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_GENEALOGY_PUB dependencies on FND_MESSAGE

Line 542: fnd_message.set_name('INV', 'INV_EAM_GENEALOGY_SAME_CH_PAR');

538: mydebug(' Start of EAM Validations');
539: END IF;
540: -- validate that the parent and child are different objects
541: IF l_object_id = l_parent_object_id THEN
542: fnd_message.set_name('INV', 'INV_EAM_GENEALOGY_SAME_CH_PAR');
543: fnd_msg_pub.ADD;
544: RAISE lg_exc_error;
545: END IF;
546:

Line 569: fnd_message.set_name('INV', 'INV_EAM_GEN_NULL_START_DATE');

565: END IF;
566:
567: -- validate that the start date is not null
568: IF p_start_date_active IS NULL THEN
569: fnd_message.set_name('INV', 'INV_EAM_GEN_NULL_START_DATE');
570: fnd_msg_pub.ADD;
571: RAISE lg_exc_error;
572: END IF;
573:

Line 577: fnd_message.set_name('INV', 'INV_EAM_START_END_DATE_INVALID');

573:
574: -- validate that the end date, if not null, is greater than the start date
575: IF p_end_date_active IS NOT NULL THEN
576: IF p_start_date_active > p_end_date_active THEN
577: fnd_message.set_name('INV', 'INV_EAM_START_END_DATE_INVALID');
578: fnd_message.set_token('ENTITY1', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
579: fnd_message.set_token('ENTITY2', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
580: fnd_msg_pub.ADD;
581: RAISE lg_exc_error;

Line 578: fnd_message.set_token('ENTITY1', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

574: -- validate that the end date, if not null, is greater than the start date
575: IF p_end_date_active IS NOT NULL THEN
576: IF p_start_date_active > p_end_date_active THEN
577: fnd_message.set_name('INV', 'INV_EAM_START_END_DATE_INVALID');
578: fnd_message.set_token('ENTITY1', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
579: fnd_message.set_token('ENTITY2', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
580: fnd_msg_pub.ADD;
581: RAISE lg_exc_error;
582: END IF;

Line 579: fnd_message.set_token('ENTITY2', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

575: IF p_end_date_active IS NOT NULL THEN
576: IF p_start_date_active > p_end_date_active THEN
577: fnd_message.set_name('INV', 'INV_EAM_START_END_DATE_INVALID');
578: fnd_message.set_token('ENTITY1', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
579: fnd_message.set_token('ENTITY2', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
580: fnd_msg_pub.ADD;
581: RAISE lg_exc_error;
582: END IF;
583: END IF;

Line 606: fnd_message.set_name('INV', 'INV_EAM_PARENT_ITEM_TYPE');

602: WHERE msi.inventory_item_id = l_parent_inventory_item_id
603: AND msi.organization_id = l_parent_org_id;
604:
605: IF l_parent_item_type IS NULL THEN
606: fnd_message.set_name('INV', 'INV_EAM_PARENT_ITEM_TYPE');
607: fnd_msg_pub.ADD;
608: RAISE lg_exc_error;
609: END IF;
610:

Line 627: fnd_message.set_name('INV', 'INV_EAM_CHILD_ITEM_TYPE');

623: WHERE msi.inventory_item_id = l_inventory_item_id
624: AND msi.organization_id = l_org_id;
625:
626: IF l_child_item_type IS NULL THEN
627: fnd_message.set_name('INV', 'INV_EAM_CHILD_ITEM_TYPE');
628: fnd_msg_pub.ADD;
629: RAISE lg_exc_error;
630: END IF;
631:

Line 638: fnd_message.set_name('INV', 'INV_EAM_ASSET_REBUILD_PARENT');

634: -- rebuildables cannot be parents of assets
635: IF ((l_parent_item_type = 3)
636: AND (l_child_item_type = 1)
637: ) THEN
638: fnd_message.set_name('INV', 'INV_EAM_ASSET_REBUILD_PARENT');
639: fnd_msg_pub.ADD;
640: RAISE lg_exc_error;
641: END IF;
642:

Line 652: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

648: -- If origin transaction id is null then genealogy origin
649: -- should show that it was a manual entry
650: IF p_origin_txn_id IS NULL THEN
651: IF p_genealogy_origin <> 3 THEN
652: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
653: fnd_message.set_token('ENTITY1', 'p_genealogy_origin');
654: fnd_msg_pub.ADD;
655: RAISE lg_exc_error;
656: END IF;

Line 653: fnd_message.set_token('ENTITY1', 'p_genealogy_origin');

649: -- should show that it was a manual entry
650: IF p_origin_txn_id IS NULL THEN
651: IF p_genealogy_origin <> 3 THEN
652: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
653: fnd_message.set_token('ENTITY1', 'p_genealogy_origin');
654: fnd_msg_pub.ADD;
655: RAISE lg_exc_error;
656: END IF;
657: END IF;

Line 707: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP');

703: and last_vld_organization_id = l_parent_org_id;
704:
705: end;
706:
707: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP');
708: fnd_message.set_token('ENTITY1', l_instance_number);
709: fnd_message.set_token('ENTITY2', l_parent_instance_number);
710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 708: fnd_message.set_token('ENTITY1', l_instance_number);

704:
705: end;
706:
707: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP');
708: fnd_message.set_token('ENTITY1', l_instance_number);
709: fnd_message.set_token('ENTITY2', l_parent_instance_number);
710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
712: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 709: fnd_message.set_token('ENTITY2', l_parent_instance_number);

705: end;
706:
707: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP');
708: fnd_message.set_token('ENTITY1', l_instance_number);
709: fnd_message.set_token('ENTITY2', l_parent_instance_number);
710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
712: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
713: fnd_message.set_token('ENTITY6', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

706:
707: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP');
708: fnd_message.set_token('ENTITY1', l_instance_number);
709: fnd_message.set_token('ENTITY2', l_parent_instance_number);
710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
712: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
713: fnd_message.set_token('ENTITY6', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
714: fnd_msg_pub.ADD;

Line 711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

707: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP');
708: fnd_message.set_token('ENTITY1', l_instance_number);
709: fnd_message.set_token('ENTITY2', l_parent_instance_number);
710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
712: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
713: fnd_message.set_token('ENTITY6', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
714: fnd_msg_pub.ADD;
715: RAISE lg_exc_error;

Line 712: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

708: fnd_message.set_token('ENTITY1', l_instance_number);
709: fnd_message.set_token('ENTITY2', l_parent_instance_number);
710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
712: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
713: fnd_message.set_token('ENTITY6', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
714: fnd_msg_pub.ADD;
715: RAISE lg_exc_error;
716: END IF;

Line 713: fnd_message.set_token('ENTITY6', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

709: fnd_message.set_token('ENTITY2', l_parent_instance_number);
710: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
711: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
712: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
713: fnd_message.set_token('ENTITY6', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
714: fnd_msg_pub.ADD;
715: RAISE lg_exc_error;
716: END IF;
717: ELSE

Line 735: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP2');

731: and last_vld_organization_id = l_parent_org_id;
732:
733: end;
734:
735: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP2');
736: fnd_message.set_token('ENTITY1', l_instance_number);
737: fnd_message.set_token('ENTITY2', l_parent_instance_number);
738: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
739: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 736: fnd_message.set_token('ENTITY1', l_instance_number);

732:
733: end;
734:
735: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP2');
736: fnd_message.set_token('ENTITY1', l_instance_number);
737: fnd_message.set_token('ENTITY2', l_parent_instance_number);
738: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
739: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
740: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 737: fnd_message.set_token('ENTITY2', l_parent_instance_number);

733: end;
734:
735: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP2');
736: fnd_message.set_token('ENTITY1', l_instance_number);
737: fnd_message.set_token('ENTITY2', l_parent_instance_number);
738: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
739: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
740: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
741: fnd_msg_pub.ADD;

Line 738: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

734:
735: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP2');
736: fnd_message.set_token('ENTITY1', l_instance_number);
737: fnd_message.set_token('ENTITY2', l_parent_instance_number);
738: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
739: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
740: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
741: fnd_msg_pub.ADD;
742: RAISE lg_exc_error;

Line 739: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

735: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP2');
736: fnd_message.set_token('ENTITY1', l_instance_number);
737: fnd_message.set_token('ENTITY2', l_parent_instance_number);
738: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
739: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
740: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
741: fnd_msg_pub.ADD;
742: RAISE lg_exc_error;
743: END IF;

Line 740: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

736: fnd_message.set_token('ENTITY1', l_instance_number);
737: fnd_message.set_token('ENTITY2', l_parent_instance_number);
738: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
739: fnd_message.set_token('ENTITY4', TO_CHAR(i.end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
740: fnd_message.set_token('ENTITY5', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
741: fnd_msg_pub.ADD;
742: RAISE lg_exc_error;
743: END IF;
744: END IF;

Line 763: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP3');

759: and last_vld_organization_id = l_parent_org_id;
760:
761: end;
762:
763: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP3');
764: fnd_message.set_token('ENTITY1', l_instance_number);
765: fnd_message.set_token('ENTITY2', l_parent_instance_number);
766: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
767: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 764: fnd_message.set_token('ENTITY1', l_instance_number);

760:
761: end;
762:
763: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP3');
764: fnd_message.set_token('ENTITY1', l_instance_number);
765: fnd_message.set_token('ENTITY2', l_parent_instance_number);
766: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
767: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
768: fnd_msg_pub.ADD;

Line 765: fnd_message.set_token('ENTITY2', l_parent_instance_number);

761: end;
762:
763: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP3');
764: fnd_message.set_token('ENTITY1', l_instance_number);
765: fnd_message.set_token('ENTITY2', l_parent_instance_number);
766: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
767: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
768: fnd_msg_pub.ADD;
769: RAISE lg_exc_error;

Line 766: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

762:
763: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP3');
764: fnd_message.set_token('ENTITY1', l_instance_number);
765: fnd_message.set_token('ENTITY2', l_parent_instance_number);
766: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
767: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
768: fnd_msg_pub.ADD;
769: RAISE lg_exc_error;
770: ELSIF (p_start_date_active >= i.start_date_active)

Line 767: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

763: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP3');
764: fnd_message.set_token('ENTITY1', l_instance_number);
765: fnd_message.set_token('ENTITY2', l_parent_instance_number);
766: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
767: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
768: fnd_msg_pub.ADD;
769: RAISE lg_exc_error;
770: ELSIF (p_start_date_active >= i.start_date_active)
771: OR (p_end_date_active >= i.start_date_active) THEN

Line 788: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP1');

784: and last_vld_organization_id = l_parent_org_id;
785:
786: end;
787:
788: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP1');
789: fnd_message.set_token('ENTITY1', l_instance_number);
790: fnd_message.set_token('ENTITY2', l_parent_instance_number);
791: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
792: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 789: fnd_message.set_token('ENTITY1', l_instance_number);

785:
786: end;
787:
788: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP1');
789: fnd_message.set_token('ENTITY1', l_instance_number);
790: fnd_message.set_token('ENTITY2', l_parent_instance_number);
791: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
792: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
793: fnd_message.set_token('ENTITY5', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

Line 790: fnd_message.set_token('ENTITY2', l_parent_instance_number);

786: end;
787:
788: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP1');
789: fnd_message.set_token('ENTITY1', l_instance_number);
790: fnd_message.set_token('ENTITY2', l_parent_instance_number);
791: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
792: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
793: fnd_message.set_token('ENTITY5', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
794: fnd_msg_pub.ADD;

Line 791: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

787:
788: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP1');
789: fnd_message.set_token('ENTITY1', l_instance_number);
790: fnd_message.set_token('ENTITY2', l_parent_instance_number);
791: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
792: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
793: fnd_message.set_token('ENTITY5', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
794: fnd_msg_pub.ADD;
795: RAISE lg_exc_error;

Line 792: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));

788: fnd_message.set_name('INV', 'INV_EAM_DATE_OVERLAP1');
789: fnd_message.set_token('ENTITY1', l_instance_number);
790: fnd_message.set_token('ENTITY2', l_parent_instance_number);
791: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
792: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
793: fnd_message.set_token('ENTITY5', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
794: fnd_msg_pub.ADD;
795: RAISE lg_exc_error;
796: END IF;

Line 793: fnd_message.set_token('ENTITY5', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

789: fnd_message.set_token('ENTITY1', l_instance_number);
790: fnd_message.set_token('ENTITY2', l_parent_instance_number);
791: fnd_message.set_token('ENTITY3', TO_CHAR(i.start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
792: fnd_message.set_token('ENTITY4', TO_CHAR(p_start_date_active, 'DD-MON-YYYY HH24:MI:SS'));
793: fnd_message.set_token('ENTITY5', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
794: fnd_msg_pub.ADD;
795: RAISE lg_exc_error;
796: END IF;
797: END IF;

Line 834: fnd_message.set_name('INV', 'INV_EAM_GENEALOGY_LOOP');

830: and last_vld_organization_id = l_parent_org_id;
831:
832: end;
833:
834: fnd_message.set_name('INV', 'INV_EAM_GENEALOGY_LOOP');
835: fnd_message.set_token('ENTITY1', l_parent_instance_number);
836: fnd_message.set_token('ENTITY2', l_instance_number);
837: fnd_msg_pub.ADD;
838: RAISE lg_exc_error;

Line 835: fnd_message.set_token('ENTITY1', l_parent_instance_number);

831:
832: end;
833:
834: fnd_message.set_name('INV', 'INV_EAM_GENEALOGY_LOOP');
835: fnd_message.set_token('ENTITY1', l_parent_instance_number);
836: fnd_message.set_token('ENTITY2', l_instance_number);
837: fnd_msg_pub.ADD;
838: RAISE lg_exc_error;
839: END IF;

Line 836: fnd_message.set_token('ENTITY2', l_instance_number);

832: end;
833:
834: fnd_message.set_name('INV', 'INV_EAM_GENEALOGY_LOOP');
835: fnd_message.set_token('ENTITY1', l_parent_instance_number);
836: fnd_message.set_token('ENTITY2', l_instance_number);
837: fnd_msg_pub.ADD;
838: RAISE lg_exc_error;
839: END IF;
840: EXCEPTION

Line 1134: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1130:
1131: -- API body
1132: -- Check for the mandatory parameters
1133: IF p_object_type IS NULL THEN
1134: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1135: fnd_message.set_token('ATTRIBUTE', 'p_object_type');
1136: fnd_msg_pub.ADD;
1137: RAISE lg_exc_error;
1138: END IF;

Line 1135: fnd_message.set_token('ATTRIBUTE', 'p_object_type');

1131: -- API body
1132: -- Check for the mandatory parameters
1133: IF p_object_type IS NULL THEN
1134: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1135: fnd_message.set_token('ATTRIBUTE', 'p_object_type');
1136: fnd_msg_pub.ADD;
1137: RAISE lg_exc_error;
1138: END IF;
1139:

Line 1145: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1141: IF p_object_number IS NULL
1142: OR p_inventory_item_id IS NULL
1143: OR p_org_id IS NULL THEN
1144: IF p_object_number IS NULL THEN
1145: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1146: fnd_message.set_token('ATTRIBUTE', 'p_object_number');
1147: fnd_msg_pub.ADD;
1148: END IF;
1149:

Line 1146: fnd_message.set_token('ATTRIBUTE', 'p_object_number');

1142: OR p_inventory_item_id IS NULL
1143: OR p_org_id IS NULL THEN
1144: IF p_object_number IS NULL THEN
1145: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1146: fnd_message.set_token('ATTRIBUTE', 'p_object_number');
1147: fnd_msg_pub.ADD;
1148: END IF;
1149:
1150: IF p_inventory_item_id IS NULL THEN

Line 1151: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1147: fnd_msg_pub.ADD;
1148: END IF;
1149:
1150: IF p_inventory_item_id IS NULL THEN
1151: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1152: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');
1153: fnd_msg_pub.ADD;
1154: END IF;
1155:

Line 1152: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');

1148: END IF;
1149:
1150: IF p_inventory_item_id IS NULL THEN
1151: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1152: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');
1153: fnd_msg_pub.ADD;
1154: END IF;
1155:
1156: IF p_org_id IS NULL THEN

Line 1157: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1153: fnd_msg_pub.ADD;
1154: END IF;
1155:
1156: IF p_org_id IS NULL THEN
1157: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1158: fnd_message.set_token('ATTRIBUTE', 'p_org_id');
1159: fnd_msg_pub.ADD;
1160: END IF;
1161:

Line 1158: fnd_message.set_token('ATTRIBUTE', 'p_org_id');

1154: END IF;
1155:
1156: IF p_org_id IS NULL THEN
1157: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1158: fnd_message.set_token('ATTRIBUTE', 'p_org_id');
1159: fnd_msg_pub.ADD;
1160: END IF;
1161:
1162: RAISE lg_exc_error;

Line 1170: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1166: -- Object type can be either 1 (lot number) or 2 (serial Number).
1167: -- If invalid return an error.
1168: IF p_object_type < 1
1169: OR p_object_type > 2 THEN
1170: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1171: fnd_message.set_token('ENTITY1', 'p_object_type');
1172: fnd_msg_pub.ADD;
1173: RAISE lg_exc_error;
1174: END IF;

Line 1171: fnd_message.set_token('ENTITY1', 'p_object_type');

1167: -- If invalid return an error.
1168: IF p_object_type < 1
1169: OR p_object_type > 2 THEN
1170: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1171: fnd_message.set_token('ENTITY1', 'p_object_type');
1172: fnd_msg_pub.ADD;
1173: RAISE lg_exc_error;
1174: END IF;
1175:

Line 1187: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1183: FROM mtl_lot_numbers
1184: WHERE gen_object_id = p_object_id;
1185:
1186: IF l_dummy = 0 THEN
1187: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1188: fnd_message.set_token('ENTITY1', 'p_object_id');
1189: fnd_msg_pub.ADD;
1190: RAISE lg_exc_error;
1191: END IF;

Line 1188: fnd_message.set_token('ENTITY1', 'p_object_id');

1184: WHERE gen_object_id = p_object_id;
1185:
1186: IF l_dummy = 0 THEN
1187: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1188: fnd_message.set_token('ENTITY1', 'p_object_id');
1189: fnd_msg_pub.ADD;
1190: RAISE lg_exc_error;
1191: END IF;
1192:

Line 1204: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1200: AND inventory_item_id = p_inventory_item_id
1201: AND organization_id = p_org_id;
1202: EXCEPTION
1203: WHEN NO_DATA_FOUND THEN
1204: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1205: fnd_message.set_token('ENTITY1', 'p_object_number, p_inventory_item_id and p_org_id combination');
1206: fnd_msg_pub.ADD;
1207: RAISE lg_exc_error;
1208: END;

Line 1205: fnd_message.set_token('ENTITY1', 'p_object_number, p_inventory_item_id and p_org_id combination');

1201: AND organization_id = p_org_id;
1202: EXCEPTION
1203: WHEN NO_DATA_FOUND THEN
1204: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1205: fnd_message.set_token('ENTITY1', 'p_object_number, p_inventory_item_id and p_org_id combination');
1206: fnd_msg_pub.ADD;
1207: RAISE lg_exc_error;
1208: END;
1209: END IF;

Line 1218: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1214: FROM mtl_serial_numbers
1215: WHERE gen_object_id = p_object_id;
1216:
1217: IF l_dummy = 0 THEN
1218: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1219: fnd_message.set_token('ENTITY1', 'p_object_id');
1220: fnd_msg_pub.ADD;
1221: RAISE lg_exc_error;
1222: END IF;

Line 1219: fnd_message.set_token('ENTITY1', 'p_object_id');

1215: WHERE gen_object_id = p_object_id;
1216:
1217: IF l_dummy = 0 THEN
1218: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1219: fnd_message.set_token('ENTITY1', 'p_object_id');
1220: fnd_msg_pub.ADD;
1221: RAISE lg_exc_error;
1222: END IF;
1223:

Line 1235: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1231: AND inventory_item_id = p_inventory_item_id
1232: AND current_organization_id = p_org_id;
1233: EXCEPTION
1234: WHEN NO_DATA_FOUND THEN
1235: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1236: fnd_message.set_token('ENTITY1', 'p_object_number, p_inventory_item_id and p_org_id combination');
1237: fnd_msg_pub.ADD;
1238: RAISE lg_exc_error;
1239: END;

Line 1236: fnd_message.set_token('ENTITY1', 'p_object_number, p_inventory_item_id and p_org_id combination');

1232: AND current_organization_id = p_org_id;
1233: EXCEPTION
1234: WHEN NO_DATA_FOUND THEN
1235: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1236: fnd_message.set_token('ENTITY1', 'p_object_number, p_inventory_item_id and p_org_id combination');
1237: fnd_msg_pub.ADD;
1238: RAISE lg_exc_error;
1239: END;
1240: END IF;

Line 1251: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1247: WHERE lookup_type = 'INV_GENEALOGY_ORIGIN'
1248: AND lookup_code = p_genealogy_origin;
1249:
1250: IF l_dummy = 0 THEN
1251: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1252: fnd_message.set_token('ENTITY1', 'p_genealogy_origin');
1253: fnd_msg_pub.ADD;
1254: RAISE lg_exc_error;
1255: END IF;

Line 1252: fnd_message.set_token('ENTITY1', 'p_genealogy_origin');

1248: AND lookup_code = p_genealogy_origin;
1249:
1250: IF l_dummy = 0 THEN
1251: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1252: fnd_message.set_token('ENTITY1', 'p_genealogy_origin');
1253: fnd_msg_pub.ADD;
1254: RAISE lg_exc_error;
1255: END IF;
1256: END IF;

Line 1267: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1263: -- if p_object_type = 2 then p_genealogy_type of 1 is valid
1264: -- otherwise all of the above are valid
1265: IF p_genealogy_type NOT IN (1, 2, 3, 5)
1266: AND p_genealogy_type IS NOT NULL THEN
1267: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1268: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
1269: fnd_msg_pub.ADD;
1270: RAISE lg_exc_error;
1271: END IF;

Line 1268: fnd_message.set_token('ENTITY1', 'P_genealogy_type');

1264: -- otherwise all of the above are valid
1265: IF p_genealogy_type NOT IN (1, 2, 3, 5)
1266: AND p_genealogy_type IS NOT NULL THEN
1267: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1268: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
1269: fnd_msg_pub.ADD;
1270: RAISE lg_exc_error;
1271: END IF;
1272:

Line 1275: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1271: END IF;
1272:
1273: IF p_object_type = 2 THEN
1274: IF p_genealogy_type NOT IN (1, 5) THEN
1275: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1276: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
1277: fnd_msg_pub.ADD;
1278: RAISE lg_exc_error;
1279: END IF;

Line 1276: fnd_message.set_token('ENTITY1', 'P_genealogy_type');

1272:
1273: IF p_object_type = 2 THEN
1274: IF p_genealogy_type NOT IN (1, 5) THEN
1275: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1276: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
1277: fnd_msg_pub.ADD;
1278: RAISE lg_exc_error;
1279: END IF;
1280: END IF;

Line 1286: fnd_message.set_name('INV', 'INV_EAM_NULL_END_DATE');

1282: -- If EAM object validate whether the object exists in the table
1283: -- If it does, check whether there exists a NULL end date for the last entry of the object
1284: IF p_genealogy_type = 5 THEN
1285: IF p_end_date_active IS NULL THEN
1286: fnd_message.set_name('INV', 'INV_EAM_NULL_END_DATE');
1287: fnd_msg_pub.ADD;
1288: RAISE lg_exc_error;
1289: END IF;
1290:

Line 1309: fnd_message.set_name('INV', 'INV_EAM_END_START_DATE_INVALID');

1305: AND object_id = l_object_id
1306: AND end_date_active IS NULL;
1307:
1308: IF (p_end_date_active < l_dummy_date) THEN
1309: fnd_message.set_name('INV', 'INV_EAM_END_START_DATE_INVALID');
1310: fnd_message.set_token('ENTITY1', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
1311: fnd_message.set_token('ENTITY2', TO_CHAR(l_dummy_date, 'DD-MON-YYYY HH24:MI:SS'));
1312: fnd_msg_pub.ADD;
1313: RAISE lg_exc_error;

Line 1310: fnd_message.set_token('ENTITY1', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));

1306: AND end_date_active IS NULL;
1307:
1308: IF (p_end_date_active < l_dummy_date) THEN
1309: fnd_message.set_name('INV', 'INV_EAM_END_START_DATE_INVALID');
1310: fnd_message.set_token('ENTITY1', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
1311: fnd_message.set_token('ENTITY2', TO_CHAR(l_dummy_date, 'DD-MON-YYYY HH24:MI:SS'));
1312: fnd_msg_pub.ADD;
1313: RAISE lg_exc_error;
1314: END IF;

Line 1311: fnd_message.set_token('ENTITY2', TO_CHAR(l_dummy_date, 'DD-MON-YYYY HH24:MI:SS'));

1307:
1308: IF (p_end_date_active < l_dummy_date) THEN
1309: fnd_message.set_name('INV', 'INV_EAM_END_START_DATE_INVALID');
1310: fnd_message.set_token('ENTITY1', TO_CHAR(p_end_date_active, 'DD-MON-YYYY HH24:MI:SS'));
1311: fnd_message.set_token('ENTITY2', TO_CHAR(l_dummy_date, 'DD-MON-YYYY HH24:MI:SS'));
1312: fnd_msg_pub.ADD;
1313: RAISE lg_exc_error;
1314: END IF;
1315: EXCEPTION

Line 1317: fnd_message.set_name('INV', 'INV_EAM_GEN_NOEXIST');

1313: RAISE lg_exc_error;
1314: END IF;
1315: EXCEPTION
1316: WHEN NO_DATA_FOUND THEN
1317: fnd_message.set_name('INV', 'INV_EAM_GEN_NOEXIST');
1318: fnd_msg_pub.ADD;
1319: RAISE lg_exc_error;
1320: END;
1321: END IF;

Line 1458: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

1454: x_msg_count := 0;
1455: x_return_status := lg_ret_sts_success;
1456:
1457: IF p_transaction_source_id IS NULL THEN
1458: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1459: fnd_msg_pub.ADD;
1460: RAISE lg_exc_error;
1461: END IF;
1462:

Line 1464: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

1460: RAISE lg_exc_error;
1461: END IF;
1462:
1463: IF p_completion_transaction_id IS NULL THEN
1464: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1465: fnd_msg_pub.ADD;
1466: RAISE lg_exc_error;
1467: END IF;
1468:

Line 1807: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1803: IF p_object_type IS NULL THEN
1804: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: P_object_type'); END IF;
1805:
1806: x_return_status := lg_ret_sts_error; -- R12
1807: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1808: fnd_message.set_token('ATTRIBUTE', 'p_object_type');
1809: fnd_msg_pub.ADD;
1810: END IF;
1811:

Line 1808: fnd_message.set_token('ATTRIBUTE', 'p_object_type');

1804: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: P_object_type'); END IF;
1805:
1806: x_return_status := lg_ret_sts_error; -- R12
1807: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1808: fnd_message.set_token('ATTRIBUTE', 'p_object_type');
1809: fnd_msg_pub.ADD;
1810: END IF;
1811:
1812: IF p_object_id IS NULL THEN

Line 1819: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1815: IF p_object_number IS NULL OR p_inventory_item_id IS NULL OR p_org_id IS NULL THEN
1816: IF p_object_number IS NULL THEN
1817: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_object_number'); END IF;
1818:
1819: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1820: fnd_message.set_token('ATTRIBUTE', 'p_object_number');
1821: fnd_msg_pub.ADD;
1822: END IF;
1823:

Line 1820: fnd_message.set_token('ATTRIBUTE', 'p_object_number');

1816: IF p_object_number IS NULL THEN
1817: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_object_number'); END IF;
1818:
1819: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1820: fnd_message.set_token('ATTRIBUTE', 'p_object_number');
1821: fnd_msg_pub.ADD;
1822: END IF;
1823:
1824: --R12 IF p_inventory_item_id IS NULL THEN

Line 1830: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1826: /* {{ - If object_id is not passed then inventory_item_id is necessary along with
1827: object_number and org_id only if this object is not of type JOB = 5 }} */
1828: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_inventory_item_id'); END IF;
1829:
1830: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1831: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');
1832: fnd_msg_pub.ADD;
1833: END IF;
1834:

Line 1831: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');

1827: object_number and org_id only if this object is not of type JOB = 5 }} */
1828: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_inventory_item_id'); END IF;
1829:
1830: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1831: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');
1832: fnd_msg_pub.ADD;
1833: END IF;
1834:
1835: IF p_org_id IS NULL THEN

Line 1838: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1834:
1835: IF p_org_id IS NULL THEN
1836: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_org_id'); END IF;
1837:
1838: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1839: fnd_message.set_token('ATTRIBUTE', 'p_org_id');
1840: fnd_msg_pub.ADD;
1841: END IF;
1842:

Line 1839: fnd_message.set_token('ATTRIBUTE', 'p_org_id');

1835: IF p_org_id IS NULL THEN
1836: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_org_id'); END IF;
1837:
1838: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1839: fnd_message.set_token('ATTRIBUTE', 'p_org_id');
1840: fnd_msg_pub.ADD;
1841: END IF;
1842:
1843: x_return_status := lg_ret_sts_error; -- R12

Line 1859: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1855:
1856: IF p_parent_object_number IS NULL THEN
1857: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_object_number'); END IF;
1858:
1859: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1860: fnd_message.set_token('ATTRIBUTE', 'p_parent_object_number');
1861: fnd_msg_pub.ADD;
1862: END IF;
1863:

Line 1860: fnd_message.set_token('ATTRIBUTE', 'p_parent_object_number');

1856: IF p_parent_object_number IS NULL THEN
1857: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_object_number'); END IF;
1858:
1859: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1860: fnd_message.set_token('ATTRIBUTE', 'p_parent_object_number');
1861: fnd_msg_pub.ADD;
1862: END IF;
1863:
1864: IF p_parent_object_type <> 5 AND p_parent_inventory_item_id IS NULL THEN

Line 1867: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1863:
1864: IF p_parent_object_type <> 5 AND p_parent_inventory_item_id IS NULL THEN
1865: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_inventory_item_id'); END IF;
1866:
1867: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1868: fnd_message.set_token('ATTRIBUTE', 'p_parent_inventory_item_id');
1869: fnd_msg_pub.ADD;
1870: END IF;
1871:

Line 1868: fnd_message.set_token('ATTRIBUTE', 'p_parent_inventory_item_id');

1864: IF p_parent_object_type <> 5 AND p_parent_inventory_item_id IS NULL THEN
1865: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_inventory_item_id'); END IF;
1866:
1867: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1868: fnd_message.set_token('ATTRIBUTE', 'p_parent_inventory_item_id');
1869: fnd_msg_pub.ADD;
1870: END IF;
1871:
1872: IF p_parent_org_id IS NULL THEN

Line 1875: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1871:
1872: IF p_parent_org_id IS NULL THEN
1873: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_org_id'); END IF;
1874:
1875: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1876: fnd_message.set_token('ATTRIBUTE', 'p_parent_org_id');
1877: fnd_msg_pub.ADD;
1878: END IF;
1879:

Line 1876: fnd_message.set_token('ATTRIBUTE', 'p_parent_org_id');

1872: IF p_parent_org_id IS NULL THEN
1873: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_org_id'); END IF;
1874:
1875: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1876: fnd_message.set_token('ATTRIBUTE', 'p_parent_org_id');
1877: fnd_msg_pub.ADD;
1878: END IF;
1879:
1880: x_return_status := lg_ret_sts_error; -- R12

Line 1891: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1887: -- If invalid return an error.
1888: IF p_object_type < 1 OR p_object_type > 5 THEN
1889: x_return_status := lg_ret_sts_error; -- R12
1890: IF (p_debug = 1) THEN mydebug('INV_FIELD_INVALID - p_object_type'); END IF;
1891: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1892: fnd_message.set_token('ENTITY1', 'p_object_type');
1893: fnd_msg_pub.ADD;
1894: END IF;
1895:

Line 1892: fnd_message.set_token('ENTITY1', 'p_object_type');

1888: IF p_object_type < 1 OR p_object_type > 5 THEN
1889: x_return_status := lg_ret_sts_error; -- R12
1890: IF (p_debug = 1) THEN mydebug('INV_FIELD_INVALID - p_object_type'); END IF;
1891: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1892: fnd_message.set_token('ENTITY1', 'p_object_type');
1893: fnd_msg_pub.ADD;
1894: END IF;
1895:
1896: IF (p_parent_object_type < 1 OR p_parent_object_type > 5) THEN

Line 1899: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1895:
1896: IF (p_parent_object_type < 1 OR p_parent_object_type > 5) THEN
1897: x_return_status := lg_ret_sts_error; -- R12
1898: IF (p_debug = 1) THEN mydebug('INV_FIELD_INVALID - p_parent_object_type'); END IF;
1899: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1900: fnd_message.set_token('ENTITY1', 'p_parent_object_type');
1901: fnd_msg_pub.ADD;
1902: END IF;
1903:

Line 1900: fnd_message.set_token('ENTITY1', 'p_parent_object_type');

1896: IF (p_parent_object_type < 1 OR p_parent_object_type > 5) THEN
1897: x_return_status := lg_ret_sts_error; -- R12
1898: IF (p_debug = 1) THEN mydebug('INV_FIELD_INVALID - p_parent_object_type'); END IF;
1899: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
1900: fnd_message.set_token('ENTITY1', 'p_parent_object_type');
1901: fnd_msg_pub.ADD;
1902: END IF;
1903:
1904: -- R12 Genealogy Enhancements : Validate second set of object and parent object details

Line 1935: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1931: EXCEPTION WHEN NO_DATA_FOUND THEN
1932:
1933: IF (p_debug = 1) THEN mydebug('no data found ...child mtl_serial_numbers '); END IF;
1934: x_return_status := lg_ret_sts_error; -- R12
1935: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1936: fnd_message.set_token('ATTRIBUTE', 'l_inventory_item_id');
1937: fnd_msg_pub.ADD;
1938: END ;
1939:

Line 1936: fnd_message.set_token('ATTRIBUTE', 'l_inventory_item_id');

1932:
1933: IF (p_debug = 1) THEN mydebug('no data found ...child mtl_serial_numbers '); END IF;
1934: x_return_status := lg_ret_sts_error; -- R12
1935: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1936: fnd_message.set_token('ATTRIBUTE', 'l_inventory_item_id');
1937: fnd_msg_pub.ADD;
1938: END ;
1939:
1940: IF (p_debug = 1) THEN mydebug('l_inventory_item_id :' || l_inventory_item_id); END IF;

Line 1976: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

1972: AND current_Organization_id = p_parent_org_id;
1973: EXCEPTION WHEN NO_DATA_FOUND THEN
1974: x_return_status := lg_ret_sts_error; -- R12
1975: IF (p_debug = 1) THEN mydebug('no data found ...parent mtl_serial_numbers '); END IF;
1976: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1977: fnd_message.set_token('ATTRIBUTE', 'l_parent_inventory_item_id');
1978: fnd_msg_pub.ADD;
1979: END ;
1980: IF (p_debug = 1) THEN mydebug('l_parent_inventory_item_id '|| l_parent_inventory_item_id ); END IF;

Line 1977: fnd_message.set_token('ATTRIBUTE', 'l_parent_inventory_item_id');

1973: EXCEPTION WHEN NO_DATA_FOUND THEN
1974: x_return_status := lg_ret_sts_error; -- R12
1975: IF (p_debug = 1) THEN mydebug('no data found ...parent mtl_serial_numbers '); END IF;
1976: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1977: fnd_message.set_token('ATTRIBUTE', 'l_parent_inventory_item_id');
1978: fnd_msg_pub.ADD;
1979: END ;
1980: IF (p_debug = 1) THEN mydebug('l_parent_inventory_item_id '|| l_parent_inventory_item_id ); END IF;
1981: END IF;

Line 2002: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

1998:
1999: IF (l_object_type2 IS NOT NULL AND l_object_type2 <> 1) THEN
2000: IF (p_debug = 1) THEN mydebug('{{- p_object_type2 can only be = 1 (lot) }} '); END IF;
2001: x_return_status := lg_ret_sts_error; -- R12
2002: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2003: fnd_message.set_token('ENTITY1', 'l_object_type2');
2004: fnd_msg_pub.ADD;
2005: ELSE
2006: IF (l_object_type2 IS NULL )

Line 2003: fnd_message.set_token('ENTITY1', 'l_object_type2');

1999: IF (l_object_type2 IS NOT NULL AND l_object_type2 <> 1) THEN
2000: IF (p_debug = 1) THEN mydebug('{{- p_object_type2 can only be = 1 (lot) }} '); END IF;
2001: x_return_status := lg_ret_sts_error; -- R12
2002: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2003: fnd_message.set_token('ENTITY1', 'l_object_type2');
2004: fnd_msg_pub.ADD;
2005: ELSE
2006: IF (l_object_type2 IS NULL )
2007: THEN

Line 2025: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

2021: ' or p_org_id is NULL'); END IF;
2022: IF p_object_number2 IS NULL THEN
2023: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_object_number2'); END IF;
2024:
2025: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2026: fnd_message.set_token('ATTRIBUTE', 'p_object_number2');
2027: fnd_msg_pub.ADD;
2028: END IF;
2029: IF p_object_type <> 5 AND p_inventory_item_id IS NULL THEN

Line 2026: fnd_message.set_token('ATTRIBUTE', 'p_object_number2');

2022: IF p_object_number2 IS NULL THEN
2023: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_object_number2'); END IF;
2024:
2025: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2026: fnd_message.set_token('ATTRIBUTE', 'p_object_number2');
2027: fnd_msg_pub.ADD;
2028: END IF;
2029: IF p_object_type <> 5 AND p_inventory_item_id IS NULL THEN
2030: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_inventory_item_id'); END IF;

Line 2032: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

2028: END IF;
2029: IF p_object_type <> 5 AND p_inventory_item_id IS NULL THEN
2030: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_inventory_item_id'); END IF;
2031:
2032: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2033: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');
2034: fnd_msg_pub.ADD;
2035: END IF;
2036:

Line 2033: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');

2029: IF p_object_type <> 5 AND p_inventory_item_id IS NULL THEN
2030: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_inventory_item_id'); END IF;
2031:
2032: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2033: fnd_message.set_token('ATTRIBUTE', 'p_inventory_item_id');
2034: fnd_msg_pub.ADD;
2035: END IF;
2036:
2037:

Line 2041: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

2037:
2038: IF p_org_id IS NULL THEN
2039: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_org_id'); END IF;
2040:
2041: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2042: fnd_message.set_token('ATTRIBUTE', 'p_org_id');
2043: fnd_msg_pub.ADD;
2044: END IF;
2045:

Line 2042: fnd_message.set_token('ATTRIBUTE', 'p_org_id');

2038: IF p_org_id IS NULL THEN
2039: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_org_id'); END IF;
2040:
2041: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2042: fnd_message.set_token('ATTRIBUTE', 'p_org_id');
2043: fnd_msg_pub.ADD;
2044: END IF;
2045:
2046: x_return_status := lg_ret_sts_error; -- R12

Line 2060: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2056:
2057: IF l_parent_lot_control_code = 2 THEN
2058: IF (l_parent_object_type2 IS NOT NULL AND l_parent_object_type2 <> 1) THEN
2059: IF (p_debug = 1) THEN mydebug('{{- p_parent_object_type2 can only be = 1 (lot) }} '); END IF;
2060: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2061: fnd_message.set_token('ENTITY1', 'l_parent_object_type2');
2062: fnd_msg_pub.ADD;
2063: RAISE lg_exc_error;
2064: ELSE

Line 2061: fnd_message.set_token('ENTITY1', 'l_parent_object_type2');

2057: IF l_parent_lot_control_code = 2 THEN
2058: IF (l_parent_object_type2 IS NOT NULL AND l_parent_object_type2 <> 1) THEN
2059: IF (p_debug = 1) THEN mydebug('{{- p_parent_object_type2 can only be = 1 (lot) }} '); END IF;
2060: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2061: fnd_message.set_token('ENTITY1', 'l_parent_object_type2');
2062: fnd_msg_pub.ADD;
2063: RAISE lg_exc_error;
2064: ELSE
2065: IF (l_parent_object_type2 IS NULL )

Line 2085: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

2081: '<> 5 and p_inventory_item_id is NULL- or p_org_id is NUll'); END IF;
2082: IF p_parent_object_number2 IS NULL THEN
2083: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_object_number2'); END IF;
2084:
2085: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2086: fnd_message.set_token('ATTRIBUTE', 'p_parent_object_number2');
2087: fnd_msg_pub.ADD;
2088: END IF;
2089:

Line 2086: fnd_message.set_token('ATTRIBUTE', 'p_parent_object_number2');

2082: IF p_parent_object_number2 IS NULL THEN
2083: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_object_number2'); END IF;
2084:
2085: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2086: fnd_message.set_token('ATTRIBUTE', 'p_parent_object_number2');
2087: fnd_msg_pub.ADD;
2088: END IF;
2089:
2090: IF l_parent_object_type2 <> 5 AND p_parent_inventory_item_id IS NULL THEN

Line 2093: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

2089:
2090: IF l_parent_object_type2 <> 5 AND p_parent_inventory_item_id IS NULL THEN
2091: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_inventory_item_id'); END IF;
2092:
2093: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2094: fnd_message.set_token('ATTRIBUTE', 'p_parent_inventory_item_id');
2095: fnd_msg_pub.ADD;
2096: END IF;
2097:

Line 2094: fnd_message.set_token('ATTRIBUTE', 'p_parent_inventory_item_id');

2090: IF l_parent_object_type2 <> 5 AND p_parent_inventory_item_id IS NULL THEN
2091: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_inventory_item_id'); END IF;
2092:
2093: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2094: fnd_message.set_token('ATTRIBUTE', 'p_parent_inventory_item_id');
2095: fnd_msg_pub.ADD;
2096: END IF;
2097:
2098: IF p_parent_org_id IS NULL THEN

Line 2101: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');

2097:
2098: IF p_parent_org_id IS NULL THEN
2099: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_org_id'); END IF;
2100:
2101: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2102: fnd_message.set_token('ATTRIBUTE', 'p_parent_org_id');
2103: fnd_msg_pub.ADD;
2104: END IF;
2105:

Line 2102: fnd_message.set_token('ATTRIBUTE', 'p_parent_org_id');

2098: IF p_parent_org_id IS NULL THEN
2099: IF (p_debug = 1) THEN mydebug('INV_ATTRIBUTE_REQUIRED: p_parent_org_id'); END IF;
2100:
2101: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
2102: fnd_message.set_token('ATTRIBUTE', 'p_parent_org_id');
2103: fnd_msg_pub.ADD;
2104: END IF;
2105:
2106: x_return_status := lg_ret_sts_error; -- R12

Line 2162: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2158:
2159: IF l_dummy = 0 THEN
2160: x_return_status := lg_ret_sts_error; -- R12
2161: IF (p_debug = 1) THEN mydebug('lot not found using - p_object_id'); END IF;
2162: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2163: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2164: fnd_msg_pub.ADD;
2165: --RAISE lg_exc_error;
2166: END IF;

Line 2163: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2159: IF l_dummy = 0 THEN
2160: x_return_status := lg_ret_sts_error; -- R12
2161: IF (p_debug = 1) THEN mydebug('lot not found using - p_object_id'); END IF;
2162: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2163: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2164: fnd_msg_pub.ADD;
2165: --RAISE lg_exc_error;
2166: END IF;
2167: END IF;

Line 2187: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2183: EXCEPTION
2184: WHEN NO_DATA_FOUND THEN
2185: x_return_status := lg_ret_sts_error; -- R12
2186: IF (p_debug = 1) THEN mydebug('lot not found using - p_object_number,'); END IF;
2187: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2188: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2189: fnd_msg_pub.ADD;
2190: --RAISE lg_exc_error;
2191: END;

Line 2188: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2184: WHEN NO_DATA_FOUND THEN
2185: x_return_status := lg_ret_sts_error; -- R12
2186: IF (p_debug = 1) THEN mydebug('lot not found using - p_object_number,'); END IF;
2187: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2188: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2189: fnd_msg_pub.ADD;
2190: --RAISE lg_exc_error;
2191: END;
2192: END IF;

Line 2204: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2200:
2201: IF l_dummy = 0 THEN
2202: x_return_status := lg_ret_sts_error; -- R12
2203: IF (p_debug = 1) THEN mydebug('Serial not found using - p_object_id,'); END IF;
2204: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2205: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2206: fnd_msg_pub.ADD;
2207: -- RAISE lg_exc_error;
2208: END IF;

Line 2205: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2201: IF l_dummy = 0 THEN
2202: x_return_status := lg_ret_sts_error; -- R12
2203: IF (p_debug = 1) THEN mydebug('Serial not found using - p_object_id,'); END IF;
2204: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2205: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2206: fnd_msg_pub.ADD;
2207: -- RAISE lg_exc_error;
2208: END IF;
2209: END IF;

Line 2229: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2225: EXCEPTION
2226: WHEN NO_DATA_FOUND THEN
2227: x_return_status := lg_ret_sts_error; -- R12
2228: IF (p_debug = 1) THEN mydebug('Serial not found using - p_object_number,'); END IF;
2229: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2230: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2231: fnd_msg_pub.ADD;
2232: --RAISE lg_exc_error;
2233: END;

Line 2230: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2226: WHEN NO_DATA_FOUND THEN
2227: x_return_status := lg_ret_sts_error; -- R12
2228: IF (p_debug = 1) THEN mydebug('Serial not found using - p_object_number,'); END IF;
2229: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2230: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2231: fnd_msg_pub.ADD;
2232: --RAISE lg_exc_error;
2233: END;
2234: END IF;

Line 2245: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2241:
2242: IF l_dummy = 0 THEN
2243: x_return_status := lg_ret_sts_error; -- R12
2244: IF (p_debug = 1) THEN mydebug('Job not found using - p_object_id,'); END IF;
2245: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2246: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2247: fnd_msg_pub.ADD;
2248: --RAISE lg_exc_error;
2249: END IF;

Line 2246: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2242: IF l_dummy = 0 THEN
2243: x_return_status := lg_ret_sts_error; -- R12
2244: IF (p_debug = 1) THEN mydebug('Job not found using - p_object_id,'); END IF;
2245: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2246: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2247: fnd_msg_pub.ADD;
2248: --RAISE lg_exc_error;
2249: END IF;
2250:

Line 2268: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2264: EXCEPTION
2265: WHEN NO_DATA_FOUND THEN
2266: x_return_status := lg_ret_sts_error; -- R12
2267: IF (p_debug = 1) THEN mydebug('Job not found using - p_object_number,'); END IF;
2268: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2269: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2270: fnd_msg_pub.ADD;
2271: --RAISE lg_exc_error;
2272: END;

Line 2269: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2265: WHEN NO_DATA_FOUND THEN
2266: x_return_status := lg_ret_sts_error; -- R12
2267: IF (p_debug = 1) THEN mydebug('Job not found using - p_object_number,'); END IF;
2268: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2269: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2270: fnd_msg_pub.ADD;
2271: --RAISE lg_exc_error;
2272: END;
2273: END IF;

Line 2298: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2294:
2295: IF l_dummy = 0 THEN
2296: x_return_status := lg_ret_sts_error; -- R12
2297: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_id,'); END IF;
2298: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2299: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2300: fnd_msg_pub.ADD;
2301: --RAISE lg_exc_error;
2302: END IF;

Line 2299: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2295: IF l_dummy = 0 THEN
2296: x_return_status := lg_ret_sts_error; -- R12
2297: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_id,'); END IF;
2298: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2299: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2300: fnd_msg_pub.ADD;
2301: --RAISE lg_exc_error;
2302: END IF;
2303: END IF;

Line 2321: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2317: IF (p_debug = 1) THEN mydebug('1: l_parent_object_id: ' || l_parent_object_id); END IF;
2318:
2319: EXCEPTION
2320: WHEN NO_DATA_FOUND THEN
2321: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2322: x_return_status := lg_ret_sts_error; -- R12
2323: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_number,'); END IF;
2324: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2325: fnd_msg_pub.ADD;

Line 2324: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2320: WHEN NO_DATA_FOUND THEN
2321: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2322: x_return_status := lg_ret_sts_error; -- R12
2323: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_number,'); END IF;
2324: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2325: fnd_msg_pub.ADD;
2326: --RAISE lg_exc_error;
2327: END;
2328: END IF;

Line 2343: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2339:
2340: IF l_dummy = 0 THEN
2341: x_return_status := lg_ret_sts_error; -- R12
2342: IF (p_debug = 1) THEN mydebug('Serial not found using - p_parent_object_id,'); END IF;
2343: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2344: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2345: fnd_msg_pub.ADD;
2346: --RAISE lg_exc_error;
2347: END IF;

Line 2344: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2340: IF l_dummy = 0 THEN
2341: x_return_status := lg_ret_sts_error; -- R12
2342: IF (p_debug = 1) THEN mydebug('Serial not found using - p_parent_object_id,'); END IF;
2343: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2344: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2345: fnd_msg_pub.ADD;
2346: --RAISE lg_exc_error;
2347: END IF;
2348: END IF;

Line 2368: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2364: EXCEPTION
2365: WHEN NO_DATA_FOUND THEN
2366: x_return_status := lg_ret_sts_error; -- R12
2367: IF (p_debug = 1) THEN mydebug('Serial not found using - p_parent_object_number,'); END IF;
2368: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2369: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2370: fnd_msg_pub.ADD;
2371: --RAISE lg_exc_error;
2372: END;

Line 2369: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2365: WHEN NO_DATA_FOUND THEN
2366: x_return_status := lg_ret_sts_error; -- R12
2367: IF (p_debug = 1) THEN mydebug('Serial not found using - p_parent_object_number,'); END IF;
2368: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2369: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2370: fnd_msg_pub.ADD;
2371: --RAISE lg_exc_error;
2372: END;
2373: END IF;

Line 2385: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2381:
2382: IF l_dummy = 0 THEN
2383: x_return_status := lg_ret_sts_error; -- R12
2384: IF (p_debug = 1) THEN mydebug('Job not found using - p_parent_object_id,'); END IF;
2385: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2386: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2387: fnd_msg_pub.ADD;
2388: -- RAISE lg_exc_error;
2389: END IF;

Line 2386: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2382: IF l_dummy = 0 THEN
2383: x_return_status := lg_ret_sts_error; -- R12
2384: IF (p_debug = 1) THEN mydebug('Job not found using - p_parent_object_id,'); END IF;
2385: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2386: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2387: fnd_msg_pub.ADD;
2388: -- RAISE lg_exc_error;
2389: END IF;
2390:

Line 2408: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2404: EXCEPTION
2405: WHEN NO_DATA_FOUND THEN
2406: x_return_status := lg_ret_sts_error; -- R12
2407: IF (p_debug = 1) THEN mydebug('Job not found using - p_parent_object_number,'); END IF;
2408: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2409: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2410: fnd_msg_pub.ADD;
2411: --RAISE lg_exc_error;
2412: END;

Line 2409: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2405: WHEN NO_DATA_FOUND THEN
2406: x_return_status := lg_ret_sts_error; -- R12
2407: IF (p_debug = 1) THEN mydebug('Job not found using - p_parent_object_number,'); END IF;
2408: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2409: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2410: fnd_msg_pub.ADD;
2411: --RAISE lg_exc_error;
2412: END;
2413: END IF;

Line 2439: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2435:
2436: IF l_dummy = 0 THEN
2437: x_return_status := lg_ret_sts_error; -- R12
2438: IF (p_debug = 1) THEN mydebug('Lot not found using - p_object_id2,'); END IF;
2439: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2440: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2441: fnd_msg_pub.ADD;
2442: --RAISE lg_exc_error;
2443: END IF;

Line 2440: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2436: IF l_dummy = 0 THEN
2437: x_return_status := lg_ret_sts_error; -- R12
2438: IF (p_debug = 1) THEN mydebug('Lot not found using - p_object_id2,'); END IF;
2439: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2440: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2441: fnd_msg_pub.ADD;
2442: --RAISE lg_exc_error;
2443: END IF;
2444: END IF;

Line 2460: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2456: EXCEPTION
2457: WHEN NO_DATA_FOUND THEN
2458: x_return_status := lg_ret_sts_error; -- R12
2459: IF (p_debug = 1) THEN mydebug('Lot not found using - p_object_number2,'); END IF;
2460: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2461: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2462: fnd_msg_pub.ADD;
2463: --RAISE lg_exc_error;
2464: END;

Line 2461: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2457: WHEN NO_DATA_FOUND THEN
2458: x_return_status := lg_ret_sts_error; -- R12
2459: IF (p_debug = 1) THEN mydebug('Lot not found using - p_object_number2,'); END IF;
2460: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2461: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2462: fnd_msg_pub.ADD;
2463: --RAISE lg_exc_error;
2464: END;
2465: ELSE

Line 2492: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2488:
2489: IF l_dummy = 0 THEN
2490: x_return_status := lg_ret_sts_error; -- R12
2491: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_id2,'); END IF;
2492: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2493: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2494: fnd_msg_pub.ADD;
2495: --RAISE lg_exc_error;
2496: END IF;

Line 2493: fnd_message.set_token('ENTITY1', l_invalid_field_msg);

2489: IF l_dummy = 0 THEN
2490: x_return_status := lg_ret_sts_error; -- R12
2491: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_id2,'); END IF;
2492: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2493: fnd_message.set_token('ENTITY1', l_invalid_field_msg);
2494: fnd_msg_pub.ADD;
2495: --RAISE lg_exc_error;
2496: END IF;
2497: END IF;

Line 2512: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2508: AND organization_id = p_parent_org_id;
2509: EXCEPTION
2510: WHEN NO_DATA_FOUND THEN
2511: x_return_status := lg_ret_sts_error; -- R12
2512: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2513: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2514: fnd_msg_pub.ADD;
2515: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_number2,'); END IF;
2516: --RAISE lg_exc_error;

Line 2513: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);

2509: EXCEPTION
2510: WHEN NO_DATA_FOUND THEN
2511: x_return_status := lg_ret_sts_error; -- R12
2512: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2513: fnd_message.set_token('ENTITY1', l_invalid_comb_msg);
2514: fnd_msg_pub.ADD;
2515: IF (p_debug = 1) THEN mydebug('Lot not found using - p_parent_object_number2,'); END IF;
2516: --RAISE lg_exc_error;
2517: END;

Line 2542: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2538: AND lookup_code = p_genealogy_origin;
2539:
2540: IF l_dummy = 0 THEN
2541: x_return_status := lg_ret_sts_error; -- R12
2542: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2543: fnd_message.set_token('ENTITY1', 'p_genealogy_origin:' || TO_CHAR(p_genealogy_origin));
2544: fnd_msg_pub.ADD;
2545: IF (p_debug = 1) THEN mydebug('Gene. Origin not found in mfg_lookups,'); END IF;
2546: --RAISE lg_exc_error;

Line 2543: fnd_message.set_token('ENTITY1', 'p_genealogy_origin:' || TO_CHAR(p_genealogy_origin));

2539:
2540: IF l_dummy = 0 THEN
2541: x_return_status := lg_ret_sts_error; -- R12
2542: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2543: fnd_message.set_token('ENTITY1', 'p_genealogy_origin:' || TO_CHAR(p_genealogy_origin));
2544: fnd_msg_pub.ADD;
2545: IF (p_debug = 1) THEN mydebug('Gene. Origin not found in mfg_lookups,'); END IF;
2546: --RAISE lg_exc_error;
2547: END IF;

Line 2564: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2560: -- {{- only if p_validation_level is FULL that the input parameters p_genealogy_origin will be validated }}
2561: IF p_genealogy_type NOT IN (1, 2, 3, 4, 5)
2562: AND p_genealogy_type IS NOT NULL THEN
2563: x_return_status := lg_ret_sts_error; -- R12
2564: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2565: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
2566: fnd_msg_pub.ADD;
2567: IF (p_debug = 1) THEN mydebug('Gene. Type is invalid ,'); END IF;
2568: --RAISE lg_exc_error;

Line 2565: fnd_message.set_token('ENTITY1', 'P_genealogy_type');

2561: IF p_genealogy_type NOT IN (1, 2, 3, 4, 5)
2562: AND p_genealogy_type IS NOT NULL THEN
2563: x_return_status := lg_ret_sts_error; -- R12
2564: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2565: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
2566: fnd_msg_pub.ADD;
2567: IF (p_debug = 1) THEN mydebug('Gene. Type is invalid ,'); END IF;
2568: --RAISE lg_exc_error;
2569: END IF;

Line 2576: fnd_message.set_name('INV', {{' INV_FIELD_INVALID'}});

2572: /* {{- Removed this condition for R12 since we will have more genealogy types for object_type = 2(serials) }}
2573:
2574: {{ IF p_object_type = 2 THEN }}
2575: {{ IF p_genealogy_type NOT IN (1, 5) THEN }}
2576: fnd_message.set_name('INV', {{' INV_FIELD_INVALID'}});
2577: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
2578: fnd_msg_pub.ADD;
2579: RAISE lg_exc_error;
2580: END IF;

Line 2577: fnd_message.set_token('ENTITY1', 'P_genealogy_type');

2573:
2574: {{ IF p_object_type = 2 THEN }}
2575: {{ IF p_genealogy_type NOT IN (1, 5) THEN }}
2576: fnd_message.set_name('INV', {{' INV_FIELD_INVALID'}});
2577: fnd_message.set_token('ENTITY1', 'P_genealogy_type');
2578: fnd_msg_pub.ADD;
2579: RAISE lg_exc_error;
2580: END IF;
2581: END IF; */

Line 2597: fnd_message.set_name('INV', 'INV_NULLOBJECTID'); -- mrana addmsg

2593: END IF;
2594:
2595: IF l_object_id IS NULL OR l_parent_object_id IS NULL THEN
2596: x_return_status := lg_ret_sts_error;
2597: fnd_message.set_name('INV', 'INV_NULLOBJECTID'); -- mrana addmsg
2598: IF l_object_id is NULL THEN
2599: fnd_message.set_token('ENTITY1', 'p_object_number');
2600: ELSIF l_parent_object_id IS NULL THEN
2601: fnd_message.set_token('ENTITY1', 'p_parent_object_number');

Line 2599: fnd_message.set_token('ENTITY1', 'p_object_number');

2595: IF l_object_id IS NULL OR l_parent_object_id IS NULL THEN
2596: x_return_status := lg_ret_sts_error;
2597: fnd_message.set_name('INV', 'INV_NULLOBJECTID'); -- mrana addmsg
2598: IF l_object_id is NULL THEN
2599: fnd_message.set_token('ENTITY1', 'p_object_number');
2600: ELSIF l_parent_object_id IS NULL THEN
2601: fnd_message.set_token('ENTITY1', 'p_parent_object_number');
2602: END IF;
2603: fnd_msg_pub.ADD;

Line 2601: fnd_message.set_token('ENTITY1', 'p_parent_object_number');

2597: fnd_message.set_name('INV', 'INV_NULLOBJECTID'); -- mrana addmsg
2598: IF l_object_id is NULL THEN
2599: fnd_message.set_token('ENTITY1', 'p_object_number');
2600: ELSIF l_parent_object_id IS NULL THEN
2601: fnd_message.set_token('ENTITY1', 'p_parent_object_number');
2602: END IF;
2603: fnd_msg_pub.ADD;
2604: IF (p_debug = 1) THEN mydebug('Gene. Type is invalid ,'); END IF;
2605: END IF;