DBA Data[Home] [Help]

APPS.OE_BULK_PRICEORDER_PVT dependencies on FND_MESSAGE

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

1002: Then
1003:
1004: IF l_debug_level > 0 THEN oe_debug_pub.add( 'PRICE LIST NOT FOUND1' ) ; END IF;
1005:
1006: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1007: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1009: OE_BULK_MSG_PUB.Add;
1010: l_invalid_line := 'Y';

Line 1007: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));

1003:
1004: IF l_debug_level > 0 THEN oe_debug_pub.add( 'PRICE LIST NOT FOUND1' ) ; END IF;
1005:
1006: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1007: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1009: OE_BULK_MSG_PUB.Add;
1010: l_invalid_line := 'Y';
1011: END IF;

Line 1008: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);

1004: IF l_debug_level > 0 THEN oe_debug_pub.add( 'PRICE LIST NOT FOUND1' ) ; END IF;
1005:
1006: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1007: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1009: OE_BULK_MSG_PUB.Add;
1010: l_invalid_line := 'Y';
1011: END IF;
1012:

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

1041: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||l_ORDERED_ITEM||l_ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
1042: null;
1043: END IF;
1044:
1045: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1046: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1047: FND_MESSAGE.SET_TOKEN('UNIT',l_Order_Quantity_uom);
1048: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
1049:

Line 1046: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));

1042: null;
1043: END IF;
1044:
1045: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1046: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1047: FND_MESSAGE.SET_TOKEN('UNIT',l_Order_Quantity_uom);
1048: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
1049:
1050: OE_BULK_MSG_PUB.ADD;

Line 1047: FND_MESSAGE.SET_TOKEN('UNIT',l_Order_Quantity_uom);

1043: END IF;
1044:
1045: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1046: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1047: FND_MESSAGE.SET_TOKEN('UNIT',l_Order_Quantity_uom);
1048: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
1049:
1050: OE_BULK_MSG_PUB.ADD;
1051:

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

1044:
1045: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1046: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1047: FND_MESSAGE.SET_TOKEN('UNIT',l_Order_Quantity_uom);
1048: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
1049:
1050: OE_BULK_MSG_PUB.ADD;
1051:
1052:

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

1053: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1056: END IF;
1057: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1058: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1059: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1060: OE_BULK_MSG_PUB.Add;
1061:

Line 1058: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));

1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1056: END IF;
1057: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1058: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1059: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1060: OE_BULK_MSG_PUB.Add;
1061:
1062: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

Line 1059: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);

1055: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1056: END IF;
1057: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1058: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1059: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1060: OE_BULK_MSG_PUB.Add;
1061:
1062: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
1063: IF l_debug_level > 0 THEN

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

1062: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
1063: IF l_debug_level > 0 THEN
1064: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
1065: END IF;
1066: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
1067: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1068: OE_BULK_MSG_PUB.Add;
1069:
1070: Elsif wrong_line.pricing_status_code in

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

1063: IF l_debug_level > 0 THEN
1064: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
1065: END IF;
1066: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
1067: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1068: OE_BULK_MSG_PUB.Add;
1069:
1070: Elsif wrong_line.pricing_status_code in
1071: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

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

1073: then
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
1076: END IF;
1077: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
1078: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1079: OE_BULK_MSG_PUB.Add;
1080:
1081: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

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

1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
1076: END IF;
1077: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
1078: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1079: OE_BULK_MSG_PUB.Add;
1080:
1081: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
1082: IF l_debug_level > 0 THEN

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

1081: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add( 'INVALID UOM' ) ;
1084: END IF;
1085: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1086: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1087: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1088: OE_BULK_MSG_PUB.Add;
1089: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

Line 1086: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));

1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add( 'INVALID UOM' ) ;
1084: END IF;
1085: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1086: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1087: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1088: OE_BULK_MSG_PUB.Add;
1089: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
1090: IF l_debug_level > 0 THEN

Line 1087: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);

1083: oe_debug_pub.add( 'INVALID UOM' ) ;
1084: END IF;
1085: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1086: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1087: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1088: OE_BULK_MSG_PUB.Add;
1089: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
1090: IF l_debug_level > 0 THEN
1091: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;

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

1089: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
1090: IF l_debug_level > 0 THEN
1091: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;
1092: END IF;
1093: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
1094:
1095: Begin
1096: Select name into l_price_list
1097: from qp_list_headers_vl a,qp_list_lines b where

Line 1111: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',

1107: instr(wrong_line.status_text,',')-1);
1108:
1109: End;
1110:
1111: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
1112: '( '||l_Ordered_Item||' ) '||l_price_list);
1113:
1114:
1115:

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

1128: l_price_list := substr(wrong_line.status_text,
1129: instr(wrong_line.status_text,',')+1);
1130: End;
1131:
1132: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
1133: OE_BULK_MSG_PUB.Add;
1134:
1135: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
1136: IF l_debug_level > 0 THEN

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

1135: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
1136: IF l_debug_level > 0 THEN
1137: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
1138: END IF;
1139: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1140: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_Ordered_Item||' ) '||
1141: wrong_line.status_text);
1142: OE_BULK_MSG_PUB.Add;
1143:

Line 1140: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_Ordered_Item||' ) '||

1136: IF l_debug_level > 0 THEN
1137: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
1138: END IF;
1139: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1140: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_Ordered_Item||' ) '||
1141: wrong_line.status_text);
1142: OE_BULK_MSG_PUB.Add;
1143:
1144:

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

1145: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
1146: IF l_debug_level > 0 THEN
1147: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1148: END IF;
1149: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1150: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1151: l_Ordered_Item||' ) '||wrong_line.status_text);
1152:
1153: OE_BULK_MSG_PUB.Add;

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

1146: IF l_debug_level > 0 THEN
1147: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1148: END IF;
1149: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1150: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1151: l_Ordered_Item||' ) '||wrong_line.status_text);
1152:
1153: OE_BULK_MSG_PUB.Add;
1154:

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

1155: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1158: END IF;
1159: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1160: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1161: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1162:
1163: OE_BULK_MSG_PUB.Add;

Line 1160: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));

1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1158: END IF;
1159: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1160: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1161: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1162:
1163: OE_BULK_MSG_PUB.Add;
1164: --bug 3716296

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

1157: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1158: END IF;
1159: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1160: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1161: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1162:
1163: OE_BULK_MSG_PUB.Add;
1164: --bug 3716296
1165: /* Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION THEN

Line 1168: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');

1164: --bug 3716296
1165: /* Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION THEN
1166: IF (l_GSA_Enabled_Flag = 'Y') THEN
1167: IF l_gsa_violation_action = 'WARNING' THEN
1168: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
1169: l_msg_text := wrong_line.status_text||' ( '||nvl(l_ordered_item,l_inventory_item_id)||' )';
1170: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
1171: OE_BULK_MSG_PUB.Add;
1172:

Line 1170: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);

1166: IF (l_GSA_Enabled_Flag = 'Y') THEN
1167: IF l_gsa_violation_action = 'WARNING' THEN
1168: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
1169: l_msg_text := wrong_line.status_text||' ( '||nvl(l_ordered_item,l_inventory_item_id)||' )';
1170: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
1171: OE_BULK_MSG_PUB.Add;
1172:
1173: IF l_debug_level > 0 THEN
1174: oe_debug_pub.add(' GSA warning occured on line_id:'||wrong_line.line_id);

Line 1177: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');

1173: IF l_debug_level > 0 THEN
1174: oe_debug_pub.add(' GSA warning occured on line_id:'||wrong_line.line_id);
1175: END IF;
1176: ELSE --violation action is error
1177: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
1178: OE_BULK_MSG_PUB.Add;
1179: -- Apply GSA Hold
1180: OE_Bulk_Holds_Pvt.Apply_GSA_Hold
1181: (p_header_id => l_header_id,

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

1204: IF wrong_line.line_type_code='LINE' and
1205: (wrong_line.unit_price <0 or wrong_line.adjusted_unit_price<0)
1206: Then
1207:
1208: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
1209: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1210: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
1211: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1212: OE_BULK_MSG_PUB.Add;

Line 1209: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));

1205: (wrong_line.unit_price <0 or wrong_line.adjusted_unit_price<0)
1206: Then
1207:
1208: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
1209: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1210: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
1211: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1212: OE_BULK_MSG_PUB.Add;
1213:

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

1206: Then
1207:
1208: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
1209: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1210: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
1211: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1212: OE_BULK_MSG_PUB.Add;
1213:
1214: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

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

1207:
1208: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
1209: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1210: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
1211: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1212: OE_BULK_MSG_PUB.Add;
1213:
1214: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
1215: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));

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

1210: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
1211: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1212: OE_BULK_MSG_PUB.Add;
1213:
1214: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
1215: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
1216: OE_BULK_MSG_PUB.Add;
1217:
1218: IF l_debug_level > 0 THEN

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

1211: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
1212: OE_BULK_MSG_PUB.Add;
1213:
1214: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
1215: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
1216: OE_BULK_MSG_PUB.Add;
1217:
1218: IF l_debug_level > 0 THEN
1219: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;

Line 1315: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');

1311: );
1312:
1313: IF (l_GSA_Enabled_Flag = 'Y') THEN
1314: IF l_gsa_violation_action = 'WARNING' THEN
1315: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
1316: l_msg_text := i.status_text||' ( '||nvl(l_ordered_item,l_inventory_item_id)||' )';
1317: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
1318: OE_BULK_MSG_PUB.Add;
1319:

Line 1317: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);

1313: IF (l_GSA_Enabled_Flag = 'Y') THEN
1314: IF l_gsa_violation_action = 'WARNING' THEN
1315: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
1316: l_msg_text := i.status_text||' ( '||nvl(l_ordered_item,l_inventory_item_id)||' )';
1317: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
1318: OE_BULK_MSG_PUB.Add;
1319:
1320: IF l_debug_level > 0 THEN
1321: oe_debug_pub.add(' GSA warning occured on line_id:'||i.line_id);

Line 1325: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');

1321: oe_debug_pub.add(' GSA warning occured on line_id:'||i.line_id);
1322: END IF;
1323: ELSE --violation action is error
1324: /* bug 3735141
1325: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
1326: OE_BULK_MSG_PUB.Add;
1327: */
1328: -- Apply GSA Hold
1329: OE_Bulk_Holds_Pvt.Apply_GSA_Hold