eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_REDUCE_MOQD_PVT dependencies on FND_MESSAGE

Line 59: fnd_message.set_name('INV','INV_LOCK_RELEASE_MISSING_ARGS');

55: BEGIN
56:
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;

Line 60: x_err_msg := fnd_message.get;

56:
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:

Line 74: fnd_message.set_name('INV','INV_LOCK_RELEASE_ERROR');

70:
71: x_err_code := dbms_lock.release(l_lock_handle);
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;

Line 75: x_err_msg := fnd_message.get;

71: x_err_code := dbms_lock.release(l_lock_handle);
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:

Line 208: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');

204: IF(g_debug = 1) THEN
205: debug('The parameter P_ORG_ID cannot be NULL');
206: END IF;
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);

Line 210: ERRBUF := FND_MESSAGE.get;

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

Line 242: FND_MESSAGE.set_name('INV','INV_MOQD_FIFO_SET');

238: IF(g_debug = 1) THEN
239: debug('The Profile INV: FIFO for Original Receipt Date is set to Yes at Appl/Resp/User Level');
240: END IF;
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);

Line 244: ERRBUF := FND_MESSAGE.get;

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

Line 259: FND_MESSAGE.set_name('INV','INV_MOQD_FIFO_SET');

255: IF(g_debug = 1) THEN
256: debug('The Profile INV: FIFO for Original Receipt Date is set to Yes and this program should not be run when this option is set to Yes');
257: END IF;
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);

Line 261: ERRBUF := FND_MESSAGE.get;

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

Line 283: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');

279: -- Allow for process enabled orgs.
280: debug('This Organization is WMS enabled'); /* or Process enabled'); */
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;

Line 309: FND_MESSAGE.set_name('INV','INV_MOQD_CANNOT_LOCK');

305: CLOSE lock_moqd;
306: END IF;
307:
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);

Line 311: ERRBUF := FND_MESSAGE.get;

307:
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;

Line 490: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');

486: IF(g_debug = 1) THEN
487: debug('MOQD and Backup Count are not same');
488: END IF;
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);

Line 492: ERRBUF := FND_MESSAGE.get;

488: END IF;
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 */

Line 675: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');

671: IF(g_debug = 1) THEN
672: debug('Sum of MOQ Qty and Backup Qty Count are not same');
673: END IF;
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);

Line 677: ERRBUF := FND_MESSAGE.get;

673: END IF;
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 */

Line 832: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_SUCC');

828: debug('Completed Successfully, total number of item processed '||l_proc_cnt);
829: END IF;
830:
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:

Line 834: ERRBUF := FND_MESSAGE.get;

830:
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;

Line 847: FND_MESSAGE.set_name('INV','INV_MOQD_REQ_ERR');

843: debug('Error during script, Statement = '||l_stmt_count);
844: debug('Rolling back... Error Message = ' ||SQLERRM);
845: END IF;
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 */

Line 849: ERRBUF := FND_MESSAGE.get;

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