70: open csr_class_rule;
71: fetch csr_class_rule into v_dummy;
72: if csr_class_rule%found then
73: close csr_class_rule;
74: hr_utility.set_message(801, 'HR_7102_ELE_SET_CLASS_EXISTS');
75: hr_utility.raise_error;
76: else
77: close csr_class_rule;
78: end if;
71: fetch csr_class_rule into v_dummy;
72: if csr_class_rule%found then
73: close csr_class_rule;
74: hr_utility.set_message(801, 'HR_7102_ELE_SET_CLASS_EXISTS');
75: hr_utility.raise_error;
76: else
77: close csr_class_rule;
78: end if;
79: --
126: -- The insert of an include element rule and the removal of an exclude
127: -- element rule have both failed which means the element is already part
128: -- of the set.
129: if sql%notfound then
130: hr_utility.set_message(801, 'HR_7701_ELE_SET_CLASS_EXIST');
131: hr_utility.raise_error;
132: end if;
133: --
134: end if;
127: -- element rule have both failed which means the element is already part
128: -- of the set.
129: if sql%notfound then
130: hr_utility.set_message(801, 'HR_7701_ELE_SET_CLASS_EXIST');
131: hr_utility.raise_error;
132: end if;
133: --
134: end if;
135: --
249: OPEN C;
250: FETCH C INTO X_Rowid;
251: if (C%NOTFOUND) then
252: CLOSE C;
253: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
254: hr_utility.set_message_token('PROCEDURE',
255: 'pay_element_type_rules_pkg.insert_row');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
250: FETCH C INTO X_Rowid;
251: if (C%NOTFOUND) then
252: CLOSE C;
253: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
254: hr_utility.set_message_token('PROCEDURE',
255: 'pay_element_type_rules_pkg.insert_row');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
258: end if;
252: CLOSE C;
253: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
254: hr_utility.set_message_token('PROCEDURE',
255: 'pay_element_type_rules_pkg.insert_row');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
258: end if;
259: CLOSE C;
260: --
253: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
254: hr_utility.set_message_token('PROCEDURE',
255: 'pay_element_type_rules_pkg.insert_row');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
258: end if;
259: CLOSE C;
260: --
261: END Insert_Row;
287: OPEN C;
288: FETCH C INTO Recinfo;
289: if (C%NOTFOUND) then
290: CLOSE C;
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE',
293: 'pay_element_type_rules_pkg.lock_row');
294: hr_utility.set_message_token('STEP','1');
295: hr_utility.raise_error;
288: FETCH C INTO Recinfo;
289: if (C%NOTFOUND) then
290: CLOSE C;
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE',
293: 'pay_element_type_rules_pkg.lock_row');
294: hr_utility.set_message_token('STEP','1');
295: hr_utility.raise_error;
296: end if;
290: CLOSE C;
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE',
293: 'pay_element_type_rules_pkg.lock_row');
294: hr_utility.set_message_token('STEP','1');
295: hr_utility.raise_error;
296: end if;
297: CLOSE C;
298: --
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE',
293: 'pay_element_type_rules_pkg.lock_row');
294: hr_utility.set_message_token('STEP','1');
295: hr_utility.raise_error;
296: end if;
297: CLOSE C;
298: --
299: -- Remove trailing spaces.
347: last_update_login = X_Last_Update_Login
348: WHERE rowid = X_rowid;
349: --
350: if (SQL%NOTFOUND) then
351: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: hr_utility.set_message_token('PROCEDURE',
353: 'pay_element_type_rules_pkg.update_row');
354: hr_utility.set_message_token('STEP','1');
355: hr_utility.raise_error;
348: WHERE rowid = X_rowid;
349: --
350: if (SQL%NOTFOUND) then
351: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: hr_utility.set_message_token('PROCEDURE',
353: 'pay_element_type_rules_pkg.update_row');
354: hr_utility.set_message_token('STEP','1');
355: hr_utility.raise_error;
356: end if;
350: if (SQL%NOTFOUND) then
351: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: hr_utility.set_message_token('PROCEDURE',
353: 'pay_element_type_rules_pkg.update_row');
354: hr_utility.set_message_token('STEP','1');
355: hr_utility.raise_error;
356: end if;
357: --
358: END Update_Row;
351: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: hr_utility.set_message_token('PROCEDURE',
353: 'pay_element_type_rules_pkg.update_row');
354: hr_utility.set_message_token('STEP','1');
355: hr_utility.raise_error;
356: end if;
357: --
358: END Update_Row;
359: --
375: DELETE FROM pay_element_type_rules
376: WHERE rowid = X_Rowid;
377: --
378: if (SQL%NOTFOUND) then
379: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
380: hr_utility.set_message_token('PROCEDURE',
381: 'pay_element_type_rules_pkg.delete_row');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
376: WHERE rowid = X_Rowid;
377: --
378: if (SQL%NOTFOUND) then
379: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
380: hr_utility.set_message_token('PROCEDURE',
381: 'pay_element_type_rules_pkg.delete_row');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: end if;
378: if (SQL%NOTFOUND) then
379: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
380: hr_utility.set_message_token('PROCEDURE',
381: 'pay_element_type_rules_pkg.delete_row');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: end if;
385: --
386: END Delete_Row;
379: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
380: hr_utility.set_message_token('PROCEDURE',
381: 'pay_element_type_rules_pkg.delete_row');
382: hr_utility.set_message_token('STEP','1');
383: hr_utility.raise_error;
384: end if;
385: --
386: END Delete_Row;
387: --