DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_CONC dependencies on FND_MESSAGE

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

293: Begin
294: --
295: hr_utility.set_location ('Entering '||l_proc,10);
296: --
297: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
298: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
299: dt_fndate.change_ses_date
300: (p_ses_date => l_effective_date,
301: p_commit => l_commit);

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

294: --
295: hr_utility.set_location ('Entering '||l_proc,10);
296: --
297: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
298: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
299: dt_fndate.change_ses_date
300: (p_ses_date => l_effective_date,
301: p_commit => l_commit);
302: --

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

303: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
304: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
305: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
306: --
307: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
308: fnd_message.set_token('PROC','benutils.get_parameter');
309: benutils.get_parameter(p_business_group_id => p_business_group_id
310: ,p_batch_exe_cd => 'BENBOCON'
311: ,p_threads => l_threads

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

304: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
305: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));
306: --
307: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
308: fnd_message.set_token('PROC','benutils.get_parameter');
309: benutils.get_parameter(p_business_group_id => p_business_group_id
310: ,p_batch_exe_cd => 'BENBOCON'
311: ,p_threads => l_threads
312: ,p_chunk_size => l_chunk_size

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

311: ,p_threads => l_threads
312: ,p_chunk_size => l_chunk_size
313: ,p_max_errors => g_max_errors_allowed);
314: --
315: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
316: fnd_message.set_token('PROC','ben_env_object.init');
317: ben_env_object.init(p_business_group_id => p_business_group_id,
318: p_effective_date => l_effective_date,
319: p_thread_id => p_thread_id,

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

312: ,p_chunk_size => l_chunk_size
313: ,p_max_errors => g_max_errors_allowed);
314: --
315: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
316: fnd_message.set_token('PROC','ben_env_object.init');
317: ben_env_object.init(p_business_group_id => p_business_group_id,
318: p_effective_date => l_effective_date,
319: p_thread_id => p_thread_id,
320: p_chunk_size => l_chunk_size,

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

334: fetch c_parameter into l_parm;
335: --
336: close c_parameter;
337: --
338: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
339: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
340: ben_batch_utils.print_parameters
341: (p_thread_id => p_thread_id
342: ,p_benefit_action_id => p_benefit_action_id

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

335: --
336: close c_parameter;
337: --
338: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
339: fnd_message.set_token('PROC','ben_batch_utils.print_parameters');
340: ben_batch_utils.print_parameters
341: (p_thread_id => p_thread_id
342: ,p_benefit_action_id => p_benefit_action_id
343: ,p_validate => p_validate

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

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

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

411: -- Using cursor c_person below to duplicate the functionality
412: --
413: /*
414: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
415: fnd_message.set_token('PROC','ben_person_object');
416: ben_person_object.get_object(p_person_id => l_person_id,
417: p_rec => l_per_rec);
418: */
419:

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

454: open c_latest_ler_abs;
455: fetch c_latest_ler_abs into l_latest_ler;
456: if c_latest_ler_abs%found then
457: close c_latest_ler_abs;
458: fnd_message.set_name('BEN','BEN_93383_ABS_LE_CANNOT_BO');
459: fnd_message.set_token('P_LER',l_latest_ler.name);
460: fnd_message.raise_error;
461: end if;
462: close c_latest_ler_abs;

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

455: fetch c_latest_ler_abs into l_latest_ler;
456: if c_latest_ler_abs%found then
457: close c_latest_ler_abs;
458: fnd_message.set_name('BEN','BEN_93383_ABS_LE_CANNOT_BO');
459: fnd_message.set_token('P_LER',l_latest_ler.name);
460: fnd_message.raise_error;
461: end if;
462: close c_latest_ler_abs;
463: --

Line 460: fnd_message.raise_error;

456: if c_latest_ler_abs%found then
457: close c_latest_ler_abs;
458: fnd_message.set_name('BEN','BEN_93383_ABS_LE_CANNOT_BO');
459: fnd_message.set_token('P_LER',l_latest_ler.name);
460: fnd_message.raise_error;
461: end if;
462: close c_latest_ler_abs;
463: --
464: elsif l_ler_thread.typ_cd = 'COMP' then

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

467: fetch c_latest_ler_cwb into l_latest_ler;
468: if c_latest_ler_cwb%found then
469: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
470: close c_latest_ler_cwb;
471: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
472: fnd_message.raise_error;
473: end if;
474: end if;
475: close c_latest_ler_cwb;

Line 472: fnd_message.raise_error;

468: if c_latest_ler_cwb%found then
469: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
470: close c_latest_ler_cwb;
471: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
472: fnd_message.raise_error;
473: end if;
474: end if;
475: close c_latest_ler_cwb;
476: --

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

480: fetch c_latest_ler_gsp into l_latest_ler;
481: if c_latest_ler_gsp%found then
482: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
483: close c_latest_ler_gsp;
484: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
485: fnd_message.raise_error;
486: end if;
487: end if;
488: close c_latest_ler_gsp;

Line 485: fnd_message.raise_error;

481: if c_latest_ler_gsp%found then
482: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
483: close c_latest_ler_gsp;
484: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
485: fnd_message.raise_error;
486: end if;
487: end if;
488: close c_latest_ler_gsp;
489:

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

494: fetch c_latest_ler into l_latest_ler;
495: if c_latest_ler%found then
496: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
497: close c_latest_ler;
498: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
499: fnd_message.raise_error;
500: end if;
501: end if;
502: close c_latest_ler;

Line 499: fnd_message.raise_error;

495: if c_latest_ler%found then
496: if l_latest_ler.per_in_ler_id <> l_ler_thread.per_in_ler_id then
497: close c_latest_ler;
498: fnd_message.set_name('BEN','BEN_92216_NOT_LATST_PER_IN_LER');
499: fnd_message.raise_error;
500: end if;
501: end if;
502: close c_latest_ler;
503: --

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

503: --
504: end if;
505: --
506: --
507: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
508: fnd_message.set_token('PROC','ben_back_out_life_event');
509: ben_back_out_life_event.g_enrt_made_flag := Null;
510: ben_back_out_life_event.back_out_life_events
511: (p_per_in_ler_id => l_ler_thread.per_in_ler_id

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

504: end if;
505: --
506: --
507: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
508: fnd_message.set_token('PROC','ben_back_out_life_event');
509: ben_back_out_life_event.g_enrt_made_flag := Null;
510: ben_back_out_life_event.back_out_life_events
511: (p_per_in_ler_id => l_ler_thread.per_in_ler_id
512: ,p_business_group_id => p_business_group_id

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

576: --
577: g_persons_errored := g_persons_errored + 1;
578: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
579: g_rec.rep_typ_cd := 'ERROR_LF';
580: -- g_rec.text := fnd_message.get; -- Bug 2376630 Moved code below benutils.get_message_name
581: g_rec.person_id := l_person_id;
582:
583: -- Bug 2376330 start
584: -- Added National Identifier and Error Message code

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

584: -- Added National Identifier and Error Message code
585:
586: g_rec.national_identifier := l_per_rec.national_identifier;
587: g_rec.error_message_code := benutils.get_message_name;
588: g_rec.text := fnd_message.get;
589:
590: -- Bug 2376330 end
591: --
592: hr_utility.set_location('Error Message '||g_rec.text,10);

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

597: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
598: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
599: if g_persons_errored > g_max_errors_allowed then
600: --
601: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
602: benutils.write(p_text => fnd_message.get);
603: --
604: raise;
605: --

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

598: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
599: if g_persons_errored > g_max_errors_allowed then
600: --
601: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
602: benutils.write(p_text => fnd_message.get);
603: --
604: raise;
605: --
606: end if;

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

622: rollback;
623: --
624: end if;
625: --
626: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
627: fnd_message.set_token('PROC','benutils.write_table_and_file');
628: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
629: commit;
630: --

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

623: --
624: end if;
625: --
626: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
627: fnd_message.set_token('PROC','benutils.write_table_and_file');
628: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
629: commit;
630: --
631: end loop;

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

629: commit;
630: --
631: end loop;
632: --
633: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
634: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
635: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
636: ,p_num_pers_errored => g_persons_errored);
637: --

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

630: --
631: end loop;
632: --
633: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
634: fnd_message.set_token('PROC','benbatch_utils.write_logfile');
635: ben_batch_utils.write_logfile(p_num_pers_processed => g_persons_processed
636: ,p_num_pers_errored => g_persons_errored);
637: --
638: commit;

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

650: benutils.rollback_cache;
651: --
652: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);
653: g_rec.rep_typ_cd := 'FATAL';
654: g_rec.text := fnd_message.get;
655: g_rec.person_id := l_person_id;
656: --
657: benutils.write(p_text => g_rec.text);
658: benutils.write(p_rec => g_rec);

Line 667: fnd_message.raise_error;

663: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
664: --
665: commit;
666: --
667: fnd_message.raise_error;
668: --
669: End do_multithread;
670: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
671: -- << Procedure: Restart >>

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

715: --
716: fetch c_parameters into l_parameters;
717: If c_parameters%notfound then
718: --
719: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
720: fnd_message.raise_error;
721: --
722: End if;
723: --

Line 720: fnd_message.raise_error;

716: fetch c_parameters into l_parameters;
717: If c_parameters%notfound then
718: --
719: fnd_message.set_name('BEN','BEN_91710_RESTRT_PARMS_NOT_FND');
720: fnd_message.raise_error;
721: --
722: End if;
723: --
724: close c_parameters;

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

1162: ,p_benfts_grp_id => p_benfts_grp_id
1163: ,p_location_id => p_location_id
1164: ,p_legal_entity_id => p_legal_entity_id);
1165: --
1166: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1167: --Bug 2253040
1168: fnd_message.set_token('PROC' , l_proc);
1169: raise l_no_one_to_process;
1170: -- fnd_message.raise_error;

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

1164: ,p_legal_entity_id => p_legal_entity_id);
1165: --
1166: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1167: --Bug 2253040
1168: fnd_message.set_token('PROC' , l_proc);
1169: raise l_no_one_to_process;
1170: -- fnd_message.raise_error;
1171: --Bug 2253040
1172: --

Line 1170: -- fnd_message.raise_error;

1166: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
1167: --Bug 2253040
1168: fnd_message.set_token('PROC' , l_proc);
1169: raise l_no_one_to_process;
1170: -- fnd_message.raise_error;
1171: --Bug 2253040
1172: --
1173: End if;
1174: --

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

1224: hr_utility.trace_off;
1225: Exception
1226: --Bug 2253040
1227: when l_no_one_to_process then
1228: benutils.write(p_text => fnd_message.get);
1229: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1230: --Bug 2253040
1231:
1232: when others then

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

1232: when others then
1233: --
1234: hr_utility.set_location('Super Error',10);
1235: rollback;
1236: benutils.write(p_text => fnd_message.get);
1237: benutils.write(p_text => sqlerrm);
1238: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
1239: If (l_num_range > 0) then
1240: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);

Line 1246: fnd_message.raise_error;

1242: ,p_person_selected => l_person_cnt
1243: ,p_business_group_id => p_business_group_id
1244: ) ;
1245: End if;
1246: fnd_message.raise_error;
1247: End process;
1248: --
1249: end ben_back_out_conc; -- End of Package.