APPS.PQH_PEI_DDF dependencies on HR_UTILITY

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

119: --
120: l_eit_name varchar2(240);
121: --
122: Begin
123: hr_utility.set_location('Entering:'||l_proc, 5);
124:
125: if NVL(p_information_type,'X') = 'PQH_ROLE_USERS' then
126: --
127: chk_default_role

Line 141: hr_utility.set_message(8302, 'PQH_CWK_EXTRA_INFO_NOT_ALLOWED');

137: if hr_general2.is_person_type(p_person_id, 'CWK', hr_general.effective_date) then
138: for each_rec in get_eit_name(p_information_type) loop
139: l_eit_name := each_rec.descriptive_flex_context_name;
140: end loop;
141: hr_utility.set_message(8302, 'PQH_CWK_EXTRA_INFO_NOT_ALLOWED');
142: hr_utility.set_message_token('EIT', l_eit_name);
143: hr_utility.raise_error;
144: end if;
145: end if;

Line 142: hr_utility.set_message_token('EIT', l_eit_name);

138: for each_rec in get_eit_name(p_information_type) loop
139: l_eit_name := each_rec.descriptive_flex_context_name;
140: end loop;
141: hr_utility.set_message(8302, 'PQH_CWK_EXTRA_INFO_NOT_ALLOWED');
142: hr_utility.set_message_token('EIT', l_eit_name);
143: hr_utility.raise_error;
144: end if;
145: end if;
146:

Line 143: hr_utility.raise_error;

139: l_eit_name := each_rec.descriptive_flex_context_name;
140: end loop;
141: hr_utility.set_message(8302, 'PQH_CWK_EXTRA_INFO_NOT_ALLOWED');
142: hr_utility.set_message_token('EIT', l_eit_name);
143: hr_utility.raise_error;
144: end if;
145: end if;
146:
147: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

143: hr_utility.raise_error;
144: end if;
145: end if;
146:
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148:
149: Exception
150: WHEN others THEN
151: raise;

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

183: AND person_id = p_person_id
184: AND NVL(pei_information4,'N') = 'Y';
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: -- check if the same role is being assigned more then once to the same person
190: --
191: OPEN csr_duplicate_role;

Line 199: hr_utility.set_message(8302,'PQH_DUPLICATE_ROLE');

195: IF l_role_id IS NOT NULL THEN
196: --
197: -- raise error
198: --
199: hr_utility.set_message(8302,'PQH_DUPLICATE_ROLE');
200: hr_utility.raise_error;
201:
202: END IF; -- role id is not null
203: --

Line 200: hr_utility.raise_error;

196: --
197: -- raise error
198: --
199: hr_utility.set_message(8302,'PQH_DUPLICATE_ROLE');
200: hr_utility.raise_error;
201:
202: END IF; -- role id is not null
203: --
204: -- check if the person already has a default role

Line 216: hr_utility.set_message(8302,'PQH_MANY_DEFAULT_ROLES');

212: IF l_role_id IS NOT NULL THEN
213: --
214: -- raise error
215: --
216: hr_utility.set_message(8302,'PQH_MANY_DEFAULT_ROLES');
217: hr_utility.raise_error;
218:
219: END IF; -- role id is not null
220:

Line 217: hr_utility.raise_error;

213: --
214: -- raise error
215: --
216: hr_utility.set_message(8302,'PQH_MANY_DEFAULT_ROLES');
217: hr_utility.raise_error;
218:
219: END IF; -- role id is not null
220:
221: END IF; -- current role is default

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

219: END IF; -- role id is not null
220:
221: END IF; -- current role is default
222:
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224:
225: Exception
226: WHEN others THEN
227: raise;