DBA Data[Home] [Help]

APPS.MSD_DELETE_DEMAND_PLAN dependencies on FND_FILE

Line 122: fnd_file.new_line(fnd_file.log, 1);

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

Line 123: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was processed for deletion.');

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'

Line 129: fnd_file.new_line(fnd_file.log, 1);

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:

Line 130: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was not processed for deletion.');

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;

Line 132: fnd_file.put_line(fnd_file.log, ' ' || errbuf);

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