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.OE_VALIDATE_PRICE_LIST_LINE dependencies on FND_API

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

13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
19:
20: -- Check required attributes.
21:

Line 25: l_return_status := FND_API.G_RET_STS_ERROR;

21:
22: IF p_PRICE_LIST_LINE_rec.price_list_line_id IS NULL
23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
26:
27: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:

Line 45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

41:
42:
43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;

Line 47: RAISE FND_API.G_EXC_ERROR;

43: -- Return Error if a required attribute is missing.
44:
45: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
46:
47: RAISE FND_API.G_EXC_ERROR;
48:
49: END IF;
50:
51: --

Line 82: l_return_status := FND_API.G_RET_STS_ERROR;

78: AND
79: OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.end_date_active ,
80: p_old_PRICE_LIST_LINE_rec.end_date_active )
81: THEN
82: l_return_status := FND_API.G_RET_STS_ERROR;
83:
84: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
85: THEN
86: FND_MESSAGE.SET_NAME('OE','OE_ATTRIBUTE_REQUIRED');

Line 95: l_return_status := FND_API.G_RET_STS_SUCCESS;

91: END IF;
92: */
93: ELSE
94: -- attribute changed , revison changed
95: l_return_status := FND_API.G_RET_STS_SUCCESS;
96: /*
97: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
98: THEN
99: FND_MESSAGE.SET_NAME('OE','Changed OE_ATTRIBUTE_REQUIRED');

Line 109: l_return_status := FND_API.G_RET_STS_SUCCESS;

105: end if;
106:
107: ELSE
108: -- revison codes are equal
109: l_return_status := FND_API.G_RET_STS_SUCCESS;
110: /*
111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113: FND_MESSAGE.SET_NAME('OE','Equal OE_ATTRIBUTE_REQUIRED');

Line 122: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

118: end if;
119:
120: x_return_status := l_return_status;
121:
122: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: end if;

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119:
120: x_return_status := l_return_status;
121:
122: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: end if;
127:

Line 124: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN

120: x_return_status := l_return_status;
121:
122: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: end if;
127:
128: -- end added by

Line 125: RAISE FND_API.G_EXC_ERROR;

121:
122: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: end if;
127:
128: -- end added by
129:

Line 134: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

130: Check_PLL_Duplicates( l_return_status,
131: p_PRICE_LIST_LINE_rec ,
132: p_old_PRICE_LIST_LINE_rec );
133:
134: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: end if;

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: p_PRICE_LIST_LINE_rec ,
132: p_old_PRICE_LIST_LINE_rec );
133:
134: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: end if;
139:

Line 136: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN

132: p_old_PRICE_LIST_LINE_rec );
133:
134: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: end if;
139:
140: --

Line 137: RAISE FND_API.G_EXC_ERROR;

133:
134: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: elsif l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: end if;
139:
140: --
141: -- Validate attribute dependencies here.

Line 151: WHEN FND_API.G_EXC_ERROR THEN

147: x_return_status := l_return_status;
148:
149: EXCEPTION
150:
151: WHEN FND_API.G_EXC_ERROR THEN
152:
153: x_return_status := FND_API.G_RET_STS_ERROR;
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149: EXCEPTION
150:
151: WHEN FND_API.G_EXC_ERROR THEN
152:
153: x_return_status := FND_API.G_RET_STS_ERROR;
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

151: WHEN FND_API.G_EXC_ERROR THEN
152:
153: x_return_status := FND_API.G_RET_STS_ERROR;
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158:
159: WHEN OTHERS THEN

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

153: x_return_status := FND_API.G_RET_STS_ERROR;
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158:
159: WHEN OTHERS THEN
160:
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158:
159: WHEN OTHERS THEN
160:
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162:
163: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
164: THEN
165: OE_MSG_PUB.Add_Exc_Msg

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

178: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
179: )
180: IS
181: l_Count NUMBER := 0;
182: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
183: PLL_Duplicates EXCEPTION;
184: BEGIN
185:
186: /* if ( p_PRICE_LIST_LINE_rec.revision is NOT NULL )

Line 217: l_return_status := FND_API.G_RET_STS_ERROR;

213:
214:
215:
216: if l_Count <> 0 then
217: l_return_status := FND_API.G_RET_STS_ERROR;
218: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
219: THEN
220: FND_MESSAGE.SET_NAME('OE','ATTRIBUTE_REQUIRED');
221: FND_MESSAGE.SET_TOKEN('REVISION','revision');

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: IS
255: l_primary_exists BOOLEAN;
256: BEGIN
257:
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: -- Validate PRICE_LIST_LINE attributes
261:
262: IF p_PRICE_LIST_LINE_rec.comments IS NOT NULL AND

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

264: p_old_PRICE_LIST_LINE_rec.comments OR
265: p_old_PRICE_LIST_LINE_rec.comments IS NULL )
266: THEN
267: IF NOT OE_Validate_Attr.Comments(p_PRICE_LIST_LINE_rec.comments) THEN
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: END IF;
270: END IF;
271:
272:

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: p_old_PRICE_LIST_LINE_rec.created_by OR
276: p_old_PRICE_LIST_LINE_rec.created_by IS NULL )
277: THEN
278: IF NOT OE_Validate_Attr.Created_By(p_PRICE_LIST_LINE_rec.created_by) THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: END IF;
281: END IF;
282:
283: IF p_PRICE_LIST_LINE_rec.creation_date IS NOT NULL AND

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: p_old_PRICE_LIST_LINE_rec.creation_date OR
286: p_old_PRICE_LIST_LINE_rec.creation_date IS NULL )
287: THEN
288: IF NOT OE_Validate_Attr.Creation_Date(p_PRICE_LIST_LINE_rec.creation_date) THEN
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: END IF;
291: END IF;
292:
293: IF p_PRICE_LIST_LINE_rec.customer_item_id IS NOT NULL AND

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: p_old_PRICE_LIST_LINE_rec.customer_item_id OR
296: p_old_PRICE_LIST_LINE_rec.customer_item_id IS NULL )
297: THEN
298: IF NOT OE_Validate_Attr.Customer_Item(p_PRICE_LIST_LINE_rec.customer_item_id) THEN
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: END IF;
301: END IF;
302:
303: IF p_PRICE_LIST_LINE_rec.end_date_active IS NOT NULL AND

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

305: p_old_PRICE_LIST_LINE_rec.end_date_active OR
306: p_old_PRICE_LIST_LINE_rec.end_date_active IS NULL )
307: THEN
308: IF NOT OE_Validate_Attr.End_Date_Active(p_Price_List_Line_rec.end_date_active) THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
312: p_Price_List_Line_rec.start_date_active,
313: p_Price_List_Line_rec.end_date_active) THEN

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310:
311: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
312: p_Price_List_Line_rec.start_date_active,
313: p_Price_List_Line_rec.end_date_active) THEN
314: x_return_status := FND_API.G_RET_STS_ERROR;
315:
316: END IF;
317: END IF;
318:

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: p_old_PRICE_LIST_LINE_rec.inventory_item_id OR
322: p_old_PRICE_LIST_LINE_rec.inventory_item_id IS NULL )
323: THEN
324: IF NOT OE_Validate_Attr.Inventory_Item(p_PRICE_LIST_LINE_rec.inventory_item_id) THEN
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: END IF;
327: END IF;
328:
329: IF p_PRICE_LIST_LINE_rec.last_updated_by IS NOT NULL AND

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331: p_old_PRICE_LIST_LINE_rec.last_updated_by OR
332: p_old_PRICE_LIST_LINE_rec.last_updated_by IS NULL )
333: THEN
334: IF NOT OE_Validate_Attr.Last_Updated_By(p_PRICE_LIST_LINE_rec.last_updated_by) THEN
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: END IF;
337: END IF;
338:
339: IF p_PRICE_LIST_LINE_rec.last_update_date IS NOT NULL AND

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

341: p_old_PRICE_LIST_LINE_rec.last_update_date OR
342: p_old_PRICE_LIST_LINE_rec.last_update_date IS NULL )
343: THEN
344: IF NOT OE_Validate_Attr.Last_Update_Date(p_PRICE_LIST_LINE_rec.last_update_date) THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: END IF;
347: END IF;
348:
349: IF p_PRICE_LIST_LINE_rec.last_update_login IS NOT NULL AND

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: p_old_PRICE_LIST_LINE_rec.last_update_login OR
352: p_old_PRICE_LIST_LINE_rec.last_update_login IS NULL )
353: THEN
354: IF NOT OE_Validate_Attr.Last_Update_Login(p_PRICE_LIST_LINE_rec.last_update_login) THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: END IF;
357: END IF;
358:
359: IF p_PRICE_LIST_LINE_rec.list_price IS NOT NULL AND

Line 365: x_return_status := FND_API.G_RET_STS_ERROR;

361: p_old_PRICE_LIST_LINE_rec.list_price OR
362: p_old_PRICE_LIST_LINE_rec.list_price IS NULL )
363: THEN
364: IF NOT OE_Validate_Attr.List_Price(p_PRICE_LIST_LINE_rec.list_price) THEN
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: END IF;
367: END IF;
368:
369: IF p_PRICE_LIST_LINE_rec.method_code IS NOT NULL AND

Line 375: x_return_status := FND_API.G_RET_STS_ERROR;

371: p_old_PRICE_LIST_LINE_rec.method_code OR
372: p_old_PRICE_LIST_LINE_rec.method_code IS NULL )
373: THEN
374: IF NOT OE_Validate_Attr.Method(p_PRICE_LIST_LINE_rec.method_code) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: END IF;
377: END IF;
378:
379: IF p_PRICE_LIST_LINE_rec.price_list_id IS NOT NULL AND

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: p_old_PRICE_LIST_LINE_rec.price_list_id OR
382: p_old_PRICE_LIST_LINE_rec.price_list_id IS NULL )
383: THEN
384: IF NOT OE_Validate_Attr.Price_List(p_PRICE_LIST_LINE_rec.price_list_id) THEN
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: END IF;
387: END IF;
388:
389: IF p_PRICE_LIST_LINE_rec.price_list_line_id IS NOT NULL AND

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391: p_old_PRICE_LIST_LINE_rec.price_list_line_id OR
392: p_old_PRICE_LIST_LINE_rec.price_list_line_id IS NULL )
393: THEN
394: IF NOT OE_Validate_Attr.Price_List_Line(p_PRICE_LIST_LINE_rec.price_list_line_id) THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: END IF;
397: END IF;
398:
399: IF p_PRICE_LIST_LINE_rec.pricing_attribute1 IS NOT NULL AND

Line 405: x_return_status := FND_API.G_RET_STS_ERROR;

401: p_old_PRICE_LIST_LINE_rec.pricing_attribute1 OR
402: p_old_PRICE_LIST_LINE_rec.pricing_attribute1 IS NULL )
403: THEN
404: IF NOT OE_Validate_Attr.Pricing_Attribute1(p_PRICE_LIST_LINE_rec.pricing_attribute1) THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: END IF;
407: END IF;
408:
409: IF p_PRICE_LIST_LINE_rec.pricing_attribute11 IS NOT NULL AND

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

411: p_old_PRICE_LIST_LINE_rec.pricing_attribute11 OR
412: p_old_PRICE_LIST_LINE_rec.pricing_attribute11 IS NULL )
413: THEN
414: IF NOT OE_Validate_Attr.Pricing_Attribute11(p_PRICE_LIST_LINE_rec.pricing_attribute11) THEN
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: END IF;
417: END IF;
418:
419: IF p_PRICE_LIST_LINE_rec.pricing_attribute12 IS NOT NULL AND

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: p_old_PRICE_LIST_LINE_rec.pricing_attribute12 OR
422: p_old_PRICE_LIST_LINE_rec.pricing_attribute12 IS NULL )
423: THEN
424: IF NOT OE_Validate_Attr.Pricing_Attribute12(p_PRICE_LIST_LINE_rec.pricing_attribute12) THEN
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: END IF;
427: END IF;
428:
429: IF p_PRICE_LIST_LINE_rec.pricing_attribute13 IS NOT NULL AND

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: p_old_PRICE_LIST_LINE_rec.pricing_attribute13 OR
432: p_old_PRICE_LIST_LINE_rec.pricing_attribute13 IS NULL )
433: THEN
434: IF NOT OE_Validate_Attr.Pricing_Attribute13(p_PRICE_LIST_LINE_rec.pricing_attribute13) THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: END IF;
437: END IF;
438:
439: IF p_PRICE_LIST_LINE_rec.pricing_attribute14 IS NOT NULL AND

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

441: p_old_PRICE_LIST_LINE_rec.pricing_attribute14 OR
442: p_old_PRICE_LIST_LINE_rec.pricing_attribute14 IS NULL )
443: THEN
444: IF NOT OE_Validate_Attr.Pricing_Attribute14(p_PRICE_LIST_LINE_rec.pricing_attribute14) THEN
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: END IF;
447: END IF;
448:
449: IF p_PRICE_LIST_LINE_rec.pricing_attribute15 IS NOT NULL AND

Line 455: x_return_status := FND_API.G_RET_STS_ERROR;

451: p_old_PRICE_LIST_LINE_rec.pricing_attribute15 OR
452: p_old_PRICE_LIST_LINE_rec.pricing_attribute15 IS NULL )
453: THEN
454: IF NOT OE_Validate_Attr.Pricing_Attribute15(p_PRICE_LIST_LINE_rec.pricing_attribute15) THEN
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: END IF;
457: END IF;
458:
459:

Line 466: x_return_status := FND_API.G_RET_STS_ERROR;

462: p_old_PRICE_LIST_LINE_rec.pricing_attribute2 OR
463: p_old_PRICE_LIST_LINE_rec.pricing_attribute2 IS NULL )
464: THEN
465: IF NOT OE_Validate_Attr.Pricing_Attribute2(p_PRICE_LIST_LINE_rec.pricing_attribute2) THEN
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: END IF;
468: END IF;
469:
470: IF p_PRICE_LIST_LINE_rec.pricing_attribute3 IS NOT NULL AND

Line 476: x_return_status := FND_API.G_RET_STS_ERROR;

472: p_old_PRICE_LIST_LINE_rec.pricing_attribute3 OR
473: p_old_PRICE_LIST_LINE_rec.pricing_attribute3 IS NULL )
474: THEN
475: IF NOT OE_Validate_Attr.Pricing_Attribute3(p_PRICE_LIST_LINE_rec.pricing_attribute3) THEN
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: END IF;
478: END IF;
479:
480: IF p_PRICE_LIST_LINE_rec.pricing_attribute4 IS NOT NULL AND

Line 486: x_return_status := FND_API.G_RET_STS_ERROR;

482: p_old_PRICE_LIST_LINE_rec.pricing_attribute4 OR
483: p_old_PRICE_LIST_LINE_rec.pricing_attribute4 IS NULL )
484: THEN
485: IF NOT OE_Validate_Attr.Pricing_Attribute4(p_PRICE_LIST_LINE_rec.pricing_attribute4) THEN
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: END IF;
488: END IF;
489:
490: IF p_PRICE_LIST_LINE_rec.pricing_attribute5 IS NOT NULL AND

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: p_old_PRICE_LIST_LINE_rec.pricing_attribute5 OR
493: p_old_PRICE_LIST_LINE_rec.pricing_attribute5 IS NULL )
494: THEN
495: IF NOT OE_Validate_Attr.Pricing_Attribute5(p_PRICE_LIST_LINE_rec.pricing_attribute5) THEN
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: END IF;
498: END IF;
499:
500:

Line 507: x_return_status := FND_API.G_RET_STS_ERROR;

503: p_old_PRICE_LIST_LINE_rec.pricing_attribute6 OR
504: p_old_PRICE_LIST_LINE_rec.pricing_attribute6 IS NULL )
505: THEN
506: IF NOT OE_Validate_Attr.Pricing_Attribute6(p_PRICE_LIST_LINE_rec.pricing_attribute6) THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: END IF;
509: END IF;
510:
511: IF p_PRICE_LIST_LINE_rec.pricing_attribute7 IS NOT NULL AND

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: p_old_PRICE_LIST_LINE_rec.pricing_attribute7 OR
514: p_old_PRICE_LIST_LINE_rec.pricing_attribute7 IS NULL )
515: THEN
516: IF NOT OE_Validate_Attr.Pricing_Attribute7(p_PRICE_LIST_LINE_rec.pricing_attribute7) THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: END IF;
519: END IF;
520:
521: IF p_PRICE_LIST_LINE_rec.pricing_attribute8 IS NOT NULL AND

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: p_old_PRICE_LIST_LINE_rec.pricing_attribute8 OR
524: p_old_PRICE_LIST_LINE_rec.pricing_attribute8 IS NULL )
525: THEN
526: IF NOT OE_Validate_Attr.Pricing_Attribute8(p_PRICE_LIST_LINE_rec.pricing_attribute8) THEN
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: END IF;
529: END IF;
530:
531: IF p_PRICE_LIST_LINE_rec.pricing_attribute9 IS NOT NULL AND

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

533: p_old_PRICE_LIST_LINE_rec.pricing_attribute9 OR
534: p_old_PRICE_LIST_LINE_rec.pricing_attribute9 IS NULL )
535: THEN
536: IF NOT OE_Validate_Attr.Pricing_Attribute9(p_PRICE_LIST_LINE_rec.pricing_attribute9) THEN
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539: END IF;
540:
541: IF p_PRICE_LIST_LINE_rec.pricing_context IS NOT NULL AND

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: p_old_PRICE_LIST_LINE_rec.pricing_context OR
544: p_old_PRICE_LIST_LINE_rec.pricing_context IS NULL )
545: THEN
546: IF NOT OE_Validate_Attr.Pricing_Context(p_PRICE_LIST_LINE_rec.pricing_context) THEN
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;
550:
551: IF p_PRICE_LIST_LINE_rec.pricing_rule_id IS NOT NULL AND

Line 557: x_return_status := FND_API.G_RET_STS_ERROR;

553: p_old_PRICE_LIST_LINE_rec.pricing_rule_id OR
554: p_old_PRICE_LIST_LINE_rec.pricing_rule_id IS NULL )
555: THEN
556: IF NOT OE_Validate_Attr.Pricing_Rule(p_PRICE_LIST_LINE_rec.pricing_rule_id) THEN
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: END IF;
559: END IF;
560:
561: IF p_PRICE_LIST_LINE_rec.primary IS NOT NULL AND

Line 567: x_return_status := FND_API.G_RET_STS_ERROR;

563: p_old_PRICE_LIST_LINE_rec.primary OR
564: p_old_PRICE_LIST_LINE_rec.primary IS NULL )
565: THEN
566: IF NOT OE_Validate_Attr.Primary(p_PRICE_LIST_LINE_rec.primary) THEN
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: END IF;
569: END IF;
570:
571: IF p_PRICE_LIST_LINE_rec.program_application_id IS NOT NULL AND

Line 577: x_return_status := FND_API.G_RET_STS_ERROR;

573: p_old_PRICE_LIST_LINE_rec.program_application_id OR
574: p_old_PRICE_LIST_LINE_rec.program_application_id IS NULL )
575: THEN
576: IF NOT OE_Validate_Attr.Program_Application(p_PRICE_LIST_LINE_rec.program_application_id) THEN
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: END IF;
579: END IF;
580:
581: IF p_PRICE_LIST_LINE_rec.program_id IS NOT NULL AND

Line 587: x_return_status := FND_API.G_RET_STS_ERROR;

583: p_old_PRICE_LIST_LINE_rec.program_id OR
584: p_old_PRICE_LIST_LINE_rec.program_id IS NULL )
585: THEN
586: IF NOT OE_Validate_Attr.Program(p_PRICE_LIST_LINE_rec.program_id) THEN
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: END IF;
589: END IF;
590:
591: IF p_PRICE_LIST_LINE_rec.program_update_date IS NOT NULL AND

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593: p_old_PRICE_LIST_LINE_rec.program_update_date OR
594: p_old_PRICE_LIST_LINE_rec.program_update_date IS NULL )
595: THEN
596: IF NOT OE_Validate_Attr.Program_Update_Date(p_PRICE_LIST_LINE_rec.program_update_date) THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: END IF;
599: END IF;
600:
601: IF p_PRICE_LIST_LINE_rec.reprice_flag IS NOT NULL AND

Line 607: x_return_status := FND_API.G_RET_STS_ERROR;

603: p_old_PRICE_LIST_LINE_rec.reprice_flag OR
604: p_old_PRICE_LIST_LINE_rec.reprice_flag IS NULL )
605: THEN
606: IF NOT OE_Validate_Attr.Reprice(p_PRICE_LIST_LINE_rec.reprice_flag) THEN
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: END IF;
609: END IF;
610:
611: IF p_PRICE_LIST_LINE_rec.request_id IS NOT NULL AND

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613: p_old_PRICE_LIST_LINE_rec.request_id OR
614: p_old_PRICE_LIST_LINE_rec.request_id IS NULL )
615: THEN
616: IF NOT OE_Validate_Attr.Request(p_PRICE_LIST_LINE_rec.request_id) THEN
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: END IF;
619: END IF;
620:
621: IF p_PRICE_LIST_LINE_rec.revision IS NOT NULL AND

Line 627: x_return_status := FND_API.G_RET_STS_ERROR;

623: p_old_PRICE_LIST_LINE_rec.revision OR
624: p_old_PRICE_LIST_LINE_rec.revision IS NULL )
625: THEN
626: IF NOT OE_Validate_Attr.Revision(p_PRICE_LIST_LINE_rec.revision) THEN
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: END IF;
629: END IF;
630:
631: IF p_PRICE_LIST_LINE_rec.revision_date IS NOT NULL AND

Line 637: x_return_status := FND_API.G_RET_STS_ERROR;

633: p_old_PRICE_LIST_LINE_rec.revision_date OR
634: p_old_PRICE_LIST_LINE_rec.revision_date IS NULL )
635: THEN
636: IF NOT OE_Validate_Attr.Revision_Date(p_PRICE_LIST_LINE_rec.revision_date) THEN
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: END IF;
639: END IF;
640:
641: IF p_PRICE_LIST_LINE_rec.revision_reason_code IS NOT NULL AND

Line 647: x_return_status := FND_API.G_RET_STS_ERROR;

643: p_old_PRICE_LIST_LINE_rec.revision_reason_code OR
644: p_old_PRICE_LIST_LINE_rec.revision_reason_code IS NULL )
645: THEN
646: IF NOT OE_Validate_Attr.Revision_Reason(p_PRICE_LIST_LINE_rec.revision_reason_code) THEN
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: END IF;
649: END IF;
650:
651: IF p_PRICE_LIST_LINE_rec.start_date_active IS NOT NULL AND

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653: p_old_PRICE_LIST_LINE_rec.start_date_active OR
654: p_old_PRICE_LIST_LINE_rec.start_date_active IS NULL )
655: THEN
656: IF NOT OE_Validate_Attr.Start_Date_Active(p_PRICE_LIST_LINE_rec.start_date_active) THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
659: p_Price_List_Line_rec.start_date_active,
660: p_Price_List_Line_rec.end_date_active) THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: x_return_status := FND_API.G_RET_STS_ERROR;
658: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
659: p_Price_List_Line_rec.start_date_active,
660: p_Price_List_Line_rec.end_date_active) THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;
663: END IF;
664:
665: IF p_PRICE_LIST_LINE_rec.unit_code IS NOT NULL AND

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667: p_old_PRICE_LIST_LINE_rec.unit_code OR
668: p_old_PRICE_LIST_LINE_rec.unit_code IS NULL )
669: THEN
670: IF NOT OE_Validate_Attr.Unit(p_PRICE_LIST_LINE_rec.unit_code) THEN
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: END IF;
673: END IF;
674:
675: IF p_PRICE_LIST_LINE_rec.list_line_type_code IS NOT NULL AND

Line 681: x_return_status := FND_API.G_RET_STS_ERROR;

677: p_old_PRICE_LIST_LINE_rec.list_line_type_code OR
678: p_old_PRICE_LIST_LINE_rec.list_line_type_code IS NULL )
679: THEN
680: IF NOT OE_Validate_Attr.List_Line_Type(p_PRICE_LIST_LINE_rec.list_line_type_code) THEN
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: END IF;
683: END IF;
684:
685:

Line 824: x_return_status := FND_API.G_RET_STS_ERROR;

820:
821: -- Validate descriptive flexfield.
822:
823: IF NOT OE_Validate_Attr.Desc_Flex( 'SO_PRICE_LIST_LINES' ) THEN
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: END IF;
826:
827: END IF;
828:

Line 927: x_return_status := FND_API.G_RET_STS_ERROR;

923:
924: -- Validate descriptive flexfield.
925:
926: IF NOT OE_Validate_Attr.Desc_Flex( 'PRICING_ATTRIBUTES' ) THEN
927: x_return_status := FND_API.G_RET_STS_ERROR;
928: END IF;
929:
930: END IF;
931:

Line 967: x_return_status := FND_API.G_RET_STS_ERROR;

963:
964: IF p_Price_List_Line_rec.primary = 'Y' THEN
965:
966: IF l_primary_exists THEN
967: x_return_status := FND_API.G_RET_STS_ERROR;
968:
969: END IF;
970:
971: ELSIF p_Price_List_Line_rec.primary = 'N' THEN

Line 974: x_return_status := FND_API.G_RET_STS_ERROR;

970:
971: ELSIF p_Price_List_Line_rec.primary = 'N' THEN
972:
973: IF (NOT l_primary_exists) THEN
974: x_return_status := FND_API.G_RET_STS_ERROR;
975: END IF;
976:
977: END IF;
978:

Line 982: x_return_status := FND_API.G_RET_STS_ERROR;

978:
979:
980: /*
981: ELSIF NOT OE_Validate_Attr.PRIMARY(p_Price_List_Line_rec.primary) THEN
982: x_return_status := FND_API.G_RET_STS_ERROR;
983: END IF;
984: */
985:
986: END IF;

Line 994: WHEN FND_API.G_EXC_ERROR THEN

990: -- Done validating attributes
991:
992: EXCEPTION
993:
994: WHEN FND_API.G_EXC_ERROR THEN
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: EXCEPTION
993:
994: WHEN FND_API.G_EXC_ERROR THEN
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
999:
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

994: WHEN FND_API.G_EXC_ERROR THEN
995:
996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
999:
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001:
1002: WHEN OTHERS THEN

Line 1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

996: x_return_status := FND_API.G_RET_STS_ERROR;
997:
998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
999:
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001:
1002: WHEN OTHERS THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001:
1002: WHEN OTHERS THEN
1003:
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005:
1006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1007: THEN
1008: OE_MSG_PUB.Add_Exc_Msg

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

1019: ( x_return_status OUT VARCHAR2
1020: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1021: )
1022: IS
1023: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1024: BEGIN
1025:
1026: -- Validate entity delete.
1027:

Line 1036: WHEN FND_API.G_EXC_ERROR THEN

1032: x_return_status := l_return_status;
1033:
1034: EXCEPTION
1035:
1036: WHEN FND_API.G_EXC_ERROR THEN
1037:
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039:
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1038: x_return_status := FND_API.G_RET_STS_ERROR;

1034: EXCEPTION
1035:
1036: WHEN FND_API.G_EXC_ERROR THEN
1037:
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039:
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041:
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1036: WHEN FND_API.G_EXC_ERROR THEN
1037:
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039:
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041:
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043:
1044: WHEN OTHERS THEN

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039:
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041:
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043:
1044: WHEN OTHERS THEN
1045:
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043:
1044: WHEN OTHERS THEN
1045:
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1047:
1048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1049: THEN
1050: OE_MSG_PUB.Add_Exc_Msg