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.18 2009/07/03 07:58:25 srajapar 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.18 2009/07/03 07:58:25 srajapar 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 227: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 230: FND_LOG.STRING(g_level_procedure,

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

Line 272: FND_LOG.STRING(g_level_unexpected,

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

Line 275: FND_LOG.STRING(g_level_unexpected,

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

Line 287: FND_LOG.STRING(g_level_statement,

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

Line 290: FND_LOG.STRING(g_level_statement,

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

Line 329: FND_LOG.STRING(g_level_unexpected,

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

Line 332: FND_LOG.STRING(g_level_unexpected,

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

Line 344: FND_LOG.STRING(g_level_statement,

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

Line 347: FND_LOG.STRING(g_level_statement,

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

Line 359: FND_LOG.STRING(g_level_procedure,

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

Line 374: FND_LOG.STRING(g_level_unexpected,

370: IF get_tax_rate_mig_csr%ISOPEN THEN
371: CLOSE get_tax_rate_mig_csr;
372: END IF;
373: IF (g_level_unexpected >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_unexpected,
375: g_module_name||'.'||l_procedure_name,
376: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
377: FND_LOG.STRING(g_level_unexpected,
378: g_module_name||'.'||l_procedure_name||'.END',

Line 377: FND_LOG.STRING(g_level_unexpected,

373: IF (g_level_unexpected >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_unexpected,
375: g_module_name||'.'||l_procedure_name,
376: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
377: FND_LOG.STRING(g_level_unexpected,
378: g_module_name||'.'||l_procedure_name||'.END',
379: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
380: END IF;
381:

Line 494: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

490: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
491: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
492:
493: BEGIN
494: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
495:
496: IF (g_level_procedure >= g_current_runtime_level ) THEN
497: FND_LOG.STRING(g_level_procedure,
498: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 497: FND_LOG.STRING(g_level_procedure,

493: BEGIN
494: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
495:
496: IF (g_level_procedure >= g_current_runtime_level ) THEN
497: FND_LOG.STRING(g_level_procedure,
498: g_module_name||'.'||l_procedure_name||'.BEGIN',
499: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(+) ');
500: END IF;
501:

Line 533: FND_LOG.STRING(g_level_unexpected,

529:
530: CLOSE get_def_tax_rate_csr;
531:
532: IF (g_level_unexpected >= g_current_runtime_level ) THEN
533: FND_LOG.STRING(g_level_unexpected,
534: g_module_name||'.'||l_procedure_name,
535: 'Too Many Tax Rate Rows Retrived. ');
536: FND_LOG.STRING(g_level_unexpected,
537: g_module_name||'.'||l_procedure_name||'.END',

Line 536: FND_LOG.STRING(g_level_unexpected,

532: IF (g_level_unexpected >= g_current_runtime_level ) THEN
533: FND_LOG.STRING(g_level_unexpected,
534: g_module_name||'.'||l_procedure_name,
535: 'Too Many Tax Rate Rows Retrived. ');
536: FND_LOG.STRING(g_level_unexpected,
537: g_module_name||'.'||l_procedure_name||'.END',
538: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
539: END IF;
540: ELSE

Line 547: FND_LOG.STRING(g_level_statement,

543: x_tax_rate_rec := l_tax_rate_rec;
544: CLOSE get_def_tax_rate_csr;
545:
546: IF (g_level_statement >= g_current_runtime_level ) THEN
547: FND_LOG.STRING(g_level_statement,
548: g_module_name||'.'||l_procedure_name,
549: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
550: FND_LOG.STRING(g_level_statement,
551: g_module_name||'.'||l_procedure_name,

Line 550: FND_LOG.STRING(g_level_statement,

546: IF (g_level_statement >= g_current_runtime_level ) THEN
547: FND_LOG.STRING(g_level_statement,
548: g_module_name||'.'||l_procedure_name,
549: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
550: FND_LOG.STRING(g_level_statement,
551: g_module_name||'.'||l_procedure_name,
552: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
553: END IF;
554:

Line 588: FND_LOG.STRING(g_level_unexpected,

584:
585: CLOSE get_def_tax_rate_mig_csr;
586:
587: IF (g_level_unexpected >= g_current_runtime_level ) THEN
588: FND_LOG.STRING(g_level_unexpected,
589: g_module_name||'.'||l_procedure_name,
590: 'Too Many Tax Rate Rows Retrived. ');
591: FND_LOG.STRING(g_level_unexpected,
592: g_module_name||'.'||l_procedure_name||'.END',

Line 591: FND_LOG.STRING(g_level_unexpected,

587: IF (g_level_unexpected >= g_current_runtime_level ) THEN
588: FND_LOG.STRING(g_level_unexpected,
589: g_module_name||'.'||l_procedure_name,
590: 'Too Many Tax Rate Rows Retrived. ');
591: FND_LOG.STRING(g_level_unexpected,
592: g_module_name||'.'||l_procedure_name||'.END',
593: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
594: END IF;
595: ELSE

Line 602: FND_LOG.STRING(g_level_statement,

598: x_tax_rate_rec := l_tax_rate_rec;
599: CLOSE get_def_tax_rate_mig_csr;
600:
601: IF (g_level_statement >= g_current_runtime_level ) THEN
602: FND_LOG.STRING(g_level_statement,
603: g_module_name||'.'||l_procedure_name,
604: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
605: FND_LOG.STRING(g_level_statement,
606: g_module_name||'.'||l_procedure_name,

Line 605: FND_LOG.STRING(g_level_statement,

601: IF (g_level_statement >= g_current_runtime_level ) THEN
602: FND_LOG.STRING(g_level_statement,
603: g_module_name||'.'||l_procedure_name,
604: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
605: FND_LOG.STRING(g_level_statement,
606: g_module_name||'.'||l_procedure_name,
607: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
608: END IF;
609:

Line 617: FND_LOG.STRING(g_level_procedure,

613: END IF;
614: END IF;
615:
616: IF (g_level_procedure >= g_current_runtime_level ) THEN
617: FND_LOG.STRING(g_level_procedure,
618: g_module_name||'.'||l_procedure_name||'.END',
619: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_gt(-) ');
620: END IF;
621:

Line 632: FND_LOG.STRING(g_level_unexpected,

628: IF get_def_tax_rate_mig_csr%ISOPEN THEN
629: CLOSE get_def_tax_rate_mig_csr;
630: END IF;
631: IF (g_level_unexpected >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_unexpected,
633: g_module_name||'.'||l_procedure_name,
634: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
635: FND_LOG.STRING(g_level_unexpected,
636: g_module_name||'.'||l_procedure_name||'.END',

Line 635: FND_LOG.STRING(g_level_unexpected,

631: IF (g_level_unexpected >= g_current_runtime_level ) THEN
632: FND_LOG.STRING(g_level_unexpected,
633: g_module_name||'.'||l_procedure_name,
634: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
635: FND_LOG.STRING(g_level_unexpected,
636: g_module_name||'.'||l_procedure_name||'.END',
637: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt(-) ');
638: END IF;
639:

Line 746: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

742: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
743: -- l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
744:
745: BEGIN
746: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747:
748: IF (g_level_procedure >= g_current_runtime_level ) THEN
749: FND_LOG.STRING(g_level_procedure,
750: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 749: FND_LOG.STRING(g_level_procedure,

745: BEGIN
746: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
747:
748: IF (g_level_procedure >= g_current_runtime_level ) THEN
749: FND_LOG.STRING(g_level_procedure,
750: g_module_name||'.'||l_procedure_name||'.BEGIN',
751: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(+) ');
752: END IF;
753:

Line 788: FND_LOG.STRING(g_level_unexpected,

784:
785: CLOSE get_tax_rate_csr;
786:
787: IF (g_level_unexpected >= g_current_runtime_level ) THEN
788: FND_LOG.STRING(g_level_unexpected,
789: g_module_name||'.'||l_procedure_name,
790: 'Too Many Tax Rate Rows Retrived. ');
791: FND_LOG.STRING(g_level_unexpected,
792: g_module_name||'.'||l_procedure_name||'.END',

Line 791: FND_LOG.STRING(g_level_unexpected,

787: IF (g_level_unexpected >= g_current_runtime_level ) THEN
788: FND_LOG.STRING(g_level_unexpected,
789: g_module_name||'.'||l_procedure_name,
790: 'Too Many Tax Rate Rows Retrived. ');
791: FND_LOG.STRING(g_level_unexpected,
792: g_module_name||'.'||l_procedure_name||'.END',
793: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
794: END IF;
795:

Line 803: FND_LOG.STRING(g_level_statement,

799: x_tax_rate_rec := l_tax_rate_rec;
800: CLOSE get_tax_rate_csr;
801:
802: IF (g_level_statement >= g_current_runtime_level ) THEN
803: FND_LOG.STRING(g_level_statement,
804: g_module_name||'.'||l_procedure_name,
805: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
806: FND_LOG.STRING(g_level_statement,
807: g_module_name||'.'||l_procedure_name,

Line 806: FND_LOG.STRING(g_level_statement,

802: IF (g_level_statement >= g_current_runtime_level ) THEN
803: FND_LOG.STRING(g_level_statement,
804: g_module_name||'.'||l_procedure_name,
805: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
806: FND_LOG.STRING(g_level_statement,
807: g_module_name||'.'||l_procedure_name,
808: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
809: END IF;
810:

Line 837: FND_LOG.STRING(g_level_unexpected,

833:
834: CLOSE get_tax_rate_mig_csr;
835:
836: IF (g_level_unexpected >= g_current_runtime_level ) THEN
837: FND_LOG.STRING(g_level_unexpected,
838: g_module_name||'.'||l_procedure_name,
839: 'Too Many Tax Rate Rows Retrived. ');
840: FND_LOG.STRING(g_level_unexpected,
841: g_module_name||'.'||l_procedure_name||'.END',

Line 840: FND_LOG.STRING(g_level_unexpected,

836: IF (g_level_unexpected >= g_current_runtime_level ) THEN
837: FND_LOG.STRING(g_level_unexpected,
838: g_module_name||'.'||l_procedure_name,
839: 'Too Many Tax Rate Rows Retrived. ');
840: FND_LOG.STRING(g_level_unexpected,
841: g_module_name||'.'||l_procedure_name||'.END',
842: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
843: END IF;
844:

Line 852: FND_LOG.STRING(g_level_statement,

848: x_tax_rate_rec := l_tax_rate_rec;
849: CLOSE get_tax_rate_mig_csr;
850:
851: IF (g_level_statement >= g_current_runtime_level ) THEN
852: FND_LOG.STRING(g_level_statement,
853: g_module_name||'.'||l_procedure_name,
854: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
855: FND_LOG.STRING(g_level_statement,
856: g_module_name||'.'||l_procedure_name,

Line 855: FND_LOG.STRING(g_level_statement,

851: IF (g_level_statement >= g_current_runtime_level ) THEN
852: FND_LOG.STRING(g_level_statement,
853: g_module_name||'.'||l_procedure_name,
854: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
855: FND_LOG.STRING(g_level_statement,
856: g_module_name||'.'||l_procedure_name,
857: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
858: END IF;
859:

Line 868: FND_LOG.STRING(g_level_procedure,

864:
865: END IF;
866:
867: IF (g_level_procedure >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_procedure,
869: g_module_name||'.'||l_procedure_name||'.END',
870: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
871: END IF;
872:

Line 883: FND_LOG.STRING(g_level_unexpected,

879: IF get_tax_rate_mig_csr%ISOPEN THEN
880: CLOSE get_tax_rate_mig_csr;
881: END IF;
882: IF (g_level_unexpected >= g_current_runtime_level ) THEN
883: FND_LOG.STRING(g_level_unexpected,
884: g_module_name||'.'||l_procedure_name,
885: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
886: FND_LOG.STRING(g_level_unexpected,
887: g_module_name||'.'||l_procedure_name||'.END',

Line 886: FND_LOG.STRING(g_level_unexpected,

882: IF (g_level_unexpected >= g_current_runtime_level ) THEN
883: FND_LOG.STRING(g_level_unexpected,
884: g_module_name||'.'||l_procedure_name,
885: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
886: FND_LOG.STRING(g_level_unexpected,
887: g_module_name||'.'||l_procedure_name||'.END',
888: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code(-) ');
889: END IF;
890:

Line 997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

993: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
994: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
995:
996: BEGIN
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
998:
999: IF (g_level_procedure >= g_current_runtime_level ) THEN
1000: FND_LOG.STRING(g_level_procedure,
1001: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1000: FND_LOG.STRING(g_level_procedure,

996: BEGIN
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
998:
999: IF (g_level_procedure >= g_current_runtime_level ) THEN
1000: FND_LOG.STRING(g_level_procedure,
1001: g_module_name||'.'||l_procedure_name||'.BEGIN',
1002: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(+) ');
1003: END IF;
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1029: FND_LOG.STRING(g_level_unexpected,

1025:
1026: CLOSE get_tax_rate_csr_no_jur;
1027:
1028: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1029: FND_LOG.STRING(g_level_unexpected,
1030: g_module_name||'.'||l_procedure_name,
1031: 'Too Many Tax Rate Rows Retrived. ');
1032: FND_LOG.STRING(g_level_unexpected,
1033: g_module_name||'.'||l_procedure_name||'.END',

Line 1032: FND_LOG.STRING(g_level_unexpected,

1028: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1029: FND_LOG.STRING(g_level_unexpected,
1030: g_module_name||'.'||l_procedure_name,
1031: 'Too Many Tax Rate Rows Retrived. ');
1032: FND_LOG.STRING(g_level_unexpected,
1033: g_module_name||'.'||l_procedure_name||'.END',
1034: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1035: END IF;
1036:

Line 1045: FND_LOG.STRING(g_level_statement,

1041: x_tax_rate_rec := l_tax_rate_rec;
1042: CLOSE get_tax_rate_csr_no_jur;
1043:
1044: IF (g_level_statement >= g_current_runtime_level ) THEN
1045: FND_LOG.STRING(g_level_statement,
1046: g_module_name||'.'||l_procedure_name,
1047: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1048: FND_LOG.STRING(g_level_statement,
1049: g_module_name||'.'||l_procedure_name,

Line 1048: FND_LOG.STRING(g_level_statement,

1044: IF (g_level_statement >= g_current_runtime_level ) THEN
1045: FND_LOG.STRING(g_level_statement,
1046: g_module_name||'.'||l_procedure_name,
1047: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1048: FND_LOG.STRING(g_level_statement,
1049: g_module_name||'.'||l_procedure_name,
1050: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1051: END IF;
1052: -- END IF;

Line 1079: FND_LOG.STRING(g_level_unexpected,

1075:
1076: CLOSE get_tax_rate_csr_no_jur_mig;
1077:
1078: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1079: FND_LOG.STRING(g_level_unexpected,
1080: g_module_name||'.'||l_procedure_name,
1081: 'Too Many Tax Rate Rows Retrived. ');
1082: FND_LOG.STRING(g_level_unexpected,
1083: g_module_name||'.'||l_procedure_name||'.END',

Line 1082: FND_LOG.STRING(g_level_unexpected,

1078: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1079: FND_LOG.STRING(g_level_unexpected,
1080: g_module_name||'.'||l_procedure_name,
1081: 'Too Many Tax Rate Rows Retrived. ');
1082: FND_LOG.STRING(g_level_unexpected,
1083: g_module_name||'.'||l_procedure_name||'.END',
1084: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1085: END IF;
1086:

Line 1095: FND_LOG.STRING(g_level_statement,

1091: x_tax_rate_rec := l_tax_rate_rec;
1092: CLOSE get_tax_rate_csr_no_jur_mig;
1093:
1094: IF (g_level_statement >= g_current_runtime_level ) THEN
1095: FND_LOG.STRING(g_level_statement,
1096: g_module_name||'.'||l_procedure_name,
1097: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1098: FND_LOG.STRING(g_level_statement,
1099: g_module_name||'.'||l_procedure_name,

Line 1098: FND_LOG.STRING(g_level_statement,

1094: IF (g_level_statement >= g_current_runtime_level ) THEN
1095: FND_LOG.STRING(g_level_statement,
1096: g_module_name||'.'||l_procedure_name,
1097: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1098: FND_LOG.STRING(g_level_statement,
1099: g_module_name||'.'||l_procedure_name,
1100: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1101: END IF;
1102:

Line 1111: FND_LOG.STRING(g_level_procedure,

1107:
1108: END IF;
1109:
1110: IF (g_level_procedure >= g_current_runtime_level ) THEN
1111: FND_LOG.STRING(g_level_procedure,
1112: g_module_name||'.'||l_procedure_name||'.END',
1113: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1114: END IF;
1115:

Line 1126: FND_LOG.STRING(g_level_unexpected,

1122: IF get_tax_rate_csr_no_jur_mig%ISOPEN THEN
1123: CLOSE get_tax_rate_csr_no_jur_mig;
1124: END IF;
1125: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1126: FND_LOG.STRING(g_level_unexpected,
1127: g_module_name||'.'||l_procedure_name,
1128: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1129: FND_LOG.STRING(g_level_unexpected,
1130: g_module_name||'.'||l_procedure_name||'.END',

Line 1129: FND_LOG.STRING(g_level_unexpected,

1125: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1126: FND_LOG.STRING(g_level_unexpected,
1127: g_module_name||'.'||l_procedure_name,
1128: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1129: FND_LOG.STRING(g_level_unexpected,
1130: g_module_name||'.'||l_procedure_name||'.END',
1131: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code(-) ');
1132: END IF;
1133: END get_tax_rate_no_jur_code;

Line 1241: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1237: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1238: l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1239:
1240: BEGIN
1241: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1242:
1243: IF (g_level_procedure >= g_current_runtime_level ) THEN
1244: FND_LOG.STRING(g_level_procedure,
1245: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1244: FND_LOG.STRING(g_level_procedure,

1240: BEGIN
1241: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1242:
1243: IF (g_level_procedure >= g_current_runtime_level ) THEN
1244: FND_LOG.STRING(g_level_procedure,
1245: g_module_name||'.'||l_procedure_name||'.BEGIN',
1246: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(+) ');
1247: END IF;
1248:

Line 1276: FND_LOG.STRING(g_level_unexpected,

1272:
1273: CLOSE get_def_tax_rate_csr;
1274:
1275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1276: FND_LOG.STRING(g_level_unexpected,
1277: g_module_name||'.'||l_procedure_name,
1278: 'Too Many Tax Rate Rows Retrived. ');
1279: FND_LOG.STRING(g_level_unexpected,
1280: g_module_name||'.'||l_procedure_name||'.END',

Line 1279: FND_LOG.STRING(g_level_unexpected,

1275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1276: FND_LOG.STRING(g_level_unexpected,
1277: g_module_name||'.'||l_procedure_name,
1278: 'Too Many Tax Rate Rows Retrived. ');
1279: FND_LOG.STRING(g_level_unexpected,
1280: g_module_name||'.'||l_procedure_name||'.END',
1281: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1282: END IF;
1283: ELSE

Line 1290: FND_LOG.STRING(g_level_statement,

1286: x_tax_rate_rec := l_tax_rate_rec;
1287: CLOSE get_def_tax_rate_csr;
1288:
1289: IF (g_level_statement >= g_current_runtime_level ) THEN
1290: FND_LOG.STRING(g_level_statement,
1291: g_module_name||'.'||l_procedure_name,
1292: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1293: FND_LOG.STRING(g_level_statement,
1294: g_module_name||'.'||l_procedure_name,

Line 1293: FND_LOG.STRING(g_level_statement,

1289: IF (g_level_statement >= g_current_runtime_level ) THEN
1290: FND_LOG.STRING(g_level_statement,
1291: g_module_name||'.'||l_procedure_name,
1292: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1293: FND_LOG.STRING(g_level_statement,
1294: g_module_name||'.'||l_procedure_name,
1295: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1296: END IF;
1297:

Line 1327: FND_LOG.STRING(g_level_unexpected,

1323:
1324: CLOSE get_def_tax_rate_mig_csr;
1325:
1326: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1327: FND_LOG.STRING(g_level_unexpected,
1328: g_module_name||'.'||l_procedure_name,
1329: 'Too Many Tax Rate Rows Retrived. ');
1330: FND_LOG.STRING(g_level_unexpected,
1331: g_module_name||'.'||l_procedure_name||'.END',

Line 1330: FND_LOG.STRING(g_level_unexpected,

1326: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1327: FND_LOG.STRING(g_level_unexpected,
1328: g_module_name||'.'||l_procedure_name,
1329: 'Too Many Tax Rate Rows Retrived. ');
1330: FND_LOG.STRING(g_level_unexpected,
1331: g_module_name||'.'||l_procedure_name||'.END',
1332: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1333: END IF;
1334: ELSE

Line 1341: FND_LOG.STRING(g_level_statement,

1337: x_tax_rate_rec := l_tax_rate_rec;
1338: CLOSE get_def_tax_rate_mig_csr;
1339:
1340: IF (g_level_statement >= g_current_runtime_level ) THEN
1341: FND_LOG.STRING(g_level_statement,
1342: g_module_name||'.'||l_procedure_name,
1343: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1344: FND_LOG.STRING(g_level_statement,
1345: g_module_name||'.'||l_procedure_name,

Line 1344: FND_LOG.STRING(g_level_statement,

1340: IF (g_level_statement >= g_current_runtime_level ) THEN
1341: FND_LOG.STRING(g_level_statement,
1342: g_module_name||'.'||l_procedure_name,
1343: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1344: FND_LOG.STRING(g_level_statement,
1345: g_module_name||'.'||l_procedure_name,
1346: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1347: END IF;
1348:

Line 1357: FND_LOG.STRING(g_level_procedure,

1353:
1354: END IF;
1355:
1356: IF (g_level_procedure >= g_current_runtime_level ) THEN
1357: FND_LOG.STRING(g_level_procedure,
1358: g_module_name||'.'||l_procedure_name||'.END',
1359: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1360: END IF;
1361:

Line 1372: FND_LOG.STRING(g_level_unexpected,

1368: IF get_def_tax_rate_mig_csr%ISOPEN THEN
1369: CLOSE get_def_tax_rate_mig_csr;
1370: END IF;
1371: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1372: FND_LOG.STRING(g_level_unexpected,
1373: g_module_name||'.'||l_procedure_name,
1374: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1375: FND_LOG.STRING(g_level_unexpected,
1376: g_module_name||'.'||l_procedure_name||'.END',

Line 1375: FND_LOG.STRING(g_level_unexpected,

1371: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1372: FND_LOG.STRING(g_level_unexpected,
1373: g_module_name||'.'||l_procedure_name,
1374: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1375: FND_LOG.STRING(g_level_unexpected,
1376: g_module_name||'.'||l_procedure_name||'.END',
1377: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_by_jur_code(-) ');
1378: END IF;
1379: END get_def_tax_rate_by_jur_code;

Line 1486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1482: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1483: --l_tax_rate_rec_tmp ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1484:
1485: BEGIN
1486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1487:
1488: IF (g_level_procedure >= g_current_runtime_level ) THEN
1489: FND_LOG.STRING(g_level_procedure,
1490: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1489: FND_LOG.STRING(g_level_procedure,

1485: BEGIN
1486: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1487:
1488: IF (g_level_procedure >= g_current_runtime_level ) THEN
1489: FND_LOG.STRING(g_level_procedure,
1490: g_module_name||'.'||l_procedure_name||'.BEGIN',
1491: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(+) ');
1492: END IF;
1493: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1518: FND_LOG.STRING(g_level_unexpected,

1514: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1515:
1516: CLOSE get_def_tax_rate_no_jur_csr;
1517: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1518: FND_LOG.STRING(g_level_unexpected,
1519: g_module_name||'.'||l_procedure_name,
1520: 'Too Many Tax Rate Rows Retrived. ');
1521: FND_LOG.STRING(g_level_unexpected,
1522: g_module_name||'.'||l_procedure_name||'.END',

Line 1521: FND_LOG.STRING(g_level_unexpected,

1517: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1518: FND_LOG.STRING(g_level_unexpected,
1519: g_module_name||'.'||l_procedure_name,
1520: 'Too Many Tax Rate Rows Retrived. ');
1521: FND_LOG.STRING(g_level_unexpected,
1522: g_module_name||'.'||l_procedure_name||'.END',
1523: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1524: END IF;
1525: RETURN;

Line 1533: FND_LOG.STRING(g_level_statement,

1529: x_tax_rate_rec := l_tax_rate_rec;
1530: CLOSE get_def_tax_rate_no_jur_csr;
1531:
1532: IF (g_level_statement >= g_current_runtime_level ) THEN
1533: FND_LOG.STRING(g_level_statement,
1534: g_module_name||'.'||l_procedure_name,
1535: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1536: FND_LOG.STRING(g_level_statement,
1537: g_module_name||'.'||l_procedure_name,

Line 1536: FND_LOG.STRING(g_level_statement,

1532: IF (g_level_statement >= g_current_runtime_level ) THEN
1533: FND_LOG.STRING(g_level_statement,
1534: g_module_name||'.'||l_procedure_name,
1535: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1536: FND_LOG.STRING(g_level_statement,
1537: g_module_name||'.'||l_procedure_name,
1538: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1539: END IF;
1540:

Line 1548: FND_LOG.STRING(g_level_statement,

1544:
1545: -- tax rate is not found for NULL tax_class, try to get it with p_tax_class
1546: --
1547: IF (g_level_statement >= g_current_runtime_level ) THEN
1548: FND_LOG.STRING(g_level_statement,
1549: g_module_name||'.'||l_procedure_name,
1550: 'tax_class = ' || p_tax_class);
1551: END IF;
1552:

Line 1574: FND_LOG.STRING(g_level_unexpected,

1570: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1571:
1572: CLOSE get_def_tax_rate_no_jur_mi_csr;
1573: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1574: FND_LOG.STRING(g_level_unexpected,
1575: g_module_name||'.'||l_procedure_name,
1576: 'Too Many Tax Rate Rows Retrived. ');
1577: FND_LOG.STRING(g_level_unexpected,
1578: g_module_name||'.'||l_procedure_name||'.END',

Line 1577: FND_LOG.STRING(g_level_unexpected,

1573: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1574: FND_LOG.STRING(g_level_unexpected,
1575: g_module_name||'.'||l_procedure_name,
1576: 'Too Many Tax Rate Rows Retrived. ');
1577: FND_LOG.STRING(g_level_unexpected,
1578: g_module_name||'.'||l_procedure_name||'.END',
1579: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1580: END IF;
1581: RETURN;

Line 1589: FND_LOG.STRING(g_level_statement,

1585: x_tax_rate_rec := l_tax_rate_rec;
1586: CLOSE get_def_tax_rate_no_jur_mi_csr;
1587:
1588: IF (g_level_statement >= g_current_runtime_level ) THEN
1589: FND_LOG.STRING(g_level_statement,
1590: g_module_name||'.'||l_procedure_name,
1591: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1592: FND_LOG.STRING(g_level_statement,
1593: g_module_name||'.'||l_procedure_name,

Line 1592: FND_LOG.STRING(g_level_statement,

1588: IF (g_level_statement >= g_current_runtime_level ) THEN
1589: FND_LOG.STRING(g_level_statement,
1590: g_module_name||'.'||l_procedure_name,
1591: 'Found Tax rate: tax_rate_id: ' || x_tax_rate_rec.tax_rate_id );
1592: FND_LOG.STRING(g_level_statement,
1593: g_module_name||'.'||l_procedure_name,
1594: 'tax_rate_code: ' || x_tax_rate_rec.tax_rate_code );
1595: END IF;
1596:

Line 1605: FND_LOG.STRING(g_level_procedure,

1601:
1602: END IF;
1603:
1604: IF (g_level_procedure >= g_current_runtime_level ) THEN
1605: FND_LOG.STRING(g_level_procedure,
1606: g_module_name||'.'||l_procedure_name||'.END',
1607: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1608: END IF;
1609:

Line 1620: FND_LOG.STRING(g_level_unexpected,

1616: IF get_def_tax_rate_no_jur_mi_csr%ISOPEN THEN
1617: CLOSE get_def_tax_rate_no_jur_mi_csr;
1618: END IF;
1619: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1620: FND_LOG.STRING(g_level_unexpected,
1621: g_module_name||'.'||l_procedure_name,
1622: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1623: FND_LOG.STRING(g_level_unexpected,
1624: g_module_name||'.'||l_procedure_name||'.END',

Line 1623: FND_LOG.STRING(g_level_unexpected,

1619: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1620: FND_LOG.STRING(g_level_unexpected,
1621: g_module_name||'.'||l_procedure_name,
1622: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1623: FND_LOG.STRING(g_level_unexpected,
1624: g_module_name||'.'||l_procedure_name||'.END',
1625: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_no_jur_code(-) ');
1626: END IF;
1627: END get_def_tax_rate_no_jur_code;

Line 1661: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1657: l_jurisdictions_found VARCHAR2(1);
1658: l_tax_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
1659: l_multiple_jurisdictions_flag VARCHAR2(1);
1660: BEGIN
1661: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1662:
1663: IF (g_level_procedure >= g_current_runtime_level ) THEN
1664: FND_LOG.STRING(g_level_procedure,
1665: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1664: FND_LOG.STRING(g_level_procedure,

1660: BEGIN
1661: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1662:
1663: IF (g_level_procedure >= g_current_runtime_level ) THEN
1664: FND_LOG.STRING(g_level_procedure,
1665: g_module_name||'.'||l_procedure_name||'.BEGIN',
1666: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(+) ');
1667: END IF;
1668:

Line 1675: FND_LOG.STRING(g_level_statement,

1671: -- get location_id
1672: l_structure_name := 'TRX_LINE_DIST_TBL';
1673:
1674: IF (g_level_statement >= g_current_runtime_level ) THEN
1675: FND_LOG.STRING(g_level_statement,
1676: g_module_name||'.'||l_procedure_name,
1677: 'Calling ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value...');
1678: END IF;
1679:

Line 1690: FND_LOG.STRING(g_level_statement,

1686: -- TCM procedure called in get_pos_parameter_name will set the error msg
1687: -- here we just need to return to the calling point which will populate
1688: -- the context information.
1689: IF (g_level_statement >= g_current_runtime_level ) THEN
1690: FND_LOG.STRING(g_level_statement,
1691: g_module_name||'.'||l_procedure_name,
1692: 'Incorrect return_status after calling ' ||
1693: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
1694: FND_LOG.STRING(g_level_statement,

Line 1694: FND_LOG.STRING(g_level_statement,

1690: FND_LOG.STRING(g_level_statement,
1691: g_module_name||'.'||l_procedure_name,
1692: 'Incorrect return_status after calling ' ||
1693: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
1694: FND_LOG.STRING(g_level_statement,
1695: g_module_name||'.'||l_procedure_name,
1696: 'RETURN_STATUS = ' || x_return_status);
1697: FND_LOG.STRING(g_level_statement,
1698: g_module_name||'.'||l_procedure_name||'.END',

Line 1697: FND_LOG.STRING(g_level_statement,

1693: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
1694: FND_LOG.STRING(g_level_statement,
1695: g_module_name||'.'||l_procedure_name,
1696: 'RETURN_STATUS = ' || x_return_status);
1697: FND_LOG.STRING(g_level_statement,
1698: g_module_name||'.'||l_procedure_name||'.END',
1699: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1700: END IF;
1701: RETURN;

Line 1714: FND_LOG.STRING(g_level_statement,

1710:
1711: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1712: THEN
1713: IF (g_level_statement >= g_current_runtime_level ) THEN
1714: FND_LOG.STRING(g_level_statement,
1715: g_module_name||'.'||l_procedure_name,
1716: 'Incorrect return_status after calling ' ||
1717: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
1718: FND_LOG.STRING(g_level_statement,

Line 1718: FND_LOG.STRING(g_level_statement,

1714: FND_LOG.STRING(g_level_statement,
1715: g_module_name||'.'||l_procedure_name,
1716: 'Incorrect return_status after calling ' ||
1717: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
1718: FND_LOG.STRING(g_level_statement,
1719: g_module_name||'.'||l_procedure_name,
1720: 'RETURN_STATUS = ' || x_return_status);
1721: FND_LOG.STRING(g_level_statement,
1722: g_module_name||'.'||l_procedure_name||'.END',

Line 1721: FND_LOG.STRING(g_level_statement,

1717: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
1718: FND_LOG.STRING(g_level_statement,
1719: g_module_name||'.'||l_procedure_name,
1720: 'RETURN_STATUS = ' || x_return_status);
1721: FND_LOG.STRING(g_level_statement,
1722: g_module_name||'.'||l_procedure_name||'.END',
1723: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1724: END IF;
1725: RETURN;

Line 1745: FND_LOG.STRING(g_level_statement,

1741:
1742: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
1743: THEN
1744: IF (g_level_statement >= g_current_runtime_level ) THEN
1745: FND_LOG.STRING(g_level_statement,
1746: g_module_name||'.'||l_procedure_name,
1747: 'Incorrect return_status after calling ' ||
1748: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
1749: FND_LOG.STRING(g_level_statement,

Line 1749: FND_LOG.STRING(g_level_statement,

1745: FND_LOG.STRING(g_level_statement,
1746: g_module_name||'.'||l_procedure_name,
1747: 'Incorrect return_status after calling ' ||
1748: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
1749: FND_LOG.STRING(g_level_statement,
1750: g_module_name||'.'||l_procedure_name,
1751: 'RETURN_STATUS = ' || x_return_status);
1752: FND_LOG.STRING(g_level_statement,
1753: g_module_name||'.'||l_procedure_name||'.END',

Line 1752: FND_LOG.STRING(g_level_statement,

1748: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
1749: FND_LOG.STRING(g_level_statement,
1750: g_module_name||'.'||l_procedure_name,
1751: 'RETURN_STATUS = ' || x_return_status);
1752: FND_LOG.STRING(g_level_statement,
1753: g_module_name||'.'||l_procedure_name||'.END',
1754: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1755: END IF;
1756: RETURN;

Line 1786: FND_LOG.STRING(g_level_statement,

1782: END IF;
1783:
1784: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1785: IF (g_level_statement >= g_current_runtime_level ) THEN
1786: FND_LOG.STRING(g_level_statement,
1787: g_module_name||'.'||l_procedure_name,
1788: 'Incorrect return_status after calling ' ||
1789: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
1790: FND_LOG.STRING(g_level_statement,

Line 1790: FND_LOG.STRING(g_level_statement,

1786: FND_LOG.STRING(g_level_statement,
1787: g_module_name||'.'||l_procedure_name,
1788: 'Incorrect return_status after calling ' ||
1789: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
1790: FND_LOG.STRING(g_level_statement,
1791: g_module_name||'.'||l_procedure_name,
1792: 'RETURN_STATUS = ' || x_return_status);
1793: FND_LOG.STRING(g_level_statement,
1794: g_module_name||'.'||l_procedure_name||'.END',

Line 1793: FND_LOG.STRING(g_level_statement,

1789: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
1790: FND_LOG.STRING(g_level_statement,
1791: g_module_name||'.'||l_procedure_name,
1792: 'RETURN_STATUS = ' || x_return_status);
1793: FND_LOG.STRING(g_level_statement,
1794: g_module_name||'.'||l_procedure_name||'.END',
1795: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-)');
1796: END IF;
1797: RETURN;

Line 1801: FND_LOG.STRING(g_level_procedure,

1797: RETURN;
1798: END IF;
1799:
1800: IF (g_level_procedure >= g_current_runtime_level ) THEN
1801: FND_LOG.STRING(g_level_procedure,
1802: g_module_name||'.'||l_procedure_name||'.END',
1803: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1804: END IF;
1805:

Line 1810: FND_LOG.STRING(g_level_unexpected,

1806: EXCEPTION
1807: WHEN OTHERS THEN
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1810: FND_LOG.STRING(g_level_unexpected,
1811: g_module_name||'.'||l_procedure_name,
1812: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1813: FND_LOG.STRING(g_level_unexpected,
1814: g_module_name||'.'||l_procedure_name||'.END',

Line 1813: FND_LOG.STRING(g_level_unexpected,

1809: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1810: FND_LOG.STRING(g_level_unexpected,
1811: g_module_name||'.'||l_procedure_name,
1812: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1813: FND_LOG.STRING(g_level_unexpected,
1814: g_module_name||'.'||l_procedure_name||'.END',
1815: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal(-) ');
1816: END IF;
1817:

Line 1848: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1844: l_tax_jurisdiction_code ZX_RATES_B.tax_jurisdiction_code%TYPE;
1845: l_ind_rec NUMBER;
1846: BEGIN
1847:
1848: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1849:
1850: IF (g_level_procedure >= g_current_runtime_level ) THEN
1851: FND_LOG.STRING(g_level_procedure,
1852: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 1851: FND_LOG.STRING(g_level_procedure,

1847:
1848: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1849:
1850: IF (g_level_procedure >= g_current_runtime_level ) THEN
1851: FND_LOG.STRING(g_level_procedure,
1852: g_module_name||'.'||l_procedure_name||'.BEGIN',
1853: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(+) ');
1854: END IF;
1855:

Line 1859: FND_LOG.STRING(g_level_statement,

1855:
1856: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1857:
1858: IF (g_level_statement >= g_current_runtime_level ) THEN
1859: FND_LOG.STRING(g_level_statement,
1860: g_module_name||'.'||l_procedure_name,
1861: 'p_multiple_jurisdictions_flag: '
1862: || p_multiple_jurisdictions_flag);
1863: END IF;

Line 1880: FND_LOG.STRING(g_level_statement,

1876: );
1877:
1878: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1879: IF (g_level_statement >= g_current_runtime_level ) THEN
1880: FND_LOG.STRING(g_level_statement,
1881: g_module_name||'.'||l_procedure_name,
1882: 'Incorrect return_status after calling ' ||
1883: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1884: FND_LOG.STRING(g_level_statement,

Line 1884: FND_LOG.STRING(g_level_statement,

1880: FND_LOG.STRING(g_level_statement,
1881: g_module_name||'.'||l_procedure_name,
1882: 'Incorrect return_status after calling ' ||
1883: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1884: FND_LOG.STRING(g_level_statement,
1885: g_module_name||'.'||l_procedure_name,
1886: 'RETURN_STATUS = ' || x_return_status);
1887: FND_LOG.STRING(g_level_statement,
1888: g_module_name||'.'||l_procedure_name||'.END',

Line 1887: FND_LOG.STRING(g_level_statement,

1883: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1884: FND_LOG.STRING(g_level_statement,
1885: g_module_name||'.'||l_procedure_name,
1886: 'RETURN_STATUS = ' || x_return_status);
1887: FND_LOG.STRING(g_level_statement,
1888: g_module_name||'.'||l_procedure_name||'.END',
1889: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1890: END IF;
1891: RETURN;

Line 1898: FND_LOG.STRING(g_level_procedure,

1894: -- if valid tax rate info found, then set the jurisdiction
1895: -- and return to the calling side.
1896: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
1897: IF (g_level_procedure >= g_current_runtime_level ) THEN
1898: FND_LOG.STRING(g_level_procedure,
1899: g_module_name||'.'||l_procedure_name||'.END',
1900: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1901: END IF;
1902: RETURN;

Line 1923: FND_LOG.STRING(g_level_statement,

1919: );
1920:
1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1922: IF (g_level_statement >= g_current_runtime_level ) THEN
1923: FND_LOG.STRING(g_level_statement,
1924: g_module_name||'.'||l_procedure_name,
1925: 'Incorrect return_status after calling ' ||
1926: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1927: FND_LOG.STRING(g_level_statement,

Line 1927: FND_LOG.STRING(g_level_statement,

1923: FND_LOG.STRING(g_level_statement,
1924: g_module_name||'.'||l_procedure_name,
1925: 'Incorrect return_status after calling ' ||
1926: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1927: FND_LOG.STRING(g_level_statement,
1928: g_module_name||'.'||l_procedure_name,
1929: 'RETURN_STATUS = ' || x_return_status);
1930: FND_LOG.STRING(g_level_statement,
1931: g_module_name||'.'||l_procedure_name||'.END',

Line 1930: FND_LOG.STRING(g_level_statement,

1926: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
1927: FND_LOG.STRING(g_level_statement,
1928: g_module_name||'.'||l_procedure_name,
1929: 'RETURN_STATUS = ' || x_return_status);
1930: FND_LOG.STRING(g_level_statement,
1931: g_module_name||'.'||l_procedure_name||'.END',
1932: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1933: END IF;
1934: RETURN;

Line 1941: FND_LOG.STRING(g_level_procedure,

1937: -- if valid tax rate info found, then set the jurisdiction
1938: -- and return to the calling side.
1939: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
1940: IF (g_level_procedure >= g_current_runtime_level ) THEN
1941: FND_LOG.STRING(g_level_procedure,
1942: g_module_name||'.'||l_procedure_name||'.END',
1943: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1944: END IF;
1945: RETURN;

Line 1965: FND_LOG.STRING(g_level_statement,

1961: x_return_status => x_return_status
1962: );
1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: IF (g_level_statement >= g_current_runtime_level ) THEN
1965: FND_LOG.STRING(g_level_statement,
1966: g_module_name||'.'||l_procedure_name,
1967: 'Incorrect return_status after calling ' ||
1968: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
1969: FND_LOG.STRING(g_level_statement,

Line 1969: FND_LOG.STRING(g_level_statement,

1965: FND_LOG.STRING(g_level_statement,
1966: g_module_name||'.'||l_procedure_name,
1967: 'Incorrect return_status after calling ' ||
1968: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
1969: FND_LOG.STRING(g_level_statement,
1970: g_module_name||'.'||l_procedure_name,
1971: 'RETURN_STATUS = ' || x_return_status);
1972: FND_LOG.STRING(g_level_statement,
1973: g_module_name||'.'||l_procedure_name||'.END',

Line 1972: FND_LOG.STRING(g_level_statement,

1968: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
1969: FND_LOG.STRING(g_level_statement,
1970: g_module_name||'.'||l_procedure_name,
1971: 'RETURN_STATUS = ' || x_return_status);
1972: FND_LOG.STRING(g_level_statement,
1973: g_module_name||'.'||l_procedure_name||'.END',
1974: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-)');
1975: END IF;
1976: RETURN;

Line 1989: FND_LOG.STRING(g_level_statement,

1985: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
1986: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
1987:
1988: IF (g_level_statement >= g_current_runtime_level) THEN
1989: FND_LOG.STRING(g_level_statement,
1990: g_module_name||'.'||l_procedure_name,
1991: 'No rate found for tax rate code: ' ||p_tax_rate_code);
1992: END IF;
1993: END IF;

Line 1996: FND_LOG.STRING(g_level_procedure,

1992: END IF;
1993: END IF;
1994:
1995: IF (g_level_procedure >= g_current_runtime_level ) THEN
1996: FND_LOG.STRING(g_level_procedure,
1997: g_module_name||'.'||l_procedure_name||'.END',
1998: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
1999: END IF;
2000:

Line 2005: FND_LOG.STRING(g_level_unexpected,

2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2005: FND_LOG.STRING(g_level_unexpected,
2006: g_module_name||'.'||l_procedure_name,
2007: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2008: FND_LOG.STRING(g_level_unexpected,
2009: g_module_name||'.'||l_procedure_name||'.END',

Line 2008: FND_LOG.STRING(g_level_unexpected,

2004: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2005: FND_LOG.STRING(g_level_unexpected,
2006: g_module_name||'.'||l_procedure_name,
2007: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2008: FND_LOG.STRING(g_level_unexpected,
2009: g_module_name||'.'||l_procedure_name||'.END',
2010: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt(-) ');
2011: END IF;
2012: END get_tax_rate_pvt;

Line 2040: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2036: l_procedure_name CONSTANT VARCHAR2(30) := 'get_def_tax_rate_pvt';
2037:
2038: BEGIN
2039:
2040: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2041:
2042: IF (g_level_procedure >= g_current_runtime_level ) THEN
2043: FND_LOG.STRING(g_level_procedure,
2044: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 2043: FND_LOG.STRING(g_level_procedure,

2039:
2040: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2041:
2042: IF (g_level_procedure >= g_current_runtime_level ) THEN
2043: FND_LOG.STRING(g_level_procedure,
2044: g_module_name||'.'||l_procedure_name||'.BEGIN',
2045: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(+) ');
2046: END IF;
2047:

Line 2051: FND_LOG.STRING(g_level_statement,

2047:
2048: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2049:
2050: IF (g_level_statement >= g_current_runtime_level ) THEN
2051: FND_LOG.STRING(g_level_statement,
2052: g_module_name||'.'||l_procedure_name,
2053: 'p_multiple_jurisdictions_flag: '
2054: || p_multiple_jurisdictions_flag);
2055: END IF;

Line 2072: FND_LOG.STRING(g_level_statement,

2068: );
2069:
2070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2071: IF (g_level_statement >= g_current_runtime_level ) THEN
2072: FND_LOG.STRING(g_level_statement,
2073: g_module_name||'.'||l_procedure_name,
2074: 'Incorrect return_status after calling ' ||
2075: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');
2076: FND_LOG.STRING(g_level_statement,

Line 2076: FND_LOG.STRING(g_level_statement,

2072: FND_LOG.STRING(g_level_statement,
2073: g_module_name||'.'||l_procedure_name,
2074: 'Incorrect return_status after calling ' ||
2075: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');
2076: FND_LOG.STRING(g_level_statement,
2077: g_module_name||'.'||l_procedure_name,
2078: 'RETURN_STATUS = ' || x_return_status);
2079: FND_LOG.STRING(g_level_statement,
2080: g_module_name||'.'||l_procedure_name||'.END',

Line 2079: FND_LOG.STRING(g_level_statement,

2075: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_gt');
2076: FND_LOG.STRING(g_level_statement,
2077: g_module_name||'.'||l_procedure_name,
2078: 'RETURN_STATUS = ' || x_return_status);
2079: FND_LOG.STRING(g_level_statement,
2080: g_module_name||'.'||l_procedure_name||'.END',
2081: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2082: END IF;
2083: RETURN;

Line 2089: FND_LOG.STRING(g_level_procedure,

2085:
2086: -- if valid tax rate info found, return to the calling side.
2087: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2088: IF (g_level_procedure >= g_current_runtime_level ) THEN
2089: FND_LOG.STRING(g_level_procedure,
2090: g_module_name||'.'||l_procedure_name||'.END',
2091: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2092: END IF;
2093: RETURN;

Line 2115: FND_LOG.STRING(g_level_statement,

2111: );
2112:
2113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2114: IF (g_level_statement >= g_current_runtime_level ) THEN
2115: FND_LOG.STRING(g_level_statement,
2116: g_module_name||'.'||l_procedure_name,
2117: 'Incorrect return_status after calling ' ||
2118: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
2119: FND_LOG.STRING(g_level_statement,

Line 2119: FND_LOG.STRING(g_level_statement,

2115: FND_LOG.STRING(g_level_statement,
2116: g_module_name||'.'||l_procedure_name,
2117: 'Incorrect return_status after calling ' ||
2118: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
2119: FND_LOG.STRING(g_level_statement,
2120: g_module_name||'.'||l_procedure_name,
2121: 'RETURN_STATUS = ' || x_return_status);
2122: FND_LOG.STRING(g_level_statement,
2123: g_module_name||'.'||l_procedure_name||'.END',

Line 2122: FND_LOG.STRING(g_level_statement,

2118: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_by_jur_code');
2119: FND_LOG.STRING(g_level_statement,
2120: g_module_name||'.'||l_procedure_name,
2121: 'RETURN_STATUS = ' || x_return_status);
2122: FND_LOG.STRING(g_level_statement,
2123: g_module_name||'.'||l_procedure_name||'.END',
2124: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2125: END IF;
2126: RETURN;

Line 2132: FND_LOG.STRING(g_level_procedure,

2128:
2129: -- if valid tax rate info found, return to the calling side.
2130: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2131: IF (g_level_procedure >= g_current_runtime_level ) THEN
2132: FND_LOG.STRING(g_level_procedure,
2133: g_module_name||'.'||l_procedure_name||'.END',
2134: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2135: END IF;
2136: RETURN;

Line 2154: FND_LOG.STRING(g_level_statement,

2150: x_return_status => x_return_status
2151: );
2152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2153: IF (g_level_statement >= g_current_runtime_level ) THEN
2154: FND_LOG.STRING(g_level_statement,
2155: g_module_name||'.'||l_procedure_name,
2156: 'Incorrect return_status after calling ' ||
2157: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
2158: FND_LOG.STRING(g_level_statement,

Line 2158: FND_LOG.STRING(g_level_statement,

2154: FND_LOG.STRING(g_level_statement,
2155: g_module_name||'.'||l_procedure_name,
2156: 'Incorrect return_status after calling ' ||
2157: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
2158: FND_LOG.STRING(g_level_statement,
2159: g_module_name||'.'||l_procedure_name,
2160: 'RETURN_STATUS = ' || x_return_status);
2161: FND_LOG.STRING(g_level_statement,
2162: g_module_name||'.'||l_procedure_name||'.END',

Line 2161: FND_LOG.STRING(g_level_statement,

2157: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_no_jur_code');
2158: FND_LOG.STRING(g_level_statement,
2159: g_module_name||'.'||l_procedure_name,
2160: 'RETURN_STATUS = ' || x_return_status);
2161: FND_LOG.STRING(g_level_statement,
2162: g_module_name||'.'||l_procedure_name||'.END',
2163: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-)');
2164: END IF;
2165: RETURN;

Line 2180: FND_LOG.STRING(g_level_statement,

2176: FND_MESSAGE.SET_TOKEN('TAX',p_tax);
2177: FND_MESSAGE.SET_TOKEN('TAX_DET_DATE',p_tax_date);
2178:
2179: IF (g_level_statement >= g_current_runtime_level) THEN
2180: FND_LOG.STRING(g_level_statement,
2181: g_module_name||'.'||l_procedure_name,
2182: 'No default rate found for tax rate code');
2183: END IF;
2184: END IF;

Line 2187: FND_LOG.STRING(g_level_procedure,

2183: END IF;
2184: END IF;
2185:
2186: IF (g_level_procedure >= g_current_runtime_level ) THEN
2187: FND_LOG.STRING(g_level_procedure,
2188: g_module_name||'.'||l_procedure_name||'.END',
2189: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2190: END IF;
2191:

Line 2196: FND_LOG.STRING(g_level_unexpected,

2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2195: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2196: FND_LOG.STRING(g_level_unexpected,
2197: g_module_name||'.'||l_procedure_name,
2198: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2199: FND_LOG.STRING(g_level_unexpected,
2200: g_module_name||'.'||l_procedure_name||'.END',

Line 2199: FND_LOG.STRING(g_level_unexpected,

2195: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2196: FND_LOG.STRING(g_level_unexpected,
2197: g_module_name||'.'||l_procedure_name,
2198: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2199: FND_LOG.STRING(g_level_unexpected,
2200: g_module_name||'.'||l_procedure_name||'.END',
2201: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt(-) ');
2202: END IF;
2203:

Line 2233: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2229: l_count_jur NUMBER;
2230: l_tax_class VARCHAR2(30);
2231: l_tbl_index BINARY_INTEGER;
2232: BEGIN
2233: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2234:
2235: IF (g_level_procedure >= g_current_runtime_level ) THEN
2236: FND_LOG.STRING(g_level_procedure,
2237: g_module_name||'.'||l_procedure_name||'.BEGIN',

Line 2236: FND_LOG.STRING(g_level_procedure,

2232: BEGIN
2233: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2234:
2235: IF (g_level_procedure >= g_current_runtime_level ) THEN
2236: FND_LOG.STRING(g_level_procedure,
2237: g_module_name||'.'||l_procedure_name||'.BEGIN',
2238: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(+) ');
2239: END IF;
2240:

Line 2244: FND_LOG.STRING(g_level_statement,

2240:
2241: x_return_status:= FND_API.G_RET_STS_SUCCESS;
2242:
2243: IF (g_level_statement >= g_current_runtime_level ) THEN
2244: FND_LOG.STRING(g_level_statement,
2245: g_module_name||'.'||l_procedure_name,
2246: 'p_tax = ' || p_tax);
2247: FND_LOG.STRING(g_level_statement,
2248: g_module_name||'.'||l_procedure_name,

Line 2247: FND_LOG.STRING(g_level_statement,

2243: IF (g_level_statement >= g_current_runtime_level ) THEN
2244: FND_LOG.STRING(g_level_statement,
2245: g_module_name||'.'||l_procedure_name,
2246: 'p_tax = ' || p_tax);
2247: FND_LOG.STRING(g_level_statement,
2248: g_module_name||'.'||l_procedure_name,
2249: 'p_tax_status_code = ' || p_tax_status_code);
2250: FND_LOG.STRING(g_level_statement,
2251: g_module_name||'.'||l_procedure_name,

Line 2250: FND_LOG.STRING(g_level_statement,

2246: 'p_tax = ' || p_tax);
2247: FND_LOG.STRING(g_level_statement,
2248: g_module_name||'.'||l_procedure_name,
2249: 'p_tax_status_code = ' || p_tax_status_code);
2250: FND_LOG.STRING(g_level_statement,
2251: g_module_name||'.'||l_procedure_name,
2252: 'p_tax_regime_code = ' || p_tax_regime_code);
2253: FND_LOG.STRING(g_level_statement,
2254: g_module_name||'.'||l_procedure_name,

Line 2253: FND_LOG.STRING(g_level_statement,

2249: 'p_tax_status_code = ' || p_tax_status_code);
2250: FND_LOG.STRING(g_level_statement,
2251: g_module_name||'.'||l_procedure_name,
2252: 'p_tax_regime_code = ' || p_tax_regime_code);
2253: FND_LOG.STRING(g_level_statement,
2254: g_module_name||'.'||l_procedure_name,
2255: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code);
2256: FND_LOG.STRING(g_level_statement,
2257: g_module_name||'.'||l_procedure_name,

Line 2256: FND_LOG.STRING(g_level_statement,

2252: 'p_tax_regime_code = ' || p_tax_regime_code);
2253: FND_LOG.STRING(g_level_statement,
2254: g_module_name||'.'||l_procedure_name,
2255: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code);
2256: FND_LOG.STRING(g_level_statement,
2257: g_module_name||'.'||l_procedure_name,
2258: 'p_tax_date = ' || p_tax_date);
2259: END IF;
2260:

Line 2290: FND_LOG.STRING(g_level_statement,

2286: x_return_status => x_return_status
2287: );
2288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2289: IF (g_level_statement >= g_current_runtime_level ) THEN
2290: FND_LOG.STRING(g_level_statement,
2291: g_module_name||'.'||l_procedure_name,
2292: 'Incorrect return_status after calling ' ||
2293: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');
2294: FND_LOG.STRING(g_level_statement,

Line 2294: FND_LOG.STRING(g_level_statement,

2290: FND_LOG.STRING(g_level_statement,
2291: g_module_name||'.'||l_procedure_name,
2292: 'Incorrect return_status after calling ' ||
2293: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');
2294: FND_LOG.STRING(g_level_statement,
2295: g_module_name||'.'||l_procedure_name,
2296: 'RETURN_STATUS = ' || x_return_status);
2297: FND_LOG.STRING(g_level_statement,
2298: g_module_name||'.'||l_procedure_name||'.END',

Line 2297: FND_LOG.STRING(g_level_statement,

2293: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_internal');
2294: FND_LOG.STRING(g_level_statement,
2295: g_module_name||'.'||l_procedure_name,
2296: 'RETURN_STATUS = ' || x_return_status);
2297: FND_LOG.STRING(g_level_statement,
2298: g_module_name||'.'||l_procedure_name||'.END',
2299: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2300: END IF;
2301: RETURN;

Line 2333: FND_LOG.STRING(g_level_statement,

2329: );
2330:
2331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2332: IF (g_level_statement >= g_current_runtime_level ) THEN
2333: FND_LOG.STRING(g_level_statement,
2334: g_module_name||'.'||l_procedure_name,
2335: 'Incorrect return_status after calling ' ||
2336: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');
2337: FND_LOG.STRING(g_level_statement,

Line 2337: FND_LOG.STRING(g_level_statement,

2333: FND_LOG.STRING(g_level_statement,
2334: g_module_name||'.'||l_procedure_name,
2335: 'Incorrect return_status after calling ' ||
2336: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');
2337: FND_LOG.STRING(g_level_statement,
2338: g_module_name||'.'||l_procedure_name,
2339: 'RETURN_STATUS = ' || x_return_status);
2340: FND_LOG.STRING(g_level_statement,
2341: g_module_name||'.'||l_procedure_name||'.END',

Line 2340: FND_LOG.STRING(g_level_statement,

2336: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate_pvt');
2337: FND_LOG.STRING(g_level_statement,
2338: g_module_name||'.'||l_procedure_name,
2339: 'RETURN_STATUS = ' || x_return_status);
2340: FND_LOG.STRING(g_level_statement,
2341: g_module_name||'.'||l_procedure_name||'.END',
2342: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2343: END IF;
2344: -- lower level should assign the fnd msg stack

Line 2373: FND_LOG.STRING(g_level_statement,

2369: );
2370:
2371: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2372: IF (g_level_statement >= g_current_runtime_level ) THEN
2373: FND_LOG.STRING(g_level_statement,
2374: g_module_name||'.'||l_procedure_name,
2375: 'Incorrect return_status after calling ' ||
2376: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');
2377: FND_LOG.STRING(g_level_statement,

Line 2377: FND_LOG.STRING(g_level_statement,

2373: FND_LOG.STRING(g_level_statement,
2374: g_module_name||'.'||l_procedure_name,
2375: 'Incorrect return_status after calling ' ||
2376: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');
2377: FND_LOG.STRING(g_level_statement,
2378: g_module_name||'.'||l_procedure_name,
2379: 'RETURN_STATUS = ' || x_return_status);
2380: FND_LOG.STRING(g_level_statement,
2381: g_module_name||'.'||l_procedure_name||'.END',

Line 2380: FND_LOG.STRING(g_level_statement,

2376: 'ZX_TCM_TAX_RATE_PKG.get_def_tax_rate_pvt');
2377: FND_LOG.STRING(g_level_statement,
2378: g_module_name||'.'||l_procedure_name,
2379: 'RETURN_STATUS = ' || x_return_status);
2380: FND_LOG.STRING(g_level_statement,
2381: g_module_name||'.'||l_procedure_name||'.END',
2382: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-)');
2383: END IF;
2384: -- lower level should have set the fnd msg stack

Line 2393: FND_LOG.STRING(g_level_statement,

2389: -- found for the tax_rate_code returned from rule engine.
2390:
2391: IF x_tax_rate_rec.tax_rate_id IS NOT NULL THEN
2392: IF (g_level_statement >= g_current_runtime_level ) THEN
2393: FND_LOG.STRING(g_level_statement,
2394: g_module_name||'.'||l_procedure_name,
2395: 'tax_rate_code = ' || x_tax_rate_rec.tax_rate_code);
2396: FND_LOG.STRING(g_level_statement,
2397: g_module_name||'.'||l_procedure_name,

Line 2396: FND_LOG.STRING(g_level_statement,

2392: IF (g_level_statement >= g_current_runtime_level ) THEN
2393: FND_LOG.STRING(g_level_statement,
2394: g_module_name||'.'||l_procedure_name,
2395: 'tax_rate_code = ' || x_tax_rate_rec.tax_rate_code);
2396: FND_LOG.STRING(g_level_statement,
2397: g_module_name||'.'||l_procedure_name,
2398: 'tax_rate_id = ' || x_tax_rate_rec.tax_rate_id);
2399: FND_LOG.STRING(g_level_statement,
2400: g_module_name||'.'||l_procedure_name,

Line 2399: FND_LOG.STRING(g_level_statement,

2395: 'tax_rate_code = ' || x_tax_rate_rec.tax_rate_code);
2396: FND_LOG.STRING(g_level_statement,
2397: g_module_name||'.'||l_procedure_name,
2398: 'tax_rate_id = ' || x_tax_rate_rec.tax_rate_id);
2399: FND_LOG.STRING(g_level_statement,
2400: g_module_name||'.'||l_procedure_name,
2401: 'rate_type = ' || x_tax_rate_rec.rate_type_code);
2402: FND_LOG.STRING(g_level_statement,
2403: g_module_name||'.'||l_procedure_name,

Line 2402: FND_LOG.STRING(g_level_statement,

2398: 'tax_rate_id = ' || x_tax_rate_rec.tax_rate_id);
2399: FND_LOG.STRING(g_level_statement,
2400: g_module_name||'.'||l_procedure_name,
2401: 'rate_type = ' || x_tax_rate_rec.rate_type_code);
2402: FND_LOG.STRING(g_level_statement,
2403: g_module_name||'.'||l_procedure_name,
2404: 'percentage_rate = ' || x_tax_rate_rec.percentage_rate);
2405: FND_LOG.STRING(g_level_statement,
2406: g_module_name||'.'||l_procedure_name,

Line 2405: FND_LOG.STRING(g_level_statement,

2401: 'rate_type = ' || x_tax_rate_rec.rate_type_code);
2402: FND_LOG.STRING(g_level_statement,
2403: g_module_name||'.'||l_procedure_name,
2404: 'percentage_rate = ' || x_tax_rate_rec.percentage_rate);
2405: FND_LOG.STRING(g_level_statement,
2406: g_module_name||'.'||l_procedure_name,
2407: 'quantity_rate = ' || x_tax_rate_rec.quantity_rate);
2408: FND_LOG.STRING(g_level_statement,
2409: g_module_name||'.'||l_procedure_name,

Line 2408: FND_LOG.STRING(g_level_statement,

2404: 'percentage_rate = ' || x_tax_rate_rec.percentage_rate);
2405: FND_LOG.STRING(g_level_statement,
2406: g_module_name||'.'||l_procedure_name,
2407: 'quantity_rate = ' || x_tax_rate_rec.quantity_rate);
2408: FND_LOG.STRING(g_level_statement,
2409: g_module_name||'.'||l_procedure_name,
2410: 'allow_adhoc_tax_rate_flag = ' || x_tax_rate_rec.allow_adhoc_tax_rate_flag);
2411: FND_LOG.STRING(g_level_statement,
2412: g_module_name||'.'||l_procedure_name,

Line 2411: FND_LOG.STRING(g_level_statement,

2407: 'quantity_rate = ' || x_tax_rate_rec.quantity_rate);
2408: FND_LOG.STRING(g_level_statement,
2409: g_module_name||'.'||l_procedure_name,
2410: 'allow_adhoc_tax_rate_flag = ' || x_tax_rate_rec.allow_adhoc_tax_rate_flag);
2411: FND_LOG.STRING(g_level_statement,
2412: g_module_name||'.'||l_procedure_name,
2413: 'uom_code = ' || x_tax_rate_rec.uom_code);
2414: FND_LOG.STRING(g_level_statement,
2415: g_module_name||'.'||l_procedure_name,

Line 2414: FND_LOG.STRING(g_level_statement,

2410: 'allow_adhoc_tax_rate_flag = ' || x_tax_rate_rec.allow_adhoc_tax_rate_flag);
2411: FND_LOG.STRING(g_level_statement,
2412: g_module_name||'.'||l_procedure_name,
2413: 'uom_code = ' || x_tax_rate_rec.uom_code);
2414: FND_LOG.STRING(g_level_statement,
2415: g_module_name||'.'||l_procedure_name,
2416: 'offset_tax_rate_code = ' || x_tax_rate_rec.offset_tax_rate_code);
2417: END IF;
2418: END IF;

Line 2434: FND_LOG.STRING(g_level_procedure,

2430:
2431: ZX_TDS_UTILITIES_PKG.g_tax_rate_info_ind_by_hash(l_tbl_index) := x_tax_rate_rec;
2432:
2433: IF (g_level_procedure >= g_current_runtime_level ) THEN
2434: FND_LOG.STRING(g_level_procedure,
2435: g_module_name||'.'||l_procedure_name||'.END',
2436: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');
2437: END IF;
2438:

Line 2443: FND_LOG.STRING(g_level_unexpected,

2439: EXCEPTION
2440: WHEN OTHERS THEN
2441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2442: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2443: FND_LOG.STRING(g_level_unexpected,
2444: g_module_name||'.'||l_procedure_name,
2445: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2446: FND_LOG.STRING(g_level_unexpected,
2447: g_module_name||'.'||l_procedure_name||'.END',

Line 2446: FND_LOG.STRING(g_level_unexpected,

2442: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2443: FND_LOG.STRING(g_level_unexpected,
2444: g_module_name||'.'||l_procedure_name,
2445: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2446: FND_LOG.STRING(g_level_unexpected,
2447: g_module_name||'.'||l_procedure_name||'.END',
2448: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate(-) ');
2449: END IF;
2450: