DBA Data[Home] [Help]

APPS.PQH_ROUTING_LISTS_API dependencies on HR_API

Line 48: when hr_api.cannot_find_prog_unit then

44: p_routing_list_name => p_routing_list_name ,
45: p_enable_flag => p_enable_flag
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (
51: p_module_name => 'CREATE_ROUTING_LIST'
52: ,p_hook_type => 'BP'

Line 49: hr_api.cannot_find_prog_unit_error

45: p_enable_flag => p_enable_flag
46: );
47: exception
48: when hr_api.cannot_find_prog_unit then
49: hr_api.cannot_find_prog_unit_error
50: (
51: p_module_name => 'CREATE_ROUTING_LIST'
52: ,p_hook_type => 'BP'
53: );

Line 79: when hr_api.cannot_find_prog_unit then

75: ,p_enable_flag => p_enable_flag
76: ,p_object_version_number => l_object_version_number
77: );
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'CREATE_ROUTING_LIST'
82: ,p_hook_type => 'AP'
83: );

Line 80: hr_api.cannot_find_prog_unit_error

76: ,p_object_version_number => l_object_version_number
77: );
78: exception
79: when hr_api.cannot_find_prog_unit then
80: hr_api.cannot_find_prog_unit_error
81: (p_module_name => 'CREATE_ROUTING_LIST'
82: ,p_hook_type => 'AP'
83: );
84: --

Line 94: raise hr_api.validate_enabled;

90: --
91: -- When in validation only mode raise the Validate_Enabled exception
92: --
93: if p_validate then
94: raise hr_api.validate_enabled;
95: end if;
96: --
97: -- Set all output arguments
98: --

Line 106: when hr_api.validate_enabled then

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

Line 138: ,p_routing_list_name in varchar2 default hr_api.g_varchar2

134: --
135: procedure update_routing_list
136: (p_validate in boolean default false
137: ,p_routing_list_id in number
138: ,p_routing_list_name in varchar2 default hr_api.g_varchar2
139: ,p_enable_flag in varchar2 default hr_api.g_varchar2
140: ,p_object_version_number in out nocopy number
141: ) is
142: --

Line 139: ,p_enable_flag in varchar2 default hr_api.g_varchar2

135: procedure update_routing_list
136: (p_validate in boolean default false
137: ,p_routing_list_id in number
138: ,p_routing_list_name in varchar2 default hr_api.g_varchar2
139: ,p_enable_flag in varchar2 default hr_api.g_varchar2
140: ,p_object_version_number in out nocopy number
141: ) is
142: --
143: -- Declare cursors and local variables

Line 174: when hr_api.cannot_find_prog_unit then

170: ,p_enable_flag => p_enable_flag
171: ,p_object_version_number => p_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'UPDATE_ROUTING_LIST'
177: ,p_hook_type => 'BP'
178: );

Line 175: hr_api.cannot_find_prog_unit_error

171: ,p_object_version_number => p_object_version_number
172: );
173: exception
174: when hr_api.cannot_find_prog_unit then
175: hr_api.cannot_find_prog_unit_error
176: (p_module_name => 'UPDATE_ROUTING_LIST'
177: ,p_hook_type => 'BP'
178: );
179: --

Line 204: when hr_api.cannot_find_prog_unit then

200: ,p_enable_flag => p_enable_flag
201: ,p_object_version_number => l_object_version_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'UPDATE_ROUTING_LIST'
207: ,p_hook_type => 'AP'
208: );

Line 205: hr_api.cannot_find_prog_unit_error

201: ,p_object_version_number => l_object_version_number
202: );
203: exception
204: when hr_api.cannot_find_prog_unit then
205: hr_api.cannot_find_prog_unit_error
206: (p_module_name => 'UPDATE_ROUTING_LIST'
207: ,p_hook_type => 'AP'
208: );
209: --

Line 219: raise hr_api.validate_enabled;

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

Line 230: when hr_api.validate_enabled then

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

Line 297: when hr_api.cannot_find_prog_unit then

293: p_routing_list_id => p_routing_list_id
294: ,p_object_version_number => p_object_version_number
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'DELETE_ROUTING_LIST'
300: ,p_hook_type => 'BP'
301: );

Line 298: hr_api.cannot_find_prog_unit_error

294: ,p_object_version_number => p_object_version_number
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'DELETE_ROUTING_LIST'
300: ,p_hook_type => 'BP'
301: );
302: --

Line 333: when hr_api.cannot_find_prog_unit then

329: p_routing_list_id => p_routing_list_id
330: ,p_object_version_number => l_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'DELETE_ROUTING_LIST'
336: ,p_hook_type => 'AP'
337: );

Line 334: hr_api.cannot_find_prog_unit_error

330: ,p_object_version_number => l_object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: (p_module_name => 'DELETE_ROUTING_LIST'
336: ,p_hook_type => 'AP'
337: );
338: --

Line 348: raise hr_api.validate_enabled;

344: --
345: -- When in validation only mode raise the Validate_Enabled exception
346: --
347: if p_validate then
348: raise hr_api.validate_enabled;
349: end if;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: --

Line 355: when hr_api.validate_enabled then

351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: --
353: exception
354: --
355: when hr_api.validate_enabled then
356: --
357: -- As the Validate_Enabled exception has been raised
358: -- we must rollback to the savepoint
359: --