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_DB_CL_ROSTER dependencies on FND_MESSAGE

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

296: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','cl_load_data Header fetch');
297: END IF;
298: IF c_header%NOTFOUND THEN
299: CLOSE c_header;
300: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
301: -- File uploaded is incomplete.
302: igs_ge_msg_stack.add;
303: RAISE FILE_NOT_LOADED;
304: END IF;

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

318:
319: IF g_cl_file_type = 'CL_DISB_ROSTER' THEN
320: NULL;
321: ELSE
322: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
323: igs_ge_msg_stack.add;
324: RAISE FILE_NOT_LOADED;
325: END IF;
326:

Line 329: fnd_message.set_name('IGF','IGF_DB_CL_ROSTER_FILE');

325: END IF;
326:
327: -- File is a valid Disbursement Roster File. It should be processed.
328:
329: fnd_message.set_name('IGF','IGF_DB_CL_ROSTER_FILE');
330: fnd_file.put_line(fnd_file.log,fnd_message.get);
331:
332: --Check whether file has been transmitted completely or not
333:

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

326:
327: -- File is a valid Disbursement Roster File. It should be processed.
328:
329: fnd_message.set_name('IGF','IGF_DB_CL_ROSTER_FILE');
330: fnd_file.put_line(fnd_file.log,fnd_message.get);
331:
332: --Check whether file has been transmitted completely or not
333:
334: OPEN c_trailer;

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

337: l_tot_reissue_amt, l_tot_cancel_amt, l_tot_deficit_amt,
338: l_tot_net_cancel_amt, l_tot_net_out_cancel_amt;
339: IF c_trailer%NOTFOUND THEN
340: CLOSE c_trailer;
341: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
342: -- File uploaded is incomplete.
343: igs_ge_msg_stack.add;
344: RAISE FILE_NOT_LOADED;
345: END IF;

Line 886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');

882:
883: EXCEPTION
884: WHEN OTHERS THEN
885: ROLLBACK TO IGFDB04B_SP1_1;
886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');
887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);
888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
889: fnd_file.put_line(fnd_file.log, fnd_message.get);
890: fnd_file.new_line(fnd_file.log, 1);

Line 887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);

883: EXCEPTION
884: WHEN OTHERS THEN
885: ROLLBACK TO IGFDB04B_SP1_1;
886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');
887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);
888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
889: fnd_file.put_line(fnd_file.log, fnd_message.get);
890: fnd_file.new_line(fnd_file.log, 1);
891: END;

Line 888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

884: WHEN OTHERS THEN
885: ROLLBACK TO IGFDB04B_SP1_1;
886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');
887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);
888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
889: fnd_file.put_line(fnd_file.log, fnd_message.get);
890: fnd_file.new_line(fnd_file.log, 1);
891: END;
892:

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

885: ROLLBACK TO IGFDB04B_SP1_1;
886: fnd_message.set_name('IGF','IGF_SL_DB_ERROR_UPLOAD');
887: fnd_file.put_line(fnd_file.log, fnd_message.get||' '||SQLERRM);
888: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
889: fnd_file.put_line(fnd_file.log, fnd_message.get);
890: fnd_file.new_line(fnd_file.log, 1);
891: END;
892:
893: END LOOP;

Line 895: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');

891: END;
892:
893: END LOOP;
894: IF l_actual_rec <> l_number_rec THEN
895: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
896: igs_ge_msg_stack.add;
897: RAISE FILE_NOT_LOADED;
898: END IF;
899: p_cbth_id := l_cbth_id;

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

903: RAISE;
904: WHEN CLSETUP_NOT_FOUND THEN
905: RAISE;
906: WHEN OTHERS THEN
907: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
908: fnd_message.set_token('NAME','IGF_DB_CL_ROSTER.CL_LOAD_DATA');
909: fnd_file.put_line(fnd_file.log,SQLERRM);
910: igs_ge_msg_stack.add;
911: app_exception.raise_exception;

Line 908: fnd_message.set_token('NAME','IGF_DB_CL_ROSTER.CL_LOAD_DATA');

904: WHEN CLSETUP_NOT_FOUND THEN
905: RAISE;
906: WHEN OTHERS THEN
907: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
908: fnd_message.set_token('NAME','IGF_DB_CL_ROSTER.CL_LOAD_DATA');
909: fnd_file.put_line(fnd_file.log,SQLERRM);
910: igs_ge_msg_stack.add;
911: app_exception.raise_exception;
912:

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

1115: OPEN cur_awdisb(l_loan_number,l_disb_num);
1116: FETCH cur_awdisb INTO disb_rec;
1117: IF cur_awdisb%NOTFOUND THEN
1118: CLOSE cur_awdisb;
1119: fnd_message.set_name('IGF','IGF_SL_NO_AWD_DISB');
1120: -- No Records in Award-Disbursement Table.
1121: fnd_file.new_line(fnd_file.log,1);
1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: fnd_file.new_line(fnd_file.log,1);

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

1118: CLOSE cur_awdisb;
1119: fnd_message.set_name('IGF','IGF_SL_NO_AWD_DISB');
1120: -- No Records in Award-Disbursement Table.
1121: fnd_file.new_line(fnd_file.log,1);
1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: fnd_file.new_line(fnd_file.log,1);
1124: lv_rec_status := 'F';
1125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1126: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','skip flag TRUE ');

Line 1139: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');

1135: OPEN c_clset(disb_rec.award_id);
1136: FETCH c_clset INTO l_auto_late_ind;
1137: IF c_clset%NOTFOUND THEN
1138: CLOSE c_clset;
1139: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
1140: fnd_file.put_line(fnd_file.log,fnd_message.get);
1141: -- No Records in CommonLine Setup Table.
1142: igs_ge_msg_stack.add;
1143: RAISE CLSETUP_NOT_FOUND;

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

1136: FETCH c_clset INTO l_auto_late_ind;
1137: IF c_clset%NOTFOUND THEN
1138: CLOSE c_clset;
1139: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
1140: fnd_file.put_line(fnd_file.log,fnd_message.get);
1141: -- No Records in CommonLine Setup Table.
1142: igs_ge_msg_stack.add;
1143: RAISE CLSETUP_NOT_FOUND;
1144: END IF;

Line 1166: fnd_message.set_name('IGF','IGF_DB_ROST_ALFND_NOUPD');

1162: IF l_fund_status = 'Y' THEN
1163: -- If the fund status is already funded then skip this record
1164: -- No updates for igf_aw_awd_disb table
1165: IF l_rec_type = 'N' THEN
1166: fnd_message.set_name('IGF','IGF_DB_ROST_ALFND_NOUPD');
1167: fnd_file.put_line(fnd_file.log,fnd_message.get);
1168: fnd_file.new_line(fnd_file.log,1);
1169: RAISE SKIP_THIS_RECORD;
1170: ELSE

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

1163: -- If the fund status is already funded then skip this record
1164: -- No updates for igf_aw_awd_disb table
1165: IF l_rec_type = 'N' THEN
1166: fnd_message.set_name('IGF','IGF_DB_ROST_ALFND_NOUPD');
1167: fnd_file.put_line(fnd_file.log,fnd_message.get);
1168: fnd_file.new_line(fnd_file.log,1);
1169: RAISE SKIP_THIS_RECORD;
1170: ELSE
1171: lv_rec_status := 'A';

Line 1172: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');

1168: fnd_file.new_line(fnd_file.log,1);
1169: RAISE SKIP_THIS_RECORD;
1170: ELSE
1171: lv_rec_status := 'A';
1172: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1173: fnd_file.put_line(fnd_file.log,fnd_message.get);
1174: fnd_file.new_line(fnd_file.log,1);
1175: END IF;
1176: END IF;

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

1169: RAISE SKIP_THIS_RECORD;
1170: ELSE
1171: lv_rec_status := 'A';
1172: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1173: fnd_file.put_line(fnd_file.log,fnd_message.get);
1174: fnd_file.new_line(fnd_file.log,1);
1175: END IF;
1176: END IF;
1177:

Line 1211: fnd_message.set_name('IGF','IGF_DB_INFO_DIFFER');

1207: LPAD(fee_paid_2_desc,30) || LPAD(NVL(TO_CHAR(l_fee_paid_2),' '),30) ||LPAD(NVL(TO_CHAR(l_awd_fee_paid_2),' '),30) ||'
1208: '||
1209: LPAD(direct_to_borr_ind_desc,30) || LPAD(NVL(l_direct_to_borr_ind,' '),30) ||LPAD(NVL(l_awd_direct_to_borr_ind,' '),30);
1210:
1211: fnd_message.set_name('IGF','IGF_DB_INFO_DIFFER');
1212: --Amounts are different in file and table for this record
1213: fnd_file.put_line(fnd_file.log,fnd_message.get);
1214: fnd_file.put_line(fnd_file.log,l_msg_str2);
1215: fnd_file.new_line(fnd_file.log,1);

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

1209: LPAD(direct_to_borr_ind_desc,30) || LPAD(NVL(l_direct_to_borr_ind,' '),30) ||LPAD(NVL(l_awd_direct_to_borr_ind,' '),30);
1210:
1211: fnd_message.set_name('IGF','IGF_DB_INFO_DIFFER');
1212: --Amounts are different in file and table for this record
1213: fnd_file.put_line(fnd_file.log,fnd_message.get);
1214: fnd_file.put_line(fnd_file.log,l_msg_str2);
1215: fnd_file.new_line(fnd_file.log,1);
1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';

Line 1218: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_NOUPD');

1214: fnd_file.put_line(fnd_file.log,l_msg_str2);
1215: fnd_file.new_line(fnd_file.log,1);
1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';
1218: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_NOUPD');
1219: fnd_file.put_line(fnd_file.log,fnd_message.get);
1220: fnd_file.new_line(fnd_file.log,1);
1221: RAISE SKIP_THIS_RECORD;
1222: ELSIF p_update_disb = 'Y' THEN

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

1215: fnd_file.new_line(fnd_file.log,1);
1216: IF p_update_disb = 'N' THEN
1217: lv_rec_status := 'D';
1218: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_NOUPD');
1219: fnd_file.put_line(fnd_file.log,fnd_message.get);
1220: fnd_file.new_line(fnd_file.log,1);
1221: RAISE SKIP_THIS_RECORD;
1222: ELSIF p_update_disb = 'Y' THEN
1223: lv_rec_status := 'U';

Line 1224: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_YSUPD');

1220: fnd_file.new_line(fnd_file.log,1);
1221: RAISE SKIP_THIS_RECORD;
1222: ELSIF p_update_disb = 'Y' THEN
1223: lv_rec_status := 'U';
1224: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_YSUPD');
1225: fnd_file.put_line(fnd_file.log,fnd_message.get);
1226: fnd_file.new_line(fnd_file.log,1);
1227: disb_rec.fee_1 := l_fee_1;
1228: disb_rec.fee_2 := l_fee_2;

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

1221: RAISE SKIP_THIS_RECORD;
1222: ELSIF p_update_disb = 'Y' THEN
1223: lv_rec_status := 'U';
1224: fnd_message.set_name('IGF','IGF_DB_ROST_DIFF_YSUPD');
1225: fnd_file.put_line(fnd_file.log,fnd_message.get);
1226: fnd_file.new_line(fnd_file.log,1);
1227: disb_rec.fee_1 := l_fee_1;
1228: disb_rec.fee_2 := l_fee_2;
1229: disb_rec.disb_net_amt := l_net_disb_amt;

Line 1260: fnd_message.set_name('IGF','IGF_SL_LATE_DISB');

1256: LPAD(fee_paid_2_desc,30) ||LPAD(NVL(TO_CHAR(l_fee_paid_2),' '),30) ||'
1257: '||
1258: LPAD(direct_to_borr_ind_desc,30) ||LPAD(NVL(l_direct_to_borr_ind,' '),30);
1259:
1260: fnd_message.set_name('IGF','IGF_SL_LATE_DISB');
1261: -- Late disbursement set for this record.
1262: fnd_file.put_line(fnd_file.log,fnd_message.get);
1263: fnd_file.put_line(fnd_file.log,l_msg_str1);
1264: lv_rec_status := 'L';

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

1258: LPAD(direct_to_borr_ind_desc,30) ||LPAD(NVL(l_direct_to_borr_ind,' '),30);
1259:
1260: fnd_message.set_name('IGF','IGF_SL_LATE_DISB');
1261: -- Late disbursement set for this record.
1262: fnd_file.put_line(fnd_file.log,fnd_message.get);
1263: fnd_file.put_line(fnd_file.log,l_msg_str1);
1264: lv_rec_status := 'L';
1265: RAISE SKIP_THIS_RECORD;
1266: END IF;

Line 1273: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');

1269: -- 2.b.Update igf_aw_awd_disb
1270: -- set the fund status = FUNDED
1271: IF lv_rec_status = 'N' THEN
1272: lv_rec_status := 'U';
1273: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1274: fnd_file.put_line(fnd_file.log,fnd_message.get);
1275: fnd_file.new_line(fnd_file.log,1);
1276: END IF;
1277:

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

1270: -- set the fund status = FUNDED
1271: IF lv_rec_status = 'N' THEN
1272: lv_rec_status := 'U';
1273: fnd_message.set_name('IGF','IGF_DB_UPD_ROST_FUND');
1274: fnd_file.put_line(fnd_file.log,fnd_message.get);
1275: fnd_file.new_line(fnd_file.log,1);
1276: END IF;
1277:
1278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1427: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

1423:
1424: WHEN app_exception.record_lock_exception THEN
1425: ROLLBACK;
1426: retcode := 2;
1427: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
1428: igs_ge_msg_stack.conc_exception_hndl;
1429:
1430: WHEN CLSETUP_NOT_FOUND THEN
1431: ROLLBACK;

Line 1433: errbuf := fnd_message.get_string('IGF','IGF_SL_NO_CL_SETUP');

1429:
1430: WHEN CLSETUP_NOT_FOUND THEN
1431: ROLLBACK;
1432: retcode := 2;
1433: errbuf := fnd_message.get_string('IGF','IGF_SL_NO_CL_SETUP');
1434: igs_ge_msg_stack.conc_exception_hndl;
1435:
1436: WHEN FILE_NOT_LOADED THEN
1437: ROLLBACK;

Line 1439: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');

1435:
1436: WHEN FILE_NOT_LOADED THEN
1437: ROLLBACK;
1438: retcode := 2;
1439: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
1440: igs_ge_msg_stack.conc_exception_hndl;
1441:
1442: WHEN OTHERS THEN
1443: ROLLBACK;

Line 1445: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1441:
1442: WHEN OTHERS THEN
1443: ROLLBACK;
1444: retcode := 2;
1445: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1446: fnd_file.put_line(fnd_file.log,SQLERRM);
1447: igs_ge_msg_stack.conc_exception_hndl;
1448:
1449: END roster_ack;