DBA Data[Home] [Help]

APPS.GMIALLOC dependencies on FND_MSG_PUB

Line 157: FND_MSG_PUB.Initialize;

153:
154: /*====================End of Variable Declarations==============================*/
155: BEGIN
156: IF FND_API.to_boolean(p_init_msg_list) THEN
157: FND_MSG_PUB.Initialize;
158: END IF;
159: SAVEPOINT update_pending_allocations;
160: -- Standard call to check for call compatibility.
161: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 245: FND_MSG_PUB.Count_AND_GET

241:
242: IF FND_API.to_boolean(p_commit) THEN
243: COMMIT WORK;
244: END IF;
245: FND_MSG_PUB.Count_AND_GET
246: (p_count => x_msg_count, p_data => x_msg_data);
247:
248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN

Line 252: FND_MSG_PUB.Count_AND_GET

248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: ROLLBACK to update_pending_allocations;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MSG_PUB.Count_AND_GET
253: (p_count => x_msg_count, p_data => x_msg_data);
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK to update_pending_allocations;

Line 258: FND_MSG_PUB.Count_AND_GET

254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK to update_pending_allocations;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: FND_MSG_PUB.Count_AND_GET
259: (p_count => x_msg_count, p_data => x_msg_data);
260:
261: WHEN OTHERS THEN
262: ROLLBACK to update_pending_allocations;

Line 268: FND_MSG_PUB.Add;

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);
272:

Line 270: FND_MSG_PUB.Count_AND_GET

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);
272:
273:
274: END UPDATE_PENDING_ALLOCATIONS;

Line 350: FND_MSG_PUB.Initialize;

346: OMSO_pick_confirmed_txn_count NUMBER := 0;
347:
348: BEGIN
349: IF FND_API.to_boolean(p_init_msg_list) THEN
350: FND_MSG_PUB.Initialize;
351: END IF;
352: -- Standard call to check for call compatibility.
353: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
354: p_api_version ,

Line 452: FND_MSG_PUB.Add;

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: /* *****************************************************************
456: check if OMSO txns exist

Line 475: FND_MSG_PUB.Add;

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

Line 484: FND_MSG_PUB.Add;

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
488: --no need to move allocations

Line 492: FND_MSG_PUB.Count_AND_GET

488: --no need to move allocations
489: x_move_allocations := 'N'; /* move qty is less than or equal to unallocated qty */
490: END IF;--}
491:
492: FND_MSG_PUB.Count_AND_GET
493: (p_count => x_msg_count, p_data => x_msg_data);
494:
495: EXCEPTION
496: WHEN FND_API.G_EXC_ERROR THEN

Line 498: FND_MSG_PUB.Count_AND_GET

494:
495: EXCEPTION
496: WHEN FND_API.G_EXC_ERROR THEN
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: FND_MSG_PUB.Count_AND_GET
499: (p_count => x_msg_count, p_data => x_msg_data);
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 503: FND_MSG_PUB.Count_AND_GET

499: (p_count => x_msg_count, p_data => x_msg_data);
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: FND_MSG_PUB.Count_AND_GET
504: (p_count => x_msg_count, p_data => x_msg_data);
505:
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 512: FND_MSG_PUB.Add;

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);
516:

Line 514: FND_MSG_PUB.Count_AND_GET

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);
516:
517: END CHECK_ALLOC_QTY;
518:

Line 578: FND_MSG_PUB.Initialize;

574: OMSO_pick_confirmed_txn_count NUMBER := 0;
575:
576: BEGIN
577: IF FND_API.to_boolean(p_init_msg_list) THEN
578: FND_MSG_PUB.Initialize;
579: END IF;
580: -- Standard call to check for call compatibility.
581: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
582: p_api_version ,

Line 615: FND_MSG_PUB.Add;

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: /* *****************************************************************
619: check if OMSO txns exist

Line 641: FND_MSG_PUB.Add;

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

Line 647: FND_MSG_PUB.Count_AND_GET

643: END IF;--}
644:
645: END IF;--}
646:
647: FND_MSG_PUB.Count_AND_GET
648: (p_count => x_msg_count, p_data => x_msg_data);
649:
650: EXCEPTION
651: WHEN FND_API.G_EXC_ERROR THEN

Line 653: FND_MSG_PUB.Count_AND_GET

649:
650: EXCEPTION
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_AND_GET
654: (p_count => x_msg_count, p_data => x_msg_data);
655:
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 658: FND_MSG_PUB.Count_AND_GET

654: (p_count => x_msg_count, p_data => x_msg_data);
655:
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: FND_MSG_PUB.Count_AND_GET
659: (p_count => x_msg_count, p_data => x_msg_data);
660:
661: WHEN OTHERS THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 667: FND_MSG_PUB.Add;

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);
671:

Line 669: FND_MSG_PUB.Count_AND_GET

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);
671:
672: END VALIDATE_MOVEALLOC_FORMASSMOVE;
673: