143:
144: EXCEPTION
145: WHEN FND_API.G_EXC_ERROR THEN
146: x_return_status := G_RET_STS_ERROR;
147: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
148: IF (l_debug = 1) THEN
149: print_debug('INV_DS_LOGICAL_TRX_INFO_PUB: no_data_found error', 9);
150: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
151: END IF;
151: END IF;
152: WHEN OTHERS THEN
153: x_return_status := G_RET_STS_UNEXP_ERROR;
154:
155: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_DS_LOGICAL_TRX_INFO_PUB');
157: END IF;
158: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
159: IF (l_debug = 1) THEN
152: WHEN OTHERS THEN
153: x_return_status := G_RET_STS_UNEXP_ERROR;
154:
155: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_DS_LOGICAL_TRX_INFO_PUB');
157: END IF;
158: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
159: IF (l_debug = 1) THEN
160: print_debug('INV_DS_LOGICAL_TRX_INFO_PUB: others error', 9);
154:
155: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'INV_DS_LOGICAL_TRX_INFO_PUB');
157: END IF;
158: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
159: IF (l_debug = 1) THEN
160: print_debug('INV_DS_LOGICAL_TRX_INFO_PUB: others error', 9);
161: print_debug('SQL Error: ' || Sqlerrm(SQLCODE), 9);
162: END IF;