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

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

46: THEN
47:
48: l_return_status := FND_API.G_RET_STS_ERROR;
49:
50: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
51: THEN
52:
53: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
54: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header_id');

Line 55: oe_msg_pub.Add;

51: THEN
52:
53: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
54: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header_id');
55: oe_msg_pub.Add;
56:
57: END IF;
58:
59: END IF;

Line 71: OE_MSG_PUB.Add;

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

Line 82: OE_MSG_PUB.Add;

78: l_return_status := FND_API.G_RET_STS_ERROR;
79:
80: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_source_code');
82: OE_MSG_PUB.Add;
83:
84: END IF;
85:
86: IF nvl(p_old_PRICE_LIST_rec.rounding_factor,9999999) <>

Line 97: OE_MSG_PUB.Add;

93: IF l_unit_precision_type = 'STANDARD' THEN
94: IF l_price_rounding = 'PRECISION' THEN
95: l_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MESSAGE.SET_NAME('QP', 'QP_ROUNDING_FACTOR_NO_UPDATE');
97: OE_MSG_PUB.Add;
98: END IF;
99: END IF;
100: END IF;
101:

Line 109: OE_MSG_PUB.Add;

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

Line 120: OE_MSG_PUB.Add;

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

Line 131: OE_MSG_PUB.Add;

127: l_return_status := FND_API.G_RET_STS_ERROR;
128:
129: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');
130: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org_id');
131: OE_MSG_PUB.Add;
132:
133: END IF;
134:
135: END IF;

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

140: THEN
141:
142: l_return_status := FND_API.G_RET_STS_ERROR;
143:
144: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
145: THEN
146:
147: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_TYPE_CODE')); -- Fix For Bug-1974413

Line 149: oe_msg_pub.Add;

145: THEN
146:
147: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('LIST_TYPE_CODE')); -- Fix For Bug-1974413
149: oe_msg_pub.Add;
150:
151: END IF;
152:
153: END IF;

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

157: THEN
158:
159: l_return_status := FND_API.G_RET_STS_ERROR;
160:
161: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
162: THEN
163:
164: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
165: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('CURRENCY_CODE')); -- Fix For Bug-1974413

Line 166: oe_msg_pub.Add;

162: THEN
163:
164: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
165: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('CURRENCY_CODE')); -- Fix For Bug-1974413
166: oe_msg_pub.Add;
167:
168: END IF;
169:
170: END IF;

Line 179: OE_MSG_PUB.Add;

175: ( p_PRICE_LIST_rec.currency_code <>
176: p_old_PRICE_LIST_rec.currency_code )
177: THEN
178: FND_MESSAGE.SET_NAME('QP','QP_CHANGE_SEC_PRL_CURR');
179: OE_MSG_PUB.Add;
180: END IF;
181:
182: -- Bug 2347427 end
183:

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

185: THEN
186:
187: l_return_status := FND_API.G_RET_STS_ERROR;
188:
189: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
190: THEN
191:
192: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
193: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('NAME')); -- Fix For Bug-1974413

Line 194: oe_msg_pub.Add;

190: THEN
191:
192: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
193: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',QP_PRC_UTIL.Get_Attribute_Name('NAME')); -- Fix For Bug-1974413
194: oe_msg_pub.Add;
195:
196: END IF;
197:
198: END IF;

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

224: IF p_PRICE_LIST_rec.automatic_flag not in ('Y', 'N', 'y', 'n') THEN
225:
226: l_return_status := FND_API.G_RET_STS_ERROR;
227:
228: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
229: THEN
230:
231: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

Line 233: oe_msg_pub.Add;

229: THEN
230:
231: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
233: oe_msg_pub.Add;
234:
235: END IF;
236:
237: END IF;

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

244: IF p_PRICE_LIST_rec.active_flag not in ('Y', 'N', 'y', 'n') THEN
245:
246: l_return_status := FND_API.G_RET_STS_ERROR;
247:
248: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
249: THEN
250:
251: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','active_flag');

Line 253: oe_msg_pub.add;

249: THEN
250:
251: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','active_flag');
253: oe_msg_pub.add;
254: END IF;
255: END IF;
256: END IF;
257:

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

262: IF p_PRICE_LIST_rec.mobile_download not in ('Y', 'N', 'n') THEN
263:
264: l_return_status := FND_API.G_RET_STS_ERROR;
265:
266: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
267:
268: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','mobile_download');
270: oe_msg_pub.add;

Line 270: oe_msg_pub.add;

266: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
267:
268: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','mobile_download');
270: oe_msg_pub.add;
271: END IF;
272: END IF;
273: END IF;
274:

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

278:
279: IF p_PRICE_LIST_rec.global_flag not in ('Y', 'N', 'n') THEN
280:
281: l_return_status := FND_API.G_RET_STS_ERROR;
282: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
283:
284: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
285: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Global_flag');
286: oe_msg_pub.add;

Line 286: oe_msg_pub.add;

282: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
283:
284: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
285: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Global_flag');
286: oe_msg_pub.add;
287: END IF;
288: END IF;
289: END IF;
290:

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

297: --if security is OFF, global_flag cannot be 'N'
298: IF (l_security_profile = 'N'
299: and p_PRICE_LIST_rec.global_flag in ('N', 'n')) THEN
300: l_return_status := FND_API.G_RET_STS_ERROR;
301: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
302: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
303: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
304: oe_msg_pub.add;
305: END IF;

Line 304: oe_msg_pub.add;

300: l_return_status := FND_API.G_RET_STS_ERROR;
301: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
302: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
303: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','global_flag');
304: oe_msg_pub.add;
305: END IF;
306: END IF;
307:
308: IF l_security_profile = 'Y' THEN

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

309: --if security is ON and global_flag is 'N', org_id cannot be null
310: IF (p_PRICE_LIST_rec.global_flag in ('N', 'n')
311: and p_PRICE_LIST_rec.org_id is null) THEN
312: l_return_status := FND_API.G_RET_STS_ERROR;
313: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
314: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
315: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
316: oe_msg_pub.add;
317: END IF;

Line 316: oe_msg_pub.add;

312: l_return_status := FND_API.G_RET_STS_ERROR;
313: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
314: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
315: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
316: oe_msg_pub.add;
317: END IF;
318: END IF;
319:
320: --if org_id is not null and it is not a valid org

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

320: --if org_id is not null and it is not a valid org
321: IF (p_PRICE_LIST_rec.org_id is not null
322: and QP_UTIL.validate_org_id(p_PRICE_LIST_rec.org_id) = 'N') THEN
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
326: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
327: oe_msg_pub.add;
328: END IF;

Line 327: oe_msg_pub.add;

323: l_return_status := FND_API.G_RET_STS_ERROR;
324: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('FND','FND_MO_ORG_INVALID');
326: -- FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORG_ID');
327: oe_msg_pub.add;
328: END IF;
329: END IF;
330: END IF;--IF l_security_profile = 'Y'
331:

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

333: IF ((p_PRICE_LIST_rec.global_flag = 'Y'
334: 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
335: -- and p_MODIFIER_LIST_rec.org_id <> FND_API.G_MISS_NUM THEN
336: l_return_status := FND_API.G_RET_STS_ERROR;
337: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
338: FND_MESSAGE.SET_NAME('QP', 'QP_GLOBAL_OR_ORG');
339: oe_msg_pub.add;
340: END IF;
341: END IF;--p_header_rec.global_flag

Line 339: oe_msg_pub.add;

335: -- and p_MODIFIER_LIST_rec.org_id <> FND_API.G_MISS_NUM THEN
336: l_return_status := FND_API.G_RET_STS_ERROR;
337: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR) THEN
338: FND_MESSAGE.SET_NAME('QP', 'QP_GLOBAL_OR_ORG');
339: oe_msg_pub.add;
340: END IF;
341: END IF;--p_header_rec.global_flag
342: END IF;
343: --end validations for moac

Line 361: oe_msg_pub.add;

357: then
358: l_return_status := FND_API.G_RET_STS_ERROR;
359:
360: FND_MESSAGE.SET_NAME('QP','QP_MUL_CURR_REQD');
361: oe_msg_pub.add;
362:
363: end if;
364:
365: /*

Line 373: oe_msg_pub.add;

369: l_return_status := FND_API.G_RET_STS_ERROR;
370:
371: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE'); -- CHANGE
372: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rounding_factor');
373: oe_msg_pub.add;
374:
375: end if;
376: */
377: else

Line 386: oe_msg_pub.add;

382: then
383: l_return_status := FND_API.G_RET_STS_ERROR;
384:
385: FND_MESSAGE.SET_NAME('QP','QP_MUL_CURR_NULL');
386: oe_msg_pub.add;
387:
388: end if;
389:
390: end if;

Line 399: oe_msg_pub.add;

395: then
396: l_return_status := FND_API.G_RET_STS_ERROR;
397:
398: FND_MESSAGE.SET_NAME('QP','QP_RNDG_FACTOR_REQD');
399: oe_msg_pub.add;
400:
401: end if;
402:
403: IF ( p_PRICE_LIST_rec.currency_header_id IS NOT NULL and

Line 418: oe_msg_pub.add;

414: WHEN NO_DATA_FOUND THEN
415: l_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MESSAGE.SET_NAME('QP','QP_INVALID_ATTRIBUTE');
417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
418: oe_msg_pub.add;
419: END;
420: END IF;
421:
422: IF NOT QP_Validate.List_Type(p_PRICE_LIST_rec.list_type_code) THEN

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

452: l_return_status := FND_API.G_RET_STS_ERROR;
453:
454: /*
455:
456: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
457: THEN
458:
459: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');

Line 461: oe_msg_pub.Add;

457: THEN
458:
459: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');
461: oe_msg_pub.Add;
462:
463: END IF;
464:
465: */

Line 476: oe_msg_pub.add;

472: fetch c_lines_edates_cur into l_dummy;
473: IF c_lines_edates_cur%found THEN -- line date not within hdr date
474: l_return_status := FND_API.G_RET_STS_ERROR;
475: FND_MESSAGE.SET_NAME('QP','QP_PLL_END_DATE_NOT_WITHIN');
476: oe_msg_pub.add;
477: END IF;
478:
479: open c_lines_sdates_cur(p_PRICE_LIST_rec.list_header_id,p_PRICE_LIST_rec.start_date_active);
480: fetch c_lines_sdates_cur into l_dummy;

Line 485: oe_msg_pub.add;

481:
482: IF c_lines_sdates_cur%found THEN -- line date not within hdr date
483: l_return_status := FND_API.G_RET_STS_ERROR;
484: FND_MESSAGE.SET_NAME('QP','QP_PLL_START_DATE_NOT_WITHIN');
485: oe_msg_pub.add;
486: END IF;
487: END IF;
488:
489: IF NOT QP_Validate.Price_List_Name(p_PRICE_LIST_rec.name,

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

518: WHEN OTHERS THEN
519:
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521:
522: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: oe_msg_pub.Add_Exc_Msg
525: ( G_PKG_NAME
526: , 'Entity'

Line 524: oe_msg_pub.Add_Exc_Msg

520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521:
522: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: oe_msg_pub.Add_Exc_Msg
525: ( G_PKG_NAME
526: , 'Entity'
527: );
528: END IF;

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

1096: WHEN OTHERS THEN
1097:
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099:
1100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1101: THEN
1102: oe_msg_pub.Add_Exc_Msg
1103: ( G_PKG_NAME
1104: , 'Attributes'

Line 1102: oe_msg_pub.Add_Exc_Msg

1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099:
1100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1101: THEN
1102: oe_msg_pub.Add_Exc_Msg
1103: ( G_PKG_NAME
1104: , 'Attributes'
1105: );
1106: END IF;

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

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

Line 1144: oe_msg_pub.Add_Exc_Msg

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