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

Line 11292: IF inv_cache.set_item_rec( p_org_id , p_item_id) THEN

11288: --/* Bug 9448490 Lot Substitution Project */ end
11289:
11290: --check ship tolerance
11291:
11292: IF inv_cache.set_item_rec( p_org_id , p_item_id) THEN
11293: l_lot_divisible_flag := NVL(inv_cache.item_rec.lot_divisible_flag,'Y');
11294: ELSE
11295: IF (l_debug = 1) THEN
11296: mydebug('item_rec not set in inv_cache');

Line 11293: l_lot_divisible_flag := NVL(inv_cache.item_rec.lot_divisible_flag,'Y');

11289:
11290: --check ship tolerance
11291:
11292: IF inv_cache.set_item_rec( p_org_id , p_item_id) THEN
11293: l_lot_divisible_flag := NVL(inv_cache.item_rec.lot_divisible_flag,'Y');
11294: ELSE
11295: IF (l_debug = 1) THEN
11296: mydebug('item_rec not set in inv_cache');
11297: END IF;

Line 11296: mydebug('item_rec not set in inv_cache');

11292: IF inv_cache.set_item_rec( p_org_id , p_item_id) THEN
11293: l_lot_divisible_flag := NVL(inv_cache.item_rec.lot_divisible_flag,'Y');
11294: ELSE
11295: IF (l_debug = 1) THEN
11296: mydebug('item_rec not set in inv_cache');
11297: END IF;
11298: RAISE fnd_api.g_exc_unexpected_error;
11299: END IF;
11300:

Line 12223: IF inv_cache.set_item_rec(p_org_id,p_item_id) THEN

12219: END IF;
12220: -- OPEN lot_csr;
12221: --/* Bug 9448490 Lot Substitution Project */ end
12222:
12223: IF inv_cache.set_item_rec(p_org_id,p_item_id) THEN
12224: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
12225: l_dual_uom_item := TRUE;
12226: IF (l_debug = 1) THEN
12227: mydebug('Item is dual UOM');

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

12220: -- OPEN lot_csr;
12221: --/* Bug 9448490 Lot Substitution Project */ end
12222:
12223: IF inv_cache.set_item_rec(p_org_id,p_item_id) THEN
12224: IF inv_cache.item_rec.tracking_quantity_ind = 'PS' THEN
12225: l_dual_uom_item := TRUE;
12226: IF (l_debug = 1) THEN
12227: mydebug('Item is dual UOM');
12228: END IF;

Line 12237: mydebug('Error from inv_cache.set_item_rec');

12233: END IF;
12234: END IF;
12235: ELSE
12236: IF (l_debug = 1) THEN
12237: mydebug('Error from inv_cache.set_item_rec');
12238: END IF;
12239: RAISE fnd_api.g_exc_unexpected_error;
12240: END IF;
12241:

Line 14928: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN

14924: mydebug('p_trx_qty in transaction uom:'|| p_trx_qty);
14925: END IF;
14926:
14927: --12871057 Begin Fetching the action and source type from cache for the txn type id
14928: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN
14929: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
14930: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
14931: ELSE
14932: RAISE fnd_api.g_exc_unexpected_error;

Line 14929: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

14925: END IF;
14926:
14927: --12871057 Begin Fetching the action and source type from cache for the txn type id
14928: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN
14929: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
14930: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
14931: ELSE
14932: RAISE fnd_api.g_exc_unexpected_error;
14933: END IF;

Line 14930: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

14926:
14927: --12871057 Begin Fetching the action and source type from cache for the txn type id
14928: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN
14929: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
14930: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
14931: ELSE
14932: RAISE fnd_api.g_exc_unexpected_error;
14933: END IF;
14934:

Line 15924: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN

15920: mydebug('l_primary_uom :'|| l_primary_uom);
15921: mydebug('p_trx_qty in transaction uom:'|| p_trx_qty);
15922: END IF;
15923:
15924: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN
15925: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
15926: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
15927: ELSE
15928: RAISE fnd_api.g_exc_unexpected_error;

Line 15925: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;

15921: mydebug('p_trx_qty in transaction uom:'|| p_trx_qty);
15922: END IF;
15923:
15924: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN
15925: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
15926: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
15927: ELSE
15928: RAISE fnd_api.g_exc_unexpected_error;
15929: END IF;

Line 15926: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

15922: END IF;
15923:
15924: IF inv_cache.set_mtt_rec(p_transaction_type_id) THEN
15925: l_transaction_action_id := inv_cache.mtt_rec.transaction_action_id;
15926: l_txn_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;
15927: ELSE
15928: RAISE fnd_api.g_exc_unexpected_error;
15929: END IF;
15930: