228:
229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
230: THEN
231:
232: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
234: OE_MSG_PUB.Add;
235:
236: END IF;
229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
230: THEN
231:
232: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
234: OE_MSG_PUB.Add;
235:
236: END IF;
237:
258:
259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
260: THEN
261:
262: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
263: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_GROUPING_NO')); -- Fix For Bug-1974413
264: OE_MSG_PUB.Add;
265:
266: END IF;
259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
260: THEN
261:
262: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
263: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_GROUPING_NO')); -- Fix For Bug-1974413
264: OE_MSG_PUB.Add;
265:
266: END IF;
267:
290:
291: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
292: THEN
293:
294: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix FOr Bug-1974413
296: OE_MSG_PUB.Add;
297:
298: END IF;
291: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
292: THEN
293:
294: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix FOr Bug-1974413
296: OE_MSG_PUB.Add;
297:
298: END IF;
299:
318:
319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
320: THEN
321:
322: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Attribute');
324: OE_MSG_PUB.Add;
325:
326: END IF;
319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
320: THEN
321:
322: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Attribute');
324: OE_MSG_PUB.Add;
325:
326: END IF;
327:
345:
346: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
347: THEN
348:
349: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
351: OE_MSG_PUB.Add;
352:
353: END IF;
346: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
347: THEN
348:
349: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
351: OE_MSG_PUB.Add;
352:
353: END IF;
354:
370:
371: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
372: THEN
373:
374: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
376: OE_MSG_PUB.Add;
377:
378: END IF;
371: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
372: THEN
373:
374: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
376: OE_MSG_PUB.Add;
377:
378: END IF;
379:
396:
397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
398: THEN
399:
400: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
402: OE_MSG_PUB.Add;
403:
404: END IF;
397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
398: THEN
399:
400: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
401: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
402: OE_MSG_PUB.Add;
403:
404: END IF;
405:
415:
416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
417: THEN
418:
419: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- FIx For Bug-1974413
421: OE_MSG_PUB.Add;
422:
423: END IF;
416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
417: THEN
418:
419: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- FIx For Bug-1974413
421: OE_MSG_PUB.Add;
422:
423: END IF;
424:
449:
450: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
451: THEN
452:
453: FND_MESSAGE.SET_NAME('QP','QP_DUPL_QUAL_EXISTS');
454:
455: FND_MESSAGE.SET_TOKEN('CONTEXT',
456: QP_UTIL.Get_Context('QP_ATTR_DEFNS_QUALIFIER',p_QUALIFIERS_rec.qualifier_context));
457:
451: THEN
452:
453: FND_MESSAGE.SET_NAME('QP','QP_DUPL_QUAL_EXISTS');
454:
455: FND_MESSAGE.SET_TOKEN('CONTEXT',
456: QP_UTIL.Get_Context('QP_ATTR_DEFNS_QUALIFIER',p_QUALIFIERS_rec.qualifier_context));
457:
458: QP_UTIL.Get_Attribute_Code('QP_ATTR_DEFNS_QUALIFIER',
459: p_QUALIFIERS_rec.qualifier_context,
459: p_QUALIFIERS_rec.qualifier_context,
460: p_QUALIFIERS_rec.qualifier_attribute,
461: x_attribute_code,
462: x_segment_name);
463: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',x_attribute_code);
464: FND_MESSAGE.SET_TOKEN('QUAL_GRPNG_NO',p_QUALIFIERS_rec.qualifier_grouping_no);
465:
466: OE_MSG_PUB.Add;
467:
460: p_QUALIFIERS_rec.qualifier_attribute,
461: x_attribute_code,
462: x_segment_name);
463: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',x_attribute_code);
464: FND_MESSAGE.SET_TOKEN('QUAL_GRPNG_NO',p_QUALIFIERS_rec.qualifier_grouping_no);
465:
466: OE_MSG_PUB.Add;
467:
468: END IF;
499: l_return_status := FND_API.G_RET_STS_ERROR;
500:
501: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
502: THEN
503: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Attribute');
505: OE_MSG_PUB.Add;
506: END IF;
507: END IF;
500:
501: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
502: THEN
503: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Attribute');
505: OE_MSG_PUB.Add;
506: END IF;
507: END IF;
508:
530:
531: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
532: THEN
533:
534: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
535: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Start Date active');
536: OE_MSG_PUB.Add;
537:
538: END IF;
531: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
532: THEN
533:
534: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
535: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Start Date active');
536: OE_MSG_PUB.Add;
537:
538: END IF;
539:
559:
560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
561: THEN
562:
563: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE_TO')||'/'||
565: QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix For Bug-1974413
566: OE_MSG_PUB.Add;
567:
560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
561: THEN
562:
563: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE_TO')||'/'||
565: QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_ATTR_VALUE')); -- Fix For Bug-1974413
566: OE_MSG_PUB.Add;
567:
568: END IF;
579: l_return_status := FND_API.G_RET_STS_ERROR;
580:
581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
582: THEN
583: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
584: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
585: OE_MSG_PUB.Add;
586: END IF;
587:
580:
581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
582: THEN
583: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
584: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
585: OE_MSG_PUB.Add;
586: END IF;
587:
588: END IF;
608: l_return_status := FND_API.G_RET_STS_ERROR;
609:
610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
611: Then
612: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Start Date Active');
614: OE_MSG_PUB.Add;
615: END IF;
616: END IF;
609:
610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
611: Then
612: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Start Date Active');
614: OE_MSG_PUB.Add;
615: END IF;
616: END IF;
617:
623: l_return_status := FND_API.G_RET_STS_ERROR;
624:
625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
626: Then
627: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'End Date Active');
629: OE_MSG_PUB.Add;
630: END IF;
631: END IF;
624:
625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
626: Then
627: FND_MESSAGE.SET_NAME('QP','QP_DATE_WITHIN_GRPNO_REQ_SAME');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'End Date Active');
629: OE_MSG_PUB.Add;
630: END IF;
631: END IF;
632:
667:
668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
669: THEN
670:
671: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
672: -- FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
673: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
674: OE_MSG_PUB.Add;
675: END IF;
668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
669: THEN
670:
671: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
672: -- FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
673: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
674: OE_MSG_PUB.Add;
675: END IF;
676:
669: THEN
670:
671: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
672: -- FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_ATTRIBUTE');
673: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Id');
674: OE_MSG_PUB.Add;
675: END IF;
676:
677: End If;*/
701:
702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
703: THEN
704:
705: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
706: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
707: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
708: OE_MSG_PUB.Add;
709: END IF;
702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
703: THEN
704:
705: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
706: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
707: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
708: OE_MSG_PUB.Add;
709: END IF;
710:
703: THEN
704:
705: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
706: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
707: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
708: OE_MSG_PUB.Add;
709: END IF;
710:
711: End If;
731: l_return_status := FND_API.G_RET_STS_ERROR;
732:
733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
734: THEN
735: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
736: OE_MSG_PUB.Add;
737:
738: END IF;
739:
760:
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763:
764: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
765: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
767: OE_MSG_PUB.Add;
768: END IF;
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763:
764: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
765: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
767: OE_MSG_PUB.Add;
768: END IF;
769:
762: THEN
763:
764: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
765: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_CONTEXT')); -- Fix For Bug-1974413
767: OE_MSG_PUB.Add;
768: END IF;
769:
770: End If;
782:
783: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
784: THEN
785:
786: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
787: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
788: OE_MSG_PUB.Add;
789: END IF;
790:
783: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
784: THEN
785:
786: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
787: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
788: OE_MSG_PUB.Add;
789: END IF;
790:
791: End If;
806:
807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
808: THEN
809:
810: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
812: --OE_MSG_PUB.Add;
813: OE_MSG_PUB.Add;
814: END IF;
807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
808: THEN
809:
810: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
812: --OE_MSG_PUB.Add;
813: OE_MSG_PUB.Add;
814: END IF;
815: End If;
848:
849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
850: THEN
851:
852: FND_MESSAGE.SET_NAME('QP','QP_INVALID_GSA_CUSTOMER');
853: OE_MSG_PUB.Add;
854:
855: END IF;
856:
862:
863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
864: THEN
865:
866: FND_MESSAGE.SET_NAME('QP','QP_INVALID_GSA_CUSTOMER');
867: OE_MSG_PUB.Add;
868:
869: END IF;
870:
895:
896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
897: THEN
898:
899: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
900: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_PRECEDENCE')); -- Fix For Bug-1974413
902: OE_MSG_PUB.Add;
903: END IF;
896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
897: THEN
898:
899: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
900: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_PRECEDENCE')); -- Fix For Bug-1974413
902: OE_MSG_PUB.Add;
903: END IF;
904:
897: THEN
898:
899: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
900: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('QUALIFIER_PRECEDENCE')); -- Fix For Bug-1974413
902: OE_MSG_PUB.Add;
903: END IF;
904:
905:
916: l_return_status := FND_API.G_RET_STS_ERROR;
917:
918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
919: THEN
920: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
921: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
922: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Datatype ');
923: OE_MSG_PUB.Add;
924: END IF;
917:
918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
919: THEN
920: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
921: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
922: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Datatype ');
923: OE_MSG_PUB.Add;
924: END IF;
925:
918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
919: THEN
920: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
921: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
922: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier Datatype ');
923: OE_MSG_PUB.Add;
924: END IF;
925:
926: End If;
941: l_return_status := FND_API.G_RET_STS_ERROR;
942:
943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
944: THEN
945: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
947: OE_MSG_PUB.Add;
948: END IF;
949:
942:
943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
944: THEN
945: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
947: OE_MSG_PUB.Add;
948: END IF;
949:
950: END IF;
969: l_return_status := FND_API.G_RET_STS_ERROR;
970:
971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
972: THEN
973: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
974: -- FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier qualifier rule id ');
976: OE_MSG_PUB.Add;
977: END IF;
970:
971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
972: THEN
973: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
974: -- FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier qualifier rule id ');
976: OE_MSG_PUB.Add;
977: END IF;
978: End If;
971: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
972: THEN
973: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
974: -- FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Qualifier qualifier rule id ');
976: OE_MSG_PUB.Add;
977: END IF;
978: End If;
979: END IF;*/
995: l_return_status := FND_API.G_RET_STS_ERROR;
996:
997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1000: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created from rule id ');
1002: OE_MSG_PUB.Add;
1003: END IF;
996:
997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1000: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created from rule id ');
1002: OE_MSG_PUB.Add;
1003: END IF;
1004: End If;
997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1000: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created from rule id ');
1002: OE_MSG_PUB.Add;
1003: END IF;
1004: End If;
1005: END IF;*/
1020: l_return_status := FND_API.G_RET_STS_ERROR;
1021:
1022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1025: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header id ');
1027: OE_MSG_PUB.Add;
1028: END IF;
1021:
1022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1025: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header id ');
1027: OE_MSG_PUB.Add;
1028: END IF;
1029: End If;
1022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1025: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header id ');
1027: OE_MSG_PUB.Add;
1028: END IF;
1029: End If;
1030: END IF; */
1045: l_return_status := FND_API.G_RET_STS_ERROR;
1046:
1047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1048: THEN
1049: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1050: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line id ');
1052: OE_MSG_PUB.Add;
1053: END IF;
1046:
1047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1048: THEN
1049: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1050: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line id ');
1052: OE_MSG_PUB.Add;
1053: END IF;
1054: End If;
1047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1048: THEN
1049: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1050: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line id ');
1052: OE_MSG_PUB.Add;
1053: END IF;
1054: End If;
1055: END IF; */
1191: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
1192:
1193: IF l_sourcing_enabled <> 'Y' THEN
1194:
1195: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1196: FND_MESSAGE.SET_TOKEN('CONTEXT',
1197: p_Qualifiers_rec.qualifier_context);
1198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1199: p_Qualifiers_rec.qualifier_attribute);
1192:
1193: IF l_sourcing_enabled <> 'Y' THEN
1194:
1195: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1196: FND_MESSAGE.SET_TOKEN('CONTEXT',
1197: p_Qualifiers_rec.qualifier_context);
1198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1199: p_Qualifiers_rec.qualifier_attribute);
1200: OE_MSG_PUB.Add;
1194:
1195: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1196: FND_MESSAGE.SET_TOKEN('CONTEXT',
1197: p_Qualifiers_rec.qualifier_context);
1198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1199: p_Qualifiers_rec.qualifier_attribute);
1200: OE_MSG_PUB.Add;
1201:
1202: END IF;
1206: IF NOT (
1207: p_qualifiers_rec.qualifier_context= 'MODLIST' AND
1208: p_qualifiers_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10')
1209: THEN
1210: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1211: FND_MESSAGE.SET_TOKEN('CONTEXT',
1212: p_Qualifiers_rec.qualifier_context);
1213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1214: p_Qualifiers_rec.qualifier_attribute);
1207: p_qualifiers_rec.qualifier_context= 'MODLIST' AND
1208: p_qualifiers_rec.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10')
1209: THEN
1210: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1211: FND_MESSAGE.SET_TOKEN('CONTEXT',
1212: p_Qualifiers_rec.qualifier_context);
1213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1214: p_Qualifiers_rec.qualifier_attribute);
1215: OE_MSG_PUB.Add;
1209: THEN
1210: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1211: FND_MESSAGE.SET_TOKEN('CONTEXT',
1212: p_Qualifiers_rec.qualifier_context);
1213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1214: p_Qualifiers_rec.qualifier_attribute);
1215: OE_MSG_PUB.Add;
1216: END IF;
1217:
1240: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1241: x_attribute_code => x_attribute_code,
1242: x_segment_name => x_segment_name);
1243: -- The level of attribute (?) ? is not compatible for Price Lists
1244: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED_FOR_PL');
1245: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1246: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1247: OE_MSG_PUB.Add;
1248: END IF;
1241: x_attribute_code => x_attribute_code,
1242: x_segment_name => x_segment_name);
1243: -- The level of attribute (?) ? is not compatible for Price Lists
1244: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED_FOR_PL');
1245: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1246: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1247: OE_MSG_PUB.Add;
1248: END IF;
1249: END IF;
1242: x_segment_name => x_segment_name);
1243: -- The level of attribute (?) ? is not compatible for Price Lists
1244: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED_FOR_PL');
1245: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1246: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1247: OE_MSG_PUB.Add;
1248: END IF;
1249: END IF;
1250: END IF;
1281: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1282: x_attribute_code => x_attribute_code,
1283: x_segment_name => x_segment_name);
1284: -- The level of attribute (?) ? is not compatible with modifier level ?.
1285: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1287: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1288: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1289: OE_MSG_PUB.Add;
1282: x_attribute_code => x_attribute_code,
1283: x_segment_name => x_segment_name);
1284: -- The level of attribute (?) ? is not compatible with modifier level ?.
1285: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1287: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1288: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1289: OE_MSG_PUB.Add;
1290: END IF; -- check_msg_level
1283: x_segment_name => x_segment_name);
1284: -- The level of attribute (?) ? is not compatible with modifier level ?.
1285: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1287: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1288: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1289: OE_MSG_PUB.Add;
1290: END IF; -- check_msg_level
1291:
1284: -- The level of attribute (?) ? is not compatible with modifier level ?.
1285: FND_MESSAGE.SET_NAME('QP','QP_SEGMENT_NOT_ALLOWED');
1286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', x_attribute_code);
1287: FND_MESSAGE.SET_TOKEN('SEGMENT_LEVEL', l_segment_level);
1288: FND_MESSAGE.SET_TOKEN('MODIFIER_LEVEL', l_modifier_level_code);
1289: OE_MSG_PUB.Add;
1290: END IF; -- check_msg_level
1291:
1292: end if; -- compare modifier_level and segment_level