DBA Data[Home] [Help]

APPS.HR_ABM_INS dependencies on HR_API

Line 63: -- Insert the row into: hr_api_batch_message_lines

59: --
60: --
61: hr_abm_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_batch_message_lines
64: --
65: insert into hr_api_batch_message_lines
66: ( line_id,
67: batch_run_number,

Line 65: insert into hr_api_batch_message_lines

61: hr_abm_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hr_api_batch_message_lines
64: --
65: insert into hr_api_batch_message_lines
66: ( line_id,
67: batch_run_number,
68: api_name,
69: status,

Line 90: When hr_api.check_integrity_violated Then

86: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
93: hr_abm_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
93: hr_abm_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
98: hr_abm_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

91: -- A check constraint has been violated
92: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
93: hr_abm_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
98: hr_abm_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
98: hr_abm_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
103: hr_abm_shd.constraint_error

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
98: hr_abm_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
103: hr_abm_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
103: hr_abm_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: hr_abm_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End insert_dml;

Line 151: Cursor C_Sel1 is select hr_api_batch_message_lines_s.nextval from sys.dual;

147: Procedure pre_insert(p_rec in out hr_abm_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_insert';
150: --
151: Cursor C_Sel1 is select hr_api_batch_message_lines_s.nextval from sys.dual;
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --

Line 204: Raise HR_Api.Validate_Enabled;

200: --
201: -- If we are validating then raise the Validate_Enabled exception
202: --
203: If p_validate then
204: Raise HR_Api.Validate_Enabled;
205: End If;
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: Exception

Line 209: When HR_Api.Validate_Enabled Then

205: End If;
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: Exception
209: When HR_Api.Validate_Enabled Then
210: --
211: -- As the Validate_Enabled exception has been raised
212: -- we must rollback to the savepoint
213: --