45: --
46: --
47: if (C%NOTFOUND) then
48: CLOSE C;
49: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
50: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
51: hr_utility.set_message_token('STEP','1');
52: hr_utility.raise_error;
53: end if;
46: --
47: if (C%NOTFOUND) then
48: CLOSE C;
49: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
50: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
51: hr_utility.set_message_token('STEP','1');
52: hr_utility.raise_error;
53: end if;
54: --
47: if (C%NOTFOUND) then
48: CLOSE C;
49: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
50: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
51: hr_utility.set_message_token('STEP','1');
52: hr_utility.raise_error;
53: end if;
54: --
55: CLOSE C;
48: CLOSE C;
49: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
50: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
51: hr_utility.set_message_token('STEP','1');
52: hr_utility.raise_error;
53: end if;
54: --
55: CLOSE C;
56: --
83: FETCH C INTO Recinfo;
84: --
85: if (C%NOTFOUND) then
86: CLOSE C;
87: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
89: hr_utility.set_message_token('STEP','1');
90: hr_utility.raise_error;
91: end if;
84: --
85: if (C%NOTFOUND) then
86: CLOSE C;
87: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
89: hr_utility.set_message_token('STEP','1');
90: hr_utility.raise_error;
91: end if;
92: --
85: if (C%NOTFOUND) then
86: CLOSE C;
87: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
89: hr_utility.set_message_token('STEP','1');
90: hr_utility.raise_error;
91: end if;
92: --
93: CLOSE C;
86: CLOSE C;
87: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
89: hr_utility.set_message_token('STEP','1');
90: hr_utility.raise_error;
91: end if;
92: --
93: CLOSE C;
94: --
146: rowid = P_Rowid;
147: --
148: if (SQL%NOTFOUND) then
149: --
150: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
151: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
152: hr_utility.set_message_token('STEP','20');
153: hr_utility.raise_error;
154: --
147: --
148: if (SQL%NOTFOUND) then
149: --
150: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
151: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
152: hr_utility.set_message_token('STEP','20');
153: hr_utility.raise_error;
154: --
155: end if;
148: if (SQL%NOTFOUND) then
149: --
150: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
151: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
152: hr_utility.set_message_token('STEP','20');
153: hr_utility.raise_error;
154: --
155: end if;
156: --
149: --
150: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
151: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
152: hr_utility.set_message_token('STEP','20');
153: hr_utility.raise_error;
154: --
155: end if;
156: --
157: END Update_Row;
165: DELETE FROM ben_covered_dependents_f
166: WHERE rowid = P_Rowid;
167: --
168: if (SQL%NOTFOUND) then
169: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
170: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
173: end if;
166: WHERE rowid = P_Rowid;
167: --
168: if (SQL%NOTFOUND) then
169: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
170: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
173: end if;
174: --
167: --
168: if (SQL%NOTFOUND) then
169: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
170: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
173: end if;
174: --
175: END Delete_Row;
168: if (SQL%NOTFOUND) then
169: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
170: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
171: hr_utility.set_message_token('STEP','1');
172: hr_utility.raise_error;
173: end if;
174: --
175: END Delete_Row;
176: --
215: fetch c_chk_asg_benefit into l_deps_allowed_for_primary_asg;
216:
217: if c_chk_asg_benefit%notfound then
218: close c_chk_asg_benefit;
219: hr_utility.set_message(801, 'PAY_7980_COV_DEP_FORM_NOT_NAV');
220: hr_utility.raise_error;
221: end if;
222:
223: close c_chk_asg_benefit;
216:
217: if c_chk_asg_benefit%notfound then
218: close c_chk_asg_benefit;
219: hr_utility.set_message(801, 'PAY_7980_COV_DEP_FORM_NOT_NAV');
220: hr_utility.raise_error;
221: end if;
222:
223: close c_chk_asg_benefit;
224: