102: Close C_Sel1;
103: --
104: -- The primary key is invalid therefore we must error
105: --
106: fnd_message.set_name('PER', 'HR_7220_INVALID_PRIMARY_KEY');
107: fnd_message.raise_error;
108: End If;
109: Close C_Sel1;
110: If (p_object_version_number
103: --
104: -- The primary key is invalid therefore we must error
105: --
106: fnd_message.set_name('PER', 'HR_7220_INVALID_PRIMARY_KEY');
107: fnd_message.raise_error;
108: End If;
109: Close C_Sel1;
110: If (p_object_version_number
111: <> irc_rtm_shd.g_old_rec.object_version_number) Then
108: End If;
109: Close C_Sel1;
110: If (p_object_version_number
111: <> irc_rtm_shd.g_old_rec.object_version_number) Then
112: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
113: fnd_message.raise_error;
114: End If;
115: l_fct_ret := true;
116: End If;
109: Close C_Sel1;
110: If (p_object_version_number
111: <> irc_rtm_shd.g_old_rec.object_version_number) Then
112: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
113: fnd_message.raise_error;
114: End If;
115: l_fct_ret := true;
116: End If;
117: End If;
171: --
172: -- The primary key is invalid therefore we must error
173: --
174: hr_utility.set_location('Invalid key at :'||l_proc, 11);
175: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
176: fnd_message.raise_error;
177: End If;
178: Close C_Sel1;
179: If (p_object_version_number
172: -- The primary key is invalid therefore we must error
173: --
174: hr_utility.set_location('Invalid key at :'||l_proc, 11);
175: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
176: fnd_message.raise_error;
177: End If;
178: Close C_Sel1;
179: If (p_object_version_number
180: <> irc_rtm_shd.g_old_rec.object_version_number) Then
181: hr_utility.set_location('Invalid OVN at :'||l_proc, 14);
182: hr_utility.set_location(to_char(p_object_version_number) ||
183: 'vs' || to_char(irc_rtm_shd.g_old_rec.object_version_number) ||
184: ' '||l_proc, 16);
185: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
186: fnd_message.raise_error;
187: End If;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 20);
182: hr_utility.set_location(to_char(p_object_version_number) ||
183: 'vs' || to_char(irc_rtm_shd.g_old_rec.object_version_number) ||
184: ' '||l_proc, 16);
185: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
186: fnd_message.raise_error;
187: End If;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 20);
190: --
196: -- The object is locked therefore we need to supply a meaningful
197: -- error message.
198: --
199: hr_utility.set_location('Object locked :'||l_proc, 21);
200: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
201: fnd_message.set_token('TABLE_NAME', 'irc_rec_team_members');
202: fnd_message.raise_error;
203: End lck;
204: --
197: -- error message.
198: --
199: hr_utility.set_location('Object locked :'||l_proc, 21);
200: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
201: fnd_message.set_token('TABLE_NAME', 'irc_rec_team_members');
202: fnd_message.raise_error;
203: End lck;
204: --
205: -- ----------------------------------------------------------------------------
198: --
199: hr_utility.set_location('Object locked :'||l_proc, 21);
200: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
201: fnd_message.set_token('TABLE_NAME', 'irc_rec_team_members');
202: fnd_message.raise_error;
203: End lck;
204: --
205: -- ----------------------------------------------------------------------------
206: -- |-----------------------------< convert_args >-----------------------------|