DBA Data[Home] [Help]

APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on FND_LOG

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

6155: put_hash_values('IGF_AP_STATE_CODES,IGF_CITIZENSHIP_TYPE,IGF_ST_MARITAL_STAT_TYPE,IGF_ENROLMENT_TYPE,IGF_HIGH_GRAD_LVL_TYPE,IGF_DEG_CERT_TYPE,IGF_AP_GRADE_LEVEL,IGF_DRUG_ELIGIBILITY_TYPE,IGF_TAX_RET_STAT_TYPE,IGF_TAX_FORM_TYPE,'
6156: ||'IGF_TAX_EXEMPTION_ELIG_TYPE,IGF_P_MARITAL_STAT_TYPE,IGF_AP_HOUSING_STAT,IGF_AP_DEP_STATUS,IGF_AP_ADDRESS_CHANGE_FLAG,IGF_AP_CPS_PUSHED_ISIR_FLAG,IGF_AP_ELECTRONIC_TRANS_TYPE,IGF_AP_SAR_C_CHANGE_TYPE,IGF_AP_PARENTS_SSN_MATCH_TYPE,'
6157: || 'IGF_AP_LOAN_LIMIT_TYPE,IGF_AP_REJECT_OVERRIDE_FLAG,IGF_AP_ENROLLMENT_STATUS_TYPE',c_award_det_rec.sys_award_year);
6158: l_debug_str := l_debug_str || 'Lookups loading complete ' ;
6159: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6160: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug','c_award_det_rec.batch_year Is: ' || c_award_det_rec.batch_year || ' : ');
6161: END IF;
6162:
6163: IF NVL(p_cps_import,'N') = 'Y' THEN

Line 6160: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug','c_award_det_rec.batch_year Is: ' || c_award_det_rec.batch_year || ' : ');

6156: ||'IGF_TAX_EXEMPTION_ELIG_TYPE,IGF_P_MARITAL_STAT_TYPE,IGF_AP_HOUSING_STAT,IGF_AP_DEP_STATUS,IGF_AP_ADDRESS_CHANGE_FLAG,IGF_AP_CPS_PUSHED_ISIR_FLAG,IGF_AP_ELECTRONIC_TRANS_TYPE,IGF_AP_SAR_C_CHANGE_TYPE,IGF_AP_PARENTS_SSN_MATCH_TYPE,'
6157: || 'IGF_AP_LOAN_LIMIT_TYPE,IGF_AP_REJECT_OVERRIDE_FLAG,IGF_AP_ENROLLMENT_STATUS_TYPE',c_award_det_rec.sys_award_year);
6158: l_debug_str := l_debug_str || 'Lookups loading complete ' ;
6159: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6160: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug','c_award_det_rec.batch_year Is: ' || c_award_det_rec.batch_year || ' : ');
6161: END IF;
6162:
6163: IF NVL(p_cps_import,'N') = 'Y' THEN
6164: OPEN c_cps_int_data(c_award_det_rec.batch_year);

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

6433: END IF;
6434: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------------------------------------------------------------');
6435: END IF;
6436: -- write debugging message to log table
6437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug',l_debug_str);
6439: END IF;
6440:
6441: EXCEPTION

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

6434: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------------------------------------------------------------');
6435: END IF;
6436: -- write debugging message to log table
6437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6438: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug',l_debug_str);
6439: END IF;
6440:
6441: EXCEPTION
6442: WHEN OTHERS THEN

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

6440:
6441: EXCEPTION
6442: WHEN OTHERS THEN
6443: -- write debugging message to log table
6444: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6445: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.begin.debug',l_debug_str||SQLERRM);
6446: END IF;
6447: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6448: fnd_message.set_token('NAME','IGF_AP_LI_ISIR_IMP_PROC.MAIN'||SQLERRM);

Line 6445: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.begin.debug',l_debug_str||SQLERRM);

6441: EXCEPTION
6442: WHEN OTHERS THEN
6443: -- write debugging message to log table
6444: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6445: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.begin.debug',l_debug_str||SQLERRM);
6446: END IF;
6447: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6448: fnd_message.set_token('NAME','IGF_AP_LI_ISIR_IMP_PROC.MAIN'||SQLERRM);
6449: fnd_file.put_line(fnd_file.log,fnd_message.get );

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

6468: fnd_file.put_line(fnd_file.OUTPUT,fnd_message.get || ' : ' || l_num_recrd_failed);
6469: EXCEPTION
6470: WHEN OTHERS THEN
6471: -- write debugging message to log table
6472: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6473: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug',l_debug_str||SQLERRM);
6474: END IF;
6475: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6476: fnd_message.set_token('NAME','IGF_AP_LI_ISIR_IMP_PROC.MAIN'||SQLERRM);

Line 6473: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug',l_debug_str||SQLERRM);

6469: EXCEPTION
6470: WHEN OTHERS THEN
6471: -- write debugging message to log table
6472: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
6473: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_li_isir_imp_proc.main.debug',l_debug_str||SQLERRM);
6474: END IF;
6475: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6476: fnd_message.set_token('NAME','IGF_AP_LI_ISIR_IMP_PROC.MAIN'||SQLERRM);
6477: fnd_file.put_line(fnd_file.log,fnd_message.get );