18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_APPROVER_TYPE_USAGES_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 = 'AME_APPROVER_TYPE_USAGES_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 = 'AME_APPROVER_TYPE_USAGES_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 = 'AME_APPROVER_TYPE_USAGES_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: --
90: Close C_Sel1;
91: --
92: -- The primary key is invalid therefore we must error
93: --
94: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
95: fnd_message.raise_error;
96: End If;
97: Close C_Sel1;
98: If (p_object_version_number
91: --
92: -- The primary key is invalid therefore we must error
93: --
94: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
95: fnd_message.raise_error;
96: End If;
97: Close C_Sel1;
98: If (p_object_version_number
99: <> ame_apu_shd.g_old_rec.object_version_number) Then
96: End If;
97: Close C_Sel1;
98: If (p_object_version_number
99: <> ame_apu_shd.g_old_rec.object_version_number) Then
100: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
101: fnd_message.raise_error;
102: End If;
103: l_fct_ret := true;
104: End If;
97: Close C_Sel1;
98: If (p_object_version_number
99: <> ame_apu_shd.g_old_rec.object_version_number) Then
100: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
101: fnd_message.raise_error;
102: End If;
103: l_fct_ret := true;
104: End If;
105: End If;
234: Close C_Sel1;
235: --
236: -- The primary key is invalid therefore we must error
237: --
238: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
239: fnd_message.raise_error;
240: End If;
241: Close C_Sel1;
242: If (p_object_version_number
235: --
236: -- The primary key is invalid therefore we must error
237: --
238: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
239: fnd_message.raise_error;
240: End If;
241: Close C_Sel1;
242: If (p_object_version_number
243: <> ame_apu_shd.g_old_rec.object_version_number) Then
240: End If;
241: Close C_Sel1;
242: If (p_object_version_number
243: <> ame_apu_shd.g_old_rec.object_version_number) Then
244: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
245: fnd_message.raise_error;
246: End If;
247: --
248: --
241: Close C_Sel1;
242: If (p_object_version_number
243: <> ame_apu_shd.g_old_rec.object_version_number) Then
244: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
245: fnd_message.raise_error;
246: End If;
247: --
248: --
249: --
252: -- We are doing a datetrack 'INSERT' which is illegal within this
253: -- procedure therefore we must error (note: to lck on insert the
254: -- private procedure ins_lck should be called).
255: --
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE', l_proc);
258: fnd_message.set_token('STEP','20');
259: fnd_message.raise_error;
260: End If;
253: -- procedure therefore we must error (note: to lck on insert the
254: -- private procedure ins_lck should be called).
255: --
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE', l_proc);
258: fnd_message.set_token('STEP','20');
259: fnd_message.raise_error;
260: End If;
261: --
254: -- private procedure ins_lck should be called).
255: --
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE', l_proc);
258: fnd_message.set_token('STEP','20');
259: fnd_message.raise_error;
260: End If;
261: --
262: -- Set the validation start and end date OUT arguments
255: --
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE', l_proc);
258: fnd_message.set_token('STEP','20');
259: fnd_message.raise_error;
260: End If;
261: --
262: -- Set the validation start and end date OUT arguments
263: --
278: --
279: -- The object is locked therefore we need to supply a meaningful
280: -- error message.
281: --
282: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
283: fnd_message.set_token('TABLE_NAME', 'ame_approver_type_usages');
284: fnd_message.raise_error;
285: End lck;
286: --
279: -- The object is locked therefore we need to supply a meaningful
280: -- error message.
281: --
282: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
283: fnd_message.set_token('TABLE_NAME', 'ame_approver_type_usages');
284: fnd_message.raise_error;
285: End lck;
286: --
287: -- ----------------------------------------------------------------------------
280: -- error message.
281: --
282: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
283: fnd_message.set_token('TABLE_NAME', 'ame_approver_type_usages');
284: fnd_message.raise_error;
285: End lck;
286: --
287: -- ----------------------------------------------------------------------------
288: -- |-----------------------------< convert_args >-----------------------------|