37: savepoint create_ame_approver_group_s;
38: --
39: -- Initialise Multiple Message Detection
40: --
41: hr_multi_message.enable_message_list;
42: --
43: -- Remember IN OUT parameter IN values
44: --
45: --
79: -- Derive the API return status value based on whether
80: -- messages of any type exist in the Multiple Message List.
81: -- Also disable Multiple Message Detection.
82: --
83: p_return_status := hr_multi_message.get_return_status_disable;
84: hr_utility.set_location(' Leaving:' || l_proc,20);
85: --
86: exception
87: when hr_multi_message.error_message_exist then
83: p_return_status := hr_multi_message.get_return_status_disable;
84: hr_utility.set_location(' Leaving:' || l_proc,20);
85: --
86: exception
87: when hr_multi_message.error_message_exist then
88: --
89: -- Catch the Multiple Message List exception which
90: -- indicates API processing has been aborted because
91: -- at least one message exists in the list.
96: --
97: p_start_date := null;
98: p_end_date := null;
99: p_object_version_number := null;
100: p_return_status := hr_multi_message.get_return_status_disable;
101: hr_utility.set_location(' Leaving:' || l_proc, 30);
102: when others then
103: --
104: -- When Multiple Message Detection is enabled catch
107: -- Multiple Message List. Otherwise re-raise the
108: -- error.
109: --
110: rollback to create_ame_approver_group_s;
111: if hr_multi_message.unexpected_error_add(l_proc) then
112: hr_utility.set_location(' Leaving:' || l_proc,40);
113: raise;
114: end if;
115: --
117: --
118: p_start_date := null;
119: p_end_date := null;
120: p_object_version_number := null;
121: p_return_status := hr_multi_message.get_return_status_disable;
122: hr_utility.set_location(' Leaving:' || l_proc,50);
123: end create_ame_approver_group;
124: -- ----------------------------------------------------------------------------
125: -- |-----------------------< update_ame_approver_group >----------------------|
152: savepoint update_ame_approver_group_s;
153: --
154: -- Initialise Multiple Message Detection
155: --
156: hr_multi_message.enable_message_list;
157: --
158: -- Remember IN OUT parameter IN values
159: --
160: l_object_version_number := p_object_version_number;
191: -- Derive the API return status value based on whether
192: -- messages of any type exist in the Multiple Message List.
193: -- Also disable Multiple Message Detection.
194: --
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc,20);
197: --
198: exception
199: when hr_multi_message.error_message_exist then
195: p_return_status := hr_multi_message.get_return_status_disable;
196: hr_utility.set_location(' Leaving:' || l_proc,20);
197: --
198: exception
199: when hr_multi_message.error_message_exist then
200: --
201: -- Catch the Multiple Message List exception which
202: -- indicates API processing has been aborted because
203: -- at least one message exists in the list.
208: --
209: p_object_version_number := l_object_version_number;
210: p_start_date := null;
211: p_end_date := null;
212: p_return_status := hr_multi_message.get_return_status_disable;
213: hr_utility.set_location(' Leaving:' || l_proc, 30);
214: when others then
215: --
216: -- When Multiple Message Detection is enabled catch
219: -- Multiple Message List. Otherwise re-raise the
220: -- error.
221: --
222: rollback to update_ame_approver_group_s;
223: if hr_multi_message.unexpected_error_add(l_proc) then
224: hr_utility.set_location(' Leaving:' || l_proc,40);
225: raise;
226: end if;
227: --
229: --
230: p_object_version_number := l_object_version_number;
231: p_start_date := null;
232: p_end_date := null;
233: p_return_status := hr_multi_message.get_return_status_disable;
234: hr_utility.set_location(' Leaving:' || l_proc,50);
235: end update_ame_approver_group;
236: -- ----------------------------------------------------------------------------
237: -- |-----------------------< delete_ame_approver_group >----------------------|
261: savepoint delete_ame_approver_group_s;
262: --
263: -- Initialise Multiple Message Detection
264: --
265: hr_multi_message.enable_message_list;
266: --
267: -- Remember IN OUT parameter IN values
268: --
269: l_object_version_number := p_object_version_number;
297: -- Derive the API return status value based on whether
298: -- messages of any type exist in the Multiple Message List.
299: -- Also disable Multiple Message Detection.
300: --
301: p_return_status := hr_multi_message.get_return_status_disable;
302: hr_utility.set_location(' Leaving:' || l_proc,20);
303: --
304: exception
305: when hr_multi_message.error_message_exist then
301: p_return_status := hr_multi_message.get_return_status_disable;
302: hr_utility.set_location(' Leaving:' || l_proc,20);
303: --
304: exception
305: when hr_multi_message.error_message_exist then
306: --
307: -- Catch the Multiple Message List exception which
308: -- indicates API processing has been aborted because
309: -- at least one message exists in the list.
314: --
315: p_object_version_number := l_object_version_number;
316: p_start_date := null;
317: p_end_date := null;
318: p_return_status := hr_multi_message.get_return_status_disable;
319: hr_utility.set_location(' Leaving:' || l_proc, 30);
320: when others then
321: --
322: -- When Multiple Message Detection is enabled catch
325: -- Multiple Message List. Otherwise re-raise the
326: -- error.
327: --
328: rollback to delete_ame_approver_group_s;
329: if hr_multi_message.unexpected_error_add(l_proc) then
330: hr_utility.set_location(' Leaving:' || l_proc,40);
331: raise;
332: end if;
333: --
335: --
336: p_object_version_number := l_object_version_number;
337: p_start_date := null;
338: p_end_date := null;
339: p_return_status := hr_multi_message.get_return_status_disable;
340: hr_utility.set_location(' Leaving:' || l_proc,50);
341: end delete_ame_approver_group;
342: -- ----------------------------------------------------------------------------
343: -- |---------------------< create_approver_group_config >---------------------|
369: savepoint create_approver_group_config_s;
370: --
371: -- Initialise Multiple Message Detection
372: --
373: hr_multi_message.enable_message_list;
374: --
375: -- Remember IN OUT parameter IN values
376: --
377: --
407: -- Derive the API return status value based on whether
408: -- messages of any type exist in the Multiple Message List.
409: -- Also disable Multiple Message Detection.
410: --
411: p_return_status := hr_multi_message.get_return_status_disable;
412: hr_utility.set_location(' Leaving:' || l_proc,20);
413: --
414: exception
415: when hr_multi_message.error_message_exist then
411: p_return_status := hr_multi_message.get_return_status_disable;
412: hr_utility.set_location(' Leaving:' || l_proc,20);
413: --
414: exception
415: when hr_multi_message.error_message_exist then
416: --
417: -- Catch the Multiple Message List exception which
418: -- indicates API processing has been aborted because
419: -- at least one message exists in the list.
424: --
425: p_object_version_number := null;
426: p_start_date := null;
427: p_end_date := null;
428: p_return_status := hr_multi_message.get_return_status_disable;
429: hr_utility.set_location(' Leaving:' || l_proc, 30);
430: when others then
431: --
432: -- When Multiple Message Detection is enabled catch
435: -- Multiple Message List. Otherwise re-raise the
436: -- error.
437: --
438: rollback to create_approver_group_config_s;
439: if hr_multi_message.unexpected_error_add(l_proc) then
440: hr_utility.set_location(' Leaving:' || l_proc,40);
441: raise;
442: end if;
443: --
445: --
446: p_object_version_number := null;
447: p_start_date := null;
448: p_end_date := null;
449: p_return_status := hr_multi_message.get_return_status_disable;
450: hr_utility.set_location(' Leaving:' || l_proc,50);
451: end create_approver_group_config;
452: -- ----------------------------------------------------------------------------
453: -- |---------------------< delete_approver_group_config >---------------------|
478: savepoint delete_approver_group_config_s;
479: --
480: -- Initialise Multiple Message Detection
481: --
482: hr_multi_message.enable_message_list;
483: --
484: -- Remember IN OUT parameter IN values
485: --
486: l_object_version_number := p_object_version_number;
515: -- Derive the API return status value based on whether
516: -- messages of any type exist in the Multiple Message List.
517: -- Also disable Multiple Message Detection.
518: --
519: p_return_status := hr_multi_message.get_return_status_disable;
520: hr_utility.set_location(' Leaving:' || l_proc,20);
521: --
522: exception
523: when hr_multi_message.error_message_exist then
519: p_return_status := hr_multi_message.get_return_status_disable;
520: hr_utility.set_location(' Leaving:' || l_proc,20);
521: --
522: exception
523: when hr_multi_message.error_message_exist then
524: --
525: -- Catch the Multiple Message List exception which
526: -- indicates API processing has been aborted because
527: -- at least one message exists in the list.
532: --
533: p_object_version_number := l_object_version_number;
534: p_start_date := null;
535: p_end_date := null;
536: p_return_status := hr_multi_message.get_return_status_disable;
537: hr_utility.set_location(' Leaving:' || l_proc, 30);
538: when others then
539: --
540: -- When Multiple Message Detection is enabled catch
543: -- Multiple Message List. Otherwise re-raise the
544: -- error.
545: --
546: rollback to delete_approver_group_config_s;
547: if hr_multi_message.unexpected_error_add(l_proc) then
548: hr_utility.set_location(' Leaving:' || l_proc,40);
549: raise;
550: end if;
551: --
553: --
554: p_object_version_number := l_object_version_number;
555: p_start_date := null;
556: p_end_date := null;
557: p_return_status := hr_multi_message.get_return_status_disable;
558: hr_utility.set_location(' Leaving:' || l_proc,50);
559: end delete_approver_group_config;
560: -- ----------------------------------------------------------------------------
561: -- |---------------------< update_approver_group_config >---------------------|
588: savepoint update_approver_group_config_s;
589: --
590: -- Initialise Multiple Message Detection
591: --
592: hr_multi_message.enable_message_list;
593: --
594: -- Remember IN OUT parameter IN values
595: --
596: l_object_version_number := p_object_version_number;
627: -- Derive the API return status value based on whether
628: -- messages of any type exist in the Multiple Message List.
629: -- Also disable Multiple Message Detection.
630: --
631: p_return_status := hr_multi_message.get_return_status_disable;
632: hr_utility.set_location(' Leaving:' || l_proc,20);
633: --
634: exception
635: when hr_multi_message.error_message_exist then
631: p_return_status := hr_multi_message.get_return_status_disable;
632: hr_utility.set_location(' Leaving:' || l_proc,20);
633: --
634: exception
635: when hr_multi_message.error_message_exist then
636: --
637: -- Catch the Multiple Message List exception which
638: -- indicates API processing has been aborted because
639: -- at least one message exists in the list.
644: --
645: p_object_version_number := l_object_version_number;
646: p_start_date := null;
647: p_end_date := null;
648: p_return_status := hr_multi_message.get_return_status_disable;
649: hr_utility.set_location(' Leaving:' || l_proc, 30);
650: when others then
651: --
652: -- When Multiple Message Detection is enabled catch
655: -- Multiple Message List. Otherwise re-raise the
656: -- error.
657: --
658: rollback to update_approver_group_config_s;
659: if hr_multi_message.unexpected_error_add(l_proc) then
660: hr_utility.set_location(' Leaving:' || l_proc,40);
661: raise;
662: end if;
663: --
665: --
666: p_object_version_number := l_object_version_number;
667: p_start_date := null;
668: p_end_date := null;
669: p_return_status := hr_multi_message.get_return_status_disable;
670: hr_utility.set_location(' Leaving:' || l_proc,50);
671: end update_approver_group_config;
672: -- ----------------------------------------------------------------------------
673: -- |----------------------< create_approver_group_item >----------------------|
701: savepoint create_approver_group_item_s;
702: --
703: -- Initialise Multiple Message Detection
704: --
705: hr_multi_message.enable_message_list;
706: --
707: -- Remember IN OUT parameter IN values
708: --
709: --
743: -- Derive the API return status value based on whether
744: -- messages of any type exist in the Multiple Message List.
745: -- Also disable Multiple Message Detection.
746: --
747: p_return_status := hr_multi_message.get_return_status_disable;
748: hr_utility.set_location(' Leaving:' || l_proc,20);
749: --
750: exception
751: when hr_multi_message.error_message_exist then
747: p_return_status := hr_multi_message.get_return_status_disable;
748: hr_utility.set_location(' Leaving:' || l_proc,20);
749: --
750: exception
751: when hr_multi_message.error_message_exist then
752: --
753: -- Catch the Multiple Message List exception which
754: -- indicates API processing has been aborted because
755: -- at least one message exists in the list.
761: -- p_approval_group_item_id := null;
762: p_object_version_number := null;
763: p_start_date := null;
764: p_end_date := null;
765: p_return_status := hr_multi_message.get_return_status_disable;
766: hr_utility.set_location(' Leaving:' || l_proc, 30);
767: when others then
768: --
769: -- When Multiple Message Detection is enabled catch
772: -- Multiple Message List. Otherwise re-raise the
773: -- error.
774: --
775: rollback to create_approver_group_item_s;
776: if hr_multi_message.unexpected_error_add(l_proc) then
777: hr_utility.set_location(' Leaving:' || l_proc,40);
778: raise;
779: end if;
780: --
783: -- p_approval_group_item_id := null;
784: p_object_version_number := null;
785: p_start_date := null;
786: p_end_date := null;
787: p_return_status := hr_multi_message.get_return_status_disable;
788: hr_utility.set_location(' Leaving:' || l_proc,50);
789: end create_approver_group_item;
790: -- ----------------------------------------------------------------------------
791: -- |----------------------< delete_approver_group_item >----------------------|
815: savepoint delete_approver_group_item_s;
816: --
817: -- Initialise Multiple Message Detection
818: --
819: hr_multi_message.enable_message_list;
820: --
821: -- Remember IN OUT parameter IN values
822: --
823: l_object_version_number := p_object_version_number;
851: -- Derive the API return status value based on whether
852: -- messages of any type exist in the Multiple Message List.
853: -- Also disable Multiple Message Detection.
854: --
855: p_return_status := hr_multi_message.get_return_status_disable;
856: hr_utility.set_location(' Leaving:' || l_proc,20);
857: --
858: exception
859: when hr_multi_message.error_message_exist then
855: p_return_status := hr_multi_message.get_return_status_disable;
856: hr_utility.set_location(' Leaving:' || l_proc,20);
857: --
858: exception
859: when hr_multi_message.error_message_exist then
860: --
861: -- Catch the Multiple Message List exception which
862: -- indicates API processing has been aborted because
863: -- at least one message exists in the list.
868: --
869: p_object_version_number := l_object_version_number;
870: p_start_date := null;
871: p_end_date := null;
872: p_return_status := hr_multi_message.get_return_status_disable;
873: hr_utility.set_location(' Leaving:' || l_proc, 30);
874: when others then
875: --
876: -- When Multiple Message Detection is enabled catch
879: -- Multiple Message List. Otherwise re-raise the
880: -- error.
881: --
882: rollback to delete_approver_group_item_s;
883: if hr_multi_message.unexpected_error_add(l_proc) then
884: hr_utility.set_location(' Leaving:' || l_proc,40);
885: raise;
886: end if;
887: --
889: --
890: p_object_version_number := l_object_version_number;
891: p_start_date := null;
892: p_end_date := null;
893: p_return_status := hr_multi_message.get_return_status_disable;
894: hr_utility.set_location(' Leaving:' || l_proc,50);
895: end delete_approver_group_item;
896: -- ----------------------------------------------------------------------------
897: -- |----------------------< update_approver_group_item >----------------------|
922: savepoint update_approver_group_item_s;
923: --
924: -- Initialise Multiple Message Detection
925: --
926: hr_multi_message.enable_message_list;
927: --
928: -- Remember IN OUT parameter IN values
929: --
930: l_object_version_number := p_object_version_number;
959: -- Derive the API return status value based on whether
960: -- messages of any type exist in the Multiple Message List.
961: -- Also disable Multiple Message Detection.
962: --
963: p_return_status := hr_multi_message.get_return_status_disable;
964: hr_utility.set_location(' Leaving:' || l_proc,20);
965: --
966: exception
967: when hr_multi_message.error_message_exist then
963: p_return_status := hr_multi_message.get_return_status_disable;
964: hr_utility.set_location(' Leaving:' || l_proc,20);
965: --
966: exception
967: when hr_multi_message.error_message_exist then
968: --
969: -- Catch the Multiple Message List exception which
970: -- indicates API processing has been aborted because
971: -- at least one message exists in the list.
976: --
977: p_object_version_number := l_object_version_number;
978: p_start_date := null;
979: p_end_date := null;
980: p_return_status := hr_multi_message.get_return_status_disable;
981: hr_utility.set_location(' Leaving:' || l_proc, 30);
982: when others then
983: --
984: -- When Multiple Message Detection is enabled catch
987: -- Multiple Message List. Otherwise re-raise the
988: -- error.
989: --
990: rollback to update_approver_group_item_s;
991: if hr_multi_message.unexpected_error_add(l_proc) then
992: hr_utility.set_location(' Leaving:' || l_proc,40);
993: raise;
994: end if;
995: --
997: --
998: p_object_version_number := l_object_version_number;
999: p_start_date := null;
1000: p_end_date := null;
1001: p_return_status := hr_multi_message.get_return_status_disable;
1002: hr_utility.set_location(' Leaving:' || l_proc,50);
1003: end update_approver_group_item;
1004: end ame_approver_group_swi;