26: l_proc varchar2(72) := g_package||'constraint_error';
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 5);
29: If (p_constraint_name = 'BEN_PRTT_ENRT_RSLT_PK') Then
30: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: fnd_message.set_token('PROCEDURE', l_proc);
32: fnd_message.set_token('STEP','5');
33: fnd_message.raise_error;
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 5);
29: If (p_constraint_name = 'BEN_PRTT_ENRT_RSLT_PK') Then
30: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: fnd_message.set_token('PROCEDURE', l_proc);
32: fnd_message.set_token('STEP','5');
33: fnd_message.raise_error;
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_location('Entering:'||l_proc, 5);
29: If (p_constraint_name = 'BEN_PRTT_ENRT_RSLT_PK') Then
30: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: fnd_message.set_token('PROCEDURE', l_proc);
32: fnd_message.set_token('STEP','5');
33: fnd_message.raise_error;
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
29: If (p_constraint_name = 'BEN_PRTT_ENRT_RSLT_PK') Then
30: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: fnd_message.set_token('PROCEDURE', l_proc);
32: fnd_message.set_token('STEP','5');
33: fnd_message.raise_error;
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','10');
31: fnd_message.set_token('PROCEDURE', l_proc);
32: fnd_message.set_token('STEP','5');
33: fnd_message.raise_error;
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','10');
38: fnd_message.raise_error;
39: Else
32: fnd_message.set_token('STEP','5');
33: fnd_message.raise_error;
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','10');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: fnd_message.raise_error;
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','10');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
34: ElsIf (p_constraint_name = 'BEN_PRTT_ENR_RSLT_FK6') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','10');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','10');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
37: fnd_message.set_token('STEP','10');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: hr_utility.set_location(' Leaving:'||l_proc, 10);
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: hr_utility.set_location(' Leaving:'||l_proc, 10);
46: End constraint_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: hr_utility.set_location(' Leaving:'||l_proc, 10);
46: End constraint_error;
47: --
165: Close C_Sel1;
166: --
167: -- The primary key is invalid therefore we must error
168: --
169: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
170: fnd_message.raise_error;
171: End If;
172: Close C_Sel1;
173: If (p_object_version_number <> g_old_rec.object_version_number) Then
166: --
167: -- The primary key is invalid therefore we must error
168: --
169: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
170: fnd_message.raise_error;
171: End If;
172: Close C_Sel1;
173: If (p_object_version_number <> g_old_rec.object_version_number) Then
174: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
170: fnd_message.raise_error;
171: End If;
172: Close C_Sel1;
173: If (p_object_version_number <> g_old_rec.object_version_number) Then
174: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
175: fnd_message.raise_error;
176: End If;
177: hr_utility.set_location(l_proc, 15);
178: l_fct_ret := true;
171: End If;
172: Close C_Sel1;
173: If (p_object_version_number <> g_old_rec.object_version_number) Then
174: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
175: fnd_message.raise_error;
176: End If;
177: hr_utility.set_location(l_proc, 15);
178: l_fct_ret := true;
179: End If;
225: ,l_parent_key_value6
226: ,l_parent_key_value7;
227: If C_Sel1%notfound then
228: Close C_Sel1;
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: End If;
226: ,l_parent_key_value7;
227: If C_Sel1%notfound then
228: Close C_Sel1;
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: End If;
234: Close C_Sel1;
227: If C_Sel1%notfound then
228: Close C_Sel1;
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: End If;
234: Close C_Sel1;
235: --
228: Close C_Sel1;
229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
230: fnd_message.set_token('PROCEDURE', l_proc);
231: fnd_message.set_token('STEP','10');
232: fnd_message.raise_error;
233: End If;
234: Close C_Sel1;
235: --
236: -- Call the corresponding datetrack api
536: Close C_Sel1;
537: --
538: -- The primary key is invalid therefore we must error
539: --
540: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
541: fnd_message.raise_error;
542: End If;
543: Close C_Sel1;
544: If (p_object_version_number <> g_old_rec.object_version_number) Then
537: --
538: -- The primary key is invalid therefore we must error
539: --
540: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
541: fnd_message.raise_error;
542: End If;
543: Close C_Sel1;
544: If (p_object_version_number <> g_old_rec.object_version_number) Then
545: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
541: fnd_message.raise_error;
542: End If;
543: Close C_Sel1;
544: If (p_object_version_number <> g_old_rec.object_version_number) Then
545: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
546: fnd_message.raise_error;
547: End If;
548: hr_utility.set_location(l_proc, 15);
549: --
542: End If;
543: Close C_Sel1;
544: If (p_object_version_number <> g_old_rec.object_version_number) Then
545: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
546: fnd_message.raise_error;
547: End If;
548: hr_utility.set_location(l_proc, 15);
549: --
550: --
601: -- We are doing a datetrack 'INSERT' which is illegal within this
602: -- procedure therefore we must error (note: to lck on insert the
603: -- private procedure ins_lck should be called).
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','20');
608: fnd_message.raise_error;
609: End If;
602: -- procedure therefore we must error (note: to lck on insert the
603: -- private procedure ins_lck should be called).
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','20');
608: fnd_message.raise_error;
609: End If;
610: --
603: -- private procedure ins_lck should be called).
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','20');
608: fnd_message.raise_error;
609: End If;
610: --
611: -- Set the validation start and end date OUT arguments
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','20');
608: fnd_message.raise_error;
609: End If;
610: --
611: -- Set the validation start and end date OUT arguments
612: --
621: --
622: -- The object is locked therefore we need to supply a meaningful
623: -- error message.
624: --
625: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
626: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
627: fnd_message.raise_error;
628: When l_object_invalid then
629: --
622: -- The object is locked therefore we need to supply a meaningful
623: -- error message.
624: --
625: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
626: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
627: fnd_message.raise_error;
628: When l_object_invalid then
629: --
630: -- The object doesn't exist or is invalid
623: -- error message.
624: --
625: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
626: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
627: fnd_message.raise_error;
628: When l_object_invalid then
629: --
630: -- The object doesn't exist or is invalid
631: --
628: When l_object_invalid then
629: --
630: -- The object doesn't exist or is invalid
631: --
632: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
633: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
634: fnd_message.raise_error;
635: End lck;
636: --
629: --
630: -- The object doesn't exist or is invalid
631: --
632: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
633: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
634: fnd_message.raise_error;
635: End lck;
636: --
637: -- ----------------------------------------------------------------------------
630: -- The object doesn't exist or is invalid
631: --
632: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
633: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');
634: fnd_message.raise_error;
635: End lck;
636: --
637: -- ----------------------------------------------------------------------------
638: -- |-----------------------------< convert_args >-----------------------------|