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_UTILITIES_PKG dependencies on ZX_TDS_UTILITIES_PKG

Line 1: package body ZX_TDS_UTILITIES_PKG as

1: package body ZX_TDS_UTILITIES_PKG as
2: /* $Header: zxdiutilitiespub.pls 120.50.12020000.3 2013/03/20 06:40:52 srajapar ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 31: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index.BEGIN',

27: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
28:
29: IF (g_level_statement >= g_current_runtime_level ) THEN
30: FND_LOG.STRING(g_level_statement,
31: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index.BEGIN',
32: 'ZX_TDS_UTILITIES_PKG: get_tax_status_index(+)');
33: END IF;
34:
35: l_tbl_index := dbms_utility.get_hash_value(

Line 32: 'ZX_TDS_UTILITIES_PKG: get_tax_status_index(+)');

28:
29: IF (g_level_statement >= g_current_runtime_level ) THEN
30: FND_LOG.STRING(g_level_statement,
31: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index.BEGIN',
32: 'ZX_TDS_UTILITIES_PKG: get_tax_status_index(+)');
33: END IF;
34:
35: l_tbl_index := dbms_utility.get_hash_value(
36: p_tax_regime_code||p_tax||p_tax_status_code,

Line 43: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index.END',

39:
40: IF (g_level_statement >= g_current_runtime_level ) THEN
41:
42: FND_LOG.STRING(g_level_statement,
43: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index.END',
44: 'ZX_TDS_UTILITIES_PKG: get_tax_status_index(-)'||
45: 'tbl index = ' || to_char(l_tbl_index));
46:
47: END IF;

Line 44: 'ZX_TDS_UTILITIES_PKG: get_tax_status_index(-)'||

40: IF (g_level_statement >= g_current_runtime_level ) THEN
41:
42: FND_LOG.STRING(g_level_statement,
43: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index.END',
44: 'ZX_TDS_UTILITIES_PKG: get_tax_status_index(-)'||
45: 'tbl index = ' || to_char(l_tbl_index));
46:
47: END IF;
48:

Line 55: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index',

51: EXCEPTION
52: WHEN OTHERS THEN
53: IF (g_level_unexpected >= g_current_runtime_level ) THEN
54: FND_LOG.STRING(g_level_unexpected,
55: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_index',
56: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
57: END IF;
58: RAISE;
59: END get_tax_status_index;

Line 115: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.BEGIN',

111: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
112:
113: IF (g_level_statement >= g_current_runtime_level ) THEN
114: FND_LOG.STRING(g_level_statement,
115: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.BEGIN',
116: 'ZX_TDS_UTILITIES_PKG: get_tax_status_cache_info(+)'||
117: ' regime code: ' || p_tax_regime_code||
118: ' status code: ' || p_tax_status_code||
119: ' tax: ' || p_tax);

Line 116: 'ZX_TDS_UTILITIES_PKG: get_tax_status_cache_info(+)'||

112:
113: IF (g_level_statement >= g_current_runtime_level ) THEN
114: FND_LOG.STRING(g_level_statement,
115: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.BEGIN',
116: 'ZX_TDS_UTILITIES_PKG: get_tax_status_cache_info(+)'||
117: ' regime code: ' || p_tax_regime_code||
118: ' status code: ' || p_tax_status_code||
119: ' tax: ' || p_tax);
120: END IF;

Line 184: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info',

180: END IF;
181:
182: IF (g_level_statement >= g_current_runtime_level ) THEN
183: FND_LOG.STRING(g_level_statement,
184: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info',
185: 'Return_status = ' || p_return_status||
186: ' tax_status_id = ' ||
187: to_char(p_status_rec.tax_status_id)||
188: ' Rule_Based_Rate_Flag = ' ||

Line 198: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.END',

194: ' Allow_Exceptions_Flag = ' ||
195: p_status_rec.Allow_Exceptions_Flag);
196:
197: FND_LOG.STRING(g_level_statement,
198: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.END',
199: 'ZX_TDS_UTILITIES_PKG: get_tax_status_cache_info(-)');
200: END IF;
201:
202: EXCEPTION

Line 199: 'ZX_TDS_UTILITIES_PKG: get_tax_status_cache_info(-)');

195: p_status_rec.Allow_Exceptions_Flag);
196:
197: FND_LOG.STRING(g_level_statement,
198: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info.END',
199: 'ZX_TDS_UTILITIES_PKG: get_tax_status_cache_info(-)');
200: END IF;
201:
202: EXCEPTION
203: WHEN OTHERS THEN

Line 211: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info',

207: CLOSE get_status_info_csr;
208: END IF;
209: IF (g_level_unexpected >= g_current_runtime_level ) THEN
210: FND_LOG.STRING(g_level_unexpected,
211: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info',
212: p_error_buffer);
213: END IF;
214:
215: END get_tax_status_cache_info;

Line 258: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.BEGIN',

254: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
255:
256: IF (g_level_statement >= g_current_runtime_level ) THEN
257: FND_LOG.STRING(g_level_statement,
258: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.BEGIN',
259: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(+)'||
260: ' regime code: ' || p_tax_regime_code);
261: END IF;
262:

Line 259: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(+)'||

255:
256: IF (g_level_statement >= g_current_runtime_level ) THEN
257: FND_LOG.STRING(g_level_statement,
258: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.BEGIN',
259: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(+)'||
260: ' regime code: ' || p_tax_regime_code);
261: END IF;
262:
263: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 329: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.END',

325:
326: IF (g_level_statement >= g_current_runtime_level ) THEN
327:
328: FND_LOG.STRING(g_level_statement,
329: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.END',
330: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-)'||
331: ' tax_regime_id = ' ||
332: to_char(p_tax_regime_rec.tax_regime_id)||
333: ' RETURN_STATUS = ' || p_return_status);

Line 330: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-)'||

326: IF (g_level_statement >= g_current_runtime_level ) THEN
327:
328: FND_LOG.STRING(g_level_statement,
329: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.END',
330: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-)'||
331: ' tax_regime_id = ' ||
332: to_char(p_tax_regime_rec.tax_regime_id)||
333: ' RETURN_STATUS = ' || p_return_status);
334: END IF;

Line 345: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info',

341: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
343: IF (g_level_unexpected >= g_current_runtime_level ) THEN
344: FND_LOG.STRING(g_level_unexpected,
345: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info',
346: p_error_buffer);
347: FND_LOG.STRING(g_level_unexpected,
348: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.END',
349: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-)');

Line 348: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.END',

344: FND_LOG.STRING(g_level_unexpected,
345: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info',
346: p_error_buffer);
347: FND_LOG.STRING(g_level_unexpected,
348: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.END',
349: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-)');
350: END IF;
351:
352: END get_regime_cache_info;

Line 349: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-)');

345: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info',
346: p_error_buffer);
347: FND_LOG.STRING(g_level_unexpected,
348: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_regime_cache_info.END',
349: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info(-)');
350: END IF;
351:
352: END get_regime_cache_info;
353:

Line 436: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.BEGIN',

432: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
433:
434: IF (g_level_statement >= g_current_runtime_level ) THEN
435: FND_LOG.STRING(g_level_statement,
436: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.BEGIN',
437: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(+)'||
438: ' regime_code: ' || p_tax_regime_code||
439: ' tax: ' || p_tax);
440: END IF;

Line 437: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(+)'||

433:
434: IF (g_level_statement >= g_current_runtime_level ) THEN
435: FND_LOG.STRING(g_level_statement,
436: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.BEGIN',
437: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(+)'||
438: ' regime_code: ' || p_tax_regime_code||
439: ' tax: ' || p_tax);
440: END IF;
441:

Line 495: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.END',

491:
492: IF (g_level_statement >= g_current_runtime_level ) THEN
493:
494: FND_LOG.STRING(g_level_statement,
495: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.END',
496: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(-)'||
497: 'return_status = ' || p_return_status);
498: END IF;
499:

Line 496: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(-)'||

492: IF (g_level_statement >= g_current_runtime_level ) THEN
493:
494: FND_LOG.STRING(g_level_statement,
495: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.END',
496: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(-)'||
497: 'return_status = ' || p_return_status);
498: END IF;
499:
500: EXCEPTION

Line 509: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',

505: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
507: IF (g_level_unexpected >= g_current_runtime_level ) THEN
508: FND_LOG.STRING(g_level_unexpected,
509: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
510: p_error_buffer);
511: FND_LOG.STRING(g_level_unexpected,
512: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.END',
513: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(-)');

Line 512: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.END',

508: FND_LOG.STRING(g_level_unexpected,
509: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
510: p_error_buffer);
511: FND_LOG.STRING(g_level_unexpected,
512: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.END',
513: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(-)');
514: END IF;
515:
516: END get_tax_cache_info;

Line 513: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(-)');

509: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info',
510: p_error_buffer);
511: FND_LOG.STRING(g_level_unexpected,
512: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_cache_info.END',
513: 'ZX_TDS_UTILITIES_PKG.get_tax_cache_info(-)');
514: END IF;
515:
516: END get_tax_cache_info;
517:

Line 559: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info.BEGIN',

555: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
556:
557: IF (g_level_statement >= g_current_runtime_level ) THEN
558: FND_LOG.STRING(g_level_statement,
559: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info.BEGIN',
560: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(+)'||
561: ' regime_code = ' || p_tax_regime_code||
562: ' tax = ' || p_tax||
563: ' jurisdiciton_code = ' || p_tax_jurisdiction_code);

Line 560: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(+)'||

556:
557: IF (g_level_statement >= g_current_runtime_level ) THEN
558: FND_LOG.STRING(g_level_statement,
559: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info.BEGIN',
560: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(+)'||
561: ' regime_code = ' || p_tax_regime_code||
562: ' tax = ' || p_tax||
563: ' jurisdiciton_code = ' || p_tax_jurisdiction_code);
564:

Line 619: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiciton_cache_info.END',

615:
616: IF (g_level_statement >= g_current_runtime_level ) THEN
617:
618: FND_LOG.STRING(g_level_statement,
619: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiciton_cache_info.END',
620: 'ZX_TDS_UTILITIES_PKG.get_jurisdiciton_cache_info(-)'||
621: ' jurisdiction id = '||to_char(x_jurisdiction_rec.tax_jurisdiction_id) ||
622: ' return_status = ' || p_return_status);
623: END IF;

Line 620: 'ZX_TDS_UTILITIES_PKG.get_jurisdiciton_cache_info(-)'||

616: IF (g_level_statement >= g_current_runtime_level ) THEN
617:
618: FND_LOG.STRING(g_level_statement,
619: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiciton_cache_info.END',
620: 'ZX_TDS_UTILITIES_PKG.get_jurisdiciton_cache_info(-)'||
621: ' jurisdiction id = '||to_char(x_jurisdiction_rec.tax_jurisdiction_id) ||
622: ' return_status = ' || p_return_status);
623: END IF;
624:

Line 634: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info',

630: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
632: IF (g_level_unexpected >= g_current_runtime_level ) THEN
633: FND_LOG.STRING(g_level_unexpected,
634: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info',
635: p_error_buffer);
636: FND_LOG.STRING(g_level_unexpected,
637: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info.END',
638: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(-)');

Line 637: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info.END',

633: FND_LOG.STRING(g_level_unexpected,
634: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info',
635: p_error_buffer);
636: FND_LOG.STRING(g_level_unexpected,
637: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info.END',
638: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(-)');
639: END IF;
640:
641: END get_jurisdiction_cache_info;

Line 638: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(-)');

634: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info',
635: p_error_buffer);
636: FND_LOG.STRING(g_level_unexpected,
637: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info.END',
638: 'ZX_TDS_UTILITIES_PKG.get_jurisdiction_cache_info(-)');
639: END IF;
640:
641: END get_jurisdiction_cache_info;
642:

Line 706: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.BEGIN',

702: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
703:
704: IF (g_level_statement >= g_current_runtime_level ) THEN
705: FND_LOG.STRING(g_level_statement,
706: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.BEGIN',
707: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(+)'||
708: 'tax_id := ' || to_char(p_tax_id));
709: END IF;
710:

Line 707: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(+)'||

703:
704: IF (g_level_statement >= g_current_runtime_level ) THEN
705: FND_LOG.STRING(g_level_statement,
706: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.BEGIN',
707: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(+)'||
708: 'tax_id := ' || to_char(p_tax_id));
709: END IF;
710:
711: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 716: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',

712:
713: IF p_tax_id IS NULL THEN
714: IF (g_level_statement >= g_current_runtime_level ) THEN
715: FND_LOG.STRING(g_level_statement,
716: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',
717: 'tax_id cannot be null');
718: END IF;
719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
720: p_error_buffer := 'tax_id cannot be null';

Line 742: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.END',

738:
739: IF (g_level_statement >= g_current_runtime_level ) THEN
740:
741: FND_LOG.STRING(g_level_statement,
742: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.END',
743: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(-)'||
744: ' RETURN_STATUS = ' || p_return_status||
745: ' error buffer: '||p_error_buffer);
746: END IF;

Line 743: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(-)'||

739: IF (g_level_statement >= g_current_runtime_level ) THEN
740:
741: FND_LOG.STRING(g_level_statement,
742: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.END',
743: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(-)'||
744: ' RETURN_STATUS = ' || p_return_status||
745: ' error buffer: '||p_error_buffer);
746: END IF;
747:

Line 757: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',

753: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
755: IF (g_level_unexpected >= g_current_runtime_level ) THEN
756: FND_LOG.STRING(g_level_unexpected,
757: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',
758: p_error_buffer);
759: FND_LOG.STRING(g_level_unexpected,
760: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.END',
761: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(-)');

Line 760: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.END',

756: FND_LOG.STRING(g_level_unexpected,
757: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',
758: p_error_buffer);
759: FND_LOG.STRING(g_level_unexpected,
760: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.END',
761: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(-)');
762: END IF;
763:
764: END populate_tax_cache;

Line 761: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(-)');

757: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache',
758: p_error_buffer);
759: FND_LOG.STRING(g_level_unexpected,
760: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_tax_cache.END',
761: 'ZX_TDS_UTILITIES_PKG.populate_tax_cache(-)');
762: END IF;
763:
764: END populate_tax_cache;
765:

Line 795: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.BEGIN',

791: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
792:
793: IF (g_level_statement >= g_current_runtime_level ) THEN
794: FND_LOG.STRING(g_level_statement,
795: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.BEGIN',
796: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(+)'||
797: 'ledger_id := ' || to_char(p_ledger_id));
798: END IF;
799:

Line 796: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(+)'||

792:
793: IF (g_level_statement >= g_current_runtime_level ) THEN
794: FND_LOG.STRING(g_level_statement,
795: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.BEGIN',
796: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(+)'||
797: 'ledger_id := ' || to_char(p_ledger_id));
798: END IF;
799:
800: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 805: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',

801:
802: IF p_ledger_id IS NULL THEN
803: IF (g_level_statement >= g_current_runtime_level ) THEN
804: FND_LOG.STRING(g_level_statement,
805: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',
806: 'ledger_id cannot be null');
807: END IF;
808: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
809: p_error_buffer := 'ledger_id cannot be null';

Line 836: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.END',

832:
833: IF (g_level_statement >= g_current_runtime_level ) THEN
834:
835: FND_LOG.STRING(g_level_statement,
836: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.END',
837: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(-)'||
838: ' RETURN_STATUS = ' || p_return_status||
839: ' error buffer: '||p_error_buffer);
840: END IF;

Line 837: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(-)'||

833: IF (g_level_statement >= g_current_runtime_level ) THEN
834:
835: FND_LOG.STRING(g_level_statement,
836: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.END',
837: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(-)'||
838: ' RETURN_STATUS = ' || p_return_status||
839: ' error buffer: '||p_error_buffer);
840: END IF;
841:

Line 851: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',

847: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
849: IF (g_level_unexpected >= g_current_runtime_level ) THEN
850: FND_LOG.STRING(g_level_unexpected,
851: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',
852: p_error_buffer);
853: FND_LOG.STRING(g_level_unexpected,
854: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.END',
855: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(-)');

Line 854: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.END',

850: FND_LOG.STRING(g_level_unexpected,
851: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',
852: p_error_buffer);
853: FND_LOG.STRING(g_level_unexpected,
854: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.END',
855: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(-)');
856: END IF;
857:
858: END populate_currency_cache;

Line 855: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(-)');

851: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache',
852: p_error_buffer);
853: FND_LOG.STRING(g_level_unexpected,
854: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.populate_currency_cache.END',
855: 'ZX_TDS_UTILITIES_PKG.populate_currency_cache(-)');
856: END IF;
857:
858: END populate_currency_cache;
859:

Line 975: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',

971: p_return_status := FND_API.G_RET_STS_SUCCESS;
972:
973: IF (g_level_statement >= g_current_runtime_level ) THEN
974: FND_LOG.STRING(g_level_statement,
975: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',
976: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(+)'||
977: ' tax_regime_code = ' || p_tax_regime_code||
978: ' tax = ' || p_tax||
979: ' tax_status_code = ' || p_tax_status_code||

Line 976: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(+)'||

972:
973: IF (g_level_statement >= g_current_runtime_level ) THEN
974: FND_LOG.STRING(g_level_statement,
975: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',
976: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(+)'||
977: ' tax_regime_code = ' || p_tax_regime_code||
978: ' tax = ' || p_tax||
979: ' tax_status_code = ' || p_tax_status_code||
980: ' tax_rate_code = ' || p_tax_rate_code||

Line 1049: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',

1045:
1046: IF (g_level_statement >= g_current_runtime_level ) THEN
1047:
1048: FND_LOG.STRING(g_level_statement,
1049: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1050: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)'||
1051: ' tax rate id: '||to_char(p_tax_rate_rec.tax_rate_id)||
1052: ' RETURN_STATUS = ' || p_return_status||
1053: ' error buffer: '||p_error_buffer);

Line 1050: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)'||

1046: IF (g_level_statement >= g_current_runtime_level ) THEN
1047:
1048: FND_LOG.STRING(g_level_statement,
1049: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1050: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)'||
1051: ' tax rate id: '||to_char(p_tax_rate_rec.tax_rate_id)||
1052: ' RETURN_STATUS = ' || p_return_status||
1053: ' error buffer: '||p_error_buffer);
1054: END IF;

Line 1061: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',

1057: WHEN OTHERS THEN
1058: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1059: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1060: FND_LOG.STRING(g_level_unexpected,
1061: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1062: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1063: FND_LOG.STRING(g_level_unexpected,
1064: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1065: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');

Line 1064: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',

1060: FND_LOG.STRING(g_level_unexpected,
1061: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1062: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1063: FND_LOG.STRING(g_level_unexpected,
1064: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1065: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');
1066: END IF;
1067:
1068: END get_tax_rate_info;

Line 1065: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');

1061: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1062: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1063: FND_LOG.STRING(g_level_unexpected,
1064: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1065: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');
1066: END IF;
1067:
1068: END get_tax_rate_info;
1069:

Line 1102: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.BEGIN',

1098: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1100:
1101: IF (g_level_statement >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.BEGIN',
1103: 'ZX_TDS_UTILITIES_PKG.get_tax_index(+)'||
1104: ' tax_regime_code : ' || p_tax_regime_code||
1105: ' tax : ' || p_tax);
1106: END IF;

Line 1103: 'ZX_TDS_UTILITIES_PKG.get_tax_index(+)'||

1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1100:
1101: IF (g_level_statement >= g_current_runtime_level ) THEN
1102: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.BEGIN',
1103: 'ZX_TDS_UTILITIES_PKG.get_tax_index(+)'||
1104: ' tax_regime_code : ' || p_tax_regime_code||
1105: ' tax : ' || p_tax);
1106: END IF;
1107:

Line 1112: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',

1108: -- Return NULL if p_begin_index IS NULL
1109: --
1110: IF (p_begin_index IS NULL) THEN
1111: IF (g_level_statement >= g_current_runtime_level ) THEN
1112: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',
1113: 'Warning: p_begin_index is NULL');
1114: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1115: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-)');
1116: END IF;

Line 1114: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',

1110: IF (p_begin_index IS NULL) THEN
1111: IF (g_level_statement >= g_current_runtime_level ) THEN
1112: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',
1113: 'Warning: p_begin_index is NULL');
1114: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1115: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-)');
1116: END IF;
1117: RETURN NULL;
1118: END IF;

Line 1115: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-)');

1111: IF (g_level_statement >= g_current_runtime_level ) THEN
1112: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',
1113: 'Warning: p_begin_index is NULL');
1114: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1115: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-)');
1116: END IF;
1117: RETURN NULL;
1118: END IF;
1119:

Line 1132: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',

1128: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax = p_tax )
1129: THEN
1130: IF (g_level_statement >= g_current_runtime_level ) THEN
1131:
1132: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1133: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-) tax found in cache');
1134: END IF;
1135: RETURN i;
1136: END IF;

Line 1133: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-) tax found in cache');

1129: THEN
1130: IF (g_level_statement >= g_current_runtime_level ) THEN
1131:
1132: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1133: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-) tax found in cache');
1134: END IF;
1135: RETURN i;
1136: END IF;
1137: END LOOP;

Line 1143: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',

1139: -- Return NULL if tax does not exist
1140: --
1141: IF (g_level_statement >= g_current_runtime_level ) THEN
1142:
1143: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1144: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-) tax does not exist in cache');
1145: END IF;
1146:
1147: RETURN NULL;

Line 1144: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-) tax does not exist in cache');

1140: --
1141: IF (g_level_statement >= g_current_runtime_level ) THEN
1142:
1143: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1144: 'ZX_TDS_UTILITIES_PKG.get_tax_index(-) tax does not exist in cache');
1145: END IF;
1146:
1147: RETURN NULL;
1148:

Line 1153: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',

1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',
1154: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1155: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1156: 'get_tax_index(-)');
1157: END IF;

Line 1155: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',

1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index',
1154: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1155: FND_LOG.STRING(g_level_unexpected, 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_index.END',
1156: 'get_tax_index(-)');
1157: END IF;
1158:
1159: END get_tax_index;

Line 1225: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',

1221: p_return_status := FND_API.G_RET_STS_SUCCESS;
1222:
1223: IF (g_level_statement >= g_current_runtime_level ) THEN
1224: FND_LOG.STRING(g_level_statement,
1225: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',
1226: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(+)'||
1227: 'tax_rate_id = ' || p_tax_rate_id);
1228: END IF;
1229:

Line 1226: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(+)'||

1222:
1223: IF (g_level_statement >= g_current_runtime_level ) THEN
1224: FND_LOG.STRING(g_level_statement,
1225: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.BEGIN',
1226: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(+)'||
1227: 'tax_rate_id = ' || p_tax_rate_id);
1228: END IF;
1229:
1230: IF g_tax_rate_info_tbl.exists(p_tax_rate_id) then

Line 1235: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',

1231:
1232: IF (g_level_statement >= g_current_runtime_level ) THEN
1233:
1234: FND_LOG.STRING(g_level_statement,
1235: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1236: 'Found rate info in cache. ');
1237: END IF;
1238:
1239: p_tax_rate_rec := g_tax_rate_info_tbl(p_tax_rate_id);

Line 1267: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',

1263:
1264: IF (g_level_statement >= g_current_runtime_level ) THEN
1265:
1266: FND_LOG.STRING(g_level_statement,
1267: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1268: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)'||
1269: ' RETURN_STATUS = ' || p_return_status||
1270: ' error buffer: '||p_error_buffer);
1271: END IF;

Line 1268: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)'||

1264: IF (g_level_statement >= g_current_runtime_level ) THEN
1265:
1266: FND_LOG.STRING(g_level_statement,
1267: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1268: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)'||
1269: ' RETURN_STATUS = ' || p_return_status||
1270: ' error buffer: '||p_error_buffer);
1271: END IF;
1272:

Line 1278: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',

1274: WHEN OTHERS THEN
1275: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1276: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1277: FND_LOG.STRING(g_level_unexpected,
1278: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1279: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1280: FND_LOG.STRING(g_level_unexpected,
1281: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1282: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');

Line 1281: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',

1277: FND_LOG.STRING(g_level_unexpected,
1278: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1279: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1280: FND_LOG.STRING(g_level_unexpected,
1281: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1282: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');
1283: END IF;
1284:
1285: END get_tax_rate_info;

Line 1282: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');

1278: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info',
1279: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
1280: FND_LOG.STRING(g_level_unexpected,
1281: 'ZX.PLSQL.ZX_TDS_UTILITIES_PKG.get_tax_rate_info.END',
1282: 'ZX_TDS_UTILITIES_PKG.get_tax_rate_info(-)');
1283: END IF;
1284:
1285: END get_tax_rate_info;
1286:

Line 1287: END ZX_TDS_UTILITIES_PKG;

1283: END IF;
1284:
1285: END get_tax_rate_info;
1286:
1287: END ZX_TDS_UTILITIES_PKG;
1288: