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 65: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

61: RETURN FALSE;
62:
63: WHEN OTHERS THEN
64:
65: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
66: THEN
67: OE_MSG_PUB.Add_Exc_Msg
68: ( G_PKG_NAME
69: , 'Check_Duplicate_Qualifier'

Line 67: OE_MSG_PUB.Add_Exc_Msg

63: WHEN OTHERS THEN
64:
65: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
66: THEN
67: OE_MSG_PUB.Add_Exc_Msg
68: ( G_PKG_NAME
69: , 'Check_Duplicate_Qualifier'
70: );
71: END IF;

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

225: THEN
226:
227: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 234: OE_MSG_PUB.Add;

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

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

255: THEN
256:
257: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 264: OE_MSG_PUB.Add;

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

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

287: THEN
288:
289: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 296: OE_MSG_PUB.Add;

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

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

315: THEN
316:
317: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 324: OE_MSG_PUB.Add;

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

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

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

Line 351: OE_MSG_PUB.Add;

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

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

367: THEN
368:
369: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 376: OE_MSG_PUB.Add;

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

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

393: THEN
394:
395: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 402: OE_MSG_PUB.Add;

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

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

412: THEN
413:
414: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 421: OE_MSG_PUB.Add;

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

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

446: THEN
447:
448: l_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 466: OE_MSG_PUB.Add;

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

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

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

Line 505: OE_MSG_PUB.Add;

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

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

527: p_QUALIFIERS_rec.end_date_active)
528: THEN
529: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 536: OE_MSG_PUB.Add;

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

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

556: p_QUALIFIERS_rec.qualifier_attr_value IS NULL)
557: THEN
558: l_return_status := FND_API.G_RET_STS_ERROR;
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')||'/'||

Line 566: OE_MSG_PUB.Add;

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

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

577: IF l_error_code <> 0 THEN
578:
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;

Line 585: OE_MSG_PUB.Add;

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

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

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

Line 614: OE_MSG_PUB.Add;

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

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

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

Line 629: OE_MSG_PUB.Add;

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

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

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

Line 674: OE_MSG_PUB.Add;

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

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

698: Then
699:
700: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 708: OE_MSG_PUB.Add;

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

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

729: THEN
730:
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:

Line 736: OE_MSG_PUB.Add;

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

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

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

Line 767: OE_MSG_PUB.Add;

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

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

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

Line 788: OE_MSG_PUB.Add;

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

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

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

Line 812: --OE_MSG_PUB.Add;

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

Line 813: OE_MSG_PUB.Add;

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

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

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

Line 853: OE_MSG_PUB.Add;

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

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

859:
860: oe_debug_pub.add('customer GSA = '||l_customer_gsa_indicator);
861: l_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 867: OE_MSG_PUB.Add;

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

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

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

Line 902: OE_MSG_PUB.Add;

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

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

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

Line 923: OE_MSG_PUB.Add;

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

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

939: IF l_error_code <> 0 THEN
940:
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;

Line 947: OE_MSG_PUB.Add;

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

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

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

Line 976: OE_MSG_PUB.Add;

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

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

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

Line 1002: OE_MSG_PUB.Add;

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

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

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

Line 1027: OE_MSG_PUB.Add;

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

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

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

Line 1052: OE_MSG_PUB.Add;

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

Line 1200: OE_MSG_PUB.Add;

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;
1203:
1204: IF l_sourcing_status <> 'Y' THEN

Line 1215: OE_MSG_PUB.Add;

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

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

1233: ,p_Qualifiers_rec.qualifier_attribute
1234: );
1235: IF l_segment_level = 'ORDER' THEN
1236: l_return_status := FND_API.G_RET_STS_ERROR;
1237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1238: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1239: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1240: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1241: x_attribute_code => x_attribute_code,

Line 1247: OE_MSG_PUB.Add;

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

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

1274: OR
1275: (l_modifier_level_code = 'ORDER' and l_segment_level = 'LINE')) then
1276:
1277: l_return_status := FND_API.G_RET_STS_ERROR;
1278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1279: qp_util. Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
1280: p_Context_Name => p_Qualifiers_rec.qualifier_context,
1281: p_attribute => p_Qualifiers_rec.qualifier_attribute,
1282: x_attribute_code => x_attribute_code,

Line 1289: OE_MSG_PUB.Add;

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

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

1314: WHEN OTHERS THEN
1315:
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1319: THEN
1320: OE_MSG_PUB.Add_Exc_Msg
1321: ( G_PKG_NAME
1322: , 'Entity'

Line 1320: OE_MSG_PUB.Add_Exc_Msg

1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1319: THEN
1320: OE_MSG_PUB.Add_Exc_Msg
1321: ( G_PKG_NAME
1322: , 'Entity'
1323: );
1324: END IF;

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

1921: WHEN OTHERS THEN
1922:
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924:
1925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1926: THEN
1927: OE_MSG_PUB.Add_Exc_Msg
1928: ( G_PKG_NAME
1929: , 'Attributes'

Line 1927: OE_MSG_PUB.Add_Exc_Msg

1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924:
1925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1926: THEN
1927: OE_MSG_PUB.Add_Exc_Msg
1928: ( G_PKG_NAME
1929: , 'Attributes'
1930: );
1931: END IF;

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

1970: WHEN OTHERS THEN
1971:
1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1973:
1974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1975: THEN
1976: OE_MSG_PUB.Add_Exc_Msg
1977: ( G_PKG_NAME
1978: , 'Entity_Delete'

Line 1976: OE_MSG_PUB.Add_Exc_Msg

1972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1973:
1974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1975: THEN
1976: OE_MSG_PUB.Add_Exc_Msg
1977: ( G_PKG_NAME
1978: , 'Entity_Delete'
1979: );
1980: END IF;