DBA Data[Home] [Help]

APPS.BEN_COVERED_DEPENDENTS_PKG dependencies on HR_UTILITY

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

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;

Line 50: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');

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

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

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;

Line 52: hr_utility.raise_error;

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

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

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;

Line 88: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');

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

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

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;

Line 90: hr_utility.raise_error;

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

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

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

Line 151: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');

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;

Line 152: hr_utility.set_message_token('STEP','20');

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

Line 153: hr_utility.raise_error;

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;

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

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;

Line 170: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');

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

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

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;

Line 172: hr_utility.raise_error;

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

Line 219: hr_utility.set_message(801, 'PAY_7980_COV_DEP_FORM_NOT_NAV');

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;

Line 220: hr_utility.raise_error;

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: