244: --
245: l_proc varchar2(72) := g_package||'lck';
246: --
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: hr_api.mandatory_arg_error
251: (p_api_name => l_proc
252: ,p_argument => 'OFFER_ID'
251: (p_api_name => l_proc
252: ,p_argument => 'OFFER_ID'
253: ,p_argument_value => p_offer_id
254: );
255: hr_utility.set_location(l_proc,10);
256: hr_api.mandatory_arg_error
257: (p_api_name => l_proc
258: ,p_argument => 'OBJECT_VERSION_NUMBER'
259: ,p_argument_value => p_object_version_number
275: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
276: fnd_message.raise_error;
277: End If;
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 20);
280: --
281: -- We need to trap the ORA LOCK exception
282: --
283: Exception
426: l_proc varchar2(72) := g_package||'blob_dml';
427: --
428: Begin
429: --
430: hr_utility.set_location(' Entering:'||l_proc, 10);
431: --
432: -- We must lock the row which we need to update.
433: --
434: irc_iof_shd.lck
441: update irc_offers
442: set offer_letter = p_offer_letter
443: where offer_id = p_offer_id;
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 20);
446: --
447: End blob_dml;
448: --
449: end irc_iof_shd;