DBA Data[Home] [Help]

APPS.MRP_ASSIGNMENT_HANDLERS dependencies on FND_MSG_PUB

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

57: EXCEPTION
58:
59: WHEN OTHERS THEN
60:
61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
62: THEN
63: FND_MSG_PUB.Add_Exc_Msg
64: ( G_PKG_NAME
65: , 'Update_Row'

Line 63: FND_MSG_PUB.Add_Exc_Msg

59: WHEN OTHERS THEN
60:
61: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
62: THEN
63: FND_MSG_PUB.Add_Exc_Msg
64: ( G_PKG_NAME
65: , 'Update_Row'
66: );
67: END IF;

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

160: EXCEPTION
161:
162: WHEN OTHERS THEN
163:
164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: THEN
166: FND_MSG_PUB.Add_Exc_Msg
167: ( G_PKG_NAME
168: , 'Insert_Row'

Line 166: FND_MSG_PUB.Add_Exc_Msg

162: WHEN OTHERS THEN
163:
164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: THEN
166: FND_MSG_PUB.Add_Exc_Msg
167: ( G_PKG_NAME
168: , 'Insert_Row'
169: );
170: END IF;

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

188: EXCEPTION
189:
190: WHEN OTHERS THEN
191:
192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
193: THEN
194: FND_MSG_PUB.Add_Exc_Msg
195: ( G_PKG_NAME
196: , 'Delete_Row'

Line 194: FND_MSG_PUB.Add_Exc_Msg

190: WHEN OTHERS THEN
191:
192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
193: THEN
194: FND_MSG_PUB.Add_Exc_Msg
195: ( G_PKG_NAME
196: , 'Delete_Row'
197: );
198: END IF;

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

495:
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
498:
499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
500: THEN
501:
502: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
503: FND_MSG_PUB.Add;

Line 503: FND_MSG_PUB.Add;

499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
500: THEN
501:
502: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
503: FND_MSG_PUB.Add;
504:
505: END IF;
506:
507: END IF;

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

512:
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
515:
516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
517: THEN
518:
519: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
520: FND_MSG_PUB.Add;

Line 520: FND_MSG_PUB.Add;

516: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
517: THEN
518:
519: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
520: FND_MSG_PUB.Add;
521:
522: END IF;
523: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
524:

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

524:
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: x_Assignment_rec.return_status := FND_API.G_RET_STS_ERROR;
527:
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
529: THEN
530:
531: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
532: FND_MSG_PUB.Add;

Line 532: FND_MSG_PUB.Add;

528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
529: THEN
530:
531: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
532: FND_MSG_PUB.Add;
533:
534: END IF;
535: WHEN OTHERS THEN
536:

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

536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: x_Assignment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539:
540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: FND_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'Lock_Row'

Line 542: FND_MSG_PUB.Add_Exc_Msg

538: x_Assignment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539:
540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: FND_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'Lock_Row'
545: );
546: END IF;

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

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

Line 569: FND_MSG_PUB.Add_Exc_Msg

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

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

603: EXCEPTION
604:
605: WHEN OTHERS THEN
606:
607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.Add_Exc_Msg
610: ( G_PKG_NAME
611: , 'Query_Entity'

Line 609: FND_MSG_PUB.Add_Exc_Msg

605: WHEN OTHERS THEN
606:
607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.Add_Exc_Msg
610: ( G_PKG_NAME
611: , 'Query_Entity'
612: );
613: END IF;

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

684: (p_Assignment_Set_Id IS NOT NULL
685: AND
686: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)
687: THEN
688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg
691: ( G_PKG_NAME
692: , 'Query Rows'

Line 690: FND_MSG_PUB.Add_Exc_Msg

686: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)
687: THEN
688: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
689: THEN
690: FND_MSG_PUB.Add_Exc_Msg
691: ( G_PKG_NAME
692: , 'Query Rows'
693: , 'Keys are mutually exclusive: Assignment_Id = '|| p_Assignment_Id || ', Assignment_Set_Id = '|| p_Assignment_Set_Id
694: );

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

770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771:
772: WHEN OTHERS THEN
773:
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , 'Query_Rows'

Line 776: FND_MSG_PUB.Add_Exc_Msg

772: WHEN OTHERS THEN
773:
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , 'Query_Rows'
779: );
780: END IF;

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

854: (p_Assignment_Set_Id IS NOT NULL
855: AND
856: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)
857: THEN
858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
859: THEN
860: FND_MSG_PUB.Add_Exc_Msg
861: ( G_PKG_NAME
862: , 'Query Entities'

Line 860: FND_MSG_PUB.Add_Exc_Msg

856: p_Assignment_Set_Id <> FND_API.G_MISS_NUM)
857: THEN
858: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
859: THEN
860: FND_MSG_PUB.Add_Exc_Msg
861: ( G_PKG_NAME
862: , 'Query Entities'
863: , 'Keys are mutually exclusive: Assignment_Id = '|| p_Assignment_Id || ', Assignment_Set_Id = '|| p_Assignment_Set_Id
864: );

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

939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940:
941: WHEN OTHERS THEN
942:
943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
944: THEN
945: FND_MSG_PUB.Add_Exc_Msg
946: ( G_PKG_NAME
947: , 'Query_Entities'

Line 945: FND_MSG_PUB.Add_Exc_Msg

941: WHEN OTHERS THEN
942:
943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
944: THEN
945: FND_MSG_PUB.Add_Exc_Msg
946: ( G_PKG_NAME
947: , 'Query_Entities'
948: );
949: END IF;