61: FETCH C INTO P_Rowid;
62: --
63: if (C%NOTFOUND) then
64: CLOSE C;
65: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
66: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
69: end if;
62: --
63: if (C%NOTFOUND) then
64: CLOSE C;
65: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
66: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
69: end if;
70: --
63: if (C%NOTFOUND) then
64: CLOSE C;
65: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
66: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
69: end if;
70: --
71: CLOSE C;
64: CLOSE C;
65: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
66: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
67: hr_utility.set_message_token('STEP','1');
68: hr_utility.raise_error;
69: end if;
70: --
71: CLOSE C;
72: --
100: FETCH C INTO Recinfo;
101: --
102: if (C%NOTFOUND) then
103: CLOSE C;
104: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
105: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
106: hr_utility.set_message_token('STEP','1');
107: hr_utility.raise_error;
108: end if;
101: --
102: if (C%NOTFOUND) then
103: CLOSE C;
104: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
105: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
106: hr_utility.set_message_token('STEP','1');
107: hr_utility.raise_error;
108: end if;
109: --
102: if (C%NOTFOUND) then
103: CLOSE C;
104: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
105: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
106: hr_utility.set_message_token('STEP','1');
107: hr_utility.raise_error;
108: end if;
109: --
110: CLOSE C;
103: CLOSE C;
104: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
105: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
106: hr_utility.set_message_token('STEP','1');
107: hr_utility.raise_error;
108: end if;
109: --
110: CLOSE C;
111: --
174: --
175: --
176: if (SQL%NOTFOUND) then
177: --
178: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
179: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
180: hr_utility.set_message_token('STEP','20');
181: hr_utility.raise_error;
182: --
175: --
176: if (SQL%NOTFOUND) then
177: --
178: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
179: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
180: hr_utility.set_message_token('STEP','20');
181: hr_utility.raise_error;
182: --
183: end if;
176: if (SQL%NOTFOUND) then
177: --
178: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
179: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
180: hr_utility.set_message_token('STEP','20');
181: hr_utility.raise_error;
182: --
183: end if;
184: --
177: --
178: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
179: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
180: hr_utility.set_message_token('STEP','20');
181: hr_utility.raise_error;
182: --
183: end if;
184: --
185: END Update_Row;
191: DELETE FROM ben_beneficiaries_f
192: WHERE rowid = P_Rowid;
193:
194: if (SQL%NOTFOUND) then
195: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
196: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
197: hr_utility.set_message_token('STEP','1');
198: hr_utility.raise_error;
199: end if;
192: WHERE rowid = P_Rowid;
193:
194: if (SQL%NOTFOUND) then
195: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
196: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
197: hr_utility.set_message_token('STEP','1');
198: hr_utility.raise_error;
199: end if;
200: END Delete_Row;
193:
194: if (SQL%NOTFOUND) then
195: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
196: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
197: hr_utility.set_message_token('STEP','1');
198: hr_utility.raise_error;
199: end if;
200: END Delete_Row;
201:
194: if (SQL%NOTFOUND) then
195: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
196: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
197: hr_utility.set_message_token('STEP','1');
198: hr_utility.raise_error;
199: end if;
200: END Delete_Row;
201:
202: ----------------------- Test_Path_To_PERBEBEN ------------------
239: fetch c_chk_asg_benefit into l_deps_allowed_for_primary_asg;
240:
241: if c_chk_asg_benefit%notfound then
242: close c_chk_asg_benefit;
243: hr_utility.set_message(801, 'PAY_7981_BEN_FORM_NOT_NAV');
244: hr_utility.raise_error;
245: end if;
246:
247: close c_chk_asg_benefit;
240:
241: if c_chk_asg_benefit%notfound then
242: close c_chk_asg_benefit;
243: hr_utility.set_message(801, 'PAY_7981_BEN_FORM_NOT_NAV');
244: hr_utility.raise_error;
245: end if;
246:
247: close c_chk_asg_benefit;
248: