DBA Data[Home] [Help]

APPS.BEN_PER_ASG_ELIG dependencies on HR_UTILITY

Line 126: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');

122:
123: if p_person_id is null and
124: p_assignment_id is null then
125:
126: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
127: hr_utility.set_message_token('API_NAME', l_proc);
128: hr_utility.set_message_token('ARGUMENT', 'person_id,assignment_id');
129: hr_utility.raise_error;
130:

Line 127: hr_utility.set_message_token('API_NAME', l_proc);

123: if p_person_id is null and
124: p_assignment_id is null then
125:
126: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
127: hr_utility.set_message_token('API_NAME', l_proc);
128: hr_utility.set_message_token('ARGUMENT', 'person_id,assignment_id');
129: hr_utility.raise_error;
130:
131: end if;

Line 128: hr_utility.set_message_token('ARGUMENT', 'person_id,assignment_id');

124: p_assignment_id is null then
125:
126: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
127: hr_utility.set_message_token('API_NAME', l_proc);
128: hr_utility.set_message_token('ARGUMENT', 'person_id,assignment_id');
129: hr_utility.raise_error;
130:
131: end if;
132:

Line 129: hr_utility.raise_error;

125:
126: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
127: hr_utility.set_message_token('API_NAME', l_proc);
128: hr_utility.set_message_token('ARGUMENT', 'person_id,assignment_id');
129: hr_utility.raise_error;
130:
131: end if;
132:
133: if p_person_id is null and

Line 136: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');

132:
133: if p_person_id is null and
134: p_assignment_type is not null then
135:
136: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
137: hr_utility.set_message_token('API_NAME', l_proc);
138: hr_utility.set_message_token('ARGUMENT', 'person_id');
139: hr_utility.raise_error;
140:

Line 137: hr_utility.set_message_token('API_NAME', l_proc);

133: if p_person_id is null and
134: p_assignment_type is not null then
135:
136: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
137: hr_utility.set_message_token('API_NAME', l_proc);
138: hr_utility.set_message_token('ARGUMENT', 'person_id');
139: hr_utility.raise_error;
140:
141: end if;

Line 138: hr_utility.set_message_token('ARGUMENT', 'person_id');

134: p_assignment_type is not null then
135:
136: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
137: hr_utility.set_message_token('API_NAME', l_proc);
138: hr_utility.set_message_token('ARGUMENT', 'person_id');
139: hr_utility.raise_error;
140:
141: end if;
142:

Line 139: hr_utility.raise_error;

135:
136: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
137: hr_utility.set_message_token('API_NAME', l_proc);
138: hr_utility.set_message_token('ARGUMENT', 'person_id');
139: hr_utility.raise_error;
140:
141: end if;
142:
143: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 166: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');

162: open c_chk_ebo;
163: fetch c_chk_ebo into l_dummy;
164: if c_chk_ebo%notfound then
165: close c_chk_ebo;
166: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
167: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_obj_f');
168: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
169: hr_utility.raise_error;
170: end if;

Line 167: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_obj_f');

163: fetch c_chk_ebo into l_dummy;
164: if c_chk_ebo%notfound then
165: close c_chk_ebo;
166: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
167: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_obj_f');
168: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
169: hr_utility.raise_error;
170: end if;
171: close c_chk_ebo;

Line 168: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));

164: if c_chk_ebo%notfound then
165: close c_chk_ebo;
166: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
167: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_obj_f');
168: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
169: hr_utility.raise_error;
170: end if;
171: close c_chk_ebo;
172:

Line 169: hr_utility.raise_error;

165: close c_chk_ebo;
166: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
167: hr_utility.set_message_token('TABLE_NAME', 'ben_elig_obj_f');
168: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
169: hr_utility.raise_error;
170: end if;
171: close c_chk_ebo;
172:
173: open c_elig_prof;

Line 206: hr_utility.set_location('person_id is null and no assignment found',10);

202: fetch c_asg into l_person_id;
203: close c_asg;
204:
205: if l_person_id is null then
206: hr_utility.set_location('person_id is null and no assignment found',10);
207: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
209: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
210: hr_utility.raise_error;

Line 207: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');

203: close c_asg;
204:
205: if l_person_id is null then
206: hr_utility.set_location('person_id is null and no assignment found',10);
207: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
209: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
210: hr_utility.raise_error;
211: end if;

Line 208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

204:
205: if l_person_id is null then
206: hr_utility.set_location('person_id is null and no assignment found',10);
207: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
209: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
210: hr_utility.raise_error;
211: end if;
212: else

Line 209: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));

205: if l_person_id is null then
206: hr_utility.set_location('person_id is null and no assignment found',10);
207: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
209: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
210: hr_utility.raise_error;
211: end if;
212: else
213: l_person_id := p_person_id;

Line 210: hr_utility.raise_error;

206: hr_utility.set_location('person_id is null and no assignment found',10);
207: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
209: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
210: hr_utility.raise_error;
211: end if;
212: else
213: l_person_id := p_person_id;
214: end if;

Line 234: hr_utility.set_location('Assignment id '||l_asg_tab(i),10);

230:
231: for i in 1..l_loop_count
232: loop
233:
234: hr_utility.set_location('Assignment id '||l_asg_tab(i),10);
235: if l_eligprof_tab.count > 0 then
236:
237: ben_manage_life_events.g_output_string := null;
238:

Line 253: hr_utility.set_location('Score Tab '||l_score_tab.count,10);

249: else
250: l_eligible := true;
251: end if;
252:
253: hr_utility.set_location('Score Tab '||l_score_tab.count,10);
254: if l_eligible then
255: l_elig_flag := 'Y';
256: else
257: l_elig_flag := 'N';

Line 492: hr_utility.set_location('entering elp_eligible',10);

488: hr_api.mandatory_arg_error(p_api_name => l_proc,
489: p_argument => 'effective_date',
490: p_argument_value => p_effective_date);
491:
492: hr_utility.set_location('entering elp_eligible',10);
493: hr_utility.set_location('p_pl_id '||p_pl_id,10);
494: hr_utility.set_location('p_node_pl_id '||p_node_pl_id,10);
495: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
496: hr_utility.set_location('p_eligy_prfl_id '||p_eligy_prfl_id,10);

Line 493: hr_utility.set_location('p_pl_id '||p_pl_id,10);

489: p_argument => 'effective_date',
490: p_argument_value => p_effective_date);
491:
492: hr_utility.set_location('entering elp_eligible',10);
493: hr_utility.set_location('p_pl_id '||p_pl_id,10);
494: hr_utility.set_location('p_node_pl_id '||p_node_pl_id,10);
495: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
496: hr_utility.set_location('p_eligy_prfl_id '||p_eligy_prfl_id,10);
497:

Line 494: hr_utility.set_location('p_node_pl_id '||p_node_pl_id,10);

490: p_argument_value => p_effective_date);
491:
492: hr_utility.set_location('entering elp_eligible',10);
493: hr_utility.set_location('p_pl_id '||p_pl_id,10);
494: hr_utility.set_location('p_node_pl_id '||p_node_pl_id,10);
495: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
496: hr_utility.set_location('p_eligy_prfl_id '||p_eligy_prfl_id,10);
497:
498: if p_pl_id <> p_node_pl_id then

Line 495: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

491:
492: hr_utility.set_location('entering elp_eligible',10);
493: hr_utility.set_location('p_pl_id '||p_pl_id,10);
494: hr_utility.set_location('p_node_pl_id '||p_node_pl_id,10);
495: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
496: hr_utility.set_location('p_eligy_prfl_id '||p_eligy_prfl_id,10);
497:
498: if p_pl_id <> p_node_pl_id then
499: return 'N';

Line 496: hr_utility.set_location('p_eligy_prfl_id '||p_eligy_prfl_id,10);

492: hr_utility.set_location('entering elp_eligible',10);
493: hr_utility.set_location('p_pl_id '||p_pl_id,10);
494: hr_utility.set_location('p_node_pl_id '||p_node_pl_id,10);
495: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
496: hr_utility.set_location('p_eligy_prfl_id '||p_eligy_prfl_id,10);
497:
498: if p_pl_id <> p_node_pl_id then
499: return 'N';
500: end if;