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.INV_DEFAULT_TROHDR dependencies on INV_VALIDATE

Line 253: l_org INV_Validate.ORG;

249: , p_iteration IN NUMBER := 1
250: , x_trohdr_rec OUT NOCOPY /* file.sql.39 change */ INV_Move_Order_PUB.Trohdr_Rec_Type
251: )
252: IS
253: l_org INV_Validate.ORG;
254: l_fsub INV_Validate.SUB;
255: l_tsub INV_Validate.SUB;
256: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
257: BEGIN

Line 254: l_fsub INV_Validate.SUB;

250: , x_trohdr_rec OUT NOCOPY /* file.sql.39 change */ INV_Move_Order_PUB.Trohdr_Rec_Type
251: )
252: IS
253: l_org INV_Validate.ORG;
254: l_fsub INV_Validate.SUB;
255: l_tsub INV_Validate.SUB;
256: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
257: BEGIN
258:

Line 255: l_tsub INV_Validate.SUB;

251: )
252: IS
253: l_org INV_Validate.ORG;
254: l_fsub INV_Validate.SUB;
255: l_tsub INV_Validate.SUB;
256: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
257: BEGIN
258:
259: -- Check number of iterations.

Line 274: -- dbms_output.put_line('INV_Validate_default_trohdr iteration');

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
276:
277: g_trohdr_rec := p_trohdr_rec;
278:

Line 283: IF INV_Validate_Trohdr.Date_Required(g_trohdr_rec.date_required) = INV_Validate_Trohdr.T

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
285: INV_Trohdr_Util.Clear_Dependent_Attr
286: ( p_attr_id => INV_Trohdr_Util.G_DATE_REQUIRED
287: , p_trohdr_rec => g_trohdr_rec

Line 296: -- dbms_output.put_line('INV_Validate_default_trohdr date required');

292: END IF;
293: END IF;
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

Line 301: IF INV_Validate.Description(g_trohdr_rec.description)= INV_Validate.T

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
303: INV_Trohdr_Util.Clear_Dependent_Attr
304: ( p_attr_id => INV_Trohdr_Util.G_DESCRIPTION
305: , p_trohdr_rec => g_trohdr_rec

Line 313: -- dbms_output.put_line('INV_Validate_default_trohdr description');

309: g_trohdr_rec.description := NULL;
310: END IF;
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;

Line 321: IF INV_Validate.Organization(l_org) = INV_Validate.T

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
320:
321: IF INV_Validate.Organization(l_org) = INV_Validate.T
322: THEN
323: INV_Trohdr_Util.Clear_Dependent_Attr
324: ( p_attr_id => INV_Trohdr_Util.G_ORGANIZATION
325: , p_trohdr_rec => g_trohdr_rec

Line 335: -- dbms_output.put_line('INV_Validate_default_trohdr organization');

331:
332: END IF;
333:
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:

Line 344: IF INV_Validate.subinventory(l_fsub,l_org) = INV_Validate.T

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
343:
344: IF INV_Validate.subinventory(l_fsub,l_org) = INV_Validate.T
345: THEN
346: INV_Trohdr_Util.Clear_Dependent_Attr
347: ( p_attr_id => INV_Trohdr_Util.G_FROM_SUBINVENTORY
348: , p_trohdr_rec => g_trohdr_rec

Line 358: -- dbms_output.put_line('INV_Validate_default_trohdr from subinventory');

354:
355: END IF;
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

Line 363: IF INV_Validate_Trohdr.Header(g_trohdr_rec.header_id) = INV_Validate_Trohdr.T

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
365: INV_Trohdr_Util.Clear_Dependent_Attr
366: ( p_attr_id => INV_Trohdr_Util.G_HEADER
367: , p_trohdr_rec => g_trohdr_rec

Line 378: -- dbms_output.put_line('INV_Validate_default_trohdr header');

374: g_trohdr_rec.request_number := to_char(g_trohdr_rec.header_id);
375: END IF;
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

Line 383: IF INV_Validate_Trohdr.Header_Status(g_trohdr_rec.header_status) = INV_Validate_Trohdr.T

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
385: INV_Trohdr_Util.Clear_Dependent_Attr
386: ( p_attr_id => INV_Trohdr_Util.G_HEADER_STATUS
387: , p_trohdr_rec => g_trohdr_rec

Line 395: -- dbms_output.put_line('INV_Validate_default_trohdr header status');

391: g_trohdr_rec.header_status := NULL;
392: END IF;
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

Line 400: IF INV_Validate_Trohdr.Request_Number(g_trohdr_rec.request_number,

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
402: THEN
403: INV_Trohdr_Util.Clear_Dependent_Attr
404: ( p_attr_id => INV_Trohdr_Util.G_REQUEST_NUMBER

Line 401: l_org) = INV_Validate_Trohdr.T

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
402: THEN
403: INV_Trohdr_Util.Clear_Dependent_Attr
404: ( p_attr_id => INV_Trohdr_Util.G_REQUEST_NUMBER
405: , p_trohdr_rec => g_trohdr_rec

Line 413: -- dbms_output.put_line('INV_Validate_default_trohdr request number');

409: g_trohdr_rec.request_number := NULL;
410: END IF;
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;

Line 421: IF INV_Validate_Trohdr.Status_Date(g_trohdr_rec.status_date) = INV_Validate_Trohdr.T

417: g_trohdr_rec.status_date := Get_Status_Date;
418:
419: IF g_trohdr_rec.status_date IS NOT NULL THEN
420:
421: IF INV_Validate_Trohdr.Status_Date(g_trohdr_rec.status_date) = INV_Validate_Trohdr.T
422: THEN
423: INV_Trohdr_Util.Clear_Dependent_Attr
424: ( p_attr_id => INV_Trohdr_Util.G_STATUS_DATE
425: , p_trohdr_rec => g_trohdr_rec

Line 435: -- dbms_output.put_line('INV_Validate_default_trohdr status date');

431:
432: END IF;
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;

Line 443: IF INV_Validate.To_Account(g_trohdr_rec.to_account_id) = INV_Validate.T

439: g_trohdr_rec.to_account_id := Get_To_Account;
440:
441: IF g_trohdr_rec.to_account_id IS NOT NULL THEN
442:
443: IF INV_Validate.To_Account(g_trohdr_rec.to_account_id) = INV_Validate.T
444: THEN
445: INV_Trohdr_Util.Clear_Dependent_Attr
446: ( p_attr_id => INV_Trohdr_Util.G_TO_ACCOUNT
447: , p_trohdr_rec => g_trohdr_rec

Line 457: -- dbms_output.put_line('INV_Validate_default_trohdr to account');

453:
454: END IF;
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;

Line 465: IF INV_Validate.subinventory(l_tsub,l_org) = INV_Validate.T

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
464:
465: IF INV_Validate.subinventory(l_tsub,l_org) = INV_Validate.T
466: THEN
467: INV_Trohdr_Util.Clear_Dependent_Attr
468: ( p_attr_id => INV_Trohdr_Util.G_TO_SUBINVENTORY
469: , p_trohdr_rec => g_trohdr_rec

Line 479: -- dbms_output.put_line('INV_Validate_default_trohdr to subinventory');

475:
476: END IF;
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;

Line 487: /*IF INV_Validate.Move_Order_Type(g_trohdr_rec.move_order_type)

483: g_trohdr_rec.move_order_type := Get_Move_Order_Type;
484:
485: IF g_trohdr_rec.move_order_type IS NOT NULL THEN
486:
487: /*IF INV_Validate.Move_Order_Type(g_trohdr_rec.move_order_type)
488: THEN*/
489: INV_Trohdr_Util.Clear_Dependent_Attr
490: ( p_attr_id => INV_Trohdr_Util.G_MOVE_ORDER_TYPE
491: , p_trohdr_rec => g_trohdr_rec

Line 499: -- dbms_output.put_line('INV_Validate_default_trohdr move oreders');

495: -- g_trohdr_rec.move_order_type := NULL;
496: -- END IF;
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;

Line 507: /*IF INV_Validate.Move_Order_Type(g_trohdr_rec.move_order_type)

503: g_trohdr_rec.transaction_type_id := Get_Transaction_type_id;
504:
505: IF g_trohdr_rec.transaction_type_id IS NOT NULL THEN
506:
507: /*IF INV_Validate.Move_Order_Type(g_trohdr_rec.move_order_type)
508: THEN*/
509: INV_Trohdr_Util.Clear_Dependent_Attr
510: ( p_attr_id => INV_Trohdr_Util.G_TRANSACTION_TYPE
511: , p_trohdr_rec => g_trohdr_rec

Line 525: -- dbms_output.put_line('INV_Validate_default_trohdr transaction type');

521: g_trohdr_rec.ship_to_location_id := NULL; -- nothing to default;
522: END IF;
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

Line 552: -- dbms_output.put_line('INV_Validate_default_trohdr created by null');

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:
554: END IF;
555:
556: IF g_trohdr_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 559: -- dbms_output.put_line('INV_Validate_default_trohdr creation date null');

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:
561: END IF;
562:
563: IF g_trohdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 566: -- dbms_output.put_line('INV_Validate_default_trohdr updated by null');

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:
568: END IF;
569:
570: IF g_trohdr_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 573: -- dbms_output.put_line('INV_Validate_default_trohdr update date null');

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:
575: END IF;
576:
577: IF g_trohdr_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 580: -- dbms_output.put_line('INV_Validate_default_trohdr last update login null');

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:
582: END IF;
583:
584: IF g_trohdr_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 587: -- dbms_output.put_line('INV_Validate_default_trohdr application id null');

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:
589: END IF;
590:
591: IF g_trohdr_rec.program_id = FND_API.G_MISS_NUM THEN

Line 594: -- dbms_output.put_line('INV_Validate_default_trohdr program id null');

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:
596: END IF;
597:
598: IF g_trohdr_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 601: -- dbms_output.put_line('INV_Validate_default_trohdr program update null');

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:
603: END IF;
604:
605: IF g_trohdr_rec.request_id = FND_API.G_MISS_NUM THEN

Line 608: -- dbms_output.put_line('INV_Validate_default_trohdr request null');

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:
610: END IF;
611:
612: -- Redefault if there are any missing attributes.

Line 652: -- dbms_output.put_line('INV_Validate_default_trohdr big null');

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
655: ( p_trohdr_rec => g_trohdr_rec
656: , p_iteration => p_iteration + 1