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.114.12020000.3 2012/07/30 08:34:28 smuthusa noship $ */
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 192: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

188:
189: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
190: IF g_level_unexpected >= g_current_runtime_level THEN
191: FND_LOG.STRING(g_level_unexpected,
192: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
193: 'Incorrect return_status after calling adjust_overapplication()');
194: FND_LOG.STRING(g_level_unexpected,
195: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
196: 'RETURN_STATUS = ' || p_return_status);

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

191: FND_LOG.STRING(g_level_unexpected,
192: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
193: 'Incorrect return_status after calling adjust_overapplication()');
194: FND_LOG.STRING(g_level_unexpected,
195: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
196: 'RETURN_STATUS = ' || p_return_status);
197: FND_LOG.STRING(g_level_unexpected,
198: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
199: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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

194: FND_LOG.STRING(g_level_unexpected,
195: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
196: 'RETURN_STATUS = ' || p_return_status);
197: FND_LOG.STRING(g_level_unexpected,
198: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
199: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
200: END IF;
201: RETURN;
202: END IF;

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

195: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
196: 'RETURN_STATUS = ' || p_return_status);
197: FND_LOG.STRING(g_level_unexpected,
198: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
199: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
200: END IF;
201: RETURN;
202: END IF;
203: END IF;

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

306:
307: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: IF g_level_unexpected >= g_current_runtime_level THEN
309: FND_LOG.STRING(g_level_unexpected,
310: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
311: 'Incorrect return_status after calling '||
312: 'ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines()');
313: FND_LOG.STRING(g_level_unexpected,
314: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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

310: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
311: 'Incorrect return_status after calling '||
312: 'ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines()');
313: FND_LOG.STRING(g_level_unexpected,
314: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
315: 'RETURN_STATUS = ' || p_return_status);
316: FND_LOG.STRING(g_level_unexpected,
317: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
318: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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

313: FND_LOG.STRING(g_level_unexpected,
314: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
315: 'RETURN_STATUS = ' || p_return_status);
316: FND_LOG.STRING(g_level_unexpected,
317: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
318: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
319: END IF;
320: RETURN;
321: END IF;

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

314: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
315: 'RETURN_STATUS = ' || p_return_status);
316: FND_LOG.STRING(g_level_unexpected,
317: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
318: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
319: END IF;
320: RETURN;
321: END IF;
322:

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

340: END IF;
341: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
342: IF g_level_unexpected >= g_current_runtime_level THEN
343: FND_LOG.STRING(g_level_unexpected,
344: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
345: 'Incorrect return_status after calling '||
346: 'populate_tax_line_numbers()');
347: FND_LOG.STRING(g_level_unexpected,
348: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',

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

344: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
345: 'Incorrect return_status after calling '||
346: 'populate_tax_line_numbers()');
347: FND_LOG.STRING(g_level_unexpected,
348: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
349: 'RETURN_STATUS = ' || p_return_status);
350: FND_LOG.STRING(g_level_unexpected,
351: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
352: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');

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

347: FND_LOG.STRING(g_level_unexpected,
348: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
349: 'RETURN_STATUS = ' || p_return_status);
350: FND_LOG.STRING(g_level_unexpected,
351: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
352: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
353: END IF;
354: RETURN;
355: END IF;

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

348: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination',
349: 'RETURN_STATUS = ' || p_return_status);
350: FND_LOG.STRING(g_level_unexpected,
351: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',
352: 'ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination(-)');
353: END IF;
354: RETURN;
355: END IF;
356:

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

377:
378: IF (g_level_procedure >= g_current_runtime_level ) THEN
379:
380: FND_LOG.STRING(g_level_procedure,
381: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines.END',
382: 'ZX_TDS_TAX_LINES_DETM_PKG: determine_tax_lines(-)'||p_return_status);
383: END IF;
384:
385: EXCEPTION

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

378: IF (g_level_procedure >= g_current_runtime_level ) THEN
379:
380: FND_LOG.STRING(g_level_procedure,
381: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines.END',
382: 'ZX_TDS_TAX_LINES_DETM_PKG: determine_tax_lines(-)'||p_return_status);
383: END IF;
384:
385: EXCEPTION
386: WHEN OTHERS THEN

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

387: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
389: IF (g_level_unexpected >= g_current_runtime_level ) THEN
390: FND_LOG.STRING(g_level_unexpected,
391: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.determine_tax_lines',
392: p_error_buffer);
393: END IF;
394:
395: END determine_tax_lines;

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

777: BEGIN
778:
779: IF (g_level_statement >= g_current_runtime_level ) THEN
780: FND_LOG.STRING(g_level_statement,
781: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.BEGIN',
782: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(+)');
783: END IF;
784:
785: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

778:
779: IF (g_level_statement >= g_current_runtime_level ) THEN
780: FND_LOG.STRING(g_level_statement,
781: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.BEGIN',
782: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(+)');
783: END IF;
784:
785: p_return_status := FND_API.G_RET_STS_SUCCESS;
786:

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

1174:
1175: IF (g_level_procedure >= g_current_runtime_level ) THEN
1176:
1177: FND_LOG.STRING(g_level_procedure,
1178: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.END',
1179: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(-)'||p_return_status);
1180: END IF;
1181:
1182: EXCEPTION

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

1175: IF (g_level_procedure >= g_current_runtime_level ) THEN
1176:
1177: FND_LOG.STRING(g_level_procedure,
1178: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines.END',
1179: 'ZX_TDS_TAX_LINES_DETM_PKG: create_offset_tax_lines(-)'||p_return_status);
1180: END IF;
1181:
1182: EXCEPTION
1183: WHEN OTHERS THEN

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

1187: CLOSE get_tax_line_csr;
1188: END IF;
1189: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1190: FND_LOG.STRING(g_level_unexpected,
1191: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.create_offset_tax_lines',
1192: p_error_buffer);
1193: END IF;
1194:
1195: END create_offset_tax_lines;

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

1260: BEGIN
1261:
1262: IF (g_level_statement >= g_current_runtime_level ) THEN
1263: FND_LOG.STRING(g_level_statement,
1264: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.BEGIN',
1265: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(+)');
1266: END IF;
1267:
1268: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1261:
1262: IF (g_level_statement >= g_current_runtime_level ) THEN
1263: FND_LOG.STRING(g_level_statement,
1264: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.BEGIN',
1265: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(+)');
1266: END IF;
1267:
1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:

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

1321: WHERE tax_line_id = l_tax_line_id_tab(i);
1322:
1323: IF (g_level_statement >= g_current_runtime_level ) THEN
1324: FND_LOG.STRING(g_level_statement,
1325: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',
1326: 'After update the tax line numbers to the non-mrc tax lines '||
1327: 'in the zx_detail_tax_lines_gt');
1328: END IF;
1329:

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

1351: CLOSE get_tax_lines_csr;
1352:
1353: IF (g_level_procedure >= g_current_runtime_level ) THEN
1354: FND_LOG.STRING(g_level_procedure,
1355: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.END',
1356: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(-)');
1357: END IF;
1358:
1359: EXCEPTION

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

1352:
1353: IF (g_level_procedure >= g_current_runtime_level ) THEN
1354: FND_LOG.STRING(g_level_procedure,
1355: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers.END',
1356: 'ZX_TDS_TAX_LINES_DETM_PKG: populate_tax_line_numbers(-)');
1357: END IF;
1358:
1359: EXCEPTION
1360: WHEN OTHERS THEN

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

1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1363: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1364: FND_LOG.STRING(g_level_unexpected,
1365: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.populate_tax_line_numbers',
1366: x_error_buffer);
1367: END IF;
1368:
1369: END populate_tax_line_numbers;

Line 1381: -- ZX_TDS_TAX_LINES_DETM_PKG

1377: -- applicable into detail tax lines global temp table and reset
1378: -- the unrounded amounts.
1379: --
1380: -- CALLED BY
1381: -- ZX_TDS_TAX_LINES_DETM_PKG
1382: --
1383: -- HISTORY
1384: -- Ling Zhang Aug-06-2004 Created for bug fix 3391186
1385: --

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

1452: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1453:
1454: IF (g_level_procedure >= g_current_runtime_level ) THEN
1455: FND_LOG.STRING(g_level_procedure,
1456: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.BEGIN',
1457: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(+)');
1458: END IF;
1459:
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1453:
1454: IF (g_level_procedure >= g_current_runtime_level ) THEN
1455: FND_LOG.STRING(g_level_procedure,
1456: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.BEGIN',
1457: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(+)');
1458: END IF;
1459:
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;
1461:

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

1510: AND L.mrc_tax_line_flag = 'N');
1511:
1512: IF (g_level_statement >= g_current_runtime_level ) THEN
1513: FND_LOG.STRING(g_level_statement,
1514: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
1515: 'Number of Rows Updated: ' || SQL%ROWCOUNT);
1516: END IF;
1517: END IF;
1518:

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

2072: );
2073:
2074: IF (g_level_statement >= g_current_runtime_level ) THEN
2075: FND_LOG.STRING(g_level_statement,
2076: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2077: '1 : Number of Rows Inserted: ' || SQL%ROWCOUNT);
2078: END IF;
2079:
2080: -- retrieve the self assessed and canceled reference tax lines for current trx

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

2643: );
2644:
2645: IF (g_level_statement >= g_current_runtime_level ) THEN
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2648: '2 : Number of Rows Inserted: ' || SQL%ROWCOUNT);
2649: END IF;
2650:
2651: OPEN get_tax_info_csr;

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

2693:
2694: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2695: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2696: FND_LOG.STRING(g_level_unexpected,
2697: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2698: 'Incorrect return_status after calling ' ||
2699: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2700: FND_LOG.STRING(g_level_unexpected,
2701: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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

2697: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2698: 'Incorrect return_status after calling ' ||
2699: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2700: FND_LOG.STRING(g_level_unexpected,
2701: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2702: 'RETURN_STATUS = ' || x_return_status);
2703: FND_LOG.STRING(g_level_unexpected,
2704: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2705: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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

2700: FND_LOG.STRING(g_level_unexpected,
2701: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2702: 'RETURN_STATUS = ' || x_return_status);
2703: FND_LOG.STRING(g_level_unexpected,
2704: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2705: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2706: END IF;
2707: RETURN;
2708: END IF;

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

2701: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2702: 'RETURN_STATUS = ' || x_return_status);
2703: FND_LOG.STRING(g_level_unexpected,
2704: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2705: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2706: END IF;
2707: RETURN;
2708: END IF;
2709:

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

2721:
2722: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2723: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2724: FND_LOG.STRING(g_level_unexpected,
2725: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2726: 'Incorrect return_status after calling ' ||
2727: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2728: FND_LOG.STRING(g_level_unexpected,
2729: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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

2725: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2726: 'Incorrect return_status after calling ' ||
2727: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2728: FND_LOG.STRING(g_level_unexpected,
2729: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2730: 'RETURN_STATUS = ' || x_return_status);
2731: FND_LOG.STRING(g_level_unexpected,
2732: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2733: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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

2728: FND_LOG.STRING(g_level_unexpected,
2729: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2730: 'RETURN_STATUS = ' || x_return_status);
2731: FND_LOG.STRING(g_level_unexpected,
2732: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2733: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2734: END IF;
2735: RETURN;
2736: END IF;

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

2729: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2730: 'RETURN_STATUS = ' || x_return_status);
2731: FND_LOG.STRING(g_level_unexpected,
2732: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2733: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2734: END IF;
2735: RETURN;
2736: END IF;
2737:

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

2749:
2750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2751: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2752: FND_LOG.STRING(g_level_unexpected,
2753: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2754: 'Incorrect return_status after calling ' ||
2755: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2756: FND_LOG.STRING(g_level_unexpected,
2757: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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

2753: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2754: 'Incorrect return_status after calling ' ||
2755: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
2756: FND_LOG.STRING(g_level_unexpected,
2757: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2758: 'RETURN_STATUS = ' || x_return_status);
2759: FND_LOG.STRING(g_level_unexpected,
2760: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2761: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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

2756: FND_LOG.STRING(g_level_unexpected,
2757: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2758: 'RETURN_STATUS = ' || x_return_status);
2759: FND_LOG.STRING(g_level_unexpected,
2760: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2761: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2762: END IF;
2763: RETURN;
2764: END IF;

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

2757: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2758: 'RETURN_STATUS = ' || x_return_status);
2759: FND_LOG.STRING(g_level_unexpected,
2760: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2761: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2762: END IF;
2763: RETURN;
2764: END IF;
2765:

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

2780:
2781: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2782: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2783: FND_LOG.STRING(g_level_unexpected,
2784: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2785: 'Incorrect return_status after calling ' ||
2786: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2787: FND_LOG.STRING(g_level_unexpected,
2788: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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

2784: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2785: 'Incorrect return_status after calling ' ||
2786: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2787: FND_LOG.STRING(g_level_unexpected,
2788: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2789: 'RETURN_STATUS = ' || x_return_status);
2790: FND_LOG.STRING(g_level_unexpected,
2791: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2792: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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

2787: FND_LOG.STRING(g_level_unexpected,
2788: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2789: 'RETURN_STATUS = ' || x_return_status);
2790: FND_LOG.STRING(g_level_unexpected,
2791: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2792: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2793: END IF;
2794: RETURN;
2795: END IF;

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

2788: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2789: 'RETURN_STATUS = ' || x_return_status);
2790: FND_LOG.STRING(g_level_unexpected,
2791: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2792: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2793: END IF;
2794: RETURN;
2795: END IF;
2796:

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

2812:
2813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2814: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2815: FND_LOG.STRING(g_level_unexpected,
2816: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2817: 'Incorrect return_status after calling ' ||
2818: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2819: FND_LOG.STRING(g_level_unexpected,
2820: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',

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

2816: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2817: 'Incorrect return_status after calling ' ||
2818: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2819: FND_LOG.STRING(g_level_unexpected,
2820: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2821: 'RETURN_STATUS = ' || x_return_status);
2822: FND_LOG.STRING(g_level_unexpected,
2823: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2824: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');

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

2819: FND_LOG.STRING(g_level_unexpected,
2820: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2821: 'RETURN_STATUS = ' || x_return_status);
2822: FND_LOG.STRING(g_level_unexpected,
2823: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2824: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2825: END IF;
2826: RETURN;
2827: END IF;

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

2820: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2821: 'RETURN_STATUS = ' || x_return_status);
2822: FND_LOG.STRING(g_level_unexpected,
2823: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2824: 'ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines(-)');
2825: END IF;
2826: RETURN;
2827: END IF;
2828:

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

2847:
2848: IF (g_level_procedure >= g_current_runtime_level ) THEN
2849:
2850: FND_LOG.STRING(g_level_procedure,
2851: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2852: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(-)'||x_return_status);
2853: END IF;
2854:
2855: EXCEPTION

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

2848: IF (g_level_procedure >= g_current_runtime_level ) THEN
2849:
2850: FND_LOG.STRING(g_level_procedure,
2851: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines.END',
2852: 'ZX_TDS_TAX_LINES_DETM_PKG: process_reference_tax_lines(-)'||x_return_status);
2853: END IF;
2854:
2855: EXCEPTION
2856: WHEN OTHERS THEN

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

2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2858: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2859: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2860: FND_LOG.STRING(g_level_unexpected,
2861: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_reference_tax_lines',
2862: x_error_buffer);
2863: END IF;
2864:
2865: END process_reference_tax_lines;

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

2947: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2948:
2949: IF (g_level_procedure >= g_current_runtime_level ) THEN
2950: FND_LOG.STRING(g_level_procedure,
2951: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.BEGIN',
2952: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(+)');
2953: END IF;
2954:
2955: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2948:
2949: IF (g_level_procedure >= g_current_runtime_level ) THEN
2950: FND_LOG.STRING(g_level_procedure,
2951: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.BEGIN',
2952: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(+)');
2953: END IF;
2954:
2955: x_return_status := FND_API.G_RET_STS_SUCCESS;
2956:

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

3991:
3992: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3993: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3994: FND_LOG.STRING(g_level_unexpected,
3995: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3996: 'Incorrect return_status after calling ' ||
3997: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
3998: FND_LOG.STRING(g_level_unexpected,
3999: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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

3995: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
3996: 'Incorrect return_status after calling ' ||
3997: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
3998: FND_LOG.STRING(g_level_unexpected,
3999: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4000: 'RETURN_STATUS = ' || x_return_status);
4001: FND_LOG.STRING(g_level_unexpected,
4002: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4003: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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

3998: FND_LOG.STRING(g_level_unexpected,
3999: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4000: 'RETURN_STATUS = ' || x_return_status);
4001: FND_LOG.STRING(g_level_unexpected,
4002: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4003: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4004: END IF;
4005: RETURN;
4006: END IF;

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

3999: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4000: 'RETURN_STATUS = ' || x_return_status);
4001: FND_LOG.STRING(g_level_unexpected,
4002: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4003: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4004: END IF;
4005: RETURN;
4006: END IF;
4007:

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

4019:
4020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4021: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4022: FND_LOG.STRING(g_level_unexpected,
4023: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4024: 'Incorrect return_status after calling ' ||
4025: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
4026: FND_LOG.STRING(g_level_unexpected,
4027: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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

4023: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4024: 'Incorrect return_status after calling ' ||
4025: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
4026: FND_LOG.STRING(g_level_unexpected,
4027: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4028: 'RETURN_STATUS = ' || x_return_status);
4029: FND_LOG.STRING(g_level_unexpected,
4030: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4031: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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

4026: FND_LOG.STRING(g_level_unexpected,
4027: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4028: 'RETURN_STATUS = ' || x_return_status);
4029: FND_LOG.STRING(g_level_unexpected,
4030: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4031: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4032: END IF;
4033: RETURN;
4034: END IF;

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

4027: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4028: 'RETURN_STATUS = ' || x_return_status);
4029: FND_LOG.STRING(g_level_unexpected,
4030: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4031: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4032: END IF;
4033: RETURN;
4034: END IF;
4035:

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

4047:
4048: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4049: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4050: FND_LOG.STRING(g_level_unexpected,
4051: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4052: 'Incorrect return_status after calling ' ||
4053: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
4054: FND_LOG.STRING(g_level_unexpected,
4055: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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

4051: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4052: 'Incorrect return_status after calling ' ||
4053: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
4054: FND_LOG.STRING(g_level_unexpected,
4055: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4056: 'RETURN_STATUS = ' || x_return_status);
4057: FND_LOG.STRING(g_level_unexpected,
4058: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4059: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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

4054: FND_LOG.STRING(g_level_unexpected,
4055: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4056: 'RETURN_STATUS = ' || x_return_status);
4057: FND_LOG.STRING(g_level_unexpected,
4058: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4059: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4060: END IF;
4061: RETURN;
4062: END IF;

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

4055: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4056: 'RETURN_STATUS = ' || x_return_status);
4057: FND_LOG.STRING(g_level_unexpected,
4058: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4059: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4060: END IF;
4061: RETURN;
4062: END IF;
4063:

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

4081:
4082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4083: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4084: FND_LOG.STRING(g_level_unexpected,
4085: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4086: 'Incorrect return_status after calling ' ||
4087: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
4088: FND_LOG.STRING(g_level_unexpected,
4089: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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

4085: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4086: 'Incorrect return_status after calling ' ||
4087: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
4088: FND_LOG.STRING(g_level_unexpected,
4089: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4090: 'RETURN_STATUS = ' || x_return_status);
4091: FND_LOG.STRING(g_level_unexpected,
4092: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4093: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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

4088: FND_LOG.STRING(g_level_unexpected,
4089: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4090: 'RETURN_STATUS = ' || x_return_status);
4091: FND_LOG.STRING(g_level_unexpected,
4092: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4093: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4094: END IF;
4095: RETURN;
4096: END IF;

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

4089: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4090: 'RETURN_STATUS = ' || x_return_status);
4091: FND_LOG.STRING(g_level_unexpected,
4092: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4093: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4094: END IF;
4095: RETURN;
4096: END IF;
4097:

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

4113:
4114: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4115: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4116: FND_LOG.STRING(g_level_unexpected,
4117: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4118: 'Incorrect return_status after calling ' ||
4119: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
4120: FND_LOG.STRING(g_level_unexpected,
4121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',

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

4117: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4118: 'Incorrect return_status after calling ' ||
4119: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
4120: FND_LOG.STRING(g_level_unexpected,
4121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4122: 'RETURN_STATUS = ' || x_return_status);
4123: FND_LOG.STRING(g_level_unexpected,
4124: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4125: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');

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

4120: FND_LOG.STRING(g_level_unexpected,
4121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4122: 'RETURN_STATUS = ' || x_return_status);
4123: FND_LOG.STRING(g_level_unexpected,
4124: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4125: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4126: END IF;
4127: RETURN;
4128: END IF;

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

4121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4122: 'RETURN_STATUS = ' || x_return_status);
4123: FND_LOG.STRING(g_level_unexpected,
4124: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4125: 'ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create(-)');
4126: END IF;
4127: RETURN;
4128: END IF;
4129:

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

4146: CLOSE get_tax_info_csr;
4147:
4148: IF (g_level_procedure >= g_current_runtime_level ) THEN
4149: FND_LOG.STRING(g_level_procedure,
4150: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4151: 'p_return_status = ' || x_return_status);
4152: FND_LOG.STRING(g_level_procedure,
4153: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4154: 'p_error_buffer = ' || x_error_buffer);

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

4149: FND_LOG.STRING(g_level_procedure,
4150: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4151: 'p_return_status = ' || x_return_status);
4152: FND_LOG.STRING(g_level_procedure,
4153: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4154: 'p_error_buffer = ' || x_error_buffer);
4155: FND_LOG.STRING(g_level_procedure,
4156: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4157: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(-)');

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

4152: FND_LOG.STRING(g_level_procedure,
4153: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4154: 'p_error_buffer = ' || x_error_buffer);
4155: FND_LOG.STRING(g_level_procedure,
4156: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4157: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(-)');
4158: END IF;
4159:
4160: EXCEPTION

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

4153: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4154: 'p_error_buffer = ' || x_error_buffer);
4155: FND_LOG.STRING(g_level_procedure,
4156: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',
4157: 'ZX_TDS_TAX_LINES_DETM_PKG: process_copy_and_create(-)');
4158: END IF;
4159:
4160: EXCEPTION
4161: WHEN OTHERS THEN

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

4162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4163: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4164: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4165: FND_LOG.STRING(g_level_unexpected,
4166: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create',
4167: x_error_buffer);
4168: END IF;
4169:
4170: END process_copy_and_create;

Line 4302: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN',

4298: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4299:
4300: IF (g_level_procedure >= g_current_runtime_level ) THEN
4301: FND_LOG.STRING(g_level_procedure,
4302: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN',
4303: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(+)');
4304: END IF;
4305:
4306: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4299:
4300: IF (g_level_procedure >= g_current_runtime_level ) THEN
4301: FND_LOG.STRING(g_level_procedure,
4302: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.BEGIN',
4303: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(+)');
4304: END IF;
4305:
4306: x_return_status := FND_API.G_RET_STS_SUCCESS;
4307:

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

4311: --THEN
4312: -- IF (g_level_statement >= g_current_runtime_level ) THEN
4313: --
4314: -- FND_LOG.STRING(g_level_statement,
4315: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',
4316: -- 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)'||' do not check for historical trx');
4317: -- END IF;
4318: -- RETURN;
4319: --END IF;

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

4312: -- IF (g_level_statement >= g_current_runtime_level ) THEN
4313: --
4314: -- FND_LOG.STRING(g_level_statement,
4315: -- 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',
4316: -- 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)'||' do not check for historical trx');
4317: -- END IF;
4318: -- RETURN;
4319: --END IF;
4320:

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

4386: AND NVL(reporting_currency_code, -99) = NVL(l_rpt_currency_code_tbl(i), -99);
4387:
4388: IF (g_level_procedure >= g_current_runtime_level ) THEN
4389: FND_LOG.STRING(g_level_procedure,
4390: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',
4391: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)');
4392: END IF;
4393:
4394: EXCEPTION

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

4387:
4388: IF (g_level_procedure >= g_current_runtime_level ) THEN
4389: FND_LOG.STRING(g_level_procedure,
4390: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication.END',
4391: 'ZX_TDS_TAX_LINES_DETM_PKG: adjust_overapplication(-)');
4392: END IF;
4393:
4394: EXCEPTION
4395: WHEN OTHERS THEN

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

4397: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4398:
4399: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4400: FND_LOG.STRING(g_level_unexpected,
4401: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.adjust_overapplication',
4402: x_error_buffer);
4403: END IF;
4404:
4405: END adjust_overapplication;

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

4451: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4452:
4453: IF (g_level_procedure >= g_current_runtime_level ) THEN
4454: FND_LOG.STRING(g_level_procedure,
4455: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',
4456: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(+)');
4457: END IF;
4458:
4459: l_tax_index := 1;

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

4452:
4453: IF (g_level_procedure >= g_current_runtime_level ) THEN
4454: FND_LOG.STRING(g_level_procedure,
4455: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',
4456: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(+)');
4457: END IF;
4458:
4459: l_tax_index := 1;
4460: FOR tax_rec IN c_tx_ln_for_unchanged_trx_ln LOOP

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

4479:
4480:
4481: IF (g_level_procedure >= g_current_runtime_level ) THEN
4482: FND_LOG.STRING(g_level_procedure,
4483: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',
4484: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(-)');
4485: END IF;
4486:
4487: EXCEPTION

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

4480:
4481: IF (g_level_procedure >= g_current_runtime_level ) THEN
4482: FND_LOG.STRING(g_level_procedure,
4483: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines.BEGIN',
4484: 'ZX_TDS_TAX_LINES_DETM_PKG: process_unchanged_trx_lines(-)');
4485: END IF;
4486:
4487: EXCEPTION
4488: WHEN OTHERS THEN

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

4490: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4491:
4492: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4493: FND_LOG.STRING(g_level_unexpected,
4494: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_unchanged_trx_lines',
4495: x_error_buffer);
4496: END IF;
4497:
4498: END process_unchanged_trx_lines;

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

4525: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4526:
4527: IF (g_level_procedure >= g_current_runtime_level ) THEN
4528: FND_LOG.STRING(g_level_procedure,
4529: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.BEGIN',
4530: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(+)');
4531: END IF;
4532:
4533: UPDATE zx_detail_tax_lines_gt gt1

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

4526:
4527: IF (g_level_procedure >= g_current_runtime_level ) THEN
4528: FND_LOG.STRING(g_level_procedure,
4529: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.BEGIN',
4530: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(+)');
4531: END IF;
4532:
4533: UPDATE zx_detail_tax_lines_gt gt1
4534: SET account_source_tax_rate_id =

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

4556: END IF;
4557:
4558: IF (g_level_procedure >= g_current_runtime_level ) THEN
4559: FND_LOG.STRING(g_level_procedure,
4560: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.END',
4561: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(-)');
4562: END IF;
4563:
4564: EXCEPTION

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

4557:
4558: IF (g_level_procedure >= g_current_runtime_level ) THEN
4559: FND_LOG.STRING(g_level_procedure,
4560: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id.END',
4561: 'ZX_TDS_TAX_LINES_DETM_PKG: set_acct_source_tax_rate_id(-)');
4562: END IF;
4563:
4564: EXCEPTION
4565: WHEN OTHERS THEN

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

4567: x_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4568:
4569: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4570: FND_LOG.STRING(g_level_unexpected,
4571: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.set_acct_source_tax_rate_id',
4572: x_error_buffer);
4573: END IF;
4574:
4575: END set_acct_source_tax_rate_id;

Line 4577: END ZX_TDS_TAX_LINES_DETM_PKG;

4573: END IF;
4574:
4575: END set_acct_source_tax_rate_id;
4576:
4577: END ZX_TDS_TAX_LINES_DETM_PKG;