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.10 2008/02/07 08:41:12 spothula 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 254: ( 'OE_SET_UTIL',

250: WHEN OTHERS THEN
251: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
252: THEN
253: OE_MSG_PUB.Add_Exc_Msg
254: ( 'OE_SET_UTIL',
255: 'Is_Service_Eligible');
256: END IF;
257: RETURN FALSE;
258: END Is_Service_Eligible;

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

366: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
367: --
368: BEGIN
369: IF l_debug_level > 0 THEN
370: oe_debug_pub.add( 'ENTER OE_SET_UTIL.FULFILL_STS' , 5 ) ;
371: END IF;
372: OE_LINE_FULLFILL.Get_Activity_Result (
373: p_item_type => OE_GLOBALS.G_WFI_LIN
374: , p_item_key => to_char(p_line_id)

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

390: ELSE
391: l_activity_status := 'ERROR';
392: END IF;
393: IF l_debug_level > 0 THEN
394: oe_debug_pub.add( 'EXIT OE_SET_UTIL.FULFILL_STS:'||L_ACTIVITY_STATUS , 5 ) ;
395: END IF;
396: RETURN l_activity_status;
397:
398: END Fulfill_Sts;

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

5110: --
5111: BEGIN
5112:
5113: IF l_debug_level > 0 THEN
5114: oe_debug_pub.add( 'ENTERING OE_SET_UTIL.QUERY_ROWS' , 1 ) ;
5115: END IF;
5116:
5117:
5118: IF

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

6872: AND p_x_line_rec.top_model_line_id IS NOT NULL THEN
6873:
6874: IF p_x_line_rec.ship_set IS NOT NULL AND
6875: p_x_line_rec.ship_set <> FND_API.G_MISS_CHAR THEN
6876: IF oe_set_util.Set_Exist(p_set_name => p_x_line_rec.ship_set,
6877: p_set_type => 'SHIP_SET',
6878: p_header_id =>p_x_line_rec.header_id,
6879: x_set_id => p_x_line_rec.ship_set_id) THEN
6880: null;

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

6880: null;
6881: END IF;
6882: ELSIF p_x_line_rec.arrival_set IS NOT NULL AND
6883: p_x_line_rec.arrival_set <> FND_API.G_MISS_CHAR THEN
6884: IF oe_set_util.Set_Exist(p_set_name => p_x_line_rec.arrival_set,
6885: p_set_type => 'ARRIVAL_SET',
6886: p_header_id =>p_x_line_rec.header_id,
6887: x_set_id => p_x_line_rec.arrival_set_id) THEN
6888: null;

Line 7306: END OE_Set_util;

7302: );
7303: END IF;
7304: END Delete_Set;
7305:
7306: END OE_Set_util;
7307: