DBA Data[Home] [Help]

APPS.BEN_ABR_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_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

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

Line 39: fnd_message.set_token('STEP','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');
43: fnd_message.set_token('PROCEDURE', l_proc);

Line 40: fnd_message.raise_error;

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

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

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

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

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

Line 45: 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');
49: ElsIf (p_constraint_name = 'BEN_PRTT_RT_VAL_DT5') Then

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

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;

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

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

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

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

Line 69: fnd_message.raise_error;

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;

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

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

Line 265: fnd_message.raise_error;

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

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

Line 270: 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;
274: End If;

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

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;

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

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;

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

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

Line 366: fnd_message.raise_error;

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

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

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

Line 770: fnd_message.raise_error;

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

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

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

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

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;

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

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

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

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

Line 896: fnd_message.raise_error;

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

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

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

Line 930: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');

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

Line 931: fnd_message.raise_error;

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

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

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

Line 937: fnd_message.set_token('TABLE_NAME', 'ben_acty_base_rt_f');

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

Line 938: fnd_message.raise_error;

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