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 235: x_return_status:= FND_API.G_RET_STS_SUCCESS;

231: g_module_name||'.'||l_procedure_name||'.BEGIN',
232: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(+) ');
233: END IF;
234:
235: x_return_status:= FND_API.G_RET_STS_SUCCESS;
236:
237: -- use p_tax_regime_code,
238: -- p_tax,
239: -- p_tax_status_code,

Line 261: x_return_status:= FND_API.G_RET_STS_ERROR;

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

Line 318: x_return_status:= FND_API.G_RET_STS_ERROR;

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

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: END IF;
363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: IF get_tax_rate_csr%ISOPEN THEN
368: CLOSE get_tax_rate_csr;
369: END IF;
370: IF get_tax_rate_mig_csr%ISOPEN THEN

Line 502: x_return_status:= FND_API.G_RET_STS_SUCCESS;

498: g_module_name||'.'||l_procedure_name||'.BEGIN',
499: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(+) ');
500: END IF;
501:
502: x_return_status:= FND_API.G_RET_STS_SUCCESS;
503:
504: -- get default tax rate code
505: OPEN get_def_tax_rate_csr;
506:

Line 521: x_return_status:= FND_API.G_RET_STS_ERROR;

517: IF get_def_tax_rate_csr%FOUND
518: AND l_tax_rate_rec_tmp.tax_jurisdiction_code = l_tax_rate_rec.tax_jurisdiction_code
519: THEN
520: -- raise error for multiple rate retrieved for the same jurisdiction code
521: x_return_status:= FND_API.G_RET_STS_ERROR;
522:
523: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
524: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
525: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 576: x_return_status:= FND_API.G_RET_STS_ERROR;

572: IF get_def_tax_rate_mig_csr%FOUND
573: AND l_tax_rate_rec_tmp.tax_jurisdiction_code = l_tax_rate_rec.tax_jurisdiction_code
574: THEN
575: -- raise error for multiple rate retrieved for the same jurisdiction code
576: x_return_status:= FND_API.G_RET_STS_ERROR;
577:
578: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
579: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
580: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

620: END IF;
621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: IF get_def_tax_rate_csr%ISOPEN THEN
626: CLOSE get_def_tax_rate_csr;
627: END IF;
628: IF get_def_tax_rate_mig_csr%ISOPEN THEN

Line 754: x_return_status:= FND_API.G_RET_STS_SUCCESS;

750: g_module_name||'.'||l_procedure_name||'.BEGIN',
751: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(+) ');
752: END IF;
753:
754: x_return_status:= FND_API.G_RET_STS_SUCCESS;
755:
756: -- use p_tax_jurisdiction_code,
757: -- p_tax_regime_code,
758: -- p_tax,

Line 777: x_return_status:= FND_API.G_RET_STS_ERROR;

773: FETCH get_tax_rate_csr INTO l_tax_rate_rec_tmp;
774:
775: IF get_tax_rate_csr%FOUND THEN
776: -- raise error for multiple rate retrieved
777: x_return_status:= FND_API.G_RET_STS_ERROR;
778:
779: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
780: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
781: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);

Line 826: x_return_status:= FND_API.G_RET_STS_ERROR;

822: FETCH get_tax_rate_mig_csr INTO l_tax_rate_rec_tmp;
823:
824: IF get_tax_rate_mig_csr%FOUND THEN
825: -- raise error for multiple rate retrieved
826: x_return_status:= FND_API.G_RET_STS_ERROR;
827:
828: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
829: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
830: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);

Line 875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

871: END IF;
872:
873: EXCEPTION
874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: IF get_tax_rate_csr%ISOPEN THEN
877: CLOSE get_tax_rate_csr;
878: END IF;
879: IF get_tax_rate_mig_csr%ISOPEN THEN

Line 1004: x_return_status := FND_API.G_RET_STS_SUCCESS;

1000: FND_LOG.STRING(g_level_procedure,
1001: g_module_name||'.'||l_procedure_name||'.BEGIN',
1002: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(+) ');
1003: END IF;
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;
1005:
1006: -- get tax rate with NULL tax class first
1007: --
1008: OPEN get_tax_rate_csr_no_jur;

Line 1019: x_return_status:= FND_API.G_RET_STS_ERROR;

1015: FETCH get_tax_rate_csr_no_jur INTO l_tax_rate_rec_tmp;
1016:
1017: IF get_tax_rate_csr_no_jur%FOUND THEN
1018: -- raise error for multiple rate retrieved
1019: x_return_status:= FND_API.G_RET_STS_ERROR;
1020: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1021: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1022: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1023: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);

Line 1069: x_return_status:= FND_API.G_RET_STS_ERROR;

1065: FETCH get_tax_rate_csr_no_jur_mig INTO l_tax_rate_rec_tmp;
1066:
1067: IF get_tax_rate_csr_no_jur_mig%FOUND THEN
1068: -- raise error for multiple rate retrieved
1069: x_return_status:= FND_API.G_RET_STS_ERROR;
1070: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTIPLE_RATES_FOUND');
1071: FND_MESSAGE.SET_TOKEN('TAX_RATE_CODE',p_tax_rate_code);
1072: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1073: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);

Line 1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1114: END IF;
1115:
1116: EXCEPTION
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: IF get_tax_rate_csr_no_jur%ISOPEN THEN
1120: CLOSE get_tax_rate_csr_no_jur;
1121: END IF;
1122: IF get_tax_rate_csr_no_jur_mig%ISOPEN THEN

Line 1249: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1245: g_module_name||'.'||l_procedure_name||'.BEGIN',
1246: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(+) ');
1247: END IF;
1248:
1249: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1250:
1251: -- get default tax rate code with NULL tax class first
1252: --
1253: OPEN get_def_tax_rate_csr;

Line 1264: x_return_status:= FND_API.G_RET_STS_ERROR;

1260: FETCH get_def_tax_rate_csr INTO l_tax_rate_rec_tmp;
1261:
1262: IF get_def_tax_rate_csr%FOUND THEN
1263: -- raise error for multiple rate retrieved
1264: x_return_status:= FND_API.G_RET_STS_ERROR;
1265:
1266: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1267: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1268: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1315: x_return_status:= FND_API.G_RET_STS_ERROR;

1311: FETCH get_def_tax_rate_mig_csr INTO l_tax_rate_rec_tmp;
1312:
1313: IF get_def_tax_rate_mig_csr%FOUND THEN
1314: -- raise error for multiple rate retrieved
1315: x_return_status:= FND_API.G_RET_STS_ERROR;
1316:
1317: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1318: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1319: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1360: END IF;
1361:
1362: EXCEPTION
1363: WHEN OTHERS THEN
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1365: IF get_def_tax_rate_csr%ISOPEN THEN
1366: CLOSE get_def_tax_rate_csr;
1367: END IF;
1368: IF get_def_tax_rate_mig_csr%ISOPEN THEN

Line 1493: x_return_status := FND_API.G_RET_STS_SUCCESS;

1489: FND_LOG.STRING(g_level_procedure,
1490: g_module_name||'.'||l_procedure_name||'.BEGIN',
1491: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(+) ');
1492: END IF;
1493: x_return_status := FND_API.G_RET_STS_SUCCESS;
1494:
1495: -- Try to get tax rate with NULL tax class first
1496: --
1497: OPEN get_def_tax_rate_no_jur_csr;

Line 1507: x_return_status:= FND_API.G_RET_STS_ERROR;

1503: FETCH get_def_tax_rate_no_jur_csr INTO l_tax_rate_rec_tmp;
1504:
1505: IF get_def_tax_rate_no_jur_csr%FOUND THEN
1506: -- raise error for multiple rate found
1507: x_return_status:= FND_API.G_RET_STS_ERROR;
1508:
1509: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1510: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1511: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1563: x_return_status:= FND_API.G_RET_STS_ERROR;

1559: FETCH get_def_tax_rate_no_jur_mi_csr INTO l_tax_rate_rec_tmp;
1560:
1561: IF get_def_tax_rate_no_jur_mi_csr%FOUND THEN
1562: -- raise error for multiple rate found
1563: x_return_status:= FND_API.G_RET_STS_ERROR;
1564:
1565: FND_MESSAGE.SET_NAME ('ZX','ZX_MULTI_DEFAULT_RATES_FOUND');
1566: FND_MESSAGE.SET_TOKEN('RATE_REGIME_CODE', p_tax_regime_code);
1567: FND_MESSAGE.SET_TOKEN('TAX_CODE',p_tax);

Line 1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1608: END IF;
1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1613: IF get_def_tax_rate_no_jur_csr%ISOPEN THEN
1614: CLOSE get_def_tax_rate_no_jur_csr;
1615: END IF;
1616: IF get_def_tax_rate_no_jur_mi_csr%ISOPEN THEN

Line 1669: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1665: g_module_name||'.'||l_procedure_name||'.BEGIN',
1666: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(+) ');
1667: END IF;
1668:
1669: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1670:
1671: -- get location_id
1672: l_structure_name := 'TRX_LINE_DIST_TBL';
1673:

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

1680: l_tax_param_code := ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name(
1681: p_place_of_supply_type_code,
1682: x_return_status);
1683:
1684: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1685: THEN
1686: -- TCM procedure called in get_pos_parameter_name will set the error msg
1687: -- here we just need to return to the calling point which will populate
1688: -- the context information.

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

1707: p_tax_param_code => l_tax_param_code,
1708: x_tax_param_value => l_location_id,
1709: x_return_status => x_return_status );
1710:
1711: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1712: THEN
1713: IF (g_level_statement >= g_current_runtime_level ) THEN
1714: FND_LOG.STRING(g_level_statement,
1715: g_module_name||'.'||l_procedure_name,

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

1738: x_tax_jurisdiction_rec => l_tax_jurisdiction_rec,
1739: x_jurisdictions_found => l_jurisdictions_found,
1740: x_return_status => x_return_status);
1741:
1742: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1743: THEN
1744: IF (g_level_statement >= g_current_runtime_level ) THEN
1745: FND_LOG.STRING(g_level_statement,
1746: g_module_name||'.'||l_procedure_name,

Line 1784: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1780: x_return_status => x_return_status
1781: );
1782: END IF;
1783:
1784: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1785: IF (g_level_statement >= g_current_runtime_level ) THEN
1786: FND_LOG.STRING(g_level_statement,
1787: g_module_name||'.'||l_procedure_name,
1788: 'Incorrect return_status after calling ' ||

Line 1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1804: END IF;
1805:
1806: EXCEPTION
1807: WHEN OTHERS THEN
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1810: FND_LOG.STRING(g_level_unexpected,
1811: g_module_name||'.'||l_procedure_name,
1812: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 1856: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1852: g_module_name||'.'||l_procedure_name||'.BEGIN',
1853: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(+) ');
1854: END IF;
1855:
1856: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1857:
1858: IF (g_level_statement >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_statement,
1860: g_module_name||'.'||l_procedure_name,

Line 1878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1874: x_tax_rate_rec => x_tax_rate_rec,
1875: x_return_status => x_return_status
1876: );
1877:
1878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1879: IF (g_level_statement >= g_current_runtime_level ) THEN
1880: FND_LOG.STRING(g_level_statement,
1881: g_module_name||'.'||l_procedure_name,
1882: 'Incorrect return_status after calling ' ||

Line 1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1917: x_tax_rate_rec => x_tax_rate_rec,
1918: x_return_status => x_return_status
1919: );
1920:
1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1922: IF (g_level_statement >= g_current_runtime_level ) THEN
1923: FND_LOG.STRING(g_level_statement,
1924: g_module_name||'.'||l_procedure_name,
1925: 'Incorrect return_status after calling ' ||

Line 1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1959: p_tax_rate_code => p_tax_rate_code,
1960: x_tax_rate_rec => x_tax_rate_rec,
1961: x_return_status => x_return_status
1962: );
1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: IF (g_level_statement >= g_current_runtime_level ) THEN
1965: FND_LOG.STRING(g_level_statement,
1966: g_module_name||'.'||l_procedure_name,
1967: 'Incorrect return_status after calling ' ||

Line 1982: x_return_status:= FND_API.G_RET_STS_ERROR;

1978: END IF;
1979:
1980: -- raise error when no tax rate found finally.
1981: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
1982: x_return_status:= FND_API.G_RET_STS_ERROR;
1983: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_NOT_FOUND');
1984: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
1985: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1986: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);

Line 2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1999: END IF;
2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2005: FND_LOG.STRING(g_level_unexpected,
2006: g_module_name||'.'||l_procedure_name,
2007: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 2048: x_return_status:= FND_API.G_RET_STS_SUCCESS;

2044: g_module_name||'.'||l_procedure_name||'.BEGIN',
2045: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(+) ');
2046: END IF;
2047:
2048: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2049:
2050: IF (g_level_statement >= g_current_runtime_level ) THEN
2051: FND_LOG.STRING(g_level_statement,
2052: g_module_name||'.'||l_procedure_name,

Line 2070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2066: x_tax_rate_rec => x_tax_rate_rec,
2067: x_return_status => x_return_status
2068: );
2069:
2070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2071: IF (g_level_statement >= g_current_runtime_level ) THEN
2072: FND_LOG.STRING(g_level_statement,
2073: g_module_name||'.'||l_procedure_name,
2074: 'Incorrect return_status after calling ' ||

Line 2113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2109: x_tax_rate_rec => x_tax_rate_rec,
2110: x_return_status => x_return_status
2111: );
2112:
2113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2114: IF (g_level_statement >= g_current_runtime_level ) THEN
2115: FND_LOG.STRING(g_level_statement,
2116: g_module_name||'.'||l_procedure_name,
2117: 'Incorrect return_status after calling ' ||

Line 2152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2148: p_tax_status_code => p_tax_status_code,
2149: x_tax_rate_rec => x_tax_rate_rec,
2150: x_return_status => x_return_status
2151: );
2152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2153: IF (g_level_statement >= g_current_runtime_level ) THEN
2154: FND_LOG.STRING(g_level_statement,
2155: g_module_name||'.'||l_procedure_name,
2156: 'Incorrect return_status after calling ' ||

Line 2172: x_return_status:= FND_API.G_RET_STS_ERROR;

2168:
2169:
2170: -- raise error when no tax rate found finally.
2171: IF x_tax_rate_rec.tax_rate_id IS NULL THEN
2172: x_return_status:= FND_API.G_RET_STS_ERROR;
2173:
2174: FND_MESSAGE.SET_NAME('ZX','ZX_DEFAULT_RATE_NOT_FOUND');
2175: FND_MESSAGE.SET_TOKEN('TAX_STATUS',p_tax_status_code);
2176: FND_MESSAGE.SET_TOKEN('TAX',p_tax);

Line 2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2190: END IF;
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2195: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2196: FND_LOG.STRING(g_level_unexpected,
2197: g_module_name||'.'||l_procedure_name,
2198: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 2241: x_return_status:= FND_API.G_RET_STS_SUCCESS;

2237: g_module_name||'.'||l_procedure_name||'.BEGIN',
2238: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(+) ');
2239: END IF;
2240:
2241: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2242:
2243: IF (g_level_statement >= g_current_runtime_level ) THEN
2244: FND_LOG.STRING(g_level_statement,
2245: g_module_name||'.'||l_procedure_name,

Line 2288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2284: p_multiple_jurisdictions_flag => p_multiple_jurisdictions_flag,
2285: x_tax_rate_rec => x_tax_rate_rec,
2286: x_return_status => x_return_status
2287: );
2288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2289: IF (g_level_statement >= g_current_runtime_level ) THEN
2290: FND_LOG.STRING(g_level_statement,
2291: g_module_name||'.'||l_procedure_name,
2292: 'Incorrect return_status after calling ' ||

Line 2331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2327: x_tax_rate_rec => x_tax_rate_rec,
2328: x_return_status => x_return_status
2329: );
2330:
2331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2332: IF (g_level_statement >= g_current_runtime_level ) THEN
2333: FND_LOG.STRING(g_level_statement,
2334: g_module_name||'.'||l_procedure_name,
2335: 'Incorrect return_status after calling ' ||

Line 2371: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2367: x_tax_rate_rec => x_tax_rate_rec,
2368: x_return_status => x_return_status
2369: );
2370:
2371: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2372: IF (g_level_statement >= g_current_runtime_level ) THEN
2373: FND_LOG.STRING(g_level_statement,
2374: g_module_name||'.'||l_procedure_name,
2375: 'Incorrect return_status after calling ' ||

Line 2441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2437: END IF;
2438:
2439: EXCEPTION
2440: WHEN OTHERS THEN
2441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2442: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2443: FND_LOG.STRING(g_level_unexpected,
2444: g_module_name||'.'||l_procedure_name,
2445: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));