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_BULK_PRICEORDER_PVT dependencies on QP_PREQ_GRP

Line 386: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW

382: , QP_PREQ_LINES_TMP lines
383: , QP_LIST_HEADERS_B QH
384: WHERE
385: ldets.list_header_id=qh.list_header_id
386: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
387: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
388: AND lines.process_status <> 'NOT_VALID'
389: AND ldets.line_index=lines.line_index
390: AND ((nvl(ldets.automatic_flag,'N') = 'Y')

Line 387: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

383: , QP_LIST_HEADERS_B QH
384: WHERE
385: ldets.list_header_id=qh.list_header_id
386: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
387: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
388: AND lines.process_status <> 'NOT_VALID'
389: AND ldets.line_index=lines.line_index
390: AND ((nvl(ldets.automatic_flag,'N') = 'Y')
391: OR (ldets.automatic_flag = 'N' AND ldets.applied_flag = 'Y' AND ldets.updated_flag = 'Y'))

Line 558: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

554: UNIT_SELLING_PERCENT
555: , lines.line_index line_index
556: from qp_preq_lines_tmp lines
557: where lines.line_type_code='LINE'
558: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
559: and lines.process_status <> 'NOT_VALID';
560:
561: l_ordered_quantity Number;
562: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 917: (QP_PREQ_GRP.G_STATUS_UNCHANGED,

913: , qp.priced_uom_code
914: from qp_preq_lines_tmp qp
915: where process_status <> 'NOT_VALID' and
916: (pricing_status_code not in
917: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
918: QP_PREQ_GRP.G_STATUS_UPDATED,
919: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION, --uncommented for bug 3716296
920: 'NOT_VALID')
921: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));

Line 918: QP_PREQ_GRP.G_STATUS_UPDATED,

914: from qp_preq_lines_tmp qp
915: where process_status <> 'NOT_VALID' and
916: (pricing_status_code not in
917: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
918: QP_PREQ_GRP.G_STATUS_UPDATED,
919: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION, --uncommented for bug 3716296
920: 'NOT_VALID')
921: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
922: -- and l.line_id = qp.line_id;

Line 919: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION, --uncommented for bug 3716296

915: where process_status <> 'NOT_VALID' and
916: (pricing_status_code not in
917: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
918: QP_PREQ_GRP.G_STATUS_UPDATED,
919: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION, --uncommented for bug 3716296
920: 'NOT_VALID')
921: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
922: -- and l.line_id = qp.line_id;
923:

Line 1001: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND

997:
998: l_invalid_line := 'N';
999: -- add message when the price list is found to be inactive
1000: IF wrong_line.line_Type_code ='LINE' and
1001: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND
1002: Then
1003:
1004: IF l_debug_level > 0 THEN oe_debug_pub.add( 'PRICE LIST NOT FOUND1' ) ; END IF;
1005:

Line 1014: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,

1010: l_invalid_line := 'Y';
1011: END IF;
1012:
1013: If wrong_line.line_Type_code ='LINE' and
1014: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1015: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1016: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1017: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1018: FND_API.G_RET_STS_UNEXP_ERROR,

Line 1015: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,

1011: END IF;
1012:
1013: If wrong_line.line_Type_code ='LINE' and
1014: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1015: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1016: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1017: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1018: FND_API.G_RET_STS_UNEXP_ERROR,
1019: FND_API.G_RET_STS_ERROR,

Line 1016: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,

1012:
1013: If wrong_line.line_Type_code ='LINE' and
1014: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1015: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1016: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1017: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1018: FND_API.G_RET_STS_UNEXP_ERROR,
1019: FND_API.G_RET_STS_ERROR,
1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

Line 1017: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,

1013: If wrong_line.line_Type_code ='LINE' and
1014: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1015: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1016: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1017: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1018: FND_API.G_RET_STS_UNEXP_ERROR,
1019: FND_API.G_RET_STS_ERROR,
1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

Line 1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

1016: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1017: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1018: FND_API.G_RET_STS_UNEXP_ERROR,
1019: FND_API.G_RET_STS_ERROR,
1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

Line 1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

1017: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1018: FND_API.G_RET_STS_UNEXP_ERROR,
1019: FND_API.G_RET_STS_ERROR,
1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

Line 1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

1018: FND_API.G_RET_STS_UNEXP_ERROR,
1019: FND_API.G_RET_STS_ERROR,
1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1026: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

Line 1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

1019: FND_API.G_RET_STS_ERROR,
1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1026: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1027: --bug 3716296QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

Line 1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

1020: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1026: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1027: --bug 3716296QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1028: Then

Line 1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

1021: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1026: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1027: --bug 3716296QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1028: Then
1029:

Line 1026: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

1022: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1026: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1027: --bug 3716296QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1028: Then
1029:
1030: l_invalid_line := 'Y';

Line 1027: --bug 3716296QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

1023: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1024: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1025: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1026: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1027: --bug 3716296QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1028: Then
1029:
1030: l_invalid_line := 'Y';
1031: Begin

Line 1039: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then

1035: Exception When No_data_found then
1036: l_price_list := l_price_list_id;
1037: End;
1038:
1039: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
1040: IF l_debug_level > 0 THEN
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;

Line 1053: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

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
1055: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1056: END IF;
1057: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');

Line 1062: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

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' ) ;
1065: END IF;
1066: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

Line 1071: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

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)
1073: then
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

Line 1081: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

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' ) ;
1084: END IF;
1085: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

Line 1089: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

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;
1093: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

Line 1135: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then

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' ) ;
1138: END IF;
1139: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

Line 1145: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

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
1147: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1148: END IF;
1149: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');

Line 1155: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

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' ) ;
1158: END IF;
1159: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');

Line 1165: /* Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION THEN

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

Line 1277: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION;

1273: SELECT line_id, PRICING_STATUS_TEXT status_text, line_index
1274: FROM QP_PREQ_LINES_TMP
1275: WHERE LINE_TYPE_CODE='LINE'
1276: AND PROCESS_STATUS <> 'NOT_VALID'
1277: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION;
1278: BEGIN
1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add('inside check gsa');
1281: END IF;

Line 1371: l_price_control_rec QP_PREQ_GRP.control_record_type;

1367: , p_adjustments_exist IN VARCHAR2 --pibadj
1368: , x_return_status OUT NOCOPY VARCHAR2
1369: )
1370: IS
1371: l_price_control_rec QP_PREQ_GRP.control_record_type;
1372: l_request_rec oe_order_pub.request_rec_type;
1373: l_line_tbl oe_order_pub.line_tbl_type;
1374: l_multiple_events VARCHAR2(1);
1375: l_book_failed VARCHAR2(1);

Line 1485: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;

1481: l_price_control_rec.pricing_event := 'BATCH';
1482: END IF;
1483:
1484: --???Control rec set to per call level might need to be changed to per order header level.... already changed for event code
1485: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1486: l_Price_Control_Rec.Simulation_Flag := 'N';
1487: l_Price_Control_rec.temp_table_insert_flag := 'N';
1488:
1489: --l_Price_Control_rec.check_cust_view_flag := 'N';