DBA Data[Home] [Help]

APPS.BEN_REOPEN_LER_CONC dependencies on BENUTILS

Line 199: benutils.get_parameter (p_business_group_id => p_business_group_id,

195: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
196: --
197: -- Get the parameters defined for the batch process.
198: --
199: benutils.get_parameter (p_business_group_id => p_business_group_id,
200: p_batch_exe_cd => 'BENROLER',
201: p_threads => l_threads,
202: p_chunk_size => l_chunk_size,
203: p_max_errors => g_max_person_err

Line 242: benutils.g_benefit_action_id := l_benefit_action_id;

238: p_program_update_date => SYSDATE,
239: p_date_from => l_from_ocrd_date
240: );
241: --
242: benutils.g_benefit_action_id := l_benefit_action_id;
243: --
244: benutils.g_thread_id := 99;
245: --
246: l_actn := 'Removing batch ranges ';

Line 244: benutils.g_thread_id := 99;

240: );
241: --
242: benutils.g_benefit_action_id := l_benefit_action_id;
243: --
244: benutils.g_thread_id := 99;
245: --
246: l_actn := 'Removing batch ranges ';
247:
248: --

Line 522: benutils.write(p_text => fnd_message.get);

518: --
519: EXCEPTION
520: -- bug: 5589226
521: when l_no_one_to_process then
522: benutils.write(p_text => fnd_message.get);
523: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
524: -- end
525: WHEN OTHERS
526: THEN

Line 523: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

519: EXCEPTION
520: -- bug: 5589226
521: when l_no_one_to_process then
522: benutils.write(p_text => fnd_message.get);
523: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
524: -- end
525: WHEN OTHERS
526: THEN
527: --

Line 541: benutils.WRITE (p_text => fnd_message.get);

537: p_last_actn => l_actn,
538: p_rpt_flag => TRUE
539: );
540: --
541: benutils.WRITE (p_text => fnd_message.get);
542: benutils.WRITE (p_text => SQLERRM);
543: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);
544:
545: --

Line 542: benutils.WRITE (p_text => SQLERRM);

538: p_rpt_flag => TRUE
539: );
540: --
541: benutils.WRITE (p_text => fnd_message.get);
542: benutils.WRITE (p_text => SQLERRM);
543: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);
544:
545: --
546: IF l_num_ranges > 0

Line 543: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);

539: );
540: --
541: benutils.WRITE (p_text => fnd_message.get);
542: benutils.WRITE (p_text => SQLERRM);
543: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);
544:
545: --
546: IF l_num_ranges > 0
547: THEN

Line 682: l_actn := 'Calling benutils.get_parameter...';

678: EXIT WHEN c_ler%NOTFOUND;
679: END LOOP;
680: CLOSE c_ler;
681: --
682: l_actn := 'Calling benutils.get_parameter...';
683: benutils.get_parameter (p_business_group_id => p_business_group_id,
684: p_batch_exe_cd => 'BENROLER',
685: p_threads => l_threads,
686: p_chunk_size => l_chunk_size,

Line 683: benutils.get_parameter (p_business_group_id => p_business_group_id,

679: END LOOP;
680: CLOSE c_ler;
681: --
682: l_actn := 'Calling benutils.get_parameter...';
683: benutils.get_parameter (p_business_group_id => p_business_group_id,
684: p_batch_exe_cd => 'BENROLER',
685: p_threads => l_threads,
686: p_chunk_size => l_chunk_size,
687: p_max_errors => g_max_person_err

Line 706: benutils.g_benefit_action_id := p_benefit_action_id;

702: g_persons_errored := 0;
703: --
704: ben_batch_utils.ini;
705: --
706: benutils.g_benefit_action_id := p_benefit_action_id;
707: benutils.g_thread_id := p_thread_id;
708: --
709: -- Fetch the parameters defined for the batch process.
710: --

Line 707: benutils.g_thread_id := p_thread_id;

703: --
704: ben_batch_utils.ini;
705: --
706: benutils.g_benefit_action_id := p_benefit_action_id;
707: benutils.g_thread_id := p_thread_id;
708: --
709: -- Fetch the parameters defined for the batch process.
710: --
711: OPEN c_parameter;

Line 847: benutils.WRITE (p_text => fnd_message.get);

843: WHERE person_action_id = g_cache_per_proc (l_cnt).person_action_id;
844:
845: fnd_message.set_name ('BEN', 'BEN_94646_LF_EVT_REOPENED');
846: fnd_message.set_token ('LIFE_EVENT', l_ler_name);
847: benutils.WRITE (p_text => fnd_message.get);
848: g_persons_procd := g_persons_procd + 1;
849: --
850: EXCEPTION
851: WHEN OTHERS

Line 882: benutils.WRITE (p_rec => g_rec);

878: g_rec.text := NVL (g_rec.text,NVL (g_rec.text, SUBSTR (SQLERRM, 1, 400)));
879: g_rec.rep_typ_cd := 'ERROR';
880: g_rec.person_id := g_cache_per_proc (l_cnt).person_id;
881:
882: benutils.WRITE (p_rec => g_rec);
883:
884: UPDATE ben_person_actions
885: SET action_status_cd = 'E'
886: WHERE person_action_id = g_cache_per_proc(l_cnt).person_action_id;

Line 917: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);

913: --
914: END IF;
915:
916: --
917: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);
918: --
919: COMMIT;
920: --
921: END LOOP;

Line 924: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);

920: --
921: END LOOP;
922:
923: --
924: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);
925: --
926: COMMIT;
927: --
928: l_actn := 'Calling log_beneadeb_statistics...';

Line 945: benutils.rollback_cache;

941: ROLLBACK;
942: --
943: hr_utility.set_location ('BENROLER Super Error ' || l_proc, 10);
944: hr_utility.set_location (SQLERRM, 10);
945: benutils.rollback_cache;
946: g_rec.rep_typ_cd := 'FATAL';
947: g_rec.text := fnd_message.get;
948: g_rec.person_id := l_person_id;
949:

Line 950: benutils.Write(p_text => benutils.g_banner_minus);

946: g_rec.rep_typ_cd := 'FATAL';
947: g_rec.text := fnd_message.get;
948: g_rec.person_id := l_person_id;
949:
950: benutils.Write(p_text => benutils.g_banner_minus);
951: benutils.WRITE (p_text => SQLERRM);
952: benutils.WRITE (p_rec => g_rec);
953: /*
954: ben_batch_utils.rpt_error (p_proc => l_proc,

Line 951: benutils.WRITE (p_text => SQLERRM);

947: g_rec.text := fnd_message.get;
948: g_rec.person_id := l_person_id;
949:
950: benutils.Write(p_text => benutils.g_banner_minus);
951: benutils.WRITE (p_text => SQLERRM);
952: benutils.WRITE (p_rec => g_rec);
953: /*
954: ben_batch_utils.rpt_error (p_proc => l_proc,
955: p_last_actn => l_actn,

Line 952: benutils.WRITE (p_rec => g_rec);

948: g_rec.person_id := l_person_id;
949:
950: benutils.Write(p_text => benutils.g_banner_minus);
951: benutils.WRITE (p_text => SQLERRM);
952: benutils.WRITE (p_rec => g_rec);
953: /*
954: ben_batch_utils.rpt_error (p_proc => l_proc,
955: p_last_actn => l_actn,
956: p_rpt_flag => TRUE

Line 959: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);

955: p_last_actn => l_actn,
956: p_rpt_flag => TRUE
957: );
958: */
959: benutils.write_table_and_file (p_table => TRUE, p_file => TRUE);
960: --
961: ben_batch_utils.write_logfile
962: (p_num_pers_processed => g_persons_procd,
963: p_num_pers_errored => g_persons_errored