ON-ERROR trigger

FRM-40209: FIELD MUST BE OF FORM 999,999,999

 

    IF error_type = 'FRM' AND ERROR_CODE = 40209 THEN
        fnd_message.set_string('입력하신 기준을 다시 한번 확인하세요');
        fnd_message.error;
    END IF;