DBA Data[Home] [Help]

APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on MSD_DEM_DEMANTRA_UTILITIES

Line 518: x_schema := msd_dem_demantra_utilities.get_demantra_schema;

514: x_schema VARCHAR2(30) := NULL;
515:
516: BEGIN
517: /* Alter session to APPS */
518: x_schema := msd_dem_demantra_utilities.get_demantra_schema;
519: x_small_sql := 'alter session set current_schema = APPS';
520: EXECUTE IMMEDIATE x_small_sql;
521: msc_phub_pkg.populate_demantra_ods(x_errbuf,
522: x_retcode);

Line 530: msd_dem_demantra_utilities.log_message ('The procedure MSD_WS_DEM_RENAME_FORECAST.PUSH_ODS_DATA failed with the following error : '||x_errbuf);

526:
527:
528: IF (x_retcode <> '0')
529: THEN
530: msd_dem_demantra_utilities.log_message ('The procedure MSD_WS_DEM_RENAME_FORECAST.PUSH_ODS_DATA failed with the following error : '||x_errbuf);
531: END IF;
532: EXCEPTION
533: WHEN OTHERS THEN
534: /* Alter session to demantra schema */

Line 537: msd_dem_demantra_utilities.log_message ('The procedure MSD_WS_DEM_RENAME_FORECAST.PUSH_ODS_DATA failed with error : '||SQLCODE||' -ERROR- '||SQLERRM);

533: WHEN OTHERS THEN
534: /* Alter session to demantra schema */
535: x_small_sql := 'alter session set current_schema = ' || x_schema;
536: EXECUTE IMMEDIATE x_small_sql;
537: msd_dem_demantra_utilities.log_message ('The procedure MSD_WS_DEM_RENAME_FORECAST.PUSH_ODS_DATA failed with error : '||SQLCODE||' -ERROR- '||SQLERRM);
538: END PUSH_ODS_DATA;
539:
540:
541: /*