1245:
1246: ELSE
1247:
1248: /*
1249: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1250: fnd_message.set_token('SHORT_NAME', l_Dimension_Level_Rec.Dimension_Level_Short_Name);
1251: fnd_message.set_token('NAME', l_Dimension_Level_Rec.Dimension_Level_Name);
1252: l_msg := fnd_message.get;
1253: */
1246: ELSE
1247:
1248: /*
1249: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1250: fnd_message.set_token('SHORT_NAME', l_Dimension_Level_Rec.Dimension_Level_Short_Name);
1251: fnd_message.set_token('NAME', l_Dimension_Level_Rec.Dimension_Level_Name);
1252: l_msg := fnd_message.get;
1253: */
1254:
1247:
1248: /*
1249: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1250: fnd_message.set_token('SHORT_NAME', l_Dimension_Level_Rec.Dimension_Level_Short_Name);
1251: fnd_message.set_token('NAME', l_Dimension_Level_Rec.Dimension_Level_Name);
1252: l_msg := fnd_message.get;
1253: */
1254:
1255: l_msg := 'Failed to upload ' || nvl(l_Dimension_Level_Rec.Dimension_Level_Short_Name, ' ');
1248: /*
1249: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1250: fnd_message.set_token('SHORT_NAME', l_Dimension_Level_Rec.Dimension_Level_Short_Name);
1251: fnd_message.set_token('NAME', l_Dimension_Level_Rec.Dimension_Level_Name);
1252: l_msg := fnd_message.get;
1253: */
1254:
1255: l_msg := 'Failed to upload ' || nvl(l_Dimension_Level_Rec.Dimension_Level_Short_Name, ' ');
1256: l_msg := l_msg || ' Level name: ' || nvl(l_Dimension_Level_Rec.Dimension_Level_Name, ' ');
1461:
1462: WHEN OTHERS THEN
1463:
1464: /*
1465: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1466: fnd_message.set_token('SHORT_NAME', p_level_short_name);
1467: fnd_message.set_token('NAME', p_level_name);
1468: l_msg := fnd_message.get;
1469: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
1462: WHEN OTHERS THEN
1463:
1464: /*
1465: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1466: fnd_message.set_token('SHORT_NAME', p_level_short_name);
1467: fnd_message.set_token('NAME', p_level_name);
1468: l_msg := fnd_message.get;
1469: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
1470: */
1463:
1464: /*
1465: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1466: fnd_message.set_token('SHORT_NAME', p_level_short_name);
1467: fnd_message.set_token('NAME', p_level_name);
1468: l_msg := fnd_message.get;
1469: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
1470: */
1471:
1464: /*
1465: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1466: fnd_message.set_token('SHORT_NAME', p_level_short_name);
1467: fnd_message.set_token('NAME', p_level_name);
1468: l_msg := fnd_message.get;
1469: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
1470: */
1471:
1472: l_msg := 'Failed to upload ' || nvl ( p_level_short_name , ' ' );
2476: -- check if the dimension level type is of PMF and then check if this can be disabled.
2477: IF ( isPMFDimensionLevel( p_dim_level_id => p_dim_level_id )) THEN
2478: -- check if this dimension level is used to set target
2479: IF ( IS_TARGET_DEFINED(p_dim_level_id => p_dim_level_id) ) THEN
2480: fnd_message.set_name('BIS','BIS_PMF_DIM_LVL_USED_IN_TARGET');
2481: app_exception.raise_exception;
2482: END IF;
2483:
2484: -- check if this dimension level is assigned to a KPI
2482: END IF;
2483:
2484: -- check if this dimension level is assigned to a KPI
2485: IF ( IS_ASSIGNED_TO_KPI(p_dim_level_id => p_dim_level_id) ) THEN
2486: fnd_message.set_name('BIS', 'BIS_BSC_DIM_LVL_KPI_ASSIGNED');
2487: app_exception.raise_exception;
2488: END IF;
2489: END IF;
2490: END validate_disabling;