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_RULE_EXTN_PVT dependencies on INV_CACHE

Line 434: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id,

430: -- Initialisize API return status to access
431: x_return_status := fnd_api.g_ret_sts_success;
432: --
433:
434: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id,
435: p_mo_line_rec.inventory_item_id);
436: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
437: l_lot_divisible_flag:= INV_CACHE.item_rec.lot_divisible_flag; -- Added for Bug 13910013
438: l_lot_control_code := INV_CACHE.item_rec.lot_control_code; -- Added for Bug 16203819

Line 436: l_reservable_type:= INV_CACHE.item_rec.reservable_type;

432: --
433:
434: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id,
435: p_mo_line_rec.inventory_item_id);
436: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
437: l_lot_divisible_flag:= INV_CACHE.item_rec.lot_divisible_flag; -- Added for Bug 13910013
438: l_lot_control_code := INV_CACHE.item_rec.lot_control_code; -- Added for Bug 16203819
439:
440: IF l_reservable_type = 2 THEN

Line 437: l_lot_divisible_flag:= INV_CACHE.item_rec.lot_divisible_flag; -- Added for Bug 13910013

433:
434: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id,
435: p_mo_line_rec.inventory_item_id);
436: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
437: l_lot_divisible_flag:= INV_CACHE.item_rec.lot_divisible_flag; -- Added for Bug 13910013
438: l_lot_control_code := INV_CACHE.item_rec.lot_control_code; -- Added for Bug 16203819
439:
440: IF l_reservable_type = 2 THEN
441: IF (l_debug = 1) THEN

Line 438: l_lot_control_code := INV_CACHE.item_rec.lot_control_code; -- Added for Bug 16203819

434: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id,
435: p_mo_line_rec.inventory_item_id);
436: l_reservable_type:= INV_CACHE.item_rec.reservable_type;
437: l_lot_divisible_flag:= INV_CACHE.item_rec.lot_divisible_flag; -- Added for Bug 13910013
438: l_lot_control_code := INV_CACHE.item_rec.lot_control_code; -- Added for Bug 16203819
439:
440: IF l_reservable_type = 2 THEN
441: IF (l_debug = 1) THEN
442: log_error(l_api_name, 'Suggest_Reservations','Error - Item is not reservable');

Line 523: log_event(l_api_name, 'Suggest_Reservations','MOLs primary UOM code ' || INV_CACHE.item_rec.primary_uom_code);

519:
520: IF ( l_debug = 1 ) THEN
521: log_event(l_api_name, 'Suggest_Reservations','Check if the MOLs primary UOM code is different than reservation UOM code ');
522: log_event(l_api_name, 'Suggest_Reservations','l_demand_rsvs_ordered(i).reservation_uom_code: ' || l_demand_rsvs_ordered(i).reservation_uom_code);
523: log_event(l_api_name, 'Suggest_Reservations','MOLs primary UOM code ' || INV_CACHE.item_rec.primary_uom_code);
524: END IF;
525:
526: IF l_demand_rsvs_ordered(i).reservation_uom_code <> INV_CACHE.item_rec.primary_uom_code THEN
527: IF ( l_debug = 1 ) THEN

Line 526: IF l_demand_rsvs_ordered(i).reservation_uom_code <> INV_CACHE.item_rec.primary_uom_code THEN

522: log_event(l_api_name, 'Suggest_Reservations','l_demand_rsvs_ordered(i).reservation_uom_code: ' || l_demand_rsvs_ordered(i).reservation_uom_code);
523: log_event(l_api_name, 'Suggest_Reservations','MOLs primary UOM code ' || INV_CACHE.item_rec.primary_uom_code);
524: END IF;
525:
526: IF l_demand_rsvs_ordered(i).reservation_uom_code <> INV_CACHE.item_rec.primary_uom_code THEN
527: IF ( l_debug = 1 ) THEN
528: log_event(l_api_name, 'Suggest_Reservations','l_reservable_primary_qty: ' || l_reservable_primary_qty);
529: END IF;
530: l_reservable_primary_qty := l_reservable_primary_qty + inv_convert.inv_um_convert ( l_demand_rsvs_ordered(i).inventory_item_id,

Line 534: INV_CACHE.item_rec.primary_uom_code,

530: l_reservable_primary_qty := l_reservable_primary_qty + inv_convert.inv_um_convert ( l_demand_rsvs_ordered(i).inventory_item_id,
531: 5,
532: l_demand_rsvs_ordered(i).reservation_quantity,
533: l_demand_rsvs_ordered(i).reservation_uom_code,
534: INV_CACHE.item_rec.primary_uom_code,
535: NULL,
536: NULL);
537: -- Added the else part for Bug 13910013
538: ELSE

Line 566: log_event(l_api_name, 'Suggest_Reservations','Update the INV Cache');

562: END IF; -- End of Bug 13910013
563:
564: IF ( l_debug = 1 ) THEN
565: log_event(l_api_name, 'Suggest_Reservations','Updated number of rows: ' || SQL%ROWCOUNT);
566: log_event(l_api_name, 'Suggest_Reservations','Update the INV Cache');
567: END IF;
568:
569: l_update_mol := INV_CACHE.set_mol_rec(p_mo_line_rec.line_id);
570:

Line 569: l_update_mol := INV_CACHE.set_mol_rec(p_mo_line_rec.line_id);

565: log_event(l_api_name, 'Suggest_Reservations','Updated number of rows: ' || SQL%ROWCOUNT);
566: log_event(l_api_name, 'Suggest_Reservations','Update the INV Cache');
567: END IF;
568:
569: l_update_mol := INV_CACHE.set_mol_rec(p_mo_line_rec.line_id);
570:
571: IF ( l_debug = 1 ) THEN
572: log_event(l_api_name, 'Suggest_Reservations','Update the p_mo_line_rec');
573: END IF;