[Home] [Help]
1: PACKAGE BODY igs_uc_load_hercules_data AS
2: /* $Header: IGSUC42B.pls 120.10 2006/08/21 06:18:28 jbaber ship $ */
3:
4:
5: -- global cursors and variables
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:
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:
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:
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:
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:
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;
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;
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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;
12623: igs_ge_msg_stack.conc_exception_hndl;
12624:
12625: END load_main;
12626:
12627: END igs_uc_load_hercules_data;