20: --
21: Begin
22: --
23: If (p_constraint_name = 'HXC_LOCKER_TYPES_PK') Then
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;
28: Else
21: Begin
22: --
23: If (p_constraint_name = 'HXC_LOCKER_TYPES_PK') Then
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;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
22: --
23: If (p_constraint_name = 'HXC_LOCKER_TYPES_PK') Then
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;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
23: If (p_constraint_name = 'HXC_LOCKER_TYPES_PK') Then
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;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
35: End constraint_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
35: End constraint_error;
36: --
83: Close C_Sel1;
84: --
85: -- The primary key is invalid therefore we must error
86: --
87: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
88: fnd_message.raise_error;
89: End If;
90: Close C_Sel1;
91: --
84: --
85: -- The primary key is invalid therefore we must error
86: --
87: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
88: fnd_message.raise_error;
89: End If;
90: Close C_Sel1;
91: --
92: l_fct_ret := true;
136: Close C_Sel1;
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: --
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: --
145: --
154: --
155: -- The object is locked therefore we need to supply a meaningful
156: -- error message.
157: --
158: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
159: fnd_message.set_token('TABLE_NAME', 'hxc_locker_types');
160: fnd_message.raise_error;
161: End lck;
162: --
155: -- The object is locked therefore we need to supply a meaningful
156: -- error message.
157: --
158: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
159: fnd_message.set_token('TABLE_NAME', 'hxc_locker_types');
160: fnd_message.raise_error;
161: End lck;
162: --
163: -- ----------------------------------------------------------------------------
156: -- error message.
157: --
158: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
159: fnd_message.set_token('TABLE_NAME', 'hxc_locker_types');
160: fnd_message.raise_error;
161: End lck;
162: --
163: -- ----------------------------------------------------------------------------
164: -- |-----------------------------< convert_args >-----------------------------|