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_LINE_FULLFILL dependencies on OE_LINE_FULLFILL

Line 1: PACKAGE BODY OE_LINE_FULLFILL AS

1: PACKAGE BODY OE_LINE_FULLFILL AS
2: /* $Header: OEXVFULB.pls 120.15.12010000.2 2008/08/04 15:07:55 amallik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Fullfill';
5: G_FULFILL_WITH_ACTIVITY CONSTANT VARCHAR2(30) := 'With Activity';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Fullfill';

1: PACKAGE BODY OE_LINE_FULLFILL AS
2: /* $Header: OEXVFULB.pls 120.15.12010000.2 2008/08/04 15:07:55 amallik ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Line_Fullfill';
5: G_FULFILL_WITH_ACTIVITY CONSTANT VARCHAR2(30) := 'With Activity';
6: G_FULFILL_NO_ACTIVITY CONSTANT VARCHAR2(30) := 'No Activity';
7:
8: g_set_tbl processed_set;

Line 235: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.IS_PART_OF_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 5 ) ;

231: --
232: BEGIN
233:
234: IF l_debug_level > 0 THEN
235: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.IS_PART_OF_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 5 ) ;
236: END IF;
237:
238: Select set_id
239: Into l_set_id

Line 304: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_SERVICE_LINES '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

300: AND TOP_MODEL_LINE_ID IS NULL; --3449588
301: BEGIN
302:
303: IF l_debug_level > 0 THEN
304: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_SERVICE_LINES '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
305: END IF;
306:
307:
308: IF p_header_id IS NULL OR -- This IF introduced for 1717444

Line 390: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387: END IF;
388:
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
391: END IF;
392:
393: EXCEPTION
394:

Line 399: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
397:
398: IF l_debug_level > 0 THEN
399: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
400: END IF;
401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
402: THEN
403: OE_MSG_PUB.Add_Exc_Msg

Line 416: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

412: IF l_debug_level > 0 THEN
413: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
414: END IF;
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
417: END IF;
418:
419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
420: THEN

Line 453: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

449: --
450: BEGIN
451:
452: IF l_debug_level > 0 THEN
453: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
454: END IF;
455:
456: /* Get the service lines if there are any associated with the
457: line */

Line 597: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES '|| X_RETURN_STATUS , 1 ) ;

593:
594: x_return_status := FND_API.G_RET_STS_SUCCESS;
595:
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES '|| X_RETURN_STATUS , 1 ) ;
598: END IF;
599:
600: EXCEPTION
601:

Line 606: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604:
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
607: END IF;
608: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
609: THEN
610: OE_MSG_PUB.Add_Exc_Msg

Line 623: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;

619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
621: END IF;
622: IF l_debug_level > 0 THEN
623: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
624: END IF;
625:
626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN

Line 765: oe_debug_pub.add('Entering oe_line_fullfill.fulfill_line() '||to_char(p_line_rec.line_id),1) ;

761:
762: BEGIN
763:
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add('Entering oe_line_fullfill.fulfill_line() '||to_char(p_line_rec.line_id),1) ;
766: END IF;
767:
768:
769: l_line_rec.service_start_date := NULL; -- initialization for 2292133

Line 918: oe_debug_pub.add('Update_global return status from oe_line_fullfill.fullfill_line is: '|| l_return_status ) ;

914: x_return_status => l_return_status);
915:
916:
917: IF l_debug_level > 0 THEN
918: oe_debug_pub.add('Update_global return status from oe_line_fullfill.fullfill_line is: '|| l_return_status ) ;
919: oe_debug_pub.add('Global picture index is: '||l_notify_index,1) ;
920: END IF;
921: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1398: oe_debug_pub.add('Exiting oe_line_fullfill.fulfill_line()',1) ;

1394: END IF; /* ASO and DBI check for Pack H and higher */
1395:
1396: END IF; --code_release_level
1397: IF l_debug_level > 0 THEN
1398: oe_debug_pub.add('Exiting oe_line_fullfill.fulfill_line()',1) ;
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_SUCCESS;
1401:
1402: EXCEPTION

Line 1508: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_ACTIVITY_RESULT '|| P_ITEM_TYPE||'/'||P_ITEM_KEY||'/'||P_ACTIVITY_NAME , 1 ) ;

1504: --
1505: BEGIN
1506:
1507: IF l_debug_level > 0 THEN
1508: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_ACTIVITY_RESULT '|| P_ITEM_TYPE||'/'||P_ITEM_KEY||'/'||P_ACTIVITY_NAME , 1 ) ;
1509: END IF;
1510:
1511: SELECT wias.ACTIVITY_STATUS, wias.ACTIVITY_RESULT_CODE, wias.PROCESS_ACTIVITY
1512: INTO x_activity_status_code, x_activity_result, x_activity_id

Line 1522: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_ACTIVITY_RESULT '||X_ACTIVITY_RESULT||'/'||X_RETURN_STATUS , 1 ) ;

1518:
1519: x_return_status := FND_API.G_RET_STS_SUCCESS;
1520:
1521: IF l_debug_level > 0 THEN
1522: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_ACTIVITY_RESULT '||X_ACTIVITY_RESULT||'/'||X_RETURN_STATUS , 1 ) ;
1523: END IF;
1524:
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN

Line 1604: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

1600: --
1601: BEGIN
1602:
1603: IF l_debug_level > 0 THEN
1604: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
1605: END IF;
1606:
1607:
1608:

Line 1732: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_FULFILLMENT_SET ' , 3 ) ;

1728: END LOOP;
1729:
1730: x_return_status := FND_API.G_RET_STS_SUCCESS;
1731: IF l_debug_level > 0 THEN
1732: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_FULFILLMENT_SET ' , 3 ) ;
1733: END IF;
1734:
1735: EXCEPTION
1736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1812: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_FULFILLMENT_ACTIVITY '|| P_ITEM_KEY , 1 ) ;

1808: l_upgraded_flag VARCHAR2(1); -- bug 3589692
1809: BEGIN
1810:
1811: IF l_debug_level > 0 THEN
1812: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_FULFILLMENT_ACTIVITY '|| P_ITEM_KEY , 1 ) ;
1813: END IF;
1814:
1815:
1816: select line_category_code into l_line_category_code

Line 2000: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.CHECK_PTO_KIT_FULFILLMENT '|| TO_CHAR ( P_TOP_MODEL_LINE_ID ) , 1 ) ;

1996: --
1997: BEGIN
1998:
1999: IF l_debug_level > 0 THEN
2000: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.CHECK_PTO_KIT_FULFILLMENT '|| TO_CHAR ( P_TOP_MODEL_LINE_ID ) , 1 ) ;
2001: END IF;
2002:
2003:
2004: l_top_model_line_id := p_top_model_line_id;

Line 2050: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CHECK_PTO_KIT_FULFILLMENT '||L_FULFILL_STATUS||'/'||X_RETURN_STATUS , 1 ) ;

2046: x_fulfill_status := l_fulfill_status;
2047: x_return_status := FND_API.G_RET_STS_SUCCESS;
2048:
2049: IF l_debug_level > 0 THEN
2050: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CHECK_PTO_KIT_FULFILLMENT '||L_FULFILL_STATUS||'/'||X_RETURN_STATUS , 1 ) ;
2051: END IF;
2052:
2053: EXCEPTION
2054:

Line 2115: oe_debug_pub.add('Entering oe_line_fullfill.fulfill_pto_kit() '||to_char(p_top_model_line_id),1) ;

2111: AND OPEN_FLAG = 'Y';
2112: BEGIN
2113:
2114: IF l_debug_level > 0 THEN
2115: oe_debug_pub.add('Entering oe_line_fullfill.fulfill_pto_kit() '||to_char(p_top_model_line_id),1) ;
2116: END IF;
2117:
2118: l_top_model_line_id := p_top_model_line_id;
2119: FOR l_top_lines IN c_fulfill_lines LOOP

Line 2294: oe_debug_pub.add('Exiting oe_line_fullfill.fulfill_pto_kit '||x_return_status,3) ;

2290:
2291: x_return_status := FND_API.G_RET_STS_SUCCESS;
2292:
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add('Exiting oe_line_fullfill.fulfill_pto_kit '||x_return_status,3) ;
2295: END IF;
2296:
2297: EXCEPTION
2298:

Line 2810: oe_debug_pub.add('** complete OE_Line_Fullfill.Process_PTO_Kit() ',1);

2806: x_fulfillment_status := l_fulfilled_flag;
2807: x_return_status := FND_API.G_RET_STS_SUCCESS;
2808:
2809: IF l_debug_level > 0 THEN
2810: oe_debug_pub.add('** complete OE_Line_Fullfill.Process_PTO_Kit() ',1);
2811: END IF;
2812:
2813: EXCEPTION
2814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2912: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.PROCESS_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

2908: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2909: --
2910: BEGIN
2911: IF l_debug_level > 0 THEN
2912: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.PROCESS_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
2913: END IF;
2914:
2915: /* Prepare a table of line and set id's to be processed. This new table
2916: will have indication whether it is a standard line or a configuration. */

Line 3345: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.PROCESS_FULFILLMENT_SET '||X_RETURN_STATUS||'/'||X_FULFILLMENT_STATUS , 1 ) ;

3341:
3342: x_return_status := FND_API.G_RET_STS_SUCCESS;
3343: x_fulfillment_status := l_fulfilled_flag;
3344: IF l_debug_level > 0 THEN
3345: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.PROCESS_FULFILLMENT_SET '||X_RETURN_STATUS||'/'||X_FULFILLMENT_STATUS , 1 ) ;
3346: END IF;
3347:
3348:
3349: EXCEPTION

Line 3445: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.PROCESS_FULFILLMENT '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

3441: --
3442: BEGIN
3443:
3444: IF l_debug_level > 0 THEN
3445: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.PROCESS_FULFILLMENT '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
3446: END IF;
3447:
3448:
3449:

Line 4420: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.PROCESS_FULFILLMENT '||X_RESULT_OUT , 3 ) ;

4416:
4417: END IF;
4418:
4419: IF l_debug_level > 0 THEN
4420: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.PROCESS_FULFILLMENT '||X_RESULT_OUT , 3 ) ;
4421: END IF;
4422:
4423: IF x_result_out = 'NOTIFIED:#NULL' THEN
4424:

Line 4591: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.CANCEL_LINE : '||TO_CHAR ( P_LINE_ID ) , 1 ) ;

4587: --
4588: BEGIN
4589:
4590: IF l_debug_level > 0 THEN
4591: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.CANCEL_LINE : '||TO_CHAR ( P_LINE_ID ) , 1 ) ;
4592: END IF;
4593:
4594:
4595:

Line 5384: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CANCEL_LINE : '||X_RETURN_STATUS , 1 ) ;

5380: << LINE_NOT_IN_SET >>
5381:
5382: x_return_status := FND_API.G_RET_STS_SUCCESS;
5383: IF l_debug_level > 0 THEN
5384: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CANCEL_LINE : '||X_RETURN_STATUS , 1 ) ;
5385: END IF;
5386:
5387: EXCEPTION
5388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5426: END OE_LINE_FULLFILL;

5422: G_DEBUG_MSG := G_DEBUG_MSG || 'E25,';
5423:
5424: END Cancel_Line;
5425:
5426: END OE_LINE_FULLFILL;
5427: