DBA Data[Home] [Help]

APPS.WMS_CATCH_WEIGHT_PVT dependencies on WMS_CONTAINER_PVT

Line 3667: IF ( l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PICKED OR

3663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3664: END;
3665:
3666: l_progress := '000';
3667: IF ( l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PICKED OR
3668: l_lpn_context = WMS_CONTAINER_PVT.LPN_LOADED_FOR_SHIPMENT ) THEN
3669: l_progress := '100';
3670: -- Records should be checked in WDD to see if any catch weight item is
3671: -- is missing secondary quantities (picked_quantity2)

Line 3668: l_lpn_context = WMS_CONTAINER_PVT.LPN_LOADED_FOR_SHIPMENT ) THEN

3664: END;
3665:
3666: l_progress := '000';
3667: IF ( l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PICKED OR
3668: l_lpn_context = WMS_CONTAINER_PVT.LPN_LOADED_FOR_SHIPMENT ) THEN
3669: l_progress := '100';
3670: -- Records should be checked in WDD to see if any catch weight item is
3671: -- is missing secondary quantities (picked_quantity2)
3672: FOR wdd_nested_lpn_rec IN wdd_nested_lpn_cur LOOP

Line 3743: ELSIF ( l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_INV OR

3739:
3740: -- Exit at any point when a catch weight cannot be resolved
3741: EXIT WHEN l_return = G_CHECK_ERROR;
3742: END LOOP;
3743: ELSIF ( l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_INV OR
3744: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PACKING OR
3745: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PREGENERATED ) THEN
3746: l_progress := '600';
3747: -- Records should be checked in MMTT to see if any catch weight item is

Line 3744: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PACKING OR

3740: -- Exit at any point when a catch weight cannot be resolved
3741: EXIT WHEN l_return = G_CHECK_ERROR;
3742: END LOOP;
3743: ELSIF ( l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_INV OR
3744: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PACKING OR
3745: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PREGENERATED ) THEN
3746: l_progress := '600';
3747: -- Records should be checked in MMTT to see if any catch weight item is
3748: -- is missing secondary transaction quantities. Currently during picking

Line 3745: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PREGENERATED ) THEN

3741: EXIT WHEN l_return = G_CHECK_ERROR;
3742: END LOOP;
3743: ELSIF ( l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_INV OR
3744: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PACKING OR
3745: l_lpn_context = WMS_CONTAINER_PVT.LPN_CONTEXT_PREGENERATED ) THEN
3746: l_progress := '600';
3747: -- Records should be checked in MMTT to see if any catch weight item is
3748: -- is missing secondary transaction quantities. Currently during picking
3749: -- LPNs can only be nested one level deep. This cursor makes that assumtion

Line 5279: wms_container_pvt.modify_lpns(

5275: l_lpn_rec.tare_weight_uom_code := l_new_tare_wt_uom_code;
5276: l_lpn_tbl(1) := l_lpn_rec;
5277:
5278: l_api_return_status := fnd_api.g_ret_sts_success;
5279: wms_container_pvt.modify_lpns(
5280: p_api_version => 1.0
5281: , p_init_msg_list => fnd_api.g_true
5282: , p_commit => fnd_api.g_false
5283: , x_return_status => l_api_return_status

Line 5291: print_debug('Error status from wms_container_pvt.modify_lpns: '

5287: , p_lpn_table => l_lpn_tbl
5288: );
5289: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
5290: IF (l_debug = 1) THEN
5291: print_debug('Error status from wms_container_pvt.modify_lpns: '
5292: || l_api_return_status, 4);
5293: END IF;
5294: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5295: RAISE fnd_api.g_exc_error;