eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_JOB_REQUIREMENTS_PKG2 dependencies on HR_UTILITY

Line 25: hr_utility.set_message(801,'HR_6657_POS_DUP_REQ');

21: fetch csr_exists into l_dummy;
22: l_found := csr_exists%found;
23: close csr_exists;
24: if l_found then
25: hr_utility.set_message(801,'HR_6657_POS_DUP_REQ');
26: hr_utility.raise_error;
27: end if;
28: end;
29:

Line 26: hr_utility.raise_error;

22: l_found := csr_exists%found;
23: close csr_exists;
24: if l_found then
25: hr_utility.set_message(801,'HR_6657_POS_DUP_REQ');
26: hr_utility.raise_error;
27: end if;
28: end;
29:
30: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,

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

147: OPEN C;
148: FETCH C INTO X_Rowid;
149: if (C%NOTFOUND) then
150: CLOSE C;
151: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
152: hr_utility.set_message_token('PROCEDURE','Insert_row');
153: hr_utility.set_message_token('STEP','1');
154: hr_utility.raise_error;
155: end if;

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

148: FETCH C INTO X_Rowid;
149: if (C%NOTFOUND) then
150: CLOSE C;
151: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
152: hr_utility.set_message_token('PROCEDURE','Insert_row');
153: hr_utility.set_message_token('STEP','1');
154: hr_utility.raise_error;
155: end if;
156: CLOSE C;

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

149: if (C%NOTFOUND) then
150: CLOSE C;
151: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
152: hr_utility.set_message_token('PROCEDURE','Insert_row');
153: hr_utility.set_message_token('STEP','1');
154: hr_utility.raise_error;
155: end if;
156: CLOSE C;
157: END Insert_Row;

Line 154: hr_utility.raise_error;

150: CLOSE C;
151: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
152: hr_utility.set_message_token('PROCEDURE','Insert_row');
153: hr_utility.set_message_token('STEP','1');
154: hr_utility.raise_error;
155: end if;
156: CLOSE C;
157: END Insert_Row;
158: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

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

198: OPEN C;
199: FETCH C INTO Recinfo;
200: if (C%NOTFOUND) then
201: CLOSE C;
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','lock_row');
204: hr_utility.set_message_token('STEP','1');
205: hr_utility.raise_error;
206: end if;

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

199: FETCH C INTO Recinfo;
200: if (C%NOTFOUND) then
201: CLOSE C;
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','lock_row');
204: hr_utility.set_message_token('STEP','1');
205: hr_utility.raise_error;
206: end if;
207: CLOSE C;

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

200: if (C%NOTFOUND) then
201: CLOSE C;
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','lock_row');
204: hr_utility.set_message_token('STEP','1');
205: hr_utility.raise_error;
206: end if;
207: CLOSE C;
208: --

Line 205: hr_utility.raise_error;

201: CLOSE C;
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','lock_row');
204: hr_utility.set_message_token('STEP','1');
205: hr_utility.raise_error;
206: end if;
207: CLOSE C;
208: --
209: Recinfo.attribute20 := rtrim(Recinfo.attribute20);

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

402: attribute20 = X_Attribute20
403: WHERE rowid = X_rowid;
404:
405: if (SQL%NOTFOUND) then
406: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
407: hr_utility.set_message_token('PROCEDURE','update_row');
408: hr_utility.set_message_token('STEP','1');
409: hr_utility.raise_error;
410: end if;

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

403: WHERE rowid = X_rowid;
404:
405: if (SQL%NOTFOUND) then
406: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
407: hr_utility.set_message_token('PROCEDURE','update_row');
408: hr_utility.set_message_token('STEP','1');
409: hr_utility.raise_error;
410: end if;
411:

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

404:
405: if (SQL%NOTFOUND) then
406: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
407: hr_utility.set_message_token('PROCEDURE','update_row');
408: hr_utility.set_message_token('STEP','1');
409: hr_utility.raise_error;
410: end if;
411:
412: END Update_Row;

Line 409: hr_utility.raise_error;

405: if (SQL%NOTFOUND) then
406: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
407: hr_utility.set_message_token('PROCEDURE','update_row');
408: hr_utility.set_message_token('STEP','1');
409: hr_utility.raise_error;
410: end if;
411:
412: END Update_Row;
413:

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

416: DELETE FROM PER_JOB_REQUIREMENTS
417: WHERE rowid = X_Rowid;
418:
419: if (SQL%NOTFOUND) then
420: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE','delete_row');
422: hr_utility.set_message_token('STEP','1');
423: hr_utility.raise_error;
424: end if;

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

417: WHERE rowid = X_Rowid;
418:
419: if (SQL%NOTFOUND) then
420: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE','delete_row');
422: hr_utility.set_message_token('STEP','1');
423: hr_utility.raise_error;
424: end if;
425: END Delete_Row;

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

418:
419: if (SQL%NOTFOUND) then
420: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE','delete_row');
422: hr_utility.set_message_token('STEP','1');
423: hr_utility.raise_error;
424: end if;
425: END Delete_Row;
426:

Line 423: hr_utility.raise_error;

419: if (SQL%NOTFOUND) then
420: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE','delete_row');
422: hr_utility.set_message_token('STEP','1');
423: hr_utility.raise_error;
424: end if;
425: END Delete_Row;
426:
427: END PER_JOB_REQUIREMENTS_PKG2;