DBA Data[Home] [Help]

APPS.AD_PA_SUBMIT_REQUEST dependencies on FND_MESSAGE

Line 41: errMsg := fnd_message.get();

37: INSTR('submitDate',' ', -8, 1)) , '' , '',
38: 'START', repeatEndDate);
39: end if;
40: if (retval = false) then
41: errMsg := fnd_message.get();
42: return;
43: end if;
44: end if;
45:

Line 54: errMsg := fnd_message.get();

50: end if;
51:
52: -- This is to get the actual error in case concurrent program fails.
53: if ( reqId <= 0 ) then
54: errMsg := fnd_message.get();
55: end if;
56:
57: commit;
58:

Line 108: errMsg := fnd_message.get();

104: end if;
105: end if;
106: if(retVal = false) then
107: lRepeatFlag := -1;
108: errMsg := fnd_message.get();
109: return;
110: end if;
111:
112: retVal := FND_SUBMIT.SET_REQUEST_SET('AD','FNDRSSUB1242');

Line 116: errMsg := fnd_message.get();

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.

Line 125: errMsg := fnd_message.get();

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.

Line 134: errMsg := fnd_message.get();

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.

Line 143: errMsg := fnd_message.get();

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.

Line 152: errMsg := fnd_message.get();

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();
153: return;
154: end if;
155:
156: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE30');

Line 160: errMsg := fnd_message.get();

156: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE30');
157: if ( retVal = true ) then
158: n30 := 1;
159: else
160: errMsg := fnd_message.get();
161: return;
162: end if;
163:
164: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE35');

Line 168: errMsg := fnd_message.get();

164: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE35');
165: if ( retVal = true ) then
166: n35 := 1;
167: else
168: errMsg := fnd_message.get();
169: return;
170: end if;
171:
172: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE40');

Line 176: errMsg := fnd_message.get();

172: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE40');
173: if ( retVal = true ) then
174: n40 := 1;
175: else
176: errMsg := fnd_message.get();
177: return;
178: end if;
179:
180: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE50');

Line 184: errMsg := fnd_message.get();

180: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE50');
181: if ( retVal = true ) then
182: n50 := 1;
183: else
184: errMsg := fnd_message.get();
185: return;
186: end if;
187:
188: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE60');

Line 192: errMsg := fnd_message.get();

188: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE60');
189: if ( retVal = true )
190: then n60 := 1;
191: else
192: errMsg := fnd_message.get();
193: return;
194: end if;
195:
196: -- bug#3984358 Call the Agggregate PIA request with proper values.

Line 205: errMsg := fnd_message.get();

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');

Line 213: errMsg := fnd_message.get();

209: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PWSTATUSTRACKER','STAGE70');
210: if ( retVal = true )
211: then n70 := 1;
212: else
213: errMsg := fnd_message.get();
214: return;
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

Line 222: errMsg := fnd_message.get();

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;
224: end if;
225:
226: -- This is to get the actual error in case concurrent program fails.

Line 228: errMsg := fnd_message.get();

224: end if;
225:
226: -- This is to get the actual error in case concurrent program fails.
227: if ( reqId <= 0 ) then
228: errMsg := fnd_message.get();
229: end if;
230:
231:
232: commit;

Line 287: errMsg := fnd_message.get();

283: end if;
284: end if;
285: if(retVal = false) then
286: lRepeatFlag := -1;
287: errMsg := fnd_message.get();
288: return;
289: end if;
290:
291: retVal := FND_SUBMIT.SET_REQUEST_SET('AD','FNDRSSUB1243');

Line 295: errMsg := fnd_message.get();

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.

Line 304: errMsg := fnd_message.get();

300: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PARECOMMENDPATCHES','STAGE3', criteriaId, pUploadPatchInfo, useproducts);
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.

Line 313: errMsg := fnd_message.get();

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.

Line 322: errMsg := fnd_message.get();

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();
323: return;
324: end if;
325:
326: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE20');

Line 330: errMsg := fnd_message.get();

326: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE20');
327: if ( retVal = true ) then
328: n20 := 1;
329: else
330: errMsg := fnd_message.get();
331: return;
332: end if;
333:
334: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE25');

Line 338: errMsg := fnd_message.get();

334: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE25');
335: if ( retVal = true ) then
336: n25 := 1;
337: else
338: errMsg := fnd_message.get();
339: return;
340: end if;
341:
342: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE30');

Line 346: errMsg := fnd_message.get();

342: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE30');
343: if ( retVal = true ) then
344: n30 := 1;
345: else
346: errMsg := fnd_message.get();
347: return;
348: end if;
349:
350: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE40');

Line 354: errMsg := fnd_message.get();

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.

Line 363: errMsg := fnd_message.get();

359: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE50');
360: if ( retVal = true ) then
361: n50 := 1;
362: else
363: errMsg := fnd_message.get();
364: return;
365: end if;
366:
367: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PWSTATUSTRACKER','STAGE60');

Line 371: errMsg := fnd_message.get();

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

Line 383: errMsg := fnd_message.get();

379: end if;
380: if ( retVal = true )
381: then n55 := 1;
382: else
383: errMsg := fnd_message.get();
384: return;
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

Line 392: errMsg := fnd_message.get();

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;
394: end if;
395:
396: -- This is to get the actual error in case concurrent program fails.

Line 398: errMsg := fnd_message.get();

394: end if;
395:
396: -- This is to get the actual error in case concurrent program fails.
397: if ( reqId <= 0 ) then
398: errMsg := fnd_message.get();
399: end if;
400:
401: commit;
402:

Line 450: errMsg := fnd_message.get();

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'

Line 466: errMsg := fnd_message.get();

462: , pOptions);
463: if ( retVal = true ) then
464: n10 := 1;
465: else
466: errMsg := fnd_message.get();
467: return;
468: end if;
469:
470: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE20');

Line 474: errMsg := fnd_message.get();

470: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','BUILDJSPDEP','STAGE20');
471: if ( retVal = true ) then
472: n20 := 1;
473: else
474: errMsg := fnd_message.get();
475: return;
476: end if;
477:
478: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE30');

Line 482: errMsg := fnd_message.get();

478: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','COMPDIAGTESTVER','STAGE30');
479: if ( retVal = true ) then
480: n30 := 1;
481: else
482: errMsg := fnd_message.get();
483: return;
484: end if;
485:
486: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE40');

Line 490: errMsg := fnd_message.get();

486: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT','STAGE40');
487: if ( retVal = true ) then
488: n40 := 1;
489: else
490: errMsg := fnd_message.get();
491: return;
492: end if;
493:
494: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE50');

Line 498: errMsg := fnd_message.get();

494: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','MENUTREEANALYSIS','STAGE50');
495: if ( retVal = true ) then
496: n50 := 1;
497: else
498: errMsg := fnd_message.get();
499: return;
500: end if;
501:
502: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE60');

Line 506: errMsg := fnd_message.get();

502: retVal := FND_SUBMIT.SUBMIT_PROGRAM('FND','ANALYZEIMPACT2','STAGE60');
503: if ( retVal = true ) then
504: n60 := 1;
505: else
506: errMsg := fnd_message.get();
507: return;
508: end if;
509:
510: -- If the user has chosen Option 3 (Download, Analyze and Aggregate Patch Impact) only then

Line 520: errMsg := fnd_message.get();

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');

Line 528: errMsg := fnd_message.get();

524: retVal := FND_SUBMIT.SUBMIT_PROGRAM('AD','PWSTATUSTRACKER','STAGE70');
525: if ( retVal = true ) then
526: n70 := 1;
527: else
528: errMsg := fnd_message.get();
529: return;
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

Line 537: errMsg := fnd_message.get();

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;
539: end if;
540:
541: -- This is to get the actual error in case concurrent program fails.

Line 543: errMsg := fnd_message.get();

539: end if;
540:
541: -- This is to get the actual error in case concurrent program fails.
542: if ( reqId <= 0 ) then
543: errMsg := fnd_message.get();
544: end if;
545:
546: commit;
547:

Line 684: errMsg := fnd_message.get();

680: end if;
681:
682: -- This is to get the actual error in case concurrent program fails.
683: if ( reqId <= 0 ) then
684: errMsg := fnd_message.get();
685: end if;
686:
687: END submit_aggregate_impact;
688: