DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on BEN_BATCH_UTILS

Line 1250: ben_batch_utils.WRITE (p_string);

1246:
1247: PROCEDURE WRITE (p_string IN VARCHAR2)
1248: IS
1249: BEGIN
1250: ben_batch_utils.WRITE (p_string);
1251: END;
1252:
1253: --
1254: -- ============================================================================

Line 2954: RAISE ben_batch_utils.g_record_error;

2950: p_pay_proposal_id := l_pay_proposal_id;
2951: p_pay_basis_id := l_pay_basis_id;
2952:
2953: IF(l_error) THEN
2954: RAISE ben_batch_utils.g_record_error;
2955: WRITE('Raising error in process_sal_comp_rates');
2956: END IF;
2957:
2958: END;

Line 3221: RAISE ben_batch_utils.g_record_error;

3217: WRITE ('Pay proposal id and element entry id populated in to the table');
3218: END IF;
3219:
3220: IF(l_error) THEN
3221: RAISE ben_batch_utils.g_record_error;
3222: END IF;
3223:
3224: END;
3225:

Line 3354: RAISE ben_batch_utils.g_record_error;

3350: write_h ('l_element_type_id ' || p_element_type_id);
3351: write_h ('l_input_value_id ' || p_input_value_id);
3352:
3353: IF(l_error) THEN
3354: RAISE ben_batch_utils.g_record_error;
3355: END IF;
3356: END;
3357:
3358: PROCEDURE compensation_object (

Line 3935: RAISE ben_batch_utils.g_record_error;

3931: write_m ('Time after processing non component rates '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
3932:
3933: IF(l_error) THEN
3934: WRITE('Raising exception at compensation_object');
3935: RAISE ben_batch_utils.g_record_error;
3936: END IF;
3937: END;
3938:
3939: --

Line 4409: RAISE ben_batch_utils.g_record_error;

4405: OR l_promo_error)
4406: THEN
4407: l_error := TRUE;
4408: g_person_errored := TRUE;
4409: RAISE ben_batch_utils.g_record_error;
4410: END IF;
4411:
4412: process_life_event(p_person_id
4413: , p_lf_evt_ocrd_date

Line 4698: RAISE ben_batch_utils.g_record_error;

4694: g_cache_cwb_sum_person (p_person_id).status := 'SC';
4695: END IF;
4696: ELSE
4697: g_cache_cwb_sum_person (p_person_id).status := 'E';
4698: RAISE ben_batch_utils.g_record_error;
4699: END IF;
4700: END IF;
4701: else
4702: BEGIN

Line 4794: ben_batch_utils.rpt_error (p_proc => g_proc, p_last_actn => g_actn, p_rpt_flag => TRUE);

4790: , p_employees_in_bg);
4791: END IF;
4792:
4793: g_persons_errored := g_persons_errored + 1;
4794: ben_batch_utils.rpt_error (p_proc => g_proc, p_last_actn => g_actn, p_rpt_flag => TRUE);
4795:
4796: IF p_person_action_id IS NOT NULL
4797: THEN
4798: ben_person_actions_api.update_person_actions

Line 4848: RAISE ben_batch_utils.g_record_error;

4844: END IF;
4845: WRITE (benutils.get_message_name);
4846: WRITE (fnd_message.get);
4847: WRITE (SQLERRM||' in process_person');
4848: RAISE ben_batch_utils.g_record_error;
4849: END;
4850:
4851: -- ============================================================================
4852: -- << Procedure: Do_Multithread >>

Line 5037: -- removed RAISE ben_batch_utils.g_record_error;

5033: THEN
5034: g_actn := '<> ';
5035: WRITE (g_actn);
5036: fnd_message.set_name ('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
5037: -- removed RAISE ben_batch_utils.g_record_error;
5038: raise g_max_error;
5039: END IF;
5040:
5041: NULL;

Line 5192: g_actn := 'Calling ben_batch_utils.ini...';

5188: IF l_comp_reason_count > 0 THEN
5189: l_process_compents := 'Y';
5190: END IF;
5191:
5192: g_actn := 'Calling ben_batch_utils.ini...';
5193: WRITE (g_actn);
5194: write_h ('ben_batch_utils.ini with PROC_INFO');
5195: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5196: g_actn := 'Calling benutils.get_parameter...';

Line 5194: write_h ('ben_batch_utils.ini with PROC_INFO');

5190: END IF;
5191:
5192: g_actn := 'Calling ben_batch_utils.ini...';
5193: WRITE (g_actn);
5194: write_h ('ben_batch_utils.ini with PROC_INFO');
5195: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5196: g_actn := 'Calling benutils.get_parameter...';
5197: WRITE (g_actn);
5198: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '

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

5191:
5192: g_actn := 'Calling ben_batch_utils.ini...';
5193: WRITE (g_actn);
5194: write_h ('ben_batch_utils.ini with PROC_INFO');
5195: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5196: g_actn := 'Calling benutils.get_parameter...';
5197: WRITE (g_actn);
5198: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5199: || g_max_errors_allowed

Line 5272: ben_batch_utils.person_selection_rule

5268:
5269: If p_person_selection_rule_id is not NULL then
5270: --
5271: begin
5272: ben_batch_utils.person_selection_rule
5273: (p_person_id => l_person_id
5274: ,p_business_group_id => pl_rec.business_group_id
5275: ,p_person_selection_rule_id=> p_person_selection_rule_id
5276: ,p_effective_date => l_effective_date

Line 5282: Ben_batch_utils.write(p_text =>

5278: ,p_err_message => l_err_message );
5279:
5280: if l_err_message is not null
5281: then
5282: Ben_batch_utils.write(p_text =>
5283: '<< Person id : '||to_char(l_person_id)||' failed.'||
5284: ' Reason : '|| l_err_message ||' >>' );
5285: l_err_message := NULL ;
5286: end if ;

Line 5367: ben_batch_utils.person_selection_rule

5363:
5364: If p_person_selection_rule_id is not NULL then
5365: --
5366: begin
5367: ben_batch_utils.person_selection_rule
5368: (p_person_id => l_person_id
5369: ,p_business_group_id => ps_rec.business_group_id
5370: ,p_person_selection_rule_id=> p_person_selection_rule_id
5371: ,p_effective_date => l_effective_date

Line 5377: Ben_batch_utils.write(p_text =>

5373: ,p_err_message => l_err_message );
5374:
5375: if l_err_message is not null
5376: then
5377: Ben_batch_utils.write(p_text =>
5378: '<< Person id : '||to_char(l_person_id)||' failed.'||
5379: ' Reason : '|| l_err_message ||' >>' );
5380: l_err_message := NULL ;
5381: end if ;

Line 5465: ben_batch_utils.g_num_processes := 0;

5461: g_actn := 'Submitting job to con-current manager...';
5462: WRITE (g_actn);
5463: g_actn := 'Preparing for launching concurrent requests';
5464: WRITE (g_actn);
5465: ben_batch_utils.g_num_processes := 0;
5466: ben_batch_utils.g_processes_tbl.DELETE;
5467:
5468: write_m ('Time before launching the threads '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5469:

Line 5466: ben_batch_utils.g_processes_tbl.DELETE;

5462: WRITE (g_actn);
5463: g_actn := 'Preparing for launching concurrent requests';
5464: WRITE (g_actn);
5465: ben_batch_utils.g_num_processes := 0;
5466: ben_batch_utils.g_processes_tbl.DELETE;
5467:
5468: write_m ('Time before launching the threads '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5469:
5470: IF l_num_ranges > 1

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

5489: , argument6 => p_is_force_on_per
5490: , argument7 => p_is_self_service
5491: , argument8 => p_use_rate_start_date
5492: );
5493: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
5494: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) := l_request_id;
5495: write_m ('request id for this thread ' || l_request_id);
5496: COMMIT;
5497: END LOOP;

Line 5494: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) := l_request_id;

5490: , argument7 => p_is_self_service
5491: , argument8 => p_use_rate_start_date
5492: );
5493: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
5494: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) := l_request_id;
5495: write_m ('request id for this thread ' || l_request_id);
5496: COMMIT;
5497: END LOOP;
5498: ELSIF l_num_ranges = 0

Line 5524: g_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';

5520: , p_is_force_on_per => p_is_force_on_per
5521: , p_is_self_service => p_is_self_service
5522: , p_use_rate_start_date => p_use_rate_start_date
5523: );
5524: g_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
5525: WRITE (g_actn);
5526:
5527: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5528: g_actn := 'Calling end_process...';

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

5523: );
5524: g_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
5525: WRITE (g_actn);
5526:
5527: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5528: g_actn := 'Calling end_process...';
5529: WRITE (g_actn);
5530:
5531: write_h ('=====================End Process==========');

Line 5556: For l_count in 1..ben_batch_utils.g_num_processes loop

5552: g_actn := 'Finished Process Procedure...';
5553: WRITE (g_actn);
5554:
5555: BEGIN
5556: For l_count in 1..ben_batch_utils.g_num_processes loop
5557: open c_slaves(ben_batch_utils.g_processes_tbl(l_count));
5558: fetch c_slaves into l_dummy;
5559: If c_slaves%found then
5560: close c_slaves;

Line 5557: open c_slaves(ben_batch_utils.g_processes_tbl(l_count));

5553: WRITE (g_actn);
5554:
5555: BEGIN
5556: For l_count in 1..ben_batch_utils.g_num_processes loop
5557: open c_slaves(ben_batch_utils.g_processes_tbl(l_count));
5558: fetch c_slaves into l_dummy;
5559: If c_slaves%found then
5560: close c_slaves;
5561: raise l_slave_errored;

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

5577: THEN
5578: WRITE (fnd_message.get);
5579: IF (l_num_ranges > 0) THEN
5580: WRITE('END_PROCESS');
5581: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5582: end_process (p_benefit_action_id => l_benefit_action_id
5583: , p_person_selected => l_num_persons
5584: , p_business_group_id => p_bg_id
5585: );

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

5590: WRITE (SQLERRM);
5591: WRITE ('Big Error Occurred');
5592: IF (l_num_ranges > 0) THEN
5593: WRITE('END_PROCESS');
5594: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5595: end_process (p_benefit_action_id => l_benefit_action_id
5596: , p_person_selected => l_num_persons
5597: , p_business_group_id => p_bg_id
5598: );

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

5608: WRITE (SQLERRM);
5609: WRITE ('Big Error Occurred');
5610: IF (l_num_ranges > 0) THEN
5611: WRITE('END_PROCESS');
5612: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5613: end_process (p_benefit_action_id => l_benefit_action_id
5614: , p_person_selected => l_num_persons
5615: , p_business_group_id => p_bg_id
5616: );

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

5625: WRITE (SQLERRM);
5626: WRITE ('Big Error Occurred');
5627: IF (l_num_ranges > 0) THEN
5628: WRITE('END_PROCESS');
5629: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5630: end_process (p_benefit_action_id => l_benefit_action_id
5631: , p_person_selected => l_num_persons
5632: , p_business_group_id => p_bg_id
5633: );