159:
160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
161: THEN
162:
163: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
165: OE_MSG_PUB.Add;
166:
167: END IF;
160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
161: THEN
162:
163: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
165: OE_MSG_PUB.Add;
166:
167: END IF;
168:
189:
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
191: THEN
192:
193: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
194: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_GROUPING_NO')); -- Fix For Bug-1974413
195: OE_MSG_PUB.Add;
196:
197: END IF;
190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
191: THEN
192:
193: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
194: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_GROUPING_NO')); -- Fix For Bug-1974413
195: OE_MSG_PUB.Add;
196:
197: END IF;
198:
221:
222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
223: THEN
224:
225: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
226: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix FOr Bug-1974413
227: OE_MSG_PUB.Add;
228:
229: END IF;
222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
223: THEN
224:
225: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
226: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix FOr Bug-1974413
227: OE_MSG_PUB.Add;
228:
229: END IF;
230:
249:
250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
251: THEN
252:
253: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Attribute');
255: OE_MSG_PUB.Add;
256:
257: END IF;
250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
251: THEN
252:
253: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Attribute');
255: OE_MSG_PUB.Add;
256:
257: END IF;
258:
276:
277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
278: THEN
279:
280: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
282: OE_MSG_PUB.Add;
283:
284: END IF;
277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
278: THEN
279:
280: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
282: OE_MSG_PUB.Add;
283:
284: END IF;
285:
301:
302: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
303: THEN
304:
305: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
307: OE_MSG_PUB.Add;
308:
309: END IF;
302: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
303: THEN
304:
305: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
307: OE_MSG_PUB.Add;
308:
309: END IF;
310:
327:
328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
329: THEN
330:
331: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
333: OE_MSG_PUB.Add;
334:
335: END IF;
328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
329: THEN
330:
331: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
333: OE_MSG_PUB.Add;
334:
335: END IF;
336:
346:
347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
348: THEN
349:
350: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
351: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- FIx For Bug-1974413
352: OE_MSG_PUB.Add;
353:
354: END IF;
347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
348: THEN
349:
350: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
351: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- FIx For Bug-1974413
352: OE_MSG_PUB.Add;
353:
354: END IF;
355:
399: l_return_status := FND_API.G_RET_STS_ERROR;
400:
401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
402: THEN
403: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Attribute');
405: OE_MSG_PUB.Add;
406: END IF;
407: END IF;
400:
401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
402: THEN
403: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Attribute');
405: OE_MSG_PUB.Add;
406: END IF;
407: END IF;
408:
430:
431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
432: THEN
433:
434: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
435: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Start Date active');
436: OE_MSG_PUB.Add;
437:
438: END IF;
431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
432: THEN
433:
434: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
435: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Start Date active');
436: OE_MSG_PUB.Add;
437:
438: END IF;
439:
459:
460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
461: THEN
462:
463: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE_TO')||'/'||
465: QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix For Bug-1974413
466: OE_MSG_PUB.Add;
467:
460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
461: THEN
462:
463: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE_TO')||'/'||
465: QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix For Bug-1974413
466: OE_MSG_PUB.Add;
467:
468: END IF;
479: l_return_status := FND_API.G_RET_STS_ERROR;
480:
481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
482: THEN
483: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
484: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
485: OE_MSG_PUB.Add;
486: END IF;
487:
480:
481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
482: THEN
483: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
484: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
485: OE_MSG_PUB.Add;
486: END IF;
487:
488: END IF;
508: l_return_status := FND_API.G_RET_STS_ERROR;
509:
510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
511: Then
512: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
513: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Start Date Active');
514: OE_MSG_PUB.Add;
515: END IF;
516: END IF;
509:
510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
511: Then
512: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
513: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Start Date Active');
514: OE_MSG_PUB.Add;
515: END IF;
516: END IF;
517:
523: l_return_status := FND_API.G_RET_STS_ERROR;
524:
525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
526: Then
527: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'End Date Active');
529: OE_MSG_PUB.Add;
530: END IF;
531: END IF;
524:
525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
526: Then
527: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'End Date Active');
529: OE_MSG_PUB.Add;
530: END IF;
531: END IF;
532:
567:
568: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
569: THEN
570:
571: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
572: -- FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
574: OE_MSG_PUB.Add;
575: END IF;
568: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
569: THEN
570:
571: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
572: -- FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
574: OE_MSG_PUB.Add;
575: END IF;
576:
569: THEN
570:
571: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
572: -- FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
574: OE_MSG_PUB.Add;
575: END IF;
576:
577: End If;*/
601:
602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
603: THEN
604:
605: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
606: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
608: OE_MSG_PUB.Add;
609: END IF;
602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
603: THEN
604:
605: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
606: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
608: OE_MSG_PUB.Add;
609: END IF;
610:
603: THEN
604:
605: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
606: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
608: OE_MSG_PUB.Add;
609: END IF;
610:
611: End If;
631: l_return_status := FND_API.G_RET_STS_ERROR;
632:
633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
634: THEN
635: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
636: OE_MSG_PUB.Add;
637:
638: END IF;
639:
660:
661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
662: THEN
663:
664: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
665: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
667: OE_MSG_PUB.Add;
668: END IF;
661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
662: THEN
663:
664: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
665: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
667: OE_MSG_PUB.Add;
668: END IF;
669:
662: THEN
663:
664: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
665: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
667: OE_MSG_PUB.Add;
668: END IF;
669:
670: End If;
682:
683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
684: THEN
685:
686: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
688: OE_MSG_PUB.Add;
689: END IF;
690:
683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
684: THEN
685:
686: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
688: OE_MSG_PUB.Add;
689: END IF;
690:
691: End If;
706:
707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
708: THEN
709:
710: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
712: --OE_MSG_PUB.Add;
713: OE_MSG_PUB.Add;
714: END IF;
707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
708: THEN
709:
710: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
712: --OE_MSG_PUB.Add;
713: OE_MSG_PUB.Add;
714: END IF;
715: End If;
748:
749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
750: THEN
751:
752: FND_MESSAGE.SET_NAME('QP','QP_INVALID_GSA_CUSTOMER');
753: OE_MSG_PUB.Add;
754:
755: END IF;
756:
762:
763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
764: THEN
765:
766: FND_MESSAGE.SET_NAME('QP','QP_INVALID_GSA_CUSTOMER');
767: OE_MSG_PUB.Add;
768:
769: END IF;
770:
795:
796: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
797: THEN
798:
799: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
800: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_PRECEDENCE')); -- Fix For Bug-1974413
802: OE_MSG_PUB.Add;
803: END IF;
796: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
797: THEN
798:
799: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
800: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_PRECEDENCE')); -- Fix For Bug-1974413
802: OE_MSG_PUB.Add;
803: END IF;
804:
797: THEN
798:
799: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
800: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
801: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_PRECEDENCE')); -- Fix For Bug-1974413
802: OE_MSG_PUB.Add;
803: END IF;
804:
805:
816: l_return_status := FND_API.G_RET_STS_ERROR;
817:
818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
819: THEN
820: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
821: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Datatype ');
823: OE_MSG_PUB.Add;
824: END IF;
817:
818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
819: THEN
820: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
821: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Datatype ');
823: OE_MSG_PUB.Add;
824: END IF;
825:
818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
819: THEN
820: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
821: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Datatype ');
823: OE_MSG_PUB.Add;
824: END IF;
825:
826: End If;
841: l_return_status := FND_API.G_RET_STS_ERROR;
842:
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
844: THEN
845: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
847: OE_MSG_PUB.Add;
848: END IF;
849:
842:
843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
844: THEN
845: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
847: OE_MSG_PUB.Add;
848: END IF;
849:
850: END IF;
869: l_return_status := FND_API.G_RET_STS_ERROR;
870:
871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
872: THEN
873: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
874: -- FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier qualifier rule id ');
876: OE_MSG_PUB.Add;
877: END IF;
870:
871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
872: THEN
873: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
874: -- FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier qualifier rule id ');
876: OE_MSG_PUB.Add;
877: END IF;
878: End If;
871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
872: THEN
873: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
874: -- FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier qualifier rule id ');
876: OE_MSG_PUB.Add;
877: END IF;
878: End If;
879: END IF;*/
895: l_return_status := FND_API.G_RET_STS_ERROR;
896:
897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
898: THEN
899: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
900: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created from rule id ');
902: OE_MSG_PUB.Add;
903: END IF;
896:
897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
898: THEN
899: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
900: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created from rule id ');
902: OE_MSG_PUB.Add;
903: END IF;
904: End If;
897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
898: THEN
899: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
900: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created from rule id ');
902: OE_MSG_PUB.Add;
903: END IF;
904: End If;
905: END IF;*/
920: l_return_status := FND_API.G_RET_STS_ERROR;
921:
922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
925: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
926: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header id ');
927: OE_MSG_PUB.Add;
928: END IF;
921:
922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
925: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
926: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header id ');
927: OE_MSG_PUB.Add;
928: END IF;
929: End If;
922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
925: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
926: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header id ');
927: OE_MSG_PUB.Add;
928: END IF;
929: End If;
930: END IF; */
945: l_return_status := FND_API.G_RET_STS_ERROR;
946:
947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
948: THEN
949: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
950: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line id ');
952: OE_MSG_PUB.Add;
953: END IF;
946:
947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
948: THEN
949: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
950: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line id ');
952: OE_MSG_PUB.Add;
953: END IF;
954: End If;
947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
948: THEN
949: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
950: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line id ');
952: OE_MSG_PUB.Add;
953: END IF;
954: End If;
955: END IF; */
1091: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
1092:
1093: IF l_sourcing_enabled <> 'Y' THEN
1094:
1095: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1096: FND_MESSAGE.SET_TOKEN('CONTEXT',
1097: p_Qualifiers_rec.qualifier_context);
1098: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1099: p_Qualifiers_rec.qualifier_attribute);
1092:
1093: IF l_sourcing_enabled <> 'Y' THEN
1094:
1095: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1096: FND_MESSAGE.SET_TOKEN('CONTEXT',
1097: p_Qualifiers_rec.qualifier_context);
1098: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1099: p_Qualifiers_rec.qualifier_attribute);
1100: OE_MSG_PUB.Add;
1094:
1095: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1096: FND_MESSAGE.SET_TOKEN('CONTEXT',
1097: p_Qualifiers_rec.qualifier_context);
1098: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1099: p_Qualifiers_rec.qualifier_attribute);
1100: OE_MSG_PUB.Add;
1101:
1102: END IF;
1106: IF NOT (
1107: p_qualifiers_rec.qualifier_context= 'MODLIST' AND
1108: p_qualifiers_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10')
1109: THEN
1110: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1111: FND_MESSAGE.SET_TOKEN('CONTEXT',
1112: p_Qualifiers_rec.qualifier_context);
1113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1114: p_Qualifiers_rec.qualifier_attribute);
1107: p_qualifiers_rec.qualifier_context= 'MODLIST' AND
1108: p_qualifiers_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10')
1109: THEN
1110: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1111: FND_MESSAGE.SET_TOKEN('CONTEXT',
1112: p_Qualifiers_rec.qualifier_context);
1113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1114: p_Qualifiers_rec.qualifier_attribute);
1115: OE_MSG_PUB.Add;
1109: THEN
1110: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1111: FND_MESSAGE.SET_TOKEN('CONTEXT',
1112: p_Qualifiers_rec.qualifier_context);
1113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1114: p_Qualifiers_rec.qualifier_attribute);
1115: OE_MSG_PUB.Add;
1116: END IF;
1117:
1140: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1141: x_attribute_code => x_attribute_code,
1142: x_segment_name => x_segment_name);
1143: -- The level of attribute (?) ? is not compatible for Price Lists
1144: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED_FOR_PL');
1145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1146: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1147: OE_MSG_PUB.Add;
1148: END IF;
1141: x_attribute_code => x_attribute_code,
1142: x_segment_name => x_segment_name);
1143: -- The level of attribute (?) ? is not compatible for Price Lists
1144: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED_FOR_PL');
1145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1146: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1147: OE_MSG_PUB.Add;
1148: END IF;
1149: END IF;
1142: x_segment_name => x_segment_name);
1143: -- The level of attribute (?) ? is not compatible for Price Lists
1144: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED_FOR_PL');
1145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1146: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1147: OE_MSG_PUB.Add;
1148: END IF;
1149: END IF;
1150: END IF;
1181: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1182: x_attribute_code => x_attribute_code,
1183: x_segment_name => x_segment_name);
1184: -- The level of attribute (?) ? is not compatible with modifier level ?.
1185: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1187: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1188: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1189: OE_MSG_PUB.Add;
1182: x_attribute_code => x_attribute_code,
1183: x_segment_name => x_segment_name);
1184: -- The level of attribute (?) ? is not compatible with modifier level ?.
1185: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1187: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1188: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1189: OE_MSG_PUB.Add;
1190: END IF; -- check_msg_level
1183: x_segment_name => x_segment_name);
1184: -- The level of attribute (?) ? is not compatible with modifier level ?.
1185: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1187: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1188: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1189: OE_MSG_PUB.Add;
1190: END IF; -- check_msg_level
1191:
1184: -- The level of attribute (?) ? is not compatible with modifier level ?.
1185: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1187: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1188: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1189: OE_MSG_PUB.Add;
1190: END IF; -- check_msg_level
1191:
1192: end if; -- compare modifier_level and segment_level