eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IMPORT_VALIDATE dependencies on OKS_LINES_INTERFACE

Line 2406: ,'OKS_LINES_INTERFACE'

2402: ,ERROR_MSG
2403: ,MSG_TOKENS)
2404: VALUES (G_WORKER_REQ_ID
2405: ,HEADER_INTERFACE_ROWID
2406: ,'OKS_LINES_INTERFACE'
2407: ,LINE_INTERFACE_ID
2408: ,'OKS_IMP_LIN_INVALID_LTYPE'
2409: ,NULL)
2410: WHEN (ITEM_ID IS NULL) THEN

Line 2420: ,'OKS_LINES_INTERFACE'

2416: ,ERROR_MSG
2417: ,MSG_TOKENS)
2418: VALUES (G_WORKER_REQ_ID
2419: ,HEADER_INTERFACE_ROWID
2420: ,'OKS_LINES_INTERFACE'
2421: ,LINE_INTERFACE_ID
2422: ,'OKS_IMP_LIN_INVALID_ITEM'
2423: ,NULL)
2424: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN

Line 2434: ,'OKS_LINES_INTERFACE'

2430: ,ERROR_MSG
2431: ,MSG_TOKENS)
2432: VALUES (G_WORKER_REQ_ID
2433: ,HEADER_INTERFACE_ROWID
2434: ,'OKS_LINES_INTERFACE'
2435: ,LINE_INTERFACE_ID
2436: ,'OKS_IMP_LIN_INVALID_BTSU'
2437: ,NULL)
2438: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN

Line 2448: ,'OKS_LINES_INTERFACE'

2444: ,ERROR_MSG
2445: ,MSG_TOKENS)
2446: VALUES (G_WORKER_REQ_ID
2447: ,HEADER_INTERFACE_ROWID
2448: ,'OKS_LINES_INTERFACE'
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

Line 2462: ,'OKS_LINES_INTERFACE'

2458: ,ERROR_MSG
2459: ,MSG_TOKENS)
2460: VALUES (G_WORKER_REQ_ID
2461: ,HEADER_INTERFACE_ROWID
2462: ,'OKS_LINES_INTERFACE'
2463: ,LINE_INTERFACE_ID
2464: ,'OKS_IMP_LIN_INVALID_INVTXT'
2465: ,NULL)
2466: /*Commented for bug:9128152*/

Line 2478: ,'OKS_LINES_INTERFACE'

2474: ,ERROR_MSG
2475: ,MSG_TOKENS)
2476: VALUES (G_WORKER_REQ_ID
2477: ,HEADER_INTERFACE_ROWID
2478: ,'OKS_LINES_INTERFACE'
2479: ,LINE_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)

Line 2493: ,'OKS_LINES_INTERFACE'

2489: ,ERROR_MSG
2490: ,MSG_TOKENS)
2491: VALUES (G_WORKER_REQ_ID
2492: ,HEADER_INTERFACE_ROWID
2493: ,'OKS_LINES_INTERFACE'
2494: ,LINE_INTERFACE_ID
2495: ,'OKS_IMP_LIN_INVALID_SC'
2496: ,NULL) */
2497: WHEN (PL_PROVIDED = 'Y' AND PRICE_LIST_ID IS NULL) THEN

Line 2507: ,'OKS_LINES_INTERFACE'

2503: ,ERROR_MSG
2504: ,MSG_TOKENS)
2505: VALUES (G_WORKER_REQ_ID
2506: ,HEADER_INTERFACE_ROWID
2507: ,'OKS_LINES_INTERFACE'
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

Line 2521: ,'OKS_LINES_INTERFACE'

2517: ,ERROR_MSG
2518: ,MSG_TOKENS)
2519: VALUES (G_WORKER_REQ_ID
2520: ,HEADER_INTERFACE_ROWID
2521: ,'OKS_LINES_INTERFACE'
2522: ,LINE_INTERFACE_ID
2523: ,'OKS_IMP_LIN_INVALID_PAY_INST'
2524: ,NULL)
2525: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN

Line 2535: ,'OKS_LINES_INTERFACE'

2531: ,ERROR_MSG
2532: ,MSG_TOKENS)
2533: VALUES (G_WORKER_REQ_ID
2534: ,HEADER_INTERFACE_ROWID
2535: ,'OKS_LINES_INTERFACE'
2536: ,LINE_INTERFACE_ID
2537: ,'OKS_IMP_LIN_INVALID_AR'
2538: ,NULL)
2539: WHEN (INVOICING_RULE_ID IS NULL) THEN

Line 2549: ,'OKS_LINES_INTERFACE'

2545: ,ERROR_MSG
2546: ,MSG_TOKENS)
2547: VALUES (G_WORKER_REQ_ID
2548: ,HEADER_INTERFACE_ROWID
2549: ,'OKS_LINES_INTERFACE'
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

Line 2563: ,'OKS_LINES_INTERFACE'

2559: ,ERROR_MSG
2560: ,MSG_TOKENS)
2561: VALUES (G_WORKER_REQ_ID
2562: ,HEADER_INTERFACE_ROWID
2563: ,'OKS_LINES_INTERFACE'
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

Line 2577: ,'OKS_LINES_INTERFACE'

2573: ,ERROR_MSG
2574: ,MSG_TOKENS)
2575: VALUES (G_WORKER_REQ_ID
2576: ,HEADER_INTERFACE_ROWID
2577: ,'OKS_LINES_INTERFACE'
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

Line 2591: ,'OKS_LINES_INTERFACE'

2587: ,ERROR_MSG
2588: ,MSG_TOKENS)
2589: VALUES (G_WORKER_REQ_ID
2590: ,HEADER_INTERFACE_ROWID
2591: ,'OKS_LINES_INTERFACE'
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

Line 2605: ,'OKS_LINES_INTERFACE'

2601: ,ERROR_MSG
2602: ,MSG_TOKENS)
2603: VALUES (G_WORKER_REQ_ID
2604: ,HEADER_INTERFACE_ROWID
2605: ,'OKS_LINES_INTERFACE'
2606: ,LINE_INTERFACE_ID
2607: ,'OKS_IMP_LIN_INVALID_TOT'
2608: ,NULL)
2609: SELECT OLI.LINE_INTERFACE_ID LINE_INTERFACE_ID

Line 2724: FROM OKS_LINES_INTERFACE OLI

2720: ELSE NULL
2721: END)
2722: ELSE NULL
2723: END) LAST_BILL_FROM_DATE
2724: FROM OKS_LINES_INTERFACE OLI
2725: ,OKS_INT_HEADER_STG_TEMP HDR
2726: ,FND_LOOKUPS FL
2727: ,RA_CUSTOMER_TRX_ALL CNI
2728: ,FND_LOOKUPS PMC

Line 2805: FROM OKS_LINES_INTERFACE LNI

2801: /*,COUNT(DISTINCT BCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) BCN_COUNT
2802: ,MAX(BCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) BCN_ID -- Billing contact id based on Name
2803: ,COUNT(DISTINCT SCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) SCN_COUNT
2804: ,MAX(SCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) SCN_ID -- Shipping contact id based on Name */
2805: FROM OKS_LINES_INTERFACE LNI
2806: ,OKS_INT_HEADER_STG_TEMP HST
2807: ,QP_LIST_HEADERS_B QPI
2808: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2809: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

Line 2909: SELECT count(1) INTO l_int_count FROM OKS_LINES_INTERFACE OLI

2905: AND BIPTL.language(+)=USERENV('LANG'); /* Added for Bug:9019205*/
2906:
2907: IF G_STMT_LOG THEN
2908:
2909: SELECT count(1) INTO l_int_count FROM OKS_LINES_INTERFACE OLI
2910: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
2911: WHERE HEADER_INTERFACE_ID = OLI.HEADER_INTERFACE_ID);
2912:
2913: SELECT count(1) INTO l_stg_count FROM OKS_INT_LINE_STG_TEMP;

Line 2936: ,'OKS_LINES_INTERFACE'

2932: ,ERROR_MSG
2933: ,MSG_TOKENS)
2934: VALUES (G_WORKER_REQ_ID
2935: ,HEADER_INTERFACE_ROWID
2936: ,'OKS_LINES_INTERFACE'
2937: ,LINE_INTERFACE_ID
2938: ,'OKS_IMP_LIN_INVALID_LINENUM'
2939: ,NULL)
2940: WHEN (HOI_COUNT = 0) THEN

Line 2950: ,'OKS_LINES_INTERFACE'

2946: ,ERROR_MSG
2947: ,MSG_TOKENS)
2948: VALUES (G_WORKER_REQ_ID
2949: ,HEADER_INTERFACE_ROWID
2950: ,'OKS_LINES_INTERFACE'
2951: ,LINE_INTERFACE_ID
2952: ,'OKS_IMP_LIN_INVALID_ITMORG'
2953: ,NULL)
2954: WHEN (COVTEM_V = 'N') THEN

Line 2964: ,'OKS_LINES_INTERFACE'

2960: ,ERROR_MSG
2961: ,MSG_TOKENS)
2962: VALUES (G_WORKER_REQ_ID
2963: ,HEADER_INTERFACE_ROWID
2964: ,'OKS_LINES_INTERFACE'
2965: ,LINE_INTERFACE_ID
2966: ,'OKS_IMP_LIN_INVALID_COVTEM'
2967: ,NULL)
2968: WHEN (STATUS_VALID = 'N') THEN

Line 2978: ,'OKS_LINES_INTERFACE'

2974: ,ERROR_MSG
2975: ,MSG_TOKENS)
2976: VALUES (G_WORKER_REQ_ID
2977: ,HEADER_INTERFACE_ROWID
2978: ,'OKS_LINES_INTERFACE'
2979: ,LINE_INTERFACE_ID
2980: ,'OKS_IMP_LIN_INVALID_STS'
2981: ,NULL)
2982: WHEN (STATUS_X_DATE_VALID = 'N') THEN

Line 2992: ,'OKS_LINES_INTERFACE'

2988: ,ERROR_MSG
2989: ,MSG_TOKENS)
2990: VALUES (G_WORKER_REQ_ID
2991: ,HEADER_INTERFACE_ROWID
2992: ,'OKS_LINES_INTERFACE'
2993: ,LINE_INTERFACE_ID
2994: ,'OKS_IMP_LIN_INVALID_STSXDATE'
2995: ,NULL)
2996: WHEN (STS_X_HDRSTS = 'N') THEN

Line 3006: ,'OKS_LINES_INTERFACE'

3002: ,ERROR_MSG
3003: ,MSG_TOKENS)
3004: VALUES (G_WORKER_REQ_ID
3005: ,HEADER_INTERFACE_ROWID
3006: ,'OKS_LINES_INTERFACE'
3007: ,LINE_INTERFACE_ID
3008: ,'OKS_IMP_LIN_INVALID_STSXHDR'
3009: ,NULL)
3010: WHEN (DATE_VALID = 'N') THEN

Line 3020: ,'OKS_LINES_INTERFACE'

3016: ,ERROR_MSG
3017: ,MSG_TOKENS)
3018: VALUES (G_WORKER_REQ_ID
3019: ,HEADER_INTERFACE_ROWID
3020: ,'OKS_LINES_INTERFACE'
3021: ,LINE_INTERFACE_ID
3022: ,'OKS_IMP_LIN_INVALID_DATE'
3023: ,NULL)
3024: WHEN (DATE_CANCELED_VALID = 'N') THEN

Line 3034: ,'OKS_LINES_INTERFACE'

3030: ,ERROR_MSG
3031: ,MSG_TOKENS)
3032: VALUES (G_WORKER_REQ_ID
3033: ,HEADER_INTERFACE_ROWID
3034: ,'OKS_LINES_INTERFACE'
3035: ,LINE_INTERFACE_ID
3036: ,'OKS_IMP_LIN_INVALID_DATECAN'
3037: ,NULL)
3038: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN

Line 3048: ,'OKS_LINES_INTERFACE'

3044: ,ERROR_MSG
3045: ,MSG_TOKENS)
3046: VALUES (G_WORKER_REQ_ID
3047: ,HEADER_INTERFACE_ROWID
3048: ,'OKS_LINES_INTERFACE'
3049: ,LINE_INTERFACE_ID
3050: ,'OKS_IMP_LIN_NULL_DATECAN'
3051: ,NULL)
3052: WHEN (CR_VALID = 'N') THEN

Line 3062: ,'OKS_LINES_INTERFACE'

3058: ,ERROR_MSG
3059: ,MSG_TOKENS)
3060: VALUES (G_WORKER_REQ_ID
3061: ,HEADER_INTERFACE_ROWID
3062: ,'OKS_LINES_INTERFACE'
3063: ,LINE_INTERFACE_ID
3064: ,'OKS_IMP_LIN_INVALID_CR'
3065: ,NULL)
3066: WHEN (CR_NULL_ERROR = 'Y') THEN

Line 3076: ,'OKS_LINES_INTERFACE'

3072: ,ERROR_MSG
3073: ,MSG_TOKENS)
3074: VALUES (G_WORKER_REQ_ID
3075: ,HEADER_INTERFACE_ROWID
3076: ,'OKS_LINES_INTERFACE'
3077: ,LINE_INTERFACE_ID
3078: ,'OKS_IMP_LIN_NULL_CR'
3079: ,NULL)
3080: WHEN (TEC_V = 'N') THEN

Line 3090: ,'OKS_LINES_INTERFACE'

3086: ,ERROR_MSG
3087: ,MSG_TOKENS)
3088: VALUES (G_WORKER_REQ_ID
3089: ,HEADER_INTERFACE_ROWID
3090: ,'OKS_LINES_INTERFACE'
3091: ,LINE_INTERFACE_ID
3092: ,'OKS_IMP_LIN_INVALID_TEC'
3093: ,NULL)
3094: WHEN (TUCEF_OU_V = 'N') THEN

Line 3104: ,'OKS_LINES_INTERFACE'

3100: ,ERROR_MSG
3101: ,MSG_TOKENS)
3102: VALUES (G_WORKER_REQ_ID
3103: ,HEADER_INTERFACE_ROWID
3104: ,'OKS_LINES_INTERFACE'
3105: ,LINE_INTERFACE_ID
3106: ,'OKS_IMP_LIN_INVALID_TUCEF_OU'
3107: ,NULL)
3108: WHEN (TEN_V = 'N') THEN

Line 3118: ,'OKS_LINES_INTERFACE'

3114: ,ERROR_MSG
3115: ,MSG_TOKENS)
3116: VALUES (G_WORKER_REQ_ID
3117: ,HEADER_INTERFACE_ROWID
3118: ,'OKS_LINES_INTERFACE'
3119: ,LINE_INTERFACE_ID
3120: ,'OKS_IMP_LIN_INVALID_TEN'
3121: ,NULL)
3122: WHEN (TEN_NULL_ERROR = 'Y') THEN

Line 3132: ,'OKS_LINES_INTERFACE'

3128: ,ERROR_MSG
3129: ,MSG_TOKENS)
3130: VALUES (G_WORKER_REQ_ID
3131: ,HEADER_INTERFACE_ROWID
3132: ,'OKS_LINES_INTERFACE'
3133: ,LINE_INTERFACE_ID
3134: ,'OKS_IMP_LIN_NULL_TEN'
3135: ,NULL)
3136: WHEN (ERC_NULL_ERROR = 'Y') THEN

Line 3146: ,'OKS_LINES_INTERFACE'

3142: ,ERROR_MSG
3143: ,MSG_TOKENS)
3144: VALUES (G_WORKER_REQ_ID
3145: ,HEADER_INTERFACE_ROWID
3146: ,'OKS_LINES_INTERFACE'
3147: ,LINE_INTERFACE_ID
3148: ,'OKS_IMP_LIN_NULL_ERC'
3149: ,NULL)
3150: WHEN (TCC_VALID = 'N') THEN

Line 3160: ,'OKS_LINES_INTERFACE'

3156: ,ERROR_MSG
3157: ,MSG_TOKENS)
3158: VALUES (G_WORKER_REQ_ID
3159: ,HEADER_INTERFACE_ROWID
3160: ,'OKS_LINES_INTERFACE'
3161: ,LINE_INTERFACE_ID
3162: ,'OKS_IMP_LIN_INVALID_TCC'
3163: ,NULL)
3164: WHEN (REN_TYPE_VALID = 'N') THEN

Line 3174: ,'OKS_LINES_INTERFACE'

3170: ,ERROR_MSG
3171: ,MSG_TOKENS)
3172: VALUES (G_WORKER_REQ_ID
3173: ,HEADER_INTERFACE_ROWID
3174: ,'OKS_LINES_INTERFACE'
3175: ,LINE_INTERFACE_ID
3176: ,'OKS_IMP_LIN_INVALID_RENTYPE'
3177: ,NULL)
3178: WHEN (PRINT_INVOICE_V = 'N') THEN

Line 3188: ,'OKS_LINES_INTERFACE'

3184: ,ERROR_MSG
3185: ,MSG_TOKENS)
3186: VALUES (G_WORKER_REQ_ID
3187: ,HEADER_INTERFACE_ROWID
3188: ,'OKS_LINES_INTERFACE'
3189: ,LINE_INTERFACE_ID
3190: ,'OKS_IMP_LIN_INVALID_PRNTINV'
3191: ,NULL)
3192: WHEN (POREQ_V = 'N') THEN

Line 3202: ,'OKS_LINES_INTERFACE'

3198: ,ERROR_MSG
3199: ,MSG_TOKENS)
3200: VALUES (G_WORKER_REQ_ID
3201: ,HEADER_INTERFACE_ROWID
3202: ,'OKS_LINES_INTERFACE'
3203: ,LINE_INTERFACE_ID
3204: ,'OKS_IMP_LIN_INVALID_POREQ'
3205: ,NULL)
3206: WHEN (POREQ_NULL_ERROR = 'Y') THEN

Line 3216: ,'OKS_LINES_INTERFACE'

3212: ,ERROR_MSG
3213: ,MSG_TOKENS)
3214: VALUES (G_WORKER_REQ_ID
3215: ,HEADER_INTERFACE_ROWID
3216: ,'OKS_LINES_INTERFACE'
3217: ,LINE_INTERFACE_ID
3218: ,'OKS_IMP_LIN_NULL_POREQ'
3219: ,NULL)
3220: WHEN (TANGIBLE_SUB = 'Y') THEN

Line 3230: ,'OKS_LINES_INTERFACE'

3226: ,ERROR_MSG
3227: ,MSG_TOKENS)
3228: VALUES (G_WORKER_REQ_ID
3229: ,HEADER_INTERFACE_ROWID
3230: ,'OKS_LINES_INTERFACE'
3231: ,LINE_INTERFACE_ID
3232: ,'OKS_IMP_LIN_TAN_SUB'
3233: ,NULL)
3234: SELECT LST.LINE_INTERFACE_ID LINE_INTERFACE_ID

Line 3358: ,'OKS_LINES_INTERFACE'

3354: ,ERROR_MSG
3355: ,MSG_TOKENS)
3356: VALUES (G_WORKER_REQ_ID
3357: ,HEADER_INTERFACE_ROWID
3358: ,'OKS_LINES_INTERFACE'
3359: ,LINE_INTERFACE_ID
3360: ,'OKS_IMP_LIN_INVALID_BID'
3361: ,NULL)
3362: WHEN (REC_BILL_OCC_V = 'N') THEN

Line 3372: ,'OKS_LINES_INTERFACE'

3368: ,ERROR_MSG
3369: ,MSG_TOKENS)
3370: VALUES (G_WORKER_REQ_ID
3371: ,HEADER_INTERFACE_ROWID
3372: ,'OKS_LINES_INTERFACE'
3373: ,LINE_INTERFACE_ID
3374: ,'OKS_IMP_LIN_INVALID_RBO'
3375: ,NULL)
3376: WHEN (BILL_INT_DUR_NULL_ERROR = 'Y') THEN

Line 3386: ,'OKS_LINES_INTERFACE'

3382: ,ERROR_MSG
3383: ,MSG_TOKENS)
3384: VALUES (G_WORKER_REQ_ID
3385: ,HEADER_INTERFACE_ROWID
3386: ,'OKS_LINES_INTERFACE'
3387: ,LINE_INTERFACE_ID
3388: ,'OKS_IMP_LIN_NULL_BID'
3389: ,NULL)
3390: WHEN (BILL_INT_PERIOD_V = 'N') THEN

Line 3400: ,'OKS_LINES_INTERFACE'

3396: ,ERROR_MSG
3397: ,MSG_TOKENS)
3398: VALUES (G_WORKER_REQ_ID
3399: ,HEADER_INTERFACE_ROWID
3400: ,'OKS_LINES_INTERFACE'
3401: ,LINE_INTERFACE_ID
3402: ,'OKS_IMP_LIN_INVALID_BIP'
3403: ,NULL)
3404: WHEN (FIRST_BILL_V = 'N') THEN

Line 3414: ,'OKS_LINES_INTERFACE'

3410: ,ERROR_MSG
3411: ,MSG_TOKENS)
3412: VALUES (G_WORKER_REQ_ID
3413: ,HEADER_INTERFACE_ROWID
3414: ,'OKS_LINES_INTERFACE'
3415: ,LINE_INTERFACE_ID
3416: ,'OKS_IMP_LIN_INVALID_FBILL'
3417: ,NULL)
3418: WHEN (SUBQTY_V = 'N') THEN

Line 3428: ,'OKS_LINES_INTERFACE'

3424: ,ERROR_MSG
3425: ,MSG_TOKENS)
3426: VALUES (G_WORKER_REQ_ID
3427: ,HEADER_INTERFACE_ROWID
3428: ,'OKS_LINES_INTERFACE'
3429: ,LINE_INTERFACE_ID
3430: ,'OKS_IMP_LIN_INVALID_SQTY'
3431: ,NULL)
3432: WHEN (SUOM_VALID = 'N') THEN

Line 3442: ,'OKS_LINES_INTERFACE'

3438: ,ERROR_MSG
3439: ,MSG_TOKENS)
3440: VALUES (G_WORKER_REQ_ID
3441: ,HEADER_INTERFACE_ROWID
3442: ,'OKS_LINES_INTERFACE'
3443: ,LINE_INTERFACE_ID
3444: ,'OKS_IMP_LIN_INVALID_SUOM'
3445: ,NULL)
3446: WHEN (SUB_NULL_ERROR = 'Y') THEN

Line 3456: ,'OKS_LINES_INTERFACE'

3452: ,ERROR_MSG
3453: ,MSG_TOKENS)
3454: VALUES (G_WORKER_REQ_ID
3455: ,HEADER_INTERFACE_ROWID
3456: ,'OKS_LINES_INTERFACE'
3457: ,LINE_INTERFACE_ID
3458: ,'OKS_IMP_LIN_NULL_SUB'
3459: ,NULL)
3460: WHEN (PRICE_UOM_V = 'N') THEN

Line 3470: ,'OKS_LINES_INTERFACE'

3466: ,ERROR_MSG
3467: ,MSG_TOKENS)
3468: VALUES (G_WORKER_REQ_ID
3469: ,HEADER_INTERFACE_ROWID
3470: ,'OKS_LINES_INTERFACE'
3471: ,LINE_INTERFACE_ID
3472: ,'OKS_IMP_LIN_INVALID_PUOM'
3473: ,NULL)
3474: WHEN (USG_TYPE_V = 'N') THEN

Line 3484: ,'OKS_LINES_INTERFACE'

3480: ,ERROR_MSG
3481: ,MSG_TOKENS)
3482: VALUES (G_WORKER_REQ_ID
3483: ,HEADER_INTERFACE_ROWID
3484: ,'OKS_LINES_INTERFACE'
3485: ,LINE_INTERFACE_ID
3486: ,'OKS_IMP_LIN_INVALID_USGTYPE'
3487: ,NULL)
3488: WHEN (USG_TYPE_NULL_ERROR = 'Y') THEN

Line 3498: ,'OKS_LINES_INTERFACE'

3494: ,ERROR_MSG
3495: ,MSG_TOKENS)
3496: VALUES (G_WORKER_REQ_ID
3497: ,HEADER_INTERFACE_ROWID
3498: ,'OKS_LINES_INTERFACE'
3499: ,LINE_INTERFACE_ID
3500: ,'OKS_IMP_LIN_NULL_USGTYPE'
3501: ,NULL)
3502: WHEN (USG_PER_V = 'N') THEN

Line 3512: ,'OKS_LINES_INTERFACE'

3508: ,ERROR_MSG
3509: ,MSG_TOKENS)
3510: VALUES (G_WORKER_REQ_ID
3511: ,HEADER_INTERFACE_ROWID
3512: ,'OKS_LINES_INTERFACE'
3513: ,LINE_INTERFACE_ID
3514: ,'OKS_IMP_LIN_INVALID_USGPER'
3515: ,NULL)
3516: WHEN (USG_PER_NULL_ERROR = 'Y') THEN

Line 3526: ,'OKS_LINES_INTERFACE'

3522: ,ERROR_MSG
3523: ,MSG_TOKENS)
3524: VALUES (G_WORKER_REQ_ID
3525: ,HEADER_INTERFACE_ROWID
3526: ,'OKS_LINES_INTERFACE'
3527: ,LINE_INTERFACE_ID
3528: ,'OKS_IMP_LIN_NULL_USGPER'
3529: ,NULL)
3530: WHEN (AVG_INT_V = 'N') THEN

Line 3540: ,'OKS_LINES_INTERFACE'

3536: ,ERROR_MSG
3537: ,MSG_TOKENS)
3538: VALUES (G_WORKER_REQ_ID
3539: ,HEADER_INTERFACE_ROWID
3540: ,'OKS_LINES_INTERFACE'
3541: ,LINE_INTERFACE_ID
3542: ,'OKS_IMP_LIN_INVALID_AVGINT'
3543: ,NULL)
3544: WHEN (AVG_INT_NULL_ERROR = 'Y') THEN

Line 3554: ,'OKS_LINES_INTERFACE'

3550: ,ERROR_MSG
3551: ,MSG_TOKENS)
3552: VALUES (G_WORKER_REQ_ID
3553: ,HEADER_INTERFACE_ROWID
3554: ,'OKS_LINES_INTERFACE'
3555: ,LINE_INTERFACE_ID
3556: ,'OKS_IMP_LIN_NULL_AVGINT'
3557: ,NULL)
3558: WHEN (STM_INT_V = 'N') THEN

Line 3568: ,'OKS_LINES_INTERFACE'

3564: ,ERROR_MSG
3565: ,MSG_TOKENS)
3566: VALUES (G_WORKER_REQ_ID
3567: ,HEADER_INTERFACE_ROWID
3568: ,'OKS_LINES_INTERFACE'
3569: ,LINE_INTERFACE_ID
3570: ,'OKS_IMP_LIN_INVALID_STMINT'
3571: ,NULL)
3572: WHEN (STM_INT_NULL_ERROR = 'Y') THEN

Line 3582: ,'OKS_LINES_INTERFACE'

3578: ,ERROR_MSG
3579: ,MSG_TOKENS)
3580: VALUES (G_WORKER_REQ_ID
3581: ,HEADER_INTERFACE_ROWID
3582: ,'OKS_LINES_INTERFACE'
3583: ,LINE_INTERFACE_ID
3584: ,'OKS_IMP_LIN_NULL_STMINT'
3585: ,NULL)
3586: WHEN (UTM_V = 'N') THEN

Line 3596: ,'OKS_LINES_INTERFACE'

3592: ,ERROR_MSG
3593: ,MSG_TOKENS)
3594: VALUES (G_WORKER_REQ_ID
3595: ,HEADER_INTERFACE_ROWID
3596: ,'OKS_LINES_INTERFACE'
3597: ,LINE_INTERFACE_ID
3598: ,'OKS_IMP_LIN_INVALID_UTM'
3599: ,NULL)
3600: WHEN (UTM_NULL_ERROR = 'Y') THEN

Line 3610: ,'OKS_LINES_INTERFACE'

3606: ,ERROR_MSG
3607: ,MSG_TOKENS)
3608: VALUES (G_WORKER_REQ_ID
3609: ,HEADER_INTERFACE_ROWID
3610: ,'OKS_LINES_INTERFACE'
3611: ,LINE_INTERFACE_ID
3612: ,'OKS_IMP_LIN_NULL_UTM'
3613: ,NULL)
3614: WHEN (FIRST_BILLED_AMT_V = 'N') THEN

Line 3624: ,'OKS_LINES_INTERFACE'

3620: ,ERROR_MSG
3621: ,MSG_TOKENS)
3622: VALUES (G_WORKER_REQ_ID
3623: ,HEADER_INTERFACE_ROWID
3624: ,'OKS_LINES_INTERFACE'
3625: ,LINE_INTERFACE_ID
3626: ,'OKS_IMP_LIN_INVALID_FBA'
3627: ,NULL)
3628: WHEN (FIRST_BILLED_DATE_V = 'N') THEN

Line 3638: ,'OKS_LINES_INTERFACE'

3634: ,ERROR_MSG
3635: ,MSG_TOKENS)
3636: VALUES (G_WORKER_REQ_ID
3637: ,HEADER_INTERFACE_ROWID
3638: ,'OKS_LINES_INTERFACE'
3639: ,LINE_INTERFACE_ID
3640: ,'OKS_IMP_LIN_INVALID_FBD'
3641: ,NULL)
3642: WHEN (LAST_BILLED_AMT_V = 'N') THEN

Line 3652: ,'OKS_LINES_INTERFACE'

3648: ,ERROR_MSG
3649: ,MSG_TOKENS)
3650: VALUES (G_WORKER_REQ_ID
3651: ,HEADER_INTERFACE_ROWID
3652: ,'OKS_LINES_INTERFACE'
3653: ,LINE_INTERFACE_ID
3654: ,'OKS_IMP_LIN_INVALID_LBA'
3655: ,NULL)
3656: WHEN (LAST_BILL_DATE_V = 'N') THEN

Line 3666: ,'OKS_LINES_INTERFACE'

3662: ,ERROR_MSG
3663: ,MSG_TOKENS)
3664: VALUES (G_WORKER_REQ_ID
3665: ,HEADER_INTERFACE_ROWID
3666: ,'OKS_LINES_INTERFACE'
3667: ,LINE_INTERFACE_ID
3668: ,'OKS_IMP_LIN_INVALID_LBD'
3669: ,NULL)
3670: SELECT LST.LINE_INTERFACE_ID LINE_INTERFACE_ID