150: l_pan VARCHAR2(30);
151: --
152: BEGIN
153: l_proc := g_package||'update_in_person';
154: g_trace := hr_utility.debug_enabled ;
155:
156: if g_trace then
157: hr_utility.set_location('Entering: '||l_proc, 10);
158: end if ;
153: l_proc := g_package||'update_in_person';
154: g_trace := hr_utility.debug_enabled ;
155:
156: if g_trace then
157: hr_utility.set_location('Entering: '||l_proc, 10);
158: end if ;
159:
160: open check_legislation(p_person_id, p_effective_date);
161: fetch check_legislation into l_legislation_code;
161: fetch check_legislation into l_legislation_code;
162:
163: if check_legislation%notfound then
164: close check_legislation;
165: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
166: hr_utility.raise_error;
167: end if;
168:
169: close check_legislation;
162:
163: if check_legislation%notfound then
164: close check_legislation;
165: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
166: hr_utility.raise_error;
167: end if;
168:
169: close check_legislation;
170:
168:
169: close check_legislation;
170:
171: if hr_general2.IS_BG(l_legislation_code ,'IN') = false then
172: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
173: hr_utility.raise_error;
174: end if;
175:
176: if g_trace then
169: close check_legislation;
170:
171: if hr_general2.IS_BG(l_legislation_code ,'IN') = false then
172: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
173: hr_utility.raise_error;
174: end if;
175:
176: if g_trace then
177: hr_utility.set_location(l_proc, 20);
173: hr_utility.raise_error;
174: end if;
175:
176: if g_trace then
177: hr_utility.set_location(l_proc, 20);
178: end if ;
179:
180:
181: -- Bugfix 3762728 Start
320: ,p_orig_hire_warning => p_orig_hire_warning
321: );
322:
323: IF g_trace THEN
324: hr_utility.set_location('Leaving: '||l_proc, 30);
325: END IF ;
326:
327: END update_in_person ;
328: END hr_in_person_api ;