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_MESSAGE

Line 227: fnd_message.set_name('IGF','IGF_SL_PROC_PROM');

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);
231: END log_message;

Line 228: fnd_message.set_token('P_STUD',l_current_per_num);

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);
231: END log_message;
232:

Line 229: fnd_message.set_token('P_LOAN',p_ln_number);

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);
231: END log_message;
232:
233: PROCEDURE update_pnote_status(

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 467: fnd_message.set_name('IGF', 'IGF_SL_NO_DL_SETUP');

463: OPEN c_pnote_check( l_ci_cal_type, l_ci_sequence_number );
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;

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 475: fnd_message.set_name('IGF', 'IGF_SL_PNOTE_SCH_NOPRNT');

471: CLOSE c_pnote_check;
472:
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;

Line 476: fnd_message.set_token('AWD_YR', r_pnote.ci_alternate_code );

472:
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:

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 524: fnd_message.set_name('IGF','IGF_SL_NO_S_HOME_ADDR');

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;
528:

Line 525: fnd_message.set_token('P_STUD',l_stud_number);

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;
528:
529: END IF;

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 627: fnd_message.set_name('IGF','IGF_SL_NO_SP_HOME_ADDR');

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);
631: fnd_file.new_line(fnd_file.log,1);

Line 628: fnd_message.set_token('P_STUD',l_stud_number);

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);
631: fnd_file.new_line(fnd_file.log,1);
632: RAISE SKIP_LOAN_RECORD;

Line 629: fnd_message.set_token('P_PAR',l_parent_number);

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);
631: fnd_file.new_line(fnd_file.log,1);
632: RAISE SKIP_LOAN_RECORD;
633: END IF;

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 745: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');

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);
749: ROLLBACK TO sp_prom_note;

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 752: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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');
753: fnd_file.put_line(fnd_file.log,fnd_message.get);
754:
755: END ;
756:

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 762: fnd_message.set_name('IGF', 'IGF_SL_NO_OF_PNOTES');

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);
765:
766: IF l_batch_seq_num IS NOT NULL THEN

Line 763: fnd_message.set_token('NO_OF_PNOTES', l_no_of_pnotes );

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);
765:
766: IF l_batch_seq_num IS NOT NULL THEN
767:

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 768: fnd_message.set_name('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');

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');
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;

Line 769: fnd_message.set_token('PNOTE_BATCH_SEQNO', NVL( l_batch_seq_num, NULL) );

765:
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:

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:

Line 782: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

778:
779: WHEN app_exception.record_lock_exception THEN
780: ROLLBACK;
781: retcode := 2;
782: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
783: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
784:
785: WHEN OTHERS THEN
786: ROLLBACK;

Line 792: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

788: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN
789: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_sl_dl_print_pnote.process_pnote.exception', l_debug_str || SQLERRM );
790: END IF;
791:
792: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
793: fnd_message.set_token('NAME','igf_sl_dl_print_pnote.process_pnote');
794:
795: ERRBUF := fnd_message.get;
796: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

Line 793: fnd_message.set_token('NAME','igf_sl_dl_print_pnote.process_pnote');

789: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_sl_dl_print_pnote.process_pnote.exception', l_debug_str || SQLERRM );
790: END IF;
791:
792: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
793: fnd_message.set_token('NAME','igf_sl_dl_print_pnote.process_pnote');
794:
795: ERRBUF := fnd_message.get;
796: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
797:

Line 795: ERRBUF := fnd_message.get;

791:
792: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
793: fnd_message.set_token('NAME','igf_sl_dl_print_pnote.process_pnote');
794:
795: ERRBUF := fnd_message.get;
796: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
797:
798: END process_pnote;
799: