DBA Data[Home] [Help]

APPS.BSC_BIS_LOCKS_PVT dependencies on FND_MESSAGE

Line 330: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE'); -- ADRAO changed Measage

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;

Line 332: FND_MESSAGE.SET_TOKEN('TYPE', l_meaning, TRUE);

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

Line 343: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');

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

Line 344: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));

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

Line 412: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');

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

Line 413: FND_MESSAGE.SET_TOKEN('MEASURE', get_Dataset_Name(p_dataset_id));

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

Line 459: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_MEASURE');

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

Line 460: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, nvl(get_Datasource_Name(p_measure_id),p_measure_id)));

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

Line 472: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_MEASURE');

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

Line 473: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name,get_Datasource_Name(p_measure_id)));

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

Line 502: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_MEASURE');

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

Line 503: FND_MESSAGE.SET_TOKEN('MEASURE', nvl(p_dataset_name, get_Datasource_Name(p_measure_id)));

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

Line 955: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_LEVEL');

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

Line 956: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', nvl(get_Dim_Level_Name(p_dim_level_id),p_dim_level_id));

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

Line 968: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_LEVEL');

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

Line 969: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));

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

Line 998: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_LEVEL');

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

Line 999: FND_MESSAGE.SET_TOKEN('DIM_LEVEL', get_Dim_Level_Name(p_dim_level_id));

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

Line 1051: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_GROUP');

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

Line 1052: FND_MESSAGE.SET_TOKEN('DIM_GROUP', nvl(get_Dim_Group_Name(p_dim_group_id),p_dim_group_id));

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;

Line 1062: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_GROUP');

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

Line 1063: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));

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;

Line 1090: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_GROUP');

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

Line 1091: FND_MESSAGE.SET_TOKEN('DIM_GROUP', get_Dim_Group_Name(p_dim_group_id));

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

Line 1145: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_DIM_SET');

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

Line 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

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

Line 1147: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id)); -- Fixed Bug#3047483

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;

Line 1157: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_DIM_SET');

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

Line 1158: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_kpi_Id, p_dim_set_id)); -- Fixed Bug#3047483

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

Line 1159: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id)); -- Fixed Bug#3047483

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;

Line 1186: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_DIM_SET');

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;

Line 1187: FND_MESSAGE.SET_TOKEN('DIM_SET', get_Dim_Set_Name(p_dim_set_id, p_kpi_Id));

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

Line 1188: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));

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

Line 1240: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');

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

Line 1241: FND_MESSAGE.SET_TOKEN('KPI', nvl(get_KPI_Name(p_kpi_Id),p_kpi_Id ));

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;

Line 1254: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_KPI_1');

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

Line 1255: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(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);
1259: RAISE FND_API.G_EXC_ERROR;

Line 1297: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_KPI_1');

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

Line 1298: FND_MESSAGE.SET_TOKEN('KPI', get_KPI_Name(p_kpi_Id));

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

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

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;

Line 2608: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_IVIEWER', 'SCORECARD'), TRUE);

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:

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

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;

Line 2661: FND_MESSAGE.SET_NAME('BSC','BSC_MUSERS_LOCKED_TAB');

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;

Line 2721: --FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETED_KPI_1');

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

Line 2722: FND_MESSAGE.SET_NAME('BSC','The current tab view has been deleted by another user');

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

Line 2739: FND_MESSAGE.SET_NAME('BSC','The Current view has been modified by another user');

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

Line 2740: --FND_MESSAGE.SET_TOKEN('KPI', get_TabView_Name(p_tab_id,p_tab_view_id);

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

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

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;

Line 2807: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);

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:

Line 2814: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_CALENDAR');

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;

Line 2815: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));

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;

Line 2876: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_CALENDAR');

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:

Line 2877: FND_MESSAGE.SET_TOKEN('CALENDAR', Get_Calendar_Name(p_Calendar_Id));

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

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

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;

Line 2928: FND_MESSAGE.SET_TOKEN('TYPE', l_Meaning, TRUE);

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:

Line 2935: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_MODIFIED_PERIODICITY');

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;

Line 2936: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));

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;

Line 2999: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_LOCKED_PERIODICITY');

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:

Line 3000: FND_MESSAGE.SET_TOKEN('PERIODICITY', Get_Periodicity_Name(p_Periodicity_Id));

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