178: AND record_version_number = nvl(p_record_version_number, record_version_number);
179:
180: IF (SQL%NOTFOUND) THEN
181:
182: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
183: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
184: x_return_status := FND_API.G_RET_STS_ERROR;
185:
186: END IF;
187:
188: -- Put any message text from message stack into the Message ARRAY
189: EXCEPTION
190: WHEN e_row_is_locked THEN
191: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
192: ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');
193: x_return_status := FND_API.G_RET_STS_ERROR;
194:
195: WHEN OTHERS THEN
219:
220: --
221: IF (SQL%NOTFOUND) THEN
222:
223: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
224: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
225: x_return_status := FND_API.G_RET_STS_ERROR;
226:
227: END IF;