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_TCM_TAX_RATE_PKG dependencies on ZX_TCM_TAX_RATE_PKG

Line 1: PACKAGE BODY ZX_TCM_TAX_RATE_PKG AS

1: PACKAGE BODY ZX_TCM_TAX_RATE_PKG AS
2: /* $Header: zxctaxratespkgb.pls 120.14.12010000.2 2008/10/30 02:03:55 tsen ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: g_module_name CONSTANT VARCHAR2(50) :='ZX.PLSQL.ZX_TCM_TAX_RATE_PKG';

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_module_name CONSTANT VARCHAR2(50) :='ZX.PLSQL.ZX_TCM_TAX_RATE_PKG';
9:
10: PROCEDURE get_tax_rate_by_jur_gt(
11: p_tax_class IN VARCHAR2,
12: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,

Line 230: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(+) ');

226:
227: IF (g_level_procedure >= g_current_runtime_level ) THEN
228: FND_LOG.STRING(g_level_procedure,
229: g_module_name||'.'||l_procedure_name||'.BEGIN',
230: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(+) ');
231: END IF;
232:
233: x_return_status:= FND_API.G_RET_STS_SUCCESS;
234:

Line 275: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');

271: g_module_name||'.'||l_procedure_name,
272: 'Too Many Tax Rate Rows Retrived. ');
273: FND_LOG.STRING(g_level_unexpected,
274: g_module_name||'.'||l_procedure_name||'.END',
275: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
276: END IF;
277:
278: ELSE
279: ***** Bug#5395227 ****/

Line 332: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');

328: g_module_name||'.'||l_procedure_name,
329: 'Too Many Tax Rate Rows Retrived. ');
330: FND_LOG.STRING(g_level_unexpected,
331: g_module_name||'.'||l_procedure_name||'.END',
332: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
333: END IF;
334:
335: ELSE
336: ***** Bug#5395227 ****/

Line 359: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');

355:
356: IF (g_level_procedure >= g_current_runtime_level ) THEN
357: FND_LOG.STRING(g_level_procedure,
358: g_module_name||'.'||l_procedure_name||'.END',
359: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
360: END IF;
361:
362: EXCEPTION
363: WHEN OTHERS THEN

Line 374: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');

370: g_module_name||'.'||l_procedure_name,
371: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
372: FND_LOG.STRING(g_level_unexpected,
373: g_module_name||'.'||l_procedure_name||'.END',
374: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
375: END IF;
376:
377: END get_tax_rate_by_jur_gt;
378:

Line 492: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(+) ');

488:
489: IF (g_level_procedure >= g_current_runtime_level ) THEN
490: FND_LOG.STRING(g_level_procedure,
491: g_module_name||'.'||l_procedure_name||'.BEGIN',
492: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(+) ');
493: END IF;
494:
495: x_return_status:= FND_API.G_RET_STS_SUCCESS;
496:

Line 531: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');

527: g_module_name||'.'||l_procedure_name,
528: 'Too Many Tax Rate Rows Retrived. ');
529: FND_LOG.STRING(g_level_unexpected,
530: g_module_name||'.'||l_procedure_name||'.END',
531: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
532: END IF;
533: ELSE
534: ***** Bug#5395227 ****/
535:

Line 586: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');

582: g_module_name||'.'||l_procedure_name,
583: 'Too Many Tax Rate Rows Retrived. ');
584: FND_LOG.STRING(g_level_unexpected,
585: g_module_name||'.'||l_procedure_name||'.END',
586: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
587: END IF;
588: ELSE
589: ***** Bug#5395227 ****/
590:

Line 612: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');

608:
609: IF (g_level_procedure >= g_current_runtime_level ) THEN
610: FND_LOG.STRING(g_level_procedure,
611: g_module_name||'.'||l_procedure_name||'.END',
612: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
613: END IF;
614:
615: EXCEPTION
616: WHEN OTHERS THEN

Line 627: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');

623: g_module_name||'.'||l_procedure_name,
624: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
625: FND_LOG.STRING(g_level_unexpected,
626: g_module_name||'.'||l_procedure_name||'.END',
627: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
628: END IF;
629:
630: END get_def_tax_rate_by_jur_gt;
631:

Line 741: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(+) ');

737:
738: IF (g_level_procedure >= g_current_runtime_level ) THEN
739: FND_LOG.STRING(g_level_procedure,
740: g_module_name||'.'||l_procedure_name||'.BEGIN',
741: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(+) ');
742: END IF;
743:
744: x_return_status:= FND_API.G_RET_STS_SUCCESS;
745:

Line 783: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');

779: g_module_name||'.'||l_procedure_name,
780: 'Too Many Tax Rate Rows Retrived. ');
781: FND_LOG.STRING(g_level_unexpected,
782: g_module_name||'.'||l_procedure_name||'.END',
783: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
784: END IF;
785:
786: ELSE
787: ***** Bug#5395227 ****/

Line 832: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');

828: g_module_name||'.'||l_procedure_name,
829: 'Too Many Tax Rate Rows Retrived. ');
830: FND_LOG.STRING(g_level_unexpected,
831: g_module_name||'.'||l_procedure_name||'.END',
832: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
833: END IF;
834:
835: ELSE
836: ***** Bug#5395227 ****/

Line 860: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');

856:
857: IF (g_level_procedure >= g_current_runtime_level ) THEN
858: FND_LOG.STRING(g_level_procedure,
859: g_module_name||'.'||l_procedure_name||'.END',
860: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
861: END IF;
862:
863: EXCEPTION
864: WHEN OTHERS THEN

Line 875: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');

871: g_module_name||'.'||l_procedure_name,
872: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
873: FND_LOG.STRING(g_level_unexpected,
874: g_module_name||'.'||l_procedure_name||'.END',
875: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
876: END IF;
877:
878: END get_tax_rate_by_jur_code;
879:

Line 989: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(+) ');

985:
986: IF (g_level_procedure >= g_current_runtime_level ) THEN
987: FND_LOG.STRING(g_level_procedure,
988: g_module_name||'.'||l_procedure_name||'.BEGIN',
989: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(+) ');
990: END IF;
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992:
993: -- get tax rate with NULL tax class first

Line 1021: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');

1017: g_module_name||'.'||l_procedure_name,
1018: 'Too Many Tax Rate Rows Retrived. ');
1019: FND_LOG.STRING(g_level_unexpected,
1020: g_module_name||'.'||l_procedure_name||'.END',
1021: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1022: END IF;
1023:
1024: RETURN;
1025: ELSE

Line 1071: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');

1067: g_module_name||'.'||l_procedure_name,
1068: 'Too Many Tax Rate Rows Retrived. ');
1069: FND_LOG.STRING(g_level_unexpected,
1070: g_module_name||'.'||l_procedure_name||'.END',
1071: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1072: END IF;
1073:
1074: RETURN;
1075: ELSE

Line 1100: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');

1096:
1097: IF (g_level_procedure >= g_current_runtime_level ) THEN
1098: FND_LOG.STRING(g_level_procedure,
1099: g_module_name||'.'||l_procedure_name||'.END',
1100: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1101: END IF;
1102:
1103: EXCEPTION
1104: WHEN OTHERS THEN

Line 1115: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');

1111: g_module_name||'.'||l_procedure_name,
1112: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1113: FND_LOG.STRING(g_level_unexpected,
1114: g_module_name||'.'||l_procedure_name||'.END',
1115: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1116: END IF;
1117: END get_tax_rate_no_jur_code;
1118:
1119: ------------------------------------------------------------------------------

Line 1230: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(+) ');

1226:
1227: IF (g_level_procedure >= g_current_runtime_level ) THEN
1228: FND_LOG.STRING(g_level_procedure,
1229: g_module_name||'.'||l_procedure_name||'.BEGIN',
1230: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(+) ');
1231: END IF;
1232:
1233: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1234:

Line 1265: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');

1261: g_module_name||'.'||l_procedure_name,
1262: 'Too Many Tax Rate Rows Retrived. ');
1263: FND_LOG.STRING(g_level_unexpected,
1264: g_module_name||'.'||l_procedure_name||'.END',
1265: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1266: END IF;
1267: ELSE
1268: ***** Bug#5395227 ****/
1269:

Line 1316: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');

1312: g_module_name||'.'||l_procedure_name,
1313: 'Too Many Tax Rate Rows Retrived. ');
1314: FND_LOG.STRING(g_level_unexpected,
1315: g_module_name||'.'||l_procedure_name||'.END',
1316: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1317: END IF;
1318: ELSE
1319: ***** Bug#5395227 ****/
1320:

Line 1343: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');

1339:
1340: IF (g_level_procedure >= g_current_runtime_level ) THEN
1341: FND_LOG.STRING(g_level_procedure,
1342: g_module_name||'.'||l_procedure_name||'.END',
1343: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1344: END IF;
1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN

Line 1358: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');

1354: g_module_name||'.'||l_procedure_name,
1355: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1356: FND_LOG.STRING(g_level_unexpected,
1357: g_module_name||'.'||l_procedure_name||'.END',
1358: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1359: END IF;
1360: END get_def_tax_rate_by_jur_code;
1361:
1362: ------------------------------------------------------------------------------

Line 1472: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(+) ');

1468:
1469: IF (g_level_procedure >= g_current_runtime_level ) THEN
1470: FND_LOG.STRING(g_level_procedure,
1471: g_module_name||'.'||l_procedure_name||'.BEGIN',
1472: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(+) ');
1473: END IF;
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;
1475:
1476: -- Try to get tax rate with NULL tax class first

Line 1504: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');

1500: g_module_name||'.'||l_procedure_name,
1501: 'Too Many Tax Rate Rows Retrived. ');
1502: FND_LOG.STRING(g_level_unexpected,
1503: g_module_name||'.'||l_procedure_name||'.END',
1504: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1505: END IF;
1506: RETURN;
1507: ELSE
1508: ***** Bug#5395227 ****/

Line 1560: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');

1556: g_module_name||'.'||l_procedure_name,
1557: 'Too Many Tax Rate Rows Retrived. ');
1558: FND_LOG.STRING(g_level_unexpected,
1559: g_module_name||'.'||l_procedure_name||'.END',
1560: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1561: END IF;
1562: RETURN;
1563: ELSE
1564: ***** Bug#5395227 ****/

Line 1588: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');

1584:
1585: IF (g_level_procedure >= g_current_runtime_level ) THEN
1586: FND_LOG.STRING(g_level_procedure,
1587: g_module_name||'.'||l_procedure_name||'.END',
1588: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1589: END IF;
1590:
1591: EXCEPTION
1592: WHEN OTHERS THEN

Line 1603: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');

1599: g_module_name||'.'||l_procedure_name,
1600: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1601: FND_LOG.STRING(g_level_unexpected,
1602: g_module_name||'.'||l_procedure_name||'.END',
1603: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1604: END IF;
1605: END get_def_tax_rate_no_jur_code;
1606:
1607: ------------------------------------------------------------------------------

Line 1644: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(+) ');

1640:
1641: IF (g_level_procedure >= g_current_runtime_level ) THEN
1642: FND_LOG.STRING(g_level_procedure,
1643: g_module_name||'.'||l_procedure_name||'.BEGIN',
1644: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(+) ');
1645: END IF;
1646:
1647: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1648:

Line 1677: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');

1673: g_module_name||'.'||l_procedure_name,
1674: 'RETURN_STATUS = ' || x_return_status);
1675: FND_LOG.STRING(g_level_statement,
1676: g_module_name||'.'||l_procedure_name||'.END',
1677: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1678: END IF;
1679: RETURN;
1680: END IF;
1681:

Line 1701: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');

1697: g_module_name||'.'||l_procedure_name,
1698: 'RETURN_STATUS = ' || x_return_status);
1699: FND_LOG.STRING(g_level_statement,
1700: g_module_name||'.'||l_procedure_name||'.END',
1701: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1702: END IF;
1703: RETURN;
1704: END IF;
1705:

Line 1732: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');

1728: g_module_name||'.'||l_procedure_name,
1729: 'RETURN_STATUS = ' || x_return_status);
1730: FND_LOG.STRING(g_level_statement,
1731: g_module_name||'.'||l_procedure_name||'.END',
1732: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1733: END IF;
1734: RETURN;
1735: END IF;
1736: END IF;

Line 1767: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');

1763: IF (g_level_statement >= g_current_runtime_level ) THEN
1764: FND_LOG.STRING(g_level_statement,
1765: g_module_name||'.'||l_procedure_name,
1766: 'Incorrect return_status after calling ' ||
1767: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
1768: FND_LOG.STRING(g_level_statement,
1769: g_module_name||'.'||l_procedure_name,
1770: 'RETURN_STATUS = ' || x_return_status);
1771: FND_LOG.STRING(g_level_statement,

Line 1773: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');

1769: g_module_name||'.'||l_procedure_name,
1770: 'RETURN_STATUS = ' || x_return_status);
1771: FND_LOG.STRING(g_level_statement,
1772: g_module_name||'.'||l_procedure_name||'.END',
1773: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1774: END IF;
1775: RETURN;
1776: END IF;
1777:

Line 1781: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');

1777:
1778: IF (g_level_procedure >= g_current_runtime_level ) THEN
1779: FND_LOG.STRING(g_level_procedure,
1780: g_module_name||'.'||l_procedure_name||'.END',
1781: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN OTHERS THEN

Line 1793: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');

1789: g_module_name||'.'||l_procedure_name,
1790: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1791: FND_LOG.STRING(g_level_unexpected,
1792: g_module_name||'.'||l_procedure_name||'.END',
1793: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1794: END IF;
1795:
1796: END get_tax_rate_internal;
1797:

Line 1831: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(+) ');

1827:
1828: IF (g_level_procedure >= g_current_runtime_level ) THEN
1829: FND_LOG.STRING(g_level_procedure,
1830: g_module_name||'.'||l_procedure_name||'.BEGIN',
1831: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(+) ');
1832: END IF;
1833:
1834: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1835:

Line 1861: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');

1857: IF (g_level_statement >= g_current_runtime_level ) THEN
1858: FND_LOG.STRING(g_level_statement,
1859: g_module_name||'.'||l_procedure_name,
1860: 'Incorrect return_status after calling ' ||
1861: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1862: FND_LOG.STRING(g_level_statement,
1863: g_module_name||'.'||l_procedure_name,
1864: 'RETURN_STATUS = ' || x_return_status);
1865: FND_LOG.STRING(g_level_statement,

Line 1867: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');

1863: g_module_name||'.'||l_procedure_name,
1864: 'RETURN_STATUS = ' || x_return_status);
1865: FND_LOG.STRING(g_level_statement,
1866: g_module_name||'.'||l_procedure_name||'.END',
1867: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1868: END IF;
1869: RETURN;
1870: END IF;
1871:

Line 1878: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');

1874: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
1875: IF (g_level_procedure >= g_current_runtime_level ) THEN
1876: FND_LOG.STRING(g_level_procedure,
1877: g_module_name||'.'||l_procedure_name||'.END',
1878: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1879: END IF;
1880: RETURN;
1881: END IF;
1882: END IF;

Line 1904: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');

1900: IF (g_level_statement >= g_current_runtime_level ) THEN
1901: FND_LOG.STRING(g_level_statement,
1902: g_module_name||'.'||l_procedure_name,
1903: 'Incorrect return_status after calling ' ||
1904: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1905: FND_LOG.STRING(g_level_statement,
1906: g_module_name||'.'||l_procedure_name,
1907: 'RETURN_STATUS = ' || x_return_status);
1908: FND_LOG.STRING(g_level_statement,

Line 1910: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');

1906: g_module_name||'.'||l_procedure_name,
1907: 'RETURN_STATUS = ' || x_return_status);
1908: FND_LOG.STRING(g_level_statement,
1909: g_module_name||'.'||l_procedure_name||'.END',
1910: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1911: END IF;
1912: RETURN;
1913: END IF;
1914:

Line 1921: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');

1917: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
1918: IF (g_level_procedure >= g_current_runtime_level ) THEN
1919: FND_LOG.STRING(g_level_procedure,
1920: g_module_name||'.'||l_procedure_name||'.END',
1921: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1922: END IF;
1923: RETURN;
1924: END IF;
1925: END IF;

Line 1946: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');

1942: IF (g_level_statement >= g_current_runtime_level ) THEN
1943: FND_LOG.STRING(g_level_statement,
1944: g_module_name||'.'||l_procedure_name,
1945: 'Incorrect return_status after calling ' ||
1946: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
1947: FND_LOG.STRING(g_level_statement,
1948: g_module_name||'.'||l_procedure_name,
1949: 'RETURN_STATUS = ' || x_return_status);
1950: FND_LOG.STRING(g_level_statement,

Line 1952: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');

1948: g_module_name||'.'||l_procedure_name,
1949: 'RETURN_STATUS = ' || x_return_status);
1950: FND_LOG.STRING(g_level_statement,
1951: g_module_name||'.'||l_procedure_name||'.END',
1952: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1953: END IF;
1954: RETURN;
1955: END IF;
1956: END IF;

Line 1976: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');

1972:
1973: IF (g_level_procedure >= g_current_runtime_level ) THEN
1974: FND_LOG.STRING(g_level_procedure,
1975: g_module_name||'.'||l_procedure_name||'.END',
1976: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1977: END IF;
1978:
1979: EXCEPTION
1980: WHEN OTHERS THEN

Line 1988: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');

1984: g_module_name||'.'||l_procedure_name,
1985: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1986: FND_LOG.STRING(g_level_unexpected,
1987: g_module_name||'.'||l_procedure_name||'.END',
1988: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1989: END IF;
1990: END get_tax_rate_pvt;
1991:
1992: ------------------------------------------------------------------------------

Line 2023: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(+) ');

2019:
2020: IF (g_level_procedure >= g_current_runtime_level ) THEN
2021: FND_LOG.STRING(g_level_procedure,
2022: g_module_name||'.'||l_procedure_name||'.BEGIN',
2023: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(+) ');
2024: END IF;
2025:
2026: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2027:

Line 2053: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');

2049: IF (g_level_statement >= g_current_runtime_level ) THEN
2050: FND_LOG.STRING(g_level_statement,
2051: g_module_name||'.'||l_procedure_name,
2052: 'Incorrect return_status after calling ' ||
2053: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');
2054: FND_LOG.STRING(g_level_statement,
2055: g_module_name||'.'||l_procedure_name,
2056: 'RETURN_STATUS = ' || x_return_status);
2057: FND_LOG.STRING(g_level_statement,

Line 2059: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');

2055: g_module_name||'.'||l_procedure_name,
2056: 'RETURN_STATUS = ' || x_return_status);
2057: FND_LOG.STRING(g_level_statement,
2058: g_module_name||'.'||l_procedure_name||'.END',
2059: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2060: END IF;
2061: RETURN;
2062: END IF;
2063:

Line 2069: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');

2065: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2066: IF (g_level_procedure >= g_current_runtime_level ) THEN
2067: FND_LOG.STRING(g_level_procedure,
2068: g_module_name||'.'||l_procedure_name||'.END',
2069: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2070: END IF;
2071: RETURN;
2072: END IF;
2073:

Line 2096: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');

2092: IF (g_level_statement >= g_current_runtime_level ) THEN
2093: FND_LOG.STRING(g_level_statement,
2094: g_module_name||'.'||l_procedure_name,
2095: 'Incorrect return_status after calling ' ||
2096: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
2097: FND_LOG.STRING(g_level_statement,
2098: g_module_name||'.'||l_procedure_name,
2099: 'RETURN_STATUS = ' || x_return_status);
2100: FND_LOG.STRING(g_level_statement,

Line 2102: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');

2098: g_module_name||'.'||l_procedure_name,
2099: 'RETURN_STATUS = ' || x_return_status);
2100: FND_LOG.STRING(g_level_statement,
2101: g_module_name||'.'||l_procedure_name||'.END',
2102: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2103: END IF;
2104: RETURN;
2105: END IF;
2106:

Line 2112: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');

2108: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2109: IF (g_level_procedure >= g_current_runtime_level ) THEN
2110: FND_LOG.STRING(g_level_procedure,
2111: g_module_name||'.'||l_procedure_name||'.END',
2112: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2113: END IF;
2114: RETURN;
2115: END IF;
2116:

Line 2135: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');

2131: IF (g_level_statement >= g_current_runtime_level ) THEN
2132: FND_LOG.STRING(g_level_statement,
2133: g_module_name||'.'||l_procedure_name,
2134: 'Incorrect return_status after calling ' ||
2135: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
2136: FND_LOG.STRING(g_level_statement,
2137: g_module_name||'.'||l_procedure_name,
2138: 'RETURN_STATUS = ' || x_return_status);
2139: FND_LOG.STRING(g_level_statement,

Line 2141: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');

2137: g_module_name||'.'||l_procedure_name,
2138: 'RETURN_STATUS = ' || x_return_status);
2139: FND_LOG.STRING(g_level_statement,
2140: g_module_name||'.'||l_procedure_name||'.END',
2141: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2142: END IF;
2143: RETURN;
2144: END IF;
2145: END IF;

Line 2167: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');

2163:
2164: IF (g_level_procedure >= g_current_runtime_level ) THEN
2165: FND_LOG.STRING(g_level_procedure,
2166: g_module_name||'.'||l_procedure_name||'.END',
2167: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2168: END IF;
2169:
2170: EXCEPTION
2171: WHEN OTHERS THEN

Line 2179: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');

2175: g_module_name||'.'||l_procedure_name,
2176: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2177: FND_LOG.STRING(g_level_unexpected,
2178: g_module_name||'.'||l_procedure_name||'.END',
2179: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2180: END IF;
2181:
2182: END get_def_tax_rate_pvt;
2183:

Line 2216: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(+) ');

2212:
2213: IF (g_level_procedure >= g_current_runtime_level ) THEN
2214: FND_LOG.STRING(g_level_procedure,
2215: g_module_name||'.'||l_procedure_name||'.BEGIN',
2216: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(+) ');
2217: END IF;
2218:
2219: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2220:

Line 2271: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');

2267: IF (g_level_statement >= g_current_runtime_level ) THEN
2268: FND_LOG.STRING(g_level_statement,
2269: g_module_name||'.'||l_procedure_name,
2270: 'Incorrect return_status after calling ' ||
2271: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');
2272: FND_LOG.STRING(g_level_statement,
2273: g_module_name||'.'||l_procedure_name,
2274: 'RETURN_STATUS = ' || x_return_status);
2275: FND_LOG.STRING(g_level_statement,

Line 2277: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');

2273: g_module_name||'.'||l_procedure_name,
2274: 'RETURN_STATUS = ' || x_return_status);
2275: FND_LOG.STRING(g_level_statement,
2276: g_module_name||'.'||l_procedure_name||'.END',
2277: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2278: END IF;
2279: RETURN;
2280: END IF;
2281: END IF;

Line 2314: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');

2310: IF (g_level_statement >= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_statement,
2312: g_module_name||'.'||l_procedure_name,
2313: 'Incorrect return_status after calling ' ||
2314: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');
2315: FND_LOG.STRING(g_level_statement,
2316: g_module_name||'.'||l_procedure_name,
2317: 'RETURN_STATUS = ' || x_return_status);
2318: FND_LOG.STRING(g_level_statement,

Line 2320: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');

2316: g_module_name||'.'||l_procedure_name,
2317: 'RETURN_STATUS = ' || x_return_status);
2318: FND_LOG.STRING(g_level_statement,
2319: g_module_name||'.'||l_procedure_name||'.END',
2320: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2321: END IF;
2322: -- lower level should assign the fnd msg stack
2323: RETURN;
2324: END IF;

Line 2354: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');

2350: IF (g_level_statement >= g_current_runtime_level ) THEN
2351: FND_LOG.STRING(g_level_statement,
2352: g_module_name||'.'||l_procedure_name,
2353: 'Incorrect return_status after calling ' ||
2354: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');
2355: FND_LOG.STRING(g_level_statement,
2356: g_module_name||'.'||l_procedure_name,
2357: 'RETURN_STATUS = ' || x_return_status);
2358: FND_LOG.STRING(g_level_statement,

Line 2360: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');

2356: g_module_name||'.'||l_procedure_name,
2357: 'RETURN_STATUS = ' || x_return_status);
2358: FND_LOG.STRING(g_level_statement,
2359: g_module_name||'.'||l_procedure_name||'.END',
2360: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2361: END IF;
2362: -- lower level should have set the fnd msg stack
2363: RETURN;
2364: END IF;

Line 2414: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');

2410:
2411: IF (g_level_procedure >= g_current_runtime_level ) THEN
2412: FND_LOG.STRING(g_level_procedure,
2413: g_module_name||'.'||l_procedure_name||'.END',
2414: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');
2415: END IF;
2416:
2417: EXCEPTION
2418: WHEN OTHERS THEN

Line 2426: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');

2422: g_module_name||'.'||l_procedure_name,
2423: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2424: FND_LOG.STRING(g_level_unexpected,
2425: g_module_name||'.'||l_procedure_name||'.END',
2426: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');
2427: END IF;
2428:
2429: END get_tax_rate;
2430:

Line 2431: END ZX_TCM_TAX_RATE_PKG;

2427: END IF;
2428:
2429: END get_tax_rate;
2430:
2431: END ZX_TCM_TAX_RATE_PKG;
2432: