DBA Data[Home] [Help]

APPS.IEM_PARAMETERS_PVT dependencies on STANDARD

Line 18: -- Standard Start of API savepoint

14: l_api_name VARCHAR2(255):='select_profile';
15: l_api_version_number NUMBER:=1.0;
16:
17: BEGIN
18: -- Standard Start of API savepoint
19: SAVEPOINT select_profile_PVT;
20: -- Standard call to check for call compatibility.
21: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
22: p_api_version_number,

Line 20: -- Standard call to check for call compatibility.

16:
17: BEGIN
18: -- Standard Start of API savepoint
19: SAVEPOINT select_profile_PVT;
20: -- Standard call to check for call compatibility.
21: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
22: p_api_version_number,
23: l_api_name,
24: G_PKG_NAME)

Line 38: -- Standard Check Of p_commit.

34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: x_profile_value := FND_PROFILE.VALUE_SPECIFIC(p_profile_name);
37:
38: -- Standard Check Of p_commit.
39: IF FND_API.To_Boolean(p_commit) THEN
40: COMMIT WORK;
41: END IF;
42: -- Standard callto get message count and if count is 1, get message info.

Line 42: -- Standard callto get message count and if count is 1, get message info.

38: -- Standard Check Of p_commit.
39: IF FND_API.To_Boolean(p_commit) THEN
40: COMMIT WORK;
41: END IF;
42: -- Standard callto get message count and if count is 1, get message info.
43: FND_MSG_PUB.Count_And_Get
44: ( p_count => x_msg_count,
45: p_data => x_msg_data
46: );

Line 107: -- Standard Start of API savepoint

103: INVALID_DEFAULT_RESOURCE_NUM EXCEPTION;
104: PROFILE_NOT_UPDATED EXCEPTION;
105:
106: BEGIN
107: -- Standard Start of API savepoint
108: SAVEPOINT update_profile_PVT;
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
111: p_api_version_number,

Line 109: -- Standard call to check for call compatibility.

105:
106: BEGIN
107: -- Standard Start of API savepoint
108: SAVEPOINT update_profile_PVT;
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
111: p_api_version_number,
112: l_api_name,
113: G_PKG_NAME)

Line 183: -- Standard Check Of p_commit.

179: if not FND_PROFILE.SAVE(p_profile_name, p_profile_value, 'SITE') then
180: raise PROFILE_NOT_UPDATED;
181: end if;
182:
183: -- Standard Check Of p_commit.
184: IF FND_API.To_Boolean(p_commit) THEN
185: COMMIT WORK;
186: END IF;
187: -- Standard callto get message count and if count is 1, get message info.

Line 187: -- Standard callto get message count and if count is 1, get message info.

183: -- Standard Check Of p_commit.
184: IF FND_API.To_Boolean(p_commit) THEN
185: COMMIT WORK;
186: END IF;
187: -- Standard callto get message count and if count is 1, get message info.
188: FND_MSG_PUB.Count_And_Get
189: ( p_count => x_msg_count,
190: p_data => x_msg_data
191: );

Line 267: -- Standard Start of API savepoint

263: l_msg_data VARCHAR2(2000);
264: PROFILE_NOT_UPDATED EXCEPTION;
265:
266: BEGIN
267: -- Standard Start of API savepoint
268: SAVEPOINT update_profile_PVT;
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
271: p_api_version_number,

Line 269: -- Standard call to check for call compatibility.

265:
266: BEGIN
267: -- Standard Start of API savepoint
268: SAVEPOINT update_profile_PVT;
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
271: p_api_version_number,
272: l_api_name,
273: G_PKG_NAME)

Line 302: -- Standard Check Of p_commit.

298: end if;
299:
300: END LOOP;
301:
302: -- Standard Check Of p_commit.
303: IF FND_API.To_Boolean(p_commit) THEN
304: COMMIT WORK;
305: END IF;
306: -- Standard callto get message count and if count is 1, get message info.

Line 306: -- Standard callto get message count and if count is 1, get message info.

302: -- Standard Check Of p_commit.
303: IF FND_API.To_Boolean(p_commit) THEN
304: COMMIT WORK;
305: END IF;
306: -- Standard callto get message count and if count is 1, get message info.
307: FND_MSG_PUB.Count_And_Get
308: ( p_count => x_msg_count,
309: p_data => x_msg_data
310: );