83: END IF;
84:
85: EXCEPTION
86: WHEN e_error THEN
87: BSC_MESSAGE.flush;
88: BSC_MESSAGE.Add(x_message => l_error_message,
89: x_source => 'BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB',
90: x_mode => 'I');
91: COMMIT;
84:
85: EXCEPTION
86: WHEN e_error THEN
87: BSC_MESSAGE.flush;
88: BSC_MESSAGE.Add(x_message => l_error_message,
89: x_source => 'BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB',
90: x_mode => 'I');
91: COMMIT;
92:
90: x_mode => 'I');
91: COMMIT;
92:
93: WHEN OTHERS THEN
94: BSC_MESSAGE.Add(x_message => SQLERRM,
95: x_source => 'BSC_BIA_WRAPPER.Drop_Rpt_Key_Table_VB',
96: x_mode => 'I');
97: COMMIT;
98:
160: END IF;
161:
162: EXCEPTION
163: WHEN e_error THEN
164: BSC_MESSAGE.flush;
165: BSC_MESSAGE.Add(x_message => l_error_message,
166: x_source => 'BSC_BIA_WRAPPER.Drop_Summary_MV_VB',
167: x_mode => 'I');
168: COMMIT;
161:
162: EXCEPTION
163: WHEN e_error THEN
164: BSC_MESSAGE.flush;
165: BSC_MESSAGE.Add(x_message => l_error_message,
166: x_source => 'BSC_BIA_WRAPPER.Drop_Summary_MV_VB',
167: x_mode => 'I');
168: COMMIT;
169:
167: x_mode => 'I');
168: COMMIT;
169:
170: WHEN OTHERS THEN
171: BSC_MESSAGE.Add(x_message => SQLERRM,
172: x_source => 'BSC_BIA_WRAPPER.Drop_Summary_MV_VB',
173: x_mode => 'I');
174: COMMIT;
175:
361: END IF;
362:
363: EXCEPTION
364: WHEN e_error THEN
365: BSC_MESSAGE.flush;
366: BSC_MESSAGE.Add(x_message => l_error_message||'. p_kpi='||p_kpi,
367: x_source => 'BSC_BIA_WRAPPER.Implement_Bsc_MV_VB',
368: x_mode => 'I');
369: COMMIT;
362:
363: EXCEPTION
364: WHEN e_error THEN
365: BSC_MESSAGE.flush;
366: BSC_MESSAGE.Add(x_message => l_error_message||'. p_kpi='||p_kpi,
367: x_source => 'BSC_BIA_WRAPPER.Implement_Bsc_MV_VB',
368: x_mode => 'I');
369: COMMIT;
370:
368: x_mode => 'I');
369: COMMIT;
370:
371: WHEN OTHERS THEN
372: BSC_MESSAGE.Add(x_message => SQLERRM||'. p_kpi='||p_kpi,
373: x_source => 'BSC_BIA_WRAPPER.Implement_Bsc_MV_VB',
374: x_mode => 'I');
375: COMMIT;
376:
499: END IF;
500:
501: EXCEPTION
502: WHEN e_error THEN
503: BSC_MESSAGE.flush;
504: BSC_MESSAGE.Add(x_message => l_error_message,
505: x_source => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar_VB',
506: x_mode => 'I');
507: COMMIT;
500:
501: EXCEPTION
502: WHEN e_error THEN
503: BSC_MESSAGE.flush;
504: BSC_MESSAGE.Add(x_message => l_error_message,
505: x_source => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar_VB',
506: x_mode => 'I');
507: COMMIT;
508:
506: x_mode => 'I');
507: COMMIT;
508:
509: WHEN OTHERS THEN
510: BSC_MESSAGE.Add(x_message => SQLERRM,
511: x_source => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar_VB',
512: x_mode => 'I');
513: COMMIT;
514: