APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_MDC_PVT

Line 1635: l_lpns wms_mdc_pvt.number_table_type;

1631: l_period_id NUMBER;
1632: l_open_past_period BOOLEAN;
1633: l_item_id NUMBER;
1634: p_user_id NUMBER;
1635: l_lpns wms_mdc_pvt.number_table_type;
1636: l_deliveries wms_mdc_pvt.number_table_type;
1637: l_allow_packing VARCHAR2(1);
1638: i NUMBER := 1;
1639: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1636: l_deliveries wms_mdc_pvt.number_table_type;

1632: l_open_past_period BOOLEAN;
1633: l_item_id NUMBER;
1634: p_user_id NUMBER;
1635: l_lpns wms_mdc_pvt.number_table_type;
1636: l_deliveries wms_mdc_pvt.number_table_type;
1637: l_allow_packing VARCHAR2(1);
1638: i NUMBER := 1;
1639: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1640: l_to_loc_type NUMBER;

Line 1677: wms_mdc_pvt.validate_to_lpn(p_from_lpn_ids => l_lpns,

1673: -- not provided, so that LPN mass move without MDC does not move CONSOL LPNs to any
1674: -- other locator
1675:
1676: -- Call the validation API to check if the from lpns can be dropped into TO lpn
1677: wms_mdc_pvt.validate_to_lpn(p_from_lpn_ids => l_lpns,
1678: p_from_delivery_ids => l_deliveries,
1679: p_to_lpn_id => p_transfer_lpn_id,
1680: p_to_sub => p_to_sub,
1681: p_to_locator_id => p_to_loc_id,

Line 1689: mydebug('lpn_mass_move: Error from wms_mdc_pvt.validate_to_lpn: ' || x_msg_data);

1685: x_msg_data => x_msg_data);
1686:
1687: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1688: IF g_trace_on = 1 THEN
1689: mydebug('lpn_mass_move: Error from wms_mdc_pvt.validate_to_lpn: ' || x_msg_data);
1690: END IF;
1691: RAISE fnd_api.g_exc_error;
1692: ELSE
1693: IF g_trace_on = 1 THEN

Line 1694: mydebug('lpn_mass_move: wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing);

1690: END IF;
1691: RAISE fnd_api.g_exc_error;
1692: ELSE
1693: IF g_trace_on = 1 THEN
1694: mydebug('lpn_mass_move: wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing);
1695: END IF;
1696:
1697: IF l_allow_packing = 'N' THEN
1698: RAISE fnd_api.g_exc_error;