DBA Data[Home] [Help]

APPS.PER_BOOKINGS_SWI dependencies on PER_BOOKINGS_SWI

Line 1: PACKAGE BODY PER_BOOKINGS_SWI As

1: PACKAGE BODY PER_BOOKINGS_SWI As
2: /* $Header: pebkgswi.pkb 120.6 2010/08/19 12:01:51 kgowripe ship $ */
3: --
4: -- Package variables
5: --

Line 6: g_package varchar2(33) := 'per_bookings_swi.';

2: /* $Header: pebkgswi.pkb 120.6 2010/08/19 12:01:51 kgowripe ship $ */
3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'per_bookings_swi.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_per_booking >---------------------------|
10: -- ----------------------------------------------------------------------------

Line 58: savepoint create_per_bookings_swi;

54: hr_utility.set_location(' Entering:' || l_proc,10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_per_bookings_swi;
59: --
60: -- Initialise Multiple Message Detection
61: --
62: hr_multi_message.enable_message_list;

Line 109: rollback to create_per_bookings_swi;

105: -- Catch the Multiple Message List exception which
106: -- indicates API processing has been aborted because
107: -- at least one message exists in the list.
108: --
109: rollback to create_per_bookings_swi;
110: --
111: -- Reset IN OUT parameters and set OUT parameters
112: --
113: p_return_status := hr_multi_message.get_return_status_disable;

Line 123: rollback to create_per_bookings_swi;

119: -- exceptions. Adding appropriate details to the
120: -- Multiple Message List. Otherwise re-raise the
121: -- error.
122: --
123: rollback to create_per_bookings_swi;
124: if hr_multi_message.unexpected_error_add(l_proc) then
125: hr_utility.set_location(' Leaving:' || l_proc,40);
126: raise;
127: end if;

Line 193: savepoint update_per_bookings_swi;

189: hr_utility.set_location(' Entering:' || l_proc,10);
190: --
191: -- Issue a savepoint
192: --
193: savepoint update_per_bookings_swi;
194: --
195: -- Initialise Multiple Message Detection
196: --
197: hr_multi_message.enable_message_list;

Line 369: rollback to update_per_bookings_swi;

365: -- Catch the Multiple Message List exception which
366: -- indicates API processing has been aborted because
367: -- at least one message exists in the list.
368: --
369: rollback to update_per_bookings_swi;
370: --
371: -- Reset IN OUT parameters and set OUT parameters
372: --
373: p_return_status := hr_multi_message.get_return_status_disable;

Line 383: rollback to update_per_bookings_swi;

379: -- exceptions. Adding appropriate details to the
380: -- Multiple Message List. Otherwise re-raise the
381: -- error.
382: --
383: rollback to update_per_bookings_swi;
384: if hr_multi_message.unexpected_error_add(l_proc) then
385: hr_utility.set_location(' Leaving:' || l_proc,40);
386: raise;
387: end if;

Line 410: savepoint delete_per_bookings_swi;

406: hr_utility.set_location(' Entering:' || l_proc,10);
407: --
408: -- Issue a savepoint
409: --
410: savepoint delete_per_bookings_swi;
411: --
412: -- Initialise Multiple Message Detection
413: --
414: hr_multi_message.enable_message_list;

Line 441: rollback to delete_per_bookings_swi;

437: -- Catch the Multiple Message List exception which
438: -- indicates API processing has been aborted because
439: -- at least one message exists in the list.
440: --
441: rollback to delete_per_bookings_swi;
442: --
443: -- Reset IN OUT parameters and set OUT parameters
444: --
445: p_return_status := hr_multi_message.get_return_status_disable;

Line 455: rollback to delete_per_bookings_swi;

451: -- exceptions. Adding appropriate details to the
452: -- Multiple Message List. Otherwise re-raise the
453: -- error.
454: --
455: rollback to delete_per_bookings_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;

Line 468: end PER_BOOKINGS_SWI;

464: hr_utility.set_location(' Leaving:' || l_proc,50);
465: end delete_per_bookings;
466:
467: --
468: end PER_BOOKINGS_SWI;