DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on BEN_BATCH_UTILS

Line 1230: ben_batch_utils.WRITE (p_string);

1226:
1227: PROCEDURE WRITE (p_string IN VARCHAR2)
1228: IS
1229: BEGIN
1230: ben_batch_utils.WRITE (p_string);
1231: END;
1232:
1233: --
1234: -- ============================================================================

Line 2927: RAISE ben_batch_utils.g_record_error;

2923: p_pay_proposal_id := l_pay_proposal_id;
2924: p_pay_basis_id := l_pay_basis_id;
2925:
2926: IF(l_error) THEN
2927: RAISE ben_batch_utils.g_record_error;
2928: WRITE('Raising error in process_sal_comp_rates');
2929: END IF;
2930:
2931: END;

Line 3194: RAISE ben_batch_utils.g_record_error;

3190: WRITE ('Pay proposal id and element entry id populated in to the table');
3191: END IF;
3192:
3193: IF(l_error) THEN
3194: RAISE ben_batch_utils.g_record_error;
3195: END IF;
3196:
3197: END;
3198:

Line 3327: RAISE ben_batch_utils.g_record_error;

3323: write_h ('l_element_type_id ' || p_element_type_id);
3324: write_h ('l_input_value_id ' || p_input_value_id);
3325:
3326: IF(l_error) THEN
3327: RAISE ben_batch_utils.g_record_error;
3328: END IF;
3329: END;
3330:
3331: PROCEDURE compensation_object (

Line 3873: RAISE ben_batch_utils.g_record_error;

3869: write_m ('Time after processing non component rates '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
3870:
3871: IF(l_error) THEN
3872: WRITE('Raising exception at compensation_object');
3873: RAISE ben_batch_utils.g_record_error;
3874: END IF;
3875: END;
3876:
3877: --

Line 4332: RAISE ben_batch_utils.g_record_error;

4328: OR l_promo_error)
4329: THEN
4330: l_error := TRUE;
4331: g_person_errored := TRUE;
4332: RAISE ben_batch_utils.g_record_error;
4333: END IF;
4334:
4335: process_life_event(p_person_id
4336: , p_lf_evt_ocrd_date

Line 4621: RAISE ben_batch_utils.g_record_error;

4617: g_cache_cwb_sum_person (p_person_id).status := 'SC';
4618: END IF;
4619: ELSE
4620: g_cache_cwb_sum_person (p_person_id).status := 'E';
4621: RAISE ben_batch_utils.g_record_error;
4622: END IF;
4623: END IF;
4624: else
4625: BEGIN

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

4713: , p_employees_in_bg);
4714: END IF;
4715:
4716: g_persons_errored := g_persons_errored + 1;
4717: ben_batch_utils.rpt_error (p_proc => g_proc, p_last_actn => g_actn, p_rpt_flag => TRUE);
4718:
4719: IF p_person_action_id IS NOT NULL
4720: THEN
4721: ben_person_actions_api.update_person_actions

Line 4771: RAISE ben_batch_utils.g_record_error;

4767: END IF;
4768: WRITE (benutils.get_message_name);
4769: WRITE (fnd_message.get);
4770: WRITE (SQLERRM||' in process_person');
4771: RAISE ben_batch_utils.g_record_error;
4772: END;
4773:
4774: -- ============================================================================
4775: -- << Procedure: Do_Multithread >>

Line 4960: -- removed RAISE ben_batch_utils.g_record_error;

4956: THEN
4957: g_actn := '<> ';
4958: WRITE (g_actn);
4959: fnd_message.set_name ('BEN', 'BEN_93145_MAX_LIMIT_REACHED');
4960: -- removed RAISE ben_batch_utils.g_record_error;
4961: raise g_max_error;
4962: END IF;
4963:
4964: NULL;

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

5111: IF l_comp_reason_count > 0 THEN
5112: l_process_compents := 'Y';
5113: END IF;
5114:
5115: g_actn := 'Calling ben_batch_utils.ini...';
5116: WRITE (g_actn);
5117: write_h ('ben_batch_utils.ini with PROC_INFO');
5118: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5119: g_actn := 'Calling benutils.get_parameter...';

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

5113: END IF;
5114:
5115: g_actn := 'Calling ben_batch_utils.ini...';
5116: WRITE (g_actn);
5117: write_h ('ben_batch_utils.ini with PROC_INFO');
5118: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5119: g_actn := 'Calling benutils.get_parameter...';
5120: WRITE (g_actn);
5121: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '

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

5114:
5115: g_actn := 'Calling ben_batch_utils.ini...';
5116: WRITE (g_actn);
5117: write_h ('ben_batch_utils.ini with PROC_INFO');
5118: ben_batch_utils.ini (p_actn_cd => 'PROC_INFO');
5119: g_actn := 'Calling benutils.get_parameter...';
5120: WRITE (g_actn);
5121: write_h ('benutils.get_parameter with ' || p_bg_id || ' ' || 'BENCWBPP' || ' '
5122: || g_max_errors_allowed

Line 5195: ben_batch_utils.person_selection_rule

5191:
5192: If p_person_selection_rule_id is not NULL then
5193: --
5194: begin
5195: ben_batch_utils.person_selection_rule
5196: (p_person_id => l_person_id
5197: ,p_business_group_id => pl_rec.business_group_id
5198: ,p_person_selection_rule_id=> p_person_selection_rule_id
5199: ,p_effective_date => l_effective_date

Line 5205: Ben_batch_utils.write(p_text =>

5201: ,p_err_message => l_err_message );
5202:
5203: if l_err_message is not null
5204: then
5205: Ben_batch_utils.write(p_text =>
5206: '<< Person id : '||to_char(l_person_id)||' failed.'||
5207: ' Reason : '|| l_err_message ||' >>' );
5208: l_err_message := NULL ;
5209: end if ;

Line 5290: ben_batch_utils.person_selection_rule

5286:
5287: If p_person_selection_rule_id is not NULL then
5288: --
5289: begin
5290: ben_batch_utils.person_selection_rule
5291: (p_person_id => l_person_id
5292: ,p_business_group_id => ps_rec.business_group_id
5293: ,p_person_selection_rule_id=> p_person_selection_rule_id
5294: ,p_effective_date => l_effective_date

Line 5300: Ben_batch_utils.write(p_text =>

5296: ,p_err_message => l_err_message );
5297:
5298: if l_err_message is not null
5299: then
5300: Ben_batch_utils.write(p_text =>
5301: '<< Person id : '||to_char(l_person_id)||' failed.'||
5302: ' Reason : '|| l_err_message ||' >>' );
5303: l_err_message := NULL ;
5304: end if ;

Line 5388: ben_batch_utils.g_num_processes := 0;

5384: g_actn := 'Submitting job to con-current manager...';
5385: WRITE (g_actn);
5386: g_actn := 'Preparing for launching concurrent requests';
5387: WRITE (g_actn);
5388: ben_batch_utils.g_num_processes := 0;
5389: ben_batch_utils.g_processes_tbl.DELETE;
5390:
5391: write_m ('Time before launching the threads '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5392:

Line 5389: ben_batch_utils.g_processes_tbl.DELETE;

5385: WRITE (g_actn);
5386: g_actn := 'Preparing for launching concurrent requests';
5387: WRITE (g_actn);
5388: ben_batch_utils.g_num_processes := 0;
5389: ben_batch_utils.g_processes_tbl.DELETE;
5390:
5391: write_m ('Time before launching the threads '||to_char(sysdate,'yyyy/mm/dd:hh:mi:ssam'));
5392:
5393: IF l_num_ranges > 1

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

5412: , argument6 => p_is_force_on_per
5413: , argument7 => p_is_self_service
5414: , argument8 => p_use_rate_start_date
5415: );
5416: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
5417: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) := l_request_id;
5418: write_m ('request id for this thread ' || l_request_id);
5419: COMMIT;
5420: END LOOP;

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

5413: , argument7 => p_is_self_service
5414: , argument8 => p_use_rate_start_date
5415: );
5416: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
5417: ben_batch_utils.g_processes_tbl (ben_batch_utils.g_num_processes) := l_request_id;
5418: write_m ('request id for this thread ' || l_request_id);
5419: COMMIT;
5420: END LOOP;
5421: ELSIF l_num_ranges = 0

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

5443: , p_is_force_on_per => p_is_force_on_per
5444: , p_is_self_service => p_is_self_service
5445: , p_use_rate_start_date => p_use_rate_start_date
5446: );
5447: g_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
5448: WRITE (g_actn);
5449:
5450: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5451: g_actn := 'Calling end_process...';

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

5446: );
5447: g_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
5448: WRITE (g_actn);
5449:
5450: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5451: g_actn := 'Calling end_process...';
5452: WRITE (g_actn);
5453:
5454: write_h ('=====================End Process==========');

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

5475: g_actn := 'Finished Process Procedure...';
5476: WRITE (g_actn);
5477:
5478: BEGIN
5479: For l_count in 1..ben_batch_utils.g_num_processes loop
5480: open c_slaves(ben_batch_utils.g_processes_tbl(l_count));
5481: fetch c_slaves into l_dummy;
5482: If c_slaves%found then
5483: close c_slaves;

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

5476: WRITE (g_actn);
5477:
5478: BEGIN
5479: For l_count in 1..ben_batch_utils.g_num_processes loop
5480: open c_slaves(ben_batch_utils.g_processes_tbl(l_count));
5481: fetch c_slaves into l_dummy;
5482: If c_slaves%found then
5483: close c_slaves;
5484: raise l_slave_errored;

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

5500: THEN
5501: WRITE (fnd_message.get);
5502: IF (l_num_ranges > 0) THEN
5503: WRITE('END_PROCESS');
5504: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5505: end_process (p_benefit_action_id => l_benefit_action_id
5506: , p_person_selected => l_num_persons
5507: , p_business_group_id => p_bg_id
5508: );

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

5513: WRITE (SQLERRM);
5514: WRITE ('Big Error Occurred');
5515: IF (l_num_ranges > 0) THEN
5516: WRITE('END_PROCESS');
5517: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5518: end_process (p_benefit_action_id => l_benefit_action_id
5519: , p_person_selected => l_num_persons
5520: , p_business_group_id => p_bg_id
5521: );

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

5531: WRITE (SQLERRM);
5532: WRITE ('Big Error Occurred');
5533: IF (l_num_ranges > 0) THEN
5534: WRITE('END_PROCESS');
5535: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5536: end_process (p_benefit_action_id => l_benefit_action_id
5537: , p_person_selected => l_num_persons
5538: , p_business_group_id => p_bg_id
5539: );

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

5548: WRITE (SQLERRM);
5549: WRITE ('Big Error Occurred');
5550: IF (l_num_ranges > 0) THEN
5551: WRITE('END_PROCESS');
5552: ben_batch_utils.check_all_slaves_finished (p_rpt_flag => TRUE);
5553: end_process (p_benefit_action_id => l_benefit_action_id
5554: , p_person_selected => l_num_persons
5555: , p_business_group_id => p_bg_id
5556: );