APPS.OE_SET_UTIL dependencies on OE_SET_UTIL

Line 1: PACKAGE BODY OE_Set_util AS

1: PACKAGE BODY OE_Set_util AS
2: /* $Header: OEXUSETB.pls 120.24.12020000.5 2013/03/28 10:18:50 sahvivek ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Line_Set';

Line 122: OE_DEBUG_PUB.Add('Entering OE_SET_UTIL.Validate_Shipset',1);

118:
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:
121: IF l_debug_level > 0 then
122: OE_DEBUG_PUB.Add('Entering OE_SET_UTIL.Validate_Shipset',1);
123: END IF;
124:
125: -- Select statement to check the Ship Set Enforce Parameter.
126: BEGIN

Line 184: OE_DEBUG_PUB.Add('Exiting OE_SET_UTIL.Validate_Shipset:'

180: END IF;
181:
182: END IF;
183: IF l_debug_level > 0 then
184: OE_DEBUG_PUB.Add('Exiting OE_SET_UTIL.Validate_Shipset:'
185: ||x_return_status,1);
186: END IF;
187:
188: EXCEPTION

Line 208: ( 'OE_SET_UTIL',

204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: OE_MSG_PUB.Add_Exc_Msg
208: ( 'OE_SET_UTIL',
209: 'Validate_Shipset');
210: END IF;
211: END Validate_Shipset;
212:

Line 264: ( 'OE_SET_UTIL',

260: WHEN OTHERS THEN
261: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
262: THEN
263: OE_MSG_PUB.Add_Exc_Msg
264: ( 'OE_SET_UTIL',
265: 'Is_Service_Eligible');
266: END IF;
267: RETURN FALSE;
268: END Is_Service_Eligible;

Line 322: oe_debug_pub.add('Create_Fulfillment_Set:'||OE_Set_util.g_set_rec.set_status ||' l_set_s ' || l_set_s);

318: oe_msg_pub.add;
319: RAISE FND_API.G_EXC_ERROR ;
320: END;
321:
322: oe_debug_pub.add('Create_Fulfillment_Set:'||OE_Set_util.g_set_rec.set_status ||' l_set_s ' || l_set_s);
323:
324: -- End changes for bug8420761
325:
326: IF is_set_closed(p_set_id => p_set_id) THEN

Line 406: oe_debug_pub.add( 'ENTER OE_SET_UTIL.FULFILL_STS' , 5 ) ;

402: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
403: --
404: BEGIN
405: IF l_debug_level > 0 THEN
406: oe_debug_pub.add( 'ENTER OE_SET_UTIL.FULFILL_STS' , 5 ) ;
407: END IF;
408: OE_LINE_FULLFILL.Get_Activity_Result (
409: p_item_type => OE_GLOBALS.G_WFI_LIN
410: , p_item_key => to_char(p_line_id)

Line 430: oe_debug_pub.add( 'EXIT OE_SET_UTIL.FULFILL_STS:'||L_ACTIVITY_STATUS , 5 ) ;

426: ELSE
427: l_activity_status := 'ERROR';
428: END IF;
429: IF l_debug_level > 0 THEN
430: oe_debug_pub.add( 'EXIT OE_SET_UTIL.FULFILL_STS:'||L_ACTIVITY_STATUS , 5 ) ;
431: END IF;
432: RETURN l_activity_status;
433:
434: END Fulfill_Sts;

Line 5171: oe_debug_pub.add( 'ENTERING OE_SET_UTIL.QUERY_ROWS' , 1 ) ;

5167: --
5168: BEGIN
5169:
5170: IF l_debug_level > 0 THEN
5171: oe_debug_pub.add( 'ENTERING OE_SET_UTIL.QUERY_ROWS' , 1 ) ;
5172: END IF;
5173:
5174:
5175: IF

Line 7356: IF oe_set_util.Set_Exist(p_set_name => p_x_line_rec.ship_set,

7352: AND p_x_line_rec.top_model_line_id IS NOT NULL THEN
7353:
7354: IF p_x_line_rec.ship_set IS NOT NULL AND
7355: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR THEN
7356: IF oe_set_util.Set_Exist(p_set_name => p_x_line_rec.ship_set,
7357: p_set_type => 'SHIP_SET',
7358: p_header_id =>p_x_line_rec.header_id,
7359: x_set_id => p_x_line_rec.ship_set_id) THEN
7360: null;

Line 7364: IF oe_set_util.Set_Exist(p_set_name => p_x_line_rec.arrival_set,

7360: null;
7361: END IF;
7362: ELSIF p_x_line_rec.arrival_set IS NOT NULL AND
7363: p_x_line_rec.arrival_set <> FND_API.G_MISS_CHAR THEN
7364: IF oe_set_util.Set_Exist(p_set_name => p_x_line_rec.arrival_set,
7365: p_set_type => 'ARRIVAL_SET',
7366: p_header_id =>p_x_line_rec.header_id,
7367: x_set_id => p_x_line_rec.arrival_set_id) THEN
7368: null;

Line 7878: END OE_Set_util;

7874: RETURN TRUE;
7875:
7876: END Stand_Alone_set_exists;
7877:
7878: END OE_Set_util;
7879: