88:
89: IF ((p_template_id = 0) OR
90: (p_template_id is null)) THEN
91: x_return_message := null;
92: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
93: RETURN;
94: END IF;
95:
96: --
118: --
119: -- Set the return flags for the start of the procedure
120: --
121: x_return_message := null;
122: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
123:
124:
125: IF (p_template_id is not null) THEN
126: --
162: --
163: -- Everything was OK
164: --
165: x_return_message := null;
166: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
167:
168: --
169: -- Lets go home
170: --
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;
196: x_return_message := l_error_text;
197: --
198: -- Debug Statements
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;
196: x_return_message := l_error_text;
197: --
198: -- Debug Statements
199: --