eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PQP_RIW_COURSE_WRAPPER dependencies on HR_UTILITY

Line 136: --hr_utility.trace_on(null, 'Course_Trace');

132: l_object_version_number number(2);
133:
134:
135: Begin
136: --hr_utility.trace_on(null, 'Course_Trace');
137: hr_utility.set_location(' Entering:' || l_proc,10);
138: --
139: -- Issue a savepoint
140: --

Line 137: hr_utility.set_location(' Entering:' || l_proc,10);

133:
134:
135: Begin
136: --hr_utility.trace_on(null, 'Course_Trace');
137: hr_utility.set_location(' Entering:' || l_proc,10);
138: --
139: -- Issue a savepoint
140: --
141: savepoint pqp_riw_course_wrapper;

Line 158: hr_utility.set_location('The version id is : '||l_activity_version_id, 89);

154: --
155: -- Call API
156: --
157: l_activity_version_id := p_activity_version_id;
158: hr_utility.set_location('The version id is : '||l_activity_version_id, 89);
159: if l_activity_version_id is not null then
160: l_create_flag := 2; --update course
161: else
162: l_create_flag := 1; --create course

Line 235: hr_utility.set_location('The code has created success', 90);

231: ,p_data_source => p_data_source
232: ,p_competency_update_level => p_competency_update_level
233: );
234:
235: hr_utility.set_location('The code has created success', 90);
236: Open C_Sel_one;
237: Fetch C_Sel_one into l_category_usage_id;
238: Close C_Sel_one;
239: hr_utility.set_location('After that success as well', 90);

Line 239: hr_utility.set_location('After that success as well', 90);

235: hr_utility.set_location('The code has created success', 90);
236: Open C_Sel_one;
237: Fetch C_Sel_one into l_category_usage_id;
238: Close C_Sel_one;
239: hr_utility.set_location('After that success as well', 90);
240:
241:
242:
243: ota_activity_category_api.create_act_cat_inclusion

Line 279: hr_utility.set_location('Inside the update', 90);

275: );
276: end if;
277:
278: if l_create_flag = 2 then
279: hr_utility.set_location('Inside the update', 90);
280:
281: select object_version_number into l_object_version_number from
282: ota_activity_versions where activity_version_id = l_activity_version_id;
283:

Line 349: hr_utility.set_location(' Leaving:' || l_proc,20);

345: end if;
346:
347:
348:
349: hr_utility.set_location(' Leaving:' || l_proc,20);
350:
351: exception
352:
353: when e_upl_not_allowed then

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

350:
351: exception
352:
353: when e_upl_not_allowed then
354: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
355: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
356: hr_utility.set_location('Leaving: ' || l_proc, 90);
357: hr_utility.raise_error;
358: when e_crt_not_allowed then

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

351: exception
352:
353: when e_upl_not_allowed then
354: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
355: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
356: hr_utility.set_location('Leaving: ' || l_proc, 90);
357: hr_utility.raise_error;
358: when e_crt_not_allowed then
359: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');

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

352:
353: when e_upl_not_allowed then
354: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
355: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
356: hr_utility.set_location('Leaving: ' || l_proc, 90);
357: hr_utility.raise_error;
358: when e_crt_not_allowed then
359: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
360: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

Line 357: hr_utility.raise_error;

353: when e_upl_not_allowed then
354: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
355: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
356: hr_utility.set_location('Leaving: ' || l_proc, 90);
357: hr_utility.raise_error;
358: when e_crt_not_allowed then
359: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
360: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
361: hr_utility.set_location('Leaving: ' || l_proc, 100);

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

355: hr_utility.set_message_token('GENERIC_TOKEN',g_upl_err_msg);
356: hr_utility.set_location('Leaving: ' || l_proc, 90);
357: hr_utility.raise_error;
358: when e_crt_not_allowed then
359: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
360: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
361: hr_utility.set_location('Leaving: ' || l_proc, 100);
362: hr_utility.raise_error;
363: when others then

Line 360: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);

356: hr_utility.set_location('Leaving: ' || l_proc, 90);
357: hr_utility.raise_error;
358: when e_crt_not_allowed then
359: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
360: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
361: hr_utility.set_location('Leaving: ' || l_proc, 100);
362: hr_utility.raise_error;
363: when others then
364: --l_error_msg := Substr(SQLERRM,1,2000);

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

357: hr_utility.raise_error;
358: when e_crt_not_allowed then
359: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
360: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
361: hr_utility.set_location('Leaving: ' || l_proc, 100);
362: hr_utility.raise_error;
363: when others then
364: --l_error_msg := Substr(SQLERRM,1,2000);
365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

Line 362: hr_utility.raise_error;

358: when e_crt_not_allowed then
359: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
360: hr_utility.set_message_token('GENERIC_TOKEN',g_crt_err_msg);
361: hr_utility.set_location('Leaving: ' || l_proc, 100);
362: hr_utility.raise_error;
363: when others then
364: --l_error_msg := Substr(SQLERRM,1,2000);
365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
366: hr_utility.set_location('SQLERRM :' || SQLERRM,90);

Line 365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);

361: hr_utility.set_location('Leaving: ' || l_proc, 100);
362: hr_utility.raise_error;
363: when others then
364: --l_error_msg := Substr(SQLERRM,1,2000);
365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
366: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
367: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
368: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
369: hr_utility.set_location(' Leaving:' || l_proc,50);

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

362: hr_utility.raise_error;
363: when others then
364: --l_error_msg := Substr(SQLERRM,1,2000);
365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
366: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
367: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
368: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
369: hr_utility.set_location(' Leaving:' || l_proc,50);
370: hr_utility.raise_error;

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

363: when others then
364: --l_error_msg := Substr(SQLERRM,1,2000);
365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
366: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
367: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
368: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
369: hr_utility.set_location(' Leaving:' || l_proc,50);
370: hr_utility.raise_error;
371:

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

364: --l_error_msg := Substr(SQLERRM,1,2000);
365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
366: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
367: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
368: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
369: hr_utility.set_location(' Leaving:' || l_proc,50);
370: hr_utility.raise_error;
371:
372: end InsUpd_Course;

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

365: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
366: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
367: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
368: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
369: hr_utility.set_location(' Leaving:' || l_proc,50);
370: hr_utility.raise_error;
371:
372: end InsUpd_Course;
373: end pqp_riw_course_wrapper;

Line 370: hr_utility.raise_error;

366: hr_utility.set_location('SQLERRM :' || SQLERRM,90);
367: --hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
368: --hr_utility.set_message_token('GENERIC_TOKEN',substr(l_error_msg,1,500) );
369: hr_utility.set_location(' Leaving:' || l_proc,50);
370: hr_utility.raise_error;
371:
372: end InsUpd_Course;
373: end pqp_riw_course_wrapper;