DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_DIMENSION_LEVELS_PVT

Line 1818: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));

1814: l_bsc_dim_obj_rec.bsc_relation_type := 1;
1815: END IF;
1816: IF (l_bsc_dim_obj_rec.bsc_parent_level_source <> l_bsc_dim_obj_rec.Bsc_Source) THEN
1817: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');
1818: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1819: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');

Line 1819: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));

1815: END IF;
1816: IF (l_bsc_dim_obj_rec.bsc_parent_level_source <> l_bsc_dim_obj_rec.Bsc_Source) THEN
1817: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');
1818: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1819: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1823: END IF;

Line 1849: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));

1845:
1846: IF ((l_bsc_dim_obj_rec.bsc_relation_type = 2) AND
1847: (l_bsc_dim_obj_rec.Bsc_Level_Id = l_bsc_dim_obj_rec.bsc_parent_level_id)) THEN
1848: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');
1849: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1850: FND_MSG_PUB.ADD;
1851: RAISE FND_API.G_EXC_ERROR;
1852: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1853: END IF;

Line 1965: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));

1961: l_bsc_dim_obj_rec.bsc_relation_type := 1;
1962: END IF;
1963: IF(l_bsc_dim_obj_rec.bsc_parent_level_source <> l_bsc_dim_obj_rec.Bsc_Source) THEN
1964: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');
1965: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1966: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1967: FND_MSG_PUB.ADD;
1968: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
1969: RAISE FND_API.G_EXC_ERROR;

Line 1966: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));

1962: END IF;
1963: IF(l_bsc_dim_obj_rec.bsc_parent_level_source <> l_bsc_dim_obj_rec.Bsc_Source) THEN
1964: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');
1965: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1966: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1967: FND_MSG_PUB.ADD;
1968: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
1969: RAISE FND_API.G_EXC_ERROR;
1970:

Line 1998: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));

1994: --DBMS_OUTPUT.PUT_LINE('l_bsc_dim_obj_rec.Bsc_Data_Source <'||l_bsc_dim_obj_rec.Bsc_Data_Source);
1995: IF ((l_bsc_dim_obj_rec.bsc_relation_type = 2) AND
1996: (l_bsc_dim_obj_rec.Bsc_Level_Id = l_bsc_dim_obj_rec.bsc_parent_level_id)) THEN
1997: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');
1998: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1999: FND_MSG_PUB.ADD;
2000: RAISE FND_API.G_EXC_ERROR;
2001: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
2002: END IF;