DBA Data[Home] [Help]

APPS.BIS_INDICATOR_REGION_PVT dependencies on FND_API

Line 20: x_return_status := FND_API.G_RET_STS_SUCCESS;

16: select rowid from BIS_USER_IND_SELECTIONS
17: where IND_SELECTION_ID = l_user_ind_id;
18:
19: BEGIN
20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21:
22: select BIS_USER_IND_SELECTIONS_S.NEXTVAL into l_user_ind_id from dual;
23: -- mdamle 01/15/2001 - Remove Org and add Dim6 and Dim7
24: insert into BIS_USER_IND_SELECTIONS (

Line 54: ,DECODE(p_Indicator_Region_Rec.RESPONSIBILITY_ID,FND_API.G_MISS_NUM,NULL,

50: -- ,NULL
51: -- ,p_Indicator_Region_Rec.Org_Level_Value_Id
52: ,p_Indicator_Region_Rec.LABEL
53: ,p_Indicator_Region_Rec.PLUG_ID
54: ,DECODE(p_Indicator_Region_Rec.RESPONSIBILITY_ID,FND_API.G_MISS_NUM,NULL,
55: p_Indicator_Region_Rec.RESPONSIBILITY_ID)
56: ,DECODE(p_Indicator_Region_Rec.DIM1_LEVEL_VALUE_ID,'+',NULL,'-',NULL,
57: p_Indicator_Region_Rec.DIM1_LEVEL_VALUE_ID)
58: ,DECODE(p_Indicator_Region_Rec.DIM2_LEVEL_VALUE_ID,'+',NULL,'-',NULL,

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

85: COMMIT;
86:
87: EXCEPTION
88: WHEN NO_DATA_FOUND THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: WHEN OTHERS THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: l_error_Tbl := x_error_Tbl;
93: BIS_UTILITIES_PVT.Add_Error_Message

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

87: EXCEPTION
88: WHEN NO_DATA_FOUND THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: WHEN OTHERS THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: l_error_Tbl := x_error_Tbl;
93: BIS_UTILITIES_PVT.Add_Error_Message
94: ( p_error_table => l_error_Tbl
95: , p_error_msg_id => SQLCODE

Line 104: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

100: --and user was not able to continue
101: --htp.p('BIS_INDICATOR_REGION_PVT.Create_User_Ind_Selection: '
102: -- ||SQLERRM);
103: -- htp.para;
104: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105:
106: END Create_User_Ind_Selection;
107:
108: -- *************************************************

Line 114: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,

110: p_api_version IN NUMBER,
111: p_user_id IN NUMBER ,
112: p_user_name IN VARCHAR2 ,
113: p_plug_id IN NUMBER ,
114: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
115: x_Indicator_Region_Tbl
116: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 172: x_return_status := FND_API.G_RET_STS_SUCCESS;

168:
169:
170: BEGIN
171:
172: x_return_status := FND_API.G_RET_STS_SUCCESS;
173:
174: FOR c_userIndSelection in c_user_ind_selection LOOP
175:
176: l_Indicator_Region_Rec.ind_selection_id

Line 211: IF p_all_info = FND_API.G_TRUE THEN

207: := l_Indicator_Region_Rec;
208:
209: END LOOP;
210:
211: IF p_all_info = FND_API.G_TRUE THEN
212:
213: FOR i in 1..x_Indicator_Region_tbl.count LOOP
214:
215: l_target_level_Rec.Target_level_ID :=

Line 232: p_all_info => FND_API.G_FALSE,

228: l_Target_level_rec_p := l_Target_level_rec;
229: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level (
230: p_api_version => 1.0,
231: p_Target_level_rec => l_Target_level_rec_p,
232: p_all_info => FND_API.G_FALSE,
233: x_Target_level_rec => l_Target_level_rec,
234: x_return_status => x_return_status,
235: x_error_Tbl => x_error_Tbl
236: );

Line 417: WHEN FND_API.G_EXC_ERROR THEN

413: END LOOP;
414: END IF;
415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: x_return_status:= FND_API.G_RET_STS_ERROR;
419: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:'); htp.para;
420: RAISE;
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 418: x_return_status:= FND_API.G_RET_STS_ERROR;

414: END IF;
415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: x_return_status:= FND_API.G_RET_STS_ERROR;
419: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:'); htp.para;
420: RAISE;
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: WHEN FND_API.G_EXC_ERROR THEN
418: x_return_status:= FND_API.G_RET_STS_ERROR;
419: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:'); htp.para;
420: RAISE;
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
423: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:G_EXC_UNEXPECTED_ERROR'); htp.para;
424: RAISE;
425: WHEN OTHERS THEN

Line 422: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

418: x_return_status:= FND_API.G_RET_STS_ERROR;
419: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:'); htp.para;
420: RAISE;
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
423: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:G_EXC_UNEXPECTED_ERROR'); htp.para;
424: RAISE;
425: WHEN OTHERS THEN
426: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 426: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

422: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
423: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:G_EXC_UNEXPECTED_ERROR'); htp.para;
424: RAISE;
425: WHEN OTHERS THEN
426: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
427: l_error_Tbl := x_error_Tbl;
428: BIS_UTILITIES_PVT.Add_Error_Message
429: ( p_error_table => l_error_Tbl
430: , p_error_msg_id => SQLCODE

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: , p_error_description => SQLERRM
432: , x_error_table => x_error_Tbl
433: );
434: htp.p('BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections:OTHERS'); htp.para;
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: --
437:
438: END Retrieve_User_Ind_Selections;
439:

Line 443: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE

439:
440: -- $$
441: Procedure Retrieve_User_Ind_Selections(
442: p_api_version IN NUMBER
443: , p_all_info IN VARCHAR2 Default FND_API.G_TRUE
444: , p_Target_level_id IN NUMBER
445: , x_Indicator_Region_Tbl
446: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type
447: , x_return_status OUT NOCOPY VARCHAR2

Line 475: x_return_status := FND_API.G_RET_STS_SUCCESS;

471: where Target_Level_ID = p_target_level_id;
472:
473: BEGIN
474:
475: x_return_status := FND_API.G_RET_STS_SUCCESS;
476:
477: FOR c_userIndSelection in c_user_ind_selection LOOP
478:
479: l_Indicator_Region_Rec.ind_selection_id

Line 511: IF p_all_info = FND_API.G_TRUE THEN

507: := l_Indicator_Region_Rec;
508:
509: END LOOP;
510:
511: IF p_all_info = FND_API.G_TRUE THEN
512:
513: FOR i in 1..x_Indicator_Region_tbl.count LOOP
514:
515: l_target_level_Rec.Target_level_ID :=

Line 532: p_all_info => FND_API.G_FALSE,

528: l_Target_level_rec_p := l_Target_level_rec;
529: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level (
530: p_api_version => 1.0,
531: p_Target_level_rec => l_Target_level_rec_p,
532: p_all_info => FND_API.G_FALSE,
533: x_Target_level_rec => l_Target_level_rec,
534: x_return_status => x_return_status,
535: x_error_Tbl => x_error_Tbl
536: );

Line 708: WHEN FND_API.G_EXC_ERROR THEN

704: END LOOP;
705: END IF;
706:
707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: RAISE;
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 709: x_return_status:= FND_API.G_RET_STS_ERROR;

705: END IF;
706:
707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: RAISE;
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
713: RAISE;

Line 711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: RAISE;
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
713: RAISE;
714: WHEN OTHERS THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 712: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status:= FND_API.G_RET_STS_ERROR;
710: RAISE;
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
713: RAISE;
714: WHEN OTHERS THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
716: l_error_Tbl := x_error_Tbl;

Line 715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
713: RAISE;
714: WHEN OTHERS THEN
715: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
716: l_error_Tbl := x_error_Tbl;
717: BIS_UTILITIES_PVT.Add_Error_Message
718: ( p_error_table => l_error_Tbl
719: , p_error_msg_id => SQLCODE

Line 723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

719: , p_error_msg_id => SQLCODE
720: , p_error_description => SQLERRM
721: , x_error_table => x_error_Tbl
722: );
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724:
725: END Retrieve_User_Ind_Selections;
726:
727:

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
737: )
738: IS
739: BEGIN
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742:
743: EXCEPTION
744: WHEN OTHERS THEN

Line 745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

741:
742:
743: EXCEPTION
744: WHEN OTHERS THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746:
747: END Update_User_Ind_Selection;
748:
749:

Line 764: x_return_status := FND_API.G_RET_STS_SUCCESS;

760: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
761:
762: BEGIN
763:
764: x_return_status := FND_API.G_RET_STS_SUCCESS;
765:
766: DELETE FROM BIS_USER_IND_SELECTIONS
767: WHERE user_id = p_user_id
768: AND plug_id = p_plug_id;

Line 773: WHEN FND_API.G_EXC_ERROR THEN

769:
770: COMMIT;
771:
772: EXCEPTION
773: WHEN FND_API.G_EXC_ERROR THEN
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:G_EXC_ERROR'); htp.para;
776: RAISE;
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 774: x_return_status := FND_API.G_RET_STS_ERROR;

770: COMMIT;
771:
772: EXCEPTION
773: WHEN FND_API.G_EXC_ERROR THEN
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:G_EXC_ERROR'); htp.para;
776: RAISE;
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

773: WHEN FND_API.G_EXC_ERROR THEN
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:G_EXC_ERROR'); htp.para;
776: RAISE;
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:G_EXC_UNEXPECTED_ERROR'); htp.para;
780: RAISE;
781: WHEN OTHERS THEN

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

774: x_return_status := FND_API.G_RET_STS_ERROR;
775: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:G_EXC_ERROR'); htp.para;
776: RAISE;
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:G_EXC_UNEXPECTED_ERROR'); htp.para;
780: RAISE;
781: WHEN OTHERS THEN
782: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 782: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:G_EXC_UNEXPECTED_ERROR'); htp.para;
780: RAISE;
781: WHEN OTHERS THEN
782: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
783: l_error_Tbl := x_error_Tbl;
784: BIS_UTILITIES_PVT.Add_Error_Message
785: ( p_error_table => l_error_Tbl
786: , p_error_msg_id => SQLCODE

Line 791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

787: , p_error_description => SQLERRM
788: , x_error_table => x_error_Tbl
789: );
790: htp.p('BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections:OTHERS'); htp.para;
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
792: --
793:
794: END Delete_User_Ind_Selections;
795:

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

810: WHERE uis.user_id = l_user_ID
811: AND uis.plug_id = p_Plug_ID;
812:
813: BEGIN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: -- IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) THEN
817: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) = FND_API.G_TRUE THEN
818: l_User_ID := p_User_ID;

Line 817: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) = FND_API.G_TRUE THEN

813: BEGIN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: -- IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) THEN
817: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_ID) = FND_API.G_TRUE THEN
818: l_User_ID := p_User_ID;
819: ELSE
820: SELECT user_id
821: INTO l_user_id

Line 836: x_return_status := FND_API.G_RET_STS_ERROR ;

832: END LOOP;
833:
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: x_return_status := FND_API.G_RET_STS_ERROR ;
837: when others then
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839:
840: END Retrieve_User_Labels;

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: x_return_status := FND_API.G_RET_STS_ERROR ;
837: when others then
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839:
840: END Retrieve_User_Labels;
841:
842:

Line 854: x_return_status := FND_API.G_RET_STS_SUCCESS;

850: )
851: IS
852: e_InvalidRecordException EXCEPTION;
853: BEGIN
854: x_return_status := FND_API.G_RET_STS_SUCCESS;
855:
856: Validate_Required_Fields(
857: p_event => p_event
858: ,p_user_id => p_user_id

Line 862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

858: ,p_user_id => p_user_id
859: ,p_Indicator_Region_Rec => p_Indicator_Region_Rec
860: ,x_return_status => x_return_status);
861:
862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
863: RAISE e_InvalidRecordException;
864: END IF;
865:
866: IF p_event = 'CREATE' THEN

Line 880: x_return_status := FND_API.G_RET_STS_ERROR ;

876: END IF;
877:
878: EXCEPTION
879: when e_InvalidEventException OR e_InvalidRecordException then
880: x_return_status := FND_API.G_RET_STS_ERROR ;
881: when others then
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883:
884: END Validate_User_Ind_Selection;

Line 882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

878: EXCEPTION
879: when e_InvalidEventException OR e_InvalidRecordException then
880: x_return_status := FND_API.G_RET_STS_ERROR ;
881: when others then
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883:
884: END Validate_User_Ind_Selection;
885:
886:

Line 898: x_return_status := FND_API.G_RET_STS_SUCCESS;

894: IS
895: e_MissingValuesException EXCEPTION;
896:
897: BEGIN
898: x_return_status := FND_API.G_RET_STS_SUCCESS;
899:
900: IF p_event NOT IN ( 'CREATE',
901: 'UPDATE',
902: 'RETRIEVE',

Line 915: = FND_API.G_FALSE

911: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
912: p_Indicator_Region_Rec.PLUG_ID)) THEN
913: */
914: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.USER_ID)
915: = FND_API.G_FALSE
916: OR BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.PLUG_ID)
917: = FND_API.G_FALSE
918: THEN
919:

Line 917: = FND_API.G_FALSE

913: */
914: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.USER_ID)
915: = FND_API.G_FALSE
916: OR BIS_UTILITIES_PUB.Value_Not_Missing(p_Indicator_Region_Rec.PLUG_ID)
917: = FND_API.G_FALSE
918: THEN
919:
920: RAISE e_MissingValuesException;
921:

Line 931: p_Indicator_Region_Rec.Target_Level_ID) = FND_API.G_FALSE

927: (NOT BIS_UTILITIES_PUB.Value_Not_Missing(
928: p_Indicator_Region_Rec.org_level_value_id)) THEN
929: */
930: IF BIS_UTILITIES_PUB.Value_Not_Missing(
931: p_Indicator_Region_Rec.Target_Level_ID) = FND_API.G_FALSE
932: -- mdamle 01/15/2001 - Use Dim6 and Dim7
933: -- OR BIS_UTILITIES_PUB.Value_Not_Missing(
934: -- p_Indicator_Region_Rec.Org_Level_Value_ID) = FND_API.G_FALSE
935: THEN

Line 934: -- p_Indicator_Region_Rec.Org_Level_Value_ID) = FND_API.G_FALSE

930: IF BIS_UTILITIES_PUB.Value_Not_Missing(
931: p_Indicator_Region_Rec.Target_Level_ID) = FND_API.G_FALSE
932: -- mdamle 01/15/2001 - Use Dim6 and Dim7
933: -- OR BIS_UTILITIES_PUB.Value_Not_Missing(
934: -- p_Indicator_Region_Rec.Org_Level_Value_ID) = FND_API.G_FALSE
935: THEN
936: RAISE e_MissingValuesException;
937: END IF;
938: END IF;

Line 945: x_return_status := FND_API.G_RET_STS_ERROR ;

941: Exception
942: when e_InvalidEventException then
943: RAISE;
944: when e_MissingValuesException then
945: x_return_status := FND_API.G_RET_STS_ERROR ;
946: when others then
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: END Validate_Required_Fields;

Line 947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

943: RAISE;
944: when e_MissingValuesException then
945: x_return_status := FND_API.G_RET_STS_ERROR ;
946: when others then
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: END Validate_Required_Fields;
950:
951: END ;-- BIS_INDICATOR_REGION_PVT;