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_SERVICE_UTIL dependencies on OE_MSG_PUB

Line 337: oe_msg_pub.add_text(p_message_text => l_buffer);

333: END IF;
334: IF l_msg_data is not null THEN
335: /* fnd_message.set_encoded(l_msg_data);
336: l_buffer := fnd_message.get;
337: oe_msg_pub.add_text(p_message_text => l_buffer);
338: IF l_debug_level > 0 THEN
339: oe_debug_pub.add( L_BUFFER , 1 ) ;
340: END IF;*/
341: Retrieve_OC_Messages;

Line 365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

361: WHEN OTHERS THEN
362:
363: x_return_status := FND_API.G_RET_STS_ERROR;
364:
365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: OE_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME
369: , 'NOTIFY_OC'

Line 367: OE_MSG_PUB.Add_Exc_Msg

363: x_return_status := FND_API.G_RET_STS_ERROR;
364:
365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: OE_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME
369: , 'NOTIFY_OC'
370: );
371: END IF;

Line 761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

757: AND (p_x_line_rec.service_reference_line_id is NOT NULL) THEN
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'ENTERING GET_SERVICE_ATTRIBUTE REF TYPE NULL' ) ;
760: END IF;
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
762: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
763: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
765: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));

Line 762: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');

758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'ENTERING GET_SERVICE_ATTRIBUTE REF TYPE NULL' ) ;
760: END IF;
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
762: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
763: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
765: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
766: OE_MSG_PUB.Add;

Line 766: OE_MSG_PUB.Add;

762: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
763: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
765: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
766: OE_MSG_PUB.Add;
767: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
768: END IF;
769: -- x_return_status := FND_API.G_RET_STS_ERROR;
770: ELSIF (p_x_line_rec.service_reference_type_code = 'ORDER') THEN

Line 767: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

763: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
764: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
765: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
766: OE_MSG_PUB.Add;
767: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
768: END IF;
769: -- x_return_status := FND_API.G_RET_STS_ERROR;
770: ELSIF (p_x_line_rec.service_reference_type_code = 'ORDER') THEN
771:

Line 1048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1044: END IF;
1045:
1046: /* OR added for 2282076 */
1047: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1049: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1050: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1052: OE_Order_Util.Get_Attribute_Name('ordered_item'));

Line 1049: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');

1045:
1046: /* OR added for 2282076 */
1047: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1049: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1050: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1052: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1053: OE_MSG_PUB.Add;

Line 1053: OE_MSG_PUB.Add;

1049: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1050: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1052: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1053: OE_MSG_PUB.Add;
1054: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1055: END IF;
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: return; /* comment on the return statement removed as part of 2271749, though not required to fix that bug */

Line 1054: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1050: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1051: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1052: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1053: OE_MSG_PUB.Add;
1054: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1055: END IF;
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: return; /* comment on the return statement removed as part of 2271749, though not required to fix that bug */
1058: END IF; -- Should be a valid service item

Line 1070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1066: oe_debug_pub.add( 'JPN: PRODUCT QTY IS' || P_X_LINE_REC.ORDERED_QUANTITY ) ;
1067: END IF;
1068:
1069: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1071: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1072: OE_MSG_PUB.Add;
1073: /* Fix for the bug 2431953 / 2749740
1074: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN

Line 1072: OE_MSG_PUB.Add;

1068:
1069: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1071: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1072: OE_MSG_PUB.Add;
1073: /* Fix for the bug 2431953 / 2749740
1074: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: Fix ends */

Line 1209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1205:
1206: EXCEPTION
1207:
1208: WHEN NO_DATA_FOUND THEN
1209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1210: OE_MSG_PUB.Add_Exc_Msg
1211: ( 'G_PKG_NAME' ,
1212: 'Get_Service_Attribute'
1213: );

Line 1210: OE_MSG_PUB.Add_Exc_Msg

1206: EXCEPTION
1207:
1208: WHEN NO_DATA_FOUND THEN
1209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1210: OE_MSG_PUB.Add_Exc_Msg
1211: ( 'G_PKG_NAME' ,
1212: 'Get_Service_Attribute'
1213: );
1214: END IF;

Line 1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1213: );
1214: END IF;
1215:
1216: WHEN OTHERS THEN
1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1218: OE_MSG_PUB.Add_Exc_Msg
1219: ( 'G_PKG_NAME' ,
1220: 'Get_Service_Attribute'
1221: );

Line 1218: OE_MSG_PUB.Add_Exc_Msg

1214: END IF;
1215:
1216: WHEN OTHERS THEN
1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1218: OE_MSG_PUB.Add_Exc_Msg
1219: ( 'G_PKG_NAME' ,
1220: 'Get_Service_Attribute'
1221: );
1222: END IF;

Line 1397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1393: END IF;
1394:
1395: /* OR added for 2282076 */
1396: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1398: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1399: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1401: OE_Order_Util.Get_Attribute_Name('ordered_item'));

Line 1398: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');

1394:
1395: /* OR added for 2282076 */
1396: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1397: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1398: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1399: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1401: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1402: OE_MSG_PUB.Add;

Line 1402: OE_MSG_PUB.Add;

1398: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1399: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1401: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1402: OE_MSG_PUB.Add;
1403: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1404: END IF;
1405: x_return_status := FND_API.G_RET_STS_ERROR; /* status set to ERROR for 2271749 */
1406: return;

Line 1403: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1399: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1401: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1402: OE_MSG_PUB.Add;
1403: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1404: END IF;
1405: x_return_status := FND_API.G_RET_STS_ERROR; /* status set to ERROR for 2271749 */
1406: return;
1407: END IF; -- Should be a valid service item

Line 1419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1415: oe_debug_pub.add( 'JPN: CUST PROD ORDERED QTY IS ' || P_X_LINE_REC.ORDERED_QUANTITY ) ;
1416: END IF;
1417: --IF l_service_qty <> p_x_line_rec.ordered_quantity THEN
1418: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1420: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1421: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1423: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));

Line 1420: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');

1416: END IF;
1417: --IF l_service_qty <> p_x_line_rec.ordered_quantity THEN
1418: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1420: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1421: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1423: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1424: OE_MSG_PUB.Add;

Line 1424: OE_MSG_PUB.Add;

1420: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1421: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1423: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1424: OE_MSG_PUB.Add;
1425: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1426: END IF;
1427: -- x_return_status := FND_API.G_RET_STS_ERROR;
1428: --p_x_line_rec.ordered_quantity := l_service_qty; -- moved in front of RETURN with, but unrelated to, 1720185

Line 1425: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1421: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1423: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1424: OE_MSG_PUB.Add;
1425: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1426: END IF;
1427: -- x_return_status := FND_API.G_RET_STS_ERROR;
1428: --p_x_line_rec.ordered_quantity := l_service_qty; -- moved in front of RETURN with, but unrelated to, 1720185
1429: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215

Line 1444: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

1440: (p_x_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN
1441: OE_DEBUG_PUB.ADD('IN Get_Service_Attribute - where code is NULL');
1442: NULL; */
1443: ELSE
1444: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
1445: 'Get_Service_Attribute - Invalid Context');
1446: -- x_return_status := FND_API.G_RET_STS_ERROR;
1447: IF l_debug_level > 0 THEN
1448: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;

Line 1611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1607: END IF;
1608:
1609: x_line_rec := p_line_rec;
1610: IF (p_line_rec.service_reference_type_code is NULL) THEN
1611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1612: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
1613: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1614: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1615: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));

Line 1612: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');

1608:
1609: x_line_rec := p_line_rec;
1610: IF (p_line_rec.service_reference_type_code is NULL) THEN
1611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1612: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
1613: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1614: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1615: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1616: OE_MSG_PUB.Add;

Line 1616: OE_MSG_PUB.Add;

1612: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
1613: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1614: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1615: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1616: OE_MSG_PUB.Add;
1617: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1618: END IF;
1619: x_return_status := FND_API.G_RET_STS_ERROR;
1620: ELSIF (p_line_rec.service_reference_type_code = 'ORDER') THEN

Line 1617: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1613: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1614: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1615: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1616: OE_MSG_PUB.Add;
1617: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1618: END IF;
1619: x_return_status := FND_API.G_RET_STS_ERROR;
1620: ELSIF (p_line_rec.service_reference_type_code = 'ORDER') THEN
1621:

Line 1736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1732: END IF;
1733:
1734: /* OR added for 2282076 */
1735: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1737: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1738: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1740: OE_Order_Util.Get_Attribute_Name('ordered_item'));

Line 1737: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');

1733:
1734: /* OR added for 2282076 */
1735: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1737: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1738: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1740: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1741: OE_MSG_PUB.Add;

Line 1741: OE_MSG_PUB.Add;

1737: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1738: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1740: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1741: OE_MSG_PUB.Add;
1742: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1743: END IF;
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: return;

Line 1742: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1738: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1740: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1741: OE_MSG_PUB.Add;
1742: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1743: END IF;
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: return;
1746: END IF; -- Should be a valid service item

Line 1752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1748: END IF;
1749:
1750: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1751: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN --5699215
1752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1753: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1754: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1756: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));

Line 1753: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');

1749:
1750: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1751: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN --5699215
1752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1753: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1754: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1756: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1757: OE_MSG_PUB.Add;

Line 1757: OE_MSG_PUB.Add;

1753: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1754: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1756: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1757: OE_MSG_PUB.Add;
1758: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1759: END IF;
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: return;

Line 1758: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1754: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1756: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1757: OE_MSG_PUB.Add;
1758: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1759: END IF;
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761: return;
1762: END IF; -- Invalid Service Quantity => Should be equal to Order QTY

Line 1817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1813:
1814: EXCEPTION
1815:
1816: WHEN OTHERS THEN
1817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1818: OE_MSG_PUB.Add_Exc_Msg
1819: ( 'G_PKG_NAME' ,
1820: 'Get_Service_Attribute'
1821: );

Line 1818: OE_MSG_PUB.Add_Exc_Msg

1814: EXCEPTION
1815:
1816: WHEN OTHERS THEN
1817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1818: OE_MSG_PUB.Add_Exc_Msg
1819: ( 'G_PKG_NAME' ,
1820: 'Get_Service_Attribute'
1821: );
1822: END IF;

Line 1929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1925: END IF;
1926:
1927: /* OR added for 2282076 */
1928: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1930: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1931: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1933: OE_Order_Util.Get_Attribute_Name('ordered_item'));

Line 1930: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');

1926:
1927: /* OR added for 2282076 */
1928: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1929: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1930: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1931: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1933: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1934: OE_MSG_PUB.Add;

Line 1934: OE_MSG_PUB.Add;

1930: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1931: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1933: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1934: OE_MSG_PUB.Add;
1935: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1936: END IF;
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: return;

Line 1935: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1931: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1933: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1934: OE_MSG_PUB.Add;
1935: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1936: END IF;
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: return;
1939: END IF; -- Should be a valid service item

Line 1945: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1941: END IF;
1942:
1943: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1944: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN--5699215
1945: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1946: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1947: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));

Line 1946: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');

1942:
1943: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1944: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN--5699215
1945: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1946: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1947: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1950: OE_MSG_PUB.Add;

Line 1950: OE_MSG_PUB.Add;

1946: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1947: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1950: OE_MSG_PUB.Add;
1951: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1952: END IF;
1953: x_return_status := FND_API.G_RET_STS_ERROR;
1954: return;

Line 1951: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

1947: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1950: OE_MSG_PUB.Add;
1951: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1952: END IF;
1953: x_return_status := FND_API.G_RET_STS_ERROR;
1954: return;
1955: END IF; -- Invalid Service Quantity => Should be equal to Order QTY

Line 1971: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

1967: oe_debug_pub.add( 'IN GET_SERVICE_ATTRIBUTE - WHERE CODE IS NULL' ) ;
1968: END IF;
1969: NULL;
1970: ELSE
1971: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
1972: 'Get_Service_Attribute - Invalid Context');
1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974: IF l_debug_level > 0 THEN
1975: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;

Line 2021: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

2017: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_LINE_ID' ) ;
2018: END IF;
2019: EXCEPTION
2020: WHEN OTHERS THEN
2021: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2022: 'Get_Service_Ref_Line_Id -Invalid Order/Line No.');
2023: /* uncomment later
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025: OE_DEBUG_PUB.ADD('Exiting Get_Service_Ref_Line_Id');

Line 2100: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

2096: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2097: END IF;
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2101: 'Get_Service_Ref_System_Id - Invalid System No.');
2102: x_return_status := FND_API.G_RET_STS_ERROR;
2103: IF l_debug_level > 0 THEN
2104: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;

Line 2388: OE_MSG_PUB.Add;

2384: WHEN NO_DATA_FOUND THEN
2385: -- Added for Bug 6889117 Start
2386: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer or Customer Product');
2388: OE_MSG_PUB.Add;
2389: -- Added for Bug 6889117 End
2390:
2391: IF l_debug_level > 0 THEN
2392: oe_debug_pub.add( 'GET_CUST_PRODUCT_LINE_ID: NO DATA FOUND' ) ;

Line 2614: oe_msg_pub.add_text(p_message_text =>X_MSG_DATA);

2610: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2611: p_encoded => 'F'
2612: );
2613: -- For bug 3574480. To show the error reason to the user.
2614: oe_msg_pub.add_text(p_message_text =>X_MSG_DATA);
2615: IF l_debug_level > 0 THEN
2616: oe_debug_pub.add( SUBSTR ( X_MSG_DATA , 1 , 255 ) ) ;
2617: END IF;
2618: end loop;

Line 2790: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2786:
2787: WHEN OTHERS THEN
2788:
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2790: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2791: THEN
2792: OE_MSG_PUB.Add_Exc_Msg
2793: ( G_PKG_NAME
2794: , 'Update_Service_Lines'

Line 2792: OE_MSG_PUB.Add_Exc_Msg

2788:
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2790: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2791: THEN
2792: OE_MSG_PUB.Add_Exc_Msg
2793: ( G_PKG_NAME
2794: , 'Update_Service_Lines'
2795: );
2796: END IF;

Line 3061: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3057: IF l_debug_level > 0 THEN
3058: oe_debug_pub.add( 'INSIDE EXCEPTION OTHER ERROR ' , 1 ) ;
3059: END IF;
3060:
3061: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3062: THEN
3063: OE_MSG_PUB.Add_Exc_Msg
3064: ( G_PKG_NAME
3065: , 'UPDATE_SERVICE_FOR_OPTIONS'

Line 3063: OE_MSG_PUB.Add_Exc_Msg

3059: END IF;
3060:
3061: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3062: THEN
3063: OE_MSG_PUB.Add_Exc_Msg
3064: ( G_PKG_NAME
3065: , 'UPDATE_SERVICE_FOR_OPTIONS'
3066: );
3067: END IF;