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:
314: x_return_status := FND_API.G_RET_STS_ERROR;
315:
316: -- Get message count and data
317:
318: OE_MSG_PUB.Count_And_Get
319: ( p_count => x_msg_count
320: , p_data => x_msg_data
321: );
322:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332:
333: -- Get message count and data
334:
335: OE_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count
337: , p_data => x_msg_data
338: );
339:
345: WHEN OTHERS THEN
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: OE_MSG_PUB.Add_Exc_Msg
352: ( G_PKG_NAME
353: , 'Process_Modifiers'
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: OE_MSG_PUB.Add_Exc_Msg
352: ( G_PKG_NAME
353: , 'Process_Modifiers'
354: );
355: END IF;
355: END IF;
356:
357: -- Get message count and data
358:
359: OE_MSG_PUB.Count_And_Get
360: ( p_count => x_msg_count
361: , p_data => x_msg_data
362: );
363:
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: -- Get message count and data
533:
534: OE_MSG_PUB.Count_And_Get
535: ( p_count => x_msg_count
536: , p_data => x_msg_data
537: );
538:
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542:
543: -- Get message count and data
544:
545: OE_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count
547: , p_data => x_msg_data
548: );
549:
550: WHEN OTHERS THEN
551:
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553:
554: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
555: THEN
556: OE_MSG_PUB.Add_Exc_Msg
557: ( G_PKG_NAME
558: , 'Lock_Modifiers'
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553:
554: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
555: THEN
556: OE_MSG_PUB.Add_Exc_Msg
557: ( G_PKG_NAME
558: , 'Lock_Modifiers'
559: );
560: END IF;
560: END IF;
561:
562: -- Get message count and data
563:
564: OE_MSG_PUB.Count_And_Get
565: ( p_count => x_msg_count
566: , p_data => x_msg_data
567: );
568:
648: ELSIF p_list_header_id <> FND_API.G_MISS_NUM THEN
649:
650: l_list_header_id := p_list_header_id;
651:
652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
653: THEN
654:
655: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
653: THEN
654:
655: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
657: OE_MSG_PUB.Add;
658:
659: END IF;
660:
661: ELSE
666: ( p_list_header => p_list_header
667: );
668:
669: IF l_list_header_id = FND_API.G_MISS_NUM THEN
670: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
671: THEN
672:
673: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
671: THEN
672:
673: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
674: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
675: OE_MSG_PUB.Add;
676:
677: END IF;
678: END IF;
679:
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727:
728: -- Get message count and data
729:
730: OE_MSG_PUB.Count_And_Get
731: ( p_count => x_msg_count
732: , p_data => x_msg_data
733: );
734:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741:
742: -- Get message count and data
743:
744: OE_MSG_PUB.Count_And_Get
745: ( p_count => x_msg_count
746: , p_data => x_msg_data
747: );
748:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752:
753: -- Get message count and data
754:
755: OE_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count
757: , p_data => x_msg_data
758: );
759:
760: WHEN OTHERS THEN
761:
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
763:
764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: OE_MSG_PUB.Add_Exc_Msg
767: ( G_PKG_NAME
768: , 'Get_Modifiers'
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
763:
764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: OE_MSG_PUB.Add_Exc_Msg
767: ( G_PKG_NAME
768: , 'Get_Modifiers'
769: );
770: END IF;
770: END IF;
771:
772: -- Get message count and data
773:
774: OE_MSG_PUB.Count_And_Get
775: ( p_count => x_msg_count
776: , p_data => x_msg_data
777: );
778:
823: EXCEPTION
824:
825: WHEN OTHERS THEN
826:
827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: OE_MSG_PUB.Add_Exc_Msg
830: ( G_PKG_NAME
831: , 'Id_To_Value'
825: WHEN OTHERS THEN
826:
827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: OE_MSG_PUB.Add_Exc_Msg
830: ( G_PKG_NAME
831: , 'Id_To_Value'
832: );
833: END IF;
954: EXCEPTION
955:
956: WHEN OTHERS THEN
957:
958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
959: THEN
960: OE_MSG_PUB.Add_Exc_Msg
961: ( G_PKG_NAME
962: , 'Value_To_Id'
956: WHEN OTHERS THEN
957:
958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
959: THEN
960: OE_MSG_PUB.Add_Exc_Msg
961: ( G_PKG_NAME
962: , 'Value_To_Id'
963: );
964: END IF;