DBA Data[Home] [Help]

APPS.BSC_BIS_DIMENSION_PUB dependencies on FND_MESSAGE

Line 73: REM | FND_MESSAGE.SET_TOKEN API |

69: REM | 10-FEB-2006 akoduri Bug#4997042 Cascade 'All' property from dim |
70: REM | designer to dim groups of Reports |
71: REM | 15-JUN-2006 ashankar Bug#5254737 Made changes to Create_Dimension |
72: REM | Method.Removed the parameter value 'TRUE' in |
73: REM | FND_MESSAGE.SET_TOKEN API |
74: REM | 27-Jun-07 ashankar Bug#6134149 synching up the dim obj props to |
75: REM | BSC_KPI_MEASURE_PROPS table |
76: REM | 02-AUG-07 psomesul B#6168487-Handling dim. object comparison settings |
77: REM +=======================================================================+

Line 591: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

587: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
588: IF (l_error_tbl.COUNT > 0) THEN
589: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
590: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
591: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
592: FND_MSG_PUB.ADD;
593: x_msg_data := NULL;
594: END IF;
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

955:
956: END IF;
957:
958: IF (l_dim_short_name IS NULL) THEN
959: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
960: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
961: FND_MSG_PUB.ADD;
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;

Line 960: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));

956: END IF;
957:
958: IF (l_dim_short_name IS NULL) THEN
959: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
960: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
961: FND_MSG_PUB.ADD;
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: IF (NOT is_Valid_AlphaNum(l_dim_short_name)) THEN

Line 965: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');

961: FND_MSG_PUB.ADD;
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: IF (NOT is_Valid_AlphaNum(l_dim_short_name)) THEN
965: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
966: FND_MESSAGE.SET_TOKEN('VALUE', l_dim_short_name);
967: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_ERROR;

Line 966: FND_MESSAGE.SET_TOKEN('VALUE', l_dim_short_name);

962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: IF (NOT is_Valid_AlphaNum(l_dim_short_name)) THEN
965: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
966: FND_MESSAGE.SET_TOKEN('VALUE', l_dim_short_name);
967: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;

Line 967: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));

963: END IF;
964: IF (NOT is_Valid_AlphaNum(l_dim_short_name)) THEN
965: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
966: FND_MESSAGE.SET_TOKEN('VALUE', l_dim_short_name);
967: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: IF (p_display_name IS NULL) THEN

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

968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: IF (p_display_name IS NULL) THEN
972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
974: FND_MSG_PUB.ADD;
975: RAISE FND_API.G_EXC_ERROR;
976: END IF;

Line 973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971: IF (p_display_name IS NULL) THEN
972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
974: FND_MSG_PUB.ADD;
975: RAISE FND_API.G_EXC_ERROR;
976: END IF;
977: IF (l_application_id IS NULL) THEN

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

974: FND_MSG_PUB.ADD;
975: RAISE FND_API.G_EXC_ERROR;
976: END IF;
977: IF (l_application_id IS NULL) THEN
978: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
979: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'APPLICATION_ID'));
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;

Line 979: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'APPLICATION_ID'));

975: RAISE FND_API.G_EXC_ERROR;
976: END IF;
977: IF (l_application_id IS NULL) THEN
978: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
979: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'APPLICATION_ID'));
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:

Line 988: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

984: SELECT COUNT(1) INTO l_count
985: FROM BSC_SYS_DIM_GROUPS_TL
986: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
987: IF (l_count <> 0) THEN
988: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
989: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
990: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);
991: FND_MSG_PUB.ADD;
992: RAISE FND_API.G_EXC_ERROR;

Line 989: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));

985: FROM BSC_SYS_DIM_GROUPS_TL
986: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
987: IF (l_count <> 0) THEN
988: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
989: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
990: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);
991: FND_MSG_PUB.ADD;
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;

Line 990: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);

986: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
987: IF (l_count <> 0) THEN
988: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
989: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
990: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);
991: FND_MSG_PUB.ADD;
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:

Line 999: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

995: SELECT COUNT(1) INTO l_count
996: FROM BIS_DIMENSIONS_VL
997: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
998: IF (l_count <> 0) THEN
999: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1000: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
1001: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;

Line 1000: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));

996: FROM BIS_DIMENSIONS_VL
997: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
998: IF (l_count <> 0) THEN
999: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1000: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
1001: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;

Line 1001: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);

997: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
998: IF (l_count <> 0) THEN
999: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1000: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));
1001: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_dim_short_name);
1002: FND_MSG_PUB.ADD;
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005:

Line 1048: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

1044: SELECT COUNT(1) INTO l_count
1045: FROM BSC_SYS_DIM_GROUPS_VL
1046: WHERE UPPER(name) = UPPER(p_display_name);
1047: IF (l_count <> 0) THEN
1048: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1049: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
1050: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
1051: FND_MSG_PUB.ADD;
1052: RAISE FND_API.G_EXC_ERROR;

Line 1049: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

1045: FROM BSC_SYS_DIM_GROUPS_VL
1046: WHERE UPPER(name) = UPPER(p_display_name);
1047: IF (l_count <> 0) THEN
1048: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1049: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
1050: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
1051: FND_MSG_PUB.ADD;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;

Line 1050: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);

1046: WHERE UPPER(name) = UPPER(p_display_name);
1047: IF (l_count <> 0) THEN
1048: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1049: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
1050: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
1051: FND_MSG_PUB.ADD;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:

Line 1059: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

1055: SELECT COUNT(1) INTO l_count
1056: FROM BIS_DIMENSIONS_VL
1057: WHERE UPPER(name) = UPPER(p_display_name);
1058: IF (l_count <> 0) THEN
1059: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1060: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
1061: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;

Line 1060: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

1056: FROM BIS_DIMENSIONS_VL
1057: WHERE UPPER(name) = UPPER(p_display_name);
1058: IF (l_count <> 0) THEN
1059: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1060: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
1061: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;

Line 1061: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);

1057: WHERE UPPER(name) = UPPER(p_display_name);
1058: IF (l_count <> 0) THEN
1059: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1060: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));
1061: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
1062: FND_MSG_PUB.ADD;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:

Line 1140: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

1136: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1137: IF (l_error_tbl.COUNT > 0) THEN
1138: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
1139: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
1140: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
1141: FND_MSG_PUB.ADD;
1142: x_msg_data := NULL;
1143: END IF;
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1272:
1273: FND_MSG_PUB.Initialize;
1274: x_return_status := FND_API.G_RET_STS_SUCCESS;
1275: IF (p_dim_short_name IS NULL) THEN
1276: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1277: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
1278: FND_MSG_PUB.ADD;
1279: RAISE FND_API.G_EXC_ERROR;
1280: END IF;

Line 1277: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

1273: FND_MSG_PUB.Initialize;
1274: x_return_status := FND_API.G_RET_STS_SUCCESS;
1275: IF (p_dim_short_name IS NULL) THEN
1276: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1277: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
1278: FND_MSG_PUB.ADD;
1279: RAISE FND_API.G_EXC_ERROR;
1280: END IF;
1281: IF (p_dim_obj_short_names IS NOT NULL) THEN

Line 1290: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

1286: FETCH cr_bsc_dim_id
1287: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
1288: CLOSE cr_bsc_dim_id;
1289: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
1290: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1291: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
1292: FND_MSG_PUB.ADD;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;

Line 1291: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);

1287: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
1288: CLOSE cr_bsc_dim_id;
1289: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
1290: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1291: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
1292: FND_MSG_PUB.ADD;
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295: IF (p_Restrict_Dim_Validate IS NOT NULL) THEN

Line 1332: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

1328: INTO l_dim_level_id
1329: , l_Source_Type;
1330: CLOSE cr_bsc_dim_obj_id;
1331: IF (l_dim_level_id IS NULL) THEN
1332: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1333: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;

Line 1333: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

1329: , l_Source_Type;
1330: CLOSE cr_bsc_dim_obj_id;
1331: IF (l_dim_level_id IS NULL) THEN
1332: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1333: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337:

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

1581:
1582: FND_MSG_PUB.Initialize;
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584: IF (p_dim_short_name IS NULL) THEN
1585: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1586: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
1587: FND_MSG_PUB.ADD;
1588: RAISE FND_API.G_EXC_ERROR;
1589: END IF;

Line 1586: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

1582: FND_MSG_PUB.Initialize;
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584: IF (p_dim_short_name IS NULL) THEN
1585: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1586: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
1587: FND_MSG_PUB.ADD;
1588: RAISE FND_API.G_EXC_ERROR;
1589: END IF;
1590: IF (cr_bsc_dim_id%ISOPEN) THEN

Line 1598: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

1594: FETCH cr_bsc_dim_id
1595: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
1596: CLOSE cr_bsc_dim_id;
1597: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
1598: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1599: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
1600: FND_MSG_PUB.ADD;
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;

Line 1599: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);

1595: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
1596: CLOSE cr_bsc_dim_id;
1597: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
1598: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1599: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
1600: FND_MSG_PUB.ADD;
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603:

Line 1629: FND_MESSAGE.SET_NAME('BIS', 'BIS_ONE_RNKLVL_IN_DIMGRP');

1625: END IF;
1626: END LOOP;
1627: IF ((l_comp_count > 0) AND (p_default_value = 'C')) THEN
1628: IF (l_Dim_Obj_Source = 'PMF') THEN
1629: FND_MESSAGE.SET_NAME('BIS', 'BIS_ONE_RNKLVL_IN_DIMGRP');
1630: FND_MESSAGE.SET_TOKEN('BIS_DIM_OBJ', l_Dim_Obj_Name, TRUE);
1631: FND_MSG_PUB.ADD;
1632: RAISE FND_API.G_EXC_ERROR;
1633: ELSIF (l_Dim_Obj_Source = 'BSC') THEN

Line 1630: FND_MESSAGE.SET_TOKEN('BIS_DIM_OBJ', l_Dim_Obj_Name, TRUE);

1626: END LOOP;
1627: IF ((l_comp_count > 0) AND (p_default_value = 'C')) THEN
1628: IF (l_Dim_Obj_Source = 'PMF') THEN
1629: FND_MESSAGE.SET_NAME('BIS', 'BIS_ONE_RNKLVL_IN_DIMGRP');
1630: FND_MESSAGE.SET_TOKEN('BIS_DIM_OBJ', l_Dim_Obj_Name, TRUE);
1631: FND_MSG_PUB.ADD;
1632: RAISE FND_API.G_EXC_ERROR;
1633: ELSIF (l_Dim_Obj_Source = 'BSC') THEN
1634: FND_MESSAGE.SET_NAME('BSC', 'BSC_D_ONE_DIM_IN_COMPARISON');

Line 1634: FND_MESSAGE.SET_NAME('BSC', 'BSC_D_ONE_DIM_IN_COMPARISON');

1630: FND_MESSAGE.SET_TOKEN('BIS_DIM_OBJ', l_Dim_Obj_Name, TRUE);
1631: FND_MSG_PUB.ADD;
1632: RAISE FND_API.G_EXC_ERROR;
1633: ELSIF (l_Dim_Obj_Source = 'BSC') THEN
1634: FND_MESSAGE.SET_NAME('BSC', 'BSC_D_ONE_DIM_IN_COMPARISON');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: END IF;
1638: END IF;

Line 1688: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

1684: INTO l_bsc_dimension_rec.Bsc_Level_Id;
1685: CLOSE cr_bsc_dim_obj_id;
1686:
1687: IF (l_bsc_dimension_rec.Bsc_Level_Id IS NULL) THEN
1688: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1689: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
1690: FND_MSG_PUB.ADD;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;

Line 1689: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

1685: CLOSE cr_bsc_dim_obj_id;
1686:
1687: IF (l_bsc_dimension_rec.Bsc_Level_Id IS NULL) THEN
1688: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1689: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
1690: FND_MSG_PUB.ADD;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: -- Can test with 'LEGAL ENTITY', 'EDW_HR_PERM_SPSR1_L9'

Line 1699: FND_MESSAGE.SET_NAME('BSC','BSC_UNAVAILABLE_LEVEL');

1695: IF (p_create_view = 1 AND l_Rolling_Period = 0) THEN
1696: IF NOT (BSC_BIS_DIMENSION_PUB.Attmpt_Recr_View(
1697: p_dim_lvl_shrt_name => p_dim_obj_short_name
1698: , x_dim_lvl_name => l_dim_lvl_name)) THEN
1699: FND_MESSAGE.SET_NAME('BSC','BSC_UNAVAILABLE_LEVEL');
1700: FND_MESSAGE.SET_TOKEN('BSC_LEVEL', l_dim_lvl_name, TRUE);
1701: FND_MSG_PUB.ADD;
1702: RAISE FND_API.G_EXC_ERROR;
1703: END IF;

Line 1700: FND_MESSAGE.SET_TOKEN('BSC_LEVEL', l_dim_lvl_name, TRUE);

1696: IF NOT (BSC_BIS_DIMENSION_PUB.Attmpt_Recr_View(
1697: p_dim_lvl_shrt_name => p_dim_obj_short_name
1698: , x_dim_lvl_name => l_dim_lvl_name)) THEN
1699: FND_MESSAGE.SET_NAME('BSC','BSC_UNAVAILABLE_LEVEL');
1700: FND_MESSAGE.SET_TOKEN('BSC_LEVEL', l_dim_lvl_name, TRUE);
1701: FND_MSG_PUB.ADD;
1702: RAISE FND_API.G_EXC_ERROR;
1703: END IF;
1704: END IF;

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

2058: IF (p_dim_short_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
2059: FND_MSG_PUB.Initialize;
2060: x_return_status := FND_API.G_RET_STS_SUCCESS;
2061: IF (p_dim_short_name IS NULL) THEN
2062: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2063: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2064: FND_MSG_PUB.ADD;
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;

Line 2063: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

2059: FND_MSG_PUB.Initialize;
2060: x_return_status := FND_API.G_RET_STS_SUCCESS;
2061: IF (p_dim_short_name IS NULL) THEN
2062: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2063: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2064: FND_MSG_PUB.ADD;
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067: IF (cr_bsc_dimension_id%ISOPEN) THEN

Line 2075: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

2071: FETCH cr_bsc_dimension_id
2072: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
2073: CLOSE cr_bsc_dimension_id;
2074: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
2075: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
2077: FND_MSG_PUB.ADD;
2078: RAISE FND_API.G_EXC_ERROR;
2079: END IF;

Line 2076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);

2072: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
2073: CLOSE cr_bsc_dimension_id;
2074: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
2075: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
2077: FND_MSG_PUB.ADD;
2078: RAISE FND_API.G_EXC_ERROR;
2079: END IF;
2080: -- START Granular Locking Declaration added by Aditya

Line 2140: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

2136: OPEN cr_bsc_dim_obj_id;
2137: FETCH cr_bsc_dim_obj_id INTO l_bsc_dimension_rec.Bsc_Level_Id, l_Dim_Obj_Source;
2138: CLOSE cr_bsc_dim_obj_id;
2139: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
2140: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2141: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
2142: FND_MSG_PUB.ADD;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;

Line 2141: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

2137: FETCH cr_bsc_dim_obj_id INTO l_bsc_dimension_rec.Bsc_Level_Id, l_Dim_Obj_Source;
2138: CLOSE cr_bsc_dim_obj_id;
2139: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
2140: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2141: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
2142: FND_MSG_PUB.ADD;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists

Line 2335: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');

2331: INTO l_dim_obj_name
2332: FROM BSC_BIS_DIM_OBJS_VL
2333: WHERE SHORT_NAME = l_unassign;
2334:
2335: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
2336: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_name);
2337: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_obj_name);
2338: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
2339: FND_MSG_PUB.ADD;

Line 2336: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_name);

2332: FROM BSC_BIS_DIM_OBJS_VL
2333: WHERE SHORT_NAME = l_unassign;
2334:
2335: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
2336: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_name);
2337: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_obj_name);
2338: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;

Line 2337: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_obj_name);

2333: WHERE SHORT_NAME = l_unassign;
2334:
2335: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
2336: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_name);
2337: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_obj_name);
2338: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;
2341: END IF;

Line 2338: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);

2334:
2335: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
2336: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_name);
2337: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_obj_name);
2338: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;
2341: END IF;
2342: END LOOP;

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

2401:
2402: FND_MSG_PUB.Initialize;
2403: x_return_status := FND_API.G_RET_STS_SUCCESS;
2404: IF (p_dim_short_name IS NULL) THEN
2405: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2406: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2407: FND_MSG_PUB.ADD;
2408: RAISE FND_API.G_EXC_ERROR;
2409: END IF;

Line 2406: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

2402: FND_MSG_PUB.Initialize;
2403: x_return_status := FND_API.G_RET_STS_SUCCESS;
2404: IF (p_dim_short_name IS NULL) THEN
2405: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2406: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2407: FND_MSG_PUB.ADD;
2408: RAISE FND_API.G_EXC_ERROR;
2409: END IF;
2410: IF (p_unassign_dim_obj_names IS NOT NULL) THEN

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

2576: l_application_id := p_application_id;
2577: END IF;
2578: l_dim_short_name := p_dim_short_name;
2579: IF (l_dim_short_name IS NULL) THEN
2580: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2581: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2582: FND_MSG_PUB.ADD;
2583: RAISE FND_API.G_EXC_ERROR;
2584: END IF;

Line 2581: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

2577: END IF;
2578: l_dim_short_name := p_dim_short_name;
2579: IF (l_dim_short_name IS NULL) THEN
2580: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2581: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2582: FND_MSG_PUB.ADD;
2583: RAISE FND_API.G_EXC_ERROR;
2584: END IF;
2585:

Line 2610: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

2606: , l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
2607: IF (cr_bsc_dim_id%ROWCOUNT = 0) THEN
2608: IF (l_bis_create) THEN
2609: l_bis_create := FALSE;
2610: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2611: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: ELSE

Line 2611: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);

2607: IF (cr_bsc_dim_id%ROWCOUNT = 0) THEN
2608: IF (l_bis_create) THEN
2609: l_bis_create := FALSE;
2610: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2611: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: ELSE
2615: l_bsc_create := TRUE; -- this flag indicates that the entries are not in the PMF metadata, so create it

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

2616: END IF;
2617: END IF;
2618: CLOSE cr_bsc_dim_id;
2619: IF (l_dim_short_name IS NULL) THEN
2620: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2621: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2622: FND_MSG_PUB.ADD;
2623: RAISE FND_API.G_EXC_ERROR;
2624: END IF;

Line 2621: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

2617: END IF;
2618: CLOSE cr_bsc_dim_id;
2619: IF (l_dim_short_name IS NULL) THEN
2620: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2621: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2622: FND_MSG_PUB.ADD;
2623: RAISE FND_API.G_EXC_ERROR;
2624: END IF;
2625: --check uniqueness of display name

Line 2668: FND_MESSAGE.SET_NAME('BIS', x_msg_data);

2664: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2665: IF (l_error_tbl.COUNT > 0) THEN
2666: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
2667: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
2668: FND_MESSAGE.SET_NAME('BIS', x_msg_data);
2669: FND_MSG_PUB.ADD;
2670: x_msg_data := NULL;
2671: END IF;
2672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2701: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

2697: IF (l_error_tbl.COUNT > 0) THEN
2698: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
2699:
2700: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
2701: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
2702: FND_MSG_PUB.ADD;
2703: x_msg_data := NULL;
2704: END IF;
2705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2880:
2881: FND_MSG_PUB.Initialize;
2882: x_return_status := FND_API.G_RET_STS_SUCCESS;
2883: IF (p_dim_short_name IS NULL) THEN
2884: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2885: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2886: FND_MSG_PUB.ADD;
2887: RAISE FND_API.G_EXC_ERROR;
2888: END IF;

Line 2885: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

2881: FND_MSG_PUB.Initialize;
2882: x_return_status := FND_API.G_RET_STS_SUCCESS;
2883: IF (p_dim_short_name IS NULL) THEN
2884: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2885: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
2886: FND_MSG_PUB.ADD;
2887: RAISE FND_API.G_EXC_ERROR;
2888: END IF;
2889: IF (cr_bsc_dim_id%ISOPEN) THEN

Line 2897: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

2893: FETCH cr_bsc_dim_id
2894: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
2895: CLOSE cr_bsc_dim_id;
2896: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
2897: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2898: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
2899: FND_MSG_PUB.ADD;
2900: RAISE FND_API.G_EXC_ERROR;
2901: END IF;

Line 2898: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);

2894: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
2895: CLOSE cr_bsc_dim_id;
2896: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
2897: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2898: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
2899: FND_MSG_PUB.ADD;
2900: RAISE FND_API.G_EXC_ERROR;
2901: END IF;
2902:

Line 2929: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

2925: FROM BSC_SYS_DIM_GROUPS_VL
2926: WHERE UPPER(short_name) <> UPPER(p_dim_short_name)
2927: AND UPPER(name) = UPPER(p_display_name); -- already trimmed from JAVA
2928: IF (l_count <> 0) THEN
2929: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2930: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);
2931: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_ERROR;

Line 2930: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);

2926: WHERE UPPER(short_name) <> UPPER(p_dim_short_name)
2927: AND UPPER(name) = UPPER(p_display_name); -- already trimmed from JAVA
2928: IF (l_count <> 0) THEN
2929: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2930: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);
2931: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;

Line 2931: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);

2927: AND UPPER(name) = UPPER(p_display_name); -- already trimmed from JAVA
2928: IF (l_count <> 0) THEN
2929: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2930: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);
2931: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;
2935:

Line 2941: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

2937: FROM BIS_DIMENSIONS_VL
2938: WHERE UPPER(short_name) <> UPPER(p_dim_short_name)
2939: AND UPPER(name) = UPPER(p_display_name);
2940: IF (l_count <> 0) THEN
2941: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2942: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);
2943: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
2944: FND_MSG_PUB.ADD;
2945: RAISE FND_API.G_EXC_ERROR;

Line 2942: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);

2938: WHERE UPPER(short_name) <> UPPER(p_dim_short_name)
2939: AND UPPER(name) = UPPER(p_display_name);
2940: IF (l_count <> 0) THEN
2941: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2942: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);
2943: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
2944: FND_MSG_PUB.ADD;
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;

Line 2943: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);

2939: AND UPPER(name) = UPPER(p_display_name);
2940: IF (l_count <> 0) THEN
2941: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
2942: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'), TRUE);
2943: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_display_name);
2944: FND_MSG_PUB.ADD;
2945: RAISE FND_API.G_EXC_ERROR;
2946: END IF;
2947:

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

3153:
3154: FND_MSG_PUB.Initialize;
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156: IF (p_dim_short_name IS NULL) THEN
3157: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3158: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_ERROR;
3161: END IF;

Line 3158: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

3154: FND_MSG_PUB.Initialize;
3155: x_return_status := FND_API.G_RET_STS_SUCCESS;
3156: IF (p_dim_short_name IS NULL) THEN
3157: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3158: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
3159: FND_MSG_PUB.ADD;
3160: RAISE FND_API.G_EXC_ERROR;
3161: END IF;
3162:

Line 3173: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

3169: INTO l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
3170: CLOSE cr_bsc_dim_id;
3171:
3172: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
3173: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
3174: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
3175: FND_MSG_PUB.ADD;
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;

Line 3174: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);

3170: CLOSE cr_bsc_dim_id;
3171:
3172: IF (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
3173: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
3174: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
3175: FND_MSG_PUB.ADD;
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;
3178: FOR cd IN cr_bsc_dim LOOP

Line 3238: FND_MESSAGE.SET_NAME('BSC','BSC_IND_DIMOBJ_LIMIT');

3234: END LOOP;
3235:
3236: CLOSE cr_indicdimset_for_dimgrp;
3237: IF(l_is_kpi_affected) THEN
3238: FND_MESSAGE.SET_NAME('BSC','BSC_IND_DIMOBJ_LIMIT');
3239: FND_MESSAGE.SET_TOKEN('NAME_LIST',l_affected_kpis);
3240: FND_MSG_PUB.ADD;
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;

Line 3239: FND_MESSAGE.SET_TOKEN('NAME_LIST',l_affected_kpis);

3235:
3236: CLOSE cr_indicdimset_for_dimgrp;
3237: IF(l_is_kpi_affected) THEN
3238: FND_MESSAGE.SET_NAME('BSC','BSC_IND_DIMOBJ_LIMIT');
3239: FND_MESSAGE.SET_TOKEN('NAME_LIST',l_affected_kpis);
3240: FND_MSG_PUB.ADD;
3241: RAISE FND_API.G_EXC_ERROR;
3242: END IF;
3243:

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

3343:
3344: FND_MSG_PUB.Initialize;
3345: x_return_status := FND_API.G_RET_STS_SUCCESS;
3346: IF (p_dim_short_name IS NULL) THEN
3347: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3348: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;

Line 3348: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);

3344: FND_MSG_PUB.Initialize;
3345: x_return_status := FND_API.G_RET_STS_SUCCESS;
3346: IF (p_dim_short_name IS NULL) THEN
3347: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3348: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'), TRUE);
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;
3352: --UNASSIGNED group can't be deleted

Line 3354: FND_MESSAGE.SET_NAME('BSC','BSC_B_CAN_NOT_DELETE_GROUP');

3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;
3352: --UNASSIGNED group can't be deleted
3353: IF (p_dim_short_name = BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
3354: FND_MESSAGE.SET_NAME('BSC','BSC_B_CAN_NOT_DELETE_GROUP');
3355: FND_MSG_PUB.ADD;
3356: RAISE FND_API.G_EXC_ERROR;
3357: END IF;
3358: --The Dimension [dimension display name] cannot be deleted. If it is being used in a Measure, Report or Key Performance Indicator.

Line 3395: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIM_IN_MEASURE');

3391: SELECT COUNT(1) INTO l_count
3392: FROM BIS_INDICATOR_DIMENSIONS
3393: WHERE DIMENSION_ID = l_bis_dimension_rec.dimension_id;
3394: IF (l_count <> 0) THEN
3395: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIM_IN_MEASURE');
3396: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bis_dimension_rec.Dimension_Name);
3397: FND_MSG_PUB.ADD;
3398: RAISE FND_API.G_EXC_ERROR;
3399: END IF;

Line 3396: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bis_dimension_rec.Dimension_Name);

3392: FROM BIS_INDICATOR_DIMENSIONS
3393: WHERE DIMENSION_ID = l_bis_dimension_rec.dimension_id;
3394: IF (l_count <> 0) THEN
3395: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIM_IN_MEASURE');
3396: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bis_dimension_rec.Dimension_Name);
3397: FND_MSG_PUB.ADD;
3398: RAISE FND_API.G_EXC_ERROR;
3399: END IF;
3400: BIS_DIMENSION_PUB.Delete_Dimension

Line 3411: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

3407: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3408: IF (l_error_tbl.COUNT > 0) THEN
3409: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
3410: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
3411: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
3412: FND_MSG_PUB.ADD;
3413: x_msg_data := NULL;
3414: END IF;
3415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3443: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_RPTASSOC_ERROR');

3439: l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name := p_dim_short_name;
3440:
3441: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_name, BSC_UTILITY.c_DIMENSION);
3442: IF(l_regions IS NOT NULL) THEN
3443: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_RPTASSOC_ERROR');
3444: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);
3445: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;

Line 3444: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);

3440:
3441: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_name, BSC_UTILITY.c_DIMENSION);
3442: IF(l_regions IS NOT NULL) THEN
3443: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_RPTASSOC_ERROR');
3444: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);
3445: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;
3448: END IF;

Line 3445: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);

3441: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(p_dim_short_name, BSC_UTILITY.c_DIMENSION);
3442: IF(l_regions IS NOT NULL) THEN
3443: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_RPTASSOC_ERROR');
3444: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);
3445: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;
3448: END IF;
3449:

Line 3456: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIMENSIONS');

3452: SELECT COUNT(1) INTO l_count
3453: FROM BSC_KPI_DIM_GROUPS
3454: WHERE dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
3455: IF (l_count <> 0) THEN
3456: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIMENSIONS');
3457: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);
3458: FND_MSG_PUB.ADD;
3459: RAISE FND_API.G_EXC_ERROR;
3460: END IF;

Line 3457: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);

3453: FROM BSC_KPI_DIM_GROUPS
3454: WHERE dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
3455: IF (l_count <> 0) THEN
3456: FND_MESSAGE.SET_NAME('BSC','BSC_NOT_DELETE_DIMENSIONS');
3457: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);
3458: FND_MSG_PUB.ADD;
3459: RAISE FND_API.G_EXC_ERROR;
3460: END IF;
3461: BSC_BIS_LOCKS_PUB.Lock_Dim_Group

Line 3494: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');

3490: ELSE
3491: l_delete := TRUE;
3492: END IF;
3493: IF (l_delete_count = 0) THEN
3494: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
3495: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
3496: FND_MSG_PUB.ADD;
3497: RAISE FND_API.G_EXC_ERROR;
3498: END IF;

Line 3495: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);

3491: l_delete := TRUE;
3492: END IF;
3493: IF (l_delete_count = 0) THEN
3494: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
3495: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), TRUE);
3496: FND_MSG_PUB.ADD;
3497: RAISE FND_API.G_EXC_ERROR;
3498: END IF;
3499: IF (p_commit = FND_API.G_TRUE) THEN

Line 3910: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_COLOR_INVALID');

3906: END IF;
3907: END IF;
3908:
3909: IF (l_kpi_names IS NOT NULL) THEN
3910: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_COLOR_INVALID');
3911: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
3912: FND_MSG_PUB.ADD;
3913: RAISE FND_API.G_EXC_ERROR;
3914: END IF;

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

3907: END IF;
3908:
3909: IF (l_kpi_names IS NOT NULL) THEN
3910: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_COLOR_INVALID');
3911: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
3912: FND_MSG_PUB.ADD;
3913: RAISE FND_API.G_EXC_ERROR;
3914: END IF;
3915:

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

4082: END LOOP;
4083: END IF;
4084:
4085: IF ((l_Struct_Flag) AND (l_kpi_names IS NOT NULL)) THEN
4086: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
4087: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
4088: FND_MSG_PUB.ADD;
4089: RAISE FND_API.G_EXC_ERROR;
4090: END IF;

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

4083: END IF;
4084:
4085: IF ((l_Struct_Flag) AND (l_kpi_names IS NOT NULL)) THEN
4086: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
4087: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
4088: FND_MSG_PUB.ADD;
4089: RAISE FND_API.G_EXC_ERROR;
4090: END IF;
4091:

Line 4187: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');

4183: l_count_dim_objs:= l_count_dim_objs +1;
4184: END LOOP;
4185:
4186: IF(l_count_dim_objs > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim) THEN
4187: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4188: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4189: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4190: FND_MSG_PUB.ADD;
4191: RAISE FND_API.G_EXC_ERROR;

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

4184: END LOOP;
4185:
4186: IF(l_count_dim_objs > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim) THEN
4187: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4188: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4189: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4190: FND_MSG_PUB.ADD;
4191: RAISE FND_API.G_EXC_ERROR;
4192: END IF;

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

4185:
4186: IF(l_count_dim_objs > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim) THEN
4187: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4188: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4189: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4190: FND_MSG_PUB.ADD;
4191: RAISE FND_API.G_EXC_ERROR;
4192: END IF;
4193:

Line 4272: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');

4268: END LOOP;
4269:
4270: IF(( (dim_objs_array.COUNT)+l_plus_count-l_minus_count ) > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim ) THEN
4271:
4272: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4273: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4274: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4275: FND_MSG_PUB.ADD;
4276: RAISE FND_API.G_EXC_ERROR;

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

4269:
4270: IF(( (dim_objs_array.COUNT)+l_plus_count-l_minus_count ) > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim ) THEN
4271:
4272: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4273: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4274: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4275: FND_MSG_PUB.ADD;
4276: RAISE FND_API.G_EXC_ERROR;
4277: END IF;

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

4270: IF(( (dim_objs_array.COUNT)+l_plus_count-l_minus_count ) > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim ) THEN
4271:
4272: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4273: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4274: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4275: FND_MSG_PUB.ADD;
4276: RAISE FND_API.G_EXC_ERROR;
4277: END IF;
4278: END LOOP;

Line 4574: FND_MESSAGE.SET_NAME('BSC','BSC_DIM_DIMOBJ_MIXED_TYPE');

4570:
4571: END IF;
4572:
4573: IF (l_true) THEN
4574: FND_MESSAGE.SET_NAME('BSC','BSC_DIM_DIMOBJ_MIXED_TYPE');
4575: FND_MESSAGE.SET_TOKEN('DIMENSION', p_dim_name);
4576: FND_MESSAGE.SET_TOKEN('DIM_OBJECT', l_dim_obj_name);
4577: FND_MSG_PUB.ADD;
4578: ELSE

Line 4575: FND_MESSAGE.SET_TOKEN('DIMENSION', p_dim_name);

4571: END IF;
4572:
4573: IF (l_true) THEN
4574: FND_MESSAGE.SET_NAME('BSC','BSC_DIM_DIMOBJ_MIXED_TYPE');
4575: FND_MESSAGE.SET_TOKEN('DIMENSION', p_dim_name);
4576: FND_MESSAGE.SET_TOKEN('DIM_OBJECT', l_dim_obj_name);
4577: FND_MSG_PUB.ADD;
4578: ELSE
4579: SELECT distinct(NVL(source, 'BSC'))

Line 4576: FND_MESSAGE.SET_TOKEN('DIM_OBJECT', l_dim_obj_name);

4572:
4573: IF (l_true) THEN
4574: FND_MESSAGE.SET_NAME('BSC','BSC_DIM_DIMOBJ_MIXED_TYPE');
4575: FND_MESSAGE.SET_TOKEN('DIMENSION', p_dim_name);
4576: FND_MESSAGE.SET_TOKEN('DIM_OBJECT', l_dim_obj_name);
4577: FND_MSG_PUB.ADD;
4578: ELSE
4579: SELECT distinct(NVL(source, 'BSC'))
4580: INTO x_dim_type