APPS.INV_MATERIAL_STATUS_GRP dependencies on WMS_CONTAINER_PUB

Line 3319: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,

3315: x_return_status_id :=NULL;
3316: RETURN;
3317: END;
3318: END IF;
3319: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3320: WMS_Container_PUB.LPN_CONTEXT_VENDOR) THEN
3321: IF(g_debug = 1)THEN
3322: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
3323: END IF;

Line 3320: WMS_Container_PUB.LPN_CONTEXT_VENDOR) THEN

3316: RETURN;
3317: END;
3318: END IF;
3319: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3320: WMS_Container_PUB.LPN_CONTEXT_VENDOR) THEN
3321: IF(g_debug = 1)THEN
3322: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
3323: END IF;
3324: l_return_status_id := NULL; --if lpn_context is 5 or 7 lpn status should be NULL

Line 3325: ELSIF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_STORES,

3321: IF(g_debug = 1)THEN
3322: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
3323: END IF;
3324: l_return_status_id := NULL; --if lpn_context is 5 or 7 lpn status should be NULL
3325: ELSIF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_STORES,
3326: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN
3327:
3328: SELECT default_status_id
3329: INTO l_def_org_status

Line 3326: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN

3322: inv_trx_util_pub.TRACE('LPN CONTEXT IS '||l_lpn_context||' Status should be NULL for that','INV_MATERIAL_STATUS_GRP',9);
3323: END IF;
3324: l_return_status_id := NULL; --if lpn_context is 5 or 7 lpn status should be NULL
3325: ELSIF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_STORES,
3326: WMS_Container_PUB.LPN_CONTEXT_INTRANSIT) THEN
3327:
3328: SELECT default_status_id
3329: INTO l_def_org_status
3330: FROM mtl_parameters

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

3334: END IF;
3335: l_return_status_id := l_def_org_status; --If lpn_context is 4 or 6 lpn status should be derived from default org parameters
3336: ELSE
3337:
3338: IF (l_lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING )THEN--wlc don't exists for the lpn therefore checking mmtt
3339: IF(g_debug = 1)THEN
3340: 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);
3341: END IF;
3342: FOR l_mmtt_cur IN mmtt_cur

Line 3858: if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then

3854: inv_trx_util_pub.TRACE('LPN Sub: '|| l_lpn_sub,'inv_material_status_grp', 9);
3855: inv_trx_util_pub.TRACE('LPN Locator: '|| l_lpn_loc,'inv_material_status_grp', 9);
3856: END IF;
3857:
3858: if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then
3859:
3860: IF p_trx_type_id IS NULL THEN
3861: -- This will execute only for Putaway pages not for cycle count pages.
3862: l_trx_type_id:=64; -- Move order Transfer

Line 3910: elsif l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_RCV or

3906:
3907: END LOOP; --FOR l_cur_wlc IN c_lpn_item
3908:
3909:
3910: elsif l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_RCV or
3911: l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP then
3912: -- LPN is in receiving or WIP
3913: IF(g_debug = 1)THEN
3914: inv_trx_util_pub.TRACE('LPN is in Receiving:','inv_material_status_grp', 9);

Line 3911: l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP then

3907: END LOOP; --FOR l_cur_wlc IN c_lpn_item
3908:
3909:
3910: elsif l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_RCV or
3911: l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP then
3912: -- LPN is in receiving or WIP
3913: IF(g_debug = 1)THEN
3914: inv_trx_util_pub.TRACE('LPN is in Receiving:','inv_material_status_grp', 9);
3915: END IF;

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

3913: IF(g_debug = 1)THEN
3914: inv_trx_util_pub.TRACE('LPN is in Receiving:','inv_material_status_grp', 9);
3915: END IF;
3916:
3917: --IF p_trx_type_id IS NULL AND l_lpn_context= WMS_Container_PUB.LPN_CONTEXT_WIP THEN
3918: --p_trx_type_id:=43; -- WIP Component Return.
3919: --END IF;
3920:
3921:

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

4021: inv_trx_util_pub.TRACE('Completed one iteration');
4022: END IF;
4023: END LOOP; --FOR l_cur_wlc IN c_lpn_item
4024:
4025: --elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then
4026: -- LPN is in packing context.
4027: --l_trx_allowed_count:=l_trx_allowed_count+1;
4028: --l_trx_allowed_count:=l_trx_allowed_count-1;
4029: elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then

Line 4029: elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then

4025: --elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then
4026: -- LPN is in packing context.
4027: --l_trx_allowed_count:=l_trx_allowed_count+1;
4028: --l_trx_allowed_count:=l_trx_allowed_count-1;
4029: elsif l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_PACKING then
4030: inv_trx_util_pub.TRACE('LPN is in Packing context');
4031: inv_trx_util_pub.TRACE('Querying MMTT to get the status id and transaction type id');
4032:
4033: FOR l_mmtt_cur IN mmtt_cur(p_inventory_item_id)

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

4189: inv_trx_util_pub.TRACE('Completed one iteration of the MMTT');
4190: END LOOP; -- FOR l_mmtt_cur IN mmtt_cur(p_inventory_item_id)
4191:
4192:
4193: end if; --if l_lpn_context=WMS_Container_PUB.LPN_CONTEXT_INV then
4194:
4195:
4196: IF(g_debug = 1)THEN
4197: inv_trx_util_pub.TRACE('Before returning the from API is_trx_allow_lpns','Material Status', 9);