19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_TL_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_TL_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
21: --
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_TL_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_TL_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: --
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: --
34: End constraint_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: --
34: End constraint_error;
35: --
87: Close C_Sel1;
88: --
89: -- The primary key is invalid therefore we must error
90: --
91: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
92: fnd_message.raise_error;
93: End If;
94: Close C_Sel1;
95: --
88: --
89: -- The primary key is invalid therefore we must error
90: --
91: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
92: fnd_message.raise_error;
93: End If;
94: Close C_Sel1;
95: --
96: l_fct_ret := true;
150: Close C_Sel1;
151: --
152: -- The primary key is invalid therefore we must error
153: --
154: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
155: fnd_message.raise_error;
156: End If;
157: Close C_Sel1;
158: --
151: --
152: -- The primary key is invalid therefore we must error
153: --
154: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
155: fnd_message.raise_error;
156: End If;
157: Close C_Sel1;
158: --
159: --
168: --
169: -- The object is locked therefore we need to supply a meaningful
170: -- error message.
171: --
172: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
173: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values_tl');
174: fnd_message.raise_error;
175: End lck;
176: --
169: -- The object is locked therefore we need to supply a meaningful
170: -- error message.
171: --
172: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
173: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values_tl');
174: fnd_message.raise_error;
175: End lck;
176: --
177: -- ----------------------------------------------------------------------------
170: -- error message.
171: --
172: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
173: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values_tl');
174: fnd_message.raise_error;
175: End lck;
176: --
177: -- ----------------------------------------------------------------------------
178: -- |----------------------------< add_language >------------------------------|