132: FROM per_business_groups pbg
133: WHERE pbg.business_group_id = p_business_group_id;
134: --
135: begin
136: hr_utility.set_location('Entering:'|| l_proc, 45);
137: --
138: -- Validation IN addition to Table Handlers
139: --
140: -- Check that the specified business group IS valid.
143: FETCH csr_bg
144: INTO l_legislation_code;
145: IF csr_bg%notfound then
146: close csr_bg;
147: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
148: hr_utility.raise_error;
149: END IF;
150: close csr_bg;
151: --
144: INTO l_legislation_code;
145: IF csr_bg%notfound then
146: close csr_bg;
147: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
148: hr_utility.raise_error;
149: END IF;
150: close csr_bg;
151: --
152: -- Check that the legislation of the specified business group IS 'FI'.
151: --
152: -- Check that the legislation of the specified business group IS 'FI'.
153: --
154: IF l_legislation_code <> 'FI' then
155: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
156: hr_utility.set_message_token('LEG_CODE','FI');
157: hr_utility.raise_error;
158: END IF;
159:
152: -- Check that the legislation of the specified business group IS 'FI'.
153: --
154: IF l_legislation_code <> 'FI' then
155: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
156: hr_utility.set_message_token('LEG_CODE','FI');
157: hr_utility.raise_error;
158: END IF;
159:
160:
153: --
154: IF l_legislation_code <> 'FI' then
155: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
156: hr_utility.set_message_token('LEG_CODE','FI');
157: hr_utility.raise_error;
158: END IF;
159:
160:
161: if p_membership_start_date is not null and p_membership_end_date is not null and
159:
160:
161: if p_membership_start_date is not null and p_membership_end_date is not null and
162: p_membership_start_date > p_membership_end_date then
163: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
164: hr_utility.set_message_token('LEG_CODE','FI');
165: hr_utility.raise_error;
166: end if;
167:
160:
161: if p_membership_start_date is not null and p_membership_end_date is not null and
162: p_membership_start_date > p_membership_end_date then
163: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
164: hr_utility.set_message_token('LEG_CODE','FI');
165: hr_utility.raise_error;
166: end if;
167:
168: hr_utility.set_location(l_proc, 50);
161: if p_membership_start_date is not null and p_membership_end_date is not null and
162: p_membership_start_date > p_membership_end_date then
163: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
164: hr_utility.set_message_token('LEG_CODE','FI');
165: hr_utility.raise_error;
166: end if;
167:
168: hr_utility.set_location(l_proc, 50);
169: --
164: hr_utility.set_message_token('LEG_CODE','FI');
165: hr_utility.raise_error;
166: end if;
167:
168: hr_utility.set_location(l_proc, 50);
169: --
170: -- Call the person business process
171: --
172: hr_applicant_api.create_applicant
281: ,p_name_combination_warning => p_name_combination_warning
282: ,p_orig_hire_warning => p_orig_hire_warning
283: );
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 55);
286: null;
287: end create_fi_applicant ;
288:
289: END HR_FI_APPLICANT_API;