41:
42: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
43: THEN
44:
45: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
46: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');
47: OE_MSG_PUB.Add;
48:
49: END IF;
42: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
43: THEN
44:
45: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
46: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Header Id');
47: OE_MSG_PUB.Add;
48:
49: END IF;
50:
63: THEN
64:
65: l_return_status := FND_API.G_RET_STS_ERROR;
66:
67: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_LIST_TYPE');
68: OE_MSG_PUB.Add;
69:
70: END IF;
71:
74: THEN
75:
76: l_return_status := FND_API.G_RET_STS_ERROR;
77:
78: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
79: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Source Code');
80: OE_MSG_PUB.Add;
81:
82: END IF;
75:
76: l_return_status := FND_API.G_RET_STS_ERROR;
77:
78: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
79: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','List Source Code');
80: OE_MSG_PUB.Add;
81:
82: END IF;
83:
87: THEN
88:
89: l_return_status := FND_API.G_RET_STS_ERROR;
90:
91: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Shareable Flag');
93: OE_MSG_PUB.Add;
94:
95: END IF;
88:
89: l_return_status := FND_API.G_RET_STS_ERROR;
90:
91: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Shareable Flag');
93: OE_MSG_PUB.Add;
94:
95: END IF;
96:
100: THEN
101:
102: l_return_status := FND_API.G_RET_STS_ERROR;
103:
104: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Parent List Header Id');
106: OE_MSG_PUB.Add;
107:
108: END IF;
101:
102: l_return_status := FND_API.G_RET_STS_ERROR;
103:
104: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Parent List Header Id');
106: OE_MSG_PUB.Add;
107:
108: END IF;
109:
112: THEN
113:
114: l_return_status := FND_API.G_RET_STS_ERROR;
115:
116: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source System Code');
118: OE_MSG_PUB.Add;
119:
120: END IF;
113:
114: l_return_status := FND_API.G_RET_STS_ERROR;
115:
116: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source System Code');
118: OE_MSG_PUB.Add;
119:
120: END IF;
121:
124: THEN
125:
126: l_return_status := FND_API.G_RET_STS_ERROR;
127:
128: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Transaction Entity Code');
130: OE_MSG_PUB.Add;
131:
132: END IF;
125:
126: l_return_status := FND_API.G_RET_STS_ERROR;
127:
128: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
129: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Pricing Transaction Entity Code');
130: OE_MSG_PUB.Add;
131:
132: END IF;
133:
136: THEN
137:
138: l_return_status := FND_API.G_RET_STS_ERROR;
139:
140: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ask For Flag');
142: OE_MSG_PUB.Add;
143:
144: END IF; Bug 5503831 */
137:
138: l_return_status := FND_API.G_RET_STS_ERROR;
139:
140: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ask For Flag');
142: OE_MSG_PUB.Add;
143:
144: END IF; Bug 5503831 */
145:
151: THEN
152:
153: l_return_status := FND_API.G_RET_STS_ERROR;
154:
155: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_NUMBER');
156: OE_MSG_PUB.Add;
157:
158: END IF;
159:
163: THEN
164:
165: l_return_status := FND_API.G_RET_STS_ERROR;
166:
167: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_NAME');
168: OE_MSG_PUB.Add;
169:
170: END IF;
171: */
181: THEN
182: l_return_status := FND_API.G_RET_STS_ERROR;
183:
184: oe_debug_pub.add('list type code is mandatory');
185: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_TYPE_CODE')); -- Fix For Bug-1974413
187: OE_MSG_PUB.Add;
188:
189: END IF;
182: l_return_status := FND_API.G_RET_STS_ERROR;
183:
184: oe_debug_pub.add('list type code is mandatory');
185: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_TYPE_CODE')); -- Fix For Bug-1974413
187: OE_MSG_PUB.Add;
188:
189: END IF;
190:
198: THEN
199:
200: oe_debug_pub.add('invalid list type code ');
201: l_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_TYPE');
203: OE_MSG_PUB.Add;
204:
205: END IF;
206: -- For bug 2363065, raise the error in basic pricing if not called from FTE
213: THEN
214:
215: oe_debug_pub.add('invalid list type code ');
216: l_return_status := FND_API.G_RET_STS_ERROR;
217: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_TYPE');
218: OE_MSG_PUB.Add;
219:
220: END IF;
221: END IF;
227: IF p_MODIFIER_LIST_rec.gsa_indicator = 'Y'
228: AND p_MODIFIER_LIST_rec.list_type_code <> 'DLT'
229: THEN
230: l_return_status := FND_API.G_RET_STS_ERROR;
231: FND_MESSAGE.SET_NAME('QP','QP_INVALID_LIST_TYPE');
232: OE_MSG_PUB.Add;
233:
234:
235: END IF;
237: IF p_MODIFIER_LIST_rec.source_system_code IS NULL
238: THEN
239:
240: l_return_status := FND_API.G_RET_STS_ERROR;
241: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('SOURCE_SYSTEM_CODE')); -- Fix For Bug-1974413
243: OE_MSG_PUB.Add;
244:
245: END IF;
238: THEN
239:
240: l_return_status := FND_API.G_RET_STS_ERROR;
241: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('SOURCE_SYSTEM_CODE')); -- Fix For Bug-1974413
243: OE_MSG_PUB.Add;
244:
245: END IF;
246:
249: IF p_MODIFIER_LIST_rec.pte_code IS NULL
250: THEN
251:
252: l_return_status := FND_API.G_RET_STS_ERROR;
253: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PTE_CODE');
255: OE_MSG_PUB.Add;
256:
257: END IF;
250: THEN
251:
252: l_return_status := FND_API.G_RET_STS_ERROR;
253: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PTE_CODE');
255: OE_MSG_PUB.Add;
256:
257: END IF;
258: END IF;
268: l_currency_code := NULL;
269: Else
270: oe_debug_pub.add('currency code is null ');
271: l_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
273: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('CURRENCY_CODE')); -- Fix For Bug-1974413
274: OE_MSG_PUB.Add;
275: End If;
276: ELSE
269: Else
270: oe_debug_pub.add('currency code is null ');
271: l_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
273: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('CURRENCY_CODE')); -- Fix For Bug-1974413
274: OE_MSG_PUB.Add;
275: End If;
276: ELSE
277:
291:
292: WHEN NO_DATA_FOUND THEN
293: l_return_status := FND_API.G_RET_STS_ERROR;
294:
295: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
296: OE_MSG_PUB.Add;
297:
298: END;
299:
306:
307: oe_debug_pub.add('start date after end date');
308: l_return_status := FND_API.G_RET_STS_ERROR;
309:
310: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
311: OE_MSG_PUB.Add;
312:
313: END IF;
314:
318:
319: oe_debug_pub.add('start date after end date');
320: l_return_status := FND_API.G_RET_STS_ERROR;
321:
322: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
323: OE_MSG_PUB.Add;
324:
325: END IF;
326:
330:
331: oe_debug_pub.add('start date after end date');
332: l_return_status := FND_API.G_RET_STS_ERROR;
333:
334: FND_MESSAGE.SET_NAME('QP','QP_STRT_DATE_BFR_END_DATE');
335: OE_MSG_PUB.Add;
336:
337: END IF;
338:
346:
347: oe_debug_pub.add('id deal, list header id is null');
348: l_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MESSAGE.SET_NAME('QP','QP_PARENT_REQUIRED');
351: OE_MSG_PUB.Add;
352:
353: END IF;
354:
360:
361: oe_debug_pub.add('name is null');
362: l_return_status := FND_API.G_RET_STS_ERROR;
363:
364: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('NAME')); -- Fix For Bug-1974413
366: OE_MSG_PUB.Add;
367:
368: END IF;
361: oe_debug_pub.add('name is null');
362: l_return_status := FND_API.G_RET_STS_ERROR;
363:
364: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('NAME')); -- Fix For Bug-1974413
366: OE_MSG_PUB.Add;
367:
368: END IF;
369: END IF;
377:
378: oe_debug_pub.add('name is null');
379: l_return_status := FND_API.G_RET_STS_ERROR;
380:
381: FND_MESSAGE.SET_NAME('QP','QP_DATE_TYPES_MUST_DIFFER');
382: OE_MSG_PUB.Add;
383:
384: END IF;
385: END IF;
394: l_return_status := FND_API.G_RET_STS_ERROR;
395:
396: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
397:
398: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Global_flag');
400: oe_msg_pub.add;
401: END IF;
402: END IF;
395:
396: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
397:
398: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Global_flag');
400: oe_msg_pub.add;
401: END IF;
402: END IF;
403: END IF;
412: IF (l_security_profile = 'N'
413: and p_MODIFIER_LIST_rec.global_flag in ('N', 'n')) THEN
414: l_return_status := FND_API.G_RET_STS_ERROR;
415: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
416: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
418: oe_msg_pub.add;
419: END IF;
420: END IF;
413: and p_MODIFIER_LIST_rec.global_flag in ('N', 'n')) THEN
414: l_return_status := FND_API.G_RET_STS_ERROR;
415: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
416: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
418: oe_msg_pub.add;
419: END IF;
420: END IF;
421:
424: IF (p_MODIFIER_LIST_rec.global_flag in ('N', 'n')
425: and p_MODIFIER_LIST_rec.org_id is null) THEN
426: l_return_status := FND_API.G_RET_STS_ERROR;
427: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
428: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
429: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
430: oe_msg_pub.add;
431: END IF;
432: END IF;
425: and p_MODIFIER_LIST_rec.org_id is null) THEN
426: l_return_status := FND_API.G_RET_STS_ERROR;
427: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
428: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
429: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
430: oe_msg_pub.add;
431: END IF;
432: END IF;
433:
435: IF (p_MODIFIER_LIST_rec.org_id is not null
436: and QP_UTIL.validate_org_id(p_MODIFIER_LIST_rec.org_id) = 'N') THEN
437: l_return_status := FND_API.G_RET_STS_ERROR;
438: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
440: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
441: oe_msg_pub.add;
442: END IF;
443: END IF;
436: and QP_UTIL.validate_org_id(p_MODIFIER_LIST_rec.org_id) = 'N') THEN
437: l_return_status := FND_API.G_RET_STS_ERROR;
438: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
440: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
441: oe_msg_pub.add;
442: END IF;
443: END IF;
444: END IF; --IF l_security_profile = 'Y'
448: and p_MODIFIER_LIST_rec.org_id is not null) OR (p_MODIFIER_LIST_rec.global_flag = 'N' and p_MODIFIER_LIST_rec.org_id is null)) THEN
449: -- and p_MODIFIER_LIST_rec.org_id <> FND_API.G_MISS_NUM THEN
450: l_return_status := FND_API.G_RET_STS_ERROR;
451: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
452: FND_MESSAGE.SET_NAME('QP', 'QP_GLOBAL_OR_ORG');
453: oe_msg_pub.add;
454: END IF;
455: END IF;--p_header_rec.global_flag
456: END IF;