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_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 233: hr_utility.set_message(801, 'HR_6932_PAY_PAST_DPM');

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

Line 234: hr_utility.raise_error;

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

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

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

Line 249: hr_utility.raise_error;

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

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

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

Line 264: hr_utility.raise_error;

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

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

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

Line 333: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 336: hr_utility.raise_error;

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

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

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

Line 375: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 378: hr_utility.raise_error;

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

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

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

Line 437: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 440: hr_utility.raise_error;

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

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

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

Line 466: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 469: hr_utility.raise_error;

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