DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_DELIVERY_DETAILS_PKG

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

2422: -- Need to lock the related entities - lines, containers and delivery legs
2423: -- For actions ship confirm and autopacking
2424: if p_action IN ('CONFIRM', 'AUTO-PACK', 'AUTO-PACK-MASTER') then
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
2427: END IF;
2428:
2429: wsh_delivery_details_pkg.lock_detail_no_compare(
2430: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);

Line 2429: wsh_delivery_details_pkg.lock_detail_no_compare(

2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_PKG.LOCK_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
2427: END IF;
2428:
2429: wsh_delivery_details_pkg.lock_detail_no_compare(
2430: p_delivery_id => p_rec_attr_tab(l_index).delivery_id);
2431:
2432: if p_action = 'CONFIRM' then
2433: IF l_debug_on THEN

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

2533: WHEN OTHERS THEN
2534: --
2535: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2536: --
2537: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_DELIVERY_WRAPPER',l_module_name);
2538: --
2539: IF l_debug_on THEN
2540: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');