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 IGF_AP_PROCESS_CORRECTIONS

Line 1: PACKAGE BODY igf_ap_process_corrections AS

1: PACKAGE BODY igf_ap_process_corrections AS
2: /* $Header: IGFAP02B.pls 120.8 2006/04/17 00:09:56 hkodali ship $ */
3:
4: /*
5: || Created By : Sridhar

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

Line 1447: END igf_ap_process_corrections;

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;