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.ZX_VALIDATE_API_PKG dependencies on ZX_VALIDATION_ERRORS_GT

Line 116: l_error_rec ZX_VALIDATION_ERRORS_GT%rowtype;

112: l_count_link_gt NUMBER;
113:
114: l_count_error NUMBER;
115:
116: l_error_rec ZX_VALIDATION_ERRORS_GT%rowtype;
117:
118: --Declare Forward references
119: PROCEDURE Validate_Other_Documents(x_return_status OUT NOCOPY VARCHAR2);
120: procedure def_additional_tax_attribs;

Line 149: from zx_validation_errors_gt;

145: other_doc_event_class_code,
146: other_doc_trx_id,
147: interface_line_entity_code,
148: interface_line_id
149: from zx_validation_errors_gt;
150:
151: BEGIN
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 262: delete from ZX_VALIDATION_ERRORS_GT err where EXISTS

258:
259: zx_on_fly_trx_upgrade_pkg.upgrade_trx_on_fly_blk(x_return_status);
260:
261: -- Bug # 4697301
262: delete from ZX_VALIDATION_ERRORS_GT err where EXISTS
263: (Select 1 from ZX_LINES_DET_FACTORS linedet where
264: linedet.application_id = err.other_doc_application_id and
265: linedet.entity_code = err.other_doc_entity_code and
266: linedet.event_class_code = err.other_doc_event_class_code and

Line 277: ZX_VALIDATION_ERRORS_GT(

273: 'Before defaulting, validate either tax_rate_id or tax_rate_code is passed in the import tax lines GT table');
274: END IF;
275:
276: INSERT INTO
277: ZX_VALIDATION_ERRORS_GT(
278: application_id,
279: entity_code,
280: event_class_code,
281: trx_id,

Line 1982: 'Before insertion into ZX_VALIDATION_ERRORS_GT - zx_trx_headers_gt and zx_transaction_lines_gt');

1978: END IF; -- End of debug checking
1979:
1980: IF ( g_level_statement >= g_current_runtime_level) THEN
1981: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1982: 'Before insertion into ZX_VALIDATION_ERRORS_GT - zx_trx_headers_gt and zx_transaction_lines_gt');
1983: END IF;
1984:
1985: /******************** Split the Header and Line Level Validations : Bug 4703541******/
1986: /** 1. Validations for the zx_trx_headers_gt related **/

Line 1990: INTO ZX_VALIDATION_ERRORS_GT(

1986: /** 1. Validations for the zx_trx_headers_gt related **/
1987:
1988: INSERT ALL
1989: WHEN (ZX_ROUND_PARTY_MISSING = 'Y') THEN
1990: INTO ZX_VALIDATION_ERRORS_GT(
1991: application_id,
1992: entity_code,
1993: event_class_code,
1994: trx_id,

Line 2018: INTO ZX_VALIDATION_ERRORS_GT(

2014: NULL --interface_line_id
2015: )
2016: WHEN (ZX_CTRL_FLAG_MISSING = 'Y') THEN
2017:
2018: INTO ZX_VALIDATION_ERRORS_GT(
2019: application_id,
2020: entity_code,
2021: event_class_code,
2022: trx_id,

Line 2046: INTO ZX_VALIDATION_ERRORS_GT(

2042: NULL --interface_line_id
2043: )
2044: WHEN (TAXATION_COUNTRY_NOT_EXISTS = 'Y') THEN
2045:
2046: INTO ZX_VALIDATION_ERRORS_GT(
2047: application_id,
2048: entity_code,
2049: event_class_code,
2050: trx_id,

Line 2074: INTO ZX_VALIDATION_ERRORS_GT(

2070: NULL --interface_line_id
2071: )
2072: WHEN (DOC_FC_CODE_NOT_EXISTS = 'Y') THEN
2073:
2074: INTO ZX_VALIDATION_ERRORS_GT(
2075: application_id,
2076: entity_code,
2077: event_class_code,
2078: trx_id,

Line 2103: INTO ZX_VALIDATION_ERRORS_GT(

2099: )
2100:
2101: WHEN (DOC_FC_COUNTRY_INCONSIS = 'Y') THEN
2102:
2103: INTO ZX_VALIDATION_ERRORS_GT(
2104: application_id,
2105: entity_code,
2106: event_class_code,
2107: trx_id,

Line 2131: INTO ZX_VALIDATION_ERRORS_GT(

2127: NULL --interface_line_id
2128: )
2129: WHEN (PARTY_NOT_EXISTS = 'Y') THEN
2130:
2131: INTO ZX_VALIDATION_ERRORS_GT(
2132: application_id,
2133: entity_code,
2134: event_class_code,
2135: trx_id,

Line 2159: INTO ZX_VALIDATION_ERRORS_GT(

2155: NULL --interface_line_id
2156: )
2157: WHEN (ZX_CURRENCY_INFO_REQD = 'Y') THEN
2158:
2159: INTO ZX_VALIDATION_ERRORS_GT(
2160: application_id,
2161: entity_code,
2162: event_class_code,
2163: trx_id,

Line 2187: INTO ZX_VALIDATION_ERRORS_GT(

2183: NULL --interface_line_id
2184: )
2185: WHEN (ZX_QUOTE_FLAG_INVALID = 'Y') THEN
2186:
2187: INTO ZX_VALIDATION_ERRORS_GT(
2188: application_id,
2189: entity_code,
2190: event_class_code,
2191: trx_id,

Line 2214: INTO ZX_VALIDATION_ERRORS_GT(

2210: NULL ,--interface_line_entity_code,
2211: NULL --interface_line_id
2212: )
2213: WHEN (ZX_DOC_LVL_RECALC_FLAG_INVALID = 'Y') THEN
2214: INTO ZX_VALIDATION_ERRORS_GT(
2215: application_id,
2216: entity_code,
2217: event_class_code,
2218: trx_id,

Line 2398: INTO ZX_VALIDATION_ERRORS_GT(

2394: INSERT ALL
2395:
2396: WHEN (ZX_LOCATION_MISSING = 'Y') THEN
2397:
2398: INTO ZX_VALIDATION_ERRORS_GT(
2399: application_id,
2400: entity_code,
2401: event_class_code,
2402: trx_id,

Line 2427: INTO ZX_VALIDATION_ERRORS_GT(

2423: )
2424:
2425: WHEN (ZX_LINE_CLASS_INVALID = 'Y') THEN
2426:
2427: INTO ZX_VALIDATION_ERRORS_GT(
2428: application_id,
2429: entity_code,
2430: event_class_code,
2431: trx_id,

Line 2456: INTO ZX_VALIDATION_ERRORS_GT(

2452: )
2453:
2454: WHEN (ZX_TRX_LINE_TYPE_INVALID = 'Y') THEN
2455:
2456: INTO ZX_VALIDATION_ERRORS_GT(
2457: application_id,
2458: entity_code,
2459: event_class_code,
2460: trx_id,

Line 2485: INTO ZX_VALIDATION_ERRORS_GT(

2481: )
2482:
2483: WHEN (ZX_LINE_AMT_INCL_TAX_INVALID = 'Y') THEN
2484:
2485: INTO ZX_VALIDATION_ERRORS_GT(
2486: application_id,
2487: entity_code,
2488: event_class_code,
2489: trx_id,

Line 2514: INTO ZX_VALIDATION_ERRORS_GT(

2510: )
2511:
2512: WHEN (PRODUCT_CATEG_NOT_EXISTS = 'Y') THEN
2513:
2514: INTO ZX_VALIDATION_ERRORS_GT(
2515: application_id,
2516: entity_code,
2517: event_class_code,
2518: trx_id,

Line 2543: INTO ZX_VALIDATION_ERRORS_GT(

2539: )
2540:
2541: WHEN (PRODUCT_CATEG_NOT_EFFECTIVE = 'Y') THEN
2542:
2543: INTO ZX_VALIDATION_ERRORS_GT(
2544: application_id,
2545: entity_code,
2546: event_class_code,
2547: trx_id,

Line 2572: INTO ZX_VALIDATION_ERRORS_GT(

2568: )
2569:
2570: WHEN (PRODUCT_CATEG_COUNTRY_INCONSIS = 'Y') THEN
2571:
2572: INTO ZX_VALIDATION_ERRORS_GT(
2573: application_id,
2574: entity_code,
2575: event_class_code,
2576: trx_id,

Line 2601: INTO ZX_VALIDATION_ERRORS_GT(

2597: )
2598:
2599: WHEN (USER_DEF_FC_CODE_NOT_EXISTS = 'Y') THEN
2600:
2601: INTO ZX_VALIDATION_ERRORS_GT(
2602: application_id,
2603: entity_code,
2604: event_class_code,
2605: trx_id,

Line 2630: INTO ZX_VALIDATION_ERRORS_GT(

2626: )
2627:
2628: WHEN (USER_DEF_FC_CODE_NOT_EFFECTIVE = 'Y') THEN
2629:
2630: INTO ZX_VALIDATION_ERRORS_GT(
2631: application_id,
2632: entity_code,
2633: event_class_code,
2634: trx_id,

Line 2658: INTO ZX_VALIDATION_ERRORS_GT(

2654: interface_line_id
2655: )
2656: WHEN (USER_DEF_COUNTRY_INCONSIS = 'Y') THEN
2657:
2658: INTO ZX_VALIDATION_ERRORS_GT(
2659: application_id,
2660: entity_code,
2661: event_class_code,
2662: trx_id,

Line 2687: INTO ZX_VALIDATION_ERRORS_GT(

2683: )
2684:
2685: WHEN (DOC_FC_CODE_NOT_EFFECTIVE = 'Y') THEN
2686:
2687: INTO ZX_VALIDATION_ERRORS_GT(
2688: application_id,
2689: entity_code,
2690: event_class_code,
2691: trx_id,

Line 2716: INTO ZX_VALIDATION_ERRORS_GT(

2712: )
2713:
2714: WHEN (TRX_BIZ_FC_CODE_NOT_EXISTS = 'Y') THEN
2715:
2716: INTO ZX_VALIDATION_ERRORS_GT(
2717: application_id,
2718: entity_code,
2719: event_class_code,
2720: trx_id,

Line 2745: INTO ZX_VALIDATION_ERRORS_GT(

2741: )
2742:
2743: WHEN (TRX_BIZ_FC_CODE_NOT_EFFECTIVE = 'Y') THEN
2744:
2745: INTO ZX_VALIDATION_ERRORS_GT(
2746: application_id,
2747: entity_code,
2748: event_class_code,
2749: trx_id,

Line 2774: INTO ZX_VALIDATION_ERRORS_GT(

2770: )
2771:
2772: WHEN (TRX_BIZ_FC_COUNTRY_INCONSIS = 'Y') THEN
2773:
2774: INTO ZX_VALIDATION_ERRORS_GT(
2775: application_id,
2776: entity_code,
2777: event_class_code,
2778: trx_id,

Line 2805: INTO ZX_VALIDATION_ERRORS_GT(

2801:
2802:
2803: WHEN (INTENDED_USE_CODE_NOT_EXISTS = 'Y') THEN
2804:
2805: INTO ZX_VALIDATION_ERRORS_GT(
2806: application_id,
2807: entity_code,
2808: event_class_code,
2809: trx_id,

Line 2834: INTO ZX_VALIDATION_ERRORS_GT(

2830: )
2831:
2832: WHEN (INTENDED_USE_NOT_EFFECTIVE = 'Y') THEN
2833:
2834: INTO ZX_VALIDATION_ERRORS_GT(
2835: application_id,
2836: entity_code,
2837: event_class_code,
2838: trx_id,

Line 2863: INTO ZX_VALIDATION_ERRORS_GT(

2859: )
2860:
2861: WHEN (INTENDED_USE_CONTRY_INCONSIS = 'Y') THEN
2862:
2863: INTO ZX_VALIDATION_ERRORS_GT(
2864: application_id,
2865: entity_code,
2866: event_class_code,
2867: trx_id,

Line 2892: INTO ZX_VALIDATION_ERRORS_GT(

2888: )
2889:
2890: WHEN (PRODUCT_TYPE_CODE_NOT_EXISTS = 'Y') THEN
2891:
2892: INTO ZX_VALIDATION_ERRORS_GT(
2893: application_id,
2894: entity_code,
2895: event_class_code,
2896: trx_id,

Line 2921: INTO ZX_VALIDATION_ERRORS_GT(

2917: )
2918:
2919: WHEN (PRODUCT_TYPE_NOT_EFFECTIVE = 'Y') THEN
2920:
2921: INTO ZX_VALIDATION_ERRORS_GT(
2922: application_id,
2923: entity_code,
2924: event_class_code,
2925: trx_id,

Line 2950: INTO ZX_VALIDATION_ERRORS_GT(

2946: )
2947:
2948: WHEN (PRODUCT_FC_CODE_NOT_EXISTS = 'Y') THEN
2949:
2950: INTO ZX_VALIDATION_ERRORS_GT(
2951: application_id,
2952: entity_code,
2953: event_class_code,
2954: trx_id,

Line 2979: INTO ZX_VALIDATION_ERRORS_GT(

2975: )
2976: /* bugfix 4919842: remove party not exist and site not exist checks
2977: WHEN (SHIP_TO_PARTY_NOT_EXISTS = 'Y') THEN
2978:
2979: INTO ZX_VALIDATION_ERRORS_GT(
2980: application_id,
2981: entity_code,
2982: event_class_code,
2983: trx_id,

Line 3008: INTO ZX_VALIDATION_ERRORS_GT(

3004: )
3005:
3006: WHEN (SHIP_FROM_PARTY_NOT_EXISTS = 'Y') THEN
3007:
3008: INTO ZX_VALIDATION_ERRORS_GT(
3009: application_id,
3010: entity_code,
3011: event_class_code,
3012: trx_id,

Line 3037: INTO ZX_VALIDATION_ERRORS_GT(

3033: )
3034:
3035: WHEN (BILL_TO_PARTY_NOT_EXISTS = 'Y') THEN
3036:
3037: INTO ZX_VALIDATION_ERRORS_GT(
3038: application_id,
3039: entity_code,
3040: event_class_code,
3041: trx_id,

Line 3066: INTO ZX_VALIDATION_ERRORS_GT(

3062: )
3063:
3064: WHEN (BILL_FROM_PARTY_NOT_EXISTS = 'Y') THEN
3065:
3066: INTO ZX_VALIDATION_ERRORS_GT(
3067: application_id,
3068: entity_code,
3069: event_class_code,
3070: trx_id,

Line 3095: INTO ZX_VALIDATION_ERRORS_GT(

3091: )
3092:
3093: WHEN (SHIPTO_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3094:
3095: INTO ZX_VALIDATION_ERRORS_GT(
3096: application_id,
3097: entity_code,
3098: event_class_code,
3099: trx_id,

Line 3124: INTO ZX_VALIDATION_ERRORS_GT(

3120: )
3121:
3122: WHEN (SHIPFROM_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3123:
3124: INTO ZX_VALIDATION_ERRORS_GT(
3125: application_id,
3126: entity_code,
3127: event_class_code,
3128: trx_id,

Line 3153: INTO ZX_VALIDATION_ERRORS_GT(

3149: )
3150:
3151: WHEN (BILLTO_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3152:
3153: INTO ZX_VALIDATION_ERRORS_GT(
3154: application_id,
3155: entity_code,
3156: event_class_code,
3157: trx_id,

Line 3182: INTO ZX_VALIDATION_ERRORS_GT(

3178: )
3179:
3180: WHEN (BILLFROM_PARTY_SITE_NOT_EXISTS = 'Y') THEN
3181:
3182: INTO ZX_VALIDATION_ERRORS_GT(
3183: application_id,
3184: entity_code,
3185: event_class_code,
3186: trx_id,

Line 3212: INTO ZX_VALIDATION_ERRORS_GT(

3208: bugfix 4919842: remove party not exist and site not exist checks */
3209: -- bug 6915776
3210: /*WHEN (ZX_LINE_CTRL_AMT_INVALID = 'Y') THEN
3211:
3212: INTO ZX_VALIDATION_ERRORS_GT(
3213: application_id,
3214: entity_code,
3215: event_class_code,
3216: trx_id,

Line 3241: INTO ZX_VALIDATION_ERRORS_GT(

3237: )*/
3238:
3239: WHEN (ZX_LINE_CTRL_AMT_NOT_NULL = 'Y') THEN
3240:
3241: INTO ZX_VALIDATION_ERRORS_GT(
3242: application_id,
3243: entity_code,
3244: event_class_code,
3245: trx_id,

Line 3272: INTO ZX_VALIDATION_ERRORS_GT(

3268: -- Bug 5516630: Moved unit price and quantity check to determine_recovery API
3269:
3270: /* WHEN (ZX_UNIT_PRICE_MISSING = 'Y') THEN
3271:
3272: INTO ZX_VALIDATION_ERRORS_GT(
3273: application_id,
3274: entity_code,
3275: event_class_code,
3276: trx_id,

Line 3301: INTO ZX_VALIDATION_ERRORS_GT(

3297: )
3298:
3299: WHEN (ZX_LINE_QUANTITY_MISSING = 'Y') THEN
3300:
3301: INTO ZX_VALIDATION_ERRORS_GT(
3302: application_id,
3303: entity_code,
3304: event_class_code,
3305: trx_id,

Line 3330: INTO ZX_VALIDATION_ERRORS_GT(

3326: )
3327: */
3328: WHEN (ZX_EXEMPTION_CTRL_FLAG_INVALID = 'Y') THEN
3329:
3330: INTO ZX_VALIDATION_ERRORS_GT(
3331: application_id,
3332: entity_code,
3333: event_class_code,
3334: trx_id,

Line 3358: INTO ZX_VALIDATION_ERRORS_GT(

3354: interface_line_id
3355: )
3356: WHEN (ZX_PRODUCT_TYPE_INVALID = 'Y') THEN
3357:
3358: INTO ZX_VALIDATION_ERRORS_GT(
3359: application_id,
3360: entity_code,
3361: event_class_code,
3362: trx_id,

Line 3387: INTO ZX_VALIDATION_ERRORS_GT(

3383: )
3384:
3385: WHEN (ZX_INVALID_TAX_LINES = 'Y') THEN
3386:
3387: INTO ZX_VALIDATION_ERRORS_GT(
3388: application_id,
3389: entity_code,
3390: event_class_code,
3391: trx_id,

Line 3417: INTO ZX_VALIDATION_ERRORS_GT(

3413:
3414:
3415: WHEN (ZX_INVALID_LINE_TAX_AMT = 'Y') THEN
3416:
3417: INTO ZX_VALIDATION_ERRORS_GT(
3418: application_id,
3419: entity_code,
3420: event_class_code,
3421: trx_id,

Line 3446: INTO ZX_VALIDATION_ERRORS_GT(

3442: )
3443:
3444: WHEN (ZX_INVALID_TAX_FOR_ALLOC_FLG = 'Y') THEN
3445:
3446: INTO ZX_VALIDATION_ERRORS_GT(
3447: application_id,
3448: entity_code,
3449: event_class_code,
3450: trx_id,

Line 3474: INTO ZX_VALIDATION_ERRORS_GT(

3470: interface_line_id
3471: )
3472: WHEN (ZX_INVALID_TAX_ONLY_TAX_LINES = 'Y') THEN
3473:
3474: INTO ZX_VALIDATION_ERRORS_GT(
3475: application_id,
3476: entity_code,
3477: event_class_code,
3478: trx_id,

Line 3502: INTO ZX_VALIDATION_ERRORS_GT(

3498: interface_line_id
3499: )
3500: WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN
3501:
3502: INTO ZX_VALIDATION_ERRORS_GT(
3503: application_id,
3504: entity_code,
3505: event_class_code,
3506: trx_id,

Line 3530: INTO ZX_VALIDATION_ERRORS_GT(

3526: interface_line_id
3527: )
3528: --Commented for Bug#7504455--
3529: /*WHEN (NVL(TAX_RATE_NOT_EXISTS,'N') <> 'Y' AND TAX_RECOV_OR_OFFSET = 'Y') THEN
3530: INTO ZX_VALIDATION_ERRORS_GT(
3531: application_id,
3532: entity_code,
3533: event_class_code,
3534: trx_id,

Line 3558: INTO ZX_VALIDATION_ERRORS_GT(

3554: interface_line_id
3555: )*/
3556: WHEN (NVL(TAX_RATE_NOT_EXISTS,'N') <> 'Y' AND TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN
3557:
3558: INTO ZX_VALIDATION_ERRORS_GT(
3559: application_id,
3560: entity_code,
3561: event_class_code,
3562: trx_id,

Line 3586: INTO ZX_VALIDATION_ERRORS_GT(

3582: interface_line_id
3583: )
3584: WHEN (NVL(TAX_RATE_NOT_EXISTS,'N') <> 'Y' AND TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN
3585:
3586: INTO ZX_VALIDATION_ERRORS_GT(
3587: application_id,
3588: entity_code,
3589: event_class_code,
3590: trx_id,

Line 4287: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Imported Tax Lines Validations');

4283: END IF; -- End of debug checking
4284:
4285: IF ( g_level_statement >= g_current_runtime_level) THEN
4286: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4287: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Imported Tax Lines Validations');
4288: END IF;
4289:
4290: IF ( g_level_statement >= g_current_runtime_level) THEN
4291: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',

Line 4292: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Regime,Tax,Status and Jurisdiction related Imported Tax Lines Validations');

4288: END IF;
4289:
4290: IF ( g_level_statement >= g_current_runtime_level) THEN
4291: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
4292: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Regime,Tax,Status and Jurisdiction related Imported Tax Lines Validations');
4293: END IF;
4294:
4295: INSERT ALL
4296: WHEN (REGIME_NOT_EXISTS = 'Y') THEN

Line 4298: INTO ZX_VALIDATION_ERRORS_GT(

4294:
4295: INSERT ALL
4296: WHEN (REGIME_NOT_EXISTS = 'Y') THEN
4297:
4298: INTO ZX_VALIDATION_ERRORS_GT(
4299: application_id,
4300: entity_code,
4301: event_class_code,
4302: trx_id,

Line 4326: INTO ZX_VALIDATION_ERRORS_GT(

4322: interface_tax_line_id
4323: )
4324: WHEN (ZX_REGIME_NOT_EFF_IN_SUBSCR = 'Y') THEN
4325:
4326: INTO ZX_VALIDATION_ERRORS_GT(
4327: application_id,
4328: entity_code,
4329: event_class_code,
4330: trx_id,

Line 4354: INTO ZX_VALIDATION_ERRORS_GT(

4350: interface_tax_line_id
4351: )
4352: WHEN (REGIME_NOT_EFFECTIVE = 'Y') THEN
4353:
4354: INTO ZX_VALIDATION_ERRORS_GT(
4355: application_id,
4356: entity_code,
4357: event_class_code,
4358: trx_id,

Line 4382: INTO ZX_VALIDATION_ERRORS_GT(

4378: interface_tax_line_id
4379: )
4380: WHEN (TAX_NOT_EXISTS = 'Y') THEN
4381:
4382: INTO ZX_VALIDATION_ERRORS_GT(
4383: application_id,
4384: entity_code,
4385: event_class_code,
4386: trx_id,

Line 4410: INTO ZX_VALIDATION_ERRORS_GT(

4406: interface_tax_line_id
4407: )
4408: WHEN (TAX_NOT_LIVE = 'Y') THEN
4409:
4410: INTO ZX_VALIDATION_ERRORS_GT(
4411: application_id,
4412: entity_code,
4413: event_class_code,
4414: trx_id,

Line 4437: INTO ZX_VALIDATION_ERRORS_GT(

4433: interface_tax_entity_code,
4434: interface_tax_line_id
4435: )
4436: WHEN (TAX_NOT_EFFECTIVE = 'Y') THEN
4437: INTO ZX_VALIDATION_ERRORS_GT(
4438: application_id,
4439: entity_code,
4440: event_class_code,
4441: trx_id,

Line 4464: INTO ZX_VALIDATION_ERRORS_GT(

4460: interface_tax_entity_code,
4461: interface_tax_line_id
4462: )
4463: WHEN (TAX_STATUS_NOT_EXISTS = 'Y') THEN
4464: INTO ZX_VALIDATION_ERRORS_GT(
4465: application_id,
4466: entity_code,
4467: event_class_code,
4468: trx_id,

Line 4492: INTO ZX_VALIDATION_ERRORS_GT(

4488: interface_tax_line_id
4489: )
4490: WHEN (TAX_STATUS_NOT_EFFECTIVE = 'Y') THEN
4491:
4492: INTO ZX_VALIDATION_ERRORS_GT(
4493: application_id,
4494: entity_code,
4495: event_class_code,
4496: trx_id,

Line 4520: INTO ZX_VALIDATION_ERRORS_GT(

4516: interface_tax_line_id
4517: )
4518: WHEN (JUR_CODE_NOT_EXISTS = 'Y') THEN
4519:
4520: INTO ZX_VALIDATION_ERRORS_GT(
4521: application_id,
4522: entity_code,
4523: event_class_code,
4524: trx_id,

Line 4549: INTO ZX_VALIDATION_ERRORS_GT(

4545: )
4546:
4547: WHEN (JUR_CODE_NOT_EFFECTIVE = 'Y') THEN
4548:
4549: INTO ZX_VALIDATION_ERRORS_GT(
4550: application_id,
4551: entity_code,
4552: event_class_code,
4553: trx_id,

Line 4578: INTO ZX_VALIDATION_ERRORS_GT(

4574: )
4575:
4576: WHEN (DEFAULT_STATUS_NOT_EXISTS = 'Y') THEN
4577:
4578: INTO ZX_VALIDATION_ERRORS_GT(
4579: application_id,
4580: entity_code,
4581: event_class_code,
4582: trx_id,

Line 4607: INTO zx_validation_errors_gt(

4603: )
4604:
4605: WHEN (TAX_AMT_MISSING = 'Y') THEN
4606:
4607: INTO zx_validation_errors_gt(
4608: application_id,
4609: entity_code,
4610: event_class_code,
4611: trx_id,

Line 4635: INTO ZX_VALIDATION_ERRORS_GT(

4631: )
4632:
4633: WHEN (ZX_TAX_LINE_ALLOC_FLAG_INVALID = 'Y') THEN
4634:
4635: INTO ZX_VALIDATION_ERRORS_GT(
4636: application_id,
4637: entity_code,
4638: event_class_code,
4639: trx_id,

Line 4663: INTO ZX_VALIDATION_ERRORS_GT(

4659: interface_tax_line_id
4660: )
4661: WHEN (ZX_INVALID_TAX_ALLOC_FLAG = 'Y') THEN
4662:
4663: INTO ZX_VALIDATION_ERRORS_GT(
4664: application_id,
4665: entity_code,
4666: event_class_code,
4667: trx_id,

Line 4689: INTO zx_validation_errors_gt(

4685: interface_tax_line_id
4686: )
4687: WHEN (SAMETAX_MULTIALLOC_TO_SAMELN = 'Y') THEN
4688:
4689: INTO zx_validation_errors_gt(
4690: application_id,
4691: entity_code,
4692: event_class_code,
4693: trx_id,

Line 4717: INTO zx_validation_errors_gt(

4713: interface_tax_line_id
4714: )
4715: WHEN (TAX_ONLY_LINE_MULTI_ALLOCATED = 'Y') THEN
4716:
4717: INTO zx_validation_errors_gt(
4718: application_id,
4719: entity_code,
4720: event_class_code,
4721: trx_id,

Line 4745: INTO zx_validation_errors_gt(

4741: interface_line_id
4742: )
4743: WHEN (PSEUDO_LINE_HAS_MULTI_TAXALLOC = 'Y') THEN
4744:
4745: INTO zx_validation_errors_gt(
4746: application_id,
4747: entity_code,
4748: event_class_code,
4749: trx_id,

Line 4774: INTO zx_validation_errors_gt(

4770: )
4771:
4772: WHEN (TAX_LN_TYP_LOC_NOT_ALLW_F_AR = 'Y' ) THEN
4773:
4774: INTO zx_validation_errors_gt(
4775: application_id,
4776: entity_code,
4777: event_class_code,
4778: trx_id,

Line 4802: INTO zx_validation_errors_gt(

4798: interface_tax_line_id
4799: )
4800: WHEN (TAX_INCL_FLAG_MISMATCH = 'Y' ) THEN
4801:
4802: INTO zx_validation_errors_gt(
4803: application_id,
4804: entity_code,
4805: event_class_code,
4806: trx_id,

Line 4833: INTO zx_validation_errors_gt(

4829:
4830:
4831: WHEN (ZX_TAX_MISSING_IN_APPLIED_FRM = 'Y') THEN
4832:
4833: INTO zx_validation_errors_gt(
4834: application_id,
4835: entity_code,
4836: event_class_code,
4837: trx_id,

Line 4862: INTO zx_validation_errors_gt(

4858: )
4859:
4860: WHEN (ZX_TAX_MISSING_IN_ADJUSTED_TO = 'Y') THEN
4861:
4862: INTO zx_validation_errors_gt(
4863: application_id,
4864: entity_code,
4865: event_class_code,
4866: trx_id,

Line 4891: INTO zx_validation_errors_gt(

4887: )
4888:
4889: WHEN (ZX_IMP_TAX_RATE_AMT_MISMATCH = 'Y') THEN
4890:
4891: INTO zx_validation_errors_gt(
4892: application_id,
4893: entity_code,
4894: event_class_code,
4895: trx_id,

Line 5613: INTO ZX_VALIDATION_ERRORS_GT(

5609: -- Bug 5018766
5610: INSERT ALL
5611: WHEN (REG_SUBSCR_NOT_EFFECTIVE = 'Y') THEN
5612:
5613: INTO ZX_VALIDATION_ERRORS_GT(
5614: application_id,
5615: entity_code,
5616: event_class_code,
5617: trx_id,

Line 5640: INTO ZX_VALIDATION_ERRORS_GT(

5636: interface_tax_entity_code,
5637: interface_tax_line_id
5638: )
5639: WHEN (TAX_SUBSCR_NOT_EFFECTIVE = 'Y') THEN
5640: INTO ZX_VALIDATION_ERRORS_GT(
5641: application_id,
5642: entity_code,
5643: event_class_code,
5644: trx_id,

Line 5668: INTO ZX_VALIDATION_ERRORS_GT(

5664: interface_tax_line_id
5665: )
5666: WHEN (STATUS_SUBSCR_NOT_EFFECTIVE = 'Y') THEN
5667:
5668: INTO ZX_VALIDATION_ERRORS_GT(
5669: application_id,
5670: entity_code,
5671: event_class_code,
5672: trx_id,

Line 5888: DELETE FROM ZX_VALIDATION_ERRORS_GT A

5884: )
5885: );
5886:
5887: --Bug 5018766 : Delete any duplicate rows that might get inserted for that trx_id , trx_line_id from the above insert stmt.
5888: DELETE FROM ZX_VALIDATION_ERRORS_GT A
5889: WHERE A.ROWID < ( SELECT MAX(B.ROWID) FROM ZX_VALIDATION_ERRORS_GT B
5890: WHERE A.APPLICATION_ID = B.APPLICATION_ID
5891: AND A.ENTITY_CODE = B.ENTITY_CODE
5892: AND A.EVENT_CLASS_CODE = B.EVENT_CLASS_CODE

Line 5889: WHERE A.ROWID < ( SELECT MAX(B.ROWID) FROM ZX_VALIDATION_ERRORS_GT B

5885: );
5886:
5887: --Bug 5018766 : Delete any duplicate rows that might get inserted for that trx_id , trx_line_id from the above insert stmt.
5888: DELETE FROM ZX_VALIDATION_ERRORS_GT A
5889: WHERE A.ROWID < ( SELECT MAX(B.ROWID) FROM ZX_VALIDATION_ERRORS_GT B
5890: WHERE A.APPLICATION_ID = B.APPLICATION_ID
5891: AND A.ENTITY_CODE = B.ENTITY_CODE
5892: AND A.EVENT_CLASS_CODE = B.EVENT_CLASS_CODE
5893: AND A.TRX_ID = B.TRX_ID

Line 5901: 'Before insertion into ZX_VALIDATION_ERRORS_GT for RateCode related Imported Tax Lines Validations');

5897: AND A.MESSAGE_NAME = B.MESSAGE_NAME );
5898:
5899: IF ( g_level_statement >= g_current_runtime_level) THEN
5900: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
5901: 'Before insertion into ZX_VALIDATION_ERRORS_GT for RateCode related Imported Tax Lines Validations');
5902: END IF;
5903:
5904: INSERT ALL
5905: WHEN (TAX_RATE_CODE_NOT_EXISTS = 'Y') THEN

Line 5907: INTO ZX_VALIDATION_ERRORS_GT(

5903:
5904: INSERT ALL
5905: WHEN (TAX_RATE_CODE_NOT_EXISTS = 'Y') THEN
5906:
5907: INTO ZX_VALIDATION_ERRORS_GT(
5908: application_id,
5909: entity_code,
5910: event_class_code,
5911: trx_id,

Line 5936: INTO ZX_VALIDATION_ERRORS_GT(

5932: )
5933:
5934: WHEN (TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN
5935:
5936: INTO ZX_VALIDATION_ERRORS_GT(
5937: application_id,
5938: entity_code,
5939: event_class_code,
5940: trx_id,

Line 5965: INTO ZX_VALIDATION_ERRORS_GT(

5961: )
5962:
5963: WHEN (TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN
5964:
5965: INTO ZX_VALIDATION_ERRORS_GT(
5966: application_id,
5967: entity_code,
5968: event_class_code,
5969: trx_id,

Line 5994: INTO ZX_VALIDATION_ERRORS_GT(

5990: )
5991:
5992: WHEN (TAX_RATE_PERCENTAGE_INVALID = 'Y') THEN
5993:
5994: INTO ZX_VALIDATION_ERRORS_GT(
5995: application_id,
5996: entity_code,
5997: event_class_code,
5998: trx_id,

Line 6021: INTO ZX_VALIDATION_ERRORS_GT(

6017: interface_tax_entity_code,
6018: interface_tax_line_id
6019: )
6020: WHEN (TAX_RECOV_OR_OFFSET = 'Y') THEN
6021: INTO ZX_VALIDATION_ERRORS_GT(
6022: application_id,
6023: entity_code,
6024: event_class_code,
6025: trx_id,

Line 6049: INTO ZX_VALIDATION_ERRORS_GT(

6045: interface_tax_line_id
6046: )
6047: WHEN (DEFAULT_RATE_CODE_NOT_EXISTS = 'Y') THEN
6048:
6049: INTO ZX_VALIDATION_ERRORS_GT(
6050: application_id,
6051: entity_code,
6052: event_class_code,
6053: trx_id,

Line 6287: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Rate Imported Tax Lines Validations based on tax_rate_id');

6283: END IF;
6284:
6285: IF ( g_level_statement >= g_current_runtime_level) THEN
6286: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6287: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Rate Imported Tax Lines Validations based on tax_rate_id');
6288: END IF;
6289:
6290: INSERT ALL
6291: WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN

Line 6292: INTO ZX_VALIDATION_ERRORS_GT(

6288: END IF;
6289:
6290: INSERT ALL
6291: WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN
6292: INTO ZX_VALIDATION_ERRORS_GT(
6293: application_id,
6294: entity_code,
6295: event_class_code,
6296: trx_id,

Line 6319: INTO ZX_VALIDATION_ERRORS_GT(

6315: interface_tax_entity_code,
6316: interface_tax_line_id
6317: )
6318: WHEN (TAX_RATE_NOT_EFFECTIVE = 'Y') THEN
6319: INTO ZX_VALIDATION_ERRORS_GT(
6320: application_id,
6321: entity_code,
6322: event_class_code,
6323: trx_id,

Line 6346: INTO ZX_VALIDATION_ERRORS_GT(

6342: interface_tax_entity_code,
6343: interface_tax_line_id
6344: )
6345: WHEN (TAX_RATE_NOT_ACTIVE = 'Y') THEN
6346: INTO ZX_VALIDATION_ERRORS_GT(
6347: application_id,
6348: entity_code,
6349: event_class_code,
6350: trx_id,

Line 6632: 'Before insertion into ZX_VALIDATION_ERRORS_GT - Validations for zx_trx_tax_link_gt link_gt');

6628: END IF; -- End of debug checking
6629:
6630: IF ( g_level_statement >= g_current_runtime_level) THEN
6631: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6632: 'Before insertion into ZX_VALIDATION_ERRORS_GT - Validations for zx_trx_tax_link_gt link_gt');
6633: END IF;
6634:
6635:
6636: INSERT ALL

Line 6638: INTO ZX_VALIDATION_ERRORS_GT(

6634:
6635:
6636: INSERT ALL
6637: WHEN (ZX_INVALID_TRX_LINE_ID = 'Y') THEN
6638: INTO ZX_VALIDATION_ERRORS_GT(
6639: application_id,
6640: entity_code,
6641: event_class_code,
6642: trx_id,

Line 6665: INTO ZX_VALIDATION_ERRORS_GT(

6661: interface_tax_entity_code,
6662: interface_tax_line_id
6663: )
6664: WHEN (ZX_INVALID_SUMMARY_TAX_LINE_ID = 'Y') THEN
6665: INTO ZX_VALIDATION_ERRORS_GT(
6666: application_id,
6667: entity_code,
6668: event_class_code,
6669: trx_id,

Line 6739: trx_id in (select trx_id from zx_validation_errors_gt);

6735:
6736: -- Bug Fix # 4184091
6737: -- As per the email communication from vidya, changed the flag value from Y to N
6738: update zx_trx_headers_gt set validation_check_flag = 'N' where
6739: trx_id in (select trx_id from zx_validation_errors_gt);
6740:
6741: IF ( SQL%ROWCOUNT > 0 ) THEN
6742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6743: IF ( g_level_statement >= g_current_runtime_level) THEN

Line 6894: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Validate_Other_Documents');

6890:
6891: IF (g_level_statement >= g_current_runtime_level ) THEN
6892: FND_LOG.STRING(g_level_statement,
6893: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.Validate_Other_Documents',
6894: 'Before insertion into ZX_VALIDATION_ERRORS_GT for Validate_Other_Documents');
6895: END IF;
6896:
6897: INSERT ALL
6898: WHEN (ZX_REF_DOC_MISSING = 'Y') THEN

Line 6900: INTO ZX_VALIDATION_ERRORS_GT(

6896:
6897: INSERT ALL
6898: WHEN (ZX_REF_DOC_MISSING = 'Y') THEN
6899:
6900: INTO ZX_VALIDATION_ERRORS_GT(
6901: application_id,
6902: entity_code,
6903: event_class_code,
6904: trx_id,

Line 6935: INTO ZX_VALIDATION_ERRORS_GT(

6931: interface_line_id
6932: )
6933: WHEN (ZX_REL_DOC_MISSING = 'Y') THEN
6934:
6935: INTO ZX_VALIDATION_ERRORS_GT(
6936: application_id,
6937: entity_code,
6938: event_class_code,
6939: trx_id,

Line 6962: INTO ZX_VALIDATION_ERRORS_GT(

6958: rel_doc_trx_id
6959: )
6960: WHEN (ZX_APP_FROM_DOC_MISSING = 'Y') THEN
6961:
6962: INTO ZX_VALIDATION_ERRORS_GT(
6963: application_id,
6964: entity_code,
6965: event_class_code,
6966: trx_id,

Line 7001: INTO ZX_VALIDATION_ERRORS_GT(

6997: not check whether the doc exists in eTax repository
6998:
6999: WHEN (ZX_APP_TO_DOC_MISSING = 'Y') THEN
7000:
7001: INTO ZX_VALIDATION_ERRORS_GT(
7002: application_id,
7003: entity_code,
7004: event_class_code,
7005: trx_id,

Line 7037: INTO ZX_VALIDATION_ERRORS_GT(

7033: )
7034: */
7035: WHEN (ZX_ADJ_DOC_MISSING = 'Y') THEN
7036:
7037: INTO ZX_VALIDATION_ERRORS_GT(
7038: application_id,
7039: entity_code,
7040: event_class_code,
7041: trx_id,

Line 7072: INTO ZX_VALIDATION_ERRORS_GT(

7068: interface_line_id
7069: )
7070: WHEN (ZX_SOURCE_DOC_MISSING = 'Y') THEN
7071:
7072: INTO ZX_VALIDATION_ERRORS_GT(
7073: application_id,
7074: entity_code,
7075: event_class_code,
7076: trx_id,