DBA Data[Home] [Help]

APPS.PQH_ROUTING_CATEGORIES_API dependencies on HR_API

Line 66: when hr_api.cannot_find_prog_unit then

62: ,p_override_user_id => p_override_user_id
63: ,p_effective_date => trunc(p_effective_date)
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (
69: p_module_name => 'CREATE_ROUTING_CATEGORY'
70: ,p_hook_type => 'BP'

Line 67: hr_api.cannot_find_prog_unit_error

63: ,p_effective_date => trunc(p_effective_date)
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (
69: p_module_name => 'CREATE_ROUTING_CATEGORY'
70: ,p_hook_type => 'BP'
71: );

Line 115: when hr_api.cannot_find_prog_unit then

111: ,p_object_version_number => l_object_version_number
112: ,p_effective_date => trunc(p_effective_date)
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_ROUTING_CATEGORY'
118: ,p_hook_type => 'AP'
119: );

Line 116: hr_api.cannot_find_prog_unit_error

112: ,p_effective_date => trunc(p_effective_date)
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'CREATE_ROUTING_CATEGORY'
118: ,p_hook_type => 'AP'
119: );
120: --

Line 130: raise hr_api.validate_enabled;

126: --
127: -- When in validation only mode raise the Validate_Enabled exception
128: --
129: if p_validate then
130: raise hr_api.validate_enabled;
131: end if;
132: --
133: -- Set all output arguments
134: --

Line 142: when hr_api.validate_enabled then

138: hr_utility.set_location(' Leaving:'||l_proc, 70);
139: --
140: exception
141: --
142: when hr_api.validate_enabled then
143: --
144: -- As the Validate_Enabled exception has been raised
145: -- we must rollback to the savepoint
146: --

Line 174: ,p_transaction_category_id in number default hr_api.g_number

170: --
171: procedure update_ROUTING_CATEGORY
172: (p_validate in boolean default false
173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number

Line 175: ,p_enable_flag in varchar2 default hr_api.g_varchar2

171: procedure update_ROUTING_CATEGORY
172: (p_validate in boolean default false
173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number

Line 176: ,p_default_flag in varchar2 default hr_api.g_varchar2

172: (p_validate in boolean default false
173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number

Line 177: ,p_delete_flag in varchar2 default hr_api.g_varchar2

173: ,p_routing_category_id in number
174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number

Line 178: ,p_routing_list_id in number default hr_api.g_number

174: ,p_transaction_category_id in number default hr_api.g_number
175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number

Line 179: ,p_position_structure_id in number default hr_api.g_number

175: ,p_enable_flag in varchar2 default hr_api.g_varchar2
176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number

Line 180: ,p_override_position_id in number default hr_api.g_number

176: ,p_default_flag in varchar2 default hr_api.g_varchar2
177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number

Line 181: ,p_override_assignment_id in number default hr_api.g_number

177: ,p_delete_flag in varchar2 default hr_api.g_varchar2
178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number
185: ,p_effective_date in date

Line 182: ,p_override_role_id in number default hr_api.g_number

178: ,p_routing_list_id in number default hr_api.g_number
179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number
185: ,p_effective_date in date
186:

Line 183: ,p_override_user_id in number default hr_api.g_number

179: ,p_position_structure_id in number default hr_api.g_number
180: ,p_override_position_id in number default hr_api.g_number
181: ,p_override_assignment_id in number default hr_api.g_number
182: ,p_override_role_id in number default hr_api.g_number
183: ,p_override_user_id in number default hr_api.g_number
184: ,p_object_version_number in out nocopy number
185: ,p_effective_date in date
186:
187: ) is

Line 230: when hr_api.cannot_find_prog_unit then

226: ,p_effective_date => trunc(p_effective_date)
227:
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
233: ,p_hook_type => 'BP'
234: );

Line 231: hr_api.cannot_find_prog_unit_error

227:
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
233: ,p_hook_type => 'BP'
234: );
235: --

Line 280: when hr_api.cannot_find_prog_unit then

276: ,p_effective_date => trunc(p_effective_date)
277:
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
283: ,p_hook_type => 'AP'
284: );

Line 281: hr_api.cannot_find_prog_unit_error

277:
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'UPDATE_ROUTING_CATEGORY'
283: ,p_hook_type => 'AP'
284: );
285: --

Line 295: raise hr_api.validate_enabled;

291: --
292: -- When in validation only mode raise the Validate_Enabled exception
293: --
294: if p_validate then
295: raise hr_api.validate_enabled;
296: end if;
297: --
298: -- Set all output arguments
299: --

Line 306: when hr_api.validate_enabled then

302: hr_utility.set_location(' Leaving:'||l_proc, 70);
303: --
304: exception
305: --
306: when hr_api.validate_enabled then
307: --
308: -- As the Validate_Enabled exception has been raised
309: -- we must rollback to the savepoint
310: --

Line 372: when hr_api.cannot_find_prog_unit then

368: ,p_effective_date => trunc(p_effective_date)
369:
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'DELETE_ROUTING_CATEGORY'
375: ,p_hook_type => 'BP'
376: );

Line 373: hr_api.cannot_find_prog_unit_error

369:
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'DELETE_ROUTING_CATEGORY'
375: ,p_hook_type => 'BP'
376: );
377: --

Line 402: when hr_api.cannot_find_prog_unit then

398: ,p_effective_date => trunc(p_effective_date)
399:
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_ROUTING_CATEGORY'
405: ,p_hook_type => 'AP'
406: );

Line 403: hr_api.cannot_find_prog_unit_error

399:
400: );
401: exception
402: when hr_api.cannot_find_prog_unit then
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'DELETE_ROUTING_CATEGORY'
405: ,p_hook_type => 'AP'
406: );
407: --

Line 417: raise hr_api.validate_enabled;

413: --
414: -- When in validation only mode raise the Validate_Enabled exception
415: --
416: if p_validate then
417: raise hr_api.validate_enabled;
418: end if;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --

Line 424: when hr_api.validate_enabled then

420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --
422: exception
423: --
424: when hr_api.validate_enabled then
425: --
426: -- As the Validate_Enabled exception has been raised
427: -- we must rollback to the savepoint
428: --