ORA-12154: TNS:could not resolve the connect identifier specified
As Munchi pointed out the issue was caused by wrong syntax. I used:

sqlplus -L user_name/tns_alias@Password @d:\my_bat_file\sql_script.sql


Instead of:

sqlplus -L user_name/Password@tns_alias @d:\my_bat_file\sql_script.sql