29: --
30: Begin
31: --
32: If (p_constraint_name = 'BEN_VRBL_RT_ELIG_PRFL_F_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 = 'BEN_VRBL_RT_ELIG_PRFL_F_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 = 'BEN_VRBL_RT_ELIG_PRFL_F_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 = 'BEN_VRBL_RT_ELIG_PRFL_F_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: --
132: Close C_Sel1;
133: --
134: -- The primary key is invalid therefore we must error
135: --
136: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: End If;
139: Close C_Sel1;
140: If (p_object_version_number
133: --
134: -- The primary key is invalid therefore we must error
135: --
136: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: End If;
139: Close C_Sel1;
140: If (p_object_version_number
141: <> ben_vep_shd.g_old_rec.object_version_number) Then
138: End If;
139: Close C_Sel1;
140: If (p_object_version_number
141: <> ben_vep_shd.g_old_rec.object_version_number) Then
142: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
143: fnd_message.raise_error;
144: End If;
145: l_fct_ret := true;
146: End If;
139: Close C_Sel1;
140: If (p_object_version_number
141: <> ben_vep_shd.g_old_rec.object_version_number) Then
142: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
143: fnd_message.raise_error;
144: End If;
145: l_fct_ret := true;
146: End If;
147: End If;
216: l_parent_key_value1
217: ,l_parent_key_value2 ;
218: If C_Sel1%NOTFOUND then
219: Close C_Sel1;
220: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE',l_proc);
222: fnd_message.set_token('STEP','10');
223: fnd_message.raise_error;
224: End If;
217: ,l_parent_key_value2 ;
218: If C_Sel1%NOTFOUND then
219: Close C_Sel1;
220: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE',l_proc);
222: fnd_message.set_token('STEP','10');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
218: If C_Sel1%NOTFOUND then
219: Close C_Sel1;
220: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE',l_proc);
222: fnd_message.set_token('STEP','10');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: --
219: Close C_Sel1;
220: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
221: fnd_message.set_token('PROCEDURE',l_proc);
222: fnd_message.set_token('STEP','10');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: --
227: -- Call the corresponding datetrack api
404: Close C_Sel1;
405: --
406: -- The primary key is invalid therefore we must error
407: --
408: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
409: fnd_message.raise_error;
410: End If;
411: Close C_Sel1;
412: If (p_object_version_number
405: --
406: -- The primary key is invalid therefore we must error
407: --
408: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
409: fnd_message.raise_error;
410: End If;
411: Close C_Sel1;
412: If (p_object_version_number
413: <> ben_vep_shd.g_old_rec.object_version_number) Then
410: End If;
411: Close C_Sel1;
412: If (p_object_version_number
413: <> ben_vep_shd.g_old_rec.object_version_number) Then
414: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
415: fnd_message.raise_error;
416: End If;
417: --
418: --
411: Close C_Sel1;
412: If (p_object_version_number
413: <> ben_vep_shd.g_old_rec.object_version_number) Then
414: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
415: fnd_message.raise_error;
416: End If;
417: --
418: --
419: -- Validate the datetrack mode mode getting the validation start
440: -- We are doing a datetrack 'INSERT' which is illegal within this
441: -- procedure therefore we must error (note: to lck on insert the
442: -- private procedure ins_lck should be called).
443: --
444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
445: fnd_message.set_token('PROCEDURE', l_proc);
446: fnd_message.set_token('STEP','20');
447: fnd_message.raise_error;
448: End If;
441: -- procedure therefore we must error (note: to lck on insert the
442: -- private procedure ins_lck should be called).
443: --
444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
445: fnd_message.set_token('PROCEDURE', l_proc);
446: fnd_message.set_token('STEP','20');
447: fnd_message.raise_error;
448: End If;
449: --
442: -- private procedure ins_lck should be called).
443: --
444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
445: fnd_message.set_token('PROCEDURE', l_proc);
446: fnd_message.set_token('STEP','20');
447: fnd_message.raise_error;
448: End If;
449: --
450: -- Set the validation start and end date OUT arguments
443: --
444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
445: fnd_message.set_token('PROCEDURE', l_proc);
446: fnd_message.set_token('STEP','20');
447: fnd_message.raise_error;
448: End If;
449: --
450: -- Set the validation start and end date OUT arguments
451: --
461: --
462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
466: fnd_message.set_token('TABLE_NAME', 'BEN_VRBL_RT_ELIG_PRFL_f');
467: fnd_message.raise_error;
468: End lck;
469: --
462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
466: fnd_message.set_token('TABLE_NAME', 'BEN_VRBL_RT_ELIG_PRFL_f');
467: fnd_message.raise_error;
468: End lck;
469: --
470: -- ----------------------------------------------------------------------------
463: -- error message.
464: --
465: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
466: fnd_message.set_token('TABLE_NAME', 'BEN_VRBL_RT_ELIG_PRFL_f');
467: fnd_message.raise_error;
468: End lck;
469: --
470: -- ----------------------------------------------------------------------------
471: -- |-----------------------------< convert_args >-----------------------------|