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

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

86: end if;
87:
88: exception
89: when others then
90: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
91: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.update_rows');
92: hr_utility.set_message_token('STEP','1');
93: hr_utility.raise_error;
94: end update_row;

Line 91: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.update_rows');

87:
88: exception
89: when others then
90: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
91: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.update_rows');
92: hr_utility.set_message_token('STEP','1');
93: hr_utility.raise_error;
94: end update_row;
95: --

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

88: exception
89: when others then
90: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
91: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.update_rows');
92: hr_utility.set_message_token('STEP','1');
93: hr_utility.raise_error;
94: end update_row;
95: --
96: --

Line 93: hr_utility.raise_error;

89: when others then
90: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
91: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.update_rows');
92: hr_utility.set_message_token('STEP','1');
93: hr_utility.raise_error;
94: end update_row;
95: --
96: --
97: procedure load_rows

Line 230: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls

226: and ((p_attribute20 is not null and p_attribute20 = pos.attribute20)
227: or
228: (p_attribute20 is null))
229: ;
230: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls
231: -- dbms_output.put_line(sqlcode);
232: -- dbms_output.put_line(sqlerrm);
233: hr_utility.trace(sqlcode);
234: hr_utility.trace(sqlerrm);

Line 233: hr_utility.trace(sqlcode);

229: ;
230: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls
231: -- dbms_output.put_line(sqlcode);
232: -- dbms_output.put_line(sqlerrm);
233: hr_utility.trace(sqlcode);
234: hr_utility.trace(sqlerrm);
235: open c;
236: fetch c into l_dummy;
237: if (c%notfound) then

Line 234: hr_utility.trace(sqlerrm);

230: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls
231: -- dbms_output.put_line(sqlcode);
232: -- dbms_output.put_line(sqlerrm);
233: hr_utility.trace(sqlcode);
234: hr_utility.trace(sqlerrm);
235: open c;
236: fetch c into l_dummy;
237: if (c%notfound) then
238: close c;

Line 242: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls

238: close c;
239: raise no_data_found;
240: end if;
241: close c;
242: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls
243: -- dbms_output.put_line(sqlcode);
244: -- dbms_output.put_line(sqlerrm);
245: hr_utility.trace(sqlcode);
246: hr_utility.trace(sqlerrm);

Line 245: hr_utility.trace(sqlcode);

241: close c;
242: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls
243: -- dbms_output.put_line(sqlcode);
244: -- dbms_output.put_line(sqlerrm);
245: hr_utility.trace(sqlcode);
246: hr_utility.trace(sqlerrm);
247: exception
248: when no_data_found then
249: hr_utility.set_message(801,'HR_51384_MMV_NO_POS_FOR_ORG');

Line 246: hr_utility.trace(sqlerrm);

242: -- Bug#885806. DBMS_OUTPUT.PUT_LINE calls were replaced with HR_UTILITY.TRACE calls
243: -- dbms_output.put_line(sqlcode);
244: -- dbms_output.put_line(sqlerrm);
245: hr_utility.trace(sqlcode);
246: hr_utility.trace(sqlerrm);
247: exception
248: when no_data_found then
249: hr_utility.set_message(801,'HR_51384_MMV_NO_POS_FOR_ORG');
250: hr_utility.raise_error;

Line 249: hr_utility.set_message(801,'HR_51384_MMV_NO_POS_FOR_ORG');

245: hr_utility.trace(sqlcode);
246: hr_utility.trace(sqlerrm);
247: exception
248: when no_data_found then
249: hr_utility.set_message(801,'HR_51384_MMV_NO_POS_FOR_ORG');
250: hr_utility.raise_error;
251: when others then
252: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.load_rows');

Line 250: hr_utility.raise_error;

246: hr_utility.trace(sqlerrm);
247: exception
248: when no_data_found then
249: hr_utility.set_message(801,'HR_51384_MMV_NO_POS_FOR_ORG');
250: hr_utility.raise_error;
251: when others then
252: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.load_rows');
254: hr_utility.set_message_token('STEP','1');

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

248: when no_data_found then
249: hr_utility.set_message(801,'HR_51384_MMV_NO_POS_FOR_ORG');
250: hr_utility.raise_error;
251: when others then
252: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.load_rows');
254: hr_utility.set_message_token('STEP','1');
255: -- Bug#885806.
256: -- hr_utility.raise_error;

Line 253: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.load_rows');

249: hr_utility.set_message(801,'HR_51384_MMV_NO_POS_FOR_ORG');
250: hr_utility.raise_error;
251: when others then
252: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.load_rows');
254: hr_utility.set_message_token('STEP','1');
255: -- Bug#885806.
256: -- hr_utility.raise_error;
257: -- dbms_output.put_line(sqlcode);

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

250: hr_utility.raise_error;
251: when others then
252: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.load_rows');
254: hr_utility.set_message_token('STEP','1');
255: -- Bug#885806.
256: -- hr_utility.raise_error;
257: -- dbms_output.put_line(sqlcode);
258: -- dbms_output.put_line(sqlerrm);

Line 256: -- hr_utility.raise_error;

252: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
253: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.load_rows');
254: hr_utility.set_message_token('STEP','1');
255: -- Bug#885806.
256: -- hr_utility.raise_error;
257: -- dbms_output.put_line(sqlcode);
258: -- dbms_output.put_line(sqlerrm);
259: raise_application_error(sqlcode,sqlerrm);
260: end load_rows;

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

317: open c;
318: fetch c into recinfo;
319: if (c%notfound) then
320: close c;
321: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
323: hr_utility.set_message_token('STEP','1');
324: hr_utility.raise_error;
325: end if;

Line 322: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');

318: fetch c into recinfo;
319: if (c%notfound) then
320: close c;
321: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
323: hr_utility.set_message_token('STEP','1');
324: hr_utility.raise_error;
325: end if;
326: close c;

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

319: if (c%notfound) then
320: close c;
321: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
323: hr_utility.set_message_token('STEP','1');
324: hr_utility.raise_error;
325: end if;
326: close c;
327: if (

Line 324: hr_utility.raise_error;

320: close c;
321: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
322: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
323: hr_utility.set_message_token('STEP','1');
324: hr_utility.raise_error;
325: end if;
326: close c;
327: if (
328: (recinfo.mass_move_id = p_mass_move_id)

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

468: AND (p_segment30 is null)))
469: ) then
470: return;
471: else
472: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
474: hr_utility.set_message_token('STEP','2');
475: hr_utility.raise_error;
476: end if;

Line 473: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');

469: ) then
470: return;
471: else
472: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
474: hr_utility.set_message_token('STEP','2');
475: hr_utility.raise_error;
476: end if;
477: exception

Line 474: hr_utility.set_message_token('STEP','2');

470: return;
471: else
472: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
474: hr_utility.set_message_token('STEP','2');
475: hr_utility.raise_error;
476: end if;
477: exception
478: when app_exceptions.record_lock_exception then

Line 475: hr_utility.raise_error;

471: else
472: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
473: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
474: hr_utility.set_message_token('STEP','2');
475: hr_utility.raise_error;
476: end if;
477: exception
478: when app_exceptions.record_lock_exception then
479: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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

475: hr_utility.raise_error;
476: end if;
477: exception
478: when app_exceptions.record_lock_exception then
479: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
480: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
481: hr_utility.set_message_token('STEP','3');
482: hr_utility.raise_error;
483: end;

Line 480: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');

476: end if;
477: exception
478: when app_exceptions.record_lock_exception then
479: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
480: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
481: hr_utility.set_message_token('STEP','3');
482: hr_utility.raise_error;
483: end;
484: end loop;

Line 481: hr_utility.set_message_token('STEP','3');

477: exception
478: when app_exceptions.record_lock_exception then
479: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
480: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
481: hr_utility.set_message_token('STEP','3');
482: hr_utility.raise_error;
483: end;
484: end loop;
485: end lock_row ;

Line 482: hr_utility.raise_error;

478: when app_exceptions.record_lock_exception then
479: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
480: hr_utility.set_message_token('PROCEDURE','per_mm_positions_pkg.lock_rows');
481: hr_utility.set_message_token('STEP','3');
482: hr_utility.raise_error;
483: end;
484: end loop;
485: end lock_row ;
486: --

Line 507: hr_utility.set_message(801,'HR_51330_MMV_POS_EXISTS');

503: open c;
504: fetch c into l_dummy;
505: if (c%found) then
506: close c;
507: hr_utility.set_message(801,'HR_51330_MMV_POS_EXISTS');
508: hr_utility.raise_error;
509: end if;
510: close c;
511:

Line 508: hr_utility.raise_error;

504: fetch c into l_dummy;
505: if (c%found) then
506: close c;
507: hr_utility.set_message(801,'HR_51330_MMV_POS_EXISTS');
508: hr_utility.raise_error;
509: end if;
510: close c;
511:
512: end chk_org;

Line 605: hr_utility.set_message(801,'HR_51358_POS_JOB_INVALID_DATE');

601: end if;
602:
603: Exception
604: When NO_DATA_FOUND then
605: hr_utility.set_message(801,'HR_51358_POS_JOB_INVALID_DATE');
606: hr_utility.raise_error;
607:
608: end get_target_job;
609: --

Line 606: hr_utility.raise_error;

602:
603: Exception
604: When NO_DATA_FOUND then
605: hr_utility.set_message(801,'HR_51358_POS_JOB_INVALID_DATE');
606: hr_utility.raise_error;
607:
608: end get_target_job;
609: --
610: --