eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PREMIUM_CONCURRENT dependencies on BEN_BATCH_UTILS

Line 60: -- << Procedure: ben_batch_utils.batch_report >>

56: g_persons_errored number(9) := 0;
57: g_max_errors_allowed number(9) := 200;
58: --
59: -- ===========================================================================
60: -- << Procedure: ben_batch_utils.batch_report >>
61: -- ===========================================================================
62: --
63: Procedure Submit_all_reports (p_rpt_flag Boolean default FALSE) is
64: l_proc varchar2(80) := g_package||'.submit_all_reports';

Line 69: l_actn := 'Calling ben_batch_utils.batch_report (BENPRSUM)...';

65: l_actn varchar2(80);
66: l_request_id number;
67: Begin
68: hr_utility.set_location ('Entering '||l_proc,05);
69: l_actn := 'Calling ben_batch_utils.batch_report (BENPRSUM)...';
70: ben_batch_utils.batch_report
71: (p_concurrent_request_id => fnd_global.conc_request_id
72: ,p_program_name => 'BENPRSUM'
73: ,p_request_id => l_request_id

Line 70: ben_batch_utils.batch_report

66: l_request_id number;
67: Begin
68: hr_utility.set_location ('Entering '||l_proc,05);
69: l_actn := 'Calling ben_batch_utils.batch_report (BENPRSUM)...';
70: ben_batch_utils.batch_report
71: (p_concurrent_request_id => fnd_global.conc_request_id
72: ,p_program_name => 'BENPRSUM'
73: ,p_request_id => l_request_id
74: );

Line 75: l_actn := 'Calling ben_batch_utils.batch_report (BENPRDEA)...';

71: (p_concurrent_request_id => fnd_global.conc_request_id
72: ,p_program_name => 'BENPRSUM'
73: ,p_request_id => l_request_id
74: );
75: l_actn := 'Calling ben_batch_utils.batch_report (BENPRDEA)...';
76: ben_batch_utils.batch_report
77: (p_concurrent_request_id => fnd_global.conc_request_id
78: ,p_program_name => 'BENPRDEA'
79: ,p_request_id => l_request_id

Line 76: ben_batch_utils.batch_report

72: ,p_program_name => 'BENPRSUM'
73: ,p_request_id => l_request_id
74: );
75: l_actn := 'Calling ben_batch_utils.batch_report (BENPRDEA)...';
76: ben_batch_utils.batch_report
77: (p_concurrent_request_id => fnd_global.conc_request_id
78: ,p_program_name => 'BENPRDEA'
79: ,p_request_id => l_request_id
80: );

Line 81: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';

77: (p_concurrent_request_id => fnd_global.conc_request_id
78: ,p_program_name => 'BENPRDEA'
79: ,p_request_id => l_request_id
80: );
81: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';
82: ben_batch_utils.batch_report
83: (p_concurrent_request_id => fnd_global.conc_request_id
84: ,p_program_name => 'BENERTYP'
85: ,p_request_id => l_request_id

Line 82: ben_batch_utils.batch_report

78: ,p_program_name => 'BENPRDEA'
79: ,p_request_id => l_request_id
80: );
81: l_actn := 'Calling ben_batch_utils.batch_report (BENERTYP)...';
82: ben_batch_utils.batch_report
83: (p_concurrent_request_id => fnd_global.conc_request_id
84: ,p_program_name => 'BENERTYP'
85: ,p_request_id => l_request_id
86: );

Line 87: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';

83: (p_concurrent_request_id => fnd_global.conc_request_id
84: ,p_program_name => 'BENERTYP'
85: ,p_request_id => l_request_id
86: );
87: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';
88: ben_batch_utils.batch_report
89: (p_concurrent_request_id => fnd_global.conc_request_id
90: ,p_program_name => 'BENERPER'
91: ,p_request_id => l_request_id

Line 88: ben_batch_utils.batch_report

84: ,p_program_name => 'BENERTYP'
85: ,p_request_id => l_request_id
86: );
87: l_actn := 'Calling ben_batch_utils.batch_report (BENERPER)...';
88: ben_batch_utils.batch_report
89: (p_concurrent_request_id => fnd_global.conc_request_id
90: ,p_program_name => 'BENERPER'
91: ,p_request_id => l_request_id
92: );

Line 97: ben_batch_utils.rpt_error(p_proc => l_proc

93:
94: hr_utility.set_location ('Leaving '||l_proc,10);
95: Exception
96: When others then
97: ben_batch_utils.rpt_error(p_proc => l_proc
98: ,p_last_actn => l_actn
99: ,p_rpt_flag => p_rpt_flag
100: );
101: raise;

Line 147: raise ben_batch_utils.g_record_error;

143: l_actn := 'Opening C1 Assignment cursor...';
144: open c1;
145: fetch c1 into l_assignment_id;
146: If c1%notfound then
147: raise ben_batch_utils.g_record_error;
148: End if;
149: close c1;
150: -- Call formula initialise routine
151: --

Line 173: When ben_batch_utils.g_record_error then

169: End if;
170: --p_return := 'Y';
171: hr_utility.set_location ('Leaving '||l_proc,10);
172: Exception
173: When ben_batch_utils.g_record_error then
174: p_return := 'N' ;
175: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
176: fnd_message.set_token('ID' ,to_char(p_person_id) );
177: fnd_message.set_token('PROC',l_proc ) ;

Line 297: l_actn := 'Calling ben_batch_utils.ini...';

293: p_threads => l_threads,
294: p_max_errors => g_max_errors_allowed,
295: p_benefit_action_id => p_benefit_action_id);
296: --
297: l_actn := 'Calling ben_batch_utils.ini...';
298: ben_batch_utils.ini;
299: --
300: -- Copy benefit action id to global in benutils package
301: --

Line 298: ben_batch_utils.ini;

294: p_max_errors => g_max_errors_allowed,
295: p_benefit_action_id => p_benefit_action_id);
296: --
297: l_actn := 'Calling ben_batch_utils.ini...';
298: ben_batch_utils.ini;
299: --
300: -- Copy benefit action id to global in benutils package
301: --
302: benutils.g_benefit_action_id := p_benefit_action_id;

Line 310: l_actn := 'Calling ben_batch_utils.print_parameters...';

306: open c_parameter;
307: fetch c_parameter into l_parm;
308: close c_parameter;
309: --
310: l_actn := 'Calling ben_batch_utils.print_parameters...';
311: --
312: ben_batch_utils.print_parameters
313: (p_thread_id => p_thread_id
314: ,p_benefit_action_id => p_benefit_action_id

Line 312: ben_batch_utils.print_parameters

308: close c_parameter;
309: --
310: l_actn := 'Calling ben_batch_utils.print_parameters...';
311: --
312: ben_batch_utils.print_parameters
313: (p_thread_id => p_thread_id
314: ,p_benefit_action_id => p_benefit_action_id
315: ,p_validate => p_validate
316: ,p_business_group_id => p_business_group_id

Line 432: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

428: End loop;
429: benutils.write_table_and_file(p_table => TRUE, p_file => FALSE);
430: --
431: l_actn := 'Calling Log_statistics...';
432: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
433: ,p_num_pers_errored => g_persons_errored
434: );
435: hr_utility.set_location ('Leaving '||l_proc,70);
436: Exception

Line 442: ben_batch_utils.rpt_error(p_proc => l_proc

438: l_error_text := sqlerrm;
439: hr_utility.set_location ('Fail in '||l_proc,998);
440: hr_utility.set_location (' with error '||l_error_text,999);
441:
442: ben_batch_utils.rpt_error(p_proc => l_proc
443: ,p_last_actn => l_actn
444: ,p_rpt_flag => TRUE
445: );
446: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

Line 446: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

442: ben_batch_utils.rpt_error(p_proc => l_proc
443: ,p_last_actn => l_actn
444: ,p_rpt_flag => TRUE
445: );
446: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
447: ,p_num_pers_errored => g_persons_errored
448: );
449: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
450: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 501: ben_batch_utils.rpt_error(p_proc => l_proc

497: l_actn := 'Getting parameter data...';
498: open c_parameters;
499: fetch c_parameters into l_parameters;
500: If c_parameters%notfound then
501: ben_batch_utils.rpt_error(p_proc => l_proc
502: ,p_last_actn => l_actn
503: ,p_rpt_flag => TRUE
504: );
505: hr_utility.set_location ('BEN_91710_RESTRT_PARMS_NOT_FND',778);

Line 533: ben_batch_utils.rpt_error(p_proc => l_proc

529: );
530: hr_utility.set_location ('Leaving '||l_proc,70);
531: Exception
532: when others then
533: ben_batch_utils.rpt_error(p_proc => l_proc
534: ,p_last_actn => l_actn
535: ,p_rpt_flag => TRUE
536: );
537: raise;

Line 658: l_actn := 'Initialize the ben_batch_utils cache...';

654: l_first_day_of_month_char := to_char(l_first_day_of_month,'YYYY/MM/DD HH24:MI:SS');
655: l_mo_num := to_char(l_effective_date,'MM');
656: l_yr_num := to_char(l_effective_date,'RRRR');
657: --
658: l_actn := 'Initialize the ben_batch_utils cache...';
659: ben_batch_utils.ini;
660: l_actn := 'Initialize the ben_batch_utils cache...';
661: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
662: --

Line 659: ben_batch_utils.ini;

655: l_mo_num := to_char(l_effective_date,'MM');
656: l_yr_num := to_char(l_effective_date,'RRRR');
657: --
658: l_actn := 'Initialize the ben_batch_utils cache...';
659: ben_batch_utils.ini;
660: l_actn := 'Initialize the ben_batch_utils cache...';
661: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
662: --
663: -- Check that all the mandatory input parameters

Line 660: l_actn := 'Initialize the ben_batch_utils cache...';

656: l_yr_num := to_char(l_effective_date,'RRRR');
657: --
658: l_actn := 'Initialize the ben_batch_utils cache...';
659: ben_batch_utils.ini;
660: l_actn := 'Initialize the ben_batch_utils cache...';
661: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
662: --
663: -- Check that all the mandatory input parameters
664: -- such as p_business_group_id, p_mode, p_effective_date

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

657: --
658: l_actn := 'Initialize the ben_batch_utils cache...';
659: ben_batch_utils.ini;
660: l_actn := 'Initialize the ben_batch_utils cache...';
661: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
662: --
663: -- Check that all the mandatory input parameters
664: -- such as p_business_group_id, p_mode, p_effective_date
665: --

Line 771: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';

767: -- tar no - 13530340.6
768: Begin
769: l_err_message := null ;
770: If (p_person_selection_rule_id is not NULL) then
771: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';
772: /* rl_ret := ben_batch_utils.person_selection_rule
773: (p_person_id => l_person_id
774: ,p_business_group_id => p_business_group_id
775: ,p_person_selection_rule_id=> p_person_selection_rule_id

Line 772: /* rl_ret := ben_batch_utils.person_selection_rule

768: Begin
769: l_err_message := null ;
770: If (p_person_selection_rule_id is not NULL) then
771: l_actn := 'Calling Ben_batch_utils.person_selection_rule...';
772: /* rl_ret := ben_batch_utils.person_selection_rule
773: (p_person_id => l_person_id
774: ,p_business_group_id => p_business_group_id
775: ,p_person_selection_rule_id=> p_person_selection_rule_id
776: ,p_effective_date => l_effective_date

Line 791: Ben_batch_utils.write(p_text =>

787:
788:
789: if l_err_message is not null
790: then
791: Ben_batch_utils.write(p_text =>
792: '<< Person id : '||to_char(l_person_id)||' failed.'||
793: ' Reason : '|| l_err_message ||' >>' );
794: skip := TRUE;
795: g_persons_errored := g_persons_errored + 1;

Line 874: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';

870: Else
871: hr_utility.set_location('p_benefit_action_id is not null',30);
872: l_restart := TRUE;
873: l_benefit_action_id := p_benefit_action_id;
874: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';
875: Ben_batch_utils.create_restart_person_actions
876: (p_benefit_action_id => p_benefit_action_id
877: ,p_effective_date => l_effective_date
878: ,p_chunk_size => l_chunk_size

Line 875: Ben_batch_utils.create_restart_person_actions

871: hr_utility.set_location('p_benefit_action_id is not null',30);
872: l_restart := TRUE;
873: l_benefit_action_id := p_benefit_action_id;
874: l_actn := 'Calling Ben_batch_utils.create_restart_person_actions...';
875: Ben_batch_utils.create_restart_person_actions
876: (p_benefit_action_id => p_benefit_action_id
877: ,p_effective_date => l_effective_date
878: ,p_chunk_size => l_chunk_size
879: ,p_threads => l_threads

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

908: ,argument8 => l_first_day_of_month_char );
909: --
910: -- Store the request id of the concurrent request
911: --
912: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
913: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
914: := l_request_id;
915: End loop;
916: Elsif (l_num_range = 0 ) then

Line 913: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)

909: --
910: -- Store the request id of the concurrent request
911: --
912: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
913: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
914: := l_request_id;
915: End loop;
916: Elsif (l_num_range = 0 ) then
917: l_actn := 'Calling Ben_batch_utils.print_parameters...';

Line 917: l_actn := 'Calling Ben_batch_utils.print_parameters...';

913: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
914: := l_request_id;
915: End loop;
916: Elsif (l_num_range = 0 ) then
917: l_actn := 'Calling Ben_batch_utils.print_parameters...';
918: hr_utility.set_location('Calling Ben_batch_utils.print_parameters ',34);
919:
920: Ben_batch_utils.print_parameters
921: (p_thread_id => 99

Line 918: hr_utility.set_location('Calling Ben_batch_utils.print_parameters ',34);

914: := l_request_id;
915: End loop;
916: Elsif (l_num_range = 0 ) then
917: l_actn := 'Calling Ben_batch_utils.print_parameters...';
918: hr_utility.set_location('Calling Ben_batch_utils.print_parameters ',34);
919:
920: Ben_batch_utils.print_parameters
921: (p_thread_id => 99
922: ,p_benefit_action_id => l_benefit_action_id

Line 920: Ben_batch_utils.print_parameters

916: Elsif (l_num_range = 0 ) then
917: l_actn := 'Calling Ben_batch_utils.print_parameters...';
918: hr_utility.set_location('Calling Ben_batch_utils.print_parameters ',34);
919:
920: Ben_batch_utils.print_parameters
921: (p_thread_id => 99
922: ,p_benefit_action_id => l_benefit_action_id
923: ,p_validate => p_validate
924: ,p_business_group_id => p_business_group_id

Line 946: Ben_batch_utils.write(p_text =>

942:
943: -- Because there are other processes below, do not error if first process finds
944: -- noone to process.
945:
946: Ben_batch_utils.write(p_text =>
947: '<< No Person was selected for Participant Premiums with above selection criteria >>' );
948: -- hr_utility.set_location ('BEN_91769_NOONE_TO_PROCESS',778);
949: -- fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
950: -- fnd_message.raise_error;

Line 967: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';

963: ,p_mo_num => l_mo_num
964: ,p_yr_num => l_yr_num
965: ,p_first_day_of_month => l_first_day_of_month_char
966: );
967: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
968:
969: hr_utility.set_location('Calling ben_batch_utils.check_all_slaves_finished ',38);
970:
971: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 969: hr_utility.set_location('Calling ben_batch_utils.check_all_slaves_finished ',38);

965: ,p_first_day_of_month => l_first_day_of_month_char
966: );
967: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
968:
969: hr_utility.set_location('Calling ben_batch_utils.check_all_slaves_finished ',38);
970:
971: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
972: end if;
973: --------------------------------------------------------------------------

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

967: l_actn := 'Calling ben_batch_utils.check_all_slaves_finished...';
968:
969: hr_utility.set_location('Calling ben_batch_utils.check_all_slaves_finished ',38);
970:
971: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
972: end if;
973: --------------------------------------------------------------------------
974: -- Now call the other two processes:
975: --------------------------------------------------------------------------

Line 1014: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1010: ,p_mo_num => l_mo_num
1011: ,p_yr_num => l_yr_num
1012: ,p_first_day_of_month => l_first_day_of_month
1013: ,p_effective_date => l_effective_date);
1014: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1015: ,p_person_selected => l_person_cnt
1016: ,p_business_group_id => p_business_group_id);
1017: submit_all_reports;
1018: hr_utility.set_location ('Leaving '||l_proc,70);

Line 1022: ben_batch_utils.rpt_error(p_proc => l_proc

1018: hr_utility.set_location ('Leaving '||l_proc,70);
1019: --
1020: Exception
1021: when others then
1022: ben_batch_utils.rpt_error(p_proc => l_proc
1023: ,p_last_actn => l_actn
1024: ,p_rpt_flag => TRUE );
1025: --
1026: benutils.write(p_text => fnd_message.get);

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

1027: benutils.write(p_text => sqlerrm);
1028: benutils.write(p_text => 'Big Error Occured');
1029: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1030: If (l_num_range > 0) then
1031: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1032: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1033: ,p_person_selected => l_person_cnt
1034: ,p_business_group_id => p_business_group_id
1035: ) ;

Line 1032: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1028: benutils.write(p_text => 'Big Error Occured');
1029: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1030: If (l_num_range > 0) then
1031: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1032: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1033: ,p_person_selected => l_person_cnt
1034: ,p_business_group_id => p_business_group_id
1035: ) ;
1036: End if;