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.IGF_GR_GEN dependencies on FND_MESSAGE

Line 245: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

241: END IF;
242:
243: EXCEPTION
244: WHEN OTHERS THEN
245: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
246: fnd_message.set_token('NAME','IGF_GR_GEN.GET_ALT_CODE'|| ' ' || SQLERRM);
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249:

Line 246: fnd_message.set_token('NAME','IGF_GR_GEN.GET_ALT_CODE'|| ' ' || SQLERRM);

242:
243: EXCEPTION
244: WHEN OTHERS THEN
245: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
246: fnd_message.set_token('NAME','IGF_GR_GEN.GET_ALT_CODE'|| ' ' || SQLERRM);
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249:
250:

Line 295: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

291: END IF;
292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
296: fnd_message.set_token('NAME','IGF_GR_GEN.GET_CALENDAR_DESC'|| ' ' || SQLERRM);
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299:

Line 296: fnd_message.set_token('NAME','IGF_GR_GEN.GET_CALENDAR_DESC'|| ' ' || SQLERRM);

292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
296: fnd_message.set_token('NAME','IGF_GR_GEN.GET_CALENDAR_DESC'|| ' ' || SQLERRM);
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299:
300:

Line 344: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

340: END IF;
341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
345: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);
346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348:

Line 345: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);

341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
345: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);
346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348:
349: END get_per_num;

Line 391: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

387: END IF;
388:
389: EXCEPTION
390: WHEN OTHERS THEN
391: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
392: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395:

Line 392: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);

388:
389: EXCEPTION
390: WHEN OTHERS THEN
391: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
392: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM'|| ' ' || SQLERRM);
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395:
396: END get_per_num;

Line 434: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

430: END IF;
431:
432: EXCEPTION
433: WHEN OTHERS THEN
434: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
435: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_ID'|| ' ' || SQLERRM);
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438:

Line 435: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_ID'|| ' ' || SQLERRM);

431:
432: EXCEPTION
433: WHEN OTHERS THEN
434: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
435: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_ID'|| ' ' || SQLERRM);
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438:
439: END get_person_id;

Line 477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

473: END IF;
474:
475: EXCEPTION
476: WHEN OTHERS THEN
477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM_OSS'|| ' ' || SQLERRM);
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481:

Line 478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM_OSS'|| ' ' || SQLERRM);

474:
475: EXCEPTION
476: WHEN OTHERS THEN
477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PER_NUM_OSS'|| ' ' || SQLERRM);
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481:
482: END get_per_num_oss;

Line 568: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);

564: --
565: -- This will ensure exception raised from the isnert hold tbh
566: -- are is not thrown
567: --
568: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);
569: IF l_name = 'IGF_DB_HOLD_EXISTS' THEN
570: NULL;
571: ELSE
572: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 572: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

568: fnd_message.parse_encoded(fnd_message.get_encoded, l_app, l_name);
569: IF l_name = 'IGF_DB_HOLD_EXISTS' THEN
570: NULL;
571: ELSE
572: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
573: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_SYS_HOLDS'|| ' ' || SQLERRM);
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;

Line 573: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_SYS_HOLDS'|| ' ' || SQLERRM);

569: IF l_name = 'IGF_DB_HOLD_EXISTS' THEN
570: NULL;
571: ELSE
572: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
573: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_SYS_HOLDS'|| ' ' || SQLERRM);
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577:

Line 710: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

706: WHEN no_file_version THEN
707: RAISE;
708:
709: WHEN OTHERS THEN
710: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
711: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_HEADER'|| ' ' || SQLERRM);
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714:

Line 711: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_HEADER'|| ' ' || SQLERRM);

707: RAISE;
708:
709: WHEN OTHERS THEN
710: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
711: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_HEADER'|| ' ' || SQLERRM);
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714:
715:

Line 785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

781: WHEN no_file_version THEN
782: RAISE;
783:
784: WHEN OTHERS THEN
785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
786: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_TRAILER'|| ' ' || SQLERRM);
787: igs_ge_msg_stack.add;
788: app_exception.raise_exception;
789:

Line 786: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_TRAILER'|| ' ' || SQLERRM);

782: RAISE;
783:
784: WHEN OTHERS THEN
785: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
786: fnd_message.set_token('NAME','IGF_GR_GEN.PREPARE_TRAILER'|| ' ' || SQLERRM);
787: igs_ge_msg_stack.add;
788: app_exception.raise_exception;
789:
790: END get_pell_trailer;

Line 897: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');

893: FETCH cur_header INTO header_rec;
894:
895: IF cur_header%NOTFOUND THEN
896: CLOSE cur_header;
897: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
898: -- File uploaded is incomplete.
899: igs_ge_msg_stack.add;
900: RAISE file_not_loaded;
901: END IF;

Line 953: fnd_message.set_name('IGF','IGF_GR_BATCH_REJ');

949: IF TO_NUMBER(l_batch_rej_reason) > 0 THEN
950:
951: p_number_rec := 0;
952: fnd_file.new_line(fnd_file.log,1);
953: fnd_message.set_name('IGF','IGF_GR_BATCH_REJ');
954: fnd_file.put_line(fnd_file.log,fnd_message.get);
955: fnd_file.new_line(fnd_file.log,1);
956:
957: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID') ||' ' || p_batch_id);

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

950:
951: p_number_rec := 0;
952: fnd_file.new_line(fnd_file.log,1);
953: fnd_message.set_name('IGF','IGF_GR_BATCH_REJ');
954: fnd_file.put_line(fnd_file.log,fnd_message.get);
955: fnd_file.new_line(fnd_file.log,1);
956:
957: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID') ||' ' || p_batch_id);
958: fnd_file.put_line(fnd_file.log,RPAD('-',35,'-'));

Line 993: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_ORIG_BTCH_REC');

989: IF lb_error_cd THEN
990: ----Bug #2938258
991: IF p_file_type = 'GR_RFMS_ORIG' THEN
992:
993: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_ORIG_BTCH_REC');
994: fnd_message.set_token('BATCH_ID',p_batch_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: fnd_file.new_line(fnd_file.log,1);
997:

Line 994: fnd_message.set_token('BATCH_ID',p_batch_id);

990: ----Bug #2938258
991: IF p_file_type = 'GR_RFMS_ORIG' THEN
992:
993: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_ORIG_BTCH_REC');
994: fnd_message.set_token('BATCH_ID',p_batch_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: fnd_file.new_line(fnd_file.log,1);
997:
998: l_rfmb_id:=rfms_batch_rec.rfmb_id;

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

991: IF p_file_type = 'GR_RFMS_ORIG' THEN
992:
993: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_ORIG_BTCH_REC');
994: fnd_message.set_token('BATCH_ID',p_batch_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: fnd_file.new_line(fnd_file.log,1);
997:
998: l_rfmb_id:=rfms_batch_rec.rfmb_id;
999:

Line 1066: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_DISB_BTCH_REC');

1062:
1063: END LOOP;
1064: ELSIF p_file_type = 'GR_RFMS_DISB_ORIG' THEN
1065:
1066: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_DISB_BTCH_REC');
1067: fnd_message.set_token('BATCH_ID',p_batch_id);
1068: fnd_file.put_line(fnd_file.log,fnd_message.get);
1069: fnd_file.new_line(fnd_file.log,1);
1070: l_disb_rfmb_id:=rfms_batch_rec.rfmb_id;

Line 1067: fnd_message.set_token('BATCH_ID',p_batch_id);

1063: END LOOP;
1064: ELSIF p_file_type = 'GR_RFMS_DISB_ORIG' THEN
1065:
1066: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_DISB_BTCH_REC');
1067: fnd_message.set_token('BATCH_ID',p_batch_id);
1068: fnd_file.put_line(fnd_file.log,fnd_message.get);
1069: fnd_file.new_line(fnd_file.log,1);
1070: l_disb_rfmb_id:=rfms_batch_rec.rfmb_id;
1071: FOR cur_get_rfms_disb IN cur_gr_rfms_disb ( l_disb_rfmb_id )

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

1064: ELSIF p_file_type = 'GR_RFMS_DISB_ORIG' THEN
1065:
1066: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_DISB_BTCH_REC');
1067: fnd_message.set_token('BATCH_ID',p_batch_id);
1068: fnd_file.put_line(fnd_file.log,fnd_message.get);
1069: fnd_file.new_line(fnd_file.log,1);
1070: l_disb_rfmb_id:=rfms_batch_rec.rfmb_id;
1071: FOR cur_get_rfms_disb IN cur_gr_rfms_disb ( l_disb_rfmb_id )
1072: LOOP

Line 1106: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');

1102:
1103: END IF;
1104:
1105: ELSE
1106: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
1107: igs_ge_msg_stack.add;
1108: RAISE file_not_loaded;
1109: END IF;
1110:

Line 1119: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');

1115: -- check for a proper trailer record
1116:
1117: IF cur_trailer%NOTFOUND THEN
1118: CLOSE cur_trailer;
1119: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
1120: --File uploaded is incomplete.
1121: igs_ge_msg_stack.add;
1122: RAISE file_not_loaded;
1123: END IF;

Line 1165: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1161: RAISE;
1162:
1163: WHEN OTHERS THEN
1164:
1165: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1166: fnd_message.set_token('NAME','IGF_GR_GEN.PROCESS_PELL_ACK'|| ' ' || SQLERRM);
1167: igs_ge_msg_stack.add;
1168: app_exception.raise_exception;
1169:

Line 1166: fnd_message.set_token('NAME','IGF_GR_GEN.PROCESS_PELL_ACK'|| ' ' || SQLERRM);

1162:
1163: WHEN OTHERS THEN
1164:
1165: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1166: fnd_message.set_token('NAME','IGF_GR_GEN.PROCESS_PELL_ACK'|| ' ' || SQLERRM);
1167: igs_ge_msg_stack.add;
1168: app_exception.raise_exception;
1169:
1170: END process_pell_ack;

Line 1217: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1213: EXCEPTION
1214:
1215: WHEN OTHERS THEN
1216:
1217: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1218: fnd_message.set_token('NAME','IGF_GR_GEN.SEND_ORIG_DISB'|| ' ' || SQLERRM);
1219: igs_ge_msg_stack.add;
1220: app_exception.raise_exception;
1221:

Line 1218: fnd_message.set_token('NAME','IGF_GR_GEN.SEND_ORIG_DISB'|| ' ' || SQLERRM);

1214:
1215: WHEN OTHERS THEN
1216:
1217: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1218: fnd_message.set_token('NAME','IGF_GR_GEN.SEND_ORIG_DISB'|| ' ' || SQLERRM);
1219: igs_ge_msg_stack.add;
1220: app_exception.raise_exception;
1221:
1222: END send_orig_disb;

Line 1255: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254:
1255: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1256: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_PELL_DISB'|| ' ' || SQLERRM);
1257: igs_ge_msg_stack.add;
1258: app_exception.raise_exception;
1259:

Line 1256: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_PELL_DISB'|| ' ' || SQLERRM);

1252: EXCEPTION
1253: WHEN OTHERS THEN
1254:
1255: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1256: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_PELL_DISB'|| ' ' || SQLERRM);
1257: igs_ge_msg_stack.add;
1258: app_exception.raise_exception;
1259:
1260:

Line 1291: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1287:
1288: EXCEPTION
1289: WHEN OTHERS THEN
1290:
1291: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1292: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_AWD_DISB'|| ' ' || SQLERRM);
1293: igs_ge_msg_stack.add;
1294: app_exception.raise_exception;
1295:

Line 1292: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_AWD_DISB'|| ' ' || SQLERRM);

1288: EXCEPTION
1289: WHEN OTHERS THEN
1290:
1291: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1292: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_AWD_DISB'|| ' ' || SQLERRM);
1293: igs_ge_msg_stack.add;
1294: app_exception.raise_exception;
1295:
1296: END get_min_awd_disb;

Line 1382: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1378: EXCEPTION
1379:
1380: WHEN OTHERS THEN
1381:
1382: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1383: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PELL_EFC_CODE'|| ' ' || SQLERRM);
1384: igs_ge_msg_stack.add;
1385: app_exception.raise_exception;
1386:

Line 1383: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PELL_EFC_CODE'|| ' ' || SQLERRM);

1379:
1380: WHEN OTHERS THEN
1381:
1382: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1383: fnd_message.set_token('NAME','IGF_GR_GEN.GET_PELL_EFC_CODE'|| ' ' || SQLERRM);
1384: igs_ge_msg_stack.add;
1385: app_exception.raise_exception;
1386:
1387: END get_pell_efc_code;

Line 1438: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1434: EXCEPTION
1435:
1436: WHEN OTHERS THEN
1437:
1438: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1439: fnd_message.set_token('NAME','IGF_GR_GEN.FRESH_ORIGINTN'|| ' ' || SQLERRM);
1440: igs_ge_msg_stack.add;
1441: app_exception.raise_exception;
1442:

Line 1439: fnd_message.set_token('NAME','IGF_GR_GEN.FRESH_ORIGINTN'|| ' ' || SQLERRM);

1435:
1436: WHEN OTHERS THEN
1437:
1438: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1439: fnd_message.set_token('NAME','IGF_GR_GEN.FRESH_ORIGINTN'|| ' ' || SQLERRM);
1440: igs_ge_msg_stack.add;
1441: app_exception.raise_exception;
1442:
1443: END fresh_origintn;

Line 1477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1473: EXCEPTION
1474:
1475: WHEN OTHERS THEN
1476:
1477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_FUND_ID'|| ' ' || SQLERRM);
1479: igs_ge_msg_stack.add;
1480: app_exception.raise_exception;
1481:

Line 1478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_FUND_ID'|| ' ' || SQLERRM);

1474:
1475: WHEN OTHERS THEN
1476:
1477: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1478: fnd_message.set_token('NAME','IGF_GR_GEN.GET_FUND_ID'|| ' ' || SQLERRM);
1479: igs_ge_msg_stack.add;
1480: app_exception.raise_exception;
1481:
1482:

Line 1508: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1504: EXCEPTION
1505:
1506: WHEN OTHERS THEN
1507:
1508: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1509: fnd_message.set_token('NAME','IGF_GR_GEN.GET_SSN_DIGITS'|| ' ' || SQLERRM);
1510: igs_ge_msg_stack.add;
1511: app_exception.raise_exception;
1512:

Line 1509: fnd_message.set_token('NAME','IGF_GR_GEN.GET_SSN_DIGITS'|| ' ' || SQLERRM);

1505:
1506: WHEN OTHERS THEN
1507:
1508: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1509: fnd_message.set_token('NAME','IGF_GR_GEN.GET_SSN_DIGITS'|| ' ' || SQLERRM);
1510: igs_ge_msg_stack.add;
1511: app_exception.raise_exception;
1512:
1513: END get_ssn_digits;

Line 1685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1681: EXCEPTION
1682: WHEN NO_DATA_FOUND THEN NULL;
1683: WHEN OTHERS THEN
1684:
1685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1686: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_COA'|| ' ' || SQLERRM);
1687: igs_ge_msg_stack.add;
1688: app_exception.raise_exception;
1689:

Line 1686: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_COA'|| ' ' || SQLERRM);

1682: WHEN NO_DATA_FOUND THEN NULL;
1683: WHEN OTHERS THEN
1684:
1685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1686: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_COA'|| ' ' || SQLERRM);
1687: igs_ge_msg_stack.add;
1688: app_exception.raise_exception;
1689:
1690: END delete_coa;

Line 1915: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1911:
1912: EXCEPTION
1913: WHEN OTHERS THEN
1914:
1915: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1916: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_ITEM_DIST'|| ' ' || SQLERRM);
1917: igs_ge_msg_stack.add;
1918: app_exception.raise_exception;
1919:

Line 1916: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_ITEM_DIST'|| ' ' || SQLERRM);

1912: EXCEPTION
1913: WHEN OTHERS THEN
1914:
1915: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1916: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_ITEM_DIST'|| ' ' || SQLERRM);
1917: igs_ge_msg_stack.add;
1918: app_exception.raise_exception;
1919:
1920: END update_item_dist;

Line 1986: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1982:
1983: IF cur_get_awd_yr%ISOPEN THEN
1984: CLOSE cur_get_awd_yr;
1985: END IF;
1986: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1987: fnd_message.set_token('NAME','IGF_GR_GEN.GET_DEF_AWD_YEAR'|| ' ' || SQLERRM);
1988: igs_ge_msg_stack.add;
1989: app_exception.raise_exception;
1990:

Line 1987: fnd_message.set_token('NAME','IGF_GR_GEN.GET_DEF_AWD_YEAR'|| ' ' || SQLERRM);

1983: IF cur_get_awd_yr%ISOPEN THEN
1984: CLOSE cur_get_awd_yr;
1985: END IF;
1986: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1987: fnd_message.set_token('NAME','IGF_GR_GEN.GET_DEF_AWD_YEAR'|| ' ' || SQLERRM);
1988: igs_ge_msg_stack.add;
1989: app_exception.raise_exception;
1990:
1991: END get_def_awd_year;

Line 2051: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2047:
2048: IF cur_overide_ld%ISOPEN THEN
2049: CLOSE cur_overide_ld;
2050: END IF;
2051: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2052: fnd_message.set_token('NAME','IGF_GR_GEN.OVRD_COA_EXIST'|| ' ' || SQLERRM);
2053: igs_ge_msg_stack.add;
2054: app_exception.raise_exception;
2055:

Line 2052: fnd_message.set_token('NAME','IGF_GR_GEN.OVRD_COA_EXIST'|| ' ' || SQLERRM);

2048: IF cur_overide_ld%ISOPEN THEN
2049: CLOSE cur_overide_ld;
2050: END IF;
2051: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2052: fnd_message.set_token('NAME','IGF_GR_GEN.OVRD_COA_EXIST'|| ' ' || SQLERRM);
2053: igs_ge_msg_stack.add;
2054: app_exception.raise_exception;
2055:
2056:

Line 2149: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2145: IF cur_tufees_code%ISOPEN THEN
2146: CLOSE cur_tufees_code;
2147: END IF;
2148:
2149: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2150: fnd_message.set_token('NAME','IGF_GR_GEN.GET_TUFEES_CODE'|| ' ' || SQLERRM);
2151: igs_ge_msg_stack.add;
2152: app_exception.raise_exception;
2153:

Line 2150: fnd_message.set_token('NAME','IGF_GR_GEN.GET_TUFEES_CODE'|| ' ' || SQLERRM);

2146: CLOSE cur_tufees_code;
2147: END IF;
2148:
2149: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2150: fnd_message.set_token('NAME','IGF_GR_GEN.GET_TUFEES_CODE'|| ' ' || SQLERRM);
2151: igs_ge_msg_stack.add;
2152: app_exception.raise_exception;
2153:
2154: END get_tufees_code;

Line 2269: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2265: IF cur_overide%ISOPEN THEN
2266: CLOSE cur_overide;
2267: END IF;
2268:
2269: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2270: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_ITEMS'|| ' ' || SQLERRM);
2271: igs_ge_msg_stack.add;
2272: app_exception.raise_exception;
2273:

Line 2270: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_ITEMS'|| ' ' || SQLERRM);

2266: CLOSE cur_overide;
2267: END IF;
2268:
2269: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2270: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_ITEMS'|| ' ' || SQLERRM);
2271: igs_ge_msg_stack.add;
2272: app_exception.raise_exception;
2273:
2274: END insert_coa_items;

Line 2337: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2333: IF cur_get_items%ISOPEN THEN
2334: CLOSE cur_get_items;
2335: END IF;
2336:
2337: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2338: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_TERMS'|| ' ' || SQLERRM);
2339: igs_ge_msg_stack.add;
2340: app_exception.raise_exception;
2341:

Line 2338: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_TERMS'|| ' ' || SQLERRM);

2334: CLOSE cur_get_items;
2335: END IF;
2336:
2337: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2338: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_COA_TERMS'|| ' ' || SQLERRM);
2339: igs_ge_msg_stack.add;
2340: app_exception.raise_exception;
2341:
2342: END insert_coa_terms;

Line 2388: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2384: IF cur_get_terms%ISOPEN THEN
2385: CLOSE cur_get_terms;
2386: END IF;
2387:
2388: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2389: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_STU_COA_TERMS'|| ' ' || SQLERRM);
2390: igs_ge_msg_stack.add;
2391: app_exception.raise_exception;
2392:

Line 2389: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_STU_COA_TERMS'|| ' ' || SQLERRM);

2385: CLOSE cur_get_terms;
2386: END IF;
2387:
2388: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2389: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_STU_COA_TERMS'|| ' ' || SQLERRM);
2390: igs_ge_msg_stack.add;
2391: app_exception.raise_exception;
2392:
2393: END insert_stu_coa_terms;

Line 2439: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2435: IF cur_get_existing_terms%ISOPEN THEN
2436: CLOSE cur_get_existing_terms;
2437: END IF;
2438:
2439: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2440: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_EXISTING_TERMS'|| ' ' || SQLERRM);
2441: igs_ge_msg_stack.add;
2442: app_exception.raise_exception;
2443:

Line 2440: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_EXISTING_TERMS'|| ' ' || SQLERRM);

2436: CLOSE cur_get_existing_terms;
2437: END IF;
2438:
2439: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2440: fnd_message.set_token('NAME','IGF_GR_GEN.INSERT_EXISTING_TERMS'|| ' ' || SQLERRM);
2441: igs_ge_msg_stack.add;
2442: app_exception.raise_exception;
2443:
2444: END insert_existing_terms;

Line 2486: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2482: IF cur_get_terms%ISOPEN THEN
2483: CLOSE cur_get_terms;
2484: END IF;
2485:
2486: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2487: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_TERMS'|| ' ' || SQLERRM);
2488: igs_ge_msg_stack.add;
2489: app_exception.raise_exception;
2490:

Line 2487: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_TERMS'|| ' ' || SQLERRM);

2483: CLOSE cur_get_terms;
2484: END IF;
2485:
2486: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2487: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_TERMS'|| ' ' || SQLERRM);
2488: igs_ge_msg_stack.add;
2489: app_exception.raise_exception;
2490:
2491: END delete_stu_coa_terms;

Line 2543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2539: IF cur_get_coa_terms%ISOPEN THEN
2540: CLOSE cur_get_coa_terms;
2541: END IF;
2542:
2543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2544: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_ITEMS'|| ' ' || SQLERRM);
2545: igs_ge_msg_stack.add;
2546: app_exception.raise_exception;
2547:

Line 2544: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_ITEMS'|| ' ' || SQLERRM);

2540: CLOSE cur_get_coa_terms;
2541: END IF;
2542:
2543: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2544: fnd_message.set_token('NAME','IGF_GR_GEN.DELETE_STU_COA_ITEMS'|| ' ' || SQLERRM);
2545: igs_ge_msg_stack.add;
2546: app_exception.raise_exception;
2547:
2548: END delete_stu_coa_items;

Line 2613: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2609: IF cur_get_terms%ISOPEN THEN
2610: CLOSE cur_get_terms;
2611: END IF;
2612:
2613: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2614: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_STU_COA_ITEMS'|| ' ' || SQLERRM);
2615: igs_ge_msg_stack.add;
2616: app_exception.raise_exception;
2617:

Line 2614: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_STU_COA_ITEMS'|| ' ' || SQLERRM);

2610: CLOSE cur_get_terms;
2611: END IF;
2612:
2613: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2614: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_STU_COA_ITEMS'|| ' ' || SQLERRM);
2615: igs_ge_msg_stack.add;
2616: app_exception.raise_exception;
2617:
2618: END update_stu_coa_items;

Line 2729: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2725:
2726: IF cur_get_base%ISOPEN THEN
2727: CLOSE cur_get_base;
2728: END IF;
2729: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2730: fnd_message.set_token('NAME','IGF_GR_GEN.GET_BASE_ID'|| ' ' || SQLERRM);
2731: igs_ge_msg_stack.add;
2732: app_exception.raise_exception;
2733:

Line 2730: fnd_message.set_token('NAME','IGF_GR_GEN.GET_BASE_ID'|| ' ' || SQLERRM);

2726: IF cur_get_base%ISOPEN THEN
2727: CLOSE cur_get_base;
2728: END IF;
2729: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2730: fnd_message.set_token('NAME','IGF_GR_GEN.GET_BASE_ID'|| ' ' || SQLERRM);
2731: igs_ge_msg_stack.add;
2732: app_exception.raise_exception;
2733:
2734: END get_base_id;

Line 2852: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');

2848: WHEN app_exception.record_lock_exception THEN
2849: IF cur_get_pell%ISOPEN THEN
2850: CLOSE cur_get_pell;
2851: END IF;
2852: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
2853: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN');
2854: igs_ge_msg_stack.add;
2855: app_exception.raise_exception;
2856:

Line 2853: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN');

2849: IF cur_get_pell%ISOPEN THEN
2850: CLOSE cur_get_pell;
2851: END IF;
2852: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
2853: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN');
2854: igs_ge_msg_stack.add;
2855: app_exception.raise_exception;
2856:
2857: WHEN OTHERS THEN

Line 2861: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2857: WHEN OTHERS THEN
2858: IF cur_get_pell%ISOPEN THEN
2859: CLOSE cur_get_pell;
2860: END IF;
2861: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2862: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN'|| ' ' || SQLERRM);
2863: igs_ge_msg_stack.add;
2864: app_exception.raise_exception;
2865:

Line 2862: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN'|| ' ' || SQLERRM);

2858: IF cur_get_pell%ISOPEN THEN
2859: CLOSE cur_get_pell;
2860: END IF;
2861: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2862: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_CURRENT_SSN'|| ' ' || SQLERRM);
2863: igs_ge_msg_stack.add;
2864: app_exception.raise_exception;
2865:
2866: END update_current_ssn;

Line 2924: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2920: WHEN OTHERS THEN
2921: IF cur_get_pell%ISOPEN THEN
2922: CLOSE cur_get_pell;
2923: END IF;
2924: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2925: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_PELL_STATUS'|| ' ' || SQLERRM);
2926: igs_ge_msg_stack.add;
2927: app_exception.raise_exception;
2928:

Line 2925: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_PELL_STATUS'|| ' ' || SQLERRM);

2921: IF cur_get_pell%ISOPEN THEN
2922: CLOSE cur_get_pell;
2923: END IF;
2924: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2925: fnd_message.set_token('NAME','IGF_GR_GEN.UPDATE_PELL_STATUS'|| ' ' || SQLERRM);
2926: igs_ge_msg_stack.add;
2927: app_exception.raise_exception;
2928:
2929: END update_pell_status;

Line 2984: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2980: EXCEPTION
2981:
2982: WHEN OTHERS THEN
2983:
2984: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2985: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_DISB_NUMBER'|| ' ' || SQLERRM);
2986: igs_ge_msg_stack.add;
2987: app_exception.raise_exception;
2988:

Line 2985: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_DISB_NUMBER'|| ' ' || SQLERRM);

2981:
2982: WHEN OTHERS THEN
2983:
2984: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2985: fnd_message.set_token('NAME','IGF_GR_GEN.GET_MIN_DISB_NUMBER'|| ' ' || SQLERRM);
2986: igs_ge_msg_stack.add;
2987: app_exception.raise_exception;
2988:
2989: END get_min_disb_number;