58: IF C1%NOTFOUND THEN
59: CLOSE C1;
60: ELSE
61: CLOSE C1;
62: hr_utility.set_message('801','HR_7777_DEF_DESCR_EXISTS');
63: hr_utility.raise_error;
64: END IF;
65:
66: end UNIQUENESS_CHECK;
59: CLOSE C1;
60: ELSE
61: CLOSE C1;
62: hr_utility.set_message('801','HR_7777_DEF_DESCR_EXISTS');
63: hr_utility.raise_error;
64: END IF;
65:
66: end UNIQUENESS_CHECK;
67:
164: open c;
165: fetch c into X_ROWID;
166: if (c%notfound) then
167: close c;
168: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE',
170: 'per_customized_restr_pkg.insert_row');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
165: fetch c into X_ROWID;
166: if (c%notfound) then
167: close c;
168: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE',
170: 'per_customized_restr_pkg.insert_row');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
173:
167: close c;
168: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE',
170: 'per_customized_restr_pkg.insert_row');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
173:
174: raise no_data_found;
175: end if;
168: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE',
170: 'per_customized_restr_pkg.insert_row');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
173:
174: raise no_data_found;
175: end if;
176: close c;