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 144: utl_file.put_line(G_FILE_PTR, 'Hello Sir, U have Opened a New Session');

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

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

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

Line 179: utl_file.fflush(G_FILE_PTR);

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

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

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

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

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

Line 185: utl_file.fflush(G_FILE_PTR);

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

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

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

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

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

Line 189: utl_file.fflush(G_FILE_PTR);

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

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

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

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

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