APPS.FUN_PARTY_MERGE_PUB dependencies on FUN_SUPPLIER_MAPS

Line 504: FUN_SUPPLIER_MAPS

500: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
501:
502: Cursor C1 is
503: Select 'X' from
504: FUN_SUPPLIER_MAPS
505: Where vendor_site_id = p_from_fk_id
506: for update nowait;
507:
508: BEGIN

Line 549: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);

545:
546: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
547:
548: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
549: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);
550:
551: Open C1;
552: Close C1;
553:

Line 555: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);

551: Open C1;
552: Close C1;
553:
554: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
555: fnd_message.set_token('TABLE_NAME', 'FUN_SUPPLIER_MAPS', FALSE);
556:
557: /*delete the existing target party ID */
558: -- DELETE FROM FUN_TRX_BATCHES
559: -- WHERE party_id = p_To_Fk_id;

Line 563: UPDATE FUN_SUPPLIER_MAPS

559: -- WHERE party_id = p_To_Fk_id;
560:
561:
562: /* Update the "From" Party_ID to be equal to the new target */
563: UPDATE FUN_SUPPLIER_MAPS
564: SET vendor_site_id = p_To_FK_id,
565: LAST_UPDATED_BY = hz_utility_pub.user_id,
566: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
567: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 577: FND_MESSAGE.SET_NAME('FUN','FUN_SUPPLIER_MAPS_LOCK');

573: END IF;
574:
575: EXCEPTION
576: WHEN RESOURCE_BUSY THEN
577: FND_MESSAGE.SET_NAME('FUN','FUN_SUPPLIER_MAPS_LOCK');
578: FND_MSG_PUB.ADD;
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
580: WHEN OTHERS THEN
581: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');