19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_DEFINITIONS_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_DEFINITIONS_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_DEFINITIONS_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_DEFINITIONS_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: --
89: Close C_Sel1;
90: --
91: -- The primary key is invalid therefore we must error
92: --
93: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
94: fnd_message.raise_error;
95: End If;
96: Close C_Sel1;
97: --
90: --
91: -- The primary key is invalid therefore we must error
92: --
93: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
94: fnd_message.raise_error;
95: End If;
96: Close C_Sel1;
97: --
98: l_fct_ret := true;
154: Close C_Sel1;
155: --
156: -- The primary key is invalid therefore we must error
157: --
158: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
159: fnd_message.raise_error;
160: End If;
161: Close C_Sel1;
162: --
155: --
156: -- The primary key is invalid therefore we must error
157: --
158: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
159: fnd_message.raise_error;
160: End If;
161: Close C_Sel1;
162: --
163: --
172: --
173: -- The object is locked therefore we need to supply a meaningful
174: -- error message.
175: --
176: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
177: fnd_message.set_token('TABLE_NAME', 'hxc_alias_definitions_tl');
178: fnd_message.raise_error;
179: End lck;
180: --
173: -- The object is locked therefore we need to supply a meaningful
174: -- error message.
175: --
176: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
177: fnd_message.set_token('TABLE_NAME', 'hxc_alias_definitions_tl');
178: fnd_message.raise_error;
179: End lck;
180: --
181: -- ----------------------------------------------------------------------------
174: -- error message.
175: --
176: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
177: fnd_message.set_token('TABLE_NAME', 'hxc_alias_definitions_tl');
178: fnd_message.raise_error;
179: End lck;
180: --
181: -- ----------------------------------------------------------------------------
182: -- |----------------------------< add_language >------------------------------|