APPS.AST_DEBUG_PUB dependencies on UTL_FILE

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

12: Begin
13:
14: if G_DIR is null then
15: select value INTO G_DIR
16: from v$PARAMETER where name = 'utl_file_dir';
17: if instr(G_DIR,',') > 0 then
18: G_DIR := substr(G_DIR,1,instr(G_DIR,',')-1);
19: end if;
20: END IF;

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

28: SELECT sid || '.AST' into G_FILE
29: FROM v$session
30: WHERE audsid = Userenv('SESSIONID');
31:
32: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'w');
33: else
34: G_FILE :=P_File;
35: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'a');
36: end if;

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

31:
32: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'w');
33: else
34: G_FILE :=P_File;
35: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'a');
36: end if;
37:
38: rtn_val := G_DIR || '/' || g_file;
39:

Line 62: utl_file.put_line(G_FILE_PTR, to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) || ' ' || debug_msg );

58:
59: if (G_Debug_Level >= debug_level) then
60: rtn_val:=OpenFile(G_FILE);
61: if print_date = 'Y' then
62: utl_file.put_line(G_FILE_PTR, to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) || ' ' || debug_msg );
63:
64: else
65: utl_file.put_line(G_FILE_PTR, ' ' ||debug_msg);
66: end if; --if print date is 'Y'

Line 65: utl_file.put_line(G_FILE_PTR, ' ' ||debug_msg);

61: if print_date = 'Y' then
62: utl_file.put_line(G_FILE_PTR, to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) || ' ' || debug_msg );
63:
64: else
65: utl_file.put_line(G_FILE_PTR, ' ' ||debug_msg);
66: end if; --if print date is 'Y'
67:
68: -- Write and close the file
69: utl_file.fflush(G_FILE_PTR);

Line 69: utl_file.fflush(G_FILE_PTR);

65: utl_file.put_line(G_FILE_PTR, ' ' ||debug_msg);
66: end if; --if print date is 'Y'
67:
68: -- Write and close the file
69: utl_file.fflush(G_FILE_PTR);
70: utl_file.fclose(G_FILE_PTR);
71:
72: end if;-- debug level is big enough
73:

Line 70: utl_file.fclose(G_FILE_PTR);

66: end if; --if print date is 'Y'
67:
68: -- Write and close the file
69: utl_file.fflush(G_FILE_PTR);
70: utl_file.fclose(G_FILE_PTR);
71:
72: end if;-- debug level is big enough
73:
74: Exception