DBA Data[Home] [Help]

APPS.BEN_PIL_ASSIGNMENT_API dependencies on HR_API

Line 51: when hr_api.cannot_find_prog_unit then

47: ,p_applicant_assignment_id => p_applicant_assignment_id
48: ,p_offer_assignment_id => p_offer_assignment_id
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (
54: p_module_name => 'CREATE_pil_assignment'
55: ,p_hook_type => 'BP'

Line 52: hr_api.cannot_find_prog_unit_error

48: ,p_offer_assignment_id => p_offer_assignment_id
49: );
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (
54: p_module_name => 'CREATE_pil_assignment'
55: ,p_hook_type => 'BP'
56: );

Line 86: when hr_api.cannot_find_prog_unit then

82: ,p_object_version_number => l_object_version_number
83:
84: );
85: exception
86: when hr_api.cannot_find_prog_unit then
87: hr_api.cannot_find_prog_unit_error
88: (p_module_name => 'CREATE_pil_assignment'
89: ,p_hook_type => 'AP'
90: );

Line 87: hr_api.cannot_find_prog_unit_error

83:
84: );
85: exception
86: when hr_api.cannot_find_prog_unit then
87: hr_api.cannot_find_prog_unit_error
88: (p_module_name => 'CREATE_pil_assignment'
89: ,p_hook_type => 'AP'
90: );
91: --

Line 101: raise hr_api.validate_enabled;

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

Line 113: when hr_api.validate_enabled then

109:
110: --
111: exception
112: --
113: when hr_api.validate_enabled then
114: --
115: -- As the Validate_Enabled exception has been raised
116: -- we must rollback to the savepoint
117: --

Line 146: ,p_per_in_ler_id in number default hr_api.g_number

142: procedure update_pil_assignment
143: (
144: p_validate in boolean default false
145: ,p_pil_assignment_id in number
146: ,p_per_in_ler_id in number default hr_api.g_number
147: ,p_applicant_assignment_id in number default hr_api.g_number
148: ,p_offer_assignment_id in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is

Line 147: ,p_applicant_assignment_id in number default hr_api.g_number

143: (
144: p_validate in boolean default false
145: ,p_pil_assignment_id in number
146: ,p_per_in_ler_id in number default hr_api.g_number
147: ,p_applicant_assignment_id in number default hr_api.g_number
148: ,p_offer_assignment_id in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is
151: --

Line 148: ,p_offer_assignment_id in number default hr_api.g_number

144: p_validate in boolean default false
145: ,p_pil_assignment_id in number
146: ,p_per_in_ler_id in number default hr_api.g_number
147: ,p_applicant_assignment_id in number default hr_api.g_number
148: ,p_offer_assignment_id in number default hr_api.g_number
149: ,p_object_version_number in out nocopy number
150: ) is
151: --
152: -- Declare cursors and local variables

Line 189: when hr_api.cannot_find_prog_unit then

185: ,p_offer_assignment_id => p_offer_assignment_id
186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'UPDATE_pil_assignment'
192: ,p_hook_type => 'BP'
193: );

Line 190: hr_api.cannot_find_prog_unit_error

186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'UPDATE_pil_assignment'
192: ,p_hook_type => 'BP'
193: );
194: --

Line 221: when hr_api.cannot_find_prog_unit then

217: ,p_offer_assignment_id => p_offer_assignment_id
218: ,p_object_version_number => l_object_version_number
219: );
220: exception
221: when hr_api.cannot_find_prog_unit then
222: hr_api.cannot_find_prog_unit_error
223: (p_module_name => 'UPDATE_pil_assignment'
224: ,p_hook_type => 'AP'
225: );

Line 222: hr_api.cannot_find_prog_unit_error

218: ,p_object_version_number => l_object_version_number
219: );
220: exception
221: when hr_api.cannot_find_prog_unit then
222: hr_api.cannot_find_prog_unit_error
223: (p_module_name => 'UPDATE_pil_assignment'
224: ,p_hook_type => 'AP'
225: );
226: --

Line 236: raise hr_api.validate_enabled;

232: --
233: -- When in validation only mode raise the Validate_Enabled exception
234: --
235: if p_validate then
236: raise hr_api.validate_enabled;
237: end if;
238: --
239: -- Set all output arguments
240: --

Line 247: when hr_api.validate_enabled then

243:
244: --
245: exception
246: --
247: when hr_api.validate_enabled then
248: --
249: -- As the Validate_Enabled exception has been raised
250: -- we must rollback to the savepoint
251: --

Line 308: when hr_api.cannot_find_prog_unit then

304: p_pil_assignment_id => p_pil_assignment_id
305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'DELETE_pil_assignment'
311: ,p_hook_type => 'BP'
312: );

Line 309: hr_api.cannot_find_prog_unit_error

305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'DELETE_pil_assignment'
311: ,p_hook_type => 'BP'
312: );
313: --

Line 334: when hr_api.cannot_find_prog_unit then

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

Line 335: hr_api.cannot_find_prog_unit_error

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

Line 349: raise hr_api.validate_enabled;

345: --
346: -- When in validation only mode raise the Validate_Enabled exception
347: --
348: if p_validate then
349: raise hr_api.validate_enabled;
350: end if;
351: --
352:
353: --

Line 356: when hr_api.validate_enabled then

352:
353: --
354: exception
355: --
356: when hr_api.validate_enabled then
357: --
358: -- As the Validate_Enabled exception has been raised
359: -- we must rollback to the savepoint
360: --