eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRANSFER_ORDER_PVT dependencies on WMS_CATCH_WEIGHT_PVT

Line 4448: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (

4444:
4445: IF ( (l_mmtt_rec.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder) AND
4446: (l_mmtt_rec.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr) ) THEN
4447: -- Call to new api to check if item is catch weight enabled.
4448: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (
4449: p_api_version => 1.0
4450: , x_return_status => x_return_status
4451: , x_msg_count => x_msg_count
4452: , x_msg_data => x_msg_data

Line 4461: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)) THEN

4457: fnd_msg_pub.ADD;
4458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4459: END IF;
4460:
4461: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)) THEN
4462: fnd_message.set_name('INV', 'WMS_CATCH_WEIGHT_NO_LPN_ERR');
4463: fnd_msg_pub.ADD;
4464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4465: END IF;

Line 4522: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND

4518:
4519: -- If this item is catch weight enabled, check to see if any other MTLT lines for
4520: -- this LPN. If any do not have secondary quantity defined, do not populate
4521: -- picked_quantity2
4522: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND
4523: l_lot_number <> l_previous_lot_number ) THEN
4524: l_previous_lot_number := l_lot_number;
4525:
4526: BEGIN

Line 4527: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL

4523: l_lot_number <> l_previous_lot_number ) THEN
4524: l_previous_lot_number := l_lot_number;
4525:
4526: BEGIN
4527: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4528: WHERE EXISTS (
4529: SELECT 1
4530: FROM mtl_material_transactions_temp mmtt,
4531: mtl_transaction_lots_temp mtlt

Line 4543: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;

4539: AND mtlt.lot_number = l_lot_number
4540: AND (mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );
4541: EXCEPTION
4542: WHEN OTHERS THEN
4543: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;
4544: END;
4545: IF (l_debug = 1) THEN
4546: DEBUG('itemid='||l_mmtt_rec.inventory_item_id||' rev='||l_mmtt_rec.revision||' lot='||l_lot_number||' lpnid='||l_lpn_id||' cwe='||l_catch_weight_enabled, 'Finalize_Pick_Confirm');
4547: END IF;

Line 4572: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

4568: l_sec_pending_quantity := l_sec_pending_quantity - ABS(l_lot_secondary_quantity);
4569: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
4570: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
4571: l_return_status := '';
4572: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4573: l_shipping_attr(1).picked_quantity2 := ABS(l_lot_secondary_quantity);
4574: l_shipping_attr(1).ordered_quantity_uom2 := l_lot_secondary_uom;
4575: END IF;
4576:

Line 4640: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

4636: END IF;
4637: RAISE fnd_api.g_exc_unexpected_error;
4638: END IF;
4639: ELSE -- Either only a single serial item or not WMS.I process the old way
4640: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4641: -- Calculate the secondary quantity for a single serial number
4642: l_serial_secondary_quantity := l_lot_secondary_quantity*(1/l_lot_primary_quantity);
4643: END IF;
4644:

Line 4681: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

4677: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
4678: l_shipping_attr(1).pending_quantity2 := null;
4679: l_return_status := '';
4680:
4681: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4682: l_shipping_attr(1).picked_quantity2 := l_serial_secondary_quantity;
4683: l_shipping_attr(1).ordered_quantity_uom2 := l_lot_secondary_uom;
4684: END IF;
4685:

Line 4771: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

4767: ELSIF ( l_lot_control_code = 1 AND l_serial_control_code NOT IN (1, 6) ) THEN
4768: -- If this item is catch weight enabled, check to see if any other MMTT lines for
4769: -- this LPN. If any do not have secondary quantity defined, do not populate
4770: -- picked_quantity2
4771: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4772: BEGIN
4773: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4774: WHERE EXISTS (
4775: SELECT 1

Line 4773: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL

4769: -- this LPN. If any do not have secondary quantity defined, do not populate
4770: -- picked_quantity2
4771: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4772: BEGIN
4773: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4774: WHERE EXISTS (
4775: SELECT 1
4776: FROM mtl_material_transactions_temp mmtt
4777: WHERE mmtt.organization_id = l_mmtt_rec.organization_id

Line 4786: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;

4782: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
4783: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
4784: EXCEPTION
4785: WHEN OTHERS THEN
4786: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;
4787: END;
4788: IF (l_debug = 1) THEN
4789: DEBUG('itemid='||l_mmtt_rec.inventory_item_id||' rev='||l_mmtt_rec.revision||' lot='||l_lot_number||' lpnid='||l_lpn_id||' cwe='||l_catch_weight_enabled, l_api_name);
4790: END IF;

Line 4806: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

4802: l_sec_pending_quantity := l_sec_pending_quantity - l_sec_shipping_quantity;
4803: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
4804: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
4805: l_return_status := '';
4806: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4807: l_shipping_attr(1).picked_quantity2 := l_mmtt_rec.secondary_transaction_quantity;
4808: l_shipping_attr(1).ordered_quantity_uom2 := l_mmtt_rec.secondary_uom_code;
4809: END IF;
4810:

Line 4870: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

4866: l_serial_trx_temp_id := 0;
4867: l_ser_prim_shipping_quantity := 0;
4868: l_serial_quantity := 1;
4869: l_update_shipping := TRUE;
4870: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4871: -- Calculate the secondary quantity for a single serial number
4872: l_serial_secondary_quantity := l_mmtt_rec.secondary_transaction_quantity*(1/l_primary_shipping_quantity);
4873: END IF;
4874:

Line 4903: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

4899: l_primary_pending_quantity := l_primary_pending_quantity - 1;
4900: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
4901: l_shipping_attr(1).pending_quantity2 := null;
4902: l_return_status := '';
4903: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4904: l_shipping_attr(1).picked_quantity2 := l_serial_secondary_quantity;
4905: l_shipping_attr(1).ordered_quantity_uom2 := l_mmtt_rec.secondary_uom_code;
4906: END IF;
4907:

Line 4999: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND

4995:
4996: -- If this item is catch weight enabled, check to see if any other MTLT lines for
4997: -- this LPN. If any do not have secondary quantity defined, do not populate
4998: -- picked_quantity2
4999: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND
5000: l_lot_number <> l_previous_lot_number ) THEN
5001: l_previous_lot_number := l_lot_number;
5002:
5003: BEGIN

Line 5004: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL

5000: l_lot_number <> l_previous_lot_number ) THEN
5001: l_previous_lot_number := l_lot_number;
5002:
5003: BEGIN
5004: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5005: WHERE EXISTS (
5006: SELECT 1
5007: FROM mtl_material_transactions_temp mmtt,
5008: mtl_transaction_lots_temp mtlt

Line 5020: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;

5016: AND mtlt.lot_number = l_lot_number
5017: AND (mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );
5018: EXCEPTION
5019: WHEN OTHERS THEN
5020: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;
5021: END;
5022: IF (l_debug = 1) THEN
5023: DEBUG('itemid='||l_mmtt_rec.inventory_item_id||' rev='||l_mmtt_rec.revision||' lot='||l_lot_number||' lpnid='||l_lpn_id||' cwe='||l_catch_weight_enabled, l_api_name);
5024: END IF;

Line 5046: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

5042: l_sec_pending_quantity := l_sec_pending_quantity - ABS(l_lot_secondary_quantity);
5043: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
5044: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
5045: l_return_status := '';
5046: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5047: l_shipping_attr(1).picked_quantity2 := ABS(l_lot_secondary_quantity);
5048: l_shipping_attr(1).ordered_quantity_uom2 := l_lot_secondary_uom;
5049: END IF;
5050:

Line 5107: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

5103: -- No lot or serial control
5104: -- If this item is catch weight enabled, check to see if any other MMTT lines for
5105: -- this LPN. If any do not have secondary quantity defined, do not populate
5106: -- picked_quantity2
5107: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5108: BEGIN
5109: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5110: WHERE EXISTS (
5111: SELECT 1

Line 5109: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL

5105: -- this LPN. If any do not have secondary quantity defined, do not populate
5106: -- picked_quantity2
5107: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5108: BEGIN
5109: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5110: WHERE EXISTS (
5111: SELECT 1
5112: FROM mtl_material_transactions_temp mmtt
5113: WHERE mmtt.organization_id = l_mmtt_rec.organization_id

Line 5122: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;

5118: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5119: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
5120: EXCEPTION
5121: WHEN OTHERS THEN
5122: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;
5123: END;
5124: IF (l_debug = 1) THEN
5125: DEBUG('itemid='||l_mmtt_rec.inventory_item_id||' rev='||l_mmtt_rec.revision||' lot='||l_lot_number||' lpnid='||l_lpn_id||' cwe='||l_catch_weight_enabled, l_api_name);
5126: END IF;

Line 5137: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

5133: l_sec_pending_quantity := l_sec_pending_quantity - l_sec_shipping_quantity;
5134: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
5135: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
5136: l_return_status := '';
5137: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5138: l_shipping_attr(1).picked_quantity2 := ABS(l_mmtt_rec.secondary_transaction_quantity);
5139: l_shipping_attr(1).ordered_quantity_uom2 := l_mmtt_rec.secondary_uom_code;
5140: END IF;
5141: