DBA Data[Home] [Help]

APPS.ZX_TAX_VERTEX_REV dependencies on FND_LOG

Line 18: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

14: | Global Structure Data Types |
15: * ======================================================================*/
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_VERTEX_REV';
18: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
19: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 19: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

15: * ======================================================================*/
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_VERTEX_REV';
18: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
19: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_VERTEX_REV';
18: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
19: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_VERTEX_REV';
18: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
19: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_VERTEX_REV.';

Line 22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

18: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
19: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_VERTEX_REV.';
26:

Line 23: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

19: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_VERTEX_REV.';
26:
27: g_string Varchar2(200);

Line 24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

20: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
21: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
22: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
23: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
24: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
25: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_VERTEX_REV.';
26:
27: g_string Varchar2(200);
28:

Line 67: FND_LOG.STRING(g_level_procedure,

63:
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: IF (g_level_procedure >= g_current_runtime_level ) THEN
67: FND_LOG.STRING(g_level_procedure,
68: 'ZX.PL/SQL.ZX_TAX_VERTEX_REV.GET_RELEASE',
69: 'ZX_TAX_VERTEX_REV.GET_RELEASE(+)');
70: END IF;
71:

Line 83: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',

79: | Retrieve product version information. |
80: -----------------------------------------------------------*/
81: BEGIN
82: IF ( g_level_statement >= g_current_runtime_level) THEN
83: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
84: 'Call ZX_TAX_VERTEX_QSU.QSUGetVersionInfo to get version number');
85: END IF;
86:
87: ZX_TAX_VERTEX_QSU.QSUGetVersionInfo(context_rec,version_rec);

Line 94: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',

90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: IF ( g_level_exception >= g_current_runtime_level) THEN
94: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
95: 'Version Error: '||to_char(SQLCODE)||SQLERRM);
96: END IF;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: g_string :='Not compaitable to VERTEX Release';

Line 105: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',

101:
102: END;
103:
104: IF ( g_level_statement >= g_current_runtime_level) THEN
105: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
106: 'Version Number is== '||version_rec.fVersionNumber);
107:
108: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
109: 'Release Date is '||to_char(version_rec.fReleaseDate));

Line 108: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',

104: IF ( g_level_statement >= g_current_runtime_level) THEN
105: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
106: 'Version Number is== '||version_rec.fVersionNumber);
107:
108: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
109: 'Release Date is '||to_char(version_rec.fReleaseDate));
110:
111: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
112: 'MAJOR: '||substrb(version_rec.fVersionNumber, 1,instrb(version_rec.fVersionNumber, '.')-1));

Line 111: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',

107:
108: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
109: 'Release Date is '||to_char(version_rec.fReleaseDate));
110:
111: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
112: 'MAJOR: '||substrb(version_rec.fVersionNumber, 1,instrb(version_rec.fVersionNumber, '.')-1));
113:
114: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
115: 'MINOR: '||substrb(version_rec.fVersionNumber,

Line 114: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',

110:
111: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
112: 'MAJOR: '||substrb(version_rec.fVersionNumber, 1,instrb(version_rec.fVersionNumber, '.')-1));
113:
114: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
115: 'MINOR: '||substrb(version_rec.fVersionNumber,
116: instrb(version_rec.fVersionNumber,'.')+1,
117: instrb(version_rec.fVersionNumber, '.', 1, 2)-
118: (instrb(version_rec.fVersionNumber,'.')+1)));

Line 147: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',

143: ELSE
144: pg_version_check := TRUE;
145: END IF;
146: IF ( g_level_statement >= g_current_runtime_level) THEN
147: FND_LOG.STRING(g_level_statement,'ZX_TAX_VERTEX_REV.GET_RELEASE',
148: 'ZX_TAX_VERTEX_REV.GET_RELEASE(TRUE)-');
149: END IF;
150:
151: --return TRUE;

Line 156: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',

152:
153: EXCEPTION
154: WHEN OTHERS THEN
155: IF ( g_level_exception >= g_current_runtime_level) THEN
156: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
157: 'Vertex is not installed.');
158:
159: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
160: 'SQLERRM: '||SQLERRM);

Line 159: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',

155: IF ( g_level_exception >= g_current_runtime_level) THEN
156: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
157: 'Vertex is not installed.');
158:
159: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
160: 'SQLERRM: '||SQLERRM);
161:
162: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
163: 'ARP_TAX_VERTEX_REV.GET_RELEASE(FALSE)-');

Line 162: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',

158:
159: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
160: 'SQLERRM: '||SQLERRM);
161:
162: FND_LOG.STRING(g_level_exception,'ZX_TAX_VERTEX_REV.GET_RELEASE',
163: 'ARP_TAX_VERTEX_REV.GET_RELEASE(FALSE)-');
164: END IF;
165:
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;