eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_VALIDATE_PRICE_LIST_LINE dependencies on OE_MSG_PUB

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

28: THEN
29:
30: l_return_status := FND_API.G_RET_STS_ERROR;
31:
32: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
33: THEN
34:
35: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
36: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');

Line 37: oe_msg_pub.Add;

33: THEN
34:
35: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
36: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');
37: oe_msg_pub.Add;
38:
39: END IF;
40:
41: END IF;

Line 71: Oe_Msg_Pub.ADD;

67: IF (p_PRICE_LIST_LINE_rec.start_date_active IS NULL OR p_PRICE_LIST_LINE_rec.start_date_active=Fnd_Api.G_MISS_DATE)
68: AND (l_hdr_start_date IS NOT NULL AND l_hdr_start_date <> Fnd_Api.G_MISS_DATE) THEN
69: l_return_status := Fnd_Api.G_RET_STS_ERROR;
70: Fnd_Message.SET_NAME('QP', 'QP_PLL_START_DATE_NOT_WITHIN');
71: Oe_Msg_Pub.ADD;
72: RAISE Fnd_Api.G_EXC_ERROR;
73: END IF;
74: */
75: IF (p_PRICE_LIST_LINE_rec.start_date_active IS NOT NULL AND p_PRICE_LIST_LINE_rec.start_date_active <> Fnd_Api.G_MISS_DATE)

Line 82: Oe_Msg_Pub.ADD;

78: IF (l_hdr_end_date IS NULL OR l_hdr_end_date = Fnd_Api.G_MISS_DATE) THEN -- Hdr end date is null
79: IF (p_PRICE_LIST_LINE_rec.start_date_active < l_hdr_start_date) THEN
80: l_return_status := Fnd_Api.G_RET_STS_ERROR;
81: Fnd_Message.SET_NAME('QP', 'QP_PLL_START_DATE_NOT_WITHIN');
82: Oe_Msg_Pub.ADD;
83: RAISE Fnd_Api.G_EXC_ERROR;
84: END IF;
85: ELSE -- PLH end date not null
86: IF ((p_PRICE_LIST_LINE_rec.start_date_active < l_hdr_start_date) OR

Line 90: Oe_Msg_Pub.ADD;

86: IF ((p_PRICE_LIST_LINE_rec.start_date_active < l_hdr_start_date) OR
87: (p_PRICE_LIST_LINE_rec.start_date_active > l_hdr_end_date)) THEN
88: l_return_status := Fnd_Api.G_RET_STS_ERROR;
89: Fnd_Message.SET_NAME('QP', 'QP_PLL_START_DATE_NOT_WITHIN');
90: Oe_Msg_Pub.ADD;
91: RAISE Fnd_Api.G_EXC_ERROR;
92:
93: END IF;
94: END IF; -- IF (l_hdr_end_date IS NULL OR...

Line 104: Oe_Msg_Pub.ADD;

100: IF (p_PRICE_LIST_LINE_rec.end_date_active IS NULL OR p_PRICE_LIST_LINE_rec.end_date_active = Fnd_Api.G_MISS_DATE)
101: AND (l_hdr_end_date IS NOT NULL AND l_hdr_end_date <> Fnd_Api.G_MISS_DATE) THEN
102: l_return_status := Fnd_Api.G_RET_STS_ERROR;
103: Fnd_Message.SET_NAME('QP', 'QP_PLL_END_DATE_NOT_WITHIN');
104: Oe_Msg_Pub.ADD;
105: RAISE Fnd_Api.G_EXC_ERROR;
106: END IF;
107: */
108: IF (p_PRICE_LIST_LINE_rec.end_date_active IS NOT NULL AND p_PRICE_LIST_LINE_rec.end_date_active <> Fnd_Api.G_MISS_DATE)

Line 114: Oe_Msg_Pub.ADD;

110: IF ((p_PRICE_LIST_LINE_rec.end_date_active < l_hdr_start_date) OR
111: (p_PRICE_LIST_LINE_rec.end_date_active > l_hdr_end_date)) THEN
112: l_return_status := Fnd_Api.G_RET_STS_ERROR;
113: Fnd_Message.SET_NAME('QP', 'QP_PLL_END_DATE_NOT_WITHIN');
114: Oe_Msg_Pub.ADD;
115: RAISE Fnd_Api.G_EXC_ERROR;
116: END IF;
117: END IF; -- end PLL end date not null and PLH end date not null
118: -- end bug 5040708

Line 132: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN

128: AND arithmetic_operator = 'BLOCK_PRICE';
129:
130: -- if any price breaks are BLOCK, prohibit changing parent line from BLOCK to UNIT!
131: IF (TO_NUMBER(l_dummy_1) > 0) THEN
132: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_CHANGE_APPL_METH');
134: oe_msg_pub.Add;
135: END IF;
136: l_return_status := FND_API.G_RET_STS_ERROR;

Line 134: oe_msg_pub.Add;

130: -- if any price breaks are BLOCK, prohibit changing parent line from BLOCK to UNIT!
131: IF (TO_NUMBER(l_dummy_1) > 0) THEN
132: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_CHANGE_APPL_METH');
134: oe_msg_pub.Add;
135: END IF;
136: l_return_status := FND_API.G_RET_STS_ERROR;
137: END IF; -- if (to_number...)
138: END IF; -- if (p_price_list_line...)

Line 154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN

150: AND (arithmetic_operator = 'UNIT_PRICE' OR recurring_value IS NOT NULL);
151:
152: -- if any price breaks found, prohibit changing parent line from RANGE to POINT!
153: IF (TO_NUMBER(l_dummy_1) > 0) THEN
154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
155: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_CHANGE_BREAK_TYPE');
156: oe_msg_pub.Add;
157: END IF;
158: l_return_status := FND_API.G_RET_STS_ERROR;

Line 156: oe_msg_pub.Add;

152: -- if any price breaks found, prohibit changing parent line from RANGE to POINT!
153: IF (TO_NUMBER(l_dummy_1) > 0) THEN
154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
155: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_CHANGE_BREAK_TYPE');
156: oe_msg_pub.Add;
157: END IF;
158: l_return_status := FND_API.G_RET_STS_ERROR;
159: END IF; -- if (to_number...)
160: END IF; -- if (p_price_list_line...)

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

174: l_return_status := FND_API.G_RET_STS_ERROR;
175:
176: /*
177:
178: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
179: THEN
180:
181: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');

Line 183: oe_msg_pub.Add;

179: THEN
180:
181: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');
183: oe_msg_pub.Add;
184:
185: END IF;
186: */
187:

Line 215: OE_MSG_PUB.Add;

211: EXCEPTION
212: WHEN NO_DATA_FOUND THEN
213: l_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');
215: OE_MSG_PUB.Add;
216: END;
217:
218: END IF;
219:

Line 239: OE_MSG_PUB.Add;

235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: l_return_status := FND_API.G_RET_STS_ERROR;
238: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');
239: OE_MSG_PUB.Add;
240: END;
241: END IF;
242:
243:

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

251: THEN
252:
253: l_return_status := FND_API.G_RET_STS_ERROR;
254: if p_PRICE_LIST_LINE_rec.arithmetic_operator = 'UNIT_PRICE' then -- Added by DKC for ER # 6111123
255: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
256: THEN
257:
258: FND_MESSAGE.SET_NAME('QP','QP_OPERAND_FORMULA');
259: oe_msg_pub.Add;

Line 259: oe_msg_pub.Add;

255: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
256: THEN
257:
258: FND_MESSAGE.SET_NAME('QP','QP_OPERAND_FORMULA');
259: oe_msg_pub.Add;
260: l_return_status := FND_API.G_RET_STS_ERROR;
261:
262: END IF;
263: else --- This validation works only for only PRICE breaks lines as the arithmetic operator couldnt be block price for PLL. changes for ER # 6111123

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

260: l_return_status := FND_API.G_RET_STS_ERROR;
261:
262: END IF;
263: else --- This validation works only for only PRICE breaks lines as the arithmetic operator couldnt be block price for PLL. changes for ER # 6111123
264: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
265: THEN
266: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
267: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Price');
268: oe_msg_pub.Add;

Line 268: oe_msg_pub.Add;

264: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
265: THEN
266: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
267: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Price');
268: oe_msg_pub.Add;
269: l_return_status := FND_API.G_RET_STS_ERROR;
270: END IF;
271: end if;
272: -- end of changes for ER # 6111123

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

276: IF NOT QP_Validate.Recurring_Value(p_PRICE_LIST_LINE_rec.recurring_value)
277: THEN
278: l_return_status := FND_API.G_RET_STS_ERROR;
279:
280: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.SET_NAME('QP','QP_INVALID_RECURRING_VALUE');
283: oe_msg_pub.Add;
284: END IF;

Line 283: oe_msg_pub.Add;

279:
280: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.SET_NAME('QP','QP_INVALID_RECURRING_VALUE');
283: oe_msg_pub.Add;
284: END IF;
285: END IF;
286:
287: -- OKS proration

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

296: THEN
297:
298: l_return_status := FND_API.G_RET_STS_ERROR;
299:
300: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
301: THEN
302:
303: FND_MESSAGE.SET_NAME('QP','QP_BREAK_UOM_NOT_ALLOWED');
304: oe_msg_pub.Add;

Line 304: oe_msg_pub.Add;

300: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
301: THEN
302:
303: FND_MESSAGE.SET_NAME('QP','QP_BREAK_UOM_NOT_ALLOWED');
304: oe_msg_pub.Add;
305: l_return_status := FND_API.G_RET_STS_ERROR;
306: END IF;
307:
308: END IF;

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

318: OR p_PRICE_LIST_LINE_rec.break_uom_attribute is null
319: THEN
320: l_return_status := FND_API.G_RET_STS_ERROR;
321:
322: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
323: THEN
324: FND_MESSAGE.SET_NAME('QP','QP_BREAK_UOM_FLDS_NOT_ALLOWED');
325: oe_msg_pub.Add;
326: l_return_status := FND_API.G_RET_STS_ERROR;

Line 325: oe_msg_pub.Add;

321:
322: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
323: THEN
324: FND_MESSAGE.SET_NAME('QP','QP_BREAK_UOM_FLDS_NOT_ALLOWED');
325: oe_msg_pub.Add;
326: l_return_status := FND_API.G_RET_STS_ERROR;
327: END IF;
328:
329: END IF;

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

339: Exception
340: when no_data_found then
341: l_return_status := FND_API.G_RET_STS_ERROR;
342:
343: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
344: THEN
345: FND_MESSAGE.SET_NAME('QP','QP_INVALID_BREAK_UOM_CODE');
346: oe_msg_pub.Add;
347: l_return_status := FND_API.G_RET_STS_ERROR;

Line 346: oe_msg_pub.Add;

342:
343: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
344: THEN
345: FND_MESSAGE.SET_NAME('QP','QP_INVALID_BREAK_UOM_CODE');
346: oe_msg_pub.Add;
347: l_return_status := FND_API.G_RET_STS_ERROR;
348: END IF;
349: END;
350: END IF;

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

372: WHEN OTHERS THEN
373:
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375:
376: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
377: THEN
378: oe_msg_pub.Add_Exc_Msg
379: ( G_PKG_NAME
380: , 'Entity'

Line 378: oe_msg_pub.Add_Exc_Msg

374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375:
376: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
377: THEN
378: oe_msg_pub.Add_Exc_Msg
379: ( G_PKG_NAME
380: , 'Entity'
381: );
382: END IF;

Line 431: OE_MSG_PUB.Add;

427: /* changes to fix bug # 1688666 */
428:
429: IF FND_PROFILE.VALUE('QP_NEGATIVE_PRICING') = 'N' AND p_PRICE_LIST_LINE_rec.operand < 0 THEN
430: FND_MESSAGE.SET_NAME('QP','SO_PR_NEGATIVE_LIST_PRICE');
431: OE_MSG_PUB.Add;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: END IF;
434:
435:

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

1131: WHEN OTHERS THEN
1132:
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134:
1135: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1136: THEN
1137: oe_msg_pub.Add_Exc_Msg
1138: ( G_PKG_NAME
1139: , 'Attributes'

Line 1137: oe_msg_pub.Add_Exc_Msg

1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134:
1135: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1136: THEN
1137: oe_msg_pub.Add_Exc_Msg
1138: ( G_PKG_NAME
1139: , 'Attributes'
1140: );
1141: END IF;

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

1173: WHEN OTHERS THEN
1174:
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176:
1177: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1178: THEN
1179: oe_msg_pub.Add_Exc_Msg
1180: ( G_PKG_NAME
1181: , 'Entity_Delete'

Line 1179: oe_msg_pub.Add_Exc_Msg

1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176:
1177: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1178: THEN
1179: oe_msg_pub.Add_Exc_Msg
1180: ( G_PKG_NAME
1181: , 'Entity_Delete'
1182: );
1183: END IF;