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_TRL_PUB_PKG dependencies on FND_API

Line 39: x_return_status := FND_API.G_RET_STS_SUCCESS;

35: 'ZX_TRL_PUB_PKG: Manage_TaxLines (+)');
36: END IF;
37:
38: -- Initialize API return status to success
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: --
42: -- bug#4893261- populate message structure
43: --

Line 66: x_return_status := FND_API.G_RET_STS_ERROR;

62: -- c_lines loop of service types pkg. Hence we should not raise error if the
63: -- p_event_class_rec.TAX_EVENT_TYPE_CODE IS NULL.
64: /*
65: IF p_event_class_rec.TAX_EVENT_TYPE_CODE IS NULL THEN
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: FND_MESSAGE.SET_NAME('ZX','ZX_TRL_NULL_VALUES');
68: ZX_API_PUB.add_msg(l_msg_context_info_rec);
69: RETURN;
70: END IF;

Line 99: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

95: ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines
96: (x_return_status => x_return_status ,
97: p_event_class_rec => p_event_class_rec);
98:
99: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
100: IF (g_level_error >= g_current_runtime_level ) THEN
101: FND_LOG.STRING(g_level_error,
102: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
103: 'Incorrect return_status after calling ' ||

Line 122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

118: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
119: p_event_class_rec => p_event_class_rec,
120: x_return_status => x_return_status);
121:
122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
123: IF (g_level_error >= g_current_runtime_level ) THEN
124: FND_LOG.STRING(g_level_error,
125: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
126: 'Incorrect return_status after calling ' ||

Line 149: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

145: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
146: p_event_class_rec => p_event_class_rec,
147: x_return_status => x_return_status);
148:
149: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
150: IF (g_level_error >= g_current_runtime_level ) THEN
151: FND_LOG.STRING(g_level_error,
152: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
153: 'Incorrect return_status after calling ' ||

Line 170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

166: ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines
167: (x_return_status => x_return_status,
168: p_event_class_rec => p_event_class_rec);
169:
170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
171: IF (g_level_error >= g_current_runtime_level ) THEN
172: FND_LOG.STRING(g_level_error,
173: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
174: 'Incorrect return_status after calling ' ||

Line 199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

195: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
196: p_event_class_rec => p_event_class_rec,
197: x_return_status => x_return_status );
198:
199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
200: IF (g_level_error >= g_current_runtime_level ) THEN
201: FND_LOG.STRING(g_level_error,
202: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
203: 'Incorrect return_status after calling ' ||

Line 220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

216: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
217: p_event_class_rec => p_event_class_rec,
218: x_return_status => x_return_status);
219:
220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
221: IF (g_level_error >= g_current_runtime_level ) THEN
222: FND_LOG.STRING(g_level_error,
223: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
224: 'Incorrect return_status after calling ' ||

Line 243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

239: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
240: p_event_class_rec => p_event_class_rec,
241: x_return_status => x_return_status);
242:
243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: IF (g_level_error >= g_current_runtime_level ) THEN
245: FND_LOG.STRING(g_level_error,
246: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
247: 'Incorrect return_status after calling ' ||

Line 263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

259: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_upd_evnt (
260: p_event_class_rec => p_event_class_rec,
261: x_return_status => x_return_status );
262:
263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: IF (g_level_error >= g_current_runtime_level ) THEN
265: FND_LOG.STRING(g_level_error,
266: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
267: 'Incorrect return_status after calling ' ||

Line 288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

284: ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions
285: (x_return_status => x_return_status,
286: p_event_class_rec => p_event_class_rec);
287:
288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: IF (g_level_error >= g_current_runtime_level ) THEN
290: FND_LOG.STRING(g_level_error,
291: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
292: 'Incorrect return_status after calling ' ||

Line 316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

312: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
313: p_event_class_rec => p_event_class_rec,
314: x_return_status => x_return_status );
315:
316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
317: IF (g_level_error >= g_current_runtime_level ) THEN
318: FND_LOG.STRING(g_level_error,
319: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
320: 'Incorrect return_status after calling ' ||

Line 339: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

335: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
336: p_event_class_rec => p_event_class_rec,
337: x_return_status => x_return_status);
338:
339: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
340: IF (g_level_error >= g_current_runtime_level ) THEN
341: FND_LOG.STRING(g_level_error,
342: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
343: 'Incorrect return_status after calling ' ||

Line 372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

368: ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines
369: (x_return_status => x_return_status ,
370: p_event_class_rec => p_event_class_rec);
371:
372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: IF (g_level_error >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_error,
375: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
376: 'Incorrect return_status after calling ' ||

Line 395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

391: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
392: p_event_class_rec => p_event_class_rec,
393: x_return_status => x_return_status);
394:
395: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
396: IF (g_level_error >= g_current_runtime_level ) THEN
397: FND_LOG.STRING(g_level_error,
398: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
399: 'Incorrect return_status after calling ' ||

Line 422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

418: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
419: p_event_class_rec => p_event_class_rec,
420: x_return_status => x_return_status);
421:
422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: IF (g_level_error >= g_current_runtime_level ) THEN
424: FND_LOG.STRING(g_level_error,
425: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
426: 'Incorrect return_status after calling ' ||

Line 443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

439: ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines
440: (x_return_status => x_return_status,
441: p_event_class_rec => p_event_class_rec);
442:
443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
444: IF (g_level_error >= g_current_runtime_level ) THEN
445: FND_LOG.STRING(g_level_error,
446: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
447: 'Incorrect return_status after calling ' ||

Line 474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

470: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
471: p_event_class_rec => p_event_class_rec,
472: x_return_status => x_return_status );
473:
474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
475: IF (g_level_error >= g_current_runtime_level ) THEN
476: FND_LOG.STRING(g_level_error,
477: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
478: 'Incorrect return_status after calling ' ||

Line 495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

491: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
492: p_event_class_rec => p_event_class_rec,
493: x_return_status => x_return_status);
494:
495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF (g_level_error >= g_current_runtime_level ) THEN
497: FND_LOG.STRING(g_level_error,
498: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
499: 'Incorrect return_status after calling ' ||

Line 521: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

517: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
518: p_event_class_rec => p_event_class_rec,
519: x_return_status => x_return_status);
520:
521: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
522: IF (g_level_error >= g_current_runtime_level ) THEN
523: FND_LOG.STRING(g_level_error,
524: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
525: 'Incorrect return_status after calling ' ||

Line 541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

537: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_upd_evnt (
538: p_event_class_rec => p_event_class_rec,
539: x_return_status => x_return_status );
540:
541: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
542: IF (g_level_error >= g_current_runtime_level ) THEN
543: FND_LOG.STRING(g_level_error,
544: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
545: 'Incorrect return_status after calling ' ||

Line 567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

563: ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions
564: (x_return_status => x_return_status,
565: p_event_class_rec => p_event_class_rec);
566:
567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
568: IF (g_level_error >= g_current_runtime_level ) THEN
569: FND_LOG.STRING(g_level_error,
570: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
571: 'Incorrect return_status after calling ' ||

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

590: END IF;
591:
592: EXCEPTION
593: WHEN OTHERS THEN
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
596:
597: IF (g_level_unexpected >= g_current_runtime_level ) THEN
598: FND_LOG.STRING(g_level_unexpected,

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: 'ZX_TRL_PUB_PKG: Document_Level_Changes (+)');
630: END IF;
631:
632: -- Initialize API return status to success
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: IF (p_event_class_rec.TAX_EVENT_TYPE_CODE = 'DELETE') THEN
636:
637: ZX_TRL_MANAGE_TAX_PKG.DELETE_TRANSACTION

Line 665: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

661:
662: -- end bug fix 3339364
663: END IF;
664:
665: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
666: RAISE FND_API.G_EXC_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;

Line 666: RAISE FND_API.G_EXC_ERROR;

662: -- end bug fix 3339364
663: END IF;
664:
665: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
666: RAISE FND_API.G_EXC_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:

Line 667: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

663: END IF;
664:
665: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
666: RAISE FND_API.G_EXC_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664:
665: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
666: RAISE FND_API.G_EXC_ERROR;
667: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: IF (g_level_procedure >= g_current_runtime_level ) THEN
672: FND_LOG.STRING(g_level_procedure,

Line 678: WHEN FND_API.G_EXC_ERROR THEN

674: 'ZX_TRL_PUB_PKG: Document_Level_Changes (-)'||x_return_status);
675: END IF;
676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF (g_level_unexpected >= g_current_runtime_level ) THEN
681: FND_LOG.STRING(g_level_unexpected,
682: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Document_Level_Changes',

Line 679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

675: END IF;
676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_ERROR THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF (g_level_unexpected >= g_current_runtime_level ) THEN
681: FND_LOG.STRING(g_level_unexpected,
682: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Document_Level_Changes',
683: 'Return Status = ' || x_return_status);

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

683: 'Return Status = ' || x_return_status);
684: END IF;
685:
686: WHEN OTHERS THEN
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
689:
690: IF (g_level_unexpected >= g_current_runtime_level ) THEN
691: FND_LOG.STRING(g_level_unexpected,

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

715: 'ZX_TRL_PUB_PKG: Synchronize_TaxLines (+)');
716: END IF;
717:
718: -- Initialize API return status to success
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: /****** no longer needed ***********
722: *ZX_TRL_MANAGE_TAX_PKG.Update_Transaction_Info
723: * (x_return_status => l_return_status);

Line 728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

724: *
725: *************************************/
726:
727:
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;

Line 729: RAISE FND_API.G_EXC_ERROR;

725: *************************************/
726:
727:
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:

Line 730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

726:
727:
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727:
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: IF (g_level_procedure >= g_current_runtime_level ) THEN
735: FND_LOG.STRING(g_level_procedure,

Line 741: WHEN FND_API.G_EXC_ERROR THEN

737: 'ZX_TRL_PUB_PKG: Synchronize_TaxLines (-)'||x_return_status);
738: END IF;
739:
740: EXCEPTION
741: WHEN FND_API.G_EXC_ERROR THEN
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: IF (g_level_unexpected >= g_current_runtime_level ) THEN
744: FND_LOG.STRING(g_level_unexpected,
745: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Synchronize_TaxLines',

Line 742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

738: END IF;
739:
740: EXCEPTION
741: WHEN FND_API.G_EXC_ERROR THEN
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: IF (g_level_unexpected >= g_current_runtime_level ) THEN
744: FND_LOG.STRING(g_level_unexpected,
745: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Synchronize_TaxLines',
746: 'Return Status = ' || x_return_status);

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

746: 'Return Status = ' || x_return_status);
747: END IF;
748:
749: WHEN OTHERS THEN
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
752:
753: IF (g_level_unexpected >= g_current_runtime_level ) THEN
754: FND_LOG.STRING(g_level_unexpected,

Line 782: x_return_status := FND_API.G_RET_STS_SUCCESS;

778: 'ZX_TRL_PUB_PKG: Mark_Tax_Lines_Delete (+)');
779: END IF;
780:
781: -- Initialize API return status to success
782: x_return_status := FND_API.G_RET_STS_SUCCESS;
783:
784: ZX_TRL_MANAGE_TAX_PKG.Mark_Detail_Tax_Lines_Delete
785: (x_return_status => l_return_status ,
786: p_transaction_line_rec => p_transaction_line_rec);

Line 789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

785: (x_return_status => l_return_status ,
786: p_transaction_line_rec => p_transaction_line_rec);
787:
788:
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;

Line 790: RAISE FND_API.G_EXC_ERROR;

786: p_transaction_line_rec => p_transaction_line_rec);
787:
788:
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:

Line 791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

787:
788:
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788:
789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
790: RAISE FND_API.G_EXC_ERROR;
791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: IF (g_level_procedure >= g_current_runtime_level ) THEN
796: FND_LOG.STRING(g_level_procedure,

Line 802: WHEN FND_API.G_EXC_ERROR THEN

798: 'ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete (-)'||x_return_status);
799: END IF;
800:
801: EXCEPTION
802: WHEN FND_API.G_EXC_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: IF (g_level_unexpected >= g_current_runtime_level ) THEN
805: FND_LOG.STRING(g_level_unexpected,
806: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete',

Line 803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

799: END IF;
800:
801: EXCEPTION
802: WHEN FND_API.G_EXC_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: IF (g_level_unexpected >= g_current_runtime_level ) THEN
805: FND_LOG.STRING(g_level_unexpected,
806: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete',
807: 'Return Status = ' || x_return_status);

Line 811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

807: 'Return Status = ' || x_return_status);
808: END IF;
809:
810: WHEN OTHERS THEN
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
813:
814: IF (g_level_unexpected >= g_current_runtime_level ) THEN
815: FND_LOG.STRING(g_level_unexpected,

Line 847: x_return_status := FND_API.G_RET_STS_SUCCESS;

843: 'ZX_TRL_PUB_PKG: Manage_TaxDistributions (+)');
844: END IF;
845:
846: -- Initialize API return status to success
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848:
849: --
850: -- bug#4893261- populate message structure
851: --

Line 879: IF (l_return_status= FND_API.G_RET_STS_SUCCESS) THEN

875: (x_return_status => l_return_status ,
876: p_event_class_rec => p_event_class_rec);
877:
878:
879: IF (l_return_status= FND_API.G_RET_STS_SUCCESS) THEN
880: ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions
881: (x_return_status => l_return_status);
882:
883: END IF;

Line 885: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN

881: (x_return_status => l_return_status);
882:
883: END IF;
884:
885: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
886: -- FND_MESSAGE.SET_NAME('ZX','ZX_TRL_RECORD_ALREADY_EXISTS');
887: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);
888: --END IF;
889:

Line 890: IF (l_return_status= FND_API.G_RET_STS_SUCCESS) THEN

886: -- FND_MESSAGE.SET_NAME('ZX','ZX_TRL_RECORD_ALREADY_EXISTS');
887: -- ZX_API_PUB.add_msg(l_msg_context_info_rec);
888: --END IF;
889:
890: IF (l_return_status= FND_API.G_RET_STS_SUCCESS) THEN
891: ZX_TRL_MANAGE_TAX_PKG.Update_Taxline_Rec_Nrec_amt
892: (x_return_status => l_return_status ,
893: p_event_class_rec => p_event_class_rec);
894:

Line 907: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

903: ZX_TRL_MANAGE_TAX_PKG.delete_tax_distributions(
904: x_return_status => l_return_status,
905: p_event_class_rec => p_event_class_rec);
906:
907: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
908: ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions
909: (x_return_status => l_return_status);
910:
911: END IF;

Line 913: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

909: (x_return_status => l_return_status);
910:
911: END IF;
912:
913: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
914: ZX_TRL_MANAGE_TAX_PKG.update_taxline_rec_nrec_amt(
915: x_return_status => l_return_status,
916: p_event_class_rec => p_event_class_rec);
917:

Line 923: IF (l_return_status= FND_API.G_RET_STS_SUCCESS) THEN

919: END IF;
920:
921: -- Added preventive check to find deleted frozen tax dists --
922: -- Start --
923: IF (l_return_status= FND_API.G_RET_STS_SUCCESS) THEN
924: IF p_event_class_rec.application_id = 200 THEN
925: ZX_TRL_PUB_PKG.Check_Frozen_Tax_Dists
926: (x_return_status => l_return_status,
927: p_event_class_rec => p_event_class_rec);

Line 929: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

925: ZX_TRL_PUB_PKG.Check_Frozen_Tax_Dists
926: (x_return_status => l_return_status,
927: p_event_class_rec => p_event_class_rec);
928:
929: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932: END IF;
933: END IF;

Line 930: RAISE FND_API.G_EXC_ERROR;

926: (x_return_status => l_return_status,
927: p_event_class_rec => p_event_class_rec);
928:
929: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932: END IF;
933: END IF;
934: -- End --

Line 936: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

932: END IF;
933: END IF;
934: -- End --
935:
936: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
937: RAISE FND_API.G_EXC_ERROR;
938: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: END IF;

Line 937: RAISE FND_API.G_EXC_ERROR;

933: END IF;
934: -- End --
935:
936: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
937: RAISE FND_API.G_EXC_ERROR;
938: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:

Line 938: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

934: -- End --
935:
936: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
937: RAISE FND_API.G_EXC_ERROR;
938: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:
942: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

935:
936: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
937: RAISE FND_API.G_EXC_ERROR;
938: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: END IF;
941:
942: IF (g_level_procedure >= g_current_runtime_level ) THEN
943: FND_LOG.STRING(g_level_procedure,

Line 949: WHEN FND_API.G_EXC_ERROR THEN

945: 'ZX_TRL_PUB_PKG: Manage_TaxDistributions (-)'||x_return_status);
946: END IF;
947:
948: EXCEPTION
949: WHEN FND_API.G_EXC_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: IF (g_level_unexpected >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_unexpected,
953: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxDistributions',

Line 950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

946: END IF;
947:
948: EXCEPTION
949: WHEN FND_API.G_EXC_ERROR THEN
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: IF (g_level_unexpected >= g_current_runtime_level ) THEN
952: FND_LOG.STRING(g_level_unexpected,
953: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxDistributions',
954: 'Unexpected Error. Return_Status = '||x_return_status);

Line 961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

957: 'ZX_TRL_PUB_PKG: Manage_TaxDistributions (-)');
958: END IF;
959:
960: WHEN OTHERS THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
963:
964: IF (g_level_unexpected >= g_current_runtime_level ) THEN
965: FND_LOG.STRING(g_level_unexpected,

Line 1004: WHEN FND_API.G_EXC_ERROR THEN

1000: 'ZX_TRL_PUB_PKG: Freeze_TaxDistributions (-)'||x_return_status);
1001: END IF;
1002:
1003: EXCEPTION
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1006: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1007: FND_LOG.STRING(g_level_unexpected,
1008: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Freeze_TaxDistributions',

Line 1005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1001: END IF;
1002:
1003: EXCEPTION
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1006: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1007: FND_LOG.STRING(g_level_unexpected,
1008: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Freeze_TaxDistributions',
1009: 'Return Status = ' || x_return_status);

Line 1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1009: 'Return Status = ' || x_return_status);
1010: END IF;
1011:
1012: WHEN OTHERS THEN
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1015:
1016: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1017: FND_LOG.STRING(g_level_unexpected,

Line 1054: WHEN FND_API.G_EXC_ERROR THEN

1050: 'ZX_TRL_PUB_PKG: Update_Taxlines (-)'||x_return_status);
1051: END IF;
1052:
1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1057: FND_LOG.STRING(g_level_unexpected,
1058: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines',

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1051: END IF;
1052:
1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1057: FND_LOG.STRING(g_level_unexpected,
1058: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines',
1059: 'Return Status = ' || x_return_status);

Line 1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1059: 'Return Status = ' || x_return_status);
1060: END IF;
1061:
1062: WHEN OTHERS THEN
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1065:
1066: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1067: FND_LOG.STRING(g_level_unexpected,

Line 1097: WHEN FND_API.G_EXC_ERROR THEN

1093: 'ZX_TRL_PUB_PKG: Discard_Tax_Only_Lines (-)'||x_return_status);
1094: END IF;
1095:
1096: EXCEPTION
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1100: FND_LOG.STRING(g_level_unexpected,
1101: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Discard_Tax_Only_Lines',

Line 1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1094: END IF;
1095:
1096: EXCEPTION
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1100: FND_LOG.STRING(g_level_unexpected,
1101: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Discard_Tax_Only_Lines',
1102: 'Return Status = ' || x_return_status);

Line 1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1102: 'Return Status = ' || x_return_status);
1103: END IF;
1104:
1105: WHEN OTHERS THEN
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1108:
1109: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1110: FND_LOG.STRING(g_level_unexpected,

Line 1142: WHEN FND_API.G_EXC_ERROR THEN

1138: 'ZX_TRL_PUB_PKG: Update_GL_Date (-)'||x_return_status);
1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1145: FND_LOG.STRING(g_level_unexpected,
1146: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date',

Line 1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1145: FND_LOG.STRING(g_level_unexpected,
1146: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date',
1147: 'Return Status = ' || x_return_status);

Line 1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1147: 'Return Status = ' || x_return_status);
1148: END IF;
1149:
1150: WHEN OTHERS THEN
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1153:
1154: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1155: FND_LOG.STRING(g_level_unexpected,

Line 1188: WHEN FND_API.G_EXC_ERROR THEN

1184: 'ZX_TRL_PUB_PKG: Update_Exchange_Rate (-)'||x_return_status);
1185: END IF;
1186:
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1191: FND_LOG.STRING(g_level_unexpected,
1192: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate',

Line 1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1185: END IF;
1186:
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1191: FND_LOG.STRING(g_level_unexpected,
1192: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate',
1193: 'Return Status = ' || x_return_status);

Line 1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1193: 'Return Status = ' || x_return_status);
1194: END IF;
1195:
1196: WHEN OTHERS THEN
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1199:
1200: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1201: FND_LOG.STRING(g_level_unexpected,

Line 1249: x_return_status := FND_API.G_RET_STS_SUCCESS;

1245: FND_LOG.STRING(g_level_procedure,
1246: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists.BEGIN',
1247: 'ZX_TRL_PUB_PKG: delete_tax_lines_and_dists (+)');
1248: END IF;
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250:
1251: -- delete the distributions
1252: DELETE FROM zx_rec_nrec_dist
1253: WHERE application_id = p_application_id

Line 1296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1292: p_retain_summ_tax_line_id_flag
1293: => l_retain_summ_tax_line_id_flag,
1294: x_return_status => x_return_status
1295: );
1296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1297: IF (g_level_error >= g_current_runtime_level ) THEN
1298: FND_LOG.STRING(g_level_error,
1299: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1300: 'MRC Lines: Incorrect return_status after calling ' ||

Line 1321: WHEN FND_API.G_EXC_ERROR THEN

1317: 'ZX_TRL_PUB_PKG: delete_tax_lines_and_dists (-)'||x_return_status);
1318: END IF;
1319:
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1323: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1324: FND_LOG.STRING(g_level_unexpected,
1325: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',

Line 1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1318: END IF;
1319:
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1323: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1324: FND_LOG.STRING(g_level_unexpected,
1325: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1326: 'Return Status = ' || x_return_status);

Line 1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1326: 'Return Status = ' || x_return_status);
1327: END IF;
1328:
1329: WHEN OTHERS THEN
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1332:
1333: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1334: FND_LOG.STRING(g_level_unexpected,

Line 1371: x_return_status := FND_API.G_RET_STS_SUCCESS;

1367: FND_LOG.STRING(g_level_procedure,
1368: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists.BEGIN',
1369: 'ZX_TRL_PUB_PKG: delete_tax_dists (+)');
1370: END IF;
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372:
1373: DELETE FROM zx_rec_nrec_dist
1374: WHERE application_id = p_application_id
1375: AND entity_code = p_entity_code

Line 1405: WHEN FND_API.G_EXC_ERROR THEN

1401: 'ZX_TRL_PUB_PKG: delete_tax_dists (-)'||x_return_status);
1402: END IF;
1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1408: FND_LOG.STRING(g_level_unexpected,
1409: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists',

Line 1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1402: END IF;
1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1407: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1408: FND_LOG.STRING(g_level_unexpected,
1409: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists',
1410: 'Return Status = ' || x_return_status);

Line 1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1410: 'Return Status = ' || x_return_status);
1411: END IF;
1412:
1413: WHEN OTHERS THEN
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1416:
1417: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1418: FND_LOG.STRING(g_level_unexpected,

Line 1506: x_return_status := FND_API.G_RET_STS_SUCCESS;

1502: 'ZX_TRL_PUB_PKG: Check_Frozen_Tax_Dists (+)');
1503: END IF;
1504:
1505: -- Initialize API return status to success
1506: x_return_status := FND_API.G_RET_STS_SUCCESS;
1507:
1508: l_msg_context_info_rec.application_id := p_event_class_rec.application_id;
1509: l_msg_context_info_rec.entity_code := p_event_class_rec.entity_code;
1510: l_msg_context_info_rec.event_class_code := p_event_class_rec.event_class_code;

Line 1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1535: l_summary_tax_line_id_tbl;
1536: CLOSE get_deleted_frzn_dist;
1537:
1538: IF l_trx_id_tbl.COUNT > 0 THEN
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: l_error_buffer := 'System is trying to delete frozen tax distributions. '||
1541: 'Unable to complete Tax Processing.';
1542:
1543: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1583: l_summary_tax_line_id_tbl;
1584: CLOSE get_deleted_frzn_sa_dist;
1585:
1586: IF l_trx_id_tbl.COUNT > 0 THEN
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: l_error_buffer := 'System is trying to delete self-assessed frozen tax distributions. '||
1589: 'Unable to complete Tax Processing.';
1590:
1591: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1631: END IF;
1632:
1633: EXCEPTION
1634: WHEN OTHERS THEN
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1637:
1638: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1639: FND_LOG.STRING(g_level_unexpected,