eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_COLOR_CALC_UTIL dependencies on BSC_COLOR_CALC_UTIL

Line 1: PACKAGE BODY BSC_COLOR_CALC_UTIL AS

1: PACKAGE BODY BSC_COLOR_CALC_UTIL AS
2: /* $Header: BSCCUTLB.pls 120.6.12000000.1 2007/07/17 07:43:38 appldev noship $ */
3:
4:
5: FUNCTION get_weighted_obj_color (

Line 92: x_source => 'BSC_COLOR_CALC_UTIL.Get_Kpi_Measure_Threshold');

88: RETURN l_threshold_Table;
89: EXCEPTION
90: WHEN OTHERS THEN
91: BSC_MESSAGE.Add(x_message => SQLERRM,
92: x_source => 'BSC_COLOR_CALC_UTIL.Get_Kpi_Measure_Threshold');
93: RETURN l_threshold_Table;
94: END Get_Kpi_Measure_Threshold;
95:
96:

Line 122: x_source => 'BSC_COLOR_CALC_UTIL.get_color_perf_seq');

118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: BSC_MESSAGE.Add(x_message => SQLERRM,
122: x_source => 'BSC_COLOR_CALC_UTIL.get_color_perf_seq');
123: RETURN NULL;
124: END get_color_perf_seq;
125:
126:

Line 160: x_source => 'BSC_COLOR_CALC_UTIL.get_objective_color_method');

156: IF c_obj_color_prop%ISOPEN THEN
157: CLOSE c_obj_color_prop;
158: END IF;
159: BSC_MESSAGE.Add(x_message => SQLERRM,
160: x_source => 'BSC_COLOR_CALC_UTIL.get_objective_color_method');
161: RETURN NULL;
162: END get_objective_color_method;
163:
164:

Line 198: x_source => 'BSC_COLOR_CALC_UTIL.get_kpi_measure_weight');

194: IF c_kpi_measure_weight%ISOPEN THEN
195: CLOSE c_kpi_measure_weight;
196: END IF;
197: BSC_MESSAGE.Add(x_message => SQLERRM,
198: x_source => 'BSC_COLOR_CALC_UTIL.get_kpi_measure_weight');
199: RETURN 0;
200: END get_kpi_measure_weight;
201:
202:

Line 227: x_source => 'BSC_COLOR_CALC_UTIL.get_color_numeric_equivalent');

223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: BSC_MESSAGE.Add(x_message => SQLERRM,
227: x_source => 'BSC_COLOR_CALC_UTIL.get_color_numeric_equivalent');
228: RETURN 0;
229: END get_color_numeric_equivalent;
230:
231:

Line 376: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights');

372: EXCEPTION
373: WHEN e_unexpected_error THEN
374: ROLLBACK;
375: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
376: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights');
377: RETURN FALSE;
378: WHEN OTHERS THEN
379: ROLLBACK;
380: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 381: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights');

377: RETURN FALSE;
378: WHEN OTHERS THEN
379: ROLLBACK;
380: BSC_MESSAGE.Add(x_message => SQLERRM,
381: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Weights');
382: RETURN FALSE;
383: END Calc_Obj_Color_By_Weights;
384:
385:

Line 474: x_source => 'BSC_COLOR_CALC_UTIL.get_weighted_obj_color');

470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: BSC_MESSAGE.Add(x_message => SQLERRM,
474: x_source => 'BSC_COLOR_CALC_UTIL.get_weighted_obj_color');
475: RETURN NULL;
476: END get_weighted_obj_color;
477:
478: FUNCTION Get_Sim_Default_Kpi_Measure_Id (

Line 526: x_source => 'BSC_COLOR_CALC_UTIL.Get_Sim_Default_Kpi_Measure_Id');

522: IF c_default_node_dataset%ISOPEN THEN
523: CLOSE c_default_node_dataset;
524: END IF;
525: BSC_MESSAGE.Add(x_message => SQLERRM,
526: x_source => 'BSC_COLOR_CALC_UTIL.Get_Sim_Default_Kpi_Measure_Id');
527: RETURN NULL;
528: END Get_Sim_Default_Kpi_Measure_Id;
529:
530:

Line 630: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi');

626: EXCEPTION
627: WHEN e_unexpected_error THEN
628: ROLLBACK;
629: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
630: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi');
631: x_kpi_measure_id := -1;
632: x_color_flag := false;
633: --RETURN FALSE;
634: WHEN OTHERS THEN

Line 637: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi');

633: --RETURN FALSE;
634: WHEN OTHERS THEN
635: ROLLBACK;
636: BSC_MESSAGE.Add(x_message => SQLERRM,
637: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Single_Kpi');
638: x_kpi_measure_id := -1;
639: x_color_flag := false;
640: --RETURN FALSE;
641: END Calc_Obj_Color_By_Single_Kpi;

Line 705: x_source => 'BSC_COLOR_CALC_UTIL.get_worst_color');

701:
702: EXCEPTION
703: WHEN OTHERS THEN
704: BSC_MESSAGE.Add(x_message => SQLERRM,
705: x_source => 'BSC_COLOR_CALC_UTIL.get_worst_color');
706: --RETURN NULL;
707: END get_worst_color;
708:
709: /* Returns the best color out of all the colors in the input array.

Line 773: x_source => 'BSC_COLOR_CALC_UTIL.get_best_color');

769: EXCEPTION
770: WHEN OTHERS THEN
771: ROLLBACK;
772: BSC_MESSAGE.Add(x_message => SQLERRM,
773: x_source => 'BSC_COLOR_CALC_UTIL.get_best_color');
774: --RETURN NULL;
775: END get_best_color;
776:
777:

Line 902: x_source => 'BSC_COLOR_CALC_UTIL.get_most_frequent_color');

898:
899: EXCEPTION
900: WHEN OTHERS THEN
901: BSC_MESSAGE.Add(x_message => SQLERRM,
902: x_source => 'BSC_COLOR_CALC_UTIL.get_most_frequent_color');
903: --RETURN NULL;
904: END get_most_frequent_color;
905:
906:

Line 925: x_source => 'BSC_COLOR_CALC_UTIL.get_rollup_obj_color');

921: END IF;
922: EXCEPTION
923: WHEN OTHERS THEN
924: BSC_MESSAGE.Add(x_message => SQLERRM,
925: x_source => 'BSC_COLOR_CALC_UTIL.get_rollup_obj_color');
926: --RETURN NULL;
927: END get_rollup_obj_color;
928:
929:

Line 970: x_source => 'BSC_COLOR_CALC_UTIL.Get_Default_Kpi_Measure_Id');

966: IF c_default_kpi%ISOPEN THEN
967: CLOSE c_default_kpi;
968: END IF;
969: BSC_MESSAGE.Add(x_message => SQLERRM,
970: x_source => 'BSC_COLOR_CALC_UTIL.Get_Default_Kpi_Measure_Id');
971: RETURN NULL;
972: END Get_Default_Kpi_Measure_Id;
973:
974:

Line 1013: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Default_Kpi');

1009: EXCEPTION
1010: WHEN OTHERS THEN
1011: ROLLBACK;
1012: BSC_MESSAGE.Add(x_message => SQLERRM,
1013: x_source => 'BSC_COLOR_CALC_UTIL.Calc_Obj_Color_By_Default_Kpi');
1014: x_color_flag := false;
1015: x_kpi_measure_id := -1;
1016: --RETURN FALSE;
1017: END Calc_Obj_Color_By_Default_Kpi;

Line 1056: x_source => 'BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type');

1052: IF c_rollup_type%ISOPEN THEN
1053: CLOSE c_rollup_type;
1054: END IF;
1055: BSC_MESSAGE.Add(x_message => SQLERRM,
1056: x_source => 'BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type');
1057: RETURN NULL;
1058: END Get_Obj_Color_Rollup_Type;
1059:
1060: END BSC_COLOR_CALC_UTIL;

Line 1060: END BSC_COLOR_CALC_UTIL;

1056: x_source => 'BSC_COLOR_CALC_UTIL.Get_Obj_Color_Rollup_Type');
1057: RETURN NULL;
1058: END Get_Obj_Color_Rollup_Type;
1059:
1060: END BSC_COLOR_CALC_UTIL;