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

APPS.ZX_TDS_TAX_LINES_DETM_PKG dependencies on FND_LOG

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

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

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

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

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

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

Line 66: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 69: FND_LOG.STRING(g_level_procedure,

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

Line 93: FND_LOG.STRING(g_level_unexpected,

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

Line 96: FND_LOG.STRING(g_level_unexpected,

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

Line 99: FND_LOG.STRING(g_level_unexpected,

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

Line 118: FND_LOG.STRING(g_level_unexpected,

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

Line 122: FND_LOG.STRING(g_level_unexpected,

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

Line 125: FND_LOG.STRING(g_level_unexpected,

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

Line 144: -- FND_LOG.STRING(g_level_unexpected,

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

Line 148: -- FND_LOG.STRING(g_level_unexpected,

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

Line 151: -- FND_LOG.STRING(g_level_unexpected,

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

Line 191: FND_LOG.STRING(g_level_unexpected,

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

Line 194: FND_LOG.STRING(g_level_unexpected,

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);
197: FND_LOG.STRING(g_level_unexpected,
198: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.tax_line_determination.END',

Line 197: FND_LOG.STRING(g_level_unexpected,

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(-)');
200: END IF;
201: RETURN;

Line 309: FND_LOG.STRING(g_level_unexpected,

305: p_error_buffer);
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,

Line 313: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 316: FND_LOG.STRING(g_level_unexpected,

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(-)');
319: END IF;
320: RETURN;

Line 343: FND_LOG.STRING(g_level_unexpected,

339: );
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,

Line 347: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 350: FND_LOG.STRING(g_level_unexpected,

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(-)');
353: END IF;
354: RETURN;

Line 380: FND_LOG.STRING(g_level_procedure,

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

Line 390: FND_LOG.STRING(g_level_unexpected,

386: WHEN OTHERS THEN
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:

Line 780: FND_LOG.STRING(g_level_statement,

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

Line 1177: FND_LOG.STRING(g_level_procedure,

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

Line 1190: FND_LOG.STRING(g_level_unexpected,

1186: IF get_tax_line_csr%ISOPEN THEN
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:

Line 1263: FND_LOG.STRING(g_level_statement,

1259: l_tax_line_number_tab num_tab_type;
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:

Line 1324: FND_LOG.STRING(g_level_statement,

1320: SET tax_line_number = l_tax_line_number_tab(i)
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;

Line 1354: FND_LOG.STRING(g_level_procedure,

1350: END LOOP;
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:

Line 1364: FND_LOG.STRING(g_level_unexpected,

1360: WHEN OTHERS THEN
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:

Line 1452: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1448: AND freeze_until_overridden_flag = 'Y';
1449:
1450: BEGIN
1451:
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',

Line 1455: FND_LOG.STRING(g_level_procedure,

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

Line 1513: FND_LOG.STRING(g_level_statement,

1509: AND L.cancel_flag <> 'Y'
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;

Line 2075: FND_LOG.STRING(g_level_statement,

2071: )
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:

Line 2646: FND_LOG.STRING(g_level_statement,

2642: )
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:

Line 2696: FND_LOG.STRING(g_level_unexpected,

2692: x_error_buffer);
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,

Line 2700: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 2703: FND_LOG.STRING(g_level_unexpected,

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(-)');
2706: END IF;
2707: RETURN;

Line 2724: FND_LOG.STRING(g_level_unexpected,

2720: x_error_buffer);
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,

Line 2728: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 2731: FND_LOG.STRING(g_level_unexpected,

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(-)');
2734: END IF;
2735: RETURN;

Line 2752: FND_LOG.STRING(g_level_unexpected,

2748: x_error_buffer);
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,

Line 2756: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 2759: FND_LOG.STRING(g_level_unexpected,

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(-)');
2762: END IF;
2763: RETURN;

Line 2783: FND_LOG.STRING(g_level_unexpected,

2779: x_error_buffer);
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,

Line 2787: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 2790: FND_LOG.STRING(g_level_unexpected,

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(-)');
2793: END IF;
2794: RETURN;

Line 2815: FND_LOG.STRING(g_level_unexpected,

2811: x_error_buffer);
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,

Line 2819: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 2822: FND_LOG.STRING(g_level_unexpected,

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(-)');
2825: END IF;
2826: RETURN;

Line 2850: FND_LOG.STRING(g_level_procedure,

2846: CLOSE get_tax_info_csr;
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:

Line 2860: FND_LOG.STRING(g_level_unexpected,

2856: WHEN OTHERS THEN
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:

Line 2947: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2943: AND T.tax_provider_id IS NULL;
2944:
2945: BEGIN
2946:
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',

Line 2950: FND_LOG.STRING(g_level_procedure,

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

Line 3994: FND_LOG.STRING(g_level_unexpected,

3990: x_error_buffer);
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,

Line 3998: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 4001: FND_LOG.STRING(g_level_unexpected,

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(-)');
4004: END IF;
4005: RETURN;

Line 4022: FND_LOG.STRING(g_level_unexpected,

4018: x_error_buffer);
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,

Line 4026: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 4029: FND_LOG.STRING(g_level_unexpected,

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(-)');
4032: END IF;
4033: RETURN;

Line 4050: FND_LOG.STRING(g_level_unexpected,

4046: x_error_buffer);
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,

Line 4054: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 4057: FND_LOG.STRING(g_level_unexpected,

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(-)');
4060: END IF;
4061: RETURN;

Line 4084: FND_LOG.STRING(g_level_unexpected,

4080: x_error_buffer);
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,

Line 4088: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 4091: FND_LOG.STRING(g_level_unexpected,

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(-)');
4094: END IF;
4095: RETURN;

Line 4116: FND_LOG.STRING(g_level_unexpected,

4112: x_error_buffer);
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,

Line 4120: FND_LOG.STRING(g_level_unexpected,

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',
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',

Line 4123: FND_LOG.STRING(g_level_unexpected,

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(-)');
4126: END IF;
4127: RETURN;

Line 4149: FND_LOG.STRING(g_level_procedure,

4145: END LOOP;
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',

Line 4152: FND_LOG.STRING(g_level_procedure,

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);
4155: FND_LOG.STRING(g_level_procedure,
4156: 'ZX.PLSQL.ZX_TDS_TAX_LINES_DETM_PKG.process_copy_and_create.END',

Line 4155: FND_LOG.STRING(g_level_procedure,

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(-)');
4158: END IF;
4159:

Line 4165: FND_LOG.STRING(g_level_unexpected,

4161: WHEN OTHERS THEN
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:

Line 4298: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4294: l_orig_tax_amt_tbl num_tbl_type;
4295: l_orig_line_amt_tbl num_tbl_type;
4296:
4297: 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',

Line 4301: FND_LOG.STRING(g_level_procedure,

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

Line 4314: -- FND_LOG.STRING(g_level_statement,

4310: -- OR p_event_class_rec.CTRL_TOTAL_LINE_TX_AMT_FLG = 'Y'
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;

Line 4389: FND_LOG.STRING(g_level_procedure,

4385: AND tax_line_id = l_tax_line_id_tbl(i)
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:

Line 4400: FND_LOG.STRING(g_level_unexpected,

4396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 4451: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4447: AND L.cancel_flag <> 'Y';
4448:
4449: BEGIN
4450:
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',

Line 4454: FND_LOG.STRING(g_level_procedure,

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

Line 4482: FND_LOG.STRING(g_level_procedure,

4478: VALUES l_detail_tax_lines_tbl(l_tax_ln_index);
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:

Line 4493: FND_LOG.STRING(g_level_unexpected,

4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 4525: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4521: l_row_count NUMBER;
4522:
4523: BEGIN
4524:
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',

Line 4528: FND_LOG.STRING(g_level_procedure,

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

Line 4553: FND_LOG.STRING(g_level_statement,

4549:
4550: l_row_count := SQL%ROWCOUNT;
4551:
4552: IF (g_level_statement >= g_current_runtime_level ) THEN
4553: FND_LOG.STRING(g_level_statement,
4554: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.set_acct_source_tax_rate_id',
4555: ' number of rows inserted = ' || l_row_count);
4556: END IF;
4557:

Line 4559: FND_LOG.STRING(g_level_procedure,

4555: ' number of rows inserted = ' || l_row_count);
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:

Line 4570: FND_LOG.STRING(g_level_unexpected,

4566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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: