eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_LRI_BUS dependencies on HR_UTILITY

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

44: l_proc varchar2(72) := g_package||'return_legislation_code';
45: --
46: Begin
47: --
48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Ensure that all the mandatory parameter are not null
51: --
52: hr_api.mandatory_arg_error

Line 66: hr_utility.set_location(l_proc, 20);

62: -- call to this function. Just return the value in the global
63: -- variable.
64: --
65: l_legislation_code := ben_lri_bus.g_legislation_code;
66: hr_utility.set_location(l_proc, 20);
67: else
68: --
69: -- The ID is different to the last call to this function
70: -- or this is the first call to this function.

Line 83: hr_utility.set_location(l_proc,30);

79: close csr_leg_code;
80: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
81: fnd_message.raise_error;
82: end if;
83: hr_utility.set_location(l_proc,30);
84: --
85: --
86: -- Set the global variables so the values are
87: -- available for the next call to this function.

Line 93: hr_utility.set_location(' Leaving:'|| l_proc, 40);

89: close csr_leg_code;
90: ben_lri_bus.g_ler_extra_info_id := p_ler_extra_info_id;
91: ben_lri_bus.g_legislation_code := l_legislation_code;
92: end if;
93: hr_utility.set_location(' Leaving:'|| l_proc, 40);
94: return l_legislation_code;
95: end return_legislation_code;
96: --
97:

Line 144: hr_utility.set_location('Entering:'||l_proc, 1);

140: from ben_ler_info_types ler
141: where ler.information_type = code;
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 1);
145: --
146: -- Check mandatory parameters have been set
147: --
148: hr_api.mandatory_arg_error

Line 155: hr_utility.set_location(l_proc, 2);

151: p_argument => 'information_type',
152: p_argument_value => p_information_type
153: );
154: --
155: hr_utility.set_location(l_proc, 2);
156: --
157: -- Check that the ACTIVE_INACTIVE_FLAG of ler
158: -- Information type is active.
159: --

Line 164: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

160: open c_ler_info_type (p_information_type);
161: fetch c_ler_info_type into l_flag;
162: if c_ler_info_type%notfound then
163: close c_ler_info_type;
164: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
165: hr_utility.raise_error;
166: end if;
167: close c_ler_info_type;
168: --

Line 165: hr_utility.raise_error;

161: fetch c_ler_info_type into l_flag;
162: if c_ler_info_type%notfound then
163: close c_ler_info_type;
164: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
165: hr_utility.raise_error;
166: end if;
167: close c_ler_info_type;
168: --
169: if l_flag = 'N' then

Line 170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');

166: end if;
167: close c_ler_info_type;
168: --
169: if l_flag = 'N' then
170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
171: hr_utility.raise_error;
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 171: hr_utility.raise_error;

167: close c_ler_info_type;
168: --
169: if l_flag = 'N' then
170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
171: hr_utility.raise_error;
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 3);
175: --

Line 174: hr_utility.set_location(' Leaving:'||l_proc, 3);

170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
171: hr_utility.raise_error;
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 3);
175: --
176: End chk_ler_info_type;
177: --
178: -- ----------------------------------------------------------------------------

Line 226: hr_utility.set_location('Entering:'||l_proc, 1);

222:
223:
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 1);
227: --
228: -- Check mandatory parameters have been set
229: --
230: hr_api.mandatory_arg_error

Line 236: hr_utility.set_location(l_proc, 2);

232: p_api_name => l_proc,
233: p_argument => 'ler_id',
234: p_argument_value => p_ler_id
235: );
236: hr_utility.set_location(l_proc, 2);
237: --
238: -- Check that the ler_id is in the ben_ler table.
239: --
240: open c_valid_ler (p_ler_id);

Line 244: hr_utility.set_message(800, 'HR_INV_LER_ID');

240: open c_valid_ler (p_ler_id);
241: fetch c_valid_ler into l_dummy;
242: if c_valid_ler%notfound then
243: close c_valid_ler;
244: hr_utility.set_message(800, 'HR_INV_LER_ID');
245: hr_utility.raise_error;
246: end if;
247: close c_valid_ler;
248: --

Line 245: hr_utility.raise_error;

241: fetch c_valid_ler into l_dummy;
242: if c_valid_ler%notfound then
243: close c_valid_ler;
244: hr_utility.set_message(800, 'HR_INV_LER_ID');
245: hr_utility.raise_error;
246: end if;
247: close c_valid_ler;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 249: hr_utility.set_location(' Leaving:'||l_proc, 3);

245: hr_utility.raise_error;
246: end if;
247: close c_valid_ler;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 3);
250: --
251: End chk_ler_id;
252: --
253: -- ----------------------------------------------------------------------------

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

303: where information_type = code
304: and ler_id = id;
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: open c_multi_occur_flag (p_information_type);
310: fetch c_multi_occur_flag into l_multi_occur_flag;
311: --

Line 317: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

313: -- chk_information_type should capture this error.
314: --
315: if c_multi_occur_flag%notfound then
316: close c_multi_occur_flag;
317: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
318: hr_utility.raise_error;
319: end if;
320: --
321: close c_multi_occur_flag;

Line 318: hr_utility.raise_error;

314: --
315: if c_multi_occur_flag%notfound then
316: close c_multi_occur_flag;
317: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
318: hr_utility.raise_error;
319: end if;
320: --
321: close c_multi_occur_flag;
322: --

Line 323: hr_utility.set_location(l_proc, 10);

319: end if;
320: --
321: close c_multi_occur_flag;
322: --
323: hr_utility.set_location(l_proc, 10);
324: --
325: open c_get_row(p_information_type, p_ler_id);
326: fetch c_get_row into l_dummy;
327: if c_get_row%notfound then

Line 335: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');

331: end if;
332: close c_get_row;
333: --
334: if l_found_ler and l_multi_occur_flag = 'N' then
335: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
336: hr_utility.raise_error;
337: end if;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 336: hr_utility.raise_error;

332: close c_get_row;
333: --
334: if l_found_ler and l_multi_occur_flag = 'N' then
335: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
336: hr_utility.raise_error;
337: end if;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 15);
340: --

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

335: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
336: hr_utility.raise_error;
337: end if;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 15);
340: --
341: End chk_multiple_occurences_flag;
342: --
343: -- ----------------------------------------------------------------------------

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

376: l_error exception;
377: l_argument varchar2(30);
378: --
379: Begin
380: hr_utility.set_location('Entering:'||l_proc, 10);
381: --
382: -- Only proceed with validation if a row exists for
383: -- the current record in the HR Schema
384: --

Line 388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

384: --
385: if not ben_lri_shd.api_updating
386: (p_ler_extra_info_id => p_rec.ler_extra_info_id
387: ,p_object_version_number => p_rec.object_version_number) then
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP', '20');
391: end if;
392: --

Line 389: hr_utility.set_message_token('PROCEDURE', l_proc);

385: if not ben_lri_shd.api_updating
386: (p_ler_extra_info_id => p_rec.ler_extra_info_id
387: ,p_object_version_number => p_rec.object_version_number) then
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP', '20');
391: end if;
392: --
393: hr_utility.set_location(l_proc, 30);

Line 390: hr_utility.set_message_token('STEP', '20');

386: (p_ler_extra_info_id => p_rec.ler_extra_info_id
387: ,p_object_version_number => p_rec.object_version_number) then
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP', '20');
391: end if;
392: --
393: hr_utility.set_location(l_proc, 30);
394: --

Line 393: hr_utility.set_location(l_proc, 30);

389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP', '20');
391: end if;
392: --
393: hr_utility.set_location(l_proc, 30);
394: --
395: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
396: nvl(ben_lri_shd.g_old_rec.information_type, hr_api.g_varchar2) then
397: l_argument := 'information_type';

Line 401: hr_utility.set_location(l_proc, 40);

397: l_argument := 'information_type';
398: raise l_error;
399: end if;
400: --
401: hr_utility.set_location(l_proc, 40);
402: --
403: if nvl(p_rec.ler_id, hr_api.g_number) <>
404: nvl(ben_lri_shd.g_old_rec.ler_id, hr_api.g_number) then
405: l_argument := 'ler_id';

Line 409: hr_utility.set_location(' Leaving:'||l_proc, 50);

405: l_argument := 'ler_id';
406: raise l_error;
407: end if;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 50);
410: exception
411: when l_error then
412: hr_api.argument_changed_error
413: (p_api_name => l_proc

Line 416: hr_utility.set_location(l_proc, 60);

412: hr_api.argument_changed_error
413: (p_api_name => l_proc
414: ,p_argument => l_argument
415: );
416: hr_utility.set_location(l_proc, 60);
417: when others then
418: hr_utility.set_location(l_proc, 70);
419: raise;
420: end chk_non_updateable_args;

Line 418: hr_utility.set_location(l_proc, 70);

414: ,p_argument => l_argument
415: );
416: hr_utility.set_location(l_proc, 60);
417: when others then
418: hr_utility.set_location(l_proc, 70);
419: raise;
420: end chk_non_updateable_args;
421:
422: -- |---------------------------< insert_validate >----------------------------|

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

426: --
427: l_proc varchar2(72) := g_package||'insert_validate';
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: -- Validate ler ID
433: --
434: chk_ler_id

Line 576: hr_utility.set_location(' Leaving:'||l_proc, 30);

572: );
573: --
574:
575: --
576: hr_utility.set_location(' Leaving:'||l_proc, 30);
577: --
578: End insert_validate;
579: --
580: -- ----------------------------------------------------------------------------

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

584: --
585: l_proc varchar2(72) := g_package||'update_validate';
586: --
587: Begin
588: hr_utility.set_location('Entering:'||l_proc, 5);
589: --
590: -- Validate Non-Updateable Fields
591: --
592: chk_non_updateable_args (p_rec => p_rec);

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

589: --
590: -- Validate Non-Updateable Fields
591: --
592: chk_non_updateable_args (p_rec => p_rec);
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: --
595: hr_dflex_utility.ins_or_upd_descflex_attribs
596: (p_appl_short_name => 'BEN'
597: ,p_descflex_name => 'Extra Life Event Information'

Line 710: hr_utility.set_location(' Leaving:'||l_proc, 30);

706: ,p_attribute30_value => p_rec.lri_information30
707: );
708:
709: --
710: hr_utility.set_location(' Leaving:'||l_proc, 30);
711: --
712: End update_validate;
713: --
714: -- ----------------------------------------------------------------------------

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

718: --
719: l_proc varchar2(72) := g_package||'delete_validate';
720: --
721: Begin
722: hr_utility.set_location('Entering:'||l_proc, 5);
723: --
724: -- Call all supporting business operations
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

722: hr_utility.set_location('Entering:'||l_proc, 5);
723: --
724: -- Call all supporting business operations
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: End delete_validate;
728: --
729: end ben_lri_bus;