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

Line 488: hr_utility.set_location('per_grades_pkg.stbdelvl',1);

484: AND rate_type = 'G';
485: --
486: begin
487: --
488: hr_utility.set_location('per_grades_pkg.stbdelvl',1);
489: --
490: open c1;
491: --
492: fetch c1 into l_exists;

Line 494: hr_utility.set_message(801, 'PER_7834_DEF_GRADE_DEL_ASSIGN');

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

Line 496: hr_utility.raise_error;

492: fetch c1 into l_exists;
493: IF c1%found THEN
494: hr_utility.set_message(801, 'PER_7834_DEF_GRADE_DEL_ASSIGN');
495: close c1;
496: hr_utility.raise_error;
497: END IF;
498: --
499: close c1;
500: --

Line 501: hr_utility.set_location('per_grades_pkg.stbdelvl',2);

497: END IF;
498: --
499: close c1;
500: --
501: hr_utility.set_location('per_grades_pkg.stbdelvl',2);
502: --
503: open c2;
504: --
505: fetch c2 into l_exists;

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

503: open c2;
504: --
505: fetch c2 into l_exists;
506: IF c2%found THEN
507: hr_utility.set_message(801, 'HR_6443_GRADE_DEL_VALID_GRADES');
508: close c2;
509: hr_utility.raise_error;
510: END IF;
511: --

Line 509: hr_utility.raise_error;

505: fetch c2 into l_exists;
506: IF c2%found THEN
507: hr_utility.set_message(801, 'HR_6443_GRADE_DEL_VALID_GRADES');
508: close c2;
509: hr_utility.raise_error;
510: END IF;
511: --
512: close c2;
513: --

Line 514: hr_utility.set_location('per_grades_pkg.stbdelvl',3);

510: END IF;
511: --
512: close c2;
513: --
514: hr_utility.set_location('per_grades_pkg.stbdelvl',3);
515: --
516: open c3;
517: --
518: fetch c3 into l_exists;

Line 520: hr_utility.set_message(801, 'HR_6444_GRADE_DEL_VACANCIES');

516: open c3;
517: --
518: fetch c3 into l_exists;
519: IF c3%found THEN
520: hr_utility.set_message(801, 'HR_6444_GRADE_DEL_VACANCIES');
521: close c3;
522: hr_utility.raise_error;
523: END IF;
524: --

Line 522: hr_utility.raise_error;

518: fetch c3 into l_exists;
519: IF c3%found THEN
520: hr_utility.set_message(801, 'HR_6444_GRADE_DEL_VACANCIES');
521: close c3;
522: hr_utility.raise_error;
523: END IF;
524: --
525: close c3;
526: --

Line 527: hr_utility.set_location('per_grades_pkg.stbdelvl',4);

523: END IF;
524: --
525: close c3;
526: --
527: hr_utility.set_location('per_grades_pkg.stbdelvl',4);
528: --
529: open c4;
530: --
531: fetch c4 into l_exists;

Line 533: hr_utility.set_message(801, 'HR_6446_DEL_ELE_LINKS');

529: open c4;
530: --
531: fetch c4 into l_exists;
532: IF c4%found THEN
533: hr_utility.set_message(801, 'HR_6446_DEL_ELE_LINKS');
534: close c4;
535: hr_utility.raise_error;
536: END IF;
537: --

Line 535: hr_utility.raise_error;

531: fetch c4 into l_exists;
532: IF c4%found THEN
533: hr_utility.set_message(801, 'HR_6446_DEL_ELE_LINKS');
534: close c4;
535: hr_utility.raise_error;
536: END IF;
537: --
538: close c4;
539: --

Line 540: hr_utility.set_location('per_grades_pkg.stbdelvl',5);

536: END IF;
537: --
538: close c4;
539: --
540: hr_utility.set_location('per_grades_pkg.stbdelvl',5);
541: --
542: open c5;
543: --
544: fetch c5 into l_exists;

Line 546: hr_utility.set_message(801, 'HR_6447_GRADE_DEL_BUDGET_ELE');

542: open c5;
543: --
544: fetch c5 into l_exists;
545: IF c5%found THEN
546: hr_utility.set_message(801, 'HR_6447_GRADE_DEL_BUDGET_ELE');
547: close c5;
548: hr_utility.raise_error;
549: END IF;
550: --

Line 548: hr_utility.raise_error;

544: fetch c5 into l_exists;
545: IF c5%found THEN
546: hr_utility.set_message(801, 'HR_6447_GRADE_DEL_BUDGET_ELE');
547: close c5;
548: hr_utility.raise_error;
549: END IF;
550: --
551: close c5;
552: --

Line 553: hr_utility.set_location('per_grades_pkg.stbdelvl',6);

549: END IF;
550: --
551: close c5;
552: --
553: hr_utility.set_location('per_grades_pkg.stbdelvl',6);
554: --
555: open c6;
556: --
557: fetch c6 into l_exists;

Line 559: hr_utility.set_message(801, 'HR_6448_GRADE_DEL_GRADE_SPINES');

555: open c6;
556: --
557: fetch c6 into l_exists;
558: IF c6%found THEN
559: hr_utility.set_message(801, 'HR_6448_GRADE_DEL_GRADE_SPINES');
560: close c6;
561: hr_utility.raise_error;
562: END IF;
563: --

Line 561: hr_utility.raise_error;

557: fetch c6 into l_exists;
558: IF c6%found THEN
559: hr_utility.set_message(801, 'HR_6448_GRADE_DEL_GRADE_SPINES');
560: close c6;
561: hr_utility.raise_error;
562: END IF;
563: --
564: close c6;
565: --

Line 566: hr_utility.set_location('per_grades_pkg.stbdelvl',7);

562: END IF;
563: --
564: close c6;
565: --
566: hr_utility.set_location('per_grades_pkg.stbdelvl',7);
567: --
568: open c7;
569: --
570: fetch c7 into l_exists;

Line 572: hr_utility.set_message(801, 'HR_6684_GRADE_RULES');

568: open c7;
569: --
570: fetch c7 into l_exists;
571: IF c7%found THEN
572: hr_utility.set_message(801, 'HR_6684_GRADE_RULES');
573: close c7;
574: hr_utility.raise_error;
575: END IF;
576: --

Line 574: hr_utility.raise_error;

570: fetch c7 into l_exists;
571: IF c7%found THEN
572: hr_utility.set_message(801, 'HR_6684_GRADE_RULES');
573: close c7;
574: hr_utility.raise_error;
575: END IF;
576: --
577: close c7;
578: --

Line 687: hr_utility.set_location('per_grades_pkg.gstruct',1);

683: AND rownum = 1;
684: --
685: begin
686: --
687: hr_utility.set_location('per_grades_pkg.gstruct',1);
688: --
689: open c10;
690: --
691: fetch c10 into l_g_str;

Line 693: hr_utility.set_message(801,'HR_6788_GR_NO_DYN_INS');

689: open c10;
690: --
691: fetch c10 into l_g_str;
692: IF c10%notfound THEN
693: hr_utility.set_message(801,'HR_6788_GR_NO_DYN_INS');
694: close c10;
695: hr_utility.raise_error;
696: END IF;
697: --

Line 695: hr_utility.raise_error;

691: fetch c10 into l_g_str;
692: IF c10%notfound THEN
693: hr_utility.set_message(801,'HR_6788_GR_NO_DYN_INS');
694: close c10;
695: hr_utility.raise_error;
696: END IF;
697: --
698: close c10;
699: --

Line 720: hr_utility.set_location('per_grades_pkg.b_check_grade_date_from',1);

716: AND p_date_from > date_from;
717: --
718: begin
719: --
720: hr_utility.set_location('per_grades_pkg.b_check_grade_date_from',1);
721: --
722: open c11;
723: --
724: fetch c11 into l_exists;

Line 726: hr_utility.set_message(801, 'PER_7808_DEF_GRADE_FIRST_VALID');

722: open c11;
723: --
724: fetch c11 into l_exists;
725: IF c11%found THEN
726: hr_utility.set_message(801, 'PER_7808_DEF_GRADE_FIRST_VALID');
727: close c11;
728: hr_utility.raise_error;
729: END IF;
730: --

Line 728: hr_utility.raise_error;

724: fetch c11 into l_exists;
725: IF c11%found THEN
726: hr_utility.set_message(801, 'PER_7808_DEF_GRADE_FIRST_VALID');
727: close c11;
728: hr_utility.raise_error;
729: END IF;
730: --
731: close c11;
732: --

Line 753: hr_utility.set_location('per_grades_pkg.chk_flex_def',1);

749: AND p.grade_definition_id = p_grdef_id;
750: --
751: begin
752: --
753: hr_utility.set_location('per_grades_pkg.chk_flex_def',1);
754: --
755: open c12;
756: --
757: fetch c12 into l_exists;

Line 759: hr_utility.set_message(801, 'PER_7830_DEF_GRADE_EXISTS');

755: open c12;
756: --
757: fetch c12 into l_exists;
758: IF c12%found THEN
759: hr_utility.set_message(801, 'PER_7830_DEF_GRADE_EXISTS');
760: close c12;
761: hr_utility.raise_error;
762: END IF;
763: --

Line 761: hr_utility.raise_error;

757: fetch c12 into l_exists;
758: IF c12%found THEN
759: hr_utility.set_message(801, 'PER_7830_DEF_GRADE_EXISTS');
760: close c12;
761: hr_utility.raise_error;
762: END IF;
763: --
764: close c12;
765: --

Line 787: hr_utility.set_location('per_grades_pkg.chk_grade',1);

783: AND p_seg = p.name;
784: --
785: begin
786: --
787: hr_utility.set_location('per_grades_pkg.chk_grade',1);
788: --
789: open c14;
790: --
791: fetch c14 into p_popid;

Line 811: hr_utility.set_location('per_grades_pkg.old_date_to',1);

807: where grade_id = p_grd_id;
808: --
809: begin
810: --
811: hr_utility.set_location('per_grades_pkg.old_date_to',1);
812: --
813: open c15;
814: --
815: fetch c15 into p_old_date;

Line 837: hr_utility.set_location('per_grades_pkg.chk_seq',1);

833: and (p_rwid is null or chartorowid(p_rwid) <> g.rowid);
834: --
835: begin
836: --
837: hr_utility.set_location('per_grades_pkg.chk_seq',1);
838: --
839: open c16;
840: --
841: fetch c16 into l_exists;

Line 843: hr_utility.set_message(801,'HR_7127_GRADE_DUP_SEQ');

839: open c16;
840: --
841: fetch c16 into l_exists;
842: IF c16%found THEN
843: hr_utility.set_message(801,'HR_7127_GRADE_DUP_SEQ');
844: close c16;
845: hr_utility.raise_error;
846: END IF;
847: --

Line 845: hr_utility.raise_error;

841: fetch c16 into l_exists;
842: IF c16%found THEN
843: hr_utility.set_message(801,'HR_7127_GRADE_DUP_SEQ');
844: close c16;
845: hr_utility.raise_error;
846: END IF;
847: --
848: close c16;
849: --

Line 868: hr_utility.set_location('per_grades_pkg.chk_date_from', 1);

864: and p.effective_start_date < nvl(p_date_from, hr_api.g_sot);
865: --
866: begin
867: --
868: hr_utility.set_location('per_grades_pkg.chk_date_from', 1);
869: --
870: open chk_grd_dt_from;
871: fetch chk_grd_dt_from into l_exists;
872: IF chk_grd_dt_from%found THEN

Line 873: hr_utility.set_message(800, 'PER_289567_GRADE_DATE_FROM');

869: --
870: open chk_grd_dt_from;
871: fetch chk_grd_dt_from into l_exists;
872: IF chk_grd_dt_from%found THEN
873: hr_utility.set_message(800, 'PER_289567_GRADE_DATE_FROM');
874: close chk_grd_dt_from;
875: hr_utility.raise_error;
876: END IF;
877: --

Line 875: hr_utility.raise_error;

871: fetch chk_grd_dt_from into l_exists;
872: IF chk_grd_dt_from%found THEN
873: hr_utility.set_message(800, 'PER_289567_GRADE_DATE_FROM');
874: close chk_grd_dt_from;
875: hr_utility.raise_error;
876: END IF;
877: --
878: close chk_grd_dt_from;
879: --

Line 905: hr_utility.set_location('per_grades_pkg.chk_end_date', 1);

901:
902: --
903: begin
904: --
905: hr_utility.set_location('per_grades_pkg.chk_end_date', 1);
906: --
907: open chk_grd_dt_to;
908: fetch chk_grd_dt_to into l_exists;
909: IF chk_grd_dt_to%found THEN

Line 910: hr_utility.set_message(800, 'PER_289568_GRADE_DATE_TO');

906: --
907: open chk_grd_dt_to;
908: fetch chk_grd_dt_to into l_exists;
909: IF chk_grd_dt_to%found THEN
910: hr_utility.set_message(800, 'PER_289568_GRADE_DATE_TO');
911: close chk_grd_dt_to;
912: hr_utility.raise_error;
913: END IF;
914: --

Line 912: hr_utility.raise_error;

908: fetch chk_grd_dt_to into l_exists;
909: IF chk_grd_dt_to%found THEN
910: hr_utility.set_message(800, 'PER_289568_GRADE_DATE_TO');
911: close chk_grd_dt_to;
912: hr_utility.raise_error;
913: END IF;
914: --
915: close chk_grd_dt_to;
916: --

Line 922: hr_utility.set_message(800, 'PER_449143_GRADE_SCALE_DATE_TO');

918: -- code to check whether grade scale exist.
919: open chk_grade_scale;
920: fetch chk_grade_scale into l_exists;
921: if chk_grade_scale%found then
922: hr_utility.set_message(800, 'PER_449143_GRADE_SCALE_DATE_TO');
923: close chk_grade_scale;
924: hr_utility.raise_error;
925: end if;
926: close chk_grade_scale;

Line 924: hr_utility.raise_error;

920: fetch chk_grade_scale into l_exists;
921: if chk_grade_scale%found then
922: hr_utility.set_message(800, 'PER_449143_GRADE_SCALE_DATE_TO');
923: close chk_grade_scale;
924: hr_utility.raise_error;
925: end if;
926: close chk_grade_scale;
927: --
928: -- bug fix 3360504 ends here