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

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

48: l_api_updating boolean;
49: --
50: Begin
51: --
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: --
54: l_api_updating := ben_vep_shd.api_updating
55: (p_effective_date => p_effective_date,
56: p_vrbl_rt_elig_prfl_id => p_vrbl_rt_elig_prfl_id,

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

76: end if;
77: --
78: end if;
79: --
80: hr_utility.set_location('Leaving:'||l_proc, 10);
81: --
82: End chk_vrbl_rt_elig_prfl_id;
83:
84:

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

119: l_api_updating boolean;
120: --
121: Begin
122: --
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: l_api_updating := ben_vep_shd.api_updating
126: (p_vrbl_rt_elig_prfl_id => p_vrbl_rt_elig_prfl_id,
127: p_effective_date => p_effective_date,

Line 145: hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');

141: p_effective_date => p_effective_date) then
142: --
143: -- raise error as does not exist as lookup
144: --
145: hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');
146: hr_utility.raise_error;
147: --
148: end if;
149: end if;

Line 146: hr_utility.raise_error;

142: --
143: -- raise error as does not exist as lookup
144: --
145: hr_utility.set_message(801,'MNDTRY_FLAG_NOT_EXIST');
146: hr_utility.raise_error;
147: --
148: end if;
149: end if;
150: --

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

147: --
148: end if;
149: end if;
150: --
151: hr_utility.set_location('Leaving:'||l_proc,10);
152: --
153: end chk_mndtry_flag;
154: -- ----------------------------------------------------------------------------
155: -- |------< chk_vrbl_rt_elig_prfl_count >------|

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

193: and p_effective_date between effective_start_date
194: and effective_end_date;
195:
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: -- raise error as the record already exists
200: open c_vrbl_rt_elig_prfl ;
201: fetch c_vrbl_rt_elig_prfl into l_dummy ;

Line 205: hr_utility.set_location('Only one Profile is allowed ', 8 ) ;

201: fetch c_vrbl_rt_elig_prfl into l_dummy ;
202: --
203: if c_vrbl_rt_elig_prfl%found then
204: --
205: hr_utility.set_location('Only one Profile is allowed ', 8 ) ;
206: close c_vrbl_rt_elig_prfl ;
207: fnd_message.set_name('BEN','BEN_93952_ONLY_ONE_ELPRO');
208: fnd_message.raise_error;
209: --

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

209: --
210: end if;
211: close c_vrbl_rt_elig_prfl ;
212: --
213: hr_utility.set_location('Leaving:'||l_proc, 10);
214: --
215: End chk_vrbl_rt_elig_prfl_count;
216: --
217: --

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

258: and vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
259: and vep.effective_start_date > p_effective_date
260: and nvl(vep.vrbl_rt_elig_prfl_id,-1) <> p_vrbl_rt_elig_prfl_id ;
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: -- raise error as the record already exists
265: open c_uniq_vrbl_rt_elig_prfl ;
266: fetch c_uniq_vrbl_rt_elig_prfl into l_dummy ;

Line 270: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;

266: fetch c_uniq_vrbl_rt_elig_prfl into l_dummy ;
267: --
268: if c_uniq_vrbl_rt_elig_prfl%found then
269: --
270: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
271: close c_uniq_vrbl_rt_elig_prfl ;
272: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
273: fnd_message.raise_error;
274: --

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

274: --
275: end if;
276: close c_uniq_vrbl_rt_elig_prfl ;
277: --
278: hr_utility.set_location('Leaving:'||l_proc, 10);
279: --
280: End chk_uniq_vrbl_rt_elig_prfl;
281: --
282: -- 2940151

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

496: -- or rt_elig_prfl_flag = 'Y'
497: );
498:
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- raise error as the record already exists
503: open c_vrbl_rt_flags ;
504: fetch c_vrbl_rt_flags into l_dummy ;

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

512: --
513: end if;
514: close c_vrbl_rt_flags ;
515: --
516: hr_utility.set_location('Leaving:'||l_proc, 10);
517: --
518: End chk_elig_prfl_criteria;
519: --
520:

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

541: l_proc varchar2(72) := g_package||'set_security_group_id';
542: --
543: begin
544: --
545: hr_utility.set_location('Entering:'|| l_proc, 10);
546: --
547: -- Ensure that all the mandatory parameter are not null
548: --
549: hr_api.mandatory_arg_error

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

572: hr_api.set_security_group_id
573: (p_security_group_id => l_security_group_id
574: );
575: --
576: hr_utility.set_location(' Leaving:'|| l_proc, 20);
577: --
578: end set_security_group_id;
579: --
580: -- ---------------------------------------------------------------------------

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

601: l_proc varchar2(72) := g_package||'return_legislation_code';
602: --
603: Begin
604: --
605: hr_utility.set_location('Entering:'|| l_proc, 10);
606: --
607: -- Ensure that all the mandatory parameter are not null
608: --
609: hr_api.mandatory_arg_error

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

619: -- call to this function. Just return the value in the global
620: -- variable.
621: --
622: l_legislation_code := ben_vep_bus.g_legislation_code;
623: hr_utility.set_location(l_proc, 20);
624: else
625: --
626: -- The ID is different to the last call to this function
627: -- or this is the first call to this function.

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

636: close csr_leg_code;
637: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
638: fnd_message.raise_error;
639: end if;
640: hr_utility.set_location(l_proc,30);
641: --
642: -- Set the global variables so the values are
643: -- available for the next call to this function.
644: --

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

645: close csr_leg_code;
646: ben_vep_bus.g_vrbl_rt_elig_prfl_id := p_vrbl_rt_elig_prfl_id;
647: ben_vep_bus.g_legislation_code := l_legislation_code;
648: end if;
649: hr_utility.set_location(' Leaving:'|| l_proc, 40);
650: return l_legislation_code;
651: end return_legislation_code;
652: --
653: /*

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

685: --
686: l_proc varchar2(72) := g_package || 'chk_df';
687: --
688: begin
689: hr_utility.set_location('Entering:'||l_proc,10);
690: --
691: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
692: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
693: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or

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

824: ,p_attribute30_value => p_rec.vep_attribute30
825: );
826: end if;
827: --
828: hr_utility.set_location(' Leaving:'||l_proc,20);
829: end chk_df;
830: */
831: --
832: /*

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

947: --
948: --
949: Begin
950: --
951: hr_utility.set_location('Entering:'||l_proc, 5);
952: --
953: open c1;
954: fetch c1 into l_dummy;
955: --

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

973: --
974: close c2;
975: --
976: --
977: hr_utility.set_location('Leaving:'||l_proc, 10);
978: End chk_ttlcov_ttlprtt_mutexcl;
979: --
980: --
981: -- ----------------------------------------------------------------------------

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

1019: and p_effective_date between effective_start_date and effective_end_date;
1020: --
1021: Begin
1022: --
1023: hr_utility.set_location('Entering:'||l_proc, 5);
1024: --
1025: open c1;
1026: fetch c1 into l_mlt_cd, l_vrbl_usg_cd;
1027: close c1;

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

1048: end if;
1049: end if;
1050: close c3;
1051: --
1052: hr_utility.set_location('Leaving:'||l_proc, 10);
1053: End chk_ttlcov_ttlprtt_mlt_cd;
1054: --
1055:
1056: --

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

1255: --
1256: l_proc varchar2(72) := g_package||'insert_validate';
1257: --
1258: Begin
1259: hr_utility.set_location('Entering:'||l_proc, 5);
1260: --
1261: -- Call all supporting business operations
1262: --
1263: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1307: p_effective_date => p_effective_date,
1308: p_business_group_id => p_rec.business_group_id);
1309:
1310:
1311: hr_utility.set_location(' Leaving:'||l_proc, 10);
1312: End insert_validate;
1313: --
1314: -- ----------------------------------------------------------------------------
1315: -- |---------------------------< update_validate >----------------------------|

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

1324: --
1325: l_proc varchar2(72) := g_package||'update_validate';
1326: --
1327: Begin
1328: hr_utility.set_location('Entering:'||l_proc, 5);
1329: --
1330: -- Call all supporting business operations
1331: --
1332: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1390: --
1391: --
1392: --ben_vep_bus.chk_df(p_rec);
1393: --
1394: hr_utility.set_location(' Leaving:'||l_proc, 10);
1395: End update_validate;
1396: --
1397: -- ----------------------------------------------------------------------------
1398: -- |---------------------------< delete_validate >----------------------------|

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

1407: --
1408: l_proc varchar2(72) := g_package||'delete_validate';
1409: --
1410: Begin
1411: hr_utility.set_location('Entering:'||l_proc, 5);
1412: --
1413: -- Call all supporting business operations
1414: --
1415: dt_delete_validate

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

1418: ,p_validation_end_date => p_validation_end_date
1419: ,p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
1420: );
1421: --
1422: hr_utility.set_location(' Leaving:'||l_proc, 10);
1423: End delete_validate;
1424: end ben_vep_bus;