eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_GE_MSG_STACK

Line 59: IGS_GE_MSG_STACK.ADD;

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;
63:

Line 100: IGS_GE_MSG_STACK.ADD;

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:
104:

Line 144: IGS_GE_MSG_STACK.ADD;

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:
148:

Line 627: IGS_GE_MSG_STACK.ADD;

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:
631:

Line 693: IGS_GE_MSG_STACK.ADD;

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:
697:

Line 808: IGS_GE_MSG_STACK.ADD;

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:
812:

Line 971: IGS_GE_MSG_STACK.ADD;

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:
975:

Line 1018: IGS_GE_MSG_STACK.ADD;

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:
1022:

Line 1057: IGS_GE_MSG_STACK.ADD;

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:
1061:

Line 1097: IGS_GE_MSG_STACK.ADD;

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:
1101:

Line 1163: IGS_GE_MSG_STACK.ADD;

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:
1167:

Line 1205: IGS_GE_MSG_STACK.ADD;

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;
1209:

Line 1246: IGS_GE_MSG_STACK.ADD;

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:
1250:

Line 1332: IGS_GE_MSG_STACK.ADD;

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:
1336:

Line 1372: IGS_GE_MSG_STACK.ADD;

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:
1376:

Line 1430: IGS_GE_MSG_STACK.ADD;

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:
1434:

Line 1501: IGS_GE_MSG_STACK.ADD;

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:
1505:

Line 1542: IGS_GE_MSG_STACK.ADD;

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:
1546:

Line 1584: IGS_GE_MSG_STACK.ADD;

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:
1588:

Line 1689: IGS_GE_MSG_STACK.ADD;

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:
1693:

Line 1736: IGS_GE_MSG_STACK.ADD;

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:
1740:

Line 1856: IGS_GE_MSG_STACK.ADD;

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:
1860:

Line 1941: IGS_GE_MSG_STACK.ADD;

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:
1945: PROCEDURE get_min_max_awd_dates

Line 2006: IGS_GE_MSG_STACK.ADD;

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;
2010:

Line 2094: IGS_GE_MSG_STACK.ADD;

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;
2098:

Line 2177: IGS_GE_MSG_STACK.ADD;

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:
2181:

Line 2290: IGS_GE_MSG_STACK.ADD;

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:
2294:

Line 2342: IGS_GE_MSG_STACK.ADD;

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:
2346:

Line 2474: IGS_GE_MSG_STACK.ADD;

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:
2478:

Line 2543: IGS_GE_MSG_STACK.ADD;

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:
2547: PROCEDURE get_qual_aim_sbj1

Line 2599: IGS_GE_MSG_STACK.ADD;

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;
2603:

Line 2707: IGS_GE_MSG_STACK.ADD;

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:
2711: FUNCTION is_ucas_ftug (p_hesa_qual_aim IN igs_he_ex_rn_dat_fd.value%TYPE,

Line 2744: IGS_GE_MSG_STACK.ADD;

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;
2748:

Line 2798: IGS_GE_MSG_STACK.ADD;

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:
2802: PROCEDURE limit_tariff_score(p_field_number IN NUMBER,

Line 2853: IGS_GE_MSG_STACK.ADD;

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:
2857: PROCEDURE get_gen_qual_aim

Line 2959: IGS_GE_MSG_STACK.ADD;

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:
2963:

Line 3036: IGS_GE_MSG_STACK.ADD;

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:
3040:

Line 3112: IGS_GE_MSG_STACK.ADD;

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:
3116: PROCEDURE get_teach_train_crs_id

Line 3151: IGS_GE_MSG_STACK.ADD;

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:
3155:

Line 3191: IGS_GE_MSG_STACK.ADD;

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:
3195:

Line 3231: IGS_GE_MSG_STACK.ADD;

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:
3235:

Line 3271: IGS_GE_MSG_STACK.ADD;

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:
3275:

Line 3311: IGS_GE_MSG_STACK.ADD;

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:
3315:

Line 3465: IGS_GE_MSG_STACK.ADD;

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:
3469:

Line 3520: IGS_GE_MSG_STACK.ADD;

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:
3524:

Line 3612: IGS_GE_MSG_STACK.ADD;

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:
3616:

Line 3902: IGS_GE_MSG_STACK.ADD;

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:
3906:

Line 3942: IGS_GE_MSG_STACK.ADD;

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:
3946:

Line 3984: IGS_GE_MSG_STACK.ADD;

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:
3988:

Line 4027: IGS_GE_MSG_STACK.ADD;

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:
4031:

Line 4142: IGS_GE_MSG_STACK.ADD;

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:
4146:

Line 4266: IGS_GE_MSG_STACK.ADD;

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:
4270:

Line 4309: IGS_GE_MSG_STACK.ADD;

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:
4313:

Line 4351: IGS_GE_MSG_STACK.ADD;

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:
4355:

Line 4499: IGS_GE_MSG_STACK.ADD;

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:
4503:

Line 5041: IGS_GE_MSG_STACK.ADD;

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;
5045:

Line 5164: IGS_GE_MSG_STACK.ADD;

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:
5168:

Line 5203: IGS_GE_MSG_STACK.ADD;

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:
5207:

Line 5244: IGS_GE_MSG_STACK.ADD;

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:
5248:

Line 5501: IGS_GE_MSG_STACK.ADD;

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;
5505:

Line 5542: IGS_GE_MSG_STACK.ADD;

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:
5546:

Line 5584: IGS_GE_MSG_STACK.ADD;

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:
5588:

Line 5623: IGS_GE_MSG_STACK.ADD;

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:
5627:

Line 5667: IGS_GE_MSG_STACK.ADD;

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:
5671:

Line 5709: IGS_GE_MSG_STACK.ADD;

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:
5713:

Line 5749: IGS_GE_MSG_STACK.ADD;

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:
5753:

Line 5895: IGS_GE_MSG_STACK.ADD;

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:
5899:

Line 5946: IGS_GE_MSG_STACK.ADD;

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:
5950:

Line 5988: IGS_GE_MSG_STACK.ADD;

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:
5992:

Line 6028: IGS_GE_MSG_STACK.ADD;

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:
6032:

Line 6087: IGS_GE_MSG_STACK.ADD;

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:
6091:

Line 6310: IGS_GE_MSG_STACK.ADD;

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:
6314:

Line 6402: IGS_GE_MSG_STACK.ADD;

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:
6406:

Line 6514: IGS_GE_MSG_STACK.ADD;

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:
6518:

Line 6573: IGS_GE_MSG_STACK.ADD;

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:
6577:

Line 6624: IGS_GE_MSG_STACK.ADD;

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:
6628:

Line 6683: IGS_GE_MSG_STACK.ADD;

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:
6687:

Line 6747: IGS_GE_MSG_STACK.ADD;

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:
6751:

Line 6815: IGS_GE_MSG_STACK.ADD;

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;
6819:

Line 6936: IGS_GE_MSG_STACK.ADD;

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 ;
6940:

Line 7288: IGS_GE_MSG_STACK.ADD;

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;
7292:

Line 7327: IGS_GE_MSG_STACK.ADD;

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:
7331: PROCEDURE get_dependants

Line 7365: IGS_GE_MSG_STACK.ADD;

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:
7369:

Line 7405: IGS_GE_MSG_STACK.ADD;

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:
7409:

Line 7463: IGS_GE_MSG_STACK.ADD;

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:
7467:

Line 7507: IGS_GE_MSG_STACK.ADD;

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:
7511: PROCEDURE get_units_completed

Line 7583: IGS_GE_MSG_STACK.ADD;

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:
7587: PROCEDURE get_disadv_uplift_elig

Line 7622: IGS_GE_MSG_STACK.ADD;

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:
7626: PROCEDURE get_franch_out_arr

Line 7661: IGS_GE_MSG_STACK.ADD;

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:
7665: PROCEDURE get_employer_role

Line 7699: IGS_GE_MSG_STACK.ADD;

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:
7703:

Line 7738: IGS_GE_MSG_STACK.ADD;

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:
7742:

Line 7791: IGS_GE_MSG_STACK.ADD;

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:
7795: PROCEDURE get_national_id

Line 7851: IGS_GE_MSG_STACK.ADD;

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:
7855:

Line 7925: IGS_GE_MSG_STACK.ADD;

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;
7929: