113: END IF;
114:
115: END IF;
116:
117: l_success := fnd_submit.set_request_set('MSD','MSDSRPFFLD');
118: if not l_success then
119: raise l_submit_failed;
120: end if;
121:
119: raise l_submit_failed;
120: end if;
121:
122: if instr(file_name,'InstallBaseHistory') > 0 then
123: l_success := fnd_submit.submit_program('MSD','MSDSRPLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
124: null, null, null, null, null, null, null, null, null, null,null,1,file_name);
125: if not l_success then
126: raise l_submit_failed;
127: end if;
124: null, null, null, null, null, null, null, null, null, null,null,1,file_name);
125: if not l_success then
126: raise l_submit_failed;
127: end if;
128: l_success := fnd_submit.submit_program('MSD','MSDSRPPP','STAGE20',instance,1);
129: if not l_success then
130: raise l_submit_failed;
131: end if;
132: end if;
131: end if;
132: end if;
133:
134: IF instr(file_name,'FldSerUsgHist')>0 THEN
135: l_success := fnd_submit.submit_program('MSD','MSDSRPLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
136: null, null, null, null, null, null, null, null, null, null,null,1,null,file_name);
137: if not l_success then
138: raise l_submit_failed;
139: end if;
136: null, null, null, null, null, null, null, null, null, null,null,1,null,file_name);
137: if not l_success then
138: raise l_submit_failed;
139: end if;
140: l_success := fnd_submit.submit_program('MSD','MSDSRPPP','STAGE20',instance,2);
141: if not l_success then
142: raise l_submit_failed;
143: end if;
144: end if;
143: end if;
144: end if;
145:
146: IF instr(file_name,'DptRepUsgHist')>0 THEN
147: l_success := fnd_submit.submit_program('MSD','MSDSRPLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
148: null, null, null, null, null, null, null, null, null, null,null,1,null,null,file_name);
149: if not l_success then
150: raise l_submit_failed;
151: end if;
148: null, null, null, null, null, null, null, null, null, null,null,1,null,null,file_name);
149: if not l_success then
150: raise l_submit_failed;
151: end if;
152: l_success := fnd_submit.submit_program('MSD','MSDSRPPP','STAGE20',instance,3);
153: if not l_success then
154: raise l_submit_failed;
155: end if;
156: end if;
155: end if;
156: end if;
157:
158: IF instr(file_name,'SerPartRetHist')>0 THEN
159: l_success := fnd_submit.submit_program('MSD','MSDSRPLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
160: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,file_name);
161: if not l_success then
162: raise l_submit_failed;
163: end if;
160: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,file_name);
161: if not l_success then
162: raise l_submit_failed;
163: end if;
164: l_success := fnd_submit.submit_program('MSD','MSDSRPPP','STAGE20',instance,4);
165: if not l_success then
166: raise l_submit_failed;
167: end if;
168: end if;
167: end if;
168: end if;
169:
170: IF instr(file_name,'FailureRates')>0 THEN
171: l_success := fnd_submit.submit_program('MSD','MSDSRPLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
172: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,null,file_name);
173: if not l_success then
174: raise l_submit_failed;
175: end if;
172: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,null,file_name);
173: if not l_success then
174: raise l_submit_failed;
175: end if;
176: l_success := fnd_submit.submit_program('MSD','MSDSRPPP','STAGE20',instance,5);
177: if not l_success then
178: raise l_submit_failed;
179: end if;
180: end if;
179: end if;
180: end if;
181:
182: IF instr(file_name,'PrdRetHist')>0 THEN
183: l_success := fnd_submit.submit_program('MSD','MSDSRPLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
184: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,null,null,file_name);
185: if not l_success then
186: raise l_submit_failed;
187: end if;
184: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,null,null,file_name);
185: if not l_success then
186: raise l_submit_failed;
187: end if;
188: l_success := fnd_submit.submit_program('MSD','MSDSRPPP','STAGE20',instance,6);
189: if not l_success then
190: raise l_submit_failed;
191: end if;
192: end if;
191: end if;
192: end if;
193:
194: IF instr(file_name,'ForecastData')>0 THEN
195: l_success := fnd_submit.submit_program('MSD','MSDSRPLD','STAGE10', instance, 1440, file_seperator, control_path, data_path, 3, null,null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
196: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,null,null,null,file_name);
197: if not l_success then
198: raise l_submit_failed;
199: end if;
196: null, null, null, null, null, null, null, null, null, null,null,1,null,null,null,null,null,null,file_name);
197: if not l_success then
198: raise l_submit_failed;
199: end if;
200: l_success := fnd_submit.submit_program('MSD','MSDSRPPP','STAGE20',instance,7);
201: if not l_success then
202: raise l_submit_failed;
203: end if;
204:
203: end if;
204:
205: end if;
206:
207: l_req_id := fnd_submit.submit_set(NULL,FALSE);
208:
209: ELSE --- Service Parts Forecasting (Demantra)
210:
211: BEGIN