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_SCHEDULE_UTIL dependencies on FND_MESSAGE

Line 265: Fnd_Message.set_name('ONT','ONT_SCH_LAD_VIOLATE');

261: > p_latest_acceptable_date)) THEN
262: IF l_debug_level > 0 THEN
263: oe_debug_pub.add( 'LAD VIOLATED ' , 1 ) ;
264: END IF;
265: Fnd_Message.set_name('ONT','ONT_SCH_LAD_VIOLATE');
266: Oe_Msg_Pub.Add;
267: END IF;
268: /* -- 3349770 this will be only validated when user enters manually.
269: ELSIF l_lad_flag = 'H' THEN

Line 279: Fnd_Message.set_name('ONT','ONT_SCH_LAD_SCH_FAILED');

275: > p_latest_acceptable_date)) THEN
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'SCHEDULE DATE EXCEEDS LAD ' , 1 ) ;
278: END IF;
279: Fnd_Message.set_name('ONT','ONT_SCH_LAD_SCH_FAILED');
280: Oe_Msg_Pub.Add;
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283: */

Line 914: FND_MESSAGE.SET_NAME('ONT','OE_RSV_LINE_FULFILLED');

910: IF l_debug_level > 0 THEN
911: oe_debug_pub.add( 'LINE FULFILLED, CANNOT RESERVE LINE. FULFILLED QTY:' || p_line_rec.fulfilled_quantity , 1 ) ;
912: END IF;
913:
914: FND_MESSAGE.SET_NAME('ONT','OE_RSV_LINE_FULFILLED');
915: OE_MSG_PUB.Add;
916:
917: RAISE FND_API.G_EXC_ERROR;
918:

Line 941: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_WHSE');

937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_WHSE');
942: OE_MSG_PUB.Add;
943: END;
944:
945: IF l_revision_code = 2

Line 949: FND_MESSAGE.SET_NAME('ONT', 'OE_SUBINV_NOT_ALLOWED');

945: IF l_revision_code = 2
946: OR l_lot_code = 2
947: THEN
948: -- 2 == YES
949: FND_MESSAGE.SET_NAME('ONT', 'OE_SUBINV_NOT_ALLOWED');
950: OE_MSG_PUB.Add;
951: IF p_line_rec.Schedule_action_code = OESCH_ACT_RESERVE THEN
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: RAISE FND_API.G_EXC_ERROR;

Line 3261: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');

3257: G_GOP_AUTO_SPLIT := FALSE;
3258: G_GOP_AUTO_SPLIT_LINE_ID := 0;
3259: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; --REMOVE
3260: /*
3261: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
3262: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
3263: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
3264: OE_MSG_PUB.Add;
3265: */

Line 3262: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);

3258: G_GOP_AUTO_SPLIT_LINE_ID := 0;
3259: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; --REMOVE
3260: /*
3261: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
3262: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
3263: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
3264: OE_MSG_PUB.Add;
3265: */
3266: p_split_line_rec := l_split_line_tbl(1);

Line 3263: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));

3259: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N'; --REMOVE
3260: /*
3261: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
3262: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
3263: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
3264: OE_MSG_PUB.Add;
3265: */
3266: p_split_line_rec := l_split_line_tbl(1);
3267:

Line 4792: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');

4788: IF l_debug_level > 0 THEN
4789: oe_debug_pub.add( 'MRP HAS RETURNED ANY DATA' , 1 ) ;
4790: END IF;
4791:
4792: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
4793: OE_MSG_PUB.Add;
4794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4795:
4796: END IF;

Line 5001: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');

4997: oe_debug_pub.add( 'ERROR FROM MRP: ' || P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;
4998: END IF;
4999: IF p_atp_rec.error_code(J) = 80 THEN
5000:
5001: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
5002: OE_MSG_PUB.Add;
5003:
5004: ELSE
5005:

Line 5070: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_FAILED_WITH_DATE');

5066: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
5067: END IF;
5068: -- 4558018
5069: IF p_atp_rec.Ship_Date(J) IS NOT NULL THEN
5070: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_FAILED_WITH_DATE');
5071: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5072: FND_MESSAGE.SET_TOKEN('NEXT_DATE',p_atp_rec.Ship_Date(J));
5073:
5074: ELSE

Line 5071: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);

5067: END IF;
5068: -- 4558018
5069: IF p_atp_rec.Ship_Date(J) IS NOT NULL THEN
5070: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_FAILED_WITH_DATE');
5071: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5072: FND_MESSAGE.SET_TOKEN('NEXT_DATE',p_atp_rec.Ship_Date(J));
5073:
5074: ELSE
5075: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');

Line 5072: FND_MESSAGE.SET_TOKEN('NEXT_DATE',p_atp_rec.Ship_Date(J));

5068: -- 4558018
5069: IF p_atp_rec.Ship_Date(J) IS NOT NULL THEN
5070: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_FAILED_WITH_DATE');
5071: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5072: FND_MESSAGE.SET_TOKEN('NEXT_DATE',p_atp_rec.Ship_Date(J));
5073:
5074: ELSE
5075: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
5076: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);

Line 5075: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');

5071: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5072: FND_MESSAGE.SET_TOKEN('NEXT_DATE',p_atp_rec.Ship_Date(J));
5073:
5074: ELSE
5075: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
5076: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5077: END IF;
5078: OE_MSG_PUB.Add;
5079: END IF;

Line 5076: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);

5072: FND_MESSAGE.SET_TOKEN('NEXT_DATE',p_atp_rec.Ship_Date(J));
5073:
5074: ELSE
5075: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
5076: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5077: END IF;
5078: OE_MSG_PUB.Add;
5079: END IF;
5080: END IF; -- 80

Line 5403: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');

5399: IF l_debug_level > 0 THEN
5400: oe_debug_pub.add( 'NEW INVENTORY ITEM :' || P_ATP_REC.INVENTORY_ITEM_ID ( J ) , 1 ) ;
5401: END IF;
5402:
5403: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
5404: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
5405: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
5406: OE_MSG_PUB.Add;
5407:

Line 5404: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);

5400: oe_debug_pub.add( 'NEW INVENTORY ITEM :' || P_ATP_REC.INVENTORY_ITEM_ID ( J ) , 1 ) ;
5401: END IF;
5402:
5403: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
5404: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
5405: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
5406: OE_MSG_PUB.Add;
5407:
5408: -- Added below call for ER 6110708

Line 5405: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));

5401: END IF;
5402:
5403: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
5404: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
5405: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
5406: OE_MSG_PUB.Add;
5407:
5408: -- Added below call for ER 6110708
5409: IF nvl(p_x_line_rec.booked_flag, 'N') = 'Y' THEN

Line 5580: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');

5576: p_x_line_rec.schedule_ship_date , 2 ) ;
5577: oe_debug_pub.add( 'SCH: Schedule Arr Date' ||
5578: p_x_line_rec.schedule_arrival_date , 2 ) ;
5579: END IF;
5580: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
5581: OE_MSG_PUB.Add;
5582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5583: END IF;
5584:

Line 5617: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');

5613: oe_debug_pub.add( 'RSCH: ITEM HAS BEEN SUBSTITUTED' , 1 ) ;
5614: oe_debug_pub.add( 'RSCH NEW INVENTORY ITEM :' || P_ATP_REC.INVENTORY_ITEM_ID ( J ) , 1 ) ;
5615: END IF;
5616:
5617: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
5618: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
5619: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
5620: OE_MSG_PUB.Add;
5621:

Line 5618: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);

5614: oe_debug_pub.add( 'RSCH NEW INVENTORY ITEM :' || P_ATP_REC.INVENTORY_ITEM_ID ( J ) , 1 ) ;
5615: END IF;
5616:
5617: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
5618: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
5619: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
5620: OE_MSG_PUB.Add;
5621:
5622: -- Added below call for ER 6110708

Line 5619: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));

5615: END IF;
5616:
5617: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
5618: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
5619: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
5620: OE_MSG_PUB.Add;
5621:
5622: -- Added below call for ER 6110708
5623: IF nvl(p_x_line_rec.booked_flag, 'N') = 'Y' THEN

Line 5821: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');

5817:
5818: IF l_debug_level > 0 THEN
5819: oe_debug_pub.add( 'RSCH: MRP HAS NOT RETURNING VALID DATE' , 2 ) ;
5820: END IF;
5821: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
5822: OE_MSG_PUB.Add;
5823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5824: END IF;
5825:

Line 6240: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');

6236: oe_debug_pub.add( 'Before setting message for: ' || P_ATP_REC.ERROR_CODE(J) , 2 ) ;
6237: END IF;
6238:
6239: l_old_set_id := l_new_set_id;
6240: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
6241: OE_MSG_PUB.Add;
6242:
6243:
6244: END IF;

Line 6488: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');

6484: ,p_source_document_type_id => l_source_document_type_id);
6485:
6486: IF p_atp_rec.error_code(J) = 80 THEN
6487:
6488: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
6489: OE_MSG_PUB.Add;
6490: l_explanation := null;
6491:
6492: ELSIF p_atp_rec.error_code(J) <> 0 THEN

Line 6503: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');

6499:
6500: IF l_debug_level > 0 THEN
6501: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
6502: END IF;
6503: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
6504: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
6505: OE_MSG_PUB.Add;
6506:
6507: ELSE

Line 6504: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);

6500: IF l_debug_level > 0 THEN
6501: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
6502: END IF;
6503: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
6504: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
6505: OE_MSG_PUB.Add;
6506:
6507: ELSE
6508:

Line 6509: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');

6505: OE_MSG_PUB.Add;
6506:
6507: ELSE
6508:
6509: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
6510: OE_MSG_PUB.Add;
6511: END IF;
6512:
6513:

Line 6531: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');

6527: oe_debug_pub.add( 'Before setting message for: ' || P_ATP_REC.ERROR_CODE ( J ) , 2 ) ;
6528: END IF;
6529:
6530: l_old_set_id := l_new_set_id;
6531: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
6532: OE_MSG_PUB.Add;
6533:
6534: ELSIF p_atp_rec.error_code(J) <> 0
6535: AND p_atp_rec.error_code(J) <> 19 THEN

Line 6558: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');

6554: ,p_source_document_line_id => p_line_tbl(I).source_document_line_id);
6555:
6556: IF p_atp_rec.error_code(J) = 80 THEN
6557:
6558: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
6559: OE_MSG_PUB.Add;
6560: l_explanation := null;
6561:
6562: ELSE

Line 6572: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');

6568:
6569: IF l_debug_level > 0 THEN
6570: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
6571: END IF;
6572: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
6573: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
6574: OE_MSG_PUB.Add;
6575:
6576:

Line 6573: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);

6569: IF l_debug_level > 0 THEN
6570: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
6571: END IF;
6572: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
6573: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
6574: OE_MSG_PUB.Add;
6575:
6576:
6577: END IF;

Line 6893: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

6889: , x_msg_data => l_msg_data);
6890:
6891: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
6892: THEN
6893: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
6894: FND_MESSAGE.SET_TOKEN('BY_PROC',
6895: 'GMI_Reservation_Util.Get_OPM_item_from_Apps');
6896: FND_MESSAGE.SET_TOKEN('WHERE','OE_SCHEDULE_UTIL');
6897: RAISE FND_API.G_EXC_ERROR;

Line 6894: FND_MESSAGE.SET_TOKEN('BY_PROC',

6890:
6891: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
6892: THEN
6893: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
6894: FND_MESSAGE.SET_TOKEN('BY_PROC',
6895: 'GMI_Reservation_Util.Get_OPM_item_from_Apps');
6896: FND_MESSAGE.SET_TOKEN('WHERE','OE_SCHEDULE_UTIL');
6897: RAISE FND_API.G_EXC_ERROR;
6898: END IF;

Line 6896: FND_MESSAGE.SET_TOKEN('WHERE','OE_SCHEDULE_UTIL');

6892: THEN
6893: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
6894: FND_MESSAGE.SET_TOKEN('BY_PROC',
6895: 'GMI_Reservation_Util.Get_OPM_item_from_Apps');
6896: FND_MESSAGE.SET_TOKEN('WHERE','OE_SCHEDULE_UTIL');
6897: RAISE FND_API.G_EXC_ERROR;
6898: END IF;
6899: get_process_query_quantities ( p_org_id => p_org_id,
6900: p_item_id => l_ic_item_mst_rec.item_id,

Line 7647: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV

7643: END IF;
7644:
7645: IF l_qty2_to_reserve = -99999 THEN
7646: -- conversion failed
7647: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
7648: OE_MSG_PUB.ADD;
7649: IF l_debug_level > 0 THEN
7650: oe_debug_pub.add( 'ERROR on UOM conversion to Secondary UOM which is '||p_x_line_rec.ordered_quantity_uom2 , 1 ) ;
7651: END IF;

Line 8539: fnd_message.set_encoded(l_msg_data);

8535: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8538: IF l_msg_data is not null THEN
8539: fnd_message.set_encoded(l_msg_data);
8540: l_buffer := fnd_message.get;
8541: oe_msg_pub.add_text(p_message_text => l_buffer);
8542: IF l_debug_level > 0 THEN
8543: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;

Line 8540: l_buffer := fnd_message.get;

8536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8537: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
8538: IF l_msg_data is not null THEN
8539: fnd_message.set_encoded(l_msg_data);
8540: l_buffer := fnd_message.get;
8541: oe_msg_pub.add_text(p_message_text => l_buffer);
8542: IF l_debug_level > 0 THEN
8543: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;
8544: END IF;

Line 8832: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV

8828: END IF;
8829:
8830: IF l_qty2_to_reserve = -99999 THEN
8831: -- conversion failed
8832: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
8833: OE_MSG_PUB.ADD;
8834: IF l_debug_level > 0 THEN
8835: oe_debug_pub.add( 'ERROR on UOM conversion to Secondary UOM which is '||p_x_line_rec.ordered_quantity_uom2 , 1 ) ;
8836: END IF;

Line 9247: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');

9243: oe_debug_pub.add( 'UPDATE SHIP DATE , EXTERNAL '|| P_X_LINE_REC.LINE_ID , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
9244: END IF;
9245:
9246: IF p_x_line_rec.ship_from_org_id is NULL THEN
9247: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
9248: OE_MSG_PUB.Add;
9249: RAISE FND_API.G_EXC_ERROR;
9250: END IF;
9251:

Line 10325: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');

10321: THEN
10322: IF l_debug_level > 0 THEN
10323: oe_debug_pub.add( 'INVALID SCH ACTION ' , 1 ) ;
10324: END IF;
10325: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
10326: OE_MSG_PUB.Add;
10327: RETURN FALSE;
10328: END IF;
10329:

Line 10901: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');

10897: p_old_line_rec.ordered_quantity = FND_API.G_MISS_NUM) AND
10898: (p_line_rec.ordered_quantity is null OR
10899: p_line_rec.ordered_quantity = FND_API.G_MISS_NUM)) THEN
10900:
10901: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');
10902: OE_MSG_PUB.Add;
10903: IF l_debug_level > 0 THEN
10904: oe_debug_pub.add( 'E1' , 1 ) ;
10905: END IF;

Line 10922: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');

10918:
10919: IF p_sch_action is not null
10920: AND p_caller = SCH_INTERNAL THEN
10921:
10922: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');
10923: OE_MSG_PUB.Add;
10924:
10925: IF l_debug_level > 0 THEN
10926: oe_debug_pub.add( 'E2' , 1 ) ;

Line 10947: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_FULLY_CANCELLED');

10943:
10944: -- The line is cancelled. Cannot perform scheduling
10945: -- on it.
10946:
10947: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_FULLY_CANCELLED');
10948: OE_MSG_PUB.Add;
10949:
10950: IF l_debug_level > 0 THEN
10951: oe_debug_pub.add( 'E3' , 1 ) ;

Line 10971: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_SHIPPED');

10967:
10968: -- The line is cancelled. Cannot perform scheduling
10969: -- on it.
10970:
10971: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_SHIPPED');
10972: OE_MSG_PUB.Add;
10973:
10974: IF l_debug_level > 0 THEN
10975: oe_debug_pub.add( 'E4' , 1 ) ;

Line 10994: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_FULFILLED');

10990:
10991: -- The line is Fulfilled. Cannot perform scheduling
10992: -- on it.
10993:
10994: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_FULFILLED');
10995: OE_MSG_PUB.Add;
10996:
10997: IF l_debug_level > 0 THEN
10998: oe_debug_pub.add( 'E4.1' , 1 ) ;

Line 11019: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');

11015: IF (p_line_rec.ordered_quantity < p_line_rec.reserved_quantity)
11016: AND OE_GLOBALS.Equal(p_old_line_rec.order_quantity_uom, p_line_rec.order_quantity_uom) --Bug 6335352
11017: THEN
11018:
11019: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
11020: OE_MSG_PUB.Add;
11021:
11022: IF l_debug_level > 0 THEN
11023: oe_debug_pub.add( 'E5' , 1 ) ;

Line 11034: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');

11030: IF (p_sch_action = OESCH_ACT_UNSCHEDULE OR
11031: p_sch_action = OESCH_ACT_UNRESERVE) AND
11032: (p_line_rec.reserved_quantity is not null) THEN
11033:
11034: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
11035: OE_MSG_PUB.Add;
11036: x_return_status := FND_API.G_RET_STS_ERROR;
11037: IF l_debug_level > 0 THEN
11038: oe_debug_pub.add( 'E6' , 1 ) ;

Line 11050: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');

11046: -- Reserved Quantity2 has changed
11047: IF (p_line_rec.ordered_quantity2 < p_line_rec.reserved_quantity2)
11048: THEN
11049:
11050: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
11051: OE_MSG_PUB.Add;
11052:
11053: IF l_debug_level > 0 THEN
11054: oe_debug_pub.add( 'E5a' , 1 ) ;

Line 11065: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');

11061: IF (p_sch_action = OESCH_ACT_UNSCHEDULE OR
11062: p_sch_action = OESCH_ACT_UNRESERVE) AND
11063: (p_line_rec.reserved_quantity2 is not null) THEN
11064:
11065: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
11066: OE_MSG_PUB.Add;
11067: x_return_status := FND_API.G_RET_STS_ERROR;
11068: IF l_debug_level > 0 THEN
11069: oe_debug_pub.add( 'E6A' , 1 ) ;

Line 11091: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');

11087: THEN
11088: IF (p_line_rec.ordered_quantity < p_line_rec.reserved_quantity)
11089: THEN
11090:
11091: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
11092: OE_MSG_PUB.Add;
11093:
11094: x_return_status := FND_API.G_RET_STS_ERROR;
11095: IF l_debug_level > 0 THEN

Line 11112: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');

11108: THEN
11109: IF (p_line_rec.ordered_quantity2 < p_line_rec.reserved_quantity2)
11110: THEN
11111:
11112: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
11113: OE_MSG_PUB.Add;
11114:
11115: x_return_status := FND_API.G_RET_STS_ERROR;
11116: IF l_debug_level > 0 THEN

Line 11131: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');

11127:
11128: IF (p_line_rec.order_quantity_uom is null OR
11129: p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR) THEN
11130:
11131: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');
11132: OE_MSG_PUB.Add;
11133:
11134: x_return_status := FND_API.G_RET_STS_ERROR;
11135: IF l_debug_level > 0 THEN

Line 11150: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_ITEM');

11146:
11147: IF (p_line_rec.inventory_item_id is null OR
11148: p_line_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
11149:
11150: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_ITEM');
11151: OE_MSG_PUB.Add;
11152:
11153: IF l_debug_level > 0 THEN
11154: oe_debug_pub.add( 'E9' , 1 ) ;

Line 11169: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');

11165: END IF;
11166: IF (p_line_rec.request_date is null OR
11167: p_line_rec.request_date = FND_API.G_MISS_DATE) THEN
11168:
11169: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
11170: OE_MSG_PUB.Add;
11171: IF l_debug_level > 0 THEN
11172: oe_debug_pub.add( 'E10' , 1 ) ;
11173: END IF;

Line 11186: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_BYPASS_MISS_WSH');

11182: oe_debug_pub.add( 'CHECKING THAT LINE HAS A WAREHOUSE...' , 1 ) ;
11183: END IF;
11184: IF (p_line_rec.ship_from_org_id is null OR
11185: p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
11186: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_BYPASS_MISS_WSH');
11187: OE_MSG_PUB.Add;
11188:
11189: IF l_debug_level > 0 THEN
11190: oe_debug_pub.add( 'ERROR BYPASS' , 1 ) ;

Line 11208: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');

11204: (p_sch_action = OESCH_ACT_UNDEMAND OR
11205: p_sch_action = OESCH_ACT_UNSCHEDULE)
11206: THEN
11207:
11208: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');
11209: OE_MSG_PUB.Add;
11210: IF l_debug_level > 0 THEN
11211: oe_debug_pub.add( 'E11' , 1 ) ;
11212: END IF;

Line 11272: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');

11268: END IF;
11269: END IF;
11270:
11271: IF (l_result = FND_API.G_TRUE) THEN
11272: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
11273: OE_MSG_PUB.Add;
11274: x_return_status := FND_API.G_RET_STS_ERROR;
11275: END IF;
11276: END IF;

Line 11308: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INACTIVE_MISS_WSH');

11304: oe_debug_pub.add( 'CHECKING THAT LINE HAS A WAREHOUSE...' , 1 ) ;
11305: END IF;
11306: IF (p_line_rec.ship_from_org_id is null OR
11307: p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
11308: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INACTIVE_MISS_WSH');
11309: FND_MESSAGE.SET_TOKEN('LTYPE',
11310: nvl(sch_cached_line_type,'0'));
11311: OE_MSG_PUB.Add;
11312:

Line 11309: FND_MESSAGE.SET_TOKEN('LTYPE',

11305: END IF;
11306: IF (p_line_rec.ship_from_org_id is null OR
11307: p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
11308: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INACTIVE_MISS_WSH');
11309: FND_MESSAGE.SET_TOKEN('LTYPE',
11310: nvl(sch_cached_line_type,'0'));
11311: OE_MSG_PUB.Add;
11312:
11313: IF l_debug_level > 0 THEN

Line 11327: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');

11323: END IF;
11324: IF (p_line_rec.item_type_code <> 'STANDARD'
11325: OR p_line_rec.ato_line_id is not null) THEN
11326:
11327: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
11328: FND_MESSAGE.SET_TOKEN('LTYPE',
11329: nvl(sch_cached_line_type,'0'));
11330: OE_MSG_PUB.Add;
11331:

Line 11328: FND_MESSAGE.SET_TOKEN('LTYPE',

11324: IF (p_line_rec.item_type_code <> 'STANDARD'
11325: OR p_line_rec.ato_line_id is not null) THEN
11326:
11327: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
11328: FND_MESSAGE.SET_TOKEN('LTYPE',
11329: nvl(sch_cached_line_type,'0'));
11330: OE_MSG_PUB.Add;
11331:
11332: IF l_debug_level > 0 THEN

Line 11348: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');

11344: -- We will now allow standard lines into sets.
11345: IF (p_line_rec.ship_set_id is not null OR
11346: P_line_rec.arrival_set_id is not null)THEN
11347:
11348: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
11349: FND_MESSAGE.SET_TOKEN('LTYPE',
11350: nvl(sch_cached_line_type,'0'));
11351: OE_MSG_PUB.Add;
11352:

Line 11349: FND_MESSAGE.SET_TOKEN('LTYPE',

11345: IF (p_line_rec.ship_set_id is not null OR
11346: P_line_rec.arrival_set_id is not null)THEN
11347:
11348: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
11349: FND_MESSAGE.SET_TOKEN('LTYPE',
11350: nvl(sch_cached_line_type,'0'));
11351: OE_MSG_PUB.Add;
11352:
11353: IF l_debug_level > 0 THEN

Line 11375: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');

11371: (p_line_rec.schedule_ship_date is NOT NULL OR
11372: p_line_rec.schedule_arrival_date is NOT NULL))
11373: THEN
11374:
11375: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
11376: FND_MESSAGE.SET_TOKEN('ACTION',
11377: nvl(p_sch_action,OESCH_ACT_SCHEDULE));
11378: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11379: nvl(sch_cached_line_type,sch_cached_order_type));

Line 11376: FND_MESSAGE.SET_TOKEN('ACTION',

11372: p_line_rec.schedule_arrival_date is NOT NULL))
11373: THEN
11374:
11375: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
11376: FND_MESSAGE.SET_TOKEN('ACTION',
11377: nvl(p_sch_action,OESCH_ACT_SCHEDULE));
11378: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11379: nvl(sch_cached_line_type,sch_cached_order_type));
11380: OE_MSG_PUB.Add;

Line 11378: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

11374:
11375: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
11376: FND_MESSAGE.SET_TOKEN('ACTION',
11377: nvl(p_sch_action,OESCH_ACT_SCHEDULE));
11378: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11379: nvl(sch_cached_line_type,sch_cached_order_type));
11380: OE_MSG_PUB.Add;
11381: IF l_debug_level > 0 THEN
11382: oe_debug_pub.add( 'E12' , 1 ) ;

Line 11397: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');

11393: -- 2766876
11394: IF (NVL(p_line_rec.reserved_quantity,0) > 0
11395: AND p_sch_action = OESCH_ACT_SCHEDULE)
11396: OR p_sch_action = OESCH_ACT_RESERVE THEN
11397: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
11398: FND_MESSAGE.SET_TOKEN('ACTION',
11399: nvl(p_sch_action,OESCH_ACT_RESERVE));
11400: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11401: nvl(sch_cached_line_type,sch_cached_order_type));

Line 11398: FND_MESSAGE.SET_TOKEN('ACTION',

11394: IF (NVL(p_line_rec.reserved_quantity,0) > 0
11395: AND p_sch_action = OESCH_ACT_SCHEDULE)
11396: OR p_sch_action = OESCH_ACT_RESERVE THEN
11397: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
11398: FND_MESSAGE.SET_TOKEN('ACTION',
11399: nvl(p_sch_action,OESCH_ACT_RESERVE));
11400: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11401: nvl(sch_cached_line_type,sch_cached_order_type));
11402: OE_MSG_PUB.Add;

Line 11400: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

11396: OR p_sch_action = OESCH_ACT_RESERVE THEN
11397: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
11398: FND_MESSAGE.SET_TOKEN('ACTION',
11399: nvl(p_sch_action,OESCH_ACT_RESERVE));
11400: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11401: nvl(sch_cached_line_type,sch_cached_order_type));
11402: OE_MSG_PUB.Add;
11403: IF l_debug_level > 0 THEN
11404: oe_debug_pub.add( 'E13' , 1 ) ;

Line 11418: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_ACTION_NOT_ALLOWED');

11414: Nvl(p_line_rec.bypass_sch_flag, 'N') = 'Y' -- DOO Integration.
11415: THEN
11416: IF p_sch_action = OESCH_ACT_ATP_CHECK THEN
11417: -- levels Four and Five CANNOT have ATP Performed
11418: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_ACTION_NOT_ALLOWED');
11419: FND_MESSAGE.SET_TOKEN('ACTION',
11420: (nvl(p_sch_action, OESCH_ACT_ATP_CHECK)));
11421: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11422: nvl(sch_cached_line_type,sch_cached_order_type));

Line 11419: FND_MESSAGE.SET_TOKEN('ACTION',

11415: THEN
11416: IF p_sch_action = OESCH_ACT_ATP_CHECK THEN
11417: -- levels Four and Five CANNOT have ATP Performed
11418: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_ACTION_NOT_ALLOWED');
11419: FND_MESSAGE.SET_TOKEN('ACTION',
11420: (nvl(p_sch_action, OESCH_ACT_ATP_CHECK)));
11421: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11422: nvl(sch_cached_line_type,sch_cached_order_type));
11423: OE_MSG_PUB.Add;

Line 11421: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',

11417: -- levels Four and Five CANNOT have ATP Performed
11418: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_ACTION_NOT_ALLOWED');
11419: FND_MESSAGE.SET_TOKEN('ACTION',
11420: (nvl(p_sch_action, OESCH_ACT_ATP_CHECK)));
11421: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
11422: nvl(sch_cached_line_type,sch_cached_order_type));
11423: OE_MSG_PUB.Add;
11424: IF l_debug_level > 0 THEN
11425: oe_debug_pub.add('p_line_rec.bypass_sch_flag: ' ||

Line 11449: Fnd_Message.Set_Name('ONT', 'OE_SCH_OE_ORDER_FAILED');

11445: FROM oe_lookups
11446: WHERE lookup_type = 'SCH_FAIL_REASONS'
11447: AND lookup_code = 'EXT_SCH_DOO';
11448:
11449: Fnd_Message.Set_Name('ONT', 'OE_SCH_OE_ORDER_FAILED');
11450: Fnd_Message.Set_Token('EXPLANATION', l_explanation);
11451: Oe_Msg_Pub.ADD;
11452:
11453: l_explanation := NULL;

Line 11450: Fnd_Message.Set_Token('EXPLANATION', l_explanation);

11446: WHERE lookup_type = 'SCH_FAIL_REASONS'
11447: AND lookup_code = 'EXT_SCH_DOO';
11448:
11449: Fnd_Message.Set_Name('ONT', 'OE_SCH_OE_ORDER_FAILED');
11450: Fnd_Message.Set_Token('EXPLANATION', l_explanation);
11451: Oe_Msg_Pub.ADD;
11452:
11453: l_explanation := NULL;
11454: EXCEPTION

Line 11494: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');

11490: -- Reservation qty cannot be reduced when line is
11491: -- interfaced to wsh. Give a message here tell the user we are
11492: -- not unreserving. Added code here to fix bug 2038201.
11493:
11494: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
11495: OE_MSG_PUB.Add;
11496: IF l_debug_level > 0 THEN
11497: oe_debug_pub.add( 'E14' , 1 ) ;
11498: END IF;

Line 11524: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');

11520: IF p_line_rec.ship_from_org_id is NULL AND
11521: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
11522: THEN
11523:
11524: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
11525: OE_MSG_PUB.Add;
11526: IF l_debug_level > 0 THEN
11527: oe_debug_pub.add( 'E15' , 1 ) ;
11528: END IF;

Line 11538: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');

11534: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
11535: AND p_line_rec.schedule_status_code is null
11536: THEN
11537:
11538: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
11539: OE_MSG_PUB.Add;
11540: IF l_debug_level > 0 THEN
11541: oe_debug_pub.add( 'E16' , 1 ) ;
11542: END IF;

Line 11557: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');

11553: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
11554: AND p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
11555: AND p_line_rec.booked_flag <> 'Y'
11556: THEN
11557: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
11558: OE_MSG_PUB.Add;
11559: IF l_debug_level > 0 THEN
11560: oe_debug_pub.add( 'E16.0' , 1 );
11561: END IF;

Line 11571: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');

11567: AND ( p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_RESERVE
11568: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
11569: AND p_line_rec.schedule_status_code IS NULL
11570: THEN
11571: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');
11572: OE_MSG_PUB.Add;
11573: IF l_debug_level > 0 THEN
11574: oe_debug_pub.add( 'E16.1' , 1 ) ;
11575: END IF;

Line 11626: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');

11622: END IF;
11623: IF l_debug_level > 0 THEN
11624: oe_debug_pub.add( 'E17' , 1 ) ;
11625: END IF;
11626: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');
11627: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item);
11628:
11629: -- Bug 2367743 Start
11630: Select ORGANIZATION_CODE

Line 11627: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item);

11623: IF l_debug_level > 0 THEN
11624: oe_debug_pub.add( 'E17' , 1 ) ;
11625: END IF;
11626: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');
11627: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item);
11628:
11629: -- Bug 2367743 Start
11630: Select ORGANIZATION_CODE
11631: Into l_org_code

Line 11637: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);

11633: Where ORGANIZATION_ID = NVL(p_line_rec.ship_from_org_id,l_org_id);
11634: IF l_debug_level > 0 THEN
11635: oe_debug_pub.add( 'ORGANIZATION CODE:'||L_ORG_CODE , 2 ) ;
11636: END IF;
11637: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
11638: -- Bug 2367743 End
11639:
11640: OE_MSG_PUB.Add;
11641: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11660: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');

11656: THEN
11657:
11658: -- Added code here to fix bug 2038201.
11659: oe_debug_pub.add('E18',1);
11660: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
11661: OE_MSG_PUB.Add;
11662: x_return_status := FND_API.G_RET_STS_ERROR;
11663:
11664: END IF;

Line 11691: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');

11687:
11688: IF l_debug_level > 0 THEN
11689: oe_debug_pub.add( 'E19' , 1 ) ;
11690: END IF;
11691: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');
11692: OE_MSG_PUB.Add;
11693: x_return_status := FND_API.G_RET_STS_ERROR;
11694:
11695: EXCEPTION

Line 11702: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');

11698: WHEN TOO_MANY_ROWS THEN
11699: IF l_debug_level > 0 THEN
11700: oe_debug_pub.add( 'E19 TOO MANY ROWS' , 1 ) ;
11701: END IF;
11702: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');
11703: OE_MSG_PUB.Add;
11704: x_return_status := FND_API.G_RET_STS_ERROR;
11705:
11706: END;

Line 11726: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');

11722: l_order_date_type_code := Get_Date_Type(p_line_rec.header_id);
11723:
11724: IF nvl(l_order_date_type_code,'SHIP') = 'ARRIVAL' THEN
11725:
11726: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');
11727: OE_MSG_PUB.Add;
11728:
11729: OE_DEBUG_PUB.Add('E20 Order date Type - Arrival');
11730: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11750: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');

11746: l_order_date_type_code := Get_Date_Type(p_line_rec.header_id);
11747:
11748: IF nvl(l_order_date_type_code,'SHIP') = 'SHIP' THEN
11749:
11750: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');
11751: OE_MSG_PUB.Add;
11752:
11753: OE_DEBUG_PUB.Add('E21 Order date Type - Ship');
11754:

Line 11778: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH');

11774: THEN
11775:
11776: -- only authorized users have authority to update the
11777: -- Overide ATP Field
11778: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH');
11779: OE_MSG_PUB.Add;
11780: IF l_debug_level > 0 THEN
11781: oe_debug_pub.add( 'E22 INVALID AUTOTIZE' ) ;
11782: END IF;

Line 11802: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_MOD');

11798: THEN
11799:
11800: -- only authorized users have authority to update scheduling attributes
11801: -- on an overridden line
11802: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_MOD');
11803: OE_MSG_PUB.Add;
11804: IF l_debug_level > 0 THEN
11805: oe_debug_pub.add( 'E23 USER DOES NOT HAVE AUTHORITY TO UPDATE SCHEDULE ATTRIBUTES' , 1 ) ;
11806: END IF;

Line 11815: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_NO_AUTH_UNCHK');

11811: IF NVL(p_line_rec.override_atp_date_code, 'N') = 'Y' AND
11812: (p_sch_action = OESCH_ACT_UNDEMAND OR
11813: P_sch_action = OESCH_ACT_UNSCHEDULE) THEN
11814: -- Only Authorized users have authority to unschedule an overriddenline
11815: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_NO_AUTH_UNCHK');
11816: OE_MSG_PUB.Add;
11817: IF l_debug_level > 0 THEN
11818: oe_debug_pub.add( 'E24 GENERAL USER CANNOT UNSCHEDULE AN OVERRIDDEN LINE' , 1 ) ;
11819: END IF;

Line 11841: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_MOD');

11837: WHEN OTHERS THEN
11838: NULL;
11839: END;
11840: IF l_found = 'Y' THEN
11841: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_MOD');
11842: OE_MSG_PUB.Add;
11843: X_return_status := FND_API.G_RET_STS_ERROR;
11844: END IF;
11845: END IF;

Line 11871: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');

11867: IF l_override > 0 THEN
11868:
11869: -- only authorized users have authority to update scheduling
11870: -- attributes in a set with an overridden line
11871: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
11872: OE_MSG_PUB.Add;
11873: IF l_debug_level > 0 THEN
11874: oe_debug_pub.add( 'E25 USER DOES NOT HAVE AUTHORITY TO UPDATE SCHEDULE ATTRIBUTES ON A SET WITH AN OVERRIDDEN LINE' , 1 ) ;
11875: END IF;

Line 11913: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');

11909: -- lines can be scheduled for the schedule ship date of the set AND
11910: -- Authorized users cannot add an overridden line if the schedule
11911: -- ship date soes not match the set
11912:
11913: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
11914: OE_MSG_PUB.Add;
11915: IF l_debug_level > 0 THEN
11916: oe_debug_pub.add( 'E26 UNABLE TO ADD THE LINE TO THE SET' , 1 ) ;
11917: END IF;

Line 11960: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');

11956: END IF; -- ship from
11957: IF l_overridden = 'Y' THEN
11958: --3517527 set_status check commented
11959: -- IF l_set_rec.set_status <> 'T' THEN
11960: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
11961: OE_MSG_PUB.Add;
11962: -- END IF;
11963: IF l_debug_level > 0 THEN
11964: oe_debug_pub.add( 'E27 UNABLE TO ADD THE line TO THE SET' , 1 ) ;

Line 11982: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');

11978: IF NOT Valid_Set_Addition
11979: (p_top_model_line_id => p_line_rec.top_model_line_id,
11980: p_set_type => l_set_rec.set_type) THEN
11981:
11982: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
11983: OE_MSG_PUB.Add;
11984: IF l_debug_level > 0 THEN
11985: oe_debug_pub.add( 'E28 UNABLE TO ADD THE Model TO THE SET' , 1 ) ;
11986: END IF;

Line 12019: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_REQUEST_EXCEED_LAD');

12015: < trunc(p_line_rec.request_date) THEN
12016: IF l_debug_level > 0 THEN
12017: oe_debug_pub.add ('E29 Request date exceeds Latest Acceptable Date',1);
12018: END IF;
12019: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_REQUEST_EXCEED_LAD');
12020: OE_MSG_PUB.Add;
12021: x_return_status := FND_API.G_RET_STS_ERROR;
12022: ELSIF ((l_order_date_type_code = 'SHIP'
12023: AND trunc(NVL(p_line_rec.schedule_ship_date,p_line_rec.request_date))

Line 12031: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');

12027: > trunc(NVL(p_line_rec.latest_acceptable_date,p_line_rec.request_date)))) THEN
12028: IF l_debug_level > 0 THEN
12029: oe_debug_pub.add('E30 Schedule date exceeds Latest Acceptable Date',1);
12030: END IF;
12031: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');
12032: OE_MSG_PUB.Add;
12033: x_return_status := FND_API.G_RET_STS_ERROR;
12034: END IF;
12035: -- 3894212

Line 12057: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');

12053: AND l_set_rec.schedule_ship_date IS NOT NULL THEN
12054: IF l_debug_level > 0 THEN
12055: oe_debug_pub.add('E30.1 Schedule date exceeds Latest Acceptable Date',1);
12056: END IF;
12057: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');
12058: OE_MSG_PUB.Add;
12059: x_return_status := FND_API.G_RET_STS_ERROR;
12060: END IF;
12061: END IF;

Line 12103: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_RSV_FAILURE_STAGED');

12099: IF l_found = 'Y' THEN
12100: IF l_debug_level > 0 THEN
12101: oe_debug_pub.add('E31 Reservation(s) cannot be created. The line has been pick confirmed/staged',1);
12102: END IF;
12103: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_RSV_FAILURE_STAGED');
12104: OE_MSG_PUB.Add;
12105: x_return_status := FND_API.G_RET_STS_ERROR;
12106: END IF;
12107: END IF;

Line 12350: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');

12346: RAISE FND_API.G_EXC_ERROR;
12347: END IF;
12348:
12349: ELSE
12350: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
12351: OE_MSG_PUB.Add;
12352: l_update_flag := FND_API.G_FALSE;
12353: END IF;
12354:

Line 12374: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');

12370: RAISE FND_API.G_EXC_ERROR;
12371: END IF;
12372:
12373: ELSE
12374: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
12375: OE_MSG_PUB.Add;
12376: l_update_flag := FND_API.G_FALSE;
12377: END IF;
12378:

Line 16698: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RSV_FAILURE');

16694: IF l_failed_rsv_temp_tbl.count > 0 THEN
16695: IF l_debug_level > 0 THEN
16696: oe_debug_pub.add( ' THE RESERVATION PROCESS HAS FAILED ' , 1 ) ;
16697: END IF;
16698: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RSV_FAILURE');
16699: OE_MSG_PUB.Add;
16700: END IF;
16701:
16702: -- Error Handling Start

Line 18734: Fnd_Message.set_name('ONT','OE_SCH_LOOP_SHP_NONSHP');

18730: AND ORGANIZATION_ID = p_new_ship_from_org_id;
18731:
18732: IF l_shippable_flag <> p_old_shippable_flag THEN
18733: oe_debug_pub.add( 'Item substitution cannot happen between shippable and non-shippable items' , 5 ) ;
18734: Fnd_Message.set_name('ONT','OE_SCH_LOOP_SHP_NONSHP');
18735: Oe_Msg_Pub.Add;
18736: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N';
18737: RAISE FND_API.G_EXC_ERROR;
18738: END IF;