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 61: 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);

57: WHERE parameter_id = lv_parameter_id;
58:
59:
60: IF ( lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
61: 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);
62: ELSE
63: msc_st_util.log_message ('Rolled the parameter dates for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);
64: END IF;
65:

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

59:
60: IF ( lv_parameter_type= G_TYPE_INPUT_SCENARIO ) THEN
61: 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);
62: ELSE
63: msc_st_util.log_message ('Rolled the parameter dates for the parameter with parameter_id - '||lv_parameter_id||' and parameter_name - '||lv_parameter_name);
64: END IF;
65:
66:
67:

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

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

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

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

Line 118: 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);

114: END IF;
115:
116:
117: IF ( nvl(lv_exclude_flag,'N')= 'N' ) THEN
118: 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);
119: ELSE
120: 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);
121: END IF;
122:

Line 120: 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);

116:
117: IF ( nvl(lv_exclude_flag,'N')= 'N' ) THEN
118: 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);
119: ELSE
120: 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);
121: END IF;
122:
123:
124:

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

201: 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 ;
202: EXIT WHEN parameters%NOTFOUND;
203: 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);
204: END LOOP;
205: msc_st_util.log_message ('************************Total number of parameters for which definition is modified ='||parameters%ROWCOUNT||'***********************');
206: CLOSE parameters;
207:
208: -- rolling forward scenario history and horizon periods
209: OPEN scenarios;

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

211: FETCH scenarios INTO lv_scenario_id,lv_scenario_name,lv_exclude_flag;
212: EXIT WHEN scenarios%NOTFOUND;
213: update_scenarios( p_demand_plan_id, lv_scenario_id,lv_scenario_name,lv_exclude_flag, p_period_type,p_number_of_periods );
214: END LOOP;
215: msc_st_util.log_message ('************************Total number of scenarios for which definition is modified ='||scenarios%ROWCOUNT||'***********************');
216: CLOSE scenarios;
217:
218: -- commiting all the changes
219: COMMIT;

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

216: CLOSE scenarios;
217:
218: -- commiting all the changes
219: COMMIT;
220: msc_st_util.log_message ('Commiting all changes');
221:
222:
223: EXCEPTION
224: WHEN OTHERS THEN

Line 229: msc_st_util.log_message(v_errtxt);

225: ROLLBACK;
226: ERRBUF := SQLERRM;
227: RETCODE := SQLCODE;
228: v_errtxt := substr(SQLERRM,1,240) ;
229: msc_st_util.log_message(v_errtxt);
230:
231: END launching_roll;
232:
233: END msd_roll_demand_plan;