[Home] [Help]
63: l_object_version_number number;
64: l_override_value_warning boolean;
65: l_proc varchar2(72) := g_package||'create_tab_page_property';
66: begin
67: hr_utility.set_location('Entering:'|| l_proc, 10);
68: --
69: -- Issue a savepoint
70: --
71: savepoint create_tab_page_property;
77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82: --
83: --
84: -- Process Logic
85: --
138: p_tab_page_property_id := l_tab_page_property_id;
139: p_object_version_number := l_object_version_number;
140: --p_override_value_warning := l_override_value_warning;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: exception
144: when hr_api.validate_enabled then
145: --
146: -- As the Validate_Enabled exception has been raised
153: -- when validation only mode is being used.)
154: --
155: p_tab_page_property_id := null;
156: --p_override_value_warning := null;
157: hr_utility.set_location(' Leaving:'||l_proc, 80);
158: when others then
159: --
160: -- A validation or unexpected error has occured
161: --
159: --
160: -- A validation or unexpected error has occured
161: --
162: rollback to create_tab_page_property;
163: hr_utility.set_location(' Leaving:'||l_proc, 90);
164: raise;
165: end create_tab_page_property;
166: --
167: --
235: l_tab_page_property_id number;
236: l_override_value_warning boolean;
237: l_proc varchar2(72) := g_package||'update_tab_page_property';
238: begin
239: hr_utility.set_location('Entering:'|| l_proc, 10);
240: --
241: -- Issue a savepoint
242: --
243: savepoint update_tab_page_property;
249: l_language_code := p_language_code;
250:
251: hr_api.validate_language_code(p_language_code => l_language_code);
252: --
253: hr_utility.set_location(l_proc, 20);
254: --
255: --
256: -- Validation in addition to Row Handlers
257: --
348: -- Set all output arguments
349: --
350: --
351: --p_override_value_warning := l_override_value_warning;
352: hr_utility.set_location(' Leaving:'||l_proc, 70);
353: exception
354: when hr_api.validate_enabled then
355: --
356: -- As the Validate_Enabled exception has been raised
362: -- (Any key or derived arguments must be set to null
363: -- when validation only mode is being used.)
364: --
365: --p_override_value_warning := null;
366: hr_utility.set_location(' Leaving:'||l_proc, 80);
367: when others then
368: --
369: -- A validation or unexpected error has occured
370: --
368: --
369: -- A validation or unexpected error has occured
370: --
371: rollback to update_tab_page_property;
372: hr_utility.set_location(' Leaving:'||l_proc, 90);
373: raise;
374: end update_tab_page_property;
375: --
376: --
404: l_tab_page_property_id number;
405:
406: l_proc varchar2(72) := g_package||'delete_tab_page_property';
407: begin
408: hr_utility.set_location('Entering:'|| l_proc, 10);
409: --
410: -- Issue a savepoint
411: --
412: savepoint delete_tab_page_property;
472: if p_validate then
473: raise hr_api.validate_enabled;
474: end if;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 70);
477: exception
478: when hr_api.validate_enabled then
479: --
480: -- As the Validate_Enabled exception has been raised
485: -- Only set output warning arguments
486: -- (Any key or derived arguments must be set to null
487: -- when validation only mode is being used.)
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 80);
490: when others then
491: --
492: -- A validation or unexpected error has occured
493: --
491: --
492: -- A validation or unexpected error has occured
493: --
494: rollback to delete_tab_page_property;
495: hr_utility.set_location(' Leaving:'||l_proc, 90);
496: raise;
497: end delete_tab_page_property;
498: --
499: --
650: l_proc varchar2(72) := g_package||'copy_tab_page_property';
651: l_language_code fnd_languages.language_code%TYPE;
652:
653: begin
654: hr_utility.set_location('Entering:'|| l_proc, 10);
655: --
656: -- Issue a savepoint
657: --
658: savepoint copy_tab_page_property;
664: --
665: l_language_code := p_language_code;
666: hr_api.validate_language_code(p_language_code => l_language_code);
667: --
668: hr_utility.set_location(l_proc, 20);
669: --
670: --
671: -- Validation in addition to Row Handlers
672: --
758: p_tab_page_property_id := l_tab_page_property_id;
759: p_object_version_number := l_object_version_number;
760: --p_override_value_warning := l_override_value_warning;
761: --
762: hr_utility.set_location(' Leaving:'||l_proc, 70);
763: exception
764: when hr_api.validate_enabled then
765: --
766: -- As the Validate_Enabled exception has been raised
773: -- when validation only mode is being used.)
774: --
775: p_tab_page_property_id := null;
776: --p_override_value_warning := null;
777: hr_utility.set_location(' Leaving:'||l_proc, 80);
778: when others then
779: --
780: -- A validation or unexpected error has occured
781: --
779: --
780: -- A validation or unexpected error has occured
781: --
782: rollback to copy_tab_page_property;
783: hr_utility.set_location(' Leaving:'||l_proc, 90);
784: raise;
785: end copy_tab_page_property;
786: --
787: -- ----------------------------------------------------------------------------
940: l_proc varchar2(72) := g_package||'copy_tab_page_property';
941: l_language_code fnd_languages.language_code%TYPE;
942:
943: begin
944: hr_utility.set_location('Entering:'|| l_proc, 10);
945: --
946: -- Issue a savepoint
947: --
948: savepoint copy_tab_page_property;
954: --
955: l_language_code := p_language_code;
956: hr_api.validate_language_code(p_language_code => l_language_code);
957: --
958: hr_utility.set_location(l_proc, 20);
959: --
960: --
961: -- Validation in addition to Row Handlers
962: --
1048: p_tab_page_property_id := l_tab_page_property_id;
1049: p_object_version_number := l_object_version_number;
1050: --p_override_value_warning := l_override_value_warning;
1051: --
1052: hr_utility.set_location(' Leaving:'||l_proc, 70);
1053: exception
1054: when hr_api.validate_enabled then
1055: --
1056: -- As the Validate_Enabled exception has been raised
1063: -- when validation only mode is being used.)
1064: --
1065: p_tab_page_property_id := null;
1066: --p_override_value_warning := null;
1067: hr_utility.set_location(' Leaving:'||l_proc, 80);
1068: when others then
1069: --
1070: -- A validation or unexpected error has occured
1071: --
1069: --
1070: -- A validation or unexpected error has occured
1071: --
1072: rollback to copy_tab_page_property;
1073: hr_utility.set_location(' Leaving:'||l_proc, 90);
1074: raise;
1075: end copy_tab_page_property;
1076: --
1077: end hr_tab_page_properties_bsi;