DBA Data[Home] [Help]

APPS.BEN_BNG_BUS dependencies on HR_UTILITY

Line 44: hr_utility.set_location('Entering:'||l_proc, 5);

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);

Line 72: hr_utility.set_location('Leaving:'||l_proc, 10);

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: -- ----------------------------------------------------------------------------

Line 115: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 125: hr_utility.set_location('Leaving:'||l_proc, 15);

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 >-----------------------------|

Line 164: hr_utility.set_location('Entering:'||l_proc, 5);

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;

Line 186: hr_utility.set_location('Leaving:'||l_proc,10);

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: -- ----------------------------------------------------------------------------

Line 198: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 214: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >----------------------------|

Line 225: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 241: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >----------------------------|

Line 252: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 260: hr_utility.set_location(' Leaving:'||l_proc, 10);

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: -- ---------------------------------------------------------------------------

Line 287: hr_utility.set_location('Entering:'|| l_proc, 10);

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,

Line 305: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 306: hr_utility.raise_error;

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;

Line 312: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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;