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

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

31: ,p_effective_date IN VARCHAR2) IS
32: l_effective_date DATE;
33: l_proc VARCHAR2(80) := g_package||'main';
34: BEGIN
35: hr_utility.set_location('Entering : '||l_proc,10);
36: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
37: populate_plan_hierarchy(p_plan_id => p_plan_id
38: ,p_effective_date => l_effective_date);
39: hr_utility.set_location('Leaving : '||l_proc,10);

Line 39: hr_utility.set_location('Leaving : '||l_proc,10);

35: hr_utility.set_location('Entering : '||l_proc,10);
36: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
37: populate_plan_hierarchy(p_plan_id => p_plan_id
38: ,p_effective_date => l_effective_date);
39: hr_utility.set_location('Leaving : '||l_proc,10);
40: EXCEPTION
41: WHEN OTHERS THEN
42: fnd_file.put_line(fnd_file.log,Sqlerrm);
43: retcode := 2;

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

75: l_max_level NUMBER;
76: l_counter NUMBER;
77: l_proc VARCHAR2(80) := g_package||'insert_next_levels';
78: BEGIN
79: hr_utility.set_location('Entering:'||l_proc,10);
80: --
81:
82: --
83: FOR i in csr_directs(p_plan_id, p_supervisor_id)

Line 86: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);

82: --
83: FOR i in csr_directs(p_plan_id, p_supervisor_id)
84: LOOP
85: l_sup_level := p_sup_chain;
86: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);
87: hr_utility.trace('INSIDE insert_next_levels: '||p_level_num);
88: hr_utility.trace('Inserting directs for:'||i.supervisor_name);
89: hr_utility.trace('Inserting direct:'||i.employee_name);
90: INSERT INTO per_wpm_plan_hierarchy

Line 87: hr_utility.trace('INSIDE insert_next_levels: '||p_level_num);

83: FOR i in csr_directs(p_plan_id, p_supervisor_id)
84: LOOP
85: l_sup_level := p_sup_chain;
86: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);
87: hr_utility.trace('INSIDE insert_next_levels: '||p_level_num);
88: hr_utility.trace('Inserting directs for:'||i.supervisor_name);
89: hr_utility.trace('Inserting direct:'||i.employee_name);
90: INSERT INTO per_wpm_plan_hierarchy
91: (wpm_plan_hierarchy_id

Line 88: hr_utility.trace('Inserting directs for:'||i.supervisor_name);

84: LOOP
85: l_sup_level := p_sup_chain;
86: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);
87: hr_utility.trace('INSIDE insert_next_levels: '||p_level_num);
88: hr_utility.trace('Inserting directs for:'||i.supervisor_name);
89: hr_utility.trace('Inserting direct:'||i.employee_name);
90: INSERT INTO per_wpm_plan_hierarchy
91: (wpm_plan_hierarchy_id
92: ,plan_id

Line 89: hr_utility.trace('Inserting direct:'||i.employee_name);

85: l_sup_level := p_sup_chain;
86: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);
87: hr_utility.trace('INSIDE insert_next_levels: '||p_level_num);
88: hr_utility.trace('Inserting directs for:'||i.supervisor_name);
89: hr_utility.trace('Inserting direct:'||i.employee_name);
90: INSERT INTO per_wpm_plan_hierarchy
91: (wpm_plan_hierarchy_id
92: ,plan_id
93: ,employee_person_id

Line 109: hr_utility.trace('Looping for supervisors for :'||i.employee_name);

105: l_max_level := l_sup_level(l_sup_level.LAST).level_num;
106: l_counter := 0;
107: FOR j in l_sup_level.FIRST .. l_sup_level.LAST
108: LOOP
109: hr_utility.trace('Looping for supervisors for :'||i.employee_name);
110: hr_utility.trace('Supervisor:'||l_sup_level(j).supervisor_name);
111: hr_utility.trace('Supervisor level:'||((l_max_level - l_counter)+1));
112: INSERT INTO per_wpm_plan_hierarchy
113: (wpm_plan_hierarchy_id

Line 110: hr_utility.trace('Supervisor:'||l_sup_level(j).supervisor_name);

106: l_counter := 0;
107: FOR j in l_sup_level.FIRST .. l_sup_level.LAST
108: LOOP
109: hr_utility.trace('Looping for supervisors for :'||i.employee_name);
110: hr_utility.trace('Supervisor:'||l_sup_level(j).supervisor_name);
111: hr_utility.trace('Supervisor level:'||((l_max_level - l_counter)+1));
112: INSERT INTO per_wpm_plan_hierarchy
113: (wpm_plan_hierarchy_id
114: ,plan_id

Line 111: hr_utility.trace('Supervisor level:'||((l_max_level - l_counter)+1));

107: FOR j in l_sup_level.FIRST .. l_sup_level.LAST
108: LOOP
109: hr_utility.trace('Looping for supervisors for :'||i.employee_name);
110: hr_utility.trace('Supervisor:'||l_sup_level(j).supervisor_name);
111: hr_utility.trace('Supervisor level:'||((l_max_level - l_counter)+1));
112: INSERT INTO per_wpm_plan_hierarchy
113: (wpm_plan_hierarchy_id
114: ,plan_id
115: ,employee_person_id

Line 133: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);

129: l_last := NVL(l_sup_level.LAST,0);
130: l_sup_level(l_last+1).supervisor_id := i.supervisor_id;
131: l_sup_level(l_last+1).supervisor_name := i.supervisor_name;
132: l_sup_level(l_last+1).level_num := NVL(p_level_num,1)+1;
133: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);
134: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level(l_last+1).level_num);
135: insert_next_levels(p_plan_id, i.employee_id,l_sup_level, l_sup_level(l_last+1).level_num );
136: l_sup_level.DELETE;
137: END LOOP;

Line 134: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level(l_last+1).level_num);

130: l_sup_level(l_last+1).supervisor_id := i.supervisor_id;
131: l_sup_level(l_last+1).supervisor_name := i.supervisor_name;
132: l_sup_level(l_last+1).level_num := NVL(p_level_num,1)+1;
133: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level.count);
134: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level(l_last+1).level_num);
135: insert_next_levels(p_plan_id, i.employee_id,l_sup_level, l_sup_level(l_last+1).level_num );
136: l_sup_level.DELETE;
137: END LOOP;
138: hr_utility.set_location('Leaving:'||l_proc,100);

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

134: hr_utility.trace('INSIDE insert_next_levels: '||l_sup_level(l_last+1).level_num);
135: insert_next_levels(p_plan_id, i.employee_id,l_sup_level, l_sup_level(l_last+1).level_num );
136: l_sup_level.DELETE;
137: END LOOP;
138: hr_utility.set_location('Leaving:'||l_proc,100);
139: END insert_next_levels;
140: --
141: --
142: PROCEDURE build_hierarchy_for_sc(p_plan_id IN NUMBER,

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

318: l_sup_level t_sup_level;
319: l_proc VARCHAR2(80) := g_package||'populate_plan_hierarchy';
320: BEGIN
321: --
322: hr_utility.set_location('Entering:'||l_proc,10);
323: DELETE per_wpm_plan_hierarchy
324: WHERE plan_id = p_plan_id;
325: l_effective_date := NVL(p_effective_date,TRUNC(SYSDATE));
326: /* changed the logic using build_hierarchy_for_sc

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

348: END LOOP;
349: */
350: build_hierarchy_for_sc(p_plan_id => p_plan_id);
351: COMMIT;
352: hr_utility.set_location('Leaving:'||l_proc,100);
353: --
354: --
355: END populate_plan_hierarchy;
356: --

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

401: ,p_effective_date IN VARCHAR2) IS
402: l_proc VARCHAR2(80) := g_package||'populate_appraisal_summary_cp';
403: l_effective_date DATE;
404: BEGIN
405: hr_utility.set_location('Entering:'||l_proc,10);
406: l_effective_date := NVL(fnd_date.canonical_to_date(p_effective_date),TRUNC(SYSDATE));
407: populate_appraisal_summary(p_plan_id => p_plan_id
408: ,p_appraisal_period_id => p_appraisal_period_id
409: ,p_effective_date => l_effective_date);

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

406: l_effective_date := NVL(fnd_date.canonical_to_date(p_effective_date),TRUNC(SYSDATE));
407: populate_appraisal_summary(p_plan_id => p_plan_id
408: ,p_appraisal_period_id => p_appraisal_period_id
409: ,p_effective_date => l_effective_date);
410: hr_utility.set_location('Leaving:'||l_proc,100);
411: EXCEPTION
412: WHEN OTHERS THEN
413: fnd_file.put_line(fnd_file.log,Sqlerrm);
414: retcode := 2;

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

412: WHEN OTHERS THEN
413: fnd_file.put_line(fnd_file.log,Sqlerrm);
414: retcode := 2;
415: errbuf := SQLERRM;
416: hr_utility.set_location('Leaving:'||l_proc,110);
417: RAISE;
418: END populate_appraisal_summary_cp;
419: --
420: --

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

511: l_direct_unrated_count NUMBER(15);
512: --
513: BEGIN
514: --
515: hr_utility.set_location('Entering:'||l_proc,10);
516: FOR i IN g_rating_levels.FIRST .. LEAST(g_rating_levels.LAST,20)-- only upto 20 levels
517: LOOP
518: l_rating_summary(i).rating_level_id := g_rating_levels(i).rating_level_id;
519: l_rating_summary(i).rating_level_name := g_rating_levels(i).level_name;

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

729: ,l_rating_summary(20).total_count
730: ,l_direct_unrated_count
731: ,l_total_unrated_count);
732: --
733: hr_utility.set_location('Leaving:'||l_proc,100);
734: --
735: END compute_summary_for_supervisor;
736: --
737: --

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

764: , supervisor_name
765: FROM per_wpm_plan_hierarchy
766: WHERE plan_id = p_plan_id;
767: BEGIN
768: hr_utility.set_location('Entering:'||l_proc,10);
769: OPEN csr_appr_period_dtls(p_appraisal_period_id);
770: FETCH csr_appr_period_dtls INTO g_appr_period_rec;
771: IF csr_appr_period_dtls%NOTFOUND THEN
772: fnd_file.put_line(fnd_file.LOG,'Invalid Appraisal Period selected. Cannot Proceed.');

Line 788: hr_utility.trace('Computing totals for : '||i.supervisor_name);

784: FETCH csr_appr_levels BULK COLLECT INTO g_rating_levels;
785: CLOSE csr_appr_levels;
786: FOR i IN csr_plan_managers(p_plan_id)
787: LOOP
788: hr_utility.trace('Computing totals for : '||i.supervisor_name);
789: compute_summary_for_supervisor(p_plan_id => p_plan_id
790: ,p_effective_date => p_effective_date
791: ,p_supervisor_id => i.supervisor_person_id
792: ,p_supervisor_name => i.supervisor_name);

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

812: ,fnd_global.conc_request_id);
813: --
814: COMMIT;
815: --
816: hr_utility.set_location('Leaving:'||l_proc,100);
817: END populate_appraisal_summary;
818: --
819: --
820: FUNCTION get_summary_date(p_plan_id IN NUMBER