DBA Data[Home] [Help]

APPS.PER_SOLUTION_SET_API dependencies on HR_API

Line 19: ,p_solution_set_impl_id in number default hr_api.g_number

15: ,p_solution_set_name in varchar2
16: ,p_user_id in number
17: ,p_description in varchar2 default null
18: ,p_status in varchar2 default null
19: ,p_solution_set_impl_id in number default hr_api.g_number
20: ,p_object_version_number out nocopy number
21: ) is
22: --
23: -- Declare cursors and local variables

Line 59: when hr_api.cannot_find_prog_unit then

55: ,p_status => p_status
56: ,p_solution_set_impl_id => p_solution_set_impl_id
57: );
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_SOLUTION_SET_b'
62: ,p_hook_type => 'BP'
63: );

Line 60: hr_api.cannot_find_prog_unit_error

56: ,p_solution_set_impl_id => p_solution_set_impl_id
57: );
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_SOLUTION_SET_b'
62: ,p_hook_type => 'BP'
63: );
64: end;

Line 90: when hr_api.cannot_find_prog_unit then

86: ,p_solution_set_impl_id => p_solution_set_impl_id
87: ,p_object_version_number => p_object_version_number
88: );
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'CREATE_SOLUTION_SET_a'
93: ,p_hook_type => 'AP'
94: );

Line 91: hr_api.cannot_find_prog_unit_error

87: ,p_object_version_number => p_object_version_number
88: );
89: exception
90: when hr_api.cannot_find_prog_unit then
91: hr_api.cannot_find_prog_unit_error
92: (p_module_name => 'CREATE_SOLUTION_SET_a'
93: ,p_hook_type => 'AP'
94: );
95: end;

Line 100: raise hr_api.validate_enabled;

96: --
97: -- When in validation only mode raise the Validate_Enabled exception
98: --
99: if p_validate then
100: raise hr_api.validate_enabled;
101: end if;
102: --
103: -- Set all output arguments
104: --

Line 109: when hr_api.validate_enabled then

105: p_object_version_number := l_object_version_number;
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 70);
108: exception
109: when hr_api.validate_enabled then
110: --
111: -- As the Validate_Enabled exception has been raised
112: -- we must rollback to the savepoint
113: --

Line 143: ,p_description in varchar2 default hr_api.g_varchar2

139: (p_validate in boolean default false
140: ,p_effective_date in date
141: ,p_solution_set_name in varchar2
142: ,p_user_id in number
143: ,p_description in varchar2 default hr_api.g_varchar2
144: ,p_status in varchar2 default hr_api.g_varchar2
145: ,p_solution_set_impl_id in number default hr_api.g_number
146: ,p_object_version_number in out nocopy number
147: ) is

Line 144: ,p_status in varchar2 default hr_api.g_varchar2

140: ,p_effective_date in date
141: ,p_solution_set_name in varchar2
142: ,p_user_id in number
143: ,p_description in varchar2 default hr_api.g_varchar2
144: ,p_status in varchar2 default hr_api.g_varchar2
145: ,p_solution_set_impl_id in number default hr_api.g_number
146: ,p_object_version_number in out nocopy number
147: ) is
148: --

Line 145: ,p_solution_set_impl_id in number default hr_api.g_number

141: ,p_solution_set_name in varchar2
142: ,p_user_id in number
143: ,p_description in varchar2 default hr_api.g_varchar2
144: ,p_status in varchar2 default hr_api.g_varchar2
145: ,p_solution_set_impl_id in number default hr_api.g_number
146: ,p_object_version_number in out nocopy number
147: ) is
148: --
149: -- Declare cursors and local variables

Line 181: when hr_api.cannot_find_prog_unit then

177: ,p_status => p_status
178: ,p_solution_set_impl_id => p_solution_set_impl_id
179: );
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'UPDATE_SOLUTION_SET_b'
184: ,p_hook_type => 'BP'
185: );

Line 182: hr_api.cannot_find_prog_unit_error

178: ,p_solution_set_impl_id => p_solution_set_impl_id
179: );
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'UPDATE_SOLUTION_SET_b'
184: ,p_hook_type => 'BP'
185: );
186: end;

Line 212: when hr_api.cannot_find_prog_unit then

208: ,p_status => p_status
209: ,p_solution_set_impl_id => p_solution_set_impl_id
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_SOLUTION_SET_a'
215: ,p_hook_type => 'AP'
216: );

Line 213: hr_api.cannot_find_prog_unit_error

209: ,p_solution_set_impl_id => p_solution_set_impl_id
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_SOLUTION_SET_a'
215: ,p_hook_type => 'AP'
216: );
217: end;

Line 222: raise hr_api.validate_enabled;

218: --
219: -- When in validation only mode raise the Validate_Enabled exception
220: --
221: if p_validate then
222: raise hr_api.validate_enabled;
223: end if;
224: --
225: --
226: -- Set all output arguments

Line 232: when hr_api.validate_enabled then

228: p_object_version_number := l_object_version_number;
229: --
230: hr_utility.set_location(' Leaving:'||l_proc, 70);
231: exception
232: when hr_api.validate_enabled then
233: --
234: -- As the Validate_Enabled exception has been raised
235: -- we must rollback to the savepoint
236: --

Line 283: when hr_api.cannot_find_prog_unit then

279: ,p_user_id => p_user_id
280: ,p_object_version_number => p_object_version_number
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'DELETE_SOLUTION_SET_b'
286: ,p_hook_type => 'BP'
287: );

Line 284: hr_api.cannot_find_prog_unit_error

280: ,p_object_version_number => p_object_version_number
281: );
282: exception
283: when hr_api.cannot_find_prog_unit then
284: hr_api.cannot_find_prog_unit_error
285: (p_module_name => 'DELETE_SOLUTION_SET_b'
286: ,p_hook_type => 'BP'
287: );
288: end;

Line 303: when hr_api.cannot_find_prog_unit then

299: ,p_user_id => p_user_id
300: ,p_object_version_number => p_object_version_number
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'DELETE_SOLUTION_SET_a'
306: ,p_hook_type => 'AP'
307: );

Line 304: hr_api.cannot_find_prog_unit_error

300: ,p_object_version_number => p_object_version_number
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'DELETE_SOLUTION_SET_a'
306: ,p_hook_type => 'AP'
307: );
308: end;

Line 313: raise hr_api.validate_enabled;

309: --
310: -- When in validation only mode raise the Validate_Enabled exception
311: --
312: if p_validate then
313: raise hr_api.validate_enabled;
314: end if;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: exception

Line 318: when hr_api.validate_enabled then

314: end if;
315: --
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: --