DBA Data[Home] [Help]

APPS.BEN_XRC_SHD dependencies on FND_MESSAGE

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

42: Begin
43: hr_utility.set_location('Entering:'||l_proc, 5);
44: --
45: If (p_constraint_name = 'BEN_EXT_RCD_FK1') Then
46: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','5');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then

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

43: hr_utility.set_location('Entering:'||l_proc, 5);
44: --
45: If (p_constraint_name = 'BEN_EXT_RCD_FK1') Then
46: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','5');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

44: --
45: If (p_constraint_name = 'BEN_EXT_RCD_FK1') Then
46: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','5');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.set_token('PROCEDURE', l_proc);

Line 49: fnd_message.raise_error;

45: If (p_constraint_name = 'BEN_EXT_RCD_FK1') Then
46: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','5');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('STEP','10');

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

47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('STEP','5');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('STEP','10');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then

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

48: fnd_message.set_token('STEP','5');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('STEP','10');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then
56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');

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

49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('STEP','10');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then
56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');
57: fnd_message.raise_error;

Line 54: fnd_message.raise_error;

50: ElsIf (p_constraint_name = 'BEN_EXT_RCD_PK') Then
51: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('STEP','10');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then
56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK3') Then

Line 56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');

52: fnd_message.set_token('PROCEDURE', l_proc);
53: fnd_message.set_token('STEP','10');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then
56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK3') Then
59: fnd_message.set_name('BEN', 'BEN_92483_XRD_EXISTS');
60: fnd_message.raise_error;

Line 57: fnd_message.raise_error;

53: fnd_message.set_token('STEP','10');
54: fnd_message.raise_error;
55: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then
56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK3') Then
59: fnd_message.set_name('BEN', 'BEN_92483_XRD_EXISTS');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK2') Then

Line 59: fnd_message.set_name('BEN', 'BEN_92483_XRD_EXISTS');

55: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK2') Then
56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK3') Then
59: fnd_message.set_name('BEN', 'BEN_92483_XRD_EXISTS');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK2') Then
62: open c1;
63: fetch c1 into l_name;

Line 60: fnd_message.raise_error;

56: fnd_message.set_name('BEN', 'BEN_92482_XER_EXISTS');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'BEN_EXT_RSLT_DTL_FK3') Then
59: fnd_message.set_name('BEN', 'BEN_92483_XRD_EXISTS');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK2') Then
62: open c1;
63: fetch c1 into l_name;
64: close c1;

Line 65: fnd_message.set_name('BEN', 'BEN_92481_XRF_EXISTS');

61: ElsIf (p_constraint_name = 'BEN_EXT_RCD_IN_FILE_FK2') Then
62: open c1;
63: fetch c1 into l_name;
64: close c1;
65: fnd_message.set_name('BEN', 'BEN_92481_XRF_EXISTS');
66: fnd_message.set_token('FILE_NAME', l_name);
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 66: fnd_message.set_token('FILE_NAME', l_name);

62: open c1;
63: fetch c1 into l_name;
64: close c1;
65: fnd_message.set_name('BEN', 'BEN_92481_XRF_EXISTS');
66: fnd_message.set_token('FILE_NAME', l_name);
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);

Line 67: fnd_message.raise_error;

63: fetch c1 into l_name;
64: close c1;
65: fnd_message.set_name('BEN', 'BEN_92481_XRF_EXISTS');
66: fnd_message.set_token('FILE_NAME', l_name);
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

65: fnd_message.set_name('BEN', 'BEN_92481_XRF_EXISTS');
66: fnd_message.set_token('FILE_NAME', l_name);
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;

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

66: fnd_message.set_token('FILE_NAME', l_name);
67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;
74: --

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

67: fnd_message.raise_error;
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;
74: --
75: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 72: fnd_message.raise_error;

68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
72: fnd_message.raise_error;
73: End If;
74: --
75: hr_utility.set_location(' Leaving:'||l_proc, 10);
76: End constraint_error;

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

172: Close C_Sel1;
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 177: fnd_message.raise_error;

173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number <> g_old_rec.object_version_number) Then
181: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

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

177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number <> g_old_rec.object_version_number) Then
181: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
182: fnd_message.raise_error;
183: End If;
184: hr_utility.set_location(l_proc, 15);
185: l_fct_ret := true;

Line 182: fnd_message.raise_error;

178: End If;
179: Close C_Sel1;
180: If (p_object_version_number <> g_old_rec.object_version_number) Then
181: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
182: fnd_message.raise_error;
183: End If;
184: hr_utility.set_location(l_proc, 15);
185: l_fct_ret := true;
186: End If;

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

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

Line 273: fnd_message.raise_error;

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

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

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

Line 278: fnd_message.raise_error;

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

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

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

Line 292: fnd_message.set_token('TABLE_NAME', 'ben_ext_rcd');

288: -- The object is locked therefore we need to supply a meaningful
289: -- error message.
290: --
291: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
292: fnd_message.set_token('TABLE_NAME', 'ben_ext_rcd');
293: fnd_message.raise_error;
294: End lck;
295: --
296: -- ----------------------------------------------------------------------------

Line 293: fnd_message.raise_error;

289: -- error message.
290: --
291: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
292: fnd_message.set_token('TABLE_NAME', 'ben_ext_rcd');
293: fnd_message.raise_error;
294: End lck;
295: --
296: -- ----------------------------------------------------------------------------
297: -- |-----------------------------< convert_args >-----------------------------|