325: AND (X_Top_Position_Method IS NULL)))
326: ) then
327: return;
328: else
329: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
330: APP_EXCEPTION.RAISE_EXCEPTION;
331: end if;
332: END Lock_Row;
333: -----------------------------------------------------------------------------
449: fetch c1 into l_dummy;
450: --
451: if c1%found then
452: close c1;
453: fnd_message.set_name('PAY', 'PER_7062_DEF_SECPROF_EXISTS');
454: fnd_message.raise_error;
455: end if;
456: close c1;
457: --
450: --
451: if c1%found then
452: close c1;
453: fnd_message.set_name('PAY', 'PER_7062_DEF_SECPROF_EXISTS');
454: fnd_message.raise_error;
455: end if;
456: close c1;
457: --
458: end check_uniqueness;
482: open c1;
483: fetch c1 into l_dummy;
484: if c1%found then
485: close c1;
486: fnd_message.set_name('PAY', 'PER_7063_DEF_SECPROF_USERNAME');
487: fnd_message.raise_error;
488: end if;
489: close c1;
490: --
483: fetch c1 into l_dummy;
484: if c1%found then
485: close c1;
486: fnd_message.set_name('PAY', 'PER_7063_DEF_SECPROF_USERNAME');
487: fnd_message.raise_error;
488: end if;
489: close c1;
490: --
491: open c2;
556: -- There was an error whilst trying to verify the
557: -- custom restriction. Wrap the SQL error in a message
558: -- and raise it back to the user.
559: --
560: fnd_message.set_name('PER','HR_289835_PSP_CUSTOM_ERR');
561: fnd_message.set_token('SQLERRM',SQLERRM);
562: fnd_message.raise_error;
563: end check_sql_fragment;
564:
557: -- custom restriction. Wrap the SQL error in a message
558: -- and raise it back to the user.
559: --
560: fnd_message.set_name('PER','HR_289835_PSP_CUSTOM_ERR');
561: fnd_message.set_token('SQLERRM',SQLERRM);
562: fnd_message.raise_error;
563: end check_sql_fragment;
564:
565: -- Bug #2809163
558: -- and raise it back to the user.
559: --
560: fnd_message.set_name('PER','HR_289835_PSP_CUSTOM_ERR');
561: fnd_message.set_token('SQLERRM',SQLERRM);
562: fnd_message.raise_error;
563: end check_sql_fragment;
564:
565: -- Bug #2809163
566: procedure check_assigned_sec_profile(p_security_profile_id number)is