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 258: ,'OKS_HEADERS_INTERFACE'

254: ,ERROR_MSG
255: ,MSG_TOKENS)
256: VALUES (G_WORKER_REQ_ID
257: ,HEADER_INTERFACE_ROWID
258: ,'OKS_HEADERS_INTERFACE'
259: ,HEADER_INTERFACE_ID
260: ,'OKS_IMP_HDR_INVALID_OU'
261: ,NULL)
262: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN

Line 272: ,'OKS_HEADERS_INTERFACE'

268: ,ERROR_MSG
269: ,MSG_TOKENS)
270: VALUES (G_WORKER_REQ_ID
271: ,HEADER_INTERFACE_ROWID
272: ,'OKS_HEADERS_INTERFACE'
273: ,HEADER_INTERFACE_ID
274: ,'OKS_IMP_HDR_INVALID_BTSU'
275: ,NULL)
276: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN

Line 286: ,'OKS_HEADERS_INTERFACE'

282: ,ERROR_MSG
283: ,MSG_TOKENS)
284: VALUES (G_WORKER_REQ_ID
285: ,HEADER_INTERFACE_ROWID
286: ,'OKS_HEADERS_INTERFACE'
287: ,HEADER_INTERFACE_ID
288: ,'OKS_IMP_HDR_INVALID_STSU'
289: ,NULL)
290: WHEN (CONTRACT_CURRENCY_CODE IS NULL) THEN

Line 300: ,'OKS_HEADERS_INTERFACE'

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

Line 316: ,'OKS_HEADERS_INTERFACE'

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

Line 333: ,'OKS_HEADERS_INTERFACE'

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

Line 349: ,'OKS_HEADERS_INTERFACE'

345: ,ERROR_MSG
346: ,MSG_TOKENS)
347: VALUES (G_WORKER_REQ_ID
348: ,HEADER_INTERFACE_ROWID
349: ,'OKS_HEADERS_INTERFACE'
350: ,HEADER_INTERFACE_ID
351: ,'OKS_IMP_HDR_INVALID_CONV_DATE'
352: ,NULL)
353: 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_RATE'
369: ,NULL)
370: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL

Line 384: ,'OKS_HEADERS_INTERFACE'

380: ,ERROR_MSG
381: ,MSG_TOKENS)
382: VALUES (G_WORKER_REQ_ID
383: ,HEADER_INTERFACE_ROWID
384: ,'OKS_HEADERS_INTERFACE'
385: ,HEADER_INTERFACE_ID
386: ,'OKS_IMP_HDR_NULL_CONV'
387: ,NULL)
388: WHEN (PRICE_LIST_ID IS NULL) THEN

Line 398: ,'OKS_HEADERS_INTERFACE'

394: ,ERROR_MSG
395: ,MSG_TOKENS)
396: VALUES (G_WORKER_REQ_ID
397: ,HEADER_INTERFACE_ROWID
398: ,'OKS_HEADERS_INTERFACE'
399: ,HEADER_INTERFACE_ID
400: ,'OKS_IMP_HDR_INVALID_PRICELIST'
401: ,NULL)
402: WHEN (PAYMENT_TERMS_ID IS NULL) THEN

Line 412: ,'OKS_HEADERS_INTERFACE'

408: ,ERROR_MSG
409: ,MSG_TOKENS)
410: VALUES (G_WORKER_REQ_ID
411: ,HEADER_INTERFACE_ROWID
412: ,'OKS_HEADERS_INTERFACE'
413: ,HEADER_INTERFACE_ID
414: ,'OKS_IMP_HDR_INVALID_PAYTERM'
415: ,NULL)
416: WHEN (HDR_PAYMENT_INSTRUCTION IS NOT NULL AND PAYMENT_INSTRUCTION IS NULL) THEN

Line 426: ,'OKS_HEADERS_INTERFACE'

422: ,ERROR_MSG
423: ,MSG_TOKENS)
424: VALUES (G_WORKER_REQ_ID
425: ,HEADER_INTERFACE_ROWID
426: ,'OKS_HEADERS_INTERFACE'
427: ,HEADER_INTERFACE_ID
428: ,'OKS_IMP_HDR_INVALID_PAYINSTR'
429: ,NULL)
430: WHEN (INVOICING_RULE_ID IS NULL) THEN

Line 440: ,'OKS_HEADERS_INTERFACE'

436: ,ERROR_MSG
437: ,MSG_TOKENS)
438: VALUES (G_WORKER_REQ_ID
439: ,HEADER_INTERFACE_ROWID
440: ,'OKS_HEADERS_INTERFACE'
441: ,HEADER_INTERFACE_ID
442: ,'OKS_IMP_HDR_INVALID_INVRULE'
443: ,NULL)
444: WHEN (HDR_PAYMENT_METHOD_CODE IS NOT NULL AND PAYMENT_METHOD_CODE IS NULL) THEN

Line 454: ,'OKS_HEADERS_INTERFACE'

450: ,ERROR_MSG
451: ,MSG_TOKENS)
452: VALUES (G_WORKER_REQ_ID
453: ,HEADER_INTERFACE_ROWID
454: ,'OKS_HEADERS_INTERFACE'
455: ,HEADER_INTERFACE_ID
456: ,'OKS_IMP_HDR_INVALID_PMC'
457: ,NULL)
458: WHEN ((PAYMENT_METHOD_CODE IS NOT NULL OR HDR_COMMITMENT_ID IS NOT NULL) AND COMMITMENT_ID IS NULL) THEN

Line 468: ,'OKS_HEADERS_INTERFACE'

464: ,ERROR_MSG
465: ,MSG_TOKENS)
466: VALUES (G_WORKER_REQ_ID
467: ,HEADER_INTERFACE_ROWID
468: ,'OKS_HEADERS_INTERFACE'
469: ,HEADER_INTERFACE_ID
470: ,'OKS_IMP_HDR_INVALID_COMMIT'
471: ,NULL)
472: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN

Line 482: ,'OKS_HEADERS_INTERFACE'

478: ,ERROR_MSG
479: ,MSG_TOKENS)
480: VALUES (G_WORKER_REQ_ID
481: ,HEADER_INTERFACE_ROWID
482: ,'OKS_HEADERS_INTERFACE'
483: ,HEADER_INTERFACE_ID
484: ,'OKS_IMP_HDR_INVALID_ACCRULE'
485: ,NULL)
486: WHEN (PRICING_METHOD = 'LST' AND RENEWAL_PRICE_LIST_ID IS NULL)

Line 497: ,'OKS_HEADERS_INTERFACE'

493: ,ERROR_MSG
494: ,MSG_TOKENS)
495: VALUES (G_WORKER_REQ_ID
496: ,HEADER_INTERFACE_ROWID
497: ,'OKS_HEADERS_INTERFACE'
498: ,HEADER_INTERFACE_ID
499: ,'OKS_IMP_HDR_RENPL_MANDATORY'
500: ,NULL)
501: WHEN (REN_PL_PROVIDED = 'Y' AND RENEWAL_PRICE_LIST_ID IS NULL) THEN

Line 511: ,'OKS_HEADERS_INTERFACE'

507: ,ERROR_MSG
508: ,MSG_TOKENS)
509: VALUES (G_WORKER_REQ_ID
510: ,HEADER_INTERFACE_ROWID
511: ,'OKS_HEADERS_INTERFACE'
512: ,HEADER_INTERFACE_ID
513: ,'OKS_IMP_HDR_INVALID_RENPL'
514: ,NULL)
515: WHEN (CUSTOMER_PARTY_ID IS NULL) THEN

Line 525: ,'OKS_HEADERS_INTERFACE'

521: ,ERROR_MSG
522: ,MSG_TOKENS)
523: VALUES (G_WORKER_REQ_ID
524: ,HEADER_INTERFACE_ROWID
525: ,'OKS_HEADERS_INTERFACE'
526: ,HEADER_INTERFACE_ID
527: ,'OKS_IMP_HDR_INVALID_CTPARTY'
528: ,NULL)
529: WHEN (TP_PROVIDED = 'Y' AND THIRD_PARTY_ID IS NULL) THEN

Line 539: ,'OKS_HEADERS_INTERFACE'

535: ,ERROR_MSG
536: ,MSG_TOKENS)
537: VALUES (G_WORKER_REQ_ID
538: ,HEADER_INTERFACE_ROWID
539: ,'OKS_HEADERS_INTERFACE'
540: ,HEADER_INTERFACE_ID
541: ,'OKS_IMP_HDR_INVALID_TPPARTY'
542: ,NULL)
543: WHEN (CONTRACT_GROUP_ID IS NULL) THEN

Line 553: ,'OKS_HEADERS_INTERFACE'

549: ,ERROR_MSG
550: ,MSG_TOKENS)
551: VALUES (G_WORKER_REQ_ID
552: ,HEADER_INTERFACE_ROWID
553: ,'OKS_HEADERS_INTERFACE'
554: ,HEADER_INTERFACE_ID
555: ,'OKS_IMP_HDR_INVALID_CG'
556: ,NULL)
557: WHEN (AGREEMENT_PROVIDED = 'Y' AND AGREEMENT_ID IS NULL) THEN

Line 567: ,'OKS_HEADERS_INTERFACE'

563: ,ERROR_MSG
564: ,MSG_TOKENS)
565: VALUES (G_WORKER_REQ_ID
566: ,HEADER_INTERFACE_ROWID
567: ,'OKS_HEADERS_INTERFACE'
568: ,HEADER_INTERFACE_ID
569: ,'OKS_IMP_HDR_INVALID_PAGRMT'
570: ,NULL)
571: WHEN (SALESPERSON_PROVIDED = 'Y' AND SALESPERSON_ID IS NULL) THEN

Line 581: ,'OKS_HEADERS_INTERFACE'

577: ,ERROR_MSG
578: ,MSG_TOKENS)
579: VALUES (G_WORKER_REQ_ID
580: ,HEADER_INTERFACE_ROWID
581: ,'OKS_HEADERS_INTERFACE'
582: ,HEADER_INTERFACE_ID
583: ,'OKS_IMP_HDR_INVALID_SALEPERS'
584: ,NULL)
585: WHEN (CONTRACT_ADMIN_PROVIDED = 'Y' AND CUSTOMER_CONTRACT_ADMIN_ID IS NULL) THEN

Line 595: ,'OKS_HEADERS_INTERFACE'

591: ,ERROR_MSG
592: ,MSG_TOKENS)
593: VALUES (G_WORKER_REQ_ID
594: ,HEADER_INTERFACE_ROWID
595: ,'OKS_HEADERS_INTERFACE'
596: ,HEADER_INTERFACE_ID
597: ,'OKS_IMP_HDR_INVALID_CCADMIN'
598: ,NULL)
599: WHEN DESCRIPTION IS NULL THEN

Line 609: ,'OKS_HEADERS_INTERFACE'

605: ,ERROR_MSG
606: ,MSG_TOKENS)
607: VALUES (G_WORKER_REQ_ID
608: ,HEADER_INTERFACE_ROWID
609: ,'OKS_HEADERS_INTERFACE'
610: ,HEADER_INTERFACE_ID
611: ,'OKS_IMP_HDR_INVALID_DESC'
612: ,NULL)
613: WHEN FULLY_BILLED IS NULL THEN

Line 623: ,'OKS_HEADERS_INTERFACE'

619: ,ERROR_MSG
620: ,MSG_TOKENS)
621: VALUES (G_WORKER_REQ_ID
622: ,HEADER_INTERFACE_ROWID
623: ,'OKS_HEADERS_INTERFACE'
624: ,HEADER_INTERFACE_ID
625: ,'OKS_IMP_HDR_INVALID_FULB'
626: ,NULL)
627: WHEN FULLY_BILLED_INV ='Y' THEN

Line 637: ,'OKS_HEADERS_INTERFACE'

633: ,ERROR_MSG
634: ,MSG_TOKENS)
635: VALUES (G_WORKER_REQ_ID
636: ,HEADER_INTERFACE_ROWID
637: ,'OKS_HEADERS_INTERFACE'
638: ,HEADER_INTERFACE_ID
639: ,'OKS_IMP_HDR_INV_FULB_STS'
640: ,NULL)
641:

Line 810: FROM OKS_HEADERS_INTERFACE OHI

806: ,(CASE WHEN OHI.FULLY_BILLED ='Y' AND OHI.STATUS_CODE IN ('ENTERED','CANCELLED') THEN 'Y'
807: ELSE 'N' END) FULLY_BILLED_INV
808: ,OHI.SOURCE SOURCE
809: ,rtrim(OHI.DOCUMENT) DOCUMENT
810: FROM OKS_HEADERS_INTERFACE OHI
811: ,HR_ALL_ORGANIZATION_UNITS HOU
812: ,HR_ORGANIZATION_INFORMATION HOI
813: ,HZ_CUST_SITE_USES_ALL BTSUI
814: ,HZ_CUST_SITE_USES_ALL STSUI

Line 902: FROM OKS_HEADERS_INTERFACE HDI

898: ,GL.CURRENCY_CODE OU_LEDGER_CUR_CODE
899: ,HDI.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
900: ,trunc(HDI.CURRENCY_CONVERSION_DATE) CURRENCY_CONVERSION_DATE
901: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
902: FROM OKS_HEADERS_INTERFACE HDI
903: ,HZ_PARTIES HPCUSTI
904: ,HZ_PARTIES HPCUSTN
905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI

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

1011: AND OHI.batch_id = P_batch_id
1012: AND (OHI.INTERFACE_STATUS IS NULL OR OHI.INTERFACE_STATUS = 'R');
1013:
1014: IF G_STMT_LOG THEN
1015: SELECT count(1) INTO l_int_count FROM OKS_HEADERS_INTERFACE
1016: WHERE ROWID between P_rowid_from AND P_rowid_to
1017: AND batch_id = P_batch_id
1018: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R');
1019:

Line 1041: ,'OKS_HEADERS_INTERFACE'

1037: ,ERROR_MSG
1038: ,MSG_TOKENS)
1039: VALUES (G_WORKER_REQ_ID
1040: ,HEADER_INTERFACE_ROWID
1041: ,'OKS_HEADERS_INTERFACE'
1042: ,HEADER_INTERFACE_ID
1043: ,'OKS_IMP_HDR_INVALID_NUM'
1044: ,NULL)
1045: WHEN (NUMBER_COUNT_IN_HDR > 0) THEN

Line 1055: ,'OKS_HEADERS_INTERFACE'

1051: ,ERROR_MSG
1052: ,MSG_TOKENS)
1053: VALUES (G_WORKER_REQ_ID
1054: ,HEADER_INTERFACE_ROWID
1055: ,'OKS_HEADERS_INTERFACE'
1056: ,HEADER_INTERFACE_ID
1057: ,'OKS_IMP_HDR_NONUNIQ_NUM_HDR'
1058: ,NULL)
1059: WHEN (NUMBER_NOTUNIQ_IN_INT = 'Y') THEN

Line 1069: ,'OKS_HEADERS_INTERFACE'

1065: ,ERROR_MSG
1066: ,MSG_TOKENS)
1067: VALUES (G_WORKER_REQ_ID
1068: ,HEADER_INTERFACE_ROWID
1069: ,'OKS_HEADERS_INTERFACE'
1070: ,HEADER_INTERFACE_ID
1071: ,'OKS_IMP_HDR_NONUNIQ_NUM_INT'
1072: ,NULL)
1073: WHEN (CAT_COUNT <> 1) THEN

Line 1083: ,'OKS_HEADERS_INTERFACE'

1079: ,ERROR_MSG
1080: ,MSG_TOKENS)
1081: VALUES (G_WORKER_REQ_ID
1082: ,HEADER_INTERFACE_ROWID
1083: ,'OKS_HEADERS_INTERFACE'
1084: ,HEADER_INTERFACE_ID
1085: ,'OKS_IMP_HDR_INVALID_CAT'
1086: ,NULL)
1087: WHEN (DATE_VALID = 'N') THEN

Line 1097: ,'OKS_HEADERS_INTERFACE'

1093: ,ERROR_MSG
1094: ,MSG_TOKENS)
1095: VALUES (G_WORKER_REQ_ID
1096: ,HEADER_INTERFACE_ROWID
1097: ,'OKS_HEADERS_INTERFACE'
1098: ,HEADER_INTERFACE_ID
1099: ,'OKS_IMP_HDR_INVALID_DATE'
1100: ,NULL)
1101: WHEN (STATUS_VALID = 'N') THEN

Line 1111: ,'OKS_HEADERS_INTERFACE'

1107: ,ERROR_MSG
1108: ,MSG_TOKENS)
1109: VALUES (G_WORKER_REQ_ID
1110: ,HEADER_INTERFACE_ROWID
1111: ,'OKS_HEADERS_INTERFACE'
1112: ,HEADER_INTERFACE_ID
1113: ,'OKS_IMP_HDR_INVALID_STATUS'
1114: ,NULL)
1115: WHEN (STATUS_X_DATE_VALID = 'N') THEN

Line 1125: ,'OKS_HEADERS_INTERFACE'

1121: ,ERROR_MSG
1122: ,MSG_TOKENS)
1123: VALUES (G_WORKER_REQ_ID
1124: ,HEADER_INTERFACE_ROWID
1125: ,'OKS_HEADERS_INTERFACE'
1126: ,HEADER_INTERFACE_ID
1127: ,'OKS_IMP_HDR_STATUS_X_DATE'
1128: ,NULL)
1129: WHEN (DATE_APPROVED_VALID = 'N') THEN

Line 1139: ,'OKS_HEADERS_INTERFACE'

1135: ,ERROR_MSG
1136: ,MSG_TOKENS)
1137: VALUES (G_WORKER_REQ_ID
1138: ,HEADER_INTERFACE_ROWID
1139: ,'OKS_HEADERS_INTERFACE'
1140: ,HEADER_INTERFACE_ID
1141: ,'OKS_IMP_HDR_INVALID_DATE_APRV'
1142: ,NULL)
1143: WHEN (DATE_APPROVED_NULL_ERROR = 'Y') THEN

Line 1153: ,'OKS_HEADERS_INTERFACE'

1149: ,ERROR_MSG
1150: ,MSG_TOKENS)
1151: VALUES (G_WORKER_REQ_ID
1152: ,HEADER_INTERFACE_ROWID
1153: ,'OKS_HEADERS_INTERFACE'
1154: ,HEADER_INTERFACE_ID
1155: ,'OKS_IMP_HDR_NULL_DATE_APRV'
1156: ,NULL)
1157: WHEN (DATE_CANCELED_VALID = 'N') THEN

Line 1167: ,'OKS_HEADERS_INTERFACE'

1163: ,ERROR_MSG
1164: ,MSG_TOKENS)
1165: VALUES (G_WORKER_REQ_ID
1166: ,HEADER_INTERFACE_ROWID
1167: ,'OKS_HEADERS_INTERFACE'
1168: ,HEADER_INTERFACE_ID
1169: ,'OKS_IMP_HDR_INVALID_DATE_CANC'
1170: ,NULL)
1171: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN

Line 1181: ,'OKS_HEADERS_INTERFACE'

1177: ,ERROR_MSG
1178: ,MSG_TOKENS)
1179: VALUES (G_WORKER_REQ_ID
1180: ,HEADER_INTERFACE_ROWID
1181: ,'OKS_HEADERS_INTERFACE'
1182: ,HEADER_INTERFACE_ID
1183: ,'OKS_IMP_HDR_NULL_DATE_CANC'
1184: ,NULL)
1185: WHEN (CR_VALID = 'N') THEN

Line 1195: ,'OKS_HEADERS_INTERFACE'

1191: ,ERROR_MSG
1192: ,MSG_TOKENS)
1193: VALUES (G_WORKER_REQ_ID
1194: ,HEADER_INTERFACE_ROWID
1195: ,'OKS_HEADERS_INTERFACE'
1196: ,HEADER_INTERFACE_ID
1197: ,'OKS_IMP_HDR_INVALID_CANC_RSN'
1198: ,NULL)
1199: WHEN (CR_NULL_ERROR = 'Y') THEN

Line 1209: ,'OKS_HEADERS_INTERFACE'

1205: ,ERROR_MSG
1206: ,MSG_TOKENS)
1207: VALUES (G_WORKER_REQ_ID
1208: ,HEADER_INTERFACE_ROWID
1209: ,'OKS_HEADERS_INTERFACE'
1210: ,HEADER_INTERFACE_ID
1211: ,'OKS_IMP_HDR_NULL_CANC_RSN'
1212: ,NULL)
1213: WHEN (DATE_SIGNED_VALID = 'N') THEN

Line 1223: ,'OKS_HEADERS_INTERFACE'

1219: ,ERROR_MSG
1220: ,MSG_TOKENS)
1221: VALUES (G_WORKER_REQ_ID
1222: ,HEADER_INTERFACE_ROWID
1223: ,'OKS_HEADERS_INTERFACE'
1224: ,HEADER_INTERFACE_ID
1225: ,'OKS_IMP_HDR_INVALID_DATE_SGND'
1226: ,NULL)
1227: WHEN (DATE_SIGNED_NULL_ERROR = 'Y') THEN

Line 1237: ,'OKS_HEADERS_INTERFACE'

1233: ,ERROR_MSG
1234: ,MSG_TOKENS)
1235: VALUES (G_WORKER_REQ_ID
1236: ,HEADER_INTERFACE_ROWID
1237: ,'OKS_HEADERS_INTERFACE'
1238: ,HEADER_INTERFACE_ID
1239: ,'OKS_IMP_HDR_NULL_DATE_SGND'
1240: ,NULL)
1241: WHEN (RENP_VALID = 'N') THEN

Line 1251: ,'OKS_HEADERS_INTERFACE'

1247: ,ERROR_MSG
1248: ,MSG_TOKENS)
1249: VALUES (G_WORKER_REQ_ID
1250: ,HEADER_INTERFACE_ROWID
1251: ,'OKS_HEADERS_INTERFACE'
1252: ,HEADER_INTERFACE_ID
1253: ,'OKS_IMP_HDR_INVALID_REN_PROC'
1254: ,NULL)
1255: WHEN (RENUPTO_VALID = 'N') THEN

Line 1265: ,'OKS_HEADERS_INTERFACE'

1261: ,ERROR_MSG
1262: ,MSG_TOKENS)
1263: VALUES (G_WORKER_REQ_ID
1264: ,HEADER_INTERFACE_ROWID
1265: ,'OKS_HEADERS_INTERFACE'
1266: ,HEADER_INTERFACE_ID
1267: ,'OKS_IMP_HDR_INVALID_REN_UPTO'
1268: ,NULL)
1269: WHEN (RENUPTO_NULL_ERROR = 'Y') THEN

Line 1279: ,'OKS_HEADERS_INTERFACE'

1275: ,ERROR_MSG
1276: ,MSG_TOKENS)
1277: VALUES (G_WORKER_REQ_ID
1278: ,HEADER_INTERFACE_ROWID
1279: ,'OKS_HEADERS_INTERFACE'
1280: ,HEADER_INTERFACE_ID
1281: ,'OKS_IMP_HDR_NULL_REN_UPTO'
1282: ,NULL)
1283: WHEN (APRV_REQ_VALID = 'N') THEN

Line 1293: ,'OKS_HEADERS_INTERFACE'

1289: ,ERROR_MSG
1290: ,MSG_TOKENS)
1291: VALUES (G_WORKER_REQ_ID
1292: ,HEADER_INTERFACE_ROWID
1293: ,'OKS_HEADERS_INTERFACE'
1294: ,HEADER_INTERFACE_ID
1295: ,'OKS_IMP_HDR_INVALID_APRV_REQ'
1296: ,NULL)
1297: WHEN (APRV_REQ_NULL_ERROR = 'Y') THEN

Line 1307: ,'OKS_HEADERS_INTERFACE'

1303: ,ERROR_MSG
1304: ,MSG_TOKENS)
1305: VALUES (G_WORKER_REQ_ID
1306: ,HEADER_INTERFACE_ROWID
1307: ,'OKS_HEADERS_INTERFACE'
1308: ,HEADER_INTERFACE_ID
1309: ,'OKS_IMP_HDR_NULL_APRV_REQ'
1310: ,NULL)
1311: WHEN (PRM_VALID = 'N') THEN

Line 1321: ,'OKS_HEADERS_INTERFACE'

1317: ,ERROR_MSG
1318: ,MSG_TOKENS)
1319: VALUES (G_WORKER_REQ_ID
1320: ,HEADER_INTERFACE_ROWID
1321: ,'OKS_HEADERS_INTERFACE'
1322: ,HEADER_INTERFACE_ID
1323: ,'OKS_IMP_HDR_INVALID_PRC_METHOD'
1324: ,NULL)
1325: WHEN (PRM_NULL_ERROR = 'Y') THEN

Line 1335: ,'OKS_HEADERS_INTERFACE'

1331: ,ERROR_MSG
1332: ,MSG_TOKENS)
1333: VALUES (G_WORKER_REQ_ID
1334: ,HEADER_INTERFACE_ROWID
1335: ,'OKS_HEADERS_INTERFACE'
1336: ,HEADER_INTERFACE_ID
1337: ,'OKS_IMP_HDR_NULL_PRC_METHOD'
1338: ,NULL)
1339: WHEN (MKP_VALID = 'N') THEN

Line 1349: ,'OKS_HEADERS_INTERFACE'

1345: ,ERROR_MSG
1346: ,MSG_TOKENS)
1347: VALUES (G_WORKER_REQ_ID
1348: ,HEADER_INTERFACE_ROWID
1349: ,'OKS_HEADERS_INTERFACE'
1350: ,HEADER_INTERFACE_ID
1351: ,'OKS_IMP_HDR_INVALID_MARKUP'
1352: ,NULL)
1353: WHEN (MKP_NULL_ERROR = 'Y') THEN

Line 1363: ,'OKS_HEADERS_INTERFACE'

1359: ,ERROR_MSG
1360: ,MSG_TOKENS)
1361: VALUES (G_WORKER_REQ_ID
1362: ,HEADER_INTERFACE_ROWID
1363: ,'OKS_HEADERS_INTERFACE'
1364: ,HEADER_INTERFACE_ID
1365: ,'OKS_IMP_HDR_NULL_MARKUP'
1366: ,NULL)
1367: WHEN (BP_VALID = 'N') THEN

Line 1377: ,'OKS_HEADERS_INTERFACE'

1373: ,ERROR_MSG
1374: ,MSG_TOKENS)
1375: VALUES (G_WORKER_REQ_ID
1376: ,HEADER_INTERFACE_ROWID
1377: ,'OKS_HEADERS_INTERFACE'
1378: ,HEADER_INTERFACE_ID
1379: ,'OKS_IMP_HDR_INVALID_BILLPROF'
1380: ,NULL)
1381: WHEN (RENPOREQ_VALID = 'N') THEN

Line 1391: ,'OKS_HEADERS_INTERFACE'

1387: ,ERROR_MSG
1388: ,MSG_TOKENS)
1389: VALUES (G_WORKER_REQ_ID
1390: ,HEADER_INTERFACE_ROWID
1391: ,'OKS_HEADERS_INTERFACE'
1392: ,HEADER_INTERFACE_ID
1393: ,'OKS_IMP_HDR_INVALID_RENPO_REQ'
1394: ,NULL)
1395: WHEN (nvl(RENEWAL_GRACE_DURATION, 1) <= 0 OR floor(nvl(RENEWAL_GRACE_DURATION, 1)) <> nvl(RENEWAL_GRACE_DURATION, 1)) THEN

Line 1405: ,'OKS_HEADERS_INTERFACE'

1401: ,ERROR_MSG
1402: ,MSG_TOKENS)
1403: VALUES (G_WORKER_REQ_ID
1404: ,HEADER_INTERFACE_ROWID
1405: ,'OKS_HEADERS_INTERFACE'
1406: ,HEADER_INTERFACE_ID
1407: ,'OKS_IMP_HDR_INVALID_RENGR_DUR'
1408: ,NULL)
1409: WHEN (RENGRPER_VALID = 'N') THEN

Line 1419: ,'OKS_HEADERS_INTERFACE'

1415: ,ERROR_MSG
1416: ,MSG_TOKENS)
1417: VALUES (G_WORKER_REQ_ID
1418: ,HEADER_INTERFACE_ROWID
1419: ,'OKS_HEADERS_INTERFACE'
1420: ,HEADER_INTERFACE_ID
1421: ,'OKS_IMP_HDR_INVALID_RENGR_PER'
1422: ,NULL)
1423: WHEN (RENGRPER_NULL_ERROR = 'Y') THEN

Line 1433: ,'OKS_HEADERS_INTERFACE'

1429: ,ERROR_MSG
1430: ,MSG_TOKENS)
1431: VALUES (G_WORKER_REQ_ID
1432: ,HEADER_INTERFACE_ROWID
1433: ,'OKS_HEADERS_INTERFACE'
1434: ,HEADER_INTERFACE_ID
1435: ,'OKS_IMP_HDR_NULL_RENGR_PER'
1436: ,NULL)
1437: /* WHEN (nvl(RENEWAL_ESTIMATED_PERCENT, 1) < 0 OR nvl(RENEWAL_ESTIMATED_PERCENT, 1) > 100) THEN

Line 1447: ,'OKS_HEADERS_INTERFACE'

1443: ,ERROR_MSG
1444: ,MSG_TOKENS)
1445: VALUES (G_WORKER_REQ_ID
1446: ,HEADER_INTERFACE_ROWID
1447: ,'OKS_HEADERS_INTERFACE'
1448: ,HEADER_INTERFACE_ID
1449: ,'OKS_IMP_HDR_NULL_EST_PERC'
1450: ,NULL) */
1451: /* WHEN (nvl(RENEWAL_ESTIMATED_DURATION, 1) <= 0 ) THEN

Line 1461: ,'OKS_HEADERS_INTERFACE'

1457: ,ERROR_MSG
1458: ,MSG_TOKENS)
1459: VALUES (G_WORKER_REQ_ID
1460: ,HEADER_INTERFACE_ROWID
1461: ,'OKS_HEADERS_INTERFACE'
1462: ,HEADER_INTERFACE_ID
1463: ,'OKS_IMP_HDR_INVALID_EST_DUR'
1464: ,NULL) */
1465: WHEN (REN_EST_DURPER_VALID = 'N') THEN

Line 1475: ,'OKS_HEADERS_INTERFACE'

1471: ,ERROR_MSG
1472: ,MSG_TOKENS)
1473: VALUES (G_WORKER_REQ_ID
1474: ,HEADER_INTERFACE_ROWID
1475: ,'OKS_HEADERS_INTERFACE'
1476: ,HEADER_INTERFACE_ID
1477: ,'OKS_IMP_HDR_INVALID_DATE_EST'
1478: ,NULL)
1479: WHEN (REN_EST_DURPER_NULL_ERROR = 'Y') THEN

Line 1489: ,'OKS_HEADERS_INTERFACE'

1485: ,ERROR_MSG
1486: ,MSG_TOKENS)
1487: VALUES (G_WORKER_REQ_ID
1488: ,HEADER_INTERFACE_ROWID
1489: ,'OKS_HEADERS_INTERFACE'
1490: ,HEADER_INTERFACE_ID
1491: ,'OKS_IMP_HDR_NULL_REN_EST'
1492: ,NULL)
1493: SELECT HST.CONTRACT_NUMBER CONTRACT_NUMBER

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

1493: SELECT HST.CONTRACT_NUMBER CONTRACT_NUMBER
1494: ,HST.HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID
1495: ,HST.HEADER_INTERFACE_ID HEADER_INTERFACE_ID
1496: ,COUNT(DISTINCT HDR.ROWID) OVER (PARTITION BY HST.ROWID) NUMBER_COUNT_IN_HDR
1497: ,(CASE WHEN EXISTS (SELECT 1 FROM OKS_HEADERS_INTERFACE
1498: WHERE HST.CONTRACT_NUMBER = CONTRACT_NUMBER
1499: AND nvl(HST.CONTRACT_NUMBER_MODIFIER, 'XgArBaGe!@#') = nvl(CONTRACT_NUMBER_MODIFIER (+), 'XgArBaGe!@#')
1500: AND HST.HEADER_INTERFACE_ID <> HEADER_INTERFACE_ID (+))
1501: THEN 'Y' ELSE 'N'

Line 1639: ,'OKS_HEADERS_INTERFACE'

1635: ,ERROR_MSG
1636: ,MSG_TOKENS)
1637: VALUES (G_WORKER_REQ_ID
1638: ,HEADER_INTERFACE_ROWID
1639: ,'OKS_HEADERS_INTERFACE'
1640: ,HEADER_INTERFACE_ID
1641: ,'OKS_IMP_HDR_INVALID_SALES_G'
1642: ,NULL)
1643: WHEN (QUOTE_TO_PARTY_SITE_V = 'N') THEN

Line 1653: ,'OKS_HEADERS_INTERFACE'

1649: ,ERROR_MSG
1650: ,MSG_TOKENS)
1651: VALUES (G_WORKER_REQ_ID
1652: ,HEADER_INTERFACE_ROWID
1653: ,'OKS_HEADERS_INTERFACE'
1654: ,HEADER_INTERFACE_ID
1655: ,'OKS_IMP_HDR_INVALID_QPS'
1656: ,NULL)
1657: WHEN (QUOTE_TO_CONTACT_V = 'N') THEN

Line 1667: ,'OKS_HEADERS_INTERFACE'

1663: ,ERROR_MSG
1664: ,MSG_TOKENS)
1665: VALUES (G_WORKER_REQ_ID
1666: ,HEADER_INTERFACE_ROWID
1667: ,'OKS_HEADERS_INTERFACE'
1668: ,HEADER_INTERFACE_ID
1669: ,'OKS_IMP_HDR_INVALID_QTC'
1670: ,NULL)
1671: WHEN (QUOTE_TO_PHONE_V = 'N') THEN

Line 1681: ,'OKS_HEADERS_INTERFACE'

1677: ,ERROR_MSG
1678: ,MSG_TOKENS)
1679: VALUES (G_WORKER_REQ_ID
1680: ,HEADER_INTERFACE_ROWID
1681: ,'OKS_HEADERS_INTERFACE'
1682: ,HEADER_INTERFACE_ID
1683: ,'OKS_IMP_HDR_INVALID_QTP'
1684: ,NULL)
1685: WHEN (QUOTE_TO_FAX_V = 'N') THEN

Line 1695: ,'OKS_HEADERS_INTERFACE'

1691: ,ERROR_MSG
1692: ,MSG_TOKENS)
1693: VALUES (G_WORKER_REQ_ID
1694: ,HEADER_INTERFACE_ROWID
1695: ,'OKS_HEADERS_INTERFACE'
1696: ,HEADER_INTERFACE_ID
1697: ,'OKS_IMP_HDR_INVALID_QTF'
1698: ,NULL)
1699: WHEN (QUOTE_TO_EMAIL_V = 'N') THEN

Line 1709: ,'OKS_HEADERS_INTERFACE'

1705: ,ERROR_MSG
1706: ,MSG_TOKENS)
1707: VALUES (G_WORKER_REQ_ID
1708: ,HEADER_INTERFACE_ROWID
1709: ,'OKS_HEADERS_INTERFACE'
1710: ,HEADER_INTERFACE_ID
1711: ,'OKS_IMP_HDR_INVALID_QTE'
1712: ,NULL)
1713: WHEN (nvl(GRACE_DURATION, 1) <= 0 OR floor(nvl(GRACE_DURATION, 1)) <> nvl(GRACE_DURATION, 1)) THEN

Line 1723: ,'OKS_HEADERS_INTERFACE'

1719: ,ERROR_MSG
1720: ,MSG_TOKENS)
1721: VALUES (G_WORKER_REQ_ID
1722: ,HEADER_INTERFACE_ROWID
1723: ,'OKS_HEADERS_INTERFACE'
1724: ,HEADER_INTERFACE_ID
1725: ,'OKS_IMP_HDR_INVALID_GRD'
1726: ,NULL)
1727: WHEN (GRPER_V = 'N') THEN

Line 1737: ,'OKS_HEADERS_INTERFACE'

1733: ,ERROR_MSG
1734: ,MSG_TOKENS)
1735: VALUES (G_WORKER_REQ_ID
1736: ,HEADER_INTERFACE_ROWID
1737: ,'OKS_HEADERS_INTERFACE'
1738: ,HEADER_INTERFACE_ID
1739: ,'OKS_IMP_HDR_INVALID_GRP'
1740: ,NULL)
1741: WHEN (GRPER_NULL_ERROR = 'Y') THEN

Line 1751: ,'OKS_HEADERS_INTERFACE'

1747: ,ERROR_MSG
1748: ,MSG_TOKENS)
1749: VALUES (G_WORKER_REQ_ID
1750: ,HEADER_INTERFACE_ROWID
1751: ,'OKS_HEADERS_INTERFACE'
1752: ,HEADER_INTERFACE_ID
1753: ,'OKS_IMP_HDR_NULL_GRP'
1754: ,NULL)
1755: /* WHEN (nvl(ESTIMATION_PERCENT, 1) < 0 OR nvl(ESTIMATION_PERCENT, 1) > 100) THEN

Line 1765: ,'OKS_HEADERS_INTERFACE'

1761: ,ERROR_MSG
1762: ,MSG_TOKENS)
1763: VALUES (G_WORKER_REQ_ID
1764: ,HEADER_INTERFACE_ROWID
1765: ,'OKS_HEADERS_INTERFACE'
1766: ,HEADER_INTERFACE_ID
1767: ,'OKS_IMP_HDR_INVALID_ESTPERC'
1768: ,NULL) */
1769: WHEN (ESTIMATION_PERCENT IS NOT NULL AND ESTIMATION_DATE IS NULL) THEN

Line 1779: ,'OKS_HEADERS_INTERFACE'

1775: ,ERROR_MSG
1776: ,MSG_TOKENS)
1777: VALUES (G_WORKER_REQ_ID
1778: ,HEADER_INTERFACE_ROWID
1779: ,'OKS_HEADERS_INTERFACE'
1780: ,HEADER_INTERFACE_ID
1781: ,'OKS_IMP_HDR_INVALID_ESTDATE'
1782: ,NULL)
1783: WHEN (EST_DATE_NULL_ERROR = 'Y') THEN

Line 1793: ,'OKS_HEADERS_INTERFACE'

1789: ,ERROR_MSG
1790: ,MSG_TOKENS)
1791: VALUES (G_WORKER_REQ_ID
1792: ,HEADER_INTERFACE_ROWID
1793: ,'OKS_HEADERS_INTERFACE'
1794: ,HEADER_INTERFACE_ID
1795: ,'OKS_IMP_HDR_NULL_ESTDATE'
1796: ,NULL)
1797: WHEN (FA_V = 'N') THEN

Line 1807: ,'OKS_HEADERS_INTERFACE'

1803: ,ERROR_MSG
1804: ,MSG_TOKENS)
1805: VALUES (G_WORKER_REQ_ID
1806: ,HEADER_INTERFACE_ROWID
1807: ,'OKS_HEADERS_INTERFACE'
1808: ,HEADER_INTERFACE_ID
1809: ,'OKS_IMP_HDR_INVALID_FA'
1810: ,NULL)
1811: WHEN (FA_NULL_ERROR = 'Y') THEN

Line 1821: ,'OKS_HEADERS_INTERFACE'

1817: ,ERROR_MSG
1818: ,MSG_TOKENS)
1819: VALUES (G_WORKER_REQ_ID
1820: ,HEADER_INTERFACE_ROWID
1821: ,'OKS_HEADERS_INTERFACE'
1822: ,HEADER_INTERFACE_ID
1823: ,'OKS_IMP_HDR_NULL_FA'
1824: ,NULL)
1825: WHEN (QAC_V = 'N') THEN

Line 1835: ,'OKS_HEADERS_INTERFACE'

1831: ,ERROR_MSG
1832: ,MSG_TOKENS)
1833: VALUES (G_WORKER_REQ_ID
1834: ,HEADER_INTERFACE_ROWID
1835: ,'OKS_HEADERS_INTERFACE'
1836: ,HEADER_INTERFACE_ID
1837: ,'OKS_IMP_HDR_INVALID_QAC'
1838: ,NULL)
1839: WHEN (AP_V = 'N') THEN

Line 1849: ,'OKS_HEADERS_INTERFACE'

1845: ,ERROR_MSG
1846: ,MSG_TOKENS)
1847: VALUES (G_WORKER_REQ_ID
1848: ,HEADER_INTERFACE_ROWID
1849: ,'OKS_HEADERS_INTERFACE'
1850: ,HEADER_INTERFACE_ID
1851: ,'OKS_IMP_HDR_INVALID_AP'
1852: ,NULL)
1853: WHEN (SALESGROUP_NULL_ERROR = 'Y') THEN

Line 1863: ,'OKS_HEADERS_INTERFACE'

1859: ,ERROR_MSG
1860: ,MSG_TOKENS)
1861: VALUES (G_WORKER_REQ_ID
1862: ,HEADER_INTERFACE_ROWID
1863: ,'OKS_HEADERS_INTERFACE'
1864: ,HEADER_INTERFACE_ID
1865: ,'OKS_IMP_HDR_NULL_SALESG'
1866: ,NULL)
1867: SELECT HST.HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID

Line 1958: ,'OKS_HEADERS_INTERFACE'

1954: ,ERROR_MSG
1955: ,MSG_TOKENS)
1956: VALUES (G_WORKER_REQ_ID
1957: ,HEADER_INTERFACE_ROWID
1958: ,'OKS_HEADERS_INTERFACE'
1959: ,HEADER_INTERFACE_ID
1960: ,'OKS_IMP_HDR_INVALID_TEC'
1961: ,NULL)
1962: WHEN (TUCEF_OU_V = 'N') THEN

Line 1972: ,'OKS_HEADERS_INTERFACE'

1968: ,ERROR_MSG
1969: ,MSG_TOKENS)
1970: VALUES (G_WORKER_REQ_ID
1971: ,HEADER_INTERFACE_ROWID
1972: ,'OKS_HEADERS_INTERFACE'
1973: ,HEADER_INTERFACE_ID
1974: ,'OKS_IMP_HDR_INVALID_TUCEF_OU'
1975: ,NULL)
1976: WHEN (TEN_V = 'N') THEN

Line 1986: ,'OKS_HEADERS_INTERFACE'

1982: ,ERROR_MSG
1983: ,MSG_TOKENS)
1984: VALUES (G_WORKER_REQ_ID
1985: ,HEADER_INTERFACE_ROWID
1986: ,'OKS_HEADERS_INTERFACE'
1987: ,HEADER_INTERFACE_ID
1988: ,'OKS_IMP_HDR_INVALID_TEN'
1989: ,NULL)
1990: WHEN (TEN_NULL_ERROR = 'Y') THEN

Line 2000: ,'OKS_HEADERS_INTERFACE'

1996: ,ERROR_MSG
1997: ,MSG_TOKENS)
1998: VALUES (G_WORKER_REQ_ID
1999: ,HEADER_INTERFACE_ROWID
2000: ,'OKS_HEADERS_INTERFACE'
2001: ,HEADER_INTERFACE_ID
2002: ,'OKS_IMP_HDR_NULL_TEN'
2003: ,NULL)
2004: WHEN (POREQ_V = 'N') THEN

Line 2014: ,'OKS_HEADERS_INTERFACE'

2010: ,ERROR_MSG
2011: ,MSG_TOKENS)
2012: VALUES (G_WORKER_REQ_ID
2013: ,HEADER_INTERFACE_ROWID
2014: ,'OKS_HEADERS_INTERFACE'
2015: ,HEADER_INTERFACE_ID
2016: ,'OKS_IMP_HDR_INVALID_POREQ'
2017: ,NULL)
2018: WHEN (POREQ_NULL_ERROR = 'Y') THEN

Line 2028: ,'OKS_HEADERS_INTERFACE'

2024: ,ERROR_MSG
2025: ,MSG_TOKENS)
2026: VALUES (G_WORKER_REQ_ID
2027: ,HEADER_INTERFACE_ROWID
2028: ,'OKS_HEADERS_INTERFACE'
2029: ,HEADER_INTERFACE_ID
2030: ,'OKS_IMP_HDR_NULL_POREQ'
2031: ,NULL)
2032: WHEN (BS_V = 'N') THEN

Line 2042: ,'OKS_HEADERS_INTERFACE'

2038: ,ERROR_MSG
2039: ,MSG_TOKENS)
2040: VALUES (G_WORKER_REQ_ID
2041: ,HEADER_INTERFACE_ROWID
2042: ,'OKS_HEADERS_INTERFACE'
2043: ,HEADER_INTERFACE_ID
2044: ,'OKS_IMP_HDR_INVALID_BS'
2045: ,NULL)
2046: WHEN (BTXNTYPE_V = 'N') THEN

Line 2056: ,'OKS_HEADERS_INTERFACE'

2052: ,ERROR_MSG
2053: ,MSG_TOKENS)
2054: VALUES (G_WORKER_REQ_ID
2055: ,HEADER_INTERFACE_ROWID
2056: ,'OKS_HEADERS_INTERFACE'
2057: ,HEADER_INTERFACE_ID
2058: ,'OKS_IMP_HDR_INVALID_BTXNTYPE'
2059: ,NULL)
2060: WHEN (HC_V = 'N') THEN

Line 2070: ,'OKS_HEADERS_INTERFACE'

2066: ,ERROR_MSG
2067: ,MSG_TOKENS)
2068: VALUES (G_WORKER_REQ_ID
2069: ,HEADER_INTERFACE_ROWID
2070: ,'OKS_HEADERS_INTERFACE'
2071: ,HEADER_INTERFACE_ID
2072: ,'OKS_IMP_HDR_INVALID_HC'
2073: ,NULL)
2074: WHEN (SP_V = 'N') THEN

Line 2084: ,'OKS_HEADERS_INTERFACE'

2080: ,ERROR_MSG
2081: ,MSG_TOKENS)
2082: VALUES (G_WORKER_REQ_ID
2083: ,HEADER_INTERFACE_ROWID
2084: ,'OKS_HEADERS_INTERFACE'
2085: ,HEADER_INTERFACE_ID
2086: ,'OKS_IMP_HDR_INVALID_SP'
2087: ,NULL)
2088: WHEN (ST_V = 'N') THEN

Line 2098: ,'OKS_HEADERS_INTERFACE'

2094: ,ERROR_MSG
2095: ,MSG_TOKENS)
2096: VALUES (G_WORKER_REQ_ID
2097: ,HEADER_INTERFACE_ROWID
2098: ,'OKS_HEADERS_INTERFACE'
2099: ,HEADER_INTERFACE_ID
2100: ,'OKS_IMP_HDR_INVALID_ST'
2101: ,NULL)
2102: WHEN (SER_CHRG_PREP_REQ_V = 'N') THEN

Line 2112: ,'OKS_HEADERS_INTERFACE'

2108: ,ERROR_MSG
2109: ,MSG_TOKENS)
2110: VALUES (G_WORKER_REQ_ID
2111: ,HEADER_INTERFACE_ROWID
2112: ,'OKS_HEADERS_INTERFACE'
2113: ,HEADER_INTERFACE_ID
2114: ,'OKS_IMP_HDR_INVALID_SCPREQ'
2115: ,NULL)
2116: WHEN (SER_CHRG_PO_REQ_V = 'N') THEN

Line 2126: ,'OKS_HEADERS_INTERFACE'

2122: ,ERROR_MSG
2123: ,MSG_TOKENS)
2124: VALUES (G_WORKER_REQ_ID
2125: ,HEADER_INTERFACE_ROWID
2126: ,'OKS_HEADERS_INTERFACE'
2127: ,HEADER_INTERFACE_ID
2128: ,'OKS_IMP_HDR_INVALID_SCPOREQ'
2129: ,NULL)
2130: WHEN (SOURCE_V = 'N') THEN

Line 2140: ,'OKS_HEADERS_INTERFACE'

2136: ,ERROR_MSG
2137: ,MSG_TOKENS)
2138: VALUES (G_WORKER_REQ_ID
2139: ,HEADER_INTERFACE_ROWID
2140: ,'OKS_HEADERS_INTERFACE'
2141: ,HEADER_INTERFACE_ID
2142: ,'OKS_IMP_HDR_INVALID_SOURCE'
2143: ,NULL)
2144: WHEN (HOI_COUNT = 0) THEN

Line 2154: ,'OKS_HEADERS_INTERFACE'

2150: ,ERROR_MSG
2151: ,MSG_TOKENS)
2152: VALUES (G_WORKER_REQ_ID
2153: ,HEADER_INTERFACE_ROWID
2154: ,'OKS_HEADERS_INTERFACE'
2155: ,HEADER_INTERFACE_ID
2156: ,'OKS_IMP_HST_INVALID_INVORG'
2157: ,NULL)
2158: WHEN (ERC_NULL_ERROR = 'Y') THEN

Line 2168: ,'OKS_HEADERS_INTERFACE'

2164: ,ERROR_MSG
2165: ,MSG_TOKENS)
2166: VALUES (G_WORKER_REQ_ID
2167: ,HEADER_INTERFACE_ROWID
2168: ,'OKS_HEADERS_INTERFACE'
2169: ,HEADER_INTERFACE_ID
2170: ,'OKS_IMP_HDR_NULL_ERC'
2171: ,NULL)
2172:

Line 5834: FROM OKS_HEADERS_INTERFACE

5830: l_stmt_num := 10;
5831: /* delete from errors table all the records related to the contracts which are going to be validated by this worker.*/
5832: DELETE FROM OKS_IMP_ERRORS
5833: WHERE HEADER_INTERFACE_ID IN (SELECT HEADER_INTERFACE_ID
5834: FROM OKS_HEADERS_INTERFACE
5835: WHERE rowid between P_rowid_from and P_rowid_to
5836: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R'));
5837: l_stmt_num := 20;
5838: Validate_header (P_batch_id,