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

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

64: p_return_status OUT NOCOPY VARCHAR2,
65: p_error_buffer OUT NOCOPY VARCHAR2);
66:
67: g_current_runtime_level NUMBER;
68: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
69: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
70: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
71: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
72:

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

65: p_error_buffer OUT NOCOPY VARCHAR2);
66:
67: g_current_runtime_level NUMBER;
68: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
69: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
70: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
71: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
72:
73: ----------------------------------------------------------------------

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

66:
67: g_current_runtime_level NUMBER;
68: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
69: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
70: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
71: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
72:
73: ----------------------------------------------------------------------
74: -- PUBLIC PROCEDURE

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

67: g_current_runtime_level NUMBER;
68: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
69: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
70: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
71: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
72:
73: ----------------------------------------------------------------------
74: -- PUBLIC PROCEDURE
75: -- process_offset_tax

Line 100: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

96: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
97: l_tax_class ZX_RATES_B.TAX_CLASS%TYPE;
98:
99: BEGIN
100: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
101:
102: IF (g_level_procedure >= g_current_runtime_level ) THEN
103: FND_LOG.STRING(g_level_procedure,
104: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax.BEGIN',

Line 103: FND_LOG.STRING(g_level_procedure,

99: BEGIN
100: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
101:
102: IF (g_level_procedure >= g_current_runtime_level ) THEN
103: FND_LOG.STRING(g_level_procedure,
104: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax.BEGIN',
105: 'ZX_TDS_OFFSET_TAX_DETM_PKG: process_offset_tax(+)');
106: END IF;
107:

Line 142: FND_LOG.STRING(g_level_error,

138: p_error_buffer => p_error_buffer
139: );
140: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
141: IF (g_level_error >= g_current_runtime_level ) THEN
142: FND_LOG.STRING(g_level_error,
143: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax',
144: 'Incorrect status returned from ZX_TDS_UTILITIES_PKG.get_tax_rate_info'||
145: 'p_return_status = ' || p_return_status);
146: FND_LOG.STRING(g_level_error,

Line 146: FND_LOG.STRING(g_level_error,

142: FND_LOG.STRING(g_level_error,
143: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax',
144: 'Incorrect status returned from ZX_TDS_UTILITIES_PKG.get_tax_rate_info'||
145: 'p_return_status = ' || p_return_status);
146: FND_LOG.STRING(g_level_error,
147: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax',
148: 'p_error_buffer = ' || p_error_buffer);
149: END IF;
150: RETURN;

Line 199: FND_LOG.STRING(g_level_procedure,

195: END IF;
196:
197: IF (g_level_procedure >= g_current_runtime_level ) THEN
198:
199: FND_LOG.STRING(g_level_procedure,
200: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax.END',
201: 'initial tax rate '||to_char(l_initial_tax_rate));
202: END IF;
203: create_offset_tax_line(p_offset_tax_line_rec,

Line 219: FND_LOG.STRING(g_level_procedure,

215: END IF;
216:
217: IF (g_level_procedure >= g_current_runtime_level ) THEN
218:
219: FND_LOG.STRING(g_level_procedure,
220: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax.END',
221: 'ZX_TDS_OFFSET_TAX_DETM_PKG: process_offset_tax(-)'||p_return_status);
222: END IF;
223:

Line 230: FND_LOG.STRING(g_level_unexpected,

226: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
228:
229: IF (g_level_unexpected >= g_current_runtime_level ) THEN
230: FND_LOG.STRING(g_level_unexpected,
231: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax',
232: p_error_buffer);
233: END IF;
234:

Line 290: FND_LOG.STRING(g_level_statement,

286: */
287:
288: BEGIN
289: IF (g_level_statement >= g_current_runtime_level ) THEN
290: FND_LOG.STRING(g_level_statement,
291: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info.BEGIN',
292: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_offset_info(+)'||
293: 'p_tax_rate_code = ' || p_tax_rate_code||
294: 'p_tax = ' || p_tax||

Line 346: FND_LOG.STRING(g_level_statement,

342: END IF;
343:
344: IF (g_level_statement >= g_current_runtime_level ) THEN
345:
346: FND_LOG.STRING(g_level_statement,
347: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info.END',
348: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_offset_info(-)'||
349: 'p_tax_rate = ' || to_char(p_tax_rate));
350: END IF;

Line 357: IF (FND_LOG.LEVEL_UNEXPECTED >= g_current_runtime_level ) THEN

353: WHEN OTHERS THEN
354: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
356:
357: IF (FND_LOG.LEVEL_UNEXPECTED >= g_current_runtime_level ) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
359: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info',
360: 'p_error_buffer = ' || p_error_buffer);
361: END IF;

Line 358: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

354: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
356:
357: IF (FND_LOG.LEVEL_UNEXPECTED >= g_current_runtime_level ) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
359: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info',
360: 'p_error_buffer = ' || p_error_buffer);
361: END IF;
362: END get_offset_info;

Line 376: FND_LOG.STRING(g_level_statement,

372: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE)
373: IS
374: BEGIN
375: IF (g_level_statement >= g_current_runtime_level ) THEN
376: FND_LOG.STRING(g_level_statement,
377: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns.BEGIN',
378: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_null_columns(+)');
379: END IF;
380:

Line 409: FND_LOG.STRING(g_level_statement,

405: p_offset_tax_line_rec.tax_hold_code := NULL;
406: p_offset_tax_line_rec.tax_hold_released_code := NULL;
407:
408: IF (g_level_statement >= g_current_runtime_level ) THEN
409: FND_LOG.STRING(g_level_statement,
410: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns.END',
411: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_null_columns(-)');
412: END IF;
413:

Line 417: FND_LOG.STRING(g_level_unexpected,

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: IF (g_level_unexpected >= g_current_runtime_level ) THEN
417: FND_LOG.STRING(g_level_unexpected,
418: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns',
419: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
420: END IF;
421:

Line 436: FND_LOG.STRING(g_level_statement,

432: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE)
433: IS
434: BEGIN
435: IF (g_level_statement >= g_current_runtime_level ) THEN
436: FND_LOG.STRING(g_level_statement,
437: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns.BEGIN',
438: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_flg_columns(+)');
439: END IF;
440:

Line 459: FND_LOG.STRING(g_level_statement,

455: -- should get from the parent line
456: -- p_offset_tax_line_rec.Process_For_Recovery_Flag := 'Y';
457:
458: IF (g_level_statement >= g_current_runtime_level ) THEN
459: FND_LOG.STRING(g_level_statement,
460: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns.END',
461: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_flg_columns(-)');
462: END IF;
463:

Line 468: FND_LOG.STRING(g_level_unexpected,

464: EXCEPTION
465: WHEN OTHERS THEN
466:
467: IF (g_level_unexpected >= g_current_runtime_level ) THEN
468: FND_LOG.STRING(g_level_unexpected,
469: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns',
470: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
471: END IF;
472:

Line 494: FND_LOG.STRING(g_level_statement,

490: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
491: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
492: BEGIN
493: IF (g_level_statement >= g_current_runtime_level ) THEN
494: FND_LOG.STRING(g_level_statement,
495: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.BEGIN',
496: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(+)');
497: END IF;
498:

Line 536: FND_LOG.STRING(g_level_statement,

532: END IF;
533:
534: IF (g_level_statement >= g_current_runtime_level ) THEN
535:
536: FND_LOG.STRING(g_level_statement,
537: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',
538: 'initia tax rate'||to_number(p_initial_tax_rate));
539: END IF;
540:

Line 543: FND_LOG.STRING(g_level_statement,

539: END IF;
540:
541: IF (g_level_statement >= g_current_runtime_level ) THEN
542:
543: FND_LOG.STRING(g_level_statement,
544: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',
545: 'offset tax rate'||to_number(p_offset_tax_line_rec.tax_rate));
546: END IF;
547: IF (p_offset_tax_line_rec.tax_rate + p_initial_tax_rate = 0 ) THEN

Line 639: FND_LOG.STRING(g_level_statement,

635: p_offset_tax_line_rec.cal_tax_amt_funcl_curr := p_offset_tax_line_rec.tax_amt_funcl_curr;
636:
637: IF (g_level_statement >= g_current_runtime_level ) THEN
638:
639: FND_LOG.STRING(g_level_statement,
640: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',
641: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(-)'||p_return_status);
642: END IF;
643:

Line 650: FND_LOG.STRING(g_level_unexpected,

646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
648:
649: IF (g_level_unexpected >= g_current_runtime_level ) THEN
650: FND_LOG.STRING(g_level_unexpected,
651: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns',
652: p_error_buffer);
653: END IF;
654:

Line 678: FND_LOG.STRING(g_level_statement,

674: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
675:
676: BEGIN
677: IF (g_level_statement >= g_current_runtime_level ) THEN
678: FND_LOG.STRING(g_level_statement,
679: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.BEGIN',
680: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(+)');
681: END IF;
682: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 699: FND_LOG.STRING(g_level_statement,

695: END IF;
696:
697: IF (g_level_statement >= g_current_runtime_level ) THEN
698:
699: FND_LOG.STRING(g_level_statement,
700: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.END',
701: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(-)');
702: END IF;
703:

Line 710: FND_LOG.STRING(g_level_unexpected,

706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
708:
709: IF (g_level_unexpected >= g_current_runtime_level ) THEN
710: FND_LOG.STRING(g_level_unexpected,
711: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id',
712: p_error_buffer);
713: END IF;
714:

Line 736: FND_LOG.STRING(g_level_statement,

732: IS
733: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
734: BEGIN
735: IF (g_level_statement >= g_current_runtime_level ) THEN
736: FND_LOG.STRING(g_level_statement,
737: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.BEGIN',
738: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(+)');
739: END IF;
740:

Line 757: FND_LOG.STRING(g_level_statement,

753: END IF;
754:
755: IF (g_level_statement >= g_current_runtime_level ) THEN
756:
757: FND_LOG.STRING(g_level_statement,
758: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.END',
759: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(-)'||
760: 'p_tax_id = ' || to_char(p_tax_id)||
761: 'p_return_status = ' || p_return_status);

Line 770: FND_LOG.STRING(g_level_unexpected,

766: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
768:
769: IF (g_level_unexpected >= g_current_runtime_level ) THEN
770: FND_LOG.STRING(g_level_unexpected,
771: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id',
772: p_error_buffer);
773: END IF;
774:

Line 812: FND_LOG.STRING(g_level_statement,

808: AND offset_link_to_tax_line_id = p_offset_tax_line_rec.offset_link_to_tax_line_id;
809:
810: BEGIN
811: IF (g_level_statement >= g_current_runtime_level ) THEN
812: FND_LOG.STRING(g_level_statement,
813: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_old_offset_tax_line_id.BEGIN',
814: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_old_offset_tax_line_id(+)'||
815: 'p_offset_link_to_tax_line_id = ' ||
816: to_char(p_offset_tax_line_rec.offset_link_to_tax_line_id));

Line 836: FND_LOG.STRING(g_level_statement,

832:
833:
834: IF (g_level_statement >= g_current_runtime_level ) THEN
835:
836: FND_LOG.STRING(g_level_statement,
837: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_old_offset_tax_line_id.END',
838: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_old_offset_tax_line_id(-)'||
839: 'p_old_offset_tax_line_id = ' ||
840: to_char(p_old_offset_tax_line_id)||

Line 850: FND_LOG.STRING(g_level_unexpected,

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

Line 894: FND_LOG.STRING(g_level_statement,

890: l_old_offset_tax_line_id ZX_LINES.TAX_LINE_ID%TYPE;
891:
892: BEGIN
893: IF (g_level_statement >= g_current_runtime_level ) THEN
894: FND_LOG.STRING(g_level_statement,
895: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line.BEGIN',
896: 'ZX_TDS_OFFSET_TAX_DETM_PKG: create_offset_tax_line(+)');
897: END IF;
898:

Line 1033: FND_LOG.STRING(g_level_statement,

1029: END IF;
1030:
1031: IF (g_level_statement >= g_current_runtime_level ) THEN
1032:
1033: FND_LOG.STRING(g_level_statement,
1034: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line.END',
1035: 'ZX_TDS_OFFSET_TAX_DETM_PKG: create_offset_tax_line(-)'||p_return_status);
1036: END IF;
1037:

Line 1044: FND_LOG.STRING(g_level_unexpected,

1040: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1042:
1043: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1044: FND_LOG.STRING(g_level_unexpected,
1045: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line',
1046: p_error_buffer);
1047: END IF;
1048: