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_ABP_BUS dependencies on HR_UTILITY

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_abp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_aplcn_to_bnft_pool_id => p_aplcn_to_bnft_pool_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_aplcn_to_bnft_pool_id;
78:
79:

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

102: l_dummy_var varchar2(1) ;
103:
104: begin
105:
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: hr_utility.set_location('p_acty_base_rt_id:'||p_acty_base_rt_id, 5);
108: hr_utility.set_location('bnft_prvdr_pool_id:'||p_bnft_prvdr_pool_id, 5);
109: hr_utility.set_location('aplcn_to_bnft_pool_id:'||p_aplcn_to_bnft_pool_id, 5);
110: hr_utility.set_location('effective_date:'||p_effective_date , 5);

Line 107: hr_utility.set_location('p_acty_base_rt_id:'||p_acty_base_rt_id, 5);

103:
104: begin
105:
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: hr_utility.set_location('p_acty_base_rt_id:'||p_acty_base_rt_id, 5);
108: hr_utility.set_location('bnft_prvdr_pool_id:'||p_bnft_prvdr_pool_id, 5);
109: hr_utility.set_location('aplcn_to_bnft_pool_id:'||p_aplcn_to_bnft_pool_id, 5);
110: hr_utility.set_location('effective_date:'||p_effective_date , 5);
111: open c_abp ;

Line 108: hr_utility.set_location('bnft_prvdr_pool_id:'||p_bnft_prvdr_pool_id, 5);

104: begin
105:
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: hr_utility.set_location('p_acty_base_rt_id:'||p_acty_base_rt_id, 5);
108: hr_utility.set_location('bnft_prvdr_pool_id:'||p_bnft_prvdr_pool_id, 5);
109: hr_utility.set_location('aplcn_to_bnft_pool_id:'||p_aplcn_to_bnft_pool_id, 5);
110: hr_utility.set_location('effective_date:'||p_effective_date , 5);
111: open c_abp ;
112: fetch c_abp into l_dummy_var ;

Line 109: hr_utility.set_location('aplcn_to_bnft_pool_id:'||p_aplcn_to_bnft_pool_id, 5);

105:
106: hr_utility.set_location('Entering:'||l_proc, 5);
107: hr_utility.set_location('p_acty_base_rt_id:'||p_acty_base_rt_id, 5);
108: hr_utility.set_location('bnft_prvdr_pool_id:'||p_bnft_prvdr_pool_id, 5);
109: hr_utility.set_location('aplcn_to_bnft_pool_id:'||p_aplcn_to_bnft_pool_id, 5);
110: hr_utility.set_location('effective_date:'||p_effective_date , 5);
111: open c_abp ;
112: fetch c_abp into l_dummy_var ;
113: if c_abp%found then

Line 110: hr_utility.set_location('effective_date:'||p_effective_date , 5);

106: hr_utility.set_location('Entering:'||l_proc, 5);
107: hr_utility.set_location('p_acty_base_rt_id:'||p_acty_base_rt_id, 5);
108: hr_utility.set_location('bnft_prvdr_pool_id:'||p_bnft_prvdr_pool_id, 5);
109: hr_utility.set_location('aplcn_to_bnft_pool_id:'||p_aplcn_to_bnft_pool_id, 5);
110: hr_utility.set_location('effective_date:'||p_effective_date , 5);
111: open c_abp ;
112: fetch c_abp into l_dummy_var ;
113: if c_abp%found then
114: hr_utility.set_location('dupes:'||l_proc, 5);

Line 114: hr_utility.set_location('dupes:'||l_proc, 5);

110: hr_utility.set_location('effective_date:'||p_effective_date , 5);
111: open c_abp ;
112: fetch c_abp into l_dummy_var ;
113: if c_abp%found then
114: hr_utility.set_location('dupes:'||l_proc, 5);
115: close c_abp ;
116: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
117: fnd_message.set_token('VAR1', 'Application');
118: fnd_message.set_token('VAR2','Benefit Pool');

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

119: fnd_message.raise_error;
120: end if ;
121: close c_abp ;
122:
123: hr_utility.set_location('Leaving:'||l_proc, 10);
124:
125: end chk_abr_dups ;
126:
127:

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

166: l_integrity_error Exception;
167: l_table_name all_tables.table_name%TYPE;
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: -- Ensure that the p_datetrack_mode argument is not null
173: --
174: hr_api.mandatory_arg_error

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

215: End If;
216: --
217: End If;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: Exception
221: When l_integrity_error Then
222: --
223: -- A referential integrity check was violated therefore

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

281: l_rows_exist Exception;
282: l_table_name all_tables.table_name%TYPE;
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: -- Ensure that the p_datetrack_mode argument is not null
288: --
289: hr_api.mandatory_arg_error

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

318: --
319: --
320: End If;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: Exception
324: When l_rows_exist Then
325: --
326: -- A referential integrity check was violated therefore

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

351: --
352: l_proc varchar2(72) := g_package||'insert_validate';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: -- Call all supporting business operations
358: --
359: --

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

371: p_effective_date => p_effective_date );
372: --
373:
374:
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: End insert_validate;
377: --
378: -- ----------------------------------------------------------------------------
379: -- |---------------------------< update_validate >----------------------------|

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

387: --
388: l_proc varchar2(72) := g_package||'update_validate';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Call all supporting business operations
394: --
395: --

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

416: p_effective_date => p_effective_date );
417: --
418:
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 10);
421: End update_validate;
422: --
423: -- ----------------------------------------------------------------------------
424: -- |---------------------------< delete_validate >----------------------------|

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

432: --
433: l_proc varchar2(72) := g_package||'delete_validate';
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Call all supporting business operations
439: --
440: dt_delete_validate

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

442: p_validation_start_date => p_validation_start_date,
443: p_validation_end_date => p_validation_end_date,
444: p_aplcn_to_bnft_pool_id => p_rec.aplcn_to_bnft_pool_id);
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: End delete_validate;
448: --
449: --
450: -- ---------------------------------------------------------------------------

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

469: l_proc varchar2(72) := g_package||'return_legislation_code';
470: --
471: begin
472: --
473: hr_utility.set_location('Entering:'|| l_proc, 10);
474: --
475: -- Ensure that all the mandatory parameter are not null
476: --
477: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

494: end if;
495: --
496: close csr_leg_code;
497: --
498: hr_utility.set_location(' Leaving:'|| l_proc, 20);
499: --
500: return l_legislation_code;
501: --
502: end return_legislation_code;