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.43.12010000.2 2008/11/12 12:22:45 spasala ship $ */
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 200: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax.END',

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

Line 220: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax.END',

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

Line 221: 'ZX_TDS_OFFSET_TAX_DETM_PKG: process_offset_tax(-)'||p_return_status);

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:
224: EXCEPTION
225: WHEN OTHERS THEN

Line 231: 'ZX.PLSQL.ZX_TDS_OFFSET_TAX_DETM_PKG.process_offset_tax',

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:
235: END process_offset_tax;

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

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

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

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||
295: 'p_tax_regime_code = ' || p_tax_regime_code||
296: 'p_tax_jurisdiction_code = ' || p_tax_jurisdiction_code ||

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

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

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

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;
351:
352: EXCEPTION

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

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

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

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

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

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

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

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

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

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:
414: EXCEPTION
415: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

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:
464: EXCEPTION
465: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
644: EXCEPTION
645: WHEN OTHERS THEN

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

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

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

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

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

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;
683:
684: ZX_TDS_UTILITIES_PKG.get_tax_status_cache_info(

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

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

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

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:
704: EXCEPTION
705: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:
1038: EXCEPTION
1039: WHEN OTHERS THEN

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

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

Line 1051: END ZX_TDS_OFFSET_TAX_DETM_PKG;

1047: END IF;
1048:
1049: END create_offset_tax_line;
1050:
1051: END ZX_TDS_OFFSET_TAX_DETM_PKG;