DBA Data[Home] [Help]

APPS.OTA_THG_UPD dependencies on HR_API

Line 87: When hr_api.check_integrity_violated Then

83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: ota_thg_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: --
90: ota_thg_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: ota_thg_shd.constraint_error

Line 92: When hr_api.parent_integrity_violated Then

88: -- A check constraint has been violated
89: --
90: ota_thg_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: ota_thg_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

92: When hr_api.parent_integrity_violated Then
93: -- Parent integrity has been violated
94: --
95: ota_thg_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ota_thg_shd.constraint_error

Line 97: When hr_api.unique_integrity_violated Then

93: -- Parent integrity has been violated
94: --
95: ota_thg_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ota_thg_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

97: When hr_api.unique_integrity_violated Then
98: -- Unique integrity has been violated
99: --
100: ota_thg_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: --
104: Raise;
105: End update_dml;

Line 230: when hr_api.cannot_find_prog_unit then

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

Line 232: hr_api.cannot_find_prog_unit_error

228: exception
229: --
230: when hr_api.cannot_find_prog_unit then
231: --
232: hr_api.cannot_find_prog_unit_error
233: (p_module_name => 'OTA_HR_GL_FLEX_MAPS'
234: ,p_hook_type => 'AU');
235: --
236: end; */

Line 295: If (p_rec.cross_charge_id = hr_api.g_number) then

291: -- p_rec plsql record structure
292: -- to see if a system default is being used. If a system default
293: -- is being used then we must set to the 'current' argument value.
294: --
295: If (p_rec.cross_charge_id = hr_api.g_number) then
296: p_rec.cross_charge_id :=
297: ota_thg_shd.g_old_rec.cross_charge_id;
298: End If;
299: If (p_rec.segment = hr_api.g_varchar2) then

Line 299: If (p_rec.segment = hr_api.g_varchar2) then

295: If (p_rec.cross_charge_id = hr_api.g_number) then
296: p_rec.cross_charge_id :=
297: ota_thg_shd.g_old_rec.cross_charge_id;
298: End If;
299: If (p_rec.segment = hr_api.g_varchar2) then
300: p_rec.segment :=
301: ota_thg_shd.g_old_rec.segment;
302: End If;
303: If (p_rec.segment_num = hr_api.g_number) then

Line 303: If (p_rec.segment_num = hr_api.g_number) then

299: If (p_rec.segment = hr_api.g_varchar2) then
300: p_rec.segment :=
301: ota_thg_shd.g_old_rec.segment;
302: End If;
303: If (p_rec.segment_num = hr_api.g_number) then
304: p_rec.segment_num :=
305: ota_thg_shd.g_old_rec.segment_num;
306: End If;
307: If (p_rec.hr_data_source = hr_api.g_varchar2) then

Line 307: If (p_rec.hr_data_source = hr_api.g_varchar2) then

303: If (p_rec.segment_num = hr_api.g_number) then
304: p_rec.segment_num :=
305: ota_thg_shd.g_old_rec.segment_num;
306: End If;
307: If (p_rec.hr_data_source = hr_api.g_varchar2) then
308: p_rec.hr_data_source :=
309: ota_thg_shd.g_old_rec.hr_data_source;
310: End If;
311: If (p_rec.constant = hr_api.g_varchar2) then

Line 311: If (p_rec.constant = hr_api.g_varchar2) then

307: If (p_rec.hr_data_source = hr_api.g_varchar2) then
308: p_rec.hr_data_source :=
309: ota_thg_shd.g_old_rec.hr_data_source;
310: End If;
311: If (p_rec.constant = hr_api.g_varchar2) then
312: p_rec.constant :=
313: ota_thg_shd.g_old_rec.constant;
314: End If;
315: If (p_rec.hr_cost_segment = hr_api.g_varchar2) then

Line 315: If (p_rec.hr_cost_segment = hr_api.g_varchar2) then

311: If (p_rec.constant = hr_api.g_varchar2) then
312: p_rec.constant :=
313: ota_thg_shd.g_old_rec.constant;
314: End If;
315: If (p_rec.hr_cost_segment = hr_api.g_varchar2) then
316: p_rec.hr_cost_segment :=
317: ota_thg_shd.g_old_rec.hr_cost_segment;
318: End If;
319: --

Line 379: Raise HR_Api.Validate_Enabled;

375: ,p_rec
376: );
377:
378: If p_validate then
379: Raise HR_Api.Validate_Enabled;
380: End If;
381:
382: hr_utility.set_location('Leaving:'||l_proc, 25);
383: Exception

Line 384: When HR_Api.Validate_Enabled Then

380: End If;
381:
382: hr_utility.set_location('Leaving:'||l_proc, 25);
383: Exception
384: When HR_Api.Validate_Enabled Then
385: --
386: -- As the Validate_Enabled exception has been raised
387: -- we must rollback to the savepoint
388: --

Line 401: ,p_cross_charge_id in number default hr_api.g_number

397: Procedure upd
398: (p_effective_date in date
399: ,p_gl_default_segment_id in number
400: ,p_object_version_number in out nocopy number
401: ,p_cross_charge_id in number default hr_api.g_number
402: ,p_segment in varchar2 default hr_api.g_varchar2
403: ,p_segment_num in number default hr_api.g_number
404: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
405: ,p_constant in varchar2 default hr_api.g_varchar2

Line 402: ,p_segment in varchar2 default hr_api.g_varchar2

398: (p_effective_date in date
399: ,p_gl_default_segment_id in number
400: ,p_object_version_number in out nocopy number
401: ,p_cross_charge_id in number default hr_api.g_number
402: ,p_segment in varchar2 default hr_api.g_varchar2
403: ,p_segment_num in number default hr_api.g_number
404: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
405: ,p_constant in varchar2 default hr_api.g_varchar2
406: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2

Line 403: ,p_segment_num in number default hr_api.g_number

399: ,p_gl_default_segment_id in number
400: ,p_object_version_number in out nocopy number
401: ,p_cross_charge_id in number default hr_api.g_number
402: ,p_segment in varchar2 default hr_api.g_varchar2
403: ,p_segment_num in number default hr_api.g_number
404: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
405: ,p_constant in varchar2 default hr_api.g_varchar2
406: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
407: ,p_validate in boolean default false

Line 404: ,p_hr_data_source in varchar2 default hr_api.g_varchar2

400: ,p_object_version_number in out nocopy number
401: ,p_cross_charge_id in number default hr_api.g_number
402: ,p_segment in varchar2 default hr_api.g_varchar2
403: ,p_segment_num in number default hr_api.g_number
404: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
405: ,p_constant in varchar2 default hr_api.g_varchar2
406: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
407: ,p_validate in boolean default false
408: ) is

Line 405: ,p_constant in varchar2 default hr_api.g_varchar2

401: ,p_cross_charge_id in number default hr_api.g_number
402: ,p_segment in varchar2 default hr_api.g_varchar2
403: ,p_segment_num in number default hr_api.g_number
404: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
405: ,p_constant in varchar2 default hr_api.g_varchar2
406: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
407: ,p_validate in boolean default false
408: ) is
409: --

Line 406: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2

402: ,p_segment in varchar2 default hr_api.g_varchar2
403: ,p_segment_num in number default hr_api.g_number
404: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
405: ,p_constant in varchar2 default hr_api.g_varchar2
406: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
407: ,p_validate in boolean default false
408: ) is
409: --
410: l_rec ota_thg_shd.g_rec_type;