DBA Data[Home] [Help]

APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on FND_MESSAGE

Line 603: fnd_message.raise_error;

599: --
600: Exception
601: When others then
602: If (g_persons_errored > g_max_errors_allowed) then
603: fnd_message.raise_error;
604: End if;
605: End;
606: End loop;
607: Else

Line 611: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');

607: Else
608: --
609: l_actn := 'Erroring out nocopy since not person is found in range...' ;
610: --
611: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
612: fnd_message.set_token('PROCEDURE',l_proc);
613: fnd_message.raise_error;
614: End if;
615: commit;

Line 612: fnd_message.set_token('PROCEDURE',l_proc);

608: --
609: l_actn := 'Erroring out nocopy since not person is found in range...' ;
610: --
611: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
612: fnd_message.set_token('PROCEDURE',l_proc);
613: fnd_message.raise_error;
614: End if;
615: commit;
616: End loop;

Line 613: fnd_message.raise_error;

609: l_actn := 'Erroring out nocopy since not person is found in range...' ;
610: --
611: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
612: fnd_message.set_token('PROCEDURE',l_proc);
613: fnd_message.raise_error;
614: End if;
615: commit;
616: End loop;
617: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

Line 636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

632: ,p_num_pers_errored => g_persons_errored
633: );
634: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
635: commit;
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP',l_actn );
639: fnd_message.raise_error;
640: --

Line 637: fnd_message.set_token('PROCEDURE', l_proc);

633: );
634: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
635: commit;
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP',l_actn );
639: fnd_message.raise_error;
640: --
641: end do_multithread;

Line 638: fnd_message.set_token('STEP',l_actn );

634: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
635: commit;
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP',l_actn );
639: fnd_message.raise_error;
640: --
641: end do_multithread;
642: --

Line 639: fnd_message.raise_error;

635: commit;
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP',l_actn );
639: fnd_message.raise_error;
640: --
641: end do_multithread;
642: --
643: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

692: ben_batch_utils.rpt_error(p_proc => l_proc
693: ,p_last_actn => l_actn
694: ,p_rpt_flag => TRUE
695: );
696: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
697: fnd_message.set_token('PROC',l_proc);
698: fnd_message.raise_error;
699: End if;
700: close c_parameters;

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

693: ,p_last_actn => l_actn
694: ,p_rpt_flag => TRUE
695: );
696: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
697: fnd_message.set_token('PROC',l_proc);
698: fnd_message.raise_error;
699: End if;
700: close c_parameters;
701: --

Line 698: fnd_message.raise_error;

694: ,p_rpt_flag => TRUE
695: );
696: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
697: fnd_message.set_token('PROC',l_proc);
698: fnd_message.raise_error;
699: End if;
700: close c_parameters;
701: --
702: -- Call process procedure with parameters for restart

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

1239: ,p_audit_log => p_audit_log);
1240: --
1241: Ben_batch_utils.write(p_text =>
1242: '<< No Person got selected with above selection criteria >>' );
1243: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1244: fnd_message.set_token('PROC',l_proc);
1245: raise l_silent_error;
1246: --
1247: End if;

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

1240: --
1241: Ben_batch_utils.write(p_text =>
1242: '<< No Person got selected with above selection criteria >>' );
1243: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1244: fnd_message.set_token('PROC',l_proc);
1245: raise l_silent_error;
1246: --
1247: End if;
1248: --

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

1272: --
1273: Exception
1274: --
1275: when l_silent_error then
1276: ben_batch_utils.write(p_text => fnd_message.get);
1277: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1278: If (l_num_ranges > 0) then
1279: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1280: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1286: when others then
1287: ben_batch_utils.rpt_error(p_proc => l_proc
1288: ,p_last_actn => l_actn
1289: ,p_rpt_flag => TRUE );
1290: ben_batch_utils.write(p_text => fnd_message.get);
1291: ben_batch_utils.write(p_text => sqlerrm);
1292: ben_batch_utils.write(p_text => 'Big Error Occured');
1293: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1294: If (l_num_ranges > 0) then

Line 1301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1297: ,p_person_selected => l_num_persons
1298: ,p_business_group_id => p_business_group_id);
1299: submit_all_reports(p_audit_log => p_audit_log);
1300: End if;
1301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1302: fnd_message.set_token('PROCEDURE', l_proc);
1303: fnd_message.set_token('STEP', l_actn );
1304: fnd_message.raise_error;
1305: End process;

Line 1302: fnd_message.set_token('PROCEDURE', l_proc);

1298: ,p_business_group_id => p_business_group_id);
1299: submit_all_reports(p_audit_log => p_audit_log);
1300: End if;
1301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1302: fnd_message.set_token('PROCEDURE', l_proc);
1303: fnd_message.set_token('STEP', l_actn );
1304: fnd_message.raise_error;
1305: End process;
1306: --

Line 1303: fnd_message.set_token('STEP', l_actn );

1299: submit_all_reports(p_audit_log => p_audit_log);
1300: End if;
1301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1302: fnd_message.set_token('PROCEDURE', l_proc);
1303: fnd_message.set_token('STEP', l_actn );
1304: fnd_message.raise_error;
1305: End process;
1306: --
1307: -- ============================================================================

Line 1304: fnd_message.raise_error;

1300: End if;
1301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1302: fnd_message.set_token('PROCEDURE', l_proc);
1303: fnd_message.set_token('STEP', l_actn );
1304: fnd_message.raise_error;
1305: End process;
1306: --
1307: -- ============================================================================
1308: -- << Procedure: Default_comp_obj>>

Line 1626: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');

1622: open c_pen(l_epe(i).prtt_enrt_rslt_id);
1623: fetch c_pen into l_pen;
1624: If (c_pen%notfound) then
1625: Close c_pen;
1626: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1630: fnd_message.set_token('LER_ID',null);

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

1623: fetch c_pen into l_pen;
1624: If (c_pen%notfound) then
1625: Close c_pen;
1626: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1630: fnd_message.set_token('LER_ID',null);
1631: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

Line 1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));

1624: If (c_pen%notfound) then
1625: Close c_pen;
1626: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1630: fnd_message.set_token('LER_ID',null);
1631: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1632: fnd_message.raise_error;

Line 1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

1625: Close c_pen;
1626: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1630: fnd_message.set_token('LER_ID',null);
1631: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1632: fnd_message.raise_error;
1633: End if;

Line 1630: fnd_message.set_token('LER_ID',null);

1626: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1630: fnd_message.set_token('LER_ID',null);
1631: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1632: fnd_message.raise_error;
1633: End if;
1634: close c_pen;

Line 1631: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1630: fnd_message.set_token('LER_ID',null);
1631: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1632: fnd_message.raise_error;
1633: End if;
1634: close c_pen;
1635: --

Line 1632: fnd_message.raise_error;

1628: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1629: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1630: fnd_message.set_token('LER_ID',null);
1631: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1632: fnd_message.raise_error;
1633: End if;
1634: close c_pen;
1635: --
1636: hr_utility.set_location (' lf_evt_ocrd_dt '|| to_char(l_global_pil_rec.lf_evt_ocrd_dt) , 5);

Line 1930: fnd_message.set_name('BEN','BEN_94757_BNF_SLF_DSGN_NOTE');

1926: if 'Y' = l_bnf_exl_participant.bnf_exl_participant_flag then
1927: open c_pl_bnf(l_epe(i).prtt_enrt_rslt_id);
1928: fetch c_pl_bnf into l_pl_bnf;
1929: if c_pl_bnf%found then
1930: fnd_message.set_name('BEN','BEN_94757_BNF_SLF_DSGN_NOTE');
1931: fnd_message.set_token('PLAN',l_bnf_exl_participant.name);
1932: benutils.write(p_text => fnd_message.get);
1933: end if;
1934: close c_pl_bnf;

Line 1931: fnd_message.set_token('PLAN',l_bnf_exl_participant.name);

1927: open c_pl_bnf(l_epe(i).prtt_enrt_rslt_id);
1928: fetch c_pl_bnf into l_pl_bnf;
1929: if c_pl_bnf%found then
1930: fnd_message.set_name('BEN','BEN_94757_BNF_SLF_DSGN_NOTE');
1931: fnd_message.set_token('PLAN',l_bnf_exl_participant.name);
1932: benutils.write(p_text => fnd_message.get);
1933: end if;
1934: close c_pl_bnf;
1935: end if;

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

1928: fetch c_pl_bnf into l_pl_bnf;
1929: if c_pl_bnf%found then
1930: fnd_message.set_name('BEN','BEN_94757_BNF_SLF_DSGN_NOTE');
1931: fnd_message.set_token('PLAN',l_bnf_exl_participant.name);
1932: benutils.write(p_text => fnd_message.get);
1933: end if;
1934: close c_pl_bnf;
1935: end if;
1936: end if;

Line 1972: fnd_message.raise_error; -- 6027345

1968: end if;
1969: hr_utility.set_location ('Leaving '|| l_proc,10);
1970: Exception
1971: when app_exception.application_exception then -- 6027345
1972: fnd_message.raise_error; -- 6027345
1973: When others then
1974: if p_batch_flag then
1975: --
1976: -- Update person action to errored as record has an error

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

1974: if p_batch_flag then
1975: --
1976: -- Update person action to errored as record has an error
1977: --
1978: -- ben_batch_utils.write(p_text => fnd_message.get);
1979: ben_batch_utils.write(p_text => sqlerrm);
1980: ben_batch_utils.rpt_error(p_proc => l_proc
1981: ,p_last_actn => l_actn
1982: ,p_rpt_flag => p_batch_flag

Line 1988: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

1984: raise ben_batch_utils.g_record_error ;
1985: -- Added for Bug 2370264
1986: else
1987: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1988: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1989: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708
1990: fnd_message.raise_error;
1991: end if;
1992: -- End 2370264

Line 1989: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708

1985: -- Added for Bug 2370264
1986: else
1987: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1988: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1989: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708
1990: fnd_message.raise_error;
1991: end if;
1992: -- End 2370264
1993: End Default_Comp_obj;

Line 1990: fnd_message.raise_error;

1986: else
1987: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1988: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1989: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708
1990: fnd_message.raise_error;
1991: end if;
1992: -- End 2370264
1993: End Default_Comp_obj;
1994: --

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

2210: When others then
2211: rollback to process_default_enrt_savepoint;
2212: g_persons_errored := g_persons_errored + 1;
2213: ben_batch_utils.write_error_rec;
2214: ben_batch_utils.write(p_text => fnd_message.get);
2215: ben_batch_utils.write(p_text => sqlerrm);
2216: ben_batch_utils.rpt_error(p_proc => l_proc
2217: ,p_last_actn => l_actn
2218: ,p_rpt_flag => TRUE);

Line 2320: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

2316: fnd_msg_pub.add;
2317: when others then
2318: hr_utility.set_location ('Other Error in Default_Comp_obj_w : '|| sqlerrm , 89);
2319: --Bug 4387247
2320: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2321: fnd_message.set_token('2',substr(sqlerrm,1,200));
2322: fnd_msg_pub.add;
2323: end Default_Comp_obj_w;
2324: --

Line 2321: fnd_message.set_token('2',substr(sqlerrm,1,200));

2317: when others then
2318: hr_utility.set_location ('Other Error in Default_Comp_obj_w : '|| sqlerrm , 89);
2319: --Bug 4387247
2320: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2321: fnd_message.set_token('2',substr(sqlerrm,1,200));
2322: fnd_msg_pub.add;
2323: end Default_Comp_obj_w;
2324: --
2325: end ben_manage_default_enrt; -- End of Package.