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

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

26: PROCEDURE handle_error ( p_error_code in varchar2) IS
27: l_proc constant varchar2(72):= g_package||'handle_error';
28: BEGIN
29:
30: hr_utility.set_location('Entering:'||l_proc, 5);
31: IF (p_error_code = 'PGI_SETUP_NOT_FOUND') THEN
32: raise PGI_SETUP_NOT_FOUND;
33: END IF;
34:

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

31: IF (p_error_code = 'PGI_SETUP_NOT_FOUND') THEN
32: raise PGI_SETUP_NOT_FOUND;
33: END IF;
34:
35: hr_utility.set_location(' Leaving:'||l_proc, 10);
36: Exception
37: WHEN PGI_SETUP_NOT_FOUND THEN
38: raise;
39:

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

48: l_count number;
49: l_proc constant varchar2(72):= g_package||'get_emp_count_on_pgm';
50: BEGIN
51:
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: SELECT count(1)
54: INTO l_count
55: FROM pqh_rank_processes
56: WHERE pgm_id = p_pgm_id

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

57: AND (p_benefit_action_id IS NULL or benefit_action_id = p_benefit_action_id);
58:
59: RETURN l_count;
60:
61: hr_utility.set_location(' Leaving:'||l_proc, 10);
62: Exception
63: WHEN Others THEN
64: raise;
65: END get_emp_count_on_pgm ;

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

124: l_result varchar2(240);
125: l_proc constant varchar2(72):= g_package||'is_workflow_enabled';
126: BEGIN
127:
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: get_pgi_info (
130: p_pgm_id => p_pgm_id
131: ,p_workflow_enabled => l_wf_enabled
132: ,p_rank_enabled => l_rank_enabled

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

135: ,p_result => l_result );
136:
137: return l_wf_enabled;
138:
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: Exception
141: WHEN Others THEN
142: raise;
143: END;

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

163:
164: l_proc constant varchar2(72):= g_package||'get_pgi_info';
165: BEGIN
166:
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: open csr_pgi;
169: FETCH csr_pgi INTO p_workflow_enabled, p_rank_enabled, p_handle_duplicate, p_group_score;
170: IF (csr_pgi%NOTFOUND ) THEN
171: --

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

173: --
174: END IF;
175: CLOSE csr_pgi;
176:
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: Exception
179: WHEN Others THEN
180: raise;
181: END;

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

338: --
339: l_dt_start date;
340: l_dt_end date;
341: BEGIN
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: l_dt_start := trunc(fnd_date.canonical_to_date(p_process_dt_start));
344: l_dt_end := trunc(fnd_date.canonical_to_date(p_process_dt_end ));
345:
346: l_dt_end := nvl(l_dt_end , hr_general.end_of_time );

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

664: --
665: end if;
666: --
667: write_log(p_audit_log, 'RANKING PROCESS COMPLETE');
668: hr_utility.set_location(' Leaving:'||l_proc, 10);
669: --
670: Exception
671: WHEN Others THEN
672: raise;

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

697: l_assignment_id per_all_assignments_f.assignment_id%type;
698:
699: BEGIN
700:
701: hr_utility.set_location('Entering:'||l_proc, 5);
702: hr_utility.set_location('Grouping by: '||p_group_score,5);
703: hr_utility.set_location('Duplicate Handling: '||p_handle_duplicate,5);
704: /*
705: write_log('Y','$$$$$$$$$$$$$$$$ Begin Computing Total Score $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');

Line 702: hr_utility.set_location('Grouping by: '||p_group_score,5);

698:
699: BEGIN
700:
701: hr_utility.set_location('Entering:'||l_proc, 5);
702: hr_utility.set_location('Grouping by: '||p_group_score,5);
703: hr_utility.set_location('Duplicate Handling: '||p_handle_duplicate,5);
704: /*
705: write_log('Y','$$$$$$$$$$$$$$$$ Begin Computing Total Score $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
706: write_log('Y','Grouping by: '||p_group_score);

Line 703: hr_utility.set_location('Duplicate Handling: '||p_handle_duplicate,5);

699: BEGIN
700:
701: hr_utility.set_location('Entering:'||l_proc, 5);
702: hr_utility.set_location('Grouping by: '||p_group_score,5);
703: hr_utility.set_location('Duplicate Handling: '||p_handle_duplicate,5);
704: /*
705: write_log('Y','$$$$$$$$$$$$$$$$ Begin Computing Total Score $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
706: write_log('Y','Grouping by: '||p_group_score);
707: write_log('Y','Duplicate Handling: '||p_handle_duplicate);

Line 712: hr_utility.set_location('Grouping by Grade',5);

708: */
709: --
710: IF ( p_group_score = 'GRADE') THEN
711: --
712: hr_utility.set_location('Grouping by Grade',5);
713: IF ( p_handle_duplicate = 'SUM') THEN
714: --
715: --
716: INSERT INTO pqh_rank_processes (

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

881: and pgm_id = p_pgm_id;
882:
883: end loop;
884:
885: hr_utility.set_location(' Leaving:'||l_proc, 10);
886: /*
887: write_log('Y','LEAVING Compute Total Score ');
888: write_log('Y','$$$$$$$$$$$$$$$$ End Computing Total Score $$$$$$$$$$$$$$$$$$$');
889: */

Line 892: hr_utility.set_location(' Error in '||l_proc||' : '||sqlerrm, 10);

888: write_log('Y','$$$$$$$$$$$$$$$$ End Computing Total Score $$$$$$$$$$$$$$$$$$$');
889: */
890: Exception
891: WHEN Others THEN
892: hr_utility.set_location(' Error in '||l_proc||' : '||sqlerrm, 10);
893: write_log('Y','Error in '||l_proc||': '||sqlerrm);
894: /*
895: write_log('Y','$$$$$$$$$$$$$$$$ End Computing Total Score $$$$$$$$$$$$$$$$$$$');
896: */

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

913: --
914: l_proc constant varchar2(72):= g_package||'compute_score_for_cwb';
915: BEGIN
916:
917: hr_utility.set_location('Entering:'||l_proc, 5);
918:
919: --
920: --
921: /** NS: 04/26/2005: Commenting as CWB Ranking is not going in FP.K

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

952: And pr.lf_evt_ocrd_dt between sr.effective_start_date and sr.effective_end_date
953: --
954: Group by pr.group_pl_id, pr.lf_evt_ocrd_dt,pr.person_id, pr.assignment_id);
955: --
956: hr_utility.set_location(' Leaving:'||l_proc, 10);
957: Exception
958: WHEN Others THEN
959: raise;
960: **/

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

973:
974: l_proc constant varchar2(72):= g_package||'compute_total_score';
975: BEGIN
976:
977: hr_utility.set_location('Entering:'||l_proc, 5);
978: --
979: if (p_module = 'GSP') then
980: --
981: Declare

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

1035: End;
1036:
1037: end if;
1038: --
1039: hr_utility.set_location(' Leaving:'||l_proc, 10);
1040: Exception
1041: WHEN Others THEN
1042: raise;
1043: END compute_total_score;

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

1055: --
1056: l_proc constant varchar2(72):= g_package||'assign_ranks_for_cwb';
1057: BEGIN
1058:
1059: hr_utility.set_location('Entering:'||l_proc, 5);
1060: --
1061: FOR rec_rnk in csr_rnk
1062: LOOP
1063: --

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

1081: order by rp.total_score desc);
1082: --
1083: END LOOP;
1084: --
1085: hr_utility.set_location(' Leaving:'||l_proc, 10);
1086: Exception
1087: WHEN Others THEN
1088: raise;
1089: END assign_ranks_for_CWB;

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

1108:
1109: l_proc constant varchar2(72):= g_package||'get_criteria_name';
1110: BEGIN
1111:
1112: hr_utility.set_location('Entering:'||l_proc, 5);
1113: --
1114: OPEN csr_crit_nm;
1115: FETCH csr_crit_nm INTO l_crit_name;
1116: CLOSE csr_crit_nm;

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

1117: --
1118: RETURN l_crit_name;
1119: --
1120: --
1121: hr_utility.set_location(' Leaving:'||l_proc, 10);
1122: Exception
1123: WHEN Others THEN
1124: raise;
1125: END get_criteria_name;