19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_RESOURCE_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
20: Begin
21: --
22: If (p_constraint_name = 'HXC_RESOURCE_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'HXC_RESOURCE_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'HXC_RESOURCE_RULES_FK1') 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: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
27: ElsIf (p_constraint_name = 'HXC_RESOURCE_RULES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
38: --
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
38: --
39: End constraint_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
38: --
39: End constraint_error;
40: --
100: Close C_Sel1;
101: --
102: -- The primary key is invalid therefore we must error
103: --
104: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
105: fnd_message.raise_error;
106: End If;
107: Close C_Sel1;
108: If (p_object_version_number
101: --
102: -- The primary key is invalid therefore we must error
103: --
104: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
105: fnd_message.raise_error;
106: End If;
107: Close C_Sel1;
108: If (p_object_version_number
109: <> hxc_hrr_shd.g_old_rec.object_version_number) Then
106: End If;
107: Close C_Sel1;
108: If (p_object_version_number
109: <> hxc_hrr_shd.g_old_rec.object_version_number) Then
110: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
111: fnd_message.raise_error;
112: End If;
113: l_fct_ret := true;
114: End If;
107: Close C_Sel1;
108: If (p_object_version_number
109: <> hxc_hrr_shd.g_old_rec.object_version_number) Then
110: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
111: fnd_message.raise_error;
112: End If;
113: l_fct_ret := true;
114: End If;
115: End If;
166: Close C_Sel1;
167: --
168: -- The primary key is invalid therefore we must error
169: --
170: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
171: fnd_message.raise_error;
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number
167: --
168: -- The primary key is invalid therefore we must error
169: --
170: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
171: fnd_message.raise_error;
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number
175: <> hxc_hrr_shd.g_old_rec.object_version_number) Then
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number
175: <> hxc_hrr_shd.g_old_rec.object_version_number) Then
176: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
177: fnd_message.raise_error;
178: End If;
179: --
180: if g_debug then
173: Close C_Sel1;
174: If (p_object_version_number
175: <> hxc_hrr_shd.g_old_rec.object_version_number) Then
176: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
177: fnd_message.raise_error;
178: End If;
179: --
180: if g_debug then
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: --
189: -- The object is locked therefore we need to supply a meaningful
190: -- error message.
191: --
192: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
193: fnd_message.set_token('TABLE_NAME', 'hxc_resource_rules');
194: fnd_message.raise_error;
195: End lck;
196: --
189: -- The object is locked therefore we need to supply a meaningful
190: -- error message.
191: --
192: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
193: fnd_message.set_token('TABLE_NAME', 'hxc_resource_rules');
194: fnd_message.raise_error;
195: End lck;
196: --
197: -- ----------------------------------------------------------------------------
190: -- error message.
191: --
192: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
193: fnd_message.set_token('TABLE_NAME', 'hxc_resource_rules');
194: fnd_message.raise_error;
195: End lck;
196: --
197: -- ----------------------------------------------------------------------------
198: -- |-----------------------------< convert_args >-----------------------------|