APPS.IGF_AP_PROCESS_CORRECTIONS dependencies on FND_MESSAGE

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

194: WHEN OTHERS THEN
195: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
196: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.blanks.exception','The exception is : ' || SQLERRM );
197: END IF;
198: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
199: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.BLANKS');
200: fnd_file.put_line(fnd_file.log,SQLERRM);
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;

Line 199: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.BLANKS');

195: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
196: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.blanks.exception','The exception is : ' || SQLERRM );
197: END IF;
198: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
199: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.BLANKS');
200: fnd_file.put_line(fnd_file.log,SQLERRM);
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203:

Line 236: fnd_message.set_name('IGF','IGF_AP_INVALID_DEST_CODE');

232: -- Give message if the ETI Destination Code is invalid. Continue with the process
233: --
234:
235: IF LENGTH(NVL(gv_dest_num,'TGXXXXX')) <> 7 THEN
236: fnd_message.set_name('IGF','IGF_AP_INVALID_DEST_CODE');
237: fnd_file.put_line(fnd_file.log, fnd_message.get);
238: gv_dest_num := 'TGXXXXX';
239: END IF;
240:

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

233: --
234:
235: IF LENGTH(NVL(gv_dest_num,'TGXXXXX')) <> 7 THEN
236: fnd_message.set_name('IGF','IGF_AP_INVALID_DEST_CODE');
237: fnd_file.put_line(fnd_file.log, fnd_message.get);
238: gv_dest_num := 'TGXXXXX';
239: END IF;
240:
241: gv_date := TO_CHAR(SYSDATE,'YYYYMMDD');

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

304: WHEN OTHERS THEN
305: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
306: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.create_header.exception','The exception is : ' || SQLERRM );
307: END IF;
308: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
309: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.CREATE_HEADER');
310: fnd_file.put_line(fnd_file.log,SQLERRM);
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;

Line 309: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.CREATE_HEADER');

305: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
306: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.create_header.exception','The exception is : ' || SQLERRM );
307: END IF;
308: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
309: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.CREATE_HEADER');
310: fnd_file.put_line(fnd_file.log,SQLERRM);
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313:

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

386: WHEN OTHERS THEN
387: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
388: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.create_trailer.exception','The exception is : ' || SQLERRM );
389: END IF;
390: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
391: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.CREATE_TRAILER');
392: fnd_file.put_line(fnd_file.log,SQLERRM);
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;

Line 391: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.CREATE_TRAILER');

387: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
388: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.create_trailer.exception','The exception is : ' || SQLERRM );
389: END IF;
390: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
391: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.CREATE_TRAILER');
392: fnd_file.put_line(fnd_file.log,SQLERRM);
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395:

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

562: WHEN OTHERS THEN
563: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
564: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.format_fields.exception','The exception is : ' || SQLERRM );
565: END IF;
566: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
567: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.FORMAT_FIELDS'|| ' ' || L_sar_column_name || ' ' || vnewval );
568: fnd_file.put_line(fnd_file.log,SQLERRM);
569: igs_ge_msg_stack.add;
570: app_exception.raise_exception;

Line 567: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.FORMAT_FIELDS'|| ' ' || L_sar_column_name || ' ' || vnewval );

563: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
564: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.format_fields.exception','The exception is : ' || SQLERRM );
565: END IF;
566: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
567: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.FORMAT_FIELDS'|| ' ' || L_sar_column_name || ' ' || vnewval );
568: fnd_file.put_line(fnd_file.log,SQLERRM);
569: igs_ge_msg_stack.add;
570: app_exception.raise_exception;
571:

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

599: WHEN OTHERS THEN
600: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
601: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.start_record.exception','The exception is : ' || SQLERRM );
602: END IF;
603: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
604: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.START_RECORD');
605: fnd_file.put_line(fnd_file.log,SQLERRM);
606: igs_ge_msg_stack.add;
607: app_exception.raise_exception;

Line 604: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.START_RECORD');

600: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
601: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.start_record.exception','The exception is : ' || SQLERRM );
602: END IF;
603: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
604: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.START_RECORD');
605: fnd_file.put_line(fnd_file.log,SQLERRM);
606: igs_ge_msg_stack.add;
607: app_exception.raise_exception;
608:

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

638: WHEN OTHERS THEN
639: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
640: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.fill_string.exception','The exception is : ' || SQLERRM );
641: END IF;
642: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
643: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.FILL_STRING');
644: fnd_file.put_line(fnd_file.log,SQLERRM);
645: igs_ge_msg_stack.add;
646: app_exception.raise_exception;

Line 643: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.FILL_STRING');

639: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
640: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.fill_string.exception','The exception is : ' || SQLERRM );
641: END IF;
642: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
643: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.FILL_STRING');
644: fnd_file.put_line(fnd_file.log,SQLERRM);
645: igs_ge_msg_stack.add;
646: app_exception.raise_exception;
647:

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

699: WHEN others THEN
700: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
701: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.compare_individual_override.exception','The exception is : ' || SQLERRM );
702: END IF;
703: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
704: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.COMPARE_INDIVIDUAL_OVERRIDE' );
705: fnd_file.put_line(fnd_file.log,SQLERRM);
706: igs_ge_msg_stack.add;
707: app_exception.raise_exception;

Line 704: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.COMPARE_INDIVIDUAL_OVERRIDE' );

700: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
701: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.compare_individual_override.exception','The exception is : ' || SQLERRM );
702: END IF;
703: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
704: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.COMPARE_INDIVIDUAL_OVERRIDE' );
705: fnd_file.put_line(fnd_file.log,SQLERRM);
706: igs_ge_msg_stack.add;
707: app_exception.raise_exception;
708:

Line 941: fnd_message.set_name('IGF','IGF_GE_ERROR_OPEN_FILE');

937:
938: EXCEPTION
939:
940: WHEN fnd_file.utl_file_error THEN
941: fnd_message.set_name('IGF','IGF_GE_ERROR_OPEN_FILE');
942: igs_ge_msg_stack.add;
943: app_exception.raise_exception;
944:
945: WHEN OTHERS THEN

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

945: WHEN OTHERS THEN
946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
947: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.write_file.exception','The exception is : ' || SQLERRM );
948: END IF;
949: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
950: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.WRITE_FILE');
951: fnd_file.put_line(fnd_file.log,SQLERRM);
952: igs_ge_msg_stack.add;
953: app_exception.raise_exception;

Line 950: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.WRITE_FILE');

946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
947: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.write_file.exception','The exception is : ' || SQLERRM );
948: END IF;
949: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
950: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.WRITE_FILE');
951: fnd_file.put_line(fnd_file.log,SQLERRM);
952: igs_ge_msg_stack.add;
953: app_exception.raise_exception;
954:

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

1158: WHEN OTHERS THEN
1159: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1160: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.update_corr.exception','The exception is : ' || SQLERRM );
1161: END IF;
1162: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1163: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.UPDATE_CORR');
1164: fnd_file.put_line(fnd_file.log,SQLERRM);
1165: igs_ge_msg_stack.add;
1166: app_exception.raise_exception;

Line 1163: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.UPDATE_CORR');

1159: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1160: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.update_corr.exception','The exception is : ' || SQLERRM );
1161: END IF;
1162: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1163: fnd_message.set_token('NAME','IGF_AP_PROCESS_CORRECTIONS.UPDATE_CORR');
1164: fnd_file.put_line(fnd_file.log,SQLERRM);
1165: igs_ge_msg_stack.add;
1166: app_exception.raise_exception;
1167:

Line 1239: fnd_message.set_name('IGF','IGF_AP_INVALID_FED_SCH');

1235:
1236: IF p_school_code IS NOT NULL THEN
1237: IF SUBSTR(p_school_code,1,1) NOT IN ('0','B','E','G')
1238: OR LENGTH(p_school_code) <> 6 THEN -- the school code entered is invalid
1239: fnd_message.set_name('IGF','IGF_AP_INVALID_FED_SCH');
1240: fnd_file.put_line(fnd_file.log, fnd_message.get);
1241: RETURN;
1242: END IF;
1243: END IF;

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

1236: IF p_school_code IS NOT NULL THEN
1237: IF SUBSTR(p_school_code,1,1) NOT IN ('0','B','E','G')
1238: OR LENGTH(p_school_code) <> 6 THEN -- the school code entered is invalid
1239: fnd_message.set_name('IGF','IGF_AP_INVALID_FED_SCH');
1240: fnd_file.put_line(fnd_file.log, fnd_message.get);
1241: RETURN;
1242: END IF;
1243: END IF;
1244:

Line 1255: fnd_message.set_name('IGF','IGF_AP_INVALID_BATCH_YR');

1251: FETCH batch_yr_cur INTO gv_batch_year;
1252:
1253: IF batch_yr_cur%NOTFOUND THEN
1254: gv_batch_year := '****';
1255: fnd_message.set_name('IGF','IGF_AP_INVALID_BATCH_YR');
1256: fnd_file.put_line(fnd_file.log, fnd_message.get);
1257: END IF;
1258: CLOSE batch_yr_cur;
1259:

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

1252:
1253: IF batch_yr_cur%NOTFOUND THEN
1254: gv_batch_year := '****';
1255: fnd_message.set_name('IGF','IGF_AP_INVALID_BATCH_YR');
1256: fnd_file.put_line(fnd_file.log, fnd_message.get);
1257: END IF;
1258: CLOSE batch_yr_cur;
1259:
1260: IF ((gv_batch_year = '5') OR (gv_batch_year = '6') OR (gv_batch_year= '7')) THEN

Line 1262: fnd_message.set_name('IGF','IGF_AP_ETI_DESTNUM_NOT_BLANK');

1258: CLOSE batch_yr_cur;
1259:
1260: IF ((gv_batch_year = '5') OR (gv_batch_year = '6') OR (gv_batch_year= '7')) THEN
1261: IF gv_dest_num IS NOT NULL THEN
1262: fnd_message.set_name('IGF','IGF_AP_ETI_DESTNUM_NOT_BLANK');
1263: fnd_file.put_line(fnd_file.log, fnd_message.get);
1264: RETURN;
1265: END IF;
1266: ELSIF gv_dest_num IS NULL THEN

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

1259:
1260: IF ((gv_batch_year = '5') OR (gv_batch_year = '6') OR (gv_batch_year= '7')) THEN
1261: IF gv_dest_num IS NOT NULL THEN
1262: fnd_message.set_name('IGF','IGF_AP_ETI_DESTNUM_NOT_BLANK');
1263: fnd_file.put_line(fnd_file.log, fnd_message.get);
1264: RETURN;
1265: END IF;
1266: ELSIF gv_dest_num IS NULL THEN
1267: fnd_message.set_name('IGF','IGF_AP_ETI_DESTNUM_BLANK');

Line 1267: fnd_message.set_name('IGF','IGF_AP_ETI_DESTNUM_BLANK');

1263: fnd_file.put_line(fnd_file.log, fnd_message.get);
1264: RETURN;
1265: END IF;
1266: ELSIF gv_dest_num IS NULL THEN
1267: fnd_message.set_name('IGF','IGF_AP_ETI_DESTNUM_BLANK');
1268: fnd_file.put_line(fnd_file.log, fnd_message.get);
1269: RETURN;
1270: END IF;
1271:

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

1264: RETURN;
1265: END IF;
1266: ELSIF gv_dest_num IS NULL THEN
1267: fnd_message.set_name('IGF','IGF_AP_ETI_DESTNUM_BLANK');
1268: fnd_file.put_line(fnd_file.log, fnd_message.get);
1269: RETURN;
1270: END IF;
1271:
1272: l_corr_stat := 'READY' ;

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

1295: --
1296: -- Log Message indicating Person Record Processed.
1297: --
1298: fnd_file.new_line(fnd_file.log,1);
1299: fnd_message.set_name('IGF','IGF_AP_PROCESSING_STUDENT');
1300: fnd_message.set_token('PERSON_NAME',gv_first_name||' '||gv_last_name);
1301: fnd_message.set_token('PERSON_NUMBER',gv_person_number);
1302: fnd_file.put_line(fnd_file.log,fnd_message.get);
1303:

Line 1300: fnd_message.set_token('PERSON_NAME',gv_first_name||' '||gv_last_name);

1296: -- Log Message indicating Person Record Processed.
1297: --
1298: fnd_file.new_line(fnd_file.log,1);
1299: fnd_message.set_name('IGF','IGF_AP_PROCESSING_STUDENT');
1300: fnd_message.set_token('PERSON_NAME',gv_first_name||' '||gv_last_name);
1301: fnd_message.set_token('PERSON_NUMBER',gv_person_number);
1302: fnd_file.put_line(fnd_file.log,fnd_message.get);
1303:
1304: x_return_status := NULL;

Line 1301: fnd_message.set_token('PERSON_NUMBER',gv_person_number);

1297: --
1298: fnd_file.new_line(fnd_file.log,1);
1299: fnd_message.set_name('IGF','IGF_AP_PROCESSING_STUDENT');
1300: fnd_message.set_token('PERSON_NAME',gv_first_name||' '||gv_last_name);
1301: fnd_message.set_token('PERSON_NUMBER',gv_person_number);
1302: fnd_file.put_line(fnd_file.log,fnd_message.get);
1303:
1304: x_return_status := NULL;
1305: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

1298: fnd_file.new_line(fnd_file.log,1);
1299: fnd_message.set_name('IGF','IGF_AP_PROCESSING_STUDENT');
1300: fnd_message.set_token('PERSON_NAME',gv_first_name||' '||gv_last_name);
1301: fnd_message.set_token('PERSON_NUMBER',gv_person_number);
1302: fnd_file.put_line(fnd_file.log,fnd_message.get);
1303:
1304: x_return_status := NULL;
1305: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1306: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_process_corrections.prepare_file.debug','The gn_baseid passed to get_stu_fao_code : ' || gn_baseid );

Line 1320: FND_MESSAGE.SET_NAME('IGF', x_msg_data);

1316:
1317: /* -- Commenting the code for future refference
1318: IF (x_return_status = 'E') AND (NVL(x_msg_data,'X') = 'IGF_AP_STU_FED_SCH_CD_NFND') THEN
1319: -- skip this record and do not create the corrections and log the message.
1320: FND_MESSAGE.SET_NAME('IGF', x_msg_data);
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1322: l_process_corr_flag := 'N'; -- Do not process Corrections
1323:
1324: ELSIF (x_return_status = 'E') AND (NVL(x_msg_data,'X') <> 'IGF_AP_STU_FED_SCH_CD_NFND') THEN

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

1317: /* -- Commenting the code for future refference
1318: IF (x_return_status = 'E') AND (NVL(x_msg_data,'X') = 'IGF_AP_STU_FED_SCH_CD_NFND') THEN
1319: -- skip this record and do not create the corrections and log the message.
1320: FND_MESSAGE.SET_NAME('IGF', x_msg_data);
1321: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1322: l_process_corr_flag := 'N'; -- Do not process Corrections
1323:
1324: ELSIF (x_return_status = 'E') AND (NVL(x_msg_data,'X') <> 'IGF_AP_STU_FED_SCH_CD_NFND') THEN
1325: -- do not skip this record and create the corrections using the school code supplied as parameter and log the message.

Line 1326: FND_MESSAGE.SET_NAME('IGF', x_msg_data);

1322: l_process_corr_flag := 'N'; -- Do not process Corrections
1323:
1324: ELSIF (x_return_status = 'E') AND (NVL(x_msg_data,'X') <> 'IGF_AP_STU_FED_SCH_CD_NFND') THEN
1325: -- do not skip this record and create the corrections using the school code supplied as parameter and log the message.
1326: FND_MESSAGE.SET_NAME('IGF', x_msg_data);
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1328: x_fed_school_code := p_school_code;
1329: l_process_corr_flag := 'Y'; -- Process Corrections
1330:

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

1323:
1324: ELSIF (x_return_status = 'E') AND (NVL(x_msg_data,'X') <> 'IGF_AP_STU_FED_SCH_CD_NFND') THEN
1325: -- do not skip this record and create the corrections using the school code supplied as parameter and log the message.
1326: FND_MESSAGE.SET_NAME('IGF', x_msg_data);
1327: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1328: x_fed_school_code := p_school_code;
1329: l_process_corr_flag := 'Y'; -- Process Corrections
1330:
1331: ELSIF (x_return_status = 'S') AND (NVL(x_fed_school_code,'X') <> p_school_code) THEN

Line 1333: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');

1329: l_process_corr_flag := 'Y'; -- Process Corrections
1330:
1331: ELSIF (x_return_status = 'S') AND (NVL(x_fed_school_code,'X') <> p_school_code) THEN
1332: -- skip this record and do not create the corrections with the supplied school code and log the message.
1333: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');
1334: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1336: l_process_corr_flag := 'N'; -- Do not process Corrections
1337:

Line 1334: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);

1330:
1331: ELSIF (x_return_status = 'S') AND (NVL(x_fed_school_code,'X') <> p_school_code) THEN
1332: -- skip this record and do not create the corrections with the supplied school code and log the message.
1333: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');
1334: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1336: l_process_corr_flag := 'N'; -- Do not process Corrections
1337:
1338: ELSIF (x_return_status = 'S') AND (x_fed_school_code = p_school_code) THEN

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

1331: ELSIF (x_return_status = 'S') AND (NVL(x_fed_school_code,'X') <> p_school_code) THEN
1332: -- skip this record and do not create the corrections with the supplied school code and log the message.
1333: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');
1334: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1336: l_process_corr_flag := 'N'; -- Do not process Corrections
1337:
1338: ELSIF (x_return_status = 'S') AND (x_fed_school_code = p_school_code) THEN
1339: l_process_corr_flag := 'Y'; -- Process Corrections

Line 1346: FND_MESSAGE.SET_NAME('IGF', x_msg_data);

1342: */
1343:
1344: IF (x_return_status = 'E') THEN
1345: -- skip this record and do not create the corrections and log the message.
1346: FND_MESSAGE.SET_NAME('IGF', x_msg_data);
1347: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1348: l_process_corr_flag := 'N'; -- Do not process Corrections
1349:
1350: ELSIF (NVL(x_fed_school_code,'X') <> p_school_code) THEN

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

1343:
1344: IF (x_return_status = 'E') THEN
1345: -- skip this record and do not create the corrections and log the message.
1346: FND_MESSAGE.SET_NAME('IGF', x_msg_data);
1347: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1348: l_process_corr_flag := 'N'; -- Do not process Corrections
1349:
1350: ELSIF (NVL(x_fed_school_code,'X') <> p_school_code) THEN
1351: -- skip this record and do not create the corrections with the supplied school code and log the message.

Line 1352: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');

1348: l_process_corr_flag := 'N'; -- Do not process Corrections
1349:
1350: ELSIF (NVL(x_fed_school_code,'X') <> p_school_code) THEN
1351: -- skip this record and do not create the corrections with the supplied school code and log the message.
1352: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');
1353: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);
1354: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1355: l_process_corr_flag := 'N'; -- Do not process Corrections
1356:

Line 1353: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);

1349:
1350: ELSIF (NVL(x_fed_school_code,'X') <> p_school_code) THEN
1351: -- skip this record and do not create the corrections with the supplied school code and log the message.
1352: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');
1353: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);
1354: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1355: l_process_corr_flag := 'N'; -- Do not process Corrections
1356:
1357: ELSE

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

1350: ELSIF (NVL(x_fed_school_code,'X') <> p_school_code) THEN
1351: -- skip this record and do not create the corrections with the supplied school code and log the message.
1352: FND_MESSAGE.SET_NAME('IGF', 'IGF_AP_FEDSCH_NOT_CONTEXT');
1353: FND_MESSAGE.SET_TOKEN('PERSON_NUM',gv_person_number);
1354: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1355: l_process_corr_flag := 'N'; -- Do not process Corrections
1356:
1357: ELSE
1358: l_process_corr_flag := 'Y'; -- Process Corrections

Line 1371: fnd_message.set_name('IGF','IGF_AP_CORR_HOLD_EXIST');

1367:
1368: OPEN corr_hold;
1369: FETCH corr_hold INTO lc_corr_hold;
1370: IF corr_hold%FOUND THEN -- If Hold Exists check
1371: fnd_message.set_name('IGF','IGF_AP_CORR_HOLD_EXIST');
1372: fnd_message.set_token('PERSON_NUMBER',gv_person_number);
1373: fnd_file.put_line(fnd_file.log,fnd_message.get);
1374: ELSE -- No Hold so proceed with corrections
1375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1372: fnd_message.set_token('PERSON_NUMBER',gv_person_number);

1368: OPEN corr_hold;
1369: FETCH corr_hold INTO lc_corr_hold;
1370: IF corr_hold%FOUND THEN -- If Hold Exists check
1371: fnd_message.set_name('IGF','IGF_AP_CORR_HOLD_EXIST');
1372: fnd_message.set_token('PERSON_NUMBER',gv_person_number);
1373: fnd_file.put_line(fnd_file.log,fnd_message.get);
1374: ELSE -- No Hold so proceed with corrections
1375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_process_corrections.prepare_file.debug','Before calling fill_string ');

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

1369: FETCH corr_hold INTO lc_corr_hold;
1370: IF corr_hold%FOUND THEN -- If Hold Exists check
1371: fnd_message.set_name('IGF','IGF_AP_CORR_HOLD_EXIST');
1372: fnd_message.set_token('PERSON_NUMBER',gv_person_number);
1373: fnd_file.put_line(fnd_file.log,fnd_message.get);
1374: ELSE -- No Hold so proceed with corrections
1375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_process_corrections.prepare_file.debug','Before calling fill_string ');
1377: END IF;

Line 1431: fnd_message.set_name ('IGF','IGF_AP_NO_ISIR_FOR_BATCH');

1427: END IF;
1428: END IF;
1429: COMMIT;
1430: ELSE
1431: fnd_message.set_name ('IGF','IGF_AP_NO_ISIR_FOR_BATCH');
1432: fnd_file.put_line(fnd_file.log, fnd_message.get);
1433: END IF; /* end of if 1*/
1434: EXCEPTION
1435: WHEN OTHERS THEN

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

1428: END IF;
1429: COMMIT;
1430: ELSE
1431: fnd_message.set_name ('IGF','IGF_AP_NO_ISIR_FOR_BATCH');
1432: fnd_file.put_line(fnd_file.log, fnd_message.get);
1433: END IF; /* end of if 1*/
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: ROLLBACK;

Line 1441: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1437: retcode := 2;
1438: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1439: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.prepare_file.exception','The exception is : ' || SQLERRM );
1440: END IF;
1441: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1442: errbuf := fnd_message.get;
1443: fnd_file.put_line(fnd_file.log,SQLERRM);
1444: igs_ge_msg_stack.add;
1445: END prepare_file;

Line 1442: errbuf := fnd_message.get;

1438: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1439: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.prepare_file.exception','The exception is : ' || SQLERRM );
1440: END IF;
1441: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1442: errbuf := fnd_message.get;
1443: fnd_file.put_line(fnd_file.log,SQLERRM);
1444: igs_ge_msg_stack.add;
1445: END prepare_file;
1446: