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_BOOKINGS_PKG dependencies on HR_UTILITY

Line 68: HR_UTILITY.SET_MESSAGE('801','HR_7676_BOOKING_FLAG_CHANGE');

64: OPEN C1;
65: FETCH C1 INTO D_DUMMY;
66: IF C1%NOTFOUND THEN
67: CLOSE C1;
68: HR_UTILITY.SET_MESSAGE('801','HR_7676_BOOKING_FLAG_CHANGE');
69: HR_UTILITY.RAISE_ERROR;
70: END IF;
71: CLOSE C1;
72: END IF;

Line 69: HR_UTILITY.RAISE_ERROR;

65: FETCH C1 INTO D_DUMMY;
66: IF C1%NOTFOUND THEN
67: CLOSE C1;
68: HR_UTILITY.SET_MESSAGE('801','HR_7676_BOOKING_FLAG_CHANGE');
69: HR_UTILITY.RAISE_ERROR;
70: END IF;
71: CLOSE C1;
72: END IF;
73:

Line 79: HR_UTILITY.SET_MESSAGE('801','HR_7677_BOOKING_FLAG_CHANGE');

75: OPEN C2;
76: FETCH C2 INTO D_DUMMY;
77: IF C2%NOTFOUND THEN
78: CLOSE C2;
79: HR_UTILITY.SET_MESSAGE('801','HR_7677_BOOKING_FLAG_CHANGE');
80: HR_UTILITY.RAISE_ERROR;
81: END IF;
82: CLOSE C2;
83: END IF;

Line 80: HR_UTILITY.RAISE_ERROR;

76: FETCH C2 INTO D_DUMMY;
77: IF C2%NOTFOUND THEN
78: CLOSE C2;
79: HR_UTILITY.SET_MESSAGE('801','HR_7677_BOOKING_FLAG_CHANGE');
80: HR_UTILITY.RAISE_ERROR;
81: END IF;
82: CLOSE C2;
83: END IF;
84:

Line 90: HR_UTILITY.SET_MESSAGE('801','HR_7678_BOOKING_FLAG_CHANGE');

86: OPEN C3;
87: FETCH C3 INTO D_DUMMY;
88: IF C3%NOTFOUND THEN
89: CLOSE C3;
90: HR_UTILITY.SET_MESSAGE('801','HR_7678_BOOKING_FLAG_CHANGE');
91: HR_UTILITY.RAISE_ERROR;
92: END IF;
93: CLOSE C3;
94: END IF;

Line 91: HR_UTILITY.RAISE_ERROR;

87: FETCH C3 INTO D_DUMMY;
88: IF C3%NOTFOUND THEN
89: CLOSE C3;
90: HR_UTILITY.SET_MESSAGE('801','HR_7678_BOOKING_FLAG_CHANGE');
91: HR_UTILITY.RAISE_ERROR;
92: END IF;
93: CLOSE C3;
94: END IF;
95:

Line 232: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

228: OPEN C;
229: FETCH C INTO X_Rowid;
230: if (C%NOTFOUND) then
231: CLOSE C;
232: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_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','INSERT_ROW');

229: FETCH C INTO X_Rowid;
230: if (C%NOTFOUND) then
231: CLOSE C;
232: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');
234: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
235: HR_UTILITY.RAISE_ERROR;
236: end if;
237: CLOSE C;

Line 234: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

230: if (C%NOTFOUND) then
231: CLOSE C;
232: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');
234: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
235: HR_UTILITY.RAISE_ERROR;
236: end if;
237: CLOSE C;
238: END Insert_Row;

Line 235: HR_UTILITY.RAISE_ERROR;

231: CLOSE C;
232: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','INSERT_ROW');
234: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
235: HR_UTILITY.RAISE_ERROR;
236: end if;
237: CLOSE C;
238: END Insert_Row;
239:

Line 281: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

277: OPEN C;
278: FETCH C INTO Recinfo;
279: if (C%NOTFOUND) then
280: CLOSE C;
281: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
282: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
283: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
284: HR_UTILITY.RAISE_ERROR;
285: end if;

Line 282: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');

278: FETCH C INTO Recinfo;
279: if (C%NOTFOUND) then
280: CLOSE C;
281: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
282: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
283: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
284: HR_UTILITY.RAISE_ERROR;
285: end if;
286: CLOSE C;

Line 283: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

279: if (C%NOTFOUND) then
280: CLOSE C;
281: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
282: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
283: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
284: HR_UTILITY.RAISE_ERROR;
285: end if;
286: CLOSE C;
287:

Line 284: HR_UTILITY.RAISE_ERROR;

280: CLOSE C;
281: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
282: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','LOCK_ROW');
283: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
284: HR_UTILITY.RAISE_ERROR;
285: end if;
286: CLOSE C;
287:
288: Recinfo.comments := rtrim(Recinfo.comments);

Line 452: HR_UTILITY.SET_MESSAGE('801', 'PER_51973_EMP_EVENT_ONCE');

448: CLOSE UNIQUE_CHECK;
449: -- Check to see if X_Token is an EMPLOYEE or an APPLICANT
450: -- and then an error message is raised for that person type.
451: if X_Token = 'EMPLOYEE' then
452: HR_UTILITY.SET_MESSAGE('801', 'PER_51973_EMP_EVENT_ONCE');
453: elsif X_Token = 'APPLICANT' then
454: HR_UTILITY.SET_MESSAGE('801', 'PER_51974_APP_EVENT_ONCE');
455: end if;
456: HR_UTILITY.RAISE_ERROR;

Line 454: HR_UTILITY.SET_MESSAGE('801', 'PER_51974_APP_EVENT_ONCE');

450: -- and then an error message is raised for that person type.
451: if X_Token = 'EMPLOYEE' then
452: HR_UTILITY.SET_MESSAGE('801', 'PER_51973_EMP_EVENT_ONCE');
453: elsif X_Token = 'APPLICANT' then
454: HR_UTILITY.SET_MESSAGE('801', 'PER_51974_APP_EVENT_ONCE');
455: end if;
456: HR_UTILITY.RAISE_ERROR;
457: ELSE
458: CLOSE UNIQUE_CHECK;

Line 456: HR_UTILITY.RAISE_ERROR;

452: HR_UTILITY.SET_MESSAGE('801', 'PER_51973_EMP_EVENT_ONCE');
453: elsif X_Token = 'APPLICANT' then
454: HR_UTILITY.SET_MESSAGE('801', 'PER_51974_APP_EVENT_ONCE');
455: end if;
456: HR_UTILITY.RAISE_ERROR;
457: ELSE
458: CLOSE UNIQUE_CHECK;
459: END IF;
460:

Line 494: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

490: primary_interviewer_flag = X_Primary_Interviewer_Flag
491: WHERE rowid = X_rowid;
492:
493: if (SQL%NOTFOUND) then
494: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
495: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
496: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
497: HR_UTILITY.RAISE_ERROR;
498: end if;

Line 495: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');

491: WHERE rowid = X_rowid;
492:
493: if (SQL%NOTFOUND) then
494: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
495: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
496: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
497: HR_UTILITY.RAISE_ERROR;
498: end if;
499:

Line 496: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

492:
493: if (SQL%NOTFOUND) then
494: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
495: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
496: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
497: HR_UTILITY.RAISE_ERROR;
498: end if;
499:
500: END Update_Row;

Line 497: HR_UTILITY.RAISE_ERROR;

493: if (SQL%NOTFOUND) then
494: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
495: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','UPDATE_ROW');
496: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
497: HR_UTILITY.RAISE_ERROR;
498: end if;
499:
500: END Update_Row;
501:

Line 508: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');

504: DELETE FROM PER_BOOKINGS
505: WHERE rowid = X_Rowid;
506:
507: if (SQL%NOTFOUND) then
508: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
509: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
510: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
511: HR_UTILITY.RAISE_ERROR;
512: end if;

Line 509: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');

505: WHERE rowid = X_Rowid;
506:
507: if (SQL%NOTFOUND) then
508: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
509: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
510: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
511: HR_UTILITY.RAISE_ERROR;
512: end if;
513: END Delete_Row;

Line 510: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');

506:
507: if (SQL%NOTFOUND) then
508: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
509: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
510: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
511: HR_UTILITY.RAISE_ERROR;
512: end if;
513: END Delete_Row;
514:

Line 511: HR_UTILITY.RAISE_ERROR;

507: if (SQL%NOTFOUND) then
508: HR_UTILITY.SET_MESSAGE(801,'HR_6153_ALL_PROCEDURE_FAIL');
509: HR_UTILITY.SET_MESSAGE_TOKEN('PROCEDURE','DELETE_ROW');
510: HR_UTILITY.SET_MESSAGE_TOKEN('STEP','1');
511: HR_UTILITY.RAISE_ERROR;
512: end if;
513: END Delete_Row;
514:
515: END PER_BOOKINGS_PKG;