118: /*--------Bug 4615390--------*/
119: DELETE FROM msd_dp_iso_organizations
120: where demand_plan_id = planId;
121:
122: fnd_file.new_line(fnd_file.log, 1);
123: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was processed for deletion.');
124:
125: else
126: update msd_demand_plans
119: DELETE FROM msd_dp_iso_organizations
120: where demand_plan_id = planId;
121:
122: fnd_file.new_line(fnd_file.log, 1);
123: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was processed for deletion.');
124:
125: else
126: update msd_demand_plans
127: set delete_plan_flag = 'NO'
125: else
126: update msd_demand_plans
127: set delete_plan_flag = 'NO'
128: where demand_plan_id = planId;
129: fnd_file.new_line(fnd_file.log, 1);
130: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was not processed for deletion.');
131:
132: fnd_file.put_line(fnd_file.log, ' ' || errbuf);
133:
126: update msd_demand_plans
127: set delete_plan_flag = 'NO'
128: where demand_plan_id = planId;
129: fnd_file.new_line(fnd_file.log, 1);
130: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was not processed for deletion.');
131:
132: fnd_file.put_line(fnd_file.log, ' ' || errbuf);
133:
134: end if;
128: where demand_plan_id = planId;
129: fnd_file.new_line(fnd_file.log, 1);
130: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was not processed for deletion.');
131:
132: fnd_file.put_line(fnd_file.log, ' ' || errbuf);
133:
134: end if;
135: exception
136: when others then