Are Stored Procedure failures logged by SQL Server?
You can't, unless the procedure has code to write to the error log, or it results in a certain severity.

Investigate using TRY...CATCH error handling.   You should be able to capture errors and then write those to the error log.