99: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
100:
101: --
102: IF l_debug_on IS NULL THEN
103: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
104: END IF;
105:
106: --
107: --
107: --
108: -- Debug Statements
109: --
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.push(l_module_name);
112: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
113: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
114: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
115: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
108: -- Debug Statements
109: --
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.push(l_module_name);
112: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
113: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
114: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
115: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
116: END IF;
109: --
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.push(l_module_name);
112: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
113: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
114: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
115: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
116: END IF;
117:
110: IF l_debug_on THEN
111: WSH_DEBUG_SV.push(l_module_name);
112: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
113: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
114: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
115: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
116: END IF;
117:
118: --
111: WSH_DEBUG_SV.push(l_module_name);
112: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
113: WSH_DEBUG_SV.logmsg(l_module_name,'-------- INPUT PARAMETERS ------');
114: WSH_DEBUG_SV.log(l_module_name,'p_template_id',p_template_id);
115: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
116: END IF;
117:
118: --
119: -- Set the return flags for the start of the procedure
154: --
155: -- Debug Statements
156: --
157: IF l_debug_on THEN
158: WSH_DEBUG_SV.pop(l_module_name);
159: END IF;
160: --
161:
162: --
185: --
186: -- Debug Statements
187: --
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_UTIL_PKG.DELETE_FILES_LINES IS ' ||L_ERROR_TEXT );
190: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
192: END IF;
193: --
186: -- Debug Statements
187: --
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_UTIL_PKG.DELETE_FILES_LINES IS ' ||L_ERROR_TEXT );
190: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
192: END IF;
193: --
194: WSH_UTIL_CORE.default_handler('FTE_DIST_UTIL_PKG.DELETE_FILES_LINES');
187: --
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM FTE_DIST_UTIL_PKG.DELETE_FILES_LINES IS ' ||L_ERROR_TEXT );
190: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
192: END IF;
193: --
194: WSH_UTIL_CORE.default_handler('FTE_DIST_UTIL_PKG.DELETE_FILES_LINES');
195: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
197: --
198: -- Debug Statements
199: --
200: IF l_debug_on THEN
201: WSH_DEBUG_SV.pop(l_module_name);
202: END IF;
203: --
204: RETURN;
205: