[Home] [Help]
PACKAGE BODY: APPS.HR_FORM_CANVASES_API
Source
1 Package Body hr_form_canvases_api as
2 /* $Header: hrfcnapi.pkb 115.4 2003/09/24 02:02:48 bsubrama noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_form_canvases_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------< create_form_canvas >--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_form_canvas
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_language_code in varchar2 default hr_api.userenv_lang
16 ,p_form_window_id in number
17 ,p_canvas_name in varchar2
18 ,p_canvas_type in varchar2
19 ,p_user_canvas_name in varchar2
20 ,p_description in varchar2 default null
21 ,p_height in number default null
22 ,p_visible in number default null
23 ,p_width in number default null
24 ,p_x_position in number default null
25 ,p_y_position in number default null
26 ,p_information_category in varchar2 default null
27 ,p_information1 in varchar2 default null
28 ,p_information2 in varchar2 default null
29 ,p_information3 in varchar2 default null
30 ,p_information4 in varchar2 default null
31 ,p_information5 in varchar2 default null
32 ,p_information6 in varchar2 default null
33 ,p_information7 in varchar2 default null
34 ,p_information8 in varchar2 default null
35 ,p_information9 in varchar2 default null
36 ,p_information10 in varchar2 default null
37 ,p_information11 in varchar2 default null
38 ,p_information12 in varchar2 default null
39 ,p_information13 in varchar2 default null
40 ,p_information14 in varchar2 default null
41 ,p_information15 in varchar2 default null
42 ,p_information16 in varchar2 default null
43 ,p_information17 in varchar2 default null
44 ,p_information18 in varchar2 default null
45 ,p_information19 in varchar2 default null
46 ,p_information20 in varchar2 default null
47 ,p_information21 in varchar2 default null
48 ,p_information22 in varchar2 default null
49 ,p_information23 in varchar2 default null
50 ,p_information24 in varchar2 default null
51 ,p_information25 in varchar2 default null
52 ,p_information26 in varchar2 default null
53 ,p_information27 in varchar2 default null
54 ,p_information28 in varchar2 default null
55 ,p_information29 in varchar2 default null
56 ,p_information30 in varchar2 default null
57 ,p_form_canvas_id out nocopy number
58 ,p_object_version_number out nocopy number)
59 is
60 --
61 -- Declare cursors and local variables
62 --
63
64 CURSOR cur_form_window
65 IS
66 SELECT NVL(p_height,fwn.height)
67 ,NVL(p_width,fwn.width)
68 FROM hr_form_windows fwn
69 WHERE fwn.form_window_id = p_form_window_id;
70
71 l_proc varchar2(72) := g_package||'create_form_canvas';
72 l_form_canvas_id number;
73 l_canvas_property_id number;
74 l_object_version_number number;
75
76 l_language_code fnd_languages.language_code%TYPE;
77 l_height number;
78 l_width number;
79 begin
80 hr_utility.set_location('Entering:'|| l_proc, 10);
81 --
82 -- Issue a savepoint
83 --
84 savepoint create_form_canvas;
85 --
86 -- Truncate the time portion from all IN date parameters
87 --
88 -- p_effective_date := TRUNC(p_effective_date);
89 --
90 -- Validate the language parameter. l_language_code should be passed
91 -- instead of p_language_code from now on, to allow an IN OUT parameter to
92 -- be passed through.
93 --
94 l_language_code := p_language_code;
95 hr_api.validate_language_code(p_language_code => l_language_code);
96 --
97 hr_utility.set_location(l_proc, 20);
98 --
99 -- Call Before Process User Hook
100 --
101 begin
102
103 hr_form_canvases_api_bk1.create_form_canvas_b
104 (p_effective_date => TRUNC(p_effective_date)
105 ,p_language_code => l_language_code
106 ,p_form_window_id => p_form_window_id
107 ,p_canvas_name => p_canvas_name
108 ,p_canvas_type => p_canvas_type
109 ,p_user_canvas_name => p_user_canvas_name
110 ,p_description => p_description
111 ,p_height => p_height
112 ,p_visible => p_visible
113 ,p_width => p_width
114 ,p_x_position => p_x_position
115 ,p_y_position => p_y_position
116 ,p_information_category => p_information_category
117 ,p_information1 => p_information1
118 ,p_information2 => p_information2
119 ,p_information3 => p_information3
120 ,p_information4 => p_information4
121 ,p_information5 => p_information5
122 ,p_information6 => p_information6
123 ,p_information7 => p_information7
124 ,p_information8 => p_information8
125 ,p_information9 => p_information9
126 ,p_information10 => p_information10
127 ,p_information11 => p_information11
128 ,p_information12 => p_information12
129 ,p_information13 => p_information13
130 ,p_information14 => p_information14
131 ,p_information15 => p_information15
132 ,p_information16 => p_information16
133 ,p_information17 => p_information17
134 ,p_information18 => p_information18
135 ,p_information19 => p_information19
136 ,p_information20 => p_information20
137 ,p_information21 => p_information21
138 ,p_information22 => p_information22
139 ,p_information23 => p_information23
140 ,p_information24 => p_information24
141 ,p_information25 => p_information25
142 ,p_information26 => p_information26
143 ,p_information27 => p_information27
144 ,p_information28 => p_information28
145 ,p_information29 => p_information29
146 ,p_information30 => p_information30);
147 exception
148 when hr_api.cannot_find_prog_unit then
149 hr_api.cannot_find_prog_unit_error
150 (p_module_name => 'create_form_canvas'
151 ,p_hook_type => 'BP'
152 );
153 end;
154
155 --
156 -- Process Logic
157 --
158
159 hr_utility.set_location('At:'|| l_proc, 20);
160
161 hr_fcn_ins.ins(
162 p_effective_date => TRUNC(p_effective_date)
163 ,p_form_window_id => p_form_window_id
164 ,p_canvas_name => p_canvas_name
165 ,p_canvas_type => p_canvas_type
166 ,p_form_canvas_id => l_form_canvas_id
167 ,p_object_version_number => l_object_version_number);
168
169 hr_utility.set_location('At:'|| l_proc, 25);
170
171 hr_fct_ins.ins_tl(
172 --p_effective_date => TRUNC(p_effective_date)
173 p_language_code => l_language_code
174 ,p_form_canvas_id => l_form_canvas_id
175 ,p_user_canvas_name => p_user_canvas_name
176 ,p_description => p_description);
177
178 hr_utility.set_location('At:'|| l_proc, 30);
179
180 IF p_canvas_type = 'CONTENT' then
181 OPEN cur_form_window;
182 FETCH cur_form_window into l_height , l_width;
183 CLOSE cur_form_window;
184 END IF;
185
186 hr_utility.set_location('At:'|| l_proc, 40);
187
188 hr_canvas_properties_bsi.create_canvas_property(
189 p_effective_date => TRUNC(p_effective_date)
190 ,p_form_canvas_id => l_form_canvas_id
191 ,p_height => l_height
192 ,p_visible => p_visible
193 ,p_width => l_width
194 ,p_x_position => p_x_position
195 ,p_y_position => p_y_position
196 ,p_information_category => p_information_category
197 ,p_information1 => p_information1
198 ,p_information2 => p_information2
199 ,p_information3 => p_information3
200 ,p_information4 => p_information4
201 ,p_information5 => p_information5
202 ,p_information6 => p_information6
203 ,p_information7 => p_information7
204 ,p_information8 => p_information8
205 ,p_information9 => p_information9
206 ,p_information10 => p_information10
207 ,p_information11 => p_information11
208 ,p_information12 => p_information12
209 ,p_information13 => p_information13
210 ,p_information14 => p_information14
211 ,p_information15 => p_information15
212 ,p_information16 => p_information16
213 ,p_information17 => p_information17
214 ,p_information18 => p_information18
215 ,p_information19 => p_information19
216 ,p_information20 => p_information20
217 ,p_information21 => p_information21
218 ,p_information22 => p_information22
219 ,p_information23 => p_information23
220 ,p_information24 => p_information24
221 ,p_information25 => p_information25
222 ,p_information26 => p_information26
223 ,p_information27 => p_information27
224 ,p_information28 => p_information28
225 ,p_information29 => p_information29
226 ,p_information30 => p_information30
227 ,p_canvas_property_id => l_canvas_property_id
228 ,p_object_version_number => l_object_version_number);
229
230 --
231 -- Call After Process User Hook
232 --
233 hr_utility.set_location('At:'|| l_proc, 45);
234
235
236 begin
237
238 hr_form_canvases_api_bk1.create_form_canvas_a
239 (p_effective_date => TRUNC(p_effective_date)
240 ,p_language_code => l_language_code
241 ,p_form_window_id => p_form_window_id
242 ,p_canvas_name => p_canvas_name
243 ,p_canvas_type => p_canvas_type
244 ,p_user_canvas_name => p_user_canvas_name
245 ,p_description => p_description
246 ,p_height => p_height
247 ,p_visible => p_visible
248 ,p_width => p_width
249 ,p_x_position => p_x_position
250 ,p_y_position => p_y_position
251 ,p_information_category => p_information_category
252 ,p_information1 => p_information1
253 ,p_information2 => p_information2
254 ,p_information3 => p_information3
255 ,p_information4 => p_information4
256 ,p_information5 => p_information5
257 ,p_information6 => p_information6
258 ,p_information7 => p_information7
259 ,p_information8 => p_information8
260 ,p_information9 => p_information9
261 ,p_information10 => p_information10
262 ,p_information11 => p_information11
263 ,p_information12 => p_information12
264 ,p_information13 => p_information13
265 ,p_information14 => p_information14
266 ,p_information15 => p_information15
267 ,p_information16 => p_information16
268 ,p_information17 => p_information17
269 ,p_information18 => p_information18
270 ,p_information19 => p_information19
271 ,p_information20 => p_information20
272 ,p_information21 => p_information21
273 ,p_information22 => p_information22
274 ,p_information23 => p_information23
275 ,p_information24 => p_information24
276 ,p_information25 => p_information25
277 ,p_information26 => p_information26
278 ,p_information27 => p_information27
279 ,p_information28 => p_information28
280 ,p_information29 => p_information29
281 ,p_information30 => p_information30
282 ,p_form_canvas_id => l_form_canvas_id
283 ,p_object_version_number => l_object_version_number);
284 exception
285 when hr_api.cannot_find_prog_unit then
286 hr_api.cannot_find_prog_unit_error
287 (p_module_name => 'create_form_canvas'
288 ,p_hook_type => 'AP'
289 );
290 end;
291
292 hr_utility.set_location('At:'|| l_proc, 50);
293
294 --
295 -- When in validation only mode raise the Validate_Enabled exception
296 --
297 if p_validate then
298 raise hr_api.validate_enabled;
299 end if;
300 --
301 -- Set all output arguments
302 --
303 p_form_canvas_id := l_form_canvas_id;
304 p_object_version_number := l_object_version_number;
305 --
306 hr_utility.set_location(' Leaving:'||l_proc, 70);
307 exception
308 when hr_api.validate_enabled then
309 --
310 -- As the Validate_Enabled exception has been raised
311 -- we must rollback to the savepoint
312 --
313 rollback to create_form_canvas;
314 --
315 -- Only set output warning arguments
316 -- (Any key or derived arguments must be set to null
317 -- when validation only mode is being used.)
318 --
319 p_form_canvas_id := null;
320 p_object_version_number := null;
321 hr_utility.set_location(' Leaving:'||l_proc, 80);
322 when others then
323 --
324 -- A validation or unexpected error has occured
325 --
326
327 rollback to create_form_canvas;
328 -- Reset out parameters
329 p_form_canvas_id := null;
330 p_object_version_number := null;
331 hr_utility.set_location(' Leaving:'||l_proc, 90);
332 raise;
333 end create_form_canvas;
334 --
335 -- ----------------------------------------------------------------------------
336 -- |--------------------------< delete_form_canvas >--------------------------|
337 -- ----------------------------------------------------------------------------
338 --
339 procedure delete_form_canvas
340 (p_validate in boolean default false
341 ,p_form_canvas_id in number
342 ,p_object_version_number in number)
343 is
344 --
345 -- Declare cursors and local variables
346 --
347
348 l_proc varchar2(72) := g_package||'delete_form_canvas';
349 begin
350 hr_utility.set_location('Entering:'|| l_proc, 10);
351 --
352 -- Issue a savepoint
353 --
354 savepoint delete_form_canvas;
355 --
356 -- Call Before Process User Hook
357 --
358 begin
359
360 hr_form_canvases_api_bk2.delete_form_canvas_b
361 (p_form_canvas_id => p_form_canvas_id
362 ,p_object_version_number => p_object_version_number);
363 exception
364 when hr_api.cannot_find_prog_unit then
365 hr_api.cannot_find_prog_unit_error
366 (p_module_name => 'delete_form_canvas'
367 ,p_hook_type => 'BP'
368 );
369 end;
370 --
371 -- Process Logic
372 --
373 hr_utility.set_location('At:'|| l_proc, 20);
374
375 hr_fcn_shd.lck(
376 p_form_canvas_id => p_form_canvas_id
377 ,p_object_version_number => p_object_version_number);
378
379 hr_utility.set_location('At:'|| l_proc, 25);
380
381 hr_canvas_properties_bsi.delete_canvas_property(
382 p_form_canvas_id => p_form_canvas_id
383 ,p_object_version_number => p_object_version_number);
384
385 hr_utility.set_location('At:'|| l_proc, 30);
386
387 hr_fct_del.del_tl(p_form_canvas_id => p_form_canvas_id );
388
389 hr_utility.set_location('At:'|| l_proc, 35);
390
391 hr_fcn_del.del(p_form_canvas_id => p_form_canvas_id
392 ,p_object_version_number => p_object_version_number);
393
394 hr_utility.set_location('At:'|| l_proc, 40);
395
396 --
397 -- Call After Process User Hook
398 --
399 begin
400
401 hr_form_canvases_api_bk2.delete_form_canvas_a
402 (p_form_canvas_id => p_form_canvas_id
403 ,p_object_version_number => p_object_version_number);
404
405 exception
406 when hr_api.cannot_find_prog_unit then
407 hr_api.cannot_find_prog_unit_error
408 (p_module_name => 'delete_form_canvas'
409 ,p_hook_type => 'AP'
410 );
411 end;
412 --
413 -- When in validation only mode raise the Validate_Enabled exception
414 --
415 hr_utility.set_location('At:'|| l_proc, 45);
416
417 if p_validate then
418 raise hr_api.validate_enabled;
419 end if;
420 --
421 hr_utility.set_location(' Leaving:'||l_proc, 70);
422 exception
423 when hr_api.validate_enabled then
424 --
425 -- As the Validate_Enabled exception has been raised
426 -- we must rollback to the savepoint
427 --
428 rollback to delete_form_canvas;
429 --
430 hr_utility.set_location(' Leaving:'||l_proc, 80);
431 when others then
432 --
433 -- A validation or unexpected error has occured
434 --
435 rollback to delete_form_canvas;
436 hr_utility.set_location(' Leaving:'||l_proc, 90);
437 raise;
438 end delete_form_canvas;
439 --
440 -- ----------------------------------------------------------------------------
441 -- |--------------------------< update_form_canvas >--------------------------|
442 -- ----------------------------------------------------------------------------
443 --
444 procedure update_form_canvas
445 (p_validate in boolean default false
446 ,p_effective_date in date
447 ,p_language_code in varchar2 default hr_api.userenv_lang
448 ,p_form_canvas_id in number
449 ,p_object_version_number in out nocopy number
450 ,p_canvas_name in varchar2 default hr_api.g_varchar2
451 --,p_canvas_type in varchar2 default hr_api.g_varchar2
452 ,p_user_canvas_name in varchar2 default hr_api.g_varchar2
453 ,p_description in varchar2 default hr_api.g_varchar2
454 ,p_height in number default hr_api.g_number
455 ,p_visible in number default hr_api.g_number
456 ,p_width in number default hr_api.g_number
457 ,p_x_position in number default hr_api.g_number
458 ,p_y_position in number default hr_api.g_number
459 ,p_information_category in varchar2 default hr_api.g_varchar2
460 ,p_information1 in varchar2 default hr_api.g_varchar2
461 ,p_information2 in varchar2 default hr_api.g_varchar2
462 ,p_information3 in varchar2 default hr_api.g_varchar2
463 ,p_information4 in varchar2 default hr_api.g_varchar2
464 ,p_information5 in varchar2 default hr_api.g_varchar2
465 ,p_information6 in varchar2 default hr_api.g_varchar2
466 ,p_information7 in varchar2 default hr_api.g_varchar2
467 ,p_information8 in varchar2 default hr_api.g_varchar2
468 ,p_information9 in varchar2 default hr_api.g_varchar2
469 ,p_information10 in varchar2 default hr_api.g_varchar2
470 ,p_information11 in varchar2 default hr_api.g_varchar2
471 ,p_information12 in varchar2 default hr_api.g_varchar2
472 ,p_information13 in varchar2 default hr_api.g_varchar2
473 ,p_information14 in varchar2 default hr_api.g_varchar2
474 ,p_information15 in varchar2 default hr_api.g_varchar2
475 ,p_information16 in varchar2 default hr_api.g_varchar2
476 ,p_information17 in varchar2 default hr_api.g_varchar2
477 ,p_information18 in varchar2 default hr_api.g_varchar2
478 ,p_information19 in varchar2 default hr_api.g_varchar2
479 ,p_information20 in varchar2 default hr_api.g_varchar2
480 ,p_information21 in varchar2 default hr_api.g_varchar2
481 ,p_information22 in varchar2 default hr_api.g_varchar2
482 ,p_information23 in varchar2 default hr_api.g_varchar2
483 ,p_information24 in varchar2 default hr_api.g_varchar2
484 ,p_information25 in varchar2 default hr_api.g_varchar2
485 ,p_information26 in varchar2 default hr_api.g_varchar2
486 ,p_information27 in varchar2 default hr_api.g_varchar2
487 ,p_information28 in varchar2 default hr_api.g_varchar2
488 ,p_information29 in varchar2 default hr_api.g_varchar2
489 ,p_information30 in varchar2 default hr_api.g_varchar2)
490 is
491 --
492 -- Declare cursors and local variables
493 --
494
495 l_language_code fnd_languages.language_code%TYPE;
496 l_proc varchar2(72) := g_package||'update_form_canvas';
497 l_object_version_number number;
498
499 l_temp_ovn number := p_object_version_number;
500 begin
501 hr_utility.set_location('Entering:'|| l_proc, 10);
502 --
503 -- Issue a savepoint
504 --
505 savepoint update_form_canvas;
506 --
507 -- Truncate the time portion from all IN date parameters
508 --
509 -- p_effective_date := TRUNC(p_effective_date);
510 l_object_version_number := p_object_version_number;
511 --
512 -- Validate the language parameter. l_language_code should be passed
513 -- instead of p_language_code from now on, to allow an IN OUT parameter to
514 -- be passed through.
515 --
516 l_language_code := p_language_code;
517 hr_api.validate_language_code(p_language_code => l_language_code);
518 --
519 hr_utility.set_location(l_proc, 20);
520 --
521 --
522 -- Call Before Process User Hook
523 --
524 begin
525
526 hr_form_canvases_api_bk3.update_form_canvas_b
527 (p_effective_date => TRUNC(p_effective_date)
528 ,p_language_code => l_language_code
529 ,p_canvas_name => p_canvas_name
530 --,p_canvas_type => p_canvas_type
531 ,p_user_canvas_name => p_user_canvas_name
532 ,p_description => p_description
533 ,p_height => p_height
534 ,p_visible => p_visible
535 ,p_width => p_width
536 ,p_x_position => p_x_position
537 ,p_y_position => p_y_position
538 ,p_information_category => p_information_category
539 ,p_information1 => p_information1
540 ,p_information2 => p_information2
541 ,p_information3 => p_information3
542 ,p_information4 => p_information4
543 ,p_information5 => p_information5
544 ,p_information6 => p_information6
545 ,p_information7 => p_information7
546 ,p_information8 => p_information8
547 ,p_information9 => p_information9
548 ,p_information10 => p_information10
549 ,p_information11 => p_information11
550 ,p_information12 => p_information12
551 ,p_information13 => p_information13
552 ,p_information14 => p_information14
553 ,p_information15 => p_information15
554 ,p_information16 => p_information16
555 ,p_information17 => p_information17
556 ,p_information18 => p_information18
557 ,p_information19 => p_information19
558 ,p_information20 => p_information20
559 ,p_information21 => p_information21
560 ,p_information22 => p_information22
561 ,p_information23 => p_information23
562 ,p_information24 => p_information24
563 ,p_information25 => p_information25
564 ,p_information26 => p_information26
565 ,p_information27 => p_information27
566 ,p_information28 => p_information28
567 ,p_information29 => p_information29
568 ,p_information30 => p_information30
569 ,p_form_canvas_id => p_form_canvas_id
570 ,p_object_version_number => l_object_version_number);
571
572 exception
573 when hr_api.cannot_find_prog_unit then
574 hr_api.cannot_find_prog_unit_error
575 (p_module_name => 'update_form_canvas'
576 ,p_hook_type => 'BP'
577 );
578 end;
579
580 --
581 -- Process Logic
582 --
583
584 hr_utility.set_location('At:'|| l_proc, 20);
585
586 hr_fcn_upd.upd(
587 p_effective_date => TRUNC(p_effective_date)
588 ,p_form_canvas_id => p_form_canvas_id
589 ,p_canvas_name => p_canvas_name
590 --,p_canvas_type => p_canvas_type
591 ,p_object_version_number => l_object_version_number);
592
593 hr_utility.set_location('At:'|| l_proc, 25);
594
595 hr_fct_upd.upd_tl(
596 --p_effective_date => TRUNC(p_effective_date)
597 p_language_code => l_language_code
598 ,p_form_canvas_id => p_form_canvas_id
599 ,p_user_canvas_name => p_user_canvas_name
600 ,p_description => p_description);
601
602 hr_utility.set_location('At:'|| l_proc, 30);
603
604 hr_canvas_properties_bsi.update_canvas_property(
605 p_effective_date => TRUNC(p_effective_date)
606 ,p_object_version_number => l_object_version_number
607 ,p_form_canvas_id => p_form_canvas_id
608 ,p_height => p_height
609 ,p_visible => p_visible
610 ,p_width => p_width
611 ,p_x_position => p_x_position
612 ,p_y_position => p_y_position
613 ,p_information_category => p_information_category
614 ,p_information1 => p_information1
615 ,p_information2 => p_information2
616 ,p_information3 => p_information3
617 ,p_information4 => p_information4
618 ,p_information5 => p_information5
619 ,p_information6 => p_information6
620 ,p_information7 => p_information7
621 ,p_information8 => p_information8
622 ,p_information9 => p_information9
623 ,p_information10 => p_information10
624 ,p_information11 => p_information11
625 ,p_information12 => p_information12
626 ,p_information13 => p_information13
627 ,p_information14 => p_information14
628 ,p_information15 => p_information15
629 ,p_information16 => p_information16
630 ,p_information17 => p_information17
631 ,p_information18 => p_information18
632 ,p_information19 => p_information19
633 ,p_information20 => p_information20
634 ,p_information21 => p_information21
635 ,p_information22 => p_information22
636 ,p_information23 => p_information23
637 ,p_information24 => p_information24
638 ,p_information25 => p_information25
639 ,p_information26 => p_information26
640 ,p_information27 => p_information27
641 ,p_information28 => p_information28
642 ,p_information29 => p_information29
643 ,p_information30 => p_information30);
644
645 hr_utility.set_location('At:'|| l_proc, 35);
646
647 --
648 -- Call After Process User Hook
649 --
650 begin
651
652 hr_form_canvases_api_bk3.update_form_canvas_a
653 (p_effective_date => TRUNC(p_effective_date)
654 ,p_language_code => l_language_code
655 ,p_canvas_name => p_canvas_name
656 --,p_canvas_type => p_canvas_type
657 ,p_user_canvas_name => p_user_canvas_name
658 ,p_description => p_description
659 ,p_height => p_height
660 ,p_visible => p_visible
661 ,p_width => p_width
662 ,p_x_position => p_x_position
663 ,p_y_position => p_y_position
664 ,p_information_category => p_information_category
665 ,p_information1 => p_information1
666 ,p_information2 => p_information2
667 ,p_information3 => p_information3
668 ,p_information4 => p_information4
669 ,p_information5 => p_information5
670 ,p_information6 => p_information6
671 ,p_information7 => p_information7
672 ,p_information8 => p_information8
673 ,p_information9 => p_information9
674 ,p_information10 => p_information10
675 ,p_information11 => p_information11
676 ,p_information12 => p_information12
677 ,p_information13 => p_information13
678 ,p_information14 => p_information14
679 ,p_information15 => p_information15
680 ,p_information16 => p_information16
681 ,p_information17 => p_information17
682 ,p_information18 => p_information18
683 ,p_information19 => p_information19
684 ,p_information20 => p_information20
685 ,p_information21 => p_information21
686 ,p_information22 => p_information22
687 ,p_information23 => p_information23
688 ,p_information24 => p_information24
689 ,p_information25 => p_information25
690 ,p_information26 => p_information26
691 ,p_information27 => p_information27
692 ,p_information28 => p_information28
693 ,p_information29 => p_information29
694 ,p_information30 => p_information30
695 ,p_form_canvas_id => p_form_canvas_id
696 ,p_object_version_number => l_object_version_number);
697
698 exception
699 when hr_api.cannot_find_prog_unit then
700 hr_api.cannot_find_prog_unit_error
701 (p_module_name => 'update_form_canvas'
702 ,p_hook_type => 'AP'
703 );
704 end;
705
706 hr_utility.set_location('At:'|| l_proc, 40);
707
708 --
709 -- When in validation only mode raise the Validate_Enabled exception
710 --
711 if p_validate then
712 raise hr_api.validate_enabled;
713 end if;
714 --
715 -- Set all output arguments
716 --
717 p_object_version_number := l_object_version_number;
718 --
719 hr_utility.set_location(' Leaving:'||l_proc, 70);
720 exception
721 when hr_api.validate_enabled then
722 --
723 -- As the Validate_Enabled exception has been raised
724 -- we must rollback to the savepoint
725 --
726 rollback to update_form_canvas;
727 --
728 -- Only set output warning arguments
729 -- (Any key or derived arguments must be set to null
730 -- when validation only mode is being used.)
731 --
732 hr_utility.set_location(' Leaving:'||l_proc, 80);
733 when others then
734 --
735 -- A validation or unexpected error has occured
736 --
737 rollback to update_form_canvas;
738 -- Reset all output arguments
739 --
740 p_object_version_number := l_temp_ovn;
741 hr_utility.set_location(' Leaving:'||l_proc, 90);
742 raise;
743 end update_form_canvas;
744 --
745 end hr_form_canvases_api;