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.IGS_HE_EXTRACT_PKG dependencies on FND_FILE

Line 36: Fnd_File.Put_Line(Fnd_File.Log, p_message);

32: PROCEDURE write_to_log(p_message IN VARCHAR2)
33: IS
34: BEGIN
35:
36: Fnd_File.Put_Line(Fnd_File.Log, p_message);
37:
38: END write_to_log;
39:
40: /*----------------------------------------------------------------------

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

1317: -- printing datetimestamp for monitoring performance
1318: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1319: fnd_message.set_token('PROCEDURE', 'GET_STUDENTS');
1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:
1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');
1324: fnd_file.put_line(fnd_file.log,fnd_message.get());
1325:

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

1320: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1321: fnd_file.put_line(fnd_file.log, fnd_message.get);
1322:
1323: fnd_message.set_name('IGS','IGS_HE_STD_RETURN');
1324: fnd_file.put_line(fnd_file.log,fnd_message.get());
1325:
1326: l_awd_min_dt := NULL;
1327: l_awd_max_dt := NULL;
1328:

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

1450: IF l_std_inst.person_id <> l_prev_person_id THEN
1451: fnd_message.set_name('IGS','IGS_HE_INVALID_PER_ID');
1452: fnd_Message.Set_Token('PERSON_ID_TYPE',alternate_id_rec.person_id_type);
1453: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1454: fnd_file.put_line(fnd_file.log,fnd_message.get());
1455: END IF;
1456:
1457: --In case the alternate person id contains non-numeric characters ,then log the message and
1458: -- exclude this record from furtehr processing

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

1466: IF l_std_inst.person_id <> l_prev_person_id THEN
1467: fnd_message.set_name('IGS','IGS_HE_PERSID_MORE_DIGITS');
1468: fnd_Message.Set_Token('PIDTYPE',alternate_id_rec.person_id_type);
1469: fnd_Message.Set_Token('PERSON',l_std_inst.person_number);
1470: fnd_file.put_line(fnd_file.log,fnd_message.get());
1471: END IF;
1472: --In case the alternate person id contains more than 8 digits ,then log the message and
1473: -- exclude this record from furtehr processing
1474: l_valid := FALSE ;

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

1909: -- printing datetimestamp for monitoring performance
1910: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
1911: fnd_message.set_token('PROCEDURE', 'GET_MODULES');
1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:
1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');
1916: fnd_file.put_line(fnd_file.log,fnd_message.get());
1917:

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

1912: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1913: fnd_file.put_line(fnd_file.log, fnd_message.get);
1914:
1915: fnd_message.set_name('IGS','IGS_HE_MOD_RETURN');
1916: fnd_file.put_line(fnd_file.log,fnd_message.get());
1917:
1918: FOR l_mod IN c_get_mod (g_he_ext_run_dtls.student_ext_run_id)
1919: LOOP
1920: g_records_found := TRUE;

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

2116: -- printing datetimestamp for monitoring performance
2117: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2118: fnd_message.set_token('PROCEDURE', 'GET_DLHE');
2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:
2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');
2123: fnd_file.put_line(fnd_file.log,fnd_message.get());
2124:

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

2119: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2120: fnd_file.put_line(fnd_file.log, fnd_message.get);
2121:
2122: fnd_message.set_name('IGS','IGS_HE_DLHE_RETURN');
2123: fnd_file.put_line(fnd_file.log,fnd_message.get());
2124:
2125: -- loop thru each dlhe record and validate dlhe_record_status
2126: FOR g_he_stdnt_dlhe IN c_get_dlhe ( g_he_ext_run_dtls.submission_name, g_he_ext_run_dtls.return_name,
2127: g_he_ext_run_dtls.user_return_subclass )

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

2223: -- printing datetimestamp for monitoring performance
2224: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2225: fnd_message.set_token('PROCEDURE', 'GET_MARKED_ROWS');
2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:
2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');
2230: fnd_file.put_line(fnd_file.log,fnd_message.get());
2231:

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

2226: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2227: fnd_file.put_line(fnd_file.log, fnd_message.get);
2228:
2229: fnd_message.set_name('IGS','IGS_HE_REC_RECAL');
2230: fnd_file.put_line(fnd_file.log,fnd_message.get());
2231:
2232:
2233: -- Delete from igs_he_ext_run_interim, if rows exist
2234: -- Replaced the procedure call which calls the TBH for deletion with direct DML for bug,3179585

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

2412: -- printing datetimestamp for monitoring performance
2413: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2414: fnd_message.set_token('PROCEDURE', 'EXTRACT_MAIN');
2415: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2416: fnd_file.put_line(fnd_file.log, fnd_message.get);
2417:
2418: -- Check if UCAS and HESA are enabled, ie country = UK
2419: IF NOT Igs_Uc_Utils.is_ucas_hesa_enabled
2420: THEN

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

2483: fnd_message.set_token('user_return_subclass',g_he_ext_run_dtls.user_return_subclass);
2484: fnd_message.set_token('return_name',g_he_ext_run_dtls.return_name);
2485: fnd_message.set_token('enrolment_start_date',g_he_submsn_header.enrolment_start_date);
2486: fnd_message.set_token('enrolment_end_date',g_he_submsn_header.enrolment_end_date);
2487: fnd_file.put_line(fnd_file.log,fnd_message.get());
2488:
2489:
2490: IF p_module_called_from = 'IGSHE008'
2491: THEN

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

2514: -- Therefore, delete all data that was created previously
2515: -- for the same run.
2516: -- Delete from igs_he_ext_run_interim
2517: fnd_message.set_name('IGS','IGS_HE_DELETE_REC');
2518: fnd_file.put_line(fnd_file.log,fnd_message.get());
2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');
2522: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

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

2519:
2520: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2521: fnd_message.set_token('PROCEDURE', 'START_DELETE_ROWS');
2522: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2523: fnd_file.put_line(fnd_file.log, fnd_message.get);
2524:
2525: -- Changed the logic to replace the call to procedure, delete_rows with the
2526: -- Direct DMLs to improve performance for bug,3179585
2527:

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

2539:
2540: fnd_message.set_name('IGS','IGS_HE_ST_PROC_TIME');
2541: fnd_message.set_token('PROCEDURE', 'END_DELETE_ROWS');
2542: fnd_message.set_token('TIMESTAMP',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2543: fnd_file.put_line(fnd_file.log, fnd_message.get);
2544:
2545: IF Substr(g_he_submsn_return.record_id,4,2) = '11'
2546: OR Substr(g_he_submsn_return.record_id,4,2) = '12'
2547: THEN

Line 2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2587:
2588: IF g_records_found
2589: THEN
2590: fnd_message.set_name('IGS','IGS_HE_VALID_STUD');
2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2592:
2593: fnd_message.set_name('IGS','IGS_HE_TEMP_REC');
2594: fnd_file.put_line(fnd_file.log,fnd_message.get());
2595:

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

2590: fnd_message.set_name('IGS','IGS_HE_VALID_STUD');
2591: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2592:
2593: fnd_message.set_name('IGS','IGS_HE_TEMP_REC');
2594: fnd_file.put_line(fnd_file.log,fnd_message.get());
2595:
2596: -- If records were found that need processing,
2597: -- call the next procedure to process these
2598: -- Transaction handling is done within this procedure

Line 2648: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2644: -- Commit Transaction
2645: COMMIT;
2646:
2647: fnd_message.set_name('IGS','IGS_HE_PROC_COMP');
2648: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2649:
2650: -- Submit the Extract Run Exception report.
2651: l_request_id := NULL ;
2652: l_request_id := Fnd_Request.Submit_Request

Line 2663: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2659: 'LINE');
2660:
2661:
2662: fnd_message.set_name('IGS','IGS_HE_REP_SUBM');
2663: fnd_file.put_line(fnd_file.log,fnd_message.get()|| ' - ' ||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2664:
2665: EXCEPTION
2666: WHEN IGS_HESA_NOT_ENABLED_EXCEP
2667: THEN