eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_ELE_CLASS_RULES_PKG dependencies on HR_UTILITY

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

55: open csr_classification_name;
56: fetch csr_classification_name into v_classification_name;
57: if csr_classification_name%notfound then
58: close csr_classification_name;
59: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE',
61: 'pay_ele_class_rules_pkg.get_classification_name');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;

Line 60: hr_utility.set_message_token('PROCEDURE',

56: fetch csr_classification_name into v_classification_name;
57: if csr_classification_name%notfound then
58: close csr_classification_name;
59: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE',
61: 'pay_ele_class_rules_pkg.get_classification_name');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;
64: else

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

58: close csr_classification_name;
59: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE',
61: 'pay_ele_class_rules_pkg.get_classification_name');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;
64: else
65: close csr_classification_name;
66: end if;

Line 63: hr_utility.raise_error;

59: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE',
61: 'pay_ele_class_rules_pkg.get_classification_name');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;
64: else
65: close csr_classification_name;
66: end if;
67: --

Line 117: hr_utility.set_message(801, 'HR_7879_ELE_SET_UNIQUE_RULES');

113: open csr_ele_class_rule;
114: fetch csr_ele_class_rule into v_dummy;
115: if csr_ele_class_rule%found then
116: close csr_ele_class_rule;
117: hr_utility.set_message(801, 'HR_7879_ELE_SET_UNIQUE_RULES');
118: hr_utility.raise_error;
119: else
120: close csr_ele_class_rule;
121: end if;

Line 118: hr_utility.raise_error;

114: fetch csr_ele_class_rule into v_dummy;
115: if csr_ele_class_rule%found then
116: close csr_ele_class_rule;
117: hr_utility.set_message(801, 'HR_7879_ELE_SET_UNIQUE_RULES');
118: hr_utility.raise_error;
119: else
120: close csr_ele_class_rule;
121: end if;
122: --

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

123: open csr_ele_type_rule;
124: fetch csr_ele_type_rule into v_dummy;
125: if csr_ele_type_rule%found then
126: close csr_ele_type_rule;
127: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
128: hr_utility.set_message_token('INS_OR_DEL', 'insert');
129: hr_utility.set_message_token('CLASSIFICATION_NAME',
130: get_classification_name(p_classification_id));
131: hr_utility.set_message_token('INC_OR_EXC', 'included');

Line 128: hr_utility.set_message_token('INS_OR_DEL', 'insert');

124: fetch csr_ele_type_rule into v_dummy;
125: if csr_ele_type_rule%found then
126: close csr_ele_type_rule;
127: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
128: hr_utility.set_message_token('INS_OR_DEL', 'insert');
129: hr_utility.set_message_token('CLASSIFICATION_NAME',
130: get_classification_name(p_classification_id));
131: hr_utility.set_message_token('INC_OR_EXC', 'included');
132: hr_utility.raise_error;

Line 129: hr_utility.set_message_token('CLASSIFICATION_NAME',

125: if csr_ele_type_rule%found then
126: close csr_ele_type_rule;
127: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
128: hr_utility.set_message_token('INS_OR_DEL', 'insert');
129: hr_utility.set_message_token('CLASSIFICATION_NAME',
130: get_classification_name(p_classification_id));
131: hr_utility.set_message_token('INC_OR_EXC', 'included');
132: hr_utility.raise_error;
133: else

Line 131: hr_utility.set_message_token('INC_OR_EXC', 'included');

127: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
128: hr_utility.set_message_token('INS_OR_DEL', 'insert');
129: hr_utility.set_message_token('CLASSIFICATION_NAME',
130: get_classification_name(p_classification_id));
131: hr_utility.set_message_token('INC_OR_EXC', 'included');
132: hr_utility.raise_error;
133: else
134: close csr_ele_type_rule;
135: end if;

Line 132: hr_utility.raise_error;

128: hr_utility.set_message_token('INS_OR_DEL', 'insert');
129: hr_utility.set_message_token('CLASSIFICATION_NAME',
130: get_classification_name(p_classification_id));
131: hr_utility.set_message_token('INC_OR_EXC', 'included');
132: hr_utility.raise_error;
133: else
134: close csr_ele_type_rule;
135: end if;
136: --

Line 173: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');

169: open csr_ele_type_rule;
170: fetch csr_ele_type_rule into v_dummy;
171: if csr_ele_type_rule%found then
172: close csr_ele_type_rule;
173: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
174: hr_utility.set_message_token('INS_OR_DEL', 'delete');
175: hr_utility.set_message_token('CLASSIFICATION_NAME',
176: get_classification_name(p_classification_id));
177: hr_utility.set_message_token('INC_OR_EXC', 'excluded');

Line 174: hr_utility.set_message_token('INS_OR_DEL', 'delete');

170: fetch csr_ele_type_rule into v_dummy;
171: if csr_ele_type_rule%found then
172: close csr_ele_type_rule;
173: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
174: hr_utility.set_message_token('INS_OR_DEL', 'delete');
175: hr_utility.set_message_token('CLASSIFICATION_NAME',
176: get_classification_name(p_classification_id));
177: hr_utility.set_message_token('INC_OR_EXC', 'excluded');
178: hr_utility.raise_error;

Line 175: hr_utility.set_message_token('CLASSIFICATION_NAME',

171: if csr_ele_type_rule%found then
172: close csr_ele_type_rule;
173: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
174: hr_utility.set_message_token('INS_OR_DEL', 'delete');
175: hr_utility.set_message_token('CLASSIFICATION_NAME',
176: get_classification_name(p_classification_id));
177: hr_utility.set_message_token('INC_OR_EXC', 'excluded');
178: hr_utility.raise_error;
179: else

Line 177: hr_utility.set_message_token('INC_OR_EXC', 'excluded');

173: hr_utility.set_message(801, 'HR_6014_ELE_SET_RULES_EXIST');
174: hr_utility.set_message_token('INS_OR_DEL', 'delete');
175: hr_utility.set_message_token('CLASSIFICATION_NAME',
176: get_classification_name(p_classification_id));
177: hr_utility.set_message_token('INC_OR_EXC', 'excluded');
178: hr_utility.raise_error;
179: else
180: close csr_ele_type_rule;
181: end if;

Line 178: hr_utility.raise_error;

174: hr_utility.set_message_token('INS_OR_DEL', 'delete');
175: hr_utility.set_message_token('CLASSIFICATION_NAME',
176: get_classification_name(p_classification_id));
177: hr_utility.set_message_token('INC_OR_EXC', 'excluded');
178: hr_utility.raise_error;
179: else
180: close csr_ele_type_rule;
181: end if;
182: --

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

234: OPEN C;
235: FETCH C INTO X_Rowid;
236: if (C%NOTFOUND) then
237: CLOSE C;
238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_ele_class_rules_pkg.insert_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;

Line 239: hr_utility.set_message_token('PROCEDURE',

235: FETCH C INTO X_Rowid;
236: if (C%NOTFOUND) then
237: CLOSE C;
238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_ele_class_rules_pkg.insert_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;

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

237: CLOSE C;
238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_ele_class_rules_pkg.insert_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: CLOSE C;
245: --

Line 242: hr_utility.raise_error;

238: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
239: hr_utility.set_message_token('PROCEDURE',
240: 'pay_ele_class_rules_pkg.insert_row');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: CLOSE C;
245: --
246: END Insert_Row;

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

272: OPEN C;
273: FETCH C INTO Recinfo;
274: if (C%NOTFOUND) then
275: CLOSE C;
276: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
277: hr_utility.set_message_token('PROCEDURE',
278: 'pay_ele_class_rules_pkg.lock_row');
279: hr_utility.set_message_token('STEP','1');
280: hr_utility.raise_error;

Line 277: hr_utility.set_message_token('PROCEDURE',

273: FETCH C INTO Recinfo;
274: if (C%NOTFOUND) then
275: CLOSE C;
276: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
277: hr_utility.set_message_token('PROCEDURE',
278: 'pay_ele_class_rules_pkg.lock_row');
279: hr_utility.set_message_token('STEP','1');
280: hr_utility.raise_error;
281: end if;

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

275: CLOSE C;
276: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
277: hr_utility.set_message_token('PROCEDURE',
278: 'pay_ele_class_rules_pkg.lock_row');
279: hr_utility.set_message_token('STEP','1');
280: hr_utility.raise_error;
281: end if;
282: CLOSE C;
283: --

Line 280: hr_utility.raise_error;

276: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
277: hr_utility.set_message_token('PROCEDURE',
278: 'pay_ele_class_rules_pkg.lock_row');
279: hr_utility.set_message_token('STEP','1');
280: hr_utility.raise_error;
281: end if;
282: CLOSE C;
283: --
284: if ( ( (Recinfo.element_set_id = X_Element_Set_Id)

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

317: classification_id = X_Classification_Id
318: WHERE rowid = X_rowid;
319: --
320: if (SQL%NOTFOUND) then
321: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE',
323: 'pay_ele_class_rules_pkg.update_row');
324: hr_utility.set_message_token('STEP','1');
325: hr_utility.raise_error;

Line 322: hr_utility.set_message_token('PROCEDURE',

318: WHERE rowid = X_rowid;
319: --
320: if (SQL%NOTFOUND) then
321: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE',
323: 'pay_ele_class_rules_pkg.update_row');
324: hr_utility.set_message_token('STEP','1');
325: hr_utility.raise_error;
326: end if;

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

320: if (SQL%NOTFOUND) then
321: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE',
323: 'pay_ele_class_rules_pkg.update_row');
324: hr_utility.set_message_token('STEP','1');
325: hr_utility.raise_error;
326: end if;
327: --
328: END Update_Row;

Line 325: hr_utility.raise_error;

321: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE',
323: 'pay_ele_class_rules_pkg.update_row');
324: hr_utility.set_message_token('STEP','1');
325: hr_utility.raise_error;
326: end if;
327: --
328: END Update_Row;
329: --

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

355: DELETE FROM pay_ele_classification_rules
356: WHERE rowid = X_Rowid;
357: --
358: if (SQL%NOTFOUND) then
359: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
360: hr_utility.set_message_token('PROCEDURE',
361: 'pay_ele_class_rules_pkg.delete_row');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;

Line 360: hr_utility.set_message_token('PROCEDURE',

356: WHERE rowid = X_Rowid;
357: --
358: if (SQL%NOTFOUND) then
359: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
360: hr_utility.set_message_token('PROCEDURE',
361: 'pay_ele_class_rules_pkg.delete_row');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;

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

358: if (SQL%NOTFOUND) then
359: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
360: hr_utility.set_message_token('PROCEDURE',
361: 'pay_ele_class_rules_pkg.delete_row');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: --
366: END Delete_Row;

Line 363: hr_utility.raise_error;

359: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
360: hr_utility.set_message_token('PROCEDURE',
361: 'pay_ele_class_rules_pkg.delete_row');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: --
366: END Delete_Row;
367: --