29: open csr_bp;
30: fetch csr_bp into l_exists;
31: if csr_bp%NOTFOUND then
32: close csr_bp;
33: fnd_message.set_name('PER', 'PER_52818_INVALID_ESTAB');
34: fnd_message.raise_error;
35: end if;
36: close csr_bp;
37: else
30: fetch csr_bp into l_exists;
31: if csr_bp%NOTFOUND then
32: close csr_bp;
33: fnd_message.set_name('PER', 'PER_52818_INVALID_ESTAB');
34: fnd_message.raise_error;
35: end if;
36: close csr_bp;
37: else
38: --
40: -- This validation is done only for Payroll Assignment.
41: -- Applicant and Benefit Assignment are not eligible for this validation.
42: --
43: if p_assignment_type = 'E' and p_payroll_id is not null then
44: fnd_message.set_name('PAY', 'HR_INV_LEG_ENT_KR');
45: fnd_message.raise_error;
46: end if;
47: end if;
48: end chk_establishment_id;
41: -- Applicant and Benefit Assignment are not eligible for this validation.
42: --
43: if p_assignment_type = 'E' and p_payroll_id is not null then
44: fnd_message.set_name('PAY', 'HR_INV_LEG_ENT_KR');
45: fnd_message.raise_error;
46: end if;
47: end if;
48: end chk_establishment_id;
49: --
75: -- This validation is done only for Payroll Assignment.
76: -- Applicant and Benefit Assignment are not eligible for this validation.
77: --
78: if p_assignment_type = 'E' and p_payroll_id is not null and p_establishment_id is null then
79: fnd_message.set_name('PAY', 'HR_INV_LEG_ENT_KR');
80: fnd_message.raise_error;
81: end if;
82: end if;
83: end chk_establishment_id_upd;
76: -- Applicant and Benefit Assignment are not eligible for this validation.
77: --
78: if p_assignment_type = 'E' and p_payroll_id is not null and p_establishment_id is null then
79: fnd_message.set_name('PAY', 'HR_INV_LEG_ENT_KR');
80: fnd_message.raise_error;
81: end if;
82: end if;
83: end chk_establishment_id_upd;
84: --