DBA Data[Home] [Help]

APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on FND_MESSAGE

Line 589: fnd_message.raise_error;

585: --
586: Exception
587: When others then
588: If (g_persons_errored > g_max_errors_allowed) then
589: fnd_message.raise_error;
590: End if;
591: End;
592: End loop;
593: Else

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

593: Else
594: --
595: l_actn := 'Erroring out nocopy since not person is found in range...' ;
596: --
597: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
598: fnd_message.set_token('PROCEDURE',l_proc);
599: fnd_message.raise_error;
600: End if;
601: commit;

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

594: --
595: l_actn := 'Erroring out nocopy since not person is found in range...' ;
596: --
597: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
598: fnd_message.set_token('PROCEDURE',l_proc);
599: fnd_message.raise_error;
600: End if;
601: commit;
602: End loop;

Line 599: fnd_message.raise_error;

595: l_actn := 'Erroring out nocopy since not person is found in range...' ;
596: --
597: fnd_message.set_name('BEN','BEN_91709_PER_NOT_FND_IN_RNG');
598: fnd_message.set_token('PROCEDURE',l_proc);
599: fnd_message.raise_error;
600: End if;
601: commit;
602: End loop;
603: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

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

618: ,p_num_pers_errored => g_persons_errored
619: );
620: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
621: commit;
622: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
623: fnd_message.set_token('PROCEDURE', l_proc);
624: fnd_message.set_token('STEP',l_actn );
625: fnd_message.raise_error;
626: --

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

619: );
620: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
621: commit;
622: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
623: fnd_message.set_token('PROCEDURE', l_proc);
624: fnd_message.set_token('STEP',l_actn );
625: fnd_message.raise_error;
626: --
627: end do_multithread;

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

620: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
621: commit;
622: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
623: fnd_message.set_token('PROCEDURE', l_proc);
624: fnd_message.set_token('STEP',l_actn );
625: fnd_message.raise_error;
626: --
627: end do_multithread;
628: --

Line 625: fnd_message.raise_error;

621: commit;
622: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
623: fnd_message.set_token('PROCEDURE', l_proc);
624: fnd_message.set_token('STEP',l_actn );
625: fnd_message.raise_error;
626: --
627: end do_multithread;
628: --
629: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

678: ben_batch_utils.rpt_error(p_proc => l_proc
679: ,p_last_actn => l_actn
680: ,p_rpt_flag => TRUE
681: );
682: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.raise_error;
685: End if;
686: close c_parameters;

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

679: ,p_last_actn => l_actn
680: ,p_rpt_flag => TRUE
681: );
682: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.raise_error;
685: End if;
686: close c_parameters;
687: --

Line 684: fnd_message.raise_error;

680: ,p_rpt_flag => TRUE
681: );
682: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
683: fnd_message.set_token('PROC',l_proc);
684: fnd_message.raise_error;
685: End if;
686: close c_parameters;
687: --
688: -- Call process procedure with parameters for restart

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

1225: ,p_audit_log => p_audit_log);
1226: --
1227: Ben_batch_utils.write(p_text =>
1228: '<< No Person got selected with above selection criteria >>' );
1229: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1230: fnd_message.set_token('PROC',l_proc);
1231: raise l_silent_error;
1232: --
1233: End if;

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

1226: --
1227: Ben_batch_utils.write(p_text =>
1228: '<< No Person got selected with above selection criteria >>' );
1229: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1230: fnd_message.set_token('PROC',l_proc);
1231: raise l_silent_error;
1232: --
1233: End if;
1234: --

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

1258: --
1259: Exception
1260: --
1261: when l_silent_error then
1262: ben_batch_utils.write(p_text => fnd_message.get);
1263: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1264: If (l_num_ranges > 0) then
1265: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
1266: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id

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

1272: when others then
1273: ben_batch_utils.rpt_error(p_proc => l_proc
1274: ,p_last_actn => l_actn
1275: ,p_rpt_flag => TRUE );
1276: ben_batch_utils.write(p_text => fnd_message.get);
1277: ben_batch_utils.write(p_text => sqlerrm);
1278: ben_batch_utils.write(p_text => 'Big Error Occured');
1279: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1280: If (l_num_ranges > 0) then

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

1283: ,p_person_selected => l_num_persons
1284: ,p_business_group_id => p_business_group_id);
1285: submit_all_reports(p_audit_log => p_audit_log);
1286: End if;
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP', l_actn );
1290: fnd_message.raise_error;
1291: End process;

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

1284: ,p_business_group_id => p_business_group_id);
1285: submit_all_reports(p_audit_log => p_audit_log);
1286: End if;
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP', l_actn );
1290: fnd_message.raise_error;
1291: End process;
1292: --

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

1285: submit_all_reports(p_audit_log => p_audit_log);
1286: End if;
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP', l_actn );
1290: fnd_message.raise_error;
1291: End process;
1292: --
1293: -- ============================================================================

Line 1290: fnd_message.raise_error;

1286: End if;
1287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1288: fnd_message.set_token('PROCEDURE', l_proc);
1289: fnd_message.set_token('STEP', l_actn );
1290: fnd_message.raise_error;
1291: End process;
1292: --
1293: -- ============================================================================
1294: -- << Procedure: Default_comp_obj>>

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

1529: open c_pen(l_epe(i).prtt_enrt_rslt_id);
1530: fetch c_pen into l_pen;
1531: If (c_pen%notfound) then
1532: Close c_pen;
1533: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1534: fnd_message.set_token('PROC',l_proc);
1535: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1536: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1537: fnd_message.set_token('LER_ID',null);

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

1530: fetch c_pen into l_pen;
1531: If (c_pen%notfound) then
1532: Close c_pen;
1533: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1534: fnd_message.set_token('PROC',l_proc);
1535: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1536: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1537: fnd_message.set_token('LER_ID',null);
1538: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

1531: If (c_pen%notfound) then
1532: Close c_pen;
1533: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1534: fnd_message.set_token('PROC',l_proc);
1535: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1536: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1537: fnd_message.set_token('LER_ID',null);
1538: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1539: fnd_message.raise_error;

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

1532: Close c_pen;
1533: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1534: fnd_message.set_token('PROC',l_proc);
1535: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1536: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1537: fnd_message.set_token('LER_ID',null);
1538: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1539: fnd_message.raise_error;
1540: End if;

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

1533: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
1534: fnd_message.set_token('PROC',l_proc);
1535: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1536: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1537: fnd_message.set_token('LER_ID',null);
1538: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1539: fnd_message.raise_error;
1540: End if;
1541: close c_pen;

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

1534: fnd_message.set_token('PROC',l_proc);
1535: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1536: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1537: fnd_message.set_token('LER_ID',null);
1538: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1539: fnd_message.raise_error;
1540: End if;
1541: close c_pen;
1542: --

Line 1539: fnd_message.raise_error;

1535: fnd_message.set_token('ID',to_char(l_epe(i).prtt_enrt_rslt_id));
1536: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1537: fnd_message.set_token('LER_ID',null);
1538: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1539: fnd_message.raise_error;
1540: End if;
1541: close c_pen;
1542: --
1543: hr_utility.set_location (' lf_evt_ocrd_dt '|| to_char(l_global_pil_rec.lf_evt_ocrd_dt) , 5);

Line 1823: fnd_message.raise_error; -- 6027345

1819: );
1820: hr_utility.set_location ('Leaving '|| l_proc,10);
1821: Exception
1822: when app_exception.application_exception then -- 6027345
1823: fnd_message.raise_error; -- 6027345
1824: When others then
1825: if p_batch_flag then
1826: --
1827: -- Update person action to errored as record has an error

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

1825: if p_batch_flag then
1826: --
1827: -- Update person action to errored as record has an error
1828: --
1829: -- ben_batch_utils.write(p_text => fnd_message.get);
1830: ben_batch_utils.write(p_text => sqlerrm);
1831: ben_batch_utils.rpt_error(p_proc => l_proc
1832: ,p_last_actn => l_actn
1833: ,p_rpt_flag => p_batch_flag

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

1835: raise ben_batch_utils.g_record_error ;
1836: -- Added for Bug 2370264
1837: else
1838: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1839: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1840: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708
1841: fnd_message.raise_error;
1842: end if;
1843: -- End 2370264

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

1836: -- Added for Bug 2370264
1837: else
1838: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1839: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1840: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708
1841: fnd_message.raise_error;
1842: end if;
1843: -- End 2370264
1844: End Default_Comp_obj;

Line 1841: fnd_message.raise_error;

1837: else
1838: hr_utility.set_location ('Error in Default_Comp_obj : '|| sqlerrm , 87);
1839: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
1840: fnd_message.set_token('2',substr(sqlerrm,1,500)); -- 4695708
1841: fnd_message.raise_error;
1842: end if;
1843: -- End 2370264
1844: End Default_Comp_obj;
1845: --

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

2061: When others then
2062: rollback to process_default_enrt_savepoint;
2063: g_persons_errored := g_persons_errored + 1;
2064: ben_batch_utils.write_error_rec;
2065: ben_batch_utils.write(p_text => fnd_message.get);
2066: ben_batch_utils.write(p_text => sqlerrm);
2067: ben_batch_utils.rpt_error(p_proc => l_proc
2068: ,p_last_actn => l_actn
2069: ,p_rpt_flag => TRUE);

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

2167: fnd_msg_pub.add;
2168: when others then
2169: hr_utility.set_location ('Other Error in Default_Comp_obj_w : '|| sqlerrm , 89);
2170: --Bug 4387247
2171: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2172: fnd_message.set_token('2',substr(sqlerrm,1,200));
2173: fnd_msg_pub.add;
2174: end Default_Comp_obj_w;
2175: --

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

2168: when others then
2169: hr_utility.set_location ('Other Error in Default_Comp_obj_w : '|| sqlerrm , 89);
2170: --Bug 4387247
2171: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2172: fnd_message.set_token('2',substr(sqlerrm,1,200));
2173: fnd_msg_pub.add;
2174: end Default_Comp_obj_w;
2175: --
2176: end ben_manage_default_enrt; -- End of Package.