The problem is "@SQLID" is a parameter variable not a string, so you need to do like...
SET @SQL = 'INSERT INTO ExecutionLog (As_of_date, Exe_module, SqlId,TimeFrom)
VALUES (dbo.GetParameters(1012), '+ @Exe_module +', '+ @SQLID +', GETDATE())';
I have also added the
@Exe_module, which I guess you have forgot and written like
Exe_module and that is incorrect. It is also one parameter, which you should use in this query.
Thanks...