DBA Data[Home] [Help]

APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BEN_BATCH_UTILS

Line 116: ben_batch_utils.write('Error is : '||benutils.get_message_name||' - '||fnd_message.get);

112: --
113: when others then
114: --
115: hr_utility.set_location('Error || sqlerrm',10);
116: ben_batch_utils.write('Error is : '||benutils.get_message_name||' - '||fnd_message.get);
117: fnd_message.raise_error;
118: --
119: end check_business_rules;
120: --

Line 447: -- ben_batch_utils.write(rpad('-',140,'-'));

443: print_parameters
444: (p_benefit_action_id => p_benefit_action_id);
445: --
446: if p_audit_log_flag = 'Y' then
447: -- ben_batch_utils.write(rpad('-',140,'-'));
448: ben_batch_utils.write(rpad('-',150,'-'));
449: ben_batch_utils.write('| EMP NAME | '||'Status | '||'POPL ID | '||
450: 'Old Enrt Perd | '||'New Enrt Perd | '||
451: 'Old Processing | '||'New Processing | '||

Line 448: ben_batch_utils.write(rpad('-',150,'-'));

444: (p_benefit_action_id => p_benefit_action_id);
445: --
446: if p_audit_log_flag = 'Y' then
447: -- ben_batch_utils.write(rpad('-',140,'-'));
448: ben_batch_utils.write(rpad('-',150,'-'));
449: ben_batch_utils.write('| EMP NAME | '||'Status | '||'POPL ID | '||
450: 'Old Enrt Perd | '||'New Enrt Perd | '||
451: 'Old Processing | '||'New Processing | '||
452: 'Old Dflt | '||'New Dflt |');

Line 449: ben_batch_utils.write('| EMP NAME | '||'Status | '||'POPL ID | '||

445: --
446: if p_audit_log_flag = 'Y' then
447: -- ben_batch_utils.write(rpad('-',140,'-'));
448: ben_batch_utils.write(rpad('-',150,'-'));
449: ben_batch_utils.write('| EMP NAME | '||'Status | '||'POPL ID | '||
450: 'Old Enrt Perd | '||'New Enrt Perd | '||
451: 'Old Processing | '||'New Processing | '||
452: 'Old Dflt | '||'New Dflt |');
453: ben_batch_utils.write('| '||rpad(' ',30)||'| '||rpad(' ',13)||'| '||rpad(' ',10)||'| '||

Line 453: ben_batch_utils.write('| '||rpad(' ',30)||'| '||rpad(' ',13)||'| '||rpad(' ',10)||'| '||

449: ben_batch_utils.write('| EMP NAME | '||'Status | '||'POPL ID | '||
450: 'Old Enrt Perd | '||'New Enrt Perd | '||
451: 'Old Processing | '||'New Processing | '||
452: 'Old Dflt | '||'New Dflt |');
453: ben_batch_utils.write('| '||rpad(' ',30)||'| '||rpad(' ',13)||'| '||rpad(' ',10)||'| '||
454: rpad('End Date',14)||'| '||rpad('End Date',14)||'| '||
455: rpad('End Date',15)||'| '||rpad('End Date',15)||'| '||
456: rpad('End Date',10)||'| '||rpad('End Date',10)||'|');
457: -- ben_batch_utils.write(rpad('-',140,'-'));

Line 457: -- ben_batch_utils.write(rpad('-',140,'-'));

453: ben_batch_utils.write('| '||rpad(' ',30)||'| '||rpad(' ',13)||'| '||rpad(' ',10)||'| '||
454: rpad('End Date',14)||'| '||rpad('End Date',14)||'| '||
455: rpad('End Date',15)||'| '||rpad('End Date',15)||'| '||
456: rpad('End Date',10)||'| '||rpad('End Date',10)||'|');
457: -- ben_batch_utils.write(rpad('-',140,'-'));
458: ben_batch_utils.write(rpad('-',150,'-'));
459: end if;
460: --
461: -- While loop to only try and fetch records while they exist

Line 458: ben_batch_utils.write(rpad('-',150,'-'));

454: rpad('End Date',14)||'| '||rpad('End Date',14)||'| '||
455: rpad('End Date',15)||'| '||rpad('End Date',15)||'| '||
456: rpad('End Date',10)||'| '||rpad('End Date',10)||'|');
457: -- ben_batch_utils.write(rpad('-',140,'-'));
458: ben_batch_utils.write(rpad('-',150,'-'));
459: end if;
460: --
461: -- While loop to only try and fetch records while they exist
462: -- we always try and fetch the size of the chunk, if we get less

Line 570: ben_batch_utils.write('| '||rpad(l_pel.full_name,30)||'| '||'SUCCESS | '||

566: );
567: hr_utility.set_location('Updation done'||l_pel.pil_elctbl_chc_popl_id,10);
568: --
569: if p_audit_log_flag = 'Y' then
570: ben_batch_utils.write('| '||rpad(l_pel.full_name,30)||'| '||'SUCCESS | '||
571: rpad(l_pel.pil_elctbl_chc_popl_id,10)||'| '||
572: rpad(l_pel.enrt_perd_end_dt,14)||'| '||rpad(l_new_enrt_perd_end_dt,14)||'| '||
573: rpad(l_pel.procg_end_dt,15)||'| '||rpad(l_new_procg_end_dt,15)||'| '||
574: rpad(l_pel.dflt_enrt_dt,10)||'| '||rpad(l_new_dflt_enrt_dt,10)||'|');

Line 583: ben_batch_utils.write('| '||rpad(l_pel.full_name,30)||'| '||'UNSUCCESSFUL | No record found for the given set of conditions.');

579: --
580: close c_pel;
581: if l_popl_cnt = 0 then
582: if p_audit_log_flag = 'Y' then
583: ben_batch_utils.write('| '||rpad(l_pel.full_name,30)||'| '||'UNSUCCESSFUL | No record found for the given set of conditions.');
584: end if;
585: hr_utility.set_location('No POPL record found for '||l_pel.full_name ||' for the given set of conditions.',10);
586: end if;
587: l_popl_cnt := 0;

Line 627: ben_batch_utils.write('| '||rpad(l_pel.full_name,18)||'| '||'UNSUCCESSFUL | Error is - '||

623: hr_utility.set_location('Error Message '||g_rec.text,10);
624: if p_audit_log_flag = 'Y' then
625: -- changed bug: 5611643
626: /*
627: ben_batch_utils.write('| '||rpad(l_pel.full_name,18)||'| '||'UNSUCCESSFUL | Error is - '||
628: benutils.get_message_name||' - '||substr(fnd_message.get,1,80));
629: */
630: DECLARE
631: l_message_text VARCHAR2 (2100);

Line 642: ben_batch_utils.WRITE (SUBSTR (l_message_text, 1, l_message_length) || ' |');

638: || 'UNSUCCESSFUL | Error is - '
639: || benutils.get_message_name
640: || ' - '
641: || fnd_message.get;
642: ben_batch_utils.WRITE (SUBSTR (l_message_text, 1, l_message_length) || ' |');
643:
644: LOOP
645: IF LENGTH (l_message_text) > l_message_length
646: THEN

Line 651: ben_batch_utils.WRITE ( SUBSTR (l_message_text, 1,

647: l_message_text :=
648: RPAD ('| ', 47)
649: || '|'
650: || SUBSTR (l_message_text, l_message_length + 1);
651: ben_batch_utils.WRITE ( SUBSTR (l_message_text, 1,
652: l_message_length));
653: ELSE
654: EXIT;
655: END IF;

Line 667: ben_batch_utils.write(p_text => fnd_message.get);

663: -- if g_persons_errored > g_max_errors_allowed then
664: if g_persons_errored >= g_max_errors_allowed then
665: --
666: fnd_message.set_name('BEN','BEN_94642_BENMNOEW_ERROR_LIMIT');
667: ben_batch_utils.write(p_text => fnd_message.get);
668: --
669: raise;
670: --
671: end if;

Line 698: ben_batch_utils.write(rpad('-',140,'-'));

694: --
695: end loop;
696: --
697: if p_audit_log_flag = 'Y' then
698: ben_batch_utils.write(rpad('-',140,'-'));
699: end if;
700: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
701: ,p_num_pers_errored => g_persons_errored);
702: --

Line 700: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

696: --
697: if p_audit_log_flag = 'Y' then
698: ben_batch_utils.write(rpad('-',140,'-'));
699: end if;
700: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
701: ,p_num_pers_errored => g_persons_errored);
702: --
703: commit;
704: --

Line 725: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed

721: --
722: benutils.write(p_text => g_rec.text);
723: benutils.write(p_rec => g_rec);
724: --
725: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
726: ,p_num_pers_errored => g_persons_errored);
727: commit;
728: --
729: fnd_message.raise_error;

Line 1023: ben_batch_utils.ini;

1019: p_commit => l_commit);
1020: --
1021: -- Get chunk_size and Thread values for multi-thread process.
1022: --
1023: ben_batch_utils.ini;
1024: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
1025: --
1026: benutils.get_parameter(p_business_group_id => p_business_group_id
1027: -- bug 5611643

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

1020: --
1021: -- Get chunk_size and Thread values for multi-thread process.
1022: --
1023: ben_batch_utils.ini;
1024: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
1025: --
1026: benutils.get_parameter(p_business_group_id => p_business_group_id
1027: -- bug 5611643
1028: -- ,p_batch_exe_cd => 'BENMNGLE'

Line 1118: ben_batch_utils.person_selection_rule

1114: l_person_ok := 'Y';
1115: --
1116: If p_person_selection_rule_id is not NULL then
1117: --
1118: ben_batch_utils.person_selection_rule
1119: (p_person_id => l_person_id
1120: ,p_business_group_id => p_business_group_id
1121: ,p_person_selection_rule_id=> p_person_selection_rule_id
1122: ,p_effective_date => l_effective_date

Line 1127: Ben_batch_utils.write(p_text =>

1123: ,p_return => l_person_ok
1124: ,p_err_message => l_err_message );
1125:
1126: if l_err_message is not null then
1127: Ben_batch_utils.write(p_text =>
1128: '<< Person id : '||to_char(l_person_id)||' failed.'||
1129: ' Reason : '|| l_err_message ||' >>' );
1130: l_err_message := NULL ;
1131: end if ;

Line 1209: Ben_batch_utils.create_restart_person_actions

1205: Else
1206: --
1207: l_benefit_action_id := p_benefit_action_id;
1208: --
1209: Ben_batch_utils.create_restart_person_actions
1210: (p_benefit_action_id => p_benefit_action_id
1211: ,p_effective_date => l_effective_date
1212: ,p_chunk_size => l_chunk_size
1213: ,p_threads => l_threads

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

1241: ,argument14 => p_audit_log_flag);
1242: --
1243: -- Store the request id of the concurrent request
1244: --
1245: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
1246: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
1247: := l_request_id;
1248: --
1249: End loop;

Line 1246: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)

1242: --
1243: -- Store the request id of the concurrent request
1244: --
1245: ben_batch_utils.g_num_processes := ben_batch_utils.g_num_processes + 1;
1246: ben_batch_utils.g_processes_tbl(ben_batch_utils.g_num_processes)
1247: := l_request_id;
1248: --
1249: End loop;
1250: --

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

1277: ,p_new_dflt_enrt_dt => p_new_dflt_enrt_dt
1278: ,p_no_of_days => p_no_of_days
1279: ,p_audit_log_flag => p_audit_log_flag);
1280: --
1281: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1282: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1283: ,p_person_selected => l_person_cnt
1284: ,p_business_group_id => p_business_group_id);
1285: --

Line 1282: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1278: ,p_no_of_days => p_no_of_days
1279: ,p_audit_log_flag => p_audit_log_flag);
1280: --
1281: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1282: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1283: ,p_person_selected => l_person_cnt
1284: ,p_business_group_id => p_business_group_id);
1285: --
1286: -- need to write summary contents here

Line 1294: ben_batch_utils.write(p_text => fnd_message.get);

1290: --
1291: Exception
1292: --
1293: when l_no_one_to_process then
1294: ben_batch_utils.write(p_text => fnd_message.get);
1295: --
1296: when others then
1297: --
1298: hr_utility.set_location('Super Error',10);

Line 1300: ben_batch_utils.write(p_text => fnd_message.get);

1296: when others then
1297: --
1298: hr_utility.set_location('Super Error',10);
1299: rollback;
1300: ben_batch_utils.write(p_text => fnd_message.get);
1301: ben_batch_utils.write(p_text => sqlerrm);
1302: --
1303: If (l_num_range > 0) then
1304: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 1301: ben_batch_utils.write(p_text => sqlerrm);

1297: --
1298: hr_utility.set_location('Super Error',10);
1299: rollback;
1300: ben_batch_utils.write(p_text => fnd_message.get);
1301: ben_batch_utils.write(p_text => sqlerrm);
1302: --
1303: If (l_num_range > 0) then
1304: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1305: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1300: ben_batch_utils.write(p_text => fnd_message.get);
1301: ben_batch_utils.write(p_text => sqlerrm);
1302: --
1303: If (l_num_range > 0) then
1304: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1305: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1306: ,p_person_selected => l_person_cnt
1307: ,p_business_group_id => p_business_group_id
1308: ) ;

Line 1305: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

1301: ben_batch_utils.write(p_text => sqlerrm);
1302: --
1303: If (l_num_range > 0) then
1304: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1305: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1306: ,p_person_selected => l_person_cnt
1307: ,p_business_group_id => p_business_group_id
1308: ) ;
1309: End if;