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_PRICING_ATTR dependencies on OE_MSG_PUB

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

87: THEN
88:
89: l_return_status := FND_API.G_RET_STS_ERROR;
90:
91: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
92: THEN
93:
94: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
95: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Id');

Line 96: OE_MSG_PUB.Add;

92: THEN
93:
94: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
95: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Id');
96: OE_MSG_PUB.Add;
97:
98: END IF;
99:
100: END IF;

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

104: THEN
105:
106: l_return_status := FND_API.G_RET_STS_ERROR;
107:
108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
109: THEN
110:
111: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');

Line 113: OE_MSG_PUB.Add;

109: THEN
110:
111: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');
113: OE_MSG_PUB.Add;
114:
115: END IF;
116:
117: END IF;

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

120: THEN
121:
122: l_return_status := FND_API.G_RET_STS_ERROR;
123:
124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
125: THEN
126:
127: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Phase Id');

Line 129: OE_MSG_PUB.Add;

125: THEN
126:
127: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Phase Id');
129: OE_MSG_PUB.Add;
130:
131: END IF;
132:
133: END IF;

Line 157: OE_MSG_PUB.Add;

153: if count_attr > 1 THEN
154: l_return_status := FND_API.G_RET_STS_ERROR;
155:
156: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_PROD_ATTR');
157: OE_MSG_PUB.Add;
158: ELSE
159: NULL;
160: END IF;
161: END;

Line 180: OE_MSG_PUB.Add;

176: if count_attr > 1 AND p_PRICING_ATTR_rec.excluder_flag = 'N' THEN
177: l_return_status := FND_API.G_RET_STS_ERROR;
178:
179: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_PROD_VALUE');
180: OE_MSG_PUB.Add;
181: ELSE
182: NULL;
183: END IF;
184: END;

Line 205: OE_MSG_PUB.Add;

201: l_return_status := FND_API.G_RET_STS_ERROR;
202:
203: FND_MESSAGE.SET_NAME('QP','QP_RECUR_VAL_FROM_CHECK');
204:
205: OE_MSG_PUB.Add;
206:
207: END IF;
208:
209: /* Bug2069685 End */

Line 222: OE_MSG_PUB.Add;

218: l_return_status := FND_API.G_RET_STS_ERROR;
219:
220: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413
222: OE_MSG_PUB.Add;
223:
224: ELSIF ( p_PRICING_ATTR_rec.excluder_flag <> 'Y' AND
225: p_PRICING_ATTR_rec.excluder_flag <> 'N' )
226: THEN

Line 232: OE_MSG_PUB.Add;

228: oe_debug_pub.add('excluder flag invalid');
229: l_return_status := FND_API.G_RET_STS_ERROR;
230:
231: FND_MESSAGE.SET_NAME('QP','QP_EXCLD_FLAG_Y_OR_N');
232: OE_MSG_PUB.Add;
233:
234: END IF;
235: END IF; --list_line_type_code not 'PMR'
236:

Line 253: OE_MSG_PUB.Add;

249: l_return_status := FND_API.G_RET_STS_ERROR;
250:
251: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
253: OE_MSG_PUB.Add;
254:
255: END IF;
256:
257: IF ( p_PRICING_ATTR_rec.comparison_operator_code <> '=' AND

Line 264: OE_MSG_PUB.Add;

260:
261: l_return_status := FND_API.G_RET_STS_ERROR;
262:
263: FND_MESSAGE.SET_NAME('QP','QP_INVALID_COMP_OPERATOR');
264: OE_MSG_PUB.Add;
265:
266: END IF;
267:
268: -- Do not check for value to null. This change is to avoid an error being thrown

Line 279: OE_MSG_PUB.Add;

275:
276: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
278: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
279: OE_MSG_PUB.Add;
280:
281: -- Do not check for value to null. This change is to avoid an error being thrown
282: -- when a null value to is entered for the last price break (infinite value)
283: ELSIF p_PRICING_ATTR_rec.comparison_operator_code = 'BETWEEN'

Line 294: OE_MSG_PUB.Add;

290:
291: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
293: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
294: OE_MSG_PUB.Add;
295:
296: ELSIF p_PRICING_ATTR_rec.comparison_operator_code = 'BETWEEN'
297: AND p_PRICING_ATTR_rec.pricing_attr_value_from IS NULL
298: AND list_line.price_break_type_code = 'RECURRING' THEN

Line 304: OE_MSG_PUB.Add;

300: l_return_status := FND_API.G_RET_STS_ERROR;
301:
302: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
303: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); -- Fix For Bug-1974413
304: OE_MSG_PUB.Add;
305: END IF;
306:
307:
308:

Line 319: OE_MSG_PUB.Add;

315: l_return_status := FND_API.G_RET_STS_ERROR;
316:
317: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Volume Type');
319: OE_MSG_PUB.Add;
320: */
321:
322: ELSE
323:

Line 333: OE_MSG_PUB.Add;

329: l_return_status := FND_API.G_RET_STS_ERROR;
330:
331: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Volume Type');
333: OE_MSG_PUB.Add;
334:
335: ELSIF p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL
336: AND p_PRICING_ATTR_rec.pricing_attribute_context
337: = 'VOLUME'

Line 349: OE_MSG_PUB.Add;

345:
346: l_return_status := FND_API.G_RET_STS_ERROR;
347:
348: FND_MESSAGE.SET_NAME('QP','QP_PBH_NO_VALUE_FROM_TO');
349: OE_MSG_PUB.Add;
350:
351: ELSIF p_PRICING_ATTR_rec.pricing_attribute_context
352: <> 'VOLUME'
353: AND p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL

Line 365: OE_MSG_PUB.Add;

361:
362: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'||
364: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); -- Fix For Bug-1974413
365: OE_MSG_PUB.Add;
366:
367: ELSIF p_PRICING_ATTR_rec.pricing_attribute_context
368: <> 'VOLUME'
369: AND p_PRICING_ATTR_rec.pricing_attribute IS NOT NULL

Line 380: OE_MSG_PUB.Add;

376: l_return_status := FND_API.G_RET_STS_ERROR;
377:
378: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')||'/'|| QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')); --Fix For Bug-1974413
380: OE_MSG_PUB.Add;
381:
382:
383: END IF;
384:

Line 399: OE_MSG_PUB.Add;

395:
396: l_return_status := FND_API.G_RET_STS_ERROR;
397:
398: FND_MESSAGE.SET_NAME('QP','QP_PBH_PRICING_CONTEXT_VOLUME');
399: OE_MSG_PUB.Add;
400:
401:
402: END IF;
403:

Line 426: OE_MSG_PUB.Add;

422: l_return_status := FND_API.G_RET_STS_ERROR;
423:
424: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
425: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Volume Type');
426: OE_MSG_PUB.Add;
427:
428: END IF;
429:
430: END IF;

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

443: If (l_error_code <> 0) -- invalid value
444: Then
445: l_return_status := FND_API.G_RET_STS_ERROR;
446:
447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
448: THEN
449:
450: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From');

Line 452: OE_MSG_PUB.Add;

448: THEN
449:
450: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From');
452: OE_MSG_PUB.Add;
453: END IF;
454: RAISE FND_API.G_EXC_ERROR;
455: End If;
456:

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

468: If (l_error_code <> 0) -- invalid value
469: Then
470: l_return_status := FND_API.G_RET_STS_ERROR;
471:
472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
473: THEN
474:
475: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To');

Line 477: OE_MSG_PUB.Add;

473: THEN
474:
475: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To');
477: OE_MSG_PUB.Add;
478: END IF;
479: RAISE FND_API.G_EXC_ERROR;
480: End If;
481:

Line 500: OE_MSG_PUB.Add;

496:
497: l_return_status := FND_API.G_RET_STS_ERROR;
498:
499: FND_MESSAGE.SET_NAME('QP','QP_FROM_MUST_LESS_THAN_TO');
500: OE_MSG_PUB.Add;
501:
502: END IF;
503:
504: END IF;

Line 520: OE_MSG_PUB.Add;

516:
517: l_return_status := FND_API.G_RET_STS_ERROR;
518:
519: FND_MESSAGE.SET_NAME('QP','QP_GSA_PROD_ATTR_ITEM');
520: OE_MSG_PUB.Add;
521:
522: END IF;
523:
524: /* Exclude flag cannot be 'Y' for GSA Discounts */

Line 533: OE_MSG_PUB.Add;

529:
530: l_return_status := FND_API.G_RET_STS_ERROR;
531:
532: FND_MESSAGE.SET_NAME('QP','QP_NO_EXCLUDE_FOR_GSA');
533: OE_MSG_PUB.Add;
534:
535: END IF;
536:
537: /* Pricing Attributes are not allowed for GSA Discounts */

Line 549: OE_MSG_PUB.Add;

545:
546: l_return_status := FND_API.G_RET_STS_ERROR;
547:
548: FND_MESSAGE.SET_NAME('QP','QP_NO_PRICING_ATTR_FOR_GSA');
549: OE_MSG_PUB.Add;
550:
551: END IF;
552:
553: --- start bug2091362, bug2119287

Line 633: OE_MSG_PUB.Add;

629: l_return_status := FND_API.G_RET_STS_ERROR;
630:
631: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413
633: OE_MSG_PUB.Add;
634: END IF;
635: END IF;
636:
637:

Line 649: OE_MSG_PUB.Add;

645:
646: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||
648: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
649: OE_MSG_PUB.Add;
650:
651: ELSE
652:
653: /* Order level discounts cannot have Products */

Line 661: OE_MSG_PUB.Add;

657:
658: l_return_status := FND_API.G_RET_STS_ERROR;
659:
660: FND_MESSAGE.SET_NAME('QP','QP_ORDER_LEVEL_NO_PRODUCT');
661: OE_MSG_PUB.Add;
662:
663: END IF;
664:
665: QP_UTIL.validate_qp_flexfield(flexfield_name =>'QP_ATTR_DEFNS_PRICING'

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

679: If (l_context_flag = 'N' AND l_error_code = 7) -- invalid context
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_PROD_CONTEXT' );
687: OE_MSG_PUB.Add;

Line 687: OE_MSG_PUB.Add;

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_PROD_CONTEXT' );
687: OE_MSG_PUB.Add;
688: END IF;
689:
690: End If;
691:

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

692: If (l_attribute_flag = 'N' AND l_error_code = 8) -- invalid attribute
693: Then
694: l_return_status := FND_API.G_RET_STS_ERROR;
695:
696: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
697: THEN
698:
699: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
700: OE_MSG_PUB.Add;

Line 700: OE_MSG_PUB.Add;

696: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
697: THEN
698:
699: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
700: OE_MSG_PUB.Add;
701: END IF;
702:
703: End If;
704:

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

705: If (l_value_flag = 'N' AND l_error_code = 9) -- invalid value
706: Then
707: l_return_status := FND_API.G_RET_STS_ERROR;
708:
709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711:
712: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
713: OE_MSG_PUB.Add;

Line 713: OE_MSG_PUB.Add;

709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711:
712: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
713: OE_MSG_PUB.Add;
714: END IF;
715:
716: End If;
717:

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

743: IF NOT l_fna_valid THEN
744:
745: l_return_status := FND_API.G_RET_STS_ERROR;
746:
747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
748: THEN
749: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
750: FND_MESSAGE.set_token('CATID', p_pricing_attr_rec.product_attr_value);
751: FND_MESSAGE.set_token('PTE', l_pte_code);

Line 753: OE_MSG_PUB.Add;

749: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
750: FND_MESSAGE.set_token('CATID', p_pricing_attr_rec.product_attr_value);
751: FND_MESSAGE.set_token('PTE', l_pte_code);
752: FND_MESSAGE.set_token('SS', l_ss_code);
753: OE_MSG_PUB.Add;
754: END IF;
755:
756: END IF;
757:

Line 792: OE_MSG_PUB.Add;

788: WHEN NO_DATA_FOUND THEN
789: l_return_status := FND_API.G_RET_STS_ERROR;
790:
791: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
792: OE_MSG_PUB.Add;
793:
794: END;
795:
796: END IF;

Line 819: OE_MSG_PUB.Add;

815: l_uom_list_header_id)
816: THEN
817: l_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
819: OE_MSG_PUB.Add;
820: END IF;
821:
822: END IF;
823:

Line 841: OE_MSG_PUB.Add;

837: WHEN NO_DATA_FOUND THEN
838: l_return_status := FND_API.G_RET_STS_ERROR;
839:
840: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
841: OE_MSG_PUB.Add;
842:
843: END;
844:
845: END IF;

Line 870: OE_MSG_PUB.Add;

866: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')||'/'||
868: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')||'/'||
869: QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
870: OE_MSG_PUB.Add;
871:
872: END IF;
873:
874: END IF;

Line 886: OE_MSG_PUB.Add;

882:
883: l_return_status := FND_API.G_RET_STS_ERROR;
884:
885: FND_MESSAGE.SET_NAME('QP','QP_ITEM_MAND_FOR_IUE');
886: OE_MSG_PUB.Add;
887:
888: END IF;
889:
890: /* Item Number is mandatory for Get Products - cannot be category or ALL */

Line 906: OE_MSG_PUB.Add;

902:
903: l_return_status := FND_API.G_RET_STS_ERROR;
904:
905: FND_MESSAGE.SET_NAME('QP','QP_ITEM_MAND_FOR_GET');
906: OE_MSG_PUB.Add;
907:
908: END IF;
909:
910: /* Get record must be of the type Discount (DIS) for Other Item Discount and Promotional Goods */

Line 918: OE_MSG_PUB.Add;

914:
915: l_return_status := FND_API.G_RET_STS_ERROR;
916:
917: FND_MESSAGE.SET_NAME('QP','QP_GET_MUST_BE_DISCOUNT');
918: OE_MSG_PUB.Add;
919:
920: END IF;
921:
922: END IF;

Line 939: OE_MSG_PUB.Add;

935:
936: l_return_status := FND_API.G_RET_STS_ERROR;
937:
938: FND_MESSAGE.SET_NAME('QP','QP_ADD_MUST_BE_RELATED');
939: OE_MSG_PUB.Add;
940:
941: END IF;
942:
943: END IF;

Line 994: OE_MSG_PUB.Add;

990: l_return_status := FND_API.G_RET_STS_ERROR;
991:
992: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_PRECEDENCE')); -- Fix For Bug-1974413
994: OE_MSG_PUB.Add;
995: end if;
996:
997: END IF;
998:

Line 1009: OE_MSG_PUB.Add;

1005:
1006: l_return_status := FND_API.G_RET_STS_ERROR;
1007:
1008: FND_MESSAGE.SET_NAME('QP','QP_RECUR_OPER_MUST_BE_EQUL');
1009: OE_MSG_PUB.Add;
1010:
1011: END IF;
1012:
1013: Point or Range must have comparison operator as Between

Line 1023: OE_MSG_PUB.Add;

1019:
1020: l_return_status := FND_API.G_RET_STS_ERROR;
1021:
1022: FND_MESSAGE.SET_NAME('QP','QP_POINT_RANGE_OPER_BETWEEN');
1023: OE_MSG_PUB.Add;
1024:
1025: END IF; */
1026:
1027: oe_debug_pub.add('pric context = '||p_PRICING_ATTR_rec.pricing_attribute_context);

Line 1041: OE_MSG_PUB.Add;

1037: oe_debug_pub.add('I am herrrrr');
1038: l_return_status := FND_API.G_RET_STS_ERROR;
1039:
1040: FND_MESSAGE.SET_NAME('QP','QP_BETW_MAND_FOR_VOLUME');
1041: OE_MSG_PUB.Add;
1042:
1043: END IF;
1044:
1045: /* Select the Primary line type of the current record */

Line 1076: OE_MSG_PUB.Add;

1072: l_return_status := FND_API.G_RET_STS_ERROR;
1073:
1074: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1075: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Precedence');
1076: OE_MSG_PUB.Add;
1077:
1078: END IF; */
1079:
1080: /* If the Primary line is a OID or PRG, and if the product is entered, proration type code is mandatory */

Line 1091: OE_MSG_PUB.Add;

1087: l_return_status := FND_API.G_RET_STS_ERROR;
1088:
1089: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1091: OE_MSG_PUB.Add;
1092:
1093: END IF;
1094:
1095: /* If the Primary line is a Price Break Header and the Child lines are DIS or SUR, and if the product is entered, proration type code is mandatory */

Line 1107: OE_MSG_PUB.Add;

1103: l_return_status := FND_API.G_RET_STS_ERROR;
1104:
1105: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
1106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRORATION_TYPE_CODE')); -- Fix For Bug-1974413
1107: OE_MSG_PUB.Add;
1108:
1109: END IF;
1110:
1111: oe_debug_pub.add('end uom ');

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

1122: IF (l_error_code <> 0 ) -- invalid context
1123: THEN
1124: l_return_status := FND_API.G_RET_STS_ERROR;
1125:
1126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1127: THEN
1128:
1129: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_CONTEXT' );
1130: OE_MSG_PUB.Add;

Line 1130: OE_MSG_PUB.Add;

1126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1127: THEN
1128:
1129: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_CONTEXT' );
1130: OE_MSG_PUB.Add;
1131: END IF;
1132:
1133: END IF;
1134: END IF;

Line 1146: OE_MSG_PUB.Add;

1142:
1143: l_return_status := FND_API.G_RET_STS_ERROR;
1144:
1145: FND_MESSAGE.SET_NAME('QP','QP_BREAK_MAND_FOR_VOLUME');
1146: OE_MSG_PUB.Add;
1147:
1148: END IF;
1149:
1150: IF p_PRICING_ATTR_rec.pricing_attribute_context IS NOT NULL

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

1160: IF (l_error_code <> 0 ) -- invalid context
1161: THEN
1162: l_return_status := FND_API.G_RET_STS_ERROR;
1163:
1164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1165: THEN
1166:
1167: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_ATTR' );
1168: OE_MSG_PUB.Add;

Line 1168: OE_MSG_PUB.Add;

1164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1165: THEN
1166:
1167: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PRICING_ATTR' );
1168: OE_MSG_PUB.Add;
1169: END IF;
1170:
1171: END IF;
1172:

Line 1183: OE_MSG_PUB.Add;

1179:
1180: l_return_status := FND_API.G_RET_STS_ERROR;
1181:
1182: FND_MESSAGE.SET_NAME('QP','QP_BREAK_MAND_FOR_VOLUME');
1183: OE_MSG_PUB.Add;
1184:
1185: END IF;
1186:
1187: END IF; --If Pricing Attribute and Context are not null

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

1208: If (l_context_flag = 'N' AND l_error_code = 9) -- invalid value
1209: Then
1210: l_return_status := FND_API.G_RET_STS_ERROR;
1211:
1212: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1213: THEN
1214:
1215: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1216: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From');

Line 1217: OE_MSG_PUB.Add;

1213: THEN
1214:
1215: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1216: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From');
1217: OE_MSG_PUB.Add;
1218: END IF;
1219:
1220: End If;
1221: oe_debug_pub.add('pricing attr value from = '|| p_PRICING_ATTR_rec.pricing_attr_value_from);

Line 1237: OE_MSG_PUB.Add;

1233:
1234: l_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_NOT_WITH_RECUR');
1237: OE_MSG_PUB.Add;
1238:
1239: END IF;
1240: */
1241:

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

1255: If (l_error_code = 9) -- invalid value
1256: Then
1257: l_return_status := FND_API.G_RET_STS_ERROR;
1258:
1259: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1260: THEN
1261:
1262: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1263: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To');

Line 1264: OE_MSG_PUB.Add;

1260: THEN
1261:
1262: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1263: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To');
1264: OE_MSG_PUB.Add;
1265: END IF;
1266:
1267: End If;
1268:

Line 1295: OE_MSG_PUB.Add;

1291: THEN
1292: l_return_status := FND_API.G_RET_STS_ERROR;
1293:
1294: FND_MESSAGE.SET_NAME('QP','QP_1_PRICING_ATTR_FOR_BASIC');
1295: OE_MSG_PUB.Add;
1296:
1297: END IF;
1298:
1299: EXCEPTION

Line 1365: OE_MSG_PUB.Add;

1361: FND_MESSAGE.SET_TOKEN('CONTEXT',
1362: p_Pricing_Attr_rec.product_attribute_context);
1363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1364: p_Pricing_Attr_rec.product_attribute);
1365: OE_MSG_PUB.Add;
1366:
1367: END IF;
1368:
1369: IF l_sourcing_status <> 'Y' THEN

Line 1377: OE_MSG_PUB.Add;

1373: FND_MESSAGE.SET_TOKEN('CONTEXT',
1374: p_Pricing_Attr_rec.product_attribute_context);
1375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1376: p_Pricing_Attr_rec.product_attribute);
1377: OE_MSG_PUB.Add;
1378:
1379: END IF;
1380:
1381: END IF; --If sourcing_method = 'ATTRIBUTE MAPPING'

Line 1413: OE_MSG_PUB.Add;

1409: FND_MESSAGE.SET_TOKEN('CONTEXT',
1410: p_Pricing_Attr_rec.pricing_attribute_context);
1411: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1412: p_Pricing_Attr_rec.pricing_attribute);
1413: OE_MSG_PUB.Add;
1414:
1415: END IF;
1416:
1417: IF l_sourcing_status <> 'Y' THEN

Line 1424: OE_MSG_PUB.Add;

1420: FND_MESSAGE.SET_TOKEN('CONTEXT',
1421: p_Pricing_Attr_rec.pricing_attribute_context);
1422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1423: p_Pricing_Attr_rec.pricing_attribute);
1424: OE_MSG_PUB.Add;
1425:
1426: END IF;
1427:
1428: END IF; --If sourcing_method = 'ATTRIBUTE MAPPING'

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

1455:
1456: oe_debug_pub.add('EXP others');
1457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1458:
1459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1460: THEN
1461: OE_MSG_PUB.Add_Exc_Msg
1462: ( G_PKG_NAME
1463: , 'Entity'

Line 1461: OE_MSG_PUB.Add_Exc_Msg

1457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1458:
1459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1460: THEN
1461: OE_MSG_PUB.Add_Exc_Msg
1462: ( G_PKG_NAME
1463: , 'Entity'
1464: );
1465: END IF;

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

1893: WHEN OTHERS THEN
1894:
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1898: THEN
1899: OE_MSG_PUB.Add_Exc_Msg
1900: ( G_PKG_NAME
1901: , 'Attributes'

Line 1899: OE_MSG_PUB.Add_Exc_Msg

1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1898: THEN
1899: OE_MSG_PUB.Add_Exc_Msg
1900: ( G_PKG_NAME
1901: , 'Attributes'
1902: );
1903: END IF;

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

1946: WHEN OTHERS THEN
1947:
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949:
1950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1951: THEN
1952: OE_MSG_PUB.Add_Exc_Msg
1953: ( G_PKG_NAME
1954: , 'Entity_Delete'

Line 1952: OE_MSG_PUB.Add_Exc_Msg

1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949:
1950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1951: THEN
1952: OE_MSG_PUB.Add_Exc_Msg
1953: ( G_PKG_NAME
1954: , 'Entity_Delete'
1955: );
1956: END IF;