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 BEN_BATCH_UTILS

Line 73: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;

69: --
70: l_proc varchar2(80) := g_package||'.write_person_category';
71: --
72: l_actn varchar2(80);
73: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;
74: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;
75: l_category varchar2(30);
76: l_detail varchar2(132);
77: l_ovn number;

Line 74: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;

70: l_proc varchar2(80) := g_package||'.write_person_category';
71: --
72: l_actn varchar2(80);
73: l_cache ben_batch_utils.g_comp_obj_table := ben_batch_utils.g_cache_comp;
74: l_cache_cnt binary_integer := ben_batch_utils.g_cache_comp_cnt;
75: l_category varchar2(30);
76: l_detail varchar2(132);
77: l_ovn number;
78: l_id number;

Line 95: l_actn := 'Calling ben_batch_utils.write_rec (ERROR_C)...';

91: --
92: l_category := 'ERROR_C';
93: l_detail := 'Error occur while Close action item';
94: --
95: l_actn := 'Calling ben_batch_utils.write_rec (ERROR_C)...';
96: Ben_batch_utils.write_rec(p_typ_cd => l_category
97: ,p_text => l_detail);
98: --
99: End if;

Line 96: Ben_batch_utils.write_rec(p_typ_cd => l_category

92: l_category := 'ERROR_C';
93: l_detail := 'Error occur while Close action item';
94: --
95: l_actn := 'Calling ben_batch_utils.write_rec (ERROR_C)...';
96: Ben_batch_utils.write_rec(p_typ_cd => l_category
97: ,p_text => l_detail);
98: --
99: End if;
100: --

Line 140: l_actn := 'Calling ben_batch_utils.write_rec...';

136: End if;
137: --
138: End if;
139: --
140: l_actn := 'Calling ben_batch_utils.write_rec...';
141: Ben_batch_utils.write_rec(p_typ_cd => l_category
142: ,p_text => l_detail);
143: --
144: End if;

Line 141: Ben_batch_utils.write_rec(p_typ_cd => l_category

137: --
138: End if;
139: --
140: l_actn := 'Calling ben_batch_utils.write_rec...';
141: Ben_batch_utils.write_rec(p_typ_cd => l_category
142: ,p_text => l_detail);
143: --
144: End if;
145: --

Line 253: ben_batch_utils.rpt_error(p_proc => l_proc

249: --
250: Exception
251: --
252: When others then
253: ben_batch_utils.rpt_error(p_proc => l_proc
254: ,p_last_actn => l_actn
255: ,p_rpt_flag => TRUE
256: );
257: raise;

Line 278: l_actn := 'Calling ben_batch_utils.batch_report (BENUAAUD)...';

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
281: --
282: If(p_audit_log = 'Y') then

Line 284: ben_batch_utils.batch_report

280: If fnd_global.conc_request_id <> -1 then
281: --
282: If(p_audit_log = 'Y') then
283: --
284: ben_batch_utils.batch_report
285: (p_concurrent_request_id => fnd_global.conc_request_id
286: ,p_program_name => 'BENUAAUD'
287: ,p_request_id => l_request_id);
288: --

Line 291: l_actn := 'Calling ben_batch_utils.batch_report (BENUASUM)...';

287: ,p_request_id => l_request_id);
288: --
289: End if;
290: --
291: l_actn := 'Calling ben_batch_utils.batch_report (BENUASUM)...';
292: --
293: ben_batch_utils.batch_report
294: (p_concurrent_request_id => fnd_global.conc_request_id
295: ,p_program_name => 'BENUASUM'

Line 293: ben_batch_utils.batch_report

289: End if;
290: --
291: l_actn := 'Calling ben_batch_utils.batch_report (BENUASUM)...';
292: --
293: ben_batch_utils.batch_report
294: (p_concurrent_request_id => fnd_global.conc_request_id
295: ,p_program_name => 'BENUASUM'
296: ,p_request_id => l_request_id
297: );

Line 316: ben_batch_utils.rpt_error(p_proc => l_proc

312: --
313: Exception
314: --
315: When others then
316: ben_batch_utils.rpt_error(p_proc => l_proc
317: ,p_last_actn => l_actn
318: ,p_rpt_flag => p_rpt_flag
319: );
320: raise;

Line 379: ben_batch_utils.rpt_error(p_proc => l_proc

375: Exception
376: --
377: When others then
378: --
379: ben_batch_utils.rpt_error(p_proc => l_proc
380: ,p_last_actn => l_actn
381: ,p_rpt_flag => p_batch_flag
382: );
383: -- For nocopy changes

Line 439: ben_batch_utils.rpt_error(p_proc => l_proc

435: --
436: Exception
437: --
438: When others then
439: ben_batch_utils.rpt_error(p_proc => l_proc
440: ,p_last_actn => l_actn
441: ,p_rpt_flag => TRUE
442: );
443: raise;

Line 484: ben_batch_utils.rpt_error(p_proc => l_proc

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
486: ,p_rpt_flag => TRUE
487: );
488: raise;

Line 532: ben_batch_utils.rpt_error(p_proc => l_proc

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
534: ,p_rpt_flag => TRUE
535: );
536: raise;

Line 625: ben_batch_utils.rpt_error(p_proc => l_proc

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
627: ,p_rpt_flag => TRUE
628: );
629: -- for nocopy changes

Line 860: l_actn := 'Calling Ben_batch_utils.person_header...';

856: savepoint validate_point;
857: --
858: If p_batch_flag then
859: --
860: l_actn := 'Calling Ben_batch_utils.person_header...';
861: --
862: ben_batch_utils.person_header
863: (p_person_id => p_person_id
864: ,p_business_group_id => p_business_group_id

Line 862: ben_batch_utils.person_header

858: If p_batch_flag then
859: --
860: l_actn := 'Calling Ben_batch_utils.person_header...';
861: --
862: ben_batch_utils.person_header
863: (p_person_id => p_person_id
864: ,p_business_group_id => p_business_group_id
865: ,p_effective_date => p_effective_date);
866: --

Line 867: ben_batch_utils.ini('COMP_OBJ');

863: (p_person_id => p_person_id
864: ,p_business_group_id => p_business_group_id
865: ,p_effective_date => p_effective_date);
866: --
867: ben_batch_utils.ini('COMP_OBJ');
868: --
869: g_actn_tbl.delete;
870: g_actn_cnt := 0;
871: g_cert_tbl.delete;

Line 1059: ben_batch_utils.write(p_text => '');

1055: l_actn := 'Calling ben_prtt_enrt_result_api.delete_enrollment...' ;
1056: --
1057: --Bug 14013461 start
1058: if l_varible = 0 then
1059: ben_batch_utils.write(p_text => '');
1060: ben_batch_utils.write(p_text => 'Deleting suspended enrollments for person_id('||to_char(p_person_id)||')');
1061: l_varible := l_varible+1;
1062: end if;
1063: open c_pen_info(l_process_rec(i).prtt_enrt_rslt_id);

Line 1060: ben_batch_utils.write(p_text => 'Deleting suspended enrollments for person_id('||to_char(p_person_id)||')');

1056: --
1057: --Bug 14013461 start
1058: if l_varible = 0 then
1059: ben_batch_utils.write(p_text => '');
1060: ben_batch_utils.write(p_text => 'Deleting suspended enrollments for person_id('||to_char(p_person_id)||')');
1061: l_varible := l_varible+1;
1062: end if;
1063: open c_pen_info(l_process_rec(i).prtt_enrt_rslt_id);
1064: fetch c_pen_info into l_pen_info;

Line 1091: -- ben_batch_utils.write(p_text => ' pgm_id:'||to_char(l_pgm_id)||'|pl_id:'||to_char(l_pl_id)||'|oipl_id:'||to_char(l_oipl_id));

1087: fetch c_opt_info into l_opt_info;
1088: close c_opt_info;
1089: end if;
1090:
1091: -- ben_batch_utils.write(p_text => ' pgm_id:'||to_char(l_pgm_id)||'|pl_id:'||to_char(l_pl_id)||'|oipl_id:'||to_char(l_oipl_id));
1092: ben_batch_utils.write(p_text => ' '||l_pgm_info.name1||l_pl_info.name1||l_opt_info.name1);
1093: close c_pen_info;
1094: For l_actn in c_actn(l_process_rec(i).prtt_enrt_rslt_id) loop
1095: for l_cert in c_cert(l_actn.prtt_enrt_actn_id) loop

Line 1092: ben_batch_utils.write(p_text => ' '||l_pgm_info.name1||l_pl_info.name1||l_opt_info.name1);

1088: close c_opt_info;
1089: end if;
1090:
1091: -- ben_batch_utils.write(p_text => ' pgm_id:'||to_char(l_pgm_id)||'|pl_id:'||to_char(l_pl_id)||'|oipl_id:'||to_char(l_oipl_id));
1092: ben_batch_utils.write(p_text => ' '||l_pgm_info.name1||l_pl_info.name1||l_opt_info.name1);
1093: close c_pen_info;
1094: For l_actn in c_actn(l_process_rec(i).prtt_enrt_rslt_id) loop
1095: for l_cert in c_cert(l_actn.prtt_enrt_actn_id) loop
1096: ben_batch_utils.write(p_text => ' Closing '||l_cert.type||l_cert.meaning||'('||to_char(l_cert.id)||')');

Line 1096: ben_batch_utils.write(p_text => ' Closing '||l_cert.type||l_cert.meaning||'('||to_char(l_cert.id)||')');

1092: ben_batch_utils.write(p_text => ' '||l_pgm_info.name1||l_pl_info.name1||l_opt_info.name1);
1093: close c_pen_info;
1094: For l_actn in c_actn(l_process_rec(i).prtt_enrt_rslt_id) loop
1095: for l_cert in c_cert(l_actn.prtt_enrt_actn_id) loop
1096: ben_batch_utils.write(p_text => ' Closing '||l_cert.type||l_cert.meaning||'('||to_char(l_cert.id)||')');
1097: end loop;
1098: end loop;
1099: --Bug 14013461 end
1100:

Line 1142: ben_batch_utils.write(p_text => '> Enrollment ( ' ||

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 ( ' ||
1143: to_char(l_process_rec(i).prtt_enrt_rslt_id) ||
1144: ') unsuspended ');
1145: --
1146: End if;

Line 1161: ben_batch_utils.write(p_text => '> Interim Enrollment ( ' ||

1157: --
1158: l_intr_rec(j).skip := 'Y';
1159: --
1160: If (p_batch_flag) then
1161: ben_batch_utils.write(p_text => '> Interim Enrollment ( ' ||
1162: to_char(l_process_rec(j).prtt_enrt_rslt_id) ||
1163: ') Ended ');
1164: End if;
1165: --

Line 1180: ben_batch_utils.write

1176: hr_utility.set_location('Result suspended after benactcm call.', 10);
1177: --
1178: If (p_batch_flag) then
1179: --
1180: ben_batch_utils.write
1181: ('Enrollment(' || to_char(l_process_rec(i).prtt_enrt_rslt_id)
1182: || ') can not be suspeneded since it is active before');
1183: End if;
1184: --

Line 1248: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';

1244: ,p_after => TRUE
1245: ,p_idx_b => l_idx_b
1246: ,p_idx_e => l_idx_e);
1247: --
1248: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1249: --
1250: Ben_batch_utils.cache_comp_obj
1251: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
1252: ,p_effective_date => p_effective_date

Line 1250: Ben_batch_utils.cache_comp_obj

1246: ,p_idx_e => l_idx_e);
1247: --
1248: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1249: --
1250: Ben_batch_utils.cache_comp_obj
1251: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
1252: ,p_effective_date => p_effective_date
1253: ,p_actn_cd => l_actn_cd);
1254: --

Line 1362: l_actn := 'Calling ben_batch_utils.write...';

1358: );
1359: --
1360: If (p_batch_flag) then
1361: --
1362: l_actn := 'Calling ben_batch_utils.write...';
1363: --
1364: ben_batch_utils.write(p_text => '> Prtt_Enrt_Actn(' ||
1365: to_char(l_recA.prtt_enrt_actn_id) ||
1366: ') deleted');

Line 1364: ben_batch_utils.write(p_text => '> Prtt_Enrt_Actn(' ||

1360: If (p_batch_flag) then
1361: --
1362: l_actn := 'Calling ben_batch_utils.write...';
1363: --
1364: ben_batch_utils.write(p_text => '> Prtt_Enrt_Actn(' ||
1365: to_char(l_recA.prtt_enrt_actn_id) ||
1366: ') deleted');
1367: --
1368: End if;

Line 1387: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';

1383: ,p_idx_b => l_idx_b
1384: ,p_idx_e => l_idx_e
1385: );
1386: --
1387: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1388: --
1389: Ben_batch_utils.cache_comp_obj
1390: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
1391: ,p_effective_date => p_effective_date

Line 1389: Ben_batch_utils.cache_comp_obj

1385: );
1386: --
1387: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1388: --
1389: Ben_batch_utils.cache_comp_obj
1390: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
1391: ,p_effective_date => p_effective_date
1392: ,p_actn_cd => l_actn_cd
1393: );

Line 1456: ben_batch_utils.write_error_rec;

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;
1457: --
1458: ben_batch_utils.rpt_error(p_proc => l_proc
1459: ,p_last_actn => l_actn
1460: ,p_rpt_flag => TRUE);

Line 1458: ben_batch_utils.rpt_error(p_proc => l_proc

1454: --
1455: g_persons_errored := g_persons_errored + 1;
1456: ben_batch_utils.write_error_rec;
1457: --
1458: ben_batch_utils.rpt_error(p_proc => l_proc
1459: ,p_last_actn => l_actn
1460: ,p_rpt_flag => TRUE);
1461: --
1462: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

Line 1462: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

1458: ben_batch_utils.rpt_error(p_proc => l_proc
1459: ,p_last_actn => l_actn
1460: ,p_rpt_flag => TRUE);
1461: --
1462: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1463: ,p_effective_date => p_effective_date
1464: );
1465: --
1466: Ben_batch_utils.write(p_text => ' << Transactions Rollbacked >> ');

Line 1466: Ben_batch_utils.write(p_text => ' << Transactions Rollbacked >> ');

1462: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1463: ,p_effective_date => p_effective_date
1464: );
1465: --
1466: Ben_batch_utils.write(p_text => ' << Transactions Rollbacked >> ');
1467: --
1468: If p_person_action_id is not null then
1469: --
1470: ben_person_actions_api.update_person_actions

Line 1608: ben_batch_utils.ini;

1604: --
1605: g_persons_procd := 0;
1606: g_persons_errored := 0;
1607: --
1608: ben_batch_utils.ini;
1609: --
1610: benutils.g_benefit_action_id := p_benefit_action_id;
1611: benutils.g_thread_id := p_thread_id;
1612: --

Line 1634: Ben_batch_utils.print_parameters

1630: --
1631: -- Print the batch parameters to the log file if this program was called by
1632: -- the concurrent manager.
1633: --
1634: Ben_batch_utils.print_parameters
1635: (p_thread_id => p_thread_id
1636: ,p_benefit_action_id => p_benefit_action_id
1637: ,p_validate => p_validate
1638: ,p_business_group_id => p_business_group_id

Line 1713: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

1709: --
1710: --
1711: End loop;
1712: --
1713: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
1714: ,p_num_pers_errored => g_persons_errored);
1715: --
1716: --
1717: -- Check if all the slave processes are finished.

Line 1719: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

1715: --
1716: --
1717: -- Check if all the slave processes are finished.
1718: --
1719: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1720: --
1721: -- End the process.
1722: --
1723: ben_batch_utils.end_process

Line 1723: ben_batch_utils.end_process

1719: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1720: --
1721: -- End the process.
1722: --
1723: ben_batch_utils.end_process
1724: (p_benefit_action_id => p_benefit_action_id
1725: ,p_person_selected => g_person_actn_cnt
1726: ,p_business_group_id => p_business_group_id);
1727: --

Line 1745: ben_batch_utils.rpt_error(p_proc => l_proc

1741: then
1742: --
1743: rollback;
1744: --
1745: ben_batch_utils.rpt_error(p_proc => l_proc
1746: ,p_last_actn => l_actn
1747: ,p_rpt_flag => TRUE);
1748: --
1749: benutils.write(p_text => fnd_message.get);

Line 1752: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

1748: --
1749: benutils.write(p_text => fnd_message.get);
1750: benutils.write(p_text => sqlerrm);
1751: --
1752: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1753: --
1754: ben_batch_utils.end_process(p_benefit_action_id => p_benefit_action_id
1755: ,p_person_selected => g_person_actn_cnt
1756: ,p_business_group_id => p_business_group_id);

Line 1754: ben_batch_utils.end_process(p_benefit_action_id => p_benefit_action_id

1750: benutils.write(p_text => sqlerrm);
1751: --
1752: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1753: --
1754: ben_batch_utils.end_process(p_benefit_action_id => p_benefit_action_id
1755: ,p_person_selected => g_person_actn_cnt
1756: ,p_business_group_id => p_business_group_id);
1757: --
1758: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

Line 1948: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');

1944: ,p_argument => 'p_effective_date'
1945: ,p_argument_value => l_effective_date
1946: );
1947: --
1948: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
1949: --
1950: -- Get the parameters that were defined for this batch process.
1951: --
1952: benutils.get_parameter(p_business_group_id => p_business_group_id

Line 2020: l_person_ok := ben_batch_utils.person_selection_rule

2016: --
2017: if p_person_selection_rl is not null
2018: then
2019: --
2020: l_person_ok := ben_batch_utils.person_selection_rule
2021: (p_person_id => l_rec.person_id
2022: ,p_business_group_id => p_business_group_id
2023: ,p_person_selection_rule_id => p_person_selection_rl
2024: ,p_effective_date => l_effective_date);

Line 2121: ben_batch_utils.create_restart_person_actions

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
2123: ,p_effective_date => l_effective_date
2124: ,p_chunk_size => l_chunk_size
2125: ,p_threads => l_threads

Line 2170: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;

2166: ,argument6 => p_audit_log);
2167: --
2168: -- Store the request id of the concurrent request
2169: --
2170: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
2171: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
2172: := l_request_id;
2173: --
2174: end loop;

Line 2171: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)

2167: --
2168: -- Store the request id of the concurrent request
2169: --
2170: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
2171: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
2172: := l_request_id;
2173: --
2174: end loop;
2175: --

Line 2182: ben_batch_utils.print_parameters

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
2184: ,p_benefit_action_id => l_benefit_action_id
2185: ,p_validate => p_validate
2186: ,p_business_group_id => p_business_group_id

Line 2193: ben_batch_utils.write(p_text =>

2189: ,p_person_selection_rule_id => p_person_selection_rl
2190: ,p_location_id => p_location_id
2191: );
2192: --
2193: ben_batch_utils.write(p_text =>
2194: 'No person got selected with above selection criteria.');
2195: --
2196: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2197: fnd_message.raise_error;