Please include following code after "begin" keyword.
Code:
If @Temp_Emp_Name='' Set @Temp_Emp_Name=null
Also please remove single quote from following statement
@Temp_Emp_Name='null'
Because when your use single quote in any sql statement then sql read it as a string. null and 'null' both not same.
i think it will be worked well.