34: Begin
35: hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'HR_PPU_HIERARCHY_LEVEL') Then
38: fnd_message.set_name('PAY', 'HR_51018_HR_PPU_LEVEL');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'HR_PPU_PK') Then
41: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
42: fnd_message.raise_error;
35: hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'HR_PPU_HIERARCHY_LEVEL') Then
38: fnd_message.set_name('PAY', 'HR_51018_HR_PPU_LEVEL');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'HR_PPU_PK') Then
41: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HR_PPU_UK01') Then
37: If (p_constraint_name = 'HR_PPU_HIERARCHY_LEVEL') Then
38: fnd_message.set_name('PAY', 'HR_51018_HR_PPU_LEVEL');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'HR_PPU_PK') Then
41: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HR_PPU_UK01') Then
44: fnd_message.set_name('PAY', 'HR_51020_HR_PPU_UK01');
45: fnd_message.raise_error;
38: fnd_message.set_name('PAY', 'HR_51018_HR_PPU_LEVEL');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'HR_PPU_PK') Then
41: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HR_PPU_UK01') Then
44: fnd_message.set_name('PAY', 'HR_51020_HR_PPU_UK01');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'HR_PPU_UK02') Then
40: ElsIf (p_constraint_name = 'HR_PPU_PK') Then
41: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HR_PPU_UK01') Then
44: fnd_message.set_name('PAY', 'HR_51020_HR_PPU_UK01');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'HR_PPU_UK02') Then
47: fnd_message.set_name('PAY', 'HR_51021_HR_PPU_UK02');
48: fnd_message.raise_error;
41: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HR_PPU_UK01') Then
44: fnd_message.set_name('PAY', 'HR_51020_HR_PPU_UK01');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'HR_PPU_UK02') Then
47: fnd_message.set_name('PAY', 'HR_51021_HR_PPU_UK02');
48: fnd_message.raise_error;
49: Else
43: ElsIf (p_constraint_name = 'HR_PPU_UK01') Then
44: fnd_message.set_name('PAY', 'HR_51020_HR_PPU_UK01');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'HR_PPU_UK02') Then
47: fnd_message.set_name('PAY', 'HR_51021_HR_PPU_UK02');
48: fnd_message.raise_error;
49: Else
50: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
51: fnd_message.set_token('PROCEDURE',l_proc);
44: fnd_message.set_name('PAY', 'HR_51020_HR_PPU_UK01');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'HR_PPU_UK02') Then
47: fnd_message.set_name('PAY', 'HR_51021_HR_PPU_UK02');
48: fnd_message.raise_error;
49: Else
50: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
51: fnd_message.set_token('PROCEDURE',l_proc);
52: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
46: ElsIf (p_constraint_name = 'HR_PPU_UK02') Then
47: fnd_message.set_name('PAY', 'HR_51021_HR_PPU_UK02');
48: fnd_message.raise_error;
49: Else
50: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
51: fnd_message.set_token('PROCEDURE',l_proc);
52: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
53: fnd_message.raise_error;
54:
47: fnd_message.set_name('PAY', 'HR_51021_HR_PPU_UK02');
48: fnd_message.raise_error;
49: Else
50: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
51: fnd_message.set_token('PROCEDURE',l_proc);
52: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
53: fnd_message.raise_error;
54:
55: End If;
48: fnd_message.raise_error;
49: Else
50: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
51: fnd_message.set_token('PROCEDURE',l_proc);
52: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
53: fnd_message.raise_error;
54:
55: End If;
56: --
49: Else
50: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
51: fnd_message.set_token('PROCEDURE',l_proc);
52: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
53: fnd_message.raise_error;
54:
55: End If;
56: --
57: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: Close C_Sel1;
116: --
117: -- The primary key is invalid therefore we must error
118: --
119: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
120: fnd_message.raise_error;
121: End If;
122: Close C_Sel1;
123: If (p_object_version_number <> g_old_rec.object_version_number) Then
116: --
117: -- The primary key is invalid therefore we must error
118: --
119: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
120: fnd_message.raise_error;
121: End If;
122: Close C_Sel1;
123: If (p_object_version_number <> g_old_rec.object_version_number) Then
124: hr_utility.set_message('801', 'HR_7155_OBJECT_INVALID');
172: Close C_Sel1;
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_51019_HR_PPU_PK');
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_51019_HR_PPU_PK');
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: hr_utility.set_message('801', 'HR_7155_OBJECT_INVALID');