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.ITG_SETUP dependencies on FND_API

Line 78: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

74: IF (l_Debug_Level <= 5) THEN
75: itg_debug_pub.Add('setup_hr_loc_data - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
76: END IF;
77:
78: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
79: x_retcode := 2;
80: x_errbuf := 'ITG Setup failed (step 1) : ' || l_retmesg;
81: RETURN;
82: END IF;

Line 91: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

87: itg_debug_pub.Add('setup_ecx_tp_header - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
88: itg_debug_pub.Add('setup_ecx_tp_header returns - tp_header_id - ' || l_tp_hdr_id, 5);
89: END IF;
90:
91: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
92: x_retcode := 2;
93: x_errbuf := 'ITG Setup failed (step 2): ' || l_retmesg;
94: RETURN;
95: END IF;

Line 103: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

99: IF (l_Debug_Level <= 5) THEN
100: itg_debug_pub.Add('setup_tp_details - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
101: END IF;
102:
103: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
104: x_retcode := 2;
105: x_errbuf := 'ITG Setup failed (step 3): ' || l_retmesg;
106: RETURN;
107: END IF;

Line 115: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

111: IF (l_Debug_Level <= 5) THEN
112: itg_debug_pub.Add('trigger_control(true) - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
113: END IF;
114:
115: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
116: x_retcode := 2;
117: x_errbuf := 'ITG Setup failed (step 4): ' || l_retmesg;
118: RETURN;
119: END IF;

Line 205: x_retcode := FND_API.G_RET_STS_ERROR;

201: OR p_addr_line_1 IS NULL
202: OR p_country IS NULL
203: OR p_style IS NULL) THEN
204:
205: x_retcode := FND_API.G_RET_STS_ERROR;
206: -- Not using a translated message her, since this condition will never occur
207: -- the Concurrent Request submit form itself will validate that input parameters
208: -- are entered by the user.
209: x_errbuf := 'Missing mandatory parameter for itg_setup.setup_hr_loc';

Line 288: x_retcode := FND_API.G_RET_STS_SUCCESS;

284: itg_debug_pub.Add('HR_LOCATION_API.update_location returns normal' ,1);
285: END IF;
286: END IF;
287:
288: x_retcode := FND_API.G_RET_STS_SUCCESS;
289: x_errbuf := 'Successful';
290:
291: IF (l_Debug_Level <= 2 ) THEN
292: itg_debug_pub.Add('EXITING itg_setup.setup_hr_loc returns normal' ,2);

Line 298: x_retcode := FND_API.G_RET_STS_ERROR;

294:
295: -- Exception Handling
296: EXCEPTION
297: WHEN OTHERS THEN
298: x_retcode := FND_API.G_RET_STS_ERROR;
299: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
300:
301: IF (l_Debug_Level <= 6 ) THEN
302: itg_debug_pub.Add(x_errbuf,6);

Line 367: x_retcode := FND_API.G_RET_STS_SUCCESS;

363: END IF;
364: END;
365: END LOOP;
366:
367: x_retcode := FND_API.G_RET_STS_SUCCESS;
368: x_errbuf := 'Successful';
369:
370: IF (l_Debug_Level <= 2 ) THEN
371: itg_debug_pub.Add('EXITING itg_setup.trigger_control(true) returns normal' ,2);

Line 375: x_retcode := FND_API.G_RET_STS_ERROR;

371: itg_debug_pub.Add('EXITING itg_setup.trigger_control(true) returns normal' ,2);
372: END IF;
373: EXCEPTION
374: WHEN OTHERS THEN
375: x_retcode := FND_API.G_RET_STS_ERROR;
376: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
377:
378: IF (l_Debug_Level <= 6 ) THEN
379: itg_debug_pub.Add(x_errbuf ,6);

Line 508: x_retcode := FND_API.G_RET_STS_ERROR;

504: END IF;
505:
506: IF l_retcode <> 0 THEN
507: x_tp_hdr_id := NULL;
508: x_retcode := FND_API.G_RET_STS_ERROR;
509: x_errbuf := l_retmesg;
510: ELSE
511: x_retcode := FND_API.G_RET_STS_SUCCESS;
512: x_errbuf := 'Successful';

Line 511: x_retcode := FND_API.G_RET_STS_SUCCESS;

507: x_tp_hdr_id := NULL;
508: x_retcode := FND_API.G_RET_STS_ERROR;
509: x_errbuf := l_retmesg;
510: ELSE
511: x_retcode := FND_API.G_RET_STS_SUCCESS;
512: x_errbuf := 'Successful';
513: x_tp_hdr_id := l_tp_hdr_id;
514: END IF;
515:

Line 526: x_retcode := FND_API.G_RET_STS_ERROR;

522: END IF;
523: -- Exception Handling
524: EXCEPTION
525: WHEN OTHERS THEN
526: x_retcode := FND_API.G_RET_STS_ERROR;
527: x_tp_hdr_id := NULL;
528: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
529:
530: IF (l_Debug_Level <= 6 )THEN

Line 563: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

559: IF (l_Debug_Level <= 1 )THEN
560: itg_debug_pub.Add('SYNC_PO_RELEASE - ' || l_retcode || l_retmesg, 1);
561: END IF;
562:
563: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
564: x_retcode := FND_API.G_RET_STS_ERROR;
565: x_errbuf := l_retmesg;
566: RETURN;
567: END IF;

Line 564: x_retcode := FND_API.G_RET_STS_ERROR;

560: itg_debug_pub.Add('SYNC_PO_RELEASE - ' || l_retcode || l_retmesg, 1);
561: END IF;
562:
563: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
564: x_retcode := FND_API.G_RET_STS_ERROR;
565: x_errbuf := l_retmesg;
566: RETURN;
567: END IF;
568:

Line 577: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

573: IF (l_Debug_Level <= 1 )THEN
574: itg_debug_pub.Add('CANCEL_PO_RELEASE - ' || l_retcode || l_retmesg, 1);
575: END IF;
576:
577: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
578: x_retcode := FND_API.G_RET_STS_ERROR;
579: x_errbuf := l_retmesg;
580: RETURN;
581: END IF;

Line 578: x_retcode := FND_API.G_RET_STS_ERROR;

574: itg_debug_pub.Add('CANCEL_PO_RELEASE - ' || l_retcode || l_retmesg, 1);
575: END IF;
576:
577: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
578: x_retcode := FND_API.G_RET_STS_ERROR;
579: x_errbuf := l_retmesg;
580: RETURN;
581: END IF;
582:

Line 591: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

587: IF (l_Debug_Level <= 1 )THEN
588: itg_debug_pub.Add('CANCEL_PO - ' || l_retcode || l_retmesg ,1);
589: END IF;
590:
591: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
592: x_retcode := FND_API.G_RET_STS_ERROR;
593: x_errbuf := l_retmesg;
594: RETURN;
595: END IF;

Line 592: x_retcode := FND_API.G_RET_STS_ERROR;

588: itg_debug_pub.Add('CANCEL_PO - ' || l_retcode || l_retmesg ,1);
589: END IF;
590:
591: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
592: x_retcode := FND_API.G_RET_STS_ERROR;
593: x_errbuf := l_retmesg;
594: RETURN;
595: END IF;
596:

Line 605: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

601: IF (l_Debug_Level <= 1 )THEN
602: itg_debug_pub.Add('ADD_REQUISITN - ' || l_retcode || l_retmesg, 1);
603: END IF;
604:
605: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
606: x_retcode := FND_API.G_RET_STS_ERROR;
607: x_errbuf := l_retmesg;
608: RETURN;
609: END IF;

Line 606: x_retcode := FND_API.G_RET_STS_ERROR;

602: itg_debug_pub.Add('ADD_REQUISITN - ' || l_retcode || l_retmesg, 1);
603: END IF;
604:
605: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
606: x_retcode := FND_API.G_RET_STS_ERROR;
607: x_errbuf := l_retmesg;
608: RETURN;
609: END IF;
610:

Line 619: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

615: IF (l_Debug_Level <= 1 )THEN
616: itg_debug_pub.Add('CHANGE_REQUISITN - ' || l_retcode || l_retmesg, 1);
617: END IF;
618:
619: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
620: x_retcode := FND_API.G_RET_STS_ERROR;
621: x_errbuf := l_retmesg;
622: RETURN;
623: END IF;

Line 620: x_retcode := FND_API.G_RET_STS_ERROR;

616: itg_debug_pub.Add('CHANGE_REQUISITN - ' || l_retcode || l_retmesg, 1);
617: END IF;
618:
619: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
620: x_retcode := FND_API.G_RET_STS_ERROR;
621: x_errbuf := l_retmesg;
622: RETURN;
623: END IF;
624:

Line 633: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

629: IF (l_Debug_Level <= 1 )THEN
630: itg_debug_pub.Add('CANCEL_REQUISITN - ' || l_retcode || l_retmesg, 1);
631: END IF;
632:
633: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
634: x_retcode := FND_API.G_RET_STS_ERROR;
635: x_errbuf := l_retmesg;
636: RETURN;
637: END IF;

Line 634: x_retcode := FND_API.G_RET_STS_ERROR;

630: itg_debug_pub.Add('CANCEL_REQUISITN - ' || l_retcode || l_retmesg, 1);
631: END IF;
632:
633: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
634: x_retcode := FND_API.G_RET_STS_ERROR;
635: x_errbuf := l_retmesg;
636: RETURN;
637: END IF;
638:

Line 647: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

643: IF (l_Debug_Level <= 1 )THEN
644: itg_debug_pub.Add('SYNC_PO - ' || l_retcode || l_retmesg , 1);
645: END IF;
646:
647: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
648: x_retcode := FND_API.G_RET_STS_ERROR;
649: x_errbuf := l_retmesg;
650: RETURN;
651: END IF;

Line 648: x_retcode := FND_API.G_RET_STS_ERROR;

644: itg_debug_pub.Add('SYNC_PO - ' || l_retcode || l_retmesg , 1);
645: END IF;
646:
647: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
648: x_retcode := FND_API.G_RET_STS_ERROR;
649: x_errbuf := l_retmesg;
650: RETURN;
651: END IF;
652:

Line 661: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

657: IF (l_Debug_Level <= 1 )THEN
658: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);
659: END IF;
660:
661: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
662: x_retcode := FND_API.G_RET_STS_ERROR;
663: x_errbuf := l_retmesg;
664: RETURN;
665: END IF;

Line 662: x_retcode := FND_API.G_RET_STS_ERROR;

658: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);
659: END IF;
660:
661: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
662: x_retcode := FND_API.G_RET_STS_ERROR;
663: x_errbuf := l_retmesg;
664: RETURN;
665: END IF;
666:

Line 676: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

672: IF (l_Debug_Level <= 1 )THEN
673: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);
674: END IF;
675:
676: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
677: x_retcode := FND_API.G_RET_STS_ERROR;
678: x_errbuf := l_retmesg;
679: RETURN;
680: END IF;

Line 677: x_retcode := FND_API.G_RET_STS_ERROR;

673: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);
674: END IF;
675:
676: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
677: x_retcode := FND_API.G_RET_STS_ERROR;
678: x_errbuf := l_retmesg;
679: RETURN;
680: END IF;
681:

Line 690: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

686: IF (l_Debug_Level <= 1 )THEN
687: itg_debug_pub.Add('CBODO - ' || l_retcode || l_retmesg , 1);
688: END IF;
689:
690: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
691: x_retcode := FND_API.G_RET_STS_ERROR;
692: x_errbuf := l_retmesg;
693: RETURN;
694: END IF;

Line 691: x_retcode := FND_API.G_RET_STS_ERROR;

687: itg_debug_pub.Add('CBODO - ' || l_retcode || l_retmesg , 1);
688: END IF;
689:
690: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
691: x_retcode := FND_API.G_RET_STS_ERROR;
692: x_errbuf := l_retmesg;
693: RETURN;
694: END IF;
695:

Line 704: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

700: IF (l_Debug_Level <= 1 )THEN
701: itg_debug_pub.Add('SYNC_FIELD_004 IN- ' || l_retcode || l_retmesg, 1);
702: END IF;
703:
704: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
705: x_retcode := FND_API.G_RET_STS_ERROR;
706: x_errbuf := l_retmesg;
707: RETURN;
708: END IF;

Line 705: x_retcode := FND_API.G_RET_STS_ERROR;

701: itg_debug_pub.Add('SYNC_FIELD_004 IN- ' || l_retcode || l_retmesg, 1);
702: END IF;
703:
704: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
705: x_retcode := FND_API.G_RET_STS_ERROR;
706: x_errbuf := l_retmesg;
707: RETURN;
708: END IF;
709:

Line 719: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

715: IF (l_Debug_Level <= 1 )THEN
716: itg_debug_pub.Add('SYNC_UOMGROUP_003 IN- ' || l_retcode || l_retmesg, 1);
717: END IF;
718:
719: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
720: x_retcode := FND_API.G_RET_STS_ERROR;
721: x_errbuf := l_retmesg;
722: RETURN;
723: END IF;

Line 720: x_retcode := FND_API.G_RET_STS_ERROR;

716: itg_debug_pub.Add('SYNC_UOMGROUP_003 IN- ' || l_retcode || l_retmesg, 1);
717: END IF;
718:
719: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
720: x_retcode := FND_API.G_RET_STS_ERROR;
721: x_errbuf := l_retmesg;
722: RETURN;
723: END IF;
724:

Line 733: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

729: IF (l_Debug_Level <= 1 )THEN
730: itg_debug_pub.Add('SYNC_SUPPLIER_005 IN- ' || l_retcode || l_retmesg ,1);
731: END IF;
732:
733: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
734: x_retcode := FND_API.G_RET_STS_ERROR;
735: x_errbuf := l_retmesg;
736: RETURN;
737: END IF;

Line 734: x_retcode := FND_API.G_RET_STS_ERROR;

730: itg_debug_pub.Add('SYNC_SUPPLIER_005 IN- ' || l_retcode || l_retmesg ,1);
731: END IF;
732:
733: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
734: x_retcode := FND_API.G_RET_STS_ERROR;
735: x_errbuf := l_retmesg;
736: RETURN;
737: END IF;
738:

Line 747: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

743: IF (l_Debug_Level <= 1 )THEN
744: itg_debug_pub.Add('SSYNC_EXCHNGRATE_003 IN- ' || l_retcode || l_retmesg, 1);
745: END IF;
746:
747: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
748: x_retcode := FND_API.G_RET_STS_ERROR;
749: x_errbuf := l_retmesg;
750: RETURN;
751: END IF;

Line 748: x_retcode := FND_API.G_RET_STS_ERROR;

744: itg_debug_pub.Add('SSYNC_EXCHNGRATE_003 IN- ' || l_retcode || l_retmesg, 1);
745: END IF;
746:
747: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
748: x_retcode := FND_API.G_RET_STS_ERROR;
749: x_errbuf := l_retmesg;
750: RETURN;
751: END IF;
752:

Line 761: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

757: IF (l_Debug_Level <= 1 )THEN
758: itg_debug_pub.Add('SYNC_ITEM_006 IN- ' || l_retcode || l_retmesg, 1);
759: END IF;
760:
761: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
762: x_retcode := FND_API.G_RET_STS_ERROR;
763: x_errbuf := l_retmesg;
764: RETURN;
765: END IF;

Line 762: x_retcode := FND_API.G_RET_STS_ERROR;

758: itg_debug_pub.Add('SYNC_ITEM_006 IN- ' || l_retcode || l_retmesg, 1);
759: END IF;
760:
761: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
762: x_retcode := FND_API.G_RET_STS_ERROR;
763: x_errbuf := l_retmesg;
764: RETURN;
765: END IF;
766:

Line 775: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

771: IF (l_Debug_Level <= 1 )THEN
772: itg_debug_pub.Add('SYNC_COA_003 IN- ' || l_retcode || l_retmesg ,1);
773: END IF;
774:
775: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
776: x_retcode := FND_API.G_RET_STS_ERROR;
777: x_errbuf := l_retmesg;
778: RETURN;
779: END IF;

Line 776: x_retcode := FND_API.G_RET_STS_ERROR;

772: itg_debug_pub.Add('SYNC_COA_003 IN- ' || l_retcode || l_retmesg ,1);
773: END IF;
774:
775: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
776: x_retcode := FND_API.G_RET_STS_ERROR;
777: x_errbuf := l_retmesg;
778: RETURN;
779: END IF;
780:

Line 790: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

786: IF (l_Debug_Level <= 1 )THEN
787: itg_debug_pub.Add('SYNC_PO IN- ' || l_retcode || l_retmesg, 1);
788: END IF;
789:
790: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
791: x_retcode := FND_API.G_RET_STS_ERROR;
792: x_errbuf := l_retmesg;
793: RETURN;
794: END IF;

Line 791: x_retcode := FND_API.G_RET_STS_ERROR;

787: itg_debug_pub.Add('SYNC_PO IN- ' || l_retcode || l_retmesg, 1);
788: END IF;
789:
790: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
791: x_retcode := FND_API.G_RET_STS_ERROR;
792: x_errbuf := l_retmesg;
793: RETURN;
794: END IF;
795:

Line 804: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

800: IF (l_Debug_Level <= 1 )THEN
801: itg_debug_pub.Add('NBOD IN- ' || l_retcode || l_retmesg, 1);
802: END IF;
803:
804: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
805: x_retcode := FND_API.G_RET_STS_ERROR;
806: x_errbuf := l_retmesg;
807: RETURN;
808: END IF;

Line 805: x_retcode := FND_API.G_RET_STS_ERROR;

801: itg_debug_pub.Add('NBOD IN- ' || l_retcode || l_retmesg, 1);
802: END IF;
803:
804: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
805: x_retcode := FND_API.G_RET_STS_ERROR;
806: x_errbuf := l_retmesg;
807: RETURN;
808: END IF;
809:

Line 810: x_retcode := FND_API.G_RET_STS_SUCCESS;

806: x_errbuf := l_retmesg;
807: RETURN;
808: END IF;
809:
810: x_retcode := FND_API.G_RET_STS_SUCCESS;
811: x_errbuf := 'Successful';
812:
813:
814: IF (l_Debug_Level <= 2 )THEN

Line 819: x_retcode := FND_API.G_RET_STS_ERROR;

815: itg_debug_pub.Add(' EXITING itg_setup.setup_tp_details normal', 2);
816: END IF;
817: EXCEPTION
818: WHEN OTHERS THEN
819: x_retcode := FND_API.G_RET_STS_ERROR;
820: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
821:
822: IF (l_Debug_Level <= 6 )THEN
823: itg_debug_pub.Add(x_errbuf, 6);

Line 992: x_retcode := FND_API.G_RET_STS_ERROR;

988: itg_debug_pub.Add('Cannot retrieve ext_process_id', 6);
989: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);
990: END IF;
991:
992: x_retcode := FND_API.G_RET_STS_ERROR;
993: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
994: RETURN;
995: END;
996:

Line 1014: x_retcode := FND_API.G_RET_STS_ERROR;

1010: AND tpd.source_tp_location_code = p_src_loc
1011: AND tpd.tp_header_id <> p_tp_hdr_id;
1012:
1013: IF l_count > 0 THEN
1014: x_retcode := FND_API.G_RET_STS_ERROR;
1015: x_errbuf := 'Found ECX TP Detail record for (' || p_std_code
1016: || ',' || p_ext_type || ',' || p_ext_subtype
1017: || ',' || p_direction || ',' || ' source location '|| p_src_loc
1018: || '), please delete this record and resubmit the Setup program.';

Line 1032: x_retcode := FND_API.G_RET_STS_ERROR;

1028: itg_debug_pub.Add('Unexpected error', 6);
1029: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);
1030: END IF;
1031:
1032: x_retcode := FND_API.G_RET_STS_ERROR;
1033: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
1034: RETURN;
1035: END;
1036:

Line 1096: x_retcode := FND_API.G_RET_STS_SUCCESS;

1092: END IF;
1093: END IF;
1094:
1095: IF l_retcode = 0 THEN
1096: x_retcode := FND_API.G_RET_STS_SUCCESS;
1097: x_errbuf := 'Successful';
1098: ELSE
1099: x_retcode := FND_API.G_RET_STS_ERROR;
1100: x_errbuf := l_retmesg;

Line 1099: x_retcode := FND_API.G_RET_STS_ERROR;

1095: IF l_retcode = 0 THEN
1096: x_retcode := FND_API.G_RET_STS_SUCCESS;
1097: x_errbuf := 'Successful';
1098: ELSE
1099: x_retcode := FND_API.G_RET_STS_ERROR;
1100: x_errbuf := l_retmesg;
1101: END IF;
1102:
1103: IF (l_Debug_Level <= 2) THEN

Line 1109: x_retcode := FND_API.G_RET_STS_ERROR;

1105: END IF;
1106: -- Exception Handling
1107: EXCEPTION
1108: WHEN OTHERS THEN
1109: x_retcode := FND_API.G_RET_STS_ERROR;
1110: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
1111:
1112: IF (l_Debug_Level <= 6) THEN
1113: itg_debug_pub.Add(x_errbuf, 6);