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