[Home] [Help]
1: PACKAGE BODY ZX_TDS_IMPORT_DOCUMENT_PKG AS
2: /* $Header: zxdiimpdocmtpkgb.pls 120.81.12020000.2 2012/07/23 12:52:42 srajapar noship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
386: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
387:
388: IF (g_level_event >= g_current_runtime_level ) THEN
389: FND_LOG.STRING(g_level_event,
390: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.BEGIN',
391: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(+)');
392: END IF;
393:
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: IF (g_level_event >= g_current_runtime_level ) THEN
389: FND_LOG.STRING(g_level_event,
390: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.BEGIN',
391: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(+)');
392: END IF;
393:
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395:
432:
433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
434: IF (g_level_unexpected >= g_current_runtime_level ) THEN
435: FND_LOG.STRING(g_level_unexpected,
436: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
437: 'Incorrect return_status after calling '||
438: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
439: FND_LOG.STRING(g_level_unexpected,
440: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
434: IF (g_level_unexpected >= g_current_runtime_level ) THEN
435: FND_LOG.STRING(g_level_unexpected,
436: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
437: 'Incorrect return_status after calling '||
438: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
439: FND_LOG.STRING(g_level_unexpected,
440: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
441: 'RETURN_STATUS = ' || x_return_status);
442: FND_LOG.STRING(g_level_unexpected,
436: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
437: 'Incorrect return_status after calling '||
438: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
439: FND_LOG.STRING(g_level_unexpected,
440: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
441: 'RETURN_STATUS = ' || x_return_status);
442: FND_LOG.STRING(g_level_unexpected,
443: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
444: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
439: FND_LOG.STRING(g_level_unexpected,
440: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
441: 'RETURN_STATUS = ' || x_return_status);
442: FND_LOG.STRING(g_level_unexpected,
443: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
444: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
445: END IF;
446: RETURN;
447: END IF;
440: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
441: 'RETURN_STATUS = ' || x_return_status);
442: FND_LOG.STRING(g_level_unexpected,
443: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
444: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
445: END IF;
446: RETURN;
447: END IF;
448:
532: x_return_status := FND_API.G_RET_STS_ERROR;
533:
534: IF (g_level_event >= g_current_runtime_level ) THEN
535: FND_LOG.STRING(g_level_event,
536: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
537: 'tax_amt from summary tax line is not 0, ' ||
538: 'but the total line amount for the allocated trx lines is 0.'
539: || 'Cannot do proration.');
540: FND_LOG.STRING(g_level_event,
537: 'tax_amt from summary tax line is not 0, ' ||
538: 'but the total line amount for the allocated trx lines is 0.'
539: || 'Cannot do proration.');
540: FND_LOG.STRING(g_level_event,
541: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
542: 'Summary_tax_line_number = ' ||
543: tax_line_rec.summary_tax_line_number);
544: FND_LOG.STRING(g_level_event,
545: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
541: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
542: 'Summary_tax_line_number = ' ||
543: tax_line_rec.summary_tax_line_number);
544: FND_LOG.STRING(g_level_event,
545: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
546: 'RETURN_STATUS = ' || x_return_status);
547: FND_LOG.STRING(g_level_event,
548: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
549: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
544: FND_LOG.STRING(g_level_event,
545: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
546: 'RETURN_STATUS = ' || x_return_status);
547: FND_LOG.STRING(g_level_event,
548: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
549: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
550: 'prorate_imported_sum_tax_lines(-)');
551: END IF;
552: RETURN;
545: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
546: 'RETURN_STATUS = ' || x_return_status);
547: FND_LOG.STRING(g_level_event,
548: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
549: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
550: 'prorate_imported_sum_tax_lines(-)');
551: END IF;
552: RETURN;
553: ELSE
577:
578: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
579: IF (g_level_unexpected >= g_current_runtime_level ) THEN
580: FND_LOG.STRING(g_level_unexpected,
581: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
582: 'Incorrect return_status after calling ' ||
583: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
584: FND_LOG.STRING(g_level_unexpected,
585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
581: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
582: 'Incorrect return_status after calling ' ||
583: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
584: FND_LOG.STRING(g_level_unexpected,
585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
586: 'RETURN_STATUS = ' || x_return_status);
587: FND_LOG.STRING(g_level_unexpected,
588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
589: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
584: FND_LOG.STRING(g_level_unexpected,
585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
586: 'RETURN_STATUS = ' || x_return_status);
587: FND_LOG.STRING(g_level_unexpected,
588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
589: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
590: END IF;
591: RETURN;
592: END IF;
585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
586: 'RETURN_STATUS = ' || x_return_status);
587: FND_LOG.STRING(g_level_unexpected,
588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
589: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
590: END IF;
591: RETURN;
592: END IF;
593:
657:
658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
659: IF (g_level_unexpected >= g_current_runtime_level ) THEN
660: FND_LOG.STRING(g_level_unexpected,
661: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
662: 'Incorrect return_status after calling '||
663: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
664: FND_LOG.STRING(g_level_unexpected,
665: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
659: IF (g_level_unexpected >= g_current_runtime_level ) THEN
660: FND_LOG.STRING(g_level_unexpected,
661: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
662: 'Incorrect return_status after calling '||
663: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
664: FND_LOG.STRING(g_level_unexpected,
665: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
666: 'RETURN_STATUS = ' || x_return_status);
667: FND_LOG.STRING(g_level_unexpected,
661: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
662: 'Incorrect return_status after calling '||
663: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
664: FND_LOG.STRING(g_level_unexpected,
665: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
666: 'RETURN_STATUS = ' || x_return_status);
667: FND_LOG.STRING(g_level_unexpected,
668: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
669: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
664: FND_LOG.STRING(g_level_unexpected,
665: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
666: 'RETURN_STATUS = ' || x_return_status);
667: FND_LOG.STRING(g_level_unexpected,
668: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
669: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
670: END IF;
671: RETURN;
672: END IF;
665: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
666: 'RETURN_STATUS = ' || x_return_status);
667: FND_LOG.STRING(g_level_unexpected,
668: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
669: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
670: END IF;
671: RETURN;
672: END IF;
673:
746: x_return_status := FND_API.G_RET_STS_ERROR;
747:
748: IF (g_level_event >= g_current_runtime_level ) THEN
749: FND_LOG.STRING(g_level_event,
750: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
751: 'tax_amt from summary tax line is not 0, ' ||
752: 'but the total line amount for the allocated trx lines is 0.'
753: || 'Cannot do proration.');
754: FND_LOG.STRING(g_level_event,
751: 'tax_amt from summary tax line is not 0, ' ||
752: 'but the total line amount for the allocated trx lines is 0.'
753: || 'Cannot do proration.');
754: FND_LOG.STRING(g_level_event,
755: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
756: 'Summary_tax_line_number = ' ||
757: tax_line_rec.summary_tax_line_number);
758: FND_LOG.STRING(g_level_event,
759: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
755: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
756: 'Summary_tax_line_number = ' ||
757: tax_line_rec.summary_tax_line_number);
758: FND_LOG.STRING(g_level_event,
759: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
760: 'RETURN_STATUS = ' || x_return_status);
761: FND_LOG.STRING(g_level_event,
762: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
763: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
758: FND_LOG.STRING(g_level_event,
759: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
760: 'RETURN_STATUS = ' || x_return_status);
761: FND_LOG.STRING(g_level_event,
762: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
763: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
764: 'prorate_imported_sum_tax_lines(-)');
765: END IF;
766: RETURN;
759: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
760: 'RETURN_STATUS = ' || x_return_status);
761: FND_LOG.STRING(g_level_event,
762: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
763: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
764: 'prorate_imported_sum_tax_lines(-)');
765: END IF;
766: RETURN;
767: ELSE
792:
793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
794: IF (g_level_unexpected >= g_current_runtime_level ) THEN
795: FND_LOG.STRING(g_level_unexpected,
796: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
797: 'Incorrect return_status after calling ' ||
798: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
799: FND_LOG.STRING(g_level_unexpected,
800: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
796: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
797: 'Incorrect return_status after calling ' ||
798: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
799: FND_LOG.STRING(g_level_unexpected,
800: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
801: 'RETURN_STATUS = ' || x_return_status);
802: FND_LOG.STRING(g_level_unexpected,
803: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
804: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
799: FND_LOG.STRING(g_level_unexpected,
800: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
801: 'RETURN_STATUS = ' || x_return_status);
802: FND_LOG.STRING(g_level_unexpected,
803: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
804: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
805: END IF;
806: RETURN;
807: END IF;
800: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
801: 'RETURN_STATUS = ' || x_return_status);
802: FND_LOG.STRING(g_level_unexpected,
803: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
804: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
805: END IF;
806: RETURN;
807: END IF;
808:
865:
866: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
867: IF (g_level_unexpected >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_unexpected,
869: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
870: 'Incorrect return_status after calling '||
871: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
872: FND_LOG.STRING(g_level_unexpected,
873: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
867: IF (g_level_unexpected >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_unexpected,
869: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
870: 'Incorrect return_status after calling '||
871: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
872: FND_LOG.STRING(g_level_unexpected,
873: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
874: 'RETURN_STATUS = ' || x_return_status);
875: FND_LOG.STRING(g_level_unexpected,
869: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
870: 'Incorrect return_status after calling '||
871: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
872: FND_LOG.STRING(g_level_unexpected,
873: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
874: 'RETURN_STATUS = ' || x_return_status);
875: FND_LOG.STRING(g_level_unexpected,
876: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
877: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
872: FND_LOG.STRING(g_level_unexpected,
873: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
874: 'RETURN_STATUS = ' || x_return_status);
875: FND_LOG.STRING(g_level_unexpected,
876: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
877: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
878: END IF;
879: RETURN;
880: END IF;
873: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
874: 'RETURN_STATUS = ' || x_return_status);
875: FND_LOG.STRING(g_level_unexpected,
876: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
877: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
878: END IF;
879: RETURN;
880: END IF;
881:
925:
926: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
927: IF (g_level_unexpected >= g_current_runtime_level ) THEN
928: FND_LOG.STRING(g_level_unexpected,
929: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
930: 'Incorrect return_status after calling ' ||
931: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
932: FND_LOG.STRING(g_level_unexpected,
933: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
929: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
930: 'Incorrect return_status after calling ' ||
931: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
932: FND_LOG.STRING(g_level_unexpected,
933: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
934: 'RETURN_STATUS = ' || x_return_status);
935: FND_LOG.STRING(g_level_unexpected,
936: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
937: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
932: FND_LOG.STRING(g_level_unexpected,
933: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
934: 'RETURN_STATUS = ' || x_return_status);
935: FND_LOG.STRING(g_level_unexpected,
936: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
937: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
938: END IF;
939: RETURN;
940: END IF;
933: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
934: 'RETURN_STATUS = ' || x_return_status);
935: FND_LOG.STRING(g_level_unexpected,
936: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
937: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
938: END IF;
939: RETURN;
940: END IF;
941:
940: END IF;
941:
942: IF (g_level_event >= g_current_runtime_level ) THEN
943: FND_LOG.STRING(g_level_event,
944: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
945: 'Detail tax lines created from imported summary tax lines:');
946: FND_LOG.STRING(g_level_event,
947: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
948: 'l_begin_index = ' || l_begin_index);
943: FND_LOG.STRING(g_level_event,
944: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
945: 'Detail tax lines created from imported summary tax lines:');
946: FND_LOG.STRING(g_level_event,
947: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
948: 'l_begin_index = ' || l_begin_index);
949: FND_LOG.STRING(g_level_event,
950: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
951: 'l_end_index = ' || l_end_index);
946: FND_LOG.STRING(g_level_event,
947: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
948: 'l_begin_index = ' || l_begin_index);
949: FND_LOG.STRING(g_level_event,
950: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
951: 'l_end_index = ' || l_end_index);
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
954: 'RETURN_STATUS = ' || x_return_status);
949: FND_LOG.STRING(g_level_event,
950: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
951: 'l_end_index = ' || l_end_index);
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
954: 'RETURN_STATUS = ' || x_return_status);
955: FND_LOG.STRING(g_level_event,
956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
957: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
954: 'RETURN_STATUS = ' || x_return_status);
955: FND_LOG.STRING(g_level_event,
956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
957: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
958: END IF;
959:
960: EXCEPTION
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
954: 'RETURN_STATUS = ' || x_return_status);
955: FND_LOG.STRING(g_level_event,
956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
957: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
958: END IF;
959:
960: EXCEPTION
961: WHEN OTHERS THEN
962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963:
964: IF (g_level_unexpected >= g_current_runtime_level ) THEN
965: FND_LOG.STRING(g_level_unexpected,
966: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
967: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
968: FND_LOG.STRING(g_level_unexpected,
969: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
970: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
965: FND_LOG.STRING(g_level_unexpected,
966: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
967: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
968: FND_LOG.STRING(g_level_unexpected,
969: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
970: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
971: END IF;
972:
973: END prorate_imported_sum_tax_lines;
966: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
967: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
968: FND_LOG.STRING(g_level_unexpected,
969: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
970: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
971: END IF;
972:
973: END prorate_imported_sum_tax_lines;
974:
1054: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1055:
1056: IF (g_level_event >= g_current_runtime_level ) THEN
1057: FND_LOG.STRING(g_level_event,
1058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.BEGIN',
1059: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(+)');
1060: END IF;
1061:
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1055:
1056: IF (g_level_event >= g_current_runtime_level ) THEN
1057: FND_LOG.STRING(g_level_event,
1058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.BEGIN',
1059: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(+)');
1060: END IF;
1061:
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1125:
1126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: IF (g_level_statement >= g_current_runtime_level ) THEN
1128: FND_LOG.STRING(g_level_statement,
1129: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1130: 'Incorrect return_status after calling ' ||
1131: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
1132: FND_LOG.STRING(g_level_statement,
1133: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1129: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1130: 'Incorrect return_status after calling ' ||
1131: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
1132: FND_LOG.STRING(g_level_statement,
1133: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1134: 'RETURN_STATUS = ' || x_return_status);
1135: FND_LOG.STRING(g_level_statement,
1136: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1137: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1132: FND_LOG.STRING(g_level_statement,
1133: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1134: 'RETURN_STATUS = ' || x_return_status);
1135: FND_LOG.STRING(g_level_statement,
1136: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1137: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1138: END IF;
1139: RETURN;
1140: END IF;
1133: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1134: 'RETURN_STATUS = ' || x_return_status);
1135: FND_LOG.STRING(g_level_statement,
1136: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1137: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1138: END IF;
1139: RETURN;
1140: END IF;
1141: l_reporting_code_id:= ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(
1154:
1155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1156: IF (g_level_statement >= g_current_runtime_level ) THEN
1157: FND_LOG.STRING(g_level_statement,
1158: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1159: 'Incorrect return_status after calling ' ||
1160: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration');
1161: FND_LOG.STRING(g_level_statement,
1162: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1158: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1159: 'Incorrect return_status after calling ' ||
1160: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration');
1161: FND_LOG.STRING(g_level_statement,
1162: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1163: 'RETURN_STATUS = ' || x_return_status);
1164: FND_LOG.STRING(g_level_statement,
1165: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1166: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1161: FND_LOG.STRING(g_level_statement,
1162: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1163: 'RETURN_STATUS = ' || x_return_status);
1164: FND_LOG.STRING(g_level_statement,
1165: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1166: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1167: END IF;
1168: RETURN;
1169: END IF;
1162: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1163: 'RETURN_STATUS = ' || x_return_status);
1164: FND_LOG.STRING(g_level_statement,
1165: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1166: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1167: END IF;
1168: RETURN;
1169: END IF;
1170:
1204: ELSE
1205: x_return_status := FND_API.G_RET_STS_ERROR;
1206: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1207: FND_LOG.STRING(g_level_unexpected,
1208: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1209: 'Tax_rate = 0, tax_amt <> 0. ' ||
1210: 'Cannot calculate taxable basis amount.');
1211: FND_LOG.STRING(g_level_unexpected,
1212: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1208: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1209: 'Tax_rate = 0, tax_amt <> 0. ' ||
1210: 'Cannot calculate taxable basis amount.');
1211: FND_LOG.STRING(g_level_unexpected,
1212: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1213: 'x_return_status = ' || x_return_status);
1214: FND_LOG.STRING(g_level_unexpected,
1215: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1216: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1211: FND_LOG.STRING(g_level_unexpected,
1212: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1213: 'x_return_status = ' || x_return_status);
1214: FND_LOG.STRING(g_level_unexpected,
1215: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1216: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1217: END IF;
1218:
1219: FND_MESSAGE.SET_NAME('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
1241:
1242: IF get_key_columns_cur%FOUND THEN
1243: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).adjusted_doc_tax_line_id := l_adjusted_doc_tax_line_id;
1244: IF (g_level_event >= g_current_runtime_level ) THEN
1245: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1246: 'l_adjusted_doc_tax_line_id: ' || l_adjusted_doc_tax_line_id);
1247: END IF;
1248: END IF;
1249: CLOSE get_key_columns_cur;
1271: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1272:
1273: IF (g_level_procedure >= g_current_runtime_level ) THEN
1274: FND_LOG.STRING(g_level_procedure,
1275: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1276: 'Begin_index and end_index for detail tax lines created ' ||
1277: 'from summary tax_line');
1278: FND_LOG.STRING(g_level_procedure,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1275: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1276: 'Begin_index and end_index for detail tax lines created ' ||
1277: 'from summary tax_line');
1278: FND_LOG.STRING(g_level_procedure,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1280: 'l_begin_index :=' || l_begin_index);
1281: FND_LOG.STRING(g_level_procedure,
1282: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1283: 'l_end_index :=' || l_end_index);
1278: FND_LOG.STRING(g_level_procedure,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1280: 'l_begin_index :=' || l_begin_index);
1281: FND_LOG.STRING(g_level_procedure,
1282: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1283: 'l_end_index :=' || l_end_index);
1284: END IF;
1285:
1286: -- copy transaction information
1294:
1295: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1296: IF (g_level_statement >= g_current_runtime_level ) THEN
1297: FND_LOG.STRING(g_level_statement,
1298: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1299: 'Incorrect return_status after calling '||
1300: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1301: FND_LOG.STRING(g_level_statement,
1302: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1298: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1299: 'Incorrect return_status after calling '||
1300: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1301: FND_LOG.STRING(g_level_statement,
1302: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1303: 'RETURN_STATUS = ' || x_return_status);
1304: FND_LOG.STRING(g_level_statement,
1305: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1306: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1301: FND_LOG.STRING(g_level_statement,
1302: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1303: 'RETURN_STATUS = ' || x_return_status);
1304: FND_LOG.STRING(g_level_statement,
1305: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1306: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1307: END IF;
1308: RETURN;
1309: END IF;
1302: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1303: 'RETURN_STATUS = ' || x_return_status);
1304: FND_LOG.STRING(g_level_statement,
1305: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1306: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1307: END IF;
1308: RETURN;
1309: END IF;
1310:
1359:
1360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1361: IF g_level_unexpected >= g_current_runtime_level THEN
1362: FND_LOG.STRING(g_level_unexpected,
1363: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1364: 'Incorrect return_status after calling ' ||
1365: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_adjusted_to()');
1366: FND_LOG.STRING(g_level_unexpected,
1367: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1363: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1364: 'Incorrect return_status after calling ' ||
1365: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_adjusted_to()');
1366: FND_LOG.STRING(g_level_unexpected,
1367: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1368: 'RETURN_STATUS = ' || x_return_status);
1369: FND_LOG.STRING(g_level_unexpected,
1370: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1371: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1366: FND_LOG.STRING(g_level_unexpected,
1367: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1368: 'RETURN_STATUS = ' || x_return_status);
1369: FND_LOG.STRING(g_level_unexpected,
1370: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1371: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1372: END IF;
1373: RETURN;
1374: END IF;
1367: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1368: 'RETURN_STATUS = ' || x_return_status);
1369: FND_LOG.STRING(g_level_unexpected,
1370: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1371: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1372: END IF;
1373: RETURN;
1374: END IF;
1375: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1388:
1389: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1390: IF g_level_unexpected >= g_current_runtime_level THEN
1391: FND_LOG.STRING(g_level_unexpected,
1392: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1393: 'Incorrect return_status after calling ' ||
1394: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_applied_from()');
1395: FND_LOG.STRING(g_level_unexpected,
1396: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1392: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1393: 'Incorrect return_status after calling ' ||
1394: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_applied_from()');
1395: FND_LOG.STRING(g_level_unexpected,
1396: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1397: 'RETURN_STATUS = ' || x_return_status);
1398: FND_LOG.STRING(g_level_unexpected,
1399: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1400: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1395: FND_LOG.STRING(g_level_unexpected,
1396: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1397: 'RETURN_STATUS = ' || x_return_status);
1398: FND_LOG.STRING(g_level_unexpected,
1399: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1400: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1401: END IF;
1402: RETURN;
1403: END IF;
1396: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1397: 'RETURN_STATUS = ' || x_return_status);
1398: FND_LOG.STRING(g_level_unexpected,
1399: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1400: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1401: END IF;
1402: RETURN;
1403: END IF;
1404:
1409: -- line level action 'LINE_INFO_TAX_ONLY'
1410: --
1411: IF (g_level_statement >= g_current_runtime_level ) THEN
1412: FND_LOG.STRING(g_level_statement,
1413: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1414: 'line_ level_action on trx line is LINE_INFO_TAX_ONLY, ' ||
1415: 'skip performing additional applicability ');
1416: FND_LOG.STRING(g_level_statement,
1417: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1413: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1414: 'line_ level_action on trx line is LINE_INFO_TAX_ONLY, ' ||
1415: 'skip performing additional applicability ');
1416: FND_LOG.STRING(g_level_statement,
1417: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1418: 'RETURN_STATUS = ' || x_return_status);
1419: FND_LOG.STRING(g_level_statement,
1420: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1421: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1416: FND_LOG.STRING(g_level_statement,
1417: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1418: 'RETURN_STATUS = ' || x_return_status);
1419: FND_LOG.STRING(g_level_statement,
1420: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1421: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1422: END IF;
1423: RETURN;
1424:
1417: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1418: 'RETURN_STATUS = ' || x_return_status);
1419: FND_LOG.STRING(g_level_statement,
1420: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1421: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1422: END IF;
1423: RETURN;
1424:
1425: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1437: THEN
1438:
1439: IF (g_level_procedure >= g_current_runtime_level ) THEN
1440: FND_LOG.STRING(g_level_procedure,
1441: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1442: 'Start performing additional applicability process. ');
1443: END IF;
1444:
1445: /* Start: Added for Bug 4959835 */
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_APPLICABILITY_DETM_PKG.get_process_results()');
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_APPLICABILITY_DETM_PKG.get_process_results()');
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_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
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_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
1485: END IF;
1486: RETURN;
1487: END IF;
1521:
1522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1523: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1524: FND_LOG.STRING(g_level_unexpected,
1525: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1526: 'Incorrect return_status after calling ' ||
1527: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1528: FND_LOG.STRING(g_level_unexpected,
1529: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1525: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1526: 'Incorrect return_status after calling ' ||
1527: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1528: FND_LOG.STRING(g_level_unexpected,
1529: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1530: 'RETURN_STATUS = ' || x_return_status);
1531: FND_LOG.STRING(g_level_unexpected,
1532: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1533: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1528: FND_LOG.STRING(g_level_unexpected,
1529: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1530: 'RETURN_STATUS = ' || x_return_status);
1531: FND_LOG.STRING(g_level_unexpected,
1532: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1533: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1534: END IF;
1535: RETURN;
1536: END IF;
1529: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1530: 'RETURN_STATUS = ' || x_return_status);
1531: FND_LOG.STRING(g_level_unexpected,
1532: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1533: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1534: END IF;
1535: RETURN;
1536: END IF;
1537: END IF; -- For provider ID
1586:
1587: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1588: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1589: FND_LOG.STRING(g_level_unexpected,
1590: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1591: 'Incorrect return_status after calling ' ||
1592: 'ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status()');
1593: FND_LOG.STRING(g_level_unexpected,
1594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1590: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1591: 'Incorrect return_status after calling ' ||
1592: 'ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status()');
1593: FND_LOG.STRING(g_level_unexpected,
1594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1595: 'RETURN_STATUS = ' || x_return_status);
1596: FND_LOG.STRING(g_level_unexpected,
1597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1598: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1593: FND_LOG.STRING(g_level_unexpected,
1594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1595: 'RETURN_STATUS = ' || x_return_status);
1596: FND_LOG.STRING(g_level_unexpected,
1597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1598: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1599: END IF;
1600: RETURN;
1601: END IF;
1594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1595: 'RETURN_STATUS = ' || x_return_status);
1596: FND_LOG.STRING(g_level_unexpected,
1597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1598: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1599: END IF;
1600: RETURN;
1601: END IF;
1602:
1613:
1614: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1615: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1616: FND_LOG.STRING(g_level_unexpected,
1617: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1618: 'Incorrect return_status after calling ' ||
1619: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate()');
1620: FND_LOG.STRING(g_level_unexpected,
1621: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1617: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1618: 'Incorrect return_status after calling ' ||
1619: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate()');
1620: FND_LOG.STRING(g_level_unexpected,
1621: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1622: 'RETURN_STATUS = ' || x_return_status);
1623: FND_LOG.STRING(g_level_unexpected,
1624: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1625: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1620: FND_LOG.STRING(g_level_unexpected,
1621: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1622: 'RETURN_STATUS = ' || x_return_status);
1623: FND_LOG.STRING(g_level_unexpected,
1624: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1625: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1626: END IF;
1627: RETURN;
1628: END IF;
1621: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1622: 'RETURN_STATUS = ' || x_return_status);
1623: FND_LOG.STRING(g_level_unexpected,
1624: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1625: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1626: END IF;
1627: RETURN;
1628: END IF;
1629:
1640:
1641: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1642: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1643: FND_LOG.STRING(g_level_unexpected,
1644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1645: 'Incorrect return_status after calling ' || '
1646: ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis()');
1647: FND_LOG.STRING(g_level_unexpected,
1648: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1645: 'Incorrect return_status after calling ' || '
1646: ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis()');
1647: FND_LOG.STRING(g_level_unexpected,
1648: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1649: 'RETURN_STATUS = ' || x_return_status);
1650: FND_LOG.STRING(g_level_unexpected,
1651: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1652: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1647: FND_LOG.STRING(g_level_unexpected,
1648: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1649: 'RETURN_STATUS = ' || x_return_status);
1650: FND_LOG.STRING(g_level_unexpected,
1651: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1652: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1653: END IF;
1654: RETURN;
1655: END IF;
1648: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1649: 'RETURN_STATUS = ' || x_return_status);
1650: FND_LOG.STRING(g_level_unexpected,
1651: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1652: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1653: END IF;
1654: RETURN;
1655: END IF;
1656:
1667:
1668: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1669: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1670: FND_LOG.STRING(g_level_unexpected,
1671: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1672: 'Incorrect return_status after calling ' ||
1673: 'ZX_TDS_CALC_PKG.Get_tax_amount()');
1674: FND_LOG.STRING(g_level_unexpected,
1675: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1671: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1672: 'Incorrect return_status after calling ' ||
1673: 'ZX_TDS_CALC_PKG.Get_tax_amount()');
1674: FND_LOG.STRING(g_level_unexpected,
1675: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1676: 'RETURN_STATUS = ' || x_return_status);
1677: FND_LOG.STRING(g_level_unexpected,
1678: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1679: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1674: FND_LOG.STRING(g_level_unexpected,
1675: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1676: 'RETURN_STATUS = ' || x_return_status);
1677: FND_LOG.STRING(g_level_unexpected,
1678: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1679: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1680: END IF;
1681: RETURN;
1682: END IF;
1675: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1676: 'RETURN_STATUS = ' || x_return_status);
1677: FND_LOG.STRING(g_level_unexpected,
1678: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1679: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1680: END IF;
1681: RETURN;
1682: END IF;
1683:
1706:
1707: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1708: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1709: FND_LOG.STRING(g_level_unexpected,
1710: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1711: 'Incorrect return_status after calling ' ||
1712: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
1713: FND_LOG.STRING(g_level_unexpected,
1714: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1710: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1711: 'Incorrect return_status after calling ' ||
1712: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
1713: FND_LOG.STRING(g_level_unexpected,
1714: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1715: 'RETURN_STATUS = ' || x_return_status);
1716: FND_LOG.STRING(g_level_unexpected,
1717: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1718: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1713: FND_LOG.STRING(g_level_unexpected,
1714: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1715: 'RETURN_STATUS = ' || x_return_status);
1716: FND_LOG.STRING(g_level_unexpected,
1717: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1718: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1719: END IF;
1720: RETURN;
1721: END IF;
1714: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1715: 'RETURN_STATUS = ' || x_return_status);
1716: FND_LOG.STRING(g_level_unexpected,
1717: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1718: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1719: END IF;
1720: RETURN;
1721: END IF;
1722: END IF; -- l_begin_index_additional and l_end_index_additional not null
1722: END IF; -- l_begin_index_additional and l_end_index_additional not null
1723:
1724: IF (g_level_event >= g_current_runtime_level ) THEN
1725: FND_LOG.STRING(g_level_event,
1726: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1727: 'RETURN_STATUS = ' || x_return_status);
1728: FND_LOG.STRING(g_level_event,
1729: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1730: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1725: FND_LOG.STRING(g_level_event,
1726: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1727: 'RETURN_STATUS = ' || x_return_status);
1728: FND_LOG.STRING(g_level_event,
1729: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1730: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1731: END IF;
1732:
1733: EXCEPTION
1726: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1727: 'RETURN_STATUS = ' || x_return_status);
1728: FND_LOG.STRING(g_level_event,
1729: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1730: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1731: END IF;
1732:
1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736:
1737: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1738: FND_LOG.STRING(g_level_unexpected,
1739: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1740: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1741: FND_LOG.STRING(g_level_unexpected,
1742: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1743: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1738: FND_LOG.STRING(g_level_unexpected,
1739: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1740: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1741: FND_LOG.STRING(g_level_unexpected,
1742: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1743: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1744: END IF;
1745: END calculate_tax_for_import;
1746:
1739: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1740: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1741: FND_LOG.STRING(g_level_unexpected,
1742: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1743: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1744: END IF;
1745: END calculate_tax_for_import;
1746:
1747: /* ======================================================================*
1770: x_return_status := FND_API.G_RET_STS_SUCCESS;
1771:
1772: IF (g_level_event >= g_current_runtime_level ) THEN
1773: FND_LOG.STRING(g_level_event,
1774: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1775: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1776:
1777: FND_LOG.STRING(g_level_event,
1778: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1771:
1772: IF (g_level_event >= g_current_runtime_level ) THEN
1773: FND_LOG.STRING(g_level_event,
1774: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1775: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1776:
1777: FND_LOG.STRING(g_level_event,
1778: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1779: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1774: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1775: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1776:
1777: FND_LOG.STRING(g_level_event,
1778: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1779: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1780: FND_LOG.STRING(g_level_event,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1782: 'tax_regime_code := '|| p_tax_line_rec.tax_regime_code);
1777: FND_LOG.STRING(g_level_event,
1778: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1779: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1780: FND_LOG.STRING(g_level_event,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1782: 'tax_regime_code := '|| p_tax_line_rec.tax_regime_code);
1783: END IF;
1784:
1785: -- get tax dates
1828:
1829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1830: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1831: FND_LOG.STRING(g_level_unexpected,
1832: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1833: 'Incorrect return_status after calling ' ||
1834: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
1835: FND_LOG.STRING(g_level_unexpected,
1836: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1832: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1833: 'Incorrect return_status after calling ' ||
1834: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
1835: FND_LOG.STRING(g_level_unexpected,
1836: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1837: 'RETURN_STATUS = ' || x_return_status);
1838: FND_LOG.STRING(g_level_unexpected,
1839: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1840: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1835: FND_LOG.STRING(g_level_unexpected,
1836: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1837: 'RETURN_STATUS = ' || x_return_status);
1838: FND_LOG.STRING(g_level_unexpected,
1839: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1840: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1841: 'create_detail_tax_line(-)');
1842: END IF;
1843: RETURN;
1836: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1837: 'RETURN_STATUS = ' || x_return_status);
1838: FND_LOG.STRING(g_level_unexpected,
1839: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1840: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1841: 'create_detail_tax_line(-)');
1842: END IF;
1843: RETURN;
1844: END IF;
1855:
1856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1857: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1858: FND_LOG.STRING(g_level_unexpected,
1859: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1860: 'Incorrect return_status after calling ' ||
1861: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
1862: FND_LOG.STRING(g_level_unexpected,
1863: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1859: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1860: 'Incorrect return_status after calling ' ||
1861: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
1862: FND_LOG.STRING(g_level_unexpected,
1863: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1864: 'RETURN_STATUS = ' || x_return_status);
1865: FND_LOG.STRING(g_level_unexpected,
1866: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1867: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1862: FND_LOG.STRING(g_level_unexpected,
1863: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1864: 'RETURN_STATUS = ' || x_return_status);
1865: FND_LOG.STRING(g_level_unexpected,
1866: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1867: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1868: 'create_detail_tax_line(-)');
1869: END IF;
1870: RETURN;
1863: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1864: 'RETURN_STATUS = ' || x_return_status);
1865: FND_LOG.STRING(g_level_unexpected,
1866: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1867: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1868: 'create_detail_tax_line(-)');
1869: END IF;
1870: RETURN;
1871: END IF;
1885:
1886: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1887: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1888: FND_LOG.STRING(g_level_unexpected,
1889: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1890: 'Incorrect return_status after calling ' ||
1891: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
1892: FND_LOG.STRING(g_level_unexpected,
1893: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1889: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1890: 'Incorrect return_status after calling ' ||
1891: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
1892: FND_LOG.STRING(g_level_unexpected,
1893: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1894: 'RETURN_STATUS = ' || x_return_status);
1895: FND_LOG.STRING(g_level_unexpected,
1896: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1897: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1892: FND_LOG.STRING(g_level_unexpected,
1893: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1894: 'RETURN_STATUS = ' || x_return_status);
1895: FND_LOG.STRING(g_level_unexpected,
1896: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1897: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1898: 'create_detail_tax_line(-)');
1899: END IF;
1900: RETURN;
1893: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1894: 'RETURN_STATUS = ' || x_return_status);
1895: FND_LOG.STRING(g_level_unexpected,
1896: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1897: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1898: 'create_detail_tax_line(-)');
1899: END IF;
1900: RETURN;
1901: END IF;
1914:
1915: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1916: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1917: FND_LOG.STRING(g_level_unexpected,
1918: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1919: 'Incorrect return_status after calling ' ||
1920: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
1921: FND_LOG.STRING(g_level_unexpected,
1922: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1918: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1919: 'Incorrect return_status after calling ' ||
1920: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
1921: FND_LOG.STRING(g_level_unexpected,
1922: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1923: 'RETURN_STATUS = ' || x_return_status);
1924: FND_LOG.STRING(g_level_unexpected,
1925: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1926: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1921: FND_LOG.STRING(g_level_unexpected,
1922: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1923: 'RETURN_STATUS = ' || x_return_status);
1924: FND_LOG.STRING(g_level_unexpected,
1925: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1926: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1927: 'create_detail_tax_line(-)');
1928: END IF;
1929: RETURN;
1922: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1923: 'RETURN_STATUS = ' || x_return_status);
1924: FND_LOG.STRING(g_level_unexpected,
1925: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1926: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1927: 'create_detail_tax_line(-)');
1928: END IF;
1929: RETURN;
1930: END IF;
1949:
1950: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1951: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1952: FND_LOG.STRING(g_level_unexpected,
1953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1954: 'After calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
1955: FND_LOG.STRING(g_level_unexpected,
1956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1957: 'RETURN_STATUS = ' || x_return_status);
1952: FND_LOG.STRING(g_level_unexpected,
1953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1954: 'After calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
1955: FND_LOG.STRING(g_level_unexpected,
1956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1957: 'RETURN_STATUS = ' || x_return_status);
1958: FND_LOG.STRING(g_level_unexpected,
1959: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1960: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1955: FND_LOG.STRING(g_level_unexpected,
1956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1957: 'RETURN_STATUS = ' || x_return_status);
1958: FND_LOG.STRING(g_level_unexpected,
1959: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1960: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1961: 'create_detail_tax_line(-)');
1962: END IF;
1963: RETURN;
1956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1957: 'RETURN_STATUS = ' || x_return_status);
1958: FND_LOG.STRING(g_level_unexpected,
1959: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1960: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1961: 'create_detail_tax_line(-)');
1962: END IF;
1963: RETURN;
1964: END IF;
1964: END IF;
1965:
1966: IF (g_level_event >= g_current_runtime_level ) THEN
1967: FND_LOG.STRING(g_level_event,
1968: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1969: 'summary_tax_line_number := '||
1970: p_tax_line_rec.summary_tax_line_number);
1971: FND_LOG.STRING(g_level_event,
1972: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1968: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1969: 'summary_tax_line_number := '||
1970: p_tax_line_rec.summary_tax_line_number);
1971: FND_LOG.STRING(g_level_event,
1972: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1973: 'tax_regime_code := ' || p_tax_line_rec.tax_regime_code);
1974: FND_LOG.STRING(g_level_event,
1975: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1976: 'tax := ' || p_tax_line_rec.tax);
1971: FND_LOG.STRING(g_level_event,
1972: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1973: 'tax_regime_code := ' || p_tax_line_rec.tax_regime_code);
1974: FND_LOG.STRING(g_level_event,
1975: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1976: 'tax := ' || p_tax_line_rec.tax);
1977: END IF;
1978:
1979: -- populate tax_line_id from Sequence
2196: --Bug 137249999
2197:
2198: IF (g_level_event >= g_current_runtime_level ) THEN
2199: FND_LOG.STRING(g_level_event,
2200: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2201: 'RETURN_STATUS = ' || x_return_status);
2202: FND_LOG.STRING(g_level_event,
2203: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2204: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2199: FND_LOG.STRING(g_level_event,
2200: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2201: 'RETURN_STATUS = ' || x_return_status);
2202: FND_LOG.STRING(g_level_event,
2203: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2204: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2205: END IF;
2206:
2207: EXCEPTION
2200: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2201: 'RETURN_STATUS = ' || x_return_status);
2202: FND_LOG.STRING(g_level_event,
2203: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2204: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2205: END IF;
2206:
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2210:
2211: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2212: FND_LOG.STRING(g_level_unexpected,
2213: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2214: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2215: FND_LOG.STRING(g_level_unexpected,
2216: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2217: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2212: FND_LOG.STRING(g_level_unexpected,
2213: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2214: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2215: FND_LOG.STRING(g_level_unexpected,
2216: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2217: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2218: END IF;
2219:
2220: END create_detail_tax_line;
2213: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2214: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2215: FND_LOG.STRING(g_level_unexpected,
2216: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2217: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2218: END IF;
2219:
2220: END create_detail_tax_line;
2221:
2283: BEGIN
2284:
2285: IF (g_level_procedure >= g_current_runtime_level ) THEN
2286: FND_LOG.STRING(g_level_procedure,
2287: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2288: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2289: FND_LOG.STRING(g_level_procedure,
2290: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2291: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2284:
2285: IF (g_level_procedure >= g_current_runtime_level ) THEN
2286: FND_LOG.STRING(g_level_procedure,
2287: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2288: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2289: FND_LOG.STRING(g_level_procedure,
2290: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2291: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2292: END IF;
2286: FND_LOG.STRING(g_level_procedure,
2287: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2288: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2289: FND_LOG.STRING(g_level_procedure,
2290: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2291: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2292: END IF;
2293:
2294: x_return_status := FND_API.G_RET_STS_SUCCESS;
2339:
2340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2341: IF (g_level_statement >= g_current_runtime_level ) THEN
2342: FND_LOG.STRING(g_level_statement,
2343: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2344: 'Incorrect return_status after calling ' ||
2345: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2346: FND_LOG.STRING(g_level_statement,
2347: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2343: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2344: 'Incorrect return_status after calling ' ||
2345: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2346: FND_LOG.STRING(g_level_statement,
2347: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2348: 'RETURN_STATUS = ' || x_return_status);
2349: FND_LOG.STRING(g_level_statement,
2350: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2351: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2346: FND_LOG.STRING(g_level_statement,
2347: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2348: 'RETURN_STATUS = ' || x_return_status);
2349: FND_LOG.STRING(g_level_statement,
2350: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2351: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2352: END IF;
2353: RETURN;
2354: END IF;
2369:
2370: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2371: IF (g_level_statement >= g_current_runtime_level ) THEN
2372: FND_LOG.STRING(g_level_statement,
2373: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2374: 'Incorrect return_status after calling ' ||
2375: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2376: FND_LOG.STRING(g_level_statement,
2377: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2373: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2374: 'Incorrect return_status after calling ' ||
2375: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2376: FND_LOG.STRING(g_level_statement,
2377: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2378: 'RETURN_STATUS = ' || x_return_status);
2379: FND_LOG.STRING(g_level_statement,
2380: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2381: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2376: FND_LOG.STRING(g_level_statement,
2377: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2378: 'RETURN_STATUS = ' || x_return_status);
2379: FND_LOG.STRING(g_level_statement,
2380: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2381: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2382: END IF;
2383: RETURN;
2384: END IF;
2410:
2411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2412: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2413: FND_LOG.STRING(g_level_unexpected,
2414: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2415: 'Incorrect return_status after calling ' ||
2416: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
2417: FND_LOG.STRING(g_level_unexpected,
2418: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2414: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2415: 'Incorrect return_status after calling ' ||
2416: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
2417: FND_LOG.STRING(g_level_unexpected,
2418: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2419: 'RETURN_STATUS = ' || x_return_status);
2420: FND_LOG.STRING(g_level_unexpected,
2421: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2422: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
2417: FND_LOG.STRING(g_level_unexpected,
2418: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2419: 'RETURN_STATUS = ' || x_return_status);
2420: FND_LOG.STRING(g_level_unexpected,
2421: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2422: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
2423: 'create_detail_tax_line(-)');
2424: END IF;
2425: RETURN;
2418: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2419: 'RETURN_STATUS = ' || x_return_status);
2420: FND_LOG.STRING(g_level_unexpected,
2421: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2422: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
2423: 'create_detail_tax_line(-)');
2424: END IF;
2425: RETURN;
2426: END IF;
2443:
2444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2445: IF (g_level_statement >= g_current_runtime_level ) THEN
2446: FND_LOG.STRING(g_level_statement,
2447: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2448: 'Incorrect return_status after calling ' ||
2449: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2450: FND_LOG.STRING(g_level_statement,
2451: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2447: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2448: 'Incorrect return_status after calling ' ||
2449: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2450: FND_LOG.STRING(g_level_statement,
2451: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2452: 'RETURN_STATUS = ' || x_return_status);
2453: FND_LOG.STRING(g_level_statement,
2454: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2455: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2450: FND_LOG.STRING(g_level_statement,
2451: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2452: 'RETURN_STATUS = ' || x_return_status);
2453: FND_LOG.STRING(g_level_statement,
2454: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2455: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2456: END IF;
2457: RETURN;
2458: END IF;
2524:
2525: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2526: IF (g_level_statement >= g_current_runtime_level ) THEN
2527: FND_LOG.STRING(g_level_statement,
2528: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2529: 'Incorrect return_status after calling ' ||
2530: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
2531: FND_LOG.STRING(g_level_statement,
2532: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2528: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2529: 'Incorrect return_status after calling ' ||
2530: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
2531: FND_LOG.STRING(g_level_statement,
2532: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2533: 'RETURN_STATUS = ' || x_return_status);
2534: FND_LOG.STRING(g_level_statement,
2535: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2536: 'ZX_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2531: FND_LOG.STRING(g_level_statement,
2532: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2533: 'RETURN_STATUS = ' || x_return_status);
2534: FND_LOG.STRING(g_level_statement,
2535: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2536: 'ZX_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2537: END IF;
2538: RETURN;
2539: END IF;
2836:
2837: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2838: IF (g_level_statement >= g_current_runtime_level ) THEN
2839: FND_LOG.STRING(g_level_statement,
2840: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2841: 'Incorrect return_status after calling ' ||
2842: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2843: FND_LOG.STRING(g_level_statement,
2844: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2840: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2841: 'Incorrect return_status after calling ' ||
2842: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2843: FND_LOG.STRING(g_level_statement,
2844: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2845: 'RETURN_STATUS = ' || x_return_status);
2846: FND_LOG.STRING(g_level_statement,
2847: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2848: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2843: FND_LOG.STRING(g_level_statement,
2844: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2845: 'RETURN_STATUS = ' || x_return_status);
2846: FND_LOG.STRING(g_level_statement,
2847: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2848: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2849: END IF;
2850: RETURN;
2851: END IF;
2844: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2845: 'RETURN_STATUS = ' || x_return_status);
2846: FND_LOG.STRING(g_level_statement,
2847: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2848: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2849: END IF;
2850: RETURN;
2851: END IF;
2852:
2851: END IF;
2852:
2853: IF (g_level_procedure >= g_current_runtime_level ) THEN
2854: FND_LOG.STRING(g_level_procedure,
2855: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2856: 'x_begin_index = ' || to_char(x_begin_index));
2857: FND_LOG.STRING(g_level_procedure,
2858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2859: 'x_end_index = ' || to_char(x_end_index));
2854: FND_LOG.STRING(g_level_procedure,
2855: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2856: 'x_begin_index = ' || to_char(x_begin_index));
2857: FND_LOG.STRING(g_level_procedure,
2858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2859: 'x_end_index = ' || to_char(x_end_index));
2860: FND_LOG.STRING(g_level_procedure,
2861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2862: 'RETURN_STATUS = ' || x_return_status);
2857: FND_LOG.STRING(g_level_procedure,
2858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2859: 'x_end_index = ' || to_char(x_end_index));
2860: FND_LOG.STRING(g_level_procedure,
2861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2862: 'RETURN_STATUS = ' || x_return_status);
2863: FND_LOG.STRING(g_level_procedure,
2864: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2865: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2860: FND_LOG.STRING(g_level_procedure,
2861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2862: 'RETURN_STATUS = ' || x_return_status);
2863: FND_LOG.STRING(g_level_procedure,
2864: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2865: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2866: END IF;
2867:
2868: EXCEPTION
2861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2862: 'RETURN_STATUS = ' || x_return_status);
2863: FND_LOG.STRING(g_level_procedure,
2864: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2865: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2866: END IF;
2867:
2868: EXCEPTION
2869: WHEN OTHERS THEN
2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871:
2872: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2873: FND_LOG.STRING(g_level_unexpected,
2874: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2875: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2876: FND_LOG.STRING(g_level_unexpected,
2877: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2878: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2873: FND_LOG.STRING(g_level_unexpected,
2874: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2875: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2876: FND_LOG.STRING(g_level_unexpected,
2877: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2878: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2879: END IF;
2880:
2881: END get_taxes_from_applied_from;
2874: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2875: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2876: FND_LOG.STRING(g_level_unexpected,
2877: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2878: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2879: END IF;
2880:
2881: END get_taxes_from_applied_from;
2882:
2952: BEGIN
2953:
2954: IF (g_level_procedure >= g_current_runtime_level ) THEN
2955: FND_LOG.STRING(g_level_procedure,
2956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2957: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2958: FND_LOG.STRING(g_level_procedure,
2959: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2960: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2953:
2954: IF (g_level_procedure >= g_current_runtime_level ) THEN
2955: FND_LOG.STRING(g_level_procedure,
2956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2957: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2958: FND_LOG.STRING(g_level_procedure,
2959: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2960: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2961: END IF;
2955: FND_LOG.STRING(g_level_procedure,
2956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2957: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2958: FND_LOG.STRING(g_level_procedure,
2959: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2960: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2961: END IF;
2962:
2963: x_return_status := FND_API.G_RET_STS_SUCCESS;
2998:
2999: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3000: IF (g_level_statement >= g_current_runtime_level ) THEN
3001: FND_LOG.STRING(g_level_statement,
3002: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3003: 'Incorrect return_status after calling ' ||
3004: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
3005: FND_LOG.STRING(g_level_statement,
3006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3002: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3003: 'Incorrect return_status after calling ' ||
3004: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
3005: FND_LOG.STRING(g_level_statement,
3006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3007: 'RETURN_STATUS = ' || x_return_status);
3008: FND_LOG.STRING(g_level_statement,
3009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3010: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3005: FND_LOG.STRING(g_level_statement,
3006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3007: 'RETURN_STATUS = ' || x_return_status);
3008: FND_LOG.STRING(g_level_statement,
3009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3010: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3011: END IF;
3012:
3013: RETURN;
3006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3007: 'RETURN_STATUS = ' || x_return_status);
3008: FND_LOG.STRING(g_level_statement,
3009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3010: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3011: END IF;
3012:
3013: RETURN;
3014: END IF;
3124: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
3125: THEN
3126: IF (g_level_statement >= g_current_runtime_level ) THEN
3127: FND_LOG.STRING(g_level_statement,
3128: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3129: 'Current trx is a tax only adjustment. ');
3130: END IF;
3131:
3132: -- for tax only adjustment set the unrounded tax amount to the
3140: -- current trx is a regular adjustment or CM
3141: -- prorate the line amt to get the unrounded taxable/tax amount
3142: IF (g_level_statement >= g_current_runtime_level ) THEN
3143: FND_LOG.STRING(g_level_statement,
3144: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3145: 'tax_amt_included_flag on Current tax line: '||
3146: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3147: l_new_row_num).tax_amt_included_flag);
3148: FND_LOG.STRING(g_level_statement,
3145: 'tax_amt_included_flag on Current tax line: '||
3146: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3147: l_new_row_num).tax_amt_included_flag);
3148: FND_LOG.STRING(g_level_statement,
3149: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3150: 'tax_amt_included_flag on original tax line: '||
3151: tax_line_rec.tax_amt_included_flag);
3152: END IF;
3153:
3465:
3466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3467: IF (g_level_statement >= g_current_runtime_level ) THEN
3468: FND_LOG.STRING(g_level_statement,
3469: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3470: 'Incorrect return_status after calling ' ||
3471: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3472: FND_LOG.STRING(g_level_statement,
3473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3469: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3470: 'Incorrect return_status after calling ' ||
3471: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3472: FND_LOG.STRING(g_level_statement,
3473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3474: 'RETURN_STATUS = ' || x_return_status);
3475: FND_LOG.STRING(g_level_statement,
3476: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3477: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3472: FND_LOG.STRING(g_level_statement,
3473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3474: 'RETURN_STATUS = ' || x_return_status);
3475: FND_LOG.STRING(g_level_statement,
3476: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3477: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3478: END IF;
3479: RETURN;
3480: END IF;
3473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3474: 'RETURN_STATUS = ' || x_return_status);
3475: FND_LOG.STRING(g_level_statement,
3476: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3477: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3478: END IF;
3479: RETURN;
3480: END IF;
3481:
3480: END IF;
3481:
3482: IF (g_level_procedure >= g_current_runtime_level ) THEN
3483: FND_LOG.STRING(g_level_procedure,
3484: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3485: 'x_begin_index = ' || to_char(x_begin_index));
3486: FND_LOG.STRING(g_level_procedure,
3487: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3488: 'x_end_index = ' || to_char(x_end_index));
3483: FND_LOG.STRING(g_level_procedure,
3484: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3485: 'x_begin_index = ' || to_char(x_begin_index));
3486: FND_LOG.STRING(g_level_procedure,
3487: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3488: 'x_end_index = ' || to_char(x_end_index));
3489: FND_LOG.STRING(g_level_procedure,
3490: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3491: 'RETURN_STATUS = ' || x_return_status);
3486: FND_LOG.STRING(g_level_procedure,
3487: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3488: 'x_end_index = ' || to_char(x_end_index));
3489: FND_LOG.STRING(g_level_procedure,
3490: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3491: 'RETURN_STATUS = ' || x_return_status);
3492: FND_LOG.STRING(g_level_procedure,
3493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3494: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3489: FND_LOG.STRING(g_level_procedure,
3490: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3491: 'RETURN_STATUS = ' || x_return_status);
3492: FND_LOG.STRING(g_level_procedure,
3493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3494: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3495: END IF;
3496:
3497: EXCEPTION
3490: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3491: 'RETURN_STATUS = ' || x_return_status);
3492: FND_LOG.STRING(g_level_procedure,
3493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3494: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3495: END IF;
3496:
3497: EXCEPTION
3498: WHEN OTHERS THEN
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500:
3501: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3502: FND_LOG.STRING(g_level_unexpected,
3503: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3504: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3505: FND_LOG.STRING(g_level_unexpected,
3506: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3507: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3502: FND_LOG.STRING(g_level_unexpected,
3503: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3504: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3505: FND_LOG.STRING(g_level_unexpected,
3506: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3507: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3508: END IF;
3509:
3510: END get_taxes_from_adjusted_to;
3503: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3504: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3505: FND_LOG.STRING(g_level_unexpected,
3506: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3507: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3508: END IF;
3509:
3510: END get_taxes_from_adjusted_to;
3511:
3508: END IF;
3509:
3510: END get_taxes_from_adjusted_to;
3511:
3512: END ZX_TDS_IMPORT_DOCUMENT_PKG;