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

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

159: -- else continue the process
160: IF l_cod_year_flag THEN
161:
162: fnd_message.set_name('IGF','IGF_SL_COD_NO_DISB_ORIG');
163: fnd_file.put_line(fnd_file.log,fnd_message.get);
164: RETURN;
165:
166: END IF;
167:

Line 173: fnd_file.put_line(fnd_file.log,RPAD(l_para,50,' '));

169:
170: OPEN c_get_sch_code; FETCH c_get_sch_code INTO c_get_sch_code_rec; CLOSE c_get_sch_code;
171:
172: --Show the parameters Passed
173: fnd_file.put_line(fnd_file.log,RPAD(l_para,50,' '));
174: fnd_file.put_line(fnd_file.log,RPAD(l_year,50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
175: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
176: fnd_file.put_line(fnd_file.log,' ');
177:

Line 174: fnd_file.put_line(fnd_file.log,RPAD(l_year,50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);

170: OPEN c_get_sch_code; FETCH c_get_sch_code INTO c_get_sch_code_rec; CLOSE c_get_sch_code;
171:
172: --Show the parameters Passed
173: fnd_file.put_line(fnd_file.log,RPAD(l_para,50,' '));
174: fnd_file.put_line(fnd_file.log,RPAD(l_year,50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
175: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
176: fnd_file.put_line(fnd_file.log,' ');
177:
178: -- Get the Direct Loan File Spec Version

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

171:
172: --Show the parameters Passed
173: fnd_file.put_line(fnd_file.log,RPAD(l_para,50,' '));
174: fnd_file.put_line(fnd_file.log,RPAD(l_year,50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
175: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
176: fnd_file.put_line(fnd_file.log,' ');
177:
178: -- Get the Direct Loan File Spec Version
179: BEGIN

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

172: --Show the parameters Passed
173: fnd_file.put_line(fnd_file.log,RPAD(l_para,50,' '));
174: fnd_file.put_line(fnd_file.log,RPAD(l_year,50,' ')||':'||RPAD(' ',4,' ')||l_alternate_code);
175: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
176: fnd_file.put_line(fnd_file.log,' ');
177:
178: -- Get the Direct Loan File Spec Version
179: BEGIN
180: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);

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

180: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);
181: EXCEPTION
182: WHEN NO_DATA_FOUND THEN
183: fnd_message.set_name('IGF','IGF_DB_DL_VERSION_FALSE');
184: fnd_file.put_line(fnd_file.log,fnd_message.get);
185: RAISE NO_DATA_FOUND;
186: END;
187:
188: -- Initialise the Data Record field

Line 209: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

205: IF cur_disb_dtl%NOTFOUND THEN
206: --Obseleted message IGF_NO_DL_DISB_DATA_ORIG as it does not comply standards.
207: --Added a new message.
208: fnd_message.set_name('IGF','IGF_DB_DLDISB_NOTORIG');
209: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
210: CLOSE cur_disb_dtl;
211: RAISE no_disb_data;
212: END IF;
213:

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

231: app_exception.raise_exception;
232: END IF;
233:
234: -- Write the Header Record into the Output file.
235: -- fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
236: -- The above line(code) commented here and is being used in the trans_rec procedure
237: -- as the header record is created if there exists a valid transaction
238: -- record to process
239:

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

260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: END IF;
263: -- Write the Trailer Record into the Output file
264: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
265:
266: --Display message that DL Disb Records are originated.See output File.
267: fnd_file.put_line(fnd_file.log,' ');
268: fnd_message.set_name('IGF','IGF_DB_DL_DISB_ORIG');

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

263: -- Write the Trailer Record into the Output file
264: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
265:
266: --Display message that DL Disb Records are originated.See output File.
267: fnd_file.put_line(fnd_file.log,' ');
268: fnd_message.set_name('IGF','IGF_DB_DL_DISB_ORIG');
269: fnd_file.put_line(fnd_file.log,fnd_message.get);
270: ELSE
271: FND_MESSAGE.SET_NAME('IGF','IGF_AP_TOTAL_RECS');

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

265:
266: --Display message that DL Disb Records are originated.See output File.
267: fnd_file.put_line(fnd_file.log,' ');
268: fnd_message.set_name('IGF','IGF_DB_DL_DISB_ORIG');
269: fnd_file.put_line(fnd_file.log,fnd_message.get);
270: ELSE
271: FND_MESSAGE.SET_NAME('IGF','IGF_AP_TOTAL_RECS');
272: FND_MESSAGE.SET_TOKEN('COUNT', p_Rec_count);
273: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

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

269: fnd_file.put_line(fnd_file.log,fnd_message.get);
270: ELSE
271: FND_MESSAGE.SET_NAME('IGF','IGF_AP_TOTAL_RECS');
272: FND_MESSAGE.SET_TOKEN('COUNT', p_Rec_count);
273: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
274: END IF;
275: COMMIT;
276:
277: EXCEPTION

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

289: WHEN OTHERS THEN
290: ROLLBACK;
291: retcode := 2;
292: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
293: fnd_file.put_line(fnd_file.log,SQLERRM);
294: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
295: END disb_originate;
296:
297: PROCEDURE trans_rec( p_dl_version igf_lookups_view.lookup_code%TYPE,

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

408: FETCH cur_school INTO l_orig_fee_perct_stafford, l_orig_fee_perct_plus;
409: IF cur_school%NOTFOUND THEN
410: CLOSE cur_school;
411: fnd_message.set_name ('IGF', 'IGF_SL_NO_DL_SETUP');
412: fnd_file.put_line(fnd_file.log,fnd_message.get);
413: RAISE NO_DATA_FOUND;
414: END IF;
415: CLOSE cur_school;
416:

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

548:
549: l_Rec_count := l_Rec_count + 1; -- ## Increment the Record Count
550: -- ## Write the header to file only first time
551: IF (l_Rec_count = 1) THEN
552: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
553: END IF;
554: fnd_file.put_line(FND_FILE.OUTPUT, l_Trans_Rec); -- ## Write the Transaction Record to file
555:
556: -- ## Update the igf_aw_db_chg_dtls table with the disb_status as sent

Line 554: fnd_file.put_line(FND_FILE.OUTPUT, l_Trans_Rec); -- ## Write the Transaction Record to file

550: -- ## Write the header to file only first time
551: IF (l_Rec_count = 1) THEN
552: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
553: END IF;
554: fnd_file.put_line(FND_FILE.OUTPUT, l_Trans_Rec); -- ## Write the Transaction Record to file
555:
556: -- ## Update the igf_aw_db_chg_dtls table with the disb_status as sent
557: -- ## , disb_status_date as sysdate and disb_batch_id as current batch id
558: -- ## for each award ID,disbnum and disb_seq_num.

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

620: CLOSE cur_school;
621: END IF;
622: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
623: fnd_message.set_token('NAME','IGF_DB_DL_DISB_ORIG.TRANS_REC');
624: fnd_file.put_line(fnd_file.log,SQLERRM);
625: igs_ge_msg_stack.add;
626: app_exception.raise_exception;
627: END trans_rec;
628: END igf_db_dl_disb_orig;