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.GML_RCV_DB_COMMON dependencies on FND_MESSAGE

Line 230: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');

226: And uom_code = ORDER_QUANTITY_UOM;
227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
231: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
232: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
233: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
234: FND_MSG_PUB.ADD;

Line 231: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
231: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
232: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
233: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
234: FND_MSG_PUB.ADD;
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 232: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);

228: EXCEPTION
229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
231: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
232: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
233: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
234: FND_MSG_PUB.ADD;
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END;

Line 233: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));

229: WHEN OTHERS THEN
230: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
231: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
232: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
233: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
234: FND_MSG_PUB.ADD;
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END;
237:

Line 253: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');

249: Where uom_code = p_rma_lot_uom;
250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
254: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
255: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
256: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
257: FND_MSG_PUB.ADD;

Line 254: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
254: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
255: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
256: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 255: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);

251: EXCEPTION
252: WHEN OTHERS THEN
253: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
254: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
255: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
256: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END;

Line 256: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));

252: WHEN OTHERS THEN
253: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
254: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
255: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
256: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END;
260: END IF;

Line 279: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');

275: And nvl(sublot_number,' ') = nvl(p_sublot_no,' ');
276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
280: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
281: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
282: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
283: FND_MSG_PUB.ADD;

Line 280: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
280: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
281: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
282: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
283: FND_MSG_PUB.ADD;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 281: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);

277: EXCEPTION
278: WHEN OTHERS THEN
279: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
280: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
281: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
282: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
283: FND_MSG_PUB.ADD;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END;

Line 282: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));

278: WHEN OTHERS THEN
279: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
280: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
281: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
282: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
283: FND_MSG_PUB.ADD;
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END;
286: ELSE

Line 326: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');

322: Where item_id = p_opm_item_id;
323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
327: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
328: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
329: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
330: FND_MSG_PUB.ADD;

Line 327: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

323:
324: EXCEPTION
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
327: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
328: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
329: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 328: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);

324: EXCEPTION
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
327: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
328: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
329: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END;

Line 329: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));

325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
327: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
328: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
329: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END;
333:

Line 350: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');

346: l_lot_recv_uom,
347: 0);
348: IF (l_trx_opm_qty < 0) THEN
349: IF (l_trx_opm_qty = -1) THEN
350: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
351: ELSIF (l_trx_opm_qty = -3) THEN
352: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
353: ELSIF (l_trx_opm_qty = -4) THEN
354: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

Line 352: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');

348: IF (l_trx_opm_qty < 0) THEN
349: IF (l_trx_opm_qty = -1) THEN
350: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
351: ELSIF (l_trx_opm_qty = -3) THEN
352: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
353: ELSIF (l_trx_opm_qty = -4) THEN
354: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
355: ELSIF (l_trx_opm_qty = -5) THEN
356: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 354: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

350: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
351: ELSIF (l_trx_opm_qty = -3) THEN
352: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
353: ELSIF (l_trx_opm_qty = -4) THEN
354: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
355: ELSIF (l_trx_opm_qty = -5) THEN
356: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
357: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
358: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

Line 356: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

352: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
353: ELSIF (l_trx_opm_qty = -4) THEN
354: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
355: ELSIF (l_trx_opm_qty = -5) THEN
356: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
357: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
358: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
359: ELSIF (l_trx_opm_qty = -6) THEN
360: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

Line 357: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);

353: ELSIF (l_trx_opm_qty = -4) THEN
354: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
355: ELSIF (l_trx_opm_qty = -5) THEN
356: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
357: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
358: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
359: ELSIF (l_trx_opm_qty = -6) THEN
360: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
361: ELSIF (l_trx_opm_qty = -7) THEN

Line 358: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

354: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
355: ELSIF (l_trx_opm_qty = -5) THEN
356: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
357: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
358: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
359: ELSIF (l_trx_opm_qty = -6) THEN
360: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
361: ELSIF (l_trx_opm_qty = -7) THEN
362: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

Line 360: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

356: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
357: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
358: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
359: ELSIF (l_trx_opm_qty = -6) THEN
360: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
361: ELSIF (l_trx_opm_qty = -7) THEN
362: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
363: ELSIF (l_trx_opm_qty = -10) THEN
364: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 362: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

358: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
359: ELSIF (l_trx_opm_qty = -6) THEN
360: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
361: ELSIF (l_trx_opm_qty = -7) THEN
362: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
363: ELSIF (l_trx_opm_qty = -10) THEN
364: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
365: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
366: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

Line 364: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

360: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
361: ELSIF (l_trx_opm_qty = -7) THEN
362: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
363: ELSIF (l_trx_opm_qty = -10) THEN
364: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
365: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
366: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
367: ELSIF (l_trx_opm_qty = -11) THEN
368: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

Line 365: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);

361: ELSIF (l_trx_opm_qty = -7) THEN
362: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
363: ELSIF (l_trx_opm_qty = -10) THEN
364: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
365: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
366: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
367: ELSIF (l_trx_opm_qty = -11) THEN
368: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
369: ELSIF (l_trx_opm_qty < -11) THEN

Line 366: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

362: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
363: ELSIF (l_trx_opm_qty = -10) THEN
364: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
365: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
366: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
367: ELSIF (l_trx_opm_qty = -11) THEN
368: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
369: ELSIF (l_trx_opm_qty < -11) THEN
370: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

Line 368: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

364: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
365: FND_MESSAGE.set_token('FROMUOM',l_trx_opm_uom);
366: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
367: ELSIF (l_trx_opm_qty = -11) THEN
368: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
369: ELSIF (l_trx_opm_qty < -11) THEN
370: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
371: END IF;
372: FND_MSG_PUB.ADD;

Line 370: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

366: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
367: ELSIF (l_trx_opm_qty = -11) THEN
368: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
369: ELSIF (l_trx_opm_qty < -11) THEN
370: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
371: END IF;
372: FND_MSG_PUB.ADD;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;

Line 395: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');

391: l_lot_recv_uom,
392: 0);
393: IF (l_rma_lot_opm_qty < 0) THEN
394: IF (l_rma_lot_opm_qty = -1) THEN
395: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
396: ELSIF (l_rma_lot_opm_qty = -3) THEN
397: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
398: ELSIF (l_rma_lot_opm_qty = -4) THEN
399: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

Line 397: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');

393: IF (l_rma_lot_opm_qty < 0) THEN
394: IF (l_rma_lot_opm_qty = -1) THEN
395: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
396: ELSIF (l_rma_lot_opm_qty = -3) THEN
397: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
398: ELSIF (l_rma_lot_opm_qty = -4) THEN
399: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
400: ELSIF (l_rma_lot_opm_qty = -5) THEN
401: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 399: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

395: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
396: ELSIF (l_rma_lot_opm_qty = -3) THEN
397: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
398: ELSIF (l_rma_lot_opm_qty = -4) THEN
399: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
400: ELSIF (l_rma_lot_opm_qty = -5) THEN
401: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
402: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
403: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

Line 401: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

397: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
398: ELSIF (l_rma_lot_opm_qty = -4) THEN
399: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
400: ELSIF (l_rma_lot_opm_qty = -5) THEN
401: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
402: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
403: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
404: ELSIF (l_rma_lot_opm_qty = -6) THEN
405: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

Line 402: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);

398: ELSIF (l_rma_lot_opm_qty = -4) THEN
399: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
400: ELSIF (l_rma_lot_opm_qty = -5) THEN
401: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
402: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
403: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
404: ELSIF (l_rma_lot_opm_qty = -6) THEN
405: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
406: ELSIF (l_rma_lot_opm_qty = -7) THEN

Line 403: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

399: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
400: ELSIF (l_rma_lot_opm_qty = -5) THEN
401: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
402: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
403: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
404: ELSIF (l_rma_lot_opm_qty = -6) THEN
405: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
406: ELSIF (l_rma_lot_opm_qty = -7) THEN
407: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

Line 405: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

401: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
402: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
403: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
404: ELSIF (l_rma_lot_opm_qty = -6) THEN
405: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
406: ELSIF (l_rma_lot_opm_qty = -7) THEN
407: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
408: ELSIF (l_rma_lot_opm_qty = -10) THEN
409: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 407: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

403: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
404: ELSIF (l_rma_lot_opm_qty = -6) THEN
405: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
406: ELSIF (l_rma_lot_opm_qty = -7) THEN
407: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
408: ELSIF (l_rma_lot_opm_qty = -10) THEN
409: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
410: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
411: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

Line 409: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

405: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
406: ELSIF (l_rma_lot_opm_qty = -7) THEN
407: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
408: ELSIF (l_rma_lot_opm_qty = -10) THEN
409: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
410: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
411: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
412: ELSIF (l_rma_lot_opm_qty = -11) THEN
413: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

Line 410: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);

406: ELSIF (l_rma_lot_opm_qty = -7) THEN
407: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
408: ELSIF (l_rma_lot_opm_qty = -10) THEN
409: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
410: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
411: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
412: ELSIF (l_rma_lot_opm_qty = -11) THEN
413: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
414: ELSIF (l_rma_lot_opm_qty < -11) THEN

Line 411: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);

407: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
408: ELSIF (l_rma_lot_opm_qty = -10) THEN
409: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
410: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
411: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
412: ELSIF (l_rma_lot_opm_qty = -11) THEN
413: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
414: ELSIF (l_rma_lot_opm_qty < -11) THEN
415: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

Line 413: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

409: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
410: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
411: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
412: ELSIF (l_rma_lot_opm_qty = -11) THEN
413: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
414: ELSIF (l_rma_lot_opm_qty < -11) THEN
415: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
416: END IF;
417: FND_MSG_PUB.ADD;

Line 415: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

411: FND_MESSAGE.set_token('TOUOM',l_lot_recv_uom);
412: ELSIF (l_rma_lot_opm_qty = -11) THEN
413: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
414: ELSIF (l_rma_lot_opm_qty < -11) THEN
415: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
416: END IF;
417: FND_MSG_PUB.ADD;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;

Line 444: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');

440: l_trx_opm_uom,
441: 0);
442: IF (X_allowed_quantity < 0) THEN
443: IF (X_allowed_quantity = -1) THEN
444: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
445: ELSIF (X_allowed_quantity = -3) THEN
446: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
447: ELSIF (X_allowed_quantity = -4) THEN
448: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

Line 446: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');

442: IF (X_allowed_quantity < 0) THEN
443: IF (X_allowed_quantity = -1) THEN
444: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
445: ELSIF (X_allowed_quantity = -3) THEN
446: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
447: ELSIF (X_allowed_quantity = -4) THEN
448: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
449: ELSIF (X_allowed_quantity = -5) THEN
450: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 448: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

444: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
445: ELSIF (X_allowed_quantity = -3) THEN
446: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
447: ELSIF (X_allowed_quantity = -4) THEN
448: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
449: ELSIF (X_allowed_quantity = -5) THEN
450: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
451: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
452: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

Line 450: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

446: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
447: ELSIF (X_allowed_quantity = -4) THEN
448: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
449: ELSIF (X_allowed_quantity = -5) THEN
450: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
451: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
452: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
453: ELSIF (X_allowed_quantity = -6) THEN
454: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

Line 451: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);

447: ELSIF (X_allowed_quantity = -4) THEN
448: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
449: ELSIF (X_allowed_quantity = -5) THEN
450: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
451: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
452: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
453: ELSIF (X_allowed_quantity = -6) THEN
454: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
455: ELSIF (X_allowed_quantity = -7) THEN

Line 452: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

448: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
449: ELSIF (X_allowed_quantity = -5) THEN
450: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
451: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
452: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
453: ELSIF (X_allowed_quantity = -6) THEN
454: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
455: ELSIF (X_allowed_quantity = -7) THEN
456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

Line 454: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

450: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
451: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
452: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
453: ELSIF (X_allowed_quantity = -6) THEN
454: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
455: ELSIF (X_allowed_quantity = -7) THEN
456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
457: ELSIF (X_allowed_quantity = -10) THEN
458: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

452: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
453: ELSIF (X_allowed_quantity = -6) THEN
454: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
455: ELSIF (X_allowed_quantity = -7) THEN
456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
457: ELSIF (X_allowed_quantity = -10) THEN
458: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
459: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
460: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

Line 458: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

454: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
455: ELSIF (X_allowed_quantity = -7) THEN
456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
457: ELSIF (X_allowed_quantity = -10) THEN
458: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
459: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
460: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
461: ELSIF (X_allowed_quantity = -11) THEN
462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

Line 459: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);

455: ELSIF (X_allowed_quantity = -7) THEN
456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
457: ELSIF (X_allowed_quantity = -10) THEN
458: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
459: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
460: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
461: ELSIF (X_allowed_quantity = -11) THEN
462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
463: ELSIF (X_allowed_quantity < -11) THEN

Line 460: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

456: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
457: ELSIF (X_allowed_quantity = -10) THEN
458: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
459: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
460: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
461: ELSIF (X_allowed_quantity = -11) THEN
462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
463: ELSIF (X_allowed_quantity < -11) THEN
464: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

Line 462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

458: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
459: FND_MESSAGE.set_token('FROMUOM',l_lot_recv_uom);
460: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
461: ELSIF (X_allowed_quantity = -11) THEN
462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
463: ELSIF (X_allowed_quantity < -11) THEN
464: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
465: END IF;
466: FND_MSG_PUB.ADD;

Line 464: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

460: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
461: ELSIF (X_allowed_quantity = -11) THEN
462: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
463: ELSIF (X_allowed_quantity < -11) THEN
464: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
465: END IF;
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;

Line 495: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');

491: l_trx_opm_uom,
492: 0);
493: IF (l_rma_lot_opm_qty < 0) THEN
494: IF (l_rma_lot_opm_qty = -1) THEN
495: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
496: ELSIF (l_rma_lot_opm_qty = -3) THEN
497: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
498: ELSIF (l_rma_lot_opm_qty = -4) THEN
499: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

Line 497: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');

493: IF (l_rma_lot_opm_qty < 0) THEN
494: IF (l_rma_lot_opm_qty = -1) THEN
495: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
496: ELSIF (l_rma_lot_opm_qty = -3) THEN
497: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
498: ELSIF (l_rma_lot_opm_qty = -4) THEN
499: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
500: ELSIF (l_rma_lot_opm_qty = -5) THEN
501: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 499: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');

495: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_PACKAGE_ERR');
496: ELSIF (l_rma_lot_opm_qty = -3) THEN
497: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
498: ELSIF (l_rma_lot_opm_qty = -4) THEN
499: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
500: ELSIF (l_rma_lot_opm_qty = -5) THEN
501: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
502: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
503: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

Line 501: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

497: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURUMTYPE_ERR');
498: ELSIF (l_rma_lot_opm_qty = -4) THEN
499: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
500: ELSIF (l_rma_lot_opm_qty = -5) THEN
501: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
502: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
503: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
504: ELSIF (l_rma_lot_opm_qty = -6) THEN
505: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

Line 502: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);

498: ELSIF (l_rma_lot_opm_qty = -4) THEN
499: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
500: ELSIF (l_rma_lot_opm_qty = -5) THEN
501: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
502: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
503: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
504: ELSIF (l_rma_lot_opm_qty = -6) THEN
505: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
506: ELSIF (l_rma_lot_opm_qty = -7) THEN

Line 503: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

499: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NEWUMTYPE_ERR');
500: ELSIF (l_rma_lot_opm_qty = -5) THEN
501: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
502: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
503: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
504: ELSIF (l_rma_lot_opm_qty = -6) THEN
505: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
506: ELSIF (l_rma_lot_opm_qty = -7) THEN
507: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

Line 505: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');

501: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
502: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
503: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
504: ELSIF (l_rma_lot_opm_qty = -6) THEN
505: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
506: ELSIF (l_rma_lot_opm_qty = -7) THEN
507: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
508: ELSIF (l_rma_lot_opm_qty = -10) THEN
509: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

Line 507: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');

503: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
504: ELSIF (l_rma_lot_opm_qty = -6) THEN
505: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
506: ELSIF (l_rma_lot_opm_qty = -7) THEN
507: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
508: ELSIF (l_rma_lot_opm_qty = -10) THEN
509: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
510: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
511: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

Line 509: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');

505: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUMTYPE_ERR');
506: ELSIF (l_rma_lot_opm_qty = -7) THEN
507: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
508: ELSIF (l_rma_lot_opm_qty = -10) THEN
509: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
510: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
511: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
512: ELSIF (l_rma_lot_opm_qty = -11) THEN
513: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

Line 510: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);

506: ELSIF (l_rma_lot_opm_qty = -7) THEN
507: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
508: ELSIF (l_rma_lot_opm_qty = -10) THEN
509: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
510: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
511: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
512: ELSIF (l_rma_lot_opm_qty = -11) THEN
513: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
514: ELSIF (l_rma_lot_opm_qty < -11) THEN

Line 511: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);

507: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_CURFACTOR_ERR');
508: ELSIF (l_rma_lot_opm_qty = -10) THEN
509: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
510: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
511: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
512: ELSIF (l_rma_lot_opm_qty = -11) THEN
513: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
514: ELSIF (l_rma_lot_opm_qty < -11) THEN
515: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

Line 513: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');

509: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_INVUOMTYPE_ERR2');
510: FND_MESSAGE.set_token('FROMUOM',l_rma_lot_opm_uom);
511: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
512: ELSIF (l_rma_lot_opm_qty = -11) THEN
513: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
514: ELSIF (l_rma_lot_opm_qty < -11) THEN
515: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
516: END IF;
517: FND_MSG_PUB.ADD;

Line 515: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');

511: FND_MESSAGE.set_token('TOUOM',l_trx_opm_uom);
512: ELSIF (l_rma_lot_opm_qty = -11) THEN
513: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_NOITEMID_ERR');
514: ELSIF (l_rma_lot_opm_qty < -11) THEN
515: FND_MESSAGE.set_name('GMI', 'IC_UOMCV_FATAL_ERR');
516: END IF;
517: FND_MSG_PUB.ADD;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;

Line 552: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');

548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
553: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
554: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
555: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
556: FND_MSG_PUB.ADD;

Line 553: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);

549:
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
553: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
554: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
555: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
556: FND_MSG_PUB.ADD;
557: /* Bug 4502018 */

Line 554: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);

550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
553: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
554: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
555: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
556: FND_MSG_PUB.ADD;
557: /* Bug 4502018 */
558: -- IF (g_fnd_debug = 'Y') THEN

Line 555: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));

551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MESSAGE.SET_NAME('GMI','GMI_SQL_ERROR');
553: FND_MESSAGE.SET_TOKEN('WHERE','GML_RCV_DB_COMMON.VALIDATE_RMA_LOT_QUANTITIES'||'-'||l_progress);
554: FND_MESSAGE.SET_TOKEN('SQL_CODE',SQLCODE);
555: FND_MESSAGE.SET_TOKEN('SQL_ERRM',SQLERRM(SQLCODE));
556: FND_MSG_PUB.ADD;
557: /* Bug 4502018 */
558: -- IF (g_fnd_debug = 'Y') THEN
559: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then