APPS.INV_MATERIAL_STATUS_GRP dependencies on WMS_CONTAINER_PUB

Line 2788: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,

2784: x_return_status_id :=NULL;
2785: RETURN;
2786: END;
2787: END IF;
2788: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
2789: WMS_Container_PUB.LPN_CONTEXT_VENDOR) THEN
2790: IF(g_debug = 1)THEN
2791: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
2792: END IF;

Line 2789: WMS_Container_PUB.LPN_CONTEXT_VENDOR) THEN

2785: RETURN;
2786: END;
2787: END IF;
2788: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
2789: WMS_Container_PUB.LPN_CONTEXT_VENDOR) THEN
2790: IF(g_debug = 1)THEN
2791: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
2792: END IF;
2793: l_return_status_id := NULL; --if lpn_context is 5 or 7 lpn status should be NULL

Line 2794: ELSIF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_STORES,

2790: IF(g_debug = 1)THEN
2791: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
2792: END IF;
2793: l_return_status_id := NULL; --if lpn_context is 5 or 7 lpn status should be NULL
2794: ELSIF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_STORES,
2795: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN
2796:
2797: SELECT default_status_id
2798: INTO l_def_org_status

Line 2795: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN

2791: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
2792: END IF;
2793: l_return_status_id := NULL; --if lpn_context is 5 or 7 lpn status should be NULL
2794: ELSIF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_STORES,
2795: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN
2796:
2797: SELECT default_status_id
2798: INTO l_def_org_status
2799: FROM mtl_parameters

Line 2807: IF (l_lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING )THEN--wlc don't exists for the lpn therefore checking mmtt

2803: END IF;
2804: l_return_status_id := l_def_org_status; --If lpn_context is 4 or 6 lpn status should be derived from default org parameters
2805: ELSE
2806:
2807: IF (l_lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING )THEN--wlc don't exists for the lpn therefore checking mmtt
2808: IF(g_debug = 1)THEN
2809: inv_trx_util_pub.TRACE('WLC is not there and no child record is there for the lpn therefor querying mmtt for details','INV_MATERIAL_STATUS_GRP',9);
2810: END IF;
2811: FOR l_mmtt_cur IN mmtt_cur

Line 3322: if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then

3318: inv_trx_util_pub.TRACE('LPN Sub: '|| l_lpn_sub,'inv_material_status_grp', 9);
3319: inv_trx_util_pub.TRACE('LPN Locator: '|| l_lpn_loc,'inv_material_status_grp', 9);
3320: END IF;
3321:
3322: if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then
3323:
3324: IF p_trx_type_id IS NULL THEN
3325: -- This will execute only for Putaway pages not for cycle count pages.
3326: l_trx_type_id:=64; -- Move order Transfer

Line 3374: elsif l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_RCV or

3370:
3371: END LOOP; --FOR l_cur_wlc IN c_lpn_item
3372:
3373:
3374: elsif l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_RCV or
3375: l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP then
3376: -- LPN is in receiving or WIP
3377: IF(g_debug = 1)THEN
3378: inv_trx_util_pub.TRACE('LPN is in Receiving:','inv_material_status_grp', 9);

Line 3375: l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP then

3371: END LOOP; --FOR l_cur_wlc IN c_lpn_item
3372:
3373:
3374: elsif l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_RCV or
3375: l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP then
3376: -- LPN is in receiving or WIP
3377: IF(g_debug = 1)THEN
3378: inv_trx_util_pub.TRACE('LPN is in Receiving:','inv_material_status_grp', 9);
3379: END IF;

Line 3381: --IF p_trx_type_id IS NULL AND l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP THEN

3377: IF(g_debug = 1)THEN
3378: inv_trx_util_pub.TRACE('LPN is in Receiving:','inv_material_status_grp', 9);
3379: END IF;
3380:
3381: --IF p_trx_type_id IS NULL AND l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP THEN
3382: --p_trx_type_id:=43; -- WIP Component Return.
3383: --END IF;
3384:
3385:

Line 3489: --elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then

3485: inv_trx_util_pub.TRACE('Completed one iteration');
3486: END IF;
3487: END LOOP; --FOR l_cur_wlc IN c_lpn_item
3488:
3489: --elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then
3490: -- LPN is in packing context.
3491: --l_trx_allowed_count:=l_trx_allowed_count+1;
3492: --l_trx_allowed_count:=l_trx_allowed_count-1;
3493: elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then

Line 3493: elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then

3489: --elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then
3490: -- LPN is in packing context.
3491: --l_trx_allowed_count:=l_trx_allowed_count+1;
3492: --l_trx_allowed_count:=l_trx_allowed_count-1;
3493: elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then
3494: inv_trx_util_pub.TRACE('LPN is in Packing context');
3495: inv_trx_util_pub.TRACE('Querying MMTT to get the status id and transaction type id');
3496:
3497: FOR l_mmtt_cur IN mmtt_cur(p_inventory_item_id)

Line 3657: end if; --if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then

3653: inv_trx_util_pub.TRACE('Completed one iteration of the MMTT');
3654: END LOOP; -- FOR l_mmtt_cur IN mmtt_cur(p_inventory_item_id)
3655:
3656:
3657: end if; --if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then
3658:
3659:
3660: IF(g_debug = 1)THEN
3661: inv_trx_util_pub.TRACE('Before returning the from API is_trx_allow_lpns','Material Status', 9);