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 204: FND_LOG.STRING(g_level_procedure,

200: RETURN;
201: END IF;
202:
203: IF (g_level_procedure >= g_current_runtime_level) THEN
204: FND_LOG.STRING(g_level_procedure,
205: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX.END',
206: 'initial tax rate '||to_char(l_initial_tax_rate));
207: END IF;
208: create_offset_tax_line(p_offset_tax_line_rec,

Line 223: FND_LOG.STRING(g_level_procedure,

219: RETURN;
220: END IF;
221:
222: IF (g_level_procedure >= g_current_runtime_level) THEN
223: FND_LOG.STRING(g_level_procedure,
224: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX.END',
225: 'ZX_TDS_OFFSET_TAX_DETM_PKG: PROCESS_OFFSET_TAX(-)'||p_return_status);
226: END IF;
227:

Line 234: FND_LOG.STRING(g_level_unexpected,

230: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
232:
233: IF (g_level_unexpected >= g_current_runtime_level) THEN
234: FND_LOG.STRING(g_level_unexpected,
235: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',
236: p_error_buffer);
237: END IF;
238:

Line 294: FND_LOG.STRING(g_level_statement,

290: */
291:
292: BEGIN
293: IF (g_level_statement >= g_current_runtime_level) THEN
294: FND_LOG.STRING(g_level_statement,
295: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info.BEGIN',
296: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_offset_info(+)'||
297: 'p_tax_rate_code = ' || p_tax_rate_code||
298: 'p_tax = ' || p_tax||

Line 348: FND_LOG.STRING(g_level_statement,

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

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

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

Line 360: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

Line 378: FND_LOG.STRING(g_level_statement,

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

Line 418: FND_LOG.STRING(g_level_statement,

414: p_offset_tax_line_rec.legal_message_pos := NULL;
415: p_offset_tax_line_rec.legal_message_trn := NULL;
416:
417: IF (g_level_statement >= g_current_runtime_level) THEN
418: FND_LOG.STRING(g_level_statement,
419: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns.END',
420: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_null_columns(-)');
421: END IF;
422:

Line 426: FND_LOG.STRING(g_level_unexpected,

422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: IF (g_level_unexpected >= g_current_runtime_level) THEN
426: FND_LOG.STRING(g_level_unexpected,
427: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns',
428: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
429: END IF;
430:

Line 445: FND_LOG.STRING(g_level_statement,

441: p_offset_tax_line_rec IN OUT NOCOPY ZX_DETAIL_TAX_LINES_GT%ROWTYPE)
442: IS
443: BEGIN
444: IF (g_level_statement >= g_current_runtime_level) THEN
445: FND_LOG.STRING(g_level_statement,
446: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns.BEGIN',
447: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_flg_columns(+)');
448: END IF;
449:

Line 468: FND_LOG.STRING(g_level_statement,

464: -- should get from the parent line
465: -- p_offset_tax_line_rec.Process_For_Recovery_Flag := 'Y';
466:
467: IF (g_level_statement >= g_current_runtime_level) THEN
468: FND_LOG.STRING(g_level_statement,
469: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns.END',
470: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_flg_columns(-)');
471: END IF;
472:

Line 476: FND_LOG.STRING(g_level_unexpected,

472:
473: EXCEPTION
474: WHEN OTHERS THEN
475: IF (g_level_unexpected >= g_current_runtime_level) THEN
476: FND_LOG.STRING(g_level_unexpected,
477: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns',
478: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
479: END IF;
480:

Line 502: FND_LOG.STRING(g_level_statement,

498: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
499: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
500: BEGIN
501: IF (g_level_statement >= g_current_runtime_level) THEN
502: FND_LOG.STRING(g_level_statement,
503: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.BEGIN',
504: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(+)');
505: END IF;
506:

Line 543: FND_LOG.STRING(g_level_statement,

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

Line 549: FND_LOG.STRING(g_level_statement,

545: 'initia tax rate'||to_number(p_initial_tax_rate));
546: END IF;
547:
548: IF (g_level_statement >= g_current_runtime_level) THEN
549: FND_LOG.STRING(g_level_statement,
550: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',
551: 'offset tax rate'||to_number(p_offset_tax_line_rec.tax_rate));
552: END IF;
553: IF (p_offset_tax_line_rec.tax_rate + p_initial_tax_rate = 0 ) THEN

Line 644: FND_LOG.STRING(g_level_statement,

640: p_offset_tax_line_rec.cal_tax_amt_tax_curr := p_offset_tax_line_rec.tax_amt_tax_curr;
641: p_offset_tax_line_rec.cal_tax_amt_funcl_curr := p_offset_tax_line_rec.tax_amt_funcl_curr;
642:
643: IF (g_level_statement >= g_current_runtime_level) THEN
644: FND_LOG.STRING(g_level_statement,
645: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',
646: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(-)'||p_return_status);
647: END IF;
648:

Line 655: FND_LOG.STRING(g_level_unexpected,

651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
653:
654: IF (g_level_unexpected >= g_current_runtime_level) THEN
655: FND_LOG.STRING(g_level_unexpected,
656: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns',
657: p_error_buffer);
658: END IF;
659:

Line 683: FND_LOG.STRING(g_level_statement,

679: l_status_rec ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC;
680:
681: BEGIN
682: IF (g_level_statement >= g_current_runtime_level) THEN
683: FND_LOG.STRING(g_level_statement,
684: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.BEGIN',
685: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(+)');
686: END IF;
687: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 703: FND_LOG.STRING(g_level_statement,

699: p_tax_status_id := l_status_rec.tax_status_id;
700: END IF;
701:
702: IF (g_level_statement >= g_current_runtime_level) THEN
703: FND_LOG.STRING(g_level_statement,
704: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.END',
705: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(-)');
706: END IF;
707:

Line 714: FND_LOG.STRING(g_level_unexpected,

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

Line 740: FND_LOG.STRING(g_level_statement,

736: IS
737: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
738: BEGIN
739: IF (g_level_statement >= g_current_runtime_level) THEN
740: FND_LOG.STRING(g_level_statement,
741: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.BEGIN',
742: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(+)');
743: END IF;
744:

Line 760: FND_LOG.STRING(g_level_statement,

756: p_tax_id := l_tax_rec.tax_id;
757: END IF;
758:
759: IF (g_level_statement >= g_current_runtime_level) THEN
760: FND_LOG.STRING(g_level_statement,
761: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.END',
762: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(-)'||
763: 'p_tax_id = ' || to_char(p_tax_id)||
764: 'p_return_status = ' || p_return_status);

Line 773: FND_LOG.STRING(g_level_unexpected,

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

Line 815: FND_LOG.STRING(g_level_statement,

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

Line 838: FND_LOG.STRING(g_level_statement,

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

Line 852: FND_LOG.STRING(g_level_unexpected,

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

Line 896: FND_LOG.STRING(g_level_statement,

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

Line 1045: FND_LOG.STRING(g_level_statement,

1041: END IF;
1042: END IF;
1043:
1044: IF (g_level_statement >= g_current_runtime_level) THEN
1045: FND_LOG.STRING(g_level_statement,
1046: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line.END',
1047: 'ZX_TDS_OFFSET_TAX_DETM_PKG: create_offset_tax_line(-)'||p_return_status);
1048: END IF;
1049:

Line 1056: FND_LOG.STRING(g_level_unexpected,

1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: p_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1054:
1055: IF (g_level_unexpected >= g_current_runtime_level) THEN
1056: FND_LOG.STRING(g_level_unexpected,
1057: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line',
1058: p_error_buffer);
1059: END IF;
1060: