oracle pl/sql error hanbling
In Pl/SQL
IF (err_condition) THEN
Fnd_message.set_name(appl_short_name,message_name);
Fnd_message.error;
RAISE form_trigger_failure;
END IF:
In stroe-lcx
IF (err_condition) THEN
Fnd_message.set_name(appl_short_name,message_name);
App_exception.raise_exception;
END IF;