DBA Data[Home] [Help]

APPS.BEN_CWB_BACK_OUT_CONC dependencies on BENUTILS

Line 495: benutils.write(p_text => l_string);

491: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
492: fnd_message.set_token('PARMA',l_element_name);
493: fnd_message.set_token('PARMB',to_char(l_effective_date));
494: l_string := fnd_message.get;
495: benutils.write(p_text => l_string);
496: --
497: end if;
498: --
499: if g_debug then

Line 814: fnd_message.set_token('PROC','benutils.get_parameter');

810: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
811: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
812: --
813: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
814: fnd_message.set_token('PROC','benutils.get_parameter');
815: benutils.get_parameter(p_business_group_id => p_business_group_id
816: ,p_batch_exe_cd => 'BENBOCON'
817: ,p_threads => l_threads
818: ,p_chunk_size => l_chunk_size

Line 815: benutils.get_parameter(p_business_group_id => p_business_group_id

811: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
812: --
813: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
814: fnd_message.set_token('PROC','benutils.get_parameter');
815: benutils.get_parameter(p_business_group_id => p_business_group_id
816: ,p_batch_exe_cd => 'BENBOCON'
817: ,p_threads => l_threads
818: ,p_chunk_size => l_chunk_size
819: ,p_max_errors => g_max_errors_allowed);

Line 835: -- Copy benefit action id to global in benutils package

831: p_threads => l_threads,
832: p_max_errors => g_max_errors_allowed,
833: p_benefit_action_id => p_benefit_action_id);
834: --
835: -- Copy benefit action id to global in benutils package
836: --
837: benutils.g_benefit_action_id := p_benefit_action_id;
838: benutils.g_thread_id := p_thread_id;
839: g_persons_errored := 0;

Line 837: benutils.g_benefit_action_id := p_benefit_action_id;

833: p_benefit_action_id => p_benefit_action_id);
834: --
835: -- Copy benefit action id to global in benutils package
836: --
837: benutils.g_benefit_action_id := p_benefit_action_id;
838: benutils.g_thread_id := p_thread_id;
839: g_persons_errored := 0;
840: g_persons_processed := 0;
841: --

Line 838: benutils.g_thread_id := p_thread_id;

834: --
835: -- Copy benefit action id to global in benutils package
836: --
837: benutils.g_benefit_action_id := p_benefit_action_id;
838: benutils.g_thread_id := p_thread_id;
839: g_persons_errored := 0;
840: g_persons_processed := 0;
841: --
842: open c_parameter;

Line 917: benutils.set_cache_record_position;

913: --
914: exit when c_person_thread%notfound;
915: --
916: savepoint last_place;
917: benutils.set_cache_record_position;
918:
919: --
920: -- CWB - Added to avoid calling ben_person_object.get_object
921: --

Line 1007: benutils.write(p_rec => g_rec);

1003: -- This is to assign the per_in_ler_id in the record to extract the
1004: -- the electable choices later.
1005: g_rec.temporal_ler_id := l_ler_thread.per_in_ler_id;
1006:
1007: benutils.write(p_rec => g_rec);
1008: --
1009: End loop;
1010: --
1011: close c_ler_thread;

Line 1020: benutils.write(l_per_rec.full_name||' processed successfully');

1016: set action_status_cd = 'P'
1017: where person_id = l_person_id
1018: and benefit_action_id = p_benefit_action_id;
1019: --
1020: benutils.write(l_per_rec.full_name||' processed successfully');
1021: g_persons_processed := g_persons_processed + 1;
1022: --
1023: exception
1024: --

Line 1044: benutils.rollback_cache;

1040: --
1041: end if;
1042: --
1043: rollback to last_place;
1044: benutils.rollback_cache;
1045: --
1046: update ben_person_actions
1047: set action_status_cd = 'E'
1048: where person_id = l_person_id

Line 1060: g_rec.error_message_code := benutils.get_message_name;

1056: -- g_rec.text := fnd_message.get;
1057: g_rec.person_id := l_person_id;
1058:
1059: g_rec.national_identifier := l_per_rec.national_identifier;
1060: g_rec.error_message_code := benutils.get_message_name;
1061: g_rec.text := fnd_message.get;
1062:
1063: hr_utility.set_location('Error Message '||g_rec.text,10);
1064: benutils.write(l_per_rec.full_name||' processed unsuccessfully');

Line 1064: benutils.write(l_per_rec.full_name||' processed unsuccessfully');

1060: g_rec.error_message_code := benutils.get_message_name;
1061: g_rec.text := fnd_message.get;
1062:
1063: hr_utility.set_location('Error Message '||g_rec.text,10);
1064: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
1065: benutils.write(g_rec.text);
1066: benutils.write(p_rec => g_rec);
1067: --
1068: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);

Line 1065: benutils.write(g_rec.text);

1061: g_rec.text := fnd_message.get;
1062:
1063: hr_utility.set_location('Error Message '||g_rec.text,10);
1064: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
1065: benutils.write(g_rec.text);
1066: benutils.write(p_rec => g_rec);
1067: --
1068: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1069: hr_utility.set_location('Num Errors = '||g_persons_errored,10);

Line 1066: benutils.write(p_rec => g_rec);

1062:
1063: hr_utility.set_location('Error Message '||g_rec.text,10);
1064: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
1065: benutils.write(g_rec.text);
1066: benutils.write(p_rec => g_rec);
1067: --
1068: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1069: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
1070: if g_persons_errored > g_max_errors_allowed then

Line 1073: benutils.write(p_text => fnd_message.get);

1069: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
1070: if g_persons_errored > g_max_errors_allowed then
1071: --
1072: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
1073: benutils.write(p_text => fnd_message.get);
1074: --
1075: raise;
1076: --
1077: end if;

Line 1098: fnd_message.set_token('PROC','benutils.write_table_and_file');

1094: --
1095: end if;
1096: --
1097: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1098: fnd_message.set_token('PROC','benutils.write_table_and_file');
1099: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1100: commit;
1101: --
1102: end loop;

Line 1099: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

1095: end if;
1096: --
1097: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1098: fnd_message.set_token('PROC','benutils.write_table_and_file');
1099: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1100: commit;
1101: --
1102: end loop;
1103: --

Line 1121: benutils.rollback_cache;

1117: hr_utility.set_location('Super Error',10);
1118: hr_utility.set_location(sqlerrm,10);
1119: hr_utility.set_location('Super Error',10);
1120: rollback;
1121: benutils.rollback_cache;
1122: --
1123: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
1124: g_rec.rep_typ_cd := 'FATAL';
1125: g_rec.text := fnd_message.get;

Line 1128: benutils.write(p_text => g_rec.text);

1124: g_rec.rep_typ_cd := 'FATAL';
1125: g_rec.text := fnd_message.get;
1126: g_rec.person_id := l_person_id;
1127: --
1128: benutils.write(p_text => g_rec.text);
1129: benutils.write(p_rec => g_rec);
1130: --
1131: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
1132: ,p_num_pers_errored => g_persons_errored);

Line 1129: benutils.write(p_rec => g_rec);

1125: g_rec.text := fnd_message.get;
1126: g_rec.person_id := l_person_id;
1127: --
1128: benutils.write(p_text => g_rec.text);
1129: benutils.write(p_rec => g_rec);
1130: --
1131: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
1132: ,p_num_pers_errored => g_persons_errored);
1133: --

Line 1134: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

1130: --
1131: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
1132: ,p_num_pers_errored => g_persons_errored);
1133: --
1134: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1135: --
1136: commit;
1137: --
1138: fnd_message.raise_error;

Line 1315: benutils.get_parameter(p_business_group_id => p_business_group_id

1311: --
1312: ben_batch_utils.ini;
1313: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
1314: --
1315: benutils.get_parameter(p_business_group_id => p_business_group_id
1316: ,p_batch_exe_cd => 'BENBOCON'
1317: ,p_threads => l_threads
1318: ,p_chunk_size => l_chunk_size
1319: ,p_max_errors => g_max_errors_allowed);

Line 1366: benutils.g_benefit_action_id := l_benefit_action_id;

1362: ,p_program_update_date => sysdate
1363: ,p_date_from => l_ocrd_date
1364: ,p_uneai_effective_date => null);
1365: --
1366: benutils.g_benefit_action_id := l_benefit_action_id;
1367: --
1368: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
1369: -- Delete/clear ranges from ben_batch_ranges table
1370: --

Line 1700: benutils.write(p_text => fnd_message.get);

1696: when l_no_one_to_process then
1697: if c_person%isopen then
1698: close c_person;
1699: end if;
1700: benutils.write(p_text => fnd_message.get);
1701: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1702:
1703: when others then
1704: --

Line 1701: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

1697: if c_person%isopen then
1698: close c_person;
1699: end if;
1700: benutils.write(p_text => fnd_message.get);
1701: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1702:
1703: when others then
1704: --
1705: if c_person%isopen then

Line 1710: benutils.write(p_text => fnd_message.get);

1706: close c_person;
1707: end if;
1708: hr_utility.set_location('Super Error',10);
1709: rollback;
1710: benutils.write(p_text => fnd_message.get);
1711: benutils.write(p_text => sqlerrm);
1712: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1713: If (l_num_range > 0) then
1714: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 1711: benutils.write(p_text => sqlerrm);

1707: end if;
1708: hr_utility.set_location('Super Error',10);
1709: rollback;
1710: benutils.write(p_text => fnd_message.get);
1711: benutils.write(p_text => sqlerrm);
1712: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1713: If (l_num_range > 0) then
1714: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1715: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

Line 1712: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

1708: hr_utility.set_location('Super Error',10);
1709: rollback;
1710: benutils.write(p_text => fnd_message.get);
1711: benutils.write(p_text => sqlerrm);
1712: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1713: If (l_num_range > 0) then
1714: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1715: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
1716: ,p_person_selected => l_person_cnt