[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_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level; -- INVCONV
1138: l_tracking_quantity_ind VARCHAR2(30); -- INVCONV
2219: AND NVL(V.TAX_CLASS,'O')='O'
2220: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
2221: AND ROWNUM = 1;
2222: ELSE
2223: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(p_line_rec.org_id);
2224: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
2225: SELECT 'VALID'
2226: INTO l_dummy
2227: FROM AR_VAT_TAX V
2424: INTO l_uom
2425: FROM mtl_system_items
2426: WHERE inventory_item_id = p_line_rec.inventory_item_id
2427: AND organization_id = nvl(p_line_rec.ship_from_org_id,
2428: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2429:
2430:
2431: oe_debug_pub.add('primary uom: '|| l_uom, 1);
2432: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);
2453: FROM mtl_item_uoms_view
2454: WHERE inventory_item_id = p_line_rec.inventory_item_id
2455: AND uom_code = p_line_rec.order_quantity_uom
2456: AND organization_id = nvl(p_line_rec.ship_from_org_id,
2457: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2458:
2459:
2460: IF l_uom_count = 0 THEN
2461: oe_debug_pub.add('uom/item combination invalid',2);
3914: -- between a standard and an option item.
3915: -- ato_item's item_type_code will be standard
3916:
3917: oe_debug_pub.add
3918: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3919: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);
3920: BEGIN
3921: SELECT OE_GLOBALS.G_ITEM_KIT
3922: INTO l_item_type_code
3921: SELECT OE_GLOBALS.G_ITEM_KIT
3922: INTO l_item_type_code
3923: FROM mtl_system_items
3924: WHERE organization_id
3925: = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
3926: AND inventory_item_id = p_line_rec.inventory_item_id
3927: AND pick_components_flag = 'Y';
3928:
3929: oe_debug_pub.add(' Before calling check 1');