DBA Data[Home] [Help]

APPS.WIP_VALIDATE_SHOPFLOORMOVE dependencies on WIP_VALIDATE

Line 1: PACKAGE BODY WIP_Validate_Shopfloormove AS

1: PACKAGE BODY WIP_Validate_Shopfloormove AS
2: /* $Header: WIPLSFMB.pls 115.10 2002/11/28 11:48:15 rmahidha ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WIP_Validate_Shopfloormove';

2: /* $Header: WIPLSFMB.pls 115.10 2002/11/28 11:48:15 rmahidha ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WIP_Validate_Shopfloormove';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 525: IF NOT WIP_Validate.Acct_Period(p_ShopFloorMove_rec.acct_period_id,

521: ( p_ShopFloorMove_rec.acct_period_id <>
522: p_old_ShopFloorMove_rec.acct_period_id OR
523: p_old_ShopFloorMove_rec.acct_period_id IS NULL )
524: THEN
525: IF NOT WIP_Validate.Acct_Period(p_ShopFloorMove_rec.acct_period_id,
526: p_ShopFloorMove_rec.organization_id) THEN
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: END IF;
529: END IF;

Line 536: IF NOT WIP_Validate.Created_By_Name(p_ShopFloorMove_rec.created_by_name) THEN

532: ( p_ShopFloorMove_rec.created_by_name <>
533: p_old_ShopFloorMove_rec.created_by_name OR
534: p_old_ShopFloorMove_rec.created_by_name IS NULL )
535: THEN
536: IF NOT WIP_Validate.Created_By_Name(p_ShopFloorMove_rec.created_by_name) THEN
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539: END IF;
540:

Line 546: IF NOT WIP_Validate.Entity_Type(p_ShopFloorMove_rec.entity_type) THEN

542: ( p_ShopFloorMove_rec.entity_type <>
543: p_old_ShopFloorMove_rec.entity_type OR
544: p_old_ShopFloorMove_rec.entity_type IS NULL )
545: THEN
546: IF NOT WIP_Validate.Entity_Type(p_ShopFloorMove_rec.entity_type) THEN
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;
550:

Line 556: IF NOT WIP_Validate.Department_Code(p_ShopFloorMove_rec.fm_department_code,

552: ( p_ShopFloorMove_rec.fm_department_code <>
553: p_old_ShopFloorMove_rec.fm_department_code OR
554: p_old_ShopFloorMove_rec.fm_department_code IS NULL )
555: THEN
556: IF NOT WIP_Validate.Department_Code(p_ShopFloorMove_rec.fm_department_code,
557: p_ShopFloorMove_rec.organization_id,
558: 'fm_department_code') THEN
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END IF;

Line 568: IF NOT WIP_Validate.Department_Id(p_ShopFloorMove_rec.fm_department_id,

564: ( p_ShopFloorMove_rec.fm_department_id <>
565: p_old_ShopFloorMove_rec.fm_department_id OR
566: p_old_ShopFloorMove_rec.fm_department_id IS NULL )
567: THEN
568: IF NOT WIP_Validate.Department_Id(p_ShopFloorMove_rec.fm_department_id,
569: 'fm_department_id') THEN
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: END IF;
572: END IF;

Line 579: IF NOT WIP_Validate.Intraop_Step_Type(p_ShopFloorMove_rec.fm_intraop_step_type,

575: ( p_ShopFloorMove_rec.fm_intraop_step_type <>
576: p_old_ShopFloorMove_rec.fm_intraop_step_type OR
577: p_old_ShopFloorMove_rec.fm_intraop_step_type IS NULL )
578: THEN
579: IF NOT WIP_Validate.Intraop_Step_Type(p_ShopFloorMove_rec.fm_intraop_step_type,
580: 'fm_intraop_step_type') THEN
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: END IF;
583: END IF;

Line 590: IF NOT WIP_Validate.Operation_Code(p_ShopFloorMove_rec.fm_operation_code,

586: ( p_ShopFloorMove_rec.fm_operation_code <>
587: p_old_ShopFloorMove_rec.fm_operation_code OR
588: p_old_ShopFloorMove_rec.fm_operation_code IS NULL )
589: THEN
590: IF NOT WIP_Validate.Operation_Code(p_ShopFloorMove_rec.fm_operation_code,
591: 'fm_operation_code') THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: END IF;
594: END IF;

Line 601: IF NOT WIP_Validate.Operation_Seq_Num(p_ShopFloorMove_rec.fm_operation_seq_num,

597: ( p_ShopFloorMove_rec.fm_operation_seq_num <>
598: p_old_ShopFloorMove_rec.fm_operation_seq_num OR
599: p_old_ShopFloorMove_rec.fm_operation_seq_num IS NULL )
600: THEN
601: IF NOT WIP_Validate.Operation_Seq_Num(p_ShopFloorMove_rec.fm_operation_seq_num,
602: 'fm_operation_seq_num') THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: END IF;
605: END IF;

Line 612: IF NOT WIP_Validate.Kanban_Card(p_ShopFloorMove_rec.kanban_card_id,

608: ( p_ShopFloorMove_rec.kanban_card_id <>
609: p_old_ShopFloorMove_rec.kanban_card_id OR
610: p_old_ShopFloorMove_rec.kanban_card_id IS NULL )
611: THEN
612: IF NOT WIP_Validate.Kanban_Card(p_ShopFloorMove_rec.kanban_card_id,
613: p_ShopFloorMove_rec.organization_id) THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: END IF;

Line 623: IF NOT WIP_Validate.Last_Updated_By_Name(p_ShopFloorMove_rec.last_updated_by_name) THEN

619: ( p_ShopFloorMove_rec.last_updated_by_name <>
620: p_old_ShopFloorMove_rec.last_updated_by_name OR
621: p_old_ShopFloorMove_rec.last_updated_by_name IS NULL )
622: THEN
623: IF NOT WIP_Validate.Last_Updated_By_Name(p_ShopFloorMove_rec.last_updated_by_name) THEN
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626: END IF;
627:

Line 633: IF NOT WIP_Validate.Line(p_ShopFloorMove_rec.line_code) THEN

629: ( p_ShopFloorMove_rec.line_code <>
630: p_old_ShopFloorMove_rec.line_code OR
631: p_old_ShopFloorMove_rec.line_code IS NULL )
632: THEN
633: IF NOT WIP_Validate.Line(p_ShopFloorMove_rec.line_code) THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: END IF;
636: END IF;
637:

Line 643: IF NOT WIP_Validate.Line(p_ShopFloorMove_rec.line_id) THEN

639: ( p_ShopFloorMove_rec.line_id <>
640: p_old_ShopFloorMove_rec.line_id OR
641: p_old_ShopFloorMove_rec.line_id IS NULL )
642: THEN
643: IF NOT WIP_Validate.Line(p_ShopFloorMove_rec.line_id) THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: END IF;
646: END IF;
647:

Line 653: IF NOT WIP_Validate.Organization(p_ShopFloorMove_rec.organization_id) THEN

649: ( p_ShopFloorMove_rec.organization_code <>
650: p_old_ShopFloorMove_rec.organization_code OR
651: p_old_ShopFloorMove_rec.organization_code IS NULL )
652: THEN
653: IF NOT WIP_Validate.Organization(p_ShopFloorMove_rec.organization_id) THEN
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: END IF;
656: END IF;
657:

Line 663: IF NOT WIP_Validate.Organization(p_ShopFloorMove_rec.organization_id) THEN

659: ( p_ShopFloorMove_rec.organization_id <>
660: p_old_ShopFloorMove_rec.organization_id OR
661: p_old_ShopFloorMove_rec.organization_id IS NULL )
662: THEN
663: IF NOT WIP_Validate.Organization(p_ShopFloorMove_rec.organization_id) THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: END IF;
666: END IF;
667:

Line 673: IF NOT WIP_Validate.Primary_Item(p_ShopFloorMove_rec.primary_item_id,

669: ( p_ShopFloorMove_rec.primary_item_id <>
670: p_old_ShopFloorMove_rec.primary_item_id OR
671: p_old_ShopFloorMove_rec.primary_item_id IS NULL )
672: THEN
673: IF NOT WIP_Validate.Primary_Item(p_ShopFloorMove_rec.primary_item_id,
674: p_ShopFloorMove_rec.organization_id) THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677: END IF;

Line 684: IF NOT WIP_Validate.Primary_Uom(p_ShopFloorMove_rec.primary_uom) THEN

680: ( p_ShopFloorMove_rec.primary_uom <>
681: p_old_ShopFloorMove_rec.primary_uom OR
682: p_old_ShopFloorMove_rec.primary_uom IS NULL )
683: THEN
684: IF NOT WIP_Validate.Primary_Uom(p_ShopFloorMove_rec.primary_uom) THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: END IF;
688:

Line 694: IF NOT WIP_Validate.Process_Phase(p_ShopFloorMove_rec.process_phase,

690: ( p_ShopFloorMove_rec.process_phase <>
691: p_old_ShopFloorMove_rec.process_phase OR
692: p_old_ShopFloorMove_rec.process_phase IS NULL )
693: THEN
694: IF NOT WIP_Validate.Process_Phase(p_ShopFloorMove_rec.process_phase,
695: 'WIP_MOVE_PROCESS_PHASE') THEN
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: END IF;
698: END IF;

Line 705: IF NOT WIP_Validate.Process_Status(p_ShopFloorMove_rec.process_status) THEN

701: ( p_ShopFloorMove_rec.process_status <>
702: p_old_ShopFloorMove_rec.process_status OR
703: p_old_ShopFloorMove_rec.process_status IS NULL )
704: THEN
705: IF NOT WIP_Validate.Process_Status(p_ShopFloorMove_rec.process_status) THEN
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: END IF;
708: END IF;
709:

Line 715: IF NOT WIP_Validate.Reason(p_ShopFloorMove_rec.reason_id) THEN

711: ( p_ShopFloorMove_rec.reason_id <>
712: p_old_ShopFloorMove_rec.reason_id OR
713: p_old_ShopFloorMove_rec.reason_id IS NULL )
714: THEN
715: IF NOT WIP_Validate.Reason(p_ShopFloorMove_rec.reason_id) THEN
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: END IF;
718: END IF;
719:

Line 725: IF NOT WIP_Validate.Reason_Name(p_ShopFloorMove_rec.reason_name) THEN

721: ( p_ShopFloorMove_rec.reason_name <>
722: p_old_ShopFloorMove_rec.reason_name OR
723: p_old_ShopFloorMove_rec.reason_name IS NULL )
724: THEN
725: IF NOT WIP_Validate.Reason_Name(p_ShopFloorMove_rec.reason_name) THEN
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: END IF;
728: END IF;
729:

Line 735: IF NOT WIP_Validate.Repetitive_Schedule(p_ShopFloorMove_rec.repetitive_schedule_id) THEN

731: ( p_ShopFloorMove_rec.repetitive_schedule_id <>
732: p_old_ShopFloorMove_rec.repetitive_schedule_id OR
733: p_old_ShopFloorMove_rec.repetitive_schedule_id IS NULL )
734: THEN
735: IF NOT WIP_Validate.Repetitive_Schedule(p_ShopFloorMove_rec.repetitive_schedule_id) THEN
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: END IF;
738: END IF;
739:

Line 745: IF NOT WIP_Validate.Scrap_Account(p_ShopFloorMove_rec.scrap_account_id) THEN

741: ( p_ShopFloorMove_rec.scrap_account_id <>
742: p_old_ShopFloorMove_rec.scrap_account_id OR
743: p_old_ShopFloorMove_rec.scrap_account_id IS NULL )
744: THEN
745: IF NOT WIP_Validate.Scrap_Account(p_ShopFloorMove_rec.scrap_account_id) THEN
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: END IF;
748: END IF;
749:

Line 755: IF NOT WIP_Validate.Department_Code(p_ShopFloorMove_rec.to_department_code,

751: ( p_ShopFloorMove_rec.to_department_code <>
752: p_old_ShopFloorMove_rec.to_department_code OR
753: p_old_ShopFloorMove_rec.to_department_code IS NULL )
754: THEN
755: IF NOT WIP_Validate.Department_Code(p_ShopFloorMove_rec.to_department_code,
756: p_ShopFloorMove_rec.organization_id,
757: 'to_department_code') THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: END IF;

Line 767: IF NOT WIP_Validate.Department_Id(p_ShopFloorMove_rec.to_department_id,

763: ( p_ShopFloorMove_rec.to_department_id <>
764: p_old_ShopFloorMove_rec.to_department_id OR
765: p_old_ShopFloorMove_rec.to_department_id IS NULL )
766: THEN
767: IF NOT WIP_Validate.Department_Id(p_ShopFloorMove_rec.to_department_id,
768: 'to_department_id') THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;
771: END IF;

Line 778: IF NOT WIP_Validate.Intraop_Step_Type(p_ShopFloorMove_rec.to_intraop_step_type,

774: ( p_ShopFloorMove_rec.to_intraop_step_type <>
775: p_old_ShopFloorMove_rec.to_intraop_step_type OR
776: p_old_ShopFloorMove_rec.to_intraop_step_type IS NULL )
777: THEN
778: IF NOT WIP_Validate.Intraop_Step_Type(p_ShopFloorMove_rec.to_intraop_step_type,
779: 'to_intraop_step_type') THEN
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: END IF;
782: END IF;

Line 789: IF NOT WIP_Validate.Operation_Code(p_ShopFloorMove_rec.to_operation_code,

785: ( p_ShopFloorMove_rec.to_operation_code <>
786: p_old_ShopFloorMove_rec.to_operation_code OR
787: p_old_ShopFloorMove_rec.to_operation_code IS NULL )
788: THEN
789: IF NOT WIP_Validate.Operation_Code(p_ShopFloorMove_rec.to_operation_code,
790: 'to_operation_code') THEN
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: END IF;
793: END IF;

Line 800: IF NOT WIP_Validate.Operation_Seq_Num(p_ShopFloorMove_rec.to_operation_seq_num,

796: ( p_ShopFloorMove_rec.to_operation_seq_num <>
797: p_old_ShopFloorMove_rec.to_operation_seq_num OR
798: p_old_ShopFloorMove_rec.to_operation_seq_num IS NULL )
799: THEN
800: IF NOT WIP_Validate.Operation_Seq_Num(p_ShopFloorMove_rec.to_operation_seq_num,
801: 'to_operation_seq_num') THEN
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: END IF;
804: END IF;

Line 811: IF NOT WIP_Validate.Transaction_Type(p_ShopFloorMove_rec.transaction_type, 'WIP_MOVE_TRANSACTION_TYPE') THEN

807: ( p_ShopFloorMove_rec.transaction_type <>
808: p_old_ShopFloorMove_rec.transaction_type OR
809: p_old_ShopFloorMove_rec.transaction_type IS NULL )
810: THEN
811: IF NOT WIP_Validate.Transaction_Type(p_ShopFloorMove_rec.transaction_type, 'WIP_MOVE_TRANSACTION_TYPE') THEN
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: END IF;
814: END IF;
815:

Line 821: IF NOT WIP_Validate.Transaction_Uom(p_ShopFloorMove_rec.transaction_uom) THEN

817: ( p_ShopFloorMove_rec.transaction_uom <>
818: p_old_ShopFloorMove_rec.transaction_uom OR
819: p_old_ShopFloorMove_rec.transaction_uom IS NULL )
820: THEN
821: IF NOT WIP_Validate.Transaction_Uom(p_ShopFloorMove_rec.transaction_uom) THEN
822: x_return_status := FND_API.G_RET_STS_ERROR;
823: END IF;
824: END IF;
825:

Line 831: IF NOT WIP_Validate.Wip_Entity(p_ShopFloorMove_rec.wip_entity_id) THEN

827: ( p_ShopFloorMove_rec.wip_entity_id <>
828: p_old_ShopFloorMove_rec.wip_entity_id OR
829: p_old_ShopFloorMove_rec.wip_entity_id IS NULL )
830: THEN
831: IF NOT WIP_Validate.Wip_Entity(p_ShopFloorMove_rec.wip_entity_id) THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: END IF;
834: END IF;
835:

Line 841: IF NOT WIP_Validate.Wip_Entity_Name(p_ShopFloorMove_rec.wip_entity_name,

837: ( p_ShopFloorMove_rec.wip_entity_name <>
838: p_old_ShopFloorMove_rec.wip_entity_name OR
839: p_old_ShopFloorMove_rec.wip_entity_name IS NULL )
840: THEN
841: IF NOT WIP_Validate.Wip_Entity_Name(p_ShopFloorMove_rec.wip_entity_name,
842: p_ShopFloorMove_rec.organization_id) THEN
843: x_return_status := FND_API.G_RET_STS_ERROR;
844: END IF;
845: END IF;

Line 875: END WIP_Validate_Shopfloormove;

871:
872: END Attributes;
873:
874:
875: END WIP_Validate_Shopfloormove;