[Home] [Help]
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Line';
7: --var added for bug 4171642
8: g_master_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ;
9: --g_cust_ord_enabled_flag varchar2(1):=nvl(FND_PROFILE.Value('ONT_VAL_CUST_ORD_ENABLED_FLAG'),'N'); --bug4343544
10: -- LOCAL PROCEDURES
11:
12: -- QUOTING changes
13: /*-------------------------------------------------------
1913: RETURN TRUE;
1914: END IF;
1915:
1916: -- Check Profile Option to see if allow item mismatch
1917: l_profile := FND_PROFILE.value('ONT_RETURN_ITEM_MISMATCH_ACTION');
1918:
1919: IF (l_profile is NULL OR l_profile = 'A') THEN
1920: RETURN TRUE;
1921: ELSE
1972: RETURN TRUE;
1973: END IF;
1974:
1975: -- Check Profile Option to see if allow item mismatch
1976: l_profile := FND_PROFILE.value('ONT_RETURN_FULFILLED_LINE_ACTION');
1977:
1978: IF (l_profile is NULL OR l_profile = 'A') THEN
1979: RETURN TRUE;
1980:
2622: IF p_line_rec.commitment_id IS NOT NULL AND
2623: p_line_rec.commitment_id <> FND_API.G_MISS_NUM THEN
2624:
2625: l_class := NULL;
2626: l_oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2627: l_oe_installed_flag := 'I';
2628: IF l_debug_level > 0 then
2629: OE_DEBUG_PUB.Add('Before calling ARP_BAL_UTIL.GET_COMMITMENT_BALANCE');
2630: END IF;
4054: -- because defaulting can be defaulting an expense sub
4055: -- and the INV profile is set to No.
4056: IF l_debug_level > 0 then
4057: oe_debug_pub.add('Entity: p_line_rec.order_source_id:' || p_line_rec.order_source_id, 5);
4058: oe_debug_pub.add('Entity: profile expense_asset:' || fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER'), 5);
4059: END IF;
4060: /* fix bug 2570174, check for restricted subinv */
4061: BEGIN
4062: -- bug 4171642
4108: into l_dummy
4109: from mtl_subinventories_trk_val_v sub
4110: where sub.organization_id = p_line_rec.ship_from_org_id
4111: and sub.secondary_inventory_name = p_line_rec.subinventory
4112: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
4113: OR
4114: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4115: and nvl(p_line_rec.order_source_id, -1) <> 10
4116: )
4110: where sub.organization_id = p_line_rec.ship_from_org_id
4111: and sub.secondary_inventory_name = p_line_rec.subinventory
4112: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
4113: OR
4114: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4115: and nvl(p_line_rec.order_source_id, -1) <> 10
4116: )
4117: OR
4118: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4114: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4115: and nvl(p_line_rec.order_source_id, -1) <> 10
4116: )
4117: OR
4118: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4119: and nvl(p_line_rec.order_source_id, -1) = 10
4120: and 'N' = (select inventory_asset_flag
4121: from mtl_system_items
4122: where inventory_item_id = p_line_rec.inventory_item_id
4122: where inventory_item_id = p_line_rec.inventory_item_id
4123: and organization_id = p_line_rec.ship_from_org_id)
4124: )
4125: OR
4126: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4127: and nvl(p_line_rec.order_source_id, -1) = 10
4128: and 'Y' = (select inventory_asset_flag
4129: from mtl_system_items
4130: where inventory_item_id = p_line_rec.inventory_item_id
5483: BEGIN
5484: IF l_debug_level > 0 then
5485: oe_debug_pub.add('invoice_to_org_id :'||to_char(p_line_rec.invoice_to_org_id),2);
5486: END IF;
5487: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
5488:
5489: IF nvl(lcustomer_relations,'N') = 'N' THEN
5490:
5491: Select 'VALID'