Summary: Use the tmp_directory configured in ynp config file

Test Plan: Manually tested script files are generated at the specified directory

Reviewers: nbhatia, skhilar

Reviewed By: nbhatia

Subscribers: yugaware

Differential Revision: https://phorge.dev.yugabyte.com/D40324