DBA Data[Home] [Help]

APPS.OTA_BOOKING_STATUS_TYPE_SWI dependencies on HR_UTILITY

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

54: -- Other variables
55: l_booking_status_type_id number;
56: l_proc varchar2(72) := g_package ||'create_booking_status_type';
57: Begin
58: hr_utility.set_location(' Entering:' || l_proc,10);
59: --
60: -- Issue a savepoint
61: --
62: savepoint create_booking_status_type_swi;

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

130: -- messages of any type exist in the Multiple Message List.
131: -- Also disable Multiple Message Detection.
132: --
133: p_return_status := hr_multi_message.get_return_status_disable;
134: hr_utility.set_location(' Leaving:' || l_proc,20);
135: --
136: exception
137: when hr_multi_message.error_message_exist then
138: --

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

145: -- Reset IN OUT parameters and set OUT parameters
146: --
147: p_object_version_number := null;
148: p_return_status := hr_multi_message.get_return_status_disable;
149: hr_utility.set_location(' Leaving:' || l_proc, 30);
150: when others then
151: --
152: -- When Multiple Message Detection is enabled catch
153: -- any Application specific or other unexpected

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

156: -- error.
157: --
158: rollback to create_booking_status_type_swi;
159: if hr_multi_message.unexpected_error_add(l_proc) then
160: hr_utility.set_location(' Leaving:' || l_proc,40);
161: raise;
162: end if;
163: --
164: -- Reset IN OUT and set OUT parameters

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

164: -- Reset IN OUT and set OUT parameters
165: --
166: p_object_version_number := null;
167: p_return_status := hr_multi_message.get_return_status_disable;
168: hr_utility.set_location(' Leaving:' || l_proc,50);
169: end create_booking_status_type;
170: -- ----------------------------------------------------------------------------
171: -- |----------------------< update_booking_status_type >----------------------|
172: -- ----------------------------------------------------------------------------

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

216: --
217: -- Other variables
218: l_proc varchar2(72) := g_package ||'update_booking_status_type';
219: Begin
220: hr_utility.set_location(' Entering:' || l_proc,10);
221: --
222: -- Issue a savepoint
223: --
224: savepoint update_booking_status_type_swi;

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

290: -- messages of any type exist in the Multiple Message List.
291: -- Also disable Multiple Message Detection.
292: --
293: p_return_status := hr_multi_message.get_return_status_disable;
294: hr_utility.set_location(' Leaving:' || l_proc,20);
295: --
296: exception
297: when hr_multi_message.error_message_exist then
298: --

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

305: -- Reset IN OUT parameters and set OUT parameters
306: --
307: p_object_version_number := l_object_version_number;
308: p_return_status := hr_multi_message.get_return_status_disable;
309: hr_utility.set_location(' Leaving:' || l_proc, 30);
310: when others then
311: --
312: -- When Multiple Message Detection is enabled catch
313: -- any Application specific or other unexpected

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

316: -- error.
317: --
318: rollback to update_booking_status_type_swi;
319: if hr_multi_message.unexpected_error_add(l_proc) then
320: hr_utility.set_location(' Leaving:' || l_proc,40);
321: raise;
322: end if;
323: --
324: -- Reset IN OUT and set OUT parameters

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

324: -- Reset IN OUT and set OUT parameters
325: --
326: p_object_version_number := l_object_version_number;
327: p_return_status := hr_multi_message.get_return_status_disable;
328: hr_utility.set_location(' Leaving:' || l_proc,50);
329: end update_booking_status_type;
330: -- ----------------------------------------------------------------------------
331: -- |----------------------< delete_booking_status_type >----------------------|
332: -- ----------------------------------------------------------------------------

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

344: --
345: -- Other variables
346: l_proc varchar2(72) := g_package ||'delete_booking_status_type';
347: Begin
348: hr_utility.set_location(' Entering:' || l_proc,10);
349: --
350: -- Issue a savepoint
351: --
352: savepoint delete_booking_status_type_swi;

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

386: -- messages of any type exist in the Multiple Message List.
387: -- Also disable Multiple Message Detection.
388: --
389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then
394: --

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

400: --
401: -- Reset IN OUT parameters and set OUT parameters
402: --
403: p_return_status := hr_multi_message.get_return_status_disable;
404: hr_utility.set_location(' Leaving:' || l_proc, 30);
405: when others then
406: --
407: -- When Multiple Message Detection is enabled catch
408: -- any Application specific or other unexpected

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

411: -- error.
412: --
413: rollback to delete_booking_status_type_swi;
414: if hr_multi_message.unexpected_error_add(l_proc) then
415: hr_utility.set_location(' Leaving:' || l_proc,40);
416: raise;
417: end if;
418: --
419: -- Reset IN OUT and set OUT parameters

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

418: --
419: -- Reset IN OUT and set OUT parameters
420: --
421: p_return_status := hr_multi_message.get_return_status_disable;
422: hr_utility.set_location(' Leaving:' || l_proc,50);
423: end delete_booking_status_type;
424: end ota_booking_status_type_swi;