18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_EVENT_PROCEDURES_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
19: Begin
20: --
21: If (p_constraint_name = 'PAY_EVENT_PROCEDURES_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
20: --
21: If (p_constraint_name = 'PAY_EVENT_PROCEDURES_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PAY_EVENT_PROCEDURES_FK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
26: ElsIf (p_constraint_name = 'PAY_EVENT_PROCEDURE_PK') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
37: --
30: fnd_message.raise_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
37: --
38: End constraint_error;
31: Else
32: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.raise_error;
36: End If;
37: --
38: End constraint_error;
39: --
94: Close C_Sel1;
95: --
96: -- The primary key is invalid therefore we must error
97: --
98: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
99: fnd_message.raise_error;
100: End If;
101: Close C_Sel1;
102: If (p_object_version_number
95: --
96: -- The primary key is invalid therefore we must error
97: --
98: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
99: fnd_message.raise_error;
100: End If;
101: Close C_Sel1;
102: If (p_object_version_number
103: <> pay_evp_shd.g_old_rec.object_version_number) Then
100: End If;
101: Close C_Sel1;
102: If (p_object_version_number
103: <> pay_evp_shd.g_old_rec.object_version_number) Then
104: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
105: fnd_message.raise_error;
106: End If;
107: l_fct_ret := true;
108: End If;
101: Close C_Sel1;
102: If (p_object_version_number
103: <> pay_evp_shd.g_old_rec.object_version_number) Then
104: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
105: fnd_message.raise_error;
106: End If;
107: l_fct_ret := true;
108: End If;
109: End If;
151: Close C_Sel1;
152: --
153: -- The primary key is invalid therefore we must error
154: --
155: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
156: fnd_message.raise_error;
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
152: --
153: -- The primary key is invalid therefore we must error
154: --
155: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
156: fnd_message.raise_error;
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
160: <> pay_evp_shd.g_old_rec.object_version_number) Then
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
160: <> pay_evp_shd.g_old_rec.object_version_number) Then
161: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
162: fnd_message.raise_error;
163: End If;
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: Close C_Sel1;
159: If (p_object_version_number
160: <> pay_evp_shd.g_old_rec.object_version_number) Then
161: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
162: fnd_message.raise_error;
163: End If;
164: --
165: hr_utility.set_location(' Leaving:'||l_proc, 10);
166: --
171: --
172: -- The object is locked therefore we need to supply a meaningful
173: -- error message.
174: --
175: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
176: fnd_message.set_token('TABLE_NAME', 'pay_event_procedures');
177: fnd_message.raise_error;
178: End lck;
179: --
172: -- The object is locked therefore we need to supply a meaningful
173: -- error message.
174: --
175: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
176: fnd_message.set_token('TABLE_NAME', 'pay_event_procedures');
177: fnd_message.raise_error;
178: End lck;
179: --
180: -- ----------------------------------------------------------------------------
173: -- error message.
174: --
175: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
176: fnd_message.set_token('TABLE_NAME', 'pay_event_procedures');
177: fnd_message.raise_error;
178: End lck;
179: --
180: -- ----------------------------------------------------------------------------
181: -- |-----------------------------< convert_args >-----------------------------|