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 FND_LOG

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

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;
6: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7:
8: ----------------------------------------------------------------------
9: -- PUBLIC FUNCTION

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

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;
6: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7:
8: ----------------------------------------------------------------------
9: -- PUBLIC FUNCTION
10: -- get_tax_status_index

Line 27: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

23:
24: l_tbl_index BINARY_INTEGER;
25: BEGIN
26:
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',

Line 30: FND_LOG.STRING(g_level_statement,

26:
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:

Line 42: FND_LOG.STRING(g_level_statement,

38: 8192);
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:

Line 54: FND_LOG.STRING(g_level_unexpected,

50:
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;

Line 111: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

107: ORDER BY subscription_level_code;
108:
109: BEGIN
110:
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',

Line 114: FND_LOG.STRING(g_level_statement,

110:
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||

Line 183: FND_LOG.STRING(g_level_statement,

179: END IF;
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)||

Line 197: FND_LOG.STRING(g_level_statement,

193: p_status_rec.Allow_Exemptions_Flag||
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:

Line 210: FND_LOG.STRING(g_level_unexpected,

206: IF get_status_info_csr%ISOPEN THEN
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:

Line 254: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

250: l_index NUMBER;
251:
252: BEGIN
253:
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',

Line 257: FND_LOG.STRING(g_level_statement,

253:
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;

Line 328: FND_LOG.STRING(g_level_statement,

324: END IF;
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)||

Line 344: FND_LOG.STRING(g_level_unexpected,

340: END IF;
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',

Line 347: FND_LOG.STRING(g_level_unexpected,

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(-)');
350: END IF;
351:

Line 432: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

428: l_index NUMBER;
429:
430: BEGIN
431:
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',

Line 435: FND_LOG.STRING(g_level_statement,

431:
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);

Line 494: FND_LOG.STRING(g_level_statement,

490: END IF; -- tax not in cache
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;

Line 508: FND_LOG.STRING(g_level_unexpected,

504: END IF;
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',

Line 511: FND_LOG.STRING(g_level_unexpected,

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(-)');
514: END IF;
515:

Line 555: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

551: l_index NUMBER;
552:
553: BEGIN
554:
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',

Line 558: FND_LOG.STRING(g_level_statement,

554:
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||

Line 618: FND_LOG.STRING(g_level_statement,

614: END IF; -- jurisdiciton not in cache
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);

Line 633: FND_LOG.STRING(g_level_unexpected,

629: END IF;
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',

Line 636: FND_LOG.STRING(g_level_unexpected,

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(-)');
639: END IF;
640:

Line 702: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

698: WHERE tax_id = p_tax_id;
699:
700: BEGIN
701:
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',

Line 705: FND_LOG.STRING(g_level_statement,

701:
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;

Line 715: FND_LOG.STRING(g_level_statement,

711: p_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 741: FND_LOG.STRING(g_level_statement,

737: END IF; -- tax_id not exist in g_tax_rec_tbl
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);

Line 756: FND_LOG.STRING(g_level_unexpected,

752: END IF;
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',

Line 759: FND_LOG.STRING(g_level_unexpected,

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(-)');
762: END IF;
763:

Line 791: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

787: AND cur.currency_code = sob.currency_code;
788:
789:
790: 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',

Line 794: FND_LOG.STRING(g_level_statement,

790: 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;

Line 804: FND_LOG.STRING(g_level_statement,

800: p_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 835: FND_LOG.STRING(g_level_statement,

831: END IF;
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);

Line 850: FND_LOG.STRING(g_level_unexpected,

846: END IF;
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',

Line 853: FND_LOG.STRING(g_level_unexpected,

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(-)');
856: END IF;
857:

Line 969: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

965: (p_tax_determine_date <= effective_to OR effective_to IS NULL))
966: ORDER BY tax_class NULLS LAST, subscription_level_code;
967:
968: BEGIN
969: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
970:
971: p_return_status := FND_API.G_RET_STS_SUCCESS;
972:
973: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 974: FND_LOG.STRING(g_level_statement,

970:
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||

Line 1048: FND_LOG.STRING(g_level_statement,

1044: END IF;
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||

Line 1060: FND_LOG.STRING(g_level_unexpected,

1056: EXCEPTION
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',

Line 1063: FND_LOG.STRING(g_level_unexpected,

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(-)');
1066: END IF;
1067:

Line 1098: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1094: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
1095:
1096: BEGIN
1097:
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',

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 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 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 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 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 1219: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1215:
1216: l_tbl_index BINARY_INTEGER;
1217:
1218: BEGIN
1219: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1220:
1221: p_return_status := FND_API.G_RET_STS_SUCCESS;
1222:
1223: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1224: FND_LOG.STRING(g_level_statement,

1220:
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;

Line 1234: FND_LOG.STRING(g_level_statement,

1230: IF g_tax_rate_info_tbl.exists(p_tax_rate_id) then
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:

Line 1266: FND_LOG.STRING(g_level_statement,

1262: END IF;
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);

Line 1277: FND_LOG.STRING(g_level_unexpected,

1273: EXCEPTION
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',

Line 1280: FND_LOG.STRING(g_level_unexpected,

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(-)');
1283: END IF;
1284: