DBA Data[Home] [Help]

APPS.IGF_AP_LG_TD_IMP dependencies on FND_LOG

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

581: FETCH c_item_system_todo_type_code INTO l_item_system_todo_type_code;
582:
583: IF (c_item_system_todo_type_code%FOUND) THEN
584:
585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_item_system_todo_type_code: '||l_item_system_todo_type_code);
587: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_get_persons.item_status_code: '||l_get_persons.item_status_code);
588: END IF;
589:

Line 586: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_item_system_todo_type_code: '||l_item_system_todo_type_code);

582:
583: IF (c_item_system_todo_type_code%FOUND) THEN
584:
585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_item_system_todo_type_code: '||l_item_system_todo_type_code);
587: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_get_persons.item_status_code: '||l_get_persons.item_status_code);
588: END IF;
589:
590: IF l_item_system_todo_type_code = 'PREFLEND' THEN

Line 587: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_get_persons.item_status_code: '||l_get_persons.item_status_code);

583: IF (c_item_system_todo_type_code%FOUND) THEN
584:
585: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_item_system_todo_type_code: '||l_item_system_todo_type_code);
587: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_ap_lg_td_imp.main.debug', 'l_get_persons.item_status_code: '||l_get_persons.item_status_code);
588: END IF;
589:
590: IF l_item_system_todo_type_code = 'PREFLEND' THEN
591:

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

711: UPDATE igf_ap_li_todo_ints
712: SET import_status_type = 'E'
713: WHERE ROWID = l_get_persons.ROW_ID;
714: END IF;
715: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
716: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_td_imp.main.debug',l_debug_str);
717: END IF;
718: l_proc_item_str := NULL;
719: l_get_meaning := NULL;

Line 716: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_td_imp.main.debug',l_debug_str);

712: SET import_status_type = 'E'
713: WHERE ROWID = l_get_persons.ROW_ID;
714: END IF;
715: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
716: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_td_imp.main.debug',l_debug_str);
717: END IF;
718: l_proc_item_str := NULL;
719: l_get_meaning := NULL;
720: l_debug_str := NULL;

Line 760: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

756:
757: EXCEPTION
758: WHEN others THEN
759: --CALL TO THE COMMON LOGGING FRAMEWORK FOR DEBUG MESSAGES
760: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
761: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_td_imp.main.exception','Exception: '||SQLERRM);
762: END IF;
763: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
764: fnd_message.set_token('NAME','IGF_AP_LG_TD_IMP.MAIN');

Line 761: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_td_imp.main.exception','Exception: '||SQLERRM);

757: EXCEPTION
758: WHEN others THEN
759: --CALL TO THE COMMON LOGGING FRAMEWORK FOR DEBUG MESSAGES
760: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
761: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_td_imp.main.exception','Exception: '||SQLERRM);
762: END IF;
763: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
764: fnd_message.set_token('NAME','IGF_AP_LG_TD_IMP.MAIN');
765: errbuf := fnd_message.get;