[Home] [Help]
1: PACKAGE BODY INV_DS_LOGICAL_TRX_INFO_PUB AS
2: /* $Header: INVLTIPB.pls 115.4 2004/05/12 18:45:01 vipartha noship $ */
3:
4: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5:
10: ) IS
11: BEGIN
12: INV_LOG_UTIL.trace
13: (p_message => p_err_msg,
14: p_module => 'INV_DS_LOGICAL_TRX_INFO_PUB',
15: p_level => p_level);
16: END print_debug;
17:
18:
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;
152: WHEN OTHERS THEN
153: x_return_status := G_RET_STS_UNEXP_ERROR;
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);
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;
163:
164: END get_logical_attr_values;
162: END IF;
163:
164: END get_logical_attr_values;
165:
166: END INV_DS_LOGICAL_TRX_INFO_PUB;
167: