After calling a stored procedure from within a stored procedure, check the return value of the called procedure.
If the return value is NULL, either the stored procedure does not exist, could not be executed, or there was some other condition that kept the procedure from executing.