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

APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on FND_LOG

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

76:
77: -- End: Bug 4959835
78:
79: g_current_runtime_level NUMBER;
80: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
81: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
82: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
83: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
84: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

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

77: -- End: Bug 4959835
78:
79: g_current_runtime_level NUMBER;
80: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
81: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
82: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
83: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
84: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
85:

Line 82: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

78:
79: g_current_runtime_level NUMBER;
80: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
81: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
82: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
83: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
84: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
85:
86: -- cache the most inner and outer jurisdiction

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

79: g_current_runtime_level NUMBER;
80: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
81: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
82: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
83: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
84: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
85:
86: -- cache the most inner and outer jurisdiction
87: g_inner_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;

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

80: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
81: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
82: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
83: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
84: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
85:
86: -- cache the most inner and outer jurisdiction
87: g_inner_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
88: g_inner_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;

Line 117: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

113: x_return_status OUT NOCOPY VARCHAR2) IS
114:
115: BEGIN
116:
117: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
118:
119: IF (g_level_statement >= g_current_runtime_level ) THEN
120: FND_LOG.STRING(g_level_statement,
121: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date.BEGIN',

Line 120: FND_LOG.STRING(g_level_statement,

116:
117: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
118:
119: IF (g_level_statement >= g_current_runtime_level ) THEN
120: FND_LOG.STRING(g_level_statement,
121: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date.BEGIN',
122: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(+)');
123: END IF;
124:

Line 148: FND_LOG.STRING(g_level_procedure,

144: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_date(p_trx_line_index),
145: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_date(p_trx_line_index)))));
146:
147: IF (g_level_procedure >= g_current_runtime_level ) THEN
148: FND_LOG.STRING(g_level_procedure,
149: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(-)',
150: 'Tax date = ' || to_char(x_tax_date, 'DD-MON-YY')||'Tax determine date = ' || to_char(x_tax_determine_date, 'DD-MON-YY')||'Tax point date = ' || to_char(x_tax_point_date, 'DD-MON-YY'));
151: END IF;
152:

Line 161: FND_LOG.STRING(g_level_unexpected,

157: x_tax_point_date := NULL;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159:
160: IF (g_level_unexpected >= g_current_runtime_level ) THEN
161: FND_LOG.STRING(g_level_unexpected,
162: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date',
163: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
164: FND_LOG.STRING(g_level_unexpected,
165: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date.END',

Line 164: FND_LOG.STRING(g_level_unexpected,

160: IF (g_level_unexpected >= g_current_runtime_level ) THEN
161: FND_LOG.STRING(g_level_unexpected,
162: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date',
163: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
164: FND_LOG.STRING(g_level_unexpected,
165: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date.END',
166: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date(-)');
167: END IF;
168:

Line 309: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

305: ORDER BY regime.regime_precedence;
306:
307: BEGIN
308:
309: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
310:
311: IF (g_level_procedure >= g_current_runtime_level ) THEN
312: FND_LOG.STRING(g_level_procedure,
313: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.BEGIN',

Line 312: FND_LOG.STRING(g_level_procedure,

308:
309: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
310:
311: IF (g_level_procedure >= g_current_runtime_level ) THEN
312: FND_LOG.STRING(g_level_procedure,
313: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.BEGIN',
314: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(+)');
315: END IF;
316:

Line 326: FND_LOG.STRING(g_level_error,

322: -- Validations
323: IF p_event_class_rec.det_factor_templ_code IS NULL THEN
324:
325: IF (g_level_error >= g_current_runtime_level ) THEN
326: FND_LOG.STRING(g_level_error,
327: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
328: 'Event Class does not contain Regime Template');
329: END IF;
330:

Line 372: FND_LOG.STRING(g_level_statement,

368: IF NVL(x_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
369: THEN
370:
371: IF (g_level_statement >= g_current_runtime_level ) THEN
372: FND_LOG.STRING(g_level_statement,
373: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
374: 'The value of return_status is not ''S'' after calling '||
375: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
376: FND_LOG.STRING(g_level_statement,

Line 376: FND_LOG.STRING(g_level_statement,

372: FND_LOG.STRING(g_level_statement,
373: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
374: 'The value of return_status is not ''S'' after calling '||
375: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
376: FND_LOG.STRING(g_level_statement,
377: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
378: 'RETURN_STATUS = ' || x_return_status);
379: FND_LOG.STRING(g_level_statement,
380: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 379: FND_LOG.STRING(g_level_statement,

375: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
376: FND_LOG.STRING(g_level_statement,
377: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
378: 'RETURN_STATUS = ' || x_return_status);
379: FND_LOG.STRING(g_level_statement,
380: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
381: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
382: END IF;
383: RETURN;

Line 413: FND_LOG.STRING(g_level_statement,

409: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
410: THEN
411:
412: IF (g_level_statement >= g_current_runtime_level ) THEN
413: FND_LOG.STRING(g_level_statement,
414: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
415: 'Incorrect return_status after calling '||
416: 'ZX_TCM_CONTROL_PKG.get_location_country');
417: FND_LOG.STRING(g_level_statement,

Line 417: FND_LOG.STRING(g_level_statement,

413: FND_LOG.STRING(g_level_statement,
414: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
415: 'Incorrect return_status after calling '||
416: 'ZX_TCM_CONTROL_PKG.get_location_country');
417: FND_LOG.STRING(g_level_statement,
418: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
419: 'RETURN_STATUS = ' || x_return_status);
420: FND_LOG.STRING(g_level_statement,
421: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 420: FND_LOG.STRING(g_level_statement,

416: 'ZX_TCM_CONTROL_PKG.get_location_country');
417: FND_LOG.STRING(g_level_statement,
418: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
419: 'RETURN_STATUS = ' || x_return_status);
420: FND_LOG.STRING(g_level_statement,
421: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
422: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
423: END IF;
424: --

Line 484: FND_LOG.STRING(g_level_statement,

480: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
481:
482: */
483: IF (g_level_statement >= g_current_runtime_level ) THEN
484: FND_LOG.STRING(g_level_statement,
485: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
486: 'No Country Code defined for the location: '|| l_location_id);
487: END IF;
488:

Line 565: FND_LOG.STRING(g_level_error,

561: x_return_status);
562:
563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
564: IF (g_level_error >= g_current_runtime_level ) THEN
565: FND_LOG.STRING(g_level_error,
566: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
567: 'Incorrect return_status after calling ' ||
568: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
569: FND_LOG.STRING(g_level_error,

Line 569: FND_LOG.STRING(g_level_error,

565: FND_LOG.STRING(g_level_error,
566: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
567: 'Incorrect return_status after calling ' ||
568: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
569: FND_LOG.STRING(g_level_error,
570: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
571: 'RETURN_STATUS = ' || x_return_status);
572: FND_LOG.STRING(g_level_error,
573: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 572: FND_LOG.STRING(g_level_error,

568: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_date()');
569: FND_LOG.STRING(g_level_error,
570: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
571: 'RETURN_STATUS = ' || x_return_status);
572: FND_LOG.STRING(g_level_error,
573: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
574: 'ZX_TDS_CALC_SERVICES_PUB_PKG.calculate_tax(-)');
575: END IF;
576: RETURN;

Line 620: FND_LOG.STRING(g_level_error,

616: x_return_status );
617:
618: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
619: IF (g_level_error >= g_current_runtime_level ) THEN
620: FND_LOG.STRING(g_level_error,
621: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
622: 'Incorrect return_status after calling ' ||
623: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
624: FND_LOG.STRING(g_level_error,

Line 624: FND_LOG.STRING(g_level_error,

620: FND_LOG.STRING(g_level_error,
621: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
622: 'Incorrect return_status after calling ' ||
623: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
624: FND_LOG.STRING(g_level_error,
625: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
626: 'RETURN_STATUS = ' || x_return_status);
627: FND_LOG.STRING(g_level_error,
628: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 627: FND_LOG.STRING(g_level_error,

623: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
624: FND_LOG.STRING(g_level_error,
625: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
626: 'RETURN_STATUS = ' || x_return_status);
627: FND_LOG.STRING(g_level_error,
628: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
629: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
630: END IF;
631:

Line 686: FND_LOG.STRING(g_level_error,

682: x_return_status );
683:
684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
685: IF (g_level_error >= g_current_runtime_level ) THEN
686: FND_LOG.STRING(g_level_error,
687: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
688: 'Incorrect return_status after calling ' ||
689: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
690: FND_LOG.STRING(g_level_error,

Line 690: FND_LOG.STRING(g_level_error,

686: FND_LOG.STRING(g_level_error,
687: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
688: 'Incorrect return_status after calling ' ||
689: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
690: FND_LOG.STRING(g_level_error,
691: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
692: 'RETURN_STATUS = ' || x_return_status);
693: FND_LOG.STRING(g_level_error,
694: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 693: FND_LOG.STRING(g_level_error,

689: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
690: FND_LOG.STRING(g_level_error,
691: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
692: 'RETURN_STATUS = ' || x_return_status);
693: FND_LOG.STRING(g_level_error,
694: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
695: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
696: END IF;
697:

Line 717: FND_LOG.STRING(g_level_statement,

713: IF ((NVL(l_country_tab.COUNT, 0) > 0 OR NVL(l_geography_tab.count, 0) > 0) AND
714: NVL(ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.COUNT, 0) = 0) THEN
715: -- x_return_status := FND_API.G_RET_STS_ERROR;
716: IF (g_level_statement >= g_current_runtime_level ) THEN
717: FND_LOG.STRING(g_level_statement,
718: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
719: 'No Applicable Regimes');
720: FND_LOG.STRING(g_level_statement,
721: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 720: FND_LOG.STRING(g_level_statement,

716: IF (g_level_statement >= g_current_runtime_level ) THEN
717: FND_LOG.STRING(g_level_statement,
718: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
719: 'No Applicable Regimes');
720: FND_LOG.STRING(g_level_statement,
721: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
722: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
723: END IF;
724: RETURN;

Line 728: FND_LOG.STRING(g_level_statement,

724: RETURN;
725: END IF;
726:
727: IF (g_level_statement >= g_current_runtime_level ) THEN
728: FND_LOG.STRING(g_level_statement,
729: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
730: 'Count for distinct Countries is: '||
731: NVL( l_country_tab.COUNT,0));
732: END IF;

Line 735: FND_LOG.STRING(g_level_procedure,

731: NVL( l_country_tab.COUNT,0));
732: END IF;
733:
734: IF (g_level_procedure >= g_current_runtime_level ) THEN
735: FND_LOG.STRING(g_level_procedure,
736: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
737: 'Count for applicable regimes is: '||
738: nvl(ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.COUNT,0));
739: END IF;

Line 742: FND_LOG.STRING(g_level_procedure,

738: nvl(ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.COUNT,0));
739: END IF;
740:
741: IF (g_level_procedure >= g_current_runtime_level ) THEN
742: FND_LOG.STRING(g_level_procedure,
743: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
744: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
745: END IF;
746:

Line 752: FND_LOG.STRING(g_level_unexpected,

748: WHEN OTHERS THEN
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750:
751: IF (g_level_unexpected >= g_current_runtime_level ) THEN
752: FND_LOG.STRING(g_level_unexpected,
753: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
754: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
755: FND_LOG.STRING(g_level_unexpected,
756: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 755: FND_LOG.STRING(g_level_unexpected,

751: IF (g_level_unexpected >= g_current_runtime_level ) THEN
752: FND_LOG.STRING(g_level_unexpected,
753: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
754: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
755: FND_LOG.STRING(g_level_unexpected,
756: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
757: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
758: END IF;
759:

Line 823: FND_LOG.STRING(g_level_unexpected,

819: WHEN OTHERS THEN
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821:
822: IF (g_level_unexpected >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_unexpected,
824: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime',
825: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
826: FND_LOG.STRING(g_level_unexpected,
827: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime.END',

Line 826: FND_LOG.STRING(g_level_unexpected,

822: IF (g_level_unexpected >= g_current_runtime_level ) THEN
823: FND_LOG.STRING(g_level_unexpected,
824: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime',
825: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
826: FND_LOG.STRING(g_level_unexpected,
827: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime.END',
828: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime(-)');
829: END IF;
830:

Line 870: FND_LOG.STRING(g_level_procedure,

866:
867: BEGIN
868:
869: IF (g_level_procedure >= g_current_runtime_level ) THEN
870: FND_LOG.STRING(g_level_procedure,
871: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable.BEGIN',
872: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable(+)');
873: END IF;
874:

Line 876: FND_LOG.STRING(g_level_statement,

872: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable(+)');
873: END IF;
874:
875: IF (g_level_statement >= g_current_runtime_level ) THEN
876: FND_LOG.STRING(g_level_statement,
877: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
878: 'l_applicability_rule_flag: '|| p_applicability_rule_flag);
879: END IF;
880:

Line 906: FND_LOG.STRING(g_level_statement,

902: x_return_status => x_return_status);
903:
904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: IF (g_level_statement >= g_current_runtime_level ) THEN
906: FND_LOG.STRING(g_level_statement,
907: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
908: 'Incorrect return_status after calling ' ||
909: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm');
910: FND_LOG.STRING(g_level_statement,

Line 910: FND_LOG.STRING(g_level_statement,

906: FND_LOG.STRING(g_level_statement,
907: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
908: 'Incorrect return_status after calling ' ||
909: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm');
910: FND_LOG.STRING(g_level_statement,
911: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
912: 'RETURN_STATUS = ' || x_return_status);
913: FND_LOG.STRING(g_level_statement,
914: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable.END',

Line 913: FND_LOG.STRING(g_level_statement,

909: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm');
910: FND_LOG.STRING(g_level_statement,
911: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
912: 'RETURN_STATUS = ' || x_return_status);
913: FND_LOG.STRING(g_level_statement,
914: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable.END',
915: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable(-)');
916: END IF;
917: RETURN FALSE;

Line 936: FND_LOG.STRING(g_level_statement,

932: ELSE
933: l_result := FALSE;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
935: IF (g_level_statement >= g_current_runtime_level ) THEN
936: FND_LOG.STRING(g_level_statement,
937: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
938: 'applicability_rule_flag = ' || p_applicability_rule_flag );
939: FND_LOG.STRING(g_level_statement,
940: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',

Line 939: FND_LOG.STRING(g_level_statement,

935: IF (g_level_statement >= g_current_runtime_level ) THEN
936: FND_LOG.STRING(g_level_statement,
937: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
938: 'applicability_rule_flag = ' || p_applicability_rule_flag );
939: FND_LOG.STRING(g_level_statement,
940: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
941: 'Error: The valid value for applicability_rule_flag ' ||
942: 'should be N or Y.');
943: END IF;

Line 947: FND_LOG.STRING(g_level_procedure,

943: END IF;
944: END IF;
945:
946: IF (g_level_procedure >= g_current_runtime_level ) THEN
947: FND_LOG.STRING(g_level_procedure,
948: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable.END',
949: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable(-)'||'return_status '||x_return_status);
950: END IF;
951:

Line 958: FND_LOG.STRING(g_level_unexpected,

954: EXCEPTION
955: WHEN OTHERS THEN
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: IF (g_level_unexpected >= g_current_runtime_level ) THEN
958: FND_LOG.STRING(g_level_unexpected,
959: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
960: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
961: FND_LOG.STRING(g_level_unexpected,
962: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable.END',

Line 961: FND_LOG.STRING(g_level_unexpected,

957: IF (g_level_unexpected >= g_current_runtime_level ) THEN
958: FND_LOG.STRING(g_level_unexpected,
959: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable',
960: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
961: FND_LOG.STRING(g_level_unexpected,
962: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable.END',
963: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable(-)');
964: END IF;
965: RETURN FALSE;

Line 1005: FND_LOG.STRING(g_level_procedure,

1001:
1002: BEGIN
1003:
1004: IF (g_level_procedure >= g_current_runtime_level ) THEN
1005: FND_LOG.STRING(g_level_procedure,
1006: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable.BEGIN',
1007: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable(+)');
1008: END IF;
1009:

Line 1031: FND_LOG.STRING(g_level_statement,

1027: l_error_buffer);
1028:
1029: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1030: IF (g_level_statement >= g_current_runtime_level ) THEN
1031: FND_LOG.STRING(g_level_statement,
1032: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable',
1033: 'Incorrect return_status after calling ' ||
1034: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');
1035: END IF;

Line 1041: FND_LOG.STRING(g_level_statement,

1037: x_direct_rate_result_rec := NULL;
1038: x_direct_rate_result_id := NULL;
1039:
1040: IF (g_level_statement >= g_current_runtime_level ) THEN
1041: FND_LOG.STRING(g_level_statement,
1042: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable',
1043: 'RETURN_STATUS = ' || x_return_status);
1044: END IF;
1045: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1046: FND_LOG.STRING(g_level_procedure,

1042: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable',
1043: 'RETURN_STATUS = ' || x_return_status);
1044: END IF;
1045: IF (g_level_procedure >= g_current_runtime_level ) THEN
1046: FND_LOG.STRING(g_level_procedure,
1047: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable.END',
1048: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable(-)');
1049: END IF;
1050: RETURN FALSE;

Line 1062: FND_LOG.STRING(g_level_statement,

1058: l_result := FALSE;
1059: END IF;
1060:
1061: IF (g_level_statement >= g_current_runtime_level ) THEN
1062: FND_LOG.STRING(g_level_statement,
1063: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable',
1064: 'RETURN_STATUS = ' || x_return_status);
1065: END IF;
1066:

Line 1068: FND_LOG.STRING(g_level_procedure,

1064: 'RETURN_STATUS = ' || x_return_status);
1065: END IF;
1066:
1067: IF (g_level_procedure >= g_current_runtime_level ) THEN
1068: FND_LOG.STRING(g_level_procedure,
1069: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable.END',
1070: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable(-)');
1071: END IF;
1072: RETURN l_result;

Line 1078: FND_LOG.STRING(g_level_unexpected,

1074: EXCEPTION
1075: WHEN OTHERS THEN
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1078: FND_LOG.STRING(g_level_unexpected,
1079: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable',
1080: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1081: FND_LOG.STRING(g_level_unexpected,
1082: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable.END',

Line 1081: FND_LOG.STRING(g_level_unexpected,

1077: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1078: FND_LOG.STRING(g_level_unexpected,
1079: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable',
1080: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1081: FND_LOG.STRING(g_level_unexpected,
1082: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable.END',
1083: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable(-)');
1084: END IF;
1085: RETURN FALSE;

Line 1238: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1234: l_self_assessed_flag_usr zx_lines.self_assessed_flag%TYPE;
1235:
1236: BEGIN
1237:
1238: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1239: IF (g_level_procedure >= g_current_runtime_level ) THEN
1240: FND_LOG.STRING(g_level_procedure,
1241: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.BEGIN',
1242: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(+)');

Line 1240: FND_LOG.STRING(g_level_procedure,

1236: BEGIN
1237:
1238: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1239: IF (g_level_procedure >= g_current_runtime_level ) THEN
1240: FND_LOG.STRING(g_level_procedure,
1241: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.BEGIN',
1242: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(+)');
1243: END IF;
1244:

Line 1281: FND_LOG.STRING(g_level_statement,

1277: p_error_buffer => l_error_buffer);
1278:
1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: IF (g_level_statement >= g_current_runtime_level ) THEN
1281: FND_LOG.STRING(g_level_statement,
1282: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1283: 'Incorrect return_status after calling ' ||
1284: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1285: FND_LOG.STRING(g_level_statement,

Line 1285: FND_LOG.STRING(g_level_statement,

1281: FND_LOG.STRING(g_level_statement,
1282: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1283: 'Incorrect return_status after calling ' ||
1284: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1285: FND_LOG.STRING(g_level_statement,
1286: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1287: 'RETURN_STATUS = ' || x_return_status);
1288: FND_LOG.STRING(g_level_statement,
1289: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1288: FND_LOG.STRING(g_level_statement,

1284: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1285: FND_LOG.STRING(g_level_statement,
1286: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1287: 'RETURN_STATUS = ' || x_return_status);
1288: FND_LOG.STRING(g_level_statement,
1289: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1290: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1291: END IF;
1292: RETURN;

Line 1393: FND_LOG.STRING(g_level_statement,

1389: p_error_buffer => l_error_buffer);
1390:
1391: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1392: IF (g_level_statement >= g_current_runtime_level ) THEN
1393: FND_LOG.STRING(g_level_statement,
1394: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1395: 'Incorrect return_status after calling ' ||
1396: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1397: FND_LOG.STRING(g_level_statement,

Line 1397: FND_LOG.STRING(g_level_statement,

1393: FND_LOG.STRING(g_level_statement,
1394: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1395: 'Incorrect return_status after calling ' ||
1396: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1397: FND_LOG.STRING(g_level_statement,
1398: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1399: 'RETURN_STATUS = ' || x_return_status);
1400: FND_LOG.STRING(g_level_statement,
1401: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1400: FND_LOG.STRING(g_level_statement,

1396: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1397: FND_LOG.STRING(g_level_statement,
1398: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1399: 'RETURN_STATUS = ' || x_return_status);
1400: FND_LOG.STRING(g_level_statement,
1401: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1402: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1403: END IF;
1404: RETURN;

Line 1482: FND_LOG.STRING(g_level_statement,

1478: x_return_status => x_return_status);
1479:
1480: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1481: IF (g_level_statement >= g_current_runtime_level ) THEN
1482: FND_LOG.STRING(g_level_statement,
1483: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1484: 'Incorrect return_status after calling ' ||
1485: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1486: FND_LOG.STRING(g_level_statement,

Line 1486: FND_LOG.STRING(g_level_statement,

1482: FND_LOG.STRING(g_level_statement,
1483: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1484: 'Incorrect return_status after calling ' ||
1485: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1486: FND_LOG.STRING(g_level_statement,
1487: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1488: 'RETURN_STATUS = ' || x_return_status);
1489: FND_LOG.STRING(g_level_statement,
1490: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1489: FND_LOG.STRING(g_level_statement,

1485: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1486: FND_LOG.STRING(g_level_statement,
1487: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1488: 'RETURN_STATUS = ' || x_return_status);
1489: FND_LOG.STRING(g_level_statement,
1490: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1491: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1492: END IF;
1493: RETURN;

Line 1544: FND_LOG.STRING(g_level_statement,

1540: p_error_buffer => l_error_buffer);
1541:
1542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1543: IF (g_level_statement >= g_current_runtime_level ) THEN
1544: FND_LOG.STRING(g_level_statement,
1545: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1546: 'Incorrect return_status after calling ' ||
1547: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1548: FND_LOG.STRING(g_level_statement,

Line 1548: FND_LOG.STRING(g_level_statement,

1544: FND_LOG.STRING(g_level_statement,
1545: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1546: 'Incorrect return_status after calling ' ||
1547: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1550: 'RETURN_STATUS = ' || x_return_status);
1551: FND_LOG.STRING(g_level_statement,
1552: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1551: FND_LOG.STRING(g_level_statement,

1547: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1548: FND_LOG.STRING(g_level_statement,
1549: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1550: 'RETURN_STATUS = ' || x_return_status);
1551: FND_LOG.STRING(g_level_statement,
1552: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1553: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1554: END IF;
1555: RETURN;

Line 1602: FND_LOG.STRING(g_level_statement,

1598: x_return_status => x_return_status);
1599:
1600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1601: IF (g_level_statement >= g_current_runtime_level ) THEN
1602: FND_LOG.STRING(g_level_statement,
1603: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1604: 'Incorrect return_status after calling ' ||
1605: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1606: FND_LOG.STRING(g_level_statement,

Line 1606: FND_LOG.STRING(g_level_statement,

1602: FND_LOG.STRING(g_level_statement,
1603: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1604: 'Incorrect return_status after calling ' ||
1605: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1606: FND_LOG.STRING(g_level_statement,
1607: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1608: 'RETURN_STATUS = ' || x_return_status);
1609: FND_LOG.STRING(g_level_statement,
1610: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1609: FND_LOG.STRING(g_level_statement,

1605: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1606: FND_LOG.STRING(g_level_statement,
1607: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1608: 'RETURN_STATUS = ' || x_return_status);
1609: FND_LOG.STRING(g_level_statement,
1610: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1611: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1612: END IF;
1613: RETURN;

Line 1647: FND_LOG.STRING(g_level_statement,

1643: p_error_buffer => l_error_buffer);
1644:
1645: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1646: IF (g_level_statement >= g_current_runtime_level ) THEN
1647: FND_LOG.STRING(g_level_statement,
1648: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1649: 'Incorrect return_status after calling ' ||
1650: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1651: FND_LOG.STRING(g_level_statement,

Line 1651: FND_LOG.STRING(g_level_statement,

1647: FND_LOG.STRING(g_level_statement,
1648: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1649: 'Incorrect return_status after calling ' ||
1650: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1651: FND_LOG.STRING(g_level_statement,
1652: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1653: 'RETURN_STATUS = ' || x_return_status);
1654: FND_LOG.STRING(g_level_statement,
1655: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1654: FND_LOG.STRING(g_level_statement,

1650: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1651: FND_LOG.STRING(g_level_statement,
1652: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1653: 'RETURN_STATUS = ' || x_return_status);
1654: FND_LOG.STRING(g_level_statement,
1655: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1656: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1657: END IF;
1658: RETURN;

Line 1705: FND_LOG.STRING(g_level_statement,

1701: x_return_status => x_return_status);
1702:
1703: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1704: IF (g_level_statement >= g_current_runtime_level ) THEN
1705: FND_LOG.STRING(g_level_statement,
1706: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1707: 'Incorrect return_status after calling ' ||
1708: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1709: FND_LOG.STRING(g_level_statement,

Line 1709: FND_LOG.STRING(g_level_statement,

1705: FND_LOG.STRING(g_level_statement,
1706: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1707: 'Incorrect return_status after calling ' ||
1708: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1709: FND_LOG.STRING(g_level_statement,
1710: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1711: 'RETURN_STATUS = ' || x_return_status);
1712: FND_LOG.STRING(g_level_statement,
1713: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1712: FND_LOG.STRING(g_level_statement,

1708: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1709: FND_LOG.STRING(g_level_statement,
1710: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1711: 'RETURN_STATUS = ' || x_return_status);
1712: FND_LOG.STRING(g_level_statement,
1713: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1714: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1715: END IF;
1716: RETURN;

Line 1750: FND_LOG.STRING(g_level_statement,

1746: p_error_buffer => l_error_buffer);
1747:
1748: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1749: IF (g_level_statement >= g_current_runtime_level ) THEN
1750: FND_LOG.STRING(g_level_statement,
1751: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1752: 'Incorrect return_status after calling ' ||
1753: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1754: FND_LOG.STRING(g_level_statement,

Line 1754: FND_LOG.STRING(g_level_statement,

1750: FND_LOG.STRING(g_level_statement,
1751: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1752: 'Incorrect return_status after calling ' ||
1753: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1754: FND_LOG.STRING(g_level_statement,
1755: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1756: 'RETURN_STATUS = ' || x_return_status);
1757: FND_LOG.STRING(g_level_statement,
1758: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1757: FND_LOG.STRING(g_level_statement,

1753: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache');
1754: FND_LOG.STRING(g_level_statement,
1755: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1756: 'RETURN_STATUS = ' || x_return_status);
1757: FND_LOG.STRING(g_level_statement,
1758: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1759: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1760: END IF;
1761: RETURN;

Line 1808: FND_LOG.STRING(g_level_statement,

1804: x_return_status => x_return_status);
1805:
1806: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1807: IF (g_level_statement >= g_current_runtime_level ) THEN
1808: FND_LOG.STRING(g_level_statement,
1809: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1810: 'Incorrect return_status after calling ' ||
1811: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1812: FND_LOG.STRING(g_level_statement,

Line 1812: FND_LOG.STRING(g_level_statement,

1808: FND_LOG.STRING(g_level_statement,
1809: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1810: 'Incorrect return_status after calling ' ||
1811: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1812: FND_LOG.STRING(g_level_statement,
1813: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1814: 'RETURN_STATUS = ' || x_return_status);
1815: FND_LOG.STRING(g_level_statement,
1816: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1815: FND_LOG.STRING(g_level_statement,

1811: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1812: FND_LOG.STRING(g_level_statement,
1813: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1814: 'RETURN_STATUS = ' || x_return_status);
1815: FND_LOG.STRING(g_level_statement,
1816: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1817: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1818: END IF;
1819: RETURN;

Line 1880: FND_LOG.STRING(g_level_statement,

1876: x_return_status => x_return_status);
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: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1882: 'Incorrect return_status after calling ' ||
1883: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1884: FND_LOG.STRING(g_level_statement,

Line 1884: FND_LOG.STRING(g_level_statement,

1880: FND_LOG.STRING(g_level_statement,
1881: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1882: 'Incorrect return_status after calling ' ||
1883: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1884: FND_LOG.STRING(g_level_statement,
1885: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1886: 'RETURN_STATUS = ' || x_return_status);
1887: FND_LOG.STRING(g_level_statement,
1888: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1887: FND_LOG.STRING(g_level_statement,

1883: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
1884: FND_LOG.STRING(g_level_statement,
1885: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1886: 'RETURN_STATUS = ' || x_return_status);
1887: FND_LOG.STRING(g_level_statement,
1888: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1889: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1890: END IF;
1891: RETURN;

Line 1906: FND_LOG.STRING(g_level_statement,

1902: l_error_buffer);
1903:
1904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1905: IF (g_level_statement >= g_current_runtime_level ) THEN
1906: FND_LOG.STRING(g_level_statement,
1907: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1908: 'Incorrect return_status after calling ' ||
1909: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
1910: FND_LOG.STRING(g_level_statement,

Line 1910: FND_LOG.STRING(g_level_statement,

1906: FND_LOG.STRING(g_level_statement,
1907: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1908: 'Incorrect return_status after calling ' ||
1909: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
1910: FND_LOG.STRING(g_level_statement,
1911: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1912: 'RETURN_STATUS = ' || x_return_status);
1913: FND_LOG.STRING(g_level_statement,
1914: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1913: FND_LOG.STRING(g_level_statement,

1909: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
1910: FND_LOG.STRING(g_level_statement,
1911: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1912: 'RETURN_STATUS = ' || x_return_status);
1913: FND_LOG.STRING(g_level_statement,
1914: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1915: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1916: END IF;
1917: RETURN;

Line 1936: FND_LOG.STRING(g_level_statement,

1932: l_error_buffer);
1933:
1934: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1935: IF (g_level_statement >= g_current_runtime_level ) THEN
1936: FND_LOG.STRING(g_level_statement,
1937: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1938: 'Incorrect return_status after calling ' ||
1939: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1940: FND_LOG.STRING(g_level_statement,

Line 1940: FND_LOG.STRING(g_level_statement,

1936: FND_LOG.STRING(g_level_statement,
1937: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1938: 'Incorrect return_status after calling ' ||
1939: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1940: FND_LOG.STRING(g_level_statement,
1941: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1942: 'RETURN_STATUS = ' || x_return_status);
1943: FND_LOG.STRING(g_level_statement,
1944: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1943: FND_LOG.STRING(g_level_statement,

1939: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1940: FND_LOG.STRING(g_level_statement,
1941: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1942: 'RETURN_STATUS = ' || x_return_status);
1943: FND_LOG.STRING(g_level_statement,
1944: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1945: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1946: END IF;
1947: RETURN;

Line 1968: FND_LOG.STRING(g_level_statement,

1964: l_error_buffer);
1965:
1966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1967: IF (g_level_statement >= g_current_runtime_level ) THEN
1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1970: 'Incorrect return_status after calling ' ||
1971: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
1972: FND_LOG.STRING(g_level_statement,

Line 1972: FND_LOG.STRING(g_level_statement,

1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1970: 'Incorrect return_status after calling ' ||
1971: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
1972: FND_LOG.STRING(g_level_statement,
1973: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1974: 'RETURN_STATUS = ' || x_return_status);
1975: FND_LOG.STRING(g_level_statement,
1976: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 1975: FND_LOG.STRING(g_level_statement,

1971: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
1972: FND_LOG.STRING(g_level_statement,
1973: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
1974: 'RETURN_STATUS = ' || x_return_status);
1975: FND_LOG.STRING(g_level_statement,
1976: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
1977: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
1978: END IF;
1979: RETURN;

Line 2000: FND_LOG.STRING(g_level_statement,

1996: l_error_buffer);
1997:
1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1999: IF (g_level_statement >= g_current_runtime_level ) THEN
2000: FND_LOG.STRING(g_level_statement,
2001: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2002: 'Incorrect return_status after calling ' ||
2003: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2004: FND_LOG.STRING(g_level_statement,

Line 2004: FND_LOG.STRING(g_level_statement,

2000: FND_LOG.STRING(g_level_statement,
2001: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2002: 'Incorrect return_status after calling ' ||
2003: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2004: FND_LOG.STRING(g_level_statement,
2005: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2006: 'RETURN_STATUS = ' || x_return_status);
2007: FND_LOG.STRING(g_level_statement,
2008: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 2007: FND_LOG.STRING(g_level_statement,

2003: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
2004: FND_LOG.STRING(g_level_statement,
2005: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2006: 'RETURN_STATUS = ' || x_return_status);
2007: FND_LOG.STRING(g_level_statement,
2008: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
2009: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
2010: END IF;
2011: RETURN;

Line 2033: FND_LOG.STRING(g_level_statement,

2029: l_error_buffer);
2030:
2031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2032: IF (g_level_statement >= g_current_runtime_level ) THEN
2033: FND_LOG.STRING(g_level_statement,
2034: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2035: 'Incorrect return_status after calling ' ||
2036: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2037: FND_LOG.STRING(g_level_statement,

Line 2037: FND_LOG.STRING(g_level_statement,

2033: FND_LOG.STRING(g_level_statement,
2034: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2035: 'Incorrect return_status after calling ' ||
2036: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2037: FND_LOG.STRING(g_level_statement,
2038: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2039: 'RETURN_STATUS = ' || x_return_status);
2040: FND_LOG.STRING(g_level_statement,
2041: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 2040: FND_LOG.STRING(g_level_statement,

2036: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
2037: FND_LOG.STRING(g_level_statement,
2038: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2039: 'RETURN_STATUS = ' || x_return_status);
2040: FND_LOG.STRING(g_level_statement,
2041: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
2042: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
2043: END IF;
2044: RETURN;

Line 2146: FND_LOG.STRING(g_level_statement,

2142: x_return_status => x_return_status);
2143:
2144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2145: IF (g_level_statement >= g_current_runtime_level ) THEN
2146: FND_LOG.STRING(g_level_statement,
2147: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2148: 'Incorrect return_status after calling ' ||
2149: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
2150: FND_LOG.STRING(g_level_statement,

Line 2150: FND_LOG.STRING(g_level_statement,

2146: FND_LOG.STRING(g_level_statement,
2147: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2148: 'Incorrect return_status after calling ' ||
2149: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
2150: FND_LOG.STRING(g_level_statement,
2151: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2152: 'RETURN_STATUS = ' || x_return_status);
2153: FND_LOG.STRING(g_level_statement,
2154: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 2153: FND_LOG.STRING(g_level_statement,

2149: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
2150: FND_LOG.STRING(g_level_statement,
2151: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2152: 'RETURN_STATUS = ' || x_return_status);
2153: FND_LOG.STRING(g_level_statement,
2154: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
2155: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
2156: END IF;
2157: RETURN;

Line 2197: FND_LOG.STRING(g_level_statement,

2193: l_error_buffer );
2194:
2195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2199: 'Incorrect RETURN_STATUS after calling '||
2200: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2201: FND_LOG.STRING(g_level_statement,

Line 2201: FND_LOG.STRING(g_level_statement,

2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2199: 'Incorrect RETURN_STATUS after calling '||
2200: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2201: FND_LOG.STRING(g_level_statement,
2202: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2203: 'RETURN_STATUS = ' || x_return_status);
2204: FND_LOG.STRING(g_level_statement,
2205: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 2204: FND_LOG.STRING(g_level_statement,

2200: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2201: FND_LOG.STRING(g_level_statement,
2202: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2203: 'RETURN_STATUS = ' || x_return_status);
2204: FND_LOG.STRING(g_level_statement,
2205: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
2206: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
2207: END IF;
2208: RETURN;

Line 2212: FND_LOG.STRING(g_level_procedure,

2208: RETURN;
2209: END IF;
2210:
2211: IF (g_level_procedure >= g_current_runtime_level ) THEN
2212: FND_LOG.STRING(g_level_procedure,
2213: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
2214: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
2215: END IF;
2216:

Line 2222: FND_LOG.STRING(g_level_unexpected,

2218: WHEN OTHERS THEN
2219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2220:
2221: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2222: FND_LOG.STRING(g_level_unexpected,
2223: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2224: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2225: FND_LOG.STRING(g_level_unexpected,
2226: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 2225: FND_LOG.STRING(g_level_unexpected,

2221: IF (g_level_unexpected >= g_current_runtime_level ) THEN
2222: FND_LOG.STRING(g_level_unexpected,
2223: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2224: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
2225: FND_LOG.STRING(g_level_unexpected,
2226: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
2227: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
2228: END IF;
2229:

Line 2483: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2479: AND ROWNUM=1;
2480:
2481: BEGIN
2482:
2483: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2484:
2485: IF (g_level_procedure >= g_current_runtime_level ) THEN
2486: FND_LOG.STRING(g_level_procedure,
2487: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.BEGIN',

Line 2486: FND_LOG.STRING(g_level_procedure,

2482:
2483: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2484:
2485: IF (g_level_procedure >= g_current_runtime_level ) THEN
2486: FND_LOG.STRING(g_level_procedure,
2487: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.BEGIN',
2488: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(+)');
2489: END IF;
2490:

Line 2528: FND_LOG.STRING(g_level_statement,

2524: l_direct_rate_result_id := NULL;
2525: l_tax_tbl_subscript := NULL;
2526:
2527: IF (g_level_statement >= g_current_runtime_level ) THEN
2528: FND_LOG.STRING(g_level_statement,
2529: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2530: 'p_trx_line_index: '|| p_trx_line_index|| 'p_tax_regime_code: '||l_tax_rec.tax_regime_code|| 'l_tax: '|| l_tax_rec.tax);
2531: END IF;
2532:

Line 2645: FND_LOG.STRING(g_level_statement,

2641: x_return_status);
2642:
2643: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2644: IF (g_level_statement >= g_current_runtime_level ) THEN
2645: FND_LOG.STRING(g_level_statement,
2646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2647: 'Incorrect return_status after calling ' ||
2648: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
2649: FND_LOG.STRING(g_level_statement,

Line 2649: FND_LOG.STRING(g_level_statement,

2645: FND_LOG.STRING(g_level_statement,
2646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2647: 'Incorrect return_status after calling ' ||
2648: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
2649: FND_LOG.STRING(g_level_statement,
2650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2651: 'RETURN_STATUS = ' || x_return_status);
2652: FND_LOG.STRING(g_level_statement,
2653: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 2652: FND_LOG.STRING(g_level_statement,

2648: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
2649: FND_LOG.STRING(g_level_statement,
2650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2651: 'RETURN_STATUS = ' || x_return_status);
2652: FND_LOG.STRING(g_level_statement,
2653: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
2654: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
2655: END IF;
2656: RETURN;

Line 2680: FND_LOG.STRING(g_level_statement,

2676: x_return_status => x_return_status);
2677:
2678: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2679: IF (g_level_statement >= g_current_runtime_level ) THEN
2680: FND_LOG.STRING(g_level_statement,
2681: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2682: 'Incorrect return_status after calling ' ||
2683: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable');
2684: FND_LOG.STRING(g_level_statement,

Line 2684: FND_LOG.STRING(g_level_statement,

2680: FND_LOG.STRING(g_level_statement,
2681: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2682: 'Incorrect return_status after calling ' ||
2683: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable');
2684: FND_LOG.STRING(g_level_statement,
2685: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2686: 'RETURN_STATUS = ' || x_return_status);
2687: FND_LOG.STRING(g_level_statement,
2688: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 2687: FND_LOG.STRING(g_level_statement,

2683: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_direct_rate_applicable');
2684: FND_LOG.STRING(g_level_statement,
2685: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2686: 'RETURN_STATUS = ' || x_return_status);
2687: FND_LOG.STRING(g_level_statement,
2688: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
2689: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
2690: END IF;
2691: RETURN;

Line 2697: FND_LOG.STRING(g_level_statement,

2693:
2694: IF l_tax_applicable THEN
2695:
2696: IF (g_level_statement >= g_current_runtime_level ) THEN
2697: FND_LOG.STRING(g_level_statement,
2698: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2699: 'l_direct_rate_result_rec.status_result = ' ||
2700: l_direct_rate_result_rec.status_result||'l_direct_rate_result_rec.rate_result = ' ||
2701: l_direct_rate_result_rec.rate_result);

Line 2720: FND_LOG.STRING(g_level_statement,

2716: --
2717: l_tax_applicable := FALSE;
2718:
2719: IF (g_level_statement >= g_current_runtime_level ) THEN
2720: FND_LOG.STRING(g_level_statement,
2721: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2722: 'Tax Rate does not exist in this product family group. ');
2723: END IF;
2724: ELSE

Line 2726: FND_LOG.STRING(g_level_statement,

2722: 'Tax Rate does not exist in this product family group. ');
2723: END IF;
2724: ELSE
2725: IF (g_level_statement >= g_current_runtime_level ) THEN
2726: FND_LOG.STRING(g_level_statement,
2727: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2728: 'Tax Rate exists in this product family group. ');
2729: END IF;
2730: END IF;

Line 2737: FND_LOG.STRING(g_level_statement,

2733: END IF;
2734:
2735: IF (g_level_statement >= g_current_runtime_level ) THEN
2736: IF l_tax_applicable THEN
2737: FND_LOG.STRING(g_level_statement,
2738: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2739: 'Direct Rate is Applicable. ');
2740: ELSE
2741: FND_LOG.STRING(g_level_statement,

Line 2741: FND_LOG.STRING(g_level_statement,

2737: FND_LOG.STRING(g_level_statement,
2738: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2739: 'Direct Rate is Applicable. ');
2740: ELSE
2741: FND_LOG.STRING(g_level_statement,
2742: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2743: 'Direct Rate is not Applicable. ');
2744: END IF;
2745: END IF;

Line 2785: FND_LOG.STRING(g_level_statement,

2781: x_return_status => x_return_status);
2782:
2783: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2784: IF (g_level_statement >= g_current_runtime_level ) THEN
2785: FND_LOG.STRING(g_level_statement,
2786: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2787: 'Incorrect return_status after calling ' ||
2788: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply');
2789: END IF;

Line 2800: FND_LOG.STRING(g_level_statement,

2796: THEN
2797:
2798: x_return_status := FND_API.G_RET_STS_SUCCESS;
2799: IF (g_level_statement >= g_current_runtime_level ) THEN
2800: FND_LOG.STRING(g_level_statement,
2801: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2802: 'For migrated taxes, if the has_other_jurisdictions_flag on ' ||
2803: 'the tax is N, no jurisdiction required. Continue processing tax... ');
2804: END IF;

Line 2808: FND_LOG.STRING(g_level_statement,

2804: END IF;
2805:
2806: ELSE
2807: IF (g_level_statement >= g_current_runtime_level ) THEN
2808: FND_LOG.STRING(g_level_statement,
2809: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2810: 'Unable to determine the Place of Supply for tax: '||l_tax_rec.tax||
2811: ' Place of Supply is mandatory when Direct Rate Determination is not used');
2812: FND_LOG.STRING(g_level_statement,

Line 2812: FND_LOG.STRING(g_level_statement,

2808: FND_LOG.STRING(g_level_statement,
2809: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2810: 'Unable to determine the Place of Supply for tax: '||l_tax_rec.tax||
2811: ' Place of Supply is mandatory when Direct Rate Determination is not used');
2812: FND_LOG.STRING(g_level_statement,
2813: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2814: 'RETURN_STATUS = ' || x_return_status);
2815: FND_LOG.STRING(g_level_statement,
2816: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 2815: FND_LOG.STRING(g_level_statement,

2811: ' Place of Supply is mandatory when Direct Rate Determination is not used');
2812: FND_LOG.STRING(g_level_statement,
2813: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2814: 'RETURN_STATUS = ' || x_return_status);
2815: FND_LOG.STRING(g_level_statement,
2816: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
2817: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
2818: END IF;
2819:

Line 2850: FND_LOG.STRING(g_level_statement,

2846: -- for multiple jurisdictions case: cache the most inner
2847: -- and outer jurisdiction for future usage
2848:
2849: IF (g_level_statement >= g_current_runtime_level ) THEN
2850: FND_LOG.STRING(g_level_statement,
2851: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2852: 'It is a multiple jurisdiction case. ' );
2853: END IF;
2854:

Line 2868: FND_LOG.STRING(g_level_error,

2864:
2865: IF l_jurisdiction_rec_tbl.COUNT = 0 THEN
2866: RAISE NO_DATA_FOUND;
2867: IF (g_level_error >= g_current_runtime_level ) THEN
2868: FND_LOG.STRING(g_level_error,
2869: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2870: 'No data found in ZX_JURISDICTIONS_GT when multiple jurisdictions found.');
2871: END IF;
2872:

Line 2888: FND_LOG.STRING(g_level_statement,

2884: g_outer_jurisdiction_id
2885: := l_jurisdiction_rec_tbl(l_jur_index).tax_jurisdiction_id;
2886:
2887: IF (g_level_statement >= g_current_runtime_level ) THEN
2888: FND_LOG.STRING(g_level_statement,
2889: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2890: 'inner_jurisdiction_code = '|| g_inner_jurisdiction_code ||'outer_jurisdiction_code = '|| g_outer_jurisdiction_code);
2891:
2892: END IF;

Line 2911: FND_LOG.STRING(g_level_statement,

2907: g_outer_jurisdiction_id
2908: := l_jurisdiction_rec.tax_jurisdiction_id;
2909:
2910: IF (g_level_statement >= g_current_runtime_level ) THEN
2911: FND_LOG.STRING(g_level_statement,
2912: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2913: 'single jurisdiction code = '|| g_inner_jurisdiction_code);
2914: END IF;
2915: END IF;

Line 2932: FND_LOG.STRING(g_level_statement,

2928: x_return_status => x_return_status);
2929:
2930: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: IF (g_level_statement >= g_current_runtime_level ) THEN
2932: FND_LOG.STRING(g_level_statement,
2933: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2934: 'Incorrect return_status after calling ' ||
2935: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
2936: FND_LOG.STRING(g_level_statement,

Line 2936: FND_LOG.STRING(g_level_statement,

2932: FND_LOG.STRING(g_level_statement,
2933: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2934: 'Incorrect return_status after calling ' ||
2935: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
2936: FND_LOG.STRING(g_level_statement,
2937: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2938: 'RETURN_STATUS = ' || x_return_status);
2939: FND_LOG.STRING(g_level_statement,
2940: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 2939: FND_LOG.STRING(g_level_statement,

2935: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
2936: FND_LOG.STRING(g_level_statement,
2937: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2938: 'RETURN_STATUS = ' || x_return_status);
2939: FND_LOG.STRING(g_level_statement,
2940: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
2941: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
2942: END IF;
2943: RETURN;

Line 2976: FND_LOG.STRING(g_level_statement,

2972: x_return_status);
2973:
2974: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2975: IF (g_level_statement >= g_current_runtime_level ) THEN
2976: FND_LOG.STRING(g_level_statement,
2977: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2978: 'Incorrect return_status after calling ' ||
2979: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
2980: FND_LOG.STRING(g_level_statement,

Line 2980: FND_LOG.STRING(g_level_statement,

2976: FND_LOG.STRING(g_level_statement,
2977: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2978: 'Incorrect return_status after calling ' ||
2979: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
2980: FND_LOG.STRING(g_level_statement,
2981: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2982: 'RETURN_STATUS = ' || x_return_status);
2983: FND_LOG.STRING(g_level_statement,
2984: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 2983: FND_LOG.STRING(g_level_statement,

2979: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
2980: FND_LOG.STRING(g_level_statement,
2981: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
2982: 'RETURN_STATUS = ' || x_return_status);
2983: FND_LOG.STRING(g_level_statement,
2984: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
2985: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
2986: END IF;
2987: RETURN;

Line 3131: FND_LOG.STRING(g_level_error,

3127: l_error_buffer);
3128:
3129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3130: IF (g_level_error >= g_current_runtime_level ) THEN
3131: FND_LOG.STRING(g_level_error,
3132: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3133: 'Incorrect return_status after calling '||
3134: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
3135: FND_LOG.STRING(g_level_error,

Line 3135: FND_LOG.STRING(g_level_error,

3131: FND_LOG.STRING(g_level_error,
3132: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3133: 'Incorrect return_status after calling '||
3134: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
3135: FND_LOG.STRING(g_level_error,
3136: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3137: 'RETURN_STATUS = ' || x_return_status);
3138: FND_LOG.STRING(g_level_error,
3139: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 3138: FND_LOG.STRING(g_level_error,

3134: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
3135: FND_LOG.STRING(g_level_error,
3136: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3137: 'RETURN_STATUS = ' || x_return_status);
3138: FND_LOG.STRING(g_level_error,
3139: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
3140: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
3141: END IF;
3142: -- Bug 4959835: Since this cursor is moved, commenting this out

Line 3186: FND_LOG.STRING(g_level_statement,

3182: x_return_status => x_return_status);
3183:
3184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3185: IF (g_level_statement >= g_current_runtime_level ) THEN
3186: FND_LOG.STRING(g_level_statement,
3187: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3188: 'Incorrect return_status after calling ' ||
3189: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
3190: FND_LOG.STRING(g_level_statement,

Line 3190: FND_LOG.STRING(g_level_statement,

3186: FND_LOG.STRING(g_level_statement,
3187: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3188: 'Incorrect return_status after calling ' ||
3189: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
3190: FND_LOG.STRING(g_level_statement,
3191: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3192: 'RETURN_STATUS = ' || x_return_status);
3193: FND_LOG.STRING(g_level_statement,
3194: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 3193: FND_LOG.STRING(g_level_statement,

3189: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
3190: FND_LOG.STRING(g_level_statement,
3191: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3192: 'RETURN_STATUS = ' || x_return_status);
3193: FND_LOG.STRING(g_level_statement,
3194: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
3195: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
3196: END IF;
3197: RETURN;

Line 3359: FND_LOG.STRING(g_level_statement,

3355: i).other_doc_source := 'REFERENCE';
3356:
3357: IF g_level_statement >= g_current_runtime_level THEN
3358:
3359: FND_LOG.STRING(g_level_statement,
3360: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3361: 'p_event_class_rec.enforce_tax_from_ref_doc_flag = Y. '||
3362: 'get tax rate code from reference document');
3363: FND_LOG.STRING(g_level_statement,

Line 3363: FND_LOG.STRING(g_level_statement,

3359: FND_LOG.STRING(g_level_statement,
3360: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3361: 'p_event_class_rec.enforce_tax_from_ref_doc_flag = Y. '||
3362: 'get tax rate code from reference document');
3363: FND_LOG.STRING(g_level_statement,
3364: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3365: 'From reference document: tax_status_code = '||
3366: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3367: i).tax_status_code);

Line 3368: FND_LOG.STRING(g_level_statement,

3364: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3365: 'From reference document: tax_status_code = '||
3366: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3367: i).tax_status_code);
3368: FND_LOG.STRING(g_level_statement,
3369: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3370: 'From reference document: tax_rate_code = '||
3371: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3372: i).tax_rate_code);

Line 3373: FND_LOG.STRING(g_level_statement,

3369: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3370: 'From reference document: tax_rate_code = '||
3371: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3372: i).tax_rate_code);
3373: FND_LOG.STRING(g_level_statement,
3374: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3375: 'other_doc_line_amt = '||
3376: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3377: i).other_doc_line_amt);

Line 3378: FND_LOG.STRING(g_level_statement,

3374: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3375: 'other_doc_line_amt = '||
3376: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3377: i).other_doc_line_amt);
3378: FND_LOG.STRING(g_level_statement,
3379: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3380: 'other_doc_line_tax_amt = '||
3381: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3382: i).other_doc_line_tax_amt);

Line 3383: FND_LOG.STRING(g_level_statement,

3379: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3380: 'other_doc_line_tax_amt = '||
3381: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3382: i).other_doc_line_tax_amt);
3383: FND_LOG.STRING(g_level_statement,
3384: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3385: 'other_doc_line_taxable_amt = '||
3386: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3387: i).other_doc_line_taxable_amt);

Line 3391: FND_LOG.STRING(g_level_statement,

3387: i).other_doc_line_taxable_amt);
3388: END IF;
3389: ELSE
3390: IF g_level_statement >= g_current_runtime_level THEN
3391: FND_LOG.STRING(g_level_statement,
3392: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3393: 'enforce_tax_from_ref_doc_flag is turned on, but tax status'||
3394: 'code and tax rate code are not available from reference doc.');
3395: END IF;

Line 3414: FND_LOG.STRING(g_level_statement,

3410: l_error_buffer );
3411:
3412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3413: IF (g_level_statement >= g_current_runtime_level ) THEN
3414: FND_LOG.STRING(g_level_statement,
3415: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3416: 'Incorrect RETURN_STATUS after calling '||
3417: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3418: FND_LOG.STRING(g_level_statement,

Line 3418: FND_LOG.STRING(g_level_statement,

3414: FND_LOG.STRING(g_level_statement,
3415: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3416: 'Incorrect RETURN_STATUS after calling '||
3417: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3418: FND_LOG.STRING(g_level_statement,
3419: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3420: 'RETURN_STATUS = ' || x_return_status);
3421: FND_LOG.STRING(g_level_statement,
3422: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 3421: FND_LOG.STRING(g_level_statement,

3417: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3418: FND_LOG.STRING(g_level_statement,
3419: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3420: 'RETURN_STATUS = ' || x_return_status);
3421: FND_LOG.STRING(g_level_statement,
3422: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
3423: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
3424: END IF;
3425: RETURN;

Line 3430: FND_LOG.STRING(g_level_procedure,

3426: END IF;
3427: END IF; -- line_level_action = 'CREATE', 'UPDATE', 'CREATE_TAX_ONLY'
3428:
3429: IF (g_level_procedure >= g_current_runtime_level ) THEN
3430: FND_LOG.STRING(g_level_procedure,
3431: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
3432: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)'||'RETURN_STATUS = ' || x_return_status);
3433: END IF;
3434:

Line 3446: FND_LOG.STRING(g_level_unexpected,

3442:
3443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3444:
3445: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3446: FND_LOG.STRING(g_level_unexpected,
3447: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3448: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3449: FND_LOG.STRING(g_level_unexpected,
3450: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 3449: FND_LOG.STRING(g_level_unexpected,

3445: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3446: FND_LOG.STRING(g_level_unexpected,
3447: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3448: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3449: FND_LOG.STRING(g_level_unexpected,
3450: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
3451: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
3452: END IF;
3453:

Line 3510: FND_LOG.STRING(g_level_procedure,

3506:
3507: BEGIN
3508:
3509: IF (g_level_procedure >= g_current_runtime_level ) THEN
3510: FND_LOG.STRING(g_level_procedure,
3511: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.BEGIN',
3512: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(+)'|| 'p_trx_line_index = ' || to_char(p_trx_line_index));
3513: END IF;
3514:

Line 3537: FND_LOG.STRING(g_level_statement,

3533: p_error_buffer => l_error_buffer);
3534:
3535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3536: IF (g_level_statement >= g_current_runtime_level ) THEN
3537: FND_LOG.STRING(g_level_statement,
3538: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3539: 'Incorrect return_status after calling ' ||
3540: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
3541: FND_LOG.STRING(g_level_statement,

Line 3541: FND_LOG.STRING(g_level_statement,

3537: FND_LOG.STRING(g_level_statement,
3538: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3539: 'Incorrect return_status after calling ' ||
3540: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
3541: FND_LOG.STRING(g_level_statement,
3542: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3543: 'RETURN_STATUS = ' || x_return_status);
3544: FND_LOG.STRING(g_level_statement,
3545: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',

Line 3544: FND_LOG.STRING(g_level_statement,

3540: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
3541: FND_LOG.STRING(g_level_statement,
3542: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3543: 'RETURN_STATUS = ' || x_return_status);
3544: FND_LOG.STRING(g_level_statement,
3545: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',
3546: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(-)');
3547: END IF;
3548:

Line 3596: FND_LOG.STRING(g_level_statement,

3592: tax_line_rec.tax_rate_type;
3593: END IF;
3594: EXCEPTION WHEN OTHERS THEN
3595: IF (g_level_statement >= g_current_runtime_level ) THEN
3596: FND_LOG.STRING(g_level_statement,
3597: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3598: 'Could Not Reterive a Row for the Tax Id'||tax_line_rec.tax_id);
3599: END IF;
3600: END;

Line 3626: FND_LOG.STRING(g_level_error,

3622: l_error_buffer);
3623:
3624: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3625: IF (g_level_error >= g_current_runtime_level ) THEN
3626: FND_LOG.STRING(g_level_error,
3627: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3628: 'Incorrect return_status after calling ' ||
3629: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
3630: FND_LOG.STRING(g_level_error,

Line 3630: FND_LOG.STRING(g_level_error,

3626: FND_LOG.STRING(g_level_error,
3627: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3628: 'Incorrect return_status after calling ' ||
3629: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
3630: FND_LOG.STRING(g_level_error,
3631: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3632: 'RETURN_STATUS = ' || x_return_status);
3633: FND_LOG.STRING(g_level_error,
3634: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',

Line 3633: FND_LOG.STRING(g_level_error,

3629: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()');
3630: FND_LOG.STRING(g_level_error,
3631: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3632: 'RETURN_STATUS = ' || x_return_status);
3633: FND_LOG.STRING(g_level_error,
3634: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',
3635: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(-)');
3636: END IF;
3637:

Line 3739: FND_LOG.STRING(g_level_statement,

3735: l_new_row_num).prd_total_tax_amt_funcl_curr);
3736:
3737: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3738: IF (g_level_statement >= g_current_runtime_level ) THEN
3739: FND_LOG.STRING(g_level_statement,
3740: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3741: 'Incorrect return_status after calling ' ||
3742: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
3743: FND_LOG.STRING(g_level_statement,

Line 3743: FND_LOG.STRING(g_level_statement,

3739: FND_LOG.STRING(g_level_statement,
3740: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3741: 'Incorrect return_status after calling ' ||
3742: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
3743: FND_LOG.STRING(g_level_statement,
3744: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3745: 'RETURN_STATUS = ' || x_return_status);
3746: FND_LOG.STRING(g_level_statement,
3747: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',

Line 3746: FND_LOG.STRING(g_level_statement,

3742: 'ZX_TRD_SERVICES_PUB_PKG.round_amt_to_mau');
3743: FND_LOG.STRING(g_level_statement,
3744: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3745: 'RETURN_STATUS = ' || x_return_status);
3746: FND_LOG.STRING(g_level_statement,
3747: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',
3748: 'ZX_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(-)');
3749: END IF;
3750: RETURN;

Line 3970: FND_LOG.STRING(g_level_statement,

3966: l_error_buffer);
3967:
3968: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3969: IF (g_level_statement >= g_current_runtime_level ) THEN
3970: FND_LOG.STRING(g_level_statement,
3971: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3972: 'Incorrect return_status after calling ' ||
3973: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3974: FND_LOG.STRING(g_level_statement,

Line 3974: FND_LOG.STRING(g_level_statement,

3970: FND_LOG.STRING(g_level_statement,
3971: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3972: 'Incorrect return_status after calling ' ||
3973: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3974: FND_LOG.STRING(g_level_statement,
3975: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3976: 'RETURN_STATUS = ' || x_return_status);
3977: FND_LOG.STRING(g_level_statement,
3978: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',

Line 3977: FND_LOG.STRING(g_level_statement,

3973: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3974: FND_LOG.STRING(g_level_statement,
3975: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3976: 'RETURN_STATUS = ' || x_return_status);
3977: FND_LOG.STRING(g_level_statement,
3978: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',
3979: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(-)');
3980: END IF;
3981: RETURN;

Line 3986: FND_LOG.STRING(g_level_procedure,

3982: END IF;
3983:
3984: IF (g_level_procedure >= g_current_runtime_level ) THEN
3985:
3986: FND_LOG.STRING(g_level_procedure,
3987: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',
3988: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(-)');
3989: END IF;
3990:

Line 3996: FND_LOG.STRING(g_level_unexpected,

3992: WHEN OTHERS THEN
3993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3994:
3995: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3996: FND_LOG.STRING(g_level_unexpected,
3997: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3998: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3999: FND_LOG.STRING(g_level_unexpected,
4000: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',

Line 3999: FND_LOG.STRING(g_level_unexpected,

3995: IF (g_level_unexpected >= g_current_runtime_level ) THEN
3996: FND_LOG.STRING(g_level_unexpected,
3997: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3998: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
3999: FND_LOG.STRING(g_level_unexpected,
4000: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied.END',
4001: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied(-)');
4002: END IF;
4003:

Line 4089: FND_LOG.STRING(g_level_procedure,

4085:
4086: BEGIN
4087:
4088: IF (g_level_procedure >= g_current_runtime_level ) THEN
4089: FND_LOG.STRING(g_level_procedure,
4090: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.BEGIN',
4091: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(+)'|| 'trx_line_index = ' || to_char(p_trx_line_index));
4092: END IF;
4093:

Line 4111: FND_LOG.STRING(g_level_statement,

4107: p_error_buffer => l_error_buffer);
4108:
4109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4110: IF (g_level_statement >= g_current_runtime_level ) THEN
4111: FND_LOG.STRING(g_level_statement,
4112: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4113: 'Incorrect return_status after calling ' ||
4114: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
4115: FND_LOG.STRING(g_level_statement,

Line 4115: FND_LOG.STRING(g_level_statement,

4111: FND_LOG.STRING(g_level_statement,
4112: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4113: 'Incorrect return_status after calling ' ||
4114: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
4115: FND_LOG.STRING(g_level_statement,
4116: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4117: 'RETURN_STATUS = ' || x_return_status);
4118: FND_LOG.STRING(g_level_statement,
4119: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.END',

Line 4118: FND_LOG.STRING(g_level_statement,

4114: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache()');
4115: FND_LOG.STRING(g_level_statement,
4116: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4117: 'RETURN_STATUS = ' || x_return_status);
4118: FND_LOG.STRING(g_level_statement,
4119: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.END',
4120: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(-)');
4121: END IF;
4122:

Line 4195: FND_LOG.STRING(g_level_statement,

4191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4192: l_new_row_num).tax_apportionment_line_number := tax_line_rec.tax_apportionment_line_number;
4193:
4194: IF (g_level_statement >= g_current_runtime_level ) THEN
4195: FND_LOG.STRING(g_level_statement,
4196: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4197: 'Tax Apportionment Line Number: Bug6729097 ' ||
4198: to_char(tax_line_rec.tax_apportionment_line_number));
4199: END IF;

Line 4618: FND_LOG.STRING(g_level_statement,

4614: l_error_buffer );
4615:
4616: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4617: IF (g_level_statement >= g_current_runtime_level ) THEN
4618: FND_LOG.STRING(g_level_statement,
4619: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4620: 'Incorrect return_status after calling ' ||
4621: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
4622: FND_LOG.STRING(g_level_statement,

Line 4622: FND_LOG.STRING(g_level_statement,

4618: FND_LOG.STRING(g_level_statement,
4619: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4620: 'Incorrect return_status after calling ' ||
4621: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
4622: FND_LOG.STRING(g_level_statement,
4623: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4624: 'RETURN_STATUS = ' || x_return_status);
4625: FND_LOG.STRING(g_level_statement,
4626: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.END',

Line 4625: FND_LOG.STRING(g_level_statement,

4621: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
4622: FND_LOG.STRING(g_level_statement,
4623: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4624: 'RETURN_STATUS = ' || x_return_status);
4625: FND_LOG.STRING(g_level_statement,
4626: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.END',
4627: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(-)');
4628: END IF;
4629:

Line 4635: FND_LOG.STRING(g_level_procedure,

4631: END IF;
4632:
4633: IF (g_level_procedure >= g_current_runtime_level ) THEN
4634:
4635: FND_LOG.STRING(g_level_procedure,
4636: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.END',
4637: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(-)');
4638: END IF;
4639:

Line 4645: FND_LOG.STRING(g_level_unexpected,

4641: WHEN OTHERS THEN
4642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4643:
4644: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4645: FND_LOG.STRING(g_level_unexpected,
4646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4647: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4648: FND_LOG.STRING(g_level_unexpected,
4649: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.END',

Line 4648: FND_LOG.STRING(g_level_unexpected,

4644: IF (g_level_unexpected >= g_current_runtime_level ) THEN
4645: FND_LOG.STRING(g_level_unexpected,
4646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4647: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
4648: FND_LOG.STRING(g_level_unexpected,
4649: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust.END',
4650: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust(-)');
4651: END IF;
4652:

Line 4712: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4708: l_msg_data VARCHAR2(2000);
4709: l_pos_type zx_taxes_b.def_place_of_supply_type_code%TYPE;
4710:
4711: BEGIN
4712: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4713:
4714: IF (g_level_procedure >= g_current_runtime_level ) THEN
4715: FND_LOG.STRING(g_level_procedure,
4716: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.BEGIN',

Line 4715: FND_LOG.STRING(g_level_procedure,

4711: BEGIN
4712: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4713:
4714: IF (g_level_procedure >= g_current_runtime_level ) THEN
4715: FND_LOG.STRING(g_level_procedure,
4716: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.BEGIN',
4717: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(+)');
4718:
4719: END IF;

Line 4726: FND_LOG.STRING(g_level_statement,

4722:
4723: l_tax_service_type_code := 'DET_PLACE_OF_SUPPLY';
4724:
4725: IF (g_level_statement >= g_current_runtime_level ) THEN
4726: FND_LOG.STRING(g_level_statement,
4727: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4728: 'p_place_of_supply_rule_flag = ' || p_place_of_supply_rule_flag ||'p_Def_Place_Of_Supply_Type_Cd = ' || p_def_place_of_supply_type_Cd||'p_applicability_rule_flag = ' || p_applicability_rule_flag
4729: ||'p_def_reg_type = ' || p_def_reg_type);
4730: END IF;

Line 4746: FND_LOG.STRING(g_level_statement,

4742: x_return_status => x_return_status);
4743:
4744: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4745: IF (g_level_statement >= g_current_runtime_level ) THEN
4746: FND_LOG.STRING(g_level_statement,
4747: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4748: 'Incorrect return_status after calling ' ||
4749: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm');
4750: END IF;

Line 4756: FND_LOG.STRING(g_level_statement,

4752: x_place_of_supply_type_code := NULL;
4753: x_place_of_supply_result_id := NULL;
4754:
4755: IF (g_level_statement >= g_current_runtime_level ) THEN
4756: FND_LOG.STRING(g_level_statement,
4757: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
4758: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)');
4759: END IF;
4760: RETURN;

Line 4792: FND_LOG.STRING(g_level_statement,

4788: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4789:
4790:
4791: IF (g_level_statement >= g_current_runtime_level ) THEN
4792: FND_LOG.STRING(g_level_statement,
4793: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4794: 'Unable to derive Place of Supply Type');
4795: END IF;
4796: RETURN;

Line 4825: FND_LOG.STRING(g_level_statement,

4821: ZX_API_PUB.add_msg(
4822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4823:
4824: IF (g_level_statement >= g_current_runtime_level ) THEN
4825: FND_LOG.STRING(g_level_statement,
4826: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4827: 'Incorrect return_status after calling ' ||
4828: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
4829: FND_LOG.STRING(g_level_statement,

Line 4829: FND_LOG.STRING(g_level_statement,

4825: FND_LOG.STRING(g_level_statement,
4826: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4827: 'Incorrect return_status after calling ' ||
4828: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
4829: FND_LOG.STRING(g_level_statement,
4830: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4831: 'RETURN_STATUS = ' || x_return_status);
4832: FND_LOG.STRING(g_level_statement,
4833: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',

Line 4832: FND_LOG.STRING(g_level_statement,

4828: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
4829: FND_LOG.STRING(g_level_statement,
4830: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4831: 'RETURN_STATUS = ' || x_return_status);
4832: FND_LOG.STRING(g_level_statement,
4833: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
4834: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)');
4835: END IF;
4836: RETURN;

Line 4849: FND_LOG.STRING(g_level_statement,

4845:
4846: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4847: THEN
4848: IF (g_level_statement >= g_current_runtime_level ) THEN
4849: FND_LOG.STRING(g_level_statement,
4850: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4851: 'Incorrect return_status after calling ' ||
4852: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
4853: FND_LOG.STRING(g_level_statement,

Line 4853: FND_LOG.STRING(g_level_statement,

4849: FND_LOG.STRING(g_level_statement,
4850: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4851: 'Incorrect return_status after calling ' ||
4852: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
4853: FND_LOG.STRING(g_level_statement,
4854: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4855: 'RETURN_STATUS = ' || x_return_status);
4856: FND_LOG.STRING(g_level_statement,
4857: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',

Line 4856: FND_LOG.STRING(g_level_statement,

4852: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
4853: FND_LOG.STRING(g_level_statement,
4854: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4855: 'RETURN_STATUS = ' || x_return_status);
4856: FND_LOG.STRING(g_level_statement,
4857: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
4858: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)');
4859: END IF;
4860: RETURN;

Line 4887: FND_LOG.STRING(g_level_statement,

4883: ZX_API_PUB.add_msg(
4884: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4885:
4886: IF (g_level_statement >= g_current_runtime_level ) THEN
4887: FND_LOG.STRING(g_level_statement,
4888: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4889: 'Incorrect return_status after calling ' ||
4890: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
4891: FND_LOG.STRING(g_level_statement,

Line 4891: FND_LOG.STRING(g_level_statement,

4887: FND_LOG.STRING(g_level_statement,
4888: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4889: 'Incorrect return_status after calling ' ||
4890: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
4891: FND_LOG.STRING(g_level_statement,
4892: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4893: 'RETURN_STATUS = ' || x_return_status);
4894: FND_LOG.STRING(g_level_statement,
4895: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',

Line 4894: FND_LOG.STRING(g_level_statement,

4890: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name');
4891: FND_LOG.STRING(g_level_statement,
4892: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4893: 'RETURN_STATUS = ' || x_return_status);
4894: FND_LOG.STRING(g_level_statement,
4895: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
4896: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)');
4897: END IF;
4898: RETURN;

Line 4911: FND_LOG.STRING(g_level_statement,

4907:
4908: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
4909: THEN
4910: IF (g_level_statement >= g_current_runtime_level ) THEN
4911: FND_LOG.STRING(g_level_statement,
4912: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4913: 'Incorrect return_status after calling ' ||
4914: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
4915: FND_LOG.STRING(g_level_statement,

Line 4915: FND_LOG.STRING(g_level_statement,

4911: FND_LOG.STRING(g_level_statement,
4912: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4913: 'Incorrect return_status after calling ' ||
4914: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
4915: FND_LOG.STRING(g_level_statement,
4916: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4917: 'RETURN_STATUS = ' || x_return_status);
4918: FND_LOG.STRING(g_level_statement,
4919: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',

Line 4918: FND_LOG.STRING(g_level_statement,

4914: 'ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value');
4915: FND_LOG.STRING(g_level_statement,
4916: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4917: 'RETURN_STATUS = ' || x_return_status);
4918: FND_LOG.STRING(g_level_statement,
4919: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
4920: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)');
4921: END IF;
4922: RETURN;

Line 4955: FND_LOG.STRING(g_level_statement,

4951: ZX_API_PUB.add_msg(
4952: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4953:
4954: IF (g_level_statement >= g_current_runtime_level ) THEN
4955: FND_LOG.STRING(g_level_statement,
4956: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4957: 'Incorrect return_status after calling ' ||
4958: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
4959: FND_LOG.STRING(g_level_statement,

Line 4959: FND_LOG.STRING(g_level_statement,

4955: FND_LOG.STRING(g_level_statement,
4956: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4957: 'Incorrect return_status after calling ' ||
4958: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
4959: FND_LOG.STRING(g_level_statement,
4960: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4961: 'RETURN_STATUS = ' || x_return_status);
4962: FND_LOG.STRING(g_level_statement,
4963: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',

Line 4962: FND_LOG.STRING(g_level_statement,

4958: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
4959: FND_LOG.STRING(g_level_statement,
4960: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4961: 'RETURN_STATUS = ' || x_return_status);
4962: FND_LOG.STRING(g_level_statement,
4963: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
4964: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)');
4965: END IF;
4966: RETURN;

Line 4988: FND_LOG.STRING(g_level_statement,

4984: ZX_API_PUB.add_msg(
4985: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
4986: */
4987: IF (g_level_statement >= g_current_runtime_level ) THEN
4988: FND_LOG.STRING(g_level_statement,
4989: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4990: 'Location id is NULL for location type ' || l_pos_type ||
4991: ', and direct rate not found for the tax '|| p_tax ||
4992: '. Hence the tax is not applicable.');

Line 5001: FND_LOG.STRING(g_level_procedure,

4997: x_place_of_supply_type_code := l_pos_type;
4998:
4999: IF (g_level_procedure >= g_current_runtime_level ) THEN
5000:
5001: FND_LOG.STRING(g_level_procedure,
5002: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
5003: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)'||'X_place_of_supply_type_code = '|| x_place_of_supply_type_code);
5004: END IF;
5005:

Line 5013: FND_LOG.STRING(g_level_unexpected,

5009: x_place_of_supply_result_id := NULL;
5010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5011:
5012: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5013: FND_LOG.STRING(g_level_unexpected,
5014: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
5015: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5016: FND_LOG.STRING(g_level_unexpected,
5017: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',

Line 5016: FND_LOG.STRING(g_level_unexpected,

5012: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5013: FND_LOG.STRING(g_level_unexpected,
5014: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
5015: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5016: FND_LOG.STRING(g_level_unexpected,
5017: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply.END',
5018: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply(-)');
5019: END IF;
5020:

Line 5044: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5040: x_msg_count NUMBER;
5041: x_msg_data VARCHAR2(2000);
5042:
5043: BEGIN
5044: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5045:
5046: IF (g_level_statement >= g_current_runtime_level ) THEN
5047: FND_LOG.STRING(g_level_statement,
5048: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name.BEGIN',

Line 5047: FND_LOG.STRING(g_level_statement,

5043: BEGIN
5044: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5045:
5046: IF (g_level_statement >= g_current_runtime_level ) THEN
5047: FND_LOG.STRING(g_level_statement,
5048: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name.BEGIN',
5049: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name(+)'|| 'pos_type = ' || p_pos_type);
5050: END IF;
5051:

Line 5194: FND_LOG.STRING(g_level_statement,

5190: RETURN 'POD_'||l_loc_site;
5191:
5192: ELSE
5193: IF (g_level_statement >= g_current_runtime_level ) THEN
5194: FND_LOG.STRING(g_level_statement,
5195: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name',
5196: 'pos_parameter_name = NULL');
5197: END IF;
5198: RETURN Null;

Line 5203: FND_LOG.STRING(g_level_procedure,

5199: END IF;
5200:
5201: IF (g_level_procedure >= g_current_runtime_level ) THEN
5202:
5203: FND_LOG.STRING(g_level_procedure,
5204: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name.END',
5205: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name(-)');
5206: END IF;
5207:

Line 5212: FND_LOG.STRING(g_level_unexpected,

5208: EXCEPTION
5209: WHEN OTHERS THEN
5210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5211: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5212: FND_LOG.STRING(g_level_unexpected,
5213: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name',
5214: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5215: FND_LOG.STRING(g_level_unexpected,
5216: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name.END',

Line 5215: FND_LOG.STRING(g_level_unexpected,

5211: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5212: FND_LOG.STRING(g_level_unexpected,
5213: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name',
5214: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5215: FND_LOG.STRING(g_level_unexpected,
5216: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name.END',
5217: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_pos_parameter_name(-)');
5218: END IF;
5219:

Line 5266: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5262: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
5263: l_has_other_jurisdictions_flag VARCHAR2(1);
5264:
5265: BEGIN
5266: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5267:
5268: IF (g_level_procedure >= g_current_runtime_level ) THEN
5269: FND_LOG.STRING(g_level_procedure,
5270: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.BEGIN',

Line 5269: FND_LOG.STRING(g_level_procedure,

5265: BEGIN
5266: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5267:
5268: IF (g_level_procedure >= g_current_runtime_level ) THEN
5269: FND_LOG.STRING(g_level_procedure,
5270: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.BEGIN',
5271: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(+)');
5272: END IF;
5273:

Line 5287: FND_LOG.STRING(g_level_error,

5283: l_error_buffer);
5284:
5285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5286: IF (g_level_error >= g_current_runtime_level ) THEN
5287: FND_LOG.STRING(g_level_error,
5288: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5289: 'Incorrect return_status after calling ' ||
5290: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5291: FND_LOG.STRING(g_level_error,

Line 5291: FND_LOG.STRING(g_level_error,

5287: FND_LOG.STRING(g_level_error,
5288: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5289: 'Incorrect return_status after calling ' ||
5290: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5291: FND_LOG.STRING(g_level_error,
5292: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5293: 'l_reg_party_prof_id = ' || l_reg_party_prof_id);
5294: FND_LOG.STRING(g_level_error,
5295: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',

Line 5294: FND_LOG.STRING(g_level_error,

5290: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5291: FND_LOG.STRING(g_level_error,
5292: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5293: 'l_reg_party_prof_id = ' || l_reg_party_prof_id);
5294: FND_LOG.STRING(g_level_error,
5295: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5296: 'RETURN_STATUS = ' || x_return_status);
5297: FND_LOG.STRING(g_level_error,
5298: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',

Line 5297: FND_LOG.STRING(g_level_error,

5293: 'l_reg_party_prof_id = ' || l_reg_party_prof_id);
5294: FND_LOG.STRING(g_level_error,
5295: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5296: 'RETURN_STATUS = ' || x_return_status);
5297: FND_LOG.STRING(g_level_error,
5298: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',
5299: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(-)');
5300: END IF;
5301: RETURN;

Line 5324: FND_LOG.STRING(g_level_error,

5320: l_error_buffer);
5321:
5322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5323: IF (g_level_error >= g_current_runtime_level ) THEN
5324: FND_LOG.STRING(g_level_error,
5325: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5326: 'Incorrect return_status after calling ' ||
5327: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5328: FND_LOG.STRING(g_level_error,

Line 5328: FND_LOG.STRING(g_level_error,

5324: FND_LOG.STRING(g_level_error,
5325: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5326: 'Incorrect return_status after calling ' ||
5327: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5328: FND_LOG.STRING(g_level_error,
5329: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5330: 'l_hq_estb_ptp_id = ' || l_hq_estb_ptp_id);
5331: FND_LOG.STRING(g_level_error,
5332: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',

Line 5331: FND_LOG.STRING(g_level_error,

5327: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5328: FND_LOG.STRING(g_level_error,
5329: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5330: 'l_hq_estb_ptp_id = ' || l_hq_estb_ptp_id);
5331: FND_LOG.STRING(g_level_error,
5332: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5333: 'RETURN_STATUS = ' || x_return_status);
5334: FND_LOG.STRING(g_level_error,
5335: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',

Line 5334: FND_LOG.STRING(g_level_error,

5330: 'l_hq_estb_ptp_id = ' || l_hq_estb_ptp_id);
5331: FND_LOG.STRING(g_level_error,
5332: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5333: 'RETURN_STATUS = ' || x_return_status);
5334: FND_LOG.STRING(g_level_error,
5335: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',
5336: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(-)');
5337: END IF;
5338: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5364: FND_LOG.STRING(g_level_error,

5360: l_error_buffer);
5361:
5362: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5363: IF (g_level_error >= g_current_runtime_level ) THEN
5364: FND_LOG.STRING(g_level_error,
5365: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5366: 'Incorrect return_status after calling ' ||
5367: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5368: FND_LOG.STRING(g_level_error,

Line 5368: FND_LOG.STRING(g_level_error,

5364: FND_LOG.STRING(g_level_error,
5365: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5366: 'Incorrect return_status after calling ' ||
5367: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5368: FND_LOG.STRING(g_level_error,
5369: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5370: 'l_account_site_id = ' || l_account_site_id);
5371: FND_LOG.STRING(g_level_error,
5372: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',

Line 5371: FND_LOG.STRING(g_level_error,

5367: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5368: FND_LOG.STRING(g_level_error,
5369: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5370: 'l_account_site_id = ' || l_account_site_id);
5371: FND_LOG.STRING(g_level_error,
5372: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5373: 'RETURN_STATUS = ' || x_return_status);
5374: FND_LOG.STRING(g_level_error,
5375: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',

Line 5374: FND_LOG.STRING(g_level_error,

5370: 'l_account_site_id = ' || l_account_site_id);
5371: FND_LOG.STRING(g_level_error,
5372: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5373: 'RETURN_STATUS = ' || x_return_status);
5374: FND_LOG.STRING(g_level_error,
5375: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',
5376: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(-)');
5377: END IF;
5378: RETURN;

Line 5393: FND_LOG.STRING(g_level_error,

5389: l_error_buffer);
5390:
5391: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5392: IF (g_level_error >= g_current_runtime_level ) THEN
5393: FND_LOG.STRING(g_level_error,
5394: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5395: 'Incorrect return_status after calling ' ||
5396: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5397: FND_LOG.STRING(g_level_error,

Line 5397: FND_LOG.STRING(g_level_error,

5393: FND_LOG.STRING(g_level_error,
5394: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5395: 'Incorrect return_status after calling ' ||
5396: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5397: FND_LOG.STRING(g_level_error,
5398: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5399: 'l_account_id = ' || l_account_id);
5400: FND_LOG.STRING(g_level_error,
5401: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',

Line 5400: FND_LOG.STRING(g_level_error,

5396: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5397: FND_LOG.STRING(g_level_error,
5398: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5399: 'l_account_id = ' || l_account_id);
5400: FND_LOG.STRING(g_level_error,
5401: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5402: 'RETURN_STATUS = ' || x_return_status);
5403: FND_LOG.STRING(g_level_error,
5404: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',

Line 5403: FND_LOG.STRING(g_level_error,

5399: 'l_account_id = ' || l_account_id);
5400: FND_LOG.STRING(g_level_error,
5401: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5402: 'RETURN_STATUS = ' || x_return_status);
5403: FND_LOG.STRING(g_level_error,
5404: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',
5405: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(-)');
5406: END IF;
5407: RETURN;

Line 5427: FND_LOG.STRING(g_level_error,

5423: END IF;
5424:
5425: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5426: IF (g_level_error >= g_current_runtime_level ) THEN
5427: FND_LOG.STRING(g_level_error,
5428: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5429: 'Incorrect return_status after calling ' ||
5430: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5431: FND_LOG.STRING(g_level_error,

Line 5431: FND_LOG.STRING(g_level_error,

5427: FND_LOG.STRING(g_level_error,
5428: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5429: 'Incorrect return_status after calling ' ||
5430: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5431: FND_LOG.STRING(g_level_error,
5432: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5433: 'l_site_use_id = ' || l_site_use_id);
5434: FND_LOG.STRING(g_level_error,
5435: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',

Line 5434: FND_LOG.STRING(g_level_error,

5430: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5431: FND_LOG.STRING(g_level_error,
5432: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5433: 'l_site_use_id = ' || l_site_use_id);
5434: FND_LOG.STRING(g_level_error,
5435: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5436: 'RETURN_STATUS = ' || x_return_status);
5437: FND_LOG.STRING(g_level_error,
5438: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',

Line 5437: FND_LOG.STRING(g_level_error,

5433: 'l_site_use_id = ' || l_site_use_id);
5434: FND_LOG.STRING(g_level_error,
5435: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5436: 'RETURN_STATUS = ' || x_return_status);
5437: FND_LOG.STRING(g_level_error,
5438: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',
5439: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(-)');
5440: END IF;
5441: RETURN;

Line 5464: FND_LOG.STRING(g_level_error,

5460: l_error_buffer);
5461:
5462: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5463: IF (g_level_error >= g_current_runtime_level ) THEN
5464: FND_LOG.STRING(g_level_error,
5465: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5466: 'Incorrect return_status after calling ' ||
5467: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5468: FND_LOG.STRING(g_level_error,

Line 5468: FND_LOG.STRING(g_level_error,

5464: FND_LOG.STRING(g_level_error,
5465: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5466: 'Incorrect return_status after calling ' ||
5467: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5468: FND_LOG.STRING(g_level_error,
5469: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5470: 'l_site_ptp_id = ' || l_site_ptp_id);
5471: FND_LOG.STRING(g_level_error,
5472: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',

Line 5471: FND_LOG.STRING(g_level_error,

5467: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
5468: FND_LOG.STRING(g_level_error,
5469: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5470: 'l_site_ptp_id = ' || l_site_ptp_id);
5471: FND_LOG.STRING(g_level_error,
5472: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5473: 'RETURN_STATUS = ' || x_return_status);
5474: FND_LOG.STRING(g_level_error,
5475: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',

Line 5474: FND_LOG.STRING(g_level_error,

5470: 'l_site_ptp_id = ' || l_site_ptp_id);
5471: FND_LOG.STRING(g_level_error,
5472: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5473: 'RETURN_STATUS = ' || x_return_status);
5474: FND_LOG.STRING(g_level_error,
5475: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',
5476: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(-)');
5477: END IF;
5478: RETURN;

Line 5543: FND_LOG.STRING(g_level_statement,

5539:
5540: IF NVL(x_return_status, FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS
5541: THEN
5542: IF (g_level_statement >= g_current_runtime_level ) THEN
5543: FND_LOG.STRING(g_level_statement,
5544: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5545: 'ZX_TCM_CONTROL_PKG.get_tax_registration_info returns with Error');
5546: END IF;
5547: -- Bug 4939819 - Skip registration processing if PTP setupis not found

Line 5560: FND_LOG.STRING(g_level_statement,

5556:
5557: EXCEPTION
5558: WHEN OTHERS THEN
5559: IF (g_level_statement >= g_current_runtime_level ) THEN
5560: FND_LOG.STRING(g_level_statement,
5561: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info',
5562: 'Unable to get tax registration number after calling TCM API.');
5563: END IF;
5564: END;

Line 5568: FND_LOG.STRING(g_level_procedure,

5564: END;
5565:
5566: IF (g_level_procedure >= g_current_runtime_level ) THEN
5567:
5568: FND_LOG.STRING(g_level_procedure,
5569: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info.END',
5570: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration_info(-)'||x_return_status);
5571: END IF;
5572:

Line 5578: FND_LOG.STRING(g_level_unexpected,

5574: WHEN OTHERS THEN
5575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5576:
5577: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5578: FND_LOG.STRING(g_level_unexpected,
5579: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_tax_registration_info',
5580: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5581: END IF;
5582:

Line 5647: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5643: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5644: l_account_type_code VARCHAR2(30);
5645:
5646: BEGIN
5647: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5648:
5649: IF (g_level_procedure >= g_current_runtime_level ) THEN
5650: FND_LOG.STRING(g_level_procedure,
5651: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration.BEGIN',

Line 5650: FND_LOG.STRING(g_level_procedure,

5646: BEGIN
5647: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5648:
5649: IF (g_level_procedure >= g_current_runtime_level ) THEN
5650: FND_LOG.STRING(g_level_procedure,
5651: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration.BEGIN',
5652: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(+)'|| 'def_reg_type = ' || p_def_reg_type||'p_reg_rule_flg = ' || p_reg_rule_flg);
5653:
5654: END IF;

Line 5674: FND_LOG.STRING(g_level_statement,

5670: x_return_status => x_return_status);
5671:
5672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5673: IF (g_level_statement >= g_current_runtime_level ) THEN
5674: FND_LOG.STRING(g_level_statement,
5675: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration',
5676: 'Incorrect return_status after calling ' ||
5677: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm');
5678: END IF;

Line 5682: FND_LOG.STRING(g_level_statement,

5678: END IF;
5679:
5680: x_tax_registration_result_id := NULL;
5681: IF (g_level_statement >= g_current_runtime_level ) THEN
5682: FND_LOG.STRING(g_level_statement,
5683: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration',
5684: 'RETURN_STATUS = ' || x_return_status);
5685: FND_LOG.STRING(g_level_statement,
5686: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration.END',

Line 5685: FND_LOG.STRING(g_level_statement,

5681: IF (g_level_statement >= g_current_runtime_level ) THEN
5682: FND_LOG.STRING(g_level_statement,
5683: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration',
5684: 'RETURN_STATUS = ' || x_return_status);
5685: FND_LOG.STRING(g_level_statement,
5686: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration.END',
5687: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(-)');
5688: END IF;
5689:

Line 5757: FND_LOG.STRING(g_level_statement,

5753: OR l_registration_rec.registration_id IS NULL)
5754: THEN
5755:
5756: IF (g_level_statement >= g_current_runtime_level ) THEN
5757: FND_LOG.STRING(g_level_statement,
5758: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration',
5759: 'ZX_TCM_CONTROL_PKG.GET_TAX_REGISTRATION returns with ' ||
5760: ' Exception or no value ');
5761:

Line 5863: FND_LOG.STRING(g_level_procedure,

5859: END IF;
5860:
5861: IF (g_level_procedure >= g_current_runtime_level ) THEN
5862:
5863: FND_LOG.STRING(g_level_procedure,
5864: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration.END',
5865: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(-)'||'x_registration_number = ' || x_registration_number||'x_tax_inclusion_flag = ' || x_tax_inclusion_flag
5866: ||'x_self_assessment_flg = ' || x_self_assessment_flg||'x_tax_registration_result_id = ' ||
5867: to_char(x_tax_registration_result_id)||'X_rounding_rule_code = ' || x_rounding_rule_code||'RETURN_STATUS = ' || x_return_status);

Line 5887: FND_LOG.STRING(g_level_statement,

5883: ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(p_tax_id).rounding_rule_code;
5884: END IF;
5885:
5886: IF (g_level_statement >= g_current_runtime_level ) THEN
5887: FND_LOG.STRING(g_level_statement,
5888: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration',
5889: 'RETURN_STATUS = ' || x_return_status);
5890: END IF;
5891: x_tax_registration_result_id := NULL;

Line 5896: FND_LOG.STRING(g_level_unexpected,

5892:
5893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5894:
5895: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5896: FND_LOG.STRING(g_level_unexpected,
5897: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration',
5898: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5899: FND_LOG.STRING(g_level_unexpected,
5900: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration.END',

Line 5899: FND_LOG.STRING(g_level_unexpected,

5895: IF (g_level_unexpected >= g_current_runtime_level ) THEN
5896: FND_LOG.STRING(g_level_unexpected,
5897: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration',
5898: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
5899: FND_LOG.STRING(g_level_unexpected,
5900: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration.END',
5901: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration(-)');
5902: END IF;
5903:

Line 5937: FND_LOG.STRING(g_level_statement,

5933: l_party_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5934:
5935: BEGIN
5936: IF (g_level_statement >= g_current_runtime_level ) THEN
5937: FND_LOG.STRING(g_level_statement,
5938: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration.BEGIN',
5939: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration(+)');
5940: END IF;
5941:

Line 5950: FND_LOG.STRING(g_level_statement,

5946: l_hq_estb_ptp_id :=
5947: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).hq_estb_party_tax_prof_id;
5948:
5949: IF (g_level_statement >= g_current_runtime_level ) THEN
5950: FND_LOG.STRING(g_level_statement,
5951: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration',
5952: 'l_hq_estb_ptp_id = ' || TO_CHAR(l_hq_estb_ptp_id));
5953:
5954: END IF;

Line 5958: FND_LOG.STRING(g_level_statement,

5954: END IF;
5955:
5956: IF l_hq_estb_ptp_id IS NULL THEN
5957: IF (g_level_statement >= g_current_runtime_level ) THEN
5958: FND_LOG.STRING(g_level_statement,
5959: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration',
5960: 'HQ establishment party tax profile id is not available');
5961: END IF;
5962: RETURN;

Line 6026: FND_LOG.STRING(g_level_statement,

6022: --
6023: x_return_status := FND_API.G_RET_STS_SUCCESS;
6024:
6025: IF (g_level_statement >= g_current_runtime_level ) THEN
6026: FND_LOG.STRING(g_level_statement,
6027: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration',
6028: 'Warning: ZX_TCM_CONTROL_PKG.get_tax_registration returns ' ||
6029: 'with Exception or no value. ');
6030: END IF;

Line 6035: FND_LOG.STRING(g_level_statement,

6031: END IF;
6032:
6033: IF (g_level_statement >= g_current_runtime_level ) THEN
6034:
6035: FND_LOG.STRING(g_level_statement,
6036: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration.END',
6037: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration(-)'||'hq_estb_reg_number = ' || l_registration_rec.registration_number||'x_return_status = ' || x_return_status
6038: ||'x_error_buffer = ' || x_error_buffer);
6039: END IF;

Line 6046: FND_LOG.STRING(g_level_unexpected,

6042: WHEN OTHERS THEN
6043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6044:
6045: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6046: FND_LOG.STRING(g_level_unexpected,
6047: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration',
6048: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6049: FND_LOG.STRING(g_level_unexpected,
6050: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration.END',

Line 6049: FND_LOG.STRING(g_level_unexpected,

6045: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6046: FND_LOG.STRING(g_level_unexpected,
6047: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration',
6048: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6049: FND_LOG.STRING(g_level_unexpected,
6050: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration.END',
6051: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_legal_entity_registration(-)');
6052: END IF;
6053:

Line 6089: FND_LOG.STRING(g_level_statement,

6085:
6086: BEGIN
6087:
6088: IF (g_level_statement >= g_current_runtime_level ) THEN
6089: FND_LOG.STRING(g_level_statement,
6090: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm.BEGIN',
6091: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm(+)');
6092: END IF;
6093:

Line 6112: FND_LOG.STRING(g_level_statement,

6108: l_error_buffer);
6109:
6110: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6111: IF (g_level_statement >= g_current_runtime_level ) THEN
6112: FND_LOG.STRING(g_level_statement,
6113: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm',
6114: 'Incorrect return_status after calling ' ||
6115: 'ZX_TDS_RULE_BASE_DETM_PVT.rule_base_process');
6116: END IF;

Line 6122: FND_LOG.STRING(g_level_statement,

6118: x_alphanumeric_result := NULL;
6119: x_result_id := NULL;
6120: IF (g_level_statement >= g_current_runtime_level ) THEN
6121:
6122: FND_LOG.STRING(g_level_statement,
6123: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm.END',
6124: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm(-)'||x_return_status);
6125: END IF;
6126: RETURN;

Line 6140: FND_LOG.STRING(g_level_statement,

6136: END IF;
6137:
6138: IF (g_level_statement >= g_current_runtime_level ) THEN
6139:
6140: FND_LOG.STRING(g_level_statement,
6141: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm.END',
6142: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm(-)'||x_return_status);
6143: END IF;
6144:

Line 6152: FND_LOG.STRING(g_level_unexpected,

6148: x_result_id := NULL;
6149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6150:
6151: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6152: FND_LOG.STRING(g_level_unexpected,
6153: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm',
6154: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6155: FND_LOG.STRING(g_level_unexpected,
6156: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm.END',

Line 6155: FND_LOG.STRING(g_level_unexpected,

6151: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6152: FND_LOG.STRING(g_level_unexpected,
6153: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm',
6154: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6155: FND_LOG.STRING(g_level_unexpected,
6156: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm.END',
6157: 'ZX_TDS_APPLICABILITY_DETM_PKG.rule_base_pos_detm(-)');
6158: END IF;
6159: END rule_base_pos_detm;

Line 6192: FND_LOG.STRING(g_level_procedure,

6188:
6189: x_return_status := FND_API.G_RET_STS_SUCCESS;
6190:
6191: IF (g_level_procedure >= g_current_runtime_level ) THEN
6192: FND_LOG.STRING(g_level_procedure,
6193: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info.BEGIN',
6194: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info(+)');
6195: END IF;
6196:

Line 6250: FND_LOG.STRING(g_level_statement,

6246: x_return_status => x_return_status);
6247:
6248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6249: IF (g_level_statement >= g_current_runtime_level ) THEN
6250: FND_LOG.STRING(g_level_statement,
6251: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info',
6252: 'Incorrect return_status after calling ' ||
6253: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
6254: FND_LOG.STRING(g_level_statement,

Line 6254: FND_LOG.STRING(g_level_statement,

6250: FND_LOG.STRING(g_level_statement,
6251: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info',
6252: 'Incorrect return_status after calling ' ||
6253: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
6254: FND_LOG.STRING(g_level_statement,
6255: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info',
6256: 'RETURN_STATUS = ' || x_return_status);
6257: FND_LOG.STRING(g_level_statement,
6258: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info.END',

Line 6257: FND_LOG.STRING(g_level_statement,

6253: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_registration');
6254: FND_LOG.STRING(g_level_statement,
6255: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info',
6256: 'RETURN_STATUS = ' || x_return_status);
6257: FND_LOG.STRING(g_level_statement,
6258: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info.END',
6259: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info(-)');
6260: END IF;
6261: RETURN;

Line 6288: FND_LOG.STRING(g_level_statement,

6284: x_return_status => x_return_status,
6285: x_error_buffer => l_error_buffer);
6286: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6287: IF (g_level_statement >= g_current_runtime_level ) THEN
6288: FND_LOG.STRING(g_level_statement,
6289: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info.END',
6290: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info(-)');
6291: END IF;
6292: RETURN;

Line 6302: FND_LOG.STRING(g_level_unexpected,

6298:
6299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6300:
6301: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6302: FND_LOG.STRING(g_level_unexpected,
6303: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info',
6304: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6305: FND_LOG.STRING(g_level_unexpected,
6306: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info.END',

Line 6305: FND_LOG.STRING(g_level_unexpected,

6301: IF (g_level_unexpected >= g_current_runtime_level ) THEN
6302: FND_LOG.STRING(g_level_unexpected,
6303: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info',
6304: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
6305: FND_LOG.STRING(g_level_unexpected,
6306: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info.END',
6307: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info(-)');
6308: END IF;
6309: END populate_registration_info;

Line 6450: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6446: l_tax_class zx_rates_b.tax_class%TYPE;
6447:
6448: BEGIN
6449:
6450: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6451:
6452: IF (g_level_procedure >= g_current_runtime_level ) THEN
6453: FND_LOG.STRING(g_level_procedure,
6454: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.BEGIN',

Line 6453: FND_LOG.STRING(g_level_procedure,

6449:
6450: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6451:
6452: IF (g_level_procedure >= g_current_runtime_level ) THEN
6453: FND_LOG.STRING(g_level_procedure,
6454: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.BEGIN',
6455: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(+)');
6456:
6457: END IF;

Line 6480: FND_LOG.STRING(g_level_statement,

6476: FETCH get_chart_of_accts_id_csr into l_chart_of_accounts_id;
6477: CLOSE get_chart_of_accts_id_csr;
6478:
6479: IF (g_level_statement >= g_current_runtime_level ) THEN
6480: FND_LOG.STRING(g_level_statement,
6481: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6482: 'l_chart_of_accounts_id = ' || to_char(l_chart_of_accounts_id));
6483: END IF;
6484:

Line 6488: FND_LOG.STRING(g_level_statement,

6484:
6485: IF l_chart_of_accounts_id IS NULL THEN
6486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
6487: IF g_level_statement >= g_current_runtime_level THEN
6488: FND_LOG.STRING(g_level_statement,
6489: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6490: 'chart_of_accounts_id is NULL.');
6491: FND_LOG.STRING(g_level_statement,
6492: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',

Line 6491: FND_LOG.STRING(g_level_statement,

6487: IF g_level_statement >= g_current_runtime_level THEN
6488: FND_LOG.STRING(g_level_statement,
6489: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6490: 'chart_of_accounts_id is NULL.');
6491: FND_LOG.STRING(g_level_statement,
6492: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6493: 'RETURN_STATUS = ' || x_return_status);
6494: FND_LOG.STRING(g_level_statement,
6495: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 6494: FND_LOG.STRING(g_level_statement,

6490: 'chart_of_accounts_id is NULL.');
6491: FND_LOG.STRING(g_level_statement,
6492: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6493: 'RETURN_STATUS = ' || x_return_status);
6494: FND_LOG.STRING(g_level_statement,
6495: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6496: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
6497: END IF;
6498: RETURN;

Line 6506: FND_LOG.STRING(g_level_statement,

6502:
6503: -- Get the column name of the account segment in GL_CODE_COMBINATIONS
6504: --
6505: IF (g_level_statement >= g_current_runtime_level ) THEN
6506: FND_LOG.STRING(g_level_statement,
6507: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6508: 'Getting tax code using code combination ID.'|| to_char(l_account_ccid));
6509: END IF;
6510:

Line 6527: FND_LOG.STRING(g_level_statement,

6523:
6524: EXECUTE IMMEDIATE l_sql_statement INTO l_account_seg_value;
6525:
6526: IF (g_level_statement >= g_current_runtime_level ) THEN
6527: FND_LOG.STRING(g_level_statement,
6528: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6529: 'l_account_seg_value ==' || l_account_seg_value);
6530: END IF;
6531:

Line 6535: FND_LOG.STRING(g_level_statement,

6531:
6532: ELSIF l_account_string IS NOT NULL THEN
6533:
6534: IF (g_level_statement >= g_current_runtime_level ) THEN
6535: FND_LOG.STRING(g_level_statement,
6536: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6537: 'account_string ==' || l_account_string);
6538: END IF;
6539:

Line 6562: FND_LOG.STRING(g_level_statement,

6558:
6559: l_account_seg_value := l_flexsegtab(l_account_seg_num);
6560:
6561: IF (g_level_statement >= g_current_runtime_level ) THEN
6562: FND_LOG.STRING(g_level_statement,
6563: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6564: 'l_account_seg_value == ' || l_account_seg_value|| 'l_delimiter == ' || l_delimiter);
6565: END IF;
6566: END IF;

Line 6598: FND_LOG.STRING(g_level_statement,

6594: x_return_status);
6595:
6596: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6597: IF (g_level_statement >= g_current_runtime_level ) THEN
6598: FND_LOG.STRING(g_level_statement,
6599: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6600: 'Incorrect return_status after calling ' ||
6601: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
6602: FND_LOG.STRING(g_level_statement,

Line 6602: FND_LOG.STRING(g_level_statement,

6598: FND_LOG.STRING(g_level_statement,
6599: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6600: 'Incorrect return_status after calling ' ||
6601: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
6602: FND_LOG.STRING(g_level_statement,
6603: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6604: 'RETURN_STATUS = ' || x_return_status);
6605: FND_LOG.STRING(g_level_statement,
6606: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 6605: FND_LOG.STRING(g_level_statement,

6601: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
6602: FND_LOG.STRING(g_level_statement,
6603: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6604: 'RETURN_STATUS = ' || x_return_status);
6605: FND_LOG.STRING(g_level_statement,
6606: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6607: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
6608: END IF;
6609: RETURN;

Line 6749: FND_LOG.STRING(g_level_statement,

6745: l_error_buffer);
6746:
6747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6748: IF (g_level_statement >= g_current_runtime_level ) THEN
6749: FND_LOG.STRING(g_level_statement,
6750: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6751: 'Incorrect return_status after calling ' ||
6752: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
6753: FND_LOG.STRING(g_level_statement,

Line 6753: FND_LOG.STRING(g_level_statement,

6749: FND_LOG.STRING(g_level_statement,
6750: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6751: 'Incorrect return_status after calling ' ||
6752: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
6753: FND_LOG.STRING(g_level_statement,
6754: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6755: 'RETURN_STATUS = ' || x_return_status);
6756: FND_LOG.STRING(g_level_statement,
6757: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 6756: FND_LOG.STRING(g_level_statement,

6752: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
6753: FND_LOG.STRING(g_level_statement,
6754: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6755: 'RETURN_STATUS = ' || x_return_status);
6756: FND_LOG.STRING(g_level_statement,
6757: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6758: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
6759: END IF;
6760: RETURN;

Line 6779: FND_LOG.STRING(g_level_statement,

6775: l_error_buffer);
6776:
6777: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6778: IF (g_level_statement >= g_current_runtime_level ) THEN
6779: FND_LOG.STRING(g_level_statement,
6780: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6781: 'Incorrect return_status after calling ' ||
6782: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
6783: FND_LOG.STRING(g_level_statement,

Line 6783: FND_LOG.STRING(g_level_statement,

6779: FND_LOG.STRING(g_level_statement,
6780: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6781: 'Incorrect return_status after calling ' ||
6782: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
6783: FND_LOG.STRING(g_level_statement,
6784: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6785: 'RETURN_STATUS = ' || x_return_status);
6786: FND_LOG.STRING(g_level_statement,
6787: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 6786: FND_LOG.STRING(g_level_statement,

6782: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
6783: FND_LOG.STRING(g_level_statement,
6784: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6785: 'RETURN_STATUS = ' || x_return_status);
6786: FND_LOG.STRING(g_level_statement,
6787: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6788: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
6789: END IF;
6790: RETURN;

Line 6812: FND_LOG.STRING(g_level_statement,

6808: l_error_buffer);
6809:
6810: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6811: IF (g_level_statement >= g_current_runtime_level ) THEN
6812: FND_LOG.STRING(g_level_statement,
6813: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6814: 'Incorrect return_status after calling ' ||
6815: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
6816: FND_LOG.STRING(g_level_statement,

Line 6816: FND_LOG.STRING(g_level_statement,

6812: FND_LOG.STRING(g_level_statement,
6813: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6814: 'Incorrect return_status after calling ' ||
6815: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
6816: FND_LOG.STRING(g_level_statement,
6817: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6818: 'RETURN_STATUS = ' || x_return_status);
6819: FND_LOG.STRING(g_level_statement,
6820: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 6819: FND_LOG.STRING(g_level_statement,

6815: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
6816: FND_LOG.STRING(g_level_statement,
6817: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6818: 'RETURN_STATUS = ' || x_return_status);
6819: FND_LOG.STRING(g_level_statement,
6820: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6821: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
6822: END IF;
6823: RETURN;

Line 6926: FND_LOG.STRING(g_level_statement,

6922: x_return_status => x_return_status);
6923:
6924: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6925: IF (g_level_statement >= g_current_runtime_level ) THEN
6926: FND_LOG.STRING(g_level_statement,
6927: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6928: 'Incorrect return_status after calling ' ||
6929: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
6930: FND_LOG.STRING(g_level_statement,

Line 6930: FND_LOG.STRING(g_level_statement,

6926: FND_LOG.STRING(g_level_statement,
6927: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6928: 'Incorrect return_status after calling ' ||
6929: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
6930: FND_LOG.STRING(g_level_statement,
6931: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6932: 'RETURN_STATUS = ' || x_return_status);
6933: FND_LOG.STRING(g_level_statement,
6934: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 6933: FND_LOG.STRING(g_level_statement,

6929: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
6930: FND_LOG.STRING(g_level_statement,
6931: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6932: 'RETURN_STATUS = ' || x_return_status);
6933: FND_LOG.STRING(g_level_statement,
6934: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6935: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
6936: END IF;
6937: RETURN;

Line 6980: FND_LOG.STRING(g_level_statement,

6976: l_error_buffer );
6977:
6978: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6979: IF (g_level_statement >= g_current_runtime_level ) THEN
6980: FND_LOG.STRING(g_level_statement,
6981: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6982: 'Incorrect return_status after calling ' ||
6983: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
6984: FND_LOG.STRING(g_level_statement,

Line 6984: FND_LOG.STRING(g_level_statement,

6980: FND_LOG.STRING(g_level_statement,
6981: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6982: 'Incorrect return_status after calling ' ||
6983: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
6984: FND_LOG.STRING(g_level_statement,
6985: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6986: 'RETURN_STATUS = ' || x_return_status);
6987: FND_LOG.STRING(g_level_statement,
6988: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 6987: FND_LOG.STRING(g_level_statement,

6983: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
6984: FND_LOG.STRING(g_level_statement,
6985: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6986: 'RETURN_STATUS = ' || x_return_status);
6987: FND_LOG.STRING(g_level_statement,
6988: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6989: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
6990: END IF;
6991: RETURN;

Line 6996: FND_LOG.STRING(g_level_procedure,

6992: END IF;
6993: END IF; -- l_account_seg_value IS NOT NULL
6994: IF (g_level_procedure >= g_current_runtime_level ) THEN
6995:
6996: FND_LOG.STRING(g_level_procedure,
6997: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
6998: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)'||x_return_status);
6999: END IF;
7000:

Line 7005: FND_LOG.STRING(g_level_unexpected,

7001: EXCEPTION
7002: WHEN OTHERS THEN
7003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7004: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7005: FND_LOG.STRING(g_level_unexpected,
7006: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7007: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
7008: FND_LOG.STRING(g_level_unexpected,
7009: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',

Line 7008: FND_LOG.STRING(g_level_unexpected,

7004: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7005: FND_LOG.STRING(g_level_unexpected,
7006: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7007: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
7008: FND_LOG.STRING(g_level_unexpected,
7009: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account.END',
7010: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account(-)');
7011: END IF;
7012:

Line 7136: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7132: l_is_valid BOOLEAN;
7133:
7134: BEGIN
7135:
7136: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7137:
7138: IF (g_level_procedure >= g_current_runtime_level ) THEN
7139: FND_LOG.STRING(g_level_procedure,
7140: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.BEGIN',

Line 7139: FND_LOG.STRING(g_level_procedure,

7135:
7136: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7137:
7138: IF (g_level_procedure >= g_current_runtime_level ) THEN
7139: FND_LOG.STRING(g_level_procedure,
7140: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.BEGIN',
7141: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(+)');
7142: END IF;
7143:

Line 7179: FND_LOG.STRING(g_level_statement,

7175:
7176: x_return_status := FND_API.G_RET_STS_ERROR;
7177: l_error_buffer := 'No Tax Rate Found in AR for the specified Tax Rate Id';
7178: IF (g_level_statement >= g_current_runtime_level ) THEN
7179: FND_LOG.STRING(g_level_statement,
7180: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7181: l_error_buffer);
7182: FND_LOG.STRING(g_level_statement,
7183: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',

Line 7182: FND_LOG.STRING(g_level_statement,

7178: IF (g_level_statement >= g_current_runtime_level ) THEN
7179: FND_LOG.STRING(g_level_statement,
7180: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7181: l_error_buffer);
7182: FND_LOG.STRING(g_level_statement,
7183: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7184: 'RETURN_STATUS = ' || x_return_status);
7185: FND_LOG.STRING(g_level_statement,
7186: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7185: FND_LOG.STRING(g_level_statement,

7181: l_error_buffer);
7182: FND_LOG.STRING(g_level_statement,
7183: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7184: 'RETURN_STATUS = ' || x_return_status);
7185: FND_LOG.STRING(g_level_statement,
7186: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7187: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7188: END IF;
7189: RETURN;

Line 7214: FND_LOG.STRING(g_level_statement,

7210:
7211: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7212: l_is_valid := FALSE;
7213: IF (g_level_statement >= g_current_runtime_level ) THEN
7214: FND_LOG.STRING(g_level_statement,
7215: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7216: 'Incorrect return_status after calling ' ||
7217: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7218: FND_LOG.STRING(g_level_statement,

Line 7218: FND_LOG.STRING(g_level_statement,

7214: FND_LOG.STRING(g_level_statement,
7215: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7216: 'Incorrect return_status after calling ' ||
7217: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7218: FND_LOG.STRING(g_level_statement,
7219: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7220: 'RETURN_STATUS = ' || x_return_status);
7221: FND_LOG.STRING(g_level_statement,
7222: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7221: FND_LOG.STRING(g_level_statement,

7217: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7218: FND_LOG.STRING(g_level_statement,
7219: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7220: 'RETURN_STATUS = ' || x_return_status);
7221: FND_LOG.STRING(g_level_statement,
7222: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7223: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7224: END IF;
7225: /*IF tax_line_rec.tax_amt <> 0 THEN

Line 7248: FND_LOG.STRING(g_level_statement,

7244:
7245: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7246: l_is_valid := FALSE;
7247: IF (g_level_statement >= g_current_runtime_level ) THEN
7248: FND_LOG.STRING(g_level_statement,
7249: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7250: 'Incorrect return_status after calling ' ||
7251: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7252: FND_LOG.STRING(g_level_statement,

Line 7252: FND_LOG.STRING(g_level_statement,

7248: FND_LOG.STRING(g_level_statement,
7249: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7250: 'Incorrect return_status after calling ' ||
7251: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7252: FND_LOG.STRING(g_level_statement,
7253: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7254: 'RETURN_STATUS = ' || x_return_status);
7255: FND_LOG.STRING(g_level_statement,
7256: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7255: FND_LOG.STRING(g_level_statement,

7251: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7252: FND_LOG.STRING(g_level_statement,
7253: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7254: 'RETURN_STATUS = ' || x_return_status);
7255: FND_LOG.STRING(g_level_statement,
7256: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7257: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7258: END IF;
7259: /*IF tax_line_rec.tax_amt <> 0 THEN

Line 7295: FND_LOG.STRING(g_level_statement,

7291:
7292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7293: l_is_valid := FALSE;
7294: IF (g_level_statement >= g_current_runtime_level ) THEN
7295: FND_LOG.STRING(g_level_statement,
7296: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7297: 'Incorrect return_status after calling ' ||
7298: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7299: FND_LOG.STRING(g_level_statement,

Line 7299: FND_LOG.STRING(g_level_statement,

7295: FND_LOG.STRING(g_level_statement,
7296: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7297: 'Incorrect return_status after calling ' ||
7298: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7299: FND_LOG.STRING(g_level_statement,
7300: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7301: 'RETURN_STATUS = ' || x_return_status);
7302: FND_LOG.STRING(g_level_statement,
7303: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 7302: FND_LOG.STRING(g_level_statement,

7298: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7299: FND_LOG.STRING(g_level_statement,
7300: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7301: 'RETURN_STATUS = ' || x_return_status);
7302: FND_LOG.STRING(g_level_statement,
7303: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
7304: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
7305: END IF;
7306: /*IF tax_line_rec.tax_amt <> 0 THEN

Line 7333: FND_LOG.STRING(g_level_statement,

7329:
7330: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7331: l_is_valid := FALSE;
7332: IF (g_level_statement >= g_current_runtime_level ) THEN
7333: FND_LOG.STRING(g_level_statement,
7334: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7335: 'Incorrect return_status after calling ' ||
7336: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7337: FND_LOG.STRING(g_level_statement,

Line 7337: FND_LOG.STRING(g_level_statement,

7333: FND_LOG.STRING(g_level_statement,
7334: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7335: 'Incorrect return_status after calling ' ||
7336: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7337: FND_LOG.STRING(g_level_statement,
7338: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7339: 'RETURN_STATUS = ' || x_return_status);
7340: FND_LOG.STRING(g_level_statement,
7341: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7340: FND_LOG.STRING(g_level_statement,

7336: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7337: FND_LOG.STRING(g_level_statement,
7338: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7339: 'RETURN_STATUS = ' || x_return_status);
7340: FND_LOG.STRING(g_level_statement,
7341: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7342: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7343: END IF;
7344: /*IF tax_line_rec.tax_amt <> 0 THEN

Line 7372: FND_LOG.STRING(g_level_statement,

7368:
7369: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7370: l_is_valid := FALSE;
7371: IF (g_level_statement >= g_current_runtime_level ) THEN
7372: FND_LOG.STRING(g_level_statement,
7373: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7374: 'Incorrect return_status after calling ' ||
7375: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7376: FND_LOG.STRING(g_level_statement,

Line 7376: FND_LOG.STRING(g_level_statement,

7372: FND_LOG.STRING(g_level_statement,
7373: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7374: 'Incorrect return_status after calling ' ||
7375: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7376: FND_LOG.STRING(g_level_statement,
7377: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7378: 'RETURN_STATUS = ' || x_return_status);
7379: FND_LOG.STRING(g_level_statement,
7380: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7379: FND_LOG.STRING(g_level_statement,

7375: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7376: FND_LOG.STRING(g_level_statement,
7377: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7378: 'RETURN_STATUS = ' || x_return_status);
7379: FND_LOG.STRING(g_level_statement,
7380: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7381: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7382: END IF;
7383: /*IF tax_line_rec.tax_amt <> 0 THEN

Line 7398: FND_LOG.STRING(g_level_statement,

7394: x_return_status := FND_API.G_RET_STS_ERROR;
7395: l_error_buffer := 'Tax Rate Code is not adhoc';
7396:
7397: IF (g_level_statement >= g_current_runtime_level ) THEN
7398: FND_LOG.STRING(g_level_statement,
7399: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7400: l_error_buffer);
7401: FND_LOG.STRING(g_level_statement,
7402: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',

Line 7401: FND_LOG.STRING(g_level_statement,

7397: IF (g_level_statement >= g_current_runtime_level ) THEN
7398: FND_LOG.STRING(g_level_statement,
7399: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7400: l_error_buffer);
7401: FND_LOG.STRING(g_level_statement,
7402: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7403: 'RETURN_STATUS = ' || x_return_status);
7404: FND_LOG.STRING(g_level_statement,
7405: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7404: FND_LOG.STRING(g_level_statement,

7400: l_error_buffer);
7401: FND_LOG.STRING(g_level_statement,
7402: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7403: 'RETURN_STATUS = ' || x_return_status);
7404: FND_LOG.STRING(g_level_statement,
7405: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7406: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7407: END IF;
7408: RETURN;

Line 7427: FND_LOG.STRING(g_level_statement,

7423: x_return_status := FND_API.G_RET_STS_ERROR;
7424: l_error_buffer := 'Need to create Offset Tax. But offset tax is not allowed';
7425:
7426: IF g_level_statement >= g_current_runtime_level THEN
7427: FND_LOG.STRING(g_level_statement,
7428: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7429: l_error_buffer);
7430: FND_LOG.STRING(g_level_statement,
7431: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',

Line 7430: FND_LOG.STRING(g_level_statement,

7426: IF g_level_statement >= g_current_runtime_level THEN
7427: FND_LOG.STRING(g_level_statement,
7428: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7429: l_error_buffer);
7430: FND_LOG.STRING(g_level_statement,
7431: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7432: 'RETURN_STATUS = ' || x_return_status);
7433: FND_LOG.STRING(g_level_statement,
7434: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7433: FND_LOG.STRING(g_level_statement,

7429: l_error_buffer);
7430: FND_LOG.STRING(g_level_statement,
7431: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7432: 'RETURN_STATUS = ' || x_return_status);
7433: FND_LOG.STRING(g_level_statement,
7434: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7435: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7436: END IF;
7437: RETURN;

Line 7479: FND_LOG.STRING(g_level_statement,

7475: --
7476: x_return_status := FND_API.G_RET_STS_SUCCESS;
7477:
7478: IF g_level_statement >= g_current_runtime_level THEN
7479: FND_LOG.STRING(g_level_statement,
7480: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7481: 'RETURN_STATUS = ' || x_return_status);
7482: FND_LOG.STRING(g_level_statement,
7483: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',

Line 7482: FND_LOG.STRING(g_level_statement,

7478: IF g_level_statement >= g_current_runtime_level THEN
7479: FND_LOG.STRING(g_level_statement,
7480: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7481: 'RETURN_STATUS = ' || x_return_status);
7482: FND_LOG.STRING(g_level_statement,
7483: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7484: 'Remove this tax line and reset return_status');
7485: END IF;
7486:

Line 7520: FND_LOG.STRING(g_level_statement,

7516: IF l_tax IS NOT NULL THEN
7517: l_tax_found_in_ap_flag := 'Y';
7518:
7519: IF (g_level_statement >= g_current_runtime_level ) THEN
7520: FND_LOG.STRING(g_level_statement,
7521: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7522: 'Tax rate code is defined in Payables.');
7523: END IF;
7524:

Line 7528: FND_LOG.STRING(g_level_statement,

7524:
7525: ELSE -- l_tax IS NULL
7526:
7527: IF (g_level_statement >= g_current_runtime_level ) THEN
7528: FND_LOG.STRING(g_level_statement,
7529: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7530: 'Tax rate code is not defined in Payables.');
7531: END IF;
7532:

Line 7547: FND_LOG.STRING(g_level_statement,

7543: --
7544: x_return_status := FND_API.G_RET_STS_ERROR;
7545: l_error_buffer := 'tax_amt <> 0. Tax Rate Code is not adhoc';
7546: IF (g_level_statement >= g_current_runtime_level ) THEN
7547: FND_LOG.STRING(g_level_statement,
7548: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7549: 'Tax rate code is not defined in AP and other product.');
7550: FND_LOG.STRING(g_level_statement,
7551: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',

Line 7550: FND_LOG.STRING(g_level_statement,

7546: IF (g_level_statement >= g_current_runtime_level ) THEN
7547: FND_LOG.STRING(g_level_statement,
7548: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7549: 'Tax rate code is not defined in AP and other product.');
7550: FND_LOG.STRING(g_level_statement,
7551: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7552: 'RETURN_STATUS = ' || x_return_status);
7553: FND_LOG.STRING(g_level_statement,
7554: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7553: FND_LOG.STRING(g_level_statement,

7549: 'Tax rate code is not defined in AP and other product.');
7550: FND_LOG.STRING(g_level_statement,
7551: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7552: 'RETURN_STATUS = ' || x_return_status);
7553: FND_LOG.STRING(g_level_statement,
7554: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7555: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7556: END IF;
7557: RETURN;

Line 7573: FND_LOG.STRING(g_level_statement,

7569: l_error_buffer);
7570:
7571: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7572: IF (g_level_statement >= g_current_runtime_level ) THEN
7573: FND_LOG.STRING(g_level_statement,
7574: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7575: 'Incorrect return_status after calling ' ||
7576: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7577: FND_LOG.STRING(g_level_statement,

Line 7577: FND_LOG.STRING(g_level_statement,

7573: FND_LOG.STRING(g_level_statement,
7574: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7575: 'Incorrect return_status after calling ' ||
7576: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7577: FND_LOG.STRING(g_level_statement,
7578: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7579: 'RETURN_STATUS = ' || x_return_status);
7580: FND_LOG.STRING(g_level_statement,
7581: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7580: FND_LOG.STRING(g_level_statement,

7576: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
7577: FND_LOG.STRING(g_level_statement,
7578: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7579: 'RETURN_STATUS = ' || x_return_status);
7580: FND_LOG.STRING(g_level_statement,
7581: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7582: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7583: END IF;
7584: RETURN;

Line 7604: FND_LOG.STRING(g_level_statement,

7600: l_error_buffer);
7601:
7602: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7603: IF (g_level_statement >= g_current_runtime_level ) THEN
7604: FND_LOG.STRING(g_level_statement,
7605: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7606: 'Incorrect return_status after calling ' ||
7607: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7608: FND_LOG.STRING(g_level_statement,

Line 7608: FND_LOG.STRING(g_level_statement,

7604: FND_LOG.STRING(g_level_statement,
7605: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7606: 'Incorrect return_status after calling ' ||
7607: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7608: FND_LOG.STRING(g_level_statement,
7609: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7610: 'RETURN_STATUS = ' || x_return_status);
7611: FND_LOG.STRING(g_level_statement,
7612: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7611: FND_LOG.STRING(g_level_statement,

7607: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
7608: FND_LOG.STRING(g_level_statement,
7609: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7610: 'RETURN_STATUS = ' || x_return_status);
7611: FND_LOG.STRING(g_level_statement,
7612: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7613: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7614: END IF;
7615: RETURN;

Line 7645: FND_LOG.STRING(g_level_statement,

7641: l_error_buffer);
7642:
7643: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7644: IF (g_level_statement >= g_current_runtime_level ) THEN
7645: FND_LOG.STRING(g_level_statement,
7646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7647: 'Incorrect return_status after calling ' ||
7648: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7649: FND_LOG.STRING(g_level_statement,

Line 7649: FND_LOG.STRING(g_level_statement,

7645: FND_LOG.STRING(g_level_statement,
7646: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7647: 'Incorrect return_status after calling ' ||
7648: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7649: FND_LOG.STRING(g_level_statement,
7650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7651: 'RETURN_STATUS = ' || x_return_status);
7652: FND_LOG.STRING(g_level_statement,
7653: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',

Line 7652: FND_LOG.STRING(g_level_statement,

7648: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info');
7649: FND_LOG.STRING(g_level_statement,
7650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
7651: 'RETURN_STATUS = ' || x_return_status);
7652: FND_LOG.STRING(g_level_statement,
7653: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines.END',
7654: 'ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(-)');
7655: END IF;
7656: RETURN;

Line 7678: FND_LOG.STRING(g_level_statement,

7674: l_error_buffer);
7675:
7676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7677: IF (g_level_statement >= g_current_runtime_level ) THEN
7678: FND_LOG.STRING(g_level_statement,
7679: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7680: 'Incorrect return_status after calling ' ||
7681: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7682: FND_LOG.STRING(g_level_statement,

Line 7682: FND_LOG.STRING(g_level_statement,

7678: FND_LOG.STRING(g_level_statement,
7679: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7680: 'Incorrect return_status after calling ' ||
7681: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7682: FND_LOG.STRING(g_level_statement,
7683: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7684: 'RETURN_STATUS = ' || x_return_status);
7685: FND_LOG.STRING(g_level_statement,
7686: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7685: FND_LOG.STRING(g_level_statement,

7681: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
7682: FND_LOG.STRING(g_level_statement,
7683: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7684: 'RETURN_STATUS = ' || x_return_status);
7685: FND_LOG.STRING(g_level_statement,
7686: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7687: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7688: END IF;
7689: RETURN;

Line 7717: FND_LOG.STRING(g_level_statement,

7713: l_error_buffer);
7714:
7715: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7716: IF (g_level_statement >= g_current_runtime_level ) THEN
7717: FND_LOG.STRING(g_level_statement,
7718: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7719: 'Incorrect return_status after calling ' ||
7720: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7721: FND_LOG.STRING(g_level_statement,

Line 7721: FND_LOG.STRING(g_level_statement,

7717: FND_LOG.STRING(g_level_statement,
7718: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7719: 'Incorrect return_status after calling ' ||
7720: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7721: FND_LOG.STRING(g_level_statement,
7722: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7723: 'RETURN_STATUS = ' || x_return_status);
7724: FND_LOG.STRING(g_level_statement,
7725: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7724: FND_LOG.STRING(g_level_statement,

7720: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
7721: FND_LOG.STRING(g_level_statement,
7722: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7723: 'RETURN_STATUS = ' || x_return_status);
7724: FND_LOG.STRING(g_level_statement,
7725: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7726: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7727: END IF;
7728: RETURN;

Line 7738: FND_LOG.STRING(g_level_statement,

7734:
7735: x_return_status := FND_API.G_RET_STS_ERROR;
7736: l_error_buffer := 'Tax Rate Code is not adhoc';
7737: IF (g_level_statement >= g_current_runtime_level ) THEN
7738: FND_LOG.STRING(g_level_statement,
7739: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7740: l_error_buffer);
7741: FND_LOG.STRING(g_level_statement,
7742: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',

Line 7741: FND_LOG.STRING(g_level_statement,

7737: IF (g_level_statement >= g_current_runtime_level ) THEN
7738: FND_LOG.STRING(g_level_statement,
7739: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7740: l_error_buffer);
7741: FND_LOG.STRING(g_level_statement,
7742: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7743: 'RETURN_STATUS = ' || x_return_status);
7744: FND_LOG.STRING(g_level_statement,
7745: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7744: FND_LOG.STRING(g_level_statement,

7740: l_error_buffer);
7741: FND_LOG.STRING(g_level_statement,
7742: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7743: 'RETURN_STATUS = ' || x_return_status);
7744: FND_LOG.STRING(g_level_statement,
7745: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7746: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7747: END IF;
7748: RETURN;

Line 7778: FND_LOG.STRING(g_level_statement,

7774: x_return_status := FND_API.G_RET_STS_ERROR;
7775: l_error_buffer := 'Need to create Offset Tax. But offset tax is not allowed';
7776:
7777: IF g_level_statement >= g_current_runtime_level THEN
7778: FND_LOG.STRING(g_level_statement,
7779: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7780: l_error_buffer);
7781: FND_LOG.STRING(g_level_statement,
7782: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',

Line 7781: FND_LOG.STRING(g_level_statement,

7777: IF g_level_statement >= g_current_runtime_level THEN
7778: FND_LOG.STRING(g_level_statement,
7779: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7780: l_error_buffer);
7781: FND_LOG.STRING(g_level_statement,
7782: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7783: 'RETURN_STATUS = ' || x_return_status);
7784: FND_LOG.STRING(g_level_statement,
7785: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7784: FND_LOG.STRING(g_level_statement,

7780: l_error_buffer);
7781: FND_LOG.STRING(g_level_statement,
7782: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7783: 'RETURN_STATUS = ' || x_return_status);
7784: FND_LOG.STRING(g_level_statement,
7785: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7786: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7787: END IF;
7788: RETURN;

Line 7832: FND_LOG.STRING(g_level_statement,

7828: x_return_status => x_return_status);
7829:
7830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7831: IF (g_level_statement >= g_current_runtime_level ) THEN
7832: FND_LOG.STRING(g_level_statement,
7833: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7834: 'Incorrect return_status after calling ' ||
7835: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
7836: FND_LOG.STRING(g_level_statement,

Line 7836: FND_LOG.STRING(g_level_statement,

7832: FND_LOG.STRING(g_level_statement,
7833: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7834: 'Incorrect return_status after calling ' ||
7835: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
7836: FND_LOG.STRING(g_level_statement,
7837: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7838: 'RETURN_STATUS = ' || x_return_status);
7839: FND_LOG.STRING(g_level_statement,
7840: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7839: FND_LOG.STRING(g_level_statement,

7835: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
7836: FND_LOG.STRING(g_level_statement,
7837: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7838: 'RETURN_STATUS = ' || x_return_status);
7839: FND_LOG.STRING(g_level_statement,
7840: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7841: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7842: END IF;
7843: RETURN;

Line 7862: FND_LOG.STRING(g_level_statement,

7858: l_error_buffer );
7859:
7860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7861: IF (g_level_statement >= g_current_runtime_level ) THEN
7862: FND_LOG.STRING(g_level_statement,
7863: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7864: 'Incorrect RETURN_STATUS after calling '||
7865: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
7866: FND_LOG.STRING(g_level_statement,

Line 7866: FND_LOG.STRING(g_level_statement,

7862: FND_LOG.STRING(g_level_statement,
7863: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7864: 'Incorrect RETURN_STATUS after calling '||
7865: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
7866: FND_LOG.STRING(g_level_statement,
7867: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7868: 'RETURN_STATUS = ' || x_return_status);
7869: FND_LOG.STRING(g_level_statement,
7870: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7869: FND_LOG.STRING(g_level_statement,

7865: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
7866: FND_LOG.STRING(g_level_statement,
7867: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7868: 'RETURN_STATUS = ' || x_return_status);
7869: FND_LOG.STRING(g_level_statement,
7870: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7871: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7872: END IF;
7873: RETURN;

Line 7877: FND_LOG.STRING(g_level_procedure,

7873: RETURN;
7874: END IF;
7875:
7876: IF (g_level_procedure >= g_current_runtime_level ) THEN
7877: FND_LOG.STRING(g_level_procedure,
7878: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7879: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)'||x_return_status);
7880: END IF;
7881:

Line 7886: FND_LOG.STRING(g_level_unexpected,

7882: EXCEPTION
7883: WHEN OTHERS THEN
7884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7885: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7886: FND_LOG.STRING(g_level_unexpected,
7887: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7888: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
7889: FND_LOG.STRING(g_level_unexpected,
7890: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',

Line 7889: FND_LOG.STRING(g_level_unexpected,

7885: IF (g_level_unexpected >= g_current_runtime_level ) THEN
7886: FND_LOG.STRING(g_level_unexpected,
7887: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7888: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
7889: FND_LOG.STRING(g_level_unexpected,
7890: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx.END',
7891: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx(-)');
7892: END IF;
7893:

Line 8163: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

8159: l_exception_rate zx_lines.exception_rate%TYPE;
8160:
8161: BEGIN
8162:
8163: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8164:
8165: IF (g_level_procedure >= g_current_runtime_level ) THEN
8166: FND_LOG.STRING(g_level_procedure,
8167: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.BEGIN',

Line 8166: FND_LOG.STRING(g_level_procedure,

8162:
8163: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8164:
8165: IF (g_level_procedure >= g_current_runtime_level ) THEN
8166: FND_LOG.STRING(g_level_procedure,
8167: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.BEGIN',
8168: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(+)');
8169: END IF;
8170:

Line 8338: FND_LOG.STRING(g_level_statement,

8334: x_return_status);
8335:
8336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8337: IF (g_level_statement >= g_current_runtime_level ) THEN
8338: FND_LOG.STRING(g_level_statement,
8339: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8340: 'Incorrect return_status after calling ' ||
8341: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
8342: FND_LOG.STRING(g_level_statement,

Line 8342: FND_LOG.STRING(g_level_statement,

8338: FND_LOG.STRING(g_level_statement,
8339: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8340: 'Incorrect return_status after calling ' ||
8341: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
8342: FND_LOG.STRING(g_level_statement,
8343: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8344: 'RETURN_STATUS = ' || x_return_status);
8345: FND_LOG.STRING(g_level_statement,
8346: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 8345: FND_LOG.STRING(g_level_statement,

8341: 'ZX_TDS_UTILITIES_PKG.get_tax_index');
8342: FND_LOG.STRING(g_level_statement,
8343: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8344: 'RETURN_STATUS = ' || x_return_status);
8345: FND_LOG.STRING(g_level_statement,
8346: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
8347: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
8348: END IF;
8349: RETURN;

Line 8412: FND_LOG.STRING(g_level_statement,

8408:
8409: for i in 1.. nvl(l_action_rec_tbl.last,0) loop
8410:
8411: IF (g_level_statement >= g_current_runtime_level ) THEN
8412: FND_LOG.STRING(g_level_statement,
8413: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8414: 'action code ' ||
8415: l_action_rec_tbl(i).action_code);
8416: END IF;

Line 8420: FND_LOG.STRING(g_level_error,

8416: END IF;
8417: if upper(l_action_rec_tbl(i).action_code) in ('ERROR_MESSAGE','SYSTEM_ERROR') then
8418: x_return_status := FND_API.G_RET_STS_ERROR;
8419: IF (g_level_error >= g_current_runtime_level ) THEN
8420: FND_LOG.STRING(g_level_error,
8421: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
8422: 'Action_code is ERROR_MESSAGE,SYSTEM_ERROR');
8423: END IF;
8424:

Line 8492: FND_LOG.STRING(g_level_error,

8488:
8489: p_return_status := FND_API.G_RET_STS_ERROR;
8490: p_error_buffer := SUBSTR(SQLERRM, 1, 80);
8491: IF (g_level_error >= g_current_runtime_level ) THEN
8492: FND_LOG.STRING(g_level_error,
8493: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
8494: 'Cannot set the tax rate code to '||l_override_tax_rate_code ||
8495: ', ERROR: '||p_error_buffer);
8496: END IF;

Line 8529: FND_LOG.STRING(g_level_error,

8525: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','The action value for APPLY_EXCEPTION action code'||
8526: 'does not contain number');
8527: FND_MSG_PUB.Add;
8528: IF (g_level_error >= g_current_runtime_level ) THEN
8529: FND_LOG.STRING(g_level_error,
8530: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',
8531: 'The action value for APPLY_EXCEPTION action code '||
8532: 'does not contain number');
8533: END IF;

Line 8609: FND_LOG.STRING(g_level_statement,

8605: l_rate_exists_same_prod_family := FALSE;
8606: -- tax not applicable. goto the next record
8607: --
8608: IF (g_level_statement >= g_current_runtime_level ) THEN
8609: FND_LOG.STRING(g_level_statement,
8610: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8611: 'Tax Rate does not exist in this product family group. ');
8612: END IF;
8613: ELSE

Line 8639: FND_LOG.STRING(g_level_statement,

8635: IF (l_tax_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax AND
8636: l_tax_regime_code_tbl(j) = ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_index).tax_regime_code)
8637: THEN
8638: IF (g_level_statement >= g_current_runtime_level ) THEN
8639: FND_LOG.STRING(g_level_statement,
8640: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
8641: 'tax found in tax cache, at index '||
8642: to_char(l_index));
8643: END IF;

Line 8698: FND_LOG.STRING(g_level_statement,

8694: x_return_status => x_return_status);
8695:
8696: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8697: IF (g_level_statement >= g_current_runtime_level ) THEN
8698: FND_LOG.STRING(g_level_statement,
8699: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8700: 'Incorrect return_status after calling ' ||
8701: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply');
8702: END IF;

Line 8712: FND_LOG.STRING(g_level_statement,

8708: NVL(l_tax_rec.record_type_code, 'USER_DEFINED') = 'MIGRATED'
8709: THEN
8710: x_return_status := FND_API.G_RET_STS_SUCCESS;
8711: IF (g_level_statement >= g_current_runtime_level ) THEN
8712: FND_LOG.STRING(g_level_statement,
8713: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8714: 'For migrated taxes, if the has_other_jurisdictions_flag on ' ||
8715: 'the tax is N, no jurisdiction required. Continue processing tax... ');
8716: END IF;

Line 8720: FND_LOG.STRING(g_level_statement,

8716: END IF;
8717:
8718: ELSE
8719: IF (g_level_statement >= g_current_runtime_level ) THEN
8720: FND_LOG.STRING(g_level_statement,
8721: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8722: 'Unable to determine the Place of Supply for tax: '||l_tax_rec.tax||
8723: ' Place of Supply is mandatory when Direct Rate Determination is for l usocation based taxes');
8724: FND_LOG.STRING(g_level_statement,

Line 8724: FND_LOG.STRING(g_level_statement,

8720: FND_LOG.STRING(g_level_statement,
8721: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8722: 'Unable to determine the Place of Supply for tax: '||l_tax_rec.tax||
8723: ' Place of Supply is mandatory when Direct Rate Determination is for l usocation based taxes');
8724: FND_LOG.STRING(g_level_statement,
8725: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
8726: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)'||', RETURN_STATUS = ' || x_return_status);
8727: END IF;
8728:

Line 8752: FND_LOG.STRING(g_level_statement,

8748:
8749: IF l_jurisdiction_rec_tbl.COUNT = 0 THEN
8750:
8751: IF (g_level_statement >= g_current_runtime_level ) THEN
8752: FND_LOG.STRING(g_level_statement,
8753: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8754: 'No data found in ZX_JURISDICTIONS_GT when multiple jurisdictions found.');
8755: END IF;
8756: RAISE NO_DATA_FOUND;

Line 8773: FND_LOG.STRING(g_level_statement,

8769: g_outer_jurisdiction_id
8770: := l_jurisdiction_rec_tbl(l_jur_index).tax_jurisdiction_id;
8771:
8772: IF (g_level_statement >= g_current_runtime_level ) THEN
8773: FND_LOG.STRING(g_level_statement,
8774: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8775: 'g_inner_jurisdiction_code = '|| g_inner_jurisdiction_code||'g_outer_jurisdiction_code = '|| g_outer_jurisdiction_code);
8776:
8777: END IF;

Line 8796: FND_LOG.STRING(g_level_statement,

8792: g_outer_jurisdiction_id
8793: := l_jurisdiction_rec.tax_jurisdiction_id;
8794:
8795: IF (g_level_statement >= g_current_runtime_level ) THEN
8796: FND_LOG.STRING(g_level_statement,
8797: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8798: 'g_inner_jurisdiction_code = '|| g_inner_jurisdiction_code|| 'g_outer_jurisdiction_code = '|| g_outer_jurisdiction_code);
8799:
8800: END IF;

Line 8827: FND_LOG.STRING(g_level_statement,

8823: x_return_status => x_return_status);
8824:
8825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8826: IF (g_level_statement >= g_current_runtime_level ) THEN
8827: FND_LOG.STRING(g_level_statement,
8828: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
8829: 'Incorrect return_status after calling ' ||
8830: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
8831: FND_LOG.STRING(g_level_statement,

Line 8831: FND_LOG.STRING(g_level_statement,

8827: FND_LOG.STRING(g_level_statement,
8828: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
8829: 'Incorrect return_status after calling ' ||
8830: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
8831: FND_LOG.STRING(g_level_statement,
8832: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
8833: 'RETURN_STATUS = ' || x_return_status);
8834: FND_LOG.STRING(g_level_statement,
8835: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',

Line 8834: FND_LOG.STRING(g_level_statement,

8830: 'ZX_TDS_APPLICABILITY_DETM_PKG.is_tax_applicable');
8831: FND_LOG.STRING(g_level_statement,
8832: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
8833: 'RETURN_STATUS = ' || x_return_status);
8834: FND_LOG.STRING(g_level_statement,
8835: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes.END',
8836: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes(-)');
8837: END IF;
8838: RETURN;

Line 8867: FND_LOG.STRING(g_level_statement,

8863: l_error_buffer);
8864:
8865: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8866: IF (g_level_statement >= g_current_runtime_level ) THEN
8867: FND_LOG.STRING(g_level_statement,
8868: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8869: 'Incorrect return_status after calling ' ||
8870: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
8871: FND_LOG.STRING(g_level_statement,

Line 8871: FND_LOG.STRING(g_level_statement,

8867: FND_LOG.STRING(g_level_statement,
8868: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8869: 'Incorrect return_status after calling ' ||
8870: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
8871: FND_LOG.STRING(g_level_statement,
8872: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8873: 'RETURN_STATUS = ' || x_return_status);
8874: FND_LOG.STRING(g_level_statement,
8875: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 8874: FND_LOG.STRING(g_level_statement,

8870: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info');
8871: FND_LOG.STRING(g_level_statement,
8872: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8873: 'RETURN_STATUS = ' || x_return_status);
8874: FND_LOG.STRING(g_level_statement,
8875: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
8876: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
8877: END IF;
8878: RETURN;

Line 8919: FND_LOG.STRING(g_level_statement,

8915: l_error_buffer);
8916:
8917: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8918: IF (g_level_statement >= g_current_runtime_level ) THEN
8919: FND_LOG.STRING(g_level_statement,
8920: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8921: 'Incorrect return_status after calling ' ||
8922: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
8923: FND_LOG.STRING(g_level_statement,

Line 8923: FND_LOG.STRING(g_level_statement,

8919: FND_LOG.STRING(g_level_statement,
8920: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8921: 'Incorrect return_status after calling ' ||
8922: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
8923: FND_LOG.STRING(g_level_statement,
8924: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8925: 'RETURN_STATUS = ' || x_return_status);
8926: FND_LOG.STRING(g_level_statement,
8927: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 8926: FND_LOG.STRING(g_level_statement,

8922: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
8923: FND_LOG.STRING(g_level_statement,
8924: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8925: 'RETURN_STATUS = ' || x_return_status);
8926: FND_LOG.STRING(g_level_statement,
8927: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
8928: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
8929: END IF;
8930: RETURN;

Line 8993: FND_LOG.STRING(g_level_statement,

8989:
8990:
8991: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8992: IF (g_level_statement >= g_current_runtime_level ) THEN
8993: FND_LOG.STRING(g_level_statement,
8994: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8995: 'Incorrect return_status after calling ' ||
8996: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
8997: FND_LOG.STRING(g_level_statement,

Line 8997: FND_LOG.STRING(g_level_statement,

8993: FND_LOG.STRING(g_level_statement,
8994: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8995: 'Incorrect return_status after calling ' ||
8996: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
8997: FND_LOG.STRING(g_level_statement,
8998: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8999: 'RETURN_STATUS = ' || x_return_status);
9000: FND_LOG.STRING(g_level_statement,
9001: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 9000: FND_LOG.STRING(g_level_statement,

8996: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
8997: FND_LOG.STRING(g_level_statement,
8998: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
8999: 'RETURN_STATUS = ' || x_return_status);
9000: FND_LOG.STRING(g_level_statement,
9001: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
9002: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
9003: END IF;
9004: RETURN;

Line 9032: FND_LOG.STRING(g_level_statement,

9028: x_return_status);
9029:
9030: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9031: IF (g_level_statement >= g_current_runtime_level ) THEN
9032: FND_LOG.STRING(g_level_statement,
9033: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9034: 'Incorrect return_status after calling ' ||
9035: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results');
9036: FND_LOG.STRING(g_level_statement,

Line 9036: FND_LOG.STRING(g_level_statement,

9032: FND_LOG.STRING(g_level_statement,
9033: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9034: 'Incorrect return_status after calling ' ||
9035: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results');
9036: FND_LOG.STRING(g_level_statement,
9037: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9038: 'RETURN_STATUS = ' || x_return_status);
9039: FND_LOG.STRING(g_level_statement,
9040: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 9039: FND_LOG.STRING(g_level_statement,

9035: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results');
9036: FND_LOG.STRING(g_level_statement,
9037: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9038: 'RETURN_STATUS = ' || x_return_status);
9039: FND_LOG.STRING(g_level_statement,
9040: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
9041: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
9042: END IF;
9043: RETURN;

Line 9178: FND_LOG.STRING(g_level_statement,

9174: x_return_status => x_return_status);
9175:
9176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9177: IF (g_level_statement >= g_current_runtime_level ) THEN
9178: FND_LOG.STRING(g_level_statement,
9179: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9180: 'Incorrect return_status after calling ' ||
9181: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
9182: FND_LOG.STRING(g_level_statement,

Line 9182: FND_LOG.STRING(g_level_statement,

9178: FND_LOG.STRING(g_level_statement,
9179: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9180: 'Incorrect return_status after calling ' ||
9181: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
9182: FND_LOG.STRING(g_level_statement,
9183: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9184: 'RETURN_STATUS = ' || x_return_status);
9185: FND_LOG.STRING(g_level_statement,
9186: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 9185: FND_LOG.STRING(g_level_statement,

9181: 'ZX_TDS_APPLICABILITY_DETM_PKG.populate_registration_info');
9182: FND_LOG.STRING(g_level_statement,
9183: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9184: 'RETURN_STATUS = ' || x_return_status);
9185: FND_LOG.STRING(g_level_statement,
9186: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
9187: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
9188: END IF;
9189: RETURN;

Line 9281: FND_LOG.STRING(g_level_error,

9277: l_tax_regime_rec.effective_to,
9278: x_return_status );
9279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9280: IF (g_level_error >= g_current_runtime_level ) THEN
9281: FND_LOG.STRING(g_level_error,
9282: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
9283: 'Incorrect return_status after calling ' ||
9284: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
9285: FND_LOG.STRING(g_level_error,

Line 9285: FND_LOG.STRING(g_level_error,

9281: FND_LOG.STRING(g_level_error,
9282: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
9283: 'Incorrect return_status after calling ' ||
9284: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
9285: FND_LOG.STRING(g_level_error,
9286: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
9287: 'RETURN_STATUS = ' || x_return_status);
9288: FND_LOG.STRING(g_level_error,
9289: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',

Line 9288: FND_LOG.STRING(g_level_error,

9284: 'ZX_TDS_APPLICABILITY_DETM_PKG.add_tax_regime');
9285: FND_LOG.STRING(g_level_error,
9286: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes',
9287: 'RETURN_STATUS = ' || x_return_status);
9288: FND_LOG.STRING(g_level_error,
9289: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes.END',
9290: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_regimes(-)');
9291: END IF;
9292: RETURN;

Line 9344: FND_LOG.STRING(g_level_statement,

9340: l_error_buffer );
9341:
9342: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9343: IF (g_level_statement >= g_current_runtime_level ) THEN
9344: FND_LOG.STRING(g_level_statement,
9345: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9346: 'Incorrect RETURN_STATUS after calling '||
9347: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
9348: FND_LOG.STRING(g_level_statement,

Line 9348: FND_LOG.STRING(g_level_statement,

9344: FND_LOG.STRING(g_level_statement,
9345: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9346: 'Incorrect RETURN_STATUS after calling '||
9347: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
9348: FND_LOG.STRING(g_level_statement,
9349: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9350: 'RETURN_STATUS = ' || x_return_status);
9351: FND_LOG.STRING(g_level_statement,
9352: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 9351: FND_LOG.STRING(g_level_statement,

9347: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
9348: FND_LOG.STRING(g_level_statement,
9349: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9350: 'RETURN_STATUS = ' || x_return_status);
9351: FND_LOG.STRING(g_level_statement,
9352: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
9353: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
9354: END IF;
9355: RETURN;

Line 9361: FND_LOG.STRING(g_level_procedure,

9357: END IF; -- line_level_action = 'CREATE', 'UPDATE', 'CREATE_TAX_ONLY'
9358:
9359: END IF;
9360: IF (g_level_procedure >= g_current_runtime_level ) THEN
9361: FND_LOG.STRING(g_level_procedure,
9362: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
9363: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
9364: END IF;
9365:

Line 9372: FND_LOG.STRING(g_level_unexpected,

9368: WHEN OTHERS THEN
9369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9370: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
9371: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9372: FND_LOG.STRING(g_level_unexpected,
9373: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9374: l_error_buffer);
9375: FND_LOG.STRING(g_level_unexpected,
9376: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',

Line 9375: FND_LOG.STRING(g_level_unexpected,

9371: IF (g_level_unexpected >= g_current_runtime_level ) THEN
9372: FND_LOG.STRING(g_level_unexpected,
9373: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9374: l_error_buffer);
9375: FND_LOG.STRING(g_level_unexpected,
9376: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results.END',
9377: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
9378: END IF;
9379: END get_process_results;

Line 9484: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9480: ORDER BY tax_apportionment_line_number;
9481:
9482: BEGIN
9483:
9484: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9485:
9486: IF (g_level_procedure >= g_current_runtime_level ) THEN
9487: FND_LOG.STRING(g_level_procedure,
9488: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.BEGIN',

Line 9487: FND_LOG.STRING(g_level_procedure,

9483:
9484: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9485:
9486: IF (g_level_procedure >= g_current_runtime_level ) THEN
9487: FND_LOG.STRING(g_level_procedure,
9488: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.BEGIN',
9489: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(+)');
9490: END IF;
9491:

Line 9517: FND_LOG.STRING(g_level_procedure,

9513: IF l_tax_line_rec.cancel_flag = 'Y' THEN
9514: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_row_num) :=
9515: l_tax_line_rec;
9516: IF (g_level_procedure >= g_current_runtime_level ) THEN
9517: FND_LOG.STRING(g_level_procedure,
9518: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.BEGIN',
9519: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9520: END IF;
9521: RETURN;

Line 9573: FND_LOG.STRING(g_level_procedure,

9569: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9570: p_row_num).TAX_RATE_TYPE := l_tax_line_rec.tax_rate_type;
9571:
9572: IF (g_level_procedure >= g_current_runtime_level ) THEN
9573: FND_LOG.STRING(g_level_procedure,
9574: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9575: 'Value for TAX_RATE_TYPE '||ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9576: p_row_num).TAX_RATE_TYPE);
9577: END IF;

Line 9649: FND_LOG.STRING(g_level_error,

9645: l_error_buffer);
9646:
9647: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9648: IF (g_level_error >= g_current_runtime_level ) THEN
9649: FND_LOG.STRING(g_level_error,
9650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9651: 'Incorrect return_status after calling '||
9652: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9653: FND_LOG.STRING(g_level_error,

Line 9653: FND_LOG.STRING(g_level_error,

9649: FND_LOG.STRING(g_level_error,
9650: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9651: 'Incorrect return_status after calling '||
9652: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9653: FND_LOG.STRING(g_level_error,
9654: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9655: 'RETURN_STATUS = ' || x_return_status);
9656: FND_LOG.STRING(g_level_error,
9657: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 9656: FND_LOG.STRING(g_level_error,

9652: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9653: FND_LOG.STRING(g_level_error,
9654: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9655: 'RETURN_STATUS = ' || x_return_status);
9656: FND_LOG.STRING(g_level_error,
9657: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
9658: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9659: END IF;
9660: CLOSE get_key_columns_cur;

Line 9700: FND_LOG.STRING(g_level_error,

9696: l_error_buffer);
9697:
9698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9699: IF (g_level_error >= g_current_runtime_level ) THEN
9700: FND_LOG.STRING(g_level_error,
9701: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9702: 'Incorrect return_status after calling '||
9703: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9704: FND_LOG.STRING(g_level_error,

Line 9704: FND_LOG.STRING(g_level_error,

9700: FND_LOG.STRING(g_level_error,
9701: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9702: 'Incorrect return_status after calling '||
9703: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9704: FND_LOG.STRING(g_level_error,
9705: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9706: 'RETURN_STATUS = ' || x_return_status);
9707: FND_LOG.STRING(g_level_error,
9708: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 9707: FND_LOG.STRING(g_level_error,

9703: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9704: FND_LOG.STRING(g_level_error,
9705: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9706: 'RETURN_STATUS = ' || x_return_status);
9707: FND_LOG.STRING(g_level_error,
9708: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
9709: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9710: END IF;
9711: CLOSE get_key_columns_cur;

Line 9735: FND_LOG.STRING(g_level_error,

9731: l_error_buffer);
9732:
9733: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9734: IF (g_level_error >= g_current_runtime_level ) THEN
9735: FND_LOG.STRING(g_level_error,
9736: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9737: 'Incorrect return_status after calling '||
9738: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9739: FND_LOG.STRING(g_level_error,

Line 9739: FND_LOG.STRING(g_level_error,

9735: FND_LOG.STRING(g_level_error,
9736: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9737: 'Incorrect return_status after calling '||
9738: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9739: FND_LOG.STRING(g_level_error,
9740: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9741: 'RETURN_STATUS = ' || x_return_status);
9742: FND_LOG.STRING(g_level_error,
9743: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 9742: FND_LOG.STRING(g_level_error,

9738: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9739: FND_LOG.STRING(g_level_error,
9740: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9741: 'RETURN_STATUS = ' || x_return_status);
9742: FND_LOG.STRING(g_level_error,
9743: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
9744: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9745: END IF;
9746: CLOSE get_key_columns_cur;

Line 9787: FND_LOG.STRING(g_level_error,

9783: l_error_buffer);
9784:
9785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9786: IF (g_level_error >= g_current_runtime_level ) THEN
9787: FND_LOG.STRING(g_level_error,
9788: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9789: 'Incorrect return_status after calling '||
9790: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9791: FND_LOG.STRING(g_level_error,

Line 9791: FND_LOG.STRING(g_level_error,

9787: FND_LOG.STRING(g_level_error,
9788: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9789: 'Incorrect return_status after calling '||
9790: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9791: FND_LOG.STRING(g_level_error,
9792: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9793: 'RETURN_STATUS = ' || x_return_status);
9794: FND_LOG.STRING(g_level_error,
9795: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 9794: FND_LOG.STRING(g_level_error,

9790: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9791: FND_LOG.STRING(g_level_error,
9792: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9793: 'RETURN_STATUS = ' || x_return_status);
9794: FND_LOG.STRING(g_level_error,
9795: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
9796: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9797: END IF;
9798: CLOSE get_key_columns_cur;

Line 9822: FND_LOG.STRING(g_level_error,

9818: l_error_buffer);
9819:
9820: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9821: IF (g_level_error >= g_current_runtime_level ) THEN
9822: FND_LOG.STRING(g_level_error,
9823: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9824: 'Incorrect return_status after calling '||
9825: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9826: FND_LOG.STRING(g_level_error,

Line 9826: FND_LOG.STRING(g_level_error,

9822: FND_LOG.STRING(g_level_error,
9823: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9824: 'Incorrect return_status after calling '||
9825: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9826: FND_LOG.STRING(g_level_error,
9827: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9828: 'RETURN_STATUS = ' || x_return_status);
9829: FND_LOG.STRING(g_level_error,
9830: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 9829: FND_LOG.STRING(g_level_error,

9825: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9826: FND_LOG.STRING(g_level_error,
9827: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9828: 'RETURN_STATUS = ' || x_return_status);
9829: FND_LOG.STRING(g_level_error,
9830: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
9831: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9832: END IF;
9833: CLOSE get_key_columns_cur;

Line 9896: FND_LOG.STRING(g_level_error,

9892: l_error_buffer);
9893:
9894: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9895: IF (g_level_error >= g_current_runtime_level ) THEN
9896: FND_LOG.STRING(g_level_error,
9897: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9898: 'Incorrect return_status after calling '||
9899: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9900: FND_LOG.STRING(g_level_error,

Line 9900: FND_LOG.STRING(g_level_error,

9896: FND_LOG.STRING(g_level_error,
9897: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9898: 'Incorrect return_status after calling '||
9899: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9900: FND_LOG.STRING(g_level_error,
9901: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9902: 'RETURN_STATUS = ' || x_return_status);
9903: FND_LOG.STRING(g_level_error,
9904: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 9903: FND_LOG.STRING(g_level_error,

9899: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.');
9900: FND_LOG.STRING(g_level_error,
9901: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9902: 'RETURN_STATUS = ' || x_return_status);
9903: FND_LOG.STRING(g_level_error,
9904: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
9905: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9906: END IF;
9907: CLOSE get_key_columns_cur;

Line 9931: FND_LOG.STRING(g_level_error,

9927: l_error_buffer);
9928:
9929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9930: IF (g_level_error >= g_current_runtime_level ) THEN
9931: FND_LOG.STRING(g_level_error,
9932: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9933: 'Incorrect return_status after calling '||
9934: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9935: FND_LOG.STRING(g_level_error,

Line 9935: FND_LOG.STRING(g_level_error,

9931: FND_LOG.STRING(g_level_error,
9932: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9933: 'Incorrect return_status after calling '||
9934: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9935: FND_LOG.STRING(g_level_error,
9936: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9937: 'RETURN_STATUS = ' || x_return_status);
9938: FND_LOG.STRING(g_level_error,
9939: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 9938: FND_LOG.STRING(g_level_error,

9934: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info.');
9935: FND_LOG.STRING(g_level_error,
9936: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9937: 'RETURN_STATUS = ' || x_return_status);
9938: FND_LOG.STRING(g_level_error,
9939: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
9940: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
9941: END IF;
9942: CLOSE get_key_columns_cur;

Line 9995: FND_LOG.STRING(g_level_statement,

9991: * FROM dual;
9992: */
9993:
9994: IF (g_level_statement >= g_current_runtime_level ) THEN
9995: FND_LOG.STRING(g_level_statement,
9996: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
9997: 'get_key_columns_cur NOTFOUND..');
9998: END IF;
9999:

Line 10006: FND_LOG.STRING(g_level_procedure,

10002:
10003: CLOSE get_key_columns_cur;
10004:
10005: IF (g_level_procedure >= g_current_runtime_level ) THEN
10006: FND_LOG.STRING(g_level_procedure,
10007: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.BEGIN',
10008: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
10009: END IF;
10010:

Line 10017: FND_LOG.STRING(g_level_unexpected,

10013: CLOSE get_key_columns_cur;
10014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10015: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
10016: IF (g_level_unexpected >= g_current_runtime_level ) THEN
10017: FND_LOG.STRING(g_level_unexpected,
10018: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10019: l_error_buffer);
10020: FND_LOG.STRING(g_level_unexpected,
10021: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',

Line 10020: FND_LOG.STRING(g_level_unexpected,

10016: IF (g_level_unexpected >= g_current_runtime_level ) THEN
10017: FND_LOG.STRING(g_level_unexpected,
10018: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios',
10019: l_error_buffer);
10020: FND_LOG.STRING(g_level_unexpected,
10021: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios.END',
10022: 'ZX_TDS_APPLICABILITY_DETM_PKG.handle_update_scenarios(-)');
10023: END IF;
10024: END handle_update_scenarios;

Line 10088: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

10084: AND mrc_tax_line_flag = 'N';
10085:
10086: BEGIN
10087:
10088: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10089:
10090: IF (g_level_procedure >= g_current_runtime_level ) THEN
10091: FND_LOG.STRING(g_level_procedure,
10092: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.BEGIN',

Line 10091: FND_LOG.STRING(g_level_procedure,

10087:
10088: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10089:
10090: IF (g_level_procedure >= g_current_runtime_level ) THEN
10091: FND_LOG.STRING(g_level_procedure,
10092: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.BEGIN',
10093: 'ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc(+)');
10094: END IF;
10095:

Line 10140: FND_LOG.STRING(g_level_statement,

10136: l_error_buffer);
10137:
10138: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10139: IF (g_level_statement >= g_current_runtime_level ) THEN
10140: FND_LOG.STRING(g_level_statement,
10141: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10142: 'Incorrect return_status after calling ' ||
10143: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
10144: FND_LOG.STRING(g_level_statement,

Line 10144: FND_LOG.STRING(g_level_statement,

10140: FND_LOG.STRING(g_level_statement,
10141: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10142: 'Incorrect return_status after calling ' ||
10143: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
10144: FND_LOG.STRING(g_level_statement,
10145: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10146: 'RETURN_STATUS = ' || x_return_status);
10147: FND_LOG.STRING(g_level_statement,
10148: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.END',

Line 10147: FND_LOG.STRING(g_level_statement,

10143: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
10144: FND_LOG.STRING(g_level_statement,
10145: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10146: 'RETURN_STATUS = ' || x_return_status);
10147: FND_LOG.STRING(g_level_statement,
10148: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.END',
10149: 'ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results(-)');
10150: END IF;
10151: RETURN;

Line 10159: FND_LOG.STRING(g_level_statement,

10155: i).tax_status_id := l_tax_status_rec.tax_status_id;
10156:
10157: ELSE
10158: IF g_level_statement >= g_current_runtime_level THEN
10159: FND_LOG.STRING(g_level_statement,
10160: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10161: 'enforce_tax_from_ref_doc_flag is turned on, but tax status'||
10162: 'code and tax rate code are not available from reference doc.');
10163: END IF;

Line 10172: FND_LOG.STRING(g_level_procedure,

10168:
10169: END LOOP; -- i IN NVL(x_begin_index, -1) .. NVL(x_end_index, 0)
10170:
10171: IF (g_level_procedure >= g_current_runtime_level ) THEN
10172: FND_LOG.STRING(g_level_procedure,
10173: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.BEGIN',
10174: 'ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc(-)');
10175: END IF;
10176:

Line 10182: FND_LOG.STRING(g_level_error,

10178: WHEN NO_DATA_FOUND THEN
10179: x_return_status := FND_API.G_RET_STS_ERROR;
10180: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
10181: IF (g_level_error >= g_current_runtime_level ) THEN
10182: FND_LOG.STRING(g_level_error,
10183: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10184: l_error_buffer);
10185: FND_LOG.STRING(g_level_error,
10186: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.END',

Line 10185: FND_LOG.STRING(g_level_error,

10181: IF (g_level_error >= g_current_runtime_level ) THEN
10182: FND_LOG.STRING(g_level_error,
10183: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10184: l_error_buffer);
10185: FND_LOG.STRING(g_level_error,
10186: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.END',
10187: 'ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc(-)');
10188: END IF;
10189:

Line 10194: FND_LOG.STRING(g_level_unexpected,

10190: WHEN OTHERS THEN
10191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10192: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
10193: IF (g_level_unexpected >= g_current_runtime_level ) THEN
10194: FND_LOG.STRING(g_level_unexpected,
10195: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10196: l_error_buffer);
10197: FND_LOG.STRING(g_level_unexpected,
10198: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.END',

Line 10197: FND_LOG.STRING(g_level_unexpected,

10193: IF (g_level_unexpected >= g_current_runtime_level ) THEN
10194: FND_LOG.STRING(g_level_unexpected,
10195: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc',
10196: l_error_buffer);
10197: FND_LOG.STRING(g_level_unexpected,
10198: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc.END',
10199: 'ZX_TDS_APPLICABILITY_DETM_PKG.enforce_tax_from_ref_doc(-)');
10200: END IF;
10201: END enforce_tax_from_ref_doc;