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

Line 68: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

64: THEN
65:
66: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 73: oe_msg_pub.Add;

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

Line 91: OE_MSG_PUB.Add;

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:
95: IF nvl(p_old_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE,'X') <>

Line 102: OE_MSG_PUB.Add;

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:
106: IF nvl(p_old_PRICING_ATTR_rec.PRODUCT_ATTR_VALUE,9999999) <>

Line 113: OE_MSG_PUB.Add;

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

Line 125: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

121: IF p_PRICING_ATTR_rec.list_line_id IS NULL
122: THEN
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;

Line 129: oe_msg_pub.Add;

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:
133: /* IF p_PRICING_ATTR_rec.list_header_id IS NULL

Line 137: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

133: /* IF p_PRICING_ATTR_rec.list_header_id IS NULL
134: THEN
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;

Line 141: oe_msg_pub.Add;

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: */
145: IF p_PRICING_ATTR_rec.pricing_phase_id IS NULL

Line 149: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

145: IF p_PRICING_ATTR_rec.pricing_phase_id IS NULL
146: THEN
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;

Line 153: oe_msg_pub.Add;

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:
157: IF p_PRICING_ATTR_rec.excluder_flag IS NULL

Line 161: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

157: IF p_PRICING_ATTR_rec.excluder_flag IS NULL
158: THEN
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;

Line 165: oe_msg_pub.Add;

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:
169: IF (p_PRICING_ATTR_rec.excluder_flag not in ( 'Y', 'y', 'N', 'n' ) )

Line 172: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

168:
169: IF (p_PRICING_ATTR_rec.excluder_flag not in ( 'Y', 'y', 'N', 'n' ) )
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;

Line 176: oe_msg_pub.Add;

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

Line 185: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

181: IF p_PRICING_ATTR_rec.product_attribute_context IS NULL
182: THEN
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;

Line 189: oe_msg_pub.Add;

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:
193: IF p_PRICING_ATTR_rec.product_attribute IS NULL

Line 197: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

193: IF p_PRICING_ATTR_rec.product_attribute IS NULL
194: THEN
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;

Line 201: oe_msg_pub.Add;

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:
205: IF p_PRICING_ATTR_rec.product_attr_value IS NULL

Line 209: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

205: IF p_PRICING_ATTR_rec.product_attr_value IS NULL
206: THEN
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;

Line 213: oe_msg_pub.Add;

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:
217: IF p_PRICING_ATTR_rec.product_attribute_datatype IS NULL

Line 221: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

217: IF p_PRICING_ATTR_rec.product_attribute_datatype IS NULL
218: THEN
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;

Line 225: oe_msg_pub.Add;

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:
229: IF p_PRICING_ATTR_rec.product_uom_code IS NULL

Line 233: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

229: IF p_PRICING_ATTR_rec.product_uom_code IS NULL
230: THEN
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;

Line 237: oe_msg_pub.Add;

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:
241: IF p_PRICING_ATTR_rec.attribute_grouping_no IS NULL

Line 245: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

241: IF p_PRICING_ATTR_rec.attribute_grouping_no IS NULL
242: THEN
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;

Line 249: oe_msg_pub.Add;

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

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

289: IF NOT l_fna_valid THEN
290:
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);

Line 299: OE_MSG_PUB.Add;

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

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

423:
424: OE_Debug_Pub.add ( 'smbalara :: l_x_rows ' || l_x_rows );
425: if l_x_rows > 0 THEN
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;

Line 431: OE_MSG_PUB.Add;

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

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

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;

Line 440: OE_MSG_PUB.Add;

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
444: END IF;--end if of l_count>0

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

482:
483: exception
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;

Line 490: OE_MSG_PUB.Add;

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:
494: when others then

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

511: and inventory_item_id = p_PRICING_ATTR_rec.product_attr_value
512: and rownum = 1;
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;

Line 518: OE_MSG_PUB.Add;

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:
522: WHEN OTHERS THEN

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

530: p_old_PRICING_ATTR_rec.product_uom_code IS NULL ) THEN
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;

Line 536: OE_MSG_PUB.Add;

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

Line 621: OE_MSG_PUB.Add;

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;
625: *

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

631: where uom_code = p_PRICING_ATTR_rec.product_uom_code
632: and rownum = 1;
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;

Line 638: OE_MSG_PUB.Add;

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:
642: WHEN OTHERS THEN

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

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

Line 677: OE_MSG_PUB.Add;

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

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

701:
702: OE_Debug_Pub.add ( 'Geresh :: Result ' || l_x_rows );
703: if l_x_rows > 0 THEN
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;

Line 709: OE_MSG_PUB.Add;

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

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

752: OR p_Pricing_Attr_rec.comparison_operator_code IS NULL)
753: THEN
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')||'/'||

Line 762: OE_MSG_PUB.Add;

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;
764: RAISE FND_API.G_EXC_ERROR;
765: ELSE
766:

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

767: IF ( p_Pricing_Attr_rec.comparison_operator_code = 'BETWEEN'
768: AND p_Pricing_Attr_rec.pricing_attribute_datatype is NULL ) THEN
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;

Line 775: OE_MSG_PUB.Add;

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

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

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

Line 804: OE_MSG_PUB.Add;

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:
807: RAISE FND_API.G_EXC_ERROR;
808:

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

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

Line 827: OE_MSG_PUB.Add;

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

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

844: If l_value_error = 'N' AND l_error_code = 9 -- invalid value
845: Then
846: l_return_status := FND_API.G_RET_STS_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 ');

Line 853: --OE_MSG_PUB.Add;

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;
857: End If;

Line 854: OE_MSG_PUB.Add;

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;
857: End If;
858: END IF;

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

869: If p_Pricing_Attr_rec.pricing_attribute_datatype <> l_datatype --- invalid datatype
870: Then
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 ');

Line 878: OE_MSG_PUB.Add;

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:
882: End If;

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

886: --When Pricing Context is 'Volume' and Attribute is 'Item Amount'
887: THEN
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;

Line 894: OE_MSG_PUB.Add;

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

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

910: IF l_error_code <> 0 THEN
911:
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;

Line 918: OE_MSG_PUB.Add;

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

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

933: p_Pricing_Attr_rec.pricing_attr_value_from IS NULL)
934: THEN
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

Line 942: OE_MSG_PUB.Add;

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

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

952: p_Pricing_Attr_rec.pricing_attr_value_from IS NULL
953: THEN
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;

Line 960: OE_MSG_PUB.Add;

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

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

970:
971: IF l_error_code <> 0 THEN
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;

Line 978: OE_MSG_PUB.Add;

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;
982: --here

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

993: IF p_Pricing_Attr_rec.comparison_operator_code is null then
994:
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:
1000: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1001: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 1003: OE_MSG_PUB.Add;

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;
1007: ELSE

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

1017: Then
1018:
1019: l_return_status := FND_API.G_RET_STS_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');

Line 1027: OE_MSG_PUB.Add;

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

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

1068: If (l_context_error = 'N' AND l_error_code = 7) -- invalid context
1069: Then
1070: l_return_status := FND_API.G_RET_STS_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');

Line 1078: OE_MSG_PUB.Add;

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

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

1092: If l_attribute_error = 'N' AND l_error_code = 8 -- invalid Attribute
1093: Then
1094: l_return_status := FND_API.G_RET_STS_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');

Line 1101: OE_MSG_PUB.Add;

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

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

1118: If l_value_error = 'N' AND l_error_code = 9 -- invalid value
1119: Then
1120: l_return_status := FND_API.G_RET_STS_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 ');

Line 1127: --OE_MSG_PUB.Add;

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;
1131: End If;

Line 1128: OE_MSG_PUB.Add;

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;
1131: End If;
1132: END IF;

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

1143: If p_Pricing_Attr_rec.pricing_attribute_datatype <> l_datatype --- invalid datatype
1144: Then
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 ');

Line 1152: OE_MSG_PUB.Add;

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:
1156: End If;

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

1168: IF l_error_code <> 0 THEN
1169:
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;

Line 1176: OE_MSG_PUB.Add;

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

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

1191: p_Pricing_Attr_rec.pricing_attr_value_from IS NULL)
1192: THEN
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

Line 1200: OE_MSG_PUB.Add;

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

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

1206:
1207: IF l_error_code <> 0 THEN
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;

Line 1214: OE_MSG_PUB.Add;

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

Line 1323: OE_MSG_PUB.Add;

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;
1326:
1327: IF l_sourcing_status <> 'Y' THEN

Line 1334: OE_MSG_PUB.Add;

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;
1337:
1338: END IF; --If sourcing_method = 'ATTRIBUTE MAPPING'

Line 1368: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1364: WHEN OTHERS THEN
1365:
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367:
1368: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1369: THEN
1370: oe_msg_pub.Add_Exc_Msg
1371: ( G_PKG_NAME
1372: , 'Entity'

Line 1370: oe_msg_pub.Add_Exc_Msg

1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367:
1368: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1369: THEN
1370: oe_msg_pub.Add_Exc_Msg
1371: ( G_PKG_NAME
1372: , 'Entity'
1373: );
1374: END IF;

Line 1821: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1817: WHEN OTHERS THEN
1818:
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820:
1821: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1822: THEN
1823: oe_msg_pub.Add_Exc_Msg
1824: ( G_PKG_NAME
1825: , 'Attributes'

Line 1823: oe_msg_pub.Add_Exc_Msg

1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820:
1821: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1822: THEN
1823: oe_msg_pub.Add_Exc_Msg
1824: ( G_PKG_NAME
1825: , 'Attributes'
1826: );
1827: END IF;

Line 1863: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1859: WHEN OTHERS THEN
1860:
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862:
1863: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1864: THEN
1865: oe_msg_pub.Add_Exc_Msg
1866: ( G_PKG_NAME
1867: , 'Entity_Delete'

Line 1865: oe_msg_pub.Add_Exc_Msg

1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862:
1863: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1864: THEN
1865: oe_msg_pub.Add_Exc_Msg
1866: ( G_PKG_NAME
1867: , 'Entity_Delete'
1868: );
1869: END IF;