DBA Data[Home] [Help]

APPS.HR_NAVIGATION_UNITS_PKG dependencies on HR_UTILITY

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

90: OPEN C;
91: FETCH C INTO X_Rowid;
92: if (C%NOTFOUND) then
93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;

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

91: FETCH C INTO X_Rowid;
92: if (C%NOTFOUND) then
93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: CLOSE C;

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

92: if (C%NOTFOUND) then
93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: CLOSE C;
100: END Insert_Row;

Line 97: hr_utility.raise_error;

93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: CLOSE C;
100: END Insert_Row;
101:

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

127: OPEN C;
128: FETCH C INTO Recinfo;
129: if (C%NOTFOUND) then
130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;

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

128: FETCH C INTO Recinfo;
129: if (C%NOTFOUND) then
130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;
136: CLOSE C;

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

129: if (C%NOTFOUND) then
130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;
136: CLOSE C;
137:

Line 134: hr_utility.raise_error;

130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;
136: CLOSE C;
137:
138: Recinfo.default_label := rtrim(Recinfo.default_label);

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

214: block_name = X_Block_Name
215: WHERE rowid = X_rowid;
216:
217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;

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

215: WHERE rowid = X_rowid;
216:
217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223:

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

216:
217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223:
224: update HR_NAVIGATION_UNITS_TL

Line 221: hr_utility.raise_error;

217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223:
224: update HR_NAVIGATION_UNITS_TL
225: set

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

228: where NAV_UNIT_ID = X_NAV_UNIT_ID
229: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
230:
231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;

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

229: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
230:
231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;
237:

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

230:
231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;
237:
238: END Update_Row;

Line 235: hr_utility.raise_error;

231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;
237:
238: END Update_Row;
239:

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

291: delete from HR_NAVIGATION_UNITS_TL
292: where NAV_UNIT_ID = X_NAV_UNIT_ID;
293:
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;

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

292: where NAV_UNIT_ID = X_NAV_UNIT_ID;
293:
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;
300:

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

293:
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;
300:
301: DELETE FROM HR_NAVIGATION_UNITS

Line 298: hr_utility.raise_error;

294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;
300:
301: DELETE FROM HR_NAVIGATION_UNITS
302: WHERE rowid = X_Rowid;

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

301: DELETE FROM HR_NAVIGATION_UNITS
302: WHERE rowid = X_Rowid;
303:
304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;

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

302: WHERE rowid = X_Rowid;
303:
304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;
310: END Delete_Row;

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

303:
304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;
310: END Delete_Row;
311:

Line 308: hr_utility.raise_error;

304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;
310: END Delete_Row;
311:
312: procedure ADD_LANGUAGE