DBA Data[Home] [Help]

APPS.M4U_SETUP_PACKAGE dependencies on FND_API

Line 175: RAISE FND_API.G_EXC_ERROR;

171: FND_MESSAGE.SET_TOKEN('PARAM2',l_transaction_subtype);
172: FND_MESSAGE.SET_TOKEN('PARAM3',l_direction);
173: FND_MESSAGE.SET_TOKEN('PARAM4',l_standard_code);
174: l_msg_data := FND_MESSAGE.GET;
175: RAISE FND_API.G_EXC_ERROR;
176: END;
177:
178: BEGIN
179: IF (l_Debug_Level <= 1) THEN

Line 221: RAISE FND_API.G_EXC_ERROR;

217:
218: IF (l_Debug_Level <= 1) THEN
219: cln_debug_pub.Add('-- Two Many Ext Process ID for M4U exists --',1);
220: END IF;
221: RAISE FND_API.G_EXC_ERROR;
222:
223: WHEN OTHERS THEN
224: l_msg_data := SQLCODE ||'-'||SQLERRM;
225: IF (l_Debug_Level <= 1) THEN

Line 229: RAISE FND_API.G_EXC_ERROR;

225: IF (l_Debug_Level <= 1) THEN
226: cln_debug_pub.Add('ERROR -'||l_msg_data,1);
227: cln_debug_pub.Add('-- Error in Finding the External Process ID --',1);
228: END IF;
229: RAISE FND_API.G_EXC_ERROR;
230: END;
231:
232:
233: IF NOT l_record_found THEN

Line 262: RAISE FND_API.G_EXC_ERROR;

258: IF l_retcode <> 0 THEN
259: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_API_FAILED');
260: FND_MESSAGE.SET_TOKEN('PARAM1','create');
261: l_msg_data := FND_MESSAGE.GET;
262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265: IF (l_Debug_Level <= 1) THEN
266: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

Line 297: RAISE FND_API.G_EXC_ERROR;

293: IF l_retcode <> 0 THEN
294: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_API_FAILED');
295: FND_MESSAGE.SET_TOKEN('PARAM1','update');
296: l_msg_data := FND_MESSAGE.GET;
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300: IF (l_Debug_Level <= 1) THEN
301: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

Line 306: x_retcode := FND_API.G_RET_STS_SUCCESS;

302: END IF;
303: END IF;
304:
305: IF l_retcode = 0 THEN
306: x_retcode := FND_API.G_RET_STS_SUCCESS;
307: x_errbuf := 'Successful';
308: END IF;
309:
310: cln_debug_pub.Add('Exiting add_or_update_tp_detail normally');

Line 314: WHEN FND_API.G_EXC_ERROR THEN

310: cln_debug_pub.Add('Exiting add_or_update_tp_detail normally');
311:
312: -- Exception Handling
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: x_retcode := 2;
316: x_errbuf := l_msg_data;
317:
318: IF (l_Debug_Level <= 2) THEN

Line 451: RAISE FND_API.G_EXC_ERROR;

447:
448: WHEN OTHERS THEN
449: FND_MESSAGE.SET_NAME('CLN','M4U_HR_API_ISSUE');
450: l_msg_data := FND_MESSAGE.GET;
451: RAISE FND_API.G_EXC_ERROR;
452: END;
453:
454: IF NOT l_record_found THEN
455: IF (l_Debug_Level <= 1) THEN

Line 549: RAISE FND_API.G_EXC_ERROR;

545:
546: WHEN OTHERS THEN
547: FND_MESSAGE.SET_NAME('CLN','M4U_TP_HDR_SETUP_ISSUE');
548: l_msg_data := FND_MESSAGE.GET;
549: RAISE FND_API.G_EXC_ERROR;
550: END;
551:
552: IF NOT l_record_found THEN
553: IF (l_Debug_Level <= 1) THEN

Line 578: RAISE FND_API.G_EXC_ERROR;

574: IF l_retcode <> 0 THEN
575: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPHDR_API_FAILED');
576: FND_MESSAGE.SET_TOKEN('PARAM','Create');
577: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: IF (l_Debug_Level <= 1) THEN
582: cln_debug_pub.Add('---- ecx_tp_api.create_trading_partner returns Normal----', 1);

Line 607: RAISE FND_API.G_EXC_ERROR;

603: IF l_retcode <> 0 THEN
604: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPHDR_API_FAILED');
605: FND_MESSAGE.SET_TOKEN('PARAM','update');
606: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
607: RAISE FND_API.G_EXC_ERROR;
608: END IF;
609:
610: IF (l_Debug_Level <= 1) THEN
611: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

Line 628: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

624: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
625: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
626: END IF;
627:
628: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
629: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
630: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;

Line 631: RAISE FND_API.G_EXC_ERROR;

627:
628: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
629: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
630: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;
633:
634: --2
635: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'GBREGQRY','m4u_230_gbreg_qry_out','OUT',l_tp_hdr_id);

Line 642: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

638: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
639: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
640: END IF;
641:
642: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
643: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
644: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;

Line 645: RAISE FND_API.G_EXC_ERROR;

641:
642: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
643: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
644: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;
647:
648:
649: --3

Line 657: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

653: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
654: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
655: END IF;
656:
657: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
658: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
659: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
660: RAISE FND_API.G_EXC_ERROR;
661:

Line 660: RAISE FND_API.G_EXC_ERROR;

656:
657: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
658: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
659: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
660: RAISE FND_API.G_EXC_ERROR;
661:
662: END IF;
663:
664: --4

Line 672: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

668: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
669: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
670: END IF;
671:
672: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
673: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
674: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;

Line 675: RAISE FND_API.G_EXC_ERROR;

671:
672: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
673: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
674: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677:
678: --5
679: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'WLQ','m4u_230_wlq_out','OUT',l_tp_hdr_id);

Line 686: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

682: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
683: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
684: END IF;
685:
686: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
687: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
688: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;

Line 689: RAISE FND_API.G_EXC_ERROR;

685:
686: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
687: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
688: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;
691:
692: --6
693: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_ACK','m4u_230_resp_ack_in','IN',l_tp_hdr_id);

Line 700: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

696: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
697: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
698: END IF;
699:
700: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
701: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
702: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;

Line 703: RAISE FND_API.G_EXC_ERROR;

699:
700: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
701: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
702: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:
706: --7
707: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_BATCH','m4u_230_resp_batch_in','IN',l_tp_hdr_id);

Line 714: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

710: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
711: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
712: END IF;
713:
714: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
715: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
716: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;

Line 717: RAISE FND_API.G_EXC_ERROR;

713:
714: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
715: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
716: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719:
720: --8
721: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_CIC','m4u_230_resp_cic_in','IN',l_tp_hdr_id);

Line 728: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

724: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
725: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
726: END IF;
727:
728: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
729: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
730: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;

Line 731: RAISE FND_API.G_EXC_ERROR;

727:
728: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
729: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
730: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733:
734: --9
735: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_GTIN','m4u_230_resp_gbregqry_in','IN',l_tp_hdr_id);

Line 742: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

738: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
739: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
740: END IF;
741:
742: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
743: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
744: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
745: RAISE FND_API.G_EXC_ERROR;
746: END IF;

Line 745: RAISE FND_API.G_EXC_ERROR;

741:
742: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
743: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
744: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
745: RAISE FND_API.G_EXC_ERROR;
746: END IF;
747:
748: --10
749: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_PARTY','m4u_230_resp_partyqry_in','IN',l_tp_hdr_id);

Line 756: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

752: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
753: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
754: END IF;
755:
756: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
757: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
758: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
759: RAISE FND_API.G_EXC_ERROR;
760: END IF;

Line 759: RAISE FND_API.G_EXC_ERROR;

755:
756: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
757: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
758: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
759: RAISE FND_API.G_EXC_ERROR;
760: END IF;
761:
762: --11
763: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_RFCIN','m4u_230_resp_rfcin_in','IN',l_tp_hdr_id);

Line 770: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

766: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
767: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
768: END IF;
769:
770: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
771: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
772: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;

Line 773: RAISE FND_API.G_EXC_ERROR;

769:
770: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
771: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');
772: l_msg_data := FND_MESSAGE.GET||' : '||l_retmesg;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775:
776: x_retcode := 0;
777: x_errbuf := 'SUCCESS';

Line 785: WHEN FND_API.G_EXC_ERROR THEN

781: cln_debug_pub.Add('==========EXTING SETUP API :NORMALLY===========', 2);
782: END IF;
783:
784: EXCEPTION
785: WHEN FND_API.G_EXC_ERROR THEN
786: x_retcode := 2;
787: x_errbuf := l_msg_data;
788:
789: IF (l_Debug_Level <= 2) THEN