[Home] [Help]
227: ,FULLY_BILLED
228: ,SOURCE
229: ,DOCUMENT)
230: WHEN (OPERATING_UNIT_ID IS NULL) THEN
231: INTO OKS_INT_ERROR_STG_TEMP
232: (CONCURRENT_REQUEST_ID
233: ,HEADER_INTERFACE_ROWID
234: ,INTERFACE_SOURCE_TABLE
235: ,INTERFACE_ID
241: ,HEADER_INTERFACE_ID
242: ,'OKS_IMP_HDR_INVALID_OU'
243: ,NULL)
244: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN
245: INTO OKS_INT_ERROR_STG_TEMP
246: (CONCURRENT_REQUEST_ID
247: ,HEADER_INTERFACE_ROWID
248: ,INTERFACE_SOURCE_TABLE
249: ,INTERFACE_ID
255: ,HEADER_INTERFACE_ID
256: ,'OKS_IMP_HDR_INVALID_BTSU'
257: ,NULL)
258: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN
259: INTO OKS_INT_ERROR_STG_TEMP
260: (CONCURRENT_REQUEST_ID
261: ,HEADER_INTERFACE_ROWID
262: ,INTERFACE_SOURCE_TABLE
263: ,INTERFACE_ID
269: ,HEADER_INTERFACE_ID
270: ,'OKS_IMP_HDR_INVALID_STSU'
271: ,NULL)
272: WHEN (CONTRACT_CURRENCY_CODE IS NULL) THEN
273: INTO OKS_INT_ERROR_STG_TEMP
274: (CONCURRENT_REQUEST_ID
275: ,HEADER_INTERFACE_ROWID
276: ,INTERFACE_SOURCE_TABLE
277: ,INTERFACE_ID
285: ,NULL)
286: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
287: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
288: AND CURRENCY_CONVERSION_TYPE IS NULL) THEN
289: INTO OKS_INT_ERROR_STG_TEMP
290: (CONCURRENT_REQUEST_ID
291: ,HEADER_INTERFACE_ROWID
292: ,INTERFACE_SOURCE_TABLE
293: ,INTERFACE_ID
302: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
303: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
304: AND CURRENCY_CONVERSION_TYPE = 'User'
305: AND (CURRENCY_CONVERSION_RATE IS NULL OR CURRENCY_CONVERSION_RATE <= 0)) THEN
306: INTO OKS_INT_ERROR_STG_TEMP
307: (CONCURRENT_REQUEST_ID
308: ,HEADER_INTERFACE_ROWID
309: ,INTERFACE_SOURCE_TABLE
310: ,INTERFACE_ID
318: ,NULL)
319: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
320: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
321: AND CURRENCY_CONVERSION_DATE IS NULL) THEN
322: INTO OKS_INT_ERROR_STG_TEMP
323: (CONCURRENT_REQUEST_ID
324: ,HEADER_INTERFACE_ROWID
325: ,INTERFACE_SOURCE_TABLE
326: ,INTERFACE_ID
335: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
336: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
337: AND CURRENCY_CONVERSION_TYPE <> 'User'
338: AND HDR_CURRENCY_CONVERSION_RATE IS NOT NULL) THEN
339: INTO OKS_INT_ERROR_STG_TEMP
340: (CONCURRENT_REQUEST_ID
341: ,HEADER_INTERFACE_ROWID
342: ,INTERFACE_SOURCE_TABLE
343: ,INTERFACE_ID
353: AND CONTRACT_CURRENCY_CODE = OU_LEDGER_CUR_CODE
354: AND (CURRENCY_CONVERSION_TYPE IS NOT NULL
355: OR HDR_CURRENCY_CONVERSION_RATE IS NOT NULL
356: OR CURRENCY_CONVERSION_DATE IS NOT NULL)) THEN
357: INTO OKS_INT_ERROR_STG_TEMP
358: (CONCURRENT_REQUEST_ID
359: ,HEADER_INTERFACE_ROWID
360: ,INTERFACE_SOURCE_TABLE
361: ,INTERFACE_ID
367: ,HEADER_INTERFACE_ID
368: ,'OKS_IMP_HDR_NULL_CONV'
369: ,NULL)
370: WHEN (PRICE_LIST_ID IS NULL) THEN
371: INTO OKS_INT_ERROR_STG_TEMP
372: (CONCURRENT_REQUEST_ID
373: ,HEADER_INTERFACE_ROWID
374: ,INTERFACE_SOURCE_TABLE
375: ,INTERFACE_ID
381: ,HEADER_INTERFACE_ID
382: ,'OKS_IMP_HDR_INVALID_PRICELIST'
383: ,NULL)
384: WHEN (PAYMENT_TERMS_ID IS NULL) THEN
385: INTO OKS_INT_ERROR_STG_TEMP
386: (CONCURRENT_REQUEST_ID
387: ,HEADER_INTERFACE_ROWID
388: ,INTERFACE_SOURCE_TABLE
389: ,INTERFACE_ID
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
399: INTO OKS_INT_ERROR_STG_TEMP
400: (CONCURRENT_REQUEST_ID
401: ,HEADER_INTERFACE_ROWID
402: ,INTERFACE_SOURCE_TABLE
403: ,INTERFACE_ID
409: ,HEADER_INTERFACE_ID
410: ,'OKS_IMP_HDR_INVALID_PAYINSTR'
411: ,NULL)
412: WHEN (INVOICING_RULE_ID IS NULL) THEN
413: INTO OKS_INT_ERROR_STG_TEMP
414: (CONCURRENT_REQUEST_ID
415: ,HEADER_INTERFACE_ROWID
416: ,INTERFACE_SOURCE_TABLE
417: ,INTERFACE_ID
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
427: INTO OKS_INT_ERROR_STG_TEMP
428: (CONCURRENT_REQUEST_ID
429: ,HEADER_INTERFACE_ROWID
430: ,INTERFACE_SOURCE_TABLE
431: ,INTERFACE_ID
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
441: INTO OKS_INT_ERROR_STG_TEMP
442: (CONCURRENT_REQUEST_ID
443: ,HEADER_INTERFACE_ROWID
444: ,INTERFACE_SOURCE_TABLE
445: ,INTERFACE_ID
451: ,HEADER_INTERFACE_ID
452: ,'OKS_IMP_HDR_INVALID_COMMIT'
453: ,NULL)
454: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN
455: INTO OKS_INT_ERROR_STG_TEMP
456: (CONCURRENT_REQUEST_ID
457: ,HEADER_INTERFACE_ROWID
458: ,INTERFACE_SOURCE_TABLE
459: ,INTERFACE_ID
466: ,'OKS_IMP_HDR_INVALID_ACCRULE'
467: ,NULL)
468: WHEN (PRICING_METHOD = 'LST' AND RENEWAL_PRICE_LIST_ID IS NULL)
469: OR (RENEWAL_PRICE_LIST_ID IS NOT NULL AND (PRICING_METHOD NOT IN ('LST', 'PCT') OR PRICING_METHOD IS NULL ) ) THEN
470: INTO OKS_INT_ERROR_STG_TEMP
471: (CONCURRENT_REQUEST_ID
472: ,HEADER_INTERFACE_ROWID
473: ,INTERFACE_SOURCE_TABLE
474: ,INTERFACE_ID
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
484: INTO OKS_INT_ERROR_STG_TEMP
485: (CONCURRENT_REQUEST_ID
486: ,HEADER_INTERFACE_ROWID
487: ,INTERFACE_SOURCE_TABLE
488: ,INTERFACE_ID
494: ,HEADER_INTERFACE_ID
495: ,'OKS_IMP_HDR_INVALID_RENPL'
496: ,NULL)
497: WHEN (CUSTOMER_PARTY_ID IS NULL) THEN
498: INTO OKS_INT_ERROR_STG_TEMP
499: (CONCURRENT_REQUEST_ID
500: ,HEADER_INTERFACE_ROWID
501: ,INTERFACE_SOURCE_TABLE
502: ,INTERFACE_ID
508: ,HEADER_INTERFACE_ID
509: ,'OKS_IMP_HDR_INVALID_CTPARTY'
510: ,NULL)
511: WHEN (TP_PROVIDED = 'Y' AND THIRD_PARTY_ID IS NULL) THEN
512: INTO OKS_INT_ERROR_STG_TEMP
513: (CONCURRENT_REQUEST_ID
514: ,HEADER_INTERFACE_ROWID
515: ,INTERFACE_SOURCE_TABLE
516: ,INTERFACE_ID
522: ,HEADER_INTERFACE_ID
523: ,'OKS_IMP_HDR_INVALID_TPPARTY'
524: ,NULL)
525: WHEN (CONTRACT_GROUP_ID IS NULL) THEN
526: INTO OKS_INT_ERROR_STG_TEMP
527: (CONCURRENT_REQUEST_ID
528: ,HEADER_INTERFACE_ROWID
529: ,INTERFACE_SOURCE_TABLE
530: ,INTERFACE_ID
536: ,HEADER_INTERFACE_ID
537: ,'OKS_IMP_HDR_INVALID_CG'
538: ,NULL)
539: WHEN (AGREEMENT_PROVIDED = 'Y' AND AGREEMENT_ID IS NULL) THEN
540: INTO OKS_INT_ERROR_STG_TEMP
541: (CONCURRENT_REQUEST_ID
542: ,HEADER_INTERFACE_ROWID
543: ,INTERFACE_SOURCE_TABLE
544: ,INTERFACE_ID
550: ,HEADER_INTERFACE_ID
551: ,'OKS_IMP_HDR_INVALID_PAGRMT'
552: ,NULL)
553: WHEN (SALESPERSON_PROVIDED = 'Y' AND SALESPERSON_ID IS NULL) THEN
554: INTO OKS_INT_ERROR_STG_TEMP
555: (CONCURRENT_REQUEST_ID
556: ,HEADER_INTERFACE_ROWID
557: ,INTERFACE_SOURCE_TABLE
558: ,INTERFACE_ID
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
568: INTO OKS_INT_ERROR_STG_TEMP
569: (CONCURRENT_REQUEST_ID
570: ,HEADER_INTERFACE_ROWID
571: ,INTERFACE_SOURCE_TABLE
572: ,INTERFACE_ID
578: ,HEADER_INTERFACE_ID
579: ,'OKS_IMP_HDR_INVALID_CCADMIN'
580: ,NULL)
581: WHEN DESCRIPTION IS NULL THEN
582: INTO OKS_INT_ERROR_STG_TEMP
583: (CONCURRENT_REQUEST_ID
584: ,HEADER_INTERFACE_ROWID
585: ,INTERFACE_SOURCE_TABLE
586: ,INTERFACE_ID
592: ,HEADER_INTERFACE_ID
593: ,'OKS_IMP_HDR_INVALID_DESC'
594: ,NULL)
595: WHEN FULLY_BILLED IS NULL THEN
596: INTO OKS_INT_ERROR_STG_TEMP
597: (CONCURRENT_REQUEST_ID
598: ,HEADER_INTERFACE_ROWID
599: ,INTERFACE_SOURCE_TABLE
600: ,INTERFACE_ID
606: ,HEADER_INTERFACE_ID
607: ,'OKS_IMP_HDR_INVALID_FULB'
608: ,NULL)
609: WHEN FULLY_BILLED_INV ='Y' THEN
610: INTO OKS_INT_ERROR_STG_TEMP
611: (CONCURRENT_REQUEST_ID
612: ,HEADER_INTERFACE_ROWID
613: ,INTERFACE_SOURCE_TABLE
614: ,INTERFACE_ID
998: l_stmt_num := 20;
999:
1000: INSERT ALL
1001: WHEN (CONTRACT_NUMBER IS NULL) THEN
1002: INTO OKS_INT_ERROR_STG_TEMP
1003: (CONCURRENT_REQUEST_ID
1004: ,HEADER_INTERFACE_ROWID
1005: ,INTERFACE_SOURCE_TABLE
1006: ,INTERFACE_ID
1012: ,HEADER_INTERFACE_ID
1013: ,'OKS_IMP_HDR_INVALID_NUM'
1014: ,NULL)
1015: WHEN (NUMBER_COUNT_IN_HDR > 0) THEN
1016: INTO OKS_INT_ERROR_STG_TEMP
1017: (CONCURRENT_REQUEST_ID
1018: ,HEADER_INTERFACE_ROWID
1019: ,INTERFACE_SOURCE_TABLE
1020: ,INTERFACE_ID
1026: ,HEADER_INTERFACE_ID
1027: ,'OKS_IMP_HDR_NONUNIQ_NUM_HDR'
1028: ,NULL)
1029: WHEN (NUMBER_NOTUNIQ_IN_INT = 'Y') THEN
1030: INTO OKS_INT_ERROR_STG_TEMP
1031: (CONCURRENT_REQUEST_ID
1032: ,HEADER_INTERFACE_ROWID
1033: ,INTERFACE_SOURCE_TABLE
1034: ,INTERFACE_ID
1040: ,HEADER_INTERFACE_ID
1041: ,'OKS_IMP_HDR_NONUNIQ_NUM_INT'
1042: ,NULL)
1043: WHEN (CAT_COUNT <> 1) THEN
1044: INTO OKS_INT_ERROR_STG_TEMP
1045: (CONCURRENT_REQUEST_ID
1046: ,HEADER_INTERFACE_ROWID
1047: ,INTERFACE_SOURCE_TABLE
1048: ,INTERFACE_ID
1054: ,HEADER_INTERFACE_ID
1055: ,'OKS_IMP_HDR_INVALID_CAT'
1056: ,NULL)
1057: WHEN (DATE_VALID = 'N') THEN
1058: INTO OKS_INT_ERROR_STG_TEMP
1059: (CONCURRENT_REQUEST_ID
1060: ,HEADER_INTERFACE_ROWID
1061: ,INTERFACE_SOURCE_TABLE
1062: ,INTERFACE_ID
1068: ,HEADER_INTERFACE_ID
1069: ,'OKS_IMP_HDR_INVALID_DATE'
1070: ,NULL)
1071: WHEN (STATUS_VALID = 'N') THEN
1072: INTO OKS_INT_ERROR_STG_TEMP
1073: (CONCURRENT_REQUEST_ID
1074: ,HEADER_INTERFACE_ROWID
1075: ,INTERFACE_SOURCE_TABLE
1076: ,INTERFACE_ID
1082: ,HEADER_INTERFACE_ID
1083: ,'OKS_IMP_HDR_INVALID_STATUS'
1084: ,NULL)
1085: WHEN (STATUS_X_DATE_VALID = 'N') THEN
1086: INTO OKS_INT_ERROR_STG_TEMP
1087: (CONCURRENT_REQUEST_ID
1088: ,HEADER_INTERFACE_ROWID
1089: ,INTERFACE_SOURCE_TABLE
1090: ,INTERFACE_ID
1096: ,HEADER_INTERFACE_ID
1097: ,'OKS_IMP_HDR_STATUS_X_DATE'
1098: ,NULL)
1099: WHEN (DATE_APPROVED_VALID = 'N') THEN
1100: INTO OKS_INT_ERROR_STG_TEMP
1101: (CONCURRENT_REQUEST_ID
1102: ,HEADER_INTERFACE_ROWID
1103: ,INTERFACE_SOURCE_TABLE
1104: ,INTERFACE_ID
1110: ,HEADER_INTERFACE_ID
1111: ,'OKS_IMP_HDR_INVALID_DATE_APRV'
1112: ,NULL)
1113: WHEN (DATE_APPROVED_NULL_ERROR = 'Y') THEN
1114: INTO OKS_INT_ERROR_STG_TEMP
1115: (CONCURRENT_REQUEST_ID
1116: ,HEADER_INTERFACE_ROWID
1117: ,INTERFACE_SOURCE_TABLE
1118: ,INTERFACE_ID
1124: ,HEADER_INTERFACE_ID
1125: ,'OKS_IMP_HDR_NULL_DATE_APRV'
1126: ,NULL)
1127: WHEN (DATE_CANCELED_VALID = 'N') THEN
1128: INTO OKS_INT_ERROR_STG_TEMP
1129: (CONCURRENT_REQUEST_ID
1130: ,HEADER_INTERFACE_ROWID
1131: ,INTERFACE_SOURCE_TABLE
1132: ,INTERFACE_ID
1138: ,HEADER_INTERFACE_ID
1139: ,'OKS_IMP_HDR_INVALID_DATE_CANC'
1140: ,NULL)
1141: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN
1142: INTO OKS_INT_ERROR_STG_TEMP
1143: (CONCURRENT_REQUEST_ID
1144: ,HEADER_INTERFACE_ROWID
1145: ,INTERFACE_SOURCE_TABLE
1146: ,INTERFACE_ID
1152: ,HEADER_INTERFACE_ID
1153: ,'OKS_IMP_HDR_NULL_DATE_CANC'
1154: ,NULL)
1155: WHEN (CR_VALID = 'N') THEN
1156: INTO OKS_INT_ERROR_STG_TEMP
1157: (CONCURRENT_REQUEST_ID
1158: ,HEADER_INTERFACE_ROWID
1159: ,INTERFACE_SOURCE_TABLE
1160: ,INTERFACE_ID
1166: ,HEADER_INTERFACE_ID
1167: ,'OKS_IMP_HDR_INVALID_CANC_RSN'
1168: ,NULL)
1169: WHEN (CR_NULL_ERROR = 'Y') THEN
1170: INTO OKS_INT_ERROR_STG_TEMP
1171: (CONCURRENT_REQUEST_ID
1172: ,HEADER_INTERFACE_ROWID
1173: ,INTERFACE_SOURCE_TABLE
1174: ,INTERFACE_ID
1180: ,HEADER_INTERFACE_ID
1181: ,'OKS_IMP_HDR_NULL_CANC_RSN'
1182: ,NULL)
1183: WHEN (DATE_SIGNED_VALID = 'N') THEN
1184: INTO OKS_INT_ERROR_STG_TEMP
1185: (CONCURRENT_REQUEST_ID
1186: ,HEADER_INTERFACE_ROWID
1187: ,INTERFACE_SOURCE_TABLE
1188: ,INTERFACE_ID
1194: ,HEADER_INTERFACE_ID
1195: ,'OKS_IMP_HDR_INVALID_DATE_SGND'
1196: ,NULL)
1197: WHEN (DATE_SIGNED_NULL_ERROR = 'Y') THEN
1198: INTO OKS_INT_ERROR_STG_TEMP
1199: (CONCURRENT_REQUEST_ID
1200: ,HEADER_INTERFACE_ROWID
1201: ,INTERFACE_SOURCE_TABLE
1202: ,INTERFACE_ID
1208: ,HEADER_INTERFACE_ID
1209: ,'OKS_IMP_HDR_NULL_DATE_SGND'
1210: ,NULL)
1211: WHEN (RENP_VALID = 'N') THEN
1212: INTO OKS_INT_ERROR_STG_TEMP
1213: (CONCURRENT_REQUEST_ID
1214: ,HEADER_INTERFACE_ROWID
1215: ,INTERFACE_SOURCE_TABLE
1216: ,INTERFACE_ID
1222: ,HEADER_INTERFACE_ID
1223: ,'OKS_IMP_HDR_INVALID_REN_PROC'
1224: ,NULL)
1225: WHEN (RENUPTO_VALID = 'N') THEN
1226: INTO OKS_INT_ERROR_STG_TEMP
1227: (CONCURRENT_REQUEST_ID
1228: ,HEADER_INTERFACE_ROWID
1229: ,INTERFACE_SOURCE_TABLE
1230: ,INTERFACE_ID
1236: ,HEADER_INTERFACE_ID
1237: ,'OKS_IMP_HDR_INVALID_REN_UPTO'
1238: ,NULL)
1239: WHEN (RENUPTO_NULL_ERROR = 'Y') THEN
1240: INTO OKS_INT_ERROR_STG_TEMP
1241: (CONCURRENT_REQUEST_ID
1242: ,HEADER_INTERFACE_ROWID
1243: ,INTERFACE_SOURCE_TABLE
1244: ,INTERFACE_ID
1250: ,HEADER_INTERFACE_ID
1251: ,'OKS_IMP_HDR_NULL_REN_UPTO'
1252: ,NULL)
1253: WHEN (APRV_REQ_VALID = 'N') THEN
1254: INTO OKS_INT_ERROR_STG_TEMP
1255: (CONCURRENT_REQUEST_ID
1256: ,HEADER_INTERFACE_ROWID
1257: ,INTERFACE_SOURCE_TABLE
1258: ,INTERFACE_ID
1264: ,HEADER_INTERFACE_ID
1265: ,'OKS_IMP_HDR_INVALID_APRV_REQ'
1266: ,NULL)
1267: WHEN (APRV_REQ_NULL_ERROR = 'Y') THEN
1268: INTO OKS_INT_ERROR_STG_TEMP
1269: (CONCURRENT_REQUEST_ID
1270: ,HEADER_INTERFACE_ROWID
1271: ,INTERFACE_SOURCE_TABLE
1272: ,INTERFACE_ID
1278: ,HEADER_INTERFACE_ID
1279: ,'OKS_IMP_HDR_NULL_APRV_REQ'
1280: ,NULL)
1281: WHEN (PRM_VALID = 'N') THEN
1282: INTO OKS_INT_ERROR_STG_TEMP
1283: (CONCURRENT_REQUEST_ID
1284: ,HEADER_INTERFACE_ROWID
1285: ,INTERFACE_SOURCE_TABLE
1286: ,INTERFACE_ID
1292: ,HEADER_INTERFACE_ID
1293: ,'OKS_IMP_HDR_INVALID_PRC_METHOD'
1294: ,NULL)
1295: WHEN (PRM_NULL_ERROR = 'Y') THEN
1296: INTO OKS_INT_ERROR_STG_TEMP
1297: (CONCURRENT_REQUEST_ID
1298: ,HEADER_INTERFACE_ROWID
1299: ,INTERFACE_SOURCE_TABLE
1300: ,INTERFACE_ID
1306: ,HEADER_INTERFACE_ID
1307: ,'OKS_IMP_HDR_NULL_PRC_METHOD'
1308: ,NULL)
1309: WHEN (MKP_VALID = 'N') THEN
1310: INTO OKS_INT_ERROR_STG_TEMP
1311: (CONCURRENT_REQUEST_ID
1312: ,HEADER_INTERFACE_ROWID
1313: ,INTERFACE_SOURCE_TABLE
1314: ,INTERFACE_ID
1320: ,HEADER_INTERFACE_ID
1321: ,'OKS_IMP_HDR_INVALID_MARKUP'
1322: ,NULL)
1323: WHEN (MKP_NULL_ERROR = 'Y') THEN
1324: INTO OKS_INT_ERROR_STG_TEMP
1325: (CONCURRENT_REQUEST_ID
1326: ,HEADER_INTERFACE_ROWID
1327: ,INTERFACE_SOURCE_TABLE
1328: ,INTERFACE_ID
1334: ,HEADER_INTERFACE_ID
1335: ,'OKS_IMP_HDR_NULL_MARKUP'
1336: ,NULL)
1337: WHEN (BP_VALID = 'N') THEN
1338: INTO OKS_INT_ERROR_STG_TEMP
1339: (CONCURRENT_REQUEST_ID
1340: ,HEADER_INTERFACE_ROWID
1341: ,INTERFACE_SOURCE_TABLE
1342: ,INTERFACE_ID
1348: ,HEADER_INTERFACE_ID
1349: ,'OKS_IMP_HDR_INVALID_BILLPROF'
1350: ,NULL)
1351: WHEN (RENPOREQ_VALID = 'N') THEN
1352: INTO OKS_INT_ERROR_STG_TEMP
1353: (CONCURRENT_REQUEST_ID
1354: ,HEADER_INTERFACE_ROWID
1355: ,INTERFACE_SOURCE_TABLE
1356: ,INTERFACE_ID
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
1366: INTO OKS_INT_ERROR_STG_TEMP
1367: (CONCURRENT_REQUEST_ID
1368: ,HEADER_INTERFACE_ROWID
1369: ,INTERFACE_SOURCE_TABLE
1370: ,INTERFACE_ID
1376: ,HEADER_INTERFACE_ID
1377: ,'OKS_IMP_HDR_INVALID_RENGR_DUR'
1378: ,NULL)
1379: WHEN (RENGRPER_VALID = 'N') THEN
1380: INTO OKS_INT_ERROR_STG_TEMP
1381: (CONCURRENT_REQUEST_ID
1382: ,HEADER_INTERFACE_ROWID
1383: ,INTERFACE_SOURCE_TABLE
1384: ,INTERFACE_ID
1390: ,HEADER_INTERFACE_ID
1391: ,'OKS_IMP_HDR_INVALID_RENGR_PER'
1392: ,NULL)
1393: WHEN (RENGRPER_NULL_ERROR = 'Y') THEN
1394: INTO OKS_INT_ERROR_STG_TEMP
1395: (CONCURRENT_REQUEST_ID
1396: ,HEADER_INTERFACE_ROWID
1397: ,INTERFACE_SOURCE_TABLE
1398: ,INTERFACE_ID
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
1408: INTO OKS_INT_ERROR_STG_TEMP
1409: (CONCURRENT_REQUEST_ID
1410: ,HEADER_INTERFACE_ROWID
1411: ,INTERFACE_SOURCE_TABLE
1412: ,INTERFACE_ID
1418: ,HEADER_INTERFACE_ID
1419: ,'OKS_IMP_HDR_NULL_EST_PERC'
1420: ,NULL) */
1421: /* WHEN (nvl(RENEWAL_ESTIMATED_DURATION, 1) <= 0 ) THEN
1422: INTO OKS_INT_ERROR_STG_TEMP
1423: (CONCURRENT_REQUEST_ID
1424: ,HEADER_INTERFACE_ROWID
1425: ,INTERFACE_SOURCE_TABLE
1426: ,INTERFACE_ID
1432: ,HEADER_INTERFACE_ID
1433: ,'OKS_IMP_HDR_INVALID_EST_DUR'
1434: ,NULL) */
1435: WHEN (REN_EST_DURPER_VALID = 'N') THEN
1436: INTO OKS_INT_ERROR_STG_TEMP
1437: (CONCURRENT_REQUEST_ID
1438: ,HEADER_INTERFACE_ROWID
1439: ,INTERFACE_SOURCE_TABLE
1440: ,INTERFACE_ID
1446: ,HEADER_INTERFACE_ID
1447: ,'OKS_IMP_HDR_INVALID_DATE_EST'
1448: ,NULL)
1449: WHEN (REN_EST_DURPER_NULL_ERROR = 'Y') THEN
1450: INTO OKS_INT_ERROR_STG_TEMP
1451: (CONCURRENT_REQUEST_ID
1452: ,HEADER_INTERFACE_ROWID
1453: ,INTERFACE_SOURCE_TABLE
1454: ,INTERFACE_ID
1596: l_stmt_num := 30;
1597:
1598: INSERT ALL
1599: WHEN (SALESGROUP_V = 'N') THEN
1600: INTO OKS_INT_ERROR_STG_TEMP
1601: (CONCURRENT_REQUEST_ID
1602: ,HEADER_INTERFACE_ROWID
1603: ,INTERFACE_SOURCE_TABLE
1604: ,INTERFACE_ID
1610: ,HEADER_INTERFACE_ID
1611: ,'OKS_IMP_HDR_INVALID_SALES_G'
1612: ,NULL)
1613: WHEN (QUOTE_TO_PARTY_SITE_V = 'N') THEN
1614: INTO OKS_INT_ERROR_STG_TEMP
1615: (CONCURRENT_REQUEST_ID
1616: ,HEADER_INTERFACE_ROWID
1617: ,INTERFACE_SOURCE_TABLE
1618: ,INTERFACE_ID
1624: ,HEADER_INTERFACE_ID
1625: ,'OKS_IMP_HDR_INVALID_QPS'
1626: ,NULL)
1627: WHEN (QUOTE_TO_CONTACT_V = 'N') THEN
1628: INTO OKS_INT_ERROR_STG_TEMP
1629: (CONCURRENT_REQUEST_ID
1630: ,HEADER_INTERFACE_ROWID
1631: ,INTERFACE_SOURCE_TABLE
1632: ,INTERFACE_ID
1638: ,HEADER_INTERFACE_ID
1639: ,'OKS_IMP_HDR_INVALID_QTC'
1640: ,NULL)
1641: WHEN (QUOTE_TO_PHONE_V = 'N') THEN
1642: INTO OKS_INT_ERROR_STG_TEMP
1643: (CONCURRENT_REQUEST_ID
1644: ,HEADER_INTERFACE_ROWID
1645: ,INTERFACE_SOURCE_TABLE
1646: ,INTERFACE_ID
1652: ,HEADER_INTERFACE_ID
1653: ,'OKS_IMP_HDR_INVALID_QTP'
1654: ,NULL)
1655: WHEN (QUOTE_TO_FAX_V = 'N') THEN
1656: INTO OKS_INT_ERROR_STG_TEMP
1657: (CONCURRENT_REQUEST_ID
1658: ,HEADER_INTERFACE_ROWID
1659: ,INTERFACE_SOURCE_TABLE
1660: ,INTERFACE_ID
1666: ,HEADER_INTERFACE_ID
1667: ,'OKS_IMP_HDR_INVALID_QTF'
1668: ,NULL)
1669: WHEN (QUOTE_TO_EMAIL_V = 'N') THEN
1670: INTO OKS_INT_ERROR_STG_TEMP
1671: (CONCURRENT_REQUEST_ID
1672: ,HEADER_INTERFACE_ROWID
1673: ,INTERFACE_SOURCE_TABLE
1674: ,INTERFACE_ID
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
1684: INTO OKS_INT_ERROR_STG_TEMP
1685: (CONCURRENT_REQUEST_ID
1686: ,HEADER_INTERFACE_ROWID
1687: ,INTERFACE_SOURCE_TABLE
1688: ,INTERFACE_ID
1694: ,HEADER_INTERFACE_ID
1695: ,'OKS_IMP_HDR_INVALID_GRD'
1696: ,NULL)
1697: WHEN (GRPER_V = 'N') THEN
1698: INTO OKS_INT_ERROR_STG_TEMP
1699: (CONCURRENT_REQUEST_ID
1700: ,HEADER_INTERFACE_ROWID
1701: ,INTERFACE_SOURCE_TABLE
1702: ,INTERFACE_ID
1708: ,HEADER_INTERFACE_ID
1709: ,'OKS_IMP_HDR_INVALID_GRP'
1710: ,NULL)
1711: WHEN (GRPER_NULL_ERROR = 'Y') THEN
1712: INTO OKS_INT_ERROR_STG_TEMP
1713: (CONCURRENT_REQUEST_ID
1714: ,HEADER_INTERFACE_ROWID
1715: ,INTERFACE_SOURCE_TABLE
1716: ,INTERFACE_ID
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
1726: INTO OKS_INT_ERROR_STG_TEMP
1727: (CONCURRENT_REQUEST_ID
1728: ,HEADER_INTERFACE_ROWID
1729: ,INTERFACE_SOURCE_TABLE
1730: ,INTERFACE_ID
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
1740: INTO OKS_INT_ERROR_STG_TEMP
1741: (CONCURRENT_REQUEST_ID
1742: ,HEADER_INTERFACE_ROWID
1743: ,INTERFACE_SOURCE_TABLE
1744: ,INTERFACE_ID
1750: ,HEADER_INTERFACE_ID
1751: ,'OKS_IMP_HDR_INVALID_ESTDATE'
1752: ,NULL)
1753: WHEN (EST_DATE_NULL_ERROR = 'Y') THEN
1754: INTO OKS_INT_ERROR_STG_TEMP
1755: (CONCURRENT_REQUEST_ID
1756: ,HEADER_INTERFACE_ROWID
1757: ,INTERFACE_SOURCE_TABLE
1758: ,INTERFACE_ID
1764: ,HEADER_INTERFACE_ID
1765: ,'OKS_IMP_HDR_NULL_ESTDATE'
1766: ,NULL)
1767: WHEN (FA_V = 'N') THEN
1768: INTO OKS_INT_ERROR_STG_TEMP
1769: (CONCURRENT_REQUEST_ID
1770: ,HEADER_INTERFACE_ROWID
1771: ,INTERFACE_SOURCE_TABLE
1772: ,INTERFACE_ID
1778: ,HEADER_INTERFACE_ID
1779: ,'OKS_IMP_HDR_INVALID_FA'
1780: ,NULL)
1781: WHEN (FA_NULL_ERROR = 'Y') THEN
1782: INTO OKS_INT_ERROR_STG_TEMP
1783: (CONCURRENT_REQUEST_ID
1784: ,HEADER_INTERFACE_ROWID
1785: ,INTERFACE_SOURCE_TABLE
1786: ,INTERFACE_ID
1792: ,HEADER_INTERFACE_ID
1793: ,'OKS_IMP_HDR_NULL_FA'
1794: ,NULL)
1795: WHEN (QAC_V = 'N') THEN
1796: INTO OKS_INT_ERROR_STG_TEMP
1797: (CONCURRENT_REQUEST_ID
1798: ,HEADER_INTERFACE_ROWID
1799: ,INTERFACE_SOURCE_TABLE
1800: ,INTERFACE_ID
1806: ,HEADER_INTERFACE_ID
1807: ,'OKS_IMP_HDR_INVALID_QAC'
1808: ,NULL)
1809: WHEN (AP_V = 'N') THEN
1810: INTO OKS_INT_ERROR_STG_TEMP
1811: (CONCURRENT_REQUEST_ID
1812: ,HEADER_INTERFACE_ROWID
1813: ,INTERFACE_SOURCE_TABLE
1814: ,INTERFACE_ID
1820: ,HEADER_INTERFACE_ID
1821: ,'OKS_IMP_HDR_INVALID_AP'
1822: ,NULL)
1823: WHEN (SALESGROUP_NULL_ERROR = 'Y') THEN
1824: INTO OKS_INT_ERROR_STG_TEMP
1825: (CONCURRENT_REQUEST_ID
1826: ,HEADER_INTERFACE_ROWID
1827: ,INTERFACE_SOURCE_TABLE
1828: ,INTERFACE_ID
1915: l_stmt_num := 40;
1916:
1917: INSERT ALL
1918: WHEN (TEC_V = 'N') THEN
1919: INTO OKS_INT_ERROR_STG_TEMP
1920: (CONCURRENT_REQUEST_ID
1921: ,HEADER_INTERFACE_ROWID
1922: ,INTERFACE_SOURCE_TABLE
1923: ,INTERFACE_ID
1929: ,HEADER_INTERFACE_ID
1930: ,'OKS_IMP_HDR_INVALID_TEC'
1931: ,NULL)
1932: WHEN (TUCEF_OU_V = 'N') THEN
1933: INTO OKS_INT_ERROR_STG_TEMP
1934: (CONCURRENT_REQUEST_ID
1935: ,HEADER_INTERFACE_ROWID
1936: ,INTERFACE_SOURCE_TABLE
1937: ,INTERFACE_ID
1943: ,HEADER_INTERFACE_ID
1944: ,'OKS_IMP_HDR_INVALID_TUCEF_OU'
1945: ,NULL)
1946: WHEN (TEN_V = 'N') THEN
1947: INTO OKS_INT_ERROR_STG_TEMP
1948: (CONCURRENT_REQUEST_ID
1949: ,HEADER_INTERFACE_ROWID
1950: ,INTERFACE_SOURCE_TABLE
1951: ,INTERFACE_ID
1957: ,HEADER_INTERFACE_ID
1958: ,'OKS_IMP_HDR_INVALID_TEN'
1959: ,NULL)
1960: WHEN (TEN_NULL_ERROR = 'Y') THEN
1961: INTO OKS_INT_ERROR_STG_TEMP
1962: (CONCURRENT_REQUEST_ID
1963: ,HEADER_INTERFACE_ROWID
1964: ,INTERFACE_SOURCE_TABLE
1965: ,INTERFACE_ID
1971: ,HEADER_INTERFACE_ID
1972: ,'OKS_IMP_HDR_NULL_TEN'
1973: ,NULL)
1974: WHEN (POREQ_V = 'N') THEN
1975: INTO OKS_INT_ERROR_STG_TEMP
1976: (CONCURRENT_REQUEST_ID
1977: ,HEADER_INTERFACE_ROWID
1978: ,INTERFACE_SOURCE_TABLE
1979: ,INTERFACE_ID
1985: ,HEADER_INTERFACE_ID
1986: ,'OKS_IMP_HDR_INVALID_POREQ'
1987: ,NULL)
1988: WHEN (POREQ_NULL_ERROR = 'Y') THEN
1989: INTO OKS_INT_ERROR_STG_TEMP
1990: (CONCURRENT_REQUEST_ID
1991: ,HEADER_INTERFACE_ROWID
1992: ,INTERFACE_SOURCE_TABLE
1993: ,INTERFACE_ID
1999: ,HEADER_INTERFACE_ID
2000: ,'OKS_IMP_HDR_NULL_POREQ'
2001: ,NULL)
2002: WHEN (BS_V = 'N') THEN
2003: INTO OKS_INT_ERROR_STG_TEMP
2004: (CONCURRENT_REQUEST_ID
2005: ,HEADER_INTERFACE_ROWID
2006: ,INTERFACE_SOURCE_TABLE
2007: ,INTERFACE_ID
2013: ,HEADER_INTERFACE_ID
2014: ,'OKS_IMP_HDR_INVALID_BS'
2015: ,NULL)
2016: WHEN (BTXNTYPE_V = 'N') THEN
2017: INTO OKS_INT_ERROR_STG_TEMP
2018: (CONCURRENT_REQUEST_ID
2019: ,HEADER_INTERFACE_ROWID
2020: ,INTERFACE_SOURCE_TABLE
2021: ,INTERFACE_ID
2027: ,HEADER_INTERFACE_ID
2028: ,'OKS_IMP_HDR_INVALID_BTXNTYPE'
2029: ,NULL)
2030: WHEN (HC_V = 'N') THEN
2031: INTO OKS_INT_ERROR_STG_TEMP
2032: (CONCURRENT_REQUEST_ID
2033: ,HEADER_INTERFACE_ROWID
2034: ,INTERFACE_SOURCE_TABLE
2035: ,INTERFACE_ID
2041: ,HEADER_INTERFACE_ID
2042: ,'OKS_IMP_HDR_INVALID_HC'
2043: ,NULL)
2044: WHEN (SP_V = 'N') THEN
2045: INTO OKS_INT_ERROR_STG_TEMP
2046: (CONCURRENT_REQUEST_ID
2047: ,HEADER_INTERFACE_ROWID
2048: ,INTERFACE_SOURCE_TABLE
2049: ,INTERFACE_ID
2055: ,HEADER_INTERFACE_ID
2056: ,'OKS_IMP_HDR_INVALID_SP'
2057: ,NULL)
2058: WHEN (ST_V = 'N') THEN
2059: INTO OKS_INT_ERROR_STG_TEMP
2060: (CONCURRENT_REQUEST_ID
2061: ,HEADER_INTERFACE_ROWID
2062: ,INTERFACE_SOURCE_TABLE
2063: ,INTERFACE_ID
2069: ,HEADER_INTERFACE_ID
2070: ,'OKS_IMP_HDR_INVALID_ST'
2071: ,NULL)
2072: WHEN (SER_CHRG_PREP_REQ_V = 'N') THEN
2073: INTO OKS_INT_ERROR_STG_TEMP
2074: (CONCURRENT_REQUEST_ID
2075: ,HEADER_INTERFACE_ROWID
2076: ,INTERFACE_SOURCE_TABLE
2077: ,INTERFACE_ID
2083: ,HEADER_INTERFACE_ID
2084: ,'OKS_IMP_HDR_INVALID_SCPREQ'
2085: ,NULL)
2086: WHEN (SER_CHRG_PO_REQ_V = 'N') THEN
2087: INTO OKS_INT_ERROR_STG_TEMP
2088: (CONCURRENT_REQUEST_ID
2089: ,HEADER_INTERFACE_ROWID
2090: ,INTERFACE_SOURCE_TABLE
2091: ,INTERFACE_ID
2097: ,HEADER_INTERFACE_ID
2098: ,'OKS_IMP_HDR_INVALID_SCPOREQ'
2099: ,NULL)
2100: WHEN (SOURCE_V = 'N') THEN
2101: INTO OKS_INT_ERROR_STG_TEMP
2102: (CONCURRENT_REQUEST_ID
2103: ,HEADER_INTERFACE_ROWID
2104: ,INTERFACE_SOURCE_TABLE
2105: ,INTERFACE_ID
2111: ,HEADER_INTERFACE_ID
2112: ,'OKS_IMP_HDR_INVALID_SOURCE'
2113: ,NULL)
2114: WHEN (HOI_COUNT = 0) THEN
2115: INTO OKS_INT_ERROR_STG_TEMP
2116: (CONCURRENT_REQUEST_ID
2117: ,HEADER_INTERFACE_ROWID
2118: ,INTERFACE_SOURCE_TABLE
2119: ,INTERFACE_ID
2125: ,HEADER_INTERFACE_ID
2126: ,'OKS_IMP_HST_INVALID_INVORG'
2127: ,NULL)
2128: WHEN (ERC_NULL_ERROR = 'Y') THEN
2129: INTO OKS_INT_ERROR_STG_TEMP
2130: (CONCURRENT_REQUEST_ID
2131: ,HEADER_INTERFACE_ROWID
2132: ,INTERFACE_SOURCE_TABLE
2133: ,INTERFACE_ID
2354: ,AVERAGING_INTERVAL
2355: ,SETTLEMENT_INTERVAL
2356: ,USAGE_TERMINATION_METHOD)
2357: WHEN (LSE_ID IS NULL) THEN
2358: INTO OKS_INT_ERROR_STG_TEMP
2359: (CONCURRENT_REQUEST_ID
2360: ,HEADER_INTERFACE_ROWID
2361: ,INTERFACE_SOURCE_TABLE
2362: ,INTERFACE_ID
2368: ,LINE_INTERFACE_ID
2369: ,'OKS_IMP_LIN_INVALID_LTYPE'
2370: ,NULL)
2371: WHEN (ITEM_ID IS NULL) THEN
2372: INTO OKS_INT_ERROR_STG_TEMP
2373: (CONCURRENT_REQUEST_ID
2374: ,HEADER_INTERFACE_ROWID
2375: ,INTERFACE_SOURCE_TABLE
2376: ,INTERFACE_ID
2382: ,LINE_INTERFACE_ID
2383: ,'OKS_IMP_LIN_INVALID_ITEM'
2384: ,NULL)
2385: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN
2386: INTO OKS_INT_ERROR_STG_TEMP
2387: (CONCURRENT_REQUEST_ID
2388: ,HEADER_INTERFACE_ROWID
2389: ,INTERFACE_SOURCE_TABLE
2390: ,INTERFACE_ID
2396: ,LINE_INTERFACE_ID
2397: ,'OKS_IMP_LIN_INVALID_BTSU'
2398: ,NULL)
2399: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN
2400: INTO OKS_INT_ERROR_STG_TEMP
2401: (CONCURRENT_REQUEST_ID
2402: ,HEADER_INTERFACE_ROWID
2403: ,INTERFACE_SOURCE_TABLE
2404: ,INTERFACE_ID
2410: ,LINE_INTERFACE_ID
2411: ,'OKS_IMP_LIN_INVALID_STSU'
2412: ,NULL)
2413: WHEN (LINE_TYPE IN ('SERVICE', 'EXT_WARRANTY') AND INVOICE_TEXT IS NULL) THEN
2414: INTO OKS_INT_ERROR_STG_TEMP
2415: (CONCURRENT_REQUEST_ID
2416: ,HEADER_INTERFACE_ROWID
2417: ,INTERFACE_SOURCE_TABLE
2418: ,INTERFACE_ID
2425: ,'OKS_IMP_LIN_INVALID_INVTXT'
2426: ,NULL)
2427: WHEN (LINE_TYPE IN ('SERVICE', 'EXT_WARRANTY') AND CUSTOMER_BILLING_CONTACT_ID IS NULL)
2428: OR (BILLING_CONTACT_PROVIDED = 'Y' AND CUSTOMER_BILLING_CONTACT_ID IS NULL) THEN
2429: INTO OKS_INT_ERROR_STG_TEMP
2430: (CONCURRENT_REQUEST_ID
2431: ,HEADER_INTERFACE_ROWID
2432: ,INTERFACE_SOURCE_TABLE
2433: ,INTERFACE_ID
2440: ,'OKS_IMP_LIN_INVALID_BC'
2441: ,NULL)
2442: WHEN (LINE_TYPE IN ('SERVICE', 'EXT_WARRANTY') AND CUSTOMER_SHIPPING_CONTACT_ID IS NULL)
2443: OR (SHIPPING_CONTACT_PROVIDED = 'Y' AND CUSTOMER_SHIPPING_CONTACT_ID IS NULL) THEN
2444: INTO OKS_INT_ERROR_STG_TEMP
2445: (CONCURRENT_REQUEST_ID
2446: ,HEADER_INTERFACE_ROWID
2447: ,INTERFACE_SOURCE_TABLE
2448: ,INTERFACE_ID
2454: ,LINE_INTERFACE_ID
2455: ,'OKS_IMP_LIN_INVALID_SC'
2456: ,NULL)
2457: WHEN (PL_PROVIDED = 'Y' AND PRICE_LIST_ID IS NULL) THEN
2458: INTO OKS_INT_ERROR_STG_TEMP
2459: (CONCURRENT_REQUEST_ID
2460: ,HEADER_INTERFACE_ROWID
2461: ,INTERFACE_SOURCE_TABLE
2462: ,INTERFACE_ID
2468: ,LINE_INTERFACE_ID
2469: ,'OKS_IMP_LIN_INVALID_QP'
2470: ,NULL)
2471: WHEN (LIN_PAYMENT_INSTRUCTION IS NOT NULL AND PAYMENT_INSTRUCTION IS NULL) THEN
2472: INTO OKS_INT_ERROR_STG_TEMP
2473: (CONCURRENT_REQUEST_ID
2474: ,HEADER_INTERFACE_ROWID
2475: ,INTERFACE_SOURCE_TABLE
2476: ,INTERFACE_ID
2482: ,LINE_INTERFACE_ID
2483: ,'OKS_IMP_LIN_INVALID_PAY_INST'
2484: ,NULL)
2485: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN
2486: INTO OKS_INT_ERROR_STG_TEMP
2487: (CONCURRENT_REQUEST_ID
2488: ,HEADER_INTERFACE_ROWID
2489: ,INTERFACE_SOURCE_TABLE
2490: ,INTERFACE_ID
2496: ,LINE_INTERFACE_ID
2497: ,'OKS_IMP_LIN_INVALID_AR'
2498: ,NULL)
2499: WHEN (INVOICING_RULE_ID IS NULL) THEN
2500: INTO OKS_INT_ERROR_STG_TEMP
2501: (CONCURRENT_REQUEST_ID
2502: ,HEADER_INTERFACE_ROWID
2503: ,INTERFACE_SOURCE_TABLE
2504: ,INTERFACE_ID
2510: ,LINE_INTERFACE_ID
2511: ,'OKS_IMP_LIN_INVALID_IR'
2512: ,NULL)
2513: WHEN (LIN_PAYMENT_METHOD_CODE IS NOT NULL AND PAYMENT_METHOD_CODE IS NULL) THEN
2514: INTO OKS_INT_ERROR_STG_TEMP
2515: (CONCURRENT_REQUEST_ID
2516: ,HEADER_INTERFACE_ROWID
2517: ,INTERFACE_SOURCE_TABLE
2518: ,INTERFACE_ID
2524: ,LINE_INTERFACE_ID
2525: ,'OKS_IMP_LIN_INVALID_PMC'
2526: ,NULL)
2527: WHEN ((PAYMENT_METHOD_CODE IS NOT NULL OR LIN_COMMITMENT_ID IS NOT NULL) AND COMMITMENT_ID IS NULL) THEN
2528: INTO OKS_INT_ERROR_STG_TEMP
2529: (CONCURRENT_REQUEST_ID
2530: ,HEADER_INTERFACE_ROWID
2531: ,INTERFACE_SOURCE_TABLE
2532: ,INTERFACE_ID
2538: ,LINE_INTERFACE_ID
2539: ,'OKS_IMP_LIN_INVALID_CN'
2540: ,NULL)
2541: WHEN (LINE_TYPE = 'SUBSCRIPTION' AND (TAX_AMOUNT IS NULL OR TAX_AMOUNT < 0 )) THEN
2542: INTO OKS_INT_ERROR_STG_TEMP
2543: (CONCURRENT_REQUEST_ID
2544: ,HEADER_INTERFACE_ROWID
2545: ,INTERFACE_SOURCE_TABLE
2546: ,INTERFACE_ID
2552: ,LINE_INTERFACE_ID
2553: ,'OKS_IMP_LIN_INVALID_TAX'
2554: ,NULL)
2555: WHEN (LINE_TYPE = 'SUBSCRIPTION' AND (SUBTOTAL IS NULL OR SUBTOTAL < 0 )) THEN
2556: INTO OKS_INT_ERROR_STG_TEMP
2557: (CONCURRENT_REQUEST_ID
2558: ,HEADER_INTERFACE_ROWID
2559: ,INTERFACE_SOURCE_TABLE
2560: ,INTERFACE_ID
2871: l_stmt_num := 20;
2872:
2873: INSERT ALL
2874: WHEN (LINE_NUMBER_V = 'N') THEN
2875: INTO OKS_INT_ERROR_STG_TEMP
2876: (CONCURRENT_REQUEST_ID
2877: ,HEADER_INTERFACE_ROWID
2878: ,INTERFACE_SOURCE_TABLE
2879: ,INTERFACE_ID
2885: ,LINE_INTERFACE_ID
2886: ,'OKS_IMP_LIN_INVALID_LINENUM'
2887: ,NULL)
2888: WHEN (HOI_COUNT = 0) THEN
2889: INTO OKS_INT_ERROR_STG_TEMP
2890: (CONCURRENT_REQUEST_ID
2891: ,HEADER_INTERFACE_ROWID
2892: ,INTERFACE_SOURCE_TABLE
2893: ,INTERFACE_ID
2899: ,LINE_INTERFACE_ID
2900: ,'OKS_IMP_LIN_INVALID_ITMORG'
2901: ,NULL)
2902: WHEN (COVTEM_V = 'N') THEN
2903: INTO OKS_INT_ERROR_STG_TEMP
2904: (CONCURRENT_REQUEST_ID
2905: ,HEADER_INTERFACE_ROWID
2906: ,INTERFACE_SOURCE_TABLE
2907: ,INTERFACE_ID
2913: ,LINE_INTERFACE_ID
2914: ,'OKS_IMP_LIN_INVALID_COVTEM'
2915: ,NULL)
2916: WHEN (STATUS_VALID = 'N') THEN
2917: INTO OKS_INT_ERROR_STG_TEMP
2918: (CONCURRENT_REQUEST_ID
2919: ,HEADER_INTERFACE_ROWID
2920: ,INTERFACE_SOURCE_TABLE
2921: ,INTERFACE_ID
2927: ,LINE_INTERFACE_ID
2928: ,'OKS_IMP_LIN_INVALID_STS'
2929: ,NULL)
2930: WHEN (STATUS_X_DATE_VALID = 'N') THEN
2931: INTO OKS_INT_ERROR_STG_TEMP
2932: (CONCURRENT_REQUEST_ID
2933: ,HEADER_INTERFACE_ROWID
2934: ,INTERFACE_SOURCE_TABLE
2935: ,INTERFACE_ID
2941: ,LINE_INTERFACE_ID
2942: ,'OKS_IMP_LIN_INVALID_STSXDATE'
2943: ,NULL)
2944: WHEN (STS_X_HDRSTS = 'N') THEN
2945: INTO OKS_INT_ERROR_STG_TEMP
2946: (CONCURRENT_REQUEST_ID
2947: ,HEADER_INTERFACE_ROWID
2948: ,INTERFACE_SOURCE_TABLE
2949: ,INTERFACE_ID
2955: ,LINE_INTERFACE_ID
2956: ,'OKS_IMP_LIN_INVALID_STSXHDR'
2957: ,NULL)
2958: WHEN (DATE_VALID = 'N') THEN
2959: INTO OKS_INT_ERROR_STG_TEMP
2960: (CONCURRENT_REQUEST_ID
2961: ,HEADER_INTERFACE_ROWID
2962: ,INTERFACE_SOURCE_TABLE
2963: ,INTERFACE_ID
2969: ,LINE_INTERFACE_ID
2970: ,'OKS_IMP_LIN_INVALID_DATE'
2971: ,NULL)
2972: WHEN (DATE_CANCELED_VALID = 'N') THEN
2973: INTO OKS_INT_ERROR_STG_TEMP
2974: (CONCURRENT_REQUEST_ID
2975: ,HEADER_INTERFACE_ROWID
2976: ,INTERFACE_SOURCE_TABLE
2977: ,INTERFACE_ID
2983: ,LINE_INTERFACE_ID
2984: ,'OKS_IMP_LIN_INVALID_DATECAN'
2985: ,NULL)
2986: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN
2987: INTO OKS_INT_ERROR_STG_TEMP
2988: (CONCURRENT_REQUEST_ID
2989: ,HEADER_INTERFACE_ROWID
2990: ,INTERFACE_SOURCE_TABLE
2991: ,INTERFACE_ID
2997: ,LINE_INTERFACE_ID
2998: ,'OKS_IMP_LIN_NULL_DATECAN'
2999: ,NULL)
3000: WHEN (CR_VALID = 'N') THEN
3001: INTO OKS_INT_ERROR_STG_TEMP
3002: (CONCURRENT_REQUEST_ID
3003: ,HEADER_INTERFACE_ROWID
3004: ,INTERFACE_SOURCE_TABLE
3005: ,INTERFACE_ID
3011: ,LINE_INTERFACE_ID
3012: ,'OKS_IMP_LIN_INVALID_CR'
3013: ,NULL)
3014: WHEN (CR_NULL_ERROR = 'Y') THEN
3015: INTO OKS_INT_ERROR_STG_TEMP
3016: (CONCURRENT_REQUEST_ID
3017: ,HEADER_INTERFACE_ROWID
3018: ,INTERFACE_SOURCE_TABLE
3019: ,INTERFACE_ID
3025: ,LINE_INTERFACE_ID
3026: ,'OKS_IMP_LIN_NULL_CR'
3027: ,NULL)
3028: WHEN (TEC_V = 'N') THEN
3029: INTO OKS_INT_ERROR_STG_TEMP
3030: (CONCURRENT_REQUEST_ID
3031: ,HEADER_INTERFACE_ROWID
3032: ,INTERFACE_SOURCE_TABLE
3033: ,INTERFACE_ID
3039: ,LINE_INTERFACE_ID
3040: ,'OKS_IMP_LIN_INVALID_TEC'
3041: ,NULL)
3042: WHEN (TUCEF_OU_V = 'N') THEN
3043: INTO OKS_INT_ERROR_STG_TEMP
3044: (CONCURRENT_REQUEST_ID
3045: ,HEADER_INTERFACE_ROWID
3046: ,INTERFACE_SOURCE_TABLE
3047: ,INTERFACE_ID
3053: ,LINE_INTERFACE_ID
3054: ,'OKS_IMP_LIN_INVALID_TUCEF_OU'
3055: ,NULL)
3056: WHEN (TEN_V = 'N') THEN
3057: INTO OKS_INT_ERROR_STG_TEMP
3058: (CONCURRENT_REQUEST_ID
3059: ,HEADER_INTERFACE_ROWID
3060: ,INTERFACE_SOURCE_TABLE
3061: ,INTERFACE_ID
3067: ,LINE_INTERFACE_ID
3068: ,'OKS_IMP_LIN_INVALID_TEN'
3069: ,NULL)
3070: WHEN (TEN_NULL_ERROR = 'Y') THEN
3071: INTO OKS_INT_ERROR_STG_TEMP
3072: (CONCURRENT_REQUEST_ID
3073: ,HEADER_INTERFACE_ROWID
3074: ,INTERFACE_SOURCE_TABLE
3075: ,INTERFACE_ID
3081: ,LINE_INTERFACE_ID
3082: ,'OKS_IMP_LIN_NULL_TEN'
3083: ,NULL)
3084: WHEN (ERC_NULL_ERROR = 'Y') THEN
3085: INTO OKS_INT_ERROR_STG_TEMP
3086: (CONCURRENT_REQUEST_ID
3087: ,HEADER_INTERFACE_ROWID
3088: ,INTERFACE_SOURCE_TABLE
3089: ,INTERFACE_ID
3095: ,LINE_INTERFACE_ID
3096: ,'OKS_IMP_LIN_NULL_ERC'
3097: ,NULL)
3098: WHEN (TCC_VALID = 'N') THEN
3099: INTO OKS_INT_ERROR_STG_TEMP
3100: (CONCURRENT_REQUEST_ID
3101: ,HEADER_INTERFACE_ROWID
3102: ,INTERFACE_SOURCE_TABLE
3103: ,INTERFACE_ID
3109: ,LINE_INTERFACE_ID
3110: ,'OKS_IMP_LIN_INVALID_TCC'
3111: ,NULL)
3112: WHEN (REN_TYPE_VALID = 'N') THEN
3113: INTO OKS_INT_ERROR_STG_TEMP
3114: (CONCURRENT_REQUEST_ID
3115: ,HEADER_INTERFACE_ROWID
3116: ,INTERFACE_SOURCE_TABLE
3117: ,INTERFACE_ID
3123: ,LINE_INTERFACE_ID
3124: ,'OKS_IMP_LIN_INVALID_RENTYPE'
3125: ,NULL)
3126: WHEN (PRINT_INVOICE_V = 'N') THEN
3127: INTO OKS_INT_ERROR_STG_TEMP
3128: (CONCURRENT_REQUEST_ID
3129: ,HEADER_INTERFACE_ROWID
3130: ,INTERFACE_SOURCE_TABLE
3131: ,INTERFACE_ID
3137: ,LINE_INTERFACE_ID
3138: ,'OKS_IMP_LIN_INVALID_PRNTINV'
3139: ,NULL)
3140: WHEN (POREQ_V = 'N') THEN
3141: INTO OKS_INT_ERROR_STG_TEMP
3142: (CONCURRENT_REQUEST_ID
3143: ,HEADER_INTERFACE_ROWID
3144: ,INTERFACE_SOURCE_TABLE
3145: ,INTERFACE_ID
3151: ,LINE_INTERFACE_ID
3152: ,'OKS_IMP_LIN_INVALID_POREQ'
3153: ,NULL)
3154: WHEN (POREQ_NULL_ERROR = 'Y') THEN
3155: INTO OKS_INT_ERROR_STG_TEMP
3156: (CONCURRENT_REQUEST_ID
3157: ,HEADER_INTERFACE_ROWID
3158: ,INTERFACE_SOURCE_TABLE
3159: ,INTERFACE_ID
3165: ,LINE_INTERFACE_ID
3166: ,'OKS_IMP_LIN_NULL_POREQ'
3167: ,NULL)
3168: WHEN (TANGIBLE_SUB = 'Y') THEN
3169: INTO OKS_INT_ERROR_STG_TEMP
3170: (CONCURRENT_REQUEST_ID
3171: ,HEADER_INTERFACE_ROWID
3172: ,INTERFACE_SOURCE_TABLE
3173: ,INTERFACE_ID
3293: l_stmt_num := 30;
3294:
3295: INSERT ALL
3296: WHEN (BILL_INT_DUR_V = 'N') THEN
3297: INTO OKS_INT_ERROR_STG_TEMP
3298: (CONCURRENT_REQUEST_ID
3299: ,HEADER_INTERFACE_ROWID
3300: ,INTERFACE_SOURCE_TABLE
3301: ,INTERFACE_ID
3307: ,LINE_INTERFACE_ID
3308: ,'OKS_IMP_LIN_INVALID_BID'
3309: ,NULL)
3310: WHEN (REC_BILL_OCC_V = 'N') THEN
3311: INTO OKS_INT_ERROR_STG_TEMP
3312: (CONCURRENT_REQUEST_ID
3313: ,HEADER_INTERFACE_ROWID
3314: ,INTERFACE_SOURCE_TABLE
3315: ,INTERFACE_ID
3321: ,LINE_INTERFACE_ID
3322: ,'OKS_IMP_LIN_INVALID_RBO'
3323: ,NULL)
3324: WHEN (BILL_INT_DUR_NULL_ERROR = 'Y') THEN
3325: INTO OKS_INT_ERROR_STG_TEMP
3326: (CONCURRENT_REQUEST_ID
3327: ,HEADER_INTERFACE_ROWID
3328: ,INTERFACE_SOURCE_TABLE
3329: ,INTERFACE_ID
3335: ,LINE_INTERFACE_ID
3336: ,'OKS_IMP_LIN_NULL_BID'
3337: ,NULL)
3338: WHEN (BILL_INT_PERIOD_V = 'N') THEN
3339: INTO OKS_INT_ERROR_STG_TEMP
3340: (CONCURRENT_REQUEST_ID
3341: ,HEADER_INTERFACE_ROWID
3342: ,INTERFACE_SOURCE_TABLE
3343: ,INTERFACE_ID
3349: ,LINE_INTERFACE_ID
3350: ,'OKS_IMP_LIN_INVALID_BIP'
3351: ,NULL)
3352: WHEN (FIRST_BILL_V = 'N') THEN
3353: INTO OKS_INT_ERROR_STG_TEMP
3354: (CONCURRENT_REQUEST_ID
3355: ,HEADER_INTERFACE_ROWID
3356: ,INTERFACE_SOURCE_TABLE
3357: ,INTERFACE_ID
3363: ,LINE_INTERFACE_ID
3364: ,'OKS_IMP_LIN_INVALID_FBILL'
3365: ,NULL)
3366: WHEN (SUBQTY_V = 'N') THEN
3367: INTO OKS_INT_ERROR_STG_TEMP
3368: (CONCURRENT_REQUEST_ID
3369: ,HEADER_INTERFACE_ROWID
3370: ,INTERFACE_SOURCE_TABLE
3371: ,INTERFACE_ID
3377: ,LINE_INTERFACE_ID
3378: ,'OKS_IMP_LIN_INVALID_SQTY'
3379: ,NULL)
3380: WHEN (SUOM_VALID = 'N') THEN
3381: INTO OKS_INT_ERROR_STG_TEMP
3382: (CONCURRENT_REQUEST_ID
3383: ,HEADER_INTERFACE_ROWID
3384: ,INTERFACE_SOURCE_TABLE
3385: ,INTERFACE_ID
3391: ,LINE_INTERFACE_ID
3392: ,'OKS_IMP_LIN_INVALID_SUOM'
3393: ,NULL)
3394: WHEN (SUB_NULL_ERROR = 'Y') THEN
3395: INTO OKS_INT_ERROR_STG_TEMP
3396: (CONCURRENT_REQUEST_ID
3397: ,HEADER_INTERFACE_ROWID
3398: ,INTERFACE_SOURCE_TABLE
3399: ,INTERFACE_ID
3405: ,LINE_INTERFACE_ID
3406: ,'OKS_IMP_LIN_NULL_SUB'
3407: ,NULL)
3408: WHEN (PRICE_UOM_V = 'N') THEN
3409: INTO OKS_INT_ERROR_STG_TEMP
3410: (CONCURRENT_REQUEST_ID
3411: ,HEADER_INTERFACE_ROWID
3412: ,INTERFACE_SOURCE_TABLE
3413: ,INTERFACE_ID
3419: ,LINE_INTERFACE_ID
3420: ,'OKS_IMP_LIN_INVALID_PUOM'
3421: ,NULL)
3422: WHEN (USG_TYPE_V = 'N') THEN
3423: INTO OKS_INT_ERROR_STG_TEMP
3424: (CONCURRENT_REQUEST_ID
3425: ,HEADER_INTERFACE_ROWID
3426: ,INTERFACE_SOURCE_TABLE
3427: ,INTERFACE_ID
3433: ,LINE_INTERFACE_ID
3434: ,'OKS_IMP_LIN_INVALID_USGTYPE'
3435: ,NULL)
3436: WHEN (USG_TYPE_NULL_ERROR = 'Y') THEN
3437: INTO OKS_INT_ERROR_STG_TEMP
3438: (CONCURRENT_REQUEST_ID
3439: ,HEADER_INTERFACE_ROWID
3440: ,INTERFACE_SOURCE_TABLE
3441: ,INTERFACE_ID
3447: ,LINE_INTERFACE_ID
3448: ,'OKS_IMP_LIN_NULL_USGTYPE'
3449: ,NULL)
3450: WHEN (USG_PER_V = 'N') THEN
3451: INTO OKS_INT_ERROR_STG_TEMP
3452: (CONCURRENT_REQUEST_ID
3453: ,HEADER_INTERFACE_ROWID
3454: ,INTERFACE_SOURCE_TABLE
3455: ,INTERFACE_ID
3461: ,LINE_INTERFACE_ID
3462: ,'OKS_IMP_LIN_INVALID_USGPER'
3463: ,NULL)
3464: WHEN (USG_PER_NULL_ERROR = 'Y') THEN
3465: INTO OKS_INT_ERROR_STG_TEMP
3466: (CONCURRENT_REQUEST_ID
3467: ,HEADER_INTERFACE_ROWID
3468: ,INTERFACE_SOURCE_TABLE
3469: ,INTERFACE_ID
3475: ,LINE_INTERFACE_ID
3476: ,'OKS_IMP_LIN_NULL_USGPER'
3477: ,NULL)
3478: WHEN (AVG_INT_V = 'N') THEN
3479: INTO OKS_INT_ERROR_STG_TEMP
3480: (CONCURRENT_REQUEST_ID
3481: ,HEADER_INTERFACE_ROWID
3482: ,INTERFACE_SOURCE_TABLE
3483: ,INTERFACE_ID
3489: ,LINE_INTERFACE_ID
3490: ,'OKS_IMP_LIN_INVALID_AVGINT'
3491: ,NULL)
3492: WHEN (AVG_INT_NULL_ERROR = 'Y') THEN
3493: INTO OKS_INT_ERROR_STG_TEMP
3494: (CONCURRENT_REQUEST_ID
3495: ,HEADER_INTERFACE_ROWID
3496: ,INTERFACE_SOURCE_TABLE
3497: ,INTERFACE_ID
3503: ,LINE_INTERFACE_ID
3504: ,'OKS_IMP_LIN_NULL_AVGINT'
3505: ,NULL)
3506: WHEN (STM_INT_V = 'N') THEN
3507: INTO OKS_INT_ERROR_STG_TEMP
3508: (CONCURRENT_REQUEST_ID
3509: ,HEADER_INTERFACE_ROWID
3510: ,INTERFACE_SOURCE_TABLE
3511: ,INTERFACE_ID
3517: ,LINE_INTERFACE_ID
3518: ,'OKS_IMP_LIN_INVALID_STMINT'
3519: ,NULL)
3520: WHEN (STM_INT_NULL_ERROR = 'Y') THEN
3521: INTO OKS_INT_ERROR_STG_TEMP
3522: (CONCURRENT_REQUEST_ID
3523: ,HEADER_INTERFACE_ROWID
3524: ,INTERFACE_SOURCE_TABLE
3525: ,INTERFACE_ID
3531: ,LINE_INTERFACE_ID
3532: ,'OKS_IMP_LIN_NULL_STMINT'
3533: ,NULL)
3534: WHEN (UTM_V = 'N') THEN
3535: INTO OKS_INT_ERROR_STG_TEMP
3536: (CONCURRENT_REQUEST_ID
3537: ,HEADER_INTERFACE_ROWID
3538: ,INTERFACE_SOURCE_TABLE
3539: ,INTERFACE_ID
3545: ,LINE_INTERFACE_ID
3546: ,'OKS_IMP_LIN_INVALID_UTM'
3547: ,NULL)
3548: WHEN (UTM_NULL_ERROR = 'Y') THEN
3549: INTO OKS_INT_ERROR_STG_TEMP
3550: (CONCURRENT_REQUEST_ID
3551: ,HEADER_INTERFACE_ROWID
3552: ,INTERFACE_SOURCE_TABLE
3553: ,INTERFACE_ID
3559: ,LINE_INTERFACE_ID
3560: ,'OKS_IMP_LIN_NULL_UTM'
3561: ,NULL)
3562: WHEN (FIRST_BILLED_AMT_V = 'N') THEN
3563: INTO OKS_INT_ERROR_STG_TEMP
3564: (CONCURRENT_REQUEST_ID
3565: ,HEADER_INTERFACE_ROWID
3566: ,INTERFACE_SOURCE_TABLE
3567: ,INTERFACE_ID
3573: ,LINE_INTERFACE_ID
3574: ,'OKS_IMP_LIN_INVALID_FBA'
3575: ,NULL)
3576: WHEN (FIRST_BILLED_DATE_V = 'N') THEN
3577: INTO OKS_INT_ERROR_STG_TEMP
3578: (CONCURRENT_REQUEST_ID
3579: ,HEADER_INTERFACE_ROWID
3580: ,INTERFACE_SOURCE_TABLE
3581: ,INTERFACE_ID
3587: ,LINE_INTERFACE_ID
3588: ,'OKS_IMP_LIN_INVALID_FBD'
3589: ,NULL)
3590: WHEN (LAST_BILLED_AMT_V = 'N') THEN
3591: INTO OKS_INT_ERROR_STG_TEMP
3592: (CONCURRENT_REQUEST_ID
3593: ,HEADER_INTERFACE_ROWID
3594: ,INTERFACE_SOURCE_TABLE
3595: ,INTERFACE_ID
3601: ,LINE_INTERFACE_ID
3602: ,'OKS_IMP_LIN_INVALID_LBA'
3603: ,NULL)
3604: WHEN (LAST_BILL_DATE_V = 'N') THEN
3605: INTO OKS_INT_ERROR_STG_TEMP
3606: (CONCURRENT_REQUEST_ID
3607: ,HEADER_INTERFACE_ROWID
3608: ,INTERFACE_SOURCE_TABLE
3609: ,INTERFACE_ID
4093: ,COVERED_SITE_ID
4094: ,COVERED_PARTY_ID
4095: ,COVERED_SYSTEM_ID)
4096: WHEN (COV_LINE_INTERFACE_ID IS NOT NULL AND LINE_INTERFACE_ID IS NULL ) THEN
4097: INTO OKS_INT_ERROR_STG_TEMP
4098: (CONCURRENT_REQUEST_ID
4099: ,HEADER_INTERFACE_ROWID
4100: ,INTERFACE_SOURCE_TABLE
4101: ,INTERFACE_ID
4107: ,COVERED_LEVEL_INTERFACE_ID
4108: ,'OKS_IMP_CLVL_INVALID_LINTID'
4109: ,NULL )
4110: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN
4111: INTO OKS_INT_ERROR_STG_TEMP
4112: (CONCURRENT_REQUEST_ID
4113: ,HEADER_INTERFACE_ROWID
4114: ,INTERFACE_SOURCE_TABLE
4115: ,INTERFACE_ID
4121: ,COVERED_LEVEL_INTERFACE_ID
4122: ,'OKS_IMP_CLVL_INVALID_LINNUM'
4123: ,NULL)
4124: WHEN ( STATUS_CODE IS NULL OR STATUS_CLVL_VALID ='N' OR STATUS_LINLVL_VALID='N') THEN
4125: INTO OKS_INT_ERROR_STG_TEMP
4126: (CONCURRENT_REQUEST_ID
4127: ,HEADER_INTERFACE_ROWID
4128: ,INTERFACE_SOURCE_TABLE
4129: ,INTERFACE_ID
4135: ,COVERED_LEVEL_INTERFACE_ID
4136: ,'OKS_IMP_CLVL_INVALID_STSCODE'
4137: ,NULL)
4138: WHEN (DATE_CLVL_VALID ='N' OR DATE_LINLVL_VALID='N') THEN
4139: INTO OKS_INT_ERROR_STG_TEMP
4140: (CONCURRENT_REQUEST_ID
4141: ,HEADER_INTERFACE_ROWID
4142: ,INTERFACE_SOURCE_TABLE
4143: ,INTERFACE_ID
4149: ,COVERED_LEVEL_INTERFACE_ID
4150: ,'OKS_IMP_CLVL_INVALID_DTRANGE'
4151: ,NULL)
4152: WHEN (DATE_CLVL_STS_VALID ='N' ) THEN
4153: INTO OKS_INT_ERROR_STG_TEMP
4154: (CONCURRENT_REQUEST_ID
4155: ,HEADER_INTERFACE_ROWID
4156: ,INTERFACE_SOURCE_TABLE
4157: ,INTERFACE_ID
4163: ,COVERED_LEVEL_INTERFACE_ID
4164: ,'OKS_IMP_CLVL_INVALID_STS_DT'
4165: ,NULL)
4166: WHEN (ST_DT_FST_BILL_YN ='N' ) THEN
4167: INTO OKS_INT_ERROR_STG_TEMP
4168: (CONCURRENT_REQUEST_ID
4169: ,HEADER_INTERFACE_ROWID
4170: ,INTERFACE_SOURCE_TABLE
4171: ,INTERFACE_ID
4178: ,'OKS_IMP_CLVL_INVALID_SDT_FBDT'
4179: ,NULL)
4180:
4181: WHEN (RNWL_TYPE_VALID ='N' ) THEN
4182: INTO OKS_INT_ERROR_STG_TEMP
4183: (CONCURRENT_REQUEST_ID
4184: ,HEADER_INTERFACE_ROWID
4185: ,INTERFACE_SOURCE_TABLE
4186: ,INTERFACE_ID
4192: ,COVERED_LEVEL_INTERFACE_ID
4193: ,'OKS_IMP_CLVL_INVALID_RNMLCD'
4194: ,NULL)
4195: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') THEN
4196: INTO OKS_INT_ERROR_STG_TEMP
4197: (CONCURRENT_REQUEST_ID
4198: ,HEADER_INTERFACE_ROWID
4199: ,INTERFACE_SOURCE_TABLE
4200: ,INTERFACE_ID
4206: ,COVERED_LEVEL_INTERFACE_ID
4207: ,'OKS_IMP_CLVL_INVALID_CNCLDT'
4208: ,NULL)
4209: WHEN (CR_VALID ='N' OR CR_NULL ='Y') THEN
4210: INTO OKS_INT_ERROR_STG_TEMP
4211: (CONCURRENT_REQUEST_ID
4212: ,HEADER_INTERFACE_ROWID
4213: ,INTERFACE_SOURCE_TABLE
4214: ,INTERFACE_ID
4220: ,COVERED_LEVEL_INTERFACE_ID
4221: ,'OKS_IMP_CLVL_INVALID_CNCLRSN'
4222: ,NULL)
4223: WHEN (INVOICE_TEXT IS NULL ) THEN
4224: INTO OKS_INT_ERROR_STG_TEMP
4225: (CONCURRENT_REQUEST_ID
4226: ,HEADER_INTERFACE_ROWID
4227: ,INTERFACE_SOURCE_TABLE
4228: ,INTERFACE_ID
4234: ,COVERED_LEVEL_INTERFACE_ID
4235: ,'OKS_IMP_CLVL_INVALID_INVTXT'
4236: ,NULL)
4237: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <>'N')) THEN
4238: INTO OKS_INT_ERROR_STG_TEMP
4239: (CONCURRENT_REQUEST_ID
4240: ,HEADER_INTERFACE_ROWID
4241: ,INTERFACE_SOURCE_TABLE
4242: ,INTERFACE_ID
4248: ,COVERED_LEVEL_INTERFACE_ID
4249: ,'OKS_IMP_CLVL_INVALID_PRNTINV'
4250: ,NULL)
4251: WHEN (QUANTITY_COVERED IS NULL OR QUANTITY_COVERED <= 0 OR FLOOR(QUANTITY_COVERED) <> QUANTITY_COVERED ) THEN
4252: INTO OKS_INT_ERROR_STG_TEMP
4253: (CONCURRENT_REQUEST_ID
4254: ,HEADER_INTERFACE_ROWID
4255: ,INTERFACE_SOURCE_TABLE
4256: ,INTERFACE_ID
4262: ,COVERED_LEVEL_INTERFACE_ID
4263: ,'OKS_IMP_CLVL_INVALID_QUNTCOV'
4264: ,NULL)
4265: WHEN( QUOM_VALID = 'N' ) THEN
4266: INTO OKS_INT_ERROR_STG_TEMP
4267: (CONCURRENT_REQUEST_ID
4268: ,HEADER_INTERFACE_ROWID
4269: ,INTERFACE_SOURCE_TABLE
4270: ,INTERFACE_ID
4277: ,'OKS_IMP_CLVL_INVALID_QUOM'
4278: ,NULL)
4279: WHEN ((COVERED_INSTANCE_ID IS NOT NULL OR COVERED_ITEM_ID IS NOT NULL)
4280: AND (PRICE_UOM IS NULL OR PRUOM_VALID ='N')) THEN
4281: INTO OKS_INT_ERROR_STG_TEMP
4282: (CONCURRENT_REQUEST_ID
4283: ,HEADER_INTERFACE_ROWID
4284: ,INTERFACE_SOURCE_TABLE
4285: ,INTERFACE_ID
4291: ,COVERED_LEVEL_INTERFACE_ID
4292: ,'OKS_IMP_CLVL_INVALID_PRUOM'
4293: ,NULL)
4294: WHEN ((COVERED_INSTANCE_ID IS NULL AND COVERED_ITEM_ID IS NULL) AND PRICE_UOM IS NOT NULL) THEN
4295: INTO OKS_INT_ERROR_STG_TEMP
4296: (CONCURRENT_REQUEST_ID
4297: ,HEADER_INTERFACE_ROWID
4298: ,INTERFACE_SOURCE_TABLE
4299: ,INTERFACE_ID
4305: ,COVERED_LEVEL_INTERFACE_ID
4306: ,'OKS_IMP_CLVL_INVALID_PRUOMNUL'
4307: ,NULL)
4308: WHEN (SUBTOTAL IS NULL OR SUBTOTAL <0 ) THEN
4309: INTO OKS_INT_ERROR_STG_TEMP
4310: (CONCURRENT_REQUEST_ID
4311: ,HEADER_INTERFACE_ROWID
4312: ,INTERFACE_SOURCE_TABLE
4313: ,INTERFACE_ID
4319: ,COVERED_LEVEL_INTERFACE_ID
4320: ,'OKS_IMP_CLVL_INVALID_SUBTOT'
4321: ,NULL)
4322: WHEN( TAX_AMOUNT IS NULL OR TAX_AMOUNT < 0 ) THEN
4323: INTO OKS_INT_ERROR_STG_TEMP
4324: (CONCURRENT_REQUEST_ID
4325: ,HEADER_INTERFACE_ROWID
4326: ,INTERFACE_SOURCE_TABLE
4327: ,INTERFACE_ID
4334: ,'OKS_IMP_CLVL_INVALID_TAXAMT'
4335: ,NULL)
4336:
4337: WHEN ( TOT_COV_LVL_ATTR <> 1 ) THEN
4338: INTO OKS_INT_ERROR_STG_TEMP
4339: (CONCURRENT_REQUEST_ID
4340: ,HEADER_INTERFACE_ROWID
4341: ,INTERFACE_SOURCE_TABLE
4342: ,INTERFACE_ID
4348: ,COVERED_LEVEL_INTERFACE_ID
4349: ,'OKS_IMP_CLVL_INVALID_CLVLID'
4350: ,NULL)
4351: /* WHEN (FIRST_BILL_AMT_VALID ='N' ) THEN
4352: INTO OKS_INT_ERROR_STG_TEMP
4353: (CONCURRENT_REQUEST_ID
4354: ,HEADER_INTERFACE_ROWID
4355: ,INTERFACE_SOURCE_TABLE
4356: ,INTERFACE_ID
4362: ,COVERED_LEVEL_INTERFACE_ID
4363: ,'OKS_IMP_CLVL_INVALID_FBILAMT'
4364: ,NULL)
4365: WHEN (LAST_BILL_AMT_VALID ='N' ) THEN
4366: INTO OKS_INT_ERROR_STG_TEMP
4367: (CONCURRENT_REQUEST_ID
4368: ,HEADER_INTERFACE_ROWID
4369: ,INTERFACE_SOURCE_TABLE
4370: ,INTERFACE_ID
4693: ,ESTIMATION_METHOD
4694: ,ESTIMATION_START_DATE
4695: ,LEVEL_YN )
4696: WHEN (LINE_INTERFACE_ID IS NOT NULL AND LINSTG_LINE_INTERFACE_ID IS NULL ) THEN
4697: INTO OKS_INT_ERROR_STG_TEMP
4698: (CONCURRENT_REQUEST_ID
4699: ,HEADER_INTERFACE_ROWID
4700: ,INTERFACE_SOURCE_TABLE
4701: ,INTERFACE_ID
4707: , USAGE_COUNTER_INTERFACE_ID
4708: ,'OKS_IMP_UCTR_INVALID_LINTID'
4709: ,NULL )
4710: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN
4711: INTO OKS_INT_ERROR_STG_TEMP
4712: (CONCURRENT_REQUEST_ID
4713: ,HEADER_INTERFACE_ROWID
4714: ,INTERFACE_SOURCE_TABLE
4715: ,INTERFACE_ID
4721: ,USAGE_COUNTER_INTERFACE_ID
4722: ,'OKS_IMP_UCTR_INVALID_LINNUM'
4723: ,NULL)
4724: WHEN (CNTR_VALID_YN = 'N' ) THEN
4725: INTO OKS_INT_ERROR_STG_TEMP
4726: (CONCURRENT_REQUEST_ID
4727: ,HEADER_INTERFACE_ROWID
4728: ,INTERFACE_SOURCE_TABLE
4729: ,INTERFACE_ID
4735: ,USAGE_COUNTER_INTERFACE_ID
4736: ,'OKS_IMP_UCTR_INVALID_CNTRID'
4737: ,NULL)
4738: WHEN (START_DATE IS NULL OR START_DATE_VALID ='N' ) THEN
4739: INTO OKS_INT_ERROR_STG_TEMP
4740: (CONCURRENT_REQUEST_ID
4741: ,HEADER_INTERFACE_ROWID
4742: ,INTERFACE_SOURCE_TABLE
4743: ,INTERFACE_ID
4750: ,'OKS_IMP_UCTR_INVALID_STRDT'
4751: ,NULL)
4752:
4753: WHEN (END_DATE IS NULL OR END_DATE_VALID='N' ) THEN
4754: INTO OKS_INT_ERROR_STG_TEMP
4755: (CONCURRENT_REQUEST_ID
4756: ,HEADER_INTERFACE_ROWID
4757: ,INTERFACE_SOURCE_TABLE
4758: ,INTERFACE_ID
4765: ,'OKS_IMP_UCTR_INVALID_ENDDT'
4766: ,NULL)
4767:
4768: WHEN ((STATUS_CODE IS NULL) OR STATUS_CNTLVL_VALID='N' OR STATUS_USGLINLVL_VALID='N') THEN
4769: INTO OKS_INT_ERROR_STG_TEMP
4770: (CONCURRENT_REQUEST_ID
4771: ,HEADER_INTERFACE_ROWID
4772: ,INTERFACE_SOURCE_TABLE
4773: ,INTERFACE_ID
4779: ,USAGE_COUNTER_INTERFACE_ID
4780: ,'OKS_IMP_UCTR_INVALID_STSCODE'
4781: ,NULL)
4782: WHEN (DATE_USGCNT_STS_VALID ='N') THEN
4783: INTO OKS_INT_ERROR_STG_TEMP
4784: (CONCURRENT_REQUEST_ID
4785: ,HEADER_INTERFACE_ROWID
4786: ,INTERFACE_SOURCE_TABLE
4787: ,INTERFACE_ID
4794: ,'OKS_IMP_USGCNT_INVALID_STS_DT'
4795: ,NULL)
4796:
4797: WHEN (RENEWAL_TYPE_CODE_VALID = 'N') THEN
4798: INTO OKS_INT_ERROR_STG_TEMP
4799: (CONCURRENT_REQUEST_ID
4800: ,HEADER_INTERFACE_ROWID
4801: ,INTERFACE_SOURCE_TABLE
4802: ,INTERFACE_ID
4808: ,USAGE_COUNTER_INTERFACE_ID
4809: ,'OKS_IMP_UCTR_INVALID_RNWLCD'
4810: ,NULL)
4811: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') THEN
4812: INTO OKS_INT_ERROR_STG_TEMP
4813: (CONCURRENT_REQUEST_ID
4814: ,HEADER_INTERFACE_ROWID
4815: ,INTERFACE_SOURCE_TABLE
4816: ,INTERFACE_ID
4822: ,USAGE_COUNTER_INTERFACE_ID
4823: ,'OKS_IMP_UCTR_INVALID_CNCLDT'
4824: ,NULL)
4825: WHEN (CR_VALID ='N' OR CR_NULL ='Y') THEN
4826: INTO OKS_INT_ERROR_STG_TEMP
4827: (CONCURRENT_REQUEST_ID
4828: ,HEADER_INTERFACE_ROWID
4829: ,INTERFACE_SOURCE_TABLE
4830: ,INTERFACE_ID
4836: ,USAGE_COUNTER_INTERFACE_ID
4837: ,'OKS_IMP_UCTR_INVALID_CNCLRSN'
4838: ,NULL)
4839: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <> 'N')) THEN
4840: INTO OKS_INT_ERROR_STG_TEMP
4841: (CONCURRENT_REQUEST_ID
4842: ,HEADER_INTERFACE_ROWID
4843: ,INTERFACE_SOURCE_TABLE
4844: ,INTERFACE_ID
4850: ,USAGE_COUNTER_INTERFACE_ID
4851: ,'OKS_IMP_UCTR_INVALID_PRINV'
4852: ,NULL)
4853: WHEN ( SUBTOTAL_VALID = 'N' OR SUBTOTAL <0) THEN
4854: INTO OKS_INT_ERROR_STG_TEMP
4855: (CONCURRENT_REQUEST_ID
4856: ,HEADER_INTERFACE_ROWID
4857: ,INTERFACE_SOURCE_TABLE
4858: ,INTERFACE_ID
4864: ,USAGE_COUNTER_INTERFACE_ID
4865: ,'OKS_IMP_UCTR_INVALID_STOT'
4866: ,NULL)
4867: WHEN (TAX_VALID ='N' OR TAX_AMOUNT < 0 ) THEN
4868: INTO OKS_INT_ERROR_STG_TEMP
4869: (CONCURRENT_REQUEST_ID
4870: ,HEADER_INTERFACE_ROWID
4871: ,INTERFACE_SOURCE_TABLE
4872: ,INTERFACE_ID
4878: ,USAGE_COUNTER_INTERFACE_ID
4879: ,'OKS_IMP_UCTR_INVALID_TAXINV'
4880: ,NULL)
4881: WHEN (FIXED_USG_CNT_VALID = 'N' OR FIXED_USG_CNT_VALID IS NULL OR FIXED_USG_CNT <0 ) THEN
4882: INTO OKS_INT_ERROR_STG_TEMP
4883: (CONCURRENT_REQUEST_ID
4884: ,HEADER_INTERFACE_ROWID
4885: ,INTERFACE_SOURCE_TABLE
4886: ,INTERFACE_ID
4892: ,USAGE_COUNTER_INTERFACE_ID
4893: ,'OKS_IMP_UCTR_INVALID_FIXEDUSG'
4894: ,NULL)
4895: WHEN ( MINIMUM_USG_CNT_VALID ='N' OR MINIMUM_USG_CNT_VALID IS NULL OR MINIMUM_USG_CNT <0 ) THEN
4896: INTO OKS_INT_ERROR_STG_TEMP
4897: (CONCURRENT_REQUEST_ID
4898: ,HEADER_INTERFACE_ROWID
4899: ,INTERFACE_SOURCE_TABLE
4900: ,INTERFACE_ID
4906: ,USAGE_COUNTER_INTERFACE_ID
4907: ,'OKS_IMP_UCTR_INVALID_MINUSG'
4908: ,NULL)
4909: WHEN ( DEFAULT_USG_CNT_VALID='N' OR DEFAULT_USG_CNT_VALID IS NULL OR DEFAULT_USG_CNT < 0 ) THEN
4910: INTO OKS_INT_ERROR_STG_TEMP
4911: (CONCURRENT_REQUEST_ID
4912: ,HEADER_INTERFACE_ROWID
4913: ,INTERFACE_SOURCE_TABLE
4914: ,INTERFACE_ID
4920: ,USAGE_COUNTER_INTERFACE_ID
4921: ,'OKS_IMP_UCTR_INVALID_DEFUSG'
4922: ,NULL)
4923: WHEN (FILL_YN_VALID = 'N' OR ( FILL_YN <> 'Y' AND FILL_YN <> 'N')) THEN
4924: INTO OKS_INT_ERROR_STG_TEMP
4925: (CONCURRENT_REQUEST_ID
4926: ,HEADER_INTERFACE_ROWID
4927: ,INTERFACE_SOURCE_TABLE
4928: ,INTERFACE_ID
4934: ,USAGE_COUNTER_INTERFACE_ID
4935: ,'OKS_IMP_UCTR_INVALID_FILLYN'
4936: ,NULL)
4937: WHEN (ESTIMATION_METHOD_VALID='N' OR ESTMTHD_LKUP_VALID='N') THEN
4938: INTO OKS_INT_ERROR_STG_TEMP
4939: (CONCURRENT_REQUEST_ID
4940: ,HEADER_INTERFACE_ROWID
4941: ,INTERFACE_SOURCE_TABLE
4942: ,INTERFACE_ID
4948: ,USAGE_COUNTER_INTERFACE_ID
4949: ,'OKS_IMP_UCTR_INVALID_ESTMTHD'
4950: ,NULL)
4951: WHEN (EST_STRDT_VALID='N') THEN
4952: INTO OKS_INT_ERROR_STG_TEMP
4953: (CONCURRENT_REQUEST_ID
4954: ,HEADER_INTERFACE_ROWID
4955: ,INTERFACE_SOURCE_TABLE
4956: ,INTERFACE_ID
4962: ,USAGE_COUNTER_INTERFACE_ID
4963: ,'OKS_IMP_UCTR_INVALID_ESTSRTDT'
4964: ,NULL)
4965: WHEN (LEVEL_YN_VALID ='N' OR (LEVEL_YN is not NULL and LEVEL_YN <>'Y' AND LEVEL_YN <>'N')) THEN
4966: INTO OKS_INT_ERROR_STG_TEMP
4967: (CONCURRENT_REQUEST_ID
4968: ,HEADER_INTERFACE_ROWID
4969: ,INTERFACE_SOURCE_TABLE
4970: ,INTERFACE_ID
5206: ,SALESGROUP_ID
5207: ,SALES_CREDIT_TYPE_ID
5208: ,PERCENT)
5209: WHEN (SALESPERSON_ID IS NULL) THEN
5210: INTO OKS_INT_ERROR_STG_TEMP
5211: (CONCURRENT_REQUEST_ID
5212: ,HEADER_INTERFACE_ROWID
5213: ,INTERFACE_SOURCE_TABLE
5214: ,INTERFACE_ID
5220: ,SALES_CREDIT_INTERFACE_ID
5221: ,'OKS_IMP_SC_INVALID_SALEPERS'
5222: ,NULL)
5223: WHEN (SALESGROUP_V = 'N') THEN
5224: INTO OKS_INT_ERROR_STG_TEMP
5225: (CONCURRENT_REQUEST_ID
5226: ,HEADER_INTERFACE_ROWID
5227: ,INTERFACE_SOURCE_TABLE
5228: ,INTERFACE_ID
5234: ,SALES_CREDIT_INTERFACE_ID
5235: ,'OKS_IMP_SC_INVALID_SALEGRP'
5236: ,NULL)
5237: WHEN (SALES_CREDIT_TYPE_ID IS NULL) THEN
5238: INTO OKS_INT_ERROR_STG_TEMP
5239: (CONCURRENT_REQUEST_ID
5240: ,HEADER_INTERFACE_ROWID
5241: ,INTERFACE_SOURCE_TABLE
5242: ,INTERFACE_ID
5248: ,SALES_CREDIT_INTERFACE_ID
5249: ,'OKS_IMP_SC_INVALID_SCT'
5250: ,NULL)
5251: WHEN (QUOTA_FLAG = 'Y' AND PERCENT_SUM <> 100) THEN
5252: INTO OKS_INT_ERROR_STG_TEMP
5253: (CONCURRENT_REQUEST_ID
5254: ,HEADER_INTERFACE_ROWID
5255: ,INTERFACE_SOURCE_TABLE
5256: ,INTERFACE_ID
5262: ,SALES_CREDIT_INTERFACE_ID
5263: ,'OKS_IMP_SC_INVALID_PERSUM'
5264: ,NULL)
5265: WHEN (PERCENT IS NULL OR PERCENT < 0 OR PERCENT > 100) THEN
5266: INTO OKS_INT_ERROR_STG_TEMP
5267: (CONCURRENT_REQUEST_ID
5268: ,HEADER_INTERFACE_ROWID
5269: ,INTERFACE_SOURCE_TABLE
5270: ,INTERFACE_ID
5276: ,SALES_CREDIT_INTERFACE_ID
5277: ,'OKS_IMP_SC_INVALID_PER'
5278: ,NULL)
5279: WHEN (UNIQ = 'N') THEN
5280: INTO OKS_INT_ERROR_STG_TEMP
5281: (CONCURRENT_REQUEST_ID
5282: ,HEADER_INTERFACE_ROWID
5283: ,INTERFACE_SOURCE_TABLE
5284: ,INTERFACE_ID
5400: l_stmt_num := 10;
5401:
5402: INSERT ALL
5403: WHEN (NOTE_STATUS_VALID ='N' ) THEN
5404: INTO OKS_INT_ERROR_STG_TEMP
5405: (CONCURRENT_REQUEST_ID
5406: ,HEADER_INTERFACE_ROWID
5407: ,INTERFACE_SOURCE_TABLE
5408: ,INTERFACE_ID
5414: ,NOTES_INTERFACE_ID
5415: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5416: ,NULL)
5417: WHEN (NOTE_TYPE_VALID='N') THEN
5418: INTO OKS_INT_ERROR_STG_TEMP
5419: (CONCURRENT_REQUEST_ID
5420: ,HEADER_INTERFACE_ROWID
5421: ,INTERFACE_SOURCE_TABLE
5422: ,INTERFACE_ID
5428: ,NOTES_INTERFACE_ID
5429: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5430: ,NULL)
5431: WHEN (ENTERED_BY_VALID ='N') THEN
5432: INTO OKS_INT_ERROR_STG_TEMP
5433: (CONCURRENT_REQUEST_ID
5434: ,HEADER_INTERFACE_ROWID
5435: ,INTERFACE_SOURCE_TABLE
5436: ,INTERFACE_ID
5442: ,NOTES_INTERFACE_ID
5443: ,'OKS_IMP_NTINT_INVALID_USR'
5444: ,NULL)
5445: WHEN (ENTERED_DT_VALID ='N') THEN
5446: INTO OKS_INT_ERROR_STG_TEMP
5447: (CONCURRENT_REQUEST_ID
5448: ,HEADER_INTERFACE_ROWID
5449: ,INTERFACE_SOURCE_TABLE
5450: ,INTERFACE_ID
5456: ,NOTES_INTERFACE_ID
5457: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5458: ,NULL)
5459: WHEN (NOTES IS NULL ) THEN
5460: INTO OKS_INT_ERROR_STG_TEMP
5461: (CONCURRENT_REQUEST_ID
5462: ,HEADER_INTERFACE_ROWID
5463: ,INTERFACE_SOURCE_TABLE
5464: ,INTERFACE_ID
5513: l_stmt_num := 20;
5514:
5515: INSERT ALL
5516: WHEN (NOTE_STATUS_VALID ='N' ) THEN
5517: INTO OKS_INT_ERROR_STG_TEMP
5518: (CONCURRENT_REQUEST_ID
5519: ,HEADER_INTERFACE_ROWID
5520: ,INTERFACE_SOURCE_TABLE
5521: ,INTERFACE_ID
5527: ,NOTES_INTERFACE_ID
5528: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5529: ,NULL)
5530: WHEN (NOTE_TYPE_VALID='N') THEN
5531: INTO OKS_INT_ERROR_STG_TEMP
5532: (CONCURRENT_REQUEST_ID
5533: ,HEADER_INTERFACE_ROWID
5534: ,INTERFACE_SOURCE_TABLE
5535: ,INTERFACE_ID
5541: ,NOTES_INTERFACE_ID
5542: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5543: ,NULL)
5544: WHEN (ENTERED_BY_VALID ='N') THEN
5545: INTO OKS_INT_ERROR_STG_TEMP
5546: (CONCURRENT_REQUEST_ID
5547: ,HEADER_INTERFACE_ROWID
5548: ,INTERFACE_SOURCE_TABLE
5549: ,INTERFACE_ID
5555: ,NOTES_INTERFACE_ID
5556: ,'OKS_IMP_NTINT_INVALID_USR'
5557: ,NULL)
5558: WHEN (ENTERED_DT_VALID ='N') THEN
5559: INTO OKS_INT_ERROR_STG_TEMP
5560: (CONCURRENT_REQUEST_ID
5561: ,HEADER_INTERFACE_ROWID
5562: ,INTERFACE_SOURCE_TABLE
5563: ,INTERFACE_ID
5569: ,NOTES_INTERFACE_ID
5570: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5571: ,NULL)
5572: WHEN (NOTES IS NULL ) THEN
5573: INTO OKS_INT_ERROR_STG_TEMP
5574: (CONCURRENT_REQUEST_ID
5575: ,HEADER_INTERFACE_ROWID
5576: ,INTERFACE_SOURCE_TABLE
5577: ,INTERFACE_ID