APPS.IEX_DEBUG_PUB dependencies on UTL_FILE

Line 21: from v$PARAMETER where name = 'utl_file_dir';

17: Begin
18:
19: if G_DIR is null then
20: select value INTO G_DIR
21: from v$PARAMETER where name = 'utl_file_dir';
22: if instr(G_DIR,',') > 0 then
23: G_DIR := substr(G_DIR,1,instr(G_DIR,',')-1);
24: end if;
25: END IF;

Line 36: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'w');

32:
33: SELECT DB_NAME || USERENV('SESSIONID') || '.IEX' into G_FILE
34: FROM DUAL;
35:
36: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'w');
37: else
38: G_FILE :=P_File;
39: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'a');
40: end if;

Line 39: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'a');

35:
36: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'w');
37: else
38: G_FILE :=P_File;
39: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'a');
40: end if;
41:
42: rtn_val := G_DIR || '/' || g_file;
43:

Line 78: utl_file.put_line(G_FILE_PTR,

74:
75: --jsanju , write to file for bug 3796601
76: if (G_Debug_Level <= debug_level) then
77: rtn_val:=OpenFile(G_FILE);
78: utl_file.put_line(G_FILE_PTR,
79: to_char( sysdate, 'DD-MON-YYYY HH:MI:SS') || ' ' || debug_msg );
80: utl_file.fflush(G_FILE_PTR);
81: utl_file.fclose(G_FILE_PTR);
82: end if;

Line 80: utl_file.fflush(G_FILE_PTR);

76: if (G_Debug_Level <= debug_level) then
77: rtn_val:=OpenFile(G_FILE);
78: utl_file.put_line(G_FILE_PTR,
79: to_char( sysdate, 'DD-MON-YYYY HH:MI:SS') || ' ' || debug_msg );
80: utl_file.fflush(G_FILE_PTR);
81: utl_file.fclose(G_FILE_PTR);
82: end if;
83:
84:

Line 81: utl_file.fclose(G_FILE_PTR);

77: rtn_val:=OpenFile(G_FILE);
78: utl_file.put_line(G_FILE_PTR,
79: to_char( sysdate, 'DD-MON-YYYY HH:MI:SS') || ' ' || debug_msg );
80: utl_file.fflush(G_FILE_PTR);
81: utl_file.fclose(G_FILE_PTR);
82: end if;
83:
84:
85: