DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICE_LIST_LINE dependencies on FND_MESSAGE

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

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');
37: oe_msg_pub.Add;
38:
39: END IF;

Line 36: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');

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');
37: oe_msg_pub.Add;
38:
39: END IF;
40:

Line 70: Fnd_Message.SET_NAME('QP', 'QP_PLL_START_DATE_NOT_WITHIN');

66: /* bug 5111502
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: */

Line 81: Fnd_Message.SET_NAME('QP', 'QP_PLL_START_DATE_NOT_WITHIN');

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

Line 89: Fnd_Message.SET_NAME('QP', 'QP_PLL_START_DATE_NOT_WITHIN');

85: ELSE -- PLH end date not null
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;

Line 103: Fnd_Message.SET_NAME('QP', 'QP_PLL_END_DATE_NOT_WITHIN');

99: /* bug 5111502
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: */

Line 113: Fnd_Message.SET_NAME('QP', 'QP_PLL_END_DATE_NOT_WITHIN');

109: AND (l_hdr_end_date IS NOT NULL AND l_hdr_end_date <> Fnd_Api.G_MISS_DATE) THEN
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

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

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;
137: END IF; -- if (to_number...)

Line 155: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_CHANGE_BREAK_TYPE');

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;
159: END IF; -- if (to_number...)

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

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');
183: oe_msg_pub.Add;
184:
185: END IF;

Line 182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');

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');
183: oe_msg_pub.Add;
184:
185: END IF;
186: */

Line 214: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');

210: and price_formula_line_type_code = 'MV' );
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;

Line 238: FND_MESSAGE.SET_NAME('QP','QP_INVALID_FORMULA_FOR_PL');

234: and price_formula_line_type_code = 'MV' );
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:

Line 258: FND_MESSAGE.SET_NAME('QP','QP_OPERAND_FORMULA');

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;
260: l_return_status := FND_API.G_RET_STS_ERROR;
261:
262: END IF;

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

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;
269: l_return_status := FND_API.G_RET_STS_ERROR;
270: END IF;

Line 267: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Price');

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;
269: l_return_status := FND_API.G_RET_STS_ERROR;
270: END IF;
271: end if;

Line 282: FND_MESSAGE.SET_NAME('QP','QP_INVALID_RECURRING_VALUE');

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

Line 303: FND_MESSAGE.SET_NAME('QP','QP_BREAK_UOM_NOT_ALLOWED');

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;
305: l_return_status := FND_API.G_RET_STS_ERROR;
306: END IF;
307:

Line 324: FND_MESSAGE.SET_NAME('QP','QP_BREAK_UOM_FLDS_NOT_ALLOWED');

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

Line 345: FND_MESSAGE.SET_NAME('QP','QP_INVALID_BREAK_UOM_CODE');

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

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

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