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_VTX_USER_PKG dependencies on FND_API

Line 127: x_error_status := FND_API.G_RET_STS_SUCCESS;

123: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
124: END IF;
125:
126: /*Set the return status to Success */
127: x_error_status := FND_API.G_RET_STS_SUCCESS;
128:
129: l_header_ext_attr1 := fnd_profile.value_specific('ZX_TAXVDR_CASESENSITIVE');
130:
131: BEGIN

Line 164: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

160: EXCEPTION WHEN OTHERS THEN
161: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
162: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
163: END IF;
164: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
165: g_string :='No Header information present';
166: error_exception_handle(g_string);
167: x_messages_tbl:=g_messages_tbl;
168: return;

Line 245: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: WHEN OTHERS THEN
242: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
244: END IF;
245: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: g_string :='Not able to insert in to ZX_PRVDR_HDR_EXTNS_GT table ';
247: x_messages_tbl:=g_messages_tbl;
248: error_exception_handle(g_string);
249: return;

Line 267: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

263: WHEN OTHERS THEN
264: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
265: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
266: END IF;
267: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: g_string :='Failed in DERIVE_HDR_EXT_ATTR procedure';
269: error_exception_handle(g_string);
270: x_messages_tbl:=g_messages_tbl;
271: return;

Line 435: x_error_status := FND_API.G_RET_STS_SUCCESS;

431: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
432: END IF;
433:
434: /*Set the return status to Success */
435: x_error_status := FND_API.G_RET_STS_SUCCESS;
436:
437: --Initialiaze all the nested tables
438: Initialize_Nested_Tables;
439:

Line 589: IF x_error_status <> FND_API.G_RET_STS_SUCCESS THEN

585: p_position => i,
586: p_error_status => x_error_status
587: ) ;
588: END IF;
589: IF x_error_status <> FND_API.G_RET_STS_SUCCESS THEN
590: IF (g_level_exception >= g_current_runtime_level ) THEN
591: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
592: END IF;
593: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 593: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

589: IF x_error_status <> FND_API.G_RET_STS_SUCCESS THEN
590: IF (g_level_exception >= g_current_runtime_level ) THEN
591: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
592: END IF;
593: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: g_string :='Failed with error in procedure POPULATE_EXEMPTION_DETAILS';
595: error_exception_handle(g_string);
596: x_messages_tbl:=g_messages_tbl;
597: RETURN;

Line 731: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR ;

727: WHEN OTHERS THEN
728: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
730: END IF;
731: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: g_string :='Not able to insert in to ZX_PRVDR_LINE_EXTNS_GT ';
733: error_exception_handle(g_string);
734: x_messages_tbl:=g_messages_tbl;
735: return;

Line 928: x_ret_status := FND_API.G_RET_STS_SUCCESS;

924: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
925: END IF;
926:
927: /*Set the return status to Success */
928: x_ret_status := FND_API.G_RET_STS_SUCCESS;
929:
930: x_exempt_record := null;
931:
932: tax_identifier_tab(1):= 'STATE';

Line 1154: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

1150: EXCEPTION WHEN NO_DATA_FOUND THEN
1151: IF (g_level_exception >= g_current_runtime_level ) THEN
1152: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1153: END IF;
1154: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: g_string :='No Data found from ZX_EXEMPTIONS for provided id';
1156: error_exception_handle(g_string);
1157: --x_messages_tbl:=g_messages_tbl;
1158: RETURN;

Line 1193: IF (x_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

1189: x_jurisdictions_found => l_jurisdictions_found,
1190: x_return_status => x_ret_status);
1191: END IF;
1192:
1193: IF (x_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1194: RETURN;
1195: ELSE
1196: IF l_jurisdiction_rec.tax_jurisdiction_id IS NOT NULL THEN
1197: l_multiple_jurisdictions_flag := 'N';

Line 1449: p_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1445: WHEN OTHERS THEN
1446: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1447: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1448: END IF;
1449: p_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450:
1451: END POPULATE_EXEMPTION_DETAILS;
1452:
1453: /*===========================================================================+

Line 1907: IF x_ret_status = FND_API.G_RET_STS_SUCCESS THEN

1903: x_tax_jurisdiction_rec => l_tax_jurisdiction_rec,
1904: x_jurisdictions_found => l_jurisdictions_found,
1905: x_return_status => x_ret_status);
1906: END IF;
1907: IF x_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1908: IF l_jurisdictions_found = 'Y' THEN
1909: IF l_tax_jurisdiction_rec.tax_jurisdiction_code IS NOT NULL THEN
1910: l_jur_code := substr(l_tax_jurisdiction_rec.tax_jurisdiction_code, 4);
1911: ELSE