1: PACKAGE BODY ZX_GET_TAX_PARAM_DRIVER_PKG AS
2: /* $Header: zxifgetparampkgb.pls 120.39 2011/08/08 13:57:55 srajapar ship $ */
3:
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
2: /* $Header: zxifgetparampkgb.pls 120.39 2011/08/08 13:57:55 srajapar ship $ */
3:
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
3:
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_GET_TAX_PARAM_DRIVER_PKG.';
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_GET_TAX_PARAM_DRIVER_PKG.';
13:
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_GET_TAX_PARAM_DRIVER_PKG.';
13:
14:
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_GET_TAX_PARAM_DRIVER_PKG.';
13:
14:
15:
24:
25: BEGIN
26:
27: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
28: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'GET_DRIVER_VALUE.BEGIN','ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+ Number');
29: END IF;
30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
399: END IF;
400: END IF;
401:
402: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
403: FND_LOG.STRING(
404: G_LEVEL_STATEMENT,
405: G_MODULE_NAME||'GET_DRIVER_VALUE.END',
406: 'ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()- Number'||
407: ', p_tax_param_code:'||p_tax_param_code||' x_tax_param_value:'||to_char(x_tax_param_value)
411: EXCEPTION
412: WHEN OTHERS THEN
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'GET_DRIVER_VALUE - Number:',SQLERRM);
416: END IF;
417:
418: END get_driver_value;
419:
429:
430: BEGIN
431:
432: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'GET_DRIVER_VALUE.BEGIN','ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+ Date');
434: END IF;
435:
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
493:
494: END IF;
495:
496: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING(
498: G_LEVEL_STATEMENT,
499: G_MODULE_NAME||'GET_DRIVER_VALUE.END',
500: 'ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()- Date'||
501: 'p_tax_param_code:'||p_tax_param_code||' x_tax_param_value:'||to_char(x_tax_param_value));
505:
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'GET_DRIVER_VALUE - Date:',SQLERRM);
510: END IF;
511:
512: END get_driver_value;
513:
522:
523: BEGIN
524:
525: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
526: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'GET_DRIVER_VALUE.BEGIN','ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()+ Varchar');
527: END IF;
528:
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530:
921: END IF;
922: END IF;
923:
924: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(
926: G_LEVEL_STATEMENT,
927: G_MODULE_NAME||'GET_DRIVER_VALUE.END',
928: 'ZX_GET_TAX_PARAM_DRIVER_PKG: GET_DRIVER_VALUE()- Varchar'||
929: 'p_tax_param_code:'||p_tax_param_code||' x_tax_param_value:'||to_char(x_tax_param_value));
932: EXCEPTION
933: WHEN OTHERS THEN
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
936: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'GET_DRIVER_VALUE - Varchar:',SQLERRM);
937: END IF;
938: END get_driver_value;
939:
940: END ZX_GET_TAX_PARAM_DRIVER_PKG;