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.OKS_IMPORT_VALIDATE dependencies on OKS_HEADERS_INTERFACE

Line 240: ,'OKS_HEADERS_INTERFACE'

236: ,ERROR_MSG
237: ,MSG_TOKENS)
238: VALUES (G_WORKER_REQ_ID
239: ,HEADER_INTERFACE_ROWID
240: ,'OKS_HEADERS_INTERFACE'
241: ,HEADER_INTERFACE_ID
242: ,'OKS_IMP_HDR_INVALID_OU'
243: ,NULL)
244: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN

Line 254: ,'OKS_HEADERS_INTERFACE'

250: ,ERROR_MSG
251: ,MSG_TOKENS)
252: VALUES (G_WORKER_REQ_ID
253: ,HEADER_INTERFACE_ROWID
254: ,'OKS_HEADERS_INTERFACE'
255: ,HEADER_INTERFACE_ID
256: ,'OKS_IMP_HDR_INVALID_BTSU'
257: ,NULL)
258: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN

Line 268: ,'OKS_HEADERS_INTERFACE'

264: ,ERROR_MSG
265: ,MSG_TOKENS)
266: VALUES (G_WORKER_REQ_ID
267: ,HEADER_INTERFACE_ROWID
268: ,'OKS_HEADERS_INTERFACE'
269: ,HEADER_INTERFACE_ID
270: ,'OKS_IMP_HDR_INVALID_STSU'
271: ,NULL)
272: WHEN (CONTRACT_CURRENCY_CODE IS NULL) THEN

Line 282: ,'OKS_HEADERS_INTERFACE'

278: ,ERROR_MSG
279: ,MSG_TOKENS)
280: VALUES (G_WORKER_REQ_ID
281: ,HEADER_INTERFACE_ROWID
282: ,'OKS_HEADERS_INTERFACE'
283: ,HEADER_INTERFACE_ID
284: ,'OKS_IMP_HDR_INVALID_CUR_CODE'
285: ,NULL)
286: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL

Line 298: ,'OKS_HEADERS_INTERFACE'

294: ,ERROR_MSG
295: ,MSG_TOKENS)
296: VALUES (G_WORKER_REQ_ID
297: ,HEADER_INTERFACE_ROWID
298: ,'OKS_HEADERS_INTERFACE'
299: ,HEADER_INTERFACE_ID
300: ,'OKS_IMP_HDR_INVALID_CONV_TYPE'
301: ,NULL)
302: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL

Line 315: ,'OKS_HEADERS_INTERFACE'

311: ,ERROR_MSG
312: ,MSG_TOKENS)
313: VALUES (G_WORKER_REQ_ID
314: ,HEADER_INTERFACE_ROWID
315: ,'OKS_HEADERS_INTERFACE'
316: ,HEADER_INTERFACE_ID
317: ,'OKS_IMP_HDR_INVALID_CONV_RATE'
318: ,NULL)
319: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL

Line 331: ,'OKS_HEADERS_INTERFACE'

327: ,ERROR_MSG
328: ,MSG_TOKENS)
329: VALUES (G_WORKER_REQ_ID
330: ,HEADER_INTERFACE_ROWID
331: ,'OKS_HEADERS_INTERFACE'
332: ,HEADER_INTERFACE_ID
333: ,'OKS_IMP_HDR_INVALID_CONV_DATE'
334: ,NULL)
335: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL

Line 348: ,'OKS_HEADERS_INTERFACE'

344: ,ERROR_MSG
345: ,MSG_TOKENS)
346: VALUES (G_WORKER_REQ_ID
347: ,HEADER_INTERFACE_ROWID
348: ,'OKS_HEADERS_INTERFACE'
349: ,HEADER_INTERFACE_ID
350: ,'OKS_IMP_HDR_NULL_CONV_RATE'
351: ,NULL)
352: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL

Line 366: ,'OKS_HEADERS_INTERFACE'

362: ,ERROR_MSG
363: ,MSG_TOKENS)
364: VALUES (G_WORKER_REQ_ID
365: ,HEADER_INTERFACE_ROWID
366: ,'OKS_HEADERS_INTERFACE'
367: ,HEADER_INTERFACE_ID
368: ,'OKS_IMP_HDR_NULL_CONV'
369: ,NULL)
370: WHEN (PRICE_LIST_ID IS NULL) THEN

Line 380: ,'OKS_HEADERS_INTERFACE'

376: ,ERROR_MSG
377: ,MSG_TOKENS)
378: VALUES (G_WORKER_REQ_ID
379: ,HEADER_INTERFACE_ROWID
380: ,'OKS_HEADERS_INTERFACE'
381: ,HEADER_INTERFACE_ID
382: ,'OKS_IMP_HDR_INVALID_PRICELIST'
383: ,NULL)
384: WHEN (PAYMENT_TERMS_ID IS NULL) THEN

Line 394: ,'OKS_HEADERS_INTERFACE'

390: ,ERROR_MSG
391: ,MSG_TOKENS)
392: VALUES (G_WORKER_REQ_ID
393: ,HEADER_INTERFACE_ROWID
394: ,'OKS_HEADERS_INTERFACE'
395: ,HEADER_INTERFACE_ID
396: ,'OKS_IMP_HDR_INVALID_PAYTERM'
397: ,NULL)
398: WHEN (HDR_PAYMENT_INSTRUCTION IS NOT NULL AND PAYMENT_INSTRUCTION IS NULL) THEN

Line 408: ,'OKS_HEADERS_INTERFACE'

404: ,ERROR_MSG
405: ,MSG_TOKENS)
406: VALUES (G_WORKER_REQ_ID
407: ,HEADER_INTERFACE_ROWID
408: ,'OKS_HEADERS_INTERFACE'
409: ,HEADER_INTERFACE_ID
410: ,'OKS_IMP_HDR_INVALID_PAYINSTR'
411: ,NULL)
412: WHEN (INVOICING_RULE_ID IS NULL) THEN

Line 422: ,'OKS_HEADERS_INTERFACE'

418: ,ERROR_MSG
419: ,MSG_TOKENS)
420: VALUES (G_WORKER_REQ_ID
421: ,HEADER_INTERFACE_ROWID
422: ,'OKS_HEADERS_INTERFACE'
423: ,HEADER_INTERFACE_ID
424: ,'OKS_IMP_HDR_INVALID_INVRULE'
425: ,NULL)
426: WHEN (HDR_PAYMENT_METHOD_CODE IS NOT NULL AND PAYMENT_METHOD_CODE IS NULL) THEN

Line 436: ,'OKS_HEADERS_INTERFACE'

432: ,ERROR_MSG
433: ,MSG_TOKENS)
434: VALUES (G_WORKER_REQ_ID
435: ,HEADER_INTERFACE_ROWID
436: ,'OKS_HEADERS_INTERFACE'
437: ,HEADER_INTERFACE_ID
438: ,'OKS_IMP_HDR_INVALID_PMC'
439: ,NULL)
440: WHEN ((PAYMENT_METHOD_CODE IS NOT NULL OR HDR_COMMITMENT_ID IS NOT NULL) AND COMMITMENT_ID IS NULL) THEN

Line 450: ,'OKS_HEADERS_INTERFACE'

446: ,ERROR_MSG
447: ,MSG_TOKENS)
448: VALUES (G_WORKER_REQ_ID
449: ,HEADER_INTERFACE_ROWID
450: ,'OKS_HEADERS_INTERFACE'
451: ,HEADER_INTERFACE_ID
452: ,'OKS_IMP_HDR_INVALID_COMMIT'
453: ,NULL)
454: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN

Line 464: ,'OKS_HEADERS_INTERFACE'

460: ,ERROR_MSG
461: ,MSG_TOKENS)
462: VALUES (G_WORKER_REQ_ID
463: ,HEADER_INTERFACE_ROWID
464: ,'OKS_HEADERS_INTERFACE'
465: ,HEADER_INTERFACE_ID
466: ,'OKS_IMP_HDR_INVALID_ACCRULE'
467: ,NULL)
468: WHEN (PRICING_METHOD = 'LST' AND RENEWAL_PRICE_LIST_ID IS NULL)

Line 479: ,'OKS_HEADERS_INTERFACE'

475: ,ERROR_MSG
476: ,MSG_TOKENS)
477: VALUES (G_WORKER_REQ_ID
478: ,HEADER_INTERFACE_ROWID
479: ,'OKS_HEADERS_INTERFACE'
480: ,HEADER_INTERFACE_ID
481: ,'OKS_IMP_HDR_RENPL_MANDATORY'
482: ,NULL)
483: WHEN (REN_PL_PROVIDED = 'Y' AND RENEWAL_PRICE_LIST_ID IS NULL) THEN

Line 493: ,'OKS_HEADERS_INTERFACE'

489: ,ERROR_MSG
490: ,MSG_TOKENS)
491: VALUES (G_WORKER_REQ_ID
492: ,HEADER_INTERFACE_ROWID
493: ,'OKS_HEADERS_INTERFACE'
494: ,HEADER_INTERFACE_ID
495: ,'OKS_IMP_HDR_INVALID_RENPL'
496: ,NULL)
497: WHEN (CUSTOMER_PARTY_ID IS NULL) THEN

Line 507: ,'OKS_HEADERS_INTERFACE'

503: ,ERROR_MSG
504: ,MSG_TOKENS)
505: VALUES (G_WORKER_REQ_ID
506: ,HEADER_INTERFACE_ROWID
507: ,'OKS_HEADERS_INTERFACE'
508: ,HEADER_INTERFACE_ID
509: ,'OKS_IMP_HDR_INVALID_CTPARTY'
510: ,NULL)
511: WHEN (TP_PROVIDED = 'Y' AND THIRD_PARTY_ID IS NULL) THEN

Line 521: ,'OKS_HEADERS_INTERFACE'

517: ,ERROR_MSG
518: ,MSG_TOKENS)
519: VALUES (G_WORKER_REQ_ID
520: ,HEADER_INTERFACE_ROWID
521: ,'OKS_HEADERS_INTERFACE'
522: ,HEADER_INTERFACE_ID
523: ,'OKS_IMP_HDR_INVALID_TPPARTY'
524: ,NULL)
525: WHEN (CONTRACT_GROUP_ID IS NULL) THEN

Line 535: ,'OKS_HEADERS_INTERFACE'

531: ,ERROR_MSG
532: ,MSG_TOKENS)
533: VALUES (G_WORKER_REQ_ID
534: ,HEADER_INTERFACE_ROWID
535: ,'OKS_HEADERS_INTERFACE'
536: ,HEADER_INTERFACE_ID
537: ,'OKS_IMP_HDR_INVALID_CG'
538: ,NULL)
539: WHEN (AGREEMENT_PROVIDED = 'Y' AND AGREEMENT_ID IS NULL) THEN

Line 549: ,'OKS_HEADERS_INTERFACE'

545: ,ERROR_MSG
546: ,MSG_TOKENS)
547: VALUES (G_WORKER_REQ_ID
548: ,HEADER_INTERFACE_ROWID
549: ,'OKS_HEADERS_INTERFACE'
550: ,HEADER_INTERFACE_ID
551: ,'OKS_IMP_HDR_INVALID_PAGRMT'
552: ,NULL)
553: WHEN (SALESPERSON_PROVIDED = 'Y' AND SALESPERSON_ID IS NULL) THEN

Line 563: ,'OKS_HEADERS_INTERFACE'

559: ,ERROR_MSG
560: ,MSG_TOKENS)
561: VALUES (G_WORKER_REQ_ID
562: ,HEADER_INTERFACE_ROWID
563: ,'OKS_HEADERS_INTERFACE'
564: ,HEADER_INTERFACE_ID
565: ,'OKS_IMP_HDR_INVALID_SALEPERS'
566: ,NULL)
567: WHEN (CONTRACT_ADMIN_PROVIDED = 'Y' AND CUSTOMER_CONTRACT_ADMIN_ID IS NULL) THEN

Line 577: ,'OKS_HEADERS_INTERFACE'

573: ,ERROR_MSG
574: ,MSG_TOKENS)
575: VALUES (G_WORKER_REQ_ID
576: ,HEADER_INTERFACE_ROWID
577: ,'OKS_HEADERS_INTERFACE'
578: ,HEADER_INTERFACE_ID
579: ,'OKS_IMP_HDR_INVALID_CCADMIN'
580: ,NULL)
581: WHEN DESCRIPTION IS NULL THEN

Line 591: ,'OKS_HEADERS_INTERFACE'

587: ,ERROR_MSG
588: ,MSG_TOKENS)
589: VALUES (G_WORKER_REQ_ID
590: ,HEADER_INTERFACE_ROWID
591: ,'OKS_HEADERS_INTERFACE'
592: ,HEADER_INTERFACE_ID
593: ,'OKS_IMP_HDR_INVALID_DESC'
594: ,NULL)
595: WHEN FULLY_BILLED IS NULL THEN

Line 605: ,'OKS_HEADERS_INTERFACE'

601: ,ERROR_MSG
602: ,MSG_TOKENS)
603: VALUES (G_WORKER_REQ_ID
604: ,HEADER_INTERFACE_ROWID
605: ,'OKS_HEADERS_INTERFACE'
606: ,HEADER_INTERFACE_ID
607: ,'OKS_IMP_HDR_INVALID_FULB'
608: ,NULL)
609: WHEN FULLY_BILLED_INV ='Y' THEN

Line 619: ,'OKS_HEADERS_INTERFACE'

615: ,ERROR_MSG
616: ,MSG_TOKENS)
617: VALUES (G_WORKER_REQ_ID
618: ,HEADER_INTERFACE_ROWID
619: ,'OKS_HEADERS_INTERFACE'
620: ,HEADER_INTERFACE_ID
621: ,'OKS_IMP_HDR_INV_FULB_STS'
622: ,NULL)
623:

Line 792: FROM OKS_HEADERS_INTERFACE OHI

788: ,(CASE WHEN OHI.FULLY_BILLED ='Y' AND OHI.STATUS_CODE IN ('ENTERED','CANCELLED') THEN 'Y'
789: ELSE 'N' END) FULLY_BILLED_INV
790: ,OHI.SOURCE SOURCE
791: ,rtrim(OHI.DOCUMENT) DOCUMENT
792: FROM OKS_HEADERS_INTERFACE OHI
793: ,HR_ALL_ORGANIZATION_UNITS HOU
794: ,HR_ORGANIZATION_INFORMATION HOI
795: ,HZ_CUST_SITE_USES_ALL BTSUI
796: ,HZ_CUST_SITE_USES_ALL STSUI

Line 872: FROM OKS_HEADERS_INTERFACE HDI

868: ,GL.CURRENCY_CODE OU_LEDGER_CUR_CODE
869: ,HDI.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
870: ,trunc(HDI.CURRENCY_CONVERSION_DATE) CURRENCY_CONVERSION_DATE
871: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
872: FROM OKS_HEADERS_INTERFACE HDI
873: ,HZ_PARTIES HPCUSTI
874: ,HZ_PARTIES HPCUSTN
875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI

Line 985: SELECT count(1) INTO l_int_count FROM OKS_HEADERS_INTERFACE

981: AND OHI.batch_id = P_batch_id
982: AND (OHI.INTERFACE_STATUS IS NULL OR OHI.INTERFACE_STATUS = 'R');
983:
984: IF G_STMT_LOG THEN
985: SELECT count(1) INTO l_int_count FROM OKS_HEADERS_INTERFACE
986: WHERE ROWID between P_rowid_from AND P_rowid_to
987: AND batch_id = P_batch_id
988: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R');
989:

Line 1011: ,'OKS_HEADERS_INTERFACE'

1007: ,ERROR_MSG
1008: ,MSG_TOKENS)
1009: VALUES (G_WORKER_REQ_ID
1010: ,HEADER_INTERFACE_ROWID
1011: ,'OKS_HEADERS_INTERFACE'
1012: ,HEADER_INTERFACE_ID
1013: ,'OKS_IMP_HDR_INVALID_NUM'
1014: ,NULL)
1015: WHEN (NUMBER_COUNT_IN_HDR > 0) THEN

Line 1025: ,'OKS_HEADERS_INTERFACE'

1021: ,ERROR_MSG
1022: ,MSG_TOKENS)
1023: VALUES (G_WORKER_REQ_ID
1024: ,HEADER_INTERFACE_ROWID
1025: ,'OKS_HEADERS_INTERFACE'
1026: ,HEADER_INTERFACE_ID
1027: ,'OKS_IMP_HDR_NONUNIQ_NUM_HDR'
1028: ,NULL)
1029: WHEN (NUMBER_NOTUNIQ_IN_INT = 'Y') THEN

Line 1039: ,'OKS_HEADERS_INTERFACE'

1035: ,ERROR_MSG
1036: ,MSG_TOKENS)
1037: VALUES (G_WORKER_REQ_ID
1038: ,HEADER_INTERFACE_ROWID
1039: ,'OKS_HEADERS_INTERFACE'
1040: ,HEADER_INTERFACE_ID
1041: ,'OKS_IMP_HDR_NONUNIQ_NUM_INT'
1042: ,NULL)
1043: WHEN (CAT_COUNT <> 1) THEN

Line 1053: ,'OKS_HEADERS_INTERFACE'

1049: ,ERROR_MSG
1050: ,MSG_TOKENS)
1051: VALUES (G_WORKER_REQ_ID
1052: ,HEADER_INTERFACE_ROWID
1053: ,'OKS_HEADERS_INTERFACE'
1054: ,HEADER_INTERFACE_ID
1055: ,'OKS_IMP_HDR_INVALID_CAT'
1056: ,NULL)
1057: WHEN (DATE_VALID = 'N') THEN

Line 1067: ,'OKS_HEADERS_INTERFACE'

1063: ,ERROR_MSG
1064: ,MSG_TOKENS)
1065: VALUES (G_WORKER_REQ_ID
1066: ,HEADER_INTERFACE_ROWID
1067: ,'OKS_HEADERS_INTERFACE'
1068: ,HEADER_INTERFACE_ID
1069: ,'OKS_IMP_HDR_INVALID_DATE'
1070: ,NULL)
1071: WHEN (STATUS_VALID = 'N') THEN

Line 1081: ,'OKS_HEADERS_INTERFACE'

1077: ,ERROR_MSG
1078: ,MSG_TOKENS)
1079: VALUES (G_WORKER_REQ_ID
1080: ,HEADER_INTERFACE_ROWID
1081: ,'OKS_HEADERS_INTERFACE'
1082: ,HEADER_INTERFACE_ID
1083: ,'OKS_IMP_HDR_INVALID_STATUS'
1084: ,NULL)
1085: WHEN (STATUS_X_DATE_VALID = 'N') THEN

Line 1095: ,'OKS_HEADERS_INTERFACE'

1091: ,ERROR_MSG
1092: ,MSG_TOKENS)
1093: VALUES (G_WORKER_REQ_ID
1094: ,HEADER_INTERFACE_ROWID
1095: ,'OKS_HEADERS_INTERFACE'
1096: ,HEADER_INTERFACE_ID
1097: ,'OKS_IMP_HDR_STATUS_X_DATE'
1098: ,NULL)
1099: WHEN (DATE_APPROVED_VALID = 'N') THEN

Line 1109: ,'OKS_HEADERS_INTERFACE'

1105: ,ERROR_MSG
1106: ,MSG_TOKENS)
1107: VALUES (G_WORKER_REQ_ID
1108: ,HEADER_INTERFACE_ROWID
1109: ,'OKS_HEADERS_INTERFACE'
1110: ,HEADER_INTERFACE_ID
1111: ,'OKS_IMP_HDR_INVALID_DATE_APRV'
1112: ,NULL)
1113: WHEN (DATE_APPROVED_NULL_ERROR = 'Y') THEN

Line 1123: ,'OKS_HEADERS_INTERFACE'

1119: ,ERROR_MSG
1120: ,MSG_TOKENS)
1121: VALUES (G_WORKER_REQ_ID
1122: ,HEADER_INTERFACE_ROWID
1123: ,'OKS_HEADERS_INTERFACE'
1124: ,HEADER_INTERFACE_ID
1125: ,'OKS_IMP_HDR_NULL_DATE_APRV'
1126: ,NULL)
1127: WHEN (DATE_CANCELED_VALID = 'N') THEN

Line 1137: ,'OKS_HEADERS_INTERFACE'

1133: ,ERROR_MSG
1134: ,MSG_TOKENS)
1135: VALUES (G_WORKER_REQ_ID
1136: ,HEADER_INTERFACE_ROWID
1137: ,'OKS_HEADERS_INTERFACE'
1138: ,HEADER_INTERFACE_ID
1139: ,'OKS_IMP_HDR_INVALID_DATE_CANC'
1140: ,NULL)
1141: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN

Line 1151: ,'OKS_HEADERS_INTERFACE'

1147: ,ERROR_MSG
1148: ,MSG_TOKENS)
1149: VALUES (G_WORKER_REQ_ID
1150: ,HEADER_INTERFACE_ROWID
1151: ,'OKS_HEADERS_INTERFACE'
1152: ,HEADER_INTERFACE_ID
1153: ,'OKS_IMP_HDR_NULL_DATE_CANC'
1154: ,NULL)
1155: WHEN (CR_VALID = 'N') THEN

Line 1165: ,'OKS_HEADERS_INTERFACE'

1161: ,ERROR_MSG
1162: ,MSG_TOKENS)
1163: VALUES (G_WORKER_REQ_ID
1164: ,HEADER_INTERFACE_ROWID
1165: ,'OKS_HEADERS_INTERFACE'
1166: ,HEADER_INTERFACE_ID
1167: ,'OKS_IMP_HDR_INVALID_CANC_RSN'
1168: ,NULL)
1169: WHEN (CR_NULL_ERROR = 'Y') THEN

Line 1179: ,'OKS_HEADERS_INTERFACE'

1175: ,ERROR_MSG
1176: ,MSG_TOKENS)
1177: VALUES (G_WORKER_REQ_ID
1178: ,HEADER_INTERFACE_ROWID
1179: ,'OKS_HEADERS_INTERFACE'
1180: ,HEADER_INTERFACE_ID
1181: ,'OKS_IMP_HDR_NULL_CANC_RSN'
1182: ,NULL)
1183: WHEN (DATE_SIGNED_VALID = 'N') THEN

Line 1193: ,'OKS_HEADERS_INTERFACE'

1189: ,ERROR_MSG
1190: ,MSG_TOKENS)
1191: VALUES (G_WORKER_REQ_ID
1192: ,HEADER_INTERFACE_ROWID
1193: ,'OKS_HEADERS_INTERFACE'
1194: ,HEADER_INTERFACE_ID
1195: ,'OKS_IMP_HDR_INVALID_DATE_SGND'
1196: ,NULL)
1197: WHEN (DATE_SIGNED_NULL_ERROR = 'Y') THEN

Line 1207: ,'OKS_HEADERS_INTERFACE'

1203: ,ERROR_MSG
1204: ,MSG_TOKENS)
1205: VALUES (G_WORKER_REQ_ID
1206: ,HEADER_INTERFACE_ROWID
1207: ,'OKS_HEADERS_INTERFACE'
1208: ,HEADER_INTERFACE_ID
1209: ,'OKS_IMP_HDR_NULL_DATE_SGND'
1210: ,NULL)
1211: WHEN (RENP_VALID = 'N') THEN

Line 1221: ,'OKS_HEADERS_INTERFACE'

1217: ,ERROR_MSG
1218: ,MSG_TOKENS)
1219: VALUES (G_WORKER_REQ_ID
1220: ,HEADER_INTERFACE_ROWID
1221: ,'OKS_HEADERS_INTERFACE'
1222: ,HEADER_INTERFACE_ID
1223: ,'OKS_IMP_HDR_INVALID_REN_PROC'
1224: ,NULL)
1225: WHEN (RENUPTO_VALID = 'N') THEN

Line 1235: ,'OKS_HEADERS_INTERFACE'

1231: ,ERROR_MSG
1232: ,MSG_TOKENS)
1233: VALUES (G_WORKER_REQ_ID
1234: ,HEADER_INTERFACE_ROWID
1235: ,'OKS_HEADERS_INTERFACE'
1236: ,HEADER_INTERFACE_ID
1237: ,'OKS_IMP_HDR_INVALID_REN_UPTO'
1238: ,NULL)
1239: WHEN (RENUPTO_NULL_ERROR = 'Y') THEN

Line 1249: ,'OKS_HEADERS_INTERFACE'

1245: ,ERROR_MSG
1246: ,MSG_TOKENS)
1247: VALUES (G_WORKER_REQ_ID
1248: ,HEADER_INTERFACE_ROWID
1249: ,'OKS_HEADERS_INTERFACE'
1250: ,HEADER_INTERFACE_ID
1251: ,'OKS_IMP_HDR_NULL_REN_UPTO'
1252: ,NULL)
1253: WHEN (APRV_REQ_VALID = 'N') THEN

Line 1263: ,'OKS_HEADERS_INTERFACE'

1259: ,ERROR_MSG
1260: ,MSG_TOKENS)
1261: VALUES (G_WORKER_REQ_ID
1262: ,HEADER_INTERFACE_ROWID
1263: ,'OKS_HEADERS_INTERFACE'
1264: ,HEADER_INTERFACE_ID
1265: ,'OKS_IMP_HDR_INVALID_APRV_REQ'
1266: ,NULL)
1267: WHEN (APRV_REQ_NULL_ERROR = 'Y') THEN

Line 1277: ,'OKS_HEADERS_INTERFACE'

1273: ,ERROR_MSG
1274: ,MSG_TOKENS)
1275: VALUES (G_WORKER_REQ_ID
1276: ,HEADER_INTERFACE_ROWID
1277: ,'OKS_HEADERS_INTERFACE'
1278: ,HEADER_INTERFACE_ID
1279: ,'OKS_IMP_HDR_NULL_APRV_REQ'
1280: ,NULL)
1281: WHEN (PRM_VALID = 'N') THEN

Line 1291: ,'OKS_HEADERS_INTERFACE'

1287: ,ERROR_MSG
1288: ,MSG_TOKENS)
1289: VALUES (G_WORKER_REQ_ID
1290: ,HEADER_INTERFACE_ROWID
1291: ,'OKS_HEADERS_INTERFACE'
1292: ,HEADER_INTERFACE_ID
1293: ,'OKS_IMP_HDR_INVALID_PRC_METHOD'
1294: ,NULL)
1295: WHEN (PRM_NULL_ERROR = 'Y') THEN

Line 1305: ,'OKS_HEADERS_INTERFACE'

1301: ,ERROR_MSG
1302: ,MSG_TOKENS)
1303: VALUES (G_WORKER_REQ_ID
1304: ,HEADER_INTERFACE_ROWID
1305: ,'OKS_HEADERS_INTERFACE'
1306: ,HEADER_INTERFACE_ID
1307: ,'OKS_IMP_HDR_NULL_PRC_METHOD'
1308: ,NULL)
1309: WHEN (MKP_VALID = 'N') THEN

Line 1319: ,'OKS_HEADERS_INTERFACE'

1315: ,ERROR_MSG
1316: ,MSG_TOKENS)
1317: VALUES (G_WORKER_REQ_ID
1318: ,HEADER_INTERFACE_ROWID
1319: ,'OKS_HEADERS_INTERFACE'
1320: ,HEADER_INTERFACE_ID
1321: ,'OKS_IMP_HDR_INVALID_MARKUP'
1322: ,NULL)
1323: WHEN (MKP_NULL_ERROR = 'Y') THEN

Line 1333: ,'OKS_HEADERS_INTERFACE'

1329: ,ERROR_MSG
1330: ,MSG_TOKENS)
1331: VALUES (G_WORKER_REQ_ID
1332: ,HEADER_INTERFACE_ROWID
1333: ,'OKS_HEADERS_INTERFACE'
1334: ,HEADER_INTERFACE_ID
1335: ,'OKS_IMP_HDR_NULL_MARKUP'
1336: ,NULL)
1337: WHEN (BP_VALID = 'N') THEN

Line 1347: ,'OKS_HEADERS_INTERFACE'

1343: ,ERROR_MSG
1344: ,MSG_TOKENS)
1345: VALUES (G_WORKER_REQ_ID
1346: ,HEADER_INTERFACE_ROWID
1347: ,'OKS_HEADERS_INTERFACE'
1348: ,HEADER_INTERFACE_ID
1349: ,'OKS_IMP_HDR_INVALID_BILLPROF'
1350: ,NULL)
1351: WHEN (RENPOREQ_VALID = 'N') THEN

Line 1361: ,'OKS_HEADERS_INTERFACE'

1357: ,ERROR_MSG
1358: ,MSG_TOKENS)
1359: VALUES (G_WORKER_REQ_ID
1360: ,HEADER_INTERFACE_ROWID
1361: ,'OKS_HEADERS_INTERFACE'
1362: ,HEADER_INTERFACE_ID
1363: ,'OKS_IMP_HDR_INVALID_RENPO_REQ'
1364: ,NULL)
1365: WHEN (nvl(RENEWAL_GRACE_DURATION, 1) <= 0 OR floor(nvl(RENEWAL_GRACE_DURATION, 1)) <> nvl(RENEWAL_GRACE_DURATION, 1)) THEN

Line 1375: ,'OKS_HEADERS_INTERFACE'

1371: ,ERROR_MSG
1372: ,MSG_TOKENS)
1373: VALUES (G_WORKER_REQ_ID
1374: ,HEADER_INTERFACE_ROWID
1375: ,'OKS_HEADERS_INTERFACE'
1376: ,HEADER_INTERFACE_ID
1377: ,'OKS_IMP_HDR_INVALID_RENGR_DUR'
1378: ,NULL)
1379: WHEN (RENGRPER_VALID = 'N') THEN

Line 1389: ,'OKS_HEADERS_INTERFACE'

1385: ,ERROR_MSG
1386: ,MSG_TOKENS)
1387: VALUES (G_WORKER_REQ_ID
1388: ,HEADER_INTERFACE_ROWID
1389: ,'OKS_HEADERS_INTERFACE'
1390: ,HEADER_INTERFACE_ID
1391: ,'OKS_IMP_HDR_INVALID_RENGR_PER'
1392: ,NULL)
1393: WHEN (RENGRPER_NULL_ERROR = 'Y') THEN

Line 1403: ,'OKS_HEADERS_INTERFACE'

1399: ,ERROR_MSG
1400: ,MSG_TOKENS)
1401: VALUES (G_WORKER_REQ_ID
1402: ,HEADER_INTERFACE_ROWID
1403: ,'OKS_HEADERS_INTERFACE'
1404: ,HEADER_INTERFACE_ID
1405: ,'OKS_IMP_HDR_NULL_RENGR_PER'
1406: ,NULL)
1407: /* WHEN (nvl(RENEWAL_ESTIMATED_PERCENT, 1) < 0 OR nvl(RENEWAL_ESTIMATED_PERCENT, 1) > 100) THEN

Line 1417: ,'OKS_HEADERS_INTERFACE'

1413: ,ERROR_MSG
1414: ,MSG_TOKENS)
1415: VALUES (G_WORKER_REQ_ID
1416: ,HEADER_INTERFACE_ROWID
1417: ,'OKS_HEADERS_INTERFACE'
1418: ,HEADER_INTERFACE_ID
1419: ,'OKS_IMP_HDR_NULL_EST_PERC'
1420: ,NULL) */
1421: /* WHEN (nvl(RENEWAL_ESTIMATED_DURATION, 1) <= 0 ) THEN

Line 1431: ,'OKS_HEADERS_INTERFACE'

1427: ,ERROR_MSG
1428: ,MSG_TOKENS)
1429: VALUES (G_WORKER_REQ_ID
1430: ,HEADER_INTERFACE_ROWID
1431: ,'OKS_HEADERS_INTERFACE'
1432: ,HEADER_INTERFACE_ID
1433: ,'OKS_IMP_HDR_INVALID_EST_DUR'
1434: ,NULL) */
1435: WHEN (REN_EST_DURPER_VALID = 'N') THEN

Line 1445: ,'OKS_HEADERS_INTERFACE'

1441: ,ERROR_MSG
1442: ,MSG_TOKENS)
1443: VALUES (G_WORKER_REQ_ID
1444: ,HEADER_INTERFACE_ROWID
1445: ,'OKS_HEADERS_INTERFACE'
1446: ,HEADER_INTERFACE_ID
1447: ,'OKS_IMP_HDR_INVALID_DATE_EST'
1448: ,NULL)
1449: WHEN (REN_EST_DURPER_NULL_ERROR = 'Y') THEN

Line 1459: ,'OKS_HEADERS_INTERFACE'

1455: ,ERROR_MSG
1456: ,MSG_TOKENS)
1457: VALUES (G_WORKER_REQ_ID
1458: ,HEADER_INTERFACE_ROWID
1459: ,'OKS_HEADERS_INTERFACE'
1460: ,HEADER_INTERFACE_ID
1461: ,'OKS_IMP_HDR_NULL_REN_EST'
1462: ,NULL)
1463: SELECT HST.CONTRACT_NUMBER CONTRACT_NUMBER

Line 1467: ,(CASE WHEN EXISTS (SELECT 1 FROM OKS_HEADERS_INTERFACE

1463: SELECT HST.CONTRACT_NUMBER CONTRACT_NUMBER
1464: ,HST.HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID
1465: ,HST.HEADER_INTERFACE_ID HEADER_INTERFACE_ID
1466: ,COUNT(DISTINCT HDR.ROWID) OVER (PARTITION BY HST.ROWID) NUMBER_COUNT_IN_HDR
1467: ,(CASE WHEN EXISTS (SELECT 1 FROM OKS_HEADERS_INTERFACE
1468: WHERE HST.CONTRACT_NUMBER = CONTRACT_NUMBER
1469: AND nvl(HST.CONTRACT_NUMBER_MODIFIER, 'XgArBaGe!@#') = nvl(CONTRACT_NUMBER_MODIFIER (+), 'XgArBaGe!@#')
1470: AND HST.HEADER_INTERFACE_ID <> HEADER_INTERFACE_ID (+))
1471: THEN 'Y' ELSE 'N'

Line 1609: ,'OKS_HEADERS_INTERFACE'

1605: ,ERROR_MSG
1606: ,MSG_TOKENS)
1607: VALUES (G_WORKER_REQ_ID
1608: ,HEADER_INTERFACE_ROWID
1609: ,'OKS_HEADERS_INTERFACE'
1610: ,HEADER_INTERFACE_ID
1611: ,'OKS_IMP_HDR_INVALID_SALES_G'
1612: ,NULL)
1613: WHEN (QUOTE_TO_PARTY_SITE_V = 'N') THEN

Line 1623: ,'OKS_HEADERS_INTERFACE'

1619: ,ERROR_MSG
1620: ,MSG_TOKENS)
1621: VALUES (G_WORKER_REQ_ID
1622: ,HEADER_INTERFACE_ROWID
1623: ,'OKS_HEADERS_INTERFACE'
1624: ,HEADER_INTERFACE_ID
1625: ,'OKS_IMP_HDR_INVALID_QPS'
1626: ,NULL)
1627: WHEN (QUOTE_TO_CONTACT_V = 'N') THEN

Line 1637: ,'OKS_HEADERS_INTERFACE'

1633: ,ERROR_MSG
1634: ,MSG_TOKENS)
1635: VALUES (G_WORKER_REQ_ID
1636: ,HEADER_INTERFACE_ROWID
1637: ,'OKS_HEADERS_INTERFACE'
1638: ,HEADER_INTERFACE_ID
1639: ,'OKS_IMP_HDR_INVALID_QTC'
1640: ,NULL)
1641: WHEN (QUOTE_TO_PHONE_V = 'N') THEN

Line 1651: ,'OKS_HEADERS_INTERFACE'

1647: ,ERROR_MSG
1648: ,MSG_TOKENS)
1649: VALUES (G_WORKER_REQ_ID
1650: ,HEADER_INTERFACE_ROWID
1651: ,'OKS_HEADERS_INTERFACE'
1652: ,HEADER_INTERFACE_ID
1653: ,'OKS_IMP_HDR_INVALID_QTP'
1654: ,NULL)
1655: WHEN (QUOTE_TO_FAX_V = 'N') THEN

Line 1665: ,'OKS_HEADERS_INTERFACE'

1661: ,ERROR_MSG
1662: ,MSG_TOKENS)
1663: VALUES (G_WORKER_REQ_ID
1664: ,HEADER_INTERFACE_ROWID
1665: ,'OKS_HEADERS_INTERFACE'
1666: ,HEADER_INTERFACE_ID
1667: ,'OKS_IMP_HDR_INVALID_QTF'
1668: ,NULL)
1669: WHEN (QUOTE_TO_EMAIL_V = 'N') THEN

Line 1679: ,'OKS_HEADERS_INTERFACE'

1675: ,ERROR_MSG
1676: ,MSG_TOKENS)
1677: VALUES (G_WORKER_REQ_ID
1678: ,HEADER_INTERFACE_ROWID
1679: ,'OKS_HEADERS_INTERFACE'
1680: ,HEADER_INTERFACE_ID
1681: ,'OKS_IMP_HDR_INVALID_QTE'
1682: ,NULL)
1683: WHEN (nvl(GRACE_DURATION, 1) <= 0 OR floor(nvl(GRACE_DURATION, 1)) <> nvl(GRACE_DURATION, 1)) THEN

Line 1693: ,'OKS_HEADERS_INTERFACE'

1689: ,ERROR_MSG
1690: ,MSG_TOKENS)
1691: VALUES (G_WORKER_REQ_ID
1692: ,HEADER_INTERFACE_ROWID
1693: ,'OKS_HEADERS_INTERFACE'
1694: ,HEADER_INTERFACE_ID
1695: ,'OKS_IMP_HDR_INVALID_GRD'
1696: ,NULL)
1697: WHEN (GRPER_V = 'N') THEN

Line 1707: ,'OKS_HEADERS_INTERFACE'

1703: ,ERROR_MSG
1704: ,MSG_TOKENS)
1705: VALUES (G_WORKER_REQ_ID
1706: ,HEADER_INTERFACE_ROWID
1707: ,'OKS_HEADERS_INTERFACE'
1708: ,HEADER_INTERFACE_ID
1709: ,'OKS_IMP_HDR_INVALID_GRP'
1710: ,NULL)
1711: WHEN (GRPER_NULL_ERROR = 'Y') THEN

Line 1721: ,'OKS_HEADERS_INTERFACE'

1717: ,ERROR_MSG
1718: ,MSG_TOKENS)
1719: VALUES (G_WORKER_REQ_ID
1720: ,HEADER_INTERFACE_ROWID
1721: ,'OKS_HEADERS_INTERFACE'
1722: ,HEADER_INTERFACE_ID
1723: ,'OKS_IMP_HDR_NULL_GRP'
1724: ,NULL)
1725: /* WHEN (nvl(ESTIMATION_PERCENT, 1) < 0 OR nvl(ESTIMATION_PERCENT, 1) > 100) THEN

Line 1735: ,'OKS_HEADERS_INTERFACE'

1731: ,ERROR_MSG
1732: ,MSG_TOKENS)
1733: VALUES (G_WORKER_REQ_ID
1734: ,HEADER_INTERFACE_ROWID
1735: ,'OKS_HEADERS_INTERFACE'
1736: ,HEADER_INTERFACE_ID
1737: ,'OKS_IMP_HDR_INVALID_ESTPERC'
1738: ,NULL) */
1739: WHEN (ESTIMATION_PERCENT IS NOT NULL AND ESTIMATION_DATE IS NULL) THEN

Line 1749: ,'OKS_HEADERS_INTERFACE'

1745: ,ERROR_MSG
1746: ,MSG_TOKENS)
1747: VALUES (G_WORKER_REQ_ID
1748: ,HEADER_INTERFACE_ROWID
1749: ,'OKS_HEADERS_INTERFACE'
1750: ,HEADER_INTERFACE_ID
1751: ,'OKS_IMP_HDR_INVALID_ESTDATE'
1752: ,NULL)
1753: WHEN (EST_DATE_NULL_ERROR = 'Y') THEN

Line 1763: ,'OKS_HEADERS_INTERFACE'

1759: ,ERROR_MSG
1760: ,MSG_TOKENS)
1761: VALUES (G_WORKER_REQ_ID
1762: ,HEADER_INTERFACE_ROWID
1763: ,'OKS_HEADERS_INTERFACE'
1764: ,HEADER_INTERFACE_ID
1765: ,'OKS_IMP_HDR_NULL_ESTDATE'
1766: ,NULL)
1767: WHEN (FA_V = 'N') THEN

Line 1777: ,'OKS_HEADERS_INTERFACE'

1773: ,ERROR_MSG
1774: ,MSG_TOKENS)
1775: VALUES (G_WORKER_REQ_ID
1776: ,HEADER_INTERFACE_ROWID
1777: ,'OKS_HEADERS_INTERFACE'
1778: ,HEADER_INTERFACE_ID
1779: ,'OKS_IMP_HDR_INVALID_FA'
1780: ,NULL)
1781: WHEN (FA_NULL_ERROR = 'Y') THEN

Line 1791: ,'OKS_HEADERS_INTERFACE'

1787: ,ERROR_MSG
1788: ,MSG_TOKENS)
1789: VALUES (G_WORKER_REQ_ID
1790: ,HEADER_INTERFACE_ROWID
1791: ,'OKS_HEADERS_INTERFACE'
1792: ,HEADER_INTERFACE_ID
1793: ,'OKS_IMP_HDR_NULL_FA'
1794: ,NULL)
1795: WHEN (QAC_V = 'N') THEN

Line 1805: ,'OKS_HEADERS_INTERFACE'

1801: ,ERROR_MSG
1802: ,MSG_TOKENS)
1803: VALUES (G_WORKER_REQ_ID
1804: ,HEADER_INTERFACE_ROWID
1805: ,'OKS_HEADERS_INTERFACE'
1806: ,HEADER_INTERFACE_ID
1807: ,'OKS_IMP_HDR_INVALID_QAC'
1808: ,NULL)
1809: WHEN (AP_V = 'N') THEN

Line 1819: ,'OKS_HEADERS_INTERFACE'

1815: ,ERROR_MSG
1816: ,MSG_TOKENS)
1817: VALUES (G_WORKER_REQ_ID
1818: ,HEADER_INTERFACE_ROWID
1819: ,'OKS_HEADERS_INTERFACE'
1820: ,HEADER_INTERFACE_ID
1821: ,'OKS_IMP_HDR_INVALID_AP'
1822: ,NULL)
1823: WHEN (SALESGROUP_NULL_ERROR = 'Y') THEN

Line 1833: ,'OKS_HEADERS_INTERFACE'

1829: ,ERROR_MSG
1830: ,MSG_TOKENS)
1831: VALUES (G_WORKER_REQ_ID
1832: ,HEADER_INTERFACE_ROWID
1833: ,'OKS_HEADERS_INTERFACE'
1834: ,HEADER_INTERFACE_ID
1835: ,'OKS_IMP_HDR_NULL_SALESG'
1836: ,NULL)
1837: SELECT HST.HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID

Line 1928: ,'OKS_HEADERS_INTERFACE'

1924: ,ERROR_MSG
1925: ,MSG_TOKENS)
1926: VALUES (G_WORKER_REQ_ID
1927: ,HEADER_INTERFACE_ROWID
1928: ,'OKS_HEADERS_INTERFACE'
1929: ,HEADER_INTERFACE_ID
1930: ,'OKS_IMP_HDR_INVALID_TEC'
1931: ,NULL)
1932: WHEN (TUCEF_OU_V = 'N') THEN

Line 1942: ,'OKS_HEADERS_INTERFACE'

1938: ,ERROR_MSG
1939: ,MSG_TOKENS)
1940: VALUES (G_WORKER_REQ_ID
1941: ,HEADER_INTERFACE_ROWID
1942: ,'OKS_HEADERS_INTERFACE'
1943: ,HEADER_INTERFACE_ID
1944: ,'OKS_IMP_HDR_INVALID_TUCEF_OU'
1945: ,NULL)
1946: WHEN (TEN_V = 'N') THEN

Line 1956: ,'OKS_HEADERS_INTERFACE'

1952: ,ERROR_MSG
1953: ,MSG_TOKENS)
1954: VALUES (G_WORKER_REQ_ID
1955: ,HEADER_INTERFACE_ROWID
1956: ,'OKS_HEADERS_INTERFACE'
1957: ,HEADER_INTERFACE_ID
1958: ,'OKS_IMP_HDR_INVALID_TEN'
1959: ,NULL)
1960: WHEN (TEN_NULL_ERROR = 'Y') THEN

Line 1970: ,'OKS_HEADERS_INTERFACE'

1966: ,ERROR_MSG
1967: ,MSG_TOKENS)
1968: VALUES (G_WORKER_REQ_ID
1969: ,HEADER_INTERFACE_ROWID
1970: ,'OKS_HEADERS_INTERFACE'
1971: ,HEADER_INTERFACE_ID
1972: ,'OKS_IMP_HDR_NULL_TEN'
1973: ,NULL)
1974: WHEN (POREQ_V = 'N') THEN

Line 1984: ,'OKS_HEADERS_INTERFACE'

1980: ,ERROR_MSG
1981: ,MSG_TOKENS)
1982: VALUES (G_WORKER_REQ_ID
1983: ,HEADER_INTERFACE_ROWID
1984: ,'OKS_HEADERS_INTERFACE'
1985: ,HEADER_INTERFACE_ID
1986: ,'OKS_IMP_HDR_INVALID_POREQ'
1987: ,NULL)
1988: WHEN (POREQ_NULL_ERROR = 'Y') THEN

Line 1998: ,'OKS_HEADERS_INTERFACE'

1994: ,ERROR_MSG
1995: ,MSG_TOKENS)
1996: VALUES (G_WORKER_REQ_ID
1997: ,HEADER_INTERFACE_ROWID
1998: ,'OKS_HEADERS_INTERFACE'
1999: ,HEADER_INTERFACE_ID
2000: ,'OKS_IMP_HDR_NULL_POREQ'
2001: ,NULL)
2002: WHEN (BS_V = 'N') THEN

Line 2012: ,'OKS_HEADERS_INTERFACE'

2008: ,ERROR_MSG
2009: ,MSG_TOKENS)
2010: VALUES (G_WORKER_REQ_ID
2011: ,HEADER_INTERFACE_ROWID
2012: ,'OKS_HEADERS_INTERFACE'
2013: ,HEADER_INTERFACE_ID
2014: ,'OKS_IMP_HDR_INVALID_BS'
2015: ,NULL)
2016: WHEN (BTXNTYPE_V = 'N') THEN

Line 2026: ,'OKS_HEADERS_INTERFACE'

2022: ,ERROR_MSG
2023: ,MSG_TOKENS)
2024: VALUES (G_WORKER_REQ_ID
2025: ,HEADER_INTERFACE_ROWID
2026: ,'OKS_HEADERS_INTERFACE'
2027: ,HEADER_INTERFACE_ID
2028: ,'OKS_IMP_HDR_INVALID_BTXNTYPE'
2029: ,NULL)
2030: WHEN (HC_V = 'N') THEN

Line 2040: ,'OKS_HEADERS_INTERFACE'

2036: ,ERROR_MSG
2037: ,MSG_TOKENS)
2038: VALUES (G_WORKER_REQ_ID
2039: ,HEADER_INTERFACE_ROWID
2040: ,'OKS_HEADERS_INTERFACE'
2041: ,HEADER_INTERFACE_ID
2042: ,'OKS_IMP_HDR_INVALID_HC'
2043: ,NULL)
2044: WHEN (SP_V = 'N') THEN

Line 2054: ,'OKS_HEADERS_INTERFACE'

2050: ,ERROR_MSG
2051: ,MSG_TOKENS)
2052: VALUES (G_WORKER_REQ_ID
2053: ,HEADER_INTERFACE_ROWID
2054: ,'OKS_HEADERS_INTERFACE'
2055: ,HEADER_INTERFACE_ID
2056: ,'OKS_IMP_HDR_INVALID_SP'
2057: ,NULL)
2058: WHEN (ST_V = 'N') THEN

Line 2068: ,'OKS_HEADERS_INTERFACE'

2064: ,ERROR_MSG
2065: ,MSG_TOKENS)
2066: VALUES (G_WORKER_REQ_ID
2067: ,HEADER_INTERFACE_ROWID
2068: ,'OKS_HEADERS_INTERFACE'
2069: ,HEADER_INTERFACE_ID
2070: ,'OKS_IMP_HDR_INVALID_ST'
2071: ,NULL)
2072: WHEN (SER_CHRG_PREP_REQ_V = 'N') THEN

Line 2082: ,'OKS_HEADERS_INTERFACE'

2078: ,ERROR_MSG
2079: ,MSG_TOKENS)
2080: VALUES (G_WORKER_REQ_ID
2081: ,HEADER_INTERFACE_ROWID
2082: ,'OKS_HEADERS_INTERFACE'
2083: ,HEADER_INTERFACE_ID
2084: ,'OKS_IMP_HDR_INVALID_SCPREQ'
2085: ,NULL)
2086: WHEN (SER_CHRG_PO_REQ_V = 'N') THEN

Line 2096: ,'OKS_HEADERS_INTERFACE'

2092: ,ERROR_MSG
2093: ,MSG_TOKENS)
2094: VALUES (G_WORKER_REQ_ID
2095: ,HEADER_INTERFACE_ROWID
2096: ,'OKS_HEADERS_INTERFACE'
2097: ,HEADER_INTERFACE_ID
2098: ,'OKS_IMP_HDR_INVALID_SCPOREQ'
2099: ,NULL)
2100: WHEN (SOURCE_V = 'N') THEN

Line 2110: ,'OKS_HEADERS_INTERFACE'

2106: ,ERROR_MSG
2107: ,MSG_TOKENS)
2108: VALUES (G_WORKER_REQ_ID
2109: ,HEADER_INTERFACE_ROWID
2110: ,'OKS_HEADERS_INTERFACE'
2111: ,HEADER_INTERFACE_ID
2112: ,'OKS_IMP_HDR_INVALID_SOURCE'
2113: ,NULL)
2114: WHEN (HOI_COUNT = 0) THEN

Line 2124: ,'OKS_HEADERS_INTERFACE'

2120: ,ERROR_MSG
2121: ,MSG_TOKENS)
2122: VALUES (G_WORKER_REQ_ID
2123: ,HEADER_INTERFACE_ROWID
2124: ,'OKS_HEADERS_INTERFACE'
2125: ,HEADER_INTERFACE_ID
2126: ,'OKS_IMP_HST_INVALID_INVORG'
2127: ,NULL)
2128: WHEN (ERC_NULL_ERROR = 'Y') THEN

Line 2138: ,'OKS_HEADERS_INTERFACE'

2134: ,ERROR_MSG
2135: ,MSG_TOKENS)
2136: VALUES (G_WORKER_REQ_ID
2137: ,HEADER_INTERFACE_ROWID
2138: ,'OKS_HEADERS_INTERFACE'
2139: ,HEADER_INTERFACE_ID
2140: ,'OKS_IMP_HDR_NULL_ERC'
2141: ,NULL)
2142:

Line 5690: FROM OKS_HEADERS_INTERFACE

5686: l_stmt_num := 10;
5687: /* delete from errors table all the records related to the contracts which are going to be validated by this worker.*/
5688: DELETE FROM OKS_IMP_ERRORS
5689: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID
5690: FROM OKS_HEADERS_INTERFACE
5691: WHERE rowid between P_rowid_from and P_rowid_to
5692: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R'));
5693: l_stmt_num := 20;
5694: Validate_header (P_batch_id,