DBA Data[Home] [Help]

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 620: ben_batch_utils.rpt_error(p_proc => l_proc

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
622: ,p_rpt_flag => TRUE
623: );
624: -- for nocopy changes

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

763: savepoint validate_point;
764: --
765: If p_batch_flag then
766: --
767: l_actn := 'Calling Ben_batch_utils.person_header...';
768: --
769: ben_batch_utils.person_header
770: (p_person_id => p_person_id
771: ,p_business_group_id => p_business_group_id

Line 769: ben_batch_utils.person_header

765: If p_batch_flag then
766: --
767: l_actn := 'Calling Ben_batch_utils.person_header...';
768: --
769: ben_batch_utils.person_header
770: (p_person_id => p_person_id
771: ,p_business_group_id => p_business_group_id
772: ,p_effective_date => p_effective_date);
773: --

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

770: (p_person_id => p_person_id
771: ,p_business_group_id => p_business_group_id
772: ,p_effective_date => p_effective_date);
773: --
774: ben_batch_utils.ini('COMP_OBJ');
775: --
776: g_actn_tbl.delete;
777: g_actn_cnt := 0;
778: g_cert_tbl.delete;

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

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 ( ' ||
1003: to_char(l_process_rec(i).prtt_enrt_rslt_id) ||
1004: ') unsuspended ');
1005: --
1006: End if;

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

1017: --
1018: l_intr_rec(j).skip := 'Y';
1019: --
1020: If (p_batch_flag) then
1021: ben_batch_utils.write(p_text => '> Interim Enrollment ( ' ||
1022: to_char(l_process_rec(j).prtt_enrt_rslt_id) ||
1023: ') Ended ');
1024: End if;
1025: --

Line 1040: ben_batch_utils.write

1036: hr_utility.set_location('Result suspended after benactcm call.', 10);
1037: --
1038: If (p_batch_flag) then
1039: --
1040: ben_batch_utils.write
1041: ('Enrollment(' || to_char(l_process_rec(i).prtt_enrt_rslt_id)
1042: || ') can not be suspeneded since it is active before');
1043: End if;
1044: --

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

1104: ,p_after => TRUE
1105: ,p_idx_b => l_idx_b
1106: ,p_idx_e => l_idx_e);
1107: --
1108: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1109: --
1110: Ben_batch_utils.cache_comp_obj
1111: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
1112: ,p_effective_date => p_effective_date

Line 1110: Ben_batch_utils.cache_comp_obj

1106: ,p_idx_e => l_idx_e);
1107: --
1108: l_actn := 'Calling Ben_batch_utils.cache_comp_obj...';
1109: --
1110: Ben_batch_utils.cache_comp_obj
1111: (p_prtt_enrt_rslt_id => l_process_rec(i).prtt_enrt_rslt_id
1112: ,p_effective_date => p_effective_date
1113: ,p_actn_cd => l_actn_cd);
1114: --

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

1218: );
1219: --
1220: If (p_batch_flag) then
1221: --
1222: l_actn := 'Calling ben_batch_utils.write...';
1223: --
1224: ben_batch_utils.write(p_text => '> Prtt_Enrt_Actn(' ||
1225: to_char(l_recA.prtt_enrt_actn_id) ||
1226: ') deleted');

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

1220: If (p_batch_flag) then
1221: --
1222: l_actn := 'Calling ben_batch_utils.write...';
1223: --
1224: ben_batch_utils.write(p_text => '> Prtt_Enrt_Actn(' ||
1225: to_char(l_recA.prtt_enrt_actn_id) ||
1226: ') deleted');
1227: --
1228: End if;

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

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

Line 1249: Ben_batch_utils.cache_comp_obj

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

Line 1316: ben_batch_utils.write_error_rec;

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;
1317: --
1318: ben_batch_utils.rpt_error(p_proc => l_proc
1319: ,p_last_actn => l_actn
1320: ,p_rpt_flag => TRUE);

Line 1318: ben_batch_utils.rpt_error(p_proc => l_proc

1314: --
1315: g_persons_errored := g_persons_errored + 1;
1316: ben_batch_utils.write_error_rec;
1317: --
1318: ben_batch_utils.rpt_error(p_proc => l_proc
1319: ,p_last_actn => l_actn
1320: ,p_rpt_flag => TRUE);
1321: --
1322: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

Line 1322: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id

1318: ben_batch_utils.rpt_error(p_proc => l_proc
1319: ,p_last_actn => l_actn
1320: ,p_rpt_flag => TRUE);
1321: --
1322: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1323: ,p_effective_date => p_effective_date
1324: );
1325: --
1326: Ben_batch_utils.write(p_text => ' << Transactions Rollbacked >> ');

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

1322: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1323: ,p_effective_date => p_effective_date
1324: );
1325: --
1326: Ben_batch_utils.write(p_text => ' << Transactions Rollbacked >> ');
1327: --
1328: If p_person_action_id is not null then
1329: --
1330: ben_person_actions_api.update_person_actions

Line 1468: ben_batch_utils.ini;

1464: --
1465: g_persons_procd := 0;
1466: g_persons_errored := 0;
1467: --
1468: ben_batch_utils.ini;
1469: --
1470: benutils.g_benefit_action_id := p_benefit_action_id;
1471: benutils.g_thread_id := p_thread_id;
1472: --

Line 1494: Ben_batch_utils.print_parameters

1490: --
1491: -- Print the batch parameters to the log file if this program was called by
1492: -- the concurrent manager.
1493: --
1494: Ben_batch_utils.print_parameters
1495: (p_thread_id => p_thread_id
1496: ,p_benefit_action_id => p_benefit_action_id
1497: ,p_validate => p_validate
1498: ,p_business_group_id => p_business_group_id

Line 1573: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd

1569: --
1570: --
1571: End loop;
1572: --
1573: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_procd
1574: ,p_num_pers_errored => g_persons_errored);
1575: --
1576: --
1577: -- Check if all the slave processes are finished.

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

1575: --
1576: --
1577: -- Check if all the slave processes are finished.
1578: --
1579: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1580: --
1581: -- End the process.
1582: --
1583: ben_batch_utils.end_process

Line 1583: ben_batch_utils.end_process

1579: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1580: --
1581: -- End the process.
1582: --
1583: ben_batch_utils.end_process
1584: (p_benefit_action_id => p_benefit_action_id
1585: ,p_person_selected => g_person_actn_cnt
1586: ,p_business_group_id => p_business_group_id);
1587: --

Line 1605: ben_batch_utils.rpt_error(p_proc => l_proc

1601: then
1602: --
1603: rollback;
1604: --
1605: ben_batch_utils.rpt_error(p_proc => l_proc
1606: ,p_last_actn => l_actn
1607: ,p_rpt_flag => TRUE);
1608: --
1609: benutils.write(p_text => fnd_message.get);

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

1608: --
1609: benutils.write(p_text => fnd_message.get);
1610: benutils.write(p_text => sqlerrm);
1611: --
1612: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1613: --
1614: ben_batch_utils.end_process(p_benefit_action_id => p_benefit_action_id
1615: ,p_person_selected => g_person_actn_cnt
1616: ,p_business_group_id => p_business_group_id);

Line 1614: ben_batch_utils.end_process(p_benefit_action_id => p_benefit_action_id

1610: benutils.write(p_text => sqlerrm);
1611: --
1612: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1613: --
1614: ben_batch_utils.end_process(p_benefit_action_id => p_benefit_action_id
1615: ,p_person_selected => g_person_actn_cnt
1616: ,p_business_group_id => p_business_group_id);
1617: --
1618: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

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

1804: ,p_argument => 'p_effective_date'
1805: ,p_argument_value => l_effective_date
1806: );
1807: --
1808: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
1809: --
1810: -- Get the parameters that were defined for this batch process.
1811: --
1812: benutils.get_parameter(p_business_group_id => p_business_group_id

Line 1880: l_person_ok := ben_batch_utils.person_selection_rule

1876: --
1877: if p_person_selection_rl is not null
1878: then
1879: --
1880: l_person_ok := ben_batch_utils.person_selection_rule
1881: (p_person_id => l_rec.person_id
1882: ,p_business_group_id => p_business_group_id
1883: ,p_person_selection_rule_id => p_person_selection_rl
1884: ,p_effective_date => l_effective_date);

Line 1981: ben_batch_utils.create_restart_person_actions

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
1983: ,p_effective_date => l_effective_date
1984: ,p_chunk_size => l_chunk_size
1985: ,p_threads => l_threads

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

2026: ,argument6 => p_audit_log);
2027: --
2028: -- Store the request id of the concurrent request
2029: --
2030: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
2031: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
2032: := l_request_id;
2033: --
2034: end loop;

Line 2031: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)

2027: --
2028: -- Store the request id of the concurrent request
2029: --
2030: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
2031: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
2032: := l_request_id;
2033: --
2034: end loop;
2035: --

Line 2042: ben_batch_utils.print_parameters

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
2044: ,p_benefit_action_id => l_benefit_action_id
2045: ,p_validate => p_validate
2046: ,p_business_group_id => p_business_group_id

Line 2053: ben_batch_utils.write(p_text =>

2049: ,p_person_selection_rule_id => p_person_selection_rl
2050: ,p_location_id => p_location_id
2051: );
2052: --
2053: ben_batch_utils.write(p_text =>
2054: 'No person got selected with above selection criteria.');
2055: --
2056: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
2057: fnd_message.raise_error;