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.BIS_FUNCTIONAL_AREA_PVT dependencies on BIS_FUNCTIONAL_AREA_PVT

Line 1: PACKAGE BODY BIS_FUNCTIONAL_AREA_PVT AS

1: PACKAGE BODY BIS_FUNCTIONAL_AREA_PVT AS
2: /* $Header: BISVFASB.pls 120.0 2005/06/01 16:05:07 appldev noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 19: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_FUNCTIONAL_AREA_PVT';

15: REM | 24-NOV-2004 Aditya Rao Created. |
16: REM +=======================================================================+
17: */
18:
19: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_FUNCTIONAL_AREA_PVT';
20:
21: /*
22: Private CRUD APIs
23: */

Line 151: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';

147: WHEN NO_DATA_FOUND THEN
148: ROLLBACK TO CreateFuncAreaSP_Pvt;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF (x_msg_data IS NOT NULL) THEN
151: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
152: ELSE
153: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
154: END IF;
155: WHEN OTHERS THEN

Line 153: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';

149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF (x_msg_data IS NOT NULL) THEN
151: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
152: ELSE
153: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
154: END IF;
155: WHEN OTHERS THEN
156: ROLLBACK TO CreateFuncAreaSP_Pvt;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 159: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';

155: WHEN OTHERS THEN
156: ROLLBACK TO CreateFuncAreaSP_Pvt;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: IF (x_msg_data IS NOT NULL) THEN
159: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
160: ELSE
161: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
162: END IF;
163: END Create_Functional_Area;

Line 161: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';

157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: IF (x_msg_data IS NOT NULL) THEN
159: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
160: ELSE
161: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
162: END IF;
163: END Create_Functional_Area;
164:
165:

Line 183: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area

179: SAVEPOINT UpdateFuncAreaSP_Pvt;
180: FND_MSG_PUB.Initialize;
181: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
182:
183: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area
184: (
185: p_Func_Area_Rec => p_Func_Area_Rec
186: ,x_Func_Area_Rec => l_Func_Area_Rec
187: ,x_Return_Status => x_Return_Status

Line 234: BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area(

230: WHERE
231: SHORT_NAME = l_Func_Area_Rec.Short_Name;
232:
233: -- Translate the Measures
234: BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area(
235: p_Api_Version => 1.0
236: ,p_Commit => p_Commit
237: ,p_Func_Area_Rec => p_Func_Area_Rec
238: ,x_Return_Status => x_Return_Status

Line 276: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';

272: WHEN NO_DATA_FOUND THEN
273: ROLLBACK TO UpdateFuncAreaSP_Pvt;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: IF (x_msg_data IS NOT NULL) THEN
276: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
277: ELSE
278: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
279: END IF;
280: WHEN OTHERS THEN

Line 278: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';

274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: IF (x_msg_data IS NOT NULL) THEN
276: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
277: ELSE
278: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
279: END IF;
280: WHEN OTHERS THEN
281: ROLLBACK TO UpdateFuncAreaSP_Pvt;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 284: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';

280: WHEN OTHERS THEN
281: ROLLBACK TO UpdateFuncAreaSP_Pvt;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF (x_msg_data IS NOT NULL) THEN
284: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
285: ELSE
286: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
287: END IF;
288:

Line 286: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';

282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF (x_msg_data IS NOT NULL) THEN
284: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
285: ELSE
286: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
287: END IF;
288:
289: END Update_Functional_Area;
290:

Line 308: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area

304: SAVEPOINT TransFuncAreaSP_Pvt;
305: FND_MSG_PUB.Initialize;
306: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
307:
308: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area
309: (
310: p_Func_Area_Rec => p_Func_Area_Rec
311: ,x_Func_Area_Rec => l_Func_Area_Rec
312: ,x_Return_Status => x_Return_Status

Line 398: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';

394: WHEN NO_DATA_FOUND THEN
395: ROLLBACK TO TransFuncAreaSP_Pvt;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF (x_msg_data IS NOT NULL) THEN
398: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
399: ELSE
400: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
401: END IF;
402: WHEN OTHERS THEN

Line 400: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';

396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF (x_msg_data IS NOT NULL) THEN
398: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
399: ELSE
400: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
401: END IF;
402: WHEN OTHERS THEN
403: ROLLBACK TO TransFuncAreaSP_Pvt;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 406: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';

402: WHEN OTHERS THEN
403: ROLLBACK TO TransFuncAreaSP_Pvt;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: IF (x_msg_data IS NOT NULL) THEN
406: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
407: ELSE
408: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
409: END IF;
410: END Translate_Functional_Area;

Line 408: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';

404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: IF (x_msg_data IS NOT NULL) THEN
406: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
407: ELSE
408: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
409: END IF;
410: END Translate_Functional_Area;
411:
412: PROCEDURE Retrieve_Functional_Area(

Line 479: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';

475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: WHEN NO_DATA_FOUND THEN
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF (x_msg_data IS NOT NULL) THEN
479: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
480: ELSE
481: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
482: END IF;
483: WHEN OTHERS THEN

Line 481: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';

477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF (x_msg_data IS NOT NULL) THEN
479: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
480: ELSE
481: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
482: END IF;
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF (x_msg_data IS NOT NULL) THEN

Line 486: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';

482: END IF;
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF (x_msg_data IS NOT NULL) THEN
486: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
487: ELSE
488: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
489: END IF;
490: END Retrieve_Functional_Area;

Line 488: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';

484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF (x_msg_data IS NOT NULL) THEN
486: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
487: ELSE
488: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
489: END IF;
490: END Retrieve_Functional_Area;
491:
492:

Line 556: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';

552: WHEN NO_DATA_FOUND THEN
553: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF (x_msg_data IS NOT NULL) THEN
556: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
557: ELSE
558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
559: END IF;
560: WHEN OTHERS THEN

Line 558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';

554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF (x_msg_data IS NOT NULL) THEN
556: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
557: ELSE
558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
559: END IF;
560: WHEN OTHERS THEN
561: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 564: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';

560: WHEN OTHERS THEN
561: ROLLBACK TO CreateFuncAreaAppDepSP_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_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
565: ELSE
566: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
567: END IF;
568: END Create_Func_Area_Apps_Dep;

Line 566: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';

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_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
565: ELSE
566: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
567: END IF;
568: END Create_Func_Area_Apps_Dep;
569:
570: -- Update Functional Area dependency with Application ID

Line 623: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';

619: WHEN NO_DATA_FOUND THEN
620: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: IF (x_msg_data IS NOT NULL) THEN
623: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
624: ELSE
625: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
626: END IF;
627: WHEN OTHERS THEN

Line 625: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';

621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: IF (x_msg_data IS NOT NULL) THEN
623: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
624: ELSE
625: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
626: END IF;
627: WHEN OTHERS THEN
628: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 631: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';

627: WHEN OTHERS THEN
628: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: IF (x_msg_data IS NOT NULL) THEN
631: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
632: ELSE
633: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
634: END IF;
635:

Line 633: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';

629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: IF (x_msg_data IS NOT NULL) THEN
631: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
632: ELSE
633: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
634: END IF;
635:
636: END Update_Func_Area_Apps_Dep;
637:

Line 663: BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep (

659: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
660: l_Func_Area_Rec := p_Func_Area_Rec;
661:
662: FOR cFAD IN c_FuncArea_Dep LOOP
663: BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep (
664: p_Api_Version => 1.0
665: ,p_Commit => p_Commit
666: ,p_Functional_Area_Id => cFAD.FUNCTIONAL_AREA_ID
667: ,p_Application_Id => cFAD.APPLICATION_ID

Line 714: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';

710: WHEN NO_DATA_FOUND THEN
711: ROLLBACK TO DeleteFuncAreaSP_Pvt;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: IF (x_msg_data IS NOT NULL) THEN
714: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
715: ELSE
716: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
717: END IF;
718: WHEN OTHERS THEN

Line 716: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';

712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: IF (x_msg_data IS NOT NULL) THEN
714: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
715: ELSE
716: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
717: END IF;
718: WHEN OTHERS THEN
719: ROLLBACK TO DeleteFuncAreaSP_Pvt;
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 722: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';

718: WHEN OTHERS THEN
719: ROLLBACK TO DeleteFuncAreaSP_Pvt;
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: IF (x_msg_data IS NOT NULL) THEN
722: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
723: ELSE
724: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
725: END IF;
726: END Delete_Functional_Area;

Line 724: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';

720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: IF (x_msg_data IS NOT NULL) THEN
722: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
723: ELSE
724: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
725: END IF;
726: END Delete_Functional_Area;
727:
728: -- remove Functional Area/Application ID dependency

Line 779: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';

775: WHEN NO_DATA_FOUND THEN
776: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: IF (x_msg_data IS NOT NULL) THEN
779: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
780: ELSE
781: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
782: END IF;
783: WHEN OTHERS THEN

Line 781: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';

777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: IF (x_msg_data IS NOT NULL) THEN
779: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
780: ELSE
781: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
782: END IF;
783: WHEN OTHERS THEN
784: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 787: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';

783: WHEN OTHERS THEN
784: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF (x_msg_data IS NOT NULL) THEN
787: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
788: ELSE
789: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
790: END IF;
791: END Remove_Func_Area_Apps_Dep;

Line 789: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';

785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF (x_msg_data IS NOT NULL) THEN
787: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
788: ELSE
789: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
790: END IF;
791: END Remove_Func_Area_Apps_Dep;
792:
793:

Line 867: END BIS_FUNCTIONAL_AREA_PVT;

863: );
864:
865: END Add_Language;
866:
867: END BIS_FUNCTIONAL_AREA_PVT;