Error handling in Pl/SQL
You can define your own exceptions. If you have a package for defining business logic, you can define some exceptions in the package header then raise the proper exception when needed. Which means that you need to keep the exception numbers unique so that you can handle the exceptions from the calling procedures.

ssociating a PL/SQL Exception with a Number (EXCEPTION_INIT Pragma)