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

Line 559: OE_MSG_PUB.Add;

555: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
556: END IF;
557: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
558: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
559: OE_MSG_PUB.Add;
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562:
563: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN

Line 604: OE_MSG_PUB.Add;

600: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
601: END IF;
602: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
603: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
604: OE_MSG_PUB.Add;
605: raise fnd_api.g_exc_unexpected_error;
606: END IF;
607:
608: END IF;

Line 788: OE_MSG_PUB.set_msg_context

784: End if;
785: J:= px_Line_Tbl.next(j);
786: end loop;
787:
788: OE_MSG_PUB.set_msg_context
789: ( p_entity_code => 'LINE'
790: ,p_entity_id => l_line_rec.line_id
791: ,p_header_id => l_line_rec.header_id
792: ,p_line_id => l_line_rec.line_id

Line 823: OE_MSG_PUB.Add;

819: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
820: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
821: vmsg := FND_MESSAGE.GET;
822: else
823: OE_MSG_PUB.Add;
824: end if;
825: else
826: OE_MSG_PUB.Add;
827: end if;

Line 826: OE_MSG_PUB.Add;

822: else
823: OE_MSG_PUB.Add;
824: end if;
825: else
826: OE_MSG_PUB.Add;
827: end if;
828:
829: l_invalid_line := 'Y';
830: END IF;

Line 869: OE_MSG_PUB.Add;

865: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
866: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
867: vmsg := FND_MESSAGE.GET;
868: else
869: OE_MSG_PUB.Add;
870: end if;
871: else
872: OE_MSG_PUB.Add;
873: end if;

Line 872: OE_MSG_PUB.Add;

868: else
869: OE_MSG_PUB.Add;
870: end if;
871: else
872: OE_MSG_PUB.Add;
873: end if;
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add( 'BEFORE CHECKING BOOK FLAG' ) ;
876: END IF;

Line 884: OE_MSG_PUB.ADD;

880: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;
881: END IF;
882: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
884: OE_MSG_PUB.ADD;
885: RAISE FND_API.G_EXC_ERROR;
886: End If;
887: IF l_debug_level > 0 THEN
888: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||':'||L_LINE_REC.UNIT_LIST_PRICE ) ;

Line 914: OE_MSG_PUB.Add;

910: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
911: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
912: vmsg := FND_MESSAGE.GET;
913: else
914: OE_MSG_PUB.Add;
915: end if;
916: else
917: OE_MSG_PUB.Add;
918: end if;

Line 917: OE_MSG_PUB.Add;

913: else
914: OE_MSG_PUB.Add;
915: end if;
916: else
917: OE_MSG_PUB.Add;
918: end if;
919: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
920: IF l_debug_level > 0 THEN
921: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;

Line 929: OE_MSG_PUB.Add;

925: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
926: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
927: vmsg := FND_MESSAGE.GET;
928: else
929: OE_MSG_PUB.Add;
930: end if;
931: else
932: OE_MSG_PUB.Add;
933: end if;

Line 932: OE_MSG_PUB.Add;

928: else
929: OE_MSG_PUB.Add;
930: end if;
931: else
932: OE_MSG_PUB.Add;
933: end if;
934: Elsif wrong_line.pricing_status_code in
935: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
936: FND_API.G_RET_STS_ERROR)

Line 947: OE_MSG_PUB.Add;

943: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
944: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
945: vmsg := FND_MESSAGE.GET;
946: else
947: OE_MSG_PUB.Add;
948: end if;
949: else
950: OE_MSG_PUB.Add;
951: end if;

Line 950: OE_MSG_PUB.Add;

946: else
947: OE_MSG_PUB.Add;
948: end if;
949: else
950: OE_MSG_PUB.Add;
951: end if;
952: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'INVALID UOM' ) ;

Line 963: OE_MSG_PUB.Add;

959: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
960: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
961: vmsg := FND_MESSAGE.GET;
962: else
963: OE_MSG_PUB.Add;
964: end if;
965: else
966: OE_MSG_PUB.Add;
967: end if;

Line 966: OE_MSG_PUB.Add;

962: else
963: OE_MSG_PUB.Add;
964: end if;
965: else
966: OE_MSG_PUB.Add;
967: end if;
968: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;

Line 1011: OE_MSG_PUB.Add;

1007: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1008: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1009: vmsg := FND_MESSAGE.GET;
1010: else
1011: OE_MSG_PUB.Add;
1012: end if;
1013: else
1014: OE_MSG_PUB.Add;
1015: end if;

Line 1014: OE_MSG_PUB.Add;

1010: else
1011: OE_MSG_PUB.Add;
1012: end if;
1013: else
1014: OE_MSG_PUB.Add;
1015: end if;
1016: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
1017: IF l_debug_level > 0 THEN
1018: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;

Line 1027: OE_MSG_PUB.Add;

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

Line 1030: OE_MSG_PUB.Add;

1026: else
1027: OE_MSG_PUB.Add;
1028: end if;
1029: else
1030: OE_MSG_PUB.Add;
1031: end if;
1032: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;

Line 1043: OE_MSG_PUB.Add;

1039: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1040: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1041: vmsg := FND_MESSAGE.GET;
1042: else
1043: OE_MSG_PUB.Add;
1044: end if;
1045: else
1046: OE_MSG_PUB.Add;
1047: end if;

Line 1046: OE_MSG_PUB.Add;

1042: else
1043: OE_MSG_PUB.Add;
1044: end if;
1045: else
1046: OE_MSG_PUB.Add;
1047: end if;
1048: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;

Line 1059: OE_MSG_PUB.Add;

1055: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
1056: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
1057: vmsg := FND_MESSAGE.GET;
1058: else
1059: OE_MSG_PUB.Add;
1060: end if;
1061: else
1062: OE_MSG_PUB.Add;
1063: end if;

Line 1062: OE_MSG_PUB.Add;

1058: else
1059: OE_MSG_PUB.Add;
1060: end if;
1061: else
1062: OE_MSG_PUB.Add;
1063: end if;
1064: End if; /* wrong pricing status code */
1065:
1066: --RAISE FND_API.G_EXC_ERROR;

Line 1108: OE_MSG_PUB.Add;

1104:
1105: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
1106: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
1107: ||l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
1108: OE_MSG_PUB.Add;
1109: elsif wrong_line.line_type_code='LINE' and
1110: (wrong_line.unit_price <0 or wrong_line.adjusted_unit_price<0)
1111: Then
1112:

Line 1120: OE_MSG_PUB.Add;

1116: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
1117: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1118: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
1119: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1120: OE_MSG_PUB.Add;
1121: IF l_debug_level > 0 THEN
1122: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;
1123: END IF;
1124: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

Line 1126: OE_MSG_PUB.Add;

1122: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;
1123: END IF;
1124: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
1125: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
1126: OE_MSG_PUB.Add;
1127: IF l_debug_level > 0 THEN
1128: -- oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;
1129: NULL;
1130: END IF;

Line 1143: OE_MSG_PUB.ADD;

1139: If book_line.adjusted_unit_price IS NULL Then
1140: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
1141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1142: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
1143: OE_MSG_PUB.ADD;
1144: End If;
1145:
1146: If book_line.unit_price IS NULL
1147: Then

Line 1159: OE_MSG_PUB.ADD;

1155: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then
1156: vmsg := FND_MESSAGE.GET;
1157: -- pricing_errors_hold(book_line.header_id,book_line.line_id,vmsg);
1158: else
1159: OE_MSG_PUB.ADD;
1160: l_temp_line_rec.line_id := book_line.line_id;
1161: l_temp_line_rec.ordered_quantity := book_line.line_quantity;
1162: l_temp_line_rec.pricing_quantity := book_line.priced_quantity;
1163: --Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);

Line 1167: OE_MSG_PUB.ADD;

1163: --Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
1164: RAISE FND_API.G_EXC_ERROR;
1165: end if;
1166: else
1167: OE_MSG_PUB.ADD;
1168: end if;
1169: End If;
1170:
1171: If book_line.price_list_header_id IS NULL Then

Line 1174: OE_MSG_PUB.ADD;

1170:
1171: If book_line.price_list_header_id IS NULL Then
1172: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');
1173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
1174: OE_MSG_PUB.ADD;
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
1177: END IF;
1178: RAISE FND_API.G_EXC_ERROR;

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

1416: IF l_debug_level > 0 THEN
1417: oe_debug_pub.add( SQLERRM , 1 ) ;
1418: END IF;
1419:
1420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1421: THEN
1422: OE_MSG_PUB.Add_Exc_Msg
1423: ( G_PKG_NAME
1424: , 'Price_line'

Line 1422: OE_MSG_PUB.Add_Exc_Msg

1418: END IF;
1419:
1420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1421: THEN
1422: OE_MSG_PUB.Add_Exc_Msg
1423: ( G_PKG_NAME
1424: , 'Price_line'
1425: );
1426: END IF;

Line 1510: OE_MSG_PUB.Add;

1506:
1507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1508: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
1509: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
1510: OE_MSG_PUB.Add;
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1513: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
1514: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

Line 1515: OE_MSG_PUB.Add;

1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1513: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
1514: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
1515: OE_MSG_PUB.Add;
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518:
1519: END Call_Pricing_Engine;