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_MODIFIER_LIST dependencies on OE_MSG_PUB

Line 42: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

38:
39: oe_debug_pub.add('list header id is mandatory');
40: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 47: OE_MSG_PUB.Add;

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

Line 68: OE_MSG_PUB.Add;

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:
72: IF nvl(p_old_MODIFIER_LIST_rec.list_source_code,'X') <>

Line 80: OE_MSG_PUB.Add;

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

Line 93: OE_MSG_PUB.Add;

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:
97: IF p_old_MODIFIER_LIST_rec.list_type_code NOT IN ('DEL')

Line 106: OE_MSG_PUB.Add;

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:
110: IF nvl(p_old_MODIFIER_LIST_rec.source_system_code,'X') <>

Line 118: OE_MSG_PUB.Add;

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:
122: IF nvl(p_old_MODIFIER_LIST_rec.pte_code,'X') <>

Line 130: OE_MSG_PUB.Add;

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:
134: /* IF nvl(p_old_MODIFIER_LIST_rec.ask_for_flag,'X') <>

Line 142: OE_MSG_PUB.Add;

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:
146: /* Commented for bug2516658

Line 156: OE_MSG_PUB.Add;

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:
160: IF p_old_MODIFIER_LIST_rec.description IS NOT NULL

Line 168: OE_MSG_PUB.Add;

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

Line 187: OE_MSG_PUB.Add;

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:
191: IF ( l_qp_status = 'I' AND

Line 203: OE_MSG_PUB.Add;

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
207: IF p_MODIFIER_LIST_rec.list_type_code <> 'PML' THEN

Line 218: OE_MSG_PUB.Add;

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;
222:

Line 232: OE_MSG_PUB.Add;

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;
236:

Line 243: OE_MSG_PUB.Add;

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:
247: -- Bug 2351145 - pte_code is mandatory only when attribute manager is installed

Line 255: OE_MSG_PUB.Add;

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;
259:

Line 274: OE_MSG_PUB.Add;

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:
278: BEGIN

Line 296: OE_MSG_PUB.Add;

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

Line 311: OE_MSG_PUB.Add;

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:
315: IF nvl( p_MODIFIER_LIST_rec.start_date_active_first,to_date('01/01/1951','mm/dd/yyyy')) >

Line 323: OE_MSG_PUB.Add;

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:
327: IF nvl( p_MODIFIER_LIST_rec.start_date_active_second,to_date('01/01/1951','mm/dd/yyyy')) >

Line 335: OE_MSG_PUB.Add;

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:
339: oe_debug_pub.add('list type code = '||p_MODIFIER_LIST_rec.list_type_code);

Line 351: OE_MSG_PUB.Add;

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:
355: IF p_MODIFIER_LIST_rec.list_type_code <> 'PML' THEN

Line 366: OE_MSG_PUB.Add;

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;
370:

Line 382: OE_MSG_PUB.Add;

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;
386: END IF; --list_type_code is not 'PML'

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

392: IF p_MODIFIER_LIST_rec.global_flag not in ('Y', 'N', 'n') THEN
393:
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;

Line 400: oe_msg_pub.add;

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;
404:

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

412: --if security is OFF, global_flag cannot be 'N'
413: IF (l_security_profile = 'N'
414: and p_MODIFIER_LIST_rec.global_flag in ('N', 'n')) THEN
415: l_return_status := FND_API.G_RET_STS_ERROR;
416: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
419: oe_msg_pub.add;
420: END IF;

Line 419: oe_msg_pub.add;

415: l_return_status := FND_API.G_RET_STS_ERROR;
416: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
419: oe_msg_pub.add;
420: END IF;
421: END IF;
422:
423: IF l_security_profile = 'Y' THEN

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

424: --if security is ON and global_flag is 'N', org_id cannot be null
425: IF (p_MODIFIER_LIST_rec.global_flag in ('N', 'n')
426: and p_MODIFIER_LIST_rec.org_id is null) THEN
427: l_return_status := FND_API.G_RET_STS_ERROR;
428: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
429: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
430: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
431: oe_msg_pub.add;
432: END IF;

Line 431: oe_msg_pub.add;

427: l_return_status := FND_API.G_RET_STS_ERROR;
428: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
429: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
430: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
431: oe_msg_pub.add;
432: END IF;
433: END IF;
434:
435: --if org_id is not null and it is not a valid org

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

435: --if org_id is not null and it is not a valid org
436: IF (p_MODIFIER_LIST_rec.org_id is not null
437: and QP_UTIL.validate_org_id(p_MODIFIER_LIST_rec.org_id) = 'N') THEN
438: l_return_status := FND_API.G_RET_STS_ERROR;
439: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
440: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
441: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
442: oe_msg_pub.add;
443: END IF;

Line 442: oe_msg_pub.add;

438: l_return_status := FND_API.G_RET_STS_ERROR;
439: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
440: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
441: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
442: oe_msg_pub.add;
443: END IF;
444: END IF;
445: END IF; --IF l_security_profile = 'Y'
446:

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

448: IF ((p_MODIFIER_LIST_rec.global_flag = 'Y'
449: 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
450: -- and p_MODIFIER_LIST_rec.org_id <> FND_API.G_MISS_NUM THEN
451: l_return_status := FND_API.G_RET_STS_ERROR;
452: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
453: FND_MESSAGE.SET_NAME('QP', 'QP_GLOBAL_OR_ORG');
454: oe_msg_pub.add;
455: END IF;
456: END IF;--p_header_rec.global_flag

Line 454: oe_msg_pub.add;

450: -- and p_MODIFIER_LIST_rec.org_id <> FND_API.G_MISS_NUM THEN
451: l_return_status := FND_API.G_RET_STS_ERROR;
452: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
453: FND_MESSAGE.SET_NAME('QP', 'QP_GLOBAL_OR_ORG');
454: oe_msg_pub.add;
455: END IF;
456: END IF;--p_header_rec.global_flag
457: ELSE --bug14758481
458: -- QP Security is ON and Global Flag is null then throw required error for Global Flag

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

458: -- QP Security is ON and Global Flag is null then throw required error for Global Flag
459: IF (l_security_profile = 'Y')
460: THEN
461: l_return_status := FND_API.G_RET_STS_ERROR;
462: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
463: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','GLOBAL_FLAG');
465: oe_msg_pub.add;
466: END IF;

Line 465: oe_msg_pub.add;

461: l_return_status := FND_API.G_RET_STS_ERROR;
462: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
463: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','GLOBAL_FLAG');
465: oe_msg_pub.add;
466: END IF;
467: END IF;
468: END IF;
469: --end validations for moac

Line 511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

507:
508: oe_debug_pub.add('others EXP');
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: OE_MSG_PUB.Add_Exc_Msg
514: ( G_PKG_NAME
515: , 'Entity'

Line 513: OE_MSG_PUB.Add_Exc_Msg

509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: OE_MSG_PUB.Add_Exc_Msg
514: ( G_PKG_NAME
515: , 'Entity'
516: );
517: END IF;

Line 1143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1139: WHEN OTHERS THEN
1140:
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142:
1143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1144: THEN
1145: OE_MSG_PUB.Add_Exc_Msg
1146: ( G_PKG_NAME
1147: , 'Attributes'

Line 1145: OE_MSG_PUB.Add_Exc_Msg

1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142:
1143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1144: THEN
1145: OE_MSG_PUB.Add_Exc_Msg
1146: ( G_PKG_NAME
1147: , 'Attributes'
1148: );
1149: END IF;

Line 1187: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1183: WHEN OTHERS THEN
1184:
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186:
1187: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1188: THEN
1189: OE_MSG_PUB.Add_Exc_Msg
1190: ( G_PKG_NAME
1191: , 'Entity_Delete'

Line 1189: OE_MSG_PUB.Add_Exc_Msg

1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186:
1187: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1188: THEN
1189: OE_MSG_PUB.Add_Exc_Msg
1190: ( G_PKG_NAME
1191: , 'Entity_Delete'
1192: );
1193: END IF;