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_RECORD dependencies on FND_LOG

Line 9: replacing FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

5: --------------------------------------------------------------------
6: -- who when what
7: ----------------------------------------------------------------------------------
8: -- upinjark 16-Feb-2005 Bug #4187798. Modified line no 181,227,422
9: replacing FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
10: with FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
11: ----------------------------------------------------------------------------------
12:
13: brajendr 12-Oct-2004 FA138 ISIR Enhacements

Line 10: with FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION

6: -- who when what
7: ----------------------------------------------------------------------------------
8: -- upinjark 16-Feb-2005 Bug #4187798. Modified line no 181,227,422
9: replacing FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
10: with FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
11: ----------------------------------------------------------------------------------
12:
13: brajendr 12-Oct-2004 FA138 ISIR Enhacements
14: Modified the reference of payment_isir_id

Line 173: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

169: fnd_message.set_token('P_DL_VERSION',p_dl_version);
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: WHEN OTHERS THEN
173: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
174: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLHeader_cur.exception',SQLERRM);
175: END IF;
176: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
177: fnd_message.set_token('NAME','igf_sl_dl_record.DLHeader_cur');

Line 174: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLHeader_cur.exception',SQLERRM);

170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: WHEN OTHERS THEN
173: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
174: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLHeader_cur.exception',SQLERRM);
175: END IF;
176: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
177: fnd_message.set_token('NAME','igf_sl_dl_record.DLHeader_cur');
178: igs_ge_msg_stack.add;

Line 219: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

215: END IF;
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLTrailer_cur.exception',SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','igf_sl_dl_record.DLTrailer_cur');

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLTrailer_cur.exception',SQLERRM);

216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLTrailer_cur.exception',SQLERRM);
221: END IF;
222: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','igf_sl_dl_record.DLTrailer_cur');
224: igs_ge_msg_stack.add;

Line 369: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

365: CLOSE c_get_person_id ;
366: -- if a laon exists then a person has to exist .. therefore not checking for notfound condition
367:
368: -- PUT DEBUG MESSAGES HERE
369: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_base_id passed to get_key_program:'|| l_base_id);
371: END IF;
372: -- Call generic API get_key_program to get course code and version number
373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);

Line 370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_base_id passed to get_key_program:'|| l_base_id);

366: -- if a laon exists then a person has to exist .. therefore not checking for notfound condition
367:
368: -- PUT DEBUG MESSAGES HERE
369: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_base_id passed to get_key_program:'|| l_base_id);
371: END IF;
372: -- Call generic API get_key_program to get course code and version number
373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);
374:

Line 375: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

371: END IF;
372: -- Call generic API get_key_program to get course code and version number
373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);
374:
375: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_course_cd got from get_key_program:'|| l_course_cd);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_ver_num got from get_key_program:'|| l_ver_num);
378: END IF;
379:

Line 376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_course_cd got from get_key_program:'|| l_course_cd);

372: -- Call generic API get_key_program to get course code and version number
373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);
374:
375: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_course_cd got from get_key_program:'|| l_course_cd);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_ver_num got from get_key_program:'|| l_ver_num);
378: END IF;
379:
380: IF p_acad_begin_date IS NOT NULL AND p_acad_end_date IS NOT NULL THEN

Line 377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_ver_num got from get_key_program:'|| l_ver_num);

373: igf_ap_gen_001.get_key_program(l_base_id,l_course_cd,l_ver_num);
374:
375: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_course_cd got from get_key_program:'|| l_course_cd);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.debug','l_ver_num got from get_key_program:'|| l_ver_num);
378: END IF;
379:
380: IF p_acad_begin_date IS NOT NULL AND p_acad_end_date IS NOT NULL THEN
381:

Line 419: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

415: END IF; -- Bug 5078761
416:
417: EXCEPTION
418: WHEN OTHERS THEN
419: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
420: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.exception',SQLERRM);
421: END IF;
422: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
423: FND_MESSAGE.SET_TOKEN('NAME','IGF_SL_DL_RECORD.GET_ACAD_CAL_DTLS');

Line 420: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.exception',SQLERRM);

416:
417: EXCEPTION
418: WHEN OTHERS THEN
419: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
420: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.get_acad_cal_dtls.exception',SQLERRM);
421: END IF;
422: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
423: FND_MESSAGE.SET_TOKEN('NAME','IGF_SL_DL_RECORD.GET_ACAD_CAL_DTLS');
424: IGS_GE_MSG_STACK.ADD;

Line 565: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

561: lv_acad_seq_number,
562: lv_acad_begin_dt,
563: lv_acad_end_dt,
564: lv_message ) ;
565: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_message got from get_acad_cal_dtls:'|| lv_message);
567: END IF;
568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);

Line 566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_message got from get_acad_cal_dtls:'|| lv_message);

562: lv_acad_begin_dt,
563: lv_acad_end_dt,
564: lv_message ) ;
565: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_message got from get_acad_cal_dtls:'|| lv_message);
567: END IF;
568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;

Line 568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

564: lv_message ) ;
565: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_message got from get_acad_cal_dtls:'|| lv_message);
567: END IF;
568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);

Line 569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);

565: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_message got from get_acad_cal_dtls:'|| lv_message);
567: END IF;
568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);
573: END IF;

Line 571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

567: END IF;
568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);
573: END IF;
574: -- FA 122 Loan Enhancements derive the paramters to be passed to the c_lor cursor
575: IF p_dl_loan_catg = 'DL_STAFFORD' THEN

Line 572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);

568: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_begin_date got from get_acad_cal_dtls:'|| lv_acad_begin_dt);
570: END IF;
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_record.DLOrig_cur.debug','lv_acad_end_date got from get_acad_cal_dtls:'|| lv_acad_end_dt);
573: END IF;
574: -- FA 122 Loan Enhancements derive the paramters to be passed to the c_lor cursor
575: IF p_dl_loan_catg = 'DL_STAFFORD' THEN
576: l_fed_fund_1 := 'DLS';

Line 854: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

850: END IF;
851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLOrig_cur.exception',SQLERRM);
856: END IF;
857: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
858: fnd_message.set_token('NAME','igf_sl_dl_record.DLOrig_cur');

Line 855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLOrig_cur.exception',SQLERRM);

851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
855: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_dl_record.DLOrig_cur.exception',SQLERRM);
856: END IF;
857: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
858: fnd_message.set_token('NAME','igf_sl_dl_record.DLOrig_cur');
859: igs_ge_msg_stack.add;