DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_STATUS_DETM_PKG dependencies on FND_API

Line 78: -- init return status to FND_API.G_RET_STS_SUCCESS

74:
75:
76: END IF;
77:
78: -- init return status to FND_API.G_RET_STS_SUCCESS
79: p_return_status := FND_API.G_RET_STS_SUCCESS;
80: p_error_buffer := NULL;
81:
82: --

Line 79: p_return_status := FND_API.G_RET_STS_SUCCESS;

75:
76: END IF;
77:
78: -- init return status to FND_API.G_RET_STS_SUCCESS
79: p_return_status := FND_API.G_RET_STS_SUCCESS;
80: p_error_buffer := NULL;
81:
82: --
83: -- check if begin_index and end_index have values

Line 86: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

82: --
83: -- check if begin_index and end_index have values
84: --
85: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
86: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
87:
88: IF (g_level_error >= g_current_runtime_level ) THEN
89: FND_LOG.STRING(g_level_error,
90: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

Line 165: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

161: l_tax_determine_date,
162: p_return_status,
163: p_error_buffer);
164:
165: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: IF (g_level_error >= g_current_runtime_level ) THEN
167: FND_LOG.STRING(g_level_error,
168: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
169: 'Incorrect return_status after calling rule_base_tax_status_detm()');

Line 189: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

185: l_tax_determine_date,
186: l_status_rec,
187: p_return_status,
188: p_error_buffer);
189: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
190: IF (g_level_error >= g_current_runtime_level ) THEN
191: FND_LOG.STRING(g_level_error,
192: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
193: 'Incorrect return_status after calling '||

Line 202: p_return_status := FND_API.G_RET_STS_SUCCESS;

198: 'returned from rule engine. Need to get default tax status.');
199: END IF;
200: -- reset return status
201: --
202: p_return_status := FND_API.G_RET_STS_SUCCESS;
203: END IF;
204: l_reporting_code_id:= ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_status_result_id,
205: l_trx_date);
206: END IF;

Line 251: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

247: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
248: RETURN;
249: END IF;
250:
251: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
252: EXIT;
253: ELSE
254: update_det_tax_line(i,
255: l_status_result_id,

Line 272: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

268: END IF;
269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
274:
275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
276: FND_LOG.STRING(g_level_unexpected,

Line 346: p_return_status := FND_API.G_RET_STS_SUCCESS;

342: 'tax = ' || p_tax);
343:
344: END IF;
345:
346: p_return_status := FND_API.G_RET_STS_SUCCESS;
347:
348: OPEN get_def_status_info_csr(p_tax,
349: p_tax_regime_code,
350: p_tax_determine_date);

Line 363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

359: p_status_rec.Allow_Rate_Override_Flag,
360: p_status_rec.Allow_Exemptions_Flag,
361: p_status_rec.Allow_Exceptions_Flag;
362: IF get_def_status_info_csr%NOTFOUND THEN
363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364: p_error_buffer := 'No default tax status found';
365:
366: IF (g_level_statement >= g_current_runtime_level ) THEN
367: FND_LOG.STRING(g_level_statement,

Line 376: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

372: CLOSE get_def_status_info_csr;
373: --
374: -- update the global status cache structure
375: --
376: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
377: l_index := ZX_TDS_UTILITIES_PKG.get_tax_status_index(
378: p_status_rec.tax,
379: p_status_rec.tax_regime_code,
380: p_status_rec.tax_status_code);

Line 395: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

391: END IF;
392:
393: EXCEPTION
394: WHEN OTHERS THEN
395: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
397: IF get_def_status_info_csr%ISOPEN THEN
398: CLOSE get_def_status_info_csr;
399: END IF;

Line 448: p_return_status := FND_API.G_RET_STS_SUCCESS;

444: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
445: 'p_tax_id = ' || to_char(p_tax_id));
446: END IF;
447:
448: p_return_status := FND_API.G_RET_STS_SUCCESS;
449:
450: l_service_type_code := 'DET_TAX_STATUS';
451:
452: ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process(l_service_type_code,

Line 466: p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

462: p_return_status,
463: p_error_buffer);
464:
465: IF (l_tax_result_rec.alphanumeric_result IS NOT NULL AND
466: p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
467: p_tax_status_code := l_tax_result_rec.alphanumeric_result;
468: p_status_result_id := l_tax_result_rec.result_id;
469: END IF;
470:

Line 495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491: END IF;
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
497:
498: IF (g_level_unexpected >= g_current_runtime_level ) THEN
499: FND_LOG.STRING(g_level_unexpected,