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 ZX_TDS_OFFSET_TAX_DETM_PKG

Line 1: package body ZX_TDS_OFFSET_TAX_DETM_PKG as

1: package body ZX_TDS_OFFSET_TAX_DETM_PKG as
2: /* $Header: zxdioffsettxpkgb.pls 120.47.12020000.2 2012/07/23 12:53:02 srajapar noship $ */
3:
4: PROCEDURE get_offset_info(
5: p_tax_rate_code IN ZX_RATES_B.TAX_RATE_CODE%TYPE,

Line 104: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX.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:
108: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 105: 'ZX_TDS_OFFSET_TAX_DETM_PKG: PROCESS_OFFSET_TAX(+)');

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:
108: p_return_status := FND_API.G_RET_STS_SUCCESS;
109: p_error_buffer := NULL;

Line 143: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',

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,
147: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',

Line 147: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',

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

Line 205: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX.END',

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,
209: p_event_class_rec,

Line 224: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX.END',

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:
228: EXCEPTION

Line 225: 'ZX_TDS_OFFSET_TAX_DETM_PKG: PROCESS_OFFSET_TAX(-)'||p_return_status);

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:
228: EXCEPTION
229: WHEN OTHERS THEN

Line 235: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.PROCESS_OFFSET_TAX',

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:
239: END PROCESS_OFFSET_TAX;

Line 295: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info.BEGIN',

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||
299: 'p_tax_regime_code = ' || p_tax_regime_code||

Line 296: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_offset_info(+)'||

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||
299: 'p_tax_regime_code = ' || p_tax_regime_code||
300: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code ||

Line 349: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info.END',

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

Line 350: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_offset_info(-)'||

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;
353:
354: EXCEPTION

Line 361: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_offset_info',

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

Line 379: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns.BEGIN',

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:
383: p_offset_tax_line_rec.orig_tax_status_id := NULL;

Line 380: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_null_columns(+)');

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:
383: p_offset_tax_line_rec.orig_tax_status_id := NULL;
384: p_offset_tax_line_rec.orig_tax_status_code := NULL;

Line 419: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns.END',

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:
423: EXCEPTION

Line 420: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_null_columns(-)');

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:
423: EXCEPTION
424: WHEN OTHERS THEN

Line 427: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_null_columns',

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:
431: END set_null_columns;

Line 446: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns.BEGIN',

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:
450: p_offset_tax_line_rec.Offset_Flag := 'Y'; --Bug6509867

Line 447: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_flg_columns(+)');

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:
450: p_offset_tax_line_rec.Offset_Flag := 'Y'; --Bug6509867
451: p_offset_tax_line_rec.Compounding_Tax_Flag := 'N';

Line 469: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns.END',

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:
473: EXCEPTION

Line 470: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_flg_columns(-)');

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:
473: EXCEPTION
474: WHEN OTHERS THEN

Line 477: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_flg_columns',

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:
481: END set_flg_columns;

Line 503: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.BEGIN',

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

Line 504: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(+)');

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

Line 544: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',

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:
548: IF (g_level_statement >= g_current_runtime_level) THEN

Line 550: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',

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

Line 645: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns.END',

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:
649: EXCEPTION

Line 646: 'ZX_TDS_OFFSET_TAX_DETM_PKG: set_amt_columns(-)'||p_return_status);

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:
649: EXCEPTION
650: WHEN OTHERS THEN

Line 656: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.set_amt_columns',

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:
660: END set_amt_columns;

Line 684: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.BEGIN',

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

Line 685: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(+)');

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;
688:
689: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

Line 704: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id.END',

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:
708: EXCEPTION

Line 705: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_status_id(-)');

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:
708: EXCEPTION
709: WHEN OTHERS THEN

Line 715: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_status_id',

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:
719: END get_tax_status_id;

Line 741: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.BEGIN',

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

Line 742: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(+)');

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

Line 761: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id.END',

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

Line 762: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_tax_id(-)'||

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

Line 774: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_tax_id',

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:
778: END get_tax_id;

Line 816: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_old_offset_tax_line_id.BEGIN',

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

Line 817: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_old_offset_tax_line_id(+)'||

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

Line 839: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_old_offset_tax_line_id.END',

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)||
843: 'p_return_status = ' || p_return_status);

Line 840: 'ZX_TDS_OFFSET_TAX_DETM_PKG: get_old_offset_tax_line_id(-)'||

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)||
843: 'p_return_status = ' || p_return_status);
844: END IF;

Line 853: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.get_old_offset_tax_line_id',

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:
857: END get_old_offset_tax_line_id;

Line 897: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line.BEGIN',

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

Line 898: 'ZX_TDS_OFFSET_TAX_DETM_PKG: create_offset_tax_line(+)');

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

Line 1046: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line.END',

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:
1050: EXCEPTION

Line 1047: 'ZX_TDS_OFFSET_TAX_DETM_PKG: create_offset_tax_line(-)'||p_return_status);

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:
1050: EXCEPTION
1051: WHEN OTHERS THEN

Line 1057: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.create_offset_tax_line',

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:
1061: END create_offset_tax_line;

Line 1063: END ZX_TDS_OFFSET_TAX_DETM_PKG;

1059: END IF;
1060:
1061: END create_offset_tax_line;
1062:
1063: END ZX_TDS_OFFSET_TAX_DETM_PKG;