82: THEN NULL;
83: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_tab', 'END igi_sls_objects_pkg.create_sls_tab '||sls_tab||' TABLE ALREADY EXISTS');
84:
85: WHEN OTHERS THEN
86: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
87: retcode := 2;
88: errbuf := Fnd_message.get;
89: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_tab','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
90:
84:
85: WHEN OTHERS THEN
86: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
87: retcode := 2;
88: errbuf := Fnd_message.get;
89: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_tab','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
90:
91: RETURN;
92:
163: */
164:
165: EXCEPTION
166: WHEN OTHERS THEN
167: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
168: retcode := 2;
169: errbuf := Fnd_message.get;
170: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_inx','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
171:
165: EXCEPTION
166: WHEN OTHERS THEN
167: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
168: retcode := 2;
169: errbuf := Fnd_message.get;
170: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_inx','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
171:
172: RETURN;
173:
206: THEN NULL;
207: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_apps_syn','END igi_sls_objects_pkg.create_sls_tab '||sls_tab||' SYNONYM ALREADY EXISTS ON THE '|| schema_name ||' SCHEMA');
208:
209: WHEN OTHERS THEN
210: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
211: retcode := 2;
212: errbuf := Fnd_message.get;
213: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_apps_syn','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
214:
208:
209: WHEN OTHERS THEN
210: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
211: retcode := 2;
212: errbuf := Fnd_message.get;
213: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_apps_syn','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
214:
215: RETURN;
216:
253: THEN NULL;
254: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_mls_syn','END igi_sls_objects_pkg.create_sls_tab '||sls_tab||' SYNONYM ALREADY EXISTS ON THE MLS SCHEMA');
255:
256: WHEN OTHERS THEN
257: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
258: retcode := 2;
259: errbuf := Fnd_message.get;
260: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_mls_syn','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
261:
255:
256: WHEN OTHERS THEN
257: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
258: retcode := 2;
259: errbuf := Fnd_message.get;
260: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_mls_syn','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
261:
262: RETURN;
263:
300: THEN NULL;
301: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_mrc_syn','END igi_sls_objects_pkg.create_sls_tab '||sls_tab||' SYNONYM ALREADY EXISTS ON THE MRC SCHEMA');
302:
303: WHEN OTHERS THEN
304: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
305: retcode := 2;
306: errbuf := Fnd_message.get;
307: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_mrc_syn','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
308:
302:
303: WHEN OTHERS THEN
304: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
305: retcode := 2;
306: errbuf := Fnd_message.get;
307: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_mrc_syn','END igi_sls_objects_pkg.create_sls_tab - failed with error ' || SQLERRM );
308:
309: RETURN;
310:
340: THEN NULL;
341: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_tab','END igi_sls_objects_pkg.drop_sls_tab '||sls_tab||' NO TABLE TO DROP');
342:
343: WHEN OTHERS THEN
344: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
345: retcode := 2;
346: errbuf := Fnd_message.get;
347: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_tab','END igi_sls_objects_pkg.drop_sls_tab - failed with error ' || SQLERRM );
348:
342:
343: WHEN OTHERS THEN
344: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
345: retcode := 2;
346: errbuf := Fnd_message.get;
347: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_tab','END igi_sls_objects_pkg.drop_sls_tab - failed with error ' || SQLERRM );
348:
349: RETURN;
350:
382: THEN NULL;
383: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_apps_syn','END igi_sls_objects_pkg.drop_sls_apps_syn '||sls_tab||' NO SYNONYM TO DROP FROM THE '|| schema_name || 'SCHEMA');
384:
385: WHEN OTHERS THEN
386: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
387: retcode := 2;
388: errbuf := Fnd_message.get;
389: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_apps_syn','END igi_sls_objects_pkg.drop_sls_apps_syn - failed with error ' || SQLERRM );
390:
384:
385: WHEN OTHERS THEN
386: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
387: retcode := 2;
388: errbuf := Fnd_message.get;
389: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_apps_syn','END igi_sls_objects_pkg.drop_sls_apps_syn - failed with error ' || SQLERRM );
390:
391: RETURN;
392:
428: THEN NULL;
429: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_mls_syn','END igi_sls_objects_pkg.drop_sls_mls_syn '||sls_tab||' NO SYNONYM TO DROP FROM THE MLS SCHEMA');
430:
431: WHEN OTHERS THEN
432: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
433: retcode := 2;
434: errbuf := Fnd_message.get;
435: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_mls_syn','END igi_sls_objects_pkg. drop_sls_mls_syn - failed with error ' || SQLERRM );
436:
430:
431: WHEN OTHERS THEN
432: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
433: retcode := 2;
434: errbuf := Fnd_message.get;
435: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_mls_syn','END igi_sls_objects_pkg. drop_sls_mls_syn - failed with error ' || SQLERRM );
436:
437: RETURN;
438:
472: THEN NULL;
473: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_mrc_syn','END igi_sls_objects_pkg.drop_sls_mrc_syn '||sls_tab||' NO SYNONYM TO DROP FROM THE MRC SCHEMA');
474:
475: WHEN OTHERS THEN
476: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
477: retcode := 2;
478: errbuf := Fnd_message.get;
479: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_mrc_syn','END igi_sls_objects_pkg.drop_sls_mrc_syn - failed with error ' || SQLERRM );
480:
474:
475: WHEN OTHERS THEN
476: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
477: retcode := 2;
478: errbuf := Fnd_message.get;
479: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_mrc_syn','END igi_sls_objects_pkg.drop_sls_mrc_syn - failed with error ' || SQLERRM );
480:
481: RETURN;
482:
587:
588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
592: retcode := 2;
593: errbuf := Fnd_message.get;
594: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_trg','END igi_sls_objects_pkg.create sls trigger - failed with error ' || SQLERRM );
595:
589: EXCEPTION
590: WHEN OTHERS THEN
591: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
592: retcode := 2;
593: errbuf := Fnd_message.get;
594: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_trg','END igi_sls_objects_pkg.create sls trigger - failed with error ' || SQLERRM );
595:
596: RETURN;
597:
622: WHEN no_trigger
623: THEN NULL;
624: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_trg','END igi_sls_objects_pkg.drop sls trigger'||sls_tab||'_TRG - NO TRIGGER TO DROP');
625: WHEN OTHERS THEN
626: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
627: retcode := 2;
628: errbuf := Fnd_message.get;
629: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_trg','END igi_sls_objects_pkg.drop sls trigger - failed with error ' || SQLERRM );
630:
624: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_trg','END igi_sls_objects_pkg.drop sls trigger'||sls_tab||'_TRG - NO TRIGGER TO DROP');
625: WHEN OTHERS THEN
626: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
627: retcode := 2;
628: errbuf := Fnd_message.get;
629: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_sls_trg','END igi_sls_objects_pkg.drop sls trigger - failed with error ' || SQLERRM );
630:
631: RETURN;
632:
722:
723: EXCEPTION
724:
725: WHEN OTHERS THEN
726: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
727: retcode := 2;
728: errbuf := Fnd_message.get;
729: igi_sls_objects_pkg .write_to_log(l_excep_level, 'cre_pol_function','END igi_sls_objects_pkg.create policy function - failed with error ' || SQLERRM );
730:
724:
725: WHEN OTHERS THEN
726: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
727: retcode := 2;
728: errbuf := Fnd_message.get;
729: igi_sls_objects_pkg .write_to_log(l_excep_level, 'cre_pol_function','END igi_sls_objects_pkg.create policy function - failed with error ' || SQLERRM );
730:
731: RETURN;
732:
762: THEN NULL;
763: igi_sls_objects_pkg.write_to_log(l_excep_level, 'drop_pol_function','END igi_sls_objects_pkg.drop_pol_function'||sls_tab||'NO FUNCTION TO DROP');
764:
765: WHEN OTHERS THEN
766: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
767: retcode := 2;
768: errbuf := Fnd_message.get;
769: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_pol_function','END igi_sls_objects_pkg.drop_pol_function - failed with error ' || SQLERRM );
770:
764:
765: WHEN OTHERS THEN
766: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
767: retcode := 2;
768: errbuf := Fnd_message.get;
769: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_pol_function','END igi_sls_objects_pkg.drop_pol_function - failed with error ' || SQLERRM );
770:
771: RETURN;
772:
808: THEN NULL;
809: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_add_pol','END igi_sls_objects_pkg.sls_add_pol '||table_name||'POLICY ALREADY EXISTS ON THIS TABLE');
810:
811: WHEN OTHERS THEN
812: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
813: retcode := 2;
814: errbuf := Fnd_message.get;
815: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_add_pol','END igi_sls_objects_pkg.sls_add_pol - failed with error ' || SQLERRM );
816:
810:
811: WHEN OTHERS THEN
812: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
813: retcode := 2;
814: errbuf := Fnd_message.get;
815: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_add_pol','END igi_sls_objects_pkg.sls_add_pol - failed with error ' || SQLERRM );
816:
817: RETURN;
818:
845:
846: WHEN no_policy THEN NULL;
847:
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
850: retcode := 2;
851: errbuf := Fnd_message.get;
852: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_drop_pol','END igi_sls_objects_pkg.sls_drop_pol - failed with error ' || SQLERRM );
853:
847:
848: WHEN OTHERS THEN
849: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
850: retcode := 2;
851: errbuf := Fnd_message.get;
852: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_drop_pol','END igi_sls_objects_pkg.sls_drop_pol - failed with error ' || SQLERRM );
853:
854: RETURN;
855:
881:
882:
883: EXCEPTION
884: WHEN OTHERS THEN
885: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
886: retcode := 2;
887: errbuf := Fnd_message.get;
888: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_refresh_pol','END igi_sls_objects_pkg.sls_refresh_pol - failed with error ' || SQLERRM );
889:
883: EXCEPTION
884: WHEN OTHERS THEN
885: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
886: retcode := 2;
887: errbuf := Fnd_message.get;
888: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_refresh_pol','END igi_sls_objects_pkg.sls_refresh_pol - failed with error ' || SQLERRM );
889:
890: RETURN;
891:
915:
916:
917: EXCEPTION
918: WHEN OTHERS THEN
919: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
920: retcode := 2;
921: errbuf := Fnd_message.get;
922: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_enable_pol','END igi_sls_objects_pkg.sls_enable_pol - failed with error ' || SQLERRM );
923:
917: EXCEPTION
918: WHEN OTHERS THEN
919: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
920: retcode := 2;
921: errbuf := Fnd_message.get;
922: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_enable_pol','END igi_sls_objects_pkg.sls_enable_pol - failed with error ' || SQLERRM );
923:
924: RETURN;
925:
956: WHEN no_policy
957: THEN NULL;
958:
959: WHEN OTHERS THEN
960: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
961: retcode := 2;
962: errbuf := Fnd_message.get;
963: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_disable_pol','END igi_sls_objects_pkg.sls_disable_pol - failed with error ' || SQLERRM );
964:
958:
959: WHEN OTHERS THEN
960: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
961: retcode := 2;
962: errbuf := Fnd_message.get;
963: igi_sls_objects_pkg.write_to_log(l_excep_level, 'sls_disable_pol','END igi_sls_objects_pkg.sls_disable_pol - failed with error ' || SQLERRM );
964:
965: RETURN;
966:
995: NULL;
996:
997: WHEN OTHERS
998: THEN
999: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1000: retcode := 2;
1001: errbuf := Fnd_message.get;
1002: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_col','END igi_sls_objects_pkg.create_sls_col - failed with error ' || SQLERRM );
1003:
997: WHEN OTHERS
998: THEN
999: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1000: retcode := 2;
1001: errbuf := Fnd_message.get;
1002: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_col','END igi_sls_objects_pkg.create_sls_col - failed with error ' || SQLERRM );
1003:
1004: RETURN;
1005:
1060: WHEN col_indexed
1061: THEN
1062: NULL;
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1065: retcode := 2;
1066: errbuf := Fnd_message.get;
1067: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_core_inx','END igi_sls_objects_pkg.create_sls_core_inx - failed with error ' || SQLERRM );
1068:
1062: NULL;
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1065: retcode := 2;
1066: errbuf := Fnd_message.get;
1067: igi_sls_objects_pkg .write_to_log(l_excep_level, 'create_sls_core_inx','END igi_sls_objects_pkg.create_sls_core_inx - failed with error ' || SQLERRM );
1068:
1069: RETURN;
1070:
1095: THEN NULL;
1096:
1097: WHEN OTHERS
1098: THEN
1099: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1100: retcode := 2;
1101: errbuf := Fnd_message.get;
1102: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_col','END igi_sls_objects_pkg.drop_sls_col - failed with error ' || SQLERRM );
1103:
1097: WHEN OTHERS
1098: THEN
1099: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1100: retcode := 2;
1101: errbuf := Fnd_message.get;
1102: igi_sls_objects_pkg .write_to_log(l_excep_level, 'drop_sls_col','END igi_sls_objects_pkg.drop_sls_col - failed with error ' || SQLERRM );
1103:
1104: RETURN;
1105:
1204:
1205:
1206: EXCEPTION
1207: WHEN OTHERS THEN
1208: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1209: retcode := 2;
1210: errbuf := Fnd_message.get;
1211: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_col_trg','END igi_sls_objects_pkg.create sls col trigger - failed with error ' || SQLERRM );
1212:
1206: EXCEPTION
1207: WHEN OTHERS THEN
1208: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1209: retcode := 2;
1210: errbuf := Fnd_message.get;
1211: igi_sls_objects_pkg.write_to_log(l_excep_level, 'create_sls_col_trg','END igi_sls_objects_pkg.create sls col trigger - failed with error ' || SQLERRM );
1212:
1213: RETURN;
1214:
1303:
1304: EXCEPTION
1305:
1306: WHEN OTHERS THEN
1307: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1308: retcode := 2;
1309: errbuf := Fnd_message.get;
1310: igi_sls_objects_pkg .write_to_log(l_excep_level, 'cre_ext_col_pol_func','END igi_sls_objects_pkg.create policy function - failed with error ' || SQLERRM );
1311:
1305:
1306: WHEN OTHERS THEN
1307: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1308: retcode := 2;
1309: errbuf := Fnd_message.get;
1310: igi_sls_objects_pkg .write_to_log(l_excep_level, 'cre_ext_col_pol_func','END igi_sls_objects_pkg.create policy function - failed with error ' || SQLERRM );
1311:
1312: RETURN;
1313: