53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: --
56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: --
56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
56: If (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK2') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
59: fnd_message.set_token('STEP','5');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
64: fnd_message.set_token('STEP','10');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
66: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_DECD_FK1') Then
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
73: open c2;
74: fetch c2 into l_name;
67: fnd_message.set_name('BEN', 'BEN_92477_ELMT_HAS_CHLD2');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK1') Then
70: fnd_message.set_name('BEN', 'BEN_92476_ELMT_HAS_CHLD1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
73: open c2;
74: fetch c2 into l_name;
75: close c2;
72: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_FK3') Then
73: open c2;
74: fetch c2 into l_name;
75: close c2;
76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
77: fnd_message.set_token('DATA_ELMT', l_name);
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
73: open c2;
74: fetch c2 into l_name;
75: close c2;
76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
77: fnd_message.set_token('DATA_ELMT', l_name);
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
81: fetch c3 into l_name;
74: fetch c2 into l_name;
75: close c2;
76: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
77: fnd_message.set_token('DATA_ELMT', l_name);
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
81: fetch c3 into l_name;
82: close c3;
79: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') Then
80: open c3;
81: fetch c3 into l_name;
82: close c3;
83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
84: fnd_message.set_token('DATA_ELMT', l_name);
85: fnd_message.raise_error;
86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;
80: open c3;
81: fetch c3 into l_name;
82: close c3;
83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
84: fnd_message.set_token('DATA_ELMT', l_name);
85: fnd_message.raise_error;
86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;
88: fetch c1 into l_name;
81: fetch c3 into l_name;
82: close c3;
83: fnd_message.set_name('BEN', 'BEN_92475_ELMT_USED_IN_TTL');
84: fnd_message.set_token('DATA_ELMT', l_name);
85: fnd_message.raise_error;
86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;
88: fetch c1 into l_name;
89: close c1;
86: ElsIf (p_constraint_name = 'BEN_EXT_DATA_ELMT_IN_RCD_FK1') Then
87: open c1;
88: fetch c1 into l_name;
89: close c1;
90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
87: open c1;
88: fetch c1 into l_name;
89: close c1;
90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
88: fetch c1 into l_name;
89: close c1;
90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
90: fnd_message.set_name('BEN', 'BEN_92474_ELMT_USED_IN_RCD');
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:
91: fnd_message.set_token('RECORD', l_name);
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:
99: End If;
92: fnd_message.raise_error;
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:
99: End If;
100: --
93: Else
94: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
97: fnd_message.raise_error;
98:
99: End If;
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: Close C_Sel1;
211: --
212: -- The primary key is invalid therefore we must error
213: --
214: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
215: fnd_message.raise_error;
216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then
211: --
212: -- The primary key is invalid therefore we must error
213: --
214: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
215: fnd_message.raise_error;
216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then
219: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
215: fnd_message.raise_error;
216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then
219: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
220: fnd_message.raise_error;
221: End If;
222: hr_utility.set_location(l_proc, 15);
223: l_fct_ret := true;
216: End If;
217: Close C_Sel1;
218: If (p_object_version_number <> g_old_rec.object_version_number) Then
219: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
220: fnd_message.raise_error;
221: End If;
222: hr_utility.set_location(l_proc, 15);
223: l_fct_ret := true;
224: End If;
318: Close C_Sel1;
319: --
320: -- The primary key is invalid therefore we must error
321: --
322: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
323: fnd_message.raise_error;
324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then
319: --
320: -- The primary key is invalid therefore we must error
321: --
322: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
323: fnd_message.raise_error;
324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then
327: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
323: fnd_message.raise_error;
324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then
327: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
328: fnd_message.raise_error;
329: End If;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: End If;
325: Close C_Sel1;
326: If (p_object_version_number <> g_old_rec.object_version_number) Then
327: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
328: fnd_message.raise_error;
329: End If;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: --
337: --
338: -- The object is locked therefore we need to supply a meaningful
339: -- error message.
340: --
341: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
342: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt');
343: fnd_message.raise_error;
344: End lck;
345: --
338: -- The object is locked therefore we need to supply a meaningful
339: -- error message.
340: --
341: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
342: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt');
343: fnd_message.raise_error;
344: End lck;
345: --
346: -- ----------------------------------------------------------------------------
339: -- error message.
340: --
341: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
342: fnd_message.set_token('TABLE_NAME', 'ben_ext_data_elmt');
343: fnd_message.raise_error;
344: End lck;
345: --
346: -- ----------------------------------------------------------------------------
347: -- |-----------------------------< convert_args >-----------------------------|