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

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

22:
23: l_return_status varchar2(1);
24:
25: begin
26: hr_utility.set_location('Entering into '||l_proc,5);
27:
28: l_length_of_service := PQH_LENGTH_OF_SERVICE_PKG.get_length_of_service(
29: p_bg_id => p_business_group_id,
30: p_person_id => p_person_id,

Line 40: hr_utility.set_location('Required length of service in Months '||to_char(l_req_length_of_service),5);

36: l_req_length_of_service := pqh_corps_utility.los_in_months(p_los_years => p_req_years,
37: p_los_months => p_req_Months,
38: p_los_days => p_req_days);
39:
40: hr_utility.set_location('Required length of service in Months '||to_char(l_req_length_of_service),5);
41: hr_utility.set_location('Current length of service in Months '||to_char(l_length_of_service),5);
42:
43: if l_length_of_service >= l_req_length_of_service then
44: l_return_status := 'Y';

Line 41: hr_utility.set_location('Current length of service in Months '||to_char(l_length_of_service),5);

37: p_los_months => p_req_Months,
38: p_los_days => p_req_days);
39:
40: hr_utility.set_location('Required length of service in Months '||to_char(l_req_length_of_service),5);
41: hr_utility.set_location('Current length of service in Months '||to_char(l_length_of_service),5);
42:
43: if l_length_of_service >= l_req_length_of_service then
44: l_return_status := 'Y';
45: else

Line 48: hr_utility.set_location('Leaving from '||l_proc,5);

44: l_return_status := 'Y';
45: else
46: l_return_status := 'N';
47: end if;
48: hr_utility.set_location('Leaving from '||l_proc,5);
49: return l_return_status;
50: end check_length_of_service;
51:
52: procedure check_eligibility ( p_per_in_ler_id in number,

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

80: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
81: l_score_tab ben_evaluate_elig_profiles.scoreTab;
82:
83: begin
84: hr_utility.set_location('Entering into '||l_proc,5);
85: hr_utility.set_location('Clearing Cache '||l_proc,5);
86: -- ben_cep_cache.clear_down_cache;
87:
88: /* ben_manage_life_events.clear_init_benmngle_caches

Line 85: hr_utility.set_location('Clearing Cache '||l_proc,5);

81: l_score_tab ben_evaluate_elig_profiles.scoreTab;
82:
83: begin
84: hr_utility.set_location('Entering into '||l_proc,5);
85: hr_utility.set_location('Clearing Cache '||l_proc,5);
86: -- ben_cep_cache.clear_down_cache;
87:
88: /* ben_manage_life_events.clear_init_benmngle_caches
89: (p_business_group_id => p_business_group_id

Line 98: hr_utility.set_location('Creating ben person objects '||l_proc,5);

94: ,p_benefit_action_id => Null
95: ,p_thread_id => 1
96: ); */
97:
98: hr_utility.set_location('Creating ben person objects '||l_proc,5);
99:
100: hr_utility.set_location('Pgm Id '||p_pgm_id,5);
101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);
102: hr_utility.set_location('p_opt_id '||p_opt_id,5);

Line 100: hr_utility.set_location('Pgm Id '||p_pgm_id,5);

96: ); */
97:
98: hr_utility.set_location('Creating ben person objects '||l_proc,5);
99:
100: hr_utility.set_location('Pgm Id '||p_pgm_id,5);
101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);
102: hr_utility.set_location('p_opt_id '||p_opt_id,5);
103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);

Line 101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);

97:
98: hr_utility.set_location('Creating ben person objects '||l_proc,5);
99:
100: hr_utility.set_location('Pgm Id '||p_pgm_id,5);
101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);
102: hr_utility.set_location('p_opt_id '||p_opt_id,5);
103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);

Line 102: hr_utility.set_location('p_opt_id '||p_opt_id,5);

98: hr_utility.set_location('Creating ben person objects '||l_proc,5);
99:
100: hr_utility.set_location('Pgm Id '||p_pgm_id,5);
101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);
102: hr_utility.set_location('p_opt_id '||p_opt_id,5);
103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);

Line 103: hr_utility.set_location('p_plip_id '||p_plip_id,5);

99:
100: hr_utility.set_location('Pgm Id '||p_pgm_id,5);
101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);
102: hr_utility.set_location('p_opt_id '||p_opt_id,5);
103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);
107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);

Line 104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);

100: hr_utility.set_location('Pgm Id '||p_pgm_id,5);
101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);
102: hr_utility.set_location('p_opt_id '||p_opt_id,5);
103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);
107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);
108: hr_utility.set_location('p_par_plip_id '||p_par_plip_id,5);

Line 105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);

101: hr_utility.set_location('p_oipl_id '||p_oipl_id,5);
102: hr_utility.set_location('p_opt_id '||p_opt_id,5);
103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);
107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);
108: hr_utility.set_location('p_par_plip_id '||p_par_plip_id,5);
109: hr_utility.set_location('p_par_opt_id '||p_par_opt_id,5);

Line 106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);

102: hr_utility.set_location('p_opt_id '||p_opt_id,5);
103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);
107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);
108: hr_utility.set_location('p_par_plip_id '||p_par_plip_id,5);
109: hr_utility.set_location('p_par_opt_id '||p_par_opt_id,5);
110:

Line 107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);

103: hr_utility.set_location('p_plip_id '||p_plip_id,5);
104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);
107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);
108: hr_utility.set_location('p_par_plip_id '||p_par_plip_id,5);
109: hr_utility.set_location('p_par_opt_id '||p_par_opt_id,5);
110:
111: ben_person_object.get_object

Line 108: hr_utility.set_location('p_par_plip_id '||p_par_plip_id,5);

104: hr_utility.set_location('p_ptip_id'||p_ptip_id,5);
105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);
107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);
108: hr_utility.set_location('p_par_plip_id '||p_par_plip_id,5);
109: hr_utility.set_location('p_par_opt_id '||p_par_opt_id,5);
110:
111: ben_person_object.get_object
112: (p_person_id => p_person_id

Line 109: hr_utility.set_location('p_par_opt_id '||p_par_opt_id,5);

105: hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
106: hr_utility.set_location('p_par_pgm_id '||p_par_pgm_id,5);
107: hr_utility.set_location('p_par_pl_id '||p_par_pl_id,5);
108: hr_utility.set_location('p_par_plip_id '||p_par_plip_id,5);
109: hr_utility.set_location('p_par_opt_id '||p_par_opt_id,5);
110:
111: ben_person_object.get_object
112: (p_person_id => p_person_id
113: ,p_rec => l_empasg_row

Line 127: hr_utility.set_location('Creating comp_obj_tree_row ',5);

123: ,p_per_in_ler_id =>p_per_in_ler_id
124: ,p_rec => l_pil_row
125: );
126:
127: hr_utility.set_location('Creating comp_obj_tree_row ',5);
128:
129: l_comp_obj_tree_row.pl_id := p_pl_id;
130: l_comp_obj_tree_row.pgm_id := p_pgm_id;
131: l_comp_obj_tree_row.oipl_id := p_oipl_id;

Line 143: hr_utility.set_location('Creating derive rate factors data structure ',5);

139: l_comp_obj_tree_row.par_opt_id := p_par_opt_id;
140: l_comp_obj_tree_row.prtn_strt_dt := p_effective_date;
141:
142:
143: hr_utility.set_location('Creating derive rate factors data structure ',5);
144:
145: hr_utility.set_location('Creating derive rate factors data structure ',5);
146: hr_utility.set_location('Values in Comp obj tree ',5);
147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);

Line 145: hr_utility.set_location('Creating derive rate factors data structure ',5);

141:
142:
143: hr_utility.set_location('Creating derive rate factors data structure ',5);
144:
145: hr_utility.set_location('Creating derive rate factors data structure ',5);
146: hr_utility.set_location('Values in Comp obj tree ',5);
147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);
148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);

Line 146: hr_utility.set_location('Values in Comp obj tree ',5);

142:
143: hr_utility.set_location('Creating derive rate factors data structure ',5);
144:
145: hr_utility.set_location('Creating derive rate factors data structure ',5);
146: hr_utility.set_location('Values in Comp obj tree ',5);
147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);
148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);

Line 147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);

143: hr_utility.set_location('Creating derive rate factors data structure ',5);
144:
145: hr_utility.set_location('Creating derive rate factors data structure ',5);
146: hr_utility.set_location('Values in Comp obj tree ',5);
147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);
148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);

Line 148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);

144:
145: hr_utility.set_location('Creating derive rate factors data structure ',5);
146: hr_utility.set_location('Values in Comp obj tree ',5);
147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);
148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);

Line 149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);

145: hr_utility.set_location('Creating derive rate factors data structure ',5);
146: hr_utility.set_location('Values in Comp obj tree ',5);
147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);
148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);

Line 150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);

146: hr_utility.set_location('Values in Comp obj tree ',5);
147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);
148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);
154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);

Line 151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);

147: hr_utility.set_location('Pgm Id '||l_comp_obj_tree_row.pgm_id,5);
148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);
154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);
155: hr_utility.set_location('p_par_plip_id '||l_comp_obj_tree_row.par_plip_id ,5);

Line 152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);

148: hr_utility.set_location('p_oipl_id '|| l_comp_obj_tree_row.oipl_id,5);
149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);
154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);
155: hr_utility.set_location('p_par_plip_id '||l_comp_obj_tree_row.par_plip_id ,5);
156: hr_utility.set_location('p_par_opt_id '|| l_comp_obj_tree_row.par_opt_id,5);

Line 153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);

149: --hr_utility.set_location('p_opt_id '||l_comp_obj_tree_row.oipl_id,5);
150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);
154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);
155: hr_utility.set_location('p_par_plip_id '||l_comp_obj_tree_row.par_plip_id ,5);
156: hr_utility.set_location('p_par_opt_id '|| l_comp_obj_tree_row.par_opt_id,5);
157:

Line 154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);

150: hr_utility.set_location('p_plip_id '||l_comp_obj_tree_row.plip_id,5);
151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);
154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);
155: hr_utility.set_location('p_par_plip_id '||l_comp_obj_tree_row.par_plip_id ,5);
156: hr_utility.set_location('p_par_opt_id '|| l_comp_obj_tree_row.par_opt_id,5);
157:
158:

Line 155: hr_utility.set_location('p_par_plip_id '||l_comp_obj_tree_row.par_plip_id ,5);

151: hr_utility.set_location('p_ptip_id'|| l_comp_obj_tree_row.ptip_id,5);
152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);
154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);
155: hr_utility.set_location('p_par_plip_id '||l_comp_obj_tree_row.par_plip_id ,5);
156: hr_utility.set_location('p_par_opt_id '|| l_comp_obj_tree_row.par_opt_id,5);
157:
158:
159: ben_derive_part_and_rate_facts.cache_data_structures(

Line 156: hr_utility.set_location('p_par_opt_id '|| l_comp_obj_tree_row.par_opt_id,5);

152: --hr_utility.set_location('p_pl_type_id '||p_pl_type_id,5);
153: hr_utility.set_location('p_par_pgm_id '||l_comp_obj_tree_row.par_pgm_id ,5);
154: hr_utility.set_location('p_par_pl_id '||l_comp_obj_tree_row.par_pl_id,5);
155: hr_utility.set_location('p_par_plip_id '||l_comp_obj_tree_row.par_plip_id ,5);
156: hr_utility.set_location('p_par_opt_id '|| l_comp_obj_tree_row.par_opt_id,5);
157:
158:
159: ben_derive_part_and_rate_facts.cache_data_structures(
160: p_comp_obj_tree_row => l_comp_obj_tree_row

Line 175: hr_utility.set_location('Checking Eligibiltiy ',5);

171: ,p_oipl_id => p_oipl_id
172: ,p_comp_rec => l_comp_rec
173: ,p_oiplip_rec => l_oiplip_rec);
174:
175: hr_utility.set_location('Checking Eligibiltiy ',5);
176:
177: l_elig_return_status := ben_evaluate_elig_profiles.eligible
178: (
179: p_person_id => p_person_id

Line 206: hr_utility.set_location('Leaving from '||l_proc,5);

202: p_score_tab := l_score_tab;
203: else
204: p_return_status := 'N';
205: end if;
206: hr_utility.set_location('Leaving from '||l_proc,5);
207: end check_eligibility;
208:
209: procedure Create_Elictable_chc(
210: p_person_id in number,

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

254: l_request_id number;
255:
256:
257: Begin
258: hr_utility.set_location('Entering into '||l_proc,5);
259:
260: hr_utility.set_location('Creating pgm Row '||l_proc,5);
261: open pgm_info;
262: fetch pgm_info into pgm_info_rec;

Line 260: hr_utility.set_location('Creating pgm Row '||l_proc,5);

256:
257: Begin
258: hr_utility.set_location('Entering into '||l_proc,5);
259:
260: hr_utility.set_location('Creating pgm Row '||l_proc,5);
261: open pgm_info;
262: fetch pgm_info into pgm_info_rec;
263:
264: l_pgm_row.pgm_id := pgm_info_rec.pgm_id;

Line 291: hr_utility.set_location('Geting P_Enrt_Cvg_Strt_Dt ',5);

287:
288: close pgm_info;
289:
290:
291: hr_utility.set_location('Geting P_Enrt_Cvg_Strt_Dt ',5);
292:
293: select blr.LEE_RSN_ID,pil.request_id
294: into l_LEE_RSN_ID, l_request_id
295: from ben_lee_rsn_f blr,

Line 332: hr_utility.set_location('Creating electable choice ',5);

328: ,p_rt_end_dt_cd => l_rt_end_dt_cd
329: ,p_rt_end_dt_rl => l_rt_end_dt_rl
330: );
331:
332: hr_utility.set_location('Creating electable choice ',5);
333:
334: select enrt_mthd_cd
335: into l_posting_style
336: from ben_pgm_f

Line 439: hr_utility.set_location('Leaving from '||l_proc,5);

435:
436: P_Elig_Per_Elctbl_Chc_Id := L_Oipl_Elig_Per_Elctbl_Chc_Id;
437:
438: end if;
439: hr_utility.set_location('Leaving from '||l_proc,5);
440:
441:
442: end Create_Elictable_chc;
443:

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

474: Between Effective_Start_Date
475: and Effective_End_Date;
476:
477: begin
478: hr_utility.set_location('Entering into '||l_proc,5);
479:
480: if p_comb_lvl_cd = 'PLAN' then
481:
482: Open Pl_Bas_rt(p_Pl_Id);

Line 512: hr_utility.set_location('Leaving from '||l_proc,5);

508: ,P_ACTY_BASE_RT_ID => L_Acty_Base_rt_Id
509: ,P_OBJECT_VERSION_NUMBER => l_Enrt_Rt_Ovn
510: ,P_Effective_Date => P_Effective_Date);
511:
512: hr_utility.set_location('Leaving from '||l_proc,5);
513:
514: end Create_Enrolment_rates; */
515:
516: procedure Create_Enrolment_rates(p_effective_date in date,

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

520: p_person_id in number
521: ) is
522: l_proc varchar2(60) := g_package||'Create_Enrolment_rates';
523: begin
524: hr_utility.set_location('Entering into '||l_proc,5);
525: ben_env_object.init(p_business_group_id => p_business_group_id,
526: p_effective_date => p_effective_date,
527: p_thread_id => 1,
528: p_chunk_size => 1,

Line 544: hr_utility.set_location('Leaving from '||l_proc,5);

540: ,P_PERSON_ID => p_person_id
541: ,P_PER_IN_LER_ID => p_per_in_ler_id
542: ,p_elig_per_elctbl_chc_id => p_electble_chc_id);
543:
544: hr_utility.set_location('Leaving from '||l_proc,5);
545: end Create_Enrolment_rates;
546:
547: procedure Create_elig_per_scre( p_business_group_id in number,
548: p_per_in_ler_id in number,

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

567: l_elig_per_opt_ovn_no number;
568: l_proc varchar2(60) := g_package||'Create_elig_per_scre';
569:
570: begin
571: hr_utility.set_location('Entering into '||l_proc,5);
572: l_number_of_rows := p_score_tab.COUNT;
573: if l_number_of_rows > 0 then
574:
575: select pil.request_id

Line 605: hr_utility.set_location('elig_per_id'||l_elig_per_id,5);

601: ,p_effective_date => p_effective_date
602: ,p_prtn_ovridn_flag => 'N'
603: ,p_request_id => l_request_id
604: );
605: hr_utility.set_location('elig_per_id'||l_elig_per_id,5);
606: hr_utility.set_location('p_opt_id'||p_opt_id,5);
607:
608: -- if p_opt_id is not null then
609: hr_utility.set_location('going to create elig_per_opt record'||p_opt_id,5);

Line 606: hr_utility.set_location('p_opt_id'||p_opt_id,5);

602: ,p_prtn_ovridn_flag => 'N'
603: ,p_request_id => l_request_id
604: );
605: hr_utility.set_location('elig_per_id'||l_elig_per_id,5);
606: hr_utility.set_location('p_opt_id'||p_opt_id,5);
607:
608: -- if p_opt_id is not null then
609: hr_utility.set_location('going to create elig_per_opt record'||p_opt_id,5);
610: ben_Elig_Person_option_api.create_perf_Elig_Person_option

Line 609: hr_utility.set_location('going to create elig_per_opt record'||p_opt_id,5);

605: hr_utility.set_location('elig_per_id'||l_elig_per_id,5);
606: hr_utility.set_location('p_opt_id'||p_opt_id,5);
607:
608: -- if p_opt_id is not null then
609: hr_utility.set_location('going to create elig_per_opt record'||p_opt_id,5);
610: ben_Elig_Person_option_api.create_perf_Elig_Person_option
611: ( p_elig_per_opt_id => l_elig_per_opt_id
612: ,p_elig_per_id => l_elig_per_id
613: ,p_effective_start_date => l_opt_effective_start_date

Line 627: hr_utility.set_location('l_elig_per_opt_id'||l_elig_per_opt_id,5);

623: ,p_effective_date => p_effective_date
624: );
625: -- end if;
626:
627: hr_utility.set_location('l_elig_per_opt_id'||l_elig_per_opt_id,5);
628: end if;
629: FOR table_row IN 1 .. l_number_of_rows
630: LOOP
631: hr_utility.set_location('eligy_prfl_id'||p_score_tab(table_row).eligy_prfl_id,5);

Line 631: hr_utility.set_location('eligy_prfl_id'||p_score_tab(table_row).eligy_prfl_id,5);

627: hr_utility.set_location('l_elig_per_opt_id'||l_elig_per_opt_id,5);
628: end if;
629: FOR table_row IN 1 .. l_number_of_rows
630: LOOP
631: hr_utility.set_location('eligy_prfl_id'||p_score_tab(table_row).eligy_prfl_id,5);
632: hr_utility.set_location('crit_tab_short_name'||p_score_tab(table_row).crit_tab_short_name,5);
633: hr_utility.set_location('crit_tab_pk_id'||p_score_tab(table_row).crit_tab_pk_id,5);
634: hr_utility.set_location('computed_score'||p_score_tab(table_row).computed_score,5);
635: hr_utility.set_location('benefit_action_id'||p_score_tab(table_row).benefit_action_id,5);

Line 632: hr_utility.set_location('crit_tab_short_name'||p_score_tab(table_row).crit_tab_short_name,5);

628: end if;
629: FOR table_row IN 1 .. l_number_of_rows
630: LOOP
631: hr_utility.set_location('eligy_prfl_id'||p_score_tab(table_row).eligy_prfl_id,5);
632: hr_utility.set_location('crit_tab_short_name'||p_score_tab(table_row).crit_tab_short_name,5);
633: hr_utility.set_location('crit_tab_pk_id'||p_score_tab(table_row).crit_tab_pk_id,5);
634: hr_utility.set_location('computed_score'||p_score_tab(table_row).computed_score,5);
635: hr_utility.set_location('benefit_action_id'||p_score_tab(table_row).benefit_action_id,5);
636: BEN_ELIG_SCRE_WTG_API.load_score_weight( p_score_tab => p_score_tab

Line 633: hr_utility.set_location('crit_tab_pk_id'||p_score_tab(table_row).crit_tab_pk_id,5);

629: FOR table_row IN 1 .. l_number_of_rows
630: LOOP
631: hr_utility.set_location('eligy_prfl_id'||p_score_tab(table_row).eligy_prfl_id,5);
632: hr_utility.set_location('crit_tab_short_name'||p_score_tab(table_row).crit_tab_short_name,5);
633: hr_utility.set_location('crit_tab_pk_id'||p_score_tab(table_row).crit_tab_pk_id,5);
634: hr_utility.set_location('computed_score'||p_score_tab(table_row).computed_score,5);
635: hr_utility.set_location('benefit_action_id'||p_score_tab(table_row).benefit_action_id,5);
636: BEN_ELIG_SCRE_WTG_API.load_score_weight( p_score_tab => p_score_tab
637: ,p_elig_per_id => l_elig_per_id

Line 634: hr_utility.set_location('computed_score'||p_score_tab(table_row).computed_score,5);

630: LOOP
631: hr_utility.set_location('eligy_prfl_id'||p_score_tab(table_row).eligy_prfl_id,5);
632: hr_utility.set_location('crit_tab_short_name'||p_score_tab(table_row).crit_tab_short_name,5);
633: hr_utility.set_location('crit_tab_pk_id'||p_score_tab(table_row).crit_tab_pk_id,5);
634: hr_utility.set_location('computed_score'||p_score_tab(table_row).computed_score,5);
635: hr_utility.set_location('benefit_action_id'||p_score_tab(table_row).benefit_action_id,5);
636: BEN_ELIG_SCRE_WTG_API.load_score_weight( p_score_tab => p_score_tab
637: ,p_elig_per_id => l_elig_per_id
638: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 635: hr_utility.set_location('benefit_action_id'||p_score_tab(table_row).benefit_action_id,5);

631: hr_utility.set_location('eligy_prfl_id'||p_score_tab(table_row).eligy_prfl_id,5);
632: hr_utility.set_location('crit_tab_short_name'||p_score_tab(table_row).crit_tab_short_name,5);
633: hr_utility.set_location('crit_tab_pk_id'||p_score_tab(table_row).crit_tab_pk_id,5);
634: hr_utility.set_location('computed_score'||p_score_tab(table_row).computed_score,5);
635: hr_utility.set_location('benefit_action_id'||p_score_tab(table_row).benefit_action_id,5);
636: BEN_ELIG_SCRE_WTG_API.load_score_weight( p_score_tab => p_score_tab
637: ,p_elig_per_id => l_elig_per_id
638: ,p_elig_per_opt_id => l_elig_per_opt_id
639: ,p_effective_date => p_effective_date );

Line 641: hr_utility.set_location('Leaving '||l_proc,5);

637: ,p_elig_per_id => l_elig_per_id
638: ,p_elig_per_opt_id => l_elig_per_opt_id
639: ,p_effective_date => p_effective_date );
640: END LOOP;
641: hr_utility.set_location('Leaving '||l_proc,5);
642: end Create_elig_per_scre ;
643:
644: procedure check_career_paths(p_per_in_ler_id in number,
645: p_person_id in number,

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

727:
728: step_info_rec step_info%rowtype;
729:
730: begin
731: hr_utility.set_location('Entering into '||l_proc,5);
732:
733: l_person_id := p_person_id;
734: l_assignment_id := p_assignment_id;
735: l_effective_date := p_effective_date;

Line 741: hr_utility.set_location('l_person_id '||to_char(l_person_id),5);

737: l_cur_grade_id := p_cur_grade_id;
738: l_cur_step_id := p_cur_step_id;
739:
740:
741: hr_utility.set_location('l_person_id '||to_char(l_person_id),5);
742: hr_utility.set_location('l_assignment_id '||to_char(l_assignment_id),5);
743: hr_utility.set_location('l_effective_date '||to_char(l_effective_date),5);
744: hr_utility.set_location('l_cur_corp_id '||to_char(l_cur_corp_id),5);
745: hr_utility.set_location('l_cur_grade_id '||to_char(l_cur_grade_id),5);

Line 742: hr_utility.set_location('l_assignment_id '||to_char(l_assignment_id),5);

738: l_cur_step_id := p_cur_step_id;
739:
740:
741: hr_utility.set_location('l_person_id '||to_char(l_person_id),5);
742: hr_utility.set_location('l_assignment_id '||to_char(l_assignment_id),5);
743: hr_utility.set_location('l_effective_date '||to_char(l_effective_date),5);
744: hr_utility.set_location('l_cur_corp_id '||to_char(l_cur_corp_id),5);
745: hr_utility.set_location('l_cur_grade_id '||to_char(l_cur_grade_id),5);
746: hr_utility.set_location('l_cur_step_id '||to_char(l_cur_step_id),5);

Line 743: hr_utility.set_location('l_effective_date '||to_char(l_effective_date),5);

739:
740:
741: hr_utility.set_location('l_person_id '||to_char(l_person_id),5);
742: hr_utility.set_location('l_assignment_id '||to_char(l_assignment_id),5);
743: hr_utility.set_location('l_effective_date '||to_char(l_effective_date),5);
744: hr_utility.set_location('l_cur_corp_id '||to_char(l_cur_corp_id),5);
745: hr_utility.set_location('l_cur_grade_id '||to_char(l_cur_grade_id),5);
746: hr_utility.set_location('l_cur_step_id '||to_char(l_cur_step_id),5);
747: open career_paths;

Line 744: hr_utility.set_location('l_cur_corp_id '||to_char(l_cur_corp_id),5);

740:
741: hr_utility.set_location('l_person_id '||to_char(l_person_id),5);
742: hr_utility.set_location('l_assignment_id '||to_char(l_assignment_id),5);
743: hr_utility.set_location('l_effective_date '||to_char(l_effective_date),5);
744: hr_utility.set_location('l_cur_corp_id '||to_char(l_cur_corp_id),5);
745: hr_utility.set_location('l_cur_grade_id '||to_char(l_cur_grade_id),5);
746: hr_utility.set_location('l_cur_step_id '||to_char(l_cur_step_id),5);
747: open career_paths;
748: loop

Line 745: hr_utility.set_location('l_cur_grade_id '||to_char(l_cur_grade_id),5);

741: hr_utility.set_location('l_person_id '||to_char(l_person_id),5);
742: hr_utility.set_location('l_assignment_id '||to_char(l_assignment_id),5);
743: hr_utility.set_location('l_effective_date '||to_char(l_effective_date),5);
744: hr_utility.set_location('l_cur_corp_id '||to_char(l_cur_corp_id),5);
745: hr_utility.set_location('l_cur_grade_id '||to_char(l_cur_grade_id),5);
746: hr_utility.set_location('l_cur_step_id '||to_char(l_cur_step_id),5);
747: open career_paths;
748: loop
749: fetch career_paths into career_path_rec;

Line 746: hr_utility.set_location('l_cur_step_id '||to_char(l_cur_step_id),5);

742: hr_utility.set_location('l_assignment_id '||to_char(l_assignment_id),5);
743: hr_utility.set_location('l_effective_date '||to_char(l_effective_date),5);
744: hr_utility.set_location('l_cur_corp_id '||to_char(l_cur_corp_id),5);
745: hr_utility.set_location('l_cur_grade_id '||to_char(l_cur_grade_id),5);
746: hr_utility.set_location('l_cur_step_id '||to_char(l_cur_step_id),5);
747: open career_paths;
748: loop
749: fetch career_paths into career_path_rec;
750: exit when career_paths%notfound;

Line 764: hr_utility.set_location('Checking eligibility for Corp ',5);

760: p_req_days => career_path_rec.req_days);
761:
762: if l_los_return_status = 'Y' then
763:
764: hr_utility.set_location('Checking eligibility for Corp ',5);
765: check_eligibility (
766: p_per_in_ler_id => p_per_in_ler_id,
767: p_person_id => p_person_id,
768: p_effective_date => p_effective_date,

Line 776: hr_utility.set_location('Eligibility defined at Corp is satisfied ',5);

772: p_return_status => l_elig_return_status,
773: p_score_tab => l_score_tab
774: );
775: if l_elig_return_status = 'Y' then
776: hr_utility.set_location('Eligibility defined at Corp is satisfied ',5);
777: Create_elig_per_scre( p_business_group_id => p_business_group_id,
778: p_per_in_ler_id => p_per_in_ler_id,
779: p_person_id => p_person_id,
780: p_effective_date => p_effective_date,

Line 787: hr_utility.set_location('Checking eligibility defined at grade in corp (plip) ',5);

783: p_plip_id => career_path_rec.to_plip_id,
784: p_ptip_id => career_path_rec.to_ptip_id,
785: p_score_tab => l_score_tab
786: );
787: hr_utility.set_location('Checking eligibility defined at grade in corp (plip) ',5);
788: check_eligibility (
789: p_per_in_ler_id => p_per_in_ler_id,
790: p_person_id => p_person_id,
791: p_effective_date => p_effective_date,

Line 801: hr_utility.set_location('Eligibility defined at Grade in Corp is satisfied ',5);

797: p_return_status => l_elig_return_status,
798: p_score_tab => l_score_tab
799: );
800: if l_elig_return_status = 'Y' then
801: hr_utility.set_location('Eligibility defined at Grade in Corp is satisfied ',5);
802: Create_elig_per_scre( p_business_group_id => p_business_group_id,
803: p_per_in_ler_id => p_per_in_ler_id,
804: p_person_id => p_person_id,
805: p_effective_date => p_effective_date,

Line 812: hr_utility.set_location('Checking eligibility defined at grade ',5);

808: p_plip_id => career_path_rec.to_plip_id,
809: p_ptip_id => career_path_rec.to_ptip_id,
810: p_score_tab => l_score_tab
811: );
812: hr_utility.set_location('Checking eligibility defined at grade ',5);
813: check_eligibility (
814: p_per_in_ler_id => p_per_in_ler_id,
815: p_person_id => p_person_id,
816: p_effective_date => p_effective_date,

Line 825: hr_utility.set_location('Eligibility defined at Grade is satisfied ',5);

821: p_return_status => l_elig_return_status,
822: p_score_tab => l_score_tab
823: );
824: if l_elig_return_status = 'Y' then
825: hr_utility.set_location('Eligibility defined at Grade is satisfied ',5);
826: Create_elig_per_scre( p_business_group_id => p_business_group_id,
827: p_per_in_ler_id => p_per_in_ler_id,
828: p_person_id => p_person_id,
829: p_effective_date => p_effective_date,

Line 839: hr_utility.set_location('Checking eligibility defined at step ',5);

835: );
836: if career_path_rec.to_step_id is not null then
837: open step_info;
838: fetch step_info into step_info_rec;
839: hr_utility.set_location('Checking eligibility defined at step ',5);
840: check_eligibility(
841: p_per_in_ler_id => p_per_in_ler_id,
842: p_person_id => p_person_id,
843: p_effective_date => p_effective_date,

Line 883: hr_utility.set_location('Eligibility defined at step is NOT satisfied ',5);

879:
880:
881: exit;
882: else
883: hr_utility.set_location('Eligibility defined at step is NOT satisfied ',5);
884: l_elig_return_status := 'N';
885: end if;
886: else
887: Create_Elictable_chc(

Line 904: hr_utility.set_location('Eligibility defined at grade is NOT satisfied ',5);

900:
901: exit;
902: end if;
903: else
904: hr_utility.set_location('Eligibility defined at grade is NOT satisfied ',5);
905: l_elig_return_status := 'N';
906: end if;
907: else
908: hr_utility.set_location('Eligibility defined at PLIP is NOT satisfied ',5);

Line 908: hr_utility.set_location('Eligibility defined at PLIP is NOT satisfied ',5);

904: hr_utility.set_location('Eligibility defined at grade is NOT satisfied ',5);
905: l_elig_return_status := 'N';
906: end if;
907: else
908: hr_utility.set_location('Eligibility defined at PLIP is NOT satisfied ',5);
909: l_elig_return_status := 'N';
910: end if;
911: else
912: hr_utility.set_location('Eligibility defined at Corp is NOT satisfied ',5);

Line 912: hr_utility.set_location('Eligibility defined at Corp is NOT satisfied ',5);

908: hr_utility.set_location('Eligibility defined at PLIP is NOT satisfied ',5);
909: l_elig_return_status := 'N';
910: end if;
911: else
912: hr_utility.set_location('Eligibility defined at Corp is NOT satisfied ',5);
913: l_elig_return_status := 'N';
914: end if;
915: else
916: l_elig_return_status := 'N';

Line 923: hr_utility.set_location('Creating Enrolment rates for the new electable choice ',5);

919: end loop;
920:
921: if l_elig_return_status <> 'N' then
922:
923: hr_utility.set_location('Creating Enrolment rates for the new electable choice ',5);
924:
925: Create_Enrolment_rates(p_effective_date => p_effective_date,
926: p_electble_chc_id => P_Elig_Per_Elctbl_Chc_Id,
927: p_business_group_id => p_business_group_id,

Line 935: hr_utility.set_location('Leaving from '||l_proc,5);

931:
932: end if;
933:
934: p_return_status := l_elig_return_status;
935: hr_utility.set_location('Leaving from '||l_proc,5);
936:
937: end check_career_paths ;
938:
939: Procedure get_elctbl_chc_career_path (p_per_in_ler_id in number,

Line 998: -- hr_utility.trace_on(NULL,'SJSCR');

994: l_return_status varchar2(1);
995:
996:
997: begin
998: -- hr_utility.trace_on(NULL,'SJSCR');
999:
1000: hr_utility.set_location('Entering into '||l_proc,5);
1001:
1002: open per_in_ler_info;

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

996:
997: begin
998: -- hr_utility.trace_on(NULL,'SJSCR');
999:
1000: hr_utility.set_location('Entering into '||l_proc,5);
1001:
1002: open per_in_ler_info;
1003: fetch per_in_ler_info into l_pil_info_rec;
1004: close per_in_ler_info;

Line 1013: hr_utility.set_location('In the person_cur_asg_info cur asg info loop '||l_proc,5);

1009: loop
1010: fetch person_cur_asg_info into l_person_info_rec;
1011: exit when person_cur_asg_info%notfound;
1012:
1013: hr_utility.set_location('In the person_cur_asg_info cur asg info loop '||l_proc,5);
1014:
1015: check_career_paths(p_per_in_ler_id => p_per_in_ler_id,
1016: p_person_id => l_pil_info_rec.person_id,
1017: p_business_group_id => l_pil_info_rec.business_group_id,

Line 1032: hr_utility.set_location('Leaving from '||l_proc,5);

1028: end loop;
1029:
1030: g_business_group_id := null;
1031:
1032: hr_utility.set_location('Leaving from '||l_proc,5);
1033:
1034:
1035: end get_elctbl_chc_career_path;
1036: