49: --
50: PROCEDURE WRITE (p_string IN VARCHAR2)
51: IS
52: BEGIN
53: ben_batch_utils.WRITE (p_string);
54: END WRITE ;
55:
56:
57: --
2431: g_exec_param_rec.start_date := SYSDATE;
2432: g_exec_param_rec.start_time := DBMS_UTILITY.get_time;
2433: g_validate := p_validate ;
2434:
2435: g_actn := 'Calling ben_batch_utils.ini...';
2436: hr_utility.set_location (g_actn,151);
2437: hr_utility.set_location ('ben_batch_utils.ini with PROC_INFO',152);
2438: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
2439:
2433: g_validate := p_validate ;
2434:
2435: g_actn := 'Calling ben_batch_utils.ini...';
2436: hr_utility.set_location (g_actn,151);
2437: hr_utility.set_location ('ben_batch_utils.ini with PROC_INFO',152);
2438: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
2439:
2440: g_actn := 'Calling benutils.get_parameter...';
2441: WRITE (g_actn);
2434:
2435: g_actn := 'Calling ben_batch_utils.ini...';
2436: hr_utility.set_location (g_actn,151);
2437: hr_utility.set_location ('ben_batch_utils.ini with PROC_INFO',152);
2438: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
2439:
2440: g_actn := 'Calling benutils.get_parameter...';
2441: WRITE (g_actn);
2442: hr_utility.set_location(g_actn,153);
3522: WRITE (g_actn);
3523: g_actn := 'Preparing for launching concurrent requests';
3524: WRITE (g_actn);
3525:
3526: ben_batch_utils.g_num_processes := 0;
3527: ben_batch_utils.g_processes_tbl.DELETE;
3528: WRITE ( 'Time before launching the threads '
3529: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
3530:
3523: g_actn := 'Preparing for launching concurrent requests';
3524: WRITE (g_actn);
3525:
3526: ben_batch_utils.g_num_processes := 0;
3527: ben_batch_utils.g_processes_tbl.DELETE;
3528: WRITE ( 'Time before launching the threads '
3529: || TO_CHAR (SYSDATE, 'yyyy/mm/dd:hh:mi:ssam'));
3530:
3531: IF l_num_ranges > 1
3557: argument6 => p_run_type,
3558: argument7 => l_period_start_date ,
3559: argument8 => l_period_end_date
3560: );
3561: ben_batch_utils.g_num_processes :=
3562: ben_batch_utils.g_num_processes + 1;
3563: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) :=
3564: l_request_id;
3565: hr_utility.set_location ('request id for this thread ' || l_request_id,160);
3558: argument7 => l_period_start_date ,
3559: argument8 => l_period_end_date
3560: );
3561: ben_batch_utils.g_num_processes :=
3562: ben_batch_utils.g_num_processes + 1;
3563: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) :=
3564: l_request_id;
3565: hr_utility.set_location ('request id for this thread ' || l_request_id,160);
3566: COMMIT;
3559: argument8 => l_period_end_date
3560: );
3561: ben_batch_utils.g_num_processes :=
3562: ben_batch_utils.g_num_processes + 1;
3563: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) :=
3564: l_request_id;
3565: hr_utility.set_location ('request id for this thread ' || l_request_id,160);
3566: COMMIT;
3567: END LOOP;
3592: p_start_date => l_period_start_date,
3593: p_end_date => l_period_end_date
3594: );
3595:
3596: g_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
3597: WRITE (g_actn);
3598: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
3599:
3600: WRITE ('=====================End Process==========');
3594: );
3595:
3596: g_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
3597: WRITE (g_actn);
3598: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
3599:
3600: WRITE ('=====================End Process==========');
3601: WRITE ('||Parameter value ');
3602: WRITE ('||p_benefit_action_id- ' || l_benefit_action_id);
3666: EXCEPTION
3667: --
3668: WHEN l_silent_error
3669: THEN
3670: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
3671: delete_hrchy;
3672: end_process (p_benefit_action_id => l_benefit_action_id
3673: , p_person_selected => l_num_persons
3674: , p_business_group_id => l_business_group_id
3679: WRITE (fnd_message.get);
3680: WRITE (SQLERRM);
3681: WRITE ('Error Occurred');
3682:
3683: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
3684: end_process (p_benefit_action_id => l_benefit_action_id
3685: , p_person_selected => l_num_persons
3686: , p_business_group_id => l_business_group_id
3687: );