[Home] [Help]
111: EXCEPTION
112: WHEN OTHERS THEN
113: ROLLBACK;
114: write_to_log(SQLERRM);
115: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
116: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.HERC_TIMESTAMP_EXISTS');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception ;
119: END herc_timestamp_exists;
112: WHEN OTHERS THEN
113: ROLLBACK;
114: write_to_log(SQLERRM);
115: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
116: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.HERC_TIMESTAMP_EXISTS');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception ;
119: END herc_timestamp_exists;
120:
152: EXCEPTION
153: WHEN OTHERS THEN
154: ROLLBACK;
155: write_to_log(SQLERRM);
156: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
157: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.INS_UPD_TIMESTAMP');
158: igs_ge_msg_stack.add;
159: app_exception.raise_exception ;
160: END ins_upd_timestamp;
153: WHEN OTHERS THEN
154: ROLLBACK;
155: write_to_log(SQLERRM);
156: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
157: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.INS_UPD_TIMESTAMP');
158: igs_ge_msg_stack.add;
159: app_exception.raise_exception ;
160: END ins_upd_timestamp;
161:
171: Who When What
172: ***************************************************************** */
173: BEGIN
174: -- log message that this view is being loaded
175: fnd_message.set_name('IGS','IGS_UC_VW_PROCESSING' );
176: fnd_message.set_token('VIEW_NAME', p_view_name ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
177: fnd_file.put_line(fnd_file.Log, fnd_message.get);
178:
179: EXCEPTION
172: ***************************************************************** */
173: BEGIN
174: -- log message that this view is being loaded
175: fnd_message.set_name('IGS','IGS_UC_VW_PROCESSING' );
176: fnd_message.set_token('VIEW_NAME', p_view_name ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
177: fnd_file.put_line(fnd_file.Log, fnd_message.get);
178:
179: EXCEPTION
180: WHEN OTHERS THEN
173: BEGIN
174: -- log message that this view is being loaded
175: fnd_message.set_name('IGS','IGS_UC_VW_PROCESSING' );
176: fnd_message.set_token('VIEW_NAME', p_view_name ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
177: fnd_file.put_line(fnd_file.Log, fnd_message.get);
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: ROLLBACK;
179: EXCEPTION
180: WHEN OTHERS THEN
181: ROLLBACK;
182: write_to_log(SQLERRM);
183: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
184: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOG_START');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception ;
187: END log_start;
180: WHEN OTHERS THEN
181: ROLLBACK;
182: write_to_log(SQLERRM);
183: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
184: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOG_START');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception ;
187: END log_start;
188:
198: Who When What
199: ***************************************************************** */
200: BEGIN
201: -- log message that this view has been succesfully loaded
202: fnd_message.set_name('IGS','IGS_UC_VW_SYNC_COMPLETE' );
203: fnd_message.set_token('VIEW_NAME', p_view_name );
204: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
205:
206: -- log message that p_count number of records have been processed
199: ***************************************************************** */
200: BEGIN
201: -- log message that this view has been succesfully loaded
202: fnd_message.set_name('IGS','IGS_UC_VW_SYNC_COMPLETE' );
203: fnd_message.set_token('VIEW_NAME', p_view_name );
204: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
205:
206: -- log message that p_count number of records have been processed
207: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC' );
200: BEGIN
201: -- log message that this view has been succesfully loaded
202: fnd_message.set_name('IGS','IGS_UC_VW_SYNC_COMPLETE' );
203: fnd_message.set_token('VIEW_NAME', p_view_name );
204: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
205:
206: -- log message that p_count number of records have been processed
207: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC' );
208: fnd_message.set_token('REC_CNT', p_count );
203: fnd_message.set_token('VIEW_NAME', p_view_name );
204: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
205:
206: -- log message that p_count number of records have been processed
207: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC' );
208: fnd_message.set_token('REC_CNT', p_count );
209: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
210:
211:
204: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
205:
206: -- log message that p_count number of records have been processed
207: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC' );
208: fnd_message.set_token('REC_CNT', p_count );
209: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
210:
211:
212: EXCEPTION
205:
206: -- log message that p_count number of records have been processed
207: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC' );
208: fnd_message.set_token('REC_CNT', p_count );
209: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
210:
211:
212: EXCEPTION
213: WHEN OTHERS THEN
212: EXCEPTION
213: WHEN OTHERS THEN
214: ROLLBACK;
215: write_to_log(SQLERRM);
216: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
217: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOG_COMPLETE');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception ;
220: END log_complete;
213: WHEN OTHERS THEN
214: ROLLBACK;
215: write_to_log(SQLERRM);
216: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
217: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOG_COMPLETE');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception ;
220: END log_complete;
221:
231: Who When What
232: ***************************************************************** */
233: BEGIN
234: -- log message that this view has been succesfully loaded
235: fnd_message.set_name('IGS','IGS_UC_VW_ALREADY_IN_SYNC' );
236: fnd_message.set_token('VIEW_NAME', p_view_name );
237: fnd_file.put_line(fnd_file.Log, fnd_message.get) ;
238:
239: EXCEPTION
232: ***************************************************************** */
233: BEGIN
234: -- log message that this view has been succesfully loaded
235: fnd_message.set_name('IGS','IGS_UC_VW_ALREADY_IN_SYNC' );
236: fnd_message.set_token('VIEW_NAME', p_view_name );
237: fnd_file.put_line(fnd_file.Log, fnd_message.get) ;
238:
239: EXCEPTION
240: WHEN OTHERS THEN
233: BEGIN
234: -- log message that this view has been succesfully loaded
235: fnd_message.set_name('IGS','IGS_UC_VW_ALREADY_IN_SYNC' );
236: fnd_message.set_token('VIEW_NAME', p_view_name );
237: fnd_file.put_line(fnd_file.Log, fnd_message.get) ;
238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: ROLLBACK;
239: EXCEPTION
240: WHEN OTHERS THEN
241: ROLLBACK;
242: write_to_log(SQLERRM);
243: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
244: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOG_ALREADY_INSYNC');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception ;
247: END log_already_insync;
240: WHEN OTHERS THEN
241: ROLLBACK;
242: write_to_log(SQLERRM);
243: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
244: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOG_ALREADY_INSYNC');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception ;
247: END log_already_insync;
248:
278: EXCEPTION
279: WHEN OTHERS THEN
280: ROLLBACK;
281: write_to_log(SQLERRM);
282: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
283: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.GET_APPNO');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception ;
286:
279: WHEN OTHERS THEN
280: ROLLBACK;
281: write_to_log(SQLERRM);
282: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
283: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.GET_APPNO');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception ;
286:
287: END get_appno;
316:
317: EXCEPTION
318: WHEN VALUE_ERROR THEN
319: -- log message that this line has not been loaded
320: fnd_message.set_name('IGS','IGS_UC_VAR_VALIDATE' );
321: fnd_message.set_token('VIEW_NAME', p_viewname);
322: fnd_message.set_token('FIELD_NAME', p_fieldname );
323: fnd_message.set_token('FIELD_VALUE', p_value );
324: fnd_message.set_token('DATA_TYPE',p_datatype);
317: EXCEPTION
318: WHEN VALUE_ERROR THEN
319: -- log message that this line has not been loaded
320: fnd_message.set_name('IGS','IGS_UC_VAR_VALIDATE' );
321: fnd_message.set_token('VIEW_NAME', p_viewname);
322: fnd_message.set_token('FIELD_NAME', p_fieldname );
323: fnd_message.set_token('FIELD_VALUE', p_value );
324: fnd_message.set_token('DATA_TYPE',p_datatype);
325: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
318: WHEN VALUE_ERROR THEN
319: -- log message that this line has not been loaded
320: fnd_message.set_name('IGS','IGS_UC_VAR_VALIDATE' );
321: fnd_message.set_token('VIEW_NAME', p_viewname);
322: fnd_message.set_token('FIELD_NAME', p_fieldname );
323: fnd_message.set_token('FIELD_VALUE', p_value );
324: fnd_message.set_token('DATA_TYPE',p_datatype);
325: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
326:
319: -- log message that this line has not been loaded
320: fnd_message.set_name('IGS','IGS_UC_VAR_VALIDATE' );
321: fnd_message.set_token('VIEW_NAME', p_viewname);
322: fnd_message.set_token('FIELD_NAME', p_fieldname );
323: fnd_message.set_token('FIELD_VALUE', p_value );
324: fnd_message.set_token('DATA_TYPE',p_datatype);
325: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
326:
327: return_value := FALSE;
320: fnd_message.set_name('IGS','IGS_UC_VAR_VALIDATE' );
321: fnd_message.set_token('VIEW_NAME', p_viewname);
322: fnd_message.set_token('FIELD_NAME', p_fieldname );
323: fnd_message.set_token('FIELD_VALUE', p_value );
324: fnd_message.set_token('DATA_TYPE',p_datatype);
325: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
326:
327: return_value := FALSE;
328: END;
321: fnd_message.set_token('VIEW_NAME', p_viewname);
322: fnd_message.set_token('FIELD_NAME', p_fieldname );
323: fnd_message.set_token('FIELD_VALUE', p_value );
324: fnd_message.set_token('DATA_TYPE',p_datatype);
325: fnd_file.put_line(fnd_file.Log, fnd_message.get ) ;
326:
327: return_value := FALSE;
328: END;
329:
330: RETURN return_value;
331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
335: fnd_message.set_token('NAME','IGS_UC_LOAD_HERCULES_DATA.IS_VALID - '||SQLERRM);
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338:
331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
335: fnd_message.set_token('NAME','IGS_UC_LOAD_HERCULES_DATA.IS_VALID - '||SQLERRM);
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338:
339: END is_valid;
452: EXCEPTION
453: WHEN OTHERS THEN
454: ROLLBACK;
455: write_to_log(SQLERRM);
456: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
457: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVCOURSE_2003');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception ;
460: END load_cvcourse_2003 ;
453: WHEN OTHERS THEN
454: ROLLBACK;
455: write_to_log(SQLERRM);
456: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
457: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVCOURSE_2003');
458: igs_ge_msg_stack.add;
459: app_exception.raise_exception ;
460: END load_cvcourse_2003 ;
461:
556: EXCEPTION
557: WHEN OTHERS THEN
558: ROLLBACK;
559: write_to_log(SQLERRM);
560: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
561: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVGCOURSE_2007');
562: igs_ge_msg_stack.add;
563: app_exception.raise_exception ;
564: END load_cvgcourse_2007 ;
557: WHEN OTHERS THEN
558: ROLLBACK;
559: write_to_log(SQLERRM);
560: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
561: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVGCOURSE_2007');
562: igs_ge_msg_stack.add;
563: app_exception.raise_exception ;
564: END load_cvgcourse_2007 ;
565:
660: EXCEPTION
661: WHEN OTHERS THEN
662: ROLLBACK;
663: write_to_log(SQLERRM);
664: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
665: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVNCOURSE_2007');
666: igs_ge_msg_stack.add;
667: app_exception.raise_exception ;
668: END load_cvncourse_2007 ;
661: WHEN OTHERS THEN
662: ROLLBACK;
663: write_to_log(SQLERRM);
664: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
665: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVNCOURSE_2007');
666: igs_ge_msg_stack.add;
667: app_exception.raise_exception ;
668: END load_cvncourse_2007 ;
669:
774: EXCEPTION
775: WHEN OTHERS THEN
776: ROLLBACK;
777: write_to_log(SQLERRM);
778: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
779: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVEBLSUBJECT_2003');
780: igs_ge_msg_stack.add;
781: app_exception.raise_exception ;
782: END load_cveblsubject_2003 ;
775: WHEN OTHERS THEN
776: ROLLBACK;
777: write_to_log(SQLERRM);
778: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
779: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVEBLSUBJECT_2003');
780: igs_ge_msg_stack.add;
781: app_exception.raise_exception ;
782: END load_cveblsubject_2003 ;
783:
882: EXCEPTION
883: WHEN OTHERS THEN
884: ROLLBACK;
885: write_to_log(SQLERRM);
886: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
887: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVINSTITUTION_2003');
888: igs_ge_msg_stack.add;
889: app_exception.raise_exception ;
890: END load_cvinstitution_2003 ;
883: WHEN OTHERS THEN
884: ROLLBACK;
885: write_to_log(SQLERRM);
886: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
887: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVINSTITUTION_2003');
888: igs_ge_msg_stack.add;
889: app_exception.raise_exception ;
890: END load_cvinstitution_2003 ;
891:
982: EXCEPTION
983: WHEN OTHERS THEN
984: ROLLBACK;
985: write_to_log(SQLERRM);
986: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
987: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVJOINTADMISSIONS_2003');
988: igs_ge_msg_stack.add;
989: app_exception.raise_exception ;
990: END load_cvjointadmissions_2003 ;
983: WHEN OTHERS THEN
984: ROLLBACK;
985: write_to_log(SQLERRM);
986: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
987: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVJOINTADMISSIONS_2003');
988: igs_ge_msg_stack.add;
989: app_exception.raise_exception ;
990: END load_cvjointadmissions_2003 ;
991:
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: ROLLBACK;
1081: write_to_log(SQLERRM);
1082: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1083: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFAPR_2003');
1084: igs_ge_msg_stack.add;
1085: app_exception.raise_exception ;
1086: END load_cvrefapr_2003 ;
1079: WHEN OTHERS THEN
1080: ROLLBACK;
1081: write_to_log(SQLERRM);
1082: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1083: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFAPR_2003');
1084: igs_ge_msg_stack.add;
1085: app_exception.raise_exception ;
1086: END load_cvrefapr_2003 ;
1087:
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: ROLLBACK;
1176: write_to_log(SQLERRM);
1177: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1178: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFAWARDBODY_2003');
1179: igs_ge_msg_stack.add;
1180: app_exception.raise_exception ;
1181: END load_cvrefawardbody_2003 ;
1174: WHEN OTHERS THEN
1175: ROLLBACK;
1176: write_to_log(SQLERRM);
1177: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1178: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFAWARDBODY_2003');
1179: igs_ge_msg_stack.add;
1180: app_exception.raise_exception ;
1181: END load_cvrefawardbody_2003 ;
1182:
1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: ROLLBACK;
1262: write_to_log(SQLERRM);
1263: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1264: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFDIS_2003');
1265: igs_ge_msg_stack.add;
1266: app_exception.raise_exception ;
1267: END load_cvrefdis_2003 ;
1260: WHEN OTHERS THEN
1261: ROLLBACK;
1262: write_to_log(SQLERRM);
1263: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1264: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFDIS_2003');
1265: igs_ge_msg_stack.add;
1266: app_exception.raise_exception ;
1267: END load_cvrefdis_2003 ;
1268:
1345: EXCEPTION
1346: WHEN OTHERS THEN
1347: ROLLBACK;
1348: write_to_log(SQLERRM);
1349: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1350: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFERROR_2003');
1351: igs_ge_msg_stack.add;
1352: app_exception.raise_exception ;
1353: END load_cvreferror_2003 ;
1346: WHEN OTHERS THEN
1347: ROLLBACK;
1348: write_to_log(SQLERRM);
1349: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1350: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFERROR_2003');
1351: igs_ge_msg_stack.add;
1352: app_exception.raise_exception ;
1353: END load_cvreferror_2003 ;
1354:
1433: EXCEPTION
1434: WHEN OTHERS THEN
1435: ROLLBACK;
1436: write_to_log(SQLERRM);
1437: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1438: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFESTGROUP_2003');
1439: igs_ge_msg_stack.add;
1440: app_exception.raise_exception ;
1441: END load_cvrefestgroup_2003 ;
1434: WHEN OTHERS THEN
1435: ROLLBACK;
1436: write_to_log(SQLERRM);
1437: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1438: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFESTGROUP_2003');
1439: igs_ge_msg_stack.add;
1440: app_exception.raise_exception ;
1441: END load_cvrefestgroup_2003 ;
1442:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: ROLLBACK;
1523: write_to_log(SQLERRM);
1524: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1525: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFETHNIC_2003');
1526: igs_ge_msg_stack.add;
1527: app_exception.raise_exception ;
1528: END load_cvrefethnic_2003 ;
1521: WHEN OTHERS THEN
1522: ROLLBACK;
1523: write_to_log(SQLERRM);
1524: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1525: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFETHNIC_2003');
1526: igs_ge_msg_stack.add;
1527: app_exception.raise_exception ;
1528: END load_cvrefethnic_2003 ;
1529:
1606: EXCEPTION
1607: WHEN OTHERS THEN
1608: ROLLBACK;
1609: write_to_log(SQLERRM);
1610: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1611: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFEXAM_2003');
1612: igs_ge_msg_stack.add;
1613: app_exception.raise_exception ;
1614: END load_cvrefexam_2003 ;
1607: WHEN OTHERS THEN
1608: ROLLBACK;
1609: write_to_log(SQLERRM);
1610: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1611: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFEXAM_2003');
1612: igs_ge_msg_stack.add;
1613: app_exception.raise_exception ;
1614: END load_cvrefexam_2003 ;
1615:
1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: ROLLBACK;
1695: write_to_log(SQLERRM);
1696: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1697: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFFEE_2003');
1698: igs_ge_msg_stack.add;
1699: app_exception.raise_exception ;
1700: END load_cvreffee_2003 ;
1693: WHEN OTHERS THEN
1694: ROLLBACK;
1695: write_to_log(SQLERRM);
1696: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1697: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFFEE_2003');
1698: igs_ge_msg_stack.add;
1699: app_exception.raise_exception ;
1700: END load_cvreffee_2003 ;
1701:
1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: ROLLBACK;
1776: write_to_log(SQLERRM);
1777: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1778: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFKEYWORD_2003');
1779: igs_ge_msg_stack.add;
1780: app_exception.raise_exception ;
1781: END load_cvrefkeyword_2003 ;
1774: WHEN OTHERS THEN
1775: ROLLBACK;
1776: write_to_log(SQLERRM);
1777: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1778: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFKEYWORD_2003');
1779: igs_ge_msg_stack.add;
1780: app_exception.raise_exception ;
1781: END load_cvrefkeyword_2003 ;
1782:
1859: EXCEPTION
1860: WHEN OTHERS THEN
1861: ROLLBACK;
1862: write_to_log(SQLERRM);
1863: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1864: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFOEQ_2003');
1865: igs_ge_msg_stack.add;
1866: app_exception.raise_exception ;
1867: END load_cvrefoeq_2003 ;
1860: WHEN OTHERS THEN
1861: ROLLBACK;
1862: write_to_log(SQLERRM);
1863: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1864: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFOEQ_2003');
1865: igs_ge_msg_stack.add;
1866: app_exception.raise_exception ;
1867: END load_cvrefoeq_2003 ;
1868:
1961: EXCEPTION
1962: WHEN OTHERS THEN
1963: ROLLBACK;
1964: write_to_log(SQLERRM);
1965: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1966: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFOFFERABBREV_2003');
1967: igs_ge_msg_stack.add;
1968: app_exception.raise_exception ;
1969: END load_cvrefofferabbrev_2003 ;
1962: WHEN OTHERS THEN
1963: ROLLBACK;
1964: write_to_log(SQLERRM);
1965: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1966: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFOFFERABBREV_2003');
1967: igs_ge_msg_stack.add;
1968: app_exception.raise_exception ;
1969: END load_cvrefofferabbrev_2003 ;
1970:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: ROLLBACK;
2051: write_to_log(SQLERRM);
2052: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2053: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFOFFERSUBJ_2003');
2054: igs_ge_msg_stack.add;
2055: app_exception.raise_exception ;
2056: END load_cvrefoffersubj_2003 ;
2049: WHEN OTHERS THEN
2050: ROLLBACK;
2051: write_to_log(SQLERRM);
2052: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2053: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFOFFERSUBJ_2003');
2054: igs_ge_msg_stack.add;
2055: app_exception.raise_exception ;
2056: END load_cvrefoffersubj_2003 ;
2057:
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: ROLLBACK;
2159: write_to_log(SQLERRM);
2160: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2161: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFPOCC_2003');
2162: igs_ge_msg_stack.add;
2163: app_exception.raise_exception ;
2164: END load_cvrefpocc_2003 ;
2157: WHEN OTHERS THEN
2158: ROLLBACK;
2159: write_to_log(SQLERRM);
2160: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2161: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFPOCC_2003');
2162: igs_ge_msg_stack.add;
2163: app_exception.raise_exception ;
2164: END load_cvrefpocc_2003 ;
2165:
2242: EXCEPTION
2243: WHEN OTHERS THEN
2244: ROLLBACK;
2245: write_to_log(SQLERRM);
2246: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2247: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFRESCAT_2003');
2248: igs_ge_msg_stack.add;
2249: app_exception.raise_exception ;
2250: END load_cvrefrescat_2003 ;
2243: WHEN OTHERS THEN
2244: ROLLBACK;
2245: write_to_log(SQLERRM);
2246: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2247: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFRESCAT_2003');
2248: igs_ge_msg_stack.add;
2249: app_exception.raise_exception ;
2250: END load_cvrefrescat_2003 ;
2251:
2328: EXCEPTION
2329: WHEN OTHERS THEN
2330: ROLLBACK;
2331: write_to_log(SQLERRM);
2332: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2333: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSCHOOLTYPE_2003');
2334: igs_ge_msg_stack.add;
2335: app_exception.raise_exception ;
2336: END load_cvrefschooltype_2003 ;
2329: WHEN OTHERS THEN
2330: ROLLBACK;
2331: write_to_log(SQLERRM);
2332: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2333: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSCHOOLTYPE_2003');
2334: igs_ge_msg_stack.add;
2335: app_exception.raise_exception ;
2336: END load_cvrefschooltype_2003 ;
2337:
2414: EXCEPTION
2415: WHEN OTHERS THEN
2416: ROLLBACK;
2417: write_to_log(SQLERRM);
2418: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2419: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSTATUS_2003');
2420: igs_ge_msg_stack.add;
2421: app_exception.raise_exception ;
2422: END load_cvrefstatus_2003 ;
2415: WHEN OTHERS THEN
2416: ROLLBACK;
2417: write_to_log(SQLERRM);
2418: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2419: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSTATUS_2003');
2420: igs_ge_msg_stack.add;
2421: app_exception.raise_exception ;
2422: END load_cvrefstatus_2003 ;
2423:
2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: ROLLBACK;
2504: write_to_log(SQLERRM);
2505: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2506: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFTARIFF_2003');
2507: igs_ge_msg_stack.add;
2508: app_exception.raise_exception ;
2509: END load_cvreftariff_2003 ;
2502: WHEN OTHERS THEN
2503: ROLLBACK;
2504: write_to_log(SQLERRM);
2505: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2506: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFTARIFF_2003');
2507: igs_ge_msg_stack.add;
2508: app_exception.raise_exception ;
2509: END load_cvreftariff_2003 ;
2510:
2587: EXCEPTION
2588: WHEN OTHERS THEN
2589: ROLLBACK;
2590: write_to_log(SQLERRM);
2591: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2592: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFUCASGROUP_2003');
2593: igs_ge_msg_stack.add;
2594: app_exception.raise_exception ;
2595: END load_cvrefucasgroup_2003 ;
2588: WHEN OTHERS THEN
2589: ROLLBACK;
2590: write_to_log(SQLERRM);
2591: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2592: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFUCASGROUP_2003');
2593: igs_ge_msg_stack.add;
2594: app_exception.raise_exception ;
2595: END load_cvrefucasgroup_2003 ;
2596:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: ROLLBACK;
2765: write_to_log(SQLERRM);
2766: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2767: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVSCHOOL_2003');
2768: igs_ge_msg_stack.add;
2769: app_exception.raise_exception ;
2770: END load_cvschool_2003 ;
2763: WHEN OTHERS THEN
2764: ROLLBACK;
2765: write_to_log(SQLERRM);
2766: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2767: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVSCHOOL_2003');
2768: igs_ge_msg_stack.add;
2769: app_exception.raise_exception ;
2770: END load_cvschool_2003 ;
2771:
2901: EXCEPTION
2902: WHEN OTHERS THEN
2903: ROLLBACK;
2904: write_to_log(SQLERRM);
2905: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2906: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVSCHOOLCONTACT_2003');
2907: igs_ge_msg_stack.add;
2908: app_exception.raise_exception ;
2909: END load_cvschoolcontact_2003 ;
2902: WHEN OTHERS THEN
2903: ROLLBACK;
2904: write_to_log(SQLERRM);
2905: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2906: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVSCHOOLCONTACT_2003');
2907: igs_ge_msg_stack.add;
2908: app_exception.raise_exception ;
2909: END load_cvschoolcontact_2003 ;
2910:
3021: EXCEPTION
3022: WHEN OTHERS THEN
3023: ROLLBACK;
3024: write_to_log(SQLERRM);
3025: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3026: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCONTACT_2003');
3027: igs_ge_msg_stack.add;
3028: app_exception.raise_exception ;
3029: END load_uvcontact_2003 ;
3022: WHEN OTHERS THEN
3023: ROLLBACK;
3024: write_to_log(SQLERRM);
3025: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3026: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCONTACT_2003');
3027: igs_ge_msg_stack.add;
3028: app_exception.raise_exception ;
3029: END load_uvcontact_2003 ;
3030:
3118: EXCEPTION
3119: WHEN OTHERS THEN
3120: ROLLBACK;
3121: write_to_log(SQLERRM);
3122: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3123: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCONTGRP_2003');
3124: igs_ge_msg_stack.add;
3125: app_exception.raise_exception ;
3126: END load_uvcontgrp_2003 ;
3119: WHEN OTHERS THEN
3120: ROLLBACK;
3121: write_to_log(SQLERRM);
3122: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3123: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCONTGRP_2003');
3124: igs_ge_msg_stack.add;
3125: app_exception.raise_exception ;
3126: END load_uvcontgrp_2003 ;
3127:
3261: EXCEPTION
3262: WHEN OTHERS THEN
3263: ROLLBACK;
3264: write_to_log(SQLERRM);
3265: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3266: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSE_2003');
3267: igs_ge_msg_stack.add;
3268: app_exception.raise_exception ;
3269: END load_uvcourse_2003 ;
3262: WHEN OTHERS THEN
3263: ROLLBACK;
3264: write_to_log(SQLERRM);
3265: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3266: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSE_2003');
3267: igs_ge_msg_stack.add;
3268: app_exception.raise_exception ;
3269: END load_uvcourse_2003 ;
3270:
3385: EXCEPTION
3386: WHEN OTHERS THEN
3387: ROLLBACK;
3388: write_to_log(SQLERRM);
3389: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3390: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSEKEYWORD_2003');
3391: igs_ge_msg_stack.add;
3392: app_exception.raise_exception ;
3393: END load_uvcoursekeyword_2003 ;
3386: WHEN OTHERS THEN
3387: ROLLBACK;
3388: write_to_log(SQLERRM);
3389: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3390: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSEKEYWORD_2003');
3391: igs_ge_msg_stack.add;
3392: app_exception.raise_exception ;
3393: END load_uvcoursekeyword_2003 ;
3394:
3503: EXCEPTION
3504: WHEN OTHERS THEN
3505: ROLLBACK;
3506: write_to_log(SQLERRM);
3507: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3508: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSEVACANCIES_2003');
3509: igs_ge_msg_stack.add;
3510: app_exception.raise_exception ;
3511: END load_uvcoursevacancies_2003 ;
3504: WHEN OTHERS THEN
3505: ROLLBACK;
3506: write_to_log(SQLERRM);
3507: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3508: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSEVACANCIES_2003');
3509: igs_ge_msg_stack.add;
3510: app_exception.raise_exception ;
3511: END load_uvcoursevacancies_2003 ;
3512:
3612: EXCEPTION
3613: WHEN OTHERS THEN
3614: ROLLBACK;
3615: write_to_log(SQLERRM);
3616: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3617: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSEVACOPTIONS_2003');
3618: igs_ge_msg_stack.add;
3619: app_exception.raise_exception ;
3620: END load_uvcoursevacoptions_2003 ;
3613: WHEN OTHERS THEN
3614: ROLLBACK;
3615: write_to_log(SQLERRM);
3616: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3617: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVCOURSEVACOPTIONS_2003');
3618: igs_ge_msg_stack.add;
3619: app_exception.raise_exception ;
3620: END load_uvcoursevacoptions_2003 ;
3621:
3834: EXCEPTION
3835: WHEN OTHERS THEN
3836: ROLLBACK;
3837: write_to_log(SQLERRM);
3838: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3839: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVINSTITUTION_2003');
3840: igs_ge_msg_stack.add;
3841: app_exception.raise_exception ;
3842: END load_uvinstitution_2003 ;
3835: WHEN OTHERS THEN
3836: ROLLBACK;
3837: write_to_log(SQLERRM);
3838: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3839: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVINSTITUTION_2003');
3840: igs_ge_msg_stack.add;
3841: app_exception.raise_exception ;
3842: END load_uvinstitution_2003 ;
3843:
3943: EXCEPTION
3944: WHEN OTHERS THEN
3945: ROLLBACK;
3946: write_to_log(SQLERRM);
3947: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3948: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVOFFERABBREV_2003');
3949: igs_ge_msg_stack.add;
3950: app_exception.raise_exception ;
3951: END load_uvofferabbrev_2003 ;
3944: WHEN OTHERS THEN
3945: ROLLBACK;
3946: write_to_log(SQLERRM);
3947: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3948: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVOFFERABBREV_2003');
3949: igs_ge_msg_stack.add;
3950: app_exception.raise_exception ;
3951: END load_uvofferabbrev_2003 ;
3952:
4025: EXCEPTION
4026: WHEN OTHERS THEN
4027: ROLLBACK;
4028: write_to_log(SQLERRM);
4029: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4030: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFPRE2000POCC_2003');
4031: igs_ge_msg_stack.add;
4032: app_exception.raise_exception ;
4033: END load_cvrefpre2000pocc_2003 ;
4026: WHEN OTHERS THEN
4027: ROLLBACK;
4028: write_to_log(SQLERRM);
4029: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4030: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFPRE2000POCC_2003');
4031: igs_ge_msg_stack.add;
4032: app_exception.raise_exception ;
4033: END load_cvrefpre2000pocc_2003 ;
4034:
4096: EXCEPTION
4097: WHEN OTHERS THEN
4098: ROLLBACK;
4099: write_to_log(SQLERRM);
4100: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4101: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSOCIALCLASS_2003');
4102: igs_ge_msg_stack.add;
4103: app_exception.raise_exception ;
4104: END load_cvrefsocialclass_2003 ;
4097: WHEN OTHERS THEN
4098: ROLLBACK;
4099: write_to_log(SQLERRM);
4100: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4101: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSOCIALCLASS_2003');
4102: igs_ge_msg_stack.add;
4103: app_exception.raise_exception ;
4104: END load_cvrefsocialclass_2003 ;
4105:
4167: EXCEPTION
4168: WHEN OTHERS THEN
4169: ROLLBACK;
4170: write_to_log(SQLERRM);
4171: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4172: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSOCIOECONOMIC_2003');
4173: igs_ge_msg_stack.add;
4174: app_exception.raise_exception ;
4175: END load_cvrefsocioeconomic_2003 ;
4168: WHEN OTHERS THEN
4169: ROLLBACK;
4170: write_to_log(SQLERRM);
4171: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4172: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSOCIOECONOMIC_2003');
4173: igs_ge_msg_stack.add;
4174: app_exception.raise_exception ;
4175: END load_cvrefsocioeconomic_2003 ;
4176:
4243: EXCEPTION
4244: WHEN OTHERS THEN
4245: ROLLBACK;
4246: write_to_log(SQLERRM);
4247: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4248: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSUBJ_2003');
4249: igs_ge_msg_stack.add;
4250: app_exception.raise_exception ;
4251: END load_cvrefsubj_2003 ;
4244: WHEN OTHERS THEN
4245: ROLLBACK;
4246: write_to_log(SQLERRM);
4247: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4248: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFSUBJ_2003');
4249: igs_ge_msg_stack.add;
4250: app_exception.raise_exception ;
4251: END load_cvrefsubj_2003 ;
4252:
4331: EXCEPTION
4332: WHEN OTHERS THEN
4333: ROLLBACK;
4334: write_to_log(SQLERRM);
4335: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4336: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFCOUNTRY_2007');
4337: igs_ge_msg_stack.add;
4338: app_exception.raise_exception ;
4339: END load_cvrefcountry_2007 ;
4332: WHEN OTHERS THEN
4333: ROLLBACK;
4334: write_to_log(SQLERRM);
4335: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4336: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFCOUNTRY_2007');
4337: igs_ge_msg_stack.add;
4338: app_exception.raise_exception ;
4339: END load_cvrefcountry_2007 ;
4340:
4418: EXCEPTION
4419: WHEN OTHERS THEN
4420: ROLLBACK;
4421: write_to_log(SQLERRM);
4422: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4423: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFNATIONALITY_2007');
4424: igs_ge_msg_stack.add;
4425: app_exception.raise_exception ;
4426: END load_cvrefnationality_2007 ;
4419: WHEN OTHERS THEN
4420: ROLLBACK;
4421: write_to_log(SQLERRM);
4422: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4423: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVREFNATIONALITY_2007');
4424: igs_ge_msg_stack.add;
4425: app_exception.raise_exception ;
4426: END load_cvrefnationality_2007 ;
4427:
4508: EXCEPTION
4509: WHEN OTHERS THEN
4510: ROLLBACK;
4511: write_to_log(SQLERRM);
4512: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4513: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVGREFDEGREESUBJ_2006');
4514: igs_ge_msg_stack.add;
4515: app_exception.raise_exception ;
4516: END load_cvgrefdegreesubj_2006 ;
4509: WHEN OTHERS THEN
4510: ROLLBACK;
4511: write_to_log(SQLERRM);
4512: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4513: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_CVGREFDEGREESUBJ_2006');
4514: igs_ge_msg_stack.add;
4515: app_exception.raise_exception ;
4516: END load_cvgrefdegreesubj_2006 ;
4517:
4636: EXCEPTION
4637: WHEN OTHERS THEN
4638: ROLLBACK;
4639: write_to_log(SQLERRM);
4640: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4641: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVOFFER_2003');
4642: igs_ge_msg_stack.add;
4643: app_exception.raise_exception ;
4644: END load_ivoffer_2003 ;
4637: WHEN OTHERS THEN
4638: ROLLBACK;
4639: write_to_log(SQLERRM);
4640: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4641: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVOFFER_2003');
4642: igs_ge_msg_stack.add;
4643: app_exception.raise_exception ;
4644: END load_ivoffer_2003 ;
4645:
4745: EXCEPTION
4746: WHEN OTHERS THEN
4747: ROLLBACK;
4748: write_to_log(SQLERRM);
4749: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4750: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGOFFER_2006');
4751: igs_ge_msg_stack.add;
4752: app_exception.raise_exception ;
4753: END load_ivgoffer_2006 ;
4746: WHEN OTHERS THEN
4747: ROLLBACK;
4748: write_to_log(SQLERRM);
4749: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4750: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGOFFER_2006');
4751: igs_ge_msg_stack.add;
4752: app_exception.raise_exception ;
4753: END load_ivgoffer_2006 ;
4754:
4854: EXCEPTION
4855: WHEN OTHERS THEN
4856: ROLLBACK;
4857: write_to_log(SQLERRM);
4858: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4859: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNOFFER_2006');
4860: igs_ge_msg_stack.add;
4861: app_exception.raise_exception ;
4862: END load_ivnoffer_2006 ;
4855: WHEN OTHERS THEN
4856: ROLLBACK;
4857: write_to_log(SQLERRM);
4858: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4859: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNOFFER_2006');
4860: igs_ge_msg_stack.add;
4861: app_exception.raise_exception ;
4862: END load_ivnoffer_2006 ;
4863:
4981: EXCEPTION
4982: WHEN OTHERS THEN
4983: ROLLBACK;
4984: write_to_log(SQLERRM);
4985: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4986: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVQUALIFICATION_2003');
4987: igs_ge_msg_stack.add;
4988: app_exception.raise_exception ;
4989: END load_ivqualification_2003 ;
4982: WHEN OTHERS THEN
4983: ROLLBACK;
4984: write_to_log(SQLERRM);
4985: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4986: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVQUALIFICATION_2003');
4987: igs_ge_msg_stack.add;
4988: app_exception.raise_exception ;
4989: END load_ivqualification_2003 ;
4990:
5125: EXCEPTION
5126: WHEN OTHERS THEN
5127: ROLLBACK;
5128: write_to_log(SQLERRM);
5129: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5130: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARA_2003');
5131: igs_ge_msg_stack.add;
5132: app_exception.raise_exception ;
5133: END load_ivstara_2003 ;
5126: WHEN OTHERS THEN
5127: ROLLBACK;
5128: write_to_log(SQLERRM);
5129: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5130: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARA_2003');
5131: igs_ge_msg_stack.add;
5132: app_exception.raise_exception ;
5133: END load_ivstara_2003 ;
5134:
5267: EXCEPTION
5268: WHEN OTHERS THEN
5269: ROLLBACK;
5270: write_to_log(SQLERRM);
5271: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5272: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARA_2006');
5273: igs_ge_msg_stack.add;
5274: app_exception.raise_exception ;
5275: END load_ivstara_2006 ;
5268: WHEN OTHERS THEN
5269: ROLLBACK;
5270: write_to_log(SQLERRM);
5271: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5272: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARA_2006');
5273: igs_ge_msg_stack.add;
5274: app_exception.raise_exception ;
5275: END load_ivstara_2006 ;
5276:
5417: EXCEPTION
5418: WHEN OTHERS THEN
5419: ROLLBACK;
5420: write_to_log(SQLERRM);
5421: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5422: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARA_2007');
5423: igs_ge_msg_stack.add;
5424: app_exception.raise_exception ;
5425: END load_ivstara_2007 ;
5418: WHEN OTHERS THEN
5419: ROLLBACK;
5420: write_to_log(SQLERRM);
5421: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5422: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARA_2007');
5423: igs_ge_msg_stack.add;
5424: app_exception.raise_exception ;
5425: END load_ivstara_2007 ;
5426:
5547: EXCEPTION
5548: WHEN OTHERS THEN
5549: ROLLBACK;
5550: write_to_log(SQLERRM);
5551: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5552: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARA_2006');
5553: igs_ge_msg_stack.add;
5554: app_exception.raise_exception ;
5555: END load_ivgstara_2006 ;
5548: WHEN OTHERS THEN
5549: ROLLBACK;
5550: write_to_log(SQLERRM);
5551: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5552: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARA_2006');
5553: igs_ge_msg_stack.add;
5554: app_exception.raise_exception ;
5555: END load_ivgstara_2006 ;
5556:
5698: EXCEPTION
5699: WHEN OTHERS THEN
5700: ROLLBACK;
5701: write_to_log(SQLERRM);
5702: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5703: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARA_2007');
5704: igs_ge_msg_stack.add;
5705: app_exception.raise_exception ;
5706: END load_ivgstara_2007 ;
5699: WHEN OTHERS THEN
5700: ROLLBACK;
5701: write_to_log(SQLERRM);
5702: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5703: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARA_2007');
5704: igs_ge_msg_stack.add;
5705: app_exception.raise_exception ;
5706: END load_ivgstara_2007 ;
5707:
5828: EXCEPTION
5829: WHEN OTHERS THEN
5830: ROLLBACK;
5831: write_to_log(SQLERRM);
5832: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5833: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARA_2006');
5834: igs_ge_msg_stack.add;
5835: app_exception.raise_exception ;
5836: END load_ivnstara_2006 ;
5829: WHEN OTHERS THEN
5830: ROLLBACK;
5831: write_to_log(SQLERRM);
5832: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5833: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARA_2006');
5834: igs_ge_msg_stack.add;
5835: app_exception.raise_exception ;
5836: END load_ivnstara_2006 ;
5837:
5979: EXCEPTION
5980: WHEN OTHERS THEN
5981: ROLLBACK;
5982: write_to_log(SQLERRM);
5983: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5984: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARA_2007');
5985: igs_ge_msg_stack.add;
5986: app_exception.raise_exception ;
5987: END load_ivnstara_2007 ;
5980: WHEN OTHERS THEN
5981: ROLLBACK;
5982: write_to_log(SQLERRM);
5983: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5984: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARA_2007');
5985: igs_ge_msg_stack.add;
5986: app_exception.raise_exception ;
5987: END load_ivnstara_2007 ;
5988:
6171: EXCEPTION
6172: WHEN OTHERS THEN
6173: ROLLBACK;
6174: write_to_log(SQLERRM);
6175: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6176: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARC_2003');
6177: igs_ge_msg_stack.add;
6178: app_exception.raise_exception ;
6179: END load_ivstarc_2003 ;
6172: WHEN OTHERS THEN
6173: ROLLBACK;
6174: write_to_log(SQLERRM);
6175: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6176: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARC_2003');
6177: igs_ge_msg_stack.add;
6178: app_exception.raise_exception ;
6179: END load_ivstarc_2003 ;
6180:
6336: EXCEPTION
6337: WHEN OTHERS THEN
6338: ROLLBACK;
6339: write_to_log(SQLERRM);
6340: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6341: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARC_2006');
6342: igs_ge_msg_stack.add;
6343: app_exception.raise_exception ;
6344: END load_ivnstarc_2006 ;
6337: WHEN OTHERS THEN
6338: ROLLBACK;
6339: write_to_log(SQLERRM);
6340: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6341: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARC_2006');
6342: igs_ge_msg_stack.add;
6343: app_exception.raise_exception ;
6344: END load_ivnstarc_2006 ;
6345:
6505: EXCEPTION
6506: WHEN OTHERS THEN
6507: ROLLBACK;
6508: write_to_log(SQLERRM);
6509: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6510: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARG_2006');
6511: igs_ge_msg_stack.add;
6512: app_exception.raise_exception ;
6513: END load_ivgstarg_2006 ;
6506: WHEN OTHERS THEN
6507: ROLLBACK;
6508: write_to_log(SQLERRM);
6509: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6510: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARG_2006');
6511: igs_ge_msg_stack.add;
6512: app_exception.raise_exception ;
6513: END load_ivgstarg_2006 ;
6514:
6640: EXCEPTION
6641: WHEN OTHERS THEN
6642: ROLLBACK;
6643: write_to_log(SQLERRM);
6644: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6645: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARH_2003');
6646: igs_ge_msg_stack.add;
6647: app_exception.raise_exception ;
6648: END load_ivstarh_2003 ;
6641: WHEN OTHERS THEN
6642: ROLLBACK;
6643: write_to_log(SQLERRM);
6644: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6645: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARH_2003');
6646: igs_ge_msg_stack.add;
6647: app_exception.raise_exception ;
6648: END load_ivstarh_2003 ;
6649:
6746: EXCEPTION
6747: WHEN OTHERS THEN
6748: ROLLBACK;
6749: write_to_log(SQLERRM);
6750: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6751: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARH_2006');
6752: igs_ge_msg_stack.add;
6753: app_exception.raise_exception ;
6754: END load_ivgstarh_2006 ;
6747: WHEN OTHERS THEN
6748: ROLLBACK;
6749: write_to_log(SQLERRM);
6750: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6751: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARH_2006');
6752: igs_ge_msg_stack.add;
6753: app_exception.raise_exception ;
6754: END load_ivgstarh_2006 ;
6755:
6858: EXCEPTION
6859: WHEN OTHERS THEN
6860: ROLLBACK;
6861: write_to_log(SQLERRM);
6862: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6863: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARH_2006');
6864: igs_ge_msg_stack.add;
6865: app_exception.raise_exception ;
6866: END load_ivnstarh_2006 ;
6859: WHEN OTHERS THEN
6860: ROLLBACK;
6861: write_to_log(SQLERRM);
6862: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6863: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARH_2006');
6864: igs_ge_msg_stack.add;
6865: app_exception.raise_exception ;
6866: END load_ivnstarh_2006 ;
6867:
7153: EXCEPTION
7154: WHEN OTHERS THEN
7155: ROLLBACK;
7156: write_to_log(SQLERRM);
7157: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7158: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARK_2003');
7159: igs_ge_msg_stack.add;
7160: app_exception.raise_exception ;
7161: END load_ivstark_2003 ;
7154: WHEN OTHERS THEN
7155: ROLLBACK;
7156: write_to_log(SQLERRM);
7157: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7158: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARK_2003');
7159: igs_ge_msg_stack.add;
7160: app_exception.raise_exception ;
7161: END load_ivstark_2003 ;
7162:
7447: EXCEPTION
7448: WHEN OTHERS THEN
7449: ROLLBACK;
7450: write_to_log(SQLERRM);
7451: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7452: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARK_2007');
7453: igs_ge_msg_stack.add;
7454: app_exception.raise_exception ;
7455: END load_ivstark_2007 ;
7448: WHEN OTHERS THEN
7449: ROLLBACK;
7450: write_to_log(SQLERRM);
7451: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7452: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARK_2007');
7453: igs_ge_msg_stack.add;
7454: app_exception.raise_exception ;
7455: END load_ivstark_2007 ;
7456:
7599: EXCEPTION
7600: WHEN OTHERS THEN
7601: ROLLBACK;
7602: write_to_log(SQLERRM);
7603: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7604: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARK_2006');
7605: igs_ge_msg_stack.add;
7606: app_exception.raise_exception ;
7607: END load_ivgstark_2006 ;
7600: WHEN OTHERS THEN
7601: ROLLBACK;
7602: write_to_log(SQLERRM);
7603: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7604: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARK_2006');
7605: igs_ge_msg_stack.add;
7606: app_exception.raise_exception ;
7607: END load_ivgstark_2006 ;
7608:
7751: EXCEPTION
7752: WHEN OTHERS THEN
7753: ROLLBACK;
7754: write_to_log(SQLERRM);
7755: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7756: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARK_2007');
7757: igs_ge_msg_stack.add;
7758: app_exception.raise_exception ;
7759: END load_ivgstark_2007 ;
7752: WHEN OTHERS THEN
7753: ROLLBACK;
7754: write_to_log(SQLERRM);
7755: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7756: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARK_2007');
7757: igs_ge_msg_stack.add;
7758: app_exception.raise_exception ;
7759: END load_ivgstark_2007 ;
7760:
7941: EXCEPTION
7942: WHEN OTHERS THEN
7943: ROLLBACK;
7944: write_to_log(SQLERRM);
7945: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7946: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARK_2006');
7947: igs_ge_msg_stack.add;
7948: app_exception.raise_exception ;
7949: END load_ivnstark_2006 ;
7942: WHEN OTHERS THEN
7943: ROLLBACK;
7944: write_to_log(SQLERRM);
7945: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7946: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARK_2006');
7947: igs_ge_msg_stack.add;
7948: app_exception.raise_exception ;
7949: END load_ivnstark_2006 ;
7950:
8131: EXCEPTION
8132: WHEN OTHERS THEN
8133: ROLLBACK;
8134: write_to_log(SQLERRM);
8135: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8136: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARK_2007');
8137: igs_ge_msg_stack.add;
8138: app_exception.raise_exception ;
8139: END load_ivnstark_2007 ;
8132: WHEN OTHERS THEN
8133: ROLLBACK;
8134: write_to_log(SQLERRM);
8135: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8136: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARK_2007');
8137: igs_ge_msg_stack.add;
8138: app_exception.raise_exception ;
8139: END load_ivnstark_2007 ;
8140:
8259: EXCEPTION
8260: WHEN OTHERS THEN
8261: ROLLBACK;
8262: write_to_log(SQLERRM);
8263: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8264: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARN_2003');
8265: igs_ge_msg_stack.add;
8266: app_exception.raise_exception ;
8267: END load_ivstarn_2003 ;
8260: WHEN OTHERS THEN
8261: ROLLBACK;
8262: write_to_log(SQLERRM);
8263: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8264: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARN_2003');
8265: igs_ge_msg_stack.add;
8266: app_exception.raise_exception ;
8267: END load_ivstarn_2003 ;
8268:
8390: EXCEPTION
8391: WHEN OTHERS THEN
8392: ROLLBACK;
8393: write_to_log(SQLERRM);
8394: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8395: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARN_2007');
8396: igs_ge_msg_stack.add;
8397: app_exception.raise_exception ;
8398: END load_ivstarn_2007 ;
8391: WHEN OTHERS THEN
8392: ROLLBACK;
8393: write_to_log(SQLERRM);
8394: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8395: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARN_2007');
8396: igs_ge_msg_stack.add;
8397: app_exception.raise_exception ;
8398: END load_ivstarn_2007 ;
8399:
8514: EXCEPTION
8515: WHEN OTHERS THEN
8516: ROLLBACK;
8517: write_to_log(SQLERRM);
8518: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8519: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARN_2006');
8520: igs_ge_msg_stack.add;
8521: app_exception.raise_exception ;
8522: END load_ivgstarn_2006 ;
8515: WHEN OTHERS THEN
8516: ROLLBACK;
8517: write_to_log(SQLERRM);
8518: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8519: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARN_2006');
8520: igs_ge_msg_stack.add;
8521: app_exception.raise_exception ;
8522: END load_ivgstarn_2006 ;
8523:
8640: EXCEPTION
8641: WHEN OTHERS THEN
8642: ROLLBACK;
8643: write_to_log(SQLERRM);
8644: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8645: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARN_2007');
8646: igs_ge_msg_stack.add;
8647: app_exception.raise_exception ;
8648: END load_ivgstarn_2007 ;
8641: WHEN OTHERS THEN
8642: ROLLBACK;
8643: write_to_log(SQLERRM);
8644: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8645: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARN_2007');
8646: igs_ge_msg_stack.add;
8647: app_exception.raise_exception ;
8648: END load_ivgstarn_2007 ;
8649:
8764: EXCEPTION
8765: WHEN OTHERS THEN
8766: ROLLBACK;
8767: write_to_log(SQLERRM);
8768: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8769: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARN_2006');
8770: igs_ge_msg_stack.add;
8771: app_exception.raise_exception ;
8772: END load_ivnstarn_2006 ;
8765: WHEN OTHERS THEN
8766: ROLLBACK;
8767: write_to_log(SQLERRM);
8768: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8769: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARN_2006');
8770: igs_ge_msg_stack.add;
8771: app_exception.raise_exception ;
8772: END load_ivnstarn_2006 ;
8773:
8890: EXCEPTION
8891: WHEN OTHERS THEN
8892: ROLLBACK;
8893: write_to_log(SQLERRM);
8894: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8895: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARN_2007');
8896: igs_ge_msg_stack.add;
8897: app_exception.raise_exception ;
8898: END load_ivnstarn_2007 ;
8891: WHEN OTHERS THEN
8892: ROLLBACK;
8893: write_to_log(SQLERRM);
8894: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8895: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARN_2007');
8896: igs_ge_msg_stack.add;
8897: app_exception.raise_exception ;
8898: END load_ivnstarn_2007 ;
8899:
9040: EXCEPTION
9041: WHEN OTHERS THEN
9042: ROLLBACK;
9043: write_to_log(SQLERRM);
9044: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9045: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARPQR_2003');
9046: igs_ge_msg_stack.add;
9047: app_exception.raise_exception ;
9048: END load_ivstarpqr_2003 ;
9041: WHEN OTHERS THEN
9042: ROLLBACK;
9043: write_to_log(SQLERRM);
9044: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9045: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARPQR_2003');
9046: igs_ge_msg_stack.add;
9047: app_exception.raise_exception ;
9048: END load_ivstarpqr_2003 ;
9049:
9190: EXCEPTION
9191: WHEN OTHERS THEN
9192: ROLLBACK;
9193: write_to_log(SQLERRM);
9194: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9195: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARPQR_2006');
9196: igs_ge_msg_stack.add;
9197: app_exception.raise_exception ;
9198: END load_ivstarpqr_2006;
9191: WHEN OTHERS THEN
9192: ROLLBACK;
9193: write_to_log(SQLERRM);
9194: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9195: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARPQR_2006');
9196: igs_ge_msg_stack.add;
9197: app_exception.raise_exception ;
9198: END load_ivstarpqr_2006;
9199:
9310: EXCEPTION
9311: WHEN OTHERS THEN
9312: ROLLBACK;
9313: write_to_log(SQLERRM);
9314: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9315: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARW_2003');
9316: igs_ge_msg_stack.add;
9317: app_exception.raise_exception ;
9318: END load_ivstarw_2003 ;
9311: WHEN OTHERS THEN
9312: ROLLBACK;
9313: write_to_log(SQLERRM);
9314: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9315: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARW_2003');
9316: igs_ge_msg_stack.add;
9317: app_exception.raise_exception ;
9318: END load_ivstarw_2003 ;
9319:
9439: EXCEPTION
9440: WHEN OTHERS THEN
9441: ROLLBACK;
9442: write_to_log(SQLERRM);
9443: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9444: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARX_2003');
9445: igs_ge_msg_stack.add;
9446: app_exception.raise_exception ;
9447: END load_ivstarx_2003 ;
9440: WHEN OTHERS THEN
9441: ROLLBACK;
9442: write_to_log(SQLERRM);
9443: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9444: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARX_2003');
9445: igs_ge_msg_stack.add;
9446: app_exception.raise_exception ;
9447: END load_ivstarx_2003 ;
9448:
9545: EXCEPTION
9546: WHEN OTHERS THEN
9547: ROLLBACK;
9548: write_to_log(SQLERRM);
9549: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9550: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARX_2006');
9551: igs_ge_msg_stack.add;
9552: app_exception.raise_exception ;
9553: END load_ivgstarx_2006 ;
9546: WHEN OTHERS THEN
9547: ROLLBACK;
9548: write_to_log(SQLERRM);
9549: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9550: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARX_2006');
9551: igs_ge_msg_stack.add;
9552: app_exception.raise_exception ;
9553: END load_ivgstarx_2006 ;
9554:
9657: EXCEPTION
9658: WHEN OTHERS THEN
9659: ROLLBACK;
9660: write_to_log(SQLERRM);
9661: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9662: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARX_2006');
9663: igs_ge_msg_stack.add;
9664: app_exception.raise_exception ;
9665: END load_ivnstarx_2006 ;
9658: WHEN OTHERS THEN
9659: ROLLBACK;
9660: write_to_log(SQLERRM);
9661: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9662: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARX_2006');
9663: igs_ge_msg_stack.add;
9664: app_exception.raise_exception ;
9665: END load_ivnstarx_2006 ;
9666:
9794: EXCEPTION
9795: WHEN OTHERS THEN
9796: ROLLBACK;
9797: write_to_log(SQLERRM);
9798: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9799: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARZ1_2003');
9800: igs_ge_msg_stack.add;
9801: app_exception.raise_exception ;
9802: END load_ivstarz1_2003 ;
9795: WHEN OTHERS THEN
9796: ROLLBACK;
9797: write_to_log(SQLERRM);
9798: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9799: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARZ1_2003');
9800: igs_ge_msg_stack.add;
9801: app_exception.raise_exception ;
9802: END load_ivstarz1_2003 ;
9803:
9918: EXCEPTION
9919: WHEN OTHERS THEN
9920: ROLLBACK;
9921: write_to_log(SQLERRM);
9922: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9923: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARZ1_2006');
9924: igs_ge_msg_stack.add;
9925: app_exception.raise_exception ;
9926: END load_ivnstarz1_2006 ;
9919: WHEN OTHERS THEN
9920: ROLLBACK;
9921: write_to_log(SQLERRM);
9922: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
9923: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARZ1_2006');
9924: igs_ge_msg_stack.add;
9925: app_exception.raise_exception ;
9926: END load_ivnstarz1_2006 ;
9927:
10032: EXCEPTION
10033: WHEN OTHERS THEN
10034: ROLLBACK;
10035: write_to_log(SQLERRM);
10036: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10037: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARZ2_2003');
10038: igs_ge_msg_stack.add;
10039: app_exception.raise_exception ;
10040: END load_ivstarz2_2003 ;
10033: WHEN OTHERS THEN
10034: ROLLBACK;
10035: write_to_log(SQLERRM);
10036: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10037: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARZ2_2003');
10038: igs_ge_msg_stack.add;
10039: app_exception.raise_exception ;
10040: END load_ivstarz2_2003 ;
10041:
10117: EXCEPTION
10118: WHEN OTHERS THEN
10119: ROLLBACK;
10120: write_to_log(SQLERRM);
10121: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10122: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTATEMENT_2003');
10123: igs_ge_msg_stack.add;
10124: app_exception.raise_exception ;
10125: END load_ivstatement_2003 ;
10118: WHEN OTHERS THEN
10119: ROLLBACK;
10120: write_to_log(SQLERRM);
10121: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10122: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTATEMENT_2003');
10123: igs_ge_msg_stack.add;
10124: app_exception.raise_exception ;
10125: END load_ivstatement_2003 ;
10126:
10220: EXCEPTION
10221: WHEN OTHERS THEN
10222: ROLLBACK;
10223: write_to_log(SQLERRM);
10224: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10225: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTATEMENT_2004');
10226: igs_ge_msg_stack.add;
10227: app_exception.raise_exception ;
10228: END load_ivstatement_2004 ;
10221: WHEN OTHERS THEN
10222: ROLLBACK;
10223: write_to_log(SQLERRM);
10224: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10225: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTATEMENT_2004');
10226: igs_ge_msg_stack.add;
10227: app_exception.raise_exception ;
10228: END load_ivstatement_2004 ;
10229:
10323: EXCEPTION
10324: WHEN OTHERS THEN
10325: ROLLBACK;
10326: write_to_log(SQLERRM);
10327: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10328: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTATEMENT_2006');
10329: igs_ge_msg_stack.add;
10330: app_exception.raise_exception ;
10331: END load_ivgstatement_2006 ;
10324: WHEN OTHERS THEN
10325: ROLLBACK;
10326: write_to_log(SQLERRM);
10327: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10328: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTATEMENT_2006');
10329: igs_ge_msg_stack.add;
10330: app_exception.raise_exception ;
10331: END load_ivgstatement_2006 ;
10332:
10426: EXCEPTION
10427: WHEN OTHERS THEN
10428: ROLLBACK;
10429: write_to_log(SQLERRM);
10430: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10431: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTATEMENT_2006');
10432: igs_ge_msg_stack.add;
10433: app_exception.raise_exception ;
10434: END load_ivnstatement_2006 ;
10427: WHEN OTHERS THEN
10428: ROLLBACK;
10429: write_to_log(SQLERRM);
10430: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10431: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTATEMENT_2006');
10432: igs_ge_msg_stack.add;
10433: app_exception.raise_exception ;
10434: END load_ivnstatement_2006 ;
10435:
10650: EXCEPTION
10651: WHEN OTHERS THEN
10652: ROLLBACK;
10653: write_to_log(SQLERRM);
10654: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10655: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVINSTITUTION_2004');
10656: igs_ge_msg_stack.add;
10657: app_exception.raise_exception ;
10658: END load_uvinstitution_2004 ;
10651: WHEN OTHERS THEN
10652: ROLLBACK;
10653: write_to_log(SQLERRM);
10654: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10655: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_UVINSTITUTION_2004');
10656: igs_ge_msg_stack.add;
10657: app_exception.raise_exception ;
10658: END load_uvinstitution_2004 ;
10659:
10788: EXCEPTION
10789: WHEN OTHERS THEN
10790: ROLLBACK;
10791: write_to_log(SQLERRM);
10792: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10793: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARW_2004');
10794: igs_ge_msg_stack.add;
10795: app_exception.raise_exception ;
10796: END load_ivstarw_2004 ;
10789: WHEN OTHERS THEN
10790: ROLLBACK;
10791: write_to_log(SQLERRM);
10792: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10793: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVSTARW_2004');
10794: igs_ge_msg_stack.add;
10795: app_exception.raise_exception ;
10796: END load_ivstarw_2004 ;
10797:
10899: EXCEPTION
10900: WHEN OTHERS THEN
10901: ROLLBACK;
10902: write_to_log(SQLERRM);
10903: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10904: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARW_2006');
10905: igs_ge_msg_stack.add;
10906: app_exception.raise_exception ;
10907: END load_ivgstarw_2006 ;
10900: WHEN OTHERS THEN
10901: ROLLBACK;
10902: write_to_log(SQLERRM);
10903: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
10904: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARW_2006');
10905: igs_ge_msg_stack.add;
10906: app_exception.raise_exception ;
10907: END load_ivgstarw_2006 ;
10908:
11013: EXCEPTION
11014: WHEN OTHERS THEN
11015: ROLLBACK;
11016: write_to_log(SQLERRM);
11017: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11018: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARW_2007');
11019: igs_ge_msg_stack.add;
11020: app_exception.raise_exception ;
11021: END load_ivgstarw_2007 ;
11014: WHEN OTHERS THEN
11015: ROLLBACK;
11016: write_to_log(SQLERRM);
11017: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11018: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGSTARW_2007');
11019: igs_ge_msg_stack.add;
11020: app_exception.raise_exception ;
11021: END load_ivgstarw_2007 ;
11022:
11124: EXCEPTION
11125: WHEN OTHERS THEN
11126: ROLLBACK;
11127: write_to_log(SQLERRM);
11128: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11129: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARW_2006');
11130: igs_ge_msg_stack.add;
11131: app_exception.raise_exception ;
11132: END load_ivnstarw_2006 ;
11125: WHEN OTHERS THEN
11126: ROLLBACK;
11127: write_to_log(SQLERRM);
11128: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11129: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARW_2006');
11130: igs_ge_msg_stack.add;
11131: app_exception.raise_exception ;
11132: END load_ivnstarw_2006 ;
11133:
11238: EXCEPTION
11239: WHEN OTHERS THEN
11240: ROLLBACK;
11241: write_to_log(SQLERRM);
11242: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11243: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARW_2007');
11244: igs_ge_msg_stack.add;
11245: app_exception.raise_exception ;
11246: END load_ivnstarw_2007 ;
11239: WHEN OTHERS THEN
11240: ROLLBACK;
11241: write_to_log(SQLERRM);
11242: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11243: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNSTARW_2007');
11244: igs_ge_msg_stack.add;
11245: app_exception.raise_exception ;
11246: END load_ivnstarw_2007 ;
11247:
11359: EXCEPTION
11360: WHEN OTHERS THEN
11361: ROLLBACK;
11362: write_to_log(SQLERRM);
11363: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11364: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVFORMQUALS_2004');
11365: igs_ge_msg_stack.add;
11366: app_exception.raise_exception ;
11367: END load_ivformquals_2004 ;
11360: WHEN OTHERS THEN
11361: ROLLBACK;
11362: write_to_log(SQLERRM);
11363: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11364: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVFORMQUALS_2004');
11365: igs_ge_msg_stack.add;
11366: app_exception.raise_exception ;
11367: END load_ivformquals_2004 ;
11368:
11491: EXCEPTION
11492: WHEN OTHERS THEN
11493: ROLLBACK;
11494: write_to_log(SQLERRM);
11495: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11496: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVFORMQUALS_2006');
11497: igs_ge_msg_stack.add;
11498: app_exception.raise_exception ;
11499: END load_ivformquals_2006 ;
11492: WHEN OTHERS THEN
11493: ROLLBACK;
11494: write_to_log(SQLERRM);
11495: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11496: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVFORMQUALS_2006');
11497: igs_ge_msg_stack.add;
11498: app_exception.raise_exception ;
11499: END load_ivformquals_2006 ;
11500:
11616: EXCEPTION
11617: WHEN OTHERS THEN
11618: ROLLBACK;
11619: write_to_log(SQLERRM);
11620: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11621: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVREFERENCE_2004');
11622: igs_ge_msg_stack.add;
11623: app_exception.raise_exception ;
11624: END load_ivreference_2004 ;
11617: WHEN OTHERS THEN
11618: ROLLBACK;
11619: write_to_log(SQLERRM);
11620: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11621: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVREFERENCE_2004');
11622: igs_ge_msg_stack.add;
11623: app_exception.raise_exception ;
11624: END load_ivreference_2004 ;
11625:
11753: EXCEPTION
11754: WHEN OTHERS THEN
11755: ROLLBACK;
11756: write_to_log(SQLERRM);
11757: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11758: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVREFERENCE_2006');
11759: igs_ge_msg_stack.add;
11760: app_exception.raise_exception ;
11761: END load_ivreference_2006 ;
11754: WHEN OTHERS THEN
11755: ROLLBACK;
11756: write_to_log(SQLERRM);
11757: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11758: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVREFERENCE_2006');
11759: igs_ge_msg_stack.add;
11760: app_exception.raise_exception ;
11761: END load_ivreference_2006 ;
11762:
11887: EXCEPTION
11888: WHEN OTHERS THEN
11889: ROLLBACK;
11890: write_to_log(SQLERRM);
11891: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11892: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGREFERENCE_2006');
11893: igs_ge_msg_stack.add;
11894: app_exception.raise_exception ;
11895: END load_ivgreference_2006 ;
11888: WHEN OTHERS THEN
11889: ROLLBACK;
11890: write_to_log(SQLERRM);
11891: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11892: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVGREFERENCE_2006');
11893: igs_ge_msg_stack.add;
11894: app_exception.raise_exception ;
11895: END load_ivgreference_2006 ;
11896:
12021: EXCEPTION
12022: WHEN OTHERS THEN
12023: ROLLBACK;
12024: write_to_log(SQLERRM);
12025: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12026: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNREFERENCE_2006');
12027: igs_ge_msg_stack.add;
12028: app_exception.raise_exception ;
12029: END load_ivnreference_2006 ;
12022: WHEN OTHERS THEN
12023: ROLLBACK;
12024: write_to_log(SQLERRM);
12025: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12026: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_IVNREFERENCE_2006');
12027: igs_ge_msg_stack.add;
12028: app_exception.raise_exception ;
12029: END load_ivnreference_2006 ;
12030:
12065: OPEN c_cyc_info ;
12066: FETCH c_cyc_info INTO g_cyc_info_rec ;
12067: CLOSE c_cyc_info ;
12068: IF g_cyc_info_rec.configured_cycle IS NULL OR g_cyc_info_rec.current_cycle IS NULL THEN
12069: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
12070: errbuf := fnd_message.get;
12071: fnd_file.put_line(fnd_file.log, errbuf);
12072: retcode := 2 ;
12073: RETURN ;
12066: FETCH c_cyc_info INTO g_cyc_info_rec ;
12067: CLOSE c_cyc_info ;
12068: IF g_cyc_info_rec.configured_cycle IS NULL OR g_cyc_info_rec.current_cycle IS NULL THEN
12069: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
12070: errbuf := fnd_message.get;
12071: fnd_file.put_line(fnd_file.log, errbuf);
12072: retcode := 2 ;
12073: RETURN ;
12074: END IF;
12080: FETCH c_ucas_cycle INTO c_ucas_cycle_rec ;
12081: CLOSE c_ucas_cycle ;
12082: -- If hercules and our oss system are not configured to the same cycle then report error
12083: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12084: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12085: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12086: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12087: fnd_message.set_token('SYSTEM_CODE','UCAS');
12088: errbuf := fnd_message.get ;
12081: CLOSE c_ucas_cycle ;
12082: -- If hercules and our oss system are not configured to the same cycle then report error
12083: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12084: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12085: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12086: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12087: fnd_message.set_token('SYSTEM_CODE','UCAS');
12088: errbuf := fnd_message.get ;
12089: fnd_file.put_line(fnd_file.log,errbuf );
12082: -- If hercules and our oss system are not configured to the same cycle then report error
12083: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12084: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12085: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12086: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12087: fnd_message.set_token('SYSTEM_CODE','UCAS');
12088: errbuf := fnd_message.get ;
12089: fnd_file.put_line(fnd_file.log,errbuf );
12090: validate_cycle := FALSE;
12083: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12084: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12085: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12086: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12087: fnd_message.set_token('SYSTEM_CODE','UCAS');
12088: errbuf := fnd_message.get ;
12089: fnd_file.put_line(fnd_file.log,errbuf );
12090: validate_cycle := FALSE;
12091: END IF ;
12084: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12085: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12086: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12087: fnd_message.set_token('SYSTEM_CODE','UCAS');
12088: errbuf := fnd_message.get ;
12089: fnd_file.put_line(fnd_file.log,errbuf );
12090: validate_cycle := FALSE;
12091: END IF ;
12092: END IF;
12098: FETCH c_ucas_cycle INTO c_ucas_cycle_rec ;
12099: CLOSE c_ucas_cycle ;
12100: -- If hercules and our oss system are not configured to the same cycle then report error
12101: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12102: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12103: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12104: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12105: fnd_message.set_token('SYSTEM_CODE','GTTR');
12106: errbuf := fnd_message.get ;
12099: CLOSE c_ucas_cycle ;
12100: -- If hercules and our oss system are not configured to the same cycle then report error
12101: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12102: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12103: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12104: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12105: fnd_message.set_token('SYSTEM_CODE','GTTR');
12106: errbuf := fnd_message.get ;
12107: fnd_file.put_line(fnd_file.log,errbuf );
12100: -- If hercules and our oss system are not configured to the same cycle then report error
12101: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12102: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12103: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12104: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12105: fnd_message.set_token('SYSTEM_CODE','GTTR');
12106: errbuf := fnd_message.get ;
12107: fnd_file.put_line(fnd_file.log,errbuf );
12108: validate_cycle := FALSE;
12101: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12102: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12103: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12104: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12105: fnd_message.set_token('SYSTEM_CODE','GTTR');
12106: errbuf := fnd_message.get ;
12107: fnd_file.put_line(fnd_file.log,errbuf );
12108: validate_cycle := FALSE;
12109: END IF ;
12102: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12103: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12104: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12105: fnd_message.set_token('SYSTEM_CODE','GTTR');
12106: errbuf := fnd_message.get ;
12107: fnd_file.put_line(fnd_file.log,errbuf );
12108: validate_cycle := FALSE;
12109: END IF ;
12110: END IF;
12116: FETCH c_ucas_cycle INTO c_ucas_cycle_rec ;
12117: CLOSE c_ucas_cycle ;
12118: -- If hercules and our oss system are not configured to the same cycle then report error
12119: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12120: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12121: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12122: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12123: fnd_message.set_token('SYSTEM_CODE','NMAS');
12124: errbuf := fnd_message.get ;
12117: CLOSE c_ucas_cycle ;
12118: -- If hercules and our oss system are not configured to the same cycle then report error
12119: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12120: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12121: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12122: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12123: fnd_message.set_token('SYSTEM_CODE','NMAS');
12124: errbuf := fnd_message.get ;
12125: fnd_file.put_line(fnd_file.log,errbuf );
12118: -- If hercules and our oss system are not configured to the same cycle then report error
12119: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12120: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12121: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12122: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12123: fnd_message.set_token('SYSTEM_CODE','NMAS');
12124: errbuf := fnd_message.get ;
12125: fnd_file.put_line(fnd_file.log,errbuf );
12126: validate_cycle := FALSE;
12119: IF NVL(c_ucas_cycle_rec.entry_year,0) <> Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) THEN
12120: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12121: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12122: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12123: fnd_message.set_token('SYSTEM_CODE','NMAS');
12124: errbuf := fnd_message.get ;
12125: fnd_file.put_line(fnd_file.log,errbuf );
12126: validate_cycle := FALSE;
12127: END IF ;
12120: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
12121: fnd_message.set_token('UCAS_CYCLE',Ltrim(Substr(g_cyc_info_rec.configured_cycle,3,2) ) );
12122: fnd_message.set_token('HERC_CYCLE',NVL(c_ucas_cycle_rec.entry_year,0 ) );
12123: fnd_message.set_token('SYSTEM_CODE','NMAS');
12124: errbuf := fnd_message.get ;
12125: fnd_file.put_line(fnd_file.log,errbuf );
12126: validate_cycle := FALSE;
12127: END IF ;
12128: END IF;
12139: OPEN c_refamend_timestamp ;
12140: FETCH c_refamend_timestamp INTO g_refamend_timestamp ;
12141: IF c_refamend_timestamp%NOTFOUND THEN
12142: CLOSE c_refamend_timestamp ;
12143: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12144: errbuf := fnd_message.get;
12145: fnd_file.put_line(fnd_file.log, errbuf);
12146: retcode := 2 ;
12147: RETURN ;
12140: FETCH c_refamend_timestamp INTO g_refamend_timestamp ;
12141: IF c_refamend_timestamp%NOTFOUND THEN
12142: CLOSE c_refamend_timestamp ;
12143: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12144: errbuf := fnd_message.get;
12145: fnd_file.put_line(fnd_file.log, errbuf);
12146: retcode := 2 ;
12147: RETURN ;
12148: ELSE
12152: OPEN c_refamend_timestamp_2007 ;
12153: FETCH c_refamend_timestamp_2007 INTO g_refamend_timestamp ;
12154: IF c_refamend_timestamp_2007%NOTFOUND THEN
12155: CLOSE c_refamend_timestamp_2007 ;
12156: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12157: errbuf := fnd_message.get;
12158: fnd_file.put_line(fnd_file.log, errbuf);
12159: retcode := 2 ;
12160: RETURN ;
12153: FETCH c_refamend_timestamp_2007 INTO g_refamend_timestamp ;
12154: IF c_refamend_timestamp_2007%NOTFOUND THEN
12155: CLOSE c_refamend_timestamp_2007 ;
12156: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12157: errbuf := fnd_message.get;
12158: fnd_file.put_line(fnd_file.log, errbuf);
12159: retcode := 2 ;
12160: RETURN ;
12161: ELSE
12174: OPEN c_grefamend_timestamp ;
12175: FETCH c_grefamend_timestamp INTO g_grefamend_timestamp ;
12176: IF c_grefamend_timestamp%NOTFOUND THEN
12177: CLOSE c_grefamend_timestamp ;
12178: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12179: fnd_message.set_token('VIEW_NAME','CvGRefAmendments');
12180: errbuf := fnd_message.get;
12181: fnd_file.put_line(fnd_file.log, errbuf);
12182: retcode := 2 ;
12175: FETCH c_grefamend_timestamp INTO g_grefamend_timestamp ;
12176: IF c_grefamend_timestamp%NOTFOUND THEN
12177: CLOSE c_grefamend_timestamp ;
12178: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12179: fnd_message.set_token('VIEW_NAME','CvGRefAmendments');
12180: errbuf := fnd_message.get;
12181: fnd_file.put_line(fnd_file.log, errbuf);
12182: retcode := 2 ;
12183: RETURN ;
12176: IF c_grefamend_timestamp%NOTFOUND THEN
12177: CLOSE c_grefamend_timestamp ;
12178: fnd_message.set_name('IGS','IGS_UC_REFTIME_NOT_FOUND');
12179: fnd_message.set_token('VIEW_NAME','CvGRefAmendments');
12180: errbuf := fnd_message.get;
12181: fnd_file.put_line(fnd_file.log, errbuf);
12182: retcode := 2 ;
12183: RETURN ;
12184: ELSE
12489:
12490: ELSE
12491:
12492: -- UCAS interface is MARVIN so log warning.
12493: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12494: fnd_message.set_token('SYSTEM_CODE','UCAS');
12495: fnd_message.set_token('PROCESS','load');
12496: fnd_file.put_line(fnd_file.log,fnd_message.get );
12497: retcode := 1;
12490: ELSE
12491:
12492: -- UCAS interface is MARVIN so log warning.
12493: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12494: fnd_message.set_token('SYSTEM_CODE','UCAS');
12495: fnd_message.set_token('PROCESS','load');
12496: fnd_file.put_line(fnd_file.log,fnd_message.get );
12497: retcode := 1;
12498:
12491:
12492: -- UCAS interface is MARVIN so log warning.
12493: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12494: fnd_message.set_token('SYSTEM_CODE','UCAS');
12495: fnd_message.set_token('PROCESS','load');
12496: fnd_file.put_line(fnd_file.log,fnd_message.get );
12497: retcode := 1;
12498:
12499: END IF;
12492: -- UCAS interface is MARVIN so log warning.
12493: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12494: fnd_message.set_token('SYSTEM_CODE','UCAS');
12495: fnd_message.set_token('PROCESS','load');
12496: fnd_file.put_line(fnd_file.log,fnd_message.get );
12497: retcode := 1;
12498:
12499: END IF;
12500:
12544:
12545: ELSE
12546:
12547: -- GTTR interface is MARVIN so log warning.
12548: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12549: fnd_message.set_token('SYSTEM_CODE','GTTR');
12550: fnd_message.set_token('PROCESS','load');
12551: fnd_file.put_line(fnd_file.log,fnd_message.get );
12552: retcode := 1;
12545: ELSE
12546:
12547: -- GTTR interface is MARVIN so log warning.
12548: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12549: fnd_message.set_token('SYSTEM_CODE','GTTR');
12550: fnd_message.set_token('PROCESS','load');
12551: fnd_file.put_line(fnd_file.log,fnd_message.get );
12552: retcode := 1;
12553:
12546:
12547: -- GTTR interface is MARVIN so log warning.
12548: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12549: fnd_message.set_token('SYSTEM_CODE','GTTR');
12550: fnd_message.set_token('PROCESS','load');
12551: fnd_file.put_line(fnd_file.log,fnd_message.get );
12552: retcode := 1;
12553:
12554: END IF;
12547: -- GTTR interface is MARVIN so log warning.
12548: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12549: fnd_message.set_token('SYSTEM_CODE','GTTR');
12550: fnd_message.set_token('PROCESS','load');
12551: fnd_file.put_line(fnd_file.log,fnd_message.get );
12552: retcode := 1;
12553:
12554: END IF;
12555:
12599:
12600: ELSE
12601:
12602: -- NMAS interface is MARVIN so log warning.
12603: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12604: fnd_message.set_token('SYSTEM_CODE','NMAS');
12605: fnd_message.set_token('PROCESS','load');
12606: fnd_file.put_line(fnd_file.log,fnd_message.get );
12607: retcode := 1;
12600: ELSE
12601:
12602: -- NMAS interface is MARVIN so log warning.
12603: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12604: fnd_message.set_token('SYSTEM_CODE','NMAS');
12605: fnd_message.set_token('PROCESS','load');
12606: fnd_file.put_line(fnd_file.log,fnd_message.get );
12607: retcode := 1;
12608:
12601:
12602: -- NMAS interface is MARVIN so log warning.
12603: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12604: fnd_message.set_token('SYSTEM_CODE','NMAS');
12605: fnd_message.set_token('PROCESS','load');
12606: fnd_file.put_line(fnd_file.log,fnd_message.get );
12607: retcode := 1;
12608:
12609: END IF;
12602: -- NMAS interface is MARVIN so log warning.
12603: fnd_message.set_name('IGS','IGS_UC_MARVIN_INTERFACE');
12604: fnd_message.set_token('SYSTEM_CODE','NMAS');
12605: fnd_message.set_token('PROCESS','load');
12606: fnd_file.put_line(fnd_file.log,fnd_message.get );
12607: retcode := 1;
12608:
12609: END IF;
12610:
12616: WHEN OTHERS THEN
12617: ROLLBACK;
12618: write_to_log(SQLERRM);
12619: retcode := 2;
12620: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12621: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_MAIN');
12622: errbuf := fnd_message.get;
12623: igs_ge_msg_stack.conc_exception_hndl;
12624:
12617: ROLLBACK;
12618: write_to_log(SQLERRM);
12619: retcode := 2;
12620: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12621: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_MAIN');
12622: errbuf := fnd_message.get;
12623: igs_ge_msg_stack.conc_exception_hndl;
12624:
12625: END load_main;
12618: write_to_log(SQLERRM);
12619: retcode := 2;
12620: Fnd_Message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12621: fnd_message.set_token('NAME', 'IGS_UC_LOAD_HERCULES_DATA.LOAD_MAIN');
12622: errbuf := fnd_message.get;
12623: igs_ge_msg_stack.conc_exception_hndl;
12624:
12625: END load_main;
12626: