DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_MESSAGE

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

644: IF(c_column%ISOPEN) THEN
645: CLOSE c_column;
646: END IF;
647: --DBMS_OUTPUT.PUT_LINE('error occured in s' || substr(SQLERRM,1,255));
648: BSC_MESSAGE.Add(x_message => SQLERRM,
649: x_source => 'Copy_Record_by_Indicator_Table');
650: RAISE;
651: END Copy_Record_by_Indicator_Table;
652:

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

693:
694: EXCEPTION
695: WHEN OTHERS THEN
696: --DBMS_OUTPUT.PUT_LINE('Init' || SQLERRM);
697: BSC_MESSAGE.Add(x_message => SQLERRM,
698: x_source => 'Init_variables');
699: END Init_variables;
700:
701: /*===========================================================================+

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

744:
745: EXCEPTION
746: WHEN OTHERS THEN
747: --DBMS_OUTPUT.PUT_LINE('a' || SQLERRM);
748: BSC_MESSAGE.Add(x_message => SQLERRM,
749: x_source => 'Deflt_RefreshInvalidKpis');
750: END Deflt_RefreshInvalidKpis;
751: /*===========================================================================+
752: | PROCEDURE

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

801: END IF;
802: EXCEPTION
803: WHEN OTHERS THEN
804: --DBMS_OUTPUT.PUT_LINE('c' || SQLERRM);
805: BSC_MESSAGE.Add(x_message => SQLERRM,
806: x_source => 'Deflt_RefreshKpi');
807: END Deflt_RefreshKpi;
808:
809: /*===========================================================================+

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

872: --DBMS_OUTPUT.PUT_LINE(h_sql);
873: EXCEPTION
874: WHEN OTHERS THEN
875: --DBMS_OUTPUT.PUT_LINE('d' || SQLERRM);
876: BSC_MESSAGE.Add(x_message => SQLERRM,
877: x_source => 'Deflt_Clear');
878: END Deflt_Clear;
879:
880: /*===========================================================================+

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

1102: --DBMS_OUTPUT.PUT_LINE('end of Deflt_Update_AOPTS');
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: --DBMS_OUTPUT.PUT_LINE('e' || SQLERRM);
1106: BSC_MESSAGE.Add(x_message => SQLERRM,
1107: x_source => 'Deflt_Update_AOPTS');
1108: END Deflt_Update_AOPTS;
1109:
1110: /*===========================================================================+

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

1300:
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: --DBMS_OUTPUT.PUT_LINE('d' || SQLERRM);
1304: BSC_MESSAGE.Add(x_message => SQLERRM,
1305: x_source => 'Deflt_Update_SN_FM_CM');
1306: END Deflt_Update_SN_FM_CM;
1307:
1308:

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

1340:
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: --DBMS_OUTPUT.PUT_LINE('g' || SQLERRM);
1344: BSC_MESSAGE.Add(x_message => SQLERRM,
1345: x_source => 'Deflt_Update_DIM_SET');
1346: END Deflt_Update_DIM_SET;
1347:
1348: /*===========================================================================+

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

1416: Execute Immediate h_sql USING l_indicator;
1417: EXCEPTION
1418: WHEN OTHERS THEN
1419: --DBMS_OUTPUT.PUT_LINE('h' || SQLERRM);
1420: BSC_MESSAGE.Add(x_message => SQLERRM,
1421: x_source => 'Deflt_Update_DIM_VALUES');
1422: END Deflt_Update_DIM_VALUES;
1423: /*===========================================================================+
1424: | PROCEDURE

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

1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: --DBMS_OUTPUT.PUT_LINE('j' || SQLERRM);
1582: BSC_MESSAGE.Add(x_message => SQLERRM,
1583: x_source => 'Deflt_Update_DIM_NAMES');
1584: END Deflt_Update_DIM_NAMES;
1585: /*===========================================================================+
1586: | FUNCTION

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

1639:
1640: EXCEPTION
1641: WHEN OTHERS THEN
1642: --DBMS_OUTPUT.PUT_LINE('k' || SQLERRM);
1643: BSC_MESSAGE.Add(x_message => SQLERRM,
1644: x_source => 'getItemfromMasterTable');
1645: END getItemfromMasterTable;
1646: /*===========================================================================+
1647: | PROCEDURE

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

1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: --DBMS_OUTPUT.PUT_LINE('m' || SQLERRM);
1735: BSC_MESSAGE.Add(x_message => SQLERRM,
1736: x_source => 'Deflt_Update_PERIOD');
1737: END Deflt_Update_PERIOD_NAME;
1738: /*===========================================================================+
1739: | PROCEDURE

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

1878:
1879: EXCEPTION
1880: WHEN OTHERS THEN
1881: --DBMS_OUTPUT.PUT_LINE('n' || SQLERRM);
1882: BSC_MESSAGE.Add(x_message => SQLERRM,
1883: x_source => 'Duplicate_Record_by_Indicator');
1884: RAISE;
1885: END Duplicate_Record_by_Indicator;
1886:

Line 1968: BSC_MESSAGE.Add( x_message => SQLERRM

1964: WHEN OTHERS THEN
1965: IF c_column%ISOPEN THEN
1966: CLOSE c_column;
1967: END IF;
1968: BSC_MESSAGE.Add( x_message => SQLERRM
1969: , x_source => 'BSC_DESIGNER_PVT.insert_kpi_meas_data'
1970: );
1971: RAISE;
1972: END insert_kpi_meas_data;

Line 2034: BSC_MESSAGE.Add( x_message => SQLERRM

2030: WHEN OTHERS THEN
2031: IF c_color_range%ISOPEN THEN
2032: CLOSE c_color_range;
2033: END IF;
2034: BSC_MESSAGE.Add( x_message => SQLERRM
2035: , x_source => 'BSC_DESIGNER_PVT.Copy_Thresholds'
2036: );
2037: RAISE;
2038: END Copy_Thresholds;

Line 2124: BSC_MESSAGE.Add( x_message => SQLERRM

2120: WHERE indicator = p_trg_kpi;
2121:
2122: EXCEPTION
2123: WHEN OTHERS THEN
2124: BSC_MESSAGE.Add( x_message => SQLERRM
2125: , x_source => 'BSC_DESIGNER_PVT.Copy_Records_by_Obj_Kpi_Meas'
2126: );
2127: RAISE;
2128: END Copy_Records_by_Obj_Kpi_Meas;

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

2335: h_sql := 'DELETE BSC_KPI_DIM_LEVELS_B WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2336: Execute Immediate h_sql USING h_Trg_kpi_neg;
2337: h_sql := 'DELETE BSC_KPI_DIM_LEVEL_PROPERTIES WHERE INDICATOR=:1'; --|| h_Trg_kpi_neg;
2338: Execute Immediate h_sql USING h_Trg_kpi_neg;
2339: BSC_MESSAGE.Add(x_message => SQLERRM,
2340: x_source => 'Duplicate_KPI_Metadata');
2341: RAISE;
2342: END Duplicate_KPI_Metadata;
2343:

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

2367:
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: --DBMS_OUTPUT.PUT_LINE('p' || SQLERRM);
2371: BSC_MESSAGE.Add(x_message => SQLERRM,
2372: x_source => 'BscKpisB_Update');
2373: RAISE;
2374: END BscKpisB_Update;
2375:

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

2470: END IF;
2471:
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: BSC_MESSAGE.Add(x_message => SQLERRM,
2475: x_source => 'BSC_DESIGNER_PVT.Update_Kpi_Prototype_Flag');
2476: END Update_Kpi_Prototype_Flag;
2477:
2478:

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

2499: , p_cascade_color => TRUE
2500: );
2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: BSC_MESSAGE.Add(x_message => SQLERRM,
2504: x_source => 'ActionFlag_Change_Cascade');
2505: END ActionFlag_Change;
2506:
2507:

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

2714:
2715: EXCEPTION
2716: WHEN OTHERS THEN
2717: --DBMS_OUTPUT.PUT_LINE('q' || SQLERRM);
2718: BSC_MESSAGE.Add(x_message => SQLERRM,
2719: x_source => 'ActionFlag_Change_Cascade');
2720: END ActionFlag_Change_Cascade;
2721:
2722:

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

2773:
2774: EXCEPTION
2775: WHEN OTHERS THEN
2776: --DBMS_OUTPUT.PUT_LINE('s' || SQLERRM);
2777: BSC_MESSAGE.Add(x_message => SQLERRM,
2778: x_source => 'Dim_Object_Change');
2779: END Dim_Object_Change;
2780:
2781:

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

2841:
2842: EXCEPTION
2843: WHEN OTHERS THEN
2844: --DBMS_OUTPUT.PUT_LINE('s' || SQLERRM);
2845: BSC_MESSAGE.Add(x_message => SQLERRM,
2846: x_source => 'Dimension_Change');
2847: END Dimension_Change;
2848:
2849:

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

2897:
2898: EXCEPTION
2899: WHEN OTHERS THEN
2900: --DBMS_OUTPUT.PUT_LINE('s' || SQLERRM);
2901: BSC_MESSAGE.Add(x_message => SQLERRM,
2902: x_source => 'Dimension_Change');
2903: END Dimension_Change;
2904:
2905: /*-------------------------------------------------------