DBA Data[Home] [Help]

APPS.WMS_POSTALLOC_PVT dependencies on INV_CACHE

Line 329: IF ( inv_cache.set_org_rec( p_organization_id ) ) THEN

325:
326: -- If no Operation Plan rule gets applied,
327: -- stamp the org default outbound operation plan
328: IF ( l_rule_applied <> TRUE ) THEN
329: IF ( inv_cache.set_org_rec( p_organization_id ) ) THEN
330: l_mmtt_hid(ii) := NVL(inv_cache.org_rec.default_pick_op_plan_id,1);
331: ELSE
332: IF g_debug = 1 THEN
333: print_debug ( 'Error setting cache for organization', l_api_name );

Line 330: l_mmtt_hid(ii) := NVL(inv_cache.org_rec.default_pick_op_plan_id,1);

326: -- If no Operation Plan rule gets applied,
327: -- stamp the org default outbound operation plan
328: IF ( l_rule_applied <> TRUE ) THEN
329: IF ( inv_cache.set_org_rec( p_organization_id ) ) THEN
330: l_mmtt_hid(ii) := NVL(inv_cache.org_rec.default_pick_op_plan_id,1);
331: ELSE
332: IF g_debug = 1 THEN
333: print_debug ( 'Error setting cache for organization', l_api_name );
334: END IF;

Line 360: IF (inv_cache.set_org_rec(p_organization_id) ) THEN

356: --}
357: ELSE --{
358: -- If there is no operation plan selection rule enabled,
359: -- stamp the org default outbound operation plan
360: IF (inv_cache.set_org_rec(p_organization_id) ) THEN
361: l_op_plan_id := NVL(inv_cache.org_rec.default_pick_op_plan_id,1);
362: ELSE
363: IF g_debug = 1 THEN
364: print_debug('Error setting cache for organization', l_api_name);

Line 361: l_op_plan_id := NVL(inv_cache.org_rec.default_pick_op_plan_id,1);

357: ELSE --{
358: -- If there is no operation plan selection rule enabled,
359: -- stamp the org default outbound operation plan
360: IF (inv_cache.set_org_rec(p_organization_id) ) THEN
361: l_op_plan_id := NVL(inv_cache.org_rec.default_pick_op_plan_id,1);
362: ELSE
363: IF g_debug = 1 THEN
364: print_debug('Error setting cache for organization', l_api_name);
365: END IF;

Line 3849: IF NOT INV_CACHE.set_mtrh_rec(p_mo_header_id) THEN

3845: , l_api_name);
3846: END IF;
3847:
3848: -- Cache the move order header info
3849: IF NOT INV_CACHE.set_mtrh_rec(p_mo_header_id) THEN
3850: IF g_debug = 1 THEN
3851: print_debug( 'Error from INV_CACHE.set_mtrh_rec', l_api_name);
3852: END IF;
3853: RAISE fnd_api.g_exc_unexpected_error;

Line 3851: print_debug( 'Error from INV_CACHE.set_mtrh_rec', l_api_name);

3847:
3848: -- Cache the move order header info
3849: IF NOT INV_CACHE.set_mtrh_rec(p_mo_header_id) THEN
3850: IF g_debug = 1 THEN
3851: print_debug( 'Error from INV_CACHE.set_mtrh_rec', l_api_name);
3852: END IF;
3853: RAISE fnd_api.g_exc_unexpected_error;
3854: END IF;
3855:

Line 3859: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;

3855:
3856: SELECT spg.bulk_pick_control
3857: INTO l_bulk_pick_control
3858: FROM wsh_pick_grouping_rules spg
3859: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;
3860:
3861: -- If bulk picking is not enabled then RETURN
3862: IF l_bulk_pick_control IS NULL THEN
3863: l_bulk_pick_control := WMS_GLOBALS.BULK_PICK_SUB_ITEM;

Line 3873: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;

3869: RETURN;
3870: END IF;
3871: END IF;
3872:
3873: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;
3874:
3875: IF l_move_order_type <> inv_globals.g_move_order_pick_wave THEN
3876: IF (g_debug = 1) THEN
3877: print_debug('Move Order is a not pick wave move order', l_api_name );

Line 4507: IF inv_cache.set_item_rec(l_organization_id, l_item_id) THEN

4503: g_hash_split_inv_item_id_tbl(l_hash_split_fac_value) := l_item_id;
4504: g_hash_split_std_op_id_tbl(l_hash_split_fac_value) := l_std_op_id;
4505: g_hash_split_fac_tbl(l_hash_split_fac_value) := -9999;
4506:
4507: IF inv_cache.set_item_rec(l_organization_id, l_item_id) THEN
4508: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
4509: l_item_w_uom := inv_cache.item_rec.weight_uom_code;
4510: l_item_weight := inv_cache.item_rec.unit_weight;
4511: l_item_vol := inv_cache.item_rec.unit_volume;

Line 4508: l_item_v_uom := inv_cache.item_rec.volume_uom_code;

4504: g_hash_split_std_op_id_tbl(l_hash_split_fac_value) := l_std_op_id;
4505: g_hash_split_fac_tbl(l_hash_split_fac_value) := -9999;
4506:
4507: IF inv_cache.set_item_rec(l_organization_id, l_item_id) THEN
4508: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
4509: l_item_w_uom := inv_cache.item_rec.weight_uom_code;
4510: l_item_weight := inv_cache.item_rec.unit_weight;
4511: l_item_vol := inv_cache.item_rec.unit_volume;
4512: END IF ;

Line 4509: l_item_w_uom := inv_cache.item_rec.weight_uom_code;

4505: g_hash_split_fac_tbl(l_hash_split_fac_value) := -9999;
4506:
4507: IF inv_cache.set_item_rec(l_organization_id, l_item_id) THEN
4508: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
4509: l_item_w_uom := inv_cache.item_rec.weight_uom_code;
4510: l_item_weight := inv_cache.item_rec.unit_weight;
4511: l_item_vol := inv_cache.item_rec.unit_volume;
4512: END IF ;
4513:

Line 4510: l_item_weight := inv_cache.item_rec.unit_weight;

4506:
4507: IF inv_cache.set_item_rec(l_organization_id, l_item_id) THEN
4508: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
4509: l_item_w_uom := inv_cache.item_rec.weight_uom_code;
4510: l_item_weight := inv_cache.item_rec.unit_weight;
4511: l_item_vol := inv_cache.item_rec.unit_volume;
4512: END IF ;
4513:
4514: IF (( l_item_v_uom IS NOT NULL AND l_item_vol IS NOT NULL )

Line 4511: l_item_vol := inv_cache.item_rec.unit_volume;

4507: IF inv_cache.set_item_rec(l_organization_id, l_item_id) THEN
4508: l_item_v_uom := inv_cache.item_rec.volume_uom_code;
4509: l_item_w_uom := inv_cache.item_rec.weight_uom_code;
4510: l_item_weight := inv_cache.item_rec.unit_weight;
4511: l_item_vol := inv_cache.item_rec.unit_volume;
4512: END IF ;
4513:
4514: IF (( l_item_v_uom IS NOT NULL AND l_item_vol IS NOT NULL )
4515: OR ( l_item_w_uom IS NOT NULL AND l_item_weight IS NOT NULL ))

Line 5181: IF ( inv_cache.set_org_rec( p_organization_id ) ) THEN

5177:
5178: -- If no Task type rule gets applied,
5179: -- stamp the org default task type
5180: IF ( l_rule_applied <> TRUE ) THEN
5181: IF ( inv_cache.set_org_rec( p_organization_id ) ) THEN
5182: l_mmtt_hid(ii) := inv_cache.org_rec.default_pick_task_type_id;
5183: ELSE
5184: IF g_debug = 1 THEN
5185: print_debug ( 'Error setting cache for organization', l_api_name );

Line 5182: l_mmtt_hid(ii) := inv_cache.org_rec.default_pick_task_type_id;

5178: -- If no Task type rule gets applied,
5179: -- stamp the org default task type
5180: IF ( l_rule_applied <> TRUE ) THEN
5181: IF ( inv_cache.set_org_rec( p_organization_id ) ) THEN
5182: l_mmtt_hid(ii) := inv_cache.org_rec.default_pick_task_type_id;
5183: ELSE
5184: IF g_debug = 1 THEN
5185: print_debug ( 'Error setting cache for organization', l_api_name );
5186: END IF;

Line 5211: IF (inv_cache.set_org_rec(p_organization_id) ) THEN

5207: --}
5208: ELSE --{
5209: -- If there is no task type rule enabled,
5210: -- stamp the org default task type
5211: IF (inv_cache.set_org_rec(p_organization_id) ) THEN
5212: l_task_type_id := inv_cache.org_rec.default_pick_task_type_id;
5213: ELSE
5214: IF g_debug = 1 THEN
5215: print_debug('Error setting cache for organization', l_api_name);

Line 5212: l_task_type_id := inv_cache.org_rec.default_pick_task_type_id;

5208: ELSE --{
5209: -- If there is no task type rule enabled,
5210: -- stamp the org default task type
5211: IF (inv_cache.set_org_rec(p_organization_id) ) THEN
5212: l_task_type_id := inv_cache.org_rec.default_pick_task_type_id;
5213: ELSE
5214: IF g_debug = 1 THEN
5215: print_debug('Error setting cache for organization', l_api_name);
5216: END IF;