[Home] [Help]
313: oe_debug_pub.add('before calling inv decimals api',2);
314: inv_decimals_pub.validate_quantity(
315: p_item_id => p_item_id,
316: p_organization_id =>
317: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'),
318: p_input_quantity => p_input_quantity,
319: p_uom_code => p_uom_code,
320: x_output_quantity => l_validated_quantity,
321: x_primary_quantity => l_primary_quantity,
601: SELECT 'valid'
602: INTO l_dummy
603: FROM mtl_system_items_vl
604: WHERE inventory_item_id = p_inventory_item_id
605: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
606: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
607: SELECT 'valid'
608: INTO l_dummy
609: FROM mtl_customer_items citems
612: WHERE citems.customer_item_id = cxref.customer_item_id
613: AND cxref.inventory_item_id = sitems.inventory_item_id
614: AND sitems.inventory_item_id = p_inventory_item_id
615: AND sitems.organization_id =
616: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
617: AND citems.customer_item_id = p_ordered_item_id
618: AND citems.customer_id = p_sold_to_org_id
619: AND rownum =1;
620: ELSE
628: , mtl_system_items_vl sitems
629: WHERE types.cross_reference_type = items.cross_reference_type
630: AND items.inventory_item_id = sitems.inventory_item_id
631: AND sitems.organization_id =
632: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
633: AND sitems.inventory_item_id = p_inventory_item_id
634: AND items.cross_reference_type = p_item_identifier_type
635: AND items.cross_reference = p_ordered_item;
636: END IF;
787: INTO l_returnable_flag
788: FROM mtl_system_items
789: WHERE inventory_item_id = p_inventory_item_id
790: and organization_id = nvl(p_ship_from_org_id,
791: oe_sys_parameters.value_wnps('MASTER_ORGANIZATION_ID'));
792:
793: IF l_returnable_flag = 'Y' THEN
794: RETURN TRUE;
795: END IF;
881: oe_debug_pub.add('Entering Validate_ship_to_org',1);
882: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
883:
884: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
885: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
886:
887: IF nvl(lcustomer_relations,'N') = 'N' THEN
888:
889: Select 'VALID'
956: BEGIN
957:
958: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
959: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
960: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
961:
962: IF nvl(lcustomer_relations,'N') = 'N' THEN
963: SELECT 'VALID'
964: INTO l_dummy
1082: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
1083: AND org.organization_id= msi.organization_id
1084: AND sysdate <= nvl( org.disable_date, sysdate)
1085: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
1086: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'))
1087: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
1088: FROM financials_system_parameters fsp);
1089:
1090: IF l_purchasing_enabled_flag = 'N' THEN
1089:
1090: IF l_purchasing_enabled_flag = 'N' THEN
1091: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,
1093: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
1094: FND_MESSAGE.SET_TOKEN('ORG', p_line_rec.ordered_item);
1095: OE_MSG_PUB.Add;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1130: l_price_list_name VARCHAR2(240);
1131: l_option_count NUMBER;
1132: l_is_ota_line BOOLEAN;
1133: l_order_quantity_uom VARCHAR2(3);
1134: lcustomer_relations varchar2(1) := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1135: l_list_type_code VARCHAR2(30);
1136:
1137: l_ret_status BOOLEAN:=TRUE; -- 8993157
1138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; -- INVCONV
2220: AND NVL(V.TAX_CLASS,'O')='O'
2221: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
2222: AND ROWNUM = 1;
2223: ELSE
2224: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(p_line_rec.org_id);
2225: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
2226: SELECT 'VALID'
2227: INTO l_dummy
2228: FROM AR_VAT_TAX V
2425: INTO l_uom
2426: FROM mtl_system_items
2427: WHERE inventory_item_id = p_line_rec.inventory_item_id
2428: AND organization_id = nvl(p_line_rec.ship_from_org_id,
2429: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2430:
2431:
2432: oe_debug_pub.add('primary uom: '|| l_uom, 1);
2433: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);
2455: FROM mtl_item_uoms_view
2456: WHERE inventory_item_id = p_line_rec.inventory_item_id
2457: AND uom_code = p_line_rec.order_quantity_uom
2458: AND organization_id = nvl(p_line_rec.ship_from_org_id,
2459: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2460:
2461:
2462: IF l_uom_count = 0 THEN
2463: oe_debug_pub.add('uom/item combination invalid',2);
2470: l_ret_status :=
2471: inv_convert.validate_item_uom(p_line_rec.order_quantity_uom,
2472: p_line_rec.inventory_item_id,
2473: nvl(p_line_rec.ship_from_org_id,
2474: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')));
2475: IF NOT l_ret_status THEN
2476: if l_debug_level > 0 then
2477: oe_debug_pub.add('uom/item combination invalid',2);
2478: end if;
3934: -- between a standard and an option item.
3935: -- ato_item's item_type_code will be standard
3936:
3937: oe_debug_pub.add
3938: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3939: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);
3940: BEGIN
3941: SELECT OE_GLOBALS.G_ITEM_KIT
3942: INTO l_item_type_code
3941: SELECT OE_GLOBALS.G_ITEM_KIT
3942: INTO l_item_type_code
3943: FROM mtl_system_items
3944: WHERE organization_id
3945: = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
3946: AND inventory_item_id = p_line_rec.inventory_item_id
3947: AND pick_components_flag = 'Y';
3948:
3949: oe_debug_pub.add(' Before calling check 1');