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 FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
14: QP_Price_List_PUB.G_MISS_PRICE_LIST_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_dummy_c VARCHAR2(1);
19: l_security_profile VARCHAR2(1);
20: l_unit_precision_type VARCHAR2(255):= '';
21: l_price_rounding VARCHAR2(50):= '';

Line 27: and NOT((end_date_active is null or end_date_active = FND_API.G_MISS_DATE)

23: cursor c_lines_dates_cur(p_list_header_id NUMBER) is
24: select end_date_active, start_date_active
25: from qp_list_lines
26: where list_header_id = p_list_header_id
27: and NOT((end_date_active is null or end_date_active = FND_API.G_MISS_DATE)
28: and (start_date_active is null or start_date_active = FND_API.G_MISS_DATE));
29:
30: BEGIN
31:

Line 28: and (start_date_active is null or start_date_active = FND_API.G_MISS_DATE));

24: select end_date_active, start_date_active
25: from qp_list_lines
26: where list_header_id = p_list_header_id
27: and NOT((end_date_active is null or end_date_active = FND_API.G_MISS_DATE)
28: and (start_date_active is null or start_date_active = FND_API.G_MISS_DATE));
29:
30: BEGIN
31:
32: -- Check required attributes. list_header_id, list_type_code

Line 38: l_return_status := FND_API.G_RET_STS_ERROR;

34:
35: IF p_PRICE_LIST_rec.list_header_id IS NULL
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:

Line 57: l_return_status := FND_API.G_RET_STS_ERROR;

53: THEN
54: IF nvl(p_old_PRICE_LIST_rec.shareable_flag,'X') <>
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;

Line 68: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 85: l_return_status := FND_API.G_RET_STS_ERROR;

81: l_price_rounding := fnd_profile.value('QP_PRICE_ROUNDING');
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;

Line 95: l_return_status := FND_API.G_RET_STS_ERROR;

91:
92: IF nvl(p_old_PRICE_LIST_rec.pte_code,'X') <>
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;

Line 106: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 117: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 132: l_return_status := FND_API.G_RET_STS_ERROR;

128:
129: IF p_PRICE_LIST_rec.list_type_code IS NULL
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:

Line 149: l_return_status := FND_API.G_RET_STS_ERROR;

145:
146: IF p_PRICE_LIST_rec.currency_code IS NULL
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:

Line 177: l_return_status := FND_API.G_RET_STS_ERROR;

173:
174: IF p_PRICE_LIST_rec.name IS NULL
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:

Line 192: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

188: END IF;
189:
190: -- Return Error if a required attribute is missing.
191:
192: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
193:
194: RAISE FND_API.G_EXC_ERROR;
195:
196: END IF;

Line 194: RAISE FND_API.G_EXC_ERROR;

190: -- Return Error if a required attribute is missing.
191:
192: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
193:
194: RAISE FND_API.G_EXC_ERROR;
195:
196: END IF;
197:
198: --

Line 203: l_return_status := FND_API.G_RET_STS_ERROR;

199: -- Check conditionally required attributes here.
200: --
201:
202: IF NOT QP_Validate.Currency(p_PRICE_LIST_rec.currency_code) THEN
203: l_return_status := FND_API.G_RET_STS_ERROR;
204: END IF;
205:
206:
207: IF NOT QP_Validate.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor,p_PRICE_LIST_rec.currency_code) THEN

Line 208: l_return_status := FND_API.G_RET_STS_ERROR;

204: END IF;
205:
206:
207: IF NOT QP_Validate.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor,p_PRICE_LIST_rec.currency_code) THEN
208: l_return_status := FND_API.G_RET_STS_ERROR;
209: END IF;
210:
211: IF ( p_PRICE_LIST_rec.automatic_flag IS NOT NULL
212: and p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR ) THEN

Line 212: and p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR ) THEN

208: l_return_status := FND_API.G_RET_STS_ERROR;
209: END IF;
210:
211: IF ( p_PRICE_LIST_rec.automatic_flag IS NOT NULL
212: and p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR ) THEN
213:
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;

Line 216: l_return_status := FND_API.G_RET_STS_ERROR;

212: and p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR ) THEN
213:
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:

Line 232: and p_PRICE_LIST_rec.active_flag <> FND_API.G_MISS_CHAR ) THEN

228:
229: END IF;
230: --add validation for active_flag
231: IF ( p_PRICE_LIST_rec.active_flag IS NOT NULL
232: and p_PRICE_LIST_rec.active_flag <> FND_API.G_MISS_CHAR ) THEN
233:
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;

Line 236: l_return_status := FND_API.G_RET_STS_ERROR;

232: and p_PRICE_LIST_rec.active_flag <> FND_API.G_MISS_CHAR ) THEN
233:
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:

Line 250: and p_PRICE_LIST_rec.mobile_download <> FND_API.G_MISS_CHAR ) THEN

246: END IF;
247:
248: -- mkarya for bug 1944882
249: IF ( p_PRICE_LIST_rec.mobile_download IS NOT NULL
250: and p_PRICE_LIST_rec.mobile_download <> FND_API.G_MISS_CHAR ) THEN
251:
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;

Line 254: l_return_status := FND_API.G_RET_STS_ERROR;

250: and p_PRICE_LIST_rec.mobile_download <> FND_API.G_MISS_CHAR ) THEN
251:
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');

Line 267: and p_PRICE_LIST_rec.global_flag <> FND_API.G_MISS_CHAR ) THEN

263: END IF;
264:
265: -- Pricing Security gtippire
266: IF ( p_PRICE_LIST_rec.global_flag IS NOT NULL
267: and p_PRICE_LIST_rec.global_flag <> FND_API.G_MISS_CHAR ) 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;

Line 271: l_return_status := FND_API.G_RET_STS_ERROR;

267: and p_PRICE_LIST_rec.global_flag <> FND_API.G_MISS_CHAR ) 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');

Line 290: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 302: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 313: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 325: -- and p_MODIFIER_LIST_rec.org_id <> FND_API.G_MISS_NUM THEN

321:
322: -- global_flag 'Y', and org_id not null combination is invalid
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;

Line 326: l_return_status := FND_API.G_RET_STS_ERROR;

322: -- global_flag 'Y', and org_id not null combination is invalid
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;

Line 346: p_PRICE_LIST_rec.currency_header_id = FND_API.G_MISS_NUM )

342: then
343:
344: -- Multi-Currency is installed
345: If (p_PRICE_LIST_rec.currency_header_id is NULL or
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');

Line 348: l_return_status := FND_API.G_RET_STS_ERROR;

344: -- Multi-Currency is installed
345: If (p_PRICE_LIST_rec.currency_header_id is NULL or
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:

Line 357: p_PRICE_LIST_rec.rounding_factor <> FND_API.G_MISS_NUM )

353: end if;
354:
355: /*
356: If (p_PRICE_LIST_rec.rounding_factor is NOT NULL and
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

Line 359: l_return_status := FND_API.G_RET_STS_ERROR;

355: /*
356: If (p_PRICE_LIST_rec.rounding_factor is NOT NULL and
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;

Line 370: p_PRICE_LIST_rec.currency_header_id <> FND_API.G_MISS_NUM and

366: */
367: else
368: -- Multi-Currency not installed
369: If (p_PRICE_LIST_rec.currency_header_id is NOT NULL and
370: p_PRICE_LIST_rec.currency_header_id <> FND_API.G_MISS_NUM and
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:

Line 373: l_return_status := FND_API.G_RET_STS_ERROR;

369: If (p_PRICE_LIST_rec.currency_header_id is NOT NULL and
370: p_PRICE_LIST_rec.currency_header_id <> FND_API.G_MISS_NUM and
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:

Line 384: p_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM )

380: end if;
381:
382: -- Bug 2293974 - rounding factor is mandatory irrespective of multi-currency is installed or not
383: If (p_PRICE_LIST_rec.rounding_factor is NULL or
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');

Line 386: l_return_status := FND_API.G_RET_STS_ERROR;

382: -- Bug 2293974 - rounding factor is mandatory irrespective of multi-currency is installed or not
383: If (p_PRICE_LIST_rec.rounding_factor is NULL or
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:

Line 394: p_PRICE_LIST_rec.currency_header_id <> FND_API.G_MISS_NUM ) THEN

390:
391: end if;
392:
393: IF ( p_PRICE_LIST_rec.currency_header_id IS NOT NULL and
394: p_PRICE_LIST_rec.currency_header_id <> FND_API.G_MISS_NUM ) THEN
395: BEGIN
396:
397: SELECT 'X'
398: INTO l_dummy_c

Line 405: l_return_status := FND_API.G_RET_STS_ERROR;

401: base_currency_code = p_PRICE_LIST_rec.currency_code;
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;

Line 413: l_return_status := FND_API.G_RET_STS_ERROR;

409: END;
410: END IF;
411:
412: IF NOT QP_Validate.List_Type(p_PRICE_LIST_rec.list_type_code) THEN
413: l_return_status := FND_API.G_RET_STS_ERROR;
414: END IF;
415:
416: /*
417:

Line 419: l_return_status := FND_API.G_RET_STS_ERROR;

415:
416: /*
417:
418: IF NOT QP_Validate.Source_System(p_PRICE_LIST_rec.source_system_code) THEN
419: l_return_status := FND_API.G_RET_STS_ERROR;
420: END IF;
421:
422: */
423:

Line 425: l_return_status := FND_API.G_RET_STS_ERROR;

421:
422: */
423:
424: IF NOT QP_Validate.Ship_Method(p_PRICE_LIST_rec.ship_method_code) THEN
425: l_return_status := FND_API.G_RET_STS_ERROR;
426: END IF;
427:
428: IF NOT QP_Validate.Freight_Terms(p_PRICE_LIST_rec.freight_terms_code) THEN
429: l_return_status := FND_API.G_RET_STS_ERROR;

Line 429: l_return_status := FND_API.G_RET_STS_ERROR;

425: l_return_status := FND_API.G_RET_STS_ERROR;
426: END IF;
427:
428: IF NOT QP_Validate.Freight_Terms(p_PRICE_LIST_rec.freight_terms_code) THEN
429: l_return_status := FND_API.G_RET_STS_ERROR;
430: END IF;
431:
432: IF NOT QP_Validate.Terms(p_PRICE_LIST_rec.terms_id) THEN
433: l_return_status := FND_API.G_RET_STS_ERROR;

Line 433: l_return_status := FND_API.G_RET_STS_ERROR;

429: l_return_status := FND_API.G_RET_STS_ERROR;
430: END IF;
431:
432: IF NOT QP_Validate.Terms(p_PRICE_LIST_rec.terms_id) THEN
433: l_return_status := FND_API.G_RET_STS_ERROR;
434: END IF;
435:
436: --
437: -- Validate attribute dependencies here.

Line 442: l_return_status := FND_API.G_RET_STS_ERROR;

438: --
439:
440: IF NOT QP_Validate.Start_Date_Active(p_PRICE_LIST_rec.start_date_active, p_PRICE_LIST_rec.end_date_active) THEN
441:
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)

Line 459: IF NOT((p_PRICE_LIST_rec.end_date_active is null or p_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE)

455: */
456:
457: END IF;
458:
459: IF NOT((p_PRICE_LIST_rec.end_date_active is null or p_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE)
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;

Line 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

456:
457: END IF;
458:
459: IF NOT((p_PRICE_LIST_rec.end_date_active is null or p_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE)
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');

Line 463: l_return_status := FND_API.G_RET_STS_ERROR;

459: IF NOT((p_PRICE_LIST_rec.end_date_active is null or p_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE)
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;

Line 470: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 482: l_return_status := FND_API.G_RET_STS_ERROR;

478: IF NOT QP_Validate.Price_List_Name(p_PRICE_LIST_rec.name,
479: p_PRICE_LIST_rec.list_header_id,
480: p_PRICE_LIST_rec.version_no) THEN
481:
482: l_return_status := FND_API.G_RET_STS_ERROR;
483:
484: END IF;
485:
486:

Line 487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

483:
484: END IF;
485:
486:
487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
488:
489: RAISE FND_API.G_EXC_ERROR;
490:
491: END IF;

Line 489: RAISE FND_API.G_EXC_ERROR;

485:
486:
487: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
488:
489: RAISE FND_API.G_EXC_ERROR;
490:
491: END IF;
492:
493: -- Done validating entity

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495: x_return_status := l_return_status;
496:
497: EXCEPTION
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500:
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: EXCEPTION
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500:
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: WHEN FND_API.G_EXC_ERROR THEN
500:
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506:
507: WHEN OTHERS THEN

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506:
507: WHEN OTHERS THEN
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506:
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

Line 533: x_return_status := FND_API.G_RET_STS_SUCCESS;

529: IS
530:
531: BEGIN
532:
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:
535: -- Validate PRICE_LIST attributes
536:
537: IF p_PRICE_LIST_rec.automatic_flag IS NOT NULL AND

Line 543: x_return_status := FND_API.G_RET_STS_ERROR;

539: p_old_PRICE_LIST_rec.automatic_flag OR
540: p_old_PRICE_LIST_rec.automatic_flag IS NULL )
541: THEN
542: IF NOT QP_Validate.Automatic(p_PRICE_LIST_rec.automatic_flag) THEN
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: END IF;
545: END IF;
546:
547: IF p_PRICE_LIST_rec.active_flag IS NOT NULL AND

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: p_old_PRICE_LIST_rec.active_flag OR
550: p_old_PRICE_LIST_rec.active_flag IS NULL)
551: THEN
552: IF NOT QP_Validate.active(p_PRICE_LIST_rec.active_flag) THEN
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: END IF;
555: END IF;
556:
557: --mkarya for bug 1944882

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: p_old_PRICE_LIST_rec.mobile_download OR
561: p_old_PRICE_LIST_rec.mobile_download IS NULL)
562: THEN
563: IF NOT QP_Validate.mobile_download(p_PRICE_LIST_rec.mobile_download) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: END IF;
566: END IF;
567:
568: --Pricing Security gtippire

Line 575: x_return_status := FND_API.G_RET_STS_ERROR;

571: p_old_PRICE_LIST_rec.global_flag OR
572: p_old_PRICE_LIST_rec.global_flag IS NULL)
573: THEN
574: IF NOT QP_Validate.global_flag(p_PRICE_LIST_rec.global_flag) THEN
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: END IF;
577: END IF;
578:
579:

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

582: p_old_PRICE_LIST_rec.description OR
583: p_old_PRICE_LIST_rec.description IS NULL )
584: THEN
585: IF NOT QP_Validate.Description(p_PRICE_LIST_rec.description) THEN
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: END IF;
588: END IF;
589:
590: IF p_PRICE_LIST_rec.name IS NOT NULL AND

Line 596: x_return_status := FND_API.G_RET_STS_ERROR;

592: p_old_PRICE_LIST_rec.name OR
593: p_old_PRICE_LIST_rec.name IS NULL )
594: THEN
595: IF NOT QP_Validate.Name(p_PRICE_LIST_rec.name) THEN
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: END IF;
598: END IF;
599:
600: IF p_PRICE_LIST_rec.comments IS NOT NULL AND

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: p_old_PRICE_LIST_rec.comments OR
603: p_old_PRICE_LIST_rec.comments IS NULL )
604: THEN
605: IF NOT QP_Validate.Comments(p_PRICE_LIST_rec.comments) THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: END IF;
608: END IF;
609:
610: IF p_PRICE_LIST_rec.created_by IS NOT NULL AND

Line 616: x_return_status := FND_API.G_RET_STS_ERROR;

612: p_old_PRICE_LIST_rec.created_by OR
613: p_old_PRICE_LIST_rec.created_by IS NULL )
614: THEN
615: IF NOT QP_Validate.Created_By(p_PRICE_LIST_rec.created_by) THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: END IF;
618: END IF;
619:
620: IF p_PRICE_LIST_rec.creation_date IS NOT NULL AND

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: p_old_PRICE_LIST_rec.creation_date OR
623: p_old_PRICE_LIST_rec.creation_date IS NULL )
624: THEN
625: IF NOT QP_Validate.Creation_Date(p_PRICE_LIST_rec.creation_date) THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: END IF;
629:
630: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: p_old_PRICE_LIST_rec.currency_code OR
633: p_old_PRICE_LIST_rec.currency_code IS NULL )
634: THEN
635: IF NOT QP_Validate.Currency(p_PRICE_LIST_rec.currency_code) THEN
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: END IF;
638: END IF;
639:
640: IF p_PRICE_LIST_rec.discount_lines_flag IS NOT NULL AND

Line 646: x_return_status := FND_API.G_RET_STS_ERROR;

642: p_old_PRICE_LIST_rec.discount_lines_flag OR
643: p_old_PRICE_LIST_rec.discount_lines_flag IS NULL )
644: THEN
645: IF NOT QP_Validate.Discount_Lines(p_PRICE_LIST_rec.discount_lines_flag) THEN
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: END IF;
648: END IF;
649:
650: IF p_PRICE_LIST_rec.end_date_active IS NOT NULL AND

Line 656: x_return_status := FND_API.G_RET_STS_ERROR;

652: p_old_PRICE_LIST_rec.end_date_active OR
653: p_old_PRICE_LIST_rec.end_date_active IS NULL )
654: THEN
655: IF NOT QP_Validate.End_Date_Active(p_PRICE_LIST_rec.end_date_active, p_PRICE_LIST_rec.start_date_active) THEN
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: END IF;
658:
659: END IF;
660:

Line 667: x_return_status := FND_API.G_RET_STS_ERROR;

663: p_old_PRICE_LIST_rec.freight_terms_code OR
664: p_old_PRICE_LIST_rec.freight_terms_code IS NULL )
665: THEN
666: IF NOT QP_Validate.Freight_Terms(p_PRICE_LIST_rec.freight_terms_code) THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: END IF;
669: END IF;
670:
671: IF p_PRICE_LIST_rec.gsa_indicator IS NOT NULL AND

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: p_old_PRICE_LIST_rec.gsa_indicator OR
674: p_old_PRICE_LIST_rec.gsa_indicator IS NULL )
675: THEN
676: IF NOT QP_Validate.Gsa_Indicator(p_PRICE_LIST_rec.gsa_indicator) THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: END IF;
679: END IF;
680:
681: IF p_PRICE_LIST_rec.last_updated_by IS NOT NULL AND

Line 687: x_return_status := FND_API.G_RET_STS_ERROR;

683: p_old_PRICE_LIST_rec.last_updated_by OR
684: p_old_PRICE_LIST_rec.last_updated_by IS NULL )
685: THEN
686: IF NOT QP_Validate.Last_Updated_By(p_PRICE_LIST_rec.last_updated_by) THEN
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: END IF;
689: END IF;
690:
691: IF p_PRICE_LIST_rec.last_update_date IS NOT NULL AND

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

693: p_old_PRICE_LIST_rec.last_update_date OR
694: p_old_PRICE_LIST_rec.last_update_date IS NULL )
695: THEN
696: IF NOT QP_Validate.Last_Update_Date(p_PRICE_LIST_rec.last_update_date) THEN
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: END IF;
699: END IF;
700:
701: IF p_PRICE_LIST_rec.last_update_login IS NOT NULL AND

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: p_old_PRICE_LIST_rec.last_update_login OR
704: p_old_PRICE_LIST_rec.last_update_login IS NULL )
705: THEN
706: IF NOT QP_Validate.Last_Update_Login(p_PRICE_LIST_rec.last_update_login) THEN
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: END IF;
709: END IF;
710:
711: IF p_PRICE_LIST_rec.list_header_id IS NOT NULL AND

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713: p_old_PRICE_LIST_rec.list_header_id OR
714: p_old_PRICE_LIST_rec.list_header_id IS NULL )
715: THEN
716: IF NOT QP_Validate.List_Header(p_PRICE_LIST_rec.list_header_id) THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: END IF;
719: END IF;
720:
721: IF p_PRICE_LIST_rec.list_type_code IS NOT NULL AND

Line 727: x_return_status := FND_API.G_RET_STS_ERROR;

723: p_old_PRICE_LIST_rec.list_type_code OR
724: p_old_PRICE_LIST_rec.list_type_code IS NULL )
725: THEN
726: IF NOT QP_Validate.List_Type(p_PRICE_LIST_rec.list_type_code) THEN
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: END IF;
729: END IF;
730:
731: IF p_PRICE_LIST_rec.version_no IS NOT NULL AND

Line 737: x_return_status := FND_API.G_RET_STS_ERROR;

733: p_old_PRICE_LIST_rec.version_no OR
734: p_old_PRICE_LIST_rec.version_no IS NULL )
735: THEN
736: IF NOT QP_Validate.Version(p_PRICE_LIST_rec.version_no) THEN
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: END IF;
739: END IF;
740:
741: IF p_PRICE_LIST_rec.program_application_id IS NOT NULL AND

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: p_old_PRICE_LIST_rec.program_application_id OR
744: p_old_PRICE_LIST_rec.program_application_id IS NULL )
745: THEN
746: IF NOT QP_Validate.Program_Application(p_PRICE_LIST_rec.program_application_id) THEN
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: END IF;
749: END IF;
750:
751: IF p_PRICE_LIST_rec.program_id IS NOT NULL AND

Line 757: x_return_status := FND_API.G_RET_STS_ERROR;

753: p_old_PRICE_LIST_rec.program_id OR
754: p_old_PRICE_LIST_rec.program_id IS NULL )
755: THEN
756: IF NOT QP_Validate.Program(p_PRICE_LIST_rec.program_id) THEN
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: END IF;
759: END IF;
760:
761: IF p_PRICE_LIST_rec.program_update_date IS NOT NULL AND

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: p_old_PRICE_LIST_rec.program_update_date OR
764: p_old_PRICE_LIST_rec.program_update_date IS NULL )
765: THEN
766: IF NOT QP_Validate.Program_Update_Date(p_PRICE_LIST_rec.program_update_date) THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: END IF;
769: END IF;
770:
771: IF p_PRICE_LIST_rec.prorate_flag IS NOT NULL AND

Line 777: x_return_status := FND_API.G_RET_STS_ERROR;

773: p_old_PRICE_LIST_rec.prorate_flag OR
774: p_old_PRICE_LIST_rec.prorate_flag IS NULL )
775: THEN
776: IF NOT QP_Validate.Prorate(p_PRICE_LIST_rec.prorate_flag) THEN
777: x_return_status := FND_API.G_RET_STS_ERROR;
778: END IF;
779: END IF;
780:
781: IF p_PRICE_LIST_rec.request_id IS NOT NULL AND

Line 787: x_return_status := FND_API.G_RET_STS_ERROR;

783: p_old_PRICE_LIST_rec.request_id OR
784: p_old_PRICE_LIST_rec.request_id IS NULL )
785: THEN
786: IF NOT QP_Validate.Request(p_PRICE_LIST_rec.request_id) THEN
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: END IF;
789: END IF;
790:
791: IF p_PRICE_LIST_rec.rounding_factor IS NOT NULL AND

Line 797: x_return_status := FND_API.G_RET_STS_ERROR;

793: p_old_PRICE_LIST_rec.rounding_factor OR
794: p_old_PRICE_LIST_rec.rounding_factor IS NULL )
795: THEN
796: IF NOT QP_Validate.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor) THEN
797: x_return_status := FND_API.G_RET_STS_ERROR;
798: END IF;
799: END IF;
800:
801: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND

Line 807: x_return_status := FND_API.G_RET_STS_ERROR;

803: p_old_PRICE_LIST_rec.ship_method_code OR
804: p_old_PRICE_LIST_rec.ship_method_code IS NULL )
805: THEN
806: IF NOT QP_Validate.Ship_Method(p_PRICE_LIST_rec.ship_method_code) THEN
807: x_return_status := FND_API.G_RET_STS_ERROR;
808: END IF;
809: END IF;
810:
811: IF p_PRICE_LIST_rec.start_date_active IS NOT NULL AND

Line 817: x_return_status := FND_API.G_RET_STS_ERROR;

813: p_old_PRICE_LIST_rec.start_date_active OR
814: p_old_PRICE_LIST_rec.start_date_active IS NULL )
815: THEN
816: IF NOT QP_Validate.Start_Date_Active(p_PRICE_LIST_rec.start_date_active, p_PRICE_LIST_rec.end_date_active) THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: END IF;
819:
820:
821: END IF;

Line 829: x_return_status := FND_API.G_RET_STS_ERROR;

825: p_old_PRICE_LIST_rec.terms_id OR
826: p_old_PRICE_LIST_rec.terms_id IS NULL )
827: THEN
828: IF NOT QP_Validate.Terms(p_PRICE_LIST_rec.terms_id) THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: END IF;
831: END IF;
832:
833: --Multi-Currency SunilPandey

Line 840: x_return_status := FND_API.G_RET_STS_ERROR;

836: p_old_PRICE_LIST_rec.currency_header_id OR
837: p_old_PRICE_LIST_rec.currency_header_id IS NULL)
838: THEN
839: IF NOT QP_Validate.currency_header(p_PRICE_LIST_rec.currency_header_id) THEN
840: x_return_status := FND_API.G_RET_STS_ERROR;
841: END IF;
842: END IF;
843:
844: --Attribute Manager Giri

Line 851: x_return_status := FND_API.G_RET_STS_ERROR;

847: p_old_PRICE_LIST_rec.pte_code OR
848: p_old_PRICE_LIST_rec.pte_code IS NULL)
849: THEN
850: IF NOT QP_Validate.pte(p_PRICE_LIST_rec.pte_code) THEN
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: END IF;
853: END IF;
854:
855: --Blanket Sales Order

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: p_old_PRICE_LIST_rec.LIST_SOURCE_CODE OR
859: p_old_PRICE_LIST_rec.LIST_SOURCE_CODE IS NULL)
860: THEN
861: IF NOT QP_Validate.list_source_code(p_PRICE_LIST_rec.LIST_SOURCE_CODE) THEN
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: END IF;
864:
865: END IF;
866:

Line 874: x_return_status := FND_API.G_RET_STS_ERROR;

870: p_old_PRICE_LIST_rec.ORIG_SYSTEM_HEADER_REF OR
871: p_old_PRICE_LIST_rec.ORIG_SYSTEM_HEADER_REF IS NULL)
872: THEN
873: IF NOT QP_Validate.orig_system_header_ref(p_PRICE_LIST_rec.ORIG_SYSTEM_HEADER_REF) THEN
874: x_return_status := FND_API.G_RET_STS_ERROR;
875: END IF;
876:
877: END IF;
878:

Line 885: x_return_status := FND_API.G_RET_STS_ERROR;

881: p_old_PRICE_LIST_rec.SOURCE_SYSTEM_CODE OR
882: p_old_PRICE_LIST_rec.SOURCE_SYSTEM_CODE IS NULL)
883: THEN
884: IF NOT QP_Validate.Source_System(p_PRICE_LIST_rec.SOURCE_SYSTEM_CODE) THEN
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: END IF;
887: END IF;
888:
889: IF p_PRICE_LIST_rec.SHAREABLE_FLAG IS NOT NULL AND

Line 895: x_return_status := FND_API.G_RET_STS_ERROR;

891: p_old_PRICE_LIST_rec.SHAREABLE_FLAG OR
892: p_old_PRICE_LIST_rec.SHAREABLE_FLAG IS NULL)
893: THEN
894: IF NOT QP_Validate.shareable_flag(p_PRICE_LIST_rec.SHAREABLE_FLAG) THEN
895: x_return_status := FND_API.G_RET_STS_ERROR;
896: END IF;
897: END IF;
898:
899: IF p_PRICE_LIST_rec.SOLD_TO_ORG_ID IS NOT NULL AND

Line 905: x_return_status := FND_API.G_RET_STS_ERROR;

901: p_old_PRICE_LIST_rec.SOLD_TO_ORG_ID OR
902: p_old_PRICE_LIST_rec.SOLD_TO_ORG_ID IS NULL)
903: THEN
904: IF NOT QP_Validate.sold_to_org_id(p_PRICE_LIST_rec.SOLD_TO_ORG_ID) THEN
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: END IF;
907: END IF;
908:
909: IF p_PRICE_LIST_rec.locked_from_list_header_id IS NOT NULL AND

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911: p_old_PRICE_LIST_rec.locked_from_list_header_id OR
912: p_old_PRICE_LIST_rec.locked_from_list_header_id IS NULL)
913: THEN
914: IF NOT QP_Validate.locked_from_list_header_id(p_PRICE_LIST_rec.locked_from_list_header_id) THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: END IF;
917: END IF;
918:
919: --added for MOAC

Line 926: x_return_status := FND_API.G_RET_STS_ERROR;

922: p_old_PRICE_LIST_rec.org_id OR
923: p_old_PRICE_LIST_rec.org_id IS NULL)
924: THEN
925: IF NOT QP_Validate.org_id(p_PRICE_LIST_rec.org_id) THEN
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: END IF;
928: END IF;
929:
930: IF (p_PRICE_LIST_rec.attribute1 IS NOT NULL AND

Line 1068: x_return_status := FND_API.G_RET_STS_ERROR;

1064:
1065: -- Validate descriptive flexfield.
1066:
1067: IF NOT QP_Validate.Desc_Flex( 'PRICE_LIST' ) THEN
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: END IF;
1070:
1071: END IF;
1072:

Line 1077: WHEN FND_API.G_EXC_ERROR THEN

1073: -- Done validating attributes
1074:
1075: EXCEPTION
1076:
1077: WHEN FND_API.G_EXC_ERROR THEN
1078:
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

1075: EXCEPTION
1076:
1077: WHEN FND_API.G_EXC_ERROR THEN
1078:
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1082:
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1077: WHEN FND_API.G_EXC_ERROR THEN
1078:
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1082:
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084:
1085: WHEN OTHERS THEN

Line 1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1082:
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084:
1085: WHEN OTHERS THEN
1086:
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084:
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

Line 1106: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1102: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1103: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
1104: )
1105: IS
1106: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1107: BEGIN
1108:
1109: -- Validate entity delete.
1110:

Line 1119: WHEN FND_API.G_EXC_ERROR THEN

1115: x_return_status := l_return_status;
1116:
1117: EXCEPTION
1118:
1119: WHEN FND_API.G_EXC_ERROR THEN
1120:
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122:
1123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1121: x_return_status := FND_API.G_RET_STS_ERROR;

1117: EXCEPTION
1118:
1119: WHEN FND_API.G_EXC_ERROR THEN
1120:
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122:
1123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1124:
1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1119: WHEN FND_API.G_EXC_ERROR THEN
1120:
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122:
1123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1124:
1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1126:
1127: WHEN OTHERS THEN

Line 1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122:
1123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1124:
1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1126:
1127: WHEN OTHERS THEN
1128:
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1126:
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