DBA Data[Home] [Help]

APPS.BEN_PL_EXTRACT_ID_API dependencies on HR_API

Line 77: when hr_api.cannot_find_prog_unit then

73: ,p_business_group_id => p_business_group_id
74: ,p_effective_date => trunc(p_effective_date)
75: );
76: exception
77: when hr_api.cannot_find_prog_unit then
78: hr_api.cannot_find_prog_unit_error
79: (
80: p_module_name => 'CREATE_PL_EXTRACT_ID'
81: ,p_hook_type => 'BP'

Line 78: hr_api.cannot_find_prog_unit_error

74: ,p_effective_date => trunc(p_effective_date)
75: );
76: exception
77: when hr_api.cannot_find_prog_unit then
78: hr_api.cannot_find_prog_unit_error
79: (
80: p_module_name => 'CREATE_PL_EXTRACT_ID'
81: ,p_hook_type => 'BP'
82: );

Line 136: when hr_api.cannot_find_prog_unit then

132: ,p_business_group_id => p_business_group_id
133: ,p_effective_date => trunc(p_effective_date)
134: );
135: exception
136: when hr_api.cannot_find_prog_unit then
137: hr_api.cannot_find_prog_unit_error
138: (p_module_name => 'CREATE_PL_EXTRACT_ID'
139: ,p_hook_type => 'AP'
140: );

Line 137: hr_api.cannot_find_prog_unit_error

133: ,p_effective_date => trunc(p_effective_date)
134: );
135: exception
136: when hr_api.cannot_find_prog_unit then
137: hr_api.cannot_find_prog_unit_error
138: (p_module_name => 'CREATE_PL_EXTRACT_ID'
139: ,p_hook_type => 'AP'
140: );
141: --

Line 151: raise hr_api.validate_enabled;

147: --
148: -- When in validation only mode raise the Validate_Enabled exception
149: --
150: if p_validate then
151: raise hr_api.validate_enabled;
152: end if;
153: --
154: -- Set all output arguments
155: --

Line 165: when hr_api.validate_enabled then

161: hr_utility.set_location(' Leaving:'||l_proc, 70);
162: --
163: exception
164: --
165: when hr_api.validate_enabled then
166: --
167: -- As the Validate_Enabled exception has been raised
168: -- we must rollback to the savepoint
169: --

Line 204: ,p_pl_id in number default hr_api.g_number

200: p_validate in boolean default false
201: ,p_pl_extract_identifier_id in number
202: ,p_effective_start_date out nocopy date
203: ,p_effective_end_date out nocopy date
204: ,p_pl_id in number default hr_api.g_number
205: ,p_plip_id in number default hr_api.g_number
206: ,p_oipl_id in number default hr_api.g_number
207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number

Line 205: ,p_plip_id in number default hr_api.g_number

201: ,p_pl_extract_identifier_id in number
202: ,p_effective_start_date out nocopy date
203: ,p_effective_end_date out nocopy date
204: ,p_pl_id in number default hr_api.g_number
205: ,p_plip_id in number default hr_api.g_number
206: ,p_oipl_id in number default hr_api.g_number
207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number

Line 206: ,p_oipl_id in number default hr_api.g_number

202: ,p_effective_start_date out nocopy date
203: ,p_effective_end_date out nocopy date
204: ,p_pl_id in number default hr_api.g_number
205: ,p_plip_id in number default hr_api.g_number
206: ,p_oipl_id in number default hr_api.g_number
207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number

Line 207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2

203: ,p_effective_end_date out nocopy date
204: ,p_pl_id in number default hr_api.g_number
205: ,p_plip_id in number default hr_api.g_number
206: ,p_oipl_id in number default hr_api.g_number
207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number

Line 208: ,p_organization_id in number default hr_api.g_number

204: ,p_pl_id in number default hr_api.g_number
205: ,p_plip_id in number default hr_api.g_number
206: ,p_oipl_id in number default hr_api.g_number
207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number

Line 209: ,p_job_id in number default hr_api.g_number

205: ,p_plip_id in number default hr_api.g_number
206: ,p_oipl_id in number default hr_api.g_number
207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number
213: ,p_payroll_id in number default hr_api.g_number

Line 210: ,p_position_id in number default hr_api.g_number

206: ,p_oipl_id in number default hr_api.g_number
207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number
213: ,p_payroll_id in number default hr_api.g_number
214: ,p_home_state in varchar2 default hr_api.g_varchar2

Line 211: ,p_people_group_id in number default hr_api.g_number

207: ,p_third_party_identifier in varchar2 default hr_api.g_varchar2
208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number
213: ,p_payroll_id in number default hr_api.g_number
214: ,p_home_state in varchar2 default hr_api.g_varchar2
215: ,p_home_zip in varchar2 default hr_api.g_varchar2

Line 212: ,p_grade_id in number default hr_api.g_number

208: ,p_organization_id in number default hr_api.g_number
209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number
213: ,p_payroll_id in number default hr_api.g_number
214: ,p_home_state in varchar2 default hr_api.g_varchar2
215: ,p_home_zip in varchar2 default hr_api.g_varchar2
216: ,p_object_version_number in out nocopy number

Line 213: ,p_payroll_id in number default hr_api.g_number

209: ,p_job_id in number default hr_api.g_number
210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number
213: ,p_payroll_id in number default hr_api.g_number
214: ,p_home_state in varchar2 default hr_api.g_varchar2
215: ,p_home_zip in varchar2 default hr_api.g_varchar2
216: ,p_object_version_number in out nocopy number
217: ,p_business_group_id in number default hr_api.g_number

Line 214: ,p_home_state in varchar2 default hr_api.g_varchar2

210: ,p_position_id in number default hr_api.g_number
211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number
213: ,p_payroll_id in number default hr_api.g_number
214: ,p_home_state in varchar2 default hr_api.g_varchar2
215: ,p_home_zip in varchar2 default hr_api.g_varchar2
216: ,p_object_version_number in out nocopy number
217: ,p_business_group_id in number default hr_api.g_number
218: ,p_effective_date in date

Line 215: ,p_home_zip in varchar2 default hr_api.g_varchar2

211: ,p_people_group_id in number default hr_api.g_number
212: ,p_grade_id in number default hr_api.g_number
213: ,p_payroll_id in number default hr_api.g_number
214: ,p_home_state in varchar2 default hr_api.g_varchar2
215: ,p_home_zip in varchar2 default hr_api.g_varchar2
216: ,p_object_version_number in out nocopy number
217: ,p_business_group_id in number default hr_api.g_number
218: ,p_effective_date in date
219: ,p_datetrack_mode in varchar2

Line 217: ,p_business_group_id in number default hr_api.g_number

213: ,p_payroll_id in number default hr_api.g_number
214: ,p_home_state in varchar2 default hr_api.g_varchar2
215: ,p_home_zip in varchar2 default hr_api.g_varchar2
216: ,p_object_version_number in out nocopy number
217: ,p_business_group_id in number default hr_api.g_number
218: ,p_effective_date in date
219: ,p_datetrack_mode in varchar2
220: ) is
221: --

Line 268: when hr_api.cannot_find_prog_unit then

264: ,p_effective_date => trunc(p_effective_date)
265: ,p_datetrack_mode => p_datetrack_mode
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'UPDATE_PL_EXTRACT_ID'
271: ,p_hook_type => 'BP'
272: );

Line 269: hr_api.cannot_find_prog_unit_error

265: ,p_datetrack_mode => p_datetrack_mode
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (p_module_name => 'UPDATE_PL_EXTRACT_ID'
271: ,p_hook_type => 'BP'
272: );
273: --

Line 329: when hr_api.cannot_find_prog_unit then

325: ,p_effective_date => trunc(p_effective_date)
326: ,p_datetrack_mode => p_datetrack_mode
327: );
328: exception
329: when hr_api.cannot_find_prog_unit then
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'UPDATE_PL_EXTRACT_ID'
332: ,p_hook_type => 'AP'
333: );

Line 330: hr_api.cannot_find_prog_unit_error

326: ,p_datetrack_mode => p_datetrack_mode
327: );
328: exception
329: when hr_api.cannot_find_prog_unit then
330: hr_api.cannot_find_prog_unit_error
331: (p_module_name => 'UPDATE_PL_EXTRACT_ID'
332: ,p_hook_type => 'AP'
333: );
334: --

Line 344: raise hr_api.validate_enabled;

340: --
341: -- When in validation only mode raise the Validate_Enabled exception
342: --
343: if p_validate then
344: raise hr_api.validate_enabled;
345: end if;
346: --
347: -- Set all output arguments
348: --

Line 357: when hr_api.validate_enabled then

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

Line 429: when hr_api.cannot_find_prog_unit then

425: ,p_effective_date => trunc(p_effective_date)
426: ,p_datetrack_mode => p_datetrack_mode
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'DELETE_PL_EXTRACT_ID'
432: ,p_hook_type => 'BP'
433: );

Line 430: hr_api.cannot_find_prog_unit_error

426: ,p_datetrack_mode => p_datetrack_mode
427: );
428: exception
429: when hr_api.cannot_find_prog_unit then
430: hr_api.cannot_find_prog_unit_error
431: (p_module_name => 'DELETE_PL_EXTRACT_ID'
432: ,p_hook_type => 'BP'
433: );
434: --

Line 462: when hr_api.cannot_find_prog_unit then

458: ,p_effective_date => trunc(p_effective_date)
459: ,p_datetrack_mode => p_datetrack_mode
460: );
461: exception
462: when hr_api.cannot_find_prog_unit then
463: hr_api.cannot_find_prog_unit_error
464: (p_module_name => 'DELETE_PL_EXTRACT_ID'
465: ,p_hook_type => 'AP'
466: );

Line 463: hr_api.cannot_find_prog_unit_error

459: ,p_datetrack_mode => p_datetrack_mode
460: );
461: exception
462: when hr_api.cannot_find_prog_unit then
463: hr_api.cannot_find_prog_unit_error
464: (p_module_name => 'DELETE_PL_EXTRACT_ID'
465: ,p_hook_type => 'AP'
466: );
467: --

Line 477: raise hr_api.validate_enabled;

473: --
474: -- When in validation only mode raise the Validate_Enabled exception
475: --
476: if p_validate then
477: raise hr_api.validate_enabled;
478: end if;
479: --
480: hr_utility.set_location(' Leaving:'||l_proc, 70);
481: --

Line 484: when hr_api.validate_enabled then

480: hr_utility.set_location(' Leaving:'||l_proc, 70);
481: --
482: exception
483: --
484: when hr_api.validate_enabled then
485: --
486: -- As the Validate_Enabled exception has been raised
487: -- we must rollback to the savepoint
488: --