APPS.OE_LOTS_ACK_UTIL dependencies on OE_LOTS_ACK_UTIL

Line 1: PACKAGE BODY OE_Lots_Ack_Util AS

1: PACKAGE BODY OE_Lots_Ack_Util AS
2: /* $Header: OEXUSAKB.pls 115.6 2003/10/20 07:17:23 appldev ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Lots_Ack_Util';

2: /* $Header: OEXUSAKB.pls 115.6 2003/10/20 07:17:23 appldev ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Lots_Ack_Util';
7:
8: PROCEDURE Insert_Row
9: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type

Line 29: oe_debug_pub.add('Enter OE_Lots_Ack_Util.Insert_Row');

25: --
26: BEGIN
27:
28: IF l_debug_level > 0 THEN
29: oe_debug_pub.add('Enter OE_Lots_Ack_Util.Insert_Row');
30: End If;
31:
32: /*
33: FOR I IN 1..p_old_line_tbl.COUNT LOOP

Line 150: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_LOTS_ACK_UTIL.INSERT_ROW: '||SQLERRM ) ;

146: EXCEPTION
147:
148: WHEN OTHERS THEN
149: IF l_debug_level > 0 THEN
150: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_LOTS_ACK_UTIL.INSERT_ROW: '||SQLERRM ) ;
151: END IF;
152:
153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN

Line 156: (G_PKG_NAME, 'OE_Lots_Ack_Util.Insert_Row');

152:
153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN
155: FND_MSG_PUB.Add_Exc_Msg
156: (G_PKG_NAME, 'OE_Lots_Ack_Util.Insert_Row');
157: END IF;
158:
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160:

Line 191: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_LOTS_ACK_UTIL.DELETE_ROW: '||SQLERRM ) ;

187: EXCEPTION
188:
189: WHEN OTHERS THEN
190: IF l_debug_level > 0 THEN
191: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_LOTS_ACK_UTIL.DELETE_ROW: '||SQLERRM ) ;
192: END IF;
193:
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
195: THEN

Line 197: (G_PKG_NAME, 'OE_Lots_Ack_Util.Delete_Row');

193:
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
195: THEN
196: FND_MSG_PUB.Add_Exc_Msg
197: (G_PKG_NAME, 'OE_Lots_Ack_Util.Delete_Row');
198: END IF;
199:
200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201:

Line 204: END OE_Lots_Ack_Util;

200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201:
202: END Delete_Row;
203:
204: END OE_Lots_Ack_Util;