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

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

269: -- Check whether the award year is full participant
270: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
271: -- Log an error message
272: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);
274: raise yr_full_participant;
275: END IF;
276:
277:

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

281: IF cur_alternate_code%NOTFOUND THEN
282: CLOSE cur_alternate_code;
283: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
284: IGS_GE_MSG_STACK.ADD;
285: fnd_file.put_line(fnd_file.log,fnd_message.get);
286:
287: app_exception.raise_exception;
288: END IF;
289: CLOSE cur_alternate_code;

Line 305: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));

301:
302: OPEN c_get_sch_code; FETCH c_get_sch_code INTO c_get_sch_code_rec; CLOSE c_get_sch_code;
303:
304: --Show the parameters passed
305: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
306: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
307: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
308: IF (p_loan_number IS NOT NULL) THEN
309: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);

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

302: OPEN c_get_sch_code; FETCH c_get_sch_code INTO c_get_sch_code_rec; CLOSE c_get_sch_code;
303:
304: --Show the parameters passed
305: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
306: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
307: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
308: IF (p_loan_number IS NOT NULL) THEN
309: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
310: END IF;

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

303:
304: --Show the parameters passed
305: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
306: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
307: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
308: IF (p_loan_number IS NOT NULL) THEN
309: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
310: END IF;
311: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);

Line 309: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);

305: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
306: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
307: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
308: IF (p_loan_number IS NOT NULL) THEN
309: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
310: END IF;
311: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
312:
313: -- Get the Direct Loan File Spec Version

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

307: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),50,' ')||':'||RPAD(' ',4,' ')||l_para_rec(1));
308: IF (p_loan_number IS NOT NULL) THEN
309: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),50,' ')||':'||RPAD(' ',4,' ')||p_loan_number);
310: END IF;
311: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
312:
313: -- Get the Direct Loan File Spec Version
314: --Bug :-2490289 DL Header and Trailer Formatting Error.
315: --Handled the NO_DATA_FOUND exception if the DL Setup record

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

321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN
323:
324: fnd_message.set_name('IGF','IGF_DB_DL_VERSION_FALSE');
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326:
327: RAISE NO_DATA_FOUND;
328: END;
329:

Line 426: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_header_record);

422: lv_num_of_rec := lv_num_of_rec + 1;
423: IF(lv_num_of_rec = 1)THEN
424: -- Write the Header Record into the Output file only there is atleast one record to process
425: -- write header only once.
426: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_header_record);
427: END IF;
428:
429: -- Write the Transaction Record into the Output File.
430: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);

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

426: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_header_record);
427: END IF;
428:
429: -- Write the Transaction Record into the Output File.
430: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
431:
432:
433:
434: -- Delete this loan record in IGF_SL_LOR_LOC

Line 901: fnd_file.new_line(fnd_file.log,2);

897: END;
898:
899: IF l_display <> 'Y' THEN
900: --Display mesg in LOG File that Records have been originated and an Output file has been created.
901: fnd_file.new_line(fnd_file.log,2);
902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');
903: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
904: fnd_message.set_token('FILE_VERSION',lv_dl_version);
905: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

901: fnd_file.new_line(fnd_file.log,2);
902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');
903: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
904: fnd_message.set_token('FILE_VERSION',lv_dl_version);
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: fnd_file.new_line(fnd_file.log,2);
907: l_display :='Y';
908: END IF;
909:

Line 906: fnd_file.new_line(fnd_file.log,2);

902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');
903: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
904: fnd_message.set_token('FILE_VERSION',lv_dl_version);
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: fnd_file.new_line(fnd_file.log,2);
907: l_display :='Y';
908: END IF;
909:
910:

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

1099: igs_ge_msg_stack.add;
1100: app_exception.raise_exception;
1101: END IF;
1102: -- Write the Trailer Record into the Output file.
1103: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
1104: ELSE
1105: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
1106: --MN 27-Dec-2004 In case there are no records getting generated, the V state will be reverted back.
1107: ROLLBACK;

Line 1105: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));

1101: END IF;
1102: -- Write the Trailer Record into the Output file.
1103: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
1104: ELSE
1105: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
1106: --MN 27-Dec-2004 In case there are no records getting generated, the V state will be reverted back.
1107: ROLLBACK;
1108: END IF;
1109:

Line 1123: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));

1119: -- of exiting a process if there is not Data.
1120: COMMIT; -- Commit is done here, so that the "Validation reject details" get committed.
1121: retcode := 0;
1122: errbuf := NULL;
1123: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
1124:
1125: WHEN yr_full_participant THEN
1126: NULL;
1127:

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

1144: CLOSE c_loans;
1145: END IF;
1146: retcode := 2;
1147: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1148: fnd_file.put_line(fnd_file.log,SQLERRM);
1149: igs_ge_msg_stack.conc_exception_hndl;
1150: END dl_originate;
1151:
1152: