123: open csr_unique_bal_classification(l_mode);
124: fetch csr_unique_bal_classification into v_bal_classification_id;
125: if csr_unique_bal_classification%notfound then
126: close csr_unique_bal_classification;
127: hr_utility.set_message(801, 'HR_6116_BAL_UNI_CLAS');
128: hr_utility.raise_error;
129: else
130: close csr_unique_bal_classification;
131: end if;
124: fetch csr_unique_bal_classification into v_bal_classification_id;
125: if csr_unique_bal_classification%notfound then
126: close csr_unique_bal_classification;
127: hr_utility.set_message(801, 'HR_6116_BAL_UNI_CLAS');
128: hr_utility.raise_error;
129: else
130: close csr_unique_bal_classification;
131: end if;
132: --
172: -- disable the use of classifications and therefore make this operation
173: -- invalid.
174: --
175: if hr_balance_feeds.manual_bal_feeds_exist(X_Balance_Type_Id) then
176: hr_utility.set_message(801, 'HR_7445_BAL_CLASS_NO_CREATE');
177: hr_utility.raise_error;
178: end if;
179: --
180: -- Make sure that there are no duplicate balance classifications NB. there
173: -- invalid.
174: --
175: if hr_balance_feeds.manual_bal_feeds_exist(X_Balance_Type_Id) then
176: hr_utility.set_message(801, 'HR_7445_BAL_CLASS_NO_CREATE');
177: hr_utility.raise_error;
178: end if;
179: --
180: -- Make sure that there are no duplicate balance classifications NB. there
181: -- can only be one classification per family ie. one of parent and its sub
213: OPEN C;
214: FETCH C INTO X_Rowid;
215: if (C%NOTFOUND) then
216: CLOSE C;
217: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
218: hr_utility.set_message_token('PROCEDURE',
219: 'pay_bal_classifications_pkg.insert_row');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
214: FETCH C INTO X_Rowid;
215: if (C%NOTFOUND) then
216: CLOSE C;
217: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
218: hr_utility.set_message_token('PROCEDURE',
219: 'pay_bal_classifications_pkg.insert_row');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
216: CLOSE C;
217: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
218: hr_utility.set_message_token('PROCEDURE',
219: 'pay_bal_classifications_pkg.insert_row');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223: CLOSE C;
224: --
217: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
218: hr_utility.set_message_token('PROCEDURE',
219: 'pay_bal_classifications_pkg.insert_row');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223: CLOSE C;
224: --
225: -- Create balance feeds for elements with the same Classification /
265: OPEN C;
266: FETCH C INTO Recinfo;
267: if (C%NOTFOUND) then
268: CLOSE C;
269: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('PROCEDURE',
271: 'pay_bal_classifications_pkg.lock_row');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
266: FETCH C INTO Recinfo;
267: if (C%NOTFOUND) then
268: CLOSE C;
269: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('PROCEDURE',
271: 'pay_bal_classifications_pkg.lock_row');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end if;
268: CLOSE C;
269: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('PROCEDURE',
271: 'pay_bal_classifications_pkg.lock_row');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end if;
275: CLOSE C;
276: --
269: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
270: hr_utility.set_message_token('PROCEDURE',
271: 'pay_bal_classifications_pkg.lock_row');
272: hr_utility.set_message_token('STEP','1');
273: hr_utility.raise_error;
274: end if;
275: CLOSE C;
276: --
277: -- Remove trailing spaces.
340: legislation_subgroup = X_Legislation_Subgroup
341: WHERE rowid = X_rowid;
342: --
343: if (SQL%NOTFOUND) then
344: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE',
346: 'pay_bal_classifications_pkg.update_row');
347: hr_utility.set_message_token('STEP','1');
348: hr_utility.raise_error;
341: WHERE rowid = X_rowid;
342: --
343: if (SQL%NOTFOUND) then
344: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE',
346: 'pay_bal_classifications_pkg.update_row');
347: hr_utility.set_message_token('STEP','1');
348: hr_utility.raise_error;
349: end if;
343: if (SQL%NOTFOUND) then
344: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE',
346: 'pay_bal_classifications_pkg.update_row');
347: hr_utility.set_message_token('STEP','1');
348: hr_utility.raise_error;
349: end if;
350: --
351: -- Update all balance feeds that are linked to the balance classification
344: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE',
346: 'pay_bal_classifications_pkg.update_row');
347: hr_utility.set_message_token('STEP','1');
348: hr_utility.raise_error;
349: end if;
350: --
351: -- Update all balance feeds that are linked to the balance classification
352: -- NB. the only attribute that can be updated is Add or Subtract.
384: DELETE FROM pay_balance_classifications
385: WHERE rowid = X_Rowid;
386: --
387: if (SQL%NOTFOUND) then
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'pay_bal_classifications_pkg.delete_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;
385: WHERE rowid = X_Rowid;
386: --
387: if (SQL%NOTFOUND) then
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'pay_bal_classifications_pkg.delete_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;
393: end if;
387: if (SQL%NOTFOUND) then
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'pay_bal_classifications_pkg.delete_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;
393: end if;
394: --
395: END Delete_Row;
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'pay_bal_classifications_pkg.delete_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;
393: end if;
394: --
395: END Delete_Row;
396: --