33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_CHECKLIST_ITEMS_PK') Then
37: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PER_CHECKLIST_ITEMS_U1') Then
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');
41: fnd_message.raise_error;
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PER_CHECKLIST_ITEMS_PK') Then
37: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PER_CHECKLIST_ITEMS_U1') Then
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');
41: fnd_message.raise_error;
42: Else
36: If (p_constraint_name = 'PER_CHECKLIST_ITEMS_PK') Then
37: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PER_CHECKLIST_ITEMS_U1') Then
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'PER_CHECKLIST_ITEMS_U1') Then
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
39: ElsIf (p_constraint_name = 'PER_CHECKLIST_ITEMS_U1') Then
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
40: fnd_message.set_name('PER', 'HR_52779_CHK_ITEM_DUP_VAL');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
48: --
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
48: --
49: hr_utility.set_location(' Leaving:'||l_proc, 10);
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
48: --
49: hr_utility.set_location(' Leaving:'||l_proc, 10);
50: End constraint_error;
141: Close C_Sel1;
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: End If;
148: Close C_Sel1;
149: If (p_object_version_number <> g_old_rec.object_version_number) Then
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: End If;
148: Close C_Sel1;
149: If (p_object_version_number <> g_old_rec.object_version_number) Then
150: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
146: fnd_message.raise_error;
147: End If;
148: Close C_Sel1;
149: If (p_object_version_number <> g_old_rec.object_version_number) Then
150: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
151: fnd_message.raise_error;
152: End If;
153: hr_utility.set_location(l_proc, 15);
154: l_fct_ret := true;
147: End If;
148: Close C_Sel1;
149: If (p_object_version_number <> g_old_rec.object_version_number) Then
150: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
151: fnd_message.raise_error;
152: End If;
153: hr_utility.set_location(l_proc, 15);
154: l_fct_ret := true;
155: End If;
233: Close C_Sel1;
234: --
235: -- The primary key is invalid therefore we must error
236: --
237: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
238: fnd_message.raise_error;
239: End If;
240: Close C_Sel1;
241: If (p_object_version_number <> g_old_rec.object_version_number) Then
234: --
235: -- The primary key is invalid therefore we must error
236: --
237: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
238: fnd_message.raise_error;
239: End If;
240: Close C_Sel1;
241: If (p_object_version_number <> g_old_rec.object_version_number) Then
242: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
238: fnd_message.raise_error;
239: End If;
240: Close C_Sel1;
241: If (p_object_version_number <> g_old_rec.object_version_number) Then
242: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
243: fnd_message.raise_error;
244: End If;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: End If;
240: Close C_Sel1;
241: If (p_object_version_number <> g_old_rec.object_version_number) Then
242: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
243: fnd_message.raise_error;
244: End If;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 10);
247: --
252: --
253: -- The object is locked therefore we need to supply a meaningful
254: -- error message.
255: --
256: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
257: fnd_message.set_token('TABLE_NAME', 'per_checklist_items');
258: fnd_message.raise_error;
259: End lck;
260: --
253: -- The object is locked therefore we need to supply a meaningful
254: -- error message.
255: --
256: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
257: fnd_message.set_token('TABLE_NAME', 'per_checklist_items');
258: fnd_message.raise_error;
259: End lck;
260: --
261: -- ----------------------------------------------------------------------------
254: -- error message.
255: --
256: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
257: fnd_message.set_token('TABLE_NAME', 'per_checklist_items');
258: fnd_message.raise_error;
259: End lck;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |-----------------------------< convert_args >-----------------------------|