APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_APPS

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 2664: if (BSC_APPS.Get_Property_Value(p_dataset_rec.Bsc_Measure_color_formula, c_FORMULA_SOURCE) is null) then

2660: l_color_formula varchar2(4000) := NULL;
2661: begin
2662: if (p_Measure_apply_rollup is not null and p_Measure_apply_rollup = 'Y') then
2663:
2664: if (BSC_APPS.Get_Property_Value(p_dataset_rec.Bsc_Measure_color_formula, c_FORMULA_SOURCE) is null) then
2665: select BSC_INTERNAL_COLUMN_S.nextval into l_column_name from dual;
2666: l_column_name := c_INTERNAL_COLUMN_NAME || l_column_name;
2667: l_color_formula := BSC_APPS.Set_Property_Value(NULL, c_FORMULA_SOURCE, l_column_name);
2668: ELSE

Line 2667: l_color_formula := BSC_APPS.Set_Property_Value(NULL, c_FORMULA_SOURCE, l_column_name);

2663:
2664: if (BSC_APPS.Get_Property_Value(p_dataset_rec.Bsc_Measure_color_formula, c_FORMULA_SOURCE) is null) then
2665: select BSC_INTERNAL_COLUMN_S.nextval into l_column_name from dual;
2666: l_column_name := c_INTERNAL_COLUMN_NAME || l_column_name;
2667: l_color_formula := BSC_APPS.Set_Property_Value(NULL, c_FORMULA_SOURCE, l_column_name);
2668: ELSE
2669: l_color_formula := SUBSTR(p_dataset_rec.Bsc_Measure_color_formula, 0, (INSTR(p_dataset_rec.Bsc_Measure_color_formula, '&')-1));
2670: END IF;
2671: else

Line 2682: l_color_formula := BSC_APPS.Set_Property_Value(l_color_formula, c_AVGL, 'Y');

2678: end if;
2679:
2680: -- Insert pAvgL=...
2681: if (p_Dataset_Rec.Bsc_Measure_operation = c_AVGL_CODE) then
2682: l_color_formula := BSC_APPS.Set_Property_Value(l_color_formula, c_AVGL, 'Y');
2683: else
2684: l_color_formula := BSC_APPS.Set_Property_Value(l_color_formula, c_AVGL, 'N');
2685: end if;
2686:

Line 2684: l_color_formula := BSC_APPS.Set_Property_Value(l_color_formula, c_AVGL, 'N');

2680: -- Insert pAvgL=...
2681: if (p_Dataset_Rec.Bsc_Measure_operation = c_AVGL_CODE) then
2682: l_color_formula := BSC_APPS.Set_Property_Value(l_color_formula, c_AVGL, 'Y');
2683: else
2684: l_color_formula := BSC_APPS.Set_Property_Value(l_color_formula, c_AVGL, 'N');
2685: end if;
2686:
2687: return l_color_formula;
2688:

Line 3699: select decode(nvl(BSC_APPS.Get_Property_Value(m.S_COLOR_FORMULA, 'pAvgL'), 'N'), 'Y', 'AVL', m.operation) rollup

3695: and disabled_calc_id = c_XTD_CODE;
3696: end if;
3697:
3698: if(p_rollup_calc is not null) then
3699: select decode(nvl(BSC_APPS.Get_Property_Value(m.S_COLOR_FORMULA, 'pAvgL'), 'N'), 'Y', 'AVL', m.operation) rollup
3700: into l_rollup_calc
3701: from bsc_sys_datasets_vl d, bsc_sys_measures m
3702: where m.measure_id = d.measure_id1
3703: and d.dataset_id = p_dataset_id ;

Line 3845: l_message := bsc_apps.get_message(p_message);

3841: begin
3842:
3843:
3844: l_temp := bsc_bis_measure_pub.getMeasureKpis(p_dataset_id => p_dataset_id);
3845: l_message := bsc_apps.get_message(p_message);
3846: l_length := nvl(0, length(l_message));
3847:
3848:
3849: if((nvl(0, length(l_temp)) + l_length) > c_MAX_MSG_LENGTH) then