DBA Data[Home] [Help]

APPS.BEN_PEN_SHD dependencies on FND_MESSAGE

Line 30: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

Line 31: fnd_message.set_token('PROCEDURE', l_proc);

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');

Line 32: fnd_message.set_token('STEP','5');

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);

Line 33: fnd_message.raise_error;

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');

Line 35: 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');
38: fnd_message.raise_error;
39: Else

Line 36: 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
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 37: fnd_message.set_token('STEP','10');

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);

Line 38: 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);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

Line 40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

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;

Line 41: 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;
45: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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;

Line 43: 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;
47: --

Line 169: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

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

Line 170: fnd_message.raise_error;

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');

Line 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;

Line 175: 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;
179: End If;

Line 229: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 230: fnd_message.set_token('PROCEDURE', l_proc);

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;

Line 231: fnd_message.set_token('STEP','10');

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: --

Line 232: fnd_message.raise_error;

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

Line 540: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

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

Line 541: fnd_message.raise_error;

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');

Line 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: --

Line 546: 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: --
550: --

Line 605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 606: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 607: fnd_message.set_token('STEP','20');

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

Line 608: fnd_message.raise_error;

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: --

Line 625: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

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: --

Line 626: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');

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

Line 627: fnd_message.raise_error;

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: --

Line 632: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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: --

Line 633: fnd_message.set_token('TABLE_NAME', 'ben_prtt_enrt_rslt_f');

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: -- ----------------------------------------------------------------------------

Line 634: fnd_message.raise_error;

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 >-----------------------------|