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 2367: ,'OKS_LINES_INTERFACE'

2363: ,ERROR_MSG
2364: ,MSG_TOKENS)
2365: VALUES (G_WORKER_REQ_ID
2366: ,HEADER_INTERFACE_ROWID
2367: ,'OKS_LINES_INTERFACE'
2368: ,LINE_INTERFACE_ID
2369: ,'OKS_IMP_LIN_INVALID_LTYPE'
2370: ,NULL)
2371: WHEN (ITEM_ID IS NULL) THEN

Line 2381: ,'OKS_LINES_INTERFACE'

2377: ,ERROR_MSG
2378: ,MSG_TOKENS)
2379: VALUES (G_WORKER_REQ_ID
2380: ,HEADER_INTERFACE_ROWID
2381: ,'OKS_LINES_INTERFACE'
2382: ,LINE_INTERFACE_ID
2383: ,'OKS_IMP_LIN_INVALID_ITEM'
2384: ,NULL)
2385: WHEN (BILL_TO_SITE_USAGE_ID IS NULL) THEN

Line 2395: ,'OKS_LINES_INTERFACE'

2391: ,ERROR_MSG
2392: ,MSG_TOKENS)
2393: VALUES (G_WORKER_REQ_ID
2394: ,HEADER_INTERFACE_ROWID
2395: ,'OKS_LINES_INTERFACE'
2396: ,LINE_INTERFACE_ID
2397: ,'OKS_IMP_LIN_INVALID_BTSU'
2398: ,NULL)
2399: WHEN (SHIP_TO_SITE_USAGE_ID IS NULL) THEN

Line 2409: ,'OKS_LINES_INTERFACE'

2405: ,ERROR_MSG
2406: ,MSG_TOKENS)
2407: VALUES (G_WORKER_REQ_ID
2408: ,HEADER_INTERFACE_ROWID
2409: ,'OKS_LINES_INTERFACE'
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

Line 2423: ,'OKS_LINES_INTERFACE'

2419: ,ERROR_MSG
2420: ,MSG_TOKENS)
2421: VALUES (G_WORKER_REQ_ID
2422: ,HEADER_INTERFACE_ROWID
2423: ,'OKS_LINES_INTERFACE'
2424: ,LINE_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)

Line 2438: ,'OKS_LINES_INTERFACE'

2434: ,ERROR_MSG
2435: ,MSG_TOKENS)
2436: VALUES (G_WORKER_REQ_ID
2437: ,HEADER_INTERFACE_ROWID
2438: ,'OKS_LINES_INTERFACE'
2439: ,LINE_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)

Line 2453: ,'OKS_LINES_INTERFACE'

2449: ,ERROR_MSG
2450: ,MSG_TOKENS)
2451: VALUES (G_WORKER_REQ_ID
2452: ,HEADER_INTERFACE_ROWID
2453: ,'OKS_LINES_INTERFACE'
2454: ,LINE_INTERFACE_ID
2455: ,'OKS_IMP_LIN_INVALID_SC'
2456: ,NULL)
2457: WHEN (PL_PROVIDED = 'Y' AND PRICE_LIST_ID IS NULL) THEN

Line 2467: ,'OKS_LINES_INTERFACE'

2463: ,ERROR_MSG
2464: ,MSG_TOKENS)
2465: VALUES (G_WORKER_REQ_ID
2466: ,HEADER_INTERFACE_ROWID
2467: ,'OKS_LINES_INTERFACE'
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

Line 2481: ,'OKS_LINES_INTERFACE'

2477: ,ERROR_MSG
2478: ,MSG_TOKENS)
2479: VALUES (G_WORKER_REQ_ID
2480: ,HEADER_INTERFACE_ROWID
2481: ,'OKS_LINES_INTERFACE'
2482: ,LINE_INTERFACE_ID
2483: ,'OKS_IMP_LIN_INVALID_PAY_INST'
2484: ,NULL)
2485: WHEN (ACCOUNTING_RULE_ID IS NULL) THEN

Line 2495: ,'OKS_LINES_INTERFACE'

2491: ,ERROR_MSG
2492: ,MSG_TOKENS)
2493: VALUES (G_WORKER_REQ_ID
2494: ,HEADER_INTERFACE_ROWID
2495: ,'OKS_LINES_INTERFACE'
2496: ,LINE_INTERFACE_ID
2497: ,'OKS_IMP_LIN_INVALID_AR'
2498: ,NULL)
2499: WHEN (INVOICING_RULE_ID IS NULL) THEN

Line 2509: ,'OKS_LINES_INTERFACE'

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

Line 2523: ,'OKS_LINES_INTERFACE'

2519: ,ERROR_MSG
2520: ,MSG_TOKENS)
2521: VALUES (G_WORKER_REQ_ID
2522: ,HEADER_INTERFACE_ROWID
2523: ,'OKS_LINES_INTERFACE'
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

Line 2537: ,'OKS_LINES_INTERFACE'

2533: ,ERROR_MSG
2534: ,MSG_TOKENS)
2535: VALUES (G_WORKER_REQ_ID
2536: ,HEADER_INTERFACE_ROWID
2537: ,'OKS_LINES_INTERFACE'
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

Line 2551: ,'OKS_LINES_INTERFACE'

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

Line 2565: ,'OKS_LINES_INTERFACE'

2561: ,ERROR_MSG
2562: ,MSG_TOKENS)
2563: VALUES (G_WORKER_REQ_ID
2564: ,HEADER_INTERFACE_ROWID
2565: ,'OKS_LINES_INTERFACE'
2566: ,LINE_INTERFACE_ID
2567: ,'OKS_IMP_LIN_INVALID_TOT'
2568: ,NULL)
2569: SELECT OLI.LINE_INTERFACE_ID LINE_INTERFACE_ID

Line 2682: FROM OKS_LINES_INTERFACE OLI

2678: ELSE NULL
2679: END)
2680: ELSE NULL
2681: END) LAST_BILL_FROM_DATE
2682: FROM OKS_LINES_INTERFACE OLI
2683: ,OKS_INT_HEADER_STG_TEMP HDR
2684: ,FND_LOOKUPS FL
2685: ,RA_CUSTOMER_TRX_ALL CNI
2686: ,FND_LOOKUPS PMC

Line 2757: FROM OKS_LINES_INTERFACE LNI

2753: /*,COUNT(DISTINCT BCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) BCN_COUNT
2754: ,MAX(BCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) BCN_ID -- Billing contact id based on Name
2755: ,COUNT(DISTINCT SCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) SCN_COUNT
2756: ,MAX(SCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) SCN_ID -- Shipping contact id based on Name */
2757: FROM OKS_LINES_INTERFACE LNI
2758: ,OKS_INT_HEADER_STG_TEMP HST
2759: ,QP_LIST_HEADERS_B QPI
2760: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2761: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL

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

2853: AND PMC.LOOKUP_CODE (+) = 'COM';
2854:
2855: IF G_STMT_LOG THEN
2856:
2857: SELECT count(1) INTO l_int_count FROM OKS_LINES_INTERFACE OLI
2858: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
2859: WHERE HEADER_INTERFACE_ID = OLI.HEADER_INTERFACE_ID);
2860:
2861: SELECT count(1) INTO l_stg_count FROM OKS_INT_LINE_STG_TEMP;

Line 2884: ,'OKS_LINES_INTERFACE'

2880: ,ERROR_MSG
2881: ,MSG_TOKENS)
2882: VALUES (G_WORKER_REQ_ID
2883: ,HEADER_INTERFACE_ROWID
2884: ,'OKS_LINES_INTERFACE'
2885: ,LINE_INTERFACE_ID
2886: ,'OKS_IMP_LIN_INVALID_LINENUM'
2887: ,NULL)
2888: WHEN (HOI_COUNT = 0) THEN

Line 2898: ,'OKS_LINES_INTERFACE'

2894: ,ERROR_MSG
2895: ,MSG_TOKENS)
2896: VALUES (G_WORKER_REQ_ID
2897: ,HEADER_INTERFACE_ROWID
2898: ,'OKS_LINES_INTERFACE'
2899: ,LINE_INTERFACE_ID
2900: ,'OKS_IMP_LIN_INVALID_ITMORG'
2901: ,NULL)
2902: WHEN (COVTEM_V = 'N') THEN

Line 2912: ,'OKS_LINES_INTERFACE'

2908: ,ERROR_MSG
2909: ,MSG_TOKENS)
2910: VALUES (G_WORKER_REQ_ID
2911: ,HEADER_INTERFACE_ROWID
2912: ,'OKS_LINES_INTERFACE'
2913: ,LINE_INTERFACE_ID
2914: ,'OKS_IMP_LIN_INVALID_COVTEM'
2915: ,NULL)
2916: WHEN (STATUS_VALID = 'N') THEN

Line 2926: ,'OKS_LINES_INTERFACE'

2922: ,ERROR_MSG
2923: ,MSG_TOKENS)
2924: VALUES (G_WORKER_REQ_ID
2925: ,HEADER_INTERFACE_ROWID
2926: ,'OKS_LINES_INTERFACE'
2927: ,LINE_INTERFACE_ID
2928: ,'OKS_IMP_LIN_INVALID_STS'
2929: ,NULL)
2930: WHEN (STATUS_X_DATE_VALID = 'N') THEN

Line 2940: ,'OKS_LINES_INTERFACE'

2936: ,ERROR_MSG
2937: ,MSG_TOKENS)
2938: VALUES (G_WORKER_REQ_ID
2939: ,HEADER_INTERFACE_ROWID
2940: ,'OKS_LINES_INTERFACE'
2941: ,LINE_INTERFACE_ID
2942: ,'OKS_IMP_LIN_INVALID_STSXDATE'
2943: ,NULL)
2944: WHEN (STS_X_HDRSTS = 'N') THEN

Line 2954: ,'OKS_LINES_INTERFACE'

2950: ,ERROR_MSG
2951: ,MSG_TOKENS)
2952: VALUES (G_WORKER_REQ_ID
2953: ,HEADER_INTERFACE_ROWID
2954: ,'OKS_LINES_INTERFACE'
2955: ,LINE_INTERFACE_ID
2956: ,'OKS_IMP_LIN_INVALID_STSXHDR'
2957: ,NULL)
2958: WHEN (DATE_VALID = 'N') THEN

Line 2968: ,'OKS_LINES_INTERFACE'

2964: ,ERROR_MSG
2965: ,MSG_TOKENS)
2966: VALUES (G_WORKER_REQ_ID
2967: ,HEADER_INTERFACE_ROWID
2968: ,'OKS_LINES_INTERFACE'
2969: ,LINE_INTERFACE_ID
2970: ,'OKS_IMP_LIN_INVALID_DATE'
2971: ,NULL)
2972: WHEN (DATE_CANCELED_VALID = 'N') THEN

Line 2982: ,'OKS_LINES_INTERFACE'

2978: ,ERROR_MSG
2979: ,MSG_TOKENS)
2980: VALUES (G_WORKER_REQ_ID
2981: ,HEADER_INTERFACE_ROWID
2982: ,'OKS_LINES_INTERFACE'
2983: ,LINE_INTERFACE_ID
2984: ,'OKS_IMP_LIN_INVALID_DATECAN'
2985: ,NULL)
2986: WHEN (DATE_CANCELED_NULL_ERROR = 'Y') THEN

Line 2996: ,'OKS_LINES_INTERFACE'

2992: ,ERROR_MSG
2993: ,MSG_TOKENS)
2994: VALUES (G_WORKER_REQ_ID
2995: ,HEADER_INTERFACE_ROWID
2996: ,'OKS_LINES_INTERFACE'
2997: ,LINE_INTERFACE_ID
2998: ,'OKS_IMP_LIN_NULL_DATECAN'
2999: ,NULL)
3000: WHEN (CR_VALID = 'N') THEN

Line 3010: ,'OKS_LINES_INTERFACE'

3006: ,ERROR_MSG
3007: ,MSG_TOKENS)
3008: VALUES (G_WORKER_REQ_ID
3009: ,HEADER_INTERFACE_ROWID
3010: ,'OKS_LINES_INTERFACE'
3011: ,LINE_INTERFACE_ID
3012: ,'OKS_IMP_LIN_INVALID_CR'
3013: ,NULL)
3014: WHEN (CR_NULL_ERROR = 'Y') THEN

Line 3024: ,'OKS_LINES_INTERFACE'

3020: ,ERROR_MSG
3021: ,MSG_TOKENS)
3022: VALUES (G_WORKER_REQ_ID
3023: ,HEADER_INTERFACE_ROWID
3024: ,'OKS_LINES_INTERFACE'
3025: ,LINE_INTERFACE_ID
3026: ,'OKS_IMP_LIN_NULL_CR'
3027: ,NULL)
3028: WHEN (TEC_V = 'N') THEN

Line 3038: ,'OKS_LINES_INTERFACE'

3034: ,ERROR_MSG
3035: ,MSG_TOKENS)
3036: VALUES (G_WORKER_REQ_ID
3037: ,HEADER_INTERFACE_ROWID
3038: ,'OKS_LINES_INTERFACE'
3039: ,LINE_INTERFACE_ID
3040: ,'OKS_IMP_LIN_INVALID_TEC'
3041: ,NULL)
3042: WHEN (TUCEF_OU_V = 'N') THEN

Line 3052: ,'OKS_LINES_INTERFACE'

3048: ,ERROR_MSG
3049: ,MSG_TOKENS)
3050: VALUES (G_WORKER_REQ_ID
3051: ,HEADER_INTERFACE_ROWID
3052: ,'OKS_LINES_INTERFACE'
3053: ,LINE_INTERFACE_ID
3054: ,'OKS_IMP_LIN_INVALID_TUCEF_OU'
3055: ,NULL)
3056: WHEN (TEN_V = 'N') THEN

Line 3066: ,'OKS_LINES_INTERFACE'

3062: ,ERROR_MSG
3063: ,MSG_TOKENS)
3064: VALUES (G_WORKER_REQ_ID
3065: ,HEADER_INTERFACE_ROWID
3066: ,'OKS_LINES_INTERFACE'
3067: ,LINE_INTERFACE_ID
3068: ,'OKS_IMP_LIN_INVALID_TEN'
3069: ,NULL)
3070: WHEN (TEN_NULL_ERROR = 'Y') THEN

Line 3080: ,'OKS_LINES_INTERFACE'

3076: ,ERROR_MSG
3077: ,MSG_TOKENS)
3078: VALUES (G_WORKER_REQ_ID
3079: ,HEADER_INTERFACE_ROWID
3080: ,'OKS_LINES_INTERFACE'
3081: ,LINE_INTERFACE_ID
3082: ,'OKS_IMP_LIN_NULL_TEN'
3083: ,NULL)
3084: WHEN (ERC_NULL_ERROR = 'Y') THEN

Line 3094: ,'OKS_LINES_INTERFACE'

3090: ,ERROR_MSG
3091: ,MSG_TOKENS)
3092: VALUES (G_WORKER_REQ_ID
3093: ,HEADER_INTERFACE_ROWID
3094: ,'OKS_LINES_INTERFACE'
3095: ,LINE_INTERFACE_ID
3096: ,'OKS_IMP_LIN_NULL_ERC'
3097: ,NULL)
3098: WHEN (TCC_VALID = 'N') THEN

Line 3108: ,'OKS_LINES_INTERFACE'

3104: ,ERROR_MSG
3105: ,MSG_TOKENS)
3106: VALUES (G_WORKER_REQ_ID
3107: ,HEADER_INTERFACE_ROWID
3108: ,'OKS_LINES_INTERFACE'
3109: ,LINE_INTERFACE_ID
3110: ,'OKS_IMP_LIN_INVALID_TCC'
3111: ,NULL)
3112: WHEN (REN_TYPE_VALID = 'N') THEN

Line 3122: ,'OKS_LINES_INTERFACE'

3118: ,ERROR_MSG
3119: ,MSG_TOKENS)
3120: VALUES (G_WORKER_REQ_ID
3121: ,HEADER_INTERFACE_ROWID
3122: ,'OKS_LINES_INTERFACE'
3123: ,LINE_INTERFACE_ID
3124: ,'OKS_IMP_LIN_INVALID_RENTYPE'
3125: ,NULL)
3126: WHEN (PRINT_INVOICE_V = 'N') THEN

Line 3136: ,'OKS_LINES_INTERFACE'

3132: ,ERROR_MSG
3133: ,MSG_TOKENS)
3134: VALUES (G_WORKER_REQ_ID
3135: ,HEADER_INTERFACE_ROWID
3136: ,'OKS_LINES_INTERFACE'
3137: ,LINE_INTERFACE_ID
3138: ,'OKS_IMP_LIN_INVALID_PRNTINV'
3139: ,NULL)
3140: WHEN (POREQ_V = 'N') THEN

Line 3150: ,'OKS_LINES_INTERFACE'

3146: ,ERROR_MSG
3147: ,MSG_TOKENS)
3148: VALUES (G_WORKER_REQ_ID
3149: ,HEADER_INTERFACE_ROWID
3150: ,'OKS_LINES_INTERFACE'
3151: ,LINE_INTERFACE_ID
3152: ,'OKS_IMP_LIN_INVALID_POREQ'
3153: ,NULL)
3154: WHEN (POREQ_NULL_ERROR = 'Y') THEN

Line 3164: ,'OKS_LINES_INTERFACE'

3160: ,ERROR_MSG
3161: ,MSG_TOKENS)
3162: VALUES (G_WORKER_REQ_ID
3163: ,HEADER_INTERFACE_ROWID
3164: ,'OKS_LINES_INTERFACE'
3165: ,LINE_INTERFACE_ID
3166: ,'OKS_IMP_LIN_NULL_POREQ'
3167: ,NULL)
3168: WHEN (TANGIBLE_SUB = 'Y') THEN

Line 3178: ,'OKS_LINES_INTERFACE'

3174: ,ERROR_MSG
3175: ,MSG_TOKENS)
3176: VALUES (G_WORKER_REQ_ID
3177: ,HEADER_INTERFACE_ROWID
3178: ,'OKS_LINES_INTERFACE'
3179: ,LINE_INTERFACE_ID
3180: ,'OKS_IMP_LIN_TAN_SUB'
3181: ,NULL)
3182: SELECT LST.LINE_INTERFACE_ID LINE_INTERFACE_ID

Line 3306: ,'OKS_LINES_INTERFACE'

3302: ,ERROR_MSG
3303: ,MSG_TOKENS)
3304: VALUES (G_WORKER_REQ_ID
3305: ,HEADER_INTERFACE_ROWID
3306: ,'OKS_LINES_INTERFACE'
3307: ,LINE_INTERFACE_ID
3308: ,'OKS_IMP_LIN_INVALID_BID'
3309: ,NULL)
3310: WHEN (REC_BILL_OCC_V = 'N') THEN

Line 3320: ,'OKS_LINES_INTERFACE'

3316: ,ERROR_MSG
3317: ,MSG_TOKENS)
3318: VALUES (G_WORKER_REQ_ID
3319: ,HEADER_INTERFACE_ROWID
3320: ,'OKS_LINES_INTERFACE'
3321: ,LINE_INTERFACE_ID
3322: ,'OKS_IMP_LIN_INVALID_RBO'
3323: ,NULL)
3324: WHEN (BILL_INT_DUR_NULL_ERROR = 'Y') THEN

Line 3334: ,'OKS_LINES_INTERFACE'

3330: ,ERROR_MSG
3331: ,MSG_TOKENS)
3332: VALUES (G_WORKER_REQ_ID
3333: ,HEADER_INTERFACE_ROWID
3334: ,'OKS_LINES_INTERFACE'
3335: ,LINE_INTERFACE_ID
3336: ,'OKS_IMP_LIN_NULL_BID'
3337: ,NULL)
3338: WHEN (BILL_INT_PERIOD_V = 'N') THEN

Line 3348: ,'OKS_LINES_INTERFACE'

3344: ,ERROR_MSG
3345: ,MSG_TOKENS)
3346: VALUES (G_WORKER_REQ_ID
3347: ,HEADER_INTERFACE_ROWID
3348: ,'OKS_LINES_INTERFACE'
3349: ,LINE_INTERFACE_ID
3350: ,'OKS_IMP_LIN_INVALID_BIP'
3351: ,NULL)
3352: WHEN (FIRST_BILL_V = 'N') THEN

Line 3362: ,'OKS_LINES_INTERFACE'

3358: ,ERROR_MSG
3359: ,MSG_TOKENS)
3360: VALUES (G_WORKER_REQ_ID
3361: ,HEADER_INTERFACE_ROWID
3362: ,'OKS_LINES_INTERFACE'
3363: ,LINE_INTERFACE_ID
3364: ,'OKS_IMP_LIN_INVALID_FBILL'
3365: ,NULL)
3366: WHEN (SUBQTY_V = 'N') THEN

Line 3376: ,'OKS_LINES_INTERFACE'

3372: ,ERROR_MSG
3373: ,MSG_TOKENS)
3374: VALUES (G_WORKER_REQ_ID
3375: ,HEADER_INTERFACE_ROWID
3376: ,'OKS_LINES_INTERFACE'
3377: ,LINE_INTERFACE_ID
3378: ,'OKS_IMP_LIN_INVALID_SQTY'
3379: ,NULL)
3380: WHEN (SUOM_VALID = 'N') THEN

Line 3390: ,'OKS_LINES_INTERFACE'

3386: ,ERROR_MSG
3387: ,MSG_TOKENS)
3388: VALUES (G_WORKER_REQ_ID
3389: ,HEADER_INTERFACE_ROWID
3390: ,'OKS_LINES_INTERFACE'
3391: ,LINE_INTERFACE_ID
3392: ,'OKS_IMP_LIN_INVALID_SUOM'
3393: ,NULL)
3394: WHEN (SUB_NULL_ERROR = 'Y') THEN

Line 3404: ,'OKS_LINES_INTERFACE'

3400: ,ERROR_MSG
3401: ,MSG_TOKENS)
3402: VALUES (G_WORKER_REQ_ID
3403: ,HEADER_INTERFACE_ROWID
3404: ,'OKS_LINES_INTERFACE'
3405: ,LINE_INTERFACE_ID
3406: ,'OKS_IMP_LIN_NULL_SUB'
3407: ,NULL)
3408: WHEN (PRICE_UOM_V = 'N') THEN

Line 3418: ,'OKS_LINES_INTERFACE'

3414: ,ERROR_MSG
3415: ,MSG_TOKENS)
3416: VALUES (G_WORKER_REQ_ID
3417: ,HEADER_INTERFACE_ROWID
3418: ,'OKS_LINES_INTERFACE'
3419: ,LINE_INTERFACE_ID
3420: ,'OKS_IMP_LIN_INVALID_PUOM'
3421: ,NULL)
3422: WHEN (USG_TYPE_V = 'N') THEN

Line 3432: ,'OKS_LINES_INTERFACE'

3428: ,ERROR_MSG
3429: ,MSG_TOKENS)
3430: VALUES (G_WORKER_REQ_ID
3431: ,HEADER_INTERFACE_ROWID
3432: ,'OKS_LINES_INTERFACE'
3433: ,LINE_INTERFACE_ID
3434: ,'OKS_IMP_LIN_INVALID_USGTYPE'
3435: ,NULL)
3436: WHEN (USG_TYPE_NULL_ERROR = 'Y') THEN

Line 3446: ,'OKS_LINES_INTERFACE'

3442: ,ERROR_MSG
3443: ,MSG_TOKENS)
3444: VALUES (G_WORKER_REQ_ID
3445: ,HEADER_INTERFACE_ROWID
3446: ,'OKS_LINES_INTERFACE'
3447: ,LINE_INTERFACE_ID
3448: ,'OKS_IMP_LIN_NULL_USGTYPE'
3449: ,NULL)
3450: WHEN (USG_PER_V = 'N') THEN

Line 3460: ,'OKS_LINES_INTERFACE'

3456: ,ERROR_MSG
3457: ,MSG_TOKENS)
3458: VALUES (G_WORKER_REQ_ID
3459: ,HEADER_INTERFACE_ROWID
3460: ,'OKS_LINES_INTERFACE'
3461: ,LINE_INTERFACE_ID
3462: ,'OKS_IMP_LIN_INVALID_USGPER'
3463: ,NULL)
3464: WHEN (USG_PER_NULL_ERROR = 'Y') THEN

Line 3474: ,'OKS_LINES_INTERFACE'

3470: ,ERROR_MSG
3471: ,MSG_TOKENS)
3472: VALUES (G_WORKER_REQ_ID
3473: ,HEADER_INTERFACE_ROWID
3474: ,'OKS_LINES_INTERFACE'
3475: ,LINE_INTERFACE_ID
3476: ,'OKS_IMP_LIN_NULL_USGPER'
3477: ,NULL)
3478: WHEN (AVG_INT_V = 'N') THEN

Line 3488: ,'OKS_LINES_INTERFACE'

3484: ,ERROR_MSG
3485: ,MSG_TOKENS)
3486: VALUES (G_WORKER_REQ_ID
3487: ,HEADER_INTERFACE_ROWID
3488: ,'OKS_LINES_INTERFACE'
3489: ,LINE_INTERFACE_ID
3490: ,'OKS_IMP_LIN_INVALID_AVGINT'
3491: ,NULL)
3492: WHEN (AVG_INT_NULL_ERROR = 'Y') THEN

Line 3502: ,'OKS_LINES_INTERFACE'

3498: ,ERROR_MSG
3499: ,MSG_TOKENS)
3500: VALUES (G_WORKER_REQ_ID
3501: ,HEADER_INTERFACE_ROWID
3502: ,'OKS_LINES_INTERFACE'
3503: ,LINE_INTERFACE_ID
3504: ,'OKS_IMP_LIN_NULL_AVGINT'
3505: ,NULL)
3506: WHEN (STM_INT_V = 'N') THEN

Line 3516: ,'OKS_LINES_INTERFACE'

3512: ,ERROR_MSG
3513: ,MSG_TOKENS)
3514: VALUES (G_WORKER_REQ_ID
3515: ,HEADER_INTERFACE_ROWID
3516: ,'OKS_LINES_INTERFACE'
3517: ,LINE_INTERFACE_ID
3518: ,'OKS_IMP_LIN_INVALID_STMINT'
3519: ,NULL)
3520: WHEN (STM_INT_NULL_ERROR = 'Y') THEN

Line 3530: ,'OKS_LINES_INTERFACE'

3526: ,ERROR_MSG
3527: ,MSG_TOKENS)
3528: VALUES (G_WORKER_REQ_ID
3529: ,HEADER_INTERFACE_ROWID
3530: ,'OKS_LINES_INTERFACE'
3531: ,LINE_INTERFACE_ID
3532: ,'OKS_IMP_LIN_NULL_STMINT'
3533: ,NULL)
3534: WHEN (UTM_V = 'N') THEN

Line 3544: ,'OKS_LINES_INTERFACE'

3540: ,ERROR_MSG
3541: ,MSG_TOKENS)
3542: VALUES (G_WORKER_REQ_ID
3543: ,HEADER_INTERFACE_ROWID
3544: ,'OKS_LINES_INTERFACE'
3545: ,LINE_INTERFACE_ID
3546: ,'OKS_IMP_LIN_INVALID_UTM'
3547: ,NULL)
3548: WHEN (UTM_NULL_ERROR = 'Y') THEN

Line 3558: ,'OKS_LINES_INTERFACE'

3554: ,ERROR_MSG
3555: ,MSG_TOKENS)
3556: VALUES (G_WORKER_REQ_ID
3557: ,HEADER_INTERFACE_ROWID
3558: ,'OKS_LINES_INTERFACE'
3559: ,LINE_INTERFACE_ID
3560: ,'OKS_IMP_LIN_NULL_UTM'
3561: ,NULL)
3562: WHEN (FIRST_BILLED_AMT_V = 'N') THEN

Line 3572: ,'OKS_LINES_INTERFACE'

3568: ,ERROR_MSG
3569: ,MSG_TOKENS)
3570: VALUES (G_WORKER_REQ_ID
3571: ,HEADER_INTERFACE_ROWID
3572: ,'OKS_LINES_INTERFACE'
3573: ,LINE_INTERFACE_ID
3574: ,'OKS_IMP_LIN_INVALID_FBA'
3575: ,NULL)
3576: WHEN (FIRST_BILLED_DATE_V = 'N') THEN

Line 3586: ,'OKS_LINES_INTERFACE'

3582: ,ERROR_MSG
3583: ,MSG_TOKENS)
3584: VALUES (G_WORKER_REQ_ID
3585: ,HEADER_INTERFACE_ROWID
3586: ,'OKS_LINES_INTERFACE'
3587: ,LINE_INTERFACE_ID
3588: ,'OKS_IMP_LIN_INVALID_FBD'
3589: ,NULL)
3590: WHEN (LAST_BILLED_AMT_V = 'N') THEN

Line 3600: ,'OKS_LINES_INTERFACE'

3596: ,ERROR_MSG
3597: ,MSG_TOKENS)
3598: VALUES (G_WORKER_REQ_ID
3599: ,HEADER_INTERFACE_ROWID
3600: ,'OKS_LINES_INTERFACE'
3601: ,LINE_INTERFACE_ID
3602: ,'OKS_IMP_LIN_INVALID_LBA'
3603: ,NULL)
3604: WHEN (LAST_BILL_DATE_V = 'N') THEN

Line 3614: ,'OKS_LINES_INTERFACE'

3610: ,ERROR_MSG
3611: ,MSG_TOKENS)
3612: VALUES (G_WORKER_REQ_ID
3613: ,HEADER_INTERFACE_ROWID
3614: ,'OKS_LINES_INTERFACE'
3615: ,LINE_INTERFACE_ID
3616: ,'OKS_IMP_LIN_INVALID_LBD'
3617: ,NULL)
3618: SELECT LST.LINE_INTERFACE_ID LINE_INTERFACE_ID