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

Line 196: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

192:
193:
194: -- This is an Direct Loan Change Acknowledgment File
195: fnd_message.set_name('IGF','IGF_SL_DL_CHG_ACK_FILE');
196: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
197: fnd_file.put_line(fnd_file.log,' ');
198:
199:
200: -- Check whether the File was Fully transferred.

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

193:
194: -- This is an Direct Loan Change Acknowledgment File
195: fnd_message.set_name('IGF','IGF_SL_DL_CHG_ACK_FILE');
196: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
197: fnd_file.put_line(fnd_file.log,' ');
198:
199:
200: -- Check whether the File was Fully transferred.
201: -- Get the record details in the File.

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

458: -- If the Loan# being uploaded is not a Valid Loan#
459: IF l_rec_present = 'N' THEN
460: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
461: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
462: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
463: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
464:
465: -- Update the Loan Change Response Record as NOT UPLOADED, Since it is INVALID
466: upd_dl_chg_resp(l_dbth_id, resp_rec.loan_number, 'I');

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

477: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_STATUS');
478: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
479: fnd_message.set_token('LOAN_STATUS',
480: igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_chg_status));
481: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
482:
483:
484: /************* Show Reject Details on the LOG File ***************/
485: DECLARE

Line 521: fnd_file.put_line(FND_FILE.LOG,

517:
518: FOR lrec IN cur_loan_err_resp(l_dbth_id, resp_rec.loan_number) LOOP
519:
520: -- Display on the LOG File.
521: fnd_file.put_line(FND_FILE.LOG,
522: igf_aw_gen.lookup_desc('IGF_SL_DL_CHG_REJ_CODES', lrec.loan_ident_err_code));
523:
524: -- Insert Loan Error Code details into the edit_report table.
525: igf_sl_edit.insert_edit(resp_rec.loan_number,

Line 546: fnd_file.put_line(FND_FILE.LOG, l_sub_col_heading);

542: ||RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','VALUES'),50)
543: ||' '
544: ||igf_aw_gen.lookup_desc('IGF_SL_GEN','REJ_REASON');
545: END IF;
546: fnd_file.put_line(FND_FILE.LOG, l_sub_col_heading);
547: fnd_file.put_line(FND_FILE.LOG, RPAD('-',50,'-')||' '||RPAD('-',50,'-')||' '
548: ||RPAD('-',100,'-') );
549:
550: FOR rrec IN cur_chg_rej_resp(l_dbth_id, resp_rec.loan_number) LOOP

Line 547: fnd_file.put_line(FND_FILE.LOG, RPAD('-',50,'-')||' '||RPAD('-',50,'-')||' '

543: ||' '
544: ||igf_aw_gen.lookup_desc('IGF_SL_GEN','REJ_REASON');
545: END IF;
546: fnd_file.put_line(FND_FILE.LOG, l_sub_col_heading);
547: fnd_file.put_line(FND_FILE.LOG, RPAD('-',50,'-')||' '||RPAD('-',50,'-')||' '
548: ||RPAD('-',100,'-') );
549:
550: FOR rrec IN cur_chg_rej_resp(l_dbth_id, resp_rec.loan_number) LOOP
551:

Line 553: fnd_file.put_line(FND_FILE.LOG, RPAD(rrec.fld_desc,50) ||' '

549:
550: FOR rrec IN cur_chg_rej_resp(l_dbth_id, resp_rec.loan_number) LOOP
551:
552: -- Display on the LOG File.
553: fnd_file.put_line(FND_FILE.LOG, RPAD(rrec.fld_desc,50) ||' '
554: ||RPAD(rrec.new_value,50)||' '
555: ||igf_aw_gen.lookup_desc('IGF_SL_DL_CHG_REJ_CODES',rrec.reject_code));
556:
557: -- Insert Reject details into the edit_report table.

Line 580: fnd_file.put_line(FND_FILE.LOG,'');

576:
577:
578: -- This is done to get a seperator of 2 Lines between each Loan rejected.
579: IF l_loan_chg_status <> 'A' THEN
580: fnd_file.put_line(FND_FILE.LOG,'');
581: fnd_file.put_line(FND_FILE.LOG,'');
582: END IF;
583:
584: END LOOP; -- End of igf_sl_dl_chg_resp table LOOP.

Line 581: fnd_file.put_line(FND_FILE.LOG,'');

577:
578: -- This is done to get a seperator of 2 Lines between each Loan rejected.
579: IF l_loan_chg_status <> 'A' THEN
580: fnd_file.put_line(FND_FILE.LOG,'');
581: fnd_file.put_line(FND_FILE.LOG,'');
582: END IF;
583:
584: END LOOP; -- End of igf_sl_dl_chg_resp table LOOP.
585:

Line 622: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

618:
619: WHEN NOT_PHASE_IN_PARTICIPANT THEN
620: ROLLBACK;
621: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ACK');
622: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
623: fnd_file.put_line(fnd_file.log,' ');
624:
625: WHEN OTHERS THEN
626: ROLLBACK;

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

619: WHEN NOT_PHASE_IN_PARTICIPANT THEN
620: ROLLBACK;
621: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ACK');
622: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
623: fnd_file.put_line(fnd_file.log,' ');
624:
625: WHEN OTHERS THEN
626: ROLLBACK;
627: retcode := 2;

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

723: --Message in the Log File which specifies that a Loan is Cancelled and Update Loan Status and Date
724: IF p_loan_status ='C' THEN
725: tbh_rec.loan_status:=p_loan_status;
726: tbh_rec.loan_status_date := TRUNC(SYSDATE);
727: fnd_file.put_line(fnd_file.log,' ');
728: fnd_message.set_name('IGF','IGF_SL_LOAN_CANCELLED');
729: fnd_message.set_token('LOAN_NO',tbh_rec.loan_number);
730: --Loan Number tbh_rec.loan_number has been cancelled.
731: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

727: fnd_file.put_line(fnd_file.log,' ');
728: fnd_message.set_name('IGF','IGF_SL_LOAN_CANCELLED');
729: fnd_message.set_token('LOAN_NO',tbh_rec.loan_number);
730: --Loan Number tbh_rec.loan_number has been cancelled.
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: END IF;
733:
734:
735: