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

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

30: l_object_version_number number := p_object_version_number;
31: --
32: begin
33: --
34: hr_utility.set_location('Entering : '||l_proc, 10);
35: --
36: if p_row is not null then
37: --
38: hr_utility.set_location(l_proc||' lock date track pos table call '||p_object_version_number, 20);

Line 38: hr_utility.set_location(l_proc||' lock date track pos table call '||p_object_version_number, 20);

34: hr_utility.set_location('Entering : '||l_proc, 10);
35: --
36: if p_row is not null then
37: --
38: hr_utility.set_location(l_proc||' lock date track pos table call '||p_object_version_number, 20);
39: --
40: hr_psf_shd.lck(p_effective_date => p_effective_date
41: , p_datetrack_mode => 'CORRECTION'
42: , p_position_id => p_position_id

Line 47: hr_utility.set_location(l_proc||' updt date track pos table call ', 20);

43: , p_object_version_number => p_object_version_number
44: , p_validation_start_date => l_validation_start_date
45: , p_validation_end_date => l_validation_end_date );
46: --
47: hr_utility.set_location(l_proc||' updt date track pos table call ', 20);
48: --
49: hr_psf_upd.upd(p_position_id => p_position_id
50: , p_effective_start_date => l_effective_start_date
51: , p_effective_end_date => l_effective_end_date

Line 58: hr_utility.set_location(l_proc||' after upd date track pos ovn: '||p_object_version_number,20);

54: , p_effective_date => p_effective_date
55: , p_date_effective => p_date_effective
56: , p_datetrack_mode => 'CORRECTION');
57: --
58: hr_utility.set_location(l_proc||' after upd date track pos ovn: '||p_object_version_number,20);
59: --
60: else
61: --
62: hr_utility.set_location(l_proc, 30);

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

58: hr_utility.set_location(l_proc||' after upd date track pos ovn: '||p_object_version_number,20);
59: --
60: else
61: --
62: hr_utility.set_location(l_proc, 30);
63: --
64: rollback to refresh;
65: end if;
66: --

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

63: --
64: rollback to refresh;
65: end if;
66: --
67: hr_utility.set_location(l_proc, 40);
68: --
69: exception
70: when others then
71: p_object_version_number := l_object_version_number;

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

68: --
69: exception
70: when others then
71: p_object_version_number := l_object_version_number;
72: hr_utility.set_location(l_proc, 50);
73: raise;
74: end set_copied_flag;
75: --
76: -- ----------------------------------------------------------------------------

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

91: from per_all_positions
92: where position_id = p_position_id;
93: begin
94: --
95: hr_utility.set_location('Entering : '||l_proc, 10);
96: --
97: open c_ovn(p_position_id);
98: fetch c_ovn into p_object_version_number;
99: --

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

107: --
108: exception
109: when others then
110: p_object_version_number := l_object_version_number;
111: hr_utility.set_location(l_proc, 20);
112: raise;
113: end check_position_table;
114: -- ----------------------------------------------------------------------------
115: -- |------------------------< refresh_all_position >------------------------|

Line 128: hr_utility.set_location('Entering:'||g_package||'refresh_all_position', 5);

124: l_object_version_number number := '';
125: begin
126: -- calling the refresh_position with position_id.
127: --
128: hr_utility.set_location('Entering:'||g_package||'refresh_all_position', 5);
129: --
130: refresh_position ( p_refresh_date => p_refresh_date
131: , p_position_id => l_position_id
132: , p_effective_date => l_effective_date

Line 137: hr_utility.set_location('Leaving:'||g_package||'refresh_all_position', 500);

133: , p_object_version_number => l_object_version_number
134: , errbuf => errbuf
135: , retcode => retcode );
136: --
137: hr_utility.set_location('Leaving:'||g_package||'refresh_all_position', 500);
138: --
139: end refresh_all_position;
140: --
141: -- ----------------------------------------------------------------------------

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

459: rec c_pos%rowtype;
460: ---
461: BEGIN
462: --
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: per_refresh_position.refreshing_position := true;
466: --
467: hr_utility.set_location(l_proc||' p_refresh_date ' || p_refresh_date, 5);

Line 467: hr_utility.set_location(l_proc||' p_refresh_date ' || p_refresh_date, 5);

463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: per_refresh_position.refreshing_position := true;
466: --
467: hr_utility.set_location(l_proc||' p_refresh_date ' || p_refresh_date, 5);
468: --
469: if p_position_id is not null then
470: open c_pos(p_position_id);
471: else

Line 490: hr_utility.set_location(l_proc||' POSITION ID ' || rec.position_id, 10);

486: -- (reset gl variable )
487: --
488: gl_pos_ovn := '' ;
489: --
490: hr_utility.set_location(l_proc||' POSITION ID ' || rec.position_id, 10);
491: --
492: if rec.position_id <> l_position_id then
493: --
494: l_rowid := rec.rowid ;

Line 500: hr_utility.set_location(l_proc||' Lock per_all_positions api call ', 20);

496: l_object_version_number := rec.object_version_number;
497: -- call per_all_positions api.
498: if (check_position_table(rec.position_id, l_object_version_number)) then
499: --
500: hr_utility.set_location(l_proc||' Lock per_all_positions api call ', 20);
501: --
502: begin
503: -- lock
504: if p_full_hr = 'N' or rec.effective_start_date <= p_refresh_date then

Line 509: hr_utility.set_location(l_proc||' upd per_all_positions api call ', 30);

505:
506: per_pos_shd.lck(p_position_id => rec.position_id
507: , p_object_version_number => l_object_version_number);
508: --
509: hr_utility.set_location(l_proc||' upd per_all_positions api call ', 30);
510: --
511: per_pos_upd.upd
512: (p_position_id => rec.position_id
513: ,p_successor_position_id => rec.successor_position_id

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

554: -- Store POS OVN in gl variable to help see the last pos ovn
555: --
556: gl_pos_ovn := l_object_version_number ;
557: --
558: hr_utility.set_location(l_proc, 60);
559: --
560: l_object_version_number := rec.object_version_number;
561: --
562: begin

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

580: end if;
581: --
582: end if; -- refresh only if the date is valid
583: --
584: hr_utility.set_location(l_proc, 40);
585: --
586: exception
587: when others then
588: if p_position_id is not null then

Line 595: hr_utility.set_location(' Exp:'||errbuf, 40);

591: l_rowid := null;
592: errbuf := 'U'||l_position_id||'-'||sqlerrm ;
593: retcode := 1 ;
594: --
595: hr_utility.set_location(' Exp:'||errbuf, 40);
596: --
597: end;
598: else
599: --

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

596: --
597: end;
598: else
599: --
600: hr_utility.set_location(l_proc, 50);
601: --
602: begin
603: --
604: hr_utility.set_location(l_proc||' insert per_all_positions api call ', 50);

Line 604: hr_utility.set_location(l_proc||' insert per_all_positions api call ', 50);

600: hr_utility.set_location(l_proc, 50);
601: --
602: begin
603: --
604: hr_utility.set_location(l_proc||' insert per_all_positions api call ', 50);
605: --
606: per_pos_ins.ins
607: (p_position_id => rec.position_id
608: ,p_business_group_id => rec.business_group_id

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

652: -- Store POS OVN in gl variable to help see the last pos ovn
653: --
654: gl_pos_ovn := l_object_version_number ;
655: --
656: hr_utility.set_location(l_proc, 65);
657: --
658: l_object_version_number := rec.object_version_number;
659: --
660: begin

Line 680: hr_utility.set_location(l_proc||' after ins per_all_positions ', 50);

676: if p_effective_date between rec.effective_start_date and rec.effective_end_date then
677: p_object_version_number := l_object_version_number;
678: end if;
679: --
680: hr_utility.set_location(l_proc||' after ins per_all_positions ', 50);
681: --
682: exception
683: when others then
684: hr_utility.set_location(l_proc||' When Others raised ', 50);

Line 684: hr_utility.set_location(l_proc||' When Others raised ', 50);

680: hr_utility.set_location(l_proc||' after ins per_all_positions ', 50);
681: --
682: exception
683: when others then
684: hr_utility.set_location(l_proc||' When Others raised ', 50);
685: if p_position_id is not null then
686: raise;
687: end if;
688: l_rowid := null;

Line 692: hr_utility.set_location(' Exp:'||errbuf, 50);

688: l_rowid := null;
689: errbuf := 'I'||l_position_id||'-'||sqlerrm ;
690: retcode := 1 ;
691: --
692: hr_utility.set_location(' Exp:'||errbuf, 50);
693: --
694: end;
695: end if; -- check_position_table(position_id)
696: end if; -- rec.position_id <> l_position_id

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

694: end;
695: end if; -- check_position_table(position_id)
696: end if; -- rec.position_id <> l_position_id
697: --
698: hr_utility.set_location(l_proc, 70);
699: --
700: if p_position_id is null then
701: commit;
702: end if;

Line 725: hr_utility.set_location(l_proc||' '||errbuf, 70);

721: raise;
722: end if;
723: errbuf := 'Oth '||l_position_id||sqlerrm ;
724: --
725: hr_utility.set_location(l_proc||' '||errbuf, 70);
726: --
727: retcode := 2 ;
728: END refresh_position;
729: --

Line 742: hr_utility.set_location('Entering:'||g_package||'refresh_position_purge', 600);

738: from per_all_positions p
739: where position_id = p_position_id
740: and position_id not in ( select position_id from hr_all_positions_f where position_id = p_position_id) ;
741: begin
742: hr_utility.set_location('Entering:'||g_package||'refresh_position_purge', 600);
743: for i in c_chk_pos loop
744: per_pos_del.del
745: ( p_position_id => p_position_id ,
746: p_object_version_number => i.object_version_number ,

Line 750: hr_utility.set_location('Leaving:'||g_package||'refresh_position_purge', 600);

746: p_object_version_number => i.object_version_number ,
747: p_validate => false );
748: --
749: end loop;
750: hr_utility.set_location('Leaving:'||g_package||'refresh_position_purge', 600);
751: end;
752: --
753: -- ----------------------------------------------------------------------------
754: -- |------------------------< refresh_single_position >------------------------|

Line 767: hr_utility.set_location('Entering:'||g_package||'refresh_single_position', 5);

763: l_retcode number;
764: begin
765: -- calling the refresh_position with position_id.
766: --
767: hr_utility.set_location('Entering:'||g_package||'refresh_single_position', 5);
768: --
769: if not (hr_position_api.full_hr) then
770: refresh_position ( p_refresh_date => p_refresh_date
771: , p_position_id => p_position_id

Line 797: hr_utility.set_location('Entering:'||g_package||'refresh_single_position', 500);

793: update per_all_positions
794: set date_end = hr_general.get_position_date_end(position_id)
795: where position_id = p_position_id;
796: --
797: hr_utility.set_location('Entering:'||g_package||'refresh_single_position', 500);
798: --
799: end refresh_single_position;
800: --
801: function get_position_ovn return number