791: -- detail lines with zeqo qty so that WMS deletes the replenishment record.
792: IF (old_delivery_detail_rec.replenishment_status = 'R' and old_delivery_detail_rec.released_status in ('R','B')) THEN
793: --{
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
796: END IF;
797: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
798: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
799: p_primary_quantity => 0, --- WMS will delete the records from replenishment table.
793: --{
794: IF l_debug_on THEN
795: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
796: END IF;
797: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
798: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
799: p_primary_quantity => 0, --- WMS will delete the records from replenishment table.
800: x_return_status => x_return_status);
801: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
800: x_return_status => x_return_status);
801: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
802: --{
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
805: WSH_DEBUG_SV.pop(l_module_name);
806: END IF;
807: RETURN;
808: --}
3003: -- delivery detail lines to decrease the qty from replenishment tables.
3004: IF (p_replenishment_status = 'R' and p_released_status in ('R','B')) THEN
3005: --{
3006: IF l_debug_on THEN
3007: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: END IF;
3009: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
3010: p_delivery_detail_id => p_delivery_detail_id,
3011: -- muom
3005: --{
3006: IF l_debug_on THEN
3007: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: END IF;
3009: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
3010: p_delivery_detail_id => p_delivery_detail_id,
3011: -- muom
3012: p_primary_quantity => l_update_qty,
3013: x_return_status => x_return_status);
3013: x_return_status => x_return_status);
3014: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3015: --{
3016: IF l_debug_on THEN
3017: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
3018: WSH_DEBUG_SV.pop(l_module_name);
3019: END IF;
3020: RETURN;
3021: --}
3288: -- detail lines with zeqo qty so that WMS deletes the replenishment record.
3289: IF (p_replenishment_status = 'R' and p_released_status in ('R','B')) THEN
3290: --{
3291: IF l_debug_on THEN
3292: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3293: END IF;
3294: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
3295: p_delivery_detail_id => p_delivery_detail_id,
3296: p_primary_quantity => 0,
3290: --{
3291: IF l_debug_on THEN
3292: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3293: END IF;
3294: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
3295: p_delivery_detail_id => p_delivery_detail_id,
3296: p_primary_quantity => 0,
3297: x_return_status => x_return_status);
3298: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3297: x_return_status => x_return_status);
3298: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3299: --{
3300: IF l_debug_on THEN
3301: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
3302: WSH_DEBUG_SV.pop(l_module_name);
3303: END IF;
3304: RETURN;
3305: --}