DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on FND_MESSAGE

Line 1833: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');

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);

Line 1834: fnd_message.set_token('PROC',l_proc);

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;

Line 1835: fnd_message.set_token('PERSON_ID',p_person_id);

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: --

Line 1836: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);

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;

Line 1837: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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: --

Line 1838: fnd_message.raise_error;

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;

Line 1997: fnd_message.set_name('BEN','BEN_92308_OBJECT_NOT_FOUND');

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);

Line 1998: fnd_message.set_token('PROC',l_proc);

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;

Line 1999: fnd_message.set_token('PERSON_ID',p_person_id);

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: --

Line 2000: fnd_message.set_token('BUSINESS_GROUP_ID',p_business_group_id);

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;

Line 2001: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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: --

Line 2002: fnd_message.raise_error;

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;

Line 3478: fnd_message.set_name('BEN','BEN_92309_OBJECT_NOT_FOUND');

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);

Line 3479: fnd_message.set_token('PROC',l_proc);

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;

Line 3480: fnd_message.set_token('PERSON_ID',p_person_id);

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: --

Line 3481: fnd_message.set_token('BNFTS_BAL_ID',p_bnfts_bal_id);

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;

Line 3482: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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: --

Line 3483: fnd_message.raise_error;

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,