466: rpt_error(p_proc => l_proc
467: ,p_last_actn => l_actn
468: ,p_rpt_flag => p_batch_flag
469: );
470: fnd_message.raise_error;
471: End get_pgm_name;
472: --
473: -- ============================================================================
474: -- << Function: get_pl_type_name >>
529: rpt_error(p_proc => l_proc
530: ,p_last_actn => l_actn
531: ,p_rpt_flag => p_batch_flag
532: );
533: fnd_message.raise_error;
534: End get_pl_typ_name;
535: --
536: -- ============================================================================
537: -- << Function: get_pl_name >>
595: rpt_error(p_proc => l_proc
596: ,p_last_actn => l_actn
597: ,p_rpt_flag => p_batch_flag
598: );
599: fnd_message.raise_error;
600: End get_pl_name;
601: --
602: -- ============================================================================
603: -- << Procedure: get_opt_name >>
666: rpt_error(p_proc => l_proc
667: ,p_last_actn => l_actn
668: ,p_rpt_flag => p_batch_flag
669: );
670: fnd_message.raise_error;
671: End get_opt_name;
672: --
673: -- ============================================================================
674: -- <
700:
701: hr_utility.set_location ('Leaving '||l_proc,99);
702: Exception
703: when others then
704: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
705: fnd_message.set_token('PROC',l_proc);
706: write(fnd_message.get);
707: fnd_message.raise_error;
708: end write_logfile;
701: hr_utility.set_location ('Leaving '||l_proc,99);
702: Exception
703: when others then
704: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
705: fnd_message.set_token('PROC',l_proc);
706: write(fnd_message.get);
707: fnd_message.raise_error;
708: end write_logfile;
709: --
702: Exception
703: when others then
704: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
705: fnd_message.set_token('PROC',l_proc);
706: write(fnd_message.get);
707: fnd_message.raise_error;
708: end write_logfile;
709: --
710: -- ===========================================================================
703: when others then
704: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
705: fnd_message.set_token('PROC',l_proc);
706: write(fnd_message.get);
707: fnd_message.raise_error;
708: end write_logfile;
709: --
710: -- ===========================================================================
711: -- << Procedure: Write_rec >>
1003: ,g_cache_person.bg_name
1004: ;
1005: If c_person%notfound then
1006: close c_person;
1007: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1008: fnd_message.set_token('PROC',l_proc);
1009: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1010: fnd_message.raise_error;
1011: End if;
1004: ;
1005: If c_person%notfound then
1006: close c_person;
1007: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1008: fnd_message.set_token('PROC',l_proc);
1009: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1010: fnd_message.raise_error;
1011: End if;
1012: close c_person;
1005: If c_person%notfound then
1006: close c_person;
1007: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1008: fnd_message.set_token('PROC',l_proc);
1009: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1010: fnd_message.raise_error;
1011: End if;
1012: close c_person;
1013: --
1006: close c_person;
1007: fnd_message.set_name('BEN','BEN_91661_BENMNGLE_PERSON_FIND');
1008: fnd_message.set_token('PROC',l_proc);
1009: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1010: fnd_message.raise_error;
1011: End if;
1012: close c_person;
1013: --
1014: -- Open cursor to see if the person holds emp person type status and store all
1563: --
1564: rpt_error(p_proc => l_proc
1565: ,p_last_actn => l_actn
1566: ,p_rpt_flag => p_batch_flag);
1567: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1568: fnd_message.set_token('RL',
1569: 'person_selection_rule_id :'||p_person_selection_rule_id);
1570: fnd_message.set_token('PROC',l_proc);
1571: Raise ben_batch_utils.g_record_error;
1564: rpt_error(p_proc => l_proc
1565: ,p_last_actn => l_actn
1566: ,p_rpt_flag => p_batch_flag);
1567: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1568: fnd_message.set_token('RL',
1569: 'person_selection_rule_id :'||p_person_selection_rule_id);
1570: fnd_message.set_token('PROC',l_proc);
1571: Raise ben_batch_utils.g_record_error;
1572: End if;
1566: ,p_rpt_flag => p_batch_flag);
1567: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1568: fnd_message.set_token('RL',
1569: 'person_selection_rule_id :'||p_person_selection_rule_id);
1570: fnd_message.set_token('PROC',l_proc);
1571: Raise ben_batch_utils.g_record_error;
1572: End if;
1573: return l_return;
1574: hr_utility.set_location ('Leaving '||l_proc,10);
1795: --
1796: l_actn := 'getting error message..';
1797: --
1798: l_msg_error_cd := benutils.get_message_name;
1799: l_msg := fnd_message.get;
1800: --
1801: write(p_text => l_msg);
1802: --
1803: if l_msg_error_cd is null then
2450: hr_utility.set_location ('Leaving '||l_proc,10);
2451: Exception
2452: When ben_batch_utils.g_record_error then
2453: p_return := 'N' ;
2454: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2455: fnd_message.set_token('ID' ,to_char(p_person_id) );
2456: fnd_message.set_token('PROC',l_proc ) ;
2457: p_err_message := fnd_message.get ;
2458:
2451: Exception
2452: When ben_batch_utils.g_record_error then
2453: p_return := 'N' ;
2454: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2455: fnd_message.set_token('ID' ,to_char(p_person_id) );
2456: fnd_message.set_token('PROC',l_proc ) ;
2457: p_err_message := fnd_message.get ;
2458:
2459: When value_exception then
2452: When ben_batch_utils.g_record_error then
2453: p_return := 'N' ;
2454: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2455: fnd_message.set_token('ID' ,to_char(p_person_id) );
2456: fnd_message.set_token('PROC',l_proc ) ;
2457: p_err_message := fnd_message.get ;
2458:
2459: When value_exception then
2460: p_return := 'N' ;
2453: p_return := 'N' ;
2454: fnd_message.set_name('BEN','BEN_91698_NO_ASSIGNMENT_FND');
2455: fnd_message.set_token('ID' ,to_char(p_person_id) );
2456: fnd_message.set_token('PROC',l_proc ) ;
2457: p_err_message := fnd_message.get ;
2458:
2459: When value_exception then
2460: p_return := 'N' ;
2461: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2457: p_err_message := fnd_message.get ;
2458:
2459: When value_exception then
2460: p_return := 'N' ;
2461: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2462: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2463: fnd_message.set_token('PROC',l_proc ) ;
2464: p_err_message := fnd_message.get ;
2465:
2458:
2459: When value_exception then
2460: p_return := 'N' ;
2461: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2462: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2463: fnd_message.set_token('PROC',l_proc ) ;
2464: p_err_message := fnd_message.get ;
2465:
2466: when others then
2459: When value_exception then
2460: p_return := 'N' ;
2461: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2462: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2463: fnd_message.set_token('PROC',l_proc ) ;
2464: p_err_message := fnd_message.get ;
2465:
2466: when others then
2467: p_return := 'N' ;
2460: p_return := 'N' ;
2461: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2462: fnd_message.set_token('RL','person_selection_rule_id :'||p_person_selection_rule_id);
2463: fnd_message.set_token('PROC',l_proc ) ;
2464: p_err_message := fnd_message.get ;
2465:
2466: when others then
2467: p_return := 'N' ;
2468: p_err_message := 'Unhandled exception while processing Person : '||to_char(p_person_id)