DBA Data[Home] [Help]

APPS.HR_FI_PERSON_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: peperfii.pkb 120.1.12000000.2 2007/02/14 12:29:01 dbehera noship $ */
3:
4: -- Package Variables
5: g_package VARCHAR2(33) := 'hr_fi_person_api.';
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: procedure update_fi_person
9: (p_validate in boolean default false
10: ,p_effective_date in date

Line 165: hr_utility.trace_on(null,'X');

161: and c_effective_date
162: between per.effective_start_date and per.effective_end_date;
163: --
164: begin
165: hr_utility.trace_on(null,'X');
166: l_proc:= g_package||'update_fi_person';
167: if g_debug then
168: hr_utility.set_location('Entering:'|| l_proc, 5);
169: end if;

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

164: begin
165: hr_utility.trace_on(null,'X');
166: l_proc:= g_package||'update_fi_person';
167: if g_debug then
168: hr_utility.set_location('Entering:'|| l_proc, 5);
169: end if;
170: --
171: -- Initialise local variables
172: --

Line 183: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

179: open check_legislation(p_person_id, l_effective_date);
180: fetch check_legislation into l_legislation_code;
181: if check_legislation%notfound then
182: close check_legislation;
183: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
184: hr_utility.raise_error;
185: end if;
186: close check_legislation;
187: if g_debug then

Line 184: hr_utility.raise_error;

180: fetch check_legislation into l_legislation_code;
181: if check_legislation%notfound then
182: close check_legislation;
183: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
184: hr_utility.raise_error;
185: end if;
186: close check_legislation;
187: if g_debug then
188: hr_utility.set_location(l_proc, 20);

Line 188: hr_utility.set_location(l_proc, 20);

184: hr_utility.raise_error;
185: end if;
186: close check_legislation;
187: if g_debug then
188: hr_utility.set_location(l_proc, 20);
189: end if;
190: --
191: -- Check that the legislation of the specified business group is 'FI'.
192: --

Line 194: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

190: --
191: -- Check that the legislation of the specified business group is 'FI'.
192: --
193: if l_legislation_code <> 'FI' then
194: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
195: hr_utility.set_message_token('LEG_CODE','FI');
196: hr_utility.raise_error;
197: end if;
198:

Line 195: hr_utility.set_message_token('LEG_CODE','FI');

191: -- Check that the legislation of the specified business group is 'FI'.
192: --
193: if l_legislation_code <> 'FI' then
194: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
195: hr_utility.set_message_token('LEG_CODE','FI');
196: hr_utility.raise_error;
197: end if;
198:
199: if p_membership_start_date is not null and p_membership_end_date is not null and

Line 196: hr_utility.raise_error;

192: --
193: if l_legislation_code <> 'FI' then
194: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
195: hr_utility.set_message_token('LEG_CODE','FI');
196: hr_utility.raise_error;
197: end if;
198:
199: if p_membership_start_date is not null and p_membership_end_date is not null and
200: p_membership_start_date > p_membership_end_date then

Line 201: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');

197: end if;
198:
199: if p_membership_start_date is not null and p_membership_end_date is not null and
200: p_membership_start_date > p_membership_end_date then
201: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
202: hr_utility.set_message_token('LEG_CODE','FI');
203: hr_utility.raise_error;
204: end if;
205:

Line 202: hr_utility.set_message_token('LEG_CODE','FI');

198:
199: if p_membership_start_date is not null and p_membership_end_date is not null and
200: p_membership_start_date > p_membership_end_date then
201: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
202: hr_utility.set_message_token('LEG_CODE','FI');
203: hr_utility.raise_error;
204: end if;
205:
206:

Line 203: hr_utility.raise_error;

199: if p_membership_start_date is not null and p_membership_end_date is not null and
200: p_membership_start_date > p_membership_end_date then
201: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
202: hr_utility.set_message_token('LEG_CODE','FI');
203: hr_utility.raise_error;
204: end if;
205:
206:
207: if g_debug then

Line 208: hr_utility.set_location(l_proc, 30);

204: end if;
205:
206:
207: if g_debug then
208: hr_utility.set_location(l_proc, 30);
209: end if;
210: --
211: -- Update the person record using the update_person
212: --

Line 350: hr_utility.set_location(' Leaving:'||l_proc, 7);

346: ,p_orig_hire_warning => p_orig_hire_warning
347: );
348: --
349: if g_debug then
350: hr_utility.set_location(' Leaving:'||l_proc, 7);
351: end if;
352: --
353: end update_fi_person;
354: