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

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

123: CLOSE c_new_per;
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: BSC_MESSAGE.Add(x_message => SQLERRM,
128: x_source => 'BSC_UPDATE_UTIL.CloneBSCPeriodicitybyCalendar',
129: x_mode => 'I');
130: COMMIT;
131: END CloneBSCPeriodicitybyCalendar;

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

195: RETURN TRUE;
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: BSC_MESSAGE.Add(x_message => SQLERRM,
200: x_source => 'BSC_UPDATE_UTIL.Create_Unique_Index');
201: RETURN FALSE;
202:
203: END Create_Unique_Index;

Line 339: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,

335: exit;
336: exception
337: when others then
338: if h_lst_cols_index is null then
339: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,
340: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
341: BSC_MESSAGE.Add(x_message => 'l_index_count=0.Unable to create Index on any Key columns',
342: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
343: RETURN FALSE;

Line 341: BSC_MESSAGE.Add(x_message => 'l_index_count=0.Unable to create Index on any Key columns',

337: when others then
338: if h_lst_cols_index is null then
339: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,
340: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
341: BSC_MESSAGE.Add(x_message => 'l_index_count=0.Unable to create Index on any Key columns',
342: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
343: RETURN FALSE;
344: end if;
345: h_lst_cols_index:=getSmallerColumnList(h_lst_cols_index);

Line 382: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,

378: RETURN TRUE;
379:
380: EXCEPTION
381: WHEN OTHERS THEN
382: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,
383: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
384: BSC_MESSAGE.Add(x_message => SQLERRM,
385: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
386: RETURN FALSE;

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

380: EXCEPTION
381: WHEN OTHERS THEN
382: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,
383: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
384: BSC_MESSAGE.Add(x_message => SQLERRM,
385: x_source => 'BSC_UPDATE_UTIL.Create_Global_Temp_Table');
386: RETURN FALSE;
387:
388: END Create_Global_Temp_Table;

Line 514: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,

510: RETURN TRUE;
511:
512: EXCEPTION
513: WHEN OTHERS THEN
514: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,
515: x_source => 'BSC_UPDATE_UTIL.Create_Permanent_Table');
516: BSC_MESSAGE.Add(x_message => SQLERRM,
517: x_source => 'BSC_UPDATE_UTIL.Create_Permanent_Table');
518: RETURN FALSE;

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

512: EXCEPTION
513: WHEN OTHERS THEN
514: BSC_MESSAGE.Add(x_message => 'x_table_name='||x_table_name,
515: x_source => 'BSC_UPDATE_UTIL.Create_Permanent_Table');
516: BSC_MESSAGE.Add(x_message => SQLERRM,
517: x_source => 'BSC_UPDATE_UTIL.Create_Permanent_Table');
518: RETURN FALSE;
519:
520: END Create_Permanent_Table;

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

667: RETURN TRUE;
668:
669: EXCEPTION
670: WHEN OTHERS THEN
671: BSC_MESSAGE.Add(x_message => SQLERRM,
672: x_source => 'BSC_UPDATE_UTIL.Drop_Index');
673: RETURN FALSE;
674: END Drop_Index;
675:

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

696: RETURN TRUE;
697:
698: EXCEPTION
699: WHEN OTHERS THEN
700: BSC_MESSAGE.Add(x_message => SQLERRM,
701: x_source => 'BSC_UPDATE_UTIL.Drop_Table');
702: RETURN FALSE;
703: END Drop_Table;
704:

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

2067: RETURN TRUE;
2068:
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071: BSC_MESSAGE.Add(x_message => SQLERRM,
2072: x_source => 'BSC_UPDATE_UTIL.Get_Calendar_Start_Date');
2073: RETURN FALSE;
2074: END Get_Calendar_Start_Date;
2075:

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

2324: RETURN TRUE;
2325:
2326: EXCEPTION
2327: WHEN OTHERS THEN
2328: BSC_MESSAGE.Add(x_message => SQLERRM,
2329: x_source => 'BSC_UPDATE_UTIL.Get_Indic_Range_Of_Years');
2330: RETURN FALSE;
2331:
2332: END Get_Indic_Range_Of_Years;

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

2397: RETURN TRUE;
2398:
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: BSC_MESSAGE.Add(x_message => SQLERRM,
2402: x_source => 'BSC_UPDATE_UTIL.Get_Information_Data_Columns');
2403: RETURN FALSE;
2404:
2405: END Get_Information_Data_Columns;

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

2464: RETURN TRUE;
2465:
2466: EXCEPTION
2467: WHEN OTHERS THEN
2468: BSC_MESSAGE.Add(x_message => SQLERRM,
2469: x_source => 'BSC_UPDATE_UTIL.Get_Information_Key_Columns');
2470: RETURN FALSE;
2471:
2472: END Get_Information_Key_Columns;

Line 2501: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WARNING')||' '||h_message,

2497: FETCH c_init INTO x_variable_value;
2498: IF c_init%NOTFOUND THEN
2499: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_VAR_NOT_FOUND');
2500: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'VARIABLE', x_variable_name);
2501: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WARNING')||' '||h_message,
2502: x_source => 'BSC_UPDATE_UTIL.Get_Init_Variable_Value');
2503: x_variable_value := NULL;
2504: END IF;
2505: CLOSE c_init;

Line 2516: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WARNING')||' '||h_message,

2512: EXCEPTION
2513: WHEN NO_DATA_FOUND THEN
2514: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_VAR_NOT_FOUND');
2515: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'VARIABLE', x_variable_name);
2516: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_WARNING')||' '||h_message,
2517: x_source => 'BSC_UPDATE_UTIL.Get_Init_Variable_Value');
2518: x_variable_value := NULL;
2519: END;
2520:

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

2521: RETURN TRUE;
2522:
2523: EXCEPTION
2524: WHEN OTHERS THEN
2525: BSC_MESSAGE.Add(x_message => SQLERRM,
2526: x_source => 'BSC_UPDATE_UTIL.Get_Init_Variable_Value');
2527: RETURN FALSE;
2528:
2529: END Get_Init_Variable_Value;

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

2557: RETURN TRUE;
2558:
2559: EXCEPTION
2560: WHEN OTHERS THEN
2561: BSC_MESSAGE.Add(x_message => SQLERRM,
2562: x_source => 'BSC_UPDATE_UTIL.Get_Input_Table_Source');
2563: RETURN FALSE;
2564: END Get_Input_Table_Source;
2565:

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

2609: RETURN h_num_languages;
2610:
2611: EXCEPTION
2612: WHEN OTHERS THEN
2613: BSC_MESSAGE.Add(x_message => SQLERRM,
2614: x_source => 'BSC_UPDATE_UTIL.Get_Installed_Languages');
2615: RETURN -1;
2616:
2617: END Get_Installed_Languages;

Line 2649: BSC_MESSAGE.Add(x_message => h_message,

2645: IF c_lookup_value%NOTFOUND THEN
2646: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_MISSING_LOOKUP_VALUES');
2647: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'LOOKUP_TYPE', x_lookup_type);
2648: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'LOOKUP_CODE', x_lookup_code);
2649: BSC_MESSAGE.Add(x_message => h_message,
2650: x_source => 'BSC_UPDATE_UTIL.Get_Lookup_Value');
2651: h_lookup_value := NULL;
2652: END IF;
2653: CLOSE c_lookup_value;

Line 2665: BSC_MESSAGE.Add(x_message => h_message,

2661: WHEN NO_DATA_FOUND THEN
2662: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_MISSING_LOOKUP_VALUES');
2663: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'LOOKUP_TYPE', x_lookup_type);
2664: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'LOOKUP_CODE', x_lookup_code);
2665: BSC_MESSAGE.Add(x_message => h_message,
2666: x_source => 'BSC_UPDATE_UTIL.Get_Lookup_Value');
2667: h_lookup_value := NULL;
2668: END;
2669:

Line 2687: ' FROM bsc_messages'||

2683:
2684: /*
2685: c_message t_cursor; -- x_message_name
2686: c_message_sql VARCHAR2(2000) := 'SELECT message_text'||
2687: ' FROM bsc_messages'||
2688: ' WHERE message_name = :1';
2689: */
2690:
2691: h_message VARCHAR2(4000);

Line 2705: FROM bsc_messages

2701: */
2702: BEGIN
2703: SELECT message_text
2704: INTO h_message
2705: FROM bsc_messages
2706: WHERE message_name = x_message_name;
2707: EXCEPTION
2708: WHEN NO_DATA_FOUND THEN
2709: h_message := NULL;

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

2767: RETURN h_num_periods;
2768:
2769: EXCEPTION
2770: WHEN OTHERS THEN
2771: BSC_MESSAGE.Add(x_message => SQLERRM,
2772: x_source => 'BSC_UPDATE_UTIL.Get_Num_Periods_Periodicity');
2773: RETURN NULL;
2774:
2775: END Get_Num_Periods_Periodicity;

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

2827: RETURN TRUE;
2828:
2829: EXCEPTION
2830: WHEN OTHERS THEN
2831: BSC_MESSAGE.Add(x_message => SQLERRM,
2832: x_source => 'BSC_UPDATE_UTIL.Get_Period_Cols_Names');
2833: RETURN FALSE;
2834:
2835: END Get_Period_Cols_Names;

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

3084: RETURN h_table_generation_type;
3085:
3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: BSC_MESSAGE.Add(x_message => SQLERRM,
3089: x_source => 'BSC_UPDATE_UTIL.Get_Table_Generation_Type');
3090: RETURN NULL;
3091:
3092: END Get_Table_Generation_Type;

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

3112: RETURN h_table_type;
3113:
3114: EXCEPTION
3115: WHEN OTHERS THEN
3116: BSC_MESSAGE.Add(x_message => SQLERRM,
3117: x_source => 'BSC_UPDATE_UTIL.Get_Table_Type');
3118: RETURN NULL;
3119:
3120: END Get_Table_Type;

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

3162: RETURN h_table_periodicity;
3163:
3164: EXCEPTION
3165: WHEN OTHERS THEN
3166: BSC_MESSAGE.Add(x_message => SQLERRM,
3167: x_source => 'BSC_UPDATE_UTIL.Get_Table_Periodicity');
3168: RETURN NULL;
3169:
3170: END Get_Table_Periodicity;

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

3202: RETURN TRUE;
3203:
3204: EXCEPTION
3205: WHEN OTHERS THEN
3206: BSC_MESSAGE.Add(x_message => SQLERRM,
3207: x_source => 'BSC_UPDATE_UTIL.Get_Table_Range_Of_Years');
3208: RETURN FALSE;
3209:
3210: END Get_Table_Range_Of_Years;

Line 3526: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INIT_FAILED'),

3522: RETURN TRUE;
3523:
3524: EXCEPTION
3525: WHEN e_unexpected_error THEN
3526: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INIT_FAILED'),
3527: x_source => 'BSC_UPDATE_UTIL.Init_Calendar_Tables');
3528: RETURN FALSE;
3529:
3530: WHEN OTHERS THEN

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

3527: x_source => 'BSC_UPDATE_UTIL.Init_Calendar_Tables');
3528: RETURN FALSE;
3529:
3530: WHEN OTHERS THEN
3531: BSC_MESSAGE.Add(x_message => SQLERRM,
3532: x_source => 'BSC_UPDATE_UTIL.Init_Calendar_Tables');
3533: RETURN FALSE;
3534:
3535: END Init_Calendar_Tables;

Line 3556: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INIT_FAILED'),

3552: RETURN TRUE;
3553:
3554: EXCEPTION
3555: WHEN e_unexpected_error THEN
3556: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INIT_FAILED'),
3557: x_source => 'BSC_UPDATE_UTIL.Init_Calendar_Tables');
3558: RETURN FALSE;
3559:
3560: WHEN OTHERS THEN

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

3557: x_source => 'BSC_UPDATE_UTIL.Init_Calendar_Tables');
3558: RETURN FALSE;
3559:
3560: WHEN OTHERS THEN
3561: BSC_MESSAGE.Add(x_message => SQLERRM,
3562: x_source => 'BSC_UPDATE_UTIL.Init_Calendar_Tables');
3563: RETURN FALSE;
3564:
3565: END Init_Calendar_Tables;

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

3811: RETURN TRUE;
3812:
3813: EXCEPTION
3814: WHEN OTHERS THEN
3815: BSC_MESSAGE.Add(x_message => SQLERRM,
3816: x_source => 'BSC_UPDATE_UTIL.Load_Periodicity_Rels');
3817: RETURN FALSE;
3818:
3819: END Load_Periodicity_Rels;

Line 4248: BSC_MESSAGE.Add(

4244: RETURN TRUE;
4245:
4246: EXCEPTION
4247: WHEN OTHERS THEN
4248: BSC_MESSAGE.Add(
4249: X_Message => SQLERRM,
4250: X_Source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Calendar');
4251: RETURN FALSE;
4252:

Line 4292: BSC_MESSAGE.Add(

4288: RETURN TRUE;
4289:
4290: EXCEPTION
4291: WHEN OTHERS THEN
4292: BSC_MESSAGE.Add(
4293: x_message => SQLERRM,
4294: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Db_Week_Maps');
4295: RETURN FALSE;
4296:

Line 4528: BSC_MESSAGE.Add(

4524: RETURN TRUE;
4525:
4526: EXCEPTION
4527: WHEN OTHERS THEN
4528: BSC_MESSAGE.Add(
4529: x_message => SQLERRM,
4530: x_source => 'BSC_UPDATE_UTIL.Populate_Bsc_Sys_Periods_Tl');
4531: RETURN FALSE;
4532:

Line 4583: BSC_MESSAGE.flush;

4579: END IF;
4580:
4581: EXCEPTION
4582: WHEN e_error THEN
4583: BSC_MESSAGE.flush;
4584: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_POP_FAILED'),
4585: x_source => 'BSC_UPDATE_UTIL.Populate_Calendar_Tables',
4586: x_mode => 'I');
4587: COMMIT;

Line 4584: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_POP_FAILED'),

4580:
4581: EXCEPTION
4582: WHEN e_error THEN
4583: BSC_MESSAGE.flush;
4584: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_POP_FAILED'),
4585: x_source => 'BSC_UPDATE_UTIL.Populate_Calendar_Tables',
4586: x_mode => 'I');
4587: COMMIT;
4588:

Line 4590: BSC_MESSAGE.flush;

4586: x_mode => 'I');
4587: COMMIT;
4588:
4589: WHEN e_error_load_rpt_cal THEN
4590: BSC_MESSAGE.flush;
4591: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,
4592: x_source => 'BSC_UPDATE_UTIL.Populate_Calendar_Tables',
4593: x_mode => 'I');
4594: COMMIT;

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

4587: COMMIT;
4588:
4589: WHEN e_error_load_rpt_cal THEN
4590: BSC_MESSAGE.flush;
4591: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,
4592: x_source => 'BSC_UPDATE_UTIL.Populate_Calendar_Tables',
4593: x_mode => 'I');
4594: COMMIT;
4595:

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

4593: x_mode => 'I');
4594: COMMIT;
4595:
4596: WHEN OTHERS THEN
4597: BSC_MESSAGE.Add(x_message => SQLERRM,
4598: x_source => 'BSC_UPDATE_UTIL.Populate_Calendar_Tables',
4599: x_mode => 'I');
4600: COMMIT;
4601: END Populate_Calendar_Tables;

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

4612: Populate_Calendar_Tables(x_calendar_id, NULL);
4613:
4614: EXCEPTION
4615: WHEN OTHERS THEN
4616: BSC_MESSAGE.Add(x_message => SQLERRM,
4617: x_source => 'BSC_UPDATE_UTIL.Populate_Calendar_Tables',
4618: x_mode => 'I');
4619: COMMIT;
4620: END Populate_Calendar_Tables;

Line 4763: BSC_MESSAGE.Add(

4759: RETURN TRUE;
4760:
4761: EXCEPTION
4762: WHEN OTHERS THEN
4763: BSC_MESSAGE.Add(
4764: X_Message => SQLERRM,
4765: X_Source => 'BSC_UPDATE_UTIL.Set_Calendar_Fiscal_Year');
4766: RETURN FALSE;
4767:

Line 4869: BSC_MESSAGE.Add(

4865: RETURN h_res;
4866:
4867: EXCEPTION
4868: WHEN OTHERS THEN
4869: BSC_MESSAGE.Add(
4870: X_Message => SQLERRM,
4871: X_Source => 'BSC_UPDATE_UTIL.Table_Has_Any_Row');
4872: RETURN NULL;
4873:

Line 4892: BSC_MESSAGE.Add(

4888: RETURN h_res;
4889:
4890: EXCEPTION
4891: WHEN OTHERS THEN
4892: BSC_MESSAGE.Add(
4893: X_Message => SQLERRM,
4894: X_Source => 'BSC_UPDATE_UTIL.Table_Has_Any_Row');
4895: RETURN NULL;
4896:

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

5034: CLOSE c_new_per;
5035:
5036: EXCEPTION
5037: WHEN OTHERS THEN
5038: BSC_MESSAGE.Add(x_message => SQLERRM,
5039: x_source => 'BSC_UPDATE_UTIL.UpdAnualPeriodicitySrc',
5040: x_mode => 'I');
5041: COMMIT;
5042: END Update_AnualPeriodicity_Src;

Line 5164: BSC_MESSAGE.Add(

5160: RETURN TRUE;
5161:
5162: EXCEPTION
5163: WHEN OTHERS THEN
5164: BSC_MESSAGE.Add(
5165: X_Message => SQLERRM,
5166: X_Source => 'BSC_UPDATE_UTIL.Update_Kpi_Period_Name');
5167: RETURN FALSE;
5168:

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

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

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

5973: RETURN TRUE;
5974:
5975: EXCEPTION
5976: WHEN OTHERS THEN
5977: BSC_MESSAGE.Add(x_message => SQLERRM,
5978: x_source => 'BSC_UPDATE_UTIL.Write_Init_Variable_Value');
5979: RETURN FALSE;
5980:
5981: END Write_Init_Variable_Value;

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

5989: g_parallel:=true;
5990: return g_parallel;
5991: EXCEPTION
5992: WHEN OTHERS THEN
5993: BSC_MESSAGE.Add(x_message => SQLERRM,
5994: x_source => 'BSC_UPDATE_UTIL.is_parallel');
5995: RETURN FALSE;
5996: END is_parallel;
5997:

Line 6030: BSC_MESSAGE.Add

6026: RETURN NULL;
6027: END IF;
6028: EXCEPTION
6029: WHEN OTHERS THEN
6030: BSC_MESSAGE.Add
6031: ( x_message => SQLERRM
6032: , x_source => 'BSC_UPDATE_UTIL.get_Product_Version'
6033: );
6034: RETURN NULL;

Line 6068: BSC_MESSAGE.Add

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

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

6243: WHEN OTHERS THEN
6244: IF c_dim_props%ISOPEN THEN
6245: CLOSE c_dim_props;
6246: END IF;
6247: BSC_MESSAGE.Add(x_message => SQLERRM,
6248: x_source => 'BSC_UPDATE_UTIL.Get_Kpi_Dim_Props');
6249: RAISE;
6250: END Get_Kpi_Dim_Props;
6251:

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

6296: WHEN OTHERS THEN
6297: IF c_measure_formula%ISOPEN THEN
6298: CLOSE c_measure_formula;
6299: END IF;
6300: BSC_MESSAGE.Add(x_message => SQLERRM,
6301: x_source => 'BSC_UPDATE_UTIL.get_kpi_measure_formula');
6302: RETURN NULL;
6303: END get_kpi_measure_formula;
6304:

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

6353: RETURN l_measure_formula;
6354:
6355: EXCEPTION
6356: WHEN OTHERS THEN
6357: BSC_MESSAGE.Add(x_message => SQLERRM,
6358: x_source => 'BSC_UPDATE_UTIL.Get_SimObj_Color_Formula');
6359: RETURN NULL;
6360: END Get_SimObj_Color_Formula;
6361:

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

6386: RETURN l_measure_formula;
6387:
6388: EXCEPTION
6389: WHEN OTHERS THEN
6390: BSC_MESSAGE.Add(x_message => SQLERRM,
6391: x_source => 'BSC_UPDATE_UTIL.Get_Measure_Formula');
6392: RETURN NULL;
6393: END Get_Measure_Formula;
6394:

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

6427: WHEN OTHERS THEN
6428: IF c_color_by_total%ISOPEN THEN
6429: CLOSE c_color_by_total;
6430: END IF;
6431: BSC_MESSAGE.Add(x_message => SQLERRM,
6432: x_source => 'BSC_UPDATE_UTIL.Get_Color_By_Total');
6433: RETURN NULL;
6434: END Get_Color_By_Total;
6435:

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

6469: WHEN OTHERS THEN
6470: IF c_ytd_flag%ISOPEN THEN
6471: CLOSE c_ytd_flag;
6472: END IF;
6473: BSC_MESSAGE.Add(x_message => SQLERRM,
6474: x_source => 'BSC_UPDATE_UTIL.get_ytd_flag');
6475: RETURN l_ytd_flag;
6476: END get_ytd_flag;
6477:

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

6510: WHEN OTHERS THEN
6511: IF c_apply_color_flag%ISOPEN THEN
6512: CLOSE c_apply_color_flag;
6513: END IF;
6514: BSC_MESSAGE.Add(x_message => SQLERRM,
6515: x_source => 'BSC_UPDATE_UTIL.Get_Apply_Color_Flag');
6516: RETURN NULL;
6517: END Get_Apply_Color_Flag;
6518: