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 dependencies on BSC_MESSAGE

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

65: RETURN h_ret;
66:
67: EXCEPTION
68: WHEN OTHERS THEN
69: BSC_MESSAGE.Add(x_message => SQLERRM,
70: x_source => 'BSC_UPDATE.Can_Load_Dim_Table');
71: RETURN NULL;
72:
73: END Can_Load_Dim_Table;

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

132: RETURN h_ret;
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: BSC_MESSAGE.Add(x_message => SQLERRM,
137: x_source => 'BSC_UPDATE.Can_Calculate_Sys_Table');
138: RETURN NULL;
139:
140: END Can_Calculate_Sys_Table;

Line 249: BSC_MESSAGE.flush;

245: END IF;
246:
247: EXCEPTION
248: WHEN e_error THEN
249: BSC_MESSAGE.flush;
250: BSC_MESSAGE.Add(x_message => l_error_message,
251: x_source => 'BSC_UPDATE.Configure_Periodicity_Calc_VB',
252: x_mode => 'I');
253: COMMIT;

Line 250: BSC_MESSAGE.Add(x_message => l_error_message,

246:
247: EXCEPTION
248: WHEN e_error THEN
249: BSC_MESSAGE.flush;
250: BSC_MESSAGE.Add(x_message => l_error_message,
251: x_source => 'BSC_UPDATE.Configure_Periodicity_Calc_VB',
252: x_mode => 'I');
253: COMMIT;
254:

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

252: x_mode => 'I');
253: COMMIT;
254:
255: WHEN OTHERS THEN
256: BSC_MESSAGE.Add(x_message => SQLERRM,
257: x_source => 'BSC_UPDATE.Configure_Periodicity_Calc_VB',
258: x_mode => 'I');
259: COMMIT;
260:

Line 350: BSC_MESSAGE.flush;

346: END IF;
347:
348: EXCEPTION
349: WHEN e_error THEN
350: BSC_MESSAGE.flush;
351: BSC_MESSAGE.Add(x_message => l_error_message,
352: x_source => 'BSC_UPDATE.Configure_Profit_Calc_VB',
353: x_mode => 'I');
354: COMMIT;

Line 351: BSC_MESSAGE.Add(x_message => l_error_message,

347:
348: EXCEPTION
349: WHEN e_error THEN
350: BSC_MESSAGE.flush;
351: BSC_MESSAGE.Add(x_message => l_error_message,
352: x_source => 'BSC_UPDATE.Configure_Profit_Calc_VB',
353: x_mode => 'I');
354: COMMIT;
355:

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

353: x_mode => 'I');
354: COMMIT;
355:
356: WHEN OTHERS THEN
357: BSC_MESSAGE.Add(x_message => SQLERRM,
358: x_source => 'BSC_UPDATE.Configure_Profit_Calc_VB',
359: x_mode => 'I');
360: COMMIT;
361:

Line 433: BSC_MESSAGE.Init(g_debug_flag);

429: BSC_APPS.Init_Bsc_Apps;
430:
431: -- Initializes the error message stack
432: g_debug_flag := 'NO';
433: BSC_MESSAGE.Init(g_debug_flag);
434:
435: -- Initialize the temporal table used for big 'in' conditions
436: BSC_APPS.Init_Big_In_Cond_Table;
437:

Line 836: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_NO_PENDING_PROCESS'),

832: WHEN e_no_pending_process THEN
833: -- Delete records in the temporal table used for big 'in' conditions
834: BSC_APPS.Init_Big_In_Cond_Table;
835:
836: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_NO_PENDING_PROCESS'),
837: x_source => 'BSC_UPDATE.Execute_Update_Process',
838: x_mode => 'I');
839: COMMIT;
840:

Line 852: BSC_MESSAGE.flush;

848: WHEN e_exists_prototype_indicators THEN
849: -- Delete records in the temporal table used for big 'in' conditions
850: BSC_APPS.Init_Big_In_Cond_Table;
851:
852: BSC_MESSAGE.flush;
853: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_METADATA_PEND_CHANGES'),
854: x_source => 'BSC_UPDATE.Execute_Update_Process',
855: x_mode => 'I');
856: COMMIT;

Line 853: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_METADATA_PEND_CHANGES'),

849: -- Delete records in the temporal table used for big 'in' conditions
850: BSC_APPS.Init_Big_In_Cond_Table;
851:
852: BSC_MESSAGE.flush;
853: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_METADATA_PEND_CHANGES'),
854: x_source => 'BSC_UPDATE.Execute_Update_Process',
855: x_mode => 'I');
856: COMMIT;
857:

Line 876: BSC_MESSAGE.flush;

872:
873: -- Delete records in the temporal table used for big 'in' conditions
874: BSC_APPS.Init_Big_In_Cond_Table;
875:
876: BSC_MESSAGE.flush;
877: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED'),
878: x_source => 'BSC_UPDATE.Execute_Update_Process',
879: x_mode => 'I');
880: COMMIT;

Line 877: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED'),

873: -- Delete records in the temporal table used for big 'in' conditions
874: BSC_APPS.Init_Big_In_Cond_Table;
875:
876: BSC_MESSAGE.flush;
877: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED'),
878: x_source => 'BSC_UPDATE.Execute_Update_Process',
879: x_mode => 'I');
880: COMMIT;
881:

Line 901: BSC_MESSAGE.flush;

897: ROLLBACK;
898: -- Delete records in the temporal table used for big 'in' conditions
899: BSC_APPS.Init_Big_In_Cond_Table;
900:
901: BSC_MESSAGE.flush;
902: BSC_MESSAGE.Add(x_message => 'BSC_OLAP_MAIN.create_tmp_col_type_table '||h_error_message,
903: x_source => 'BSC_UPDATE.Execute_Update_Process',
904: x_mode => 'I');
905: COMMIT;

Line 902: BSC_MESSAGE.Add(x_message => 'BSC_OLAP_MAIN.create_tmp_col_type_table '||h_error_message,

898: -- Delete records in the temporal table used for big 'in' conditions
899: BSC_APPS.Init_Big_In_Cond_Table;
900:
901: BSC_MESSAGE.flush;
902: BSC_MESSAGE.Add(x_message => 'BSC_OLAP_MAIN.create_tmp_col_type_table '||h_error_message,
903: x_source => 'BSC_UPDATE.Execute_Update_Process',
904: x_mode => 'I');
905: COMMIT;
906:

Line 926: BSC_MESSAGE.flush;

922:
923: -- Delete records in the temporal table used for big 'in' conditions
924: BSC_APPS.Init_Big_In_Cond_Table;
925:
926: BSC_MESSAGE.flush;
927: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_DIM.Import_Dbi_Plans: '||h_error_message,
928: x_source => 'BSC_UPDATE.Execute_Update_Process',
929: x_mode => 'I');
930: COMMIT;

Line 927: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_DIM.Import_Dbi_Plans: '||h_error_message,

923: -- Delete records in the temporal table used for big 'in' conditions
924: BSC_APPS.Init_Big_In_Cond_Table;
925:
926: BSC_MESSAGE.flush;
927: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_DIM.Import_Dbi_Plans: '||h_error_message,
928: x_source => 'BSC_UPDATE.Execute_Update_Process',
929: x_mode => 'I');
930: COMMIT;
931:

Line 951: BSC_MESSAGE.flush;

947:
948: -- Delete records in the temporal table used for big 'in' conditions
949: BSC_APPS.Init_Big_In_Cond_Table;
950:
951: BSC_MESSAGE.flush;
952:
953: -- Error is already in the log file snet to the log file
954: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
955: x_source => 'BSC_UPDATE.Execute_Update_Process',

Line 954: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',

950:
951: BSC_MESSAGE.flush;
952:
953: -- Error is already in the log file snet to the log file
954: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
955: x_source => 'BSC_UPDATE.Execute_Update_Process',
956: x_mode => 'I');
957: COMMIT;
958:

Line 977: BSC_MESSAGE.flush;

973:
974: -- Delete records in the temporal table used for big 'in' conditions
975: BSC_APPS.Init_Big_In_Cond_Table;
976:
977: BSC_MESSAGE.flush;
978: BSC_MESSAGE.Add(x_message => SQLERRM,
979: x_source => 'BSC_UPDATE.Execute_Update_Process',
980: x_mode => 'I');
981: COMMIT;

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

974: -- Delete records in the temporal table used for big 'in' conditions
975: BSC_APPS.Init_Big_In_Cond_Table;
976:
977: BSC_MESSAGE.flush;
978: BSC_MESSAGE.Add(x_message => SQLERRM,
979: x_source => 'BSC_UPDATE.Execute_Update_Process',
980: x_mode => 'I');
981: COMMIT;
982:

Line 1590: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_YEARCHANGE_FAILED'),

1586:
1587: EXCEPTION
1588: WHEN e_unexpected_error THEN
1589: ROLLBACK;
1590: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_YEARCHANGE_FAILED'),
1591: x_source => 'BSC_UPDATE.Execute_Year_Change_Process');
1592:
1593: RETURN FALSE;
1594:

Line 1598: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',

1594:
1595: --LOCKING
1596: WHEN e_could_not_get_lock THEN
1597: ROLLBACK;
1598: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',
1599: x_source => 'BSC_UPDATE.Execute_Year_Change_Process');
1600:
1601: RETURN FALSE;
1602:

Line 1606: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,

1602:
1603: --LOCKING
1604: WHEN e_error_load_rpt_cal THEN
1605: ROLLBACK;
1606: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,
1607: x_source => 'BSC_UPDATE.Execute_Year_Change_Process');
1608:
1609: RETURN FALSE;
1610:

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

1609: RETURN FALSE;
1610:
1611: WHEN OTHERS THEN
1612: ROLLBACK;
1613: BSC_MESSAGE.Add (x_message => SQLERRM,
1614: x_source => 'BSC_UPDATE.Execute_Year_Change_Process');
1615:
1616: RETURN FALSE;
1617:

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

1672: RETURN h_res;
1673:
1674: EXCEPTION
1675: WHEN OTHERS THEN
1676: BSC_MESSAGE.Add(x_message => SQLERRM,
1677: x_source => 'BSC_UPDATE.Exists_Prototype_Indicators');
1678: RETURN NULL;
1679:
1680: END Exists_Prototype_Indicators;

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

1706: RETURN TRUE;
1707:
1708: EXCEPTION
1709: WHEN OTHERS THEN
1710: BSC_MESSAGE.Add(x_message => SQLERRM,
1711: x_source => 'BSC_UPDATE.Flag_Last_Stage_Input_Table');
1712: RETURN FALSE;
1713:
1714: END Flag_Last_Stage_Input_Table;

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

1754: RETURN TRUE;
1755:
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: BSC_MESSAGE.Add(x_message => SQLERRM,
1759: x_source => 'BSC_UPDATE.Get_Base_Table_Of_Input_Table');
1760: RETURN FALSE;
1761:
1762: END Get_Base_Table_Of_Input_Table;

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

1814: RETURN TRUE;
1815:
1816: EXCEPTION
1817: WHEN OTHERS THEN
1818: BSC_MESSAGE.Add(x_message => SQLERRM,
1819: x_source => 'BSC_UPDATE.Get_EDW_Dims_In_Input_Tables');
1820: RETURN FALSE;
1821: END Get_EDW_Dims_In_Input_Tables;
1822:

Line 1890: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_COLORKPILIST_FAILED'),

1886:
1887: RETURN TRUE;
1888: EXCEPTION
1889: WHEN e_unexpected_error THEN
1890: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_COLORKPILIST_FAILED'),
1891: x_source => 'BSC_UPDATE.Get_Indicators_To_Color');
1892: RETURN FALSE;
1893:
1894: WHEN OTHERS THEN

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

1891: x_source => 'BSC_UPDATE.Get_Indicators_To_Color');
1892: RETURN FALSE;
1893:
1894: WHEN OTHERS THEN
1895: BSC_MESSAGE.Add(x_message => SQLERRM,
1896: x_source => 'BSC_UPDATE.Get_Indicators_To_Color');
1897: RETURN FALSE;
1898:
1899: END Get_Indicators_To_Color;

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

1937:
1938: RETURN TRUE;
1939: EXCEPTION
1940: WHEN OTHERS THEN
1941: BSC_MESSAGE.Add(x_message => SQLERRM,
1942: x_source => 'BSC_UPDATE.Get_Last_Stage_Input_Table');
1943: RETURN FALSE;
1944:
1945: END Get_Last_Stage_Input_Table;

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

2090: RETURN h_process_id;
2091:
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: BSC_MESSAGE.Add(x_message => SQLERRM,
2095: x_source => 'BSC_UPDATE.Get_Process_Id');
2096: RETURN NULL;
2097:
2098: END Get_Process_Id;

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

2138: RETURN TRUE;
2139:
2140: EXCEPTION
2141: WHEN OTHERS THEN
2142: BSC_MESSAGE.Add(x_message => SQLERRM,
2143: x_source => 'BSC_UPDATE.Get_Process_Input_Tables');
2144: RETURN FALSE;
2145:
2146: END Get_Process_Input_Tables;

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

2162: RETURN TRUE;
2163:
2164: EXCEPTION
2165: WHEN OTHERS THEN
2166: BSC_MESSAGE.Add(x_message => SQLERRM,
2167: x_source => 'BSC_UPDATE.Init_Env_Values');
2168: RETURN FALSE;
2169:
2170: END Init_Env_Values;

Line 2235: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',

2231:
2232: EXCEPTION
2233: --LOCKING
2234: WHEN e_could_not_get_lock THEN
2235: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',
2236: x_source => 'BSC_UPDATE.Import_ITables_From_DBSrc');
2237: RETURN FALSE;
2238:
2239: WHEN e_unexpected_error THEN

Line 2240: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_IMPORT_ITABLES_FAILED'),

2236: x_source => 'BSC_UPDATE.Import_ITables_From_DBSrc');
2237: RETURN FALSE;
2238:
2239: WHEN e_unexpected_error THEN
2240: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_IMPORT_ITABLES_FAILED'),
2241: x_source => 'BSC_UPDATE.Import_ITables_From_DBSrc');
2242: RETURN FALSE;
2243:
2244: WHEN OTHERS THEN

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

2241: x_source => 'BSC_UPDATE.Import_ITables_From_DBSrc');
2242: RETURN FALSE;
2243:
2244: WHEN OTHERS THEN
2245: BSC_MESSAGE.Add (x_message => SQLERRM,
2246: x_source => 'BSC_UPDATE.Import_ITables_From_DBSrc');
2247: RETURN FALSE;
2248: END Import_ITables_From_DBSrc;
2249:

Line 2370: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_IMPORT_ITABLES_FAILED'),

2366: RETURN TRUE;
2367:
2368: EXCEPTION
2369: WHEN e_unexpected_error THEN
2370: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_IMPORT_ITABLES_FAILED'),
2371: x_source => 'BSC_UPDATE.Import_ITable_StoredProc');
2372: RETURN FALSE;
2373:
2374: WHEN OTHERS THEN

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

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

Line 2464: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_TABLES_INSERT_FAILED'),

2460: RETURN TRUE;
2461:
2462: EXCEPTION
2463: WHEN e_unexpected_error THEN
2464: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_TABLES_INSERT_FAILED'),
2465: x_source => 'BSC_UPDATE.Insert_Affected_Tables');
2466: RETURN FALSE;
2467:
2468: WHEN OTHERS THEN

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

2465: x_source => 'BSC_UPDATE.Insert_Affected_Tables');
2466: RETURN FALSE;
2467:
2468: WHEN OTHERS THEN
2469: BSC_MESSAGE.Add(x_message => SQLERRM,
2470: x_source => 'BSC_UPDATE.Insert_Affected_Tables');
2471: RETURN FALSE;
2472:
2473: END Insert_Affected_Tables;

Line 2723: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',

2719: EXCEPTION
2720: --LOCKING
2721: WHEN e_could_not_get_lock THEN
2722: ROLLBACK;
2723: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',
2724: x_source => 'BSC_UPDATE.Load_Dim_Input_Tables');
2725: h_b := Update_Status_All_Input_Tables(LC_RUNNING_STATUS, LC_ERROR_STATUS, LC_PROGRAM_ERR);
2726: COMMIT;
2727:

Line 2732: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATE_FAILED'),

2728: RETURN FALSE;
2729:
2730: WHEN e_unexpected_error THEN
2731: ROLLBACK;
2732: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATE_FAILED'),
2733: x_source => 'BSC_UPDATE.Load_Dim_Input_Tables');
2734: h_b := Update_Status_All_Input_Tables(LC_RUNNING_STATUS, LC_ERROR_STATUS, LC_PROGRAM_ERR);
2735: COMMIT;
2736:

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

2737: RETURN FALSE;
2738:
2739: WHEN OTHERS THEN
2740: ROLLBACK;
2741: BSC_MESSAGE.Add (x_message => SQLERRM,
2742: x_source => 'BSC_UPDATE.Load_Dim_Input_Tables');
2743:
2744: h_b := Update_Status_All_Input_Tables(LC_RUNNING_STATUS, LC_ERROR_STATUS, LC_PROGRAM_ERR);
2745: COMMIT;

Line 2823: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATE_FAILED'),

2819: RETURN TRUE;
2820: EXCEPTION
2821: WHEN e_unexpected_error THEN
2822: ROLLBACK;
2823: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATE_FAILED'),
2824: x_source => 'BSC_UPDATE.Load_Dims_Into_AW');
2825: RETURN FALSE;
2826:
2827: WHEN OTHERS THEN

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

2825: RETURN FALSE;
2826:
2827: WHEN OTHERS THEN
2828: ROLLBACK;
2829: BSC_MESSAGE.Add (x_message => SQLERRM,
2830: x_source => 'BSC_UPDATE.Load_Dims_Into_AW');
2831: RETURN FALSE;
2832: END Load_Dims_Into_AW;
2833:

Line 2850: BSC_MESSAGE.Add( x_message => SQLERRM

2846: RETURN TRUE;
2847:
2848: EXCEPTION
2849: WHEN OTHERS THEN
2850: BSC_MESSAGE.Add( x_message => SQLERRM
2851: , x_source => 'BSC_UPDATE.Update_Kpis_Prototype_Flag');
2852: RETURN FALSE;
2853: END Update_Kpis_Prototype_Flag;
2854:

Line 3652: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATE_FAILED'),

3648: RETURN TRUE;
3649: EXCEPTION
3650: WHEN e_unexpected_error THEN
3651: ROLLBACK;
3652: BSC_MESSAGE.Add (x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATE_FAILED'),
3653: x_source => 'BSC_UPDATE.Process_Input_Tables');
3654: IF x_start_from = 0 THEN
3655: h_b := Update_Status_All_Input_Tables(LC_RUNNING_STATUS, LC_ERROR_STATUS, LC_PROGRAM_ERR);
3656: COMMIT;

Line 3664: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',

3660:
3661: --LOCKING
3662: WHEN e_could_not_get_lock THEN
3663: ROLLBACK;
3664: BSC_MESSAGE.Add (x_message => 'Loader could not get the required locks to continue.',
3665: x_source => 'BSC_UPDATE.Process_Input_Tables');
3666: IF x_start_from = 0 THEN
3667: h_b := Update_Status_All_Input_Tables(LC_RUNNING_STATUS, LC_ERROR_STATUS, LC_PROGRAM_ERR);
3668: COMMIT;

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

3671: RETURN FALSE;
3672:
3673: WHEN OTHERS THEN
3674: ROLLBACK;
3675: BSC_MESSAGE.Add (x_message => SQLERRM,
3676: x_source => 'BSC_UPDATE.Process_Input_Tables');
3677:
3678: IF x_start_from = 0 THEN
3679: h_b := Update_Status_All_Input_Tables(LC_RUNNING_STATUS, LC_ERROR_STATUS, LC_PROGRAM_ERR);

Line 3841: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',

3837:
3838: EXCEPTION
3839: --LOCKING
3840: WHEN e_could_not_get_lock THEN
3841: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
3842: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3843: RETURN FALSE;
3844:
3845: WHEN e_unexpected_error THEN

Line 3846: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATE_FAILED'),

3842: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3843: RETURN FALSE;
3844:
3845: WHEN e_unexpected_error THEN
3846: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATE_FAILED'),
3847: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3848: RETURN FALSE;
3849:
3850: WHEN e_error_refresh THEN

Line 3851: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||mv_name||' '||h_error_refresh,

3847: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3848: RETURN FALSE;
3849:
3850: WHEN e_error_refresh THEN
3851: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||mv_name||' '||h_error_refresh,
3852: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3853: RETURN FALSE;
3854:
3855: WHEN e_error_refresh_zero THEN

Line 3856: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,

3852: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3853: RETURN FALSE;
3854:
3855: WHEN e_error_refresh_zero THEN
3856: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,
3857: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3858: RETURN FALSE;
3859:
3860: WHEN OTHERS THEN

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

3857: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3858: RETURN FALSE;
3859:
3860: WHEN OTHERS THEN
3861: BSC_MESSAGE.Add(x_message => SQLERRM,
3862: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3863: RETURN FALSE;
3864: END Refresh_System_MVs;
3865:

Line 3972: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATE_FAILED'),

3968: RETURN TRUE;
3969:
3970: EXCEPTION
3971: WHEN e_unexpected_error THEN
3972: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPDATE_FAILED'),
3973: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3974: RETURN FALSE;
3975:
3976: WHEN e_error_refresh THEN

Line 3977: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||mv_name||' '||h_error_refresh,

3973: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3974: RETURN FALSE;
3975:
3976: WHEN e_error_refresh THEN
3977: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||mv_name||' '||h_error_refresh,
3978: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3979: RETURN FALSE;
3980:
3981: WHEN e_error_refresh_zero THEN

Line 3982: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,

3978: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3979: RETURN FALSE;
3980:
3981: WHEN e_error_refresh_zero THEN
3982: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,
3983: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3984: RETURN FALSE;
3985:
3986: WHEN OTHERS THEN

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

3983: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3984: RETURN FALSE;
3985:
3986: WHEN OTHERS THEN
3987: BSC_MESSAGE.Add(x_message => SQLERRM,
3988: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3989: RETURN FALSE;
3990: END Refresh_System_MVs_Mig;
3991:

Line 4034: BSC_MESSAGE.Init(g_debug_flag);

4030: FND_MSG_PUB.Initialize;
4031:
4032: -- Initializes the error message stack
4033: g_debug_flag := 'NO';
4034: BSC_MESSAGE.Init(g_debug_flag);
4035:
4036: -- Check system lock
4037: --LOCKING: Do not use BSC_SECURITY.
4038: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);

Line 4042: --FROM bsc_message_logs

4038: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4039: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4040: --SELECT count(*)
4041: --INTO h_count
4042: --FROM bsc_message_logs
4043: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4044: --IF h_count > 0 THEN
4045: -- RAISE e_system_lock;
4046: --END IF;

Line 4066: FROM bsc_message_logs

4062: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4063:
4064: SELECT count(*)
4065: INTO h_count
4066: FROM bsc_message_logs
4067: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4068:
4069: IF h_count > 0 THEN
4070: RAISE e_update_error;

Line 4093: BSC_MESSAGE.Add(

4089:
4090: EXCEPTION
4091: WHEN e_system_lock THEN
4092: --LOCKING: h_msg_data has the error message
4093: BSC_MESSAGE.Add(
4094: X_Message => h_msg_data,
4095: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4096: X_Mode => 'I'
4097: );

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

4123: ERRBUF := '';
4124: RETCODE := 1; -- Request completed with warning
4125:
4126: WHEN OTHERS THEN
4127: BSC_MESSAGE.Add(x_message => SQLERRM,
4128: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4129: x_mode => 'I');
4130: COMMIT;
4131:

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

4155: )IS
4156: Begin
4157: Run_Concurrent_Loader_Apps(ERRBUF,RETCODE,x_process_id,'N');
4158: EXCEPTION when others then
4159: BSC_MESSAGE.Add(x_message => SQLERRM,
4160: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4161: x_mode => 'I');
4162: COMMIT;
4163:

Line 4219: BSC_MESSAGE.Init(g_debug_flag);

4215: FND_MSG_PUB.Initialize;
4216:
4217: -- Initializes the error message stack
4218: g_debug_flag := 'NO';
4219: BSC_MESSAGE.Init(g_debug_flag);
4220:
4221: -- Check system lock
4222: --LOCKING: Do not use BSC_SECURITY.
4223: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);

Line 4227: --FROM bsc_message_logs

4223: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4224: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4225: --SELECT count(*)
4226: --INTO h_count
4227: --FROM bsc_message_logs
4228: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4229: --IF h_count > 0 THEN
4230: -- RAISE e_system_lock;
4231: --END IF;

Line 4285: -- clean bsc_message_logs

4281: end if;
4282: end if;
4283: end if;
4284:
4285: -- clean bsc_message_logs
4286: BSC_MESSAGE.Clean;
4287:
4288: -- Run loader
4289: Execute_Update_Process(TO_NUMBER(x_process_id), PC_LOADER_PROCESS, NULL);

Line 4286: BSC_MESSAGE.Clean;

4282: end if;
4283: end if;
4284:
4285: -- clean bsc_message_logs
4286: BSC_MESSAGE.Clean;
4287:
4288: -- Run loader
4289: Execute_Update_Process(TO_NUMBER(x_process_id), PC_LOADER_PROCESS, NULL);
4290:

Line 4295: ' FROM bsc_message_logs'||

4291: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4292:
4293: /*
4294: h_sql := 'SELECT count(*)'||
4295: ' FROM bsc_message_logs'||
4296: ' WHERE type = :1'||
4297: ' AND UPPER(source) = :2 AND last_update_login = :3';
4298: OPEN h_cursor FOR h_sql USING 0, h_source, h_sessionid;
4299: FETCH h_cursor INTO h_count;

Line 4304: FROM bsc_message_logs

4300: CLOSE h_cursor;
4301: */
4302: SELECT count(*)
4303: INTO h_count
4304: FROM bsc_message_logs
4305: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4306:
4307: IF h_count > 0 THEN
4308: RAISE e_update_error;

Line 4339: BSC_MESSAGE.Add(

4335:
4336: EXCEPTION
4337: WHEN e_system_lock THEN
4338: --LOCKING: h_msg_data has the error message
4339: BSC_MESSAGE.Add(
4340: X_Message => h_msg_data,
4341: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4342: X_Mode => 'I'
4343: );

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

4369: ERRBUF := '';
4370: RETCODE := 1; -- Request completed with warning
4371:
4372: WHEN OTHERS THEN
4373: BSC_MESSAGE.Add(x_message => SQLERRM,
4374: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4375: x_mode => 'I');
4376: COMMIT;
4377:

Line 4434: BSC_MESSAGE.Init(g_debug_flag);

4430: FND_MSG_PUB.Initialize;
4431:
4432: -- Initializes the error message stack
4433: g_debug_flag := 'NO';
4434: BSC_MESSAGE.Init(g_debug_flag);
4435:
4436: -- Check system lock
4437: --LOCKING: Do not use BSC_SECURITY.
4438: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);

Line 4442: --FROM bsc_message_logs

4438: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4439: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4440: --SELECT count(*)
4441: --INTO h_count
4442: --FROM bsc_message_logs
4443: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4444: --IF h_count > 0 THEN
4445: -- RAISE e_system_lock;
4446: --END IF;

Line 4467: ' FROM bsc_message_logs'||

4463: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4464:
4465: /*
4466: h_sql := 'SELECT count(*)'||
4467: ' FROM bsc_message_logs'||
4468: ' WHERE type = :1'||
4469: ' AND UPPER(source) = :2 AND last_update_login = :3';
4470: OPEN h_cursor FOR h_sql USING 0, h_source, h_sessionid;
4471: FETCH h_cursor INTO h_count;

Line 4476: FROM bsc_message_logs

4472: CLOSE h_cursor;
4473: */
4474: SELECT count(*)
4475: INTO h_count
4476: FROM bsc_message_logs
4477: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = h_sessionid;
4478:
4479: IF h_count > 0 THEN
4480: RAISE e_update_error;

Line 4511: BSC_MESSAGE.Add(

4507:
4508: EXCEPTION
4509: WHEN e_system_lock THEN
4510: --LOCKING: h_msg_data has the error message
4511: BSC_MESSAGE.Add(
4512: X_Message => h_msg_data,
4513: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4514: X_Mode => 'I'
4515: );

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

4541: ERRBUF := '';
4542: RETCODE := 1; -- Request completed with warning
4543:
4544: WHEN OTHERS THEN
4545: BSC_MESSAGE.Add(x_message => SQLERRM,
4546: x_source => 'BSC_UPDATE.Run_Concurrent_Loader_Dim_Apps',
4547: x_mode => 'I');
4548: COMMIT;
4549:

Line 4602: BSC_MESSAGE.Init(g_debug_flag);

4598: FND_MSG_PUB.Initialize;
4599:
4600: -- Initializes the error message stack
4601: g_debug_flag := 'NO';
4602: BSC_MESSAGE.Init(g_debug_flag);
4603:
4604: -- Initializes g_session_id, g_user_id and g_schema_name
4605: IF NOT Init_Env_Values THEN
4606: RAISE e_update_error;

Line 4620: --FROM bsc_message_logs

4616: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4617: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4618: --SELECT count(*)
4619: --INTO h_count
4620: --FROM bsc_message_logs
4621: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4622: --IF h_count > 0 THEN
4623: -- RAISE e_system_lock;
4624: --END IF;

Line 4645: FROM bsc_message_logs

4641: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4642:
4643: SELECT count(*)
4644: INTO h_count
4645: FROM bsc_message_logs
4646: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4647:
4648: IF h_count > 0 THEN
4649: RAISE e_update_error;

Line 4658: BSC_MESSAGE.Add(

4654:
4655: EXCEPTION
4656: WHEN e_system_lock THEN
4657: --LOCKING: h_msg_data has the error message
4658: BSC_MESSAGE.Add(
4659: X_Message => h_msg_data,
4660: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4661: X_Mode => 'I'
4662: );

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

4681: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4682: RETCODE := 2; -- Request completed with errors
4683:
4684: WHEN OTHERS THEN
4685: BSC_MESSAGE.Add(x_message => SQLERRM,
4686: x_source => 'BSC_UPDATE.Run_change_current_year',
4687: x_mode => 'I');
4688: COMMIT;
4689:

Line 4780: BSC_MESSAGE.Init(g_debug_flag);

4776: FND_MSG_PUB.Initialize;
4777:
4778: -- Initializes the error message stack
4779: g_debug_flag := 'NO';
4780: BSC_MESSAGE.Init(g_debug_flag);
4781:
4782: -- Initialize the temporal table used for big 'in' conditions
4783: BSC_APPS.Init_Big_In_Cond_Table;
4784:

Line 4801: --FROM bsc_message_logs

4797: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
4798: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
4799: --SELECT count(*)
4800: --INTO h_count
4801: --FROM bsc_message_logs
4802: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4803: --IF h_count > 0 THEN
4804: -- RAISE e_system_lock;
4805: --END IF;

Line 4911: FROM bsc_message_logs

4907: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
4908:
4909: SELECT count(*)
4910: INTO h_count
4911: FROM bsc_message_logs
4912: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
4913:
4914: IF h_count > 0 THEN
4915: RAISE e_update_error;

Line 4938: BSC_MESSAGE.Add(

4934:
4935: EXCEPTION
4936: WHEN e_system_lock THEN
4937: --LOCKING: h_msg_data has the error message
4938: BSC_MESSAGE.Add(
4939: X_Message => h_msg_data,
4940: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
4941: X_Mode => 'I'
4942: );

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

4985: --Fix bug#3923207: import dbi plans was moved to execute_update_process
4986: --WHEN e_import_dbi_plans THEN
4987:
4988: WHEN OTHERS THEN
4989: BSC_MESSAGE.Add(x_message => SQLERRM,
4990: x_source => 'BSC_UPDATE.Load_Indicators_Data',
4991: x_mode => 'I');
4992: COMMIT;
4993:

Line 5068: BSC_MESSAGE.Init(g_debug_flag);

5064: FND_MSG_PUB.Initialize;
5065:
5066: -- Initializes the error message stack
5067: g_debug_flag := 'NO';
5068: BSC_MESSAGE.Init(g_debug_flag);
5069:
5070: -- Initialize the temporal table used for big 'in' conditions
5071: BSC_APPS.Init_Big_In_Cond_Table;
5072:

Line 5089: --FROM bsc_message_logs

5085: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
5086: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
5087: --SELECT count(*)
5088: --INTO h_count
5089: --FROM bsc_message_logs
5090: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5091: --IF h_count > 0 THEN
5092: -- RAISE e_system_lock;
5093: --END IF;

Line 5228: FROM bsc_message_logs

5224: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
5225:
5226: SELECT count(*)
5227: INTO h_count
5228: FROM bsc_message_logs
5229: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5230:
5231: IF h_count > 0 THEN
5232: RAISE e_update_error;

Line 5255: BSC_MESSAGE.Add(

5251:
5252: EXCEPTION
5253: WHEN e_system_lock THEN
5254: --LOCKING: h_msg_data has the error message
5255: BSC_MESSAGE.Add(
5256: X_Message => h_msg_data,
5257: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
5258: X_Mode => 'I'
5259: );

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

5296: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
5297: RETCODE := 2; -- Request completed with errors
5298:
5299: WHEN OTHERS THEN
5300: BSC_MESSAGE.Add(x_message => SQLERRM,
5301: x_source => 'BSC_UPDATE.Load_Indicators_Dims',
5302: x_mode => 'I');
5303: COMMIT;
5304:

Line 5363: BSC_MESSAGE.Init(g_debug_flag);

5359: FND_MSG_PUB.Initialize;
5360:
5361: -- Initializes the error message stack
5362: g_debug_flag := 'NO';
5363: BSC_MESSAGE.Init(g_debug_flag);
5364:
5365: -- Initialize the temporal table used for big 'in' conditions
5366: BSC_APPS.Init_Big_In_Cond_Table;
5367:

Line 5379: --FROM bsc_message_logs

5375: --BSC_SECURITY.Check_System_Lock(-101, NULL, BSC_APPS.apps_user_id);
5376: --h_source := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
5377: --SELECT count(*)
5378: --INTO h_count
5379: --FROM bsc_message_logs
5380: --WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5381: --IF h_count > 0 THEN
5382: -- RAISE e_system_lock;
5383: --END IF;

Line 5447: FROM bsc_message_logs

5443: h_source := 'BSC_UPDATE.EXECUTE_UPDATE_PROCESS';
5444:
5445: SELECT count(*)
5446: INTO h_count
5447: FROM bsc_message_logs
5448: WHERE type = 0 AND UPPER(source) = h_source AND last_update_login = g_session_id;
5449:
5450: IF h_count > 0 THEN
5451: RAISE e_update_error;

Line 5460: BSC_MESSAGE.Add(

5456:
5457: EXCEPTION
5458: WHEN e_system_lock THEN
5459: --LOCKING: h_msg_data has the error message
5460: BSC_MESSAGE.Add(
5461: X_Message => h_msg_data,
5462: X_Source => 'BSC_UPDATE.Run_Concurrent_Loader_Apps',
5463: X_Mode => 'I'
5464: );

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

5482: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
5483: RETCODE := 2; -- Request completed with errors
5484:
5485: WHEN OTHERS THEN
5486: BSC_MESSAGE.Add(x_message => SQLERRM,
5487: x_source => 'BSC_UPDATE.Delete_Indicators_Data',
5488: x_mode => 'I');
5489: COMMIT;
5490:

Line 5564: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),

5560: RETURN TRUE;
5561:
5562: EXCEPTION
5563: WHEN e_unexpected_error THEN
5564: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),
5565: x_source => 'BSC_UPDATE.Get_Input_Tables_Kpis');
5566: RETURN FALSE;
5567:
5568: WHEN OTHERS THEN

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

5565: x_source => 'BSC_UPDATE.Get_Input_Tables_Kpis');
5566: RETURN FALSE;
5567:
5568: WHEN OTHERS THEN
5569: BSC_MESSAGE.Add(x_message => SQLERRM,
5570: x_source => 'BSC_UPDATE.Get_Input_Tables_Kpis');
5571: RETURN FALSE;
5572:
5573: END Get_Input_Tables_Kpis;

Line 5596: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),

5592: end loop;
5593: return true;
5594: EXCEPTION
5595: WHEN e_unexpected_error THEN
5596: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),
5597: x_source => 'BSC_UPDATE.get_kpi_for_input_tables');
5598: RETURN FALSE;
5599:
5600: WHEN OTHERS THEN

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

5597: x_source => 'BSC_UPDATE.get_kpi_for_input_tables');
5598: RETURN FALSE;
5599:
5600: WHEN OTHERS THEN
5601: BSC_MESSAGE.Add(x_message => SQLERRM,
5602: x_source => 'BSC_UPDATE.get_kpi_for_input_tables');
5603: RETURN FALSE;
5604:
5605: END get_kpi_for_input_tables;

Line 5738: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),

5734: RETURN TRUE;
5735:
5736: EXCEPTION
5737: WHEN e_unexpected_error THEN
5738: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),
5739: x_source => 'BSC_UPDATE.Get_Dim_Input_Tables_Kpis');
5740: RETURN FALSE;
5741:
5742: WHEN OTHERS THEN

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

5739: x_source => 'BSC_UPDATE.Get_Dim_Input_Tables_Kpis');
5740: RETURN FALSE;
5741:
5742: WHEN OTHERS THEN
5743: BSC_MESSAGE.Add(x_message => SQLERRM,
5744: x_source => 'BSC_UPDATE.Get_Dim_Input_Tables_Kpis');
5745: RETURN FALSE;
5746:
5747: END Get_Dim_Input_Tables_Kpis;

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

5768: RETURN TRUE;
5769:
5770: EXCEPTION
5771: WHEN OTHERS THEN
5772: BSC_MESSAGE.Add(x_message => SQLERRM,
5773: x_source => 'BSC_UPDATE.Set_PStatus_Finished');
5774: RETURN FALSE;
5775:
5776: END Set_PStatus_Finished;

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

5805: RETURN TRUE;
5806:
5807: EXCEPTION
5808: WHEN OTHERS THEN
5809: BSC_MESSAGE.Add(x_message => SQLERRM,
5810: x_source => 'BSC_UPDATE.Set_PStatus_Running');
5811: RETURN FALSE;
5812:
5813: END Set_PStatus_Running;

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

5843: RETURN TRUE;
5844:
5845: EXCEPTION
5846: WHEN OTHERS THEN
5847: BSC_MESSAGE.Add(x_message => SQLERRM,
5848: x_source => 'BSC_UPDATE.Update_Indicator_Period');
5849: RETURN FALSE;
5850:
5851: END Update_Indicator_Period;

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

5883: RETURN TRUE;
5884:
5885: EXCEPTION
5886: WHEN OTHERS THEN
5887: BSC_MESSAGE.Add(x_message => SQLERRM,
5888: x_source => 'BSC_UPDATE.Update_Indicators_Periods');
5889: RETURN FALSE;
5890:
5891: END Update_Indicators_Periods;

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

5910: RETURN TRUE;
5911:
5912: EXCEPTION
5913: WHEN OTHERS THEN
5914: BSC_MESSAGE.Add(x_message => SQLERRM,
5915: x_source => 'BSC_UPDATE.Update_Stage_Input_Table');
5916: RETURN FALSE;
5917:
5918: END Update_Stage_Input_Table;

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

5966: RETURN TRUE;
5967:
5968: EXCEPTION
5969: WHEN OTHERS THEN
5970: BSC_MESSAGE.Add(x_message => SQLERRM,
5971: x_source => 'BSC_UPDATE.Update_Stage_Input_Tables');
5972: RETURN FALSE;
5973:
5974: END Update_Stage_Input_Tables;

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

5995: RETURN TRUE;
5996:
5997: EXCEPTION
5998: WHEN OTHERS THEN
5999: BSC_MESSAGE.Add(x_message => SQLERRM,
6000: x_source => 'BSC_UPDATE.Update_Status_All_Input_Tables');
6001: RETURN FALSE;
6002:
6003: END Update_Status_All_Input_Tables;

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

6024: RETURN TRUE;
6025:
6026: EXCEPTION
6027: WHEN OTHERS THEN
6028: BSC_MESSAGE.Add(x_message => SQLERRM,
6029: x_source => 'BSC_UPDATE.Update_Status_Input_Table');
6030: RETURN FALSE;
6031:
6032: END Update_Status_Input_Table;

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

6064: RETURN TRUE;
6065:
6066: EXCEPTION
6067: WHEN OTHERS THEN
6068: BSC_MESSAGE.Add(x_message => SQLERRM,
6069: x_source => 'BSC_UPDATE.Wait_For_Requests');
6070: RETURN FALSE;
6071: END Wait_For_Requests;
6072:

Line 6291: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WR_LOGFILE_RES_FAILED'),

6287: RETURN TRUE;
6288:
6289: EXCEPTION
6290: WHEN e_unexpected_error THEN
6291: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WR_LOGFILE_RES_FAILED'),
6292: x_source => 'BSC_UPDATE.Write_Result_Log');
6293: RETURN FALSE;
6294:
6295: WHEN OTHERS THEN

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

6292: x_source => 'BSC_UPDATE.Write_Result_Log');
6293: RETURN FALSE;
6294:
6295: WHEN OTHERS THEN
6296: BSC_MESSAGE.Add(x_message => SQLERRM,
6297: x_source => 'BSC_UPDATE.Write_Result_Log');
6298: RETURN FALSE;
6299:
6300: END Write_Result_Log;