DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on FND_PROFILE

Line 9: --g_cust_ord_enabled_flag varchar2(1):=nvl(FND_PROFILE.Value('ONT_VAL_CUST_ORD_ENABLED_FLAG'),'N'); --bug4343544

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Line';
7: --var added for bug 4171642
8: g_master_org_id NUMBER; --Bug#12426110
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: /*-------------------------------------------------------

Line 1941: l_profile := FND_PROFILE.value('ONT_RETURN_ITEM_MISMATCH_ACTION');

1937: RETURN TRUE;
1938: END IF;
1939:
1940: -- Check Profile Option to see if allow item mismatch
1941: l_profile := FND_PROFILE.value('ONT_RETURN_ITEM_MISMATCH_ACTION');
1942:
1943: IF (l_profile is NULL OR l_profile = 'A') THEN
1944: RETURN TRUE;
1945: ELSE

Line 2000: l_profile := FND_PROFILE.value('ONT_RETURN_FULFILLED_LINE_ACTION');

1996: RETURN TRUE;
1997: END IF;
1998:
1999: -- Check Profile Option to see if allow item mismatch
2000: l_profile := FND_PROFILE.value('ONT_RETURN_FULFILLED_LINE_ACTION');
2001:
2002: IF (l_profile is NULL OR l_profile = 'A') THEN
2003: RETURN TRUE;
2004:

Line 2218: IF (nvl(fnd_profile.value('ONT_BYPASS_ISO_RMA_VAL'), 'N') = 'Y') THEN

2214: -- sol_ord_er #16014165 end
2215:
2216: IF l_source_document_type_id = 10 THEN
2217: --added for bug10631972
2218: IF (nvl(fnd_profile.value('ONT_BYPASS_ISO_RMA_VAL'), 'N') = 'Y') THEN
2219:
2220: -- If profile is not set to 'Y' we need not check for receiving activities
2221: -- by running the following queries
2222:

Line 2279: IF ((l_actid IS NOT NULL) OR (nvl(fnd_profile.value('ONT_BYPASS_ISO_RMA_VAL'), 'N') = 'N')) THEN

2275: oe_debug_pub.add('After receiving activity check l_actid : '||l_actid,1);
2276: END IF;
2277:
2278:
2279: IF ((l_actid IS NOT NULL) OR (nvl(fnd_profile.value('ONT_BYPASS_ISO_RMA_VAL'), 'N') = 'N')) THEN
2280: -- end changes for bug10631972
2281:
2282: fnd_message.set_name('ONT','OE_NO_RMA_FOR_INTERNAL_ORDER');
2283: OE_MSG_PUB.Add;

Line 2751: l_oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

2747: IF p_line_rec.commitment_id IS NOT NULL AND
2748: p_line_rec.commitment_id <> FND_API.G_MISS_NUM THEN
2749:
2750: l_class := NULL;
2751: l_oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2752: l_oe_installed_flag := 'I';
2753: IF l_debug_level > 0 then
2754: OE_DEBUG_PUB.Add('Before calling ARP_BAL_UTIL.GET_COMMITMENT_BALANCE');
2755: END IF;

Line 4358: oe_debug_pub.add('Entity: profile expense_asset:' || fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER'), 5);

4354: -- because defaulting can be defaulting an expense sub
4355: -- and the INV profile is set to No.
4356: IF l_debug_level > 0 then
4357: oe_debug_pub.add('Entity: p_line_rec.order_source_id:' || p_line_rec.order_source_id, 5);
4358: oe_debug_pub.add('Entity: profile expense_asset:' || fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER'), 5);
4359: END IF;
4360: /* fix bug 2570174, check for restricted subinv */
4361: BEGIN
4362: -- bug 4171642

Line 4412: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1

4408: into l_dummy
4409: from mtl_subinventories_trk_val_v sub
4410: where sub.organization_id = p_line_rec.ship_from_org_id
4411: and sub.secondary_inventory_name = p_line_rec.subinventory
4412: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
4413: OR
4414: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4415: and nvl(p_line_rec.order_source_id, -1) <> 10
4416: )

Line 4414: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

4410: where sub.organization_id = p_line_rec.ship_from_org_id
4411: and sub.secondary_inventory_name = p_line_rec.subinventory
4412: and (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') = 1
4413: OR
4414: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4415: and nvl(p_line_rec.order_source_id, -1) <> 10
4416: )
4417: OR
4418: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

Line 4418: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

4414: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4415: and nvl(p_line_rec.order_source_id, -1) <> 10
4416: )
4417: OR
4418: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4419: and nvl(p_line_rec.order_source_id, -1) = 10
4420: and 'N' = (select inventory_asset_flag
4421: from mtl_system_items
4422: where inventory_item_id = p_line_rec.inventory_item_id

Line 4426: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1

4422: where inventory_item_id = p_line_rec.inventory_item_id
4423: and organization_id = p_line_rec.ship_from_org_id)
4424: )
4425: OR
4426: (fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER') <> 1
4427: and nvl(p_line_rec.order_source_id, -1) = 10
4428: and 'Y' = (select inventory_asset_flag
4429: from mtl_system_items
4430: where inventory_item_id = p_line_rec.inventory_item_id

Line 5828: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');

5824: BEGIN
5825: IF l_debug_level > 0 then
5826: oe_debug_pub.add('invoice_to_org_id :'||to_char(p_line_rec.invoice_to_org_id),2);
5827: END IF;
5828: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
5829:
5830: IF nvl(lcustomer_relations,'N') = 'N' THEN
5831:
5832: Select 'VALID'