[Home] [Help]
714: select decode(revision_qty_control_code, 2, 'Y', 'N')
715: into l_revision_controlled
716: from mtl_system_items
717: where inventory_item_id = p_line_rec.inventory_item_id
718: and organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
719: Exception
720: When NO_DATA_FOUND Then
721: l_revision_controlled := 'N';
722: End;
1000: END IF;
1001: inv_decimals_pub.validate_quantity(
1002: p_item_id => p_item_id,
1003: p_organization_id =>
1004: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'),
1005: p_input_quantity => p_input_quantity,
1006: p_uom_code => p_uom_code,
1007: x_output_quantity => l_validated_quantity,
1008: x_primary_quantity => l_primary_quantity,
1100: INTO l_indivisible_flag
1101: FROM mtl_system_items
1102: WHERE inventory_item_id = p_line_rec.inventory_item_id
1103: AND organization_id =
1104: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1105:
1106: IF nvl(l_indivisible_flag, 'N') = 'N' THEN
1107: IF l_debug_level > 0 THEN
1108: OE_DEBUG_PUB.ADD('this Option can have decimal ratio', 1);
1654: l_dummy VARCHAR2(10);
1655:
1656: /* added for 2219230 */
1657: l_org_flag NUMBER := 2;
1658: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
1659: CURSOR xref IS
1660: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1661: DECODE(items.organization_id, item_val_org, 1, 2))
1662: FROM mtl_cross_reference_types types
1723: SELECT 'valid'
1724: INTO l_dummy
1725: FROM mtl_system_items_b
1726: WHERE inventory_item_id = p_inventory_item_id
1727: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1728: AND internal_order_enabled_flag = 'Y';
1729: ELSE /* other orders except Internal*/
1730: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1731: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1737: SELECT 'valid'
1738: INTO l_dummy
1739: FROM mtl_system_items_b
1740: WHERE inventory_item_id = p_inventory_item_id
1741: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
1742: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1743:
1744: /* Change for bug 1805985
1745: -------------------------------------------------------
1776: /*SELECT 'valid'
1777: INTO l_dummy
1778: FROM mtl_system_items_b
1779: WHERE inventory_item_id = p_inventory_item_id
1780: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1781: AND customer_order_enabled_flag = 'Y'; */
1782: -- end bug 4171642
1783:
1784: END IF;
1807: /*SELECT 'valid'
1808: INTO l_dummy
1809: FROM mtl_system_items_b
1810: WHERE inventory_item_id = p_inventory_item_id
1811: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1812: AND customer_order_enabled_flag = 'Y'; */
1813: -- End bug 4171642
1814: END IF;
1815: END IF;
1832: WHERE citems.customer_item_id = cxref.customer_item_id
1833: AND cxref.inventory_item_id = sitems.inventory_item_id
1834: AND sitems.inventory_item_id = p_inventory_item_id
1835: AND sitems.organization_id =
1836: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1837: AND sitems.customer_order_enabled_flag = 'Y' -- bug 3835602
1838: AND citems.customer_item_id = p_ordered_item_id
1839: AND citems.customer_id = p_sold_to_org_id
1840: AND citems.inactive_flag = 'N'
1853: WHERE citems.customer_item_id = cxref.customer_item_id
1854: AND cxref.inventory_item_id = sitems.inventory_item_id
1855: AND sitems.inventory_item_id = p_inventory_item_id
1856: AND sitems.organization_id =
1857: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
1858: AND citems.customer_item_id = p_ordered_item_id
1859: AND citems.customer_id = p_sold_to_org_id
1860: AND mp.organization_id = sitems.organization_id -- 4402603
1861: AND cxref.master_organization_id = mp.master_organization_id ; -- 4402603
2083: INTO l_returnable_flag
2084: FROM mtl_system_items_b
2085: WHERE inventory_item_id = p_inventory_item_id
2086: and organization_id = nvl(p_ship_from_org_id,
2087: oe_sys_parameters.value_wnps('MASTER_ORGANIZATION_ID')); */
2088:
2089: -- bug 4171642
2090:
2091: IF l_returnable_flag = 'Y' THEN
2402: oe_debug_pub.add('Entering Validate_ship_to_org',1);
2403: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
2404: END IF;
2405:
2406: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2407:
2408: IF nvl(lcustomer_relations,'N') = 'N' THEN
2409:
2410: Select 'VALID'
2485: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2486: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2487: END IF;
2488:
2489: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2490:
2491: IF nvl(lcustomer_relations,'N') = 'N' THEN
2492: SELECT 'VALID'
2493: INTO l_dummy
2875: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2876: AND org.organization_id= msi.organization_id
2877: AND sysdate <= nvl( org.disable_date, sysdate)
2878: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
2879: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2880: IF l_debug_level > 0 then
2881: OE_DEBUG_PUB.Add('Pack-J Across SOB',2);
2882: END IF;
2883: ELSE
2888: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2889: AND org.organization_id= msi.organization_id
2890: AND sysdate <= nvl( org.disable_date, sysdate)
2891: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
2892: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'))
2893: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
2894: FROM financials_system_parameters fsp);
2895: IF l_debug_level > 0 then
2896: OE_DEBUG_PUB.Add('Pre Pack-J Logic',2);
2900: IF l_purchasing_enabled_flag = 'N' THEN
2901: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2902: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2903: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2904: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2905: OE_MSG_PUB.Add;
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: END IF;
2908:
3111: --FOR BUG 3192386
3112: l_flow_status_code VARCHAR2(30);
3113: -- Bug 3232544
3114: lcustomer_relations varchar2(1) :=
3115: OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
3116: l_exists varchar2(1);
3117: --For Bug 3257240
3118: l_customer_name VARCHAR2(240);
3119: l_customer_number NUMBER;
3264: AND NVL(BH.TRANSACTION_PHASE_CODE,'F')='F'
3265: AND NVL(BH.DRAFT_SUBMITTED_FLAG,'Y') = 'Y';
3266:
3267: -- Set Item validation org parameter value
3268: l_item_val_org := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
3269:
3270: -- Blanket/Item Validations
3271:
3272: IF p_line_rec.inventory_item_id IS NOT NULL
3794: l_price_list_name VARCHAR2(240);
3795: l_option_count NUMBER;
3796: l_is_ota_line BOOLEAN;
3797: l_order_quantity_uom VARCHAR2(3);
3798: lcustomer_relations varchar2(1) := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
3799: l_list_type_code VARCHAR2(30);
3800: l_currency_code VARCHAR2(30);
3801: l_hdr_currency_code VARCHAR2(30);
3802: l_restrict_subinv NUMBER;
3827:
3828: l_top_container_model VARCHAR2(1);
3829: l_part_of_container VARCHAR2(1);
3830: l_item_description VARCHAR2(240);
3831: l_mast_org_id NUMBER := OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3832: CURSOR pick_status IS
3833: SELECT --RELEASED_STATUS, -- 14108180
3834: SRC_REQUESTED_QUANTITY,
3835: SRC_REQUESTED_QUANTITY2
3940: BEGIN
3941: IF l_debug_level > 0 then
3942: oe_debug_pub.add('Enter OE_VALIDATE_LINE.ENTITY',1);
3943: END IF;
3944: g_master_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ; --Bug#12426110
3945: IF OE_GLOBALS.G_HEADER_CREATED
3946: THEN
3947: IF l_debug_level > 0 then
3948: oe_debug_pub.add('Header has got created in the same call',1);
4003: p_old_line_rec => p_old_line_rec);
4004:
4005: END IF;
4006: --begin rakesh 4241385
4007: l_auto_schedule_sets := NVL(oe_sys_parameters.Value('ONT_AUTO_SCH_SETS',p_line_rec.org_id),'Y'); --rakesh 4241385
4008: IF l_auto_schedule_sets = 'N' THEN
4009:
4010: IF ((p_line_rec.arrival_set_id IS NOT NULL
4011: AND p_line_rec.arrival_set_id <> FND_API.G_MISS_NUM)
5989: AND TRUNC(p_line_rec.tax_date) BETWEEN TRUNC(V.START_DATE) AND
5990: TRUNC(NVL(V.END_DATE, p_line_rec.tax_date))
5991: AND ROWNUM = 1;
5992: Else
5993: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
5994: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
5995:
5996: SELECT 'VALID'
5997: INTO l_dummy
6285: INTO l_uom
6286: FROM mtl_system_items_b
6287: WHERE inventory_item_id = p_line_rec.inventory_item_id
6288: AND organization_id = nvl(p_line_rec.ship_from_org_id,
6289: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
6290: */
6291: -- end bug 4171642
6292: ---Start bug 8894555 Primary uom should be validated against the Master org for model items
6293: ---UOM will be picked from cache if ship_from and master org are same else get from DB
6351: FROM mtl_item_uoms_view
6352: WHERE inventory_item_id = p_line_rec.inventory_item_id
6353: AND uom_code = p_line_rec.order_quantity_uom
6354: AND organization_id = nvl(p_line_rec.ship_from_org_id,
6355: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
6356:
6357:
6358: IF l_uom_count = 0 THEN
6359: IF l_debug_level > 0 then
6364: RAISE FND_API.G_EXC_ERROR;
6365: END IF;
6366:
6367: */
6368: 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')));
6369: IF NOT l_ret_status THEN
6370: IF l_debug_level > 0 then
6371: oe_debug_pub.add('uom/item combination invalid',2);
6372: END IF;
7802: END IF;
7803:
7804: IF OE_Validate.Charge_Periodicity (p_line_rec.charge_periodicity_code) THEN
7805:
7806: IF OE_SYS_PARAMETERS.Value ('RECURRING_CHARGES') = 'Y' THEN
7807:
7808: IF p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7809:
7810: IF p_line_rec.top_model_line_id IS NOT NULL THEN
7832: --INTO l_item_description
7833: --FROM MTL_SYSTEM_ITEMS mtl_msi
7834: --WHERE mtl_msi.inventory_item_id = p_line_rec.inventory_item_id
7835: --AND mtl_msi.organization_id =
7836: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7837:
7838: FND_MESSAGE.SET_NAME('ONT','ONT_NO_RC_ALLOWED');
7839: --FND_MESSAGE.SET_TOKEN('ITEM',l_item_description);
7840: OE_MSG_PUB.Add;