DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on FND_MESSAGE

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

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');
67: oe_msg_pub.Add;
68:
69: END IF;

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

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');
67: oe_msg_pub.Add;
68:
69: END IF;
70:

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

79: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE_CONTEXT,'X')
80: THEN
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;

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

80: THEN
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:

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

90: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE,'X')
91: THEN
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;

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

91: THEN
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:

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

101: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTR_VALUE,9999999)
102: THEN
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;

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

102: THEN
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:

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

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

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

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;
124: END IF;
125: END IF;
126:

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

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

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

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;
136: END IF;
137: END IF;
138: */

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

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

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

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;
148: END IF;
149: END IF;
150:

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

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;
160: END IF;
161: ELSE

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

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;
160: END IF;
161: ELSE
162:

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

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

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

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;
171: END IF;
172: END IF;
173: END IF;

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

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

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

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;
184: END IF;
185: END IF;
186:

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

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

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

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;
196: END IF;
197: END IF;
198:

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

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

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

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;
208: END IF;
209: END IF;
210:

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

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

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

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;
220: END IF;
221: END IF;
222:

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

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

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

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;
232: END IF;
233: END IF;
234:

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

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

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

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;
244: END IF;
245: END IF;
246:

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

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);
292: FND_MESSAGE.set_token('SS', l_ss_code);
293: OE_MSG_PUB.Add;

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

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);
292: FND_MESSAGE.set_token('SS', l_ss_code);
293: OE_MSG_PUB.Add;
294: END IF;

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

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);
292: FND_MESSAGE.set_token('SS', l_ss_code);
293: OE_MSG_PUB.Add;
294: END IF;
295:

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

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

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

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

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

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;
434: END IF;
435: RAISE FND_API.G_EXC_ERROR;

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

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;
434: END IF;
435: RAISE FND_API.G_EXC_ERROR;
436:

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

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;
463: RAISE FND_API.G_EXC_ERROR;
464:

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

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

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

559: and rownum = 1;
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;

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

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;
583: RAISE FND_API.G_EXC_ERROR;
584:

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

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

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

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;
653: end if;
654: end if;
655:

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

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')||'/'||
704: QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
705: OE_MSG_PUB.Add;

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

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')||'/'||
704: QP_PRC_UTIL.Get_Attribute_Name('COMPARISON_OPERATOR_CODE')); -- Fix For Bug-1974413
705: OE_MSG_PUB.Add;
706: END IF;

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

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;
719: END IF;
720: RAISE FND_API.G_EXC_ERROR;

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

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;
719: END IF;
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;

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

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

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

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

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

741: THEN
742:
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:

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

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');
770: OE_MSG_PUB.Add;
771: END IF;
772:

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

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');
770: OE_MSG_PUB.Add;
771: END IF;
772:
773: RAISE FND_API.G_EXC_ERROR;

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

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 ');
796: --OE_MSG_PUB.Add;
797: OE_MSG_PUB.Add;
798: END IF;

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

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 ');
796: --OE_MSG_PUB.Add;
797: OE_MSG_PUB.Add;
798: END IF;
799: RAISE FND_API.G_EXC_ERROR;

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

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 ');
821: OE_MSG_PUB.Add;
822: END IF;

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

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 ');
821: OE_MSG_PUB.Add;
822: END IF;
823: RAISE FND_API.G_EXC_ERROR;

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

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 ');
821: OE_MSG_PUB.Add;
822: END IF;
823: RAISE FND_API.G_EXC_ERROR;
824:

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

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

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

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;
838: END IF;
839:
840: RAISE FND_API.G_EXC_ERROR;

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

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;
862: END IF;
863: RAISE FND_API.G_EXC_ERROR;

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

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;
862: END IF;
863: RAISE FND_API.G_EXC_ERROR;
864:

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

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
885: OE_MSG_PUB.Add;
886: END IF;

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

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
885: OE_MSG_PUB.Add;
886: END IF;
887: RAISE FND_API.G_EXC_ERROR;

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

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;
904: END IF;
905: RAISE FND_API.G_EXC_ERROR;

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

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;
904: END IF;
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;

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

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;
922: END IF;
923: RAISE FND_API.G_EXC_ERROR;

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

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;
922: END IF;
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;

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

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

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

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

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

941: THEN
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;

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

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

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

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

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

965: THEN
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;

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

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

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

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

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

1016: THEN
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;

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

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');
1044: OE_MSG_PUB.Add;
1045: END IF;
1046:

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

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');
1044: OE_MSG_PUB.Add;
1045: END IF;
1046:
1047: RAISE FND_API.G_EXC_ERROR;

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

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 ');
1070: --OE_MSG_PUB.Add;
1071: OE_MSG_PUB.Add;
1072: END IF;

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

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 ');
1070: --OE_MSG_PUB.Add;
1071: OE_MSG_PUB.Add;
1072: END IF;
1073: RAISE FND_API.G_EXC_ERROR;

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

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 ');
1095: OE_MSG_PUB.Add;
1096: END IF;

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

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 ');
1095: OE_MSG_PUB.Add;
1096: END IF;
1097: RAISE FND_API.G_EXC_ERROR;

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

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 ');
1095: OE_MSG_PUB.Add;
1096: END IF;
1097: RAISE FND_API.G_EXC_ERROR;
1098:

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

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;
1120: END IF;
1121: RAISE FND_API.G_EXC_ERROR;

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

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;
1120: END IF;
1121: RAISE FND_API.G_EXC_ERROR;
1122:

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

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
1143: OE_MSG_PUB.Add;
1144: END IF;

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

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
1143: OE_MSG_PUB.Add;
1144: END IF;
1145: RAISE FND_API.G_EXC_ERROR;

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

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;
1158: END IF;
1159: RAISE FND_API.G_EXC_ERROR;

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

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;
1158: END IF;
1159: RAISE FND_API.G_EXC_ERROR;
1160: END IF;

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

1257: IF l_sourcing_method = 'ATTRIBUTE MAPPING' THEN
1258:
1259: IF l_sourcing_enabled <> 'Y' THEN
1260:
1261: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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);

Line 1262: FND_MESSAGE.SET_TOKEN('CONTEXT',

1258:
1259: IF l_sourcing_enabled <> 'Y' THEN
1260:
1261: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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;

Line 1264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1260:
1261: FND_MESSAGE.SET_NAME('QP','QP_ENABLE_SOURCING');
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;

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

1268: END IF;
1269:
1270: IF l_sourcing_status <> 'Y' THEN
1271:
1272: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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);

Line 1273: FND_MESSAGE.SET_TOKEN('CONTEXT',

1269:
1270: IF l_sourcing_status <> 'Y' THEN
1271:
1272: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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;

Line 1275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1271:
1272: FND_MESSAGE.SET_NAME('QP','QP_BUILD_SOURCING_RULES');
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;