You can use the EXCEPTION clause to raise friendly errors for the errors you handle. If you omit the WHEN OTHERS clause, any unhandled errors will be raised at the front-end.