18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQH_FR_EMP_STAT_SITUATIONS_PK') 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: Else
19: Begin
20: --
21: If (p_constraint_name = 'PQH_FR_EMP_STAT_SITUATIONS_PK') 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: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
20: --
21: If (p_constraint_name = 'PQH_FR_EMP_STAT_SITUATIONS_PK') 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: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PQH_FR_EMP_STAT_SITUATIONS_PK') 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: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
34: --
129: Close C_Sel1;
130: --
131: -- The primary key is invalid therefore we must error
132: --
133: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
134: fnd_message.raise_error;
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
130: --
131: -- The primary key is invalid therefore we must error
132: --
133: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
134: fnd_message.raise_error;
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> pqh_psu_shd.g_old_rec.object_version_number) Then
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> pqh_psu_shd.g_old_rec.object_version_number) Then
139: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
140: fnd_message.raise_error;
141: End If;
142: l_fct_ret := true;
143: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> pqh_psu_shd.g_old_rec.object_version_number) Then
139: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
140: fnd_message.raise_error;
141: End If;
142: l_fct_ret := true;
143: End If;
144: End If;
232: Close C_Sel1;
233: --
234: -- The primary key is invalid therefore we must error
235: --
236: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
237: fnd_message.raise_error;
238: End If;
239: Close C_Sel1;
240: If (p_object_version_number
233: --
234: -- The primary key is invalid therefore we must error
235: --
236: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
237: fnd_message.raise_error;
238: End If;
239: Close C_Sel1;
240: If (p_object_version_number
241: <> pqh_psu_shd.g_old_rec.object_version_number) Then
238: End If;
239: Close C_Sel1;
240: If (p_object_version_number
241: <> pqh_psu_shd.g_old_rec.object_version_number) Then
242: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
243: fnd_message.raise_error;
244: End If;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: Close C_Sel1;
240: If (p_object_version_number
241: <> pqh_psu_shd.g_old_rec.object_version_number) Then
242: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
243: fnd_message.raise_error;
244: End If;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
247: --
252: --
253: -- The object is locked therefore we need to supply a meaningful
254: -- error message.
255: --
256: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
257: fnd_message.set_token('TABLE_NAME', 'pqh_fr_emp_stat_situations');
258: fnd_message.raise_error;
259: End lck;
260: --
253: -- The object is locked therefore we need to supply a meaningful
254: -- error message.
255: --
256: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
257: fnd_message.set_token('TABLE_NAME', 'pqh_fr_emp_stat_situations');
258: fnd_message.raise_error;
259: End lck;
260: --
261: -- ----------------------------------------------------------------------------
254: -- error message.
255: --
256: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
257: fnd_message.set_token('TABLE_NAME', 'pqh_fr_emp_stat_situations');
258: fnd_message.raise_error;
259: End lck;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |-----------------------------< convert_args >-----------------------------|