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.WMS_DIRECT_SHIP_PVT dependencies on INV_CACHE

Line 3270: IF inv_cache.set_item_rec(p_org_id,l_item_id) THEN

3266: IF (l_debug = 1) THEN
3267: DEBUG('Entered the delivery details loop', 'Unload Truck');
3268: END IF;
3269:
3270: IF inv_cache.set_item_rec(p_org_id,l_item_id) THEN
3271: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
3272: l_dual_uom_item := TRUE;
3273: IF (l_debug = 1) THEN
3274: DEBUG('Item is dual UOM', 'Unload Truck');

Line 3271: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN

3267: DEBUG('Entered the delivery details loop', 'Unload Truck');
3268: END IF;
3269:
3270: IF inv_cache.set_item_rec(p_org_id,l_item_id) THEN
3271: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
3272: l_dual_uom_item := TRUE;
3273: IF (l_debug = 1) THEN
3274: DEBUG('Item is dual UOM', 'Unload Truck');
3275: END IF;

Line 3284: DEBUG('Error from inv_cache.set_item_rec', 'Unload Truck');

3280: END IF;
3281: END IF;
3282: ELSE
3283: IF (l_debug = 1) THEN
3284: DEBUG('Error from inv_cache.set_item_rec', 'Unload Truck');
3285: END IF;
3286: RAISE fnd_api.g_exc_unexpected_error;
3287: END IF;
3288:

Line 4896: IF inv_cache.set_item_rec(p_organization_id,

4892: END LOOP;
4893:
4894: l_mtl_reservation_tbl_count := l_mtl_reservation_tbl.COUNT;
4895:
4896: IF inv_cache.set_item_rec(p_organization_id,
4897: l_mtl_reservation_tbl(l_mtl_reservation_tbl.FIRST).inventory_item_id)
4898: THEN
4899: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
4900: l_dual_uom_item := TRUE;

Line 4899: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN

4895:
4896: IF inv_cache.set_item_rec(p_organization_id,
4897: l_mtl_reservation_tbl(l_mtl_reservation_tbl.FIRST).inventory_item_id)
4898: THEN
4899: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
4900: l_dual_uom_item := TRUE;
4901: IF (l_debug = 1) THEN
4902: DEBUG('Item is dual UOM', 'Overship Staged Lines');
4903: END IF;

Line 4912: DEBUG('Error from inv_cache.set_item_rec', 'Overship Staged Lines');

4908: END IF;
4909: END IF;
4910: ELSE
4911: IF (l_debug = 1) THEN
4912: DEBUG('Error from inv_cache.set_item_rec', 'Overship Staged Lines');
4913: END IF;
4914: RAISE fnd_api.g_exc_unexpected_error;
4915: END IF;
4916:

Line 5540: IF inv_cache.set_item_rec(p_organization_id, l_inventory_item_id) THEN

5536: IF (l_debug = 1) THEN
5537: DEBUG('Stage Line Loop Line_ID :' || l_line_id, 'Stage_LPNS');
5538: END IF;
5539:
5540: IF inv_cache.set_item_rec(p_organization_id, l_inventory_item_id) THEN
5541: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
5542: l_dual_uom_item := TRUE;
5543: IF (l_debug = 1) THEN
5544: DEBUG('Item is dual UOM', 'Stage_LPNS');

Line 5541: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN

5537: DEBUG('Stage Line Loop Line_ID :' || l_line_id, 'Stage_LPNS');
5538: END IF;
5539:
5540: IF inv_cache.set_item_rec(p_organization_id, l_inventory_item_id) THEN
5541: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
5542: l_dual_uom_item := TRUE;
5543: IF (l_debug = 1) THEN
5544: DEBUG('Item is dual UOM', 'Stage_LPNS');
5545: END IF;

Line 5554: DEBUG('Error from inv_cache.set_item_rec', 'Stage_LPNS');

5550: END IF;
5551: END IF;
5552: ELSE
5553: IF (l_debug = 1) THEN
5554: DEBUG('Error from inv_cache.set_item_rec', 'Stage_LPNS');
5555: END IF;
5556: RAISE fnd_api.g_exc_unexpected_error;
5557: END IF;
5558:

Line 6189: from_unit => inv_cache.item_rec.primary_uom_code,

6185: lot_number => l_shipping_attr(1).lot_number,
6186: organization_id => l_shipping_attr(1).ship_from_org_id,
6187: precision => NULL,
6188: from_quantity => l_shipping_attr(1).picked_quantity,
6189: from_unit => inv_cache.item_rec.primary_uom_code,
6190: to_unit => inv_cache.item_rec.secondary_uom_code,
6191: from_name => NULL,
6192: to_name => NULL);
6193: END IF;

Line 6190: to_unit => inv_cache.item_rec.secondary_uom_code,

6186: organization_id => l_shipping_attr(1).ship_from_org_id,
6187: precision => NULL,
6188: from_quantity => l_shipping_attr(1).picked_quantity,
6189: from_unit => inv_cache.item_rec.primary_uom_code,
6190: to_unit => inv_cache.item_rec.secondary_uom_code,
6191: from_name => NULL,
6192: to_name => NULL);
6193: END IF;
6194: END IF;

Line 6593: from_unit => inv_cache.item_rec.primary_uom_code,

6589: lot_number => l_shipping_attr(1).lot_number,
6590: organization_id => l_shipping_attr(1).ship_from_org_id,
6591: precision => NULL,
6592: from_quantity => l_shipping_attr(1).picked_quantity,
6593: from_unit => inv_cache.item_rec.primary_uom_code,
6594: to_unit => inv_cache.item_rec.secondary_uom_code,
6595: from_name => NULL,
6596: to_name => NULL);
6597: END IF;

Line 6594: to_unit => inv_cache.item_rec.secondary_uom_code,

6590: organization_id => l_shipping_attr(1).ship_from_org_id,
6591: precision => NULL,
6592: from_quantity => l_shipping_attr(1).picked_quantity,
6593: from_unit => inv_cache.item_rec.primary_uom_code,
6594: to_unit => inv_cache.item_rec.secondary_uom_code,
6595: from_name => NULL,
6596: to_name => NULL);
6597: END IF;
6598: END IF;

Line 9848: IF inv_cache.set_item_rec(p_org_id, g_lpn_contents_tab(c_index).inventory_item_id) THEN

9844: IF (l_debug = 1) THEN
9845: DEBUG('Querying reservations for lpn_contents_rec ' || c_index, 'Process_LPN');
9846: END IF;
9847:
9848: IF inv_cache.set_item_rec(p_org_id, g_lpn_contents_tab(c_index).inventory_item_id) THEN
9849: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
9850: l_dual_uom_item := TRUE;
9851: IF (l_debug = 1) THEN
9852: DEBUG('Item is dual UOM', 'Process_LPN');

Line 9849: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN

9845: DEBUG('Querying reservations for lpn_contents_rec ' || c_index, 'Process_LPN');
9846: END IF;
9847:
9848: IF inv_cache.set_item_rec(p_org_id, g_lpn_contents_tab(c_index).inventory_item_id) THEN
9849: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
9850: l_dual_uom_item := TRUE;
9851: IF (l_debug = 1) THEN
9852: DEBUG('Item is dual UOM', 'Process_LPN');
9853: END IF;

Line 9862: DEBUG('Error from inv_cache.set_item_rec', 'Process_LPN');

9858: END IF;
9859: END IF;
9860: ELSE
9861: IF (l_debug = 1) THEN
9862: DEBUG('Error from inv_cache.set_item_rec', 'Process_LPN');
9863: END IF;
9864: RAISE fnd_api.g_exc_unexpected_error;
9865: END IF;
9866:

Line 10817: IF inv_cache.set_item_rec(p_org_id, p_inventory_item_id) THEN

10813: IF (l_debug = 1) THEN
10814: DEBUG('l_demand_source_type_id = ' || l_demand_source_type_id, 'Process_Line');
10815: END IF;
10816:
10817: IF inv_cache.set_item_rec(p_org_id, p_inventory_item_id) THEN
10818: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
10819: l_dual_uom_item := TRUE;
10820: IF (l_debug = 1) THEN
10821: DEBUG('Item is dual UOM','Process_Line');

Line 10818: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN

10814: DEBUG('l_demand_source_type_id = ' || l_demand_source_type_id, 'Process_Line');
10815: END IF;
10816:
10817: IF inv_cache.set_item_rec(p_org_id, p_inventory_item_id) THEN
10818: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
10819: l_dual_uom_item := TRUE;
10820: IF (l_debug = 1) THEN
10821: DEBUG('Item is dual UOM','Process_Line');
10822: END IF;

Line 10823: IF NVL(inv_cache.item_rec.dual_uom_deviation_high,0) > 0

10819: l_dual_uom_item := TRUE;
10820: IF (l_debug = 1) THEN
10821: DEBUG('Item is dual UOM','Process_Line');
10822: END IF;
10823: IF NVL(inv_cache.item_rec.dual_uom_deviation_high,0) > 0
10824: OR NVL(inv_cache.item_rec.dual_uom_deviation_low,0) > 0
10825: THEN
10826: l_deviation_allowed := TRUE;
10827: IF (l_debug = 1) THEN

Line 10824: OR NVL(inv_cache.item_rec.dual_uom_deviation_low,0) > 0

10820: IF (l_debug = 1) THEN
10821: DEBUG('Item is dual UOM','Process_Line');
10822: END IF;
10823: IF NVL(inv_cache.item_rec.dual_uom_deviation_high,0) > 0
10824: OR NVL(inv_cache.item_rec.dual_uom_deviation_low,0) > 0
10825: THEN
10826: l_deviation_allowed := TRUE;
10827: IF (l_debug = 1) THEN
10828: DEBUG('Deviation is allowed','Process_Line');

Line 10845: DEBUG('Error from inv_cache.set_item_rec','Process_Line');

10841: END IF;
10842: END IF;
10843: ELSE
10844: IF (l_debug = 1) THEN
10845: DEBUG('Error from inv_cache.set_item_rec','Process_Line');
10846: END IF;
10847: RAISE fnd_api.g_exc_unexpected_error;
10848: END IF;
10849:

Line 11647: , from_unit => inv_cache.item_rec.primary_uom_code

11643: , lot_number => l_lpn_cont_rec.lot_number
11644: , organization_id => p_org_id
11645: , precision => NULL
11646: , from_quantity => l_reservation_record.primary_reservation_quantity
11647: , from_unit => inv_cache.item_rec.primary_uom_code
11648: , to_unit => inv_cache.item_rec.secondary_uom_code
11649: , from_name => NULL
11650: , to_name => NULL);
11651: ELSE

Line 11648: , to_unit => inv_cache.item_rec.secondary_uom_code

11644: , organization_id => p_org_id
11645: , precision => NULL
11646: , from_quantity => l_reservation_record.primary_reservation_quantity
11647: , from_unit => inv_cache.item_rec.primary_uom_code
11648: , to_unit => inv_cache.item_rec.secondary_uom_code
11649: , from_name => NULL
11650: , to_name => NULL);
11651: ELSE
11652: IF l_deviation_allowed THEN

Line 11703: l_reservation_record.reservation_uom_code := inv_cache.item_rec.primary_uom_code;

11699: l_reservation_record.inventory_item_id := p_inventory_item_id;
11700: l_reservation_record.demand_source_header_id := l_demand_source_header_id;
11701: l_reservation_record.demand_source_line_id := p_order_line_id;
11702: l_reservation_record.reservation_uom_id := NULL;
11703: l_reservation_record.reservation_uom_code := inv_cache.item_rec.primary_uom_code;
11704: l_reservation_record.primary_uom_code := inv_cache.item_rec.primary_uom_code;
11705: IF l_dual_uom_item THEN
11706: l_reservation_record.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
11707: ELSE

Line 11704: l_reservation_record.primary_uom_code := inv_cache.item_rec.primary_uom_code;

11700: l_reservation_record.demand_source_header_id := l_demand_source_header_id;
11701: l_reservation_record.demand_source_line_id := p_order_line_id;
11702: l_reservation_record.reservation_uom_id := NULL;
11703: l_reservation_record.reservation_uom_code := inv_cache.item_rec.primary_uom_code;
11704: l_reservation_record.primary_uom_code := inv_cache.item_rec.primary_uom_code;
11705: IF l_dual_uom_item THEN
11706: l_reservation_record.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
11707: ELSE
11708: l_reservation_record.secondary_uom_code := NULL;

Line 11706: l_reservation_record.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;

11702: l_reservation_record.reservation_uom_id := NULL;
11703: l_reservation_record.reservation_uom_code := inv_cache.item_rec.primary_uom_code;
11704: l_reservation_record.primary_uom_code := inv_cache.item_rec.primary_uom_code;
11705: IF l_dual_uom_item THEN
11706: l_reservation_record.secondary_uom_code := inv_cache.item_rec.secondary_uom_code;
11707: ELSE
11708: l_reservation_record.secondary_uom_code := NULL;
11709: END IF;
11710: l_reservation_record.primary_uom_id := NULL;

Line 12596: IF inv_cache.set_item_rec(p_org_id, l_lpn_cont_rec.inventory_item_id) THEN

12592:
12593: IF (g_fulfillment_base = 'P' AND l_lpn_cont_rec.quantity > 0)
12594: OR (g_fulfillment_base = 'S' AND NVL(l_lpn_cont_rec.secondary_quantity,0) > 0) --{
12595: THEN -- overship needed
12596: IF inv_cache.set_item_rec(p_org_id, l_lpn_cont_rec.inventory_item_id) THEN
12597: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
12598: l_dual_uom_item := TRUE;
12599: IF (l_debug = 1) THEN
12600: DEBUG('Item is dual UOM', 'Perform_Overship_Distribution');

Line 12597: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN

12593: IF (g_fulfillment_base = 'P' AND l_lpn_cont_rec.quantity > 0)
12594: OR (g_fulfillment_base = 'S' AND NVL(l_lpn_cont_rec.secondary_quantity,0) > 0) --{
12595: THEN -- overship needed
12596: IF inv_cache.set_item_rec(p_org_id, l_lpn_cont_rec.inventory_item_id) THEN
12597: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
12598: l_dual_uom_item := TRUE;
12599: IF (l_debug = 1) THEN
12600: DEBUG('Item is dual UOM', 'Perform_Overship_Distribution');
12601: END IF;

Line 12610: DEBUG('Error from inv_cache.set_item_rec', 'Perform_Overship_Distribution');

12606: END IF;
12607: END IF;
12608: ELSE
12609: IF (l_debug = 1) THEN
12610: DEBUG('Error from inv_cache.set_item_rec', 'Perform_Overship_Distribution');
12611: END IF;
12612: RAISE fnd_api.g_exc_unexpected_error;
12613: END IF;
12614: