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

Line 151: WHERE trx_id IN (SELECT DISTINCT trx_id FROM zx_validation_errors_gt);

147: -- Update the validation_check_flag to N for problematic trxs
148: -- so that these trxs should not be picked up for tax processing
149: UPDATE zx_trx_headers_gt
150: SET validation_check_flag = 'N'
151: WHERE trx_id IN (SELECT DISTINCT trx_id FROM zx_validation_errors_gt);
152:
153: IF ( SQL%ROWCOUNT > 0 ) THEN
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155: IF (g_level_statement >= g_current_runtime_level) THEN

Line 161: -- Printing Error Messages in Zx_Validation_Errors_Gt

157: 'Updated the validation_check_flag to N in Zx_Trx_Headers_GT for '||to_char(SQL%ROWCOUNT)||' trx(s).');
158: END IF;
159: END IF ;
160:
161: -- Printing Error Messages in Zx_Validation_Errors_Gt
162: SELECT Count(*)
163: INTO l_err_count
164: FROM zx_validation_errors_gt;
165:

Line 164: FROM zx_validation_errors_gt;

160:
161: -- Printing Error Messages in Zx_Validation_Errors_Gt
162: SELECT Count(*)
163: INTO l_err_count
164: FROM zx_validation_errors_gt;
165:
166: IF l_err_count > 0 THEN
167: IF (g_level_procedure >= g_current_runtime_level ) THEN
168: FND_LOG.STRING(g_level_procedure,

Line 172: FOR rec IN (SELECT trx_id, message_text FROM ZX_VALIDATION_ERRORS_GT) LOOP

168: FND_LOG.STRING(g_level_procedure,
169: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
170: 'Error Message Count : '||l_err_count);
171: END IF;
172: FOR rec IN (SELECT trx_id, message_text FROM ZX_VALIDATION_ERRORS_GT) LOOP
173: IF (g_level_procedure >= g_current_runtime_level ) THEN
174: FND_LOG.STRING(g_level_procedure,
175: 'JL.PL/SQL.JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Trx_ID : '||rec.trx_id||', Error : '||rec.message_text);

Line 230: INTO ZX_VALIDATION_ERRORS_GT(

226: FETCH c_delimiter_prod_cat INTO l_delimiter_prod_cat;
227: CLOSE c_delimiter_prod_cat;
228:
229: INSERT ALL
230: INTO ZX_VALIDATION_ERRORS_GT(
231: application_id,
232: entity_code,
233: event_class_code,
234: trx_id,

Line 279: INTO ZX_VALIDATION_ERRORS_GT(

275: 'Transaction Business Category Validation Errors: '|| To_Char(SQL%ROWCOUNT) );
276: END IF;
277:
278: INSERT ALL
279: INTO ZX_VALIDATION_ERRORS_GT(
280: application_id,
281: entity_code,
282: event_class_code,
283: trx_id,

Line 334: INTO ZX_VALIDATION_ERRORS_GT(

330: 'Product Fiscal Classification Validation Errors: '|| To_Char(SQL%ROWCOUNT) );
331: END IF;
332:
333: INSERT ALL
334: INTO ZX_VALIDATION_ERRORS_GT(
335: application_id,
336: entity_code,
337: event_class_code,
338: trx_id,

Line 1119: INTO ZX_VALIDATION_ERRORS_GT(

1115:
1116: INSERT ALL
1117: WHEN (ZX_EVNT_CLS_MPG_INVALID = 'Y') THEN
1118:
1119: INTO ZX_VALIDATION_ERRORS_GT(
1120: application_id,
1121: entity_code,
1122: event_class_code,
1123: trx_id,

Line 1146: INTO ZX_VALIDATION_ERRORS_GT(

1142: )
1143:
1144: WHEN (ZX_EXCHG_INFO_MISSING = 'Y') THEN
1145:
1146: INTO ZX_VALIDATION_ERRORS_GT(
1147: application_id,
1148: entity_code,
1149: event_class_code,
1150: trx_id,

Line 1174: INTO ZX_VALIDATION_ERRORS_GT(

1170:
1171:
1172: WHEN (ZX_LINE_CLASS_INVALID = 'Y') THEN
1173:
1174: INTO ZX_VALIDATION_ERRORS_GT(
1175: application_id,
1176: entity_code,
1177: event_class_code,
1178: trx_id,

Line 1201: INTO ZX_VALIDATION_ERRORS_GT(

1197: )
1198:
1199: WHEN (ZX_TRX_LINE_TYPE_INVALID = 'Y') THEN
1200:
1201: INTO ZX_VALIDATION_ERRORS_GT(
1202: application_id,
1203: entity_code,
1204: event_class_code,
1205: trx_id,

Line 1228: INTO ZX_VALIDATION_ERRORS_GT(

1224: )
1225:
1226: WHEN (ZX_LINE_AMT_INCL_TAX_INVALID = 'Y') THEN
1227:
1228: INTO ZX_VALIDATION_ERRORS_GT(
1229: application_id,
1230: entity_code,
1231: event_class_code,
1232: trx_id,

Line 1256: INTO ZX_VALIDATION_ERRORS_GT(

1252:
1253: /*
1254: WHEN (SHIP_TO_PARTY_NOT_EXISTS = 'Y') THEN
1255:
1256: INTO ZX_VALIDATION_ERRORS_GT(
1257: application_id,
1258: entity_code,
1259: event_class_code,
1260: trx_id,

Line 1282: INTO ZX_VALIDATION_ERRORS_GT(

1278:
1279:
1280: WHEN (BILL_TO_PARTY_NOT_EXISTS = 'Y') THEN
1281:
1282: INTO ZX_VALIDATION_ERRORS_GT(
1283: application_id,
1284: entity_code,
1285: event_class_code,
1286: trx_id,

Line 1308: INTO ZX_VALIDATION_ERRORS_GT(

1304:
1305:
1306: WHEN (SHIPTO_PARTY_SITE_NOT_EXISTS = 'Y') THEN
1307:
1308: INTO ZX_VALIDATION_ERRORS_GT(
1309: application_id,
1310: entity_code,
1311: event_class_code,
1312: trx_id,

Line 1333: INTO ZX_VALIDATION_ERRORS_GT(

1329: )
1330:
1331: WHEN (SHIPFROM_PARTY_SITE_NOT_EXISTS = 'Y') THEN
1332:
1333: INTO ZX_VALIDATION_ERRORS_GT(
1334: application_id,
1335: entity_code,
1336: event_class_code,
1337: trx_id,

Line 1358: INTO ZX_VALIDATION_ERRORS_GT(

1354: )
1355:
1356: WHEN (BILLTO_PARTY_SITE_NOT_EXISTS = 'Y') THEN
1357:
1358: INTO ZX_VALIDATION_ERRORS_GT(
1359: application_id,
1360: entity_code,
1361: event_class_code,
1362: trx_id,

Line 1384: INTO ZX_VALIDATION_ERRORS_GT(

1380:
1381: */
1382:
1383: WHEN (USER_DEF_FC_NA_FOR_LTE = 'Y') THEN
1384: INTO ZX_VALIDATION_ERRORS_GT(
1385: application_id,
1386: entity_code,
1387: event_class_code,
1388: trx_id,

Line 1413: INTO ZX_VALIDATION_ERRORS_GT(

1409: /*
1410: -- Commented the validation as Product Category
1411: -- is a required parameter for Memo Lines
1412: WHEN (PRODUCT_CATEGORY_NA_FOR_LTE = 'Y') THEN
1413: INTO ZX_VALIDATION_ERRORS_GT(
1414: application_id,
1415: entity_code,
1416: event_class_code,
1417: trx_id,

Line 1440: INTO ZX_VALIDATION_ERRORS_GT(

1436: )
1437: */
1438:
1439: WHEN (DOCUMENT_FC_NA_FOR_LTE = 'Y') THEN
1440: INTO ZX_VALIDATION_ERRORS_GT(
1441: application_id,
1442: entity_code,
1443: event_class_code,
1444: trx_id,

Line 1466: INTO ZX_VALIDATION_ERRORS_GT(

1462: interface_line_id
1463: )
1464:
1465: WHEN (INTENDED_USE_NA_FOR_LTE = 'Y') THEN
1466: INTO ZX_VALIDATION_ERRORS_GT(
1467: application_id,
1468: entity_code,
1469: event_class_code,
1470: trx_id,

Line 1492: INTO ZX_VALIDATION_ERRORS_GT(

1488: interface_line_id
1489: )
1490:
1491: WHEN (PRODUCT_TYPE_NA_FOR_LTE = 'Y') THEN
1492: INTO ZX_VALIDATION_ERRORS_GT(
1493: application_id,
1494: entity_code,
1495: event_class_code,
1496: trx_id,

Line 1518: INTO ZX_VALIDATION_ERRORS_GT(

1514: interface_line_id
1515: )
1516:
1517: WHEN (TAX_RATE_CODE_NOT_EXISTS = 'Y') THEN
1518: INTO ZX_VALIDATION_ERRORS_GT(
1519: application_id,
1520: entity_code,
1521: event_class_code,
1522: trx_id,

Line 1545: INTO ZX_VALIDATION_ERRORS_GT(

1541: interface_line_id
1542: )
1543:
1544: WHEN (TAX_RATE_CODE_NOT_EXISTS = 'N' AND TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN
1545: INTO ZX_VALIDATION_ERRORS_GT(
1546: application_id,
1547: entity_code,
1548: event_class_code,
1549: trx_id,

Line 1572: INTO ZX_VALIDATION_ERRORS_GT(

1568: interface_line_id
1569: )
1570:
1571: WHEN (TAX_RATE_CODE_NOT_EXISTS = 'N' AND TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN
1572: INTO ZX_VALIDATION_ERRORS_GT(
1573: application_id,
1574: entity_code,
1575: event_class_code,
1576: trx_id,

Line 1815: INTO ZX_VALIDATION_ERRORS_GT(

1811: END IF;
1812:
1813: INSERT ALL
1814: WHEN (REGIME_NOT_EXISTS = 'Y') THEN
1815: INTO ZX_VALIDATION_ERRORS_GT(
1816: application_id,
1817: entity_code,
1818: event_class_code,
1819: trx_id,

Line 1841: INTO ZX_VALIDATION_ERRORS_GT(

1837: interface_tax_line_id
1838: )
1839:
1840: WHEN (REGIME_NOT_EFF_IN_SUBSCR = 'Y') THEN
1841: INTO ZX_VALIDATION_ERRORS_GT(
1842: application_id,
1843: entity_code,
1844: event_class_code,
1845: trx_id,

Line 1866: INTO ZX_VALIDATION_ERRORS_GT(

1862: trx_level_type,
1863: interface_tax_line_id
1864: )
1865: WHEN (REGIME_NOT_EFFECTIVE = 'Y') THEN
1866: INTO ZX_VALIDATION_ERRORS_GT(
1867: application_id,
1868: entity_code,
1869: event_class_code,
1870: trx_id,

Line 1892: INTO ZX_VALIDATION_ERRORS_GT(

1888: interface_tax_line_id
1889: )
1890:
1891: WHEN (TAX_NOT_EXISTS = 'Y') THEN
1892: INTO ZX_VALIDATION_ERRORS_GT(
1893: application_id,
1894: entity_code,
1895: event_class_code,
1896: trx_id,

Line 1918: INTO ZX_VALIDATION_ERRORS_GT(

1914: interface_tax_line_id
1915: )
1916:
1917: WHEN (TAX_NOT_LIVE = 'Y') THEN
1918: INTO ZX_VALIDATION_ERRORS_GT(
1919: application_id,
1920: entity_code,
1921: event_class_code,
1922: trx_id,

Line 1944: INTO ZX_VALIDATION_ERRORS_GT(

1940: interface_tax_line_id
1941: )
1942:
1943: WHEN (TAX_NOT_EFFECTIVE = 'Y') THEN
1944: INTO ZX_VALIDATION_ERRORS_GT(
1945: application_id,
1946: entity_code,
1947: event_class_code,
1948: trx_id,

Line 1970: INTO ZX_VALIDATION_ERRORS_GT(

1966: interface_tax_line_id
1967: )
1968:
1969: WHEN (TAX_STATUS_NOT_EXISTS = 'Y') THEN
1970: INTO ZX_VALIDATION_ERRORS_GT(
1971: application_id,
1972: entity_code,
1973: event_class_code,
1974: trx_id,

Line 1996: INTO ZX_VALIDATION_ERRORS_GT(

1992: interface_tax_line_id
1993: )
1994:
1995: WHEN (TAX_STATUS_NOT_EFFECTIVE = 'Y') THEN
1996: INTO ZX_VALIDATION_ERRORS_GT(
1997: application_id,
1998: entity_code,
1999: event_class_code,
2000: trx_id,

Line 2022: INTO ZX_VALIDATION_ERRORS_GT(

2018: interface_tax_line_id
2019: )
2020:
2021: WHEN (TAX_JUR_CODE_NA_FOR_LTE = 'Y') THEN
2022: INTO ZX_VALIDATION_ERRORS_GT(
2023: application_id,
2024: entity_code,
2025: event_class_code,
2026: trx_id,

Line 2255: INTO ZX_VALIDATION_ERRORS_GT(

2251: END IF;
2252:
2253: INSERT ALL
2254: WHEN (TAX_RATE_CODE_NOT_EXISTS = 'Y') THEN
2255: INTO ZX_VALIDATION_ERRORS_GT(
2256: application_id,
2257: entity_code,
2258: event_class_code,
2259: trx_id,

Line 2282: INTO ZX_VALIDATION_ERRORS_GT(

2278: interface_tax_line_id
2279: )
2280:
2281: WHEN (TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN
2282: INTO ZX_VALIDATION_ERRORS_GT(
2283: application_id,
2284: entity_code,
2285: event_class_code,
2286: trx_id,

Line 2309: INTO ZX_VALIDATION_ERRORS_GT(

2305: interface_tax_line_id
2306: )
2307:
2308: WHEN (TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN
2309: INTO ZX_VALIDATION_ERRORS_GT(
2310: application_id,
2311: entity_code,
2312: event_class_code,
2313: trx_id,

Line 2336: INTO ZX_VALIDATION_ERRORS_GT(

2332: interface_tax_line_id
2333: )
2334:
2335: WHEN (TAX_RATE_PERCENTAGE_INVALID = 'Y') THEN
2336: INTO ZX_VALIDATION_ERRORS_GT(
2337: application_id,
2338: entity_code,
2339: event_class_code,
2340: trx_id,

Line 2502: INTO zx_validation_errors_gt(

2498: END IF;
2499:
2500: INSERT ALL
2501: WHEN (SAMESUMTX_MULTIALLOC_TO_SAMELN = 'Y') THEN
2502: INTO zx_validation_errors_gt(
2503: application_id,
2504: entity_code,
2505: event_class_code,
2506: trx_id,

Line 2530: INTO zx_validation_errors_gt(

2526:
2527: /* bug 3698554 */
2528:
2529: WHEN (TAX_INCL_FLAG_MISMATCH = 'Y' ) THEN
2530: INTO zx_validation_errors_gt(
2531: application_id,
2532: entity_code,
2533: event_class_code,
2534: trx_id,

Line 2556: INTO zx_validation_errors_gt(

2552: interface_tax_line_id
2553: )
2554:
2555: WHEN (IMP_TAX_MISSING_IN_ADJUSTED_TO = 'Y') THEN
2556: INTO zx_validation_errors_gt(
2557: application_id,
2558: entity_code,
2559: event_class_code,
2560: trx_id,