DBA Data[Home] [Help]

APPS.OE_BULK_PRICEORDER_PVT dependencies on OE_BULK_MSG_PUB

Line 979: OE_BULK_MSG_PUB.set_msg_context

975:
976:
977: If l_debug_level > 0 Then oe_debug_pub.add('before set_msg_context'); end if;
978:
979: OE_BULK_MSG_PUB.set_msg_context
980: ( p_entity_code => 'LINE'
981: ,p_entity_id => wrong_line.line_id
982: ,p_header_id => l_header_id
983: ,p_line_id => wrong_line.line_id

Line 1009: OE_BULK_MSG_PUB.Add;

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:
1013: If wrong_line.line_Type_code ='LINE' and

Line 1050: OE_BULK_MSG_PUB.ADD;

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:
1053: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
1054: IF l_debug_level > 0 THEN

Line 1060: OE_BULK_MSG_PUB.Add;

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
1064: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;

Line 1068: OE_BULK_MSG_PUB.Add;

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,
1072: FND_API.G_RET_STS_ERROR)

Line 1079: OE_BULK_MSG_PUB.Add;

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
1083: oe_debug_pub.add( 'INVALID UOM' ) ;

Line 1088: OE_BULK_MSG_PUB.Add;

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' ) ;
1092: END IF;

Line 1133: OE_BULK_MSG_PUB.Add;

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
1137: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;

Line 1142: OE_BULK_MSG_PUB.Add;

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:
1145: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
1146: IF l_debug_level > 0 THEN

Line 1153: OE_BULK_MSG_PUB.Add;

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

Line 1163: OE_BULK_MSG_PUB.Add;

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
1166: IF (l_GSA_Enabled_Flag = 'Y') THEN
1167: IF l_gsa_violation_action = 'WARNING' THEN

Line 1171: OE_BULK_MSG_PUB.Add;

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

Line 1178: OE_BULK_MSG_PUB.Add;

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,
1182: p_line_id => wrong_line.line_id,

Line 1212: OE_BULK_MSG_PUB.Add;

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));
1216: OE_BULK_MSG_PUB.Add;

Line 1216: OE_BULK_MSG_PUB.Add;

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 ) ;
1220: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;

Line 1298: OE_BULK_MSG_PUB.set_msg_context

1294: l_change_sequence := OE_BULK_ORDER_PVT.G_Line_Rec.change_sequence(i.line_index);
1295: l_source_document_type_id := OE_BULK_ORDER_PVT.G_Line_Rec.source_document_type_id(i.line_index);
1296: l_source_document_id := OE_BULK_ORDER_PVT.G_Line_Rec.source_document_id(i.line_index);
1297: l_source_document_line_id := OE_BULK_ORDER_PVT.G_Line_Rec.source_document_line_id(i.line_index);
1298: OE_BULK_MSG_PUB.set_msg_context
1299: ( p_entity_code => 'LINE'
1300: ,p_entity_id => i.line_id
1301: ,p_header_id => l_header_id
1302: ,p_line_id => i.line_id

Line 1318: OE_BULK_MSG_PUB.Add;

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

Line 1326: OE_BULK_MSG_PUB.Add;

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
1330: (p_header_id => l_header_id,

Line 1596: OE_BULK_MSG_PUB.Add_Exc_Msg

1592: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1594: WHEN OTHERS THEN
1595: OE_GLOBALS.G_EC_INSTALLED := l_ec_installed;
1596: OE_BULK_MSG_PUB.Add_Exc_Msg
1597: (G_PKG_NAME
1598: ,'Price_Orders');
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1600: END Price_Orders;