DBA Data[Home] [Help]

APPS.PER_AE_DISABILITY_API dependencies on HR_UTILITY

Line 90: hr_utility.set_location('Entering:'|| l_proc, 10);

86: where pbg.business_group_id = l_business_group_id;
87: --
88: begin
89:
90: hr_utility.set_location('Entering:'|| l_proc, 10);
91: --
92: -- Issue a savepoint if operating in validation only mode
93: --
94: savepoint create_ae_disability;

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

92: -- Issue a savepoint if operating in validation only mode
93: --
94: savepoint create_ae_disability;
95: --
96: hr_utility.set_location(l_proc, 20);
97: --
98: -- Process Logic
99: --
100: -- Get person details.

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

104: into l_business_group_id;
105: --
106: if csr_get_business_group_id%NOTFOUND then
107: close csr_get_business_group_id;
108: hr_utility.set_location(l_proc, 30);
109: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
110: hr_utility.raise_error;
111: end if;
112: close csr_get_business_group_id;

Line 109: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');

105: --
106: if csr_get_business_group_id%NOTFOUND then
107: close csr_get_business_group_id;
108: hr_utility.set_location(l_proc, 30);
109: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
110: hr_utility.raise_error;
111: end if;
112: close csr_get_business_group_id;
113: --

Line 110: hr_utility.raise_error;

106: if csr_get_business_group_id%NOTFOUND then
107: close csr_get_business_group_id;
108: hr_utility.set_location(l_proc, 30);
109: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
110: hr_utility.raise_error;
111: end if;
112: close csr_get_business_group_id;
113: --
114: hr_utility.set_location(l_proc, 40);

Line 114: hr_utility.set_location(l_proc, 40);

110: hr_utility.raise_error;
111: end if;
112: close csr_get_business_group_id;
113: --
114: hr_utility.set_location(l_proc, 40);
115: --
116: -- Check that the specified business group is valid.
117: --
118: open csr_bg;

Line 123: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

119: fetch csr_bg
120: into l_legislation_code;
121: if csr_bg%notfound then
122: close csr_bg;
123: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
124: hr_utility.raise_error;
125: end if;
126: close csr_bg;
127: hr_utility.set_location(l_proc, 50);

Line 124: hr_utility.raise_error;

120: into l_legislation_code;
121: if csr_bg%notfound then
122: close csr_bg;
123: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
124: hr_utility.raise_error;
125: end if;
126: close csr_bg;
127: hr_utility.set_location(l_proc, 50);
128: --

Line 127: hr_utility.set_location(l_proc, 50);

123: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
124: hr_utility.raise_error;
125: end if;
126: close csr_bg;
127: hr_utility.set_location(l_proc, 50);
128: --
129: -- Check that the legislation of the specified business group is 'AE'.
130: --
131: if l_legislation_code <> 'AE' then

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

128: --
129: -- Check that the legislation of the specified business group is 'AE'.
130: --
131: if l_legislation_code <> 'AE' then
132: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
133: hr_utility.set_message_token('LEG_CODE','AE');
134: hr_utility.raise_error;
135: end if;
136: hr_utility.set_location(l_proc, 60);

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

129: -- Check that the legislation of the specified business group is 'AE'.
130: --
131: if l_legislation_code <> 'AE' then
132: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
133: hr_utility.set_message_token('LEG_CODE','AE');
134: hr_utility.raise_error;
135: end if;
136: hr_utility.set_location(l_proc, 60);
137: --

Line 134: hr_utility.raise_error;

130: --
131: if l_legislation_code <> 'AE' then
132: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
133: hr_utility.set_message_token('LEG_CODE','AE');
134: hr_utility.raise_error;
135: end if;
136: hr_utility.set_location(l_proc, 60);
137: --
138: -- Call the disability business process

Line 136: hr_utility.set_location(l_proc, 60);

132: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
133: hr_utility.set_message_token('LEG_CODE','AE');
134: hr_utility.raise_error;
135: end if;
136: hr_utility.set_location(l_proc, 60);
137: --
138: -- Call the disability business process
139: --
140: per_disability_api.create_disability

Line 196: hr_utility.set_location(' Leaving:'||l_proc, 70);

192: ,p_object_version_number => p_object_version_number
193: ,p_effective_start_date => p_effective_start_date
194: ,p_effective_end_date => p_effective_end_date);
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 70);
197: --
198: end create_ae_disability;
199: --
200: -- ----------------------------------------------------------------------

Line 284: hr_utility.set_location('Entering:'|| l_proc, 10);

280: where pbg.business_group_id = l_business_group_id;
281: --
282: begin
283: --
284: hr_utility.set_location('Entering:'|| l_proc, 10);
285: --
286: -- Issue a savepoint if operating in validation only mode
287: --
288: savepoint update_ae_disability;

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

286: -- Issue a savepoint if operating in validation only mode
287: --
288: savepoint update_ae_disability;
289: --
290: hr_utility.set_location(l_proc, 20);
291: --
292: -- Process Logic
293: --
294: -- Get person details.

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

298: into l_business_group_id;
299: --
300: if csr_get_business_group_id%NOTFOUND then
301: close csr_get_business_group_id;
302: hr_utility.set_location(l_proc, 30);
303: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
304: hr_utility.raise_error;
305: end if;
306: close csr_get_business_group_id;

Line 303: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');

299: --
300: if csr_get_business_group_id%NOTFOUND then
301: close csr_get_business_group_id;
302: hr_utility.set_location(l_proc, 30);
303: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
304: hr_utility.raise_error;
305: end if;
306: close csr_get_business_group_id;
307: --

Line 304: hr_utility.raise_error;

300: if csr_get_business_group_id%NOTFOUND then
301: close csr_get_business_group_id;
302: hr_utility.set_location(l_proc, 30);
303: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
304: hr_utility.raise_error;
305: end if;
306: close csr_get_business_group_id;
307: --
308: hr_utility.set_location(l_proc, 40);

Line 308: hr_utility.set_location(l_proc, 40);

304: hr_utility.raise_error;
305: end if;
306: close csr_get_business_group_id;
307: --
308: hr_utility.set_location(l_proc, 40);
309: --
310: -- Check that the specified business group is valid.
311: --
312: open csr_bg;

Line 317: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

313: fetch csr_bg
314: into l_legislation_code;
315: if csr_bg%notfound then
316: close csr_bg;
317: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
318: hr_utility.raise_error;
319: end if;
320: close csr_bg;
321: --

Line 318: hr_utility.raise_error;

314: into l_legislation_code;
315: if csr_bg%notfound then
316: close csr_bg;
317: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
318: hr_utility.raise_error;
319: end if;
320: close csr_bg;
321: --
322: hr_utility.set_location(l_proc, 50);

Line 322: hr_utility.set_location(l_proc, 50);

318: hr_utility.raise_error;
319: end if;
320: close csr_bg;
321: --
322: hr_utility.set_location(l_proc, 50);
323: --
324: -- Check that the legislation of the specified business group is 'AE'.
325: --
326: if l_legislation_code <> 'AE' then

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

323: --
324: -- Check that the legislation of the specified business group is 'AE'.
325: --
326: if l_legislation_code <> 'AE' then
327: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
328: hr_utility.set_message_token('LEG_CODE','AE');
329: hr_utility.raise_error;
330: end if;
331: hr_utility.set_location(l_proc, 60);

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

324: -- Check that the legislation of the specified business group is 'AE'.
325: --
326: if l_legislation_code <> 'AE' then
327: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
328: hr_utility.set_message_token('LEG_CODE','AE');
329: hr_utility.raise_error;
330: end if;
331: hr_utility.set_location(l_proc, 60);
332: --

Line 329: hr_utility.raise_error;

325: --
326: if l_legislation_code <> 'AE' then
327: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
328: hr_utility.set_message_token('LEG_CODE','AE');
329: hr_utility.raise_error;
330: end if;
331: hr_utility.set_location(l_proc, 60);
332: --
333: -- Call the contract business process

Line 331: hr_utility.set_location(l_proc, 60);

327: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
328: hr_utility.set_message_token('LEG_CODE','AE');
329: hr_utility.raise_error;
330: end if;
331: hr_utility.set_location(l_proc, 60);
332: --
333: -- Call the contract business process
334: --
335: per_disability_api.update_disability

Line 391: hr_utility.set_location(' Leaving:'||l_proc, 70);

387: ,p_dis_information1 => p_relevant_to_social_security
388: ,p_effective_start_date => p_effective_start_date
389: ,p_effective_end_date => p_effective_end_date);
390: --
391: hr_utility.set_location(' Leaving:'||l_proc, 70);
392: --
393: end update_ae_disability;
394: --
395: end per_ae_disability_api;