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 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

558:
559: EXCEPTION
560:
561: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
564: --first log the sqlerrm
565: l_error_text := substr (SQLERRM, 1, 512);
566: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

Line 845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

841:
842: EXCEPTION
843:
844: WHEN OTHERS THEN
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
847: --first log the sqlerrm
848: l_error_text := substr (SQLERRM, 1, 512);
849: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

Line 983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

979:
980: EXCEPTION
981:
982: WHEN OTHERS THEN
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
984: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
985: --first log the sqlerrm
986: l_error_text := substr (SQLERRM, 1, 512);
987: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

Line 1328: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1324: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1325: 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);
1326: END IF;
1327:
1328: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1329: RAISE FND_API.g_exc_unexpected_error;
1330: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1331: RAISE FND_API.g_exc_error;
1332: END IF;

Line 1329: RAISE FND_API.g_exc_unexpected_error;

1325: 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);
1326: END IF;
1327:
1328: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1329: RAISE FND_API.g_exc_unexpected_error;
1330: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1331: RAISE FND_API.g_exc_error;
1332: END IF;
1333:

Line 1330: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1326: END IF;
1327:
1328: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1329: RAISE FND_API.g_exc_unexpected_error;
1330: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1331: RAISE FND_API.g_exc_error;
1332: END IF;
1333:
1334: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 1331: RAISE FND_API.g_exc_error;

1327:
1328: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1329: RAISE FND_API.g_exc_unexpected_error;
1330: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1331: RAISE FND_API.g_exc_error;
1332: END IF;
1333:
1334: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1335: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');

Line 1342: WHEN FND_API.g_exc_error THEN

1338: RETURN (l_legal_entity_id);
1339:
1340: EXCEPTION
1341:
1342: WHEN FND_API.g_exc_error THEN
1343:
1344: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1345: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1346: END IF;

Line 1358: WHEN FND_API.g_exc_unexpected_error THEN

1354: IF (cur_batch_source_id%isopen) THEN
1355: CLOSE cur_batch_source_id;
1356: END IF;
1357:
1358: WHEN FND_API.g_exc_unexpected_error THEN
1359:
1360: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1361: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1362: END IF;

Line 1463: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1459: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1460: 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);
1461: END IF;
1462:
1463: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1464: RAISE FND_API.g_exc_unexpected_error;
1465: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1466: RAISE FND_API.g_exc_error;
1467: END IF;

Line 1464: RAISE FND_API.g_exc_unexpected_error;

1460: 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);
1461: END IF;
1462:
1463: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1464: RAISE FND_API.g_exc_unexpected_error;
1465: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:

Line 1465: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1461: END IF;
1462:
1463: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1464: RAISE FND_API.g_exc_unexpected_error;
1465: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:
1469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 1466: RAISE FND_API.g_exc_error;

1462:
1463: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1464: RAISE FND_API.g_exc_unexpected_error;
1465: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:
1469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1470: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');

Line 1477: WHEN FND_API.g_exc_error THEN

1473: RETURN (l_legal_entity_id);
1474:
1475: EXCEPTION
1476:
1477: WHEN FND_API.g_exc_error THEN
1478:
1479: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1480: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1481: END IF;

Line 1487: WHEN FND_API.g_exc_unexpected_error THEN

1483: IF (cur_batch_source_id%isopen) THEN
1484: CLOSE cur_batch_source_id;
1485: END IF;
1486:
1487: WHEN FND_API.g_exc_unexpected_error THEN
1488:
1489: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1490: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1491: END IF;

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

1644: p_level => FND_LOG.level_procedure);
1645: END IF;
1646:
1647: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1648: IF(FND_API.G_TRUE = p_init_msg_list) THEN
1649: FND_MSG_PUB.initialize;
1650: END IF;
1651:
1652: --1. get hdr details from okc table and do basic id validation

Line 1663: RAISE FND_API.g_exc_error;

1659: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1660: END IF;
1661: FND_MSG_PUB.ADD;
1662: CLOSE okc_hdr_csr;
1663: RAISE FND_API.g_exc_error;
1664: END IF;
1665: CLOSE okc_hdr_csr;
1666:
1667: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1862: RAISE FND_API.g_exc_error;

1858: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1859: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1860: END IF;
1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.g_exc_error;
1863: END IF;
1864: -- End of added for tax bug # 4026206
1865:
1866:

Line 1963: RAISE FND_API.g_exc_unexpected_error;

1959: END IF;
1960: IF Cur_Batch_Source_Id%ISOPEN THEN
1961: CLOSE Cur_Batch_Source_Id;
1962: END IF;
1963: RAISE FND_API.g_exc_unexpected_error;
1964: END;
1965: END IF;
1966: --end npalepu
1967:

Line 2013: RAISE FND_API.g_exc_unexpected_error;

2009: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2010: --then add it to the message api list
2011: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2012: END IF;
2013: RAISE FND_API.g_exc_unexpected_error;
2014:
2015: END; --of inner block
2016:
2017: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2041: 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.'||

2037:
2038:
2039: --18. finally call the zx api to calculate tax
2040: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2041: 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.'||
2042: ' ,trec.internal_organization_id='||transaction_rec.internal_organization_id||
2043: ' ,trec.application_id='||transaction_rec.application_id||
2044: ' ,trec.entity_code='||transaction_rec.entity_code||
2045: ' ,trec.event_class_code='||transaction_rec.event_class_code||

Line 2053: p_commit => FND_API.G_FALSE,

2049:
2050: ZX_API_PUB.calculate_tax(
2051: p_api_version => p_api_version,
2052: p_init_msg_list => p_init_msg_list,
2053: p_commit => FND_API.G_FALSE,
2054: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2055: x_return_status => x_return_status,
2056: x_msg_count => x_msg_count,
2057: x_msg_data => x_msg_data,

Line 2054: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2050: ZX_API_PUB.calculate_tax(
2051: p_api_version => p_api_version,
2052: p_init_msg_list => p_init_msg_list,
2053: p_commit => FND_API.G_FALSE,
2054: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2055: x_return_status => x_return_status,
2056: x_msg_count => x_msg_count,
2057: x_msg_data => x_msg_data,
2058: p_transaction_rec => transaction_rec,

Line 2067: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

2063: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2064: 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);
2065: END IF;
2066:
2067: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2068: RAISE FND_API.g_exc_unexpected_error;
2069: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2070: RAISE FND_API.g_exc_error;
2071: END IF;

Line 2068: RAISE FND_API.g_exc_unexpected_error;

2064: 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);
2065: END IF;
2066:
2067: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2068: RAISE FND_API.g_exc_unexpected_error;
2069: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2070: RAISE FND_API.g_exc_error;
2071: END IF;
2072:

Line 2069: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

2065: END IF;
2066:
2067: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2068: RAISE FND_API.g_exc_unexpected_error;
2069: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2070: RAISE FND_API.g_exc_error;
2071: END IF;
2072:
2073: --19. get the calculated tax value

Line 2070: RAISE FND_API.g_exc_error;

2066:
2067: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2068: RAISE FND_API.g_exc_unexpected_error;
2069: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
2070: RAISE FND_API.g_exc_error;
2071: END IF;
2072:
2073: --19. get the calculated tax value
2074: --query to get the calculated tax from the global temp table

Line 2116: WHEN FND_API.g_exc_error THEN

2112: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2113:
2114:
2115: EXCEPTION
2116: WHEN FND_API.g_exc_error THEN
2117: x_return_status := FND_API.G_RET_STS_ERROR ;
2118:
2119: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2120: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

Line 2117: x_return_status := FND_API.G_RET_STS_ERROR ;

2113:
2114:
2115: EXCEPTION
2116: WHEN FND_API.g_exc_error THEN
2117: x_return_status := FND_API.G_RET_STS_ERROR ;
2118:
2119: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2120: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2121: END IF;

Line 2166: WHEN FND_API.g_exc_unexpected_error THEN

2162: CLOSE Cur_Batch_Source_Id;
2163: END IF;
2164: --end npalepu
2165:
2166: WHEN FND_API.g_exc_unexpected_error THEN
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2168:
2169: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2170: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

Line 2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2163: END IF;
2164: --end npalepu
2165:
2166: WHEN FND_API.g_exc_unexpected_error THEN
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2168:
2169: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2170: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
2171: END IF;

Line 2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2213: END IF;
2214: --end npalepu
2215:
2216: WHEN OTHERS THEN
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2218:
2219: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2220: --first log the sqlerrm
2221: l_error_text := substr (SQLERRM, 1, 240);