[Home] [Help]
1: PACKAGE BODY igs_he_extract_fields_pkg AS
2: /* $Header: IGSHE9CB.pls 120.14 2006/09/15 01:49:20 jtmathew noship $ */
3:
4: PROCEDURE write_to_log (p_message IN VARCHAR2)
5: IS
54: CLOSE c_get_instid;
55: END IF;
56:
57: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
58: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_hesa_inst_id');
59: IGS_GE_MSG_STACK.ADD;
60: App_Exception.Raise_Exception;
61:
62: END get_hesa_inst_id;
95: THEN
96: write_to_log(SQLERRM);
97:
98: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
99: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_campus_id');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END get_campus_id;
103:
139: WHEN OTHERS
140: THEN
141: write_to_log (SQLERRM);
142: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
143: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_alt_pers_id');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END get_alt_pers_id;
147:
265: l_cre_husid := FALSE;
266: l_cre_lat_husid := FALSE;
267:
268: -- Check if HUS ID already exists
269: igs_he_extract_fields_pkg.get_alt_pers_id
270: (p_person_id => p_person_id,
271: p_id_type => 'HUSID',
272: p_api_id => l_stdnt_id,
273: p_enrl_start_dt => p_enrl_start_dt,
354: ELSIF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
355:
356: fnd_message.set_name('IGS','IGS_HE_INVAL_HUSID_RECS_WARN');
357: fnd_message.set_token('PERSON_NO',p_person_id );
358: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_he_extract_fields_pkg.get_stdnt_id', fnd_message.get);
359:
360: END IF;
361: CLOSE c_future_husid;
362:
376: CLOSE c_api;
377: l_stdnt_id := NULL;
378: --IN case of more than one person id type
379: -- Check if UCAS ID already exists
380: igs_he_extract_fields_pkg.get_alt_pers_id
381: (p_person_id => p_person_id,
382: p_id_type => 'UCASID',
383: p_api_id => l_stdnt_id,
384: p_enrl_start_dt => p_enrl_start_dt,
386:
387: --3
388: -- Check if NMASID already exists
389: IF l_stdnt_id IS NULL THEN
390: igs_he_extract_fields_pkg.get_alt_pers_id
391: (p_person_id => p_person_id,
392: p_id_type => 'NMASID',
393: p_api_id => l_stdnt_id,
394: p_enrl_start_dt => p_enrl_start_dt,
395: p_enrl_end_dt => p_enrl_end_dt);
396: --4
397: -- Check if GTTRID already exists
398: IF l_stdnt_id IS NULL THEN
399: igs_he_extract_fields_pkg.get_alt_pers_id
400: (p_person_id => p_person_id,
401: p_id_type => 'GTTRID',
402: p_api_id => l_stdnt_id,
403: p_enrl_start_dt => p_enrl_start_dt,
404: p_enrl_end_dt => p_enrl_end_dt);
405: --5
406: -- Check if SWASID already exists
407: IF l_stdnt_id IS NULL THEN
408: igs_he_extract_fields_pkg.get_alt_pers_id
409: (p_person_id => p_person_id,
410: p_id_type => 'SWASID',
411: p_api_id => l_stdnt_id,
412: p_enrl_start_dt => p_enrl_start_dt,
622: THEN
623: CLOSE c_deleted_husid;
624: END IF;
625: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
626: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_stdnt_id');
627: IGS_GE_MSG_STACK.ADD;
628: App_Exception.Raise_Exception;
629: END get_stdnt_id;
630:
688: WHEN OTHERS
689: THEN
690: write_to_log (SQLERRM);
691: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
692: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fe_stdnt_mrker');
693: IGS_GE_MSG_STACK.ADD;
694: App_Exception.Raise_Exception;
695: END get_fe_stdnt_mrker;
696:
803: CLOSE c_gov_fsrc;
804: END IF;
805:
806: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
807: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_funding_src');
808: IGS_GE_MSG_STACK.ADD;
809: App_Exception.Raise_Exception;
810: END get_funding_src;
811:
966: CLOSE c_res_sts;
967: END IF;
968:
969: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
970: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fundability_cd');
971: IGS_GE_MSG_STACK.ADD;
972: App_Exception.Raise_Exception;
973: END get_fundability_cd;
974:
1013: CLOSE c_fmly_nm;
1014: END IF;
1015:
1016: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1017: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fmly_name_on_16_bday');
1018: IGS_GE_MSG_STACK.ADD;
1019: App_Exception.Raise_Exception;
1020: END get_fmly_name_on_16_bday;
1021:
1052: WHEN OTHERS
1053: THEN
1054: write_to_log (SQLERRM);
1055: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1056: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_gender');
1057: IGS_GE_MSG_STACK.ADD;
1058: App_Exception.Raise_Exception;
1059: END get_gender;
1060:
1092: WHEN OTHERS
1093: THEN
1094: write_to_log (SQLERRM);
1095: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1096: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_domicile');
1097: IGS_GE_MSG_STACK.ADD;
1098: App_Exception.Raise_Exception;
1099: END get_domicile;
1100:
1158: CLOSE c_ntnl;
1159: END IF;
1160:
1161: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1162: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_nationality');
1163: IGS_GE_MSG_STACK.ADD;
1164: App_Exception.Raise_Exception;
1165: END get_nationality;
1166:
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: write_to_log (SQLERRM);
1203: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1204: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_ethnicity');
1205: IGS_GE_MSG_STACK.ADD;
1206: App_Exception.Raise_Exception;
1207:
1208: END get_ethnicity;
1241: WHEN OTHERS
1242: THEN
1243: write_to_log (SQLERRM);
1244: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1245: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_disability_allow');
1246: IGS_GE_MSG_STACK.ADD;
1247: App_Exception.Raise_Exception;
1248: END get_disablity_allow;
1249:
1327: CLOSE c_dis;
1328: END IF;
1329:
1330: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1331: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_disability');
1332: IGS_GE_MSG_STACK.ADD;
1333: App_Exception.Raise_Exception;
1334: END get_disablity;
1335:
1367: WHEN OTHERS
1368: THEN
1369: write_to_log (SQLERRM);
1370: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1371: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_addnl_supp_band');
1372: IGS_GE_MSG_STACK.ADD;
1373: App_Exception.Raise_Exception;
1374: END get_addnl_supp_band;
1375:
1425: CLOSE c_yr;
1426: END IF;
1427:
1428: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1429: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_yr_left_last_inst');
1430: IGS_GE_MSG_STACK.ADD;
1431: App_Exception.Raise_Exception;
1432: END get_yr_left_last_inst;
1433:
1496: WHEN OTHERS
1497: THEN
1498: write_to_log (SQLERRM);
1499: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1500: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_new_ent_to_he');
1501: IGS_GE_MSG_STACK.ADD;
1502: App_Exception.Raise_Exception;
1503: END get_new_ent_to_he;
1504:
1537: CLOSE c_yop;
1538: END IF;
1539:
1540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1541: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_year_of_prog');
1542: IGS_GE_MSG_STACK.ADD;
1543: App_Exception.Raise_Exception;
1544: END get_year_of_prog;
1545:
1579: WHEN OTHERS
1580: THEN
1581: write_to_log (SQLERRM);
1582: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1583: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_special_student');
1584: IGS_GE_MSG_STACK.ADD;
1585: App_Exception.Raise_Exception;
1586: END get_special_student;
1587:
1684: CLOSE c_yos;
1685: END IF;
1686:
1687: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1688: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_year_of_student');
1689: IGS_GE_MSG_STACK.ADD;
1690: App_Exception.Raise_Exception;
1691: END get_year_of_student;
1692:
1731: THEN
1732: write_to_log (SQLERRM);
1733:
1734: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1735: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_study_location');
1736: IGS_GE_MSG_STACK.ADD;
1737: App_Exception.Raise_Exception;
1738: END get_study_location;
1739:
1851: CLOSE c_addrus;
1852: END IF;
1853:
1854: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1855: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_term_time_acc');
1856: IGS_GE_MSG_STACK.ADD;
1857: App_Exception.Raise_Exception;
1858: END get_term_time_acc;
1859:
1936: WHEN OTHERS
1937: THEN
1938: write_to_log (SQLERRM);
1939: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1940: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_awd_conferral_dates');
1941: IGS_GE_MSG_STACK.ADD;
1942: App_Exception.Raise_Exception;
1943: END get_awd_conferral_dates;
1944:
2001: CLOSE c_get_max_awd_conf_dt;
2002: END IF;
2003:
2004: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2005: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_min_max_awd_dates');
2006: IGS_GE_MSG_STACK.ADD;
2007: App_Exception.Raise_Exception;
2008:
2009: END get_min_max_awd_dates;
2089: CLOSE c_get_awdcount;
2090: END IF;
2091:
2092: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2093: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_awd_dtls');
2094: IGS_GE_MSG_STACK.ADD;
2095: App_Exception.Raise_Exception;
2096:
2097: END get_awd_dtls;
2172: WHEN OTHERS
2173: THEN
2174: write_to_log (SQLERRM);
2175: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2176: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_rsn_inst_left');
2177: IGS_GE_MSG_STACK.ADD;
2178: App_Exception.Raise_Exception;
2179: END get_rsn_inst_left;
2180:
2285: CLOSE c_chk_trn;
2286: END IF;
2287:
2288: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2289: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_completion_status');
2290: IGS_GE_MSG_STACK.ADD;
2291: App_Exception.Raise_Exception;
2292: END get_completion_status;
2293:
2337: WHEN OTHERS
2338: THEN
2339: write_to_log (SQLERRM);
2340: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2341: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_good_stand_mrkr');
2342: IGS_GE_MSG_STACK.ADD;
2343: App_Exception.Raise_Exception;
2344: END get_good_stand_mrkr;
2345:
2469: CLOSE c_pr_awd;
2470: END IF;
2471:
2472: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2473: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_obtained ');
2474: IGS_GE_MSG_STACK.ADD;
2475: App_Exception.Raise_Exception;
2476: END get_qual_obtained ;
2477:
2538: CLOSE c_get_feq;
2539: END IF;
2540:
2541: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2542: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fe_qual_aim');
2543: IGS_GE_MSG_STACK.ADD;
2544: App_Exception.Raise_Exception;
2545: END get_fe_qual_aim;
2546:
2594: WHEN OTHERS
2595: THEN
2596: write_to_log (SQLERRM);
2597: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2598: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_aim_sbj1');
2599: IGS_GE_MSG_STACK.ADD;
2600: App_Exception.Raise_Exception;
2601:
2602: END get_qual_aim_sbj1;
2702: CLOSE c_sbj23;
2703: END IF;
2704:
2705: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2706: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_aim_sbj ');
2707: IGS_GE_MSG_STACK.ADD;
2708: App_Exception.Raise_Exception;
2709: END get_qual_aim_sbj;
2710:
2739: WHEN OTHERS
2740: THEN
2741: write_to_log (SQLERRM);
2742: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2743: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.is_ucas_ftug');
2744: IGS_GE_MSG_STACK.ADD;
2745: App_Exception.Raise_Exception;
2746:
2747: END is_ucas_ftug;
2793: THEN
2794: write_to_log (SQLERRM);
2795:
2796: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2797: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.limit_no_of_qual');
2798: IGS_GE_MSG_STACK.ADD;
2799: App_Exception.Raise_Exception;
2800: END limit_no_of_qual;
2801:
2848: THEN
2849: write_to_log (SQLERRM);
2850:
2851: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2852: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.limit_tariff_score');
2853: IGS_GE_MSG_STACK.ADD;
2854: App_Exception.Raise_Exception;
2855: END limit_tariff_score;
2856:
2954: CLOSE c_prgawd;
2955: END IF;
2956:
2957: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2958: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_gen_qual_aim');
2959: IGS_GE_MSG_STACK.ADD;
2960: App_Exception.Raise_Exception;
2961: END get_gen_qual_aim;
2962:
3031: CLOSE c_awdbdy;
3032: END IF;
3033:
3034: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3035: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_awd_body_12');
3036: IGS_GE_MSG_STACK.ADD;
3037: App_Exception.Raise_Exception;
3038: END get_awd_body_12;
3039:
3107: WHEN OTHERS
3108: THEN
3109: write_to_log (SQLERRM);
3110: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3111: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_prog_length');
3112: IGS_GE_MSG_STACK.ADD;
3113: App_Exception.Raise_Exception;
3114: END get_prog_length;
3115:
3146: WHEN OTHERS
3147: THEN
3148: write_to_log (SQLERRM);
3149: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3150: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_teach_train_crs_id');
3151: IGS_GE_MSG_STACK.ADD;
3152: App_Exception.Raise_Exception;
3153: END get_teach_train_crs_id;
3154:
3186: WHEN OTHERS
3187: THEN
3188: write_to_log (SQLERRM);
3189: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3190: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_itt_phsc');
3191: IGS_GE_MSG_STACK.ADD;
3192: App_Exception.Raise_Exception;
3193: END get_itt_phsc;
3194:
3226: WHEN OTHERS
3227: THEN
3228: write_to_log (SQLERRM);
3229: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3230: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_itt_mrker');
3231: IGS_GE_MSG_STACK.ADD;
3232: App_Exception.Raise_Exception;
3233: END get_itt_mrker;
3234:
3266: WHEN OTHERS
3267: THEN
3268: write_to_log (SQLERRM);
3269: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3270: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_teach_qual_sect');
3271: IGS_GE_MSG_STACK.ADD;
3272: App_Exception.Raise_Exception;
3273: END get_teach_qual_sect;
3274:
3306: WHEN OTHERS
3307: THEN
3308: write_to_log (SQLERRM);
3309: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3310: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_teach_qual_sbj');
3311: IGS_GE_MSG_STACK.ADD;
3312: App_Exception.Raise_Exception;
3313: END get_teach_qual_sbj;
3314:
3460: CLOSE c_res_sts;
3461: END IF;
3462:
3463: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3464: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fee_elig');
3465: IGS_GE_MSG_STACK.ADD;
3466: App_Exception.Raise_Exception;
3467: END get_fee_elig;
3468:
3515: WHEN OTHERS
3516: THEN
3517: write_to_log (SQLERRM);
3518: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3519: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fee_band');
3520: IGS_GE_MSG_STACK.ADD;
3521: App_Exception.Raise_Exception;
3522: END get_fee_band;
3523:
3607: CLOSE c_fees;
3608: END IF;
3609:
3610: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3611: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_amt_tuition_fees');
3612: IGS_GE_MSG_STACK.ADD;
3613: App_Exception.Raise_Exception;
3614: END get_amt_tuition_fees;
3615:
3897: EXCEPTION
3898: WHEN OTHERS THEN
3899: write_to_log (SQLERRM);
3900: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3901: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.GET_MAJ_SRC_TU_FEE - '||SQLERRM);
3902: IGS_GE_MSG_STACK.ADD;
3903: App_Exception.Raise_Exception;
3904: END get_maj_src_tu_fee;
3905:
3937: WHEN OTHERS
3938: THEN
3939: write_to_log (SQLERRM);
3940: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3941: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_religion');
3942: IGS_GE_MSG_STACK.ADD;
3943: App_Exception.Raise_Exception;
3944: END get_religion;
3945:
3979: WHEN OTHERS
3980: THEN
3981: write_to_log (SQLERRM);
3982: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3983: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_sldd_disc_prv');
3984: IGS_GE_MSG_STACK.ADD;
3985: App_Exception.Raise_Exception;
3986: END get_sldd_disc_prv;
3987:
4022: WHEN OTHERS
4023: THEN
4024: write_to_log (SQLERRM);
4025: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4026: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_non_payment_rsn');
4027: IGS_GE_MSG_STACK.ADD;
4028: App_Exception.Raise_Exception;
4029: END get_non_payment_rsn;
4030:
4137: CLOSE c_un_inst;
4138: END IF;
4139:
4140: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4141: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_oth_teach_inst');
4142: IGS_GE_MSG_STACK.ADD;
4143: App_Exception.Raise_Exception;
4144: END get_oth_teach_inst;
4145:
4261: CLOSE c_total_cp;
4262: END IF;
4263:
4264: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4265: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_prop_not_taught');
4266: IGS_GE_MSG_STACK.ADD;
4267: App_Exception.Raise_Exception;
4268: END get_prop_not_taught;
4269:
4304: WHEN OTHERS
4305: THEN
4306: write_to_log (SQLERRM);
4307: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4308: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_credit_trans_sch');
4309: IGS_GE_MSG_STACK.ADD;
4310: App_Exception.Raise_Exception;
4311: END get_credit_trans_sch;
4312:
4346: WHEN OTHERS
4347: THEN
4348: write_to_log (SQLERRM);
4349: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4350: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_credit_level');
4351: IGS_GE_MSG_STACK.ADD;
4352: App_Exception.Raise_Exception;
4353: END get_credit_level;
4354:
4428: FETCH c_cp INTO p_no_crd_pt4, l_lvl4;
4429: CLOSE c_cp;
4430:
4431: -- Level of Credit Points obtained 1
4432: igs_he_extract_fields_pkg.get_credit_level
4433: (p_susa_credit_level => NULL ,
4434: p_poous_credit_level => l_lvl1,
4435: p_hesa_credit_level => p_lvl_crd_pt1);
4436:
4434: p_poous_credit_level => l_lvl1,
4435: p_hesa_credit_level => p_lvl_crd_pt1);
4436:
4437: -- Level of Credit Points obtained 2
4438: igs_he_extract_fields_pkg.get_credit_level
4439: (p_susa_credit_level => NULL ,
4440: p_poous_credit_level => l_lvl2,
4441: p_hesa_credit_level => p_lvl_crd_pt2);
4442:
4440: p_poous_credit_level => l_lvl2,
4441: p_hesa_credit_level => p_lvl_crd_pt2);
4442:
4443: -- Level of Credit Points obtained 3
4444: igs_he_extract_fields_pkg.get_credit_level
4445: (p_susa_credit_level => NULL ,
4446: p_poous_credit_level => l_lvl3,
4447: p_hesa_credit_level => p_lvl_crd_pt3);
4448:
4446: p_poous_credit_level => l_lvl3,
4447: p_hesa_credit_level => p_lvl_crd_pt3);
4448:
4449: -- Level of Credit Points obtained 4
4450: igs_he_extract_fields_pkg.get_credit_level
4451: (p_susa_credit_level => NULL ,
4452: p_poous_credit_level => l_lvl4,
4453: p_hesa_credit_level => p_lvl_crd_pt4);
4454:
4459: p_no_crd_pt3 := p_susa_crd_pt3;
4460: p_no_crd_pt4 := p_susa_crd_pt4;
4461:
4462: -- Level of Credit Points obtained 1
4463: igs_he_extract_fields_pkg.get_credit_level
4464: (p_susa_credit_level => NULL ,
4465: p_poous_credit_level => p_susa_crd_lvl1,
4466: p_hesa_credit_level => p_lvl_crd_pt1);
4467:
4465: p_poous_credit_level => p_susa_crd_lvl1,
4466: p_hesa_credit_level => p_lvl_crd_pt1);
4467:
4468: -- Level of Credit Points obtained 2
4469: igs_he_extract_fields_pkg.get_credit_level
4470: (p_susa_credit_level => NULL ,
4471: p_poous_credit_level => p_susa_crd_lvl2,
4472: p_hesa_credit_level => p_lvl_crd_pt2);
4473:
4471: p_poous_credit_level => p_susa_crd_lvl2,
4472: p_hesa_credit_level => p_lvl_crd_pt2);
4473:
4474: -- Level of Credit Points obtained 3
4475: igs_he_extract_fields_pkg.get_credit_level
4476: (p_susa_credit_level => NULL ,
4477: p_poous_credit_level => p_susa_crd_lvl3,
4478: p_hesa_credit_level => p_lvl_crd_pt3);
4479:
4477: p_poous_credit_level => p_susa_crd_lvl3,
4478: p_hesa_credit_level => p_lvl_crd_pt3);
4479:
4480: -- Level of Credit Points obtained 4
4481: igs_he_extract_fields_pkg.get_credit_level
4482: (p_susa_credit_level => NULL ,
4483: p_poous_credit_level => p_susa_crd_lvl4,
4484: p_hesa_credit_level => p_lvl_crd_pt4);
4485:
4494: CLOSE c_cp;
4495: END IF;
4496:
4497: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
4498: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_credit_obtained');
4499: IGS_GE_MSG_STACK.ADD;
4500: App_Exception.Raise_Exception;
4501: END get_credit_obtained;
4502:
5036: CLOSE c_cc;
5037: END IF;
5038:
5039: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5040: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_cost_centres');
5041: IGS_GE_MSG_STACK.ADD;
5042: App_Exception.Raise_Exception;
5043:
5044: END get_cost_centres;
5159: CLOSE c_susp;
5160: END IF;
5161:
5162: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5163: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_studies_susp');
5164: IGS_GE_MSG_STACK.ADD;
5165: App_Exception.Raise_Exception;
5166: END get_studies_susp;
5167:
5198: WHEN OTHERS
5199: THEN
5200: write_to_log (SQLERRM);
5201: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5202: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_pyr_type');
5203: IGS_GE_MSG_STACK.ADD;
5204: App_Exception.Raise_Exception;
5205: END get_pyr_type;
5206:
5239: WHEN OTHERS
5240: THEN
5241: write_to_log (SQLERRM);
5242: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5243: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_lvl_appl_to_fund');
5244: IGS_GE_MSG_STACK.ADD;
5245: App_Exception.Raise_Exception;
5246: END get_lvl_appl_to_fund;
5247:
5496: EXCEPTION
5497: WHEN OTHERS THEN
5498: write_to_log (SQLERRM);
5499: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5500: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_comp_pyr_study');
5501: IGS_GE_MSG_STACK.ADD;
5502: App_Exception.Raise_Exception;
5503:
5504: END get_comp_pyr_study;
5537: WHEN OTHERS
5538: THEN
5539: write_to_log (SQLERRM);
5540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5541: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_destination');
5542: IGS_GE_MSG_STACK.ADD;
5543: App_Exception.Raise_Exception;
5544: END get_destination;
5545:
5579: WHEN OTHERS
5580: THEN
5581: write_to_log (SQLERRM);
5582: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5583: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_itt_outcome');
5584: IGS_GE_MSG_STACK.ADD;
5585: App_Exception.Raise_Exception;
5586: END get_itt_outcome;
5587:
5618: WHEN OTHERS
5619: THEN
5620: write_to_log (SQLERRM);
5621: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5622: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_ufi_place');
5623: IGS_GE_MSG_STACK.ADD;
5624: App_Exception.Raise_Exception;
5625: END get_ufi_place;
5626:
5662: WHEN OTHERS
5663: THEN
5664: write_to_log (SQLERRM);
5665: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5666: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_franchising_activity');
5667: IGS_GE_MSG_STACK.ADD;
5668: App_Exception.Raise_Exception;
5669: END get_franchising_activity;
5670:
5704: WHEN OTHERS
5705: THEN
5706: write_to_log (SQLERRM);
5707: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5708: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_social_class_ind');
5709: IGS_GE_MSG_STACK.ADD;
5710: App_Exception.Raise_Exception;
5711: END get_social_class_ind;
5712:
5744: WHEN OTHERS
5745: THEN
5746: write_to_log (SQLERRM);
5747: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5748: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_occupation_code');
5749: IGS_GE_MSG_STACK.ADD;
5750: App_Exception.Raise_Exception;
5751: END get_occupation_code;
5752:
5890: CLOSE c_gvinst;
5891: END IF;
5892:
5893: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5894: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_inst_last_attended');
5895: IGS_GE_MSG_STACK.ADD;
5896: App_Exception.Raise_Exception;
5897: END get_inst_last_attended;
5898:
5941: WHEN OTHERS
5942: THEN
5943: write_to_log (SQLERRM);
5944: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5945: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_regulatory_body');
5946: IGS_GE_MSG_STACK.ADD;
5947: App_Exception.Raise_Exception;
5948: END get_regulatory_body;
5949:
5983: WHEN OTHERS
5984: THEN
5985: write_to_log (SQLERRM);
5986: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5987: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_nhs_fund_src');
5988: IGS_GE_MSG_STACK.ADD;
5989: App_Exception.Raise_Exception;
5990: END get_nhs_fund_src;
5991:
6023: WHEN OTHERS
6024: THEN
6025: write_to_log (SQLERRM);
6026: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6027: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_nhs_employer');
6028: IGS_GE_MSG_STACK.ADD;
6029: App_Exception.Raise_Exception;
6030: END get_nhs_employer;
6031:
6082: CLOSE c_qdet;
6083: END IF;
6084:
6085: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6086: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_dets');
6087: IGS_GE_MSG_STACK.ADD;
6088: App_Exception.Raise_Exception;
6089: END get_qual_dets;
6090:
6305: WHEN OTHERS
6306: THEN
6307: write_to_log (SQLERRM);
6308: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6309: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_module_dets');
6310: IGS_GE_MSG_STACK.ADD;
6311: App_Exception.Raise_Exception;
6312: END get_module_dets;
6313:
6397: THEN
6398: write_to_log (SQLERRM);
6399:
6400: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6401: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mode_of_study');
6402: IGS_GE_MSG_STACK.ADD;
6403: App_Exception.Raise_Exception;
6404: END get_mode_of_study;
6405:
6509: CLOSE c_spa_dt;
6510: END IF;
6511:
6512: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6513: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.isDormant');
6514: IGS_GE_MSG_STACK.ADD;
6515: App_Exception.Raise_Exception;
6516: END isDormant;
6517:
6568: NULL ;
6569: WHEN OTHERS THEN
6570: write_to_log (SQLERRM);
6571: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6572: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mod_prop_fte');
6573: IGS_GE_MSG_STACK.ADD;
6574: App_Exception.Raise_Exception;
6575: END get_mod_prop_fte;
6576:
6619: CLOSE c_perc;
6620: END IF;
6621:
6622: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6623: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mod_prop_not_taught');
6624: IGS_GE_MSG_STACK.ADD;
6625: App_Exception.Raise_Exception;
6626: END get_mod_prop_not_taught;
6627:
6678: CLOSE c_oinst;
6679: END IF;
6680:
6681: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6682: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mod_oth_teach_inst');
6683: IGS_GE_MSG_STACK.ADD;
6684: App_Exception.Raise_Exception;
6685: END get_mod_oth_teach_inst;
6686:
6742: WHEN OTHERS
6743: THEN
6744: write_to_log (SQLERRM);
6745: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6746: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_pgce_class');
6747: IGS_GE_MSG_STACK.ADD;
6748: App_Exception.Raise_Exception;
6749: END get_pgce_class;
6750:
6810: WHEN OTHERS
6811: THEN
6812: write_to_log (SQLERRM);
6813: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6814: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_commencement_dt');
6815: IGS_GE_MSG_STACK.ADD;
6816: App_Exception.Raise_Exception;
6817:
6818: END get_commencement_dt;
6850:
6851: BEGIN
6852: --get the api_id from the UCASID
6853: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
6854: igs_he_extract_fields_pkg.get_alt_pers_id
6855: (p_person_id => p_person_id,
6856: p_id_type => 'UCASID',
6857: p_api_id => l_stdnt_id,
6858: p_enrl_start_dt => p_enrl_start_dt,
6859: p_enrl_end_dt => p_enrl_end_dt);
6860:
6861: -- If Student ID is not derived using UCASID the try to get the student id using NMASID
6862: IF l_stdnt_id IS NULL THEN --0
6863: igs_he_extract_fields_pkg.get_alt_pers_id
6864: (p_person_id => p_person_id,
6865: p_id_type => 'NMASID',
6866: p_api_id => l_stdnt_id,
6867: p_enrl_start_dt => p_enrl_start_dt,
6868: p_enrl_end_dt => p_enrl_end_dt);
6869:
6870: -- If Student ID is not derived using UCASID or NMASID then try to get the student id using GTTRID
6871: IF l_stdnt_id IS NULL THEN --1
6872: igs_he_extract_fields_pkg.get_alt_pers_id
6873: (p_person_id => p_person_id,
6874: p_id_type => 'GTTRID',
6875: p_api_id => l_stdnt_id,
6876: p_enrl_start_dt => p_enrl_start_dt,
6877: p_enrl_end_dt => p_enrl_end_dt);
6878:
6879: -- If Student ID is not derived using UCASID or NMASID or GTTRID then try to get the student id using SWASID
6880: IF l_stdnt_id IS NULL THEN
6881: igs_he_extract_fields_pkg.get_alt_pers_id
6882: (p_person_id => p_person_id,
6883: p_id_type => 'SWASID',
6884: p_api_id => l_stdnt_id,
6885: p_enrl_start_dt => p_enrl_start_dt,
6931: EXCEPTION
6932: WHEN OTHERS THEN
6933: write_to_log (SQLERRM);
6934: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
6935: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_ucasnum');
6936: IGS_GE_MSG_STACK.ADD;
6937: App_Exception.Raise_Exception;
6938:
6939: END get_ucasnum ;
7283: WHEN OTHERS
7284: THEN
7285: write_to_log (SQLERRM);
7286: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7287: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_new_prog_length');
7288: IGS_GE_MSG_STACK.ADD;
7289: App_Exception.Raise_Exception;
7290:
7291: END get_new_prog_length;
7322: WHEN OTHERS
7323: THEN
7324: write_to_log (SQLERRM);
7325: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7326: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_marital_status');
7327: IGS_GE_MSG_STACK.ADD;
7328: App_Exception.Raise_Exception;
7329: END get_marital_status;
7330:
7360: WHEN OTHERS
7361: THEN
7362: write_to_log (SQLERRM);
7363: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7364: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_dependants');
7365: IGS_GE_MSG_STACK.ADD;
7366: App_Exception.Raise_Exception;
7367: END get_dependants;
7368:
7400: WHEN OTHERS
7401: THEN
7402: write_to_log (SQLERRM);
7403: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7404: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_enh_fund_elig');
7405: IGS_GE_MSG_STACK.ADD;
7406: App_Exception.Raise_Exception;
7407: END get_enh_fund_elig;
7408:
7458: THEN
7459: CLOSE c_hesa_dis_types;
7460: END IF;
7461: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7462: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_learn_dif');
7463: IGS_GE_MSG_STACK.ADD;
7464: App_Exception.Raise_Exception;
7465: END get_learn_dif;
7466:
7502: WHEN OTHERS
7503: THEN
7504: write_to_log (SQLERRM);
7505: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7506: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_gov_init');
7507: IGS_GE_MSG_STACK.ADD;
7508: App_Exception.Raise_Exception;
7509: END get_gov_init;
7510:
7578: THEN
7579: CLOSE c_unit_count;
7580: END IF;
7581: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7582: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_units_completed');
7583: IGS_GE_MSG_STACK.ADD;
7584: App_Exception.Raise_Exception;
7585: END get_units_completed;
7586:
7617: WHEN OTHERS
7618: THEN
7619: write_to_log (SQLERRM);
7620: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7621: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_disadv_uplift_elig');
7622: IGS_GE_MSG_STACK.ADD;
7623: App_Exception.Raise_Exception;
7624: END get_disadv_uplift_elig;
7625:
7656: WHEN OTHERS
7657: THEN
7658: write_to_log (SQLERRM);
7659: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7660: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_franch_out_arr');
7661: IGS_GE_MSG_STACK.ADD;
7662: App_Exception.Raise_Exception;
7663: END get_franch_out_arr;
7664:
7694: WHEN OTHERS
7695: THEN
7696: write_to_log (SQLERRM);
7697: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7698: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_employer_role');
7699: IGS_GE_MSG_STACK.ADD;
7700: App_Exception.Raise_Exception;
7701: END get_employer_role;
7702:
7733: WHEN OTHERS
7734: THEN
7735: write_to_log (SQLERRM);
7736: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7737: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_franchise_partner');
7738: IGS_GE_MSG_STACK.ADD;
7739: App_Exception.Raise_Exception;
7740: END get_franchise_partner;
7741:
7786: THEN
7787: CLOSE c_lang;
7788: END IF;
7789: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7790: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_welsh_speaker_ind');
7791: IGS_GE_MSG_STACK.ADD;
7792: App_Exception.Raise_Exception;
7793: END get_welsh_speaker_ind;
7794:
7846: THEN
7847: CLOSE c_race;
7848: END IF;
7849: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7850: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_national_id');
7851: IGS_GE_MSG_STACK.ADD;
7852: App_Exception.Raise_Exception;
7853: END get_national_id;
7854:
7920: IF c_welsh_bacc_pass_grd%ISOPEN THEN
7921: CLOSE c_welsh_bacc_pass_grd;
7922: END IF;
7923: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
7924: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_welsh_bacc_qual');
7925: IGS_GE_MSG_STACK.ADD;
7926: App_Exception.Raise_Exception;
7927:
7928: END get_welsh_bacc_qual;
7927:
7928: END get_welsh_bacc_qual;
7929:
7930:
7931: END igs_he_extract_fields_pkg;