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

Line 22: -- replacing FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

18: ----------------------------------------------------------------------------------
19: -- who when what
20: ----------------------------------------------------------------------------------
21: -- upinjark 16-Feb-2005 Bug #4187798. Modified line no 135,168,499
22: -- replacing FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
23: -- with FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
24: ----------------------------------------------------------------------------------
25: -- ridas 03-JAN-2005 Bug #4097414. Modified the cursor c_get_persons
26: ----------------------------------------------------------------------------------

Line 23: -- with FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION

19: -- who when what
20: ----------------------------------------------------------------------------------
21: -- upinjark 16-Feb-2005 Bug #4187798. Modified line no 135,168,499
22: -- replacing FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
23: -- with FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION
24: ----------------------------------------------------------------------------------
25: -- ridas 03-JAN-2005 Bug #4097414. Modified the cursor c_get_persons
26: ----------------------------------------------------------------------------------
27: -- sjadhav 14-oct-2003 Changed update flag code to update

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

122: END LOOP;
123:
124: EXCEPTION
125: WHEN others THEN
126: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.print_log_process.exception',SQLERRM);
128: END IF;
129: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
130: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.PRINT_LOG_PROCESS');

Line 127: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.print_log_process.exception',SQLERRM);

123:
124: EXCEPTION
125: WHEN others THEN
126: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.print_log_process.exception',SQLERRM);
128: END IF;
129: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
130: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.PRINT_LOG_PROCESS');
131: app_exception.raise_exception;

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

154: g_log_tab(g_log_tab_index).message_text := RPAD('',12) || p_message_str;
155:
156: EXCEPTION
157: WHEN others THEN
158: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
159: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.add_log_table_process.exception',SQLERRM);
160: END IF;
161: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.ADD_LOG_TABLE_PROCESS');

Line 159: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.add_log_table_process.exception',SQLERRM);

155:
156: EXCEPTION
157: WHEN others THEN
158: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
159: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.add_log_table_process.exception',SQLERRM);
160: END IF;
161: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.ADD_LOG_TABLE_PROCESS');
163: app_exception.raise_exception;

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

219: END LOOP;
220:
221: EXCEPTION
222: WHEN others THEN
223: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.check_for_todo.exception',SQLERRM);
225: END IF;
226: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
227: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.CHECK_FOR_TODO');

Line 224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.check_for_todo.exception',SQLERRM);

220:
221: EXCEPTION
222: WHEN others THEN
223: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
224: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.check_for_todo.exception',SQLERRM);
225: END IF;
226: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
227: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.CHECK_FOR_TODO');
228: app_exception.raise_exception;

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

391: l_person_number := NULL;
392:
393: FETCH c_get_persons INTO l_person_id,l_person_number;
394: EXIT WHEN c_get_persons%NOTFOUND OR c_get_persons%NOTFOUND IS NULL;
395: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
396: l_debug_str := 'Person Number is:' || l_person_number;
397: END IF;
398: l_msg_count := NULL;
399: l_msg_number := NULL;

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

443: END IF;
444: END;
445:
446: ELSE
447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
448: l_debug_str := l_debug_str || ' Person has a active lender relationship';
449: END IF;
450: -- means already the active lender exists
451: IF l_chk_pref_lender.relationship_cd = p_rel_code THEN

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

463: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
464: add_log_table_process(NULL,l_error,fnd_message.get);
465: l_error_flag := TRUE;
466: ELSE
467: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
468: l_debug_str := l_debug_str || ' Previous record has to be updated';
469: END IF;
470: l_message := NULL;
471: -- Previous relationship record has to be end dated and a new record has to be added .

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

526: ELSE
527: l_success_record_cnt := l_success_record_cnt + 1;
528: END IF;
529: -- log the messgae in the logging framework
530: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_pref_lender.main.debug',l_debug_str);
532: END IF;
533: l_debug_str := NULL;
534:

Line 531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_pref_lender.main.debug',l_debug_str);

527: l_success_record_cnt := l_success_record_cnt + 1;
528: END IF;
529: -- log the messgae in the logging framework
530: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_pref_lender.main.debug',l_debug_str);
532: END IF;
533: l_debug_str := NULL;
534:
535: EXCEPTION

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

556: print_log_process(l_start_date,l_chk_perid_grp.group_cd,p_rel_code,p_update);
557:
558: EXCEPTION
559: WHEN others THEN
560: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.main.exception',SQLERRM);
562: END IF;
563: ROLLBACK;
564: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.main.exception',SQLERRM);

557:
558: EXCEPTION
559: WHEN others THEN
560: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
561: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'igf.plsql.igf_sl_pref_lender.main.exception',SQLERRM);
562: END IF;
563: ROLLBACK;
564: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
565: fnd_message.set_token('NAME','IGF_SL_PREF_LENDER.MAIN');