470: rpt_error(p_proc => l_proc
471: ,p_last_actn => l_actn
472: ,p_rpt_flag => p_batch_flag
473: );
474: fnd_message.raise_error;
475: End get_pgm_name;
476: --
477: -- ============================================================================
478: -- << Function: get_pl_type_name >>
533: rpt_error(p_proc => l_proc
534: ,p_last_actn => l_actn
535: ,p_rpt_flag => p_batch_flag
536: );
537: fnd_message.raise_error;
538: End get_pl_typ_name;
539: --
540: -- ============================================================================
541: -- << Function: get_pl_name >>
599: rpt_error(p_proc => l_proc
600: ,p_last_actn => l_actn
601: ,p_rpt_flag => p_batch_flag
602: );
603: fnd_message.raise_error;
604: End get_pl_name;
605: --
606: -- ============================================================================
607: -- << Procedure: get_opt_name >>
670: rpt_error(p_proc => l_proc
671: ,p_last_actn => l_actn
672: ,p_rpt_flag => p_batch_flag
673: );
674: fnd_message.raise_error;
675: End get_opt_name;
676: --
677: -- ============================================================================
678: -- <
704:
705: hr_utility.set_location ('Leaving '||l_proc,99);
706: Exception
707: when others then
708: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
709: fnd_message.set_token('PROC',l_proc);
710: write(fnd_message.get);
711: fnd_message.raise_error;
712: end write_logfile;
705: hr_utility.set_location ('Leaving '||l_proc,99);
706: Exception
707: when others then
708: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
709: fnd_message.set_token('PROC',l_proc);
710: write(fnd_message.get);
711: fnd_message.raise_error;
712: end write_logfile;
713: --
706: Exception
707: when others then
708: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
709: fnd_message.set_token('PROC',l_proc);
710: write(fnd_message.get);
711: fnd_message.raise_error;
712: end write_logfile;
713: --
714: -- ===========================================================================
707: when others then
708: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
709: fnd_message.set_token('PROC',l_proc);
710: write(fnd_message.get);
711: fnd_message.raise_error;
712: end write_logfile;
713: --
714: -- ===========================================================================
715: -- << Procedure: Write_rec >>
1007: ,g_cache_person.bg_name
1008: ;
1009: If c_person%notfound then
1010: close c_person;
1011: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1012: fnd_message.set_token('PROC',l_proc);
1013: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1014: fnd_message.raise_error;
1015: End if;
1008: ;
1009: If c_person%notfound then
1010: close c_person;
1011: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1012: fnd_message.set_token('PROC',l_proc);
1013: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1014: fnd_message.raise_error;
1015: End if;
1016: close c_person;
1009: If c_person%notfound then
1010: close c_person;
1011: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1012: fnd_message.set_token('PROC',l_proc);
1013: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1014: fnd_message.raise_error;
1015: End if;
1016: close c_person;
1017: --
1010: close c_person;
1011: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1012: fnd_message.set_token('PROC',l_proc);
1013: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1014: fnd_message.raise_error;
1015: End if;
1016: close c_person;
1017: --
1018: -- Open cursor to see if the person holds emp person type status and store all
1573: --
1574: rpt_error(p_proc => l_proc
1575: ,p_last_actn => l_actn
1576: ,p_rpt_flag => p_batch_flag);
1577: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1578: fnd_message.set_token('RL',
1579: 'person_selection_rule_id :'||p_person_selection_rule_id);
1580: fnd_message.set_token('PROC',l_proc);
1581: Raise ben_batch_utils.g_record_error;
1574: rpt_error(p_proc => l_proc
1575: ,p_last_actn => l_actn
1576: ,p_rpt_flag => p_batch_flag);
1577: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1578: fnd_message.set_token('RL',
1579: 'person_selection_rule_id :'||p_person_selection_rule_id);
1580: fnd_message.set_token('PROC',l_proc);
1581: Raise ben_batch_utils.g_record_error;
1582: End if;
1576: ,p_rpt_flag => p_batch_flag);
1577: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1578: fnd_message.set_token('RL',
1579: 'person_selection_rule_id :'||p_person_selection_rule_id);
1580: fnd_message.set_token('PROC',l_proc);
1581: Raise ben_batch_utils.g_record_error;
1582: End if;
1583: return l_return;
1584: hr_utility.set_location ('Leaving '||l_proc,10);
1805: --
1806: l_actn := 'getting error message..';
1807: --
1808: l_msg_error_cd := benutils.get_message_name;
1809: l_msg := fnd_message.get;
1810: --
1811: write(p_text => l_msg);
1812: --
1813: if l_msg_error_cd is null then
2468: hr_utility.set_location ('Leaving '||l_proc,10);
2469: Exception
2470: When ben_batch_utils.g_record_error then
2471: p_return := 'N' ;
2472: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2473: fnd_message.set_token('ID' ,to_char(p_person_id) );
2474: fnd_message.set_token('PROC',l_proc ) ;
2475: p_err_message := fnd_message.get ;
2476:
2469: Exception
2470: When ben_batch_utils.g_record_error then
2471: p_return := 'N' ;
2472: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2473: fnd_message.set_token('ID' ,to_char(p_person_id) );
2474: fnd_message.set_token('PROC',l_proc ) ;
2475: p_err_message := fnd_message.get ;
2476:
2477: When value_exception then
2470: When ben_batch_utils.g_record_error then
2471: p_return := 'N' ;
2472: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2473: fnd_message.set_token('ID' ,to_char(p_person_id) );
2474: fnd_message.set_token('PROC',l_proc ) ;
2475: p_err_message := fnd_message.get ;
2476:
2477: When value_exception then
2478: p_return := 'N' ;
2471: p_return := 'N' ;
2472: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2473: fnd_message.set_token('ID' ,to_char(p_person_id) );
2474: fnd_message.set_token('PROC',l_proc ) ;
2475: p_err_message := fnd_message.get ;
2476:
2477: When value_exception then
2478: p_return := 'N' ;
2479: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2475: p_err_message := fnd_message.get ;
2476:
2477: When value_exception then
2478: p_return := 'N' ;
2479: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2480: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2481: fnd_message.set_token('PROC',l_proc ) ;
2482: p_err_message := fnd_message.get ;
2483:
2476:
2477: When value_exception then
2478: p_return := 'N' ;
2479: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2480: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2481: fnd_message.set_token('PROC',l_proc ) ;
2482: p_err_message := fnd_message.get ;
2483:
2484: when others then
2477: When value_exception then
2478: p_return := 'N' ;
2479: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2480: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2481: fnd_message.set_token('PROC',l_proc ) ;
2482: p_err_message := fnd_message.get ;
2483:
2484: when others then
2485: p_return := 'N' ;
2478: p_return := 'N' ;
2479: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2480: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2481: fnd_message.set_token('PROC',l_proc ) ;
2482: p_err_message := fnd_message.get ;
2483:
2484: when others then
2485: p_return := 'N' ;
2486: p_err_message := 'Unhandled exception while processing Person : '||to_char(p_person_id)