33: --
34: Begin
35: --
36: If (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK2') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
34: Begin
35: --
36: If (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK2') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: --
36: If (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK2') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: If (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK2') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
41: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_FK3') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: Else
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
46: ElsIf (p_constraint_name = 'PER_ELECTION_CONSTITUENCYS_PK') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
50: fnd_message.raise_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
58: End constraint_error;
51: Else
52: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
55: fnd_message.raise_error;
56: End If;
57: --
58: End constraint_error;
59: --
143: Close C_Sel1;
144: --
145: -- The primary key is invalid therefore we must error
146: --
147: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: End If;
150: Close C_Sel1;
151: If (p_object_version_number
144: --
145: -- The primary key is invalid therefore we must error
146: --
147: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: End If;
150: Close C_Sel1;
151: If (p_object_version_number
152: <> per_eco_shd.g_old_rec.object_version_number) Then
149: End If;
150: Close C_Sel1;
151: If (p_object_version_number
152: <> per_eco_shd.g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: End If;
156: l_fct_ret := true;
157: End If;
150: Close C_Sel1;
151: If (p_object_version_number
152: <> per_eco_shd.g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: End If;
156: l_fct_ret := true;
157: End If;
158: End If;
229: Close C_Sel1;
230: --
231: -- The primary key is invalid therefore we must error
232: --
233: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
234: fnd_message.raise_error;
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
230: --
231: -- The primary key is invalid therefore we must error
232: --
233: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
234: fnd_message.raise_error;
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
238: <> per_eco_shd.g_old_rec.object_version_number) Then
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
238: <> per_eco_shd.g_old_rec.object_version_number) Then
239: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
240: fnd_message.raise_error;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: Close C_Sel1;
237: If (p_object_version_number
238: <> per_eco_shd.g_old_rec.object_version_number) Then
239: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
240: fnd_message.raise_error;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: --
249: --
250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'per_election_constituencys');
255: fnd_message.raise_error;
256: End lck;
257: --
250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'per_election_constituencys');
255: fnd_message.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'per_election_constituencys');
255: fnd_message.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |-----------------------------< convert_args >-----------------------------|