36: Begin
37: hr_utility.set_location('Entering:'||l_proc, 5);
38: --
39: If (p_constraint_name = 'HR_PAB_PK') Then
40: FND_MESSAGE.SET_NAME('PAY', 'HR_51022_HR_INV_PRIMARY_KEY');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'HR_PAB_POSITIVE_MULTIPLIER') Then
43: FND_MESSAGE.SET_NAME('PAY','HR_51024_HR_MULTIP');
44: fnd_message.raise_error;
37: hr_utility.set_location('Entering:'||l_proc, 5);
38: --
39: If (p_constraint_name = 'HR_PAB_PK') Then
40: FND_MESSAGE.SET_NAME('PAY', 'HR_51022_HR_INV_PRIMARY_KEY');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'HR_PAB_POSITIVE_MULTIPLIER') Then
43: FND_MESSAGE.SET_NAME('PAY','HR_51024_HR_MULTIP');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'HR_PAB_UK01') Then
39: If (p_constraint_name = 'HR_PAB_PK') Then
40: FND_MESSAGE.SET_NAME('PAY', 'HR_51022_HR_INV_PRIMARY_KEY');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'HR_PAB_POSITIVE_MULTIPLIER') Then
43: FND_MESSAGE.SET_NAME('PAY','HR_51024_HR_MULTIP');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'HR_PAB_UK01') Then
46: FND_MESSAGE.SET_NAME('PAY','HR_51023_HR_PATT_BIT');
47: fnd_message.raise_error;
40: FND_MESSAGE.SET_NAME('PAY', 'HR_51022_HR_INV_PRIMARY_KEY');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'HR_PAB_POSITIVE_MULTIPLIER') Then
43: FND_MESSAGE.SET_NAME('PAY','HR_51024_HR_MULTIP');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'HR_PAB_UK01') Then
46: FND_MESSAGE.SET_NAME('PAY','HR_51023_HR_PATT_BIT');
47: fnd_message.raise_error;
48: Else
42: ElsIf (p_constraint_name = 'HR_PAB_POSITIVE_MULTIPLIER') Then
43: FND_MESSAGE.SET_NAME('PAY','HR_51024_HR_MULTIP');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'HR_PAB_UK01') Then
46: FND_MESSAGE.SET_NAME('PAY','HR_51023_HR_PATT_BIT');
47: fnd_message.raise_error;
48: Else
49: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
50: fnd_message.set_token('PROCEDURE',l_proc);
43: FND_MESSAGE.SET_NAME('PAY','HR_51024_HR_MULTIP');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'HR_PAB_UK01') Then
46: FND_MESSAGE.SET_NAME('PAY','HR_51023_HR_PATT_BIT');
47: fnd_message.raise_error;
48: Else
49: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
50: fnd_message.set_token('PROCEDURE',l_proc);
51: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
45: ElsIf (p_constraint_name = 'HR_PAB_UK01') Then
46: FND_MESSAGE.SET_NAME('PAY','HR_51023_HR_PATT_BIT');
47: fnd_message.raise_error;
48: Else
49: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
50: fnd_message.set_token('PROCEDURE',l_proc);
51: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
52: fnd_message.raise_error;
53: End If;
46: FND_MESSAGE.SET_NAME('PAY','HR_51023_HR_PATT_BIT');
47: fnd_message.raise_error;
48: Else
49: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
50: fnd_message.set_token('PROCEDURE',l_proc);
51: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
52: fnd_message.raise_error;
53: End If;
54: --
47: fnd_message.raise_error;
48: Else
49: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
50: fnd_message.set_token('PROCEDURE',l_proc);
51: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
52: fnd_message.raise_error;
53: End If;
54: --
55: hr_utility.set_location(' Leaving:'||l_proc, 10);
48: Else
49: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
50: fnd_message.set_token('PROCEDURE',l_proc);
51: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
52: fnd_message.raise_error;
53: End If;
54: --
55: hr_utility.set_location(' Leaving:'||l_proc, 10);
56: End constraint_error;
114: Close C_Sel1;
115: --
116: -- The primary key is invalid therefore we must error
117: --
118: FND_MESSAGE.SET_NAME('PAY', 'HR_51022_HR_INV_PRIMARY_KEY');
119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number <> g_old_rec.object_version_number) Then
115: --
116: -- The primary key is invalid therefore we must error
117: --
118: FND_MESSAGE.SET_NAME('PAY', 'HR_51022_HR_INV_PRIMARY_KEY');
119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number <> g_old_rec.object_version_number) Then
123: FND_MESSAGE.SET_NAME('PAY', 'HR_51026_HR_LOCKED_OBJ');
119: fnd_message.raise_error;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number <> g_old_rec.object_version_number) Then
123: FND_MESSAGE.SET_NAME('PAY', 'HR_51026_HR_LOCKED_OBJ');
124: fnd_message.raise_error;
125: End If;
126: hr_utility.set_location(l_proc, 15);
127: l_fct_ret := true;
120: End If;
121: Close C_Sel1;
122: If (p_object_version_number <> g_old_rec.object_version_number) Then
123: FND_MESSAGE.SET_NAME('PAY', 'HR_51026_HR_LOCKED_OBJ');
124: fnd_message.raise_error;
125: End If;
126: hr_utility.set_location(l_proc, 15);
127: l_fct_ret := true;
128: End If;
172: Close C_Sel1;
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: FND_MESSAGE.SET_NAME('PAY', 'HR_51022_HR_INV_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_51022_HR_INV_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_51027_HR_INV_OBJ');
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_51027_HR_INV_OBJ');
182: fnd_message.raise_error;
183: End If;
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
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_51027_HR_INV_OBJ');
182: fnd_message.raise_error;
183: End If;
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: --
191: --
192: -- The object is locked therefore we need to supply a meaningful
193: -- error message.
194: --
195: FND_MESSAGE.SET_NAME('PAY', 'HR_51026_HR_LOCKED_OBJ');
196: fnd_message.raise_error;
197: End lck;
198: --
199: -- ----------------------------------------------------------------------------
192: -- The object is locked therefore we need to supply a meaningful
193: -- error message.
194: --
195: FND_MESSAGE.SET_NAME('PAY', 'HR_51026_HR_LOCKED_OBJ');
196: fnd_message.raise_error;
197: End lck;
198: --
199: -- ----------------------------------------------------------------------------
200: -- |-----------------------------< convert_args >-----------------------------|