DBA Data[Home] [Help]

APPS.ZX_TAX_TAXWARE_REV dependencies on FND_LOG

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

5: | Global Structure Data Types |
6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_TAXWARE_REV';
9: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_TAXWARE_REV';
9: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_TAXWARE_REV';
9: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ZX_TAX_TAXWARE_REV';
9: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_TAXWARE_REV.';

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

9: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_TAXWARE_REV.';
17: g_string varchar2(200);

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

10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_TAXWARE_REV.';
17: g_string varchar2(200);
18:

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

11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'ZX.PLSQL.ZX_TAX_TAXWARE_REV.';
17: g_string varchar2(200);
18:
19: /*------------------------

Line 47: FND_LOG.STRING(g_level_procedure,

43: FUNCTION Get_Release RETURN VARCHAR2 IS
44: BEGIN
45:
46: IF (g_level_procedure >= g_current_runtime_level ) THEN
47: FND_LOG.STRING(g_level_procedure,
48: 'ZX.PL/SQL.ZX_TAX_TAXWARE_REV.GET_RELEASE',
49: 'ZX_TAX_TAXWARE_REV.GET_RELEASE(+)');
50: END IF;
51:

Line 53: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

49: 'ZX_TAX_TAXWARE_REV.GET_RELEASE(+)');
50: END IF;
51:
52: IF ( g_level_statement >= g_current_runtime_level) THEN
53: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
54: 'Checking Current release=='||pg_release_number);
55:
56: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
57: 'Major.Minor=='||pg_comp_rel_num_major||'.'||pg_comp_rel_num_minor_high);

Line 56: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

52: IF ( g_level_statement >= g_current_runtime_level) THEN
53: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
54: 'Checking Current release=='||pg_release_number);
55:
56: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
57: 'Major.Minor=='||pg_comp_rel_num_major||'.'||pg_comp_rel_num_minor_high);
58: END IF;
59:
60:

Line 73: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

69: EXCEPTION
70: WHEN OTHERS THEN
71:
72: IF ( g_level_exception >= g_current_runtime_level) THEN
73: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
74: 'Version Error: '||to_char(SQLCODE)||SQLERRM);
75: END IF;
76: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: g_string :='Not compaitable to TAXWARE Release';

Line 84: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

80: END;
81: end if;
82:
83: IF ( g_level_statement >= g_current_runtime_level) THEN
84: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
85: 'major: '||substrb(pg_release_number, 1,instrb(pg_release_number, '.')-1));
86:
87: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
88: 'minor: '||substrb(pg_release_number, instrb(pg_release_number,'.')+1,1));

Line 87: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

83: IF ( g_level_statement >= g_current_runtime_level) THEN
84: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
85: 'major: '||substrb(pg_release_number, 1,instrb(pg_release_number, '.')-1));
86:
87: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
88: 'minor: '||substrb(pg_release_number, instrb(pg_release_number,'.')+1,1));
89: END IF;
90:
91:

Line 97: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

93: instrb(pg_release_number, '.')-1)) <> pg_comp_rel_num_major THEN
94:
95: pg_compatible_release := FALSE;
96: IF ( g_level_exception >= g_current_runtime_level) THEN
97: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
98: 'Version Error: '||to_char(SQLCODE)||SQLERRM);
99: END IF;
100: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: g_string :='Release number of Taxware SALES/USE TAX SYSTEM is '||

Line 120: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

116: THEN
117: pg_compatible_release := FALSE;
118:
119: IF ( g_level_exception >= g_current_runtime_level) THEN
120: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
121: 'Version Error: '||to_char(SQLCODE)||SQLERRM);
122: END IF;
123: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: g_string :='Release number of Taxware SALES/USE TAX SYSTEM is '||

Line 145: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

141:
142: return('0');
143:
144: IF ( g_level_statement >= g_current_runtime_level) THEN
145: FND_LOG.STRING(g_level_statement,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
146: 'ZX_TAX_TAXWARE_REV.GET_RELEASE(TRUE)-');
147: END IF;
148:
149: EXCEPTION

Line 152: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

148:
149: EXCEPTION
150: WHEN OTHERS THEN
151: IF ( g_level_exception >= g_current_runtime_level) THEN
152: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
153: 'TAXWARE is not installed.');
154:
155: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
156: 'SQLERRM: '||SQLERRM);

Line 155: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

151: IF ( g_level_exception >= g_current_runtime_level) THEN
152: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
153: 'TAXWARE is not installed.');
154:
155: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
156: 'SQLERRM: '||SQLERRM);
157:
158: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
159: 'ARP_TAX_TAXWARE_REV.GET_RELEASE(FALSE)-');

Line 158: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',

154:
155: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
156: 'SQLERRM: '||SQLERRM);
157:
158: FND_LOG.STRING(g_level_exception,'ZX_TAX_TAXWARE_REV.GET_RELEASE',
159: 'ARP_TAX_TAXWARE_REV.GET_RELEASE(FALSE)-');
160: END IF;
161:
162: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;