eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_TAX_LINES_DETM_PKG dependencies on FND_LOG

Line 43: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

39: x_return_status OUT NOCOPY VARCHAR2,
40: x_error_buffer OUT NOCOPY VARCHAR2);
41:
42: g_current_runtime_level NUMBER;
43: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
44: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
45: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46:
47: c_lines_per_fetch CONSTANT NUMBER := 1000;

Line 44: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

40: x_error_buffer OUT NOCOPY VARCHAR2);
41:
42: g_current_runtime_level NUMBER;
43: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
44: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
45: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46:
47: c_lines_per_fetch CONSTANT NUMBER := 1000;
48: NUMBER_DUMMY CONSTANT NUMBER(15):= -999999999999999;

Line 45: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

41:
42: g_current_runtime_level NUMBER;
43: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
44: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
45: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46:
47: c_lines_per_fetch CONSTANT NUMBER := 1000;
48: NUMBER_DUMMY CONSTANT NUMBER(15):= -999999999999999;
49: -----------------------------------------------------------------------

Line 66: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

62: IS
63:
64: BEGIN
65:
66: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
67:
68: IF (g_level_procedure >= g_current_runtime_level ) THEN
69: FND_LOG.STRING(g_level_procedure,
70: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines.BEGIN',

Line 69: FND_LOG.STRING(g_level_procedure,

65:
66: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
67:
68: IF (g_level_procedure >= g_current_runtime_level ) THEN
69: FND_LOG.STRING(g_level_procedure,
70: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines.BEGIN',
71: 'ZX_TDS_TAX_LINES_DETM_PKG: determine_tax_lines(+)');
72: END IF;
73:

Line 93: FND_LOG.STRING(g_level_unexpected,

89: x_error_buffer => p_error_buffer);
90:
91: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
92: IF g_level_unexpected >= g_current_runtime_level THEN
93: FND_LOG.STRING(g_level_unexpected,
94: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
95: 'Incorrect return_status after calling process_copy_and_create()');
96: FND_LOG.STRING(g_level_unexpected,
97: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

Line 96: FND_LOG.STRING(g_level_unexpected,

92: IF g_level_unexpected >= g_current_runtime_level THEN
93: FND_LOG.STRING(g_level_unexpected,
94: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
95: 'Incorrect return_status after calling process_copy_and_create()');
96: FND_LOG.STRING(g_level_unexpected,
97: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
98: 'RETURN_STATUS = ' || p_return_status);
99: FND_LOG.STRING(g_level_unexpected,
100: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

Line 99: FND_LOG.STRING(g_level_unexpected,

95: 'Incorrect return_status after calling process_copy_and_create()');
96: FND_LOG.STRING(g_level_unexpected,
97: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
98: 'RETURN_STATUS = ' || p_return_status);
99: FND_LOG.STRING(g_level_unexpected,
100: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
101: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
102: END IF;
103: RETURN;

Line 118: FND_LOG.STRING(g_level_unexpected,

114: x_error_buffer => p_error_buffer);
115:
116: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
117: IF g_level_unexpected >= g_current_runtime_level THEN
118: FND_LOG.STRING(g_level_unexpected,
119: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
120: 'Incorrect return_status after calling '||
121: 'process_reference_tax_lines()');
122: FND_LOG.STRING(g_level_unexpected,

Line 122: FND_LOG.STRING(g_level_unexpected,

118: FND_LOG.STRING(g_level_unexpected,
119: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
120: 'Incorrect return_status after calling '||
121: 'process_reference_tax_lines()');
122: FND_LOG.STRING(g_level_unexpected,
123: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
124: 'RETURN_STATUS = ' || p_return_status);
125: FND_LOG.STRING(g_level_unexpected,
126: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

Line 125: FND_LOG.STRING(g_level_unexpected,

121: 'process_reference_tax_lines()');
122: FND_LOG.STRING(g_level_unexpected,
123: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
124: 'RETURN_STATUS = ' || p_return_status);
125: FND_LOG.STRING(g_level_unexpected,
126: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
127: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
128: END IF;
129: RETURN;

Line 144: -- FND_LOG.STRING(g_level_unexpected,

140: -- x_return_status => p_return_status);
141: --
142: -- IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
143: -- IF g_level_unexpected >= g_current_runtime_level THEN
144: -- FND_LOG.STRING(g_level_unexpected,
145: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
146: -- 'Incorrect return_status after calling '||
147: -- 'ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines()');
148: -- FND_LOG.STRING(g_level_unexpected,

Line 148: -- FND_LOG.STRING(g_level_unexpected,

144: -- FND_LOG.STRING(g_level_unexpected,
145: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
146: -- 'Incorrect return_status after calling '||
147: -- 'ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines()');
148: -- FND_LOG.STRING(g_level_unexpected,
149: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
150: -- 'RETURN_STATUS = ' || p_return_status);
151: -- FND_LOG.STRING(g_level_unexpected,
152: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

Line 151: -- FND_LOG.STRING(g_level_unexpected,

147: -- 'ZX_TDS_MRC_PROCESSING_PKG.create_mrc_det_tax_lines()');
148: -- FND_LOG.STRING(g_level_unexpected,
149: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
150: -- 'RETURN_STATUS = ' || p_return_status);
151: -- FND_LOG.STRING(g_level_unexpected,
152: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
153: -- 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
154: -- END IF;
155: -- RETURN;

Line 184: FND_LOG.STRING(g_level_unexpected,

180: x_error_buffer => p_error_buffer);
181:
182: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: IF g_level_unexpected >= g_current_runtime_level THEN
184: FND_LOG.STRING(g_level_unexpected,
185: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
186: 'Incorrect return_status after calling adjust_overapplication()');
187: FND_LOG.STRING(g_level_unexpected,
188: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

Line 187: FND_LOG.STRING(g_level_unexpected,

183: IF g_level_unexpected >= g_current_runtime_level THEN
184: FND_LOG.STRING(g_level_unexpected,
185: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
186: 'Incorrect return_status after calling adjust_overapplication()');
187: FND_LOG.STRING(g_level_unexpected,
188: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
189: 'RETURN_STATUS = ' || p_return_status);
190: FND_LOG.STRING(g_level_unexpected,
191: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

Line 190: FND_LOG.STRING(g_level_unexpected,

186: 'Incorrect return_status after calling adjust_overapplication()');
187: FND_LOG.STRING(g_level_unexpected,
188: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
189: 'RETURN_STATUS = ' || p_return_status);
190: FND_LOG.STRING(g_level_unexpected,
191: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
192: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
193: END IF;
194: RETURN;

Line 298: FND_LOG.STRING(g_level_unexpected,

294: p_error_buffer);
295:
296: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: IF g_level_unexpected >= g_current_runtime_level THEN
298: FND_LOG.STRING(g_level_unexpected,
299: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
300: 'Incorrect return_status after calling '||
301: 'ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines()');
302: FND_LOG.STRING(g_level_unexpected,

Line 302: FND_LOG.STRING(g_level_unexpected,

298: FND_LOG.STRING(g_level_unexpected,
299: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
300: 'Incorrect return_status after calling '||
301: 'ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines()');
302: FND_LOG.STRING(g_level_unexpected,
303: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
304: 'RETURN_STATUS = ' || p_return_status);
305: FND_LOG.STRING(g_level_unexpected,
306: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

Line 305: FND_LOG.STRING(g_level_unexpected,

301: 'ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines()');
302: FND_LOG.STRING(g_level_unexpected,
303: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
304: 'RETURN_STATUS = ' || p_return_status);
305: FND_LOG.STRING(g_level_unexpected,
306: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
307: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
308: END IF;
309: RETURN;

Line 332: FND_LOG.STRING(g_level_unexpected,

328: );
329: END IF;
330: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: IF g_level_unexpected >= g_current_runtime_level THEN
332: FND_LOG.STRING(g_level_unexpected,
333: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
334: 'Incorrect return_status after calling '||
335: 'populate_tax_line_numbers()');
336: FND_LOG.STRING(g_level_unexpected,

Line 336: FND_LOG.STRING(g_level_unexpected,

332: FND_LOG.STRING(g_level_unexpected,
333: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
334: 'Incorrect return_status after calling '||
335: 'populate_tax_line_numbers()');
336: FND_LOG.STRING(g_level_unexpected,
337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
338: 'RETURN_STATUS = ' || p_return_status);
339: FND_LOG.STRING(g_level_unexpected,
340: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

Line 339: FND_LOG.STRING(g_level_unexpected,

335: 'populate_tax_line_numbers()');
336: FND_LOG.STRING(g_level_unexpected,
337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
338: 'RETURN_STATUS = ' || p_return_status);
339: FND_LOG.STRING(g_level_unexpected,
340: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
341: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
342: END IF;
343: RETURN;

Line 369: FND_LOG.STRING(g_level_procedure,

365: END IF;
366:
367: IF (g_level_procedure >= g_current_runtime_level ) THEN
368:
369: FND_LOG.STRING(g_level_procedure,
370: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines.END',
371: 'ZX_TDS_TAX_LINES_DETM_PKG: determine_tax_lines(-)'||p_return_status);
372: END IF;
373:

Line 379: FND_LOG.STRING(g_level_unexpected,

375: WHEN OTHERS THEN
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
378: IF (g_level_unexpected >= g_current_runtime_level ) THEN
379: FND_LOG.STRING(g_level_unexpected,
380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines',
381: p_error_buffer);
382: END IF;
383:

Line 764: FND_LOG.STRING(g_level_statement,

760:
761: BEGIN
762:
763: IF (g_level_statement >= g_current_runtime_level ) THEN
764: FND_LOG.STRING(g_level_statement,
765: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.BEGIN',
766: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(+)');
767: END IF;
768:

Line 1149: FND_LOG.STRING(g_level_procedure,

1145: END IF;
1146:
1147: IF (g_level_procedure >= g_current_runtime_level ) THEN
1148:
1149: FND_LOG.STRING(g_level_procedure,
1150: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.END',
1151: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(-)'||p_return_status);
1152: END IF;
1153:

Line 1162: FND_LOG.STRING(g_level_unexpected,

1158: IF get_tax_line_csr%ISOPEN THEN
1159: CLOSE get_tax_line_csr;
1160: END IF;
1161: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1162: FND_LOG.STRING(g_level_unexpected,
1163: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines',
1164: p_error_buffer);
1165: END IF;
1166:

Line 1235: FND_LOG.STRING(g_level_statement,

1231: l_tax_line_number_tab num_tab_type;
1232: BEGIN
1233:
1234: IF (g_level_statement >= g_current_runtime_level ) THEN
1235: FND_LOG.STRING(g_level_statement,
1236: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.BEGIN',
1237: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(+)');
1238: END IF;
1239:

Line 1296: FND_LOG.STRING(g_level_statement,

1292: SET tax_line_number = l_tax_line_number_tab(i)
1293: WHERE tax_line_id = l_tax_line_id_tab(i);
1294:
1295: IF (g_level_statement >= g_current_runtime_level ) THEN
1296: FND_LOG.STRING(g_level_statement,
1297: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',
1298: 'After update the tax line numbers to the non-mrc tax lines '||
1299: 'in the zx_detail_tax_lines_gt');
1300: END IF;

Line 1326: FND_LOG.STRING(g_level_procedure,

1322: END LOOP;
1323: CLOSE get_tax_lines_csr;
1324:
1325: IF (g_level_procedure >= g_current_runtime_level ) THEN
1326: FND_LOG.STRING(g_level_procedure,
1327: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.END',
1328: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(-)');
1329: END IF;
1330:

Line 1336: FND_LOG.STRING(g_level_unexpected,

1332: WHEN OTHERS THEN
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1335: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1336: FND_LOG.STRING(g_level_unexpected,
1337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',
1338: x_error_buffer);
1339: END IF;
1340:

Line 1424: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1420: AND freeze_until_overridden_flag = 'Y';
1421:
1422: BEGIN
1423:
1424: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1425:
1426: IF (g_level_procedure >= g_current_runtime_level ) THEN
1427: FND_LOG.STRING(g_level_procedure,
1428: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.BEGIN',

Line 1427: FND_LOG.STRING(g_level_procedure,

1423:
1424: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1425:
1426: IF (g_level_procedure >= g_current_runtime_level ) THEN
1427: FND_LOG.STRING(g_level_procedure,
1428: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.BEGIN',
1429: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(+)');
1430: END IF;
1431:

Line 2083: FND_LOG.STRING(g_level_unexpected,

2079: x_error_buffer);
2080:
2081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2082: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2083: FND_LOG.STRING(g_level_unexpected,
2084: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2085: 'Incorrect return_status after calling ' ||
2086: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2087: FND_LOG.STRING(g_level_unexpected,

Line 2087: FND_LOG.STRING(g_level_unexpected,

2083: FND_LOG.STRING(g_level_unexpected,
2084: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2085: 'Incorrect return_status after calling ' ||
2086: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2087: FND_LOG.STRING(g_level_unexpected,
2088: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2089: 'RETURN_STATUS = ' || x_return_status);
2090: FND_LOG.STRING(g_level_unexpected,
2091: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

Line 2090: FND_LOG.STRING(g_level_unexpected,

2086: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2087: FND_LOG.STRING(g_level_unexpected,
2088: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2089: 'RETURN_STATUS = ' || x_return_status);
2090: FND_LOG.STRING(g_level_unexpected,
2091: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2092: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2093: END IF;
2094: RETURN;

Line 2111: FND_LOG.STRING(g_level_unexpected,

2107: x_error_buffer);
2108:
2109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2110: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2111: FND_LOG.STRING(g_level_unexpected,
2112: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2113: 'Incorrect return_status after calling ' ||
2114: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2115: FND_LOG.STRING(g_level_unexpected,

Line 2115: FND_LOG.STRING(g_level_unexpected,

2111: FND_LOG.STRING(g_level_unexpected,
2112: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2113: 'Incorrect return_status after calling ' ||
2114: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2115: FND_LOG.STRING(g_level_unexpected,
2116: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2117: 'RETURN_STATUS = ' || x_return_status);
2118: FND_LOG.STRING(g_level_unexpected,
2119: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

Line 2118: FND_LOG.STRING(g_level_unexpected,

2114: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2115: FND_LOG.STRING(g_level_unexpected,
2116: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2117: 'RETURN_STATUS = ' || x_return_status);
2118: FND_LOG.STRING(g_level_unexpected,
2119: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2120: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2121: END IF;
2122: RETURN;

Line 2139: FND_LOG.STRING(g_level_unexpected,

2135: x_error_buffer);
2136:
2137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2138: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2139: FND_LOG.STRING(g_level_unexpected,
2140: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2141: 'Incorrect return_status after calling ' ||
2142: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2143: FND_LOG.STRING(g_level_unexpected,

Line 2143: FND_LOG.STRING(g_level_unexpected,

2139: FND_LOG.STRING(g_level_unexpected,
2140: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2141: 'Incorrect return_status after calling ' ||
2142: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2143: FND_LOG.STRING(g_level_unexpected,
2144: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2145: 'RETURN_STATUS = ' || x_return_status);
2146: FND_LOG.STRING(g_level_unexpected,
2147: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

Line 2146: FND_LOG.STRING(g_level_unexpected,

2142: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2143: FND_LOG.STRING(g_level_unexpected,
2144: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2145: 'RETURN_STATUS = ' || x_return_status);
2146: FND_LOG.STRING(g_level_unexpected,
2147: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2148: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2149: END IF;
2150: RETURN;

Line 2170: FND_LOG.STRING(g_level_unexpected,

2166: x_error_buffer);
2167:
2168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2169: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2170: FND_LOG.STRING(g_level_unexpected,
2171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2172: 'Incorrect return_status after calling ' ||
2173: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2174: FND_LOG.STRING(g_level_unexpected,

Line 2174: FND_LOG.STRING(g_level_unexpected,

2170: FND_LOG.STRING(g_level_unexpected,
2171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2172: 'Incorrect return_status after calling ' ||
2173: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2174: FND_LOG.STRING(g_level_unexpected,
2175: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2176: 'RETURN_STATUS = ' || x_return_status);
2177: FND_LOG.STRING(g_level_unexpected,
2178: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

Line 2177: FND_LOG.STRING(g_level_unexpected,

2173: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2174: FND_LOG.STRING(g_level_unexpected,
2175: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2176: 'RETURN_STATUS = ' || x_return_status);
2177: FND_LOG.STRING(g_level_unexpected,
2178: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2179: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2180: END IF;
2181: RETURN;

Line 2202: FND_LOG.STRING(g_level_unexpected,

2198: x_error_buffer);
2199:
2200: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2201: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2202: FND_LOG.STRING(g_level_unexpected,
2203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2204: 'Incorrect return_status after calling ' ||
2205: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2206: FND_LOG.STRING(g_level_unexpected,

Line 2206: FND_LOG.STRING(g_level_unexpected,

2202: FND_LOG.STRING(g_level_unexpected,
2203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2204: 'Incorrect return_status after calling ' ||
2205: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2206: FND_LOG.STRING(g_level_unexpected,
2207: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2208: 'RETURN_STATUS = ' || x_return_status);
2209: FND_LOG.STRING(g_level_unexpected,
2210: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

Line 2209: FND_LOG.STRING(g_level_unexpected,

2205: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2206: FND_LOG.STRING(g_level_unexpected,
2207: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2208: 'RETURN_STATUS = ' || x_return_status);
2209: FND_LOG.STRING(g_level_unexpected,
2210: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2211: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2212: END IF;
2213: RETURN;

Line 2237: FND_LOG.STRING(g_level_procedure,

2233: CLOSE get_tax_info_csr;
2234:
2235: IF (g_level_procedure >= g_current_runtime_level ) THEN
2236:
2237: FND_LOG.STRING(g_level_procedure,
2238: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2239: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(-)'||x_return_status);
2240: END IF;
2241:

Line 2247: FND_LOG.STRING(g_level_unexpected,

2243: WHEN OTHERS THEN
2244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2245: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2246: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2247: FND_LOG.STRING(g_level_unexpected,
2248: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2249: x_error_buffer);
2250: END IF;
2251:

Line 2334: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2330: AND T.tax_provider_id IS NULL;
2331:
2332: BEGIN
2333:
2334: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2335:
2336: IF (g_level_procedure >= g_current_runtime_level ) THEN
2337: FND_LOG.STRING(g_level_procedure,
2338: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.BEGIN',

Line 2337: FND_LOG.STRING(g_level_procedure,

2333:
2334: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2335:
2336: IF (g_level_procedure >= g_current_runtime_level ) THEN
2337: FND_LOG.STRING(g_level_procedure,
2338: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.BEGIN',
2339: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(+)');
2340: END IF;
2341:

Line 3379: FND_LOG.STRING(g_level_unexpected,

3375: x_error_buffer);
3376:
3377: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3378: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3379: FND_LOG.STRING(g_level_unexpected,
3380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3381: 'Incorrect return_status after calling ' ||
3382: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
3383: FND_LOG.STRING(g_level_unexpected,

Line 3383: FND_LOG.STRING(g_level_unexpected,

3379: FND_LOG.STRING(g_level_unexpected,
3380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3381: 'Incorrect return_status after calling ' ||
3382: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
3383: FND_LOG.STRING(g_level_unexpected,
3384: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3385: 'RETURN_STATUS = ' || x_return_status);
3386: FND_LOG.STRING(g_level_unexpected,
3387: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

Line 3386: FND_LOG.STRING(g_level_unexpected,

3382: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
3383: FND_LOG.STRING(g_level_unexpected,
3384: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3385: 'RETURN_STATUS = ' || x_return_status);
3386: FND_LOG.STRING(g_level_unexpected,
3387: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
3388: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
3389: END IF;
3390: RETURN;

Line 3407: FND_LOG.STRING(g_level_unexpected,

3403: x_error_buffer);
3404:
3405: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3406: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3407: FND_LOG.STRING(g_level_unexpected,
3408: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3409: 'Incorrect return_status after calling ' ||
3410: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
3411: FND_LOG.STRING(g_level_unexpected,

Line 3411: FND_LOG.STRING(g_level_unexpected,

3407: FND_LOG.STRING(g_level_unexpected,
3408: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3409: 'Incorrect return_status after calling ' ||
3410: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
3411: FND_LOG.STRING(g_level_unexpected,
3412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3413: 'RETURN_STATUS = ' || x_return_status);
3414: FND_LOG.STRING(g_level_unexpected,
3415: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

Line 3414: FND_LOG.STRING(g_level_unexpected,

3410: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
3411: FND_LOG.STRING(g_level_unexpected,
3412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3413: 'RETURN_STATUS = ' || x_return_status);
3414: FND_LOG.STRING(g_level_unexpected,
3415: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
3416: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
3417: END IF;
3418: RETURN;

Line 3435: FND_LOG.STRING(g_level_unexpected,

3431: x_error_buffer);
3432:
3433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3434: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3435: FND_LOG.STRING(g_level_unexpected,
3436: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3437: 'Incorrect return_status after calling ' ||
3438: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
3439: FND_LOG.STRING(g_level_unexpected,

Line 3439: FND_LOG.STRING(g_level_unexpected,

3435: FND_LOG.STRING(g_level_unexpected,
3436: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3437: 'Incorrect return_status after calling ' ||
3438: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
3439: FND_LOG.STRING(g_level_unexpected,
3440: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3441: 'RETURN_STATUS = ' || x_return_status);
3442: FND_LOG.STRING(g_level_unexpected,
3443: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

Line 3442: FND_LOG.STRING(g_level_unexpected,

3438: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
3439: FND_LOG.STRING(g_level_unexpected,
3440: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3441: 'RETURN_STATUS = ' || x_return_status);
3442: FND_LOG.STRING(g_level_unexpected,
3443: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
3444: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
3445: END IF;
3446: RETURN;

Line 3469: FND_LOG.STRING(g_level_unexpected,

3465: x_error_buffer);
3466:
3467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3468: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3469: FND_LOG.STRING(g_level_unexpected,
3470: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3471: 'Incorrect return_status after calling ' ||
3472: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
3473: FND_LOG.STRING(g_level_unexpected,

Line 3473: FND_LOG.STRING(g_level_unexpected,

3469: FND_LOG.STRING(g_level_unexpected,
3470: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3471: 'Incorrect return_status after calling ' ||
3472: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
3473: FND_LOG.STRING(g_level_unexpected,
3474: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3475: 'RETURN_STATUS = ' || x_return_status);
3476: FND_LOG.STRING(g_level_unexpected,
3477: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

Line 3476: FND_LOG.STRING(g_level_unexpected,

3472: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
3473: FND_LOG.STRING(g_level_unexpected,
3474: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3475: 'RETURN_STATUS = ' || x_return_status);
3476: FND_LOG.STRING(g_level_unexpected,
3477: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
3478: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
3479: END IF;
3480: RETURN;

Line 3501: FND_LOG.STRING(g_level_unexpected,

3497: x_error_buffer);
3498:
3499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3500: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3501: FND_LOG.STRING(g_level_unexpected,
3502: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3503: 'Incorrect return_status after calling ' ||
3504: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
3505: FND_LOG.STRING(g_level_unexpected,

Line 3505: FND_LOG.STRING(g_level_unexpected,

3501: FND_LOG.STRING(g_level_unexpected,
3502: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3503: 'Incorrect return_status after calling ' ||
3504: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
3505: FND_LOG.STRING(g_level_unexpected,
3506: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3507: 'RETURN_STATUS = ' || x_return_status);
3508: FND_LOG.STRING(g_level_unexpected,
3509: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

Line 3508: FND_LOG.STRING(g_level_unexpected,

3504: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
3505: FND_LOG.STRING(g_level_unexpected,
3506: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3507: 'RETURN_STATUS = ' || x_return_status);
3508: FND_LOG.STRING(g_level_unexpected,
3509: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
3510: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
3511: END IF;
3512: RETURN;

Line 3534: FND_LOG.STRING(g_level_procedure,

3530: END LOOP;
3531: CLOSE get_tax_info_csr;
3532:
3533: IF (g_level_procedure >= g_current_runtime_level ) THEN
3534: FND_LOG.STRING(g_level_procedure,
3535: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3536: 'p_return_status = ' || x_return_status);
3537: FND_LOG.STRING(g_level_procedure,
3538: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 3537: FND_LOG.STRING(g_level_procedure,

3533: IF (g_level_procedure >= g_current_runtime_level ) THEN
3534: FND_LOG.STRING(g_level_procedure,
3535: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3536: 'p_return_status = ' || x_return_status);
3537: FND_LOG.STRING(g_level_procedure,
3538: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3539: 'p_error_buffer = ' || x_error_buffer);
3540: FND_LOG.STRING(g_level_procedure,
3541: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

Line 3540: FND_LOG.STRING(g_level_procedure,

3536: 'p_return_status = ' || x_return_status);
3537: FND_LOG.STRING(g_level_procedure,
3538: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3539: 'p_error_buffer = ' || x_error_buffer);
3540: FND_LOG.STRING(g_level_procedure,
3541: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
3542: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(-)');
3543: END IF;
3544:

Line 3550: FND_LOG.STRING(g_level_unexpected,

3546: WHEN OTHERS THEN
3547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3548: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3549: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3550: FND_LOG.STRING(g_level_unexpected,
3551: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3552: x_error_buffer);
3553: END IF;
3554:

Line 3655: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3651: l_orig_tax_amt_tbl num_tbl_type;
3652: l_orig_line_amt_tbl num_tbl_type;
3653:
3654: BEGIN
3655: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3656:
3657: IF (g_level_procedure >= g_current_runtime_level ) THEN
3658: FND_LOG.STRING(g_level_procedure,
3659: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN',

Line 3658: FND_LOG.STRING(g_level_procedure,

3654: BEGIN
3655: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3656:
3657: IF (g_level_procedure >= g_current_runtime_level ) THEN
3658: FND_LOG.STRING(g_level_procedure,
3659: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN',
3660: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(+)');
3661: END IF;
3662:

Line 3671: -- FND_LOG.STRING(g_level_statement,

3667: -- OR p_event_class_rec.CTRL_TOTAL_LINE_TX_AMT_FLG = 'Y'
3668: --THEN
3669: -- IF (g_level_statement >= g_current_runtime_level ) THEN
3670: --
3671: -- FND_LOG.STRING(g_level_statement,
3672: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',
3673: -- 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)'||' do not check for historical trx');
3674: -- END IF;
3675: -- RETURN;

Line 3734: FND_LOG.STRING(g_level_procedure,

3730: AND tax_line_id = l_tax_line_id_tbl(i)
3731: AND NVL(reporting_currency_code, -99) = NVL(l_rpt_currency_code_tbl(i), -99);
3732:
3733: IF (g_level_procedure >= g_current_runtime_level ) THEN
3734: FND_LOG.STRING(g_level_procedure,
3735: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',
3736: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)');
3737: END IF;
3738:

Line 3745: FND_LOG.STRING(g_level_unexpected,

3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3742: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3743:
3744: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3745: FND_LOG.STRING(g_level_unexpected,
3746: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication',
3747: x_error_buffer);
3748: END IF;
3749:

Line 3796: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3792: AND L.cancel_flag <> 'Y';
3793:
3794: BEGIN
3795:
3796: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3797:
3798: IF (g_level_procedure >= g_current_runtime_level ) THEN
3799: FND_LOG.STRING(g_level_procedure,
3800: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',

Line 3799: FND_LOG.STRING(g_level_procedure,

3795:
3796: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3797:
3798: IF (g_level_procedure >= g_current_runtime_level ) THEN
3799: FND_LOG.STRING(g_level_procedure,
3800: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',
3801: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(+)');
3802: END IF;
3803:

Line 3827: FND_LOG.STRING(g_level_procedure,

3823: VALUES l_detail_tax_lines_tbl(l_tax_ln_index);
3824:
3825:
3826: IF (g_level_procedure >= g_current_runtime_level ) THEN
3827: FND_LOG.STRING(g_level_procedure,
3828: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',
3829: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(-)');
3830: END IF;
3831:

Line 3838: FND_LOG.STRING(g_level_unexpected,

3834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3835: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3836:
3837: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3838: FND_LOG.STRING(g_level_unexpected,
3839: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines',
3840: x_error_buffer);
3841: END IF;
3842:

Line 3870: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3866: l_row_count NUMBER;
3867:
3868: BEGIN
3869:
3870: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3871:
3872: IF (g_level_procedure >= g_current_runtime_level ) THEN
3873: FND_LOG.STRING(g_level_procedure,
3874: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.BEGIN',

Line 3873: FND_LOG.STRING(g_level_procedure,

3869:
3870: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3871:
3872: IF (g_level_procedure >= g_current_runtime_level ) THEN
3873: FND_LOG.STRING(g_level_procedure,
3874: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.BEGIN',
3875: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(+)');
3876: END IF;
3877:

Line 3898: FND_LOG.STRING(g_level_statement,

3894:
3895: l_row_count := SQL%ROWCOUNT;
3896:
3897: IF (g_level_statement >= g_current_runtime_level ) THEN
3898: FND_LOG.STRING(g_level_statement,
3899: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.set_acct_source_tax_rate_id',
3900: ' number of rows inserted = ' || l_row_count);
3901: END IF;
3902:

Line 3904: FND_LOG.STRING(g_level_procedure,

3900: ' number of rows inserted = ' || l_row_count);
3901: END IF;
3902:
3903: IF (g_level_procedure >= g_current_runtime_level ) THEN
3904: FND_LOG.STRING(g_level_procedure,
3905: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.END',
3906: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(-)');
3907: END IF;
3908:

Line 3915: FND_LOG.STRING(g_level_unexpected,

3911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3912: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3913:
3914: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3915: FND_LOG.STRING(g_level_unexpected,
3916: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id',
3917: x_error_buffer);
3918: END IF;
3919: