326: if (l_cursor%notfound) then
327: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' Deleted by other user ');
328: close l_cursor;
329: FND_MSG_PUB.Initialize;
330: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE'); -- ADRAO changed Measage
331: l_meaning := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'EDW_MEASURE'); -- added by ADRAO
332: FND_MESSAGE.SET_TOKEN('TYPE', l_meaning, TRUE);
333: FND_MSG_PUB.ADD;
334: x_return_status := FND_API.G_RET_STS_ERROR;
328: close l_cursor;
329: FND_MSG_PUB.Initialize;
330: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE'); -- ADRAO changed Measage
331: l_meaning := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'EDW_MEASURE'); -- added by ADRAO
332: FND_MESSAGE.SET_TOKEN('TYPE', l_meaning, TRUE);
333: FND_MSG_PUB.ADD;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
336: ,p_data => x_msg_data);
339: if not p_time_stamp is null then
340: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
341: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' updated by other user ');
342: FND_MSG_PUB.Initialize;
343: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
344: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));
345: FND_MSG_PUB.ADD;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
340: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
341: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' updated by other user ');
342: FND_MSG_PUB.Initialize;
343: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
344: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));
345: FND_MSG_PUB.ADD;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
348: ,p_data => x_msg_data);
408: ROLLBACK TO BSCLockDataSetPVT;
409: if (SQLCODE = -00054) then
410: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' locked by other user ');
411: FND_MSG_PUB.Initialize;
412: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');
413: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));
414: FND_MSG_PUB.ADD;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
409: if (SQLCODE = -00054) then
410: --dbms_output.put_line(' p_dataset_id = ' || p_dataset_id || ' locked by other user ');
411: FND_MSG_PUB.Initialize;
412: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');
413: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));
414: FND_MSG_PUB.ADD;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
417: ,p_data => x_msg_data);
455: if (l_cursor%notfound) then
456: close l_cursor;
457: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' deleted by other user ');
458: FND_MSG_PUB.Initialize;
459: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_MEASURE');
460: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, nvl(get_Datasource_Name(p_measure_id),p_measure_id)));
461: FND_MSG_PUB.ADD;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
456: close l_cursor;
457: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' deleted by other user ');
458: FND_MSG_PUB.Initialize;
459: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_MEASURE');
460: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, nvl(get_Datasource_Name(p_measure_id),p_measure_id)));
461: FND_MSG_PUB.ADD;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
464: ,p_data => x_msg_data);
468: if not p_time_stamp is null then
469: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
470: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' updated by other user ');
471: FND_MSG_PUB.Initialize;
472: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
473: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name,get_Datasource_Name(p_measure_id)));
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
469: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
470: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' updated by other user ');
471: FND_MSG_PUB.Initialize;
472: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');
473: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name,get_Datasource_Name(p_measure_id)));
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
477: ,p_data => x_msg_data);
498: ROLLBACK TO BSCLockDataSrcPVT;
499: if (SQLCODE = -00054) then
500: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' locked by other user ');
501: FND_MSG_PUB.Initialize;
502: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');
503: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, get_Datasource_Name(p_measure_id)));
504: FND_MSG_PUB.ADD;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
499: if (SQLCODE = -00054) then
500: --dbms_output.put_line(' p_measure_id = ' || p_measure_id || ' locked by other user ');
501: FND_MSG_PUB.Initialize;
502: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');
503: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, get_Datasource_Name(p_measure_id)));
504: FND_MSG_PUB.ADD;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
507: ,p_data => x_msg_data);
951: if (l_cursor%notfound) then
952: close l_cursor;
953: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' Deleted by other user ');
954: FND_MSG_PUB.Initialize;
955: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_LEVEL');
956: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', nvl(get_Dim_Level_Name(p_dim_level_id),p_dim_level_id));
957: FND_MSG_PUB.ADD;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
952: close l_cursor;
953: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' Deleted by other user ');
954: FND_MSG_PUB.Initialize;
955: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_LEVEL');
956: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', nvl(get_Dim_Level_Name(p_dim_level_id),p_dim_level_id));
957: FND_MSG_PUB.ADD;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
960: ,p_data => x_msg_data);
964: if not p_time_stamp is null then
965: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
966: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' updated by other user ');
967: FND_MSG_PUB.Initialize;
968: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_LEVEL');
969: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));
970: FND_MSG_PUB.ADD;
971: x_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
965: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
966: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' updated by other user ');
967: FND_MSG_PUB.Initialize;
968: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_LEVEL');
969: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));
970: FND_MSG_PUB.ADD;
971: x_return_status := FND_API.G_RET_STS_ERROR;
972: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
973: ,p_data => x_msg_data);
994: ROLLBACK TO BSCLockDimObjPVT;
995: if (SQLCODE = -00054) then
996: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' locked by other user ');
997: FND_MSG_PUB.Initialize;
998: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_LEVEL');
999: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));
1000: FND_MSG_PUB.ADD;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
995: if (SQLCODE = -00054) then
996: --dbms_output.put_line('Dimension Level Id = ' || p_dim_level_id || ' locked by other user ');
997: FND_MSG_PUB.Initialize;
998: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_LEVEL');
999: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));
1000: FND_MSG_PUB.ADD;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1003: ,p_data => x_msg_data);
1047: if (l_cursor%notfound) then
1048: close l_cursor;
1049: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' Deleted by other user ');
1050: FND_MSG_PUB.Initialize;
1051: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_GROUP');
1052: FND_MESSAGE.SET_TOKEN('DIM_GROUP', nvl(get_Dim_Group_Name(p_dim_group_id),p_dim_group_id));
1053: FND_MSG_PUB.ADD;
1054: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1055: ,p_data => x_msg_data);
1048: close l_cursor;
1049: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' Deleted by other user ');
1050: FND_MSG_PUB.Initialize;
1051: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_GROUP');
1052: FND_MESSAGE.SET_TOKEN('DIM_GROUP', nvl(get_Dim_Group_Name(p_dim_group_id),p_dim_group_id));
1053: FND_MSG_PUB.ADD;
1054: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1055: ,p_data => x_msg_data);
1056: RAISE FND_API.G_EXC_ERROR;
1058: if not p_time_stamp is null then
1059: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1060: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' updated by other user ');
1061: FND_MSG_PUB.Initialize;
1062: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_GROUP');
1063: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));
1064: FND_MSG_PUB.ADD;
1065: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1066: ,p_data => x_msg_data);
1059: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1060: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' updated by other user ');
1061: FND_MSG_PUB.Initialize;
1062: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_GROUP');
1063: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));
1064: FND_MSG_PUB.ADD;
1065: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1066: ,p_data => x_msg_data);
1067: RAISE FND_API.G_EXC_ERROR;
1086: ROLLBACK TO BSCLockDimPVT;
1087: if (SQLCODE = -00054) then
1088: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' locked by other user ');
1089: FND_MSG_PUB.Initialize;
1090: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_GROUP');
1091: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));
1092: FND_MSG_PUB.ADD;
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1087: if (SQLCODE = -00054) then
1088: --dbms_output.put_line('Dimension Group Id = ' || p_dim_group_id || ' locked by other user ');
1089: FND_MSG_PUB.Initialize;
1090: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_GROUP');
1091: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));
1092: FND_MSG_PUB.ADD;
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1095: ,p_data => x_msg_data);
1141: if (l_cursor%notfound) then
1142: close l_cursor;
1143: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' Deleted by other user ');
1144: FND_MSG_PUB.Initialize;
1145: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_SET');
1146: FND_MESSAGE.SET_TOKEN('DIM_SET', nvl(get_Dim_Set_Name(p_kpi_Id, p_dim_set_id), p_dim_set_id )); -- Fixed Bug#3047483
1147: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id)); -- Fixed Bug#3047483
1148: FND_MSG_PUB.ADD;
1149: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1142: close l_cursor;
1143: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' Deleted by other user ');
1144: FND_MSG_PUB.Initialize;
1145: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_SET');
1146: FND_MESSAGE.SET_TOKEN('DIM_SET', nvl(get_Dim_Set_Name(p_kpi_Id, p_dim_set_id), p_dim_set_id )); -- Fixed Bug#3047483
1147: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id)); -- Fixed Bug#3047483
1148: FND_MSG_PUB.ADD;
1149: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1143: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' Deleted by other user ');
1144: FND_MSG_PUB.Initialize;
1145: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_SET');
1146: FND_MESSAGE.SET_TOKEN('DIM_SET', nvl(get_Dim_Set_Name(p_kpi_Id, p_dim_set_id), p_dim_set_id )); -- Fixed Bug#3047483
1147: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id)); -- Fixed Bug#3047483
1148: FND_MSG_PUB.ADD;
1149: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1151: RAISE FND_API.G_EXC_ERROR;
1153: if not p_time_stamp is null then
1154: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1155: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' updated by other user ');
1156: FND_MSG_PUB.Initialize;
1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');
1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483
1159: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id)); -- Fixed Bug#3047483
1160: FND_MSG_PUB.ADD;
1161: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1154: if p_time_stamp <> TO_CHAR(l_last_update_date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) then
1155: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' updated by other user ');
1156: FND_MSG_PUB.Initialize;
1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');
1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483
1159: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id)); -- Fixed Bug#3047483
1160: FND_MSG_PUB.ADD;
1161: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1162: ,p_data => x_msg_data);
1155: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' updated by other user ');
1156: FND_MSG_PUB.Initialize;
1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');
1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483
1159: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id)); -- Fixed Bug#3047483
1160: FND_MSG_PUB.ADD;
1161: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1162: ,p_data => x_msg_data);
1163: RAISE FND_API.G_EXC_ERROR;
1182: ROLLBACK TO BSCLockDimSetPVT;
1183: if (SQLCODE = -00054) then
1184: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' locked by other user ');
1185: FND_MSG_PUB.Initialize;
1186: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_SET');
1187: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_dim_set_id, p_kpi_Id));
1188: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1189: FND_MSG_PUB.ADD;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1183: if (SQLCODE = -00054) then
1184: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' locked by other user ');
1185: FND_MSG_PUB.Initialize;
1186: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_SET');
1187: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_dim_set_id, p_kpi_Id));
1188: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1189: FND_MSG_PUB.ADD;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1184: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Dimension Set Id = ' || p_dim_set_id || ' locked by other user ');
1185: FND_MSG_PUB.Initialize;
1186: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_SET');
1187: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_dim_set_id, p_kpi_Id));
1188: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1189: FND_MSG_PUB.ADD;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1192: ,p_data => x_msg_data);
1236: if (l_cursor%notfound) then
1237: close l_cursor;
1238: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Deleted by other user ');
1239: FND_MSG_PUB.Initialize;
1240: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
1241: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id ));
1242: FND_MSG_PUB.ADD;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1244: ,p_data => x_msg_data);
1237: close l_cursor;
1238: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' Deleted by other user ');
1239: FND_MSG_PUB.Initialize;
1240: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
1241: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id ));
1242: FND_MSG_PUB.ADD;
1243: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1244: ,p_data => x_msg_data);
1245: RAISE FND_API.G_EXC_ERROR;
1250: l_last_update_date := get_time_stamp_kpi( p_kpi_Id);
1251: if p_time_stamp <> l_last_update_date then
1252: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
1253: FND_MSG_PUB.Initialize;
1254: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_KPI_1');
1255: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1256: FND_MSG_PUB.ADD;
1257: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1258: ,p_data => x_msg_data);
1251: if p_time_stamp <> l_last_update_date then
1252: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
1253: FND_MSG_PUB.Initialize;
1254: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_KPI_1');
1255: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1256: FND_MSG_PUB.ADD;
1257: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1258: ,p_data => x_msg_data);
1259: RAISE FND_API.G_EXC_ERROR;
1293: ROLLBACK TO BSCLockKpiPVT;
1294: if (SQLCODE = -00054) then
1295: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' locked by other user ');
1296: FND_MSG_PUB.Initialize;
1297: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_KPI_1');
1298: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1299: FND_MSG_PUB.ADD;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1294: if (SQLCODE = -00054) then
1295: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' locked by other user ');
1296: FND_MSG_PUB.Initialize;
1297: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_KPI_1');
1298: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));
1299: FND_MSG_PUB.ADD;
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1302: ,p_data => x_msg_data);
2603:
2604: IF(l_cursor%NOTFOUND) THEN
2605: CLOSE l_cursor;
2606: FND_MSG_PUB.Initialize;
2607: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2608: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_IVIEWER', 'SCORECARD'), TRUE);
2609: FND_MSG_PUB.ADD;
2610: RAISE FND_API.G_EXC_ERROR;
2611: END IF;
2604: IF(l_cursor%NOTFOUND) THEN
2605: CLOSE l_cursor;
2606: FND_MSG_PUB.Initialize;
2607: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2608: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_IVIEWER', 'SCORECARD'), TRUE);
2609: FND_MSG_PUB.ADD;
2610: RAISE FND_API.G_EXC_ERROR;
2611: END IF;
2612:
2616: );
2617:
2618: IF (p_time_stamp <> l_last_update_date) THEN
2619: FND_MSG_PUB.Initialize;
2620: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_SCORECARD');
2621: FND_MSG_PUB.ADD;
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624: END IF;
2657: CLOSE l_cursor;
2658: END IF;
2659: ROLLBACK TO bsclocktabpvt;
2660: IF (SQLCODE = -00054) THEN
2661: FND_MESSAGE.SET_NAME('BSC','BSC_MUSERS_LOCKED_TAB');
2662: FND_MSG_PUB.ADD;
2663: x_return_status := FND_API.G_RET_STS_ERROR;
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2717: IF (l_cursor%notfound) THEN
2718: CLOSE l_cursor;
2719: --DBMS_OUTPUT.PUT_LINE('Kpi = ' || p_kpi_id || ' Deleted by other user ');
2720: FND_MSG_PUB.Initialize;
2721: --FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
2722: FND_MESSAGE.SET_NAME('BSC','The current tab view has been deleted by another user');
2723: FND_MSG_PUB.ADD;
2724: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'
2725: ,p_count => x_msg_count
2718: CLOSE l_cursor;
2719: --DBMS_OUTPUT.PUT_LINE('Kpi = ' || p_kpi_id || ' Deleted by other user ');
2720: FND_MSG_PUB.Initialize;
2721: --FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');
2722: FND_MESSAGE.SET_NAME('BSC','The current tab view has been deleted by another user');
2723: FND_MSG_PUB.ADD;
2724: FND_MSG_PUB.Count_And_Get(p_encoded => 'F'
2725: ,p_count => x_msg_count
2726: ,p_data => x_msg_data);
2735: );
2736: IF p_time_stamp <> l_last_update_date THEN
2737: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
2738: FND_MSG_PUB.Initialize;
2739: FND_MESSAGE.SET_NAME('BSC','The Current view has been modified by another user');
2740: --FND_MESSAGE.SET_TOKEN('KPI', get_TabView_Name(p_tab_id,p_tab_view_id);
2741: FND_MSG_PUB.ADD;
2742: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2743: ,p_count => x_msg_count
2736: IF p_time_stamp <> l_last_update_date THEN
2737: --dbms_output.put_line('Kpi = ' || p_kpi_id || ' updated by other user ');
2738: FND_MSG_PUB.Initialize;
2739: FND_MESSAGE.SET_NAME('BSC','The Current view has been modified by another user');
2740: --FND_MESSAGE.SET_TOKEN('KPI', get_TabView_Name(p_tab_id,p_tab_view_id);
2741: FND_MSG_PUB.ADD;
2742: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
2743: ,p_count => x_msg_count
2744: ,p_data => x_msg_data);
2801: FETCH l_Cursor INTO l_Object_Id, l_Last_Update_Date;
2802:
2803: IF (l_Cursor%NOTFOUND) THEN
2804: CLOSE l_Cursor;
2805: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2806: l_Meaning := Bsc_Apps.Get_Lookup_Value('BSC_UI_COMMON', 'CALENDAR');
2807: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);
2808: FND_MSG_PUB.ADD;
2809: RAISE FND_API.G_EXC_ERROR;
2803: IF (l_Cursor%NOTFOUND) THEN
2804: CLOSE l_Cursor;
2805: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2806: l_Meaning := Bsc_Apps.Get_Lookup_Value('BSC_UI_COMMON', 'CALENDAR');
2807: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);
2808: FND_MSG_PUB.ADD;
2809: RAISE FND_API.G_EXC_ERROR;
2810: END IF;
2811:
2810: END IF;
2811:
2812: IF NOT p_Time_Stamp IS NULL THEN
2813: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2814: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_CALENDAR');
2815: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2816: FND_MSG_PUB.ADD;
2817: x_Return_Status := FND_API.G_RET_STS_ERROR;
2818: RAISE FND_API.G_EXC_ERROR;
2811:
2812: IF NOT p_Time_Stamp IS NULL THEN
2813: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2814: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_CALENDAR');
2815: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2816: FND_MSG_PUB.ADD;
2817: x_Return_Status := FND_API.G_RET_STS_ERROR;
2818: RAISE FND_API.G_EXC_ERROR;
2819: END IF;
2872: END IF;
2873: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: IF (SQLCODE = -00054) THEN
2875: FND_MSG_PUB.Initialize;
2876: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_CALENDAR');
2877: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2878: FND_MSG_PUB.ADD;
2879: x_Return_Status := FND_API.G_RET_STS_ERROR;
2880:
2873: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: IF (SQLCODE = -00054) THEN
2875: FND_MSG_PUB.Initialize;
2876: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_CALENDAR');
2877: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));
2878: FND_MSG_PUB.ADD;
2879: x_Return_Status := FND_API.G_RET_STS_ERROR;
2880:
2881: FND_MSG_PUB.Count_And_Get
2922: OPEN l_Cursor FOR l_Sql USING p_Periodicity_Id;
2923: FETCH l_Cursor INTO l_Object_Id, l_Last_Update_Date;
2924: IF (l_Cursor%NOTFOUND) THEN
2925: CLOSE l_Cursor;
2926: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2927: l_Meaning := Bsc_Apps.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY');
2928: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);
2929: FND_MSG_PUB.ADD;
2930: RAISE FND_API.G_EXC_ERROR;
2924: IF (l_Cursor%NOTFOUND) THEN
2925: CLOSE l_Cursor;
2926: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2927: l_Meaning := Bsc_Apps.Get_Lookup_Value('BSC_UI_COMMON', 'PERIODICITY');
2928: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);
2929: FND_MSG_PUB.ADD;
2930: RAISE FND_API.G_EXC_ERROR;
2931: END IF;
2932:
2931: END IF;
2932:
2933: IF NOT p_Time_Stamp IS NULL THEN
2934: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2935: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_PERIODICITY');
2936: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
2937: FND_MSG_PUB.ADD;
2938: x_Return_Status := FND_API.G_RET_STS_ERROR;
2939: RAISE FND_API.G_EXC_ERROR;
2932:
2933: IF NOT p_Time_Stamp IS NULL THEN
2934: IF p_Time_Stamp <> TO_CHAR(l_Last_Update_Date, BSC_BIS_LOCKS_PUB.C_TIME_STAMP_FORMAT) THEN
2935: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_PERIODICITY');
2936: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
2937: FND_MSG_PUB.ADD;
2938: x_Return_Status := FND_API.G_RET_STS_ERROR;
2939: RAISE FND_API.G_EXC_ERROR;
2940: END IF;
2995: END IF;
2996: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2997: IF (SQLCODE = -00054) THEN
2998: FND_MSG_PUB.Initialize;
2999: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_PERIODICITY');
3000: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
3001: FND_MSG_PUB.ADD;
3002: x_Return_Status := FND_API.G_RET_STS_ERROR;
3003:
2996: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2997: IF (SQLCODE = -00054) THEN
2998: FND_MSG_PUB.Initialize;
2999: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_PERIODICITY');
3000: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));
3001: FND_MSG_PUB.ADD;
3002: x_Return_Status := FND_API.G_RET_STS_ERROR;
3003:
3004: FND_MSG_PUB.Count_And_Get