DBA Data[Home] [Help]

APPS.BIS_FUNCTIONAL_AREA_PUB dependencies on FND_MESSAGE

Line 775: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_IS_NULL');

771: FND_MSG_PUB.Initialize;
772: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
773:
774: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(LTRIM(RTRIM(p_Func_Area_Rec.Short_Name))) = FND_API.G_TRUE) THEN
775: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_IS_NULL');
776: FND_MSG_PUB.ADD;
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779:

Line 789: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_EXISTS');

785: FROM BIS_FUNCTIONAL_AREAS
786: WHERE UPPER(SHORT_NAME) = UPPER(p_Func_Area_Rec.Short_Name);
787:
788: IF (l_Count <> 0) THEN
789: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_EXISTS');
790: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;

Line 790: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);

786: WHERE UPPER(SHORT_NAME) = UPPER(p_Func_Area_Rec.Short_Name);
787:
788: IF (l_Count <> 0) THEN
789: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_EXISTS');
790: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:

Line 796: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');

792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: END IF;
794:
795: IF (p_Func_Area_Rec.Functional_Area_Id IS NULL) THEN
796: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
797: FND_MSG_PUB.ADD;
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: END IF;
800:

Line 803: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_NAME_NOT_ENTERED');

799: END IF;
800:
801:
802: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(LTRIM(RTRIM(p_Func_Area_Rec.Name))) = FND_API.G_TRUE) THEN
803: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_NAME_NOT_ENTERED');
804: FND_MSG_PUB.ADD;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:

Line 812: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');

808: ELSIF(p_Action_Type = C_UPDATE OR p_Action_Type = C_RETRIEVE OR p_Action_Type = C_DELETE) THEN
809:
810: /*
811: IF (p_Func_Area_Rec.Functional_Area_Id IS NULL) THEN
812: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
813: FND_MSG_PUB.ADD;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816: */

Line 823: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_NOT_EXISTS');

819: FROM BIS_FUNCTIONAL_AREAS_VL
820: WHERE SHORT_NAME = p_Func_Area_Rec.Short_Name;
821:
822: IF (l_Count = 0) THEN
823: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_NOT_EXISTS');
824: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);
825: FND_MSG_PUB.ADD;
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;

Line 824: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);

820: WHERE SHORT_NAME = p_Func_Area_Rec.Short_Name;
821:
822: IF (l_Count = 0) THEN
823: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_NOT_EXISTS');
824: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Func_Area_Rec.Short_Name);
825: FND_MSG_PUB.ADD;
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:

Line 883: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');

879: FND_MSG_PUB.Initialize;
880: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
881:
882: IF (p_Functional_Area_Id IS NULL) THEN
883: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
884: FND_MSG_PUB.ADD;
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887:

Line 889: FND_MESSAGE.SET_NAME('BIS','BIS_APP_ID_NOT_ENTERED');

885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887:
888: IF (p_Application_Id IS NULL) THEN
889: FND_MESSAGE.SET_NAME('BIS','BIS_APP_ID_NOT_ENTERED');
890: FND_MSG_PUB.ADD;
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893:

Line 899: FND_MESSAGE.SET_NAME('BIS','BIS_FA_ID_NOT_EXISTS');

895: FROM BIS_FUNCTIONAL_AREAS
896: WHERE FUNCTIONAL_AREA_ID = p_Functional_Area_Id;
897:
898: IF (l_Count = 0) THEN
899: FND_MESSAGE.SET_NAME('BIS','BIS_FA_ID_NOT_EXISTS');
900: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
901: FND_MSG_PUB.ADD;
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;

Line 900: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);

896: WHERE FUNCTIONAL_AREA_ID = p_Functional_Area_Id;
897:
898: IF (l_Count = 0) THEN
899: FND_MESSAGE.SET_NAME('BIS','BIS_FA_ID_NOT_EXISTS');
900: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
901: FND_MSG_PUB.ADD;
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;
904:

Line 915: FND_MESSAGE.SET_NAME('BIS','BIS_APPS_ID_NOT_EXISTS');

911: FROM FND_APPLICATION
912: WHERE APPLICATION_ID = p_Application_Id;
913:
914: IF (l_Count = 0) THEN
915: FND_MESSAGE.SET_NAME('BIS','BIS_APPS_ID_NOT_EXISTS');
916: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;

Line 916: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);

912: WHERE APPLICATION_ID = p_Application_Id;
913:
914: IF (l_Count = 0) THEN
915: FND_MESSAGE.SET_NAME('BIS','BIS_APPS_ID_NOT_EXISTS');
916: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;

Line 928: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_EXIST');

924: WHERE FUNCTIONAL_AREA_ID = p_Functional_Area_Id
925: AND APPLICATION_ID = p_Application_Id;
926:
927: IF l_Count <> 0 THEN
928: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_EXIST');
929: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
930: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
931: FND_MSG_PUB.ADD;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 929: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);

925: AND APPLICATION_ID = p_Application_Id;
926:
927: IF l_Count <> 0 THEN
928: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_EXIST');
929: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
930: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
931: FND_MSG_PUB.ADD;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;

Line 930: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);

926:
927: IF l_Count <> 0 THEN
928: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_EXIST');
929: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
930: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
931: FND_MSG_PUB.ADD;
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:

Line 941: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_ALREADY_EXIST');

937: FROM BIS_FUNC_AREA_APP_DEPENDENCY
938: WHERE APPLICATION_ID = p_Application_Id;
939:
940: IF l_Count > 0 THEN
941: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_ALREADY_EXIST');
942: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
943: FND_MSG_PUB.ADD;
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945: END IF;

Line 942: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);

938: WHERE APPLICATION_ID = p_Application_Id;
939:
940: IF l_Count > 0 THEN
941: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_ALREADY_EXIST');
942: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
943: FND_MSG_PUB.ADD;
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945: END IF;
946:

Line 958: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_NOT_EXIST');

954: WHERE FUNCTIONAL_AREA_ID = p_Functional_Area_Id
955: AND APPLICATION_ID = p_Application_Id;
956:
957: IF (l_Count = 0) THEN
958: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_NOT_EXIST');
959: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
960: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
961: FND_MSG_PUB.ADD;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 959: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);

955: AND APPLICATION_ID = p_Application_Id;
956:
957: IF (l_Count = 0) THEN
958: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_NOT_EXIST');
959: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
960: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
961: FND_MSG_PUB.ADD;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;

Line 960: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);

956:
957: IF (l_Count = 0) THEN
958: FND_MESSAGE.SET_NAME('BIS','BIS_FA_APPS_ID_NOT_EXIST');
959: FND_MESSAGE.SET_TOKEN('APPS_ID', p_Application_Id);
960: FND_MESSAGE.SET_TOKEN('FA_ID', p_Functional_Area_Id);
961: FND_MSG_PUB.ADD;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;
964: