167: CLOSE c_org_id;
168:
169: COMMIT;
170:
171: fnd_file.put_line(fnd_file.log, 'Launching ASCP engine with default unconstrained plan');
172:
173: -- launch ASCP engine with default unconstrained plan
174: MSC_X_CP_FLOW.Start_ASCP_Engine_WF ( p_constrained_plan_flag => 2 );
175:
188: CLOSE c_attach_scenario;
189:
190: IF l_attach_scn_count > 0 then
191:
192: fnd_file.put_line(fnd_file.log, 'Launching ASCP engine with default unconstrained plan');
193:
194: -- launch ASCP engine with default unconstrained plan
195: MSC_X_CP_FLOW.Start_ASCP_Engine_WF ( p_constrained_plan_flag => 2 );
196:
199: END IF;
200:
201: EXCEPTION
202: WHEN OTHERS THEN
203: fnd_file.put_line(fnd_file.log, 'Errors in Launching ASCP Plan from DP');
204: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
205:
206: END;
207:
200:
201: EXCEPTION
202: WHEN OTHERS THEN
203: fnd_file.put_line(fnd_file.log, 'Errors in Launching ASCP Plan from DP');
204: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
205:
206: END;
207:
208: function get_priority(p_demand_plan_id in number,
563:
564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: fnd_file.put_line(fnd_file.log, 'Errors in populating denormalized tables');
568: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
569: raise;
570:
571: END populate_denorm_tables;
564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: fnd_file.put_line(fnd_file.log, 'Errors in populating denormalized tables');
568: fnd_file.put_line(fnd_file.log, substr(SQLERRM, 1, 1000));
569: raise;
570:
571: END populate_denorm_tables;
572: