DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on FND_MESSAGE

Line 71: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Id');

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:

Line 89: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

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;

Line 90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute_context');

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:

Line 100: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

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;

Line 101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute');

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:

Line 111: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

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;

Line 112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attr_value');

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:

Line 127: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');

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:

Line 139: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');

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

Line 151: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 152: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Phase Id');

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:

Line 163: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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

Line 164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413

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:

Line 174: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Excluder Flag');

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;

Line 187: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413

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:

Line 199: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 200: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')); -- Fix For Bug-1974413

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:

Line 211: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 212: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413

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:

Line 223: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Product Attribute Datatype');

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:

Line 235: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 236: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413

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:

Line 247: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');

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;

Line 248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ATTRIBUTE_GROUPING_NO')); -- Fix For Bug-1974413

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:

Line 295: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');

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;

Line 296: FND_MESSAGE.set_token('CATID', p_PRICING_ATTR_REC.product_attr_value);

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;

Line 297: FND_MESSAGE.set_token('PTE', l_pte_code);

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:

Line 298: FND_MESSAGE.set_token('SS', l_ss_code);

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;

Line 430: FND_MESSAGE.SET_NAME('QP','QP_DUP_PRICING_ATTR');

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

Line 439: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');

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

Line 488: FND_MESSAGE.SET_NAME('QP','QP_ITEM_NOT_VALID');

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;

Line 489: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_PRICING_ATTR_rec.product_attr_value);

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:

Line 517: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');

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:

Line 535: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');

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;

Line 620: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');

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;

Line 637: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');

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:

Line 676: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');

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;

Line 708: FND_MESSAGE.SET_NAME('QP','QP_DUP_PRICING_ATTR');

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:

Line 758: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')||'/'||

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;

Line 773: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Enter Required Values');

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;

Line 800: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 801: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 802: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413

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:

Line 825: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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:

Line 826: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');

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;

Line 851: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 852: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');

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;

Line 875: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 876: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');

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:

Line 892: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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:

Line 893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute');

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;

Line 916: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 917: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');

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:

Line 939: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 940: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||

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;

Line 958: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 959: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413

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;

Line 976: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 977: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');

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;

Line 1000: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 1001: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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:

Line 1002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); --Fix For Bug-1974413

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;

Line 1024: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 1025: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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:

Line 1026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413

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;

Line 1075: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 1076: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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:

Line 1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413

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;

Line 1099: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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:

Line 1100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');

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;

Line 1125: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 1126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');

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;

Line 1149: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 1150: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 1151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');

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:

Line 1174: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 1175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');

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:

Line 1197: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );

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;

Line 1198: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||

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;

Line 1212: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

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;

Line 1213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');

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;

Line 1318: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');

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);

Line 1319: FND_MESSAGE.SET_TOKEN('CONTEXT',

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;

Line 1321: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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;

Line 1329: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');

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);

Line 1330: FND_MESSAGE.SET_TOKEN('CONTEXT',

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;

Line 1332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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;