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.OKS_TAX_UTIL_PVT dependencies on FND_API

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

400:
401: EXCEPTION
402:
403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
406: --first log the sqlerrm
407: l_error_text := substr (SQLERRM, 1, 512);
408: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

Line 578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

574:
575: EXCEPTION
576:
577: WHEN OTHERS THEN
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
580: --first log the sqlerrm
581: l_error_text := substr (SQLERRM, 1, 512);
582: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

Line 879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

875:
876: EXCEPTION
877:
878: WHEN OTHERS THEN
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
880: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
881: --first log the sqlerrm
882: l_error_text := substr (SQLERRM, 1, 512);
883: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

Line 1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1013:
1014: EXCEPTION
1015:
1016: WHEN OTHERS THEN
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1019: --first log the sqlerrm
1020: l_error_text := substr (SQLERRM, 1, 512);
1021: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

Line 1376: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1372: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1373: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1374: END IF;
1375:
1376: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: RAISE FND_API.g_exc_unexpected_error;
1378: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1379: RAISE FND_API.g_exc_error;
1380: END IF;

Line 1377: RAISE FND_API.g_exc_unexpected_error;

1373: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1374: END IF;
1375:
1376: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: RAISE FND_API.g_exc_unexpected_error;
1378: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1379: RAISE FND_API.g_exc_error;
1380: END IF;
1381:

Line 1378: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1374: END IF;
1375:
1376: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: RAISE FND_API.g_exc_unexpected_error;
1378: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1379: RAISE FND_API.g_exc_error;
1380: END IF;
1381:
1382: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 1379: RAISE FND_API.g_exc_error;

1375:
1376: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: RAISE FND_API.g_exc_unexpected_error;
1378: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1379: RAISE FND_API.g_exc_error;
1380: END IF;
1381:
1382: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1383: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');

Line 1390: WHEN FND_API.g_exc_error THEN

1386: RETURN (l_legal_entity_id);
1387:
1388: EXCEPTION
1389:
1390: WHEN FND_API.g_exc_error THEN
1391:
1392: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1393: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1394: END IF;

Line 1406: WHEN FND_API.g_exc_unexpected_error THEN

1402: IF (cur_batch_source_id%isopen) THEN
1403: CLOSE cur_batch_source_id;
1404: END IF;
1405:
1406: WHEN FND_API.g_exc_unexpected_error THEN
1407:
1408: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1409: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1410: END IF;

Line 1511: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1507: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1508: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1509: END IF;
1510:
1511: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1512: RAISE FND_API.g_exc_unexpected_error;
1513: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1514: RAISE FND_API.g_exc_error;
1515: END IF;

Line 1512: RAISE FND_API.g_exc_unexpected_error;

1508: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1509: END IF;
1510:
1511: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1512: RAISE FND_API.g_exc_unexpected_error;
1513: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1514: RAISE FND_API.g_exc_error;
1515: END IF;
1516:

Line 1513: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1509: END IF;
1510:
1511: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1512: RAISE FND_API.g_exc_unexpected_error;
1513: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1514: RAISE FND_API.g_exc_error;
1515: END IF;
1516:
1517: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 1514: RAISE FND_API.g_exc_error;

1510:
1511: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1512: RAISE FND_API.g_exc_unexpected_error;
1513: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1514: RAISE FND_API.g_exc_error;
1515: END IF;
1516:
1517: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1518: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');

Line 1525: WHEN FND_API.g_exc_error THEN

1521: RETURN (l_legal_entity_id);
1522:
1523: EXCEPTION
1524:
1525: WHEN FND_API.g_exc_error THEN
1526:
1527: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1528: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1529: END IF;

Line 1535: WHEN FND_API.g_exc_unexpected_error THEN

1531: IF (cur_batch_source_id%isopen) THEN
1532: CLOSE cur_batch_source_id;
1533: END IF;
1534:
1535: WHEN FND_API.g_exc_unexpected_error THEN
1536:
1537: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1538: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1539: END IF;

Line 1696: IF(FND_API.G_TRUE = p_init_msg_list) THEN

1692: p_level => FND_LOG.level_procedure);
1693: END IF;
1694:
1695: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1696: IF(FND_API.G_TRUE = p_init_msg_list) THEN
1697: FND_MSG_PUB.initialize;
1698: END IF;
1699:
1700: --1. get hdr details from okc table and do basic id validation

Line 1711: RAISE FND_API.g_exc_error;

1707: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1708: END IF;
1709: FND_MSG_PUB.ADD;
1710: CLOSE okc_hdr_csr;
1711: RAISE FND_API.g_exc_error;
1712: END IF;
1713: CLOSE okc_hdr_csr;
1714:
1715: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1910: RAISE FND_API.g_exc_error;

1906: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1907: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1908: END IF;
1909: FND_MSG_PUB.ADD;
1910: RAISE FND_API.g_exc_error;
1911: END IF;
1912: -- End of added for tax bug # 4026206
1913:
1914:

Line 2011: RAISE FND_API.g_exc_unexpected_error;

2007: END IF;
2008: IF Cur_Batch_Source_Id%ISOPEN THEN
2009: CLOSE Cur_Batch_Source_Id;
2010: END IF;
2011: RAISE FND_API.g_exc_unexpected_error;
2012: END;
2013: END IF;
2014: --end npalepu
2015:

Line 2061: RAISE FND_API.g_exc_unexpected_error;

2057: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2058: --then add it to the message api list
2059: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2060: END IF;
2061: RAISE FND_API.g_exc_unexpected_error;
2062:
2063: END; --of inner block
2064:
2065: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2089: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','calling ZX_API_PUB.calculate_tax, p_quote_flag=Y, p_data_transfer_mode=PLS, p_validation_level=FND_API.G_VALID_LEVEL_FULL, transaction_rec_details.'||

2085:
2086:
2087: --18. finally call the zx api to calculate tax
2088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2089: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','calling ZX_API_PUB.calculate_tax, p_quote_flag=Y, p_data_transfer_mode=PLS, p_validation_level=FND_API.G_VALID_LEVEL_FULL, transaction_rec_details.'||
2090: ' ,trec.internal_organization_id='||transaction_rec.internal_organization_id||
2091: ' ,trec.application_id='||transaction_rec.application_id||
2092: ' ,trec.entity_code='||transaction_rec.entity_code||
2093: ' ,trec.event_class_code='||transaction_rec.event_class_code||

Line 2101: p_commit => FND_API.G_FALSE,

2097:
2098: ZX_API_PUB.calculate_tax(
2099: p_api_version => p_api_version,
2100: p_init_msg_list => p_init_msg_list,
2101: p_commit => FND_API.G_FALSE,
2102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2103: x_return_status => x_return_status,
2104: x_msg_count => x_msg_count,
2105: x_msg_data => x_msg_data,

Line 2102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2098: ZX_API_PUB.calculate_tax(
2099: p_api_version => p_api_version,
2100: p_init_msg_list => p_init_msg_list,
2101: p_commit => FND_API.G_FALSE,
2102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2103: x_return_status => x_return_status,
2104: x_msg_count => x_msg_count,
2105: x_msg_data => x_msg_data,
2106: p_transaction_rec => transaction_rec,

Line 2115: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

2111: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2112: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','after call to ZX_API_PUB.calculate_tax, x_return_status='||x_return_status||' ,x_doc_level_recalc_flag='||l_doc_level_recalc_flag);
2113: END IF;
2114:
2115: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2116: RAISE FND_API.g_exc_unexpected_error;
2117: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2118: RAISE FND_API.g_exc_error;
2119: END IF;

Line 2116: RAISE FND_API.g_exc_unexpected_error;

2112: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','after call to ZX_API_PUB.calculate_tax, x_return_status='||x_return_status||' ,x_doc_level_recalc_flag='||l_doc_level_recalc_flag);
2113: END IF;
2114:
2115: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2116: RAISE FND_API.g_exc_unexpected_error;
2117: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2118: RAISE FND_API.g_exc_error;
2119: END IF;
2120:

Line 2117: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

2113: END IF;
2114:
2115: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2116: RAISE FND_API.g_exc_unexpected_error;
2117: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2118: RAISE FND_API.g_exc_error;
2119: END IF;
2120:
2121: --19. get the calculated tax value

Line 2118: RAISE FND_API.g_exc_error;

2114:
2115: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2116: RAISE FND_API.g_exc_unexpected_error;
2117: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2118: RAISE FND_API.g_exc_error;
2119: END IF;
2120:
2121: --19. get the calculated tax value
2122: --query to get the calculated tax from the global temp table

Line 2164: WHEN FND_API.g_exc_error THEN

2160: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2161:
2162:
2163: EXCEPTION
2164: WHEN FND_API.g_exc_error THEN
2165: x_return_status := FND_API.G_RET_STS_ERROR ;
2166:
2167: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2168: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

Line 2165: x_return_status := FND_API.G_RET_STS_ERROR ;

2161:
2162:
2163: EXCEPTION
2164: WHEN FND_API.g_exc_error THEN
2165: x_return_status := FND_API.G_RET_STS_ERROR ;
2166:
2167: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2168: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2169: END IF;

Line 2214: WHEN FND_API.g_exc_unexpected_error THEN

2210: CLOSE Cur_Batch_Source_Id;
2211: END IF;
2212: --end npalepu
2213:
2214: WHEN FND_API.g_exc_unexpected_error THEN
2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2216:
2217: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2218: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

Line 2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2211: END IF;
2212: --end npalepu
2213:
2214: WHEN FND_API.g_exc_unexpected_error THEN
2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2216:
2217: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2218: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
2219: END IF;

Line 2265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2261: END IF;
2262: --end npalepu
2263:
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2266:
2267: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2268: --first log the sqlerrm
2269: l_error_text := substr (SQLERRM, 1, 240);