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

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

14: open c1;
15: fetch c1 into p_job_id;
16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;

Line 19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');

15: fetch c1 into p_job_id;
16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
23: end if;

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

16: if (C1%NOTFOUND) then
17: CLOSE C1;
18: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
19: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
20: hr_utility.set_message_token('STEP','1');
21: end if;
22: close c1;
23: end if;
24: --

Line 25: hr_utility.set_location('PER_JOBS_PKG.get_next_sequence', 1);

21: end if;
22: close c1;
23: end if;
24: --
25: hr_utility.set_location('PER_JOBS_PKG.get_next_sequence', 1);
26: --
27: end get_next_sequence;
28: --
29: procedure check_unique_name(p_job_id in number,

Line 54: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');

50: v_not_unique := csr_name%FOUND;
51: close csr_name;
52: --
53: if v_not_unique then
54: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOBS_PKG.check_unique_name', 1);

Line 55: hr_utility.raise_error;

51: close csr_name;
52: --
53: if v_not_unique then
54: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOBS_PKG.check_unique_name', 1);
59: --

Line 58: hr_utility.set_location('PER_JOBS_PKG.check_unique_name', 1);

54: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_utility.set_location('PER_JOBS_PKG.check_unique_name', 1);
59: --
60: end check_unique_name;
61: --
62: procedure check_date_from(p_job_id in number,

Line 74: hr_utility.set_location('check date',99);

70: g_dummy_number number;
71: v_job_date_greater boolean := FALSE;
72: --
73: begin
74: hr_utility.set_location('check date',99);
75: --
76: -- If the date from item in the jobs block is greater than
77: -- the date from item in the grades block then raise an error
78: --

Line 85: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');

81: v_job_date_greater := csr_date_from%FOUND;
82: close csr_date_from;
83: --
84: if v_job_date_greater then
85: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');
86: hr_utility.raise_error;
87: end if;
88: --
89: hr_utility.set_location('PER_JOBS_PKG.check_date_from', 1);

Line 86: hr_utility.raise_error;

82: close csr_date_from;
83: --
84: if v_job_date_greater then
85: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');
86: hr_utility.raise_error;
87: end if;
88: --
89: hr_utility.set_location('PER_JOBS_PKG.check_date_from', 1);
90: --

Line 89: hr_utility.set_location('PER_JOBS_PKG.check_date_from', 1);

85: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');
86: hr_utility.raise_error;
87: end if;
88: --
89: hr_utility.set_location('PER_JOBS_PKG.check_date_from', 1);
90: --
91: end check_date_from;
92: --
93: procedure get_job_flex_structure(p_structure_defining_column in out nocopy varchar2,

Line 116: hr_utility.set_location('p_struct '||l_struct,99);

112: v_not_found := csr_job%NOTFOUND;
113: close csr_job;
114: --
115: l_struct := p_structure_defining_column;
116: hr_utility.set_location('p_struct '||l_struct,99);
117: --
118: if v_not_found then
119: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');

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

115: l_struct := p_structure_defining_column;
116: hr_utility.set_location('p_struct '||l_struct,99);
117: --
118: if v_not_found then
119: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
121: hr_utility.set_message_token('STEP','1');
122: hr_utility.raise_error;
123: end if;

Line 120: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');

116: hr_utility.set_location('p_struct '||l_struct,99);
117: --
118: if v_not_found then
119: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
121: hr_utility.set_message_token('STEP','1');
122: hr_utility.raise_error;
123: end if;
124: --

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

117: --
118: if v_not_found then
119: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
121: hr_utility.set_message_token('STEP','1');
122: hr_utility.raise_error;
123: end if;
124: --
125: hr_utility.set_location('PER_JOBS_PKG.get_job_flex_structure', 1);

Line 122: hr_utility.raise_error;

118: if v_not_found then
119: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
120: hr_utility.set_message_token('PROCEDURE','get_job_flex_structure');
121: hr_utility.set_message_token('STEP','1');
122: hr_utility.raise_error;
123: end if;
124: --
125: hr_utility.set_location('PER_JOBS_PKG.get_job_flex_structure', 1);
126: --

Line 125: hr_utility.set_location('PER_JOBS_PKG.get_job_flex_structure', 1);

121: hr_utility.set_message_token('STEP','1');
122: hr_utility.raise_error;
123: end if;
124: --
125: hr_utility.set_location('PER_JOBS_PKG.get_job_flex_structure', 1);
126: --
127: end get_job_flex_structure;
128: --
129: PROCEDURE check_altered_end_date(p_business_group_id number,

Line 157: hr_utility.set_location('PER_JOBS_PKG.check_altered_end_date', 1);

153: fetch csr_date_to into g_dummy_number;
154: p_early_date_to := csr_date_to%FOUND;
155: close csr_date_to;
156: --
157: hr_utility.set_location('PER_JOBS_PKG.check_altered_end_date', 1);
158: --
159: open csr_date_from;
160: fetch csr_date_from into g_dummy_number;
161: p_early_date_from := csr_date_from%FOUND;

Line 164: hr_utility.set_location('PER_JOBS_PKG.check_altered_end_date', 2);

160: fetch csr_date_from into g_dummy_number;
161: p_early_date_from := csr_date_from%FOUND;
162: close csr_date_from;
163: --
164: hr_utility.set_location('PER_JOBS_PKG.check_altered_end_date', 2);
165: --
166: end check_altered_end_date;
167: --
168: PROCEDURE update_valid_grades(p_business_group_id number,

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

188: and vg.job_id = p_job_id
189: and nvl(vg.date_to, p_end_of_time) > p_date_to;
190: --
191: if (SQL%NOTFOUND) then
192: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
194: hr_utility.set_message_token('STEP','1');
195: hr_utility.raise_error;
196: end if;

Line 193: hr_utility.set_message_token('PROCEDURE','update_valid_grades');

189: and nvl(vg.date_to, p_end_of_time) > p_date_to;
190: --
191: if (SQL%NOTFOUND) then
192: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
194: hr_utility.set_message_token('STEP','1');
195: hr_utility.raise_error;
196: end if;
197: --

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

190: --
191: if (SQL%NOTFOUND) then
192: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
194: hr_utility.set_message_token('STEP','1');
195: hr_utility.raise_error;
196: end if;
197: --
198: --

Line 195: hr_utility.raise_error;

191: if (SQL%NOTFOUND) then
192: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE','update_valid_grades');
194: hr_utility.set_message_token('STEP','1');
195: hr_utility.raise_error;
196: end if;
197: --
198: --
199: end update_valid_grades;

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

215: and vg.date_from > p_date_to;
216: --
217: --
218: if (SQL%NOTFOUND) then
219: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
221: hr_utility.set_message_token('STEP','1');
222: hr_utility.raise_error;
223: end if;

Line 220: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');

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

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

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

Line 222: hr_utility.raise_error;

218: if (SQL%NOTFOUND) then
219: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
220: hr_utility.set_message_token('PROCEDURE','delete_valid_grades');
221: hr_utility.set_message_token('STEP','1');
222: hr_utility.raise_error;
223: end if;
224: --
225: end delete_valid_grades;
226: --

Line 307: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');

303: v_record_exists := csr_position%FOUND;
304: close csr_position;
305: --
306: if v_record_exists then
307: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');
308: hr_utility.raise_error;
309: end if;
310: --
311: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 1);

Line 308: hr_utility.raise_error;

304: close csr_position;
305: --
306: if v_record_exists then
307: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');
308: hr_utility.raise_error;
309: end if;
310: --
311: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 1);
312: --

Line 311: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 1);

307: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');
308: hr_utility.raise_error;
309: end if;
310: --
311: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 1);
312: --
313: --
314: --
315: open csr_assignment;

Line 321: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');

317: v_record_exists := csr_assignment%FOUND;
318: close csr_assignment;
319: --
320: if v_record_exists then
321: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');
322: hr_utility.raise_error;
323: end if;
324: --
325: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 2);

Line 322: hr_utility.raise_error;

318: close csr_assignment;
319: --
320: if v_record_exists then
321: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');
322: hr_utility.raise_error;
323: end if;
324: --
325: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 2);
326: --

Line 325: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 2);

321: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');
322: hr_utility.raise_error;
323: end if;
324: --
325: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 2);
326: --
327: --
328: --
329: open csr_grade;

Line 335: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');

331: v_record_exists := csr_grade%FOUND;
332: close csr_grade;
333: --
334: if v_record_exists then
335: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');
336: hr_utility.raise_error;
337: end if;
338: --
339: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 3);

Line 336: hr_utility.raise_error;

332: close csr_grade;
333: --
334: if v_record_exists then
335: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');
336: hr_utility.raise_error;
337: end if;
338: --
339: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 3);
340: --

Line 339: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 3);

335: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');
336: hr_utility.raise_error;
337: end if;
338: --
339: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 3);
340: --
341: --
342: --
343: open csr_requirement;

Line 349: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');

345: v_record_exists := csr_requirement%FOUND;
346: close csr_requirement;
347: --
348: if v_record_exists then
349: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');
350: hr_utility.raise_error;
351: end if;
352: --
353: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 4);

Line 350: hr_utility.raise_error;

346: close csr_requirement;
347: --
348: if v_record_exists then
349: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');
350: hr_utility.raise_error;
351: end if;
352: --
353: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 4);
354: --

Line 353: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 4);

349: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');
350: hr_utility.raise_error;
351: end if;
352: --
353: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 4);
354: --
355: --
356: --
357: open csr_evaluation;

Line 363: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');

359: v_record_exists := csr_evaluation%FOUND;
360: close csr_evaluation;
361: --
362: if v_record_exists then
363: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');
364: hr_utility.raise_error;
365: end if;
366: --
367: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 5);

Line 364: hr_utility.raise_error;

360: close csr_evaluation;
361: --
362: if v_record_exists then
363: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');
364: hr_utility.raise_error;
365: end if;
366: --
367: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 5);
368: --

Line 367: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 5);

363: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');
364: hr_utility.raise_error;
365: end if;
366: --
367: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 5);
368: --
369: --
370: --
371: open csr_elementp;

Line 377: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');

373: v_record_exists := csr_elementp%FOUND;
374: close csr_elementp;
375: --
376: if v_record_exists then
377: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
378: hr_utility.raise_error;
379: end if;
380: --
381: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 6);

Line 378: hr_utility.raise_error;

374: close csr_elementp;
375: --
376: if v_record_exists then
377: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
378: hr_utility.raise_error;
379: end if;
380: --
381: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 6);
382: --

Line 381: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 6);

377: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
378: hr_utility.raise_error;
379: end if;
380: --
381: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 6);
382: --
383: --
384: --
385: open csr_elements;

Line 391: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');

387: v_record_exists := csr_elements%FOUND;
388: close csr_elements;
389: --
390: if v_record_exists then
391: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
392: hr_utility.raise_error;
393: end if;
394: --
395: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 7);

Line 392: hr_utility.raise_error;

388: close csr_elements;
389: --
390: if v_record_exists then
391: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
392: hr_utility.raise_error;
393: end if;
394: --
395: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 7);
396: --

Line 395: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 7);

391: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
392: hr_utility.raise_error;
393: end if;
394: --
395: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 7);
396: --
397: --
398: --
399: open csr_budget;

Line 405: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');

401: v_record_exists := csr_budget%FOUND;
402: close csr_budget;
403: --
404: if v_record_exists then
405: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');
406: hr_utility.raise_error;
407: end if;
408: --
409: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 8);

Line 406: hr_utility.raise_error;

402: close csr_budget;
403: --
404: if v_record_exists then
405: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');
406: hr_utility.raise_error;
407: end if;
408: --
409: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 8);
410: --

Line 409: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 8);

405: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');
406: hr_utility.raise_error;
407: end if;
408: --
409: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 8);
410: --
411: --
412: --
413: open csr_vacancy;

Line 419: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');

415: v_record_exists := csr_vacancy%FOUND;
416: close csr_vacancy;
417: --
418: if v_record_exists then
419: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');
420: hr_utility.raise_error;
421: end if;
422: --
423: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 9);

Line 420: hr_utility.raise_error;

416: close csr_vacancy;
417: --
418: if v_record_exists then
419: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');
420: hr_utility.raise_error;
421: end if;
422: --
423: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 9);
424: --

Line 423: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 9);

419: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');
420: hr_utility.raise_error;
421: end if;
422: --
423: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 9);
424: --
425: --
426: --
427: open csr_link;

Line 433: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');

429: v_record_exists := csr_link%FOUND;
430: close csr_link;
431: --
432: if v_record_exists then
433: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');
434: hr_utility.raise_error;
435: end if;
436: --
437: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 10);

Line 434: hr_utility.raise_error;

430: close csr_link;
431: --
432: if v_record_exists then
433: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');
434: hr_utility.raise_error;
435: end if;
436: --
437: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 10);
438: --

Line 437: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 10);

433: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');
434: hr_utility.raise_error;
435: end if;
436: --
437: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 10);
438: --
439: --
440: open csr_role;
441: fetch csr_role into g_dummy_number;

Line 446: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');

442: v_record_exists := csr_role%FOUND;
443: close csr_role;
444: --
445: if v_record_exists then
446: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');
447: hr_utility.raise_error;
448: end if;
449: --
450: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);

Line 447: hr_utility.raise_error;

443: close csr_role;
444: --
445: if v_record_exists then
446: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');
447: hr_utility.raise_error;
448: end if;
449: --
450: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);
451: --

Line 450: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);

446: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');
447: hr_utility.raise_error;
448: end if;
449: --
450: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);
451: --
452: -- is po installed?
453: --
454: if (fnd_installation.get(appl_id => 201

Line 509: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);

505: end;
506: end if;
507: end if;
508: --
509: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);
510: --
511: per_ota_predel_validation.ota_predel_job_validation(p_job_id);
512: --
513: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 12);

Line 513: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 12);

509: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 11);
510: --
511: per_ota_predel_validation.ota_predel_job_validation(p_job_id);
512: --
513: hr_utility.set_location('PER_JOBS_PKG.check_delete_record', 12);
514: --
515: pa_job.pa_predel_validation(p_job_id);
516: --
517: end check_delete_record;

Line 542: hr_utility.raise_error;

538: if l_job_evaluation.date_evaluated not between
539: nvl(p_job_date_from, hr_api.g_sot) and
540: nvl(p_job_date_to, hr_api.g_eot) then
541: fnd_message.set_name('PER', 'HR_52603_JOB_JBE_OUT_PERIOD');
542: hr_utility.raise_error;
543: end if;
544: end loop;
545: end if;
546: