eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_VALIDATE_QUALIFIERS dependencies on OE_MSG_PUB

Line 160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

156: THEN
157:
158: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 165: OE_MSG_PUB.Add;

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:
169: END IF;

Line 190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

186: THEN
187:
188: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 195: OE_MSG_PUB.Add;

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:
199: END IF;

Line 222: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

218: THEN
219:
220: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 227: OE_MSG_PUB.Add;

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:
231: END IF;

Line 250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

246: THEN
247:
248: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 255: OE_MSG_PUB.Add;

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:
259: END IF;

Line 277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

273: THEN
274:
275: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 282: OE_MSG_PUB.Add;

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:
286: END IF;

Line 302: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

298: THEN
299:
300: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 307: OE_MSG_PUB.Add;

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:
311: END IF;

Line 328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

324: THEN
325:
326: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 333: OE_MSG_PUB.Add;

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:
337: END IF;

Line 347: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

343: THEN
344:
345: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 352: OE_MSG_PUB.Add;

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:
356: END IF;

Line 401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

397: -- Qualifier Attr 'Order Amount' under the 'Volume' Qualfier context
398: THEN
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;

Line 405: OE_MSG_PUB.Add;

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:
409: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

427: p_QUALIFIERS_rec.end_date_active)
428: THEN
429: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 436: OE_MSG_PUB.Add;

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:
440: END IF;

Line 460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

456: p_QUALIFIERS_rec.qualifier_attr_value IS NULL)
457: THEN
458: l_return_status := FND_API.G_RET_STS_ERROR;
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')||'/'||

Line 466: OE_MSG_PUB.Add;

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;
469:
470: END IF;

Line 481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

477: IF l_error_code <> 0 THEN
478:
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;

Line 485: OE_MSG_PUB.Add;

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;
489:

Line 510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

506: p_QUALIFIERS_rec.qualifier_rule_id,
507: p_QUALIFIERS_rec.qualifier_id) THEN
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;

Line 514: OE_MSG_PUB.Add;

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:
518:

Line 525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

521: p_QUALIFIERS_rec.qualifier_rule_id,
522: p_QUALIFIERS_rec.qualifier_id) THEN
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;

Line 529: OE_MSG_PUB.Add;

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:
533:

Line 568: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

564: Else
565: l_return_status := FND_API.G_RET_STS_ERROR;
566: --dbms_output.put_line('entity validation for duplicaet id '||l_return_status);
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');

Line 574: OE_MSG_PUB.Add;

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;*/
578:

Line 602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

598: Then
599:
600: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 608: OE_MSG_PUB.Add;

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;
612:

Line 633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

629: THEN
630:
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:

Line 636: OE_MSG_PUB.Add;

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:
640: END IF;

Line 661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

657: If (l_context_error = 'N' AND l_error_code = 7) -- invalid context
658: Then
659: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 667: OE_MSG_PUB.Add;

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;
671:

Line 683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

679: If l_attribute_error = 'N' AND l_error_code = 8 -- invalid Attribute
680: Then
681: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 688: OE_MSG_PUB.Add;

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;
692:

Line 707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

703: If l_value_error = 'N' AND l_error_code = 9 -- invalid value
704: Then
705: l_return_status := FND_API.G_RET_STS_ERROR;
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 ');

Line 712: --OE_MSG_PUB.Add;

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;
716: END IF;

Line 713: OE_MSG_PUB.Add;

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;
716: END IF;
717:

Line 749: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

745:
746: oe_debug_pub.add('customer GSA not found');
747: l_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 753: OE_MSG_PUB.Add;

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:
757: ELSIF nvl(l_customer_gsa_indicator,'N') <> 'Y'

Line 763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

759:
760: oe_debug_pub.add('customer GSA = '||l_customer_gsa_indicator);
761: l_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 767: OE_MSG_PUB.Add;

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:
771: END IF;

Line 796: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

792: /*If p_QUALIFIERS_rec.qualifier_precedence <> l_precedence --- invalid precedence
793: Then
794: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 802: OE_MSG_PUB.Add;

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:
806: End If;*/

Line 818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

814: If p_QUALIFIERS_rec.qualifier_datatype <> l_datatype --- invalid qualifier datatype
815: Then
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 ');

Line 823: OE_MSG_PUB.Add;

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;
827:

Line 843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

839: IF l_error_code <> 0 THEN
840:
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;

Line 847: OE_MSG_PUB.Add;

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;
851: --dbms_output.put_line('for cano of value from ,'||l_return_status);

Line 871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

867: If SQL%NOTFOUND
868: Then
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 ');

Line 876: OE_MSG_PUB.Add;

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;*/
880:

Line 897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

893: If SQL%NOTFOUND
894: Then
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 ');

Line 902: OE_MSG_PUB.Add;

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;*/
906:

Line 922: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

918: If SQL%NOTFOUND
919: Then
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 ');

Line 927: OE_MSG_PUB.Add;

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; */
931:

Line 947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

943: If SQL%NOTFOUND
944: Then
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 ');

Line 952: OE_MSG_PUB.Add;

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; */
956:

Line 1100: OE_MSG_PUB.Add;

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;
1103:
1104: IF l_sourcing_status <> 'Y' THEN

Line 1115: OE_MSG_PUB.Add;

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:
1118: END IF;
1119:

Line 1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1133: ,p_Qualifiers_rec.qualifier_attribute
1134: );
1135: IF l_segment_level = 'ORDER' THEN
1136: l_return_status := FND_API.G_RET_STS_ERROR;
1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1138: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1139: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1140: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1141: x_attribute_code => x_attribute_code,

Line 1147: OE_MSG_PUB.Add;

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;
1151: END IF;

Line 1178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1174: OR
1175: (l_modifier_level_code = 'ORDER' and l_segment_level = 'LINE')) then
1176:
1177: l_return_status := FND_API.G_RET_STS_ERROR;
1178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1179: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1180: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1181: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1182: x_attribute_code => x_attribute_code,

Line 1189: OE_MSG_PUB.Add;

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
1193:

Line 1218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1214: WHEN OTHERS THEN
1215:
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: OE_MSG_PUB.Add_Exc_Msg
1221: ( G_PKG_NAME
1222: , 'Entity'

Line 1220: OE_MSG_PUB.Add_Exc_Msg

1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: OE_MSG_PUB.Add_Exc_Msg
1221: ( G_PKG_NAME
1222: , 'Entity'
1223: );
1224: END IF;

Line 1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1821: WHEN OTHERS THEN
1822:
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1826: THEN
1827: OE_MSG_PUB.Add_Exc_Msg
1828: ( G_PKG_NAME
1829: , 'Attributes'

Line 1827: OE_MSG_PUB.Add_Exc_Msg

1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1824:
1825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1826: THEN
1827: OE_MSG_PUB.Add_Exc_Msg
1828: ( G_PKG_NAME
1829: , 'Attributes'
1830: );
1831: END IF;

Line 1874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1870: WHEN OTHERS THEN
1871:
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1873:
1874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: OE_MSG_PUB.Add_Exc_Msg
1877: ( G_PKG_NAME
1878: , 'Entity_Delete'

Line 1876: OE_MSG_PUB.Add_Exc_Msg

1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1873:
1874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: OE_MSG_PUB.Add_Exc_Msg
1877: ( G_PKG_NAME
1878: , 'Entity_Delete'
1879: );
1880: END IF;