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.WIP_VALIDATE_RES dependencies on WIP_VALIDATE

Line 1: PACKAGE BODY WIP_Validate_Res AS

1: PACKAGE BODY WIP_Validate_Res AS
2: /* $Header: WIPLRESB.pls 115.11 2002/11/28 11:43:17 rmahidha ship $ */
3:
4: -- Global constant holding the package name
5:

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

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

Line 463: IF NOT WIP_Validate.Acct_Period(p_Res_rec.acct_period_id,

459: ( p_Res_rec.acct_period_id <>
460: p_old_Res_rec.acct_period_id OR
461: p_old_Res_rec.acct_period_id IS NULL )
462: THEN
463: IF NOT WIP_Validate.Acct_Period(p_Res_rec.acct_period_id,
464: p_Res_rec.organization_id) THEN
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: END IF;
467: END IF;

Line 474: IF NOT WIP_Validate.Activity(p_Res_rec.activity_id) THEN

470: ( p_Res_rec.activity_id <>
471: p_old_Res_rec.activity_id OR
472: p_old_Res_rec.activity_id IS NULL )
473: THEN
474: IF NOT WIP_Validate.Activity(p_Res_rec.activity_id) THEN
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: END IF;
477: END IF;
478:

Line 484: IF NOT WIP_Validate.Activity_Name(p_Res_rec.activity_name) THEN

480: ( p_Res_rec.activity_name <>
481: p_old_Res_rec.activity_name OR
482: p_old_Res_rec.activity_name IS NULL )
483: THEN
484: IF NOT WIP_Validate.Activity_Name(p_Res_rec.activity_name) THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: END IF;
487: END IF;
488:

Line 494: IF NOT WIP_Validate.Actual_Resource_Rate(p_Res_rec.actual_resource_rate) THEN

490: ( p_Res_rec.actual_resource_rate <>
491: p_old_Res_rec.actual_resource_rate OR
492: p_old_Res_rec.actual_resource_rate IS NULL )
493: THEN
494: IF NOT WIP_Validate.Actual_Resource_Rate(p_Res_rec.actual_resource_rate) THEN
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: END IF;
497: END IF;
498:

Line 504: IF NOT WIP_Validate.Autocharge_Type(p_Res_rec.autocharge_type) THEN

500: ( p_Res_rec.autocharge_type <>
501: p_old_Res_rec.autocharge_type OR
502: p_old_Res_rec.autocharge_type IS NULL )
503: THEN
504: IF NOT WIP_Validate.Autocharge_Type(p_Res_rec.autocharge_type) THEN
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: END IF;
507: END IF;
508:

Line 514: IF NOT WIP_Validate.Basis_Type(p_Res_rec.basis_type) THEN

510: ( p_Res_rec.basis_type <>
511: p_old_Res_rec.basis_type OR
512: p_old_Res_rec.basis_type IS NULL )
513: THEN
514: IF NOT WIP_Validate.Basis_Type(p_Res_rec.basis_type) THEN
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: END IF;
517: END IF;
518:

Line 524: IF NOT WIP_Validate.Completion_Transaction(p_Res_rec.completion_transaction_id) THEN

520: ( p_Res_rec.completion_transaction_id <>
521: p_old_Res_rec.completion_transaction_id OR
522: p_old_Res_rec.completion_transaction_id IS NULL )
523: THEN
524: IF NOT WIP_Validate.Completion_Transaction(p_Res_rec.completion_transaction_id) THEN
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: END IF;
527: END IF;
528:

Line 535: IF NOT WIP_Validate.Created_By(p_Res_rec.created_by) THEN

531: ( p_Res_rec.created_by <>
532: p_old_Res_rec.created_by OR
533: p_old_Res_rec.created_by IS NULL )
534: THEN
535: IF NOT WIP_Validate.Created_By(p_Res_rec.created_by) THEN
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: END IF;
538: END IF;
539: */

Line 546: IF NOT WIP_Validate.Created_By_Name(p_Res_rec.created_by_name) THEN

542: ( p_Res_rec.created_by_name <>
543: p_old_Res_rec.created_by_name OR
544: p_old_Res_rec.created_by_name IS NULL )
545: THEN
546: IF NOT WIP_Validate.Created_By_Name(p_Res_rec.created_by_name) THEN
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;
550:

Line 557: IF NOT WIP_Validate.Creation_Date(p_Res_rec.creation_date) THEN

553: ( p_Res_rec.creation_date <>
554: p_old_Res_rec.creation_date OR
555: p_old_Res_rec.creation_date IS NULL )
556: THEN
557: IF NOT WIP_Validate.Creation_Date(p_Res_rec.creation_date) THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: END IF;
560: END IF;
561: */

Line 568: IF NOT WIP_Validate.Currency_Actual_Rsc_Rate(p_Res_rec.currency_actual_rsc_rate) THEN

564: ( p_Res_rec.currency_actual_rsc_rate <>
565: p_old_Res_rec.currency_actual_rsc_rate OR
566: p_old_Res_rec.currency_actual_rsc_rate IS NULL )
567: THEN
568: IF NOT WIP_Validate.Currency_Actual_Rsc_Rate(p_Res_rec.currency_actual_rsc_rate) THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: END IF;
571: END IF;
572:

Line 578: IF NOT WIP_Validate.Currency(p_Res_rec.currency_code) THEN

574: ( p_Res_rec.currency_code <>
575: p_old_Res_rec.currency_code OR
576: p_old_Res_rec.currency_code IS NULL )
577: THEN
578: IF NOT WIP_Validate.Currency(p_Res_rec.currency_code) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: END IF;
581: END IF;
582:

Line 588: IF NOT WIP_Validate.Currency_Conversion_Date(p_Res_rec.currency_conversion_date) THEN

584: ( p_Res_rec.currency_conversion_date <>
585: p_old_Res_rec.currency_conversion_date OR
586: p_old_Res_rec.currency_conversion_date IS NULL )
587: THEN
588: IF NOT WIP_Validate.Currency_Conversion_Date(p_Res_rec.currency_conversion_date) THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: END IF;
591: END IF;
592:

Line 598: IF NOT WIP_Validate.Currency_Conversion_Rate(p_Res_rec.currency_conversion_rate) THEN

594: ( p_Res_rec.currency_conversion_rate <>
595: p_old_Res_rec.currency_conversion_rate OR
596: p_old_Res_rec.currency_conversion_rate IS NULL )
597: THEN
598: IF NOT WIP_Validate.Currency_Conversion_Rate(p_Res_rec.currency_conversion_rate) THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601: END IF;
602:

Line 608: IF NOT WIP_Validate.Currency_Conversion_Type(p_Res_rec.currency_conversion_type) THEN

604: ( p_Res_rec.currency_conversion_type <>
605: p_old_Res_rec.currency_conversion_type OR
606: p_old_Res_rec.currency_conversion_type IS NULL )
607: THEN
608: IF NOT WIP_Validate.Currency_Conversion_Type(p_Res_rec.currency_conversion_type) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: END IF;
611: END IF;
612:

Line 618: IF NOT WIP_Validate.Department_Code(p_Res_rec.department_code, p_Res_rec.organization_id) THEN

614: ( p_Res_rec.department_code <>
615: p_old_Res_rec.department_code OR
616: p_old_Res_rec.department_code IS NULL )
617: THEN
618: IF NOT WIP_Validate.Department_Code(p_Res_rec.department_code, p_Res_rec.organization_id) THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;
621: END IF;
622:

Line 628: IF NOT WIP_Validate.Department_Id(p_Res_rec.department_id, p_Res_rec.organization_id) THEN

624: ( p_Res_rec.department_id <>
625: p_old_Res_rec.department_id OR
626: p_old_Res_rec.department_id IS NULL )
627: THEN
628: IF NOT WIP_Validate.Department_Id(p_Res_rec.department_id, p_Res_rec.organization_id) THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: END IF;
631: END IF;
632:

Line 638: IF NOT WIP_Validate.Employee(p_Res_rec.employee_id) THEN

634: ( p_Res_rec.employee_id <>
635: p_old_Res_rec.employee_id OR
636: p_old_Res_rec.employee_id IS NULL )
637: THEN
638: IF NOT WIP_Validate.Employee(p_Res_rec.employee_id) THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END IF;
641: END IF;
642:

Line 648: IF NOT WIP_Validate.Employee_Num(p_Res_rec.employee_num) THEN

644: ( p_Res_rec.employee_num <>
645: p_old_Res_rec.employee_num OR
646: p_old_Res_rec.employee_num IS NULL )
647: THEN
648: IF NOT WIP_Validate.Employee_Num(p_Res_rec.employee_num) THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: END IF;
651: END IF;
652:

Line 658: IF NOT WIP_Validate.Entity_Type(p_Res_rec.entity_type) THEN

654: ( p_Res_rec.entity_type <>
655: p_old_Res_rec.entity_type OR
656: p_old_Res_rec.entity_type IS NULL )
657: THEN
658: IF NOT WIP_Validate.Entity_Type(p_Res_rec.entity_type) THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: END IF;
661: END IF;
662:

Line 668: IF NOT WIP_Validate.Group_Id(p_Res_rec.group_id) THEN

664: ( p_Res_rec.group_id <>
665: p_old_Res_rec.group_id OR
666: p_old_Res_rec.group_id IS NULL )
667: THEN
668: IF NOT WIP_Validate.Group_Id(p_Res_rec.group_id) THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: END IF;
671: END IF;
672:

Line 679: IF NOT WIP_Validate.Last_Updated_By(p_Res_rec.last_updated_by) THEN

675: ( p_Res_rec.last_updated_by <>
676: p_old_Res_rec.last_updated_by OR
677: p_old_Res_rec.last_updated_by IS NULL )
678: THEN
679: IF NOT WIP_Validate.Last_Updated_By(p_Res_rec.last_updated_by) THEN
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: END IF;
682: END IF;
683: */

Line 690: IF NOT WIP_Validate.Last_Updated_By_Name(p_Res_rec.last_updated_by_name) THEN

686: ( p_Res_rec.last_updated_by_name <>
687: p_old_Res_rec.last_updated_by_name OR
688: p_old_Res_rec.last_updated_by_name IS NULL )
689: THEN
690: IF NOT WIP_Validate.Last_Updated_By_Name(p_Res_rec.last_updated_by_name) THEN
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: END IF;
693: END IF;
694:

Line 701: IF NOT WIP_Validate.Last_Update_Date(p_Res_rec.last_update_date) THEN

697: ( p_Res_rec.last_update_date <>
698: p_old_Res_rec.last_update_date OR
699: p_old_Res_rec.last_update_date IS NULL )
700: THEN
701: IF NOT WIP_Validate.Last_Update_Date(p_Res_rec.last_update_date) THEN
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: END IF;
704: END IF;
705:

Line 711: IF NOT WIP_Validate.Last_Update_Login(p_Res_rec.last_update_login) THEN

707: ( p_Res_rec.last_update_login <>
708: p_old_Res_rec.last_update_login OR
709: p_old_Res_rec.last_update_login IS NULL )
710: THEN
711: IF NOT WIP_Validate.Last_Update_Login(p_Res_rec.last_update_login) THEN
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: END IF;
714: END IF;
715: */

Line 722: IF NOT WIP_Validate.Line(p_Res_rec.line_code) THEN

718: ( p_Res_rec.line_code <>
719: p_old_Res_rec.line_code OR
720: p_old_Res_rec.line_code IS NULL )
721: THEN
722: IF NOT WIP_Validate.Line(p_Res_rec.line_code) THEN
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: END IF;
725: END IF;
726:

Line 732: IF NOT WIP_Validate.Line(p_Res_rec.line_id) THEN

728: ( p_Res_rec.line_id <>
729: p_old_Res_rec.line_id OR
730: p_old_Res_rec.line_id IS NULL )
731: THEN
732: IF NOT WIP_Validate.Line(p_Res_rec.line_id) THEN
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: END IF;
735: END IF;
736:

Line 742: IF NOT WIP_Validate.Move_Transaction(p_Res_rec.move_transaction_id) THEN

738: ( p_Res_rec.move_transaction_id <>
739: p_old_Res_rec.move_transaction_id OR
740: p_old_Res_rec.move_transaction_id IS NULL )
741: THEN
742: IF NOT WIP_Validate.Move_Transaction(p_Res_rec.move_transaction_id) THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: END IF;
745: END IF;
746:

Line 752: IF NOT WIP_Validate.Operation_Seq_Num(p_Res_rec.operation_seq_num) THEN

748: ( p_Res_rec.operation_seq_num <>
749: p_old_Res_rec.operation_seq_num OR
750: p_old_Res_rec.operation_seq_num IS NULL )
751: THEN
752: IF NOT WIP_Validate.Operation_Seq_Num(p_Res_rec.operation_seq_num) THEN
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: END IF;
755: END IF;
756:

Line 762: IF NOT WIP_Validate.Organization(p_Res_rec.organization_id) THEN

758: ( p_Res_rec.organization_code <>
759: p_old_Res_rec.organization_code OR
760: p_old_Res_rec.organization_code IS NULL )
761: THEN
762: IF NOT WIP_Validate.Organization(p_Res_rec.organization_id) THEN
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: END IF;
765: END IF;
766:

Line 772: IF NOT WIP_Validate.Organization(p_Res_rec.organization_id) THEN

768: ( p_Res_rec.organization_id <>
769: p_old_Res_rec.organization_id OR
770: p_old_Res_rec.organization_id IS NULL )
771: THEN
772: IF NOT WIP_Validate.Organization(p_Res_rec.organization_id) THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: END IF;
775: END IF;
776:

Line 782: IF NOT WIP_Validate.Po_Header(p_Res_rec.po_header_id) THEN

778: ( p_Res_rec.po_header_id <>
779: p_old_Res_rec.po_header_id OR
780: p_old_Res_rec.po_header_id IS NULL )
781: THEN
782: IF NOT WIP_Validate.Po_Header(p_Res_rec.po_header_id) THEN
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: END IF;
785: END IF;
786:

Line 792: IF NOT WIP_Validate.Po_Line(p_Res_rec.po_line_id) THEN

788: ( p_Res_rec.po_line_id <>
789: p_old_Res_rec.po_line_id OR
790: p_old_Res_rec.po_line_id IS NULL )
791: THEN
792: IF NOT WIP_Validate.Po_Line(p_Res_rec.po_line_id) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: END IF;
795: END IF;
796:

Line 802: IF NOT WIP_Validate.Primary_Item(p_Res_rec.primary_item_id,

798: ( p_Res_rec.primary_item_id <>
799: p_old_Res_rec.primary_item_id OR
800: p_old_Res_rec.primary_item_id IS NULL )
801: THEN
802: IF NOT WIP_Validate.Primary_Item(p_Res_rec.primary_item_id,
803: p_Res_rec.organization_id) THEN
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: END IF;
806: END IF;

Line 813: IF NOT WIP_Validate.Primary_Quantity(p_Res_rec.primary_quantity) THEN

809: ( p_Res_rec.primary_quantity <>
810: p_old_Res_rec.primary_quantity OR
811: p_old_Res_rec.primary_quantity IS NULL )
812: THEN
813: IF NOT WIP_Validate.Primary_Quantity(p_Res_rec.primary_quantity) THEN
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;
816: END IF;
817:

Line 823: IF NOT WIP_Validate.Primary_Uom(p_Res_rec.primary_uom) THEN

819: ( p_Res_rec.primary_uom <>
820: p_old_Res_rec.primary_uom OR
821: p_old_Res_rec.primary_uom IS NULL )
822: THEN
823: IF NOT WIP_Validate.Primary_Uom(p_Res_rec.primary_uom) THEN
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: END IF;
826: END IF;
827:

Line 833: IF NOT WIP_Validate.Primary_Uom_Class(p_Res_rec.primary_uom_class) THEN

829: ( p_Res_rec.primary_uom_class <>
830: p_old_Res_rec.primary_uom_class OR
831: p_old_Res_rec.primary_uom_class IS NULL )
832: THEN
833: IF NOT WIP_Validate.Primary_Uom_Class(p_Res_rec.primary_uom_class) THEN
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: END IF;
836: END IF;
837:

Line 843: IF NOT WIP_Validate.Process_Phase(p_Res_rec.process_phase, 'WIP_RESOURCE_PROCESS_PHASE') THEN

839: ( p_Res_rec.process_phase <>
840: p_old_Res_rec.process_phase OR
841: p_old_Res_rec.process_phase IS NULL )
842: THEN
843: IF NOT WIP_Validate.Process_Phase(p_Res_rec.process_phase, 'WIP_RESOURCE_PROCESS_PHASE') THEN
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: END IF;
846: END IF;
847:

Line 853: IF NOT WIP_Validate.Process_Status(p_Res_rec.process_status) THEN

849: ( p_Res_rec.process_status <>
850: p_old_Res_rec.process_status OR
851: p_old_Res_rec.process_status IS NULL )
852: THEN
853: IF NOT WIP_Validate.Process_Status(p_Res_rec.process_status) THEN
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: END IF;
856: END IF;
857:

Line 864: IF NOT WIP_Validate.Program_Application(p_Res_rec.program_application_id) THEN

860: ( p_Res_rec.program_application_id <>
861: p_old_Res_rec.program_application_id OR
862: p_old_Res_rec.program_application_id IS NULL )
863: THEN
864: IF NOT WIP_Validate.Program_Application(p_Res_rec.program_application_id) THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: END IF;
867: END IF;
868:

Line 874: IF NOT WIP_Validate.Program(p_Res_rec.program_id) THEN

870: ( p_Res_rec.program_id <>
871: p_old_Res_rec.program_id OR
872: p_old_Res_rec.program_id IS NULL )
873: THEN
874: IF NOT WIP_Validate.Program(p_Res_rec.program_id) THEN
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END IF;
877: END IF;
878:

Line 884: IF NOT WIP_Validate.Program_Update_Date(p_Res_rec.program_update_date) THEN

880: ( p_Res_rec.program_update_date <>
881: p_old_Res_rec.program_update_date OR
882: p_old_Res_rec.program_update_date IS NULL )
883: THEN
884: IF NOT WIP_Validate.Program_Update_Date(p_Res_rec.program_update_date) THEN
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: END IF;
887: END IF;
888: */

Line 895: IF NOT WIP_Validate.Project(p_Res_rec.project_id,

891: ( p_Res_rec.project_id <>
892: p_old_Res_rec.project_id OR
893: p_old_Res_rec.project_id IS NULL )
894: THEN
895: IF NOT WIP_Validate.Project(p_Res_rec.project_id,
896: p_Res_rec.organization_id) THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: END IF;
899: END IF;

Line 910: IF NOT WIP_Validate.Rcv_Transaction(p_Res_rec.source_line_id) THEN

906: --rcv_transaction_id is the transaction_id. we actually need to
907: --validate against the rcv_transactions_interface table and thus
908: --need to pass the interface_transaction_id...source line id should
909: --always be populated if rcv_transaction_id is populated
910: IF NOT WIP_Validate.Rcv_Transaction(p_Res_rec.source_line_id) THEN
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: END IF;
913: END IF;
914:

Line 920: IF NOT WIP_Validate.Reason(p_Res_rec.reason_id) THEN

916: ( p_Res_rec.reason_id <>
917: p_old_Res_rec.reason_id OR
918: p_old_Res_rec.reason_id IS NULL )
919: THEN
920: IF NOT WIP_Validate.Reason(p_Res_rec.reason_id) THEN
921: x_return_status := FND_API.G_RET_STS_ERROR;
922: END IF;
923: END IF;
924:

Line 930: IF NOT WIP_Validate.Reason_Name(p_Res_rec.reason_name) THEN

926: ( p_Res_rec.reason_name <>
927: p_old_Res_rec.reason_name OR
928: p_old_Res_rec.reason_name IS NULL )
929: THEN
930: IF NOT WIP_Validate.Reason_Name(p_Res_rec.reason_name) THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: END IF;
933: END IF;
934:

Line 940: IF NOT WIP_Validate.Receiving_Account(p_Res_rec.receiving_account_id) THEN

936: ( p_Res_rec.receiving_account_id <>
937: p_old_Res_rec.receiving_account_id OR
938: p_old_Res_rec.receiving_account_id IS NULL )
939: THEN
940: IF NOT WIP_Validate.Receiving_Account(p_Res_rec.receiving_account_id) THEN
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: END IF;
943: END IF;
944:

Line 950: IF NOT WIP_Validate.Reference(p_Res_rec.reference) THEN

946: ( p_Res_rec.reference <>
947: p_old_Res_rec.reference OR
948: p_old_Res_rec.reference IS NULL )
949: THEN
950: IF NOT WIP_Validate.Reference(p_Res_rec.reference) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: END IF;
953: END IF;
954:

Line 960: IF NOT WIP_Validate.Repetitive_Schedule(p_Res_rec.repetitive_schedule_id) THEN

956: ( p_Res_rec.repetitive_schedule_id <>
957: p_old_Res_rec.repetitive_schedule_id OR
958: p_old_Res_rec.repetitive_schedule_id IS NULL )
959: THEN
960: IF NOT WIP_Validate.Repetitive_Schedule(p_Res_rec.repetitive_schedule_id) THEN
961: x_return_status := FND_API.G_RET_STS_ERROR;
962: END IF;
963: END IF;
964:

Line 971: IF NOT WIP_Validate.Request(p_Res_rec.request_id) THEN

967: ( p_Res_rec.request_id <>
968: p_old_Res_rec.request_id OR
969: p_old_Res_rec.request_id IS NULL )
970: THEN
971: IF NOT WIP_Validate.Request(p_Res_rec.request_id) THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: END IF;
974: END IF;
975: */

Line 982: IF NOT WIP_Validate.Resource_Code(p_Res_rec.resource_code, p_Res_rec.organization_id) THEN

978: ( p_Res_rec.resource_code <>
979: p_old_Res_rec.resource_code OR
980: p_old_Res_rec.resource_code IS NULL )
981: THEN
982: IF NOT WIP_Validate.Resource_Code(p_Res_rec.resource_code, p_Res_rec.organization_id) THEN
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: END IF;
985: END IF;
986:

Line 992: IF NOT WIP_Validate.Resource_Id(p_Res_rec.resource_id) THEN

988: ( p_Res_rec.resource_id <>
989: p_old_Res_rec.resource_id OR
990: p_old_Res_rec.resource_id IS NULL )
991: THEN
992: IF NOT WIP_Validate.Resource_Id(p_Res_rec.resource_id) THEN
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: END IF;
995: END IF;
996:

Line 1002: IF NOT WIP_Validate.Resource_Seq_Num(p_Res_rec.resource_seq_num) THEN

998: ( p_Res_rec.resource_seq_num <>
999: p_old_Res_rec.resource_seq_num OR
1000: p_old_Res_rec.resource_seq_num IS NULL )
1001: THEN
1002: IF NOT WIP_Validate.Resource_Seq_Num(p_Res_rec.resource_seq_num) THEN
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004: END IF;
1005: END IF;
1006:

Line 1012: IF NOT WIP_Validate.Resource_Type(p_Res_rec.resource_type) THEN

1008: ( p_Res_rec.resource_type <>
1009: p_old_Res_rec.resource_type OR
1010: p_old_Res_rec.resource_type IS NULL )
1011: THEN
1012: IF NOT WIP_Validate.Resource_Type(p_Res_rec.resource_type) THEN
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: END IF;
1015: END IF;
1016:

Line 1023: IF NOT WIP_Validate.Source(p_Res_rec.source_code) THEN

1019: ( p_Res_rec.source_code <>
1020: p_old_Res_rec.source_code OR
1021: p_old_Res_rec.source_code IS NULL )
1022: THEN
1023: IF NOT WIP_Validate.Source(p_Res_rec.source_code) THEN
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: END IF;
1026: END IF;
1027:

Line 1033: IF NOT WIP_Validate.Source_Line(p_Res_rec.source_line_id) THEN

1029: ( p_Res_rec.source_line_id <>
1030: p_old_Res_rec.source_line_id OR
1031: p_old_Res_rec.source_line_id IS NULL )
1032: THEN
1033: IF NOT WIP_Validate.Source_Line(p_Res_rec.source_line_id) THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;
1036: END IF;
1037: */

Line 1043: IF NOT WIP_Validate.Standard_Rate(p_Res_rec.standard_rate_flag) THEN

1039: ( p_Res_rec.standard_rate_flag <>
1040: p_old_Res_rec.standard_rate_flag OR
1041: p_old_Res_rec.standard_rate_flag IS NULL )
1042: THEN
1043: IF NOT WIP_Validate.Standard_Rate(p_Res_rec.standard_rate_flag) THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: END IF;
1046: END IF;
1047:

Line 1053: IF NOT WIP_Validate.Task(p_Res_rec.task_id,

1049: ( p_Res_rec.task_id <>
1050: p_old_Res_rec.task_id OR
1051: p_old_Res_rec.task_id IS NULL )
1052: THEN
1053: IF NOT WIP_Validate.Task(p_Res_rec.task_id,
1054: p_Res_rec.project_id,
1055: p_Res_rec.organization_id) THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: END IF;

Line 1066: IF NOT WIP_Validate.Transaction_Date(p_Res_rec.transaction_date) THEN

1062: ( p_Res_rec.transaction_date <>
1063: p_old_Res_rec.transaction_date OR
1064: p_old_Res_rec.transaction_date IS NULL )
1065: THEN
1066: IF NOT WIP_Validate.Transaction_Date(p_Res_rec.transaction_date) THEN
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;
1070: */

Line 1077: IF NOT WIP_Validate.Transaction(p_Res_rec.transaction_id) THEN

1073: ( p_Res_rec.transaction_id <>
1074: p_old_Res_rec.transaction_id OR
1075: p_old_Res_rec.transaction_id IS NULL )
1076: THEN
1077: IF NOT WIP_Validate.Transaction(p_Res_rec.transaction_id) THEN
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: END IF;
1080: END IF;
1081:

Line 1088: IF NOT WIP_Validate.Transaction_Quantity(p_Res_rec.transaction_quantity) THEN

1084: ( p_Res_rec.transaction_quantity <>
1085: p_old_Res_rec.transaction_quantity OR
1086: p_old_Res_rec.transaction_quantity IS NULL )
1087: THEN
1088: IF NOT WIP_Validate.Transaction_Quantity(p_Res_rec.transaction_quantity) THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: END IF;
1091: END IF;
1092: */

Line 1099: IF NOT WIP_Validate.Transaction_Type(p_Res_rec.transaction_type, 'WIP_TRANSACTION_TYPE' ) THEN

1095: ( p_Res_rec.transaction_type <>
1096: p_old_Res_rec.transaction_type OR
1097: p_old_Res_rec.transaction_type IS NULL )
1098: THEN
1099: IF NOT WIP_Validate.Transaction_Type(p_Res_rec.transaction_type, 'WIP_TRANSACTION_TYPE' ) THEN
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: END IF;
1102: END IF;
1103:

Line 1109: IF NOT WIP_Validate.Transaction_Uom(p_Res_rec.transaction_uom) THEN

1105: ( p_Res_rec.transaction_uom <>
1106: p_old_Res_rec.transaction_uom OR
1107: p_old_Res_rec.transaction_uom IS NULL )
1108: THEN
1109: IF NOT WIP_Validate.Transaction_Uom(p_Res_rec.transaction_uom) THEN
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111: END IF;
1112: END IF;
1113:

Line 1119: IF NOT WIP_Validate.Usage_Rate_Or_Amount(p_Res_rec.usage_rate_or_amount) THEN

1115: ( p_Res_rec.usage_rate_or_amount <>
1116: p_old_Res_rec.usage_rate_or_amount OR
1117: p_old_Res_rec.usage_rate_or_amount IS NULL )
1118: THEN
1119: IF NOT WIP_Validate.Usage_Rate_Or_Amount(p_Res_rec.usage_rate_or_amount) THEN
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: END IF;
1122: END IF;
1123:

Line 1129: IF NOT WIP_Validate.Wip_Entity(p_Res_rec.wip_entity_id) THEN

1125: ( p_Res_rec.wip_entity_id <>
1126: p_old_Res_rec.wip_entity_id OR
1127: p_old_Res_rec.wip_entity_id IS NULL )
1128: THEN
1129: IF NOT WIP_Validate.Wip_Entity(p_Res_rec.wip_entity_id) THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: END IF;
1132: END IF;
1133:

Line 1139: IF NOT WIP_Validate.Wip_Entity_Name(p_Res_rec.wip_entity_name,

1135: ( p_Res_rec.wip_entity_name <>
1136: p_old_Res_rec.wip_entity_name OR
1137: p_old_Res_rec.wip_entity_name IS NULL )
1138: THEN
1139: IF NOT WIP_Validate.Wip_Entity_Name(p_Res_rec.wip_entity_name,
1140: p_Res_rec.organization_id) THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: END IF;
1143: END IF;

Line 1281: IF NOT WIP_Validate.Desc_Flex( 'OSP' ) THEN

1277: );
1278:
1279: -- Validate descriptive flexfield.
1280:
1281: IF NOT WIP_Validate.Desc_Flex( 'OSP' ) THEN
1282: x_return_status := FND_API.G_RET_STS_ERROR;
1283: END IF;
1284:
1285: */

Line 1314: END WIP_Validate_Res;

1310: END IF;
1311:
1312: END Attributes;
1313:
1314: END WIP_Validate_Res;