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_ORDER_SCH_UTIL dependencies on OE_ORDER_SCH_UTIL

Line 1: PACKAGE BODY OE_ORDER_SCH_UTIL AS

1: PACKAGE BODY OE_ORDER_SCH_UTIL AS
2: /* $Header: OEXVSCHB.pls 120.5 2005/12/15 03:42:56 rmoharan noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Schedule';
5: G_SOURCE_AGAIN VARCHAR2(1) := 'Y';

Line 729: l_sales_order_id := OE_ORDER_SCH_UTIL.Get_mtl_sales_order_id

725: -- Starting with the index of 2 since the first element has
726: -- been occupied by the parent line.
727:
728: -- Get reserved quantity for the lines.
729: l_sales_order_id := OE_ORDER_SCH_UTIL.Get_mtl_sales_order_id
730: (p_x_line_rec.HEADER_ID);
731:
732: l_inc_old_index := 0;
733: l_top_old_index := 0;

Line 1044: OE_ORDER_SCH_UTIL.OESCH_ACT_UNDEMAND;

1040:
1041: -- Let us first unschedule the whole set
1042: FOR I IN 1..l_line_tbl.count LOOP
1043: l_line_tbl(I).schedule_action_code :=
1044: OE_ORDER_SCH_UTIL.OESCH_ACT_UNDEMAND;
1045: END LOOP;
1046:
1047: OE_GRP_SCH_UTIL.Process_set_of_lines
1048: ( p_old_line_tbl => l_old_line_tbl,

Line 1065: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;

1061:
1062: -- Let us now schedule the whole set
1063: FOR I IN 1..l_line_tbl.count LOOP
1064: l_line_tbl(I).schedule_action_code :=
1065: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
1066: END LOOP;
1067:
1068: OE_GRP_SCH_UTIL.Process_set_of_lines
1069: ( p_old_line_tbl => l_old_line_tbl,

Line 1225: oe_debug_pub.add( '56: ENTERING OE_ORDER_SCH_UTIL.SCHEDULE_LINE' , 1 ) ;

1221: BEGIN
1222:
1223:
1224: IF l_debug_level > 0 THEN
1225: oe_debug_pub.add( '56: ENTERING OE_ORDER_SCH_UTIL.SCHEDULE_LINE' , 1 ) ;
1226: oe_debug_pub.add( '---- OLD RECORD ---- ' , 1 ) ;
1227: oe_debug_pub.add( 'LINE ID : ' || P_OLD_LINE_REC.LINE_ID , 1 ) ;
1228: oe_debug_pub.add( 'ATO LINE ID : ' || P_OLD_LINE_REC.ATO_LINE_ID , 1 ) ;
1229: oe_debug_pub.add( 'ORDERED QUANTITY : ' || P_OLD_LINE_REC.ORDERED_QUANTITY , 1 ) ;

Line 1390: oe_debug_pub.add( 'CALLING OE_ORDER_SCH_UTIL.VALIDATE LINE' , 1 ) ;

1386: goto end_schedule_line;
1387: END IF;
1388:
1389: IF l_debug_level > 0 THEN
1390: oe_debug_pub.add( 'CALLING OE_ORDER_SCH_UTIL.VALIDATE LINE' , 1 ) ;
1391: END IF;
1392:
1393: Validate_Line(p_line_rec => l_line_rec,
1394: p_old_line_rec => l_old_line_rec,

Line 2042: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.SCHEDULE_LINE' , 1 ) ;

2038: oe_debug_pub.add( ' P_X_LINE_REC SCH STATUS :'|| L_NEW_LINE_TBL ( 1 ) .SCHEDULE_STATUS_CODE , 1 ) ;
2039: oe_debug_pub.add( ' P_X_LINE_REC RESERVED QTY : '|| L_NEW_LINE_TBL ( 1 ) .RESERVED_QUANTITY , 1 ) ;
2040: oe_debug_pub.add( 'AFTER PRINTING OUT NOCOPY RECORD: ' , 1 ) ;
2041: oe_debug_pub.add( ' ' , 1 ) ;
2042: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.SCHEDULE_LINE' , 1 ) ;
2043: END IF;
2044:
2045:
2046: EXCEPTION

Line 2154: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';

2150:
2151: l_control_rec.clear_api_cache := FALSE;
2152: l_control_rec.clear_api_requests := FALSE;
2153:
2154: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'N';
2155:
2156: IF l_debug_level > 0 THEN
2157: oe_debug_pub.add( 'CALLING PROCESS ORDER' , 1 ) ;
2158: END IF;

Line 2290: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

2286: END IF;
2287: RAISE FND_API.G_EXC_ERROR;
2288: END IF;
2289:
2290: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
2291:
2292: x_return_status := l_return_status;
2293:
2294: IF l_debug_level > 0 THEN

Line 2303: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

2299: -- resetting the flag to fix bug 2043973.
2300:
2301: WHEN FND_API.G_EXC_ERROR THEN
2302:
2303: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305:
2306: IF is_set_recursion = 'N' THEN
2307: oe_set_util.g_set_recursive_flag := FALSE;

Line 2312: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

2308: END IF;
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311:
2312: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
2313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2314:
2315: IF is_set_recursion = 'N' THEN
2316: oe_set_util.g_set_recursive_flag := FALSE;

Line 2321: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

2317: END IF;
2318:
2319: WHEN OTHERS THEN
2320:
2321: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
2322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2323:
2324: IF is_set_recursion = 'N' THEN
2325: oe_set_util.g_set_recursive_flag := FALSE;

Line 2784: oe_debug_pub.add( '..ENTERING OE_ORDER_SCH_UTIL.VALIDATE_LINE' , 6 ) ;

2780: --
2781: BEGIN
2782:
2783: IF l_debug_level > 0 THEN
2784: oe_debug_pub.add( '..ENTERING OE_ORDER_SCH_UTIL.VALIDATE_LINE' , 6 ) ;
2785: END IF;
2786:
2787: -- If the quantity on the line is missing or null and if
2788: -- the user is trying to performing scheduling, it is an error

Line 3208: oe_debug_pub.add( '..EXITING OE_ORDER_SCH_UTIL.VALIDATE_LINE WITH ' || L_RETURN_STATUS , 1 ) ;

3204:
3205: x_return_status := l_return_status;
3206:
3207: IF l_debug_level > 0 THEN
3208: oe_debug_pub.add( '..EXITING OE_ORDER_SCH_UTIL.VALIDATE_LINE WITH ' || L_RETURN_STATUS , 1 ) ;
3209: END IF;
3210: END Validate_Line;
3211:
3212: /*---------------------------------------------------------------------

Line 3331: FND_MESSAGE.SET_TOKEN('WHERE','OE_ORDER_SCH_UTIL');

3327: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3328: THEN
3329: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3330: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.Get_OPM_item_from_Apps');
3331: FND_MESSAGE.SET_TOKEN('WHERE','OE_ORDER_SCH_UTIL');
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334:
3335: get_process_query_quantities ( p_org_id => p_org_id,

Line 4182: oe_debug_pub.add( 'ENTERING OE_ORDER_SCH_UTIL.PROCESS_REQUEST' , 1 ) ;

4178: --
4179: BEGIN
4180:
4181: IF l_debug_level > 0 THEN
4182: oe_debug_pub.add( 'ENTERING OE_ORDER_SCH_UTIL.PROCESS_REQUEST' , 1 ) ;
4183: oe_debug_pub.add( 'OESCH_AUTO_SCH_FLAG : ' || OESCH_AUTO_SCH_FLAG , 1 ) ;
4184: END IF;
4185:
4186: l_line_rec := p_x_line_rec;

Line 5522: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.PROCESS_REQUEST: ' || X_RETURN_STATUS , 1 ) ;

5518: x_return_status := l_return_status;
5519: p_x_line_rec := l_out_line_rec;
5520: x_out_atp_tbl := l_out_atp_tbl;
5521: IF l_debug_level > 0 THEN
5522: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.PROCESS_REQUEST: ' || X_RETURN_STATUS , 1 ) ;
5523: END IF;
5524:
5525: END Process_request;
5526:

Line 5806: oe_debug_pub.add( '....ENTERING OE_ORDER_SCH_UTIL.LOAD_MRP_REQUEST' , 1 ) ;

5802: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5803: --
5804: BEGIN
5805: IF l_debug_level > 0 THEN
5806: oe_debug_pub.add( '....ENTERING OE_ORDER_SCH_UTIL.LOAD_MRP_REQUEST' , 1 ) ;
5807: oe_debug_pub.add( 'COUNT IS ' || P_LINE_TBL.COUNT , 1 ) ;
5808: oe_debug_pub.add( '------------------LOAD MRP TABLE---------------' , 1 ) ;
5809: END IF;
5810:

Line 6175: OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK)

6171:
6172: l_atp_rec.Message(I) := null;
6173:
6174: IF (l_line_rec.schedule_action_code =
6175: OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK)
6176: THEN
6177: l_atp_rec.Action(I) := 100;
6178: ELSIF (l_line_rec.schedule_action_code =
6179: OE_ORDER_SCH_UTIL.OESCH_ACT_DEMAND) OR

Line 6179: OE_ORDER_SCH_UTIL.OESCH_ACT_DEMAND) OR

6175: OE_ORDER_SCH_UTIL.OESCH_ACT_ATP_CHECK)
6176: THEN
6177: l_atp_rec.Action(I) := 100;
6178: ELSIF (l_line_rec.schedule_action_code =
6179: OE_ORDER_SCH_UTIL.OESCH_ACT_DEMAND) OR
6180: (l_line_rec.schedule_action_code =
6181: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE)
6182: THEN
6183: l_atp_rec.Action(I) := 110;

Line 6181: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE)

6177: l_atp_rec.Action(I) := 100;
6178: ELSIF (l_line_rec.schedule_action_code =
6179: OE_ORDER_SCH_UTIL.OESCH_ACT_DEMAND) OR
6180: (l_line_rec.schedule_action_code =
6181: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE)
6182: THEN
6183: l_atp_rec.Action(I) := 110;
6184: ELSIF (l_line_rec.schedule_action_code =
6185: OE_ORDER_SCH_UTIL.OESCH_ACT_REDEMAND) OR

Line 6185: OE_ORDER_SCH_UTIL.OESCH_ACT_REDEMAND) OR

6181: OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE)
6182: THEN
6183: l_atp_rec.Action(I) := 110;
6184: ELSIF (l_line_rec.schedule_action_code =
6185: OE_ORDER_SCH_UTIL.OESCH_ACT_REDEMAND) OR
6186: (l_line_rec.schedule_action_code =
6187: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE)
6188: THEN
6189: l_atp_rec.Action(I) := 120;

Line 6187: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE)

6183: l_atp_rec.Action(I) := 110;
6184: ELSIF (l_line_rec.schedule_action_code =
6185: OE_ORDER_SCH_UTIL.OESCH_ACT_REDEMAND) OR
6186: (l_line_rec.schedule_action_code =
6187: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE)
6188: THEN
6189: l_atp_rec.Action(I) := 120;
6190: l_atp_rec.Old_Source_Organization_Id(I) :=
6191: l_old_line_rec.ship_from_org_id;

Line 6195: OE_ORDER_SCH_UTIL.OESCH_ACT_UNDEMAND)

6191: l_old_line_rec.ship_from_org_id;
6192: l_atp_rec.Old_Demand_Class(I) :=
6193: l_old_line_rec.demand_class_code;
6194: ELSIF (l_line_rec.schedule_action_code =
6195: OE_ORDER_SCH_UTIL.OESCH_ACT_UNDEMAND)
6196: THEN
6197: l_atp_rec.Action(I) := 120;
6198: l_atp_rec.Quantity_Ordered(I) := 0;
6199: l_atp_rec.Old_Source_Organization_Id(I) :=

Line 6575: oe_debug_pub.add( '....EXITING OE_ORDER_SCH_UTIL.LOAD_REQUEST' , 1 ) ;

6571: END IF;
6572: x_atp_table := l_atp_rec;
6573:
6574: IF l_debug_level > 0 THEN
6575: oe_debug_pub.add( '....EXITING OE_ORDER_SCH_UTIL.LOAD_REQUEST' , 1 ) ;
6576: END IF;
6577: EXCEPTION
6578: WHEN OTHERS THEN
6579: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 8406: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;

8402:
8403: K := K +1;
8404: l_line_tbl(K) := l_local_line_tbl(L);
8405: l_line_tbl(K).schedule_action_code :=
8406: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;
8407:
8408: END LOOP;
8409:
8410: l_local_line_tbl.delete;

Line 8423: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;

8419:
8420: K := K +1;
8421: l_line_tbl(K) := l_local_line_tbl(L);
8422: l_line_tbl(K).schedule_action_code :=
8423: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;
8424:
8425: END LOOP;
8426:
8427: l_local_line_tbl.delete;

Line 8443: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;

8439:
8440: K := K +1;
8441: l_line_tbl(K) := l_local_line_tbl(L);
8442: l_line_tbl(K).schedule_action_code :=
8443: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;
8444: l_line_tbl(K).ship_set := p_x_line_tbl(I).top_model_line_id;
8445:
8446: END LOOP;
8447:

Line 8477: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;

8473:
8474: K := K +1;
8475: l_line_tbl(K) := l_local_line_tbl(L);
8476: l_line_tbl(K).schedule_action_code :=
8477: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;
8478: l_line_tbl(K).ship_set := l_ato_line_id;
8479:
8480:
8481: END LOOP;

Line 8491: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;

8487:
8488: K := K +1;
8489: l_line_tbl(K) := p_x_line_tbl(I);
8490: l_line_tbl(K).schedule_action_code :=
8491: OE_ORDER_SCH_UTIL.OESCH_ACT_RESCHEDULE;
8492:
8493:
8494: END IF;
8495:

Line 10090: oe_debug_pub.add( 'ENTERING OE_ORDER_SCH_UTIL.UPDATE_PO' , 2 ) ;

10086: --
10087: BEGIN
10088:
10089: IF l_debug_level > 0 THEN
10090: oe_debug_pub.add( 'ENTERING OE_ORDER_SCH_UTIL.UPDATE_PO' , 2 ) ;
10091: END IF;
10092:
10093: -- Call po if internal req and quantity is changed
10094:

Line 10112: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.UPDATE_PO' , 1 ) ;

10108: p_receipt_date => p_schedule_ship_date);
10109: END IF;
10110:
10111: IF l_debug_level > 0 THEN
10112: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.UPDATE_PO' , 1 ) ;
10113: END IF;
10114:
10115: EXCEPTION
10116: WHEN OTHERS THEN

Line 10133: oe_debug_pub.add( 'ENTERING OE_ORDER_SCH_UTIL.DELETE_ROW' , 1 ) ;

10129: --
10130: BEGIN
10131:
10132: IF l_debug_level > 0 THEN
10133: oe_debug_pub.add( 'ENTERING OE_ORDER_SCH_UTIL.DELETE_ROW' , 1 ) ;
10134: END IF;
10135: OE_Line_Util.Query_Row(p_line_id => p_line_id,
10136: x_line_rec => l_line_rec);
10137:

Line 10147: l_sales_order_id := OE_ORDER_SCH_UTIL.Get_mtl_sales_order_id

10143: shippable line */
10144:
10145: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
10146:
10147: l_sales_order_id := OE_ORDER_SCH_UTIL.Get_mtl_sales_order_id
10148: (l_line_rec.HEADER_ID);
10149:
10150: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
10151:

Line 10193: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.DELETE_ROW' , 1 ) ;

10189: END IF;
10190:
10191:
10192: IF l_debug_level > 0 THEN
10193: oe_debug_pub.add( 'EXITING OE_ORDER_SCH_UTIL.DELETE_ROW' , 1 ) ;
10194: END IF;
10195: EXCEPTION
10196:
10197: WHEN OTHERS THEN

Line 10405: END OE_ORDER_SCH_UTIL;

10401:
10402: END Post_Forms_Commit;
10403:
10404:
10405: END OE_ORDER_SCH_UTIL;