DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_CONC dependencies on FND_MESSAGE

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

298: Begin
299: --
300: hr_utility.set_location ('Entering '||l_proc,10);
301: --
302: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
303: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
304: dt_fndate.change_ses_date
305: (p_ses_date => l_effective_date,
306: p_commit => l_commit);

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

299: --
300: hr_utility.set_location ('Entering '||l_proc,10);
301: --
302: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
303: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
304: dt_fndate.change_ses_date
305: (p_ses_date => l_effective_date,
306: p_commit => l_commit);
307: --

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

308: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
309: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
310: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
311: --
312: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
313: fnd_message.set_token('PROC','benutils.get_parameter');
314: benutils.get_parameter(p_business_group_id => p_business_group_id
315: ,p_batch_exe_cd => 'BENBOCON'
316: ,p_threads => l_threads

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

309: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
310: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
311: --
312: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
313: fnd_message.set_token('PROC','benutils.get_parameter');
314: benutils.get_parameter(p_business_group_id => p_business_group_id
315: ,p_batch_exe_cd => 'BENBOCON'
316: ,p_threads => l_threads
317: ,p_chunk_size => l_chunk_size

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

316: ,p_threads => l_threads
317: ,p_chunk_size => l_chunk_size
318: ,p_max_errors => g_max_errors_allowed);
319: --
320: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
321: fnd_message.set_token('PROC','ben_env_object.init');
322: ben_env_object.init(p_business_group_id => p_business_group_id,
323: p_effective_date => l_effective_date,
324: p_thread_id => p_thread_id,

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

317: ,p_chunk_size => l_chunk_size
318: ,p_max_errors => g_max_errors_allowed);
319: --
320: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
321: fnd_message.set_token('PROC','ben_env_object.init');
322: ben_env_object.init(p_business_group_id => p_business_group_id,
323: p_effective_date => l_effective_date,
324: p_thread_id => p_thread_id,
325: p_chunk_size => l_chunk_size,

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

339: fetch c_parameter into l_parm;
340: --
341: close c_parameter;
342: --
343: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
344: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
345: ben_batch_utils.print_parameters
346: (p_thread_id => p_thread_id
347: ,p_benefit_action_id => p_benefit_action_id

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

340: --
341: close c_parameter;
342: --
343: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
344: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
345: ben_batch_utils.print_parameters
346: (p_thread_id => p_thread_id
347: ,p_benefit_action_id => p_benefit_action_id
348: ,p_validate => p_validate

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

415: -- Commented out for CWB - Bug # 2183388
416: -- Using cursor c_person below to duplicate the functionality
417: --
418: /*
419: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
420: fnd_message.set_token('PROC','ben_person_object');
421: ben_person_object.get_object(p_person_id => l_person_id,
422: p_rec => l_per_rec);
423: */

Line 420: fnd_message.set_token('PROC','ben_person_object');

416: -- Using cursor c_person below to duplicate the functionality
417: --
418: /*
419: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
420: fnd_message.set_token('PROC','ben_person_object');
421: ben_person_object.get_object(p_person_id => l_person_id,
422: p_rec => l_per_rec);
423: */
424:

Line 468: fnd_message.set_name('BEN','BEN_93383_ABS_LE_CANNOT_BO');

464: open c_latest_ler_abs;
465: fetch c_latest_ler_abs into l_latest_ler;
466: if c_latest_ler_abs%found then
467: close c_latest_ler_abs;
468: fnd_message.set_name('BEN','BEN_93383_ABS_LE_CANNOT_BO');
469: fnd_message.set_token('P_LER',l_latest_ler.name);
470: fnd_message.raise_error;
471: end if;
472: close c_latest_ler_abs;

Line 469: fnd_message.set_token('P_LER',l_latest_ler.name);

465: fetch c_latest_ler_abs into l_latest_ler;
466: if c_latest_ler_abs%found then
467: close c_latest_ler_abs;
468: fnd_message.set_name('BEN','BEN_93383_ABS_LE_CANNOT_BO');
469: fnd_message.set_token('P_LER',l_latest_ler.name);
470: fnd_message.raise_error;
471: end if;
472: close c_latest_ler_abs;
473: --

Line 470: fnd_message.raise_error;

466: if c_latest_ler_abs%found then
467: close c_latest_ler_abs;
468: fnd_message.set_name('BEN','BEN_93383_ABS_LE_CANNOT_BO');
469: fnd_message.set_token('P_LER',l_latest_ler.name);
470: fnd_message.raise_error;
471: end if;
472: close c_latest_ler_abs;
473: --
474: elsif l_ler_thread.typ_cd = 'COMP' then

Line 481: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');

477: fetch c_latest_ler_cwb into l_latest_ler;
478: if c_latest_ler_cwb%found then
479: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
480: close c_latest_ler_cwb;
481: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
482: fnd_message.raise_error;
483: end if;
484: end if;
485: close c_latest_ler_cwb;

Line 482: fnd_message.raise_error;

478: if c_latest_ler_cwb%found then
479: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
480: close c_latest_ler_cwb;
481: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
482: fnd_message.raise_error;
483: end if;
484: end if;
485: close c_latest_ler_cwb;
486: --

Line 494: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');

490: fetch c_latest_ler_gsp into l_latest_ler;
491: if c_latest_ler_gsp%found then
492: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
493: close c_latest_ler_gsp;
494: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
495: fnd_message.raise_error;
496: end if;
497: end if;
498: close c_latest_ler_gsp;

Line 495: fnd_message.raise_error;

491: if c_latest_ler_gsp%found then
492: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
493: close c_latest_ler_gsp;
494: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
495: fnd_message.raise_error;
496: end if;
497: end if;
498: close c_latest_ler_gsp;
499:

Line 508: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');

504: fetch c_latest_ler into l_latest_ler;
505: if c_latest_ler%found then
506: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
507: close c_latest_ler;
508: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
509: fnd_message.raise_error;
510: end if;
511: end if;
512: close c_latest_ler;

Line 509: fnd_message.raise_error;

505: if c_latest_ler%found then
506: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
507: close c_latest_ler;
508: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
509: fnd_message.raise_error;
510: end if;
511: end if;
512: close c_latest_ler;
513: --

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

513: --
514: end if;
515: --
516: --
517: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
518: fnd_message.set_token('PROC','ben_back_out_life_event');
519: ben_back_out_life_event.g_enrt_made_flag := Null;
520: ben_back_out_life_event.back_out_life_events
521: (p_per_in_ler_id => l_ler_thread.per_in_ler_id

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

514: end if;
515: --
516: --
517: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
518: fnd_message.set_token('PROC','ben_back_out_life_event');
519: ben_back_out_life_event.g_enrt_made_flag := Null;
520: ben_back_out_life_event.back_out_life_events
521: (p_per_in_ler_id => l_ler_thread.per_in_ler_id
522: ,p_business_group_id => p_business_group_id

Line 606: -- g_rec.text := fnd_message.get; -- Bug 2376630 Moved code below benutils.get_message_name

602: --
603: g_persons_errored := g_persons_errored + 1;
604: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
605: g_rec.rep_typ_cd := 'ERROR_LF';
606: -- g_rec.text := fnd_message.get; -- Bug 2376630 Moved code below benutils.get_message_name
607: g_rec.person_id := l_person_id;
608:
609: -- Bug 2376330 start
610: -- Added National Identifier and Error Message code

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

610: -- Added National Identifier and Error Message code
611:
612: g_rec.national_identifier := l_per_rec.national_identifier;
613: g_rec.error_message_code := benutils.get_message_name;
614: g_rec.text := fnd_message.get;
615:
616: -- Bug 2376330 end
617: --
618: hr_utility.set_location('Error Message '||g_rec.text,10);

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

623: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
624: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
625: if g_persons_errored > g_max_errors_allowed then
626: --
627: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
628: benutils.write(p_text => fnd_message.get);
629: --
630: raise;
631: --

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

624: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
625: if g_persons_errored > g_max_errors_allowed then
626: --
627: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
628: benutils.write(p_text => fnd_message.get);
629: --
630: raise;
631: --
632: end if;

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

648: rollback;
649: --
650: end if;
651: --
652: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
653: fnd_message.set_token('PROC','benutils.write_table_and_file');
654: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
655: commit;
656: --

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

649: --
650: end if;
651: --
652: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
653: fnd_message.set_token('PROC','benutils.write_table_and_file');
654: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
655: commit;
656: --
657: end loop;

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

655: commit;
656: --
657: end loop;
658: --
659: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
660: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
661: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
662: ,p_num_pers_errored => g_persons_errored);
663: --

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

656: --
657: end loop;
658: --
659: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
660: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
661: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
662: ,p_num_pers_errored => g_persons_errored);
663: --
664: commit;

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

676: benutils.rollback_cache;
677: --
678: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
679: g_rec.rep_typ_cd := 'FATAL';
680: g_rec.text := fnd_message.get;
681: g_rec.person_id := l_person_id;
682: --
683: benutils.write(p_text => g_rec.text);
684: benutils.write(p_rec => g_rec);

Line 693: fnd_message.raise_error;

689: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
690: --
691: commit;
692: --
693: fnd_message.raise_error;
694: --
695: End do_multithread;
696: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
697: -- << Procedure: Restart >>

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

741: --
742: fetch c_parameters into l_parameters;
743: If c_parameters%notfound then
744: --
745: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
746: fnd_message.raise_error;
747: --
748: End if;
749: --

Line 746: fnd_message.raise_error;

742: fetch c_parameters into l_parameters;
743: If c_parameters%notfound then
744: --
745: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
746: fnd_message.raise_error;
747: --
748: End if;
749: --
750: close c_parameters;

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

1188: ,p_benfts_grp_id => p_benfts_grp_id
1189: ,p_location_id => p_location_id
1190: ,p_legal_entity_id => p_legal_entity_id);
1191: --
1192: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1193: --Bug 2253040
1194: fnd_message.set_token('PROC' , l_proc);
1195: raise l_no_one_to_process;
1196: -- fnd_message.raise_error;

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

1190: ,p_legal_entity_id => p_legal_entity_id);
1191: --
1192: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1193: --Bug 2253040
1194: fnd_message.set_token('PROC' , l_proc);
1195: raise l_no_one_to_process;
1196: -- fnd_message.raise_error;
1197: --Bug 2253040
1198: --

Line 1196: -- fnd_message.raise_error;

1192: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1193: --Bug 2253040
1194: fnd_message.set_token('PROC' , l_proc);
1195: raise l_no_one_to_process;
1196: -- fnd_message.raise_error;
1197: --Bug 2253040
1198: --
1199: End if;
1200: --

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

1250: hr_utility.trace_off;
1251: Exception
1252: --Bug 2253040
1253: when l_no_one_to_process then
1254: benutils.write(p_text => fnd_message.get);
1255: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1256: --Bug 2253040
1257:
1258: when others then

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

1258: when others then
1259: --
1260: hr_utility.set_location('Super Error',10);
1261: rollback;
1262: benutils.write(p_text => fnd_message.get);
1263: benutils.write(p_text => sqlerrm);
1264: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1265: If (l_num_range > 0) then
1266: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 1272: fnd_message.raise_error;

1268: ,p_person_selected => l_person_cnt
1269: ,p_business_group_id => p_business_group_id
1270: ) ;
1271: End if;
1272: fnd_message.raise_error;
1273: End process;
1274: --
1275: end ben_back_out_conc; -- End of Package.
1276: