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

APPS.ZX_TDS_IMPORT_DOCUMENT_PKG dependencies on FND_LOG

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

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;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

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

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;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: NUMBER_DUMMY CONSTANT NUMBER := -999999999999;

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: NUMBER_DUMMY CONSTANT NUMBER := -999999999999;
11:

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

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: NUMBER_DUMMY CONSTANT NUMBER := -999999999999;
11:
12: TYPE tax_line_rec_type is RECORD (

Line 386: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

382: l_tax_class zx_rates_b.tax_class%TYPE;
383:
384: BEGIN
385:
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',

Line 389: FND_LOG.STRING(g_level_event,

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

Line 435: FND_LOG.STRING(g_level_unexpected,

431: x_return_status => x_return_status);
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,

Line 439: FND_LOG.STRING(g_level_unexpected,

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,
443: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 442: FND_LOG.STRING(g_level_unexpected,

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

Line 535: FND_LOG.STRING(g_level_event,

531:
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.');

Line 540: 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,
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,

Line 544: FND_LOG.STRING(g_level_event,

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

Line 547: FND_LOG.STRING(g_level_event,

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.' ||
550: 'prorate_imported_sum_tax_lines(-)');
551: END IF;

Line 580: FND_LOG.STRING(g_level_unexpected,

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

Line 584: FND_LOG.STRING(g_level_unexpected,

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

Line 587: FND_LOG.STRING(g_level_unexpected,

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

Line 660: FND_LOG.STRING(g_level_unexpected,

656: x_return_status => x_return_status);
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,

Line 664: FND_LOG.STRING(g_level_unexpected,

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,
668: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 667: FND_LOG.STRING(g_level_unexpected,

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

Line 749: FND_LOG.STRING(g_level_event,

745:
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.');

Line 754: 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,
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,

Line 758: FND_LOG.STRING(g_level_event,

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

Line 761: FND_LOG.STRING(g_level_event,

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.' ||
764: 'prorate_imported_sum_tax_lines(-)');
765: END IF;

Line 795: FND_LOG.STRING(g_level_unexpected,

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

Line 799: FND_LOG.STRING(g_level_unexpected,

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

Line 802: FND_LOG.STRING(g_level_unexpected,

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

Line 868: FND_LOG.STRING(g_level_unexpected,

864: x_return_status => x_return_status);
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,

Line 872: FND_LOG.STRING(g_level_unexpected,

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,
876: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 875: FND_LOG.STRING(g_level_unexpected,

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

Line 928: FND_LOG.STRING(g_level_unexpected,

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

Line 932: FND_LOG.STRING(g_level_unexpected,

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

Line 935: FND_LOG.STRING(g_level_unexpected,

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

Line 943: FND_LOG.STRING(g_level_event,

939: RETURN;
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',

Line 946: FND_LOG.STRING(g_level_event,

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);
949: FND_LOG.STRING(g_level_event,
950: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',

Line 949: FND_LOG.STRING(g_level_event,

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);
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',

Line 952: FND_LOG.STRING(g_level_event,

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);
955: FND_LOG.STRING(g_level_event,
956: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 955: FND_LOG.STRING(g_level_event,

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(-)');
958: END IF;
959:

Line 965: FND_LOG.STRING(g_level_unexpected,

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

Line 968: FND_LOG.STRING(g_level_unexpected,

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(-)');
971: END IF;
972:

Line 1054: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1050: l_adjusted_doc_tax_line_id zx_lines.adjusted_doc_tax_line_id%TYPE;
1051: l_reporting_code_id ZX_REPORTING_CODES_B.reporting_code_id%type;
1052: BEGIN
1053:
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',

Line 1057: FND_LOG.STRING(g_level_event,

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

Line 1128: FND_LOG.STRING(g_level_statement,

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

Line 1132: FND_LOG.STRING(g_level_statement,

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

Line 1135: FND_LOG.STRING(g_level_statement,

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

Line 1157: FND_LOG.STRING(g_level_statement,

1153: x_error_buffer => l_error_buffer);
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,

Line 1161: FND_LOG.STRING(g_level_statement,

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

Line 1164: FND_LOG.STRING(g_level_statement,

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

Line 1207: FND_LOG.STRING(g_level_unexpected,

1203:
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,

Line 1211: FND_LOG.STRING(g_level_unexpected,

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

Line 1214: FND_LOG.STRING(g_level_unexpected,

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 (-)');
1217: END IF;
1218:

Line 1245: FND_LOG.STRING(g_level_event,'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',

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;

Line 1274: FND_LOG.STRING(g_level_procedure,

1270: AND trx_level_type =
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,

Line 1278: FND_LOG.STRING(g_level_procedure,

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

Line 1281: FND_LOG.STRING(g_level_procedure,

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);
1284: END IF;
1285:

Line 1297: FND_LOG.STRING(g_level_statement,

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

Line 1301: FND_LOG.STRING(g_level_statement,

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

Line 1304: FND_LOG.STRING(g_level_statement,

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

Line 1362: FND_LOG.STRING(g_level_unexpected,

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

Line 1366: FND_LOG.STRING(g_level_unexpected,

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

Line 1369: FND_LOG.STRING(g_level_unexpected,

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

Line 1391: FND_LOG.STRING(g_level_unexpected,

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

Line 1395: FND_LOG.STRING(g_level_unexpected,

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

Line 1398: FND_LOG.STRING(g_level_unexpected,

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

Line 1412: FND_LOG.STRING(g_level_statement,

1408: -- Bug 3010729: skip performing additional applicability for trx lines with
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,

Line 1416: FND_LOG.STRING(g_level_statement,

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

Line 1419: FND_LOG.STRING(g_level_statement,

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

Line 1440: FND_LOG.STRING(g_level_procedure,

1436: NVL(p_event_class_rec.source_process_for_appl_flag, 'Y') = 'Y'
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:

Line 1453: FND_LOG.STRING(g_level_statement,

1449: -- then, call get process results directly
1450: -- Else (for location based) call tax applicability.
1451:
1452: IF (g_level_statement >= g_current_runtime_level ) THEN
1453: FND_LOG.STRING(g_level_statement,
1454: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1455: 'template_usage_code = '||p_event_class_rec.template_usage_code);
1456: END IF;
1457:

Line 1475: FND_LOG.STRING(g_level_unexpected,

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

Line 1479: FND_LOG.STRING(g_level_unexpected,

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

Line 1482: FND_LOG.STRING(g_level_unexpected,

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

Line 1524: FND_LOG.STRING(g_level_unexpected,

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

Line 1528: FND_LOG.STRING(g_level_unexpected,

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

Line 1531: FND_LOG.STRING(g_level_unexpected,

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

Line 1589: FND_LOG.STRING(g_level_unexpected,

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

Line 1593: FND_LOG.STRING(g_level_unexpected,

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

Line 1596: FND_LOG.STRING(g_level_unexpected,

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

Line 1616: FND_LOG.STRING(g_level_unexpected,

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

Line 1620: FND_LOG.STRING(g_level_unexpected,

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

Line 1623: FND_LOG.STRING(g_level_unexpected,

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

Line 1643: FND_LOG.STRING(g_level_unexpected,

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

Line 1647: FND_LOG.STRING(g_level_unexpected,

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

Line 1650: FND_LOG.STRING(g_level_unexpected,

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

Line 1670: FND_LOG.STRING(g_level_unexpected,

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

Line 1674: FND_LOG.STRING(g_level_unexpected,

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

Line 1677: FND_LOG.STRING(g_level_unexpected,

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

Line 1709: FND_LOG.STRING(g_level_unexpected,

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

Line 1713: FND_LOG.STRING(g_level_unexpected,

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

Line 1716: FND_LOG.STRING(g_level_unexpected,

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

Line 1725: FND_LOG.STRING(g_level_event,

1721: END IF;
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',

Line 1728: FND_LOG.STRING(g_level_event,

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(-)');
1731: END IF;
1732:

Line 1738: FND_LOG.STRING(g_level_unexpected,

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

Line 1741: FND_LOG.STRING(g_level_unexpected,

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(-)');
1744: END IF;
1745: END calculate_tax_for_import;

Line 1773: FND_LOG.STRING(g_level_event,

1769:
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,

Line 1777: FND_LOG.STRING(g_level_event,

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 || ')');
1780: FND_LOG.STRING(g_level_event,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',

Line 1780: FND_LOG.STRING(g_level_event,

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);
1783: END IF;
1784:

Line 1831: FND_LOG.STRING(g_level_unexpected,

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

Line 1835: FND_LOG.STRING(g_level_unexpected,

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

Line 1838: FND_LOG.STRING(g_level_unexpected,

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.' ||
1841: 'create_detail_tax_line(-)');
1842: END IF;

Line 1858: FND_LOG.STRING(g_level_unexpected,

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

Line 1862: FND_LOG.STRING(g_level_unexpected,

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

Line 1865: FND_LOG.STRING(g_level_unexpected,

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.' ||
1868: 'create_detail_tax_line(-)');
1869: END IF;

Line 1888: FND_LOG.STRING(g_level_unexpected,

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

Line 1892: FND_LOG.STRING(g_level_unexpected,

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

Line 1895: FND_LOG.STRING(g_level_unexpected,

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.' ||
1898: 'create_detail_tax_line(-)');
1899: END IF;

Line 1917: FND_LOG.STRING(g_level_unexpected,

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

Line 1921: FND_LOG.STRING(g_level_unexpected,

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

Line 1924: FND_LOG.STRING(g_level_unexpected,

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.' ||
1927: 'create_detail_tax_line(-)');
1928: END IF;

Line 1952: FND_LOG.STRING(g_level_unexpected,

1948: := l_tax_rate_rec.tax_rate_id;
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',

Line 1955: FND_LOG.STRING(g_level_unexpected,

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);
1958: FND_LOG.STRING(g_level_unexpected,
1959: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 1958: FND_LOG.STRING(g_level_unexpected,

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.' ||
1961: 'create_detail_tax_line(-)');
1962: END IF;

Line 1967: FND_LOG.STRING(g_level_event,

1963: RETURN;
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,

Line 1971: FND_LOG.STRING(g_level_event,

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

Line 1974: FND_LOG.STRING(g_level_event,

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);
1977: END IF;
1978:

Line 2199: FND_LOG.STRING(g_level_event,

2195: END IF;
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',

Line 2202: FND_LOG.STRING(g_level_event,

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(-)');
2205: END IF;
2206:

Line 2212: FND_LOG.STRING(g_level_unexpected,

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

Line 2215: FND_LOG.STRING(g_level_unexpected,

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(-)');
2218: END IF;
2219:

Line 2286: FND_LOG.STRING(g_level_procedure,

2282: l_reporting_code_id ZX_REPORTING_CODES_B.reporting_code_id%type;
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',

Line 2289: FND_LOG.STRING(g_level_procedure,

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;
2293:

Line 2342: FND_LOG.STRING(g_level_statement,

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

Line 2346: FND_LOG.STRING(g_level_statement,

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

Line 2349: FND_LOG.STRING(g_level_statement,

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

Line 2372: FND_LOG.STRING(g_level_statement,

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

Line 2376: FND_LOG.STRING(g_level_statement,

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

Line 2379: FND_LOG.STRING(g_level_statement,

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

Line 2413: FND_LOG.STRING(g_level_unexpected,

2409:
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,

Line 2417: FND_LOG.STRING(g_level_unexpected,

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

Line 2420: FND_LOG.STRING(g_level_unexpected,

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.' ||
2423: 'create_detail_tax_line(-)');
2424: END IF;

Line 2446: FND_LOG.STRING(g_level_statement,

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

Line 2450: FND_LOG.STRING(g_level_statement,

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

Line 2453: FND_LOG.STRING(g_level_statement,

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

Line 2527: FND_LOG.STRING(g_level_statement,

2523: l_new_row_num).prd_total_tax_amt_funcl_curr);
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,

Line 2531: FND_LOG.STRING(g_level_statement,

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

Line 2534: FND_LOG.STRING(g_level_statement,

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

Line 2839: FND_LOG.STRING(g_level_statement,

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

Line 2843: FND_LOG.STRING(g_level_statement,

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

Line 2846: FND_LOG.STRING(g_level_statement,

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

Line 2854: FND_LOG.STRING(g_level_procedure,

2850: RETURN;
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',

Line 2857: FND_LOG.STRING(g_level_procedure,

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));
2860: FND_LOG.STRING(g_level_procedure,
2861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',

Line 2860: FND_LOG.STRING(g_level_procedure,

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);
2863: FND_LOG.STRING(g_level_procedure,
2864: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2863: FND_LOG.STRING(g_level_procedure,

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(-)');
2866: END IF;
2867:

Line 2873: FND_LOG.STRING(g_level_unexpected,

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

Line 2876: FND_LOG.STRING(g_level_unexpected,

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(-)');
2879: END IF;
2880:

Line 2955: FND_LOG.STRING(g_level_procedure,

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

Line 2958: FND_LOG.STRING(g_level_procedure,

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;
2962:

Line 3001: FND_LOG.STRING(g_level_statement,

2997: p_error_buffer => l_error_buffer);
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,

Line 3005: FND_LOG.STRING(g_level_statement,

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

Line 3008: FND_LOG.STRING(g_level_statement,

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(-)');
3011: END IF;
3012:

Line 3076: FND_LOG.STRING(g_level_statement,

3072: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3073: l_new_row_num).tax_apportionment_line_number := tax_line_rec.tax_apportionment_line_number;
3074:
3075: IF (g_level_statement >= g_current_runtime_level ) THEN
3076: FND_LOG.STRING(g_level_statement,
3077: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
3078: 'Tax Apportionment Line Number: Bug6729097 ' ||
3079: to_char(tax_line_rec.tax_apportionment_line_number));
3080: END IF;

Line 3127: FND_LOG.STRING(g_level_statement,

3123: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
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:

Line 3143: FND_LOG.STRING(g_level_statement,

3139: ELSE
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);

Line 3148: 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,
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;

Line 3468: FND_LOG.STRING(g_level_statement,

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

Line 3472: FND_LOG.STRING(g_level_statement,

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

Line 3475: FND_LOG.STRING(g_level_statement,

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

Line 3483: FND_LOG.STRING(g_level_procedure,

3479: RETURN;
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',

Line 3486: FND_LOG.STRING(g_level_procedure,

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));
3489: FND_LOG.STRING(g_level_procedure,
3490: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',

Line 3489: FND_LOG.STRING(g_level_procedure,

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);
3492: FND_LOG.STRING(g_level_procedure,
3493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',

Line 3492: FND_LOG.STRING(g_level_procedure,

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(-)');
3495: END IF;
3496:

Line 3502: FND_LOG.STRING(g_level_unexpected,

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

Line 3505: FND_LOG.STRING(g_level_unexpected,

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(-)');
3508: END IF;
3509: