APPS.XLE_PARTY_MERGE_PUB dependencies on XLE_REG_FUNCTIONS

Line 158: XLE_REG_FUNCTIONS

154: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
155:
156: Cursor C1 is
157: Select 'X' from
158: XLE_REG_FUNCTIONS
159: Where authority_id = p_from_fk_id
160: for update nowait;
161:
162: Cursor C2 is

Line 164: XLE_REG_FUNCTIONS

160: for update nowait;
161:
162: Cursor C2 is
163: Select 'X' from
164: XLE_REG_FUNCTIONS
165: Where authority_site_id = p_from_fk_id
166: for update nowait;
167:
168: BEGIN

Line 209: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);

205:
206: IF p_parent_entity_name = 'HZ_PARTIES' THEN
207:
208: fnd_message.set_name('XLE', 'XLE_LOCKING_TABLE');
209: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);
210:
211: Open C1;
212: Close C1;
213:

Line 215: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);

211: Open C1;
212: Close C1;
213:
214: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
215: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);
216:
217: /* Update the "From" Party_ID to be equal to the new target */
218: UPDATE XLE_REG_FUNCTIONS
219: SET authority_id = p_To_FK_id,

Line 218: UPDATE XLE_REG_FUNCTIONS

214: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
215: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);
216:
217: /* Update the "From" Party_ID to be equal to the new target */
218: UPDATE XLE_REG_FUNCTIONS
219: SET authority_id = p_To_FK_id,
220: LAST_UPDATED_BY = hz_utility_pub.user_id,
221: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
222: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 229: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);

225:
226: ELSIF p_Parent_Entity_name = 'HZ_PARTY_SITES' THEN
227:
228: fnd_message.set_name('XLE', 'XLE_LOCKING_TABLE');
229: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);
230:
231: Open C2;
232: Close C2;
233:

Line 235: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);

231: Open C2;
232: Close C2;
233:
234: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
235: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);
236:
237: UPDATE XLE_REG_FUNCTIONS
238: SET authority_site_id = p_To_FK_id,
239: LAST_UPDATED_BY = hz_utility_pub.user_id,

Line 237: UPDATE XLE_REG_FUNCTIONS

233:
234: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
235: fnd_message.set_token('TABLE_NAME', 'XLE_REG_FUNCTIONS', FALSE);
236:
237: UPDATE XLE_REG_FUNCTIONS
238: SET authority_site_id = p_To_FK_id,
239: LAST_UPDATED_BY = hz_utility_pub.user_id,
240: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
241: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 248: FND_MESSAGE.SET_NAME('XLE','XLE_REG_FUNCTIONS');

244: END IF;
245: END IF;
246: EXCEPTION
247: WHEN RESOURCE_BUSY THEN
248: FND_MESSAGE.SET_NAME('XLE','XLE_REG_FUNCTIONS');
249: FND_MSG_PUB.ADD;
250: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
251: WHEN OTHERS THEN
252: FND_MESSAGE.SET_NAME('XLE','HZ_API_OTHERS_EXCEP');