DBA Data[Home] [Help]

APPS.MRP_RECEIVING_ORG_HANDLERS dependencies on FND_MSG_PUB

Line 54: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

50: EXCEPTION
51:
52: WHEN OTHERS THEN
53:
54: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
55: THEN
56: FND_MSG_PUB.Add_Exc_Msg
57: ( G_PKG_NAME
58: , 'Update_Row'

Line 56: FND_MSG_PUB.Add_Exc_Msg

52: WHEN OTHERS THEN
53:
54: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
55: THEN
56: FND_MSG_PUB.Add_Exc_Msg
57: ( G_PKG_NAME
58: , 'Update_Row'
59: );
60: END IF;

Line 143: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

139: EXCEPTION
140:
141: WHEN OTHERS THEN
142:
143: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg
146: ( G_PKG_NAME
147: , 'Insert_Row'

Line 145: FND_MSG_PUB.Add_Exc_Msg

141: WHEN OTHERS THEN
142:
143: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg
146: ( G_PKG_NAME
147: , 'Insert_Row'
148: );
149: END IF;

Line 199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

195: EXCEPTION
196:
197: WHEN OTHERS THEN
198:
199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg
202: ( G_PKG_NAME
203: , 'Delete_Row'

Line 201: FND_MSG_PUB.Add_Exc_Msg

197: WHEN OTHERS THEN
198:
199: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg
202: ( G_PKG_NAME
203: , 'Delete_Row'
204: );
205: END IF;

Line 457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

453:
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: x_Receiving_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
456:
457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
458: THEN
459:
460: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
461: FND_MSG_PUB.Add;

Line 461: FND_MSG_PUB.Add;

457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
458: THEN
459:
460: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
461: FND_MSG_PUB.Add;
462:
463: END IF;
464:
465: END IF;

Line 474: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

470:
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: x_Receiving_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
473:
474: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
475: THEN
476:
477: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
478: FND_MSG_PUB.Add;

Line 478: FND_MSG_PUB.Add;

474: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
475: THEN
476:
477: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
478: FND_MSG_PUB.Add;
479:
480: END IF;
481: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
482:

Line 486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

482:
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: x_Receiving_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
485:
486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
487: THEN
488:
489: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
490: FND_MSG_PUB.Add;

Line 490: FND_MSG_PUB.Add;

486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
487: THEN
488:
489: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
490: FND_MSG_PUB.Add;
491:
492: END IF;
493: WHEN OTHERS THEN
494:

Line 498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: x_Receiving_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497:
498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: FND_MSG_PUB.Add_Exc_Msg
501: ( G_PKG_NAME
502: , 'Lock_Row'

Line 500: FND_MSG_PUB.Add_Exc_Msg

496: x_Receiving_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497:
498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: FND_MSG_PUB.Add_Exc_Msg
501: ( G_PKG_NAME
502: , 'Lock_Row'
503: );
504: END IF;

Line 525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

521: EXCEPTION
522:
523: WHEN OTHERS THEN
524:
525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg
528: ( G_PKG_NAME
529: , 'Query_Row'

Line 527: FND_MSG_PUB.Add_Exc_Msg

523: WHEN OTHERS THEN
524:
525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: FND_MSG_PUB.Add_Exc_Msg
528: ( G_PKG_NAME
529: , 'Query_Row'
530: );
531: END IF;

Line 565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

561: EXCEPTION
562:
563: WHEN OTHERS THEN
564:
565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: FND_MSG_PUB.Add_Exc_Msg
568: ( G_PKG_NAME
569: , 'Query_Entity'

Line 567: FND_MSG_PUB.Add_Exc_Msg

563: WHEN OTHERS THEN
564:
565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: FND_MSG_PUB.Add_Exc_Msg
568: ( G_PKG_NAME
569: , 'Query_Entity'
570: );
571: END IF;

Line 639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

635: (p_Sourcing_Rule_Id IS NOT NULL
636: AND
637: p_Sourcing_Rule_Id <> FND_API.G_MISS_NUM)
638: THEN
639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN
641: FND_MSG_PUB.Add_Exc_Msg
642: ( G_PKG_NAME
643: , 'Query Rows'

Line 641: FND_MSG_PUB.Add_Exc_Msg

637: p_Sourcing_Rule_Id <> FND_API.G_MISS_NUM)
638: THEN
639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
640: THEN
641: FND_MSG_PUB.Add_Exc_Msg
642: ( G_PKG_NAME
643: , 'Query Rows'
644: , 'Keys are mutually exclusive: Sr_Receipt_Id = '|| p_Sr_Receipt_Id || ', Sourcing_Rule_Id = '|| p_Sourcing_Rule_Id
645: );

Line 718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715:
716: WHEN OTHERS THEN
717:
718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: FND_MSG_PUB.Add_Exc_Msg
721: ( G_PKG_NAME
722: , 'Query_Rows'

Line 720: FND_MSG_PUB.Add_Exc_Msg

716: WHEN OTHERS THEN
717:
718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
719: THEN
720: FND_MSG_PUB.Add_Exc_Msg
721: ( G_PKG_NAME
722: , 'Query_Rows'
723: );
724: END IF;

Line 795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

791: (p_Sourcing_Rule_Id IS NOT NULL
792: AND
793: p_Sourcing_Rule_Id <> FND_API.G_MISS_NUM)
794: THEN
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
796: THEN
797: FND_MSG_PUB.Add_Exc_Msg
798: ( G_PKG_NAME
799: , 'Query Entities'

Line 797: FND_MSG_PUB.Add_Exc_Msg

793: p_Sourcing_Rule_Id <> FND_API.G_MISS_NUM)
794: THEN
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
796: THEN
797: FND_MSG_PUB.Add_Exc_Msg
798: ( G_PKG_NAME
799: , 'Query Entities'
800: , 'Keys are mutually exclusive: Sr_Receipt_Id = '|| p_Sr_Receipt_Id || ', Sourcing_Rule_Id = '|| p_Sourcing_Rule_Id
801: );

Line 873: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870:
871: WHEN OTHERS THEN
872:
873: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
874: THEN
875: FND_MSG_PUB.Add_Exc_Msg
876: ( G_PKG_NAME
877: , 'Query_Entities'

Line 875: FND_MSG_PUB.Add_Exc_Msg

871: WHEN OTHERS THEN
872:
873: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
874: THEN
875: FND_MSG_PUB.Add_Exc_Msg
876: ( G_PKG_NAME
877: , 'Query_Entities'
878: );
879: END IF;