DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on FND_MESSAGE

Line 250: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');

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

Line 262: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');

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;

Line 280: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');

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

Line 292: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');

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;

Line 761: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');

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;

Line 762: FND_MESSAGE.SET_TOKEN('VALUE', l_Dataset_Rec.Bsc_Measure_Short_Name);

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;

Line 763: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'), TRUE);

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:

Line 772: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_SHORT_NAME_UNIQUE');

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;

Line 1032: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

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;

Line 1726: FND_MESSAGE.SET_NAME('BIS','BIS_KPI_NON_FORMULA_FOR_AGRPT');

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;

Line 1727: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Report_Objectives);

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 ;

Line 1988: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

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;

Line 2012: FND_MESSAGE.SET_NAME('BIS',x_msg_data);

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;

Line 2513: FND_MESSAGE.SET_NAME('BSC','BSC_CAE_USED_AT_SAME_TIME');

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;

Line 2514: FND_MESSAGE.SET_TOKEN('LIST', l_measure_names);

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;

Line 2674: FND_MESSAGE.SET_NAME('BSC','BSC_AVGLOWESTLEVEL_ERR_TXT');

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;

Line 2993: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');

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;

Line 2994: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);

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;

Line 3237: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');

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;

Line 3238: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);

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:

Line 3731: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');

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;

Line 3732: fnd_message.set_token('INDICATORS', l_kpis);

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:

Line 3739: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');

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

Line 3740: fnd_message.set_token('INDICATORS', l_kpis);

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

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

Line 3745: fnd_message.set_token('OBJECTIVES', 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;
3749: end if;

Line 3753: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');

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;

Line 3754: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpis);

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;

Line 3761: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');

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;

Line 3762: fnd_message.set_token('INDICATORS', l_kpis);

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:

Line 3771: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');

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;

Line 3772: fnd_message.set_token('INDICATORS', l_kpis);

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:

Line 3779: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');

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;

Line 3780: fnd_message.set_token('INDICATORS', l_kpis);

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:

Line 3787: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');

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;

Line 3788: fnd_message.set_token('INDICATORS', l_kpis);

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:

Line 3795: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');

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;

Line 3796: fnd_message.set_token('INDICATORS', l_kpis);

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

Line 4179: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');

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;

Line 4180: fnd_message.set_token('INDICATORS', l_indicators);

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: