DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on FND_MESSAGE

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

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

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

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;

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

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

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

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;

Line 1891: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795

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

Line 1892: fnd_message.raise_error;

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;

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

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

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

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;

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

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

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

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;

Line 2055: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795

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

Line 2056: fnd_message.raise_error;

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;

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

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

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

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;

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

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

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

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;

Line 3637: fnd_message.set_token('EFFECTIVE_DATE',fnd_date.date_to_chardate(p_effective_date,calendar_aware=>2));--Bug 12759795

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

Line 3638: fnd_message.raise_error;

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,