18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK1') Then
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_CRT_RT_ELMNT');
23: hr_utility.raise_error;
24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
19: Begin
20: --
21: If (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK1') Then
22: hr_utility.set_message(8302, 'PQH_RBC_INVALID_CRT_RT_ELMNT');
23: hr_utility.raise_error;
24: /*fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;*/
28: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK3') Then
29: hr_utility.set_message(8302, 'PQH_RBC_INVALID_BUSINESS_GRP');
30: hr_utility.raise_error;
31: /* fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: fnd_message.set_token('PROCEDURE', l_proc);
33: fnd_message.set_token('STEP','10');
34: fnd_message.raise_error; */
37: fnd_message.set_token('PROCEDURE', l_proc);
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
45: hr_utility.raise_error;
38: fnd_message.set_token('STEP','15');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
45: hr_utility.raise_error;
46: Else
40: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK4') Then
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
41: hr_utility.set_message(8302, 'PQH_RBC_INVALID_ELEMENT_TYPE');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PQH_RATE_ELEMENT_RELATIONS_FK5') Then
44: hr_utility.set_message(8302, 'PQH_RBC_INVALID_INPUT_VALUE');
45: hr_utility.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
154: --
155: l_proc varchar2(72) := g_package||'lck';
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: hr_api.mandatory_arg_error
161: (p_api_name => l_proc
162: ,p_argument => 'RATE_ELEMENT_RELATION_ID'
161: (p_api_name => l_proc
162: ,p_argument => 'RATE_ELEMENT_RELATION_ID'
163: ,p_argument_value => p_rate_element_relation_id
164: );
165: hr_utility.set_location(l_proc,6);
166: hr_api.mandatory_arg_error
167: (p_api_name => l_proc
168: ,p_argument => 'OBJECT_VERSION_NUMBER'
169: ,p_argument_value => p_object_version_number
185: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
186: fnd_message.raise_error;
187: End If;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: --
191: -- We need to trap the ORA LOCK exception
192: --
193: Exception