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: -----------------------------------------------------------------------------
469: fetch c1 into l_dummy;
470: --
471: if c1%found then
472: close c1;
473: fnd_message.set_name('PAY', 'PER_7062_DEF_SECPROF_EXISTS');
474: fnd_message.raise_error;
475: end if;
476: close c1;
477: --
470: --
471: if c1%found then
472: close c1;
473: fnd_message.set_name('PAY', 'PER_7062_DEF_SECPROF_EXISTS');
474: fnd_message.raise_error;
475: end if;
476: close c1;
477: --
478: end check_uniqueness;
502: open c1;
503: fetch c1 into l_dummy;
504: if c1%found then
505: close c1;
506: fnd_message.set_name('PAY', 'PER_7063_DEF_SECPROF_USERNAME');
507: fnd_message.raise_error;
508: end if;
509: close c1;
510: --
503: fetch c1 into l_dummy;
504: if c1%found then
505: close c1;
506: fnd_message.set_name('PAY', 'PER_7063_DEF_SECPROF_USERNAME');
507: fnd_message.raise_error;
508: end if;
509: close c1;
510: --
511: open c2;
600: -- There was an error whilst trying to verify the
601: -- custom restriction. Wrap the SQL error in a message
602: -- and raise it back to the user.
603: --
604: fnd_message.set_name('PER','HR_289835_PSP_CUSTOM_ERR');
605: fnd_message.set_token('SQLERRM',SQLERRM);
606: fnd_message.raise_error;
607: end check_sql_fragment;
608:
601: -- custom restriction. Wrap the SQL error in a message
602: -- and raise it back to the user.
603: --
604: fnd_message.set_name('PER','HR_289835_PSP_CUSTOM_ERR');
605: fnd_message.set_token('SQLERRM',SQLERRM);
606: fnd_message.raise_error;
607: end check_sql_fragment;
608:
609: -- Bug #2809163
602: -- and raise it back to the user.
603: --
604: fnd_message.set_name('PER','HR_289835_PSP_CUSTOM_ERR');
605: fnd_message.set_token('SQLERRM',SQLERRM);
606: fnd_message.raise_error;
607: end check_sql_fragment;
608:
609: -- Bug #2809163
610: procedure check_assigned_sec_profile(p_security_profile_id number)is