DBA Data[Home] [Help]

APPS.HR_NAVIGATION_UNITS_PKG dependencies on HR_UTILITY

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

121: OPEN C;
122: FETCH C INTO X_Rowid;
123: if (C%NOTFOUND) then
124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;

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

122: FETCH C INTO X_Rowid;
123: if (C%NOTFOUND) then
124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;
130: CLOSE C;

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

123: if (C%NOTFOUND) then
124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;
130: CLOSE C;
131: END Insert_Row;

Line 128: hr_utility.raise_error;

124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;
130: CLOSE C;
131: END Insert_Row;
132:

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

158: OPEN C;
159: FETCH C INTO Recinfo;
160: if (C%NOTFOUND) then
161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;

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

159: FETCH C INTO Recinfo;
160: if (C%NOTFOUND) then
161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
167: CLOSE C;

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

160: if (C%NOTFOUND) then
161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
167: CLOSE C;
168:

Line 165: hr_utility.raise_error;

161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
167: CLOSE C;
168:
169: Recinfo.default_label := rtrim(Recinfo.default_label);

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

245: block_name = X_Block_Name
246: WHERE rowid = X_rowid;
247:
248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;

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

246: WHERE rowid = X_rowid;
247:
248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254:

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

247:
248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254:
255: update HR_NAVIGATION_UNITS_TL

Line 252: hr_utility.raise_error;

248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254:
255: update HR_NAVIGATION_UNITS_TL
256: set

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

259: where NAV_UNIT_ID = X_NAV_UNIT_ID
260: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
261:
262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;

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

260: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
261:
262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;
268:

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

261:
262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;
268:
269: END Update_Row;

Line 266: hr_utility.raise_error;

262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;
268:
269: END Update_Row;
270:

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

323: delete from HR_NAVIGATION_UNITS_TL
324: where NAV_UNIT_ID = X_NAV_UNIT_ID;
325:
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;

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

324: where NAV_UNIT_ID = X_NAV_UNIT_ID;
325:
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332:

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

325:
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332:
333: --

Line 330: hr_utility.raise_error;

326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332:
333: --
334: -- Added the following code as a part of Zero Downtime Patching Project.

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

356: DELETE FROM HR_NAVIGATION_UNITS
357: WHERE rowid = X_Rowid;
358:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;

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

357: WHERE rowid = X_Rowid;
358:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: END Delete_Row;

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

358:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: END Delete_Row;
366:

Line 363: hr_utility.raise_error;

359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: END Delete_Row;
366:
367: procedure ADD_LANGUAGE