DBA Data[Home] [Help]

APPS.OTA_EVENT_SWI dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

333: -- error.
334: --
335: rollback to delete_event_swi;
336: if hr_multi_message.unexpected_error_add(l_proc) then
337: hr_utility.set_location(' Leaving:' || l_proc,40);
338: raise;
339: end if;
340: --
341: -- Reset IN OUT and set OUT parameters

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

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

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

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

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

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

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

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

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

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

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

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

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

608: p_tfl_object_version_number => l_tfl_object_version_number,
609: p_finance_line_id => l_finance_line_id
610: );
611: p_return_status := hr_multi_message.get_return_status_disable;
612: hr_utility.set_location(' Leaving:' || l_proc,20);
613:
614:
615: exception
616: when hr_multi_message.error_message_exist then

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

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

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

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

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

643: -- Reset IN OUT and set OUT parameters
644: --
645:
646: p_return_status := hr_multi_message.get_return_status_disable;
647: hr_utility.set_location(' Leaving:' || l_proc,50);
648: end update_enrollment;
649:
650: --
651: -- ----------------------------------------------------------------------------

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

700: l_proc varchar2(72) := g_package ||'upd2_update_event';
701:
702: --
703: begin
704: hr_utility.set_location(' Entering:' || l_proc,10);
705: --
706: -- Issue a savepoint
707: --
708: savepoint upd2_update_event;

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

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

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

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

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

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

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

833:
834: else
835: p_message_name := 'OTA_13553_WAITLIST_EXISTS';
836: p_return_status := hr_multi_message.get_return_status_disable;
837: hr_utility.set_location(' Leaving:' || l_proc,20);
838: return;
839:
840: -- ***
841: --

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

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

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

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

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

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

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

876: -- Reset IN OUT and set OUT parameters
877: --
878:
879: p_return_status := hr_multi_message.get_return_status_disable;
880: hr_utility.set_location(' Leaving:' || l_proc,50);
881: end upd2_update_event;
882:
883:
884: --