You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
INSERT INTOCROWN.VALIDATION_ERROR_MESSAGE (ERROR_CODE,NAME,LABEL,ACTIVE,SORT_ORDER,CATEGORY,SUB_CATEGORY,IS_WARNING,CREATE_TIME,UPDATE_TIME) values (12519,'CW 4.0','Pre-Dialysis Weight must be greater than zero (0).',1,707,2,1,0,to_date('14-MAY-12','DD-MON-RR'),to_date('14-MAY-12','DD-MON-RR'));
ELSE
UPDATECROWN.VALIDATION_ERROR_MESSAGE
SET ERROR_CODE =12519,
NAME ='CW 4.0',
LABEL ='Pre-Dialysis Weight must be greater than zero (0).',
ACTIVE =1,
SORT_ORDER =707,
CATEGORY =2,
SUB_CATEGORY =1,
IS_WARNING =0,
CREATE_TIME = to_date('14-MAY-12','DD-MON-RR'),
UPDATE_TIME = to_date('14-MAY-12','DD-MON-RR')
WHERE ERROR_CODE =12519;
END IF;
-- reset the counter
CNT_V :=0;
SELECTCOUNT(*)
INTO CNT_V
FROMCROWN.VALIDATION_ERROR_MESSAGE
WHERE ERROR_CODE =12629;
IF CNT_V =0 THEN
INSERT INTOCROWN.VALIDATION_ERROR_MESSAGE (ERROR_CODE,NAME,LABEL,ACTIVE,SORT_ORDER,CATEGORY,SUB_CATEGORY,IS_WARNING,CREATE_TIME,UPDATE_TIME) values (12629,'CW 4.0','Serum BUN is mandatory when Clinic Weight, Creatinine Clearance, Dialysate Volume, Dialysate Urea Nitrogen, Dialysate Creatinine, Urine Volume, or Serum Creatinine is populated.',1,758,2,1,0,to_date('14-MAY-12','DD-MON-RR'),to_date('14-MAY-12','DD-MON-RR'));
ELSE
UPDATECROWN.VALIDATION_ERROR_MESSAGE
SET ERROR_CODE =12629,
NAME ='CW 4.0',
LABEL ='Serum BUN is mandatory when Clinic Weight, Creatinine Clearance, Dialysate Volume, Dialysate Urea Nitrogen, Dialysate Creatinine, Urine Volume, or Serum Creatinine is populated.',
ACTIVE =1,
SORT_ORDER =758,
CATEGORY =2,
SUB_CATEGORY =1,
IS_WARNING =0,
CREATE_TIME = to_date('14-MAY-12','DD-MON-RR'),
UPDATE_TIME = to_date('14-MAY-12','DD-MON-RR')
WHERE ERROR_CODE =12629;
END IF;
-- reset the counter
CNT_V :=0;
SELECTCOUNT(*)
INTO CNT_V
FROMCROWN.VALIDATION_ERROR_MESSAGE
WHERE ERROR_CODE =13079;
IF CNT_V =0 THEN
INSERT INTOCROWN.VALIDATION_ERROR_MESSAGE (ERROR_CODE,NAME,LABEL,ACTIVE,SORT_ORDER,CATEGORY,SUB_CATEGORY,IS_WARNING,CREATE_TIME,UPDATE_TIME) values (13079,'CW 4.0','When Hepatitis C Screen Test field is ''''Other'''', then Other Hepatitis C Screen Test field must have a value.',1,1069,2,1,0,to_date('14-MAY-12','DD-MON-RR'),to_date('14-MAY-12','DD-MON-RR'));
ELSE
UPDATECROWN.VALIDATION_ERROR_MESSAGE
SET ERROR_CODE =13079,
NAME ='CW 4.0',
LABEL ='When Hepatitis C Screen Test field is ''''Other'''', then Other Hepatitis C Screen Test field must have a value.',
ACTIVE =1,
SORT_ORDER =1069,
CATEGORY =2,
SUB_CATEGORY =1,
IS_WARNING =0,
CREATE_TIME = to_date('14-MAY-12','DD-MON-RR'),
UPDATE_TIME = to_date('14-MAY-12','DD-MON-RR')
WHERE ERROR_CODE =13079;
END IF;
-- reset the counter
CNT_V :=0;
SELECTCOUNT(*)
INTO CNT_V
FROMCROWN.VALIDATION_ERROR_MESSAGE
WHERE ERROR_CODE =12629;
IF CNT_V =0 THEN
INSERT INTOCROWN.VALIDATION_ERROR_MESSAGE (ERROR_CODE,NAME,LABEL,ACTIVE,SORT_ORDER,CATEGORY,SUB_CATEGORY,IS_WARNING,CREATE_TIME,UPDATE_TIME) values (12629,'CW 4.0','Serum BUN is mandatory when Clinic Weight, Creatinine Clearance, Dialysate Volume, Dialysate Urea Nitrogen, Dialysate Creatinine, Urine Volume, or
Serum Creatinine is populated.',1,758,2,1,0,to_date('09-APR-12','DD-MON-RR'),to_date('09-APR-12','DD-MON-RR'));
ELSE
UPDATECROWN.VALIDATION_ERROR_MESSAGE
SET ERROR_CODE =12629,
NAME ='CW 4.0',
LABEL ='Serum BUN is mandatory when Clinic Weight, Creatinine Clearance, Dialysate Volume, Dialysate Urea Nitrogen, Dialysate Creatinine, Urine Volume, or