APPS.FUN_PARTY_MERGE_PUB dependencies on FUN_TRX_HEADERS

Line 38: FUN_TRX_HEADERS

34: for update nowait;
35:
36: Cursor C2 is
37: Select 'X' from
38: FUN_TRX_HEADERS
39: Where initiator_id = p_from_fk_id
40: for update nowait;
41:
42: BEGIN

Line 107: UPDATE FUN_TRX_HEADERS

103:
104: Open C2;
105: Close C2;
106:
107: UPDATE FUN_TRX_HEADERS
108: SET initiator_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,
110: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
111: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 162: FUN_TRX_HEADERS

158: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
159:
160: Cursor C1 is
161: Select 'X' from
162: FUN_TRX_HEADERS
163: Where recipient_id = p_from_fk_id
164: for update nowait;
165:
166: BEGIN

Line 208: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);

204: IF p_parent_entity_name = 'HZ_PARTIES' THEN
205:
206: IF fun_tca_pkg.get_le_id(p_from_FK_id) = fun_tca_pkg.get_le_id(p_to_FK_id) THEN
207: fnd_message.set_name('FUN', 'FUN_LOCKING_TABLE');
208: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);
209:
210: Open C1;
211: Close C1;
212:

Line 214: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);

210: Open C1;
211: Close C1;
212:
213: fnd_message.set_name('FUN', 'FUN_UPDATING_TABLE');
214: fnd_message.set_token('TABLE_NAME', 'FUN_TRX_HEADERS', FALSE);
215:
216: /*delete the existing target party ID */
217: -- DELETE FROM FUN_TRX_BATCHES
218: -- WHERE party_id = p_To_Fk_id;

Line 222: UPDATE FUN_TRX_HEADERS

218: -- WHERE party_id = p_To_Fk_id;
219:
220:
221: /* Update the "From" Party_ID to be equal to the new target */
222: UPDATE FUN_TRX_HEADERS
223: SET recipient_id = p_To_FK_id,
224: LAST_UPDATED_BY = hz_utility_pub.user_id,
225: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
226: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 238: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_HEADERS_LOCK');

234: END IF;
235:
236: EXCEPTION
237: WHEN RESOURCE_BUSY THEN
238: FND_MESSAGE.SET_NAME('FUN','FUN_TRX_HEADERS_LOCK');
239: FND_MSG_PUB.ADD;
240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
241: WHEN OTHERS THEN
242: FND_MESSAGE.SET_NAME('FUN','HZ_API_OTHERS_EXCEP');