eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 110: -- OE_DEBUG_PUB.Add('Result set to N. service reference type is not ORDER', 1); --commneted for bug12958565

106: ELSE -- Bug 4875015
107: -- resultout := 'COMPLETE:N'; --commneted for bug12958565
108: resultout := 'COMPLETE:Y'; --added for bug12958565
109: IF l_debug_level > 0 THEN
110: -- OE_DEBUG_PUB.Add('Result set to N. service reference type is not ORDER', 1); --commneted for bug12958565
111: OE_DEBUG_PUB.Add('Result set to Y. service reference type is Customer Product', 1); --added for bug12958565
112: END IF;
113: END IF; -- Bug 4875015 End
114:

Line 111: OE_DEBUG_PUB.Add('Result set to Y. service reference type is Customer Product', 1); --added for bug12958565

107: -- resultout := 'COMPLETE:N'; --commneted for bug12958565
108: resultout := 'COMPLETE:Y'; --added for bug12958565
109: IF l_debug_level > 0 THEN
110: -- OE_DEBUG_PUB.Add('Result set to N. service reference type is not ORDER', 1); --commneted for bug12958565
111: OE_DEBUG_PUB.Add('Result set to Y. service reference type is Customer Product', 1); --added for bug12958565
112: END IF;
113: END IF; -- Bug 4875015 End
114:
115: ELSIF nvl(l_shippable_flag,'N') = 'N' THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 269: oe_debug_pub.add('Workflow complete activity failed. Raising');

265: Result => OE_GLOBALS.G_WFR_COMPLETE,
266: raise_engine_exception => TRUE );
267: exception
268: WHEN OTHERS THEN
269: oe_debug_pub.add('Workflow complete activity failed. Raising');
270: RAISE ;
271: END ;
272:
273: IF l_debug_level > 0 THEN

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

270: RAISE ;
271: END ;
272:
273: IF l_debug_level > 0 THEN
274: OE_DEBUG_PUB.Add('Exiting Complete Fulfill Eligible Line ');
275: END IF;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN

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

278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280:
281: IF l_debug_level > 0 THEN
282: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
283: END IF;
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286:

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

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

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

290: WHEN OTHERS THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292:
293: IF l_debug_level > 0 THEN
294: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible'||sqlerrm);
295: END IF;
296:
297: END Complete_Fulfill_Eligible_Line;
298:

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

314: l_result_out VARCHAR2(240);
315: l_msg_count NUMBER;
316: l_msg_data VARCHAR2(2000);
317: --
318: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
319: --
320:
321: l_header_id NUMBER;
322: l_order_source_id NUMBER;

Line 337: oe_debug_pub.add( 'ENTERING OE_FULFILL_WF.START_FULFILLMENT '||ITEMTYPE||'/'||ITEMKEY , 0.5 ) ;

333: --
334: -- RUN mode - normal process execution
335: --
336: IF l_debug_level > 0 THEN -- debug level changed to 0.5 for bug 13435459
337: oe_debug_pub.add( 'ENTERING OE_FULFILL_WF.START_FULFILLMENT '||ITEMTYPE||'/'||ITEMKEY , 0.5 ) ;
338: END IF;
339: OE_STANDARD_WF.Set_Msg_Context(actid);
340:
341: if (funcmode = 'RUN') then

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

381:
382: OE_Line_Fullfill.G_DEBUG_MSG := NULL;
383:
384: IF l_debug_level > 0 THEN
385: oe_debug_pub.add( 'call OE_LINE_FULLFILL.Process_Fulfillment() for line'||TO_CHAR ( L_LINE_ID ) , 2 ) ;
386: END IF;
387: OE_Line_Fullfill.Process_Fulfillment
388: ( p_api_version_number => 1.0
389: , p_line_id => l_line_id

Line 399: oe_debug_pub.add( 'RETURNED FROM OE_LINE_FULLFILL.PROCESS_FULFILLMENT '||L_RETURN_STATUS , 0.5 );

395: );
396:
397: IF l_debug_level > 0 THEN
398: -- debug level changed to 0.5 for bug 13435459
399: oe_debug_pub.add( 'RETURNED FROM OE_LINE_FULLFILL.PROCESS_FULFILLMENT '||L_RETURN_STATUS , 0.5 );
400: END IF;
401:
402: IF l_return_status = 'DEFERRED' THEN
403: IF l_debug_level > 0 THEN

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

400: END IF;
401:
402: IF l_return_status = 'DEFERRED' THEN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add( 'WF activity deferred') ;
405: END IF;
406: --resultout := 'DEFERRED:'||to_char(sysdate+0.02, wf_engine.date_format); --bug 4189737
407: resultout := 'DEFERRED';
408: OE_STANDARD_WF.Clear_Msg_Context;

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

410: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
411: app_exception.raise_exception;
412: END IF;
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add( '*** completed fulfillment *** for line '||l_line_id,1);
415: END IF;
416: resultout := l_result_out;
417: OE_STANDARD_WF.Clear_Msg_Context;
418: return;

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

448: exception
449:
450: when others then
451: IF l_debug_level > 0 THEN
452: oe_debug_pub.add( 'Others exception in OEXWFULB.pls' ) ; -- bug 4189737
453: oe_debug_pub.add('Exception is '||sqlerrm,0.5); -- bug 4189737
454: END IF;
455: -- The line below records this function call in the error system
456: -- in the case of an exception.

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

449:
450: when others then
451: IF l_debug_level > 0 THEN
452: oe_debug_pub.add( 'Others exception in OEXWFULB.pls' ) ; -- bug 4189737
453: oe_debug_pub.add('Exception is '||sqlerrm,0.5); -- bug 4189737
454: END IF;
455: -- The line below records this function call in the error system
456: -- in the case of an exception.
457: wf_core.context('OE_Fulfill_WF', 'Fulfillment',