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.3 2007/12/14 11:13:30 uuddavol noship $ */
3: --
4: -- Package variables
5: --

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

2: /* $Header: pebkgswi.pkb 120.3 2007/12/14 11:13:30 uuddavol noship $ */
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 191: savepoint update_per_bookings_swi;

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

Line 251: rollback to update_per_bookings_swi;

247: -- Catch the Multiple Message List exception which
248: -- indicates API processing has been aborted because
249: -- at least one message exists in the list.
250: --
251: rollback to update_per_bookings_swi;
252: --
253: -- Reset IN OUT parameters and set OUT parameters
254: --
255: p_return_status := hr_multi_message.get_return_status_disable;

Line 265: rollback to update_per_bookings_swi;

261: -- exceptions. Adding appropriate details to the
262: -- Multiple Message List. Otherwise re-raise the
263: -- error.
264: --
265: rollback to update_per_bookings_swi;
266: if hr_multi_message.unexpected_error_add(l_proc) then
267: hr_utility.set_location(' Leaving:' || l_proc,40);
268: raise;
269: end if;

Line 292: savepoint delete_per_bookings_swi;

288: hr_utility.set_location(' Entering:' || l_proc,10);
289: --
290: -- Issue a savepoint
291: --
292: savepoint delete_per_bookings_swi;
293: --
294: -- Initialise Multiple Message Detection
295: --
296: hr_multi_message.enable_message_list;

Line 323: rollback to delete_per_bookings_swi;

319: -- Catch the Multiple Message List exception which
320: -- indicates API processing has been aborted because
321: -- at least one message exists in the list.
322: --
323: rollback to delete_per_bookings_swi;
324: --
325: -- Reset IN OUT parameters and set OUT parameters
326: --
327: p_return_status := hr_multi_message.get_return_status_disable;

Line 337: rollback to delete_per_bookings_swi;

333: -- exceptions. Adding appropriate details to the
334: -- Multiple Message List. Otherwise re-raise the
335: -- error.
336: --
337: rollback to delete_per_bookings_swi;
338: if hr_multi_message.unexpected_error_add(l_proc) then
339: hr_utility.set_location(' Leaving:' || l_proc,40);
340: raise;
341: end if;

Line 350: end PER_BOOKINGS_SWI;

346: hr_utility.set_location(' Leaving:' || l_proc,50);
347: end delete_per_bookings;
348:
349: --
350: end PER_BOOKINGS_SWI;