DBA Data[Home] [Help]

APPS.BEN_CWB_BACK_OUT_CONC dependencies on FND_MESSAGE

Line 491: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');

487: p_person_id => p_person_id);
488: --
489: if fnd_global.conc_request_id in ( 0,-1) then
490: --
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);

Line 492: fnd_message.set_token('PARMA',l_element_name);

488: --
489: if fnd_global.conc_request_id in ( 0,-1) then
490: --
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: --

Line 493: fnd_message.set_token('PARMB',to_char(l_effective_date));

489: if fnd_global.conc_request_id in ( 0,-1) then
490: --
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;

Line 494: l_string := fnd_message.get;

490: --
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: --

Line 647: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');

643: fetch c_parameters into l_parameters;
644: If c_parameters%notfound then
645: --
646: close c_parameters;
647: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
648: fnd_message.raise_error;
649: --
650: End if;
651: --

Line 648: fnd_message.raise_error;

644: If c_parameters%notfound then
645: --
646: close c_parameters;
647: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
648: fnd_message.raise_error;
649: --
650: End if;
651: --
652: close c_parameters;

Line 804: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

800: Begin
801: --
802: hr_utility.set_location ('Entering '||l_proc,10);
803: --
804: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
805: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
806: dt_fndate.change_ses_date
807: (p_ses_date => l_effective_date,
808: p_commit => l_commit);

Line 805: fnd_message.set_token('PROC','dt_fndate.change_ses_date');

801: --
802: hr_utility.set_location ('Entering '||l_proc,10);
803: --
804: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
805: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
806: dt_fndate.change_ses_date
807: (p_ses_date => l_effective_date,
808: p_commit => l_commit);
809: --

Line 813: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

809: --
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

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 825: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

821: hr_utility.set_location ('l_threads '||l_threads,10);
822: hr_utility.set_location ('l_chunk_size '||l_chunk_size,10);
823: --
824: --
825: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
826: fnd_message.set_token('PROC','ben_env_object.init');
827: ben_env_object.init(p_business_group_id => p_business_group_id,
828: p_effective_date => l_effective_date,
829: p_thread_id => p_thread_id,

Line 826: fnd_message.set_token('PROC','ben_env_object.init');

822: hr_utility.set_location ('l_chunk_size '||l_chunk_size,10);
823: --
824: --
825: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
826: fnd_message.set_token('PROC','ben_env_object.init');
827: ben_env_object.init(p_business_group_id => p_business_group_id,
828: p_effective_date => l_effective_date,
829: p_thread_id => p_thread_id,
830: p_chunk_size => l_chunk_size,

Line 848: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

844: fetch c_parameter into l_parm;
845: --
846: close c_parameter;
847: --
848: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
849: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
850: ben_batch_utils.print_parameters
851: (p_thread_id => p_thread_id
852: ,p_benefit_action_id => p_benefit_action_id

Line 849: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');

845: --
846: close c_parameter;
847: --
848: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
849: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
850: ben_batch_utils.print_parameters
851: (p_thread_id => p_thread_id
852: ,p_benefit_action_id => p_benefit_action_id
853: ,p_validate => p_validate

Line 953: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

949: hr_utility.set_location ('typ_cd '||l_ler_thread.typ_cd,10);
950: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);
951: --
952: --
953: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
954: fnd_message.set_token('PROC','ben_back_out_life_event');
955: hr_utility.set_location ('calling bolfe ',10);
956: ben_back_out_life_event.g_enrt_made_flag := Null;
957: ben_back_out_life_event.back_out_life_events

Line 954: fnd_message.set_token('PROC','ben_back_out_life_event');

950: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);
951: --
952: --
953: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
954: fnd_message.set_token('PROC','ben_back_out_life_event');
955: hr_utility.set_location ('calling bolfe ',10);
956: ben_back_out_life_event.g_enrt_made_flag := Null;
957: ben_back_out_life_event.back_out_life_events
958: (p_per_in_ler_id => l_ler_thread.per_in_ler_id

Line 975: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

971: 'group pil is '||p_life_event_id,777);
972: --
973: -- Bug 3517726 : CWB data is not getting deleted.
974: hr_utility.set_location ('calling delete_cwb_data',10);
975: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
976: fnd_message.set_token('PROC','delete_cwb_data');
977: delete_cwb_data
978: (p_per_in_ler_id => l_ler_thread.per_in_ler_id
979: , p_business_group_id => l_ler_thread.business_group_id

Line 976: fnd_message.set_token('PROC','delete_cwb_data');

972: --
973: -- Bug 3517726 : CWB data is not getting deleted.
974: hr_utility.set_location ('calling delete_cwb_data',10);
975: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
976: fnd_message.set_token('PROC','delete_cwb_data');
977: delete_cwb_data
978: (p_per_in_ler_id => l_ler_thread.per_in_ler_id
979: , p_business_group_id => l_ler_thread.business_group_id
980: , p_update_summary => false

Line 1056: -- g_rec.text := fnd_message.get;

1052: --
1053: g_persons_errored := g_persons_errored + 1;
1054: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
1055: g_rec.rep_typ_cd := 'ERROR_LF';
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;

Line 1061: 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');
1065: benutils.write(g_rec.text);

Line 1072: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');

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
1071: --
1072: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
1073: benutils.write(p_text => fnd_message.get);
1074: --
1075: raise;
1076: --

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 1097: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

1093: rollback;
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: --

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 1104: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

1100: commit;
1101: --
1102: end loop;
1103: --
1104: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1105: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
1106: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
1107: ,p_num_pers_errored => g_persons_errored);
1108: --

Line 1105: fnd_message.set_token('PROC','benbatch_utils.write_logfile');

1101: --
1102: end loop;
1103: --
1104: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1105: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
1106: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
1107: ,p_num_pers_errored => g_persons_errored);
1108: --
1109: commit;

Line 1125: g_rec.text := fnd_message.get;

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;
1126: g_rec.person_id := l_person_id;
1127: --
1128: benutils.write(p_text => g_rec.text);
1129: benutils.write(p_rec => g_rec);

Line 1138: fnd_message.raise_error;

1134: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1135: --
1136: commit;
1137: --
1138: fnd_message.raise_error;
1139: --
1140: End do_multithread;
1141:
1142:

Line 1572: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');

1568: ,p_benfts_grp_id => null
1569: ,p_location_id => null
1570: ,p_legal_entity_id => null);
1571: --
1572: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1573: fnd_message.set_token('PROC' , l_proc);
1574: raise l_no_one_to_process;
1575: --
1576: End if;

Line 1573: fnd_message.set_token('PROC' , l_proc);

1569: ,p_location_id => null
1570: ,p_legal_entity_id => null);
1571: --
1572: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1573: fnd_message.set_token('PROC' , l_proc);
1574: raise l_no_one_to_process;
1575: --
1576: End if;
1577: --

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 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 1720: fnd_message.raise_error;

1716: ,p_person_selected => l_person_cnt
1717: ,p_business_group_id => p_business_group_id
1718: ) ;
1719: End if;
1720: fnd_message.raise_error;
1721: End process;
1722: --
1723: -- *************************************************************************
1724: -- * << Procedure: cwb_delete_routine >>

Line 1997: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

1993: hr_utility.set_location( 'Entering '||l_proc, 5);
1994:
1995: --1. BEN_CWB_PERSON_TASKS
1996: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_TASKS', 10);
1997: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1998: fnd_message.set_token('PROC','delete_person_tasks');
1999: cwb_delete_routine
2000: (p_routine => 'BEN_CWB_PERSON_TASKS'
2001: ,p_per_in_ler_id => p_per_in_ler_id

Line 1998: fnd_message.set_token('PROC','delete_person_tasks');

1994:
1995: --1. BEN_CWB_PERSON_TASKS
1996: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_TASKS', 10);
1997: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1998: fnd_message.set_token('PROC','delete_person_tasks');
1999: cwb_delete_routine
2000: (p_routine => 'BEN_CWB_PERSON_TASKS'
2001: ,p_per_in_ler_id => p_per_in_ler_id
2002: ,p_update_summary => p_update_summary

Line 2007: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

2003: );
2004:
2005: --2. BEN_CWB_PERSON_RATES
2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
2007: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2008: fnd_message.set_token('PROC','delete_person_rates');
2009: cwb_delete_routine
2010: (p_routine => 'BEN_CWB_PERSON_RATES'
2011: ,p_per_in_ler_id => p_per_in_ler_id

Line 2008: fnd_message.set_token('PROC','delete_person_rates');

2004:
2005: --2. BEN_CWB_PERSON_RATES
2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
2007: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2008: fnd_message.set_token('PROC','delete_person_rates');
2009: cwb_delete_routine
2010: (p_routine => 'BEN_CWB_PERSON_RATES'
2011: ,p_per_in_ler_id => p_per_in_ler_id
2012: ,p_update_summary => p_update_summary

Line 2017: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

2013: );
2014:
2015: --3. BEN_CWB_PERSON_GROUPS
2016: hr_utility.set_location( 'BEN_CWB_PERSON_GROUPS', 20);
2017: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2018: fnd_message.set_token('PROC','delete_person_groups');
2019: cwb_delete_routine
2020: (p_routine => 'BEN_CWB_PERSON_GROUPS'
2021: ,p_per_in_ler_id => p_per_in_ler_id

Line 2018: fnd_message.set_token('PROC','delete_person_groups');

2014:
2015: --3. BEN_CWB_PERSON_GROUPS
2016: hr_utility.set_location( 'BEN_CWB_PERSON_GROUPS', 20);
2017: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2018: fnd_message.set_token('PROC','delete_person_groups');
2019: cwb_delete_routine
2020: (p_routine => 'BEN_CWB_PERSON_GROUPS'
2021: ,p_per_in_ler_id => p_per_in_ler_id
2022: ,p_update_summary => p_update_summary

Line 2027: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

2023: );
2024:
2025: --4. BEN_CWB_PERSON_INFO
2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
2027: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2028: fnd_message.set_token('PROC','delete_person_info');
2029: cwb_delete_routine
2030: (p_routine => 'BEN_CWB_PERSON_INFO'
2031: ,p_per_in_ler_id => p_per_in_ler_id

Line 2028: fnd_message.set_token('PROC','delete_person_info');

2024:
2025: --4. BEN_CWB_PERSON_INFO
2026: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
2027: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2028: fnd_message.set_token('PROC','delete_person_info');
2029: cwb_delete_routine
2030: (p_routine => 'BEN_CWB_PERSON_INFO'
2031: ,p_per_in_ler_id => p_per_in_ler_id
2032: ,p_update_summary => p_update_summary

Line 2140: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

2136: hr_utility.set_location ('per_in_ler_id '||l_pil_rec.per_in_ler_id,10);
2137: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);
2138: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2139: --
2140: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2141: fnd_message.set_token('PROC','ben_back_out_life_event');
2142: hr_utility.set_location ('calling bolfe ',10);
2143: --
2144: ben_back_out_life_event.g_enrt_made_flag := Null;

Line 2141: fnd_message.set_token('PROC','ben_back_out_life_event');

2137: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);
2138: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2139: --
2140: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2141: fnd_message.set_token('PROC','ben_back_out_life_event');
2142: hr_utility.set_location ('calling bolfe ',10);
2143: --
2144: ben_back_out_life_event.g_enrt_made_flag := Null;
2145: --