525: --
526: -- write log message indicating related person potentials are
527: -- are voided.
528: --
529: fnd_message.set_name('BEN','BEN_92507_CON_PTNLS_VOIDD');
530: benutils.write(p_text => fnd_message.get);
531: --
532: elsif l_con_ptnls_rec.ptnl_ler_for_per_stat_cd in
533: ('VOIDD', 'MNL', 'BCKDT', 'MNLO')
526: -- write log message indicating related person potentials are
527: -- are voided.
528: --
529: fnd_message.set_name('BEN','BEN_92507_CON_PTNLS_VOIDD');
530: benutils.write(p_text => fnd_message.get);
531: --
532: elsif l_con_ptnls_rec.ptnl_ler_for_per_stat_cd in
533: ('VOIDD', 'MNL', 'BCKDT', 'MNLO')
534: then
540: --
541: -- write log message indicating some of the related person potentials are
542: -- are already set to voided or manual or manual override or backed out.
543: --
544: fnd_message.set_name('BEN','BEN_92508_CON_PTNLS_VMBMO');
545: benutils.write(p_text => fnd_message.get);
546: --
547: elsif l_con_ptnls_rec.ptnl_ler_for_per_stat_cd = 'PROCD'
548: then
541: -- write log message indicating some of the related person potentials are
542: -- are already set to voided or manual or manual override or backed out.
543: --
544: fnd_message.set_name('BEN','BEN_92508_CON_PTNLS_VMBMO');
545: benutils.write(p_text => fnd_message.get);
546: --
547: elsif l_con_ptnls_rec.ptnl_ler_for_per_stat_cd = 'PROCD'
548: then
549: --
582: --
583: -- write log message indicating some of the related person
584: -- per in lers are backed out.
585: --
586: fnd_message.set_name('BEN','BEN_92509_CON_PILS_VOIDD');
587: benutils.write(p_text => fnd_message.get);
588: --
589: end loop;
590:
583: -- write log message indicating some of the related person
584: -- per in lers are backed out.
585: --
586: fnd_message.set_name('BEN','BEN_92509_CON_PILS_VOIDD');
587: benutils.write(p_text => fnd_message.get);
588: --
589: end loop;
590:
591:
2225:
2226: BEGIN
2227: -- hr_utility.set_location('Entering:'|| l_proc, 10);
2228:
2229: l_encoded_msg := fnd_message.get_encoded();
2230: fnd_message.parse_encoded(
2231: encoded_message => l_encoded_msg
2232: ,app_short_name => l_msg_app -- OUT
2233: ,message_name => l_msg_name -- OUT
2226: BEGIN
2227: -- hr_utility.set_location('Entering:'|| l_proc, 10);
2228:
2229: l_encoded_msg := fnd_message.get_encoded();
2230: fnd_message.parse_encoded(
2231: encoded_message => l_encoded_msg
2232: ,app_short_name => l_msg_app -- OUT
2233: ,message_name => l_msg_name -- OUT
2234: );
5123: end loop ;
5124: --
5125: exception
5126: --
5127: when OTHERS then -- exception number raised when FND_MESSAGE.raise_error is called
5128: --
5129: l_err_num := SQLCODE ;
5130: --
5131: if l_err_num = -20001 then
5135: if l_msg_name = 'BEN_92705_REIMB_RQST_APPROVD' then
5136: --
5137: -- set our own message name and raise the exception again
5138: --
5139: fnd_message.set_name('BEN', 'BEN_93188_APRVD_CLM_NO_BCKOUT');
5140: fnd_message.raise_error;
5141: --
5142: else
5143: --
5136: --
5137: -- set our own message name and raise the exception again
5138: --
5139: fnd_message.set_name('BEN', 'BEN_93188_APRVD_CLM_NO_BCKOUT');
5140: fnd_message.raise_error;
5141: --
5142: else
5143: --
5144: fnd_message.raise_error;
5140: fnd_message.raise_error;
5141: --
5142: else
5143: --
5144: fnd_message.raise_error;
5145: --
5146: end if;
5147: --
5148: end if;
6576: end loop;
6577: --
6578:
6579: else
6580: fnd_message.set_name('BEN','BEN_92535_UNKNOWN_DELETE_RTN');
6581: fnd_message.set_token('PROC',l_package);
6582: fnd_message.set_token('ROUTINE',p_routine);
6583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
6584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
6577: --
6578:
6579: else
6580: fnd_message.set_name('BEN','BEN_92535_UNKNOWN_DELETE_RTN');
6581: fnd_message.set_token('PROC',l_package);
6582: fnd_message.set_token('ROUTINE',p_routine);
6583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
6584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
6585: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6578:
6579: else
6580: fnd_message.set_name('BEN','BEN_92535_UNKNOWN_DELETE_RTN');
6581: fnd_message.set_token('PROC',l_package);
6582: fnd_message.set_token('ROUTINE',p_routine);
6583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
6584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
6585: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6586: raise ben_manage_life_events.g_record_error;
6579: else
6580: fnd_message.set_name('BEN','BEN_92535_UNKNOWN_DELETE_RTN');
6581: fnd_message.set_token('PROC',l_package);
6582: fnd_message.set_token('ROUTINE',p_routine);
6583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
6584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
6585: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6586: raise ben_manage_life_events.g_record_error;
6587:
6580: fnd_message.set_name('BEN','BEN_92535_UNKNOWN_DELETE_RTN');
6581: fnd_message.set_token('PROC',l_package);
6582: fnd_message.set_token('ROUTINE',p_routine);
6583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
6584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
6585: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6586: raise ben_manage_life_events.g_record_error;
6587:
6588: end if;
6581: fnd_message.set_token('PROC',l_package);
6582: fnd_message.set_token('ROUTINE',p_routine);
6583: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
6584: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
6585: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
6586: raise ben_manage_life_events.g_record_error;
6587:
6588: end if;
6589: --