[Home] [Help]
150: l_actn := 'Calling ben_batch_rate_info_api.create_batch_rate_info...';
151: --
152: ben_batch_rate_info_api.create_batch_rate_info
153: (p_batch_rt_id => l_id
154: ,p_benefit_action_id => benutils.g_benefit_action_id
155: ,p_person_id => p_person_id
156: ,p_pgm_id => l_cache(i).pgm_id
157: ,p_pl_id => l_cache(i).pl_id
158: ,p_oipl_id => l_cache(i).oipl_id
175: --
176: ben_batch_dpnt_info_api.create_batch_dpnt_info
177: (p_batch_dpnt_id => l_id
178: ,p_person_id => p_person_id
179: ,p_benefit_action_id => benutils.g_benefit_action_id
180: ,p_business_group_id => p_business_group_id
181: ,p_enrt_cvg_strt_dt => g_dpnt_tbl(i).cvg_strt_dt
182: ,p_enrt_cvg_thru_dt => g_dpnt_tbl(i).cvg_end_dt
183: ,p_actn_cd => to_char(g_dpnt_tbl(i).prtt_enrt_rslt_id)
192: --
193: l_actn := 'Calling create_batch_actn_item_info...';
194: ben_batch_actn_item_info_api.create_batch_actn_item_info
195: (p_batch_actn_item_id => l_id
196: ,p_benefit_action_id => benutils.g_benefit_action_id
197: ,p_person_id => p_person_id
198: ,p_actn_typ_id => g_actn_tbl(i).actn_typ_id
199: ,p_cmpltd_dt => g_actn_tbl(i).cmpltd_dt
200: ,p_due_dt => g_actn_tbl(i).due_dt
213: l_actn := 'Calling create_batch_bnft_cert_info (Certification)...';
214: --
215: ben_batch_bnft_cert_info_api.create_batch_bnft_cert_info
216: (p_batch_benft_cert_id => l_id
217: ,p_benefit_action_id => benutils.g_benefit_action_id
218: ,p_person_id => p_person_id
219: ,p_actn_typ_id => g_cert_tbl(i).actn_typ_id
220: ,p_typ_cd => 'C' ||
221: to_char(g_cert_tbl(i).prtt_enrt_rslt_id)
231: l_actn := 'Calling create_batch_bnft_cert_info (Beneficiary)...';
232: --
233: ben_batch_bnft_cert_info_api.create_batch_bnft_cert_info
234: (p_batch_benft_cert_id => l_id
235: ,p_benefit_action_id => benutils.g_benefit_action_id
236: ,p_person_id => p_person_id
237: ,p_typ_cd => 'B' ||
238: to_char(g_bnf_tbl(i).prtt_enrt_rslt_id)
239: ,p_actn_typ_id => g_bnf_tbl(i).bnf_person_id
1113: ,p_actn_cd => l_actn_cd);
1114: --
1115: If (l_actn_cd = 'D') then
1116: --
1117: benutils.write
1118: (p_text => '> Enrollment(' ||
1119: to_char(l_process_rec(i).prtt_enrt_rslt_id) || ') Ended ');
1120: --
1121: Elsif (l_actn_cd = 'U') then
1119: to_char(l_process_rec(i).prtt_enrt_rslt_id) || ') Ended ');
1120: --
1121: Elsif (l_actn_cd = 'U') then
1122: --
1123: benutils.write
1124: (p_text => '> Enrollment(' ||
1125: to_char(l_process_rec(i).prtt_enrt_rslt_id) || ') unsuspended ');
1126: --
1127: End if;
1253: );
1254: --
1255: If (l_actn_cd = 'D') then
1256: --
1257: benutils.write
1258: (p_text => '> Enrollment(' ||
1259: to_char(l_process_rec(i).prtt_enrt_rslt_id) || ') Ended ');
1260: --
1261: Elsif (l_actn_cd = 'U') then
1259: to_char(l_process_rec(i).prtt_enrt_rslt_id) || ') Ended ');
1260: --
1261: Elsif (l_actn_cd = 'U') then
1262: --
1263: benutils.write
1264: (p_text => '> Enrollment(' ||
1265: to_char(l_process_rec(i).prtt_enrt_rslt_id) || ') unsuspended ');
1266: --
1267: End if;
1295: ,p_effective_date => p_effective_date);
1296: --
1297: End if;
1298: --
1299: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
1300: g_persons_procd := g_persons_procd + 1;
1301: --
1302: End if;
1303: --
1341: ,p_business_group_id => p_business_group_id
1342: ,p_person_id => p_person_id
1343: ,p_effective_date => p_effective_date);
1344: --
1345: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
1346: --
1347: End if;
1348: --
1349: fnd_message.raise_error;
1444: dt_fndate.change_ses_date
1445: (p_ses_date => l_effective_date,
1446: p_commit => l_commit);
1447: --
1448: l_actn := 'Calling benutils.get_parameter...';
1449: benutils.get_parameter(p_business_group_id => p_business_group_Id
1450: ,p_batch_exe_cd => 'BENUNEAI'
1451: ,p_threads => l_threads
1452: ,p_chunk_size => l_chunk_size
1445: (p_ses_date => l_effective_date,
1446: p_commit => l_commit);
1447: --
1448: l_actn := 'Calling benutils.get_parameter...';
1449: benutils.get_parameter(p_business_group_id => p_business_group_Id
1450: ,p_batch_exe_cd => 'BENUNEAI'
1451: ,p_threads => l_threads
1452: ,p_chunk_size => l_chunk_size
1453: ,p_max_errors => g_max_person_err);
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: --
1473: open c_master;
1474: fetch c_master into l_master;
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: --
1473: open c_master;
1474: fetch c_master into l_master;
1475: close c_master;
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);
1610: benutils.write(p_text => sqlerrm);
1611: --
1612: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1613: --
1606: ,p_last_actn => l_actn
1607: ,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
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);
1619: --
1620: commit;
1621: --
1622: fnd_message.raise_error;
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
1813: ,p_batch_exe_cd => 'BENUNEAI'
1814: ,p_threads => l_threads
1815: ,p_chunk_size => l_chunk_size
1816: ,p_max_errors => g_max_person_err);
1858: ,p_program_application_id => fnd_global.prog_appl_id
1859: ,p_program_id => fnd_global.conc_program_id
1860: ,p_program_update_date => sysdate);
1861: --
1862: benutils.g_benefit_action_id := l_benefit_action_id;
1863: benutils.g_thread_id := 99;
1864: --
1865: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
1866: -- create person actions for the selected people.
1859: ,p_program_id => fnd_global.conc_program_id
1860: ,p_program_update_date => sysdate);
1861: --
1862: benutils.g_benefit_action_id := l_benefit_action_id;
1863: benutils.g_thread_id := 99;
1864: --
1865: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
1866: -- create person actions for the selected people.
1867: --