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.

APPS.PAY_ELEMENT_SETS_PKG dependencies on HR_UTILITY

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

62: open csr_element_set;
63: fetch csr_element_set into v_dummy;
64: if csr_element_set%notfound then
65: close csr_element_set;
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE',
68: 'pay_element_sets_pkg.lock_element_set');
69: hr_utility.set_message_token('STEP','1');
70: hr_utility.raise_error;

Line 67: hr_utility.set_message_token('PROCEDURE',

63: fetch csr_element_set into v_dummy;
64: if csr_element_set%notfound then
65: close csr_element_set;
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE',
68: 'pay_element_sets_pkg.lock_element_set');
69: hr_utility.set_message_token('STEP','1');
70: hr_utility.raise_error;
71: else

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

65: close csr_element_set;
66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE',
68: 'pay_element_sets_pkg.lock_element_set');
69: hr_utility.set_message_token('STEP','1');
70: hr_utility.raise_error;
71: else
72: close csr_element_set;
73: end if;

Line 70: hr_utility.raise_error;

66: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
67: hr_utility.set_message_token('PROCEDURE',
68: 'pay_element_sets_pkg.lock_element_set');
69: hr_utility.set_message_token('STEP','1');
70: hr_utility.raise_error;
71: else
72: close csr_element_set;
73: end if;
74: --

Line 140: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');

136: open csr_debit_or_credit_ele_rule;
137: fetch csr_debit_or_credit_ele_rule into v_debit_or_credit_code;
138: if csr_debit_or_credit_ele_rule%found then
139: close csr_debit_or_credit_ele_rule;
140: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');
141: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');
142: hr_utility.raise_error;
143: else
144: close csr_debit_or_credit_ele_rule;

Line 141: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');

137: fetch csr_debit_or_credit_ele_rule into v_debit_or_credit_code;
138: if csr_debit_or_credit_ele_rule%found then
139: close csr_debit_or_credit_ele_rule;
140: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');
141: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');
142: hr_utility.raise_error;
143: else
144: close csr_debit_or_credit_ele_rule;
145: end if;

Line 142: hr_utility.raise_error;

138: if csr_debit_or_credit_ele_rule%found then
139: close csr_debit_or_credit_ele_rule;
140: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');
141: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');
142: hr_utility.raise_error;
143: else
144: close csr_debit_or_credit_ele_rule;
145: end if;
146: --

Line 154: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');

150: open csr_debit_or_credit_class_rule;
151: fetch csr_debit_or_credit_class_rule into v_debit_or_credit_code;
152: if csr_debit_or_credit_class_rule%found then
153: close csr_debit_or_credit_class_rule;
154: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');
155: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');
156: hr_utility.raise_error;
157: else
158: close csr_debit_or_credit_class_rule;

Line 155: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');

151: fetch csr_debit_or_credit_class_rule into v_debit_or_credit_code;
152: if csr_debit_or_credit_class_rule%found then
153: close csr_debit_or_credit_class_rule;
154: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');
155: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');
156: hr_utility.raise_error;
157: else
158: close csr_debit_or_credit_class_rule;
159: end if;

Line 156: hr_utility.raise_error;

152: if csr_debit_or_credit_class_rule%found then
153: close csr_debit_or_credit_class_rule;
154: hr_utility.set_message(801, 'HR_6547_ELE_SET_CR_OR_DB');
155: hr_utility.set_message_token('CREDIT_OR_DEBIT', '???');
156: hr_utility.raise_error;
157: else
158: close csr_debit_or_credit_class_rule;
159: end if;
160: --

Line 202: hr_utility.set_message(801, 'HR_6055_ELE_SET_UNIQUE_NAME');

198: open csr_unique_set;
199: fetch csr_unique_set into v_dummy;
200: if csr_unique_set%found then
201: close csr_unique_set;
202: hr_utility.set_message(801, 'HR_6055_ELE_SET_UNIQUE_NAME');
203: hr_utility.raise_error;
204: else
205: close csr_unique_set;
206: end if;

Line 203: hr_utility.raise_error;

199: fetch csr_unique_set into v_dummy;
200: if csr_unique_set%found then
201: close csr_unique_set;
202: hr_utility.set_message(801, 'HR_6055_ELE_SET_UNIQUE_NAME');
203: hr_utility.raise_error;
204: else
205: close csr_unique_set;
206: end if;
207: --

Line 260: hr_utility.set_message(801, 'HR_6051_ELE_SET_SET_DELETES');

256: open csr_element_links;
257: fetch csr_element_links into v_dummy;
258: if csr_element_links%found then
259: close csr_element_links;
260: hr_utility.set_message(801, 'HR_6051_ELE_SET_SET_DELETES');
261: hr_utility.raise_error;
262: else
263: close csr_element_links;
264: end if;

Line 261: hr_utility.raise_error;

257: fetch csr_element_links into v_dummy;
258: if csr_element_links%found then
259: close csr_element_links;
260: hr_utility.set_message(801, 'HR_6051_ELE_SET_SET_DELETES');
261: hr_utility.raise_error;
262: else
263: close csr_element_links;
264: end if;
265: --

Line 273: hr_utility.set_message(801, 'HR_6054_ELE_SET_SET_DELETES');

269: open csr_payroll_actions;
270: fetch csr_payroll_actions into v_dummy;
271: if csr_payroll_actions%found then
272: close csr_payroll_actions;
273: hr_utility.set_message(801, 'HR_6054_ELE_SET_SET_DELETES');
274: hr_utility.raise_error;
275: else
276: close csr_payroll_actions;
277: end if;

Line 274: hr_utility.raise_error;

270: fetch csr_payroll_actions into v_dummy;
271: if csr_payroll_actions%found then
272: close csr_payroll_actions;
273: hr_utility.set_message(801, 'HR_6054_ELE_SET_SET_DELETES');
274: hr_utility.raise_error;
275: else
276: close csr_payroll_actions;
277: end if;
278: --

Line 286: hr_utility.set_message(801, 'HR_6050_ELE_SET_SET_DELETES');

282: open csr_restriction_values;
283: fetch csr_restriction_values into v_dummy;
284: if csr_restriction_values%found then
285: close csr_restriction_values;
286: hr_utility.set_message(801, 'HR_6050_ELE_SET_SET_DELETES');
287: hr_utility.raise_error;
288: else
289: close csr_restriction_values;
290: end if;

Line 287: hr_utility.raise_error;

283: fetch csr_restriction_values into v_dummy;
284: if csr_restriction_values%found then
285: close csr_restriction_values;
286: hr_utility.set_message(801, 'HR_6050_ELE_SET_SET_DELETES');
287: hr_utility.raise_error;
288: else
289: close csr_restriction_values;
290: end if;
291: elsif p_element_set_type = 'E' then

Line 297: hr_utility.set_message(801, 'PAY_294526_ECU_CHILD_EXISTS');

293: open csr_element_set_usages;
294: fetch csr_element_set_usages into v_dummy;
295: if csr_element_set_usages%found then
296: close csr_element_set_usages;
297: hr_utility.set_message(801, 'PAY_294526_ECU_CHILD_EXISTS');
298: hr_utility.raise_error;
299: else
300: close csr_element_set_usages;
301: end if;

Line 298: hr_utility.raise_error;

294: fetch csr_element_set_usages into v_dummy;
295: if csr_element_set_usages%found then
296: close csr_element_set_usages;
297: hr_utility.set_message(801, 'PAY_294526_ECU_CHILD_EXISTS');
298: hr_utility.raise_error;
299: else
300: close csr_element_set_usages;
301: end if;
302: --

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

405: OPEN C;
406: FETCH C INTO X_Rowid;
407: if (C%NOTFOUND) then
408: CLOSE C;
409: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
410: hr_utility.set_message_token('PROCEDURE',
411: 'pay_element_sets_pkg.insert_row');
412: hr_utility.set_message_token('STEP','1');
413: hr_utility.raise_error;

Line 410: hr_utility.set_message_token('PROCEDURE',

406: FETCH C INTO X_Rowid;
407: if (C%NOTFOUND) then
408: CLOSE C;
409: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
410: hr_utility.set_message_token('PROCEDURE',
411: 'pay_element_sets_pkg.insert_row');
412: hr_utility.set_message_token('STEP','1');
413: hr_utility.raise_error;
414: end if;

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

408: CLOSE C;
409: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
410: hr_utility.set_message_token('PROCEDURE',
411: 'pay_element_sets_pkg.insert_row');
412: hr_utility.set_message_token('STEP','1');
413: hr_utility.raise_error;
414: end if;
415: CLOSE C;
416: --

Line 413: hr_utility.raise_error;

409: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
410: hr_utility.set_message_token('PROCEDURE',
411: 'pay_element_sets_pkg.insert_row');
412: hr_utility.set_message_token('STEP','1');
413: hr_utility.raise_error;
414: end if;
415: CLOSE C;
416: --
417: END Insert_Row;

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

446: OPEN C;
447: FETCH C INTO Recinfo;
448: if (C%NOTFOUND) then
449: CLOSE C;
450: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
451: hr_utility.set_message_token('PROCEDURE',
452: 'pay_element_sets_pkg.lock_row');
453: hr_utility.set_message_token('STEP','1');
454: hr_utility.raise_error;

Line 451: hr_utility.set_message_token('PROCEDURE',

447: FETCH C INTO Recinfo;
448: if (C%NOTFOUND) then
449: CLOSE C;
450: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
451: hr_utility.set_message_token('PROCEDURE',
452: 'pay_element_sets_pkg.lock_row');
453: hr_utility.set_message_token('STEP','1');
454: hr_utility.raise_error;
455: end if;

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

449: CLOSE C;
450: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
451: hr_utility.set_message_token('PROCEDURE',
452: 'pay_element_sets_pkg.lock_row');
453: hr_utility.set_message_token('STEP','1');
454: hr_utility.raise_error;
455: end if;
456: CLOSE C;
457: --

Line 454: hr_utility.raise_error;

450: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
451: hr_utility.set_message_token('PROCEDURE',
452: 'pay_element_sets_pkg.lock_row');
453: hr_utility.set_message_token('STEP','1');
454: hr_utility.raise_error;
455: end if;
456: CLOSE C;
457: --
458: -- Remove trailing spaces.

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

552: end if;
553: --------------------------------------------------------------------------------
554: --
555: if (SQL%NOTFOUND) then
556: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
557: hr_utility.set_message_token('PROCEDURE',
558: 'pay_element_sets_pkg.update_row');
559: hr_utility.set_message_token('STEP','1');
560: hr_utility.raise_error;

Line 557: hr_utility.set_message_token('PROCEDURE',

553: --------------------------------------------------------------------------------
554: --
555: if (SQL%NOTFOUND) then
556: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
557: hr_utility.set_message_token('PROCEDURE',
558: 'pay_element_sets_pkg.update_row');
559: hr_utility.set_message_token('STEP','1');
560: hr_utility.raise_error;
561: end if;

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

555: if (SQL%NOTFOUND) then
556: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
557: hr_utility.set_message_token('PROCEDURE',
558: 'pay_element_sets_pkg.update_row');
559: hr_utility.set_message_token('STEP','1');
560: hr_utility.raise_error;
561: end if;
562: --
563: END Update_Row;

Line 560: hr_utility.raise_error;

556: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
557: hr_utility.set_message_token('PROCEDURE',
558: 'pay_element_sets_pkg.update_row');
559: hr_utility.set_message_token('STEP','1');
560: hr_utility.raise_error;
561: end if;
562: --
563: END Update_Row;
564: --

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

596: DELETE FROM pay_element_sets
597: WHERE rowid = X_Rowid;
598: --
599: if (SQL%NOTFOUND) then
600: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PROCEDURE',
602: 'pay_element_sets_pkg.delete_row');
603: hr_utility.set_message_token('STEP','1');
604: hr_utility.raise_error;

Line 601: hr_utility.set_message_token('PROCEDURE',

597: WHERE rowid = X_Rowid;
598: --
599: if (SQL%NOTFOUND) then
600: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PROCEDURE',
602: 'pay_element_sets_pkg.delete_row');
603: hr_utility.set_message_token('STEP','1');
604: hr_utility.raise_error;
605: end if;

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

599: if (SQL%NOTFOUND) then
600: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PROCEDURE',
602: 'pay_element_sets_pkg.delete_row');
603: hr_utility.set_message_token('STEP','1');
604: hr_utility.raise_error;
605: end if;
606: --
607: END Delete_Row;

Line 604: hr_utility.raise_error;

600: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
601: hr_utility.set_message_token('PROCEDURE',
602: 'pay_element_sets_pkg.delete_row');
603: hr_utility.set_message_token('STEP','1');
604: hr_utility.raise_error;
605: end if;
606: --
607: END Delete_Row;
608: --

Line 738: hr_utility.set_location (l_package_name,10);

734: BEGIN
735: l_package_name := 'PAY_ELEMENT_SETS_PKG.VALIDATE_TRANSLATION';
736: l_business_group_id := p_business_group_id;
737: l_legislation_code := p_legislation_code;
738: hr_utility.set_location (l_package_name,10);
739: OPEN c_translation(language, element_set_name,element_set_id,
740: l_business_group_id,l_legislation_code);
741: hr_utility.set_location (l_package_name,50);
742: FETCH c_translation INTO g_dummy;

Line 741: hr_utility.set_location (l_package_name,50);

737: l_legislation_code := p_legislation_code;
738: hr_utility.set_location (l_package_name,10);
739: OPEN c_translation(language, element_set_name,element_set_id,
740: l_business_group_id,l_legislation_code);
741: hr_utility.set_location (l_package_name,50);
742: FETCH c_translation INTO g_dummy;
743:
744: IF c_translation%NOTFOUND THEN
745: hr_utility.set_location (l_package_name,60);

Line 745: hr_utility.set_location (l_package_name,60);

741: hr_utility.set_location (l_package_name,50);
742: FETCH c_translation INTO g_dummy;
743:
744: IF c_translation%NOTFOUND THEN
745: hr_utility.set_location (l_package_name,60);
746: CLOSE c_translation;
747: ELSE
748: hr_utility.set_location (l_package_name,70);
749: CLOSE c_translation;

Line 748: hr_utility.set_location (l_package_name,70);

744: IF c_translation%NOTFOUND THEN
745: hr_utility.set_location (l_package_name,60);
746: CLOSE c_translation;
747: ELSE
748: hr_utility.set_location (l_package_name,70);
749: CLOSE c_translation;
750: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
751: fnd_message.raise_error;
752: END IF;

Line 753: hr_utility.set_location ('Leaving:'||l_package_name,80);

749: CLOSE c_translation;
750: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
751: fnd_message.raise_error;
752: END IF;
753: hr_utility.set_location ('Leaving:'||l_package_name,80);
754: END validate_translation;
755:
756: --
757: function return_dml_status