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 APP_EXCEPTION

Line 60: App_Exception.Raise_Exception;

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

Line 101: App_Exception.Raise_Exception;

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:
105: PROCEDURE get_alt_pers_id

Line 145: App_Exception.Raise_Exception;

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:
149: PROCEDURE get_stdnt_id

Line 628: App_Exception.Raise_Exception;

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:
632: PROCEDURE get_fe_stdnt_mrker

Line 694: App_Exception.Raise_Exception;

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:
698: PROCEDURE get_funding_src

Line 809: App_Exception.Raise_Exception;

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:
813: PROCEDURE get_fundability_cd

Line 972: App_Exception.Raise_Exception;

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:
976: PROCEDURE get_fmly_name_on_16_bday

Line 1019: App_Exception.Raise_Exception;

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:
1023: PROCEDURE get_gender

Line 1058: App_Exception.Raise_Exception;

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:
1062: PROCEDURE get_domicile

Line 1098: App_Exception.Raise_Exception;

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:
1102: PROCEDURE get_nationality

Line 1164: App_Exception.Raise_Exception;

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:
1168: PROCEDURE get_ethnicity (

Line 1206: App_Exception.Raise_Exception;

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

Line 1247: App_Exception.Raise_Exception;

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:
1251: PROCEDURE get_disablity

Line 1333: App_Exception.Raise_Exception;

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:
1337: PROCEDURE get_addnl_supp_band

Line 1373: App_Exception.Raise_Exception;

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:
1377: PROCEDURE get_yr_left_last_inst

Line 1431: App_Exception.Raise_Exception;

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:
1435: PROCEDURE get_new_ent_to_he

Line 1502: App_Exception.Raise_Exception;

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:
1506: PROCEDURE get_year_of_prog

Line 1543: App_Exception.Raise_Exception;

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:
1547: PROCEDURE get_special_student

Line 1585: App_Exception.Raise_Exception;

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:
1589: PROCEDURE get_year_of_student

Line 1690: App_Exception.Raise_Exception;

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:
1694: PROCEDURE get_study_location

Line 1737: App_Exception.Raise_Exception;

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

Line 1857: App_Exception.Raise_Exception;

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:
1861: /***************************************************************

Line 1942: App_Exception.Raise_Exception;

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
1946: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,

Line 2007: App_Exception.Raise_Exception;

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

Line 2095: App_Exception.Raise_Exception;

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

Line 2178: App_Exception.Raise_Exception;

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

Line 2291: App_Exception.Raise_Exception;

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

Line 2343: App_Exception.Raise_Exception;

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:
2347: PROCEDURE get_qual_obtained

Line 2475: App_Exception.Raise_Exception;

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:
2479: PROCEDURE get_fe_qual_aim

Line 2544: App_Exception.Raise_Exception;

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
2548: (p_qual_aim_subj1 IN igs_he_st_spa.qual_aim_subj1%TYPE,

Line 2600: App_Exception.Raise_Exception;

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:
2604: PROCEDURE get_qual_aim_sbj

Line 2708: App_Exception.Raise_Exception;

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,
2712: p_hesa_commdate IN igs_he_ex_rn_dat_fd.value%TYPE,

Line 2745: App_Exception.Raise_Exception;

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:
2749: PROCEDURE limit_no_of_qual(p_field_number IN NUMBER,

Line 2799: App_Exception.Raise_Exception;

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,
2803: p_person_number IN igs_pe_person.person_number%TYPE,

Line 2854: App_Exception.Raise_Exception;

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
2858: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 2960: App_Exception.Raise_Exception;

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

Line 3037: App_Exception.Raise_Exception;

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

Line 3113: App_Exception.Raise_Exception;

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
3117: (p_prg_ttcid IN igs_he_st_prog.teacher_train_prog_id%TYPE,

Line 3152: App_Exception.Raise_Exception;

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:
3156: PROCEDURE get_itt_phsc

Line 3192: App_Exception.Raise_Exception;

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:
3196: PROCEDURE get_itt_mrker

Line 3232: App_Exception.Raise_Exception;

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

Line 3272: App_Exception.Raise_Exception;

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

Line 3312: App_Exception.Raise_Exception;

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:
3316: PROCEDURE get_fee_elig

Line 3466: App_Exception.Raise_Exception;

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

Line 3521: App_Exception.Raise_Exception;

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:
3525: PROCEDURE get_amt_tuition_fees

Line 3613: App_Exception.Raise_Exception;

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:
3617: PROCEDURE get_maj_src_tu_fee

Line 3903: App_Exception.Raise_Exception;

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

Line 3943: App_Exception.Raise_Exception;

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

Line 3985: App_Exception.Raise_Exception;

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

Line 4028: App_Exception.Raise_Exception;

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:
4032: PROCEDURE get_oth_teach_inst

Line 4143: App_Exception.Raise_Exception;

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:
4147: PROCEDURE get_prop_not_taught

Line 4267: App_Exception.Raise_Exception;

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

Line 4310: App_Exception.Raise_Exception;

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

Line 4352: App_Exception.Raise_Exception;

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:
4356: PROCEDURE get_credit_obtained

Line 4500: App_Exception.Raise_Exception;

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:
4504: PROCEDURE get_cost_centres

Line 5042: App_Exception.Raise_Exception;

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:
5046: PROCEDURE get_studies_susp

Line 5165: App_Exception.Raise_Exception;

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:
5169: PROCEDURE get_pyr_type

Line 5204: App_Exception.Raise_Exception;

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:
5208: PROCEDURE get_lvl_appl_to_fund

Line 5245: App_Exception.Raise_Exception;

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:
5249: PROCEDURE get_comp_pyr_study(

Line 5502: App_Exception.Raise_Exception;

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

Line 5543: App_Exception.Raise_Exception;

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

Line 5585: App_Exception.Raise_Exception;

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:
5589: PROCEDURE get_ufi_place

Line 5624: App_Exception.Raise_Exception;

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

Line 5668: App_Exception.Raise_Exception;

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

Line 5710: App_Exception.Raise_Exception;

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

Line 5750: App_Exception.Raise_Exception;

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

Line 5896: App_Exception.Raise_Exception;

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

Line 5947: App_Exception.Raise_Exception;

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

Line 5989: App_Exception.Raise_Exception;

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

Line 6029: App_Exception.Raise_Exception;

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:
6033: PROCEDURE get_qual_dets

Line 6088: App_Exception.Raise_Exception;

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

Line 6311: App_Exception.Raise_Exception;

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

Line 6403: App_Exception.Raise_Exception;

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

Line 6515: App_Exception.Raise_Exception;

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:
6519: PROCEDURE get_mod_prop_fte

Line 6574: App_Exception.Raise_Exception;

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:
6578: PROCEDURE get_mod_prop_not_taught

Line 6625: App_Exception.Raise_Exception;

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

Line 6684: App_Exception.Raise_Exception;

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:
6688: PROCEDURE get_pgce_class

Line 6748: App_Exception.Raise_Exception;

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

Line 6816: App_Exception.Raise_Exception;

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:
6820: PROCEDURE get_ucasnum(p_person_id IN igs_pe_person.person_id%TYPE,

Line 6937: App_Exception.Raise_Exception;

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:
6941: PROCEDURE get_new_prog_length

Line 7289: App_Exception.Raise_Exception;

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:
7293: PROCEDURE get_marital_status

Line 7328: App_Exception.Raise_Exception;

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
7332: (p_oss_dependants IN igs_he_st_spa.dependants_cd%TYPE,

Line 7366: App_Exception.Raise_Exception;

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:
7370: PROCEDURE get_enh_fund_elig

Line 7406: App_Exception.Raise_Exception;

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:
7410: PROCEDURE get_learn_dif

Line 7464: App_Exception.Raise_Exception;

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

Line 7508: App_Exception.Raise_Exception;

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
7512: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 7584: App_Exception.Raise_Exception;

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
7588: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,

Line 7623: App_Exception.Raise_Exception;

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
7627: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,

Line 7662: App_Exception.Raise_Exception;

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
7666: (p_spa_employer_role_cd IN igs_he_st_spa.employer_role_cd%TYPE,

Line 7700: App_Exception.Raise_Exception;

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:
7704: PROCEDURE get_franchise_partner

Line 7739: App_Exception.Raise_Exception;

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:
7743: PROCEDURE get_welsh_speaker_ind

Line 7792: App_Exception.Raise_Exception;

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
7796: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 7852: App_Exception.Raise_Exception;

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:
7856: -- anwest 19-Dec-05 Changes as per (4731723) HE360 - HESA REQUIREMENTS FOR 2005/06 REPORTING

Line 7926: App_Exception.Raise_Exception;

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