115: where pbg.business_group_id = p_business_group_id;
116: --
117: --
118: begin
119: hr_utility.set_location('Entering:'|| l_proc, 5);
120: --
121: -- Validation in addition to Row Handlers
122: --
123: -- Check that the specified business group is valid.
126: fetch csr_bg
127: into l_legislation_code;
128: if csr_bg%notfound then
129: close csr_bg;
130: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
131: hr_utility.raise_error;
132: end if;
133: close csr_bg;
134: --
127: into l_legislation_code;
128: if csr_bg%notfound then
129: close csr_bg;
130: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
131: hr_utility.raise_error;
132: end if;
133: close csr_bg;
134: --
135: -- Check that the legislation of the specified business group is 'FR'.
134: --
135: -- Check that the legislation of the specified business group is 'FR'.
136: --
137: if l_legislation_code <> 'FR' then
138: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:
135: -- Check that the legislation of the specified business group is 'FR'.
136: --
137: if l_legislation_code <> 'FR' then
138: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 6);
136: --
137: if l_legislation_code <> 'FR' then
138: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 6);
144: /* Provisional/Definitive number not required
139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 6);
144: /* Provisional/Definitive number not required
145: --
146: -- Check that Provisonal Number is Unique or Not.
147: --
148: open provisonal_cur(p_provisional_no);
149: fetch provisonal_cur into l_var;
150: if provisonal_cur%found then
151: close provisonal_cur;
152: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
153: hr_utility.set_message_token('NAME','Provisional Number');
154: hr_utility.raise_error;
155: end if;
156: close provisonal_cur;
149: fetch provisonal_cur into l_var;
150: if provisonal_cur%found then
151: close provisonal_cur;
152: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
153: hr_utility.set_message_token('NAME','Provisional Number');
154: hr_utility.raise_error;
155: end if;
156: close provisonal_cur;
157: --
150: if provisonal_cur%found then
151: close provisonal_cur;
152: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
153: hr_utility.set_message_token('NAME','Provisional Number');
154: hr_utility.raise_error;
155: end if;
156: close provisonal_cur;
157: --
158: -- Check that Definitive Number is Unique or Not
160: open Definative_cur(p_definitive_no);
161: fetch Definative_cur into l_var;
162: if Definative_cur%found then
163: close Definative_cur;
164: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
165: hr_utility.set_message_token('NAME','Definitive Number');
166: hr_utility.raise_error;
167: end if;
168: close Definative_cur;
161: fetch Definative_cur into l_var;
162: if Definative_cur%found then
163: close Definative_cur;
164: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
165: hr_utility.set_message_token('NAME','Definitive Number');
166: hr_utility.raise_error;
167: end if;
168: close Definative_cur;
169: */
162: if Definative_cur%found then
163: close Definative_cur;
164: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
165: hr_utility.set_message_token('NAME','Definitive Number');
166: hr_utility.raise_error;
167: end if;
168: close Definative_cur;
169: */
170: --
271: ,p_name_combination_warning => p_name_combination_warning
272: ,p_assign_payroll_warning => p_assign_payroll_warning
273: );
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 7);
276: exception when others then
277: p_person_id := null;
278: p_assignment_id := null;
279: p_per_object_version_number := null;