APPS.OE_LOTS_ACK_UTIL dependencies on OE_DEBUG_PUB

Line 24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

20: l_return_status VARCHAR2(1);
21: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
22: l_lot_serial_val_rec OE_Order_Pub.Lot_Serial_Val_Rec_Type;
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: BEGIN
27:
28: IF l_debug_level > 0 THEN

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 46: oe_debug_pub.add( 'BEFORE LOTSERIAL ACKNOWLEDGMENT INSERT STATEMENT' ) ;

42: -- l_lot_serial_val_rec := p_old_lot_serial_val_tbl(J);
43: END IF;
44:
45: IF l_debug_level > 0 THEN
46: oe_debug_pub.add( 'BEFORE LOTSERIAL ACKNOWLEDGMENT INSERT STATEMENT' ) ;
47: END IF;
48:
49: INSERT INTO OE_LOTSERIAL_ACKS
50: ( ACKNOWLEDGMENT_FLAG

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 174: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

170: , p_orig_sys_lot_serial_ref IN VARCHAR2
171: )
172: IS
173: --
174: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
175: --
176: BEGIN
177:
178: DELETE FROM OE_LOTSERIAL_ACKS

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