259: --x_return_status := FND_API.G_RET_STS_SUCCESS;
260: EXCEPTION
261:
262: WHEN NO_DATA_FOUND THEN
263: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
264: THEN
265: Error_Handler.Add_Error_Token
266: ( p_Message_name => 'BOM_NOT_UPDATE_ROW'
267: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
273: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
274:
275: WHEN OTHERS THEN
276:
277: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: l_err_text := G_PKG_NAME ||
280: 'Utility (SubStitute Component Update)' ||
281: SUBSTR(SQLERRM, 1, 100);
432:
433: EXCEPTION
434:
435: WHEN OTHERS THEN
436: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
437: THEN
438: l_err_text := G_PKG_NAME ||
439: 'Utility (Substitute Component Insert)' ||
440: SUBSTR(SQLERRM, 1, 100);
508: EXCEPTION
509:
510: WHEN OTHERS THEN
511:
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
513: THEN
514: l_err_text := G_PKG_NAME ||
515: 'Utility (Substitute Component Delete_Row)' ||
516: SUBSTR(SQLERRM, 1, 100);