155: p_cei_attribute19 => p_cei_attribute19,
156: p_cei_attribute20 => p_cei_attribute20
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_contact_extra_info'
162: ,p_hook_type => 'BP'
163: );
156: p_cei_attribute20 => p_cei_attribute20
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_contact_extra_info'
162: ,p_hook_type => 'BP'
163: );
164: end;
297: ,p_object_version_number => l_object_version_number
298: -- ,p_some_warning =>
299: );
300: exception
301: when hr_api.cannot_find_prog_unit then
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'create_contact_extra_info'
304: ,p_hook_type => 'AP'
305: );
298: -- ,p_some_warning =>
299: );
300: exception
301: when hr_api.cannot_find_prog_unit then
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'create_contact_extra_info'
304: ,p_hook_type => 'AP'
305: );
306: end;
307: --
308: -- When in validation only mode raise the Validate_Enabled exception
309: --
310: if p_validate then
311: raise hr_api.validate_enabled;
312: end if;
313: --
314: -- Set all output arguments
315: --
320: p_effective_end_date := l_effective_end_date;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
327: -- we must rollback to the savepoint
328: --
361: -- ,p_business_group_id in number
362: -- ,p_non_mandatory_arg in number default null
363: p_datetrack_update_mode IN VARCHAR2,
364: p_contact_extra_info_id IN NUMBER,
365: p_contact_relationship_id IN NUMBER DEFAULT hr_api.g_number,
366: p_information_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
367: p_object_version_number IN OUT NOCOPY NUMBER,
368: p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
362: -- ,p_non_mandatory_arg in number default null
363: p_datetrack_update_mode IN VARCHAR2,
364: p_contact_extra_info_id IN NUMBER,
365: p_contact_relationship_id IN NUMBER DEFAULT hr_api.g_number,
366: p_information_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
367: p_object_version_number IN OUT NOCOPY NUMBER,
368: p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
364: p_contact_extra_info_id IN NUMBER,
365: p_contact_relationship_id IN NUMBER DEFAULT hr_api.g_number,
366: p_information_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
367: p_object_version_number IN OUT NOCOPY NUMBER,
368: p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
365: p_contact_relationship_id IN NUMBER DEFAULT hr_api.g_number,
366: p_information_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
367: p_object_version_number IN OUT NOCOPY NUMBER,
368: p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
366: p_information_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
367: p_object_version_number IN OUT NOCOPY NUMBER,
368: p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
367: p_object_version_number IN OUT NOCOPY NUMBER,
368: p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
368: p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369: p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370: p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371: p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372: p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373: p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374: p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375: p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376: p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377: p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378: p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379: p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380: p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381: p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382: p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383: p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384: p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385: p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386: p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387: p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388: p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389: p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390: p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391: p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392: p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393: p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394: p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395: p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396: p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397: p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398: p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399: p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400: p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401: p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402: p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403: p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404: p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405: p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406: p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407: p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408: p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409: p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417: p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410: p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417: p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
418: p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411: p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417: p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
418: p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
419: p_cei_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412: p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417: p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
418: p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
419: p_cei_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
420: -- ,p_id out number
413: p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417: p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
418: p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
419: p_cei_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
420: -- ,p_id out number
421: -- ,p_object_version_number out number
414: p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417: p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
418: p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
419: p_cei_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
420: -- ,p_id out number
421: -- ,p_object_version_number out number
422: -- ,p_some_warning out boolean
415: p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416: p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417: p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
418: p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
419: p_cei_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
420: -- ,p_id out number
421: -- ,p_object_version_number out number
422: -- ,p_some_warning out boolean
423: p_effective_start_date OUT NOCOPY DATE,
507: p_cei_attribute20 => p_cei_attribute20,
508: p_object_version_number => p_object_version_number
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'update_contact_extra_info'
514: ,p_hook_type => 'BP'
515: );
508: p_object_version_number => p_object_version_number
509: );
510: exception
511: when hr_api.cannot_find_prog_unit then
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'update_contact_extra_info'
514: ,p_hook_type => 'BP'
515: );
516: end;
650: p_cei_attribute19 => p_cei_attribute19,
651: p_cei_attribute20 => p_cei_attribute20
652: );
653: exception
654: when hr_api.cannot_find_prog_unit then
655: hr_api.cannot_find_prog_unit_error
656: (p_module_name => 'update_contact_extra_info'
657: ,p_hook_type => 'AP'
658: );
651: p_cei_attribute20 => p_cei_attribute20
652: );
653: exception
654: when hr_api.cannot_find_prog_unit then
655: hr_api.cannot_find_prog_unit_error
656: (p_module_name => 'update_contact_extra_info'
657: ,p_hook_type => 'AP'
658: );
659: end;
660: --
661: -- When in validation only mode raise the Validate_Enabled exception
662: --
663: if p_validate then
664: raise hr_api.validate_enabled;
665: end if;
666: --
667: -- Set all output arguments
668: --
673: p_effective_end_date := l_effective_end_date;
674: --
675: hr_utility.set_location(' Leaving:'||l_proc, 70);
676: exception
677: when hr_api.validate_enabled then
678: --
679: -- As the Validate_Enabled exception has been raised
680: -- we must rollback to the savepoint
681: --
750: p_object_version_number => p_object_version_number,
751: p_datetrack_delete_mode => p_datetrack_delete_mode
752: );
753: exception
754: when hr_api.cannot_find_prog_unit then
755: hr_api.cannot_find_prog_unit_error
756: (p_module_name => 'delete_contact_extra_info'
757: ,p_hook_type => 'BP'
758: );
751: p_datetrack_delete_mode => p_datetrack_delete_mode
752: );
753: exception
754: when hr_api.cannot_find_prog_unit then
755: hr_api.cannot_find_prog_unit_error
756: (p_module_name => 'delete_contact_extra_info'
757: ,p_hook_type => 'BP'
758: );
759: end;
786: -- ,p_some_warning =>
787: p_datetrack_delete_mode => p_datetrack_delete_mode
788: );
789: exception
790: when hr_api.cannot_find_prog_unit then
791: hr_api.cannot_find_prog_unit_error
792: (p_module_name => 'delete_contact_extra_info_api'
793: ,p_hook_type => 'AP'
794: );
787: p_datetrack_delete_mode => p_datetrack_delete_mode
788: );
789: exception
790: when hr_api.cannot_find_prog_unit then
791: hr_api.cannot_find_prog_unit_error
792: (p_module_name => 'delete_contact_extra_info_api'
793: ,p_hook_type => 'AP'
794: );
795: end;
796: --
797: -- When in validation only mode raise the Validate_Enabled exception
798: --
799: if p_validate then
800: raise hr_api.validate_enabled;
801: end if;
802: --
803: -- Set all output arguments
804: --
809: p_effective_end_date := l_effective_end_date;
810: --
811: hr_utility.set_location(' Leaving:'||l_proc, 70);
812: exception
813: when hr_api.validate_enabled then
814: --
815: -- As the Validate_Enabled exception has been raised
816: -- we must rollback to the savepoint
817: --