[Home] [Help]
4: -- Global constant holding the package name
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
690: select decode(revision_qty_control_code, 2, 'Y', 'N')
691: into l_revision_controlled
692: from mtl_system_items
693: where inventory_item_id = p_line_rec.inventory_item_id
694: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
695: Exception
696: When NO_DATA_FOUND Then
697: l_revision_controlled := 'N';
698: End;
976: END IF;
977: inv_decimals_pub.validate_quantity(
978: p_item_id => p_item_id,
979: p_organization_id =>
980: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'),
981: p_input_quantity => p_input_quantity,
982: p_uom_code => p_uom_code,
983: x_output_quantity => l_validated_quantity,
984: x_primary_quantity => l_primary_quantity,
1076: INTO l_indivisible_flag
1077: FROM mtl_system_items
1078: WHERE inventory_item_id = p_line_rec.inventory_item_id
1079: AND organization_id =
1080: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1081:
1082: IF nvl(l_indivisible_flag, 'N') = 'N' THEN
1083: IF l_debug_level > 0 THEN
1084: OE_DEBUG_PUB.ADD('this Option can have decimal ratio', 1);
1630: l_dummy VARCHAR2(10);
1631:
1632: /* added for 2219230 */
1633: l_org_flag NUMBER := 2;
1634: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
1635: CURSOR xref IS
1636: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1637: DECODE(items.organization_id, item_val_org, 1, 2))
1638: FROM mtl_cross_reference_types types
1699: SELECT 'valid'
1700: INTO l_dummy
1701: FROM mtl_system_items_b
1702: WHERE inventory_item_id = p_inventory_item_id
1703: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1704: AND internal_order_enabled_flag = 'Y';
1705: ELSE /* other orders except Internal*/
1706: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1707: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1713: SELECT 'valid'
1714: INTO l_dummy
1715: FROM mtl_system_items_b
1716: WHERE inventory_item_id = p_inventory_item_id
1717: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
1718: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1719:
1720: /* Change for bug 1805985
1721: -------------------------------------------------------
1752: /*SELECT 'valid'
1753: INTO l_dummy
1754: FROM mtl_system_items_b
1755: WHERE inventory_item_id = p_inventory_item_id
1756: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1757: AND customer_order_enabled_flag = 'Y'; */
1758: -- end bug 4171642
1759:
1760: END IF;
1783: /*SELECT 'valid'
1784: INTO l_dummy
1785: FROM mtl_system_items_b
1786: WHERE inventory_item_id = p_inventory_item_id
1787: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1788: AND customer_order_enabled_flag = 'Y'; */
1789: -- End bug 4171642
1790: END IF;
1791: END IF;
1808: WHERE citems.customer_item_id = cxref.customer_item_id
1809: AND cxref.inventory_item_id = sitems.inventory_item_id
1810: AND sitems.inventory_item_id = p_inventory_item_id
1811: AND sitems.organization_id =
1812: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1813: AND sitems.customer_order_enabled_flag = 'Y' -- bug 3835602
1814: AND citems.customer_item_id = p_ordered_item_id
1815: AND citems.customer_id = p_sold_to_org_id
1816: AND citems.inactive_flag = 'N'
1829: WHERE citems.customer_item_id = cxref.customer_item_id
1830: AND cxref.inventory_item_id = sitems.inventory_item_id
1831: AND sitems.inventory_item_id = p_inventory_item_id
1832: AND sitems.organization_id =
1833: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1834: AND citems.customer_item_id = p_ordered_item_id
1835: AND citems.customer_id = p_sold_to_org_id
1836: AND mp.organization_id = sitems.organization_id -- 4402603
1837: AND cxref.master_organization_id = mp.master_organization_id ; -- 4402603
2058: INTO l_returnable_flag
2059: FROM mtl_system_items_b
2060: WHERE inventory_item_id = p_inventory_item_id
2061: and organization_id = nvl(p_ship_from_org_id,
2062: oe_sys_parameters.value_wnps('MASTER_ORGANIZATION_ID')); */
2063:
2064: -- bug 4171642
2065:
2066: IF l_returnable_flag = 'Y' THEN
2277: oe_debug_pub.add('Entering Validate_ship_to_org',1);
2278: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
2279: END IF;
2280:
2281: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2282:
2283: IF nvl(lcustomer_relations,'N') = 'N' THEN
2284:
2285: Select 'VALID'
2360: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2361: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2362: END IF;
2363:
2364: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2365:
2366: IF nvl(lcustomer_relations,'N') = 'N' THEN
2367: SELECT 'VALID'
2368: INTO l_dummy
2750: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2751: AND org.organization_id= msi.organization_id
2752: AND sysdate <= nvl( org.disable_date, sysdate)
2753: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
2754: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2755: IF l_debug_level > 0 then
2756: OE_DEBUG_PUB.Add('Pack-J Across SOB',2);
2757: END IF;
2758: ELSE
2763: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2764: AND org.organization_id= msi.organization_id
2765: AND sysdate <= nvl( org.disable_date, sysdate)
2766: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
2767: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'))
2768: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
2769: FROM financials_system_parameters fsp);
2770: IF l_debug_level > 0 then
2771: OE_DEBUG_PUB.Add('Pre Pack-J Logic',2);
2775: IF l_purchasing_enabled_flag = 'N' THEN
2776: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2777: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2778: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2779: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2780: OE_MSG_PUB.Add;
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;
2783:
2986: --FOR BUG 3192386
2987: l_flow_status_code VARCHAR2(30);
2988: -- Bug 3232544
2989: lcustomer_relations varchar2(1) :=
2990: OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2991: l_exists varchar2(1);
2992: --For Bug 3257240
2993: l_customer_name VARCHAR2(240);
2994: l_customer_number NUMBER;
3139: AND NVL(BH.TRANSACTION_PHASE_CODE,'F')='F'
3140: AND NVL(BH.DRAFT_SUBMITTED_FLAG,'Y') = 'Y';
3141:
3142: -- Set Item validation org parameter value
3143: l_item_val_org := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
3144:
3145: -- Blanket/Item Validations
3146:
3147: IF p_line_rec.inventory_item_id IS NOT NULL
3669: l_price_list_name VARCHAR2(240);
3670: l_option_count NUMBER;
3671: l_is_ota_line BOOLEAN;
3672: l_order_quantity_uom VARCHAR2(3);
3673: lcustomer_relations varchar2(1) := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
3674: l_list_type_code VARCHAR2(30);
3675: l_currency_code VARCHAR2(30);
3676: l_hdr_currency_code VARCHAR2(30);
3677: l_restrict_subinv NUMBER;
3701:
3702: l_top_container_model VARCHAR2(1);
3703: l_part_of_container VARCHAR2(1);
3704: l_item_description VARCHAR2(240);
3705: l_mast_org_id NUMBER := OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3706: CURSOR pick_status IS
3707: SELECT RELEASED_STATUS, SRC_REQUESTED_QUANTITY,
3708: SRC_REQUESTED_QUANTITY2
3709: FROM WSH_DELIVERY_DETAILS
5648: AND TRUNC(p_line_rec.tax_date) BETWEEN TRUNC(V.START_DATE) AND
5649: TRUNC(NVL(V.END_DATE, p_line_rec.tax_date))
5650: AND ROWNUM = 1;
5651: Else
5652: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
5653: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
5654:
5655: SELECT 'VALID'
5656: INTO l_dummy
5943: INTO l_uom
5944: FROM mtl_system_items_b
5945: WHERE inventory_item_id = p_line_rec.inventory_item_id
5946: AND organization_id = nvl(p_line_rec.ship_from_org_id,
5947: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
5948: */
5949: -- end bug 4171642
5950: IF l_debug_level > 0 then
5951: oe_debug_pub.add('primary uom: '|| l_uom, 1);
5979: FROM mtl_item_uoms_view
5980: WHERE inventory_item_id = p_line_rec.inventory_item_id
5981: AND uom_code = p_line_rec.order_quantity_uom
5982: AND organization_id = nvl(p_line_rec.ship_from_org_id,
5983: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
5984:
5985:
5986: IF l_uom_count = 0 THEN
5987: IF l_debug_level > 0 then
5992: RAISE FND_API.G_EXC_ERROR;
5993: END IF;
5994:
5995: */
5996: l_ret_status := inv_convert.validate_item_uom(p_line_rec.order_quantity_uom,p_line_rec.inventory_item_id,nvl(p_line_rec.ship_from_org_id,OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')));
5997: IF NOT l_ret_status THEN
5998: IF l_debug_level > 0 then
5999: oe_debug_pub.add('uom/item combination invalid',2);
6000: END IF;
7404: END IF;
7405:
7406: IF OE_Validate.Charge_Periodicity (p_line_rec.charge_periodicity_code) THEN
7407:
7408: IF OE_SYS_PARAMETERS.Value ('RECURRING_CHARGES') = 'Y' THEN
7409:
7410: IF p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7411:
7412: IF p_line_rec.top_model_line_id IS NOT NULL THEN
7434: --INTO l_item_description
7435: --FROM MTL_SYSTEM_ITEMS mtl_msi
7436: --WHERE mtl_msi.inventory_item_id = p_line_rec.inventory_item_id
7437: --AND mtl_msi.organization_id =
7438: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7439:
7440: FND_MESSAGE.SET_NAME('ONT','ONT_NO_RC_ALLOWED');
7441: --FND_MESSAGE.SET_TOKEN('ITEM',l_item_description);
7442: OE_MSG_PUB.Add;