588: hr_utility.set_location('Leaving'|| l_proc,10);
589:
590: EXCEPTION
591: /*WHEN hr_utility.hr_error THEN
592: hr_message.provide_error;
593: lv_message_number := hr_message.last_message_number;
594: hr_errors_api.addErrorToTable(
595: p_errormsg => hr_message.get_message_text,
596: p_errorcode => lv_message_number
589:
590: EXCEPTION
591: /*WHEN hr_utility.hr_error THEN
592: hr_message.provide_error;
593: lv_message_number := hr_message.last_message_number;
594: hr_errors_api.addErrorToTable(
595: p_errormsg => hr_message.get_message_text,
596: p_errorcode => lv_message_number
597: );*/
591: /*WHEN hr_utility.hr_error THEN
592: hr_message.provide_error;
593: lv_message_number := hr_message.last_message_number;
594: hr_errors_api.addErrorToTable(
595: p_errormsg => hr_message.get_message_text,
596: p_errorcode => lv_message_number
597: );*/
598:
599: WHEN OTHERS THEN
752: hr_utility.set_location('Leaving'|| l_proc,15);
753: EXCEPTION
754: -- add api error
755: /*WHEN hr_utility.hr_error THEN
756: hr_message.provide_error;
757: lv_message_number := hr_message.last_message_number;
758: hr_errors_api.addErrorToTable(
759: p_errormsg => hr_message.get_message_text,
760: p_errorcode => lv_message_number
753: EXCEPTION
754: -- add api error
755: /*WHEN hr_utility.hr_error THEN
756: hr_message.provide_error;
757: lv_message_number := hr_message.last_message_number;
758: hr_errors_api.addErrorToTable(
759: p_errormsg => hr_message.get_message_text,
760: p_errorcode => lv_message_number
761: );*/
755: /*WHEN hr_utility.hr_error THEN
756: hr_message.provide_error;
757: lv_message_number := hr_message.last_message_number;
758: hr_errors_api.addErrorToTable(
759: p_errormsg => hr_message.get_message_text,
760: p_errorcode => lv_message_number
761: );*/
762:
763: WHEN OTHERS THEN
2164: -- an application error has been raised so we must
2165: -- redisplay the web form to display the error
2166: -- --------------------------------------------
2167: ROLLBACK TO sup_update_asg;
2168: hr_message.provide_error;
2169: p_error_message_appl := hr_message.last_message_app;
2170: p_error_message_name := hr_message.last_message_name;
2171: p_error_message := null;
2172:
2165: -- redisplay the web form to display the error
2166: -- --------------------------------------------
2167: ROLLBACK TO sup_update_asg;
2168: hr_message.provide_error;
2169: p_error_message_appl := hr_message.last_message_app;
2170: p_error_message_name := hr_message.last_message_name;
2171: p_error_message := null;
2172:
2173: WHEN OTHERS THEN
2166: -- --------------------------------------------
2167: ROLLBACK TO sup_update_asg;
2168: hr_message.provide_error;
2169: p_error_message_appl := hr_message.last_message_app;
2170: p_error_message_name := hr_message.last_message_name;
2171: p_error_message := null;
2172:
2173: WHEN OTHERS THEN
2174: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2180: IF (hr_utility.get_message IS NOT NULL) THEN
2181: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2182: hr_utility.get_message;
2183: ELSE
2184: p_error_message := hr_message.get_message_text;
2185: END IF;
2186: p_error_message_appl := null;
2187: p_error_message_name := null;
2188: ROLLBACK TO sup_update_asg;