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

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

179: l_cvg_end_rl number(15);
180: l_step integer;
181: l_effective date;
182: begin
183: hr_utility.set_location(' Entering:'||l_proc,10);
184: ben_prtt_enrt_result_api.determine_dpnt_cvg_dt_cd
185: (p_pgm_id => p_pgm_id
186: ,P_ptip_id => p_ptip_id
187: ,p_pl_id => p_pl_id

Line 196: hr_utility.set_location(' cvg end dt cd :'||l_cvg_end_cd ,10);

192: ,p_cvg_strt_rl => l_cvg_strt_rl
193: ,p_cvg_end_cd => l_cvg_end_cd
194: ,p_cvg_end_rl => l_cvg_end_rl
195: );
196: hr_utility.set_location(' cvg end dt cd :'||l_cvg_end_cd ,10);
197: hr_utility.set_location(' elig chnage dt:'||ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,109);
198: -- tilak 2455430 : I dont think we need the if condition as it is
199: -- only AED and ODBED are avaialble
200: -- for end dt codes This conditon makes the AED calc wrong , get_elig_change_dt return

Line 197: hr_utility.set_location(' elig chnage dt:'||ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,109);

193: ,p_cvg_end_cd => l_cvg_end_cd
194: ,p_cvg_end_rl => l_cvg_end_rl
195: );
196: hr_utility.set_location(' cvg end dt cd :'||l_cvg_end_cd ,10);
197: hr_utility.set_location(' elig chnage dt:'||ben_evaluate_dpnt_elg_profiles.get_elig_change_dt,109);
198: -- tilak 2455430 : I dont think we need the if condition as it is
199: -- only AED and ODBED are avaialble
200: -- for end dt codes This conditon makes the AED calc wrong , get_elig_change_dt return
201: -- Date of birth -1 that is not the AED date but ODBED

Line 207: -- hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,110);

203: --if (l_cvg_end_cd in ('AED','ODBED','AFDEM','ALDEM','AFDFEM','OMFED',
204: -- 'TMFED','30DFLED','TDBED','60DFLED','SDFED','SDBED',
205: -- 'TODFED')) then
206: -- l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
207: -- hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,110);
208: --else
209: ben_determine_date.main
210: (P_DATE_CD => l_cvg_end_cd
211: ,p_formula_id => l_cvg_end_rl -- l_cvg_strt_rl Bug: 3657077; end-date-rule should be passed.

Line 223: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,111);

219: ,P_LF_EVT_OCRD_DT => ben_evaluate_dpnt_elg_profiles.
220: get_elig_change_dt + 1
221: ,P_RETURNED_DATE => l_enrt_cvg_end_dt
222: );
223: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,111);
224: --end if;
225: if l_enrt_cvg_end_dt is null then
226: l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
227: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,112);

Line 227: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,112);

223: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,111);
224: --end if;
225: if l_enrt_cvg_end_dt is null then
226: l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
227: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,112);
228: end if;
229: p_returned_end_dt := l_enrt_cvg_end_dt;
230: hr_utility.set_location(' Leaving:'||l_proc, 70);
231: end calc_dpnt_cvg_end_dt;

Line 230: hr_utility.set_location(' Leaving:'||l_proc, 70);

226: l_enrt_cvg_end_dt:=ben_evaluate_dpnt_elg_profiles.get_elig_change_dt;
227: hr_utility.set_location(' cvg end dt :'||l_enrt_cvg_end_dt ,112);
228: end if;
229: p_returned_end_dt := l_enrt_cvg_end_dt;
230: hr_utility.set_location(' Leaving:'||l_proc, 70);
231: end calc_dpnt_cvg_end_dt;
232: --
233: -- ===========================================================================
234: -- << Procedure: ben_batch_utils.batch_report >>

Line 242: hr_utility.set_location ('Entering '||l_proc,05);

238: l_proc varchar2(80) := g_package||'.submit_all_reports';
239: l_actn varchar2(80);
240: l_request_id number;
241: Begin
242: hr_utility.set_location ('Entering '||l_proc,05);
243: l_actn := 'Calling ben_batch_utils.batch_report (BENDEAUD)...';
244: --
245: If fnd_global.conc_request_id <> -1 then
246: --

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

271: -- ,p_subtitle =>
272: -- 'MANAGE DEFAULT ENROLLMENTS - ERROR DETAIL BY PERSON'
273: );
274: end if;
275: hr_utility.set_location ('Leaving '||l_proc,10);
276: Exception
277: When others then
278: ben_batch_utils.rpt_error(p_proc => l_proc
279: ,p_last_actn => l_actn

Line 350: hr_utility.set_location ('Entering '||l_proc,05);

346: l_parm c_parameter%rowtype;
347: l_commit number;
348: --
349: Begin
350: hr_utility.set_location ('Entering '||l_proc,05);
351: --
352: /*
353: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
354: l_effective_date:=to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR'),'DD/MM/RRRR');

Line 506: hr_utility.set_location ('Leaving '||l_proc,70);

502: l_actn := 'Calling Log_statistics...';
503: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
504: ,p_num_pers_errored => g_persons_errored
505: );
506: hr_utility.set_location ('Leaving '||l_proc,70);
507: Exception
508: When others then
509: ben_batch_utils.rpt_error(p_proc => l_proc
510: ,p_last_actn => l_actn

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

559: l_errbuf varchar2(80);
560: l_retcode number;
561: l_actn varchar2(80);
562: Begin
563: hr_utility.set_location ('Entering '||l_proc,10);
564: --
565: -- get the parameters for a previous run and do a restart
566: --
567: l_actn := 'Getting parameter data...';

Line 603: hr_utility.set_location ('Leaving '||l_proc,70);

599: ,p_legal_entity_id => l_parameters.legal_entity_id
600: ,p_payroll_id => l_parameters.payroll_id
601: ,p_debug_messages => l_parameters.debug_messages_flag
602: );
603: hr_utility.set_location ('Leaving '||l_proc,70);
604: Exception
605: when others then
606: ben_batch_utils.rpt_error(p_proc => l_proc
607: ,p_last_actn => l_actn

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

776: l_commit number;
777: --
778: Begin
779:
780: hr_utility.set_location ('Entering '||l_proc,10);
781:
782: --
783: /*
784: l_effective_date:=to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');

Line 892: hr_utility.set_location('person_id='||to_char(l_person_id),999);

888: fetch c_person into l_person_id,l_part_person_id;
889: Exit when c_person%notfound;
890: l_cnt := l_cnt + 1;
891: l_actn := 'Calling ben_batch_utils.person_selection_rule...';
892: hr_utility.set_location('person_id='||to_char(l_person_id),999);
893: --
894: -- if p_person_selection_rule_id is pass, test rule.
895: -- If the rule return 'N' then
896: -- Bug 5662220: If the rule doesnt return 'Y' or 'N' then also skip the person

Line 1058: hr_utility.set_location ('Leaving '||l_proc,70);

1054: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1055: ,p_person_selected => l_person_cnt
1056: ,p_business_group_id => p_business_group_id);
1057: submit_all_reports;
1058: hr_utility.set_location ('Leaving '||l_proc,70);
1059: --
1060: Exception
1061: when others then
1062: ben_batch_utils.rpt_error(p_proc => l_proc

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

1125: l_organization_id number;
1126: l_step integer;
1127: begin
1128: l_step := 10;
1129: hr_utility.set_location ('Entering '||l_proc,10);
1130: --
1131: -- Get assignment ID,organization_id form per_assignments_f table.
1132: --
1133: open c1;

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

1187: fnd_message.set_token('PROC',l_proc);
1188: raise ben_maintain_designee_elig.g_record_error;
1189: end if;
1190: return l_return;
1191: hr_utility.set_location ('Leaving '||l_proc,10);
1192: exception
1193: when others then
1194: ben_batch_utils.rpt_error(p_proc => l_proc,
1195: p_last_actn => 'Step = '||to_char(l_step),p_rpt_flag => TRUE);

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

1404: l_egd_elig_thru_dt date; -- 5100008
1405:
1406: --
1407: begin
1408: hr_utility.set_location ('Entering '|| l_proc,10);
1409: l_actn := 'Initializing...';
1410: Savepoint process_default_enrt_savepoint;
1411: --
1412: -- Cache person data and write personal data into cache.

Line 1424: hr_utility.set_location(l_proc,101);

1420: --
1421: l_actn := 'Calling ben_batch_utils.ini(COMP_OBJ)...';
1422: ben_batch_utils.ini('COMP_OBJ');
1423: For l_rec in c_designation loop
1424: hr_utility.set_location(l_proc,101);
1425:
1426: l_returned_end_dt:=null;
1427:
1428: if l_rec.oipl_id is not null then

Line 1448: hr_utility.set_location(l_proc,102);

1444: -- Note: pgm_id and pl_id args already checked in the cursor
1445: --
1446: l_rule_ret:='Y';
1447: if p_comp_selection_rl is not null then
1448: hr_utility.set_location(l_proc,102);
1449: l_rule_ret:=comp_selection_rule(
1450: p_person_id => p_person_id
1451: ,p_business_group_id => p_business_group_id
1452: ,p_pgm_id => l_rec.pgm_id

Line 1462: hr_utility.set_location(l_proc,103);

1458: ,p_comp_selection_rule_id => p_comp_selection_rl
1459: ,p_effective_date => p_effective_date
1460: );
1461: end if;
1462: hr_utility.set_location(l_proc,103);
1463: if l_rule_ret='Y' then
1464: hr_utility.set_location(l_proc,104);
1465: --
1466: -- Check to see if the dependent is still eligible

Line 1464: hr_utility.set_location(l_proc,104);

1460: );
1461: end if;
1462: hr_utility.set_location(l_proc,103);
1463: if l_rule_ret='Y' then
1464: hr_utility.set_location(l_proc,104);
1465: --
1466: -- Check to see if the dependent is still eligible
1467: --
1468: hr_utility.set_location('contact_person_id='||to_char(p_person_id),1100);

Line 1468: hr_utility.set_location('contact_person_id='||to_char(p_person_id),1100);

1464: hr_utility.set_location(l_proc,104);
1465: --
1466: -- Check to see if the dependent is still eligible
1467: --
1468: hr_utility.set_location('contact_person_id='||to_char(p_person_id),1100);
1469: hr_utility.set_location('oipl_id='||to_char(l_rec.oipl_id),1100);
1470: hr_utility.set_location('ptip_id='||to_char(l_rec.ptip_id),1100);
1471: hr_utility.set_location('pl_id='||to_char(l_rec.pl_id),1100);
1472: hr_utility.set_location('pgm_id='||to_char(l_rec.pgm_id),1100);

Line 1469: hr_utility.set_location('oipl_id='||to_char(l_rec.oipl_id),1100);

1465: --
1466: -- Check to see if the dependent is still eligible
1467: --
1468: hr_utility.set_location('contact_person_id='||to_char(p_person_id),1100);
1469: hr_utility.set_location('oipl_id='||to_char(l_rec.oipl_id),1100);
1470: hr_utility.set_location('ptip_id='||to_char(l_rec.ptip_id),1100);
1471: hr_utility.set_location('pl_id='||to_char(l_rec.pl_id),1100);
1472: hr_utility.set_location('pgm_id='||to_char(l_rec.pgm_id),1100);
1473: hr_utility.set_location('contact_relationship_id_id='||to_char(l_rec.contact_relationship_id),1100);

Line 1470: hr_utility.set_location('ptip_id='||to_char(l_rec.ptip_id),1100);

1466: -- Check to see if the dependent is still eligible
1467: --
1468: hr_utility.set_location('contact_person_id='||to_char(p_person_id),1100);
1469: hr_utility.set_location('oipl_id='||to_char(l_rec.oipl_id),1100);
1470: hr_utility.set_location('ptip_id='||to_char(l_rec.ptip_id),1100);
1471: hr_utility.set_location('pl_id='||to_char(l_rec.pl_id),1100);
1472: hr_utility.set_location('pgm_id='||to_char(l_rec.pgm_id),1100);
1473: hr_utility.set_location('contact_relationship_id_id='||to_char(l_rec.contact_relationship_id),1100);
1474: --

Line 1471: hr_utility.set_location('pl_id='||to_char(l_rec.pl_id),1100);

1467: --
1468: hr_utility.set_location('contact_person_id='||to_char(p_person_id),1100);
1469: hr_utility.set_location('oipl_id='||to_char(l_rec.oipl_id),1100);
1470: hr_utility.set_location('ptip_id='||to_char(l_rec.ptip_id),1100);
1471: hr_utility.set_location('pl_id='||to_char(l_rec.pl_id),1100);
1472: hr_utility.set_location('pgm_id='||to_char(l_rec.pgm_id),1100);
1473: hr_utility.set_location('contact_relationship_id_id='||to_char(l_rec.contact_relationship_id),1100);
1474: --
1475: if l_rec.pgm_id is not null then

Line 1472: hr_utility.set_location('pgm_id='||to_char(l_rec.pgm_id),1100);

1468: hr_utility.set_location('contact_person_id='||to_char(p_person_id),1100);
1469: hr_utility.set_location('oipl_id='||to_char(l_rec.oipl_id),1100);
1470: hr_utility.set_location('ptip_id='||to_char(l_rec.ptip_id),1100);
1471: hr_utility.set_location('pl_id='||to_char(l_rec.pl_id),1100);
1472: hr_utility.set_location('pgm_id='||to_char(l_rec.pgm_id),1100);
1473: hr_utility.set_location('contact_relationship_id_id='||to_char(l_rec.contact_relationship_id),1100);
1474: --
1475: if l_rec.pgm_id is not null then
1476: --

Line 1473: hr_utility.set_location('contact_relationship_id_id='||to_char(l_rec.contact_relationship_id),1100);

1469: hr_utility.set_location('oipl_id='||to_char(l_rec.oipl_id),1100);
1470: hr_utility.set_location('ptip_id='||to_char(l_rec.ptip_id),1100);
1471: hr_utility.set_location('pl_id='||to_char(l_rec.pl_id),1100);
1472: hr_utility.set_location('pgm_id='||to_char(l_rec.pgm_id),1100);
1473: hr_utility.set_location('contact_relationship_id_id='||to_char(l_rec.contact_relationship_id),1100);
1474: --
1475: if l_rec.pgm_id is not null then
1476: --
1477: open c_dpnt_dsgn_lvl(l_rec.pgm_id);

Line 1507: hr_utility.set_location(l_proc,105);

1503: p_dpnt_inelig_rsn_cd => l_inelig_rsn_cd);
1504: --
1505: -- If the dependent is not eligible end date row
1506: --
1507: hr_utility.set_location(l_proc,105);
1508: hr_utility.set_location('l_elig_flag'||l_elig_flag,8888);
1509: --
1510: if l_elig_flag<>'Y' then
1511: --

Line 1508: hr_utility.set_location('l_elig_flag'||l_elig_flag,8888);

1504: --
1505: -- If the dependent is not eligible end date row
1506: --
1507: hr_utility.set_location(l_proc,105);
1508: hr_utility.set_location('l_elig_flag'||l_elig_flag,8888);
1509: --
1510: if l_elig_flag<>'Y' then
1511: --
1512: hr_utility.set_location(l_proc,106);

Line 1512: hr_utility.set_location(l_proc,106);

1508: hr_utility.set_location('l_elig_flag'||l_elig_flag,8888);
1509: --
1510: if l_elig_flag<>'Y' then
1511: --
1512: hr_utility.set_location(l_proc,106);
1513: --
1514: -- 5100008 : Added this to fetch EGD ELIG_THRU_DT
1515: if (l_rec.date_end <= p_effective_date) then
1516: l_egd_elig_thru_dt := l_rec.date_end;

Line 1525: hr_utility.set_location('SARKAR l_rec.ovrdn_flag '||l_rec.ovrdn_flag,8888);

1521:
1522: --
1523: -- Get the dpnt cvg end date
1524: -- Bug 5442301 -- dont update cvg_thru date if it is overriden
1525: hr_utility.set_location('SARKAR l_rec.ovrdn_flag '||l_rec.ovrdn_flag,8888);
1526: hr_utility.set_location('SARKAR l_rec.ovrdn_thru_dt '||l_rec.ovrdn_thru_dt,8888);
1527:
1528: -- 14552686 - when dependent enrollment record(other than coverage thru date) is
1529: -- overrided through enrollment override form then dependent coverage

Line 1526: hr_utility.set_location('SARKAR l_rec.ovrdn_thru_dt '||l_rec.ovrdn_thru_dt,8888);

1522: --
1523: -- Get the dpnt cvg end date
1524: -- Bug 5442301 -- dont update cvg_thru date if it is overriden
1525: hr_utility.set_location('SARKAR l_rec.ovrdn_flag '||l_rec.ovrdn_flag,8888);
1526: hr_utility.set_location('SARKAR l_rec.ovrdn_thru_dt '||l_rec.ovrdn_thru_dt,8888);
1527:
1528: -- 14552686 - when dependent enrollment record(other than coverage thru date) is
1529: -- overrided through enrollment override form then dependent coverage
1530: -- is not ending though the dependent became ineligible.

Line 1584: hr_utility.set_location('pdp_id='||to_char(l_rec.elig_cvrd_dpnt_id),111);

1580: l_returned_end_dt := p_effective_date;
1581: --
1582: end if;
1583: --
1584: hr_utility.set_location('pdp_id='||to_char(l_rec.elig_cvrd_dpnt_id),111);
1585: hr_utility.set_location('cvg_thru_dt='||to_char(l_returned_end_dt),112);
1586: -- -- Bug 5442301 -- dont update cvg_thru date if it is overriden
1587:
1588: -- 14552686 - when dependent enrollment record(other than coverage thru date) is

Line 1585: hr_utility.set_location('cvg_thru_dt='||to_char(l_returned_end_dt),112);

1581: --
1582: end if;
1583: --
1584: hr_utility.set_location('pdp_id='||to_char(l_rec.elig_cvrd_dpnt_id),111);
1585: hr_utility.set_location('cvg_thru_dt='||to_char(l_returned_end_dt),112);
1586: -- -- Bug 5442301 -- dont update cvg_thru date if it is overriden
1587:
1588: -- 14552686 - when dependent enrollment record(other than coverage thru date) is
1589: -- overrided through enrollment override form then dependent coverage

Line 1755: hr_utility.set_location(l_proc,107);

1751: g_designations_ended:=g_designations_ended+1;
1752: l_person_ended:='Y';
1753: l_this_person_ended:='Y';
1754: else
1755: hr_utility.set_location(l_proc,107);
1756: g_designations_remaining:=g_designations_remaining+1;
1757: end if;
1758: hr_utility.set_location(l_proc,108);
1759: --

Line 1758: hr_utility.set_location(l_proc,108);

1754: else
1755: hr_utility.set_location(l_proc,107);
1756: g_designations_remaining:=g_designations_remaining+1;
1757: end if;
1758: hr_utility.set_location(l_proc,108);
1759: --
1760: end if;
1761: --
1762: -- write the audit info for this

Line 1784: hr_utility.set_location(l_proc,109);

1780: l_cache(l_cache_cnt).contact_type:=l_rec.contact_type;
1781: l_cache(l_cache_cnt).dpnt_cvg_strt_dt:=l_rec.cvg_strt_dt;
1782: l_cache(l_cache_cnt).dpnt_cvg_thru_dt:=l_returned_end_dt;
1783: --
1784: hr_utility.set_location(l_proc,109);
1785: --
1786: end loop;
1787: --
1788: if l_comp_ineligible then

Line 1804: hr_utility.set_location(l_proc,110);

1800: );
1801: --
1802: end if;
1803: --
1804: hr_utility.set_location(l_proc,110);
1805: l_actn := 'Calling Ben_batch_utils.write_comp...';
1806: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1807: ,p_effective_date => p_effective_date
1808: );

Line 1818: hr_utility.set_location('g_profile_value = '||g_profile_value,100);

1814: -- Store the participant Id on the related_person_id so that
1815: -- may get participant counts for summary report
1816: --
1817: ben_batch_utils.g_rec.related_person_id:=l_part_person_id;
1818: hr_utility.set_location('g_profile_value = '||g_profile_value,100);
1819: if l_person_ended='Y' then
1820: Ben_batch_utils.write_rec(p_typ_cd => 'DSGENDED');
1821: else
1822: --

Line 1840: hr_utility.set_location(l_proc||' pgm_id='||to_char(l_cache(i).pgm_id),111);

1836: -- ben_batch_dpnt_info if the g_profile_value set to "No". This is
1837: -- done for improving the performance of audit log
1838: --
1839: For i in 1..l_cache_cnt Loop
1840: hr_utility.set_location(l_proc||' pgm_id='||to_char(l_cache(i).pgm_id),111);
1841: if((l_cache(i).actn_cd = 'ENDED')
1842: or (l_cache(i).actn_cd = 'NOCHG'
1843: and nvl(g_profile_value, 'Y') = 'Y')) then
1844: ben_batch_dpnt_info_api.create_batch_dpnt_info

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

1872: );
1873: End if;
1874: g_persons_processed := g_persons_processed + 1;
1875: commit;
1876: hr_utility.set_location ('Leaving '|| l_proc,10);
1877: Exception
1878: When others then
1879: rollback to process_default_enrt_savepoint;
1880: g_persons_errored := g_persons_errored + 1;