DBA Data[Home] [Help]

APPS.OE_CONFIG_TSO_GRP dependencies on FND_API

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS; --Nocopy changes

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:
117: -- MOAC change
118: -- Check if org context has been set before doing any process
119: -- Set the context if not already or if the org on the line_id is different

Line 140: RAISE FND_API.G_EXC_ERROR;

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:
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add('SO Org Id: ' ||l_org_id , 1 ) ;

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

159: );
160:
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);

Line 170: RAISE FND_API.G_EXC_ERROR;

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;
172:
173: --following code is executed only if line is part of container model
174: IF l_debug_level > 0 THEN

Line 196: WHEN FND_API.G_EXC_ERROR THEN

192: Print_Time ('Exiting OE_CONFIG_TSO_GRP.Get_MACD_Action_Mode..');
193:
194: EXCEPTION
195:
196: WHEN FND_API.G_EXC_ERROR THEN
197:
198: IF l_reset_policy THEN -- MOAC
199: Mo_Global.Set_Policy_Context (p_access_mode => l_current_access_mode, p_org_id => l_current_org_id);
200: END IF;

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197:
198: IF l_reset_policy THEN -- MOAC
199: Mo_Global.Set_Policy_Context (p_access_mode => l_current_access_mode, p_org_id => l_current_org_id);
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);

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

210: IF l_reset_policy THEN -- MOAC
211: Mo_Global.Set_Policy_Context (p_access_mode => l_current_access_mode, p_org_id => l_current_org_id);
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;

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: Print_Time ('Entering OE_CONFIG_TSO_GRP.Process_MACD_Order..');
246:
247:
248: -- Main Logic
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251: -- MOAC change
252: -- Check if org context has been set before doing any process
253: -- If there is no org context set, we stop calling group process order API

Line 257: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN

253: -- If there is no org context set, we stop calling group process order API
254: -- and raise an error though we don't do any validation for the org_id.
255:
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;

Line 265: RAISE FND_API.G_EXC_ERROR;

261: END IF;
262:
263: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
264: OE_MSG_PUB.Add;
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);

Line 292: WHEN FND_API.G_EXC_ERROR THEN

288: Print_Time ('Exiting OE_CONFIG_TSO_GRP.Process_MACD_Order..');
289:
290: EXCEPTION
291:
292: WHEN FND_API.G_EXC_ERROR THEN
293:
294: x_return_status := FND_API.G_RET_STS_ERROR;
295:
296: -- Get message count and data

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: EXCEPTION
291:
292: WHEN FND_API.G_EXC_ERROR THEN
293:
294: x_return_status := FND_API.G_RET_STS_ERROR;
295:
296: -- Get message count and data
297:
298: OE_MSG_PUB.Count_And_Get

Line 303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

299: ( p_count => x_msg_count
300: , p_data => x_msg_data
301: );
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304:
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306:
307: -- Get message count and data

Line 305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

301: );
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304:
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306:
307: -- Get message count and data
308:
309: OE_MSG_PUB.Count_And_Get

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310: ( p_count => x_msg_count
311: , p_data => x_msg_data
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;