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

Line 60: hr_utility.set_location('Entering:'|| l_proc, 5);

56: l_rating_scale_id per_rating_scales.rating_scale_id%TYPE;
57: l_object_version_number per_rating_scales.object_version_number%TYPE;
58: l_language_code per_rating_scales_tl.language%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --
62: -- Issue a savepoint.
63: --
64: savepoint create_rating_scale;

Line 65: hr_utility.set_location(l_proc, 6);

61: --
62: -- Issue a savepoint.
63: --
64: savepoint create_rating_scale;
65: hr_utility.set_location(l_proc, 6);
66: l_language_code := p_language_code;
67: hr_api.validate_language_code(p_language_code => l_language_code);
68: --
69: -- ngundura global rating scales cannot be created if Cross business

Line 121: hr_utility.set_location(l_proc, 7);

117: -- End of Before Process User Hook call
118: --
119: -- Validation in addition to Table Handlers
120: --
121: hr_utility.set_location(l_proc, 7);
122: --
123: -- Process Logic
124: --
125: per_rsc_ins.ins

Line 167: hr_utility.set_location(l_proc, 8);

163: ,p_rating_scale_id => l_rating_scale_id
164: ,p_name => p_name
165: ,p_description => p_description
166: );
167: hr_utility.set_location(l_proc, 8);
168: --
169: -- Call After Process User Hook
170: --
171: begin

Line 225: hr_utility.set_location(' Leaving:'||l_proc, 11);

221: --
222: p_rating_scale_id := l_rating_scale_id;
223: p_object_version_number := l_object_version_number;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 11);
226: exception
227: when hr_api.validate_enabled then
228: --
229: -- As the Validate_Enabled exception has been raised

Line 254: hr_utility.set_location(' Leaving:'||l_proc, 12);

250: raise;
251: --
252: -- End of fix.
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 12);
255: end create_rating_scale;
256: --
257: --
258: --

Line 306: hr_utility.set_location('Entering:'|| l_proc, 5);

302: l_object_version_number per_rating_scales.object_version_number%TYPE;
303: l_language_code per_rating_scales_tl.language%TYPE;
304: l_temp_ovn number := p_object_version_number;
305: begin
306: hr_utility.set_location('Entering:'|| l_proc, 5);
307: --
308: -- Issue a savepoint.
309: --
310: savepoint update_rating_scale;

Line 313: hr_utility.set_location(l_proc, 6);

309: --
310: savepoint update_rating_scale;
311: l_language_code := p_language_code;
312: hr_api.validate_language_code(p_language_code => l_language_code);
313: hr_utility.set_location(l_proc, 6);
314: --
315: -- Call Before Process User Hook
316: --
317: begin

Line 360: hr_utility.set_location(l_proc, 7);

356: -- End of Before Process User Hook call
357: --
358: -- Validation in addition to Table Handlers
359: --
360: hr_utility.set_location(l_proc, 7);
361: --
362: -- Process Logic
363: --
364: --

Line 405: hr_utility.set_location(l_proc, 8);

401: ,p_rating_scale_id => p_rating_scale_id
402: ,p_name => p_name
403: ,p_description => p_description
404: );
405: hr_utility.set_location(l_proc, 8);
406: --
407: -- Call After Process User Hook
408: --
409: begin

Line 462: hr_utility.set_location(' Leaving:'||l_proc, 11);

458: --
459: --
460: p_object_version_number := l_object_version_number;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 11);
463: exception
464: when hr_api.validate_enabled then
465: --
466: -- As the Validate_Enabled exception has been raised

Line 490: hr_utility.set_location(' Leaving:'||l_proc, 12);

486: raise;
487: --
488: -- End of fix.
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 12);
491: --
492: end update_rating_scale;
493: --
494: --

Line 517: hr_utility.set_location('Entering:'|| l_proc, 5);

513: --
514: --
515: l_proc varchar2(72) := g_package||'delete_rating_scale';
516: begin
517: hr_utility.set_location('Entering:'|| l_proc, 5);
518: --
519: -- Issue a savepoint.
520: --
521: savepoint delete_rating_scale;

Line 522: hr_utility.set_location(l_proc, 6);

518: --
519: -- Issue a savepoint.
520: --
521: savepoint delete_rating_scale;
522: hr_utility.set_location(l_proc, 6);
523: --
524: -- Call Before Process User Hook
525: --
526: begin

Line 544: hr_utility.set_location(l_proc, 7);

540: -- End of Before Process User hook
541: --
542: -- Validation in addition to Table Handlers
543: --
544: hr_utility.set_location(l_proc, 7);
545: --
546: -- Process Logic
547: --
548: --

Line 572: hr_utility.set_location(l_proc, 8);

568: ,p_rating_scale_id => p_rating_scale_id
569: ,p_object_version_number => p_object_version_number
570: );
571: --
572: hr_utility.set_location(l_proc, 8);
573: --
574: -- Call After Process User Hook
575: --
576: begin

Line 597: hr_utility.set_location(' Leaving:'||l_proc, 11);

593: if p_validate then
594: raise hr_api.validate_enabled;
595: end if;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 11);
598: exception
599: when hr_api.validate_enabled then
600: --
601: -- As the Validate_Enabled exception has been raised

Line 618: hr_utility.set_location(' Leaving:'||l_proc, 12);

614: raise;
615: --
616: -- End of fix.
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 12);
619: end delete_rating_scale;
620: --
621: -- ----------------------------------------------------------------------------
622: -- |-------------------< >---------------------|

Line 681: hr_utility.set_message(800, 'HR_449156_LOOK_MEANING_INVALID');

677: open Sel_Id;
678: fetch Sel_Id Into l_lookup_code;
679: if Sel_Id%notfound then
680: close Sel_Id;
681: hr_utility.set_message(800, 'HR_449156_LOOK_MEANING_INVALID');
682: fnd_message.set_token('MEANING',p_meaning);
683: hr_utility.raise_error;
684: end if;
685: close Sel_Id;

Line 683: hr_utility.raise_error;

679: if Sel_Id%notfound then
680: close Sel_Id;
681: hr_utility.set_message(800, 'HR_449156_LOOK_MEANING_INVALID');
682: fnd_message.set_token('MEANING',p_meaning);
683: hr_utility.raise_error;
684: end if;
685: close Sel_Id;
686: --
687: return (l_lookup_code);

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

687: return (l_lookup_code);
688: end;
689: begin
690:
691: hr_utility.set_location('Entering... ' || l_proc,10);
692: --
693: -- Issue a savepoint.
694: --
695: savepoint create_or_update_rating_scale;

Line 712: hr_utility.trace('p_effective_date : ' || p_effective_date);

708: l_effective_date := trunc(sysdate);
709: else
710: l_effective_date := trunc(p_effective_date);
711: end if;
712: hr_utility.trace('p_effective_date : ' || p_effective_date);
713:
714: IF ( p_translated_language IS NULL AND p_source_rating_scale_name IS NULL )
715: THEN
716: hr_utility.set_location(l_proc,20);

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

712: hr_utility.trace('p_effective_date : ' || p_effective_date);
713:
714: IF ( p_translated_language IS NULL AND p_source_rating_scale_name IS NULL )
715: THEN
716: hr_utility.set_location(l_proc,20);
717:
718: open csr_rs(p_name);
719: fetch csr_rs into l_rating_scale_id,l_ovn;
720: if csr_rs%NOTFOUND then

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

718: open csr_rs(p_name);
719: fetch csr_rs into l_rating_scale_id,l_ovn;
720: if csr_rs%NOTFOUND then
721: close csr_rs;
722: hr_utility.set_location(l_proc,30);
723: l_rating_scale_id := NULL;
724: l_ovn := NULL;
725: else
726: close csr_rs;

Line 728: hr_utility.trace('l_reating_scale_id : ' || l_rating_scale_id);

724: l_ovn := NULL;
725: else
726: close csr_rs;
727: end if;
728: hr_utility.trace('l_reating_scale_id : ' || l_rating_scale_id);
729: hr_utility.trace('l_ovn : ' || l_ovn);
730:
731: --
732: if (p_type is not null) then

Line 729: hr_utility.trace('l_ovn : ' || l_ovn);

725: else
726: close csr_rs;
727: end if;
728: hr_utility.trace('l_reating_scale_id : ' || l_rating_scale_id);
729: hr_utility.trace('l_ovn : ' || l_ovn);
730:
731: --
732: if (p_type is not null) then
733: l_type := return_lookup_code

Line 741: hr_utility.trace('l_type : ' || l_type);

737: );
738: else
739: l_type := 'PROFICIENCY';
740: end if;
741: hr_utility.trace('l_type : ' || l_type);
742: --
743: if (p_default_flag is not null) then
744: l_default_flag := return_lookup_code
745: (p_meaning => p_default_flag

Line 752: hr_utility.trace('l_default_flag : ' || l_default_flag);

748: );
749: else
750: l_default_flag := 'N';
751: end if;
752: hr_utility.trace('l_default_flag : ' || l_default_flag);
753:
754: --
755: if (l_rating_scale_id is null and l_ovn is null) then
756: hr_utility.set_location(l_proc,40);

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

752: hr_utility.trace('l_default_flag : ' || l_default_flag);
753:
754: --
755: if (l_rating_scale_id is null and l_ovn is null) then
756: hr_utility.set_location(l_proc,40);
757:
758: create_rating_scale
759: (p_language_code => l_language_code
760: ,p_validate => p_validate

Line 769: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);

765: ,p_description => p_description
766: ,p_rating_scale_id => l_rating_scale_id
767: ,p_object_version_number => l_ovn
768: );
769: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);
770: else
771: hr_utility.set_location(l_proc,50);
772:
773: update_rating_scale

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

767: ,p_object_version_number => l_ovn
768: );
769: hr_utility.trace('l_rating_scale_id : ' || l_rating_scale_id);
770: else
771: hr_utility.set_location(l_proc,50);
772:
773: update_rating_scale
774: (p_language_code => l_language_code
775: ,p_validate => p_validate

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

782: );
783: end if;
784: ELSE
785:
786: hr_utility.set_location(l_proc,60);
787: open csr_rs(p_source_rating_scale_name);
788: fetch csr_rs into l_source_rating_scale_id,l_source_ovn;
789: if csr_rs%NOTFOUND then
790: close csr_rs;

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

787: open csr_rs(p_source_rating_scale_name);
788: fetch csr_rs into l_source_rating_scale_id,l_source_ovn;
789: if csr_rs%NOTFOUND then
790: close csr_rs;
791: hr_utility.set_location(l_proc,70);
792: hr_utility.set_message(800, 'HR_449190_SOURCE_RSC_INVALID');
793: hr_utility.raise_error;
794: else
795: close csr_rs;

Line 792: hr_utility.set_message(800, 'HR_449190_SOURCE_RSC_INVALID');

788: fetch csr_rs into l_source_rating_scale_id,l_source_ovn;
789: if csr_rs%NOTFOUND then
790: close csr_rs;
791: hr_utility.set_location(l_proc,70);
792: hr_utility.set_message(800, 'HR_449190_SOURCE_RSC_INVALID');
793: hr_utility.raise_error;
794: else
795: close csr_rs;
796: end if;

Line 793: hr_utility.raise_error;

789: if csr_rs%NOTFOUND then
790: close csr_rs;
791: hr_utility.set_location(l_proc,70);
792: hr_utility.set_message(800, 'HR_449190_SOURCE_RSC_INVALID');
793: hr_utility.raise_error;
794: else
795: close csr_rs;
796: end if;
797: hr_utility.trace('l_source_reating_scale_id : ' || l_source_rating_scale_id);

Line 797: hr_utility.trace('l_source_reating_scale_id : ' || l_source_rating_scale_id);

793: hr_utility.raise_error;
794: else
795: close csr_rs;
796: end if;
797: hr_utility.trace('l_source_reating_scale_id : ' || l_source_rating_scale_id);
798: hr_utility.trace('l_source_ovn : ' || l_source_ovn);
799:
800: l_translated_language := p_translated_language;
801: hr_api.validate_language_code(p_language_code => l_translated_language);

Line 798: hr_utility.trace('l_source_ovn : ' || l_source_ovn);

794: else
795: close csr_rs;
796: end if;
797: hr_utility.trace('l_source_reating_scale_id : ' || l_source_rating_scale_id);
798: hr_utility.trace('l_source_ovn : ' || l_source_ovn);
799:
800: l_translated_language := p_translated_language;
801: hr_api.validate_language_code(p_language_code => l_translated_language);
802:

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

802:
803: --
804: -- MLS update
805: --
806: hr_utility.set_location(l_proc,80);
807: per_rsl_upd.upd_tl
808: (p_language_code => l_translated_language
809: ,p_rating_scale_id => l_source_rating_scale_id
810: ,p_name => p_name

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

809: ,p_rating_scale_id => l_source_rating_scale_id
810: ,p_name => p_name
811: ,p_description => p_description
812: );
813: hr_utility.set_location(l_proc, 90);
814: --
815: -- Call After Process User Hook
816: --
817: begin

Line 859: hr_utility.set_location(l_proc,100);

855: end;
856: --
857: -- End After Process User Hook
858: --
859: hr_utility.set_location(l_proc,100);
860: END IF;
861:
862: hr_rating_scales_api.g_ignore_df := 'N';
863: hr_utility.set_location('Leaving ... ' || l_proc,110);

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

859: hr_utility.set_location(l_proc,100);
860: END IF;
861:
862: hr_rating_scales_api.g_ignore_df := 'N';
863: hr_utility.set_location('Leaving ... ' || l_proc,110);
864: exception
865: when hr_api.validate_enabled then
866: --
867: -- As the Validate_Enabled exception has been raised

Line 883: hr_utility.set_location(' Leaving:'||l_proc, 120);

879: ROLLBACK TO create_or_update_rating_scale;
880: hr_rating_scales_api.g_ignore_df := 'N';
881: raise;
882: --
883: hr_utility.set_location(' Leaving:'||l_proc, 120);
884: --
885: end create_or_update_rating_scale;
886: --
887: end hr_rating_scales_api;