DBA Data[Home] [Help]

APPS.PAY_BAL_CLASSIFICATIONS_PKG dependencies on HR_UTILITY

Line 127: hr_utility.set_message(801, 'HR_6116_BAL_UNI_CLAS');

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;

Line 128: hr_utility.raise_error;

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: --

Line 176: hr_utility.set_message(801, 'HR_7445_BAL_CLASS_NO_CREATE');

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

Line 177: hr_utility.raise_error;

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

Line 217: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 218: hr_utility.set_message_token('PROCEDURE',

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;

Line 220: hr_utility.set_message_token('STEP','1');

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: --

Line 221: hr_utility.raise_error;

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 /

Line 269: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 270: hr_utility.set_message_token('PROCEDURE',

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;

Line 272: hr_utility.set_message_token('STEP','1');

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: --

Line 273: hr_utility.raise_error;

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.

Line 344: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 345: hr_utility.set_message_token('PROCEDURE',

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;

Line 347: hr_utility.set_message_token('STEP','1');

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

Line 348: hr_utility.raise_error;

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.

Line 388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 389: hr_utility.set_message_token('PROCEDURE',

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;

Line 391: hr_utility.set_message_token('STEP','1');

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;

Line 392: hr_utility.raise_error;

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: --