Love the script!

The only issue is that you assume people already have the usp_LogError and usp_ReportError stored procedures you reference in your catch section. Therefore, you should reference those...