63: L_LAST_UPDATE_LOGIN NUMBER;
64:
65:
66: BEGIN
67: -- Standard Start of API savepoint
68: SAVEPOINT CREATE_RELATIONSHIP_PUB;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call (l_api_version ,
66: BEGIN
67: -- Standard Start of API savepoint
68: SAVEPOINT CREATE_RELATIONSHIP_PUB;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call (l_api_version ,
72: p_api_version ,
73: l_api_name ,
74: G_PKG_NAME )
150: );
151:
152: -- End of API Body
153:
154: -- Standard check of p_commit.
155: IF FND_API.To_Boolean( p_commit ) THEN
156: COMMIT;
157: END IF;
158:
155: IF FND_API.To_Boolean( p_commit ) THEN
156: COMMIT;
157: END IF;
158:
159: -- Standard call to get message count and if count is 1,
160: --get message info.
161: FND_MSG_PUB.Count_And_Get
162: ( p_count => x_msg_count ,
163: p_data => x_msg_data
232: INVALID_EVENT_ERROR EXCEPTION;
233: CHILD_ERECORD_ID_ERROR EXCEPTION;
234: CHILD_EVENT_ERROR EXCEPTION;
235: BEGIN
236: -- Standard call to check for call compatibility.
237: IF NOT FND_API.Compatible_API_Call (l_api_version ,
238: p_api_version ,
239: l_api_name ,
240: G_PKG_NAME )
326: end if;
327:
328: -- End of API Body
329:
330: -- Standard call to get message count and if count is 1,
331: --get message info.
332: FND_MSG_PUB.Count_And_Get
333: ( p_count => x_msg_count ,
334: p_data => x_msg_data