DBA Data[Home] [Help]

APPS.BEN_CWB_BACK_OUT_CONC dependencies on FND_MESSAGE

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

457: p_person_id => p_person_id);
458: --
459: if fnd_global.conc_request_id in ( 0,-1) then
460: --
461: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
462: fnd_message.set_token('PARMA',l_element_name);
463: fnd_message.set_token('PARMB',to_char(l_effective_date));
464: l_string := fnd_message.get;
465: benutils.write(p_text => l_string);

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

458: --
459: if fnd_global.conc_request_id in ( 0,-1) then
460: --
461: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
462: fnd_message.set_token('PARMA',l_element_name);
463: fnd_message.set_token('PARMB',to_char(l_effective_date));
464: l_string := fnd_message.get;
465: benutils.write(p_text => l_string);
466: --

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

459: if fnd_global.conc_request_id in ( 0,-1) then
460: --
461: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
462: fnd_message.set_token('PARMA',l_element_name);
463: fnd_message.set_token('PARMB',to_char(l_effective_date));
464: l_string := fnd_message.get;
465: benutils.write(p_text => l_string);
466: --
467: end if;

Line 464: l_string := fnd_message.get;

460: --
461: fnd_message.set_name('BEN','BEN_93455_ELE_ALREADY_ENDED');
462: fnd_message.set_token('PARMA',l_element_name);
463: fnd_message.set_token('PARMB',to_char(l_effective_date));
464: l_string := fnd_message.get;
465: benutils.write(p_text => l_string);
466: --
467: end if;
468: --

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

568: fetch c_parameters into l_parameters;
569: If c_parameters%notfound then
570: --
571: close c_parameters;
572: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
573: fnd_message.raise_error;
574: --
575: End if;
576: --

Line 573: fnd_message.raise_error;

569: If c_parameters%notfound then
570: --
571: close c_parameters;
572: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
573: fnd_message.raise_error;
574: --
575: End if;
576: --
577: close c_parameters;

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

725: Begin
726: --
727: hr_utility.set_location ('Entering '||l_proc,10);
728: --
729: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
730: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
731: dt_fndate.change_ses_date
732: (p_ses_date => l_effective_date,
733: p_commit => l_commit);

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

726: --
727: hr_utility.set_location ('Entering '||l_proc,10);
728: --
729: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
730: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
731: dt_fndate.change_ses_date
732: (p_ses_date => l_effective_date,
733: p_commit => l_commit);
734: --

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

734: --
735: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
736: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
737: --
738: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
739: fnd_message.set_token('PROC','benutils.get_parameter');
740: benutils.get_parameter(p_business_group_id => p_business_group_id
741: ,p_batch_exe_cd => 'BENBOCON'
742: ,p_threads => l_threads

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

735: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
736: l_ocrd_date := trunc(fnd_date.canonical_to_date(p_ocrd_date));
737: --
738: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
739: fnd_message.set_token('PROC','benutils.get_parameter');
740: benutils.get_parameter(p_business_group_id => p_business_group_id
741: ,p_batch_exe_cd => 'BENBOCON'
742: ,p_threads => l_threads
743: ,p_chunk_size => l_chunk_size

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

746: hr_utility.set_location ('l_threads '||l_threads,10);
747: hr_utility.set_location ('l_chunk_size '||l_chunk_size,10);
748: --
749: --
750: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
751: fnd_message.set_token('PROC','ben_env_object.init');
752: ben_env_object.init(p_business_group_id => p_business_group_id,
753: p_effective_date => l_effective_date,
754: p_thread_id => p_thread_id,

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

747: hr_utility.set_location ('l_chunk_size '||l_chunk_size,10);
748: --
749: --
750: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
751: fnd_message.set_token('PROC','ben_env_object.init');
752: ben_env_object.init(p_business_group_id => p_business_group_id,
753: p_effective_date => l_effective_date,
754: p_thread_id => p_thread_id,
755: p_chunk_size => l_chunk_size,

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

769: fetch c_parameter into l_parm;
770: --
771: close c_parameter;
772: --
773: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
774: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
775: ben_batch_utils.print_parameters
776: (p_thread_id => p_thread_id
777: ,p_benefit_action_id => p_benefit_action_id

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

770: --
771: close c_parameter;
772: --
773: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
774: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
775: ben_batch_utils.print_parameters
776: (p_thread_id => p_thread_id
777: ,p_benefit_action_id => p_benefit_action_id
778: ,p_validate => p_validate

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

874: hr_utility.set_location ('typ_cd '||l_ler_thread.typ_cd,10);
875: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);
876: --
877: --
878: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
879: fnd_message.set_token('PROC','ben_back_out_life_event');
880: hr_utility.set_location ('calling bolfe ',10);
881: ben_back_out_life_event.g_enrt_made_flag := Null;
882: ben_back_out_life_event.back_out_life_events

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

875: hr_utility.set_location ('bg id '||l_ler_thread.business_group_id,10);
876: --
877: --
878: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
879: fnd_message.set_token('PROC','ben_back_out_life_event');
880: hr_utility.set_location ('calling bolfe ',10);
881: ben_back_out_life_event.g_enrt_made_flag := Null;
882: ben_back_out_life_event.back_out_life_events
883: (p_per_in_ler_id => l_ler_thread.per_in_ler_id

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

896: 'group pil is '||p_life_event_id,777);
897: --
898: -- Bug 3517726 : CWB data is not getting deleted.
899: hr_utility.set_location ('calling delete_cwb_data',10);
900: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
901: fnd_message.set_token('PROC','delete_cwb_data');
902: delete_cwb_data
903: (p_per_in_ler_id => l_ler_thread.per_in_ler_id
904: , p_business_group_id => l_ler_thread.business_group_id

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

897: --
898: -- Bug 3517726 : CWB data is not getting deleted.
899: hr_utility.set_location ('calling delete_cwb_data',10);
900: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
901: fnd_message.set_token('PROC','delete_cwb_data');
902: delete_cwb_data
903: (p_per_in_ler_id => l_ler_thread.per_in_ler_id
904: , p_business_group_id => l_ler_thread.business_group_id
905: , p_update_summary => false

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

977: --
978: g_persons_errored := g_persons_errored + 1;
979: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
980: g_rec.rep_typ_cd := 'ERROR_LF';
981: -- g_rec.text := fnd_message.get;
982: g_rec.person_id := l_person_id;
983:
984: g_rec.national_identifier := l_per_rec.national_identifier;
985: g_rec.error_message_code := benutils.get_message_name;

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

982: g_rec.person_id := l_person_id;
983:
984: g_rec.national_identifier := l_per_rec.national_identifier;
985: g_rec.error_message_code := benutils.get_message_name;
986: g_rec.text := fnd_message.get;
987:
988: hr_utility.set_location('Error Message '||g_rec.text,10);
989: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
990: benutils.write(g_rec.text);

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

993: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
994: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
995: if g_persons_errored > g_max_errors_allowed then
996: --
997: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
998: benutils.write(p_text => fnd_message.get);
999: --
1000: raise;
1001: --

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

994: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
995: if g_persons_errored > g_max_errors_allowed then
996: --
997: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
998: benutils.write(p_text => fnd_message.get);
999: --
1000: raise;
1001: --
1002: end if;

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

1018: rollback;
1019: --
1020: end if;
1021: --
1022: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1023: fnd_message.set_token('PROC','benutils.write_table_and_file');
1024: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1025: commit;
1026: --

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

1019: --
1020: end if;
1021: --
1022: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1023: fnd_message.set_token('PROC','benutils.write_table_and_file');
1024: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1025: commit;
1026: --
1027: end loop;

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

1025: commit;
1026: --
1027: end loop;
1028: --
1029: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1030: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
1031: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
1032: ,p_num_pers_errored => g_persons_errored);
1033: --

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

1026: --
1027: end loop;
1028: --
1029: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1030: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
1031: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
1032: ,p_num_pers_errored => g_persons_errored);
1033: --
1034: commit;

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

1046: benutils.rollback_cache;
1047: --
1048: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
1049: g_rec.rep_typ_cd := 'FATAL';
1050: g_rec.text := fnd_message.get;
1051: g_rec.person_id := l_person_id;
1052: --
1053: benutils.write(p_text => g_rec.text);
1054: benutils.write(p_rec => g_rec);

Line 1063: fnd_message.raise_error;

1059: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1060: --
1061: commit;
1062: --
1063: fnd_message.raise_error;
1064: --
1065: End do_multithread;
1066:
1067:

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

1488: ,p_benfts_grp_id => null
1489: ,p_location_id => null
1490: ,p_legal_entity_id => null);
1491: --
1492: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1493: fnd_message.set_token('PROC' , l_proc);
1494: raise l_no_one_to_process;
1495: --
1496: End if;

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

1489: ,p_location_id => null
1490: ,p_legal_entity_id => null);
1491: --
1492: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1493: fnd_message.set_token('PROC' , l_proc);
1494: raise l_no_one_to_process;
1495: --
1496: End if;
1497: --

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

1603: when l_no_one_to_process then
1604: if c_person%isopen then
1605: close c_person;
1606: end if;
1607: benutils.write(p_text => fnd_message.get);
1608: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1609:
1610: when others then
1611: --

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

1613: close c_person;
1614: end if;
1615: hr_utility.set_location('Super Error',10);
1616: rollback;
1617: benutils.write(p_text => fnd_message.get);
1618: benutils.write(p_text => sqlerrm);
1619: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1620: If (l_num_range > 0) then
1621: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 1627: fnd_message.raise_error;

1623: ,p_person_selected => l_person_cnt
1624: ,p_business_group_id => p_business_group_id
1625: ) ;
1626: End if;
1627: fnd_message.raise_error;
1628: End process;
1629: --
1630: -- *************************************************************************
1631: -- * << Procedure: cwb_delete_routine >>

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

1899: hr_utility.set_location( 'Entering '||l_proc, 5);
1900:
1901: --1. BEN_CWB_PERSON_TASKS
1902: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_TASKS', 10);
1903: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1904: fnd_message.set_token('PROC','delete_person_tasks');
1905: cwb_delete_routine
1906: (p_routine => 'BEN_CWB_PERSON_TASKS'
1907: ,p_per_in_ler_id => p_per_in_ler_id

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

1900:
1901: --1. BEN_CWB_PERSON_TASKS
1902: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_TASKS', 10);
1903: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1904: fnd_message.set_token('PROC','delete_person_tasks');
1905: cwb_delete_routine
1906: (p_routine => 'BEN_CWB_PERSON_TASKS'
1907: ,p_per_in_ler_id => p_per_in_ler_id
1908: ,p_update_summary => p_update_summary

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

1909: );
1910:
1911: --2. BEN_CWB_PERSON_RATES
1912: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
1913: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1914: fnd_message.set_token('PROC','delete_person_rates');
1915: cwb_delete_routine
1916: (p_routine => 'BEN_CWB_PERSON_RATES'
1917: ,p_per_in_ler_id => p_per_in_ler_id

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

1910:
1911: --2. BEN_CWB_PERSON_RATES
1912: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
1913: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1914: fnd_message.set_token('PROC','delete_person_rates');
1915: cwb_delete_routine
1916: (p_routine => 'BEN_CWB_PERSON_RATES'
1917: ,p_per_in_ler_id => p_per_in_ler_id
1918: ,p_update_summary => p_update_summary

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

1919: );
1920:
1921: --3. BEN_CWB_PERSON_GROUPS
1922: hr_utility.set_location( 'BEN_CWB_PERSON_GROUPS', 20);
1923: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1924: fnd_message.set_token('PROC','delete_person_groups');
1925: cwb_delete_routine
1926: (p_routine => 'BEN_CWB_PERSON_GROUPS'
1927: ,p_per_in_ler_id => p_per_in_ler_id

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

1920:
1921: --3. BEN_CWB_PERSON_GROUPS
1922: hr_utility.set_location( 'BEN_CWB_PERSON_GROUPS', 20);
1923: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1924: fnd_message.set_token('PROC','delete_person_groups');
1925: cwb_delete_routine
1926: (p_routine => 'BEN_CWB_PERSON_GROUPS'
1927: ,p_per_in_ler_id => p_per_in_ler_id
1928: ,p_update_summary => p_update_summary

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

1929: );
1930:
1931: --4. BEN_CWB_PERSON_INFO
1932: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
1933: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1934: fnd_message.set_token('PROC','delete_person_info');
1935: cwb_delete_routine
1936: (p_routine => 'BEN_CWB_PERSON_INFO'
1937: ,p_per_in_ler_id => p_per_in_ler_id

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

1930:
1931: --4. BEN_CWB_PERSON_INFO
1932: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_INFO', 25);
1933: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1934: fnd_message.set_token('PROC','delete_person_info');
1935: cwb_delete_routine
1936: (p_routine => 'BEN_CWB_PERSON_INFO'
1937: ,p_per_in_ler_id => p_per_in_ler_id
1938: ,p_update_summary => p_update_summary

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

2042: hr_utility.set_location ('per_in_ler_id '||l_pil_rec.per_in_ler_id,10);
2043: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);
2044: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2045: --
2046: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2047: fnd_message.set_token('PROC','ben_back_out_life_event');
2048: hr_utility.set_location ('calling bolfe ',10);
2049: --
2050: ben_back_out_life_event.g_enrt_made_flag := Null;

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

2043: hr_utility.set_location ('typ_cd '||l_pil_rec.typ_cd,10);
2044: hr_utility.set_location ('bg id '||l_pil_rec.business_group_id,10);
2045: --
2046: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2047: fnd_message.set_token('PROC','ben_back_out_life_event');
2048: hr_utility.set_location ('calling bolfe ',10);
2049: --
2050: ben_back_out_life_event.g_enrt_made_flag := Null;
2051: --