APPS.HXC_MPC_UPD dependencies on HR_API

Line 98: When hr_api.check_integrity_violated Then

94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: end if;
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_mpc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_mpc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_mpc_shd.constraint_error

Line 103: When hr_api.parent_integrity_violated Then

99: -- A check constraint has been violated
100: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_mpc_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_mpc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_mpc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_mpc_shd.constraint_error

Line 108: When hr_api.unique_integrity_violated Then

104: -- Parent integrity has been violated
105: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_mpc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_mpc_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_mpc_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;
116: End update_dml;

Line 241: when hr_api.cannot_find_prog_unit then

237: );
238: --
239: exception
240: --
241: when hr_api.cannot_find_prog_unit then
242: --
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'HXC_MAPPING_COMPONENTS'
245: ,p_hook_type => 'AU');

Line 243: hr_api.cannot_find_prog_unit_error

239: exception
240: --
241: when hr_api.cannot_find_prog_unit then
242: --
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'HXC_MAPPING_COMPONENTS'
245: ,p_hook_type => 'AU');
246: --
247: end;

Line 308: If (p_rec.field_name = hr_api.g_varchar2) then

304: -- p_rec plsql record structure
305: -- to see if a system default is being used. If a system default
306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.field_name = hr_api.g_varchar2) then
309: p_rec.field_name :=
310: hxc_mpc_shd.g_old_rec.field_name;
311: End If;
312: If (p_rec.name = hr_api.g_varchar2) then

Line 312: If (p_rec.name = hr_api.g_varchar2) then

308: If (p_rec.field_name = hr_api.g_varchar2) then
309: p_rec.field_name :=
310: hxc_mpc_shd.g_old_rec.field_name;
311: End If;
312: If (p_rec.name = hr_api.g_varchar2) then
313: p_rec.name :=
314: hxc_mpc_shd.g_old_rec.name;
315: End If;
316: If (p_rec.bld_blk_info_type_id = hr_api.g_number) then

Line 316: If (p_rec.bld_blk_info_type_id = hr_api.g_number) then

312: If (p_rec.name = hr_api.g_varchar2) then
313: p_rec.name :=
314: hxc_mpc_shd.g_old_rec.name;
315: End If;
316: If (p_rec.bld_blk_info_type_id = hr_api.g_number) then
317: p_rec.bld_blk_info_type_id :=
318: hxc_mpc_shd.g_old_rec.bld_blk_info_type_id;
319: End If;
320: If (p_rec.segment = hr_api.g_varchar2) then

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

316: If (p_rec.bld_blk_info_type_id = hr_api.g_number) then
317: p_rec.bld_blk_info_type_id :=
318: hxc_mpc_shd.g_old_rec.bld_blk_info_type_id;
319: End If;
320: If (p_rec.segment = hr_api.g_varchar2) then
321: p_rec.segment :=
322: hxc_mpc_shd.g_old_rec.segment;
323: End If;
324: --

Line 383: ,p_field_name in varchar2 default hr_api.g_varchar2

379: -- ----------------------------------------------------------------------------
380: Procedure upd
381: (p_mapping_component_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_field_name in varchar2 default hr_api.g_varchar2
384: ,p_name in varchar2 default hr_api.g_varchar2
385: ,p_bld_blk_info_type_id in number default hr_api.g_varchar2
386: ,p_segment in varchar2 default hr_api.g_varchar2
387: ) is

Line 384: ,p_name in varchar2 default hr_api.g_varchar2

380: Procedure upd
381: (p_mapping_component_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_field_name in varchar2 default hr_api.g_varchar2
384: ,p_name in varchar2 default hr_api.g_varchar2
385: ,p_bld_blk_info_type_id in number default hr_api.g_varchar2
386: ,p_segment in varchar2 default hr_api.g_varchar2
387: ) is
388: --

Line 385: ,p_bld_blk_info_type_id in number default hr_api.g_varchar2

381: (p_mapping_component_id in number
382: ,p_object_version_number in out nocopy number
383: ,p_field_name in varchar2 default hr_api.g_varchar2
384: ,p_name in varchar2 default hr_api.g_varchar2
385: ,p_bld_blk_info_type_id in number default hr_api.g_varchar2
386: ,p_segment in varchar2 default hr_api.g_varchar2
387: ) is
388: --
389: l_rec hxc_mpc_shd.g_rec_type;

Line 386: ,p_segment in varchar2 default hr_api.g_varchar2

382: ,p_object_version_number in out nocopy number
383: ,p_field_name in varchar2 default hr_api.g_varchar2
384: ,p_name in varchar2 default hr_api.g_varchar2
385: ,p_bld_blk_info_type_id in number default hr_api.g_varchar2
386: ,p_segment in varchar2 default hr_api.g_varchar2
387: ) is
388: --
389: l_rec hxc_mpc_shd.g_rec_type;
390: l_proc varchar2(72);