33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ACTY_BASE_RT_FK4') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_ACTY_BASE_RT_FK4') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: --
36: If (p_constraint_name = 'BEN_ACTY_BASE_RT_FK4') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: If (p_constraint_name = 'BEN_ACTY_BASE_RT_FK4') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ENRT_RT_DT1') Then
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ENRT_RT_DT1') Then
47: ben_utility.child_exists_error(p_table_name =>
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ENRT_RT_DT1') Then
47: ben_utility.child_exists_error(p_table_name =>
48: 'BEN_ENRT_RT');
41: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ENRT_RT_DT1') Then
47: ben_utility.child_exists_error(p_table_name =>
48: 'BEN_ENRT_RT');
49: ElsIf (p_constraint_name = 'BEN_PRTT_RT_VAL_DT5') Then
62: hr_utility.raise_error;
63:
64:
65: Else
66: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
67: fnd_message.set_token('PROCEDURE', l_proc);
68: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
69: fnd_message.raise_error;
70: End If;
63:
64:
65: Else
66: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
67: fnd_message.set_token('PROCEDURE', l_proc);
68: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
69: fnd_message.raise_error;
70: End If;
71: --
64:
65: Else
66: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
67: fnd_message.set_token('PROCEDURE', l_proc);
68: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
69: fnd_message.raise_error;
70: End If;
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
65: Else
66: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
67: fnd_message.set_token('PROCEDURE', l_proc);
68: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
69: fnd_message.raise_error;
70: End If;
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: End constraint_error;
260: Close C_Sel1;
261: --
262: -- The primary key is invalid therefore we must error
263: --
264: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
265: fnd_message.raise_error;
266: End If;
267: Close C_Sel1;
268: If (p_object_version_number <> g_old_rec.object_version_number) Then
261: --
262: -- The primary key is invalid therefore we must error
263: --
264: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
265: fnd_message.raise_error;
266: End If;
267: Close C_Sel1;
268: If (p_object_version_number <> g_old_rec.object_version_number) Then
269: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
265: fnd_message.raise_error;
266: End If;
267: Close C_Sel1;
268: If (p_object_version_number <> g_old_rec.object_version_number) Then
269: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
270: fnd_message.raise_error;
271: End If;
272: hr_utility.set_location(l_proc, 15);
273: l_fct_ret := true;
266: End If;
267: Close C_Sel1;
268: If (p_object_version_number <> g_old_rec.object_version_number) Then
269: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
270: fnd_message.raise_error;
271: End If;
272: hr_utility.set_location(l_proc, 15);
273: l_fct_ret := true;
274: End If;
359: l_parent_key_value15,
360: l_parent_key_value16;
361: If C_Sel1%notfound then
362: Close C_Sel1;
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','10');
366: fnd_message.raise_error;
367: End If;
360: l_parent_key_value16;
361: If C_Sel1%notfound then
362: Close C_Sel1;
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','10');
366: fnd_message.raise_error;
367: End If;
368: Close C_Sel1;
361: If C_Sel1%notfound then
362: Close C_Sel1;
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','10');
366: fnd_message.raise_error;
367: End If;
368: Close C_Sel1;
369: --
362: Close C_Sel1;
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','10');
366: fnd_message.raise_error;
367: End If;
368: Close C_Sel1;
369: --
370: -- Call the corresponding datetrack api
765: Close C_Sel1;
766: --
767: -- The primary key is invalid therefore we must error
768: --
769: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
770: fnd_message.raise_error;
771: End If;
772: Close C_Sel1;
773: If (p_object_version_number <> g_old_rec.object_version_number) Then
766: --
767: -- The primary key is invalid therefore we must error
768: --
769: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
770: fnd_message.raise_error;
771: End If;
772: Close C_Sel1;
773: If (p_object_version_number <> g_old_rec.object_version_number) Then
774: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
770: fnd_message.raise_error;
771: End If;
772: Close C_Sel1;
773: If (p_object_version_number <> g_old_rec.object_version_number) Then
774: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
775: fnd_message.raise_error;
776: End If;
777: hr_utility.set_location(l_proc, 15);
778: --
771: End If;
772: Close C_Sel1;
773: If (p_object_version_number <> g_old_rec.object_version_number) Then
774: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
775: fnd_message.raise_error;
776: End If;
777: hr_utility.set_location(l_proc, 15);
778: --
779: --
889: -- We are doing a datetrack 'INSERT' which is illegal within this
890: -- procedure therefore we must error (note: to lck on insert the
891: -- private procedure ins_lck should be called).
892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','20');
896: fnd_message.raise_error;
897: End If;
890: -- procedure therefore we must error (note: to lck on insert the
891: -- private procedure ins_lck should be called).
892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','20');
896: fnd_message.raise_error;
897: End If;
898: --
891: -- private procedure ins_lck should be called).
892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','20');
896: fnd_message.raise_error;
897: End If;
898: --
899: -- Set the validation start and end date OUT arguments
892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','20');
896: fnd_message.raise_error;
897: End If;
898: --
899: -- Set the validation start and end date OUT arguments
900: --
925: --
926: -- The object is locked therefore we need to supply a meaningful
927: -- error message.
928: --
929: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
930: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
931: fnd_message.raise_error;
932: When l_object_invalid then
933: --
926: -- The object is locked therefore we need to supply a meaningful
927: -- error message.
928: --
929: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
930: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
931: fnd_message.raise_error;
932: When l_object_invalid then
933: --
934: -- The object doesn't exist or is invalid
927: -- error message.
928: --
929: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
930: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
931: fnd_message.raise_error;
932: When l_object_invalid then
933: --
934: -- The object doesn't exist or is invalid
935: --
932: When l_object_invalid then
933: --
934: -- The object doesn't exist or is invalid
935: --
936: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
937: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
938: fnd_message.raise_error;
939: End lck;
940: --
933: --
934: -- The object doesn't exist or is invalid
935: --
936: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
937: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
938: fnd_message.raise_error;
939: End lck;
940: --
941: -- ----------------------------------------------------------------------------
934: -- The object doesn't exist or is invalid
935: --
936: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
937: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');
938: fnd_message.raise_error;
939: End lck;
940: --
941: -- ----------------------------------------------------------------------------
942: -- |-----------------------------< convert_args >-----------------------------|