DBA Data[Home] [Help]

APPS.MRP_SHIPPING_ORG_HANDLERS dependencies on FND_MSG_PUB

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

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

Line 61: FND_MSG_PUB.Add_Exc_Msg

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

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

154: EXCEPTION
155:
156: WHEN OTHERS THEN
157:
158: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
159: THEN
160: FND_MSG_PUB.Add_Exc_Msg
161: ( G_PKG_NAME
162: , 'Insert_Row'

Line 160: FND_MSG_PUB.Add_Exc_Msg

156: WHEN OTHERS THEN
157:
158: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
159: THEN
160: FND_MSG_PUB.Add_Exc_Msg
161: ( G_PKG_NAME
162: , 'Insert_Row'
163: );
164: END IF;

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

182: EXCEPTION
183:
184: WHEN OTHERS THEN
185:
186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: FND_MSG_PUB.Add_Exc_Msg
189: ( G_PKG_NAME
190: , 'Delete_Row'

Line 188: FND_MSG_PUB.Add_Exc_Msg

184: WHEN OTHERS THEN
185:
186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: FND_MSG_PUB.Add_Exc_Msg
189: ( G_PKG_NAME
190: , 'Delete_Row'
191: );
192: END IF;

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

475:
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
478:
479: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
480: THEN
481:
482: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
483: FND_MSG_PUB.Add;

Line 483: FND_MSG_PUB.Add;

479: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
480: THEN
481:
482: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
483: FND_MSG_PUB.Add;
484:
485: END IF;
486:
487: END IF;

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

492:
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
495:
496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
497: THEN
498:
499: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
500: FND_MSG_PUB.Add;

Line 500: FND_MSG_PUB.Add;

496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
497: THEN
498:
499: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
500: FND_MSG_PUB.Add;
501:
502: END IF;
503: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
504:

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

504:
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_ERROR;
507:
508: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
509: THEN
510:
511: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
512: FND_MSG_PUB.Add;

Line 512: FND_MSG_PUB.Add;

508: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
509: THEN
510:
511: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
512: FND_MSG_PUB.Add;
513:
514: END IF;
515: WHEN OTHERS THEN
516:

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

516:
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519:
520: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
521: THEN
522: FND_MSG_PUB.Add_Exc_Msg
523: ( G_PKG_NAME
524: , 'Lock_Row'

Line 522: FND_MSG_PUB.Add_Exc_Msg

518: x_Shipping_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519:
520: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
521: THEN
522: FND_MSG_PUB.Add_Exc_Msg
523: ( G_PKG_NAME
524: , 'Lock_Row'
525: );
526: END IF;

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

543: EXCEPTION
544:
545: WHEN OTHERS THEN
546:
547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME
551: , 'Query_Row'

Line 549: FND_MSG_PUB.Add_Exc_Msg

545: WHEN OTHERS THEN
546:
547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg
550: ( G_PKG_NAME
551: , 'Query_Row'
552: );
553: END IF;

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

583: EXCEPTION
584:
585: WHEN OTHERS THEN
586:
587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
588: THEN
589: FND_MSG_PUB.Add_Exc_Msg
590: ( G_PKG_NAME
591: , 'Query_Entity'

Line 589: FND_MSG_PUB.Add_Exc_Msg

585: WHEN OTHERS THEN
586:
587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
588: THEN
589: FND_MSG_PUB.Add_Exc_Msg
590: ( G_PKG_NAME
591: , 'Query_Entity'
592: );
593: END IF;

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

662: (p_Sr_Receipt_Id IS NOT NULL
663: AND
664: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)
665: THEN
666: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
667: THEN
668: FND_MSG_PUB.Add_Exc_Msg
669: ( G_PKG_NAME
670: , 'Query Rows'

Line 668: FND_MSG_PUB.Add_Exc_Msg

664: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)
665: THEN
666: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
667: THEN
668: FND_MSG_PUB.Add_Exc_Msg
669: ( G_PKG_NAME
670: , 'Query Rows'
671: , 'Keys are mutually exclusive: Sr_Source_Id = '|| p_Sr_Source_Id || ', Sr_Receipt_Id = '|| p_Sr_Receipt_Id
672: );

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

746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747:
748: WHEN OTHERS THEN
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg
753: ( G_PKG_NAME
754: , 'Query_Rows'

Line 752: FND_MSG_PUB.Add_Exc_Msg

748: WHEN OTHERS THEN
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg
753: ( G_PKG_NAME
754: , 'Query_Rows'
755: );
756: END IF;

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

828: (p_Sr_Receipt_Id IS NOT NULL
829: AND
830: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)
831: THEN
832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME
836: , 'Query Entities'

Line 834: FND_MSG_PUB.Add_Exc_Msg

830: p_Sr_Receipt_Id <> FND_API.G_MISS_NUM)
831: THEN
832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME
836: , 'Query Entities'
837: , 'Keys are mutually exclusive: Sr_Source_Id = '|| p_Sr_Source_Id || ', Sr_Receipt_Id = '|| p_Sr_Receipt_Id
838: );

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

911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
912:
913: WHEN OTHERS THEN
914:
915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
916: THEN
917: FND_MSG_PUB.Add_Exc_Msg
918: ( G_PKG_NAME
919: , 'Query_Entities'

Line 917: FND_MSG_PUB.Add_Exc_Msg

913: WHEN OTHERS THEN
914:
915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
916: THEN
917: FND_MSG_PUB.Add_Exc_Msg
918: ( G_PKG_NAME
919: , 'Query_Entities'
920: );
921: END IF;