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

APPS.ZX_TDS_TAX_LINES_POPU_PKG dependencies on FND_LOG

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

2: /* $Header: zxditaxlnpoppkgb.pls 120.68.12010000.8 2009/02/02 10:06:44 tsen ship $ */
3:
4:
5: g_current_runtime_level NUMBER;
6: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: -----------------------------------------------------------------------

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

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

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

4:
5: g_current_runtime_level NUMBER;
6: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: -----------------------------------------------------------------------
11: -- PUBLIC PROCEDURE
12: -- cp_tsrm_val_to_zx_lines

Line 36: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

32: j BINARY_INTEGER;
33:
34: BEGIN
35:
36: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
37:
38: IF (g_level_statement >= g_current_runtime_level ) THEN
39: FND_LOG.STRING(g_level_statement,
40: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.BEGIN',

Line 39: FND_LOG.STRING(g_level_statement,

35:
36: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
37:
38: IF (g_level_statement >= g_current_runtime_level ) THEN
39: FND_LOG.STRING(g_level_statement,
40: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.BEGIN',
41: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(+)');
42: END IF;
43:

Line 56: FND_LOG.STRING(g_level_statement,

52: --
53: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
54:
55: IF (g_level_statement >= g_current_runtime_level ) THEN
56: FND_LOG.STRING(g_level_statement,
57: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
58: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||'Begin index or End index is null');
59:
60: END IF;

Line 518: FND_LOG.STRING(g_level_statement,

514: END LOOP;
515:
516: IF (g_level_statement >= g_current_runtime_level ) THEN
517:
518: FND_LOG.STRING(g_level_statement,
519: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines.END',
520: 'ZX_TDS_TAX_LINES_POPU_PKG: cp_tsrm_val_to_zx_lines(-)'||p_return_status);
521: END IF;
522:

Line 529: FND_LOG.STRING(g_level_unexpected,

525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
527:
528: IF (g_level_unexpected >= g_current_runtime_level ) THEN
529: FND_LOG.STRING(g_level_unexpected,
530: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines',
531: p_error_buffer);
532: END IF;
533:

Line 554: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

550: p_error_buffer OUT NOCOPY VARCHAR2)
551: IS
552: BEGIN
553:
554: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
555:
556: IF (g_level_statement >= g_current_runtime_level ) THEN
557: FND_LOG.STRING(g_level_statement,
558: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_tax_lines.BEGIN',

Line 557: FND_LOG.STRING(g_level_statement,

553:
554: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
555:
556: IF (g_level_statement >= g_current_runtime_level ) THEN
557: FND_LOG.STRING(g_level_statement,
558: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_tax_lines.BEGIN',
559: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_tax_lines(+)');
560: END IF;
561:

Line 596: FND_LOG.STRING(g_level_statement,

592: p_error_buffer);
593:
594: IF (g_level_statement >= g_current_runtime_level ) THEN
595:
596: FND_LOG.STRING(g_level_statement,
597: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_tax_lines.END',
598: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_tax_lines(-)'||p_return_status);
599: END IF;
600:

Line 607: FND_LOG.STRING(g_level_unexpected,

603: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
605:
606: IF (g_level_unexpected >= g_current_runtime_level ) THEN
607: FND_LOG.STRING(g_level_unexpected,
608: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_tax_line',
609: p_error_buffer);
610: END IF;
611:

Line 629: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

625:
626: IS
627: BEGIN
628:
629: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
630:
631: IF (g_level_statement >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_statement,
633: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_orig_columns.BEGIN',

Line 632: FND_LOG.STRING(g_level_statement,

628:
629: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
630:
631: IF (g_level_statement >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_statement,
633: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_orig_columns.BEGIN',
634: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_orig_columns(+)');
635: END IF;
636:

Line 670: FND_LOG.STRING(g_level_statement,

666:
667:
668: IF (g_level_statement >= g_current_runtime_level ) THEN
669:
670: FND_LOG.STRING(g_level_statement,
671: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_orig_columns.END',
672: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_orig_columns(-)');
673: END IF;
674:

Line 679: FND_LOG.STRING(g_level_unexpected,

675: EXCEPTION
676: WHEN OTHERS THEN
677:
678: IF (g_level_unexpected >= g_current_runtime_level ) THEN
679: FND_LOG.STRING(g_level_unexpected,
680: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_orig_columns',
681: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
682: END IF;
683:

Line 706: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

702: IS
703:
704: BEGIN
705:
706: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
707:
708: IF (g_level_statement >= g_current_runtime_level ) THEN
709: FND_LOG.STRING(g_level_statement,
710: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns.BEGIN',

Line 709: FND_LOG.STRING(g_level_statement,

705:
706: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
707:
708: IF (g_level_statement >= g_current_runtime_level ) THEN
709: FND_LOG.STRING(g_level_statement,
710: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns.BEGIN',
711: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_mandatory_columns(+)');
712: END IF;
713:

Line 760: FND_LOG.STRING(g_level_statement,

756: p_tax_line_rec.last_update_date := sysdate;
757:
758: IF (g_level_statement >= g_current_runtime_level ) THEN
759:
760: FND_LOG.STRING(g_level_statement,
761: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns.END',
762: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_mandatory_columns(-)'||p_return_status);
763: END IF;
764:

Line 771: FND_LOG.STRING(g_level_unexpected,

767: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
769:
770: IF (g_level_unexpected >= g_current_runtime_level ) THEN
771: FND_LOG.STRING(g_level_unexpected,
772: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_mandatory_columns',
773: p_error_buffer);
774: END IF;
775:

Line 796: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

792:
793: IS
794: BEGIN
795:
796: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
797:
798: IF (g_level_statement >= g_current_runtime_level ) THEN
799: FND_LOG.STRING(g_level_statement,
800: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns.BEGIN',

Line 799: FND_LOG.STRING(g_level_statement,

795:
796: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
797:
798: IF (g_level_statement >= g_current_runtime_level ) THEN
799: FND_LOG.STRING(g_level_statement,
800: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns.BEGIN',
801: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns(+)');
802: END IF;
803:

Line 820: FND_LOG.STRING(g_level_statement,

816: p_error_buffer);
817: END IF;
818:
819: IF (g_level_statement >= g_current_runtime_level ) THEN
820: FND_LOG.STRING(g_level_statement,
821: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns',
822: 'p_return_status = ' || p_return_status);
823: FND_LOG.STRING(g_level_statement,
824: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns',

Line 823: FND_LOG.STRING(g_level_statement,

819: IF (g_level_statement >= g_current_runtime_level ) THEN
820: FND_LOG.STRING(g_level_statement,
821: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns',
822: 'p_return_status = ' || p_return_status);
823: FND_LOG.STRING(g_level_statement,
824: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns',
825: 'p_error_buffer = ' || p_error_buffer);
826: FND_LOG.STRING(g_level_statement,
827: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns.END',

Line 826: FND_LOG.STRING(g_level_statement,

822: 'p_return_status = ' || p_return_status);
823: FND_LOG.STRING(g_level_statement,
824: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns',
825: 'p_error_buffer = ' || p_error_buffer);
826: FND_LOG.STRING(g_level_statement,
827: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns.END',
828: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns(-)');
829: END IF;
830:

Line 837: FND_LOG.STRING(g_level_unexpected,

833: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
835:
836: IF (g_level_unexpected >= g_current_runtime_level ) THEN
837: FND_LOG.STRING(g_level_unexpected,
838: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns',
839: p_error_buffer);
840: END IF;
841:

Line 862: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

858:
859: IS
860: BEGIN
861:
862: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
863:
864: IF (g_level_statement >= g_current_runtime_level ) THEN
865: FND_LOG.STRING(g_level_statement,
866: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all.BEGIN',

Line 865: FND_LOG.STRING(g_level_statement,

861:
862: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
863:
864: IF (g_level_statement >= g_current_runtime_level ) THEN
865: FND_LOG.STRING(g_level_statement,
866: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all.BEGIN',
867: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns_all(+)');
868: END IF;
869:

Line 920: FND_LOG.STRING(g_level_statement,

916: p_error_buffer := 'tax_status_code can not be NULL';
917: END IF;
918:
919: IF (g_level_statement >= g_current_runtime_level ) THEN
920: FND_LOG.STRING(g_level_statement,
921: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all',
922: 'p_return_status = ' || p_return_status);
923: FND_LOG.STRING(g_level_statement,
924: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all',

Line 923: FND_LOG.STRING(g_level_statement,

919: IF (g_level_statement >= g_current_runtime_level ) THEN
920: FND_LOG.STRING(g_level_statement,
921: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all',
922: 'p_return_status = ' || p_return_status);
923: FND_LOG.STRING(g_level_statement,
924: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all',
925: 'p_error_buffer = ' || p_error_buffer);
926: FND_LOG.STRING(g_level_statement,
927: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all.END',

Line 926: FND_LOG.STRING(g_level_statement,

922: 'p_return_status = ' || p_return_status);
923: FND_LOG.STRING(g_level_statement,
924: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all',
925: 'p_error_buffer = ' || p_error_buffer);
926: FND_LOG.STRING(g_level_statement,
927: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all.END',
928: 'ZX_TDS_TAX_LINES_POPU_PKG: check_mandatory_columns_all(-)');
929: END IF;
930:

Line 937: FND_LOG.STRING(g_level_unexpected,

933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
935:
936: IF (g_level_unexpected >= g_current_runtime_level ) THEN
937: FND_LOG.STRING(g_level_unexpected,
938: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_mandatory_columns_all',
939: p_error_buffer);
940: END IF;
941:

Line 964: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

960:
961: IS
962: BEGIN
963:
964: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
965:
966: IF (g_level_statement >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_statement,
968: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line.BEGIN',

Line 967: FND_LOG.STRING(g_level_statement,

963:
964: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
965:
966: IF (g_level_statement >= g_current_runtime_level ) THEN
967: FND_LOG.STRING(g_level_statement,
968: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line.BEGIN',
969: 'ZX_TDS_TAX_LINES_POPU_PKG: check_non_manual_tax_line(+)');
970: END IF;
971:

Line 1020: FND_LOG.STRING(g_level_statement,

1016:
1017: END IF;
1018:
1019: IF (g_level_statement >= g_current_runtime_level ) THEN
1020: FND_LOG.STRING(g_level_statement,
1021: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line',
1022: 'p_return_status = ' || p_return_status);
1023: FND_LOG.STRING(g_level_statement,
1024: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line',

Line 1023: FND_LOG.STRING(g_level_statement,

1019: IF (g_level_statement >= g_current_runtime_level ) THEN
1020: FND_LOG.STRING(g_level_statement,
1021: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line',
1022: 'p_return_status = ' || p_return_status);
1023: FND_LOG.STRING(g_level_statement,
1024: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line',
1025: 'p_error_buffer = ' || p_error_buffer);
1026: FND_LOG.STRING(g_level_statement,
1027: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line.END',

Line 1026: FND_LOG.STRING(g_level_statement,

1022: 'p_return_status = ' || p_return_status);
1023: FND_LOG.STRING(g_level_statement,
1024: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line',
1025: 'p_error_buffer = ' || p_error_buffer);
1026: FND_LOG.STRING(g_level_statement,
1027: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line.END',
1028: 'ZX_TDS_TAX_LINES_POPU_PKG: check_non_manual_tax_line(-)');
1029: END IF;
1030:

Line 1037: FND_LOG.STRING(g_level_unexpected,

1033: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1034: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1035:
1036: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1037: FND_LOG.STRING(g_level_unexpected,
1038: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.check_non_manual_tax_line',
1039: p_error_buffer);
1040: END IF;
1041:

Line 1068: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1064: IS
1065:
1066: BEGIN
1067:
1068: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1069:
1070: IF (g_level_statement >= g_current_runtime_level ) THEN
1071: FND_LOG.STRING(g_level_statement,
1072: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line.BEGIN',

Line 1071: FND_LOG.STRING(g_level_statement,

1067:
1068: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1069:
1070: IF (g_level_statement >= g_current_runtime_level ) THEN
1071: FND_LOG.STRING(g_level_statement,
1072: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line.BEGIN',
1073: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_tax_line_for_trx_line(+)');
1074: FND_LOG.STRING(g_level_statement,
1075: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',

Line 1074: FND_LOG.STRING(g_level_statement,

1070: IF (g_level_statement >= g_current_runtime_level ) THEN
1071: FND_LOG.STRING(g_level_statement,
1072: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line.BEGIN',
1073: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_tax_line_for_trx_line(+)');
1074: FND_LOG.STRING(g_level_statement,
1075: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',
1076: 'p_begin_index = ' || to_char(p_begin_index));
1077: FND_LOG.STRING(g_level_statement,
1078: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',

Line 1077: FND_LOG.STRING(g_level_statement,

1073: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_tax_line_for_trx_line(+)');
1074: FND_LOG.STRING(g_level_statement,
1075: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',
1076: 'p_begin_index = ' || to_char(p_begin_index));
1077: FND_LOG.STRING(g_level_statement,
1078: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',
1079: 'p_end_index = ' || to_char(p_end_index));
1080: END IF;
1081:

Line 1091: FND_LOG.STRING(g_level_statement,

1087: --
1088: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
1089:
1090: IF (g_level_statement >= g_current_runtime_level ) THEN
1091: FND_LOG.STRING(g_level_statement,
1092: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',
1093: 'Begin index or End index is null' );
1094: END IF;
1095:

Line 1120: FND_LOG.STRING(g_level_statement,

1116: RETURN;
1117: END IF;
1118:
1119: IF (g_level_statement >= g_current_runtime_level ) THEN
1120: FND_LOG.STRING(g_level_statement,
1121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_lines',
1122: 'p_return_status = ' || p_return_status);
1123: FND_LOG.STRING(g_level_statement,
1124: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_lines',

Line 1123: FND_LOG.STRING(g_level_statement,

1119: IF (g_level_statement >= g_current_runtime_level ) THEN
1120: FND_LOG.STRING(g_level_statement,
1121: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_lines',
1122: 'p_return_status = ' || p_return_status);
1123: FND_LOG.STRING(g_level_statement,
1124: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_lines',
1125: 'p_error_buffer = ' || p_error_buffer);
1126: FND_LOG.STRING(g_level_statement,
1127: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_lines.END',

Line 1126: FND_LOG.STRING(g_level_statement,

1122: 'p_return_status = ' || p_return_status);
1123: FND_LOG.STRING(g_level_statement,
1124: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_lines',
1125: 'p_error_buffer = ' || p_error_buffer);
1126: FND_LOG.STRING(g_level_statement,
1127: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_lines.END',
1128: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_tax_line_for_trx_lines(-)');
1129: END IF;
1130:

Line 1137: FND_LOG.STRING(g_level_unexpected,

1133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1135:
1136: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1137: FND_LOG.STRING(g_level_unexpected,
1138: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_tax_line_for_trx_line',
1139: p_error_buffer);
1140: END IF;
1141:

Line 1164: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1160: IS
1161:
1162: BEGIN
1163:
1164: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1165:
1166: IF (g_level_statement >= g_current_runtime_level ) THEN
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line.BEGIN',

Line 1167: FND_LOG.STRING(g_level_statement,

1163:
1164: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1165:
1166: IF (g_level_statement >= g_current_runtime_level ) THEN
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line.BEGIN',
1169: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_mandatory_col_for_trx_line(+)');
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',

Line 1170: FND_LOG.STRING(g_level_statement,

1166: IF (g_level_statement >= g_current_runtime_level ) THEN
1167: FND_LOG.STRING(g_level_statement,
1168: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line.BEGIN',
1169: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_mandatory_col_for_trx_line(+)');
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1172: 'p_begin_index = ' || to_char(p_begin_index));
1173: FND_LOG.STRING(g_level_statement,
1174: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',

Line 1173: FND_LOG.STRING(g_level_statement,

1169: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_mandatory_col_for_trx_line(+)');
1170: FND_LOG.STRING(g_level_statement,
1171: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1172: 'p_begin_index = ' || to_char(p_begin_index));
1173: FND_LOG.STRING(g_level_statement,
1174: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1175: 'p_end_index = ' || to_char(p_end_index));
1176: END IF;
1177:

Line 1186: FND_LOG.STRING(g_level_statement,

1182: --
1183: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
1184:
1185: IF (g_level_statement >= g_current_runtime_level ) THEN
1186: FND_LOG.STRING(g_level_statement,
1187: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1188: 'Begin index or End index is null' );
1189: END IF;
1190:

Line 1197: FND_LOG.STRING(g_level_statement,

1193:
1194: FOR i IN p_begin_index ..p_end_index LOOP
1195:
1196: IF (g_level_statement >= g_current_runtime_level ) THEN
1197: FND_LOG.STRING(g_level_statement,
1198: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1199: 'processing detail line index = ' || to_char(i));
1200: END IF;
1201:

Line 1249: FND_LOG.STRING(g_level_statement,

1245: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).last_update_date :=
1246: sysdate;
1247:
1248: IF (g_level_statement >= g_current_runtime_level ) THEN
1249: FND_LOG.STRING(g_level_statement,
1250: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1251: 'tax_line_id = ' ||
1252: to_char(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_line_id));
1253:

Line 1258: FND_LOG.STRING(g_level_statement,

1254: END IF;
1255: END LOOP;
1256:
1257: IF (g_level_statement >= g_current_runtime_level ) THEN
1258: FND_LOG.STRING(g_level_statement,
1259: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1260: 'p_return_status = ' || p_return_status);
1261: FND_LOG.STRING(g_level_statement,
1262: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',

Line 1261: FND_LOG.STRING(g_level_statement,

1257: IF (g_level_statement >= g_current_runtime_level ) THEN
1258: FND_LOG.STRING(g_level_statement,
1259: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1260: 'p_return_status = ' || p_return_status);
1261: FND_LOG.STRING(g_level_statement,
1262: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1263: 'p_error_buffer = ' || p_error_buffer);
1264: FND_LOG.STRING(g_level_statement,
1265: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line.END',

Line 1264: FND_LOG.STRING(g_level_statement,

1260: 'p_return_status = ' || p_return_status);
1261: FND_LOG.STRING(g_level_statement,
1262: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1263: 'p_error_buffer = ' || p_error_buffer);
1264: FND_LOG.STRING(g_level_statement,
1265: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line.END',
1266: 'ZX_TDS_TAX_LINES_POPU_PKG: pop_mandatory_col_for_trx_line(-)');
1267: END IF;
1268:

Line 1275: FND_LOG.STRING(g_level_unexpected,

1271: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1273:
1274: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1275: FND_LOG.STRING(g_level_unexpected,
1276: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.pop_mandatory_col_for_trx_line',
1277: p_error_buffer);
1278: END IF;
1279:

Line 1302: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1298:
1299: IS
1300: BEGIN
1301:
1302: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1303:
1304: IF (g_level_statement >= g_current_runtime_level ) THEN
1305: FND_LOG.STRING(g_level_statement,
1306: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line.BEGIN',

Line 1305: FND_LOG.STRING(g_level_statement,

1301:
1302: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1303:
1304: IF (g_level_statement >= g_current_runtime_level ) THEN
1305: FND_LOG.STRING(g_level_statement,
1306: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line.BEGIN',
1307: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mandatory_col_for_trx_line(+)');
1308: FND_LOG.STRING(g_level_statement,
1309: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',

Line 1308: FND_LOG.STRING(g_level_statement,

1304: IF (g_level_statement >= g_current_runtime_level ) THEN
1305: FND_LOG.STRING(g_level_statement,
1306: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line.BEGIN',
1307: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mandatory_col_for_trx_line(+)');
1308: FND_LOG.STRING(g_level_statement,
1309: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1310: 'p_begin_index = ' || to_char(p_begin_index));
1311: FND_LOG.STRING(g_level_statement,
1312: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',

Line 1311: FND_LOG.STRING(g_level_statement,

1307: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mandatory_col_for_trx_line(+)');
1308: FND_LOG.STRING(g_level_statement,
1309: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1310: 'p_begin_index = ' || to_char(p_begin_index));
1311: FND_LOG.STRING(g_level_statement,
1312: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1313: 'p_end_index = ' || to_char(p_end_index));
1314: END IF;
1315:

Line 1324: FND_LOG.STRING(g_level_statement,

1320: --
1321: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
1322:
1323: IF (g_level_statement >= g_current_runtime_level ) THEN
1324: FND_LOG.STRING(g_level_statement,
1325: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1326: 'Begin index or End index is null' );
1327: END IF;
1328:

Line 1359: FND_LOG.STRING(g_level_statement,

1355: RETURN;
1356: END IF;
1357:
1358: IF (g_level_statement >= g_current_runtime_level ) THEN
1359: FND_LOG.STRING(g_level_statement,
1360: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1361: 'p_return_status = ' || p_return_status);
1362: FND_LOG.STRING(g_level_statement,
1363: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',

Line 1362: FND_LOG.STRING(g_level_statement,

1358: IF (g_level_statement >= g_current_runtime_level ) THEN
1359: FND_LOG.STRING(g_level_statement,
1360: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1361: 'p_return_status = ' || p_return_status);
1362: FND_LOG.STRING(g_level_statement,
1363: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1364: 'p_error_buffer = ' || p_error_buffer);
1365: FND_LOG.STRING(g_level_statement,
1366: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line.END',

Line 1365: FND_LOG.STRING(g_level_statement,

1361: 'p_return_status = ' || p_return_status);
1362: FND_LOG.STRING(g_level_statement,
1363: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1364: 'p_error_buffer = ' || p_error_buffer);
1365: FND_LOG.STRING(g_level_statement,
1366: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line.END',
1367: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mandatory_col_for_trx_line(-)');
1368: END IF;
1369:

Line 1376: FND_LOG.STRING(g_level_unexpected,

1372: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1374:
1375: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1376: FND_LOG.STRING(g_level_unexpected,
1377: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mandatory_col_for_trx_line',
1378: p_error_buffer);
1379: END IF;
1380:

Line 1402: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1398: p_error_buffer OUT NOCOPY VARCHAR2)
1399: IS
1400: BEGIN
1401:
1402: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1403:
1404: IF (g_level_statement >= g_current_runtime_level ) THEN
1405: FND_LOG.STRING(g_level_statement,
1406: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line.BEGIN',

Line 1405: FND_LOG.STRING(g_level_statement,

1401:
1402: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1403:
1404: IF (g_level_statement >= g_current_runtime_level ) THEN
1405: FND_LOG.STRING(g_level_statement,
1406: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line.BEGIN',
1407: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mand_col_all_for_trx_line(+)');
1408: FND_LOG.STRING(g_level_statement,
1409: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',

Line 1408: FND_LOG.STRING(g_level_statement,

1404: IF (g_level_statement >= g_current_runtime_level ) THEN
1405: FND_LOG.STRING(g_level_statement,
1406: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line.BEGIN',
1407: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mand_col_all_for_trx_line(+)');
1408: FND_LOG.STRING(g_level_statement,
1409: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1410: 'p_begin_index = ' || to_char(p_begin_index));
1411: FND_LOG.STRING(g_level_statement,
1412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',

Line 1411: FND_LOG.STRING(g_level_statement,

1407: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mand_col_all_for_trx_line(+)');
1408: FND_LOG.STRING(g_level_statement,
1409: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1410: 'p_begin_index = ' || to_char(p_begin_index));
1411: FND_LOG.STRING(g_level_statement,
1412: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1413: 'p_end_index = ' || to_char(p_end_index));
1414: END IF;
1415:

Line 1424: FND_LOG.STRING(g_level_statement,

1420: --
1421: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
1422:
1423: IF (g_level_statement >= g_current_runtime_level ) THEN
1424: FND_LOG.STRING(g_level_statement,
1425: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1426: 'Begin index or End index is null' );
1427: END IF;
1428:

Line 1435: FND_LOG.STRING(g_level_statement,

1431:
1432: FOR i IN p_begin_index ..p_end_index LOOP
1433:
1434: IF (g_level_statement >= g_current_runtime_level ) THEN
1435: FND_LOG.STRING(g_level_statement,
1436: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1437: 'processing detail line index = ' || to_char(i));
1438: END IF;
1439:

Line 1494: FND_LOG.STRING(g_level_statement,

1490:
1491: END LOOP;
1492:
1493: IF (g_level_statement >= g_current_runtime_level ) THEN
1494: FND_LOG.STRING(g_level_statement,
1495: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1496: 'p_return_status = ' || p_return_status);
1497: FND_LOG.STRING(g_level_statement,
1498: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',

Line 1497: FND_LOG.STRING(g_level_statement,

1493: IF (g_level_statement >= g_current_runtime_level ) THEN
1494: FND_LOG.STRING(g_level_statement,
1495: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1496: 'p_return_status = ' || p_return_status);
1497: FND_LOG.STRING(g_level_statement,
1498: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1499: 'p_error_buffer = ' || p_error_buffer);
1500: FND_LOG.STRING(g_level_statement,
1501: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line.END',

Line 1500: FND_LOG.STRING(g_level_statement,

1496: 'p_return_status = ' || p_return_status);
1497: FND_LOG.STRING(g_level_statement,
1498: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1499: 'p_error_buffer = ' || p_error_buffer);
1500: FND_LOG.STRING(g_level_statement,
1501: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line.END',
1502: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_mand_col_all_for_trx_line(-)');
1503: END IF;
1504:

Line 1511: FND_LOG.STRING(g_level_unexpected,

1507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1509:
1510: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1511: FND_LOG.STRING(g_level_unexpected,
1512: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_mand_col_all_for_trx_line',
1513: p_error_buffer);
1514: END IF;
1515:

Line 1539: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1535: p_error_buffer OUT NOCOPY VARCHAR2)
1536: IS
1537: BEGIN
1538:
1539: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1540:
1541: IF (g_level_statement >= g_current_runtime_level ) THEN
1542: FND_LOG.STRING(g_level_statement,
1543: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line.BEGIN',

Line 1542: FND_LOG.STRING(g_level_statement,

1538:
1539: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1540:
1541: IF (g_level_statement >= g_current_runtime_level ) THEN
1542: FND_LOG.STRING(g_level_statement,
1543: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line.BEGIN',
1544: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_non_manual_line_f_trx_line(+)');
1545: FND_LOG.STRING(g_level_statement,
1546: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',

Line 1545: FND_LOG.STRING(g_level_statement,

1541: IF (g_level_statement >= g_current_runtime_level ) THEN
1542: FND_LOG.STRING(g_level_statement,
1543: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line.BEGIN',
1544: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_non_manual_line_f_trx_line(+)');
1545: FND_LOG.STRING(g_level_statement,
1546: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1547: 'p_begin_index = ' || to_char(p_begin_index));
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',

Line 1548: FND_LOG.STRING(g_level_statement,

1544: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_non_manual_line_f_trx_line(+)');
1545: FND_LOG.STRING(g_level_statement,
1546: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1547: 'p_begin_index = ' || to_char(p_begin_index));
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1550: 'p_end_index = ' || to_char(p_end_index));
1551: END IF;
1552:

Line 1561: FND_LOG.STRING(g_level_statement,

1557: --
1558: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
1559:
1560: IF (g_level_statement >= g_current_runtime_level ) THEN
1561: FND_LOG.STRING(g_level_statement,
1562: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1563: 'Begin index or End index is null' );
1564: END IF;
1565:

Line 1572: FND_LOG.STRING(g_level_statement,

1568:
1569: FOR i IN p_begin_index ..p_end_index LOOP
1570:
1571: IF (g_level_statement >= g_current_runtime_level ) THEN
1572: FND_LOG.STRING(g_level_statement,
1573: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1574: 'processing detail line index = ' || to_char(i));
1575: END IF;
1576:

Line 1630: FND_LOG.STRING(g_level_statement,

1626: END IF; -- non manual tax line
1627: END LOOP;
1628:
1629: IF (g_level_statement >= g_current_runtime_level ) THEN
1630: FND_LOG.STRING(g_level_statement,
1631: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1632: 'p_return_status = ' || p_return_status);
1633: FND_LOG.STRING(g_level_statement,
1634: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',

Line 1633: FND_LOG.STRING(g_level_statement,

1629: IF (g_level_statement >= g_current_runtime_level ) THEN
1630: FND_LOG.STRING(g_level_statement,
1631: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1632: 'p_return_status = ' || p_return_status);
1633: FND_LOG.STRING(g_level_statement,
1634: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1635: 'p_error_buffer = ' || p_error_buffer);
1636: FND_LOG.STRING(g_level_statement,
1637: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line.END',

Line 1636: FND_LOG.STRING(g_level_statement,

1632: 'p_return_status = ' || p_return_status);
1633: FND_LOG.STRING(g_level_statement,
1634: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1635: 'p_error_buffer = ' || p_error_buffer);
1636: FND_LOG.STRING(g_level_statement,
1637: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line.END',
1638: 'ZX_TDS_TAX_LINES_POPU_PKG: chk_non_manual_line_f_trx_line(-)');
1639: END IF;
1640:

Line 1647: FND_LOG.STRING(g_level_unexpected,

1643: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1645:
1646: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1647: FND_LOG.STRING(g_level_unexpected,
1648: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.chk_non_manual_line_f_trx_line',
1649: p_error_buffer);
1650: END IF;
1651:

Line 1674: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1670:
1671: IS
1672: BEGIN
1673:
1674: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1675:
1676: IF (g_level_procedure >= g_current_runtime_level ) THEN
1677: FND_LOG.STRING(g_level_procedure,
1678: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines.BEGIN',

Line 1677: FND_LOG.STRING(g_level_procedure,

1673:
1674: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1675:
1676: IF (g_level_procedure >= g_current_runtime_level ) THEN
1677: FND_LOG.STRING(g_level_procedure,
1678: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines.BEGIN',
1679: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_tax_lines(+)');
1680: END IF;
1681:

Line 2324: FND_LOG.STRING(g_level_statement,

2320: )
2321: );
2322:
2323: IF (g_level_statement >= g_current_runtime_level ) THEN
2324: FND_LOG.STRING(g_level_statement,
2325: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines',
2326: 'Number of Rows Inserted: ' || SQL%ROWCOUNT);
2327: END IF;
2328:

Line 2330: FND_LOG.STRING(g_level_procedure,

2326: 'Number of Rows Inserted: ' || SQL%ROWCOUNT);
2327: END IF;
2328:
2329: IF (g_level_procedure >= g_current_runtime_level ) THEN
2330: FND_LOG.STRING(g_level_procedure,
2331: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines',
2332: 'p_return_status = ' || p_return_status);
2333: FND_LOG.STRING(g_level_procedure,
2334: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines',

Line 2333: FND_LOG.STRING(g_level_procedure,

2329: IF (g_level_procedure >= g_current_runtime_level ) THEN
2330: FND_LOG.STRING(g_level_procedure,
2331: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines',
2332: 'p_return_status = ' || p_return_status);
2333: FND_LOG.STRING(g_level_procedure,
2334: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines',
2335: 'p_error_buffer = ' || p_error_buffer);
2336: FND_LOG.STRING(g_level_procedure,
2337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines.END',

Line 2336: FND_LOG.STRING(g_level_procedure,

2332: 'p_return_status = ' || p_return_status);
2333: FND_LOG.STRING(g_level_procedure,
2334: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines',
2335: 'p_error_buffer = ' || p_error_buffer);
2336: FND_LOG.STRING(g_level_procedure,
2337: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines.END',
2338: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_tax_lines(-)');
2339: END IF;
2340:

Line 2347: FND_LOG.STRING(g_level_unexpected,

2343: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2344: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2345:
2346: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2347: FND_LOG.STRING(g_level_unexpected,
2348: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_tax_lines',
2349: p_error_buffer);
2350: END IF;
2351:

Line 2374: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2370:
2371: IS
2372: BEGIN
2373:
2374: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2375:
2376: IF (g_level_procedure >= g_current_runtime_level ) THEN
2377: FND_LOG.STRING(g_level_procedure,
2378: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines.BEGIN',

Line 2377: FND_LOG.STRING(g_level_procedure,

2373:
2374: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2375:
2376: IF (g_level_procedure >= g_current_runtime_level ) THEN
2377: FND_LOG.STRING(g_level_procedure,
2378: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines.BEGIN',
2379: 'ZX_TDS_TAX_LINES_POPU_PKG: process_frozen_tax_lines(+)');
2380: END IF;
2381:

Line 3164: FND_LOG.STRING(g_level_statement,

3160: AND zl.cancel_flag <> 'Y'
3161: );
3162:
3163: IF (g_level_statement >= g_current_runtime_level ) THEN
3164: FND_LOG.STRING(g_level_statement,
3165: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3166: 'Number of Rows Updated: ' || SQL%ROWCOUNT);
3167: END IF;
3168:

Line 3822: FND_LOG.STRING(g_level_statement,

3818: )
3819: );
3820:
3821: IF (g_level_statement >= g_current_runtime_level ) THEN
3822: FND_LOG.STRING(g_level_statement,
3823: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3824: 'Number of Rows Inserted: ' || SQL%ROWCOUNT);
3825: END IF;
3826:

Line 3830: FND_LOG.STRING(g_level_procedure,

3826:
3827: END IF; -- tax_event_type_code = OVERRIDE_TAX, or else
3828:
3829: IF (g_level_procedure >= g_current_runtime_level ) THEN
3830: FND_LOG.STRING(g_level_procedure,
3831: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3832: 'p_return_status = ' || p_return_status);
3833: FND_LOG.STRING(g_level_procedure,
3834: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',

Line 3833: FND_LOG.STRING(g_level_procedure,

3829: IF (g_level_procedure >= g_current_runtime_level ) THEN
3830: FND_LOG.STRING(g_level_procedure,
3831: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3832: 'p_return_status = ' || p_return_status);
3833: FND_LOG.STRING(g_level_procedure,
3834: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3835: 'p_error_buffer = ' || p_error_buffer);
3836: FND_LOG.STRING(g_level_procedure,
3837: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines.END',

Line 3836: FND_LOG.STRING(g_level_procedure,

3832: 'p_return_status = ' || p_return_status);
3833: FND_LOG.STRING(g_level_procedure,
3834: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3835: 'p_error_buffer = ' || p_error_buffer);
3836: FND_LOG.STRING(g_level_procedure,
3837: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines.END',
3838: 'ZX_TDS_TAX_LINES_POPU_PKG: process_frozen_tax_lines(-)');
3839: END IF;
3840:

Line 3847: FND_LOG.STRING(g_level_unexpected,

3843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3844: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3845:
3846: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3847: FND_LOG.STRING(g_level_unexpected,
3848: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_frozen_tax_lines',
3849: p_error_buffer);
3850: END IF;
3851:

Line 3873: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3869:
3870: IS
3871: BEGIN
3872:
3873: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3874:
3875: IF (g_level_procedure >= g_current_runtime_level ) THEN
3876: FND_LOG.STRING(g_level_procedure,
3877: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines.BEGIN',

Line 3876: FND_LOG.STRING(g_level_procedure,

3872:
3873: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3874:
3875: IF (g_level_procedure >= g_current_runtime_level ) THEN
3876: FND_LOG.STRING(g_level_procedure,
3877: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines.BEGIN',
3878: 'ZX_TDS_TAX_LINES_POPU_PKG: process_discard_tax_lines(+)');
3879: END IF;
3880:

Line 4525: FND_LOG.STRING(g_level_procedure,

4521: )
4522: );
4523:
4524: IF (g_level_procedure >= g_current_runtime_level ) THEN
4525: FND_LOG.STRING(g_level_procedure,
4526: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines',
4527: 'p_return_status = ' || p_return_status);
4528: FND_LOG.STRING(g_level_procedure,
4529: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines',

Line 4528: FND_LOG.STRING(g_level_procedure,

4524: IF (g_level_procedure >= g_current_runtime_level ) THEN
4525: FND_LOG.STRING(g_level_procedure,
4526: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines',
4527: 'p_return_status = ' || p_return_status);
4528: FND_LOG.STRING(g_level_procedure,
4529: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines',
4530: 'p_error_buffer = ' || p_error_buffer);
4531: FND_LOG.STRING(g_level_procedure,
4532: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines.END',

Line 4531: FND_LOG.STRING(g_level_procedure,

4527: 'p_return_status = ' || p_return_status);
4528: FND_LOG.STRING(g_level_procedure,
4529: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines',
4530: 'p_error_buffer = ' || p_error_buffer);
4531: FND_LOG.STRING(g_level_procedure,
4532: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines.END',
4533: 'ZX_TDS_TAX_LINES_POPU_PKG: process_discard_tax_lines(-)');
4534: END IF;
4535:

Line 4542: FND_LOG.STRING(g_level_unexpected,

4538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
4540:
4541: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4542: FND_LOG.STRING(g_level_unexpected,
4543: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_discard_tax_lines',
4544: p_error_buffer);
4545: END IF;
4546:

Line 4569: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4565:
4566: IS
4567: BEGIN
4568:
4569: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4570:
4571: IF (g_level_procedure >= g_current_runtime_level ) THEN
4572: FND_LOG.STRING(g_level_procedure,
4573: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines.BEGIN',

Line 4572: FND_LOG.STRING(g_level_procedure,

4568:
4569: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4570:
4571: IF (g_level_procedure >= g_current_runtime_level ) THEN
4572: FND_LOG.STRING(g_level_procedure,
4573: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines.BEGIN',
4574: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_trx_lines(+)');
4575: END IF;
4576:

Line 5199: FND_LOG.STRING(g_level_procedure,

5195:
5196: );
5197:
5198: IF (g_level_procedure >= g_current_runtime_level ) THEN
5199: FND_LOG.STRING(g_level_procedure,
5200: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines',
5201: 'p_return_status = ' || p_return_status);
5202: FND_LOG.STRING(g_level_procedure,
5203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines',

Line 5202: FND_LOG.STRING(g_level_procedure,

5198: IF (g_level_procedure >= g_current_runtime_level ) THEN
5199: FND_LOG.STRING(g_level_procedure,
5200: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines',
5201: 'p_return_status = ' || p_return_status);
5202: FND_LOG.STRING(g_level_procedure,
5203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines',
5204: 'p_error_buffer = ' || p_error_buffer);
5205: FND_LOG.STRING(g_level_procedure,
5206: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines.END',

Line 5205: FND_LOG.STRING(g_level_procedure,

5201: 'p_return_status = ' || p_return_status);
5202: FND_LOG.STRING(g_level_procedure,
5203: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines',
5204: 'p_error_buffer = ' || p_error_buffer);
5205: FND_LOG.STRING(g_level_procedure,
5206: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines.END',
5207: 'ZX_TDS_TAX_LINES_POPU_PKG: process_cancel_trx_lines(-)');
5208: END IF;
5209:

Line 5216: FND_LOG.STRING(g_level_unexpected,

5212: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5214:
5215: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5216: FND_LOG.STRING(g_level_unexpected,
5217: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_cancel_trx_lines',
5218: p_error_buffer);
5219: END IF;
5220:

Line 5393: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5389: );
5390:
5391: BEGIN
5392:
5393: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5394:
5395: IF (g_level_statement >= g_current_runtime_level ) THEN
5396: FND_LOG.STRING(g_level_statement,
5397: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance.BEGIN',

Line 5396: FND_LOG.STRING(g_level_statement,

5392:
5393: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5394:
5395: IF (g_level_statement >= g_current_runtime_level ) THEN
5396: FND_LOG.STRING(g_level_statement,
5397: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance.BEGIN',
5398: 'ZX_TDS_TAX_LINES_POPU_PKG: process_tax_tolerance(+)');
5399: END IF;
5400:

Line 5478: FND_LOG.STRING(g_level_statement,

5474:
5475: l_count := l_orig_tax_amt_tax_curr_tbl.COUNT;
5476:
5477: IF (g_level_statement >= g_current_runtime_level ) THEN
5478: FND_LOG.STRING(g_level_statement,
5479: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',
5480: 'number of rows fetched = ' || to_char(l_count));
5481: END IF;
5482:

Line 5564: FND_LOG.STRING(g_level_statement,

5560: -- bulk update the current rows processed
5561: -- before fetch the next set of rows
5562: --
5563: IF (g_level_statement >= g_current_runtime_level ) THEN
5564: FND_LOG.STRING(g_level_statement,
5565: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',
5566: 'update ZX_DETAIL_TAX_LINES_GT with tax hold info');
5567: END IF;
5568:

Line 5615: FND_LOG.STRING(g_level_statement,

5611: RETURN;
5612: END IF;
5613:
5614: IF (g_level_statement >= g_current_runtime_level ) THEN
5615: FND_LOG.STRING(g_level_statement,
5616: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',
5617: 'p_return_status = ' || p_return_status);
5618: FND_LOG.STRING(g_level_statement,
5619: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',

Line 5618: FND_LOG.STRING(g_level_statement,

5614: IF (g_level_statement >= g_current_runtime_level ) THEN
5615: FND_LOG.STRING(g_level_statement,
5616: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',
5617: 'p_return_status = ' || p_return_status);
5618: FND_LOG.STRING(g_level_statement,
5619: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',
5620: 'p_error_buffer = ' || p_error_buffer);
5621: FND_LOG.STRING(g_level_statement,
5622: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance.END',

Line 5621: FND_LOG.STRING(g_level_statement,

5617: 'p_return_status = ' || p_return_status);
5618: FND_LOG.STRING(g_level_statement,
5619: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',
5620: 'p_error_buffer = ' || p_error_buffer);
5621: FND_LOG.STRING(g_level_statement,
5622: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance.END',
5623: 'ZX_TDS_TAX_LINES_POPU_PKG: process_tax_tolerance(-)');
5624: END IF;
5625:

Line 5632: FND_LOG.STRING(g_level_unexpected,

5628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5629: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5630:
5631: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5632: FND_LOG.STRING(g_level_unexpected,
5633: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.process_tax_tolerance',
5634: p_error_buffer);
5635: END IF;
5636:

Line 5660: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5656: IS
5657:
5658: BEGIN
5659:
5660: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5661:
5662: IF (g_level_statement >= g_current_runtime_level ) THEN
5663: FND_LOG.STRING(g_level_statement,
5664: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg.BEGIN',

Line 5663: FND_LOG.STRING(g_level_statement,

5659:
5660: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5661:
5662: IF (g_level_statement >= g_current_runtime_level ) THEN
5663: FND_LOG.STRING(g_level_statement,
5664: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg.BEGIN',
5665: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_recovery_flg(+)');
5666: FND_LOG.STRING(g_level_statement,
5667: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg',

Line 5666: FND_LOG.STRING(g_level_statement,

5662: IF (g_level_statement >= g_current_runtime_level ) THEN
5663: FND_LOG.STRING(g_level_statement,
5664: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg.BEGIN',
5665: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_recovery_flg(+)');
5666: FND_LOG.STRING(g_level_statement,
5667: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg',
5668: 'begin_index = ' || to_char(p_begin_index) || ' end_index= '
5669: || to_char(p_end_index));
5670: END IF;

Line 5680: FND_LOG.STRING(g_level_statement,

5676: --
5677: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
5678:
5679: IF (g_level_statement >= g_current_runtime_level ) THEN
5680: FND_LOG.STRING(g_level_statement,
5681: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg',
5682: 'Begin index or End index is null' );
5683: END IF;
5684:

Line 5712: FND_LOG.STRING(g_level_statement,

5708: END LOOP;
5709: END IF;
5710:
5711: IF (g_level_statement >= g_current_runtime_level ) THEN
5712: FND_LOG.STRING(g_level_statement,
5713: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg.END',
5714: 'ZX_TDS_TAX_LINES_POPU_PKG: populate_recovery_flg(-)');
5715: END IF;
5716:

Line 5722: FND_LOG.STRING(g_level_unexpected,

5718: WHEN OTHERS THEN
5719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5720: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
5721: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5722: FND_LOG.STRING(g_level_unexpected,
5723: 'ZX.PLSQL.ZX_TDS_TAX_LINES_POPU_PKG.populate_recovery_flg',
5724: p_error_buffer);
5725: END IF;
5726: