67: l_object_version_number number;
68: l_language_code fnd_languages.language_code%TYPE;
69:
70: begin
71: hr_utility.set_location('Entering:'|| l_proc, 10);
72: --
73: -- Issue a savepoint
74: --
75: savepoint create_form_window;
84: --
85: l_language_code := p_language_code;
86: hr_api.validate_language_code(p_language_code => l_language_code);
87: --
88: hr_utility.set_location(l_proc, 20);
89: --
90: --
91: -- Call Before Process User Hook
92: --
145:
146: --
147: -- Process Logic
148: --
149: hr_utility.set_location('At:'|| l_proc, 15);
150:
151: hr_fwn_ins.ins( p_application_id => p_application_id
152: ,p_form_id => p_form_id
153: ,p_window_name => p_window_name
153: ,p_window_name => p_window_name
154: ,p_form_window_id => l_form_window_id
155: ,p_object_version_number => l_object_version_number);
156:
157: hr_utility.set_location('At:'|| l_proc, 20);
158:
159: hr_fwt_ins.ins_tl(p_language_code => l_language_code
160: ,p_form_window_id => l_form_window_id
161: ,p_user_window_name => p_user_window_name
160: ,p_form_window_id => l_form_window_id
161: ,p_user_window_name => p_user_window_name
162: ,p_description => p_description);
163:
164: hr_utility.set_location('At:'|| l_proc, 25);
165:
166: hr_window_properties_bsi.create_window_property(
167: p_effective_date => TRUNC(p_effective_date)
168: ,p_language_code => l_language_code
207:
208: --
209: -- Call After Process User Hook
210: --
211: hr_utility.set_location('At:'|| l_proc, 30);
212:
213: begin
214: hr_form_windows_api_bk1.create_form_window_a
215: (p_effective_date => TRUNC(p_effective_date)
264: (p_module_name => 'create_form_window'
265: ,p_hook_type => 'AP'
266: );
267: end;
268: hr_utility.set_location('At:'|| l_proc, 35);
269:
270: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
278: --
279: p_form_window_id := l_form_window_id;
280: p_object_version_number := l_object_version_number;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: exception
284: when hr_api.validate_enabled then
285: --
286: -- As the Validate_Enabled exception has been raised
293: -- when validation only mode is being used.)
294: --
295: p_form_window_id := null;
296: p_object_version_number := null;
297: hr_utility.set_location(' Leaving:'||l_proc, 80);
298: when others then
299: --
300: -- A validation or unexpected error has occured
301: --
302: rollback to create_form_window;
303: -- Set OUT parameters.
304: p_form_window_id := null;
305: p_object_version_number := null;
306: hr_utility.set_location(' Leaving:'||l_proc, 90);
307: raise;
308: end create_form_window;
309: --
310: -- ----------------------------------------------------------------------------
321: --
322:
323: l_proc varchar2(72) := g_package||'delete_form_window';
324: begin
325: hr_utility.set_location('Entering:'|| l_proc, 10);
326: --
327: -- Issue a savepoint
328: --
329: savepoint delete_form_window;
346: --
347: -- Process Logic
348: --
349:
350: hr_utility.set_location('At:'|| l_proc, 20);
351:
352: hr_fwn_shd.lck( p_form_window_id => p_form_window_id
353: ,p_object_version_number => p_object_version_number);
354:
351:
352: hr_fwn_shd.lck( p_form_window_id => p_form_window_id
353: ,p_object_version_number => p_object_version_number);
354:
355: hr_utility.set_location('At:'|| l_proc, 25);
356:
357: hr_window_properties_bsi.delete_window_property
358: (p_form_window_id => p_form_window_id);
359:
356:
357: hr_window_properties_bsi.delete_window_property
358: (p_form_window_id => p_form_window_id);
359:
360: hr_utility.set_location('At:'|| l_proc, 30);
361:
362: hr_fwt_del.del_tl( p_form_window_id => p_form_window_id);
363:
364: hr_utility.set_location('At:'|| l_proc, 40);
360: hr_utility.set_location('At:'|| l_proc, 30);
361:
362: hr_fwt_del.del_tl( p_form_window_id => p_form_window_id);
363:
364: hr_utility.set_location('At:'|| l_proc, 40);
365:
366: hr_fwn_del.del( p_form_window_id => p_form_window_id
367: ,p_object_version_number => p_object_version_number);
368:
365:
366: hr_fwn_del.del( p_form_window_id => p_form_window_id
367: ,p_object_version_number => p_object_version_number);
368:
369: hr_utility.set_location('At:'|| l_proc, 45);
370:
371: --
372: -- Call After Process User Hook
373: --
382: ,p_hook_type => 'AP'
383: );
384: end;
385:
386: hr_utility.set_location('At:'|| l_proc, 50);
387: --
388: -- When in validation only mode raise the Validate_Enabled exception
389: --
390: if p_validate then
390: if p_validate then
391: raise hr_api.validate_enabled;
392: end if;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: exception
396: when hr_api.validate_enabled then
397: --
398: -- As the Validate_Enabled exception has been raised
403: -- Only set output warning arguments
404: -- (Any key or derived arguments must be set to null
405: -- when validation only mode is being used.)
406: --
407: hr_utility.set_location(' Leaving:'||l_proc, 80);
408: when others then
409: --
410: -- A validation or unexpected error has occured
411: --
409: --
410: -- A validation or unexpected error has occured
411: --
412: rollback to delete_form_window;
413: hr_utility.set_location(' Leaving:'||l_proc, 90);
414: raise;
415: end delete_form_window;
416: --
417: -- ----------------------------------------------------------------------------
486: l_object_version_number number;
487: l_language_code fnd_languages.language_code%TYPE;
488: l_temp_ovn number := p_object_version_number;
489: begin
490: hr_utility.set_location('Entering:'|| l_proc, 10);
491: --
492: -- Issue a savepoint
493: --
494: savepoint update_form_window;
504: --
505: l_language_code := p_language_code;
506: hr_api.validate_language_code(p_language_code => l_language_code);
507: --
508: hr_utility.set_location(l_proc, 20);
509: --
510: --
511: -- Call Before Process User Hook
512: --
567:
568: --
569: -- Process Logic
570: --
571: hr_utility.set_location('At:'|| l_proc, 20);
572:
573: hr_fwn_upd.upd(p_form_window_id => p_form_window_id
574: --,p_application_id => p_application_id
575: --,p_form_id => p_form_id
575: --,p_form_id => p_form_id
576: ,p_window_name => p_window_name
577: ,p_object_version_number => l_object_version_number);
578:
579: hr_utility.set_location('At:'|| l_proc, 25);
580:
581: hr_fwt_upd.upd_tl(p_language_code => l_language_code
582: ,p_form_window_id => p_form_window_id
583: ,p_user_window_name => p_user_window_name
582: ,p_form_window_id => p_form_window_id
583: ,p_user_window_name => p_user_window_name
584: ,p_description => p_description);
585:
586: hr_utility.set_location('At:'|| l_proc, 30);
587:
588: hr_window_properties_bsi.update_window_property(
589: p_effective_date => TRUNC(p_effective_date)
590: ,p_language_code => l_language_code
625: ,p_information28 => p_information28
626: ,p_information29 => p_information29
627: ,p_information30 => p_information30);
628:
629: hr_utility.set_location('At:'|| l_proc, 35);
630:
631: FOR cur_rec in cur_form_canvas LOOP
632: hr_form_canvases_api.update_form_canvas(
633: p_effective_date => TRUNC(p_effective_date)
637: ,p_object_version_number => cur_rec.object_version_number
638: );
639: END LOOP;
640:
641: hr_utility.set_location('At:'|| l_proc, 40);
642:
643: --
644: -- Call After Process User Hook
645: --
699: end;
700: --
701: -- When in validation only mode raise the Validate_Enabled exception
702: --
703: hr_utility.set_location('At:'|| l_proc, 45);
704:
705: if p_validate then
706: raise hr_api.validate_enabled;
707: end if;
709: -- Set all output arguments
710: --
711: p_object_version_number := l_object_version_number;
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 70);
714: exception
715: when hr_api.validate_enabled then
716: --
717: -- As the Validate_Enabled exception has been raised
725: -- Reset all out arguments
726: --
727: p_object_version_number := l_temp_ovn;
728: --
729: hr_utility.set_location(' Leaving:'||l_proc, 80);
730: when others then
731: --
732: -- A validation or unexpected error has occured
733: --
734: rollback to update_form_window;
735: -- Reset all in out arguments
736: --
737: p_object_version_number := l_temp_ovn;
738: hr_utility.set_location(' Leaving:'||l_proc, 90);
739: raise;
740: end update_form_window;
741: --
742: end hr_form_windows_api;