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

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

222: BEGIN
223: --Display message Promissory Note Processed for Person Number:-
224: l_ret:=igf_gr_gen.get_per_num(p_stud_id,l_current_per_num);
225:
226: fnd_file.new_line(fnd_file.log,1);
227: fnd_message.set_name('IGF','IGF_SL_PROC_PROM');
228: fnd_message.set_token('P_STUD',l_current_per_num);
229: fnd_message.set_token('P_LOAN',p_ln_number);
230: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

226: fnd_file.new_line(fnd_file.log,1);
227: fnd_message.set_name('IGF','IGF_SL_PROC_PROM');
228: fnd_message.set_token('P_STUD',l_current_per_num);
229: fnd_message.set_token('P_LOAN',p_ln_number);
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: END log_message;
232:
233: PROCEDURE update_pnote_status(
234: p_loan_id igf_sl_loans_all.loan_id%TYPE

Line 439: fnd_file.put_line(fnd_file.log, l_log_mesg);

435: --Display all Headings
436:
437:
438: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');
439: fnd_file.put_line(fnd_file.log, l_log_mesg);
440: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
441: fnd_file.put_line(fnd_file.log, l_log_mesg);
442:
443: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||

Line 441: fnd_file.put_line(fnd_file.log, l_log_mesg);

437:
438: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');
439: fnd_file.put_line(fnd_file.log, l_log_mesg);
440: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
441: fnd_file.put_line(fnd_file.log, l_log_mesg);
442:
443: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||
444: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;
445: fnd_file.put_line(fnd_file.log, l_log_mesg);

Line 445: fnd_file.put_line(fnd_file.log, l_log_mesg);

441: fnd_file.put_line(fnd_file.log, l_log_mesg);
442:
443: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||
444: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;
445: fnd_file.put_line(fnd_file.log, l_log_mesg);
446:
447: --Display the Person Number for the Base ID
448: l_person_num :=NULL;
449: IF p_base_id IS NOT NULL THEN

Line 455: fnd_file.put_line(fnd_file.log, l_log_mesg);

451: END IF;
452:
453:
454: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;
455: fnd_file.put_line(fnd_file.log, l_log_mesg);
456:
457: l_log_mesg := RPAD(l_heading,80,' ')||':'||RPAD(' ',4,' ')|| NVL( p_loan_number , NULL );
458: fnd_file.put_line(fnd_file.log, l_log_mesg);
459:

Line 458: fnd_file.put_line(fnd_file.log, l_log_mesg);

454: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;
455: fnd_file.put_line(fnd_file.log, l_log_mesg);
456:
457: l_log_mesg := RPAD(l_heading,80,' ')||':'||RPAD(' ',4,' ')|| NVL( p_loan_number , NULL );
458: fnd_file.put_line(fnd_file.log, l_log_mesg);
459:
460: fnd_file.new_line(fnd_file.log, 1);
461:
462: /* Check if school is configured to print */

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

456:
457: l_log_mesg := RPAD(l_heading,80,' ')||':'||RPAD(' ',4,' ')|| NVL( p_loan_number , NULL );
458: fnd_file.put_line(fnd_file.log, l_log_mesg);
459:
460: fnd_file.new_line(fnd_file.log, 1);
461:
462: /* Check if school is configured to print */
463: OPEN c_pnote_check( l_ci_cal_type, l_ci_sequence_number );
464: FETCH c_pnote_check INTO r_pnote;

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

464: FETCH c_pnote_check INTO r_pnote;
465: IF ( c_pnote_check%NOTFOUND ) THEN
466: CLOSE c_pnote_check;
467: fnd_message.set_name('IGF', 'IGF_SL_NO_DL_SETUP');
468: fnd_file.put_line(fnd_file.log, fnd_message.get);
469: RAISE NO_DATA_FOUND;
470: END IF;
471: CLOSE c_pnote_check;
472:

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

473: /* The school is not configured to print, so exit after displaying a message */
474: IF ( r_pnote.pnote_print_ind <> 'F' ) THEN
475: fnd_message.set_name('IGF', 'IGF_SL_PNOTE_SCH_NOPRNT');
476: fnd_message.set_token('AWD_YR', r_pnote.ci_alternate_code );
477: fnd_file.put_line(fnd_file.log, fnd_message.get);
478: RETURN;
479: END IF;
480:
481:

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

518: IF student_dtl_rec.p_permt_addr1 IS NULL THEN
519:
520: CLOSE student_dtl_cur;
521: --Display message in Log File that "Home" address not available for Student and Skip record.
522: fnd_file.new_line(fnd_file.log,1);
523: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);
524: fnd_message.set_name('IGF','IGF_SL_NO_S_HOME_ADDR');
525: fnd_message.set_token('P_STUD',l_stud_number);
526: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 523: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);

519:
520: CLOSE student_dtl_cur;
521: --Display message in Log File that "Home" address not available for Student and Skip record.
522: fnd_file.new_line(fnd_file.log,1);
523: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);
524: fnd_message.set_name('IGF','IGF_SL_NO_S_HOME_ADDR');
525: fnd_message.set_token('P_STUD',l_stud_number);
526: fnd_file.put_line(fnd_file.log,fnd_message.get);
527: RAISE SKIP_LOAN_RECORD;

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

522: fnd_file.new_line(fnd_file.log,1);
523: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);
524: fnd_message.set_name('IGF','IGF_SL_NO_S_HOME_ADDR');
525: fnd_message.set_token('P_STUD',l_stud_number);
526: fnd_file.put_line(fnd_file.log,fnd_message.get);
527: RAISE SKIP_LOAN_RECORD;
528:
529: END IF;
530:

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

621:
622:
623: IF student_dtl_rec.p_permt_addr1 IS NULL OR parent_dtl_rec.p_permt_addr1 IS NULL THEN
624: --Display message in Log File that "Home" Address not present for Student and Parent and Skip record.
625: fnd_file.new_line(fnd_file.log,1);
626: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);
627: fnd_message.set_name('IGF','IGF_SL_NO_SP_HOME_ADDR');
628: fnd_message.set_token('P_STUD',l_stud_number);
629: fnd_message.set_token('P_PAR',l_parent_number);

Line 626: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);

622:
623: IF student_dtl_rec.p_permt_addr1 IS NULL OR parent_dtl_rec.p_permt_addr1 IS NULL THEN
624: --Display message in Log File that "Home" Address not present for Student and Parent and Skip record.
625: fnd_file.new_line(fnd_file.log,1);
626: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);
627: fnd_message.set_name('IGF','IGF_SL_NO_SP_HOME_ADDR');
628: fnd_message.set_token('P_STUD',l_stud_number);
629: fnd_message.set_token('P_PAR',l_parent_number);
630: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

626: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec.loan_number);
627: fnd_message.set_name('IGF','IGF_SL_NO_SP_HOME_ADDR');
628: fnd_message.set_token('P_STUD',l_stud_number);
629: fnd_message.set_token('P_PAR',l_parent_number);
630: fnd_file.put_line(fnd_file.log,fnd_message.get);
631: fnd_file.new_line(fnd_file.log,1);
632: RAISE SKIP_LOAN_RECORD;
633: END IF;
634:

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

627: fnd_message.set_name('IGF','IGF_SL_NO_SP_HOME_ADDR');
628: fnd_message.set_token('P_STUD',l_stud_number);
629: fnd_message.set_token('P_PAR',l_parent_number);
630: fnd_file.put_line(fnd_file.log,fnd_message.get);
631: fnd_file.new_line(fnd_file.log,1);
632: RAISE SKIP_LOAN_RECORD;
633: END IF;
634:
635:

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

740: FETCH cur_get_loans INTO l_loan_rec_det;
741:
742: CLOSE cur_get_loans;
743:
744: fnd_file.new_line(fnd_file.log,1);
745: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
746: fnd_file.put_line(fnd_file.log,fnd_message.get);
747: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec_det.loan_number);
748: fnd_file.new_line(fnd_file.log,1);

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

742: CLOSE cur_get_loans;
743:
744: fnd_file.new_line(fnd_file.log,1);
745: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
746: fnd_file.put_line(fnd_file.log,fnd_message.get);
747: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec_det.loan_number);
748: fnd_file.new_line(fnd_file.log,1);
749: ROLLBACK TO sp_prom_note;
750:

Line 747: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec_det.loan_number);

743:
744: fnd_file.new_line(fnd_file.log,1);
745: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
746: fnd_file.put_line(fnd_file.log,fnd_message.get);
747: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec_det.loan_number);
748: fnd_file.new_line(fnd_file.log,1);
749: ROLLBACK TO sp_prom_note;
750:
751: WHEN SKIP_LOAN_RECORD THEN

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

744: fnd_file.new_line(fnd_file.log,1);
745: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
746: fnd_file.put_line(fnd_file.log,fnd_message.get);
747: fnd_file.put_line(fnd_file.log,l_heading||': '||l_loan_rec_det.loan_number);
748: fnd_file.new_line(fnd_file.log,1);
749: ROLLBACK TO sp_prom_note;
750:
751: WHEN SKIP_LOAN_RECORD THEN
752: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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

749: ROLLBACK TO sp_prom_note;
750:
751: WHEN SKIP_LOAN_RECORD THEN
752: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
753: fnd_file.put_line(fnd_file.log,fnd_message.get);
754:
755: END ;
756:
757: END LOOP; /* End of r_dl_orig_rec loop (i.e) end of the DL Orig recs loop */

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

756:
757: END LOOP; /* End of r_dl_orig_rec loop (i.e) end of the DL Orig recs loop */
758:
759: /* Display the details in the Log file */
760: fnd_file.new_line(fnd_file.log, 2);
761:
762: fnd_message.set_name('IGF', 'IGF_SL_NO_OF_PNOTES');
763: fnd_message.set_token('NO_OF_PNOTES', l_no_of_pnotes );
764: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

760: fnd_file.new_line(fnd_file.log, 2);
761:
762: fnd_message.set_name('IGF', 'IGF_SL_NO_OF_PNOTES');
763: fnd_message.set_token('NO_OF_PNOTES', l_no_of_pnotes );
764: fnd_file.put_line(fnd_file.log, fnd_message.get);
765:
766: IF l_batch_seq_num IS NOT NULL THEN
767:
768: fnd_message.set_name('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');

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

766: IF l_batch_seq_num IS NOT NULL THEN
767:
768: fnd_message.set_name('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');
769: fnd_message.set_token('PNOTE_BATCH_SEQNO', NVL( l_batch_seq_num, NULL) );
770: fnd_file.put_line(fnd_file.log, fnd_message.get);
771:
772: END IF;
773:
774: