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_PPL_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_ppl_shd.api_updating
47: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_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_ptnl_ler_for_per_id;
75: --
76: -- ----------------------------------------------------------------------------

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

120: and a.effective_end_date;
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc,5);
125: --
126: l_api_updating := ben_ppl_shd.api_updating
127: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
128: p_object_version_number => p_object_version_number);

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

177: close c1;
178: --
179: end if;
180: --
181: hr_utility.set_location('Leaving:'||l_proc,10);
182: --
183: End chk_ler_id;
184: /*
185: --

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

229: and ptnl_ler_for_per_stat_cd not in ('VOIDD', 'BCKDT')
230: and business_group_id = p_business_group_id;
231:
232: begin
233: hr_utility.set_location('Entering' || l_proc,5);
234: --
235: l_api_updating := ben_ppl_shd.api_updating
236: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
237: p_object_version_number => p_object_version_number);

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

254: fnd_message.raise_error;
255: end if;
256: --
257: end if;
258: hr_utility.set_location('Leaving' || l_proc,15);
259: close c1;
260:
261: end chk_unique_ler;
262: */

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

300: where a.ptnl_ler_for_per_id = p_csd_by_ptnl_ler_for_per_id;
301: --
302: Begin
303: --
304: hr_utility.set_location('Entering:'||l_proc,5);
305: --
306: l_api_updating := ben_ppl_shd.api_updating
307: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
308: p_object_version_number => p_object_version_number);

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

331: close c1;
332: --
333: end if;
334: --
335: hr_utility.set_location('Leaving:'||l_proc,10);
336: --
337: End chk_csd_by_ptnl_ler_for_per_id;
338: --
339: --

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

376: where a.enrt_perd_id = p_enrt_perd_id;
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc,5);
381: --
382: l_api_updating := ben_ppl_shd.api_updating
383: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
384: p_object_version_number => p_object_version_number);

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

407: close c1;
408: --
409: end if;
410: --
411: hr_utility.set_location('Leaving:'||l_proc,10);
412: --
413: End chk_enrt_perd_id;
414: --
415: -- ----------------------------------------------------------------------------

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

490:
491: --
492: Begin
493: --
494: hr_utility.set_location('Entering:'||l_proc,5);
495: /*
496: hr_utility.set_location('p_person_id: '||p_person_id,5);
497: hr_utility.set_location('p_ptnl_ler_for_per_id: '||p_ptnl_ler_for_per_id,5);
498: hr_utility.set_location('p_effective_date: '||p_effective_date,5);

Line 496: hr_utility.set_location('p_person_id: '||p_person_id,5);

492: Begin
493: --
494: hr_utility.set_location('Entering:'||l_proc,5);
495: /*
496: hr_utility.set_location('p_person_id: '||p_person_id,5);
497: hr_utility.set_location('p_ptnl_ler_for_per_id: '||p_ptnl_ler_for_per_id,5);
498: hr_utility.set_location('p_effective_date: '||p_effective_date,5);
499: hr_utility.set_location('p_object_version_number: '||p_object_version_number,5);
500: */

Line 497: hr_utility.set_location('p_ptnl_ler_for_per_id: '||p_ptnl_ler_for_per_id,5);

493: --
494: hr_utility.set_location('Entering:'||l_proc,5);
495: /*
496: hr_utility.set_location('p_person_id: '||p_person_id,5);
497: hr_utility.set_location('p_ptnl_ler_for_per_id: '||p_ptnl_ler_for_per_id,5);
498: hr_utility.set_location('p_effective_date: '||p_effective_date,5);
499: hr_utility.set_location('p_object_version_number: '||p_object_version_number,5);
500: */
501: --

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

494: hr_utility.set_location('Entering:'||l_proc,5);
495: /*
496: hr_utility.set_location('p_person_id: '||p_person_id,5);
497: hr_utility.set_location('p_ptnl_ler_for_per_id: '||p_ptnl_ler_for_per_id,5);
498: hr_utility.set_location('p_effective_date: '||p_effective_date,5);
499: hr_utility.set_location('p_object_version_number: '||p_object_version_number,5);
500: */
501: --
502: l_api_updating := ben_ppl_shd.api_updating

Line 499: hr_utility.set_location('p_object_version_number: '||p_object_version_number,5);

495: /*
496: hr_utility.set_location('p_person_id: '||p_person_id,5);
497: hr_utility.set_location('p_ptnl_ler_for_per_id: '||p_ptnl_ler_for_per_id,5);
498: hr_utility.set_location('p_effective_date: '||p_effective_date,5);
499: hr_utility.set_location('p_object_version_number: '||p_object_version_number,5);
500: */
501: --
502: l_api_updating := ben_ppl_shd.api_updating
503: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,

Line 512: hr_utility.set_location('ace p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 9999);

508: <> nvl(ben_ppl_shd.g_old_rec.person_id,hr_api.g_number)
509: or not l_api_updating) then
510: --
511: -- check if person_id value exists in per_all_people_f table
512: hr_utility.set_location('ace p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 9999);
513: hr_utility.set_location('p_effective_date = ' || p_effective_date, 9999);
514: l_person_id := p_person_id;
515:
516: -- 5747460: Get COBRA Qualifying Event flag

Line 513: hr_utility.set_location('p_effective_date = ' || p_effective_date, 9999);

509: or not l_api_updating) then
510: --
511: -- check if person_id value exists in per_all_people_f table
512: hr_utility.set_location('ace p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt, 9999);
513: hr_utility.set_location('p_effective_date = ' || p_effective_date, 9999);
514: l_person_id := p_person_id;
515:
516: -- 5747460: Get COBRA Qualifying Event flag
517: -- If this flag is 'Y' then person record will be checked against effective date

Line 522: hr_utility.set_location('l_cobra_evt_flag = ' || l_cobra_evt_flag, 9999);

518: -- and not lf_evt_dt. This is because COBRA events are generally created prior to person record.
519: open c_cobra_evt_flag;
520: fetch c_cobra_evt_flag into l_cobra_evt_flag;
521: close c_cobra_evt_flag;
522: hr_utility.set_location('l_cobra_evt_flag = ' || l_cobra_evt_flag, 9999);
523: --
524: open c1(l_person_id, l_cobra_evt_flag);
525: --
526: fetch c1 into l_dummy;

Line 538: hr_utility.set_location('ESD of contact at this point : '||l_date,5.5);

534: -- cursor c3 is for debug purpose
535: open c3;
536: fetch c3 into l_date;
537: close c3;
538: hr_utility.set_location('ESD of contact at this point : '||l_date,5.5);
539: open c2(l_cobra_evt_flag);
540: --
541: fetch c2 into l_person_id;
542: if c2%notfound then

Line 548: hr_utility.set_location('p_person_id: '||p_person_id,5.5);

544: -- or per_contact_relationships
545: -- table.
546: --
547: close c2;
548: hr_utility.set_location('p_person_id: '||p_person_id,5.5);
549: ben_ppl_shd.constraint_error('BEN_PTNL_LER_FOR_PER_DT2');
550: --
551: else
552: open c1(l_person_id, l_cobra_evt_flag);

Line 556: hr_utility.set_location('p_person_id: '||p_person_id,5.5);

552: open c1(l_person_id, l_cobra_evt_flag);
553: fetch c1 into l_dummy;
554: if c1%notfound then
555: close c1;
556: hr_utility.set_location('p_person_id: '||p_person_id,5.5);
557: ben_ppl_shd.constraint_error('BEN_PTNL_LER_FOR_PER_DT2');
558: else
559: close c1;
560: end if;

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

565: end if; -- end c1
566: --
567: end if; --end l_api_updating
568: --
569: hr_utility.set_location('Leaving:'||l_proc,10);
570: --
571: End chk_person_id;
572: --
573: -- ----------------------------------------------------------------------------

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

605: l_api_updating boolean;
606: --
607: Begin
608: --
609: hr_utility.set_location('Entering:'||l_proc, 5);
610: --
611: l_api_updating := ben_ppl_shd.api_updating
612: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
613: p_object_version_number => p_object_version_number);

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

635: end if;
636: --
637: end if;
638: --
639: hr_utility.set_location('Leaving:'||l_proc,10);
640: --
641: end chk_ptnl_ler_for_per_src_cd;
642: --
643: -- ----------------------------------------------------------------------------

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

675: l_api_updating boolean;
676: --
677: Begin
678: --
679: hr_utility.set_location('Entering:'||l_proc, 5);
680: --
681: l_api_updating := ben_ppl_shd.api_updating
682: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
683: p_object_version_number => p_object_version_number);

Line 711: hr_utility.set_location('Creation: '||l_proc, 10);

707: --
708: if not l_api_updating
709: and p_ptnl_ler_for_per_stat_cd not in ('DTCTD', 'UNPROCD') then
710: --
711: hr_utility.set_location('Creation: '||l_proc, 10);
712: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
713: fnd_message.raise_error;
714: --
715: elsif l_api_updating

Line 719: hr_utility.set_location('DTCTD: '||l_proc, 10);

715: elsif l_api_updating
716: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'DTCTD'
717: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then
718: --
719: hr_utility.set_location('DTCTD: '||l_proc, 10);
720: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
721: fnd_message.raise_error;
722: --
723: elsif l_api_updating

Line 727: hr_utility.set_location('UNPROCD: '||l_proc, 10);

723: elsif l_api_updating
724: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'UNPROCD'
725: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then
726: --
727: hr_utility.set_location('UNPROCD: '||l_proc, 10);
728: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
729: fnd_message.raise_error;
730: --
731: elsif l_api_updating

Line 735: hr_utility.set_location('VOIDD: '||l_proc, 10);

731: elsif l_api_updating
732: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'VOIDD'
733: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL') then
734: --
735: hr_utility.set_location('VOIDD: '||l_proc, 10);
736: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
737: fnd_message.raise_error;
738: --
739: elsif l_api_updating

Line 743: hr_utility.set_location('PROCD: '||l_proc, 10);

739: elsif l_api_updating
740: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'PROCD'
741: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL','VOIDD') then
742: --
743: hr_utility.set_location('PROCD: '||l_proc, 10);
744: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
745: fnd_message.raise_error;
746: --
747: elsif l_api_updating

Line 751: hr_utility.set_location('MNL: '||l_proc, 10);

747: elsif l_api_updating
748: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'MNL'
749: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','VOIDD','MNLO') then
750: --
751: hr_utility.set_location('MNL: '||l_proc, 10);
752: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
753: fnd_message.raise_error;
754: --
755: end if;

Line 759: hr_utility.set_location('Leaving:'||l_proc,100);

755: end if;
756: --
757: end if;
758: --
759: hr_utility.set_location('Leaving:'||l_proc,100);
760: --
761: end chk_ptnl_ler_for_per_stat_cd;
762: --
763: -- ----------------------------------------------------------------------------

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

811: l_api_updating boolean;
812: --
813: Begin
814: --
815: hr_utility.set_location('Entering:'||l_proc, 5);
816: --
817: if p_ptnl_ler_for_per_stat_cd = 'PROCD' then
818: --
819: -- Check if we can delete the record.

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

835: close c1;
836: --
837: end if;
838: --
839: hr_utility.set_location('Leaving:'||l_proc,10);
840: --
841: return true;
842: --
843: end chk_delete_allowed;

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

883: l_proc varchar2(72) := g_package||'chk_delete_allowed';
884: --
885: Begin
886: --
887: hr_utility.set_location('Entering:'||l_proc, 5);
888: --
889: if p_ptnl_ler_for_per_stat_cd = 'PROCD' and
890: p_procd_dt is null then
891: --

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

923: fnd_message.raise_error;
924: --
925: end if;
926: --
927: hr_utility.set_location('Leaving:'||l_proc,10);
928: --
929: end chk_date_validity;
930: --
931: -- ----------------------------------------------------------------------------

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

936: --
937: l_proc varchar2(72) := g_package||'insert_validate';
938: --
939: Begin
940: hr_utility.set_location('Entering:'||l_proc, 5);
941: --
942: -- Call all supporting business operations
943: --
944: --

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

1004: p_lf_evt_ocrd_dt => p_rec.lf_evt_ocrd_dt,
1005: p_object_version_number => p_rec.object_version_number,
1006: p_ptnl_ler_for_per_stat_cd => p_rec.ptnl_ler_for_per_stat_cd); */
1007:
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009: End insert_validate;
1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< update_validate >----------------------------|

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

1016: --
1017: l_proc varchar2(72) := g_package||'update_validate';
1018: --
1019: Begin
1020: hr_utility.set_location('Entering:'||l_proc, 5);
1021: --
1022: -- Call all supporting business operations
1023: --
1024: --

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

1082: p_lf_evt_ocrd_dt => p_rec.lf_evt_ocrd_dt,
1083: p_object_version_number => p_rec.object_version_number,
1084: p_ptnl_ler_for_per_stat_cd => p_rec.ptnl_ler_for_per_stat_cd); */
1085: --
1086: hr_utility.set_location(' Leaving:'||l_proc, 10);
1087: End update_validate;
1088: --
1089: -- ----------------------------------------------------------------------------
1090: -- |---------------------------< delete_validate >----------------------------|

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

1094: --
1095: l_proc varchar2(72) := g_package||'delete_validate';
1096: --
1097: Begin
1098: hr_utility.set_location('Entering:'||l_proc, 5);
1099: --
1100: -- Call all supporting business operations
1101: --
1102: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1098: hr_utility.set_location('Entering:'||l_proc, 5);
1099: --
1100: -- Call all supporting business operations
1101: --
1102: hr_utility.set_location(' Leaving:'||l_proc, 10);
1103: End delete_validate;
1104: --
1105: --
1106: -- ---------------------------------------------------------------------------

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

1125: l_proc varchar2(72) := g_package||'return_legislation_code';
1126: --
1127: begin
1128: --
1129: hr_utility.set_location('Entering:'|| l_proc, 10);
1130: --
1131: -- Ensure that all the mandatory parameter are not null
1132: --
1133: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1143: close csr_leg_code;
1144: --
1145: -- The primary key is invalid therefore we must error
1146: --
1147: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1148: hr_utility.raise_error;
1149: --
1150: end if;
1151: --

Line 1148: hr_utility.raise_error;

1144: --
1145: -- The primary key is invalid therefore we must error
1146: --
1147: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1148: hr_utility.raise_error;
1149: --
1150: end if;
1151: --
1152: close csr_leg_code;

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

1150: end if;
1151: --
1152: close csr_leg_code;
1153: --
1154: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1155: --
1156: return l_legislation_code;
1157: --
1158: end return_legislation_code;