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 ZX_TDS_TAX_LINES_DETM_PKG

Line 1: package body ZX_TDS_TAX_LINES_DETM_PKG as

1: package body ZX_TDS_TAX_LINES_DETM_PKG as
2: /* $Header: zxditaxlndetpkgb.pls 120.91.12010000.3 2008/12/04 01:43:14 hongliu ship $ */
3:
4: -- private procedures
5: PROCEDURE create_offset_tax_lines(

Line 70: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines.BEGIN',

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:
74: --

Line 71: 'ZX_TDS_TAX_LINES_DETM_PKG: determine_tax_lines(+)');

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:
74: --
75: -- init error buffer and return status

Line 94: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
98: 'RETURN_STATUS = ' || p_return_status);

Line 97: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
101: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

Line 100: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

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;
104: END IF;

Line 101: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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;
104: END IF;
105: END IF;

Line 119: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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,
123: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

Line 123: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
127: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

Line 126: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

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;
130: END IF;

Line 127: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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;
130: END IF;
131: END IF;

Line 145: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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,
149: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

Line 149: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
153: -- 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

Line 152: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

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;
156: -- END IF;

Line 153: -- 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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;
156: -- END IF;
157: -- END IF;

Line 185: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
189: 'RETURN_STATUS = ' || p_return_status);

Line 188: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
192: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

Line 191: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

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;
195: END IF;

Line 192: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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;
195: END IF;
196: END IF;

Line 299: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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,
303: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

Line 303: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
307: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

Line 306: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

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;
310: END IF;

Line 307: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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;
310: END IF;
311:

Line 333: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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,
337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

Line 337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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',
341: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

Line 340: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

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;
344: END IF;

Line 341: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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;
344: END IF;
345:

Line 370: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines.END',

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:
374: EXCEPTION

Line 371: 'ZX_TDS_TAX_LINES_DETM_PKG: determine_tax_lines(-)'||p_return_status);

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:
374: EXCEPTION
375: WHEN OTHERS THEN

Line 380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines',

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:
384: END determine_tax_lines;

Line 765: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.BEGIN',

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:
769: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 766: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(+)');

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:
769: p_return_status := FND_API.G_RET_STS_SUCCESS;
770:

Line 1150: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.END',

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:
1154: EXCEPTION

Line 1151: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(-)'||p_return_status);

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:
1154: EXCEPTION
1155: WHEN OTHERS THEN

Line 1163: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines',

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:
1167: END create_offset_tax_lines;

Line 1236: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.BEGIN',

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:
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1237: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(+)');

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:
1240: x_return_status := FND_API.G_RET_STS_SUCCESS;
1241:

Line 1297: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',

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;
1301:

Line 1327: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.END',

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:
1331: EXCEPTION

Line 1328: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(-)');

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:
1331: EXCEPTION
1332: WHEN OTHERS THEN

Line 1337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',

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:
1341: END populate_tax_line_numbers;

Line 1353: -- ZX_TDS_TAX_LINES_DETM_PKG

1349: -- applicable into detail tax lines global temp table and reset
1350: -- the unrounded amounts.
1351: --
1352: -- CALLED BY
1353: -- ZX_TDS_TAX_LINES_DETM_PKG
1354: --
1355: -- HISTORY
1356: -- Ling Zhang Aug-06-2004 Created for bug fix 3391186
1357: --

Line 1428: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.BEGIN',

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:
1432: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1429: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(+)');

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:
1432: x_return_status := FND_API.G_RET_STS_SUCCESS;
1433:

Line 2084: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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,
2088: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

Line 2088: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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',
2092: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

Line 2091: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

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;
2095: END IF;

Line 2092: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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;
2095: END IF;
2096:

Line 2112: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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,
2116: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

Line 2116: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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',
2120: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

Line 2119: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

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;
2123: END IF;

Line 2120: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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;
2123: END IF;
2124:

Line 2140: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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,
2144: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

Line 2144: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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',
2148: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

Line 2147: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

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;
2151: END IF;

Line 2148: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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;
2151: END IF;
2152:

Line 2171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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,
2175: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

Line 2175: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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',
2179: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

Line 2178: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

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;
2182: END IF;

Line 2179: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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;
2182: END IF;
2183:

Line 2203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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,
2207: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

Line 2207: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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',
2211: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

Line 2210: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

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;
2214: END IF;

Line 2211: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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;
2214: END IF;
2215:

Line 2238: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',

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:
2242: EXCEPTION

Line 2239: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(-)'||x_return_status);

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:
2242: EXCEPTION
2243: WHEN OTHERS THEN

Line 2248: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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:
2252: END process_reference_tax_lines;

Line 2338: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.BEGIN',

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:
2342: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2339: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(+)');

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:
2342: x_return_status := FND_API.G_RET_STS_SUCCESS;
2343:

Line 3380: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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,
3384: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 3384: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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',
3388: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

Line 3387: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

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;
3391: END IF;

Line 3388: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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;
3391: END IF;
3392:

Line 3408: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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,
3412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 3412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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',
3416: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

Line 3415: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

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;
3419: END IF;

Line 3416: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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;
3419: END IF;
3420:

Line 3436: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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,
3440: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 3440: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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',
3444: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

Line 3443: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

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;
3447: END IF;

Line 3444: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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;
3447: END IF;
3448:

Line 3470: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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,
3474: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 3474: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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',
3478: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

Line 3477: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

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;
3481: END IF;

Line 3478: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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;
3481: END IF;
3482:

Line 3502: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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,
3506: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

Line 3506: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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',
3510: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

Line 3509: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

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;
3513: END IF;

Line 3510: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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;
3513: END IF;
3514:

Line 3535: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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',
3539: 'p_error_buffer = ' || x_error_buffer);

Line 3538: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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',
3542: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(-)');

Line 3541: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

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:
3545: EXCEPTION

Line 3542: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(-)');

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:
3545: EXCEPTION
3546: WHEN OTHERS THEN

Line 3551: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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:
3555: END process_copy_and_create;

Line 3659: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.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:
3663: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3660: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(+)');

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:
3663: x_return_status := FND_API.G_RET_STS_SUCCESS;
3664:

Line 3672: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',

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;
3676: --END IF;

Line 3673: -- 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)'||' do not check for historical trx');

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;
3676: --END IF;
3677:

Line 3735: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',

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:
3739: EXCEPTION

Line 3736: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)');

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:
3739: EXCEPTION
3740: WHEN OTHERS THEN

Line 3746: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication',

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:
3750: END adjust_overapplication;

Line 3800: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',

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:
3804: l_tax_index := 1;

Line 3801: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(+)');

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:
3804: l_tax_index := 1;
3805: FOR tax_rec IN c_tx_ln_for_unchanged_trx_ln LOOP

Line 3828: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',

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:
3832: EXCEPTION

Line 3829: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(-)');

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:
3832: EXCEPTION
3833: WHEN OTHERS THEN

Line 3839: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines',

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:
3843: END process_unchanged_trx_lines;

Line 3874: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.BEGIN',

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:
3878: UPDATE zx_detail_tax_lines_gt gt1

Line 3875: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(+)');

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:
3878: UPDATE zx_detail_tax_lines_gt gt1
3879: SET account_source_tax_rate_id =

Line 3905: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.END',

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:
3909: EXCEPTION

Line 3906: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(-)');

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:
3909: EXCEPTION
3910: WHEN OTHERS THEN

Line 3916: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id',

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:
3920: END set_acct_source_tax_rate_id;

Line 3922: END ZX_TDS_TAX_LINES_DETM_PKG;

3918: END IF;
3919:
3920: END set_acct_source_tax_rate_id;
3921:
3922: END ZX_TDS_TAX_LINES_DETM_PKG;