16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: --
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: --
29: End constraint_error;
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: --
29: End constraint_error;
30: --
31: -- ----------------------------------------------------------------------------
118: --
119: l_proc varchar2(72) := g_package||'lck';
120: --
121: Begin
122: hr_utility.set_location('Entering:'||l_proc, 5);
123: --
124: hr_api.mandatory_arg_error
125: (p_api_name => l_proc
126: ,p_argument => 'TABLE_ROUTE_ID'
125: (p_api_name => l_proc
126: ,p_argument => 'TABLE_ROUTE_ID'
127: ,p_argument_value => p_table_route_id
128: );
129: hr_utility.set_location(l_proc,6);
130: hr_api.mandatory_arg_error
131: (p_api_name => l_proc
132: ,p_argument => 'LANGUAGE'
133: ,p_argument_value => p_language
145: End If;
146: Close C_Sel1;
147: --
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: --
151: -- We need to trap the ORA LOCK exception
152: --
153: Exception