DBA Data[Home] [Help]

APPS.OE_CONFIG_TSO_GRP dependencies on OE_DEBUG_PUB

Line 14: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;

10:
11: PROCEDURE Print_Time (p_msg IN VARCHAR2)
12: IS
13: l_time VARCHAR2(100);
14: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;
15: BEGIN
16: l_time := to_char(new_time(sysdate,'PST','EST'),'DD-MON-YY HH24:MI:SS');
17: IF l_debug_level > 0 THEN
18: OE_DEBUG_PUB.Add (p_msg||':'||l_time,1);

Line 18: OE_DEBUG_PUB.Add (p_msg||':'||l_time,1);

14: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;
15: BEGIN
16: l_time := to_char(new_time(sysdate,'PST','EST'),'DD-MON-YY HH24:MI:SS');
17: IF l_debug_level > 0 THEN
18: OE_DEBUG_PUB.Add (p_msg||':'||l_time,1);
19: END IF;
20: END Print_Time;
21:
22:

Line 100: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;

96: ,x_config_mode OUT NOCOPY NUMBER
97: ,x_return_status OUT NOCOPY VARCHAR2
98: )
99: IS
100: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;
101: l_top_container_model VARCHAR2(1);
102: l_part_of_container VARCHAR2(1);
103: -- MOAC
104: l_org_id NUMBER;

Line 111: OE_DEBUG_PUB.Add('LineID:'||p_line_id,3);

107: l_reset_policy BOOLEAN := FALSE;
108: BEGIN
109: Print_Time ('Entering OE_CONFIG_TSO_GRP.Get_MACD_Action_Mode..');
110: IF l_debug_level > 0 THEN
111: OE_DEBUG_PUB.Add('LineID:'||p_line_id,3);
112: OE_DEBUG_PUB.Add('TopModelLineID:'||p_top_model_line_id,3);
113: END IF;
114:
115: x_return_status := FND_API.G_RET_STS_SUCCESS; --Nocopy changes

Line 112: OE_DEBUG_PUB.Add('TopModelLineID:'||p_top_model_line_id,3);

108: BEGIN
109: Print_Time ('Entering OE_CONFIG_TSO_GRP.Get_MACD_Action_Mode..');
110: IF l_debug_level > 0 THEN
111: OE_DEBUG_PUB.Add('LineID:'||p_line_id,3);
112: OE_DEBUG_PUB.Add('TopModelLineID:'||p_top_model_line_id,3);
113: END IF;
114:
115: x_return_status := FND_API.G_RET_STS_SUCCESS; --Nocopy changes
116:

Line 138: OE_DEBUG_PUB.Add('Null org id' || sqlerrm,3);

134: EXCEPTION
135:
136: WHEN OTHERS THEN
137: IF l_debug_level > 0 THEN
138: OE_DEBUG_PUB.Add('Null org id' || sqlerrm,3);
139: END IF;
140: RAISE FND_API.G_EXC_ERROR;
141: END;
142:

Line 144: oe_debug_pub.add('SO Org Id: ' ||l_org_id , 1 ) ;

140: RAISE FND_API.G_EXC_ERROR;
141: END;
142:
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add('SO Org Id: ' ||l_org_id , 1 ) ;
145: END IF;
146:
147:
148: IF nvl(l_current_org_id,-99) <> l_org_id THEN

Line 165: OE_DEBUG_PUB.Add('ERR: Only part of container models can use API',1);

161: IF l_part_of_container = 'N' THEN
162: x_config_mode := NULL;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: IF l_debug_level > 0 THEN
165: OE_DEBUG_PUB.Add('ERR: Only part of container models can use API',1);
166: OE_DEBUG_PUB.Add('Setting Return Status:'||x_return_status,1);
167: OE_DEBUG_PUB.Add('Config Mode:'||x_config_mode,2);
168: END IF;
169: Print_Time ('Exiting OE_CONFIG_TSO_GRP.Get_MACD_Action_Mode..');

Line 166: OE_DEBUG_PUB.Add('Setting Return Status:'||x_return_status,1);

162: x_config_mode := NULL;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: IF l_debug_level > 0 THEN
165: OE_DEBUG_PUB.Add('ERR: Only part of container models can use API',1);
166: OE_DEBUG_PUB.Add('Setting Return Status:'||x_return_status,1);
167: OE_DEBUG_PUB.Add('Config Mode:'||x_config_mode,2);
168: END IF;
169: Print_Time ('Exiting OE_CONFIG_TSO_GRP.Get_MACD_Action_Mode..');
170: RAISE FND_API.G_EXC_ERROR;

Line 167: OE_DEBUG_PUB.Add('Config Mode:'||x_config_mode,2);

163: x_return_status := FND_API.G_RET_STS_ERROR;
164: IF l_debug_level > 0 THEN
165: OE_DEBUG_PUB.Add('ERR: Only part of container models can use API',1);
166: OE_DEBUG_PUB.Add('Setting Return Status:'||x_return_status,1);
167: OE_DEBUG_PUB.Add('Config Mode:'||x_config_mode,2);
168: END IF;
169: Print_Time ('Exiting OE_CONFIG_TSO_GRP.Get_MACD_Action_Mode..');
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;

Line 175: OE_DEBUG_PUB.Add('L_PartOfContainer:'||l_part_of_container,3);

171: END IF;
172:
173: --following code is executed only if line is part of container model
174: IF l_debug_level > 0 THEN
175: OE_DEBUG_PUB.Add('L_PartOfContainer:'||l_part_of_container,3);
176: OE_DEBUG_PUB.Add('Eligible to call TSO_PVT.Get_MACD_Action_Mode',2);
177: END IF;
178: OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode
179: ( p_line_id => p_line_id

Line 176: OE_DEBUG_PUB.Add('Eligible to call TSO_PVT.Get_MACD_Action_Mode',2);

172:
173: --following code is executed only if line is part of container model
174: IF l_debug_level > 0 THEN
175: OE_DEBUG_PUB.Add('L_PartOfContainer:'||l_part_of_container,3);
176: OE_DEBUG_PUB.Add('Eligible to call TSO_PVT.Get_MACD_Action_Mode',2);
177: END IF;
178: OE_CONFIG_TSO_PVT.Get_MACD_Action_Mode
179: ( p_line_id => p_line_id
180: ,p_top_model_line_id => p_top_model_line_id

Line 185: OE_DEBUG_PUB.Add('Return Status:'||x_return_status,1);

181: ,x_config_mode => x_config_mode
182: ,x_return_status => x_return_status
183: );
184: IF l_debug_level > 0 THEN
185: OE_DEBUG_PUB.Add('Return Status:'||x_return_status,1);
186: OE_DEBUG_PUB.Add('Config Mode:'||x_config_mode,2);
187: END IF;
188:
189: IF l_reset_policy THEN -- MOAC

Line 186: OE_DEBUG_PUB.Add('Config Mode:'||x_config_mode,2);

182: ,x_return_status => x_return_status
183: );
184: IF l_debug_level > 0 THEN
185: OE_DEBUG_PUB.Add('Return Status:'||x_return_status,1);
186: OE_DEBUG_PUB.Add('Config Mode:'||x_config_mode,2);
187: END IF;
188:
189: IF l_reset_policy THEN -- MOAC
190: Mo_Global.Set_Policy_Context (p_access_mode => l_current_access_mode, p_org_id => l_current_org_id);

Line 204: OE_DEBUG_PUB.Add('Expected Exception in TSO_GRP.Get_MACD_Action_Mode'

200: END IF;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: x_config_mode := NULL;
203: IF l_debug_level > 0 THEN
204: OE_DEBUG_PUB.Add('Expected Exception in TSO_GRP.Get_MACD_Action_Mode'
205: ||sqlerrm,1);
206: END IF;
207:
208:

Line 216: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Get_MACD_Action_Mode'

212: END IF;
213: x_config_mode := NULL;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: IF l_debug_level > 0 THEN
216: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Get_MACD_Action_Mode'
217: ||sqlerrm,1);
218: END IF;
219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
220: OE_MSG_PUB.Add_Exc_Msg

Line 240: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;

236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY VARCHAR2,
238: x_msg_data OUT NOCOPY VARCHAR2)
239: IS
240: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;
241: l_line_tbl OE_ORDER_PUB.line_tbl_type;
242: l_number_of_containers NUMBER;
243: l_org_id NUMBER;
244: BEGIN

Line 260: OE_DEBUG_PUB.Add('Null org id',3);

256: l_org_id := MO_GLOBAL.get_current_org_id;
257: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
258:
259: IF l_debug_level > 0 THEN
260: OE_DEBUG_PUB.Add('Null org id',3);
261: END IF;
262:
263: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
264: OE_MSG_PUB.Add;

Line 269: OE_DEBUG_PUB.Add('Return Status:'||x_return_status,1);

265: RAISE FND_API.G_EXC_ERROR;
266: END IF;
267:
268: IF l_debug_level > 0 THEN
269: OE_DEBUG_PUB.Add('Return Status:'||x_return_status,1);
270: OE_DEBUG_PUB.Add('Org Id:' || l_org_id,1);
271: END IF;
272:
273: Oe_config_tso_pvt.Process_MACD_Order

Line 270: OE_DEBUG_PUB.Add('Org Id:' || l_org_id,1);

266: END IF;
267:
268: IF l_debug_level > 0 THEN
269: OE_DEBUG_PUB.Add('Return Status:'||x_return_status,1);
270: OE_DEBUG_PUB.Add('Org Id:' || l_org_id,1);
271: END IF;
272:
273: Oe_config_tso_pvt.Process_MACD_Order
274: (P_API_VERSION_NUMBER => P_API_VERSION_NUMBER,

Line 316: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Process_MACD_Order'

312: );
313: WHEN OTHERS THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: IF l_debug_level > 0 THEN
316: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Process_MACD_Order'
317: ||sqlerrm,1);
318: END IF;
319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
320: OE_MSG_PUB.Add_Exc_Msg