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.MSD_ROLL_DEMAND_PLAN dependencies on MSC_ST_UTIL

Line 59: msc_st_util.log_message ('Rolled the parameter dates and attached the latest forecast for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);

55: WHERE parameter_id = lv_parameter_id;
56:
57:
58: IF ( lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
59: msc_st_util.log_message ('Rolled the parameter dates and attached the latest forecast for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);
60: ELSE
61: msc_st_util.log_message ('Rolled the parameter dates for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);
62: END IF;
63:

Line 61: msc_st_util.log_message ('Rolled the parameter dates for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);

57:
58: IF ( lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
59: msc_st_util.log_message ('Rolled the parameter dates and attached the latest forecast for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);
60: ELSE
61: msc_st_util.log_message ('Rolled the parameter dates for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);
62: END IF;
63:
64:
65:

Line 76: msc_st_util.log_message ('No Change for the parameter_name for latest forecast version in msd_dp_scenarios table');

72: AND nvl(forecast_date_used,NULL_CHAR) = nvl(lv_forecast_date_used,NULL_CHAR)
73: AND demand_plan_id = p_demand_plan_id;
74:
75: IF ( SQL%NOTFOUND AND lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
76: msc_st_util.log_message ('No Change for the parameter_name for latest forecast version in msd_dp_scenarios table');
77: ELSIF ( lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
78: msc_st_util.log_message ('Changed the parameter_name for latest forecast version in msd_dp_scenarios table');
79: END IF;
80:

Line 78: msc_st_util.log_message ('Changed the parameter_name for latest forecast version in msd_dp_scenarios table');

74:
75: IF ( SQL%NOTFOUND AND lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
76: msc_st_util.log_message ('No Change for the parameter_name for latest forecast version in msd_dp_scenarios table');
77: ELSIF ( lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
78: msc_st_util.log_message ('Changed the parameter_name for latest forecast version in msd_dp_scenarios table');
79: END IF;
80:
81:
82: CLOSE latest_forecast_version;

Line 112: msc_st_util.log_message ('Rolled the scenario history and horizon dates for the scenario with scenario_id - '||lv_scenario_id||' and scenario_name - '||lv_scenario_name);

108: END IF;
109:
110:
111: IF ( nvl(lv_exclude_flag,'N')= 'N' ) THEN
112: msc_st_util.log_message ('Rolled the scenario history and horizon dates for the scenario with scenario_id - '||lv_scenario_id||' and scenario_name - '||lv_scenario_name);
113: ELSE
114: msc_st_util.log_message ('Not Rolled the scenario history and horizon dates for the scenario with scenario_id - '||lv_scenario_id||' and scenario_name - '||lv_scenario_name);
115: END IF;
116:

Line 114: msc_st_util.log_message ('Not Rolled the scenario history and horizon dates for the scenario with scenario_id - '||lv_scenario_id||' and scenario_name - '||lv_scenario_name);

110:
111: IF ( nvl(lv_exclude_flag,'N')= 'N' ) THEN
112: msc_st_util.log_message ('Rolled the scenario history and horizon dates for the scenario with scenario_id - '||lv_scenario_id||' and scenario_name - '||lv_scenario_name);
113: ELSE
114: msc_st_util.log_message ('Not Rolled the scenario history and horizon dates for the scenario with scenario_id - '||lv_scenario_id||' and scenario_name - '||lv_scenario_name);
115: END IF;
116:
117:
118:

Line 199: msc_st_util.log_message ('**Total number of parameters for which definition is modified ='||parameters%ROWCOUNT||'*');

195: FETCH parameters INTO lv_parameter_id,lv_parameter_type,lv_parameter_name,lv_forecast_date_used,lv_input_demand_plan_id,lv_input_scenario_id ;
196: EXIT WHEN parameters%NOTFOUND;
197: update_parameters( p_demand_plan_id, lv_parameter_id,lv_parameter_type,lv_parameter_name,lv_forecast_date_used,lv_input_demand_plan_id,lv_input_scenario_id ,p_period_type, p_number_of_periods);
198: END LOOP;
199: msc_st_util.log_message ('************************Total number of parameters for which definition is modified ='||parameters%ROWCOUNT||'***********************');
200: CLOSE parameters;
201:
202: -- rolling forward scenario history and horizon periods
203: OPEN scenarios;

Line 209: msc_st_util.log_message ('**Total number of scenarios for which definition is modified ='||scenarios%ROWCOUNT||'*');

205: FETCH scenarios INTO lv_scenario_id,lv_scenario_name,lv_exclude_flag;
206: EXIT WHEN scenarios%NOTFOUND;
207: update_scenarios( p_demand_plan_id, lv_scenario_id,lv_scenario_name,lv_exclude_flag, p_period_type,p_number_of_periods );
208: END LOOP;
209: msc_st_util.log_message ('************************Total number of scenarios for which definition is modified ='||scenarios%ROWCOUNT||'***********************');
210: CLOSE scenarios;
211:
212: -- commiting all the changes
213: COMMIT;

Line 214: msc_st_util.log_message ('Commiting all changes');

210: CLOSE scenarios;
211:
212: -- commiting all the changes
213: COMMIT;
214: msc_st_util.log_message ('Commiting all changes');
215:
216:
217: EXCEPTION
218: WHEN OTHERS THEN

Line 223: msc_st_util.log_message(v_errtxt);

219: ROLLBACK;
220: ERRBUF := SQLERRM;
221: RETCODE := SQLCODE;
222: v_errtxt := substr(SQLERRM,1,240) ;
223: msc_st_util.log_message(v_errtxt);
224:
225: END launching_roll;
226:
227: END msd_roll_demand_plan;