DBA Data[Home] [Help]

APPS.IGF_SL_DL_LI_IMP_PKG dependencies on FND_LOG

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

220: END LOOP;
221: END IF;
222: EXCEPTION
223: WHEN others THEN
224: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);
226: END IF;
227: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PRINT_MESSAGE');

Line 225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);

221: END IF;
222: EXCEPTION
223: WHEN others THEN
224: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);
226: END IF;
227: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PRINT_MESSAGE');
229: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

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

1059:
1060: EXCEPTION
1061:
1062: WHEN others THEN
1063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);
1065: END IF;
1066: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1067: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_DISB');

Line 1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);

1060: EXCEPTION
1061:
1062: WHEN others THEN
1063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);
1065: END IF;
1066: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1067: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
1068: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

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

1645:
1646: EXCEPTION
1647:
1648: WHEN others THEN
1649: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);
1651: END IF;
1652: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1653: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');

Line 1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);

1646: EXCEPTION
1647:
1648: WHEN others THEN
1649: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);
1651: END IF;
1652: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1653: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
1654: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

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

2985: END IF;
2986: EXCEPTION
2987:
2988: WHEN others THEN
2989: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);
2991: END IF;
2992: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2993: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DELETE_CONTEXT_RECORDS');

Line 2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);

2986: EXCEPTION
2987:
2988: WHEN others THEN
2989: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);
2991: END IF;
2992: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2993: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DELETE_CONTEXT_RECORDS');
2994: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);

Line 3449: IF fnd_log.TEST(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG') THEN

3445:
3446:
3447:
3448: -- Initialize lb_write_log for writing into debug log table
3449: IF fnd_log.TEST(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG') THEN
3450: lb_write_log := TRUE;
3451: END IF;
3452: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_person_number||' '||l_interface.person_number);
3453: fnd_file.new_line(fnd_file.log,1);

Line 3898: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));

3894: IF lb_write_log THEN
3895: IF g_request_id IS NULL THEN
3896: g_request_id := fnd_global.conc_request_id;
3897: END IF;
3898: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));
3899: END IF;
3900:
3901: END; -- block for updating and deleting interface records
3902: END LOOP;

Line 3922: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str || SQLERRM,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));

3918: EXCEPTION
3919:
3920: WHEN others THEN
3921: ROLLBACK;
3922: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str || SQLERRM,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));
3923: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3924: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.RUN');
3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
3926: retcode := 2;