APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on OE_MSG_PUB

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

58: THEN
59:
60: l_return_status := FND_API.G_RET_STS_ERROR;
61:
62: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
63: THEN
64:
65: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Id');

Line 67: oe_msg_pub.Add;

63: THEN
64:
65: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Id');
67: oe_msg_pub.Add;
68:
69: END IF;
70:
71: END IF;

Line 85: OE_MSG_PUB.Add;

81: l_return_status := FND_API.G_RET_STS_ERROR;
82:
83: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
84: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute_context');
85: OE_MSG_PUB.Add;
86:
87: END IF;
88:
89: IF nvl(p_old_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE,'X') <>

Line 96: OE_MSG_PUB.Add;

92: l_return_status := FND_API.G_RET_STS_ERROR;
93:
94: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
95: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attribute');
96: OE_MSG_PUB.Add;
97:
98: END IF;
99:
100: IF nvl(p_old_PRICING_ATTR_rec.PRODUCT_ATTR_VALUE,9999999) <>

Line 107: OE_MSG_PUB.Add;

103: l_return_status := FND_API.G_RET_STS_ERROR;
104:
105: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_attr_value');
107: OE_MSG_PUB.Add;
108:
109: END IF;
110:
111: END IF;

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

115: IF p_PRICING_ATTR_rec.list_line_id IS NULL
116: THEN
117: l_return_status := FND_API.G_RET_STS_ERROR;
118:
119: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
120: THEN
121: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
123: oe_msg_pub.Add;

Line 123: oe_msg_pub.Add;

119: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
120: THEN
121: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Line Id');
123: oe_msg_pub.Add;
124: END IF;
125: END IF;
126:
127: /* IF p_PRICING_ATTR_rec.list_header_id IS NULL

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

127: /* IF p_PRICING_ATTR_rec.list_header_id IS NULL
128: THEN
129: l_return_status := FND_API.G_RET_STS_ERROR;
130:
131: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
132: THEN
133: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
134: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');
135: oe_msg_pub.Add;

Line 135: oe_msg_pub.Add;

131: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
132: THEN
133: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
134: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');
135: oe_msg_pub.Add;
136: END IF;
137: END IF;
138: */
139: IF p_PRICING_ATTR_rec.pricing_phase_id IS NULL

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

139: IF p_PRICING_ATTR_rec.pricing_phase_id IS NULL
140: THEN
141: l_return_status := FND_API.G_RET_STS_ERROR;
142:
143: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
144: THEN
145: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Phase Id');
147: oe_msg_pub.Add;

Line 147: oe_msg_pub.Add;

143: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
144: THEN
145: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Phase Id');
147: oe_msg_pub.Add;
148: END IF;
149: END IF;
150:
151: IF p_PRICING_ATTR_rec.excluder_flag IS NULL

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

151: IF p_PRICING_ATTR_rec.excluder_flag IS NULL
152: THEN
153: l_return_status := FND_API.G_RET_STS_ERROR;
154:
155: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
156: THEN
157: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413
159: oe_msg_pub.Add;

Line 159: oe_msg_pub.Add;

155: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
156: THEN
157: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('EXCLUDER_FLAG')); -- Fix For Bug-1974413
159: oe_msg_pub.Add;
160: END IF;
161: ELSE
162:
163: IF (p_PRICING_ATTR_rec.excluder_flag not in ( 'Y', 'y', 'N', 'n' ) )

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

162:
163: IF (p_PRICING_ATTR_rec.excluder_flag not in ( 'Y', 'y', 'N', 'n' ) )
164: THEN
165: l_return_status := FND_API.G_RET_STS_ERROR;
166: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
167: THEN
168: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Excluder Flag');
170: oe_msg_pub.Add;

Line 170: oe_msg_pub.Add;

166: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
167: THEN
168: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Excluder Flag');
170: oe_msg_pub.Add;
171: END IF;
172: END IF;
173: END IF;
174:

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

175: IF p_PRICING_ATTR_rec.product_attribute_context IS NULL
176: THEN
177: l_return_status := FND_API.G_RET_STS_ERROR;
178:
179: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
180: THEN
181: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
183: oe_msg_pub.Add;

Line 183: oe_msg_pub.Add;

179: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
180: THEN
181: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
183: oe_msg_pub.Add;
184: END IF;
185: END IF;
186:
187: IF p_PRICING_ATTR_rec.product_attribute IS NULL

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

187: IF p_PRICING_ATTR_rec.product_attribute IS NULL
188: THEN
189: l_return_status := FND_API.G_RET_STS_ERROR;
190:
191: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
192: THEN
193: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
194: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')); -- Fix For Bug-1974413
195: oe_msg_pub.Add;

Line 195: oe_msg_pub.Add;

191: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
192: THEN
193: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
194: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTRIBUTE')); -- Fix For Bug-1974413
195: oe_msg_pub.Add;
196: END IF;
197: END IF;
198:
199: IF p_PRICING_ATTR_rec.product_attr_value IS NULL

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

199: IF p_PRICING_ATTR_rec.product_attr_value IS NULL
200: THEN
201: l_return_status := FND_API.G_RET_STS_ERROR;
202:
203: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
204: THEN
205: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
207: oe_msg_pub.Add;

Line 207: oe_msg_pub.Add;

203: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
204: THEN
205: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_ATTR_VALUE')); -- Fix For Bug-1974413
207: oe_msg_pub.Add;
208: END IF;
209: END IF;
210:
211: IF p_PRICING_ATTR_rec.product_attribute_datatype IS NULL

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

211: IF p_PRICING_ATTR_rec.product_attribute_datatype IS NULL
212: THEN
213: l_return_status := FND_API.G_RET_STS_ERROR;
214:
215: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
216: THEN
217: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Product Attribute Datatype');
219: oe_msg_pub.Add;

Line 219: oe_msg_pub.Add;

215: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
216: THEN
217: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Product Attribute Datatype');
219: oe_msg_pub.Add;
220: END IF;
221: END IF;
222:
223: IF p_PRICING_ATTR_rec.product_uom_code IS NULL

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

223: IF p_PRICING_ATTR_rec.product_uom_code IS NULL
224: THEN
225: l_return_status := FND_API.G_RET_STS_ERROR;
226:
227: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
228: THEN
229: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413
231: oe_msg_pub.Add;

Line 231: oe_msg_pub.Add;

227: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
228: THEN
229: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRODUCT_UOM_CODE')); -- Fix For Bug-1974413
231: oe_msg_pub.Add;
232: END IF;
233: END IF;
234:
235: IF p_PRICING_ATTR_rec.attribute_grouping_no IS NULL

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

235: IF p_PRICING_ATTR_rec.attribute_grouping_no IS NULL
236: THEN
237: l_return_status := FND_API.G_RET_STS_ERROR;
238:
239: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
240: THEN
241: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ATTRIBUTE_GROUPING_NO')); -- Fix For Bug-1974413
243: oe_msg_pub.Add;

Line 243: oe_msg_pub.Add;

239: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
240: THEN
241: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('ATTRIBUTE_GROUPING_NO')); -- Fix For Bug-1974413
243: oe_msg_pub.Add;
244: END IF;
245: END IF;
246:
247: --

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

283: IF NOT l_fna_valid THEN
284:
285: l_return_status := FND_API.G_RET_STS_ERROR;
286:
287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
288: THEN
289: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
290: FND_MESSAGE.set_token('CATID', p_PRICING_ATTR_REC.product_attr_value);
291: FND_MESSAGE.set_token('PTE', l_pte_code);

Line 293: OE_MSG_PUB.Add;

289: FND_MESSAGE.set_name('QP', 'QP_INVALID_CAT_FUNC_PTE');
290: FND_MESSAGE.set_token('CATID', p_PRICING_ATTR_REC.product_attr_value);
291: FND_MESSAGE.set_token('PTE', l_pte_code);
292: FND_MESSAGE.set_token('SS', l_ss_code);
293: OE_MSG_PUB.Add;
294: END IF;
295:
296: RAISE FND_API.G_EXC_ERROR;
297:

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

392: end loop;
393:
394: IF l_count > 0 THEN
395: l_return_status := FND_API.G_RET_STS_ERROR;
396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
397: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
398: OE_MSG_PUB.Add;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;

Line 398: OE_MSG_PUB.Add;

394: IF l_count > 0 THEN
395: l_return_status := FND_API.G_RET_STS_ERROR;
396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
397: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
398: OE_MSG_PUB.Add;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401: END IF;
402: END IF;

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

425: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID');
426: exception
427: WHEN NO_DATA_FOUND THEN
428:
429: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
430: THEN
431: FND_MESSAGE.SET_NAME('QP','QP_ITEM_NOT_VALID');
432: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_PRICING_ATTR_rec.product_attr_value);
433: OE_MSG_PUB.Add;

Line 433: OE_MSG_PUB.Add;

429: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
430: THEN
431: FND_MESSAGE.SET_NAME('QP','QP_ITEM_NOT_VALID');
432: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_PRICING_ATTR_rec.product_attr_value);
433: OE_MSG_PUB.Add;
434: END IF;
435: RAISE FND_API.G_EXC_ERROR;
436:
437: when others then

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

454: and inventory_item_id = p_PRICING_ATTR_rec.product_attr_value
455: and rownum = 1;
456: exception
457: WHEN NO_DATA_FOUND THEN
458: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
461: OE_MSG_PUB.Add;
462: END IF;

Line 461: OE_MSG_PUB.Add;

457: WHEN NO_DATA_FOUND THEN
458: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
461: OE_MSG_PUB.Add;
462: END IF;
463: RAISE FND_API.G_EXC_ERROR;
464:
465: WHEN OTHERS THEN

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

473: p_old_PRICING_ATTR_rec.product_uom_code IS NULL ) THEN
474: IF NOT QP_VALIDATE.Product_Uom(p_pricing_attr_rec.product_uom_code,
475: to_number(p_PRICING_ATTR_rec.product_attr_value),
476: p_PRICING_ATTR_rec.list_header_id) THEN
477: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
478: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
479: OE_MSG_PUB.Add;
480: END IF;
481: RAISE FND_API.G_EXC_ERROR;

Line 479: OE_MSG_PUB.Add;

475: to_number(p_PRICING_ATTR_rec.product_attr_value),
476: p_PRICING_ATTR_rec.list_header_id) THEN
477: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
478: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
479: OE_MSG_PUB.Add;
480: END IF;
481: RAISE FND_API.G_EXC_ERROR;
482: END IF;
483: END IF;

Line 564: OE_MSG_PUB.Add;

560: exception
561: WHEN NO_DATA_FOUND THEN
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
564: OE_MSG_PUB.Add;
565: WHEN OTHERS THEN
566: null;
567: end;
568: *

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

574: where uom_code = p_PRICING_ATTR_rec.product_uom_code
575: and rownum = 1;
576: exception
577: WHEN NO_DATA_FOUND THEN
578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
581: OE_MSG_PUB.Add;
582: END IF;

Line 581: OE_MSG_PUB.Add;

577: WHEN NO_DATA_FOUND THEN
578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
581: OE_MSG_PUB.Add;
582: END IF;
583: RAISE FND_API.G_EXC_ERROR;
584:
585: WHEN OTHERS THEN

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

614: END;
615:
616: IF l_count > 0 THEN
617: l_return_status := FND_API.G_RET_STS_ERROR;
618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
619: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
620: OE_MSG_PUB.Add;
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;

Line 620: OE_MSG_PUB.Add;

616: IF l_count > 0 THEN
617: l_return_status := FND_API.G_RET_STS_ERROR;
618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
619: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
620: OE_MSG_PUB.Add;
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: END IF;
624:

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

644:
645: OE_Debug_Pub.add ( 'Geresh :: Result ' || l_x_rows );
646: if l_x_rows > 0 THEN
647:
648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: l_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MESSAGE.SET_NAME('QP','QP_DUP_PRICING_ATTR');
652: OE_MSG_PUB.Add;

Line 652: OE_MSG_PUB.Add;

648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: l_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MESSAGE.SET_NAME('QP','QP_DUP_PRICING_ATTR');
652: OE_MSG_PUB.Add;
653: end if;
654: end if;
655:
656:

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

695: OR p_Pricing_Attr_rec.comparison_operator_code IS NULL)
696: THEN
697:
698: l_return_status := FND_API.G_RET_STS_ERROR;
699: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
700: THEN
701: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')||'/'||
703: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE')||'/'||

Line 705: OE_MSG_PUB.Add;

701: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')||'/'||
703: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE')||'/'||
704: QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
705: OE_MSG_PUB.Add;
706: END IF;
707: RAISE FND_API.G_EXC_ERROR;
708: ELSE
709:

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

710: IF ( p_Pricing_Attr_rec.comparison_operator_code = 'BETWEEN'
711: AND p_Pricing_Attr_rec.pricing_attribute_datatype is NULL ) THEN
712:
713: l_return_status := FND_API.G_RET_STS_ERROR;
714: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
715: THEN
716: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
717: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Enter Required Values');
718: OE_MSG_PUB.Add;

Line 718: OE_MSG_PUB.Add;

714: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
715: THEN
716: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
717: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Enter Required Values');
718: OE_MSG_PUB.Add;
719: END IF;
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722:

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

736: If (l_context_error = 'N' AND l_error_code = 7) -- invalid context
737: Then
738: l_return_status := FND_API.G_RET_STS_ERROR;
739:
740: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
741: THEN
742:
743: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
744: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 747: OE_MSG_PUB.Add;

743: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
744: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
746:
747: OE_MSG_PUB.Add;
748: END IF;
749:
750: RAISE FND_API.G_EXC_ERROR;
751:

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

761: If l_attribute_error = 'N' AND l_error_code = 8 -- invalid Attribute
762: Then
763: l_return_status := FND_API.G_RET_STS_ERROR;
764:
765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
766: THEN
767:
768: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');

Line 770: OE_MSG_PUB.Add;

766: THEN
767:
768: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
770: OE_MSG_PUB.Add;
771: END IF;
772:
773: RAISE FND_API.G_EXC_ERROR;
774:

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

787: If l_value_error = 'N' AND l_error_code = 9 -- invalid value
788: Then
789: l_return_status := FND_API.G_RET_STS_ERROR;
790:
791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
792: THEN
793:
794: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');

Line 796: --OE_MSG_PUB.Add;

792: THEN
793:
794: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
796: --OE_MSG_PUB.Add;
797: OE_MSG_PUB.Add;
798: END IF;
799: RAISE FND_API.G_EXC_ERROR;
800: End If;

Line 797: OE_MSG_PUB.Add;

793:
794: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
796: --OE_MSG_PUB.Add;
797: OE_MSG_PUB.Add;
798: END IF;
799: RAISE FND_API.G_EXC_ERROR;
800: End If;
801: END IF;

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

812: If p_Pricing_Attr_rec.pricing_attribute_datatype <> l_datatype --- invalid datatype
813: Then
814: l_return_status := FND_API.G_RET_STS_ERROR;
815:
816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
817: THEN
818: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
819: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');

Line 821: OE_MSG_PUB.Add;

817: THEN
818: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
819: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
820: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
821: OE_MSG_PUB.Add;
822: END IF;
823: RAISE FND_API.G_EXC_ERROR;
824:
825: End If;

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

829: --When Pricing Context is 'Volume' and Attribute is 'Item Amount'
830: THEN
831: l_return_status := FND_API.G_RET_STS_ERROR;
832:
833: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
834: THEN
835: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
836: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute');
837: OE_MSG_PUB.Add;

Line 837: OE_MSG_PUB.Add;

833: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
834: THEN
835: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
836: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute');
837: OE_MSG_PUB.Add;
838: END IF;
839:
840: RAISE FND_API.G_EXC_ERROR;
841:

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

853: IF l_error_code <> 0 THEN
854:
855: l_return_status := FND_API.G_RET_STS_ERROR;
856:
857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
858: THEN
859: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
860: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
861: OE_MSG_PUB.Add;

Line 861: OE_MSG_PUB.Add;

857: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
858: THEN
859: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
860: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
861: OE_MSG_PUB.Add;
862: END IF;
863: RAISE FND_API.G_EXC_ERROR;
864:
865: END IF;

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

876: p_Pricing_Attr_rec.pricing_attr_value_from IS NULL)
877: THEN
878: l_return_status := FND_API.G_RET_STS_ERROR;
879:
880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
881: THEN
882: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
884: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); -- Fix For Bug-1974413

Line 885: OE_MSG_PUB.Add;

881: THEN
882: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
884: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); -- Fix For Bug-1974413
885: OE_MSG_PUB.Add;
886: END IF;
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:

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

895: p_Pricing_Attr_rec.pricing_attr_value_from IS NULL
896: THEN
897: l_return_status := FND_API.G_RET_STS_ERROR;
898:
899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
900: THEN
901: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413
903: OE_MSG_PUB.Add;

Line 903: OE_MSG_PUB.Add;

899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
900: THEN
901: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413
903: OE_MSG_PUB.Add;
904: END IF;
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;
907:

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

913:
914: IF l_error_code <> 0 THEN
915: l_return_status := FND_API.G_RET_STS_ERROR;
916:
917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
918: THEN
919: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
921: OE_MSG_PUB.Add;

Line 921: OE_MSG_PUB.Add;

917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
918: THEN
919: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
921: OE_MSG_PUB.Add;
922: END IF;
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925: --here

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

936: IF p_Pricing_Attr_rec.comparison_operator_code is null then
937:
938: l_return_status := FND_API.G_RET_STS_ERROR;
939:
940: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
941: THEN
942:
943: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
944: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 946: OE_MSG_PUB.Add;

942:
943: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
944: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); --Fix For Bug-1974413
946: OE_MSG_PUB.Add;
947: END IF;
948:
949: RAISE FND_API.G_EXC_ERROR;
950: ELSE

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

960: Then
961:
962: l_return_status := FND_API.G_RET_STS_ERROR;
963:
964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
965: THEN
966:
967: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
968: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 970: OE_MSG_PUB.Add;

966:
967: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
968: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
970: OE_MSG_PUB.Add;
971: END IF;
972:
973: RAISE FND_API.G_EXC_ERROR;
974:

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

1011: If (l_context_error = 'N' AND l_error_code = 7) -- invalid context
1012: Then
1013: l_return_status := FND_API.G_RET_STS_ERROR;
1014:
1015: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1016: THEN
1017:
1018: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1019: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');

Line 1021: OE_MSG_PUB.Add;

1017:
1018: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1019: --FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_name('PRICING_ATTRIBUTE_CONTEXT')); --Fix For Bug-1974413
1021: OE_MSG_PUB.Add;
1022: END IF;
1023:
1024: RAISE FND_API.G_EXC_ERROR;
1025:

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

1035: If l_attribute_error = 'N' AND l_error_code = 8 -- invalid Attribute
1036: Then
1037: l_return_status := FND_API.G_RET_STS_ERROR;
1038:
1039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1040: THEN
1041:
1042: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');

Line 1044: OE_MSG_PUB.Add;

1040: THEN
1041:
1042: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Attribute');
1044: OE_MSG_PUB.Add;
1045: END IF;
1046:
1047: RAISE FND_API.G_EXC_ERROR;
1048:

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

1061: If l_value_error = 'N' AND l_error_code = 9 -- invalid value
1062: Then
1063: l_return_status := FND_API.G_RET_STS_ERROR;
1064:
1065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1066: THEN
1067:
1068: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');

Line 1070: --OE_MSG_PUB.Add;

1066: THEN
1067:
1068: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
1070: --OE_MSG_PUB.Add;
1071: OE_MSG_PUB.Add;
1072: END IF;
1073: RAISE FND_API.G_EXC_ERROR;
1074: End If;

Line 1071: OE_MSG_PUB.Add;

1067:
1068: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',' Value From ');
1070: --OE_MSG_PUB.Add;
1071: OE_MSG_PUB.Add;
1072: END IF;
1073: RAISE FND_API.G_EXC_ERROR;
1074: End If;
1075: END IF;

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

1086: If p_Pricing_Attr_rec.pricing_attribute_datatype <> l_datatype --- invalid datatype
1087: Then
1088: l_return_status := FND_API.G_RET_STS_ERROR;
1089:
1090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1091: THEN
1092: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1093: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1094: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');

Line 1095: OE_MSG_PUB.Add;

1091: THEN
1092: --FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1093: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1094: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Attribute Datatype ');
1095: OE_MSG_PUB.Add;
1096: END IF;
1097: RAISE FND_API.G_EXC_ERROR;
1098:
1099: End If;

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

1111: IF l_error_code <> 0 THEN
1112:
1113: l_return_status := FND_API.G_RET_STS_ERROR;
1114:
1115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1116: THEN
1117: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
1119: OE_MSG_PUB.Add;

Line 1119: OE_MSG_PUB.Add;

1115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1116: THEN
1117: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value From ');
1119: OE_MSG_PUB.Add;
1120: END IF;
1121: RAISE FND_API.G_EXC_ERROR;
1122:
1123: END IF;

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

1134: p_Pricing_Attr_rec.pricing_attr_value_from IS NULL)
1135: THEN
1136: l_return_status := FND_API.G_RET_STS_ERROR;
1137:
1138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1139: THEN
1140: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
1142: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413

Line 1143: OE_MSG_PUB.Add;

1139: THEN
1140: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED' );
1141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_TO')||'/'||
1142: QP_PRC_UTIL.Get_Attribute_Name('PRICING_ATTR_VALUE_FROM')); --Fix For Bug-1974413
1143: OE_MSG_PUB.Add;
1144: END IF;
1145: RAISE FND_API.G_EXC_ERROR;
1146: END IF;
1147:

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

1149:
1150: IF l_error_code <> 0 THEN
1151: l_return_status := FND_API.G_RET_STS_ERROR;
1152:
1153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1154: THEN
1155: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
1157: OE_MSG_PUB.Add;

Line 1157: OE_MSG_PUB.Add;

1153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1154: THEN
1155: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
1156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Value To ');
1157: OE_MSG_PUB.Add;
1158: END IF;
1159: RAISE FND_API.G_EXC_ERROR;
1160: END IF;
1161:

Line 1266: OE_MSG_PUB.Add;

1262: FND_MESSAGE.SET_TOKEN('CONTEXT',
1263: p_Pricing_Attr_rec.pricing_attribute_context);
1264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1265: p_Pricing_Attr_rec.pricing_attribute);
1266: OE_MSG_PUB.Add;
1267:
1268: END IF;
1269:
1270: IF l_sourcing_status <> 'Y' THEN

Line 1277: OE_MSG_PUB.Add;

1273: FND_MESSAGE.SET_TOKEN('CONTEXT',
1274: p_Pricing_Attr_rec.pricing_attribute_context);
1275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1276: p_Pricing_Attr_rec.pricing_attribute);
1277: OE_MSG_PUB.Add;
1278:
1279: END IF;
1280:
1281: END IF; --If sourcing_method = 'ATTRIBUTE MAPPING'

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

1307: WHEN OTHERS THEN
1308:
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310:
1311: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1312: THEN
1313: oe_msg_pub.Add_Exc_Msg
1314: ( G_PKG_NAME
1315: , 'Entity'

Line 1313: oe_msg_pub.Add_Exc_Msg

1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310:
1311: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1312: THEN
1313: oe_msg_pub.Add_Exc_Msg
1314: ( G_PKG_NAME
1315: , 'Entity'
1316: );
1317: END IF;

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

1760: WHEN OTHERS THEN
1761:
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1763:
1764: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1765: THEN
1766: oe_msg_pub.Add_Exc_Msg
1767: ( G_PKG_NAME
1768: , 'Attributes'

Line 1766: oe_msg_pub.Add_Exc_Msg

1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1763:
1764: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1765: THEN
1766: oe_msg_pub.Add_Exc_Msg
1767: ( G_PKG_NAME
1768: , 'Attributes'
1769: );
1770: END IF;

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

1802: WHEN OTHERS THEN
1803:
1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1805:
1806: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1807: THEN
1808: oe_msg_pub.Add_Exc_Msg
1809: ( G_PKG_NAME
1810: , 'Entity_Delete'

Line 1808: oe_msg_pub.Add_Exc_Msg

1804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1805:
1806: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1807: THEN
1808: oe_msg_pub.Add_Exc_Msg
1809: ( G_PKG_NAME
1810: , 'Entity_Delete'
1811: );
1812: END IF;