eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_PROCESS_LINE dependencies on OE_BULK_ORDER_PVT

Line 357: l_org_id := nvl(p_line_rec.ship_from_org_id(p_index), OE_BULK_ORDER_PVT.G_ITEM_ORG);

353: p_line_rec.item_type_code(p_index) in ('STANDARD','OPTION','INCLUDED') AND --9775352
354: fnd_profile.value('INV_CTP') = '5'
355: THEN
356:
357: l_org_id := nvl(p_line_rec.ship_from_org_id(p_index), OE_BULK_ORDER_PVT.G_ITEM_ORG);
358: l_c_index := OE_BULK_CACHE.Load_Item
359: (p_key1 => p_line_rec.inventory_item_id(p_index)
360: ,p_key2 => l_org_id
361: ,p_default_attributes => 'Y');

Line 567: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||OE_BULK_ORDER_PVT.G_ITEM_ORG ) ;

563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add( 'SEGMENTS ENABLED = '||L_N_SEGMENTS ) ;
565: END IF;
566: IF l_debug_level > 0 THEN
567: oe_debug_pub.add( 'VALIDATION_ORG_ID = '||OE_BULK_ORDER_PVT.G_ITEM_ORG ) ;
568: END IF;
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'ARRAY1 = '||L_SEGMENT_ARRAY ( 1 ) ) ;
571: END IF;

Line 572: IF FND_FLEX_EXT.GET_COMBINATION_ID('INV', 'MSTK', 101, SYSDATE, l_n_segments, l_segment_array, l_id, OE_BULK_ORDER_PVT.G_ITEM_ORG) THEN

568: END IF;
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add( 'ARRAY1 = '||L_SEGMENT_ARRAY ( 1 ) ) ;
571: END IF;
572: IF FND_FLEX_EXT.GET_COMBINATION_ID('INV', 'MSTK', 101, SYSDATE, l_n_segments, l_segment_array, l_id, OE_BULK_ORDER_PVT.G_ITEM_ORG) THEN
573: p_line_rec.inventory_item_id(p_index) := l_id;
574: IF l_debug_level > 0 THEN
575: oe_debug_pub.add( 'GET CCID = '||P_LINE_REC.INVENTORY_ITEM_ID ( P_INDEX ) ) ;
576: END IF;

Line 610: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG;

606: FROM mtl_system_items_vl
607: WHERE concatenated_segments = l_inventory_item
608: AND customer_order_enabled_flag = 'Y'
609: AND bom_item_type in (1,2,4)
610: AND organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG;
611: EXCEPTION
612: WHEN NO_DATA_FOUND THEN
613: NULL;
614: END;

Line 653: ,OE_BULK_ORDER_PVT.G_ITEM_ORG)

649: Z_Customer_Item_Id => p_line_rec.ordered_item_id(p_index)
650: , Z_Customer_Id => p_line_rec.sold_to_org_id(p_index)
651: , Z_Customer_Item_Number => p_line_rec.ordered_item(p_index)
652: , Z_Organization_Id => nvl(p_line_rec.ship_from_org_id(p_index)
653: ,OE_BULK_ORDER_PVT.G_ITEM_ORG)
654: , Z_Inventory_Item_Id => NULL
655: , Attribute_Name => 'INVENTORY_ITEM_ID'
656: , Error_Code => l_error_code
657: , Error_Flag => l_error_flag

Line 677: ,OE_BULK_ORDER_PVT.G_ITEM_ORG)

673: Z_Customer_Item_Id => p_line_rec.ordered_item_id(p_index)
674: , Z_Customer_Id => p_line_rec.sold_to_org_id(p_index)
675: , Z_Customer_Item_Number => p_line_rec.ordered_item(p_index)
676: , Z_Organization_Id => nvl(p_line_rec.ship_from_org_id(p_index)
677: ,OE_BULK_ORDER_PVT.G_ITEM_ORG)
678: , Z_Inventory_Item_Id => NULL
679: , Attribute_Name => 'CUSTOMER_ITEM_ID'
680: , Error_Code => l_error_code
681: , Error_Flag => l_error_flag

Line 724: AND (organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG

720: SELECT inventory_item_id
721: INTO l_inventory_item_id_gen
722: FROM mtl_cross_references
723: WHERE cross_reference_type = p_line_rec.item_identifier_type(p_index)
724: AND (organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
725: OR organization_id IS NULL)
726: AND cross_reference = p_line_rec.ordered_item(p_index)
727: AND (inventory_item_id = l_inventory_item_id_int
728: OR l_inventory_item_id_int IS NULL);

Line 1061: OE_Bulk_Order_PVT.G_ITEM_ORG,

1057:
1058: inv_decimals_pub.validate_quantity(
1059: p_item_id => p_item_id,
1060: p_organization_id =>
1061: OE_Bulk_Order_PVT.G_ITEM_ORG,
1062: p_input_quantity => p_input_quantity,
1063: p_uom_code => p_uom_code,
1064: x_output_quantity => l_validated_quantity,
1065: x_primary_quantity => l_primary_quantity,

Line 1169: OE_Bulk_Order_PVT.G_ITEM_ORG

1165: WHERE citems.customer_item_id = cxref.customer_item_id
1166: AND cxref.inventory_item_id = sitems.inventory_item_id
1167: AND sitems.inventory_item_id = p_inventory_item_id
1168: AND sitems.organization_id =
1169: OE_Bulk_Order_PVT.G_ITEM_ORG
1170: AND citems.customer_item_id = p_ordered_item_id
1171: AND citems.customer_id = p_sold_to_org_id
1172: AND citems.inactive_flag = 'N'
1173: AND cxref.inactive_flag = 'N';

Line 1183: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG

1179: ,mtl_system_items_vl sitems
1180: WHERE citems.customer_item_id = cxref.customer_item_id
1181: AND cxref.inventory_item_id = sitems.inventory_item_id
1182: AND sitems.inventory_item_id = p_inventory_item_id
1183: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG
1184: AND citems.customer_item_id = p_ordered_item_id
1185: AND citems.customer_id = p_sold_to_org_id;
1186:
1187: END IF;

Line 1200: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG

1196: , mtl_cross_references items
1197: , mtl_system_items_vl sitems
1198: WHERE types.cross_reference_type = items.cross_reference_type
1199: AND items.inventory_item_id = sitems.inventory_item_id
1200: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG
1201: AND sitems.inventory_item_id = p_inventory_item_id
1202: AND items.cross_reference_type = p_item_identifier_type
1203: AND items.cross_reference = p_ordered_item
1204: AND (items.organization_id = sitems.organization_id

Line 1302: l_header_id := OE_Bulk_Order_PVT.g_header_rec.header_id(p_header_index);

1298: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1299: --
1300: BEGIN
1301:
1302: l_header_id := OE_Bulk_Order_PVT.g_header_rec.header_id(p_header_index);
1303:
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add( 'UNBOOK ORDER , HEADER ID:'||L_HEADER_ID ) ;
1306: oe_debug_pub.add( 'HEADER INDEX :'||P_HEADER_INDEX ) ;

Line 1312: OE_Bulk_Order_PVT.g_header_rec.booked_flag(p_header_index) := 'N';

1308: END IF;
1309:
1310: -- Unset booking fields on header global
1311:
1312: OE_Bulk_Order_PVT.g_header_rec.booked_flag(p_header_index) := 'N';
1313:
1314: -- Unset booking fields on line global records
1315:
1316: l_index := p_last_line_index;

Line 1380: OE_Bulk_Order_PVT.g_header_rec.org_id(p_header_index);

1376:
1377: -- Populate Ship To first, since it may be used to override Header defaults
1378: IF p_line_rec.org_id(p_index) IS NULL THEN
1379: p_line_rec.org_id(p_index) :=
1380: OE_Bulk_Order_PVT.g_header_rec.org_id(p_header_index);
1381: END IF;
1382:
1383:
1384:

Line 1387: OE_Bulk_Order_PVT.g_header_rec.ship_to_org_id(p_header_index);

1383:
1384:
1385: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
1386: p_line_rec.ship_to_org_id(p_index) :=
1387: OE_Bulk_Order_PVT.g_header_rec.ship_to_org_id(p_header_index);
1388: END IF;
1389:
1390: -- Default attributes that have item as the first source
1391:

Line 1486: (p_key => OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index)

1482: -- Default line type from order type
1483:
1484: IF p_line_rec.line_type_id(p_index) IS NULL THEN
1485: l_c_index := OE_Bulk_Cache.Load_Order_Type
1486: (p_key => OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index)
1487: ,p_default_attributes => 'Y'
1488: );
1489: p_line_rec.line_type_id(p_index) :=
1490: OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).default_outbound_line_type_id;

Line 1497: OE_Bulk_Order_PVT.g_header_rec.accounting_rule_id(p_header_index);

1493: -- Default remaining attributes from Order Header
1494:
1495: IF p_line_rec.accounting_rule_id(p_index) IS NULL THEN
1496: p_line_rec.accounting_rule_id(p_index) :=
1497: OE_Bulk_Order_PVT.g_header_rec.accounting_rule_id(p_header_index);
1498: END IF;
1499:
1500: IF p_line_rec.demand_class_code(p_index) IS NULL THEN
1501: p_line_rec.demand_class_code(p_index) :=

Line 1502: OE_Bulk_Order_PVT.g_header_rec.demand_class_code(p_header_index);

1498: END IF;
1499:
1500: IF p_line_rec.demand_class_code(p_index) IS NULL THEN
1501: p_line_rec.demand_class_code(p_index) :=
1502: OE_Bulk_Order_PVT.g_header_rec.demand_class_code(p_header_index);
1503: END IF;
1504:
1505: IF p_line_rec.fob_point_code(p_index) IS NULL THEN
1506: p_line_rec.fob_point_code(p_index) :=

Line 1507: OE_Bulk_Order_PVT.g_header_rec.fob_point_code(p_header_index);

1503: END IF;
1504:
1505: IF p_line_rec.fob_point_code(p_index) IS NULL THEN
1506: p_line_rec.fob_point_code(p_index) :=
1507: OE_Bulk_Order_PVT.g_header_rec.fob_point_code(p_header_index);
1508: END IF;
1509:
1510: IF p_line_rec.freight_terms_code(p_index) IS NULL THEN
1511: p_line_rec.freight_terms_code(p_index) :=

Line 1512: OE_Bulk_Order_PVT.g_header_rec.freight_terms_code(p_header_index);

1508: END IF;
1509:
1510: IF p_line_rec.freight_terms_code(p_index) IS NULL THEN
1511: p_line_rec.freight_terms_code(p_index) :=
1512: OE_Bulk_Order_PVT.g_header_rec.freight_terms_code(p_header_index);
1513: END IF;
1514:
1515: IF p_line_rec.invoicing_rule_id(p_index) IS NULL THEN
1516: p_line_rec.invoicing_rule_id(p_index) :=

Line 1517: OE_Bulk_Order_PVT.g_header_rec.invoicing_rule_id(p_header_index);

1513: END IF;
1514:
1515: IF p_line_rec.invoicing_rule_id(p_index) IS NULL THEN
1516: p_line_rec.invoicing_rule_id(p_index) :=
1517: OE_Bulk_Order_PVT.g_header_rec.invoicing_rule_id(p_header_index);
1518: END IF;
1519:
1520: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
1521: p_line_rec.payment_term_id(p_index) :=

Line 1522: OE_Bulk_Order_PVT.g_header_rec.payment_term_id(p_header_index);

1518: END IF;
1519:
1520: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
1521: p_line_rec.payment_term_id(p_index) :=
1522: OE_Bulk_Order_PVT.g_header_rec.payment_term_id(p_header_index);
1523: END IF;
1524:
1525: IF p_line_rec.price_list_id(p_index) IS NULL THEN
1526: p_line_rec.price_list_id(p_index) :=

Line 1527: OE_Bulk_Order_PVT.g_header_rec.price_list_id(p_header_index);

1523: END IF;
1524:
1525: IF p_line_rec.price_list_id(p_index) IS NULL THEN
1526: p_line_rec.price_list_id(p_index) :=
1527: OE_Bulk_Order_PVT.g_header_rec.price_list_id(p_header_index);
1528: END IF;
1529:
1530: IF p_line_rec.salesrep_id(p_index) IS NULL THEN
1531: p_line_rec.salesrep_id(p_index) :=

Line 1532: OE_Bulk_Order_PVT.g_header_rec.salesrep_id(p_header_index);

1528: END IF;
1529:
1530: IF p_line_rec.salesrep_id(p_index) IS NULL THEN
1531: p_line_rec.salesrep_id(p_index) :=
1532: OE_Bulk_Order_PVT.g_header_rec.salesrep_id(p_header_index);
1533: END IF;
1534:
1535: IF p_line_rec.ship_tolerance_above(p_index) IS NULL THEN
1536: p_line_rec.ship_tolerance_above(p_index) :=

Line 1537: OE_Bulk_Order_PVT.g_header_rec.ship_tolerance_above(p_header_index);

1533: END IF;
1534:
1535: IF p_line_rec.ship_tolerance_above(p_index) IS NULL THEN
1536: p_line_rec.ship_tolerance_above(p_index) :=
1537: OE_Bulk_Order_PVT.g_header_rec.ship_tolerance_above(p_header_index);
1538: END IF;
1539:
1540: IF p_line_rec.ship_tolerance_below(p_index) IS NULL THEN
1541: p_line_rec.ship_tolerance_below(p_index) :=

Line 1542: OE_Bulk_Order_PVT.g_header_rec.ship_tolerance_below(p_header_index);

1538: END IF;
1539:
1540: IF p_line_rec.ship_tolerance_below(p_index) IS NULL THEN
1541: p_line_rec.ship_tolerance_below(p_index) :=
1542: OE_Bulk_Order_PVT.g_header_rec.ship_tolerance_below(p_header_index);
1543: END IF;
1544:
1545: IF p_line_rec.shipping_method_code(p_index) IS NULL THEN
1546: p_line_rec.shipping_method_code(p_index) :=

Line 1547: OE_Bulk_Order_PVT.g_header_rec.shipping_method_code(p_header_index);

1543: END IF;
1544:
1545: IF p_line_rec.shipping_method_code(p_index) IS NULL THEN
1546: p_line_rec.shipping_method_code(p_index) :=
1547: OE_Bulk_Order_PVT.g_header_rec.shipping_method_code(p_header_index);
1548: END IF;
1549:
1550: IF p_line_rec.shipment_priority_code(p_index) IS NULL THEN
1551: p_line_rec.shipment_priority_code(p_index) :=

Line 1552: OE_Bulk_Order_PVT.g_header_rec.shipment_priority_code(p_header_index);

1548: END IF;
1549:
1550: IF p_line_rec.shipment_priority_code(p_index) IS NULL THEN
1551: p_line_rec.shipment_priority_code(p_index) :=
1552: OE_Bulk_Order_PVT.g_header_rec.shipment_priority_code(p_header_index);
1553: END IF;
1554:
1555: IF p_line_rec.ship_from_org_id(p_index) IS NULL THEN
1556: p_line_rec.ship_from_org_id(p_index) :=

Line 1557: OE_Bulk_Order_PVT.g_header_rec.ship_from_org_id(p_header_index);

1553: END IF;
1554:
1555: IF p_line_rec.ship_from_org_id(p_index) IS NULL THEN
1556: p_line_rec.ship_from_org_id(p_index) :=
1557: OE_Bulk_Order_PVT.g_header_rec.ship_from_org_id(p_header_index);
1558: END IF;
1559:
1560: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
1561: p_line_rec.tax_exempt_flag(p_index) :=

Line 1562: OE_Bulk_Order_PVT.g_header_rec.tax_exempt_flag(p_header_index);

1558: END IF;
1559:
1560: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
1561: p_line_rec.tax_exempt_flag(p_index) :=
1562: OE_Bulk_Order_PVT.g_header_rec.tax_exempt_flag(p_header_index);
1563: END IF;
1564:
1565:
1566: -- Constant Value Defaults

Line 1635: OE_Bulk_Order_PVT.g_header_rec.header_id(p_header_index);

1631: -- Populate Fields from Header
1632: -------------------------------------------------------------------
1633: oe_debug_pub.add( 'Populate_Internal_Fields 1' ) ;
1634: p_line_rec.header_id(p_index) :=
1635: OE_Bulk_Order_PVT.g_header_rec.header_id(p_header_index);
1636:
1637: p_line_rec.booked_flag(p_index) :=
1638: OE_Bulk_Order_PVT.g_header_rec.booked_flag(p_header_index);
1639:

Line 1638: OE_Bulk_Order_PVT.g_header_rec.booked_flag(p_header_index);

1634: p_line_rec.header_id(p_index) :=
1635: OE_Bulk_Order_PVT.g_header_rec.header_id(p_header_index);
1636:
1637: p_line_rec.booked_flag(p_index) :=
1638: OE_Bulk_Order_PVT.g_header_rec.booked_flag(p_header_index);
1639:
1640: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
1641: p_line_rec.sold_to_org_id(p_index) :=
1642: OE_Bulk_Order_PVT.g_header_rec.sold_to_org_id(p_header_index);

Line 1642: OE_Bulk_Order_PVT.g_header_rec.sold_to_org_id(p_header_index);

1638: OE_Bulk_Order_PVT.g_header_rec.booked_flag(p_header_index);
1639:
1640: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
1641: p_line_rec.sold_to_org_id(p_index) :=
1642: OE_Bulk_Order_PVT.g_header_rec.sold_to_org_id(p_header_index);
1643: END IF;
1644:
1645: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
1646: p_line_rec.ship_to_org_id(p_index) :=

Line 1647: OE_Bulk_Order_PVT.g_header_rec.ship_to_org_id(p_header_index);

1643: END IF;
1644:
1645: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
1646: p_line_rec.ship_to_org_id(p_index) :=
1647: OE_Bulk_Order_PVT.g_header_rec.ship_to_org_id(p_header_index);
1648: END IF;
1649:
1650: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
1651: p_line_rec.invoice_to_org_id(p_index) :=

Line 1652: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index);

1648: END IF;
1649:
1650: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
1651: p_line_rec.invoice_to_org_id(p_index) :=
1652: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index);
1653: ELSIF p_line_rec.invoice_to_org_id(p_index) <>
1654: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index)
1655: THEN
1656: FND_MESSAGE.SET_NAME('ONT','OE_BULK_DIFF_INVOICE_TO');

Line 1654: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index)

1650: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
1651: p_line_rec.invoice_to_org_id(p_index) :=
1652: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index);
1653: ELSIF p_line_rec.invoice_to_org_id(p_index) <>
1654: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index)
1655: THEN
1656: FND_MESSAGE.SET_NAME('ONT','OE_BULK_DIFF_INVOICE_TO');
1657: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1658: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1698: IF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'YES'

1694: END IF;
1695: END IF;
1696:
1697: oe_debug_pub.add( 'Populate_Internal_Fields 2' ) ;
1698: IF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'YES'
1699: AND p_line_rec.orig_sys_shipment_ref(p_index) IS NULL
1700: AND nvl(p_line_rec.source_document_id(p_index),0) <> 10
1701: THEN
1702: p_line_rec.orig_sys_shipment_ref(p_index)

Line 1794: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;

1790: OR -- 4282392
1791: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1792: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S')
1793: THEN
1794: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1795: oe_debug_pub.add( 'Populate_Internal_Fields b' ) ;
1796: END IF;
1797: --bug 3798477
1798: oe_debug_pub.add( 'Populate_Internal_Fields bcc' ) ;

Line 1931: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;

1927: (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).tracking_quantity_ind = 'PS' AND
1928: OE_BULK_CACHE.G_ITEM_TBL(l_c_index).ont_pricing_qty_source = 'S' )
1929:
1930: THEN
1931: OE_BULK_ORDER_PVT.G_CATCHWEIGHT := TRUE;
1932: END IF;
1933: --bug 3798477
1934: -- Item Type can be STANDARD or KIT in BULK mode
1935:

Line 2045: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));

2041:
2042: l_c_index := OE_BULK_CACHE.Load_Line_Type
2043: (p_key => p_line_rec.line_type_id(p_index));
2044:
2045: l_d_index := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.g_header_rec.order_type_id(p_header_index));
2046:
2047: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code
2048: <> 'ORDER'
2049: THEN

Line 2132: OE_Bulk_Order_PVT.g_header_rec.latest_schedule_limit(p_header_index);

2128: p_line_rec.latest_acceptable_date(p_index) IS NULL
2129: THEN
2130: p_line_rec.latest_acceptable_date(p_index) :=
2131: p_line_rec.request_date(p_index) +
2132: OE_Bulk_Order_PVT.g_header_rec.latest_schedule_limit(p_header_index);
2133: END IF;
2134:
2135: -- Bug 2802876
2136: -- Item type code should not be null even for error records.

Line 2178: , p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

2174: -- Post_Processing from OEXVIMSB.pls
2175: ---------------------------------------------------------------------
2176: PROCEDURE Post_Process
2177: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
2178: , p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
2179: , p_line_index IN NUMBER
2180: , p_header_index IN NUMBER
2181: )
2182: IS

Line 2271: , p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE

2267: ---------------------------------------------------------------------
2268:
2269: PROCEDURE Entity
2270: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
2271: , p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
2272: , x_line_scredit_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
2273: , p_defaulting_mode IN VARCHAR2
2274: , p_process_configurations IN VARCHAR2 DEFAULT 'N'
2275: , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'

Line 2272: , x_line_scredit_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE

2268:
2269: PROCEDURE Entity
2270: ( p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
2271: , p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
2272: , x_line_scredit_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.SCREDIT_REC_TYPE
2273: , p_defaulting_mode IN VARCHAR2
2274: , p_process_configurations IN VARCHAR2 DEFAULT 'N'
2275: , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'
2276: , p_schedule_configurations IN VARCHAR2 DEFAULT 'N'

Line 2413: OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter) := l_index;

2409: l_nbr_ctr := 1; -- Reset the line number counter
2410:
2411: -- added for HVOP Tax project
2412: -- setting start and end line index for new order bug7685103
2413: OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter) := l_index;
2414: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter) := l_index;
2415:
2416: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter));
2417: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter));

Line 2414: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter) := l_index;

2410:
2411: -- added for HVOP Tax project
2412: -- setting start and end line index for new order bug7685103
2413: OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter) := l_index;
2414: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter) := l_index;
2415:
2416: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter));
2417: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter));
2418:

Line 2416: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter));

2412: -- setting start and end line index for new order bug7685103
2413: OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter) := l_index;
2414: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter) := l_index;
2415:
2416: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter));
2417: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter));
2418:
2419:
2420: --------------------------------------------------------------

Line 2417: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter));

2413: OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter) := l_index;
2414: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter) := l_index;
2415:
2416: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.start_line_index(header_counter));
2417: oe_debug_pub.add('OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter):'||OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter));
2418:
2419:
2420: --------------------------------------------------------------
2421: -- Same order: check for duplicate reference, from OEXVIMPB.pls

Line 2427: IF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'NO' THEN

2423: ELSE
2424:
2425: IF l_last_line_index IS NOT NULL THEN
2426:
2427: IF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'NO' THEN
2428: IF (p_line_rec.orig_sys_line_ref(l_last_line_index)
2429: = p_line_rec.orig_sys_line_ref(l_index))
2430: THEN
2431: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');

Line 2437: ELSIF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'YES' THEN

2433: ,'orig_sys_line_ref');
2434: p_line_rec.lock_control(l_index) := -99;
2435: OE_BULK_MSG_PUB.Add;
2436: END IF;
2437: ELSIF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'YES' THEN
2438: IF (p_line_rec.orig_sys_line_ref(l_last_line_index)
2439: = p_line_rec.orig_sys_line_ref(l_index))
2440: AND (p_line_rec.orig_sys_shipment_ref(l_last_line_index)
2441: = p_line_rec.orig_sys_shipment_ref(l_index))

Line 2457: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter) := l_index;

2453: END IF;
2454:
2455: -- added for HVOP Tax project
2456: -- setting end line index for this order bug7685103
2457: OE_BULK_ORDER_PVT.G_HEADER_REC.end_line_index(header_counter) := l_index;
2458:
2459:
2460: p_line_rec.line_number(l_index) := l_nbr_ctr;
2461:

Line 2759: IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN

2755: END IF;
2756:
2757: /* -- checks: Warehouse/Process combinations process HVOP
2758: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
2759: IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
2760:
2761: -- first check if warehouse is NULL, do not supply process attributes INVCONV - NOT NEEDED NOW
2762:
2763: IF (p_line_rec.ship_from_org_id(l_index)IS NULL) THEN

Line 2813: END IF; -- IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN

2809: END IF; -- OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL THEN
2810:
2811: END IF; -- p_line_rec.inventory_item_id(p_index) IS NOT NULL THEN
2812:
2813: END IF; -- IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
2814:
2815: END IF; -- IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN */
2816:
2817:

Line 2851: OE_Bulk_Order_PVT.G_ITEM_ORG);

2847: INTO l_uom
2848: FROM mtl_system_items
2849: WHERE inventory_item_id=p_line_rec.inventory_item_id(l_index)
2850: AND organization_id=nvl(p_line_rec.ship_from_org_id(l_index),
2851: OE_Bulk_Order_PVT.G_ITEM_ORG);
2852:
2853: IF l_uom <> p_line_rec.order_quantity_uom(l_index) THEN
2854: IF l_debug_level > 0 THEN
2855: oe_debug_pub.add( 'UOM OTHER THAN PRIMARY UOM IS ENTERED' , 1 ) ;

Line 2884: ,OE_Bulk_Order_PVT.G_ITEM_ORG )

2880: l_ret_status := inv_convert.validate_item_uom
2881: (p_line_rec.order_quantity_uom(l_index)
2882: ,p_line_rec.inventory_item_id(l_index)
2883: ,nvl(p_line_rec.ship_from_org_id(l_index)
2884: ,OE_Bulk_Order_PVT.G_ITEM_ORG )
2885: );
2886: IF NOT l_ret_status THEN
2887: IF l_debug_level > 0 THEN
2888: oe_debug_pub.add( 'UOM/ITEM COMBINATION INVALID' , 2 ) ;

Line 3605: IF OE_Bulk_Order_PVT.G_OE_LINE_ATTRIBUTES = 'Y' THEN

3601: -- BEGIN: Validate Desc Flex
3602:
3603: IF p_validate_desc_flex = 'Y' THEN
3604:
3605: IF OE_Bulk_Order_PVT.G_OE_LINE_ATTRIBUTES = 'Y' THEN
3606: IF NOT OE_VALIDATE.Line_Desc_Flex
3607: (p_context => p_line_rec.context(l_index)
3608: ,p_attribute1 => p_line_rec.attribute1(l_index)
3609: ,p_attribute2 => p_line_rec.attribute2(l_index)

Line 3746: IF OE_Bulk_Order_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE = 'Y' THEN

3742:
3743: END IF;
3744: END IF;
3745:
3746: IF OE_Bulk_Order_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE = 'Y' THEN
3747: IF NOT OE_VALIDATE.I_Line_Desc_Flex
3748: (p_context => p_line_rec.Industry_context(l_index)
3749: ,p_attribute1 => p_line_rec.Industry_attribute1(l_index)
3750: ,p_attribute2 => p_line_rec.Industry_attribute2(l_index)

Line 3948: IF OE_Bulk_Order_PVT.G_OE_LINE_TP_ATTRIBUTES = 'Y' THEN

3944: END IF;
3945:
3946: END IF;
3947:
3948: IF OE_Bulk_Order_PVT.G_OE_LINE_TP_ATTRIBUTES = 'Y' THEN
3949: IF NOT OE_VALIDATE.TP_Line_Desc_Flex
3950: (p_context => p_line_rec.tp_context(l_index)
3951: ,p_attribute1 => p_line_rec.tp_attribute1(l_index)
3952: ,p_attribute2 => p_line_rec.tp_attribute2(l_index)

Line 4091: OE_BULK_ORDER_PVT.G_PRICING_NEEDED := 'Y';

4087: END IF;
4088:
4089: ELSE
4090:
4091: OE_BULK_ORDER_PVT.G_PRICING_NEEDED := 'Y';
4092:
4093: END IF;
4094:
4095: ---------------------------------------------------------------

Line 4234: IF (OE_BULK_ORDER_PVT.G_AUTO_SCHEDULE = 'Y'

4230: ---------------------------------------------------------------
4231: oe_debug_pub.add(' SCHEDULING :');
4232: l_c_index := OE_BULK_CACHE.Load_Order_Type(p_header_rec.order_type_id(header_counter));
4233:
4234: IF (OE_BULK_ORDER_PVT.G_AUTO_SCHEDULE = 'Y'
4235: OR OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).auto_scheduling_flag = 'Y'
4236: OR p_line_rec.schedule_ship_date(l_index) IS NOT NULL
4237: OR p_line_rec.schedule_arrival_date(l_index) IS NOT NULL)
4238: AND p_line_rec.source_type_code(l_index) = 'INTERNAL'

Line 4252: IF ( OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'

4248: oe_debug_pub.add( 'SCHEDULING VALIDATIONS - ato scheduling') ;
4249: END IF;
4250:
4251: l_d_index := OE_BULK_CACHE.Load_Line_Type(p_line_rec.line_type_id(l_index));
4252: IF ( OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4253: AND l_on_generic_hold )
4254: THEN
4255: -- Add scheduling on hold message
4256: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');

Line 4304: OE_BULK_ORDER_PVT.G_SCH_COUNT := OE_BULK_ORDER_PVT.G_SCH_COUNT + 1;

4300: END IF; -- ship from not null.
4301:
4302: ELSE -- four/five
4303: p_line_rec.schedule_status_code(l_index) := 'TO_BE_SCHEDULED';
4304: OE_BULK_ORDER_PVT.G_SCH_COUNT := OE_BULK_ORDER_PVT.G_SCH_COUNT + 1;
4305: END IF;
4306: ELSE
4307: IF p_line_rec.schedule_ship_date(l_index) IS NOT NULL
4308: OR p_line_rec.schedule_arrival_date(l_index) IS NOT NULL THEN

Line 4451: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id.EXTEND(1);

4447: (p_line_rec.orig_sys_document_ref(l_index) <> l_orig_sys_document_ref)) THEN
4448:
4449: l_error_count := l_error_count + 1;
4450:
4451: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id.EXTEND(1);
4452: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)
4453: := p_line_rec.order_source_id(l_index);
4454: l_order_source_id := p_line_rec.order_source_id(l_index);
4455:

Line 4452: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)

4448:
4449: l_error_count := l_error_count + 1;
4450:
4451: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id.EXTEND(1);
4452: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)
4453: := p_line_rec.order_source_id(l_index);
4454: l_order_source_id := p_line_rec.order_source_id(l_index);
4455:
4456: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

Line 4456: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

4452: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)
4453: := p_line_rec.order_source_id(l_index);
4454: l_order_source_id := p_line_rec.order_source_id(l_index);
4455:
4456: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
4457: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4458: := p_line_rec.orig_sys_document_ref(l_index);
4459: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4460: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);

Line 4457: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)

4453: := p_line_rec.order_source_id(l_index);
4454: l_order_source_id := p_line_rec.order_source_id(l_index);
4455:
4456: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
4457: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4458: := p_line_rec.orig_sys_document_ref(l_index);
4459: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4460: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);
4461: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)

Line 4460: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);

4456: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
4457: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4458: := p_line_rec.orig_sys_document_ref(l_index);
4459: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4460: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);
4461: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)
4462: := p_line_rec.header_id(l_index);
4463:
4464: END IF; -- new order source/orig sys combination

Line 4461: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)

4457: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4458: := p_line_rec.orig_sys_document_ref(l_index);
4459: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4460: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);
4461: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)
4462: := p_line_rec.header_id(l_index);
4463:
4464: END IF; -- new order source/orig sys combination
4465:

Line 4476: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id.EXTEND(1);

4472: THEN
4473:
4474: l_error_count := l_error_count + 1;
4475:
4476: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id.EXTEND(1);
4477: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)
4478: := p_line_rec.order_source_id(l_index);
4479: l_order_source_id := p_line_rec.order_source_id(l_index);
4480:

Line 4477: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)

4473:
4474: l_error_count := l_error_count + 1;
4475:
4476: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id.EXTEND(1);
4477: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)
4478: := p_line_rec.order_source_id(l_index);
4479: l_order_source_id := p_line_rec.order_source_id(l_index);
4480:
4481: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

Line 4481: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);

4477: OE_Bulk_Order_PVT.G_ERROR_REC.order_source_id(l_error_count)
4478: := p_line_rec.order_source_id(l_index);
4479: l_order_source_id := p_line_rec.order_source_id(l_index);
4480:
4481: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
4482: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4483: := p_line_rec.orig_sys_document_ref(l_index);
4484: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4485: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);

Line 4482: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)

4478: := p_line_rec.order_source_id(l_index);
4479: l_order_source_id := p_line_rec.order_source_id(l_index);
4480:
4481: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
4482: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4483: := p_line_rec.orig_sys_document_ref(l_index);
4484: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4485: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);
4486: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)

Line 4485: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);

4481: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref.EXTEND(1);
4482: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4483: := p_line_rec.orig_sys_document_ref(l_index);
4484: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4485: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);
4486: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)
4487: := p_line_rec.header_id(l_index);
4488:
4489: -- Mark Corresponding Header Record as invalid as well

Line 4486: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)

4482: OE_Bulk_Order_PVT.G_ERROR_REC.orig_sys_document_ref(l_error_count)
4483: := p_line_rec.orig_sys_document_ref(l_index);
4484: l_orig_sys_document_ref := p_line_rec.orig_sys_document_ref(l_index);
4485: OE_Bulk_Order_PVT.G_ERROR_REC.header_id.EXTEND(1);
4486: OE_Bulk_Order_PVT.G_ERROR_REC.header_id(l_error_count)
4487: := p_line_rec.header_id(l_index);
4488:
4489: -- Mark Corresponding Header Record as invalid as well
4490: p_header_rec.lock_control(header_counter) := -99;

Line 5032: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)

5028: PROCEDURE Load_Cust_Trx_Type_Id
5029: ( p_line_index IN NUMBER
5030: ,p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
5031: ,p_header_index IN NUMBER
5032: ,p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)
5033: IS
5034: l_index NUMBER;
5035: BEGIN
5036: