33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') Then
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: --
36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: If (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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_EXT_WHERE_CLAUSE_FK2') 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');
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_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
41: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK2') 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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
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_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
46: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') Then
57: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
58: fnd_message.set_token('PROCEDURE', l_proc);
51: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK4') Then
52: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') 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','25');
53: fnd_message.set_token('PROCEDURE', l_proc);
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') 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','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
54: fnd_message.set_token('STEP','20');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') 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','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') 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','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_PK') Then
62: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
63: fnd_message.set_token('PROCEDURE', l_proc);
56: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_FK6') 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','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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','30');
58: fnd_message.set_token('PROCEDURE', l_proc);
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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','30');
65: fnd_message.raise_error;
66: Else
59: fnd_message.set_token('STEP','25');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
60: fnd_message.raise_error;
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
61: ElsIf (p_constraint_name = 'BEN_EXT_WHERE_CLAUSE_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','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
63: fnd_message.set_token('PROCEDURE', l_proc);
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;
64: fnd_message.set_token('STEP','30');
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;
72: --
65: fnd_message.raise_error;
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;
72: --
73: hr_utility.set_location(' Leaving:'||l_proc, 10);
66: Else
67: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
68: fnd_message.set_token('PROCEDURE', l_proc);
69: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
70: fnd_message.raise_error;
71: End If;
72: --
73: hr_utility.set_location(' Leaving:'||l_proc, 10);
74: End constraint_error;
144: Close C_Sel1;
145: --
146: -- The primary key is invalid therefore we must error
147: --
148: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
145: --
146: -- The primary key is invalid therefore we must error
147: --
148: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
149: fnd_message.raise_error;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: End If;
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;
150: End If;
151: Close C_Sel1;
152: If (p_object_version_number <> g_old_rec.object_version_number) Then
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: End If;
156: hr_utility.set_location(l_proc, 15);
157: l_fct_ret := true;
158: End If;
214: Close C_Sel1;
215: --
216: -- The primary key is invalid therefore we must error
217: --
218: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
219: fnd_message.raise_error;
220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then
215: --
216: -- The primary key is invalid therefore we must error
217: --
218: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
219: fnd_message.raise_error;
220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then
223: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
219: fnd_message.raise_error;
220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then
223: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
224: fnd_message.raise_error;
225: End If;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: End If;
221: Close C_Sel1;
222: If (p_object_version_number <> g_old_rec.object_version_number) Then
223: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
224: fnd_message.raise_error;
225: End If;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: --
233: --
234: -- The object is locked therefore we need to supply a meaningful
235: -- error message.
236: --
237: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
238: fnd_message.set_token('TABLE_NAME', 'ben_ext_where_clause');
239: fnd_message.raise_error;
240: End lck;
241: --
234: -- The object is locked therefore we need to supply a meaningful
235: -- error message.
236: --
237: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
238: fnd_message.set_token('TABLE_NAME', 'ben_ext_where_clause');
239: fnd_message.raise_error;
240: End lck;
241: --
242: -- ----------------------------------------------------------------------------
235: -- error message.
236: --
237: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
238: fnd_message.set_token('TABLE_NAME', 'ben_ext_where_clause');
239: fnd_message.raise_error;
240: End lck;
241: --
242: -- ----------------------------------------------------------------------------
243: -- |-----------------------------< convert_args >-----------------------------|