APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on FND_MESSAGE

Line 57: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

53: THEN
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:

Line 58: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_hesa_inst_id');

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;

Line 98: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

94: WHEN OTHERS
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;

Line 99: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_campus_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:

Line 142: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

138: EXCEPTION
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;

Line 143: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_alt_pers_id');

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:

Line 356: fnd_message.set_name('IGS','IGS_HE_INVAL_HUSID_RECS_WARN');

352: -- Future Record exists after the HESA submission period
353: -- Log the Message at the Execption Level
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;

Line 357: fnd_message.set_token('PERSON_NO',p_person_id );

353: -- Log the Message at the Execption Level
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;

Line 358: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_he_extract_fields_pkg.get_stdnt_id', fnd_message.get);

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:

Line 511: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');

507: AND api_person_id = l_stdnt_id
508: AND person_id_type = 'HUSID'
509: AND start_dt = l_start_dt;
510:
511: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
512: fnd_Message.Set_Token('PER_ID',p_person_id);
513: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
514: fnd_Message.Set_Token('PID_TYPE','HUSID');
515: fnd_Message.Set_Token('START_DT',TRUNC(l_start_dt));

Line 512: fnd_Message.Set_Token('PER_ID',p_person_id);

508: AND person_id_type = 'HUSID'
509: AND start_dt = l_start_dt;
510:
511: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
512: fnd_Message.Set_Token('PER_ID',p_person_id);
513: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
514: fnd_Message.Set_Token('PID_TYPE','HUSID');
515: fnd_Message.Set_Token('START_DT',TRUNC(l_start_dt));
516: fnd_file.put_line(fnd_file.log,fnd_message.get());

Line 513: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);

509: AND start_dt = l_start_dt;
510:
511: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
512: fnd_Message.Set_Token('PER_ID',p_person_id);
513: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
514: fnd_Message.Set_Token('PID_TYPE','HUSID');
515: fnd_Message.Set_Token('START_DT',TRUNC(l_start_dt));
516: fnd_file.put_line(fnd_file.log,fnd_message.get());
517:

Line 514: fnd_Message.Set_Token('PID_TYPE','HUSID');

510:
511: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
512: fnd_Message.Set_Token('PER_ID',p_person_id);
513: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
514: fnd_Message.Set_Token('PID_TYPE','HUSID');
515: fnd_Message.Set_Token('START_DT',TRUNC(l_start_dt));
516: fnd_file.put_line(fnd_file.log,fnd_message.get());
517:
518: ELSE

Line 515: fnd_Message.Set_Token('START_DT',TRUNC(l_start_dt));

511: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
512: fnd_Message.Set_Token('PER_ID',p_person_id);
513: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
514: fnd_Message.Set_Token('PID_TYPE','HUSID');
515: fnd_Message.Set_Token('START_DT',TRUNC(l_start_dt));
516: fnd_file.put_line(fnd_file.log,fnd_message.get());
517:
518: ELSE
519:

Line 516: fnd_file.put_line(fnd_file.log,fnd_message.get());

512: fnd_Message.Set_Token('PER_ID',p_person_id);
513: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
514: fnd_Message.Set_Token('PID_TYPE','HUSID');
515: fnd_Message.Set_Token('START_DT',TRUNC(l_start_dt));
516: fnd_file.put_line(fnd_file.log,fnd_message.get());
517:
518: ELSE
519:
520: CLOSE c_deleted_husid;

Line 568: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');

564: AND api_person_id = l_stdnt_id
565: AND person_id_type = 'HUSID'
566: AND start_dt = c_husid_rec.end_dt + 1;
567:
568: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
569: fnd_Message.Set_Token('PER_ID',p_person_id);
570: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
571: fnd_Message.Set_Token('PID_TYPE','HUSID');
572: fnd_Message.Set_Token('START_DT',TRUNC(c_husid_rec.end_dt + 1));

Line 569: fnd_Message.Set_Token('PER_ID',p_person_id);

565: AND person_id_type = 'HUSID'
566: AND start_dt = c_husid_rec.end_dt + 1;
567:
568: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
569: fnd_Message.Set_Token('PER_ID',p_person_id);
570: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
571: fnd_Message.Set_Token('PID_TYPE','HUSID');
572: fnd_Message.Set_Token('START_DT',TRUNC(c_husid_rec.end_dt + 1));
573: fnd_file.put_line(fnd_file.log,fnd_message.get());

Line 570: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);

566: AND start_dt = c_husid_rec.end_dt + 1;
567:
568: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
569: fnd_Message.Set_Token('PER_ID',p_person_id);
570: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
571: fnd_Message.Set_Token('PID_TYPE','HUSID');
572: fnd_Message.Set_Token('START_DT',TRUNC(c_husid_rec.end_dt + 1));
573: fnd_file.put_line(fnd_file.log,fnd_message.get());
574:

Line 571: fnd_Message.Set_Token('PID_TYPE','HUSID');

567:
568: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
569: fnd_Message.Set_Token('PER_ID',p_person_id);
570: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
571: fnd_Message.Set_Token('PID_TYPE','HUSID');
572: fnd_Message.Set_Token('START_DT',TRUNC(c_husid_rec.end_dt + 1));
573: fnd_file.put_line(fnd_file.log,fnd_message.get());
574:
575: ELSE

Line 572: fnd_Message.Set_Token('START_DT',TRUNC(c_husid_rec.end_dt + 1));

568: fnd_message.set_name('IGS','IGS_HE_DEL_REC_OPENED');
569: fnd_Message.Set_Token('PER_ID',p_person_id);
570: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
571: fnd_Message.Set_Token('PID_TYPE','HUSID');
572: fnd_Message.Set_Token('START_DT',TRUNC(c_husid_rec.end_dt + 1));
573: fnd_file.put_line(fnd_file.log,fnd_message.get());
574:
575: ELSE
576:

Line 573: fnd_file.put_line(fnd_file.log,fnd_message.get());

569: fnd_Message.Set_Token('PER_ID',p_person_id);
570: fnd_Message.Set_Token('ALT_PID',l_stdnt_id);
571: fnd_Message.Set_Token('PID_TYPE','HUSID');
572: fnd_Message.Set_Token('START_DT',TRUNC(c_husid_rec.end_dt + 1));
573: fnd_file.put_line(fnd_file.log,fnd_message.get());
574:
575: ELSE
576:
577: CLOSE c_deleted_husid;

Line 625: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

621: IF c_deleted_husid%ISOPEN
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;

Line 626: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_stdnt_id');

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:

Line 691: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

687: EXCEPTION
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;

Line 692: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fe_stdnt_mrker');

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:

Line 806: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

802: THEN
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;

Line 807: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_funding_src');

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:

Line 969: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

965: THEN
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;

Line 970: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fundability_cd');

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:

Line 1016: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1012: THEN
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;

Line 1017: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fmly_name_on_16_bday');

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:

Line 1055: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1051: EXCEPTION
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;

Line 1056: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_gender');

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:

Line 1095: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1091: EXCEPTION
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;

Line 1096: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_domicile');

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:

Line 1161: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1157: THEN
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;

Line 1162: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_nationality');

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:

Line 1203: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 1204: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_ethnicity');

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;

Line 1244: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1240: EXCEPTION
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;

Line 1245: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_disability_allow');

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:

Line 1330: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1326: THEN
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;

Line 1331: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_disability');

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:

Line 1370: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1366: EXCEPTION
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;

Line 1371: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_addnl_supp_band');

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:

Line 1428: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1424: THEN
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;

Line 1429: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_yr_left_last_inst');

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:

Line 1499: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1495: EXCEPTION
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;

Line 1500: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_new_ent_to_he');

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:

Line 1540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1536: THEN
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;

Line 1541: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_year_of_prog');

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:

Line 1582: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1578: EXCEPTION
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;

Line 1583: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_special_student');

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:

Line 1687: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1683: THEN
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;

Line 1688: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_year_of_student');

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:

Line 1734: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1730: WHEN OTHERS
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;

Line 1735: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_study_location');

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:

Line 1854: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1850: THEN
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;

Line 1855: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_term_time_acc');

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:

Line 1939: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1935: EXCEPTION
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;

Line 1940: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_awd_conferral_dates');

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:

Line 2004: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2000: THEN
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:

Line 2005: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_min_max_awd_dates');

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;

Line 2092: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2088: THEN
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:

Line 2093: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_awd_dtls');

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;

Line 2175: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2171: EXCEPTION
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;

Line 2176: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_rsn_inst_left');

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:

Line 2288: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2284: THEN
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;

Line 2289: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_completion_status');

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:

Line 2340: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2336: EXCEPTION
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;

Line 2341: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_good_stand_mrkr');

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:

Line 2472: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2468: THEN
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 ;

Line 2473: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_obtained ');

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:

Line 2541: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2537: THEN
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;

Line 2542: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fe_qual_aim');

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:

Line 2597: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2593: EXCEPTION
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:

Line 2598: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_aim_sbj1');

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;

Line 2705: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2701: THEN
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;

Line 2706: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_aim_sbj ');

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:

Line 2742: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2738: EXCEPTION
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:

Line 2743: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.is_ucas_ftug');

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;

Line 2780: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');

2776: IF p_no_of_qual > l_max_no_of_qual
2777: THEN
2778: p_no_of_qual := l_max_no_of_qual;
2779:
2780: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2781: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);

Line 2781: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);

2777: THEN
2778: p_no_of_qual := l_max_no_of_qual;
2779:
2780: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2781: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);

Line 2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);

2778: p_no_of_qual := l_max_no_of_qual;
2779:
2780: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2781: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2786: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_no_of_qual);

Line 2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);

2779:
2780: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2781: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2786: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_no_of_qual);
2787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

Line 2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);

2780: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2781: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2786: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_no_of_qual);
2787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2788:

Line 2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);

2781: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2786: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_no_of_qual);
2787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2788:
2789: END IF;

Line 2786: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_no_of_qual);

2782: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2786: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_no_of_qual);
2787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2788:
2789: END IF;
2790:

Line 2787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

2783: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_no_of_qual);
2784: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2785: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2786: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_no_of_qual);
2787: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2788:
2789: END IF;
2790:
2791: EXCEPTION

Line 2796: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2792: WHEN OTHERS
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;

Line 2797: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.limit_no_of_qual');

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:

Line 2833: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');

2829: IF l_old_tariff_score > l_max_tariff_score
2830: THEN
2831: p_tariff_score := TO_CHAR(l_max_tariff_score);
2832:
2833: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2834: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);

Line 2834: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);

2830: THEN
2831: p_tariff_score := TO_CHAR(l_max_tariff_score);
2832:
2833: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2834: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);

Line 2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);

2831: p_tariff_score := TO_CHAR(l_max_tariff_score);
2832:
2833: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2834: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2839: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_tariff_score);

Line 2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);

2832:
2833: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2834: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2839: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_tariff_score);
2840: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

Line 2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);

2833: FND_MESSAGE.SET_NAME('IGS','IGS_HE_MAX_TARIFF');
2834: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2839: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_tariff_score);
2840: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2841:

Line 2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);

2834: FND_MESSAGE.SET_TOKEN('FIELD_NUM', p_field_number);
2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2839: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_tariff_score);
2840: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2841:
2842: END IF;

Line 2839: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_tariff_score);

2835: FND_MESSAGE.SET_TOKEN('PER_NUM', p_person_number);
2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2839: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_tariff_score);
2840: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2841:
2842: END IF;
2843:

Line 2840: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());

2836: FND_MESSAGE.SET_TOKEN('OLD_NUM', l_old_tariff_score);
2837: FND_MESSAGE.SET_TOKEN('COURSE_CD',p_course_cd);
2838: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_hesa_qual);
2839: FND_MESSAGE.SET_TOKEN('MAX_NUM',l_max_tariff_score);
2840: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET());
2841:
2842: END IF;
2843:
2844: p_tariff_score := LPAD(p_tariff_score, 3, '0');

Line 2851: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2847: WHEN OTHERS
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;

Line 2852: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.limit_tariff_score');

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:

Line 2957: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

2953: THEN
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;

Line 2958: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_gen_qual_aim');

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:

Line 3034: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3030: THEN
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;

Line 3035: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_awd_body_12');

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:

Line 3110: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3106: EXCEPTION
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;

Line 3111: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_prog_length');

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:

Line 3149: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3145: EXCEPTION
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;

Line 3150: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_teach_train_crs_id');

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:

Line 3189: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3185: EXCEPTION
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;

Line 3190: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_itt_phsc');

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:

Line 3229: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3225: EXCEPTION
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;

Line 3230: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_itt_mrker');

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:

Line 3269: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3265: EXCEPTION
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;

Line 3270: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_teach_qual_sect');

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:

Line 3309: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3305: EXCEPTION
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;

Line 3310: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_teach_qual_sbj');

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:

Line 3463: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3459: THEN
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;

Line 3464: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fee_elig');

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:

Line 3518: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3514: EXCEPTION
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;

Line 3519: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_fee_band');

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:

Line 3610: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3606: THEN
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;

Line 3611: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_amt_tuition_fees');

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:

Line 3900: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 3901: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.GET_MAJ_SRC_TU_FEE - '||SQLERRM);

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:

Line 3940: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3936: EXCEPTION
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;

Line 3941: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_religion');

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:

Line 3982: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

3978: EXCEPTION
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;

Line 3983: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_sldd_disc_prv');

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:

Line 4025: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4021: EXCEPTION
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;

Line 4026: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_non_payment_rsn');

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:

Line 4140: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4136: THEN
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;

Line 4141: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_oth_teach_inst');

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:

Line 4264: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4260: THEN
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;

Line 4265: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_prop_not_taught');

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:

Line 4307: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4303: EXCEPTION
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;

Line 4308: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_credit_trans_sch');

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:

Line 4349: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4345: EXCEPTION
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;

Line 4350: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_credit_level');

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:

Line 4497: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

4493: THEN
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;

Line 4498: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_credit_obtained');

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:

Line 5039: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5035: IF c_cc%ISOPEN THEN
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:

Line 5040: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_cost_centres');

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;

Line 5162: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5158: THEN
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;

Line 5163: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_studies_susp');

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:

Line 5201: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5197: EXCEPTION
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;

Line 5202: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_pyr_type');

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:

Line 5242: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5238: EXCEPTION
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;

Line 5243: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_lvl_appl_to_fund');

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:

Line 5499: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 5500: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_comp_pyr_study');

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;

Line 5540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5536: EXCEPTION
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;

Line 5541: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_destination');

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:

Line 5582: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5578: EXCEPTION
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;

Line 5583: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_itt_outcome');

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:

Line 5621: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5617: EXCEPTION
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;

Line 5622: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_ufi_place');

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:

Line 5665: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5661: EXCEPTION
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;

Line 5666: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_franchising_activity');

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:

Line 5707: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5703: EXCEPTION
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;

Line 5708: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_social_class_ind');

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:

Line 5747: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5743: EXCEPTION
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;

Line 5748: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_occupation_code');

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:

Line 5893: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5889: THEN
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;

Line 5894: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_inst_last_attended');

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:

Line 5944: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5940: EXCEPTION
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;

Line 5945: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_regulatory_body');

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:

Line 5986: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5982: EXCEPTION
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;

Line 5987: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_nhs_fund_src');

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:

Line 6026: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6022: EXCEPTION
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;

Line 6027: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_nhs_employer');

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:

Line 6085: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6081: THEN
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;

Line 6086: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_qual_dets');

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:

Line 6308: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6304: EXCEPTION
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;

Line 6309: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_module_dets');

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:

Line 6400: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6396: WHEN OTHERS
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;

Line 6401: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mode_of_study');

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:

Line 6512: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6508: THEN
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;

Line 6513: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.isDormant');

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:

Line 6571: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6567: WHEN NOT_NUMBER_EXCEP THEN
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;

Line 6572: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mod_prop_fte');

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:

Line 6622: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6618: THEN
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;

Line 6623: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mod_prop_not_taught');

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:

Line 6681: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6677: THEN
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;

Line 6682: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_mod_oth_teach_inst');

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:

Line 6745: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6741: EXCEPTION
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;

Line 6746: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_pgce_class');

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:

Line 6813: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

6809: EXCEPTION
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:

Line 6814: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_commencement_dt');

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;

Line 6934: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 6935: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_ucasnum');

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 ;

Line 7286: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7282: EXCEPTION
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:

Line 7287: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_new_prog_length');

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;

Line 7325: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7321: EXCEPTION
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;

Line 7326: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_marital_status');

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:

Line 7363: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7359: EXCEPTION
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;

Line 7364: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_dependants');

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:

Line 7403: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7399: EXCEPTION
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;

Line 7404: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_enh_fund_elig');

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:

Line 7461: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7457: IF c_hesa_dis_types%ISOPEN
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;

Line 7462: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_learn_dif');

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:

Line 7505: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7501: EXCEPTION
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;

Line 7506: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_gov_init');

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:

Line 7581: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7577: IF c_unit_count%ISOPEN
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;

Line 7582: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_units_completed');

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:

Line 7620: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7616: EXCEPTION
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;

Line 7621: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_disadv_uplift_elig');

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:

Line 7659: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7655: EXCEPTION
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;

Line 7660: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_franch_out_arr');

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:

Line 7697: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7693: EXCEPTION
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;

Line 7698: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_employer_role');

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:

Line 7736: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7732: EXCEPTION
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;

Line 7737: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_franchise_partner');

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:

Line 7789: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7785: IF c_lang%ISOPEN
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;

Line 7790: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_welsh_speaker_ind');

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:

Line 7849: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7845: IF c_race%ISOPEN
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;

Line 7850: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_national_id');

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:

Line 7923: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

7919: END IF;
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:

Line 7924: Fnd_Message.Set_Token('NAME','IGS_HE_EXTRACT_FIELDS_PKG.get_welsh_bacc_qual');

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;