71: l_effective_date date;
72: l_language_code varchar2(30);
73:
74: begin
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76: --
77: -- Issue a savepoint
78: --
79: savepoint CREATE_RECRUITING_SITE;
87: --
88: -- Call Before Process User Hook
89: --
90: begin
91: hr_utility.set_location(l_proc, 20);
92: IRC_RECRUITING_SITES_BK1.CREATE_RECRUITING_SITE_B
93: (p_effective_date => p_effective_date
94: ,p_language_code => l_language_code
95: ,p_site_name => p_site_name
138: ,p_attribute29 => p_attribute29
139: ,p_attribute30 => p_attribute30
140: ,p_posting_impl_class => p_posting_impl_class
141: );
142: hr_utility.set_location(l_proc, 30);
143: exception
144: when hr_api.cannot_find_prog_unit then
145: hr_api.cannot_find_prog_unit_error
146: (p_module_name => 'CREATE_RECRUITING_SITE'
152: --
153: --
154: -- Process Logic
155: --
156: hr_utility.set_location(l_proc, 40);
157: irc_rse_ins.ins
158: (p_effective_date => l_effective_date
159: ,p_date_from => p_date_from
160: ,p_date_to => p_date_to
215: if (p_posting_password is not null) then
216: fnd_vault.put('IRC_SITE',l_recruiting_site_id,p_posting_password);
217: end if;
218:
219: hr_utility.set_location(l_proc, 50);
220: -- Call After Process User Hook
221: --
222: begin
223: IRC_RECRUITING_SITES_BK1.CREATE_RECRUITING_SITE_A
271: ,p_attribute30 => p_attribute30
272: ,p_recruiting_site_id => l_recruiting_site_id
273: ,p_posting_impl_class => p_posting_impl_class
274: );
275: hr_utility.set_location(l_proc, 60);
276: exception
277: when hr_api.cannot_find_prog_unit then
278: hr_api.cannot_find_prog_unit_error
279: (p_module_name => 'CREATE_RECRUITING_SITE'
291: --
292: p_object_version_number := l_object_version_number;
293: p_recruiting_site_id := l_recruiting_site_id;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 70);
296: exception
297: when hr_api.validate_enabled then
298: --
299: -- As the Validate_Enabled exception has been raised
309: -- Reset IN OUT parameters and set OUT parameters
310: --
311: p_recruiting_site_id := null;
312: p_object_version_number := null;
313: hr_utility.set_location(' Leaving:'||l_proc, 80);
314: when others then
315: --
316: -- A validation or unexpected error has occured
317: --
321: -- Reset IN OUT parameters and set OUT parameters
322: --
323: p_recruiting_site_id := null;
324: p_object_version_number := null;
325: hr_utility.set_location(' Leaving:'||l_proc, 90);
326: raise;
327: end CREATE_RECRUITING_SITE;
328: --
329: -- ----------------------------------------------------------------------------
392: l_language_code varchar2(30);
393: l_object_version_number number := p_object_version_number;
394: BEGIN
395: --
396: hr_utility.set_location('Entering:'|| l_proc, 10);
397: --
398: -- Issue a savepoint
399: --
400: savepoint UPDATE_RECRUITING_SITE;
614: -- Set all output arguments
615: --
616: --
617: p_object_version_number := l_object_version_number;
618: hr_utility.set_location(' Leaving:'||l_proc, 70);
619: exception
620: when hr_api.validate_enabled then
621: --
622: -- As the Validate_Enabled exception has been raised
631: --
632: -- Reset IN OUT parameters and set OUT parameters
633: --
634: p_object_version_number := l_object_version_number;
635: hr_utility.set_location(' Leaving:'||l_proc, 80);
636: when others then
637: --
638: -- A validation or unexpected error has occured
639: --
641: --
642: -- Reset IN OUT parameters and set OUT parameters
643: --
644: p_object_version_number := l_object_version_number;
645: hr_utility.set_location(' Leaving:'||l_proc, 90);
646: raise;
647: end UPDATE_RECRUITING_SITE;
648: --
649: -- ----------------------------------------------------------------------------
660: --
661: l_proc varchar2(72) := g_package||'DELETE_RECRUITING_SITE';
662: --
663: begin
664: hr_utility.set_location('Entering:'|| l_proc, 10);
665: --
666: -- Issue a savepoint
667: --
668: savepoint DELETE_RECRUITING_SITE;
736: --
737: -- Set all output arguments
738: --
739: --
740: hr_utility.set_location(' Leaving:'||l_proc, 70);
741: exception
742: when hr_api.validate_enabled then
743: --
744: -- As the Validate_Enabled exception has been raised
750: -- (Any key or derived arguments must be set to null
751: -- when validation only mode is being used.)
752: --
753: --
754: hr_utility.set_location(' Leaving:'||l_proc, 80);
755: when others then
756: --
757: -- A validation or unexpected error has occured
758: --
756: --
757: -- A validation or unexpected error has occured
758: --
759: rollback to DELETE_RECRUITING_SITE;
760: hr_utility.set_location(' Leaving:'||l_proc, 90);
761: raise;
762: end DELETE_RECRUITING_SITE;
763: --
764: end IRC_RECRUITING_SITES_API;