29: --
30: Begin
31: --
32: If (p_constraint_name = 'BEN_OPTIP_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_OPTIP_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_OPTIP_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_OPTIP_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: --
136: Close C_Sel1;
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: If (p_object_version_number
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
141: fnd_message.raise_error;
142: End If;
143: Close C_Sel1;
144: If (p_object_version_number
145: <> ben_otp_shd.g_old_rec.object_version_number) Then
142: End If;
143: Close C_Sel1;
144: If (p_object_version_number
145: <> ben_otp_shd.g_old_rec.object_version_number) Then
146: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
147: fnd_message.raise_error;
148: End If;
149: l_fct_ret := true;
150: End If;
143: Close C_Sel1;
144: If (p_object_version_number
145: <> ben_otp_shd.g_old_rec.object_version_number) Then
146: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
147: fnd_message.raise_error;
148: End If;
149: l_fct_ret := true;
150: End If;
151: End If;
222: ,l_parent_key_value2
223: ,l_parent_key_value3;
224: If C_Sel1%NOTFOUND then
225: Close C_Sel1;
226: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
227: fnd_message.set_token('PROCEDURE',l_proc);
228: fnd_message.set_token('STEP','10');
229: fnd_message.raise_error;
230: End If;
223: ,l_parent_key_value3;
224: If C_Sel1%NOTFOUND then
225: Close C_Sel1;
226: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
227: fnd_message.set_token('PROCEDURE',l_proc);
228: fnd_message.set_token('STEP','10');
229: fnd_message.raise_error;
230: End If;
231: Close C_Sel1;
224: If C_Sel1%NOTFOUND then
225: Close C_Sel1;
226: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
227: fnd_message.set_token('PROCEDURE',l_proc);
228: fnd_message.set_token('STEP','10');
229: fnd_message.raise_error;
230: End If;
231: Close C_Sel1;
232: --
225: Close C_Sel1;
226: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
227: fnd_message.set_token('PROCEDURE',l_proc);
228: fnd_message.set_token('STEP','10');
229: fnd_message.raise_error;
230: End If;
231: Close C_Sel1;
232: --
233: -- Call the corresponding datetrack api
417: Close C_Sel1;
418: --
419: -- The primary key is invalid therefore we must error
420: --
421: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
422: fnd_message.raise_error;
423: End If;
424: Close C_Sel1;
425: If (p_object_version_number
418: --
419: -- The primary key is invalid therefore we must error
420: --
421: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
422: fnd_message.raise_error;
423: End If;
424: Close C_Sel1;
425: If (p_object_version_number
426: <> ben_otp_shd.g_old_rec.object_version_number) Then
423: End If;
424: Close C_Sel1;
425: If (p_object_version_number
426: <> ben_otp_shd.g_old_rec.object_version_number) Then
427: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
428: fnd_message.raise_error;
429: End If;
430: --
431: --
424: Close C_Sel1;
425: If (p_object_version_number
426: <> ben_otp_shd.g_old_rec.object_version_number) Then
427: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
428: fnd_message.raise_error;
429: End If;
430: --
431: --
432: -- Validate the datetrack mode mode getting the validation start
456: -- We are doing a datetrack 'INSERT' which is illegal within this
457: -- procedure therefore we must error (note: to lck on insert the
458: -- private procedure ins_lck should be called).
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','20');
463: fnd_message.raise_error;
464: End If;
457: -- procedure therefore we must error (note: to lck on insert the
458: -- private procedure ins_lck should be called).
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','20');
463: fnd_message.raise_error;
464: End If;
465: --
458: -- private procedure ins_lck should be called).
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','20');
463: fnd_message.raise_error;
464: End If;
465: --
466: -- Set the validation start and end date OUT arguments
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','20');
463: fnd_message.raise_error;
464: End If;
465: --
466: -- Set the validation start and end date OUT arguments
467: --
477: --
478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
482: fnd_message.set_token('TABLE_NAME', 'ben_optip_f');
483: fnd_message.raise_error;
484: End lck;
485: --
478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
482: fnd_message.set_token('TABLE_NAME', 'ben_optip_f');
483: fnd_message.raise_error;
484: End lck;
485: --
486: -- ----------------------------------------------------------------------------
479: -- error message.
480: --
481: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
482: fnd_message.set_token('TABLE_NAME', 'ben_optip_f');
483: fnd_message.raise_error;
484: End lck;
485: --
486: -- ----------------------------------------------------------------------------
487: -- |-----------------------------< convert_args >-----------------------------|