DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICE_LIST dependencies on FND_MESSAGE

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

39:
40: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
41: THEN
42:
43: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
44: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header_id');
45: oe_msg_pub.Add;
46:
47: END IF;

Line 44: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header_id');

40: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
41: THEN
42:
43: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
44: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header_id');
45: oe_msg_pub.Add;
46:
47: END IF;
48:

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

55: nvl(p_PRICE_LIST_rec.shareable_flag,'X')
56: THEN
57: l_return_status := FND_API.G_RET_STS_ERROR;
58:
59: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
60: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shareable_flag');
61: OE_MSG_PUB.Add;
62:
63: END IF;

Line 60: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shareable_flag');

56: THEN
57: l_return_status := FND_API.G_RET_STS_ERROR;
58:
59: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
60: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shareable_flag');
61: OE_MSG_PUB.Add;
62:
63: END IF;
64:

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

66: nvl(p_PRICE_LIST_rec.list_source_code,'X')
67: THEN
68: l_return_status := FND_API.G_RET_STS_ERROR;
69:
70: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
71: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_source_code');
72: OE_MSG_PUB.Add;
73:
74: END IF;

Line 71: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_source_code');

67: THEN
68: l_return_status := FND_API.G_RET_STS_ERROR;
69:
70: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
71: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_source_code');
72: OE_MSG_PUB.Add;
73:
74: END IF;
75:

Line 86: FND_MESSAGE.SET_NAME('QP', 'QP_ROUNDING_FACTOR_NO_UPDATE');

82:
83: IF l_unit_precision_type = 'STANDARD' THEN
84: IF l_price_rounding = 'PRECISION' THEN
85: l_return_status := FND_API.G_RET_STS_ERROR;
86: FND_MESSAGE.SET_NAME('QP', 'QP_ROUNDING_FACTOR_NO_UPDATE');
87: OE_MSG_PUB.Add;
88: END IF;
89: END IF;
90: END IF;

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

93: nvl(p_PRICE_LIST_rec.pte_code,'X')
94: THEN
95: l_return_status := FND_API.G_RET_STS_ERROR;
96:
97: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_code');
99: OE_MSG_PUB.Add;
100:
101: END IF;

Line 98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_code');

94: THEN
95: l_return_status := FND_API.G_RET_STS_ERROR;
96:
97: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_code');
99: OE_MSG_PUB.Add;
100:
101: END IF;
102:

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

104: nvl(p_PRICE_LIST_rec.source_system_code,'X')
105: THEN
106: l_return_status := FND_API.G_RET_STS_ERROR;
107:
108: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
109: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','source_system_code');
110: OE_MSG_PUB.Add;
111:
112: END IF;

Line 109: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','source_system_code');

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

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

115: nvl(p_PRICE_LIST_rec.sold_to_org_id,9999999)
116: THEN
117: l_return_status := FND_API.G_RET_STS_ERROR;
118:
119: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
120: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
121: OE_MSG_PUB.Add;
122:
123: END IF;

Line 120: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');

116: THEN
117: l_return_status := FND_API.G_RET_STS_ERROR;
118:
119: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
120: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
121: OE_MSG_PUB.Add;
122:
123: END IF;
124:

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

133:
134: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
135: THEN
136:
137: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
138: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_TYPE_CODE')); -- Fix For Bug-1974413
139: oe_msg_pub.Add;
140:
141: END IF;

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

134: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
135: THEN
136:
137: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
138: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_TYPE_CODE')); -- Fix For Bug-1974413
139: oe_msg_pub.Add;
140:
141: END IF;
142:

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

150:
151: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
152: THEN
153:
154: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
155: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('CURRENCY_CODE')); -- Fix For Bug-1974413
156: oe_msg_pub.Add;
157:
158: END IF;

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

151: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
152: THEN
153:
154: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
155: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('CURRENCY_CODE')); -- Fix For Bug-1974413
156: oe_msg_pub.Add;
157:
158: END IF;
159:

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

164: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND
165: ( p_PRICE_LIST_rec.currency_code <>
166: p_old_PRICE_LIST_rec.currency_code )
167: THEN
168: FND_MESSAGE.SET_NAME('QP','QP_CHANGE_SEC_PRL_CURR');
169: OE_MSG_PUB.Add;
170: END IF;
171:
172: -- Bug 2347427 end

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

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

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

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

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

217:
218: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
219: THEN
220:
221: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
223: oe_msg_pub.Add;
224:
225: END IF;

Line 222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

218: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
219: THEN
220:
221: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
223: oe_msg_pub.Add;
224:
225: END IF;
226:

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

237:
238: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
239: THEN
240:
241: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','active_flag');
243: oe_msg_pub.add;
244: END IF;
245: END IF;

Line 242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','active_flag');

238: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
239: THEN
240:
241: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','active_flag');
243: oe_msg_pub.add;
244: END IF;
245: END IF;
246: END IF;

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

254: l_return_status := FND_API.G_RET_STS_ERROR;
255:
256: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
257:
258: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','mobile_download');
260: oe_msg_pub.add;
261: END IF;
262: END IF;

Line 259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','mobile_download');

255:
256: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
257:
258: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','mobile_download');
260: oe_msg_pub.add;
261: END IF;
262: END IF;
263: END IF;

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

270:
271: l_return_status := FND_API.G_RET_STS_ERROR;
272: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
273:
274: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Global_flag');
276: oe_msg_pub.add;
277: END IF;
278: END IF;

Line 275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Global_flag');

271: l_return_status := FND_API.G_RET_STS_ERROR;
272: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
273:
274: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
275: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Global_flag');
276: oe_msg_pub.add;
277: END IF;
278: END IF;
279: END IF;

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

288: IF (l_security_profile = 'N'
289: and p_PRICE_LIST_rec.global_flag in ('N', 'n')) THEN
290: l_return_status := FND_API.G_RET_STS_ERROR;
291: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
292: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
293: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
294: oe_msg_pub.add;
295: END IF;
296: END IF;

Line 293: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');

289: and p_PRICE_LIST_rec.global_flag in ('N', 'n')) THEN
290: l_return_status := FND_API.G_RET_STS_ERROR;
291: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
292: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
293: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
294: oe_msg_pub.add;
295: END IF;
296: END IF;
297:

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

300: IF (p_PRICE_LIST_rec.global_flag in ('N', 'n')
301: and p_PRICE_LIST_rec.org_id is null) THEN
302: l_return_status := FND_API.G_RET_STS_ERROR;
303: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
304: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
306: oe_msg_pub.add;
307: END IF;
308: END IF;

Line 305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');

301: and p_PRICE_LIST_rec.org_id is null) THEN
302: l_return_status := FND_API.G_RET_STS_ERROR;
303: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
304: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
306: oe_msg_pub.add;
307: END IF;
308: END IF;
309:

Line 315: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');

311: IF (p_PRICE_LIST_rec.org_id is not null
312: and QP_UTIL.validate_org_id(p_PRICE_LIST_rec.org_id) = 'N') THEN
313: l_return_status := FND_API.G_RET_STS_ERROR;
314: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
315: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
316: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
317: oe_msg_pub.add;
318: END IF;
319: END IF;

Line 316: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');

312: and QP_UTIL.validate_org_id(p_PRICE_LIST_rec.org_id) = 'N') THEN
313: l_return_status := FND_API.G_RET_STS_ERROR;
314: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
315: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
316: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
317: oe_msg_pub.add;
318: END IF;
319: END IF;
320: END IF;--IF l_security_profile = 'Y'

Line 328: FND_MESSAGE.SET_NAME('QP', 'QP_GLOBAL_OR_ORG');

324: and p_PRICE_LIST_rec.org_id is not null) OR (p_PRICE_LIST_rec.global_flag ='N' and p_PRICE_LIST_rec.org_id is null)) THEN
325: -- and p_MODIFIER_LIST_rec.org_id <> FND_API.G_MISS_NUM THEN
326: l_return_status := FND_API.G_RET_STS_ERROR;
327: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
328: FND_MESSAGE.SET_NAME('QP', 'QP_GLOBAL_OR_ORG');
329: oe_msg_pub.add;
330: END IF;
331: END IF;--p_header_rec.global_flag
332: END IF;

Line 350: FND_MESSAGE.SET_NAME('QP','QP_MUL_CURR_REQD');

346: p_PRICE_LIST_rec.currency_header_id = FND_API.G_MISS_NUM )
347: then
348: l_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MESSAGE.SET_NAME('QP','QP_MUL_CURR_REQD');
351: oe_msg_pub.add;
352:
353: end if;
354:

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

357: p_PRICE_LIST_rec.rounding_factor <> FND_API.G_MISS_NUM )
358: then
359: l_return_status := FND_API.G_RET_STS_ERROR;
360:
361: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE'); -- CHANGE
362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rounding_factor');
363: oe_msg_pub.add;
364:
365: end if;

Line 362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rounding_factor');

358: then
359: l_return_status := FND_API.G_RET_STS_ERROR;
360:
361: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE'); -- CHANGE
362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rounding_factor');
363: oe_msg_pub.add;
364:
365: end if;
366: */

Line 375: FND_MESSAGE.SET_NAME('QP','QP_MUL_CURR_NULL');

371: p_old_PRICE_LIST_rec.currency_header_id <> p_PRICE_LIST_rec.currency_header_id)
372: then
373: l_return_status := FND_API.G_RET_STS_ERROR;
374:
375: FND_MESSAGE.SET_NAME('QP','QP_MUL_CURR_NULL');
376: oe_msg_pub.add;
377:
378: end if;
379:

Line 388: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');

384: p_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM )
385: then
386: l_return_status := FND_API.G_RET_STS_ERROR;
387:
388: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');
389: oe_msg_pub.add;
390:
391: end if;
392:

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

402:
403: EXCEPTION
404: WHEN NO_DATA_FOUND THEN
405: l_return_status := FND_API.G_RET_STS_ERROR;
406: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
408: oe_msg_pub.add;
409: END;
410: END IF;

Line 407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');

403: EXCEPTION
404: WHEN NO_DATA_FOUND THEN
405: l_return_status := FND_API.G_RET_STS_ERROR;
406: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
408: oe_msg_pub.add;
409: END;
410: END IF;
411:

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

445:
446: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
447: THEN
448:
449: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');
451: oe_msg_pub.Add;
452:
453: END IF;

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

446: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
447: THEN
448:
449: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');
451: oe_msg_pub.Add;
452:
453: END IF;
454:

Line 464: FND_MESSAGE.SET_NAME('QP','QP_PLL_END_DATE_NOT_WITHIN');

460: and (p_PRICE_LIST_rec.start_date_active is null or p_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE)) THEN
461: FOR l_lines_dates_cur IN c_lines_dates_cur(p_PRICE_LIST_rec.list_header_id) LOOP
462: IF (p_PRICE_LIST_rec.end_date_active < l_lines_dates_cur.end_date_active) THEN -- line date not within hdr date
463: l_return_status := FND_API.G_RET_STS_ERROR;
464: FND_MESSAGE.SET_NAME('QP','QP_PLL_END_DATE_NOT_WITHIN');
465: oe_msg_pub.add;
466: exit;
467: END IF;
468:

Line 471: FND_MESSAGE.SET_NAME('QP','QP_PLL_START_DATE_NOT_WITHIN');

467: END IF;
468:
469: IF (p_PRICE_LIST_rec.start_date_active > l_lines_dates_cur.start_date_active) THEN -- line date not within hdr date
470: l_return_status := FND_API.G_RET_STS_ERROR;
471: FND_MESSAGE.SET_NAME('QP','QP_PLL_START_DATE_NOT_WITHIN');
472: oe_msg_pub.add;
473: exit;
474: END IF;
475: END LOOP;