96: EXCEPTION
97: --< Shared Proc FPJ Start >
98: WHEN DUP_VAL_ON_INDEX THEN
99: x_return_status := FND_API.g_ret_sts_error;
100: FND_MESSAGE.set_name(application => 'PO',
101: name => 'PO_GA_ORG_ASSIGN_DUPLICATE');
102: FND_MSG_PUB.add;
103: WHEN OTHERS THEN
104: x_return_status := FND_API.g_ret_sts_unexp_error;
172:
173: EXCEPTION
174: WHEN DUP_VAL_ON_INDEX THEN
175: x_return_status := FND_API.g_ret_sts_error;
176: FND_MESSAGE.set_name(application => 'PO',
177: name => 'PO_GA_ORG_ASSIGN_DUPLICATE');
178: FND_MSG_PUB.add;
179: WHEN OTHERS THEN
180: x_return_status := FND_API.g_ret_sts_unexp_error;
267: -- purchasing_org_id
268: -- vendor_site_id
269: -- enabled_flag
270: -- If any of these are different than the database value, the procedure will
271: -- error out after setting the FND message FORM_RECORD_CHANGED. If the matching
272: -- record in the database cannot be found, the FND message FORM_RECORD_DELETED
273: -- is set. Uses APP_EXCEPTION.raise_exception when errors occur.
274: --Parameters:
275: --IN:
268: -- vendor_site_id
269: -- enabled_flag
270: -- If any of these are different than the database value, the procedure will
271: -- error out after setting the FND message FORM_RECORD_CHANGED. If the matching
272: -- record in the database cannot be found, the FND message FORM_RECORD_DELETED
273: -- is set. Uses APP_EXCEPTION.raise_exception when errors occur.
274: --Parameters:
275: --IN:
276: --p_org_assign_rec
306: -- The record could not be locked, so raise it to calling procedure
307: RAISE APP_EXCEPTION.record_lock_exception;
308: WHEN NO_DATA_FOUND THEN
309: -- Could not find the record
310: FND_MESSAGE.set_name(application => 'FND',
311: name => 'FORM_RECORD_DELETED');
312: APP_EXCEPTION.raise_exception;
313: WHEN FND_API.g_exc_error THEN
314: -- The individual value comparisons failed
311: name => 'FORM_RECORD_DELETED');
312: APP_EXCEPTION.raise_exception;
313: WHEN FND_API.g_exc_error THEN
314: -- The individual value comparisons failed
315: FND_MESSAGE.set_name(application => 'FND',
316: name => 'FORM_RECORD_CHANGED');
317: APP_EXCEPTION.raise_exception;
318: WHEN OTHERS THEN
319: FND_MSG_PUB.build_exc_msg
419:
420: EXCEPTION
421: WHEN DUP_VAL_ON_INDEX THEN
422: x_return_status := FND_API.g_ret_sts_error;
423: FND_MESSAGE.set_name(application => 'PO',
424: name => 'PO_GA_ORG_ASSIGN_DUPLICATE');
425: FND_MSG_PUB.add;
426: WHEN OTHERS THEN
427: x_return_status := FND_API.g_ret_sts_unexp_error;