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

Line 41: hr_utility.set_message (801,'PER_7350_OUT_LETTER_EXISTS');

37: close csr_request;
38:
39: --
40: if v_not_unique then
41: hr_utility.set_message (801,'PER_7350_OUT_LETTER_EXISTS');
42: hr_utility.raise_error;
43: end if;
44: --
45: end check_request_unique;

Line 42: hr_utility.raise_error;

38:
39: --
40: if v_not_unique then
41: hr_utility.set_message (801,'PER_7350_OUT_LETTER_EXISTS');
42: hr_utility.raise_error;
43: end if;
44: --
45: end check_request_unique;
46: --

Line 66: hr_utility.set_message (801,'PER_7351_OUT_LETTER_NO_LINES');

62: request_lines_not_exist := c%notfound;
63: close c;
64: --
65: if request_lines_not_exist then
66: hr_utility.set_message (801,'PER_7351_OUT_LETTER_NO_LINES');
67: hr_utility.raise_error;
68: end if;
69: --
70: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.check_request_lines', 1);

Line 67: hr_utility.raise_error;

63: close c;
64: --
65: if request_lines_not_exist then
66: hr_utility.set_message (801,'PER_7351_OUT_LETTER_NO_LINES');
67: hr_utility.raise_error;
68: end if;
69: --
70: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.check_request_lines', 1);
71: --

Line 70: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.check_request_lines', 1);

66: hr_utility.set_message (801,'PER_7351_OUT_LETTER_NO_LINES');
67: hr_utility.raise_error;
68: end if;
69: --
70: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.check_request_lines', 1);
71: --
72: end check_request_lines;
73: --
74: PROCEDURE confirm_delete_lines (X_letter_request_id in NUMBER,

Line 96: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.confirm_delete_lines', 1);

92: X_request_lines_exist := TRUE;
93: end if;
94: close c;
95: --
96: hr_utility.set_location('PER_LETTER_REQUESTS_PKG.confirm_delete_lines', 1);
97: --
98: end confirm_delete_lines;
99: --
100: PROCEDURE Insert_Row(X_Rowid IN OUT nocopy VARCHAR2,

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

140: --
141: OPEN C;
142: FETCH C INTO X_Rowid;
143: if (C%NOTFOUND) then
144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
145: hr_utility.set_message_token('PROCEDURE','Insert_Row');
146: hr_utility.set_message_token('STEP','1');
147: hr_utility.raise_error;
148: end if;

Line 145: hr_utility.set_message_token('PROCEDURE','Insert_Row');

141: OPEN C;
142: FETCH C INTO X_Rowid;
143: if (C%NOTFOUND) then
144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
145: hr_utility.set_message_token('PROCEDURE','Insert_Row');
146: hr_utility.set_message_token('STEP','1');
147: hr_utility.raise_error;
148: end if;
149: CLOSE C;

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

142: FETCH C INTO X_Rowid;
143: if (C%NOTFOUND) then
144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
145: hr_utility.set_message_token('PROCEDURE','Insert_Row');
146: hr_utility.set_message_token('STEP','1');
147: hr_utility.raise_error;
148: end if;
149: CLOSE C;
150: END Insert_Row;

Line 147: hr_utility.raise_error;

143: if (C%NOTFOUND) then
144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
145: hr_utility.set_message_token('PROCEDURE','Insert_Row');
146: hr_utility.set_message_token('STEP','1');
147: hr_utility.raise_error;
148: end if;
149: CLOSE C;
150: END Insert_Row;
151: --

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

171: --
172: OPEN C;
173: FETCH C INTO Recinfo;
174: if (C%NOTFOUND) then
175: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
176: hr_utility.set_message_token('PROCEDURE','Lock_Row');
177: hr_utility.set_message_token('STEP','1');
178: hr_utility.raise_error;
179: end if;

Line 176: hr_utility.set_message_token('PROCEDURE','Lock_Row');

172: OPEN C;
173: FETCH C INTO Recinfo;
174: if (C%NOTFOUND) then
175: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
176: hr_utility.set_message_token('PROCEDURE','Lock_Row');
177: hr_utility.set_message_token('STEP','1');
178: hr_utility.raise_error;
179: end if;
180: CLOSE C;

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

173: FETCH C INTO Recinfo;
174: if (C%NOTFOUND) then
175: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
176: hr_utility.set_message_token('PROCEDURE','Lock_Row');
177: hr_utility.set_message_token('STEP','1');
178: hr_utility.raise_error;
179: end if;
180: CLOSE C;
181: --

Line 178: hr_utility.raise_error;

174: if (C%NOTFOUND) then
175: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
176: hr_utility.set_message_token('PROCEDURE','Lock_Row');
177: hr_utility.set_message_token('STEP','1');
178: hr_utility.raise_error;
179: end if;
180: CLOSE C;
181: --
182: Recinfo.request_status := rtrim(Recinfo.request_status);

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

233: event_id = X_Event_ID
234: WHERE rowid = X_rowid;
235: --
236: if (SQL%NOTFOUND) then
237: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE','Update_Row');
239: hr_utility.set_message_token('STEP','1');
240: hr_utility.raise_error;
241: end if;

Line 238: hr_utility.set_message_token('PROCEDURE','Update_Row');

234: WHERE rowid = X_rowid;
235: --
236: if (SQL%NOTFOUND) then
237: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE','Update_Row');
239: hr_utility.set_message_token('STEP','1');
240: hr_utility.raise_error;
241: end if;
242: --

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

235: --
236: if (SQL%NOTFOUND) then
237: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE','Update_Row');
239: hr_utility.set_message_token('STEP','1');
240: hr_utility.raise_error;
241: end if;
242: --
243: END Update_Row;

Line 240: hr_utility.raise_error;

236: if (SQL%NOTFOUND) then
237: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE','Update_Row');
239: hr_utility.set_message_token('STEP','1');
240: hr_utility.raise_error;
241: end if;
242: --
243: END Update_Row;
244: --

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

264: DELETE FROM per_letter_request_lines
265: WHERE letter_Request_Id = X_letter_request_id;
266: --
267: if (SQL%NOTFOUND) then
268: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
269: hr_utility.set_message_token('PROCEDURE','Delete_Row');
270: hr_utility.set_message_token('STEP','1');
271: hr_utility.raise_error;
272: end if;

Line 269: hr_utility.set_message_token('PROCEDURE','Delete_Row');

265: WHERE letter_Request_Id = X_letter_request_id;
266: --
267: if (SQL%NOTFOUND) then
268: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
269: hr_utility.set_message_token('PROCEDURE','Delete_Row');
270: hr_utility.set_message_token('STEP','1');
271: hr_utility.raise_error;
272: end if;
273: --

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

266: --
267: if (SQL%NOTFOUND) then
268: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
269: hr_utility.set_message_token('PROCEDURE','Delete_Row');
270: hr_utility.set_message_token('STEP','1');
271: hr_utility.raise_error;
272: end if;
273: --
274: end if;

Line 271: hr_utility.raise_error;

267: if (SQL%NOTFOUND) then
268: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
269: hr_utility.set_message_token('PROCEDURE','Delete_Row');
270: hr_utility.set_message_token('STEP','1');
271: hr_utility.raise_error;
272: end if;
273: --
274: end if;
275: --

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

276: DELETE FROM per_letter_requests
277: WHERE rowid = X_Rowid;
278: --
279: if (SQL%NOTFOUND) then
280: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE','Delete_Row');
282: hr_utility.set_message_token('STEP','1');
283: hr_utility.raise_error;
284: end if;

Line 281: hr_utility.set_message_token('PROCEDURE','Delete_Row');

277: WHERE rowid = X_Rowid;
278: --
279: if (SQL%NOTFOUND) then
280: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE','Delete_Row');
282: hr_utility.set_message_token('STEP','1');
283: hr_utility.raise_error;
284: end if;
285: --

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

278: --
279: if (SQL%NOTFOUND) then
280: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE','Delete_Row');
282: hr_utility.set_message_token('STEP','1');
283: hr_utility.raise_error;
284: end if;
285: --
286: END Delete_Row;

Line 283: hr_utility.raise_error;

279: if (SQL%NOTFOUND) then
280: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
281: hr_utility.set_message_token('PROCEDURE','Delete_Row');
282: hr_utility.set_message_token('STEP','1');
283: hr_utility.raise_error;
284: end if;
285: --
286: END Delete_Row;
287: --