[Home] [Help]
31: l_proc varchar2(72) := g_package||'set_security_group_id';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error
62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);
67: --
68: end set_security_group_id;
69: --
70: --
101: l_api_updating boolean;
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: l_api_updating := ben_xfi_shd.api_updating
108: (p_ext_file_id => p_ext_file_id,
109: p_object_version_number => p_object_version_number);
129: end if;
130: --
131: end if;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 10);
134: --
135: End chk_ext_file_id;
136: --
137: -- ----------------------------------------------------------------------------
184: )
185: ;
186: --
187: Begin
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: if p_name is null then
191: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
192: fnd_message.raise_error;
198: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
199: fnd_message.raise_error;
200: end if;
201: --
202: hr_utility.set_location('Leaving:'||l_proc, 15);
203: End chk_name_unique;
204: --
205: -- ----------------------------------------------------------------------------
206: -- |----------------------< chk_startup_action >------------------------------|
257: --
258: l_proc varchar2(72) := g_package||'insert_validate';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: -- Call all supporting business operations
264: --
265: --
278: (p_ext_file_id => p_rec.ext_file_id,
279: p_name => p_rec.name,
280: p_business_group_id => p_rec.business_group_id,
281: p_legislation_code => p_rec.legislation_code);
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: End insert_validate;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |---------------------------< update_validate >----------------------------|
289: --
290: l_proc varchar2(72) := g_package||'update_validate';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Call all supporting business operations
296: --
297: chk_startup_action(False
309: (p_ext_file_id => p_rec.ext_file_id,
310: p_name => p_rec.name,
311: p_business_group_id => p_rec.business_group_id,
312: p_legislation_code => p_rec.legislation_code);
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End update_validate;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |---------------------------< delete_validate >----------------------------|
320: --
321: l_proc varchar2(72) := g_package||'delete_validate';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: -- Call all supporting business operations
327: --
328: --
329: chk_startup_action(False
330: ,ben_xfi_shd.g_old_rec.business_group_id
331: ,ben_xfi_shd.g_old_rec.legislation_code);
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: End delete_validate;
335: --
336: --
337: -- ---------------------------------------------------------------------------
356: l_proc varchar2(72) := g_package||'return_legislation_code';
357: --
358: begin
359: --
360: hr_utility.set_location('Entering:'|| l_proc, 10);
361: --
362: -- Ensure that all the mandatory parameter are not null
363: --
364: hr_api.mandatory_arg_error(p_api_name => l_proc,
381: end if;
382: --
383: close csr_leg_code;
384: --
385: hr_utility.set_location(' Leaving:'|| l_proc, 20);
386: --
387: return l_legislation_code;
388: --
389: end return_legislation_code;