DBA Data[Home] [Help]

APPS.OE_FULFILL_WF dependencies on OE_DEBUG_PUB

Line 28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

24: -- Bug 4875015
25: l_service_reference_type_code VARCHAR2(30);
26:
27: --
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30:
31: BEGIN
32:

Line 38: oe_debug_pub.add('Entering Check Wait to Fulfill Line'||itemkey,1 ) ;

34: -- RUN mode - normal process execution
35: --
36:
37: IF l_debug_level > 0 THEN
38: oe_debug_pub.add('Entering Check Wait to Fulfill Line'||itemkey,1 ) ;
39: END IF;
40:
41: IF (funcmode = 'RUN') THEN
42:

Line 61: OE_DEBUG_PUB.Add('Result set to No, Line part of configuration!!');

57:
58: resultout := 'COMPLETE:N';
59:
60: IF l_debug_level > 0 THEN
61: OE_DEBUG_PUB.Add('Result set to No, Line part of configuration!!');
62: END IF;
63:
64: ELSIF l_item_type = 'SERVICE' AND
65: nvl(l_shippable_flag,'N') = 'N' THEN

Line 86: OE_DEBUG_PUB.Add('Result set to No!! Service in same order');

82: IF l_header_id = l_service_header_id AND
83: nvl(l_service_ship_flag,'N') = 'Y' THEN
84:
85: IF l_debug_level > 0 THEN
86: OE_DEBUG_PUB.Add('Result set to No!! Service in same order');
87: END IF;
88:
89: -- Do not hold services lines attached
90: -- to lines with in the same order.

Line 96: OE_DEBUG_PUB.Add('Result set to Yes!! Service not in same order');

92: resultout := 'COMPLETE:N';
93: ELSE
94:
95: IF l_debug_level > 0 THEN
96: OE_DEBUG_PUB.Add('Result set to Yes!! Service not in same order');
97: OE_DEBUG_PUB.Add('or Line is Service attached to Non Shippable Line');
98: END IF;
99:
100: -- Hold services lines attached

Line 97: OE_DEBUG_PUB.Add('or Line is Service attached to Non Shippable Line');

93: ELSE
94:
95: IF l_debug_level > 0 THEN
96: OE_DEBUG_PUB.Add('Result set to Yes!! Service not in same order');
97: OE_DEBUG_PUB.Add('or Line is Service attached to Non Shippable Line');
98: END IF;
99:
100: -- Hold services lines attached
101: -- to lines not in the same order.

Line 109: OE_DEBUG_PUB.Add('Result set to N. service reference type is not ORDER', 1);

105:
106: ELSE -- Bug 4875015
107: resultout := 'COMPLETE:N';
108: IF l_debug_level > 0 THEN
109: OE_DEBUG_PUB.Add('Result set to N. service reference type is not ORDER', 1);
110: END IF;
111: END IF; -- Bug 4875015 End
112:
113: ELSIF nvl(l_shippable_flag,'N') = 'N' THEN

Line 120: OE_DEBUG_PUB.Add('Result set to YES!! Non Shippable Line');

116:
117: resultout := 'COMPLETE:Y';
118:
119: IF l_debug_level > 0 THEN
120: OE_DEBUG_PUB.Add('Result set to YES!! Non Shippable Line');
121: END IF;
122:
123: ELSE
124:

Line 128: OE_DEBUG_PUB.Add('Result set to No!!Shippable Line');

124:
125: resultout := 'COMPLETE:N';
126:
127: IF l_debug_level > 0 THEN
128: OE_DEBUG_PUB.Add('Result set to No!!Shippable Line');
129: END IF;
130: END IF;
131:
132: ELSE

Line 178: OE_DEBUG_PUB.Add('When Other in Check Wait Fulfill'||sqlerrm);

174: -- end data fix project
175: OE_STANDARD_WF.Save_Messages;
176: OE_STANDARD_WF.Clear_Msg_Context;
177: IF l_debug_level > 0 THEN
178: OE_DEBUG_PUB.Add('When Other in Check Wait Fulfill'||sqlerrm);
179: END IF;
180: raise;
181: END Check_Wait_To_Fulfill_Line;
182:

Line 202: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

198: l_line_rec OE_Order_PUB.Line_Rec_Type;
199: l_return_status VARCHAR2(1);
200:
201: --
202: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
203: --
204:
205: BEGIN
206:

Line 212: OE_DEBUG_PUB.Add('Entering Complete Fulfill Eligible Line ');

208:
209: -- Check whether the line is eligible to Fulfill
210:
211: IF l_debug_level > 0 THEN
212: OE_DEBUG_PUB.Add('Entering Complete Fulfill Eligible Line ');
213: END IF;
214:
215: BEGIN
216: SELECT WIAS.Activity_Status

Line 230: OE_DEBUG_PUB.Add('Line Not Eligible for Fulfillment');

226: WHEN NO_DATA_FOUND THEN
227: x_return_status := FND_API.G_RET_STS_ERROR;
228:
229: IF l_debug_level > 0 THEN
230: OE_DEBUG_PUB.Add('Line Not Eligible for Fulfillment');
231: END IF;
232: RETURN;
233: END;
234:

Line 238: oe_debug_pub.add('Before Calling Lock Row'||p_line_id);

234:
235: -- Lock the Row
236:
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add('Before Calling Lock Row'||p_line_id);
239: END IF;
240:
241: OE_Line_Util.lock_Row
242: ( p_line_id => p_line_id

Line 248: oe_debug_pub.add('After Calling Lock Row'||l_return_status);

244: ,x_return_status => l_return_status
245: );
246:
247: IF l_debug_level > 0 THEN
248: oe_debug_pub.add('After Calling Lock Row'||l_return_status);
249: END IF;
250:
251: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 266: OE_DEBUG_PUB.Add('Exiting Complete Fulfill Eligible Line ');

262: Activity => 'FULFILL_LINE_ELIGIBLE',
263: Result => OE_GLOBALS.G_WFR_COMPLETE);
264:
265: IF l_debug_level > 0 THEN
266: OE_DEBUG_PUB.Add('Exiting Complete Fulfill Eligible Line ');
267: END IF;
268:
269: EXCEPTION
270: WHEN FND_API.G_EXC_ERROR THEN

Line 274: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);

270: WHEN FND_API.G_EXC_ERROR THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272:
273: IF l_debug_level > 0 THEN
274: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
275: END IF;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:

Line 280: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible');

276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: IF l_debug_level > 0 THEN
280: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible');
281: END IF;
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284:

Line 286: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible'||sqlerrm);

282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284:
285: IF l_debug_level > 0 THEN
286: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible'||sqlerrm);
287: END IF;
288:
289: END Complete_Fulfill_Eligible_Line;
290:

Line 310: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

306: l_result_out VARCHAR2(240);
307: l_msg_count NUMBER;
308: l_msg_data VARCHAR2(2000);
309: --
310: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
311: --
312:
313: l_header_id NUMBER;
314: l_order_source_id NUMBER;

Line 329: oe_debug_pub.add('*** enter Start_Fulfillment() in OEXWFULB.pls for item type/item key'||ITEMTYPE||'/'||ITEMKEY , 1 ) ;

325: --
326: -- RUN mode - normal process execution
327: --
328: IF l_debug_level > 0 THEN
329: oe_debug_pub.add('*** enter Start_Fulfillment() in OEXWFULB.pls for item type/item key'||ITEMTYPE||'/'||ITEMKEY , 1 ) ;
330: END IF;
331: OE_STANDARD_WF.Set_Msg_Context(actid);
332:
333: if (funcmode = 'RUN') then

Line 377: oe_debug_pub.add( 'call OE_LINE_FULLFILL.Process_Fulfillment() for line'||TO_CHAR ( L_LINE_ID ) , 2 ) ;

373:
374: OE_Line_Fullfill.G_DEBUG_MSG := NULL;
375:
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add( 'call OE_LINE_FULLFILL.Process_Fulfillment() for line'||TO_CHAR ( L_LINE_ID ) , 2 ) ;
378: END IF;
379: OE_Line_Fullfill.Process_Fulfillment
380: ( p_api_version_number => 1.0
381: , p_line_id => l_line_id

Line 390: oe_debug_pub.add('Returned from oe_line_fullfill.process_fulfillment '||l_return_status , 2 ) ;

386: , x_msg_data => l_msg_data
387: );
388:
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add('Returned from oe_line_fullfill.process_fulfillment '||l_return_status , 2 ) ;
391: END IF;
392:
393:
394: IF l_return_status = 'DEFERRED' THEN

Line 396: oe_debug_pub.add( 'WF activity deferred') ;

392:
393:
394: IF l_return_status = 'DEFERRED' THEN
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'WF activity deferred') ;
397: END IF;
398: --resultout := 'DEFERRED:'||to_char(sysdate+0.02, wf_engine.date_format); --bug 4189737
399: resultout := 'DEFERRED';
400: OE_STANDARD_WF.Clear_Msg_Context;

Line 406: oe_debug_pub.add( '*** completed fulfillment *** for line '||l_line_id,1);

402: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
403: app_exception.raise_exception;
404: END IF;
405: IF l_debug_level > 0 THEN
406: oe_debug_pub.add( '*** completed fulfillment *** for line '||l_line_id,1);
407: END IF;
408: resultout := l_result_out;
409: OE_STANDARD_WF.Clear_Msg_Context;
410: return;

Line 444: oe_debug_pub.add( 'Others exception in OEXWFULB.pls' ) ; -- bug 4189737

440: exception
441:
442: when others then
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add( 'Others exception in OEXWFULB.pls' ) ; -- bug 4189737
445: oe_debug_pub.add('Exception is '||sqlerrm,0.5); -- bug 4189737
446: END IF;
447: -- The line below records this function call in the error system
448: -- in the case of an exception.

Line 445: oe_debug_pub.add('Exception is '||sqlerrm,0.5); -- bug 4189737

441:
442: when others then
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add( 'Others exception in OEXWFULB.pls' ) ; -- bug 4189737
445: oe_debug_pub.add('Exception is '||sqlerrm,0.5); -- bug 4189737
446: END IF;
447: -- The line below records this function call in the error system
448: -- in the case of an exception.
449: wf_core.context('OE_Fulfill_WF', 'Fulfillment',