DBA Data[Home] [Help]

APPS.BEN_PGM_SHD dependencies on FND_MESSAGE

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

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PGM_FK1') 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_PGM_F_PK') Then

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

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PGM_FK1') 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_PGM_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

35: --
36: If (p_constraint_name = 'BEN_PGM_FK1') 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_PGM_F_PK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);

Line 40: fnd_message.raise_error;

36: If (p_constraint_name = 'BEN_PGM_FK1') 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_PGM_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');

Line 42: 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_PGM_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: Else

Line 43: 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_PGM_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: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

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

40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_PGM_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: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);

Line 45: fnd_message.raise_error;

41: ElsIf (p_constraint_name = 'BEN_PGM_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: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;

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

44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --

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

45: fnd_message.raise_error;
46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
53: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 50: fnd_message.raise_error;

46: Else
47: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.raise_error;
51: End If;
52: --
53: hr_utility.set_location(' Leaving:'||l_proc, 10);
54: End constraint_error;

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

215: Close C_Sel1;
216: --
217: -- The primary key is invalid therefore we must error
218: --
219: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
220: fnd_message.raise_error;
221: End If;
222: Close C_Sel1;
223: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 220: fnd_message.raise_error;

216: --
217: -- The primary key is invalid therefore we must error
218: --
219: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
220: fnd_message.raise_error;
221: End If;
222: Close C_Sel1;
223: If (p_object_version_number <> g_old_rec.object_version_number) Then
224: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

220: fnd_message.raise_error;
221: End If;
222: Close C_Sel1;
223: If (p_object_version_number <> g_old_rec.object_version_number) Then
224: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
225: fnd_message.raise_error;
226: End If;
227: hr_utility.set_location(l_proc, 15);
228: l_fct_ret := true;

Line 225: fnd_message.raise_error;

221: End If;
222: Close C_Sel1;
223: If (p_object_version_number <> g_old_rec.object_version_number) Then
224: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
225: fnd_message.raise_error;
226: End If;
227: hr_utility.set_location(l_proc, 15);
228: l_fct_ret := true;
229: End If;

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

275: l_parent_key_value5,
276: l_parent_key_value6;
277: If C_Sel1%notfound then
278: Close C_Sel1;
279: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE', l_proc);
281: fnd_message.set_token('STEP','10');
282: fnd_message.raise_error;
283: End If;

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

276: l_parent_key_value6;
277: If C_Sel1%notfound then
278: Close C_Sel1;
279: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE', l_proc);
281: fnd_message.set_token('STEP','10');
282: fnd_message.raise_error;
283: End If;
284: Close C_Sel1;

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

277: If C_Sel1%notfound then
278: Close C_Sel1;
279: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE', l_proc);
281: fnd_message.set_token('STEP','10');
282: fnd_message.raise_error;
283: End If;
284: Close C_Sel1;
285: --

Line 282: fnd_message.raise_error;

278: Close C_Sel1;
279: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
280: fnd_message.set_token('PROCEDURE', l_proc);
281: fnd_message.set_token('STEP','10');
282: fnd_message.raise_error;
283: End If;
284: Close C_Sel1;
285: --
286: -- Call the corresponding datetrack api

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

569: Close C_Sel1;
570: --
571: -- The primary key is invalid therefore we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
574: fnd_message.raise_error;
575: End If;
576: Close C_Sel1;
577: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 574: fnd_message.raise_error;

570: --
571: -- The primary key is invalid therefore we must error
572: --
573: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
574: fnd_message.raise_error;
575: End If;
576: Close C_Sel1;
577: If (p_object_version_number <> g_old_rec.object_version_number) Then
578: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

574: fnd_message.raise_error;
575: End If;
576: Close C_Sel1;
577: If (p_object_version_number <> g_old_rec.object_version_number) Then
578: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
579: fnd_message.raise_error;
580: End If;
581: hr_utility.set_location(l_proc, 15);
582: --

Line 579: fnd_message.raise_error;

575: End If;
576: Close C_Sel1;
577: If (p_object_version_number <> g_old_rec.object_version_number) Then
578: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
579: fnd_message.raise_error;
580: End If;
581: hr_utility.set_location(l_proc, 15);
582: --
583: --

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

669: -- We are doing a datetrack 'INSERT' which is illegal within this
670: -- procedure therefore we must error (note: to lck on insert the
671: -- private procedure ins_lck should be called).
672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','20');
676: fnd_message.raise_error;
677: End If;

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

670: -- procedure therefore we must error (note: to lck on insert the
671: -- private procedure ins_lck should be called).
672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','20');
676: fnd_message.raise_error;
677: End If;
678: --

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

671: -- private procedure ins_lck should be called).
672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','20');
676: fnd_message.raise_error;
677: End If;
678: --
679: -- Set the validation start and end date OUT arguments

Line 676: fnd_message.raise_error;

672: --
673: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
674: fnd_message.set_token('PROCEDURE', l_proc);
675: fnd_message.set_token('STEP','20');
676: fnd_message.raise_error;
677: End If;
678: --
679: -- Set the validation start and end date OUT arguments
680: --

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

690: --
691: -- The object is locked therefore we need to supply a meaningful
692: -- error message.
693: --
694: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
695: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');
696: fnd_message.raise_error;
697: When l_object_invalid then
698: --

Line 695: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');

691: -- The object is locked therefore we need to supply a meaningful
692: -- error message.
693: --
694: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
695: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');
696: fnd_message.raise_error;
697: When l_object_invalid then
698: --
699: -- The object doesn't exist or is invalid

Line 696: fnd_message.raise_error;

692: -- error message.
693: --
694: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
695: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');
696: fnd_message.raise_error;
697: When l_object_invalid then
698: --
699: -- The object doesn't exist or is invalid
700: --

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

697: When l_object_invalid then
698: --
699: -- The object doesn't exist or is invalid
700: --
701: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
702: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');
703: fnd_message.raise_error;
704: End lck;
705: --

Line 702: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');

698: --
699: -- The object doesn't exist or is invalid
700: --
701: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
702: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');
703: fnd_message.raise_error;
704: End lck;
705: --
706: -- ----------------------------------------------------------------------------

Line 703: fnd_message.raise_error;

699: -- The object doesn't exist or is invalid
700: --
701: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
702: fnd_message.set_token('TABLE_NAME', 'ben_pgm_f');
703: fnd_message.raise_error;
704: End lck;
705: --
706: -- ----------------------------------------------------------------------------
707: -- |-----------------------------< convert_args >-----------------------------|