5912: end if;
5913:
5914: EXCEPTION
5915: when hr_utility.hr_error then
5916: hr_message.provide_error;
5917: p_page_error := hr_message.last_message_app;
5918: --p_page_error_msg := hr_message.last_message_name;
5919: p_page_error_msg := hr_message.get_message_text;
5920: -- If its registration then roll back the dummy person
5913:
5914: EXCEPTION
5915: when hr_utility.hr_error then
5916: hr_message.provide_error;
5917: p_page_error := hr_message.last_message_app;
5918: --p_page_error_msg := hr_message.last_message_name;
5919: p_page_error_msg := hr_message.get_message_text;
5920: -- If its registration then roll back the dummy person
5921: if(g_registration) then
5914: EXCEPTION
5915: when hr_utility.hr_error then
5916: hr_message.provide_error;
5917: p_page_error := hr_message.last_message_app;
5918: --p_page_error_msg := hr_message.last_message_name;
5919: p_page_error_msg := hr_message.get_message_text;
5920: -- If its registration then roll back the dummy person
5921: if(g_registration) then
5922: rollback;
5915: when hr_utility.hr_error then
5916: hr_message.provide_error;
5917: p_page_error := hr_message.last_message_app;
5918: --p_page_error_msg := hr_message.last_message_name;
5919: p_page_error_msg := hr_message.get_message_text;
5920: -- If its registration then roll back the dummy person
5921: if(g_registration) then
5922: rollback;
5923: -- set it back to false to avoid global variable problems with SS connection pooling
7773: hr_utility.set_location('Exception:Others'||l_proc,555);
7774: rollback to validate_assignment;
7775: --hr_utility.raise_error;
7776: raise;
7777: --hr_message.provide_error;
7778: --Should add page level error
7779: /*hr_errors_api.addErrorToTable
7780: (p_errorfield => null
7781: ,p_errorcode => hr_message.last_message_number
7777: --hr_message.provide_error;
7778: --Should add page level error
7779: /*hr_errors_api.addErrorToTable
7780: (p_errorfield => null
7781: ,p_errorcode => hr_message.last_message_number
7782: ,p_errormsg => hr_message.get_message_text);*/
7783: end update_assignment;
7784:
7785: --
7778: --Should add page level error
7779: /*hr_errors_api.addErrorToTable
7780: (p_errorfield => null
7781: ,p_errorcode => hr_message.last_message_number
7782: ,p_errormsg => hr_message.get_message_text);*/
7783: end update_assignment;
7784:
7785: --
7786: FUNCTION get_assignment(p_transaction_step_id in number)