[Home] [Help]
PACKAGE BODY: APPS.PQH_ACCOMMODATIONS_SWI
Source
1 Package Body pqh_accommodations_swi As
2 /* $Header: pqaccswi.pkb 115.1 2002/11/26 22:33:46 rpasapul noship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'pqh_accommodations_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-------------------------< create_accommodation >-------------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_accommodation
12 (p_validate in number default hr_api.g_false_num
13 ,p_effective_date in date
14 ,p_accommodation_name in varchar2
15 ,p_business_group_id in number
16 ,p_location_id in number
17 ,p_accommodation_desc in varchar2 default null
18 ,p_accommodation_type in varchar2 default null
19 ,p_style in varchar2 default null
20 ,p_address_line_1 in varchar2 default null
21 ,p_address_line_2 in varchar2 default null
22 ,p_address_line_3 in varchar2 default null
23 ,p_town_or_city in varchar2 default null
24 ,p_country in varchar2 default null
25 ,p_postal_code in varchar2 default null
26 ,p_region_1 in varchar2 default null
27 ,p_region_2 in varchar2 default null
28 ,p_region_3 in varchar2 default null
29 ,p_telephone_number_1 in varchar2 default null
30 ,p_telephone_number_2 in varchar2 default null
31 ,p_telephone_number_3 in varchar2 default null
32 ,p_floor_number in varchar2 default null
33 ,p_floor_area in number default null
34 ,p_floor_area_measure_unit in varchar2 default null
35 ,p_main_rooms in number default null
36 ,p_family_size in number default null
37 ,p_suitability_disabled in varchar2 default null
41 ,p_comments in varchar2 default null
38 ,p_rental_value in number default null
39 ,p_rental_value_currency in varchar2 default null
40 ,p_owner in varchar2 default null
42 ,p_information_category in varchar2 default null
43 ,p_information1 in varchar2 default null
44 ,p_information2 in varchar2 default null
45 ,p_information3 in varchar2 default null
46 ,p_information4 in varchar2 default null
47 ,p_information5 in varchar2 default null
48 ,p_information6 in varchar2 default null
49 ,p_information7 in varchar2 default null
50 ,p_information8 in varchar2 default null
51 ,p_information9 in varchar2 default null
52 ,p_information10 in varchar2 default null
53 ,p_information11 in varchar2 default null
54 ,p_information12 in varchar2 default null
55 ,p_information13 in varchar2 default null
56 ,p_information14 in varchar2 default null
57 ,p_information15 in varchar2 default null
58 ,p_information16 in varchar2 default null
59 ,p_information17 in varchar2 default null
60 ,p_information18 in varchar2 default null
61 ,p_information19 in varchar2 default null
62 ,p_information20 in varchar2 default null
63 ,p_information21 in varchar2 default null
64 ,p_information22 in varchar2 default null
65 ,p_information23 in varchar2 default null
66 ,p_information24 in varchar2 default null
67 ,p_information25 in varchar2 default null
68 ,p_information26 in varchar2 default null
69 ,p_information27 in varchar2 default null
70 ,p_information28 in varchar2 default null
71 ,p_information29 in varchar2 default null
72 ,p_information30 in varchar2 default null
73 ,p_attribute_category in varchar2 default null
74 ,p_attribute1 in varchar2 default null
75 ,p_attribute2 in varchar2 default null
76 ,p_attribute3 in varchar2 default null
77 ,p_attribute4 in varchar2 default null
78 ,p_attribute5 in varchar2 default null
79 ,p_attribute6 in varchar2 default null
80 ,p_attribute7 in varchar2 default null
81 ,p_attribute8 in varchar2 default null
82 ,p_attribute9 in varchar2 default null
83 ,p_attribute10 in varchar2 default null
84 ,p_attribute11 in varchar2 default null
85 ,p_attribute12 in varchar2 default null
86 ,p_attribute13 in varchar2 default null
87 ,p_attribute14 in varchar2 default null
88 ,p_attribute15 in varchar2 default null
89 ,p_attribute16 in varchar2 default null
90 ,p_attribute17 in varchar2 default null
91 ,p_attribute18 in varchar2 default null
92 ,p_attribute19 in varchar2 default null
93 ,p_attribute20 in varchar2 default null
94 ,p_attribute21 in varchar2 default null
95 ,p_attribute22 in varchar2 default null
96 ,p_attribute23 in varchar2 default null
97 ,p_attribute24 in varchar2 default null
98 ,p_attribute25 in varchar2 default null
99 ,p_attribute26 in varchar2 default null
100 ,p_attribute27 in varchar2 default null
101 ,p_attribute28 in varchar2 default null
102 ,p_attribute29 in varchar2 default null
103 ,p_attribute30 in varchar2 default null
104 ,p_accommodation_id out nocopy number
105 ,p_object_version_number out nocopy number
106 ,p_effective_start_date out nocopy date
107 ,p_effective_end_date out nocopy date
108 ,p_return_status out nocopy varchar2
109 ) is
110 --
111 -- Variables for API Boolean parameters
112 l_validate boolean;
113 --
114 -- Variables for IN/OUT parameters
115 --
116 -- Other variables
117 l_proc varchar2(72) := g_package ||'create_accommodation';
118 Begin
119 hr_utility.set_location(' Entering:' || l_proc,10);
120 --
121 -- Issue a savepoint
122 --
123 savepoint create_accommodation_swi;
124 --
125 -- Initialise Multiple Message Detection
126 --
127 hr_multi_message.enable_message_list;
128 --
129 -- Remember IN OUT parameter IN values
130 --
131 --
132 -- Convert constant values to their corresponding boolean value
133 --
134 l_validate :=
135 hr_api.constant_to_boolean
136 (p_constant_value => p_validate);
137 --
138 -- Register Surrogate ID or user key values
139 --
140 --
141 -- Call API
142 --
143 pqh_accommodations_api.create_accommodation
144 (p_validate => l_validate
145 ,p_effective_date => p_effective_date
146 ,p_accommodation_name => p_accommodation_name
150 ,p_accommodation_type => p_accommodation_type
147 ,p_business_group_id => p_business_group_id
148 ,p_location_id => p_location_id
149 ,p_accommodation_desc => p_accommodation_desc
151 ,p_style => p_style
152 ,p_address_line_1 => p_address_line_1
153 ,p_address_line_2 => p_address_line_2
154 ,p_address_line_3 => p_address_line_3
155 ,p_town_or_city => p_town_or_city
156 ,p_country => p_country
157 ,p_postal_code => p_postal_code
158 ,p_region_1 => p_region_1
159 ,p_region_2 => p_region_2
160 ,p_region_3 => p_region_3
161 ,p_telephone_number_1 => p_telephone_number_1
162 ,p_telephone_number_2 => p_telephone_number_2
163 ,p_telephone_number_3 => p_telephone_number_3
164 ,p_floor_number => p_floor_number
165 ,p_floor_area => p_floor_area
166 ,p_floor_area_measure_unit => p_floor_area_measure_unit
167 ,p_main_rooms => p_main_rooms
168 ,p_family_size => p_family_size
169 ,p_suitability_disabled => p_suitability_disabled
170 ,p_rental_value => p_rental_value
171 ,p_rental_value_currency => p_rental_value_currency
172 ,p_owner => p_owner
173 ,p_comments => p_comments
174 ,p_information_category => p_information_category
175 ,p_information1 => p_information1
176 ,p_information2 => p_information2
177 ,p_information3 => p_information3
178 ,p_information4 => p_information4
179 ,p_information5 => p_information5
180 ,p_information6 => p_information6
181 ,p_information7 => p_information7
182 ,p_information8 => p_information8
183 ,p_information9 => p_information9
184 ,p_information10 => p_information10
185 ,p_information11 => p_information11
186 ,p_information12 => p_information12
187 ,p_information13 => p_information13
188 ,p_information14 => p_information14
189 ,p_information15 => p_information15
190 ,p_information16 => p_information16
191 ,p_information17 => p_information17
192 ,p_information18 => p_information18
193 ,p_information19 => p_information19
194 ,p_information20 => p_information20
195 ,p_information21 => p_information21
196 ,p_information22 => p_information22
197 ,p_information23 => p_information23
198 ,p_information24 => p_information24
199 ,p_information25 => p_information25
200 ,p_information26 => p_information26
201 ,p_information27 => p_information27
202 ,p_information28 => p_information28
203 ,p_information29 => p_information29
204 ,p_information30 => p_information30
205 ,p_attribute_category => p_attribute_category
206 ,p_attribute1 => p_attribute1
207 ,p_attribute2 => p_attribute2
208 ,p_attribute3 => p_attribute3
209 ,p_attribute4 => p_attribute4
210 ,p_attribute5 => p_attribute5
211 ,p_attribute6 => p_attribute6
212 ,p_attribute7 => p_attribute7
213 ,p_attribute8 => p_attribute8
214 ,p_attribute9 => p_attribute9
215 ,p_attribute10 => p_attribute10
216 ,p_attribute11 => p_attribute11
217 ,p_attribute12 => p_attribute12
218 ,p_attribute13 => p_attribute13
219 ,p_attribute14 => p_attribute14
220 ,p_attribute15 => p_attribute15
221 ,p_attribute16 => p_attribute16
222 ,p_attribute17 => p_attribute17
223 ,p_attribute18 => p_attribute18
224 ,p_attribute19 => p_attribute19
225 ,p_attribute20 => p_attribute20
226 ,p_attribute21 => p_attribute21
227 ,p_attribute22 => p_attribute22
228 ,p_attribute23 => p_attribute23
229 ,p_attribute24 => p_attribute24
230 ,p_attribute25 => p_attribute25
231 ,p_attribute26 => p_attribute26
232 ,p_attribute27 => p_attribute27
233 ,p_attribute28 => p_attribute28
234 ,p_attribute29 => p_attribute29
235 ,p_attribute30 => p_attribute30
236 ,p_accommodation_id => p_accommodation_id
237 ,p_object_version_number => p_object_version_number
238 ,p_effective_start_date => p_effective_start_date
239 ,p_effective_end_date => p_effective_end_date
240 );
241 --
242 -- Convert API warning boolean parameter values to specific
243 -- messages and add them to Multiple Message List
244 --
245 --
246 -- Convert API non-warning boolean parameter values
247 --
248 --
249 -- Derive the API return status value based on whether
250 -- messages of any type exist in the Multiple Message List.
254 hr_utility.set_location(' Leaving:' || l_proc,20);
251 -- Also disable Multiple Message Detection.
252 --
253 p_return_status := hr_multi_message.get_return_status_disable;
255 --
256 exception
257 when hr_multi_message.error_message_exist then
258 --
259 -- Catch the Multiple Message List exception which
260 -- indicates API processing has been aborted because
261 -- at least one message exists in the list.
262 --
263 rollback to create_accommodation_swi;
264 --
265 -- Reset IN OUT parameters and set OUT parameters
266 --
267 p_accommodation_id := null;
268 p_object_version_number := null;
269 p_effective_start_date := null;
270 p_effective_end_date := null;
271 p_return_status := hr_multi_message.get_return_status_disable;
272 hr_utility.set_location(' Leaving:' || l_proc, 30);
273 when others then
274 --
275 -- When Multiple Message Detection is enabled catch
276 -- any Application specific or other unexpected
277 -- exceptions. Adding appropriate details to the
278 -- Multiple Message List. Otherwise re-raise the
279 -- error.
280 --
281 rollback to create_accommodation_swi;
282 if hr_multi_message.unexpected_error_add(l_proc) then
283 hr_utility.set_location(' Leaving:' || l_proc,40);
284 raise;
285 end if;
286 --
287 -- Reset IN OUT and set OUT parameters
288 --
289 p_accommodation_id := null;
290 p_object_version_number := null;
291 p_effective_start_date := null;
292 p_effective_end_date := null;
293 p_return_status := hr_multi_message.get_return_status_disable;
294 hr_utility.set_location(' Leaving:' || l_proc,50);
295 end create_accommodation;
296 -- ----------------------------------------------------------------------------
297 -- |-------------------------< delete_accommodation >-------------------------|
298 -- ----------------------------------------------------------------------------
299 PROCEDURE delete_accommodation
300 (p_validate in number default hr_api.g_false_num
301 ,p_effective_date in date
302 ,p_datetrack_mode in varchar2
303 ,p_accommodation_id in number
304 ,p_object_version_number in out nocopy number
305 ,p_effective_start_date out nocopy date
306 ,p_effective_end_date out nocopy date
307 ,p_return_status out nocopy varchar2
308 ) is
309 --
310 -- Variables for API Boolean parameters
311 l_validate boolean;
312 --
313 -- Variables for IN/OUT parameters
314 l_object_version_number number;
315 --
316 -- Other variables
317 l_proc varchar2(72) := g_package ||'delete_accommodation';
318 Begin
319 hr_utility.set_location(' Entering:' || l_proc,10);
320 --
321 -- Issue a savepoint
322 --
323 savepoint delete_accommodation_swi;
324 --
325 -- Initialise Multiple Message Detection
326 --
327 hr_multi_message.enable_message_list;
328 --
329 -- Remember IN OUT parameter IN values
330 --
331 l_object_version_number := p_object_version_number;
332 --
333 -- Convert constant values to their corresponding boolean value
334 --
335 l_validate :=
336 hr_api.constant_to_boolean
337 (p_constant_value => p_validate);
338 --
339 -- Register Surrogate ID or user key values
340 --
341 --
342 -- Call API
343 --
344 pqh_accommodations_api.delete_accommodation
345 (p_validate => l_validate
346 ,p_effective_date => p_effective_date
347 ,p_datetrack_mode => p_datetrack_mode
348 ,p_accommodation_id => p_accommodation_id
349 ,p_object_version_number => p_object_version_number
350 ,p_effective_start_date => p_effective_start_date
351 ,p_effective_end_date => p_effective_end_date
352 );
353 --
354 -- Convert API warning boolean parameter values to specific
355 -- messages and add them to Multiple Message List
356 --
357 --
358 -- Convert API non-warning boolean parameter values
359 --
360 --
361 -- Derive the API return status value based on whether
362 -- messages of any type exist in the Multiple Message List.
363 -- Also disable Multiple Message Detection.
364 --
365 p_return_status := hr_multi_message.get_return_status_disable;
366 hr_utility.set_location(' Leaving:' || l_proc,20);
367 --
368 exception
369 when hr_multi_message.error_message_exist then
370 --
371 -- Catch the Multiple Message List exception which
372 -- indicates API processing has been aborted because
373 -- at least one message exists in the list.
374 --
375 rollback to delete_accommodation_swi;
376 --
377 -- Reset IN OUT parameters and set OUT parameters
378 --
379 p_object_version_number := l_object_version_number;
380 p_effective_start_date := null;
381 p_effective_end_date := null;
382 p_return_status := hr_multi_message.get_return_status_disable;
383 hr_utility.set_location(' Leaving:' || l_proc, 30);
384 when others then
385 --
386 -- When Multiple Message Detection is enabled catch
387 -- any Application specific or other unexpected
388 -- exceptions. Adding appropriate details to the
389 -- Multiple Message List. Otherwise re-raise the
390 -- error.
391 --
392 rollback to delete_accommodation_swi;
393 if hr_multi_message.unexpected_error_add(l_proc) then
394 hr_utility.set_location(' Leaving:' || l_proc,40);
395 raise;
396 end if;
397 --
398 -- Reset IN OUT and set OUT parameters
399 --
400 p_object_version_number := l_object_version_number;
401 p_effective_start_date := null;
402 p_effective_end_date := null;
403 p_return_status := hr_multi_message.get_return_status_disable;
404 hr_utility.set_location(' Leaving:' || l_proc,50);
405 end delete_accommodation;
406 -- ----------------------------------------------------------------------------
407 -- |-------------------------< update_accommodation >-------------------------|
408 -- ----------------------------------------------------------------------------
409 PROCEDURE update_accommodation
410 (p_validate in number default hr_api.g_false_num
411 ,p_effective_date in date
412 ,p_datetrack_mode in varchar2
413 ,p_accommodation_id in number
414 ,p_object_version_number in out nocopy number
415 ,p_accommodation_name in varchar2 default hr_api.g_varchar2
416 ,p_business_group_id in number default hr_api.g_number
417 ,p_location_id in number default hr_api.g_number
418 ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419 ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420 ,p_style in varchar2 default hr_api.g_varchar2
421 ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422 ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423 ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424 ,p_town_or_city in varchar2 default hr_api.g_varchar2
425 ,p_country in varchar2 default hr_api.g_varchar2
426 ,p_postal_code in varchar2 default hr_api.g_varchar2
427 ,p_region_1 in varchar2 default hr_api.g_varchar2
428 ,p_region_2 in varchar2 default hr_api.g_varchar2
429 ,p_region_3 in varchar2 default hr_api.g_varchar2
430 ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431 ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432 ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433 ,p_floor_number in varchar2 default hr_api.g_varchar2
434 ,p_floor_area in number default hr_api.g_number
435 ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436 ,p_main_rooms in number default hr_api.g_number
437 ,p_family_size in number default hr_api.g_number
438 ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439 ,p_rental_value in number default hr_api.g_number
440 ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441 ,p_owner in varchar2 default hr_api.g_varchar2
442 ,p_comments in varchar2 default hr_api.g_varchar2
443 ,p_information_category in varchar2 default hr_api.g_varchar2
444 ,p_information1 in varchar2 default hr_api.g_varchar2
445 ,p_information2 in varchar2 default hr_api.g_varchar2
446 ,p_information3 in varchar2 default hr_api.g_varchar2
447 ,p_information4 in varchar2 default hr_api.g_varchar2
448 ,p_information5 in varchar2 default hr_api.g_varchar2
449 ,p_information6 in varchar2 default hr_api.g_varchar2
450 ,p_information7 in varchar2 default hr_api.g_varchar2
451 ,p_information8 in varchar2 default hr_api.g_varchar2
452 ,p_information9 in varchar2 default hr_api.g_varchar2
453 ,p_information10 in varchar2 default hr_api.g_varchar2
454 ,p_information11 in varchar2 default hr_api.g_varchar2
455 ,p_information12 in varchar2 default hr_api.g_varchar2
456 ,p_information13 in varchar2 default hr_api.g_varchar2
457 ,p_information14 in varchar2 default hr_api.g_varchar2
458 ,p_information15 in varchar2 default hr_api.g_varchar2
459 ,p_information16 in varchar2 default hr_api.g_varchar2
460 ,p_information17 in varchar2 default hr_api.g_varchar2
461 ,p_information18 in varchar2 default hr_api.g_varchar2
462 ,p_information19 in varchar2 default hr_api.g_varchar2
463 ,p_information20 in varchar2 default hr_api.g_varchar2
464 ,p_information21 in varchar2 default hr_api.g_varchar2
465 ,p_information22 in varchar2 default hr_api.g_varchar2
466 ,p_information23 in varchar2 default hr_api.g_varchar2
467 ,p_information24 in varchar2 default hr_api.g_varchar2
468 ,p_information25 in varchar2 default hr_api.g_varchar2
469 ,p_information26 in varchar2 default hr_api.g_varchar2
470 ,p_information27 in varchar2 default hr_api.g_varchar2
471 ,p_information28 in varchar2 default hr_api.g_varchar2
472 ,p_information29 in varchar2 default hr_api.g_varchar2
473 ,p_information30 in varchar2 default hr_api.g_varchar2
474 ,p_attribute_category in varchar2 default hr_api.g_varchar2
475 ,p_attribute1 in varchar2 default hr_api.g_varchar2
476 ,p_attribute2 in varchar2 default hr_api.g_varchar2
477 ,p_attribute3 in varchar2 default hr_api.g_varchar2
478 ,p_attribute4 in varchar2 default hr_api.g_varchar2
479 ,p_attribute5 in varchar2 default hr_api.g_varchar2
480 ,p_attribute6 in varchar2 default hr_api.g_varchar2
481 ,p_attribute7 in varchar2 default hr_api.g_varchar2
482 ,p_attribute8 in varchar2 default hr_api.g_varchar2
483 ,p_attribute9 in varchar2 default hr_api.g_varchar2
484 ,p_attribute10 in varchar2 default hr_api.g_varchar2
485 ,p_attribute11 in varchar2 default hr_api.g_varchar2
486 ,p_attribute12 in varchar2 default hr_api.g_varchar2
487 ,p_attribute13 in varchar2 default hr_api.g_varchar2
488 ,p_attribute14 in varchar2 default hr_api.g_varchar2
489 ,p_attribute15 in varchar2 default hr_api.g_varchar2
490 ,p_attribute16 in varchar2 default hr_api.g_varchar2
491 ,p_attribute17 in varchar2 default hr_api.g_varchar2
492 ,p_attribute18 in varchar2 default hr_api.g_varchar2
493 ,p_attribute19 in varchar2 default hr_api.g_varchar2
494 ,p_attribute20 in varchar2 default hr_api.g_varchar2
495 ,p_attribute21 in varchar2 default hr_api.g_varchar2
496 ,p_attribute22 in varchar2 default hr_api.g_varchar2
497 ,p_attribute23 in varchar2 default hr_api.g_varchar2
498 ,p_attribute24 in varchar2 default hr_api.g_varchar2
499 ,p_attribute25 in varchar2 default hr_api.g_varchar2
500 ,p_attribute26 in varchar2 default hr_api.g_varchar2
501 ,p_attribute27 in varchar2 default hr_api.g_varchar2
502 ,p_attribute28 in varchar2 default hr_api.g_varchar2
503 ,p_attribute29 in varchar2 default hr_api.g_varchar2
504 ,p_attribute30 in varchar2 default hr_api.g_varchar2
505 ,p_effective_start_date out nocopy date
506 ,p_effective_end_date out nocopy date
507 ,p_return_status out nocopy varchar2
508 ) is
509 --
510 -- Variables for API Boolean parameters
511 l_validate boolean;
512 --
513 -- Variables for IN/OUT parameters
514 l_object_version_number number;
515 --
516 -- Other variables
517 l_proc varchar2(72) := g_package ||'update_accommodation';
518 Begin
519 hr_utility.set_location(' Entering:' || l_proc,10);
520 --
521 -- Issue a savepoint
522 --
523 savepoint update_accommodation_swi;
524 --
525 -- Initialise Multiple Message Detection
526 --
527 hr_multi_message.enable_message_list;
528 --
529 -- Remember IN OUT parameter IN values
530 --
531 l_object_version_number := p_object_version_number;
532 --
533 -- Convert constant values to their corresponding boolean value
534 --
535 l_validate :=
536 hr_api.constant_to_boolean
537 (p_constant_value => p_validate);
538 --
539 -- Register Surrogate ID or user key values
540 --
541 --
542 -- Call API
543 --
544 pqh_accommodations_api.update_accommodation
545 (p_validate => l_validate
546 ,p_effective_date => p_effective_date
547 ,p_datetrack_mode => p_datetrack_mode
548 ,p_accommodation_id => p_accommodation_id
549 ,p_object_version_number => p_object_version_number
550 ,p_accommodation_name => p_accommodation_name
551 ,p_business_group_id => p_business_group_id
552 ,p_location_id => p_location_id
553 ,p_accommodation_desc => p_accommodation_desc
554 ,p_accommodation_type => p_accommodation_type
555 ,p_style => p_style
556 ,p_address_line_1 => p_address_line_1
557 ,p_address_line_2 => p_address_line_2
558 ,p_address_line_3 => p_address_line_3
559 ,p_town_or_city => p_town_or_city
560 ,p_country => p_country
561 ,p_postal_code => p_postal_code
562 ,p_region_1 => p_region_1
563 ,p_region_2 => p_region_2
564 ,p_region_3 => p_region_3
565 ,p_telephone_number_1 => p_telephone_number_1
566 ,p_telephone_number_2 => p_telephone_number_2
567 ,p_telephone_number_3 => p_telephone_number_3
568 ,p_floor_number => p_floor_number
569 ,p_floor_area => p_floor_area
570 ,p_floor_area_measure_unit => p_floor_area_measure_unit
571 ,p_main_rooms => p_main_rooms
572 ,p_family_size => p_family_size
573 ,p_suitability_disabled => p_suitability_disabled
574 ,p_rental_value => p_rental_value
575 ,p_rental_value_currency => p_rental_value_currency
576 ,p_owner => p_owner
577 ,p_comments => p_comments
578 ,p_information_category => p_information_category
579 ,p_information1 => p_information1
580 ,p_information2 => p_information2
581 ,p_information3 => p_information3
582 ,p_information4 => p_information4
583 ,p_information5 => p_information5
584 ,p_information6 => p_information6
585 ,p_information7 => p_information7
586 ,p_information8 => p_information8
587 ,p_information9 => p_information9
588 ,p_information10 => p_information10
589 ,p_information11 => p_information11
590 ,p_information12 => p_information12
591 ,p_information13 => p_information13
592 ,p_information14 => p_information14
593 ,p_information15 => p_information15
594 ,p_information16 => p_information16
595 ,p_information17 => p_information17
596 ,p_information18 => p_information18
597 ,p_information19 => p_information19
598 ,p_information20 => p_information20
599 ,p_information21 => p_information21
600 ,p_information22 => p_information22
601 ,p_information23 => p_information23
602 ,p_information24 => p_information24
603 ,p_information25 => p_information25
604 ,p_information26 => p_information26
605 ,p_information27 => p_information27
606 ,p_information28 => p_information28
607 ,p_information29 => p_information29
608 ,p_information30 => p_information30
609 ,p_attribute_category => p_attribute_category
610 ,p_attribute1 => p_attribute1
611 ,p_attribute2 => p_attribute2
612 ,p_attribute3 => p_attribute3
613 ,p_attribute4 => p_attribute4
614 ,p_attribute5 => p_attribute5
615 ,p_attribute6 => p_attribute6
616 ,p_attribute7 => p_attribute7
617 ,p_attribute8 => p_attribute8
618 ,p_attribute9 => p_attribute9
619 ,p_attribute10 => p_attribute10
620 ,p_attribute11 => p_attribute11
621 ,p_attribute12 => p_attribute12
622 ,p_attribute13 => p_attribute13
623 ,p_attribute14 => p_attribute14
624 ,p_attribute15 => p_attribute15
625 ,p_attribute16 => p_attribute16
626 ,p_attribute17 => p_attribute17
627 ,p_attribute18 => p_attribute18
628 ,p_attribute19 => p_attribute19
629 ,p_attribute20 => p_attribute20
630 ,p_attribute21 => p_attribute21
631 ,p_attribute22 => p_attribute22
632 ,p_attribute23 => p_attribute23
633 ,p_attribute24 => p_attribute24
634 ,p_attribute25 => p_attribute25
635 ,p_attribute26 => p_attribute26
636 ,p_attribute27 => p_attribute27
637 ,p_attribute28 => p_attribute28
638 ,p_attribute29 => p_attribute29
639 ,p_attribute30 => p_attribute30
640 ,p_effective_start_date => p_effective_start_date
641 ,p_effective_end_date => p_effective_end_date
642 );
643 --
644 -- Convert API warning boolean parameter values to specific
645 -- messages and add them to Multiple Message List
646 --
647 --
648 -- Convert API non-warning boolean parameter values
649 --
650 --
651 -- Derive the API return status value based on whether
652 -- messages of any type exist in the Multiple Message List.
653 -- Also disable Multiple Message Detection.
654 --
655 p_return_status := hr_multi_message.get_return_status_disable;
656 hr_utility.set_location(' Leaving:' || l_proc,20);
657 --
658 exception
659 when hr_multi_message.error_message_exist then
660 --
661 -- Catch the Multiple Message List exception which
662 -- indicates API processing has been aborted because
663 -- at least one message exists in the list.
664 --
665 rollback to update_accommodation_swi;
666 --
667 -- Reset IN OUT parameters and set OUT parameters
668 --
669 p_object_version_number := l_object_version_number;
670 p_effective_start_date := null;
671 p_effective_end_date := null;
672 p_return_status := hr_multi_message.get_return_status_disable;
673 hr_utility.set_location(' Leaving:' || l_proc, 30);
674 when others then
675 --
676 -- When Multiple Message Detection is enabled catch
677 -- any Application specific or other unexpected
678 -- exceptions. Adding appropriate details to the
679 -- Multiple Message List. Otherwise re-raise the
680 -- error.
681 --
682 rollback to update_accommodation_swi;
683 if hr_multi_message.unexpected_error_add(l_proc) then
684 hr_utility.set_location(' Leaving:' || l_proc,40);
685 raise;
686 end if;
687 --
688 -- Reset IN OUT and set OUT parameters
689 --
690 p_object_version_number := l_object_version_number;
691 p_effective_start_date := null;
692 p_effective_end_date := null;
693 p_return_status := hr_multi_message.get_return_status_disable;
694 hr_utility.set_location(' Leaving:' || l_proc,50);
695 end update_accommodation;
696 end pqh_accommodations_swi;