19: Begin
20: --
21: if (p_constraint_name = 'PAY_TIME_DEF_USAGES_UK1') then
22:
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: else
20: --
21: if (p_constraint_name = 'PAY_TIME_DEF_USAGES_UK1') then
22:
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
21: if (p_constraint_name = 'PAY_TIME_DEF_USAGES_UK1') then
22:
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
22:
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: end if;
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: end if;
33: --
26: fnd_message.raise_error;
27: else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: end if;
33: --
34: End constraint_error;
27: else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: end if;
33: --
34: End constraint_error;
35: --
91: Close C_Sel1;
92: --
93: -- The primary key is invalid therefore we must error
94: --
95: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
96: fnd_message.raise_error;
97: End If;
98: Close C_Sel1;
99: If (p_object_version_number
92: --
93: -- The primary key is invalid therefore we must error
94: --
95: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
96: fnd_message.raise_error;
97: End If;
98: Close C_Sel1;
99: If (p_object_version_number
100: <> pay_tdu_shd.g_old_rec.object_version_number) Then
97: End If;
98: Close C_Sel1;
99: If (p_object_version_number
100: <> pay_tdu_shd.g_old_rec.object_version_number) Then
101: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
102: fnd_message.raise_error;
103: End If;
104: l_fct_ret := true;
105: End If;
98: Close C_Sel1;
99: If (p_object_version_number
100: <> pay_tdu_shd.g_old_rec.object_version_number) Then
101: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
102: fnd_message.raise_error;
103: End If;
104: l_fct_ret := true;
105: End If;
106: End If;
158: Close C_Sel1;
159: --
160: -- The primary key is invalid therefore we must error
161: --
162: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: End If;
165: Close C_Sel1;
166: If (p_object_version_number
159: --
160: -- The primary key is invalid therefore we must error
161: --
162: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: End If;
165: Close C_Sel1;
166: If (p_object_version_number
167: <> pay_tdu_shd.g_old_rec.object_version_number) Then
164: End If;
165: Close C_Sel1;
166: If (p_object_version_number
167: <> pay_tdu_shd.g_old_rec.object_version_number) Then
168: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
169: fnd_message.raise_error;
170: End If;
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Close C_Sel1;
166: If (p_object_version_number
167: <> pay_tdu_shd.g_old_rec.object_version_number) Then
168: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
169: fnd_message.raise_error;
170: End If;
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 10);
173: --
178: --
179: -- The object is locked therefore we need to supply a meaningful
180: -- error message.
181: --
182: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
183: fnd_message.set_token('TABLE_NAME', 'pay_time_def_usages');
184: fnd_message.raise_error;
185: End lck;
186: --
179: -- The object is locked therefore we need to supply a meaningful
180: -- error message.
181: --
182: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
183: fnd_message.set_token('TABLE_NAME', 'pay_time_def_usages');
184: fnd_message.raise_error;
185: End lck;
186: --
187: -- ----------------------------------------------------------------------------
180: -- error message.
181: --
182: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
183: fnd_message.set_token('TABLE_NAME', 'pay_time_def_usages');
184: fnd_message.raise_error;
185: End lck;
186: --
187: -- ----------------------------------------------------------------------------
188: -- |-----------------------------< convert_args >-----------------------------|