DBA Data[Home] [Help]

APPS.BEN_LSF_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_LOS_FCTR_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_LOS_FCTR_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_LOS_FCTR_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_LOS_FCTR_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_LOS_FCTR_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_LOS_FCTR_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_LOS_FCTR_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_LOS_FCTR_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_LOS_FCTR_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_LOSE_RT_FK1') 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_LOS_FCTR_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_LOSE_RT_FK1') Then
47: ben_utility.child_exists_error(p_table_name => 'BEN_LOS_RT_F');

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

40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_LOS_FCTR_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_LOSE_RT_FK1') Then
47: ben_utility.child_exists_error(p_table_name => 'BEN_LOS_RT_F');
48: ElsIf (p_constraint_name = 'BEN_CMB_AGE_LGH_OF_SVC_FCT_FK2') Then

Line 45: fnd_message.raise_error;

41: ElsIf (p_constraint_name = 'BEN_LOS_FCTR_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_LOSE_RT_FK1') Then
47: ben_utility.child_exists_error(p_table_name => 'BEN_LOS_RT_F');
48: ElsIf (p_constraint_name = 'BEN_CMB_AGE_LGH_OF_SVC_FCT_FK2') Then
49: ben_utility.child_exists_error(p_table_name => 'BEN_CMBN_AGE_LGTH_OF_SVC_FCTR');

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

51: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_LOS_PRTE_F');
52: ElsIf (p_constraint_name = 'BEN_VSTG_LOS_RQMT_FK1') Then
53: ben_utility.child_exists_error(p_table_name => 'BEN_VSTG_LOS_RQMT');
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;

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

52: ElsIf (p_constraint_name = 'BEN_VSTG_LOS_RQMT_FK1') Then
53: ben_utility.child_exists_error(p_table_name => 'BEN_VSTG_LOS_RQMT');
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;
60: --

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

53: ben_utility.child_exists_error(p_table_name => 'BEN_VSTG_LOS_RQMT');
54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;
60: --
61: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 58: fnd_message.raise_error;

54: Else
55: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
56: fnd_message.set_token('PROCEDURE', l_proc);
57: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
58: fnd_message.raise_error;
59: End If;
60: --
61: hr_utility.set_location(' Leaving:'||l_proc, 10);
62: End constraint_error;

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

163: Close C_Sel1;
164: --
165: -- The primary key is invalid therefore we must error
166: --
167: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
168: fnd_message.raise_error;
169: End If;
170: Close C_Sel1;
171: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 168: fnd_message.raise_error;

164: --
165: -- The primary key is invalid therefore we must error
166: --
167: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
168: fnd_message.raise_error;
169: End If;
170: Close C_Sel1;
171: If (p_object_version_number <> g_old_rec.object_version_number) Then
172: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

168: fnd_message.raise_error;
169: End If;
170: Close C_Sel1;
171: If (p_object_version_number <> g_old_rec.object_version_number) Then
172: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
173: fnd_message.raise_error;
174: End If;
175: hr_utility.set_location(l_proc, 15);
176: l_fct_ret := true;

Line 173: fnd_message.raise_error;

169: End If;
170: Close C_Sel1;
171: If (p_object_version_number <> g_old_rec.object_version_number) Then
172: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
173: fnd_message.raise_error;
174: End If;
175: hr_utility.set_location(l_proc, 15);
176: l_fct_ret := true;
177: End If;

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

264: Close C_Sel1;
265: --
266: -- The primary key is invalid therefore we must error
267: --
268: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
269: fnd_message.raise_error;
270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 269: fnd_message.raise_error;

265: --
266: -- The primary key is invalid therefore we must error
267: --
268: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
269: fnd_message.raise_error;
270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
273: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

269: fnd_message.raise_error;
270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
273: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
274: fnd_message.raise_error;
275: End If;
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 274: fnd_message.raise_error;

270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
273: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
274: fnd_message.raise_error;
275: End If;
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: --

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

283: --
284: -- The object is locked therefore we need to supply a meaningful
285: -- error message.
286: --
287: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
288: fnd_message.set_token('TABLE_NAME', 'ben_los_fctr');
289: fnd_message.raise_error;
290: End lck;
291: --

Line 288: fnd_message.set_token('TABLE_NAME', 'ben_los_fctr');

284: -- The object is locked therefore we need to supply a meaningful
285: -- error message.
286: --
287: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
288: fnd_message.set_token('TABLE_NAME', 'ben_los_fctr');
289: fnd_message.raise_error;
290: End lck;
291: --
292: -- ----------------------------------------------------------------------------

Line 289: fnd_message.raise_error;

285: -- error message.
286: --
287: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
288: fnd_message.set_token('TABLE_NAME', 'ben_los_fctr');
289: fnd_message.raise_error;
290: End lck;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |-----------------------------< convert_args >-----------------------------|