155: --WSH_ITM_QUERY_CUSTOM.EDIT_CONDITION(p_Table,' AND WND.ORGANIZATION_ID = :b_org_id', ' AND WND.ORG_ID = :b_org_id', l_Item_Condn1Tab, 'NUMBER');
156: --Deleting a Condition
157: --WSH_ITM_QUERY_CUSTOM.DEL_CONDITION(p_Table, ' AND WND.ORGANIZATION_ID = :b_org_id');
158:
159: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
160:
161: IF l_debug_on THEN
162: WSH_DEBUG_SV.pop(l_module_name);
163: END IF;
165:
166:
167: EXCEPTION
168: WHEN Others THEN
169: wsh_util_core.default_handler('WSH_ITM_CUSTOMIZE.ALTER_DELIVERY_MARK');
170: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
171:
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
166:
167: EXCEPTION
168: WHEN Others THEN
169: wsh_util_core.default_handler('WSH_ITM_CUSTOMIZE.ALTER_DELIVERY_MARK');
170: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
171:
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
174: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');