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 598: IF NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) <> 1 THEN

594: c_api_name varchar2(30) := 'is_trx_allowed';
595: BEGIN
596: -- Onhand Material Status Support : Return true if the material status profile is not enabled.
597: -- Added this check as now we are calling this method from QtyManager.
598: IF NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) <> 1 THEN
599: RETURN 'Y';
600: END IF;
601:
602: -- Onhand Material Status Support : Return true if status_id or transaction_type_id is null

Line 818: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');

814: l_default_serial_status_id number;
815: l_wms_installed varchar2(30);
816: --ERES Deferred
817: l_pending_eres_chk NUMBER :=0;
818: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
819: g_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_DEF_ERES_ENABLED'), 'N');
820: -- New variables for MACD Validations
821: --l_old_item_id NUMBER := FND_API.g_miss_num;
822: l_item_trackable VARCHAR2(1) := 'N';

Line 819: g_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_DEF_ERES_ENABLED'), 'N');

815: l_wms_installed varchar2(30);
816: --ERES Deferred
817: l_pending_eres_chk NUMBER :=0;
818: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
819: g_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_DEF_ERES_ENABLED'), 'N');
820: -- New variables for MACD Validations
821: --l_old_item_id NUMBER := FND_API.g_miss_num;
822: l_item_trackable VARCHAR2(1) := 'N';
823: l_freeze_flag VARCHAR2(1) := NULL;

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

839:
840: BEGIN
841: --INCONV kkillams
842: -- Bug 4121999
843: IF NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'),2) <> 1 THEN
844: RETURN 'Y';
845: END IF;
846: --END INCONV kkillams
847:

Line 2376: l_wip_lot_return := NVL(FND_PROFILE.VALUE('INV_DEFAULT_LOT_STATUS_FOR_RETURN'),2);

2372: -- WIP component return transaction the original onhand record's status_id needs to
2373: -- be stamped onto the new onhand record.
2374:
2375: If (p_transaction_action_id = 27 and p_txn_source_type_id = 5 and p_lot_number is not null) then
2376: l_wip_lot_return := NVL(FND_PROFILE.VALUE('INV_DEFAULT_LOT_STATUS_FOR_RETURN'),2);
2377: If(l_wip_lot_return=2) THEN
2378: If(p_txn_source_id is not null) then
2379: if (g_debug = 1) then
2380: inv_trx_util_pub.TRACE('src id ' || p_txn_source_id, 'INV_MATERIAL_STATUS_GRP', 14);

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

3545: l_count NUMBER;
3546: l_comingle VARCHAR2(1):= 'N' ;
3547: l_allow_diff_status VARCHAR2(1) ;
3548: l_progress VARCHAR2(15);
3549: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3550:
3551: BEGIN
3552: /* Have to check the exact meaning of With Exception for plain items.*/
3553: /*

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

3720: p_xfer_locator_id IN NUMBER,
3721: p_xfer_org_id IN NUMBER)
3722: RETURN NUMBER IS
3723:
3724: l_allow_mixed_status number := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);
3725: l_lpn_context number;
3726: l_return_status number :=-1;
3727: l_lpn_loc number;
3728: l_lpn_sub VARCHAR2(30);