DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on HR_UTILITY

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

89: l_proc varchar2(80) := g_package || '.write_person_category';
90: --
91: begin
92: --
93: hr_utility.set_location ('Entering ' || l_proc, 05);
94: --
95: if p_error then
96: --
97: if p_audit_log = 'Y' then

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

245: end loop;
246: --
247: end if;
248: --
249: hr_utility.set_location ('Leaving '||l_proc,10);
250: --
251: exception
252: --
253: when others then

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

277: l_pl_name ben_pl_f.name%TYPE; -- UTF8 varchar2(80);
278: --
279: begin
280: --
281: hr_utility.set_location ('Entering '||l_proc,05);
282: --
283: if p_cnt > 0 then
284: --
285: ben_batch_utils.write

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

330: end loop;
331: --
332: end if;
333: --
334: hr_utility.set_location ('Leaving ' || l_proc, 10);
335: --
336: end write_pil_elctbl_popl;
337: --
338: -- -----------------------------------------------------------------------------

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

348: l_request_id number;
349: --
350: begin
351: --
352: hr_utility.set_location ('Entering '||l_proc,05);
353: --
354: if fnd_global.conc_request_id <> -1 then
355: --
356: if upper(p_audit_log) = 'Y' then

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

382: ,p_report_type => 'ERROR_BY_PERSON');
383: --
384: end if;
385: --
386: hr_utility.set_location ('Leaving '||l_proc,10);
387: --
388: exception
389: --
390: when others then

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

428: l_voidd_dt date;
429: --
430: begin
431: --
432: hr_utility.set_location('Entering '||l_proc,10);
433: --
434: l_object_version_number := p_object_version_number;
435: --
436: -- No updates need to be done when the status code

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

472: benutils.update_life_event_cache(p_open_and_closed => 'N');
473: --
474: end if;
475: --
476: hr_utility.set_location('Leaving:'||l_proc, 10);
477: --
478: exception
479: --
480: when others then

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

692: l_auto_flag boolean := FALSE; --Bug 6144967
693: --
694: begin
695: --
696: hr_utility.set_location ('Entering '||l_proc,10);
697: --
698: -- Make sure all the mandatory input parameters are not null
699: --
700: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 829: hr_utility.set_location('p_close_cd is : ' || p_close_cd, 5);

825: --
826: -- PB : When open enrollment called from authentication form if a active
827: -- life event exists and PSR opts closure of the active life event.
828: --
829: hr_utility.set_location('p_close_cd is : ' || p_close_cd, 5);
830: --
831: if p_close_cd = 'PRPENDTR' then
832: --
833: open c_get_pending_approvals;

Line 868: hr_utility.set_location('Defaults will be assigned', 5);

864: l_rec.dflt_asnd_dt is null and
865: not l_pend_approvals
866: then
867: --
868: hr_utility.set_location('Defaults will be assigned', 5);
869: --
870: l_dflt_flag := TRUE;
871: l_set_pel_stat_cd := TRUE;
872: --

Line 874: hr_utility.set_location('Elections have been made or Defaults ' ||

870: l_dflt_flag := TRUE;
871: l_set_pel_stat_cd := TRUE;
872: --
873: else
874: hr_utility.set_location('Elections have been made or Defaults ' ||
875: 'assigned or No Defaults required', 5);
876: --
877: l_set_pel_stat_cd := TRUE;
878: --

Line 883: hr_utility.set_location('cls_enrt_dt_to_use_cd is ELCNSMADE', 10);

879: end if;
880: --
881: elsif l_rec.cls_enrt_dt_to_use_cd = 'ELCNSMADE' then
882: --
883: hr_utility.set_location('cls_enrt_dt_to_use_cd is ELCNSMADE', 10);
884: --
885: if l_rec.elcns_made_dt is not NULL then
886: --
887: hr_utility.set_location('Elections have been made', 10);

Line 887: hr_utility.set_location('Elections have been made', 10);

883: hr_utility.set_location('cls_enrt_dt_to_use_cd is ELCNSMADE', 10);
884: --
885: if l_rec.elcns_made_dt is not NULL then
886: --
887: hr_utility.set_location('Elections have been made', 10);
888: --
889: l_set_pel_stat_cd := TRUE;
890: --
891: elsif l_rec.procg_end_dt is not null and

Line 896: hr_utility.set_location('Elections not made. procg_end_dt reached', 10);

892: l_rec.procg_end_dt <= p_effective_date then
893: --
894: -- Elections not made. Processing end date reached.
895: --
896: hr_utility.set_location('Elections not made. procg_end_dt reached', 10);
897: --
898: if l_rec.dflt_asnd_dt is not null then
899: --
900: -- The defaults have been assigned to the enrollment.

Line 902: hr_utility.set_location('Defaults assigned.', 10);

898: if l_rec.dflt_asnd_dt is not null then
899: --
900: -- The defaults have been assigned to the enrollment.
901: --
902: hr_utility.set_location('Defaults assigned.', 10);
903: --
904: l_set_pel_stat_cd := TRUE;
905: --
906: else

Line 910: hr_utility.set_location('Defaults not assigned.', 10);

906: else
907: --
908: -- Processing end date reached. Defaults not asigned.
909: --
910: hr_utility.set_location('Defaults not assigned.', 10);
911: --
912: if l_rec.dflt_enrt_dt is not null and
913: l_rec.dflt_enrt_dt <= p_effective_date then
914: --

Line 915: hr_utility.set_location('Defaults will be assigned', 10);

911: --
912: if l_rec.dflt_enrt_dt is not null and
913: l_rec.dflt_enrt_dt <= p_effective_date then
914: --
915: hr_utility.set_location('Defaults will be assigned', 10);
916: --
917: l_dflt_flag := TRUE;
918: l_set_pel_stat_cd := TRUE;
919: --

Line 924: hr_utility.set_location('No action needed.', 10);

920: elsif l_rec.dflt_enrt_dt is NULL then
921: --
922: -- This comp-object does not need to be defaulted.
923: --
924: hr_utility.set_location('No action needed.', 10);
925: --
926: l_set_pel_stat_cd := TRUE;
927: --
928: end if;

Line 936: hr_utility.set_location('cls_enrt_dt_to_use_cd is ENRTPERDEND', 10);

932: end if;
933: --
934: elsif l_rec.cls_enrt_dt_to_use_cd = 'ENRTPERDEND' then
935: --
936: hr_utility.set_location('cls_enrt_dt_to_use_cd is ENRTPERDEND', 10);
937: --
938: if l_rec.enrt_perd_end_dt is not null and
939: l_rec.enrt_perd_end_dt <= p_effective_date then
940: --

Line 941: hr_utility.set_location('Enrt perd over', 10);

937: --
938: if l_rec.enrt_perd_end_dt is not null and
939: l_rec.enrt_perd_end_dt <= p_effective_date then
940: --
941: hr_utility.set_location('Enrt perd over', 10);
942: --
943: if l_rec.elcns_made_dt is not Null or
944: l_rec.dflt_asnd_dt is not null then
945: --

Line 946: hr_utility.set_location('Enrt end dt reached. Either elections ' ||

942: --
943: if l_rec.elcns_made_dt is not Null or
944: l_rec.dflt_asnd_dt is not null then
945: --
946: hr_utility.set_location('Enrt end dt reached. Either elections ' ||
947: 'have been made or enrt defaulted', 10);
948: --
949: l_set_pel_stat_cd := TRUE;
950: --

Line 954: hr_utility.set_location('No defaults yet. Assigning defaults', 10);

950: --
951: elsif l_rec.dflt_enrt_dt is not null and
952: l_rec.dflt_enrt_dt <= p_effective_date then
953: --
954: hr_utility.set_location('No defaults yet. Assigning defaults', 10);
955: --
956: l_dflt_flag := TRUE;
957: l_set_pel_stat_cd := TRUE;
958: --

Line 963: hr_utility.set_location('No action needed.', 10);

959: elsif l_rec.dflt_enrt_dt is NULL then
960: --
961: -- This comp-object does not need to be defaulted.
962: --
963: hr_utility.set_location('No action needed.', 10);
964: --
965: l_set_pel_stat_cd := TRUE;
966: --
967: end if;

Line 971: hr_utility.set_location('enrt_perd_end date is NULL', 10);

967: end if;
968: --
969: elsif l_rec.enrt_perd_end_dt is NULL then
970: --
971: hr_utility.set_location('enrt_perd_end date is NULL', 10);
972: --
973: fnd_message.set_name('BEN','BEN_91903_ENRT_PERD_END_DT_NUL');
974: fnd_message.set_token('PROC',l_proc);
975: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

Line 987: hr_utility.set_location('cls_enrt_dt_to_use_cd is PROCGEND', 10);

983: end if;
984: --
985: elsif l_rec.cls_enrt_dt_to_use_cd = 'PROCGEND' then
986: --
987: hr_utility.set_location('cls_enrt_dt_to_use_cd is PROCGEND', 10);
988: --
989: if l_rec.procg_end_dt is not null and
990: l_rec.procg_end_dt <= p_effective_date then
991: --

Line 992: hr_utility.set_location('Processing end date reached.', 10);

988: --
989: if l_rec.procg_end_dt is not null and
990: l_rec.procg_end_dt <= p_effective_date then
991: --
992: hr_utility.set_location('Processing end date reached.', 10);
993: --
994: if l_rec.elcns_made_dt is not null or
995: l_rec.dflt_asnd_dt is not null then
996: --

Line 998: hr_utility.set_location('Enrt end dt reached. Either elections ' ||

994: if l_rec.elcns_made_dt is not null or
995: l_rec.dflt_asnd_dt is not null then
996: --
997: --
998: hr_utility.set_location('Enrt end dt reached. Either elections ' ||
999: 'have been made or enrt defaulted', 10);
1000: --
1001: l_set_pel_stat_cd := TRUE;
1002: --

Line 1006: hr_utility.set_location('No defaults yet. Assigning defaults', 10);

1002: --
1003: elsif l_rec.dflt_enrt_dt is not NULL and
1004: l_rec.dflt_enrt_dt <= p_effective_date then
1005: --
1006: hr_utility.set_location('No defaults yet. Assigning defaults', 10);
1007: --
1008: l_dflt_flag := TRUE;
1009: l_set_pel_stat_cd := TRUE;
1010: --

Line 1015: hr_utility.set_location('No action needed', 10);

1011: elsif (l_rec.dflt_enrt_dt is NULL) then
1012: --
1013: -- This comp-object does not need to be defaulted.
1014: --
1015: hr_utility.set_location('No action needed', 10);
1016: --
1017: l_set_pel_stat_cd := TRUE;
1018: --
1019: end if;

Line 1023: hr_utility.set_location('Processing end date is null', 10);

1019: end if;
1020: --
1021: elsif l_rec.procg_end_dt is null then
1022: --
1023: hr_utility.set_location('Processing end date is null', 10);
1024: --
1025: fnd_message.set_name('BEN','BEN_91904_PROCG_END_DT_NULL');
1026: fnd_message.set_token('PROC',l_proc);
1027: fnd_message.set_token('PIL_ELCTBL_CHC_POPL_ID',

Line 1039: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);

1035: end if;
1036: --
1037: else
1038: --
1039: hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
1040: --
1041: fnd_message.set_name('BEN','BEN_91905_INVLD_CLS_ENRT_DT_CD');
1042: fnd_message.set_token('PROC',l_proc);
1043: fnd_message.set_token('CLS_ENRT_DT_TO_USE_CD',

Line 1053: hr_utility.set_location('Setting pil_elcbl_chc_popl_stat to PROCD', 10);

1049: end if;
1050: --
1051: if l_set_pel_stat_cd = TRUE then
1052: --
1053: hr_utility.set_location('Setting pil_elcbl_chc_popl_stat to PROCD', 10);
1054: --
1055:
1056: --Start Bug 6144967
1057:

Line 1118: hr_utility.set_location('Assign defaults', 10);

1114: end if;
1115: --
1116: if l_dflt_flag = TRUE then
1117: --
1118: hr_utility.set_location('Assign defaults', 10);
1119: --
1120: -- Bug 5407755
1121: -- Close enrollment date = nvl ( ( 'Defaults will be assigned on',
1122: -- OR 'Days after Enrollment Period to Apply Defaults'

Line 1133: hr_utility.set_location('ACE l_Dflt_enrt_Date = ' || l_Dflt_enrt_Date, 9999);

1129: if l_dflt_enrt_Date is null or p_close_cd = 'FORCE'
1130: then
1131: l_dflt_enrt_date := p_effective_date;
1132: end if;
1133: hr_utility.set_location('ACE l_Dflt_enrt_Date = ' || l_Dflt_enrt_Date, 9999);
1134: ben_manage_default_enrt.default_comp_obj
1135: (p_validate => FALSE
1136: ,p_per_in_ler_id => p_per_in_ler_id
1137: ,p_person_id => l_person_id

Line 1161: hr_utility.set_location('l_set_pil_stat_cd = ' || 'FALSE' , 9999);

1157: open c_chk_epe_exists;
1158: fetch c_chk_epe_exists into l_chk_epe_exists;
1159: close c_chk_epe_exists;
1160: --
1161: hr_utility.set_location('l_set_pil_stat_cd = ' || 'FALSE' , 9999);
1162: hr_utility.set_location('l_pec_cnt = ' || to_char(l_pec_cnt), 9999);
1163: hr_utility.set_location('ELIG_PER_ELCTBL_CHC_ID = ' || l_chk_epe_exists.ELIG_PER_ELCTBL_CHC_ID, 9999);
1164: hr_utility.set_location('l_pil_stat_cd = ' || l_pil_stat_cd, 9999);
1165: --

Line 1162: hr_utility.set_location('l_pec_cnt = ' || to_char(l_pec_cnt), 9999);

1158: fetch c_chk_epe_exists into l_chk_epe_exists;
1159: close c_chk_epe_exists;
1160: --
1161: hr_utility.set_location('l_set_pil_stat_cd = ' || 'FALSE' , 9999);
1162: hr_utility.set_location('l_pec_cnt = ' || to_char(l_pec_cnt), 9999);
1163: hr_utility.set_location('ELIG_PER_ELCTBL_CHC_ID = ' || l_chk_epe_exists.ELIG_PER_ELCTBL_CHC_ID, 9999);
1164: hr_utility.set_location('l_pil_stat_cd = ' || l_pil_stat_cd, 9999);
1165: --
1166: -- Third OR condition is for all PEL in PROCD and PIL in STRTD

Line 1163: hr_utility.set_location('ELIG_PER_ELCTBL_CHC_ID = ' || l_chk_epe_exists.ELIG_PER_ELCTBL_CHC_ID, 9999);

1159: close c_chk_epe_exists;
1160: --
1161: hr_utility.set_location('l_set_pil_stat_cd = ' || 'FALSE' , 9999);
1162: hr_utility.set_location('l_pec_cnt = ' || to_char(l_pec_cnt), 9999);
1163: hr_utility.set_location('ELIG_PER_ELCTBL_CHC_ID = ' || l_chk_epe_exists.ELIG_PER_ELCTBL_CHC_ID, 9999);
1164: hr_utility.set_location('l_pil_stat_cd = ' || l_pil_stat_cd, 9999);
1165: --
1166: -- Third OR condition is for all PEL in PROCD and PIL in STRTD
1167: --

Line 1164: hr_utility.set_location('l_pil_stat_cd = ' || l_pil_stat_cd, 9999);

1160: --
1161: hr_utility.set_location('l_set_pil_stat_cd = ' || 'FALSE' , 9999);
1162: hr_utility.set_location('l_pec_cnt = ' || to_char(l_pec_cnt), 9999);
1163: hr_utility.set_location('ELIG_PER_ELCTBL_CHC_ID = ' || l_chk_epe_exists.ELIG_PER_ELCTBL_CHC_ID, 9999);
1164: hr_utility.set_location('l_pil_stat_cd = ' || l_pil_stat_cd, 9999);
1165: --
1166: -- Third OR condition is for all PEL in PROCD and PIL in STRTD
1167: --
1168: if l_pec_cnt <> 0

Line 1188: hr_utility.set_location('PEL not processed. ' ||

1184: -- FALSE so that the per_in_ler is not closed.
1185: --
1186: if l_pec_rec(i).set_flag = 'N' then
1187: --
1188: hr_utility.set_location('PEL not processed. ' ||
1189: 'Cannot set per_in_ler status to PROCD', 10);
1190: --
1191: l_set_pil_stat_cd := FALSE;
1192: --

Line 1207: hr_utility.set_location('set_pil_stat_cd flag is TRUE', 10);

1203: -- All pel_elctbl_chc records have been processed. We can set per_in_ler.
1204: -- Loop through enrollments for which the prtt is no longer eligible and
1205: -- haven't been closed yet.
1206: --
1207: hr_utility.set_location('set_pil_stat_cd flag is TRUE', 10);
1208: --
1209: for rslt in c_no_lngr_elig
1210: loop
1211: --

Line 1256: hr_utility.set_location('End date cd not WEM. Deleting enrt', 10);

1252: if nvl(l_enrt_cvg_end_dt_cd, '-1') <> 'WEM' then
1253: --
1254: -- The end date code is not 'when elections made'. Delete enrt.
1255: --
1256: hr_utility.set_location('End date cd not WEM. Deleting enrt', 10);
1257: --
1258: ben_prtt_enrt_result_api.delete_enrollment
1259: (p_validate => p_validate
1260: ,p_per_in_ler_id => p_per_in_ler_id

Line 1279: hr_utility.set_location ('effectiv_date=' ||

1275: -- Close unresolved actn items.
1276: --
1277: if p_close_uneai_flag='Y' then
1278: --
1279: hr_utility.set_location ('effectiv_date=' ||
1280: to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS'), 05);
1281: --
1282: hr_utility.set_location ('uneai_effectiv_date=' ||
1283: to_char(p_uneai_effective_date,'YYYY/MM/DD HH24:MI:SS'), 05);

Line 1282: hr_utility.set_location ('uneai_effectiv_date=' ||

1278: --
1279: hr_utility.set_location ('effectiv_date=' ||
1280: to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS'), 05);
1281: --
1282: hr_utility.set_location ('uneai_effectiv_date=' ||
1283: to_char(p_uneai_effective_date,'YYYY/MM/DD HH24:MI:SS'), 05);
1284: --
1285: ben_cls_unresolved_actn_item.cls_per_unresolved_actn_item
1286: (p_person_id => l_person_id

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

1379: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1380: --
1381: end if;
1382: --
1383: hr_utility.set_location('Leaving:'||l_proc, 10);
1384: --
1385: exception
1386: --
1387: when others then

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

1528: -- end bug 3079317
1529:
1530: begin
1531: --
1532: hr_utility.set_location ('Entering '||l_proc,10);
1533: --
1534: /*
1535: l_effective_date := to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
1536: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR')

Line 1616: hr_utility.set_location('Updated range ' || to_char(l_range_id) ||

1612: update ben_batch_ranges ran
1613: set ran.range_status_cd = 'P'
1614: where ran.range_id = l_range_id;
1615: --
1616: hr_utility.set_location('Updated range ' || to_char(l_range_id) ||
1617: ' status code to P', 10);
1618: --
1619: commit;
1620: --

Line 1629: hr_utility.set_location('Load person actions into the cache', 10);

1625: open c_person_thread;
1626: --
1627: l_record_number := 0;
1628: --
1629: hr_utility.set_location('Load person actions into the cache', 10);
1630: --
1631: loop
1632: --
1633: fetch c_person_thread into

Line 1660: hr_utility.set_location('Closing Enrollment for ' ||

1656: --
1657: for l_cnt in 1..l_record_number
1658: loop
1659: --
1660: hr_utility.set_location('Closing Enrollment for ' ||
1661: to_char(g_cache_per_proc(l_cnt).person_id), 10);
1662: --
1663: begin
1664: --

Line 1726: hr_utility.set_location('No records found. Erroring out.', 10);

1722: end loop;
1723: --
1724: else
1725: --
1726: hr_utility.set_location('No records found. Erroring out.', 10);
1727: --
1728: l_actn := 'Reporting error since there is no record found';
1729: --
1730: fnd_message.set_name('BEN','BEN_91906_PER_NOT_FND_IN_RNG');

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

1750: --
1751: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
1752: ,p_num_pers_errored => g_persons_errored);
1753: --
1754: hr_utility.set_location ('Leaving '||l_proc,70);
1755: --
1756: exception
1757: --
1758: when others then

Line 1763: hr_utility.set_location('BENCLENR Super Error ' || l_proc, 10);

1759: --
1760: rollback;
1761: benutils.write(p_text => sqlerrm);
1762: --
1763: hr_utility.set_location('BENCLENR Super Error ' || l_proc, 10);
1764: --
1765: ben_batch_utils.rpt_error(p_proc => l_proc
1766: ,p_last_actn => l_actn
1767: ,p_rpt_flag => TRUE);

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

1823: l_proc varchar2(80) := g_package||'.restart';
1824: --
1825: begin
1826: --
1827: hr_utility.set_location ('Entering '||l_proc,10);
1828: --
1829: -- get the parameters for a previous run and do a restart
1830: --
1831: open c_parameters;

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

1864: ,p_close_uneai_flag => l_parameters.close_uneai_flag
1865: ,p_close_cd => l_parameters.mode_cd -- 1674123
1866: ,p_uneai_effective_date => l_parameters.uneai_effective_date);
1867: --
1868: hr_utility.set_location ('Leaving '||l_proc,70);
1869: --
1870: end restart;
1871: --
1872: -- -----------------------------------------------------------------------------

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

2008: l_pilid_va g_number_table := g_number_table();
2009:
2010: begin
2011: --
2012: hr_utility.set_location ('Entering ' || l_proc, 10);
2013: -- Bug 5857493
2014: if p_audit_log ='Y' then
2015: ben_batch_utils.g_audit_flag := true;
2016: else

Line 2275: hr_utility.set_location('Restarting for benefit action id : ' ||

2271: -- for restarting.
2272: --
2273: l_benefit_action_id := p_benefit_action_id;
2274: --
2275: hr_utility.set_location('Restarting for benefit action id : ' ||
2276: to_char(l_benefit_action_id), 10);
2277: --
2278: ben_batch_utils.create_restart_person_actions
2279: (p_benefit_action_id => p_benefit_action_id

Line 2295: hr_utility.set_location('More than one range got created.', 10);

2291: -- that got created.
2292: --
2293: if l_num_ranges > 1 then
2294: --
2295: hr_utility.set_location('More than one range got created.', 10);
2296: --
2297: --
2298: -- Set the number of threads to the lesser of the defined number of threads
2299: -- and the number of ranges created above. There's no point in submitting

Line 2311: hr_utility.set_location('Submitting request ' || l_count, 10);

2307: -- We are subtracting one from the number of threads because the main
2308: -- process will act as the last thread and will be able to keep track of
2309: -- the child requests that get submitted.
2310: --
2311: hr_utility.set_location('Submitting request ' || l_count, 10);
2312: --
2313: l_request_id := fnd_request.submit_request
2314: (application => 'BEN'
2315: ,program => 'BENCLENRS'

Line 2362: hr_utility.set_location('Submitting the master process', 10);

2358: end if;
2359: --
2360: -- Carry on with the master. This will ensure that the master finishes last.
2361: --
2362: hr_utility.set_location('Submitting the master process', 10);
2363: --
2364: do_multithread
2365: (errbuf => errbuf
2366: ,retcode => retcode

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

2385: -- Submit reports.
2386: --
2387: submit_all_reports(p_audit_log => p_audit_log);
2388: --
2389: hr_utility.set_location ('Leaving ' || l_proc, 10);
2390: --
2391: exception
2392: --
2393: when others then

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

2527: l_pil_rec c_get_strtd_dt%rowtype;
2528: --
2529: begin
2530: --
2531: hr_utility.set_location ('Entering '||l_proc,10);
2532:
2533: --
2534: --Bug(2300866):Should not allow to reopen the bug
2535: --the prtspnt does not have any electable choices.

Line 2537: hr_utility.set_location('p_per_in_ler_id' || p_per_in_ler_id , 99 );

2533: --
2534: --Bug(2300866):Should not allow to reopen the bug
2535: --the prtspnt does not have any electable choices.
2536: --
2537: hr_utility.set_location('p_per_in_ler_id' || p_per_in_ler_id , 99 );
2538:
2539: open c_chk_reopen_lf_event;
2540: fetch c_chk_reopen_lf_event into l_chk_reopen_lf_event;
2541: close c_chk_reopen_lf_event;

Line 2646: hr_utility.set_location ('manage_enrt_bnft '||l_enb.enrt_bnft_id,10);

2642: --epe and valid result.
2643: --
2644: FOR l_enb IN c_enb(p_per_in_ler_id) LOOP
2645: --
2646: hr_utility.set_location ('manage_enrt_bnft '||l_enb.enrt_bnft_id,10);
2647: --
2648: ben_election_information.manage_enrt_bnft
2649: ( p_enrt_bnft_id => l_enb.enrt_bnft_id,
2650: p_effective_date => p_effective_date,

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

2657: );
2658: --
2659: END LOOP;
2660: --
2661: hr_utility.set_location ('Leaving '||l_proc,10);
2662: --
2663: end reopen_single_life_event;
2664: --
2665: --Selfservice wrapper to call close enrollment for closing a per in ler