The error message is below.

I understand what is causing the error in the first place, ie violation of a foregin key constraint.

The issue is that if such an error occurs...