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');
96: OE_MSG_PUB.Add;
97:
98: END IF;
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');
96: OE_MSG_PUB.Add;
97:
98: END IF;
99:
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');
113: OE_MSG_PUB.Add;
114:
115: END IF;
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');
113: OE_MSG_PUB.Add;
114:
115: END IF;
116:
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');
129: OE_MSG_PUB.Add;
130:
131: END IF;
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');
129: OE_MSG_PUB.Add;
130:
131: END IF;
132:
152: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
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;
175: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
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;
199: p_PRICING_ATTR_rec.pricing_attr_value_from <= 0) then
200:
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;
216:
217: oe_debug_pub.add('excluder flag null');
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
217: oe_debug_pub.add('excluder flag null');
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' )
227:
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'
247: THEN
248:
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;
248:
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:
259: THEN
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:
272: THEN
273:
274: l_return_status := FND_API.G_RET_STS_ERROR;
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:
273:
274: l_return_status := FND_API.G_RET_STS_ERROR;
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
287: AND list_line.price_break_type_code <> 'RECURRING' THEN
288:
289: l_return_status := FND_API.G_RET_STS_ERROR;
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:
288:
289: l_return_status := FND_API.G_RET_STS_ERROR;
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'
298: AND list_line.price_break_type_code = 'RECURRING' THEN
299:
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:
299:
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:
313: THEN
314:
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:
314:
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
327: IF p_PRICING_ATTR_rec.pricing_attribute IS NULL THEN
328:
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
328:
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
344: --when value from/to entered for PBH record volume context
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'
358: --when value from/to NOT entered for PBH rec context<>VOLUME
359:
360: l_return_status := FND_API.G_RET_STS_ERROR;
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:
359:
360: l_return_status := FND_API.G_RET_STS_ERROR;
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
374: --when value from/to NOT entered for PBH rec context<>VOLUME
375:
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:
375:
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;
394: THEN
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;
420: THEN
421:
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;
421:
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:
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');
452: OE_MSG_PUB.Add;
453: END IF;
454: RAISE FND_API.G_EXC_ERROR;
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');
452: OE_MSG_PUB.Add;
453: END IF;
454: RAISE FND_API.G_EXC_ERROR;
455: End If;
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');
477: OE_MSG_PUB.Add;
478: END IF;
479: RAISE FND_API.G_EXC_ERROR;
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');
477: OE_MSG_PUB.Add;
478: END IF;
479: RAISE FND_API.G_EXC_ERROR;
480: End If;
495: THEN
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:
515: THEN
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:
528: THEN
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:
544: THEN
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:
627: 'PRICING_ATTRIBUTE14','PRICING_ATTRIBUTE15')) OR -- Bug#2828308
628: p_PRICING_ATTR_rec.PRICING_ATTRIBUTE = 'PRICING_ATTRIBUTE10') THEN
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;
628: p_PRICING_ATTR_rec.PRICING_ATTRIBUTE = 'PRICING_ATTRIBUTE10') THEN
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:
642: THEN
643:
644: l_return_status := FND_API.G_RET_STS_ERROR;
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:
643:
644: l_return_status := FND_API.G_RET_STS_ERROR;
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
656: THEN
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:
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;
688: END IF;
689:
690: End If;
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;
701: END IF;
702:
703: End If;
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;
714: END IF;
715:
716: End If;
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);
752: FND_MESSAGE.set_token('SS', l_ss_code);
753: OE_MSG_PUB.Add;
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);
752: FND_MESSAGE.set_token('SS', l_ss_code);
753: OE_MSG_PUB.Add;
754: END IF;
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);
752: FND_MESSAGE.set_token('SS', l_ss_code);
753: OE_MSG_PUB.Add;
754: END IF;
755:
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);
752: FND_MESSAGE.set_token('SS', l_ss_code);
753: OE_MSG_PUB.Add;
754: END IF;
755:
756: END IF;
787: EXCEPTION
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:
814: to_number(p_PRICING_ATTR_rec.product_attr_value),
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;
836: EXCEPTION
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:
862: THEN
863:
864: l_return_status := FND_API.G_RET_STS_ERROR;
865:
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;
863:
864: l_return_status := FND_API.G_RET_STS_ERROR;
865:
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:
881: THEN
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:
901: THEN
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:
913: THEN
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:
934: THEN
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:
988: --precedence is mandatory for pricing attribute records to exclude product
989: if p_PRICING_ATTR_rec.excluder_flag = 'N' then
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:
989: if p_PRICING_ATTR_rec.excluder_flag = 'N' then
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;
1004: THEN
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:
1018: THEN
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:
1036:
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:
1070:
1071: oe_debug_pub.add('prece 33 ');
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; */
1071: oe_debug_pub.add('prece 33 ');
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:
1085: THEN
1086:
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;
1086:
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:
1101: THEN
1102:
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;
1102:
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:
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;
1131: END IF;
1132:
1133: END IF;
1141: THEN
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:
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;
1169: END IF;
1170:
1171: END IF;
1178: THEN
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:
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');
1217: OE_MSG_PUB.Add;
1218: END IF;
1219:
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');
1217: OE_MSG_PUB.Add;
1218: END IF;
1219:
1220: End If;
1232: THEN
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: */
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');
1264: OE_MSG_PUB.Add;
1265: END IF;
1266:
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');
1264: OE_MSG_PUB.Add;
1265: END IF;
1266:
1267: End If;
1290: IF nvl(l_no_pricing_attr,0) = 1
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:
1356: oe_debug_pub.add('Here 4444');
1357: IF l_sourcing_enabled <> 'Y' THEN
1358:
1359: oe_debug_pub.add('Here 5555');
1360: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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);
1357: IF l_sourcing_enabled <> 'Y' THEN
1358:
1359: oe_debug_pub.add('Here 5555');
1360: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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;
1359: oe_debug_pub.add('Here 5555');
1360: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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
1370:
1371: oe_debug_pub.add('Here 6666');
1372: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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);
1369: IF l_sourcing_status <> 'Y' THEN
1370:
1371: oe_debug_pub.add('Here 6666');
1372: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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;
1371: oe_debug_pub.add('Here 6666');
1372: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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;
1404: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
1405:
1406: IF l_sourcing_enabled <> 'Y' THEN
1407:
1408: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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);
1405:
1406: IF l_sourcing_enabled <> 'Y' THEN
1407:
1408: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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;
1407:
1408: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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;
1415: END IF;
1416:
1417: IF l_sourcing_status <> 'Y' THEN
1418:
1419: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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);
1416:
1417: IF l_sourcing_status <> 'Y' THEN
1418:
1419: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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;
1418:
1419: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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;