$sql .= $sth->bind_param(":IN_App_Name", $app_name);

It seems your $sth does not hold a DBI statement handle (where are you setting it?) — that's what the error message indicates.

Also, I wouldn't know what $sth->bind_param(...); would return that you could usefully concat with your $sql ...   Update: maybe you meant to concatenate code snippets to be eval'ed later:

$sql .= '$sth->bind_param(":IN_App_Name", $app_name)';
[download]

(note the single quotes) — though then, the "BEGIN CONSOLE(..." wouldn't be valid Perl code...