[Home] [Help]
426:
427: x_sr_instance_id NUMBER := NULL;
428: BEGIN
429: -- Check the profile MSD_DEM_SR_INSTANCE_FOR_GLOBAL_FCST, use this value if the profile is set
430: x_sr_instance_id := fnd_profile.value('MSD_DEM_SR_INSTANCE_FOR_GLOBAL_FCST');
431:
432: -- If the profile is not set find the sr_instance_id using cursor
433: if (x_sr_instance_id is null) then
434: OPEN c_get_sr_instance_id;
843: x_small_sql := 'alter session set current_schema = APPS';
844: EXECUTE IMMEDIATE x_small_sql;
845:
846:
847: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
848: IF (x_schema IS NULL)
849: THEN
850: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_forecast - Unable to find schema name');
851: END IF;
1774: x_small_sql := 'alter session set current_schema = APPS';
1775: EXECUTE IMMEDIATE x_small_sql;
1776:
1777:
1778: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
1779: IF (x_schema IS NULL)
1780: THEN
1781: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_planning_percentages - Unable to find schema name');
1782: END IF;
2238: x_small_sql := 'alter session set current_schema = APPS';
2239: EXECUTE IMMEDIATE x_small_sql;
2240:
2241:
2242: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2243: IF (x_schema IS NULL)
2244: THEN
2245: raise_application_error (-20002, 'Error: msd_dem_upload_forecast.upload_total_demand - Unable to find schema name');
2246: END IF;
2359: x_small_sql := 'alter session set current_schema = APPS';
2360: EXECUTE IMMEDIATE x_small_sql;
2361:
2362:
2363: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2364: IF (x_schema IS NULL)
2365: THEN
2366: raise_application_error (-20002, 'Error: msd_dem_upload_forecast.upload_forecast_with_app_id - Unable to find schema name');
2367: END IF;
2553: /* Alter session to APPS */
2554: x_small_sql := 'alter session set current_schema = APPS';
2555: EXECUTE IMMEDIATE x_small_sql;
2556:
2557: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
2558: IF (x_schema IS NULL) THEN
2559: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_cto_plng_pct_direct - Unable to find schema name');
2560: END IF;
2561:
3090: THEN
3091: raise_application_error (-20003, 'Error: msd_dem_upload_forecast.upload_plng_pctg_with_app_id - Planning Percentage series APP ID NOT provided');
3092: END IF;
3093:
3094: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3095: IF (x_schema IS NULL)
3096: THEN
3097: raise_application_error (-20004, 'Error: msd_dem_upload_forecast.upload_plng_pctg_with_app_id - Unable to find schema name');
3098: END IF;
3186: EXECUTE IMMEDIATE x_small_sql;
3187:
3188: raise_application_error (-20009, 'Exception: msd_dem_upload_forecast.upload_forecast_with_app_id - Unable to find option item demand fcst series ' || substr(SQLERRM,1,150));
3189: END;
3190: x_upload_pct_by_base_model := NVL(fnd_profile.value('MSD_DEM_PUB_PLAN_PCT_BY_BASE_MODEL'), 'N');
3191: /* Alter session to demantra schema */
3192: x_small_sql := 'alter session set current_schema = ' || x_schema;
3193: EXECUTE IMMEDIATE x_small_sql;
3194:
3250: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_cto_fcst_with_app_id - All the four input parameters must be specified');
3251: END IF;
3252:
3253:
3254: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3255: IF (x_schema IS NULL)
3256: THEN
3257: raise_application_error (-20002, 'Error: msd_dem_upload_forecast.upload_cto_fcst_with_app_id - Unable to find schema name');
3258: END IF;
3412: x_small_sql := 'alter session set current_schema = APPS';
3413: EXECUTE IMMEDIATE x_small_sql;
3414:
3415:
3416: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3417: IF (x_schema IS NULL)
3418: THEN
3419: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_spf_metrics - Unable to find schema name');
3420: END IF;
3742: x_small_sql := 'alter session set current_schema = APPS';
3743: EXECUTE IMMEDIATE x_small_sql;
3744:
3745:
3746: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
3747: IF (x_schema IS NULL)
3748: THEN
3749: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_spf_inc_forecast - Unable to find schema name');
3750: END IF;
4165: x_dem_schema varchar2(100) := null;
4166: x_wf_status varchar2(20) := 'Running';
4167:
4168: BEGIN
4169: x_dem_schema := trim(fnd_profile.value('MSD_DEM_SCHEMA'));
4170:
4171: IF (x_dem_schema IS NULL) then
4172: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.wait_until_upload - Unable to find schema name');
4173: END IF;
4233: x_last_upld_time date := null;
4234:
4235: BEGIN
4236:
4237: x_dem_schema := trim(fnd_profile.value('MSD_DEM_SCHEMA'));
4238:
4239: IF (x_dem_schema is NULL) THEN
4240: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.check_upload_last_run - Unable to find schema name');
4241: END IF;
4509: l_large_sql VARCHAR2(4000);
4510: l_sql VARCHAR2(1000);
4511: x_small_sql VARCHAR2(200);
4512: x_lvl_count NUMBER := 0;
4513: x_dem_schema VARCHAR2(100) := fnd_profile.value('MSD_DEM_SCHEMA');
4514: x_table_name VARCHAR2(100) := NULL ;
4515: x_fnd_user_id NUMBER := FND_GLOBAL.USER_ID();
4516: x_wo_item VARCHAR2(50) := MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM();
4517: x_spf_master_org NUMBER := NULL;
5027: raise_application_error (-20001, 'Error: msd_dem_upload_forecast.upload_total_demand_wo - All the four input parameters must be specified');
5028: END IF;
5029:
5030:
5031: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
5032: IF (x_schema IS NULL)
5033: THEN
5034: raise_application_error (-20002, 'Error: msd_dem_upload_forecast.upload_total_demand_wo - Unable to find schema name');
5035: END IF;
5276: THEN
5277: raise_application_error(-20001, 'Error: msd_dem_upload_forecast.upload_spf_forecast_metrics - Export Data Profile Application ID is null');
5278: END IF;
5279:
5280: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
5281: IF (x_schema IS NULL)
5282: THEN
5283: raise_application_error (-20002, 'Error: msd_dem_upload_forecast.upload_spf_forecast_metrics - Unable to find schema name');
5284: END IF;