APPS.HR_AHC_SHD dependencies on HR_API

Line 21: If (p_constraint_name = 'HR_API_HOOK_CALLS_CK1') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_API_HOOK_CALLS_CK1') Then
22: hr_utility.set_message(800, 'PER_52135_AHC_HK_CALL_TYPE_INV');
23: hr_utility.raise_error;
24:
25: ----------------------------------------------------------------------

Line 30: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_CK2') Then

26: -- This constraint now has two error messages associated with it.
27: -- These are called from the chk_sequence procedure and therefore this
28: -- condition will never be called.
29: ----------------------------------------------------------------------
30: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_CK2') Then
31: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','10');
34: hr_utility.raise_error;

Line 35: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_FK1') Then

31: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','10');
34: hr_utility.raise_error;
35: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_FK1') Then
36: hr_utility.set_message(800, 'PER_52134_AHC_HOOK_ID_INV');
37: hr_utility.raise_error;
38: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_PK') Then
39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 38: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_PK') Then

34: hr_utility.raise_error;
35: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_FK1') Then
36: hr_utility.set_message(800, 'PER_52134_AHC_HOOK_ID_INV');
37: hr_utility.raise_error;
38: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_PK') Then
39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP','20');
42: hr_utility.raise_error;

Line 43: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_UK1') Then

39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP','20');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'HR_API_HOOK_CALLS_UK1') Then
44: hr_utility.set_message(800, 'PER_52139_AHC_DUP_PROC_CALL');
45: hr_utility.raise_error;
46: Else
47: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

Line 84: from hr_api_hook_calls

80: status,
81: object_version_number,
82: application_id,
83: app_install_status
84: from hr_api_hook_calls
85: where api_hook_call_id = p_api_hook_call_id;
86: --
87: l_proc varchar2(72) := g_package||'api_updating';
88: l_fct_ret boolean;

Line 167: from hr_api_hook_calls

163: status,
164: object_version_number,
165: application_id,
166: app_install_status
167: from hr_api_hook_calls
168: where api_hook_call_id = p_api_hook_call_id
169: for update nowait;
170: --
171: l_proc varchar2(72) := g_package||'lck';

Line 178: hr_api.mandatory_arg_error

174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: -- Check that the object version number is set
177: --
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc
180: ,p_argument => 'object_version_number'
181: ,p_argument_value => p_object_version_number
182: );

Line 205: When HR_Api.Object_Locked then

201: --
202: -- We need to trap the ORA LOCK exception
203: --
204: Exception
205: When HR_Api.Object_Locked then
206: --
207: -- The object is locked therefore we need to supply a meaningful
208: -- error message.
209: --

Line 211: hr_utility.set_message_token('TABLE_NAME', 'hr_api_hook_calls');

207: -- The object is locked therefore we need to supply a meaningful
208: -- error message.
209: --
210: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
211: hr_utility.set_message_token('TABLE_NAME', 'hr_api_hook_calls');
212: hr_utility.raise_error;
213: End lck;
214: --
215: -- ----------------------------------------------------------------------------