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 FND_MESSAGE

Line 557: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');

553: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
554: IF l_debug_level > 0 THEN
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;

Line 558: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

554: IF l_debug_level > 0 THEN
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:

Line 602: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');

598: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
599: IF l_debug_level > 0 THEN
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;

Line 603: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

599: IF l_debug_level > 0 THEN
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:

Line 816: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');

812: END IF;
813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;
815: END IF;
816: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
817: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
818: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 817: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;
815: END IF;
816: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
817: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
818: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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;

Line 818: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);

814: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;
815: END IF;
816: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
817: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
818: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 821: vmsg := FND_MESSAGE.GET;

817: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
818: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 861: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');

857: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
860: END IF;
861: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
862: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
863: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
864: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
865: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

Line 862: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
860: END IF;
861: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
862: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
863: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
864: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
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

Line 863: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);

859: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
860: END IF;
861: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
862: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
863: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
864: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
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;

Line 864: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);

860: END IF;
861: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
862: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
863: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
864: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
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

Line 867: vmsg := FND_MESSAGE.GET;

863: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
864: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
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

Line 882: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

878: If nvl(l_line_rec.booked_flag,'X') = 'Y' Then
879: IF l_debug_level > 0 THEN
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;

Line 883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));

879: IF l_debug_level > 0 THEN
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

Line 907: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');

903: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
904: IF l_debug_level > 0 THEN
905: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
906: END IF;
907: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
908: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
909: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 908: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

904: IF l_debug_level > 0 THEN
905: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
906: END IF;
907: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
908: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
909: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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;

Line 909: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);

905: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
906: END IF;
907: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
908: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
909: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 912: vmsg := FND_MESSAGE.GET;

908: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
909: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

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' ) ;
922: END IF;
923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
924: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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;

Line 924: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

920: IF l_debug_level > 0 THEN
921: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
922: END IF;
923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
924: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 927: vmsg := FND_MESSAGE.GET;

923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
924: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 941: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');

937: then
938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
940: END IF;
941: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
942: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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;

Line 942: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
940: END IF;
941: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
942: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 945: vmsg := FND_MESSAGE.GET;

941: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');
942: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 956: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

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' ) ;
955: END IF;
956: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
957: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
958: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 957: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'INVALID UOM' ) ;
955: END IF;
956: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
957: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
958: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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;

Line 958: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);

954: oe_debug_pub.add( 'INVALID UOM' ) ;
955: END IF;
956: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
957: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
958: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 961: vmsg := FND_MESSAGE.GET;

957: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
958: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 972: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

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' ) ;
971: END IF;
972: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
973:
974: Begin
975: Select name into l_price_list
976: from qp_list_headers_vl a,qp_list_lines b where

Line 990: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',

986: instr(wrong_line.status_text,',')-1);
987:
988: End;
989:
990: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
991: '( '||l_line_rec.Ordered_Item||' ) '||l_price_list);
992: Begin
993: Select name into l_price_list
994: from qp_list_headers_vl a,qp_list_lines b where

Line 1006: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);

1002: When invalid_number then
1003: l_price_list := substr(wrong_line.status_text,
1004: instr(wrong_line.status_text,',')+1);
1005: End;
1006: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
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

Line 1009: vmsg := FND_MESSAGE.GET;

1005: End;
1006: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
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

Line 1020: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

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' ) ;
1019: END IF;
1020: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1021: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
1022: wrong_line.status_text);
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

Line 1021: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||

1017: IF l_debug_level > 0 THEN
1018: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
1019: END IF;
1020: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1021: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
1022: wrong_line.status_text);
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;

Line 1025: vmsg := FND_MESSAGE.GET;

1021: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
1022: wrong_line.status_text);
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

Line 1036: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');

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' ) ;
1035: END IF;
1036: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1037: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1038: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
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

Line 1037: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||

1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1035: END IF;
1036: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1037: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1038: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
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;

Line 1041: vmsg := FND_MESSAGE.GET;

1037: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1038: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
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

Line 1052: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');

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' ) ;
1051: END IF;
1052: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1053: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1054: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 1053: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1051: END IF;
1052: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1053: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1054: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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;

Line 1054: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

1050: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1051: END IF;
1052: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1053: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1054: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 1057: vmsg := FND_MESSAGE.GET;

1053: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1054: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 1105: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');

1101: wrong_line.line_Type_code ='LINE' and
1102: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1103: Then
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

Line 1106: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '

1102: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1103: Then
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)

Line 1116: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');

1112:
1113: IF l_debug_level > 0 THEN
1114: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
1115: END IF;
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;

Line 1117: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

1113: IF l_debug_level > 0 THEN
1114: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
1115: END IF;
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

Line 1118: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);

1114: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
1115: END IF;
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' ) ;

Line 1119: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);

1115: END IF;
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;

Line 1124: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

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');
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 ) ) ;

Line 1125: --FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));

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');
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;

Line 1140: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

1136:
1137: For book_line in wrong_book_lines loop
1138:
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;

Line 1141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1137: For book_line in wrong_book_lines loop
1138:
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:

Line 1148: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

1144: End If;
1145:
1146: If book_line.unit_price IS NULL
1147: Then
1148: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
1149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1150: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;

Line 1149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1145:
1146: If book_line.unit_price IS NULL
1147: Then
1148: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
1149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1150: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
1151: IF l_debug_level > 0 THEN
1152: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
1153: END IF;

Line 1156: vmsg := FND_MESSAGE.GET;

1152: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
1153: END IF;
1154: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
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;

Line 1172: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');

1168: end if;
1169: End If;
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' ) ;

Line 1173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));

1169: End If;
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;

Line 1508: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR');

1504: ,x_return_status_Text =>l_return_status_Text
1505: );
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

Line 1509: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

1505: );
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');

Line 1513: 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);
1515: OE_MSG_PUB.Add;
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;

Line 1514: 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);
1515: OE_MSG_PUB.Add;
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518: