67:
68: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
69: THEN
70:
71: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Id');
73: oe_msg_pub.Add;
74:
75: END IF;
68: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
69: THEN
70:
71: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Id');
73: oe_msg_pub.Add;
74:
75: END IF;
76:
85: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE_CONTEXT,'X')
86: THEN
87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute_context');
91: OE_MSG_PUB.Add;
92:
93: END IF;
86: THEN
87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute_context');
91: OE_MSG_PUB.Add;
92:
93: END IF;
94:
96: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE,'X')
97: THEN
98: l_return_status := FND_API.G_RET_STS_ERROR;
99:
100: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute');
102: OE_MSG_PUB.Add;
103:
104: END IF;
97: THEN
98: l_return_status := FND_API.G_RET_STS_ERROR;
99:
100: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute');
102: OE_MSG_PUB.Add;
103:
104: END IF;
105:
107: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTR_VALUE,9999999)
108: THEN
109: l_return_status := FND_API.G_RET_STS_ERROR;
110:
111: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attr_value');
113: OE_MSG_PUB.Add;
114:
115: END IF;
108: THEN
109: l_return_status := FND_API.G_RET_STS_ERROR;
110:
111: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attr_value');
113: OE_MSG_PUB.Add;
114:
115: END IF;
116:
123: l_return_status := FND_API.G_RET_STS_ERROR;
124:
125: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
126: THEN
127: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
129: oe_msg_pub.Add;
130: END IF;
131: END IF;
124:
125: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
126: THEN
127: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
129: oe_msg_pub.Add;
130: END IF;
131: END IF;
132:
135: l_return_status := FND_API.G_RET_STS_ERROR;
136:
137: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
138: THEN
139: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');
141: oe_msg_pub.Add;
142: END IF;
143: END IF;
136:
137: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
138: THEN
139: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');
141: oe_msg_pub.Add;
142: END IF;
143: END IF;
144: */
147: l_return_status := FND_API.G_RET_STS_ERROR;
148:
149: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
150: THEN
151: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
152: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Phase Id');
153: oe_msg_pub.Add;
154: END IF;
155: END IF;
148:
149: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
150: THEN
151: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
152: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Phase Id');
153: oe_msg_pub.Add;
154: END IF;
155: END IF;
156:
159: l_return_status := FND_API.G_RET_STS_ERROR;
160:
161: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
162: THEN
163: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413
165: oe_msg_pub.Add;
166: END IF;
167: ELSE
160:
161: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
162: THEN
163: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413
165: oe_msg_pub.Add;
166: END IF;
167: ELSE
168:
170: THEN
171: l_return_status := FND_API.G_RET_STS_ERROR;
172: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
173: THEN
174: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Excluder Flag');
176: oe_msg_pub.Add;
177: END IF;
178: END IF;
171: l_return_status := FND_API.G_RET_STS_ERROR;
172: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
173: THEN
174: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Excluder Flag');
176: oe_msg_pub.Add;
177: END IF;
178: END IF;
179: END IF;
183: l_return_status := FND_API.G_RET_STS_ERROR;
184:
185: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
186: THEN
187: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
189: oe_msg_pub.Add;
190: END IF;
191: END IF;
184:
185: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
186: THEN
187: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
189: oe_msg_pub.Add;
190: END IF;
191: END IF;
192:
195: l_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
198: THEN
199: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
200: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')); -- Fix For Bug-1974413
201: oe_msg_pub.Add;
202: END IF;
203: END IF;
196:
197: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
198: THEN
199: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
200: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')); -- Fix For Bug-1974413
201: oe_msg_pub.Add;
202: END IF;
203: END IF;
204:
207: l_return_status := FND_API.G_RET_STS_ERROR;
208:
209: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
210: THEN
211: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
212: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
213: oe_msg_pub.Add;
214: END IF;
215: END IF;
208:
209: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
210: THEN
211: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
212: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
213: oe_msg_pub.Add;
214: END IF;
215: END IF;
216:
219: l_return_status := FND_API.G_RET_STS_ERROR;
220:
221: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
222: THEN
223: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Product Attribute Datatype');
225: oe_msg_pub.Add;
226: END IF;
227: END IF;
220:
221: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
222: THEN
223: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Product Attribute Datatype');
225: oe_msg_pub.Add;
226: END IF;
227: END IF;
228:
231: l_return_status := FND_API.G_RET_STS_ERROR;
232:
233: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
234: THEN
235: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413
237: oe_msg_pub.Add;
238: END IF;
239: END IF;
232:
233: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
234: THEN
235: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413
237: oe_msg_pub.Add;
238: END IF;
239: END IF;
240:
243: l_return_status := FND_API.G_RET_STS_ERROR;
244:
245: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
246: THEN
247: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ATTRIBUTE_GROUPING_NO')); -- Fix For Bug-1974413
249: oe_msg_pub.Add;
250: END IF;
251: END IF;
244:
245: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
246: THEN
247: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ATTRIBUTE_GROUPING_NO')); -- Fix For Bug-1974413
249: oe_msg_pub.Add;
250: END IF;
251: END IF;
252:
291: l_return_status := FND_API.G_RET_STS_ERROR;
292:
293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
296: FND_MESSAGE.set_token('CATID', p_PRICING_ATTR_REC.product_attr_value);
297: FND_MESSAGE.set_token('PTE', l_pte_code);
298: FND_MESSAGE.set_token('SS', l_ss_code);
299: OE_MSG_PUB.Add;
292:
293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
296: FND_MESSAGE.set_token('CATID', p_PRICING_ATTR_REC.product_attr_value);
297: FND_MESSAGE.set_token('PTE', l_pte_code);
298: FND_MESSAGE.set_token('SS', l_ss_code);
299: OE_MSG_PUB.Add;
300: END IF;
293: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
296: FND_MESSAGE.set_token('CATID', p_PRICING_ATTR_REC.product_attr_value);
297: FND_MESSAGE.set_token('PTE', l_pte_code);
298: FND_MESSAGE.set_token('SS', l_ss_code);
299: OE_MSG_PUB.Add;
300: END IF;
301:
294: THEN
295: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
296: FND_MESSAGE.set_token('CATID', p_PRICING_ATTR_REC.product_attr_value);
297: FND_MESSAGE.set_token('PTE', l_pte_code);
298: FND_MESSAGE.set_token('SS', l_ss_code);
299: OE_MSG_PUB.Add;
300: END IF;
301:
302: RAISE FND_API.G_EXC_ERROR;
426: OE_Debug_Pub.add ( 'smbalara :: PA match hence duplicate lines');
427: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
428: THEN
429: l_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MESSAGE.SET_NAME('QP','QP_DUP_PRICING_ATTR');
431: OE_MSG_PUB.Add;
432: end if;
433: END If;
434: ELSE
435: --End check for Pricing attributes 8359896
436: OE_Debug_Pub.add ( 'smbalara :: Only one primary uom allowed');
437: l_return_status := FND_API.G_RET_STS_ERROR;
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
440: OE_MSG_PUB.Add;
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: END IF;--end if of Check_Dup_Pra
484: WHEN NO_DATA_FOUND THEN
485:
486: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
487: THEN
488: FND_MESSAGE.SET_NAME('QP','QP_ITEM_NOT_VALID');
489: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_PRICING_ATTR_rec.product_attr_value);
490: OE_MSG_PUB.Add;
491: END IF;
492: RAISE FND_API.G_EXC_ERROR;
485:
486: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
487: THEN
488: FND_MESSAGE.SET_NAME('QP','QP_ITEM_NOT_VALID');
489: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_PRICING_ATTR_rec.product_attr_value);
490: OE_MSG_PUB.Add;
491: END IF;
492: RAISE FND_API.G_EXC_ERROR;
493:
513: exception
514: WHEN NO_DATA_FOUND THEN
515: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
516: THEN
517: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
518: OE_MSG_PUB.Add;
519: END IF;
520: RAISE FND_API.G_EXC_ERROR;
521:
531: IF NOT QP_VALIDATE.Product_Uom(p_pricing_attr_rec.product_uom_code,
532: to_number(p_PRICING_ATTR_rec.product_attr_value),
533: p_PRICING_ATTR_rec.list_header_id) THEN
534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
535: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
536: OE_MSG_PUB.Add;
537: END IF;
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
616: and rownum = 1;
617: exception
618: WHEN NO_DATA_FOUND THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
621: OE_MSG_PUB.Add;
622: WHEN OTHERS THEN
623: null;
624: end;
633: exception
634: WHEN NO_DATA_FOUND THEN
635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN
637: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
638: OE_MSG_PUB.Add;
639: END IF;
640: RAISE FND_API.G_EXC_ERROR;
641:
672:
673: IF l_count > 0 THEN
674: l_return_status := FND_API.G_RET_STS_ERROR;
675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
676: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
677: OE_MSG_PUB.Add;
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680: END IF;
704:
705: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
706: THEN
707: l_return_status := FND_API.G_RET_STS_ERROR;
708: FND_MESSAGE.SET_NAME('QP','QP_DUP_PRICING_ATTR');
709: OE_MSG_PUB.Add;
710: end if;
711: end if;
712:
754:
755: l_return_status := FND_API.G_RET_STS_ERROR;
756: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
757: THEN
758: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')||'/'||
760: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE')||'/'||
761: QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
762: OE_MSG_PUB.Add;
755: l_return_status := FND_API.G_RET_STS_ERROR;
756: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
757: THEN
758: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')||'/'||
760: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE')||'/'||
761: QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
762: OE_MSG_PUB.Add;
763: END IF;
769:
770: l_return_status := FND_API.G_RET_STS_ERROR;
771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
772: THEN
773: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Enter Required Values');
775: OE_MSG_PUB.Add;
776: END IF;
777: RAISE FND_API.G_EXC_ERROR;
770: l_return_status := FND_API.G_RET_STS_ERROR;
771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
772: THEN
773: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Enter Required Values');
775: OE_MSG_PUB.Add;
776: END IF;
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;
796:
797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
798: THEN
799:
800: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
801: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
802: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
803:
804: OE_MSG_PUB.Add;
797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
798: THEN
799:
800: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
801: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
802: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
803:
804: OE_MSG_PUB.Add;
805: END IF;
798: THEN
799:
800: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
801: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
802: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
803:
804: OE_MSG_PUB.Add;
805: END IF;
806:
821:
822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
823: THEN
824:
825: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
826: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
827: OE_MSG_PUB.Add;
828: END IF;
829:
822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
823: THEN
824:
825: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
826: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
827: OE_MSG_PUB.Add;
828: END IF;
829:
830: RAISE FND_API.G_EXC_ERROR;
847:
848: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
849: THEN
850:
851: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
852: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
853: --OE_MSG_PUB.Add;
854: OE_MSG_PUB.Add;
855: END IF;
848: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
849: THEN
850:
851: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
852: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
853: --OE_MSG_PUB.Add;
854: OE_MSG_PUB.Add;
855: END IF;
856: RAISE FND_API.G_EXC_ERROR;
871: l_return_status := FND_API.G_RET_STS_ERROR;
872:
873: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
874: THEN
875: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
876: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
878: OE_MSG_PUB.Add;
879: END IF;
872:
873: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
874: THEN
875: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
876: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
878: OE_MSG_PUB.Add;
879: END IF;
880: RAISE FND_API.G_EXC_ERROR;
873: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
874: THEN
875: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
876: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
878: OE_MSG_PUB.Add;
879: END IF;
880: RAISE FND_API.G_EXC_ERROR;
881:
888: l_return_status := FND_API.G_RET_STS_ERROR;
889:
890: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
891: THEN
892: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute');
894: OE_MSG_PUB.Add;
895: END IF;
896:
889:
890: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
891: THEN
892: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute');
894: OE_MSG_PUB.Add;
895: END IF;
896:
897: RAISE FND_API.G_EXC_ERROR;
912: l_return_status := FND_API.G_RET_STS_ERROR;
913:
914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
915: THEN
916: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
917: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
918: OE_MSG_PUB.Add;
919: END IF;
920: RAISE FND_API.G_EXC_ERROR;
913:
914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
915: THEN
916: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
917: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
918: OE_MSG_PUB.Add;
919: END IF;
920: RAISE FND_API.G_EXC_ERROR;
921:
935: l_return_status := FND_API.G_RET_STS_ERROR;
936:
937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
938: THEN
939: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
941: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); -- Fix For Bug-1974413
942: OE_MSG_PUB.Add;
943: END IF;
936:
937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
938: THEN
939: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
941: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); -- Fix For Bug-1974413
942: OE_MSG_PUB.Add;
943: END IF;
944: RAISE FND_API.G_EXC_ERROR;
954: l_return_status := FND_API.G_RET_STS_ERROR;
955:
956: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
957: THEN
958: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
959: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413
960: OE_MSG_PUB.Add;
961: END IF;
962: RAISE FND_API.G_EXC_ERROR;
955:
956: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
957: THEN
958: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
959: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413
960: OE_MSG_PUB.Add;
961: END IF;
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
972: l_return_status := FND_API.G_RET_STS_ERROR;
973:
974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
975: THEN
976: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
977: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
978: OE_MSG_PUB.Add;
979: END IF;
980: RAISE FND_API.G_EXC_ERROR;
973:
974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
975: THEN
976: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
977: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
978: OE_MSG_PUB.Add;
979: END IF;
980: RAISE FND_API.G_EXC_ERROR;
981: END IF;
996:
997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999:
1000: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1001: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); --Fix For Bug-1974413
1003: OE_MSG_PUB.Add;
1004: END IF;
997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
998: THEN
999:
1000: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1001: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); --Fix For Bug-1974413
1003: OE_MSG_PUB.Add;
1004: END IF;
1005:
998: THEN
999:
1000: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1001: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); --Fix For Bug-1974413
1003: OE_MSG_PUB.Add;
1004: END IF;
1005:
1006: RAISE FND_API.G_EXC_ERROR;
1020:
1021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1022: THEN
1023:
1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1025: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
1027: OE_MSG_PUB.Add;
1028: END IF;
1021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1022: THEN
1023:
1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1025: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
1027: OE_MSG_PUB.Add;
1028: END IF;
1029:
1022: THEN
1023:
1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1025: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
1027: OE_MSG_PUB.Add;
1028: END IF;
1029:
1030: RAISE FND_API.G_EXC_ERROR;
1071:
1072: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1073: THEN
1074:
1075: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1076: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
1078: OE_MSG_PUB.Add;
1079: END IF;
1072: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1073: THEN
1074:
1075: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1076: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
1078: OE_MSG_PUB.Add;
1079: END IF;
1080:
1073: THEN
1074:
1075: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1076: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
1078: OE_MSG_PUB.Add;
1079: END IF;
1080:
1081: RAISE FND_API.G_EXC_ERROR;
1095:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1097: THEN
1098:
1099: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
1101: OE_MSG_PUB.Add;
1102: END IF;
1103:
1096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1097: THEN
1098:
1099: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
1101: OE_MSG_PUB.Add;
1102: END IF;
1103:
1104: RAISE FND_API.G_EXC_ERROR;
1121:
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1123: THEN
1124:
1125: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
1127: --OE_MSG_PUB.Add;
1128: OE_MSG_PUB.Add;
1129: END IF;
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1123: THEN
1124:
1125: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
1127: --OE_MSG_PUB.Add;
1128: OE_MSG_PUB.Add;
1129: END IF;
1130: RAISE FND_API.G_EXC_ERROR;
1145: l_return_status := FND_API.G_RET_STS_ERROR;
1146:
1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1148: THEN
1149: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1150: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
1152: OE_MSG_PUB.Add;
1153: END IF;
1146:
1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1148: THEN
1149: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1150: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
1152: OE_MSG_PUB.Add;
1153: END IF;
1154: RAISE FND_API.G_EXC_ERROR;
1147: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1148: THEN
1149: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1150: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
1152: OE_MSG_PUB.Add;
1153: END IF;
1154: RAISE FND_API.G_EXC_ERROR;
1155:
1170: l_return_status := FND_API.G_RET_STS_ERROR;
1171:
1172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1173: THEN
1174: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
1176: OE_MSG_PUB.Add;
1177: END IF;
1178: RAISE FND_API.G_EXC_ERROR;
1171:
1172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1173: THEN
1174: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
1176: OE_MSG_PUB.Add;
1177: END IF;
1178: RAISE FND_API.G_EXC_ERROR;
1179:
1193: l_return_status := FND_API.G_RET_STS_ERROR;
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1196: THEN
1197: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
1199: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413
1200: OE_MSG_PUB.Add;
1201: END IF;
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1196: THEN
1197: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
1199: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413
1200: OE_MSG_PUB.Add;
1201: END IF;
1202: RAISE FND_API.G_EXC_ERROR;
1208: l_return_status := FND_API.G_RET_STS_ERROR;
1209:
1210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1211: THEN
1212: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
1214: OE_MSG_PUB.Add;
1215: END IF;
1216: RAISE FND_API.G_EXC_ERROR;
1209:
1210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1211: THEN
1212: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
1214: OE_MSG_PUB.Add;
1215: END IF;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1314: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
1315:
1316: IF l_sourcing_enabled <> 'Y' THEN
1317:
1318: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1319: FND_MESSAGE.SET_TOKEN('CONTEXT',
1320: p_Pricing_Attr_rec.pricing_attribute_context);
1321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1322: p_Pricing_Attr_rec.pricing_attribute);
1315:
1316: IF l_sourcing_enabled <> 'Y' THEN
1317:
1318: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1319: FND_MESSAGE.SET_TOKEN('CONTEXT',
1320: p_Pricing_Attr_rec.pricing_attribute_context);
1321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1322: p_Pricing_Attr_rec.pricing_attribute);
1323: OE_MSG_PUB.Add;
1317:
1318: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
1319: FND_MESSAGE.SET_TOKEN('CONTEXT',
1320: p_Pricing_Attr_rec.pricing_attribute_context);
1321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1322: p_Pricing_Attr_rec.pricing_attribute);
1323: OE_MSG_PUB.Add;
1324:
1325: END IF;
1325: END IF;
1326:
1327: IF l_sourcing_status <> 'Y' THEN
1328:
1329: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1330: FND_MESSAGE.SET_TOKEN('CONTEXT',
1331: p_Pricing_Attr_rec.pricing_attribute_context);
1332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1333: p_Pricing_Attr_rec.pricing_attribute);
1326:
1327: IF l_sourcing_status <> 'Y' THEN
1328:
1329: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1330: FND_MESSAGE.SET_TOKEN('CONTEXT',
1331: p_Pricing_Attr_rec.pricing_attribute_context);
1332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1333: p_Pricing_Attr_rec.pricing_attribute);
1334: OE_MSG_PUB.Add;
1328:
1329: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
1330: FND_MESSAGE.SET_TOKEN('CONTEXT',
1331: p_Pricing_Attr_rec.pricing_attribute_context);
1332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1333: p_Pricing_Attr_rec.pricing_attribute);
1334: OE_MSG_PUB.Add;
1335:
1336: END IF;