APPS.WSH_UTIL dependencies on UTL_FILE

Line 17: log_file_handle UTL_FILE.FILE_TYPE;

13: debug_flag VARCHAR2(1) := 'N';
14: debug_level NUMBER := 0;
15: flush VARCHAR2(1) := 'N';
16: source VARCHAR2(1) := 'u';
17: log_file_handle UTL_FILE.FILE_TYPE;
18: log_file_name VARCHAR2(20);
19: file_location VARCHAR2(20) := '/home/rshivram/temp';
20: last_flush_record NUMBER := 1;
21:

Line 69: log_file_handle := UTL_FILE.FOPEN(file_location, log_file_name, 'w');

65: log_file_name := 'l' || today || '.req';
66: ELSE
67: log_file_name := 'l' || to_char(request_id) || '.req';
68: END IF;
69: log_file_handle := UTL_FILE.FOPEN(file_location, log_file_name, 'w');
70: END Open_File;
71:
72: --
73: -- This function returns 'u' if called from form etc or 'c' for

Line 295: UTL_FILE.PUT_LINE(log_file_handle, buffer);

291: END IF;
292: END IF;
293: FOR i IN current_line..log_buffer.COUNT LOOP
294: buffer := log_buffer(i).text_line;
295: UTL_FILE.PUT_LINE(log_file_handle, buffer);
296: END LOOP;
297: last_flush_record := log_buffer.COUNT - 1;
298: IF p_close = 'Y' THEN
299: UTL_FILE.FCLOSE(log_file_handle);

Line 299: UTL_FILE.FCLOSE(log_file_handle);

295: UTL_FILE.PUT_LINE(log_file_handle, buffer);
296: END LOOP;
297: last_flush_record := log_buffer.COUNT - 1;
298: IF p_close = 'Y' THEN
299: UTL_FILE.FCLOSE(log_file_handle);
300: END IF;
301: END IF;
302: RETURN SUCCESS;
303: