169: p_encoded => 'F');
170:
171: WHEN OTHERS THEN
172: ROLLBACK TO CREATE_HIERARCHY_SECTION_PUB;
173: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
174: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
175: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
176: FND_MESSAGE.Set_Token('REASON', SQLERRM);
177: FND_MSG_PUB.Add;
170:
171: WHEN OTHERS THEN
172: ROLLBACK TO CREATE_HIERARCHY_SECTION_PUB;
173: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
174: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
175: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
176: FND_MESSAGE.Set_Token('REASON', SQLERRM);
177: FND_MSG_PUB.Add;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: WHEN OTHERS THEN
172: ROLLBACK TO CREATE_HIERARCHY_SECTION_PUB;
173: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
174: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
175: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
176: FND_MESSAGE.Set_Token('REASON', SQLERRM);
177: FND_MSG_PUB.Add;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
172: ROLLBACK TO CREATE_HIERARCHY_SECTION_PUB;
173: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
174: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
175: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
176: FND_MESSAGE.Set_Token('REASON', SQLERRM);
177: FND_MSG_PUB.Add;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: p_encoded => 'F');
272:
273: WHEN OTHERS THEN
274: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PUB;
275: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
276: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
277: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
278: FND_MESSAGE.Set_Token('REASON', SQLERRM);
279: FND_MSG_PUB.Add;
272:
273: WHEN OTHERS THEN
274: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PUB;
275: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
276: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
277: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
278: FND_MESSAGE.Set_Token('REASON', SQLERRM);
279: FND_MSG_PUB.Add;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: WHEN OTHERS THEN
274: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PUB;
275: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
276: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
277: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
278: FND_MESSAGE.Set_Token('REASON', SQLERRM);
279: FND_MSG_PUB.Add;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
274: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PUB;
275: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
276: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
277: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
278: FND_MESSAGE.Set_Token('REASON', SQLERRM);
279: FND_MSG_PUB.Add;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: p_encoded => 'F');
414:
415: WHEN OTHERS THEN
416: ROLLBACK TO ASSOCIATE_LOGICAL_CONTENT_PUB;
417: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
418: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
419: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
420: FND_MESSAGE.Set_Token('REASON', SQLERRM);
421: FND_MSG_PUB.Add;
414:
415: WHEN OTHERS THEN
416: ROLLBACK TO ASSOCIATE_LOGICAL_CONTENT_PUB;
417: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
418: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
419: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
420: FND_MESSAGE.Set_Token('REASON', SQLERRM);
421: FND_MSG_PUB.Add;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: WHEN OTHERS THEN
416: ROLLBACK TO ASSOCIATE_LOGICAL_CONTENT_PUB;
417: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
418: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
419: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
420: FND_MESSAGE.Set_Token('REASON', SQLERRM);
421: FND_MSG_PUB.Add;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
416: ROLLBACK TO ASSOCIATE_LOGICAL_CONTENT_PUB;
417: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
418: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
419: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
420: FND_MESSAGE.Set_Token('REASON', SQLERRM);
421: FND_MSG_PUB.Add;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)