47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error
52: (p_api_name => l_proc
53: ,p_argument => 'solution_id'
54: ,p_argument_value => p_solution_id
55: );
73: close csr_sec_grp;
74: --
75: -- Set the security_group_id in CLIENT_INFO
76: --
77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: end if;
81: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error
122: (p_api_name => l_proc
123: ,p_argument => 'solution_id'
124: ,p_argument_value => p_solution_id
125: );
123: ,p_argument => 'solution_id'
124: ,p_argument_value => p_solution_id
125: );
126: --
127: if ( nvl(per_sol_bus.g_solution_id, hr_api.g_number)
128: = p_solution_id) then
129: --
130: -- The legislation code has already been found with a previous
131: -- call to this function. Just return the value in the global
269: hr_utility.set_location('Entering:'|| l_proc, 10);
270: --
271: -- Check mandatory parameters have been set
272: --
273: hr_api.mandatory_arg_error
274: (p_api_name => l_proc
275: ,p_argument => 'effective date'
276: ,p_argument_value => p_effective_date
277: );
285: (p_solution_id => p_solution_id
286: ,p_object_version_number => p_object_version_number
287: );
288: if ((l_api_updating
289: and nvl(per_sol_shd.g_old_rec.vertical, hr_api.g_varchar2)
290: <> nvl(p_vertical,hr_api.g_varchar2))
291: or
292: (NOT l_api_updating))
293: then
286: ,p_object_version_number => p_object_version_number
287: );
288: if ((l_api_updating
289: and nvl(per_sol_shd.g_old_rec.vertical, hr_api.g_varchar2)
290: <> nvl(p_vertical,hr_api.g_varchar2))
291: or
292: (NOT l_api_updating))
293: then
294: hr_utility.set_location(l_proc, 40);
301: -- lookup type 'PER_SOLUTION_VERTICALS' with an enabled flag set to 'Y'
302: -- and that the effective date is between start date
303: -- active and end date active in HR_STANDARD_LOOKUPS.
304: --
305: if hr_api.not_exists_in_hrstanlookups
306: (p_effective_date => p_effective_date
307: ,p_lookup_type => 'PER_SOLUTION_VERTICALS'
308: ,p_lookup_code => p_vertical
309: )