APPS.INV_MATERIAL_STATUS_GRP dependencies on FND_PROFILE

Line 41: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

37: g_transaction_action_id NUMBER;
38: g_transaction_source_type_id NUMBER;
39:
40: -- Onhand Material Status Support
41: g_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
42: g_sub_code VARCHAR2(10);
43: g_locator_control NUMBER;
44: -- Onhand Material Status Support
45:

Line 68: l_allow_mixed_status number := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);

64: p_xfer_locator_id IN NUMBER,
65: p_xfer_org_id IN NUMBER)
66: RETURN NUMBER IS
67:
68: l_allow_mixed_status number := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);
69: l_allow_status VARCHAR2(1):='Y';
70: l_allow_transaction VARCHAR2(1):='Y';
71: l_serial_controlled number := 0;
72: l_serial_status_enabled number := 0;

Line 584: IF NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) <> 1 THEN

580: c_api_name varchar2(30) := 'is_trx_allowed';
581: BEGIN
582: -- Onhand Material Status Support : Return true if the material status profile is not enabled.
583: -- Added this check as now we are calling this method from QtyManager.
584: IF NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) <> 1 THEN
585: RETURN 'Y';
586: END IF;
587:
588: -- Onhand Material Status Support : Return true if status_id or transaction_type_id is null

Line 821: IF NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) <> 1 THEN

817:
818: BEGIN
819: --INCONV kkillams
820: -- Bug 4121999
821: IF NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) <> 1 THEN
822: RETURN 'Y';
823: END IF;
824: --END INCONV kkillams
825:

Line 3018: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3014: l_count NUMBER;
3015: l_comingle VARCHAR2(1):= 'N' ;
3016: l_allow_diff_status VARCHAR2(1) ;
3017: l_progress VARCHAR2(15);
3018: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3019:
3020: BEGIN
3021: /* Have to check the exact meaning of With Exception for plain items.*/
3022: /*

Line 3193: l_allow_mixed_status number := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);

3189: p_xfer_locator_id IN NUMBER,
3190: p_xfer_org_id IN NUMBER)
3191: RETURN NUMBER IS
3192:
3193: l_allow_mixed_status number := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);
3194: l_lpn_context number;
3195: l_return_status number :=-1;
3196: l_lpn_loc number;
3197: l_lpn_sub VARCHAR2(30);