DBA Data[Home] [Help]

APPS.HR_AE_PREVIOUS_EMPLOYMENT_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: pepemaei.pkb 120.0 2005/06/03 05:07:23 appldev noship $ */
3:
4: -- Package Variables
5: g_package VARCHAR2(33) := 'hr_ae_previous_employment_api.';
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: procedure create_ae_previous_employer
9: ( p_effective_date IN date
10: ,p_validate IN boolean default false

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

85: begin
86:
87: l_proc := g_package||'create_ae_previous_employer';
88: if g_debug then
89: hr_utility.set_location('Entering:'|| l_proc, 5);
90: end if;
91: --
92: -- Initialise local variables
93: --

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

100: open check_legislation(p_person_id, l_effective_date);
101: fetch check_legislation into l_legislation_code;
102: if check_legislation%notfound then
103: close check_legislation;
104: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
105: hr_utility.raise_error;
106: end if;
107: close check_legislation;
108: if g_debug then

Line 105: hr_utility.raise_error;

101: fetch check_legislation into l_legislation_code;
102: if check_legislation%notfound then
103: close check_legislation;
104: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
105: hr_utility.raise_error;
106: end if;
107: close check_legislation;
108: if g_debug then
109: hr_utility.set_location(l_proc, 20);

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

105: hr_utility.raise_error;
106: end if;
107: close check_legislation;
108: if g_debug then
109: hr_utility.set_location(l_proc, 20);
110: end if;
111: --
112: -- Check that the legislation of the specified business group is 'AE'.
113: --

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

111: --
112: -- Check that the legislation of the specified business group is 'AE'.
113: --
114: if l_legislation_code <> 'AE' then
115: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
116: hr_utility.set_message_token('LEG_CODE','AE');
117: hr_utility.raise_error;
118: end if;
119: if g_debug then

Line 116: hr_utility.set_message_token('LEG_CODE','AE');

112: -- Check that the legislation of the specified business group is 'AE'.
113: --
114: if l_legislation_code <> 'AE' then
115: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
116: hr_utility.set_message_token('LEG_CODE','AE');
117: hr_utility.raise_error;
118: end if;
119: if g_debug then
120: hr_utility.set_location(l_proc, 30);

Line 117: hr_utility.raise_error;

113: --
114: if l_legislation_code <> 'AE' then
115: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
116: hr_utility.set_message_token('LEG_CODE','AE');
117: hr_utility.raise_error;
118: end if;
119: if g_debug then
120: hr_utility.set_location(l_proc, 30);
121: end if;

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

116: hr_utility.set_message_token('LEG_CODE','AE');
117: hr_utility.raise_error;
118: end if;
119: if g_debug then
120: hr_utility.set_location(l_proc, 30);
121: end if;
122: --
123: -- Create the previous employer record using the create_previous_employer
124: --

Line 182: hr_utility.set_location(' Leaving:'||l_proc, 40);

178: );
179:
180: --
181: if g_debug then
182: hr_utility.set_location(' Leaving:'||l_proc, 40);
183: end if;
184: --
185: end create_ae_previous_employer;
186: --------------------------------------------------------------------------------- -

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

264: begin
265:
266: l_proc := g_package||'update_ae_previous_employer';
267: if g_debug then
268: hr_utility.set_location('Entering:'|| l_proc, 5);
269: end if;
270: --
271: -- Initialise local variables
272: --

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

279: open check_legislation(p_previous_employer_id, l_effective_date);
280: fetch check_legislation into l_legislation_code;
281: if check_legislation%notfound then
282: close check_legislation;
283: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
284: hr_utility.raise_error;
285: end if;
286: close check_legislation;
287: if g_debug then

Line 284: hr_utility.raise_error;

280: fetch check_legislation into l_legislation_code;
281: if check_legislation%notfound then
282: close check_legislation;
283: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
284: hr_utility.raise_error;
285: end if;
286: close check_legislation;
287: if g_debug then
288: hr_utility.set_location(l_proc, 20);

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

284: hr_utility.raise_error;
285: end if;
286: close check_legislation;
287: if g_debug then
288: hr_utility.set_location(l_proc, 20);
289: end if;
290: --
291: -- Check that the legislation of the specified business group is 'AE'.
292: --

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

290: --
291: -- Check that the legislation of the specified business group is 'AE'.
292: --
293: if l_legislation_code <> 'AE' then
294: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
295: hr_utility.set_message_token('LEG_CODE','AE');
296: hr_utility.raise_error;
297: end if;
298: if g_debug then

Line 295: hr_utility.set_message_token('LEG_CODE','AE');

291: -- Check that the legislation of the specified business group is 'AE'.
292: --
293: if l_legislation_code <> 'AE' then
294: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
295: hr_utility.set_message_token('LEG_CODE','AE');
296: hr_utility.raise_error;
297: end if;
298: if g_debug then
299: hr_utility.set_location(l_proc, 30);

Line 296: hr_utility.raise_error;

292: --
293: if l_legislation_code <> 'AE' then
294: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
295: hr_utility.set_message_token('LEG_CODE','AE');
296: hr_utility.raise_error;
297: end if;
298: if g_debug then
299: hr_utility.set_location(l_proc, 30);
300: end if;

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

295: hr_utility.set_message_token('LEG_CODE','AE');
296: hr_utility.raise_error;
297: end if;
298: if g_debug then
299: hr_utility.set_location(l_proc, 30);
300: end if;
301: --
302: -- Create the previous employer record using the create_previous_employer
303: --

Line 357: hr_utility.set_location(' Leaving:'||l_proc, 40);

353: ,p_object_version_number => p_object_version_number
354: );
355: --
356: if g_debug then
357: hr_utility.set_location(' Leaving:'||l_proc, 40);
358: end if;
359: --
360: end update_ae_previous_employer;
361: