APPS.BSC_DIMENSION_SETS_PVT dependencies on FND_MESSAGE

Line 90: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

86: if (p_commit = FND_API.G_TRUE) then
87: commit;
88: end if;
89: else
90: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
91: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Dim_Set_Id);
92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: end if;

Line 91: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Dim_Set_Id);

87: commit;
88: end if;
89: else
90: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
91: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Dim_Set_Id);
92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: end if;
95: EXCEPTION

Line 229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

225: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
226: ,'indicator'
227: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
228: if l_count = 0 then
229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
230: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
231: FND_MSG_PUB.ADD;
232: RAISE FND_API.G_EXC_ERROR;
233: end if;

Line 230: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

226: ,'indicator'
227: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
228: if l_count = 0 then
229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
230: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
231: FND_MSG_PUB.ADD;
232: RAISE FND_API.G_EXC_ERROR;
233: end if;
234: else

Line 235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

231: FND_MSG_PUB.ADD;
232: RAISE FND_API.G_EXC_ERROR;
233: end if;
234: else
235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
236: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
237: FND_MSG_PUB.ADD;
238: RAISE FND_API.G_EXC_ERROR;
239: end if;

Line 236: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

232: RAISE FND_API.G_EXC_ERROR;
233: end if;
234: else
235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
236: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
237: FND_MSG_PUB.ADD;
238: RAISE FND_API.G_EXC_ERROR;
239: end if;
240:

Line 247: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');

243: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_GROUPS_TL'
244: ,'dim_group_id'
245: ,p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
246: if l_count = 0 then
247: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
248: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
249: FND_MSG_PUB.ADD;
250: RAISE FND_API.G_EXC_ERROR;
251: end if;

Line 248: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);

244: ,'dim_group_id'
245: ,p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
246: if l_count = 0 then
247: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
248: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
249: FND_MSG_PUB.ADD;
250: RAISE FND_API.G_EXC_ERROR;
251: end if;
252: else

Line 253: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');

249: FND_MSG_PUB.ADD;
250: RAISE FND_API.G_EXC_ERROR;
251: end if;
252: else
253: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');
254: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
255: FND_MSG_PUB.ADD;
256: RAISE FND_API.G_EXC_ERROR;
257: end if;

Line 254: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);

250: RAISE FND_API.G_EXC_ERROR;
251: end if;
252: else
253: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');
254: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
255: FND_MSG_PUB.ADD;
256: RAISE FND_API.G_EXC_ERROR;
257: end if;
258:

Line 359: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

355: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
356: ,'indicator'
357: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
358: if l_count = 0 then
359: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
360: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: end if;

Line 360: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

356: ,'indicator'
357: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
358: if l_count = 0 then
359: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
360: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: end if;
364: else

Line 365: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: end if;
364: else
365: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
366: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
367: FND_MSG_PUB.ADD;
368: RAISE FND_API.G_EXC_ERROR;
369: end if;

Line 366: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

362: RAISE FND_API.G_EXC_ERROR;
363: end if;
364: else
365: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
366: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
367: FND_MSG_PUB.ADD;
368: RAISE FND_API.G_EXC_ERROR;
369: end if;
370:

Line 377: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');

373: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_GROUPS_TL'
374: ,'dim_group_id'
375: ,p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
376: if l_count = 0 then
377: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
378: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
379: FND_MSG_PUB.ADD;
380: RAISE FND_API.G_EXC_ERROR;
381: end if;

Line 378: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);

374: ,'dim_group_id'
375: ,p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
376: if l_count = 0 then
377: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
378: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
379: FND_MSG_PUB.ADD;
380: RAISE FND_API.G_EXC_ERROR;
381: end if;
382: else

Line 383: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');

379: FND_MSG_PUB.ADD;
380: RAISE FND_API.G_EXC_ERROR;
381: end if;
382: else
383: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');
384: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
385: FND_MSG_PUB.ADD;
386: RAISE FND_API.G_EXC_ERROR;
387: end if;

Line 384: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);

380: RAISE FND_API.G_EXC_ERROR;
381: end if;
382: else
383: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');
384: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id);
385: FND_MSG_PUB.ADD;
386: RAISE FND_API.G_EXC_ERROR;
387: end if;
388:

Line 547: FND_MESSAGE.SET_NAME('BSC','BSC_DSET_KPI_EXISTS');

543: end if;
544:
545: else
546: if l_Dim_Set_Rec.Bsc_New_Dset = 'Y' then
547: FND_MESSAGE.SET_NAME('BSC','BSC_DSET_KPI_EXISTS');
548: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Dim_Set_Rec.Bsc_Kpi_Id);
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_ERROR;
551: end if;

Line 548: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Dim_Set_Rec.Bsc_Kpi_Id);

544:
545: else
546: if l_Dim_Set_Rec.Bsc_New_Dset = 'Y' then
547: FND_MESSAGE.SET_NAME('BSC','BSC_DSET_KPI_EXISTS');
548: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Dim_Set_Rec.Bsc_Kpi_Id);
549: FND_MSG_PUB.ADD;
550: RAISE FND_API.G_EXC_ERROR;
551: end if;
552: end if;

Line 704: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

700: FROM BSC_KPIS_B
701: WHERE INDICATOR = p_Dim_Set_Rec.Bsc_Kpi_Id;
702:
703: if l_count = 0 then
704: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
705: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: else

Line 705: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

701: WHERE INDICATOR = p_Dim_Set_Rec.Bsc_Kpi_Id;
702:
703: if l_count = 0 then
704: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
705: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: else
709: select count(dim_set_id)

Line 715: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DSET_ID');

711: from BSC_KPI_DIM_SETS_TL
712: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
713: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
714: if l_count = 0 then
715: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DSET_ID');
716: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
717: FND_MSG_PUB.ADD;
718: RAISE FND_API.G_EXC_ERROR;
719: end if;

Line 716: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

712: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
713: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
714: if l_count = 0 then
715: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DSET_ID');
716: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
717: FND_MSG_PUB.ADD;
718: RAISE FND_API.G_EXC_ERROR;
719: end if;
720: end if;

Line 722: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

718: RAISE FND_API.G_EXC_ERROR;
719: end if;
720: end if;
721: else
722: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
723: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
724: FND_MSG_PUB.ADD;
725: RAISE FND_API.G_EXC_ERROR;
726: end if;

Line 723: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

719: end if;
720: end if;
721: else
722: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
723: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
724: FND_MSG_PUB.ADD;
725: RAISE FND_API.G_EXC_ERROR;
726: end if;
727:

Line 947: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

943: ,p_Dim_Set_Rec.Bsc_Dset_User_Level2
944: ,p_Dim_Set_Rec.Bsc_Dset_User_Level2_Default
945: ,p_Dim_Set_Rec.Bsc_Dset_Target_Level);
946: else
947: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
948: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
949: FND_MSG_PUB.ADD;
950: RAISE FND_API.G_EXC_ERROR;
951: end if;

Line 948: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);

944: ,p_Dim_Set_Rec.Bsc_Dset_User_Level2_Default
945: ,p_Dim_Set_Rec.Bsc_Dset_Target_Level);
946: else
947: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
948: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
949: FND_MSG_PUB.ADD;
950: RAISE FND_API.G_EXC_ERROR;
951: end if;
952: END IF;

Line 1108: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

1104: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1105: ,'indicator'
1106: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
1107: if l_count = 0 then
1108: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1109: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1110: FND_MSG_PUB.ADD;
1111: RAISE FND_API.G_EXC_ERROR;
1112: else

Line 1109: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

1105: ,'indicator'
1106: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
1107: if l_count = 0 then
1108: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1109: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1110: FND_MSG_PUB.ADD;
1111: RAISE FND_API.G_EXC_ERROR;
1112: else
1113: select count(dim_set_id)

Line 1119: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

1115: from BSC_KPI_DIM_SETS_TL
1116: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1117: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1118: if l_count = 0 then
1119: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1120: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1121: FND_MSG_PUB.ADD;
1122: RAISE FND_API.G_EXC_ERROR;
1123: end if;

Line 1120: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);

1116: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1117: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1118: if l_count = 0 then
1119: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1120: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1121: FND_MSG_PUB.ADD;
1122: RAISE FND_API.G_EXC_ERROR;
1123: end if;
1124: end if;

Line 1126: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

1122: RAISE FND_API.G_EXC_ERROR;
1123: end if;
1124: end if;
1125: else
1126: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1127: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1128: FND_MSG_PUB.ADD;
1129: RAISE FND_API.G_EXC_ERROR;
1130: end if;

Line 1127: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

1123: end if;
1124: end if;
1125: else
1126: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1127: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1128: FND_MSG_PUB.ADD;
1129: RAISE FND_API.G_EXC_ERROR;
1130: end if;
1131:

Line 1138: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');

1134: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B'
1135: ,'dim_level_id'
1136: ,p_Dim_Set_Rec.Bsc_Level_Id);
1137: if l_count = 0 then
1138: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1139: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Set_Rec.Bsc_Level_Id);
1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;
1142: end if;

Line 1139: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Set_Rec.Bsc_Level_Id);

1135: ,'dim_level_id'
1136: ,p_Dim_Set_Rec.Bsc_Level_Id);
1137: if l_count = 0 then
1138: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1139: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Set_Rec.Bsc_Level_Id);
1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;
1142: end if;
1143: else

Line 1144: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

1140: FND_MSG_PUB.ADD;
1141: RAISE FND_API.G_EXC_ERROR;
1142: end if;
1143: else
1144: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1145: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Set_Rec.Bsc_Level_Id);
1146: FND_MSG_PUB.ADD;
1147: RAISE FND_API.G_EXC_ERROR;
1148: end if;

Line 1145: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Set_Rec.Bsc_Level_Id);

1141: RAISE FND_API.G_EXC_ERROR;
1142: end if;
1143: else
1144: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
1145: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Set_Rec.Bsc_Level_Id);
1146: FND_MSG_PUB.ADD;
1147: RAISE FND_API.G_EXC_ERROR;
1148: end if;
1149:

Line 1281: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

1277: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1278: ,'indicator'
1279: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
1280: if l_count = 0 then
1281: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1282: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1283: FND_MSG_PUB.ADD;
1284: RAISE FND_API.G_EXC_ERROR;
1285: else

Line 1282: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

1278: ,'indicator'
1279: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
1280: if l_count = 0 then
1281: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1282: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1283: FND_MSG_PUB.ADD;
1284: RAISE FND_API.G_EXC_ERROR;
1285: else
1286: select count(dim_set_id)

Line 1292: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

1288: from BSC_KPI_DIM_SETS_TL
1289: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1290: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1291: if l_count = 0 then
1292: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1293: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1294: FND_MSG_PUB.ADD;
1295: RAISE FND_API.G_EXC_ERROR;
1296: end if;

Line 1293: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);

1289: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1290: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1291: if l_count = 0 then
1292: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1293: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1294: FND_MSG_PUB.ADD;
1295: RAISE FND_API.G_EXC_ERROR;
1296: end if;
1297: end if;

Line 1299: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

1295: RAISE FND_API.G_EXC_ERROR;
1296: end if;
1297: end if;
1298: else
1299: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1300: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: end if;

Line 1300: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

1296: end if;
1297: end if;
1298: else
1299: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1300: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: end if;
1304:

Line 1529: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

1525: );
1526: END LOOP;
1527: END IF;
1528: ELSE
1529: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1530: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: END IF;

Line 1530: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);

1526: END LOOP;
1527: END IF;
1528: ELSE
1529: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1530: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: END IF;
1534: END IF;

Line 1744: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

1740: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1741: ,'indicator'
1742: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
1743: if l_count = 0 then
1744: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1745: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1746: FND_MSG_PUB.ADD;
1747: RAISE FND_API.G_EXC_ERROR;
1748: else

Line 1745: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

1741: ,'indicator'
1742: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
1743: if l_count = 0 then
1744: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1745: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1746: FND_MSG_PUB.ADD;
1747: RAISE FND_API.G_EXC_ERROR;
1748: else
1749: select count(dim_set_id)

Line 1755: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

1751: from BSC_KPI_DIM_SETS_TL
1752: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1753: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1754: if l_count = 0 then
1755: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1756: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: end if;

Line 1756: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);

1752: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1753: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1754: if l_count = 0 then
1755: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');
1756: FND_MESSAGE.SET_TOKEN('BSC_COMBO', p_Dim_Set_Rec.Bsc_Kpi_Id);
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: end if;
1760: end if;

Line 1762: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

1758: RAISE FND_API.G_EXC_ERROR;
1759: end if;
1760: end if;
1761: else
1762: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1763: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1764: FND_MSG_PUB.ADD;
1765: RAISE FND_API.G_EXC_ERROR;
1766: end if;

Line 1763: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

1759: end if;
1760: end if;
1761: else
1762: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1763: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
1764: FND_MSG_PUB.ADD;
1765: RAISE FND_API.G_EXC_ERROR;
1766: end if;
1767:

Line 1775: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');

1771: into l_count
1772: from BSC_SYS_DIM_LEVELS_B
1773: where upper(level_table_name) = upper(p_Dim_Set_Rec.Bsc_Level_Name);
1774: if l_count = 0 then
1775: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
1776: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Set_Rec.Bsc_Level_Name);
1777: FND_MSG_PUB.ADD;
1778: RAISE FND_API.G_EXC_ERROR;
1779: end if;

Line 1776: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Set_Rec.Bsc_Level_Name);

1772: from BSC_SYS_DIM_LEVELS_B
1773: where upper(level_table_name) = upper(p_Dim_Set_Rec.Bsc_Level_Name);
1774: if l_count = 0 then
1775: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');
1776: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Set_Rec.Bsc_Level_Name);
1777: FND_MSG_PUB.ADD;
1778: RAISE FND_API.G_EXC_ERROR;
1779: end if;
1780: else

Line 1781: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_NAME_ENTERED');

1777: FND_MSG_PUB.ADD;
1778: RAISE FND_API.G_EXC_ERROR;
1779: end if;
1780: else
1781: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_NAME_ENTERED');
1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Set_Rec.Bsc_Level_Name);
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: end if;

Line 1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Set_Rec.Bsc_Level_Name);

1778: RAISE FND_API.G_EXC_ERROR;
1779: end if;
1780: else
1781: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_NAME_ENTERED');
1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', p_Dim_Set_Rec.Bsc_Level_Name);
1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: end if;
1786:

Line 2025: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

2021: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2022: ,'indicator'
2023: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
2024: if l_count = 0 then
2025: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2026: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
2027: FND_MSG_PUB.ADD;
2028: RAISE FND_API.G_EXC_ERROR;
2029: end if;

Line 2026: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

2022: ,'indicator'
2023: ,p_Dim_Set_Rec.Bsc_Kpi_Id);
2024: if l_count = 0 then
2025: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2026: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
2027: FND_MSG_PUB.ADD;
2028: RAISE FND_API.G_EXC_ERROR;
2029: end if;
2030: else

Line 2031: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

2027: FND_MSG_PUB.ADD;
2028: RAISE FND_API.G_EXC_ERROR;
2029: end if;
2030: else
2031: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2032: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
2033: FND_MSG_PUB.ADD;
2034: RAISE FND_API.G_EXC_ERROR;
2035: end if;

Line 2032: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);

2028: RAISE FND_API.G_EXC_ERROR;
2029: end if;
2030: else
2031: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2032: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Dim_Set_Rec.Bsc_Kpi_Id);
2033: FND_MSG_PUB.ADD;
2034: RAISE FND_API.G_EXC_ERROR;
2035: end if;
2036: