DBA Data[Home] [Help]

APPS.IBE_UTIL dependencies on UTL_FILE

Line 78: l_file_type utl_file.file_type;

74: -- Private Variables
75: -------------------------------------------------------------------------
76: l_file_name VARCHAR2(100) := NULL;
77: l_path_name VARCHAR2(100) := NULL;
78: l_file_type utl_file.file_type;
79: l_debug_flag boolean := false;
80:
81: procedure file_debug(p_line in varchar2) IS
82:

Line 85: utl_file.put_line(l_file_type, p_line);

81: procedure file_debug(p_line in varchar2) IS
82:
83: begin
84: if (l_file_name is not null) THEN
85: utl_file.put_line(l_file_type, p_line);
86: utl_file.fflush(l_file_type);
87: end if;
88: end file_debug;
89:

Line 86: utl_file.fflush(l_file_type);

82:
83: begin
84: if (l_file_name is not null) THEN
85: utl_file.put_line(l_file_type, p_line);
86: utl_file.fflush(l_file_type);
87: end if;
88: end file_debug;
89:
90: procedure enable_file_debug(p_path_name in varchar2,

Line 95: l_file_type := utl_file.fopen(p_path_name, p_file_name, 'a');

91: p_file_name in varchar2) IS
92: begin
93:
94: if (l_file_name is null) THEN
95: l_file_type := utl_file.fopen(p_path_name, p_file_name, 'a');
96: l_file_name := p_file_name;
97: l_path_name := p_path_name;
98: end if;
99:

Line 101: when utl_file.invalid_path then

97: l_path_name := p_path_name;
98: end if;
99:
100: exception
101: when utl_file.invalid_path then
102: app_exception.raise_exception;
103: when utl_file.invalid_mode then
104: app_exception.raise_exception;
105:

Line 103: when utl_file.invalid_mode then

99:
100: exception
101: when utl_file.invalid_path then
102: app_exception.raise_exception;
103: when utl_file.invalid_mode then
104: app_exception.raise_exception;
105:
106: end ;
107:

Line 111: utl_file.fclose(l_file_type);

107:
108: procedure disable_file_debug is
109: begin
110: if (l_file_name is not null) THEN
111: utl_file.fclose(l_file_type);
112: end if;
113: end;
114:
115: procedure debug(p_line in varchar2 ) is

Line 128: -- utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||'IBE IBE_UTIL:Using New Debugging');

124: - achalana 07/29
125: **/
126: -- If fnd_profile.value_specific('IBE_DEBUG',FND_GLOBAL.USER_ID,null,null) = 'Y' Then
127: If IBE_UTIL.G_DEBUGON = FND_API.G_TRUE Then
128: -- utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||'IBE IBE_UTIL:Using New Debugging');
129: enable_debug_pvt();
130: x_rest := p_line;
131: loop
132: if (x_rest is null) then

Line 137: utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, debug_msg);

133: exit;
134: else
135: --OE_DEBUG_PUB.ADD(to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' '||substr(x_rest,1,255));
136: debug_msg := to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' IBE '||substr(x_rest,1,255);
137: utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, debug_msg);
138: utl_file.fflush(ASO_DEBUG_PUB.G_FILE_PTR);
139: x_rest := substr(x_rest,256);
140: end if;
141: end loop;

Line 138: utl_file.fflush(ASO_DEBUG_PUB.G_FILE_PTR);

134: else
135: --OE_DEBUG_PUB.ADD(to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' '||substr(x_rest,1,255));
136: debug_msg := to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' IBE '||substr(x_rest,1,255);
137: utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, debug_msg);
138: utl_file.fflush(ASO_DEBUG_PUB.G_FILE_PTR);
139: x_rest := substr(x_rest,256);
140: end if;
141: end loop;
142:

Line 159: utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, debug_msg);

155: exit;
156: else
157: --OE_DEBUG_PUB.ADD(to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' '||substr(x_rest,1,255));
158: debug_msg := to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' IBE '||substr(x_rest,1,255);
159: utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, debug_msg);
160: utl_file.fflush(ASO_DEBUG_PUB.G_FILE_PTR);
161: x_rest := substr(x_rest,256);
162: end if;
163: end loop;

Line 160: utl_file.fflush(ASO_DEBUG_PUB.G_FILE_PTR);

156: else
157: --OE_DEBUG_PUB.ADD(to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' '||substr(x_rest,1,255));
158: debug_msg := to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS')||' IBE '||substr(x_rest,1,255);
159: utl_file.put_line(ASO_DEBUG_PUB.G_FILE_PTR, debug_msg);
160: utl_file.fflush(ASO_DEBUG_PUB.G_FILE_PTR);
161: x_rest := substr(x_rest,256);
162: end if;
163: end loop;
164: End If;

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

216:
217: IF (ASO_DEBUG_PUB.G_FILE is NULL OR ASO_DEBUG_PUB.G_FILE <> 'IBE_'||FND_GLOBAL.USER_NAME||'.log') Then
218: ASO_DEBUG_PUB.G_DEBUG_MODE := 'FILE';
219: ASO_DEBUG_PUB.G_FILE := 'IBE_'||FND_GLOBAL.USER_NAME||'.log';
220: ASO_DEBUG_PUB.G_FILE_PTR := utl_file.fopen(ASO_DEBUG_PUB.G_DIR,ASO_DEBUG_PUB.G_FILE,'a');
221: ASO_DEBUG_PUB.debug_on;
222: ASO_DEBUG_PUB.setdebuglevel(ASO_DEBUG_PUB.G_DEBUG_LEVEL);
223: /* Setting OM Debug variables on */
224: OE_DEBUG_PUB.G_DEBUG_MODE := 'FILE';

Line 258: If utl_file.is_Open(ASO_DEBUG_PUB.G_FILE_PTR) Then

254: ASO_DEBUG_PUB.Debug_off;
255: ASO_DEBUG_PUB.G_FILE := null;
256: OE_DEBUG_PUB.Debug_off;
257: OE_DEBUG_PUB.G_FILE := null;
258: If utl_file.is_Open(ASO_DEBUG_PUB.G_FILE_PTR) Then
259: utl_file.fclose(ASO_DEBUG_PUB.G_FILE_PTR);
260: End If;
261: exception
262: When Others Then

Line 259: utl_file.fclose(ASO_DEBUG_PUB.G_FILE_PTR);

255: ASO_DEBUG_PUB.G_FILE := null;
256: OE_DEBUG_PUB.Debug_off;
257: OE_DEBUG_PUB.G_FILE := null;
258: If utl_file.is_Open(ASO_DEBUG_PUB.G_FILE_PTR) Then
259: utl_file.fclose(ASO_DEBUG_PUB.G_FILE_PTR);
260: End If;
261: exception
262: When Others Then
263: null;