28: IEM_ERROR_GET_SUB_CATEGORIES EXCEPTION;
29:
30: BEGIN
31: SAVEPOINT search_message_pvt;
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
34: p_api_version_number,
35: l_api_name,
36: G_PKG_NAME)
101:
102:
103: END LOOP;
104:
105: -- Standard Check Of p_commit.
106: IF FND_API.To_Boolean(p_commit) THEN
107: COMMIT WORK;
108: END IF;
109: -- Standard callto get message count and if count is 1, get message info.
105: -- Standard Check Of p_commit.
106: IF FND_API.To_Boolean(p_commit) THEN
107: COMMIT WORK;
108: END IF;
109: -- Standard callto get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get
111: ( p_count => x_msg_count,
112: p_data => x_msg_data
113: );
182:
183: IEM_ERROR_GET_SUB_CATEGORIES EXCEPTION;
184: BEGIN
185: SAVEPOINT search_message_pvt;
186: -- Standard call to check for call compatibility.
187: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
188: p_api_version_number,
189: l_api_name,
190: G_PKG_NAME)
254: x_index := p_index;
255: end if;
256:
257:
258: -- Standard Check Of p_commit.
259: IF FND_API.To_Boolean(p_commit) THEN
260: COMMIT WORK;
261: END IF;
262: -- Standard callto get message count and if count is 1, get message info.
258: -- Standard Check Of p_commit.
259: IF FND_API.To_Boolean(p_commit) THEN
260: COMMIT WORK;
261: END IF;
262: -- Standard callto get message count and if count is 1, get message info.
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );