exec @ret = mydb.dbo.usp_procedure @arg1='foo'
if @ret =  -1
     RAISERROR('USP_PROCEDURE FAILED BECAUSE IT WAS TIRED', 16,1) WITH LOG
if @ret = -2
     RAISERROR('USP_PROCEDURE FAILED FOR SOME OTHER REASON', 16,1)  -- not specifying WITH LOG