DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_CRUD_PUB dependencies on FND_MESSAGE

Line 290: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');

286:
287: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
288:
289: IF (p_Param_Portlet_Region_Code IS NULL) THEN
290: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');
291: FND_MSG_PUB.ADD;
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294:

Line 355: FND_MESSAGE.SET_NAME('BSC','BSC_DIP_MEASURE_SNAME_IS_NULL');

351: END IF;
352:
353:
354: IF (x_Measure_Short_Name IS NULL) THEN
355: FND_MESSAGE.SET_NAME('BSC','BSC_DIP_MEASURE_SNAME_IS_NULL');
356: FND_MSG_PUB.ADD;
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359:

Line 534: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');

530: -- Validate Input Parameters.
531: -- check if the KPI is in production mode, if yes throw and exception
532:
533: IF (p_Param_Portlet_Region_Code IS NULL) THEN
534: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:

Line 559: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_REG_DIM_AK ');

555: , x_Time_Counter => x_Time_Counter
556: , x_Msg_Data => x_Msg_Data
557: );
558: IF (x_Msg_Data IS NOT NULL) THEN
559: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_REG_DIM_AK ');
560: FND_MESSAGE.SET_TOKEN('CODE', p_Param_Portlet_Region_Code);
561: FND_MSG_PUB.ADD;
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;

Line 560: FND_MESSAGE.SET_TOKEN('CODE', p_Param_Portlet_Region_Code);

556: , x_Msg_Data => x_Msg_Data
557: );
558: IF (x_Msg_Data IS NOT NULL) THEN
559: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_REG_DIM_AK ');
560: FND_MESSAGE.SET_TOKEN('CODE', p_Param_Portlet_Region_Code);
561: FND_MSG_PUB.ADD;
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:

Line 673: FND_MESSAGE.SET_NAME('BSC','BSC_ANA_OPT_NO_UPD_DEL');

669: );
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;

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 675: FND_MESSAGE.SET_TOKEN('KPI', l_Kpi_Id);

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;
679: END IF;

Line 676: FND_MESSAGE.SET_TOKEN('DATASET_ID', l_Dataset_Id);

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;
679: END IF;
680:

Line 861: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');

857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858:
859:
860: IF (p_Param_Portlet_Region_Code IS NULL) THEN
861: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');
862: FND_MSG_PUB.ADD;
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:

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

875: SELECT COUNT(1) INTO l_Count
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;

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

885: SELECT COUNT(1) INTO l_Count
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;

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

949: ,x_msg_data => x_msg_data
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;

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 955: FND_MESSAGE.SET_TOKEN('KPI', l_kpi_Id);

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;
959: END IF;

Line 956: FND_MESSAGE.SET_TOKEN('DATASET_ID', l_Dataset_Id);

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;
959: END IF;
960:

Line 1235: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');

1231: l_Dim_Id_Cnt := l_Dim_Id_Cnt + 1;
1232: END LOOP;
1233:
1234: IF l_Dim_Id_Cnt <> 1 THEN
1235: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
1236: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dimension_grp(l_counter), TRUE);
1237: FND_MSG_PUB.ADD;
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;

Line 1236: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dimension_grp(l_counter), TRUE);

1232: END LOOP;
1233:
1234: IF l_Dim_Id_Cnt <> 1 THEN
1235: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
1236: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dimension_grp(l_counter), TRUE);
1237: FND_MSG_PUB.ADD;
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1239: END IF;
1240:

Line 1253: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DIM_SET_ASSOC');

1249: CLOSE c_dim;
1250:
1251: -- if no dimension set, raise exception
1252: IF (l_counter = 1) THEN
1253: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DIM_SET_ASSOC');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256: END IF;
1257:

Line 1942: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DIM_OBJ_PARAM_PORTLET');

1938: CLOSE c_dim;
1939:
1940: -- if no dimension set, raise exception
1941: IF (l_counter = 1) THEN
1942: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DIM_OBJ_PARAM_PORTLET');
1943: FND_MSG_PUB.ADD;
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946:

Line 2153: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PERIODICITY_FOUND_DL');

2149: IF l_Time_Dim_Obj_sh = p_Dft_Dim_obj_sn THEN
2150: l_Dft_periodicity_id := l_periodicity_id;
2151: END IF;
2152: ELSE
2153: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PERIODICITY_FOUND_DL');
2154: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_Time_Dim_Obj_sh );
2155: FND_MSG_PUB.ADD;
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;

Line 2154: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_Time_Dim_Obj_sh );

2150: l_Dft_periodicity_id := l_periodicity_id;
2151: END IF;
2152: ELSE
2153: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PERIODICITY_FOUND_DL');
2154: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_Time_Dim_Obj_sh );
2155: FND_MSG_PUB.ADD;
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;
2158: --DBMS_OUTPUT.PUT_LINE(' l_periodicity_ids = '||l_periodicity_ids);

Line 4567: FND_MESSAGE.SET_NAME('BSC','BSC_DIP_ERR_GET_GROUP_ID');

4563: OPEN c_Get_Prop_Dim;
4564: FETCH c_Get_Prop_Dim INTO l_Total_Flag, l_Comparison_Flag, l_Where_Clause;
4565:
4566: IF(c_Get_Prop_Dim%NOTFOUND) THEN
4567: FND_MESSAGE.SET_NAME('BSC','BSC_DIP_ERR_GET_GROUP_ID');
4568: FND_MSG_PUB.ADD;
4569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4570: END IF;
4571:

Line 5004: FND_MESSAGE.SET_NAME('BSC','BSC_ENABLE_ADV_SUMMARIZATION');

5000: -- Check if AS_OF_DATE is enabled at the Paramter Portlet
5001: IF ((is_XTD_Enabled(p_Param_Portlet_Region_Code) = FND_API.G_TRUE) OR (l_Is_From_Report_Designer)) THEN
5002: -- Check if Advance Summarization Profile > 1, else throw and error.
5003: IF (BSC_UTILITY.Is_Adv_Summarization_Enabled = FND_API.G_FALSE) THEN
5004: FND_MESSAGE.SET_NAME('BSC','BSC_ENABLE_ADV_SUMMARIZATION');
5005: FND_MSG_PUB.ADD;
5006: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5007: END IF;
5008: END IF;

Line 6323: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');

6319: FROM BSC_SYS_DIM_GROUPS_VL
6320: WHERE SHORT_NAME = p_Dim_Short_Name;
6321:
6322: IF l_Count = 0 THEN
6323: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
6324: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', p_Dim_Short_Name, TRUE);
6325: FND_MSG_PUB.ADD;
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END IF;

Line 6324: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', p_Dim_Short_Name, TRUE);

6320: WHERE SHORT_NAME = p_Dim_Short_Name;
6321:
6322: IF l_Count = 0 THEN
6323: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
6324: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', p_Dim_Short_Name, TRUE);
6325: FND_MSG_PUB.ADD;
6326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6327: END IF;
6328:

Line 6803: FND_MESSAGE.SET_NAME('BIS',l_Return_Msg);

6799: , x_Msg_Data => l_Return_Msg
6800: );
6801: IF ((l_Return_Status IS NOT NULL) AND (l_Return_Status <> FND_API.G_RET_STS_SUCCESS)) THEN
6802: FND_MSG_PUB.Initialize;
6803: FND_MESSAGE.SET_NAME('BIS',l_Return_Msg);
6804: FND_MSG_PUB.ADD;
6805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6806: END IF;
6807:

Line 6816: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_DBIPAGE'); -- Need to use BSC_KPI_DEP_DBIPAGE

6812: l_Index_Count := l_Parent_Obj_Table.FIRST;
6813:
6814: LOOP
6815: IF l_Loop = 1 THEN
6816: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_DBIPAGE'); -- Need to use BSC_KPI_DEP_DBIPAGE
6817: l_Trigger_Warning := TRUE;
6818: ELSE
6819: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION'); -- Message here is correct BSC_KPI_DEP_KPI_REGION
6820: l_Trigger_Exception := TRUE;

Line 6819: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION'); -- Message here is correct BSC_KPI_DEP_KPI_REGION

6815: IF l_Loop = 1 THEN
6816: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_DBIPAGE'); -- Need to use BSC_KPI_DEP_DBIPAGE
6817: l_Trigger_Warning := TRUE;
6818: ELSE
6819: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION'); -- Message here is correct BSC_KPI_DEP_KPI_REGION
6820: l_Trigger_Exception := TRUE;
6821:
6822: END IF;
6823:

Line 6824: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_Parent_Obj_Table(l_Index_Count).Object_Name));

6820: l_Trigger_Exception := TRUE;
6821:
6822: END IF;
6823:
6824: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_Parent_Obj_Table(l_Index_Count).Object_Name));
6825: l_Dep_Message := '

  • '||FND_MESSAGE.GET || '
    • ';
    6826:
    6827:
    6828: IF (LENGTH(l_Message||l_Dep_Message) >= l_Msg_Max_Count_Size) THEN

    Line 6825: l_Dep_Message := '
  • '||FND_MESSAGE.GET || '
    • ';

    6821:
    6822: END IF;
    6823:
    6824: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_Parent_Obj_Table(l_Index_Count).Object_Name));
    6825: l_Dep_Message := '

  • '||FND_MESSAGE.GET || '
    • ';
    6826:
    6827:
    6828: IF (LENGTH(l_Message||l_Dep_Message) >= l_Msg_Max_Count_Size) THEN
    6829: l_Msg_Exceeds_Size := TRUE;

    Line 6851: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_SCORECARD'); -- Need to use BSC_KPI_DEP_SCORECARD

    6847: LOOP
    6848: FETCH c_Tab_List INTO l_Dep_Message;
    6849: EXIT WHEN c_Tab_List%NOTFOUND;
    6850:
    6851: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_SCORECARD'); -- Need to use BSC_KPI_DEP_SCORECARD
    6852: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6853: l_Dep_Message := FND_MESSAGE.GET;
    6854:
    6855: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';

    Line 6852: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);

    6848: FETCH c_Tab_List INTO l_Dep_Message;
    6849: EXIT WHEN c_Tab_List%NOTFOUND;
    6850:
    6851: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_SCORECARD'); -- Need to use BSC_KPI_DEP_SCORECARD
    6852: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6853: l_Dep_Message := FND_MESSAGE.GET;
    6854:
    6855: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';
    6856: END LOOP;

    Line 6853: l_Dep_Message := FND_MESSAGE.GET;

    6849: EXIT WHEN c_Tab_List%NOTFOUND;
    6850:
    6851: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_SCORECARD'); -- Need to use BSC_KPI_DEP_SCORECARD
    6852: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6853: l_Dep_Message := FND_MESSAGE.GET;
    6854:
    6855: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';
    6856: END LOOP;
    6857:

    Line 6879: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPIREPORT'); -- Need to use BSC_KPI_DEP_KPIREPORT

    6875: LOOP
    6876: FETCH c_Kpi_Report_List INTO l_Dep_Message;
    6877: EXIT WHEN c_Kpi_Report_List%NOTFOUND;
    6878:
    6879: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPIREPORT'); -- Need to use BSC_KPI_DEP_KPIREPORT
    6880: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6881: l_Dep_Message := FND_MESSAGE.GET;
    6882:
    6883: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';

    Line 6880: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);

    6876: FETCH c_Kpi_Report_List INTO l_Dep_Message;
    6877: EXIT WHEN c_Kpi_Report_List%NOTFOUND;
    6878:
    6879: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPIREPORT'); -- Need to use BSC_KPI_DEP_KPIREPORT
    6880: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6881: l_Dep_Message := FND_MESSAGE.GET;
    6882:
    6883: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';
    6884:

    Line 6881: l_Dep_Message := FND_MESSAGE.GET;

    6877: EXIT WHEN c_Kpi_Report_List%NOTFOUND;
    6878:
    6879: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPIREPORT'); -- Need to use BSC_KPI_DEP_KPIREPORT
    6880: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6881: l_Dep_Message := FND_MESSAGE.GET;
    6882:
    6883: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';
    6884:
    6885: END LOOP;

    Line 6908: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION'); -- Need to use BSC_KPI_DEP_PMVREPORT

    6904: LOOP
    6905: FETCH c_PMV_Report_List INTO l_Dep_Message;
    6906: EXIT WHEN c_PMV_Report_List%NOTFOUND;
    6907:
    6908: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION'); -- Need to use BSC_KPI_DEP_PMVREPORT
    6909: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6910: l_Dep_Message := FND_MESSAGE.GET;
    6911:
    6912: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';

    Line 6909: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);

    6905: FETCH c_PMV_Report_List INTO l_Dep_Message;
    6906: EXIT WHEN c_PMV_Report_List%NOTFOUND;
    6907:
    6908: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION'); -- Need to use BSC_KPI_DEP_PMVREPORT
    6909: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6910: l_Dep_Message := FND_MESSAGE.GET;
    6911:
    6912: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';
    6913:

    Line 6910: l_Dep_Message := FND_MESSAGE.GET;

    6906: EXIT WHEN c_PMV_Report_List%NOTFOUND;
    6907:
    6908: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION'); -- Need to use BSC_KPI_DEP_PMVREPORT
    6909: FND_MESSAGE.SET_TOKEN('DEP_OBJECT', l_Dep_Message);
    6910: l_Dep_Message := FND_MESSAGE.GET;
    6911:
    6912: l_Temp_Message := l_Temp_Message || '

  • '||l_Dep_Message || '
    • ';
    6913:
    6914: END LOOP;

    Line 6940: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DELETE_WARNING');

    6936: l_Kpi_Name := l_Measure_Short_Name;
    6937: END;
    6938:
    6939: IF (l_Trigger_Warning = TRUE AND l_Trigger_Exception = FALSE) THEN
    6940: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DELETE_WARNING');
    6941: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);
    6942: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);
    6943: FND_MSG_PUB.ADD;
    6944: FND_MSG_PUB.Count_And_Get

    Line 6941: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);

    6937: END;
    6938:
    6939: IF (l_Trigger_Warning = TRUE AND l_Trigger_Exception = FALSE) THEN
    6940: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DELETE_WARNING');
    6941: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);
    6942: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);
    6943: FND_MSG_PUB.ADD;
    6944: FND_MSG_PUB.Count_And_Get
    6945: ( p_encoded => FND_API.G_FALSE

    Line 6942: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);

    6938:
    6939: IF (l_Trigger_Warning = TRUE AND l_Trigger_Exception = FALSE) THEN
    6940: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DELETE_WARNING');
    6941: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);
    6942: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);
    6943: FND_MSG_PUB.ADD;
    6944: FND_MSG_PUB.Count_And_Get
    6945: ( p_encoded => FND_API.G_FALSE
    6946: , p_count => x_Msg_Count

    Line 6952: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_IN_USE');

    6948: );
    6949: END IF;
    6950:
    6951: IF (l_Trigger_Exception = TRUE ) THEN
    6952: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_IN_USE');
    6953: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);
    6954: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);
    6955: FND_MSG_PUB.ADD;
    6956: RAISE FND_API.G_EXC_ERROR;

    Line 6953: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);

    6949: END IF;
    6950:
    6951: IF (l_Trigger_Exception = TRUE ) THEN
    6952: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_IN_USE');
    6953: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);
    6954: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);
    6955: FND_MSG_PUB.ADD;
    6956: RAISE FND_API.G_EXC_ERROR;
    6957: END IF;

    Line 6954: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);

    6950:
    6951: IF (l_Trigger_Exception = TRUE ) THEN
    6952: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_IN_USE');
    6953: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);
    6954: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_Message);
    6955: FND_MSG_PUB.ADD;
    6956: RAISE FND_API.G_EXC_ERROR;
    6957: END IF;
    6958:

    Line 7030: FND_MESSAGE.SET_NAME('BSC','BSC_ERR_LOAD_DBI_CAL_METADATA');

    7026: -- call the DBI API to populate DBI Calendars into BSC_SYS_CALENDARS and BSC_SYS_PERIODICITIES.
    7027: BSC_DBI_CALENDAR.Load_Dbi_Cal_Metadata(l_Error_Msg);
    7028:
    7029: IF (l_Error_Msg IS NOT NULL) THEN
    7030: FND_MESSAGE.SET_NAME('BSC','BSC_ERR_LOAD_DBI_CAL_METADATA');
    7031: FND_MESSAGE.SET_TOKEN('ERRMSG', l_Error_Msg);
    7032: FND_MSG_PUB.ADD;
    7033: RAISE FND_API.G_EXC_ERROR;
    7034: END IF;

    Line 7031: FND_MESSAGE.SET_TOKEN('ERRMSG', l_Error_Msg);

    7027: BSC_DBI_CALENDAR.Load_Dbi_Cal_Metadata(l_Error_Msg);
    7028:
    7029: IF (l_Error_Msg IS NOT NULL) THEN
    7030: FND_MESSAGE.SET_NAME('BSC','BSC_ERR_LOAD_DBI_CAL_METADATA');
    7031: FND_MESSAGE.SET_TOKEN('ERRMSG', l_Error_Msg);
    7032: FND_MSG_PUB.ADD;
    7033: RAISE FND_API.G_EXC_ERROR;
    7034: END IF;
    7035:

    Line 7120: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');

    7116:
    7117: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
    7118:
    7119: IF (p_Param_Portlet_Region_Code IS NULL) THEN
    7120: FND_MESSAGE.SET_NAME('BSC','BSC_NO_PARAM_PORTLET');
    7121: FND_MSG_PUB.ADD;
    7122: RAISE FND_API.G_EXC_ERROR;
    7123: END IF;
    7124:

    Line 7129: FND_MESSAGE.SET_NAME('BSC','BSC_ENABLE_ADV_SUMMARIZATION');

    7125: -- Check if AS_OF_DATE is enabled at the Paramter Portlet
    7126: IF (is_XTD_Enabled(p_Param_Portlet_Region_Code) = FND_API.G_TRUE) THEN
    7127: -- Check if Advance Summarization Profile >= 0, else throw and error.
    7128: IF (BSC_UTILITY.Is_Adv_Summarization_Enabled = FND_API.G_FALSE) THEN
    7129: FND_MESSAGE.SET_NAME('BSC','BSC_ENABLE_ADV_SUMMARIZATION');
    7130: FND_MSG_PUB.ADD;
    7131: RAISE FND_API.G_EXC_ERROR;
    7132: END IF;
    7133: END IF;

    Line 7642: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_WARN');

    7638: l_cust_kpis := l_cust_kpis || ',' || l_cust_kpi_name;
    7639: END IF;
    7640: END LOOP;
    7641:
    7642: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_WARN');
    7643: FND_MESSAGE.SET_TOKEN('OBJECTIVE', l_objective_name);
    7644: FND_MESSAGE.SET_TOKEN('CUST_KPI_LIST',l_cust_kpis);
    7645: FND_MSG_PUB.ADD;
    7646:

    Line 7643: FND_MESSAGE.SET_TOKEN('OBJECTIVE', l_objective_name);

    7639: END IF;
    7640: END LOOP;
    7641:
    7642: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_WARN');
    7643: FND_MESSAGE.SET_TOKEN('OBJECTIVE', l_objective_name);
    7644: FND_MESSAGE.SET_TOKEN('CUST_KPI_LIST',l_cust_kpis);
    7645: FND_MSG_PUB.ADD;
    7646:
    7647: FND_MSG_PUB.Count_And_Get

    Line 7644: FND_MESSAGE.SET_TOKEN('CUST_KPI_LIST',l_cust_kpis);

    7640: END LOOP;
    7641:
    7642: FND_MESSAGE.SET_NAME('BSC','BSC_SCR_DELETE_WARN');
    7643: FND_MESSAGE.SET_TOKEN('OBJECTIVE', l_objective_name);
    7644: FND_MESSAGE.SET_TOKEN('CUST_KPI_LIST',l_cust_kpis);
    7645: FND_MSG_PUB.ADD;
    7646:
    7647: FND_MSG_PUB.Count_And_Get
    7648: ( p_encoded => FND_API.G_FALSE

    Line 7810: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');

    7806: l_Dim_Id_Cnt := l_Dim_Id_Cnt + 1;
    7807: END LOOP;
    7808:
    7809: IF l_Dim_Id_Cnt <> 1 THEN
    7810: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
    7811: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dimension_grp(l_counter), TRUE);
    7812: FND_MSG_PUB.ADD;
    7813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
    7814: END IF;

    Line 7811: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dimension_grp(l_counter), TRUE);

    7807: END LOOP;
    7808:
    7809: IF l_Dim_Id_Cnt <> 1 THEN
    7810: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
    7811: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dimension_grp(l_counter), TRUE);
    7812: FND_MSG_PUB.ADD;
    7813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
    7814: END IF;
    7815:

    Line 8431: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');

    8427:
    8428: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
    8429:
    8430: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
    8431: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
    8432: FND_MSG_PUB.ADD;
    8433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
    8434: END IF;
    8435:

    Line 8635: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');

    8631:
    8632: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
    8633:
    8634: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
    8635: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
    8636: FND_MSG_PUB.ADD;
    8637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
    8638: END IF;
    8639:

    Line 9690: FND_MESSAGE.SET_NAME('BSC','BSC_TIME_PERIODICITY_NULL');

    9686:
    9687: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
    9688:
    9689: IF (p_Time_Short_Name IS NULL) THEN
    9690: FND_MESSAGE.SET_NAME('BSC','BSC_TIME_PERIODICITY_NULL');
    9691: FND_MSG_PUB.ADD;
    9692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
    9693: END IF;
    9694:

    Line 11021: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');

    11017: x_return_status := FND_API.G_RET_STS_SUCCESS;
    11018:
    11019: l_Kpi_Id := BSC_BIS_KPI_CRUD_PUB.Get_Kpi_Id(p_Region_Code);
    11020: IF (l_Kpi_Id = BSC_BIS_KPI_CRUD_PUB.C_INVALID_ENTITY) THEN
    11021: FND_MESSAGE.SET_NAME('BSC','BSC_SETUP_REPORT_DEF');
    11022: FND_MSG_PUB.ADD;
    11023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
    11024: END IF;
    11025: