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_PROCESSING_MSGS

Line 24: INSERT INTO OE_PROCESSING_MSGS

20: --
21: BEGIN
22:
23: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_BULK_REQD_HDR_ATTRIBUTES');
24: INSERT INTO OE_PROCESSING_MSGS
25: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
26: ,order_source_id ,original_sys_document_ref
27: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
28: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 59: INSERT INTO OE_PROCESSING_MSGS

55: END IF;
56: END IF;
57:
58: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_OI_OPERATION_CODE');
59: INSERT INTO OE_PROCESSING_MSGS
60: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
61: ,order_source_id ,original_sys_document_ref
62: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
63: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 99: INSERT INTO OE_PROCESSING_MSGS

95: END IF;
96:
97: -- comment out with config support change
98: /* l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_BULK_NOT_SUPP_HDR_ATTRIBS');
99: INSERT INTO OE_PROCESSING_MSGS
100: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
101: ,order_source_id ,original_sys_document_ref
102: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
103: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 141: INSERT INTO OE_PROCESSING_MSGS

137: END IF;
138: END IF;
139: */
140: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_OI_ORIG_SYS_LINE_REF');
141: INSERT INTO OE_PROCESSING_MSGS
142: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
143: ,order_source_id ,original_sys_document_ref
144: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
145: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 180: INSERT INTO OE_PROCESSING_MSGS

176: END IF;
177: -- comment out with config support change
178:
179: /* l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_BULK_NOT_SUPP_LINE_ATTRIBS');
180: INSERT INTO OE_PROCESSING_MSGS
181: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
182: ,order_source_id ,original_sys_document_ref
183: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
184: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 223: INSERT INTO OE_PROCESSING_MSGS

219: END IF;
220: */
221:
222: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_OI_ORIG_SYS_DISCOUNT_REF');
223: INSERT INTO OE_PROCESSING_MSGS
224: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
225: ,order_source_id ,original_sys_document_ref
226: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
227: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 337: INSERT INTO OE_PROCESSING_MSGS

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
338: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
339: ,line_id ,order_source_id ,original_sys_document_ref
340: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
341: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 372: INSERT INTO OE_PROCESSING_MSGS

368: END IF;
369: END IF;
370: END IF;
371:
372: INSERT INTO OE_PROCESSING_MSGS
373: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
374: ,line_id ,order_source_id ,original_sys_document_ref
375: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
376: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 412: INSERT INTO OE_PROCESSING_MSGS

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
416: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 448: INSERT INTO OE_PROCESSING_MSGS

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
452: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 503: INSERT INTO OE_PROCESSING_MSGS

499: END IF;
500: END IF;
501: END IF;
502:
503: INSERT INTO OE_PROCESSING_MSGS
504: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
505: ,line_id ,order_source_id ,original_sys_document_ref
506: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
507: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 564: INSERT INTO OE_PROCESSING_MSGS

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
568: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 603: INSERT INTO OE_PROCESSING_MSGS

599: END IF;
600: END IF;
601:
602:
603: INSERT INTO OE_PROCESSING_MSGS
604: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
605: ,line_id ,order_source_id ,original_sys_document_ref
606: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
607: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 646: INSERT INTO OE_PROCESSING_MSGS

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
650: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 684: INSERT INTO OE_PROCESSING_MSGS

680: END IF;
681: END IF;
682: END IF;
683:
684: INSERT INTO OE_PROCESSING_MSGS
685: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
686: ,line_id ,order_source_id ,original_sys_document_ref
687: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
688: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 726: INSERT INTO OE_PROCESSING_MSGS

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
730: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 762: INSERT INTO OE_PROCESSING_MSGS

758: END IF;
759: END IF;
760: END IF;
761:
762: INSERT INTO OE_PROCESSING_MSGS
763: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
764: ,line_id ,order_source_id ,original_sys_document_ref
765: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
766: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 803: INSERT INTO OE_PROCESSING_MSGS

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
807: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 843: INSERT INTO OE_PROCESSING_MSGS

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
847: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 879: INSERT INTO OE_PROCESSING_MSGS

875: END IF;
876: END IF;
877: END IF;
878:
879: INSERT INTO OE_PROCESSING_MSGS
880: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
881: ,line_id ,order_source_id ,original_sys_document_ref
882: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
883: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 920: INSERT INTO OE_PROCESSING_MSGS

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
924: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 956: INSERT INTO OE_PROCESSING_MSGS

952: END IF;
953: END IF;
954: END IF;
955:
956: INSERT INTO OE_PROCESSING_MSGS
957: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
958: ,line_id ,order_source_id ,original_sys_document_ref
959: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
960: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 996: INSERT INTO OE_PROCESSING_MSGS

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
1000: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1034: INSERT INTO OE_PROCESSING_MSGS

1030: END IF;
1031: END IF;
1032: END IF;
1033:
1034: INSERT INTO OE_PROCESSING_MSGS
1035: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1036: ,line_id ,order_source_id ,original_sys_document_ref
1037: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
1038: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1077: INSERT INTO OE_PROCESSING_MSGS

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
1081: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1112: INSERT INTO OE_PROCESSING_MSGS

1108: END IF;
1109: END IF;
1110: END IF;
1111:
1112: INSERT INTO OE_PROCESSING_MSGS
1113: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1114: ,line_id ,order_source_id ,original_sys_document_ref
1115: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
1116: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1152: INSERT INTO OE_PROCESSING_MSGS

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
1156: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1189: INSERT INTO OE_PROCESSING_MSGS

1185: END IF;
1186: END IF;
1187: END IF;
1188:
1189: INSERT INTO OE_PROCESSING_MSGS
1190: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1191: ,line_id ,order_source_id ,original_sys_document_ref
1192: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
1193: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1231: INSERT INTO OE_PROCESSING_MSGS

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
1235: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1269: INSERT INTO OE_PROCESSING_MSGS

1265: END IF;
1266: END IF;
1267: END IF;
1268:
1269: INSERT INTO OE_PROCESSING_MSGS
1270: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1271: ,line_id ,order_source_id ,original_sys_document_ref
1272: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
1273: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1312: INSERT INTO OE_PROCESSING_MSGS

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
1316: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1352: INSERT INTO OE_PROCESSING_MSGS

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
1356: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1393: INSERT INTO OE_PROCESSING_MSGS

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
1396: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
1397: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1442: INSERT INTO OE_PROCESSING_MSGS

1438: END IF;
1439: END IF;
1440: END IF;
1441:
1442: INSERT INTO OE_PROCESSING_MSGS
1443: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
1444: ,line_id ,order_source_id ,original_sys_document_ref
1445: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
1446: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1496: INSERT INTO OE_PROCESSING_MSGS

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
1500: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1536: INSERT INTO OE_PROCESSING_MSGS

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
1540: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1574: INSERT INTO OE_PROCESSING_MSGS

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
1578: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1619: INSERT INTO OE_PROCESSING_MSGS

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
1623: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1665: INSERT INTO OE_PROCESSING_MSGS

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
1669: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1712: INSERT INTO OE_PROCESSING_MSGS

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
1716: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1760: INSERT INTO OE_PROCESSING_MSGS

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
1764: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1813: INSERT INTO OE_PROCESSING_MSGS

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
1817: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1866: INSERT INTO OE_PROCESSING_MSGS

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
1870: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1901: INSERT INTO OE_PROCESSING_MSGS

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
1905: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1951: INSERT INTO OE_PROCESSING_MSGS

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
1955: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 1987: INSERT INTO OE_PROCESSING_MSGS

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
1991: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 2023: INSERT INTO OE_PROCESSING_MSGS

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
2027: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 2062: INSERT INTO OE_PROCESSING_MSGS

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
2066: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 2104: INSERT INTO OE_PROCESSING_MSGS

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
2108: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 2142: INSERT INTO OE_PROCESSING_MSGS

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
2146: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 2183: INSERT INTO OE_PROCESSING_MSGS

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
2187: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 2220: INSERT INTO OE_PROCESSING_MSGS

2216: END IF;
2217: END IF;
2218: END IF;
2219:
2220: INSERT INTO OE_PROCESSING_MSGS
2221: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id
2222: ,line_id ,order_source_id ,original_sys_document_ref
2223: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
2224: ,source_document_type_id ,source_document_id ,source_document_line_id

Line 2305: INSERT INTO OE_PROCESSING_MSGS

2301: -- Check if parent exists
2302:
2303: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_BULK_CONFIG_MISS_PARENT');
2304:
2305: INSERT INTO OE_PROCESSING_MSGS
2306: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
2307: ,order_source_id ,original_sys_document_ref
2308: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
2309: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 2348: INSERT INTO OE_PROCESSING_MSGS

2344: -- Check for min max quantities
2345:
2346: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_BULK_CONFIG_QTY_RANGE');
2347:
2348: INSERT INTO OE_PROCESSING_MSGS
2349: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
2350: ,order_source_id ,original_sys_document_ref
2351: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
2352: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 2392: INSERT INTO OE_PROCESSING_MSGS

2388:
2389: -- Check for class has options
2390: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_BULK_CONFIG_CLS_NO_OPTION');
2391:
2392: INSERT INTO OE_PROCESSING_MSGS
2393: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
2394: ,order_source_id ,original_sys_document_ref
2395: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
2396: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 2436: INSERT INTO OE_PROCESSING_MSGS

2432:
2433: -- existing message can used without specifying the token.
2434: l_msg_text := FND_MESSAGE.GET_STRING('ONT', 'OE_BULK_CONFIG_EXCLUSIVE_CLS');
2435:
2436: INSERT INTO OE_PROCESSING_MSGS
2437: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
2438: ,order_source_id ,original_sys_document_ref
2439: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
2440: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 2478: INSERT INTO OE_PROCESSING_MSGS

2474: -- Check for mandatory classes
2475:
2476: l_msg_text := FND_MESSAGE.GET_STRING('ONT', 'OE_BULK_CONFIG_MANDATORY_CLS');
2477:
2478: INSERT INTO OE_PROCESSING_MSGS
2479: ( request_id ,entity_code ,entity_ref ,entity_id ,header_id, line_id
2480: ,order_source_id ,original_sys_document_ref
2481: ,original_sys_document_line_ref ,orig_sys_shipment_ref ,change_sequence
2482: ,attribute_code ,creation_date ,created_by ,last_update_date

Line 2619: FROM oe_processing_msgs b

2615: ,attribute_status = NULL
2616: where nvl(error_flag, 'N') = 'N'
2617: AND EXISTS
2618: (SELECT original_sys_document_line_ref
2619: FROM oe_processing_msgs b
2620: WHERE b.original_sys_document_ref = a.orig_sys_document_ref
2621: AND b.original_sys_document_line_ref = a.orig_sys_line_ref
2622: AND b.order_source_id = a.order_source_id
2623: AND b.request_id = oe_bulk_order_pvt.g_request_id);

Line 2649: from oe_processing_msgs b

2645: WHERE batch_id = p_batch_id
2646: AND nvl(error_flag,'N') = 'N'
2647: AND EXISTS
2648: (SELECT original_sys_document_ref
2649: from oe_processing_msgs b
2650: WHERE b.original_sys_document_ref = a.orig_sys_document_ref
2651: AND b.order_source_id = a.order_source_id
2652: and b.original_sys_document_line_ref is NULL
2653: AND b.request_id = oe_bulk_order_pvt.g_request_id);

Line 2685: FROM OE_PROCESSING_MSGS b

2681: WHERE batch_id = p_batch_id
2682: AND nvl(ERROR_FLAG, 'N') = 'N'
2683: AND EXISTS
2684: (SELECT original_sys_document_line_ref
2685: FROM OE_PROCESSING_MSGS b
2686: WHERE b.original_sys_document_ref = a.ORIG_SYS_DOCUMENT_REF
2687: AND b.order_source_id = a.order_source_id
2688: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID); -- Added for Bug 6671781
2689:

Line 2701: FROM OE_HEADERS_IFACE_ALL a, OE_PROCESSING_MSGS b

2697: UPDATE OE_LINES_IFACE_ALL c
2698: SET ATTRIBUTE_STATUS = NULL
2699: WHERE (order_source_id, orig_sys_document_ref) IN
2700: (SELECT a.order_source_id, a.orig_sys_document_ref
2701: FROM OE_HEADERS_IFACE_ALL a, OE_PROCESSING_MSGS b
2702: WHERE a.batch_id = p_batch_id
2703: AND b.original_sys_document_ref = a.ORIG_SYS_DOCUMENT_REF
2704: AND b.order_source_id = a.order_source_id
2705: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID);--Added for bug 6830039