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

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

150:
151: IF l_dl_file_type ='DL_DISB_ACK' THEN
152: -- This is an Direct Loan Disbursment Acknowledgment File
153: fnd_message.set_name('IGF','IGF_DB_DL_ACK_FILE');
154: fnd_file.put_line(fnd_file.log,fnd_message.get);
155: ELSIF l_dl_file_type='DL_DISB_BOOK' THEN
156: fnd_message.set_name('IGF','IGF_DB_DL_BOOK_FILE');
157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158:

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

153: fnd_message.set_name('IGF','IGF_DB_DL_ACK_FILE');
154: fnd_file.put_line(fnd_file.log,fnd_message.get);
155: ELSIF l_dl_file_type='DL_DISB_BOOK' THEN
156: fnd_message.set_name('IGF','IGF_DB_DL_BOOK_FILE');
157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158:
159: END IF;
160:
161:

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

282: RAISE;
283: WHEN OTHERS THEN
284: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
285: fnd_message.set_token('NAME','IGF_DB_DL_ORIG_ACK.DISB_LOAD_DATA');
286: fnd_file.put_line(fnd_file.log,SQLERRM);
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: END disb_load_data;
290:

Line 404: fnd_file.put_line(fnd_file.log,RPAD(l_loan_number_desc ,50)||' : '||p_loan_number);

400: BEGIN
401:
402: IF l_log_start_flag = FALSE THEN
403:
404: fnd_file.put_line(fnd_file.log,RPAD(l_loan_number_desc ,50)||' : '||p_loan_number);
405: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(p_disb_num) );
406: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc,50)||' : '||TO_CHAR(p_disb_seq_num));
407:
408: l_log_start_flag := TRUE;

Line 405: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(p_disb_num) );

401:
402: IF l_log_start_flag = FALSE THEN
403:
404: fnd_file.put_line(fnd_file.log,RPAD(l_loan_number_desc ,50)||' : '||p_loan_number);
405: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(p_disb_num) );
406: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc,50)||' : '||TO_CHAR(p_disb_seq_num));
407:
408: l_log_start_flag := TRUE;
409: END IF;

Line 406: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc,50)||' : '||TO_CHAR(p_disb_seq_num));

402: IF l_log_start_flag = FALSE THEN
403:
404: fnd_file.put_line(fnd_file.log,RPAD(l_loan_number_desc ,50)||' : '||p_loan_number);
405: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(p_disb_num) );
406: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc,50)||' : '||TO_CHAR(p_disb_seq_num));
407:
408: l_log_start_flag := TRUE;
409: END IF;
410:

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

482: fnd_message.set_name('IGF','IGF_DB_NO_AWARD_DTL');
483: fnd_message.set_token('AWARD',lcur_db_resp.loan_number);
484: fnd_message.set_token('DNUM',lcur_db_resp.disb_num);
485: fnd_message.set_token('DSEQNUM',lcur_db_resp.disb_seq_num);
486: fnd_file.put_line(fnd_file.log,fnd_message.get);
487: RAISE SKIP_THIS_RECORD;
488:
489: END IF;
490:

Line 504: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

500: IF lcur_db_resp.disb_activity_status IS NOT NULL THEN
501:
502: log_start(lcur_db_resp.loan_number, lcur_db_resp.disb_num, lcur_db_resp.disb_seq_num);
503:
504: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
505: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,1,2)))
506: )
507: );
508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

Line 508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

504: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
505: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,1,2)))
506: )
507: );
508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
509: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,3,2)))
510: )
511: );
512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

Line 512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

508: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
509: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,3,2)))
510: )
511: );
512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
513: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,5,2)))
514: )
515: );
516: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

Line 516: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',

512: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
513: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,5,2)))
514: )
515: );
516: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_DB_DL_REJ_CODES',
517: LTRIM(RTRIM(SUBSTR(lcur_db_resp.disb_activity_status,7,2)))
518: )
519: );
520: END IF;

Line 569: fnd_file.new_line(fnd_file.log,1);

565: l_mesg_str1 := l_mesg_str1 || LPAD(l_disb_net_amt_desc,50);
566: l_mesg_str2 := l_mesg_str2 || LPAD(NVL(lcur_db_resp.loc_disb_net_amt,''),50);
567: l_mesg_str3 := l_mesg_str3 || LPAD(lcur_awdisb.disb_net_amt,50);
568:
569: fnd_file.new_line(fnd_file.log,1);
570: fnd_file.put_line(fnd_file.log,l_mesg_str1);
571: fnd_file.put_line(fnd_file.log,l_mesg_str2);
572: fnd_file.put_line(fnd_file.log,l_mesg_str3);
573:

Line 570: fnd_file.put_line(fnd_file.log,l_mesg_str1);

566: l_mesg_str2 := l_mesg_str2 || LPAD(NVL(lcur_db_resp.loc_disb_net_amt,''),50);
567: l_mesg_str3 := l_mesg_str3 || LPAD(lcur_awdisb.disb_net_amt,50);
568:
569: fnd_file.new_line(fnd_file.log,1);
570: fnd_file.put_line(fnd_file.log,l_mesg_str1);
571: fnd_file.put_line(fnd_file.log,l_mesg_str2);
572: fnd_file.put_line(fnd_file.log,l_mesg_str3);
573:
574: END IF;

Line 571: fnd_file.put_line(fnd_file.log,l_mesg_str2);

567: l_mesg_str3 := l_mesg_str3 || LPAD(lcur_awdisb.disb_net_amt,50);
568:
569: fnd_file.new_line(fnd_file.log,1);
570: fnd_file.put_line(fnd_file.log,l_mesg_str1);
571: fnd_file.put_line(fnd_file.log,l_mesg_str2);
572: fnd_file.put_line(fnd_file.log,l_mesg_str3);
573:
574: END IF;
575:

Line 572: fnd_file.put_line(fnd_file.log,l_mesg_str3);

568:
569: fnd_file.new_line(fnd_file.log,1);
570: fnd_file.put_line(fnd_file.log,l_mesg_str1);
571: fnd_file.put_line(fnd_file.log,l_mesg_str2);
572: fnd_file.put_line(fnd_file.log,l_mesg_str3);
573:
574: END IF;
575:
576: END IF;

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

704:
705: EXCEPTION
706: WHEN SKIP_THIS_RECORD THEN
707: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
708: fnd_file.put_line(fnd_file.log,fnd_message.get);
709: fnd_file.new_line(fnd_file.log,1);
710: END;
711:
712: END LOOP; -- ## End Loop of Disb Loop

Line 709: fnd_file.new_line(fnd_file.log,1);

705: EXCEPTION
706: WHEN SKIP_THIS_RECORD THEN
707: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
708: fnd_file.put_line(fnd_file.log,fnd_message.get);
709: fnd_file.new_line(fnd_file.log,1);
710: END;
711:
712: END LOOP; -- ## End Loop of Disb Loop
713:

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

714: COMMIT;
715:
716: -- Print the disbursment details of 'COD generated disbursements received' in the log file
717: fnd_message.set_name('IGF','IGF_SL_DL_DB_COD_DISB');
718: fnd_file.put_line(fnd_file.log,fnd_message.get);
719: FOR l_disb_count IN 1 .. l_disb_dtl_tab.COUNT LOOP
720:
721: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'C' THEN
722: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));

Line 722: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));

718: fnd_file.put_line(fnd_file.log,fnd_message.get);
719: FOR l_disb_count IN 1 .. l_disb_dtl_tab.COUNT LOOP
720:
721: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'C' THEN
722: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
723: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
724: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
725: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
726: END IF;

Line 723: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));

719: FOR l_disb_count IN 1 .. l_disb_dtl_tab.COUNT LOOP
720:
721: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'C' THEN
722: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
723: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
724: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
725: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
726: END IF;
727:

Line 724: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));

720:
721: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'C' THEN
722: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
723: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
724: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
725: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
726: END IF;
727:
728: END LOOP;

Line 725: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));

721: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'C' THEN
722: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
723: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
724: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
725: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
726: END IF;
727:
728: END LOOP;
729:

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

728: END LOOP;
729:
730: -- Print the disbursment details of 'Payment to Servicing Response Received' in the log file
731: fnd_message.set_name('IGF','IGF_SL_DL_DB_PYMN_SRVC');
732: fnd_file.put_line(fnd_file.log,fnd_message.get);
733: FOR l_disb_count IN 1 .. l_disb_dtl_tab.COUNT LOOP
734:
735: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'P' THEN
736: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));

Line 736: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));

732: fnd_file.put_line(fnd_file.log,fnd_message.get);
733: FOR l_disb_count IN 1 .. l_disb_dtl_tab.COUNT LOOP
734:
735: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'P' THEN
736: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
737: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
738: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
739: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
740: END IF;

Line 737: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));

733: FOR l_disb_count IN 1 .. l_disb_dtl_tab.COUNT LOOP
734:
735: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'P' THEN
736: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
737: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
738: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
739: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
740: END IF;
741:

Line 738: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));

734:
735: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'P' THEN
736: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
737: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
738: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
739: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
740: END IF;
741:
742: END LOOP;

Line 739: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));

735: IF l_disb_dtl_tab(l_disb_count).p_rec_type = 'P' THEN
736: fnd_file.put_line(fnd_file.log,RPAD(l_disb_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_num));
737: fnd_file.put_line(fnd_file.log,RPAD(l_disb_seq_num_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_seq_num));
738: fnd_file.put_line(fnd_file.log,RPAD(l_disb_date_desc ,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_date));
739: fnd_file.put_line(fnd_file.log,RPAD(l_disb_gross_amt_desc,50)||' : '||TO_CHAR(l_disb_dtl_tab(l_disb_count).p_disb_amount));
740: END IF;
741:
742: END LOOP;
743:

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

772: ROLLBACK;
773:
774: retcode := 2;
775: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
776: fnd_file.put_line(fnd_file.log,SQLERRM);
777: igs_ge_msg_stack.conc_exception_hndl;
778:
779: END disb_ack;
780: