1903:
1904: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Short_Name)
1905: = FND_API.G_TRUE) then
1906: SELECT dimension_level_id into x_Dimension_Level_ID
1907: FROM bisbv_dimension_levels
1908: WHERE dimension_level_short_name = p_Dimension_Level_Short_Name;
1909: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Name)
1910: = FND_API.G_TRUE) then
1911: SELECT dimension_level_id into x_Dimension_Level_ID
1908: WHERE dimension_level_short_name = p_Dimension_Level_Short_Name;
1909: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Name)
1910: = FND_API.G_TRUE) then
1911: SELECT dimension_level_id into x_Dimension_Level_ID
1912: FROM bisbv_dimension_levels
1913: WHERE dimension_level_name = p_Dimension_Level_Name;
1914: else
1915:
1916: -- POPULATE THE ERROR TABLE: added last two parameters