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_BREAK dependencies on FND_API

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

13: , p_old_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type :=
14: OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_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 28: l_return_status := FND_API.G_RET_STS_ERROR;

24: OR p_Price_Break_rec.price_break_high IS NULL
25: OR p_Price_Break_rec.price_break_low IS NULL
26: THEN
27:
28: l_return_status := FND_API.G_RET_STS_ERROR;
29:
30: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
31: THEN
32:

Line 48: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 50: RAISE FND_API.G_EXC_ERROR;

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

Line 70: WHEN FND_API.G_EXC_ERROR THEN

66: x_return_status := l_return_status;
67:
68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71:
72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: EXCEPTION
69:
70: WHEN FND_API.G_EXC_ERROR THEN
71:
72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

70: WHEN FND_API.G_EXC_ERROR THEN
71:
72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: WHEN OTHERS THEN

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: x_return_status := FND_API.G_RET_STS_ERROR;
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75:
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: WHEN OTHERS THEN
79:
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: WHEN OTHERS THEN
79:
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81:
82: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
83: THEN
84: OE_MSG_PUB.Add_Exc_Msg

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: )
100: IS
101: BEGIN
102:
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104:
105: -- Validate Price_Break attributes
106:
107: IF p_Price_Break_rec.amount IS NOT NULL AND

Line 113: x_return_status := FND_API.G_RET_STS_ERROR;

109: p_old_Price_Break_rec.amount OR
110: p_old_Price_Break_rec.amount IS NULL )
111: THEN
112: IF NOT OE_Validate_Attr.Amount(p_Price_Break_rec.amount) THEN
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: END IF;
115: END IF;
116:
117: IF p_Price_Break_rec.created_by IS NOT NULL AND

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: p_old_Price_Break_rec.created_by OR
120: p_old_Price_Break_rec.created_by IS NULL )
121: THEN
122: IF NOT OE_Validate_Attr.Created_By(p_Price_Break_rec.created_by) THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: END IF;
125: END IF;
126:
127: IF p_Price_Break_rec.creation_date IS NOT NULL AND

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: p_old_Price_Break_rec.creation_date OR
130: p_old_Price_Break_rec.creation_date IS NULL )
131: THEN
132: IF NOT OE_Validate_Attr.Creation_Date(p_Price_Break_rec.creation_date) THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: END IF;
135: END IF;
136:
137: IF p_Price_Break_rec.discount_line_id IS NOT NULL AND

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139: p_old_Price_Break_rec.discount_line_id OR
140: p_old_Price_Break_rec.discount_line_id IS NULL )
141: THEN
142: IF NOT OE_Validate_Attr.Discount_Line(p_Price_Break_rec.discount_line_id) THEN
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: END IF;
145: END IF;
146:
147: IF p_Price_Break_rec.end_date_active IS NOT NULL AND

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149: p_old_Price_Break_rec.end_date_active OR
150: p_old_Price_Break_rec.end_date_active IS NULL )
151: THEN
152: IF NOT OE_Validate_Attr.End_Date_Active(p_Price_Break_rec.end_date_active) THEN
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: END IF;
155: END IF;
156:
157: IF p_Price_Break_rec.last_updated_by IS NOT NULL AND

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

159: p_old_Price_Break_rec.last_updated_by OR
160: p_old_Price_Break_rec.last_updated_by IS NULL )
161: THEN
162: IF NOT OE_Validate_Attr.Last_Updated_By(p_Price_Break_rec.last_updated_by) THEN
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: END IF;
165: END IF;
166:
167: IF p_Price_Break_rec.last_update_date IS NOT NULL AND

Line 173: x_return_status := FND_API.G_RET_STS_ERROR;

169: p_old_Price_Break_rec.last_update_date OR
170: p_old_Price_Break_rec.last_update_date IS NULL )
171: THEN
172: IF NOT OE_Validate_Attr.Last_Update_Date(p_Price_Break_rec.last_update_date) THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: END IF;
175: END IF;
176:
177: IF p_Price_Break_rec.last_update_login IS NOT NULL AND

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: p_old_Price_Break_rec.last_update_login OR
180: p_old_Price_Break_rec.last_update_login IS NULL )
181: THEN
182: IF NOT OE_Validate_Attr.Last_Update_Login(p_Price_Break_rec.last_update_login) THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: END IF;
185: END IF;
186:
187: IF p_Price_Break_rec.method_type_code IS NOT NULL AND

Line 193: x_return_status := FND_API.G_RET_STS_ERROR;

189: p_old_Price_Break_rec.method_type_code OR
190: p_old_Price_Break_rec.method_type_code IS NULL )
191: THEN
192: IF NOT OE_Validate_Attr.Method_Type(p_Price_Break_rec.method_type_code) THEN
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: END IF;
195: END IF;
196:
197: IF p_Price_Break_rec.percent IS NOT NULL AND

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199: p_old_Price_Break_rec.percent OR
200: p_old_Price_Break_rec.percent IS NULL )
201: THEN
202: IF NOT OE_Validate_Attr.Percent(p_Price_Break_rec.percent) THEN
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END IF;
205: END IF;
206:
207: IF p_Price_Break_rec.price IS NOT NULL AND

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209: p_old_Price_Break_rec.price OR
210: p_old_Price_Break_rec.price IS NULL )
211: THEN
212: IF NOT OE_Validate_Attr.Price(p_Price_Break_rec.price) THEN
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: END IF;
215: END IF;
216:
217: IF p_Price_Break_rec.price_break_high IS NOT NULL AND

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: p_old_Price_Break_rec.price_break_high OR
220: p_old_Price_Break_rec.price_break_high IS NULL )
221: THEN
222: IF NOT OE_Validate_Attr.Price_Break_High(p_Price_Break_rec.price_break_high) THEN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: END IF;
225: END IF;
226:
227: IF p_Price_Break_rec.price_break_low IS NOT NULL AND

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: p_old_Price_Break_rec.price_break_low OR
230: p_old_Price_Break_rec.price_break_low IS NULL )
231: THEN
232: IF NOT OE_Validate_Attr.Price_Break_Low(p_Price_Break_rec.price_break_low) THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: END IF;
235: END IF;
236:
237: IF p_Price_Break_rec.program_application_id IS NOT NULL AND

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: p_old_Price_Break_rec.program_application_id OR
240: p_old_Price_Break_rec.program_application_id IS NULL )
241: THEN
242: IF NOT OE_Validate_Attr.Program_Application(p_Price_Break_rec.program_application_id) THEN
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;
245: END IF;
246:
247: IF p_Price_Break_rec.program_id IS NOT NULL AND

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: p_old_Price_Break_rec.program_id OR
250: p_old_Price_Break_rec.program_id IS NULL )
251: THEN
252: IF NOT OE_Validate_Attr.Program(p_Price_Break_rec.program_id) THEN
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: END IF;
255: END IF;
256:
257: IF p_Price_Break_rec.program_update_date IS NOT NULL AND

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: p_old_Price_Break_rec.program_update_date OR
260: p_old_Price_Break_rec.program_update_date IS NULL )
261: THEN
262: IF NOT OE_Validate_Attr.Program_Update_Date(p_Price_Break_rec.program_update_date) THEN
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: END IF;
265: END IF;
266:
267: IF p_Price_Break_rec.request_id IS NOT NULL AND

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: p_old_Price_Break_rec.request_id OR
270: p_old_Price_Break_rec.request_id IS NULL )
271: THEN
272: IF NOT OE_Validate_Attr.Request(p_Price_Break_rec.request_id) THEN
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: END IF;
275: END IF;
276:
277: IF p_Price_Break_rec.start_date_active IS NOT NULL AND

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: p_old_Price_Break_rec.start_date_active OR
280: p_old_Price_Break_rec.start_date_active IS NULL )
281: THEN
282: IF NOT OE_Validate_Attr.Start_Date_Active(p_Price_Break_rec.start_date_active) THEN
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: END IF;
285: END IF;
286:
287: IF p_Price_Break_rec.unit_code IS NOT NULL AND

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289: p_old_Price_Break_rec.unit_code OR
290: p_old_Price_Break_rec.unit_code IS NULL )
291: THEN
292: IF NOT OE_Validate_Attr.Unit(p_Price_Break_rec.unit_code) THEN
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: END IF;
295: END IF;
296:
297: IF (p_Price_Break_rec.attribute1 IS NOT NULL AND

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431:
432: -- Validate descriptive flexfield.
433:
434: IF NOT OE_Validate_Attr.Desc_Flex( 'PRICE_BREAK' ) THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: END IF;
437:
438: END IF;
439:

Line 444: WHEN FND_API.G_EXC_ERROR THEN

440: -- Done validating attributes
441:
442: EXCEPTION
443:
444: WHEN FND_API.G_EXC_ERROR THEN
445:
446: x_return_status := FND_API.G_RET_STS_ERROR;
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 446: x_return_status := FND_API.G_RET_STS_ERROR;

442: EXCEPTION
443:
444: WHEN FND_API.G_EXC_ERROR THEN
445:
446: x_return_status := FND_API.G_RET_STS_ERROR;
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
449:
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

444: WHEN FND_API.G_EXC_ERROR THEN
445:
446: x_return_status := FND_API.G_RET_STS_ERROR;
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
449:
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451:
452: WHEN OTHERS THEN

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

446: x_return_status := FND_API.G_RET_STS_ERROR;
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
449:
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451:
452: WHEN OTHERS THEN
453:
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451:
452: WHEN OTHERS THEN
453:
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455:
456: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: OE_MSG_PUB.Add_Exc_Msg

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

469: ( x_return_status OUT VARCHAR2
470: , p_Price_Break_rec IN OE_Pricing_Cont_PUB.Price_Break_Rec_Type
471: )
472: IS
473: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
474: BEGIN
475:
476: -- Validate entity delete.
477:

Line 486: WHEN FND_API.G_EXC_ERROR THEN

482: x_return_status := l_return_status;
483:
484: EXCEPTION
485:
486: WHEN FND_API.G_EXC_ERROR THEN
487:
488: x_return_status := FND_API.G_RET_STS_ERROR;
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484: EXCEPTION
485:
486: WHEN FND_API.G_EXC_ERROR THEN
487:
488: x_return_status := FND_API.G_RET_STS_ERROR;
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491:
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

486: WHEN FND_API.G_EXC_ERROR THEN
487:
488: x_return_status := FND_API.G_RET_STS_ERROR;
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491:
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493:
494: WHEN OTHERS THEN

Line 492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

488: x_return_status := FND_API.G_RET_STS_ERROR;
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491:
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493:
494: WHEN OTHERS THEN
495:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493:
494: WHEN OTHERS THEN
495:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497:
498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: OE_MSG_PUB.Add_Exc_Msg