APPS.OKC_UTIL dependencies on UTL_FILE

Line 2523: UTL_FILE.FCLOSE(l_trace_file);

2519: --
2520: PROCEDURE close_trace_file
2521: IS
2522: BEGIN
2523: UTL_FILE.FCLOSE(l_trace_file);
2524:
2525: EXCEPTION
2526: WHEN OTHERS THEN
2527: OKC_API.set_message(p_app_name => g_app_name,

Line 2590: WHERE pa.name = 'utl_file_dir';

2586:
2587: SELECT pa.value
2588: INTO l_parameter_value
2589: FROM v$parameter pa
2590: WHERE pa.name = 'utl_file_dir';
2591:
2592: l_trace_path := get_trace_path (l_parameter_value);
2593:
2594: ---

Line 2598: l_trace_file := utl_file.fopen(l_trace_path, g_trc_trace_file_prefix

2594: ---
2595: --- The file mode must be opened in w mode in 7.3, otherwise in a mode
2596: ---
2597: BEGIN
2598: l_trace_file := utl_file.fopen(l_trace_path, g_trc_trace_file_prefix
2599: || TO_CHAR(l_process_id)
2600: || '_'
2601: || TO_CHAR(l_session_id)
2602: || g_trc_trace_file_suffix, 'a');

Line 2604: WHEN utl_file.invalid_mode THEN

2600: || '_'
2601: || TO_CHAR(l_session_id)
2602: || g_trc_trace_file_suffix, 'a');
2603: EXCEPTION
2604: WHEN utl_file.invalid_mode THEN
2605: l_trace_file := utl_file.fopen(l_trace_path, g_trc_trace_file_prefix
2606: || TO_CHAR(l_process_id)
2607: || '_'
2608: || TO_CHAR(l_session_id)

Line 2605: l_trace_file := utl_file.fopen(l_trace_path, g_trc_trace_file_prefix

2601: || TO_CHAR(l_session_id)
2602: || g_trc_trace_file_suffix, 'a');
2603: EXCEPTION
2604: WHEN utl_file.invalid_mode THEN
2605: l_trace_file := utl_file.fopen(l_trace_path, g_trc_trace_file_prefix
2606: || TO_CHAR(l_process_id)
2607: || '_'
2608: || TO_CHAR(l_session_id)
2609: || g_trc_trace_file_suffix, 'w');