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_STATUS_DETM_PKG dependencies on ZX_TDS_TAX_STATUS_DETM_PKG

Line 1: package body ZX_TDS_TAX_STATUS_DETM_PKG as

1: package body ZX_TDS_TAX_STATUS_DETM_PKG as
2: /* $Header: zxditaxstsdtpkgb.pls 120.29.12010000.7 2010/02/12 11:51:37 msakalab ship $ */
3:
4:
5: PROCEDURE get_def_tax_status_info(

Line 72: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.BEGIN',

68:
69: IF (g_level_procedure >= g_current_runtime_level ) THEN
70:
71: FND_LOG.STRING(g_level_procedure,
72: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.BEGIN',
73: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(+)');
74:
75:
76: END IF;

Line 73: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(+)');

69: IF (g_level_procedure >= g_current_runtime_level ) THEN
70:
71: FND_LOG.STRING(g_level_procedure,
72: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.BEGIN',
73: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(+)');
74:
75:
76: END IF;
77:

Line 90: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

86: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
87:
88: IF (g_level_error >= g_current_runtime_level ) THEN
89: FND_LOG.STRING(g_level_error,
90: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
91: 'Begin index or End index is null');
92: END IF;
93: RETURN;
94: END IF;

Line 104: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

100:
101: FOR i IN p_begin_index .. p_end_index LOOP
102: IF (g_level_statement >= g_current_runtime_level ) THEN
103: FND_LOG.STRING(g_level_statement,
104: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
105: 'processing detail line index = ' || to_char(i));
106: END IF;
107:
108: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).other_doc_source = 'REFERENCE' AND

Line 168: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

164:
165: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: IF (g_level_error >= g_current_runtime_level ) THEN
167: FND_LOG.STRING(g_level_error,
168: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
169: 'Incorrect return_status after calling rule_base_tax_status_detm()');
170: FND_LOG.STRING(g_level_error,
171: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
172: 'p_return_status : '|| p_return_status);

Line 171: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

167: FND_LOG.STRING(g_level_error,
168: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
169: 'Incorrect return_status after calling rule_base_tax_status_detm()');
170: FND_LOG.STRING(g_level_error,
171: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
172: 'p_return_status : '|| p_return_status);
173: END IF;
174: EXIT;
175: ELSE

Line 192: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

188: p_error_buffer);
189: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
190: IF (g_level_error >= g_current_runtime_level ) THEN
191: FND_LOG.STRING(g_level_error,
192: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
193: 'Incorrect return_status after calling '||
194: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()' );
195: FND_LOG.STRING(g_level_error,
196: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

Line 196: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

192: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
193: 'Incorrect return_status after calling '||
194: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()' );
195: FND_LOG.STRING(g_level_error,
196: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
197: 'No valid tax status id for the tax status code ' ||
198: 'returned from rule engine. Need to get default tax status.');
199: END IF;
200: -- reset return status

Line 233: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

229:
230: IF l_status_rec.tax_status_code IS NULL THEN
231: IF (g_level_error >= g_current_runtime_level ) THEN
232: FND_LOG.STRING(g_level_error,
233: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
234: 'tax status not found for tax: ' || l_tax);
235: END IF;
236:
237: FND_MESSAGE.SET_NAME('ZX','ZX_STATUS_NOT_FOUND');

Line 266: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.END',

262:
263: IF (g_level_procedure >= g_current_runtime_level ) THEN
264:
265: FND_LOG.STRING(g_level_procedure,
266: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.END',
267: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(-)'||p_return_status);
268: END IF;
269:
270: EXCEPTION

Line 267: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(-)'||p_return_status);

263: IF (g_level_procedure >= g_current_runtime_level ) THEN
264:
265: FND_LOG.STRING(g_level_procedure,
266: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.END',
267: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(-)'||p_return_status);
268: END IF;
269:
270: EXCEPTION
271: WHEN OTHERS THEN

Line 277: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

273: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
274:
275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
276: FND_LOG.STRING(g_level_unexpected,
277: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
278: p_error_buffer);
279: END IF;
280:
281: END get_tax_status;

Line 339: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.BEGIN',

335: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
336:
337: IF (g_level_procedure >= g_current_runtime_level ) THEN
338: FND_LOG.STRING(g_level_procedure,
339: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.BEGIN',
340: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(+)'||
341: 'tax_regime_code = ' || p_tax_regime_code||
342: 'tax = ' || p_tax);
343:

Line 340: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(+)'||

336:
337: IF (g_level_procedure >= g_current_runtime_level ) THEN
338: FND_LOG.STRING(g_level_procedure,
339: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.BEGIN',
340: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(+)'||
341: 'tax_regime_code = ' || p_tax_regime_code||
342: 'tax = ' || p_tax);
343:
344: END IF;

Line 368: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info',

364: p_error_buffer := 'No default tax status found';
365:
366: IF (g_level_statement >= g_current_runtime_level ) THEN
367: FND_LOG.STRING(g_level_statement,
368: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info',
369: p_error_buffer);
370: END IF;
371: END IF;
372: CLOSE get_def_status_info_csr;

Line 387: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.END',

383:
384:
385: IF (g_level_procedure >= g_current_runtime_level ) THEN
386: FND_LOG.STRING(g_level_procedure,
387: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.END',
388: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(-)'||
389: 'tax_status_code = ' ||
390: p_status_rec.tax_status_code);
391: END IF;

Line 388: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(-)'||

384:
385: IF (g_level_procedure >= g_current_runtime_level ) THEN
386: FND_LOG.STRING(g_level_procedure,
387: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.END',
388: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(-)'||
389: 'tax_status_code = ' ||
390: p_status_rec.tax_status_code);
391: END IF;
392:

Line 402: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info',

398: CLOSE get_def_status_info_csr;
399: END IF;
400: IF (g_level_unexpected >= g_current_runtime_level ) THEN
401: FND_LOG.STRING(g_level_unexpected,
402: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info',
403: p_error_buffer);
404: END IF;
405: END get_def_tax_status_info;
406:

Line 439: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.BEGIN',

435: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
436:
437: IF (g_level_procedure >= g_current_runtime_level ) THEN
438: FND_LOG.STRING(g_level_procedure,
439: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.BEGIN',
440: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(+)');
441: END IF;
442: IF (g_level_statement >= g_current_runtime_level ) THEN
443: FND_LOG.STRING(g_level_statement,

Line 440: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(+)');

436:
437: IF (g_level_procedure >= g_current_runtime_level ) THEN
438: FND_LOG.STRING(g_level_procedure,
439: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.BEGIN',
440: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(+)');
441: END IF;
442: IF (g_level_statement >= g_current_runtime_level ) THEN
443: FND_LOG.STRING(g_level_statement,
444: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

Line 444: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

440: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(+)');
441: END IF;
442: IF (g_level_statement >= g_current_runtime_level ) THEN
443: FND_LOG.STRING(g_level_statement,
444: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
445: 'p_tax_id = ' || to_char(p_tax_id));
446: END IF;
447:
448: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 473: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

469: END IF;
470:
471: IF (g_level_statement >= g_current_runtime_level ) THEN
472: FND_LOG.STRING(g_level_statement,
473: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
474: 'p_return_status = ' || p_return_status);
475: FND_LOG.STRING(g_level_statement,
476: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
477: 'p_error_buffer = ' || p_error_buffer);

Line 476: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

472: FND_LOG.STRING(g_level_statement,
473: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
474: 'p_return_status = ' || p_return_status);
475: FND_LOG.STRING(g_level_statement,
476: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
477: 'p_error_buffer = ' || p_error_buffer);
478: FND_LOG.STRING(g_level_statement,
479: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
480: 'p_tax_status_code = ' || p_tax_status_code);

Line 479: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

475: FND_LOG.STRING(g_level_statement,
476: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
477: 'p_error_buffer = ' || p_error_buffer);
478: FND_LOG.STRING(g_level_statement,
479: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
480: 'p_tax_status_code = ' || p_tax_status_code);
481: FND_LOG.STRING(g_level_statement,
482: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
483: 'p_status_result_id = ' ||

Line 482: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

478: FND_LOG.STRING(g_level_statement,
479: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
480: 'p_tax_status_code = ' || p_tax_status_code);
481: FND_LOG.STRING(g_level_statement,
482: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
483: 'p_status_result_id = ' ||
484: to_char(p_status_result_id));
485: END IF;
486:

Line 489: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.END',

485: END IF;
486:
487: IF (g_level_procedure >= g_current_runtime_level ) THEN
488: FND_LOG.STRING(g_level_procedure,
489: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.END',
490: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(-)');
491: END IF;
492:
493: EXCEPTION

Line 490: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(-)');

486:
487: IF (g_level_procedure >= g_current_runtime_level ) THEN
488: FND_LOG.STRING(g_level_procedure,
489: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.END',
490: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(-)');
491: END IF;
492:
493: EXCEPTION
494: WHEN OTHERS THEN

Line 500: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

496: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
497:
498: IF (g_level_unexpected >= g_current_runtime_level ) THEN
499: FND_LOG.STRING(g_level_unexpected,
500: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
501: p_error_buffer);
502: END IF;
503:
504: END rule_base_tax_status_detm;

Line 527: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.BEGIN',

523: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
524:
525: IF (g_level_procedure >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_procedure,
527: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.BEGIN',
528: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(+)');
529: END IF;
530:
531: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id := p_status_rec.tax_status_id;

Line 528: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(+)');

524:
525: IF (g_level_procedure >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_procedure,
527: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.BEGIN',
528: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(+)');
529: END IF;
530:
531: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_id := p_status_rec.tax_status_id;
532: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_status_code := p_status_rec.tax_status_code;

Line 538: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.END',

534: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_message_status := p_reporting_code_id;
535:
536: IF (g_level_procedure >= g_current_runtime_level ) THEN
537: FND_LOG.STRING(g_level_procedure,
538: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.END',
539: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(-)');
540: END IF;
541:
542: EXCEPTION

Line 539: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(-)');

535:
536: IF (g_level_procedure >= g_current_runtime_level ) THEN
537: FND_LOG.STRING(g_level_procedure,
538: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.END',
539: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(-)');
540: END IF;
541:
542: EXCEPTION
543: WHEN OTHERS THEN

Line 546: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line',

542: EXCEPTION
543: WHEN OTHERS THEN
544: IF (g_level_unexpected >= g_current_runtime_level ) THEN
545: FND_LOG.STRING(g_level_unexpected,
546: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line',
547: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
548: END IF;
549:
550: END update_det_tax_line;

Line 552: END ZX_TDS_TAX_STATUS_DETM_PKG;

548: END IF;
549:
550: END update_det_tax_line;
551:
552: END ZX_TDS_TAX_STATUS_DETM_PKG;