APPS.FUN_PARTY_MERGE_PUB dependencies on FUN_CUSTOMER_MAPS

Line 392: FUN_CUSTOMER_MAPS

388: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
389:
390: Cursor C1 is
391: Select 'X' from
392: FUN_CUSTOMER_MAPS
393: Where site_use_id = p_from_fk_id
394: for update nowait;
395:
396: BEGIN

Line 437: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);

433:
434: IF p_parent_entity_name = 'HZ_PARTY_SITE_USES' THEN
435:
436: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
437: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);
438:
439: Open C1;
440: Close C1;
441:

Line 443: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);

439: Open C1;
440: Close C1;
441:
442: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
443: fnd_message.set_token('TABLE_NAME', 'FUN_CUSTOMER_MAPS', FALSE);
444:
445: /*delete the existing target party ID */
446: -- DELETE FROM FUN_TRX_BATCHES
447: -- WHERE party_id = p_To_Fk_id;

Line 451: UPDATE FUN_CUSTOMER_MAPS

447: -- WHERE party_id = p_To_Fk_id;
448:
449:
450: /* Update the "From" Party_ID to be equal to the new target */
451: UPDATE FUN_CUSTOMER_MAPS
452: SET site_use_id = p_To_FK_id,
453: LAST_UPDATED_BY = hz_utility_pub.user_id,
454: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
455: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 465: FND_MESSAGE.SET_NAME('FUN','FUN_CUSTOMER_MAPS_LOCK');

461: END IF;
462:
463: EXCEPTION
464: WHEN RESOURCE_BUSY THEN
465: FND_MESSAGE.SET_NAME('FUN','FUN_CUSTOMER_MAPS_LOCK');
466: FND_MSG_PUB.ADD;
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
468: WHEN OTHERS THEN
469: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');