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;
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: --
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;
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;
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: --
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;
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;
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;
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: --
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.
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;
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;
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;
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: --
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;
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;
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: --
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: --