DBA Data[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on FND_API

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: from zx_validation_errors_gt;
150:
151: BEGIN
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
155:
156: IF (g_level_procedure >= g_current_runtime_level ) THEN
157: FND_LOG.STRING(g_level_procedure,

Line 233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

229: -- Need to verify if we need to raise a UNEXPECTED error if we fail to set first party
230: -- Checked with Isaac. This should not be an unexpected error, but raise one valdn error for
231: -- all transactions and do not proceed further => Changes yet to be implemented
232:
233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: IF (g_level_exception >= g_current_runtime_level ) THEN
235: FND_LOG.STRING(g_level_exception,
236: 'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR:
237: Get Tax Subscriber : Returned Error Status',

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: FND_LOG.STRING(g_level_unexpected,
396: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
397: sqlerrm);
398: END IF;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: app_exception.raise_exception;
401: END Default_And_Validate_Tax_Attr;
402:
403:

Line 452: x_return_status := FND_API.G_RET_STS_SUCCESS;

448: and header.TRX_ID = lines.TRX_ID ;
449:
450: BEGIN
451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
454: IF (g_level_procedure >= g_current_runtime_level ) THEN
455: FND_LOG.STRING(g_level_procedure,
456: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',

Line 1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1586: FND_LOG.STRING(g_level_unexpected,
1587: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1588: sqlerrm);
1589: END IF;
1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1591: app_exception.raise_exception;
1592:
1593: END Default_Tax_Attr;
1594:

Line 1891: x_return_status := FND_API.G_RET_STS_SUCCESS;

1887: summary_tax_line_number
1888: FROM zx_trx_tax_link_gt;
1889:
1890: BEGIN
1891: x_return_status := FND_API.G_RET_STS_SUCCESS;
1892: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1893: IF (g_level_procedure >= g_current_runtime_level ) THEN
1894: FND_LOG.STRING(g_level_procedure,
1895: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',

Line 6764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6760: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6761: sqlerrm);
6762: END IF;
6763:
6764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6765: app_exception.raise_exception;
6766:
6767:
6768:

Line 7340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7336: 'ZX_VALIDATE_API_PKG.Validate_Other_Documents',
7337: sqlerrm);
7338: END IF;
7339:
7340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7341: app_exception.raise_exception;
7342: END Validate_Other_Documents;
7343:
7344:

Line 7499: x_return_status := FND_API.G_RET_STS_SUCCESS;

7495:
7496: --
7497: -- init error buffer and return status
7498: --
7499: x_return_status := FND_API.G_RET_STS_SUCCESS;
7500: l_error_buffer := NULL;
7501:
7502: OPEN get_parm_info_for_def_tax_csr;
7503:

Line 7653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7649: l_definforec,
7650: x_return_status,
7651: l_error_buffer);
7652:
7653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7654: EXIT;
7655: END IF;
7656:
7657: --

Line 7666: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7662: l_output_tax_classif_code_tbl(i) := l_definforec.output_tax_classification_code;
7663: -- END IF ; -- end if for the conditional call
7664: END LOOP;
7665:
7666: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7667: EXIT;
7668: END IF;
7669:
7670: --

Line 7707: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7703: EXIT;
7704: END IF;
7705: END LOOP;
7706:
7707: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7708: CLOSE get_parm_info_for_def_tax_csr;
7709: RETURN;
7710: END IF;
7711:

Line 7726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7722: END IF;
7723:
7724: EXCEPTION
7725: WHEN OTHERS THEN
7726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7727: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
7728: IF get_parm_info_for_def_tax_csr%ISOPEN THEN
7729: CLOSE get_parm_info_for_def_tax_csr;
7730: END IF;

Line 8204: x_return_status := FND_API.G_RET_STS_SUCCESS;

8200: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8201: 'Before opening the cursor - gtt_to_glb_strctr_csr');
8202: END IF;
8203:
8204: x_return_status := FND_API.G_RET_STS_SUCCESS;
8205: OPEN gtt_to_glb_strctr_csr;
8206:
8207: IF (g_level_statement >= g_current_runtime_level ) THEN
8208: FND_LOG.STRING(g_level_statement,

Line 8629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8625: p_event_class_rec => l_event_class_rec,
8626: x_return_status => l_return_status
8627: );
8628:
8629: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8630: IF (g_level_procedure >= g_current_runtime_level ) THEN
8631: FND_LOG.STRING(g_level_procedure,
8632: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8633: 'x_return_status = ' || x_return_status);

Line 8677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8673: NULL, --p_tax_invoice_date
8674: x_return_status
8675: );
8676:
8677: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8678: IF (g_level_procedure >= g_current_runtime_level ) THEN
8679: FND_LOG.STRING(g_level_procedure,
8680: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.def_additional_tax_attribs',
8681: 'x_return_status = ' || x_return_status);

Line 8758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8754:
8755: EXCEPTION
8756:
8757: WHEN OTHERS THEN
8758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8759: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
8760: IF gtt_to_glb_strctr_csr%ISOPEN THEN
8761: CLOSE gtt_to_glb_strctr_csr;
8762: END IF;