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

Line 621: OE_MSG_PUB.Add;

617: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
618: END IF;
619: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
620: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
621: OE_MSG_PUB.Add;
622: RAISE FND_API.G_EXC_ERROR;
623: END IF;
624:
625: IF G_LDET_LINE_DETAIL_INDEX.count > 0 THEN

Line 724: OE_MSG_PUB.Add;

720: oe_debug_pub.add( 'ERROR INSERTING INTO LINE DETAILS'||SQLERRM ) ;
721: END IF;
722: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
723: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
724: OE_MSG_PUB.Add;
725: raise fnd_api.g_exc_unexpected_error;
726: END IF;
727: END IF;
728:

Line 770: OE_MSG_PUB.Add;

766: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
767: END IF;
768: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
769: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
770: OE_MSG_PUB.Add;
771: raise fnd_api.g_exc_unexpected_error;
772: END IF;
773:
774: END IF;

Line 994: OE_MSG_PUB.set_msg_context

990: End if;
991: J:= px_Line_Tbl.next(j);
992: end loop;
993:
994: OE_MSG_PUB.set_msg_context
995: ( p_entity_code => 'LINE'
996: ,p_entity_id => l_line_rec.line_id
997: ,p_header_id => l_line_rec.header_id
998: ,p_line_id => l_line_rec.line_id

Line 1029: OE_MSG_PUB.Add;

1025: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1026: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1027: vmsg := FND_MESSAGE.GET;
1028: else
1029: OE_MSG_PUB.Add;
1030: end if;
1031: else
1032: OE_MSG_PUB.Add;
1033: end if;

Line 1032: OE_MSG_PUB.Add;

1028: else
1029: OE_MSG_PUB.Add;
1030: end if;
1031: else
1032: OE_MSG_PUB.Add;
1033: end if;
1034:
1035: l_invalid_line := 'Y';
1036: END IF;

Line 1075: OE_MSG_PUB.Add;

1071: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1072: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1073: vmsg := FND_MESSAGE.GET;
1074: else
1075: OE_MSG_PUB.Add;
1076: end if;
1077: else
1078: OE_MSG_PUB.Add;
1079: end if;

Line 1078: OE_MSG_PUB.Add;

1074: else
1075: OE_MSG_PUB.Add;
1076: end if;
1077: else
1078: OE_MSG_PUB.Add;
1079: end if;
1080: IF l_debug_level > 0 THEN
1081: oe_debug_pub.add( 'BEFORE CHECKING BOOK FLAG' ) ;
1082: END IF;

Line 1090: OE_MSG_PUB.ADD;

1086: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;
1087: END IF;
1088: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
1089: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
1090: OE_MSG_PUB.ADD;
1091: RAISE FND_API.G_EXC_ERROR;
1092: End If;
1093: IF l_debug_level > 0 THEN
1094: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||':'||L_LINE_REC.UNIT_LIST_PRICE ) ;

Line 1120: OE_MSG_PUB.Add;

1116: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1117: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1118: vmsg := FND_MESSAGE.GET;
1119: else
1120: OE_MSG_PUB.Add;
1121: end if;
1122: else
1123: OE_MSG_PUB.Add;
1124: end if;

Line 1123: OE_MSG_PUB.Add;

1119: else
1120: OE_MSG_PUB.Add;
1121: end if;
1122: else
1123: OE_MSG_PUB.Add;
1124: end if;
1125: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;

Line 1135: OE_MSG_PUB.Add;

1131: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1132: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1133: vmsg := FND_MESSAGE.GET;
1134: else
1135: OE_MSG_PUB.Add;
1136: end if;
1137: else
1138: OE_MSG_PUB.Add;
1139: end if;

Line 1138: OE_MSG_PUB.Add;

1134: else
1135: OE_MSG_PUB.Add;
1136: end if;
1137: else
1138: OE_MSG_PUB.Add;
1139: end if;
1140: Elsif wrong_line.pricing_status_code in
1141: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
1142: FND_API.G_RET_STS_ERROR)

Line 1153: OE_MSG_PUB.Add;

1149: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1150: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1151: vmsg := FND_MESSAGE.GET;
1152: else
1153: OE_MSG_PUB.Add;
1154: end if;
1155: else
1156: OE_MSG_PUB.Add;
1157: end if;

Line 1156: OE_MSG_PUB.Add;

1152: else
1153: OE_MSG_PUB.Add;
1154: end if;
1155: else
1156: OE_MSG_PUB.Add;
1157: end if;
1158: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'INVALID UOM' ) ;

Line 1169: OE_MSG_PUB.Add;

1165: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1166: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1167: vmsg := FND_MESSAGE.GET;
1168: else
1169: OE_MSG_PUB.Add;
1170: end if;
1171: else
1172: OE_MSG_PUB.Add;
1173: end if;

Line 1172: OE_MSG_PUB.Add;

1168: else
1169: OE_MSG_PUB.Add;
1170: end if;
1171: else
1172: OE_MSG_PUB.Add;
1173: end if;
1174: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;

Line 1217: OE_MSG_PUB.Add;

1213: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1214: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1215: vmsg := FND_MESSAGE.GET;
1216: else
1217: OE_MSG_PUB.Add;
1218: end if;
1219: else
1220: OE_MSG_PUB.Add;
1221: end if;

Line 1220: OE_MSG_PUB.Add;

1216: else
1217: OE_MSG_PUB.Add;
1218: end if;
1219: else
1220: OE_MSG_PUB.Add;
1221: end if;
1222: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
1223: IF l_debug_level > 0 THEN
1224: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;

Line 1233: OE_MSG_PUB.Add;

1229: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1230: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1231: vmsg := FND_MESSAGE.GET;
1232: else
1233: OE_MSG_PUB.Add;
1234: end if;
1235: else
1236: OE_MSG_PUB.Add;
1237: end if;

Line 1236: OE_MSG_PUB.Add;

1232: else
1233: OE_MSG_PUB.Add;
1234: end if;
1235: else
1236: OE_MSG_PUB.Add;
1237: end if;
1238: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;

Line 1249: OE_MSG_PUB.Add;

1245: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1246: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1247: vmsg := FND_MESSAGE.GET;
1248: else
1249: OE_MSG_PUB.Add;
1250: end if;
1251: else
1252: OE_MSG_PUB.Add;
1253: end if;

Line 1252: OE_MSG_PUB.Add;

1248: else
1249: OE_MSG_PUB.Add;
1250: end if;
1251: else
1252: OE_MSG_PUB.Add;
1253: end if;
1254: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;

Line 1265: OE_MSG_PUB.Add;

1261: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1262: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1263: vmsg := FND_MESSAGE.GET;
1264: else
1265: OE_MSG_PUB.Add;
1266: end if;
1267: else
1268: OE_MSG_PUB.Add;
1269: end if;

Line 1268: OE_MSG_PUB.Add;

1264: else
1265: OE_MSG_PUB.Add;
1266: end if;
1267: else
1268: OE_MSG_PUB.Add;
1269: end if;
1270: End if; /* wrong pricing status code */
1271:
1272: --RAISE FND_API.G_EXC_ERROR;

Line 1314: OE_MSG_PUB.Add;

1310:
1311: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
1313: ||l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
1314: OE_MSG_PUB.Add;
1315: elsif wrong_line.line_type_code='LINE' and
1316: (wrong_line.unit_price <0 or wrong_line.adjusted_unit_price<0)
1317: Then
1318:

Line 1326: OE_MSG_PUB.Add;

1322: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
1323: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1324: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
1325: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1326: OE_MSG_PUB.Add;
1327: IF l_debug_level > 0 THEN
1328: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;
1329: END IF;
1330: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

Line 1332: OE_MSG_PUB.Add;

1328: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;
1329: END IF;
1330: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
1331: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
1332: OE_MSG_PUB.Add;
1333: IF l_debug_level > 0 THEN
1334: -- oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;
1335: NULL;
1336: END IF;

Line 1349: OE_MSG_PUB.ADD;

1345: If book_line.adjusted_unit_price IS NULL Then
1346: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
1347: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1348: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
1349: OE_MSG_PUB.ADD;
1350: End If;
1351:
1352: If book_line.unit_price IS NULL
1353: Then

Line 1365: OE_MSG_PUB.ADD;

1361: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then
1362: vmsg := FND_MESSAGE.GET;
1363: -- pricing_errors_hold(book_line.header_id,book_line.line_id,vmsg);
1364: else
1365: OE_MSG_PUB.ADD;
1366: l_temp_line_rec.line_id := book_line.line_id;
1367: l_temp_line_rec.ordered_quantity := book_line.line_quantity;
1368: l_temp_line_rec.pricing_quantity := book_line.priced_quantity;
1369: --Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);

Line 1373: OE_MSG_PUB.ADD;

1369: --Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
1370: RAISE FND_API.G_EXC_ERROR;
1371: end if;
1372: else
1373: OE_MSG_PUB.ADD;
1374: end if;
1375: End If;
1376:
1377: If book_line.price_list_header_id IS NULL Then

Line 1380: OE_MSG_PUB.ADD;

1376:
1377: If book_line.price_list_header_id IS NULL Then
1378: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');
1379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
1380: OE_MSG_PUB.ADD;
1381: IF l_debug_level > 0 THEN
1382: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
1383: END IF;
1384: RAISE FND_API.G_EXC_ERROR;

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

1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( SQLERRM , 1 ) ;
1645: END IF;
1646:
1647: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1648: THEN
1649: OE_MSG_PUB.Add_Exc_Msg
1650: ( G_PKG_NAME
1651: , 'Process_Adjustments'

Line 1649: OE_MSG_PUB.Add_Exc_Msg

1645: END IF;
1646:
1647: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1648: THEN
1649: OE_MSG_PUB.Add_Exc_Msg
1650: ( G_PKG_NAME
1651: , 'Process_Adjustments'
1652: );
1653: END IF;

Line 1733: OE_MSG_PUB.Add;

1729:
1730: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1731: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
1732: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
1733: OE_MSG_PUB.Add;
1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1736: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
1737: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

Line 1738: OE_MSG_PUB.Add;

1734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1735: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1736: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
1737: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
1738: OE_MSG_PUB.Add;
1739: RAISE FND_API.G_EXC_ERROR;
1740: END IF;
1741:
1742: EXCEPTION

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

2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add( SQLERRM , 1 ) ;
2034: END IF;
2035:
2036: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2037: THEN
2038: OE_MSG_PUB.Add_Exc_Msg
2039: ( G_PKG_NAME
2040: , 'PRICE_ORDER'

Line 2038: OE_MSG_PUB.Add_Exc_Msg

2034: END IF;
2035:
2036: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2037: THEN
2038: OE_MSG_PUB.Add_Exc_Msg
2039: ( G_PKG_NAME
2040: , 'PRICE_ORDER'
2041: );
2042: END IF;