DBA Data[Home] [Help]

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 1046: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

1042: EXCEPTION WHEN NO_DATA_FOUND THEN
1043: IF (g_level_exception >= g_current_runtime_level ) THEN
1044: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1045: END IF;
1046: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1047: g_string :='No Data found from ZX_EXEMPTIONS for provided id';
1048: error_exception_handle(g_string);
1049: --x_messages_tbl:=g_messages_tbl;
1050: RETURN;

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

1080: x_jurisdictions_found => l_jurisdictions_found,
1081: x_return_status => x_ret_status);
1082: END IF;
1083:
1084: IF (x_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1085: /*FND_LOG.STRING(g_level_statement,
1086: 'In Populate Exemption Details',
1087: 'After calling get_tax_jurisdictions, x_return_status = '|| x_ret_status);*/
1088: RETURN;

Line 1303: p_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1299: WHEN OTHERS THEN
1300: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1302: END IF;
1303: p_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1304:
1305: END POPULATE_EXEMPTION_DETAILS;
1306:
1307: /*===========================================================================+

Line 1761: IF x_ret_status = FND_API.G_RET_STS_SUCCESS THEN

1757: x_tax_jurisdiction_rec => l_tax_jurisdiction_rec,
1758: x_jurisdictions_found => l_jurisdictions_found,
1759: x_return_status => x_ret_status);
1760: END IF;
1761: IF x_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1762: IF l_jurisdictions_found = 'Y' THEN
1763: IF l_tax_jurisdiction_rec.tax_jurisdiction_code IS NOT NULL THEN
1764: l_jur_code := substr(l_tax_jurisdiction_rec.tax_jurisdiction_code, 4);
1765: ELSE