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 40: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

36: THEN
37:
38: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 45: oe_msg_pub.Add;

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

Line 61: OE_MSG_PUB.Add;

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

Line 72: OE_MSG_PUB.Add;

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:
76: IF nvl(p_old_PRICE_LIST_rec.rounding_factor,9999999) <>

Line 87: OE_MSG_PUB.Add;

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

Line 99: OE_MSG_PUB.Add;

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

Line 110: OE_MSG_PUB.Add;

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:
114: IF nvl(p_old_PRICE_LIST_rec.sold_to_org_id,9999999) <>

Line 121: OE_MSG_PUB.Add;

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

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

130: THEN
131:
132: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 139: oe_msg_pub.Add;

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

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

147: THEN
148:
149: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 156: oe_msg_pub.Add;

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

Line 169: OE_MSG_PUB.Add;

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

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

175: THEN
176:
177: l_return_status := FND_API.G_RET_STS_ERROR;
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

Line 184: oe_msg_pub.Add;

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

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

214: IF p_PRICE_LIST_rec.automatic_flag not in ('Y', 'N', 'y', 'n') THEN
215:
216: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 223: oe_msg_pub.Add;

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

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

234: IF p_PRICE_LIST_rec.active_flag not in ('Y', 'N', 'y', 'n') THEN
235:
236: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 243: oe_msg_pub.add;

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

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

252: IF p_PRICE_LIST_rec.mobile_download not in ('Y', 'N', 'n') THEN
253:
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;

Line 260: oe_msg_pub.add;

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

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

268:
269: IF p_PRICE_LIST_rec.global_flag not in ('Y', 'N', 'n') THEN
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;

Line 276: oe_msg_pub.add;

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

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

287: --if security is OFF, global_flag cannot be 'N'
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;

Line 294: oe_msg_pub.add;

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:
298: IF l_security_profile = 'Y' THEN

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

299: --if security is ON and global_flag is 'N', org_id cannot be null
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;

Line 306: oe_msg_pub.add;

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:
310: --if org_id is not null and it is not a valid org

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

310: --if org_id is not null and it is not a valid org
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;

Line 317: oe_msg_pub.add;

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'
321:

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

323: IF ((p_PRICE_LIST_rec.global_flag = 'Y'
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

Line 329: oe_msg_pub.add;

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;
333: --end validations for moac

Line 351: oe_msg_pub.add;

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:
355: /*

Line 363: oe_msg_pub.add;

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: */
367: else

Line 376: oe_msg_pub.add;

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:
380: end if;

Line 389: oe_msg_pub.add;

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:
393: IF ( p_PRICE_LIST_rec.currency_header_id IS NOT NULL and

Line 408: oe_msg_pub.add;

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:
412: IF NOT QP_Validate.List_Type(p_PRICE_LIST_rec.list_type_code) THEN

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

442: l_return_status := FND_API.G_RET_STS_ERROR;
443:
444: /*
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');

Line 451: oe_msg_pub.Add;

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:
455: */

Line 465: oe_msg_pub.add;

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:
469: IF (p_PRICE_LIST_rec.start_date_active > l_lines_dates_cur.start_date_active) THEN -- line date not within hdr date

Line 472: oe_msg_pub.add;

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

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

507: WHEN OTHERS THEN
508:
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 1089: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1085: WHEN OTHERS THEN
1086:
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088:
1089: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1090: THEN
1091: oe_msg_pub.Add_Exc_Msg
1092: ( G_PKG_NAME
1093: , 'Attributes'

Line 1091: oe_msg_pub.Add_Exc_Msg

1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088:
1089: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1090: THEN
1091: oe_msg_pub.Add_Exc_Msg
1092: ( G_PKG_NAME
1093: , 'Attributes'
1094: );
1095: END IF;

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

1127: WHEN OTHERS THEN
1128:
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130:
1131: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1132: THEN
1133: oe_msg_pub.Add_Exc_Msg
1134: ( G_PKG_NAME
1135: , 'Entity_Delete'

Line 1133: oe_msg_pub.Add_Exc_Msg

1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130:
1131: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1132: THEN
1133: oe_msg_pub.Add_Exc_Msg
1134: ( G_PKG_NAME
1135: , 'Entity_Delete'
1136: );
1137: END IF;