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

Line 56: --fnd_file.put_line(fnd_file.log, m);

52: IS
53: -- for debug message logging
54: --g_debug_seq NUMBER:=0; --- #R1 Remove after debugging
55: BEGIN
56: --fnd_file.put_line(fnd_file.log, m);
57: --g_debug_seq := g_debug_seq + 1;
58: --INSERT INTO RAN_DEBUG values (g_debug_seq,m);
59: NULL;
60: END;

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

168: EXCEPTION
169: WHEN others THEN
170: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
171: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.L_IS_COR_FROM_SAME_SCHOOL');
172: fnd_file.put_line(fnd_file.log,SQLERRM);
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175:
176: END l_is_cor_from_same_school;

Line 279: fnd_file.put_line( fnd_file.LOG ,' ');

275:
276:
277: IF l_request_id > 0 THEN
278: -- successfully submitted then log message
279: fnd_file.put_line( fnd_file.LOG ,' ');
280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');
281: fnd_message.set_token('REQUEST_ID', l_request_id);
282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);

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

280: fnd_message.set_name('IGS','IGF_AP_SPAWN_REQ_SUBMIT');
281: fnd_message.set_token('REQUEST_ID', l_request_id);
282: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
283: fnd_message.set_token('TOTAL_RECS', p_sub_req_rec_cnt);
284: fnd_file.put_line(fnd_file.log,fnd_message.get);
285: ELSE
286: -- if error then log message
287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');
288: fnd_message.set_token('SPAWN_ID', p_sub_req_number);

Line 289: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

285: ELSE
286: -- if error then log message
287: fnd_message.set_name('IGS','IGF_AP_FAIL_SBMT_SPAWN_PROC');
288: fnd_message.set_token('SPAWN_ID', p_sub_req_number);
289: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
290: END IF;
291:
292: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
293: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.spawn_processes.debug','Launched spawned request ' || p_sub_req_number || ' Request ID : ' || l_request_id);

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

300: END IF;
301:
302: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
303: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.LAUNCH_SUB_REQUEST');
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: igs_ge_msg_stack.add;
306: RETURN; -- continue processing for the next sub request.
307: END launch_sub_request;
308:

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

482: END IF;
483:
484: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');
486: fnd_file.put_line(fnd_file.log,fnd_message.get);
487: fnd_file.put_line(fnd_file.log, SQLERRM);
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END validate_parameters;

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

483:
484: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
485: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_PARAMETERS');
486: fnd_file.put_line(fnd_file.log,fnd_message.get);
487: fnd_file.put_line(fnd_file.log, SQLERRM);
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END validate_parameters;
491:

Line 565: -- fnd_file.put_line(fnd_file.LOG, ' Dynamic Where Clause : ' || g_where);

561: IF g_school_code IS NOT NULL THEN
562: g_where := g_where || ' AND ' || '''' || g_school_code || '''' || ' IN (first_college_cd, second_college_cd, third_college_cd, fourth_college_cd, fifth_college_cd, sixth_college_cd) ';
563: END IF;
564:
565: -- fnd_file.put_line(fnd_file.LOG, ' Dynamic Where Clause : ' || g_where);
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.build_selection_criteria.debug', 'Successfully Completed build_selection_criteria procedure.');
568: END IF;
569:

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

574: END IF;
575:
576: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579: fnd_file.put_line(fnd_file.log, SQLERRM);
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;
582: END build_selection_criteria;

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

575:
576: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
577: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.BUILD_SELECTION_CRITERIA');
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579: fnd_file.put_line(fnd_file.log, SQLERRM);
580: igs_ge_msg_stack.add;
581: app_exception.raise_exception;
582: END build_selection_criteria;
583:

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

650: log_debug_message('EXCEPTION : ' || SQLERRM);
651:
652: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');
654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: fnd_file.put_line(fnd_file.log, SQLERRM);
656: igs_ge_msg_stack.add;
657: app_exception.raise_exception;
658: END query_isir_records;

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

651:
652: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
653: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.QUERY_ISIR_RECORDS');
654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: fnd_file.put_line(fnd_file.log, SQLERRM);
656: igs_ge_msg_stack.add;
657: app_exception.raise_exception;
658: END query_isir_records;
659:

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

778: log_debug_message(' EXCEPTION in spawn_processes : ' || SQLERRM);
779:
780: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
781: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SPAWN_PROCESSES');
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783: igs_ge_msg_stack.add;
784: app_exception.raise_exception;
785: END spawn_processes;
786:

Line 799: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');

795:
796: log_debug_message(' Beginning Main process at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
797:
798: -- print input parameters
799: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
800: fnd_message.set_name('IGF', 'IGF_AP_AWD_YR');
801: fnd_message.set_token('AWD_YEAR', p_award_year);
802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:

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

798: -- print input parameters
799: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
800: fnd_message.set_name('IGF', 'IGF_AP_AWD_YR');
801: fnd_message.set_token('AWD_YEAR', p_award_year);
802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

802: fnd_file.put_line(fnd_file.log, fnd_message.get);
803:
804: fnd_message.set_name('IGF', 'IGF_AP_CREATE_PRSN_NO_MATCH');
805: fnd_message.set_token('CREATE_PRSN', p_force_add);
806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

806: fnd_file.put_line(fnd_file.log, fnd_message.get);
807:
808: fnd_message.set_name('IGF', 'IGF_AP_CREATE_ADM_INQ');
809: fnd_message.set_token('CREATE_INQ', p_create_inquiry);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811:
812: fnd_message.set_name('IGF', 'IGF_AP_ADM_INQ_MTHD');
813: fnd_message.set_token('INQ_METHOD', p_adm_source_type);
814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

814: fnd_file.put_line(fnd_file.log, fnd_message.get);
815:
816: fnd_message.set_name('IGF', 'IGF_AP_MATCH_CODE');
817: fnd_message.set_token('MATCH_CODE', p_match_code);
818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

818: fnd_file.put_line(fnd_file.log, fnd_message.get);
819:
820: fnd_message.set_name('IGF', 'IGF_AP_REC_TYPE');
821: fnd_message.set_token('REC_TYPE', p_rec_type);
822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

822: fnd_file.put_line(fnd_file.log, fnd_message.get);
823:
824: fnd_message.set_name('IGF', 'IGF_AP_REC_STAT');
825: fnd_message.set_token('REC_STATUS', p_rec_status);
826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

826: fnd_file.put_line(fnd_file.log, fnd_message.get);
827:
828: fnd_message.set_name('IGF', 'IGF_AP_MSG_CLASS');
829: fnd_message.set_token('MSG_CLASS', p_message_class);
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: fnd_message.set_name('IGF', 'IGF_AP_SCHOOL_CD');
833: fnd_message.set_token('SCHOOL_CD', p_school_code);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835:
836: fnd_message.set_name('IGF', 'IGF_AP_SPAWN_REQ');
837: fnd_message.set_token('SPAWN_CNT', p_spawn_process);
838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

838: fnd_file.put_line(fnd_file.log, fnd_message.get);
839:
840: fnd_message.set_name('IGF', 'IGF_AP_DEL_INT_RECORD');
841: fnd_message.set_token('DEL_FLAG', p_del_int);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
846: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843:
844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
846: fnd_file.put_line(fnd_file.log, fnd_message.get);
847:
848: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
849:
850: errbuf := NULL;

Line 848: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');

844: fnd_message.set_name('IGF', 'IGF_AP_UPD_ANT_DATA');
845: fnd_message.set_token('UPD_ANT', p_upd_ant_val);
846: fnd_file.put_line(fnd_file.log, fnd_message.get);
847:
848: fnd_file.put_line(fnd_file.log, '-----------------------------------------------------------------------------------------');
849:
850: errbuf := NULL;
851: retcode := 0;
852: l_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));

Line 890: fnd_file.put_line(fnd_file.log, errbuf);

886:
887: IF l_batch.batch_year IS NULL THEN
888: fnd_message.set_name('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
889: errbuf := fnd_message.get;
890: fnd_file.put_line(fnd_file.log, errbuf);
891: RETCODE := 2;
892: RETURN;
893: END IF;
894: g_batch_year := l_batch.batch_year;

Line 903: fnd_file.put_line(fnd_file.log,errbuf);

899:
900: IF LTRIM(RTRIM(p_create_inquiry)) = 'Y' AND LTRIM(RTRIM(p_adm_source_type)) IS NULL THEN
901: fnd_message.set_name('IGF', 'IGF_AP_SOURCE_TYPE_REQ');
902: errbuf := fnd_message.get;
903: fnd_file.put_line(fnd_file.log,errbuf);
904: retcode := 2;
905: RETURN;
906: END IF;
907:

Line 929: fnd_file.put_line(fnd_file.log, errbuf);

925: -- Check whether any records found for processing for the query
926: IF g_total_recs_fetched = 0 THEN
927: fnd_message.set_name ('IGF','IGF_AP_MATCHING_REC_NT_FND');
928: errbuf := fnd_message.get;
929: fnd_file.put_line(fnd_file.log, errbuf);
930: retcode := 1;
931: RETURN;
932: END IF;
933:

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

963: ROLLBACK;
964: retcode := 2;
965: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
966: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.MAIN_IMPORT_PROCESS');
967: fnd_file.put_line(fnd_file.log,SQLERRM);
968: errbuf := fnd_message.get;
969: igs_ge_msg_stack.conc_exception_hndl;
970: END main_import_process;
971:

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

1313: igf_gr_gen.update_current_ssn(cur_ISIR_rec.base_id,cur_ISIR_rec.current_ssn,p_c_message);
1314:
1315: IF p_c_message = 'IGF_GR_UPDT_SSN_FAIL' THEN
1316: fnd_message.set_name ('IGF',p_c_message);
1317: fnd_file.put_line(fnd_file.log,fnd_message.get);
1318: END IF;
1319: END LOOP;
1320: END IF;
1321:

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

1322: EXCEPTION
1323: WHEN others THEN
1324: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1325: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_MATCHED_ISIR');
1326: fnd_file.put_line(fnd_file.log,SQLERRM);
1327: igs_ge_msg_stack.add;
1328: app_exception.raise_exception;
1329: END update_matched_ISIR;
1330:

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

1495:
1496: WHEN others THEN
1497: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1498: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_FABASE');
1499: fnd_file.put_line(fnd_file.log,SQLERRM);
1500: igs_ge_msg_stack.add;
1501: app_exception.raise_exception;
1502:
1503: END update_fabase;

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

1544: EXCEPTION
1545: WHEN others THEN
1546: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1547: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.UPDATE_ISIR_CORR');
1548: fnd_file.put_line(fnd_file.log,SQLERRM);
1549: igs_ge_msg_stack.add;
1550: app_exception.raise_exception;
1551: END update_ISIR_corr;
1552:

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

1634: x_correction_status => 'ACKNOWLEDGED') THEN
1635: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'ACKNOWLEDGED');
1636: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_ACK');
1637: fnd_message.set_token('FIELD', lv_column_meaning);
1638: fnd_file.put_line(fnd_file.log,fnd_message.get);
1639: END IF;
1640:
1641: ELSE
1642: IF NOT igf_ap_ISIR_corr_pkg.get_uk_for_validation ( x_ISIR_id => rec_ISIR_corr.ISIR_id,

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

1645: update_ISIR_corr (rec_ISIR_corr.ISIRc_id, 'READY');
1646: ln_count_corr := ln_count_corr + 1;
1647: fnd_message.set_name('IGF','IGF_AP_ISIR_CORR_READY');
1648: fnd_message.set_token('FIELD', lv_column_meaning);
1649: fnd_file.put_line(fnd_file.log,fnd_message.get);
1650: END IF;
1651: END IF;
1652: END LOOP;
1653:

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

1665: EXCEPTION
1666: WHEN others THEN
1667: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1668: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.VALIDATE_CORRECTIONS');
1669: fnd_file.put_line(fnd_file.log,SQLERRM);
1670: igs_ge_msg_stack.add;
1671: app_exception.raise_exception;
1672: END validate_corrections;
1673:

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

1712: EXCEPTION
1713: WHEN others THEN
1714: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1715: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.PREPARE_MESSAGE');
1716: fnd_file.put_line(fnd_file.log,SQLERRM);
1717: igs_ge_msg_stack.add;
1718: app_exception.raise_exception;
1719: END prepare_message;
1720:

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

1827: EXCEPTION
1828: WHEN others THEN
1829: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1830: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.CREATE_MESSAGE');
1831: fnd_file.put_line(fnd_file.log,SQLERRM);
1832: igs_ge_msg_stack.add;
1833: app_exception.raise_exception;
1834: END create_message;
1835:

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

1908: EXCEPTION
1909: WHEN others THEN
1910: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1911: fnd_message.set_token('NAME','IGF_AP_ISIR_IMPORT_PKG.SEND_MESSAGE');
1912: fnd_file.put_line(fnd_file.log,SQLERRM);
1913: igs_ge_msg_stack.add;
1914: app_exception.raise_exception;
1915: END send_message;
1916: