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.61.12010000.2 2008/11/12 12:22:25 spasala ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
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.61.12010000.2 2008/11/12 12:22:25 spasala ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
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 318: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

314: l_tax_class zx_rates_b.tax_class%TYPE;
315:
316: BEGIN
317:
318: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
319:
320: IF (g_level_event >= g_current_runtime_level ) THEN
321: FND_LOG.STRING(g_level_event,
322: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.BEGIN',

Line 321: FND_LOG.STRING(g_level_event,

317:
318: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
319:
320: IF (g_level_event >= g_current_runtime_level ) THEN
321: FND_LOG.STRING(g_level_event,
322: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.BEGIN',
323: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(+)');
324: END IF;
325:

Line 367: FND_LOG.STRING(g_level_unexpected,

363: x_return_status => x_return_status);
364:
365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
366: IF (g_level_unexpected >= g_current_runtime_level ) THEN
367: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
369: 'Incorrect return_status after calling '||
370: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
371: FND_LOG.STRING(g_level_unexpected,

Line 371: FND_LOG.STRING(g_level_unexpected,

367: FND_LOG.STRING(g_level_unexpected,
368: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
369: 'Incorrect return_status after calling '||
370: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
371: FND_LOG.STRING(g_level_unexpected,
372: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
373: 'RETURN_STATUS = ' || x_return_status);
374: FND_LOG.STRING(g_level_unexpected,
375: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 374: FND_LOG.STRING(g_level_unexpected,

370: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
371: FND_LOG.STRING(g_level_unexpected,
372: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
373: 'RETURN_STATUS = ' || x_return_status);
374: FND_LOG.STRING(g_level_unexpected,
375: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
376: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
377: END IF;
378: RETURN;

Line 467: FND_LOG.STRING(g_level_event,

463:
464: x_return_status := FND_API.G_RET_STS_ERROR;
465:
466: IF (g_level_event >= g_current_runtime_level ) THEN
467: FND_LOG.STRING(g_level_event,
468: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
469: 'tax_amt from summary tax line is not 0, ' ||
470: 'but the total line amount for the allocated trx lines is 0.'
471: || 'Cannot do proration.');

Line 472: FND_LOG.STRING(g_level_event,

468: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
469: 'tax_amt from summary tax line is not 0, ' ||
470: 'but the total line amount for the allocated trx lines is 0.'
471: || 'Cannot do proration.');
472: FND_LOG.STRING(g_level_event,
473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
474: 'Summary_tax_line_number = ' ||
475: tax_line_rec.summary_tax_line_number);
476: FND_LOG.STRING(g_level_event,

Line 476: FND_LOG.STRING(g_level_event,

472: FND_LOG.STRING(g_level_event,
473: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
474: 'Summary_tax_line_number = ' ||
475: tax_line_rec.summary_tax_line_number);
476: FND_LOG.STRING(g_level_event,
477: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
478: 'RETURN_STATUS = ' || x_return_status);
479: FND_LOG.STRING(g_level_event,
480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 479: FND_LOG.STRING(g_level_event,

475: tax_line_rec.summary_tax_line_number);
476: FND_LOG.STRING(g_level_event,
477: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
478: 'RETURN_STATUS = ' || x_return_status);
479: FND_LOG.STRING(g_level_event,
480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
481: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
482: 'prorate_imported_sum_tax_lines(-)');
483: END IF;

Line 512: FND_LOG.STRING(g_level_unexpected,

508: l_error_buffer);
509:
510: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
511: IF (g_level_unexpected >= g_current_runtime_level ) THEN
512: FND_LOG.STRING(g_level_unexpected,
513: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
514: 'Incorrect return_status after calling ' ||
515: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
516: FND_LOG.STRING(g_level_unexpected,

Line 516: FND_LOG.STRING(g_level_unexpected,

512: FND_LOG.STRING(g_level_unexpected,
513: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
514: 'Incorrect return_status after calling ' ||
515: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
516: FND_LOG.STRING(g_level_unexpected,
517: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
518: 'RETURN_STATUS = ' || x_return_status);
519: FND_LOG.STRING(g_level_unexpected,
520: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 519: FND_LOG.STRING(g_level_unexpected,

515: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
516: FND_LOG.STRING(g_level_unexpected,
517: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
518: 'RETURN_STATUS = ' || x_return_status);
519: FND_LOG.STRING(g_level_unexpected,
520: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
521: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
522: END IF;
523: RETURN;

Line 592: FND_LOG.STRING(g_level_unexpected,

588: x_return_status => x_return_status);
589:
590: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
591: IF (g_level_unexpected >= g_current_runtime_level ) THEN
592: FND_LOG.STRING(g_level_unexpected,
593: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
594: 'Incorrect return_status after calling '||
595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
596: FND_LOG.STRING(g_level_unexpected,

Line 596: FND_LOG.STRING(g_level_unexpected,

592: FND_LOG.STRING(g_level_unexpected,
593: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
594: 'Incorrect return_status after calling '||
595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
596: FND_LOG.STRING(g_level_unexpected,
597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
598: 'RETURN_STATUS = ' || x_return_status);
599: FND_LOG.STRING(g_level_unexpected,
600: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 599: FND_LOG.STRING(g_level_unexpected,

595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
596: FND_LOG.STRING(g_level_unexpected,
597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
598: 'RETURN_STATUS = ' || x_return_status);
599: FND_LOG.STRING(g_level_unexpected,
600: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
601: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
602: END IF;
603: RETURN;

Line 674: FND_LOG.STRING(g_level_event,

670:
671: x_return_status := FND_API.G_RET_STS_ERROR;
672:
673: IF (g_level_event >= g_current_runtime_level ) THEN
674: FND_LOG.STRING(g_level_event,
675: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
676: 'tax_amt from summary tax line is not 0, ' ||
677: 'but the total line amount for the allocated trx lines is 0.'
678: || 'Cannot do proration.');

Line 679: FND_LOG.STRING(g_level_event,

675: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
676: 'tax_amt from summary tax line is not 0, ' ||
677: 'but the total line amount for the allocated trx lines is 0.'
678: || 'Cannot do proration.');
679: FND_LOG.STRING(g_level_event,
680: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
681: 'Summary_tax_line_number = ' ||
682: tax_line_rec.summary_tax_line_number);
683: FND_LOG.STRING(g_level_event,

Line 683: FND_LOG.STRING(g_level_event,

679: FND_LOG.STRING(g_level_event,
680: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
681: 'Summary_tax_line_number = ' ||
682: tax_line_rec.summary_tax_line_number);
683: FND_LOG.STRING(g_level_event,
684: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
685: 'RETURN_STATUS = ' || x_return_status);
686: FND_LOG.STRING(g_level_event,
687: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 686: FND_LOG.STRING(g_level_event,

682: tax_line_rec.summary_tax_line_number);
683: FND_LOG.STRING(g_level_event,
684: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
685: 'RETURN_STATUS = ' || x_return_status);
686: FND_LOG.STRING(g_level_event,
687: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
688: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
689: 'prorate_imported_sum_tax_lines(-)');
690: END IF;

Line 720: FND_LOG.STRING(g_level_unexpected,

716: l_error_buffer);
717:
718: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
719: IF (g_level_unexpected >= g_current_runtime_level ) THEN
720: FND_LOG.STRING(g_level_unexpected,
721: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
722: 'Incorrect return_status after calling ' ||
723: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
724: FND_LOG.STRING(g_level_unexpected,

Line 724: FND_LOG.STRING(g_level_unexpected,

720: FND_LOG.STRING(g_level_unexpected,
721: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
722: 'Incorrect return_status after calling ' ||
723: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
724: FND_LOG.STRING(g_level_unexpected,
725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
726: 'RETURN_STATUS = ' || x_return_status);
727: FND_LOG.STRING(g_level_unexpected,
728: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 727: FND_LOG.STRING(g_level_unexpected,

723: 'ZX_TDS_TAX_ROUNDING_PKG.round_tax()');
724: FND_LOG.STRING(g_level_unexpected,
725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
726: 'RETURN_STATUS = ' || x_return_status);
727: FND_LOG.STRING(g_level_unexpected,
728: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
729: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
730: END IF;
731: RETURN;

Line 793: FND_LOG.STRING(g_level_unexpected,

789: x_return_status => x_return_status);
790:
791: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
792: IF (g_level_unexpected >= g_current_runtime_level ) THEN
793: FND_LOG.STRING(g_level_unexpected,
794: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
795: 'Incorrect return_status after calling '||
796: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
797: FND_LOG.STRING(g_level_unexpected,

Line 797: FND_LOG.STRING(g_level_unexpected,

793: FND_LOG.STRING(g_level_unexpected,
794: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
795: 'Incorrect return_status after calling '||
796: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
797: FND_LOG.STRING(g_level_unexpected,
798: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
799: 'RETURN_STATUS = ' || x_return_status);
800: FND_LOG.STRING(g_level_unexpected,
801: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 800: FND_LOG.STRING(g_level_unexpected,

796: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line()');
797: FND_LOG.STRING(g_level_unexpected,
798: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
799: 'RETURN_STATUS = ' || x_return_status);
800: FND_LOG.STRING(g_level_unexpected,
801: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
802: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
803: END IF;
804: RETURN;

Line 853: FND_LOG.STRING(g_level_unexpected,

849: l_error_buffer);
850:
851: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
852: IF (g_level_unexpected >= g_current_runtime_level ) THEN
853: FND_LOG.STRING(g_level_unexpected,
854: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
855: 'Incorrect return_status after calling ' ||
856: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
857: FND_LOG.STRING(g_level_unexpected,

Line 857: FND_LOG.STRING(g_level_unexpected,

853: FND_LOG.STRING(g_level_unexpected,
854: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
855: 'Incorrect return_status after calling ' ||
856: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
859: 'RETURN_STATUS = ' || x_return_status);
860: FND_LOG.STRING(g_level_unexpected,
861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 860: FND_LOG.STRING(g_level_unexpected,

856: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
857: FND_LOG.STRING(g_level_unexpected,
858: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
859: 'RETURN_STATUS = ' || x_return_status);
860: FND_LOG.STRING(g_level_unexpected,
861: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
862: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
863: END IF;
864: RETURN;

Line 868: FND_LOG.STRING(g_level_event,

864: RETURN;
865: END IF;
866:
867: IF (g_level_event >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_event,
869: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
870: 'Detail tax lines created from imported summary tax lines:');
871: FND_LOG.STRING(g_level_event,
872: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',

Line 871: FND_LOG.STRING(g_level_event,

867: IF (g_level_event >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_event,
869: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
870: 'Detail tax lines created from imported summary tax lines:');
871: FND_LOG.STRING(g_level_event,
872: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
873: 'l_begin_index = ' || l_begin_index);
874: FND_LOG.STRING(g_level_event,
875: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',

Line 874: FND_LOG.STRING(g_level_event,

870: 'Detail tax lines created from imported summary tax lines:');
871: FND_LOG.STRING(g_level_event,
872: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
873: 'l_begin_index = ' || l_begin_index);
874: FND_LOG.STRING(g_level_event,
875: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
876: 'l_end_index = ' || l_end_index);
877: FND_LOG.STRING(g_level_event,
878: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',

Line 877: FND_LOG.STRING(g_level_event,

873: 'l_begin_index = ' || l_begin_index);
874: FND_LOG.STRING(g_level_event,
875: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
876: 'l_end_index = ' || l_end_index);
877: FND_LOG.STRING(g_level_event,
878: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
879: 'RETURN_STATUS = ' || x_return_status);
880: FND_LOG.STRING(g_level_event,
881: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 880: FND_LOG.STRING(g_level_event,

876: 'l_end_index = ' || l_end_index);
877: FND_LOG.STRING(g_level_event,
878: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
879: 'RETURN_STATUS = ' || x_return_status);
880: FND_LOG.STRING(g_level_event,
881: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
882: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
883: END IF;
884:

Line 890: FND_LOG.STRING(g_level_unexpected,

886: WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888:
889: IF (g_level_unexpected >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_unexpected,
891: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
892: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
893: FND_LOG.STRING(g_level_unexpected,
894: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',

Line 893: FND_LOG.STRING(g_level_unexpected,

889: IF (g_level_unexpected >= g_current_runtime_level ) THEN
890: FND_LOG.STRING(g_level_unexpected,
891: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
892: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
893: FND_LOG.STRING(g_level_unexpected,
894: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines.END',
895: 'ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines(-)');
896: END IF;
897:

Line 949: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

945: l_tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE;
946:
947: BEGIN
948:
949: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
950:
951: IF (g_level_event >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.BEGIN',

Line 952: FND_LOG.STRING(g_level_event,

948:
949: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
950:
951: IF (g_level_event >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_event,
953: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.BEGIN',
954: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(+)');
955: END IF;
956:

Line 1017: FND_LOG.STRING(g_level_statement,

1013: x_return_status);
1014:
1015: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1016: IF (g_level_statement >= g_current_runtime_level ) THEN
1017: FND_LOG.STRING(g_level_statement,
1018: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1019: 'Incorrect return_status after calling ' ||
1020: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
1021: FND_LOG.STRING(g_level_statement,

Line 1021: FND_LOG.STRING(g_level_statement,

1017: FND_LOG.STRING(g_level_statement,
1018: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1019: 'Incorrect return_status after calling ' ||
1020: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
1021: FND_LOG.STRING(g_level_statement,
1022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1023: 'RETURN_STATUS = ' || x_return_status);
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1024: FND_LOG.STRING(g_level_statement,

1020: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
1021: FND_LOG.STRING(g_level_statement,
1022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1023: 'RETURN_STATUS = ' || x_return_status);
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1026: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1027: END IF;
1028: RETURN;

Line 1042: FND_LOG.STRING(g_level_statement,

1038: x_error_buffer => l_error_buffer);
1039:
1040: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1041: IF (g_level_statement >= g_current_runtime_level ) THEN
1042: FND_LOG.STRING(g_level_statement,
1043: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1044: 'Incorrect return_status after calling ' ||
1045: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration');
1046: FND_LOG.STRING(g_level_statement,

Line 1046: FND_LOG.STRING(g_level_statement,

1042: FND_LOG.STRING(g_level_statement,
1043: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1044: 'Incorrect return_status after calling ' ||
1045: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration');
1046: FND_LOG.STRING(g_level_statement,
1047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1048: 'RETURN_STATUS = ' || x_return_status);
1049: FND_LOG.STRING(g_level_statement,
1050: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1049: FND_LOG.STRING(g_level_statement,

1045: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration');
1046: FND_LOG.STRING(g_level_statement,
1047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1048: 'RETURN_STATUS = ' || x_return_status);
1049: FND_LOG.STRING(g_level_statement,
1050: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1051: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1052: END IF;
1053: RETURN;

Line 1092: FND_LOG.STRING(g_level_unexpected,

1088:
1089: ELSE
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1092: FND_LOG.STRING(g_level_unexpected,
1093: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1094: 'Tax_rate = 0, tax_amt <> 0. ' ||
1095: 'Cannot calculate taxable basis amount.');
1096: FND_LOG.STRING(g_level_unexpected,

Line 1096: FND_LOG.STRING(g_level_unexpected,

1092: FND_LOG.STRING(g_level_unexpected,
1093: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1094: 'Tax_rate = 0, tax_amt <> 0. ' ||
1095: 'Cannot calculate taxable basis amount.');
1096: FND_LOG.STRING(g_level_unexpected,
1097: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1098: 'x_return_status = ' || x_return_status);
1099: FND_LOG.STRING(g_level_unexpected,
1100: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1099: FND_LOG.STRING(g_level_unexpected,

1095: 'Cannot calculate taxable basis amount.');
1096: FND_LOG.STRING(g_level_unexpected,
1097: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1098: 'x_return_status = ' || x_return_status);
1099: FND_LOG.STRING(g_level_unexpected,
1100: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1101: 'ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis (-)');
1102: END IF;
1103:

Line 1140: FND_LOG.STRING(g_level_procedure,

1136: AND trx_level_type =
1137: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1138:
1139: IF (g_level_procedure >= g_current_runtime_level ) THEN
1140: FND_LOG.STRING(g_level_procedure,
1141: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1142: 'Begin_index and end_index for detail tax lines created ' ||
1143: 'from summary tax_line');
1144: FND_LOG.STRING(g_level_procedure,

Line 1144: FND_LOG.STRING(g_level_procedure,

1140: FND_LOG.STRING(g_level_procedure,
1141: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1142: 'Begin_index and end_index for detail tax lines created ' ||
1143: 'from summary tax_line');
1144: FND_LOG.STRING(g_level_procedure,
1145: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1146: 'l_begin_index :=' || l_begin_index);
1147: FND_LOG.STRING(g_level_procedure,
1148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',

Line 1147: FND_LOG.STRING(g_level_procedure,

1143: 'from summary tax_line');
1144: FND_LOG.STRING(g_level_procedure,
1145: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1146: 'l_begin_index :=' || l_begin_index);
1147: FND_LOG.STRING(g_level_procedure,
1148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1149: 'l_end_index :=' || l_end_index);
1150: END IF;
1151:

Line 1163: FND_LOG.STRING(g_level_statement,

1159: l_error_buffer );
1160:
1161: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1162: IF (g_level_statement >= g_current_runtime_level ) THEN
1163: FND_LOG.STRING(g_level_statement,
1164: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1165: 'Incorrect return_status after calling '||
1166: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1167: FND_LOG.STRING(g_level_statement,

Line 1167: FND_LOG.STRING(g_level_statement,

1163: FND_LOG.STRING(g_level_statement,
1164: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1165: 'Incorrect return_status after calling '||
1166: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1169: 'RETURN_STATUS = ' || x_return_status);
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1170: FND_LOG.STRING(g_level_statement,

1166: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1169: 'RETURN_STATUS = ' || x_return_status);
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1172: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1173: END IF;
1174: RETURN;

Line 1221: FND_LOG.STRING(g_level_unexpected,

1217: x_return_status);
1218:
1219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1220: IF g_level_unexpected >= g_current_runtime_level THEN
1221: FND_LOG.STRING(g_level_unexpected,
1222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1223: 'Incorrect return_status after calling ' ||
1224: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_adjusted_to()');
1225: FND_LOG.STRING(g_level_unexpected,

Line 1225: FND_LOG.STRING(g_level_unexpected,

1221: FND_LOG.STRING(g_level_unexpected,
1222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1223: 'Incorrect return_status after calling ' ||
1224: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_adjusted_to()');
1225: FND_LOG.STRING(g_level_unexpected,
1226: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1227: 'RETURN_STATUS = ' || x_return_status);
1228: FND_LOG.STRING(g_level_unexpected,
1229: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1228: FND_LOG.STRING(g_level_unexpected,

1224: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_adjusted_to()');
1225: FND_LOG.STRING(g_level_unexpected,
1226: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1227: 'RETURN_STATUS = ' || x_return_status);
1228: FND_LOG.STRING(g_level_unexpected,
1229: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1230: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1231: END IF;
1232: RETURN;

Line 1250: FND_LOG.STRING(g_level_unexpected,

1246: x_return_status);
1247:
1248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1249: IF g_level_unexpected >= g_current_runtime_level THEN
1250: FND_LOG.STRING(g_level_unexpected,
1251: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1252: 'Incorrect return_status after calling ' ||
1253: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_applied_from()');
1254: FND_LOG.STRING(g_level_unexpected,

Line 1254: FND_LOG.STRING(g_level_unexpected,

1250: FND_LOG.STRING(g_level_unexpected,
1251: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1252: 'Incorrect return_status after calling ' ||
1253: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_applied_from()');
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1256: 'RETURN_STATUS = ' || x_return_status);
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1257: FND_LOG.STRING(g_level_unexpected,

1253: 'ZX_TDS_TAX_ROUNDING_PKG.get_taxes_from_applied_from()');
1254: FND_LOG.STRING(g_level_unexpected,
1255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1256: 'RETURN_STATUS = ' || x_return_status);
1257: FND_LOG.STRING(g_level_unexpected,
1258: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1259: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1260: END IF;
1261: RETURN;

Line 1271: FND_LOG.STRING(g_level_statement,

1267: -- Bug 3010729: skip performing additional applicability for trx lines with
1268: -- line level action 'LINE_INFO_TAX_ONLY'
1269: --
1270: IF (g_level_statement >= g_current_runtime_level ) THEN
1271: FND_LOG.STRING(g_level_statement,
1272: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1273: 'line_ level_action on trx line is LINE_INFO_TAX_ONLY, ' ||
1274: 'skip performing additional applicability ');
1275: FND_LOG.STRING(g_level_statement,

Line 1275: FND_LOG.STRING(g_level_statement,

1271: FND_LOG.STRING(g_level_statement,
1272: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1273: 'line_ level_action on trx line is LINE_INFO_TAX_ONLY, ' ||
1274: 'skip performing additional applicability ');
1275: FND_LOG.STRING(g_level_statement,
1276: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1277: 'RETURN_STATUS = ' || x_return_status);
1278: FND_LOG.STRING(g_level_statement,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1278: FND_LOG.STRING(g_level_statement,

1274: 'skip performing additional applicability ');
1275: FND_LOG.STRING(g_level_statement,
1276: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1277: 'RETURN_STATUS = ' || x_return_status);
1278: FND_LOG.STRING(g_level_statement,
1279: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1280: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1281: END IF;
1282: RETURN;

Line 1299: FND_LOG.STRING(g_level_procedure,

1295: NVL(p_event_class_rec.source_process_for_appl_flag, 'Y') = 'Y'
1296: THEN
1297:
1298: IF (g_level_procedure >= g_current_runtime_level ) THEN
1299: FND_LOG.STRING(g_level_procedure,
1300: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1301: 'Start performing additional applicability process. ');
1302: END IF;
1303:

Line 1312: FND_LOG.STRING(g_level_statement,

1308: -- then, call get process results directly
1309: -- Else (for location based) call tax applicability.
1310:
1311: IF (g_level_statement >= g_current_runtime_level ) THEN
1312: FND_LOG.STRING(g_level_statement,
1313: 'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax',
1314: 'template_usage_code = '||p_event_class_rec.template_usage_code);
1315: END IF;
1316:

Line 1334: FND_LOG.STRING(g_level_unexpected,

1330: x_return_status);
1331:
1332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1333: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1334: FND_LOG.STRING(g_level_unexpected,
1335: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1336: 'Incorrect return_status after calling ' ||
1337: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results()');
1338: FND_LOG.STRING(g_level_unexpected,

Line 1338: FND_LOG.STRING(g_level_unexpected,

1334: FND_LOG.STRING(g_level_unexpected,
1335: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1336: 'Incorrect return_status after calling ' ||
1337: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results()');
1338: FND_LOG.STRING(g_level_unexpected,
1339: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1340: 'RETURN_STATUS = ' || x_return_status);
1341: FND_LOG.STRING(g_level_unexpected,
1342: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1341: FND_LOG.STRING(g_level_unexpected,

1337: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results()');
1338: FND_LOG.STRING(g_level_unexpected,
1339: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1340: 'RETURN_STATUS = ' || x_return_status);
1341: FND_LOG.STRING(g_level_unexpected,
1342: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1343: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
1344: END IF;
1345: RETURN;

Line 1383: FND_LOG.STRING(g_level_unexpected,

1379: x_return_status );
1380:
1381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1382: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1383: FND_LOG.STRING(g_level_unexpected,
1384: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1385: 'Incorrect return_status after calling ' ||
1386: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1387: FND_LOG.STRING(g_level_unexpected,

Line 1387: FND_LOG.STRING(g_level_unexpected,

1383: FND_LOG.STRING(g_level_unexpected,
1384: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1385: 'Incorrect return_status after calling ' ||
1386: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1387: FND_LOG.STRING(g_level_unexpected,
1388: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1389: 'RETURN_STATUS = ' || x_return_status);
1390: FND_LOG.STRING(g_level_unexpected,
1391: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1390: FND_LOG.STRING(g_level_unexpected,

1386: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes()');
1387: FND_LOG.STRING(g_level_unexpected,
1388: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1389: 'RETURN_STATUS = ' || x_return_status);
1390: FND_LOG.STRING(g_level_unexpected,
1391: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1392: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1393: END IF;
1394: RETURN;

Line 1448: FND_LOG.STRING(g_level_unexpected,

1444: l_error_buffer);
1445:
1446: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1447: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1448: FND_LOG.STRING(g_level_unexpected,
1449: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1450: 'Incorrect return_status after calling ' ||
1451: 'ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status()');
1452: FND_LOG.STRING(g_level_unexpected,

Line 1452: FND_LOG.STRING(g_level_unexpected,

1448: FND_LOG.STRING(g_level_unexpected,
1449: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1450: 'Incorrect return_status after calling ' ||
1451: 'ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status()');
1452: FND_LOG.STRING(g_level_unexpected,
1453: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1454: 'RETURN_STATUS = ' || x_return_status);
1455: FND_LOG.STRING(g_level_unexpected,
1456: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1455: FND_LOG.STRING(g_level_unexpected,

1451: 'ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status()');
1452: FND_LOG.STRING(g_level_unexpected,
1453: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1454: 'RETURN_STATUS = ' || x_return_status);
1455: FND_LOG.STRING(g_level_unexpected,
1456: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1457: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1458: END IF;
1459: RETURN;

Line 1475: FND_LOG.STRING(g_level_unexpected,

1471: l_error_buffer );
1472:
1473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1474: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1475: FND_LOG.STRING(g_level_unexpected,
1476: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1477: 'Incorrect return_status after calling ' ||
1478: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate()');
1479: FND_LOG.STRING(g_level_unexpected,

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_RATE_DETM_PKG.get_tax_rate()');
1479: FND_LOG.STRING(g_level_unexpected,
1480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1481: 'RETURN_STATUS = ' || x_return_status);
1482: FND_LOG.STRING(g_level_unexpected,
1483: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1482: FND_LOG.STRING(g_level_unexpected,

1478: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate()');
1479: FND_LOG.STRING(g_level_unexpected,
1480: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1481: 'RETURN_STATUS = ' || x_return_status);
1482: FND_LOG.STRING(g_level_unexpected,
1483: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1484: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1485: END IF;
1486: RETURN;

Line 1502: FND_LOG.STRING(g_level_unexpected,

1498: l_error_buffer );
1499:
1500: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1501: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1502: FND_LOG.STRING(g_level_unexpected,
1503: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1504: 'Incorrect return_status after calling ' || '
1505: ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis()');
1506: FND_LOG.STRING(g_level_unexpected,

Line 1506: FND_LOG.STRING(g_level_unexpected,

1502: FND_LOG.STRING(g_level_unexpected,
1503: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1504: 'Incorrect return_status after calling ' || '
1505: ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis()');
1506: FND_LOG.STRING(g_level_unexpected,
1507: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1508: 'RETURN_STATUS = ' || x_return_status);
1509: FND_LOG.STRING(g_level_unexpected,
1510: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1509: FND_LOG.STRING(g_level_unexpected,

1505: ZX_TDS_TAXABLE_BASIS_DETM_PKG.get_taxable_basis()');
1506: FND_LOG.STRING(g_level_unexpected,
1507: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1508: 'RETURN_STATUS = ' || x_return_status);
1509: FND_LOG.STRING(g_level_unexpected,
1510: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1511: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1512: END IF;
1513: RETURN;

Line 1529: FND_LOG.STRING(g_level_unexpected,

1525: l_error_buffer );
1526:
1527: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1528: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1529: FND_LOG.STRING(g_level_unexpected,
1530: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1531: 'Incorrect return_status after calling ' ||
1532: 'ZX_TDS_CALC_PKG.Get_tax_amount()');
1533: FND_LOG.STRING(g_level_unexpected,

Line 1533: FND_LOG.STRING(g_level_unexpected,

1529: FND_LOG.STRING(g_level_unexpected,
1530: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1531: 'Incorrect return_status after calling ' ||
1532: 'ZX_TDS_CALC_PKG.Get_tax_amount()');
1533: FND_LOG.STRING(g_level_unexpected,
1534: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1535: 'RETURN_STATUS = ' || x_return_status);
1536: FND_LOG.STRING(g_level_unexpected,
1537: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1536: FND_LOG.STRING(g_level_unexpected,

1532: 'ZX_TDS_CALC_PKG.Get_tax_amount()');
1533: FND_LOG.STRING(g_level_unexpected,
1534: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1535: 'RETURN_STATUS = ' || x_return_status);
1536: FND_LOG.STRING(g_level_unexpected,
1537: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1538: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1539: END IF;
1540: RETURN;

Line 1568: FND_LOG.STRING(g_level_unexpected,

1564: l_error_buffer);
1565:
1566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1567: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1568: FND_LOG.STRING(g_level_unexpected,
1569: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1570: 'Incorrect return_status after calling ' ||
1571: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
1572: FND_LOG.STRING(g_level_unexpected,

Line 1572: FND_LOG.STRING(g_level_unexpected,

1568: FND_LOG.STRING(g_level_unexpected,
1569: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1570: 'Incorrect return_status after calling ' ||
1571: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
1572: FND_LOG.STRING(g_level_unexpected,
1573: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1574: 'RETURN_STATUS = ' || x_return_status);
1575: FND_LOG.STRING(g_level_unexpected,
1576: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1575: FND_LOG.STRING(g_level_unexpected,

1571: 'ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line()');
1572: FND_LOG.STRING(g_level_unexpected,
1573: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1574: 'RETURN_STATUS = ' || x_return_status);
1575: FND_LOG.STRING(g_level_unexpected,
1576: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1577: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1578: END IF;
1579: RETURN;

Line 1584: FND_LOG.STRING(g_level_event,

1580: END IF;
1581: END IF; -- l_begin_index_additional and l_end_index_additional not null
1582:
1583: IF (g_level_event >= g_current_runtime_level ) THEN
1584: FND_LOG.STRING(g_level_event,
1585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1586: 'RETURN_STATUS = ' || x_return_status);
1587: FND_LOG.STRING(g_level_event,
1588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1587: FND_LOG.STRING(g_level_event,

1583: IF (g_level_event >= g_current_runtime_level ) THEN
1584: FND_LOG.STRING(g_level_event,
1585: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1586: 'RETURN_STATUS = ' || x_return_status);
1587: FND_LOG.STRING(g_level_event,
1588: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1589: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1590: END IF;
1591:

Line 1597: FND_LOG.STRING(g_level_unexpected,

1593: WHEN OTHERS THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595:
1596: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1597: FND_LOG.STRING(g_level_unexpected,
1598: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1599: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1600: FND_LOG.STRING(g_level_unexpected,
1601: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',

Line 1600: FND_LOG.STRING(g_level_unexpected,

1596: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1597: FND_LOG.STRING(g_level_unexpected,
1598: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1599: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1600: FND_LOG.STRING(g_level_unexpected,
1601: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import.END',
1602: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1603: END IF;
1604: END calculate_tax_for_import;

Line 1632: FND_LOG.STRING(g_level_event,

1628:
1629: x_return_status := FND_API.G_RET_STS_SUCCESS;
1630:
1631: IF (g_level_event >= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_event,
1633: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1634: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1635:
1636: FND_LOG.STRING(g_level_event,

Line 1636: FND_LOG.STRING(g_level_event,

1632: FND_LOG.STRING(g_level_event,
1633: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.BEGIN',
1634: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(+)');
1635:
1636: FND_LOG.STRING(g_level_event,
1637: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1638: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1639: FND_LOG.STRING(g_level_event,
1640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',

Line 1639: FND_LOG.STRING(g_level_event,

1635:
1636: FND_LOG.STRING(g_level_event,
1637: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1638: 'new tax line created (tax := '|| p_tax_line_rec.tax || ')');
1639: FND_LOG.STRING(g_level_event,
1640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1641: 'tax_regime_code := '|| p_tax_line_rec.tax_regime_code);
1642: END IF;
1643:

Line 1690: FND_LOG.STRING(g_level_unexpected,

1686: l_error_buffer);
1687:
1688: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1689: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1690: FND_LOG.STRING(g_level_unexpected,
1691: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1692: 'Incorrect return_status after calling ' ||
1693: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
1694: FND_LOG.STRING(g_level_unexpected,

Line 1694: FND_LOG.STRING(g_level_unexpected,

1690: FND_LOG.STRING(g_level_unexpected,
1691: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1692: 'Incorrect return_status after calling ' ||
1693: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
1694: FND_LOG.STRING(g_level_unexpected,
1695: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1696: 'RETURN_STATUS = ' || x_return_status);
1697: FND_LOG.STRING(g_level_unexpected,
1698: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 1697: FND_LOG.STRING(g_level_unexpected,

1693: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info()');
1694: FND_LOG.STRING(g_level_unexpected,
1695: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1696: 'RETURN_STATUS = ' || x_return_status);
1697: FND_LOG.STRING(g_level_unexpected,
1698: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1699: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1700: 'create_detail_tax_line(-)');
1701: END IF;

Line 1717: FND_LOG.STRING(g_level_unexpected,

1713: l_error_buffer);
1714:
1715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1716: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1717: FND_LOG.STRING(g_level_unexpected,
1718: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1719: 'Incorrect return_status after calling ' ||
1720: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
1721: FND_LOG.STRING(g_level_unexpected,

Line 1721: FND_LOG.STRING(g_level_unexpected,

1717: FND_LOG.STRING(g_level_unexpected,
1718: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1719: 'Incorrect return_status after calling ' ||
1720: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
1721: FND_LOG.STRING(g_level_unexpected,
1722: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1723: 'RETURN_STATUS = ' || x_return_status);
1724: FND_LOG.STRING(g_level_unexpected,
1725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 1724: FND_LOG.STRING(g_level_unexpected,

1720: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info()');
1721: FND_LOG.STRING(g_level_unexpected,
1722: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1723: 'RETURN_STATUS = ' || x_return_status);
1724: FND_LOG.STRING(g_level_unexpected,
1725: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1726: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1727: 'create_detail_tax_line(-)');
1728: END IF;

Line 1747: FND_LOG.STRING(g_level_unexpected,

1743: l_error_buffer);
1744:
1745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1746: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1747: FND_LOG.STRING(g_level_unexpected,
1748: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1749: 'Incorrect return_status after calling ' ||
1750: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
1751: FND_LOG.STRING(g_level_unexpected,

Line 1751: FND_LOG.STRING(g_level_unexpected,

1747: FND_LOG.STRING(g_level_unexpected,
1748: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1749: 'Incorrect return_status after calling ' ||
1750: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
1751: FND_LOG.STRING(g_level_unexpected,
1752: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1753: 'RETURN_STATUS = ' || x_return_status);
1754: FND_LOG.STRING(g_level_unexpected,
1755: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 1754: FND_LOG.STRING(g_level_unexpected,

1750: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
1751: FND_LOG.STRING(g_level_unexpected,
1752: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1753: 'RETURN_STATUS = ' || x_return_status);
1754: FND_LOG.STRING(g_level_unexpected,
1755: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1756: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1757: 'create_detail_tax_line(-)');
1758: END IF;

Line 1776: FND_LOG.STRING(g_level_unexpected,

1772: l_error_buffer);
1773:
1774: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1775: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1776: FND_LOG.STRING(g_level_unexpected,
1777: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1778: 'Incorrect return_status after calling ' ||
1779: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
1780: FND_LOG.STRING(g_level_unexpected,

Line 1780: FND_LOG.STRING(g_level_unexpected,

1776: FND_LOG.STRING(g_level_unexpected,
1777: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1778: 'Incorrect return_status after calling ' ||
1779: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
1780: FND_LOG.STRING(g_level_unexpected,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1782: 'RETURN_STATUS = ' || x_return_status);
1783: FND_LOG.STRING(g_level_unexpected,
1784: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 1783: FND_LOG.STRING(g_level_unexpected,

1779: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
1780: FND_LOG.STRING(g_level_unexpected,
1781: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1782: 'RETURN_STATUS = ' || x_return_status);
1783: FND_LOG.STRING(g_level_unexpected,
1784: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1785: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1786: 'create_detail_tax_line(-)');
1787: END IF;

Line 1811: FND_LOG.STRING(g_level_unexpected,

1807: := l_tax_rate_rec.tax_rate_id;
1808:
1809: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1810: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1811: FND_LOG.STRING(g_level_unexpected,
1812: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1813: 'After calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
1814: FND_LOG.STRING(g_level_unexpected,
1815: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',

Line 1814: FND_LOG.STRING(g_level_unexpected,

1810: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1811: FND_LOG.STRING(g_level_unexpected,
1812: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1813: 'After calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
1814: FND_LOG.STRING(g_level_unexpected,
1815: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1816: 'RETURN_STATUS = ' || x_return_status);
1817: FND_LOG.STRING(g_level_unexpected,
1818: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 1817: FND_LOG.STRING(g_level_unexpected,

1813: 'After calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info()');
1814: FND_LOG.STRING(g_level_unexpected,
1815: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
1816: 'RETURN_STATUS = ' || x_return_status);
1817: FND_LOG.STRING(g_level_unexpected,
1818: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
1819: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
1820: 'create_detail_tax_line(-)');
1821: END IF;

Line 1826: FND_LOG.STRING(g_level_event,

1822: RETURN;
1823: END IF;
1824:
1825: IF (g_level_event >= g_current_runtime_level ) THEN
1826: FND_LOG.STRING(g_level_event,
1827: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1828: 'summary_tax_line_number := '||
1829: p_tax_line_rec.summary_tax_line_number);
1830: FND_LOG.STRING(g_level_event,

Line 1830: FND_LOG.STRING(g_level_event,

1826: FND_LOG.STRING(g_level_event,
1827: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1828: 'summary_tax_line_number := '||
1829: p_tax_line_rec.summary_tax_line_number);
1830: FND_LOG.STRING(g_level_event,
1831: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1832: 'tax_regime_code := ' || p_tax_line_rec.tax_regime_code);
1833: FND_LOG.STRING(g_level_event,
1834: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',

Line 1833: FND_LOG.STRING(g_level_event,

1829: p_tax_line_rec.summary_tax_line_number);
1830: FND_LOG.STRING(g_level_event,
1831: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1832: 'tax_regime_code := ' || p_tax_line_rec.tax_regime_code);
1833: FND_LOG.STRING(g_level_event,
1834: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.prorate_imported_sum_tax_lines',
1835: 'tax := ' || p_tax_line_rec.tax);
1836: END IF;
1837:

Line 2005: FND_LOG.STRING(g_level_event,

2001: * p_new_row_num).last_update_login := fnd_global.login_id;
2002: */
2003:
2004: IF (g_level_event >= g_current_runtime_level ) THEN
2005: FND_LOG.STRING(g_level_event,
2006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2007: 'RETURN_STATUS = ' || x_return_status);
2008: FND_LOG.STRING(g_level_event,
2009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 2008: FND_LOG.STRING(g_level_event,

2004: IF (g_level_event >= g_current_runtime_level ) THEN
2005: FND_LOG.STRING(g_level_event,
2006: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2007: 'RETURN_STATUS = ' || x_return_status);
2008: FND_LOG.STRING(g_level_event,
2009: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2010: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2011: END IF;
2012:

Line 2018: FND_LOG.STRING(g_level_unexpected,

2014: WHEN OTHERS THEN
2015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2016:
2017: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2018: FND_LOG.STRING(g_level_unexpected,
2019: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2020: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2021: FND_LOG.STRING(g_level_unexpected,
2022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',

Line 2021: FND_LOG.STRING(g_level_unexpected,

2017: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2018: FND_LOG.STRING(g_level_unexpected,
2019: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line',
2020: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2021: FND_LOG.STRING(g_level_unexpected,
2022: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line.END',
2023: 'ZX_TDS_IMPORT_DOCUMENT_PKG.create_detail_tax_line(-)');
2024: END IF;
2025:

Line 2087: FND_LOG.STRING(g_level_procedure,

2083:
2084: BEGIN
2085:
2086: IF (g_level_procedure >= g_current_runtime_level ) THEN
2087: FND_LOG.STRING(g_level_procedure,
2088: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2089: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2090: FND_LOG.STRING(g_level_procedure,
2091: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',

Line 2090: FND_LOG.STRING(g_level_procedure,

2086: IF (g_level_procedure >= g_current_runtime_level ) THEN
2087: FND_LOG.STRING(g_level_procedure,
2088: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.BEGIN',
2089: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(+)');
2090: FND_LOG.STRING(g_level_procedure,
2091: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2092: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2093: END IF;
2094:

Line 2143: FND_LOG.STRING(g_level_statement,

2139: l_error_buffer);
2140:
2141: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2142: IF (g_level_statement >= g_current_runtime_level ) THEN
2143: FND_LOG.STRING(g_level_statement,
2144: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2145: 'Incorrect return_status after calling ' ||
2146: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2147: FND_LOG.STRING(g_level_statement,

Line 2147: FND_LOG.STRING(g_level_statement,

2143: FND_LOG.STRING(g_level_statement,
2144: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2145: 'Incorrect return_status after calling ' ||
2146: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2147: FND_LOG.STRING(g_level_statement,
2148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2149: 'RETURN_STATUS = ' || x_return_status);
2150: FND_LOG.STRING(g_level_statement,
2151: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2150: FND_LOG.STRING(g_level_statement,

2146: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
2147: FND_LOG.STRING(g_level_statement,
2148: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2149: 'RETURN_STATUS = ' || x_return_status);
2150: FND_LOG.STRING(g_level_statement,
2151: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2152: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2153: END IF;
2154: RETURN;

Line 2173: FND_LOG.STRING(g_level_statement,

2169: l_error_buffer);
2170:
2171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2172: IF (g_level_statement >= g_current_runtime_level ) THEN
2173: FND_LOG.STRING(g_level_statement,
2174: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2175: 'Incorrect return_status after calling ' ||
2176: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2177: FND_LOG.STRING(g_level_statement,

Line 2177: FND_LOG.STRING(g_level_statement,

2173: FND_LOG.STRING(g_level_statement,
2174: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2175: 'Incorrect return_status after calling ' ||
2176: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2177: FND_LOG.STRING(g_level_statement,
2178: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2179: 'RETURN_STATUS = ' || x_return_status);
2180: FND_LOG.STRING(g_level_statement,
2181: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2180: FND_LOG.STRING(g_level_statement,

2176: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
2177: FND_LOG.STRING(g_level_statement,
2178: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2179: 'RETURN_STATUS = ' || x_return_status);
2180: FND_LOG.STRING(g_level_statement,
2181: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2182: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2183: END IF;
2184: RETURN;

Line 2214: FND_LOG.STRING(g_level_unexpected,

2210:
2211:
2212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2213: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2214: FND_LOG.STRING(g_level_unexpected,
2215: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2216: 'Incorrect return_status after calling ' ||
2217: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
2218: FND_LOG.STRING(g_level_unexpected,

Line 2218: FND_LOG.STRING(g_level_unexpected,

2214: FND_LOG.STRING(g_level_unexpected,
2215: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2216: 'Incorrect return_status after calling ' ||
2217: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
2218: FND_LOG.STRING(g_level_unexpected,
2219: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2220: 'RETURN_STATUS = ' || x_return_status);
2221: FND_LOG.STRING(g_level_unexpected,
2222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2221: FND_LOG.STRING(g_level_unexpected,

2217: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info()');
2218: FND_LOG.STRING(g_level_unexpected,
2219: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2220: 'RETURN_STATUS = ' || x_return_status);
2221: FND_LOG.STRING(g_level_unexpected,
2222: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2223: 'ZX_TDS_IMPORT_DOCUMENT_PKG.' ||
2224: 'create_detail_tax_line(-)');
2225: END IF;

Line 2247: FND_LOG.STRING(g_level_statement,

2243: l_error_buffer);
2244:
2245: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2246: IF (g_level_statement >= g_current_runtime_level ) THEN
2247: FND_LOG.STRING(g_level_statement,
2248: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2249: 'Incorrect return_status after calling ' ||
2250: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2251: FND_LOG.STRING(g_level_statement,

Line 2251: FND_LOG.STRING(g_level_statement,

2247: FND_LOG.STRING(g_level_statement,
2248: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2249: 'Incorrect return_status after calling ' ||
2250: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2253: 'RETURN_STATUS = ' || x_return_status);
2254: FND_LOG.STRING(g_level_statement,
2255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2254: FND_LOG.STRING(g_level_statement,

2250: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2251: FND_LOG.STRING(g_level_statement,
2252: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2253: 'RETURN_STATUS = ' || x_return_status);
2254: FND_LOG.STRING(g_level_statement,
2255: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2256: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2257: END IF;
2258: RETURN;

Line 2328: FND_LOG.STRING(g_level_statement,

2324: l_new_row_num).prd_total_tax_amt_funcl_curr);
2325:
2326: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2327: IF (g_level_statement >= g_current_runtime_level ) THEN
2328: FND_LOG.STRING(g_level_statement,
2329: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2330: 'Incorrect return_status after calling ' ||
2331: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
2332: FND_LOG.STRING(g_level_statement,

Line 2332: FND_LOG.STRING(g_level_statement,

2328: FND_LOG.STRING(g_level_statement,
2329: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2330: 'Incorrect return_status after calling ' ||
2331: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
2332: FND_LOG.STRING(g_level_statement,
2333: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2334: 'RETURN_STATUS = ' || x_return_status);
2335: FND_LOG.STRING(g_level_statement,
2336: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2335: FND_LOG.STRING(g_level_statement,

2331: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
2332: FND_LOG.STRING(g_level_statement,
2333: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2334: 'RETURN_STATUS = ' || x_return_status);
2335: FND_LOG.STRING(g_level_statement,
2336: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2337: 'ZX_APPLICABILITY_DETM_PKG.get_taxes_from_applied_from(-)');
2338: END IF;
2339: RETURN;

Line 2477: FND_LOG.STRING(g_level_statement,

2473: l_error_buffer);
2474:
2475: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2476: IF (g_level_statement >= g_current_runtime_level ) THEN
2477: FND_LOG.STRING(g_level_statement,
2478: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2479: 'Incorrect return_status after calling ' ||
2480: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2481: FND_LOG.STRING(g_level_statement,

Line 2481: FND_LOG.STRING(g_level_statement,

2477: FND_LOG.STRING(g_level_statement,
2478: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2479: 'Incorrect return_status after calling ' ||
2480: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2481: FND_LOG.STRING(g_level_statement,
2482: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2483: 'RETURN_STATUS = ' || x_return_status);
2484: FND_LOG.STRING(g_level_statement,
2485: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2484: FND_LOG.STRING(g_level_statement,

2480: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2481: FND_LOG.STRING(g_level_statement,
2482: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2483: 'RETURN_STATUS = ' || x_return_status);
2484: FND_LOG.STRING(g_level_statement,
2485: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2486: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2487: END IF;
2488: RETURN;

Line 2492: FND_LOG.STRING(g_level_procedure,

2488: RETURN;
2489: END IF;
2490:
2491: IF (g_level_procedure >= g_current_runtime_level ) THEN
2492: FND_LOG.STRING(g_level_procedure,
2493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2494: 'x_begin_index = ' || to_char(x_begin_index));
2495: FND_LOG.STRING(g_level_procedure,
2496: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',

Line 2495: FND_LOG.STRING(g_level_procedure,

2491: IF (g_level_procedure >= g_current_runtime_level ) THEN
2492: FND_LOG.STRING(g_level_procedure,
2493: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2494: 'x_begin_index = ' || to_char(x_begin_index));
2495: FND_LOG.STRING(g_level_procedure,
2496: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2497: 'x_end_index = ' || to_char(x_end_index));
2498: FND_LOG.STRING(g_level_procedure,
2499: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',

Line 2498: FND_LOG.STRING(g_level_procedure,

2494: 'x_begin_index = ' || to_char(x_begin_index));
2495: FND_LOG.STRING(g_level_procedure,
2496: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2497: 'x_end_index = ' || to_char(x_end_index));
2498: FND_LOG.STRING(g_level_procedure,
2499: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2500: 'RETURN_STATUS = ' || x_return_status);
2501: FND_LOG.STRING(g_level_procedure,
2502: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2501: FND_LOG.STRING(g_level_procedure,

2497: 'x_end_index = ' || to_char(x_end_index));
2498: FND_LOG.STRING(g_level_procedure,
2499: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2500: 'RETURN_STATUS = ' || x_return_status);
2501: FND_LOG.STRING(g_level_procedure,
2502: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2503: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2504: END IF;
2505:

Line 2511: FND_LOG.STRING(g_level_unexpected,

2507: WHEN OTHERS THEN
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509:
2510: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2511: FND_LOG.STRING(g_level_unexpected,
2512: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2513: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2514: FND_LOG.STRING(g_level_unexpected,
2515: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',

Line 2514: FND_LOG.STRING(g_level_unexpected,

2510: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2511: FND_LOG.STRING(g_level_unexpected,
2512: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from',
2513: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2514: FND_LOG.STRING(g_level_unexpected,
2515: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from.END',
2516: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_applied_from(-)');
2517: END IF;
2518:

Line 2593: FND_LOG.STRING(g_level_procedure,

2589:
2590: BEGIN
2591:
2592: IF (g_level_procedure >= g_current_runtime_level ) THEN
2593: FND_LOG.STRING(g_level_procedure,
2594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2596: FND_LOG.STRING(g_level_procedure,
2597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',

Line 2596: FND_LOG.STRING(g_level_procedure,

2592: IF (g_level_procedure >= g_current_runtime_level ) THEN
2593: FND_LOG.STRING(g_level_procedure,
2594: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.BEGIN',
2595: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(+)');
2596: FND_LOG.STRING(g_level_procedure,
2597: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2598: 'p_trx_line_index = ' || to_char(p_trx_line_index));
2599: END IF;
2600:

Line 2639: FND_LOG.STRING(g_level_statement,

2635: p_error_buffer => l_error_buffer);
2636:
2637: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2638: IF (g_level_statement >= g_current_runtime_level ) THEN
2639: FND_LOG.STRING(g_level_statement,
2640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2641: 'Incorrect return_status after calling ' ||
2642: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
2643: FND_LOG.STRING(g_level_statement,

Line 2643: FND_LOG.STRING(g_level_statement,

2639: FND_LOG.STRING(g_level_statement,
2640: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2641: 'Incorrect return_status after calling ' ||
2642: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
2643: FND_LOG.STRING(g_level_statement,
2644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2645: 'RETURN_STATUS = ' || x_return_status);
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',

Line 2646: FND_LOG.STRING(g_level_statement,

2642: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
2643: FND_LOG.STRING(g_level_statement,
2644: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2645: 'RETURN_STATUS = ' || x_return_status);
2646: FND_LOG.STRING(g_level_statement,
2647: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
2648: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
2649: END IF;
2650:

Line 2714: FND_LOG.STRING(g_level_statement,

2710: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2711: l_new_row_num).tax_apportionment_line_number := tax_line_rec.tax_apportionment_line_number;
2712:
2713: IF (g_level_statement >= g_current_runtime_level ) THEN
2714: FND_LOG.STRING(g_level_statement,
2715: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
2716: 'Tax Apportionment Line Number: Bug6729097 ' ||
2717: to_char(tax_line_rec.tax_apportionment_line_number));
2718: END IF;

Line 2765: FND_LOG.STRING(g_level_statement,

2761: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2762: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
2763: THEN
2764: IF (g_level_statement >= g_current_runtime_level ) THEN
2765: FND_LOG.STRING(g_level_statement,
2766: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2767: 'Current trx is a tax only adjustment. ');
2768: END IF;
2769:

Line 2781: FND_LOG.STRING(g_level_statement,

2777: ELSE
2778: -- current trx is a regular adjustment or CM
2779: -- prorate the line amt to get the unrounded taxable/tax amount
2780: IF (g_level_statement >= g_current_runtime_level ) THEN
2781: FND_LOG.STRING(g_level_statement,
2782: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2783: 'tax_amt_included_flag on Current tax line: '||
2784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2785: l_new_row_num).tax_amt_included_flag);

Line 2786: FND_LOG.STRING(g_level_statement,

2782: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2783: 'tax_amt_included_flag on Current tax line: '||
2784: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2785: l_new_row_num).tax_amt_included_flag);
2786: FND_LOG.STRING(g_level_statement,
2787: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
2788: 'tax_amt_included_flag on original tax line: '||
2789: tax_line_rec.tax_amt_included_flag);
2790: END IF;

Line 3039: FND_LOG.STRING(g_level_statement,

3035: l_error_buffer);
3036:
3037: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3038: IF (g_level_statement >= g_current_runtime_level ) THEN
3039: FND_LOG.STRING(g_level_statement,
3040: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3041: 'Incorrect return_status after calling ' ||
3042: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3043: FND_LOG.STRING(g_level_statement,

Line 3043: FND_LOG.STRING(g_level_statement,

3039: FND_LOG.STRING(g_level_statement,
3040: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3041: 'Incorrect return_status after calling ' ||
3042: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3043: FND_LOG.STRING(g_level_statement,
3044: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3045: 'RETURN_STATUS = ' || x_return_status);
3046: FND_LOG.STRING(g_level_statement,
3047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',

Line 3046: FND_LOG.STRING(g_level_statement,

3042: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3043: FND_LOG.STRING(g_level_statement,
3044: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3045: 'RETURN_STATUS = ' || x_return_status);
3046: FND_LOG.STRING(g_level_statement,
3047: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3048: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3049: END IF;
3050: RETURN;

Line 3054: FND_LOG.STRING(g_level_procedure,

3050: RETURN;
3051: END IF;
3052:
3053: IF (g_level_procedure >= g_current_runtime_level ) THEN
3054: FND_LOG.STRING(g_level_procedure,
3055: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3056: 'x_begin_index = ' || to_char(x_begin_index));
3057: FND_LOG.STRING(g_level_procedure,
3058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',

Line 3057: FND_LOG.STRING(g_level_procedure,

3053: IF (g_level_procedure >= g_current_runtime_level ) THEN
3054: FND_LOG.STRING(g_level_procedure,
3055: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3056: 'x_begin_index = ' || to_char(x_begin_index));
3057: FND_LOG.STRING(g_level_procedure,
3058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3059: 'x_end_index = ' || to_char(x_end_index));
3060: FND_LOG.STRING(g_level_procedure,
3061: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',

Line 3060: FND_LOG.STRING(g_level_procedure,

3056: 'x_begin_index = ' || to_char(x_begin_index));
3057: FND_LOG.STRING(g_level_procedure,
3058: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3059: 'x_end_index = ' || to_char(x_end_index));
3060: FND_LOG.STRING(g_level_procedure,
3061: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3062: 'RETURN_STATUS = ' || x_return_status);
3063: FND_LOG.STRING(g_level_procedure,
3064: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',

Line 3063: FND_LOG.STRING(g_level_procedure,

3059: 'x_end_index = ' || to_char(x_end_index));
3060: FND_LOG.STRING(g_level_procedure,
3061: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3062: 'RETURN_STATUS = ' || x_return_status);
3063: FND_LOG.STRING(g_level_procedure,
3064: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3065: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3066: END IF;
3067:

Line 3073: FND_LOG.STRING(g_level_unexpected,

3069: WHEN OTHERS THEN
3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3071:
3072: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3073: FND_LOG.STRING(g_level_unexpected,
3074: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3075: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3076: FND_LOG.STRING(g_level_unexpected,
3077: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',

Line 3076: FND_LOG.STRING(g_level_unexpected,

3072: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3073: FND_LOG.STRING(g_level_unexpected,
3074: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to',
3075: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3076: FND_LOG.STRING(g_level_unexpected,
3077: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to.END',
3078: 'ZX_TDS_IMPORT_DOCUMENT_PKG.get_taxes_from_adjusted_to(-)');
3079: END IF;
3080: