[Home] [Help]
119: l_count_jur_null NUMBER;
120: l_count_pvr_null NUMBER;
121: l_count_rate_id_null NUMBER;
122:
123: l_error_rec ZX_VALIDATION_ERRORS_GT%rowtype;
124:
125: --Declare Forward references
126: PROCEDURE Validate_Other_Documents(x_return_status OUT NOCOPY VARCHAR2);
127: procedure def_additional_tax_attribs;
151: other_doc_event_class_code,
152: other_doc_trx_id,
153: interface_line_entity_code,
154: interface_line_id
155: FROM zx_validation_errors_gt;
156:
157: l_count_header NUMBER;
158: l_count_lines NUMBER;
159:
280:
281: zx_on_fly_trx_upgrade_pkg.upgrade_trx_on_fly_blk(x_return_status);
282:
283: -- Bug # 4697301
284: DELETE FROM ZX_VALIDATION_ERRORS_GT err
285: WHERE EXISTS
286: (SELECT 1
287: FROM ZX_LINES_DET_FACTORS linedet
288: WHERE linedet.application_id = err.other_doc_application_id
297: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
298: 'Before Defaulting, Validate either tax_rate_id or tax_rate_code is passed');
299: END IF;
300:
301: INSERT INTO ZX_VALIDATION_ERRORS_GT
302: (
303: application_id,
304: entity_code,
305: event_class_code,
327: FROM ZX_IMPORT_TAX_LINES_GT lines_gt
328: WHERE tax_rate_code IS NULL AND tax_rate_id IS NULL
329: AND NOT EXISTS
330: (SELECT 1
331: FROM ZX_VALIDATION_ERRORS_GT exists_check
332: WHERE exists_check.application_id = lines_gt.application_id
333: AND exists_check.entity_code = lines_gt.entity_code
334: AND exists_check.event_class_code = lines_gt.event_class_code
335: AND exists_check.trx_id = lines_gt.trx_id
355: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
356: 'After Defaulting, Validate either tax_rate_id or tax_rate_code is present');
357: END IF;
358:
359: INSERT INTO ZX_VALIDATION_ERRORS_GT(
360: application_id,
361: entity_code,
362: event_class_code,
363: trx_id,
384: FROM ZX_IMPORT_TAX_LINES_GT lines_gt
385: WHERE tax_rate_code IS NULL AND tax_rate_id IS NULL
386: AND NOT EXISTS
387: (SELECT 1
388: FROM ZX_VALIDATION_ERRORS_GT exists_check
389: WHERE exists_check.application_id = lines_gt.application_id
390: AND exists_check.entity_code = lines_gt.entity_code
391: AND exists_check.event_class_code = lines_gt.event_class_code
392: AND exists_check.trx_id = lines_gt.trx_id
2284: END IF;
2285:
2286: INSERT ALL
2287: WHEN (ZX_ROUND_PARTY_MISSING = 'Y') THEN
2288: INTO ZX_VALIDATION_ERRORS_GT(
2289: application_id,
2290: entity_code,
2291: event_class_code,
2292: trx_id,
2311: NULL ,--interface_line_entity_code,
2312: NULL --interface_line_id
2313: )
2314: WHEN (ZX_CTRL_FLAG_MISSING = 'Y') THEN
2315: INTO ZX_VALIDATION_ERRORS_GT(
2316: application_id,
2317: entity_code,
2318: event_class_code,
2319: trx_id,
2338: NULL ,--interface_line_entity_code,
2339: NULL --interface_line_id
2340: )
2341: WHEN (TAXATION_COUNTRY_NOT_EXISTS = 'Y') THEN
2342: INTO ZX_VALIDATION_ERRORS_GT(
2343: application_id,
2344: entity_code,
2345: event_class_code,
2346: trx_id,
2365: NULL ,--interface_line_entity_code,
2366: NULL --interface_line_id
2367: )
2368: WHEN (DOC_FC_CODE_NOT_EXISTS = 'Y') THEN
2369: INTO ZX_VALIDATION_ERRORS_GT(
2370: application_id,
2371: entity_code,
2372: event_class_code,
2373: trx_id,
2392: NULL ,--interface_line_entity_code,
2393: NULL --interface_line_id
2394: )
2395: WHEN (DOC_FC_COUNTRY_INCONSIS = 'Y') THEN
2396: INTO ZX_VALIDATION_ERRORS_GT(
2397: application_id,
2398: entity_code,
2399: event_class_code,
2400: trx_id,
2419: NULL ,--interface_line_entity_code,
2420: NULL --interface_line_id
2421: )
2422: WHEN (PARTY_NOT_EXISTS = 'Y') THEN
2423: INTO ZX_VALIDATION_ERRORS_GT(
2424: application_id,
2425: entity_code,
2426: event_class_code,
2427: trx_id,
2446: NULL ,--interface_line_entity_code,
2447: NULL --interface_line_id
2448: )
2449: WHEN (ZX_CURRENCY_INFO_REQD = 'Y') THEN
2450: INTO ZX_VALIDATION_ERRORS_GT(
2451: application_id,
2452: entity_code,
2453: event_class_code,
2454: trx_id,
2473: NULL ,--interface_line_entity_code,
2474: NULL --interface_line_id
2475: )
2476: WHEN (ZX_QUOTE_FLAG_INVALID = 'Y') THEN
2477: INTO ZX_VALIDATION_ERRORS_GT(
2478: application_id,
2479: entity_code,
2480: event_class_code,
2481: trx_id,
2500: NULL ,--interface_line_entity_code,
2501: NULL --interface_line_id
2502: )
2503: WHEN (ZX_DOC_LVL_RECALC_FLAG_INVALID = 'Y') THEN
2504: INTO ZX_VALIDATION_ERRORS_GT(
2505: application_id,
2506: entity_code,
2507: event_class_code,
2508: trx_id,
2683: END IF;
2684:
2685: INSERT ALL
2686: WHEN (ZX_LOCATION_MISSING = 'Y') THEN
2687: INTO ZX_VALIDATION_ERRORS_GT(
2688: application_id,
2689: entity_code,
2690: event_class_code,
2691: trx_id,
2711: interface_line_id
2712: )
2713:
2714: WHEN (ZX_LINE_CLASS_INVALID = 'Y') THEN
2715: INTO ZX_VALIDATION_ERRORS_GT(
2716: application_id,
2717: entity_code,
2718: event_class_code,
2719: trx_id,
2739: interface_line_id
2740: )
2741:
2742: WHEN (ZX_TRX_LINE_TYPE_INVALID = 'Y') THEN
2743: INTO ZX_VALIDATION_ERRORS_GT(
2744: application_id,
2745: entity_code,
2746: event_class_code,
2747: trx_id,
2767: interface_line_id
2768: )
2769:
2770: WHEN (ZX_LINE_AMT_INCL_TAX_INVALID = 'Y') THEN
2771: INTO ZX_VALIDATION_ERRORS_GT(
2772: application_id,
2773: entity_code,
2774: event_class_code,
2775: trx_id,
2795: interface_line_id
2796: )
2797:
2798: WHEN (PRODUCT_CATEG_NOT_EXISTS = 'Y') THEN
2799: INTO ZX_VALIDATION_ERRORS_GT(
2800: application_id,
2801: entity_code,
2802: event_class_code,
2803: trx_id,
2823: interface_line_id
2824: )
2825:
2826: WHEN (PRODUCT_CATEG_NOT_EFFECTIVE = 'Y') THEN
2827: INTO ZX_VALIDATION_ERRORS_GT(
2828: application_id,
2829: entity_code,
2830: event_class_code,
2831: trx_id,
2851: interface_line_id
2852: )
2853:
2854: WHEN (PRODUCT_CATEG_COUNTRY_INCONSIS = 'Y') THEN
2855: INTO ZX_VALIDATION_ERRORS_GT(
2856: application_id,
2857: entity_code,
2858: event_class_code,
2859: trx_id,
2879: interface_line_id
2880: )
2881:
2882: WHEN (USER_DEF_FC_CODE_NOT_EXISTS = 'Y') THEN
2883: INTO ZX_VALIDATION_ERRORS_GT(
2884: application_id,
2885: entity_code,
2886: event_class_code,
2887: trx_id,
2907: interface_line_id
2908: )
2909:
2910: WHEN (USER_DEF_FC_CODE_NOT_EFFECTIVE = 'Y') THEN
2911: INTO ZX_VALIDATION_ERRORS_GT(
2912: application_id,
2913: entity_code,
2914: event_class_code,
2915: trx_id,
2934: interface_line_entity_code,
2935: interface_line_id
2936: )
2937: WHEN (USER_DEF_COUNTRY_INCONSIS = 'Y') THEN
2938: INTO ZX_VALIDATION_ERRORS_GT(
2939: application_id,
2940: entity_code,
2941: event_class_code,
2942: trx_id,
2962: interface_line_id
2963: )
2964:
2965: WHEN (DOC_FC_CODE_NOT_EFFECTIVE = 'Y') THEN
2966: INTO ZX_VALIDATION_ERRORS_GT(
2967: application_id,
2968: entity_code,
2969: event_class_code,
2970: trx_id,
2990: interface_line_id
2991: )
2992:
2993: WHEN (TRX_BIZ_FC_CODE_NOT_EXISTS = 'Y') THEN
2994: INTO ZX_VALIDATION_ERRORS_GT(
2995: application_id,
2996: entity_code,
2997: event_class_code,
2998: trx_id,
3018: interface_line_id
3019: )
3020:
3021: WHEN (TRX_BIZ_FC_CODE_NOT_EFFECTIVE = 'Y') THEN
3022: INTO ZX_VALIDATION_ERRORS_GT(
3023: application_id,
3024: entity_code,
3025: event_class_code,
3026: trx_id,
3046: interface_line_id
3047: )
3048:
3049: WHEN (TRX_BIZ_FC_COUNTRY_INCONSIS = 'Y') THEN
3050: INTO ZX_VALIDATION_ERRORS_GT(
3051: application_id,
3052: entity_code,
3053: event_class_code,
3054: trx_id,
3074: interface_line_id
3075: )
3076:
3077: WHEN (INTENDED_USE_CODE_NOT_EXISTS = 'Y') THEN
3078: INTO ZX_VALIDATION_ERRORS_GT(
3079: application_id,
3080: entity_code,
3081: event_class_code,
3082: trx_id,
3102: interface_line_id
3103: )
3104:
3105: WHEN (INTENDED_USE_NOT_EFFECTIVE = 'Y') THEN
3106: INTO ZX_VALIDATION_ERRORS_GT(
3107: application_id,
3108: entity_code,
3109: event_class_code,
3110: trx_id,
3130: interface_line_id
3131: )
3132:
3133: WHEN (INTENDED_USE_CONTRY_INCONSIS = 'Y') THEN
3134: INTO ZX_VALIDATION_ERRORS_GT(
3135: application_id,
3136: entity_code,
3137: event_class_code,
3138: trx_id,
3158: interface_line_id
3159: )
3160:
3161: WHEN (PRODUCT_TYPE_CODE_NOT_EXISTS = 'Y') THEN
3162: INTO ZX_VALIDATION_ERRORS_GT(
3163: application_id,
3164: entity_code,
3165: event_class_code,
3166: trx_id,
3186: interface_line_id
3187: )
3188:
3189: WHEN (PRODUCT_TYPE_NOT_EFFECTIVE = 'Y') THEN
3190: INTO ZX_VALIDATION_ERRORS_GT(
3191: application_id,
3192: entity_code,
3193: event_class_code,
3194: trx_id,
3214: interface_line_id
3215: )
3216:
3217: WHEN (PRODUCT_FC_CODE_NOT_EXISTS = 'Y') THEN
3218: INTO ZX_VALIDATION_ERRORS_GT(
3219: application_id,
3220: entity_code,
3221: event_class_code,
3222: trx_id,
3243: )
3244: /* bugfix 4919842: remove party not exist and site not exist checks
3245: WHEN (SHIP_TO_PARTY_NOT_EXISTS = 'Y') THEN
3246:
3247: INTO ZX_VALIDATION_ERRORS_GT(
3248: application_id,
3249: entity_code,
3250: event_class_code,
3251: trx_id,
3272: )
3273:
3274: WHEN (SHIP_FROM_PARTY_NOT_EXISTS = 'Y') THEN
3275:
3276: INTO ZX_VALIDATION_ERRORS_GT(
3277: application_id,
3278: entity_code,
3279: event_class_code,
3280: trx_id,
3301: )
3302:
3303: WHEN (BILL_TO_PARTY_NOT_EXISTS = 'Y') THEN
3304:
3305: INTO ZX_VALIDATION_ERRORS_GT(
3306: application_id,
3307: entity_code,
3308: event_class_code,
3309: trx_id,
3330: )
3331:
3332: WHEN (BILL_FROM_PARTY_NOT_EXISTS = 'Y') THEN
3333:
3334: INTO ZX_VALIDATION_ERRORS_GT(
3335: application_id,
3336: entity_code,
3337: event_class_code,
3338: trx_id,
3359: )
3360:
3361: WHEN (SHIPTO_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3362:
3363: INTO ZX_VALIDATION_ERRORS_GT(
3364: application_id,
3365: entity_code,
3366: event_class_code,
3367: trx_id,
3388: )
3389:
3390: WHEN (SHIPFROM_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3391:
3392: INTO ZX_VALIDATION_ERRORS_GT(
3393: application_id,
3394: entity_code,
3395: event_class_code,
3396: trx_id,
3417: )
3418:
3419: WHEN (BILLTO_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3420:
3421: INTO ZX_VALIDATION_ERRORS_GT(
3422: application_id,
3423: entity_code,
3424: event_class_code,
3425: trx_id,
3446: )
3447:
3448: WHEN (BILLFROM_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3449:
3450: INTO ZX_VALIDATION_ERRORS_GT(
3451: application_id,
3452: entity_code,
3453: event_class_code,
3454: trx_id,
3476: bugfix 4919842: remove party not exist and site not exist checks */
3477: -- bug 6915776
3478: /*WHEN (ZX_LINE_CTRL_AMT_INVALID = 'Y') THEN
3479:
3480: INTO ZX_VALIDATION_ERRORS_GT(
3481: application_id,
3482: entity_code,
3483: event_class_code,
3484: trx_id,
3504: interface_line_id
3505: )*/
3506:
3507: WHEN (ZX_LINE_CTRL_AMT_NOT_NULL = 'Y') THEN
3508: INTO ZX_VALIDATION_ERRORS_GT(
3509: application_id,
3510: entity_code,
3511: event_class_code,
3512: trx_id,
3535: -- Bug 5516630: Moved unit price and quantity check to determine_recovery API
3536:
3537: /* WHEN (ZX_UNIT_PRICE_MISSING = 'Y') THEN
3538:
3539: INTO ZX_VALIDATION_ERRORS_GT(
3540: application_id,
3541: entity_code,
3542: event_class_code,
3543: trx_id,
3564: )
3565:
3566: WHEN (ZX_LINE_QUANTITY_MISSING = 'Y') THEN
3567:
3568: INTO ZX_VALIDATION_ERRORS_GT(
3569: application_id,
3570: entity_code,
3571: event_class_code,
3572: trx_id,
3592: interface_line_id
3593: )
3594: */
3595: WHEN (ZX_EXEMPTION_CTRL_FLAG_INVALID = 'Y') THEN
3596: INTO ZX_VALIDATION_ERRORS_GT(
3597: application_id,
3598: entity_code,
3599: event_class_code,
3600: trx_id,
3620: interface_line_id
3621: )
3622:
3623: WHEN (ZX_PRODUCT_TYPE_INVALID = 'Y') THEN
3624: INTO ZX_VALIDATION_ERRORS_GT(
3625: application_id,
3626: entity_code,
3627: event_class_code,
3628: trx_id,
3648: interface_line_id
3649: )
3650:
3651: WHEN (ZX_INVALID_TAX_LINES = 'Y') THEN
3652: INTO ZX_VALIDATION_ERRORS_GT(
3653: application_id,
3654: entity_code,
3655: event_class_code,
3656: trx_id,
3677: )
3678:
3679:
3680: WHEN (ZX_INVALID_LINE_TAX_AMT = 'Y') THEN
3681: INTO ZX_VALIDATION_ERRORS_GT(
3682: application_id,
3683: entity_code,
3684: event_class_code,
3685: trx_id,
3705: interface_line_id
3706: )
3707:
3708: WHEN (ZX_INVALID_TAX_FOR_ALLOC_FLG = 'Y') THEN
3709: INTO ZX_VALIDATION_ERRORS_GT(
3710: application_id,
3711: entity_code,
3712: event_class_code,
3713: trx_id,
3732: interface_line_entity_code,
3733: interface_line_id
3734: )
3735: WHEN (ZX_INVALID_TAX_ONLY_TAX_LINES = 'Y') THEN
3736: INTO ZX_VALIDATION_ERRORS_GT(
3737: application_id,
3738: entity_code,
3739: event_class_code,
3740: trx_id,
3760: interface_line_id
3761: )
3762:
3763: WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN
3764: INTO ZX_VALIDATION_ERRORS_GT(
3765: application_id,
3766: entity_code,
3767: event_class_code,
3768: trx_id,
3788: interface_line_id
3789: )
3790: --Commented for Bug#7504455--
3791: /*WHEN (NVL(TAX_RATE_NOT_EXISTS,'N') <> 'Y' AND TAX_RECOV_OR_OFFSET = 'Y') THEN
3792: INTO ZX_VALIDATION_ERRORS_GT(
3793: application_id,
3794: entity_code,
3795: event_class_code,
3796: trx_id,
3815: interface_line_entity_code,
3816: interface_line_id
3817: )*/
3818: WHEN (NVL(TAX_RATE_NOT_EXISTS,'N') <> 'Y' AND TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN
3819: INTO ZX_VALIDATION_ERRORS_GT(
3820: application_id,
3821: entity_code,
3822: event_class_code,
3823: trx_id,
3843: interface_line_id
3844: )
3845:
3846: WHEN (NVL(TAX_RATE_NOT_EXISTS,'N') <> 'Y' AND TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN
3847: INTO ZX_VALIDATION_ERRORS_GT(
3848: application_id,
3849: entity_code,
3850: event_class_code,
3851: trx_id,
4763: -- Have moved the validations that are specific to an Item line to a separate query.
4764: -- The Validations here are Tax Line related Validations only.
4765: INSERT ALL
4766: WHEN (REGIME_NOT_EXISTS = 'Y') THEN
4767: INTO ZX_VALIDATION_ERRORS_GT(
4768: application_id,
4769: entity_code,
4770: event_class_code,
4771: trx_id,
4790: interface_tax_entity_code,
4791: interface_tax_line_id
4792: )
4793: WHEN (ZX_REGIME_NOT_EFF_IN_SUBSCR = 'Y') THEN
4794: INTO ZX_VALIDATION_ERRORS_GT(
4795: application_id,
4796: entity_code,
4797: event_class_code,
4798: trx_id,
4817: interface_tax_entity_code,
4818: interface_tax_line_id
4819: )
4820: WHEN (REGIME_NOT_EFFECTIVE = 'Y') THEN
4821: INTO ZX_VALIDATION_ERRORS_GT(
4822: application_id,
4823: entity_code,
4824: event_class_code,
4825: trx_id,
4844: interface_tax_entity_code,
4845: interface_tax_line_id
4846: )
4847: WHEN (TAX_NOT_EXISTS = 'Y') THEN
4848: INTO ZX_VALIDATION_ERRORS_GT(
4849: application_id,
4850: entity_code,
4851: event_class_code,
4852: trx_id,
4871: interface_tax_entity_code,
4872: interface_tax_line_id
4873: )
4874: WHEN (TAX_NOT_LIVE = 'Y') THEN
4875: INTO ZX_VALIDATION_ERRORS_GT(
4876: application_id,
4877: entity_code,
4878: event_class_code,
4879: trx_id,
4898: interface_tax_entity_code,
4899: interface_tax_line_id
4900: )
4901: WHEN (TAX_NOT_EFFECTIVE = 'Y') THEN
4902: INTO ZX_VALIDATION_ERRORS_GT(
4903: application_id,
4904: entity_code,
4905: event_class_code,
4906: trx_id,
4925: interface_tax_entity_code,
4926: interface_tax_line_id
4927: )
4928: WHEN (TAX_STATUS_NOT_EXISTS = 'Y') THEN
4929: INTO ZX_VALIDATION_ERRORS_GT(
4930: application_id,
4931: entity_code,
4932: event_class_code,
4933: trx_id,
4952: interface_tax_entity_code,
4953: interface_tax_line_id
4954: )
4955: WHEN (TAX_STATUS_NOT_EFFECTIVE = 'Y') THEN
4956: INTO ZX_VALIDATION_ERRORS_GT(
4957: application_id,
4958: entity_code,
4959: event_class_code,
4960: trx_id,
4979: interface_tax_entity_code,
4980: interface_tax_line_id
4981: )
4982: WHEN (JUR_CODE_NOT_EXISTS = 'Y') THEN
4983: INTO ZX_VALIDATION_ERRORS_GT(
4984: application_id,
4985: entity_code,
4986: event_class_code,
4987: trx_id,
5006: interface_tax_entity_code,
5007: interface_tax_line_id
5008: )
5009: WHEN (JUR_CODE_NOT_EFFECTIVE = 'Y') THEN
5010: INTO ZX_VALIDATION_ERRORS_GT(
5011: application_id,
5012: entity_code,
5013: event_class_code,
5014: trx_id,
5033: interface_tax_entity_code,
5034: interface_tax_line_id
5035: )
5036: WHEN (DEFAULT_STATUS_NOT_EXISTS = 'Y') THEN
5037: INTO ZX_VALIDATION_ERRORS_GT(
5038: application_id,
5039: entity_code,
5040: event_class_code,
5041: trx_id,
5060: interface_tax_entity_code,
5061: interface_tax_line_id
5062: )
5063: WHEN (TAX_AMT_MISSING = 'Y') THEN
5064: INTO ZX_VALIDATION_ERRORS_GT(
5065: application_id,
5066: entity_code,
5067: event_class_code,
5068: trx_id,
5085: interface_tax_entity_code,
5086: interface_tax_line_id
5087: )
5088: WHEN (ZX_TAX_LINE_ALLOC_FLAG_INVALID = 'Y') THEN
5089: INTO ZX_VALIDATION_ERRORS_GT(
5090: application_id,
5091: entity_code,
5092: event_class_code,
5093: trx_id,
5112: interface_tax_entity_code,
5113: interface_tax_line_id
5114: )
5115: WHEN (ZX_INVALID_TAX_ALLOC_FLAG = 'Y') THEN
5116: INTO ZX_VALIDATION_ERRORS_GT(
5117: application_id,
5118: entity_code,
5119: event_class_code,
5120: trx_id,
5137: interface_tax_entity_code,
5138: interface_tax_line_id
5139: )
5140: WHEN (TAX_LN_TYP_LOC_NOT_ALLW_F_AR = 'Y' ) THEN
5141: INTO ZX_VALIDATION_ERRORS_GT(
5142: application_id,
5143: entity_code,
5144: event_class_code,
5145: trx_id,
5165: interface_tax_entity_code,
5166: interface_tax_line_id
5167: )
5168: WHEN (TAX_INCL_FLAG_MISMATCH = 'Y' ) THEN
5169: INTO ZX_VALIDATION_ERRORS_GT(
5170: application_id,
5171: entity_code,
5172: event_class_code,
5173: trx_id,
5193: interface_tax_entity_code,
5194: interface_tax_line_id
5195: )
5196: WHEN (ZX_IMP_TAX_RATE_AMT_MISMATCH = 'Y') THEN
5197: INTO ZX_VALIDATION_ERRORS_GT(
5198: application_id,
5199: entity_code,
5200: event_class_code,
5201: trx_id,
5667: END IF;
5668:
5669: INSERT ALL
5670: WHEN (SAMETAX_MULTIALLOC_TO_SAMELN = 'Y') THEN
5671: INTO ZX_VALIDATION_ERRORS_GT(
5672: application_id,
5673: entity_code,
5674: event_class_code,
5675: trx_id,
5694: interface_tax_entity_code,
5695: interface_tax_line_id
5696: )
5697: WHEN (TAX_ONLY_LINE_MULTI_ALLOCATED = 'Y') THEN
5698: INTO ZX_VALIDATION_ERRORS_GT(
5699: application_id,
5700: entity_code,
5701: event_class_code,
5702: trx_id,
5721: interface_tax_entity_code,
5722: interface_tax_line_id
5723: )
5724: WHEN (PSEUDO_LINE_HAS_MULTI_TAXALLOC = 'Y') THEN
5725: INTO ZX_VALIDATION_ERRORS_GT(
5726: application_id,
5727: entity_code,
5728: event_class_code,
5729: trx_id,
5748: interface_line_entity_code,
5749: interface_line_id
5750: )
5751: WHEN (ZX_TAX_MISSING_IN_APPLIED_FRM = 'Y') THEN
5752: INTO ZX_VALIDATION_ERRORS_GT(
5753: application_id,
5754: entity_code,
5755: event_class_code,
5756: trx_id,
5776: interface_tax_line_id
5777: )
5778:
5779: WHEN (ZX_TAX_MISSING_IN_ADJUSTED_TO = 'Y') THEN
5780: INTO ZX_VALIDATION_ERRORS_GT(
5781: application_id,
5782: entity_code,
5783: event_class_code,
5784: trx_id,
6185: lines_gt.trx_line_id = taxlines_gt.trx_line_id;
6186:
6187: INSERT ALL
6188: WHEN (SAMETAX_MULTIALLOC_TO_SAMELN = 'Y') THEN
6189: INTO ZX_VALIDATION_ERRORS_GT(
6190: application_id,
6191: entity_code,
6192: event_class_code,
6193: trx_id,
6212: interface_tax_entity_code,
6213: interface_tax_line_id
6214: )
6215: WHEN (TAX_ONLY_LINE_MULTI_ALLOCATED = 'Y') THEN
6216: INTO ZX_VALIDATION_ERRORS_GT(
6217: application_id,
6218: entity_code,
6219: event_class_code,
6220: trx_id,
6239: interface_tax_entity_code,
6240: interface_tax_line_id
6241: )
6242: WHEN (PSEUDO_LINE_HAS_MULTI_TAXALLOC = 'Y') THEN
6243: INTO ZX_VALIDATION_ERRORS_GT(
6244: application_id,
6245: entity_code,
6246: event_class_code,
6247: trx_id,
6266: interface_line_entity_code,
6267: interface_line_id
6268: )
6269: WHEN (ZX_TAX_MISSING_IN_APPLIED_FRM = 'Y') THEN
6270: INTO ZX_VALIDATION_ERRORS_GT(
6271: application_id,
6272: entity_code,
6273: event_class_code,
6274: trx_id,
6294: interface_tax_line_id
6295: )
6296:
6297: WHEN (ZX_TAX_MISSING_IN_ADJUSTED_TO = 'Y') THEN
6298: INTO ZX_VALIDATION_ERRORS_GT(
6299: application_id,
6300: entity_code,
6301: event_class_code,
6302: trx_id,
6749: END IF;
6750:
6751: INSERT ALL
6752: WHEN (SAMETAX_MULTIALLOC_TO_SAMELN = 'Y') THEN
6753: INTO ZX_VALIDATION_ERRORS_GT(
6754: application_id,
6755: entity_code,
6756: event_class_code,
6757: trx_id,
6776: interface_tax_entity_code,
6777: interface_tax_line_id
6778: )
6779: WHEN (TAX_ONLY_LINE_MULTI_ALLOCATED = 'Y') THEN
6780: INTO ZX_VALIDATION_ERRORS_GT(
6781: application_id,
6782: entity_code,
6783: event_class_code,
6784: trx_id,
6803: interface_tax_entity_code,
6804: interface_tax_line_id
6805: )
6806: WHEN (PSEUDO_LINE_HAS_MULTI_TAXALLOC = 'Y') THEN
6807: INTO ZX_VALIDATION_ERRORS_GT(
6808: application_id,
6809: entity_code,
6810: event_class_code,
6811: trx_id,
6830: interface_line_entity_code,
6831: interface_line_id
6832: )
6833: WHEN (ZX_TAX_MISSING_IN_APPLIED_FRM = 'Y') THEN
6834: INTO ZX_VALIDATION_ERRORS_GT(
6835: application_id,
6836: entity_code,
6837: event_class_code,
6838: trx_id,
6857: interface_tax_entity_code,
6858: interface_tax_line_id
6859: )
6860: WHEN (ZX_TAX_MISSING_IN_ADJUSTED_TO = 'Y') THEN
6861: INTO ZX_VALIDATION_ERRORS_GT(
6862: application_id,
6863: entity_code,
6864: event_class_code,
6865: trx_id,
7306:
7307: -- Bug 5018766
7308: INSERT ALL
7309: WHEN (REG_SUBSCR_NOT_EFFECTIVE = 'Y') THEN
7310: INTO ZX_VALIDATION_ERRORS_GT(
7311: application_id,
7312: entity_code,
7313: event_class_code,
7314: trx_id,
7333: interface_tax_entity_code,
7334: interface_tax_line_id
7335: )
7336: WHEN (TAX_SUBSCR_NOT_EFFECTIVE = 'Y') THEN
7337: INTO ZX_VALIDATION_ERRORS_GT(
7338: application_id,
7339: entity_code,
7340: event_class_code,
7341: trx_id,
7360: interface_tax_entity_code,
7361: interface_tax_line_id
7362: )
7363: WHEN (STATUS_SUBSCR_NOT_EFFECTIVE = 'Y') THEN
7364: INTO ZX_VALIDATION_ERRORS_GT(
7365: application_id,
7366: entity_code,
7367: event_class_code,
7368: trx_id,
7610: --
7611: -- bug 13527056
7612: -- rewriting query to delete duplicate records existing in zx_validation_erros_gt
7613: --
7614: DELETE FROM zx_validation_errors_gt
7615: WHERE ROWID IN
7616: (SELECT rn FROM
7617: (SELECT ROWID rn,
7618: DENSE_RANK() OVER (PARTITION BY application_id, entity_code,
7619: event_class_code, trx_id,
7620: trx_line_id, summary_tax_line_number,
7621: message_name
7622: ORDER BY ROWID )AS row_rank
7623: FROM zx_validation_errors_gt
7624: )
7625: WHERE row_rank <> 1
7626: );
7627:
7631: END IF;
7632:
7633: INSERT ALL
7634: WHEN (TAX_RATE_CODE_NOT_EXISTS = 'Y') THEN
7635: INTO ZX_VALIDATION_ERRORS_GT(
7636: application_id,
7637: entity_code,
7638: event_class_code,
7639: trx_id,
7659: interface_tax_line_id
7660: )
7661:
7662: WHEN (TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN
7663: INTO ZX_VALIDATION_ERRORS_GT(
7664: application_id,
7665: entity_code,
7666: event_class_code,
7667: trx_id,
7687: interface_tax_line_id
7688: )
7689:
7690: WHEN (TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN
7691: INTO ZX_VALIDATION_ERRORS_GT(
7692: application_id,
7693: entity_code,
7694: event_class_code,
7695: trx_id,
7715: interface_tax_line_id
7716: )
7717:
7718: WHEN (TAX_RATE_PERCENTAGE_INVALID = 'Y') THEN
7719: INTO ZX_VALIDATION_ERRORS_GT(
7720: application_id,
7721: entity_code,
7722: event_class_code,
7723: trx_id,
7742: interface_tax_entity_code,
7743: interface_tax_line_id
7744: )
7745: WHEN (TAX_RECOV_OR_OFFSET = 'Y') THEN
7746: INTO ZX_VALIDATION_ERRORS_GT(
7747: application_id,
7748: entity_code,
7749: event_class_code,
7750: trx_id,
7769: interface_tax_entity_code,
7770: interface_tax_line_id
7771: )
7772: WHEN (DEFAULT_RATE_CODE_NOT_EXISTS = 'Y') THEN
7773: INTO ZX_VALIDATION_ERRORS_GT(
7774: application_id,
7775: entity_code,
7776: event_class_code,
7777: trx_id,
8025: END IF;
8026:
8027: INSERT ALL
8028: WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN
8029: INTO ZX_VALIDATION_ERRORS_GT(
8030: application_id,
8031: entity_code,
8032: event_class_code,
8033: trx_id,
8052: interface_tax_entity_code,
8053: interface_tax_line_id
8054: )
8055: WHEN (TAX_RATE_NOT_EFFECTIVE = 'Y') THEN
8056: INTO ZX_VALIDATION_ERRORS_GT(
8057: application_id,
8058: entity_code,
8059: event_class_code,
8060: trx_id,
8079: interface_tax_entity_code,
8080: interface_tax_line_id
8081: )
8082: WHEN (TAX_RATE_NOT_ACTIVE = 'Y') THEN
8083: INTO ZX_VALIDATION_ERRORS_GT(
8084: application_id,
8085: entity_code,
8086: event_class_code,
8087: trx_id,
8339: END IF;
8340:
8341: INSERT ALL
8342: WHEN (ZX_INVALID_TRX_LINE_ID = 'Y') THEN
8343: INTO ZX_VALIDATION_ERRORS_GT(
8344: application_id,
8345: entity_code,
8346: event_class_code,
8347: trx_id,
8366: interface_tax_entity_code,
8367: interface_tax_line_id
8368: )
8369: WHEN (ZX_INVALID_SUMMARY_TAX_LINE_ID = 'Y') THEN
8370: INTO ZX_VALIDATION_ERRORS_GT(
8371: application_id,
8372: entity_code,
8373: event_class_code,
8374: trx_id,
8439: -- Bug Fix # 4184091
8440: -- As per the email communication from vidya, changed the flag value from Y to N
8441: UPDATE zx_trx_headers_gt
8442: SET validation_check_flag = 'N'
8443: WHERE trx_id IN (SELECT trx_id FROM zx_validation_errors_gt);
8444:
8445: IF ( SQL%ROWCOUNT > 0 ) THEN
8446: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8447: IF ( g_level_statement >= g_current_runtime_level) THEN
8573: END IF;
8574:
8575: INSERT ALL
8576: WHEN (ZX_REF_DOC_MISSING = 'Y') THEN
8577: INTO ZX_VALIDATION_ERRORS_GT(
8578: application_id,
8579: entity_code,
8580: event_class_code,
8581: trx_id,
8606: interface_line_entity_code,
8607: interface_line_id
8608: )
8609: WHEN (ZX_REL_DOC_MISSING = 'Y') THEN
8610: INTO ZX_VALIDATION_ERRORS_GT(
8611: application_id,
8612: entity_code,
8613: event_class_code,
8614: trx_id,
8631: rel_doc_event_class_code,
8632: rel_doc_trx_id
8633: )
8634: WHEN (ZX_APP_FROM_DOC_MISSING = 'Y') THEN
8635: INTO ZX_VALIDATION_ERRORS_GT(
8636: application_id,
8637: entity_code,
8638: event_class_code,
8639: trx_id,
8668: not check whether the doc exists in eTax repository
8669:
8670: WHEN (ZX_APP_TO_DOC_MISSING = 'Y') THEN
8671:
8672: INTO ZX_VALIDATION_ERRORS_GT(
8673: application_id,
8674: entity_code,
8675: event_class_code,
8676: trx_id,
8703: interface_line_id
8704: )
8705: */
8706: WHEN (ZX_ADJ_DOC_MISSING = 'Y') THEN
8707: INTO ZX_VALIDATION_ERRORS_GT(
8708: application_id,
8709: entity_code,
8710: event_class_code,
8711: trx_id,
8736: interface_line_entity_code,
8737: interface_line_id
8738: )
8739: WHEN (ZX_SOURCE_DOC_MISSING = 'Y') THEN
8740: INTO ZX_VALIDATION_ERRORS_GT(
8741: application_id,
8742: entity_code,
8743: event_class_code,
8744: trx_id,