APPS.INV_REDUCE_MOQD_PVT dependencies on FND_CONCURRENT

Line 212: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

208: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
209: -- Consolidation of Onhand Quantities failed.
210: ERRBUF := FND_MESSAGE.get;
211: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
212: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
213: ROLLBACK;
214: RETURN;
215: END IF;
216:

Line 246: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

242: FND_MESSAGE.set_name('INV','INV_MOQD_FIFO_SET');
243: -- The Profile INV: FIFO for Original Receipt Date is set to Yes and this program should not be run when the option is set to Yes.
244: ERRBUF := FND_MESSAGE.get;
245: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
246: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
247: ROLLBACK;
248: RETURN;
249: END IF;
250: ELSE -- l_profile = 'Y'

Line 263: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

259: FND_MESSAGE.set_name('INV','INV_MOQD_FIFO_SET');
260: -- The Profile INV: FIFO for Original Receipt Date is set to Yes and this program should not be run when the option is set to Yes.
261: ERRBUF := FND_MESSAGE.get;
262: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
263: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
264: ROLLBACK;
265: RETURN;
266: END IF;
267:

Line 286: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

282: RETCODE := 2;
283: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
284: -- Consolidation of Onhand Quantities failed.
285: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
286: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
287: RETURN;
288: END IF;
289: CLOSE elig_orgs;
290: END;

Line 313: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

309: FND_MESSAGE.set_name('INV','INV_MOQD_CANNOT_LOCK');
310: -- The Onhand Quantities table cannot be locked for consolidation.
311: ERRBUF := FND_MESSAGE.get;
312: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
313: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
314: ROLLBACK;
315: RETURN;
316: END;
317: */

Line 494: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

490: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
491: -- Consolidation of Onhand Quantities failed.
492: ERRBUF := FND_MESSAGE.get;
493: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
494: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
495: ROLLBACK;
496: -- RETURN; /* Commented for bug 7588761 */
497: goto loop_end; /* Added for bug 7588761 */
498:

Line 679: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

675: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
676: -- Consolidation of Onhand Quantities failed.
677: ERRBUF := FND_MESSAGE.get;
678: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
679: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
680: ROLLBACK;
681: -- RETURN; /* Commented for bug 7588761 */
682: goto loop_end; /* Added for bug 7588761 */
683: END IF;

Line 835: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',ERRBUF);

831: RETCODE := 1;
832: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_SUCC');
833: -- Consolidation of Onhand Quantities completed successfully.
834: ERRBUF := FND_MESSAGE.get;
835: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',ERRBUF);
836:
837: --COMMIT; /* Commented for bug 7588761 */
838: RETURN;
839:

Line 850: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);

846: RETCODE := 2;
847: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
848: -- Consolidation of Onhand Quantities failed.
849: ERRBUF := FND_MESSAGE.get;
850: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
851: /* Added following if condition for bug 7588761 */
852: /* we should release any outstanding locks */
853: if g_lock_handle is not null then
854: l_err_code := dbms_lock.release(g_lock_handle);