20: --
21: Begin
22: --
23: If (p_constraint_name = 'HXC_LOCKING_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_FK2') Then
21: Begin
22: --
23: If (p_constraint_name = 'HXC_LOCKING_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_FK2') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
22: --
23: If (p_constraint_name = 'HXC_LOCKING_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_FK2') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
23: If (p_constraint_name = 'HXC_LOCKING_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_FK2') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
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 = 'HXC_LOCKING_RULES_FK2') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_FK2') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
27: fnd_message.raise_error;
28: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_FK2') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
28: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_FK2') Then
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','15');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','15');
37: fnd_message.raise_error;
38: Else
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','15');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','15');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
33: ElsIf (p_constraint_name = 'HXC_LOCKING_RULES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','15');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','15');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
36: fnd_message.set_token('STEP','15');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
44: --
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
44: --
45: End constraint_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
44: --
45: End constraint_error;
46: --
98: Close C_Sel1;
99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: End If;
105: Close C_Sel1;
106: --
99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: End If;
105: Close C_Sel1;
106: --
107: l_fct_ret := true;
161: Close C_Sel1;
162: --
163: -- The primary key is invalid therefore we must error
164: --
165: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
166: fnd_message.raise_error;
167: End If;
168: Close C_Sel1;
169: --
162: --
163: -- The primary key is invalid therefore we must error
164: --
165: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
166: fnd_message.raise_error;
167: End If;
168: Close C_Sel1;
169: --
170: --
179: --
180: -- The object is locked therefore we need to supply a meaningful
181: -- error message.
182: --
183: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
184: fnd_message.set_token('TABLE_NAME', 'hxc_locking_rules');
185: fnd_message.raise_error;
186: End lck;
187: --
180: -- The object is locked therefore we need to supply a meaningful
181: -- error message.
182: --
183: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
184: fnd_message.set_token('TABLE_NAME', 'hxc_locking_rules');
185: fnd_message.raise_error;
186: End lck;
187: --
188: -- ----------------------------------------------------------------------------
181: -- error message.
182: --
183: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
184: fnd_message.set_token('TABLE_NAME', 'hxc_locking_rules');
185: fnd_message.raise_error;
186: End lck;
187: --
188: -- ----------------------------------------------------------------------------
189: -- |-----------------------------< convert_args >-----------------------------|