DBA Data[Home] [Help]

APPS.HR_PHONE_SWI dependencies on HR_UTILITY

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

65: --
66: -- Other variables
67: l_proc varchar2(72) := g_package ||'create_or_update_phone';
68: Begin
69: hr_utility.set_location(' Entering:' || l_proc,10);
70: --
71: -- Issue a savepoint
72: --
73: savepoint create_or_update_phone_swi;

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

150: -- messages of any type exist in the Multiple Message List.
151: -- Also disable Multiple Message Detection.
152: --
153: p_return_status := hr_multi_message.get_return_status_disable;
154: hr_utility.set_location(' Leaving:' || l_proc,20);
155: --
156: exception
157: when hr_multi_message.error_message_exist then
158: --

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

166: --
167: p_phone_id := l_phone_id;
168: p_object_version_number := l_object_version_number;
169: p_return_status := hr_multi_message.get_return_status_disable;
170: hr_utility.set_location(' Leaving:' || l_proc,30);
171: when others then
172: --
173: -- When Multiple Message Detection is enabled catch
174: -- any Application specific or other unexpected

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

177: -- the error.
178: --
179: rollback to create_or_update_phone_swi;
180: if hr_multi_message.unexpected_error_add(l_proc) then
181: hr_utility.set_location(' Leaving:' || l_proc, 40);
182: raise;
183: end if;
184: --
185: -- Reset IN OUT parameters and set OUT parameters

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

186: --
187: p_phone_id := l_phone_id;
188: p_object_version_number := l_object_version_number;
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving: ' || l_proc, 50);
191: end create_or_update_phone;
192: -- ----------------------------------------------------------------------------
193: -- |-----------------------------< create_phone >-----------------------------|
194: -- ----------------------------------------------------------------------------

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

247: -- Other variables
248: l_phone_id number;
249: l_proc varchar2(72) := g_package ||'create_phone';
250: Begin
251: hr_utility.set_location(' Entering:' || l_proc,10);
252: --
253: -- Issue a savepoint
254: --
255: savepoint create_phone_swi;

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

332: -- messages of any type exist in the Multiple Message List.
333: -- Also disable Multiple Message Detection.
334: --
335: p_return_status := hr_multi_message.get_return_status_disable;
336: hr_utility.set_location(' Leaving:' || l_proc,20);
337: --
338: exception
339: when hr_multi_message.error_message_exist then
340: --

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

347: -- Reset IN OUT paramters and set OUT parameters
348: --
349: p_object_version_number := null;
350: p_return_status := hr_multi_message.get_return_status_disable;
351: hr_utility.set_location(' Leaving:' || l_proc,30);
352: when others then
353: --
354: -- When Multiple Message Detection is enabled catch
355: -- any Application specific or other unexpected

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

358: -- the error.
359: --
360: rollback to create_phone_swi;
361: if hr_multi_message.unexpected_error_add(l_proc) then
362: hr_utility.set_location(' Leaving:' || l_proc, 40);
363: raise;
364: end if;
365: --
366: -- Reset IN OUT parameters and set OUT parameters

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

366: -- Reset IN OUT parameters and set OUT parameters
367: --
368: p_object_version_number := null;
369: p_return_status := hr_multi_message.get_return_status_disable;
370: hr_utility.set_location(' Leaving: ' || l_proc, 50);
371: end create_phone;
372: -- ----------------------------------------------------------------------------
373: -- |-----------------------------< delete_phone >-----------------------------|
374: -- ----------------------------------------------------------------------------

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

386: --
387: -- Other variables
388: l_proc varchar2(72) := g_package ||'delete_phone';
389: Begin
390: hr_utility.set_location(' Entering:' || l_proc,10);
391: --
392: -- Issue a savepoint
393: --
394: savepoint delete_phone_swi;

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

428: -- messages of any type exist in the Multiple Message List.
429: -- Also disable Multiple Message Detection.
430: --
431: p_return_status := hr_multi_message.get_return_status_disable;
432: hr_utility.set_location(' Leaving:' || l_proc,20);
433: --
434: exception
435: when hr_multi_message.error_message_exist then
436: --

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

442: --
443: -- Reset IN OUT paramters and set OUT parameters
444: --
445: p_return_status := hr_multi_message.get_return_status_disable;
446: hr_utility.set_location(' Leaving:' || l_proc,30);
447: when others then
448: --
449: -- When Multiple Message Detection is enabled catch
450: -- any Application specific or other unexpected

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

453: -- the error.
454: --
455: rollback to delete_phone_swi;
456: if hr_multi_message.unexpected_error_add(l_proc) then
457: hr_utility.set_location(' Leaving:' || l_proc, 40);
458: raise;
459: end if;
460: --
461: -- Reset IN OUT parameters and set OUT parameters

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

460: --
461: -- Reset IN OUT parameters and set OUT parameters
462: --
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving: ' || l_proc, 50);
465: end delete_phone;
466: -- ----------------------------------------------------------------------------
467: -- |-----------------------------< update_phone >-----------------------------|
468: -- ----------------------------------------------------------------------------

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

519: --
520: -- Other variables
521: l_proc varchar2(72) := g_package ||'update_phone';
522: Begin
523: hr_utility.set_location(' Entering:' || l_proc,10);
524: --
525: -- Issue a savepoint
526: --
527: savepoint update_phone_swi;

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

600: -- messages of any type exist in the Multiple Message List.
601: -- Also disable Multiple Message Detection.
602: --
603: p_return_status := hr_multi_message.get_return_status_disable;
604: hr_utility.set_location(' Leaving:' || l_proc,20);
605: --
606: exception
607: when hr_multi_message.error_message_exist then
608: --

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

615: -- Reset IN OUT paramters and set OUT parameters
616: --
617: p_object_version_number := l_object_version_number;
618: p_return_status := hr_multi_message.get_return_status_disable;
619: hr_utility.set_location(' Leaving:' || l_proc,30);
620: when others then
621: --
622: -- When Multiple Message Detection is enabled catch
623: -- any Application specific or other unexpected

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

626: -- the error.
627: --
628: rollback to update_phone_swi;
629: if hr_multi_message.unexpected_error_add(l_proc) then
630: hr_utility.set_location(' Leaving:' || l_proc, 40);
631: raise;
632: end if;
633: --
634: -- Reset IN OUT parameters and set OUT parameters

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

634: -- Reset IN OUT parameters and set OUT parameters
635: --
636: p_object_version_number := l_object_version_number;
637: p_return_status := hr_multi_message.get_return_status_disable;
638: hr_utility.set_location(' Leaving: ' || l_proc, 50);
639: end update_phone;
640: end hr_phone_swi;