[Home] [Help]
43: l_proc varchar2(72) := g_package||'set_security_group_id';
44: --
45: begin
46: --
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
78: (p_security_group_id => l_security_group_id
79: );
80: end if;
81: --
82: hr_utility.set_location(' Leaving:'|| l_proc, 20);
83: --
84: end set_security_group_id;
85: --
86: -- ---------------------------------------------------------------------------
113: l_proc varchar2(72) := g_package||'return_legislation_code';
114: --
115: Begin
116: --
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
131: -- call to this function. Just return the value in the global
132: -- variable.
133: --
134: l_legislation_code := per_sol_bus.g_legislation_code;
135: hr_utility.set_location(l_proc, 20);
136: else
137: --
138: -- The ID is different to the last call to this function
139: -- or this is the first call to this function.
148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are
155: -- available for the next call to this function.
156: --
157: close csr_leg_code;
158: per_sol_bus.g_solution_id := p_solution_id;
159: per_sol_bus.g_legislation_code := l_legislation_code;
160: end if;
161: hr_utility.set_location(' Leaving:'|| l_proc, 40);
162: return l_legislation_code;
163: end return_legislation_code;
164: --
165: -- ----------------------------------------------------------------------------
265: l_proc varchar2(72) := g_package||'chk_vertical';
266: l_api_updating boolean;
267: --
268: begin
269: hr_utility.set_location('Entering:'|| l_proc, 10);
270: --
271: -- Check mandatory parameters have been set
272: --
273: hr_api.mandatory_arg_error
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);
295: --
296: -- Check if vertical is set
297: --
298: if p_vertical is not null then
308: ,p_lookup_code => p_vertical
309: )
310: then
311: --
312: hr_utility.set_message(801, 'HR_EDIT');
313: hr_utility.raise_error;
314: --
315: end if;
316: hr_utility.set_location(l_proc, 50);
309: )
310: then
311: --
312: hr_utility.set_message(801, 'HR_EDIT');
313: hr_utility.raise_error;
314: --
315: end if;
316: hr_utility.set_location(l_proc, 50);
317: --
312: hr_utility.set_message(801, 'HR_EDIT');
313: hr_utility.raise_error;
314: --
315: end if;
316: hr_utility.set_location(l_proc, 50);
317: --
318: end if;
319: end if;
320: hr_utility.set_location(' Leaving:'|| l_proc, 60);
316: hr_utility.set_location(l_proc, 50);
317: --
318: end if;
319: end if;
320: hr_utility.set_location(' Leaving:'|| l_proc, 60);
321: end chk_vertical;
322: --
323: -- ----------------------------------------------------------------------------
324: -- |---------------------------< insert_validate >----------------------------|
330: --
331: l_proc varchar2(72) := g_package||'insert_validate';
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- Call all supporting business operations
337: --
338: -- No business group context. HR_STANDARD_LOOKUPS used for validation."
346: ,p_effective_date => p_effective_date
347: ,p_object_version_number => p_rec.object_version_number
348: );
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 10);
351: End insert_validate;
352: --
353: -- ----------------------------------------------------------------------------
354: -- |---------------------------< update_validate >----------------------------|
360: --
361: l_proc varchar2(72) := g_package||'update_validate';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: -- Call all supporting business operations
367: --
368: -- No business group context. HR_STANDARD_LOOKUPS used for validation."
381: ,p_object_version_number => p_rec.object_version_number
382: );
383: --
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: End update_validate;
387: --
388: -- ----------------------------------------------------------------------------
389: -- |---------------------------< delete_validate >----------------------------|
394: --
395: l_proc varchar2(72) := g_package||'delete_validate';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Call all supporting business operations
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Call all supporting business operations
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End delete_validate;
404: --
405: end per_sol_bus;