40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bng_shd.api_updating
47: (p_benfts_grp_id => p_benfts_grp_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_benfts_grp_id;
75: --
76: -- ----------------------------------------------------------------------------
111: and name = p_name
112: and business_group_id = p_business_group_id;
113: --
114: Begin
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: open c1;
118: fetch c1 into l_dummy;
119: if c1%found then
121: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
122: fnd_message.raise_error;
123: end if;
124: --
125: hr_utility.set_location('Leaving:'||l_proc, 15);
126: End chk_name_unique;
127: --
128: -- ----------------------------------------------------------------------- --
129: -- -----------------------< chk_child_records >-----------------------------|
160: where per.benefit_group_id = p_benfts_grp_id
161: and per.business_Group_id= p_business_group_id; /* Perf Bug 4882374 */
162: begin
163: --
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: -- check if benefit groups exists in the per_all_people_f table
167: --
168: open chk_benefits_group;
182: end if;
183: --
184: close chk_benefits_group;
185: --
186: hr_utility.set_location('Leaving:'||l_proc,10);
187: --
188: end chk_child_records;
189: --
190: -- ----------------------------------------------------------------------------
194: --
195: l_proc varchar2(72) := g_package||'insert_validate';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: -- Call all supporting business operations
201: --
202: --
210: ( p_benfts_grp_id => p_rec.benfts_grp_id
211: ,p_name => p_rec.name
212: ,p_business_group_id => p_rec.business_group_id);
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End insert_validate;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |---------------------------< update_validate >----------------------------|
221: --
222: l_proc varchar2(72) := g_package||'update_validate';
223: --
224: Begin
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: -- Call all supporting business operations
228: --
229: --
237: ( p_benfts_grp_id => p_rec.benfts_grp_id
238: ,p_name => p_rec.name
239: ,p_business_group_id => p_rec.business_group_id);
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: End update_validate;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |---------------------------< delete_validate >----------------------------|
248: --
249: l_proc varchar2(72) := g_package||'delete_validate';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- Call all supporting business operations
255: --
256: chk_child_records
256: chk_child_records
257: (p_benfts_grp_id => p_rec.benfts_grp_id,
258: p_business_Group_id => p_rec.business_Group_id);
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End delete_validate;
262: --
263: --
264: -- ---------------------------------------------------------------------------
283: l_proc varchar2(72) := g_package||'return_legislation_code';
284: --
285: begin
286: --
287: hr_utility.set_location('Entering:'|| l_proc, 10);
288: --
289: -- Ensure that all the mandatory parameter are not null
290: --
291: hr_api.mandatory_arg_error(p_api_name => l_proc,
301: close csr_leg_code;
302: --
303: -- The primary key is invalid therefore we must error
304: --
305: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
306: hr_utility.raise_error;
307: --
308: end if;
309: --
302: --
303: -- The primary key is invalid therefore we must error
304: --
305: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
306: hr_utility.raise_error;
307: --
308: end if;
309: --
310: close csr_leg_code;
308: end if;
309: --
310: close csr_leg_code;
311: --
312: hr_utility.set_location(' Leaving:'|| l_proc, 20);
313: --
314: return l_legislation_code;
315: --
316: end return_legislation_code;