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 34: x_return_status := FND_API.G_RET_STS_SUCCESS;

30: 'ZX_TRL_PUB_PKG: Manage_TaxLines (+)');
31: END IF;
32:
33: -- Initialize API return status to success
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: --
37: -- bug#4893261- populate message structure
38: --

Line 61: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 94: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

90: ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines
91: (x_return_status => x_return_status ,
92: p_event_class_rec => p_event_class_rec);
93:
94: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
95: IF (g_level_error >= g_current_runtime_level ) THEN
96: FND_LOG.STRING(g_level_error,
97: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
98: 'Incorrect return_status after calling ' ||

Line 117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

113: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
114: p_event_class_rec => p_event_class_rec,
115: x_return_status => x_return_status);
116:
117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
118: IF (g_level_error >= g_current_runtime_level ) THEN
119: FND_LOG.STRING(g_level_error,
120: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
121: 'Incorrect return_status after calling ' ||

Line 144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

140: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
141: p_event_class_rec => p_event_class_rec,
142: x_return_status => x_return_status);
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: IF (g_level_error >= g_current_runtime_level ) THEN
146: FND_LOG.STRING(g_level_error,
147: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
148: 'Incorrect return_status after calling ' ||

Line 165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

161: ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines
162: (x_return_status => x_return_status,
163: p_event_class_rec => p_event_class_rec);
164:
165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
166: IF (g_level_error >= g_current_runtime_level ) THEN
167: FND_LOG.STRING(g_level_error,
168: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
169: 'Incorrect return_status after calling ' ||

Line 194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

190: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
191: p_event_class_rec => p_event_class_rec,
192: x_return_status => x_return_status );
193:
194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
195: IF (g_level_error >= g_current_runtime_level ) THEN
196: FND_LOG.STRING(g_level_error,
197: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
198: 'Incorrect return_status after calling ' ||

Line 215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

211: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
212: p_event_class_rec => p_event_class_rec,
213: x_return_status => x_return_status);
214:
215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
216: IF (g_level_error >= g_current_runtime_level ) THEN
217: FND_LOG.STRING(g_level_error,
218: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
219: 'Incorrect return_status after calling ' ||

Line 238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

234: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
235: p_event_class_rec => p_event_class_rec,
236: x_return_status => x_return_status);
237:
238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
239: IF (g_level_error >= g_current_runtime_level ) THEN
240: FND_LOG.STRING(g_level_error,
241: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
242: 'Incorrect return_status after calling ' ||

Line 258: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

254: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_upd_evnt (
255: p_event_class_rec => p_event_class_rec,
256: x_return_status => x_return_status );
257:
258: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
259: IF (g_level_error >= g_current_runtime_level ) THEN
260: FND_LOG.STRING(g_level_error,
261: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
262: 'Incorrect return_status after calling ' ||

Line 283: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

279: ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions
280: (x_return_status => x_return_status,
281: p_event_class_rec => p_event_class_rec);
282:
283: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
284: IF (g_level_error >= g_current_runtime_level ) THEN
285: FND_LOG.STRING(g_level_error,
286: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
287: 'Incorrect return_status after calling ' ||

Line 311: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

307: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
308: p_event_class_rec => p_event_class_rec,
309: x_return_status => x_return_status );
310:
311: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
312: IF (g_level_error >= g_current_runtime_level ) THEN
313: FND_LOG.STRING(g_level_error,
314: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
315: 'Incorrect return_status after calling ' ||

Line 334: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

330: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
331: p_event_class_rec => p_event_class_rec,
332: x_return_status => x_return_status);
333:
334: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
335: IF (g_level_error >= g_current_runtime_level ) THEN
336: FND_LOG.STRING(g_level_error,
337: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
338: 'Incorrect return_status after calling ' ||

Line 367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

363: ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines
364: (x_return_status => x_return_status ,
365: p_event_class_rec => p_event_class_rec);
366:
367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
368: IF (g_level_error >= g_current_runtime_level ) THEN
369: FND_LOG.STRING(g_level_error,
370: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
371: 'Incorrect return_status after calling ' ||

Line 390: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

386: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
387: p_event_class_rec => p_event_class_rec,
388: x_return_status => x_return_status);
389:
390: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
391: IF (g_level_error >= g_current_runtime_level ) THEN
392: FND_LOG.STRING(g_level_error,
393: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
394: 'Incorrect return_status after calling ' ||

Line 417: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

413: ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
414: p_event_class_rec => p_event_class_rec,
415: x_return_status => x_return_status);
416:
417: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
418: IF (g_level_error >= g_current_runtime_level ) THEN
419: FND_LOG.STRING(g_level_error,
420: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
421: 'Incorrect return_status after calling ' ||

Line 438: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

434: ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines
435: (x_return_status => x_return_status,
436: p_event_class_rec => p_event_class_rec);
437:
438: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
439: IF (g_level_error >= g_current_runtime_level ) THEN
440: FND_LOG.STRING(g_level_error,
441: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
442: 'Incorrect return_status after calling ' ||

Line 469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

465: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
466: p_event_class_rec => p_event_class_rec,
467: x_return_status => x_return_status );
468:
469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
470: IF (g_level_error >= g_current_runtime_level ) THEN
471: FND_LOG.STRING(g_level_error,
472: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
473: 'Incorrect return_status after calling ' ||

Line 490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

486: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
487: p_event_class_rec => p_event_class_rec,
488: x_return_status => x_return_status);
489:
490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
491: IF (g_level_error >= g_current_runtime_level ) THEN
492: FND_LOG.STRING(g_level_error,
493: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
494: 'Incorrect return_status after calling ' ||

Line 516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

512: ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines (
513: p_event_class_rec => p_event_class_rec,
514: x_return_status => x_return_status);
515:
516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: IF (g_level_error >= g_current_runtime_level ) THEN
518: FND_LOG.STRING(g_level_error,
519: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
520: 'Incorrect return_status after calling ' ||

Line 536: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

532: ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_upd_evnt (
533: p_event_class_rec => p_event_class_rec,
534: x_return_status => x_return_status );
535:
536: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
537: IF (g_level_error >= g_current_runtime_level ) THEN
538: FND_LOG.STRING(g_level_error,
539: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
540: 'Incorrect return_status after calling ' ||

Line 562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

558: ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions
559: (x_return_status => x_return_status,
560: p_event_class_rec => p_event_class_rec);
561:
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: IF (g_level_error >= g_current_runtime_level ) THEN
564: FND_LOG.STRING(g_level_error,
565: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxLines',
566: 'Incorrect return_status after calling ' ||

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

585: END IF;
586:
587: EXCEPTION
588: WHEN OTHERS THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
591:
592: IF (g_level_unexpected >= g_current_runtime_level ) THEN
593: FND_LOG.STRING(g_level_unexpected,

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: 'ZX_TRL_PUB_PKG: Document_Level_Changes (+)');
625: END IF;
626:
627: -- Initialize API return status to success
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: IF (p_event_class_rec.TAX_EVENT_TYPE_CODE = 'DELETE') THEN
631:
632: ZX_TRL_MANAGE_TAX_PKG.DELETE_TRANSACTION

Line 660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

656:
657: -- end bug fix 3339364
658: END IF;
659:
660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;

Line 661: RAISE FND_API.G_EXC_ERROR;

657: -- end bug fix 3339364
658: END IF;
659:
660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665:

Line 662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

658: END IF;
659:
660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665:
666: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

659:
660: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
661: RAISE FND_API.G_EXC_ERROR;
662: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665:
666: IF (g_level_procedure >= g_current_runtime_level ) THEN
667: FND_LOG.STRING(g_level_procedure,

Line 673: WHEN FND_API.G_EXC_ERROR THEN

669: 'ZX_TRL_PUB_PKG: Document_Level_Changes (-)'||x_return_status);
670: END IF;
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: IF (g_level_unexpected >= g_current_runtime_level ) THEN
676: FND_LOG.STRING(g_level_unexpected,
677: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Document_Level_Changes',

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

670: END IF;
671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: IF (g_level_unexpected >= g_current_runtime_level ) THEN
676: FND_LOG.STRING(g_level_unexpected,
677: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Document_Level_Changes',
678: 'Return Status = ' || x_return_status);

Line 682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

678: 'Return Status = ' || x_return_status);
679: END IF;
680:
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
684:
685: IF (g_level_unexpected >= g_current_runtime_level ) THEN
686: FND_LOG.STRING(g_level_unexpected,

Line 714: x_return_status := FND_API.G_RET_STS_SUCCESS;

710: 'ZX_TRL_PUB_PKG: Synchronize_TaxLines (+)');
711: END IF;
712:
713: -- Initialize API return status to success
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715:
716: /****** no longer needed ***********
717: *ZX_TRL_MANAGE_TAX_PKG.Update_Transaction_Info
718: * (x_return_status => l_return_status);

Line 723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

719: *
720: *************************************/
721:
722:
723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;

Line 724: RAISE FND_API.G_EXC_ERROR;

720: *************************************/
721:
722:
723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:

Line 725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

721:
722:
723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722:
723: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
724: RAISE FND_API.G_EXC_ERROR;
725: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: IF (g_level_procedure >= g_current_runtime_level ) THEN
730: FND_LOG.STRING(g_level_procedure,

Line 736: WHEN FND_API.G_EXC_ERROR THEN

732: 'ZX_TRL_PUB_PKG: Synchronize_TaxLines (-)'||x_return_status);
733: END IF;
734:
735: EXCEPTION
736: WHEN FND_API.G_EXC_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: IF (g_level_unexpected >= g_current_runtime_level ) THEN
739: FND_LOG.STRING(g_level_unexpected,
740: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Synchronize_TaxLines',

Line 737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

733: END IF;
734:
735: EXCEPTION
736: WHEN FND_API.G_EXC_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: IF (g_level_unexpected >= g_current_runtime_level ) THEN
739: FND_LOG.STRING(g_level_unexpected,
740: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Synchronize_TaxLines',
741: 'Return Status = ' || x_return_status);

Line 745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

741: 'Return Status = ' || x_return_status);
742: END IF;
743:
744: WHEN OTHERS THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
747:
748: IF (g_level_unexpected >= g_current_runtime_level ) THEN
749: FND_LOG.STRING(g_level_unexpected,

Line 777: x_return_status := FND_API.G_RET_STS_SUCCESS;

773: 'ZX_TRL_PUB_PKG: Mark_Tax_Lines_Delete (+)');
774: END IF;
775:
776: -- Initialize API return status to success
777: x_return_status := FND_API.G_RET_STS_SUCCESS;
778:
779: ZX_TRL_MANAGE_TAX_PKG.Mark_Detail_Tax_Lines_Delete
780: (x_return_status => l_return_status ,
781: p_transaction_line_rec => p_transaction_line_rec);

Line 784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

780: (x_return_status => l_return_status ,
781: p_transaction_line_rec => p_transaction_line_rec);
782:
783:
784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;

Line 785: RAISE FND_API.G_EXC_ERROR;

781: p_transaction_line_rec => p_transaction_line_rec);
782:
783:
784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789:

Line 786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

782:
783:
784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789:
790: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

783:
784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789:
790: IF (g_level_procedure >= g_current_runtime_level ) THEN
791: FND_LOG.STRING(g_level_procedure,

Line 797: WHEN FND_API.G_EXC_ERROR THEN

793: 'ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete (-)'||x_return_status);
794: END IF;
795:
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: IF (g_level_unexpected >= g_current_runtime_level ) THEN
800: FND_LOG.STRING(g_level_unexpected,
801: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete',

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: END IF;
795:
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: IF (g_level_unexpected >= g_current_runtime_level ) THEN
800: FND_LOG.STRING(g_level_unexpected,
801: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete',
802: 'Return Status = ' || x_return_status);

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

802: 'Return Status = ' || x_return_status);
803: END IF;
804:
805: WHEN OTHERS THEN
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
808:
809: IF (g_level_unexpected >= g_current_runtime_level ) THEN
810: FND_LOG.STRING(g_level_unexpected,

Line 844: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 882: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

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

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

Line 904: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 910: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

914:
915: END IF;
916: END IF;
917:
918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
919: RAISE FND_API.G_EXC_ERROR;
920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
922: END IF;

Line 919: RAISE FND_API.G_EXC_ERROR;

915: END IF;
916: END IF;
917:
918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
919: RAISE FND_API.G_EXC_ERROR;
920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
922: END IF;
923:

Line 920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

916: END IF;
917:
918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
919: RAISE FND_API.G_EXC_ERROR;
920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
922: END IF;
923:
924: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

917:
918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
919: RAISE FND_API.G_EXC_ERROR;
920: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
922: END IF;
923:
924: IF (g_level_procedure >= g_current_runtime_level ) THEN
925: FND_LOG.STRING(g_level_procedure,

Line 931: WHEN FND_API.G_EXC_ERROR THEN

927: 'ZX_TRL_PUB_PKG: Manage_TaxDistributions (-)'||x_return_status);
928: END IF;
929:
930: EXCEPTION
931: WHEN FND_API.G_EXC_ERROR THEN
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: IF (g_level_unexpected >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_unexpected,
935: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxDistributions',

Line 932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

928: END IF;
929:
930: EXCEPTION
931: WHEN FND_API.G_EXC_ERROR THEN
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: IF (g_level_unexpected >= g_current_runtime_level ) THEN
934: FND_LOG.STRING(g_level_unexpected,
935: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Manage_TaxDistributions',
936: 'Return Status = ' || x_return_status);

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

936: 'Return Status = ' || x_return_status);
937: END IF;
938:
939: WHEN OTHERS THEN
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
942:
943: IF (g_level_unexpected >= g_current_runtime_level ) THEN
944: FND_LOG.STRING(g_level_unexpected,

Line 983: WHEN FND_API.G_EXC_ERROR THEN

979: 'ZX_TRL_PUB_PKG: Freeze_TaxDistributions (-)'||x_return_status);
980: END IF;
981:
982: EXCEPTION
983: WHEN FND_API.G_EXC_ERROR THEN
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: IF (g_level_unexpected >= g_current_runtime_level ) THEN
986: FND_LOG.STRING(g_level_unexpected,
987: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Freeze_TaxDistributions',

Line 984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

980: END IF;
981:
982: EXCEPTION
983: WHEN FND_API.G_EXC_ERROR THEN
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: IF (g_level_unexpected >= g_current_runtime_level ) THEN
986: FND_LOG.STRING(g_level_unexpected,
987: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Freeze_TaxDistributions',
988: 'Return Status = ' || x_return_status);

Line 992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

988: 'Return Status = ' || x_return_status);
989: END IF;
990:
991: WHEN OTHERS THEN
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
994:
995: IF (g_level_unexpected >= g_current_runtime_level ) THEN
996: FND_LOG.STRING(g_level_unexpected,

Line 1033: WHEN FND_API.G_EXC_ERROR THEN

1029: 'ZX_TRL_PUB_PKG: Update_Taxlines (-)'||x_return_status);
1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_unexpected,
1037: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines',

Line 1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1030: END IF;
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_unexpected,
1037: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines',
1038: 'Return Status = ' || x_return_status);

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: 'Return Status = ' || x_return_status);
1039: END IF;
1040:
1041: WHEN OTHERS THEN
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1044:
1045: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1046: FND_LOG.STRING(g_level_unexpected,

Line 1076: WHEN FND_API.G_EXC_ERROR THEN

1072: 'ZX_TRL_PUB_PKG: Discard_Tax_Only_Lines (-)'||x_return_status);
1073: END IF;
1074:
1075: EXCEPTION
1076: WHEN FND_API.G_EXC_ERROR THEN
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1079: FND_LOG.STRING(g_level_unexpected,
1080: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Discard_Tax_Only_Lines',

Line 1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1073: END IF;
1074:
1075: EXCEPTION
1076: WHEN FND_API.G_EXC_ERROR THEN
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1079: FND_LOG.STRING(g_level_unexpected,
1080: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Discard_Tax_Only_Lines',
1081: 'Return Status = ' || x_return_status);

Line 1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1081: 'Return Status = ' || x_return_status);
1082: END IF;
1083:
1084: WHEN OTHERS THEN
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1087:
1088: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1089: FND_LOG.STRING(g_level_unexpected,

Line 1121: WHEN FND_API.G_EXC_ERROR THEN

1117: 'ZX_TRL_PUB_PKG: Update_GL_Date (-)'||x_return_status);
1118: END IF;
1119:
1120: EXCEPTION
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1124: FND_LOG.STRING(g_level_unexpected,
1125: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date',

Line 1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1118: END IF;
1119:
1120: EXCEPTION
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1124: FND_LOG.STRING(g_level_unexpected,
1125: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date',
1126: 'Return Status = ' || x_return_status);

Line 1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1126: 'Return Status = ' || x_return_status);
1127: END IF;
1128:
1129: WHEN OTHERS THEN
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1132:
1133: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1134: FND_LOG.STRING(g_level_unexpected,

Line 1167: WHEN FND_API.G_EXC_ERROR THEN

1163: 'ZX_TRL_PUB_PKG: Update_Exchange_Rate (-)'||x_return_status);
1164: END IF;
1165:
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1170: FND_LOG.STRING(g_level_unexpected,
1171: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate',

Line 1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1164: END IF;
1165:
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1170: FND_LOG.STRING(g_level_unexpected,
1171: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate',
1172: 'Return Status = ' || x_return_status);

Line 1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1172: 'Return Status = ' || x_return_status);
1173: END IF;
1174:
1175: WHEN OTHERS THEN
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1178:
1179: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1180: FND_LOG.STRING(g_level_unexpected,

Line 1228: x_return_status := FND_API.G_RET_STS_SUCCESS;

1224: FND_LOG.STRING(g_level_procedure,
1225: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists.BEGIN',
1226: 'ZX_TRL_PUB_PKG: delete_tax_lines_and_dists (+)');
1227: END IF;
1228: x_return_status := FND_API.G_RET_STS_SUCCESS;
1229:
1230: -- delete the distributions
1231: DELETE FROM zx_rec_nrec_dist
1232: WHERE application_id = p_application_id

Line 1275: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1271: p_retain_summ_tax_line_id_flag
1272: => l_retain_summ_tax_line_id_flag,
1273: x_return_status => x_return_status
1274: );
1275: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1276: IF (g_level_error >= g_current_runtime_level ) THEN
1277: FND_LOG.STRING(g_level_error,
1278: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1279: 'MRC Lines: Incorrect return_status after calling ' ||

Line 1300: WHEN FND_API.G_EXC_ERROR THEN

1296: 'ZX_TRL_PUB_PKG: delete_tax_lines_and_dists (-)'||x_return_status);
1297: END IF;
1298:
1299: EXCEPTION
1300: WHEN FND_API.G_EXC_ERROR THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1303: FND_LOG.STRING(g_level_unexpected,
1304: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',

Line 1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1297: END IF;
1298:
1299: EXCEPTION
1300: WHEN FND_API.G_EXC_ERROR THEN
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1303: FND_LOG.STRING(g_level_unexpected,
1304: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
1305: 'Return Status = ' || x_return_status);

Line 1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1305: 'Return Status = ' || x_return_status);
1306: END IF;
1307:
1308: WHEN OTHERS THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1311:
1312: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1313: FND_LOG.STRING(g_level_unexpected,

Line 1350: x_return_status := FND_API.G_RET_STS_SUCCESS;

1346: FND_LOG.STRING(g_level_procedure,
1347: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists.BEGIN',
1348: 'ZX_TRL_PUB_PKG: delete_tax_dists (+)');
1349: END IF;
1350: x_return_status := FND_API.G_RET_STS_SUCCESS;
1351:
1352: DELETE FROM zx_rec_nrec_dist
1353: WHERE application_id = p_application_id
1354: AND entity_code = p_entity_code

Line 1384: WHEN FND_API.G_EXC_ERROR THEN

1380: 'ZX_TRL_PUB_PKG: delete_tax_dists (-)'||x_return_status);
1381: END IF;
1382:
1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1387: FND_LOG.STRING(g_level_unexpected,
1388: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists',

Line 1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1381: END IF;
1382:
1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1387: FND_LOG.STRING(g_level_unexpected,
1388: 'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists',
1389: 'Return Status = ' || x_return_status);

Line 1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1389: 'Return Status = ' || x_return_status);
1390: END IF;
1391:
1392: WHEN OTHERS THEN
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1394: l_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1395:
1396: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1397: FND_LOG.STRING(g_level_unexpected,