DBA Data[Home] [Help]

APPS.INV_REDUCE_MOQD_PVT dependencies on FND_FILE

Line 61: fnd_file.put_line(fnd_file.log, x_err_msg);

57: if (p_request_id is null or p_org_id is null or p_item_id is null) then
58:
59: fnd_message.set_name('INV','INV_LOCK_RELEASE_MISSING_ARGS');
60: x_err_msg := fnd_message.get;
61: fnd_file.put_line(fnd_file.log, x_err_msg);
62: rollback;
63: end if;
64:
65: l_lock_handle := get_lock_handle (p_request_id, p_org_id, p_item_id);

Line 76: fnd_file.put_line(fnd_file.log, x_err_msg);

72: -- parameter error,illegal lockhandle
73: if x_err_code IN (3,5) THEN
74: fnd_message.set_name('INV','INV_LOCK_RELEASE_ERROR');
75: x_err_msg := fnd_message.get;
76: fnd_file.put_line(fnd_file.log, x_err_msg);
77: rollback;
78: end if;
79:
80: g_lock_handle :='';

Line 211: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

207: RETCODE := 2;
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;

Line 245: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

241: RETCODE := 2;
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;

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

258: RETCODE := 2;
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;

Line 285: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

281: END IF;
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;

Line 312: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

308: RETCODE := 2;
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;

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

489: RETCODE := 2;
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 */

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

674: RETCODE := 2;
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 */