113: THEN -- Public API unavailable for Basic Pricing
114:
115: l_return_status := FND_API.G_RET_STS_ERROR;
116: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
117: OE_MSG_PUB.Add;
118: RAISE FND_API.G_EXC_ERROR;
119:
120: END IF;
121:
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
194: -- Get message count and data
195:
196: OE_MSG_PUB.Count_And_Get
197: ( p_count => x_msg_count
198: , p_data => x_msg_data
199: );
200:
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
210:
211: -- Get message count and data
212:
213: OE_MSG_PUB.Count_And_Get
214: ( p_count => x_msg_count
215: , p_data => x_msg_data
216: );
217:
224: WHEN OTHERS THEN
225:
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227:
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: OE_MSG_PUB.Add_Exc_Msg
231: ( G_PKG_NAME
232: , 'Process_Qualifier_Rules'
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227:
228: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: OE_MSG_PUB.Add_Exc_Msg
231: ( G_PKG_NAME
232: , 'Process_Qualifier_Rules'
233: );
234: END IF;
234: END IF;
235:
236: -- Get message count and data
237:
238: OE_MSG_PUB.Count_And_Get
239: ( p_count => x_msg_count
240: , p_data => x_msg_data
241: );
242:
365: x_return_status := FND_API.G_RET_STS_ERROR;
366:
367: -- Get message count and data
368:
369: OE_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count
371: , p_data => x_msg_data
372: );
373:
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377:
378: -- Get message count and data
379:
380: OE_MSG_PUB.Count_And_Get
381: ( p_count => x_msg_count
382: , p_data => x_msg_data
383: );
384:
385: WHEN OTHERS THEN
386:
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388:
389: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
390: THEN
391: OE_MSG_PUB.Add_Exc_Msg
392: ( G_PKG_NAME
393: , 'Lock_Qualifier_Rules'
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
388:
389: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
390: THEN
391: OE_MSG_PUB.Add_Exc_Msg
392: ( G_PKG_NAME
393: , 'Lock_Qualifier_Rules'
394: );
395: END IF;
395: END IF;
396:
397: -- Get message count and data
398:
399: OE_MSG_PUB.Count_And_Get
400: ( p_count => x_msg_count
401: , p_data => x_msg_data
402: );
403:
465: ELSIF p_qualifier_rule_id <> FND_API.G_MISS_NUM THEN
466:
467: l_qualifier_rule_id := p_qualifier_rule_id;
468:
469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
470: THEN
471:
472: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
470: THEN
471:
472: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
474: OE_MSG_PUB.Add;
475:
476: END IF;
477:
478: ELSE
487: --dbms_output.put_line('after convertid'||l_qualifier_rule_id);
488: --dbms_output.put_line('qualifier rule id is miss num');
489:
490: IF l_qualifier_rule_id = FND_API.G_MISS_NUM THEN
491: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
492: THEN
493:
494: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
495: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
492: THEN
493:
494: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
495: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
496: OE_MSG_PUB.Add;
497:
498: END IF;
499: END IF;
500:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: -- Get message count and data
548:
549: OE_MSG_PUB.Count_And_Get
550: ( p_count => x_msg_count
551: , p_data => x_msg_data
552: );
553:
560: x_return_status := FND_API.G_RET_STS_ERROR;
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:
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573:
574: -- Get message count and data
575:
576: OE_MSG_PUB.Count_And_Get
577: ( p_count => x_msg_count
578: , p_data => x_msg_data
579: );
580:
582: --dbms_output.put_line('calling get qualifiers other');
583:
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585:
586: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: OE_MSG_PUB.Add_Exc_Msg
589: ( G_PKG_NAME
590: , 'Get_Qualifier_Rules'
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585:
586: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: OE_MSG_PUB.Add_Exc_Msg
589: ( G_PKG_NAME
590: , 'Get_Qualifier_Rules'
591: );
592: END IF;
592: END IF;
593:
594: -- Get message count and data
595:
596: OE_MSG_PUB.Count_And_Get
597: ( p_count => x_msg_count
598: , p_data => x_msg_data
599: );
600:
646: ELSIF p_qualifier_rule_id <> FND_API.G_MISS_NUM THEN
647:
648: l_qualifier_rule_id := p_qualifier_rule_id;
649:
650: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
651: THEN
652:
653: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
654: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
651: THEN
652:
653: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
654: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
655: OE_MSG_PUB.Add;
656:
657: END IF;
658:
659: ELSE
668: --dbms_output.put_line('after convertid'||l_qualifier_rule_id);
669: --dbms_output.put_line('qualifier rule id is miss num');
670:
671: IF l_qualifier_rule_id = FND_API.G_MISS_NUM THEN
672: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
673: THEN
674:
675: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
676: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
673: THEN
674:
675: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');
676: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
677: OE_MSG_PUB.Add;
678:
679: END IF;
680: END IF;
681:
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: -- Get message count and data
735:
736: OE_MSG_PUB.Count_And_Get
737: ( p_count => x_msg_count
738: , p_data => x_msg_data
739: );
740:
747: x_return_status := FND_API.G_RET_STS_ERROR;
748:
749: -- Get message count and data
750:
751: OE_MSG_PUB.Count_And_Get
752: ( p_count => x_msg_count
753: , p_data => x_msg_data
754: );
755:
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:
770: --dbms_output.put_line('calling get qualifiers other');
771:
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
773:
774: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: OE_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , 'Copy_Qualifier_Rule'
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
773:
774: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: OE_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , 'Copy_Qualifier_Rule'
779: );
780: END IF;
780: END IF;
781:
782: -- Get message count and data
783:
784: OE_MSG_PUB.Count_And_Get
785: ( p_count => x_msg_count
786: , p_data => x_msg_data
787: );
788:
821: EXCEPTION
822:
823: WHEN OTHERS THEN
824:
825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
826: THEN
827: OE_MSG_PUB.Add_Exc_Msg
828: ( G_PKG_NAME
829: , 'Id_To_Value'
823: WHEN OTHERS THEN
824:
825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
826: THEN
827: OE_MSG_PUB.Add_Exc_Msg
828: ( G_PKG_NAME
829: , 'Id_To_Value'
830: );
831: END IF;
895: EXCEPTION
896:
897: WHEN OTHERS THEN
898:
899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: OE_MSG_PUB.Add_Exc_Msg
902: ( G_PKG_NAME
903: , 'Value_To_Id'
897: WHEN OTHERS THEN
898:
899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: OE_MSG_PUB.Add_Exc_Msg
902: ( G_PKG_NAME
903: , 'Value_To_Id'
904: );
905: END IF;