159: if (sql%notfound) then
160: -- Modified by HSIU
161: -- BUG 1712957
162: -- Changed message to PA_RECORD_CHANGED
163: -- fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
164: fnd_message.set_name('PA','PA_RECORD_CHANGED');
165: x_return_status := 'E';
166: end if;
167:
160: -- Modified by HSIU
161: -- BUG 1712957
162: -- Changed message to PA_RECORD_CHANGED
163: -- fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
164: fnd_message.set_name('PA','PA_RECORD_CHANGED');
165: x_return_status := 'E';
166: end if;
167:
168: else
183: record_version_number = p_record_version_number and
184: pm_product_code is null;
185:
186: if (sql%notfound) then
187: fnd_message.set_name('PA','PA_RECORD_CHANGED');
188: x_return_status := 'E';
189: end if;
190:
191: end if;
245: if (sql%notfound) then
246: -- Modified by HSIU
247: -- BUG 1712957
248: -- Changed message to PA_RECORD_CHANGED
249: -- fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
250: fnd_message.set_name('PA','PA_RECORD_CHANGED');
251: x_return_status := 'E';
252: end if;
253:
246: -- Modified by HSIU
247: -- BUG 1712957
248: -- Changed message to PA_RECORD_CHANGED
249: -- fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
250: fnd_message.set_name('PA','PA_RECORD_CHANGED');
251: x_return_status := 'E';
252: end if;
253:
254: end if;