692: -- detail lines with zeqo qty so that WMS deletes the replenishment record.
693: IF (old_delivery_detail_rec.replenishment_status = 'R' and old_delivery_detail_rec.released_status in ('R','B')) THEN
694: --{
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
697: END IF;
698: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
699: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
700: p_primary_quantity => 0, --- WMS will delete the records from replenishment table.
694: --{
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
697: END IF;
698: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
699: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
700: p_primary_quantity => 0, --- WMS will delete the records from replenishment table.
701: x_return_status => x_return_status);
702: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
701: x_return_status => x_return_status);
702: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
703: --{
704: IF l_debug_on THEN
705: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
706: WSH_DEBUG_SV.pop(l_module_name);
707: END IF;
708: RETURN;
709: --}
2636: -- delivery detail lines to decrease the qty from replenishment tables.
2637: IF (p_replenishment_status = 'R' and p_released_status in ('R','B')) THEN
2638: --{
2639: IF l_debug_on THEN
2640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2641: END IF;
2642: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
2643: p_delivery_detail_id => p_delivery_detail_id,
2644: p_primary_quantity => (p_requested_quantity - ABS(p_changed_detail_quantity)),
2638: --{
2639: IF l_debug_on THEN
2640: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2641: END IF;
2642: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
2643: p_delivery_detail_id => p_delivery_detail_id,
2644: p_primary_quantity => (p_requested_quantity - ABS(p_changed_detail_quantity)),
2645: x_return_status => x_return_status);
2646: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2645: x_return_status => x_return_status);
2646: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2647: --{
2648: IF l_debug_on THEN
2649: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
2650: WSH_DEBUG_SV.pop(l_module_name);
2651: END IF;
2652: RETURN;
2653: --}
2888: -- detail lines with zeqo qty so that WMS deletes the replenishment record.
2889: IF (p_replenishment_status = 'R' and p_released_status in ('R','B')) THEN
2890: --{
2891: IF l_debug_on THEN
2892: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2893: END IF;
2894: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
2895: p_delivery_detail_id => p_delivery_detail_id,
2896: p_primary_quantity => 0,
2890: --{
2891: IF l_debug_on THEN
2892: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2893: END IF;
2894: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
2895: p_delivery_detail_id => p_delivery_detail_id,
2896: p_primary_quantity => 0,
2897: x_return_status => x_return_status);
2898: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2897: x_return_status => x_return_status);
2898: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2899: --{
2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
2902: WSH_DEBUG_SV.pop(l_module_name);
2903: END IF;
2904: RETURN;
2905: --}