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_PROCESS_CORRECTIONS dependencies on FND_FILE

Line 200: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
204: END blanks;

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 310: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
314: END create_header;

Line 392: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
396: END create_trailer;

Line 568: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
572: END format_fields;

Line 605: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
609: END start_record;

Line 644: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
648: END fill_string;

Line 705: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
709: END compare_individual_override;

Line 716: || Purpose : Uses Fnd_file utitlity to write header,data and trailer records

712: IS
713: /*
714: || Created By : Sridhar
715: || Created On : 25-NOV-2000
716: || Purpose : Uses Fnd_file utitlity to write header,data and trailer records
717: || into the flat file.Header and trailer records are written into
718: || file as they are constructed. But data records are formated here
719: || to fill in the last fields.
720: || Known limitations, enhancements or remarks :

Line 923: fnd_file.put_line(fnd_file.output,gv_corr_rec);

919: blanks(26); -- 580
920:
921: END IF;
922:
923: fnd_file.put_line(fnd_file.output,gv_corr_rec);
924:
925: ELSIF str_type = 'HEADER' THEN
926: create_header;
927:

Line 928: fnd_file.put_line(fnd_file.output,gv_header);

924:
925: ELSIF str_type = 'HEADER' THEN
926: create_header;
927:
928: fnd_file.put_line(fnd_file.output,gv_header);
929:
930:
931: ELSIF str_type = 'TRAILER' THEN
932: create_trailer;

Line 934: fnd_file.put_line(fnd_file.output,gv_trailer);

930:
931: ELSIF str_type = 'TRAILER' THEN
932: create_trailer;
933:
934: fnd_file.put_line(fnd_file.output,gv_trailer);
935:
936: END IF;
937:
938: EXCEPTION

Line 940: WHEN fnd_file.utl_file_error THEN

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

Line 951: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
955: END write_file;

Line 1164: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
1168: END update_corr;

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 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 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 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 1298: fnd_file.new_line(fnd_file.log,1);

1294: EXIT WHEN match_isirs%NOTFOUND;
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);

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 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 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 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 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 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 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 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 1443: fnd_file.put_line(fnd_file.log,SQLERRM);

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:
1447: END igf_ap_process_corrections;