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.24.12020000.8 2013/04/09 08:00:43 spothula 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.24.12020000.8 2013/04/09 08:00:43 spothula 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: G_BINARY_LIMIT CONSTANT NUMBER :=OE_GLOBALS.G_BINARY_LIMIT; --7827727
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 603: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES '|| X_RETURN_STATUS , 1 ) ;

599:
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES '|| X_RETURN_STATUS , 1 ) ;
604: END IF;
605:
606: EXCEPTION
607:

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

608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610:
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
613: END IF;
614: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
615: THEN
616: OE_MSG_PUB.Add_Exc_Msg

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

625: IF l_debug_level > 0 THEN
626: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
627: END IF;
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.FULFILL_SERVICE_LINES WITH STATUS: '|| X_RETURN_STATUS , 1 ) ;
630: END IF;
631:
632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
633: THEN

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

935: x_return_status => l_return_status);
936:
937:
938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add('Update_global return status from oe_line_fullfill.fullfill_line is: '|| l_return_status ) ;
940: oe_debug_pub.add('Global picture index is: '||l_notify_index,1) ;
941: END IF;
942: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1585: --
1586: BEGIN
1587:
1588: IF l_debug_level > 0 THEN
1589: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_ACTIVITY_RESULT '|| P_ITEM_TYPE||'/'||P_ITEM_KEY||'/'||P_ACTIVITY_NAME , 1 ) ;
1590: END IF;
1591:
1592: SELECT wias.ACTIVITY_STATUS, wias.ACTIVITY_RESULT_CODE, wias.PROCESS_ACTIVITY
1593: INTO x_activity_status_code, x_activity_result, x_activity_id

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

1599:
1600: x_return_status := FND_API.G_RET_STS_SUCCESS;
1601:
1602: IF l_debug_level > 0 THEN
1603: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_ACTIVITY_RESULT '||X_ACTIVITY_RESULT||'/'||X_RETURN_STATUS , 1 ) ;
1604: END IF;
1605:
1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN

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

1685: --
1686: BEGIN
1687:
1688: IF l_debug_level > 0 THEN
1689: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
1690: END IF;
1691:
1692:
1693:

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

1815: END LOOP;
1816:
1817: x_return_status := FND_API.G_RET_STS_SUCCESS;
1818: IF l_debug_level > 0 THEN
1819: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.GET_FULFILLMENT_SET ' , 3 ) ;
1820: END IF;
1821:
1822: EXCEPTION
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1895: l_upgraded_flag VARCHAR2(1); -- bug 3589692
1896: BEGIN
1897:
1898: IF l_debug_level > 0 THEN
1899: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.GET_FULFILLMENT_ACTIVITY '|| P_ITEM_KEY , 1 ) ;
1900: END IF;
1901:
1902:
1903: select line_category_code into l_line_category_code

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

2083: --
2084: BEGIN
2085:
2086: IF l_debug_level > 0 THEN
2087: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.CHECK_PTO_KIT_FULFILLMENT '|| TO_CHAR ( P_TOP_MODEL_LINE_ID ) , 1 ) ;
2088: END IF;
2089:
2090:
2091: l_top_model_line_id := p_top_model_line_id;

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

2133: x_fulfill_status := l_fulfill_status;
2134: x_return_status := FND_API.G_RET_STS_SUCCESS;
2135:
2136: IF l_debug_level > 0 THEN
2137: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CHECK_PTO_KIT_FULFILLMENT '||L_FULFILL_STATUS||'/'||X_RETURN_STATUS , 1 ) ;
2138: END IF;
2139:
2140: EXCEPTION
2141:

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

2204: AND OPEN_FLAG = 'Y';
2205: BEGIN
2206:
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add('Entering oe_line_fullfill.fulfill_pto_kit() '||to_char(p_top_model_line_id),1) ;
2209: END IF;
2210:
2211: l_top_model_line_id := p_top_model_line_id;
2212: FOR l_top_lines IN c_fulfill_lines LOOP

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

2418:
2419: x_return_status := FND_API.G_RET_STS_SUCCESS;
2420:
2421: IF l_debug_level > 0 THEN
2422: oe_debug_pub.add('Exiting oe_line_fullfill.fulfill_pto_kit '||x_return_status,3) ;
2423: END IF;
2424:
2425: EXCEPTION
2426:

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

2956: x_fulfillment_status := l_fulfilled_flag;
2957: x_return_status := FND_API.G_RET_STS_SUCCESS;
2958:
2959: IF l_debug_level > 0 THEN
2960: oe_debug_pub.add('** complete OE_Line_Fullfill.Process_PTO_Kit() ',1);
2961: END IF;
2962:
2963: EXCEPTION
2964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3063: --
3064: BEGIN
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.PROCESS_FULFILLMENT_SET '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
3067: END IF;
3068:
3069: /* Prepare a table of line and set id's to be processed. This new table
3070: will have indication whether it is a standard line or a configuration. */

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

3520:
3521: x_return_status := FND_API.G_RET_STS_SUCCESS;
3522: x_fulfillment_status := l_fulfilled_flag;
3523: IF l_debug_level > 0 THEN
3524: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.PROCESS_FULFILLMENT_SET '||X_RETURN_STATUS||'/'||X_FULFILLMENT_STATUS , 1 ) ;
3525: END IF;
3526:
3527:
3528: EXCEPTION

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

3621: --
3622: BEGIN
3623:
3624: IF l_debug_level > 0 THEN
3625: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.PROCESS_FULFILLMENT '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
3626: END IF;
3627:
3628:
3629:

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

4623:
4624: END IF;
4625:
4626: IF l_debug_level > 0 THEN
4627: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.PROCESS_FULFILLMENT '||X_RESULT_OUT , 3 ) ;
4628: END IF;
4629:
4630: IF x_result_out = 'NOTIFIED:#NULL' THEN
4631:

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

4818: --
4819: BEGIN
4820:
4821: IF l_debug_level > 0 THEN
4822: oe_debug_pub.add( 'ENTERING OE_LINE_FULLFILL.CANCEL_LINE : '||TO_CHAR ( P_LINE_ID ) , 1 ) ;
4823: END IF;
4824:
4825:
4826:

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

5627: << LINE_NOT_IN_SET >>
5628:
5629: x_return_status := FND_API.G_RET_STS_SUCCESS;
5630: IF l_debug_level > 0 THEN
5631: oe_debug_pub.add( 'EXITING OE_LINE_FULLFILL.CANCEL_LINE : '||X_RETURN_STATUS , 1 ) ;
5632: END IF;
5633:
5634: EXCEPTION
5635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5673: END OE_LINE_FULLFILL;

5669: G_DEBUG_MSG := G_DEBUG_MSG || 'E25,';
5670:
5671: END Cancel_Line;
5672:
5673: END OE_LINE_FULLFILL;
5674: