DBA Data[Home] [Help]

APPS.OTA_EVENT_SWI dependencies on HR_MULTI_MESSAGE

Line 102: hr_multi_message.enable_message_list;

98: savepoint create_event_swi;
99: --
100: -- Initialise Multiple Message Detection
101: --
102: hr_multi_message.enable_message_list;
103: --
104: -- Remember IN OUT parameter IN values
105: --
106: --

Line 215: p_return_status := hr_multi_message.get_return_status_disable;

211: -- Derive the API return status value based on whether
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

Line 219: when hr_multi_message.error_message_exist then

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: --
221: -- Catch the Multiple Message List exception which
222: -- indicates API processing has been aborted because
223: -- at least one message exists in the list.

Line 231: p_return_status := hr_multi_message.get_return_status_disable;

227: -- Reset IN OUT parameters and set OUT parameters
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

Line 242: if hr_multi_message.unexpected_error_add(l_proc) then

238: -- Multiple Message List. Otherwise re-raise the
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: --

Line 251: p_return_status := hr_multi_message.get_return_status_disable;

247: -- Reset IN OUT and set OUT parameters
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 >-----------------------------|

Line 280: hr_multi_message.enable_message_list;

276: savepoint delete_event_swi;
277: --
278: -- Initialise Multiple Message Detection
279: --
280: hr_multi_message.enable_message_list;
281: --
282: -- Remember IN OUT parameter IN values
283: --
284: --

Line 313: p_return_status := hr_multi_message.get_return_status_disable;

309: -- Derive the API return status value based on whether
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

Line 317: when hr_multi_message.error_message_exist then

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: --
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.

Line 327: p_return_status := hr_multi_message.get_return_status_disable;

323: rollback to delete_event_swi;
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

Line 338: if hr_multi_message.unexpected_error_add(l_proc) then

334: -- Multiple Message List. Otherwise re-raise the
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: --

Line 345: p_return_status := hr_multi_message.get_return_status_disable;

341: end if;
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 >-----------------------------|

Line 442: hr_multi_message.enable_message_list;

438: savepoint update_event_swi;
439: --
440: -- Initialise Multiple Message Detection
441: --
442: hr_multi_message.enable_message_list;
443: --
444: -- Remember IN OUT parameter IN values
445: --
446: l_object_version_number := p_object_version_number;

Line 543: p_return_status := hr_multi_message.get_return_status_disable;

539: -- Derive the API return status value based on whether
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

Line 547: when hr_multi_message.error_message_exist then

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: --
549: -- Catch the Multiple Message List exception which
550: -- indicates API processing has been aborted because
551: -- at least one message exists in the list.

Line 558: p_return_status := hr_multi_message.get_return_status_disable;

554: --
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

Line 569: if hr_multi_message.unexpected_error_add(l_proc) then

565: -- Multiple Message List. Otherwise re-raise the
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: --

Line 577: p_return_status := hr_multi_message.get_return_status_disable;

573: --
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: -- ----------------------------------------------------------------------------

Line 601: hr_multi_message.enable_message_list;

597: l_finance_line_id number;
598: begin
599: savepoint update_enrollment;
600: --
601: hr_multi_message.enable_message_list;
602: l_object_version_number := p_object_version_number ;
603: ota_tdb_api_upd2.update_enrollment
604: (
605: p_booking_id => p_booking_id,

Line 615: p_return_status := hr_multi_message.get_return_status_disable;

611: p_object_version_number => l_object_version_number,
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

Line 620: when hr_multi_message.error_message_exist then

616: hr_utility.set_location(' Leaving:' || l_proc,20);
617:
618:
619: exception
620: when hr_multi_message.error_message_exist then
621: --
622: -- Catch the Multiple Message List exception which
623: -- indicates API processing has been aborted because
624: -- at least one message exists in the list.

Line 631: p_return_status := hr_multi_message.get_return_status_disable;

627: --
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

Line 642: if hr_multi_message.unexpected_error_add(l_proc) then

638: -- Multiple Message List. Otherwise re-raise the
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: --

Line 650: p_return_status := hr_multi_message.get_return_status_disable;

646: --
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: --

Line 716: hr_multi_message.enable_message_list;

712: savepoint upd2_update_event;
713: --
714: -- Initialise Multiple Message Detection
715: --
716: hr_multi_message.enable_message_list;
717:
718: OPEN c_event_date(p_event_id);
719: FETCH c_event_date into l_event_date,l_event_type,l_event_title,l_owner_id,l_maximum_attendees_old;
720: CLOSE c_event_date;

Line 726: p_return_status := hr_multi_message.get_return_status_disable;

722:
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:

Line 734: p_return_status := hr_multi_message.get_return_status_disable;

730:
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:

Line 742: p_return_status := hr_multi_message.get_return_status_disable;

738:
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:

Line 840: p_return_status := hr_multi_message.get_return_status_disable;

836: END IF;
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: -- ***

Line 851: p_return_status := hr_multi_message.get_return_status_disable;

847: end if;
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: --

Line 854: when hr_multi_message.error_message_exist then

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
857: -- indicates API processing has been aborted because
858: -- at least one message exists in the list.

Line 864: p_return_status := hr_multi_message.get_return_status_disable;

860: rollback to upd2_update_event;
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

Line 875: if hr_multi_message.unexpected_error_add(l_proc) then

871: -- Multiple Message List. Otherwise re-raise the
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: --

Line 883: p_return_status := hr_multi_message.get_return_status_disable;

879: --
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: