527: IF (l_debugon = l_true) THEN
528: IBE_UTIL.debug('Others exception');
529: END IF;
530:
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
528: IBE_UTIL.debug('Others exception');
529: END IF;
530:
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536: FND_MSG_PUB.ADD;
529: END IF;
530:
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536: FND_MSG_PUB.ADD;
537: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
530:
531: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
532: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536: FND_MSG_PUB.ADD;
537: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
538: p_data => x_msg_data,