29: --
30: Begin
31: --
32: If (p_constraint_name = 'PSP_REPORT_PERIOD_FREQ_B_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
30: Begin
31: --
32: If (p_constraint_name = 'PSP_REPORT_PERIOD_FREQ_B_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
31: --
32: If (p_constraint_name = 'PSP_REPORT_PERIOD_FREQ_B_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: If (p_constraint_name = 'PSP_REPORT_PERIOD_FREQ_B_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;
45: --
99: Close C_Sel1;
100: --
101: -- The primary key is invalid therefore we must error
102: --
103: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
104: fnd_message.raise_error;
105: End If;
106: Close C_Sel1;
107: If (p_object_version_number
100: --
101: -- The primary key is invalid therefore we must error
102: --
103: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
104: fnd_message.raise_error;
105: End If;
106: Close C_Sel1;
107: If (p_object_version_number
108: <> psp_pfb_shd.g_old_rec.object_version_number) Then
105: End If;
106: Close C_Sel1;
107: If (p_object_version_number
108: <> psp_pfb_shd.g_old_rec.object_version_number) Then
109: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
110: fnd_message.raise_error;
111: End If;
112: l_fct_ret := true;
113: End If;
106: Close C_Sel1;
107: If (p_object_version_number
108: <> psp_pfb_shd.g_old_rec.object_version_number) Then
109: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
110: fnd_message.raise_error;
111: End If;
112: l_fct_ret := true;
113: End If;
114: End If;
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: If (p_object_version_number
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: If (p_object_version_number
170: <> psp_pfb_shd.g_old_rec.object_version_number) Then
167: End If;
168: Close C_Sel1;
169: If (p_object_version_number
170: <> psp_pfb_shd.g_old_rec.object_version_number) Then
171: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
172: fnd_message.raise_error;
173: End If;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: Close C_Sel1;
169: If (p_object_version_number
170: <> psp_pfb_shd.g_old_rec.object_version_number) Then
171: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
172: fnd_message.raise_error;
173: End If;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: --
181: --
182: -- The object is locked therefore we need to supply a meaningful
183: -- error message.
184: --
185: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
186: fnd_message.set_token('TABLE_NAME', 'psp_report_period_frequency_b');
187: fnd_message.raise_error;
188: End lck;
189: --
182: -- The object is locked therefore we need to supply a meaningful
183: -- error message.
184: --
185: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
186: fnd_message.set_token('TABLE_NAME', 'psp_report_period_frequency_b');
187: fnd_message.raise_error;
188: End lck;
189: --
190: -- ----------------------------------------------------------------------------
183: -- error message.
184: --
185: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
186: fnd_message.set_token('TABLE_NAME', 'psp_report_period_frequency_b');
187: fnd_message.raise_error;
188: End lck;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |-----------------------------< convert_args >-----------------------------|