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 386: hr_utility.set_location('Entering:'||l_proc, 5);

382: -- or rt_elig_prfl_flag = 'Y'
383: );
384:
385: Begin
386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: -- raise error as the record already exists
389: open c_vrbl_rt_flags ;
390: fetch c_vrbl_rt_flags into l_dummy ;

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

398: --
399: end if;
400: close c_vrbl_rt_flags ;
401: --
402: hr_utility.set_location('Leaving:'||l_proc, 10);
403: --
404: End chk_elig_prfl_criteria;
405: --
406:

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

427: l_proc varchar2(72) := g_package||'set_security_group_id';
428: --
429: begin
430: --
431: hr_utility.set_location('Entering:'|| l_proc, 10);
432: --
433: -- Ensure that all the mandatory parameter are not null
434: --
435: hr_api.mandatory_arg_error

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

458: hr_api.set_security_group_id
459: (p_security_group_id => l_security_group_id
460: );
461: --
462: hr_utility.set_location(' Leaving:'|| l_proc, 20);
463: --
464: end set_security_group_id;
465: --
466: -- ---------------------------------------------------------------------------

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

487: l_proc varchar2(72) := g_package||'return_legislation_code';
488: --
489: Begin
490: --
491: hr_utility.set_location('Entering:'|| l_proc, 10);
492: --
493: -- Ensure that all the mandatory parameter are not null
494: --
495: hr_api.mandatory_arg_error

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

505: -- call to this function. Just return the value in the global
506: -- variable.
507: --
508: l_legislation_code := ben_vep_bus.g_legislation_code;
509: hr_utility.set_location(l_proc, 20);
510: else
511: --
512: -- The ID is different to the last call to this function
513: -- or this is the first call to this function.

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

522: close csr_leg_code;
523: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
524: fnd_message.raise_error;
525: end if;
526: hr_utility.set_location(l_proc,30);
527: --
528: -- Set the global variables so the values are
529: -- available for the next call to this function.
530: --

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

531: close csr_leg_code;
532: ben_vep_bus.g_vrbl_rt_elig_prfl_id := p_vrbl_rt_elig_prfl_id;
533: ben_vep_bus.g_legislation_code := l_legislation_code;
534: end if;
535: hr_utility.set_location(' Leaving:'|| l_proc, 40);
536: return l_legislation_code;
537: end return_legislation_code;
538: --
539: /*

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

571: --
572: l_proc varchar2(72) := g_package || 'chk_df';
573: --
574: begin
575: hr_utility.set_location('Entering:'||l_proc,10);
576: --
577: if ((p_rec.vrbl_rt_elig_prfl_id is not null) and (
578: nvl(ben_vep_shd.g_old_rec.vep_attribute_category, hr_api.g_varchar2) <>
579: nvl(p_rec.vep_attribute_category, hr_api.g_varchar2) or

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

710: ,p_attribute30_value => p_rec.vep_attribute30
711: );
712: end if;
713: --
714: hr_utility.set_location(' Leaving:'||l_proc,20);
715: end chk_df;
716: */
717: --
718: /*

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

833: --
834: --
835: Begin
836: --
837: hr_utility.set_location('Entering:'||l_proc, 5);
838: --
839: open c1;
840: fetch c1 into l_dummy;
841: --

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

859: --
860: close c2;
861: --
862: --
863: hr_utility.set_location('Leaving:'||l_proc, 10);
864: End chk_ttlcov_ttlprtt_mutexcl;
865: --
866: --
867: -- ----------------------------------------------------------------------------

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

905: and p_effective_date between effective_start_date and effective_end_date;
906: --
907: Begin
908: --
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: --
911: open c1;
912: fetch c1 into l_mlt_cd, l_vrbl_usg_cd;
913: close c1;

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

934: end if;
935: end if;
936: close c3;
937: --
938: hr_utility.set_location('Leaving:'||l_proc, 10);
939: End chk_ttlcov_ttlprtt_mlt_cd;
940: --
941:
942: --

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

1141: --
1142: l_proc varchar2(72) := g_package||'insert_validate';
1143: --
1144: Begin
1145: hr_utility.set_location('Entering:'||l_proc, 5);
1146: --
1147: -- Call all supporting business operations
1148: --
1149: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1193: p_effective_date => p_effective_date,
1194: p_business_group_id => p_rec.business_group_id);
1195:
1196:
1197: hr_utility.set_location(' Leaving:'||l_proc, 10);
1198: End insert_validate;
1199: --
1200: -- ----------------------------------------------------------------------------
1201: -- |---------------------------< update_validate >----------------------------|

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

1210: --
1211: l_proc varchar2(72) := g_package||'update_validate';
1212: --
1213: Begin
1214: hr_utility.set_location('Entering:'||l_proc, 5);
1215: --
1216: -- Call all supporting business operations
1217: --
1218: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1276: --
1277: --
1278: --ben_vep_bus.chk_df(p_rec);
1279: --
1280: hr_utility.set_location(' Leaving:'||l_proc, 10);
1281: End update_validate;
1282: --
1283: -- ----------------------------------------------------------------------------
1284: -- |---------------------------< delete_validate >----------------------------|

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

1293: --
1294: l_proc varchar2(72) := g_package||'delete_validate';
1295: --
1296: Begin
1297: hr_utility.set_location('Entering:'||l_proc, 5);
1298: --
1299: -- Call all supporting business operations
1300: --
1301: dt_delete_validate

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

1304: ,p_validation_end_date => p_validation_end_date
1305: ,p_vrbl_rt_elig_prfl_id => p_rec.vrbl_rt_elig_prfl_id
1306: );
1307: --
1308: hr_utility.set_location(' Leaving:'||l_proc, 10);
1309: End delete_validate;
1310: end ben_vep_bus;