APPS.WMS_PICK_DROP_PVT dependencies on WMS_MDC_PVT

Line 9145: wms_mdc_pvt.validate_to_lpn

9141: -- Added the following if condition for bug 5186375
9142: IF l_drop_lpn_id IS NOT NULL AND
9143: l_drop_lpn_id <> 0
9144: THEN
9145: wms_mdc_pvt.validate_to_lpn
9146: (p_from_lpn_id => nvl(p_transfer_lpn_id,0),
9147: p_from_delivery_id => null,
9148: p_to_lpn_id => nvl(l_drop_lpn_id,0),
9149: p_is_from_to_delivery_same => 'U',

Line 9159: print_debug('Error from wms_mdc_pvt.validate_to_lpn: ' || l_msg_data, l_api_name);

9155: x_msg_data => l_msg_data);
9156:
9157: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
9158: IF l_debug = 1 THEN
9159: print_debug('Error from wms_mdc_pvt.validate_to_lpn: ' || l_msg_data, l_api_name);
9160: END IF;
9161: RAISE fnd_api.g_exc_error;
9162: ELSE
9163: IF l_debug = 1 THEN

Line 9164: print_debug('wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing, l_api_name);

9160: END IF;
9161: RAISE fnd_api.g_exc_error;
9162: ELSE
9163: IF l_debug = 1 THEN
9164: print_debug('wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing, l_api_name);
9165: END IF;
9166:
9167: IF l_allow_packing = 'N' THEN
9168: RAISE fnd_api.g_exc_error;

Line 10744: wms_mdc_pvt.validate_to_lpn(p_from_lpn_id => p_transfer_lpn_id,

10740: END IF;
10741:
10742: --**MRANA temporary code for double validations and avoid data corruption
10743:
10744: wms_mdc_pvt.validate_to_lpn(p_from_lpn_id => p_transfer_lpn_id,
10745: p_from_delivery_id => p_delivery_id,
10746: p_to_lpn_id => drop_lpn_rec.lpn_id,
10747: p_is_from_to_delivery_same => 'U',
10748: x_allow_packing => l_allow_packing,

Line 10755: print_debug('Error from wms_mdc_pvt.validate_to_lpn: ' || l_msg_data, l_api_name);

10751: x_msg_data => l_msg_data);
10752:
10753: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
10754: IF l_debug = 1 THEN
10755: print_debug('Error from wms_mdc_pvt.validate_to_lpn: ' || l_msg_data, l_api_name);
10756: END IF;
10757: RAISE fnd_api.g_exc_error;
10758: ELSE
10759: IF l_debug = 1 THEN

Line 10760: print_debug('wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing, l_api_name);

10756: END IF;
10757: RAISE fnd_api.g_exc_error;
10758: ELSE
10759: IF l_debug = 1 THEN
10760: print_debug('wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing, l_api_name);
10761: END IF;
10762:
10763: IF l_allow_packing = 'N' THEN
10764: RAISE fnd_api.g_exc_error;

Line 10770: -- MR: wms_mdc_pvt.validate_to_lpn API, returns l_allow_packing = 'N', if

10766:
10767: END IF;
10768:
10769:
10770: -- MR: wms_mdc_pvt.validate_to_lpn API, returns l_allow_packing = 'N', if
10771: -- {{- either from or To do not have a delivery id . Therefor, MDC is not }}
10772: -- {{ allowed if either of the 2 is NULL }} */
10773: --mrana IF l_allow_packing = 'U' THEN -- Both from LPN and to LPN are not tied to any delivery
10774: /*Bug#4106176.The following block is added.*/