DBA Data[Home] [Help]

APPS.WSH_ITM_POST_PROCESS_HANDLER dependencies on UTL_FILE

Line 206: l_file_ptr UTL_FILE.File_Type;

202: p_source VARCHAR2,
203: p_itm_log_level NUMBER,
204: p_log_filename VARCHAR2)
205: IS
206: l_file_ptr UTL_FILE.File_Type;
207: l_debug_process BOOLEAN;
208: l_log_directory VARCHAR2(4000);
209: BEGIN
210:

Line 215: l_file_ptr := UTL_FILE.Fopen(l_log_directory, p_log_filename, 'a');

211: --If ITM Log Severity is set to DEBUG then enable Shipping and OM Debugging
212: IF ( p_itm_log_level = '1' ) THEN -- {
213: BEGIN
214: fnd_profile.get('WSH_DEBUG_LOG_DIRECTORY',l_log_directory);
215: l_file_ptr := UTL_FILE.Fopen(l_log_directory, p_log_filename, 'a');
216: WSH_DEBUG_INTERFACE.Start_Debugger(
217: p_dir_name => l_log_directory,
218: p_file_name => p_log_filename,
219: p_file_handle => l_file_ptr );

Line 246: IF utl_file.is_open(l_file_ptr) THEN

242: --If ITM Log Severity is set to DEBUG then disable Shipping and OM Debugging
243: IF ( p_itm_log_level = '1' and l_debug_process ) THEN -- {
244: OE_DEBUG_PUB.Stop_ONT_Debugger;
245: WSH_DEBUG_INTERFACE.Stop_Debugger;
246: IF utl_file.is_open(l_file_ptr) THEN
247: utl_file.fclose(l_file_ptr);
248: END IF;
249: END IF; --}
250:

Line 247: utl_file.fclose(l_file_ptr);

243: IF ( p_itm_log_level = '1' and l_debug_process ) THEN -- {
244: OE_DEBUG_PUB.Stop_ONT_Debugger;
245: WSH_DEBUG_INTERFACE.Stop_Debugger;
246: IF utl_file.is_open(l_file_ptr) THEN
247: utl_file.fclose(l_file_ptr);
248: END IF;
249: END IF; --}
250:
251: EXCEPTION

Line 256: IF utl_file.is_open(l_file_ptr) THEN

252: WHEN OTHERS THEN
253: IF ( p_itm_log_level = '1' ) THEN -- {
254: OE_DEBUG_PUB.Stop_ONT_Debugger;
255: WSH_DEBUG_INTERFACE.Stop_Debugger;
256: IF utl_file.is_open(l_file_ptr) THEN
257: utl_file.fclose(l_file_ptr);
258: END IF;
259: END IF; --}
260:

Line 257: utl_file.fclose(l_file_ptr);

253: IF ( p_itm_log_level = '1' ) THEN -- {
254: OE_DEBUG_PUB.Stop_ONT_Debugger;
255: WSH_DEBUG_INTERFACE.Stop_Debugger;
256: IF utl_file.is_open(l_file_ptr) THEN
257: utl_file.fclose(l_file_ptr);
258: END IF;
259: END IF; --}
260:
261: END CHECK_PENDING_CALL_API;