APPS.ZX_TDS_RATE_DETM_PKG dependencies on ZX_TDS_RATE_DETM_PKG

Line 1: PACKAGE BODY ZX_TDS_RATE_DETM_PKG AS

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;

Line 145: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.GET_TAX_RATE.BEGIN',

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:
149: p_return_status:= FND_API.G_RET_STS_SUCCESS;

Line 146: 'ZX_TDS_RATE_DETM_PKG: GET_TAX_RATE(+)');

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:
149: p_return_status:= FND_API.G_RET_STS_SUCCESS;
150:

Line 158: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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;
162: END IF;

Line 180: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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

Line 203: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
207: l_multiple_jurisdictions_flag :=

Line 231: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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;
235: END IF;

Line 326: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
330: 'RETURN_STATUS = ' || p_return_status);

Line 329: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
333: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

Line 332: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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;
336: ELSE

Line 333: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

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;
336: ELSE
337: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code

Line 481: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
485: -- Set appropriate message and return

Line 520: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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;
524: END IF;

Line 532: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
536: END IF;

Line 561: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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,
565: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 565: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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:
569: -- in TCM, the error msg already saved on fnd msg stack

Line 566: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);

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:
569: -- in TCM, the error msg already saved on fnd msg stack
570: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

Line 629: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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

Line 656: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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(
660: p_structure_index)

Line 686: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
690: ELSE -- if l_tax_rate_code is NULL

Line 695: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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

Line 725: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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;
729: END IF;

Line 763: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
767: 'RETURN_STATUS = ' || p_return_status);

Line 766: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
770: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

Line 769: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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;
773: ELSE

Line 770: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

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;
773: ELSE
774: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 803: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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

Line 836: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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,
840: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 840: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
844: 'RETURN_STATUS = ' || p_return_status);

Line 843: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
847: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

Line 846: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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;
850: END IF;

Line 847: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

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;
850: END IF;
851:

Line 865: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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,
869: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 869: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
873: 'RETURN_STATUS = ' || p_return_status);

Line 872: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
876: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

Line 875: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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;
879: END IF;

Line 876: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

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;
879: END IF;
880:

Line 888: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
892: 'l_offset_tax_appl = '||l_offset_tax_appl);

Line 891: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
895: ELSIF SUBSTR(l_reg_party_type, 1,15) IN ('SHIP_FROM_PARTY', 'BILL_FROM_PARTY') OR

Line 912: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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,
916: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 916: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
920: 'RETURN_STATUS = ' || p_return_status);

Line 919: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
923: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

Line 922: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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;
926: END IF;

Line 923: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');

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;
926: END IF;
927:

Line 934: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
938: 'l_offset_tax_appl= '||l_offset_tax_appl);

Line 937: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
941: END IF; -- l_reg_party_type = 'PARTY' OR 'SITE'

Line 960: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
964: END IF;

Line 986: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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;
990: -- p_error_buffer := 'Rule Based engine returned error during offset tax determination ';

Line 994: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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;
998: --ELSE

Line 1006: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
1010: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';

Line 1023: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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

Line 1031: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
1035: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';

Line 1083: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
1087: 'l_tax_rate = ' ||l_tax_rate);

Line 1086: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
1090: 'l_numeric_result = ' || l_numeric_result);

Line 1089: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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',
1093: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-) ');

Line 1092: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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;
1096: END IF;

Line 1093: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-) ');

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;
1096: END IF;
1097: END IF;

Line 1139: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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,
1143: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1143: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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:
1147: RETURN;

Line 1144: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);

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:
1147: RETURN;
1148: END IF;

Line 1184: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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:
1188: END IF;

Line 1209: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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

Line 1265: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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,
1269: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1269: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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:
1273: -- in TCM, the error msg already saved on fnd msg stack

Line 1270: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);

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:
1273: -- in TCM, the error msg already saved on fnd msg stack
1274: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=

Line 1341: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_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;
1345:

Line 1396: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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
1400: RETURN;

Line 1423: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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;
1427: RETURN;

Line 1451: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

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

Line 1468: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

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:
1472: EXCEPTION

Line 1469: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-) ');

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:
1472: EXCEPTION
1473: WHEN OTHERS THEN

Line 1479: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.GET_TAX_RATE',

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

Line 1502: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.BEGIN',

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:
1506: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_code:= p_tax_rate_code;

Line 1503: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(+) ');

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:
1506: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate_code:= p_tax_rate_code;
1507: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).tax_rate:= p_tax_rate;

Line 1514: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.END',

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:
1518: EXCEPTION

Line 1515: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(-) ');

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:
1518: EXCEPTION
1519: WHEN OTHERS THEN

Line 1523: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate',

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:
1527: end update_tax_rate;

Line 1580: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.BEGIN',

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:
1584: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1581: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(+)');

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:
1584: x_return_status := FND_API.G_RET_STS_SUCCESS;
1585:

Line 1597: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',

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',
1601: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

Line 1600: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

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;
1604: END IF;

Line 1601: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

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;
1604: END IF;
1605:

Line 1618: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',

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',
1622: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

Line 1621: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

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;
1625: END IF;

Line 1622: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

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;
1625: END IF;
1626:

Line 1640: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',

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;
1644: CLOSE get_offset_info_csr;

Line 1665: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',

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',
1669: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

Line 1668: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

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

Line 1669: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

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;
1672:
1673: END IF;

Line 1677: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

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
1681: WHEN OTHERS THEN

Line 1678: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

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
1681: WHEN OTHERS THEN
1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1686: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',

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',
1690: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

Line 1689: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

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:
1693: END validate_offset_tax;

Line 1690: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');

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:
1693: END validate_offset_tax;
1694:

Line 1695: END ZX_TDS_RATE_DETM_PKG;

1691: END IF;
1692:
1693: END validate_offset_tax;
1694:
1695: END ZX_TDS_RATE_DETM_PKG;
1696: