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_MESSAGE

Line 62: BSC_MESSAGE.Add(x_message => SQLERRM,

58:
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:

Line 187: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

183:
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;

Line 192: BSC_MESSAGE.Add(x_message => SQLERRM,

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,
193: x_source => 'BSC_UPDATE_COLOR.Color_Kpis_In_Objective');
194: RETURN FALSE;
195: END Color_Kpis_In_Objective;
196:

Line 280: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

276:
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;

Line 285: BSC_MESSAGE.Add(x_message => SQLERRM,

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,
286: x_source => 'BSC_UPDATE_COLOR.Color_Kpi_Measure');
287: RETURN FALSE;
288: END Color_Kpi_Measure;
289:

Line 473: BSC_MESSAGE.Add(x_message => SQLERRM,

469: RETURN TRUE;
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:

Line 517: BSC_MESSAGE.Add(x_message => SQLERRM,

513:
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:

Line 675: BSC_MESSAGE.Add(x_message => SQLERRM,

671:
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: /*===========================================================================+

Line 1446: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMDATA_NOT_FOUND'),

1442: RETURN TRUE;
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

Line 1451: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

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'),
1452: x_source => 'BSC_UPDATE_COLOR.Color_Indic_Dim_Combination');
1453: RETURN FALSE;
1454:
1455: WHEN OTHERS THEN

Line 1456: BSC_MESSAGE.Add(x_message => 'x_indic_code='||x_indic_code,

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,
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,

Line 1458: BSC_MESSAGE.Add(x_message => 'h_table_name='||h_table_name,

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');
1462: BSC_MESSAGE.Add(x_message => 'h_condition='||h_condition,

Line 1460: BSC_MESSAGE.Add(x_message => 'h_level_comb='||h_level_comb,

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');
1464: BSC_MESSAGE.Add(x_message => 'h_sql='||SUBSTR(h_sql, 1, 200),

Line 1462: BSC_MESSAGE.Add(x_message => 'h_condition='||h_condition,

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');
1466: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 1464: BSC_MESSAGE.Add(x_message => 'h_sql='||SUBSTR(h_sql, 1, 200),

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');
1468: RETURN FALSE;

Line 1466: BSC_MESSAGE.Add(x_message => SQLERRM,

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:
1470: END Color_Indic_Dim_Combination;

Line 1646: BSC_MESSAGE.Add(x_message => SQLERRM,

1642:
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:

Line 1695: BSC_MESSAGE.Add(x_message => SQLERRM,

1691:
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:

Line 1965: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

1961: IF c_objective_color_props%ISOPEN THEN
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

Line 1980: BSC_MESSAGE.Add(x_message => SQLERRM,

1976: IF c_objective_color_props%ISOPEN THEN
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;

Line 2331: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_TEMP_TABTABLES_FAILED'),

2327: RETURN TRUE;
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

Line 2336: BSC_MESSAGE.Add(x_message => SQLERRM,

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,
2337: x_source => 'BSC_UPDATE_COLOR.Create_Temp_Tab_Tables');
2338:
2339: RETURN FALSE;
2340:

Line 2370: BSC_MESSAGE.Add(x_message => SQLERRM,

2366: RETURN TRUE;
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

Line 2375: 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,
2376: x_source => 'BSC_UPDATE_COLOR.Drop_Temp_Tab_Tables');
2377: RETURN FALSE;
2378:
2379: END Drop_Temp_Tab_Tables;

Line 2636: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_COLORTABLE_COND_FAILED'),

2632: RETURN TRUE;
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

Line 2641: BSC_MESSAGE.Add(x_message => SQLERRM,

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,
2642: x_source => 'BSC_UPDATE_COLOR.Get_Condition_On_Color_Table');
2643: RETURN FALSE;
2644:
2645: END Get_Condition_On_Color_Table;

Line 2725: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_COLORTABLE_FAILED'),

2721: WHEN e_unexpected_error THEN
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

Line 2733: BSC_MESSAGE.Add(x_message => SQLERRM,

2729: WHEN OTHERS THEN
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:

Line 2907: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_COLORTABLE_FAILED'),

2903: RETURN h_table_name;
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

Line 2912: BSC_MESSAGE.Add(x_message => SQLERRM,

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,
2913: x_source => 'BSC_UPDATE_COLOR.Get_Table_Used_To_Color');
2914: RETURN NULL;
2915: END Get_Table_Used_To_Color;
2916:

Line 2986: BSC_MESSAGE.Add(x_message => SQLERRM,

2982: RETURN TRUE;
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;

Line 3076: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_FAILED'),

3072:
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;

Line 3083: BSC_MESSAGE.Add(x_message => SQLERRM,

3079: x_kpi_measure_id := -1;
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;

Line 3272: BSC_MESSAGE.Add(x_message => SQLERRM,

3268:
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: