DBA Data[Home] [Help]

APPS.BEN_PROCESS_USER_SS_API dependencies on FND_MESSAGE

Line 208: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

204: fetch lc_get_sec_group_id into l_dummy;
205: if lc_get_sec_group_id%NOTFOUND
206: then
207: close lc_get_sec_group_id;
208: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
210: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
211: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
212: hr_utility.raise_error;

Line 209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');

205: if lc_get_sec_group_id%NOTFOUND
206: then
207: close lc_get_sec_group_id;
208: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
210: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
211: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
212: hr_utility.raise_error;
213: else

Line 210: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');

206: then
207: close lc_get_sec_group_id;
208: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
210: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
211: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
212: hr_utility.raise_error;
213: else
214: close lc_get_sec_group_id;

Line 211: fnd_message.set_token('VALUE', to_char(p_sec_group_id));

207: close lc_get_sec_group_id;
208: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
210: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
211: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
212: hr_utility.raise_error;
213: else
214: close lc_get_sec_group_id;
215: end if;

Line 226: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

222: --
223: if lc_get_sec_profile%NOTFOUND
224: then
225: close lc_get_sec_profile;
226: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
227: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
228: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
229: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
230: hr_utility.raise_error;

Line 227: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');

223: if lc_get_sec_profile%NOTFOUND
224: then
225: close lc_get_sec_profile;
226: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
227: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
228: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
229: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
230: hr_utility.raise_error;
231: else

Line 228: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');

224: then
225: close lc_get_sec_profile;
226: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
227: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
228: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
229: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
230: hr_utility.raise_error;
231: else
232: close lc_get_sec_profile;

Line 229: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));

225: close lc_get_sec_profile;
226: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
227: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
228: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
229: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
230: hr_utility.raise_error;
231: else
232: close lc_get_sec_profile;
233: end if;

Line 637: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

633: fetch lc_get_sec_group_id into l_sec_group_id;
634: if lc_get_sec_group_id%NOTFOUND then
635:
636: close lc_get_sec_group_id;
637: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
639: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
640: fnd_message.set_token('VALUE', to_char(p_business_group_id));
641: hr_utility.raise_error;

Line 638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');

634: if lc_get_sec_group_id%NOTFOUND then
635:
636: close lc_get_sec_group_id;
637: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
639: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
640: fnd_message.set_token('VALUE', to_char(p_business_group_id));
641: hr_utility.raise_error;
642: else

Line 639: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');

635:
636: close lc_get_sec_group_id;
637: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
639: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
640: fnd_message.set_token('VALUE', to_char(p_business_group_id));
641: hr_utility.raise_error;
642: else
643: close lc_get_sec_group_id;

Line 640: fnd_message.set_token('VALUE', to_char(p_business_group_id));

636: close lc_get_sec_group_id;
637: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
639: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
640: fnd_message.set_token('VALUE', to_char(p_business_group_id));
641: hr_utility.raise_error;
642: else
643: close lc_get_sec_group_id;
644: end if;