DBA Data[Home] [Help]

APPS.PQP_RIW_CLASS_WRAPPER dependencies on HR_UTILITY

Line 119: --hr_utility.trace_on(null, 'Class_Trace');

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: --

Line 120: hr_utility.set_location('Entering: '|| l_proc, 11);

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

Line 148: hr_utility.set_location('The class Id is : '||l_event_id, 89);

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

Line 304: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

Line 305: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);

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');

Line 306: hr_utility.set_location('Leaving: ' || l_proc, 90);

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);

Line 307: hr_utility.raise_error;

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);

Line 309: 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);
312: hr_utility.raise_error;
313: when others then

Line 310: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_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
314: --l_error_msg := Substr(SQLERRM,1,2000);

Line 311: hr_utility.set_location('Leaving: ' || l_proc, 100);

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);

Line 312: 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);
316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

Line 315: hr_utility.set_location('SQLCODE :' || SQLCODE,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);

Line 316: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

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;

Line 317: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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:

Line 318: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );

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:

Line 319: hr_utility.set_location(' Leaving:' || l_proc,50);

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:

Line 320: hr_utility.raise_error;

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;