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_MSG_ID_S

Line 44: ,l_msg_text, OE_MSG_ID_S.NEXTVAL

40: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
41: ,660 ,NULL ,NULL
42: ,NULL ,NULL ,NULL
43: ,'C' ,USERENV('LANG')
44: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
45: FROM OE_HEADERS_IFACE_ALL
46: WHERE batch_id = p_batch_id
47: AND (order_source_id IS NULL OR orig_sys_document_ref IS NULL);
48:

Line 79: ,l_msg_text, OE_MSG_ID_S.NEXTVAL

75: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
76: ,660 ,NULL ,NULL
77: ,NULL ,NULL ,NULL
78: ,'C' ,USERENV('LANG')
79: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
80: FROM OE_HEADERS_IFACE_ALL h
81: WHERE batch_id = p_batch_id
82: AND EXISTS (SELECT 'Y'
83: FROM OE_ORDER_HEADERS oh

Line 119: ,l_msg_text, OE_MSG_ID_S.NEXTVAL

115: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
116: ,660 ,NULL ,NULL
117: ,NULL ,NULL ,NULL
118: ,'C' ,USERENV('LANG')
119: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
120: FROM OE_HEADERS_IFACE_ALL h
121: WHERE h.batch_id = p_batch_id
122: AND ( h.payment_type_code = 'CREDIT_CARD'
123: OR h.order_source_id = 10 -- 'Internal' Orders

Line 161: ,l_msg_text, OE_MSG_ID_S.NEXTVAL

157: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
158: ,660 ,NULL ,NULL
159: ,NULL ,NULL ,NULL
160: ,'C' ,USERENV('LANG')
161: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
162: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l
163: WHERE h.batch_id = p_batch_id
164: AND h.order_source_id = l.order_source_id
165: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 200: ,l_msg_text, OE_MSG_ID_S.NEXTVAL

196: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
197: ,660 ,NULL ,NULL
198: ,NULL ,NULL ,NULL
199: ,'C' ,USERENV('LANG')
200: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
201: FROM OE_HEADERS_IFACE_ALL h, OE_LINES_IFACE_ALL l
202: WHERE h.batch_id = p_batch_id
203: AND h.order_source_id = l.order_source_id
204: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 244: ,l_msg_text, OE_MSG_ID_S.NEXTVAL

240: ,FND_GLOBAL.USER_ID ,FND_GLOBAL.CONC_LOGIN_ID
241: ,660 ,NULL ,NULL
242: ,NULL ,NULL ,NULL
243: ,'C' ,USERENV('LANG')
244: ,l_msg_text, OE_MSG_ID_S.NEXTVAL
245: FROM OE_HEADERS_IFACE_ALL h, OE_PRICE_ADJS_INTERFACE l
246: WHERE h.batch_id = p_batch_id
247: AND h.order_source_id = l.order_source_id
248: AND h.orig_sys_document_ref = l.orig_sys_document_ref

Line 353: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

349: ,order_source_id ,orig_sys_document_ref ,NULL
350: ,NULL ,change_sequence,NULL,NULL,NULL,'ACCOUNTING_RULE_ID'
351: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
352: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
353: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
354: FROM OE_HEADERS_IFACE_ALL b
355: WHERE batch_id = p_batch_id and
356: b.accounting_rule_id IS NOT NULL and
357: NOT EXISTS (SELECT RULE_ID

Line 388: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

384: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
385: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ACCOUNTING_RULE_ID'
386: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
387: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
388: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
389: FROM OE_LINES_IFACE_ALL b
390: WHERE (order_source_id, orig_sys_document_ref) IN
391: ( SELECT order_source_id, orig_sys_document_ref
392: FROM OE_HEADERS_IFACE_ALL

Line 428: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

424: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
425: ,change_sequence ,NULL ,NULL ,NULL ,'CONVERSION_TYPE'
426: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
427: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
428: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
429: FROM OE_HEADERS_IFACE_ALL b
430: WHERE batch_id = p_batch_id and
431: b.CONVERSION_TYPE_CODE IS NOT NULL and
432: NOT EXISTS (SELECT CONVERSION_TYPE

Line 464: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

460: ,order_source_id ,orig_sys_document_ref ,NULL
461: ,NULL ,change_sequence,NULL,NULL,NULL,'DEMAND_CLASS_CODE'
462: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
463: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
464: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
465: FROM OE_HEADERS_IFACE_ALL b
466: WHERE batch_id = p_batch_id and
467: b.demand_class_code IS NOT NULL and
468: NOT EXISTS (SELECT FLV.LOOKUP_CODE

Line 519: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

515: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
516: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'DEMAND_CLASS_CODE'
517: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
518: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
519: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
520: FROM OE_LINES_IFACE_ALL b
521: WHERE (order_source_id, orig_sys_document_ref) IN
522: ( SELECT order_source_id, orig_sys_document_ref
523: FROM OE_HEADERS_IFACE_ALL

Line 580: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

576: ,order_source_id ,orig_sys_document_ref ,NULL
577: ,NULL ,change_sequence,NULL,NULL,NULL,'FOB_POINT'
578: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
579: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
580: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
581: FROM OE_HEADERS_IFACE_ALL b
582: WHERE batch_id = p_batch_id and
583: b.fob_point_code IS NOT NULL and
584: NOT EXISTS (SELECT LOOKUP_CODE

Line 619: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

615: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
616: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FOB_POINT_CODE'
617: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
618: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
619: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
620: FROM OE_LINES_IFACE_ALL b
621: WHERE (order_source_id, orig_sys_document_ref) IN
622: ( SELECT order_source_id, orig_sys_document_ref
623: FROM OE_HEADERS_IFACE_ALL

Line 662: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

658: ,order_source_id ,orig_sys_document_ref ,NULL
659: ,NULL ,change_sequence,NULL,NULL,NULL,'FREIGHT_TERMS_CODE'
660: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
661: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
662: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
663: FROM OE_HEADERS_IFACE_ALL b
664: WHERE batch_id = p_batch_id and
665: b.freight_terms_code IS NOT NULL and
666: NOT EXISTS (SELECT LOOKUP_CODE

Line 700: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

696: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
697: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'FREIGHT_TERMS_CODE'
698: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
699: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
700: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
701: FROM OE_LINES_IFACE_ALL b
702: WHERE (order_source_id, orig_sys_document_ref) IN
703: ( SELECT order_source_id, orig_sys_document_ref
704: FROM OE_HEADERS_IFACE_ALL

Line 742: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

738: ,order_source_id ,orig_sys_document_ref ,NULL
739: ,NULL ,change_sequence,NULL,NULL,NULL,'INVOICING_RULE_ID'
740: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
741: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
742: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
743: FROM OE_HEADERS_IFACE_ALL b
744: WHERE batch_id = p_batch_id and
745: b.invoicing_rule_id IS NOT NULL and
746: NOT EXISTS (SELECT RULE_ID

Line 778: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

774: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
775: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'INVOICING_RULE_ID'
776: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
777: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
778: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
779: FROM OE_LINES_IFACE_ALL b
780: WHERE (order_source_id, orig_sys_document_ref) IN
781: ( SELECT order_source_id, orig_sys_document_ref
782: FROM OE_HEADERS_IFACE_ALL

Line 819: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

815: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
816: ,change_sequence ,NULL ,NULL ,NULL ,'ORDER_DATE_TYPE_CODE'
817: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
818: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
819: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
820: FROM OE_HEADERS_IFACE_ALL b
821: WHERE batch_id = p_batch_id
822: AND b.order_date_type_code IS NOT NULL
823: AND NOT EXISTS (SELECT LOOKUP_CODE

Line 859: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

855: ,order_source_id ,orig_sys_document_ref ,NULL
856: ,NULL ,change_sequence,NULL,NULL,NULL,'PAYMENT_TERM_ID'
857: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
858: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
859: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
860: FROM OE_HEADERS_IFACE_ALL b
861: WHERE batch_id = p_batch_id and
862: b.payment_term_id IS NOT NULL and
863: NOT EXISTS (select a.TERM_ID

Line 895: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

891: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
892: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PAYMENT_TERM_ID'
893: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
894: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
895: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
896: FROM OE_LINES_IFACE_ALL b
897: WHERE (order_source_id, orig_sys_document_ref) IN
898: ( SELECT order_source_id, orig_sys_document_ref
899: FROM OE_HEADERS_IFACE_ALL

Line 936: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

932: ,order_source_id ,orig_sys_document_ref ,NULL
933: ,NULL ,change_sequence,NULL,NULL,NULL,'PRICE_LIST_ID'
934: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
935: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
936: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
937: FROM OE_HEADERS_IFACE_ALL b
938: WHERE batch_id = p_batch_id and
939: b.price_list_id IS NOT NULL and
940: NOT EXISTS (select list_header_id

Line 972: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

968: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
969: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PRICE_LIST_ID'
970: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
971: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
972: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
973: FROM OE_LINES_IFACE_ALL b
974: WHERE (order_source_id, orig_sys_document_ref) IN
975: ( SELECT order_source_id, orig_sys_document_ref
976: FROM OE_HEADERS_IFACE_ALL

Line 1012: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1008: ,order_source_id ,orig_sys_document_ref ,NULL
1009: ,NULL ,change_sequence,NULL,NULL,NULL,'SHIPMENT_PRIORITY_CODE'
1010: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1011: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1012: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1013: FROM OE_HEADERS_IFACE_ALL b
1014: WHERE batch_id = p_batch_id and
1015: b.shipment_priority_code IS NOT NULL and
1016: NOT EXISTS (select LOOKUP_CODE

Line 1050: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1046: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1047: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPMENT_PRIORITY_CODE'
1048: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1049: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1050: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1051: FROM OE_LINES_IFACE_ALL b
1052: WHERE (order_source_id, orig_sys_document_ref) IN
1053: ( SELECT order_source_id, orig_sys_document_ref
1054: FROM OE_HEADERS_IFACE_ALL

Line 1093: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1089: ,order_source_id ,orig_sys_document_ref ,NULL
1090: ,NULL ,change_sequence,NULL,NULL,NULL,'SHIPPING_METHOD'
1091: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1092: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1093: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1094: FROM OE_HEADERS_IFACE_ALL b
1095: WHERE batch_id = p_batch_id and
1096: b.shipping_method_code IS NOT NULL and
1097: NOT EXISTS (select LOOKUP_CODE

Line 1128: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1124: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1125: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SHIPPING_METHOD_CODE'
1126: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1127: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1128: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1129: FROM OE_LINES_IFACE_ALL b
1130: WHERE (order_source_id, orig_sys_document_ref) IN
1131: ( SELECT order_source_id, orig_sys_document_ref
1132: FROM OE_HEADERS_IFACE_ALL

Line 1168: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1164: ,order_source_id ,orig_sys_document_ref ,NULL
1165: ,NULL ,change_sequence,NULL,NULL,NULL,'SOLD_TO_ORG'
1166: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1167: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1168: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1169: FROM OE_HEADERS_IFACE_ALL b
1170: WHERE batch_id = p_batch_id and
1171: b.sold_to_org_id IS NOT NULL and
1172: NOT EXISTS (select ORGANIZATION_ID

Line 1205: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1201: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1202: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SOLD_TO_ORG_ID'
1203: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1204: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1205: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1206: FROM OE_LINES_IFACE_ALL b
1207: WHERE (order_source_id, orig_sys_document_ref) IN
1208: ( SELECT order_source_id, orig_sys_document_ref
1209: FROM OE_HEADERS_IFACE_ALL

Line 1247: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1243: ,order_source_id ,orig_sys_document_ref ,NULL
1244: ,NULL ,change_sequence,NULL,NULL,NULL,'TAX_EXEMPT_FLAG'
1245: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1246: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1247: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1248: FROM OE_HEADERS_IFACE_ALL b
1249: WHERE batch_id = p_batch_id and
1250: b.tax_exempt_flag IS NOT NULL and
1251: NOT EXISTS (SELECT LOOKUP_CODE

Line 1285: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1281: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1282: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'TAX_EXEMPT_FLAG'
1283: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1284: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1285: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1286: FROM OE_LINES_IFACE_ALL b
1287: WHERE (order_source_id, orig_sys_document_ref) IN
1288: ( SELECT order_source_id, orig_sys_document_ref
1289: FROM OE_HEADERS_IFACE_ALL

Line 1328: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1324: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
1325: ,change_sequence ,NULL ,NULL ,NULL ,'TRANSACTIONAL_CURR_CODE'
1326: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1327: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1328: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1329: FROM OE_HEADERS_IFACE_ALL b
1330: WHERE batch_id = p_batch_id and
1331: b.transactional_curr_code IS NOT NULL and
1332: NOT EXISTS (SELECT CURRENCY_CODE

Line 1368: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1364: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
1365: ,change_sequence ,NULL ,NULL ,NULL ,'PAYMENT_TYPE_CODE'
1366: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1367: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1368: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1369: FROM OE_HEADERS_IFACE_ALL b
1370: WHERE batch_id = p_batch_id and
1371: b.payment_type_code IS NOT NULL and
1372: NOT EXISTS (SELECT LOOKUP_CODE

Line 1409: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1405: ,order_source_id ,orig_sys_document_ref ,NULL
1406: ,NULL ,change_sequence,NULL,NULL,NULL,'SALESREP_ID'
1407: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1408: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1409: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1410: FROM OE_HEADERS_IFACE_ALL b
1411: WHERE batch_id = p_batch_id
1412: AND b.salesrep_id IS NOT NULL
1413: AND NOT EXISTS (SELECT a.salesrep_id

Line 1458: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1454: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1455: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'SALESREP_ID'
1456: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1457: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1458: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1459: FROM OE_LINES_IFACE_ALL b
1460: WHERE (order_source_id, orig_sys_document_ref) IN
1461: ( SELECT order_source_id, orig_sys_document_ref
1462: FROM OE_HEADERS_IFACE_ALL

Line 1512: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1508: ,order_source_id ,orig_sys_document_ref ,NULL ,NULL
1509: ,change_sequence ,NULL ,NULL ,NULL ,'SALES_CHANNEL_CODE'
1510: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1511: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1512: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1513: FROM OE_HEADERS_IFACE_ALL b
1514: WHERE batch_id = p_batch_id and
1515: b.sales_channel_code IS NOT NULL and
1516: NOT EXISTS (SELECT LOOKUP_CODE

Line 1552: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1548: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1549: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1550: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1551: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1552: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1553: FROM OE_LINES_IFACE_ALL b
1554: WHERE (order_source_id, orig_sys_document_ref) IN
1555: ( SELECT order_source_id, orig_sys_document_ref
1556: FROM OE_HEADERS_IFACE_ALL

Line 1590: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1586: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1587: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_ITEM_UNIT_NUMBER'
1588: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1589: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1590: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1591: FROM OE_LINES_IFACE_ALL b
1592: WHERE (order_source_id, orig_sys_document_ref) IN
1593: ( SELECT order_source_id, orig_sys_document_ref
1594: FROM OE_HEADERS_IFACE_ALL

Line 1635: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1631: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1632: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1633: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1634: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1635: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1636: FROM OE_LINES_IFACE_ALL b
1637: WHERE (order_source_id, orig_sys_document_ref) IN
1638: ( SELECT order_source_id, orig_sys_document_ref
1639: FROM OE_HEADERS_IFACE_ALL

Line 1681: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1677: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1678: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1679: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1680: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1681: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1682: FROM OE_LINES_IFACE_ALL b
1683: WHERE (order_source_id, orig_sys_document_ref) IN
1684: ( SELECT order_source_id, orig_sys_document_ref
1685: FROM OE_HEADERS_IFACE_ALL

Line 1728: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1724: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1725: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1726: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1727: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1728: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1729: FROM OE_LINES_IFACE_ALL b
1730: WHERE (order_source_id, orig_sys_document_ref) IN
1731: ( SELECT order_source_id, orig_sys_document_ref
1732: FROM OE_HEADERS_IFACE_ALL

Line 1776: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1772: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1773: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'ORDERED_QUANTITY_UOM2'
1774: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1775: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1776: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1777: FROM OE_LINES_IFACE_ALL b
1778: WHERE (order_source_id, orig_sys_document_ref) IN
1779: ( SELECT order_source_id, orig_sys_document_ref
1780: FROM OE_HEADERS_IFACE_ALL

Line 1829: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1825: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
1826: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'PREFERRED_GRADE'
1827: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1828: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1829: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1830: FROM OE_LINES_IFACE_ALL b
1831: WHERE (order_source_id, orig_sys_document_ref) IN
1832: ( SELECT order_source_id, orig_sys_document_ref
1833: FROM OE_HEADERS_IFACE_ALL

Line 1882: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1878: ,order_source_id ,orig_sys_document_ref ,NULL
1879: ,NULL ,change_sequence,NULL,NULL,NULL,'TRANSACTION_PHASE_CODE'
1880: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1881: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1882: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1883: FROM OE_HEADERS_IFACE_ALL b
1884: WHERE batch_id = p_batch_id and
1885: b.transaction_phase_code IS NOT NULL
1886: -- Only fulfillment orders are supported for HVOP

Line 1917: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1913: ,order_source_id ,orig_sys_document_ref ,NULL
1914: ,NULL ,change_sequence,NULL,NULL,NULL,'VERSION_NUMBER'
1915: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1916: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
1917: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1918: FROM OE_HEADERS_IFACE_ALL b
1919: WHERE batch_id = p_batch_id and
1920: b.version_number IS NOT NULL
1921: -- Version number cannot be negative or in decimals

Line 1967: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1963: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
1964: ,a.change_sequence ,NULL ,NULL ,NULL ,'APPLIED_FLAG'
1965: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
1966: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
1967: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
1968: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
1969: WHERE h.batch_id = p_batch_id
1970: AND a.order_source_id = h.order_source_id
1971: AND a.orig_sys_document_ref = h.orig_sys_document_ref

Line 2003: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

1999: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
2000: ,a.change_sequence ,NULL ,NULL ,NULL ,'INCLUDE_ON_RETURNS_FLAG'
2001: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2002: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2003: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2004: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2005: WHERE h.batch_id = p_batch_id
2006: AND a.order_source_id = h.order_source_id
2007: AND a.orig_sys_document_ref = h.orig_sys_document_ref

Line 2039: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

2035: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
2036: ,a.change_sequence ,NULL ,NULL ,NULL ,'CREDIT_OR_CHARGE_FLAG'
2037: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2038: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2039: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2040: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2041: WHERE h.batch_id = p_batch_id
2042: AND a.order_source_id = h.order_source_id
2043: AND a.orig_sys_document_ref = h.orig_sys_document_ref

Line 2078: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

2074: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
2075: ,a.change_sequence ,NULL ,NULL ,NULL ,'CHARGE_TYPE_CODE'
2076: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2077: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2078: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2079: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2080: WHERE h.batch_id = p_batch_id
2081: AND a.order_source_id = h.order_source_id
2082: AND a.orig_sys_document_ref = h.orig_sys_document_ref

Line 2120: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

2116: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
2117: ,a.change_sequence ,NULL ,NULL ,NULL ,'LIST_HEADER_ID'
2118: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2119: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2120: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2121: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2122: WHERE h.batch_id = p_batch_id
2123: AND a.order_source_id = h.order_source_id
2124: AND a.orig_sys_document_ref = h.orig_sys_document_ref

Line 2158: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

2154: ,NULL, a.order_source_id ,a.orig_sys_document_ref, a.orig_sys_line_ref ,NULL
2155: ,a.change_sequence ,NULL ,NULL ,NULL ,'LIST_LINE_ID'
2156: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2157: ,FND_GLOBAL.CONC_LOGIN_ID ,660 ,NULL ,NULL ,NULL ,NULL ,NULL
2158: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2159: FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
2160: WHERE h.batch_id = p_batch_id
2161: AND a.order_source_id = h.order_source_id
2162: AND a.orig_sys_document_ref = h.orig_sys_document_ref

Line 2199: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

2195: ,order_source_id ,orig_sys_document_ref ,NULL
2196: ,NULL ,change_sequence,NULL,NULL,NULL,'END_CUSTOMER'
2197: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2198: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
2199: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2200: FROM OE_HEADERS_IFACE_ALL b
2201: WHERE batch_id = p_batch_id and
2202: b.sold_to_org_id IS NOT NULL and
2203: NOT EXISTS (select ORGANIZATION_ID

Line 2236: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL

2232: ,order_source_id ,orig_sys_document_ref ,ORIG_SYS_LINE_REF
2233: ,orig_sys_shipment_ref ,change_sequence,NULL,NULL,NULL,'END_CUSTOMER_ID'
2234: ,sysdate ,FND_GLOBAL.USER_ID ,sysdate ,FND_GLOBAL.USER_ID
2235: ,FND_GLOBAL.CONC_LOGIN_ID ,660,NULL,NULL,NULL,NULL,NULL
2236: ,'C' ,USERENV('LANG') ,l_msg_text, OE_MSG_ID_S.NEXTVAL
2237: FROM OE_LINES_IFACE_ALL b
2238: WHERE (order_source_id, orig_sys_document_ref) IN
2239: ( SELECT order_source_id, orig_sys_document_ref
2240: FROM OE_HEADERS_IFACE_ALL

Line 2326: OE_MSG_ID_S.NEXTVAL

2322: ,660 ,NULL ,NULL
2323: ,NULL ,NULL ,NULL
2324: ,'C' ,USERENV('LANG')
2325: ,l_msg_text || ' '|| l.ordered_item,
2326: OE_MSG_ID_S.NEXTVAL
2327: FROM oe_config_details_tmp L
2328: WHERE NVL(L.item_type_code, 'XXX') <> 'MODEL'
2329: AND NOT EXISTS (select L2.line_id
2330: From oe_config_details_tmp L2

Line 2371: OE_MSG_ID_S.NEXTVAL

2367: ,'C' ,USERENV('LANG')
2368: ,l_msg_text ||' '||l.ordered_item || '( '||
2369: l.low_quantity*L2.ordered_quantity
2370: || ' -> '|| l.high_quantity *L2.ordered_quantity || ')',
2371: OE_MSG_ID_S.NEXTVAL
2372: FROM oe_config_details_tmp L,
2373: oe_config_details_tmp L2
2374: WHERE L2.item_type_code = 'MODEL'
2375: AND L.top_model_line_id = L2.line_id

Line 2413: ,OE_MSG_ID_S.NEXTVAL

2409: ,660 ,NULL ,NULL
2410: ,NULL ,NULL ,NULL
2411: ,'C' ,USERENV('LANG')
2412: ,l_msg_text || ' '||l.ordered_item
2413: ,OE_MSG_ID_S.NEXTVAL
2414: FROM oe_config_details_tmp L
2415: WHERE L.BOM_ITEM_TYPE = 2
2416: AND L.ordered_quantity > 0
2417: AND NOT EXISTS ( -- fix bug 5687771

Line 2457: ,OE_MSG_ID_S.NEXTVAL

2453: ,660 ,NULL ,NULL
2454: ,NULL ,NULL ,NULL
2455: ,'C' ,USERENV('LANG')
2456: ,l_msg_text || ' '||l.ordered_item
2457: ,OE_MSG_ID_S.NEXTVAL
2458: FROM oe_config_details_tmp L
2459: WHERE L.ITEM_TYPE_CODE in ('CLASS','MODEL')
2460: AND L.mutually_exclusive_options = 1
2461: AND 2 <= ( select count(line_id)

Line 2499: , OE_MSG_ID_S.NEXTVAL

2495: ,660 ,NULL ,NULL
2496: ,NULL ,NULL ,NULL
2497: ,'C' ,USERENV('LANG')
2498: ,l_msg_text || ' '||l.ordered_item
2499: , OE_MSG_ID_S.NEXTVAL
2500: FROM oe_config_details_tmp L
2501: WHERE L.ITEM_TYPE_CODE = 'MODEL'
2502: AND EXISTS (select b2.component_code
2503: From bom_explosions b2