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

Line 174: hr_utility.set_location('Inside Load_rows. before insert ',10);

170: is
171: l_effective_date per_mass_moves.effective_date%type;
172:
173: BEGIN
174: hr_utility.set_location('Inside Load_rows. before insert ',10);
175: -- added for 7214283
176: select effective_date into l_effective_date
177: from per_mass_moves where mass_move_id = p_mass_move_id;
178: -- added for 7214283

Line 237: hr_utility.set_location('Load_rows. After insert',20);

233: where vgr.position_id = mmpos.position_id
234: and mmpos.mass_move_id = p_mass_move_id
235: and l_effective_date between vgr.date_from and vgr.date_to; -- This condition added for 7214283
236:
237: hr_utility.set_location('Load_rows. After insert',20);
238:
239: exception
240: when no_data_found THEN
241: hr_utility.set_location(' Inside No data found ',30);

Line 241: hr_utility.set_location(' Inside No data found ',30);

237: hr_utility.set_location('Load_rows. After insert',20);
238:
239: exception
240: when no_data_found THEN
241: hr_utility.set_location(' Inside No data found ',30);
242: null;
243: when others THEN
244: hr_utility.set_location('Inside Others ',40);
245: hr_utility.set_location(sqlerrm,50);

Line 244: hr_utility.set_location('Inside Others ',40);

240: when no_data_found THEN
241: hr_utility.set_location(' Inside No data found ',30);
242: null;
243: when others THEN
244: hr_utility.set_location('Inside Others ',40);
245: hr_utility.set_location(sqlerrm,50);
246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');
248: hr_utility.set_message_token('STEP','1');

Line 245: hr_utility.set_location(sqlerrm,50);

241: hr_utility.set_location(' Inside No data found ',30);
242: null;
243: when others THEN
244: hr_utility.set_location('Inside Others ',40);
245: hr_utility.set_location(sqlerrm,50);
246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');
248: hr_utility.set_message_token('STEP','1');
249: hr_utility.raise_error;

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

242: null;
243: when others THEN
244: hr_utility.set_location('Inside Others ',40);
245: hr_utility.set_location(sqlerrm,50);
246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');
248: hr_utility.set_message_token('STEP','1');
249: hr_utility.raise_error;
250: end load_rows;

Line 247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');

243: when others THEN
244: hr_utility.set_location('Inside Others ',40);
245: hr_utility.set_location(sqlerrm,50);
246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');
248: hr_utility.set_message_token('STEP','1');
249: hr_utility.raise_error;
250: end load_rows;
251: --

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

244: hr_utility.set_location('Inside Others ',40);
245: hr_utility.set_location(sqlerrm,50);
246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');
248: hr_utility.set_message_token('STEP','1');
249: hr_utility.raise_error;
250: end load_rows;
251: --
252: --

Line 249: hr_utility.raise_error;

245: hr_utility.set_location(sqlerrm,50);
246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
247: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.load_rows');
248: hr_utility.set_message_token('STEP','1');
249: hr_utility.raise_error;
250: end load_rows;
251: --
252: --
253: procedure lock_row

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

293: open c;
294: fetch c into recinfo;
295: if (c%notfound) then
296: close c;
297: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
298: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
299: hr_utility.set_message_token('STEP','1');
300: hr_utility.raise_error;
301: end if;

Line 298: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');

294: fetch c into recinfo;
295: if (c%notfound) then
296: close c;
297: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
298: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
299: hr_utility.set_message_token('STEP','1');
300: hr_utility.raise_error;
301: end if;
302: close c;

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

295: if (c%notfound) then
296: close c;
297: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
298: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
299: hr_utility.set_message_token('STEP','1');
300: hr_utility.raise_error;
301: end if;
302: close c;
303: if (

Line 300: hr_utility.raise_error;

296: close c;
297: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
298: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
299: hr_utility.set_message_token('STEP','1');
300: hr_utility.raise_error;
301: end if;
302: close c;
303: if (
304: (recinfo.mass_move_id = p_mass_move_id)

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

388: AND (p_attribute20 is null)))
389: ) then
390: return;
391: else
392: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
393: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
394: hr_utility.set_message_token('STEP','2');
395: hr_utility.raise_error;
396: end if;

Line 393: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');

389: ) then
390: return;
391: else
392: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
393: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
394: hr_utility.set_message_token('STEP','2');
395: hr_utility.raise_error;
396: end if;
397: exception

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

390: return;
391: else
392: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
393: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
394: hr_utility.set_message_token('STEP','2');
395: hr_utility.raise_error;
396: end if;
397: exception
398: when app_exceptions.record_lock_exception then

Line 395: hr_utility.raise_error;

391: else
392: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
393: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
394: hr_utility.set_message_token('STEP','2');
395: hr_utility.raise_error;
396: end if;
397: exception
398: when app_exceptions.record_lock_exception then
399: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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

395: hr_utility.raise_error;
396: end if;
397: exception
398: when app_exceptions.record_lock_exception then
399: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
400: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
401: hr_utility.set_message_token('STEP','3');
402: hr_utility.raise_error;
403: end;

Line 400: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');

396: end if;
397: exception
398: when app_exceptions.record_lock_exception then
399: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
400: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
401: hr_utility.set_message_token('STEP','3');
402: hr_utility.raise_error;
403: end;
404: end loop;

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

397: exception
398: when app_exceptions.record_lock_exception then
399: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
400: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
401: hr_utility.set_message_token('STEP','3');
402: hr_utility.raise_error;
403: end;
404: end loop;
405: end lock_row ;

Line 402: hr_utility.raise_error;

398: when app_exceptions.record_lock_exception then
399: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
400: hr_utility.set_message_token('PROCEDURE','per_mm_valid_grades_pkg.lock_rows');
401: hr_utility.set_message_token('STEP','3');
402: hr_utility.raise_error;
403: end;
404: end loop;
405: end lock_row ;
406: --