APPS.XLE_PARTY_MERGE_PUB dependencies on XLE_REGISTRATIONS

Line 29: XLE_REGISTRATIONS

25: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
26:
27: Cursor C1 is
28: Select 'X' from
29: XLE_REGISTRATIONS
30: Where issuing_authority_id = p_from_fk_id
31: for update nowait;
32:
33: Cursor C2 is

Line 35: XLE_REGISTRATIONS

31: for update nowait;
32:
33: Cursor C2 is
34: Select 'X' from
35: XLE_REGISTRATIONS
36: Where issuing_authority_site_id = p_from_fk_id
37: for update nowait;
38:
39: BEGIN

Line 78: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);

74: IF p_from_FK_id <> p_to_FK_id THEN
75: IF p_parent_entity_name = 'HZ_PARTIES' THEN
76:
77: fnd_message.set_name('XLE', 'XLE_LOCKING_TABLE');
78: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);
79:
80: Open C1;
81: Close C1;
82:

Line 84: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);

80: Open C1;
81: Close C1;
82:
83: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
84: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);
85:
86: /* Update the "From" Party_ID to be equal to the new target */
87: UPDATE XLE_REGISTRATIONS
88: SET issuing_authority_id = p_To_FK_id,

Line 87: UPDATE XLE_REGISTRATIONS

83: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
84: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);
85:
86: /* Update the "From" Party_ID to be equal to the new target */
87: UPDATE XLE_REGISTRATIONS
88: SET issuing_authority_id = p_To_FK_id,
89: LAST_UPDATED_BY = hz_utility_pub.user_id,
90: LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
91: LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login

Line 99: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);

95:
96: ELSIF p_Parent_Entity_name = 'HZ_PARTY_SITES' THEN
97:
98: fnd_message.set_name('XLE', 'XLE_LOCKING_TABLE');
99: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);
100:
101: Open C2;
102: Close C2;
103:

Line 105: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);

101: Open C2;
102: Close C2;
103:
104: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
105: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);
106:
107: UPDATE XLE_REGISTRATIONS
108: SET issuing_authority_site_id = p_To_FK_id,
109: LAST_UPDATED_BY = hz_utility_pub.user_id,

Line 107: UPDATE XLE_REGISTRATIONS

103:
104: fnd_message.set_name('XLE', 'XLE_UPDATING_TABLE');
105: fnd_message.set_token('TABLE_NAME', 'XLE_REGISTRATIONS', FALSE);
106:
107: UPDATE XLE_REGISTRATIONS
108: SET issuing_authority_site_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 119: FND_MESSAGE.SET_NAME('XLE','XLE_REGISTRATIONS_LOCK');

115: END IF;
116:
117: EXCEPTION
118: WHEN RESOURCE_BUSY THEN
119: FND_MESSAGE.SET_NAME('XLE','XLE_REGISTRATIONS_LOCK');
120: FND_MSG_PUB.ADD;
121: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
122: WHEN OTHERS THEN
123: FND_MESSAGE.SET_NAME('XLE','HZ_API_OTHERS_EXCEP');