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 FND_MESSAGE

Line 619: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

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

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

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

Line 722: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497

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

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

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

Line 768: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497

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

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

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

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

1018: END IF;
1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;
1021: END IF;
1022: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1023: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1024: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

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

1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;
1021: END IF;
1022: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1023: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1024: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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;

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

1020: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;
1021: END IF;
1022: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1023: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1024: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 1027: vmsg := FND_MESSAGE.GET;

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

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

1063: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
1064: IF l_debug_level > 0 THEN
1065: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
1066: END IF;
1067: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1068: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1069: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
1070: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
1071: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

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

1064: IF l_debug_level > 0 THEN
1065: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
1066: END IF;
1067: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1068: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1069: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
1070: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
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

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

1065: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
1066: END IF;
1067: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1068: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1069: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
1070: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
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;

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

1066: END IF;
1067: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1068: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1069: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
1070: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
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

Line 1073: vmsg := FND_MESSAGE.GET;

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

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

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

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

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

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

1109: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
1110: IF l_debug_level > 0 THEN
1111: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1112: END IF;
1113: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1114: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1115: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

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

1110: IF l_debug_level > 0 THEN
1111: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1112: END IF;
1113: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1114: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1115: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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;

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

1111: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1112: END IF;
1113: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1114: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1115: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 1118: vmsg := FND_MESSAGE.GET;

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

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

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

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

1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
1128: END IF;
1129: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
1130: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 1133: vmsg := FND_MESSAGE.GET;

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

Line 1147: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497

1143: then
1144: IF l_debug_level > 0 THEN
1145: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
1146: END IF;
1147: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
1148: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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;

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

1144: IF l_debug_level > 0 THEN
1145: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
1146: END IF;
1147: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
1148: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 1151: vmsg := FND_MESSAGE.GET;

1147: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497
1148: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

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

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' ) ;
1161: END IF;
1162: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1163: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1164: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

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

1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'INVALID UOM' ) ;
1161: END IF;
1162: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1163: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1164: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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;

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

1160: oe_debug_pub.add( 'INVALID UOM' ) ;
1161: END IF;
1162: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1163: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1164: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
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

Line 1167: vmsg := FND_MESSAGE.GET;

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

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

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' ) ;
1177: END IF;
1178: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
1179:
1180: Begin
1181: Select name into l_price_list
1182: from qp_list_headers_vl a,qp_list_lines b where

Line 1196: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',

1192: instr(wrong_line.status_text,',')-1);
1193:
1194: End;
1195:
1196: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
1197: '( '||l_line_rec.Ordered_Item||' ) '||l_price_list);
1198: Begin
1199: Select name into l_price_list
1200: from qp_list_headers_vl a,qp_list_lines b where

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

1208: When invalid_number then
1209: l_price_list := substr(wrong_line.status_text,
1210: instr(wrong_line.status_text,',')+1);
1211: End;
1212: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
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

Line 1215: vmsg := FND_MESSAGE.GET;

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

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

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' ) ;
1225: END IF;
1226: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1227: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
1228: wrong_line.status_text);
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

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

1223: IF l_debug_level > 0 THEN
1224: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
1225: END IF;
1226: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1227: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
1228: wrong_line.status_text);
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;

Line 1231: vmsg := FND_MESSAGE.GET;

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

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

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' ) ;
1241: END IF;
1242: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1243: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1244: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
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

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

1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1241: END IF;
1242: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1243: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1244: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
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;

Line 1247: vmsg := FND_MESSAGE.GET;

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

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

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' ) ;
1257: END IF;
1258: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1259: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1260: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

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

1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1257: END IF;
1258: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1259: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1260: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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;

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

1256: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1257: END IF;
1258: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1259: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
1260: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
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

Line 1263: vmsg := FND_MESSAGE.GET;

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

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

1307: wrong_line.line_Type_code ='LINE' and
1308: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1309: Then
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1342:
1343: For book_line in wrong_book_lines loop
1344:
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;

Line 1347: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1343: For book_line in wrong_book_lines loop
1344:
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:

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

1350: End If;
1351:
1352: If book_line.unit_price IS NULL
1353: Then
1354: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
1355: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1356: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
1357: IF l_debug_level > 0 THEN
1358: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;

Line 1355: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1351:
1352: If book_line.unit_price IS NULL
1353: Then
1354: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
1355: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1356: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
1357: IF l_debug_level > 0 THEN
1358: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
1359: END IF;

Line 1362: vmsg := FND_MESSAGE.GET;

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

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

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

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

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

Line 1731: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');--bug#7149497

1727: ,x_return_status_Text =>l_return_status_Text
1728: );
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

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

1728: );
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

Line 1736: 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);
1738: OE_MSG_PUB.Add;
1739: RAISE FND_API.G_EXC_ERROR;
1740: END IF;

Line 1737: 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);
1738: OE_MSG_PUB.Add;
1739: RAISE FND_API.G_EXC_ERROR;
1740: END IF;
1741: