APPS.FUN_PARTY_MERGE_PUB dependencies on FUN_DIST_LINES

Line 277: FUN_DIST_LINES

273: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
274:
275: Cursor C1 is
276: Select 'X' from
277: FUN_DIST_LINES
278: Where party_id = p_from_fk_id
279: for update nowait;
280:
281: BEGIN

Line 323: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);

319: IF p_parent_entity_name = 'HZ_PARTIES' THEN
320:
321: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
322: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
323: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);
324:
325: Open C1;
326: Close C1;
327:

Line 329: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);

325: Open C1;
326: Close C1;
327:
328: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
329: fnd_message.set_token('TABLE_NAME', 'FUN_DIST_LINES', FALSE);
330:
331: /*delete the existing target party ID */
332: -- DELETE FROM FUN_TRX_BATCHES
333: -- WHERE party_id = p_To_Fk_id;

Line 337: UPDATE FUN_DIST_LINES

333: -- WHERE party_id = p_To_Fk_id;
334:
335:
336: /* Update the "From" Party_ID to be equal to the new target */
337: UPDATE FUN_DIST_LINES
338: SET party_id = p_To_FK_id,
339: LAST_UPDATED_BY = hz_utility_pub.user_id,
340: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
341: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 353: FND_MESSAGE.SET_NAME('FUN','FUN_DIST_LINES_LOCK');

349: END IF;
350:
351: EXCEPTION
352: WHEN RESOURCE_BUSY THEN
353: FND_MESSAGE.SET_NAME('FUN','FUN_DIST_LINES_LOCK');
354: FND_MSG_PUB.ADD;
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
356: WHEN OTHERS THEN
357: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');