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_UPDATE_COLOR dependencies on BSC_UPDATE_COLOR

Line 1: PACKAGE BODY BSC_UPDATE_COLOR AS

1: PACKAGE BODY BSC_UPDATE_COLOR AS
2: /* $Header: BSCDCOLB.pls 120.15.12010000.3 2008/09/18 09:40:23 bijain ship $ */
3:
4:
5: FUNCTION Color_Kpi_Measure (

Line 21: p_objective_color_rec IN BSC_UPDATE_COLOR.t_objective_color_rec

17: )
18: RETURN BOOLEAN;
19:
20: PROCEDURE Calculate_Objective_Color (
21: p_objective_color_rec IN BSC_UPDATE_COLOR.t_objective_color_rec
22: ,x_kpi_measure_id OUT NOCOPY NUMBER
23: ,x_color_flag OUT NOCOPY BOOLEAN
24: );
25:

Line 63: x_source => 'BSC_UPDATE_COLOR.is_ytd_default_calc');

59: EXCEPTION
60: WHEN OTHERS THEN
61: ROLLBACK;
62: BSC_MESSAGE.Add(x_message => SQLERRM,
63: x_source => 'BSC_UPDATE_COLOR.is_ytd_default_calc');
64: RETURN FALSE;
65: END is_ytd_default_calc;
66:
67:

Line 188: x_source => 'BSC_UPDATE_COLOR.Color_Kpis_In_Objective');

184: EXCEPTION
185: WHEN e_unexpected_error THEN
186: ROLLBACK;
187: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
188: x_source => 'BSC_UPDATE_COLOR.Color_Kpis_In_Objective');
189: RETURN FALSE;
190: WHEN OTHERS THEN
191: ROLLBACK;
192: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 193: x_source => 'BSC_UPDATE_COLOR.Color_Kpis_In_Objective');

189: RETURN FALSE;
190: WHEN OTHERS THEN
191: ROLLBACK;
192: BSC_MESSAGE.Add(x_message => SQLERRM,
193: x_source => 'BSC_UPDATE_COLOR.Color_Kpis_In_Objective');
194: RETURN FALSE;
195: END Color_Kpis_In_Objective;
196:
197:

Line 281: x_source => 'BSC_UPDATE_COLOR.Color_Kpi_Measure');

277: EXCEPTION
278: WHEN e_unexpected_error THEN
279: ROLLBACK;
280: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
281: x_source => 'BSC_UPDATE_COLOR.Color_Kpi_Measure');
282: RETURN FALSE;
283: WHEN OTHERS THEN
284: ROLLBACK;
285: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 286: x_source => 'BSC_UPDATE_COLOR.Color_Kpi_Measure');

282: RETURN FALSE;
283: WHEN OTHERS THEN
284: ROLLBACK;
285: BSC_MESSAGE.Add(x_message => SQLERRM,
286: x_source => 'BSC_UPDATE_COLOR.Color_Kpi_Measure');
287: RETURN FALSE;
288: END Color_Kpi_Measure;
289:
290:

Line 474: x_source => 'BSC_UPDATE_COLOR.update_actual_budget_for_mcc');

470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: BSC_MESSAGE.Add(x_message => SQLERRM,
474: x_source => 'BSC_UPDATE_COLOR.update_actual_budget_for_mcc');
475: RETURN FALSE;
476: END update_actual_budget_for_mcc;
477:
478:

Line 518: x_source => 'BSC_UPDATE_COLOR.get_trend_flag');

514: EXCEPTION
515: WHEN OTHERS THEN
516: ROLLBACK;
517: BSC_MESSAGE.Add(x_message => SQLERRM,
518: x_source => 'BSC_UPDATE_COLOR.get_trend_flag');
519: RETURN 5;--No Data
520: END get_trend_flag;
521:
522: --BugFix 6000042 Trend for Comparison Mode

Line 558: l_key_tbl BSC_UPDATE_COLOR.t_key_tbl_type;

554: h_prev_period NUMBER;
555: h_trend_keys VARCHAR2(100);
556: l_index NUMBER := 1;
557: l_key_rec t_key_rec;
558: l_key_tbl BSC_UPDATE_COLOR.t_key_tbl_type;
559: l_first_time BOOLEAN := true;
560: l_prev_real NUMBER;
561: l_count NUMBER;
562: --l_starttime timestamp;

Line 676: x_source => 'BSC_UPDATE_COLOR.update_trend_for_comparison');

672: EXCEPTION
673: WHEN OTHERS THEN
674: ROLLBACK;
675: BSC_MESSAGE.Add(x_message => SQLERRM,
676: x_source => 'BSC_UPDATE_COLOR.update_trend_for_comparison');
677: END update_trend_for_comparison;
678:
679: /*===========================================================================+
680: | FUNCTION Color_Indic_Dim_Combination

Line 1447: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1443:
1444: EXCEPTION
1445: WHEN e_no_data_table_error THEN
1446: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMDATA_NOT_FOUND'),
1447: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1448: RETURN FALSE;
1449:
1450: WHEN e_unexpected_error THEN
1451: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

Line 1452: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1448: RETURN FALSE;
1449:
1450: WHEN e_unexpected_error THEN
1451: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
1452: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1453: RETURN FALSE;
1454:
1455: WHEN OTHERS THEN
1456: BSC_MESSAGE.Add(x_message => 'x_indic_code='||x_indic_code,

Line 1457: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1453: RETURN FALSE;
1454:
1455: WHEN OTHERS THEN
1456: BSC_MESSAGE.Add(x_message => 'x_indic_code='||x_indic_code,
1457: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1458: BSC_MESSAGE.Add(x_message => 'h_table_name='||h_table_name,
1459: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1460: BSC_MESSAGE.Add(x_message => 'h_level_comb='||h_level_comb,
1461: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

Line 1459: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1455: WHEN OTHERS THEN
1456: BSC_MESSAGE.Add(x_message => 'x_indic_code='||x_indic_code,
1457: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1458: BSC_MESSAGE.Add(x_message => 'h_table_name='||h_table_name,
1459: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1460: BSC_MESSAGE.Add(x_message => 'h_level_comb='||h_level_comb,
1461: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1462: BSC_MESSAGE.Add(x_message => 'h_condition='||h_condition,
1463: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

Line 1461: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1457: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1458: BSC_MESSAGE.Add(x_message => 'h_table_name='||h_table_name,
1459: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1460: BSC_MESSAGE.Add(x_message => 'h_level_comb='||h_level_comb,
1461: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1462: BSC_MESSAGE.Add(x_message => 'h_condition='||h_condition,
1463: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1464: BSC_MESSAGE.Add(x_message => 'h_sql='||SUBSTR(h_sql, 1, 200),
1465: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

Line 1463: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1459: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1460: BSC_MESSAGE.Add(x_message => 'h_level_comb='||h_level_comb,
1461: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1462: BSC_MESSAGE.Add(x_message => 'h_condition='||h_condition,
1463: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1464: BSC_MESSAGE.Add(x_message => 'h_sql='||SUBSTR(h_sql, 1, 200),
1465: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1466: BSC_MESSAGE.Add(x_message => SQLERRM,
1467: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

Line 1465: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1461: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1462: BSC_MESSAGE.Add(x_message => 'h_condition='||h_condition,
1463: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1464: BSC_MESSAGE.Add(x_message => 'h_sql='||SUBSTR(h_sql, 1, 200),
1465: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1466: BSC_MESSAGE.Add(x_message => SQLERRM,
1467: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1468: RETURN FALSE;
1469:

Line 1467: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');

1463: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1464: BSC_MESSAGE.Add(x_message => 'h_sql='||SUBSTR(h_sql, 1, 200),
1465: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1466: BSC_MESSAGE.Add(x_message => SQLERRM,
1467: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1468: RETURN FALSE;
1469:
1470: END Color_Indic_Dim_Combination;
1471:

Line 1647: x_source => 'BSC_UPDATE_COLOR.Calculate_KPI_Color');

1643: EXCEPTION
1644: WHEN OTHERS THEN
1645: ROLLBACK;
1646: BSC_MESSAGE.Add(x_message => SQLERRM,
1647: x_source => 'BSC_UPDATE_COLOR.Calculate_KPI_Color');
1648: RETURN FALSE;
1649: END Calculate_KPI_Color;
1650:
1651:

Line 1696: x_source => 'BSC_UPDATE_COLOR.calculate_trend_icon');

1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: ROLLBACK;
1695: BSC_MESSAGE.Add(x_message => SQLERRM,
1696: x_source => 'BSC_UPDATE_COLOR.calculate_trend_icon');
1697: RETURN FALSE;
1698: END calculate_trend_icon;
1699:
1700: /*===========================================================================+

Line 1966: x_source => 'BSC_UPDATE_COLOR.Color_Indicator');

1962: CLOSE c_objective_color_props;
1963: END IF;
1964: ROLLBACK;
1965: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
1966: x_source => 'BSC_UPDATE_COLOR.Color_Indicator');
1967: RETURN FALSE;
1968:
1969: WHEN OTHERS THEN
1970: IF c_indic_type%ISOPEN THEN

Line 1981: x_source => 'BSC_UPDATE_COLOR.Color_Indicator');

1977: CLOSE c_objective_color_props;
1978: END IF;
1979: ROLLBACK;
1980: BSC_MESSAGE.Add(x_message => SQLERRM,
1981: x_source => 'BSC_UPDATE_COLOR.Color_Indicator');
1982: RETURN FALSE;
1983:
1984: END Color_Indicator;
1985:

Line 2332: x_source => 'BSC_UPDATE_COLOR.Create_Temp_Tab_Tables');

2328:
2329: EXCEPTION
2330: WHEN e_unexpected_error THEN
2331: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_TEMP_TABTABLES_FAILED'),
2332: x_source => 'BSC_UPDATE_COLOR.Create_Temp_Tab_Tables');
2333: RETURN FALSE;
2334:
2335: WHEN OTHERS THEN
2336: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 2337: x_source => 'BSC_UPDATE_COLOR.Create_Temp_Tab_Tables');

2333: RETURN FALSE;
2334:
2335: WHEN OTHERS THEN
2336: BSC_MESSAGE.Add(x_message => SQLERRM,
2337: x_source => 'BSC_UPDATE_COLOR.Create_Temp_Tab_Tables');
2338:
2339: RETURN FALSE;
2340:
2341: END Create_Temp_Tab_Tables;

Line 2371: x_source => 'BSC_UPDATE_COLOR.Drop_Temp_Tab_Tables');

2367:
2368: EXCEPTION
2369: WHEN e_unexpected_error THEN
2370: BSC_MESSAGE.Add(x_message => SQLERRM,
2371: x_source => 'BSC_UPDATE_COLOR.Drop_Temp_Tab_Tables');
2372: RETURN FALSE;
2373:
2374: WHEN OTHERS THEN
2375: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 2376: x_source => 'BSC_UPDATE_COLOR.Drop_Temp_Tab_Tables');

2372: RETURN FALSE;
2373:
2374: WHEN OTHERS THEN
2375: BSC_MESSAGE.Add(x_message => SQLERRM,
2376: x_source => 'BSC_UPDATE_COLOR.Drop_Temp_Tab_Tables');
2377: RETURN FALSE;
2378:
2379: END Drop_Temp_Tab_Tables;
2380:

Line 2637: x_source => 'BSC_UPDATE_COLOR.Get_Condition_On_Color_Table');

2633:
2634: EXCEPTION
2635: WHEN e_unexpected_error THEN
2636: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_COLORTABLE_COND_FAILED'),
2637: x_source => 'BSC_UPDATE_COLOR.Get_Condition_On_Color_Table');
2638: RETURN FALSE;
2639:
2640: WHEN OTHERS THEN
2641: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 2642: x_source => 'BSC_UPDATE_COLOR.Get_Condition_On_Color_Table');

2638: RETURN FALSE;
2639:
2640: WHEN OTHERS THEN
2641: BSC_MESSAGE.Add(x_message => SQLERRM,
2642: x_source => 'BSC_UPDATE_COLOR.Get_Condition_On_Color_Table');
2643: RETURN FALSE;
2644:
2645: END Get_Condition_On_Color_Table;
2646:

Line 2726: x_source => 'BSC_UPDATE_COLOR.Get_Table_For_Drill_Comb');

2722: IF c_indic_tables%ISOPEN THEN
2723: CLOSE c_indic_tables;
2724: END IF;
2725: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_COLORTABLE_FAILED'),
2726: x_source => 'BSC_UPDATE_COLOR.Get_Table_For_Drill_Comb');
2727: RETURN NULL;
2728:
2729: WHEN OTHERS THEN
2730: IF c_indic_tables%ISOPEN THEN

Line 2734: x_source => 'BSC_UPDATE_COLOR.Get_Table_For_Drill_Comb');

2730: IF c_indic_tables%ISOPEN THEN
2731: CLOSE c_indic_tables;
2732: END IF;
2733: BSC_MESSAGE.Add(x_message => SQLERRM,
2734: x_source => 'BSC_UPDATE_COLOR.Get_Table_For_Drill_Comb');
2735: RETURN NULL;
2736: END Get_Table_For_Drill_Comb;
2737:
2738:

Line 2908: x_source => 'BSC_UPDATE_COLOR.Get_Table_Used_To_Color');

2904:
2905: EXCEPTION
2906: WHEN e_unexpected_error THEN
2907: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_COLORTABLE_FAILED'),
2908: x_source => 'BSC_UPDATE_COLOR.Get_Table_Used_To_Color');
2909: RETURN NULL;
2910:
2911: WHEN OTHERS THEN
2912: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 2913: x_source => 'BSC_UPDATE_COLOR.Get_Table_Used_To_Color');

2909: RETURN NULL;
2910:
2911: WHEN OTHERS THEN
2912: BSC_MESSAGE.Add(x_message => SQLERRM,
2913: x_source => 'BSC_UPDATE_COLOR.Get_Table_Used_To_Color');
2914: RETURN NULL;
2915: END Get_Table_Used_To_Color;
2916:
2917:

Line 2987: x_source => 'BSC_UPDATE_COLOR.Insert_Tab_Combinations');

2983:
2984: EXCEPTION
2985: WHEN OTHERS THEN
2986: BSC_MESSAGE.Add(x_message => SQLERRM,
2987: x_source => 'BSC_UPDATE_COLOR.Insert_Tab_Combinations');
2988:
2989:
2990: RETURN FALSE;
2991:

Line 3041: p_objective_color_rec IN BSC_UPDATE_COLOR.t_objective_color_rec

3037: * DEFAULT_KPI. For Simulation Objective, the color will be based on the
3038: * default (color) node as of today.
3039: */
3040: PROCEDURE Calculate_Objective_Color (
3041: p_objective_color_rec IN BSC_UPDATE_COLOR.t_objective_color_rec
3042: ,x_kpi_measure_id OUT NOCOPY NUMBER
3043: ,x_color_flag OUT NOCOPY BOOLEAN
3044: ) IS
3045:

Line 3077: x_source => 'BSC_UPDATE_COLOR.Calculate_Objective_Color');

3073: EXCEPTION
3074: WHEN e_unexpected_error THEN
3075: ROLLBACK;
3076: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),
3077: x_source => 'BSC_UPDATE_COLOR.Calculate_Objective_Color');
3078: x_color_flag := false;
3079: x_kpi_measure_id := -1;
3080: --RETURN FALSE;
3081: WHEN OTHERS THEN

Line 3084: x_source => 'BSC_UPDATE_COLOR.Calculate_Objective_Color');

3080: --RETURN FALSE;
3081: WHEN OTHERS THEN
3082: ROLLBACK;
3083: BSC_MESSAGE.Add(x_message => SQLERRM,
3084: x_source => 'BSC_UPDATE_COLOR.Calculate_Objective_Color');
3085: x_color_flag := false;
3086: x_kpi_measure_id := -1;
3087: --RETURN FALSE;
3088: END Calculate_Objective_Color;

Line 3273: x_source => 'BSC_UPDATE_COLOR.calculate_kpi_trend_icon');

3269: EXCEPTION
3270: WHEN OTHERS THEN
3271: ROLLBACK;
3272: BSC_MESSAGE.Add(x_message => SQLERRM,
3273: x_source => 'BSC_UPDATE_COLOR.calculate_kpi_trend_icon');
3274: RETURN FALSE;
3275: END calculate_kpi_trend_icon;
3276:
3277: END BSC_UPDATE_COLOR;

Line 3277: END BSC_UPDATE_COLOR;

3273: x_source => 'BSC_UPDATE_COLOR.calculate_kpi_trend_icon');
3274: RETURN FALSE;
3275: END calculate_kpi_trend_icon;
3276:
3277: END BSC_UPDATE_COLOR;