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_SL_DL_CHG_ORIG dependencies on FND_FILE

Line 367: fnd_file.put_line(fnd_file.log,SQLERRM);

363: CLOSE c_chg_code;
364: END IF;
365: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
366: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.COMP_LOR_LOC');
367: fnd_file.put_line(fnd_file.log,SQLERRM);
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END comp_lor_loc;
371:

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

384: IF cur_alternate_code%NOTFOUND THEN
385: CLOSE cur_alternate_code;
386: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
387: IGS_GE_MSG_STACK.ADD;
388: fnd_file.put_line(fnd_file.log,fnd_message.get);
389:
390: app_exception.raise_exception;
391: END IF;
392: CLOSE cur_alternate_code;

Line 409: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' '));

405: OPEN c_get_sch_code; FETCH c_get_sch_code INTO c_get_sch_code_rec; CLOSE c_get_sch_code;
406:
407: --Show the parameters passed
408: --Bug No:2332668
409: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' '));
410: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
411: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
412: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
413:

Line 410: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);

406:
407: --Show the parameters passed
408: --Bug No:2332668
409: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' '));
410: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
411: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
412: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
413:
414: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN

Line 411: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));

407: --Show the parameters passed
408: --Bug No:2332668
409: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' '));
410: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
411: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
412: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
413:
414: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
415: -- Log an error message

Line 412: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);

408: --Bug No:2332668
409: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' '));
410: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
411: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
412: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
413:
414: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
415: -- Log an error message
416: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ORIG');

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

413:
414: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
415: -- Log an error message
416: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ORIG');
417: fnd_file.put_line(fnd_file.log,fnd_message.get);
418: raise yr_full_participant;
419: END IF;
420:
421: --Get the Direct Loan File Spec Version Bug :-2490289 DL Header and Trailer Formatting Error.

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

424: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN
427: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
428: fnd_file.put_line(fnd_file.log,fnd_message.get);
429: RAISE NO_DATA_FOUND;
430: END;
431:
432: -- Initialise the Data Record field

Line 497: fnd_file.put_line(fnd_file.log,' ');

493: IF c_lor_loc%NOTFOUND THEN
494: CLOSE c_lor_loc;
495: fnd_message.set_name('IGF','IGF_SL_NO_LOR_LOC_REC');
496: fnd_message.set_token('LOAN_NUMBER',lc_lor.loan_number);
497: fnd_file.put_line(fnd_file.log,' ');
498: fnd_file.put_line(fnd_file.log,fnd_message.get);
499:
500: RAISE SKIP_LOAN;
501: END IF;

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

494: CLOSE c_lor_loc;
495: fnd_message.set_name('IGF','IGF_SL_NO_LOR_LOC_REC');
496: fnd_message.set_token('LOAN_NUMBER',lc_lor.loan_number);
497: fnd_file.put_line(fnd_file.log,' ');
498: fnd_file.put_line(fnd_file.log,fnd_message.get);
499:
500: RAISE SKIP_LOAN;
501: END IF;
502:

Line 512: fnd_file.put_line(fnd_file.log,' ');

508: IF cur_isir_depend_status%NOTFOUND THEN
509: CLOSE cur_isir_depend_status;
510: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
511: fnd_message.set_token('P_RECORD',' Payment ISIR');
512: fnd_file.put_line(fnd_file.log,' ');
513: fnd_file.put_line(fnd_file.log,fnd_message.get);
514: RAISE SKIP_LOAN;
515: END IF;
516:

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

509: CLOSE cur_isir_depend_status;
510: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
511: fnd_message.set_token('P_RECORD',' Payment ISIR');
512: fnd_file.put_line(fnd_file.log,' ');
513: fnd_file.put_line(fnd_file.log,fnd_message.get);
514: RAISE SKIP_LOAN;
515: END IF;
516:
517: --Code added for bug 3603289 start

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

992: --Display mesg in LOG File that Change Records have been originated and an Output file has been created.
993: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_ORIG');
994: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
995: fnd_message.set_token('FILE_VERSION',lv_dl_version);
996: fnd_file.put_line(fnd_file.log,fnd_message.get);
997: l_display :='Y';
998: END IF;
999:
1000:

Line 1021: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);

1017:
1018: IF lc_header_flag= 'Y' THEN
1019:
1020: -- Write the Header Record into the Output file.
1021: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
1022:
1023: --Formulating the Transaction Record
1024:
1025: BEGIN

Line 1047: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);

1043: app_exception.raise_exception;
1044: END IF;
1045:
1046: -- Write the Trailer Record into the Output file.
1047: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
1048:
1049: ELSE
1050: -- We need to do a rollback as we would have inserted into IGF_SL_DL_BATCH
1051: -- table while calling igf_sl_dl_record.DLHeader_cur.

Line 1058: fnd_file.put_line(fnd_file.log,' ');

1054:
1055: --Display a message if No Loan Change Origination
1056: --Bug No:2332668
1057: IF l_display='N' THEN
1058: fnd_file.put_line(fnd_file.log,' ');
1059: fnd_file.put_line(fnd_file.log,' ');
1060: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_CHG_ORIG');
1061: fnd_file.put_line(fnd_file.log,fnd_message.get);
1062:

Line 1059: fnd_file.put_line(fnd_file.log,' ');

1055: --Display a message if No Loan Change Origination
1056: --Bug No:2332668
1057: IF l_display='N' THEN
1058: fnd_file.put_line(fnd_file.log,' ');
1059: fnd_file.put_line(fnd_file.log,' ');
1060: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_CHG_ORIG');
1061: fnd_file.put_line(fnd_file.log,fnd_message.get);
1062:
1063: END IF;

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

1057: IF l_display='N' THEN
1058: fnd_file.put_line(fnd_file.log,' ');
1059: fnd_file.put_line(fnd_file.log,' ');
1060: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_CHG_ORIG');
1061: fnd_file.put_line(fnd_file.log,fnd_message.get);
1062:
1063: END IF;
1064:
1065:

Line 1090: fnd_file.put_line(fnd_file.log,SQLERRM);

1086: CLOSE cur_disb_loc;
1087: END IF;
1088: retcode := 2;
1089: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1090: fnd_file.put_line(fnd_file.log,SQLERRM);
1091: igs_ge_msg_stack.conc_exception_hndl;
1092: END chg_originate;
1093:
1094:

Line 1158: fnd_file.put_line(FND_FILE.OUTPUT, RPAD(l_Trans_Rec, l_chg_rec_len)||RPAD(p_dl_batch_id,'25'));

1154: LOOP
1155: FETCH cur_chg_rec INTO lcur_chg_rec;
1156: IF cur_chg_rec%NOTFOUND THEN
1157: IF l_trans_rec IS NOT NULL THEN
1158: fnd_file.put_line(FND_FILE.OUTPUT, RPAD(l_Trans_Rec, l_chg_rec_len)||RPAD(p_dl_batch_id,'25'));
1159: l_tot_rec_count := l_tot_rec_count + 1;
1160: END IF;
1161: EXIT;
1162: END IF;

Line 1168: fnd_file.put_line(FND_FILE.OUTPUT, RPAD(l_Trans_Rec, l_chg_rec_len)||RPAD(p_dl_batch_id,'25'));

1164: IF l_prev_loan_number <> lcur_chg_rec.loan_number THEN
1165: l_prev_loan_number := lcur_chg_rec.loan_number;
1166: l_line_rec_count := 0;
1167: IF l_trans_rec IS NOT NULL THEN
1168: fnd_file.put_line(FND_FILE.OUTPUT, RPAD(l_Trans_Rec, l_chg_rec_len)||RPAD(p_dl_batch_id,'25'));
1169: l_tot_rec_count := l_tot_rec_count + 1;
1170: l_trans_rec := RPAD(lcur_chg_rec.loan_number,21)||' ';
1171: ELSE
1172: l_trans_rec := RPAD(lcur_chg_rec.loan_number,21)||' ';

Line 1178: fnd_file.put_line(FND_FILE.OUTPUT, RPAD(l_Trans_Rec, l_chg_rec_len)||RPAD(p_dl_batch_id,'25'));

1174:
1175: ELSE -- If Loan-Number is Same
1176: IF l_line_rec_count = 10 THEN
1177: l_line_rec_count := 0;
1178: fnd_file.put_line(FND_FILE.OUTPUT, RPAD(l_Trans_Rec, l_chg_rec_len)||RPAD(p_dl_batch_id,'25'));
1179: l_tot_rec_count := l_tot_rec_count + 1;
1180: l_trans_rec := RPAD(lcur_chg_rec.loan_number,21)||' ';
1181: END IF;
1182: END IF;

Line 1202: fnd_file.put_line(fnd_file.log,SQLERRM);

1198: CLOSE cur_chg_rec;
1199: END IF;
1200: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1201: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.TRANS_REC');
1202: fnd_file.put_line(fnd_file.log,SQLERRM);
1203: igs_ge_msg_stack.add;
1204: app_exception.raise_exception;
1205: END Trans_Rec;
1206: