278: -- Bug fix 1873685
279: if (p_cmbnd_max_val < p_cmbnd_min_val) then
280: -- if (p_cmbnd_max_val <= p_cmbnd_min_val) then
281: -- End fix 1873685
282: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
283: fnd_message.raise_error;
284: end if;
285: --
286: --
279: if (p_cmbnd_max_val < p_cmbnd_min_val) then
280: -- if (p_cmbnd_max_val <= p_cmbnd_min_val) then
281: -- End fix 1873685
282: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
283: fnd_message.raise_error;
284: end if;
285: --
286: --
287: end if;
363: close c1;
364: --
365: -- raise error
366: --
367: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
368: fnd_message.raise_error;
369: --
370: end if;
371: --
364: --
365: -- raise error
366: --
367: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
368: fnd_message.raise_error;
369: --
370: end if;
371: --
372: close c1;
586: close csr_leg_code;
587: --
588: -- The primary key is invalid therefore we must error
589: --
590: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
591: fnd_message.raise_error;
592: --
593: end if;
594: --
587: --
588: -- The primary key is invalid therefore we must error
589: --
590: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
591: fnd_message.raise_error;
592: --
593: end if;
594: --
595: close csr_leg_code;