DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on FND_API

Line 140: x_error_status := FND_API.G_RET_STS_SUCCESS;

136: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
137: END IF;
138:
139: /*Set the return status to Success */
140: x_error_status := FND_API.G_RET_STS_SUCCESS;
141:
142: BEGIN
143: SELECT
144: ZX_DET_FACT.EVENT_CLASS_CODE ,

Line 175: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: EXCEPTION WHEN OTHERS THEN
172: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
173: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
174: END IF;
175: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: g_string :='No Header information present';
177: error_exception_handle(g_string);
178: x_messages_tbl:=g_messages_tbl;
179: return;

Line 254: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: WHEN OTHERS THEN
251: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
252: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
253: END IF;
254: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: g_string :='Not able to insert in to ZX_PRVDR_HDR_EXTNS_GT table ';
256: x_messages_tbl:=g_messages_tbl;
257: error_exception_handle(g_string);
258: return;

Line 275: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: WHEN OTHERS THEN
272: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
273: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||':'||l_api_name,SQLERRM);
274: END IF;
275: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: g_string :='Failed in DERIVE_HDR_EXT_ATTR procedure';
277: error_exception_handle(g_string);
278: x_messages_tbl:=g_messages_tbl;
279: return;

Line 457: x_error_status := FND_API.G_RET_STS_SUCCESS;

453: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
454: END IF;
455:
456: /*Set the return status to Success */
457: x_error_status := FND_API.G_RET_STS_SUCCESS;
458:
459: --Initialiaze all the nested tables
460: Initialize_Nested_Tables;
461:

Line 640: IF x_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

636: ) ;
637: NULL;
638: END IF;
639:
640: IF x_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
641: IF (g_level_exception >= g_current_runtime_level ) THEN
642: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
643: END IF;
644: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 644: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

640: IF x_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
641: IF (g_level_exception >= g_current_runtime_level ) THEN
642: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
643: END IF;
644: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: g_string :='Failed with error in procedure POPULATE_EXEMPTION_DETAILS';
646: error_exception_handle(g_string);
647: x_messages_tbl:=g_messages_tbl;
648: return;

Line 806: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR ;

802: WHEN OTHERS THEN
803: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
805: END IF;
806: x_error_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: g_string :='Not able to insert in to ZX_PRVDR_LINE_EXTNS_GT ';
808: error_exception_handle(g_string);
809: x_messages_tbl:=g_messages_tbl;
810: return;

Line 1004: x_ret_status := FND_API.G_RET_STS_SUCCESS;

1000: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1001: END IF;
1002:
1003: /*Set the return status to Success */
1004: x_ret_status := FND_API.G_RET_STS_SUCCESS;
1005:
1006: x_exempt_record := null;
1007:
1008: tax_identifier_tab(1):= 'STATE';

Line 1183: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

1179: EXCEPTION WHEN NO_DATA_FOUND THEN
1180: IF (g_level_exception >= g_current_runtime_level ) THEN
1181: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1182: END IF;
1183: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1184: g_string :='No Data found from ZX_EXEMPTIONS for provided id';
1185: error_exception_handle(g_string);
1186: --x_messages_tbl:=g_messages_tbl;
1187: RETURN;

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

1216: x_jurisdictions_found => l_jurisdictions_found,
1217: x_return_status => x_ret_status);
1218: END IF;
1219:
1220: IF (x_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1221: /*FND_LOG.STRING(g_level_statement,
1222: 'In Populate Exemption Details',
1223: 'After calling get_tax_jurisdictions, x_return_status = '|| x_ret_status);*/
1224: RETURN;

Line 1488: p_error_status := FND_API.G_RET_STS_UNEXP_ERROR;

1484: WHEN OTHERS THEN
1485: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1486: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1487: END IF;
1488: p_error_status := FND_API.G_RET_STS_UNEXP_ERROR;
1489:
1490: END POPULATE_EXEMPTION_DETAILS;
1491:
1492: /*===========================================================================+

Line 1962: IF x_ret_status = FND_API.G_RET_STS_SUCCESS THEN

1958: x_tax_jurisdiction_rec => l_tax_jurisdiction_rec,
1959: x_jurisdictions_found => l_jurisdictions_found,
1960: x_return_status => x_ret_status);
1961:
1962: IF x_ret_status = FND_API.G_RET_STS_SUCCESS THEN
1963: IF l_jurisdictions_found = 'Y' THEN
1964: IF l_tax_jurisdiction_rec.tax_jurisdiction_code IS NOT NULL THEN
1965: l_ship_to_geocode := l_tax_jurisdiction_rec.tax_jurisdiction_code;
1966: