DBA Data[Home] [Help]

APPS.PER_JOB_EVALUATIONS_PKG2 dependencies on HR_UTILITY

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

117: OPEN C;
118: FETCH C INTO X_Rowid;
119: if (C%NOTFOUND) then
120: CLOSE C;
121: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE','Insert_row');
123: hr_utility.set_message_token('STEP','1');
124: hr_utility.raise_error;
125: end if;

Line 122: hr_utility.set_message_token('PROCEDURE','Insert_row');

118: FETCH C INTO X_Rowid;
119: if (C%NOTFOUND) then
120: CLOSE C;
121: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE','Insert_row');
123: hr_utility.set_message_token('STEP','1');
124: hr_utility.raise_error;
125: end if;
126: CLOSE C;

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

119: if (C%NOTFOUND) then
120: CLOSE C;
121: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE','Insert_row');
123: hr_utility.set_message_token('STEP','1');
124: hr_utility.raise_error;
125: end if;
126: CLOSE C;
127: END Insert_Row;

Line 124: hr_utility.raise_error;

120: CLOSE C;
121: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
122: hr_utility.set_message_token('PROCEDURE','Insert_row');
123: hr_utility.set_message_token('STEP','1');
124: hr_utility.raise_error;
125: end if;
126: CLOSE C;
127: END Insert_Row;
128: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

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

168: OPEN C;
169: FETCH C INTO Recinfo;
170: if (C%NOTFOUND) then
171: CLOSE C;
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','lock_row');
174: hr_utility.set_message_token('STEP','1');
175: hr_utility.raise_error;
176: end if;

Line 173: hr_utility.set_message_token('PROCEDURE','lock_row');

169: FETCH C INTO Recinfo;
170: if (C%NOTFOUND) then
171: CLOSE C;
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','lock_row');
174: hr_utility.set_message_token('STEP','1');
175: hr_utility.raise_error;
176: end if;
177: CLOSE C;

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

170: if (C%NOTFOUND) then
171: CLOSE C;
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','lock_row');
174: hr_utility.set_message_token('STEP','1');
175: hr_utility.raise_error;
176: end if;
177: CLOSE C;
178: --

Line 175: hr_utility.raise_error;

171: CLOSE C;
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','lock_row');
174: hr_utility.set_message_token('STEP','1');
175: hr_utility.raise_error;
176: end if;
177: CLOSE C;
178: --
179: Recinfo.comments := rtrim(Recinfo.comments);

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

369: attribute20 = X_Attribute20
370: WHERE rowid = X_rowid;
371:
372: if (SQL%NOTFOUND) then
373: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
374: hr_utility.set_message_token('PROCEDURE','update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;

Line 374: hr_utility.set_message_token('PROCEDURE','update_row');

370: WHERE rowid = X_rowid;
371:
372: if (SQL%NOTFOUND) then
373: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
374: hr_utility.set_message_token('PROCEDURE','update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;
378:

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

371:
372: if (SQL%NOTFOUND) then
373: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
374: hr_utility.set_message_token('PROCEDURE','update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;
378:
379: END Update_Row;

Line 376: hr_utility.raise_error;

372: if (SQL%NOTFOUND) then
373: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
374: hr_utility.set_message_token('PROCEDURE','update_row');
375: hr_utility.set_message_token('STEP','1');
376: hr_utility.raise_error;
377: end if;
378:
379: END Update_Row;
380:

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

383: DELETE FROM PER_JOB_EVALUATIONS
384: WHERE rowid = X_Rowid;
385:
386: if (SQL%NOTFOUND) then
387: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
388: hr_utility.set_message_token('PROCEDURE','delete_row');
389: hr_utility.set_message_token('STEP','1');
390: hr_utility.raise_error;
391: end if;

Line 388: hr_utility.set_message_token('PROCEDURE','delete_row');

384: WHERE rowid = X_Rowid;
385:
386: if (SQL%NOTFOUND) then
387: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
388: hr_utility.set_message_token('PROCEDURE','delete_row');
389: hr_utility.set_message_token('STEP','1');
390: hr_utility.raise_error;
391: end if;
392: END Delete_Row;

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

385:
386: if (SQL%NOTFOUND) then
387: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
388: hr_utility.set_message_token('PROCEDURE','delete_row');
389: hr_utility.set_message_token('STEP','1');
390: hr_utility.raise_error;
391: end if;
392: END Delete_Row;
393:

Line 390: hr_utility.raise_error;

386: if (SQL%NOTFOUND) then
387: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
388: hr_utility.set_message_token('PROCEDURE','delete_row');
389: hr_utility.set_message_token('STEP','1');
390: hr_utility.raise_error;
391: end if;
392: END Delete_Row;
393:
394: END PER_JOB_EVALUATIONS_PKG2;