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.HR_GRADE_SCALE_API dependencies on HR_UTILITY

Line 88: hr_utility.set_location('Entering:'|| l_proc, 10);

84: and psp.spinal_point_id = p_ceiling_point_id;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89: --
90: -- Issue a savepoint
91: --
92: savepoint create_grade_scale;

Line 94: hr_utility.set_location(l_proc, 20);

90: -- Issue a savepoint
91: --
92: savepoint create_grade_scale;
93:
94: hr_utility.set_location(l_proc, 20);
95:
96: --
97: -- Truncate the time portion from all IN date parameters
98: --

Line 127: hr_utility.set_location(l_proc, 30);

123: -- End of before hook process (create_grade_scale)
124: --
125: end;
126:
127: hr_utility.set_location(l_proc, 30);
128: --
129: -- Process Logic
130: --
131: l_ceiling_step_id := null;

Line 152: hr_utility.set_location(l_proc, 40);

148: ,p_effective_start_date => l_effective_start_date
149: ,p_effective_end_date => l_effective_end_date
150: );
151: --
152: hr_utility.set_location(l_proc, 40);
153: --
154: -- We need to create the Grade Step (Ceiling Step), if the
155: -- parameter p_ceiling_point_id is passed with a value
156: --

Line 177: hr_utility.set_location(l_proc, 60);

173: ,p_effective_end_date => l_effective_end_date
174: ,p_object_version_number => lv_object_version_number
175: );
176: --
177: hr_utility.set_location(l_proc, 60);
178: --
179: -- Update ceiling_step_id in per_grade_spines_f
180: --
181: per_pgs_upd.upd

Line 191: hr_utility.set_location(l_proc, 70);

187: ,p_effective_start_date => l_effective_start_date
188: ,p_effective_end_date => l_effective_end_date
189: );
190: --
191: hr_utility.set_location(l_proc, 70);
192: --
193: end if;
194: --
195: -- Call After Process hook for create_grade_scale

Line 232: hr_utility.set_location(l_proc, 80);

228: then
229: raise hr_api.validate_enabled;
230: end if;
231: --
232: hr_utility.set_location(l_proc, 80);
233: --
234: -- Set OUT parameters
235: --
236: p_grade_spine_id := l_grade_spine_id;

Line 242: hr_utility.set_location(' Leaving:' ||l_proc, 90);

238: p_object_version_number := l_object_version_number;
239: p_effective_start_date := l_effective_start_date;
240: p_effective_end_date := l_effective_end_date;
241: --
242: hr_utility.set_location(' Leaving:' ||l_proc, 90);
243: --
244: exception
245: --
246: when hr_api.validate_enabled then

Line 264: hr_utility.set_location(' Leaving:'||l_proc, 100);

260: p_object_version_number := null;
261: p_effective_start_date := null;
262: p_effective_end_date := null;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 100);
265: --
266: when others then
267: --
268: -- A validation or unexpected error has occurred

Line 272: hr_utility.set_location(' Leaving:'||l_proc, 110);

268: -- A validation or unexpected error has occurred
269: --
270: ROLLBACK TO create_grade_scale;
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 110);
273: --
274: p_grade_spine_id := null;
275: p_ceiling_step_id := null;
276: p_object_version_number := null;

Line 324: hr_utility.set_location('Entering:'|| l_proc, 10);

320:
321: --
322: begin
323: --
324: hr_utility.set_location('Entering:'|| l_proc, 10);
325: --
326: lv_object_version_number := p_object_version_number;
327:
328: --

Line 333: hr_utility.set_location(l_proc, 20);

329: -- Issue a savepoint
330: --
331: savepoint update_grade_scale;
332:
333: hr_utility.set_location(l_proc, 20);
334:
335: --
336: -- Truncate the time portion from all IN date parameters
337: --

Line 374: hr_utility.set_location(l_proc, 30);

370: -- End of before hook process (update_grade_scale)
371: --
372: end;
373:
374: hr_utility.set_location(l_proc, 30);
375: --
376: -- Process Logic
377: --
378:

Line 408: hr_utility.set_location(l_proc, 40);

404: -- Assign the out parameters.
405: --
406: p_object_version_number := l_object_version_number;
407:
408: hr_utility.set_location(l_proc, 40);
409:
410: --
411: --
412: -- Call After Process hook for update_grade_scale

Line 450: hr_utility.set_location(l_proc, 50);

446: then
447: raise hr_api.validate_enabled;
448: end if;
449: --
450: hr_utility.set_location(l_proc, 50);
451: --
452: -- Set OUT parameters
453: --
454: p_object_version_number := l_object_version_number;

Line 458: hr_utility.set_location(' Leaving:' ||l_proc, 60);

454: p_object_version_number := l_object_version_number;
455: p_effective_start_date := l_effective_start_date;
456: p_effective_end_date := l_effective_end_date;
457: --
458: hr_utility.set_location(' Leaving:' ||l_proc, 60);
459: --
460: exception
461: --
462: when hr_api.validate_enabled then

Line 476: hr_utility.set_location(' Leaving:'||l_proc, 70);

472: -- when validation only mode is being used.)
473: --
474: p_object_version_number := p_object_version_number;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 70);
477: --
478: when others then
479: --
480: -- A validation or unexpected error has occurred

Line 488: hr_utility.set_location(' Leaving:'||l_proc, 80);

484: p_object_version_number := lv_object_version_number;
485: p_effective_start_date := null;
486: p_effective_end_date := null;
487: --
488: hr_utility.set_location(' Leaving:'||l_proc, 80);
489: --
490: raise;
491: --
492: end update_grade_scale;

Line 566: hr_utility.set_location('Entering:'|| l_proc, 10);

562: l_exists VARCHAR2(1);
563: --
564: BEGIN
565: --
566: hr_utility.set_location('Entering:'|| l_proc, 10);
567: hr_utility.set_location('Datetrack mode: '||p_datetrack_mode, 15);
568: --
569: l_date := p_effective_date;
570: --

Line 567: hr_utility.set_location('Datetrack mode: '||p_datetrack_mode, 15);

563: --
564: BEGIN
565: --
566: hr_utility.set_location('Entering:'|| l_proc, 10);
567: hr_utility.set_location('Datetrack mode: '||p_datetrack_mode, 15);
568: --
569: l_date := p_effective_date;
570: --
571: -- Check if the steps are used in assignments or placements or positions.

Line 587: hr_utility.set_location(l_proc, 20);

583: if p_datetrack_mode = hr_api.g_delete then
584: l_date := p_effective_date;
585: end if;
586: --
587: hr_utility.set_location(l_proc, 20);
588: --
589: open csr_chk_placements(l_date);
590: fetch csr_chk_placements into l_exists;
591: IF csr_chk_placements%found THEN

Line 593: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');

589: open csr_chk_placements(l_date);
590: fetch csr_chk_placements into l_exists;
591: IF csr_chk_placements%found THEN
592: close csr_chk_placements;
593: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');
594: hr_utility.raise_error;
595: END IF;
596: close csr_chk_placements;
597: --

Line 594: hr_utility.raise_error;

590: fetch csr_chk_placements into l_exists;
591: IF csr_chk_placements%found THEN
592: close csr_chk_placements;
593: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');
594: hr_utility.raise_error;
595: END IF;
596: close csr_chk_placements;
597: --
598: hr_utility.set_location(l_proc, 30);

Line 598: hr_utility.set_location(l_proc, 30);

594: hr_utility.raise_error;
595: END IF;
596: close csr_chk_placements;
597: --
598: hr_utility.set_location(l_proc, 30);
599: --
600: open csr_chk_assignments(l_date);
601: fetch csr_chk_assignments into l_exists;
602: IF csr_chk_assignments%found THEN

Line 604: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');

600: open csr_chk_assignments(l_date);
601: fetch csr_chk_assignments into l_exists;
602: IF csr_chk_assignments%found THEN
603: close csr_chk_assignments;
604: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');
605: hr_utility.raise_error;
606: END IF;
607: close csr_chk_assignments;
608: --

Line 605: hr_utility.raise_error;

601: fetch csr_chk_assignments into l_exists;
602: IF csr_chk_assignments%found THEN
603: close csr_chk_assignments;
604: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');
605: hr_utility.raise_error;
606: END IF;
607: close csr_chk_assignments;
608: --
609: hr_utility.set_location(l_proc, 40);

Line 609: hr_utility.set_location(l_proc, 40);

605: hr_utility.raise_error;
606: END IF;
607: close csr_chk_assignments;
608: --
609: hr_utility.set_location(l_proc, 40);
610: --
611: open csr_chk_positions(l_date);
612: fetch csr_chk_positions into l_exists;
613: IF csr_chk_positions%found THEN

Line 615: hr_utility.set_message(800, 'PER_449137_DEL_GRDSPN_POS');

611: open csr_chk_positions(l_date);
612: fetch csr_chk_positions into l_exists;
613: IF csr_chk_positions%found THEN
614: close csr_chk_positions;
615: hr_utility.set_message(800, 'PER_449137_DEL_GRDSPN_POS');
616: hr_utility.raise_error;
617: END IF;
618: close csr_chk_positions;
619: --

Line 616: hr_utility.raise_error;

612: fetch csr_chk_positions into l_exists;
613: IF csr_chk_positions%found THEN
614: close csr_chk_positions;
615: hr_utility.set_message(800, 'PER_449137_DEL_GRDSPN_POS');
616: hr_utility.raise_error;
617: END IF;
618: close csr_chk_positions;
619: --
620: hr_utility.set_location(l_proc, 50);

Line 620: hr_utility.set_location(l_proc, 50);

616: hr_utility.raise_error;
617: END IF;
618: close csr_chk_positions;
619: --
620: hr_utility.set_location(l_proc, 50);
621: --
622: -- Delete all the child step records before deleting the Grade Scale.
623: --
624: FOR grade_step_rec in csr_grade_steps LOOP

Line 631: hr_utility.set_location(l_proc, 60);

627: --
628: l_effective_date := trunc(p_effective_date);
629: l_datetrack_mode := p_datetrack_mode;
630: --
631: hr_utility.set_location(l_proc, 60);
632: IF grade_step_rec.min_eff_start_date > p_effective_date AND
633: p_datetrack_mode = hr_api.g_delete THEN
634: --
635: -- ZAP the step using min effective_start_date as effective_date.

Line 637: hr_utility.set_location(l_proc, 70);

633: p_datetrack_mode = hr_api.g_delete THEN
634: --
635: -- ZAP the step using min effective_start_date as effective_date.
636: --
637: hr_utility.set_location(l_proc, 70);
638: l_effective_date := grade_step_rec.min_eff_start_date;
639: l_datetrack_mode := hr_api.g_zap;
640: --
641: ELSIF grade_step_rec.min_eff_start_date > p_effective_date AND

Line 646: hr_utility.set_location(l_proc, 80);

642: p_datetrack_mode = hr_api.g_zap THEN
643: --
644: -- To ZAP the step, use the min effective_start_date as effective_date.
645: --
646: hr_utility.set_location(l_proc, 80);
647: l_effective_date := grade_step_rec.min_eff_start_date;
648: --
649: ELSIF grade_step_rec.max_eff_end_date <= p_effective_date AND
650: p_datetrack_mode = hr_api.g_zap THEN

Line 654: hr_utility.set_location(l_proc, 90);

650: p_datetrack_mode = hr_api.g_zap THEN
651: --
652: -- To ZAp the step, use the min effective_start_date as effective_date.
653: --
654: hr_utility.set_location(l_proc, 90);
655: l_effective_date := grade_step_rec.min_eff_start_date;
656: --
657: END IF;
658: --

Line 659: hr_utility.set_location('l_effective_date: '||l_effective_date, 100);

655: l_effective_date := grade_step_rec.min_eff_start_date;
656: --
657: END IF;
658: --
659: hr_utility.set_location('l_effective_date: '||l_effective_date, 100);
660: hr_utility.set_location('l_datetrack_mode'||l_datetrack_mode, 100);
661: --
662: IF not (grade_step_rec.max_eff_end_date <= p_effective_date AND
663: p_datetrack_mode = hr_api.g_delete) THEN

Line 660: hr_utility.set_location('l_datetrack_mode'||l_datetrack_mode, 100);

656: --
657: END IF;
658: --
659: hr_utility.set_location('l_effective_date: '||l_effective_date, 100);
660: hr_utility.set_location('l_datetrack_mode'||l_datetrack_mode, 100);
661: --
662: IF not (grade_step_rec.max_eff_end_date <= p_effective_date AND
663: p_datetrack_mode = hr_api.g_delete) THEN
664: --

Line 667: hr_utility.set_location(l_proc, 110);

663: p_datetrack_mode = hr_api.g_delete) THEN
664: --
665: -- Get the step details.
666: --
667: hr_utility.set_location(l_proc, 110);
668: open csr_step_details(grade_step_rec.step_id,l_effective_date);
669: fetch csr_step_details into l_object_version_number;
670: close csr_step_details;
671: --

Line 672: hr_utility.set_location(l_datetrack_mode||' step: '||to_char(grade_step_rec.step_id), 120);

668: open csr_step_details(grade_step_rec.step_id,l_effective_date);
669: fetch csr_step_details into l_object_version_number;
670: close csr_step_details;
671: --
672: hr_utility.set_location(l_datetrack_mode||' step: '||to_char(grade_step_rec.step_id), 120);
673: --
674: BEGIN
675: hr_grade_step_api.delete_grade_step(
676: p_validate => p_validate

Line 685: hr_utility.set_location(l_proc, 130);

681: ,p_Effective_End_Date => l_effective_end_date
682: ,p_object_version_number => l_object_version_number
683: ,p_called_from_del_grd_scale => TRUE --bug 4096238
684: );
685: hr_utility.set_location(l_proc, 130);
686: EXCEPTION
687: when others then
688: hr_utility.set_location(l_proc, 140);
689: raise;

Line 688: hr_utility.set_location(l_proc, 140);

684: );
685: hr_utility.set_location(l_proc, 130);
686: EXCEPTION
687: when others then
688: hr_utility.set_location(l_proc, 140);
689: raise;
690: END;
691: END IF;
692: --

Line 693: hr_utility.set_location(l_proc, 150);

689: raise;
690: END;
691: END IF;
692: --
693: hr_utility.set_location(l_proc, 150);
694: END LOOP;
695: hr_utility.set_location('Leaving :'||l_proc, 160);
696: --
697: END;

Line 695: hr_utility.set_location('Leaving :'||l_proc, 160);

691: END IF;
692: --
693: hr_utility.set_location(l_proc, 150);
694: END LOOP;
695: hr_utility.set_location('Leaving :'||l_proc, 160);
696: --
697: END;
698: --
699: -- Fix for bug 3472194 ends here.

Line 734: hr_utility.set_location('Entering:'|| l_proc, 10);

730: l_effective_start_date per_grade_spines_f.effective_start_date%TYPE;
731: l_effective_end_date per_grade_spines_f.effective_end_date%TYPE;
732: --
733: begin
734: hr_utility.set_location('Entering:'|| l_proc, 10);
735:
736: l_effective_date := trunc(p_effective_date);
737: lv_object_version_number := p_object_version_number;
738:

Line 764: hr_utility.set_location(l_proc, 20);

760: ,p_hook_type => 'BP'
761: );
762: end;
763:
764: hr_utility.set_location(l_proc, 20);
765:
766: --
767: -- Process Logic
768: --

Line 773: hr_utility.set_location(l_proc, 25);

769: -- Fix for bug 3472194 starts here.
770: -- Delete the child grade steps before deleting the grade scale.
771: --
772: IF p_datetrack_mode in (hr_api.g_delete, hr_api.g_zap) THEN
773: hr_utility.set_location(l_proc, 25);
774: delete_child_grade_steps
775: (p_validate => p_validate
776: ,p_effective_date => l_effective_date
777: ,p_datetrack_mode => p_datetrack_mode

Line 793: hr_utility.set_location(l_proc, 30);

789: ,p_effective_start_date => l_effective_start_date
790: ,p_effective_end_date => l_effective_end_date
791: );
792:
793: hr_utility.set_location(l_proc, 30);
794:
795: --
796: -- Call After Process User Hook
797: --

Line 815: hr_utility.set_location(l_proc, 40);

811: ,p_hook_type => 'AP'
812: );
813: end;
814:
815: hr_utility.set_location(l_proc, 40);
816:
817: p_object_version_number := l_object_version_number;
818: --
819: -- When in validation only mode raise the Validate_Enabled exception

Line 830: hr_utility.set_location(' Leaving:'||l_proc, 100);

826: -- Set all output arguments (returned by some dt modes only)
827: --
828: p_object_version_number := l_object_version_number;
829:
830: hr_utility.set_location(' Leaving:'||l_proc, 100);
831: exception
832: when hr_api.validate_enabled then
833: hr_utility.set_location(' Leaving...:'||l_proc, 50);
834: --

Line 833: hr_utility.set_location(' Leaving...:'||l_proc, 50);

829:
830: hr_utility.set_location(' Leaving:'||l_proc, 100);
831: exception
832: when hr_api.validate_enabled then
833: hr_utility.set_location(' Leaving...:'||l_proc, 50);
834: --
835: -- As the Validate_Enabled exception has been raised
836: -- we must rollback to the savepoint
837: --

Line 849: hr_utility.set_location(' Leaving...:'||l_proc, 60);

845: p_effective_end_date := null;
846: p_object_version_number := null;
847: --
848: when others then
849: hr_utility.set_location(' Leaving...:'||l_proc, 60);
850: --
851: -- A validation or unexpected error has occured
852: --
853: rollback to delete_grade_scale;