DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_APPS

Line 674: FND_MESSAGE.SET_TOKEN('ACTION', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','UPDATE'));

670:
671: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
672: -- debug
673: FND_MESSAGE.SET_NAME('BSC','BSC_ANA_OPT_NO_UPD_DEL');
674: FND_MESSAGE.SET_TOKEN('ACTION', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','UPDATE'));
675: FND_MESSAGE.SET_TOKEN('KPI', l_Kpi_Id);
676: FND_MESSAGE.SET_TOKEN('DATASET_ID', l_Dataset_Id);
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 880: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','EDW_MEASURE'));

876: FROM BSC_SYS_DATASETS_B
877: WHERE DATASET_ID = l_Dataset_Id;
878: IF l_count = 0 THEN
879: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
880: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','EDW_MEASURE'));
881: FND_MSG_PUB.ADD;
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884:

Line 890: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','KPI'));

886: FROM BSC_KPIS_B
887: WHERE INDICATOR = l_Kpi_Id;
888: IF l_count = 0 THEN
889: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
890: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','KPI'));
891: FND_MSG_PUB.ADD;
892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894:

Line 954: FND_MESSAGE.SET_TOKEN('ACTION', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','UPDATE'));

950: );
951:
952: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
953: FND_MESSAGE.SET_NAME('BSC','BSC_ANA_OPT_NO_UPD_DEL');
954: FND_MESSAGE.SET_TOKEN('ACTION', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON','UPDATE'));
955: FND_MESSAGE.SET_TOKEN('KPI', l_kpi_Id);
956: FND_MESSAGE.SET_TOKEN('DATASET_ID', l_Dataset_Id);
957: FND_MSG_PUB.ADD;
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2320: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_GROUP_ID');

2316: x_msg_data := NULL;
2317:
2318: FOR l_index in 1..p_non_time_counter LOOP
2319:
2320: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_GROUP_ID');
2321: SELECT d.total_flag, d.comparison_flag, d.where_clause
2322: INTO l_total_flag, l_comparison_flag, l_where_clause
2323: FROM bsc_sys_dim_groups_tl a,
2324: bis_dimensions b,

Line 2337: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_DIM_REL');

2333: AND e.short_name = p_non_time_dimension_objects(l_index)
2334: AND e.dim_level_id = d.dim_level_id;
2335:
2336:
2337: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_GET_DIM_REL');
2338: SELECT d.dim_group_id, d.dim_level_id
2339: INTO l_dim_group_id, l_dim_level_id
2340: FROM bsc_sys_dim_groups_tl a,
2341: bsc_sys_dim_levels_by_group d,

Line 2349: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_UPDATE_DIM_REL');

2345: AND a.language = userenv('LANG')
2346: AND e.short_name = p_non_time_dimension_objects(l_index)
2347: AND e.dim_level_id = d.dim_level_id;
2348:
2349: x_Msg_Data := BSC_APPS.Get_Message('BSC_DIP_ERR_UPDATE_DIM_REL');
2350: UPDATE bsc_sys_dim_levels_by_group
2351: SET total_flag = l_total_flag,
2352: comparison_flag = l_comparison_flag,
2353: where_clause = l_where_clause

Line 3873: l_Lookup_Meaning := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'COMPARE_TO'); -- creates Prior

3869: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_COMPARISON_APPEND_STRING
3870: );
3871: l_Compare_Column := l_Attribute_Code;
3872:
3873: l_Lookup_Meaning := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'COMPARE_TO'); -- creates Prior
3874: -- No lookup for Compare To
3875: Create_Sim_Generic_Region_Item(
3876: p_commit => p_Commit
3877: , p_Region_Code => p_Region_Code

Line 3929: l_Lookup_Meaning := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'CHANGE');

3925: , p_Measure_Short_Name => p_Measure_Short_Name
3926: , p_Append_String => BSC_BIS_KPI_CRUD_PUB.C_CHANGE_APPEND_STRING
3927: );
3928:
3929: l_Lookup_Meaning := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'CHANGE');
3930: Create_Sim_Generic_Region_Item(
3931: p_commit => p_Commit
3932: , p_Region_Code => p_Region_Code
3933: , p_Region_Application_Id => p_Region_Application_Id

Line 4258: l_Lookup_Value := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'COMPARE_TO');

4254: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4255: );
4256:
4257: -- currently we do not have lookup for "Compare To"
4258: l_Lookup_Value := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'COMPARE_TO');
4259:
4260: Update_Sim_Generic_Region_Item(
4261: p_commit => p_Commit
4262: , p_Region_Code => p_Region_Code

Line 4313: l_Lookup_Value := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'CHANGE');

4309: , p_Attribute_Application_Id => BSC_BIS_KPI_CRUD_PUB.C_BSC_APPLICATION_ID
4310: );
4311:
4312:
4313: l_Lookup_Value := BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BACKEND', 'CHANGE');
4314:
4315: -- Added for Bug#3919666
4316: l_Format_Type := BSC_BIS_KPI_CRUD_PUB.Get_Change_Disp_Type_By_Mask(p_Format_Id);
4317:

Line 4437: x_msg_data := BSC_APPS.GET_MESSAGE( 'BSC_KPI_ETE_MEASURE_GROUP_ERR');

4433: RETURN x_measure_group_id;
4434:
4435: WHEN OTHERS THEN
4436: x_return_status := FND_API.G_RET_STS_ERROR;
4437: x_msg_data := BSC_APPS.GET_MESSAGE( 'BSC_KPI_ETE_MEASURE_GROUP_ERR');
4438:
4439: RETURN BSC_BIS_KPI_CRUD_PUB.c_measure_group_id_error;
4440:
4441:

Line 9703: x_Msg_Data := BSC_APPS.Get_Message('BSC_PER_CAL_NOT_EXIST');

9699:
9700: EXCEPTION
9701: WHEN NO_DATA_FOUND THEN
9702: IF(x_Msg_Data IS NULL) THEN
9703: x_Msg_Data := BSC_APPS.Get_Message('BSC_PER_CAL_NOT_EXIST');
9704: END IF;
9705: x_return_status := FND_API.G_RET_STS_ERROR;
9706: WHEN OTHERS THEN
9707: IF (x_msg_data IS NULL) THEN