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