543: hr_utility.set_location('Leaving'|| l_proc,10);
544:
545: EXCEPTION
546: /*WHEN hr_utility.hr_error THEN
547: hr_message.provide_error;
548: lv_message_number := hr_message.last_message_number;
549: hr_errors_api.addErrorToTable(
550: p_errormsg => hr_message.get_message_text,
551: p_errorcode => lv_message_number
544:
545: EXCEPTION
546: /*WHEN hr_utility.hr_error THEN
547: hr_message.provide_error;
548: lv_message_number := hr_message.last_message_number;
549: hr_errors_api.addErrorToTable(
550: p_errormsg => hr_message.get_message_text,
551: p_errorcode => lv_message_number
552: );*/
546: /*WHEN hr_utility.hr_error THEN
547: hr_message.provide_error;
548: lv_message_number := hr_message.last_message_number;
549: hr_errors_api.addErrorToTable(
550: p_errormsg => hr_message.get_message_text,
551: p_errorcode => lv_message_number
552: );*/
553:
554: WHEN OTHERS THEN
707: hr_utility.set_location('Leaving'|| l_proc,15);
708: EXCEPTION
709: -- add api error
710: /*WHEN hr_utility.hr_error THEN
711: hr_message.provide_error;
712: lv_message_number := hr_message.last_message_number;
713: hr_errors_api.addErrorToTable(
714: p_errormsg => hr_message.get_message_text,
715: p_errorcode => lv_message_number
708: EXCEPTION
709: -- add api error
710: /*WHEN hr_utility.hr_error THEN
711: hr_message.provide_error;
712: lv_message_number := hr_message.last_message_number;
713: hr_errors_api.addErrorToTable(
714: p_errormsg => hr_message.get_message_text,
715: p_errorcode => lv_message_number
716: );*/
710: /*WHEN hr_utility.hr_error THEN
711: hr_message.provide_error;
712: lv_message_number := hr_message.last_message_number;
713: hr_errors_api.addErrorToTable(
714: p_errormsg => hr_message.get_message_text,
715: p_errorcode => lv_message_number
716: );*/
717:
718: WHEN OTHERS THEN
2032: -- an application error has been raised so we must
2033: -- redisplay the web form to display the error
2034: -- --------------------------------------------
2035: ROLLBACK TO sup_update_asg;
2036: hr_message.provide_error;
2037: p_error_message_appl := hr_message.last_message_app;
2038: p_error_message_name := hr_message.last_message_name;
2039: p_error_message := null;
2040:
2033: -- redisplay the web form to display the error
2034: -- --------------------------------------------
2035: ROLLBACK TO sup_update_asg;
2036: hr_message.provide_error;
2037: p_error_message_appl := hr_message.last_message_app;
2038: p_error_message_name := hr_message.last_message_name;
2039: p_error_message := null;
2040:
2041: WHEN OTHERS THEN
2034: -- --------------------------------------------
2035: ROLLBACK TO sup_update_asg;
2036: hr_message.provide_error;
2037: p_error_message_appl := hr_message.last_message_app;
2038: p_error_message_name := hr_message.last_message_name;
2039: p_error_message := null;
2040:
2041: WHEN OTHERS THEN
2042: hr_utility.set_location('EXCEPTION'|| l_proc,555);
2048: IF (hr_utility.get_message IS NOT NULL) THEN
2049: p_error_message := 'ORA' || hr_utility.hr_error_number || ' '||
2050: hr_utility.get_message;
2051: ELSE
2052: p_error_message := hr_message.get_message_text;
2053: END IF;
2054: p_error_message_appl := null;
2055: p_error_message_name := null;
2056: ROLLBACK TO sup_update_asg;