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.BSC_BIS_DIM_REL_PUB dependencies on FND_MESSAGE

Line 1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

1252: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');
1253: FND_MSG_PUB.Initialize;
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF (p_dim_obj_id IS NULL) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;

Line 1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

1253: FND_MSG_PUB.Initialize;
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF (p_dim_obj_id IS NULL) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261: IF (p_parent_ids IS NOT NULL) THEN

Line 1567: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

1563: --DBMS_OUTPUT.PUT_LINE('p_child_rel_column '||p_child_rel_column);
1564: --DBMS_OUTPUT.PUT_LINE('p_child_data_type '||p_child_data_type);
1565: --DBMS_OUTPUT.PUT_LINE('p_child_data_source '||p_child_data_source);
1566: IF (p_dim_obj_id IS NULL) THEN
1567: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1568: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;

Line 1568: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

1564: --DBMS_OUTPUT.PUT_LINE('p_child_data_type '||p_child_data_type);
1565: --DBMS_OUTPUT.PUT_LINE('p_child_data_source '||p_child_data_source);
1566: IF (p_dim_obj_id IS NULL) THEN
1567: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1568: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: SELECT COUNT(*) INTO l_count

Line 1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');

1572: SELECT COUNT(*) INTO l_count
1573: FROM BSC_SYS_DIM_LEVELS_B
1574: WHERE dim_level_id = p_dim_obj_id;
1575: IF (l_count = 0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1578: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;

Line 1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

1573: FROM BSC_SYS_DIM_LEVELS_B
1574: WHERE dim_level_id = p_dim_obj_id;
1575: IF (l_count = 0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1578: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;

Line 1578: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);

1574: WHERE dim_level_id = p_dim_obj_id;
1575: IF (l_count = 0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1578: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;
1582:

Line 1817: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');

1813: (l_bsc_dim_obj_rec.bsc_relation_type <> 1) AND (l_bsc_dim_obj_rec.bsc_relation_type <> 2)) THEN
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;

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 1848: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');

1844: END IF;
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');

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 1880: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');

1876: FROM BSC_SYS_DIM_LEVEL_RELS
1877: WHERE dim_level_id = l_bsc_dim_obj_rec.bsc_parent_level_id
1878: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
1879: IF (l_count <> 0) THEN
1880: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
1881: FND_MSG_PUB.ADD;
1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884: END IF;

Line 1915: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');

1911: END IF;
1912: END IF;
1913: -- END Granluar Locking
1914: ELSE
1915: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: END IF;
1919: END LOOP;

Line 1964: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');

1960: (l_bsc_dim_obj_rec.bsc_relation_type <> 1) AND (l_bsc_dim_obj_rec.bsc_relation_type <> 2)) THEN
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');

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 1997: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');

1993: --DBMS_OUTPUT.PUT_LINE('l_bsc_dim_obj_rec.Bsc_Data_Source_Type <'||l_bsc_dim_obj_rec.Bsc_Data_Source_Type);
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');

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;

Line 2041: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');

2037: FROM BSC_SYS_DIM_LEVEL_RELS
2038: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Parent_Level_Id
2039: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
2040: IF (l_count <> 0) THEN
2041: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
2042: FND_MSG_PUB.ADD;
2043: RAISE FND_API.G_EXC_ERROR;
2044: END IF;
2045: END IF;

Line 2086: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');

2082: l_Is_PMF_Recur_Type := TRUE;
2083: END IF;
2084:
2085: IF (NOT ((l_db_child_rel_type = 2) AND (l_bsc_dim_obj_rec.bsc_relation_type = 2)) AND l_Is_PMF_Recur_Type = FALSE)THEN
2086: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
2087: FND_MSG_PUB.ADD;
2088: RAISE FND_API.G_EXC_ERROR;
2089: END IF;
2090: END IF;

Line 2296: FND_MESSAGE.SET_NAME('BSC','BSC_MAX_DIM_OBJ_RELS');

2292: FROM BSC_SYS_DIM_LEVEL_RELS A
2293: WHERE A.Dim_Level_Id = l_One_N_Table(i).p_dim_obj_id
2294: AND A.Relation_Type = 1;
2295: IF (l_Count > MAX_PARENTS_RELS_1_N) THEN
2296: FND_MESSAGE.SET_NAME('BSC','BSC_MAX_DIM_OBJ_RELS');
2297: FND_MSG_PUB.ADD;
2298: RAISE FND_API.G_EXC_ERROR;
2299: END IF;
2300: END IF;

Line 2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

2570: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');
2571: FND_MSG_PUB.Initialize;
2572: x_return_status := FND_API.G_RET_STS_SUCCESS;
2573: IF (p_dim_obj_id IS NULL) THEN
2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2576: FND_MSG_PUB.ADD;
2577: RAISE FND_API.G_EXC_ERROR;
2578: END IF;

Line 2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

2571: FND_MSG_PUB.Initialize;
2572: x_return_status := FND_API.G_RET_STS_SUCCESS;
2573: IF (p_dim_obj_id IS NULL) THEN
2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2576: FND_MSG_PUB.ADD;
2577: RAISE FND_API.G_EXC_ERROR;
2578: END IF;
2579: FOR cd IN c_parent_ids LOOP

Line 2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

2968: x_return_status := FND_API.G_RET_STS_SUCCESS;
2969: BSC_APPS.Init_Bsc_Apps;
2970: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
2971: IF (p_dim_obj_id IS NULL) THEN
2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: END IF;

Line 2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

2969: BSC_APPS.Init_Bsc_Apps;
2970: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
2971: IF (p_dim_obj_id IS NULL) THEN
2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: END IF;
2977: IF (p_dim_obj_id IS NOT NULL) THEN

Line 2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');

2980: FROM BSC_SYS_DIM_LEVELS_B
2981: WHERE Dim_Level_Id = p_dim_obj_id;
2982:
2983: IF (l_count = 0) THEN
2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2986: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;

Line 2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

2981: WHERE Dim_Level_Id = p_dim_obj_id;
2982:
2983: IF (l_count = 0) THEN
2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2986: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;

Line 2986: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);

2982:
2983: IF (l_count = 0) THEN
2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2986: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;
2990: END IF;

Line 3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

3315: FND_MSG_PUB.Initialize;
3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: BSC_APPS.Init_Bsc_Apps;
3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3321: FND_MSG_PUB.ADD;
3322: RAISE FND_API.G_EXC_ERROR;
3323: END IF;

Line 3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: BSC_APPS.Init_Bsc_Apps;
3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3321: FND_MSG_PUB.ADD;
3322: RAISE FND_API.G_EXC_ERROR;
3323: END IF;
3324: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_M_To_N_MTable Function');

Line 3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');

3329: FROM BSC_SYS_DIM_LEVELS_B
3330: WHERE Dim_Level_Id = p_dim_obj_id;
3331:
3332: IF (l_count = 0) THEN
3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3335: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
3336: FND_MSG_PUB.ADD;
3337: RAISE FND_API.G_EXC_ERROR;

Line 3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

3330: WHERE Dim_Level_Id = p_dim_obj_id;
3331:
3332: IF (l_count = 0) THEN
3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3335: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
3336: FND_MSG_PUB.ADD;
3337: RAISE FND_API.G_EXC_ERROR;
3338: END IF;

Line 3335: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);

3331:
3332: IF (l_count = 0) THEN
3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3335: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
3336: FND_MSG_PUB.ADD;
3337: RAISE FND_API.G_EXC_ERROR;
3338: END IF;
3339: END IF;

Line 3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

3539: FND_MSG_PUB.Initialize;
3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3542: IF (p_dim_obj_id IS NULL) THEN
3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;

Line 3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3542: IF (p_dim_obj_id IS NULL) THEN
3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:

Line 3988: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');

3984: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_kpi_names, 401, 200));
3985: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_kpi_names, 601, 200));
3986: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_kpi_names, 801, 200));
3987: IF ((l_strut_flag) AND (l_kpi_names IS NOT NULL)) THEN
3988: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3989: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
3990: FND_MSG_PUB.ADD;
3991: RAISE FND_API.G_EXC_ERROR;
3992: END IF;

Line 3989: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);

3985: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_kpi_names, 601, 200));
3986: --DBMS_OUTPUT.PUT_LINE(SUBSTR(l_kpi_names, 801, 200));
3987: IF ((l_strut_flag) AND (l_kpi_names IS NOT NULL)) THEN
3988: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3989: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
3990: FND_MSG_PUB.ADD;
3991: RAISE FND_API.G_EXC_ERROR;
3992: END IF;
3993: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');

Line 4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');

4113: AND DIM_SET_ID = l_dimset_id
4114: AND PARENT_LEVEL_INDEX >= 0;
4115: --DBMS_OUTPUT.PUT_LINE('kpi_id :- '||l_kpi_id||'dimset_id :- '||l_dimset_id||'No of rels are :- '||l_no_rels );
4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;
4121: ROLLBACK TO sp_before_rel_config;

Line 4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);

4114: AND PARENT_LEVEL_INDEX >= 0;
4115: --DBMS_OUTPUT.PUT_LINE('kpi_id :- '||l_kpi_id||'dimset_id :- '||l_dimset_id||'No of rels are :- '||l_no_rels );
4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;
4121: ROLLBACK TO sp_before_rel_config;
4122: RAISE FND_API.G_EXC_ERROR;

Line 4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);

4115: --DBMS_OUTPUT.PUT_LINE('kpi_id :- '||l_kpi_id||'dimset_id :- '||l_dimset_id||'No of rels are :- '||l_no_rels );
4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;
4121: ROLLBACK TO sp_before_rel_config;
4122: RAISE FND_API.G_EXC_ERROR;
4123: END IF;