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

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

13: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_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 26: l_return_status := FND_API.G_RET_STS_ERROR;

22: IF p_PRICE_LIST_rec.name IS NULL
23: OR p_PRICE_LIST_rec.price_list_id IS NULL
24: THEN
25:
26: l_return_status := FND_API.G_RET_STS_ERROR;
27:
28: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
29: THEN
30:

Line 46: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 48: RAISE FND_API.G_EXC_ERROR;

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

Line 68: WHEN FND_API.G_EXC_ERROR THEN

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

Line 70: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 72: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: )
98: IS
99: BEGIN
100:
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: -- Validate PRICE_LIST attributes
104:
105: IF p_PRICE_LIST_rec.comments IS NOT NULL AND

Line 111: x_return_status := FND_API.G_RET_STS_ERROR;

107: p_old_PRICE_LIST_rec.comments OR
108: p_old_PRICE_LIST_rec.comments IS NULL )
109: THEN
110: IF NOT OE_Validate_Attr.Comments(p_PRICE_LIST_rec.comments) THEN
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: END IF;
113: END IF;
114:
115: IF p_PRICE_LIST_rec.created_by IS NOT NULL AND

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: p_old_PRICE_LIST_rec.created_by OR
118: p_old_PRICE_LIST_rec.created_by IS NULL )
119: THEN
120: IF NOT OE_Validate_Attr.Created_By(p_PRICE_LIST_rec.created_by) THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: END IF;
123: END IF;
124:
125: IF p_PRICE_LIST_rec.creation_date IS NOT NULL AND

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: p_old_PRICE_LIST_rec.creation_date OR
128: p_old_PRICE_LIST_rec.creation_date IS NULL )
129: THEN
130: IF NOT OE_Validate_Attr.Creation_Date(p_PRICE_LIST_rec.creation_date) THEN
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: END IF;
133: END IF;
134:
135: IF p_PRICE_LIST_rec.currency_code IS NOT NULL AND

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

137: p_old_PRICE_LIST_rec.currency_code OR
138: p_old_PRICE_LIST_rec.currency_code IS NULL )
139: THEN
140: IF NOT OE_Validate_Attr.Currency(p_PRICE_LIST_rec.currency_code) THEN
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: END IF;
143: END IF;
144:
145: IF p_PRICE_LIST_rec.description IS NOT NULL AND

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: p_old_PRICE_LIST_rec.description OR
148: p_old_PRICE_LIST_rec.description IS NULL )
149: THEN
150: IF NOT OE_Validate_Attr.Description(p_PRICE_LIST_rec.description) THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153: END IF;
154:
155: IF p_PRICE_LIST_rec.end_date_active IS NOT NULL AND

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: p_old_PRICE_LIST_rec.end_date_active OR
158: p_old_PRICE_LIST_rec.end_date_active IS NULL )
159: THEN
160: IF NOT OE_Validate_Attr.End_Date_Active(p_PRICE_LIST_rec.end_date_active) THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: END IF;
163: END IF;
164:
165: IF p_PRICE_LIST_rec.freight_terms_code IS NOT NULL AND

Line 171: x_return_status := FND_API.G_RET_STS_ERROR;

167: p_old_PRICE_LIST_rec.freight_terms_code OR
168: p_old_PRICE_LIST_rec.freight_terms_code IS NULL )
169: THEN
170: IF NOT OE_Validate_Attr.Freight_Terms(p_PRICE_LIST_rec.freight_terms_code) THEN
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: END IF;
173: END IF;
174:
175: IF p_PRICE_LIST_rec.last_updated_by IS NOT NULL AND

Line 181: x_return_status := FND_API.G_RET_STS_ERROR;

177: p_old_PRICE_LIST_rec.last_updated_by OR
178: p_old_PRICE_LIST_rec.last_updated_by IS NULL )
179: THEN
180: IF NOT OE_Validate_Attr.Last_Updated_By(p_PRICE_LIST_rec.last_updated_by) THEN
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END IF;
183: END IF;
184:
185: IF p_PRICE_LIST_rec.last_update_date IS NOT NULL AND

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187: p_old_PRICE_LIST_rec.last_update_date OR
188: p_old_PRICE_LIST_rec.last_update_date IS NULL )
189: THEN
190: IF NOT OE_Validate_Attr.Last_Update_Date(p_PRICE_LIST_rec.last_update_date) THEN
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: END IF;
193: END IF;
194:
195: IF p_PRICE_LIST_rec.last_update_login IS NOT NULL AND

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197: p_old_PRICE_LIST_rec.last_update_login OR
198: p_old_PRICE_LIST_rec.last_update_login IS NULL )
199: THEN
200: IF NOT OE_Validate_Attr.Last_Update_Login(p_PRICE_LIST_rec.last_update_login) THEN
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: END IF;
203: END IF;
204:
205: IF p_PRICE_LIST_rec.name IS NOT NULL AND

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: p_old_PRICE_LIST_rec.name OR
208: p_old_PRICE_LIST_rec.name IS NULL )
209: THEN
210: IF NOT OE_Validate_Attr.Name(p_PRICE_LIST_rec.name) THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: END IF;
213: END IF;
214:
215: IF p_PRICE_LIST_rec.price_list_id IS NOT NULL AND

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: p_old_PRICE_LIST_rec.price_list_id OR
218: p_old_PRICE_LIST_rec.price_list_id IS NULL )
219: THEN
220: IF NOT OE_Validate_Attr.Price_List(p_PRICE_LIST_rec.price_list_id) THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: END IF;
223: END IF;
224:
225: IF p_PRICE_LIST_rec.program_application_id IS NOT NULL AND

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: p_old_PRICE_LIST_rec.program_application_id OR
228: p_old_PRICE_LIST_rec.program_application_id IS NULL )
229: THEN
230: IF NOT OE_Validate_Attr.Program_Application(p_PRICE_LIST_rec.program_application_id) THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: END IF;
233: END IF;
234:
235: IF p_PRICE_LIST_rec.program_id IS NOT NULL AND

Line 241: x_return_status := FND_API.G_RET_STS_ERROR;

237: p_old_PRICE_LIST_rec.program_id OR
238: p_old_PRICE_LIST_rec.program_id IS NULL )
239: THEN
240: IF NOT OE_Validate_Attr.Program(p_PRICE_LIST_rec.program_id) THEN
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: END IF;
243: END IF;
244:
245: IF p_PRICE_LIST_rec.program_update_date IS NOT NULL AND

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: p_old_PRICE_LIST_rec.program_update_date OR
248: p_old_PRICE_LIST_rec.program_update_date IS NULL )
249: THEN
250: IF NOT OE_Validate_Attr.Program_Update_Date(p_PRICE_LIST_rec.program_update_date) THEN
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: END IF;
253: END IF;
254:
255: IF p_PRICE_LIST_rec.request_id IS NOT NULL AND

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: p_old_PRICE_LIST_rec.request_id OR
258: p_old_PRICE_LIST_rec.request_id IS NULL )
259: THEN
260: IF NOT OE_Validate_Attr.Request(p_PRICE_LIST_rec.request_id) THEN
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: END IF;
263: END IF;
264:
265: IF p_PRICE_LIST_rec.rounding_factor IS NOT NULL AND

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: p_old_PRICE_LIST_rec.rounding_factor OR
268: p_old_PRICE_LIST_rec.rounding_factor IS NULL )
269: THEN
270: IF NOT OE_Validate_Attr.Rounding_Factor(p_PRICE_LIST_rec.rounding_factor) THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273: END IF;
274:
275: IF p_PRICE_LIST_rec.secondary_price_list_id IS NOT NULL AND

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

277: p_old_PRICE_LIST_rec.secondary_price_list_id OR
278: p_old_PRICE_LIST_rec.secondary_price_list_id IS NULL )
279: THEN
280: IF NOT OE_Validate_Attr.Secondary_Price_List(p_PRICE_LIST_rec.secondary_price_list_id) THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: END IF;
283: END IF;
284:
285: IF p_PRICE_LIST_rec.ship_method_code IS NOT NULL AND

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: p_old_PRICE_LIST_rec.ship_method_code OR
288: p_old_PRICE_LIST_rec.ship_method_code IS NULL )
289: THEN
290: IF NOT OE_Validate_Attr.Ship_Method(p_PRICE_LIST_rec.ship_method_code) THEN
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: END IF;
293: END IF;
294:
295: IF p_PRICE_LIST_rec.start_date_active IS NOT NULL AND

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297: p_old_PRICE_LIST_rec.start_date_active OR
298: p_old_PRICE_LIST_rec.start_date_active IS NULL )
299: THEN
300: IF NOT OE_Validate_Attr.Start_Date_Active(p_PRICE_LIST_rec.start_date_active) THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: END IF;
303: END IF;
304:
305: IF p_PRICE_LIST_rec.terms_id IS NOT NULL AND

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: p_old_PRICE_LIST_rec.terms_id OR
308: p_old_PRICE_LIST_rec.terms_id IS NULL )
309: THEN
310: IF NOT OE_Validate_Attr.Terms(p_PRICE_LIST_rec.terms_id) THEN
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: END IF;
313: END IF;
314:
315: IF (p_PRICE_LIST_rec.attribute1 IS NOT NULL AND

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

449:
450: -- Validate descriptive flexfield.
451:
452: IF NOT OE_Validate_Attr.Desc_Flex( 'SO_PRICE_LISTS' ) THEN
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: END IF;
455:
456: END IF;
457:

Line 462: WHEN FND_API.G_EXC_ERROR THEN

458: -- Done validating attributes
459:
460: EXCEPTION
461:
462: WHEN FND_API.G_EXC_ERROR THEN
463:
464: x_return_status := FND_API.G_RET_STS_ERROR;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 464: x_return_status := FND_API.G_RET_STS_ERROR;

460: EXCEPTION
461:
462: WHEN FND_API.G_EXC_ERROR THEN
463:
464: x_return_status := FND_API.G_RET_STS_ERROR;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: WHEN FND_API.G_EXC_ERROR THEN
463:
464: x_return_status := FND_API.G_RET_STS_ERROR;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: WHEN OTHERS THEN

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464: x_return_status := FND_API.G_RET_STS_ERROR;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: WHEN OTHERS THEN
471:
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469:
470: WHEN OTHERS THEN
471:
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473:
474: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
475: THEN
476: OE_MSG_PUB.Add_Exc_Msg

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

487: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
488: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
489: )
490: IS
491: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
492: BEGIN
493:
494: -- Validate entity delete.
495:

Line 504: WHEN FND_API.G_EXC_ERROR THEN

500: x_return_status := l_return_status;
501:
502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505:
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505:
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509:
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

504: WHEN FND_API.G_EXC_ERROR THEN
505:
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509:
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511:
512: WHEN OTHERS THEN

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509:
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511:
512: WHEN OTHERS THEN
513:
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511:
512: WHEN OTHERS THEN
513:
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515:
516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: OE_MSG_PUB.Add_Exc_Msg