Using a User Defined Function as a constraint within a temporary table.

Your temp table cannot see the udf because it is stored in other database.

Try creating the udf in the tempdb where all temp table are stored.