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 4784: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (

4780:
4781: IF ( (l_mmtt_rec.transaction_source_type_id = INV_GLOBALS.G_SourceType_SalesOrder) AND
4782: (l_mmtt_rec.transaction_action_id = INV_GLOBALS.G_Action_Stgxfr) ) THEN
4783: -- Call to new api to check if item is catch weight enabled.
4784: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.Get_Ont_Pricing_Qty_Source (
4785: p_api_version => 1.0
4786: , x_return_status => x_return_status
4787: , x_msg_count => x_msg_count
4788: , x_msg_data => x_msg_data

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

4793: fnd_msg_pub.ADD;
4794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4795: END IF;
4796:
4797: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)
4798: AND nvl(l_mmtt_rec.secondary_transaction_quantity,0) = 0) THEN -- added secondary_transaction_quantity for bug 12616674
4799: fnd_message.set_name('INV', 'WMS_CATCH_WEIGHT_NO_LPN_ERR');
4800: fnd_msg_pub.ADD;
4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4859: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND

4855:
4856: -- If this item is catch weight enabled, check to see if any other MTLT lines for
4857: -- this LPN. If any do not have secondary quantity defined, do not populate
4858: -- picked_quantity2
4859: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND
4860: l_lot_number <> l_previous_lot_number ) THEN
4861: l_previous_lot_number := l_lot_number;
4862:
4863: BEGIN

Line 4864: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL

4860: l_lot_number <> l_previous_lot_number ) THEN
4861: l_previous_lot_number := l_lot_number;
4862:
4863: BEGIN
4864: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
4865: WHERE EXISTS (
4866: SELECT 1
4867: FROM mtl_material_transactions_temp mmtt,
4868: mtl_transaction_lots_temp mtlt

Line 4880: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;

4876: AND mtlt.lot_number = l_lot_number
4877: AND (mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );
4878: EXCEPTION
4879: WHEN OTHERS THEN
4880: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;
4881: END;
4882: IF (l_debug = 1) THEN
4883: 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');
4884: END IF;

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

4905: l_sec_pending_quantity := l_sec_pending_quantity - ABS(l_lot_secondary_quantity);
4906: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
4907: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
4908: l_return_status := '';
4909: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4910: l_shipping_attr(1).picked_quantity2 := ABS(l_lot_secondary_quantity);
4911: l_shipping_attr(1).ordered_quantity_uom2 := l_lot_secondary_uom;
4912: END IF;
4913:

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

4972: END IF;
4973: RAISE fnd_api.g_exc_unexpected_error;
4974: END IF;
4975: ELSE -- Either only a single serial item or not WMS.I process the old way
4976: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
4977: -- Calculate the secondary quantity for a single serial number
4978: l_serial_secondary_quantity := l_lot_secondary_quantity*(1/l_lot_primary_quantity);
4979: END IF;
4980:

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

5013: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
5014: l_shipping_attr(1).pending_quantity2 := null;
5015: l_return_status := '';
5016:
5017: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5018: l_shipping_attr(1).picked_quantity2 := l_serial_secondary_quantity;
5019: l_shipping_attr(1).ordered_quantity_uom2 := l_lot_secondary_uom;
5020: END IF;
5021:

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

5103: ELSIF ( l_lot_control_code = 1 AND l_serial_control_code NOT IN (1, 6) ) THEN
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 5142: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN

5138: l_sec_pending_quantity := l_sec_pending_quantity - l_sec_shipping_quantity;
5139: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
5140: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
5141: l_return_status := '';
5142: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5143: l_shipping_attr(1).picked_quantity2 := l_mmtt_rec.secondary_transaction_quantity;
5144: l_shipping_attr(1).ordered_quantity_uom2 := l_mmtt_rec.secondary_uom_code;
5145: END IF;
5146:

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

5210: l_serial_trx_temp_id := 0;
5211: l_ser_prim_shipping_quantity := 0;
5212: l_serial_quantity := 1;
5213: l_update_shipping := TRUE;
5214: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5215: -- Calculate the secondary quantity for a single serial number
5216: l_serial_secondary_quantity := l_mmtt_rec.secondary_transaction_quantity*(1/l_primary_shipping_quantity);
5217: END IF;
5218:

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

5243: l_primary_pending_quantity := l_primary_pending_quantity - 1;
5244: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
5245: l_shipping_attr(1).pending_quantity2 := null;
5246: l_return_status := '';
5247: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5248: l_shipping_attr(1).picked_quantity2 := l_serial_secondary_quantity;
5249: l_shipping_attr(1).ordered_quantity_uom2 := l_mmtt_rec.secondary_uom_code;
5250: END IF;
5251:

Line 5343: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND

5339:
5340: -- If this item is catch weight enabled, check to see if any other MTLT lines for
5341: -- this LPN. If any do not have secondary quantity defined, do not populate
5342: -- picked_quantity2
5343: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND
5344: l_lot_number <> l_previous_lot_number ) THEN
5345: l_previous_lot_number := l_lot_number;
5346:
5347: BEGIN

Line 5348: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL

5344: l_lot_number <> l_previous_lot_number ) THEN
5345: l_previous_lot_number := l_lot_number;
5346:
5347: BEGIN
5348: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5349: WHERE EXISTS (
5350: SELECT 1
5351: FROM mtl_material_transactions_temp mmtt,
5352: mtl_transaction_lots_temp mtlt

Line 5364: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;

5360: AND mtlt.lot_number = l_lot_number
5361: AND (mtlt.secondary_quantity IS NULL OR mtlt.secondary_unit_of_measure IS NULL) );
5362: EXCEPTION
5363: WHEN OTHERS THEN
5364: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;
5365: END;
5366: IF (l_debug = 1) THEN
5367: 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);
5368: END IF;

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

5386: l_sec_pending_quantity := l_sec_pending_quantity - ABS(l_lot_secondary_quantity);
5387: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
5388: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
5389: l_return_status := '';
5390: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5391: l_shipping_attr(1).picked_quantity2 := ABS(l_lot_secondary_quantity);
5392: l_shipping_attr(1).ordered_quantity_uom2 := l_lot_secondary_uom;
5393: END IF;
5394:

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

5458: -- No lot or serial control
5459: -- If this item is catch weight enabled, check to see if any other MMTT lines for
5460: -- this LPN. If any do not have secondary quantity defined, do not populate
5461: -- picked_quantity2
5462: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5463: BEGIN
5464: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5465: WHERE EXISTS (
5466: SELECT 1

Line 5464: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL

5460: -- this LPN. If any do not have secondary quantity defined, do not populate
5461: -- picked_quantity2
5462: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5463: BEGIN
5464: SELECT WMS_CATCH_WEIGHT_PVT.G_PRICE_PRIMARY INTO l_catch_weight_enabled FROM DUAL
5465: WHERE EXISTS (
5466: SELECT 1
5467: FROM mtl_material_transactions_temp mmtt
5468: WHERE mmtt.organization_id = l_mmtt_rec.organization_id

Line 5477: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;

5473: AND NVL(mmtt.content_lpn_id, mmtt.transfer_lpn_id) = l_lpn_id
5474: AND (mmtt.secondary_transaction_quantity IS NULL OR mmtt.secondary_uom_code IS NULL) );
5475: EXCEPTION
5476: WHEN OTHERS THEN
5477: l_catch_weight_enabled := WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY;
5478: END;
5479: IF (l_debug = 1) THEN
5480: 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);
5481: END IF;

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

5488: l_sec_pending_quantity := l_sec_pending_quantity - l_sec_shipping_quantity;
5489: l_shipping_attr(1).pending_quantity := l_primary_pending_quantity;
5490: l_shipping_attr(1).pending_quantity2 := l_sec_pending_quantity;
5491: l_return_status := '';
5492: IF ( l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY ) THEN
5493: l_shipping_attr(1).picked_quantity2 := ABS(l_mmtt_rec.secondary_transaction_quantity);
5494: l_shipping_attr(1).ordered_quantity_uom2 := l_mmtt_rec.secondary_uom_code;
5495: END IF;
5496: