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_TAX_STATUS_DETM_PKG dependencies on FND_LOG

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

28: p_return_status OUT NOCOPY VARCHAR2,
29: p_error_buffer OUT NOCOPY VARCHAR2);
30:
31: g_current_runtime_level NUMBER;
32: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
33: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: -----------------------------------------------------------------------

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

29: p_error_buffer OUT NOCOPY VARCHAR2);
30:
31: g_current_runtime_level NUMBER;
32: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
33: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: -----------------------------------------------------------------------
37: -- PUBLIC PROCEDURE

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

30:
31: g_current_runtime_level NUMBER;
32: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
33: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: -----------------------------------------------------------------------
37: -- PUBLIC PROCEDURE
38: -- get_tax_status

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

31: g_current_runtime_level NUMBER;
32: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
33: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: -----------------------------------------------------------------------
37: -- PUBLIC PROCEDURE
38: -- get_tax_status
39: --

Line 67: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

63: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
64: l_reporting_code_id ZX_REPORTING_CODES_B.reporting_code_id%type;
65: l_trx_date ZX_LINES.TRX_DATE%TYPE;
66: BEGIN
67: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68:
69: IF (g_level_procedure >= g_current_runtime_level ) THEN
70:
71: FND_LOG.STRING(g_level_procedure,

Line 71: FND_LOG.STRING(g_level_procedure,

67: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68:
69: IF (g_level_procedure >= g_current_runtime_level ) THEN
70:
71: FND_LOG.STRING(g_level_procedure,
72: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.BEGIN',
73: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(+)');
74:
75:

Line 89: FND_LOG.STRING(g_level_error,

85: IF (p_begin_index IS NULL OR p_end_index IS NULL) THEN
86: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
87:
88: IF (g_level_error >= g_current_runtime_level ) THEN
89: FND_LOG.STRING(g_level_error,
90: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
91: 'Begin index or End index is null');
92: END IF;
93: RETURN;

Line 103: FND_LOG.STRING(g_level_statement,

99: --
100:
101: FOR i IN p_begin_index .. p_end_index LOOP
102: IF (g_level_statement >= g_current_runtime_level ) THEN
103: FND_LOG.STRING(g_level_statement,
104: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
105: 'processing detail line index = ' || to_char(i));
106: END IF;
107:

Line 167: FND_LOG.STRING(g_level_error,

163: p_error_buffer);
164:
165: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: IF (g_level_error >= g_current_runtime_level ) THEN
167: FND_LOG.STRING(g_level_error,
168: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
169: 'Incorrect return_status after calling rule_base_tax_status_detm()');
170: FND_LOG.STRING(g_level_error,
171: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',

Line 170: FND_LOG.STRING(g_level_error,

166: IF (g_level_error >= g_current_runtime_level ) THEN
167: FND_LOG.STRING(g_level_error,
168: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
169: 'Incorrect return_status after calling rule_base_tax_status_detm()');
170: FND_LOG.STRING(g_level_error,
171: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
172: 'p_return_status : '|| p_return_status);
173: END IF;
174: EXIT;

Line 191: FND_LOG.STRING(g_level_error,

187: p_return_status,
188: p_error_buffer);
189: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
190: IF (g_level_error >= g_current_runtime_level ) THEN
191: FND_LOG.STRING(g_level_error,
192: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
193: 'Incorrect return_status after calling '||
194: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()' );
195: FND_LOG.STRING(g_level_error,

Line 195: FND_LOG.STRING(g_level_error,

191: FND_LOG.STRING(g_level_error,
192: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
193: 'Incorrect return_status after calling '||
194: 'ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info()' );
195: FND_LOG.STRING(g_level_error,
196: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
197: 'No valid tax status id for the tax status code ' ||
198: 'returned from rule engine. Need to get default tax status.');
199: END IF;

Line 232: FND_LOG.STRING(g_level_error,

228: --
229:
230: IF l_status_rec.tax_status_code IS NULL THEN
231: IF (g_level_error >= g_current_runtime_level ) THEN
232: FND_LOG.STRING(g_level_error,
233: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
234: 'tax status not found for tax: ' || l_tax);
235: END IF;
236:

Line 265: FND_LOG.STRING(g_level_procedure,

261: END LOOP;
262:
263: IF (g_level_procedure >= g_current_runtime_level ) THEN
264:
265: FND_LOG.STRING(g_level_procedure,
266: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status.END',
267: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_tax_status(-)'||p_return_status);
268: END IF;
269:

Line 276: FND_LOG.STRING(g_level_unexpected,

272: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
274:
275: IF (g_level_unexpected >= g_current_runtime_level ) THEN
276: FND_LOG.STRING(g_level_unexpected,
277: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_tax_status',
278: p_error_buffer);
279: END IF;
280:

Line 335: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

331: --AND rownum = 1;
332: ORDER BY subscription_level_code;
333:
334: BEGIN
335: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
336:
337: IF (g_level_procedure >= g_current_runtime_level ) THEN
338: FND_LOG.STRING(g_level_procedure,
339: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.BEGIN',

Line 338: FND_LOG.STRING(g_level_procedure,

334: BEGIN
335: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
336:
337: IF (g_level_procedure >= g_current_runtime_level ) THEN
338: FND_LOG.STRING(g_level_procedure,
339: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.BEGIN',
340: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(+)'||
341: 'tax_regime_code = ' || p_tax_regime_code||
342: 'tax = ' || p_tax);

Line 367: FND_LOG.STRING(g_level_statement,

363: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364: p_error_buffer := 'No default tax status found';
365:
366: IF (g_level_statement >= g_current_runtime_level ) THEN
367: FND_LOG.STRING(g_level_statement,
368: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info',
369: p_error_buffer);
370: END IF;
371: END IF;

Line 386: FND_LOG.STRING(g_level_procedure,

382: END IF;
383:
384:
385: IF (g_level_procedure >= g_current_runtime_level ) THEN
386: FND_LOG.STRING(g_level_procedure,
387: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info.END',
388: 'ZX_TDS_TAX_STATUS_DETM_PKG: get_def_tax_status_info(-)'||
389: 'tax_status_code = ' ||
390: p_status_rec.tax_status_code);

Line 401: FND_LOG.STRING(g_level_unexpected,

397: IF get_def_status_info_csr%ISOPEN THEN
398: CLOSE get_def_status_info_csr;
399: END IF;
400: IF (g_level_unexpected >= g_current_runtime_level ) THEN
401: FND_LOG.STRING(g_level_unexpected,
402: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.get_def_tax_status_info',
403: p_error_buffer);
404: END IF;
405: END get_def_tax_status_info;

Line 435: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

431: l_recovery_type_code ZX_RULES_B.RECOVERY_TYPE_CODE%TYPE;
432:
433: BEGIN
434:
435: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
436:
437: IF (g_level_procedure >= g_current_runtime_level ) THEN
438: FND_LOG.STRING(g_level_procedure,
439: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.BEGIN',

Line 438: FND_LOG.STRING(g_level_procedure,

434:
435: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
436:
437: IF (g_level_procedure >= g_current_runtime_level ) THEN
438: FND_LOG.STRING(g_level_procedure,
439: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.BEGIN',
440: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(+)');
441: END IF;
442: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 443: FND_LOG.STRING(g_level_statement,

439: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.BEGIN',
440: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(+)');
441: END IF;
442: IF (g_level_statement >= g_current_runtime_level ) THEN
443: FND_LOG.STRING(g_level_statement,
444: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
445: 'p_tax_id = ' || to_char(p_tax_id));
446: END IF;
447:

Line 472: FND_LOG.STRING(g_level_statement,

468: p_status_result_id := l_tax_result_rec.result_id;
469: END IF;
470:
471: IF (g_level_statement >= g_current_runtime_level ) THEN
472: FND_LOG.STRING(g_level_statement,
473: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
474: 'p_return_status = ' || p_return_status);
475: FND_LOG.STRING(g_level_statement,
476: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

Line 475: FND_LOG.STRING(g_level_statement,

471: IF (g_level_statement >= g_current_runtime_level ) THEN
472: FND_LOG.STRING(g_level_statement,
473: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
474: 'p_return_status = ' || p_return_status);
475: FND_LOG.STRING(g_level_statement,
476: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
477: 'p_error_buffer = ' || p_error_buffer);
478: FND_LOG.STRING(g_level_statement,
479: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

Line 478: FND_LOG.STRING(g_level_statement,

474: 'p_return_status = ' || p_return_status);
475: FND_LOG.STRING(g_level_statement,
476: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
477: 'p_error_buffer = ' || p_error_buffer);
478: FND_LOG.STRING(g_level_statement,
479: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
480: 'p_tax_status_code = ' || p_tax_status_code);
481: FND_LOG.STRING(g_level_statement,
482: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',

Line 481: FND_LOG.STRING(g_level_statement,

477: 'p_error_buffer = ' || p_error_buffer);
478: FND_LOG.STRING(g_level_statement,
479: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
480: 'p_tax_status_code = ' || p_tax_status_code);
481: FND_LOG.STRING(g_level_statement,
482: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
483: 'p_status_result_id = ' ||
484: to_char(p_status_result_id));
485: END IF;

Line 488: FND_LOG.STRING(g_level_procedure,

484: to_char(p_status_result_id));
485: END IF;
486:
487: IF (g_level_procedure >= g_current_runtime_level ) THEN
488: FND_LOG.STRING(g_level_procedure,
489: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm.END',
490: 'ZX_TDS_TAX_STATUS_DETM_PKG: rule_base_tax_status_detm(-)');
491: END IF;
492:

Line 499: FND_LOG.STRING(g_level_unexpected,

495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
497:
498: IF (g_level_unexpected >= g_current_runtime_level ) THEN
499: FND_LOG.STRING(g_level_unexpected,
500: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.rule_base_tax_status_detm',
501: p_error_buffer);
502: END IF;
503:

Line 523: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

519: p_reporting_code_id IN ZX_REPORTING_CODES_B.REPORTING_CODE_ID%TYPE,
520: p_status_rec IN ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC)
521: IS
522: BEGIN
523: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
524:
525: IF (g_level_procedure >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_procedure,
527: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.BEGIN',

Line 526: FND_LOG.STRING(g_level_procedure,

522: BEGIN
523: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
524:
525: IF (g_level_procedure >= g_current_runtime_level ) THEN
526: FND_LOG.STRING(g_level_procedure,
527: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.BEGIN',
528: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(+)');
529: END IF;
530:

Line 537: FND_LOG.STRING(g_level_procedure,

533: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).status_result_id := p_status_result_id;
534: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).legal_message_status := p_reporting_code_id;
535:
536: IF (g_level_procedure >= g_current_runtime_level ) THEN
537: FND_LOG.STRING(g_level_procedure,
538: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.END',
539: 'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(-)');
540: END IF;
541:

Line 545: FND_LOG.STRING(g_level_unexpected,

541:
542: EXCEPTION
543: WHEN OTHERS THEN
544: IF (g_level_unexpected >= g_current_runtime_level ) THEN
545: FND_LOG.STRING(g_level_unexpected,
546: 'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line',
547: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
548: END IF;
549: