106: ( p_PRICE_LIST_rec.comments <>
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:
116: ( p_PRICE_LIST_rec.created_by <>
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:
126: ( p_PRICE_LIST_rec.creation_date <>
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:
136: ( p_PRICE_LIST_rec.currency_code <>
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:
146: ( p_PRICE_LIST_rec.description <>
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:
156: ( p_PRICE_LIST_rec.end_date_active <>
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:
166: ( p_PRICE_LIST_rec.freight_terms_code <>
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:
176: ( p_PRICE_LIST_rec.last_updated_by <>
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:
186: ( p_PRICE_LIST_rec.last_update_date <>
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:
196: ( p_PRICE_LIST_rec.last_update_login <>
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:
206: ( p_PRICE_LIST_rec.name <>
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:
216: ( p_PRICE_LIST_rec.price_list_id <>
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:
226: ( p_PRICE_LIST_rec.program_application_id <>
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:
236: ( p_PRICE_LIST_rec.program_id <>
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:
246: ( p_PRICE_LIST_rec.program_update_date <>
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:
256: ( p_PRICE_LIST_rec.request_id <>
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:
266: ( p_PRICE_LIST_rec.rounding_factor <>
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:
276: ( p_PRICE_LIST_rec.secondary_price_list_id <>
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:
286: ( p_PRICE_LIST_rec.ship_method_code <>
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:
296: ( p_PRICE_LIST_rec.start_date_active <>
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:
306: ( p_PRICE_LIST_rec.terms_id <>
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:
448: */
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;