4465: --
4466: hr_utility.set_location('Leaving..:' || l_proc, 70);
4467: EXCEPTION
4468: WHEN hr_utility.hr_error then
4469: hr_message.provide_error;
4470: p_page_error := hr_message.last_message_app;
4471: p_page_error_msg := hr_message.get_message_text;
4472: p_page_error_num := hr_message.last_message_number;
4473: hr_utility.set_location('Leaving..:' || l_proc, 555);
4466: hr_utility.set_location('Leaving..:' || l_proc, 70);
4467: EXCEPTION
4468: WHEN hr_utility.hr_error then
4469: hr_message.provide_error;
4470: p_page_error := hr_message.last_message_app;
4471: p_page_error_msg := hr_message.get_message_text;
4472: p_page_error_num := hr_message.last_message_number;
4473: hr_utility.set_location('Leaving..:' || l_proc, 555);
4474: WHEN OTHERS THEN
4467: EXCEPTION
4468: WHEN hr_utility.hr_error then
4469: hr_message.provide_error;
4470: p_page_error := hr_message.last_message_app;
4471: p_page_error_msg := hr_message.get_message_text;
4472: p_page_error_num := hr_message.last_message_number;
4473: hr_utility.set_location('Leaving..:' || l_proc, 555);
4474: WHEN OTHERS THEN
4475: hr_utility.trace('Exception HR_LOA_SS..process_save:: ' || SQLERRM );
4468: WHEN hr_utility.hr_error then
4469: hr_message.provide_error;
4470: p_page_error := hr_message.last_message_app;
4471: p_page_error_msg := hr_message.get_message_text;
4472: p_page_error_num := hr_message.last_message_number;
4473: hr_utility.set_location('Leaving..:' || l_proc, 555);
4474: WHEN OTHERS THEN
4475: hr_utility.trace('Exception HR_LOA_SS..process_save:: ' || SQLERRM );
4476: hr_utility.set_location('Leaving..:' || l_proc, 560);
5490: -- hr_utility.set_location(' Leaving:' || l_proc,105);
5491:
5492: EXCEPTION
5493: WHEN hr_utility.hr_error then
5494: hr_message.provide_error;
5495: p_page_error := hr_message.last_message_app;
5496: p_page_error_msg := hr_message.get_message_text;
5497: p_page_error_num := hr_message.last_message_number;
5498: hr_utility.set_location(' Leaving:' || l_proc,555);
5491:
5492: EXCEPTION
5493: WHEN hr_utility.hr_error then
5494: hr_message.provide_error;
5495: p_page_error := hr_message.last_message_app;
5496: p_page_error_msg := hr_message.get_message_text;
5497: p_page_error_num := hr_message.last_message_number;
5498: hr_utility.set_location(' Leaving:' || l_proc,555);
5499:
5492: EXCEPTION
5493: WHEN hr_utility.hr_error then
5494: hr_message.provide_error;
5495: p_page_error := hr_message.last_message_app;
5496: p_page_error_msg := hr_message.get_message_text;
5497: p_page_error_num := hr_message.last_message_number;
5498: hr_utility.set_location(' Leaving:' || l_proc,555);
5499:
5500: WHEN g_data_error THEN
5493: WHEN hr_utility.hr_error then
5494: hr_message.provide_error;
5495: p_page_error := hr_message.last_message_app;
5496: p_page_error_msg := hr_message.get_message_text;
5497: p_page_error_num := hr_message.last_message_number;
5498: hr_utility.set_location(' Leaving:' || l_proc,555);
5499:
5500: WHEN g_data_error THEN
5501: hr_utility.trace( 'g_data_error in .process_update_save: ' || SQLERRM );
6310: EXCEPTION
6311:
6312: --4064949
6313: WHEN hr_utility.hr_error then
6314: hr_message.provide_error;
6315: p_page_error := hr_message.last_message_app;
6316: p_page_error_msg := hr_message.get_message_text;
6317: p_page_error_num := hr_message.last_message_number;
6318: hr_utility.set_location(' Leaving:' || l_proc,500);
6311:
6312: --4064949
6313: WHEN hr_utility.hr_error then
6314: hr_message.provide_error;
6315: p_page_error := hr_message.last_message_app;
6316: p_page_error_msg := hr_message.get_message_text;
6317: p_page_error_num := hr_message.last_message_number;
6318: hr_utility.set_location(' Leaving:' || l_proc,500);
6319:
6312: --4064949
6313: WHEN hr_utility.hr_error then
6314: hr_message.provide_error;
6315: p_page_error := hr_message.last_message_app;
6316: p_page_error_msg := hr_message.get_message_text;
6317: p_page_error_num := hr_message.last_message_number;
6318: hr_utility.set_location(' Leaving:' || l_proc,500);
6319:
6320: WHEN g_data_error THEN
6313: WHEN hr_utility.hr_error then
6314: hr_message.provide_error;
6315: p_page_error := hr_message.last_message_app;
6316: p_page_error_msg := hr_message.get_message_text;
6317: p_page_error_num := hr_message.last_message_number;
6318: hr_utility.set_location(' Leaving:' || l_proc,500);
6319:
6320: WHEN g_data_error THEN
6321: hr_utility.trace('g_data_error exception in .process_update_txn_save: ' || SQLERRM );
7207: --
7208: -- hr_utility.set_location('Leaving..:' || l_proc, 50);
7209: EXCEPTION
7210: WHEN hr_utility.hr_error then
7211: hr_message.provide_error;
7212: p_page_error := hr_message.last_message_app;
7213: p_page_error_msg := hr_message.get_message_text;
7214: p_page_error_num := hr_message.last_message_number;
7215: hr_utility.set_location('Leaving..:' || l_proc, 555);
7208: -- hr_utility.set_location('Leaving..:' || l_proc, 50);
7209: EXCEPTION
7210: WHEN hr_utility.hr_error then
7211: hr_message.provide_error;
7212: p_page_error := hr_message.last_message_app;
7213: p_page_error_msg := hr_message.get_message_text;
7214: p_page_error_num := hr_message.last_message_number;
7215: hr_utility.set_location('Leaving..:' || l_proc, 555);
7216: WHEN OTHERS THEN
7209: EXCEPTION
7210: WHEN hr_utility.hr_error then
7211: hr_message.provide_error;
7212: p_page_error := hr_message.last_message_app;
7213: p_page_error_msg := hr_message.get_message_text;
7214: p_page_error_num := hr_message.last_message_number;
7215: hr_utility.set_location('Leaving..:' || l_proc, 555);
7216: WHEN OTHERS THEN
7217: hr_utility.trace( ' HR_LOA_SS.process_save ' || SQLERRM );
7210: WHEN hr_utility.hr_error then
7211: hr_message.provide_error;
7212: p_page_error := hr_message.last_message_app;
7213: p_page_error_msg := hr_message.get_message_text;
7214: p_page_error_num := hr_message.last_message_number;
7215: hr_utility.set_location('Leaving..:' || l_proc, 555);
7216: WHEN OTHERS THEN
7217: hr_utility.trace( ' HR_LOA_SS.process_save ' || SQLERRM );
7218: hr_utility.set_location('Leaving..:' || l_proc, 560);