DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TYPE_RULES_PKG dependencies on HR_UTILITY

Line 74: hr_utility.set_message(801, 'HR_7102_ELE_SET_CLASS_EXISTS');

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;

Line 75: hr_utility.raise_error;

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

Line 130: hr_utility.set_message(801, 'HR_7701_ELE_SET_CLASS_EXIST');

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;

Line 131: hr_utility.raise_error;

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

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

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;

Line 254: hr_utility.set_message_token('PROCEDURE',

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;

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

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

Line 257: hr_utility.raise_error;

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;

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

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;

Line 292: hr_utility.set_message_token('PROCEDURE',

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;

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

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

Line 295: hr_utility.raise_error;

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.

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

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;

Line 352: hr_utility.set_message_token('PROCEDURE',

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;

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

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;

Line 355: hr_utility.raise_error;

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

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

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;

Line 380: hr_utility.set_message_token('PROCEDURE',

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;

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

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;

Line 383: hr_utility.raise_error;

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