DBA Data[Home] [Help]

APPS.BEN_BENEFICIARIES_PKG dependencies on HR_UTILITY

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

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;

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

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

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

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;

Line 68: hr_utility.raise_error;

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

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

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;

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

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

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

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;

Line 107: hr_utility.raise_error;

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

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

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

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

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;

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

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

Line 181: hr_utility.raise_error;

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;

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

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;

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

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;

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

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:

Line 198: hr_utility.raise_error;

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

Line 243: hr_utility.set_message(801, 'PAY_7981_BEN_FORM_NOT_NAV');

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;

Line 244: hr_utility.raise_error;

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: