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_TRN_VALIDATION_PKG dependencies on ZX_TRN_VALIDATION_PKG

Line 1: package body ZX_TRN_VALIDATION_PKG AS

1: package body ZX_TRN_VALIDATION_PKG AS
2: /* $Header: zxctaxregnb.pls 120.46.12020000.4 2013/01/03 11:13:37 srajapar ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;

Line 12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'ZX.PLSQL.ZX_TRN_VALIDATION_PKG.';

8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'ZX.PLSQL.ZX_TRN_VALIDATION_PKG.';
13: G_INVALID_PTP_ID CONSTANT NUMBER(3) := -1;
14: g_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
15: g_trn VARCHAR2(20);
16: l_allow_regn_num_flag VARCHAR2(1);

Line 1378: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AT(l_trn,

1374: --
1375: IF (l_country_code = 'AT') THEN -- f3
1376: /* if the country name is Austria check the Tax Registration Number */
1377: --
1378: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AT(l_trn,
1379: l_trn_type,
1380: l_pass_unique_check,
1381: p_return_status,
1382: p_error_buffer);

Line 1387: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BE(l_trn,

1383: --
1384: ELSIF (l_country_code = 'BE') THEN
1385: /* if the country name is Belgium check the Tax Registration Number */
1386: --
1387: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BE(l_trn,
1388: l_trn_type,
1389: l_pass_unique_check,
1390: p_return_status,
1391: p_error_buffer);

Line 1396: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DK(l_trn,

1392: --
1393: ELSIF (l_country_code= 'DK') THEN
1394: /* if the country name is Denmark check the Tax Registration Number */
1395: --
1396: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DK(l_trn,
1397: l_trn_type,
1398: l_pass_unique_check,
1399: p_return_status,
1400: p_error_buffer);

Line 1405: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_EE(l_trn,

1401: --
1402: ELSIF (l_country_code = 'EE') THEN
1403: /* if the country name is Estonia check the Tax Registration Number */
1404: --
1405: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_EE(l_trn,
1406: l_trn_type,
1407: l_pass_unique_check,
1408: p_return_status,
1409: p_error_buffer);

Line 1414: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FI(l_trn,

1410: --
1411: ELSIF (l_country_code = 'FI') THEN
1412: /* if the country name is Finland check the Tax Registration Number */
1413: --
1414: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FI(l_trn,
1415: l_trn_type,
1416: l_pass_unique_check,
1417: p_return_status,
1418: p_error_buffer);

Line 1423: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FR(l_trn,

1419: --
1420: ELSIF (l_country_code = 'FR') THEN
1421: /* if the country name is France check the Tax Registration Number */
1422: --
1423: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_FR(l_trn,
1424: l_trn_type,
1425: l_pass_unique_check,
1426: p_return_status,
1427: p_error_buffer);

Line 1432: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DE(l_trn,

1428: --
1429: ELSIF (l_country_code = 'DE') THEN
1430: /* if the country name is Germany check the Tax Registration Number */
1431: --
1432: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_DE(l_trn,
1433: l_trn_type,
1434: l_pass_unique_check,
1435: p_return_status,
1436: p_error_buffer);

Line 1441: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GR(l_trn,

1437: --
1438: ELSIF (l_country_code = 'GR') THEN
1439: /* if the country name is GREECE check the Tax Registration Number */
1440: --
1441: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GR(l_trn,
1442: l_trn_type,
1443: l_pass_unique_check,
1444: p_return_status,
1445: p_error_buffer);

Line 1450: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IE(l_trn,

1446: --
1447: ELSIF (l_country_code = 'IE') THEN
1448: /* if the country name is IRELAND check the Tax Registration Number */
1449: --
1450: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IE(l_trn,
1451: l_trn_type,
1452: l_pass_unique_check,
1453: p_return_status,
1454: p_error_buffer);

Line 1459: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IT(l_trn,

1455: --
1456: ELSIF (l_country_code = 'IT') THEN
1457: /* if the country name is Italy check the Tax Registration Number */
1458: --
1459: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_IT(l_trn,
1460: l_trn_type,
1461: l_pass_unique_check,
1462: p_return_status,
1463: p_error_buffer);

Line 1468: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LU(l_trn,

1464: --
1465: ELSIF (l_country_code = 'LU') THEN
1466: /* if the country name is Luxembourg check the Tax Registration Number */
1467: --
1468: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LU(l_trn,
1469: l_trn_type,
1470: l_pass_unique_check,
1471: p_return_status,
1472: p_error_buffer);

Line 1477: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_NL(l_trn,

1473: --
1474: ELSIF (l_country_code = 'NL') THEN
1475: /* if the country name is Netherlands check the Tax Registration Number */
1476: --
1477: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_NL(l_trn,
1478: l_trn_type,
1479: l_pass_unique_check,
1480: p_return_status,
1481: p_error_buffer);

Line 1486: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PL(l_trn,

1482: --
1483: ELSIF (l_country_code = 'PL') THEN
1484: /* if the country name is Poland check the Tax Registration Number */
1485: --
1486: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PL(l_trn,
1487: l_trn_type,
1488: l_pass_unique_check,
1489: p_return_status,
1490: p_error_buffer);

Line 1495: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PT(l_trn,

1491: --
1492: ELSIF (l_country_code = 'PT') THEN
1493: /* if the country name is Portugal check the Tax Registration Number */
1494: --
1495: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_PT(l_trn,
1496: l_trn_type,
1497: l_pass_unique_check,
1498: p_return_status,
1499: p_error_buffer);

Line 1504: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SK(l_trn,

1500: --
1501: ELSIF (l_country_code = 'SK') THEN
1502: /* if the country name is Slovakia check the Tax Registration Number */
1503: --
1504: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SK(l_trn,
1505: l_trn_type,
1506: l_pass_unique_check,
1507: p_return_status,
1508: p_error_buffer);

Line 1513: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_ES(l_trn,

1509: --
1510: ELSIF (l_country_code = 'ES') THEN
1511: /* if the country name is Spain check the Tax Registration Number */
1512: --
1513: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_ES(l_trn,
1514: l_trn_type,
1515: l_pass_unique_check,
1516: p_return_status,
1517: p_error_buffer);

Line 1522: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SE(l_trn,

1518: --
1519: ELSIF (l_country_code = 'SE') THEN
1520: /* if the country name is Sweden check the Tax Registration Number */
1521: --
1522: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SE(l_trn,
1523: l_trn_type,
1524: l_pass_unique_check,
1525: p_return_status,
1526: p_error_buffer);

Line 1531: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CH(l_trn,

1527: --
1528: ELSIF (l_country_code = 'CH') THEN
1529: /* if the country name is Swizerland check the Tax Registration Number */
1530: --
1531: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CH(l_trn,
1532: l_trn_type,
1533: l_pass_unique_check,
1534: p_return_status,
1535: p_error_buffer);

Line 1540: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GB(l_trn,

1536: --
1537: ELSIF (l_country_code = 'GB') THEN
1538: /* if the country name is United Kingdom check the Tax Registration Number */
1539: --
1540: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_GB(l_trn,
1541: l_trn_type,
1542: l_pass_unique_check,
1543: p_return_status,
1544: p_error_buffer);

Line 1549: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_RU(l_trn,

1545: --
1546: ELSIF (l_country_code = 'RU') THEN
1547: /* if the country name is Russia check the Tax Registration Number */
1548: --
1549: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_RU(l_trn,
1550: l_trn_type,
1551: l_pass_unique_check,
1552: p_return_status,
1553: p_error_buffer);

Line 1558: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_HU(l_trn,

1554: --
1555: ELSIF (l_country_code = 'HU') THEN
1556: /* if the country name is Hungary check the Tax Registration Number */
1557: --
1558: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_HU(l_trn,
1559: l_trn_type,
1560: l_pass_unique_check,
1561: p_return_status,
1562: p_error_buffer);

Line 1567: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AR(l_trn,

1563: --
1564: ELSIF (l_country_code = 'AR') THEN
1565: /* if the country name is Argentina check the Tax Registration Number */
1566: --
1567: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_AR(l_trn,
1568: l_trn_type,
1569: p_return_status,
1570: p_error_buffer);
1571: --

Line 1575: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CL(l_trn,

1571: --
1572: ELSIF (l_country_code = 'CL') THEN
1573: /* if the country name is Chile check the Tax Registration Number */
1574: --
1575: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CL(l_trn,
1576: p_return_status,
1577: p_error_buffer);
1578: --
1579: ELSIF (l_country_code = 'CO') THEN

Line 1582: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CO(l_trn,

1578: --
1579: ELSIF (l_country_code = 'CO') THEN
1580: /* if the country name is Colombia check the Tax Registration Number */
1581: --
1582: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CO(l_trn,
1583: p_return_status,
1584: p_error_buffer);
1585: --
1586: ELSIF (l_country_code = 'TW') THEN

Line 1589: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_TW(l_trn,

1585: --
1586: ELSIF (l_country_code = 'TW') THEN
1587: /* if the country name is Taiwan check the Tax Registration Number */
1588: --
1589: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_TW(l_trn,
1590: p_return_status,
1591: p_error_buffer);
1592: --
1593: ELSIF (l_country_code = 'BR') THEN

Line 1596: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BR(l_trn,

1592: --
1593: ELSIF (l_country_code = 'BR') THEN
1594: /* if the country name is Brazil check the Tax Registration Number */
1595: --
1596: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_BR(l_trn,
1597: l_trn_type,
1598: p_return_status,
1599: p_error_buffer);
1600: --

Line 1604: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_MT(l_trn,

1600: --
1601: ELSIF (l_country_code = 'MT') THEN
1602: /* if the country name is Malta check the Tax Registration Number */
1603: --
1604: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_MT(l_trn,
1605: l_trn_type,
1606: l_pass_unique_check,
1607: p_return_status,
1608: p_error_buffer);

Line 1613: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CY(l_trn,

1609: --
1610: ELSIF (l_country_code = 'CY') THEN
1611: /* if the country name is Cyprus check the Tax Registration Number */
1612: --
1613: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_CY(l_trn,
1614: l_trn_type,
1615: l_pass_unique_check,
1616: p_return_status,
1617: p_error_buffer);

Line 1622: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LV(l_trn,

1618: --
1619: ELSIF (l_country_code = 'LV') THEN
1620: /* if the country name is Latvia check the Tax Registration Number */
1621: --
1622: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LV(l_trn,
1623: l_trn_type,
1624: l_pass_unique_check,
1625: p_return_status,
1626: p_error_buffer);

Line 1631: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LT(l_trn,

1627: --
1628: ELSIF (l_country_code = 'LT') THEN
1629: /* if the country name is Lithuania check the Tax Registration Number */
1630: --
1631: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_LT(l_trn,
1632: l_trn_type,
1633: l_pass_unique_check,
1634: p_return_status,
1635: p_error_buffer);

Line 1640: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SI(l_trn,

1636: --
1637: ELSIF (l_country_code = 'SI') THEN
1638: /* if the country name is Slovenia check the Tax Registration Number */
1639: --
1640: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN_SI(l_trn,
1641: l_trn_type,
1642: l_pass_unique_check,
1643: p_return_status,
1644: p_error_buffer);

Line 6658: END ZX_TRN_VALIDATION_PKG;

6654: END VALIDATE_TRN_CY;
6655:
6656: /* *********** End VALIDATE_TRN_CY ****************** */
6657:
6658: END ZX_TRN_VALIDATION_PKG;