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

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

82: l_del boolean := FALSE;
83: --
84: Begin
85: --
86: hr_utility.set_location ('Entering '||l_proc,05);
87: --
88: If(p_error) then
89: --
90: If(p_audit_log = 'Y') then

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

244: End loop;
245: --
246: End if;
247: --
248: hr_utility.set_location ('Leaving '||l_proc, 10);
249: --
250: Exception
251: --
252: When others then

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

272: l_request_id number;
273: --
274: begin
275: --
276: hr_utility.set_location ('Entering '||l_proc,05);
277: --
278: l_actn := 'Calling ben_batch_utils.batch_report (BENUAAUD)...';
279: --
280: If fnd_global.conc_request_id <> -1 then

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

307: ,p_report_type => 'ERROR_BY_PERSON');
308: --
309: End if;
310: --
311: hr_utility.set_location ('Leaving '||l_proc,10);
312: --
313: Exception
314: --
315: When others then

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

350: l_effective_end_date date := p_effective_end_date;
351: --
352: begin
353: --
354: hr_utility.set_location ('Entering '||l_proc,5);
355: --
356: --
357: l_actn := 'Calling delete_prtt_enrt_actn(' || to_char(p_prtt_enrt_actn_id)
358: || ')...' ;

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

369: ,p_effective_start_date => p_effective_start_date
370: ,p_effective_end_date => p_effective_end_date
371: );
372: --
373: hr_utility.set_location ('Leaving '||l_proc,10);
374: --
375: Exception
376: --
377: When others then

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

420: l_actn varchar2(80);
421: --
422: Begin
423: --
424: hr_utility.set_location ('Entering '||l_proc,05);
425: --
426: l_actn := 'Entering ld_dpnt...';
427: --
428: For rec in c1 loop

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

430: g_dpnt_cnt := g_dpnt_cnt + 1;
431: g_dpnt_tbl(g_dpnt_cnt) := rec;
432: End loop;
433: --
434: hr_utility.set_location ('Leaving '||l_proc,10);
435: --
436: Exception
437: --
438: When others then

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

470: l_proc varchar2(80) := g_package||'.ld_bnf';
471: l_actn varchar2(80);
472: --
473: Begin
474: hr_utility.set_location ('Entering '||l_proc,05);
475: l_actn := 'Entering ld_bnf...';
476: For rec in c1 loop
477: l_actn := 'Loading beneficiary...';
478: g_bnf_cnt := g_bnf_cnt + 1;

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

477: l_actn := 'Loading beneficiary...';
478: g_bnf_cnt := g_bnf_cnt + 1;
479: g_bnf_tbl(g_bnf_cnt) := rec;
480: End loop;
481: hr_utility.set_location ('Leaving '||l_proc,10);
482: Exception
483: When others then
484: ben_batch_utils.rpt_error(p_proc => l_proc
485: ,p_last_actn => l_actn

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

518: --
519: l_proc varchar2(80) := g_package||'.ld_cert';
520: l_actn varchar2(80);
521: Begin
522: hr_utility.set_location ('Entering '||l_proc,05);
523: l_actn := 'Entering ld_cert...';
524: For rec in c1 loop
525: l_actn := 'Loading Certicication...';
526: g_cert_cnt := g_cert_cnt + 1;

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

525: l_actn := 'Loading Certicication...';
526: g_cert_cnt := g_cert_cnt + 1;
527: g_cert_tbl(g_cert_cnt) := rec;
528: End loop;
529: hr_utility.set_location ('Leaving '||l_proc,10);
530: Exception
531: When others then
532: ben_batch_utils.rpt_error(p_proc => l_proc
533: ,p_last_actn => l_actn

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

580: l_idx_b binary_integer := p_idx_b ;
581: l_idx_e binary_integer:= p_idx_e;
582:
583: Begin
584: hr_utility.set_location ('Entering '||l_proc,05);
585: If(p_before) then
586: --
587: l_actn := 'Load actn item (Before)...';
588: p_idx_b := g_actn_cnt;

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

613: g_actn_tbl(i).actn_cd := 'D';
614: End if;
615: End loop;
616: End if;
617: hr_utility.set_location ('Leaving '||l_proc,10);
618: Exception
619: When others then
620: ben_batch_utils.rpt_error(p_proc => l_proc
621: ,p_last_actn => l_actn

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

755: l_object_version_number Number := p_object_version_number;
756: --
757: begin
758: --
759: hr_utility.set_location ('Entering ' || l_proc, 10);
760: --
761: -- Issue a savepoint for validation mode.
762: --
763: savepoint validate_point;

Line 804: hr_utility.set_location ('All enrollments l_enrt_cnt '||l_enrt_cnt ,20);

800: l_enrt_cnt := l_enrt_cnt + 1;
801: l_enrt_rec(l_enrt_cnt) := l_rec;
802: end loop;
803: --
804: hr_utility.set_location ('All enrollments l_enrt_cnt '||l_enrt_cnt ,20);
805: for i in 1..l_enrt_cnt
806: loop
807: --
808: -- If the enrollment result is suspended and has an interim enrollment

Line 812: hr_utility.set_location('Loading interim id into cache', 10);

808: -- If the enrollment result is suspended and has an interim enrollment
809: -- then load the interim result's id into the cache.
810: --
811: if l_enrt_rec(i).rplcs_sspndd_rslt_id is not null then
812: hr_utility.set_location('Loading interim id into cache', 10);
813: l_intr_cnt := l_intr_cnt + 1;
814: l_intr_rec(l_intr_cnt).prtt_enrt_rslt_id := l_enrt_rec(i).rplcs_sspndd_rslt_id;
815: end if;
816: --

Line 818: hr_utility.set_location ('Interim l_intr_cnt '||l_intr_cnt,30);

814: l_intr_rec(l_intr_cnt).prtt_enrt_rslt_id := l_enrt_rec(i).rplcs_sspndd_rslt_id;
815: end if;
816: --
817: end loop;
818: hr_utility.set_location ('Interim l_intr_cnt '||l_intr_cnt,30);
819: --
820: -- Load all of the person's interim enrt-rslt records into the l_intr_rec cache.
821: --
822: for i in 1..l_intr_cnt loop

Line 849: --hr_utility.set_location(' INTR PEN '||l_intr_rec(j).prtt_enrt_rslt_id,111);

845: --
846: for j in 1..l_intr_cnt loop
847: --
848: l_found := false; --Bug 2386000
849: --hr_utility.set_location(' INTR PEN '||l_intr_rec(j).prtt_enrt_rslt_id,111);
850: --hr_utility.set_location(' ENROLL PEN '||l_enrt_rec(i).prtt_enrt_rslt_id,111);
851: --
852: if l_intr_rec(j).prtt_enrt_rslt_id = l_enrt_rec(i).prtt_enrt_rslt_id
853: then

Line 850: --hr_utility.set_location(' ENROLL PEN '||l_enrt_rec(i).prtt_enrt_rslt_id,111);

846: for j in 1..l_intr_cnt loop
847: --
848: l_found := false; --Bug 2386000
849: --hr_utility.set_location(' INTR PEN '||l_intr_rec(j).prtt_enrt_rslt_id,111);
850: --hr_utility.set_location(' ENROLL PEN '||l_enrt_rec(i).prtt_enrt_rslt_id,111);
851: --
852: if l_intr_rec(j).prtt_enrt_rslt_id = l_enrt_rec(i).prtt_enrt_rslt_id
853: then
854: --

Line 876: hr_utility.set_location(' All enrt minus Interim enrt l_process_cnt '||l_process_cnt, 40);

872: l_process_cnt := l_enrt_cnt ;
873: l_process_rec := l_enrt_rec;
874: end if;
875: --
876: hr_utility.set_location(' All enrt minus Interim enrt l_process_cnt '||l_process_cnt, 40);
877: l_actn := 'Starting Enrollment loop';
878: --
879: for i in 1..l_process_cnt loop
880: --

Line 887: hr_utility.set_location(' Call ld_actn First Place ',50);

883: if (p_batch_flag) then
884: --
885: -- g_actn_tbl is all the action items for a single result
886: --
887: hr_utility.set_location(' Call ld_actn First Place ',50);
888: ld_actn(p_business_group_id => p_business_group_id
889: ,p_effective_date => p_effective_date
890: ,p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
891: ,p_before => TRUE

Line 900: hr_utility.set_location('Call determine_action_items ',60);

896: end if;
897: --
898: -- Attempt to resolve actions items for this result.
899: --
900: hr_utility.set_location('Call determine_action_items ',60);
901: ben_enrollment_action_items.determine_action_items
902: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
903: ,p_effective_date => p_effective_date
904: ,p_business_group_id => p_business_group_id

Line 912: hr_utility.set_location(' l_suspend_flag '||l_suspend_flag,70);

908: ,p_dpnt_actn_warning => l_dump_boolean
909: ,p_bnf_actn_warning => l_dump_boolean
910: ,p_ctfn_actn_warning => l_dump_boolean);
911: --
912: hr_utility.set_location(' l_suspend_flag '||l_suspend_flag,70);
913: hr_utility.set_location(' l_process_rec(i).sspndd_flag '||l_process_rec(i).sspndd_flag , 70);
914: --
915: If (l_suspend_flag = 'Y' and l_process_rec(i).sspndd_flag = 'Y') then
916: --

Line 913: hr_utility.set_location(' l_process_rec(i).sspndd_flag '||l_process_rec(i).sspndd_flag , 70);

909: ,p_bnf_actn_warning => l_dump_boolean
910: ,p_ctfn_actn_warning => l_dump_boolean);
911: --
912: hr_utility.set_location(' l_suspend_flag '||l_suspend_flag,70);
913: hr_utility.set_location(' l_process_rec(i).sspndd_flag '||l_process_rec(i).sspndd_flag , 70);
914: --
915: If (l_suspend_flag = 'Y' and l_process_rec(i).sspndd_flag = 'Y') then
916: --
917: -- The result is suspended now, and was suspended before this call...

Line 921: hr_utility.set_location('Enrt Result still suspended after benactcm call.'

917: -- The result is suspended now, and was suspended before this call...
918: --
919: -- Get minimum due date of all required open actn items for this result
920: --
921: hr_utility.set_location('Enrt Result still suspended after benactcm call.'
922: , 10);
923: --
924: open c_actn_min(l_process_rec(i).prtt_enrt_rslt_id);
925: Fetch c_actn_min into l_due_dt;

Line 942: hr_utility.set_location('Due date passed or overwrite flag TRUE', 10);

938: --
939: If p_effective_date >= l_due_dt or p_overwrite_flag = TRUE
940: then
941: --
942: hr_utility.set_location('Due date passed or overwrite flag TRUE', 10);
943: --
944: If (p_audit_log = 'Y') then
945: --
946: -- g_bnf_tbl is all the beneficiaries for a single result

Line 998: hr_utility.set_location('Result unsuspended after benactcm call', 10);

994: -- processing is skipped when it is picked up.
995: --
996: l_actn := 'Processing unsupended enrollment in loop E';
997: --
998: hr_utility.set_location('Result unsuspended after benactcm call', 10);
999: --
1000: If (p_batch_flag) then
1001: --
1002: ben_batch_utils.write(p_text => '> Enrollment ( ' ||

Line 1015: hr_utility.set_location('Will not process interim id ' ||

1011: --
1012: If l_intr_rec(j).prtt_enrt_rslt_id=l_process_rec(i).prtt_enrt_rslt_id
1013: then
1014: --
1015: hr_utility.set_location('Will not process interim id ' ||
1016: l_intr_rec(j).prtt_enrt_rslt_id, 10);
1017: --
1018: l_intr_rec(j).skip := 'Y';
1019: --

Line 1036: hr_utility.set_location('Result suspended after benactcm call.', 10);

1032: Elsif (l_suspend_flag = 'Y' and l_process_rec(i).sspndd_flag = 'N') then
1033: --
1034: -- If the result is suspended now and wasn't before then error out.
1035: --
1036: hr_utility.set_location('Result suspended after benactcm call.', 10);
1037: --
1038: If (p_batch_flag) then
1039: --
1040: ben_batch_utils.write

Line 1050: hr_utility.set_location(' After four cases ',80);

1046: Fnd_message.raise_error;
1047: --
1048: End if;
1049: --
1050: hr_utility.set_location(' After four cases ',80);
1051: -- Clean up all unresolved action items for this enrt result.
1052: --
1053: For l_recA in c_actn(l_process_rec(i).prtt_enrt_rslt_id) loop
1054: --

Line 1075: hr_utility.set_location(' l_del_flag TRUE ',80);

1071: End if;
1072: --
1073: If l_del_flag then
1074: --
1075: hr_utility.set_location(' l_del_flag TRUE ',80);
1076: remove_prtt_actn
1077: (p_prtt_enrt_actn_id => l_reca.prtt_enrt_actn_id
1078: ,p_business_group_id => p_business_group_id
1079: ,p_effective_date => p_effective_date

Line 1095: --hr_utility.set_location(' Second ld_actn Call ', 90);

1091: End loop; -- End of c_Actn
1092: --
1093: If p_batch_flag then
1094: --
1095: --hr_utility.set_location(' Second ld_actn Call ', 90);
1096: --hr_utility.set_location(' l_idx_b '||l_idx_b,90);
1097: --hr_utility.set_location('l_idx_e '||l_idx_e,90);
1098:
1099: --

Line 1096: --hr_utility.set_location(' l_idx_b '||l_idx_b,90);

1092: --
1093: If p_batch_flag then
1094: --
1095: --hr_utility.set_location(' Second ld_actn Call ', 90);
1096: --hr_utility.set_location(' l_idx_b '||l_idx_b,90);
1097: --hr_utility.set_location('l_idx_e '||l_idx_e,90);
1098:
1099: --
1100: ld_actn(p_business_group_id => p_business_group_id

Line 1097: --hr_utility.set_location('l_idx_e '||l_idx_e,90);

1093: If p_batch_flag then
1094: --
1095: --hr_utility.set_location(' Second ld_actn Call ', 90);
1096: --hr_utility.set_location(' l_idx_b '||l_idx_b,90);
1097: --hr_utility.set_location('l_idx_e '||l_idx_e,90);
1098:
1099: --
1100: ld_actn(p_business_group_id => p_business_group_id
1101: ,p_effective_date => p_effective_date

Line 1140: hr_utility.set_location('Cleaing up interim enrollment id : ' ||

1136: --
1137: -- For each enrt result id call determine action items to try to unsuspend
1138: -- the result.
1139: --
1140: hr_utility.set_location('Cleaing up interim enrollment id : ' ||
1141: l_intr_rec(i).prtt_enrt_rslt_id, 10);
1142: --
1143: If (l_intr_rec(i).skip = 'N') then
1144: --

Line 1151: --hr_utility.set_location(' Second ld_actn Call ', 99);

1147: If (p_batch_flag) then
1148: --
1149: l_actn := 'Calling ld_actn...';
1150: --
1151: --hr_utility.set_location(' Second ld_actn Call ', 99);
1152: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1153: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1154: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1155: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);

Line 1152: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);

1148: --
1149: l_actn := 'Calling ld_actn...';
1150: --
1151: --hr_utility.set_location(' Second ld_actn Call ', 99);
1152: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1153: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1154: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1155: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1156: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);

Line 1153: --hr_utility.set_location('l_idx_e '||l_idx_e,99);

1149: l_actn := 'Calling ld_actn...';
1150: --
1151: --hr_utility.set_location(' Second ld_actn Call ', 99);
1152: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1153: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1154: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1155: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1156: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);
1157:

Line 1154: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '

1150: --
1151: --hr_utility.set_location(' Second ld_actn Call ', 99);
1152: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1153: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1154: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1155: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1156: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);
1157:
1158: ld_actn(p_business_group_id => p_business_group_id

Line 1156: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);

1152: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1153: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1154: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1155: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1156: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);
1157:
1158: ld_actn(p_business_group_id => p_business_group_id
1159: ,p_effective_date => p_effective_date
1160: ,p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id

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

1300: g_persons_procd := g_persons_procd + 1;
1301: --
1302: End if;
1303: --
1304: hr_utility.set_location('Leaving:'||l_proc, 10);
1305: --
1306: Exception
1307: --
1308: When others then

Line 1312: hr_utility.set_location('Exception handled in cls_per...', 10);

1308: When others then
1309: --
1310: rollback to validate_point;
1311: --
1312: hr_utility.set_location('Exception handled in cls_per...', 10);
1313: If (p_batch_flag) then
1314: --
1315: g_persons_errored := g_persons_errored + 1;
1316: ben_batch_utils.write_error_rec;

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

1428: l_master varchar2(1) := 'N';
1429: --
1430: Begin
1431: --
1432: hr_utility.set_location ('Entering '||l_proc,5);
1433: --
1434: -- Convert varchar2 dates to real dates
1435: -- 1) First remove time component
1436: -- 2) Next convert format

Line 1544: hr_utility.set_location('person_id : ' || l_rec.person_id, 10);

1540: --
1541: for l_rec in c_person_thread
1542: loop
1543: --
1544: hr_utility.set_location('person_id : ' || l_rec.person_id, 10);
1545: --
1546: g_person_actn_cnt := g_person_actn_cnt + 1;
1547: --
1548: begin

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

1592: submit_all_reports(p_audit_log => p_audit_log);
1593: --
1594: end if;
1595: --
1596: hr_utility.set_location ('Leaving '||l_proc,70);
1597: --
1598: Exception
1599: --
1600: when others

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

1661: l_actn varchar2(80);
1662: --
1663: Begin
1664: --
1665: hr_utility.set_location ('Entering ' || l_proc, 10);
1666: --
1667: -- get the parameters for a previous run and do a restart
1668: --
1669: open c_parameters;

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

1693: ,p_debug_messages => l_parameters.debug_messages_flag
1694: ,p_audit_log => l_parameters.audit_log_flag
1695: );
1696: --
1697: hr_utility.set_location ('Leaving ' || l_proc, 70);
1698: --
1699: End restart;
1700: --
1701: -- ----------------------------------------------------------------------------

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

1781: l_commit number;
1782: --
1783: Begin
1784: --
1785: hr_utility.set_location ('Entering '||l_proc,5);
1786: --
1787: -- Convert varchar2 dates to real dates
1788: -- 1) First remove time component
1789: -- 2) Next convert format

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

1974: -- for restarting.
1975: --
1976: l_benefit_action_id := p_benefit_action_id;
1977: --
1978: hr_utility.set_location('Restarting for benefit action id : ' ||
1979: to_char(l_benefit_action_id), 10);
1980: --
1981: ben_batch_utils.create_restart_person_actions
1982: (p_benefit_action_id => p_benefit_action_id

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

1995: --
1996: if l_num_ranges > 1
1997: then
1998: --
1999: hr_utility.set_location('More than one range got created.', 10);
2000: --
2001: -- Set the number of threads to the lesser of the defined number of threads
2002: -- and the number of ranges created above. There's no point in submitting
2003: -- 5 threads for only two ranges.

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

2010: -- We are subtracting one from the number of threads because the main
2011: -- process will act as the last thread and will be able to keep track of
2012: -- the child requests that get submitted.
2013: --
2014: hr_utility.set_location('Submitting request ' || l_count, 10);
2015: --
2016: l_request_id := fnd_request.submit_request
2017: (application => 'BEN'
2018: ,program => 'BENUNEAIS'

Line 2039: hr_utility.set_location('No people selected', 10);

2035: --
2036: elsif l_num_ranges = 0
2037: then
2038: --
2039: hr_utility.set_location('No people selected', 10);
2040: -- No ranges got created. i.e. no people got selected. Error out.
2041: --
2042: ben_batch_utils.print_parameters
2043: (p_thread_id => 99

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

2059: end if;
2060: --
2061: -- Carry on with the master. This will ensure that the master finishes last.
2062: --
2063: hr_utility.set_location('Submitting the master process', 10);
2064: --
2065: do_multithread
2066: (errbuf => errbuf
2067: ,retcode => retcode

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

2071: ,p_effective_date => p_effective_date
2072: ,p_business_group_id => p_business_group_id
2073: ,p_audit_log => p_audit_log);
2074: --
2075: hr_utility.set_location ('Leaving ' || l_proc, 10);
2076: --
2077: End process;
2078: --
2079: End ben_cls_unresolved_Actn_item;