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_ORG_PAY_METH_USAGES_F_PKG dependencies on HR_UTILITY

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

55: from pay_all_payrolls_f prl
56: where prl.payroll_id = p_payroll_id;
57: exception
58: when no_data_found then
59: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE',
61: 'pay_payrolls_f_pkg.opmu_end_date');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;

Line 60: hr_utility.set_message_token('PROCEDURE',

56: where prl.payroll_id = p_payroll_id;
57: exception
58: when no_data_found then
59: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE',
61: 'pay_payrolls_f_pkg.opmu_end_date');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;
64: end;

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

58: when no_data_found then
59: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE',
61: 'pay_payrolls_f_pkg.opmu_end_date');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;
64: end;
65: --
66: -- Get opm end date

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_payrolls_f_pkg.opmu_end_date');
62: hr_utility.set_message_token('STEP','1');
63: hr_utility.raise_error;
64: end;
65: --
66: -- Get opm end date
67: begin

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

70: from pay_org_payment_methods_f opm
71: where opm.org_payment_method_id = p_org_payment_method_id;
72: exception
73: when no_data_found then
74: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE',
76: 'pay_payrolls_f_pkg.opmu_end_date');
77: hr_utility.set_message_token('STEP','2');
78: hr_utility.raise_error;

Line 75: hr_utility.set_message_token('PROCEDURE',

71: where opm.org_payment_method_id = p_org_payment_method_id;
72: exception
73: when no_data_found then
74: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE',
76: 'pay_payrolls_f_pkg.opmu_end_date');
77: hr_utility.set_message_token('STEP','2');
78: hr_utility.raise_error;
79: end;

Line 77: hr_utility.set_message_token('STEP','2');

73: when no_data_found then
74: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE',
76: 'pay_payrolls_f_pkg.opmu_end_date');
77: hr_utility.set_message_token('STEP','2');
78: hr_utility.raise_error;
79: end;
80: --
81: -- Use the most restrictive date.

Line 78: hr_utility.raise_error;

74: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE',
76: 'pay_payrolls_f_pkg.opmu_end_date');
77: hr_utility.set_message_token('STEP','2');
78: hr_utility.raise_error;
79: end;
80: --
81: -- Use the most restrictive date.
82: v_opmu_end_date := least(v_max_payroll_end_date,v_max_opm_end_date);

Line 103: hr_utility.set_message(801, 'HR_6868_PAY_NO_DNC_PAY');

99: -- Trying to extend the end date of the opmu past the end date
100: -- of the payroll.
101: if v_opmu_end_date = v_max_payroll_end_date then
102: --
103: hr_utility.set_message(801, 'HR_6868_PAY_NO_DNC_PAY');
104: --
105: -- Trying to extend the end date of the opmu past the end date
106: -- of the opm.
107: else

Line 109: hr_utility.set_message(801, 'HR_6870_PAY_NO_DNC_PAYM');

105: -- Trying to extend the end date of the opmu past the end date
106: -- of the opm.
107: else
108: --
109: hr_utility.set_message(801, 'HR_6870_PAY_NO_DNC_PAYM');
110: --
111: end if;
112: --
113: -- Trying to extend the end date of the opmu such that it will

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

113: -- Trying to extend the end date of the opmu such that it will
114: -- overlap with an existing opmu.
115: else
116: --
117: hr_utility.set_message(801, 'HR_6869_PAY_NO_DNC_OPMU');
118: --
119: end if;
120: --
121: hr_utility.raise_error;

Line 121: hr_utility.raise_error;

117: hr_utility.set_message(801, 'HR_6869_PAY_NO_DNC_OPMU');
118: --
119: end if;
120: --
121: hr_utility.raise_error;
122: --
123: end if;
124: --
125: return v_opmu_end_date;

Line 236: hr_utility.set_message(801, 'HR_6932_PAY_PAST_DPM');

232: v_validation_end_date);
233: fetch csr_dflt_pay_meth into v_dummy_id;
234: if csr_dflt_pay_meth%found then
235: close csr_dflt_pay_meth;
236: hr_utility.set_message(801, 'HR_6932_PAY_PAST_DPM');
237: hr_utility.raise_error;
238: else
239: close csr_dflt_pay_meth;
240: end if;

Line 237: hr_utility.raise_error;

233: fetch csr_dflt_pay_meth into v_dummy_id;
234: if csr_dflt_pay_meth%found then
235: close csr_dflt_pay_meth;
236: hr_utility.set_message(801, 'HR_6932_PAY_PAST_DPM');
237: hr_utility.raise_error;
238: else
239: close csr_dflt_pay_meth;
240: end if;
241: --

Line 251: hr_utility.set_message(801, 'HR_6497_PAY_DEL_PPM');

247: v_validation_end_date);
248: fetch csr_ppm into v_dummy_id;
249: if csr_ppm%found then
250: close csr_ppm;
251: hr_utility.set_message(801, 'HR_6497_PAY_DEL_PPM');
252: hr_utility.raise_error;
253: else
254: close csr_ppm;
255: end if;

Line 252: hr_utility.raise_error;

248: fetch csr_ppm into v_dummy_id;
249: if csr_ppm%found then
250: close csr_ppm;
251: hr_utility.set_message(801, 'HR_6497_PAY_DEL_PPM');
252: hr_utility.raise_error;
253: else
254: close csr_ppm;
255: end if;
256: --

Line 266: hr_utility.set_message(801, 'HR_6498_PAY_DEL_PREPAY');

262: v_validation_end_date);
263: fetch csr_pre_pay into v_dummy_id;
264: if csr_pre_pay%found then
265: close csr_pre_pay;
266: hr_utility.set_message(801, 'HR_6498_PAY_DEL_PREPAY');
267: hr_utility.raise_error;
268: else
269: close csr_pre_pay;
270: end if;

Line 267: hr_utility.raise_error;

263: fetch csr_pre_pay into v_dummy_id;
264: if csr_pre_pay%found then
265: close csr_pre_pay;
266: hr_utility.set_message(801, 'HR_6498_PAY_DEL_PREPAY');
267: hr_utility.raise_error;
268: else
269: close csr_pre_pay;
270: end if;
271: --

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

331: OPEN C;
332: FETCH C INTO X_Rowid;
333: if (C%NOTFOUND) then
334: CLOSE C;
335: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE',
337: 'pay_org_pay_meth_usages_f_pkg.insert_row');
338: hr_utility.set_message_token('STEP','1');
339: hr_utility.raise_error;

Line 336: hr_utility.set_message_token('PROCEDURE',

332: FETCH C INTO X_Rowid;
333: if (C%NOTFOUND) then
334: CLOSE C;
335: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE',
337: 'pay_org_pay_meth_usages_f_pkg.insert_row');
338: hr_utility.set_message_token('STEP','1');
339: hr_utility.raise_error;
340: end if;

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

334: CLOSE C;
335: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE',
337: 'pay_org_pay_meth_usages_f_pkg.insert_row');
338: hr_utility.set_message_token('STEP','1');
339: hr_utility.raise_error;
340: end if;
341: CLOSE C;
342: --

Line 339: hr_utility.raise_error;

335: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
336: hr_utility.set_message_token('PROCEDURE',
337: 'pay_org_pay_meth_usages_f_pkg.insert_row');
338: hr_utility.set_message_token('STEP','1');
339: hr_utility.raise_error;
340: end if;
341: CLOSE C;
342: --
343: END Insert_Row;

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

373: OPEN C;
374: FETCH C INTO Recinfo;
375: if (C%NOTFOUND) then
376: CLOSE C;
377: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
378: hr_utility.set_message_token('PROCEDURE',
379: 'pay_org_pay_meth_usages_f_pkg.lock_row');
380: hr_utility.set_message_token('STEP','1');
381: hr_utility.raise_error;

Line 378: hr_utility.set_message_token('PROCEDURE',

374: FETCH C INTO Recinfo;
375: if (C%NOTFOUND) then
376: CLOSE C;
377: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
378: hr_utility.set_message_token('PROCEDURE',
379: 'pay_org_pay_meth_usages_f_pkg.lock_row');
380: hr_utility.set_message_token('STEP','1');
381: hr_utility.raise_error;
382: end if;

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

376: CLOSE C;
377: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
378: hr_utility.set_message_token('PROCEDURE',
379: 'pay_org_pay_meth_usages_f_pkg.lock_row');
380: hr_utility.set_message_token('STEP','1');
381: hr_utility.raise_error;
382: end if;
383: CLOSE C;
384: --

Line 381: hr_utility.raise_error;

377: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
378: hr_utility.set_message_token('PROCEDURE',
379: 'pay_org_pay_meth_usages_f_pkg.lock_row');
380: hr_utility.set_message_token('STEP','1');
381: hr_utility.raise_error;
382: end if;
383: CLOSE C;
384: --
385: if ( ( (Recinfo.org_pay_method_usage_id = X_Org_Pay_Method_Usage_Id)

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

435: org_payment_method_id = X_Org_Payment_Method_Id
436: WHERE rowid = X_rowid;
437: --
438: if (SQL%NOTFOUND) then
439: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
440: hr_utility.set_message_token('PROCEDURE',
441: 'pay_org_pay_meth_usages_f_pkg.update_row');
442: hr_utility.set_message_token('STEP','1');
443: hr_utility.raise_error;

Line 440: hr_utility.set_message_token('PROCEDURE',

436: WHERE rowid = X_rowid;
437: --
438: if (SQL%NOTFOUND) then
439: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
440: hr_utility.set_message_token('PROCEDURE',
441: 'pay_org_pay_meth_usages_f_pkg.update_row');
442: hr_utility.set_message_token('STEP','1');
443: hr_utility.raise_error;
444: end if;

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

438: if (SQL%NOTFOUND) then
439: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
440: hr_utility.set_message_token('PROCEDURE',
441: 'pay_org_pay_meth_usages_f_pkg.update_row');
442: hr_utility.set_message_token('STEP','1');
443: hr_utility.raise_error;
444: end if;
445: --
446: END Update_Row;

Line 443: hr_utility.raise_error;

439: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
440: hr_utility.set_message_token('PROCEDURE',
441: 'pay_org_pay_meth_usages_f_pkg.update_row');
442: hr_utility.set_message_token('STEP','1');
443: hr_utility.raise_error;
444: end if;
445: --
446: END Update_Row;
447: --

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

464: DELETE FROM pay_org_pay_method_usages_f
465: WHERE rowid = X_Rowid;
466: --
467: if (SQL%NOTFOUND) then
468: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
469: hr_utility.set_message_token('PROCEDURE',
470: 'pay_org_pay_meth_usages_f_pkg.delete_row');
471: hr_utility.set_message_token('STEP','1');
472: hr_utility.raise_error;

Line 469: hr_utility.set_message_token('PROCEDURE',

465: WHERE rowid = X_Rowid;
466: --
467: if (SQL%NOTFOUND) then
468: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
469: hr_utility.set_message_token('PROCEDURE',
470: 'pay_org_pay_meth_usages_f_pkg.delete_row');
471: hr_utility.set_message_token('STEP','1');
472: hr_utility.raise_error;
473: end if;

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

467: if (SQL%NOTFOUND) then
468: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
469: hr_utility.set_message_token('PROCEDURE',
470: 'pay_org_pay_meth_usages_f_pkg.delete_row');
471: hr_utility.set_message_token('STEP','1');
472: hr_utility.raise_error;
473: end if;
474: --
475: END Delete_Row;

Line 472: hr_utility.raise_error;

468: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
469: hr_utility.set_message_token('PROCEDURE',
470: 'pay_org_pay_meth_usages_f_pkg.delete_row');
471: hr_utility.set_message_token('STEP','1');
472: hr_utility.raise_error;
473: end if;
474: --
475: END Delete_Row;
476: --