45: ,p_ath_varname => p_ath_varname
46: );
47:
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'CREATE_VARIABLEMAP'
52: ,p_hook_type => 'BP'
53: );
46: );
47:
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'CREATE_VARIABLEMAP'
52: ,p_hook_type => 'BP'
53: );
54: end;
76: ,p_ath_varname => p_ath_varname
77: );
78:
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (p_module_name => 'CREATE_VARIABLEMAP'
83: ,p_hook_type => 'AP'
84: );
77: );
78:
79: exception
80: when hr_api.cannot_find_prog_unit then
81: hr_api.cannot_find_prog_unit_error
82: (p_module_name => 'CREATE_VARIABLEMAP'
83: ,p_hook_type => 'AP'
84: );
85: end;
86: --
87: -- When in validation only mode raise the Validate_Enabled exception
88: --
89: if p_validate then
90: raise hr_api.validate_enabled;
91: end if;
92: --
93: -- Set all output arguments
94: --
95: p_ath_variablemap_id := l_ath_variablemap_id;
96: p_object_version_number := l_object_version_number;
97: hr_utility.set_location(' Leaving:'||l_proc, 70);
98: exception
99: when hr_api.validate_enabled then
100: --
101: -- As the Validate_Enabled exception has been raised
102: -- we must rollback to the savepoint
103: --
165: ,p_object_version_number => p_object_version_number
166: );
167:
168: exception
169: when hr_api.cannot_find_prog_unit then
170: hr_api.cannot_find_prog_unit_error
171: (p_module_name => 'UPDATE_VARIABLEMAP'
172: ,p_hook_type => 'BP'
173: );
166: );
167:
168: exception
169: when hr_api.cannot_find_prog_unit then
170: hr_api.cannot_find_prog_unit_error
171: (p_module_name => 'UPDATE_VARIABLEMAP'
172: ,p_hook_type => 'BP'
173: );
174: end;
199: ,p_object_version_number => p_object_version_number
200: );
201:
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_VARIABLEMAP'
206: ,p_hook_type => 'AP'
207: );
200: );
201:
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'UPDATE_VARIABLEMAP'
206: ,p_hook_type => 'AP'
207: );
208: end;
209: --
210: -- When in validation only mode raise the Validate_Enabled exception
211: --
212: if p_validate then
213: raise hr_api.validate_enabled;
214: end if;
215: --
216: -- Set all output arguments
217: --
217: --
218: p_object_version_number := l_object_version_number;
219: hr_utility.set_location(' Leaving:'||l_proc, 70);
220: exception
221: when hr_api.validate_enabled then
222: --
223: -- As the Validate_Enabled exception has been raised
224: -- we must rollback to the savepoint
225: --
277: ,p_object_version_number => p_object_version_number
278: );
279:
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'DELETE_VARIABLEMAP'
284: ,p_hook_type => 'BP'
285: );
278: );
279:
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'DELETE_VARIABLEMAP'
284: ,p_hook_type => 'BP'
285: );
286: end;
300: ,p_object_version_number => p_object_version_number
301: );
302:
303: exception
304: when hr_api.cannot_find_prog_unit then
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'DELETE_VARIABLEMAP'
307: ,p_hook_type => 'AP'
308: );
301: );
302:
303: exception
304: when hr_api.cannot_find_prog_unit then
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'DELETE_VARIABLEMAP'
307: ,p_hook_type => 'AP'
308: );
309: end;
310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: if p_validate then
314: raise hr_api.validate_enabled;
315: end if;
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: exception
318: when hr_api.validate_enabled then
314: raise hr_api.validate_enabled;
315: end if;
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: exception
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised
321: -- we must rollback to the savepoint
322: --