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

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

164: This function will check if there is already correction present which has not been batched. If yes then the correction
165: record is updated instead of creating a new correction record.
166: Also, if the correction is present with status 'BATCHED', then new corrections are created with status 'PENDING'
167: */
168: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
169: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','opening cursor with cur_dup_rec > pn_isir_id/pn_sar_field_number'||pn_isir_id ||'/'||pn_sar_field_number);
170: END IF;
171:
172: OPEN cur_dup_rec (pn_isir_id ,pn_sar_field_number);

Line 169: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','opening cursor with cur_dup_rec > pn_isir_id/pn_sar_field_number'||pn_isir_id ||'/'||pn_sar_field_number);

165: record is updated instead of creating a new correction record.
166: Also, if the correction is present with status 'BATCHED', then new corrections are created with status 'PENDING'
167: */
168: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
169: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','opening cursor with cur_dup_rec > pn_isir_id/pn_sar_field_number'||pn_isir_id ||'/'||pn_sar_field_number);
170: END IF;
171:
172: OPEN cur_dup_rec (pn_isir_id ,pn_sar_field_number);
173: LOOP

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

178: IF cur_dup_rec%NOTFOUND THEN
179: IF l_corr_status IS NULL THEN
180: l_new_corr_status := 'READY' ;
181: l_insert := TRUE;
182: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
183: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','New Correction status is READY');
184: END IF;
185: END IF;
186: EXIT;

Line 183: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','New Correction status is READY');

179: IF l_corr_status IS NULL THEN
180: l_new_corr_status := 'READY' ;
181: l_insert := TRUE;
182: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
183: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','New Correction status is READY');
184: END IF;
185: END IF;
186: EXIT;
187: END IF;

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

188:
189: IF l_corr_status IN ( 'NOTREADY', 'READY','PENDING','HOLD') THEN
190: l_insert := FALSE;
191: l_new_corr_status := l_corr_status;
192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','New Correction status is '||l_corr_status);
194: END IF;
195:
196: ELSIF l_corr_status = 'BATCHED' THEN

Line 193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','New Correction status is '||l_corr_status);

189: IF l_corr_status IN ( 'NOTREADY', 'READY','PENDING','HOLD') THEN
190: l_insert := FALSE;
191: l_new_corr_status := l_corr_status;
192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
193: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','New Correction status is '||l_corr_status);
194: END IF;
195:
196: ELSIF l_corr_status = 'BATCHED' THEN
197: IF l_cur_dup_rec.corrected_value = pn_corrected_value THEN

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

195:
196: ELSIF l_corr_status = 'BATCHED' THEN
197: IF l_cur_dup_rec.corrected_value = pn_corrected_value THEN
198: l_exists_flag := TRUE;
199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','value is the same as already present in the record with status batched');
201: END IF;
202:
203: ELSE

Line 200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','value is the same as already present in the record with status batched');

196: ELSIF l_corr_status = 'BATCHED' THEN
197: IF l_cur_dup_rec.corrected_value = pn_corrected_value THEN
198: l_exists_flag := TRUE;
199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','value is the same as already present in the record with status batched');
201: END IF;
202:
203: ELSE
204: l_new_corr_status := 'PENDING';

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

202:
203: ELSE
204: l_new_corr_status := 'PENDING';
205: l_insert:= TRUE;
206: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','value is not same as already present in the record with status batched and now status changed to pending ');
208: END IF;
209: END IF;
210: END IF;

Line 207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','value is not same as already present in the record with status batched and now status changed to pending ');

203: ELSE
204: l_new_corr_status := 'PENDING';
205: l_insert:= TRUE;
206: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug','value is not same as already present in the record with status batched and now status changed to pending ');
208: END IF;
209: END IF;
210: END IF;
211:

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

236: CLOSE cur_dup_rec;
237: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.L_CHK_DUP_CORR '||SQLERRM);
239: igs_ge_msg_stack.add;
240: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug',SQLERRM);
242: END IF;
243: RETURN FALSE;
244: END l_chk_dup_corr;

Line 241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug',SQLERRM);

237: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
238: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.L_CHK_DUP_CORR '||SQLERRM);
239: igs_ge_msg_stack.add;
240: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_chk_dup_corr.debug',SQLERRM);
242: END IF;
243: RETURN FALSE;
244: END l_chk_dup_corr;
245:

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

375: x_adnl_unsub_loan_elig_flag => cur_fbr_rec.adnl_unsub_loan_elig_flag,
376: x_lock_awd_flag => cur_fbr_rec.lock_awd_flag,
377: x_lock_coa_flag => cur_fbr_rec.lock_coa_flag
378: );
379: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
380: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_fa_base_rec_pkg.update_row successfull');
381: END IF;
382: END LOOP;
383:

Line 380: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_fa_base_rec_pkg.update_row successfull');

376: x_lock_awd_flag => cur_fbr_rec.lock_awd_flag,
377: x_lock_coa_flag => cur_fbr_rec.lock_coa_flag
378: );
379: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
380: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_fa_base_rec_pkg.update_row successfull');
381: END IF;
382: END LOOP;
383:
384: EXCEPTION

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

385: WHEN OTHERS THEN
386: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
387: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.L_UPDATE_BASE_REC '||SQLERRM);
388: IGS_GE_MSG_STACK.ADD;
389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
390: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug',SQLERRM);
391: END IF;
392: APP_EXCEPTION.RAISE_EXCEPTION;
393: END l_update_base_rec;

Line 390: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug',SQLERRM);

386: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
387: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.L_UPDATE_BASE_REC '||SQLERRM);
388: IGS_GE_MSG_STACK.ADD;
389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
390: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug',SQLERRM);
391: END IF;
392: APP_EXCEPTION.RAISE_EXCEPTION;
393: END l_update_base_rec;
394:

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

766: x_reject_override_k_flag => cur_ori_isir_rec.reject_override_k_flag,
767: x_rejected_status_change_flag => cur_ori_isir_rec.rejected_status_change_flag,
768: x_verification_selection_flag => cur_ori_isir_rec.verification_selection_flag
769: );
770: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
771: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_isir_matched_pkg.insert_row successfull New ISIR ID: '||pn_isir_id);
772: END IF;
773: END LOOP;
774:

Line 771: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_isir_matched_pkg.insert_row successfull New ISIR ID: '||pn_isir_id);

767: x_rejected_status_change_flag => cur_ori_isir_rec.rejected_status_change_flag,
768: x_verification_selection_flag => cur_ori_isir_rec.verification_selection_flag
769: );
770: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
771: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_update_base_rec.debug','igf_ap_isir_matched_pkg.insert_row successfull New ISIR ID: '||pn_isir_id);
772: END IF;
773: END LOOP;
774:
775: EXCEPTION

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

777: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
778: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.CREATE_CORRECTION_ISIR '||SQLERRM);
779: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
780: IGS_GE_MSG_STACK.ADD;
781: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.create_correction_isir.debug',SQLERRM);
783: END IF;
784: APP_EXCEPTION.RAISE_EXCEPTION;
785:

Line 782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.create_correction_isir.debug',SQLERRM);

778: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.CREATE_CORRECTION_ISIR '||SQLERRM);
779: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
780: IGS_GE_MSG_STACK.ADD;
781: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.create_correction_isir.debug',SQLERRM);
783: END IF;
784: APP_EXCEPTION.RAISE_EXCEPTION;
785:
786: END create_correction_isir;

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

1131: x_reject_override_k_flag => p_isir_rec.reject_override_k_flag,
1132: x_rejected_status_change_flag => p_isir_rec.rejected_status_change_flag,
1133: x_verification_selection_flag => p_isir_rec.verification_selection_flag
1134: );
1135: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug','igf_ap_isir_matched_pkg.update_row successfull');
1137: END IF;
1138:
1139: EXCEPTION

Line 1136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug','igf_ap_isir_matched_pkg.update_row successfull');

1132: x_rejected_status_change_flag => p_isir_rec.rejected_status_change_flag,
1133: x_verification_selection_flag => p_isir_rec.verification_selection_flag
1134: );
1135: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1136: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug','igf_ap_isir_matched_pkg.update_row successfull');
1137: END IF;
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN

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

1140: WHEN OTHERS THEN
1141: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1142: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_CORRECTION_ISIR '||SQLERRM);
1143: IGS_GE_MSG_STACK.ADD;
1144: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1145: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug',SQLERRM);
1146: END IF;
1147: APP_EXCEPTION.RAISE_EXCEPTION;
1148: END update_correction_isir;

Line 1145: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug',SQLERRM);

1141: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1142: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_CORRECTION_ISIR '||SQLERRM);
1143: IGS_GE_MSG_STACK.ADD;
1144: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1145: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_correction_isir.debug',SQLERRM);
1146: END IF;
1147: APP_EXCEPTION.RAISE_EXCEPTION;
1148: END update_correction_isir;
1149:

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

1195: END IF;
1196: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1197: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.l_incomplete '||SQLERRM);
1198: IGS_GE_MSG_STACK.ADD;
1199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_incomplete.debug',SQLERRM);
1201: END IF;
1202: APP_EXCEPTION.RAISE_EXCEPTION;
1203: END l_incomplete;

Line 1200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_incomplete.debug',SQLERRM);

1196: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1197: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.l_incomplete '||SQLERRM);
1198: IGS_GE_MSG_STACK.ADD;
1199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_incomplete.debug',SQLERRM);
1201: END IF;
1202: APP_EXCEPTION.RAISE_EXCEPTION;
1203: END l_incomplete;
1204:

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

1240: X_CORRECTED_VALUE => pv_item_value,
1241: X_CORRECTION_STATUS => NVL(l_new_corr_status,'READY'),
1242: X_MODE => 'R'
1243: );
1244: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');
1246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : ln_isirc_id/pn_isir_id/pn_sequence_number : '||ln_isirc_id||' / '||pn_isir_id||' / '||pn_sequence_number);
1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;

Line 1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');

1241: X_CORRECTION_STATUS => NVL(l_new_corr_status,'READY'),
1242: X_MODE => 'R'
1243: );
1244: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');
1246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : ln_isirc_id/pn_isir_id/pn_sequence_number : '||ln_isirc_id||' / '||pn_isir_id||' / '||pn_sequence_number);
1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;
1249: ELSIF pv_mode = 'UPDATE' THEN

Line 1246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : ln_isirc_id/pn_isir_id/pn_sequence_number : '||ln_isirc_id||' / '||pn_isir_id||' / '||pn_sequence_number);

1242: X_MODE => 'R'
1243: );
1244: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');
1246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : ln_isirc_id/pn_isir_id/pn_sequence_number : '||ln_isirc_id||' / '||pn_isir_id||' / '||pn_sequence_number);
1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;
1249: ELSIF pv_mode = 'UPDATE' THEN
1250: FOR corr_upd_rec IN upd_Corr_cur LOOP

Line 1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);

1243: );
1244: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1245: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.insert_row successfull with values ');
1246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : ln_isirc_id/pn_isir_id/pn_sequence_number : '||ln_isirc_id||' / '||pn_isir_id||' / '||pn_sequence_number);
1247: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_cal_type/pv_isir_map_column/pv_retval/pv_item_value'||pv_cal_type||'/'||pv_isir_map_column||'/'||pv_retval||'/'||pv_item_value);
1248: END IF;
1249: ELSIF pv_mode = 'UPDATE' THEN
1250: FOR corr_upd_rec IN upd_Corr_cur LOOP
1251: igf_ap_isir_corr_pkg.update_row

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

1261: X_CORRECTED_VALUE => pv_item_value,
1262: X_CORRECTION_STATUS => l_new_corr_status,
1263: X_MODE => 'R'
1264: );
1265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);

Line 1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');

1262: X_CORRECTION_STATUS => l_new_corr_status,
1263: X_MODE => 'R'
1264: );
1265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);

Line 1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);

1263: X_MODE => 'R'
1264: );
1265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);
1271: END IF;

Line 1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);

1264: );
1265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);
1271: END IF;
1272: END LOOP;

Line 1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);

1265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);
1271: END IF;
1272: END LOOP;
1273: END IF;

Line 1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);

1266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','igf_ap_isir_corr_pkg.update_row successfull');
1267: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.rowid / corr_upd_rec.isirc_id : '||corr_upd_rec.rowid||' / '||corr_upd_rec.isirc_id);
1268: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.isir_id / corr_upd_rec.ci_sequence_number : '||corr_upd_rec.isir_id||' / '||corr_upd_rec.ci_sequence_number);
1269: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : corr_upd_rec.ci_cal_type / corr_upd_rec.sar_field_number : '||corr_upd_rec.ci_cal_type||' / '||corr_upd_rec.sar_field_number);
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','Values : pv_retval / pv_item_value / l_new_corr_status : '||pv_retval / pv_item_value||' / '||l_new_corr_status);
1271: END IF;
1272: END LOOP;
1273: END IF;
1274: EXCEPTION

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

1275: WHEN OTHERS THEN
1276: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1277: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.L_CREATE_CORR_RECORD '||SQLERRM);
1278: IGS_GE_MSG_STACK.ADD;
1279: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1280: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug',SQLERRM);
1281: END IF;
1282: RETURN;
1283: END l_create_corr_record;

Line 1280: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug',SQLERRM);

1276: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1277: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.L_CREATE_CORR_RECORD '||SQLERRM);
1278: IGS_GE_MSG_STACK.ADD;
1279: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1280: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug',SQLERRM);
1281: END IF;
1282: RETURN;
1283: END l_create_corr_record;
1284:

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

1335: -- Get the isir_id of the latest ISIR for the student
1336: IF pv_isir_id IS NULL THEN
1337: fnd_message.set_name('IGF','IGF_AP_NO_ISIR_RECS_EXIST');
1338: fnd_file.put_line(fnd_file.log,fnd_message.get);
1339: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','No ISIR record exists');
1341: END IF;
1342: ELSE
1343:

Line 1340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','No ISIR record exists');

1336: IF pv_isir_id IS NULL THEN
1337: fnd_message.set_name('IGF','IGF_AP_NO_ISIR_RECS_EXIST');
1338: fnd_file.put_line(fnd_file.log,fnd_message.get);
1339: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','No ISIR record exists');
1341: END IF;
1342: ELSE
1343:
1344: IF pv_column_name IS NOT NULL THEN

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

1384: WHEN OTHERS THEN
1385: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1386: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.L_VALIDATE_DATA '||SQLERRM);
1387: igs_ge_msg_stack.add;
1388: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1389: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_validate_data.debug',SQLERRM);
1390: END IF;
1391: RETURN;
1392: END l_validate_data;

Line 1389: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_validate_data.debug',SQLERRM);

1385: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1386: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.L_VALIDATE_DATA '||SQLERRM);
1387: igs_ge_msg_stack.add;
1388: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1389: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_validate_data.debug',SQLERRM);
1390: END IF;
1391: RETURN;
1392: END l_validate_data;
1393:

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

1540: fnd_message.set_name('IGF','IGF_AP_PROCESSING_STUDENT');
1541: fnd_message.set_token ('PERSON_NAME',rec_selected.given_names ||' '||rec_selected.surname);
1542: fnd_message.set_token ('PERSON_NUMBER',rec_selected.person_number);
1543: fnd_file.put_line(fnd_file.log,fnd_message.get);
1544: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Procssing student '||rec_selected.given_names ||' '||rec_selected.surname );
1546: END IF;
1547: ln_tot_count := ln_tot_count + 1;
1548:

Line 1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Procssing student '||rec_selected.given_names ||' '||rec_selected.surname );

1541: fnd_message.set_token ('PERSON_NAME',rec_selected.given_names ||' '||rec_selected.surname);
1542: fnd_message.set_token ('PERSON_NUMBER',rec_selected.person_number);
1543: fnd_file.put_line(fnd_file.log,fnd_message.get);
1544: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Procssing student '||rec_selected.given_names ||' '||rec_selected.surname );
1546: END IF;
1547: ln_tot_count := ln_tot_count + 1;
1548:
1549: l_cur_chk_batched := NULL;

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

1571: CLOSE cur_get_ver_item_count;
1572: fnd_message.set_name('IGF','IGF_AP_STDNT_SKIP_NO_VERIF');
1573: fnd_file.put_line(fnd_file.log,fnd_message.get);
1574: fnd_file.new_line(fnd_file.log,2);
1575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','No verification items present , Therefore skipping the student');
1577: END IF;
1578: RAISE SKIP_STUDENT;
1579: ELSE

Line 1576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','No verification items present , Therefore skipping the student');

1572: fnd_message.set_name('IGF','IGF_AP_STDNT_SKIP_NO_VERIF');
1573: fnd_file.put_line(fnd_file.log,fnd_message.get);
1574: fnd_file.new_line(fnd_file.log,2);
1575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','No verification items present , Therefore skipping the student');
1577: END IF;
1578: RAISE SKIP_STUDENT;
1579: ELSE
1580: CLOSE cur_get_ver_item_count;

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

1594: -- Create the CORRECTION ISIR
1595: ln_corr_isir_id := NULL;
1596: create_correction_isir( rec_selected.base_id, ln_corr_isir_id );
1597: IF ln_corr_isir_id IS NULL THEN
1598: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Could not create correction record, Therefore skipping the student');
1600: END IF;
1601: RAISE SKIP_STUDENT;
1602: END IF;

Line 1599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Could not create correction record, Therefore skipping the student');

1595: ln_corr_isir_id := NULL;
1596: create_correction_isir( rec_selected.base_id, ln_corr_isir_id );
1597: IF ln_corr_isir_id IS NULL THEN
1598: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Could not create correction record, Therefore skipping the student');
1600: END IF;
1601: RAISE SKIP_STUDENT;
1602: END IF;
1603:

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

1623: pv_ci_cal_type => rec_selected.ci_cal_type,
1624: pv_ci_sequence_number => rec_selected.ci_sequence_number,
1625: pv_update_ssn => lv_update_ssn
1626: );
1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','l_validate_data sucessfull');
1629: END IF;
1630: END LOOP;
1631:

Line 1628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','l_validate_data sucessfull');

1624: pv_ci_sequence_number => rec_selected.ci_sequence_number,
1625: pv_update_ssn => lv_update_ssn
1626: );
1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1628: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','l_validate_data sucessfull');
1629: END IF;
1630: END LOOP;
1631:
1632: -- Compute EFC Against the updated correction ISIR

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

1640: p_ignore_warnings => 'N',
1641: p_sys_batch_yr => lv_get_sys_year.sys_award_year,
1642: p_return_status => p_efc_ret_status
1643: );
1644: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1645: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','igf_ap_efc_calc.calculate_efc sucessfull');
1646: END IF;
1647:
1648: IF p_efc_ret_status = 'W' THEN

Line 1645: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','igf_ap_efc_calc.calculate_efc sucessfull');

1641: p_sys_batch_yr => lv_get_sys_year.sys_award_year,
1642: p_return_status => p_efc_ret_status
1643: );
1644: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1645: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','igf_ap_efc_calc.calculate_efc sucessfull');
1646: END IF;
1647:
1648: IF p_efc_ret_status = 'W' THEN
1649: -- Computation stopped with Warnings.

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

1647:
1648: IF p_efc_ret_status = 'W' THEN
1649: -- Computation stopped with Warnings.
1650: -- So re-submit with Ignore Warnings
1651: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1652: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','EFC Computation stopped with Warnings.So re-submit with Ignore Warnings');
1653: END IF;
1654:
1655: igf_ap_efc_calc.calculate_efc(

Line 1652: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','EFC Computation stopped with Warnings.So re-submit with Ignore Warnings');

1648: IF p_efc_ret_status = 'W' THEN
1649: -- Computation stopped with Warnings.
1650: -- So re-submit with Ignore Warnings
1651: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1652: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','EFC Computation stopped with Warnings.So re-submit with Ignore Warnings');
1653: END IF;
1654:
1655: igf_ap_efc_calc.calculate_efc(
1656: p_isir_rec => lv_efc_isir_rec,

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

1657: p_ignore_warnings => 'Y',
1658: p_sys_batch_yr => lv_get_sys_year.sys_award_year,
1659: p_return_status => p_efc_ret_status
1660: );
1661: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1662: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','igf_ap_efc_calc.calculate_efc sucessfull');
1663: END IF;
1664: END IF;
1665:

Line 1662: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','igf_ap_efc_calc.calculate_efc sucessfull');

1658: p_sys_batch_yr => lv_get_sys_year.sys_award_year,
1659: p_return_status => p_efc_ret_status
1660: );
1661: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1662: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','igf_ap_efc_calc.calculate_efc sucessfull');
1663: END IF;
1664: END IF;
1665:
1666: -- Now check the final return value of p_efc_ret_status

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

1671: lv_ver_status := 'ACCURATE';
1672:
1673: -- Update FA Process Status in FA Base Record.
1674: igf_ap_batch_ver_prc_pkg.update_process_status (rec_selected.base_id,lv_ver_status);
1675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1676: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Updated FA Process Status in FA Base Record');
1677: END IF;
1678: ln_tot_no_corr_count := ln_tot_no_corr_count+1;
1679: fnd_message.set_name ('IGF','IGF_AP_VER_STAT_ACCURATE');

Line 1676: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Updated FA Process Status in FA Base Record');

1672:
1673: -- Update FA Process Status in FA Base Record.
1674: igf_ap_batch_ver_prc_pkg.update_process_status (rec_selected.base_id,lv_ver_status);
1675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1676: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Updated FA Process Status in FA Base Record');
1677: END IF;
1678: ln_tot_no_corr_count := ln_tot_no_corr_count+1;
1679: fnd_message.set_name ('IGF','IGF_AP_VER_STAT_ACCURATE');
1680: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1686: -- For Update of Correction ISIR.
1687: update_correction_isir (pn_base_id => rec_selected.base_id,
1688: p_isir_rec => lv_efc_isir_rec,
1689: p_update_ssn => lv_update_ssn );
1690: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Correction Records were created for the student and Verification Process Status set to Corrections Sent');
1692: END IF;
1693: ln_tot_corr_count := ln_tot_corr_count + 1;
1694: END IF;

Line 1691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Correction Records were created for the student and Verification Process Status set to Corrections Sent');

1687: update_correction_isir (pn_base_id => rec_selected.base_id,
1688: p_isir_rec => lv_efc_isir_rec,
1689: p_update_ssn => lv_update_ssn );
1690: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1691: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Correction Records were created for the student and Verification Process Status set to Corrections Sent');
1692: END IF;
1693: ln_tot_corr_count := ln_tot_corr_count + 1;
1694: END IF;
1695:

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

1698: -- PRINT ALL ERRORS
1699: p_msg_count := FND_MSG_PUB.Count_Msg();
1700:
1701: IF NVL(p_msg_count,0) > 0 THEN
1702: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1703: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','EFC computation for the context student has failed.');
1704: END IF;
1705: FND_MESSAGE.SET_NAME('IGF','IGF_AP_EFC_FAIL');
1706: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1703: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','EFC computation for the context student has failed.');

1699: p_msg_count := FND_MSG_PUB.Count_Msg();
1700:
1701: IF NVL(p_msg_count,0) > 0 THEN
1702: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1703: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','EFC computation for the context student has failed.');
1704: END IF;
1705: FND_MESSAGE.SET_NAME('IGF','IGF_AP_EFC_FAIL');
1706: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1707:

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

1709: p_msg_text := fnd_msg_pub.get(i,'F');
1710: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || TO_CHAR(i) || '.' || p_msg_text);
1711: END LOOP;
1712: END IF;
1713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Since EFC could not be computed with given correction items, No correction item has been created for this Student.');
1715: END IF;
1716: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Since EFC could not be computed with given correction items, No correction item has been created for this Student.');

1710: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || TO_CHAR(i) || '.' || p_msg_text);
1711: END LOOP;
1712: END IF;
1713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Since EFC could not be computed with given correction items, No correction item has been created for this Student.');
1715: END IF;
1716: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1718: ROLLBACK TO IGFAP08B_SP;

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

1730: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.MAIN-INNER '||SQLERRM);
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1732: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1734: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main-inner.debug',SQLERRM);
1736: END IF;
1737: ROLLBACK TO IGFAP08B_SP;
1738: END;

Line 1735: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main-inner.debug',SQLERRM);

1731: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1732: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1734: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main-inner.debug',SQLERRM);
1736: END IF;
1737: ROLLBACK TO IGFAP08B_SP;
1738: END;
1739: ELSE

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

1771: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.main');
1772: igs_ge_msg_stack.add;
1773: igs_ge_msg_stack.conc_exception_hndl;
1774: fnd_file.put_line(fnd_file.log,'ERROR: '||SQLERRM);
1775: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1776: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug',SQLERRM);
1777: END IF;
1778: app_exception.raise_exception;
1779: END main;

Line 1776: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug',SQLERRM);

1772: igs_ge_msg_stack.add;
1773: igs_ge_msg_stack.conc_exception_hndl;
1774: fnd_file.put_line(fnd_file.log,'ERROR: '||SQLERRM);
1775: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1776: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug',SQLERRM);
1777: END IF;
1778: app_exception.raise_exception;
1779: END main;
1780:

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

1886: fnd_file.put_line(fnd_file.log,SQLERRM);
1887: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1888: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_PROCESS_STATUS');
1889: IGS_GE_MSG_STACK.ADD;
1890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1891: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_process_status.debug',SQLERRM);
1892: END IF;
1893: APP_EXCEPTION.RAISE_EXCEPTION;
1894:

Line 1891: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_process_status.debug',SQLERRM);

1887: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1888: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_PROCESS_STATUS');
1889: IGS_GE_MSG_STACK.ADD;
1890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1891: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_process_status.debug',SQLERRM);
1892: END IF;
1893: APP_EXCEPTION.RAISE_EXCEPTION;
1894:
1895: END update_process_status;

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

1936: fnd_file.put_line(fnd_file.log,SQLERRM);
1937: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1938: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_FED_VERIF_STATUS');
1939: IGS_GE_MSG_STACK.ADD;
1940: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1941: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_fed_verif_status.debug',SQLERRM);
1942: END IF;
1943: APP_EXCEPTION.RAISE_EXCEPTION;
1944:

Line 1941: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_fed_verif_status.debug',SQLERRM);

1937: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1938: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_FED_VERIF_STATUS');
1939: IGS_GE_MSG_STACK.ADD;
1940: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1941: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.update_fed_verif_status.debug',SQLERRM);
1942: END IF;
1943: APP_EXCEPTION.RAISE_EXCEPTION;
1944:
1945: END update_fed_verif_status;

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

1999:
2000: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2001: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.GET_GR_VER_CODE');
2002: igs_ge_msg_stack.add;
2003: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2004: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.get_gr_ver_code.debug',SQLERRM);
2005: END IF;
2006: app_exception.raise_exception;
2007:

Line 2004: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.get_gr_ver_code.debug',SQLERRM);

2000: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2001: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.GET_GR_VER_CODE');
2002: igs_ge_msg_stack.add;
2003: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2004: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.get_gr_ver_code.debug',SQLERRM);
2005: END IF;
2006: app_exception.raise_exception;
2007:
2008: END get_gr_ver_code;