DBA Data[Home] [Help]

APPS.BEN_DSQ_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_DED_SCHED_PY_FREQ_PK') 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_RT_DED_SCHED_F_FK2') 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_DED_SCHED_PY_FREQ_PK') 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_RT_DED_SCHED_F_FK2') Then
42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');

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

35: --
36: If (p_constraint_name = 'BEN_DED_SCHED_PY_FREQ_PK') 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_RT_DED_SCHED_F_FK2') Then
42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');
43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then

Line 40: fnd_message.raise_error;

36: If (p_constraint_name = 'BEN_DED_SCHED_PY_FREQ_PK') 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_RT_DED_SCHED_F_FK2') Then
42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');
43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then
44: ben_utility.child_exists_error(p_table_name => 'BEN_PERD_TO_PROC');

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

42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');
43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then
44: ben_utility.child_exists_error(p_table_name => 'BEN_PERD_TO_PROC');
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;

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

43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then
44: ben_utility.child_exists_error(p_table_name => 'BEN_PERD_TO_PROC');
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
51: --

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

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

Line 49: fnd_message.raise_error;

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

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

142: Close C_Sel1;
143: --
144: -- The primary key is invalid therefore we must error
145: --
146: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 147: fnd_message.raise_error;

143: --
144: -- The primary key is invalid therefore we must error
145: --
146: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
152: fnd_message.raise_error;
153: End If;
154: hr_utility.set_location(l_proc, 15);
155: l_fct_ret := true;

Line 152: fnd_message.raise_error;

148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
152: fnd_message.raise_error;
153: End If;
154: hr_utility.set_location(l_proc, 15);
155: l_fct_ret := true;
156: End If;

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

231: Close C_Sel1;
232: --
233: -- The primary key is invalid therefore we must error
234: --
235: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 236: fnd_message.raise_error;

232: --
233: -- The primary key is invalid therefore we must error
234: --
235: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
241: fnd_message.raise_error;
242: End If;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 241: fnd_message.raise_error;

237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
241: fnd_message.raise_error;
242: End If;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
245: --

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

250: --
251: -- The object is locked therefore we need to supply a meaningful
252: -- error message.
253: --
254: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'ben_ded_sched_py_freq');
256: fnd_message.raise_error;
257: End lck;
258: --

Line 255: fnd_message.set_token('TABLE_NAME', 'ben_ded_sched_py_freq');

251: -- The object is locked therefore we need to supply a meaningful
252: -- error message.
253: --
254: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'ben_ded_sched_py_freq');
256: fnd_message.raise_error;
257: End lck;
258: --
259: -- ----------------------------------------------------------------------------

Line 256: fnd_message.raise_error;

252: -- error message.
253: --
254: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'ben_ded_sched_py_freq');
256: fnd_message.raise_error;
257: End lck;
258: --
259: -- ----------------------------------------------------------------------------
260: -- |-----------------------------< convert_args >-----------------------------|