64:
65: -- In the future call Flex APIs for defaults
66: x_eam_direct_items_rec := p_eam_direct_items_rec;
67:
68: IF p_eam_direct_items_rec.attribute_category =FND_API.G_MISS_CHAR THEN
69: x_eam_direct_items_rec.attribute_category := NULL;
70: END IF;
71:
72: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR THEN
68: IF p_eam_direct_items_rec.attribute_category =FND_API.G_MISS_CHAR THEN
69: x_eam_direct_items_rec.attribute_category := NULL;
70: END IF;
71:
72: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR THEN
73: x_eam_direct_items_rec.attribute1 := NULL;
74: END IF;
75:
76: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR THEN
72: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR THEN
73: x_eam_direct_items_rec.attribute1 := NULL;
74: END IF;
75:
76: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR THEN
77: x_eam_direct_items_rec.attribute2 := NULL;
78: END IF;
79:
80: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR THEN
76: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR THEN
77: x_eam_direct_items_rec.attribute2 := NULL;
78: END IF;
79:
80: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR THEN
81: x_eam_direct_items_rec.attribute3 := NULL;
82: END IF;
83:
84: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR THEN
80: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR THEN
81: x_eam_direct_items_rec.attribute3 := NULL;
82: END IF;
83:
84: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR THEN
85: x_eam_direct_items_rec.attribute4 := NULL;
86: END IF;
87:
88: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR THEN
84: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR THEN
85: x_eam_direct_items_rec.attribute4 := NULL;
86: END IF;
87:
88: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR THEN
89: x_eam_direct_items_rec.attribute5 := NULL;
90: END IF;
91:
92: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR THEN
88: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR THEN
89: x_eam_direct_items_rec.attribute5 := NULL;
90: END IF;
91:
92: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR THEN
93: x_eam_direct_items_rec.attribute6 := NULL;
94: END IF;
95:
96: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR THEN
92: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR THEN
93: x_eam_direct_items_rec.attribute6 := NULL;
94: END IF;
95:
96: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR THEN
97: x_eam_direct_items_rec.attribute7 := NULL;
98: END IF;
99:
100: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR THEN
96: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR THEN
97: x_eam_direct_items_rec.attribute7 := NULL;
98: END IF;
99:
100: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR THEN
101: x_eam_direct_items_rec.attribute8 := NULL;
102: END IF;
103:
104: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR THEN
100: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR THEN
101: x_eam_direct_items_rec.attribute8 := NULL;
102: END IF;
103:
104: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR THEN
105: x_eam_direct_items_rec.attribute9 := NULL;
106: END IF;
107:
108: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR THEN
104: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR THEN
105: x_eam_direct_items_rec.attribute9 := NULL;
106: END IF;
107:
108: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR THEN
109: x_eam_direct_items_rec.attribute10 := NULL;
110: END IF;
111:
112: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR THEN
108: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR THEN
109: x_eam_direct_items_rec.attribute10 := NULL;
110: END IF;
111:
112: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR THEN
113: x_eam_direct_items_rec.attribute11 := NULL;
114: END IF;
115:
116: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR THEN
112: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR THEN
113: x_eam_direct_items_rec.attribute11 := NULL;
114: END IF;
115:
116: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR THEN
117: x_eam_direct_items_rec.attribute12 := NULL;
118: END IF;
119:
120: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR THEN
116: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR THEN
117: x_eam_direct_items_rec.attribute12 := NULL;
118: END IF;
119:
120: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR THEN
121: x_eam_direct_items_rec.attribute13 := NULL;
122: END IF;
123:
124: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR THEN
120: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR THEN
121: x_eam_direct_items_rec.attribute13 := NULL;
122: END IF;
123:
124: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR THEN
125: x_eam_direct_items_rec.attribute14 := NULL;
126: END IF;
127:
128: IF p_eam_direct_items_rec.attribute15 = FND_API.G_MISS_CHAR THEN
124: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR THEN
125: x_eam_direct_items_rec.attribute14 := NULL;
126: END IF;
127:
128: IF p_eam_direct_items_rec.attribute15 = FND_API.G_MISS_CHAR THEN
129: x_eam_direct_items_rec.attribute15 := NULL;
130: END IF;
131:
132: END get_flex_eam_direct_items;
153: BEGIN
154:
155: x_eam_direct_items_rec := p_eam_direct_items_rec;
156: -- x_eam_direct_items_rec := p_eam_direct_items_rec;
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159: IF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
160: then
161: -- Defaulting direct_item_sequence_id
163: END IF;
164:
165: -- Defaulting AUTO_REQUEST_MATERIAL flag.
166: IF p_eam_direct_items_rec.auto_request_material IS NULL OR
167: p_eam_direct_items_rec.auto_request_material = FND_API.G_MISS_CHAR
168: THEN
169: x_eam_direct_items_rec.auto_request_material := 'Y';
170: END IF;
171:
170: END IF;
171:
172: -- Defaulting department_id
173: IF (p_eam_direct_items_rec.department_id IS NULL OR
174: p_eam_direct_items_rec.department_id = FND_API.G_MISS_NUM) AND
175: p_eam_direct_items_rec.operation_seq_num is not null AND
176: p_eam_direct_items_rec.organization_id is not null AND
177: p_eam_direct_items_rec.wip_entity_id is not null
178: THEN
204: , p_message_text => G_PKG_NAME || SQLERRM
205: , x_mesg_token_Tbl => x_mesg_token_tbl
206: );
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: END Attribute_Defaulting;
211:
212:
233: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing null columns prior update'); END IF;
234:
235:
236: IF p_eam_direct_items_rec.description IS NULL OR
237: p_eam_direct_items_rec.description = FND_API.G_MISS_CHAR
238: THEN
239: x_eam_direct_items_rec.description := p_old_eam_direct_items_rec.description;
240: END IF;
241:
239: x_eam_direct_items_rec.description := p_old_eam_direct_items_rec.description;
240: END IF;
241:
242: IF p_eam_direct_items_rec.purchasing_category_id IS NULL OR
243: p_eam_direct_items_rec.purchasing_category_id = FND_API.G_MISS_NUM
244: THEN
245: x_eam_direct_items_rec.purchasing_category_id := p_old_eam_direct_items_rec.purchasing_category_id;
246: END IF;
247:
245: x_eam_direct_items_rec.purchasing_category_id := p_old_eam_direct_items_rec.purchasing_category_id;
246: END IF;
247:
248: IF p_eam_direct_items_rec.uom IS NULL OR
249: p_eam_direct_items_rec.uom = FND_API.G_MISS_CHAR
250: THEN
251: x_eam_direct_items_rec.uom := p_old_eam_direct_items_rec.uom;
252: END IF;
253:
251: x_eam_direct_items_rec.uom := p_old_eam_direct_items_rec.uom;
252: END IF;
253:
254: IF p_eam_direct_items_rec.suggested_vendor_name IS NULL OR
255: p_eam_direct_items_rec.suggested_vendor_name = FND_API.G_MISS_CHAR
256: THEN
257: x_eam_direct_items_rec.suggested_vendor_name := p_old_eam_direct_items_rec.suggested_vendor_name;
258: END IF;
259:
257: x_eam_direct_items_rec.suggested_vendor_name := p_old_eam_direct_items_rec.suggested_vendor_name;
258: END IF;
259:
260: IF p_eam_direct_items_rec.suggested_vendor_id IS NULL OR
261: p_eam_direct_items_rec.suggested_vendor_id = FND_API.G_MISS_NUM
262: THEN
263: x_eam_direct_items_rec.suggested_vendor_id := p_old_eam_direct_items_rec.suggested_vendor_id;
264: END IF;
265:
263: x_eam_direct_items_rec.suggested_vendor_id := p_old_eam_direct_items_rec.suggested_vendor_id;
264: END IF;
265:
266: IF p_eam_direct_items_rec.suggested_vendor_site IS NULL OR
267: p_eam_direct_items_rec.suggested_vendor_site = FND_API.G_MISS_CHAR
268: THEN
269: x_eam_direct_items_rec.suggested_vendor_site := p_old_eam_direct_items_rec.suggested_vendor_site;
270: END IF;
271:
269: x_eam_direct_items_rec.suggested_vendor_site := p_old_eam_direct_items_rec.suggested_vendor_site;
270: END IF;
271:
272: IF p_eam_direct_items_rec.suggested_vendor_site_id IS NULL OR
273: p_eam_direct_items_rec.suggested_vendor_site_id = FND_API.G_MISS_NUM
274: THEN
275: x_eam_direct_items_rec.suggested_vendor_site_id := p_old_eam_direct_items_rec.suggested_vendor_site_id;
276: END IF;
277:
275: x_eam_direct_items_rec.suggested_vendor_site_id := p_old_eam_direct_items_rec.suggested_vendor_site_id;
276: END IF;
277:
278: IF p_eam_direct_items_rec.suggested_vendor_contact IS NULL OR
279: p_eam_direct_items_rec.suggested_vendor_contact = FND_API.G_MISS_CHAR
280: THEN
281: x_eam_direct_items_rec.suggested_vendor_contact := p_old_eam_direct_items_rec.suggested_vendor_contact;
282: END IF;
283:
281: x_eam_direct_items_rec.suggested_vendor_contact := p_old_eam_direct_items_rec.suggested_vendor_contact;
282: END IF;
283:
284: IF p_eam_direct_items_rec.suggested_vendor_contact_id IS NULL OR
285: p_eam_direct_items_rec.suggested_vendor_contact_id = FND_API.G_MISS_NUM
286: THEN
287: x_eam_direct_items_rec.suggested_vendor_contact_id := p_old_eam_direct_items_rec.suggested_vendor_contact_id;
288: END IF;
289:
287: x_eam_direct_items_rec.suggested_vendor_contact_id := p_old_eam_direct_items_rec.suggested_vendor_contact_id;
288: END IF;
289:
290: IF p_eam_direct_items_rec.suggested_vendor_phone IS NULL OR
291: p_eam_direct_items_rec.suggested_vendor_phone = FND_API.G_MISS_CHAR
292: THEN
293: x_eam_direct_items_rec.suggested_vendor_phone := p_old_eam_direct_items_rec.suggested_vendor_phone;
294: END IF;
295:
293: x_eam_direct_items_rec.suggested_vendor_phone := p_old_eam_direct_items_rec.suggested_vendor_phone;
294: END IF;
295:
296: IF p_eam_direct_items_rec.suggested_vendor_item_num IS NULL OR
297: p_eam_direct_items_rec.suggested_vendor_item_num = FND_API.G_MISS_CHAR
298: THEN
299: x_eam_direct_items_rec.suggested_vendor_item_num := p_old_eam_direct_items_rec.suggested_vendor_item_num;
300: END IF;
301:
299: x_eam_direct_items_rec.suggested_vendor_item_num := p_old_eam_direct_items_rec.suggested_vendor_item_num;
300: END IF;
301:
302: IF p_eam_direct_items_rec.unit_price IS NULL OR
303: p_eam_direct_items_rec.unit_price = FND_API.G_MISS_NUM
304: THEN
305: x_eam_direct_items_rec.unit_price := p_old_eam_direct_items_rec.unit_price;
306: END IF;
307:
305: x_eam_direct_items_rec.unit_price := p_old_eam_direct_items_rec.unit_price;
306: END IF;
307:
308: IF p_eam_direct_items_rec.department_id IS NULL OR
309: p_eam_direct_items_rec.department_id = FND_API.G_MISS_NUM
310: THEN
311: x_eam_direct_items_rec.department_id := p_old_eam_direct_items_rec.department_id;
312: END IF;
313:
312: END IF;
313:
314:
315: IF p_eam_direct_items_rec.need_by_date IS NULL OR
316: p_eam_direct_items_rec.need_by_date = FND_API.G_MISS_DATE
317: THEN
318: x_eam_direct_items_rec.need_by_date := p_old_eam_direct_items_rec.need_by_date;
319: END IF;
320:
318: x_eam_direct_items_rec.need_by_date := p_old_eam_direct_items_rec.need_by_date;
319: END IF;
320:
321: IF p_eam_direct_items_rec.required_quantity IS NULL OR
322: p_eam_direct_items_rec.required_quantity = FND_API.G_MISS_NUM
323: THEN
324: x_eam_direct_items_rec.required_quantity := p_old_eam_direct_items_rec.required_quantity;
325: END IF;
326:
327: --
328: -- Populate Null or missng flex field columns
329: --
330: IF p_eam_direct_items_rec.attribute_category IS NULL OR
331: p_eam_direct_items_rec.attribute_category = FND_API.G_MISS_CHAR
332: THEN
333: x_eam_direct_items_rec.attribute_category := p_old_eam_direct_items_rec.attribute_category;
334:
335: END IF;
333: x_eam_direct_items_rec.attribute_category := p_old_eam_direct_items_rec.attribute_category;
334:
335: END IF;
336:
337: IF p_eam_direct_items_rec.attribute1 = FND_API.G_MISS_CHAR OR
338: p_eam_direct_items_rec.attribute1 IS NULL
339: THEN
340: x_eam_direct_items_rec.attribute1 := p_old_eam_direct_items_rec.attribute1;
341: END IF;
339: THEN
340: x_eam_direct_items_rec.attribute1 := p_old_eam_direct_items_rec.attribute1;
341: END IF;
342:
343: IF p_eam_direct_items_rec.attribute2 = FND_API.G_MISS_CHAR OR
344: p_eam_direct_items_rec.attribute2 IS NULL
345: THEN
346: x_eam_direct_items_rec.attribute2 := p_old_eam_direct_items_rec.attribute2;
347: END IF;
345: THEN
346: x_eam_direct_items_rec.attribute2 := p_old_eam_direct_items_rec.attribute2;
347: END IF;
348:
349: IF p_eam_direct_items_rec.attribute3 = FND_API.G_MISS_CHAR OR
350: p_eam_direct_items_rec.attribute3 IS NULL
351: THEN
352: x_eam_direct_items_rec.attribute3 := p_old_eam_direct_items_rec.attribute3;
353: END IF;
351: THEN
352: x_eam_direct_items_rec.attribute3 := p_old_eam_direct_items_rec.attribute3;
353: END IF;
354:
355: IF p_eam_direct_items_rec.attribute4 = FND_API.G_MISS_CHAR OR
356: p_eam_direct_items_rec.attribute4 IS NULL
357: THEN
358: x_eam_direct_items_rec.attribute4 := p_old_eam_direct_items_rec.attribute4;
359: END IF;
357: THEN
358: x_eam_direct_items_rec.attribute4 := p_old_eam_direct_items_rec.attribute4;
359: END IF;
360:
361: IF p_eam_direct_items_rec.attribute5 = FND_API.G_MISS_CHAR OR
362: p_eam_direct_items_rec.attribute5 IS NULL
363: THEN
364: x_eam_direct_items_rec.attribute5 := p_old_eam_direct_items_rec.attribute5;
365: END IF;
363: THEN
364: x_eam_direct_items_rec.attribute5 := p_old_eam_direct_items_rec.attribute5;
365: END IF;
366:
367: IF p_eam_direct_items_rec.attribute6 = FND_API.G_MISS_CHAR OR
368: p_eam_direct_items_rec.attribute6 IS NULL
369: THEN
370: x_eam_direct_items_rec.attribute6 := p_old_eam_direct_items_rec.attribute6;
371: END IF;
369: THEN
370: x_eam_direct_items_rec.attribute6 := p_old_eam_direct_items_rec.attribute6;
371: END IF;
372:
373: IF p_eam_direct_items_rec.attribute7 = FND_API.G_MISS_CHAR OR
374: p_eam_direct_items_rec.attribute7 IS NULL
375: THEN
376: x_eam_direct_items_rec.attribute7 := p_old_eam_direct_items_rec.attribute7;
377: END IF;
375: THEN
376: x_eam_direct_items_rec.attribute7 := p_old_eam_direct_items_rec.attribute7;
377: END IF;
378:
379: IF p_eam_direct_items_rec.attribute8 = FND_API.G_MISS_CHAR OR
380: p_eam_direct_items_rec.attribute8 IS NULL
381: THEN
382: x_eam_direct_items_rec.attribute8 := p_old_eam_direct_items_rec.attribute8;
383: END IF;
381: THEN
382: x_eam_direct_items_rec.attribute8 := p_old_eam_direct_items_rec.attribute8;
383: END IF;
384:
385: IF p_eam_direct_items_rec.attribute9 = FND_API.G_MISS_CHAR OR
386: p_eam_direct_items_rec.attribute9 IS NULL
387: THEN
388: x_eam_direct_items_rec.attribute9 := p_old_eam_direct_items_rec.attribute9;
389: END IF;
387: THEN
388: x_eam_direct_items_rec.attribute9 := p_old_eam_direct_items_rec.attribute9;
389: END IF;
390:
391: IF p_eam_direct_items_rec.attribute10 = FND_API.G_MISS_CHAR OR
392: p_eam_direct_items_rec.attribute10 IS NULL
393: THEN
394: x_eam_direct_items_rec.attribute10 := p_old_eam_direct_items_rec.attribute10;
395: END IF;
393: THEN
394: x_eam_direct_items_rec.attribute10 := p_old_eam_direct_items_rec.attribute10;
395: END IF;
396:
397: IF p_eam_direct_items_rec.attribute11 = FND_API.G_MISS_CHAR OR
398: p_eam_direct_items_rec.attribute11 IS NULL
399: THEN
400: x_eam_direct_items_rec.attribute11 := p_old_eam_direct_items_rec.attribute11;
401: END IF;
399: THEN
400: x_eam_direct_items_rec.attribute11 := p_old_eam_direct_items_rec.attribute11;
401: END IF;
402:
403: IF p_eam_direct_items_rec.attribute12 = FND_API.G_MISS_CHAR OR
404: p_eam_direct_items_rec.attribute12 IS NULL
405: THEN
406: x_eam_direct_items_rec.attribute12 := p_old_eam_direct_items_rec.attribute12;
407: END IF;
405: THEN
406: x_eam_direct_items_rec.attribute12 := p_old_eam_direct_items_rec.attribute12;
407: END IF;
408:
409: IF p_eam_direct_items_rec.attribute13 = FND_API.G_MISS_CHAR OR
410: p_eam_direct_items_rec.attribute13 IS NULL
411: THEN
412: x_eam_direct_items_rec.attribute13 := p_old_eam_direct_items_rec.attribute13;
413: END IF;
411: THEN
412: x_eam_direct_items_rec.attribute13 := p_old_eam_direct_items_rec.attribute13;
413: END IF;
414:
415: IF p_eam_direct_items_rec.attribute14 = FND_API.G_MISS_CHAR OR
416: p_eam_direct_items_rec.attribute14 IS NULL
417: THEN
418: x_eam_direct_items_rec.attribute14 := p_old_eam_direct_items_rec.attribute14;
419: END IF;
417: THEN
418: x_eam_direct_items_rec.attribute14 := p_old_eam_direct_items_rec.attribute14;
419: END IF;
420:
421: IF p_eam_direct_items_rec.attribute15 = FND_API.G_MISS_CHAR OR
422: p_eam_direct_items_rec.attribute15 IS NULL
423: THEN
424: x_eam_direct_items_rec.attribute15 := p_old_eam_direct_items_rec.attribute15;
425: END IF;
423: THEN
424: x_eam_direct_items_rec.attribute15 := p_old_eam_direct_items_rec.attribute15;
425: END IF;
426:
427: IF p_eam_direct_items_rec.auto_request_material = FND_API.G_MISS_CHAR OR
428: p_eam_direct_items_rec.auto_request_material IS NULL
429: THEN
430: x_eam_direct_items_rec.auto_request_material := p_old_eam_direct_items_rec.auto_request_material;
431: END IF;