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_RATE_DETM_PKG dependencies on FND_LOG

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

1: PACKAGE BODY ZX_TDS_RATE_DETM_PKG AS
2: /* $Header: zxditxratedtpkgb.pls 120.77.12010000.4 2008/12/11 04:24:23 tsen 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_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

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

2: /* $Header: zxditxratedtpkgb.pls 120.77.12010000.4 2008/12/11 04:24:23 tsen 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_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------

Line 7: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

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_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------
11: -- PRIVATE PROCEDURE

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_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------
11: -- PRIVATE PROCEDURE
12: ------------------------------------------------------------------------------

Line 141: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

137:
138:
139: BEGIN
140:
141: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
142:
143: IF (g_level_procedure >= g_current_runtime_level ) THEN
144: FND_LOG.STRING(g_level_procedure,
145: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.GET_TAX_RATE.BEGIN',

Line 144: FND_LOG.STRING(g_level_procedure,

140:
141: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
142:
143: IF (g_level_procedure >= g_current_runtime_level ) THEN
144: FND_LOG.STRING(g_level_procedure,
145: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.GET_TAX_RATE.BEGIN',
146: 'ZX_TDS_RATE_DETM_PKG: GET_TAX_RATE(+)');
147: END IF;
148:

Line 157: FND_LOG.STRING(g_level_error,

153: IF p_begin_index IS NULL or p_end_index IS NULL THEN
154: p_return_status:= FND_API.G_RET_STS_ERROR;
155: IF (g_level_error >= g_current_runtime_level ) THEN
156:
157: FND_LOG.STRING(g_level_error,
158: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
159: ' unexpected error:' || 'p_begin_index or p_end_index IS NULL...');
160: END IF;
161: RETURN;

Line 179: FND_LOG.STRING(g_level_statement,

175:
176: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate IS NOT NULL AND
177: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.source_event_class_code(p_structure_index) = 'INTERCOMPANY_TRX' THEN
178: IF (g_level_statement >= g_current_runtime_level ) THEN
179: FND_LOG.STRING(g_level_statement,
180: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
181: ' Intercompany Transaction : Tax rate : ' || ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate);
182: END IF;
183: ELSE

Line 202: FND_LOG.STRING(g_level_statement,

198: l_tax_date := NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_date,
199: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
200:
201: IF (g_level_statement >= g_current_runtime_level ) THEN
202: FND_LOG.STRING(g_level_statement,
203: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
204: ' Tax Date ' || l_tax_date);
205: END IF;
206:

Line 230: FND_LOG.STRING(g_level_error,

226: p_return_status:= FND_API.G_RET_STS_ERROR;
227: p_error_buffer :=
228: 'Tax Rate must be entered when last manual entry is Tax Amount';
229: IF (g_level_error >= g_current_runtime_level ) THEN
230: FND_LOG.STRING(g_level_error,
231: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
232: 'p_error_buffer: '|| p_error_buffer);
233: END IF;
234: RETURN;

Line 325: FND_LOG.STRING(g_level_error,

321: p_error_buffer := 'Need to create Offset Tax. But offset tax is not
322: valid'; -- will be replaced with coded message
323:
324: IF g_level_error >= g_current_runtime_level THEN
325: FND_LOG.STRING(g_level_error,
326: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
327: 'Need to create Offset Tax. But offset tax is not valid');
328: FND_LOG.STRING(g_level_error,
329: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 328: FND_LOG.STRING(g_level_error,

324: IF g_level_error >= g_current_runtime_level THEN
325: FND_LOG.STRING(g_level_error,
326: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
327: 'Need to create Offset Tax. But offset tax is not valid');
328: FND_LOG.STRING(g_level_error,
329: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
330: 'RETURN_STATUS = ' || p_return_status);
331: FND_LOG.STRING(g_level_error,
332: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 331: FND_LOG.STRING(g_level_error,

327: 'Need to create Offset Tax. But offset tax is not valid');
328: FND_LOG.STRING(g_level_error,
329: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
330: 'RETURN_STATUS = ' || p_return_status);
331: FND_LOG.STRING(g_level_error,
332: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
333: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
334: END IF;
335: RETURN;

Line 480: FND_LOG.STRING(g_level_error,

476: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
477: p_error_buffer := 'The Tax Status information could not be located in cache.';
478:
479: IF (g_level_error >= g_current_runtime_level ) THEN
480: FND_LOG.STRING(g_level_error,
481: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
482: 'Could not locate the status record in cache....');
483: END IF;
484:

Line 519: FND_LOG.STRING(g_level_error,

515: IF p_return_status IN ( FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR)
516: THEN
517: -- error is raised in rule based evaluation. Abort processing.
518: IF (g_level_error >= g_current_runtime_level ) THEN
519: FND_LOG.STRING(g_level_error,
520: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
521: 'Rule Based engine returned error. Aborting... ');
522: END IF;
523: RETURN;

Line 531: FND_LOG.STRING(g_level_statement,

527: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
528: i).rate_result_id := l_zx_result_rec.result_id;
529:
530: IF (g_level_statement >= g_current_runtime_level ) THEN
531: FND_LOG.STRING(g_level_statement,
532: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
533: 'l_tax_rate_code returned by rule base process is '||
534: l_zx_result_rec.alphanumeric_result);
535:

Line 560: FND_LOG.STRING(g_level_error,

556: );
557:
558: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
559: IF (g_level_error >= g_current_runtime_level ) THEN
560: FND_LOG.STRING(g_level_error,
561: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
562: 'Incorrect return_status after calling ' ||
563: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
564: FND_LOG.STRING(g_level_error,

Line 564: FND_LOG.STRING(g_level_error,

560: FND_LOG.STRING(g_level_error,
561: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
562: 'Incorrect return_status after calling ' ||
563: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
564: FND_LOG.STRING(g_level_error,
565: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
566: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
567: END IF;
568:

Line 628: FND_LOG.STRING(g_level_error,

624: -- UI need to take care of not to allow slabbed tax defined.
625: p_return_status:= FND_API.G_RET_STS_ERROR;
626: p_error_buffer := 'Slabbed rates are not supported in phase 1a ';
627: IF (g_level_error >= g_current_runtime_level ) THEN
628: FND_LOG.STRING(g_level_error,
629: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
630: 'p_error_buffer: '|| p_error_buffer);
631: END IF;
632: RETURN;

Line 655: FND_LOG.STRING(g_level_error,

651: p_error_buffer := 'UOM_CODE on the transaction does not match the '||
652: ' UOM_CODE on the rate ';
653:
654: IF (g_level_error >= g_current_runtime_level ) THEN
655: FND_LOG.STRING(g_level_error,
656: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
657: 'The UOM '||l_uom_code||' for quantity rate '||l_tax_rate_code ||
658: ' is not the same as the UOM '||
659: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.uom_code(

Line 685: FND_LOG.STRING(g_level_procedure,

681:
682: END IF;
683:
684: IF (g_level_procedure >= g_current_runtime_level ) THEN
685: FND_LOG.STRING(g_level_procedure,
686: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
687: 'tax rate code: ' ||l_tax_rate_code ||' tax_rate = ' || l_tax_rate);
688: END IF;
689:

Line 694: FND_LOG.STRING(g_level_error,

690: ELSE -- if l_tax_rate_code is NULL
691: p_return_status:= FND_API.G_RET_STS_ERROR; -- error
692:
693: IF (g_level_error>= g_current_runtime_level ) THEN
694: FND_LOG.STRING(g_level_error,
695: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
696: 'Tax_rate_code not found for tax: '|| l_tax ||
697: 'tax_status: '||l_tax_status_code);
698: END IF;

Line 724: FND_LOG.STRING(g_level_error,

720: -- rate associated with the rate_code
721: p_return_status:= FND_API.G_RET_STS_ERROR; -- error
722: p_error_buffer := 'Error: No tax rate found';
723: IF (g_level_error >= g_current_runtime_level ) THEN
724: FND_LOG.STRING(g_level_error,
725: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
726: p_error_buffer);
727: END IF;
728: RETURN;

Line 762: FND_LOG.STRING(g_level_error,

758: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: p_error_buffer := 'Need to create Offset Tax. But offset tax is not valid'; -- will be replaced with coded message
760:
761: IF g_level_error >= g_current_runtime_level THEN
762: FND_LOG.STRING(g_level_error,
763: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
764: 'Need to create Offset Tax. But offset tax is not valid');
765: FND_LOG.STRING(g_level_error,
766: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 765: FND_LOG.STRING(g_level_error,

761: IF g_level_error >= g_current_runtime_level THEN
762: FND_LOG.STRING(g_level_error,
763: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
764: 'Need to create Offset Tax. But offset tax is not valid');
765: FND_LOG.STRING(g_level_error,
766: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
767: 'RETURN_STATUS = ' || p_return_status);
768: FND_LOG.STRING(g_level_error,
769: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 768: FND_LOG.STRING(g_level_error,

764: 'Need to create Offset Tax. But offset tax is not valid');
765: FND_LOG.STRING(g_level_error,
766: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
767: 'RETURN_STATUS = ' || p_return_status);
768: FND_LOG.STRING(g_level_error,
769: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
770: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
771: END IF;
772: RETURN;

Line 802: FND_LOG.STRING(g_level_statement,

798:
799: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
800:
801: IF (g_level_statement >= g_current_runtime_level ) THEN
802: FND_LOG.STRING(g_level_statement,
803: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
804: 'Offset tax not found, reset the return status and continue the process');
805: END IF;
806: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 835: FND_LOG.STRING(g_level_error,

831: p_error_buffer);
832:
833: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
834: IF (g_level_error >= g_current_runtime_level ) THEN
835: FND_LOG.STRING(g_level_error,
836: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
837: 'Incorrect return_status after calling ' ||
838: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
839: FND_LOG.STRING(g_level_error,

Line 839: FND_LOG.STRING(g_level_error,

835: FND_LOG.STRING(g_level_error,
836: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
837: 'Incorrect return_status after calling ' ||
838: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
839: FND_LOG.STRING(g_level_error,
840: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
841: 'l_account_site_id = ' || l_account_site_id);
842: FND_LOG.STRING(g_level_error,
843: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 842: FND_LOG.STRING(g_level_error,

838: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
839: FND_LOG.STRING(g_level_error,
840: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
841: 'l_account_site_id = ' || l_account_site_id);
842: FND_LOG.STRING(g_level_error,
843: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
844: 'RETURN_STATUS = ' || p_return_status);
845: FND_LOG.STRING(g_level_error,
846: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 845: FND_LOG.STRING(g_level_error,

841: 'l_account_site_id = ' || l_account_site_id);
842: FND_LOG.STRING(g_level_error,
843: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
844: 'RETURN_STATUS = ' || p_return_status);
845: FND_LOG.STRING(g_level_error,
846: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
847: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
848: END IF;
849: RETURN;

Line 864: FND_LOG.STRING(g_level_error,

860: p_error_buffer);
861:
862: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
863: IF (g_level_error >= g_current_runtime_level ) THEN
864: FND_LOG.STRING(g_level_error,
865: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
866: 'Incorrect return_status after calling ' ||
867: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
868: FND_LOG.STRING(g_level_error,

Line 868: FND_LOG.STRING(g_level_error,

864: FND_LOG.STRING(g_level_error,
865: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
866: 'Incorrect return_status after calling ' ||
867: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
868: FND_LOG.STRING(g_level_error,
869: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
870: 'l_account_id = ' || l_account_id);
871: FND_LOG.STRING(g_level_error,
872: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 871: FND_LOG.STRING(g_level_error,

867: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
868: FND_LOG.STRING(g_level_error,
869: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
870: 'l_account_id = ' || l_account_id);
871: FND_LOG.STRING(g_level_error,
872: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
873: 'RETURN_STATUS = ' || p_return_status);
874: FND_LOG.STRING(g_level_error,
875: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 874: FND_LOG.STRING(g_level_error,

870: 'l_account_id = ' || l_account_id);
871: FND_LOG.STRING(g_level_error,
872: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
873: 'RETURN_STATUS = ' || p_return_status);
874: FND_LOG.STRING(g_level_error,
875: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
876: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
877: END IF;
878: RETURN;

Line 887: FND_LOG.STRING(g_level_error,

883: FETCH get_ap_supplier_site_csr INTO l_offset_tax_appl;
884: CLOSE get_ap_supplier_site_csr;
885:
886: IF (g_level_error >= g_current_runtime_level ) THEN
887: FND_LOG.STRING(g_level_error,
888: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
889: 'l_account_site_id = '||l_account_site_id);
890: FND_LOG.STRING(g_level_error,
891: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 890: FND_LOG.STRING(g_level_error,

886: IF (g_level_error >= g_current_runtime_level ) THEN
887: FND_LOG.STRING(g_level_error,
888: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
889: 'l_account_site_id = '||l_account_site_id);
890: FND_LOG.STRING(g_level_error,
891: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
892: 'l_offset_tax_appl = '||l_offset_tax_appl);
893: END IF;
894:

Line 911: FND_LOG.STRING(g_level_error,

907: p_error_buffer);
908:
909: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
910: IF (g_level_error >= g_current_runtime_level ) THEN
911: FND_LOG.STRING(g_level_error,
912: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
913: 'Incorrect return_status after calling ' ||
914: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
915: FND_LOG.STRING(g_level_error,

Line 915: FND_LOG.STRING(g_level_error,

911: FND_LOG.STRING(g_level_error,
912: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
913: 'Incorrect return_status after calling ' ||
914: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
915: FND_LOG.STRING(g_level_error,
916: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
917: 'l_account_id = ' || l_account_id);
918: FND_LOG.STRING(g_level_error,
919: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 918: FND_LOG.STRING(g_level_error,

914: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
915: FND_LOG.STRING(g_level_error,
916: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
917: 'l_account_id = ' || l_account_id);
918: FND_LOG.STRING(g_level_error,
919: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
920: 'RETURN_STATUS = ' || p_return_status);
921: FND_LOG.STRING(g_level_error,
922: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 921: FND_LOG.STRING(g_level_error,

917: 'l_account_id = ' || l_account_id);
918: FND_LOG.STRING(g_level_error,
919: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
920: 'RETURN_STATUS = ' || p_return_status);
921: FND_LOG.STRING(g_level_error,
922: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
923: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
924: END IF;
925: RETURN;

Line 933: FND_LOG.STRING(g_level_error,

929: FETCH get_ap_supplier_csr INTO l_offset_tax_appl;
930: CLOSE get_ap_supplier_csr;
931:
932: IF (g_level_error >= g_current_runtime_level ) THEN
933: FND_LOG.STRING(g_level_error,
934: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
935: 'l_account_id = '||l_account_id);
936: FND_LOG.STRING(g_level_error,
937: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 936: FND_LOG.STRING(g_level_error,

932: IF (g_level_error >= g_current_runtime_level ) THEN
933: FND_LOG.STRING(g_level_error,
934: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
935: 'l_account_id = '||l_account_id);
936: FND_LOG.STRING(g_level_error,
937: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
938: 'l_offset_tax_appl= '||l_offset_tax_appl);
939: END IF;
940:

Line 959: FND_LOG.STRING(g_level_error,

955: FETCH get_ptp_cur into l_offset_tax_appl;
956: CLOSE get_ptp_cur;
957:
958: IF (g_level_error >= g_current_runtime_level ) THEN
959: FND_LOG.STRING(g_level_error,
960: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
961: 'l_offset_tax_appl(from PTP) = '||l_offset_tax_appl);
962: END IF;
963:

Line 985: -- FND_LOG.STRING(g_level_statement,

981: --THEN
982: -- -- Error is raised in rule based evaluation. Abort processing.
983: -- --
984: -- IF (g_level_statement >= g_current_runtime_level ) THEN
985: -- FND_LOG.STRING(g_level_statement,
986: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
987: -- 'Rule Based engine returned error. Aborting... ');
988: -- END IF;
989: -- p_return_status:= FND_API.G_RET_STS_ERROR;

Line 993: -- FND_LOG.STRING(g_level_statement,

989: -- p_return_status:= FND_API.G_RET_STS_ERROR;
990: -- p_error_buffer := 'Rule Based engine returned error during offset tax determination ';
991: --
992: -- IF (g_level_statement >= g_current_runtime_level ) THEN
993: -- FND_LOG.STRING(g_level_statement,
994: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
995: -- 'p_error_buffer: '|| p_error_buffer);
996: -- END IF;
997: -- RETURN;

Line 1005: FND_LOG.STRING(g_level_procedure,

1001: IF nvl(l_offset_tax_appl,'N') = 'Y' THEN
1002:
1003: IF (g_level_procedure >= g_current_runtime_level ) THEN
1004:
1005: FND_LOG.STRING(g_level_procedure,
1006: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1007: 'Offset tax applicable...');
1008: END IF;
1009:

Line 1022: -- FND_LOG.STRING(g_level_statement,

1018: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number :=
1019: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1020:
1021: --IF (g_level_statement >= g_current_runtime_level ) THEN
1022: -- FND_LOG.STRING(g_level_statement,
1023: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1024: -- 'offset_tax_line_number = '||
1025: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1026: -- i).offset_tax_line_number);

Line 1030: FND_LOG.STRING(g_level_statement,

1026: -- i).offset_tax_line_number);
1027: --END IF;
1028: ELSE
1029: IF (g_level_statement >= g_current_runtime_level ) THEN
1030: FND_LOG.STRING(g_level_statement,
1031: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1032: 'Offset tax not applicable...');
1033: END IF;
1034:

Line 1082: FND_LOG.STRING(g_level_error,

1078: p_return_status:= FND_API.G_RET_STS_ERROR;
1079: p_error_buffer := 'Different Exception rate is specified for non-adhoc tax.';
1080:
1081: IF (g_level_error >= g_current_runtime_level) THEN
1082: FND_LOG.STRING(g_level_error,
1083: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1084: p_error_buffer);
1085: FND_LOG.STRING(g_level_error,
1086: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1085: FND_LOG.STRING(g_level_error,

1081: IF (g_level_error >= g_current_runtime_level) THEN
1082: FND_LOG.STRING(g_level_error,
1083: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1084: p_error_buffer);
1085: FND_LOG.STRING(g_level_error,
1086: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1087: 'l_tax_rate = ' ||l_tax_rate);
1088: FND_LOG.STRING(g_level_error,
1089: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1088: FND_LOG.STRING(g_level_error,

1084: p_error_buffer);
1085: FND_LOG.STRING(g_level_error,
1086: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1087: 'l_tax_rate = ' ||l_tax_rate);
1088: FND_LOG.STRING(g_level_error,
1089: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1090: 'l_numeric_result = ' || l_numeric_result);
1091: FND_LOG.STRING(g_level_error,
1092: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1091: FND_LOG.STRING(g_level_error,

1087: 'l_tax_rate = ' ||l_tax_rate);
1088: FND_LOG.STRING(g_level_error,
1089: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1090: 'l_numeric_result = ' || l_numeric_result);
1091: FND_LOG.STRING(g_level_error,
1092: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1093: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-) ');
1094: END IF;
1095: RETURN;

Line 1138: FND_LOG.STRING(g_level_error,

1134: );
1135:
1136: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1137: IF (g_level_error >= g_current_runtime_level ) THEN
1138: FND_LOG.STRING(g_level_error,
1139: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1140: 'Incorrect return_status after calling ' ||
1141: 'ZX_TCM_GET_EXCEPT_PKG.get_tax_exceptions');
1142: FND_LOG.STRING(g_level_error,

Line 1142: FND_LOG.STRING(g_level_error,

1138: FND_LOG.STRING(g_level_error,
1139: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1140: 'Incorrect return_status after calling ' ||
1141: 'ZX_TCM_GET_EXCEPT_PKG.get_tax_exceptions');
1142: FND_LOG.STRING(g_level_error,
1143: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1144: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
1145: END IF;
1146:

Line 1183: FND_LOG.STRING(g_level_statement,

1179: IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1180: l_tax_id).tax_exmpt_source_tax IS NOT NULL
1181: THEN
1182: IF (g_level_statement >= g_current_runtime_level ) THEN
1183: FND_LOG.STRING(g_level_statement,
1184: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1185: 'Current tax has a source tax: ' ||
1186: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_exmpt_source_tax);
1187:

Line 1208: FND_LOG.STRING(g_level_statement,

1204: END IF;
1205:
1206: IF l_exemption_rec.exemption_id IS NULL THEN
1207: IF (g_level_statement >= g_current_runtime_level ) THEN
1208: FND_LOG.STRING(g_level_statement,
1209: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1210: 'There is no source tax or no source tax exemptions info '||
1211: 'calling TCM exemption API to get exemption info.');
1212: END IF;

Line 1264: FND_LOG.STRING(g_level_error,

1260: x_exemption_rec => l_exemption_rec);
1261:
1262: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1263: IF (g_level_error >= g_current_runtime_level ) THEN
1264: FND_LOG.STRING(g_level_error,
1265: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1266: 'Incorrect return_status after calling ' ||
1267: ' ZX_TCM_GET_EXEMPT_PKG.get_tax_exemptions');
1268: FND_LOG.STRING(g_level_error,

Line 1268: FND_LOG.STRING(g_level_error,

1264: FND_LOG.STRING(g_level_error,
1265: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1266: 'Incorrect return_status after calling ' ||
1267: ' ZX_TCM_GET_EXEMPT_PKG.get_tax_exemptions');
1268: FND_LOG.STRING(g_level_error,
1269: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1270: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
1271: END IF;
1272:

Line 1340: FND_LOG.STRING(g_level_statement,

1336: := l_exemption_rec.percent_exempt / l_tax_rate;
1337: l_tax_rate := l_exemption_rec.percent_exempt;
1338: ELSE
1339: IF (g_level_statement >= g_current_runtime_level ) THEN
1340: FND_LOG.STRING(g_level_statement,
1341: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1342: 'tax_rate is Zero, no exemption needed. ' );
1343: END IF;
1344: END IF;

Line 1395: FND_LOG.STRING(g_level_error,

1391:
1392: p_return_status:= FND_API.G_RET_STS_ERROR;
1393: p_error_buffer := 'The Tax Status information could not be located in cache.';
1394: IF (g_level_error >= g_current_runtime_level ) THEN
1395: FND_LOG.STRING(g_level_error,
1396: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1397: 'Could not locate the status record in cache....');
1398: END IF;
1399: -- Set appropriate message and return

Line 1422: FND_LOG.STRING(g_level_error,

1418: p_return_status:= FND_API.G_RET_STS_ERROR;
1419: p_error_buffer := 'You cannot specify a rate percentage on a tax which '||
1420: ' is not ad-hoc';
1421: IF (g_level_error >= g_current_runtime_level ) THEN
1422: FND_LOG.STRING(g_level_error,
1423: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1424: 'A tax rate cannot be specified on a tax status which '||
1425: 'does not allow ad-hoc rates');
1426: END IF;

Line 1450: FND_LOG.STRING(g_level_error,

1446: p_return_status:= FND_API.G_RET_STS_ERROR;
1447: p_error_buffer := 'The rate is not valid for the tax determination date'||
1448: to_char(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date );
1449: IF (g_level_error >= g_current_runtime_level ) THEN
1450: FND_LOG.STRING(g_level_error,
1451: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1452: 'p_error_buffer: '|| p_error_buffer);
1453: END IF;
1454: END IF;

Line 1467: FND_LOG.STRING(g_level_procedure,

1463:
1464: end loop; -- for tax i.
1465:
1466: IF (g_level_procedure >= g_current_runtime_level ) THEN
1467: FND_LOG.STRING(g_level_procedure,
1468: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1469: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-) ');
1470: END IF;
1471:

Line 1478: FND_LOG.STRING(g_level_unexpected,

1474: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1475: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1476:
1477: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1478: FND_LOG.STRING(g_level_unexpected,
1479: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.GET_TAX_RATE',
1480: p_error_buffer);
1481: END IF;
1482:

Line 1498: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1494: p_Rate_Type_Code in zx_rates_b.Rate_Type_Code%TYPE) IS
1495:
1496: begin
1497:
1498: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1499:
1500: IF (g_level_procedure >= g_current_runtime_level ) THEN
1501: FND_LOG.STRING(g_level_procedure,
1502: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.BEGIN',

Line 1501: FND_LOG.STRING(g_level_procedure,

1497:
1498: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1499:
1500: IF (g_level_procedure >= g_current_runtime_level ) THEN
1501: FND_LOG.STRING(g_level_procedure,
1502: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.BEGIN',
1503: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(+) ');
1504: END IF;
1505:

Line 1513: FND_LOG.STRING(g_level_procedure,

1509: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_id := p_tax_rate_id ;
1510: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_type := p_Rate_Type_Code;
1511:
1512: IF (g_level_procedure >= g_current_runtime_level ) THEN
1513: FND_LOG.STRING(g_level_procedure,
1514: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.END',
1515: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(-) ');
1516: END IF;
1517:

Line 1522: FND_LOG.STRING(g_level_unexpected,

1518: EXCEPTION
1519: WHEN OTHERS THEN
1520:
1521: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1522: FND_LOG.STRING(g_level_unexpected,
1523: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate',
1524: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1525: END IF;
1526:

Line 1579: FND_LOG.STRING(g_level_procedure,

1575: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1576: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1577: BEGIN
1578: IF (g_level_procedure >= g_current_runtime_level ) THEN
1579: FND_LOG.STRING(g_level_procedure,
1580: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.BEGIN',
1581: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(+)');
1582: END IF;
1583:

Line 1596: FND_LOG.STRING(g_level_error,

1592: x_error_buffer);
1593:
1594: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1595: IF (g_level_error >= g_current_runtime_level ) THEN
1596: FND_LOG.STRING(g_level_error,
1597: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1598: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1599: FND_LOG.STRING(g_level_error,
1600: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

Line 1599: FND_LOG.STRING(g_level_error,

1595: IF (g_level_error >= g_current_runtime_level ) THEN
1596: FND_LOG.STRING(g_level_error,
1597: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1598: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1599: FND_LOG.STRING(g_level_error,
1600: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1601: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1602: END IF;
1603: RETURN;

Line 1617: FND_LOG.STRING(g_level_error,

1613: x_error_buffer);
1614:
1615: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1616: IF (g_level_error >= g_current_runtime_level ) THEN
1617: FND_LOG.STRING(g_level_error,
1618: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1619: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
1620: FND_LOG.STRING(g_level_error,
1621: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

Line 1620: FND_LOG.STRING(g_level_error,

1616: IF (g_level_error >= g_current_runtime_level ) THEN
1617: FND_LOG.STRING(g_level_error,
1618: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1619: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
1620: FND_LOG.STRING(g_level_error,
1621: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1622: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1623: END IF;
1624: RETURN;

Line 1639: FND_LOG.STRING(g_level_error,

1635: IF get_offset_info_csr%NOTFOUND THEN
1636: x_return_status := FND_API.G_RET_STS_ERROR;
1637: x_error_buffer := 'No data found for the specified tax rate '; -- will replace with coded message
1638: IF (g_level_error >= g_current_runtime_level ) THEN
1639: FND_LOG.STRING(g_level_error,
1640: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1641: 'No data found for the specified offset tax rate');
1642: END IF;
1643: END IF;

Line 1664: FND_LOG.STRING(g_level_error,

1660: l_tax_rate_id := l_offset_tax_rate_rec.tax_rate_id;
1661:
1662: ELSE
1663: IF (g_level_error >= g_current_runtime_level ) THEN
1664: FND_LOG.STRING(g_level_error,
1665: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1666: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
1667: FND_LOG.STRING(g_level_error,
1668: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

Line 1667: FND_LOG.STRING(g_level_error,

1663: IF (g_level_error >= g_current_runtime_level ) THEN
1664: FND_LOG.STRING(g_level_error,
1665: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1666: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
1667: FND_LOG.STRING(g_level_error,
1668: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1669: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1670: END IF;
1671: RETURN;

Line 1676: FND_LOG.STRING(g_level_procedure,

1672:
1673: END IF;
1674:
1675: IF (g_level_procedure >= g_current_runtime_level ) THEN
1676: FND_LOG.STRING(g_level_procedure,
1677: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1678: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1679: END IF;
1680: EXCEPTION

Line 1685: FND_LOG.STRING(g_level_unexpected,

1681: WHEN OTHERS THEN
1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683:
1684: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1685: FND_LOG.STRING(g_level_unexpected,
1686: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1687: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1688: FND_LOG.STRING(g_level_unexpected,
1689: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

Line 1688: FND_LOG.STRING(g_level_unexpected,

1684: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1685: FND_LOG.STRING(g_level_unexpected,
1686: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1687: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1688: FND_LOG.STRING(g_level_unexpected,
1689: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1690: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1691: END IF;
1692: