DBA Data[Home] [Help]

APPS.OTA_EVENT_SWI dependencies on HR_UTILITY

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

90: l_event_id ota_events.event_id%TYPE;
91: -- Other variables
92: l_proc varchar2(72) := g_package ||'create_event';
93: Begin
94: hr_utility.set_location(' Entering:' || l_proc,10);
95: --
96: -- Issue a savepoint
97: --
98: savepoint create_event_swi;

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

212: -- messages of any type exist in the Multiple Message List.
213: -- Also disable Multiple Message Detection.
214: --
215: p_return_status := hr_multi_message.get_return_status_disable;
216: hr_utility.set_location(' Leaving:' || l_proc,20);
217: --
218: exception
219: when hr_multi_message.error_message_exist then
220: --

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

228: --
229: -- p_event_id := null;
230: p_object_version_number := null;
231: p_return_status := hr_multi_message.get_return_status_disable;
232: hr_utility.set_location(' Leaving:' || l_proc, 30);
233: when others then
234: --
235: -- When Multiple Message Detection is enabled catch
236: -- any Application specific or other unexpected

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

239: -- error.
240: --
241: rollback to create_event_swi;
242: if hr_multi_message.unexpected_error_add(l_proc) then
243: hr_utility.set_location(' Leaving:' || l_proc,40);
244: raise;
245: end if;
246: --
247: -- Reset IN OUT and set OUT parameters

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

248: --
249: --p_event_id := null;
250: p_object_version_number := null;
251: p_return_status := hr_multi_message.get_return_status_disable;
252: hr_utility.set_location(' Leaving:' || l_proc,50);
253: end create_event;
254: -- ----------------------------------------------------------------------------
255: -- |-----------------------------< delete_event >-----------------------------|
256: -- ----------------------------------------------------------------------------

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

268: --
269: -- Other variables
270: l_proc varchar2(72) := g_package ||'delete_event';
271: Begin
272: hr_utility.set_location(' Entering:' || l_proc,10);
273: --
274: -- Issue a savepoint
275: --
276: savepoint delete_event_swi;

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

310: -- messages of any type exist in the Multiple Message List.
311: -- Also disable Multiple Message Detection.
312: --
313: p_return_status := hr_multi_message.get_return_status_disable;
314: hr_utility.set_location(' Leaving:' || l_proc,20);
315: --
316: exception
317: when hr_multi_message.error_message_exist then
318: --

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

324: --
325: -- Reset IN OUT parameters and set OUT parameters
326: --
327: p_return_status := hr_multi_message.get_return_status_disable;
328: hr_utility.set_location(' Leaving:' || l_proc, 30);
329: when others then
330: --
331: -- When Multiple Message Detection is enabled catch
332: -- any Application specific or other unexpected

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

335: -- error.
336: --
337: rollback to delete_event_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;
342: --
343: -- Reset IN OUT and set OUT parameters

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

342: --
343: -- Reset IN OUT and set OUT parameters
344: --
345: p_return_status := hr_multi_message.get_return_status_disable;
346: hr_utility.set_location(' Leaving:' || l_proc,50);
347: end delete_event;
348: -- ----------------------------------------------------------------------------
349: -- |-----------------------------< update_event >-----------------------------|
350: -- ----------------------------------------------------------------------------

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

430: --
431: -- Other variables
432: l_proc varchar2(72) := g_package ||'update_event';
433: Begin
434: hr_utility.set_location(' Entering:' || l_proc,10);
435: --
436: -- Issue a savepoint
437: --
438: savepoint update_event_swi;

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

540: -- messages of any type exist in the Multiple Message List.
541: -- Also disable Multiple Message Detection.
542: --
543: p_return_status := hr_multi_message.get_return_status_disable;
544: hr_utility.set_location(' Leaving:' || l_proc,20);
545: --
546: exception
547: when hr_multi_message.error_message_exist then
548: --

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

555: -- Reset IN OUT parameters and set OUT parameters
556: --
557: p_object_version_number := l_object_version_number;
558: p_return_status := hr_multi_message.get_return_status_disable;
559: hr_utility.set_location(' Leaving:' || l_proc, 30);
560: when others then
561: --
562: -- When Multiple Message Detection is enabled catch
563: -- any Application specific or other unexpected

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

566: -- error.
567: --
568: rollback to update_event_swi;
569: if hr_multi_message.unexpected_error_add(l_proc) then
570: hr_utility.set_location(' Leaving:' || l_proc,40);
571: raise;
572: end if;
573: --
574: -- Reset IN OUT and set OUT parameters

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

574: -- Reset IN OUT and set OUT parameters
575: --
576: p_object_version_number := l_object_version_number;
577: p_return_status := hr_multi_message.get_return_status_disable;
578: hr_utility.set_location(' Leaving:' || l_proc,50);
579: end update_event;
580:
581: -- ----------------------------------------------------------------------------
582: -- |-----------------------------< update_enrollment >------------------------|

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

612: p_tfl_object_version_number => l_tfl_object_version_number,
613: p_finance_line_id => l_finance_line_id
614: );
615: p_return_status := hr_multi_message.get_return_status_disable;
616: hr_utility.set_location(' Leaving:' || l_proc,20);
617:
618:
619: exception
620: when hr_multi_message.error_message_exist then

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

628: -- Reset IN OUT parameters and set OUT parameters
629: --
630:
631: p_return_status := hr_multi_message.get_return_status_disable;
632: hr_utility.set_location(' Leaving:' || l_proc, 30);
633: when others then
634: --
635: -- When Multiple Message Detection is enabled catch
636: -- any Application specific or other unexpected

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

639: -- error.
640: --
641: rollback to update_enrollment;
642: if hr_multi_message.unexpected_error_add(l_proc) then
643: hr_utility.set_location(' Leaving:' || l_proc,40);
644: raise;
645: end if;
646: --
647: -- Reset IN OUT and set OUT parameters

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

647: -- Reset IN OUT and set OUT parameters
648: --
649:
650: p_return_status := hr_multi_message.get_return_status_disable;
651: hr_utility.set_location(' Leaving:' || l_proc,50);
652: end update_enrollment;
653:
654: --
655: -- ----------------------------------------------------------------------------

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

704: l_proc varchar2(72) := g_package ||'upd2_update_event';
705:
706: --
707: begin
708: hr_utility.set_location(' Entering:' || l_proc,10);
709: --
710: -- Issue a savepoint
711: --
712: savepoint upd2_update_event;

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

723: if p_change_status = 'S' and p_event_status = 'A'
724: then
725: p_message_name := 'OTA_13557_EVT_CANCEL_TDB';
726: p_return_status := hr_multi_message.get_return_status_disable;
727: hr_utility.set_location(' Leaving:' || l_proc,20);
728: return;
729: end if;
730:
731: if p_change_status = 'S' and

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

731: if p_change_status = 'S' and
732: ota_evt_bus2.resource_booking_exists(p_event_id) then
733: p_message_name := 'OTA_13525_EVT_CANCEL_RESOURCE';
734: p_return_status := hr_multi_message.get_return_status_disable;
735: hr_utility.set_location(' Leaving:' || l_proc,20);
736: return;
737: end if;
738:
739: IF p_change_status = 'A' AND

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

739: IF p_change_status = 'A' AND
740: p_maximum_attendees <> l_maximum_attendees_old THEN
741: p_message_name := 'OTA_13699_EVT_PRICING';
742: p_return_status := hr_multi_message.get_return_status_disable;
743: hr_utility.set_location(' Leaving:' || l_proc,20);
744: return;
745: END IF;
746:
747: end if;

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

837:
838: else
839: p_message_name := 'OTA_13553_WAITLIST_EXISTS';
840: p_return_status := hr_multi_message.get_return_status_disable;
841: hr_utility.set_location(' Leaving:' || l_proc,20);
842: return;
843:
844: -- ***
845: --

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

848: --
849: end if;
850: --
851: p_return_status := hr_multi_message.get_return_status_disable;
852: hr_utility.set_location(' Leaving:' || l_proc,20);
853: exception
854: when hr_multi_message.error_message_exist then
855: --
856: -- Catch the Multiple Message List exception which

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

861: --
862: -- Reset IN OUT parameters and set OUT parameters
863: --
864: p_return_status := hr_multi_message.get_return_status_disable;
865: hr_utility.set_location(' Leaving:' || l_proc, 30);
866: when others then
867: --
868: -- When Multiple Message Detection is enabled catch
869: -- any Application specific or other unexpected

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

872: -- error.
873: --
874: rollback to upd2_update_event;
875: if hr_multi_message.unexpected_error_add(l_proc) then
876: hr_utility.set_location(' Leaving:' || l_proc,40);
877: raise;
878: end if;
879: --
880: -- Reset IN OUT and set OUT parameters

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

880: -- Reset IN OUT and set OUT parameters
881: --
882:
883: p_return_status := hr_multi_message.get_return_status_disable;
884: hr_utility.set_location(' Leaving:' || l_proc,50);
885: end upd2_update_event;
886:
887:
888: --