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 FND_API

Line 233: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
235: -- use p_tax_regime_code,
236: -- p_tax,
237: -- p_tax_status_code,

Line 259: x_return_status:= FND_API.G_RET_STS_ERROR;

255: IF get_tax_rate_csr%FOUND
256: AND l_tax_rate_rec_tmp.tax_jurisdiction_code = l_tax_rate_rec.tax_jurisdiction_code
257: THEN
258: -- raise error for multiple rate retrieved for the same jurisdiction code
259: x_return_status:= FND_API.G_RET_STS_ERROR;
260:
261: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
262: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
263: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);

Line 316: x_return_status:= FND_API.G_RET_STS_ERROR;

312: IF get_tax_rate_mig_csr%FOUND
313: AND l_tax_rate_rec_tmp.tax_jurisdiction_code = l_tax_rate_rec.tax_jurisdiction_code
314: THEN
315: -- raise error for multiple rate retrieved for the same jurisdiction code
316: x_return_status:= FND_API.G_RET_STS_ERROR;
317:
318: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
319: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
320: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: END IF;
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF get_tax_rate_csr%ISOPEN THEN
366: CLOSE get_tax_rate_csr;
367: END IF;
368: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 495: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
497: -- get default tax rate code
498: OPEN get_def_tax_rate_csr;
499:

Line 514: x_return_status:= FND_API.G_RET_STS_ERROR;

510: IF get_def_tax_rate_csr%FOUND
511: AND l_tax_rate_rec_tmp.tax_jurisdiction_code = l_tax_rate_rec.tax_jurisdiction_code
512: THEN
513: -- raise error for multiple rate retrieved for the same jurisdiction code
514: x_return_status:= FND_API.G_RET_STS_ERROR;
515:
516: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
517: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
518: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 569: x_return_status:= FND_API.G_RET_STS_ERROR;

565: IF get_def_tax_rate_mig_csr%FOUND
566: AND l_tax_rate_rec_tmp.tax_jurisdiction_code = l_tax_rate_rec.tax_jurisdiction_code
567: THEN
568: -- raise error for multiple rate retrieved for the same jurisdiction code
569: x_return_status:= FND_API.G_RET_STS_ERROR;
570:
571: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
572: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
573: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

613: END IF;
614:
615: EXCEPTION
616: WHEN OTHERS THEN
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
618: IF get_def_tax_rate_csr%ISOPEN THEN
619: CLOSE get_def_tax_rate_csr;
620: END IF;
621: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 744: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
746: -- use p_tax_jurisdiction_code,
747: -- p_tax_regime_code,
748: -- p_tax,

Line 767: x_return_status:= FND_API.G_RET_STS_ERROR;

763: FETCH get_tax_rate_csr INTO l_tax_rate_rec_tmp;
764:
765: IF get_tax_rate_csr%FOUND THEN
766: -- raise error for multiple rate retrieved
767: x_return_status:= FND_API.G_RET_STS_ERROR;
768:
769: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
770: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
771: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);

Line 816: x_return_status:= FND_API.G_RET_STS_ERROR;

812: FETCH get_tax_rate_mig_csr INTO l_tax_rate_rec_tmp;
813:
814: IF get_tax_rate_mig_csr%FOUND THEN
815: -- raise error for multiple rate retrieved
816: x_return_status:= FND_API.G_RET_STS_ERROR;
817:
818: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
819: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
820: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

861: END IF;
862:
863: EXCEPTION
864: WHEN OTHERS THEN
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: IF get_tax_rate_csr%ISOPEN THEN
867: CLOSE get_tax_rate_csr;
868: END IF;
869: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 991: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
994: --
995: OPEN get_tax_rate_csr_no_jur;

Line 1006: x_return_status:= FND_API.G_RET_STS_ERROR;

1002: FETCH get_tax_rate_csr_no_jur INTO l_tax_rate_rec_tmp;
1003:
1004: IF get_tax_rate_csr_no_jur%FOUND THEN
1005: -- raise error for multiple rate retrieved
1006: x_return_status:= FND_API.G_RET_STS_ERROR;
1007: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1008: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1009: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1010: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);

Line 1056: x_return_status:= FND_API.G_RET_STS_ERROR;

1052: FETCH get_tax_rate_csr_no_jur_mig INTO l_tax_rate_rec_tmp;
1053:
1054: IF get_tax_rate_csr_no_jur_mig%FOUND THEN
1055: -- raise error for multiple rate retrieved
1056: x_return_status:= FND_API.G_RET_STS_ERROR;
1057: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1058: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1059: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1060: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);

Line 1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1101: END IF;
1102:
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF get_tax_rate_csr_no_jur%ISOPEN THEN
1107: CLOSE get_tax_rate_csr_no_jur;
1108: END IF;
1109: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1233: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
1235: -- get default tax rate code with NULL tax class first
1236: --
1237: OPEN get_def_tax_rate_csr;

Line 1248: x_return_status:= FND_API.G_RET_STS_ERROR;

1244: FETCH get_def_tax_rate_csr INTO l_tax_rate_rec_tmp;
1245:
1246: IF get_def_tax_rate_csr%FOUND THEN
1247: -- raise error for multiple rate retrieved
1248: x_return_status:= FND_API.G_RET_STS_ERROR;
1249:
1250: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1251: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1252: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1299: x_return_status:= FND_API.G_RET_STS_ERROR;

1295: FETCH get_def_tax_rate_mig_csr INTO l_tax_rate_rec_tmp;
1296:
1297: IF get_def_tax_rate_mig_csr%FOUND THEN
1298: -- raise error for multiple rate retrieved
1299: x_return_status:= FND_API.G_RET_STS_ERROR;
1300:
1301: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1302: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1303: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1344: END IF;
1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF get_def_tax_rate_csr%ISOPEN THEN
1350: CLOSE get_def_tax_rate_csr;
1351: END IF;
1352: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1474: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1477: --
1478: OPEN get_def_tax_rate_no_jur_csr;

Line 1488: x_return_status:= FND_API.G_RET_STS_ERROR;

1484: FETCH get_def_tax_rate_no_jur_csr INTO l_tax_rate_rec_tmp;
1485:
1486: IF get_def_tax_rate_no_jur_csr%FOUND THEN
1487: -- raise error for multiple rate found
1488: x_return_status:= FND_API.G_RET_STS_ERROR;
1489:
1490: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1491: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1492: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1544: x_return_status:= FND_API.G_RET_STS_ERROR;

1540: FETCH get_def_tax_rate_no_jur_mi_csr INTO l_tax_rate_rec_tmp;
1541:
1542: IF get_def_tax_rate_no_jur_mi_csr%FOUND THEN
1543: -- raise error for multiple rate found
1544: x_return_status:= FND_API.G_RET_STS_ERROR;
1545:
1546: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1547: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1548: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1589: END IF;
1590:
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1594: IF get_def_tax_rate_no_jur_csr%ISOPEN THEN
1595: CLOSE get_def_tax_rate_no_jur_csr;
1596: END IF;
1597: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1647: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
1649: -- get location_id
1650: l_structure_name := 'TRX_LINE_DIST_TBL';
1651:

Line 1662: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

1658: l_tax_param_code := ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name(
1659: p_place_of_supply_type_code,
1660: x_return_status);
1661:
1662: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1663: THEN
1664: -- TCM procedure called in get_pos_parameter_name will set the error msg
1665: -- here we just need to return to the calling point which will populate
1666: -- the context information.

Line 1689: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

1685: p_tax_param_code => l_tax_param_code,
1686: x_tax_param_value => l_location_id,
1687: x_return_status => x_return_status );
1688:
1689: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1690: THEN
1691: IF (g_level_statement >= g_current_runtime_level ) THEN
1692: FND_LOG.STRING(g_level_statement,
1693: g_module_name||'.'||l_procedure_name,

Line 1720: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS

1716: x_tax_jurisdiction_rec => l_tax_jurisdiction_rec,
1717: x_jurisdictions_found => l_jurisdictions_found,
1718: x_return_status => x_return_status);
1719:
1720: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1721: THEN
1722: IF (g_level_statement >= g_current_runtime_level ) THEN
1723: FND_LOG.STRING(g_level_statement,
1724: g_module_name||'.'||l_procedure_name,

Line 1762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1758: x_return_status => x_return_status
1759: );
1760: END IF;
1761:
1762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN OTHERS THEN
1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1787: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1788: FND_LOG.STRING(g_level_unexpected,
1789: g_module_name||'.'||l_procedure_name,
1790: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 1834: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
1836: IF (g_level_statement >= g_current_runtime_level ) THEN
1837: FND_LOG.STRING(g_level_statement,
1838: g_module_name||'.'||l_procedure_name,

Line 1856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1852: x_tax_rate_rec => x_tax_rate_rec,
1853: x_return_status => x_return_status
1854: );
1855:
1856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 1899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1895: x_tax_rate_rec => x_tax_rate_rec,
1896: x_return_status => x_return_status
1897: );
1898:
1899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 1941: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1937: p_tax_rate_code => p_tax_rate_code,
1938: x_tax_rate_rec => x_tax_rate_rec,
1939: x_return_status => x_return_status
1940: );
1941: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 1960: x_return_status:= FND_API.G_RET_STS_ERROR;

1956: END IF;
1957:
1958: -- raise error when no tax rate found finally.
1959: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1960: x_return_status:= FND_API.G_RET_STS_ERROR;
1961: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1962: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1963: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1964: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);

Line 1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1977: END IF;
1978:
1979: EXCEPTION
1980: WHEN OTHERS THEN
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1983: FND_LOG.STRING(g_level_unexpected,
1984: g_module_name||'.'||l_procedure_name,
1985: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 2026: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
2028: IF (g_level_statement >= g_current_runtime_level ) THEN
2029: FND_LOG.STRING(g_level_statement,
2030: g_module_name||'.'||l_procedure_name,

Line 2048: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2044: x_tax_rate_rec => x_tax_rate_rec,
2045: x_return_status => x_return_status
2046: );
2047:
2048: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 2091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2087: x_tax_rate_rec => x_tax_rate_rec,
2088: x_return_status => x_return_status
2089: );
2090:
2091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 2130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2126: p_tax_status_code => p_tax_status_code,
2127: x_tax_rate_rec => x_tax_rate_rec,
2128: x_return_status => x_return_status
2129: );
2130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 2150: x_return_status:= FND_API.G_RET_STS_ERROR;

2146:
2147:
2148: -- raise error when no tax rate found finally.
2149: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
2150: x_return_status:= FND_API.G_RET_STS_ERROR;
2151:
2152: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2153: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2154: FND_MESSAGE.SET_TOKEN('TAX',p_tax);

Line 2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2168: END IF;
2169:
2170: EXCEPTION
2171: WHEN OTHERS THEN
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2173: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_unexpected,
2175: g_module_name||'.'||l_procedure_name,
2176: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 2219: x_return_status:= FND_API.G_RET_STS_SUCCESS;

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:
2221: IF (g_level_statement >= g_current_runtime_level ) THEN
2222: FND_LOG.STRING(g_level_statement,
2223: g_module_name||'.'||l_procedure_name,

Line 2266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2262: p_multiple_jurisdictions_flag => p_multiple_jurisdictions_flag,
2263: x_tax_rate_rec => x_tax_rate_rec,
2264: x_return_status => x_return_status
2265: );
2266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 2309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2305: x_tax_rate_rec => x_tax_rate_rec,
2306: x_return_status => x_return_status
2307: );
2308:
2309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 2349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2345: x_tax_rate_rec => x_tax_rate_rec,
2346: x_return_status => x_return_status
2347: );
2348:
2349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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 ' ||

Line 2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2415: END IF;
2416:
2417: EXCEPTION
2418: WHEN OTHERS THEN
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2420: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2421: FND_LOG.STRING(g_level_unexpected,
2422: g_module_name||'.'||l_procedure_name,
2423: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));