Implicit user Defined Exceptions

exception_error_occurred
A name to the exception error that needs to be trapped
n
An integer value denoting the exception error code

statement_1,...,statement_n

A sequence of statements

statement_11,...,statement_n

A sequence of statements
e_pet_care_log_remaining EXCEPTION
Declaring and naming the exception"

PRAGMA EXCEPTION_INIT (e_pet_care_log_remaining, -2292)

Linking the integrity constraint violation to e_pet_care_log_remaining:

WHEN e_pet_care_log_remaining THEN

Providing the error handling routine