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 IGF_SL_DL_PRINT_PNOTE

Line 1: PACKAGE BODY igf_sl_dl_print_pnote AS

1: PACKAGE BODY igf_sl_dl_print_pnote AS
2: /* $Header: IGFSL16B.pls 120.1 2006/04/18 23:19:15 akomurav noship $ */
3: /***************************************************************
4: Created By : avenkatr
5: Date Created By : 2001/05/08

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

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 800: END igf_sl_dl_print_pnote;

796: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
797:
798: END process_pnote;
799:
800: END igf_sl_dl_print_pnote;