115: l_obj_ver_num number(3);
116: l_object_version_number number(3);
117:
118: Begin
119: --hr_utility.trace_on(null, 'Class_Trace');
120: hr_utility.set_location('Entering: '|| l_proc, 11);
121: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
122: l_event_id := p_event_id;
123: --
116: l_object_version_number number(3);
117:
118: Begin
119: --hr_utility.trace_on(null, 'Class_Trace');
120: hr_utility.set_location('Entering: '|| l_proc, 11);
121: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
122: l_event_id := p_event_id;
123: --
124: -- Call API
144: if (P_CRT_UPD = 'U' and l_create_flag = 1) then
145: raise e_crt_not_allowed; -- Update only flag is enabled but Trying to Create
146: end if;
147:
148: hr_utility.set_location('The class Id is : '||l_event_id, 89);
149:
150: if l_create_flag = 1 then
151: ota_event_api.create_class
152: (p_effective_date => p_effective_date
300:
301: Exception
302:
303: when e_upl_not_allowed then
304: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
305: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
306: hr_utility.set_location('Leaving: ' || l_proc, 90);
307: hr_utility.raise_error;
308: when e_crt_not_allowed then
301: Exception
302:
303: when e_upl_not_allowed then
304: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
305: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
306: hr_utility.set_location('Leaving: ' || l_proc, 90);
307: hr_utility.raise_error;
308: when e_crt_not_allowed then
309: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
302:
303: when e_upl_not_allowed then
304: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
305: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
306: hr_utility.set_location('Leaving: ' || l_proc, 90);
307: hr_utility.raise_error;
308: when e_crt_not_allowed then
309: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
310: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
303: when e_upl_not_allowed then
304: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
305: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
306: hr_utility.set_location('Leaving: ' || l_proc, 90);
307: hr_utility.raise_error;
308: when e_crt_not_allowed then
309: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
310: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
311: hr_utility.set_location('Leaving: ' || l_proc, 100);
305: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
306: hr_utility.set_location('Leaving: ' || l_proc, 90);
307: hr_utility.raise_error;
308: when e_crt_not_allowed then
309: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
310: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
311: hr_utility.set_location('Leaving: ' || l_proc, 100);
312: hr_utility.raise_error;
313: when others then
306: hr_utility.set_location('Leaving: ' || l_proc, 90);
307: hr_utility.raise_error;
308: when e_crt_not_allowed then
309: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
310: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
311: hr_utility.set_location('Leaving: ' || l_proc, 100);
312: hr_utility.raise_error;
313: when others then
314: --l_error_msg := Substr(SQLERRM,1,2000);
307: hr_utility.raise_error;
308: when e_crt_not_allowed then
309: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
310: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
311: hr_utility.set_location('Leaving: ' || l_proc, 100);
312: hr_utility.raise_error;
313: when others then
314: --l_error_msg := Substr(SQLERRM,1,2000);
315: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
308: when e_crt_not_allowed then
309: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
310: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
311: hr_utility.set_location('Leaving: ' || l_proc, 100);
312: hr_utility.raise_error;
313: when others then
314: --l_error_msg := Substr(SQLERRM,1,2000);
315: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
311: hr_utility.set_location('Leaving: ' || l_proc, 100);
312: hr_utility.raise_error;
313: when others then
314: --l_error_msg := Substr(SQLERRM,1,2000);
315: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
317: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
318: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
319: hr_utility.set_location(' Leaving:' || l_proc,50);
312: hr_utility.raise_error;
313: when others then
314: --l_error_msg := Substr(SQLERRM,1,2000);
315: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
317: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
318: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
319: hr_utility.set_location(' Leaving:' || l_proc,50);
320: hr_utility.raise_error;
313: when others then
314: --l_error_msg := Substr(SQLERRM,1,2000);
315: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
317: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
318: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
319: hr_utility.set_location(' Leaving:' || l_proc,50);
320: hr_utility.raise_error;
321:
314: --l_error_msg := Substr(SQLERRM,1,2000);
315: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
317: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
318: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
319: hr_utility.set_location(' Leaving:' || l_proc,50);
320: hr_utility.raise_error;
321:
322:
315: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
317: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
318: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
319: hr_utility.set_location(' Leaving:' || l_proc,50);
320: hr_utility.raise_error;
321:
322:
323:
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
317: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
318: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
319: hr_utility.set_location(' Leaving:' || l_proc,50);
320: hr_utility.raise_error;
321:
322:
323:
324: end InsUpd_Class;