APPS.PER_SPINAL_POINT_STEPS_PKG dependencies on HR_UTILITY

Line 391: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',1);

387: and p_sess < effective_end_date;
388: --
389: begin
390: --
391: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',1);
392: --
393: open c1;
394: --
395: fetch c1 into l_exists1;

Line 397: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');

393: open c1;
394: --
395: fetch c1 into l_exists1;
396: IF c1%found THEN
397: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');
398: close c1;
399: hr_utility.raise_error;
400: END IF;
401: --

Line 399: hr_utility.raise_error;

395: fetch c1 into l_exists1;
396: IF c1%found THEN
397: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');
398: close c1;
399: hr_utility.raise_error;
400: END IF;
401: --
402: close c1;
403: --

Line 404: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',2);

400: END IF;
401: --
402: close c1;
403: --
404: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_del',2);
405: --
406: open c2;
407: --
408: fetch c2 into l_exists2;

Line 410: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');

406: open c2;
407: --
408: fetch c2 into l_exists2;
409: IF c2%found THEN
410: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');
411: close c2;
412: hr_utility.raise_error;
413: END IF;
414: --

Line 412: hr_utility.raise_error;

408: fetch c2 into l_exists2;
409: IF c2%found THEN
410: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');
411: close c2;
412: hr_utility.raise_error;
413: END IF;
414: --
415: close c2;
416: --

Line 438: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',1);

434: and special_ceiling_step_id is not null;
435: --
436: begin
437: --
438: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',1);
439: --
440: open c3;
441: --
442: fetch c3 into l_exists;

Line 444: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');

440: open c3;
441: --
442: fetch c3 into l_exists;
443: IF c3%found THEN
444: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');
445: close c3;
446: hr_utility.raise_error;
447: END IF;
448: --

Line 446: hr_utility.raise_error;

442: fetch c3 into l_exists;
443: IF c3%found THEN
444: hr_utility.set_message(801, 'PER_7938_DEL_STEP_PLACE');
445: close c3;
446: hr_utility.raise_error;
447: END IF;
448: --
449: close c3;
450: --

Line 451: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',2);

447: END IF;
448: --
449: close c3;
450: --
451: hr_utility.set_location('per_spinal_point_steps_pkg.del_chks_zap',2);
452: --
453: open c4;
454: --
455: fetch c4 into l_exists2;

Line 457: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');

453: open c4;
454: --
455: fetch c4 into l_exists2;
456: IF c4%found THEN
457: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');
458: close c4;
459: hr_utility.raise_error;
460: END IF;
461: --

Line 459: hr_utility.raise_error;

455: fetch c4 into l_exists2;
456: IF c4%found THEN
457: hr_utility.set_message(801, 'PER_7939_DEL_STEP_ASS');
458: close c4;
459: hr_utility.raise_error;
460: END IF;
461: --
462: close c4;
463: --

Line 486: hr_utility.set_location('per_spinal_point_steps_pkg.chk_unq_step_point',1);

482: and sp.step_id <> p_step_id);
483: --
484: begin
485: --
486: hr_utility.set_location('per_spinal_point_steps_pkg.chk_unq_step_point',1);
487: --
488: open c5;
489: --
490: fetch c5 into l_exists;

Line 492: hr_utility.set_message(801, 'PER_7936_GRDSPN_POINT_EXISTS');

488: open c5;
489: --
490: fetch c5 into l_exists;
491: IF c5%found THEN
492: hr_utility.set_message(801, 'PER_7936_GRDSPN_POINT_EXISTS');
493: close c5;
494: hr_utility.raise_error;
495: END IF;
496: --

Line 494: hr_utility.raise_error;

490: fetch c5 into l_exists;
491: IF c5%found THEN
492: hr_utility.set_message(801, 'PER_7936_GRDSPN_POINT_EXISTS');
493: close c5;
494: hr_utility.raise_error;
495: END IF;
496: --
497: close c5;
498: --

Line 525: hr_utility.set_location('per_spinal_point_steps_pkg.pop_flds',1);

521: l_count NUMBER;
522: --
523: begin
524: --
525: hr_utility.set_location('per_spinal_point_steps_pkg.pop_flds',1);
526: --
527: open c6;
528: --
529: fetch c6 into l_count;