APPS.WMS_CONSOLIDATION_PUB dependencies on WMS_MDC_PVT

Line 1630: l_lpns wms_mdc_pvt.number_table_type;

1626: l_period_id NUMBER;
1627: l_open_past_period BOOLEAN;
1628: l_item_id NUMBER;
1629: p_user_id NUMBER;
1630: l_lpns wms_mdc_pvt.number_table_type;
1631: l_deliveries wms_mdc_pvt.number_table_type;
1632: l_allow_packing VARCHAR2(1);
1633: i NUMBER := 1;
1634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1631: l_deliveries wms_mdc_pvt.number_table_type;

1627: l_open_past_period BOOLEAN;
1628: l_item_id NUMBER;
1629: p_user_id NUMBER;
1630: l_lpns wms_mdc_pvt.number_table_type;
1631: l_deliveries wms_mdc_pvt.number_table_type;
1632: l_allow_packing VARCHAR2(1);
1633: i NUMBER := 1;
1634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1635: l_to_loc_type NUMBER;

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

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

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

1680: x_msg_data => x_msg_data);
1681:
1682: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1683: IF g_trace_on = 1 THEN
1684: mydebug('lpn_mass_move: Error from wms_mdc_pvt.validate_to_lpn: ' || x_msg_data);
1685: END IF;
1686: RAISE fnd_api.g_exc_error;
1687: ELSE
1688: IF g_trace_on = 1 THEN

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

1685: END IF;
1686: RAISE fnd_api.g_exc_error;
1687: ELSE
1688: IF g_trace_on = 1 THEN
1689: mydebug('lpn_mass_move: wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing);
1690: END IF;
1691:
1692: IF l_allow_packing = 'N' THEN
1693: RAISE fnd_api.g_exc_error;