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.QP_VALIDATE_LIMITS dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Limits AS

1: PACKAGE BODY QP_Validate_Limits AS
2: /* $Header: QPXLLMTB.pls 120.1 2005/06/08 04:27:49 appldev $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: QPXLLMTB.pls 120.1 2005/06/08 04:27:49 appldev $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Limits';
7:
8: PROCEDURE Validate_List_Header_Limits
9: (x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: ,p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

Line 828: --dbms_output.put_line('Inside QP_Validate_Limits.Attributes ' || x_return_status);

824: BEGIN
825:
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: --dbms_output.put_line('Inside QP_Validate_Limits.Attributes ' || x_return_status);
829: -- Validate LIMITS attributes
830: IF p_LIMITS_rec.amount IS NOT NULL AND
831: ( p_LIMITS_rec.amount <>
832: p_old_LIMITS_rec.amount OR

Line 835: IF NOT QP_Validate.Amount(p_LIMITS_rec.amount) THEN

831: ( p_LIMITS_rec.amount <>
832: p_old_LIMITS_rec.amount OR
833: p_old_LIMITS_rec.amount IS NULL )
834: THEN
835: IF NOT QP_Validate.Amount(p_LIMITS_rec.amount) THEN
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: END IF;
838: --dbms_output.put_line('Inside QP_Validate.Amount ' || x_return_status);
839: END IF;

Line 838: --dbms_output.put_line('Inside QP_Validate.Amount ' || x_return_status);

834: THEN
835: IF NOT QP_Validate.Amount(p_LIMITS_rec.amount) THEN
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: END IF;
838: --dbms_output.put_line('Inside QP_Validate.Amount ' || x_return_status);
839: END IF;
840:
841: IF p_LIMITS_rec.basis IS NOT NULL AND
842: ( p_LIMITS_rec.basis <>

Line 846: IF NOT QP_Validate.Basis(p_LIMITS_rec.basis) THEN

842: ( p_LIMITS_rec.basis <>
843: p_old_LIMITS_rec.basis OR
844: p_old_LIMITS_rec.basis IS NULL )
845: THEN
846: IF NOT QP_Validate.Basis(p_LIMITS_rec.basis) THEN
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849: --dbms_output.put_line('Inside QP_Validate.Basis ' || x_return_status);
850: END IF;

Line 849: --dbms_output.put_line('Inside QP_Validate.Basis ' || x_return_status);

845: THEN
846: IF NOT QP_Validate.Basis(p_LIMITS_rec.basis) THEN
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849: --dbms_output.put_line('Inside QP_Validate.Basis ' || x_return_status);
850: END IF;
851:
852: IF p_LIMITS_rec.created_by IS NOT NULL AND
853: ( p_LIMITS_rec.created_by <>

Line 857: IF NOT QP_Validate.Created_By(p_LIMITS_rec.created_by) THEN

853: ( p_LIMITS_rec.created_by <>
854: p_old_LIMITS_rec.created_by OR
855: p_old_LIMITS_rec.created_by IS NULL )
856: THEN
857: IF NOT QP_Validate.Created_By(p_LIMITS_rec.created_by) THEN
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: END IF;
860: --dbms_output.put_line('Inside QP_Validate.created_by ' || x_return_status);
861: END IF;

Line 860: --dbms_output.put_line('Inside QP_Validate.created_by ' || x_return_status);

856: THEN
857: IF NOT QP_Validate.Created_By(p_LIMITS_rec.created_by) THEN
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: END IF;
860: --dbms_output.put_line('Inside QP_Validate.created_by ' || x_return_status);
861: END IF;
862:
863: IF p_LIMITS_rec.creation_date IS NOT NULL AND
864: ( p_LIMITS_rec.creation_date <>

Line 868: IF NOT QP_Validate.Creation_Date(p_LIMITS_rec.creation_date) THEN

864: ( p_LIMITS_rec.creation_date <>
865: p_old_LIMITS_rec.creation_date OR
866: p_old_LIMITS_rec.creation_date IS NULL )
867: THEN
868: IF NOT QP_Validate.Creation_Date(p_LIMITS_rec.creation_date) THEN
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: END IF;
871: --dbms_output.put_line('Inside QP_Validate.Creation_Date ' || x_return_status);
872: END IF;

Line 871: --dbms_output.put_line('Inside QP_Validate.Creation_Date ' || x_return_status);

867: THEN
868: IF NOT QP_Validate.Creation_Date(p_LIMITS_rec.creation_date) THEN
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: END IF;
871: --dbms_output.put_line('Inside QP_Validate.Creation_Date ' || x_return_status);
872: END IF;
873:
874: IF p_LIMITS_rec.last_updated_by IS NOT NULL AND
875: ( p_LIMITS_rec.last_updated_by <>

Line 879: IF NOT QP_Validate.Last_Updated_By(p_LIMITS_rec.last_updated_by) THEN

875: ( p_LIMITS_rec.last_updated_by <>
876: p_old_LIMITS_rec.last_updated_by OR
877: p_old_LIMITS_rec.last_updated_by IS NULL )
878: THEN
879: IF NOT QP_Validate.Last_Updated_By(p_LIMITS_rec.last_updated_by) THEN
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: END IF;
882: --dbms_output.put_line('Inside QP_Validate.Last_Updated_By ' || x_return_status);
883: END IF;

Line 882: --dbms_output.put_line('Inside QP_Validate.Last_Updated_By ' || x_return_status);

878: THEN
879: IF NOT QP_Validate.Last_Updated_By(p_LIMITS_rec.last_updated_by) THEN
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: END IF;
882: --dbms_output.put_line('Inside QP_Validate.Last_Updated_By ' || x_return_status);
883: END IF;
884:
885: IF p_LIMITS_rec.last_update_date IS NOT NULL AND
886: ( p_LIMITS_rec.last_update_date <>

Line 890: IF NOT QP_Validate.Last_Update_Date(p_LIMITS_rec.last_update_date) THEN

886: ( p_LIMITS_rec.last_update_date <>
887: p_old_LIMITS_rec.last_update_date OR
888: p_old_LIMITS_rec.last_update_date IS NULL )
889: THEN
890: IF NOT QP_Validate.Last_Update_Date(p_LIMITS_rec.last_update_date) THEN
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: END IF;
893: --dbms_output.put_line('Inside QP_Validate.Last_Update_Date ' || x_return_status);
894: END IF;

Line 893: --dbms_output.put_line('Inside QP_Validate.Last_Update_Date ' || x_return_status);

889: THEN
890: IF NOT QP_Validate.Last_Update_Date(p_LIMITS_rec.last_update_date) THEN
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: END IF;
893: --dbms_output.put_line('Inside QP_Validate.Last_Update_Date ' || x_return_status);
894: END IF;
895:
896: IF p_LIMITS_rec.last_update_login IS NOT NULL AND
897: ( p_LIMITS_rec.last_update_login <>

Line 901: IF NOT QP_Validate.Last_Update_Login(p_LIMITS_rec.last_update_login) THEN

897: ( p_LIMITS_rec.last_update_login <>
898: p_old_LIMITS_rec.last_update_login OR
899: p_old_LIMITS_rec.last_update_login IS NULL )
900: THEN
901: IF NOT QP_Validate.Last_Update_Login(p_LIMITS_rec.last_update_login) THEN
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904: --dbms_output.put_line('Inside QP_Validate.last_update_login ' || x_return_status);
905: END IF;

Line 904: --dbms_output.put_line('Inside QP_Validate.last_update_login ' || x_return_status);

900: THEN
901: IF NOT QP_Validate.Last_Update_Login(p_LIMITS_rec.last_update_login) THEN
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904: --dbms_output.put_line('Inside QP_Validate.last_update_login ' || x_return_status);
905: END IF;
906:
907: IF p_LIMITS_rec.limit_exceed_action_code IS NOT NULL AND
908: ( p_LIMITS_rec.limit_exceed_action_code <>

Line 912: IF NOT QP_Validate.Limit_Exceed_Action(p_LIMITS_rec.limit_exceed_action_code) THEN

908: ( p_LIMITS_rec.limit_exceed_action_code <>
909: p_old_LIMITS_rec.limit_exceed_action_code OR
910: p_old_LIMITS_rec.limit_exceed_action_code IS NULL )
911: THEN
912: IF NOT QP_Validate.Limit_Exceed_Action(p_LIMITS_rec.limit_exceed_action_code) THEN
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;
915: --dbms_output.put_line('Inside QP_Validate.Limit_Exceed_Action ' || x_return_status);
916: END IF;

Line 915: --dbms_output.put_line('Inside QP_Validate.Limit_Exceed_Action ' || x_return_status);

911: THEN
912: IF NOT QP_Validate.Limit_Exceed_Action(p_LIMITS_rec.limit_exceed_action_code) THEN
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;
915: --dbms_output.put_line('Inside QP_Validate.Limit_Exceed_Action ' || x_return_status);
916: END IF;
917:
918: IF p_LIMITS_rec.limit_hold_flag IS NOT NULL AND
919: ( p_LIMITS_rec.limit_hold_flag <>

Line 923: IF NOT QP_Validate.LIMIT_HOLD(p_LIMITS_rec.limit_hold_flag) THEN

919: ( p_LIMITS_rec.limit_hold_flag <>
920: p_old_LIMITS_rec.limit_hold_flag OR
921: p_old_LIMITS_rec.limit_hold_flag IS NULL )
922: THEN
923: IF NOT QP_Validate.LIMIT_HOLD(p_LIMITS_rec.limit_hold_flag) THEN
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: END IF;
926: --dbms_output.put_line('Inside QP_Validate.LIMIT_HOLD ' || x_return_status);
927: END IF;

Line 926: --dbms_output.put_line('Inside QP_Validate.LIMIT_HOLD ' || x_return_status);

922: THEN
923: IF NOT QP_Validate.LIMIT_HOLD(p_LIMITS_rec.limit_hold_flag) THEN
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: END IF;
926: --dbms_output.put_line('Inside QP_Validate.LIMIT_HOLD ' || x_return_status);
927: END IF;
928:
929: IF p_LIMITS_rec.limit_id IS NOT NULL AND
930: ( p_LIMITS_rec.limit_id <>

Line 934: IF NOT QP_Validate.Limit(p_LIMITS_rec.limit_id) THEN

930: ( p_LIMITS_rec.limit_id <>
931: p_old_LIMITS_rec.limit_id OR
932: p_old_LIMITS_rec.limit_id IS NULL )
933: THEN
934: IF NOT QP_Validate.Limit(p_LIMITS_rec.limit_id) THEN
935: x_return_status := FND_API.G_RET_STS_ERROR;
936: END IF;
937: --dbms_output.put_line('Inside QP_Validate.limit_id ' || x_return_status);
938: END IF;

Line 937: --dbms_output.put_line('Inside QP_Validate.limit_id ' || x_return_status);

933: THEN
934: IF NOT QP_Validate.Limit(p_LIMITS_rec.limit_id) THEN
935: x_return_status := FND_API.G_RET_STS_ERROR;
936: END IF;
937: --dbms_output.put_line('Inside QP_Validate.limit_id ' || x_return_status);
938: END IF;
939:
940: IF p_LIMITS_rec.limit_level_code IS NOT NULL AND
941: ( p_LIMITS_rec.limit_level_code <>

Line 945: IF NOT QP_Validate.Limit_Level(p_LIMITS_rec.limit_level_code) THEN

941: ( p_LIMITS_rec.limit_level_code <>
942: p_old_LIMITS_rec.limit_level_code OR
943: p_old_LIMITS_rec.limit_level_code IS NULL )
944: THEN
945: IF NOT QP_Validate.Limit_Level(p_LIMITS_rec.limit_level_code) THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: END IF;
948: --dbms_output.put_line('Inside QP_Validate.Limit_Level ' || x_return_status);
949: END IF;

Line 948: --dbms_output.put_line('Inside QP_Validate.Limit_Level ' || x_return_status);

944: THEN
945: IF NOT QP_Validate.Limit_Level(p_LIMITS_rec.limit_level_code) THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: END IF;
948: --dbms_output.put_line('Inside QP_Validate.Limit_Level ' || x_return_status);
949: END IF;
950:
951: IF p_LIMITS_rec.limit_number IS NOT NULL AND
952: ( p_LIMITS_rec.limit_number <>

Line 956: IF NOT QP_Validate.Limit_Number(p_LIMITS_rec.limit_number) THEN

952: ( p_LIMITS_rec.limit_number <>
953: p_old_LIMITS_rec.limit_number OR
954: p_old_LIMITS_rec.limit_number IS NULL )
955: THEN
956: IF NOT QP_Validate.Limit_Number(p_LIMITS_rec.limit_number) THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959: --dbms_output.put_line('Inside QP_Validate.Limit_Number ' || x_return_status);
960: END IF;

Line 959: --dbms_output.put_line('Inside QP_Validate.Limit_Number ' || x_return_status);

955: THEN
956: IF NOT QP_Validate.Limit_Number(p_LIMITS_rec.limit_number) THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959: --dbms_output.put_line('Inside QP_Validate.Limit_Number ' || x_return_status);
960: END IF;
961:
962: IF p_LIMITS_rec.list_header_id IS NOT NULL AND
963: ( p_LIMITS_rec.list_header_id <>

Line 967: IF NOT QP_Validate.List_Header(p_LIMITS_rec.list_header_id) THEN

963: ( p_LIMITS_rec.list_header_id <>
964: p_old_LIMITS_rec.list_header_id OR
965: p_old_LIMITS_rec.list_header_id IS NULL )
966: THEN
967: IF NOT QP_Validate.List_Header(p_LIMITS_rec.list_header_id) THEN
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: END IF;
970: --dbms_output.put_line('Inside QP_Validate.List_Header ' || x_return_status);
971: END IF;

Line 970: --dbms_output.put_line('Inside QP_Validate.List_Header ' || x_return_status);

966: THEN
967: IF NOT QP_Validate.List_Header(p_LIMITS_rec.list_header_id) THEN
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: END IF;
970: --dbms_output.put_line('Inside QP_Validate.List_Header ' || x_return_status);
971: END IF;
972:
973: IF p_LIMITS_rec.list_line_id IS NOT NULL AND
974: ( p_LIMITS_rec.list_line_id <>

Line 978: IF NOT QP_Validate.List_Line(p_LIMITS_rec.list_line_id) THEN

974: ( p_LIMITS_rec.list_line_id <>
975: p_old_LIMITS_rec.list_line_id OR
976: p_old_LIMITS_rec.list_line_id IS NULL )
977: THEN
978: IF NOT QP_Validate.List_Line(p_LIMITS_rec.list_line_id) THEN
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: END IF;
981: --dbms_output.put_line('Inside QP_Validate.List_Line ' || x_return_status);
982: END IF;

Line 981: --dbms_output.put_line('Inside QP_Validate.List_Line ' || x_return_status);

977: THEN
978: IF NOT QP_Validate.List_Line(p_LIMITS_rec.list_line_id) THEN
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: END IF;
981: --dbms_output.put_line('Inside QP_Validate.List_Line ' || x_return_status);
982: END IF;
983:
984: IF p_LIMITS_rec.multival_attr1_type IS NOT NULL AND
985: ( p_LIMITS_rec.multival_attr1_type <>

Line 989: IF NOT QP_Validate.Multival_Attr1_Type(p_LIMITS_rec.multival_attr1_type) THEN

985: ( p_LIMITS_rec.multival_attr1_type <>
986: p_old_LIMITS_rec.multival_attr1_type OR
987: p_old_LIMITS_rec.multival_attr1_type IS NULL )
988: THEN
989: IF NOT QP_Validate.Multival_Attr1_Type(p_LIMITS_rec.multival_attr1_type) THEN
990: x_return_status := FND_API.G_RET_STS_ERROR;
991: END IF;
992: END IF;
993:

Line 999: IF NOT QP_Validate.Multival_Attr1_Context(p_LIMITS_rec.multival_attr1_context) THEN

995: ( p_LIMITS_rec.multival_attr1_context <>
996: p_old_LIMITS_rec.multival_attr1_context OR
997: p_old_LIMITS_rec.multival_attr1_context IS NULL )
998: THEN
999: IF NOT QP_Validate.Multival_Attr1_Context(p_LIMITS_rec.multival_attr1_context) THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: END IF;
1002: END IF;
1003:

Line 1009: IF NOT QP_Validate.Multival_Attribute2(p_LIMITS_rec.multival_attribute2) THEN

1005: ( p_LIMITS_rec.multival_attribute2 <>
1006: p_old_LIMITS_rec.multival_attribute2 OR
1007: p_old_LIMITS_rec.multival_attribute2 IS NULL )
1008: THEN
1009: IF NOT QP_Validate.Multival_Attribute2(p_LIMITS_rec.multival_attribute2) THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: END IF;
1012: END IF;
1013:

Line 1019: IF NOT QP_Validate.Multival_Attr1_Datatype(p_LIMITS_rec.multival_attr1_datatype) THEN

1015: ( p_LIMITS_rec.multival_attr1_datatype <>
1016: p_old_LIMITS_rec.multival_attr1_datatype OR
1017: p_old_LIMITS_rec.multival_attr1_datatype IS NULL )
1018: THEN
1019: IF NOT QP_Validate.Multival_Attr1_Datatype(p_LIMITS_rec.multival_attr1_datatype) THEN
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021: END IF;
1022: END IF;
1023:

Line 1029: IF NOT QP_Validate.Multival_Attr2_Type(p_LIMITS_rec.multival_attr2_type) THEN

1025: ( p_LIMITS_rec.multival_attr2_type <>
1026: p_old_LIMITS_rec.multival_attr2_type OR
1027: p_old_LIMITS_rec.multival_attr2_type IS NULL )
1028: THEN
1029: IF NOT QP_Validate.Multival_Attr2_Type(p_LIMITS_rec.multival_attr2_type) THEN
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: END IF;
1032: END IF;
1033:

Line 1039: IF NOT QP_Validate.Multival_Attr2_Context(p_LIMITS_rec.multival_attr2_context) THEN

1035: ( p_LIMITS_rec.multival_attr2_context <>
1036: p_old_LIMITS_rec.multival_attr2_context OR
1037: p_old_LIMITS_rec.multival_attr2_context IS NULL )
1038: THEN
1039: IF NOT QP_Validate.Multival_Attr2_Context(p_LIMITS_rec.multival_attr2_context) THEN
1040: x_return_status := FND_API.G_RET_STS_ERROR;
1041: END IF;
1042: END IF;
1043:

Line 1049: IF NOT QP_Validate.Multival_Attribute2(p_LIMITS_rec.multival_attribute2) THEN

1045: ( p_LIMITS_rec.multival_attribute2 <>
1046: p_old_LIMITS_rec.multival_attribute2 OR
1047: p_old_LIMITS_rec.multival_attribute2 IS NULL )
1048: THEN
1049: IF NOT QP_Validate.Multival_Attribute2(p_LIMITS_rec.multival_attribute2) THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: END IF;
1052: END IF;
1053:

Line 1059: IF NOT QP_Validate.Multival_Attr2_Datatype(p_LIMITS_rec.multival_attr2_datatype) THEN

1055: ( p_LIMITS_rec.multival_attr2_datatype <>
1056: p_old_LIMITS_rec.multival_attr2_datatype OR
1057: p_old_LIMITS_rec.multival_attr2_datatype IS NULL )
1058: THEN
1059: IF NOT QP_Validate.Multival_Attr2_Datatype(p_LIMITS_rec.multival_attr2_datatype) THEN
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: END IF;
1062: END IF;
1063:

Line 1069: IF NOT QP_Validate.Organization(p_LIMITS_rec.organization_flag) THEN

1065: ( p_LIMITS_rec.organization_flag <>
1066: p_old_LIMITS_rec.organization_flag OR
1067: p_old_LIMITS_rec.organization_flag IS NULL )
1068: THEN
1069: IF NOT QP_Validate.Organization(p_LIMITS_rec.organization_flag) THEN
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: END IF;
1072: --dbms_output.put_line('Inside QP_Validate.Organization ' || x_return_status);
1073: END IF;

Line 1072: --dbms_output.put_line('Inside QP_Validate.Organization ' || x_return_status);

1068: THEN
1069: IF NOT QP_Validate.Organization(p_LIMITS_rec.organization_flag) THEN
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: END IF;
1072: --dbms_output.put_line('Inside QP_Validate.Organization ' || x_return_status);
1073: END IF;
1074:
1075:
1076: IF p_LIMITS_rec.program_application_id IS NOT NULL AND

Line 1081: IF NOT QP_Validate.Program_Application(p_LIMITS_rec.program_application_id) THEN

1077: ( p_LIMITS_rec.program_application_id <>
1078: p_old_LIMITS_rec.program_application_id OR
1079: p_old_LIMITS_rec.program_application_id IS NULL )
1080: THEN
1081: IF NOT QP_Validate.Program_Application(p_LIMITS_rec.program_application_id) THEN
1082: x_return_status := FND_API.G_RET_STS_ERROR;
1083: END IF;
1084: END IF;
1085:

Line 1091: IF NOT QP_Validate.Program(p_LIMITS_rec.program_id) THEN

1087: ( p_LIMITS_rec.program_id <>
1088: p_old_LIMITS_rec.program_id OR
1089: p_old_LIMITS_rec.program_id IS NULL )
1090: THEN
1091: IF NOT QP_Validate.Program(p_LIMITS_rec.program_id) THEN
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: END IF;
1094: END IF;
1095:

Line 1101: IF NOT QP_Validate.Program_Update_Date(p_LIMITS_rec.program_update_date) THEN

1097: ( p_LIMITS_rec.program_update_date <>
1098: p_old_LIMITS_rec.program_update_date OR
1099: p_old_LIMITS_rec.program_update_date IS NULL )
1100: THEN
1101: IF NOT QP_Validate.Program_Update_Date(p_LIMITS_rec.program_update_date) THEN
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: END IF;
1104: END IF;
1105:

Line 1111: IF NOT QP_Validate.Request(p_LIMITS_rec.request_id) THEN

1107: ( p_LIMITS_rec.request_id <>
1108: p_old_LIMITS_rec.request_id OR
1109: p_old_LIMITS_rec.request_id IS NULL )
1110: THEN
1111: IF NOT QP_Validate.Request(p_LIMITS_rec.request_id) THEN
1112: x_return_status := FND_API.G_RET_STS_ERROR;
1113: --dbms_output.put_line('Inside QP_Validate.request_id ' || x_return_status);
1114: END IF;
1115: END IF;

Line 1113: --dbms_output.put_line('Inside QP_Validate.request_id ' || x_return_status);

1109: p_old_LIMITS_rec.request_id IS NULL )
1110: THEN
1111: IF NOT QP_Validate.Request(p_LIMITS_rec.request_id) THEN
1112: x_return_status := FND_API.G_RET_STS_ERROR;
1113: --dbms_output.put_line('Inside QP_Validate.request_id ' || x_return_status);
1114: END IF;
1115: END IF;
1116:
1117: IF (p_LIMITS_rec.attribute1 IS NOT NULL AND

Line 1254: IF NOT QP_Validate.Desc_Flex( 'LIMITS' ) THEN

1250: */
1251:
1252: -- Validate descriptive flexfield.
1253:
1254: IF NOT QP_Validate.Desc_Flex( 'LIMITS' ) THEN
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: END IF;
1257:
1258: END IF;

Line 1518: END QP_Validate_Limits;

1514: END IF;
1515:
1516: END Entity_Update;
1517:
1518: END QP_Validate_Limits;