44: savepoint create_ame_act_type_swi;
45: --
46: -- Initialise Multiple Message Detection
47: --
48: hr_multi_message.enable_message_list;
49: --
50: -- Remember IN OUT parameter IN values
51: --
52: --
93: -- Derive the API return status value based on whether
94: -- messages of any type exist in the Multiple Message List.
95: -- Also disable Multiple Message Detection.
96: --
97: p_return_status := hr_multi_message.get_return_status_disable;
98: hr_utility.set_location(' Leaving:' || l_proc,20);
99: --
100: exception
101: when hr_multi_message.error_message_exist then
97: p_return_status := hr_multi_message.get_return_status_disable;
98: hr_utility.set_location(' Leaving:' || l_proc,20);
99: --
100: exception
101: when hr_multi_message.error_message_exist then
102: --
103: -- Catch the Multiple Message List exception which
104: -- indicates API processing has been aborted because
105: -- at least one message exists in the list.
113: p_aty_end_date := null;
114: p_apu_object_version_number := null;
115: p_apu_start_date := null;
116: p_apu_end_date := null;
117: p_return_status := hr_multi_message.get_return_status_disable;
118: hr_utility.set_location(' Leaving:' || l_proc, 30);
119: when others then
120: --
121: -- When Multiple Message Detection is enabled catch
124: -- Multiple Message List. Otherwise re-raise the
125: -- error.
126: --
127: rollback to create_ame_act_type_swi;
128: if hr_multi_message.unexpected_error_add(l_proc) then
129: hr_utility.set_location(' Leaving:' || l_proc,40);
130: raise;
131: end if;
132: --
137: p_aty_end_date := null;
138: p_apu_object_version_number := null;
139: p_apu_start_date := null;
140: p_apu_end_date := null;
141: p_return_status := hr_multi_message.get_return_status_disable;
142: hr_utility.set_location(' Leaving:' || l_proc,50);
143: end create_ame_action_type;
144: -- ----------------------------------------------------------------------------
145: -- |---------------------< create_ame_action_type_usage >---------------------|
169: savepoint create_ame_act_type_usg_swi;
170: --
171: -- Initialise Multiple Message Detection
172: --
173: hr_multi_message.enable_message_list;
174: --
175: -- Remember IN OUT parameter IN values
176: --
177: --
205: -- Derive the API return status value based on whether
206: -- messages of any type exist in the Multiple Message List.
207: -- Also disable Multiple Message Detection.
208: --
209: p_return_status := hr_multi_message.get_return_status_disable;
210: hr_utility.set_location(' Leaving:' || l_proc,20);
211: --
212: exception
213: when hr_multi_message.error_message_exist then
209: p_return_status := hr_multi_message.get_return_status_disable;
210: hr_utility.set_location(' Leaving:' || l_proc,20);
211: --
212: exception
213: when hr_multi_message.error_message_exist then
214: --
215: -- Catch the Multiple Message List exception which
216: -- indicates API processing has been aborted because
217: -- at least one message exists in the list.
222: --
223: p_object_version_number := null;
224: p_start_date := null;
225: p_end_date := null;
226: p_return_status := hr_multi_message.get_return_status_disable;
227: hr_utility.set_location(' Leaving:' || l_proc, 30);
228: when others then
229: --
230: -- When Multiple Message Detection is enabled catch
233: -- Multiple Message List. Otherwise re-raise the
234: -- error.
235: --
236: rollback to create_ame_act_type_usg_swi;
237: if hr_multi_message.unexpected_error_add(l_proc) then
238: hr_utility.set_location(' Leaving:' || l_proc,40);
239: raise;
240: end if;
241: --
243: --
244: p_object_version_number := null;
245: p_start_date := null;
246: p_end_date := null;
247: p_return_status := hr_multi_message.get_return_status_disable;
248: hr_utility.set_location(' Leaving:' || l_proc,50);
249: end create_ame_action_type_usage;
250: -- ----------------------------------------------------------------------------
251: -- |----------------------< create_ame_appr_type_usage >----------------------|
275: savepoint create_ame_appr_type_usage_swi;
276: --
277: -- Initialise Multiple Message Detection
278: --
279: hr_multi_message.enable_message_list;
280: --
281: -- Remember IN OUT parameter IN values
282: --
283: --
311: -- Derive the API return status value based on whether
312: -- messages of any type exist in the Multiple Message List.
313: -- Also disable Multiple Message Detection.
314: --
315: p_return_status := hr_multi_message.get_return_status_disable;
316: hr_utility.set_location(' Leaving:' || l_proc,20);
317: --
318: exception
319: when hr_multi_message.error_message_exist then
315: p_return_status := hr_multi_message.get_return_status_disable;
316: hr_utility.set_location(' Leaving:' || l_proc,20);
317: --
318: exception
319: when hr_multi_message.error_message_exist then
320: --
321: -- Catch the Multiple Message List exception which
322: -- indicates API processing has been aborted because
323: -- at least one message exists in the list.
328: --
329: p_object_version_number := null;
330: p_start_date := null;
331: p_end_date := null;
332: p_return_status := hr_multi_message.get_return_status_disable;
333: hr_utility.set_location(' Leaving:' || l_proc, 30);
334: when others then
335: --
336: -- When Multiple Message Detection is enabled catch
339: -- Multiple Message List. Otherwise re-raise the
340: -- error.
341: --
342: rollback to create_ame_appr_type_usage_swi;
343: if hr_multi_message.unexpected_error_add(l_proc) then
344: hr_utility.set_location(' Leaving:' || l_proc,40);
345: raise;
346: end if;
347: --
349: --
350: p_object_version_number := null;
351: p_start_date := null;
352: p_end_date := null;
353: p_return_status := hr_multi_message.get_return_status_disable;
354: hr_utility.set_location(' Leaving:' || l_proc,50);
355: end create_ame_appr_type_usage;
356: -- |---------------------< create_ame_action_type_config >--------------------|
357: -- ----------------------------------------------------------------------------
383: savepoint create_ame_act_type_conf_swi;
384: --
385: -- Initialise Multiple Message Detection
386: --
387: hr_multi_message.enable_message_list;
388: --
389: -- Remember IN OUT parameter IN values
390: --
391: --
422: -- Derive the API return status value based on whether
423: -- messages of any type exist in the Multiple Message List.
424: -- Also disable Multiple Message Detection.
425: --
426: p_return_status := hr_multi_message.get_return_status_disable;
427: hr_utility.set_location(' Leaving:' || l_proc,20);
428: --
429: exception
430: when hr_multi_message.error_message_exist then
426: p_return_status := hr_multi_message.get_return_status_disable;
427: hr_utility.set_location(' Leaving:' || l_proc,20);
428: --
429: exception
430: when hr_multi_message.error_message_exist then
431: --
432: -- Catch the Multiple Message List exception which
433: -- indicates API processing has been aborted because
434: -- at least one message exists in the list.
439: --
440: p_object_version_number := null;
441: p_start_date := null;
442: p_end_date := null;
443: p_return_status := hr_multi_message.get_return_status_disable;
444: hr_utility.set_location(' Leaving:' || l_proc, 30);
445: when others then
446: --
447: -- When Multiple Message Detection is enabled catch
450: -- Multiple Message List. Otherwise re-raise the
451: -- error.
452: --
453: rollback to create_ame_act_type_conf_swi;
454: if hr_multi_message.unexpected_error_add(l_proc) then
455: hr_utility.set_location(' Leaving:' || l_proc,40);
456: raise;
457: end if;
458: --
460: --
461: p_object_version_number := null;
462: p_start_date := null;
463: p_end_date := null;
464: p_return_status := hr_multi_message.get_return_status_disable;
465: hr_utility.set_location(' Leaving:' || l_proc,50);
466: end create_ame_action_type_config;
467: -- ----------------------------------------------------------------------------
468: -- |-----------------------< create_ame_req_attribute >-----------------------|
492: savepoint create_ame_req_attribute_swi;
493: --
494: -- Initialise Multiple Message Detection
495: --
496: hr_multi_message.enable_message_list;
497: --
498: -- Remember IN OUT parameter IN values
499: --
500: --
528: -- Derive the API return status value based on whether
529: -- messages of any type exist in the Multiple Message List.
530: -- Also disable Multiple Message Detection.
531: --
532: p_return_status := hr_multi_message.get_return_status_disable;
533: hr_utility.set_location(' Leaving:' || l_proc,20);
534: --
535: exception
536: when hr_multi_message.error_message_exist then
532: p_return_status := hr_multi_message.get_return_status_disable;
533: hr_utility.set_location(' Leaving:' || l_proc,20);
534: --
535: exception
536: when hr_multi_message.error_message_exist then
537: --
538: -- Catch the Multiple Message List exception which
539: -- indicates API processing has been aborted because
540: -- at least one message exists in the list.
545: --
546: p_object_version_number := null;
547: p_start_date := null;
548: p_end_date := null;
549: p_return_status := hr_multi_message.get_return_status_disable;
550: hr_utility.set_location(' Leaving:' || l_proc, 30);
551: when others then
552: --
553: -- When Multiple Message Detection is enabled catch
556: -- Multiple Message List. Otherwise re-raise the
557: -- error.
558: --
559: rollback to create_ame_req_attribute_swi;
560: if hr_multi_message.unexpected_error_add(l_proc) then
561: hr_utility.set_location(' Leaving:' || l_proc,40);
562: raise;
563: end if;
564: --
566: --
567: p_object_version_number := null;
568: p_start_date := null;
569: p_end_date := null;
570: p_return_status := hr_multi_message.get_return_status_disable;
571: hr_utility.set_location(' Leaving:' || l_proc,50);
572: end create_ame_req_attribute;
573: -- ----------------------------------------------------------------------------
574: -- |---------------------------< create_ame_action >--------------------------|
602: savepoint create_ame_action_swi;
603: --
604: -- Initialise Multiple Message Detection
605: --
606: hr_multi_message.enable_message_list;
607: --
608: -- Remember IN OUT parameter IN values
609: --
610: --
642: -- Derive the API return status value based on whether
643: -- messages of any type exist in the Multiple Message List.
644: -- Also disable Multiple Message Detection.
645: --
646: p_return_status := hr_multi_message.get_return_status_disable;
647: hr_utility.set_location(' Leaving:' || l_proc,20);
648: --
649: exception
650: when hr_multi_message.error_message_exist then
646: p_return_status := hr_multi_message.get_return_status_disable;
647: hr_utility.set_location(' Leaving:' || l_proc,20);
648: --
649: exception
650: when hr_multi_message.error_message_exist then
651: --
652: -- Catch the Multiple Message List exception which
653: -- indicates API processing has been aborted because
654: -- at least one message exists in the list.
660: p_action_id := null;
661: p_object_version_number := null;
662: p_start_date := null;
663: p_end_date := null;
664: p_return_status := hr_multi_message.get_return_status_disable;
665: hr_utility.set_location(' Leaving:' || l_proc, 30);
666: when others then
667: --
668: -- When Multiple Message Detection is enabled catch
671: -- Multiple Message List. Otherwise re-raise the
672: -- error.
673: --
674: rollback to create_ame_action_swi;
675: if hr_multi_message.unexpected_error_add(l_proc) then
676: hr_utility.set_location(' Leaving:' || l_proc,40);
677: raise;
678: end if;
679: --
682: p_action_id := null;
683: p_object_version_number := null;
684: p_start_date := null;
685: p_end_date := null;
686: p_return_status := hr_multi_message.get_return_status_disable;
687: hr_utility.set_location(' Leaving:' || l_proc,50);
688: end create_ame_action;
689: -- ----------------------------------------------------------------------------
690: -- |------------------------< update_ame_action_type >------------------------|
718: savepoint update_ame_act_type_swi;
719: --
720: -- Initialise Multiple Message Detection
721: --
722: hr_multi_message.enable_message_list;
723: --
724: -- Remember IN OUT parameter IN values
725: --
726: l_object_version_number := p_object_version_number;
758: -- Derive the API return status value based on whether
759: -- messages of any type exist in the Multiple Message List.
760: -- Also disable Multiple Message Detection.
761: --
762: p_return_status := hr_multi_message.get_return_status_disable;
763: hr_utility.set_location(' Leaving:' || l_proc,20);
764: --
765: exception
766: when hr_multi_message.error_message_exist then
762: p_return_status := hr_multi_message.get_return_status_disable;
763: hr_utility.set_location(' Leaving:' || l_proc,20);
764: --
765: exception
766: when hr_multi_message.error_message_exist then
767: --
768: -- Catch the Multiple Message List exception which
769: -- indicates API processing has been aborted because
770: -- at least one message exists in the list.
775: --
776: p_object_version_number := l_object_version_number;
777: p_start_date := null;
778: p_end_date := null;
779: p_return_status := hr_multi_message.get_return_status_disable;
780: hr_utility.set_location(' Leaving:' || l_proc, 30);
781: when others then
782: --
783: -- When Multiple Message Detection is enabled catch
786: -- Multiple Message List. Otherwise re-raise the
787: -- error.
788: --
789: rollback to update_ame_act_type_swi;
790: if hr_multi_message.unexpected_error_add(l_proc) then
791: hr_utility.set_location(' Leaving:' || l_proc,40);
792: raise;
793: end if;
794: --
796: --
797: p_object_version_number := l_object_version_number;
798: p_start_date := null;
799: p_end_date := null;
800: p_return_status := hr_multi_message.get_return_status_disable;
801: hr_utility.set_location(' Leaving:' || l_proc,50);
802: end update_ame_action_type;
803: -- ----------------------------------------------------------------------------
804: -- |----------------------< update_ame_action_type_conf >---------------------|
832: savepoint update_ame_act_type_conf_swi;
833: --
834: -- Initialise Multiple Message Detection
835: --
836: hr_multi_message.enable_message_list;
837: --
838: -- Remember IN OUT parameter IN values
839: --
840: l_object_version_number := p_object_version_number;
872: -- Derive the API return status value based on whether
873: -- messages of any type exist in the Multiple Message List.
874: -- Also disable Multiple Message Detection.
875: --
876: p_return_status := hr_multi_message.get_return_status_disable;
877: hr_utility.set_location(' Leaving:' || l_proc,20);
878: --
879: exception
880: when hr_multi_message.error_message_exist then
876: p_return_status := hr_multi_message.get_return_status_disable;
877: hr_utility.set_location(' Leaving:' || l_proc,20);
878: --
879: exception
880: when hr_multi_message.error_message_exist then
881: --
882: -- Catch the Multiple Message List exception which
883: -- indicates API processing has been aborted because
884: -- at least one message exists in the list.
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, 30);
895: when others then
896: --
897: -- When Multiple Message Detection is enabled catch
900: -- Multiple Message List. Otherwise re-raise the
901: -- error.
902: --
903: rollback to update_ame_act_type_conf_swi;
904: if hr_multi_message.unexpected_error_add(l_proc) then
905: hr_utility.set_location(' Leaving:' || l_proc,40);
906: raise;
907: end if;
908: --
910: --
911: p_object_version_number := l_object_version_number;
912: p_start_date := null;
913: p_end_date := null;
914: p_return_status := hr_multi_message.get_return_status_disable;
915: hr_utility.set_location(' Leaving:' || l_proc,50);
916: end update_ame_action_type_conf;
917: -- ----------------------------------------------------------------------------
918: -- |---------------------------< update_ame_action >--------------------------|
947: savepoint update_ame_action_swi;
948: --
949: -- Initialise Multiple Message Detection
950: --
951: hr_multi_message.enable_message_list;
952: --
953: -- Remember IN OUT parameter IN values
954: --
955: l_object_version_number := p_object_version_number;
988: -- Derive the API return status value based on whether
989: -- messages of any type exist in the Multiple Message List.
990: -- Also disable Multiple Message Detection.
991: --
992: p_return_status := hr_multi_message.get_return_status_disable;
993: hr_utility.set_location(' Leaving:' || l_proc,20);
994: --
995: exception
996: when hr_multi_message.error_message_exist then
992: p_return_status := hr_multi_message.get_return_status_disable;
993: hr_utility.set_location(' Leaving:' || l_proc,20);
994: --
995: exception
996: when hr_multi_message.error_message_exist then
997: --
998: -- Catch the Multiple Message List exception which
999: -- indicates API processing has been aborted because
1000: -- at least one message exists in the list.
1005: --
1006: p_object_version_number := l_object_version_number;
1007: p_start_date := null;
1008: p_end_date := null;
1009: p_return_status := hr_multi_message.get_return_status_disable;
1010: hr_utility.set_location(' Leaving:' || l_proc, 30);
1011: when others then
1012: --
1013: -- When Multiple Message Detection is enabled catch
1016: -- Multiple Message List. Otherwise re-raise the
1017: -- error.
1018: --
1019: rollback to update_ame_action_swi;
1020: if hr_multi_message.unexpected_error_add(l_proc) then
1021: hr_utility.set_location(' Leaving:' || l_proc,40);
1022: raise;
1023: end if;
1024: --
1026: --
1027: p_object_version_number := l_object_version_number;
1028: p_start_date := null;
1029: p_end_date := null;
1030: p_return_status := hr_multi_message.get_return_status_disable;
1031: hr_utility.set_location(' Leaving:' || l_proc,50);
1032: end update_ame_action;
1033: -- ----------------------------------------------------------------------------
1034: -- |------------------------< delete_ame_action_type >------------------------|
1058: savepoint delete_ame_act_type_swi;
1059: --
1060: -- Initialise Multiple Message Detection
1061: --
1062: hr_multi_message.enable_message_list;
1063: --
1064: -- Remember IN OUT parameter IN values
1065: --
1066: l_object_version_number := p_object_version_number;
1094: -- Derive the API return status value based on whether
1095: -- messages of any type exist in the Multiple Message List.
1096: -- Also disable Multiple Message Detection.
1097: --
1098: p_return_status := hr_multi_message.get_return_status_disable;
1099: hr_utility.set_location(' Leaving:' || l_proc,20);
1100: --
1101: exception
1102: when hr_multi_message.error_message_exist then
1098: p_return_status := hr_multi_message.get_return_status_disable;
1099: hr_utility.set_location(' Leaving:' || l_proc,20);
1100: --
1101: exception
1102: when hr_multi_message.error_message_exist then
1103: --
1104: -- Catch the Multiple Message List exception which
1105: -- indicates API processing has been aborted because
1106: -- at least one message exists in the list.
1111: --
1112: p_object_version_number := l_object_version_number;
1113: p_start_date := null;
1114: p_end_date := null;
1115: p_return_status := hr_multi_message.get_return_status_disable;
1116: hr_utility.set_location(' Leaving:' || l_proc, 30);
1117: when others then
1118: --
1119: -- When Multiple Message Detection is enabled catch
1122: -- Multiple Message List. Otherwise re-raise the
1123: -- error.
1124: --
1125: rollback to delete_ame_act_type_swi;
1126: if hr_multi_message.unexpected_error_add(l_proc) then
1127: hr_utility.set_location(' Leaving:' || l_proc,40);
1128: raise;
1129: end if;
1130: --
1132: --
1133: p_object_version_number := l_object_version_number;
1134: p_start_date := null;
1135: p_end_date := null;
1136: p_return_status := hr_multi_message.get_return_status_disable;
1137: hr_utility.set_location(' Leaving:' || l_proc,50);
1138: end delete_ame_action_type;
1139: -- ----------------------------------------------------------------------------
1140: -- |----------------------< delete_ame_action_type_conf >---------------------|
1165: savepoint delete_ame_act_type_conf_swi;
1166: --
1167: -- Initialise Multiple Message Detection
1168: --
1169: hr_multi_message.enable_message_list;
1170: --
1171: -- Remember IN OUT parameter IN values
1172: --
1173: l_object_version_number := p_object_version_number;
1202: -- Derive the API return status value based on whether
1203: -- messages of any type exist in the Multiple Message List.
1204: -- Also disable Multiple Message Detection.
1205: --
1206: p_return_status := hr_multi_message.get_return_status_disable;
1207: hr_utility.set_location(' Leaving:' || l_proc,20);
1208: --
1209: exception
1210: when hr_multi_message.error_message_exist then
1206: p_return_status := hr_multi_message.get_return_status_disable;
1207: hr_utility.set_location(' Leaving:' || l_proc,20);
1208: --
1209: exception
1210: when hr_multi_message.error_message_exist then
1211: --
1212: -- Catch the Multiple Message List exception which
1213: -- indicates API processing has been aborted because
1214: -- at least one message exists in the list.
1219: --
1220: p_object_version_number := l_object_version_number;
1221: p_start_date := null;
1222: p_end_date := null;
1223: p_return_status := hr_multi_message.get_return_status_disable;
1224: hr_utility.set_location(' Leaving:' || l_proc, 30);
1225: when others then
1226: --
1227: -- When Multiple Message Detection is enabled catch
1230: -- Multiple Message List. Otherwise re-raise the
1231: -- error.
1232: --
1233: rollback to delete_ame_act_type_conf_swi;
1234: if hr_multi_message.unexpected_error_add(l_proc) then
1235: hr_utility.set_location(' Leaving:' || l_proc,40);
1236: raise;
1237: end if;
1238: --
1240: --
1241: p_object_version_number := l_object_version_number;
1242: p_start_date := null;
1243: p_end_date := null;
1244: p_return_status := hr_multi_message.get_return_status_disable;
1245: hr_utility.set_location(' Leaving:' || l_proc,50);
1246: end delete_ame_action_type_conf;
1247: -- ----------------------------------------------------------------------------
1248: -- |---------------------< delete_ame_action_type_usage >---------------------|
1273: savepoint delete_ame_act_type_usg_swi;
1274: --
1275: -- Initialise Multiple Message Detection
1276: --
1277: hr_multi_message.enable_message_list;
1278: --
1279: -- Remember IN OUT parameter IN values
1280: --
1281: l_object_version_number := p_object_version_number;
1310: -- Derive the API return status value based on whether
1311: -- messages of any type exist in the Multiple Message List.
1312: -- Also disable Multiple Message Detection.
1313: --
1314: p_return_status := hr_multi_message.get_return_status_disable;
1315: hr_utility.set_location(' Leaving:' || l_proc,20);
1316: --
1317: exception
1318: when hr_multi_message.error_message_exist then
1314: p_return_status := hr_multi_message.get_return_status_disable;
1315: hr_utility.set_location(' Leaving:' || l_proc,20);
1316: --
1317: exception
1318: when hr_multi_message.error_message_exist then
1319: --
1320: -- Catch the Multiple Message List exception which
1321: -- indicates API processing has been aborted because
1322: -- at least one message exists in the list.
1327: --
1328: p_object_version_number := l_object_version_number;
1329: p_start_date := null;
1330: p_end_date := null;
1331: p_return_status := hr_multi_message.get_return_status_disable;
1332: hr_utility.set_location(' Leaving:' || l_proc, 30);
1333: when others then
1334: --
1335: -- When Multiple Message Detection is enabled catch
1338: -- Multiple Message List. Otherwise re-raise the
1339: -- error.
1340: --
1341: rollback to delete_ame_act_type_usg_swi;
1342: if hr_multi_message.unexpected_error_add(l_proc) then
1343: hr_utility.set_location(' Leaving:' || l_proc,40);
1344: raise;
1345: end if;
1346: --
1348: --
1349: p_object_version_number := l_object_version_number;
1350: p_start_date := null;
1351: p_end_date := null;
1352: p_return_status := hr_multi_message.get_return_status_disable;
1353: hr_utility.set_location(' Leaving:' || l_proc,50);
1354: end delete_ame_action_type_usage;
1355: -- ----------------------------------------------------------------------------
1356: -- |----------------------< delete_ame_appr_type_usage >----------------------|
1381: savepoint delete_ame_appr_type_usage_swi;
1382: --
1383: -- Initialise Multiple Message Detection
1384: --
1385: hr_multi_message.enable_message_list;
1386: --
1387: -- Remember IN OUT parameter IN values
1388: --
1389: l_object_version_number := p_object_version_number;
1418: -- Derive the API return status value based on whether
1419: -- messages of any type exist in the Multiple Message List.
1420: -- Also disable Multiple Message Detection.
1421: --
1422: p_return_status := hr_multi_message.get_return_status_disable;
1423: hr_utility.set_location(' Leaving:' || l_proc,20);
1424: --
1425: exception
1426: when hr_multi_message.error_message_exist then
1422: p_return_status := hr_multi_message.get_return_status_disable;
1423: hr_utility.set_location(' Leaving:' || l_proc,20);
1424: --
1425: exception
1426: when hr_multi_message.error_message_exist then
1427: --
1428: -- Catch the Multiple Message List exception which
1429: -- indicates API processing has been aborted because
1430: -- at least one message exists in the list.
1435: --
1436: p_object_version_number := l_object_version_number;
1437: p_start_date := null;
1438: p_end_date := null;
1439: p_return_status := hr_multi_message.get_return_status_disable;
1440: hr_utility.set_location(' Leaving:' || l_proc, 30);
1441: when others then
1442: --
1443: -- When Multiple Message Detection is enabled catch
1446: -- Multiple Message List. Otherwise re-raise the
1447: -- error.
1448: --
1449: rollback to delete_ame_appr_type_usage_swi;
1450: if hr_multi_message.unexpected_error_add(l_proc) then
1451: hr_utility.set_location(' Leaving:' || l_proc,40);
1452: raise;
1453: end if;
1454: --
1456: --
1457: p_object_version_number := l_object_version_number;
1458: p_start_date := null;
1459: p_end_date := null;
1460: p_return_status := hr_multi_message.get_return_status_disable;
1461: hr_utility.set_location(' Leaving:' || l_proc,50);
1462: end delete_ame_appr_type_usage;
1463: -- ----------------------------------------------------------------------------
1464: -- |-----------------------< delete_ame_req_attribute >-----------------------|
1489: savepoint delete_ame_req_attribute_swi;
1490: --
1491: -- Initialise Multiple Message Detection
1492: --
1493: hr_multi_message.enable_message_list;
1494: --
1495: -- Remember IN OUT parameter IN values
1496: --
1497: l_object_version_number := p_object_version_number;
1526: -- Derive the API return status value based on whether
1527: -- messages of any type exist in the Multiple Message List.
1528: -- Also disable Multiple Message Detection.
1529: --
1530: p_return_status := hr_multi_message.get_return_status_disable;
1531: hr_utility.set_location(' Leaving:' || l_proc,20);
1532: --
1533: exception
1534: when hr_multi_message.error_message_exist then
1530: p_return_status := hr_multi_message.get_return_status_disable;
1531: hr_utility.set_location(' Leaving:' || l_proc,20);
1532: --
1533: exception
1534: when hr_multi_message.error_message_exist then
1535: --
1536: -- Catch the Multiple Message List exception which
1537: -- indicates API processing has been aborted because
1538: -- at least one message exists in the list.
1543: --
1544: p_object_version_number := l_object_version_number;
1545: p_start_date := null;
1546: p_end_date := null;
1547: p_return_status := hr_multi_message.get_return_status_disable;
1548: hr_utility.set_location(' Leaving:' || l_proc, 30);
1549: when others then
1550: --
1551: -- When Multiple Message Detection is enabled catch
1554: -- Multiple Message List. Otherwise re-raise the
1555: -- error.
1556: --
1557: rollback to delete_ame_req_attribute_swi;
1558: if hr_multi_message.unexpected_error_add(l_proc) then
1559: hr_utility.set_location(' Leaving:' || l_proc,40);
1560: raise;
1561: end if;
1562: --
1564: --
1565: p_object_version_number := l_object_version_number;
1566: p_start_date := null;
1567: p_end_date := null;
1568: p_return_status := hr_multi_message.get_return_status_disable;
1569: hr_utility.set_location(' Leaving:' || l_proc,50);
1570: end delete_ame_req_attribute;
1571: -- ----------------------------------------------------------------------------
1572: -- |---------------------------< delete_ame_action >--------------------------|
1597: savepoint delete_ame_action_swi;
1598: --
1599: -- Initialise Multiple Message Detection
1600: --
1601: hr_multi_message.enable_message_list;
1602: --
1603: -- Remember IN OUT parameter IN values
1604: --
1605: l_object_version_number := p_object_version_number;
1634: -- Derive the API return status value based on whether
1635: -- messages of any type exist in the Multiple Message List.
1636: -- Also disable Multiple Message Detection.
1637: --
1638: p_return_status := hr_multi_message.get_return_status_disable;
1639: hr_utility.set_location(' Leaving:' || l_proc,20);
1640: --
1641: exception
1642: when hr_multi_message.error_message_exist then
1638: p_return_status := hr_multi_message.get_return_status_disable;
1639: hr_utility.set_location(' Leaving:' || l_proc,20);
1640: --
1641: exception
1642: when hr_multi_message.error_message_exist then
1643: --
1644: -- Catch the Multiple Message List exception which
1645: -- indicates API processing has been aborted because
1646: -- at least one message exists in the list.
1651: --
1652: p_object_version_number := l_object_version_number;
1653: p_start_date := null;
1654: p_end_date := null;
1655: p_return_status := hr_multi_message.get_return_status_disable;
1656: hr_utility.set_location(' Leaving:' || l_proc, 30);
1657: when others then
1658: --
1659: -- When Multiple Message Detection is enabled catch
1662: -- Multiple Message List. Otherwise re-raise the
1663: -- error.
1664: --
1665: rollback to delete_ame_action_swi;
1666: if hr_multi_message.unexpected_error_add(l_proc) then
1667: hr_utility.set_location(' Leaving:' || l_proc,40);
1668: raise;
1669: end if;
1670: --
1672: --
1673: p_object_version_number := l_object_version_number;
1674: p_start_date := null;
1675: p_end_date := null;
1676: p_return_status := hr_multi_message.get_return_status_disable;
1677: hr_utility.set_location(' Leaving:' || l_proc,50);
1678: end delete_ame_action;
1679: end ame_action_swi;