DBA Data[Home] [Help]

APPS.GMIALLOC dependencies on FND_MESSAGE

Line 265: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');

261: WHEN OTHERS THEN
262: ROLLBACK to update_pending_allocations;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF (SQLCODE IS NOT NULL) THEN
265: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
266: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
267: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
268: FND_MSG_PUB.Add;
269: END IF;

Line 266: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

262: ROLLBACK to update_pending_allocations;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF (SQLCODE IS NOT NULL) THEN
265: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
266: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
267: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
268: FND_MSG_PUB.Add;
269: END IF;
270: FND_MSG_PUB.Count_AND_GET

Line 267: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));

263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF (SQLCODE IS NOT NULL) THEN
265: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
266: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
267: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
268: FND_MSG_PUB.Add;
269: END IF;
270: FND_MSG_PUB.Count_AND_GET
271: (p_count => x_msg_count, p_data => x_msg_data);

Line 451: FND_MESSAGE.SET_NAME('GMI','GMI_MOVE_TO_DIFF_WHSE');

447: ***************************************************************** */
448: --{
449: IF (pfrom_whse_code <> pto_whse_code) THEN
450:
451: FND_MESSAGE.SET_NAME('GMI','GMI_MOVE_TO_DIFF_WHSE');
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;--}
455: /* *****************************************************************

Line 474: FND_MESSAGE.SET_NAME('GMI','GMI_PICK_CNFRMD_ALLOC_EXISTS');

470: and pnd.trans_qty < 0
471: and pnd.staged_ind = 1;
472: --{
473: IF (OMSO_pick_confirmed_txn_count > 0) THEN
474: FND_MESSAGE.SET_NAME('GMI','GMI_PICK_CNFRMD_ALLOC_EXISTS');
475: FND_MSG_PUB.Add;
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;--}
478:

Line 483: FND_MESSAGE.SET_NAME('GMI','GMI_UNABLE_TO_MOVE_ALLOCATIONS');

479: END IF;--}
480: --allocations can be moved.
481: x_move_allocations := 'Y';
482: ELSE
483: FND_MESSAGE.SET_NAME('GMI','GMI_UNABLE_TO_MOVE_ALLOCATIONS');
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;--}
487: ELSE

Line 509: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');

505:
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF (SQLCODE IS NOT NULL) THEN
509: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
510: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
511: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
512: FND_MSG_PUB.Add;
513: END IF;

Line 510: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF (SQLCODE IS NOT NULL) THEN
509: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
510: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
511: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
512: FND_MSG_PUB.Add;
513: END IF;
514: FND_MSG_PUB.Count_AND_GET

Line 511: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));

507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: IF (SQLCODE IS NOT NULL) THEN
509: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
510: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
511: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
512: FND_MSG_PUB.Add;
513: END IF;
514: FND_MSG_PUB.Count_AND_GET
515: (p_count => x_msg_count, p_data => x_msg_data);

Line 614: FND_MESSAGE.SET_NAME('GMI','GMI_MOVE_TO_DIFF_WHSE');

610: ***************************************************************** */
611: --{
612: IF (pfrom_whse_code <> pto_whse_code) THEN
613:
614: FND_MESSAGE.SET_NAME('GMI','GMI_MOVE_TO_DIFF_WHSE');
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_ERROR;
617: END IF;--}
618: /* *****************************************************************

Line 640: FND_MESSAGE.SET_NAME('GMI','GMI_PICK_CNFRMD_ALLOC_EXISTS');

636: AND pnd.trans_qty < 0
637: AND pnd.staged_ind = 1;
638: --{
639: IF (OMSO_pick_confirmed_txn_count > 0) THEN
640: FND_MESSAGE.SET_NAME('GMI','GMI_PICK_CNFRMD_ALLOC_EXISTS');
641: FND_MSG_PUB.Add;
642: RAISE FND_API.G_EXC_ERROR;
643: END IF;--}
644:

Line 664: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');

660:
661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF (SQLCODE IS NOT NULL) THEN
664: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
665: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
666: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
667: FND_MSG_PUB.Add;
668: END IF;

Line 665: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF (SQLCODE IS NOT NULL) THEN
664: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
665: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
666: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
667: FND_MSG_PUB.Add;
668: END IF;
669: FND_MSG_PUB.Count_AND_GET

Line 666: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));

662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF (SQLCODE IS NOT NULL) THEN
664: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
665: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
666: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
667: FND_MSG_PUB.Add;
668: END IF;
669: FND_MSG_PUB.Count_AND_GET
670: (p_count => x_msg_count, p_data => x_msg_data);