DBA Data[Home] [Help]

APPS.INV_REDUCE_MOQD_PVT dependencies on FND_CONCURRENT

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

68: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
69: -- Consolidation of Onhand Quantities failed.
70: ERRBUF := FND_MESSAGE.get;
71: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
72: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
73: ROLLBACK;
74: RETURN;
75: END IF;
76:

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

102: FND_MESSAGE.set_name('INV','INV_MOQD_FIFO_SET');
103: -- 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.
104: ERRBUF := FND_MESSAGE.get;
105: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
106: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
107: ROLLBACK;
108: RETURN;
109: END IF;
110: ELSE -- l_profile = 'Y'

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

119: FND_MESSAGE.set_name('INV','INV_MOQD_FIFO_SET');
120: -- 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.
121: ERRBUF := FND_MESSAGE.get;
122: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
123: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
124: ROLLBACK;
125: RETURN;
126: END IF;
127:

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

140: RETCODE := 2;
141: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
142: -- Consolidation of Onhand Quantities failed.
143: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
144: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
145: RETURN;
146: END IF;
147: CLOSE elig_orgs;
148: END;

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

165: FND_MESSAGE.set_name('INV','INV_MOQD_CANNOT_LOCK');
166: -- The Onhand Quantities table cannot be locked for consolidation.
167: ERRBUF := FND_MESSAGE.get;
168: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
169: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
170: ROLLBACK;
171: RETURN;
172: END;
173:

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

312: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
313: -- Consolidation of Onhand Quantities failed.
314: ERRBUF := FND_MESSAGE.get;
315: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
316: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
317: ROLLBACK;
318: RETURN;
319: END IF;
320:

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

481: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
482: -- Consolidation of Onhand Quantities failed.
483: ERRBUF := FND_MESSAGE.get;
484: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
485: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
486: ROLLBACK;
487: RETURN;
488: END IF;
489:

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

600: RETCODE := 1;
601: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_SUCC');
602: -- Consolidation of Onhand Quantities completed successfully.
603: ERRBUF := FND_MESSAGE.get;
604: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL',ERRBUF);
605:
606: COMMIT;
607: RETURN;
608:

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

615: RETCODE := 2;
616: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');
617: -- Consolidation of Onhand Quantities failed.
618: ERRBUF := FND_MESSAGE.get;
619: l_ret := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
620: ROLLBACK;
621: RETURN;
622: END;
623: