65: l_api_version CONSTANT NUMBER := 1.0;
66: l_debug VARCHAR2(1);
67:
68: BEGIN
69: -- Standard Start of API savepoint
70: SAVEPOINT CREATE_HIERARCHY_SECTION_PUB;
71:
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call(l_api_version,
68: BEGIN
69: -- Standard Start of API savepoint
70: SAVEPOINT CREATE_HIERARCHY_SECTION_PUB;
71:
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call(l_api_version,
74: p_api_version,
75: l_api_name,
76: G_PKG_NAME)
141: IBE_UTIL.debug(FND_MSG_PUB.get(i,FND_API.G_FALSE));
142: END LOOP;
143: END IF;
144:
145: -- Standard check of p_commit.
146: IF (FND_API.To_Boolean(p_commit)) THEN
147: COMMIT WORK;
148: END IF;
149:
146: IF (FND_API.To_Boolean(p_commit)) THEN
147: COMMIT WORK;
148: END IF;
149:
150: -- Standard call to get message count and if count is 1, get message info.
151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
152: p_data => x_msg_data,
153: p_encoded => 'F');
154:
206:
207:
208: BEGIN
209:
210: -- Standard Start of API savepoint
211: SAVEPOINT ASSOCIATE_ITEMS_TO_SECTION_PUB;
212:
213: -- Standard call to check for call compatibility.
214: IF NOT FND_API.Compatible_API_Call(l_api_version,
209:
210: -- Standard Start of API savepoint
211: SAVEPOINT ASSOCIATE_ITEMS_TO_SECTION_PUB;
212:
213: -- Standard call to check for call compatibility.
214: IF NOT FND_API.Compatible_API_Call(l_api_version,
215: p_api_version,
216: l_api_name,
217: G_PKG_NAME)
243: x_section_item_out_tbl => x_section_item_out_tbl);
244:
245: -- End of main API body.
246:
247: -- Standard check of p_commit.
248: IF (FND_API.To_Boolean(p_commit)) THEN
249: COMMIT WORK;
250: END IF;
251:
248: IF (FND_API.To_Boolean(p_commit)) THEN
249: COMMIT WORK;
250: END IF;
251:
252: -- Standard call to get message count and if count is 1, get message info.
253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
254: p_data => x_msg_data,
255: p_encoded => 'F');
256:
312: l_overall_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
313:
314: BEGIN
315:
316: -- Standard Start of API savepoint
317: SAVEPOINT ASSOCIATE_LOGICAL_CONTENT_PUB;
318:
319: -- Standard call to check for call compatibility.
320: IF NOT FND_API.Compatible_API_Call(l_api_version,
315:
316: -- Standard Start of API savepoint
317: SAVEPOINT ASSOCIATE_LOGICAL_CONTENT_PUB;
318:
319: -- Standard call to check for call compatibility.
320: IF NOT FND_API.Compatible_API_Call(l_api_version,
321: p_api_version,
322: l_api_name,
323: G_PKG_NAME)
390: end if;
391:
392: -- End of main API body.
393:
394: -- Standard call to get message count and if count is 1, get message info.
395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
396: p_data => x_msg_data,
397: p_encoded => 'F');
398: