DBA Data[Home] [Help]

APPS.ASO_DEBUG_PUB dependencies on UTL_FILE

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

27: || lpad(l_dbgfile_number,6,'0'),1,8)
28: || fnd_global.user_name
29: || '.dbg';
30:
31: G_FILE_PTR := utl_file.fopen(G_DIR, G_FILE, 'a');
32: oe_debug_pub.G_FILE_PTR := G_FILE_PTR;
33: end if;
34: rtn_val := G_DIR || '/' || g_file;
35: elsif P_MODE = 'CONC' then

Line 141: utl_file.put_line(G_FILE_PTR, 'Hello Sir, U have Opened a New Session');

137: -- I could not test this, But this is the problem. This should be set after
138: -- set_debug_mode call, other G_FILE will be null
139: OE_DEBUG_PUB.G_DIR := ASO_DEBUG_PUB.G_DIR;
140: OE_DEBUG_PUB.G_FILE := ASO_DEBUG_PUB.G_FILE;
141: utl_file.put_line(G_FILE_PTR, 'Hello Sir, U have Opened a New Session');
142: else
143: ASO_DEBUG_PUB.G_FILE := 'OFF';
144: return;
145: end if;

Line 175: utl_file.put_line(G_FILE_PTR, debug_msg);

171: G_Debug_count := G_debug_count + 1;
172: G_Debug_tbl(G_debug_count) := substr(debug_msg,1,G_DEBUG_LEN);
173: FND_FILE.put_line(FND_FILE.LOG, debug_msg);
174: if G_FILE is not null then
175: utl_file.put_line(G_FILE_PTR, debug_msg);
176: utl_file.fflush(G_FILE_PTR);
177: end if;
178: else -- debug mode
179: if print_date = 'Y' then

Line 176: utl_file.fflush(G_FILE_PTR);

172: G_Debug_tbl(G_debug_count) := substr(debug_msg,1,G_DEBUG_LEN);
173: FND_FILE.put_line(FND_FILE.LOG, debug_msg);
174: if G_FILE is not null then
175: utl_file.put_line(G_FILE_PTR, debug_msg);
176: utl_file.fflush(G_FILE_PTR);
177: end if;
178: else -- debug mode
179: if print_date = 'Y' then
180: --utl_file.put_line(G_FILE_PTR, debug_msg ||' ' || to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) );

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

176: utl_file.fflush(G_FILE_PTR);
177: end if;
178: else -- debug mode
179: if print_date = 'Y' then
180: --utl_file.put_line(G_FILE_PTR, debug_msg ||' ' || to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) );
181: utl_file.put_line(G_FILE_PTR, to_char( sysdate,'DD-MON-YYYY HH:MI:SS') || ' ASO ' || debug_msg );
182: utl_file.fflush(G_FILE_PTR);
183: else
184: --utl_file.put_line(G_FILE_PTR, debug_msg);

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

177: end if;
178: else -- debug mode
179: if print_date = 'Y' then
180: --utl_file.put_line(G_FILE_PTR, debug_msg ||' ' || to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) );
181: utl_file.put_line(G_FILE_PTR, to_char( sysdate,'DD-MON-YYYY HH:MI:SS') || ' ASO ' || debug_msg );
182: utl_file.fflush(G_FILE_PTR);
183: else
184: --utl_file.put_line(G_FILE_PTR, debug_msg);
185: utl_file.put_line(G_FILE_PTR, 'ASO ' || debug_msg );

Line 182: utl_file.fflush(G_FILE_PTR);

178: else -- debug mode
179: if print_date = 'Y' then
180: --utl_file.put_line(G_FILE_PTR, debug_msg ||' ' || to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) );
181: utl_file.put_line(G_FILE_PTR, to_char( sysdate,'DD-MON-YYYY HH:MI:SS') || ' ASO ' || debug_msg );
182: utl_file.fflush(G_FILE_PTR);
183: else
184: --utl_file.put_line(G_FILE_PTR, debug_msg);
185: utl_file.put_line(G_FILE_PTR, 'ASO ' || debug_msg );
186: utl_file.fflush(G_FILE_PTR);

Line 184: --utl_file.put_line(G_FILE_PTR, debug_msg);

180: --utl_file.put_line(G_FILE_PTR, debug_msg ||' ' || to_char( sysdate, 'DD-MON-YYYY HH:MI:SS' ) );
181: utl_file.put_line(G_FILE_PTR, to_char( sysdate,'DD-MON-YYYY HH:MI:SS') || ' ASO ' || debug_msg );
182: utl_file.fflush(G_FILE_PTR);
183: else
184: --utl_file.put_line(G_FILE_PTR, debug_msg);
185: utl_file.put_line(G_FILE_PTR, 'ASO ' || debug_msg );
186: utl_file.fflush(G_FILE_PTR);
187: end if;
188: end if;

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

181: utl_file.put_line(G_FILE_PTR, to_char( sysdate,'DD-MON-YYYY HH:MI:SS') || ' ASO ' || debug_msg );
182: utl_file.fflush(G_FILE_PTR);
183: else
184: --utl_file.put_line(G_FILE_PTR, debug_msg);
185: utl_file.put_line(G_FILE_PTR, 'ASO ' || debug_msg );
186: utl_file.fflush(G_FILE_PTR);
187: end if;
188: end if;
189: end if; -- debug_msg is not null

Line 186: utl_file.fflush(G_FILE_PTR);

182: utl_file.fflush(G_FILE_PTR);
183: else
184: --utl_file.put_line(G_FILE_PTR, debug_msg);
185: utl_file.put_line(G_FILE_PTR, 'ASO ' || debug_msg );
186: utl_file.fflush(G_FILE_PTR);
187: end if;
188: end if;
189: end if; -- debug_msg is not null
190: end if; -- debug on

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

300: ASO_DEBUG_PUB.Debug_off;
301: ASO_DEBUG_PUB.G_FILE := null;
302: OE_DEBUG_PUB.Debug_off;
303: OE_DEBUG_PUB.G_FILE := null;
304: If utl_file.is_Open(ASO_DEBUG_PUB.G_FILE_PTR) Then
305: utl_file.fclose(ASO_DEBUG_PUB.G_FILE_PTR);
306: End If;
307: exception
308: When Others Then

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

301: ASO_DEBUG_PUB.G_FILE := null;
302: OE_DEBUG_PUB.Debug_off;
303: OE_DEBUG_PUB.G_FILE := null;
304: If utl_file.is_Open(ASO_DEBUG_PUB.G_FILE_PTR) Then
305: utl_file.fclose(ASO_DEBUG_PUB.G_FILE_PTR);
306: End If;
307: exception
308: When Others Then
309: null;