DBA Data[Home] [Help]

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 370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

366: WHEN OTHERS THEN
367:
368: x_return_status := FND_API.G_RET_STS_ERROR;
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'NOTIFY_OC'

Line 372: OE_MSG_PUB.Add_Exc_Msg

368: x_return_status := FND_API.G_RET_STS_ERROR;
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'NOTIFY_OC'
375: );
376: END IF;

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

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

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

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

Line 771: OE_MSG_PUB.Add;

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

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

768: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
770: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
771: OE_MSG_PUB.Add;
772: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
773: END IF;
774: -- x_return_status := FND_API.G_RET_STS_ERROR;
775: ELSIF (p_x_line_rec.service_reference_type_code = 'ORDER') THEN
776:

Line 911: OE_MSG_PUB.Add;

907: -- Bug 9001060
908: EXCEPTION
909: WHEN No_Data_Found THEN
910: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_SERV_REF');
911: OE_MSG_PUB.Add;
912: RAISE FND_API.G_EXC_ERROR;
913: END;
914:
915: --Added for Bug # 4770432 Try to get blanket No from Top Model

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

1058: END IF;
1059:
1060: /* OR added for 2282076 */
1061: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1063: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1064: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1065: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1066: OE_Order_Util.Get_Attribute_Name('ordered_item'));

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

1059:
1060: /* OR added for 2282076 */
1061: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1062: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1063: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1064: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1065: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1066: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1067: OE_MSG_PUB.Add;

Line 1067: OE_MSG_PUB.Add;

1063: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1064: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1065: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1066: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1067: OE_MSG_PUB.Add;
1068: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: return; /* comment on the return statement removed as part of 2271749, though not required to fix that bug */

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

1064: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1065: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1066: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1067: OE_MSG_PUB.Add;
1068: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: return; /* comment on the return statement removed as part of 2271749, though not required to fix that bug */
1072: END IF; -- Should be a valid service item

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

1080: oe_debug_pub.add( 'JPN: PRODUCT QTY IS' || P_X_LINE_REC.ORDERED_QUANTITY ) ;
1081: END IF;
1082:
1083: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1085: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1086: OE_MSG_PUB.Add;
1087: /* Fix for the bug 2431953 / 2749740
1088: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN

Line 1086: OE_MSG_PUB.Add;

1082:
1083: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1085: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1086: OE_MSG_PUB.Add;
1087: /* Fix for the bug 2431953 / 2749740
1088: ELSIF OE_LINE_UTIL.G_ORDERED_QTY_CHANGE = TRUE THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: Fix ends */

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

1219:
1220: EXCEPTION
1221:
1222: WHEN NO_DATA_FOUND THEN
1223: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1224: OE_MSG_PUB.Add_Exc_Msg
1225: ( 'G_PKG_NAME' ,
1226: 'Get_Service_Attribute'
1227: );

Line 1224: OE_MSG_PUB.Add_Exc_Msg

1220: EXCEPTION
1221:
1222: WHEN NO_DATA_FOUND THEN
1223: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1224: OE_MSG_PUB.Add_Exc_Msg
1225: ( 'G_PKG_NAME' ,
1226: 'Get_Service_Attribute'
1227: );
1228: END IF;

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

1231: WHEN FND_API.G_EXC_ERROR THEN
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233:
1234: WHEN OTHERS THEN
1235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1236: OE_MSG_PUB.Add_Exc_Msg
1237: ( 'G_PKG_NAME' ,
1238: 'Get_Service_Attribute'
1239: );

Line 1236: OE_MSG_PUB.Add_Exc_Msg

1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233:
1234: WHEN OTHERS THEN
1235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1236: OE_MSG_PUB.Add_Exc_Msg
1237: ( 'G_PKG_NAME' ,
1238: 'Get_Service_Attribute'
1239: );
1240: END IF;

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

1411: END IF;
1412:
1413: /* OR added for 2282076 */
1414: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1416: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1417: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1419: OE_Order_Util.Get_Attribute_Name('ordered_item'));

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

1412:
1413: /* OR added for 2282076 */
1414: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1416: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1417: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1419: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1420: OE_MSG_PUB.Add;

Line 1420: OE_MSG_PUB.Add;

1416: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1417: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1419: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1420: OE_MSG_PUB.Add;
1421: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1422: END IF;
1423: x_return_status := FND_API.G_RET_STS_ERROR; /* status set to ERROR for 2271749 */
1424: return;

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

1417: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1419: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1420: OE_MSG_PUB.Add;
1421: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1422: END IF;
1423: x_return_status := FND_API.G_RET_STS_ERROR; /* status set to ERROR for 2271749 */
1424: return;
1425: END IF; -- Should be a valid service item

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

1433: oe_debug_pub.add( 'JPN: CUST PROD ORDERED QTY IS ' || P_X_LINE_REC.ORDERED_QUANTITY ) ;
1434: END IF;
1435: --IF l_service_qty <> p_x_line_rec.ordered_quantity THEN
1436: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1438: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1439: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1441: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));

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

1434: END IF;
1435: --IF l_service_qty <> p_x_line_rec.ordered_quantity THEN
1436: IF p_x_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty)THEN --5699215
1437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1438: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1439: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1441: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1442: OE_MSG_PUB.Add;

Line 1442: OE_MSG_PUB.Add;

1438: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1439: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1441: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1442: OE_MSG_PUB.Add;
1443: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1444: END IF;
1445: -- x_return_status := FND_API.G_RET_STS_ERROR;
1446: --p_x_line_rec.ordered_quantity := l_service_qty; -- moved in front of RETURN with, but unrelated to, 1720185

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

1439: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1440: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1441: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1442: OE_MSG_PUB.Add;
1443: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1444: END IF;
1445: -- x_return_status := FND_API.G_RET_STS_ERROR;
1446: --p_x_line_rec.ordered_quantity := l_service_qty; -- moved in front of RETURN with, but unrelated to, 1720185
1447: p_x_line_rec.ordered_quantity := Nvl (l_fulfilled_quantity,l_service_qty); --5699215

Line 1462: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

1458: (p_x_line_rec.service_reference_type_code = FND_API.G_MISS_CHAR) THEN
1459: OE_DEBUG_PUB.ADD('IN Get_Service_Attribute - where code is NULL');
1460: NULL; */
1461: ELSE
1462: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
1463: 'Get_Service_Attribute - Invalid Context');
1464: -- x_return_status := FND_API.G_RET_STS_ERROR;
1465: IF l_debug_level > 0 THEN
1466: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;

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

1638: END IF;
1639:
1640: x_line_rec := p_line_rec;
1641: IF (p_line_rec.service_reference_type_code is NULL) THEN
1642: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1643: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
1644: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1646: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));

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

1639:
1640: x_line_rec := p_line_rec;
1641: IF (p_line_rec.service_reference_type_code is NULL) THEN
1642: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1643: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
1644: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1646: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1647: OE_MSG_PUB.Add;

Line 1647: OE_MSG_PUB.Add;

1643: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SERVICE_REFERENCE_TYPE_CODE');
1644: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1646: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1647: OE_MSG_PUB.Add;
1648: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1649: END IF;
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: ELSIF (p_line_rec.service_reference_type_code = 'ORDER') THEN

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

1644: fnd_message.set_name('ONT','OE_INVALID_SERVICE_REFERENCE_TYPE_CODE');
1645: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1646: OE_Order_Util.Get_Attribute_Name('service_reference_type_code'));
1647: OE_MSG_PUB.Add;
1648: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1649: END IF;
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: ELSIF (p_line_rec.service_reference_type_code = 'ORDER') THEN
1652:

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

1767: END IF;
1768:
1769: /* OR added for 2282076 */
1770: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1772: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1773: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1775: OE_Order_Util.Get_Attribute_Name('ordered_item'));

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

1768:
1769: /* OR added for 2282076 */
1770: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1772: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1773: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1775: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1776: OE_MSG_PUB.Add;

Line 1776: OE_MSG_PUB.Add;

1772: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1773: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1775: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1776: OE_MSG_PUB.Add;
1777: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1778: END IF;
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: return;

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

1773: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1775: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1776: OE_MSG_PUB.Add;
1777: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1778: END IF;
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: return;
1781: END IF; -- Should be a valid service item

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

1783: END IF;
1784:
1785: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1786: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN --5699215
1787: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1789: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));

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

1784:
1785: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1786: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN --5699215
1787: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1789: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1792: OE_MSG_PUB.Add;

Line 1792: OE_MSG_PUB.Add;

1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1789: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1792: OE_MSG_PUB.Add;
1793: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1794: END IF;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: return;

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

1789: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1792: OE_MSG_PUB.Add;
1793: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1794: END IF;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: return;
1797: END IF; -- Invalid Service Quantity => Should be equal to Order QTY

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

1848:
1849: EXCEPTION
1850:
1851: WHEN OTHERS THEN
1852: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1853: OE_MSG_PUB.Add_Exc_Msg
1854: ( 'G_PKG_NAME' ,
1855: 'Get_Service_Attribute'
1856: );

Line 1853: OE_MSG_PUB.Add_Exc_Msg

1849: EXCEPTION
1850:
1851: WHEN OTHERS THEN
1852: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1853: OE_MSG_PUB.Add_Exc_Msg
1854: ( 'G_PKG_NAME' ,
1855: 'Get_Service_Attribute'
1856: );
1857: END IF;

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

1965: END IF;
1966:
1967: /* OR added for 2282076 */
1968: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1971: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1973: OE_Order_Util.Get_Attribute_Name('ordered_item'));

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

1966:
1967: /* OR added for 2282076 */
1968: IF l_available_yn = 'N' OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1971: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1973: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1974: OE_MSG_PUB.Add;

Line 1974: OE_MSG_PUB.Add;

1970: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_ITEM');
1971: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1973: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1974: OE_MSG_PUB.Add;
1975: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1976: END IF;
1977: x_return_status := FND_API.G_RET_STS_ERROR;
1978: return;

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

1971: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM');
1972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1973: OE_Order_Util.Get_Attribute_Name('ordered_item'));
1974: OE_MSG_PUB.Add;
1975: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1976: END IF;
1977: x_return_status := FND_API.G_RET_STS_ERROR;
1978: return;
1979: END IF; -- Should be a valid service item

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

1981: END IF;
1982:
1983: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1984: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN--5699215
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1986: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1987: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1988: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1989: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));

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

1982:
1983: -- IF l_service_qty <> p_line_rec.ordered_quantity THEN
1984: IF p_line_rec.ordered_quantity <> Nvl (l_fulfilled_quantity,l_service_qty) THEN--5699215
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1986: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1987: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1988: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1989: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1990: OE_MSG_PUB.Add;

Line 1990: OE_MSG_PUB.Add;

1986: OE_MSG_PUB.Update_Msg_Context(p_attribute_code =>'ORDERED_QUANTITY');
1987: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1988: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1989: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1990: OE_MSG_PUB.Add;
1991: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1992: END IF;
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: return;

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

1987: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SERV_ITEM_QTY');
1988: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1989: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1990: OE_MSG_PUB.Add;
1991: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1992: END IF;
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: return;
1995: END IF; -- Invalid Service Quantity => Should be equal to Order QTY

Line 2011: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

2007: oe_debug_pub.add( 'IN GET_SERVICE_ATTRIBUTE - WHERE CODE IS NULL' ) ;
2008: END IF;
2009: NULL;
2010: ELSE
2011: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2012: 'Get_Service_Attribute - Invalid Context');
2013: x_return_status := FND_API.G_RET_STS_ERROR;
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add( 'EXITING GET_SERVICE_ATTRIBUTE' ) ;

Line 2061: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

2057: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_LINE_ID' ) ;
2058: END IF;
2059: EXCEPTION
2060: WHEN OTHERS THEN
2061: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2062: 'Get_Service_Ref_Line_Id -Invalid Order/Line No.');
2063: /* uncomment later
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: OE_DEBUG_PUB.ADD('Exiting Get_Service_Ref_Line_Id');

Line 2140: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',

2136: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;
2137: END IF;
2138: EXCEPTION
2139: WHEN OTHERS THEN
2140: OE_MSG_PUB.Add_Exc_Msg( 'G_PKG_NAME',
2141: 'Get_Service_Ref_System_Id - Invalid System No.');
2142: x_return_status := FND_API.G_RET_STS_ERROR;
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add( 'EXITING GET_SERVICE_REF_SYSTEM_ID' ) ;

Line 2429: OE_MSG_PUB.Add;

2425: WHEN NO_DATA_FOUND THEN
2426: -- Added for Bug 6889117 Start
2427: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer or Customer Product');
2429: OE_MSG_PUB.Add;
2430: -- Added for Bug 6889117 End
2431:
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add( 'GET_CUST_PRODUCT_LINE_ID: NO DATA FOUND' ) ;

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

2652: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
2653: p_encoded => 'F'
2654: );
2655: -- For bug 3574480. To show the error reason to the user.
2656: oe_msg_pub.add_text(p_message_text =>X_MSG_DATA);
2657: IF l_debug_level > 0 THEN
2658: oe_debug_pub.add( SUBSTR ( X_MSG_DATA , 1 , 255 ) ) ;
2659: END IF;
2660: end loop;

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

2832:
2833: WHEN OTHERS THEN
2834:
2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2837: THEN
2838: OE_MSG_PUB.Add_Exc_Msg
2839: ( G_PKG_NAME
2840: , 'Update_Service_Lines'

Line 2838: OE_MSG_PUB.Add_Exc_Msg

2834:
2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2837: THEN
2838: OE_MSG_PUB.Add_Exc_Msg
2839: ( G_PKG_NAME
2840: , 'Update_Service_Lines'
2841: );
2842: END IF;

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

3103: IF l_debug_level > 0 THEN
3104: oe_debug_pub.add( 'INSIDE EXCEPTION OTHER ERROR ' , 1 ) ;
3105: END IF;
3106:
3107: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3108: THEN
3109: OE_MSG_PUB.Add_Exc_Msg
3110: ( G_PKG_NAME
3111: , 'UPDATE_SERVICE_FOR_OPTIONS'

Line 3109: OE_MSG_PUB.Add_Exc_Msg

3105: END IF;
3106:
3107: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3108: THEN
3109: OE_MSG_PUB.Add_Exc_Msg
3110: ( G_PKG_NAME
3111: , 'UPDATE_SERVICE_FOR_OPTIONS'
3112: );
3113: END IF;