1829: fetch c1 into p_rec;
1830: if c1%notfound then
1831: --
1832: close c1;
1833: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1834: fnd_message.set_token('PROC',l_proc);
1835: fnd_message.set_token('PERSON_ID',p_person_id);
1836: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1837: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1830: if c1%notfound then
1831: --
1832: close c1;
1833: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1834: fnd_message.set_token('PROC',l_proc);
1835: fnd_message.set_token('PERSON_ID',p_person_id);
1836: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1837: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1838: fnd_message.raise_error;
1831: --
1832: close c1;
1833: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1834: fnd_message.set_token('PROC',l_proc);
1835: fnd_message.set_token('PERSON_ID',p_person_id);
1836: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1837: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1838: fnd_message.raise_error;
1839: --
1832: close c1;
1833: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1834: fnd_message.set_token('PROC',l_proc);
1835: fnd_message.set_token('PERSON_ID',p_person_id);
1836: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1837: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1838: fnd_message.raise_error;
1839: --
1840: end if;
1833: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1834: fnd_message.set_token('PROC',l_proc);
1835: fnd_message.set_token('PERSON_ID',p_person_id);
1836: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1837: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1838: fnd_message.raise_error;
1839: --
1840: end if;
1841: --
1834: fnd_message.set_token('PROC',l_proc);
1835: fnd_message.set_token('PERSON_ID',p_person_id);
1836: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1837: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1838: fnd_message.raise_error;
1839: --
1840: end if;
1841: --
1842: close c1;
1993: fetch c1 into p_rec.min_per_effective_start_date;
1994: if c1%notfound then
1995: --
1996: close c1;
1997: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1998: fnd_message.set_token('PROC',l_proc);
1999: fnd_message.set_token('PERSON_ID',p_person_id);
2000: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2001: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1994: if c1%notfound then
1995: --
1996: close c1;
1997: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1998: fnd_message.set_token('PROC',l_proc);
1999: fnd_message.set_token('PERSON_ID',p_person_id);
2000: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2001: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2002: fnd_message.raise_error;
1995: --
1996: close c1;
1997: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1998: fnd_message.set_token('PROC',l_proc);
1999: fnd_message.set_token('PERSON_ID',p_person_id);
2000: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2001: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2002: fnd_message.raise_error;
2003: --
1996: close c1;
1997: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1998: fnd_message.set_token('PROC',l_proc);
1999: fnd_message.set_token('PERSON_ID',p_person_id);
2000: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2001: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2002: fnd_message.raise_error;
2003: --
2004: end if;
1997: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1998: fnd_message.set_token('PROC',l_proc);
1999: fnd_message.set_token('PERSON_ID',p_person_id);
2000: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2001: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2002: fnd_message.raise_error;
2003: --
2004: end if;
2005: --
1998: fnd_message.set_token('PROC',l_proc);
1999: fnd_message.set_token('PERSON_ID',p_person_id);
2000: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2001: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2002: fnd_message.raise_error;
2003: --
2004: end if;
2005: --
2006: close c1;
3474: exception
3475: --
3476: when no_data_found then
3477: --
3478: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3479: fnd_message.set_token('PROC',l_proc);
3480: fnd_message.set_token('PERSON_ID',p_person_id);
3481: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3482: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3475: --
3476: when no_data_found then
3477: --
3478: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3479: fnd_message.set_token('PROC',l_proc);
3480: fnd_message.set_token('PERSON_ID',p_person_id);
3481: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3482: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3483: fnd_message.raise_error;
3476: when no_data_found then
3477: --
3478: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3479: fnd_message.set_token('PROC',l_proc);
3480: fnd_message.set_token('PERSON_ID',p_person_id);
3481: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3482: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3483: fnd_message.raise_error;
3484: --
3477: --
3478: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3479: fnd_message.set_token('PROC',l_proc);
3480: fnd_message.set_token('PERSON_ID',p_person_id);
3481: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3482: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3483: fnd_message.raise_error;
3484: --
3485: end get_bal_per_object;
3478: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3479: fnd_message.set_token('PROC',l_proc);
3480: fnd_message.set_token('PERSON_ID',p_person_id);
3481: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3482: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3483: fnd_message.raise_error;
3484: --
3485: end get_bal_per_object;
3486: --
3479: fnd_message.set_token('PROC',l_proc);
3480: fnd_message.set_token('PERSON_ID',p_person_id);
3481: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3482: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3483: fnd_message.raise_error;
3484: --
3485: end get_bal_per_object;
3486: --
3487: procedure get_object(p_person_id in number,