DBA Data[Home] [Help]

APPS.OTA_TPM_SWI dependencies on HR_UTILITY

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

93: From ota_training_plans
94: Where training_plan_id = p_training_plan_id;
95:
96: BEGIN
97: hr_utility.set_location(' Entering:' || l_proc,10);
98: --
99: -- Issue a savepoint
100: --
101: SAVEPOINT create_trng_plan_member_swi;

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

272: -- messages of any type exist in the Multiple Message List.
273: -- Also disable Multiple Message Detection.
274: --
275: p_return_status := hr_multi_message.get_return_status_disable;
276: hr_utility.set_location(' Leaving:' || l_proc,20);
277: --
278: EXCEPTION
279: WHEN hr_multi_message.error_message_exist THEN
280: --

Line 291: hr_utility.set_location(' Leaving:' || l_proc, 30);

287: -- Reset IN OUT parameters and set OUT parameters
288: --
289: p_object_version_NUMBER := NULL;
290: p_return_status := hr_multi_message.get_return_status_disable;
291: hr_utility.set_location(' Leaving:' || l_proc, 30);
292:
293: WHEN others THEN
294: --
295: -- When Multiple Message Detection is enabled catch

Line 303: hr_utility.set_location(' Leaving:' || l_proc,40);

299: -- error.
300: --
301: ROLLBACK TO create_trng_plan_member_swi;
302: IF hr_multi_message.unexpected_error_add(l_proc) THEN
303: hr_utility.set_location(' Leaving:' || l_proc,40);
304: RAISE;
305: END IF;
306: --
307: -- Reset IN OUT and set OUT parameters

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

307: -- Reset IN OUT and set OUT parameters
308: --
309: p_object_version_NUMBER := NULL;
310: p_return_status := hr_multi_message.get_return_status_disable;
311: hr_utility.set_location(' Leaving:' || l_proc,50);
312: END create_training_plan_member;
313:
314:
315: -- ----------------------------------------------------------------------------

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

329: --
330: -- Other variables
331: l_proc VARCHAR2(72) := g_package ||'delete_training_plan_member';
332: BEGIN
333: hr_utility.set_location(' Entering:' || l_proc,10);
334: --
335: -- Issue a savepoint
336: --
337: SAVEPOINT delete_trng_plan_member_swi;

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

371: -- messages of any type exist in the Multiple Message List.
372: -- Also disable Multiple Message Detection.
373: --
374: p_return_status := hr_multi_message.get_return_status_disable;
375: hr_utility.set_location(' Leaving:' || l_proc,20);
376: --
377: EXCEPTION
378: WHEN hr_multi_message.error_message_exist THEN
379: --

Line 389: hr_utility.set_location(' Leaving:' || l_proc, 30);

385: --
386: -- Reset IN OUT parameters and set OUT parameters
387: --
388: p_return_status := hr_multi_message.get_return_status_disable;
389: hr_utility.set_location(' Leaving:' || l_proc, 30);
390: WHEN others THEN
391: --
392: -- When Multiple Message Detection is enabled catch
393: -- any Application specific or other unexpected

Line 400: hr_utility.set_location(' Leaving:' || l_proc,40);

396: -- error.
397: --
398: ROLLBACK TO delete_trng_plan_member_swi;
399: IF hr_multi_message.unexpected_error_add(l_proc) THEN
400: hr_utility.set_location(' Leaving:' || l_proc,40);
401: RAISE;
402: END IF;
403: --
404: -- Reset IN OUT and set OUT parameters

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

403: --
404: -- Reset IN OUT and set OUT parameters
405: --
406: p_return_status := hr_multi_message.get_return_status_disable;
407: hr_utility.set_location(' Leaving:' || l_proc,50);
408: END delete_training_plan_member;
409: -- ----------------------------------------------------------------------------
410: -- |----------------------< update_training_plan_member >---------------------|
411: -- ----------------------------------------------------------------------------

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

467: -- Other variables
468: l_proc VARCHAR2(72) := g_package ||'update_training_plan_member';
469:
470: BEGIN
471: hr_utility.set_location(' Entering:' || l_proc,10);
472: --
473: -- Issue a savepoint
474: --
475: SAVEPOINT update_trng_plan_member_swi;

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

552: -- messages of any type exist in the Multiple Message List.
553: -- Also disable Multiple Message Detection.
554: --
555: p_return_status := hr_multi_message.get_return_status_disable;
556: hr_utility.set_location(' Leaving:' || l_proc,20);
557: --
558: EXCEPTION
559: WHEN hr_multi_message.error_message_exist THEN
560: --

Line 571: hr_utility.set_location(' Leaving:' || l_proc, 30);

567: -- Reset IN OUT parameters and set OUT parameters
568: --
569: p_object_version_NUMBER := l_object_version_number;
570: p_return_status := hr_multi_message.get_return_status_disable;
571: hr_utility.set_location(' Leaving:' || l_proc, 30);
572: WHEN others THEN
573: --
574: -- When Multiple Message Detection is enabled catch
575: -- any Application specific or other unexpected

Line 582: hr_utility.set_location(' Leaving:' || l_proc,40);

578: -- error.
579: --
580: ROLLBACK TO update_trng_plan_member_swi;
581: IF hr_multi_message.unexpected_error_add(l_proc) THEN
582: hr_utility.set_location(' Leaving:' || l_proc,40);
583: RAISE;
584: END IF;
585: --
586: -- Reset IN OUT and set OUT parameters

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

586: -- Reset IN OUT and set OUT parameters
587: --
588: p_object_version_NUMBER := l_object_version_number;
589: p_return_status := hr_multi_message.get_return_status_disable;
590: hr_utility.set_location(' Leaving:' || l_proc,50);
591: END update_training_plan_member;
592: END ota_tpm_swi;