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

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

1: PACKAGE BODY ZX_TCM_TAX_RATE_PKG AS
2: /* $Header: zxctaxratespkgb.pls 120.14.12010000.2 2008/10/30 02:03:55 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_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_module_name CONSTANT VARCHAR2(50) :='ZX.PLSQL.ZX_TCM_TAX_RATE_PKG';
9:

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

2: /* $Header: zxctaxratespkgb.pls 120.14.12010000.2 2008/10/30 02:03:55 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_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_module_name CONSTANT VARCHAR2(50) :='ZX.PLSQL.ZX_TCM_TAX_RATE_PKG';
9:
10: PROCEDURE get_tax_rate_by_jur_gt(

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

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_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
8: g_module_name CONSTANT VARCHAR2(50) :='ZX.PLSQL.ZX_TCM_TAX_RATE_PKG';
9:
10: PROCEDURE get_tax_rate_by_jur_gt(
11: p_tax_class IN VARCHAR2,

Line 225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
223:
224: BEGIN
225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
226:
227: IF (g_level_procedure >= g_current_runtime_level ) THEN
228: FND_LOG.STRING(g_level_procedure,
229: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 228: FND_LOG.STRING(g_level_procedure,

224: BEGIN
225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
226:
227: IF (g_level_procedure >= g_current_runtime_level ) THEN
228: FND_LOG.STRING(g_level_procedure,
229: g_module_name||'.'||l_procedure_name||'.BEGIN',
230: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(+) ');
231: END IF;
232:

Line 270: FND_LOG.STRING(g_level_unexpected,

266:
267: CLOSE get_tax_rate_csr;
268:
269: IF (g_level_unexpected >= g_current_runtime_level ) THEN
270: FND_LOG.STRING(g_level_unexpected,
271: g_module_name||'.'||l_procedure_name,
272: 'Too Many Tax Rate Rows Retrived. ');
273: FND_LOG.STRING(g_level_unexpected,
274: g_module_name||'.'||l_procedure_name||'.END',

Line 273: FND_LOG.STRING(g_level_unexpected,

269: IF (g_level_unexpected >= g_current_runtime_level ) THEN
270: FND_LOG.STRING(g_level_unexpected,
271: g_module_name||'.'||l_procedure_name,
272: 'Too Many Tax Rate Rows Retrived. ');
273: FND_LOG.STRING(g_level_unexpected,
274: g_module_name||'.'||l_procedure_name||'.END',
275: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
276: END IF;
277:

Line 285: FND_LOG.STRING(g_level_statement,

281: x_tax_rate_rec := l_tax_rate_rec;
282: CLOSE get_tax_rate_csr;
283:
284: IF (g_level_statement >= g_current_runtime_level ) THEN
285: FND_LOG.STRING(g_level_statement,
286: g_module_name||'.'||l_procedure_name,
287: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
288: FND_LOG.STRING(g_level_statement,
289: g_module_name||'.'||l_procedure_name,

Line 288: FND_LOG.STRING(g_level_statement,

284: IF (g_level_statement >= g_current_runtime_level ) THEN
285: FND_LOG.STRING(g_level_statement,
286: g_module_name||'.'||l_procedure_name,
287: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
288: FND_LOG.STRING(g_level_statement,
289: g_module_name||'.'||l_procedure_name,
290: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
291: END IF;
292:

Line 327: FND_LOG.STRING(g_level_unexpected,

323:
324: CLOSE get_tax_rate_mig_csr;
325:
326: IF (g_level_unexpected >= g_current_runtime_level ) THEN
327: FND_LOG.STRING(g_level_unexpected,
328: g_module_name||'.'||l_procedure_name,
329: 'Too Many Tax Rate Rows Retrived. ');
330: FND_LOG.STRING(g_level_unexpected,
331: g_module_name||'.'||l_procedure_name||'.END',

Line 330: FND_LOG.STRING(g_level_unexpected,

326: IF (g_level_unexpected >= g_current_runtime_level ) THEN
327: FND_LOG.STRING(g_level_unexpected,
328: g_module_name||'.'||l_procedure_name,
329: 'Too Many Tax Rate Rows Retrived. ');
330: FND_LOG.STRING(g_level_unexpected,
331: g_module_name||'.'||l_procedure_name||'.END',
332: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
333: END IF;
334:

Line 342: FND_LOG.STRING(g_level_statement,

338: x_tax_rate_rec := l_tax_rate_rec;
339: CLOSE get_tax_rate_mig_csr;
340:
341: IF (g_level_statement >= g_current_runtime_level ) THEN
342: FND_LOG.STRING(g_level_statement,
343: g_module_name||'.'||l_procedure_name,
344: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
345: FND_LOG.STRING(g_level_statement,
346: g_module_name||'.'||l_procedure_name,

Line 345: FND_LOG.STRING(g_level_statement,

341: IF (g_level_statement >= g_current_runtime_level ) THEN
342: FND_LOG.STRING(g_level_statement,
343: g_module_name||'.'||l_procedure_name,
344: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
345: FND_LOG.STRING(g_level_statement,
346: g_module_name||'.'||l_procedure_name,
347: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
348: END IF;
349:

Line 357: FND_LOG.STRING(g_level_procedure,

353: END IF;
354: END IF;
355:
356: IF (g_level_procedure >= g_current_runtime_level ) THEN
357: FND_LOG.STRING(g_level_procedure,
358: g_module_name||'.'||l_procedure_name||'.END',
359: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
360: END IF;
361:

Line 369: FND_LOG.STRING(g_level_unexpected,

365: IF get_tax_rate_csr%ISOPEN THEN
366: CLOSE get_tax_rate_csr;
367: END IF;
368: IF (g_level_unexpected >= g_current_runtime_level ) THEN
369: FND_LOG.STRING(g_level_unexpected,
370: g_module_name||'.'||l_procedure_name,
371: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
372: FND_LOG.STRING(g_level_unexpected,
373: g_module_name||'.'||l_procedure_name||'.END',

Line 372: FND_LOG.STRING(g_level_unexpected,

368: IF (g_level_unexpected >= g_current_runtime_level ) THEN
369: FND_LOG.STRING(g_level_unexpected,
370: g_module_name||'.'||l_procedure_name,
371: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
372: FND_LOG.STRING(g_level_unexpected,
373: g_module_name||'.'||l_procedure_name||'.END',
374: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
375: END IF;
376:

Line 487: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

483: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
484: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
485:
486: BEGIN
487: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
488:
489: IF (g_level_procedure >= g_current_runtime_level ) THEN
490: FND_LOG.STRING(g_level_procedure,
491: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 490: FND_LOG.STRING(g_level_procedure,

486: BEGIN
487: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
488:
489: IF (g_level_procedure >= g_current_runtime_level ) THEN
490: FND_LOG.STRING(g_level_procedure,
491: g_module_name||'.'||l_procedure_name||'.BEGIN',
492: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(+) ');
493: END IF;
494:

Line 526: FND_LOG.STRING(g_level_unexpected,

522:
523: CLOSE get_def_tax_rate_csr;
524:
525: IF (g_level_unexpected >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_unexpected,
527: g_module_name||'.'||l_procedure_name,
528: 'Too Many Tax Rate Rows Retrived. ');
529: FND_LOG.STRING(g_level_unexpected,
530: g_module_name||'.'||l_procedure_name||'.END',

Line 529: FND_LOG.STRING(g_level_unexpected,

525: IF (g_level_unexpected >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_unexpected,
527: g_module_name||'.'||l_procedure_name,
528: 'Too Many Tax Rate Rows Retrived. ');
529: FND_LOG.STRING(g_level_unexpected,
530: g_module_name||'.'||l_procedure_name||'.END',
531: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
532: END IF;
533: ELSE

Line 540: FND_LOG.STRING(g_level_statement,

536: x_tax_rate_rec := l_tax_rate_rec;
537: CLOSE get_def_tax_rate_csr;
538:
539: IF (g_level_statement >= g_current_runtime_level ) THEN
540: FND_LOG.STRING(g_level_statement,
541: g_module_name||'.'||l_procedure_name,
542: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
543: FND_LOG.STRING(g_level_statement,
544: g_module_name||'.'||l_procedure_name,

Line 543: FND_LOG.STRING(g_level_statement,

539: IF (g_level_statement >= g_current_runtime_level ) THEN
540: FND_LOG.STRING(g_level_statement,
541: g_module_name||'.'||l_procedure_name,
542: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
543: FND_LOG.STRING(g_level_statement,
544: g_module_name||'.'||l_procedure_name,
545: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
546: END IF;
547:

Line 581: FND_LOG.STRING(g_level_unexpected,

577:
578: CLOSE get_def_tax_rate_mig_csr;
579:
580: IF (g_level_unexpected >= g_current_runtime_level ) THEN
581: FND_LOG.STRING(g_level_unexpected,
582: g_module_name||'.'||l_procedure_name,
583: 'Too Many Tax Rate Rows Retrived. ');
584: FND_LOG.STRING(g_level_unexpected,
585: g_module_name||'.'||l_procedure_name||'.END',

Line 584: FND_LOG.STRING(g_level_unexpected,

580: IF (g_level_unexpected >= g_current_runtime_level ) THEN
581: FND_LOG.STRING(g_level_unexpected,
582: g_module_name||'.'||l_procedure_name,
583: 'Too Many Tax Rate Rows Retrived. ');
584: FND_LOG.STRING(g_level_unexpected,
585: g_module_name||'.'||l_procedure_name||'.END',
586: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
587: END IF;
588: ELSE

Line 595: FND_LOG.STRING(g_level_statement,

591: x_tax_rate_rec := l_tax_rate_rec;
592: CLOSE get_def_tax_rate_mig_csr;
593:
594: IF (g_level_statement >= g_current_runtime_level ) THEN
595: FND_LOG.STRING(g_level_statement,
596: g_module_name||'.'||l_procedure_name,
597: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
598: FND_LOG.STRING(g_level_statement,
599: g_module_name||'.'||l_procedure_name,

Line 598: FND_LOG.STRING(g_level_statement,

594: IF (g_level_statement >= g_current_runtime_level ) THEN
595: FND_LOG.STRING(g_level_statement,
596: g_module_name||'.'||l_procedure_name,
597: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
598: FND_LOG.STRING(g_level_statement,
599: g_module_name||'.'||l_procedure_name,
600: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
601: END IF;
602:

Line 610: FND_LOG.STRING(g_level_procedure,

606: END IF;
607: END IF;
608:
609: IF (g_level_procedure >= g_current_runtime_level ) THEN
610: FND_LOG.STRING(g_level_procedure,
611: g_module_name||'.'||l_procedure_name||'.END',
612: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
613: END IF;
614:

Line 622: FND_LOG.STRING(g_level_unexpected,

618: IF get_def_tax_rate_csr%ISOPEN THEN
619: CLOSE get_def_tax_rate_csr;
620: END IF;
621: IF (g_level_unexpected >= g_current_runtime_level ) THEN
622: FND_LOG.STRING(g_level_unexpected,
623: g_module_name||'.'||l_procedure_name,
624: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
625: FND_LOG.STRING(g_level_unexpected,
626: g_module_name||'.'||l_procedure_name||'.END',

Line 625: FND_LOG.STRING(g_level_unexpected,

621: IF (g_level_unexpected >= g_current_runtime_level ) THEN
622: FND_LOG.STRING(g_level_unexpected,
623: g_module_name||'.'||l_procedure_name,
624: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
625: FND_LOG.STRING(g_level_unexpected,
626: g_module_name||'.'||l_procedure_name||'.END',
627: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
628: END IF;
629:

Line 736: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

732: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
733: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
734:
735: BEGIN
736: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737:
738: IF (g_level_procedure >= g_current_runtime_level ) THEN
739: FND_LOG.STRING(g_level_procedure,
740: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 739: FND_LOG.STRING(g_level_procedure,

735: BEGIN
736: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737:
738: IF (g_level_procedure >= g_current_runtime_level ) THEN
739: FND_LOG.STRING(g_level_procedure,
740: g_module_name||'.'||l_procedure_name||'.BEGIN',
741: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(+) ');
742: END IF;
743:

Line 778: FND_LOG.STRING(g_level_unexpected,

774:
775: CLOSE get_tax_rate_csr;
776:
777: IF (g_level_unexpected >= g_current_runtime_level ) THEN
778: FND_LOG.STRING(g_level_unexpected,
779: g_module_name||'.'||l_procedure_name,
780: 'Too Many Tax Rate Rows Retrived. ');
781: FND_LOG.STRING(g_level_unexpected,
782: g_module_name||'.'||l_procedure_name||'.END',

Line 781: FND_LOG.STRING(g_level_unexpected,

777: IF (g_level_unexpected >= g_current_runtime_level ) THEN
778: FND_LOG.STRING(g_level_unexpected,
779: g_module_name||'.'||l_procedure_name,
780: 'Too Many Tax Rate Rows Retrived. ');
781: FND_LOG.STRING(g_level_unexpected,
782: g_module_name||'.'||l_procedure_name||'.END',
783: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
784: END IF;
785:

Line 793: FND_LOG.STRING(g_level_statement,

789: x_tax_rate_rec := l_tax_rate_rec;
790: CLOSE get_tax_rate_csr;
791:
792: IF (g_level_statement >= g_current_runtime_level ) THEN
793: FND_LOG.STRING(g_level_statement,
794: g_module_name||'.'||l_procedure_name,
795: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
796: FND_LOG.STRING(g_level_statement,
797: g_module_name||'.'||l_procedure_name,

Line 796: FND_LOG.STRING(g_level_statement,

792: IF (g_level_statement >= g_current_runtime_level ) THEN
793: FND_LOG.STRING(g_level_statement,
794: g_module_name||'.'||l_procedure_name,
795: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
796: FND_LOG.STRING(g_level_statement,
797: g_module_name||'.'||l_procedure_name,
798: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
799: END IF;
800:

Line 827: FND_LOG.STRING(g_level_unexpected,

823:
824: CLOSE get_tax_rate_mig_csr;
825:
826: IF (g_level_unexpected >= g_current_runtime_level ) THEN
827: FND_LOG.STRING(g_level_unexpected,
828: g_module_name||'.'||l_procedure_name,
829: 'Too Many Tax Rate Rows Retrived. ');
830: FND_LOG.STRING(g_level_unexpected,
831: g_module_name||'.'||l_procedure_name||'.END',

Line 830: FND_LOG.STRING(g_level_unexpected,

826: IF (g_level_unexpected >= g_current_runtime_level ) THEN
827: FND_LOG.STRING(g_level_unexpected,
828: g_module_name||'.'||l_procedure_name,
829: 'Too Many Tax Rate Rows Retrived. ');
830: FND_LOG.STRING(g_level_unexpected,
831: g_module_name||'.'||l_procedure_name||'.END',
832: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
833: END IF;
834:

Line 842: FND_LOG.STRING(g_level_statement,

838: x_tax_rate_rec := l_tax_rate_rec;
839: CLOSE get_tax_rate_mig_csr;
840:
841: IF (g_level_statement >= g_current_runtime_level ) THEN
842: FND_LOG.STRING(g_level_statement,
843: g_module_name||'.'||l_procedure_name,
844: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
845: FND_LOG.STRING(g_level_statement,
846: g_module_name||'.'||l_procedure_name,

Line 845: FND_LOG.STRING(g_level_statement,

841: IF (g_level_statement >= g_current_runtime_level ) THEN
842: FND_LOG.STRING(g_level_statement,
843: g_module_name||'.'||l_procedure_name,
844: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
845: FND_LOG.STRING(g_level_statement,
846: g_module_name||'.'||l_procedure_name,
847: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
848: END IF;
849:

Line 858: FND_LOG.STRING(g_level_procedure,

854:
855: END IF;
856:
857: IF (g_level_procedure >= g_current_runtime_level ) THEN
858: FND_LOG.STRING(g_level_procedure,
859: g_module_name||'.'||l_procedure_name||'.END',
860: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
861: END IF;
862:

Line 870: FND_LOG.STRING(g_level_unexpected,

866: IF get_tax_rate_csr%ISOPEN THEN
867: CLOSE get_tax_rate_csr;
868: END IF;
869: IF (g_level_unexpected >= g_current_runtime_level ) THEN
870: FND_LOG.STRING(g_level_unexpected,
871: g_module_name||'.'||l_procedure_name,
872: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
873: FND_LOG.STRING(g_level_unexpected,
874: g_module_name||'.'||l_procedure_name||'.END',

Line 873: FND_LOG.STRING(g_level_unexpected,

869: IF (g_level_unexpected >= g_current_runtime_level ) THEN
870: FND_LOG.STRING(g_level_unexpected,
871: g_module_name||'.'||l_procedure_name,
872: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
873: FND_LOG.STRING(g_level_unexpected,
874: g_module_name||'.'||l_procedure_name||'.END',
875: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
876: END IF;
877:

Line 984: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

980: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
981: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
982:
983: BEGIN
984: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
985:
986: IF (g_level_procedure >= g_current_runtime_level ) THEN
987: FND_LOG.STRING(g_level_procedure,
988: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 987: FND_LOG.STRING(g_level_procedure,

983: BEGIN
984: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
985:
986: IF (g_level_procedure >= g_current_runtime_level ) THEN
987: FND_LOG.STRING(g_level_procedure,
988: g_module_name||'.'||l_procedure_name||'.BEGIN',
989: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(+) ');
990: END IF;
991: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1016: FND_LOG.STRING(g_level_unexpected,

1012:
1013: CLOSE get_tax_rate_csr_no_jur;
1014:
1015: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1016: FND_LOG.STRING(g_level_unexpected,
1017: g_module_name||'.'||l_procedure_name,
1018: 'Too Many Tax Rate Rows Retrived. ');
1019: FND_LOG.STRING(g_level_unexpected,
1020: g_module_name||'.'||l_procedure_name||'.END',

Line 1019: FND_LOG.STRING(g_level_unexpected,

1015: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1016: FND_LOG.STRING(g_level_unexpected,
1017: g_module_name||'.'||l_procedure_name,
1018: 'Too Many Tax Rate Rows Retrived. ');
1019: FND_LOG.STRING(g_level_unexpected,
1020: g_module_name||'.'||l_procedure_name||'.END',
1021: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1022: END IF;
1023:

Line 1032: FND_LOG.STRING(g_level_statement,

1028: x_tax_rate_rec := l_tax_rate_rec;
1029: CLOSE get_tax_rate_csr_no_jur;
1030:
1031: IF (g_level_statement >= g_current_runtime_level ) THEN
1032: FND_LOG.STRING(g_level_statement,
1033: g_module_name||'.'||l_procedure_name,
1034: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1035: FND_LOG.STRING(g_level_statement,
1036: g_module_name||'.'||l_procedure_name,

Line 1035: FND_LOG.STRING(g_level_statement,

1031: IF (g_level_statement >= g_current_runtime_level ) THEN
1032: FND_LOG.STRING(g_level_statement,
1033: g_module_name||'.'||l_procedure_name,
1034: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1035: FND_LOG.STRING(g_level_statement,
1036: g_module_name||'.'||l_procedure_name,
1037: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1038: END IF;
1039: -- END IF;

Line 1066: FND_LOG.STRING(g_level_unexpected,

1062:
1063: CLOSE get_tax_rate_csr_no_jur_mig;
1064:
1065: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1066: FND_LOG.STRING(g_level_unexpected,
1067: g_module_name||'.'||l_procedure_name,
1068: 'Too Many Tax Rate Rows Retrived. ');
1069: FND_LOG.STRING(g_level_unexpected,
1070: g_module_name||'.'||l_procedure_name||'.END',

Line 1069: FND_LOG.STRING(g_level_unexpected,

1065: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1066: FND_LOG.STRING(g_level_unexpected,
1067: g_module_name||'.'||l_procedure_name,
1068: 'Too Many Tax Rate Rows Retrived. ');
1069: FND_LOG.STRING(g_level_unexpected,
1070: g_module_name||'.'||l_procedure_name||'.END',
1071: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1072: END IF;
1073:

Line 1082: FND_LOG.STRING(g_level_statement,

1078: x_tax_rate_rec := l_tax_rate_rec;
1079: CLOSE get_tax_rate_csr_no_jur_mig;
1080:
1081: IF (g_level_statement >= g_current_runtime_level ) THEN
1082: FND_LOG.STRING(g_level_statement,
1083: g_module_name||'.'||l_procedure_name,
1084: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1085: FND_LOG.STRING(g_level_statement,
1086: g_module_name||'.'||l_procedure_name,

Line 1085: FND_LOG.STRING(g_level_statement,

1081: IF (g_level_statement >= g_current_runtime_level ) THEN
1082: FND_LOG.STRING(g_level_statement,
1083: g_module_name||'.'||l_procedure_name,
1084: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1085: FND_LOG.STRING(g_level_statement,
1086: g_module_name||'.'||l_procedure_name,
1087: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1088: END IF;
1089:

Line 1098: FND_LOG.STRING(g_level_procedure,

1094:
1095: END IF;
1096:
1097: IF (g_level_procedure >= g_current_runtime_level ) THEN
1098: FND_LOG.STRING(g_level_procedure,
1099: g_module_name||'.'||l_procedure_name||'.END',
1100: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1101: END IF;
1102:

Line 1110: FND_LOG.STRING(g_level_unexpected,

1106: IF get_tax_rate_csr_no_jur%ISOPEN THEN
1107: CLOSE get_tax_rate_csr_no_jur;
1108: END IF;
1109: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1110: FND_LOG.STRING(g_level_unexpected,
1111: g_module_name||'.'||l_procedure_name,
1112: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1113: FND_LOG.STRING(g_level_unexpected,
1114: g_module_name||'.'||l_procedure_name||'.END',

Line 1113: FND_LOG.STRING(g_level_unexpected,

1109: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1110: FND_LOG.STRING(g_level_unexpected,
1111: g_module_name||'.'||l_procedure_name,
1112: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1113: FND_LOG.STRING(g_level_unexpected,
1114: g_module_name||'.'||l_procedure_name||'.END',
1115: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1116: END IF;
1117: END get_tax_rate_no_jur_code;

Line 1225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1221: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1222: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1223:
1224: BEGIN
1225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1226:
1227: IF (g_level_procedure >= g_current_runtime_level ) THEN
1228: FND_LOG.STRING(g_level_procedure,
1229: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1228: FND_LOG.STRING(g_level_procedure,

1224: BEGIN
1225: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1226:
1227: IF (g_level_procedure >= g_current_runtime_level ) THEN
1228: FND_LOG.STRING(g_level_procedure,
1229: g_module_name||'.'||l_procedure_name||'.BEGIN',
1230: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(+) ');
1231: END IF;
1232:

Line 1260: FND_LOG.STRING(g_level_unexpected,

1256:
1257: CLOSE get_def_tax_rate_csr;
1258:
1259: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1260: FND_LOG.STRING(g_level_unexpected,
1261: g_module_name||'.'||l_procedure_name,
1262: 'Too Many Tax Rate Rows Retrived. ');
1263: FND_LOG.STRING(g_level_unexpected,
1264: g_module_name||'.'||l_procedure_name||'.END',

Line 1263: FND_LOG.STRING(g_level_unexpected,

1259: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1260: FND_LOG.STRING(g_level_unexpected,
1261: g_module_name||'.'||l_procedure_name,
1262: 'Too Many Tax Rate Rows Retrived. ');
1263: FND_LOG.STRING(g_level_unexpected,
1264: g_module_name||'.'||l_procedure_name||'.END',
1265: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1266: END IF;
1267: ELSE

Line 1274: FND_LOG.STRING(g_level_statement,

1270: x_tax_rate_rec := l_tax_rate_rec;
1271: CLOSE get_def_tax_rate_csr;
1272:
1273: IF (g_level_statement >= g_current_runtime_level ) THEN
1274: FND_LOG.STRING(g_level_statement,
1275: g_module_name||'.'||l_procedure_name,
1276: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1277: FND_LOG.STRING(g_level_statement,
1278: g_module_name||'.'||l_procedure_name,

Line 1277: FND_LOG.STRING(g_level_statement,

1273: IF (g_level_statement >= g_current_runtime_level ) THEN
1274: FND_LOG.STRING(g_level_statement,
1275: g_module_name||'.'||l_procedure_name,
1276: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1277: FND_LOG.STRING(g_level_statement,
1278: g_module_name||'.'||l_procedure_name,
1279: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1280: END IF;
1281:

Line 1311: FND_LOG.STRING(g_level_unexpected,

1307:
1308: CLOSE get_def_tax_rate_mig_csr;
1309:
1310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1311: FND_LOG.STRING(g_level_unexpected,
1312: g_module_name||'.'||l_procedure_name,
1313: 'Too Many Tax Rate Rows Retrived. ');
1314: FND_LOG.STRING(g_level_unexpected,
1315: g_module_name||'.'||l_procedure_name||'.END',

Line 1314: FND_LOG.STRING(g_level_unexpected,

1310: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1311: FND_LOG.STRING(g_level_unexpected,
1312: g_module_name||'.'||l_procedure_name,
1313: 'Too Many Tax Rate Rows Retrived. ');
1314: FND_LOG.STRING(g_level_unexpected,
1315: g_module_name||'.'||l_procedure_name||'.END',
1316: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1317: END IF;
1318: ELSE

Line 1325: FND_LOG.STRING(g_level_statement,

1321: x_tax_rate_rec := l_tax_rate_rec;
1322: CLOSE get_def_tax_rate_mig_csr;
1323:
1324: IF (g_level_statement >= g_current_runtime_level ) THEN
1325: FND_LOG.STRING(g_level_statement,
1326: g_module_name||'.'||l_procedure_name,
1327: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1328: FND_LOG.STRING(g_level_statement,
1329: g_module_name||'.'||l_procedure_name,

Line 1328: FND_LOG.STRING(g_level_statement,

1324: IF (g_level_statement >= g_current_runtime_level ) THEN
1325: FND_LOG.STRING(g_level_statement,
1326: g_module_name||'.'||l_procedure_name,
1327: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1328: FND_LOG.STRING(g_level_statement,
1329: g_module_name||'.'||l_procedure_name,
1330: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1331: END IF;
1332:

Line 1341: FND_LOG.STRING(g_level_procedure,

1337:
1338: END IF;
1339:
1340: IF (g_level_procedure >= g_current_runtime_level ) THEN
1341: FND_LOG.STRING(g_level_procedure,
1342: g_module_name||'.'||l_procedure_name||'.END',
1343: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1344: END IF;
1345:

Line 1353: FND_LOG.STRING(g_level_unexpected,

1349: IF get_def_tax_rate_csr%ISOPEN THEN
1350: CLOSE get_def_tax_rate_csr;
1351: END IF;
1352: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1353: FND_LOG.STRING(g_level_unexpected,
1354: g_module_name||'.'||l_procedure_name,
1355: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1356: FND_LOG.STRING(g_level_unexpected,
1357: g_module_name||'.'||l_procedure_name||'.END',

Line 1356: FND_LOG.STRING(g_level_unexpected,

1352: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1353: FND_LOG.STRING(g_level_unexpected,
1354: g_module_name||'.'||l_procedure_name,
1355: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1356: FND_LOG.STRING(g_level_unexpected,
1357: g_module_name||'.'||l_procedure_name||'.END',
1358: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1359: END IF;
1360: END get_def_tax_rate_by_jur_code;

Line 1467: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1463: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1464: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1465:
1466: BEGIN
1467: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1468:
1469: IF (g_level_procedure >= g_current_runtime_level ) THEN
1470: FND_LOG.STRING(g_level_procedure,
1471: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1470: FND_LOG.STRING(g_level_procedure,

1466: BEGIN
1467: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1468:
1469: IF (g_level_procedure >= g_current_runtime_level ) THEN
1470: FND_LOG.STRING(g_level_procedure,
1471: g_module_name||'.'||l_procedure_name||'.BEGIN',
1472: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(+) ');
1473: END IF;
1474: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1499: FND_LOG.STRING(g_level_unexpected,

1495: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1496:
1497: CLOSE get_def_tax_rate_no_jur_csr;
1498: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1499: FND_LOG.STRING(g_level_unexpected,
1500: g_module_name||'.'||l_procedure_name,
1501: 'Too Many Tax Rate Rows Retrived. ');
1502: FND_LOG.STRING(g_level_unexpected,
1503: g_module_name||'.'||l_procedure_name||'.END',

Line 1502: FND_LOG.STRING(g_level_unexpected,

1498: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1499: FND_LOG.STRING(g_level_unexpected,
1500: g_module_name||'.'||l_procedure_name,
1501: 'Too Many Tax Rate Rows Retrived. ');
1502: FND_LOG.STRING(g_level_unexpected,
1503: g_module_name||'.'||l_procedure_name||'.END',
1504: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1505: END IF;
1506: RETURN;

Line 1514: FND_LOG.STRING(g_level_statement,

1510: x_tax_rate_rec := l_tax_rate_rec;
1511: CLOSE get_def_tax_rate_no_jur_csr;
1512:
1513: IF (g_level_statement >= g_current_runtime_level ) THEN
1514: FND_LOG.STRING(g_level_statement,
1515: g_module_name||'.'||l_procedure_name,
1516: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1517: FND_LOG.STRING(g_level_statement,
1518: g_module_name||'.'||l_procedure_name,

Line 1517: FND_LOG.STRING(g_level_statement,

1513: IF (g_level_statement >= g_current_runtime_level ) THEN
1514: FND_LOG.STRING(g_level_statement,
1515: g_module_name||'.'||l_procedure_name,
1516: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1517: FND_LOG.STRING(g_level_statement,
1518: g_module_name||'.'||l_procedure_name,
1519: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1520: END IF;
1521:

Line 1529: FND_LOG.STRING(g_level_statement,

1525:
1526: -- tax rate is not found for NULL tax_class, try to get it with p_tax_class
1527: --
1528: IF (g_level_statement >= g_current_runtime_level ) THEN
1529: FND_LOG.STRING(g_level_statement,
1530: g_module_name||'.'||l_procedure_name,
1531: 'tax_class = ' || p_tax_class);
1532: END IF;
1533:

Line 1555: FND_LOG.STRING(g_level_unexpected,

1551: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1552:
1553: CLOSE get_def_tax_rate_no_jur_mi_csr;
1554: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1555: FND_LOG.STRING(g_level_unexpected,
1556: g_module_name||'.'||l_procedure_name,
1557: 'Too Many Tax Rate Rows Retrived. ');
1558: FND_LOG.STRING(g_level_unexpected,
1559: g_module_name||'.'||l_procedure_name||'.END',

Line 1558: FND_LOG.STRING(g_level_unexpected,

1554: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1555: FND_LOG.STRING(g_level_unexpected,
1556: g_module_name||'.'||l_procedure_name,
1557: 'Too Many Tax Rate Rows Retrived. ');
1558: FND_LOG.STRING(g_level_unexpected,
1559: g_module_name||'.'||l_procedure_name||'.END',
1560: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1561: END IF;
1562: RETURN;

Line 1570: FND_LOG.STRING(g_level_statement,

1566: x_tax_rate_rec := l_tax_rate_rec;
1567: CLOSE get_def_tax_rate_no_jur_mi_csr;
1568:
1569: IF (g_level_statement >= g_current_runtime_level ) THEN
1570: FND_LOG.STRING(g_level_statement,
1571: g_module_name||'.'||l_procedure_name,
1572: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1573: FND_LOG.STRING(g_level_statement,
1574: g_module_name||'.'||l_procedure_name,

Line 1573: FND_LOG.STRING(g_level_statement,

1569: IF (g_level_statement >= g_current_runtime_level ) THEN
1570: FND_LOG.STRING(g_level_statement,
1571: g_module_name||'.'||l_procedure_name,
1572: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1573: FND_LOG.STRING(g_level_statement,
1574: g_module_name||'.'||l_procedure_name,
1575: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1576: END IF;
1577:

Line 1586: FND_LOG.STRING(g_level_procedure,

1582:
1583: END IF;
1584:
1585: IF (g_level_procedure >= g_current_runtime_level ) THEN
1586: FND_LOG.STRING(g_level_procedure,
1587: g_module_name||'.'||l_procedure_name||'.END',
1588: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1589: END IF;
1590:

Line 1598: FND_LOG.STRING(g_level_unexpected,

1594: IF get_def_tax_rate_no_jur_csr%ISOPEN THEN
1595: CLOSE get_def_tax_rate_no_jur_csr;
1596: END IF;
1597: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1598: FND_LOG.STRING(g_level_unexpected,
1599: g_module_name||'.'||l_procedure_name,
1600: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1601: FND_LOG.STRING(g_level_unexpected,
1602: g_module_name||'.'||l_procedure_name||'.END',

Line 1601: FND_LOG.STRING(g_level_unexpected,

1597: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1598: FND_LOG.STRING(g_level_unexpected,
1599: g_module_name||'.'||l_procedure_name,
1600: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1601: FND_LOG.STRING(g_level_unexpected,
1602: g_module_name||'.'||l_procedure_name||'.END',
1603: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1604: END IF;
1605: END get_def_tax_rate_no_jur_code;

Line 1639: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1635: l_jurisdictions_found VARCHAR2(1);
1636: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1637: l_multiple_jurisdictions_flag VARCHAR2(1);
1638: BEGIN
1639: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1640:
1641: IF (g_level_procedure >= g_current_runtime_level ) THEN
1642: FND_LOG.STRING(g_level_procedure,
1643: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1642: FND_LOG.STRING(g_level_procedure,

1638: BEGIN
1639: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1640:
1641: IF (g_level_procedure >= g_current_runtime_level ) THEN
1642: FND_LOG.STRING(g_level_procedure,
1643: g_module_name||'.'||l_procedure_name||'.BEGIN',
1644: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(+) ');
1645: END IF;
1646:

Line 1653: FND_LOG.STRING(g_level_statement,

1649: -- get location_id
1650: l_structure_name := 'TRX_LINE_DIST_TBL';
1651:
1652: IF (g_level_statement >= g_current_runtime_level ) THEN
1653: FND_LOG.STRING(g_level_statement,
1654: g_module_name||'.'||l_procedure_name,
1655: 'Calling ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value...');
1656: END IF;
1657:

Line 1668: FND_LOG.STRING(g_level_statement,

1664: -- TCM procedure called in get_pos_parameter_name will set the error msg
1665: -- here we just need to return to the calling point which will populate
1666: -- the context information.
1667: IF (g_level_statement >= g_current_runtime_level ) THEN
1668: FND_LOG.STRING(g_level_statement,
1669: g_module_name||'.'||l_procedure_name,
1670: 'Incorrect return_status after calling ' ||
1671: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
1672: FND_LOG.STRING(g_level_statement,

Line 1672: FND_LOG.STRING(g_level_statement,

1668: FND_LOG.STRING(g_level_statement,
1669: g_module_name||'.'||l_procedure_name,
1670: 'Incorrect return_status after calling ' ||
1671: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
1672: FND_LOG.STRING(g_level_statement,
1673: g_module_name||'.'||l_procedure_name,
1674: 'RETURN_STATUS = ' || x_return_status);
1675: FND_LOG.STRING(g_level_statement,
1676: g_module_name||'.'||l_procedure_name||'.END',

Line 1675: FND_LOG.STRING(g_level_statement,

1671: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
1672: FND_LOG.STRING(g_level_statement,
1673: g_module_name||'.'||l_procedure_name,
1674: 'RETURN_STATUS = ' || x_return_status);
1675: FND_LOG.STRING(g_level_statement,
1676: g_module_name||'.'||l_procedure_name||'.END',
1677: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1678: END IF;
1679: RETURN;

Line 1692: FND_LOG.STRING(g_level_statement,

1688:
1689: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1690: THEN
1691: IF (g_level_statement >= g_current_runtime_level ) THEN
1692: FND_LOG.STRING(g_level_statement,
1693: g_module_name||'.'||l_procedure_name,
1694: 'Incorrect return_status after calling ' ||
1695: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
1696: FND_LOG.STRING(g_level_statement,

Line 1696: FND_LOG.STRING(g_level_statement,

1692: FND_LOG.STRING(g_level_statement,
1693: g_module_name||'.'||l_procedure_name,
1694: 'Incorrect return_status after calling ' ||
1695: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
1696: FND_LOG.STRING(g_level_statement,
1697: g_module_name||'.'||l_procedure_name,
1698: 'RETURN_STATUS = ' || x_return_status);
1699: FND_LOG.STRING(g_level_statement,
1700: g_module_name||'.'||l_procedure_name||'.END',

Line 1699: FND_LOG.STRING(g_level_statement,

1695: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
1696: FND_LOG.STRING(g_level_statement,
1697: g_module_name||'.'||l_procedure_name,
1698: 'RETURN_STATUS = ' || x_return_status);
1699: FND_LOG.STRING(g_level_statement,
1700: g_module_name||'.'||l_procedure_name||'.END',
1701: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1702: END IF;
1703: RETURN;

Line 1723: FND_LOG.STRING(g_level_statement,

1719:
1720: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1721: THEN
1722: IF (g_level_statement >= g_current_runtime_level ) THEN
1723: FND_LOG.STRING(g_level_statement,
1724: g_module_name||'.'||l_procedure_name,
1725: 'Incorrect return_status after calling ' ||
1726: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
1727: FND_LOG.STRING(g_level_statement,

Line 1727: FND_LOG.STRING(g_level_statement,

1723: FND_LOG.STRING(g_level_statement,
1724: g_module_name||'.'||l_procedure_name,
1725: 'Incorrect return_status after calling ' ||
1726: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
1727: FND_LOG.STRING(g_level_statement,
1728: g_module_name||'.'||l_procedure_name,
1729: 'RETURN_STATUS = ' || x_return_status);
1730: FND_LOG.STRING(g_level_statement,
1731: g_module_name||'.'||l_procedure_name||'.END',

Line 1730: FND_LOG.STRING(g_level_statement,

1726: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
1727: FND_LOG.STRING(g_level_statement,
1728: g_module_name||'.'||l_procedure_name,
1729: 'RETURN_STATUS = ' || x_return_status);
1730: FND_LOG.STRING(g_level_statement,
1731: g_module_name||'.'||l_procedure_name||'.END',
1732: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1733: END IF;
1734: RETURN;

Line 1764: FND_LOG.STRING(g_level_statement,

1760: END IF;
1761:
1762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1763: IF (g_level_statement >= g_current_runtime_level ) THEN
1764: FND_LOG.STRING(g_level_statement,
1765: g_module_name||'.'||l_procedure_name,
1766: 'Incorrect return_status after calling ' ||
1767: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
1768: FND_LOG.STRING(g_level_statement,

Line 1768: FND_LOG.STRING(g_level_statement,

1764: FND_LOG.STRING(g_level_statement,
1765: g_module_name||'.'||l_procedure_name,
1766: 'Incorrect return_status after calling ' ||
1767: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
1768: FND_LOG.STRING(g_level_statement,
1769: g_module_name||'.'||l_procedure_name,
1770: 'RETURN_STATUS = ' || x_return_status);
1771: FND_LOG.STRING(g_level_statement,
1772: g_module_name||'.'||l_procedure_name||'.END',

Line 1771: FND_LOG.STRING(g_level_statement,

1767: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
1768: FND_LOG.STRING(g_level_statement,
1769: g_module_name||'.'||l_procedure_name,
1770: 'RETURN_STATUS = ' || x_return_status);
1771: FND_LOG.STRING(g_level_statement,
1772: g_module_name||'.'||l_procedure_name||'.END',
1773: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1774: END IF;
1775: RETURN;

Line 1779: FND_LOG.STRING(g_level_procedure,

1775: RETURN;
1776: END IF;
1777:
1778: IF (g_level_procedure >= g_current_runtime_level ) THEN
1779: FND_LOG.STRING(g_level_procedure,
1780: g_module_name||'.'||l_procedure_name||'.END',
1781: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1782: END IF;
1783:

Line 1788: FND_LOG.STRING(g_level_unexpected,

1784: EXCEPTION
1785: WHEN OTHERS THEN
1786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1787: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1788: FND_LOG.STRING(g_level_unexpected,
1789: g_module_name||'.'||l_procedure_name,
1790: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1791: FND_LOG.STRING(g_level_unexpected,
1792: g_module_name||'.'||l_procedure_name||'.END',

Line 1791: FND_LOG.STRING(g_level_unexpected,

1787: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1788: FND_LOG.STRING(g_level_unexpected,
1789: g_module_name||'.'||l_procedure_name,
1790: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1791: FND_LOG.STRING(g_level_unexpected,
1792: g_module_name||'.'||l_procedure_name||'.END',
1793: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1794: END IF;
1795:

Line 1826: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1822: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1823: l_ind_rec NUMBER;
1824: BEGIN
1825:
1826: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1827:
1828: IF (g_level_procedure >= g_current_runtime_level ) THEN
1829: FND_LOG.STRING(g_level_procedure,
1830: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1829: FND_LOG.STRING(g_level_procedure,

1825:
1826: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1827:
1828: IF (g_level_procedure >= g_current_runtime_level ) THEN
1829: FND_LOG.STRING(g_level_procedure,
1830: g_module_name||'.'||l_procedure_name||'.BEGIN',
1831: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(+) ');
1832: END IF;
1833:

Line 1837: FND_LOG.STRING(g_level_statement,

1833:
1834: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1835:
1836: IF (g_level_statement >= g_current_runtime_level ) THEN
1837: FND_LOG.STRING(g_level_statement,
1838: g_module_name||'.'||l_procedure_name,
1839: 'p_multiple_jurisdictions_flag: '
1840: || p_multiple_jurisdictions_flag);
1841: END IF;

Line 1858: FND_LOG.STRING(g_level_statement,

1854: );
1855:
1856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1857: IF (g_level_statement >= g_current_runtime_level ) THEN
1858: FND_LOG.STRING(g_level_statement,
1859: g_module_name||'.'||l_procedure_name,
1860: 'Incorrect return_status after calling ' ||
1861: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1862: FND_LOG.STRING(g_level_statement,

Line 1862: FND_LOG.STRING(g_level_statement,

1858: FND_LOG.STRING(g_level_statement,
1859: g_module_name||'.'||l_procedure_name,
1860: 'Incorrect return_status after calling ' ||
1861: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1862: FND_LOG.STRING(g_level_statement,
1863: g_module_name||'.'||l_procedure_name,
1864: 'RETURN_STATUS = ' || x_return_status);
1865: FND_LOG.STRING(g_level_statement,
1866: g_module_name||'.'||l_procedure_name||'.END',

Line 1865: FND_LOG.STRING(g_level_statement,

1861: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1862: FND_LOG.STRING(g_level_statement,
1863: g_module_name||'.'||l_procedure_name,
1864: 'RETURN_STATUS = ' || x_return_status);
1865: FND_LOG.STRING(g_level_statement,
1866: g_module_name||'.'||l_procedure_name||'.END',
1867: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1868: END IF;
1869: RETURN;

Line 1876: FND_LOG.STRING(g_level_procedure,

1872: -- if valid tax rate info found, then set the jurisdiction
1873: -- and return to the calling side.
1874: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
1875: IF (g_level_procedure >= g_current_runtime_level ) THEN
1876: FND_LOG.STRING(g_level_procedure,
1877: g_module_name||'.'||l_procedure_name||'.END',
1878: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1879: END IF;
1880: RETURN;

Line 1901: FND_LOG.STRING(g_level_statement,

1897: );
1898:
1899: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1900: IF (g_level_statement >= g_current_runtime_level ) THEN
1901: FND_LOG.STRING(g_level_statement,
1902: g_module_name||'.'||l_procedure_name,
1903: 'Incorrect return_status after calling ' ||
1904: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1905: FND_LOG.STRING(g_level_statement,

Line 1905: FND_LOG.STRING(g_level_statement,

1901: FND_LOG.STRING(g_level_statement,
1902: g_module_name||'.'||l_procedure_name,
1903: 'Incorrect return_status after calling ' ||
1904: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1905: FND_LOG.STRING(g_level_statement,
1906: g_module_name||'.'||l_procedure_name,
1907: 'RETURN_STATUS = ' || x_return_status);
1908: FND_LOG.STRING(g_level_statement,
1909: g_module_name||'.'||l_procedure_name||'.END',

Line 1908: FND_LOG.STRING(g_level_statement,

1904: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1905: FND_LOG.STRING(g_level_statement,
1906: g_module_name||'.'||l_procedure_name,
1907: 'RETURN_STATUS = ' || x_return_status);
1908: FND_LOG.STRING(g_level_statement,
1909: g_module_name||'.'||l_procedure_name||'.END',
1910: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1911: END IF;
1912: RETURN;

Line 1919: FND_LOG.STRING(g_level_procedure,

1915: -- if valid tax rate info found, then set the jurisdiction
1916: -- and return to the calling side.
1917: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
1918: IF (g_level_procedure >= g_current_runtime_level ) THEN
1919: FND_LOG.STRING(g_level_procedure,
1920: g_module_name||'.'||l_procedure_name||'.END',
1921: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1922: END IF;
1923: RETURN;

Line 1943: FND_LOG.STRING(g_level_statement,

1939: x_return_status => x_return_status
1940: );
1941: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1942: IF (g_level_statement >= g_current_runtime_level ) THEN
1943: FND_LOG.STRING(g_level_statement,
1944: g_module_name||'.'||l_procedure_name,
1945: 'Incorrect return_status after calling ' ||
1946: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
1947: FND_LOG.STRING(g_level_statement,

Line 1947: FND_LOG.STRING(g_level_statement,

1943: FND_LOG.STRING(g_level_statement,
1944: g_module_name||'.'||l_procedure_name,
1945: 'Incorrect return_status after calling ' ||
1946: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
1947: FND_LOG.STRING(g_level_statement,
1948: g_module_name||'.'||l_procedure_name,
1949: 'RETURN_STATUS = ' || x_return_status);
1950: FND_LOG.STRING(g_level_statement,
1951: g_module_name||'.'||l_procedure_name||'.END',

Line 1950: FND_LOG.STRING(g_level_statement,

1946: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
1947: FND_LOG.STRING(g_level_statement,
1948: g_module_name||'.'||l_procedure_name,
1949: 'RETURN_STATUS = ' || x_return_status);
1950: FND_LOG.STRING(g_level_statement,
1951: g_module_name||'.'||l_procedure_name||'.END',
1952: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1953: END IF;
1954: RETURN;

Line 1967: FND_LOG.STRING(g_level_statement,

1963: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1964: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
1965:
1966: IF (g_level_statement >= g_current_runtime_level) THEN
1967: FND_LOG.STRING(g_level_statement,
1968: g_module_name||'.'||l_procedure_name,
1969: 'No rate found for tax rate code: ' ||p_tax_rate_code);
1970: END IF;
1971: END IF;

Line 1974: FND_LOG.STRING(g_level_procedure,

1970: END IF;
1971: END IF;
1972:
1973: IF (g_level_procedure >= g_current_runtime_level ) THEN
1974: FND_LOG.STRING(g_level_procedure,
1975: g_module_name||'.'||l_procedure_name||'.END',
1976: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1977: END IF;
1978:

Line 1983: FND_LOG.STRING(g_level_unexpected,

1979: EXCEPTION
1980: WHEN OTHERS THEN
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1983: FND_LOG.STRING(g_level_unexpected,
1984: g_module_name||'.'||l_procedure_name,
1985: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1986: FND_LOG.STRING(g_level_unexpected,
1987: g_module_name||'.'||l_procedure_name||'.END',

Line 1986: FND_LOG.STRING(g_level_unexpected,

1982: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1983: FND_LOG.STRING(g_level_unexpected,
1984: g_module_name||'.'||l_procedure_name,
1985: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1986: FND_LOG.STRING(g_level_unexpected,
1987: g_module_name||'.'||l_procedure_name||'.END',
1988: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1989: END IF;
1990: END get_tax_rate_pvt;

Line 2018: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2014: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_pvt';
2015:
2016: BEGIN
2017:
2018: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2019:
2020: IF (g_level_procedure >= g_current_runtime_level ) THEN
2021: FND_LOG.STRING(g_level_procedure,
2022: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 2021: FND_LOG.STRING(g_level_procedure,

2017:
2018: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2019:
2020: IF (g_level_procedure >= g_current_runtime_level ) THEN
2021: FND_LOG.STRING(g_level_procedure,
2022: g_module_name||'.'||l_procedure_name||'.BEGIN',
2023: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(+) ');
2024: END IF;
2025:

Line 2029: FND_LOG.STRING(g_level_statement,

2025:
2026: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2027:
2028: IF (g_level_statement >= g_current_runtime_level ) THEN
2029: FND_LOG.STRING(g_level_statement,
2030: g_module_name||'.'||l_procedure_name,
2031: 'p_multiple_jurisdictions_flag: '
2032: || p_multiple_jurisdictions_flag);
2033: END IF;

Line 2050: FND_LOG.STRING(g_level_statement,

2046: );
2047:
2048: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2049: IF (g_level_statement >= g_current_runtime_level ) THEN
2050: FND_LOG.STRING(g_level_statement,
2051: g_module_name||'.'||l_procedure_name,
2052: 'Incorrect return_status after calling ' ||
2053: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');
2054: FND_LOG.STRING(g_level_statement,

Line 2054: FND_LOG.STRING(g_level_statement,

2050: FND_LOG.STRING(g_level_statement,
2051: g_module_name||'.'||l_procedure_name,
2052: 'Incorrect return_status after calling ' ||
2053: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');
2054: FND_LOG.STRING(g_level_statement,
2055: g_module_name||'.'||l_procedure_name,
2056: 'RETURN_STATUS = ' || x_return_status);
2057: FND_LOG.STRING(g_level_statement,
2058: g_module_name||'.'||l_procedure_name||'.END',

Line 2057: FND_LOG.STRING(g_level_statement,

2053: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');
2054: FND_LOG.STRING(g_level_statement,
2055: g_module_name||'.'||l_procedure_name,
2056: 'RETURN_STATUS = ' || x_return_status);
2057: FND_LOG.STRING(g_level_statement,
2058: g_module_name||'.'||l_procedure_name||'.END',
2059: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2060: END IF;
2061: RETURN;

Line 2067: FND_LOG.STRING(g_level_procedure,

2063:
2064: -- if valid tax rate info found, return to the calling side.
2065: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2066: IF (g_level_procedure >= g_current_runtime_level ) THEN
2067: FND_LOG.STRING(g_level_procedure,
2068: g_module_name||'.'||l_procedure_name||'.END',
2069: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2070: END IF;
2071: RETURN;

Line 2093: FND_LOG.STRING(g_level_statement,

2089: );
2090:
2091: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2092: IF (g_level_statement >= g_current_runtime_level ) THEN
2093: FND_LOG.STRING(g_level_statement,
2094: g_module_name||'.'||l_procedure_name,
2095: 'Incorrect return_status after calling ' ||
2096: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
2097: FND_LOG.STRING(g_level_statement,

Line 2097: FND_LOG.STRING(g_level_statement,

2093: FND_LOG.STRING(g_level_statement,
2094: g_module_name||'.'||l_procedure_name,
2095: 'Incorrect return_status after calling ' ||
2096: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
2097: FND_LOG.STRING(g_level_statement,
2098: g_module_name||'.'||l_procedure_name,
2099: 'RETURN_STATUS = ' || x_return_status);
2100: FND_LOG.STRING(g_level_statement,
2101: g_module_name||'.'||l_procedure_name||'.END',

Line 2100: FND_LOG.STRING(g_level_statement,

2096: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
2097: FND_LOG.STRING(g_level_statement,
2098: g_module_name||'.'||l_procedure_name,
2099: 'RETURN_STATUS = ' || x_return_status);
2100: FND_LOG.STRING(g_level_statement,
2101: g_module_name||'.'||l_procedure_name||'.END',
2102: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2103: END IF;
2104: RETURN;

Line 2110: FND_LOG.STRING(g_level_procedure,

2106:
2107: -- if valid tax rate info found, return to the calling side.
2108: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2109: IF (g_level_procedure >= g_current_runtime_level ) THEN
2110: FND_LOG.STRING(g_level_procedure,
2111: g_module_name||'.'||l_procedure_name||'.END',
2112: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2113: END IF;
2114: RETURN;

Line 2132: FND_LOG.STRING(g_level_statement,

2128: x_return_status => x_return_status
2129: );
2130: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2131: IF (g_level_statement >= g_current_runtime_level ) THEN
2132: FND_LOG.STRING(g_level_statement,
2133: g_module_name||'.'||l_procedure_name,
2134: 'Incorrect return_status after calling ' ||
2135: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
2136: FND_LOG.STRING(g_level_statement,

Line 2136: FND_LOG.STRING(g_level_statement,

2132: FND_LOG.STRING(g_level_statement,
2133: g_module_name||'.'||l_procedure_name,
2134: 'Incorrect return_status after calling ' ||
2135: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
2136: FND_LOG.STRING(g_level_statement,
2137: g_module_name||'.'||l_procedure_name,
2138: 'RETURN_STATUS = ' || x_return_status);
2139: FND_LOG.STRING(g_level_statement,
2140: g_module_name||'.'||l_procedure_name||'.END',

Line 2139: FND_LOG.STRING(g_level_statement,

2135: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
2136: FND_LOG.STRING(g_level_statement,
2137: g_module_name||'.'||l_procedure_name,
2138: 'RETURN_STATUS = ' || x_return_status);
2139: FND_LOG.STRING(g_level_statement,
2140: g_module_name||'.'||l_procedure_name||'.END',
2141: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2142: END IF;
2143: RETURN;

Line 2158: FND_LOG.STRING(g_level_statement,

2154: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2155: FND_MESSAGE.SET_TOKEN('DATE',p_tax_date);
2156:
2157: IF (g_level_statement >= g_current_runtime_level) THEN
2158: FND_LOG.STRING(g_level_statement,
2159: g_module_name||'.'||l_procedure_name,
2160: 'No default rate found for tax rate code');
2161: END IF;
2162: END IF;

Line 2165: FND_LOG.STRING(g_level_procedure,

2161: END IF;
2162: END IF;
2163:
2164: IF (g_level_procedure >= g_current_runtime_level ) THEN
2165: FND_LOG.STRING(g_level_procedure,
2166: g_module_name||'.'||l_procedure_name||'.END',
2167: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2168: END IF;
2169:

Line 2174: FND_LOG.STRING(g_level_unexpected,

2170: EXCEPTION
2171: WHEN OTHERS THEN
2172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2173: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_unexpected,
2175: g_module_name||'.'||l_procedure_name,
2176: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2177: FND_LOG.STRING(g_level_unexpected,
2178: g_module_name||'.'||l_procedure_name||'.END',

Line 2177: FND_LOG.STRING(g_level_unexpected,

2173: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_unexpected,
2175: g_module_name||'.'||l_procedure_name,
2176: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2177: FND_LOG.STRING(g_level_unexpected,
2178: g_module_name||'.'||l_procedure_name||'.END',
2179: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2180: END IF;
2181:

Line 2211: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2207: l_count_jur NUMBER;
2208: l_tax_class VARCHAR2(30);
2209: l_tbl_index BINARY_INTEGER;
2210: BEGIN
2211: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2212:
2213: IF (g_level_procedure >= g_current_runtime_level ) THEN
2214: FND_LOG.STRING(g_level_procedure,
2215: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 2214: FND_LOG.STRING(g_level_procedure,

2210: BEGIN
2211: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2212:
2213: IF (g_level_procedure >= g_current_runtime_level ) THEN
2214: FND_LOG.STRING(g_level_procedure,
2215: g_module_name||'.'||l_procedure_name||'.BEGIN',
2216: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(+) ');
2217: END IF;
2218:

Line 2222: FND_LOG.STRING(g_level_statement,

2218:
2219: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2220:
2221: IF (g_level_statement >= g_current_runtime_level ) THEN
2222: FND_LOG.STRING(g_level_statement,
2223: g_module_name||'.'||l_procedure_name,
2224: 'p_tax = ' || p_tax);
2225: FND_LOG.STRING(g_level_statement,
2226: g_module_name||'.'||l_procedure_name,

Line 2225: FND_LOG.STRING(g_level_statement,

2221: IF (g_level_statement >= g_current_runtime_level ) THEN
2222: FND_LOG.STRING(g_level_statement,
2223: g_module_name||'.'||l_procedure_name,
2224: 'p_tax = ' || p_tax);
2225: FND_LOG.STRING(g_level_statement,
2226: g_module_name||'.'||l_procedure_name,
2227: 'p_tax_status_code = ' || p_tax_status_code);
2228: FND_LOG.STRING(g_level_statement,
2229: g_module_name||'.'||l_procedure_name,

Line 2228: FND_LOG.STRING(g_level_statement,

2224: 'p_tax = ' || p_tax);
2225: FND_LOG.STRING(g_level_statement,
2226: g_module_name||'.'||l_procedure_name,
2227: 'p_tax_status_code = ' || p_tax_status_code);
2228: FND_LOG.STRING(g_level_statement,
2229: g_module_name||'.'||l_procedure_name,
2230: 'p_tax_regime_code = ' || p_tax_regime_code);
2231: FND_LOG.STRING(g_level_statement,
2232: g_module_name||'.'||l_procedure_name,

Line 2231: FND_LOG.STRING(g_level_statement,

2227: 'p_tax_status_code = ' || p_tax_status_code);
2228: FND_LOG.STRING(g_level_statement,
2229: g_module_name||'.'||l_procedure_name,
2230: 'p_tax_regime_code = ' || p_tax_regime_code);
2231: FND_LOG.STRING(g_level_statement,
2232: g_module_name||'.'||l_procedure_name,
2233: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code);
2234: FND_LOG.STRING(g_level_statement,
2235: g_module_name||'.'||l_procedure_name,

Line 2234: FND_LOG.STRING(g_level_statement,

2230: 'p_tax_regime_code = ' || p_tax_regime_code);
2231: FND_LOG.STRING(g_level_statement,
2232: g_module_name||'.'||l_procedure_name,
2233: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code);
2234: FND_LOG.STRING(g_level_statement,
2235: g_module_name||'.'||l_procedure_name,
2236: 'p_tax_date = ' || p_tax_date);
2237: END IF;
2238:

Line 2268: FND_LOG.STRING(g_level_statement,

2264: x_return_status => x_return_status
2265: );
2266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2267: IF (g_level_statement >= g_current_runtime_level ) THEN
2268: FND_LOG.STRING(g_level_statement,
2269: g_module_name||'.'||l_procedure_name,
2270: 'Incorrect return_status after calling ' ||
2271: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');
2272: FND_LOG.STRING(g_level_statement,

Line 2272: FND_LOG.STRING(g_level_statement,

2268: FND_LOG.STRING(g_level_statement,
2269: g_module_name||'.'||l_procedure_name,
2270: 'Incorrect return_status after calling ' ||
2271: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');
2272: FND_LOG.STRING(g_level_statement,
2273: g_module_name||'.'||l_procedure_name,
2274: 'RETURN_STATUS = ' || x_return_status);
2275: FND_LOG.STRING(g_level_statement,
2276: g_module_name||'.'||l_procedure_name||'.END',

Line 2275: FND_LOG.STRING(g_level_statement,

2271: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');
2272: FND_LOG.STRING(g_level_statement,
2273: g_module_name||'.'||l_procedure_name,
2274: 'RETURN_STATUS = ' || x_return_status);
2275: FND_LOG.STRING(g_level_statement,
2276: g_module_name||'.'||l_procedure_name||'.END',
2277: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2278: END IF;
2279: RETURN;

Line 2311: FND_LOG.STRING(g_level_statement,

2307: );
2308:
2309: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2310: IF (g_level_statement >= g_current_runtime_level ) THEN
2311: FND_LOG.STRING(g_level_statement,
2312: g_module_name||'.'||l_procedure_name,
2313: 'Incorrect return_status after calling ' ||
2314: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');
2315: FND_LOG.STRING(g_level_statement,

Line 2315: FND_LOG.STRING(g_level_statement,

2311: FND_LOG.STRING(g_level_statement,
2312: g_module_name||'.'||l_procedure_name,
2313: 'Incorrect return_status after calling ' ||
2314: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');
2315: FND_LOG.STRING(g_level_statement,
2316: g_module_name||'.'||l_procedure_name,
2317: 'RETURN_STATUS = ' || x_return_status);
2318: FND_LOG.STRING(g_level_statement,
2319: g_module_name||'.'||l_procedure_name||'.END',

Line 2318: FND_LOG.STRING(g_level_statement,

2314: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');
2315: FND_LOG.STRING(g_level_statement,
2316: g_module_name||'.'||l_procedure_name,
2317: 'RETURN_STATUS = ' || x_return_status);
2318: FND_LOG.STRING(g_level_statement,
2319: g_module_name||'.'||l_procedure_name||'.END',
2320: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2321: END IF;
2322: -- lower level should assign the fnd msg stack

Line 2351: FND_LOG.STRING(g_level_statement,

2347: );
2348:
2349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2350: IF (g_level_statement >= g_current_runtime_level ) THEN
2351: FND_LOG.STRING(g_level_statement,
2352: g_module_name||'.'||l_procedure_name,
2353: 'Incorrect return_status after calling ' ||
2354: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');
2355: FND_LOG.STRING(g_level_statement,

Line 2355: FND_LOG.STRING(g_level_statement,

2351: FND_LOG.STRING(g_level_statement,
2352: g_module_name||'.'||l_procedure_name,
2353: 'Incorrect return_status after calling ' ||
2354: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');
2355: FND_LOG.STRING(g_level_statement,
2356: g_module_name||'.'||l_procedure_name,
2357: 'RETURN_STATUS = ' || x_return_status);
2358: FND_LOG.STRING(g_level_statement,
2359: g_module_name||'.'||l_procedure_name||'.END',

Line 2358: FND_LOG.STRING(g_level_statement,

2354: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');
2355: FND_LOG.STRING(g_level_statement,
2356: g_module_name||'.'||l_procedure_name,
2357: 'RETURN_STATUS = ' || x_return_status);
2358: FND_LOG.STRING(g_level_statement,
2359: g_module_name||'.'||l_procedure_name||'.END',
2360: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2361: END IF;
2362: -- lower level should have set the fnd msg stack

Line 2371: FND_LOG.STRING(g_level_statement,

2367: -- found for the tax_rate_code returned from rule engine.
2368:
2369: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2370: IF (g_level_statement >= g_current_runtime_level ) THEN
2371: FND_LOG.STRING(g_level_statement,
2372: g_module_name||'.'||l_procedure_name,
2373: 'tax_rate_code = ' || x_tax_rate_rec.tax_rate_code);
2374: FND_LOG.STRING(g_level_statement,
2375: g_module_name||'.'||l_procedure_name,

Line 2374: FND_LOG.STRING(g_level_statement,

2370: IF (g_level_statement >= g_current_runtime_level ) THEN
2371: FND_LOG.STRING(g_level_statement,
2372: g_module_name||'.'||l_procedure_name,
2373: 'tax_rate_code = ' || x_tax_rate_rec.tax_rate_code);
2374: FND_LOG.STRING(g_level_statement,
2375: g_module_name||'.'||l_procedure_name,
2376: 'tax_rate_id = ' || x_tax_rate_rec.tax_rate_id);
2377: FND_LOG.STRING(g_level_statement,
2378: g_module_name||'.'||l_procedure_name,

Line 2377: FND_LOG.STRING(g_level_statement,

2373: 'tax_rate_code = ' || x_tax_rate_rec.tax_rate_code);
2374: FND_LOG.STRING(g_level_statement,
2375: g_module_name||'.'||l_procedure_name,
2376: 'tax_rate_id = ' || x_tax_rate_rec.tax_rate_id);
2377: FND_LOG.STRING(g_level_statement,
2378: g_module_name||'.'||l_procedure_name,
2379: 'rate_type = ' || x_tax_rate_rec.rate_type_code);
2380: FND_LOG.STRING(g_level_statement,
2381: g_module_name||'.'||l_procedure_name,

Line 2380: FND_LOG.STRING(g_level_statement,

2376: 'tax_rate_id = ' || x_tax_rate_rec.tax_rate_id);
2377: FND_LOG.STRING(g_level_statement,
2378: g_module_name||'.'||l_procedure_name,
2379: 'rate_type = ' || x_tax_rate_rec.rate_type_code);
2380: FND_LOG.STRING(g_level_statement,
2381: g_module_name||'.'||l_procedure_name,
2382: 'percentage_rate = ' || x_tax_rate_rec.percentage_rate);
2383: FND_LOG.STRING(g_level_statement,
2384: g_module_name||'.'||l_procedure_name,

Line 2383: FND_LOG.STRING(g_level_statement,

2379: 'rate_type = ' || x_tax_rate_rec.rate_type_code);
2380: FND_LOG.STRING(g_level_statement,
2381: g_module_name||'.'||l_procedure_name,
2382: 'percentage_rate = ' || x_tax_rate_rec.percentage_rate);
2383: FND_LOG.STRING(g_level_statement,
2384: g_module_name||'.'||l_procedure_name,
2385: 'quantity_rate = ' || x_tax_rate_rec.quantity_rate);
2386: FND_LOG.STRING(g_level_statement,
2387: g_module_name||'.'||l_procedure_name,

Line 2386: FND_LOG.STRING(g_level_statement,

2382: 'percentage_rate = ' || x_tax_rate_rec.percentage_rate);
2383: FND_LOG.STRING(g_level_statement,
2384: g_module_name||'.'||l_procedure_name,
2385: 'quantity_rate = ' || x_tax_rate_rec.quantity_rate);
2386: FND_LOG.STRING(g_level_statement,
2387: g_module_name||'.'||l_procedure_name,
2388: 'allow_adhoc_tax_rate_flag = ' || x_tax_rate_rec.allow_adhoc_tax_rate_flag);
2389: FND_LOG.STRING(g_level_statement,
2390: g_module_name||'.'||l_procedure_name,

Line 2389: FND_LOG.STRING(g_level_statement,

2385: 'quantity_rate = ' || x_tax_rate_rec.quantity_rate);
2386: FND_LOG.STRING(g_level_statement,
2387: g_module_name||'.'||l_procedure_name,
2388: 'allow_adhoc_tax_rate_flag = ' || x_tax_rate_rec.allow_adhoc_tax_rate_flag);
2389: FND_LOG.STRING(g_level_statement,
2390: g_module_name||'.'||l_procedure_name,
2391: 'uom_code = ' || x_tax_rate_rec.uom_code);
2392: FND_LOG.STRING(g_level_statement,
2393: g_module_name||'.'||l_procedure_name,

Line 2392: FND_LOG.STRING(g_level_statement,

2388: 'allow_adhoc_tax_rate_flag = ' || x_tax_rate_rec.allow_adhoc_tax_rate_flag);
2389: FND_LOG.STRING(g_level_statement,
2390: g_module_name||'.'||l_procedure_name,
2391: 'uom_code = ' || x_tax_rate_rec.uom_code);
2392: FND_LOG.STRING(g_level_statement,
2393: g_module_name||'.'||l_procedure_name,
2394: 'offset_tax_rate_code = ' || x_tax_rate_rec.offset_tax_rate_code);
2395: END IF;
2396: END IF;

Line 2412: FND_LOG.STRING(g_level_procedure,

2408:
2409: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index) := x_tax_rate_rec;
2410:
2411: IF (g_level_procedure >= g_current_runtime_level ) THEN
2412: FND_LOG.STRING(g_level_procedure,
2413: g_module_name||'.'||l_procedure_name||'.END',
2414: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');
2415: END IF;
2416:

Line 2421: FND_LOG.STRING(g_level_unexpected,

2417: EXCEPTION
2418: WHEN OTHERS THEN
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2420: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2421: FND_LOG.STRING(g_level_unexpected,
2422: g_module_name||'.'||l_procedure_name,
2423: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2424: FND_LOG.STRING(g_level_unexpected,
2425: g_module_name||'.'||l_procedure_name||'.END',

Line 2424: FND_LOG.STRING(g_level_unexpected,

2420: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2421: FND_LOG.STRING(g_level_unexpected,
2422: g_module_name||'.'||l_procedure_name,
2423: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2424: FND_LOG.STRING(g_level_unexpected,
2425: g_module_name||'.'||l_procedure_name||'.END',
2426: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');
2427: END IF;
2428: