Currently:

In addition, our exception handler has not the exception number assigned, which is raise when the SELECT statement does not find any rows.

Should be (or something close to this):

In addition, our exception handler doesn't have an exception number assigned, which should be raised when the SELECT statement does not find any rows.