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_INC dependencies on BSC_UPDATE_INC

Line 1: PACKAGE BODY BSC_UPDATE_INC AS

1: PACKAGE BODY BSC_UPDATE_INC AS
2: /* $Header: BSCDINCB.pls 120.6 2007/03/01 14:42:47 ankgoel ship $ */
3:
4:
5: /*===========================================================================+

Line 127: x_source => 'BSC_UPDATE_INC.Add_Related_Tables');

123:
124: EXCEPTION
125: WHEN e_unexpected_error THEN
126: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_ADD_REL_TABLES_FAILED'),
127: x_source => 'BSC_UPDATE_INC.Add_Related_Tables');
128: RETURN FALSE;
129:
130: WHEN OTHERS THEN
131: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 132: x_source => 'BSC_UPDATE_INC.Add_Related_Tables');

128: RETURN FALSE;
129:
130: WHEN OTHERS THEN
131: BSC_MESSAGE.Add(x_message => SQLERRM,
132: x_source => 'BSC_UPDATE_INC.Add_Related_Tables');
133: RETURN FALSE;
134:
135: END Add_Related_Tables;
136:

Line 382: x_source => 'BSC_UPDATE_INC.Do_Incremental');

378:
379: EXCEPTION
380: WHEN e_unexpected_error THEN
381: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_INCR_CHANGE_REV_FAILED'),
382: x_source => 'BSC_UPDATE_INC.Do_Incremental');
383: RETURN FALSE;
384:
385: --LOCKING
386: WHEN e_could_not_get_lock THEN

Line 388: x_source => 'BSC_UPDATE_INC.Do_Incremental');

384:
385: --LOCKING
386: WHEN e_could_not_get_lock THEN
387: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
388: x_source => 'BSC_UPDATE_INC.Do_Incremental');
389: RETURN FALSE;
390:
391: WHEN e_error_load_rpt_cal THEN
392: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,

Line 393: x_source => 'BSC_UPDATE_INC.Do_Incremental');

389: RETURN FALSE;
390:
391: WHEN e_error_load_rpt_cal THEN
392: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,
393: x_source => 'BSC_UPDATE_INC.Do_Incremental');
394: RETURN FALSE;
395:
396: WHEN OTHERS THEN
397: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 398: x_source => 'BSC_UPDATE_INC.Do_Incremental');

394: RETURN FALSE;
395:
396: WHEN OTHERS THEN
397: BSC_MESSAGE.Add(x_message => SQLERRM,
398: x_source => 'BSC_UPDATE_INC.Do_Incremental');
399: RETURN FALSE;
400:
401: END Do_Incremental;
402:

Line 452: x_source => 'BSC_UPDATE_INC.Get_Changed_Calendars');

448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: BSC_MESSAGE.Add(x_message => SQLERRM,
452: x_source => 'BSC_UPDATE_INC.Get_Changed_Calendars');
453: RETURN FALSE;
454:
455: END Get_Changed_Calendars;
456:

Line 517: x_source => 'BSC_UPDATE_INC.Get_Color_Indics_Incremental');

513: RETURN TRUE;
514: EXCEPTION
515: WHEN OTHERS THEN
516: BSC_MESSAGE.Add(x_message => SQLERRM,
517: x_source => 'BSC_UPDATE_INC.Get_Color_Indics_Incremental');
518: RETURN FALSE;
519:
520: END Get_Color_Indics_Incremental;
521:

Line 588: x_source => 'BSC_UPDATE_INC.Get_Input_Tables');

584:
585: EXCEPTION
586: WHEN e_unexpected_error THEN
587: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),
588: x_source => 'BSC_UPDATE_INC.Get_Input_Tables');
589: RETURN FALSE;
590:
591: WHEN OTHERS THEN
592: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 593: x_source => 'BSC_UPDATE_INC.Get_Input_Tables');

589: RETURN FALSE;
590:
591: WHEN OTHERS THEN
592: BSC_MESSAGE.Add(x_message => SQLERRM,
593: x_source => 'BSC_UPDATE_INC.Get_Input_Tables');
594: RETURN FALSE;
595: END Get_Input_Tables;
596:
597:

Line 663: x_source => 'BSC_UPDATE_INC.Get_Input_Tables_Incremental');

659: RETURN TRUE;
660: EXCEPTION
661: WHEN e_unexpected_error THEN
662: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_INCR_ITABLES_FAILED'),
663: x_source => 'BSC_UPDATE_INC.Get_Input_Tables_Incremental');
664: RETURN FALSE;
665:
666: WHEN OTHERS THEN
667: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 668: x_source => 'BSC_UPDATE_INC.Get_Input_Tables_Incremental');

664: RETURN FALSE;
665:
666: WHEN OTHERS THEN
667: BSC_MESSAGE.Add(x_message => SQLERRM,
668: x_source => 'BSC_UPDATE_INC.Get_Input_Tables_Incremental');
669: RETURN FALSE;
670:
671: END Get_Input_Tables_Incremental;
672:

Line 717: x_source => 'BSC_UPDATE_INC.Purge_Data_All_Indicators');

713:
714: EXCEPTION
715: WHEN e_unexpected_error THEN
716: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
717: x_source => 'BSC_UPDATE_INC.Purge_Data_All_Indicators');
718: RETURN FALSE;
719:
720: WHEN OTHERS THEN
721: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 722: x_source => 'BSC_UPDATE_INC.Purge_Data_All_Indicators');

718: RETURN FALSE;
719:
720: WHEN OTHERS THEN
721: BSC_MESSAGE.Add(x_message => SQLERRM,
722: x_source => 'BSC_UPDATE_INC.Purge_Data_All_Indicators');
723: RETURN FALSE;
724:
725: END Purge_Data_All_Indicators;
726:

Line 778: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');

774: EXCEPTION
775: --LOCKING
776: WHEN e_could_not_get_lock THEN
777: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
778: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
779: RETURN FALSE;
780:
781: WHEN e_unexpected_error THEN
782: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),

Line 783: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');

779: RETURN FALSE;
780:
781: WHEN e_unexpected_error THEN
782: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
783: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
784: RETURN FALSE;
785:
786: WHEN OTHERS THEN
787: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 788: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');

784: RETURN FALSE;
785:
786: WHEN OTHERS THEN
787: BSC_MESSAGE.Add(x_message => SQLERRM,
788: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
789: RETURN FALSE;
790:
791: END Purge_Data_Indicators_Calendar;
792:

Line 807: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');

803: return Purge_Indicators_Data(x_purge_indicators,x_num_purge_indicators,'N');
804: EXCEPTION
805: WHEN e_unexpected_error THEN
806: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
807: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
808: RETURN FALSE;
809:
810: WHEN OTHERS THEN
811: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 812: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');

808: RETURN FALSE;
809:
810: WHEN OTHERS THEN
811: BSC_MESSAGE.Add(x_message => SQLERRM,
812: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
813: RETURN FALSE;
814:
815: END Purge_Indicators_Data;
816:

Line 1324: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');

1320: EXCEPTION
1321: --LOCKING
1322: WHEN e_could_not_get_lock THEN
1323: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
1324: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1325: RETURN FALSE;
1326:
1327: WHEN e_unexpected_error THEN
1328: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),

Line 1329: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');

1325: RETURN FALSE;
1326:
1327: WHEN e_unexpected_error THEN
1328: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
1329: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1330: RETURN FALSE;
1331:
1332: WHEN OTHERS THEN
1333: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 1334: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');

1330: RETURN FALSE;
1331:
1332: WHEN OTHERS THEN
1333: BSC_MESSAGE.Add(x_message => SQLERRM,
1334: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1335: RETURN FALSE;
1336:
1337: END Purge_Indicators_Data;
1338:

Line 1401: x_source => 'BSC_UPDATE_INC.Reset_Flag_Indicators');

1397: RETURN TRUE;
1398: EXCEPTION
1399: WHEN OTHERS THEN
1400: BSC_MESSAGE.Add(x_message => SQLERRM,
1401: x_source => 'BSC_UPDATE_INC.Reset_Flag_Indicators');
1402: RETURN FALSE;
1403: END Reset_Flag_Indicators;
1404:
1405:

Line 1422: END BSC_UPDATE_INC;

1418: );
1419: commit; -- autonomous transactions need to commit
1420: END Purge_AW_Indicator_AT;
1421:
1422: END BSC_UPDATE_INC;