[Home] [Help]
245: ,FULLY_BILLED
246: ,SOURCE
247: ,DOCUMENT)
248: WHEN (OPERATING_UNIT_ID IS NULL) THEN
249: INTO OKS_INT_ERROR_STG_TEMP
250: (CONCURRENT_REQUEST_ID
251: ,HEADER_INTERFACE_ROWID
252: ,INTERFACE_SOURCE_TABLE
253: ,INTERFACE_ID
259: ,HEADER_INTERFACE_ID
260: ,'OKS_IMP_HDR_INVALID_OU'
261: ,NULL)
262: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN
263: INTO OKS_INT_ERROR_STG_TEMP
264: (CONCURRENT_REQUEST_ID
265: ,HEADER_INTERFACE_ROWID
266: ,INTERFACE_SOURCE_TABLE
267: ,INTERFACE_ID
273: ,HEADER_INTERFACE_ID
274: ,'OKS_IMP_HDR_INVALID_BTSU'
275: ,NULL)
276: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN
277: INTO OKS_INT_ERROR_STG_TEMP
278: (CONCURRENT_REQUEST_ID
279: ,HEADER_INTERFACE_ROWID
280: ,INTERFACE_SOURCE_TABLE
281: ,INTERFACE_ID
287: ,HEADER_INTERFACE_ID
288: ,'OKS_IMP_HDR_INVALID_STSU'
289: ,NULL)
290: WHEN (CONTRACT_CURRENCY_CODE IS NULL) THEN
291: INTO OKS_INT_ERROR_STG_TEMP
292: (CONCURRENT_REQUEST_ID
293: ,HEADER_INTERFACE_ROWID
294: ,INTERFACE_SOURCE_TABLE
295: ,INTERFACE_ID
303: ,NULL)
304: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
305: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
306: AND CURRENCY_CONVERSION_TYPE IS NULL) THEN
307: INTO OKS_INT_ERROR_STG_TEMP
308: (CONCURRENT_REQUEST_ID
309: ,HEADER_INTERFACE_ROWID
310: ,INTERFACE_SOURCE_TABLE
311: ,INTERFACE_ID
320: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
321: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
322: AND CURRENCY_CONVERSION_TYPE = 'User'
323: AND (CURRENCY_CONVERSION_RATE IS NULL OR CURRENCY_CONVERSION_RATE <= 0)) THEN
324: INTO OKS_INT_ERROR_STG_TEMP
325: (CONCURRENT_REQUEST_ID
326: ,HEADER_INTERFACE_ROWID
327: ,INTERFACE_SOURCE_TABLE
328: ,INTERFACE_ID
336: ,NULL)
337: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
338: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
339: AND CURRENCY_CONVERSION_DATE IS NULL) THEN
340: INTO OKS_INT_ERROR_STG_TEMP
341: (CONCURRENT_REQUEST_ID
342: ,HEADER_INTERFACE_ROWID
343: ,INTERFACE_SOURCE_TABLE
344: ,INTERFACE_ID
353: WHEN (CONTRACT_CURRENCY_CODE IS NOT NULL
354: AND CONTRACT_CURRENCY_CODE <> OU_LEDGER_CUR_CODE
355: AND CURRENCY_CONVERSION_TYPE <> 'User'
356: AND HDR_CURRENCY_CONVERSION_RATE 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
371: AND CONTRACT_CURRENCY_CODE = OU_LEDGER_CUR_CODE
372: AND (CURRENCY_CONVERSION_TYPE IS NOT NULL
373: OR HDR_CURRENCY_CONVERSION_RATE IS NOT NULL
374: OR CURRENCY_CONVERSION_DATE IS NOT NULL)) THEN
375: INTO OKS_INT_ERROR_STG_TEMP
376: (CONCURRENT_REQUEST_ID
377: ,HEADER_INTERFACE_ROWID
378: ,INTERFACE_SOURCE_TABLE
379: ,INTERFACE_ID
385: ,HEADER_INTERFACE_ID
386: ,'OKS_IMP_HDR_NULL_CONV'
387: ,NULL)
388: WHEN (PRICE_LIST_ID IS NULL) THEN
389: INTO OKS_INT_ERROR_STG_TEMP
390: (CONCURRENT_REQUEST_ID
391: ,HEADER_INTERFACE_ROWID
392: ,INTERFACE_SOURCE_TABLE
393: ,INTERFACE_ID
399: ,HEADER_INTERFACE_ID
400: ,'OKS_IMP_HDR_INVALID_PRICELIST'
401: ,NULL)
402: WHEN (PAYMENT_TERMS_ID IS NULL) THEN
403: INTO OKS_INT_ERROR_STG_TEMP
404: (CONCURRENT_REQUEST_ID
405: ,HEADER_INTERFACE_ROWID
406: ,INTERFACE_SOURCE_TABLE
407: ,INTERFACE_ID
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
417: INTO OKS_INT_ERROR_STG_TEMP
418: (CONCURRENT_REQUEST_ID
419: ,HEADER_INTERFACE_ROWID
420: ,INTERFACE_SOURCE_TABLE
421: ,INTERFACE_ID
427: ,HEADER_INTERFACE_ID
428: ,'OKS_IMP_HDR_INVALID_PAYINSTR'
429: ,NULL)
430: WHEN (INVOICING_RULE_ID IS NULL) THEN
431: INTO OKS_INT_ERROR_STG_TEMP
432: (CONCURRENT_REQUEST_ID
433: ,HEADER_INTERFACE_ROWID
434: ,INTERFACE_SOURCE_TABLE
435: ,INTERFACE_ID
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
445: INTO OKS_INT_ERROR_STG_TEMP
446: (CONCURRENT_REQUEST_ID
447: ,HEADER_INTERFACE_ROWID
448: ,INTERFACE_SOURCE_TABLE
449: ,INTERFACE_ID
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
459: INTO OKS_INT_ERROR_STG_TEMP
460: (CONCURRENT_REQUEST_ID
461: ,HEADER_INTERFACE_ROWID
462: ,INTERFACE_SOURCE_TABLE
463: ,INTERFACE_ID
469: ,HEADER_INTERFACE_ID
470: ,'OKS_IMP_HDR_INVALID_COMMIT'
471: ,NULL)
472: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN
473: INTO OKS_INT_ERROR_STG_TEMP
474: (CONCURRENT_REQUEST_ID
475: ,HEADER_INTERFACE_ROWID
476: ,INTERFACE_SOURCE_TABLE
477: ,INTERFACE_ID
484: ,'OKS_IMP_HDR_INVALID_ACCRULE'
485: ,NULL)
486: WHEN (PRICING_METHOD = 'LST' AND RENEWAL_PRICE_LIST_ID IS NULL)
487: OR (RENEWAL_PRICE_LIST_ID IS NOT NULL AND (PRICING_METHOD NOT IN ('LST', 'PCT') OR PRICING_METHOD IS NULL ) ) THEN
488: INTO OKS_INT_ERROR_STG_TEMP
489: (CONCURRENT_REQUEST_ID
490: ,HEADER_INTERFACE_ROWID
491: ,INTERFACE_SOURCE_TABLE
492: ,INTERFACE_ID
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
502: INTO OKS_INT_ERROR_STG_TEMP
503: (CONCURRENT_REQUEST_ID
504: ,HEADER_INTERFACE_ROWID
505: ,INTERFACE_SOURCE_TABLE
506: ,INTERFACE_ID
512: ,HEADER_INTERFACE_ID
513: ,'OKS_IMP_HDR_INVALID_RENPL'
514: ,NULL)
515: WHEN (CUSTOMER_PARTY_ID IS NULL) THEN
516: INTO OKS_INT_ERROR_STG_TEMP
517: (CONCURRENT_REQUEST_ID
518: ,HEADER_INTERFACE_ROWID
519: ,INTERFACE_SOURCE_TABLE
520: ,INTERFACE_ID
526: ,HEADER_INTERFACE_ID
527: ,'OKS_IMP_HDR_INVALID_CTPARTY'
528: ,NULL)
529: WHEN (TP_PROVIDED = 'Y' AND THIRD_PARTY_ID IS NULL) THEN
530: INTO OKS_INT_ERROR_STG_TEMP
531: (CONCURRENT_REQUEST_ID
532: ,HEADER_INTERFACE_ROWID
533: ,INTERFACE_SOURCE_TABLE
534: ,INTERFACE_ID
540: ,HEADER_INTERFACE_ID
541: ,'OKS_IMP_HDR_INVALID_TPPARTY'
542: ,NULL)
543: WHEN (CONTRACT_GROUP_ID IS NULL) THEN
544: INTO OKS_INT_ERROR_STG_TEMP
545: (CONCURRENT_REQUEST_ID
546: ,HEADER_INTERFACE_ROWID
547: ,INTERFACE_SOURCE_TABLE
548: ,INTERFACE_ID
554: ,HEADER_INTERFACE_ID
555: ,'OKS_IMP_HDR_INVALID_CG'
556: ,NULL)
557: WHEN (AGREEMENT_PROVIDED = 'Y' AND AGREEMENT_ID IS NULL) THEN
558: INTO OKS_INT_ERROR_STG_TEMP
559: (CONCURRENT_REQUEST_ID
560: ,HEADER_INTERFACE_ROWID
561: ,INTERFACE_SOURCE_TABLE
562: ,INTERFACE_ID
568: ,HEADER_INTERFACE_ID
569: ,'OKS_IMP_HDR_INVALID_PAGRMT'
570: ,NULL)
571: WHEN (SALESPERSON_PROVIDED = 'Y' AND SALESPERSON_ID IS NULL) THEN
572: INTO OKS_INT_ERROR_STG_TEMP
573: (CONCURRENT_REQUEST_ID
574: ,HEADER_INTERFACE_ROWID
575: ,INTERFACE_SOURCE_TABLE
576: ,INTERFACE_ID
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
586: INTO OKS_INT_ERROR_STG_TEMP
587: (CONCURRENT_REQUEST_ID
588: ,HEADER_INTERFACE_ROWID
589: ,INTERFACE_SOURCE_TABLE
590: ,INTERFACE_ID
596: ,HEADER_INTERFACE_ID
597: ,'OKS_IMP_HDR_INVALID_CCADMIN'
598: ,NULL)
599: WHEN DESCRIPTION IS NULL THEN
600: INTO OKS_INT_ERROR_STG_TEMP
601: (CONCURRENT_REQUEST_ID
602: ,HEADER_INTERFACE_ROWID
603: ,INTERFACE_SOURCE_TABLE
604: ,INTERFACE_ID
610: ,HEADER_INTERFACE_ID
611: ,'OKS_IMP_HDR_INVALID_DESC'
612: ,NULL)
613: WHEN FULLY_BILLED IS NULL THEN
614: INTO OKS_INT_ERROR_STG_TEMP
615: (CONCURRENT_REQUEST_ID
616: ,HEADER_INTERFACE_ROWID
617: ,INTERFACE_SOURCE_TABLE
618: ,INTERFACE_ID
624: ,HEADER_INTERFACE_ID
625: ,'OKS_IMP_HDR_INVALID_FULB'
626: ,NULL)
627: WHEN FULLY_BILLED_INV ='Y' THEN
628: INTO OKS_INT_ERROR_STG_TEMP
629: (CONCURRENT_REQUEST_ID
630: ,HEADER_INTERFACE_ROWID
631: ,INTERFACE_SOURCE_TABLE
632: ,INTERFACE_ID
1028: l_stmt_num := 20;
1029:
1030: INSERT ALL
1031: WHEN (CONTRACT_NUMBER IS NULL) THEN
1032: INTO OKS_INT_ERROR_STG_TEMP
1033: (CONCURRENT_REQUEST_ID
1034: ,HEADER_INTERFACE_ROWID
1035: ,INTERFACE_SOURCE_TABLE
1036: ,INTERFACE_ID
1042: ,HEADER_INTERFACE_ID
1043: ,'OKS_IMP_HDR_INVALID_NUM'
1044: ,NULL)
1045: WHEN (NUMBER_COUNT_IN_HDR > 0) THEN
1046: INTO OKS_INT_ERROR_STG_TEMP
1047: (CONCURRENT_REQUEST_ID
1048: ,HEADER_INTERFACE_ROWID
1049: ,INTERFACE_SOURCE_TABLE
1050: ,INTERFACE_ID
1056: ,HEADER_INTERFACE_ID
1057: ,'OKS_IMP_HDR_NONUNIQ_NUM_HDR'
1058: ,NULL)
1059: WHEN (NUMBER_NOTUNIQ_IN_INT = 'Y') THEN
1060: INTO OKS_INT_ERROR_STG_TEMP
1061: (CONCURRENT_REQUEST_ID
1062: ,HEADER_INTERFACE_ROWID
1063: ,INTERFACE_SOURCE_TABLE
1064: ,INTERFACE_ID
1070: ,HEADER_INTERFACE_ID
1071: ,'OKS_IMP_HDR_NONUNIQ_NUM_INT'
1072: ,NULL)
1073: WHEN (CAT_COUNT <> 1) THEN
1074: INTO OKS_INT_ERROR_STG_TEMP
1075: (CONCURRENT_REQUEST_ID
1076: ,HEADER_INTERFACE_ROWID
1077: ,INTERFACE_SOURCE_TABLE
1078: ,INTERFACE_ID
1084: ,HEADER_INTERFACE_ID
1085: ,'OKS_IMP_HDR_INVALID_CAT'
1086: ,NULL)
1087: WHEN (DATE_VALID = 'N') THEN
1088: INTO OKS_INT_ERROR_STG_TEMP
1089: (CONCURRENT_REQUEST_ID
1090: ,HEADER_INTERFACE_ROWID
1091: ,INTERFACE_SOURCE_TABLE
1092: ,INTERFACE_ID
1098: ,HEADER_INTERFACE_ID
1099: ,'OKS_IMP_HDR_INVALID_DATE'
1100: ,NULL)
1101: WHEN (STATUS_VALID = 'N') THEN
1102: INTO OKS_INT_ERROR_STG_TEMP
1103: (CONCURRENT_REQUEST_ID
1104: ,HEADER_INTERFACE_ROWID
1105: ,INTERFACE_SOURCE_TABLE
1106: ,INTERFACE_ID
1112: ,HEADER_INTERFACE_ID
1113: ,'OKS_IMP_HDR_INVALID_STATUS'
1114: ,NULL)
1115: WHEN (STATUS_X_DATE_VALID = 'N') THEN
1116: INTO OKS_INT_ERROR_STG_TEMP
1117: (CONCURRENT_REQUEST_ID
1118: ,HEADER_INTERFACE_ROWID
1119: ,INTERFACE_SOURCE_TABLE
1120: ,INTERFACE_ID
1126: ,HEADER_INTERFACE_ID
1127: ,'OKS_IMP_HDR_STATUS_X_DATE'
1128: ,NULL)
1129: WHEN (DATE_APPROVED_VALID = 'N') THEN
1130: INTO OKS_INT_ERROR_STG_TEMP
1131: (CONCURRENT_REQUEST_ID
1132: ,HEADER_INTERFACE_ROWID
1133: ,INTERFACE_SOURCE_TABLE
1134: ,INTERFACE_ID
1140: ,HEADER_INTERFACE_ID
1141: ,'OKS_IMP_HDR_INVALID_DATE_APRV'
1142: ,NULL)
1143: WHEN (DATE_APPROVED_NULL_ERROR = 'Y') THEN
1144: INTO OKS_INT_ERROR_STG_TEMP
1145: (CONCURRENT_REQUEST_ID
1146: ,HEADER_INTERFACE_ROWID
1147: ,INTERFACE_SOURCE_TABLE
1148: ,INTERFACE_ID
1154: ,HEADER_INTERFACE_ID
1155: ,'OKS_IMP_HDR_NULL_DATE_APRV'
1156: ,NULL)
1157: WHEN (DATE_CANCELED_VALID = 'N') THEN
1158: INTO OKS_INT_ERROR_STG_TEMP
1159: (CONCURRENT_REQUEST_ID
1160: ,HEADER_INTERFACE_ROWID
1161: ,INTERFACE_SOURCE_TABLE
1162: ,INTERFACE_ID
1168: ,HEADER_INTERFACE_ID
1169: ,'OKS_IMP_HDR_INVALID_DATE_CANC'
1170: ,NULL)
1171: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN
1172: INTO OKS_INT_ERROR_STG_TEMP
1173: (CONCURRENT_REQUEST_ID
1174: ,HEADER_INTERFACE_ROWID
1175: ,INTERFACE_SOURCE_TABLE
1176: ,INTERFACE_ID
1182: ,HEADER_INTERFACE_ID
1183: ,'OKS_IMP_HDR_NULL_DATE_CANC'
1184: ,NULL)
1185: WHEN (CR_VALID = 'N') THEN
1186: INTO OKS_INT_ERROR_STG_TEMP
1187: (CONCURRENT_REQUEST_ID
1188: ,HEADER_INTERFACE_ROWID
1189: ,INTERFACE_SOURCE_TABLE
1190: ,INTERFACE_ID
1196: ,HEADER_INTERFACE_ID
1197: ,'OKS_IMP_HDR_INVALID_CANC_RSN'
1198: ,NULL)
1199: WHEN (CR_NULL_ERROR = 'Y') THEN
1200: INTO OKS_INT_ERROR_STG_TEMP
1201: (CONCURRENT_REQUEST_ID
1202: ,HEADER_INTERFACE_ROWID
1203: ,INTERFACE_SOURCE_TABLE
1204: ,INTERFACE_ID
1210: ,HEADER_INTERFACE_ID
1211: ,'OKS_IMP_HDR_NULL_CANC_RSN'
1212: ,NULL)
1213: WHEN (DATE_SIGNED_VALID = 'N') THEN
1214: INTO OKS_INT_ERROR_STG_TEMP
1215: (CONCURRENT_REQUEST_ID
1216: ,HEADER_INTERFACE_ROWID
1217: ,INTERFACE_SOURCE_TABLE
1218: ,INTERFACE_ID
1224: ,HEADER_INTERFACE_ID
1225: ,'OKS_IMP_HDR_INVALID_DATE_SGND'
1226: ,NULL)
1227: WHEN (DATE_SIGNED_NULL_ERROR = 'Y') THEN
1228: INTO OKS_INT_ERROR_STG_TEMP
1229: (CONCURRENT_REQUEST_ID
1230: ,HEADER_INTERFACE_ROWID
1231: ,INTERFACE_SOURCE_TABLE
1232: ,INTERFACE_ID
1238: ,HEADER_INTERFACE_ID
1239: ,'OKS_IMP_HDR_NULL_DATE_SGND'
1240: ,NULL)
1241: WHEN (RENP_VALID = 'N') THEN
1242: INTO OKS_INT_ERROR_STG_TEMP
1243: (CONCURRENT_REQUEST_ID
1244: ,HEADER_INTERFACE_ROWID
1245: ,INTERFACE_SOURCE_TABLE
1246: ,INTERFACE_ID
1252: ,HEADER_INTERFACE_ID
1253: ,'OKS_IMP_HDR_INVALID_REN_PROC'
1254: ,NULL)
1255: WHEN (RENUPTO_VALID = 'N') THEN
1256: INTO OKS_INT_ERROR_STG_TEMP
1257: (CONCURRENT_REQUEST_ID
1258: ,HEADER_INTERFACE_ROWID
1259: ,INTERFACE_SOURCE_TABLE
1260: ,INTERFACE_ID
1266: ,HEADER_INTERFACE_ID
1267: ,'OKS_IMP_HDR_INVALID_REN_UPTO'
1268: ,NULL)
1269: WHEN (RENUPTO_NULL_ERROR = 'Y') THEN
1270: INTO OKS_INT_ERROR_STG_TEMP
1271: (CONCURRENT_REQUEST_ID
1272: ,HEADER_INTERFACE_ROWID
1273: ,INTERFACE_SOURCE_TABLE
1274: ,INTERFACE_ID
1280: ,HEADER_INTERFACE_ID
1281: ,'OKS_IMP_HDR_NULL_REN_UPTO'
1282: ,NULL)
1283: WHEN (APRV_REQ_VALID = 'N') THEN
1284: INTO OKS_INT_ERROR_STG_TEMP
1285: (CONCURRENT_REQUEST_ID
1286: ,HEADER_INTERFACE_ROWID
1287: ,INTERFACE_SOURCE_TABLE
1288: ,INTERFACE_ID
1294: ,HEADER_INTERFACE_ID
1295: ,'OKS_IMP_HDR_INVALID_APRV_REQ'
1296: ,NULL)
1297: WHEN (APRV_REQ_NULL_ERROR = 'Y') THEN
1298: INTO OKS_INT_ERROR_STG_TEMP
1299: (CONCURRENT_REQUEST_ID
1300: ,HEADER_INTERFACE_ROWID
1301: ,INTERFACE_SOURCE_TABLE
1302: ,INTERFACE_ID
1308: ,HEADER_INTERFACE_ID
1309: ,'OKS_IMP_HDR_NULL_APRV_REQ'
1310: ,NULL)
1311: WHEN (PRM_VALID = 'N') THEN
1312: INTO OKS_INT_ERROR_STG_TEMP
1313: (CONCURRENT_REQUEST_ID
1314: ,HEADER_INTERFACE_ROWID
1315: ,INTERFACE_SOURCE_TABLE
1316: ,INTERFACE_ID
1322: ,HEADER_INTERFACE_ID
1323: ,'OKS_IMP_HDR_INVALID_PRC_METHOD'
1324: ,NULL)
1325: WHEN (PRM_NULL_ERROR = 'Y') THEN
1326: INTO OKS_INT_ERROR_STG_TEMP
1327: (CONCURRENT_REQUEST_ID
1328: ,HEADER_INTERFACE_ROWID
1329: ,INTERFACE_SOURCE_TABLE
1330: ,INTERFACE_ID
1336: ,HEADER_INTERFACE_ID
1337: ,'OKS_IMP_HDR_NULL_PRC_METHOD'
1338: ,NULL)
1339: WHEN (MKP_VALID = 'N') THEN
1340: INTO OKS_INT_ERROR_STG_TEMP
1341: (CONCURRENT_REQUEST_ID
1342: ,HEADER_INTERFACE_ROWID
1343: ,INTERFACE_SOURCE_TABLE
1344: ,INTERFACE_ID
1350: ,HEADER_INTERFACE_ID
1351: ,'OKS_IMP_HDR_INVALID_MARKUP'
1352: ,NULL)
1353: WHEN (MKP_NULL_ERROR = 'Y') THEN
1354: INTO OKS_INT_ERROR_STG_TEMP
1355: (CONCURRENT_REQUEST_ID
1356: ,HEADER_INTERFACE_ROWID
1357: ,INTERFACE_SOURCE_TABLE
1358: ,INTERFACE_ID
1364: ,HEADER_INTERFACE_ID
1365: ,'OKS_IMP_HDR_NULL_MARKUP'
1366: ,NULL)
1367: WHEN (BP_VALID = 'N') THEN
1368: INTO OKS_INT_ERROR_STG_TEMP
1369: (CONCURRENT_REQUEST_ID
1370: ,HEADER_INTERFACE_ROWID
1371: ,INTERFACE_SOURCE_TABLE
1372: ,INTERFACE_ID
1378: ,HEADER_INTERFACE_ID
1379: ,'OKS_IMP_HDR_INVALID_BILLPROF'
1380: ,NULL)
1381: WHEN (RENPOREQ_VALID = 'N') THEN
1382: INTO OKS_INT_ERROR_STG_TEMP
1383: (CONCURRENT_REQUEST_ID
1384: ,HEADER_INTERFACE_ROWID
1385: ,INTERFACE_SOURCE_TABLE
1386: ,INTERFACE_ID
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
1396: INTO OKS_INT_ERROR_STG_TEMP
1397: (CONCURRENT_REQUEST_ID
1398: ,HEADER_INTERFACE_ROWID
1399: ,INTERFACE_SOURCE_TABLE
1400: ,INTERFACE_ID
1406: ,HEADER_INTERFACE_ID
1407: ,'OKS_IMP_HDR_INVALID_RENGR_DUR'
1408: ,NULL)
1409: WHEN (RENGRPER_VALID = 'N') THEN
1410: INTO OKS_INT_ERROR_STG_TEMP
1411: (CONCURRENT_REQUEST_ID
1412: ,HEADER_INTERFACE_ROWID
1413: ,INTERFACE_SOURCE_TABLE
1414: ,INTERFACE_ID
1420: ,HEADER_INTERFACE_ID
1421: ,'OKS_IMP_HDR_INVALID_RENGR_PER'
1422: ,NULL)
1423: WHEN (RENGRPER_NULL_ERROR = 'Y') THEN
1424: INTO OKS_INT_ERROR_STG_TEMP
1425: (CONCURRENT_REQUEST_ID
1426: ,HEADER_INTERFACE_ROWID
1427: ,INTERFACE_SOURCE_TABLE
1428: ,INTERFACE_ID
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
1438: INTO OKS_INT_ERROR_STG_TEMP
1439: (CONCURRENT_REQUEST_ID
1440: ,HEADER_INTERFACE_ROWID
1441: ,INTERFACE_SOURCE_TABLE
1442: ,INTERFACE_ID
1448: ,HEADER_INTERFACE_ID
1449: ,'OKS_IMP_HDR_NULL_EST_PERC'
1450: ,NULL) */
1451: /* WHEN (nvl(RENEWAL_ESTIMATED_DURATION, 1) <= 0 ) THEN
1452: INTO OKS_INT_ERROR_STG_TEMP
1453: (CONCURRENT_REQUEST_ID
1454: ,HEADER_INTERFACE_ROWID
1455: ,INTERFACE_SOURCE_TABLE
1456: ,INTERFACE_ID
1462: ,HEADER_INTERFACE_ID
1463: ,'OKS_IMP_HDR_INVALID_EST_DUR'
1464: ,NULL) */
1465: WHEN (REN_EST_DURPER_VALID = 'N') THEN
1466: INTO OKS_INT_ERROR_STG_TEMP
1467: (CONCURRENT_REQUEST_ID
1468: ,HEADER_INTERFACE_ROWID
1469: ,INTERFACE_SOURCE_TABLE
1470: ,INTERFACE_ID
1476: ,HEADER_INTERFACE_ID
1477: ,'OKS_IMP_HDR_INVALID_DATE_EST'
1478: ,NULL)
1479: WHEN (REN_EST_DURPER_NULL_ERROR = 'Y') THEN
1480: INTO OKS_INT_ERROR_STG_TEMP
1481: (CONCURRENT_REQUEST_ID
1482: ,HEADER_INTERFACE_ROWID
1483: ,INTERFACE_SOURCE_TABLE
1484: ,INTERFACE_ID
1626: l_stmt_num := 30;
1627:
1628: INSERT ALL
1629: WHEN (SALESGROUP_V = 'N') THEN
1630: INTO OKS_INT_ERROR_STG_TEMP
1631: (CONCURRENT_REQUEST_ID
1632: ,HEADER_INTERFACE_ROWID
1633: ,INTERFACE_SOURCE_TABLE
1634: ,INTERFACE_ID
1640: ,HEADER_INTERFACE_ID
1641: ,'OKS_IMP_HDR_INVALID_SALES_G'
1642: ,NULL)
1643: WHEN (QUOTE_TO_PARTY_SITE_V = 'N') THEN
1644: INTO OKS_INT_ERROR_STG_TEMP
1645: (CONCURRENT_REQUEST_ID
1646: ,HEADER_INTERFACE_ROWID
1647: ,INTERFACE_SOURCE_TABLE
1648: ,INTERFACE_ID
1654: ,HEADER_INTERFACE_ID
1655: ,'OKS_IMP_HDR_INVALID_QPS'
1656: ,NULL)
1657: WHEN (QUOTE_TO_CONTACT_V = 'N') THEN
1658: INTO OKS_INT_ERROR_STG_TEMP
1659: (CONCURRENT_REQUEST_ID
1660: ,HEADER_INTERFACE_ROWID
1661: ,INTERFACE_SOURCE_TABLE
1662: ,INTERFACE_ID
1668: ,HEADER_INTERFACE_ID
1669: ,'OKS_IMP_HDR_INVALID_QTC'
1670: ,NULL)
1671: WHEN (QUOTE_TO_PHONE_V = 'N') THEN
1672: INTO OKS_INT_ERROR_STG_TEMP
1673: (CONCURRENT_REQUEST_ID
1674: ,HEADER_INTERFACE_ROWID
1675: ,INTERFACE_SOURCE_TABLE
1676: ,INTERFACE_ID
1682: ,HEADER_INTERFACE_ID
1683: ,'OKS_IMP_HDR_INVALID_QTP'
1684: ,NULL)
1685: WHEN (QUOTE_TO_FAX_V = 'N') THEN
1686: INTO OKS_INT_ERROR_STG_TEMP
1687: (CONCURRENT_REQUEST_ID
1688: ,HEADER_INTERFACE_ROWID
1689: ,INTERFACE_SOURCE_TABLE
1690: ,INTERFACE_ID
1696: ,HEADER_INTERFACE_ID
1697: ,'OKS_IMP_HDR_INVALID_QTF'
1698: ,NULL)
1699: WHEN (QUOTE_TO_EMAIL_V = 'N') THEN
1700: INTO OKS_INT_ERROR_STG_TEMP
1701: (CONCURRENT_REQUEST_ID
1702: ,HEADER_INTERFACE_ROWID
1703: ,INTERFACE_SOURCE_TABLE
1704: ,INTERFACE_ID
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
1714: INTO OKS_INT_ERROR_STG_TEMP
1715: (CONCURRENT_REQUEST_ID
1716: ,HEADER_INTERFACE_ROWID
1717: ,INTERFACE_SOURCE_TABLE
1718: ,INTERFACE_ID
1724: ,HEADER_INTERFACE_ID
1725: ,'OKS_IMP_HDR_INVALID_GRD'
1726: ,NULL)
1727: WHEN (GRPER_V = 'N') THEN
1728: INTO OKS_INT_ERROR_STG_TEMP
1729: (CONCURRENT_REQUEST_ID
1730: ,HEADER_INTERFACE_ROWID
1731: ,INTERFACE_SOURCE_TABLE
1732: ,INTERFACE_ID
1738: ,HEADER_INTERFACE_ID
1739: ,'OKS_IMP_HDR_INVALID_GRP'
1740: ,NULL)
1741: WHEN (GRPER_NULL_ERROR = 'Y') THEN
1742: INTO OKS_INT_ERROR_STG_TEMP
1743: (CONCURRENT_REQUEST_ID
1744: ,HEADER_INTERFACE_ROWID
1745: ,INTERFACE_SOURCE_TABLE
1746: ,INTERFACE_ID
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
1756: INTO OKS_INT_ERROR_STG_TEMP
1757: (CONCURRENT_REQUEST_ID
1758: ,HEADER_INTERFACE_ROWID
1759: ,INTERFACE_SOURCE_TABLE
1760: ,INTERFACE_ID
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
1770: INTO OKS_INT_ERROR_STG_TEMP
1771: (CONCURRENT_REQUEST_ID
1772: ,HEADER_INTERFACE_ROWID
1773: ,INTERFACE_SOURCE_TABLE
1774: ,INTERFACE_ID
1780: ,HEADER_INTERFACE_ID
1781: ,'OKS_IMP_HDR_INVALID_ESTDATE'
1782: ,NULL)
1783: WHEN (EST_DATE_NULL_ERROR = 'Y') THEN
1784: INTO OKS_INT_ERROR_STG_TEMP
1785: (CONCURRENT_REQUEST_ID
1786: ,HEADER_INTERFACE_ROWID
1787: ,INTERFACE_SOURCE_TABLE
1788: ,INTERFACE_ID
1794: ,HEADER_INTERFACE_ID
1795: ,'OKS_IMP_HDR_NULL_ESTDATE'
1796: ,NULL)
1797: WHEN (FA_V = 'N') THEN
1798: INTO OKS_INT_ERROR_STG_TEMP
1799: (CONCURRENT_REQUEST_ID
1800: ,HEADER_INTERFACE_ROWID
1801: ,INTERFACE_SOURCE_TABLE
1802: ,INTERFACE_ID
1808: ,HEADER_INTERFACE_ID
1809: ,'OKS_IMP_HDR_INVALID_FA'
1810: ,NULL)
1811: WHEN (FA_NULL_ERROR = 'Y') THEN
1812: INTO OKS_INT_ERROR_STG_TEMP
1813: (CONCURRENT_REQUEST_ID
1814: ,HEADER_INTERFACE_ROWID
1815: ,INTERFACE_SOURCE_TABLE
1816: ,INTERFACE_ID
1822: ,HEADER_INTERFACE_ID
1823: ,'OKS_IMP_HDR_NULL_FA'
1824: ,NULL)
1825: WHEN (QAC_V = 'N') THEN
1826: INTO OKS_INT_ERROR_STG_TEMP
1827: (CONCURRENT_REQUEST_ID
1828: ,HEADER_INTERFACE_ROWID
1829: ,INTERFACE_SOURCE_TABLE
1830: ,INTERFACE_ID
1836: ,HEADER_INTERFACE_ID
1837: ,'OKS_IMP_HDR_INVALID_QAC'
1838: ,NULL)
1839: WHEN (AP_V = 'N') THEN
1840: INTO OKS_INT_ERROR_STG_TEMP
1841: (CONCURRENT_REQUEST_ID
1842: ,HEADER_INTERFACE_ROWID
1843: ,INTERFACE_SOURCE_TABLE
1844: ,INTERFACE_ID
1850: ,HEADER_INTERFACE_ID
1851: ,'OKS_IMP_HDR_INVALID_AP'
1852: ,NULL)
1853: WHEN (SALESGROUP_NULL_ERROR = 'Y') THEN
1854: INTO OKS_INT_ERROR_STG_TEMP
1855: (CONCURRENT_REQUEST_ID
1856: ,HEADER_INTERFACE_ROWID
1857: ,INTERFACE_SOURCE_TABLE
1858: ,INTERFACE_ID
1945: l_stmt_num := 40;
1946:
1947: INSERT ALL
1948: WHEN (TEC_V = 'N') THEN
1949: INTO OKS_INT_ERROR_STG_TEMP
1950: (CONCURRENT_REQUEST_ID
1951: ,HEADER_INTERFACE_ROWID
1952: ,INTERFACE_SOURCE_TABLE
1953: ,INTERFACE_ID
1959: ,HEADER_INTERFACE_ID
1960: ,'OKS_IMP_HDR_INVALID_TEC'
1961: ,NULL)
1962: WHEN (TUCEF_OU_V = 'N') THEN
1963: INTO OKS_INT_ERROR_STG_TEMP
1964: (CONCURRENT_REQUEST_ID
1965: ,HEADER_INTERFACE_ROWID
1966: ,INTERFACE_SOURCE_TABLE
1967: ,INTERFACE_ID
1973: ,HEADER_INTERFACE_ID
1974: ,'OKS_IMP_HDR_INVALID_TUCEF_OU'
1975: ,NULL)
1976: WHEN (TEN_V = 'N') THEN
1977: INTO OKS_INT_ERROR_STG_TEMP
1978: (CONCURRENT_REQUEST_ID
1979: ,HEADER_INTERFACE_ROWID
1980: ,INTERFACE_SOURCE_TABLE
1981: ,INTERFACE_ID
1987: ,HEADER_INTERFACE_ID
1988: ,'OKS_IMP_HDR_INVALID_TEN'
1989: ,NULL)
1990: WHEN (TEN_NULL_ERROR = 'Y') THEN
1991: INTO OKS_INT_ERROR_STG_TEMP
1992: (CONCURRENT_REQUEST_ID
1993: ,HEADER_INTERFACE_ROWID
1994: ,INTERFACE_SOURCE_TABLE
1995: ,INTERFACE_ID
2001: ,HEADER_INTERFACE_ID
2002: ,'OKS_IMP_HDR_NULL_TEN'
2003: ,NULL)
2004: WHEN (POREQ_V = 'N') THEN
2005: INTO OKS_INT_ERROR_STG_TEMP
2006: (CONCURRENT_REQUEST_ID
2007: ,HEADER_INTERFACE_ROWID
2008: ,INTERFACE_SOURCE_TABLE
2009: ,INTERFACE_ID
2015: ,HEADER_INTERFACE_ID
2016: ,'OKS_IMP_HDR_INVALID_POREQ'
2017: ,NULL)
2018: WHEN (POREQ_NULL_ERROR = 'Y') THEN
2019: INTO OKS_INT_ERROR_STG_TEMP
2020: (CONCURRENT_REQUEST_ID
2021: ,HEADER_INTERFACE_ROWID
2022: ,INTERFACE_SOURCE_TABLE
2023: ,INTERFACE_ID
2029: ,HEADER_INTERFACE_ID
2030: ,'OKS_IMP_HDR_NULL_POREQ'
2031: ,NULL)
2032: WHEN (BS_V = 'N') THEN
2033: INTO OKS_INT_ERROR_STG_TEMP
2034: (CONCURRENT_REQUEST_ID
2035: ,HEADER_INTERFACE_ROWID
2036: ,INTERFACE_SOURCE_TABLE
2037: ,INTERFACE_ID
2043: ,HEADER_INTERFACE_ID
2044: ,'OKS_IMP_HDR_INVALID_BS'
2045: ,NULL)
2046: WHEN (BTXNTYPE_V = 'N') THEN
2047: INTO OKS_INT_ERROR_STG_TEMP
2048: (CONCURRENT_REQUEST_ID
2049: ,HEADER_INTERFACE_ROWID
2050: ,INTERFACE_SOURCE_TABLE
2051: ,INTERFACE_ID
2057: ,HEADER_INTERFACE_ID
2058: ,'OKS_IMP_HDR_INVALID_BTXNTYPE'
2059: ,NULL)
2060: WHEN (HC_V = 'N') THEN
2061: INTO OKS_INT_ERROR_STG_TEMP
2062: (CONCURRENT_REQUEST_ID
2063: ,HEADER_INTERFACE_ROWID
2064: ,INTERFACE_SOURCE_TABLE
2065: ,INTERFACE_ID
2071: ,HEADER_INTERFACE_ID
2072: ,'OKS_IMP_HDR_INVALID_HC'
2073: ,NULL)
2074: WHEN (SP_V = 'N') THEN
2075: INTO OKS_INT_ERROR_STG_TEMP
2076: (CONCURRENT_REQUEST_ID
2077: ,HEADER_INTERFACE_ROWID
2078: ,INTERFACE_SOURCE_TABLE
2079: ,INTERFACE_ID
2085: ,HEADER_INTERFACE_ID
2086: ,'OKS_IMP_HDR_INVALID_SP'
2087: ,NULL)
2088: WHEN (ST_V = 'N') THEN
2089: INTO OKS_INT_ERROR_STG_TEMP
2090: (CONCURRENT_REQUEST_ID
2091: ,HEADER_INTERFACE_ROWID
2092: ,INTERFACE_SOURCE_TABLE
2093: ,INTERFACE_ID
2099: ,HEADER_INTERFACE_ID
2100: ,'OKS_IMP_HDR_INVALID_ST'
2101: ,NULL)
2102: WHEN (SER_CHRG_PREP_REQ_V = 'N') THEN
2103: INTO OKS_INT_ERROR_STG_TEMP
2104: (CONCURRENT_REQUEST_ID
2105: ,HEADER_INTERFACE_ROWID
2106: ,INTERFACE_SOURCE_TABLE
2107: ,INTERFACE_ID
2113: ,HEADER_INTERFACE_ID
2114: ,'OKS_IMP_HDR_INVALID_SCPREQ'
2115: ,NULL)
2116: WHEN (SER_CHRG_PO_REQ_V = 'N') THEN
2117: INTO OKS_INT_ERROR_STG_TEMP
2118: (CONCURRENT_REQUEST_ID
2119: ,HEADER_INTERFACE_ROWID
2120: ,INTERFACE_SOURCE_TABLE
2121: ,INTERFACE_ID
2127: ,HEADER_INTERFACE_ID
2128: ,'OKS_IMP_HDR_INVALID_SCPOREQ'
2129: ,NULL)
2130: WHEN (SOURCE_V = 'N') THEN
2131: INTO OKS_INT_ERROR_STG_TEMP
2132: (CONCURRENT_REQUEST_ID
2133: ,HEADER_INTERFACE_ROWID
2134: ,INTERFACE_SOURCE_TABLE
2135: ,INTERFACE_ID
2141: ,HEADER_INTERFACE_ID
2142: ,'OKS_IMP_HDR_INVALID_SOURCE'
2143: ,NULL)
2144: WHEN (HOI_COUNT = 0) THEN
2145: INTO OKS_INT_ERROR_STG_TEMP
2146: (CONCURRENT_REQUEST_ID
2147: ,HEADER_INTERFACE_ROWID
2148: ,INTERFACE_SOURCE_TABLE
2149: ,INTERFACE_ID
2155: ,HEADER_INTERFACE_ID
2156: ,'OKS_IMP_HST_INVALID_INVORG'
2157: ,NULL)
2158: WHEN (ERC_NULL_ERROR = 'Y') THEN
2159: INTO OKS_INT_ERROR_STG_TEMP
2160: (CONCURRENT_REQUEST_ID
2161: ,HEADER_INTERFACE_ROWID
2162: ,INTERFACE_SOURCE_TABLE
2163: ,INTERFACE_ID
2393: ,AVERAGING_INTERVAL
2394: ,SETTLEMENT_INTERVAL
2395: ,USAGE_TERMINATION_METHOD)
2396: WHEN (LSE_ID IS NULL) THEN
2397: INTO OKS_INT_ERROR_STG_TEMP
2398: (CONCURRENT_REQUEST_ID
2399: ,HEADER_INTERFACE_ROWID
2400: ,INTERFACE_SOURCE_TABLE
2401: ,INTERFACE_ID
2407: ,LINE_INTERFACE_ID
2408: ,'OKS_IMP_LIN_INVALID_LTYPE'
2409: ,NULL)
2410: WHEN (ITEM_ID IS NULL) THEN
2411: INTO OKS_INT_ERROR_STG_TEMP
2412: (CONCURRENT_REQUEST_ID
2413: ,HEADER_INTERFACE_ROWID
2414: ,INTERFACE_SOURCE_TABLE
2415: ,INTERFACE_ID
2421: ,LINE_INTERFACE_ID
2422: ,'OKS_IMP_LIN_INVALID_ITEM'
2423: ,NULL)
2424: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN
2425: INTO OKS_INT_ERROR_STG_TEMP
2426: (CONCURRENT_REQUEST_ID
2427: ,HEADER_INTERFACE_ROWID
2428: ,INTERFACE_SOURCE_TABLE
2429: ,INTERFACE_ID
2435: ,LINE_INTERFACE_ID
2436: ,'OKS_IMP_LIN_INVALID_BTSU'
2437: ,NULL)
2438: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN
2439: INTO OKS_INT_ERROR_STG_TEMP
2440: (CONCURRENT_REQUEST_ID
2441: ,HEADER_INTERFACE_ROWID
2442: ,INTERFACE_SOURCE_TABLE
2443: ,INTERFACE_ID
2449: ,LINE_INTERFACE_ID
2450: ,'OKS_IMP_LIN_INVALID_STSU'
2451: ,NULL)
2452: WHEN (LINE_TYPE IN ('SERVICE', 'EXT_WARRANTY') AND INVOICE_TEXT IS NULL) THEN
2453: INTO OKS_INT_ERROR_STG_TEMP
2454: (CONCURRENT_REQUEST_ID
2455: ,HEADER_INTERFACE_ROWID
2456: ,INTERFACE_SOURCE_TABLE
2457: ,INTERFACE_ID
2465: ,NULL)
2466: /*Commented for bug:9128152*/
2467: /* WHEN (LINE_TYPE IN ('SERVICE', 'EXT_WARRANTY') AND CUSTOMER_BILLING_CONTACT_ID IS NULL)
2468: OR (BILLING_CONTACT_PROVIDED = 'Y' AND CUSTOMER_BILLING_CONTACT_ID IS NULL) THEN
2469: INTO OKS_INT_ERROR_STG_TEMP
2470: (CONCURRENT_REQUEST_ID
2471: ,HEADER_INTERFACE_ROWID
2472: ,INTERFACE_SOURCE_TABLE
2473: ,INTERFACE_ID
2480: ,'OKS_IMP_LIN_INVALID_BC'
2481: ,NULL)
2482: WHEN (LINE_TYPE IN ('SERVICE', 'EXT_WARRANTY') AND CUSTOMER_SHIPPING_CONTACT_ID IS NULL)
2483: OR (SHIPPING_CONTACT_PROVIDED = 'Y' AND CUSTOMER_SHIPPING_CONTACT_ID IS NULL) THEN
2484: INTO OKS_INT_ERROR_STG_TEMP
2485: (CONCURRENT_REQUEST_ID
2486: ,HEADER_INTERFACE_ROWID
2487: ,INTERFACE_SOURCE_TABLE
2488: ,INTERFACE_ID
2494: ,LINE_INTERFACE_ID
2495: ,'OKS_IMP_LIN_INVALID_SC'
2496: ,NULL) */
2497: WHEN (PL_PROVIDED = 'Y' AND PRICE_LIST_ID IS NULL) THEN
2498: INTO OKS_INT_ERROR_STG_TEMP
2499: (CONCURRENT_REQUEST_ID
2500: ,HEADER_INTERFACE_ROWID
2501: ,INTERFACE_SOURCE_TABLE
2502: ,INTERFACE_ID
2508: ,LINE_INTERFACE_ID
2509: ,'OKS_IMP_LIN_INVALID_QP'
2510: ,NULL)
2511: WHEN (LIN_PAYMENT_INSTRUCTION IS NOT NULL AND PAYMENT_INSTRUCTION IS NULL) THEN
2512: INTO OKS_INT_ERROR_STG_TEMP
2513: (CONCURRENT_REQUEST_ID
2514: ,HEADER_INTERFACE_ROWID
2515: ,INTERFACE_SOURCE_TABLE
2516: ,INTERFACE_ID
2522: ,LINE_INTERFACE_ID
2523: ,'OKS_IMP_LIN_INVALID_PAY_INST'
2524: ,NULL)
2525: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN
2526: INTO OKS_INT_ERROR_STG_TEMP
2527: (CONCURRENT_REQUEST_ID
2528: ,HEADER_INTERFACE_ROWID
2529: ,INTERFACE_SOURCE_TABLE
2530: ,INTERFACE_ID
2536: ,LINE_INTERFACE_ID
2537: ,'OKS_IMP_LIN_INVALID_AR'
2538: ,NULL)
2539: WHEN (INVOICING_RULE_ID IS NULL) THEN
2540: INTO OKS_INT_ERROR_STG_TEMP
2541: (CONCURRENT_REQUEST_ID
2542: ,HEADER_INTERFACE_ROWID
2543: ,INTERFACE_SOURCE_TABLE
2544: ,INTERFACE_ID
2550: ,LINE_INTERFACE_ID
2551: ,'OKS_IMP_LIN_INVALID_IR'
2552: ,NULL)
2553: WHEN (LIN_PAYMENT_METHOD_CODE IS NOT NULL AND PAYMENT_METHOD_CODE IS NULL) THEN
2554: INTO OKS_INT_ERROR_STG_TEMP
2555: (CONCURRENT_REQUEST_ID
2556: ,HEADER_INTERFACE_ROWID
2557: ,INTERFACE_SOURCE_TABLE
2558: ,INTERFACE_ID
2564: ,LINE_INTERFACE_ID
2565: ,'OKS_IMP_LIN_INVALID_PMC'
2566: ,NULL)
2567: WHEN ((PAYMENT_METHOD_CODE IS NOT NULL OR LIN_COMMITMENT_ID IS NOT NULL) AND COMMITMENT_ID IS NULL) THEN
2568: INTO OKS_INT_ERROR_STG_TEMP
2569: (CONCURRENT_REQUEST_ID
2570: ,HEADER_INTERFACE_ROWID
2571: ,INTERFACE_SOURCE_TABLE
2572: ,INTERFACE_ID
2578: ,LINE_INTERFACE_ID
2579: ,'OKS_IMP_LIN_INVALID_CN'
2580: ,NULL)
2581: WHEN (LINE_TYPE = 'SUBSCRIPTION' AND (TAX_AMOUNT IS NULL OR TAX_AMOUNT < 0 )) THEN
2582: INTO OKS_INT_ERROR_STG_TEMP
2583: (CONCURRENT_REQUEST_ID
2584: ,HEADER_INTERFACE_ROWID
2585: ,INTERFACE_SOURCE_TABLE
2586: ,INTERFACE_ID
2592: ,LINE_INTERFACE_ID
2593: ,'OKS_IMP_LIN_INVALID_TAX'
2594: ,NULL)
2595: WHEN (LINE_TYPE = 'SUBSCRIPTION' AND (SUBTOTAL IS NULL OR SUBTOTAL < 0 )) THEN
2596: INTO OKS_INT_ERROR_STG_TEMP
2597: (CONCURRENT_REQUEST_ID
2598: ,HEADER_INTERFACE_ROWID
2599: ,INTERFACE_SOURCE_TABLE
2600: ,INTERFACE_ID
2923: l_stmt_num := 20;
2924:
2925: INSERT ALL
2926: WHEN (LINE_NUMBER_V = 'N') THEN
2927: INTO OKS_INT_ERROR_STG_TEMP
2928: (CONCURRENT_REQUEST_ID
2929: ,HEADER_INTERFACE_ROWID
2930: ,INTERFACE_SOURCE_TABLE
2931: ,INTERFACE_ID
2937: ,LINE_INTERFACE_ID
2938: ,'OKS_IMP_LIN_INVALID_LINENUM'
2939: ,NULL)
2940: WHEN (HOI_COUNT = 0) THEN
2941: INTO OKS_INT_ERROR_STG_TEMP
2942: (CONCURRENT_REQUEST_ID
2943: ,HEADER_INTERFACE_ROWID
2944: ,INTERFACE_SOURCE_TABLE
2945: ,INTERFACE_ID
2951: ,LINE_INTERFACE_ID
2952: ,'OKS_IMP_LIN_INVALID_ITMORG'
2953: ,NULL)
2954: WHEN (COVTEM_V = 'N') THEN
2955: INTO OKS_INT_ERROR_STG_TEMP
2956: (CONCURRENT_REQUEST_ID
2957: ,HEADER_INTERFACE_ROWID
2958: ,INTERFACE_SOURCE_TABLE
2959: ,INTERFACE_ID
2965: ,LINE_INTERFACE_ID
2966: ,'OKS_IMP_LIN_INVALID_COVTEM'
2967: ,NULL)
2968: WHEN (STATUS_VALID = 'N') THEN
2969: INTO OKS_INT_ERROR_STG_TEMP
2970: (CONCURRENT_REQUEST_ID
2971: ,HEADER_INTERFACE_ROWID
2972: ,INTERFACE_SOURCE_TABLE
2973: ,INTERFACE_ID
2979: ,LINE_INTERFACE_ID
2980: ,'OKS_IMP_LIN_INVALID_STS'
2981: ,NULL)
2982: WHEN (STATUS_X_DATE_VALID = 'N') THEN
2983: INTO OKS_INT_ERROR_STG_TEMP
2984: (CONCURRENT_REQUEST_ID
2985: ,HEADER_INTERFACE_ROWID
2986: ,INTERFACE_SOURCE_TABLE
2987: ,INTERFACE_ID
2993: ,LINE_INTERFACE_ID
2994: ,'OKS_IMP_LIN_INVALID_STSXDATE'
2995: ,NULL)
2996: WHEN (STS_X_HDRSTS = 'N') THEN
2997: INTO OKS_INT_ERROR_STG_TEMP
2998: (CONCURRENT_REQUEST_ID
2999: ,HEADER_INTERFACE_ROWID
3000: ,INTERFACE_SOURCE_TABLE
3001: ,INTERFACE_ID
3007: ,LINE_INTERFACE_ID
3008: ,'OKS_IMP_LIN_INVALID_STSXHDR'
3009: ,NULL)
3010: WHEN (DATE_VALID = 'N') THEN
3011: INTO OKS_INT_ERROR_STG_TEMP
3012: (CONCURRENT_REQUEST_ID
3013: ,HEADER_INTERFACE_ROWID
3014: ,INTERFACE_SOURCE_TABLE
3015: ,INTERFACE_ID
3021: ,LINE_INTERFACE_ID
3022: ,'OKS_IMP_LIN_INVALID_DATE'
3023: ,NULL)
3024: WHEN (DATE_CANCELED_VALID = 'N') THEN
3025: INTO OKS_INT_ERROR_STG_TEMP
3026: (CONCURRENT_REQUEST_ID
3027: ,HEADER_INTERFACE_ROWID
3028: ,INTERFACE_SOURCE_TABLE
3029: ,INTERFACE_ID
3035: ,LINE_INTERFACE_ID
3036: ,'OKS_IMP_LIN_INVALID_DATECAN'
3037: ,NULL)
3038: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN
3039: INTO OKS_INT_ERROR_STG_TEMP
3040: (CONCURRENT_REQUEST_ID
3041: ,HEADER_INTERFACE_ROWID
3042: ,INTERFACE_SOURCE_TABLE
3043: ,INTERFACE_ID
3049: ,LINE_INTERFACE_ID
3050: ,'OKS_IMP_LIN_NULL_DATECAN'
3051: ,NULL)
3052: WHEN (CR_VALID = 'N') THEN
3053: INTO OKS_INT_ERROR_STG_TEMP
3054: (CONCURRENT_REQUEST_ID
3055: ,HEADER_INTERFACE_ROWID
3056: ,INTERFACE_SOURCE_TABLE
3057: ,INTERFACE_ID
3063: ,LINE_INTERFACE_ID
3064: ,'OKS_IMP_LIN_INVALID_CR'
3065: ,NULL)
3066: WHEN (CR_NULL_ERROR = 'Y') THEN
3067: INTO OKS_INT_ERROR_STG_TEMP
3068: (CONCURRENT_REQUEST_ID
3069: ,HEADER_INTERFACE_ROWID
3070: ,INTERFACE_SOURCE_TABLE
3071: ,INTERFACE_ID
3077: ,LINE_INTERFACE_ID
3078: ,'OKS_IMP_LIN_NULL_CR'
3079: ,NULL)
3080: WHEN (TEC_V = 'N') THEN
3081: INTO OKS_INT_ERROR_STG_TEMP
3082: (CONCURRENT_REQUEST_ID
3083: ,HEADER_INTERFACE_ROWID
3084: ,INTERFACE_SOURCE_TABLE
3085: ,INTERFACE_ID
3091: ,LINE_INTERFACE_ID
3092: ,'OKS_IMP_LIN_INVALID_TEC'
3093: ,NULL)
3094: WHEN (TUCEF_OU_V = 'N') THEN
3095: INTO OKS_INT_ERROR_STG_TEMP
3096: (CONCURRENT_REQUEST_ID
3097: ,HEADER_INTERFACE_ROWID
3098: ,INTERFACE_SOURCE_TABLE
3099: ,INTERFACE_ID
3105: ,LINE_INTERFACE_ID
3106: ,'OKS_IMP_LIN_INVALID_TUCEF_OU'
3107: ,NULL)
3108: WHEN (TEN_V = 'N') THEN
3109: INTO OKS_INT_ERROR_STG_TEMP
3110: (CONCURRENT_REQUEST_ID
3111: ,HEADER_INTERFACE_ROWID
3112: ,INTERFACE_SOURCE_TABLE
3113: ,INTERFACE_ID
3119: ,LINE_INTERFACE_ID
3120: ,'OKS_IMP_LIN_INVALID_TEN'
3121: ,NULL)
3122: WHEN (TEN_NULL_ERROR = 'Y') THEN
3123: INTO OKS_INT_ERROR_STG_TEMP
3124: (CONCURRENT_REQUEST_ID
3125: ,HEADER_INTERFACE_ROWID
3126: ,INTERFACE_SOURCE_TABLE
3127: ,INTERFACE_ID
3133: ,LINE_INTERFACE_ID
3134: ,'OKS_IMP_LIN_NULL_TEN'
3135: ,NULL)
3136: WHEN (ERC_NULL_ERROR = 'Y') THEN
3137: INTO OKS_INT_ERROR_STG_TEMP
3138: (CONCURRENT_REQUEST_ID
3139: ,HEADER_INTERFACE_ROWID
3140: ,INTERFACE_SOURCE_TABLE
3141: ,INTERFACE_ID
3147: ,LINE_INTERFACE_ID
3148: ,'OKS_IMP_LIN_NULL_ERC'
3149: ,NULL)
3150: WHEN (TCC_VALID = 'N') THEN
3151: INTO OKS_INT_ERROR_STG_TEMP
3152: (CONCURRENT_REQUEST_ID
3153: ,HEADER_INTERFACE_ROWID
3154: ,INTERFACE_SOURCE_TABLE
3155: ,INTERFACE_ID
3161: ,LINE_INTERFACE_ID
3162: ,'OKS_IMP_LIN_INVALID_TCC'
3163: ,NULL)
3164: WHEN (REN_TYPE_VALID = 'N') THEN
3165: INTO OKS_INT_ERROR_STG_TEMP
3166: (CONCURRENT_REQUEST_ID
3167: ,HEADER_INTERFACE_ROWID
3168: ,INTERFACE_SOURCE_TABLE
3169: ,INTERFACE_ID
3175: ,LINE_INTERFACE_ID
3176: ,'OKS_IMP_LIN_INVALID_RENTYPE'
3177: ,NULL)
3178: WHEN (PRINT_INVOICE_V = 'N') THEN
3179: INTO OKS_INT_ERROR_STG_TEMP
3180: (CONCURRENT_REQUEST_ID
3181: ,HEADER_INTERFACE_ROWID
3182: ,INTERFACE_SOURCE_TABLE
3183: ,INTERFACE_ID
3189: ,LINE_INTERFACE_ID
3190: ,'OKS_IMP_LIN_INVALID_PRNTINV'
3191: ,NULL)
3192: WHEN (POREQ_V = 'N') THEN
3193: INTO OKS_INT_ERROR_STG_TEMP
3194: (CONCURRENT_REQUEST_ID
3195: ,HEADER_INTERFACE_ROWID
3196: ,INTERFACE_SOURCE_TABLE
3197: ,INTERFACE_ID
3203: ,LINE_INTERFACE_ID
3204: ,'OKS_IMP_LIN_INVALID_POREQ'
3205: ,NULL)
3206: WHEN (POREQ_NULL_ERROR = 'Y') THEN
3207: INTO OKS_INT_ERROR_STG_TEMP
3208: (CONCURRENT_REQUEST_ID
3209: ,HEADER_INTERFACE_ROWID
3210: ,INTERFACE_SOURCE_TABLE
3211: ,INTERFACE_ID
3217: ,LINE_INTERFACE_ID
3218: ,'OKS_IMP_LIN_NULL_POREQ'
3219: ,NULL)
3220: WHEN (TANGIBLE_SUB = 'Y') THEN
3221: INTO OKS_INT_ERROR_STG_TEMP
3222: (CONCURRENT_REQUEST_ID
3223: ,HEADER_INTERFACE_ROWID
3224: ,INTERFACE_SOURCE_TABLE
3225: ,INTERFACE_ID
3345: l_stmt_num := 30;
3346:
3347: INSERT ALL
3348: WHEN (BILL_INT_DUR_V = 'N') THEN
3349: INTO OKS_INT_ERROR_STG_TEMP
3350: (CONCURRENT_REQUEST_ID
3351: ,HEADER_INTERFACE_ROWID
3352: ,INTERFACE_SOURCE_TABLE
3353: ,INTERFACE_ID
3359: ,LINE_INTERFACE_ID
3360: ,'OKS_IMP_LIN_INVALID_BID'
3361: ,NULL)
3362: WHEN (REC_BILL_OCC_V = 'N') THEN
3363: INTO OKS_INT_ERROR_STG_TEMP
3364: (CONCURRENT_REQUEST_ID
3365: ,HEADER_INTERFACE_ROWID
3366: ,INTERFACE_SOURCE_TABLE
3367: ,INTERFACE_ID
3373: ,LINE_INTERFACE_ID
3374: ,'OKS_IMP_LIN_INVALID_RBO'
3375: ,NULL)
3376: WHEN (BILL_INT_DUR_NULL_ERROR = 'Y') THEN
3377: INTO OKS_INT_ERROR_STG_TEMP
3378: (CONCURRENT_REQUEST_ID
3379: ,HEADER_INTERFACE_ROWID
3380: ,INTERFACE_SOURCE_TABLE
3381: ,INTERFACE_ID
3387: ,LINE_INTERFACE_ID
3388: ,'OKS_IMP_LIN_NULL_BID'
3389: ,NULL)
3390: WHEN (BILL_INT_PERIOD_V = 'N') THEN
3391: INTO OKS_INT_ERROR_STG_TEMP
3392: (CONCURRENT_REQUEST_ID
3393: ,HEADER_INTERFACE_ROWID
3394: ,INTERFACE_SOURCE_TABLE
3395: ,INTERFACE_ID
3401: ,LINE_INTERFACE_ID
3402: ,'OKS_IMP_LIN_INVALID_BIP'
3403: ,NULL)
3404: WHEN (FIRST_BILL_V = 'N') THEN
3405: INTO OKS_INT_ERROR_STG_TEMP
3406: (CONCURRENT_REQUEST_ID
3407: ,HEADER_INTERFACE_ROWID
3408: ,INTERFACE_SOURCE_TABLE
3409: ,INTERFACE_ID
3415: ,LINE_INTERFACE_ID
3416: ,'OKS_IMP_LIN_INVALID_FBILL'
3417: ,NULL)
3418: WHEN (SUBQTY_V = 'N') THEN
3419: INTO OKS_INT_ERROR_STG_TEMP
3420: (CONCURRENT_REQUEST_ID
3421: ,HEADER_INTERFACE_ROWID
3422: ,INTERFACE_SOURCE_TABLE
3423: ,INTERFACE_ID
3429: ,LINE_INTERFACE_ID
3430: ,'OKS_IMP_LIN_INVALID_SQTY'
3431: ,NULL)
3432: WHEN (SUOM_VALID = 'N') THEN
3433: INTO OKS_INT_ERROR_STG_TEMP
3434: (CONCURRENT_REQUEST_ID
3435: ,HEADER_INTERFACE_ROWID
3436: ,INTERFACE_SOURCE_TABLE
3437: ,INTERFACE_ID
3443: ,LINE_INTERFACE_ID
3444: ,'OKS_IMP_LIN_INVALID_SUOM'
3445: ,NULL)
3446: WHEN (SUB_NULL_ERROR = 'Y') THEN
3447: INTO OKS_INT_ERROR_STG_TEMP
3448: (CONCURRENT_REQUEST_ID
3449: ,HEADER_INTERFACE_ROWID
3450: ,INTERFACE_SOURCE_TABLE
3451: ,INTERFACE_ID
3457: ,LINE_INTERFACE_ID
3458: ,'OKS_IMP_LIN_NULL_SUB'
3459: ,NULL)
3460: WHEN (PRICE_UOM_V = 'N') THEN
3461: INTO OKS_INT_ERROR_STG_TEMP
3462: (CONCURRENT_REQUEST_ID
3463: ,HEADER_INTERFACE_ROWID
3464: ,INTERFACE_SOURCE_TABLE
3465: ,INTERFACE_ID
3471: ,LINE_INTERFACE_ID
3472: ,'OKS_IMP_LIN_INVALID_PUOM'
3473: ,NULL)
3474: WHEN (USG_TYPE_V = 'N') THEN
3475: INTO OKS_INT_ERROR_STG_TEMP
3476: (CONCURRENT_REQUEST_ID
3477: ,HEADER_INTERFACE_ROWID
3478: ,INTERFACE_SOURCE_TABLE
3479: ,INTERFACE_ID
3485: ,LINE_INTERFACE_ID
3486: ,'OKS_IMP_LIN_INVALID_USGTYPE'
3487: ,NULL)
3488: WHEN (USG_TYPE_NULL_ERROR = 'Y') THEN
3489: INTO OKS_INT_ERROR_STG_TEMP
3490: (CONCURRENT_REQUEST_ID
3491: ,HEADER_INTERFACE_ROWID
3492: ,INTERFACE_SOURCE_TABLE
3493: ,INTERFACE_ID
3499: ,LINE_INTERFACE_ID
3500: ,'OKS_IMP_LIN_NULL_USGTYPE'
3501: ,NULL)
3502: WHEN (USG_PER_V = 'N') THEN
3503: INTO OKS_INT_ERROR_STG_TEMP
3504: (CONCURRENT_REQUEST_ID
3505: ,HEADER_INTERFACE_ROWID
3506: ,INTERFACE_SOURCE_TABLE
3507: ,INTERFACE_ID
3513: ,LINE_INTERFACE_ID
3514: ,'OKS_IMP_LIN_INVALID_USGPER'
3515: ,NULL)
3516: WHEN (USG_PER_NULL_ERROR = 'Y') THEN
3517: INTO OKS_INT_ERROR_STG_TEMP
3518: (CONCURRENT_REQUEST_ID
3519: ,HEADER_INTERFACE_ROWID
3520: ,INTERFACE_SOURCE_TABLE
3521: ,INTERFACE_ID
3527: ,LINE_INTERFACE_ID
3528: ,'OKS_IMP_LIN_NULL_USGPER'
3529: ,NULL)
3530: WHEN (AVG_INT_V = 'N') THEN
3531: INTO OKS_INT_ERROR_STG_TEMP
3532: (CONCURRENT_REQUEST_ID
3533: ,HEADER_INTERFACE_ROWID
3534: ,INTERFACE_SOURCE_TABLE
3535: ,INTERFACE_ID
3541: ,LINE_INTERFACE_ID
3542: ,'OKS_IMP_LIN_INVALID_AVGINT'
3543: ,NULL)
3544: WHEN (AVG_INT_NULL_ERROR = 'Y') THEN
3545: INTO OKS_INT_ERROR_STG_TEMP
3546: (CONCURRENT_REQUEST_ID
3547: ,HEADER_INTERFACE_ROWID
3548: ,INTERFACE_SOURCE_TABLE
3549: ,INTERFACE_ID
3555: ,LINE_INTERFACE_ID
3556: ,'OKS_IMP_LIN_NULL_AVGINT'
3557: ,NULL)
3558: WHEN (STM_INT_V = 'N') THEN
3559: INTO OKS_INT_ERROR_STG_TEMP
3560: (CONCURRENT_REQUEST_ID
3561: ,HEADER_INTERFACE_ROWID
3562: ,INTERFACE_SOURCE_TABLE
3563: ,INTERFACE_ID
3569: ,LINE_INTERFACE_ID
3570: ,'OKS_IMP_LIN_INVALID_STMINT'
3571: ,NULL)
3572: WHEN (STM_INT_NULL_ERROR = 'Y') THEN
3573: INTO OKS_INT_ERROR_STG_TEMP
3574: (CONCURRENT_REQUEST_ID
3575: ,HEADER_INTERFACE_ROWID
3576: ,INTERFACE_SOURCE_TABLE
3577: ,INTERFACE_ID
3583: ,LINE_INTERFACE_ID
3584: ,'OKS_IMP_LIN_NULL_STMINT'
3585: ,NULL)
3586: WHEN (UTM_V = 'N') THEN
3587: INTO OKS_INT_ERROR_STG_TEMP
3588: (CONCURRENT_REQUEST_ID
3589: ,HEADER_INTERFACE_ROWID
3590: ,INTERFACE_SOURCE_TABLE
3591: ,INTERFACE_ID
3597: ,LINE_INTERFACE_ID
3598: ,'OKS_IMP_LIN_INVALID_UTM'
3599: ,NULL)
3600: WHEN (UTM_NULL_ERROR = 'Y') THEN
3601: INTO OKS_INT_ERROR_STG_TEMP
3602: (CONCURRENT_REQUEST_ID
3603: ,HEADER_INTERFACE_ROWID
3604: ,INTERFACE_SOURCE_TABLE
3605: ,INTERFACE_ID
3611: ,LINE_INTERFACE_ID
3612: ,'OKS_IMP_LIN_NULL_UTM'
3613: ,NULL)
3614: WHEN (FIRST_BILLED_AMT_V = 'N') THEN
3615: INTO OKS_INT_ERROR_STG_TEMP
3616: (CONCURRENT_REQUEST_ID
3617: ,HEADER_INTERFACE_ROWID
3618: ,INTERFACE_SOURCE_TABLE
3619: ,INTERFACE_ID
3625: ,LINE_INTERFACE_ID
3626: ,'OKS_IMP_LIN_INVALID_FBA'
3627: ,NULL)
3628: WHEN (FIRST_BILLED_DATE_V = 'N') THEN
3629: INTO OKS_INT_ERROR_STG_TEMP
3630: (CONCURRENT_REQUEST_ID
3631: ,HEADER_INTERFACE_ROWID
3632: ,INTERFACE_SOURCE_TABLE
3633: ,INTERFACE_ID
3639: ,LINE_INTERFACE_ID
3640: ,'OKS_IMP_LIN_INVALID_FBD'
3641: ,NULL)
3642: WHEN (LAST_BILLED_AMT_V = 'N') THEN
3643: INTO OKS_INT_ERROR_STG_TEMP
3644: (CONCURRENT_REQUEST_ID
3645: ,HEADER_INTERFACE_ROWID
3646: ,INTERFACE_SOURCE_TABLE
3647: ,INTERFACE_ID
3653: ,LINE_INTERFACE_ID
3654: ,'OKS_IMP_LIN_INVALID_LBA'
3655: ,NULL)
3656: WHEN (LAST_BILL_DATE_V = 'N') THEN
3657: INTO OKS_INT_ERROR_STG_TEMP
3658: (CONCURRENT_REQUEST_ID
3659: ,HEADER_INTERFACE_ROWID
3660: ,INTERFACE_SOURCE_TABLE
3661: ,INTERFACE_ID
4145: ,COVERED_SITE_ID
4146: ,COVERED_PARTY_ID
4147: ,COVERED_SYSTEM_ID)
4148: WHEN (COV_LINE_INTERFACE_ID IS NOT NULL AND LINE_INTERFACE_ID IS NULL ) THEN
4149: INTO OKS_INT_ERROR_STG_TEMP
4150: (CONCURRENT_REQUEST_ID
4151: ,HEADER_INTERFACE_ROWID
4152: ,INTERFACE_SOURCE_TABLE
4153: ,INTERFACE_ID
4159: ,COVERED_LEVEL_INTERFACE_ID
4160: ,'OKS_IMP_CLVL_INVALID_LINTID'
4161: ,NULL )
4162: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN
4163: INTO OKS_INT_ERROR_STG_TEMP
4164: (CONCURRENT_REQUEST_ID
4165: ,HEADER_INTERFACE_ROWID
4166: ,INTERFACE_SOURCE_TABLE
4167: ,INTERFACE_ID
4173: ,COVERED_LEVEL_INTERFACE_ID
4174: ,'OKS_IMP_CLVL_INVALID_LINNUM'
4175: ,NULL)
4176: WHEN ( STATUS_CODE IS NULL OR STATUS_CLVL_VALID ='N' OR STATUS_LINLVL_VALID='N') THEN
4177: INTO OKS_INT_ERROR_STG_TEMP
4178: (CONCURRENT_REQUEST_ID
4179: ,HEADER_INTERFACE_ROWID
4180: ,INTERFACE_SOURCE_TABLE
4181: ,INTERFACE_ID
4187: ,COVERED_LEVEL_INTERFACE_ID
4188: ,'OKS_IMP_CLVL_INVALID_STSCODE'
4189: ,NULL)
4190: WHEN (DATE_CLVL_VALID ='N' OR DATE_LINLVL_VALID='N') THEN
4191: INTO OKS_INT_ERROR_STG_TEMP
4192: (CONCURRENT_REQUEST_ID
4193: ,HEADER_INTERFACE_ROWID
4194: ,INTERFACE_SOURCE_TABLE
4195: ,INTERFACE_ID
4201: ,COVERED_LEVEL_INTERFACE_ID
4202: ,'OKS_IMP_CLVL_INVALID_DTRANGE'
4203: ,NULL)
4204: WHEN (DATE_CLVL_STS_VALID ='N' ) THEN
4205: INTO OKS_INT_ERROR_STG_TEMP
4206: (CONCURRENT_REQUEST_ID
4207: ,HEADER_INTERFACE_ROWID
4208: ,INTERFACE_SOURCE_TABLE
4209: ,INTERFACE_ID
4215: ,COVERED_LEVEL_INTERFACE_ID
4216: ,'OKS_IMP_CLVL_INVALID_STS_DT'
4217: ,NULL)
4218: WHEN (ST_DT_FST_BILL_YN ='N' ) THEN
4219: INTO OKS_INT_ERROR_STG_TEMP
4220: (CONCURRENT_REQUEST_ID
4221: ,HEADER_INTERFACE_ROWID
4222: ,INTERFACE_SOURCE_TABLE
4223: ,INTERFACE_ID
4230: ,'OKS_IMP_CLVL_INVALID_SDT_FBDT'
4231: ,NULL)
4232:
4233: WHEN (RNWL_TYPE_VALID ='N' ) THEN
4234: INTO OKS_INT_ERROR_STG_TEMP
4235: (CONCURRENT_REQUEST_ID
4236: ,HEADER_INTERFACE_ROWID
4237: ,INTERFACE_SOURCE_TABLE
4238: ,INTERFACE_ID
4244: ,COVERED_LEVEL_INTERFACE_ID
4245: ,'OKS_IMP_CLVL_INVALID_RNMLCD'
4246: ,NULL)
4247: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') THEN
4248: INTO OKS_INT_ERROR_STG_TEMP
4249: (CONCURRENT_REQUEST_ID
4250: ,HEADER_INTERFACE_ROWID
4251: ,INTERFACE_SOURCE_TABLE
4252: ,INTERFACE_ID
4258: ,COVERED_LEVEL_INTERFACE_ID
4259: ,'OKS_IMP_CLVL_INVALID_CNCLDT'
4260: ,NULL)
4261: WHEN (CR_VALID ='N' OR CR_NULL ='Y') THEN
4262: INTO OKS_INT_ERROR_STG_TEMP
4263: (CONCURRENT_REQUEST_ID
4264: ,HEADER_INTERFACE_ROWID
4265: ,INTERFACE_SOURCE_TABLE
4266: ,INTERFACE_ID
4272: ,COVERED_LEVEL_INTERFACE_ID
4273: ,'OKS_IMP_CLVL_INVALID_CNCLRSN'
4274: ,NULL)
4275: WHEN (INVOICE_TEXT IS NULL ) THEN
4276: INTO OKS_INT_ERROR_STG_TEMP
4277: (CONCURRENT_REQUEST_ID
4278: ,HEADER_INTERFACE_ROWID
4279: ,INTERFACE_SOURCE_TABLE
4280: ,INTERFACE_ID
4286: ,COVERED_LEVEL_INTERFACE_ID
4287: ,'OKS_IMP_CLVL_INVALID_INVTXT'
4288: ,NULL)
4289: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <>'N')) THEN
4290: INTO OKS_INT_ERROR_STG_TEMP
4291: (CONCURRENT_REQUEST_ID
4292: ,HEADER_INTERFACE_ROWID
4293: ,INTERFACE_SOURCE_TABLE
4294: ,INTERFACE_ID
4300: ,COVERED_LEVEL_INTERFACE_ID
4301: ,'OKS_IMP_CLVL_INVALID_PRNTINV'
4302: ,NULL)
4303: WHEN (QUANTITY_COVERED IS NULL OR QUANTITY_COVERED <= 0 OR FLOOR(QUANTITY_COVERED) <> QUANTITY_COVERED ) THEN
4304: INTO OKS_INT_ERROR_STG_TEMP
4305: (CONCURRENT_REQUEST_ID
4306: ,HEADER_INTERFACE_ROWID
4307: ,INTERFACE_SOURCE_TABLE
4308: ,INTERFACE_ID
4314: ,COVERED_LEVEL_INTERFACE_ID
4315: ,'OKS_IMP_CLVL_INVALID_QUNTCOV'
4316: ,NULL)
4317: WHEN( QUOM_VALID = 'N' ) THEN
4318: INTO OKS_INT_ERROR_STG_TEMP
4319: (CONCURRENT_REQUEST_ID
4320: ,HEADER_INTERFACE_ROWID
4321: ,INTERFACE_SOURCE_TABLE
4322: ,INTERFACE_ID
4329: ,'OKS_IMP_CLVL_INVALID_QUOM'
4330: ,NULL)
4331: /*WHEN ((COVERED_INSTANCE_ID IS NOT NULL OR COVERED_ITEM_ID IS NOT NULL)
4332: AND (PRICE_UOM IS NULL OR PRUOM_VALID ='N')) THEN
4333: INTO OKS_INT_ERROR_STG_TEMP
4334: (CONCURRENT_REQUEST_ID
4335: ,HEADER_INTERFACE_ROWID
4336: ,INTERFACE_SOURCE_TABLE
4337: ,INTERFACE_ID
4343: ,COVERED_LEVEL_INTERFACE_ID
4344: ,'OKS_IMP_CLVL_INVALID_PRUOM'
4345: ,NULL)*/ /*commented for bug:7804753*/
4346: WHEN ((COVERED_INSTANCE_ID IS NULL AND COVERED_ITEM_ID IS NULL) AND PRICE_UOM IS NOT NULL) THEN
4347: INTO OKS_INT_ERROR_STG_TEMP
4348: (CONCURRENT_REQUEST_ID
4349: ,HEADER_INTERFACE_ROWID
4350: ,INTERFACE_SOURCE_TABLE
4351: ,INTERFACE_ID
4357: ,COVERED_LEVEL_INTERFACE_ID
4358: ,'OKS_IMP_CLVL_INVALID_PRUOMNUL'
4359: ,NULL)
4360: WHEN (SUBTOTAL IS NULL OR SUBTOTAL <0 ) THEN
4361: INTO OKS_INT_ERROR_STG_TEMP
4362: (CONCURRENT_REQUEST_ID
4363: ,HEADER_INTERFACE_ROWID
4364: ,INTERFACE_SOURCE_TABLE
4365: ,INTERFACE_ID
4371: ,COVERED_LEVEL_INTERFACE_ID
4372: ,'OKS_IMP_CLVL_INVALID_SUBTOT'
4373: ,NULL)
4374: WHEN( TAX_AMOUNT IS NULL OR TAX_AMOUNT < 0 ) THEN
4375: INTO OKS_INT_ERROR_STG_TEMP
4376: (CONCURRENT_REQUEST_ID
4377: ,HEADER_INTERFACE_ROWID
4378: ,INTERFACE_SOURCE_TABLE
4379: ,INTERFACE_ID
4386: ,'OKS_IMP_CLVL_INVALID_TAXAMT'
4387: ,NULL)
4388:
4389: WHEN ( TOT_COV_LVL_ATTR <> 1 ) THEN
4390: INTO OKS_INT_ERROR_STG_TEMP
4391: (CONCURRENT_REQUEST_ID
4392: ,HEADER_INTERFACE_ROWID
4393: ,INTERFACE_SOURCE_TABLE
4394: ,INTERFACE_ID
4400: ,COVERED_LEVEL_INTERFACE_ID
4401: ,'OKS_IMP_CLVL_INVALID_CLVLID'
4402: ,NULL)
4403: /* WHEN (FIRST_BILL_AMT_VALID ='N' ) THEN
4404: INTO OKS_INT_ERROR_STG_TEMP
4405: (CONCURRENT_REQUEST_ID
4406: ,HEADER_INTERFACE_ROWID
4407: ,INTERFACE_SOURCE_TABLE
4408: ,INTERFACE_ID
4414: ,COVERED_LEVEL_INTERFACE_ID
4415: ,'OKS_IMP_CLVL_INVALID_FBILAMT'
4416: ,NULL)
4417: WHEN (LAST_BILL_AMT_VALID ='N' ) THEN
4418: INTO OKS_INT_ERROR_STG_TEMP
4419: (CONCURRENT_REQUEST_ID
4420: ,HEADER_INTERFACE_ROWID
4421: ,INTERFACE_SOURCE_TABLE
4422: ,INTERFACE_ID
4428: ,COVERED_LEVEL_INTERFACE_ID
4429: ,'OKS_IMP_CLVL_INVALID_LBILAMT'
4430: ,NULL) */
4431: WHEN ( Nvl(COVERED_ITEM_ID,1) = -99 ) THEN /*skuchima bug16468231 */
4432: INTO OKS_INT_ERROR_STG_TEMP
4433: (CONCURRENT_REQUEST_ID
4434: ,HEADER_INTERFACE_ROWID
4435: ,INTERFACE_SOURCE_TABLE
4436: ,INTERFACE_ID
4442: ,COVERED_LEVEL_INTERFACE_ID
4443: ,'OKS_IMP_CLVL_INVALID_COVERED'
4444: ,NULL)
4445: WHEN ( Nvl(COVERED_PARTY_ID,1) = -99 ) THEN
4446: INTO OKS_INT_ERROR_STG_TEMP
4447: (CONCURRENT_REQUEST_ID
4448: ,HEADER_INTERFACE_ROWID
4449: ,INTERFACE_SOURCE_TABLE
4450: ,INTERFACE_ID
4456: ,COVERED_LEVEL_INTERFACE_ID
4457: ,'OKS_IMP_CLVL_INVALID_COVERED'
4458: ,NULL)
4459: WHEN ( Nvl(COVERED_ACCOUNT_ID,1) = -99 ) THEN
4460: INTO OKS_INT_ERROR_STG_TEMP
4461: (CONCURRENT_REQUEST_ID
4462: ,HEADER_INTERFACE_ROWID
4463: ,INTERFACE_SOURCE_TABLE
4464: ,INTERFACE_ID
4470: ,COVERED_LEVEL_INTERFACE_ID
4471: ,'OKS_IMP_CLVL_INVALID_COVERED'
4472: ,NULL)
4473: WHEN ( Nvl(COVERED_SITE_ID,1) = -99 ) THEN
4474: INTO OKS_INT_ERROR_STG_TEMP
4475: (CONCURRENT_REQUEST_ID
4476: ,HEADER_INTERFACE_ROWID
4477: ,INTERFACE_SOURCE_TABLE
4478: ,INTERFACE_ID
4484: ,COVERED_LEVEL_INTERFACE_ID
4485: ,'OKS_IMP_CLVL_INVALID_COVERED'
4486: ,NULL)
4487: WHEN ( Nvl(COVERED_SYSTEM_ID,1) = -99 ) THEN
4488: INTO OKS_INT_ERROR_STG_TEMP
4489: (CONCURRENT_REQUEST_ID
4490: ,HEADER_INTERFACE_ROWID
4491: ,INTERFACE_SOURCE_TABLE
4492: ,INTERFACE_ID
4819: ,ESTIMATION_METHOD
4820: ,ESTIMATION_START_DATE
4821: ,LEVEL_YN )
4822: WHEN (LINE_INTERFACE_ID IS NOT NULL AND LINSTG_LINE_INTERFACE_ID IS NULL ) THEN
4823: INTO OKS_INT_ERROR_STG_TEMP
4824: (CONCURRENT_REQUEST_ID
4825: ,HEADER_INTERFACE_ROWID
4826: ,INTERFACE_SOURCE_TABLE
4827: ,INTERFACE_ID
4833: , USAGE_COUNTER_INTERFACE_ID
4834: ,'OKS_IMP_UCTR_INVALID_LINTID'
4835: ,NULL )
4836: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN
4837: INTO OKS_INT_ERROR_STG_TEMP
4838: (CONCURRENT_REQUEST_ID
4839: ,HEADER_INTERFACE_ROWID
4840: ,INTERFACE_SOURCE_TABLE
4841: ,INTERFACE_ID
4847: ,USAGE_COUNTER_INTERFACE_ID
4848: ,'OKS_IMP_UCTR_INVALID_LINNUM'
4849: ,NULL)
4850: WHEN (CNTR_VALID_YN = 'N' ) THEN
4851: INTO OKS_INT_ERROR_STG_TEMP
4852: (CONCURRENT_REQUEST_ID
4853: ,HEADER_INTERFACE_ROWID
4854: ,INTERFACE_SOURCE_TABLE
4855: ,INTERFACE_ID
4861: ,USAGE_COUNTER_INTERFACE_ID
4862: ,'OKS_IMP_UCTR_INVALID_CNTRID'
4863: ,NULL)
4864: WHEN (START_DATE IS NULL OR START_DATE_VALID ='N' ) THEN
4865: INTO OKS_INT_ERROR_STG_TEMP
4866: (CONCURRENT_REQUEST_ID
4867: ,HEADER_INTERFACE_ROWID
4868: ,INTERFACE_SOURCE_TABLE
4869: ,INTERFACE_ID
4876: ,'OKS_IMP_UCTR_INVALID_STRDT'
4877: ,NULL)
4878:
4879: WHEN (END_DATE IS NULL OR END_DATE_VALID='N' ) THEN
4880: INTO OKS_INT_ERROR_STG_TEMP
4881: (CONCURRENT_REQUEST_ID
4882: ,HEADER_INTERFACE_ROWID
4883: ,INTERFACE_SOURCE_TABLE
4884: ,INTERFACE_ID
4891: ,'OKS_IMP_UCTR_INVALID_ENDDT'
4892: ,NULL)
4893:
4894: WHEN ((STATUS_CODE IS NULL) OR STATUS_CNTLVL_VALID='N' OR STATUS_USGLINLVL_VALID='N') THEN
4895: INTO OKS_INT_ERROR_STG_TEMP
4896: (CONCURRENT_REQUEST_ID
4897: ,HEADER_INTERFACE_ROWID
4898: ,INTERFACE_SOURCE_TABLE
4899: ,INTERFACE_ID
4905: ,USAGE_COUNTER_INTERFACE_ID
4906: ,'OKS_IMP_UCTR_INVALID_STSCODE'
4907: ,NULL)
4908: WHEN (DATE_USGCNT_STS_VALID ='N') THEN
4909: INTO OKS_INT_ERROR_STG_TEMP
4910: (CONCURRENT_REQUEST_ID
4911: ,HEADER_INTERFACE_ROWID
4912: ,INTERFACE_SOURCE_TABLE
4913: ,INTERFACE_ID
4920: ,'OKS_IMP_USGCNT_INVALID_STS_DT'
4921: ,NULL)
4922:
4923: WHEN (RENEWAL_TYPE_CODE_VALID = '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_RNWLCD'
4936: ,NULL)
4937: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') 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_CNCLDT'
4950: ,NULL)
4951: WHEN (CR_VALID ='N' OR CR_NULL ='Y') 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_CNCLRSN'
4964: ,NULL)
4965: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <> 'N')) THEN
4966: INTO OKS_INT_ERROR_STG_TEMP
4967: (CONCURRENT_REQUEST_ID
4968: ,HEADER_INTERFACE_ROWID
4969: ,INTERFACE_SOURCE_TABLE
4970: ,INTERFACE_ID
4976: ,USAGE_COUNTER_INTERFACE_ID
4977: ,'OKS_IMP_UCTR_INVALID_PRINV'
4978: ,NULL)
4979: WHEN ( SUBTOTAL_VALID = 'N' OR SUBTOTAL <0) THEN
4980: INTO OKS_INT_ERROR_STG_TEMP
4981: (CONCURRENT_REQUEST_ID
4982: ,HEADER_INTERFACE_ROWID
4983: ,INTERFACE_SOURCE_TABLE
4984: ,INTERFACE_ID
4990: ,USAGE_COUNTER_INTERFACE_ID
4991: ,'OKS_IMP_UCTR_INVALID_STOT'
4992: ,NULL)
4993: WHEN (TAX_VALID ='N' OR TAX_AMOUNT < 0 ) THEN
4994: INTO OKS_INT_ERROR_STG_TEMP
4995: (CONCURRENT_REQUEST_ID
4996: ,HEADER_INTERFACE_ROWID
4997: ,INTERFACE_SOURCE_TABLE
4998: ,INTERFACE_ID
5004: ,USAGE_COUNTER_INTERFACE_ID
5005: ,'OKS_IMP_UCTR_INVALID_TAXINV'
5006: ,NULL)
5007: WHEN (FIXED_USG_CNT_VALID = 'N' OR FIXED_USG_CNT_VALID IS NULL OR FIXED_USG_CNT <0 ) THEN
5008: INTO OKS_INT_ERROR_STG_TEMP
5009: (CONCURRENT_REQUEST_ID
5010: ,HEADER_INTERFACE_ROWID
5011: ,INTERFACE_SOURCE_TABLE
5012: ,INTERFACE_ID
5018: ,USAGE_COUNTER_INTERFACE_ID
5019: ,'OKS_IMP_UCTR_INVALID_FIXEDUSG'
5020: ,NULL)
5021: WHEN ( MINIMUM_USG_CNT_VALID ='N' OR MINIMUM_USG_CNT_VALID IS NULL OR MINIMUM_USG_CNT <0 ) THEN
5022: INTO OKS_INT_ERROR_STG_TEMP
5023: (CONCURRENT_REQUEST_ID
5024: ,HEADER_INTERFACE_ROWID
5025: ,INTERFACE_SOURCE_TABLE
5026: ,INTERFACE_ID
5032: ,USAGE_COUNTER_INTERFACE_ID
5033: ,'OKS_IMP_UCTR_INVALID_MINUSG'
5034: ,NULL)
5035: WHEN ( DEFAULT_USG_CNT_VALID='N' OR DEFAULT_USG_CNT_VALID IS NULL OR DEFAULT_USG_CNT < 0 ) THEN
5036: INTO OKS_INT_ERROR_STG_TEMP
5037: (CONCURRENT_REQUEST_ID
5038: ,HEADER_INTERFACE_ROWID
5039: ,INTERFACE_SOURCE_TABLE
5040: ,INTERFACE_ID
5046: ,USAGE_COUNTER_INTERFACE_ID
5047: ,'OKS_IMP_UCTR_INVALID_DEFUSG'
5048: ,NULL)
5049: WHEN (FILL_YN_VALID = 'N' OR ( Nvl(FILL_YN,'Y') <> 'Y' AND Nvl(FILL_YN,'N') <> 'N')) THEN --skuchima bug 12664469
5050: INTO OKS_INT_ERROR_STG_TEMP
5051: (CONCURRENT_REQUEST_ID
5052: ,HEADER_INTERFACE_ROWID
5053: ,INTERFACE_SOURCE_TABLE
5054: ,INTERFACE_ID
5060: ,USAGE_COUNTER_INTERFACE_ID
5061: ,'OKS_IMP_UCTR_INVALID_FILLYN'
5062: ,NULL)
5063: WHEN (ESTIMATION_METHOD_VALID='N' OR ESTMTHD_LKUP_VALID='N') THEN
5064: INTO OKS_INT_ERROR_STG_TEMP
5065: (CONCURRENT_REQUEST_ID
5066: ,HEADER_INTERFACE_ROWID
5067: ,INTERFACE_SOURCE_TABLE
5068: ,INTERFACE_ID
5074: ,USAGE_COUNTER_INTERFACE_ID
5075: ,'OKS_IMP_UCTR_INVALID_ESTMTHD'
5076: ,NULL)
5077: WHEN (EST_STRDT_VALID='N') THEN
5078: INTO OKS_INT_ERROR_STG_TEMP
5079: (CONCURRENT_REQUEST_ID
5080: ,HEADER_INTERFACE_ROWID
5081: ,INTERFACE_SOURCE_TABLE
5082: ,INTERFACE_ID
5088: ,USAGE_COUNTER_INTERFACE_ID
5089: ,'OKS_IMP_UCTR_INVALID_ESTSRTDT'
5090: ,NULL)
5091: WHEN (LEVEL_YN_VALID ='N' OR (LEVEL_YN is not NULL and LEVEL_YN <>'Y' AND LEVEL_YN <>'N')) THEN
5092: INTO OKS_INT_ERROR_STG_TEMP
5093: (CONCURRENT_REQUEST_ID
5094: ,HEADER_INTERFACE_ROWID
5095: ,INTERFACE_SOURCE_TABLE
5096: ,INTERFACE_ID
5332: ,SALESGROUP_ID
5333: ,SALES_CREDIT_TYPE_ID
5334: ,PERCENT)
5335: WHEN (SALESPERSON_ID IS NULL) THEN
5336: INTO OKS_INT_ERROR_STG_TEMP
5337: (CONCURRENT_REQUEST_ID
5338: ,HEADER_INTERFACE_ROWID
5339: ,INTERFACE_SOURCE_TABLE
5340: ,INTERFACE_ID
5346: ,SALES_CREDIT_INTERFACE_ID
5347: ,'OKS_IMP_SC_INVALID_SALEPERS'
5348: ,NULL)
5349: WHEN (SALESGROUP_V = 'N') THEN
5350: INTO OKS_INT_ERROR_STG_TEMP
5351: (CONCURRENT_REQUEST_ID
5352: ,HEADER_INTERFACE_ROWID
5353: ,INTERFACE_SOURCE_TABLE
5354: ,INTERFACE_ID
5360: ,SALES_CREDIT_INTERFACE_ID
5361: ,'OKS_IMP_SC_INVALID_SALEGRP'
5362: ,NULL)
5363: WHEN (SALES_CREDIT_TYPE_ID IS NULL) THEN
5364: INTO OKS_INT_ERROR_STG_TEMP
5365: (CONCURRENT_REQUEST_ID
5366: ,HEADER_INTERFACE_ROWID
5367: ,INTERFACE_SOURCE_TABLE
5368: ,INTERFACE_ID
5374: ,SALES_CREDIT_INTERFACE_ID
5375: ,'OKS_IMP_SC_INVALID_SCT'
5376: ,NULL)
5377: WHEN (QUOTA_FLAG = 'Y' AND PERCENT_SUM <> 100) THEN
5378: INTO OKS_INT_ERROR_STG_TEMP
5379: (CONCURRENT_REQUEST_ID
5380: ,HEADER_INTERFACE_ROWID
5381: ,INTERFACE_SOURCE_TABLE
5382: ,INTERFACE_ID
5389: ,'OKS_IMP_SC_INVALID_PERSUM'
5390: ,NULL)
5391: /*Changes made for bug10295589*/
5392: WHEN (QUOTA_FLAG = 'Y' AND (PERCENT IS NULL OR PERCENT < 0 OR PERCENT > 100)) THEN
5393: INTO OKS_INT_ERROR_STG_TEMP
5394: (CONCURRENT_REQUEST_ID
5395: ,HEADER_INTERFACE_ROWID
5396: ,INTERFACE_SOURCE_TABLE
5397: ,INTERFACE_ID
5406: /*bug 10295589 added new when condition to handle non-quota sales credit percentage
5407: added a new message with name 'OKS_IMP_SC_INVALID_NQ_PER' and the message text to be
5408: 'Enter a percent value greater than 0 for 'Non Quota' type sales persons.'*/
5409: WHEN (QUOTA_FLAG = 'N' AND (PERCENT IS NULL OR PERCENT < 0 )) THEN
5410: INTO OKS_INT_ERROR_STG_TEMP
5411: (CONCURRENT_REQUEST_ID
5412: ,HEADER_INTERFACE_ROWID
5413: ,INTERFACE_SOURCE_TABLE
5414: ,INTERFACE_ID
5420: ,SALES_CREDIT_INTERFACE_ID
5421: ,'OKS_IMP_SC_INVALID_NQ_PER'
5422: ,NULL)
5423: WHEN (UNIQ = 'N') THEN
5424: INTO OKS_INT_ERROR_STG_TEMP
5425: (CONCURRENT_REQUEST_ID
5426: ,HEADER_INTERFACE_ROWID
5427: ,INTERFACE_SOURCE_TABLE
5428: ,INTERFACE_ID
5544: l_stmt_num := 10;
5545:
5546: INSERT ALL
5547: WHEN (NOTE_STATUS_VALID ='N' ) THEN
5548: INTO OKS_INT_ERROR_STG_TEMP
5549: (CONCURRENT_REQUEST_ID
5550: ,HEADER_INTERFACE_ROWID
5551: ,INTERFACE_SOURCE_TABLE
5552: ,INTERFACE_ID
5558: ,NOTES_INTERFACE_ID
5559: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5560: ,NULL)
5561: WHEN (NOTE_TYPE_VALID='N') THEN
5562: INTO OKS_INT_ERROR_STG_TEMP
5563: (CONCURRENT_REQUEST_ID
5564: ,HEADER_INTERFACE_ROWID
5565: ,INTERFACE_SOURCE_TABLE
5566: ,INTERFACE_ID
5572: ,NOTES_INTERFACE_ID
5573: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5574: ,NULL)
5575: WHEN (ENTERED_BY_VALID ='N') THEN
5576: INTO OKS_INT_ERROR_STG_TEMP
5577: (CONCURRENT_REQUEST_ID
5578: ,HEADER_INTERFACE_ROWID
5579: ,INTERFACE_SOURCE_TABLE
5580: ,INTERFACE_ID
5586: ,NOTES_INTERFACE_ID
5587: ,'OKS_IMP_NTINT_INVALID_USR'
5588: ,NULL)
5589: WHEN (ENTERED_DT_VALID ='N') THEN
5590: INTO OKS_INT_ERROR_STG_TEMP
5591: (CONCURRENT_REQUEST_ID
5592: ,HEADER_INTERFACE_ROWID
5593: ,INTERFACE_SOURCE_TABLE
5594: ,INTERFACE_ID
5600: ,NOTES_INTERFACE_ID
5601: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5602: ,NULL)
5603: WHEN (NOTES IS NULL ) THEN
5604: INTO OKS_INT_ERROR_STG_TEMP
5605: (CONCURRENT_REQUEST_ID
5606: ,HEADER_INTERFACE_ROWID
5607: ,INTERFACE_SOURCE_TABLE
5608: ,INTERFACE_ID
5657: l_stmt_num := 20;
5658:
5659: INSERT ALL
5660: WHEN (NOTE_STATUS_VALID ='N' ) THEN
5661: INTO OKS_INT_ERROR_STG_TEMP
5662: (CONCURRENT_REQUEST_ID
5663: ,HEADER_INTERFACE_ROWID
5664: ,INTERFACE_SOURCE_TABLE
5665: ,INTERFACE_ID
5671: ,NOTES_INTERFACE_ID
5672: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5673: ,NULL)
5674: WHEN (NOTE_TYPE_VALID='N') THEN
5675: INTO OKS_INT_ERROR_STG_TEMP
5676: (CONCURRENT_REQUEST_ID
5677: ,HEADER_INTERFACE_ROWID
5678: ,INTERFACE_SOURCE_TABLE
5679: ,INTERFACE_ID
5685: ,NOTES_INTERFACE_ID
5686: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5687: ,NULL)
5688: WHEN (ENTERED_BY_VALID ='N') THEN
5689: INTO OKS_INT_ERROR_STG_TEMP
5690: (CONCURRENT_REQUEST_ID
5691: ,HEADER_INTERFACE_ROWID
5692: ,INTERFACE_SOURCE_TABLE
5693: ,INTERFACE_ID
5699: ,NOTES_INTERFACE_ID
5700: ,'OKS_IMP_NTINT_INVALID_USR'
5701: ,NULL)
5702: WHEN (ENTERED_DT_VALID ='N') THEN
5703: INTO OKS_INT_ERROR_STG_TEMP
5704: (CONCURRENT_REQUEST_ID
5705: ,HEADER_INTERFACE_ROWID
5706: ,INTERFACE_SOURCE_TABLE
5707: ,INTERFACE_ID
5713: ,NOTES_INTERFACE_ID
5714: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5715: ,NULL)
5716: WHEN (NOTES IS NULL ) THEN
5717: INTO OKS_INT_ERROR_STG_TEMP
5718: (CONCURRENT_REQUEST_ID
5719: ,HEADER_INTERFACE_ROWID
5720: ,INTERFACE_SOURCE_TABLE
5721: ,INTERFACE_ID