APPS.OTA_CERT_ENROLLMENT_API dependencies on HR_API

Line 107: when hr_api.cannot_find_prog_unit then

103: ,p_enrollment_date => p_enrollment_date
104: ,p_is_automatic_subscription =>p_is_automatic_subscription
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_cert_enrollment'
110: ,p_hook_type => 'BP'
111: );

Line 108: hr_api.cannot_find_prog_unit_error

104: ,p_is_automatic_subscription =>p_is_automatic_subscription
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_cert_enrollment'
110: ,p_hook_type => 'BP'
111: );
112: end;

Line 202: when hr_api.cannot_find_prog_unit then

198: ,p_is_automatic_subscription =>p_is_automatic_subscription
199: );
200:
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'CREATE_cert_enrollment'
205: ,p_hook_type => 'AP'
206: );

Line 203: hr_api.cannot_find_prog_unit_error

199: );
200:
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'CREATE_cert_enrollment'
205: ,p_hook_type => 'AP'
206: );
207: end;

Line 213: raise hr_api.validate_enabled;

209: --
210: -- When in validation only mode raise the Validate_Enabled exception
211: --
212: if p_validate then
213: raise hr_api.validate_enabled;
214: end if;
215:
216: hr_utility.set_location(' Leaving:'||l_proc, 70);
217: exception

Line 218: when hr_api.validate_enabled then

214: end if;
215:
216: hr_utility.set_location(' Leaving:'||l_proc, 70);
217: exception
218: when hr_api.validate_enabled then
219: --
220: -- As the Validate_Enabled exception has been raised
221: -- we must rollback to the savepoint
222: --

Line 251: ,p_person_id in number default hr_api.g_number

247: (p_effective_date in date
248: ,p_cert_enrollment_id in number
249: ,p_object_version_number in out nocopy number
250: ,p_certification_id in number
251: ,p_person_id in number default hr_api.g_number
252: ,p_contact_id in number default hr_api.g_number
253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date

Line 252: ,p_contact_id in number default hr_api.g_number

248: ,p_cert_enrollment_id in number
249: ,p_object_version_number in out nocopy number
250: ,p_certification_id in number
251: ,p_person_id in number default hr_api.g_number
252: ,p_contact_id in number default hr_api.g_number
253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date

Line 253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2

249: ,p_object_version_number in out nocopy number
250: ,p_certification_id in number
251: ,p_person_id in number default hr_api.g_number
252: ,p_contact_id in number default hr_api.g_number
253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date

Line 254: ,p_completion_date in date default hr_api.g_date

250: ,p_certification_id in number
251: ,p_person_id in number default hr_api.g_number
252: ,p_contact_id in number default hr_api.g_number
253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

Line 255: ,p_unenrollment_date in date default hr_api.g_date

251: ,p_person_id in number default hr_api.g_number
252: ,p_contact_id in number default hr_api.g_number
253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number

Line 256: ,p_expiration_date in date default hr_api.g_date

252: ,p_contact_id in number default hr_api.g_number
253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 257: ,p_earliest_enroll_date in date default hr_api.g_date

253: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2

254: ,p_completion_date in date default hr_api.g_date
255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 259: ,p_business_group_id in number default hr_api.g_number

255: ,p_unenrollment_date in date default hr_api.g_date
256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 260: ,p_attribute_category in varchar2 default hr_api.g_varchar2

256: ,p_expiration_date in date default hr_api.g_date
257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 261: ,p_attribute1 in varchar2 default hr_api.g_varchar2

257: ,p_earliest_enroll_date in date default hr_api.g_date
258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 262: ,p_attribute2 in varchar2 default hr_api.g_varchar2

258: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 263: ,p_attribute3 in varchar2 default hr_api.g_varchar2

259: ,p_business_group_id in number default hr_api.g_number
260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 264: ,p_attribute4 in varchar2 default hr_api.g_varchar2

260: ,p_attribute_category in varchar2 default hr_api.g_varchar2
261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 265: ,p_attribute5 in varchar2 default hr_api.g_varchar2

261: ,p_attribute1 in varchar2 default hr_api.g_varchar2
262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 266: ,p_attribute6 in varchar2 default hr_api.g_varchar2

262: ,p_attribute2 in varchar2 default hr_api.g_varchar2
263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 267: ,p_attribute7 in varchar2 default hr_api.g_varchar2

263: ,p_attribute3 in varchar2 default hr_api.g_varchar2
264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 268: ,p_attribute8 in varchar2 default hr_api.g_varchar2

264: ,p_attribute4 in varchar2 default hr_api.g_varchar2
265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 269: ,p_attribute9 in varchar2 default hr_api.g_varchar2

265: ,p_attribute5 in varchar2 default hr_api.g_varchar2
266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 270: ,p_attribute10 in varchar2 default hr_api.g_varchar2

266: ,p_attribute6 in varchar2 default hr_api.g_varchar2
267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 271: ,p_attribute11 in varchar2 default hr_api.g_varchar2

267: ,p_attribute7 in varchar2 default hr_api.g_varchar2
268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 272: ,p_attribute12 in varchar2 default hr_api.g_varchar2

268: ,p_attribute8 in varchar2 default hr_api.g_varchar2
269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 273: ,p_attribute13 in varchar2 default hr_api.g_varchar2

269: ,p_attribute9 in varchar2 default hr_api.g_varchar2
270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 274: ,p_attribute14 in varchar2 default hr_api.g_varchar2

270: ,p_attribute10 in varchar2 default hr_api.g_varchar2
271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 275: ,p_attribute15 in varchar2 default hr_api.g_varchar2

271: ,p_attribute11 in varchar2 default hr_api.g_varchar2
272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2
279: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 276: ,p_attribute16 in varchar2 default hr_api.g_varchar2

272: ,p_attribute12 in varchar2 default hr_api.g_varchar2
273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2
279: ,p_attribute19 in varchar2 default hr_api.g_varchar2
280: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 277: ,p_attribute17 in varchar2 default hr_api.g_varchar2

273: ,p_attribute13 in varchar2 default hr_api.g_varchar2
274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2
279: ,p_attribute19 in varchar2 default hr_api.g_varchar2
280: ,p_attribute20 in varchar2 default hr_api.g_varchar2
281: ,p_enrollment_date in date default hr_api.g_date

Line 278: ,p_attribute18 in varchar2 default hr_api.g_varchar2

274: ,p_attribute14 in varchar2 default hr_api.g_varchar2
275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2
279: ,p_attribute19 in varchar2 default hr_api.g_varchar2
280: ,p_attribute20 in varchar2 default hr_api.g_varchar2
281: ,p_enrollment_date in date default hr_api.g_date
282: ,p_validate in boolean default false

Line 279: ,p_attribute19 in varchar2 default hr_api.g_varchar2

275: ,p_attribute15 in varchar2 default hr_api.g_varchar2
276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2
279: ,p_attribute19 in varchar2 default hr_api.g_varchar2
280: ,p_attribute20 in varchar2 default hr_api.g_varchar2
281: ,p_enrollment_date in date default hr_api.g_date
282: ,p_validate in boolean default false
283: ) is

Line 280: ,p_attribute20 in varchar2 default hr_api.g_varchar2

276: ,p_attribute16 in varchar2 default hr_api.g_varchar2
277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2
279: ,p_attribute19 in varchar2 default hr_api.g_varchar2
280: ,p_attribute20 in varchar2 default hr_api.g_varchar2
281: ,p_enrollment_date in date default hr_api.g_date
282: ,p_validate in boolean default false
283: ) is
284: --

Line 281: ,p_enrollment_date in date default hr_api.g_date

277: ,p_attribute17 in varchar2 default hr_api.g_varchar2
278: ,p_attribute18 in varchar2 default hr_api.g_varchar2
279: ,p_attribute19 in varchar2 default hr_api.g_varchar2
280: ,p_attribute20 in varchar2 default hr_api.g_varchar2
281: ,p_enrollment_date in date default hr_api.g_date
282: ,p_validate in boolean default false
283: ) is
284: --
285: -- Declare cursors and local variables

Line 339: when hr_api.cannot_find_prog_unit then

335: ,p_enrollment_date => p_enrollment_date
336: );
337:
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'UPDATE_cert_enrollment'
342: ,p_hook_type => 'BP'
343: );

Line 340: hr_api.cannot_find_prog_unit_error

336: );
337:
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'UPDATE_cert_enrollment'
342: ,p_hook_type => 'BP'
343: );
344: end;

Line 431: when hr_api.cannot_find_prog_unit then

427: ,p_enrollment_date => p_enrollment_date
428: );
429:
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'UPDATE_cert_enrollment'
434: ,p_hook_type => 'AP'
435: );

Line 432: hr_api.cannot_find_prog_unit_error

428: );
429:
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'UPDATE_cert_enrollment'
434: ,p_hook_type => 'AP'
435: );
436: end;

Line 443: raise hr_api.validate_enabled;

439: --
440: -- When in validation only mode raise the Validate_Enabled exception
441: --
442: if p_validate then
443: raise hr_api.validate_enabled;
444: end if;
445: --
446: -- Set all output arguments
447: --

Line 452: when hr_api.validate_enabled then

448: p_object_version_number := l_object_version_number;
449:
450: hr_utility.set_location(' Leaving:'||l_proc, 70);
451: exception
452: when hr_api.validate_enabled then
453: --
454: -- As the Validate_Enabled exception has been raised
455: -- we must rollback to the savepoint
456: --

Line 521: when hr_api.cannot_find_prog_unit then

517: (p_cert_enrollment_id => p_cert_enrollment_id
518: ,p_object_version_number => p_object_version_number
519: );
520: exception
521: when hr_api.cannot_find_prog_unit then
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'DELETE_cert_enrollment'
524: ,p_hook_type => 'BP'
525: );

Line 522: hr_api.cannot_find_prog_unit_error

518: ,p_object_version_number => p_object_version_number
519: );
520: exception
521: when hr_api.cannot_find_prog_unit then
522: hr_api.cannot_find_prog_unit_error
523: (p_module_name => 'DELETE_cert_enrollment'
524: ,p_hook_type => 'BP'
525: );
526: end;

Line 546: when hr_api.cannot_find_prog_unit then

542: ,p_object_version_number => p_object_version_number
543: ,p_person_id => l_person_id
544: );
545: exception
546: when hr_api.cannot_find_prog_unit then
547: hr_api.cannot_find_prog_unit_error
548: (p_module_name => 'DELETE_cert_enrollment'
549: ,p_hook_type => 'AP'
550: );

Line 547: hr_api.cannot_find_prog_unit_error

543: ,p_person_id => l_person_id
544: );
545: exception
546: when hr_api.cannot_find_prog_unit then
547: hr_api.cannot_find_prog_unit_error
548: (p_module_name => 'DELETE_cert_enrollment'
549: ,p_hook_type => 'AP'
550: );
551: end;

Line 557: raise hr_api.validate_enabled;

553: --
554: -- When in validation only mode raise the Validate_Enabled exception
555: --
556: if p_validate then
557: raise hr_api.validate_enabled;
558: end if;
559: --
560: -- Set all output arguments
561: --

Line 565: when hr_api.validate_enabled then

561: --
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 170);
564: exception
565: when hr_api.validate_enabled then
566: --
567: -- As the Validate_Enabled exception has been raised
568: -- we must rollback to the savepoint
569: --

Line 1021: raise hr_api.validate_enabled;

1017:
1018:
1019:
1020: if p_validate then
1021: raise hr_api.validate_enabled;
1022: end if;
1023:
1024: exception
1025: when hr_api.validate_enabled then

Line 1025: when hr_api.validate_enabled then

1021: raise hr_api.validate_enabled;
1022: end if;
1023:
1024: exception
1025: when hr_api.validate_enabled then
1026: --
1027: --
1028: -- Catch the Multiple Message List exception which
1029: -- indicates API processing has been aborted because