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

Line 139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

135: igf_sl_award.pick_setup(p_base_id,p_ci_cal_type,p_ci_seq_num,l_rel_code,l_person_id,l_party_id,p_alt_rel_code);
136: g_rel_code := l_rel_code;
137: g_party_id := l_party_id;
138: -- put debug log messages
139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
141: END IF;
142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);

Line 140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);

136: g_rel_code := l_rel_code;
137: g_party_id := l_party_id;
138: -- put debug log messages
139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
141: END IF;
142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);
144: END IF;

Line 142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

138: -- put debug log messages
139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
141: END IF;
142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);
144: END IF;
145:
146:

Line 143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);

139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
140: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
141: END IF;
142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);
144: END IF;
145:
146:
147: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

Line 156: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

152:
153: RETURN l_hold_rel_ind;
154:
155: EXCEPTION WHEN OTHERS THEN
156: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);
158: END IF;
159: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
160: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_HOLD_REL_IND');

Line 157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);

153: RETURN l_hold_rel_ind;
154:
155: EXCEPTION WHEN OTHERS THEN
156: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
157: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.exception',SQLERRM);
158: END IF;
159: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
160: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_HOLD_REL_IND');
161: igs_ge_msg_stack.conc_exception_hndl;

Line 218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

214: g_party_id := l_party_id;
215: --
216: -- put debug log messages
217: --
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
220: END IF;
221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);

Line 219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);

215: --
216: -- put debug log messages
217: --
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
220: END IF;
221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);
223: END IF;

Line 221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

217: --
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
220: END IF;
221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);
223: END IF;
224:
225: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

Line 222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);

218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned rel_code: '||l_rel_code);
220: END IF;
221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);
223: END IF;
224:
225: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN
226: OPEN c_clsetup(g_rel_code,g_party_id);

Line 234: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

230:
231: RETURN l_auto_late_disb_ind;
232:
233: EXCEPTION WHEN OTHERS THEN
234: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);
236: END IF;
237: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_AUTO_LATE_IND');

Line 235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);

231: RETURN l_auto_late_disb_ind;
232:
233: EXCEPTION WHEN OTHERS THEN
234: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
235: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.exception',SQLERRM);
236: END IF;
237: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_CL_AUTO_LATE_IND');
239: igs_ge_msg_stack.conc_exception_hndl;

Line 320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

316: END IF;
317:
318: g_party_id := l_party_id;
319:
320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
322: END IF;
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);

Line 321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);

317:
318: g_party_id := l_party_id;
319:
320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
322: END IF;
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
325: END IF;

Line 323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

319:
320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
322: END IF;
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
325: END IF;
326:
327: OPEN c_clsetup(g_rel_code,g_party_id);

Line 324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);

320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
322: END IF;
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
325: END IF;
326:
327: OPEN c_clsetup(g_rel_code,g_party_id);
328: FETCH c_clsetup INTO l_cl_fee1,l_cl_alt_fee1;

Line 350: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

346: END IF;
347:
348: g_party_id := l_party_id;
349:
350: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
352: END IF;
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);

Line 351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);

347:
348: g_party_id := l_party_id;
349:
350: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
352: END IF;
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
355: END IF;

Line 353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

349:
350: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
352: END IF;
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
355: END IF;
356:
357: OPEN c_clsetup(g_rel_code,g_party_id);

Line 354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);

350: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
351: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned rel_code: '||l_rel_code);
352: END IF;
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee1.debug','The value pick_setup returned party_id: '||l_party_id);
355: END IF;
356:
357: OPEN c_clsetup(g_rel_code,g_party_id);
358: FETCH c_clsetup INTO l_cl_fee1,l_cl_alt_fee1;

Line 367: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

363: END IF;
364:
365: RETURN 0;
366: EXCEPTION WHEN OTHERS THEN
367: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);
369: END IF;
370: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
371: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE1');

Line 368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);

364:
365: RETURN 0;
366: EXCEPTION WHEN OTHERS THEN
367: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee1.exception',SQLERRM);
369: END IF;
370: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
371: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE1');
372: igs_ge_msg_stack.conc_exception_hndl;

Line 446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

442: g_party_id := l_party_id;
443: --
444: -- put debug log messages
445: --
446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);
448: END IF;
449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);

Line 447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);

443: --
444: -- put debug log messages
445: --
446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);
448: END IF;
449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);
451: END IF;

Line 449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

445: --
446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);
448: END IF;
449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);
451: END IF;
452:
453:

Line 450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);

446: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
447: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned rel_code: '||l_rel_code);
448: END IF;
449: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);
451: END IF;
452:
453:
454: IF igf_sl_gen.chk_cl_alt(p_fed_fund_code) = 'TRUE' THEN

Line 471: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

467: END IF;
468: RETURN 0;
469:
470: EXCEPTION WHEN OTHERS THEN
471: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);
473: END IF;
474: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
475: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE2');

Line 472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);

468: RETURN 0;
469:
470: EXCEPTION WHEN OTHERS THEN
471: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
472: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_fee2.exception',SQLERRM);
473: END IF;
474: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
475: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_FEE2');
476: igs_ge_msg_stack.conc_exception_hndl;

Line 527: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

523: RETURN l_v_return_val;
524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);
529: END IF;
530: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
531: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_DISB_DATE');

Line 528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);

524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
528: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_disb_date.exception',SQLERRM);
529: END IF;
530: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
531: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_DISB_DATE');
532: igs_ge_msg_stack.conc_exception_hndl;

Line 558: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

554: CLOSE c_rel_code;
555:
556: RETURN l_alt_rel_code;
557: EXCEPTION WHEN OTHERS THEN
558: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);
560: END IF;
561: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
562: fnd_message.set_token('NAME','IGF_SL_AWARD.get_alt_rel_code');

Line 559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);

555:
556: RETURN l_alt_rel_code;
557: EXCEPTION WHEN OTHERS THEN
558: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
559: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_alt_rel_code.exception',SQLERRM);
560: END IF;
561: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
562: fnd_message.set_token('NAME','IGF_SL_AWARD.get_alt_rel_code');
563: igs_ge_msg_stack.conc_exception_hndl;

Line 603: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

599: -- Loan Status or Loan Change Status is SENT. If SENT, then should
600: -- not allow to update anything in Awards Table. So, returning
601: -- FALSE, saying do not allow update to awards.
602:
603: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
604: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.Award_id', p_award_id);
605: END IF;
606:
607: OPEN c_loans(p_award_id);

Line 604: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.Award_id', p_award_id);

600: -- not allow to update anything in Awards Table. So, returning
601: -- FALSE, saying do not allow update to awards.
602:
603: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
604: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.Award_id', p_award_id);
605: END IF;
606:
607: OPEN c_loans(p_award_id);
608: FETCH c_loans INTO l_loan_id, l_loan_status, l_loan_chg_status;

Line 652: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

648: END IF;
649: END IF;
650: RETURN 'FALSE';
651: EXCEPTION WHEN OTHERS THEN
652: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);
654: END IF;
655: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
656: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_LOAN_UPD_LOCK');

Line 653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);

649: END IF;
650: RETURN 'FALSE';
651: EXCEPTION WHEN OTHERS THEN
652: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
653: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.chk_loan_upd_lock.exception',SQLERRM);
654: END IF;
655: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
656: fnd_message.set_token('NAME','IGF_SL_AWARD.CHK_LOAN_UPD_LOCK');
657: igs_ge_msg_stack.conc_exception_hndl;

Line 713: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

709: --
710: p_rebate_amt := p_net_amt - ( p_gross_amt - p_loan_fee_amt);
711:
712: EXCEPTION WHEN OTHERS THEN
713: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);
715: END IF;
716: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_AMTS');

Line 714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);

710: p_rebate_amt := p_net_amt - ( p_gross_amt - p_loan_fee_amt);
711:
712: EXCEPTION WHEN OTHERS THEN
713: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
714: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.get_loan_amts.exception',SQLERRM);
715: END IF;
716: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGF_SL_AWARD.GET_LOAN_AMTS');
718: igs_ge_msg_stack.conc_exception_hndl;

Line 810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

806: ELSE
807: g_party_id := NULL;
808: END IF;
809: -- put debug log messages
810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);
812: END IF;
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);

Line 811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);

807: g_party_id := NULL;
808: END IF;
809: -- put debug log messages
810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);
812: END IF;
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);
815: END IF;

Line 813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

809: -- put debug log messages
810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);
812: END IF;
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);
815: END IF;
816:
817: g_rel_code := p_rel_code;

Line 814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);

810: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
811: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned rel_code: '||l_rel_code);
812: END IF;
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.recalc_fees.debug','The value pick_setup returned party_id: '||l_party_id);
815: END IF;
816:
817: g_rel_code := p_rel_code;
818:

Line 910: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

906:
907: END LOOP;
908:
909: EXCEPTION WHEN OTHERS THEN
910: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);
912: END IF;
913: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
914: fnd_message.set_token('NAME','IGF_SL_AWARD.RECALC_FEES');

Line 911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);

907: END LOOP;
908:
909: EXCEPTION WHEN OTHERS THEN
910: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
911: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.recalc_fees.exception',SQLERRM);
912: END IF;
913: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
914: fnd_message.set_token('NAME','IGF_SL_AWARD.RECALC_FEES');
915: igs_ge_msg_stack.conc_exception_hndl;

Line 1041: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1037:
1038: g_base_id := p_base_id;
1039: igf_sl_gen.get_associated_org(g_base_id, lv_party_number, g_party_id, lv_module, lv_return_status, lv_msg_data);
1040:
1041: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1042: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.pick_setup.debug','The value select_org returned : '||g_party_id);
1043: END IF;
1044: --FACR116
1045: -- If the alt_rel_code passed is NOT NULL means it has to be done for the Alternative Loans

Line 1042: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.pick_setup.debug','The value select_org returned : '||g_party_id);

1038: g_base_id := p_base_id;
1039: igf_sl_gen.get_associated_org(g_base_id, lv_party_number, g_party_id, lv_module, lv_return_status, lv_msg_data);
1040:
1041: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1042: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.pick_setup.debug','The value select_org returned : '||g_party_id);
1043: END IF;
1044: --FACR116
1045: -- If the alt_rel_code passed is NOT NULL means it has to be done for the Alternative Loans
1046: IF p_alt_rel_code IS NOT NULL THEN

Line 1210: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN

1206: p_rel_code := g_rel_code;
1207: p_party_id := g_party_id;
1208:
1209: EXCEPTION WHEN OTHERS THEN
1210: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);
1212: END IF;
1213: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1214: fnd_message.set_token('NAME','IGF_SL_AWARD.PICK_SETUP');

Line 1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);

1207: p_party_id := g_party_id;
1208:
1209: EXCEPTION WHEN OTHERS THEN
1210: IF FND_LOG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level THEN
1211: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_award.pick_setup.exception',SQLERRM);
1212: END IF;
1213: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1214: fnd_message.set_token('NAME','IGF_SL_AWARD.PICK_SETUP');
1215: igs_ge_msg_stack.conc_exception_hndl;

Line 1270: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1266: CLOSE c_chk_chg_enable;
1267: RETURN TRUE;
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);
1272: END IF;
1273: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1274: fnd_message.set_token('NAME','igf_sl_award.chk_chg_enable');

Line 1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);

1267: RETURN TRUE;
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1271: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_chg_enable exception',SQLERRM);
1272: END IF;
1273: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1274: fnd_message.set_token('NAME','igf_sl_award.chk_chg_enable');
1275: igs_ge_msg_stack.add;

Line 1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1340:
1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);
1346: END IF;
1347: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1348: fnd_message.set_token('NAME','igf_sl_award.chk_add_new_disb');

Line 1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);

1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1345: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_add_new_disb exception',SQLERRM);
1346: END IF;
1347: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1348: fnd_message.set_token('NAME','igf_sl_award.chk_add_new_disb');
1349: igs_ge_msg_stack.add;

Line 1449: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1445: END IF;
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);
1451: END IF;
1452: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1453: fnd_message.set_token('NAME','igf_sl_award.chk_loan_increase');

Line 1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);

1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1450: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_loan_increase exception',SQLERRM);
1451: END IF;
1452: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1453: fnd_message.set_token('NAME','igf_sl_award.chk_loan_increase');
1454: igs_ge_msg_stack.add;

Line 1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1523: RETURN l_n_cl_version;
1524:
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);
1529: END IF;
1530: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1531: fnd_message.set_token('NAME','igf_sl_award.get_loan_cl_version');

Line 1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);

1524:
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1528: fnd_log.string(fnd_log.level_exception,'igf_sl_award.get_loan_cl_version exception',SQLERRM);
1529: END IF;
1530: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1531: fnd_message.set_token('NAME','igf_sl_award.get_loan_cl_version');
1532: igs_ge_msg_stack.add;

Line 1610: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

1606: CLOSE c_chk_fund_st_chg_2 ;
1607: RETURN TRUE;
1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);
1612: END IF;
1613: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1614: fnd_message.set_token('NAME','igf_sl_award.chk_fund_st_chg');

Line 1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);

1607: RETURN TRUE;
1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
1611: fnd_log.string(fnd_log.level_exception,'igf_sl_award.chk_fund_st_chg exception',SQLERRM);
1612: END IF;
1613: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1614: fnd_message.set_token('NAME','igf_sl_award.chk_fund_st_chg');
1615: igs_ge_msg_stack.add;