DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_DELIVERY_DETAILS_PKG

Line 2406: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

2402: -- Need to lock the related entities - lines, containers and delivery legs
2403: -- For actions ship confirm and autopacking
2404: if p_action IN ('CONFIRM', 'AUTO-PACK', 'AUTO-PACK-MASTER') then
2405: IF l_debug_on THEN
2406: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
2407: END IF;
2408:
2409: wsh_delivery_details_pkg.lock_detail_no_compare(
2410: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);

Line 2409: wsh_delivery_details_pkg.lock_detail_no_compare(

2405: IF l_debug_on THEN
2406: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
2407: END IF;
2408:
2409: wsh_delivery_details_pkg.lock_detail_no_compare(
2410: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2411:
2412: if p_action = 'CONFIRM' then
2413: IF l_debug_on THEN

Line 2517: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);

2513: WHEN OTHERS THEN
2514: --
2515: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2516: --
2517: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);
2518: --
2519: IF l_debug_on THEN
2520: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2521: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');