[Home] [Help]
92: if ( repeatOption = 'yes' ) then
93: retVal := false;
94: if (length(repeatInterval) <> 0 ) then
95: --if the repeat inteval is not null, then recurr the request after this interval
96: retVal := FND_SUBMIT.SET_REPEAT_OPTIONS('' , repeatInterval ,repeatUnit, 'START', repeatEndDate);
97: else
98: --if the repeatInteval is null, then recurr the request daily at this time
99: --Extract the time from submitDate
100: retVal := FND_SUBMIT.SET_REPEAT_OPTIONS(SUBSTR('submitDate' ,
96: retVal := FND_SUBMIT.SET_REPEAT_OPTIONS('' , repeatInterval ,repeatUnit, 'START', repeatEndDate);
97: else
98: --if the repeatInteval is null, then recurr the request daily at this time
99: --Extract the time from submitDate
100: retVal := FND_SUBMIT.SET_REPEAT_OPTIONS(SUBSTR('submitDate' ,
101: - INSTR('submitDate',' ', -8, 1) ,
102: INSTR('submitDate',' ', -8, 1)) , '' , '',
103: 'START', repeatEndDate);
104: end if;
108: errMsg := fnd_message.get();
109: return;
110: end if;
111:
112: retVal := FND_SUBMIT.SET_REQUEST_SET('AD','FNDRSSUB1242');
113: if ( retVal = true ) then
114: n0 := 1;
115: else
116: errMsg := fnd_message.get();
117: return;
118: end if;
119:
120: -- bug#3984358 Call the PAANALYZEPATCHES wrapper.
121: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PAANALYZEPATCHES','STAGE3',patchList);
122: if ( retVal = true ) then
123: n3 := 1;
124: else
125: errMsg := fnd_message.get();
126: return;
127: end if;
128:
129: -- bug#3984358 PAPATCHDOWNLOADER is now dummy request. replaced by PAANALYZEPATCHES wrapper.
130: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PAPATCHDOWNLOADER','STAGE5',patchList);
131: if ( retVal = true ) then
132: n5 := 1;
133: else
134: errMsg := fnd_message.get();
135: return;
136: end if;
137:
138: -- bug#3984358 PATCHUPLOAD is now dummy request. replaced by PAANALYZEPATCHES wrapper.
139: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PATCHUPLOAD','STAGE10',patchList);
140: if ( retVal = true ) then
141: n10 := 1;
142: else
143: errMsg := fnd_message.get();
144: return;
145: end if;
146:
147: -- bug#3984358 PATCHANALYSIS is now dummy request. replaced by PAANALYZEPATCHES wrapper.
148: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PATCHANALYSIS','STAGE20',patchList);
149: if ( retVal = true ) then
150: n20 := 1;
151: else
152: errMsg := fnd_message.get();
152: errMsg := fnd_message.get();
153: return;
154: end if;
155:
156: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE30');
157: if ( retVal = true ) then
158: n30 := 1;
159: else
160: errMsg := fnd_message.get();
160: errMsg := fnd_message.get();
161: return;
162: end if;
163:
164: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE35');
165: if ( retVal = true ) then
166: n35 := 1;
167: else
168: errMsg := fnd_message.get();
168: errMsg := fnd_message.get();
169: return;
170: end if;
171:
172: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE40');
173: if ( retVal = true ) then
174: n40 := 1;
175: else
176: errMsg := fnd_message.get();
176: errMsg := fnd_message.get();
177: return;
178: end if;
179:
180: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE50');
181: if ( retVal = true ) then
182: n50 := 1;
183: else
184: errMsg := fnd_message.get();
184: errMsg := fnd_message.get();
185: return;
186: end if;
187:
188: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE60');
189: if ( retVal = true )
190: then n60 := 1;
191: else
192: errMsg := fnd_message.get();
194: end if;
195:
196: -- bug#3984358 Call the Agggregate PIA request with proper values.
197: if(pIsAggregate = 'Y') then
198: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65',null);
199: else
200: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65', -1);
201: end if;
202: if ( retVal = true )
196: -- bug#3984358 Call the Agggregate PIA request with proper values.
197: if(pIsAggregate = 'Y') then
198: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65',null);
199: else
200: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65', -1);
201: end if;
202: if ( retVal = true )
203: then n65 := 1;
204: else
205: errMsg := fnd_message.get();
206: return;
207: end if;
208:
209: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PWSTATUSTRACKER','STAGE70');
210: if ( retVal = true )
211: then n70 := 1;
212: else
213: errMsg := fnd_message.get();
215: end if;
216:
217: -- if ( (n1 = 1 ) and (n1_0 = 1 ) and (n1_1 = 1 ) and (n2 = 1 ) and (n3 = 1 ) and (n4 = 1 ) and (n5 = 1) and (n6 = 1) and (n7 = 1) and (n8 = 1) and (n9 = 1) and (lRepeatFlag = 1)) then
218: if ( (n0 = 1 ) and (n3 = 1 ) and (n5 = 1 ) and (n10 = 1 ) and (n20 = 1 ) and (n30 = 1 ) and (n35 = 1 ) and (n40 = 1 ) and (n50 = 1 ) and (n60 = 1) and (n65 = 1) and (n70 = 1) and (lRepeatFlag = 1)) then
219: reqId := FND_SUBMIT.SUBMIT_SET(submitDate);
220: else
221: reqId := 0;
222: errMsg := fnd_message.get();
223: return;
270: if ( repeatOption = 'yes' ) then
271: retVal := false;
272: if (length(repeatInterval) <> 0 ) then
273: --if the repeat inteval is not null, then recurr the request after this interval
274: retVal := FND_SUBMIT.SET_REPEAT_OPTIONS('' , repeatInterval ,repeatUnit
275: , 'START', repeatEndDate);
276: else
277: --if the repeatInteval is null, then recurr the request daily at this time
278: --Extract the time from submitDate
275: , 'START', repeatEndDate);
276: else
277: --if the repeatInteval is null, then recurr the request daily at this time
278: --Extract the time from submitDate
279: retVal := FND_SUBMIT.SET_REPEAT_OPTIONS(SUBSTR('submitDate' ,
280: - INSTR('submitDate',' ', -8, 1) ,
281: INSTR('submitDate',' ', -8, 1)) , '' , '',
282: 'START', repeatEndDate);
283: end if;
287: errMsg := fnd_message.get();
288: return;
289: end if;
290:
291: retVal := FND_SUBMIT.SET_REQUEST_SET('AD','FNDRSSUB1243');
292: if ( retVal = true ) then
293: n0 := 1;
294: else
295: errMsg := fnd_message.get();
296: return;
297: end if;
298:
299: -- bug#3984358 Call PAANALYZEPATCHES wrapper request.
300: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PARECOMMENDPATCHES','STAGE3', criteriaId, pUploadPatchInfo);
301: if ( retVal = true ) then
302: n3 := 1;
303: else
304: errMsg := fnd_message.get();
305: return;
306: end if;
307:
308: -- bug#3984358 FND_PAUPLOAD is now dummy request. replaced by PAANALYZEPATCHES wrapper.
309: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','FND_PAUPLOAD','STAGE5', pUploadPatchInfo);
310: if ( retVal = true ) then
311: n5 := 1;
312: else
313: errMsg := fnd_message.get();
314: return;
315: end if;
316:
317: -- bug#3984358 PAANALYSIS is now dummy request. replaced by PAANALYZEPATCHES wrapper.
318: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PAANALYSIS','STAGE10',criteriaId);
319: if ( retVal = true ) then
320: n10 := 1;
321: else
322: errMsg := fnd_message.get();
322: errMsg := fnd_message.get();
323: return;
324: end if;
325:
326: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE20');
327: if ( retVal = true ) then
328: n20 := 1;
329: else
330: errMsg := fnd_message.get();
330: errMsg := fnd_message.get();
331: return;
332: end if;
333:
334: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE25');
335: if ( retVal = true ) then
336: n25 := 1;
337: else
338: errMsg := fnd_message.get();
338: errMsg := fnd_message.get();
339: return;
340: end if;
341:
342: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE30');
343: if ( retVal = true ) then
344: n30 := 1;
345: else
346: errMsg := fnd_message.get();
346: errMsg := fnd_message.get();
347: return;
348: end if;
349:
350: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE40');
351: if ( retVal = true ) then
352: n40 := 1;
353: else
354: errMsg := fnd_message.get();
355: return;
356: end if;
357:
358: -- bug#3984358 Call Aggregate PIA request.
359: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE50');
360: if ( retVal = true ) then
361: n50 := 1;
362: else
363: errMsg := fnd_message.get();
363: errMsg := fnd_message.get();
364: return;
365: end if;
366:
367: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PWSTATUSTRACKER','STAGE60');
368: if ( retVal = true ) then
369: n60 := 1;
370: else
371: errMsg := fnd_message.get();
372: return;
373: end if;
374:
375: if(pIsAggregate = 'Y') then
376: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE55',null);
377: else
378: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE55', -1);
379: end if;
380: if ( retVal = true )
374:
375: if(pIsAggregate = 'Y') then
376: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE55',null);
377: else
378: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE55', -1);
379: end if;
380: if ( retVal = true )
381: then n55 := 1;
382: else
385: end if;
386:
387: -- if ( (n1 = 1 ) and (n1_1 = 1) and (n2 = 1 ) and (n3 = 1 ) and (n4 = 1 ) and (n5 = 1) and (n6 = 1) and (n7 = 1) and (n8 = 1) and (lRepeatFlag = 1)) then
388: if ( (n0 = 1 ) and (n3 = 1 ) and (n20 = 1 ) and (n25 = 1) and (n30 = 1) and (n40 = 1) and (n50 = 1) and (n55 = 1) and (n60 = 1 ) and (lRepeatFlag = 1)) then
389: reqId := FND_SUBMIT.SUBMIT_SET(submitDate);
390: else
391: reqId := 0;
392: errMsg := fnd_message.get();
393: return;
441: n60 number ;
442: n65 number ;
443: n70 number ;
444: begin
445: retVal := FND_SUBMIT.SET_REQUEST_SET('AD','FNDRSSUB1623');
446:
447: if ( retVal = true ) then
448: n0 := 1;
449: else
450: errMsg := fnd_message.get();
451: return;
452: end if;
453:
454: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PADOWNLOADPATCHES','STAGE10'
455: , pPatchList
456: , pAutoMerge
457: , pMergeName
458: , pMergeType
466: errMsg := fnd_message.get();
467: return;
468: end if;
469:
470: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE20');
471: if ( retVal = true ) then
472: n20 := 1;
473: else
474: errMsg := fnd_message.get();
474: errMsg := fnd_message.get();
475: return;
476: end if;
477:
478: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE30');
479: if ( retVal = true ) then
480: n30 := 1;
481: else
482: errMsg := fnd_message.get();
482: errMsg := fnd_message.get();
483: return;
484: end if;
485:
486: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE40');
487: if ( retVal = true ) then
488: n40 := 1;
489: else
490: errMsg := fnd_message.get();
490: errMsg := fnd_message.get();
491: return;
492: end if;
493:
494: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE50');
495: if ( retVal = true ) then
496: n50 := 1;
497: else
498: errMsg := fnd_message.get();
498: errMsg := fnd_message.get();
499: return;
500: end if;
501:
502: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE60');
503: if ( retVal = true ) then
504: n60 := 1;
505: else
506: errMsg := fnd_message.get();
509:
510: -- If the user has chosen Option 3 (Download, Analyze and Aggregate Patch Impact) only then
511: -- do the Aggregate PIA (otherwise we pass -1 not aggregate)
512: if(pOptions = '3') then
513: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65', null);
514: else
515: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65', -1);
516: end if;
517: if ( retVal = true )
511: -- do the Aggregate PIA (otherwise we pass -1 not aggregate)
512: if(pOptions = '3') then
513: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65', null);
514: else
515: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','AGGREGATEIMPACT','STAGE65', -1);
516: end if;
517: if ( retVal = true )
518: then n65 := 1;
519: else
520: errMsg := fnd_message.get();
521: return;
522: end if;
523:
524: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PWSTATUSTRACKER','STAGE70');
525: if ( retVal = true ) then
526: n70 := 1;
527: else
528: errMsg := fnd_message.get();
530: end if;
531:
532: -- if ( (n1 = 1 ) and (n2 = 1 ) and (n3 = 1 ) and (n4 = 1 ) and (n5 = 1) and (n6 = 1) and (n7 = 1) and (n8 = 1)) then
533: if ( (n0 = 1 ) and (n10 = 1 ) and (n20 = 1 ) and (n30 = 1) and (n40 = 1) and (n50 = 1) and (n60 = 1 ) and (n65 = 1) and (n70 = 1) ) then
534: reqId := FND_SUBMIT.SUBMIT_SET(pSubmitDate);
535: else
536: reqId := 0;
537: errMsg := fnd_message.get();
538: return;