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_VALIDATE dependencies on OE_ORDER_UTIL

Line 333: OE_ORDER_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID');

329: -- Attribute Validations for Headers and Lines
330: -------------------------------------------------------------------
331:
332: l_msg_text := l_msg_data||
333: OE_ORDER_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID');
334: --PP Revenue Recognition
335: --bug 4893057
336: --Included the new accounting rules for partial revenue recognition
337: INSERT INTO OE_PROCESSING_MSGS

Line 411: OE_ORDER_UTIL.Get_Attribute_Name('CONVERSION_TYPE_CODE');

407: END IF;
408: END IF;
409:
410: l_msg_text := l_msg_data||
411: OE_ORDER_UTIL.Get_Attribute_Name('CONVERSION_TYPE_CODE');
412: INSERT INTO OE_PROCESSING_MSGS
413: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
414: ,line_id ,order_source_id ,original_sys_document_ref
415: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 447: OE_ORDER_UTIL.Get_Attribute_Name('DEMAND_CLASS_CODE');

443: END IF;
444:
445:
446: l_msg_text := l_msg_data||
447: OE_ORDER_UTIL.Get_Attribute_Name('DEMAND_CLASS_CODE');
448: INSERT INTO OE_PROCESSING_MSGS
449: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
450: ,line_id ,order_source_id ,original_sys_document_ref
451: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 563: OE_ORDER_UTIL.Get_Attribute_Name('FOB_POINT_CODE');

559: END IF;
560:
561:
562: l_msg_text := l_msg_data||
563: OE_ORDER_UTIL.Get_Attribute_Name('FOB_POINT_CODE');
564: INSERT INTO OE_PROCESSING_MSGS
565: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
566: ,line_id ,order_source_id ,original_sys_document_ref
567: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 645: OE_ORDER_UTIL.Get_Attribute_Name('FREIGHT_TERMS_CODE');

641: END IF;
642:
643:
644: l_msg_text := l_msg_data||
645: OE_ORDER_UTIL.Get_Attribute_Name('FREIGHT_TERMS_CODE');
646: INSERT INTO OE_PROCESSING_MSGS
647: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
648: ,line_id ,order_source_id ,original_sys_document_ref
649: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 725: OE_ORDER_UTIL.Get_Attribute_Name('INVOICING_RULE_ID');

721: END IF;
722: END IF;
723:
724: l_msg_text := l_msg_data||
725: OE_ORDER_UTIL.Get_Attribute_Name('INVOICING_RULE_ID');
726: INSERT INTO OE_PROCESSING_MSGS
727: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
728: ,line_id ,order_source_id ,original_sys_document_ref
729: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 802: OE_ORDER_UTIL.Get_Attribute_Name('ORDER_DATE_TYPE_CODE');

798: END IF;
799:
800:
801: l_msg_text := l_msg_data||
802: OE_ORDER_UTIL.Get_Attribute_Name('ORDER_DATE_TYPE_CODE');
803: INSERT INTO OE_PROCESSING_MSGS
804: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
805: ,line_id ,order_source_id ,original_sys_document_ref
806: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 842: OE_ORDER_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID');

838: END IF;
839:
840:
841: l_msg_text := l_msg_data||
842: OE_ORDER_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID');
843: INSERT INTO OE_PROCESSING_MSGS
844: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
845: ,line_id ,order_source_id ,original_sys_document_ref
846: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 919: OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID');

915: END IF;
916:
917:
918: l_msg_text := l_msg_data||
919: OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID');
920: INSERT INTO OE_PROCESSING_MSGS
921: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
922: ,line_id ,order_source_id ,original_sys_document_ref
923: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 995: OE_ORDER_UTIL.Get_Attribute_Name('SHIPMENT_PRIORITY_CODE');

991: END IF;
992: END IF;
993:
994: l_msg_text := l_msg_data||
995: OE_ORDER_UTIL.Get_Attribute_Name('SHIPMENT_PRIORITY_CODE');
996: INSERT INTO OE_PROCESSING_MSGS
997: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
998: ,line_id ,order_source_id ,original_sys_document_ref
999: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1076: OE_ORDER_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE');

1072: END IF;
1073:
1074:
1075: l_msg_text := l_msg_data||
1076: OE_ORDER_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE');
1077: INSERT INTO OE_PROCESSING_MSGS
1078: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1079: ,line_id ,order_source_id ,original_sys_document_ref
1080: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1151: OE_ORDER_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID');

1147: END IF;
1148:
1149:
1150: l_msg_text := l_msg_data||
1151: OE_ORDER_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID');
1152: INSERT INTO OE_PROCESSING_MSGS
1153: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1154: ,line_id ,order_source_id ,original_sys_document_ref
1155: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1230: OE_ORDER_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG');

1226: END IF;
1227:
1228:
1229: l_msg_text := l_msg_data||
1230: OE_ORDER_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG');
1231: INSERT INTO OE_PROCESSING_MSGS
1232: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1233: ,line_id ,order_source_id ,original_sys_document_ref
1234: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1311: OE_ORDER_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE');

1307: END IF;
1308:
1309:
1310: l_msg_text := l_msg_data||
1311: OE_ORDER_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE');
1312: INSERT INTO OE_PROCESSING_MSGS
1313: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1314: ,line_id ,order_source_id ,original_sys_document_ref
1315: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1351: OE_ORDER_UTIL.Get_Attribute_Name('PAYMENT_TYPE_CODE');

1347: END IF;
1348:
1349:
1350: l_msg_text := l_msg_data||
1351: OE_ORDER_UTIL.Get_Attribute_Name('PAYMENT_TYPE_CODE');
1352: INSERT INTO OE_PROCESSING_MSGS
1353: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1354: ,line_id ,order_source_id ,original_sys_document_ref
1355: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1391: OE_ORDER_UTIL.Get_Attribute_Name('SALESREP_ID');

1387: END IF;
1388:
1389:
1390: l_msg_text := l_msg_data||
1391: OE_ORDER_UTIL.Get_Attribute_Name('SALESREP_ID');
1392:
1393: INSERT INTO OE_PROCESSING_MSGS
1394: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1395: ,line_id ,order_source_id ,original_sys_document_ref

Line 1495: OE_ORDER_UTIL.Get_Attribute_Name('SALES_CHANNEL_CODE');

1491: END IF;
1492: END IF;
1493:
1494: l_msg_text := l_msg_data||
1495: OE_ORDER_UTIL.Get_Attribute_Name('SALES_CHANNEL_CODE');
1496: INSERT INTO OE_PROCESSING_MSGS
1497: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1498: ,line_id ,order_source_id ,original_sys_document_ref
1499: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1535: OE_ORDER_UTIL.Get_Attribute_Name('END_ITEM_UNIT_NUMBER');

1531: END IF;
1532:
1533:
1534: l_msg_text := l_msg_data||
1535: OE_ORDER_UTIL.Get_Attribute_Name('END_ITEM_UNIT_NUMBER');
1536: INSERT INTO OE_PROCESSING_MSGS
1537: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1538: ,line_id ,order_source_id ,original_sys_document_ref
1539: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1573: OE_ORDER_UTIL.Get_Attribute_Name('CALCULATE_PRICE_FLAG');

1569: END IF;
1570: END IF;
1571:
1572: l_msg_text := l_msg_data||
1573: OE_ORDER_UTIL.Get_Attribute_Name('CALCULATE_PRICE_FLAG');
1574: INSERT INTO OE_PROCESSING_MSGS
1575: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1576: ,line_id ,order_source_id ,original_sys_document_ref
1577: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1618: OE_ORDER_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID');

1614: -- check for invalid item/warehouse combo INVCONV
1615:
1616:
1617: l_msg_text := l_msg_data||
1618: OE_ORDER_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID');
1619: INSERT INTO OE_PROCESSING_MSGS
1620: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1621: ,line_id ,order_source_id ,original_sys_document_ref
1622: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1664: OE_ORDER_UTIL.Get_Attribute_Name('ORDERED_QUANTITY_UOM2');

1660: -- PROCESS DUAL HVOP 2. validation is ordered_quantity_uom2;
1661: -- if line non-dual then do not supply UOM2 OR secondary quantity
1662:
1663: l_msg_text := l_msg_data||
1664: OE_ORDER_UTIL.Get_Attribute_Name('ORDERED_QUANTITY_UOM2');
1665: INSERT INTO OE_PROCESSING_MSGS
1666: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1667: ,line_id ,order_source_id ,original_sys_document_ref
1668: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1711: OE_ORDER_UTIL.Get_Attribute_Name('ORDERED_QUANTITY_UOM2');

1707: -- AND secondary UOM must be same as on mtl_system_items
1708:
1709:
1710: l_msg_text := l_msg_data||
1711: OE_ORDER_UTIL.Get_Attribute_Name('ORDERED_QUANTITY_UOM2');
1712: INSERT INTO OE_PROCESSING_MSGS
1713: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1714: ,line_id ,order_source_id ,original_sys_document_ref
1715: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1759: OE_ORDER_UTIL.Get_Attribute_Name('ORDERED_QUANTITY_UOM2');

1755: -- PROCESS DUAL HVOP 4. if item is tracked in primary and secondary or item is priced in secondary
1756: -- then secondary UOM must be enterd -- INVCONV
1757:
1758: l_msg_text := l_msg_data||
1759: OE_ORDER_UTIL.Get_Attribute_Name('ORDERED_QUANTITY_UOM2');
1760: INSERT INTO OE_PROCESSING_MSGS
1761: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1762: ,line_id ,order_source_id ,original_sys_document_ref
1763: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1812: OE_ORDER_UTIL.Get_Attribute_Name('PREFERRED_GRADE');

1808: -- validation is preferred_grade; 1 if entered,item must be grade controlled;
1809: -- 2.if entered, grade must exist in mtl_grades
1810:
1811: l_msg_text := l_msg_data||
1812: OE_ORDER_UTIL.Get_Attribute_Name('PREFERRED_GRADE');
1813: INSERT INTO OE_PROCESSING_MSGS
1814: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1815: ,line_id ,order_source_id ,original_sys_document_ref
1816: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1865: OE_ORDER_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE');

1861: -- INVCONV END IF; -- IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
1862:
1863: -- QUOTING changes - validate trxn phase and version number if >= Pack J
1864: l_msg_text := l_msg_data||
1865: OE_ORDER_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE');
1866: INSERT INTO OE_PROCESSING_MSGS
1867: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1868: ,line_id ,order_source_id ,original_sys_document_ref
1869: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1900: OE_ORDER_UTIL.Get_Attribute_Name('VERSION_NUMBER');

1896: END IF;
1897: END IF;
1898:
1899: l_msg_text := l_msg_data||
1900: OE_ORDER_UTIL.Get_Attribute_Name('VERSION_NUMBER');
1901: INSERT INTO OE_PROCESSING_MSGS
1902: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1903: ,line_id ,order_source_id ,original_sys_document_ref
1904: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1950: OE_ORDER_UTIL.Get_Attribute_Name('APPLIED_FLAG');

1946: RETURN;
1947: END IF;
1948:
1949: l_msg_text := l_msg_data||
1950: OE_ORDER_UTIL.Get_Attribute_Name('APPLIED_FLAG');
1951: INSERT INTO OE_PROCESSING_MSGS
1952: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1953: ,line_id ,order_source_id ,original_sys_document_ref
1954: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 1986: OE_ORDER_UTIL.Get_Attribute_Name('INCLUDE_ON_RETURNS_FLAG');

1982: END IF;
1983:
1984:
1985: l_msg_text := l_msg_data||
1986: OE_ORDER_UTIL.Get_Attribute_Name('INCLUDE_ON_RETURNS_FLAG');
1987: INSERT INTO OE_PROCESSING_MSGS
1988: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1989: ,line_id ,order_source_id ,original_sys_document_ref
1990: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 2022: OE_ORDER_UTIL.Get_Attribute_Name('CREDIT_OR_CHARGE_FLAG');

2018: END IF;
2019:
2020:
2021: l_msg_text := l_msg_data||
2022: OE_ORDER_UTIL.Get_Attribute_Name('CREDIT_OR_CHARGE_FLAG');
2023: INSERT INTO OE_PROCESSING_MSGS
2024: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
2025: ,line_id ,order_source_id ,original_sys_document_ref
2026: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 2061: OE_ORDER_UTIL.Get_Attribute_Name('CHARGE_TYPE_CODE');

2057: END IF;
2058:
2059:
2060: l_msg_text := l_msg_data||
2061: OE_ORDER_UTIL.Get_Attribute_Name('CHARGE_TYPE_CODE');
2062: INSERT INTO OE_PROCESSING_MSGS
2063: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
2064: ,line_id ,order_source_id ,original_sys_document_ref
2065: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 2103: OE_ORDER_UTIL.Get_Attribute_Name('LIST_HEADER_ID');

2099: END IF;
2100: END IF;
2101:
2102: l_msg_text := l_msg_data||
2103: OE_ORDER_UTIL.Get_Attribute_Name('LIST_HEADER_ID');
2104: INSERT INTO OE_PROCESSING_MSGS
2105: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
2106: ,line_id ,order_source_id ,original_sys_document_ref
2107: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 2141: OE_ORDER_UTIL.Get_Attribute_Name('LIST_LINE_ID');

2137: END IF;
2138: END IF;
2139:
2140: l_msg_text := l_msg_data||
2141: OE_ORDER_UTIL.Get_Attribute_Name('LIST_LINE_ID');
2142: INSERT INTO OE_PROCESSING_MSGS
2143: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
2144: ,line_id ,order_source_id ,original_sys_document_ref
2145: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence

Line 2182: OE_ORDER_UTIL.Get_Attribute_Name('END_CUSTOMER_ID');

2178:
2179: --{bug 5054618
2180: -- End Customer Change
2181: l_msg_text := l_msg_data||
2182: OE_ORDER_UTIL.Get_Attribute_Name('END_CUSTOMER_ID');
2183: INSERT INTO OE_PROCESSING_MSGS
2184: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
2185: ,line_id ,order_source_id ,original_sys_document_ref
2186: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence