1883: fetch c1 into p_rec;
1884: if c1%notfound then
1885: --
1886: close c1;
1887: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1888: fnd_message.set_token('PROC',l_proc);
1889: fnd_message.set_token('PERSON_ID',p_person_id);
1890: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1891: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
1884: if c1%notfound then
1885: --
1886: close c1;
1887: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1888: fnd_message.set_token('PROC',l_proc);
1889: fnd_message.set_token('PERSON_ID',p_person_id);
1890: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1891: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
1892: fnd_message.raise_error;
1885: --
1886: close c1;
1887: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1888: fnd_message.set_token('PROC',l_proc);
1889: fnd_message.set_token('PERSON_ID',p_person_id);
1890: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1891: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
1892: fnd_message.raise_error;
1893: --
1886: close c1;
1887: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1888: fnd_message.set_token('PROC',l_proc);
1889: fnd_message.set_token('PERSON_ID',p_person_id);
1890: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1891: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
1892: fnd_message.raise_error;
1893: --
1894: end if;
1887: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
1888: fnd_message.set_token('PROC',l_proc);
1889: fnd_message.set_token('PERSON_ID',p_person_id);
1890: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1891: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
1892: fnd_message.raise_error;
1893: --
1894: end if;
1895: --
1888: fnd_message.set_token('PROC',l_proc);
1889: fnd_message.set_token('PERSON_ID',p_person_id);
1890: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
1891: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
1892: fnd_message.raise_error;
1893: --
1894: end if;
1895: --
1896: close c1;
2047: fetch c1 into p_rec.min_per_effective_start_date;
2048: if c1%notfound then
2049: --
2050: close c1;
2051: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
2052: fnd_message.set_token('PROC',l_proc);
2053: fnd_message.set_token('PERSON_ID',p_person_id);
2054: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2055: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
2048: if c1%notfound then
2049: --
2050: close c1;
2051: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
2052: fnd_message.set_token('PROC',l_proc);
2053: fnd_message.set_token('PERSON_ID',p_person_id);
2054: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2055: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
2056: fnd_message.raise_error;
2049: --
2050: close c1;
2051: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
2052: fnd_message.set_token('PROC',l_proc);
2053: fnd_message.set_token('PERSON_ID',p_person_id);
2054: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2055: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
2056: fnd_message.raise_error;
2057: --
2050: close c1;
2051: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
2052: fnd_message.set_token('PROC',l_proc);
2053: fnd_message.set_token('PERSON_ID',p_person_id);
2054: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2055: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
2056: fnd_message.raise_error;
2057: --
2058: end if;
2051: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');
2052: fnd_message.set_token('PROC',l_proc);
2053: fnd_message.set_token('PERSON_ID',p_person_id);
2054: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2055: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
2056: fnd_message.raise_error;
2057: --
2058: end if;
2059: --
2052: fnd_message.set_token('PROC',l_proc);
2053: fnd_message.set_token('PERSON_ID',p_person_id);
2054: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);
2055: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
2056: fnd_message.raise_error;
2057: --
2058: end if;
2059: --
2060: close c1;
3629: exception
3630: --
3631: when no_data_found then
3632: --
3633: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3634: fnd_message.set_token('PROC',l_proc);
3635: fnd_message.set_token('PERSON_ID',p_person_id);
3636: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3637: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
3630: --
3631: when no_data_found then
3632: --
3633: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3634: fnd_message.set_token('PROC',l_proc);
3635: fnd_message.set_token('PERSON_ID',p_person_id);
3636: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3637: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
3638: fnd_message.raise_error;
3631: when no_data_found then
3632: --
3633: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3634: fnd_message.set_token('PROC',l_proc);
3635: fnd_message.set_token('PERSON_ID',p_person_id);
3636: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3637: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
3638: fnd_message.raise_error;
3639: --
3632: --
3633: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3634: fnd_message.set_token('PROC',l_proc);
3635: fnd_message.set_token('PERSON_ID',p_person_id);
3636: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3637: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
3638: fnd_message.raise_error;
3639: --
3640: end get_bal_per_object;
3633: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');
3634: fnd_message.set_token('PROC',l_proc);
3635: fnd_message.set_token('PERSON_ID',p_person_id);
3636: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3637: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
3638: fnd_message.raise_error;
3639: --
3640: end get_bal_per_object;
3641: --
3634: fnd_message.set_token('PROC',l_proc);
3635: fnd_message.set_token('PERSON_ID',p_person_id);
3636: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);
3637: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795
3638: fnd_message.raise_error;
3639: --
3640: end get_bal_per_object;
3641: --
3642: procedure get_object(p_person_id in number,