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.GMD_COA_DATA_OM_NEW dependencies on UTL_FILE

Line 2307: LOG UTL_FILE.FILE_TYPE;

2303: -- #**************************************************************************/
2304: PROCEDURE Log_Initialize
2305: IS
2306:
2307: LOG UTL_FILE.FILE_TYPE;
2308: l_file_name VARCHAR2(10) := 'GMDLOG.txt';
2309:
2310: CURSOR c_get_1st_location IS
2311: SELECT NVL( SUBSTR( value, 1, INSTR( value, ',')-1), value)

Line 2313: WHERE name = 'utl_file_dir';

2309:
2310: CURSOR c_get_1st_location IS
2311: SELECT NVL( SUBSTR( value, 1, INSTR( value, ',')-1), value)
2312: FROM v$parameter
2313: WHERE name = 'utl_file_dir';
2314:
2315: BEGIN
2316:
2317: OPEN c_get_1st_location;

Line 2322: LOG := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'w');

2318: FETCH c_get_1st_location
2319: INTO g_gmdlog_location;
2320: CLOSE c_get_1st_location;
2321:
2322: LOG := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'w');
2323: UTL_FILE.put_line(LOG, 'Log file opened: '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2324: UTL_FILE.fflush(LOG);
2325: UTL_FILE.fclose(LOG);
2326:

Line 2323: UTL_FILE.put_line(LOG, 'Log file opened: '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2319: INTO g_gmdlog_location;
2320: CLOSE c_get_1st_location;
2321:
2322: LOG := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'w');
2323: UTL_FILE.put_line(LOG, 'Log file opened: '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2324: UTL_FILE.fflush(LOG);
2325: UTL_FILE.fclose(LOG);
2326:
2327: EXCEPTION

Line 2324: UTL_FILE.fflush(LOG);

2320: CLOSE c_get_1st_location;
2321:
2322: LOG := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'w');
2323: UTL_FILE.put_line(LOG, 'Log file opened: '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2324: UTL_FILE.fflush(LOG);
2325: UTL_FILE.fclose(LOG);
2326:
2327: EXCEPTION
2328: WHEN OTHERS THEN

Line 2325: UTL_FILE.fclose(LOG);

2321:
2322: LOG := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'w');
2323: UTL_FILE.put_line(LOG, 'Log file opened: '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2324: UTL_FILE.fflush(LOG);
2325: UTL_FILE.fclose(LOG);
2326:
2327: EXCEPTION
2328: WHEN OTHERS THEN
2329: NULL;

Line 2349: WHERE name = 'utl_file_dir';

2345:
2346: CURSOR get_log_file_location IS
2347: SELECT NVL( SUBSTR( value, 1, instr( value, ',')-1), value)
2348: FROM v$parameter
2349: WHERE name = 'utl_file_dir';
2350:
2351:
2352: l_log UTL_FILE.file_type;
2353: l_file_name VARCHAR2(80) := 'GMDLOG.txt';

Line 2352: l_log UTL_FILE.file_type;

2348: FROM v$parameter
2349: WHERE name = 'utl_file_dir';
2350:
2351:
2352: l_log UTL_FILE.file_type;
2353: l_file_name VARCHAR2(80) := 'GMDLOG.txt';
2354:
2355: BEGIN
2356:

Line 2363: l_log := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'a');

2359: FETCH get_log_file_location into gmd_coa_data_om_new.g_gmdlog_location;
2360: CLOSE get_log_file_location;
2361: END IF;
2362:
2363: l_log := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'a');
2364: IF UTL_FILE.IS_OPEN(l_log) THEN
2365: UTL_FILE.put_line(l_log, p_msg);
2366: UTL_FILE.fflush(l_log);
2367: UTL_FILE.fclose(l_log);

Line 2364: IF UTL_FILE.IS_OPEN(l_log) THEN

2360: CLOSE get_log_file_location;
2361: END IF;
2362:
2363: l_log := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'a');
2364: IF UTL_FILE.IS_OPEN(l_log) THEN
2365: UTL_FILE.put_line(l_log, p_msg);
2366: UTL_FILE.fflush(l_log);
2367: UTL_FILE.fclose(l_log);
2368: END IF;

Line 2365: UTL_FILE.put_line(l_log, p_msg);

2361: END IF;
2362:
2363: l_log := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'a');
2364: IF UTL_FILE.IS_OPEN(l_log) THEN
2365: UTL_FILE.put_line(l_log, p_msg);
2366: UTL_FILE.fflush(l_log);
2367: UTL_FILE.fclose(l_log);
2368: END IF;
2369:

Line 2366: UTL_FILE.fflush(l_log);

2362:
2363: l_log := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'a');
2364: IF UTL_FILE.IS_OPEN(l_log) THEN
2365: UTL_FILE.put_line(l_log, p_msg);
2366: UTL_FILE.fflush(l_log);
2367: UTL_FILE.fclose(l_log);
2368: END IF;
2369:
2370: EXCEPTION

Line 2367: UTL_FILE.fclose(l_log);

2363: l_log := UTL_FILE.fopen(g_gmdlog_location, l_file_name, 'a');
2364: IF UTL_FILE.IS_OPEN(l_log) THEN
2365: UTL_FILE.put_line(l_log, p_msg);
2366: UTL_FILE.fflush(l_log);
2367: UTL_FILE.fclose(l_log);
2368: END IF;
2369:
2370: EXCEPTION
2371: