DBA Data[Home] [Help]

APPS.INV_DEFAULT_TROHDR dependencies on FND_API

Line 26: IF g_cache_Trohdr_rec.header_id = FND_API.G_MISS_NUM OR

22: /* inv_debug.message('In Load_Request_Header:'||to_char(p_header_id)); */
23:
24: IF p_header_id IS NOT NULL THEN
25:
26: IF g_cache_Trohdr_rec.header_id = FND_API.G_MISS_NUM OR
27: g_cache_Trohdr_rec.header_id <> p_header_id THEN
28:
29: g_cache_Trohdr_rec := INV_Trohdr_Util.Query_Row(p_header_id);
30: INV_Globals.g_max_line_num := null;

Line 178: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN

174: BEGIN
175:
176: -- In the future call Flex APIs for defaults
177:
178: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
179: g_trohdr_rec.attribute1 := NULL;
180: END IF;
181:
182: IF g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 182: IF g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN

178: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
179: g_trohdr_rec.attribute1 := NULL;
180: END IF;
181:
182: IF g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN
183: g_trohdr_rec.attribute10 := NULL;
184: END IF;
185:
186: IF g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 186: IF g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN

182: IF g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN
183: g_trohdr_rec.attribute10 := NULL;
184: END IF;
185:
186: IF g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN
187: g_trohdr_rec.attribute11 := NULL;
188: END IF;
189:
190: IF g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 190: IF g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN

186: IF g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN
187: g_trohdr_rec.attribute11 := NULL;
188: END IF;
189:
190: IF g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN
191: g_trohdr_rec.attribute12 := NULL;
192: END IF;
193:
194: IF g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 194: IF g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN

190: IF g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN
191: g_trohdr_rec.attribute12 := NULL;
192: END IF;
193:
194: IF g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN
195: g_trohdr_rec.attribute13 := NULL;
196: END IF;
197:
198: IF g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 198: IF g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN

194: IF g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN
195: g_trohdr_rec.attribute13 := NULL;
196: END IF;
197:
198: IF g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN
199: g_trohdr_rec.attribute14 := NULL;
200: END IF;
201:
202: IF g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 202: IF g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN

198: IF g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN
199: g_trohdr_rec.attribute14 := NULL;
200: END IF;
201:
202: IF g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN
203: g_trohdr_rec.attribute15 := NULL;
204: END IF;
205:
206: IF g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 206: IF g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN

202: IF g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN
203: g_trohdr_rec.attribute15 := NULL;
204: END IF;
205:
206: IF g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN
207: g_trohdr_rec.attribute2 := NULL;
208: END IF;
209:
210: IF g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 210: IF g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN

206: IF g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN
207: g_trohdr_rec.attribute2 := NULL;
208: END IF;
209:
210: IF g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN
211: g_trohdr_rec.attribute3 := NULL;
212: END IF;
213:
214: IF g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 214: IF g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN

210: IF g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN
211: g_trohdr_rec.attribute3 := NULL;
212: END IF;
213:
214: IF g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN
215: g_trohdr_rec.attribute4 := NULL;
216: END IF;
217:
218: IF g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 218: IF g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN

214: IF g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN
215: g_trohdr_rec.attribute4 := NULL;
216: END IF;
217:
218: IF g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN
219: g_trohdr_rec.attribute5 := NULL;
220: END IF;
221:
222: IF g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 222: IF g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN

218: IF g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN
219: g_trohdr_rec.attribute5 := NULL;
220: END IF;
221:
222: IF g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN
223: g_trohdr_rec.attribute6 := NULL;
224: END IF;
225:
226: IF g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 226: IF g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN

222: IF g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN
223: g_trohdr_rec.attribute6 := NULL;
224: END IF;
225:
226: IF g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN
227: g_trohdr_rec.attribute7 := NULL;
228: END IF;
229:
230: IF g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 230: IF g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN

226: IF g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN
227: g_trohdr_rec.attribute7 := NULL;
228: END IF;
229:
230: IF g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN
231: g_trohdr_rec.attribute8 := NULL;
232: END IF;
233:
234: IF g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 234: IF g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN

230: IF g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN
231: g_trohdr_rec.attribute8 := NULL;
232: END IF;
233:
234: IF g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN
235: g_trohdr_rec.attribute9 := NULL;
236: END IF;
237:
238: IF g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 238: IF g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN

234: IF g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN
235: g_trohdr_rec.attribute9 := NULL;
236: END IF;
237:
238: IF g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN
239: g_trohdr_rec.attribute_category := NULL;
240: END IF;
241:
242: END Get_Flex_Trohdr;

Line 271: RAISE FND_API.G_EXC_ERROR;

267: FND_MSG_PUB.Add;
268:
269: END IF;
270:
271: RAISE FND_API.G_EXC_ERROR;
272:
273: END IF;
274: -- dbms_output.put_line('INV_Validate_default_trohdr iteration');
275: -- Initialize g_trohdr_rec

Line 280: IF g_trohdr_rec.date_required = FND_API.G_MISS_DATE THEN

276:
277: g_trohdr_rec := p_trohdr_rec;
278:
279: -- Default missing attributes.
280: IF g_trohdr_rec.date_required = FND_API.G_MISS_DATE THEN
281: g_trohdr_rec.date_required := Get_Date_Required;
282: IF g_trohdr_rec.date_required IS NOT NULL THEN
283: IF INV_Validate_Trohdr.Date_Required(g_trohdr_rec.date_required) = INV_Validate_Trohdr.T
284: THEN

Line 298: IF g_trohdr_rec.description = FND_API.G_MISS_CHAR THEN

294: END IF;
295:
296: -- dbms_output.put_line('INV_Validate_default_trohdr date required');
297:
298: IF g_trohdr_rec.description = FND_API.G_MISS_CHAR THEN
299: g_trohdr_rec.description := Get_Description;
300: IF g_trohdr_rec.description IS NOT NULL THEN
301: IF INV_Validate.Description(g_trohdr_rec.description)= INV_Validate.T
302: THEN

Line 315: IF g_trohdr_rec.organization_id = FND_API.G_MISS_NUM THEN

311: END IF;
312: END IF;
313: -- dbms_output.put_line('INV_Validate_default_trohdr description');
314:
315: IF g_trohdr_rec.organization_id = FND_API.G_MISS_NUM THEN
316:
317: g_trohdr_rec.organization_id := Get_Organization;
318: l_org.organization_id := g_trohdr_rec.organization_id;
319: IF g_trohdr_rec.organization_id IS NOT NULL THEN

Line 338: IF g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN

334: END IF;
335: -- dbms_output.put_line('INV_Validate_default_trohdr organization');
336:
337:
338: IF g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
339:
340: g_trohdr_rec.from_subinventory_code := Get_From_Subinventory;
341: l_fsub.secondary_inventory_name := g_trohdr_rec.from_subinventory_code;
342: IF g_trohdr_rec.from_subinventory_code IS NOT NULL THEN

Line 360: IF g_trohdr_rec.header_id = FND_API.G_MISS_NUM THEN

356:
357: END IF;
358: -- dbms_output.put_line('INV_Validate_default_trohdr from subinventory');
359:
360: IF g_trohdr_rec.header_id = FND_API.G_MISS_NUM THEN
361: g_trohdr_rec.header_id := Get_Header(g_trohdr_rec.organization_id);
362: IF g_trohdr_rec.header_id IS NOT NULL THEN
363: IF INV_Validate_Trohdr.Header(g_trohdr_rec.header_id) = INV_Validate_Trohdr.T
364: THEN

Line 373: IF g_trohdr_rec.request_number = FND_API.G_MISS_CHAR THEN

369: );
370: ELSE
371: g_trohdr_rec.header_id := NULL;
372: END IF;
373: IF g_trohdr_rec.request_number = FND_API.G_MISS_CHAR THEN
374: g_trohdr_rec.request_number := to_char(g_trohdr_rec.header_id);
375: END IF;
376: END IF;
377: END IF;

Line 380: IF g_trohdr_rec.header_status = FND_API.G_MISS_NUM THEN

376: END IF;
377: END IF;
378: -- dbms_output.put_line('INV_Validate_default_trohdr header');
379:
380: IF g_trohdr_rec.header_status = FND_API.G_MISS_NUM THEN
381: g_trohdr_rec.header_status := Get_Header_Status;
382: IF g_trohdr_rec.header_status IS NOT NULL THEN
383: IF INV_Validate_Trohdr.Header_Status(g_trohdr_rec.header_status) = INV_Validate_Trohdr.T
384: THEN

Line 397: IF g_trohdr_rec.request_number = FND_API.G_MISS_CHAR THEN

393: END IF;
394: END IF;
395: -- dbms_output.put_line('INV_Validate_default_trohdr header status');
396:
397: IF g_trohdr_rec.request_number = FND_API.G_MISS_CHAR THEN
398: g_trohdr_rec.request_number := Get_Request_Number;
399: IF g_trohdr_rec.request_number IS NOT NULL THEN
400: IF INV_Validate_Trohdr.Request_Number(g_trohdr_rec.request_number,
401: l_org) = INV_Validate_Trohdr.T

Line 415: IF g_trohdr_rec.status_date = FND_API.G_MISS_DATE THEN

411: END IF;
412: END IF;
413: -- dbms_output.put_line('INV_Validate_default_trohdr request number');
414:
415: IF g_trohdr_rec.status_date = FND_API.G_MISS_DATE THEN
416:
417: g_trohdr_rec.status_date := Get_Status_Date;
418:
419: IF g_trohdr_rec.status_date IS NOT NULL THEN

Line 437: IF g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM THEN

433:
434: END IF;
435: -- dbms_output.put_line('INV_Validate_default_trohdr status date');
436:
437: IF g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM THEN
438:
439: g_trohdr_rec.to_account_id := Get_To_Account;
440:
441: IF g_trohdr_rec.to_account_id IS NOT NULL THEN

Line 459: IF g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN

455:
456: END IF;
457: -- dbms_output.put_line('INV_Validate_default_trohdr to account');
458:
459: IF g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
460:
461: g_trohdr_rec.to_subinventory_code := Get_To_Subinventory;
462: l_tsub.secondary_inventory_name := g_trohdr_rec.to_subinventory_code;
463: IF g_trohdr_rec.to_subinventory_code IS NOT NULL THEN

Line 481: IF g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM THEN

477:
478: END IF;
479: -- dbms_output.put_line('INV_Validate_default_trohdr to subinventory');
480:
481: IF g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM THEN
482:
483: g_trohdr_rec.move_order_type := Get_Move_Order_Type;
484:
485: IF g_trohdr_rec.move_order_type IS NOT NULL THEN

Line 501: IF g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN

497: END IF;
498: END IF;
499: -- dbms_output.put_line('INV_Validate_default_trohdr move oreders');
500:
501: IF g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
502:
503: g_trohdr_rec.transaction_type_id := Get_Transaction_type_id;
504:
505: IF g_trohdr_rec.transaction_type_id IS NOT NULL THEN

Line 520: IF g_trohdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN

516: -- END IF;
517: END IF;
518: END IF;
519:
520: IF g_trohdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
521: g_trohdr_rec.ship_to_location_id := NULL; -- nothing to default;
522: END IF;
523:
524:

Line 527: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR

523:
524:
525: -- dbms_output.put_line('INV_Validate_default_trohdr transaction type');
526:
527: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
528: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR

Line 528: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR

524:
525: -- dbms_output.put_line('INV_Validate_default_trohdr transaction type');
526:
527: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
528: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR

Line 529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR

525: -- dbms_output.put_line('INV_Validate_default_trohdr transaction type');
526:
527: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
528: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR

Line 530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR

526:
527: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
528: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR

Line 531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR

527: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
528: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR

Line 532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR

528: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR

Line 533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR

529: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR

Line 534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR

530: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR

Line 535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR

531: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR

Line 536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR

532: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR

Line 537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR

533: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
541: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR

Line 538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR

534: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
541: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
542: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR

Line 539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR

535: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
541: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
542: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
543: THEN

Line 540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR

536: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
541: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
542: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
543: THEN
544:

Line 541: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR

537: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
541: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
542: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
543: THEN
544:
545: Get_Flex_Trohdr;

Line 542: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR

538: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
539: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
540: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
541: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
542: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
543: THEN
544:
545: Get_Flex_Trohdr;
546:

Line 549: IF g_trohdr_rec.created_by = FND_API.G_MISS_NUM THEN

545: Get_Flex_Trohdr;
546:
547: END IF;
548:
549: IF g_trohdr_rec.created_by = FND_API.G_MISS_NUM THEN
550:
551: g_trohdr_rec.created_by := NULL;
552: -- dbms_output.put_line('INV_Validate_default_trohdr created by null');
553:

Line 556: IF g_trohdr_rec.creation_date = FND_API.G_MISS_DATE THEN

552: -- dbms_output.put_line('INV_Validate_default_trohdr created by null');
553:
554: END IF;
555:
556: IF g_trohdr_rec.creation_date = FND_API.G_MISS_DATE THEN
557:
558: g_trohdr_rec.creation_date := NULL;
559: -- dbms_output.put_line('INV_Validate_default_trohdr creation date null');
560:

Line 563: IF g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN

559: -- dbms_output.put_line('INV_Validate_default_trohdr creation date null');
560:
561: END IF;
562:
563: IF g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN
564:
565: g_trohdr_rec.last_updated_by := NULL;
566: -- dbms_output.put_line('INV_Validate_default_trohdr updated by null');
567:

Line 570: IF g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE THEN

566: -- dbms_output.put_line('INV_Validate_default_trohdr updated by null');
567:
568: END IF;
569:
570: IF g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE THEN
571:
572: g_trohdr_rec.last_update_date := NULL;
573: -- dbms_output.put_line('INV_Validate_default_trohdr update date null');
574:

Line 577: IF g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM THEN

573: -- dbms_output.put_line('INV_Validate_default_trohdr update date null');
574:
575: END IF;
576:
577: IF g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM THEN
578:
579: g_trohdr_rec.last_update_login := NULL;
580: -- dbms_output.put_line('INV_Validate_default_trohdr last update login null');
581:

Line 584: IF g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM THEN

580: -- dbms_output.put_line('INV_Validate_default_trohdr last update login null');
581:
582: END IF;
583:
584: IF g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM THEN
585:
586: g_trohdr_rec.program_application_id := NULL;
587: -- dbms_output.put_line('INV_Validate_default_trohdr application id null');
588:

Line 591: IF g_trohdr_rec.program_id = FND_API.G_MISS_NUM THEN

587: -- dbms_output.put_line('INV_Validate_default_trohdr application id null');
588:
589: END IF;
590:
591: IF g_trohdr_rec.program_id = FND_API.G_MISS_NUM THEN
592:
593: g_trohdr_rec.program_id := NULL;
594: -- dbms_output.put_line('INV_Validate_default_trohdr program id null');
595:

Line 598: IF g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE THEN

594: -- dbms_output.put_line('INV_Validate_default_trohdr program id null');
595:
596: END IF;
597:
598: IF g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE THEN
599:
600: g_trohdr_rec.program_update_date := NULL;
601: -- dbms_output.put_line('INV_Validate_default_trohdr program update null');
602:

Line 605: IF g_trohdr_rec.request_id = FND_API.G_MISS_NUM THEN

601: -- dbms_output.put_line('INV_Validate_default_trohdr program update null');
602:
603: END IF;
604:
605: IF g_trohdr_rec.request_id = FND_API.G_MISS_NUM THEN
606:
607: g_trohdr_rec.request_id := NULL;
608: -- dbms_output.put_line('INV_Validate_default_trohdr request null');
609:

Line 614: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR

610: END IF;
611:
612: -- Redefault if there are any missing attributes.
613:
614: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
615: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR

Line 615: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR

611:
612: -- Redefault if there are any missing attributes.
613:
614: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
615: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR

Line 616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR

612: -- Redefault if there are any missing attributes.
613:
614: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
615: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR

Line 617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR

613:
614: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
615: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR

Line 618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR

614: IF g_trohdr_rec.attribute1 = FND_API.G_MISS_CHAR
615: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR

Line 619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR

615: OR g_trohdr_rec.attribute10 = FND_API.G_MISS_CHAR
616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR

Line 620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR

616: OR g_trohdr_rec.attribute11 = FND_API.G_MISS_CHAR
617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR

Line 621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR

617: OR g_trohdr_rec.attribute12 = FND_API.G_MISS_CHAR
618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR

Line 622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR

618: OR g_trohdr_rec.attribute13 = FND_API.G_MISS_CHAR
619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR

Line 623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR

619: OR g_trohdr_rec.attribute14 = FND_API.G_MISS_CHAR
620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR

Line 624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR

620: OR g_trohdr_rec.attribute15 = FND_API.G_MISS_CHAR
621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR

Line 625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR

621: OR g_trohdr_rec.attribute2 = FND_API.G_MISS_CHAR
622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR

Line 626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR

622: OR g_trohdr_rec.attribute3 = FND_API.G_MISS_CHAR
623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM

Line 627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR

623: OR g_trohdr_rec.attribute4 = FND_API.G_MISS_CHAR
624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE

Line 628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR

624: OR g_trohdr_rec.attribute5 = FND_API.G_MISS_CHAR
625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE

Line 629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR

625: OR g_trohdr_rec.attribute6 = FND_API.G_MISS_CHAR
626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR

Line 630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM

626: OR g_trohdr_rec.attribute7 = FND_API.G_MISS_CHAR
627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR

Line 631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE

627: OR g_trohdr_rec.attribute8 = FND_API.G_MISS_CHAR
628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM

Line 632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE

628: OR g_trohdr_rec.attribute9 = FND_API.G_MISS_CHAR
629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM

Line 633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR

629: OR g_trohdr_rec.attribute_category = FND_API.G_MISS_CHAR
630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM

Line 634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR

630: OR g_trohdr_rec.created_by = FND_API.G_MISS_NUM
631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE

Line 635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM

631: OR g_trohdr_rec.creation_date = FND_API.G_MISS_DATE
632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM

Line 636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM

632: OR g_trohdr_rec.date_required = FND_API.G_MISS_DATE
633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM

Line 637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM

633: OR g_trohdr_rec.description = FND_API.G_MISS_CHAR
634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM

Line 638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE

634: OR g_trohdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR
635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM

Line 639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM

635: OR g_trohdr_rec.header_id = FND_API.G_MISS_NUM
636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE

Line 640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM

636: OR g_trohdr_rec.header_status = FND_API.G_MISS_NUM
637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM

Line 641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM

637: OR g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM
638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR

Line 642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM

638: OR g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE
639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE

Line 643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE

639: OR g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM
640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM

Line 644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM

640: OR g_trohdr_rec.organization_id = FND_API.G_MISS_NUM
641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR

Line 645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR

641: OR g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM
642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR
649: OR g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM

Line 646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE

642: OR g_trohdr_rec.program_id = FND_API.G_MISS_NUM
643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR
649: OR g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM
650: OR g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM

Line 647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM

643: OR g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE
644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR
649: OR g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM
650: OR g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM
651: THEN

Line 648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR

644: OR g_trohdr_rec.request_id = FND_API.G_MISS_NUM
645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR
649: OR g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM
650: OR g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM
651: THEN
652: -- dbms_output.put_line('INV_Validate_default_trohdr big null');

Line 649: OR g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM

645: OR g_trohdr_rec.request_number = FND_API.G_MISS_CHAR
646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR
649: OR g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM
650: OR g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM
651: THEN
652: -- dbms_output.put_line('INV_Validate_default_trohdr big null');
653:

Line 650: OR g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM

646: OR g_trohdr_rec.status_date = FND_API.G_MISS_DATE
647: OR g_trohdr_rec.to_account_id = FND_API.G_MISS_NUM
648: OR g_trohdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR
649: OR g_trohdr_rec.move_order_type = FND_API.G_MISS_NUM
650: OR g_trohdr_rec.transaction_type_id = FND_API.G_MISS_NUM
651: THEN
652: -- dbms_output.put_line('INV_Validate_default_trohdr big null');
653:
654: INV_Default_Trohdr.Attributes