132: THEN
133:
134: l_return_status := FND_API.G_RET_STS_ERROR;
135: FND_MESSAGE.SET_NAME('QP','QP_PRICING_NOT_INSTALLED');
136: OE_MSG_PUB.Add;
137: RAISE FND_API.G_EXC_ERROR;
138:
139: END IF;
140:
201: THEN
202:
203: l_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MESSAGE.SET_NAME('QP','QP_BASIC_PRICING_UNAVAILABLE');
205: OE_MSG_PUB.Add;
206: RAISE FND_API.G_EXC_ERROR;
207:
208: END IF;
209:
322: x_return_status := FND_API.G_RET_STS_ERROR;
323:
324: -- Get message count and data
325:
326: OE_MSG_PUB.Count_And_Get
327: ( p_count => x_msg_count
328: , p_data => x_msg_data
329: );
330:
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340:
341: -- Get message count and data
342:
343: OE_MSG_PUB.Count_And_Get
344: ( p_count => x_msg_count
345: , p_data => x_msg_data
346: );
347:
353: WHEN OTHERS THEN
354:
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356:
357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
358: THEN
359: OE_MSG_PUB.Add_Exc_Msg
360: ( G_PKG_NAME
361: , 'Process_Modifiers'
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356:
357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
358: THEN
359: OE_MSG_PUB.Add_Exc_Msg
360: ( G_PKG_NAME
361: , 'Process_Modifiers'
362: );
363: END IF;
363: END IF;
364:
365: -- Get message count and data
366:
367: OE_MSG_PUB.Count_And_Get
368: ( p_count => x_msg_count
369: , p_data => x_msg_data
370: );
371:
538: x_return_status := FND_API.G_RET_STS_ERROR;
539:
540: -- Get message count and data
541:
542: OE_MSG_PUB.Count_And_Get
543: ( p_count => x_msg_count
544: , p_data => x_msg_data
545: );
546:
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
550:
551: -- Get message count and data
552:
553: OE_MSG_PUB.Count_And_Get
554: ( p_count => x_msg_count
555: , p_data => x_msg_data
556: );
557:
558: WHEN OTHERS THEN
559:
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561:
562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: OE_MSG_PUB.Add_Exc_Msg
565: ( G_PKG_NAME
566: , 'Lock_Modifiers'
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561:
562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: OE_MSG_PUB.Add_Exc_Msg
565: ( G_PKG_NAME
566: , 'Lock_Modifiers'
567: );
568: END IF;
568: END IF;
569:
570: -- Get message count and data
571:
572: OE_MSG_PUB.Count_And_Get
573: ( p_count => x_msg_count
574: , p_data => x_msg_data
575: );
576:
656: ELSIF p_list_header_id <> FND_API.G_MISS_NUM THEN
657:
658: l_list_header_id := p_list_header_id;
659:
660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
661: THEN
662:
663: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
661: THEN
662:
663: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
665: OE_MSG_PUB.Add;
666:
667: END IF;
668:
669: ELSE
674: ( p_list_header => p_list_header
675: );
676:
677: IF l_list_header_id = FND_API.G_MISS_NUM THEN
678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
679: THEN
680:
681: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
679: THEN
680:
681: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
683: OE_MSG_PUB.Add;
684:
685: END IF;
686: END IF;
687:
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735:
736: -- Get message count and data
737:
738: OE_MSG_PUB.Count_And_Get
739: ( p_count => x_msg_count
740: , p_data => x_msg_data
741: );
742:
748: x_return_status := FND_API.G_RET_STS_ERROR;
749:
750: -- Get message count and data
751:
752: OE_MSG_PUB.Count_And_Get
753: ( p_count => x_msg_count
754: , p_data => x_msg_data
755: );
756:
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
760:
761: -- Get message count and data
762:
763: OE_MSG_PUB.Count_And_Get
764: ( p_count => x_msg_count
765: , p_data => x_msg_data
766: );
767:
768: WHEN OTHERS THEN
769:
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
771:
772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
773: THEN
774: OE_MSG_PUB.Add_Exc_Msg
775: ( G_PKG_NAME
776: , 'Get_Modifiers'
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
771:
772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
773: THEN
774: OE_MSG_PUB.Add_Exc_Msg
775: ( G_PKG_NAME
776: , 'Get_Modifiers'
777: );
778: END IF;
778: END IF;
779:
780: -- Get message count and data
781:
782: OE_MSG_PUB.Count_And_Get
783: ( p_count => x_msg_count
784: , p_data => x_msg_data
785: );
786:
831: EXCEPTION
832:
833: WHEN OTHERS THEN
834:
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME
839: , 'Id_To_Value'
833: WHEN OTHERS THEN
834:
835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837: OE_MSG_PUB.Add_Exc_Msg
838: ( G_PKG_NAME
839: , 'Id_To_Value'
840: );
841: END IF;
962: EXCEPTION
963:
964: WHEN OTHERS THEN
965:
966: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
967: THEN
968: OE_MSG_PUB.Add_Exc_Msg
969: ( G_PKG_NAME
970: , 'Value_To_Id'
964: WHEN OTHERS THEN
965:
966: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
967: THEN
968: OE_MSG_PUB.Add_Exc_Msg
969: ( G_PKG_NAME
970: , 'Value_To_Id'
971: );
972: END IF;