20: --
21: Begin
22: --
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
21: Begin
22: --
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
22: --
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
35: End constraint_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
35: End constraint_error;
36: --
117: Close C_Sel1;
118: --
119: -- The primary key is invalid therefore we must error
120: --
121: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number
118: --
119: -- The primary key is invalid therefore we must error
120: --
121: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number
126: <> pqh_sts_shd.g_old_rec.object_version_number) Then
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number
126: <> pqh_sts_shd.g_old_rec.object_version_number) Then
127: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
128: fnd_message.raise_error;
129: End If;
130: l_fct_ret := true;
131: End If;
124: Close C_Sel1;
125: If (p_object_version_number
126: <> pqh_sts_shd.g_old_rec.object_version_number) Then
127: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
128: fnd_message.raise_error;
129: End If;
130: l_fct_ret := true;
131: End If;
132: End If;
218: Close C_Sel1;
219: --
220: -- The primary key is invalid therefore we must error
221: --
222: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number
219: --
220: -- The primary key is invalid therefore we must error
221: --
222: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number
227: <> pqh_sts_shd.g_old_rec.object_version_number) Then
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number
227: <> pqh_sts_shd.g_old_rec.object_version_number) Then
228: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
229: fnd_message.raise_error;
230: End If;
231: --
232: if g_debug then
225: Close C_Sel1;
226: If (p_object_version_number
227: <> pqh_sts_shd.g_old_rec.object_version_number) Then
228: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
229: fnd_message.raise_error;
230: End If;
231: --
232: if g_debug then
233: --
242: --
243: -- The object is locked therefore we need to supply a meaningful
244: -- error message.
245: --
246: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
247: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situations');
248: fnd_message.raise_error;
249: End lck;
250: --
243: -- The object is locked therefore we need to supply a meaningful
244: -- error message.
245: --
246: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
247: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situations');
248: fnd_message.raise_error;
249: End lck;
250: --
251: -- ----------------------------------------------------------------------------
244: -- error message.
245: --
246: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
247: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situations');
248: fnd_message.raise_error;
249: End lck;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |-----------------------------< convert_args >-----------------------------|