APPS.OE_BULK_HOLDS_PVT dependencies on OE_BULK_HOLDS_PVT

Line 1: PACKAGE BODY OE_Bulk_Holds_PVT AS

1: PACKAGE BODY OE_Bulk_Holds_PVT AS
2: /* $Header: OEBVHLDB.pls 120.1.12010000.7 2008/11/24 04:31:37 smusanna ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Bulk_Holds_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Bulk_Holds_PVT';

1: PACKAGE BODY OE_Bulk_Holds_PVT AS
2: /* $Header: OEBVHLDB.pls 120.1.12010000.7 2008/11/24 04:31:37 smusanna ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Bulk_Holds_PVT';
5:
6:
7: /****************************************************************************
8: Valid Entity Combination

Line 91: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug

87:
88: l_count BINARY_INTEGER;
89: BEGIN
90:
91: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
92: -- Clear the Globals.
93: g_hold_header_id.DELETE;
94: g_hold_line_id.DELETE;
95: g_hold_Source_Id.DELETE;

Line 888: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug

884: --ER#7479609 end
885:
886: END LOOP;
887:
888: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
889:
890: EXCEPTION
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 919: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');

915: l_activity_name VARCHAR2(30);
916: l_inventory_item_id NUMBER;
917:
918: BEGIN
919: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');
920: oe_debug_pub.add('Header'||p_header_rec.header_id);
921: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);
922:
923: -- Set the OUT parameter

Line 2450: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug

2446:
2447: --ER#7479609 end
2448:
2449: END IF;
2450: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug
2451: EXCEPTION
2452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2454: WHEN OTHERS THEN

Line 3357: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');

3353:
3354: BEGIN
3355:
3356: IF l_debug_level > 0 THEN
3357: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');
3358: oe_debug_pub.add( 'p_line_index is '||p_line_index);
3359: END IF;
3360:
3361: -- Initialize API return value to False

Line 3439: oe_debug_pub.add( 'Exiting OE_BULK_HOLDS_PVT.Check_For_Holds');

3435: END IF;
3436: END IF;
3437: END IF;
3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add( 'Exiting OE_BULK_HOLDS_PVT.Check_For_Holds');
3440: END IF;
3441: RETURN FALSE;
3442:
3443: EXCEPTION

Line 3446: oe_debug_pub.add( 'In others of OE_BULK_HOLDS_PVT.Check_For_Holds');

3442:
3443: EXCEPTION
3444: WHEN OTHERS THEN
3445: IF l_debug_level > 0 THEN
3446: oe_debug_pub.add( 'In others of OE_BULK_HOLDS_PVT.Check_For_Holds');
3447: END IF;
3448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3449: THEN
3450: OE_MSG_PUB.Add_Exc_Msg

Line 3458: END OE_Bulk_Holds_PVT;

3454: END IF;
3455:
3456: END Check_For_Holds;
3457:
3458: END OE_Bulk_Holds_PVT;