[Home] [Help]
1: PACKAGE BODY ZX_TDS_IMPORT_DOCUMENT_PKG AS
2: /* $Header: zxdiimpdocmtpkgb.pls 120.61.12010000.2 2008/11/12 12:22:25 spasala ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
318: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
319:
320: IF (g_level_event >= g_current_runtime_level ) THEN
321: FND_LOG.STRING(g_level_event,
322: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.BEGIN',
323: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(+)');
324: END IF;
325:
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: IF (g_level_event >= g_current_runtime_level ) THEN
321: FND_LOG.STRING(g_level_event,
322: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.BEGIN',
323: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(+)');
324: END IF;
325:
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:
364:
365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
366: IF (g_level_unexpected >= g_current_runtime_level ) THEN
367: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
369: 'Incorrect return_status after calling '||
370: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
371: FND_LOG.STRING(g_level_unexpected,
372: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
366: IF (g_level_unexpected >= g_current_runtime_level ) THEN
367: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
369: 'Incorrect return_status after calling '||
370: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
371: FND_LOG.STRING(g_level_unexpected,
372: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
373: 'RETURN_STATUS = ' || x_return_status);
374: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
369: 'Incorrect return_status after calling '||
370: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
371: FND_LOG.STRING(g_level_unexpected,
372: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
373: 'RETURN_STATUS = ' || x_return_status);
374: FND_LOG.STRING(g_level_unexpected,
375: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
376: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
371: FND_LOG.STRING(g_level_unexpected,
372: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
373: 'RETURN_STATUS = ' || x_return_status);
374: FND_LOG.STRING(g_level_unexpected,
375: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
376: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
377: END IF;
378: RETURN;
379: END IF;
372: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
373: 'RETURN_STATUS = ' || x_return_status);
374: FND_LOG.STRING(g_level_unexpected,
375: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
376: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
377: END IF;
378: RETURN;
379: END IF;
380:
464: x_return_status := FND_API.G_RET_STS_ERROR;
465:
466: IF (g_level_event >= g_current_runtime_level ) THEN
467: FND_LOG.STRING(g_level_event,
468: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
469: 'tax_amt from summary tax line is not 0, ' ||
470: 'but the total line amount for the allocated trx lines is 0.'
471: || 'Cannot do proration.');
472: FND_LOG.STRING(g_level_event,
469: 'tax_amt from summary tax line is not 0, ' ||
470: 'but the total line amount for the allocated trx lines is 0.'
471: || 'Cannot do proration.');
472: FND_LOG.STRING(g_level_event,
473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
474: 'Summary_tax_line_number = ' ||
475: tax_line_rec.summary_tax_line_number);
476: FND_LOG.STRING(g_level_event,
477: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
474: 'Summary_tax_line_number = ' ||
475: tax_line_rec.summary_tax_line_number);
476: FND_LOG.STRING(g_level_event,
477: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
478: 'RETURN_STATUS = ' || x_return_status);
479: FND_LOG.STRING(g_level_event,
480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
481: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
476: FND_LOG.STRING(g_level_event,
477: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
478: 'RETURN_STATUS = ' || x_return_status);
479: FND_LOG.STRING(g_level_event,
480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
481: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
482: 'prorate_imported_sum_tax_lines(-)');
483: END IF;
484: RETURN;
477: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
478: 'RETURN_STATUS = ' || x_return_status);
479: FND_LOG.STRING(g_level_event,
480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
481: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
482: 'prorate_imported_sum_tax_lines(-)');
483: END IF;
484: RETURN;
485: ELSE
509:
510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
511: IF (g_level_unexpected >= g_current_runtime_level ) THEN
512: FND_LOG.STRING(g_level_unexpected,
513: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
514: 'Incorrect return_status after calling ' ||
515: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
516: FND_LOG.STRING(g_level_unexpected,
517: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
513: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
514: 'Incorrect return_status after calling ' ||
515: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
516: FND_LOG.STRING(g_level_unexpected,
517: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
518: 'RETURN_STATUS = ' || x_return_status);
519: FND_LOG.STRING(g_level_unexpected,
520: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
521: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
516: FND_LOG.STRING(g_level_unexpected,
517: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
518: 'RETURN_STATUS = ' || x_return_status);
519: FND_LOG.STRING(g_level_unexpected,
520: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
521: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
522: END IF;
523: RETURN;
524: END IF;
517: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
518: 'RETURN_STATUS = ' || x_return_status);
519: FND_LOG.STRING(g_level_unexpected,
520: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
521: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
522: END IF;
523: RETURN;
524: END IF;
525:
589:
590: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
591: IF (g_level_unexpected >= g_current_runtime_level ) THEN
592: FND_LOG.STRING(g_level_unexpected,
593: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
594: 'Incorrect return_status after calling '||
595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
596: FND_LOG.STRING(g_level_unexpected,
597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
591: IF (g_level_unexpected >= g_current_runtime_level ) THEN
592: FND_LOG.STRING(g_level_unexpected,
593: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
594: 'Incorrect return_status after calling '||
595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
596: FND_LOG.STRING(g_level_unexpected,
597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
598: 'RETURN_STATUS = ' || x_return_status);
599: FND_LOG.STRING(g_level_unexpected,
593: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
594: 'Incorrect return_status after calling '||
595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
596: FND_LOG.STRING(g_level_unexpected,
597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
598: 'RETURN_STATUS = ' || x_return_status);
599: FND_LOG.STRING(g_level_unexpected,
600: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
601: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
596: FND_LOG.STRING(g_level_unexpected,
597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
598: 'RETURN_STATUS = ' || x_return_status);
599: FND_LOG.STRING(g_level_unexpected,
600: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
601: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
602: END IF;
603: RETURN;
604: END IF;
597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
598: 'RETURN_STATUS = ' || x_return_status);
599: FND_LOG.STRING(g_level_unexpected,
600: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
601: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
602: END IF;
603: RETURN;
604: END IF;
605:
671: x_return_status := FND_API.G_RET_STS_ERROR;
672:
673: IF (g_level_event >= g_current_runtime_level ) THEN
674: FND_LOG.STRING(g_level_event,
675: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
676: 'tax_amt from summary tax line is not 0, ' ||
677: 'but the total line amount for the allocated trx lines is 0.'
678: || 'Cannot do proration.');
679: FND_LOG.STRING(g_level_event,
676: 'tax_amt from summary tax line is not 0, ' ||
677: 'but the total line amount for the allocated trx lines is 0.'
678: || 'Cannot do proration.');
679: FND_LOG.STRING(g_level_event,
680: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
681: 'Summary_tax_line_number = ' ||
682: tax_line_rec.summary_tax_line_number);
683: FND_LOG.STRING(g_level_event,
684: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
680: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
681: 'Summary_tax_line_number = ' ||
682: tax_line_rec.summary_tax_line_number);
683: FND_LOG.STRING(g_level_event,
684: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
685: 'RETURN_STATUS = ' || x_return_status);
686: FND_LOG.STRING(g_level_event,
687: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
688: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
683: FND_LOG.STRING(g_level_event,
684: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
685: 'RETURN_STATUS = ' || x_return_status);
686: FND_LOG.STRING(g_level_event,
687: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
688: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
689: 'prorate_imported_sum_tax_lines(-)');
690: END IF;
691: RETURN;
684: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
685: 'RETURN_STATUS = ' || x_return_status);
686: FND_LOG.STRING(g_level_event,
687: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
688: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
689: 'prorate_imported_sum_tax_lines(-)');
690: END IF;
691: RETURN;
692: ELSE
717:
718: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
719: IF (g_level_unexpected >= g_current_runtime_level ) THEN
720: FND_LOG.STRING(g_level_unexpected,
721: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
722: 'Incorrect return_status after calling ' ||
723: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
724: FND_LOG.STRING(g_level_unexpected,
725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
721: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
722: 'Incorrect return_status after calling ' ||
723: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
724: FND_LOG.STRING(g_level_unexpected,
725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
726: 'RETURN_STATUS = ' || x_return_status);
727: FND_LOG.STRING(g_level_unexpected,
728: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
729: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
724: FND_LOG.STRING(g_level_unexpected,
725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
726: 'RETURN_STATUS = ' || x_return_status);
727: FND_LOG.STRING(g_level_unexpected,
728: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
729: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
730: END IF;
731: RETURN;
732: END IF;
725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
726: 'RETURN_STATUS = ' || x_return_status);
727: FND_LOG.STRING(g_level_unexpected,
728: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
729: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
730: END IF;
731: RETURN;
732: END IF;
733:
790:
791: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
792: IF (g_level_unexpected >= g_current_runtime_level ) THEN
793: FND_LOG.STRING(g_level_unexpected,
794: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
795: 'Incorrect return_status after calling '||
796: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
797: FND_LOG.STRING(g_level_unexpected,
798: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
792: IF (g_level_unexpected >= g_current_runtime_level ) THEN
793: FND_LOG.STRING(g_level_unexpected,
794: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
795: 'Incorrect return_status after calling '||
796: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
797: FND_LOG.STRING(g_level_unexpected,
798: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
799: 'RETURN_STATUS = ' || x_return_status);
800: FND_LOG.STRING(g_level_unexpected,
794: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
795: 'Incorrect return_status after calling '||
796: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
797: FND_LOG.STRING(g_level_unexpected,
798: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
799: 'RETURN_STATUS = ' || x_return_status);
800: FND_LOG.STRING(g_level_unexpected,
801: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
802: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
797: FND_LOG.STRING(g_level_unexpected,
798: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
799: 'RETURN_STATUS = ' || x_return_status);
800: FND_LOG.STRING(g_level_unexpected,
801: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
802: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
803: END IF;
804: RETURN;
805: END IF;
798: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
799: 'RETURN_STATUS = ' || x_return_status);
800: FND_LOG.STRING(g_level_unexpected,
801: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
802: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
803: END IF;
804: RETURN;
805: END IF;
806:
850:
851: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
852: IF (g_level_unexpected >= g_current_runtime_level ) THEN
853: FND_LOG.STRING(g_level_unexpected,
854: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
855: 'Incorrect return_status after calling ' ||
856: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
854: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
855: 'Incorrect return_status after calling ' ||
856: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
859: 'RETURN_STATUS = ' || x_return_status);
860: FND_LOG.STRING(g_level_unexpected,
861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
862: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
859: 'RETURN_STATUS = ' || x_return_status);
860: FND_LOG.STRING(g_level_unexpected,
861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
862: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
863: END IF;
864: RETURN;
865: END IF;
858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
859: 'RETURN_STATUS = ' || x_return_status);
860: FND_LOG.STRING(g_level_unexpected,
861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
862: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
863: END IF;
864: RETURN;
865: END IF;
866:
865: END IF;
866:
867: IF (g_level_event >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_event,
869: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
870: 'Detail tax lines created from imported summary tax lines:');
871: FND_LOG.STRING(g_level_event,
872: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
873: 'l_begin_index = ' || l_begin_index);
868: FND_LOG.STRING(g_level_event,
869: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
870: 'Detail tax lines created from imported summary tax lines:');
871: FND_LOG.STRING(g_level_event,
872: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
873: 'l_begin_index = ' || l_begin_index);
874: FND_LOG.STRING(g_level_event,
875: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
876: 'l_end_index = ' || l_end_index);
871: FND_LOG.STRING(g_level_event,
872: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
873: 'l_begin_index = ' || l_begin_index);
874: FND_LOG.STRING(g_level_event,
875: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
876: 'l_end_index = ' || l_end_index);
877: FND_LOG.STRING(g_level_event,
878: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
879: 'RETURN_STATUS = ' || x_return_status);
874: FND_LOG.STRING(g_level_event,
875: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
876: 'l_end_index = ' || l_end_index);
877: FND_LOG.STRING(g_level_event,
878: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
879: 'RETURN_STATUS = ' || x_return_status);
880: FND_LOG.STRING(g_level_event,
881: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
882: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
877: FND_LOG.STRING(g_level_event,
878: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
879: 'RETURN_STATUS = ' || x_return_status);
880: FND_LOG.STRING(g_level_event,
881: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
882: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
883: END IF;
884:
885: EXCEPTION
878: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
879: 'RETURN_STATUS = ' || x_return_status);
880: FND_LOG.STRING(g_level_event,
881: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
882: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
883: END IF;
884:
885: EXCEPTION
886: WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888:
889: IF (g_level_unexpected >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_unexpected,
891: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
892: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
893: FND_LOG.STRING(g_level_unexpected,
894: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
895: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
890: FND_LOG.STRING(g_level_unexpected,
891: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
892: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
893: FND_LOG.STRING(g_level_unexpected,
894: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
895: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
896: END IF;
897:
898: END prorate_imported_sum_tax_lines;
891: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
892: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
893: FND_LOG.STRING(g_level_unexpected,
894: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
895: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
896: END IF;
897:
898: END prorate_imported_sum_tax_lines;
899:
949: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
950:
951: IF (g_level_event >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.BEGIN',
954: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(+)');
955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
950:
951: IF (g_level_event >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.BEGIN',
954: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(+)');
955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958:
1014:
1015: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1016: IF (g_level_statement >= g_current_runtime_level ) THEN
1017: FND_LOG.STRING(g_level_statement,
1018: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1019: 'Incorrect return_status after calling ' ||
1020: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
1021: FND_LOG.STRING(g_level_statement,
1022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1018: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1019: 'Incorrect return_status after calling ' ||
1020: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
1021: FND_LOG.STRING(g_level_statement,
1022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1023: 'RETURN_STATUS = ' || x_return_status);
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1026: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1021: FND_LOG.STRING(g_level_statement,
1022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1023: 'RETURN_STATUS = ' || x_return_status);
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1026: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1027: END IF;
1028: RETURN;
1029: END IF;
1022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1023: 'RETURN_STATUS = ' || x_return_status);
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1026: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1027: END IF;
1028: RETURN;
1029: END IF;
1030:
1039:
1040: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1041: IF (g_level_statement >= g_current_runtime_level ) THEN
1042: FND_LOG.STRING(g_level_statement,
1043: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1044: 'Incorrect return_status after calling ' ||
1045: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration');
1046: FND_LOG.STRING(g_level_statement,
1047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1043: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1044: 'Incorrect return_status after calling ' ||
1045: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration');
1046: FND_LOG.STRING(g_level_statement,
1047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1048: 'RETURN_STATUS = ' || x_return_status);
1049: FND_LOG.STRING(g_level_statement,
1050: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1051: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1046: FND_LOG.STRING(g_level_statement,
1047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1048: 'RETURN_STATUS = ' || x_return_status);
1049: FND_LOG.STRING(g_level_statement,
1050: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1051: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1052: END IF;
1053: RETURN;
1054: END IF;
1047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1048: 'RETURN_STATUS = ' || x_return_status);
1049: FND_LOG.STRING(g_level_statement,
1050: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1051: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1052: END IF;
1053: RETURN;
1054: END IF;
1055:
1089: ELSE
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1092: FND_LOG.STRING(g_level_unexpected,
1093: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1094: 'Tax_rate = 0, tax_amt <> 0. ' ||
1095: 'Cannot calculate taxable basis amount.');
1096: FND_LOG.STRING(g_level_unexpected,
1097: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1093: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1094: 'Tax_rate = 0, tax_amt <> 0. ' ||
1095: 'Cannot calculate taxable basis amount.');
1096: FND_LOG.STRING(g_level_unexpected,
1097: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1098: 'x_return_status = ' || x_return_status);
1099: FND_LOG.STRING(g_level_unexpected,
1100: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1101: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1096: FND_LOG.STRING(g_level_unexpected,
1097: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1098: 'x_return_status = ' || x_return_status);
1099: FND_LOG.STRING(g_level_unexpected,
1100: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1101: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1102: END IF;
1103:
1104: FND_MESSAGE.SET_NAME('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
1137: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1138:
1139: IF (g_level_procedure >= g_current_runtime_level ) THEN
1140: FND_LOG.STRING(g_level_procedure,
1141: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1142: 'Begin_index and end_index for detail tax lines created ' ||
1143: 'from summary tax_line');
1144: FND_LOG.STRING(g_level_procedure,
1145: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1141: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1142: 'Begin_index and end_index for detail tax lines created ' ||
1143: 'from summary tax_line');
1144: FND_LOG.STRING(g_level_procedure,
1145: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1146: 'l_begin_index :=' || l_begin_index);
1147: FND_LOG.STRING(g_level_procedure,
1148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1149: 'l_end_index :=' || l_end_index);
1144: FND_LOG.STRING(g_level_procedure,
1145: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1146: 'l_begin_index :=' || l_begin_index);
1147: FND_LOG.STRING(g_level_procedure,
1148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1149: 'l_end_index :=' || l_end_index);
1150: END IF;
1151:
1152: -- copy transaction information
1160:
1161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: IF (g_level_statement >= g_current_runtime_level ) THEN
1163: FND_LOG.STRING(g_level_statement,
1164: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1165: 'Incorrect return_status after calling '||
1166: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1164: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1165: 'Incorrect return_status after calling '||
1166: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1169: 'RETURN_STATUS = ' || x_return_status);
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1172: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1169: 'RETURN_STATUS = ' || x_return_status);
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1172: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1173: END IF;
1174: RETURN;
1175: END IF;
1168: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1169: 'RETURN_STATUS = ' || x_return_status);
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1172: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1173: END IF;
1174: RETURN;
1175: END IF;
1176:
1218:
1219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1220: IF g_level_unexpected >= g_current_runtime_level THEN
1221: FND_LOG.STRING(g_level_unexpected,
1222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1223: 'Incorrect return_status after calling ' ||
1224: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_adjusted_to()');
1225: FND_LOG.STRING(g_level_unexpected,
1226: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1223: 'Incorrect return_status after calling ' ||
1224: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_adjusted_to()');
1225: FND_LOG.STRING(g_level_unexpected,
1226: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1227: 'RETURN_STATUS = ' || x_return_status);
1228: FND_LOG.STRING(g_level_unexpected,
1229: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1230: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1225: FND_LOG.STRING(g_level_unexpected,
1226: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1227: 'RETURN_STATUS = ' || x_return_status);
1228: FND_LOG.STRING(g_level_unexpected,
1229: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1230: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1231: END IF;
1232: RETURN;
1233: END IF;
1226: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1227: 'RETURN_STATUS = ' || x_return_status);
1228: FND_LOG.STRING(g_level_unexpected,
1229: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1230: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1231: END IF;
1232: RETURN;
1233: END IF;
1234: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1247:
1248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1249: IF g_level_unexpected >= g_current_runtime_level THEN
1250: FND_LOG.STRING(g_level_unexpected,
1251: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1252: 'Incorrect return_status after calling ' ||
1253: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_applied_from()');
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1251: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1252: 'Incorrect return_status after calling ' ||
1253: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_applied_from()');
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1256: 'RETURN_STATUS = ' || x_return_status);
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1259: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1256: 'RETURN_STATUS = ' || x_return_status);
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1259: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1260: END IF;
1261: RETURN;
1262: END IF;
1255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1256: 'RETURN_STATUS = ' || x_return_status);
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1259: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1260: END IF;
1261: RETURN;
1262: END IF;
1263:
1268: -- line level action 'LINE_INFO_TAX_ONLY'
1269: --
1270: IF (g_level_statement >= g_current_runtime_level ) THEN
1271: FND_LOG.STRING(g_level_statement,
1272: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1273: 'line_ level_action on trx line is LINE_INFO_TAX_ONLY, ' ||
1274: 'skip performing additional applicability ');
1275: FND_LOG.STRING(g_level_statement,
1276: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1272: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1273: 'line_ level_action on trx line is LINE_INFO_TAX_ONLY, ' ||
1274: 'skip performing additional applicability ');
1275: FND_LOG.STRING(g_level_statement,
1276: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1277: 'RETURN_STATUS = ' || x_return_status);
1278: FND_LOG.STRING(g_level_statement,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1280: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1275: FND_LOG.STRING(g_level_statement,
1276: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1277: 'RETURN_STATUS = ' || x_return_status);
1278: FND_LOG.STRING(g_level_statement,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1280: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1281: END IF;
1282: RETURN;
1283:
1276: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1277: 'RETURN_STATUS = ' || x_return_status);
1278: FND_LOG.STRING(g_level_statement,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1280: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1281: END IF;
1282: RETURN;
1283:
1284: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1296: THEN
1297:
1298: IF (g_level_procedure >= g_current_runtime_level ) THEN
1299: FND_LOG.STRING(g_level_procedure,
1300: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1301: 'Start performing additional applicability process. ');
1302: END IF;
1303:
1304: /* Start: Added for Bug 4959835 */
1331:
1332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1333: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1334: FND_LOG.STRING(g_level_unexpected,
1335: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1336: 'Incorrect return_status after calling ' ||
1337: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results()');
1338: FND_LOG.STRING(g_level_unexpected,
1339: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1335: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1336: 'Incorrect return_status after calling ' ||
1337: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results()');
1338: FND_LOG.STRING(g_level_unexpected,
1339: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1340: 'RETURN_STATUS = ' || x_return_status);
1341: FND_LOG.STRING(g_level_unexpected,
1342: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1343: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
1338: FND_LOG.STRING(g_level_unexpected,
1339: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1340: 'RETURN_STATUS = ' || x_return_status);
1341: FND_LOG.STRING(g_level_unexpected,
1342: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1343: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
1344: END IF;
1345: RETURN;
1346: END IF;
1380:
1381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1382: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1383: FND_LOG.STRING(g_level_unexpected,
1384: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1385: 'Incorrect return_status after calling ' ||
1386: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1387: FND_LOG.STRING(g_level_unexpected,
1388: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1384: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1385: 'Incorrect return_status after calling ' ||
1386: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1387: FND_LOG.STRING(g_level_unexpected,
1388: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1389: 'RETURN_STATUS = ' || x_return_status);
1390: FND_LOG.STRING(g_level_unexpected,
1391: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1392: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1387: FND_LOG.STRING(g_level_unexpected,
1388: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1389: 'RETURN_STATUS = ' || x_return_status);
1390: FND_LOG.STRING(g_level_unexpected,
1391: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1392: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1393: END IF;
1394: RETURN;
1395: END IF;
1388: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1389: 'RETURN_STATUS = ' || x_return_status);
1390: FND_LOG.STRING(g_level_unexpected,
1391: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1392: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1393: END IF;
1394: RETURN;
1395: END IF;
1396: END IF; -- For provider ID
1445:
1446: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1447: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1448: FND_LOG.STRING(g_level_unexpected,
1449: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1450: 'Incorrect return_status after calling ' ||
1451: 'ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status()');
1452: FND_LOG.STRING(g_level_unexpected,
1453: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1449: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1450: 'Incorrect return_status after calling ' ||
1451: 'ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status()');
1452: FND_LOG.STRING(g_level_unexpected,
1453: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1454: 'RETURN_STATUS = ' || x_return_status);
1455: FND_LOG.STRING(g_level_unexpected,
1456: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1457: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1452: FND_LOG.STRING(g_level_unexpected,
1453: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1454: 'RETURN_STATUS = ' || x_return_status);
1455: FND_LOG.STRING(g_level_unexpected,
1456: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1457: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1458: END IF;
1459: RETURN;
1460: END IF;
1453: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1454: 'RETURN_STATUS = ' || x_return_status);
1455: FND_LOG.STRING(g_level_unexpected,
1456: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1457: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1458: END IF;
1459: RETURN;
1460: END IF;
1461:
1472:
1473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1474: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1475: FND_LOG.STRING(g_level_unexpected,
1476: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1477: 'Incorrect return_status after calling ' ||
1478: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate()');
1479: FND_LOG.STRING(g_level_unexpected,
1480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1476: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1477: 'Incorrect return_status after calling ' ||
1478: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate()');
1479: FND_LOG.STRING(g_level_unexpected,
1480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1481: 'RETURN_STATUS = ' || x_return_status);
1482: FND_LOG.STRING(g_level_unexpected,
1483: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1484: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1479: FND_LOG.STRING(g_level_unexpected,
1480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1481: 'RETURN_STATUS = ' || x_return_status);
1482: FND_LOG.STRING(g_level_unexpected,
1483: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1484: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1485: END IF;
1486: RETURN;
1487: END IF;
1480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1481: 'RETURN_STATUS = ' || x_return_status);
1482: FND_LOG.STRING(g_level_unexpected,
1483: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1484: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1485: END IF;
1486: RETURN;
1487: END IF;
1488:
1499:
1500: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1501: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1502: FND_LOG.STRING(g_level_unexpected,
1503: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1504: 'Incorrect return_status after calling ' || '
1505: ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis()');
1506: FND_LOG.STRING(g_level_unexpected,
1507: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1503: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1504: 'Incorrect return_status after calling ' || '
1505: ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis()');
1506: FND_LOG.STRING(g_level_unexpected,
1507: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1508: 'RETURN_STATUS = ' || x_return_status);
1509: FND_LOG.STRING(g_level_unexpected,
1510: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1511: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1506: FND_LOG.STRING(g_level_unexpected,
1507: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1508: 'RETURN_STATUS = ' || x_return_status);
1509: FND_LOG.STRING(g_level_unexpected,
1510: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1511: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1512: END IF;
1513: RETURN;
1514: END IF;
1507: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1508: 'RETURN_STATUS = ' || x_return_status);
1509: FND_LOG.STRING(g_level_unexpected,
1510: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1511: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1512: END IF;
1513: RETURN;
1514: END IF;
1515:
1526:
1527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1528: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1529: FND_LOG.STRING(g_level_unexpected,
1530: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1531: 'Incorrect return_status after calling ' ||
1532: 'ZX_TDS_CALC_PKG.Get_tax_amount()');
1533: FND_LOG.STRING(g_level_unexpected,
1534: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1530: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1531: 'Incorrect return_status after calling ' ||
1532: 'ZX_TDS_CALC_PKG.Get_tax_amount()');
1533: FND_LOG.STRING(g_level_unexpected,
1534: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1535: 'RETURN_STATUS = ' || x_return_status);
1536: FND_LOG.STRING(g_level_unexpected,
1537: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1538: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1533: FND_LOG.STRING(g_level_unexpected,
1534: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1535: 'RETURN_STATUS = ' || x_return_status);
1536: FND_LOG.STRING(g_level_unexpected,
1537: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1538: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1539: END IF;
1540: RETURN;
1541: END IF;
1534: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1535: 'RETURN_STATUS = ' || x_return_status);
1536: FND_LOG.STRING(g_level_unexpected,
1537: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1538: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1539: END IF;
1540: RETURN;
1541: END IF;
1542:
1565:
1566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1567: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1568: FND_LOG.STRING(g_level_unexpected,
1569: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1570: 'Incorrect return_status after calling ' ||
1571: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
1572: FND_LOG.STRING(g_level_unexpected,
1573: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1569: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1570: 'Incorrect return_status after calling ' ||
1571: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
1572: FND_LOG.STRING(g_level_unexpected,
1573: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1574: 'RETURN_STATUS = ' || x_return_status);
1575: FND_LOG.STRING(g_level_unexpected,
1576: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1577: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1572: FND_LOG.STRING(g_level_unexpected,
1573: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1574: 'RETURN_STATUS = ' || x_return_status);
1575: FND_LOG.STRING(g_level_unexpected,
1576: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1577: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1578: END IF;
1579: RETURN;
1580: END IF;
1573: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1574: 'RETURN_STATUS = ' || x_return_status);
1575: FND_LOG.STRING(g_level_unexpected,
1576: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1577: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1578: END IF;
1579: RETURN;
1580: END IF;
1581: END IF; -- l_begin_index_additional and l_end_index_additional not null
1581: END IF; -- l_begin_index_additional and l_end_index_additional not null
1582:
1583: IF (g_level_event >= g_current_runtime_level ) THEN
1584: FND_LOG.STRING(g_level_event,
1585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1586: 'RETURN_STATUS = ' || x_return_status);
1587: FND_LOG.STRING(g_level_event,
1588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1589: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1584: FND_LOG.STRING(g_level_event,
1585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1586: 'RETURN_STATUS = ' || x_return_status);
1587: FND_LOG.STRING(g_level_event,
1588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1589: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1590: END IF;
1591:
1592: EXCEPTION
1585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1586: 'RETURN_STATUS = ' || x_return_status);
1587: FND_LOG.STRING(g_level_event,
1588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1589: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1590: END IF;
1591:
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595:
1596: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1597: FND_LOG.STRING(g_level_unexpected,
1598: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1599: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1600: FND_LOG.STRING(g_level_unexpected,
1601: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1602: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1597: FND_LOG.STRING(g_level_unexpected,
1598: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1599: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1600: FND_LOG.STRING(g_level_unexpected,
1601: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1602: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1603: END IF;
1604: END calculate_tax_for_import;
1605:
1598: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1599: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1600: FND_LOG.STRING(g_level_unexpected,
1601: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1602: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1603: END IF;
1604: END calculate_tax_for_import;
1605:
1606: /* ======================================================================*
1629: x_return_status := FND_API.G_RET_STS_SUCCESS;
1630:
1631: IF (g_level_event >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_event,
1633: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1634: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1635:
1636: FND_LOG.STRING(g_level_event,
1637: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1630:
1631: IF (g_level_event >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_event,
1633: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1634: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1635:
1636: FND_LOG.STRING(g_level_event,
1637: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1638: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1633: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1634: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1635:
1636: FND_LOG.STRING(g_level_event,
1637: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1638: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1639: FND_LOG.STRING(g_level_event,
1640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1641: 'tax_regime_code := '|| p_tax_line_rec.tax_regime_code);
1636: FND_LOG.STRING(g_level_event,
1637: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1638: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1639: FND_LOG.STRING(g_level_event,
1640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1641: 'tax_regime_code := '|| p_tax_line_rec.tax_regime_code);
1642: END IF;
1643:
1644: -- get tax dates
1687:
1688: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1689: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1690: FND_LOG.STRING(g_level_unexpected,
1691: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1692: 'Incorrect return_status after calling ' ||
1693: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
1694: FND_LOG.STRING(g_level_unexpected,
1695: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1691: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1692: 'Incorrect return_status after calling ' ||
1693: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
1694: FND_LOG.STRING(g_level_unexpected,
1695: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1696: 'RETURN_STATUS = ' || x_return_status);
1697: FND_LOG.STRING(g_level_unexpected,
1698: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1699: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1694: FND_LOG.STRING(g_level_unexpected,
1695: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1696: 'RETURN_STATUS = ' || x_return_status);
1697: FND_LOG.STRING(g_level_unexpected,
1698: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1699: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1700: 'create_detail_tax_line(-)');
1701: END IF;
1702: RETURN;
1695: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1696: 'RETURN_STATUS = ' || x_return_status);
1697: FND_LOG.STRING(g_level_unexpected,
1698: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1699: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1700: 'create_detail_tax_line(-)');
1701: END IF;
1702: RETURN;
1703: END IF;
1714:
1715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1716: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1717: FND_LOG.STRING(g_level_unexpected,
1718: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1719: 'Incorrect return_status after calling ' ||
1720: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
1721: FND_LOG.STRING(g_level_unexpected,
1722: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1718: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1719: 'Incorrect return_status after calling ' ||
1720: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
1721: FND_LOG.STRING(g_level_unexpected,
1722: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1723: 'RETURN_STATUS = ' || x_return_status);
1724: FND_LOG.STRING(g_level_unexpected,
1725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1726: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1721: FND_LOG.STRING(g_level_unexpected,
1722: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1723: 'RETURN_STATUS = ' || x_return_status);
1724: FND_LOG.STRING(g_level_unexpected,
1725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1726: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1727: 'create_detail_tax_line(-)');
1728: END IF;
1729: RETURN;
1722: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1723: 'RETURN_STATUS = ' || x_return_status);
1724: FND_LOG.STRING(g_level_unexpected,
1725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1726: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1727: 'create_detail_tax_line(-)');
1728: END IF;
1729: RETURN;
1730: END IF;
1744:
1745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1746: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1747: FND_LOG.STRING(g_level_unexpected,
1748: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1749: 'Incorrect return_status after calling ' ||
1750: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
1751: FND_LOG.STRING(g_level_unexpected,
1752: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1748: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1749: 'Incorrect return_status after calling ' ||
1750: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
1751: FND_LOG.STRING(g_level_unexpected,
1752: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1753: 'RETURN_STATUS = ' || x_return_status);
1754: FND_LOG.STRING(g_level_unexpected,
1755: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1756: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1751: FND_LOG.STRING(g_level_unexpected,
1752: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1753: 'RETURN_STATUS = ' || x_return_status);
1754: FND_LOG.STRING(g_level_unexpected,
1755: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1756: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1757: 'create_detail_tax_line(-)');
1758: END IF;
1759: RETURN;
1752: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1753: 'RETURN_STATUS = ' || x_return_status);
1754: FND_LOG.STRING(g_level_unexpected,
1755: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1756: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1757: 'create_detail_tax_line(-)');
1758: END IF;
1759: RETURN;
1760: END IF;
1773:
1774: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1775: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1776: FND_LOG.STRING(g_level_unexpected,
1777: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1778: 'Incorrect return_status after calling ' ||
1779: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
1780: FND_LOG.STRING(g_level_unexpected,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1777: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1778: 'Incorrect return_status after calling ' ||
1779: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
1780: FND_LOG.STRING(g_level_unexpected,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1782: 'RETURN_STATUS = ' || x_return_status);
1783: FND_LOG.STRING(g_level_unexpected,
1784: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1785: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1780: FND_LOG.STRING(g_level_unexpected,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1782: 'RETURN_STATUS = ' || x_return_status);
1783: FND_LOG.STRING(g_level_unexpected,
1784: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1785: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1786: 'create_detail_tax_line(-)');
1787: END IF;
1788: RETURN;
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1782: 'RETURN_STATUS = ' || x_return_status);
1783: FND_LOG.STRING(g_level_unexpected,
1784: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1785: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1786: 'create_detail_tax_line(-)');
1787: END IF;
1788: RETURN;
1789: END IF;
1808:
1809: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1810: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1811: FND_LOG.STRING(g_level_unexpected,
1812: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1813: 'After calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
1814: FND_LOG.STRING(g_level_unexpected,
1815: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1816: 'RETURN_STATUS = ' || x_return_status);
1811: FND_LOG.STRING(g_level_unexpected,
1812: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1813: 'After calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
1814: FND_LOG.STRING(g_level_unexpected,
1815: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1816: 'RETURN_STATUS = ' || x_return_status);
1817: FND_LOG.STRING(g_level_unexpected,
1818: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1819: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1814: FND_LOG.STRING(g_level_unexpected,
1815: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1816: 'RETURN_STATUS = ' || x_return_status);
1817: FND_LOG.STRING(g_level_unexpected,
1818: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1819: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1820: 'create_detail_tax_line(-)');
1821: END IF;
1822: RETURN;
1815: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1816: 'RETURN_STATUS = ' || x_return_status);
1817: FND_LOG.STRING(g_level_unexpected,
1818: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1819: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1820: 'create_detail_tax_line(-)');
1821: END IF;
1822: RETURN;
1823: END IF;
1823: END IF;
1824:
1825: IF (g_level_event >= g_current_runtime_level ) THEN
1826: FND_LOG.STRING(g_level_event,
1827: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1828: 'summary_tax_line_number := '||
1829: p_tax_line_rec.summary_tax_line_number);
1830: FND_LOG.STRING(g_level_event,
1831: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1827: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1828: 'summary_tax_line_number := '||
1829: p_tax_line_rec.summary_tax_line_number);
1830: FND_LOG.STRING(g_level_event,
1831: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1832: 'tax_regime_code := ' || p_tax_line_rec.tax_regime_code);
1833: FND_LOG.STRING(g_level_event,
1834: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1835: 'tax := ' || p_tax_line_rec.tax);
1830: FND_LOG.STRING(g_level_event,
1831: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1832: 'tax_regime_code := ' || p_tax_line_rec.tax_regime_code);
1833: FND_LOG.STRING(g_level_event,
1834: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1835: 'tax := ' || p_tax_line_rec.tax);
1836: END IF;
1837:
1838: -- populate tax_line_id from Sequence
2002: */
2003:
2004: IF (g_level_event >= g_current_runtime_level ) THEN
2005: FND_LOG.STRING(g_level_event,
2006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2007: 'RETURN_STATUS = ' || x_return_status);
2008: FND_LOG.STRING(g_level_event,
2009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2010: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2005: FND_LOG.STRING(g_level_event,
2006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2007: 'RETURN_STATUS = ' || x_return_status);
2008: FND_LOG.STRING(g_level_event,
2009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2010: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2011: END IF;
2012:
2013: EXCEPTION
2006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2007: 'RETURN_STATUS = ' || x_return_status);
2008: FND_LOG.STRING(g_level_event,
2009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2010: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2011: END IF;
2012:
2013: EXCEPTION
2014: WHEN OTHERS THEN
2015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2016:
2017: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2018: FND_LOG.STRING(g_level_unexpected,
2019: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2020: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2021: FND_LOG.STRING(g_level_unexpected,
2022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2023: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2018: FND_LOG.STRING(g_level_unexpected,
2019: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2020: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2021: FND_LOG.STRING(g_level_unexpected,
2022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2023: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2024: END IF;
2025:
2026: END create_detail_tax_line;
2019: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2020: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2021: FND_LOG.STRING(g_level_unexpected,
2022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2023: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2024: END IF;
2025:
2026: END create_detail_tax_line;
2027:
2084: BEGIN
2085:
2086: IF (g_level_procedure >= g_current_runtime_level ) THEN
2087: FND_LOG.STRING(g_level_procedure,
2088: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2089: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2090: FND_LOG.STRING(g_level_procedure,
2091: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2092: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2085:
2086: IF (g_level_procedure >= g_current_runtime_level ) THEN
2087: FND_LOG.STRING(g_level_procedure,
2088: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2089: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2090: FND_LOG.STRING(g_level_procedure,
2091: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2092: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2093: END IF;
2087: FND_LOG.STRING(g_level_procedure,
2088: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2089: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2090: FND_LOG.STRING(g_level_procedure,
2091: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2092: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2093: END IF;
2094:
2095: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140:
2141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2142: IF (g_level_statement >= g_current_runtime_level ) THEN
2143: FND_LOG.STRING(g_level_statement,
2144: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2145: 'Incorrect return_status after calling ' ||
2146: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2147: FND_LOG.STRING(g_level_statement,
2148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2144: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2145: 'Incorrect return_status after calling ' ||
2146: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2147: FND_LOG.STRING(g_level_statement,
2148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2149: 'RETURN_STATUS = ' || x_return_status);
2150: FND_LOG.STRING(g_level_statement,
2151: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2152: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2147: FND_LOG.STRING(g_level_statement,
2148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2149: 'RETURN_STATUS = ' || x_return_status);
2150: FND_LOG.STRING(g_level_statement,
2151: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2152: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2153: END IF;
2154: RETURN;
2155: END IF;
2170:
2171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2172: IF (g_level_statement >= g_current_runtime_level ) THEN
2173: FND_LOG.STRING(g_level_statement,
2174: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2175: 'Incorrect return_status after calling ' ||
2176: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2177: FND_LOG.STRING(g_level_statement,
2178: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2174: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2175: 'Incorrect return_status after calling ' ||
2176: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2177: FND_LOG.STRING(g_level_statement,
2178: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2179: 'RETURN_STATUS = ' || x_return_status);
2180: FND_LOG.STRING(g_level_statement,
2181: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2182: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2177: FND_LOG.STRING(g_level_statement,
2178: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2179: 'RETURN_STATUS = ' || x_return_status);
2180: FND_LOG.STRING(g_level_statement,
2181: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2182: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2183: END IF;
2184: RETURN;
2185: END IF;
2211:
2212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2213: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2214: FND_LOG.STRING(g_level_unexpected,
2215: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2216: 'Incorrect return_status after calling ' ||
2217: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
2218: FND_LOG.STRING(g_level_unexpected,
2219: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2215: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2216: 'Incorrect return_status after calling ' ||
2217: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
2218: FND_LOG.STRING(g_level_unexpected,
2219: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2220: 'RETURN_STATUS = ' || x_return_status);
2221: FND_LOG.STRING(g_level_unexpected,
2222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2223: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
2218: FND_LOG.STRING(g_level_unexpected,
2219: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2220: 'RETURN_STATUS = ' || x_return_status);
2221: FND_LOG.STRING(g_level_unexpected,
2222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2223: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
2224: 'create_detail_tax_line(-)');
2225: END IF;
2226: RETURN;
2219: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2220: 'RETURN_STATUS = ' || x_return_status);
2221: FND_LOG.STRING(g_level_unexpected,
2222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2223: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
2224: 'create_detail_tax_line(-)');
2225: END IF;
2226: RETURN;
2227: END IF;
2244:
2245: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2246: IF (g_level_statement >= g_current_runtime_level ) THEN
2247: FND_LOG.STRING(g_level_statement,
2248: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2249: 'Incorrect return_status after calling ' ||
2250: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2248: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2249: 'Incorrect return_status after calling ' ||
2250: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2253: 'RETURN_STATUS = ' || x_return_status);
2254: FND_LOG.STRING(g_level_statement,
2255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2256: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2253: 'RETURN_STATUS = ' || x_return_status);
2254: FND_LOG.STRING(g_level_statement,
2255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2256: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2257: END IF;
2258: RETURN;
2259: END IF;
2325:
2326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2327: IF (g_level_statement >= g_current_runtime_level ) THEN
2328: FND_LOG.STRING(g_level_statement,
2329: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2330: 'Incorrect return_status after calling ' ||
2331: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
2332: FND_LOG.STRING(g_level_statement,
2333: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2329: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2330: 'Incorrect return_status after calling ' ||
2331: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
2332: FND_LOG.STRING(g_level_statement,
2333: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2334: 'RETURN_STATUS = ' || x_return_status);
2335: FND_LOG.STRING(g_level_statement,
2336: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2337: 'ZX_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2332: FND_LOG.STRING(g_level_statement,
2333: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2334: 'RETURN_STATUS = ' || x_return_status);
2335: FND_LOG.STRING(g_level_statement,
2336: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2337: 'ZX_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2338: END IF;
2339: RETURN;
2340: END IF;
2474:
2475: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2476: IF (g_level_statement >= g_current_runtime_level ) THEN
2477: FND_LOG.STRING(g_level_statement,
2478: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2479: 'Incorrect return_status after calling ' ||
2480: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2481: FND_LOG.STRING(g_level_statement,
2482: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2478: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2479: 'Incorrect return_status after calling ' ||
2480: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2481: FND_LOG.STRING(g_level_statement,
2482: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2483: 'RETURN_STATUS = ' || x_return_status);
2484: FND_LOG.STRING(g_level_statement,
2485: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2486: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2481: FND_LOG.STRING(g_level_statement,
2482: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2483: 'RETURN_STATUS = ' || x_return_status);
2484: FND_LOG.STRING(g_level_statement,
2485: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2486: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2487: END IF;
2488: RETURN;
2489: END IF;
2482: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2483: 'RETURN_STATUS = ' || x_return_status);
2484: FND_LOG.STRING(g_level_statement,
2485: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2486: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2487: END IF;
2488: RETURN;
2489: END IF;
2490:
2489: END IF;
2490:
2491: IF (g_level_procedure >= g_current_runtime_level ) THEN
2492: FND_LOG.STRING(g_level_procedure,
2493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2494: 'x_begin_index = ' || to_char(x_begin_index));
2495: FND_LOG.STRING(g_level_procedure,
2496: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2497: 'x_end_index = ' || to_char(x_end_index));
2492: FND_LOG.STRING(g_level_procedure,
2493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2494: 'x_begin_index = ' || to_char(x_begin_index));
2495: FND_LOG.STRING(g_level_procedure,
2496: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2497: 'x_end_index = ' || to_char(x_end_index));
2498: FND_LOG.STRING(g_level_procedure,
2499: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2500: 'RETURN_STATUS = ' || x_return_status);
2495: FND_LOG.STRING(g_level_procedure,
2496: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2497: 'x_end_index = ' || to_char(x_end_index));
2498: FND_LOG.STRING(g_level_procedure,
2499: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2500: 'RETURN_STATUS = ' || x_return_status);
2501: FND_LOG.STRING(g_level_procedure,
2502: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2503: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2498: FND_LOG.STRING(g_level_procedure,
2499: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2500: 'RETURN_STATUS = ' || x_return_status);
2501: FND_LOG.STRING(g_level_procedure,
2502: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2503: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2504: END IF;
2505:
2506: EXCEPTION
2499: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2500: 'RETURN_STATUS = ' || x_return_status);
2501: FND_LOG.STRING(g_level_procedure,
2502: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2503: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2504: END IF;
2505:
2506: EXCEPTION
2507: WHEN OTHERS THEN
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509:
2510: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2511: FND_LOG.STRING(g_level_unexpected,
2512: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2513: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2514: FND_LOG.STRING(g_level_unexpected,
2515: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2516: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2511: FND_LOG.STRING(g_level_unexpected,
2512: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2513: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2514: FND_LOG.STRING(g_level_unexpected,
2515: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2516: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2517: END IF;
2518:
2519: END get_taxes_from_applied_from;
2512: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2513: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2514: FND_LOG.STRING(g_level_unexpected,
2515: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2516: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2517: END IF;
2518:
2519: END get_taxes_from_applied_from;
2520:
2590: BEGIN
2591:
2592: IF (g_level_procedure >= g_current_runtime_level ) THEN
2593: FND_LOG.STRING(g_level_procedure,
2594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2596: FND_LOG.STRING(g_level_procedure,
2597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2598: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2591:
2592: IF (g_level_procedure >= g_current_runtime_level ) THEN
2593: FND_LOG.STRING(g_level_procedure,
2594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2596: FND_LOG.STRING(g_level_procedure,
2597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2598: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2599: END IF;
2593: FND_LOG.STRING(g_level_procedure,
2594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2596: FND_LOG.STRING(g_level_procedure,
2597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2598: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2599: END IF;
2600:
2601: x_return_status := FND_API.G_RET_STS_SUCCESS;
2636:
2637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2638: IF (g_level_statement >= g_current_runtime_level ) THEN
2639: FND_LOG.STRING(g_level_statement,
2640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2641: 'Incorrect return_status after calling ' ||
2642: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
2643: FND_LOG.STRING(g_level_statement,
2644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2641: 'Incorrect return_status after calling ' ||
2642: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
2643: FND_LOG.STRING(g_level_statement,
2644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2645: 'RETURN_STATUS = ' || x_return_status);
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
2648: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
2643: FND_LOG.STRING(g_level_statement,
2644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2645: 'RETURN_STATUS = ' || x_return_status);
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
2648: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
2649: END IF;
2650:
2651: RETURN;
2644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2645: 'RETURN_STATUS = ' || x_return_status);
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
2648: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
2649: END IF;
2650:
2651: RETURN;
2652: END IF;
2762: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
2763: THEN
2764: IF (g_level_statement >= g_current_runtime_level ) THEN
2765: FND_LOG.STRING(g_level_statement,
2766: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2767: 'Current trx is a tax only adjustment. ');
2768: END IF;
2769:
2770: -- for tax only adjustment set the unrounded tax amount to the
2778: -- current trx is a regular adjustment or CM
2779: -- prorate the line amt to get the unrounded taxable/tax amount
2780: IF (g_level_statement >= g_current_runtime_level ) THEN
2781: FND_LOG.STRING(g_level_statement,
2782: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2783: 'tax_amt_included_flag on Current tax line: '||
2784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2785: l_new_row_num).tax_amt_included_flag);
2786: FND_LOG.STRING(g_level_statement,
2783: 'tax_amt_included_flag on Current tax line: '||
2784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2785: l_new_row_num).tax_amt_included_flag);
2786: FND_LOG.STRING(g_level_statement,
2787: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2788: 'tax_amt_included_flag on original tax line: '||
2789: tax_line_rec.tax_amt_included_flag);
2790: END IF;
2791:
3036:
3037: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3038: IF (g_level_statement >= g_current_runtime_level ) THEN
3039: FND_LOG.STRING(g_level_statement,
3040: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3041: 'Incorrect return_status after calling ' ||
3042: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3043: FND_LOG.STRING(g_level_statement,
3044: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3040: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3041: 'Incorrect return_status after calling ' ||
3042: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3043: FND_LOG.STRING(g_level_statement,
3044: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3045: 'RETURN_STATUS = ' || x_return_status);
3046: FND_LOG.STRING(g_level_statement,
3047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3048: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3043: FND_LOG.STRING(g_level_statement,
3044: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3045: 'RETURN_STATUS = ' || x_return_status);
3046: FND_LOG.STRING(g_level_statement,
3047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3048: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3049: END IF;
3050: RETURN;
3051: END IF;
3044: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3045: 'RETURN_STATUS = ' || x_return_status);
3046: FND_LOG.STRING(g_level_statement,
3047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3048: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3049: END IF;
3050: RETURN;
3051: END IF;
3052:
3051: END IF;
3052:
3053: IF (g_level_procedure >= g_current_runtime_level ) THEN
3054: FND_LOG.STRING(g_level_procedure,
3055: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3056: 'x_begin_index = ' || to_char(x_begin_index));
3057: FND_LOG.STRING(g_level_procedure,
3058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3059: 'x_end_index = ' || to_char(x_end_index));
3054: FND_LOG.STRING(g_level_procedure,
3055: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3056: 'x_begin_index = ' || to_char(x_begin_index));
3057: FND_LOG.STRING(g_level_procedure,
3058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3059: 'x_end_index = ' || to_char(x_end_index));
3060: FND_LOG.STRING(g_level_procedure,
3061: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3062: 'RETURN_STATUS = ' || x_return_status);
3057: FND_LOG.STRING(g_level_procedure,
3058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3059: 'x_end_index = ' || to_char(x_end_index));
3060: FND_LOG.STRING(g_level_procedure,
3061: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3062: 'RETURN_STATUS = ' || x_return_status);
3063: FND_LOG.STRING(g_level_procedure,
3064: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3065: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3060: FND_LOG.STRING(g_level_procedure,
3061: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3062: 'RETURN_STATUS = ' || x_return_status);
3063: FND_LOG.STRING(g_level_procedure,
3064: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3065: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3066: END IF;
3067:
3068: EXCEPTION
3061: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3062: 'RETURN_STATUS = ' || x_return_status);
3063: FND_LOG.STRING(g_level_procedure,
3064: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3065: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3066: END IF;
3067:
3068: EXCEPTION
3069: WHEN OTHERS THEN
3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3071:
3072: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3073: FND_LOG.STRING(g_level_unexpected,
3074: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3075: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3076: FND_LOG.STRING(g_level_unexpected,
3077: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3078: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3073: FND_LOG.STRING(g_level_unexpected,
3074: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3075: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3076: FND_LOG.STRING(g_level_unexpected,
3077: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3078: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3079: END IF;
3080:
3081: END get_taxes_from_adjusted_to;
3074: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3075: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3076: FND_LOG.STRING(g_level_unexpected,
3077: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3078: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3079: END IF;
3080:
3081: END get_taxes_from_adjusted_to;
3082:
3079: END IF;
3080:
3081: END get_taxes_from_adjusted_to;
3082:
3083: END ZX_TDS_IMPORT_DOCUMENT_PKG;