DBA Data[Home] [Help]

APPS.PER_TIME_PERIODS_PKG dependencies on HR_UTILITY

Line 61: hr_utility.set_message(801, 'PAY_6802_CALEND_PERIOD_EXISTS');

57: open csr_unique_time_period;
58: fetch csr_unique_time_period into v_dummy;
59: if csr_unique_time_period%found then
60: close csr_unique_time_period;
61: hr_utility.set_message(801, 'PAY_6802_CALEND_PERIOD_EXISTS');
62: hr_utility.raise_error;
63: else
64: close csr_unique_time_period;
65: end if;

Line 62: hr_utility.raise_error;

58: fetch csr_unique_time_period into v_dummy;
59: if csr_unique_time_period%found then
60: close csr_unique_time_period;
61: hr_utility.set_message(801, 'PAY_6802_CALEND_PERIOD_EXISTS');
62: hr_utility.raise_error;
63: else
64: close csr_unique_time_period;
65: end if;
66: --

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

322: OPEN C;
323: FETCH C INTO X_Rowid;
324: if (C%NOTFOUND) then
325: CLOSE C;
326: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE',
328: 'per_time_periods_pkg.insert_row');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;

Line 327: hr_utility.set_message_token('PROCEDURE',

323: FETCH C INTO X_Rowid;
324: if (C%NOTFOUND) then
325: CLOSE C;
326: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE',
328: 'per_time_periods_pkg.insert_row');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;

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

325: CLOSE C;
326: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE',
328: 'per_time_periods_pkg.insert_row');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332: CLOSE C;
333: --

Line 330: hr_utility.raise_error;

326: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
327: hr_utility.set_message_token('PROCEDURE',
328: 'per_time_periods_pkg.insert_row');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332: CLOSE C;
333: --
334: END Insert_Row;

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

434: OPEN C;
435: FETCH C INTO Recinfo;
436: if (C%NOTFOUND) then
437: CLOSE C;
438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE',
440: 'per_time_periods_pkg.lock_row');
441: hr_utility.set_message_token('STEP','1');
442: hr_utility.raise_error;

Line 439: hr_utility.set_message_token('PROCEDURE',

435: FETCH C INTO Recinfo;
436: if (C%NOTFOUND) then
437: CLOSE C;
438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE',
440: 'per_time_periods_pkg.lock_row');
441: hr_utility.set_message_token('STEP','1');
442: hr_utility.raise_error;
443: end if;

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

437: CLOSE C;
438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE',
440: 'per_time_periods_pkg.lock_row');
441: hr_utility.set_message_token('STEP','1');
442: hr_utility.raise_error;
443: end if;
444: CLOSE C;
445: --

Line 442: hr_utility.raise_error;

438: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
439: hr_utility.set_message_token('PROCEDURE',
440: 'per_time_periods_pkg.lock_row');
441: hr_utility.set_message_token('STEP','1');
442: hr_utility.raise_error;
443: end if;
444: CLOSE C;
445: --
446: -- Remove trailing spaces.

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

903: payslip_view_date = X_Payslip_view_date
904: WHERE rowid = X_rowid;
905: --
906: if (SQL%NOTFOUND) then
907: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
908: hr_utility.set_message_token('PROCEDURE',
909: 'per_time_periods_pkg.update_row');
910: hr_utility.set_message_token('STEP','1');
911: hr_utility.raise_error;

Line 908: hr_utility.set_message_token('PROCEDURE',

904: WHERE rowid = X_rowid;
905: --
906: if (SQL%NOTFOUND) then
907: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
908: hr_utility.set_message_token('PROCEDURE',
909: 'per_time_periods_pkg.update_row');
910: hr_utility.set_message_token('STEP','1');
911: hr_utility.raise_error;
912: end if;

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

906: if (SQL%NOTFOUND) then
907: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
908: hr_utility.set_message_token('PROCEDURE',
909: 'per_time_periods_pkg.update_row');
910: hr_utility.set_message_token('STEP','1');
911: hr_utility.raise_error;
912: end if;
913: --
914: END Update_Row;

Line 911: hr_utility.raise_error;

907: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
908: hr_utility.set_message_token('PROCEDURE',
909: 'per_time_periods_pkg.update_row');
910: hr_utility.set_message_token('STEP','1');
911: hr_utility.raise_error;
912: end if;
913: --
914: END Update_Row;
915: --

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

932: DELETE FROM per_time_periods
933: WHERE rowid = X_Rowid;
934: --
935: if (SQL%NOTFOUND) then
936: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
937: hr_utility.set_message_token('PROCEDURE',
938: 'per_time_periods_pkg.delete_row');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;

Line 937: hr_utility.set_message_token('PROCEDURE',

933: WHERE rowid = X_Rowid;
934: --
935: if (SQL%NOTFOUND) then
936: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
937: hr_utility.set_message_token('PROCEDURE',
938: 'per_time_periods_pkg.delete_row');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;
941: end if;

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

935: if (SQL%NOTFOUND) then
936: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
937: hr_utility.set_message_token('PROCEDURE',
938: 'per_time_periods_pkg.delete_row');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;
941: end if;
942: END Delete_Row;
943: --

Line 940: hr_utility.raise_error;

936: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
937: hr_utility.set_message_token('PROCEDURE',
938: 'per_time_periods_pkg.delete_row');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;
941: end if;
942: END Delete_Row;
943: --
944: --