246: WHERE UPPER(TRIM(Name)) =UPPER(x_measure_name)
247: AND Source = c_BSC;
248:
249: IF(l_Count>0) THEN
250: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
251: FND_MSG_PUB.ADD;
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254: ELSE
258: , p_Pmf_Old_source => cd.Bis_Source
259: , p_Bsc_Old_Source => cd.Bsc_Source
260: );
261: IF (NOT l_Flag) THEN
262: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
263: FND_MSG_PUB.ADD;
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: END LOOP;
276: AND Source = c_BSC
277: AND Dataset_id <> p_dataset_id;
278:
279: IF(l_Count>0) THEN
280: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: ELSE
288: , p_Pmf_Old_source => cd.Bis_Source
289: , p_Bsc_Old_Source => cd.Bsc_Source
290: );
291: IF (NOT l_Flag) THEN
292: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
293: FND_MSG_PUB.ADD;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296: END LOOP;
757:
758: l_Dataset_Rec.Bsc_Measure_Short_Name := UPPER(TRIM(p_measure_short_name));
759:
760: IF (NOT is_Valid_AlphaNum(l_Dataset_Rec.Bsc_Measure_Short_Name)) THEN
761: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
762: FND_MESSAGE.SET_TOKEN('VALUE', l_Dataset_Rec.Bsc_Measure_Short_Name);
763: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'), TRUE);
764: FND_MSG_PUB.ADD;
765: RAISE FND_API.G_EXC_ERROR;
758: l_Dataset_Rec.Bsc_Measure_Short_Name := UPPER(TRIM(p_measure_short_name));
759:
760: IF (NOT is_Valid_AlphaNum(l_Dataset_Rec.Bsc_Measure_Short_Name)) THEN
761: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
762: FND_MESSAGE.SET_TOKEN('VALUE', l_Dataset_Rec.Bsc_Measure_Short_Name);
763: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'), TRUE);
764: FND_MSG_PUB.ADD;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
759:
760: IF (NOT is_Valid_AlphaNum(l_Dataset_Rec.Bsc_Measure_Short_Name)) THEN
761: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
762: FND_MESSAGE.SET_TOKEN('VALUE', l_Dataset_Rec.Bsc_Measure_Short_Name);
763: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'), TRUE);
764: FND_MSG_PUB.ADD;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: SELECT COUNT(Short_Name) INTO l_count
769: FROM BIS_INDICATORS
770: WHERE UPPER(TRIM(Short_Name)) = l_Dataset_Rec.Bsc_Measure_Short_Name;
771: IF (l_count > 0) THEN
772: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_SHORT_NAME_UNIQUE');
773: FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: END IF;
1028: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1029: IF (l_error_tbl.COUNT > 0) THEN
1030: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
1031: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
1032: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
1033: FND_MSG_PUB.ADD;
1034: x_msg_data := NULL;
1035: END IF;
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722:
1723: IF (l_Is_Converted_To_Formula_Type) THEN
1724: l_Report_Objectives := Get_Report_Objectives(p_Dataset_Id);
1725: IF (l_Report_Objectives IS NOT NULL) THEN
1726: FND_MESSAGE.SET_NAME('BIS','BIS_KPI_NON_FORMULA_FOR_AGRPT');
1727: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Report_Objectives);
1728: FND_MSG_PUB.ADD;
1729: RAISE FND_API.G_EXC_ERROR;
1730: END IF;
1723: IF (l_Is_Converted_To_Formula_Type) THEN
1724: l_Report_Objectives := Get_Report_Objectives(p_Dataset_Id);
1725: IF (l_Report_Objectives IS NOT NULL) THEN
1726: FND_MESSAGE.SET_NAME('BIS','BIS_KPI_NON_FORMULA_FOR_AGRPT');
1727: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Report_Objectives);
1728: FND_MSG_PUB.ADD;
1729: RAISE FND_API.G_EXC_ERROR;
1730: END IF;
1731: END IF ;
1984: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1985: IF (l_error_tbl.COUNT > 0) THEN
1986: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
1987: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
1988: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
1989: FND_MSG_PUB.ADD;
1990: x_msg_data := NULL;
1991: END IF;
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2009: IF (l_error_tbl.COUNT > 0) THEN
2010: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
2011: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
2012: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
2013: FND_MSG_PUB.ADD;
2014: x_msg_data := NULL;
2015: END IF;
2016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509: end loop;
2510: end loop;
2511:
2512: if l_measure_names is not null then
2513: FND_MESSAGE.SET_NAME('BSC','BSC_CAE_USED_AT_SAME_TIME');
2514: FND_MESSAGE.SET_TOKEN('LIST', l_measure_names);
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: end if;
2510: end loop;
2511:
2512: if l_measure_names is not null then
2513: FND_MESSAGE.SET_NAME('BSC','BSC_CAE_USED_AT_SAME_TIME');
2514: FND_MESSAGE.SET_TOKEN('LIST', l_measure_names);
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: end if;
2518: end if;
2670: END IF;
2671: else
2672: if (p_Dataset_Rec.Bsc_Measure_operation = c_AVGL_CODE) and isFormula(p_Dataset_Rec.Bsc_Measure_Col) then
2673: -- Do not allow this condition
2674: FND_MESSAGE.SET_NAME('BSC','BSC_AVGLOWESTLEVEL_ERR_TXT');
2675: FND_MSG_PUB.ADD;
2676: RAISE FND_API.G_EXC_ERROR;
2677: end if;
2678: end if;
2989: );
2990:
2991: --if upload_test result is false, does not allow update of this record, throw exception
2992: IF (l_upload_test = FALSE) THEN
2993: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');
2994: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);
2995: FND_MSG_PUB.ADD;
2996: RAISE FND_API.G_EXC_ERROR;
2997: END IF;
2990:
2991: --if upload_test result is false, does not allow update of this record, throw exception
2992: IF (l_upload_test = FALSE) THEN
2993: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');
2994: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);
2995: FND_MSG_PUB.ADD;
2996: RAISE FND_API.G_EXC_ERROR;
2997: END IF;
2998: END IF;
3233: );
3234:
3235: --if upload_test result is false, does not allow update of this record, throw exception
3236: IF (l_upload_test = FALSE) THEN
3237: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');
3238: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);
3239: FND_MSG_PUB.ADD;
3240: RAISE FND_API.G_EXC_ERROR;
3241: END IF;
3234:
3235: --if upload_test result is false, does not allow update of this record, throw exception
3236: IF (l_upload_test = FALSE) THEN
3237: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');
3238: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);
3239: FND_MSG_PUB.ADD;
3240: RAISE FND_API.G_EXC_ERROR;
3241: END IF;
3242:
3727:
3728: if (l_kpis is not null) then
3729: -- Provide a structural changes warning first
3730: if((upper(p_is_xtd_enabled) <> l_is_xtd_enabled) and (p_is_xtd_enabled is not null)) then -- l_is_xtd_enabled is always caps.
3731: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3732: fnd_message.set_token('INDICATORS', l_kpis);
3733: fnd_msg_pub.ADD;
3734: -- raise fnd_api.g_exc_error;
3735: end if;
3728: if (l_kpis is not null) then
3729: -- Provide a structural changes warning first
3730: if((upper(p_is_xtd_enabled) <> l_is_xtd_enabled) and (p_is_xtd_enabled is not null)) then -- l_is_xtd_enabled is always caps.
3731: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3732: fnd_message.set_token('INDICATORS', l_kpis);
3733: fnd_msg_pub.ADD;
3734: -- raise fnd_api.g_exc_error;
3735: end if;
3736:
3735: end if;
3736:
3737: if((upper(p_formula) <> upper(l_formula)) and (p_formula is not null)) then
3738: IF (BSC_DATASETS_PVT.Is_Structure_change(upper(p_formula), upper(l_formula))) THEN
3739: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3740: fnd_message.set_token('INDICATORS', l_kpis);
3741: fnd_msg_pub.ADD;
3742: raise fnd_api.g_exc_error;
3743: ELSE
3736:
3737: if((upper(p_formula) <> upper(l_formula)) and (p_formula is not null)) then
3738: IF (BSC_DATASETS_PVT.Is_Structure_change(upper(p_formula), upper(l_formula))) THEN
3739: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3740: fnd_message.set_token('INDICATORS', l_kpis);
3741: fnd_msg_pub.ADD;
3742: raise fnd_api.g_exc_error;
3743: ELSE
3744: fnd_message.set_name('BIS','BIS_PMD_KPI_NONSTRUCT_INVALID');
3740: fnd_message.set_token('INDICATORS', l_kpis);
3741: fnd_msg_pub.ADD;
3742: raise fnd_api.g_exc_error;
3743: ELSE
3744: fnd_message.set_name('BIS','BIS_PMD_KPI_NONSTRUCT_INVALID');
3745: fnd_message.set_token('OBJECTIVES', l_kpis);
3746: fnd_msg_pub.ADD;
3747: raise fnd_api.g_exc_error;
3748: END IF;
3741: fnd_msg_pub.ADD;
3742: raise fnd_api.g_exc_error;
3743: ELSE
3744: fnd_message.set_name('BIS','BIS_PMD_KPI_NONSTRUCT_INVALID');
3745: fnd_message.set_token('OBJECTIVES', l_kpis);
3746: fnd_msg_pub.ADD;
3747: raise fnd_api.g_exc_error;
3748: END IF;
3749: end if;
3749: end if;
3750:
3751: IF((p_Measure_Group_Id IS NOT NULL ) AND (l_measure_group_id IS NOT NULL)) THEN
3752: IF(p_Measure_Group_Id <> l_measure_group_id) THEN
3753: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3754: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpis);
3755: FND_MSG_PUB.ADD;
3756: RAISE FND_API.G_EXC_ERROR;
3757: END IF;
3750:
3751: IF((p_Measure_Group_Id IS NOT NULL ) AND (l_measure_group_id IS NOT NULL)) THEN
3752: IF(p_Measure_Group_Id <> l_measure_group_id) THEN
3753: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3754: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpis);
3755: FND_MSG_PUB.ADD;
3756: RAISE FND_API.G_EXC_ERROR;
3757: END IF;
3758: END IF;
3757: END IF;
3758: END IF;
3759:
3760: if ((l_measure_type <> p_measure_type) and (p_measure_type <> -1)) then
3761: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3762: fnd_message.set_token('INDICATORS', l_kpis);
3763: fnd_msg_pub.ADD;
3764: raise fnd_api.g_exc_error;
3765: end if;
3758: END IF;
3759:
3760: if ((l_measure_type <> p_measure_type) and (p_measure_type <> -1)) then
3761: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3762: fnd_message.set_token('INDICATORS', l_kpis);
3763: fnd_msg_pub.ADD;
3764: raise fnd_api.g_exc_error;
3765: end if;
3766:
3767: -- color changes is a sub-set change for structural changes, hence comes next
3768:
3769: -- Fixed for bug#3798834
3770: if((upper(p_rollup_calc) <> upper(l_rollup_calc)) and (p_rollup_calc is not null)) then
3771: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3772: fnd_message.set_token('INDICATORS', l_kpis);
3773: fnd_msg_pub.ADD;
3774: raise fnd_api.g_exc_error;
3775: end if;
3768:
3769: -- Fixed for bug#3798834
3770: if((upper(p_rollup_calc) <> upper(l_rollup_calc)) and (p_rollup_calc is not null)) then
3771: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3772: fnd_message.set_token('INDICATORS', l_kpis);
3773: fnd_msg_pub.ADD;
3774: raise fnd_api.g_exc_error;
3775: end if;
3776:
3775: end if;
3776:
3777:
3778: if ((l_proj_id <> p_measure_projection_id) and (p_measure_projection_id <> -1)) then
3779: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3780: fnd_message.set_token('INDICATORS', l_kpis);
3781: fnd_msg_pub.ADD;
3782: raise fnd_api.g_exc_error;
3783: end if;
3776:
3777:
3778: if ((l_proj_id <> p_measure_projection_id) and (p_measure_projection_id <> -1)) then
3779: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3780: fnd_message.set_token('INDICATORS', l_kpis);
3781: fnd_msg_pub.ADD;
3782: raise fnd_api.g_exc_error;
3783: end if;
3784:
3783: end if;
3784:
3785: -- l_is_ytd_enabled is always caps.
3786: if((upper(p_is_ytd_enabled) <> l_is_ytd_enabled) and (p_is_ytd_enabled is not null)) then
3787: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3788: fnd_message.set_token('INDICATORS', l_kpis);
3789: fnd_msg_pub.ADD;
3790: raise fnd_api.g_exc_error;
3791: end if;
3784:
3785: -- l_is_ytd_enabled is always caps.
3786: if((upper(p_is_ytd_enabled) <> l_is_ytd_enabled) and (p_is_ytd_enabled is not null)) then
3787: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3788: fnd_message.set_token('INDICATORS', l_kpis);
3789: fnd_msg_pub.ADD;
3790: raise fnd_api.g_exc_error;
3791: end if;
3792:
3791: end if;
3792:
3793: -- l_is_qtd_enabled is always caps.
3794: if((upper(p_is_qtd_enabled) <> l_is_qtd_enabled) and (p_is_qtd_enabled is not null)) then
3795: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3796: fnd_message.set_token('INDICATORS', l_kpis);
3797: fnd_msg_pub.ADD;
3798: raise fnd_api.g_exc_error;
3799: end if;
3792:
3793: -- l_is_qtd_enabled is always caps.
3794: if((upper(p_is_qtd_enabled) <> l_is_qtd_enabled) and (p_is_qtd_enabled is not null)) then
3795: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3796: fnd_message.set_token('INDICATORS', l_kpis);
3797: fnd_msg_pub.ADD;
3798: raise fnd_api.g_exc_error;
3799: end if;
3800: END IF;-- END L_KPIS IS NOT NULL
4175:
4176: x_msg_data := null;
4177:
4178: if (l_indicators is not null) then
4179: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
4180: fnd_message.set_token('INDICATORS', l_indicators);
4181: fnd_msg_pub.ADD;
4182: raise fnd_api.g_exc_error;
4183: end if;
4176: x_msg_data := null;
4177:
4178: if (l_indicators is not null) then
4179: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
4180: fnd_message.set_token('INDICATORS', l_indicators);
4181: fnd_msg_pub.ADD;
4182: raise fnd_api.g_exc_error;
4183: end if;
4184: