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_MESSAGE

Line 237: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

233:
234: EXCEPTION
235: WHEN OTHERS 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);

Line 238: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.L_CHK_DUP_CORR '||SQLERRM);

234: EXCEPTION
235: WHEN OTHERS 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;

Line 386: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

382: END LOOP;
383:
384: EXCEPTION
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);

Line 387: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.L_UPDATE_BASE_REC '||SQLERRM);

383:
384: EXCEPTION
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;

Line 777: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

773: END LOOP;
774:
775: EXCEPTION
776: WHEN others 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

Line 778: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.CREATE_CORRECTION_ISIR '||SQLERRM);

774:
775: EXCEPTION
776: WHEN others 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);

Line 779: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

775: EXCEPTION
776: WHEN others 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;

Line 824: fnd_message.set_name('IGF','IGF_GR_UPDT_SSN_FAIL');

820: l_message
821: );
822:
823: IF l_message = 'IGF_GR_UPDT_SSN_FAIL' THEN
824: fnd_message.set_name('IGF','IGF_GR_UPDT_SSN_FAIL');
825: fnd_file.put_line(fnd_file.log,fnd_message.get);
826: END IF;
827:
828: END IF;

Line 825: fnd_file.put_line(fnd_file.log,fnd_message.get);

821: );
822:
823: IF l_message = 'IGF_GR_UPDT_SSN_FAIL' THEN
824: fnd_message.set_name('IGF','IGF_GR_UPDT_SSN_FAIL');
825: fnd_file.put_line(fnd_file.log,fnd_message.get);
826: END IF;
827:
828: END IF;
829:

Line 1141: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1137: END IF;
1138:
1139: EXCEPTION
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);

Line 1142: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_CORRECTION_ISIR '||SQLERRM);

1138:
1139: EXCEPTION
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;

Line 1182: FND_MESSAGE.SET_NAME('IGF','IGF_AP_INCOMPLETE_DOC_VAL');

1178: FETCH cur_get_ver_data INTO lv_flag;
1179: CLOSE cur_get_ver_data;
1180:
1181: IF lv_flag > 0 THEN
1182: FND_MESSAGE.SET_NAME('IGF','IGF_AP_INCOMPLETE_DOC_VAL');
1183: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1184: lb_return_status := TRUE;
1185: ELSE
1186: lb_return_status := FALSE;

Line 1183: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1179: CLOSE cur_get_ver_data;
1180:
1181: IF lv_flag > 0 THEN
1182: FND_MESSAGE.SET_NAME('IGF','IGF_AP_INCOMPLETE_DOC_VAL');
1183: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1184: lb_return_status := TRUE;
1185: ELSE
1186: lb_return_status := FALSE;
1187: END IF;

Line 1196: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1192: WHEN OTHERS THEN
1193: IF cur_get_ver_data%ISOPEN THEN
1194: CLOSE cur_get_ver_data;
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);

Line 1197: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.l_incomplete '||SQLERRM);

1193: IF cur_get_ver_data%ISOPEN THEN
1194: CLOSE cur_get_ver_data;
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;

Line 1276: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1272: END LOOP;
1273: END IF;
1274: EXCEPTION
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);

Line 1277: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.L_CREATE_CORR_RECORD '||SQLERRM);

1273: END IF;
1274: EXCEPTION
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;

Line 1337: fnd_message.set_name('IGF','IGF_AP_NO_ISIR_RECS_EXIST');

1333: lv_item_value := pv_item_value;
1334:
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;

Line 1338: fnd_file.put_line(fnd_file.log,fnd_message.get);

1334:
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

Line 1364: fnd_message.set_name('IGF','IGF_AP_CORR_REC_CREATED');

1360: OPEN cur_get_sar_field_desc ( pv_column_name , l_lookup_type) ;
1361: FETCH cur_get_sar_field_desc INTO l_sar_col_desc ;
1362: CLOSE cur_get_sar_field_desc ;
1363:
1364: fnd_message.set_name('IGF','IGF_AP_CORR_REC_CREATED');
1365: fnd_message.set_token ('ITEM',l_sar_col_desc );
1366: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);
1367: l_create_corr_record ( pn_base_id,ln_isir_id,pv_isir_map_column,lv_cal_type, ln_sequence_number, lv_retval,lv_item_value,l_mode);
1368:

Line 1365: fnd_message.set_token ('ITEM',l_sar_col_desc );

1361: FETCH cur_get_sar_field_desc INTO l_sar_col_desc ;
1362: CLOSE cur_get_sar_field_desc ;
1363:
1364: fnd_message.set_name('IGF','IGF_AP_CORR_REC_CREATED');
1365: fnd_message.set_token ('ITEM',l_sar_col_desc );
1366: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);
1367: l_create_corr_record ( pn_base_id,ln_isir_id,pv_isir_map_column,lv_cal_type, ln_sequence_number, lv_retval,lv_item_value,l_mode);
1368:
1369: -- Update the Correction ISIR with the correction Value

Line 1366: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);

1362: CLOSE cur_get_sar_field_desc ;
1363:
1364: fnd_message.set_name('IGF','IGF_AP_CORR_REC_CREATED');
1365: fnd_message.set_token ('ITEM',l_sar_col_desc );
1366: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);
1367: l_create_corr_record ( pn_base_id,ln_isir_id,pv_isir_map_column,lv_cal_type, ln_sequence_number, lv_retval,lv_item_value,l_mode);
1368:
1369: -- Update the Correction ISIR with the correction Value
1370: EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'

Line 1385: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1381: END IF;
1382:
1383: EXCEPTION
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);

Line 1386: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.L_VALIDATE_DATA '||SQLERRM);

1382:
1383: EXCEPTION
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;

Line 1540: fnd_message.set_name('IGF','IGF_AP_PROCESSING_STUDENT');

1536: -- Start the process by getting all the students for which
1537: -- the verification process is initiated.
1538: FOR rec_selected IN cur_selected_rec(lv_ci_cal_type, lv_ci_sequence_number) LOOP
1539:
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

Line 1541: fnd_message.set_token ('PERSON_NAME',rec_selected.given_names ||' '||rec_selected.surname);

1537: -- the verification process is initiated.
1538: FOR rec_selected IN cur_selected_rec(lv_ci_cal_type, lv_ci_sequence_number) LOOP
1539:
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 );

Line 1542: fnd_message.set_token ('PERSON_NUMBER',rec_selected.person_number);

1538: FOR rec_selected IN cur_selected_rec(lv_ci_cal_type, lv_ci_sequence_number) LOOP
1539:
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;

Line 1543: fnd_file.put_line(fnd_file.log,fnd_message.get);

1539:
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;

Line 1572: fnd_message.set_name('IGF','IGF_AP_STDNT_SKIP_NO_VERIF');

1568: OPEN cur_get_ver_item_count(rec_selected.base_id);
1569: FETCH cur_get_ver_item_count INTO lc_get_ver_item_count;
1570: IF cur_get_ver_item_count%NOTFOUND 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');

Line 1573: fnd_file.put_line(fnd_file.log,fnd_message.get);

1569: FETCH cur_get_ver_item_count INTO lc_get_ver_item_count;
1570: IF cur_get_ver_item_count%NOTFOUND 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;

Line 1679: fnd_message.set_name ('IGF','IGF_AP_VER_STAT_ACCURATE');

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);
1681:
1682: ELSIF ln_corr_count <> 0 THEN
1683:

Line 1680: fnd_file.put_line(fnd_file.log,fnd_message.get);

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);
1681:
1682: ELSIF ln_corr_count <> 0 THEN
1683:
1684: -- Update the Correction ISIR with Correction Items Values in Federal Verification Worksheet.

Line 1705: FND_MESSAGE.SET_NAME('IGF','IGF_AP_EFC_FAIL');

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:
1708: FOR i in 1..p_msg_count LOOP
1709: p_msg_text := fnd_msg_pub.get(i,'F');

Line 1706: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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:
1708: FOR i in 1..p_msg_count LOOP
1709: p_msg_text := fnd_msg_pub.get(i,'F');
1710: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || TO_CHAR(i) || '.' || p_msg_text);

Line 1716: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');

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;
1719:
1720: END IF;

Line 1717: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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;
1719:
1720: END IF;
1721:

Line 1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1725: WHEN SKIP_STUDENT THEN
1726: NULL;
1727:
1728: WHEN OTHERS THEN
1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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);

Line 1730: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.MAIN-INNER '||SQLERRM);

1726: NULL;
1727:
1728: WHEN OTHERS THEN
1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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

Line 1731: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1727:
1728: WHEN OTHERS THEN
1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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);

Line 1732: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');

1728: WHEN OTHERS THEN
1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 1733: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 1741: fnd_message.set_name('IGF','IGF_AP_COR_BATCH_EXIST');

1737: ROLLBACK TO IGFAP08B_SP;
1738: END;
1739: ELSE
1740: IF l_cur_chk_batched.base_id IS NOT NULL THEN
1741: fnd_message.set_name('IGF','IGF_AP_COR_BATCH_EXIST');
1742: fnd_file.put_line(fnd_file.log,fnd_message.get);
1743: END IF;
1744: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
1745:

Line 1742: fnd_file.put_line(fnd_file.log,fnd_message.get);

1738: END;
1739: ELSE
1740: IF l_cur_chk_batched.base_id IS NOT NULL THEN
1741: fnd_message.set_name('IGF','IGF_AP_COR_BATCH_EXIST');
1742: fnd_file.put_line(fnd_file.log,fnd_message.get);
1743: END IF;
1744: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
1745:
1746: END IF;

Line 1751: fnd_message.set_name('IGF','IGF_AP_MATCHING_REC_NT_FND');

1747:
1748: END LOOP;
1749:
1750: IF ln_tot_count = 0 THEN
1751: fnd_message.set_name('IGF','IGF_AP_MATCHING_REC_NT_FND');
1752: fnd_file.put_line(fnd_file.log,fnd_message.get);
1753: END IF;
1754:
1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');

Line 1752: fnd_file.put_line(fnd_file.log,fnd_message.get);

1748: END LOOP;
1749:
1750: IF ln_tot_count = 0 THEN
1751: fnd_message.set_name('IGF','IGF_AP_MATCHING_REC_NT_FND');
1752: fnd_file.put_line(fnd_file.log,fnd_message.get);
1753: END IF;
1754:
1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));

Line 1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');

1751: fnd_message.set_name('IGF','IGF_AP_MATCHING_REC_NT_FND');
1752: fnd_file.put_line(fnd_file.log,fnd_message.get);
1753: END IF;
1754:
1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));
1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');

Line 1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));

1752: fnd_file.put_line(fnd_file.log,fnd_message.get);
1753: END IF;
1754:
1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));
1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));

Line 1757: fnd_file.put_line(fnd_file.output,fnd_message.get);

1753: END IF;
1754:
1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));
1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);

Line 1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');

1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));
1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');

Line 1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));

1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));
1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');
1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));

Line 1761: fnd_file.put_line(fnd_file.output,fnd_message.get);

1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');
1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));
1765: fnd_file.put_line(fnd_file.output,fnd_message.get);

Line 1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');

1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');
1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));
1765: fnd_file.put_line(fnd_file.output,fnd_message.get);
1766:
1767: retcode := 0;

Line 1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));

1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');
1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));
1765: fnd_file.put_line(fnd_file.output,fnd_message.get);
1766:
1767: retcode := 0;
1768: EXCEPTION

Line 1765: fnd_file.put_line(fnd_file.output,fnd_message.get);

1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');
1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));
1765: fnd_file.put_line(fnd_file.output,fnd_message.get);
1766:
1767: retcode := 0;
1768: EXCEPTION
1769: WHEN others THEN

Line 1770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1766:
1767: retcode := 0;
1768: EXCEPTION
1769: WHEN others THEN
1770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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);

Line 1771: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.main');

1767: retcode := 0;
1768: EXCEPTION
1769: WHEN others THEN
1770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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

Line 1850: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1846: OPEN cur_ver_status ( p_base_id);
1847: FETCH cur_ver_status INTO lv_fed_verif_status,lv_fa_process_status;
1848: IF cur_ver_status%NOTFOUND THEN
1849: CLOSE cur_ver_status;
1850: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1851: FND_MESSAGE.SET_TOKEN('NAME','FA BASE DOES NOT EXIST');
1852: fnd_file.put_line(fnd_file.log,fnd_message.get);
1853: APP_EXCEPTION.RAISE_EXCEPTION;
1854: END IF;

Line 1851: FND_MESSAGE.SET_TOKEN('NAME','FA BASE DOES NOT EXIST');

1847: FETCH cur_ver_status INTO lv_fed_verif_status,lv_fa_process_status;
1848: IF cur_ver_status%NOTFOUND THEN
1849: CLOSE cur_ver_status;
1850: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1851: FND_MESSAGE.SET_TOKEN('NAME','FA BASE DOES NOT EXIST');
1852: fnd_file.put_line(fnd_file.log,fnd_message.get);
1853: APP_EXCEPTION.RAISE_EXCEPTION;
1854: END IF;
1855: CLOSE cur_ver_status;

Line 1852: fnd_file.put_line(fnd_file.log,fnd_message.get);

1848: IF cur_ver_status%NOTFOUND THEN
1849: CLOSE cur_ver_status;
1850: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1851: FND_MESSAGE.SET_TOKEN('NAME','FA BASE DOES NOT EXIST');
1852: fnd_file.put_line(fnd_file.log,fnd_message.get);
1853: APP_EXCEPTION.RAISE_EXCEPTION;
1854: END IF;
1855: CLOSE cur_ver_status;
1856:

Line 1887: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1883:
1884: EXCEPTION
1885: WHEN OTHERS 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);

Line 1888: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_PROCESS_STATUS');

1884: EXCEPTION
1885: WHEN OTHERS 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;

Line 1937: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1933:
1934: EXCEPTION
1935: WHEN OTHERS 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);

Line 1938: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_FED_VERIF_STATUS');

1934: EXCEPTION
1935: WHEN OTHERS 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;

Line 2000: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1996:
1997: EXCEPTION
1998: WHEN OTHERS 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);

Line 2001: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.GET_GR_VER_CODE');

1997: EXCEPTION
1998: WHEN OTHERS 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;