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

APPS.ZX_TDS_RATE_DETM_PKG dependencies on FND_LOG

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

1: PACKAGE BODY ZX_TDS_RATE_DETM_PKG AS
2: /* $Header: zxditxratedtpkgb.pls 120.108 2011/05/28 07:58:08 ssanka ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

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

2: /* $Header: zxditxratedtpkgb.pls 120.108 2011/05/28 07:58:08 ssanka ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------

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

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------
11: -- PRIVATE PROCEDURE

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

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: ------------------------------------------------------------------------------
11: -- PRIVATE PROCEDURE
12: ------------------------------------------------------------------------------

Line 144: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 147: FND_LOG.STRING(g_level_procedure,

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

Line 160: FND_LOG.STRING(g_level_error,

156: IF p_begin_index IS NULL or p_end_index IS NULL THEN
157: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
158: IF (g_level_error >= g_current_runtime_level ) THEN
159:
160: FND_LOG.STRING(g_level_error,
161: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
162: ' unexpected error:' || 'p_begin_index or p_end_index IS NULL...');
163: END IF;
164: RETURN;

Line 182: FND_LOG.STRING(g_level_statement,

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

Line 205: FND_LOG.STRING(g_level_statement,

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

Line 214: FND_LOG.STRING(g_level_statement,

210: l_multiple_jurisdictions_flag :=
211: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).multiple_jurisdictions_flag, 'N');
212:
213: IF (g_level_statement >= g_current_runtime_level ) THEN
214: FND_LOG.STRING(g_level_statement,
215: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
216: 'Multiple Jurisdictions Flag : ' || l_multiple_jurisdictions_flag);
217: END IF;
218:

Line 239: FND_LOG.STRING(g_level_error,

235: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
236: p_error_buffer :=
237: 'Tax Rate must be entered when last manual entry is Tax Amount';
238: IF (g_level_error >= g_current_runtime_level ) THEN
239: FND_LOG.STRING(g_level_error,
240: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
241: 'p_error_buffer: '|| p_error_buffer);
242: END IF;
243: RETURN;

Line 323: FND_LOG.STRING(g_level_error,

319: END IF;
320:
321: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
322: IF (g_level_error >= g_current_runtime_level ) THEN
323: FND_LOG.STRING(g_level_error,
324: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
325: 'Incorrect return_status after calling get_tax_rate proc.');
326: FND_LOG.STRING(g_level_error,
327: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 326: FND_LOG.STRING(g_level_error,

322: IF (g_level_error >= g_current_runtime_level ) THEN
323: FND_LOG.STRING(g_level_error,
324: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
325: 'Incorrect return_status after calling get_tax_rate proc.');
326: FND_LOG.STRING(g_level_error,
327: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
328: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
329: END IF;
330:

Line 386: FND_LOG.STRING(g_level_statement,

382: x_return_status => p_return_status,
383: x_error_buffer => p_error_buffer);
384: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
385: IF (g_level_statement >= g_current_runtime_level ) THEN
386: FND_LOG.STRING(g_level_statement,
387: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
388: 'Offset tax not found, reset the return status and continue the process');
389: END IF;
390: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 413: FND_LOG.STRING(g_level_error,

409: p_error_buffer);
410:
411: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
412: IF (g_level_error >= g_current_runtime_level ) THEN
413: FND_LOG.STRING(g_level_error,
414: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
415: 'Incorrect return_status after calling ' ||
416: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
417: FND_LOG.STRING(g_level_error,

Line 417: FND_LOG.STRING(g_level_error,

413: FND_LOG.STRING(g_level_error,
414: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
415: 'Incorrect return_status after calling ' ||
416: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
417: FND_LOG.STRING(g_level_error,
418: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
419: 'l_account_site_id = ' || l_account_site_id);
420: FND_LOG.STRING(g_level_error,
421: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 420: FND_LOG.STRING(g_level_error,

416: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
417: FND_LOG.STRING(g_level_error,
418: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
419: 'l_account_site_id = ' || l_account_site_id);
420: FND_LOG.STRING(g_level_error,
421: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
422: 'RETURN_STATUS = ' || p_return_status);
423: FND_LOG.STRING(g_level_error,
424: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 423: FND_LOG.STRING(g_level_error,

419: 'l_account_site_id = ' || l_account_site_id);
420: FND_LOG.STRING(g_level_error,
421: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
422: 'RETURN_STATUS = ' || p_return_status);
423: FND_LOG.STRING(g_level_error,
424: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
425: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
426: END IF;
427: RETURN;

Line 441: FND_LOG.STRING(g_level_error,

437: p_error_buffer);
438:
439: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
440: IF (g_level_error >= g_current_runtime_level ) THEN
441: FND_LOG.STRING(g_level_error,
442: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
443: 'Incorrect return_status after calling ' ||
444: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
445: FND_LOG.STRING(g_level_error,

Line 445: FND_LOG.STRING(g_level_error,

441: FND_LOG.STRING(g_level_error,
442: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
443: 'Incorrect return_status after calling ' ||
444: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
445: FND_LOG.STRING(g_level_error,
446: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
447: 'l_account_id = ' || l_account_id);
448: FND_LOG.STRING(g_level_error,
449: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 448: FND_LOG.STRING(g_level_error,

444: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
445: FND_LOG.STRING(g_level_error,
446: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
447: 'l_account_id = ' || l_account_id);
448: FND_LOG.STRING(g_level_error,
449: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
450: 'RETURN_STATUS = ' || p_return_status);
451: FND_LOG.STRING(g_level_error,
452: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 451: FND_LOG.STRING(g_level_error,

447: 'l_account_id = ' || l_account_id);
448: FND_LOG.STRING(g_level_error,
449: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
450: 'RETURN_STATUS = ' || p_return_status);
451: FND_LOG.STRING(g_level_error,
452: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
453: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
454: END IF;
455: RETURN;

Line 463: FND_LOG.STRING(g_level_error,

459: FETCH get_ap_supplier_site_csr INTO l_offset_tax_appl;
460: CLOSE get_ap_supplier_site_csr;
461:
462: IF (g_level_error >= g_current_runtime_level ) THEN
463: FND_LOG.STRING(g_level_error,
464: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
465: 'l_account_site_id = '||l_account_site_id);
466: FND_LOG.STRING(g_level_error,
467: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 466: FND_LOG.STRING(g_level_error,

462: IF (g_level_error >= g_current_runtime_level ) THEN
463: FND_LOG.STRING(g_level_error,
464: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
465: 'l_account_site_id = '||l_account_site_id);
466: FND_LOG.STRING(g_level_error,
467: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
468: 'l_offset_tax_appl = '||l_offset_tax_appl);
469: END IF;
470:

Line 486: FND_LOG.STRING(g_level_error,

482: p_error_buffer);
483:
484: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
485: IF (g_level_error >= g_current_runtime_level ) THEN
486: FND_LOG.STRING(g_level_error,
487: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
488: 'Incorrect return_status after calling ' ||
489: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
490: FND_LOG.STRING(g_level_error,

Line 490: FND_LOG.STRING(g_level_error,

486: FND_LOG.STRING(g_level_error,
487: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
488: 'Incorrect return_status after calling ' ||
489: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
490: FND_LOG.STRING(g_level_error,
491: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
492: 'l_account_id = ' || l_account_id);
493: FND_LOG.STRING(g_level_error,
494: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 493: FND_LOG.STRING(g_level_error,

489: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
490: FND_LOG.STRING(g_level_error,
491: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
492: 'l_account_id = ' || l_account_id);
493: FND_LOG.STRING(g_level_error,
494: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
495: 'RETURN_STATUS = ' || p_return_status);
496: FND_LOG.STRING(g_level_error,
497: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 496: FND_LOG.STRING(g_level_error,

492: 'l_account_id = ' || l_account_id);
493: FND_LOG.STRING(g_level_error,
494: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
495: 'RETURN_STATUS = ' || p_return_status);
496: FND_LOG.STRING(g_level_error,
497: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
498: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
499: END IF;
500: RETURN;

Line 508: FND_LOG.STRING(g_level_error,

504: FETCH get_ap_supplier_csr INTO l_offset_tax_appl;
505: CLOSE get_ap_supplier_csr;
506:
507: IF (g_level_error >= g_current_runtime_level ) THEN
508: FND_LOG.STRING(g_level_error,
509: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
510: 'l_account_id = '||l_account_id);
511: FND_LOG.STRING(g_level_error,
512: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 511: FND_LOG.STRING(g_level_error,

507: IF (g_level_error >= g_current_runtime_level ) THEN
508: FND_LOG.STRING(g_level_error,
509: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
510: 'l_account_id = '||l_account_id);
511: FND_LOG.STRING(g_level_error,
512: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
513: 'l_offset_tax_appl= '||l_offset_tax_appl);
514: END IF;
515: END IF; -- l_reg_party_type = 'PARTY' OR 'SITE'

Line 532: FND_LOG.STRING(g_level_error,

528: FETCH get_ptp_cur into l_offset_tax_appl;
529: CLOSE get_ptp_cur;
530:
531: IF (g_level_error >= g_current_runtime_level ) THEN
532: FND_LOG.STRING(g_level_error,
533: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
534: 'l_offset_tax_appl(from PTP) = '||l_offset_tax_appl);
535: END IF;
536: END IF;

Line 540: FND_LOG.STRING(g_level_procedure,

536: END IF;
537:
538: IF nvl(l_offset_tax_appl,'N') = 'Y' THEN
539: IF (g_level_procedure >= g_current_runtime_level ) THEN
540: FND_LOG.STRING(g_level_procedure,
541: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
542: 'Offset tax applicable...');
543: END IF;
544: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';

Line 548: FND_LOG.STRING(g_level_statement,

544: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'Y';
545: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).offset_tax_rate_code := l_offset_tax_rate_code;
546: ELSE
547: IF (g_level_statement >= g_current_runtime_level ) THEN
548: FND_LOG.STRING(g_level_statement,
549: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
550: 'Offset tax not applicable...');
551: END IF;
552: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Offset_Flag := 'N';

Line 715: FND_LOG.STRING(g_level_error,

711: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
712: p_error_buffer := 'The Tax Status information could not be located in cache.';
713:
714: IF (g_level_error >= g_current_runtime_level ) THEN
715: FND_LOG.STRING(g_level_error,
716: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
717: 'Could not locate the status record in cache....');
718: END IF;
719:

Line 754: FND_LOG.STRING(g_level_error,

750: IF p_return_status IN ( FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR)
751: THEN
752: -- error is raised in rule based evaluation. Abort processing.
753: IF (g_level_error >= g_current_runtime_level ) THEN
754: FND_LOG.STRING(g_level_error,
755: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
756: 'Rule Based engine returned error. Aborting... ');
757: END IF;
758: RETURN;

Line 770: FND_LOG.STRING(g_level_statement,

766: ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id(l_zx_result_rec.result_id,
767: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).trx_date);
768:
769: IF (g_level_statement >= g_current_runtime_level ) THEN
770: FND_LOG.STRING(g_level_statement,
771: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
772: 'l_tax_rate_code returned by rule base process is '||
773: l_zx_result_rec.alphanumeric_result);
774:

Line 799: FND_LOG.STRING(g_level_error,

795: );
796:
797: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
798: IF (g_level_error >= g_current_runtime_level ) THEN
799: FND_LOG.STRING(g_level_error,
800: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
801: 'Incorrect return_status after calling ' ||
802: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
803: FND_LOG.STRING(g_level_error,

Line 803: FND_LOG.STRING(g_level_error,

799: FND_LOG.STRING(g_level_error,
800: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
801: 'Incorrect return_status after calling ' ||
802: 'ZX_TCM_TAX_RATE_PKG.get_tax_rate');
803: FND_LOG.STRING(g_level_error,
804: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
805: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
806: END IF;
807:

Line 869: FND_LOG.STRING(g_level_error,

865: -- UI need to take care of not to allow slabbed tax defined.
866: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR; -- 8568734
867: p_error_buffer := 'Slabbed rates are not supported in phase 1a ';
868: IF (g_level_error >= g_current_runtime_level ) THEN
869: FND_LOG.STRING(g_level_error,
870: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
871: 'p_error_buffer: '|| p_error_buffer);
872: END IF;
873: RETURN;

Line 896: FND_LOG.STRING(g_level_error,

892: p_error_buffer := 'UOM_CODE on the transaction does not match the '||
893: ' UOM_CODE on the rate ';
894:
895: IF (g_level_error >= g_current_runtime_level ) THEN
896: FND_LOG.STRING(g_level_error,
897: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
898: 'The UOM '||l_uom_code||' for quantity rate '||l_tax_rate_code ||
899: ' is not the same as the UOM '||
900: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.uom_code(

Line 926: FND_LOG.STRING(g_level_procedure,

922:
923: END IF;
924:
925: IF (g_level_procedure >= g_current_runtime_level ) THEN
926: FND_LOG.STRING(g_level_procedure,
927: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
928: 'tax rate code: ' ||l_tax_rate_code ||' tax_rate = ' || l_tax_rate);
929: END IF;
930:

Line 935: FND_LOG.STRING(g_level_error,

931: ELSE -- if l_tax_rate_code is NULL
932: p_return_status:= FND_API.G_RET_STS_ERROR; -- error
933:
934: IF (g_level_error>= g_current_runtime_level ) THEN
935: FND_LOG.STRING(g_level_error,
936: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
937: 'Tax_rate_code not found for tax: '|| l_tax ||
938: 'tax_status: '||l_tax_status_code);
939: END IF;

Line 966: FND_LOG.STRING(g_level_error,

962:
963: p_return_status:= FND_API.G_RET_STS_ERROR; -- error
964:
965: IF (g_level_error>= g_current_runtime_level ) THEN
966: FND_LOG.STRING(g_level_error,
967: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
968: 'Tax_rate_code not found for tax: '|| l_tax ||
969: 'tax_status: '||l_tax_status_code);
970: END IF;

Line 988: FND_LOG.STRING(g_level_error,

984: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
985:
986: p_error_buffer := 'Error: No tax rate found';
987: IF (g_level_error >= g_current_runtime_level ) THEN
988: FND_LOG.STRING(g_level_error,
989: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
990: p_error_buffer);
991: END IF;
992: RETURN;

Line 1026: FND_LOG.STRING(g_level_error,

1022: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1023: p_error_buffer := 'Need to create Offset Tax. But offset tax is not valid'; -- will be replaced with coded message
1024:
1025: IF g_level_error >= g_current_runtime_level THEN
1026: FND_LOG.STRING(g_level_error,
1027: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1028: 'Need to create Offset Tax. But offset tax is not valid');
1029: FND_LOG.STRING(g_level_error,
1030: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1029: FND_LOG.STRING(g_level_error,

1025: IF g_level_error >= g_current_runtime_level THEN
1026: FND_LOG.STRING(g_level_error,
1027: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1028: 'Need to create Offset Tax. But offset tax is not valid');
1029: FND_LOG.STRING(g_level_error,
1030: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1031: 'RETURN_STATUS = ' || p_return_status);
1032: FND_LOG.STRING(g_level_error,
1033: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1032: FND_LOG.STRING(g_level_error,

1028: 'Need to create Offset Tax. But offset tax is not valid');
1029: FND_LOG.STRING(g_level_error,
1030: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1031: 'RETURN_STATUS = ' || p_return_status);
1032: FND_LOG.STRING(g_level_error,
1033: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1034: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
1035: END IF;
1036: RETURN;

Line 1068: FND_LOG.STRING(g_level_statement,

1064:
1065: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1066:
1067: IF (g_level_statement >= g_current_runtime_level ) THEN
1068: FND_LOG.STRING(g_level_statement,
1069: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1070: 'Offset tax not found, reset the return status and continue the process');
1071: END IF;
1072: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1101: FND_LOG.STRING(g_level_error,

1097: p_error_buffer);
1098:
1099: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1100: IF (g_level_error >= g_current_runtime_level ) THEN
1101: FND_LOG.STRING(g_level_error,
1102: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1103: 'Incorrect return_status after calling ' ||
1104: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1105: FND_LOG.STRING(g_level_error,

Line 1105: FND_LOG.STRING(g_level_error,

1101: FND_LOG.STRING(g_level_error,
1102: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1103: 'Incorrect return_status after calling ' ||
1104: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1105: FND_LOG.STRING(g_level_error,
1106: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1107: 'l_account_site_id = ' || l_account_site_id);
1108: FND_LOG.STRING(g_level_error,
1109: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1108: FND_LOG.STRING(g_level_error,

1104: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1105: FND_LOG.STRING(g_level_error,
1106: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1107: 'l_account_site_id = ' || l_account_site_id);
1108: FND_LOG.STRING(g_level_error,
1109: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1110: 'RETURN_STATUS = ' || p_return_status);
1111: FND_LOG.STRING(g_level_error,
1112: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1111: FND_LOG.STRING(g_level_error,

1107: 'l_account_site_id = ' || l_account_site_id);
1108: FND_LOG.STRING(g_level_error,
1109: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1110: 'RETURN_STATUS = ' || p_return_status);
1111: FND_LOG.STRING(g_level_error,
1112: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1113: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
1114: END IF;
1115: RETURN;

Line 1130: FND_LOG.STRING(g_level_error,

1126: p_error_buffer);
1127:
1128: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1129: IF (g_level_error >= g_current_runtime_level ) THEN
1130: FND_LOG.STRING(g_level_error,
1131: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1132: 'Incorrect return_status after calling ' ||
1133: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1134: FND_LOG.STRING(g_level_error,

Line 1134: FND_LOG.STRING(g_level_error,

1130: FND_LOG.STRING(g_level_error,
1131: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1132: 'Incorrect return_status after calling ' ||
1133: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1134: FND_LOG.STRING(g_level_error,
1135: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1136: 'l_account_id = ' || l_account_id);
1137: FND_LOG.STRING(g_level_error,
1138: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1137: FND_LOG.STRING(g_level_error,

1133: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1134: FND_LOG.STRING(g_level_error,
1135: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1136: 'l_account_id = ' || l_account_id);
1137: FND_LOG.STRING(g_level_error,
1138: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1139: 'RETURN_STATUS = ' || p_return_status);
1140: FND_LOG.STRING(g_level_error,
1141: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1140: FND_LOG.STRING(g_level_error,

1136: 'l_account_id = ' || l_account_id);
1137: FND_LOG.STRING(g_level_error,
1138: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1139: 'RETURN_STATUS = ' || p_return_status);
1140: FND_LOG.STRING(g_level_error,
1141: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1142: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
1143: END IF;
1144: RETURN;

Line 1153: FND_LOG.STRING(g_level_error,

1149: FETCH get_ap_supplier_site_csr INTO l_offset_tax_appl;
1150: CLOSE get_ap_supplier_site_csr;
1151:
1152: IF (g_level_error >= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_error,
1154: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1155: 'l_account_site_id = '||l_account_site_id);
1156: FND_LOG.STRING(g_level_error,
1157: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1156: FND_LOG.STRING(g_level_error,

1152: IF (g_level_error >= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_error,
1154: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1155: 'l_account_site_id = '||l_account_site_id);
1156: FND_LOG.STRING(g_level_error,
1157: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1158: 'l_offset_tax_appl = '||l_offset_tax_appl);
1159: END IF;
1160:

Line 1177: FND_LOG.STRING(g_level_error,

1173: p_error_buffer);
1174:
1175: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1176: IF (g_level_error >= g_current_runtime_level ) THEN
1177: FND_LOG.STRING(g_level_error,
1178: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1179: 'Incorrect return_status after calling ' ||
1180: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1181: FND_LOG.STRING(g_level_error,

Line 1181: FND_LOG.STRING(g_level_error,

1177: FND_LOG.STRING(g_level_error,
1178: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1179: 'Incorrect return_status after calling ' ||
1180: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1181: FND_LOG.STRING(g_level_error,
1182: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1183: 'l_account_id = ' || l_account_id);
1184: FND_LOG.STRING(g_level_error,
1185: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1184: FND_LOG.STRING(g_level_error,

1180: 'ZX_TDS_RULE_BASE_DETM_PVT.get_tsrm_num_value');
1181: FND_LOG.STRING(g_level_error,
1182: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1183: 'l_account_id = ' || l_account_id);
1184: FND_LOG.STRING(g_level_error,
1185: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1186: 'RETURN_STATUS = ' || p_return_status);
1187: FND_LOG.STRING(g_level_error,
1188: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1187: FND_LOG.STRING(g_level_error,

1183: 'l_account_id = ' || l_account_id);
1184: FND_LOG.STRING(g_level_error,
1185: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1186: 'RETURN_STATUS = ' || p_return_status);
1187: FND_LOG.STRING(g_level_error,
1188: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1189: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)');
1190: END IF;
1191: RETURN;

Line 1199: FND_LOG.STRING(g_level_error,

1195: FETCH get_ap_supplier_csr INTO l_offset_tax_appl;
1196: CLOSE get_ap_supplier_csr;
1197:
1198: IF (g_level_error >= g_current_runtime_level ) THEN
1199: FND_LOG.STRING(g_level_error,
1200: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1201: 'l_account_id = '||l_account_id);
1202: FND_LOG.STRING(g_level_error,
1203: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1202: FND_LOG.STRING(g_level_error,

1198: IF (g_level_error >= g_current_runtime_level ) THEN
1199: FND_LOG.STRING(g_level_error,
1200: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1201: 'l_account_id = '||l_account_id);
1202: FND_LOG.STRING(g_level_error,
1203: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1204: 'l_offset_tax_appl= '||l_offset_tax_appl);
1205: END IF;
1206:

Line 1225: FND_LOG.STRING(g_level_error,

1221: FETCH get_ptp_cur into l_offset_tax_appl;
1222: CLOSE get_ptp_cur;
1223:
1224: IF (g_level_error >= g_current_runtime_level ) THEN
1225: FND_LOG.STRING(g_level_error,
1226: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1227: 'l_offset_tax_appl(from PTP) = '||l_offset_tax_appl);
1228: END IF;
1229:

Line 1251: -- FND_LOG.STRING(g_level_statement,

1247: --THEN
1248: -- -- Error is raised in rule based evaluation. Abort processing.
1249: -- --
1250: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1251: -- FND_LOG.STRING(g_level_statement,
1252: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1253: -- 'Rule Based engine returned error. Aborting... ');
1254: -- END IF;
1255: -- p_return_status:= FND_API.G_RET_STS_ERROR;

Line 1259: -- FND_LOG.STRING(g_level_statement,

1255: -- p_return_status:= FND_API.G_RET_STS_ERROR;
1256: -- p_error_buffer := 'Rule Based engine returned error during offset tax determination ';
1257: --
1258: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1259: -- FND_LOG.STRING(g_level_statement,
1260: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1261: -- 'p_error_buffer: '|| p_error_buffer);
1262: -- END IF;
1263: -- RETURN;

Line 1271: FND_LOG.STRING(g_level_procedure,

1267: IF nvl(l_offset_tax_appl,'N') = 'Y' THEN
1268:
1269: IF (g_level_procedure >= g_current_runtime_level ) THEN
1270:
1271: FND_LOG.STRING(g_level_procedure,
1272: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1273: 'Offset tax applicable...');
1274: END IF;
1275:

Line 1288: -- FND_LOG.STRING(g_level_statement,

1284: ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number :=
1285: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_max_tax_line_number,0)+ 1;
1286:
1287: --IF (g_level_statement >= g_current_runtime_level ) THEN
1288: -- FND_LOG.STRING(g_level_statement,
1289: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1290: -- 'offset_tax_line_number = '||
1291: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1292: -- i).offset_tax_line_number);

Line 1296: FND_LOG.STRING(g_level_statement,

1292: -- i).offset_tax_line_number);
1293: --END IF;
1294: ELSE
1295: IF (g_level_statement >= g_current_runtime_level ) THEN
1296: FND_LOG.STRING(g_level_statement,
1297: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1298: 'Offset tax not applicable...');
1299: END IF;
1300:

Line 1365: FND_LOG.STRING(g_level_error,

1361: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1362:
1363:
1364: IF (g_level_error >= g_current_runtime_level) THEN
1365: FND_LOG.STRING(g_level_error,
1366: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1367: p_error_buffer);
1368: FND_LOG.STRING(g_level_error,
1369: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1368: FND_LOG.STRING(g_level_error,

1364: IF (g_level_error >= g_current_runtime_level) THEN
1365: FND_LOG.STRING(g_level_error,
1366: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1367: p_error_buffer);
1368: FND_LOG.STRING(g_level_error,
1369: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1370: 'l_tax_rate = ' ||l_tax_rate);
1371: FND_LOG.STRING(g_level_error,
1372: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',

Line 1371: FND_LOG.STRING(g_level_error,

1367: p_error_buffer);
1368: FND_LOG.STRING(g_level_error,
1369: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1370: 'l_tax_rate = ' ||l_tax_rate);
1371: FND_LOG.STRING(g_level_error,
1372: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1373: 'l_numeric_result = ' || l_numeric_result);
1374: FND_LOG.STRING(g_level_error,
1375: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',

Line 1374: FND_LOG.STRING(g_level_error,

1370: 'l_tax_rate = ' ||l_tax_rate);
1371: FND_LOG.STRING(g_level_error,
1372: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1373: 'l_numeric_result = ' || l_numeric_result);
1374: FND_LOG.STRING(g_level_error,
1375: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1376: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-) ');
1377: END IF;
1378: RETURN;

Line 1422: FND_LOG.STRING(g_level_error,

1418: );
1419:
1420: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1421: IF (g_level_error >= g_current_runtime_level ) THEN
1422: FND_LOG.STRING(g_level_error,
1423: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1424: 'Incorrect return_status after calling ' ||
1425: 'ZX_TCM_GET_EXCEPT_PKG.get_tax_exceptions');
1426: FND_LOG.STRING(g_level_error,

Line 1426: FND_LOG.STRING(g_level_error,

1422: FND_LOG.STRING(g_level_error,
1423: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1424: 'Incorrect return_status after calling ' ||
1425: 'ZX_TCM_GET_EXCEPT_PKG.get_tax_exceptions');
1426: FND_LOG.STRING(g_level_error,
1427: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1428: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
1429: END IF;
1430:

Line 1469: -- FND_LOG.STRING(g_level_statement,

1465: -- IF ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(
1466: -- l_tax_id).tax_exmpt_source_tax IS NOT NULL
1467: -- THEN
1468: -- IF (g_level_statement >= g_current_runtime_level ) THEN
1469: -- FND_LOG.STRING(g_level_statement,
1470: -- 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1471: -- 'Current tax has a source tax: ' ||
1472: -- ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl(l_tax_id).tax_exmpt_source_tax);
1473: --

Line 1498: FND_LOG.STRING(g_level_statement,

1494: -- END IF;
1495:
1496: IF l_exemption_rec.exemption_id IS NULL THEN
1497: IF (g_level_statement >= g_current_runtime_level ) THEN
1498: FND_LOG.STRING(g_level_statement,
1499: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1500: 'There is no source tax or no source tax exemptions info '||
1501: 'calling TCM exemption API to get exemption info.');
1502: END IF;

Line 1553: FND_LOG.STRING(g_level_error,

1549: x_exemption_rec => l_exemption_rec);
1550:
1551: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1552: IF (g_level_error >= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_error,
1554: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1555: 'Incorrect return_status after calling ' ||
1556: ' ZX_TCM_GET_EXEMPT_PKG.get_tax_exemptions');
1557: FND_LOG.STRING(g_level_error,

Line 1557: FND_LOG.STRING(g_level_error,

1553: FND_LOG.STRING(g_level_error,
1554: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1555: 'Incorrect return_status after calling ' ||
1556: ' ZX_TCM_GET_EXEMPT_PKG.get_tax_exemptions');
1557: FND_LOG.STRING(g_level_error,
1558: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1559: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-)'||p_return_status);
1560: END IF;
1561:

Line 1634: FND_LOG.STRING(g_level_statement,

1630: := l_exemption_rec.percent_exempt / l_tax_rate;
1631: l_tax_rate := l_exemption_rec.percent_exempt;
1632: ELSE
1633: IF (g_level_statement >= g_current_runtime_level ) THEN
1634: FND_LOG.STRING(g_level_statement,
1635: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1636: 'tax_rate is Zero, no exemption needed. ' );
1637: END IF;
1638: END IF;

Line 1693: FND_LOG.STRING(g_level_error,

1689:
1690: p_return_status:= FND_API.G_RET_STS_ERROR;
1691: p_error_buffer := 'The Tax Status information could not be located in cache.';
1692: IF (g_level_error >= g_current_runtime_level ) THEN
1693: FND_LOG.STRING(g_level_error,
1694: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1695: 'Could not locate the status record in cache....');
1696: END IF;
1697: -- Set appropriate message and return

Line 1720: FND_LOG.STRING(g_level_error,

1716: p_return_status:= FND_API.G_RET_STS_ERROR;
1717: p_error_buffer := 'You cannot specify a rate percentage on a tax which '||
1718: ' is not ad-hoc';
1719: IF (g_level_error >= g_current_runtime_level ) THEN
1720: FND_LOG.STRING(g_level_error,
1721: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1722: 'A tax rate cannot be specified on a tax status which '||
1723: 'does not allow ad-hoc rates');
1724: END IF;

Line 1748: FND_LOG.STRING(g_level_error,

1744: p_return_status:= FND_API.G_RET_STS_ERROR;
1745: p_error_buffer := 'The rate is not valid for the tax determination date'||
1746: to_char(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_determine_date);
1747: IF (g_level_error >= g_current_runtime_level ) THEN
1748: FND_LOG.STRING(g_level_error,
1749: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate',
1750: 'p_error_buffer: '|| p_error_buffer);
1751: END IF;
1752:

Line 1781: FND_LOG.STRING(g_level_procedure,

1777:
1778: end loop; -- for tax i.
1779:
1780: IF (g_level_procedure >= g_current_runtime_level ) THEN
1781: FND_LOG.STRING(g_level_procedure,
1782: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.get_tax_rate.END',
1783: 'ZX_TDS_RATE_DETM_PKG.get_tax_rate(-) ');
1784: END IF;
1785:

Line 1792: FND_LOG.STRING(g_level_unexpected,

1788: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1789: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1790:
1791: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1792: FND_LOG.STRING(g_level_unexpected,
1793: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.GET_TAX_RATE',
1794: p_error_buffer);
1795: END IF;
1796:

Line 1812: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1808: p_Rate_Type_Code in zx_rates_b.Rate_Type_Code%TYPE) IS
1809:
1810: begin
1811:
1812: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1813:
1814: IF (g_level_procedure >= g_current_runtime_level ) THEN
1815: FND_LOG.STRING(g_level_procedure,
1816: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.BEGIN',

Line 1815: FND_LOG.STRING(g_level_procedure,

1811:
1812: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1813:
1814: IF (g_level_procedure >= g_current_runtime_level ) THEN
1815: FND_LOG.STRING(g_level_procedure,
1816: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.BEGIN',
1817: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(+) ');
1818: END IF;
1819:

Line 1833: FND_LOG.STRING(g_level_procedure,

1829: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_tax_line_index).legal_message_rate := NULL;
1830: END;
1831:
1832: IF (g_level_procedure >= g_current_runtime_level ) THEN
1833: FND_LOG.STRING(g_level_procedure,
1834: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate.END',
1835: 'ZX_TDS_RATE_DETM_PKG.update_tax_rate(-) ');
1836: END IF;
1837:

Line 1842: FND_LOG.STRING(g_level_unexpected,

1838: EXCEPTION
1839: WHEN OTHERS THEN
1840:
1841: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1842: FND_LOG.STRING(g_level_unexpected,
1843: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.update_tax_rate',
1844: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1845: END IF;
1846:

Line 1899: FND_LOG.STRING(g_level_procedure,

1895: l_offet_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1896: l_offset_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1897: BEGIN
1898: IF (g_level_procedure >= g_current_runtime_level ) THEN
1899: FND_LOG.STRING(g_level_procedure,
1900: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.BEGIN',
1901: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(+)');
1902: END IF;
1903:

Line 1916: FND_LOG.STRING(g_level_error,

1912: x_error_buffer);
1913:
1914: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1915: IF (g_level_error >= g_current_runtime_level ) THEN
1916: FND_LOG.STRING(g_level_error,
1917: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1918: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1919: FND_LOG.STRING(g_level_error,
1920: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

Line 1919: FND_LOG.STRING(g_level_error,

1915: IF (g_level_error >= g_current_runtime_level ) THEN
1916: FND_LOG.STRING(g_level_error,
1917: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1918: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_cache_info');
1919: FND_LOG.STRING(g_level_error,
1920: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1921: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1922: END IF;
1923: RETURN;

Line 1937: FND_LOG.STRING(g_level_error,

1933: x_error_buffer);
1934:
1935: IF NVL(x_return_status, FND_API.G_RET_STS_UNEXP_ERROR) <> FND_API.G_RET_STS_SUCCESS THEN
1936: IF (g_level_error >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_error,
1938: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1939: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
1940: FND_LOG.STRING(g_level_error,
1941: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

Line 1940: FND_LOG.STRING(g_level_error,

1936: IF (g_level_error >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_error,
1938: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1939: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info');
1940: FND_LOG.STRING(g_level_error,
1941: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1942: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1943: END IF;
1944: RETURN;

Line 1959: FND_LOG.STRING(g_level_error,

1955: IF get_offset_info_csr%NOTFOUND THEN
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957: x_error_buffer := 'No data found for the specified tax rate '; -- will replace with coded message
1958: IF (g_level_error >= g_current_runtime_level ) THEN
1959: FND_LOG.STRING(g_level_error,
1960: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1961: 'No data found for the specified offset tax rate');
1962: END IF;
1963: END IF;

Line 1984: FND_LOG.STRING(g_level_error,

1980: l_tax_rate_id := l_offset_tax_rate_rec.tax_rate_id;
1981:
1982: ELSE
1983: IF (g_level_error >= g_current_runtime_level ) THEN
1984: FND_LOG.STRING(g_level_error,
1985: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1986: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
1987: FND_LOG.STRING(g_level_error,
1988: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',

Line 1987: FND_LOG.STRING(g_level_error,

1983: IF (g_level_error >= g_current_runtime_level ) THEN
1984: FND_LOG.STRING(g_level_error,
1985: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax',
1986: 'Incorrect return status after calling ZX_TDS_UTILITIES_PKG.get_tax_rate_info');
1987: FND_LOG.STRING(g_level_error,
1988: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1989: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1990: END IF;
1991: RETURN;

Line 1996: FND_LOG.STRING(g_level_procedure,

1992:
1993: END IF;
1994:
1995: IF (g_level_procedure >= g_current_runtime_level ) THEN
1996: FND_LOG.STRING(g_level_procedure,
1997: 'ZX.PLSQL.ZX_TDS_RATE_DETM_PKG.validate_offset_tax.END',
1998: 'ZX_TDS_RATE_DETM_PKG: validate_offset_tax(-)');
1999: END IF;
2000: EXCEPTION

Line 2005: FND_LOG.STRING(g_level_unexpected,

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

Line 2008: FND_LOG.STRING(g_level_unexpected,

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