DBA Data[Home] [Help]

APPS.IBE_DSP_HIERARCHY_SETUP_PUB dependencies on FND_MESSAGE

Line 173: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 174: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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;

Line 175: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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:

Line 176: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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)

Line 275: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_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;

Line 276: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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;

Line 277: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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:

Line 278: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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)

Line 417: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_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;

Line 418: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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;

Line 419: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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:

Line 420: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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)