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_LOG

Line 49: g_debug_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

45: masehgal 19-Feb-2002 # 2216956 FACR007
46: Added Elec_mpn_ind , Borr_sign_ind in igf_sl_lor_pkg
47: ***************************************************************/
48:
49: g_debug_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50:
51: -- Main Procedure starts here and is a Concurrent Program
52:
53: PROCEDURE process_pnote(

Line 85: l_debug_str fnd_log_messages.message_text%TYPE;

81:
82: parent_dtl_rec igf_sl_gen.person_dtl_rec;
83: parent_dtl_cur igf_sl_gen.person_dtl_cur;
84:
85: l_debug_str fnd_log_messages.message_text%TYPE;
86:
87: CURSOR c_pnote_check( x_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE,
88: x_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE ) IS
89: SELECT pnote_print_ind, ci_alternate_code

Line 274: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN

270: */
271: FOR r_dl_lor_rec IN c_lor_rec( p_loan_id )
272: LOOP
273: BEGIN
274: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
275: l_debug_str := l_debug_str || ' Before updating igf_sl_lor : loan_id ' || p_loan_id;
276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);
277: l_debug_str := NULL;
278: END IF;

Line 276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);

272: LOOP
273: BEGIN
274: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
275: l_debug_str := l_debug_str || ' Before updating igf_sl_lor : loan_id ' || p_loan_id;
276: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);
277: l_debug_str := NULL;
278: END IF;
279:
280: igf_sl_lor_pkg.update_row (

Line 408: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN

404: x_esign_src_typ_cd => r_dl_lor_rec.esign_src_typ_cd,
405: x_acad_begin_date => r_dl_lor_rec.acad_begin_date,
406: x_acad_end_date => r_dl_lor_rec.acad_end_date
407: );
408: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
409: l_debug_str := l_debug_str || 'Updated igf_sl_lor : loan_id ' || p_loan_id;
410: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);
411: l_debug_str := NULL;
412: END IF;

Line 410: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);

406: x_acad_end_date => r_dl_lor_rec.acad_end_date
407: );
408: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
409: l_debug_str := l_debug_str || 'Updated igf_sl_lor : loan_id ' || p_loan_id;
410: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.update_pnote_status.debug', l_debug_str);
411: l_debug_str := NULL;
412: END IF;
413:
414: END;

Line 540: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN

536: END IF;
537:
538: --Inorder to rollback this Transaction whenever Lock Error happens
539: SAVEPOINT sp_prom_note;
540: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
541: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_s_p';
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
543: l_debug_str := NULL;
544: END IF;

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);

538: --Inorder to rollback this Transaction whenever Lock Error happens
539: SAVEPOINT sp_prom_note;
540: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
541: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_s_p';
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
543: l_debug_str := NULL;
544: END IF;
545:
546: /* Insert into IGF_SL_DL_PNOTE_S_P */

Line 571: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN

567: x_s_email_addr => student_dtl_rec.p_email_addr,
568: x_s_phone => l_person_phone,
569: x_status => 'N' /* not printed */
570: );
571: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
572: l_debug_str := l_debug_str || 'Inserted into igf_sl_dl_pnote_s_p';
573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
574: l_debug_str := NULL;
575: END IF;

Line 573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);

569: x_status => 'N' /* not printed */
570: );
571: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
572: l_debug_str := l_debug_str || 'Inserted into igf_sl_dl_pnote_s_p';
573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
574: l_debug_str := NULL;
575: END IF;
576:
577: --Since the loan is processed, call update_pnote_status to update the pnote_status to 'printed'

Line 647: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN

643: END IF;
644:
645: --Transaction to be rolled back whenever Lock Error
646: SAVEPOINT sp_prom_note;
647: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
648: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_p_p';
649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
650: l_debug_str := NULL;
651: END IF;

Line 649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);

645: --Transaction to be rolled back whenever Lock Error
646: SAVEPOINT sp_prom_note;
647: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
648: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_p_p';
649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
650: l_debug_str := NULL;
651: END IF;
652:
653: --insert into igf_sl_dl_pnote_p_p table

Line 707: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN

703: x_p_email_addr => parent_dtl_rec.p_email_addr,
704: x_p_phone => l_parent_phone,
705: x_status => 'N' /* Not printed */
706: );
707: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
708: l_debug_str := l_debug_str || 'Inserted into igf_sl_dl_pnote_s';
709: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
710: l_debug_str := NULL;
711: END IF;

Line 709: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);

705: x_status => 'N' /* Not printed */
706: );
707: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
708: l_debug_str := l_debug_str || 'Inserted into igf_sl_dl_pnote_s';
709: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
710: l_debug_str := NULL;
711: END IF;
712:
713: --Since the loan is processed, call update_pnote_status to update the pnote_status to 'printed'

Line 788: IF(FND_LOG.LEVEL_EXCEPTION >= g_debug_runtime_level)THEN

784:
785: WHEN OTHERS THEN
786: ROLLBACK;
787: RETCODE :=2;
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');

Line 789: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'igf.plsql.igf_sl_dl_print_pnote.process_pnote.exception', l_debug_str || SQLERRM );

785: WHEN OTHERS THEN
786: ROLLBACK;
787: RETCODE :=2;
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');