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_LOG

Line 13: || bkkumar 07-May-2004 Bug 3598933 Added the fnd logging messages

9: || igf_ap_fa_base_rec tables are updated to change the correction_status.
10: || Known limitations, enhancements or remarks :
11: || Change History :
12: || Who When What
13: || bkkumar 07-May-2004 Bug 3598933 Added the fnd logging messages
14: || veramach 29-Apr-2004 bug 3598067
15: || Changed gv_Trans_Data_Source_Or_Type's value to '1C' rather than 'IC'
16: || ugummall 31-OCT-2003 Bug 3102439. FA 126 - Multiple FA Offices.
17: || 1. Added 5 new parameters to prepare_file.

Line 195: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

191:
192: EXCEPTION
193:
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');

Line 196: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.blanks.exception','The exception is : ' || SQLERRM );

192: EXCEPTION
193:
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);

Line 305: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

301: END IF;
302:
303: EXCEPTION
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');

Line 306: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.create_header.exception','The exception is : ' || SQLERRM );

302:
303: EXCEPTION
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);

Line 387: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

383: END IF;
384:
385: EXCEPTION
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');

Line 388: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.create_trailer.exception','The exception is : ' || SQLERRM );

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

Line 563: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

559:
560: EXCEPTION
561:
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 );

Line 564: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.format_fields.exception','The exception is : ' || SQLERRM );

560: EXCEPTION
561:
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);

Line 600: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

596:
597: EXCEPTION
598:
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');

Line 601: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.start_record.exception','The exception is : ' || SQLERRM );

597: EXCEPTION
598:
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);

Line 639: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

635: v_newval;
636: EXCEPTION
637:
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');

Line 640: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.fill_string.exception','The exception is : ' || SQLERRM );

636: EXCEPTION
637:
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);

Line 700: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

696: gv_assum_override_6 := NVL(corr_isir_rec.assum_override_6,blanks(1));
697:
698: EXCEPTION
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' );

Line 701: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.compare_individual_override.exception','The exception is : ' || SQLERRM );

697:
698: EXCEPTION
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);

Line 946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

942: igs_ge_msg_stack.add;
943: app_exception.raise_exception;
944:
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');

Line 947: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.write_file.exception','The exception is : ' || SQLERRM );

943: app_exception.raise_exception;
944:
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);

Line 1159: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1155: CLOSE get_baserec;
1156:
1157: EXCEPTION
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');

Line 1160: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.update_corr.exception','The exception is : ' || SQLERRM );

1156:
1157: EXCEPTION
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);

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

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 );
1307: END IF;
1308:
1309:

Line 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 );

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 );
1307: END IF;
1308:
1309:
1310: -- Get baseid's (match_isirs's gn_baseid) associated org unit's federal school code.

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

1309:
1310: -- Get baseid's (match_isirs's gn_baseid) associated org unit's federal school code.
1311: igf_sl_gen.get_stu_fao_code(gn_baseid, 'FED_SCH_CD', x_fed_school_code, x_return_status, x_msg_data);
1312:
1313: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1314: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_process_corrections.prepare_file.debug','The x_fed_school_code returned : ' || x_fed_school_code );
1315: END IF;
1316:
1317: /* -- Commenting the code for future refference

Line 1314: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_process_corrections.prepare_file.debug','The x_fed_school_code returned : ' || x_fed_school_code );

1310: -- Get baseid's (match_isirs's gn_baseid) associated org unit's federal school code.
1311: igf_sl_gen.get_stu_fao_code(gn_baseid, 'FED_SCH_CD', x_fed_school_code, x_return_status, x_msg_data);
1312:
1313: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1314: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_process_corrections.prepare_file.debug','The x_fed_school_code returned : ' || x_fed_school_code );
1315: END IF;
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

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

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;
1378: gn_std_cnt := gn_std_cnt + 1;
1379: start_record;

Line 1376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_process_corrections.prepare_file.debug','Before calling fill_string ');

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;
1378: gn_std_cnt := gn_std_cnt + 1;
1379: start_record;
1380: l_corr_status := 'READY' ;

Line 1438: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: ROLLBACK;
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;

Line 1439: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_process_corrections.prepare_file.exception','The exception is : ' || SQLERRM );

1435: WHEN OTHERS THEN
1436: ROLLBACK;
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);