1: PACKAGE BODY BIS_OBJECT_EXTENSIONS_PVT AS
2: /* $Header: BISVEXTB.pls 120.2 2005/12/12 12:35:45 hengliu noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
21: REM | 24-Aug-2005 hengliu bug#4572274: issue in loading seed data |
22: REM +=======================================================================+
23: */
24:
25: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_OBJECT_EXTENSIONS_PVT';
26:
27: /*********************************************************************************************
28: FUNCTION Name :- Create_Form_Func_Extension
29: PARAMETERS :-
149: WHEN NO_DATA_FOUND THEN
150: ROLLBACK TO CreateFormFuncSP_Pvt;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: IF (x_msg_data IS NOT NULL) THEN
153: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
154: ELSE
155: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
156: END IF;
157: WHEN OTHERS THEN
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: IF (x_msg_data IS NOT NULL) THEN
153: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
154: ELSE
155: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
156: END IF;
157: WHEN OTHERS THEN
158: ROLLBACK TO CreateFormFuncSP_Pvt;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: WHEN OTHERS THEN
158: ROLLBACK TO CreateFormFuncSP_Pvt;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: IF (x_msg_data IS NOT NULL) THEN
161: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
162: ELSE
163: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
164: END IF;
165: END Create_Form_Func_Extension;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: IF (x_msg_data IS NOT NULL) THEN
161: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
162: ELSE
163: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Form_Func_Extension ';
164: END IF;
165: END Create_Form_Func_Extension;
166:
167:
193: ELSE
194: l_Commit := p_Commit;
195: END IF;
196:
197: BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension(
198: p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec
199: , x_Form_Func_Extn_Rec => l_Form_Func_Extn_Rec
200: , x_Return_Status => x_Return_Status
201: , x_Msg_Count => x_Msg_Count
239: , LAST_UPDATE_LOGIN = l_Form_Func_Extn_Rec.Last_Update_Login
240: WHERE OBJECT_NAME = l_Form_Func_Extn_Rec.Object_Name;
241:
242:
243: BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension(
244: p_Api_Version => p_Api_Version
245: , p_Commit => p_Commit
246: , p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec
247: , x_Return_Status => x_Return_Status
279: WHEN NO_DATA_FOUND THEN
280: ROLLBACK TO UpdateFormFuncSP;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: IF (x_msg_data IS NOT NULL) THEN
283: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
284: ELSE
285: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
286: END IF;
287: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: IF (x_msg_data IS NOT NULL) THEN
283: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
284: ELSE
285: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
286: END IF;
287: WHEN OTHERS THEN
288: ROLLBACK TO UpdateFormFuncSP;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: WHEN OTHERS THEN
288: ROLLBACK TO UpdateFormFuncSP;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF (x_msg_data IS NOT NULL) THEN
291: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
292: ELSE
293: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
294: END IF;
295: END Update_Form_Func_Extension;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF (x_msg_data IS NOT NULL) THEN
291: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
292: ELSE
293: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Form_Func_Extension ';
294: END IF;
295: END Update_Form_Func_Extension;
296:
297: /*********************************************************************************************
408: WHEN NO_DATA_FOUND THEN
409: ROLLBACK TO TransalteFormFuncSP;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF (x_msg_data IS NOT NULL) THEN
412: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
413: ELSE
414: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
415: END IF;
416: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF (x_msg_data IS NOT NULL) THEN
412: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
413: ELSE
414: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
415: END IF;
416: WHEN OTHERS THEN
417: ROLLBACK TO TransalteFormFuncSP;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: WHEN OTHERS THEN
417: ROLLBACK TO TransalteFormFuncSP;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: IF (x_msg_data IS NOT NULL) THEN
420: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
421: ELSE
422: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
423: END IF;
424: END Translate_Form_Func_Extension;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: IF (x_msg_data IS NOT NULL) THEN
420: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
421: ELSE
422: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Form_Func_Extension ';
423: END IF;
424: END Translate_Form_Func_Extension;
425:
426:
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: WHEN NO_DATA_FOUND THEN
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF (x_msg_data IS NOT NULL) THEN
496: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
497: ELSE
498: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
499: END IF;
500: WHEN OTHERS THEN
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: IF (x_msg_data IS NOT NULL) THEN
496: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
497: ELSE
498: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
499: END IF;
500: WHEN OTHERS THEN
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF (x_msg_data IS NOT NULL) THEN
499: END IF;
500: WHEN OTHERS THEN
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF (x_msg_data IS NOT NULL) THEN
503: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
504: ELSE
505: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
506: END IF;
507: END Retrieve_Form_Func_Extension;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF (x_msg_data IS NOT NULL) THEN
503: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
504: ELSE
505: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension ';
506: END IF;
507: END Retrieve_Form_Func_Extension;
508:
509: /*********************************************************************************************
560: WHEN NO_DATA_FOUND THEN
561: ROLLBACK TO DeleteFormFuncSP_Pvt;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF (x_msg_data IS NOT NULL) THEN
564: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
565: ELSE
566: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
567: END IF;
568: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF (x_msg_data IS NOT NULL) THEN
564: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
565: ELSE
566: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
567: END IF;
568: WHEN OTHERS THEN
569: ROLLBACK TO DeleteFormFuncSP_Pvt;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: WHEN OTHERS THEN
569: ROLLBACK TO DeleteFormFuncSP_Pvt;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: IF (x_msg_data IS NOT NULL) THEN
572: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
573: ELSE
574: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
575: END IF;
576: END Delete_Form_Func_Extension;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: IF (x_msg_data IS NOT NULL) THEN
572: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
573: ELSE
574: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Form_Func_Extension ';
575: END IF;
576: END Delete_Form_Func_Extension;
577:
578:
693: WHEN NO_DATA_FOUND THEN
694: ROLLBACK TO CreateMeasExtnSP;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: IF (x_msg_data IS NOT NULL) THEN
697: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
698: ELSE
699: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
700: END IF;
701: WHEN OTHERS THEN
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: IF (x_msg_data IS NOT NULL) THEN
697: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
698: ELSE
699: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
700: END IF;
701: WHEN OTHERS THEN
702: ROLLBACK TO CreateMeasExtnSP;
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: WHEN OTHERS THEN
702: ROLLBACK TO CreateMeasExtnSP;
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF (x_msg_data IS NOT NULL) THEN
705: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
706: ELSE
707: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
708: END IF;
709:
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF (x_msg_data IS NOT NULL) THEN
705: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
706: ELSE
707: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Create_Measure_Extension ';
708: END IF;
709:
710: END Create_Measure_Extension;
711:
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: WHEN NO_DATA_FOUND THEN
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: IF (x_msg_data IS NOT NULL) THEN
781: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
782: ELSE
783: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
784: END IF;
785: WHEN OTHERS THEN
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: IF (x_msg_data IS NOT NULL) THEN
781: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
782: ELSE
783: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
784: END IF;
785: WHEN OTHERS THEN
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: IF (x_msg_data IS NOT NULL) THEN
784: END IF;
785: WHEN OTHERS THEN
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: IF (x_msg_data IS NOT NULL) THEN
788: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
789: ELSE
790: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
791: END IF;
792: END Retrieve_Measure_Extension;
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: IF (x_msg_data IS NOT NULL) THEN
788: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
789: ELSE
790: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension ';
791: END IF;
792: END Retrieve_Measure_Extension;
793:
794: PROCEDURE Translate_Measure_Extension(
809:
810: ------dbms_output.put_line ('l_Meas_Extn_Rec.Measure_Short_Name - ' || l_Meas_Extn_Rec.Measure_Short_Name);
811:
812:
813: BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension(
814: p_Meas_Extn_Rec => p_Meas_Extn_Rec
815: ,x_Meas_Extn_Rec => l_Meas_Extn_Rec
816: ,x_Return_Status => x_Return_Status
817: ,x_Msg_Count => x_Msg_Count
899: WHEN NO_DATA_FOUND THEN
900: ROLLBACK TO TranslateMeasExtnSP;
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: IF (x_msg_data IS NOT NULL) THEN
903: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
904: ELSE
905: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
906: END IF;
907: WHEN OTHERS THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: IF (x_msg_data IS NOT NULL) THEN
903: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
904: ELSE
905: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
906: END IF;
907: WHEN OTHERS THEN
908: ROLLBACK TO TranslateMeasExtnSP;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: WHEN OTHERS THEN
908: ROLLBACK TO TranslateMeasExtnSP;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: IF (x_msg_data IS NOT NULL) THEN
911: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
912: ELSE
913: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
914: END IF;
915:
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: IF (x_msg_data IS NOT NULL) THEN
911: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
912: ELSE
913: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension ';
914: END IF;
915:
916: END Translate_Measure_Extension;
917:
934:
935: -- Since there is no base table, a direct transalation
936: -- should suffice.
937:
938: BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension(
939: p_Meas_Extn_Rec => p_Meas_Extn_Rec
940: ,x_Meas_Extn_Rec => l_Meas_Extn_Rec
941: ,x_Return_Status => x_Return_Status
942: ,x_Msg_Count => x_Msg_Count
978: , LAST_UPDATE_LOGIN = l_Meas_Extn_Rec.Last_Update_Login
979: WHERE
980: MEASURE_SHORT_NAME = l_Meas_Extn_Rec.Measure_Short_Name;
981:
982: BIS_OBJECT_EXTENSIONS_PVT.Translate_Measure_Extension(
983: p_Api_Version => p_Api_Version
984: ,p_Commit => p_Commit
985: ,p_Meas_Extn_Rec => p_Meas_Extn_Rec
986: ,x_Return_Status => x_Return_Status
1019: WHEN NO_DATA_FOUND THEN
1020: ROLLBACK TO UpdateMeasExtnSP;
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1022: IF (x_msg_data IS NOT NULL) THEN
1023: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1024: ELSE
1025: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1026: END IF;
1027: WHEN OTHERS THEN
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1022: IF (x_msg_data IS NOT NULL) THEN
1023: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1024: ELSE
1025: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1026: END IF;
1027: WHEN OTHERS THEN
1028: ROLLBACK TO UpdateMeasExtnSP;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: WHEN OTHERS THEN
1028: ROLLBACK TO UpdateMeasExtnSP;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030: IF (x_msg_data IS NOT NULL) THEN
1031: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1032: ELSE
1033: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1034: END IF;
1035: END Update_Measure_Extension;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030: IF (x_msg_data IS NOT NULL) THEN
1031: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1032: ELSE
1033: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Update_Measure_Extension ';
1034: END IF;
1035: END Update_Measure_Extension;
1036: /*********************************************************************************************
1037: FUNCTION Name :- Retrieve_Form_Func_Extension
1090: WHEN NO_DATA_FOUND THEN
1091: ROLLBACK TO DeleteMeasExtnSP;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF (x_msg_data IS NOT NULL) THEN
1094: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1095: ELSE
1096: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1097: END IF;
1098: WHEN OTHERS THEN
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF (x_msg_data IS NOT NULL) THEN
1094: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1095: ELSE
1096: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1097: END IF;
1098: WHEN OTHERS THEN
1099: ROLLBACK TO DeleteMeasExtnSP;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: WHEN OTHERS THEN
1099: ROLLBACK TO DeleteMeasExtnSP;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: IF (x_msg_data IS NOT NULL) THEN
1102: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1103: ELSE
1104: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1105: END IF;
1106:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: IF (x_msg_data IS NOT NULL) THEN
1102: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1103: ELSE
1104: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PVT.Delete_Measure_Extension ';
1105: END IF;
1106:
1107: END Delete_Measure_Extension;
1108:
1276: NULL;
1277: END;
1278: END Add_Language;
1279:
1280: END BIS_OBJECT_EXTENSIONS_PVT;