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

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

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

618: g_actn_tbl(i).actn_cd := 'D';
619: End if;
620: End loop;
621: End if;
622: hr_utility.set_location ('Leaving '||l_proc,10);
623: Exception
624: When others then
625: ben_batch_utils.rpt_error(p_proc => l_proc
626: ,p_last_actn => l_actn

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

848: l_object_version_number Number := p_object_version_number;
849: --
850: begin
851: --
852: hr_utility.set_location ('Entering ' || l_proc, 10);
853: --
854: -- Issue a savepoint for validation mode.
855: --
856: savepoint validate_point;

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

893: l_enrt_cnt := l_enrt_cnt + 1;
894: l_enrt_rec(l_enrt_cnt) := l_rec;
895: end loop;
896: --
897: hr_utility.set_location ('All enrollments l_enrt_cnt '||l_enrt_cnt ,20);
898: for i in 1..l_enrt_cnt
899: loop
900: --
901: -- If the enrollment result is suspended and has an interim enrollment

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

901: -- If the enrollment result is suspended and has an interim enrollment
902: -- then load the interim result's id into the cache.
903: --
904: if l_enrt_rec(i).rplcs_sspndd_rslt_id is not null then
905: hr_utility.set_location('Loading interim id into cache', 10);
906: l_intr_cnt := l_intr_cnt + 1;
907: l_intr_rec(l_intr_cnt).prtt_enrt_rslt_id := l_enrt_rec(i).rplcs_sspndd_rslt_id;
908: end if;
909: --

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

907: l_intr_rec(l_intr_cnt).prtt_enrt_rslt_id := l_enrt_rec(i).rplcs_sspndd_rslt_id;
908: end if;
909: --
910: end loop;
911: hr_utility.set_location ('Interim l_intr_cnt '||l_intr_cnt,30);
912: --
913: -- Load all of the person's interim enrt-rslt records into the l_intr_rec cache.
914: --
915: for i in 1..l_intr_cnt loop

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

938: --
939: for j in 1..l_intr_cnt loop
940: --
941: l_found := false; --Bug 2386000
942: --hr_utility.set_location(' INTR PEN '||l_intr_rec(j).prtt_enrt_rslt_id,111);
943: --hr_utility.set_location(' ENROLL PEN '||l_enrt_rec(i).prtt_enrt_rslt_id,111);
944: --
945: if l_intr_rec(j).prtt_enrt_rslt_id = l_enrt_rec(i).prtt_enrt_rslt_id
946: then

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

939: for j in 1..l_intr_cnt loop
940: --
941: l_found := false; --Bug 2386000
942: --hr_utility.set_location(' INTR PEN '||l_intr_rec(j).prtt_enrt_rslt_id,111);
943: --hr_utility.set_location(' ENROLL PEN '||l_enrt_rec(i).prtt_enrt_rslt_id,111);
944: --
945: if l_intr_rec(j).prtt_enrt_rslt_id = l_enrt_rec(i).prtt_enrt_rslt_id
946: then
947: --

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

965: l_process_cnt := l_enrt_cnt ;
966: l_process_rec := l_enrt_rec;
967: end if;
968: --
969: hr_utility.set_location(' All enrt minus Interim enrt l_process_cnt '||l_process_cnt, 40);
970: l_actn := 'Starting Enrollment loop';
971: --
972: for i in 1..l_process_cnt loop
973: --

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

976: if (p_batch_flag) then
977: --
978: -- g_actn_tbl is all the action items for a single result
979: --
980: hr_utility.set_location(' Call ld_actn First Place ',50);
981: ld_actn(p_business_group_id => p_business_group_id
982: ,p_effective_date => p_effective_date
983: ,p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
984: ,p_before => TRUE

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

989: end if;
990: --
991: -- Attempt to resolve actions items for this result.
992: --
993: hr_utility.set_location('Call determine_action_items ',60);
994: ben_enrollment_action_items.determine_action_items
995: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
996: ,p_effective_date => p_effective_date
997: ,p_business_group_id => p_business_group_id

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

1001: ,p_dpnt_actn_warning => l_dump_boolean
1002: ,p_bnf_actn_warning => l_dump_boolean
1003: ,p_ctfn_actn_warning => l_dump_boolean);
1004: --
1005: hr_utility.set_location(' l_suspend_flag '||l_suspend_flag,70);
1006: hr_utility.set_location(' l_process_rec(i).sspndd_flag '||l_process_rec(i).sspndd_flag , 70);
1007: --
1008: If (l_suspend_flag = 'Y' and l_process_rec(i).sspndd_flag = 'Y') then
1009: --

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

1002: ,p_bnf_actn_warning => l_dump_boolean
1003: ,p_ctfn_actn_warning => l_dump_boolean);
1004: --
1005: hr_utility.set_location(' l_suspend_flag '||l_suspend_flag,70);
1006: hr_utility.set_location(' l_process_rec(i).sspndd_flag '||l_process_rec(i).sspndd_flag , 70);
1007: --
1008: If (l_suspend_flag = 'Y' and l_process_rec(i).sspndd_flag = 'Y') then
1009: --
1010: -- The result is suspended now, and was suspended before this call...

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

1010: -- The result is suspended now, and was suspended before this call...
1011: --
1012: -- Get minimum due date of all required open actn items for this result
1013: --
1014: hr_utility.set_location('Enrt Result still suspended after benactcm call.'
1015: , 10);
1016: --
1017: open c_actn_min(l_process_rec(i).prtt_enrt_rslt_id);
1018: Fetch c_actn_min into l_due_dt;

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

1031: --
1032: If p_effective_date >= l_due_dt or p_overwrite_flag = TRUE
1033: then
1034: --
1035: hr_utility.set_location('Due date passed or overwrite flag TRUE', 10);
1036: --
1037: If (p_audit_log = 'Y') then
1038: --
1039: -- g_bnf_tbl is all the beneficiaries for a single result

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

1134: -- processing is skipped when it is picked up.
1135: --
1136: l_actn := 'Processing unsupended enrollment in loop E';
1137: --
1138: hr_utility.set_location('Result unsuspended after benactcm call', 10);
1139: --
1140: If (p_batch_flag) then
1141: --
1142: ben_batch_utils.write(p_text => '> Enrollment ( ' ||

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

1151: --
1152: If l_intr_rec(j).prtt_enrt_rslt_id=l_process_rec(i).prtt_enrt_rslt_id
1153: then
1154: --
1155: hr_utility.set_location('Will not process interim id ' ||
1156: l_intr_rec(j).prtt_enrt_rslt_id, 10);
1157: --
1158: l_intr_rec(j).skip := 'Y';
1159: --

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

1172: Elsif (l_suspend_flag = 'Y' and l_process_rec(i).sspndd_flag = 'N') then
1173: --
1174: -- If the result is suspended now and wasn't before then error out.
1175: --
1176: hr_utility.set_location('Result suspended after benactcm call.', 10);
1177: --
1178: If (p_batch_flag) then
1179: --
1180: ben_batch_utils.write

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

1186: Fnd_message.raise_error;
1187: --
1188: End if;
1189: --
1190: hr_utility.set_location(' After four cases ',80);
1191: -- Clean up all unresolved action items for this enrt result.
1192: --
1193: For l_recA in c_actn(l_process_rec(i).prtt_enrt_rslt_id) loop
1194: --

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

1211: End if;
1212: --
1213: If l_del_flag then
1214: --
1215: hr_utility.set_location(' l_del_flag TRUE ',80);
1216: remove_prtt_actn
1217: (p_prtt_enrt_actn_id => l_reca.prtt_enrt_actn_id
1218: ,p_business_group_id => p_business_group_id
1219: ,p_effective_date => p_effective_date

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

1231: End loop; -- End of c_Actn
1232: --
1233: If p_batch_flag then
1234: --
1235: --hr_utility.set_location(' Second ld_actn Call ', 90);
1236: --hr_utility.set_location(' l_idx_b '||l_idx_b,90);
1237: --hr_utility.set_location('l_idx_e '||l_idx_e,90);
1238:
1239: --

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

1232: --
1233: If p_batch_flag then
1234: --
1235: --hr_utility.set_location(' Second ld_actn Call ', 90);
1236: --hr_utility.set_location(' l_idx_b '||l_idx_b,90);
1237: --hr_utility.set_location('l_idx_e '||l_idx_e,90);
1238:
1239: --
1240: ld_actn(p_business_group_id => p_business_group_id

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

1233: If p_batch_flag then
1234: --
1235: --hr_utility.set_location(' Second ld_actn Call ', 90);
1236: --hr_utility.set_location(' l_idx_b '||l_idx_b,90);
1237: --hr_utility.set_location('l_idx_e '||l_idx_e,90);
1238:
1239: --
1240: ld_actn(p_business_group_id => p_business_group_id
1241: ,p_effective_date => p_effective_date

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

1276: --
1277: -- For each enrt result id call determine action items to try to unsuspend
1278: -- the result.
1279: --
1280: hr_utility.set_location('Cleaing up interim enrollment id : ' ||
1281: l_intr_rec(i).prtt_enrt_rslt_id, 10);
1282: --
1283: If (l_intr_rec(i).skip = 'N') then
1284: --

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

1287: If (p_batch_flag) then
1288: --
1289: l_actn := 'Calling ld_actn...';
1290: --
1291: --hr_utility.set_location(' Second ld_actn Call ', 99);
1292: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1293: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1294: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1295: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);

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

1288: --
1289: l_actn := 'Calling ld_actn...';
1290: --
1291: --hr_utility.set_location(' Second ld_actn Call ', 99);
1292: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1293: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1294: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1295: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1296: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);

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

1289: l_actn := 'Calling ld_actn...';
1290: --
1291: --hr_utility.set_location(' Second ld_actn Call ', 99);
1292: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1293: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1294: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1295: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1296: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);
1297:

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

1290: --
1291: --hr_utility.set_location(' Second ld_actn Call ', 99);
1292: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1293: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1294: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1295: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1296: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);
1297:
1298: ld_actn(p_business_group_id => p_business_group_id

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

1292: --hr_utility.set_location(' l_idx_b '||l_idx_b,99);
1293: --hr_utility.set_location('l_idx_e '||l_idx_e,99);
1294: --hr_utility.set_location('l_process_rec(i).prtt_enrt_rslt_id '
1295: -- ||l_process_rec(i).prtt_enrt_rslt_id,99);
1296: --hr_utility.set_location(' p_effective_date '||p_effective_date,99);
1297:
1298: ld_actn(p_business_group_id => p_business_group_id
1299: ,p_effective_date => p_effective_date
1300: ,p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id

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

1440: g_persons_procd := g_persons_procd + 1;
1441: --
1442: End if;
1443: --
1444: hr_utility.set_location('Leaving:'||l_proc, 10);
1445: --
1446: Exception
1447: --
1448: When others then

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

1448: When others then
1449: --
1450: rollback to validate_point;
1451: --
1452: hr_utility.set_location('Exception handled in cls_per...', 10);
1453: If (p_batch_flag) then
1454: --
1455: g_persons_errored := g_persons_errored + 1;
1456: ben_batch_utils.write_error_rec;

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

1568: l_master varchar2(1) := 'N';
1569: --
1570: Begin
1571: --
1572: hr_utility.set_location ('Entering '||l_proc,5);
1573: --
1574: -- Convert varchar2 dates to real dates
1575: -- 1) First remove time component
1576: -- 2) Next convert format

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

1680: --
1681: for l_rec in c_person_thread
1682: loop
1683: --
1684: hr_utility.set_location('person_id : ' || l_rec.person_id, 10);
1685: --
1686: g_person_actn_cnt := g_person_actn_cnt + 1;
1687: --
1688: begin

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

1732: submit_all_reports(p_audit_log => p_audit_log);
1733: --
1734: end if;
1735: --
1736: hr_utility.set_location ('Leaving '||l_proc,70);
1737: --
1738: Exception
1739: --
1740: when others

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

1801: l_actn varchar2(80);
1802: --
1803: Begin
1804: --
1805: hr_utility.set_location ('Entering ' || l_proc, 10);
1806: --
1807: -- get the parameters for a previous run and do a restart
1808: --
1809: open c_parameters;

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

1833: ,p_debug_messages => l_parameters.debug_messages_flag
1834: ,p_audit_log => l_parameters.audit_log_flag
1835: );
1836: --
1837: hr_utility.set_location ('Leaving ' || l_proc, 70);
1838: --
1839: End restart;
1840: --
1841: -- ----------------------------------------------------------------------------

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

1921: l_commit number;
1922: --
1923: Begin
1924: --
1925: hr_utility.set_location ('Entering '||l_proc,5);
1926: --
1927: -- Convert varchar2 dates to real dates
1928: -- 1) First remove time component
1929: -- 2) Next convert format

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

2114: -- for restarting.
2115: --
2116: l_benefit_action_id := p_benefit_action_id;
2117: --
2118: hr_utility.set_location('Restarting for benefit action id : ' ||
2119: to_char(l_benefit_action_id), 10);
2120: --
2121: ben_batch_utils.create_restart_person_actions
2122: (p_benefit_action_id => p_benefit_action_id

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

2135: --
2136: if l_num_ranges > 1
2137: then
2138: --
2139: hr_utility.set_location('More than one range got created.', 10);
2140: --
2141: -- Set the number of threads to the lesser of the defined number of threads
2142: -- and the number of ranges created above. There's no point in submitting
2143: -- 5 threads for only two ranges.

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

2150: -- We are subtracting one from the number of threads because the main
2151: -- process will act as the last thread and will be able to keep track of
2152: -- the child requests that get submitted.
2153: --
2154: hr_utility.set_location('Submitting request ' || l_count, 10);
2155: --
2156: l_request_id := fnd_request.submit_request
2157: (application => 'BEN'
2158: ,program => 'BENUNEAIS'

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

2175: --
2176: elsif l_num_ranges = 0
2177: then
2178: --
2179: hr_utility.set_location('No people selected', 10);
2180: -- No ranges got created. i.e. no people got selected. Error out.
2181: --
2182: ben_batch_utils.print_parameters
2183: (p_thread_id => 99

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

2199: end if;
2200: --
2201: -- Carry on with the master. This will ensure that the master finishes last.
2202: --
2203: hr_utility.set_location('Submitting the master process', 10);
2204: --
2205: do_multithread
2206: (errbuf => errbuf
2207: ,retcode => retcode

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

2211: ,p_effective_date => p_effective_date
2212: ,p_business_group_id => p_business_group_id
2213: ,p_audit_log => p_audit_log);
2214: --
2215: hr_utility.set_location ('Leaving ' || l_proc, 10);
2216: --
2217: End process;
2218: --
2219: End ben_cls_unresolved_Actn_item;