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 52: hr_utility.set_location ('Entering : ' || l_proc, 10);

48: IS
49: l_effective_date DATE;
50: l_proc VARCHAR2 (80) := g_package || 'main';
51: BEGIN
52: hr_utility.set_location ('Entering : ' || l_proc, 10);
53: l_effective_date := fnd_date.canonical_to_date (p_effective_date);
54: populate_plan_hierarchy (p_plan_id => p_plan_id, p_effective_date => l_effective_date);
55: hr_utility.set_location ('Leaving : ' || l_proc, 10);
56: EXCEPTION

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

51: BEGIN
52: hr_utility.set_location ('Entering : ' || l_proc, 10);
53: l_effective_date := fnd_date.canonical_to_date (p_effective_date);
54: populate_plan_hierarchy (p_plan_id => p_plan_id, p_effective_date => l_effective_date);
55: hr_utility.set_location ('Leaving : ' || l_proc, 10);
56: EXCEPTION
57: WHEN OTHERS
58: THEN
59: fnd_file.put_line (fnd_file.LOG, SQLERRM);

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

99: l_max_level NUMBER;
100: l_counter NUMBER;
101: l_proc VARCHAR2 (80) := g_package || 'insert_next_levels';
102: BEGIN
103: hr_utility.set_location ('Entering:' || l_proc, 10);
104:
105: --
106:
107: --

Line 111: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);

107: --
108: FOR i IN csr_directs (p_plan_id, p_supervisor_id)
109: LOOP
110: l_sup_level := p_sup_chain;
111: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);
112: hr_utility.TRACE ('INSIDE insert_next_levels: ' || p_level_num);
113: hr_utility.TRACE ('Inserting directs for:' || i.supervisor_name);
114: hr_utility.TRACE ('Inserting direct:' || i.employee_name);
115:

Line 112: hr_utility.TRACE ('INSIDE insert_next_levels: ' || p_level_num);

108: FOR i IN csr_directs (p_plan_id, p_supervisor_id)
109: LOOP
110: l_sup_level := p_sup_chain;
111: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);
112: hr_utility.TRACE ('INSIDE insert_next_levels: ' || p_level_num);
113: hr_utility.TRACE ('Inserting directs for:' || i.supervisor_name);
114: hr_utility.TRACE ('Inserting direct:' || i.employee_name);
115:
116: INSERT INTO per_wpm_plan_hierarchy

Line 113: hr_utility.TRACE ('Inserting directs for:' || i.supervisor_name);

109: LOOP
110: l_sup_level := p_sup_chain;
111: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);
112: hr_utility.TRACE ('INSIDE insert_next_levels: ' || p_level_num);
113: hr_utility.TRACE ('Inserting directs for:' || i.supervisor_name);
114: hr_utility.TRACE ('Inserting direct:' || i.employee_name);
115:
116: INSERT INTO per_wpm_plan_hierarchy
117: (wpm_plan_hierarchy_id,

Line 114: hr_utility.TRACE ('Inserting direct:' || i.employee_name);

110: l_sup_level := p_sup_chain;
111: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);
112: hr_utility.TRACE ('INSIDE insert_next_levels: ' || p_level_num);
113: hr_utility.TRACE ('Inserting directs for:' || i.supervisor_name);
114: hr_utility.TRACE ('Inserting direct:' || i.employee_name);
115:
116: INSERT INTO per_wpm_plan_hierarchy
117: (wpm_plan_hierarchy_id,
118: plan_id,

Line 139: hr_utility.TRACE ('Looping for supervisors for :' || i.employee_name);

135: l_counter := 0;
136:
137: FOR j IN l_sup_level.FIRST .. l_sup_level.LAST
138: LOOP
139: hr_utility.TRACE ('Looping for supervisors for :' || i.employee_name);
140: hr_utility.TRACE ('Supervisor:' || l_sup_level (j).supervisor_name);
141: hr_utility.TRACE ('Supervisor level:' || ((l_max_level - l_counter) + 1));
142:
143: INSERT INTO per_wpm_plan_hierarchy

Line 140: hr_utility.TRACE ('Supervisor:' || l_sup_level (j).supervisor_name);

136:
137: FOR j IN l_sup_level.FIRST .. l_sup_level.LAST
138: LOOP
139: hr_utility.TRACE ('Looping for supervisors for :' || i.employee_name);
140: hr_utility.TRACE ('Supervisor:' || l_sup_level (j).supervisor_name);
141: hr_utility.TRACE ('Supervisor level:' || ((l_max_level - l_counter) + 1));
142:
143: INSERT INTO per_wpm_plan_hierarchy
144: (wpm_plan_hierarchy_id,

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

137: FOR j IN l_sup_level.FIRST .. l_sup_level.LAST
138: LOOP
139: hr_utility.TRACE ('Looping for supervisors for :' || i.employee_name);
140: hr_utility.TRACE ('Supervisor:' || l_sup_level (j).supervisor_name);
141: hr_utility.TRACE ('Supervisor level:' || ((l_max_level - l_counter) + 1));
142:
143: INSERT INTO per_wpm_plan_hierarchy
144: (wpm_plan_hierarchy_id,
145: plan_id,

Line 168: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);

164: l_last := NVL (l_sup_level.LAST, 0);
165: l_sup_level (l_last + 1).supervisor_id := i.supervisor_id;
166: l_sup_level (l_last + 1).supervisor_name := i.supervisor_name;
167: l_sup_level (l_last + 1).level_num := NVL (p_level_num, 1) + 1;
168: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);
169: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level (l_last + 1).level_num);
170: insert_next_levels (p_plan_id,
171: i.employee_id,
172: l_sup_level,

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

165: l_sup_level (l_last + 1).supervisor_id := i.supervisor_id;
166: l_sup_level (l_last + 1).supervisor_name := i.supervisor_name;
167: l_sup_level (l_last + 1).level_num := NVL (p_level_num, 1) + 1;
168: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level.COUNT);
169: hr_utility.TRACE ('INSIDE insert_next_levels: ' || l_sup_level (l_last + 1).level_num);
170: insert_next_levels (p_plan_id,
171: i.employee_id,
172: l_sup_level,
173: l_sup_level (l_last + 1).level_num

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

174: );
175: l_sup_level.DELETE;
176: END LOOP;
177:
178: hr_utility.set_location ('Leaving:' || l_proc, 100);
179: END insert_next_levels;
180:
181: --
182: --

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

450: l_sup_level t_sup_level;
451: l_proc VARCHAR2 (80) := g_package || 'populate_plan_hierarchy';
452: BEGIN
453: --
454: hr_utility.set_location ('Entering:' || l_proc, 10);
455:
456: DELETE per_wpm_plan_hierarchy
457: WHERE plan_id = p_plan_id;
458:

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

482: END LOOP;
483: */
484: build_hierarchy_for_sc (p_plan_id => p_plan_id);
485: COMMIT;
486: hr_utility.set_location ('Leaving:' || l_proc, 100);
487: --
488: --
489: END populate_plan_hierarchy;
490:

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

534: IS
535: l_proc VARCHAR2 (80) := g_package || 'populate_appraisal_summary_cp';
536: l_effective_date DATE;
537: BEGIN
538: hr_utility.set_location ('Entering:' || l_proc, 10);
539: l_effective_date :=
540: NVL (fnd_date.canonical_to_date (p_effective_date), TRUNC (SYSDATE));
541: populate_appraisal_summary (p_plan_id => p_plan_id,
542: p_appraisal_period_id => p_appraisal_period_id,

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

541: populate_appraisal_summary (p_plan_id => p_plan_id,
542: p_appraisal_period_id => p_appraisal_period_id,
543: p_effective_date => l_effective_date
544: );
545: hr_utility.set_location ('Leaving:' || l_proc, 100);
546: EXCEPTION
547: WHEN OTHERS
548: THEN
549: fnd_file.put_line (fnd_file.LOG, SQLERRM);

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

548: THEN
549: fnd_file.put_line (fnd_file.LOG, SQLERRM);
550: retcode := 2;
551: errbuf := SQLERRM;
552: hr_utility.set_location ('Leaving:' || l_proc, 110);
553: RAISE;
554: END populate_appraisal_summary_cp;
555:
556: --

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

856: l_direct_unrated_count NUMBER (15);
857: --
858: BEGIN
859: --
860: hr_utility.set_location ('Entering:' || l_proc, 10);
861:
862: IF p_appraisal_template_id IS NULL OR p_appraisal_period_id IS NULL
863: THEN
864: hr_utility.TRACE ('Appraisal Tempate or Appraisal Period not selected. Returning');

Line 864: hr_utility.TRACE ('Appraisal Tempate or Appraisal Period not selected. Returning');

860: hr_utility.set_location ('Entering:' || l_proc, 10);
861:
862: IF p_appraisal_template_id IS NULL OR p_appraisal_period_id IS NULL
863: THEN
864: hr_utility.TRACE ('Appraisal Tempate or Appraisal Period not selected. Returning');
865: RETURN;
866: END IF;
867:
868: FOR i IN g_rating_levels.FIRST .. LEAST (g_rating_levels.LAST, 20) -- only upto 20 levels

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

1103: l_total_unrated_count
1104: );
1105:
1106: --
1107: hr_utility.set_location ('Leaving:' || l_proc, 100);
1108: --
1109: END compute_summary_for_supervisor;
1110:
1111: --

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

1152: WHERE wph.plan_id = p_plan_id
1153: AND pap.appraisal_period_id = p_appraisal_period_id
1154: AND pap.plan_id = wph.plan_id;
1155: BEGIN
1156: hr_utility.set_location ('Entering:' || l_proc, 10);
1157:
1158: OPEN csr_appr_period_dtls (p_appraisal_period_id);
1159:
1160: FETCH csr_appr_period_dtls

Line 1192: hr_utility.TRACE ('Computing totals for : ' || i.supervisor_name);

1188: CLOSE csr_appr_levels;
1189:
1190: FOR i IN csr_plan_managers (p_plan_id, p_appraisal_period_id)
1191: LOOP
1192: hr_utility.TRACE ('Computing totals for : ' || i.supervisor_name);
1193: compute_summary_for_supervisor (p_plan_id => p_plan_id,
1194: p_effective_date => p_effective_date,
1195: p_supervisor_id => i.supervisor_person_id,
1196: p_supervisor_name => i.supervisor_name,

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

1221:
1222: --
1223: COMMIT;
1224: --
1225: hr_utility.set_location ('Leaving:' || l_proc, 100);
1226: END populate_appraisal_summary;
1227:
1228: --
1229: --