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_API

Line 85: RAISE FND_API.G_EXC_ERROR;

81: -- Need both header rec and line rec to price the order
82:
83: IF (px_header_rec.header_id IS NULL OR
84: px_line_rec.line_id IS NULL ) THEN
85: RAISE FND_API.G_EXC_ERROR;
86: END IF;
87:
88: IF l_debug_level > 0 THEN
89: oe_debug_pub.add( 'PRICE_ORDER: SETTING REQUEST ID' , 1 ) ;

Line 235: IF (p_header_rec.pricing_date is not null and p_header_rec.pricing_date <> FND_API.G_MISS_DATE) THEN

231: l_req_line_rec.Active_date_first := p_Header_rec.Ordered_date;
232:
233: G_LINE_INDEX_TBL(px_line_index) := p_header_rec.header_id;
234: G_LINE_TYPE_CODE_TBL(px_line_index) := 'ORDER';
235: IF (p_header_rec.pricing_date is not null and p_header_rec.pricing_date <> FND_API.G_MISS_DATE) THEN
236: G_PRICING_EFFECTIVE_DATE_TBL(px_line_index)
237: := TRUNC(nvl(p_header_rec.pricing_date,sysdate));
238: ELSE
239: G_PRICING_EFFECTIVE_DATE_TBL(px_line_index)

Line 242: IF (p_header_rec.ordered_date is not null and p_header_rec.ordered_date <> FND_API.G_MISS_DATE) THEN

238: ELSE
239: G_PRICING_EFFECTIVE_DATE_TBL(px_line_index)
240: := TRUNC(sysdate);
241: END IF;
242: IF (p_header_rec.ordered_date is not null and p_header_rec.ordered_date <> FND_API.G_MISS_DATE) THEN
243: G_ACTIVE_DATE_FIRST_TBL(px_line_index)
244: := TRUNC(p_header_rec.Ordered_date);
245: ELSE
246: G_ACTIVE_DATE_FIRST_TBL(px_line_index)

Line 279: IF (p_header_rec.price_request_code is not null and p_header_rec.price_request_code <> FND_API.G_MISS_CHAR) THEN

275: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
276: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
277: G_PRICE_LIST_ID_TBL(px_line_index) :=NULL;
278: G_PL_VALIDATED_FLAG_TBL(px_line_index) := 'N';
279: IF (p_header_rec.price_request_code is not null and p_header_rec.price_request_code <> FND_API.G_MISS_CHAR) THEN
280: G_PRICE_REQUEST_CODE_TBL(px_line_index) := p_header_rec.price_request_code;
281: ELSE
282: G_PRICE_REQUEST_CODE_TBL(px_line_index) := NULL;
283: END IF;

Line 355: Elsif (p_line_rec.service_period IS NOT NULL and p_line_rec.service_period <> FND_API.G_MISS_CHAR) THEN

351: IF (p_line_rec.item_type_code = 'SERVICE' AND p_line_rec.service_period IS NULL) THEN
352: l_UOM_QUANTITY := 0;
353: Elsif (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then
354: l_UOM_QUANTITY := p_Line_rec.service_duration;
355: Elsif (p_line_rec.service_period IS NOT NULL and p_line_rec.service_period <> FND_API.G_MISS_CHAR) THEN
356: INV_CONVERT.INV_UM_CONVERSION(From_Unit => p_Line_rec.service_period
357: ,To_Unit => p_Line_rec.Order_quantity_uom
358: ,Item_ID => p_Line_rec.Inventory_item_id
359: ,Uom_Rate => l_Uom_rate);

Line 413: IF (l_line_rec.PRICING_DATE = FND_API.G_MISS_DATE) THEN

409: BEGIN
410: i := px_Line_Tbl.FIRST;
411: While i is Not Null Loop
412: l_line_rec := px_Line_Tbl(i);
413: IF (l_line_rec.PRICING_DATE = FND_API.G_MISS_DATE) THEN
414: l_line_Rec.PRICING_DATE := sysdate;
415: END IF;
416:
417: IF (l_line_rec.UNIT_LIST_PRICE_PER_PQTY = FND_API.G_MISS_NUM) THEN

Line 417: IF (l_line_rec.UNIT_LIST_PRICE_PER_PQTY = FND_API.G_MISS_NUM) THEN

413: IF (l_line_rec.PRICING_DATE = FND_API.G_MISS_DATE) THEN
414: l_line_Rec.PRICING_DATE := sysdate;
415: END IF;
416:
417: IF (l_line_rec.UNIT_LIST_PRICE_PER_PQTY = FND_API.G_MISS_NUM) THEN
418: IF (l_line_rec.UNIT_LIST_PRICE = FND_API.G_MISS_NUM) THEN
419: l_line_Rec.UNIT_LIST_PRICE := NULL;
420: END IF;
421: l_line_Rec.UNIT_LIST_PRICE_PER_PQTY := l_line_rec.UNIT_LIST_PRICE;

Line 418: IF (l_line_rec.UNIT_LIST_PRICE = FND_API.G_MISS_NUM) THEN

414: l_line_Rec.PRICING_DATE := sysdate;
415: END IF;
416:
417: IF (l_line_rec.UNIT_LIST_PRICE_PER_PQTY = FND_API.G_MISS_NUM) THEN
418: IF (l_line_rec.UNIT_LIST_PRICE = FND_API.G_MISS_NUM) THEN
419: l_line_Rec.UNIT_LIST_PRICE := NULL;
420: END IF;
421: l_line_Rec.UNIT_LIST_PRICE_PER_PQTY := l_line_rec.UNIT_LIST_PRICE;
422: END IF;

Line 423: If (l_line_rec.calculate_price_Flag is null or l_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR) THEN

419: l_line_Rec.UNIT_LIST_PRICE := NULL;
420: END IF;
421: l_line_Rec.UNIT_LIST_PRICE_PER_PQTY := l_line_rec.UNIT_LIST_PRICE;
422: END IF;
423: If (l_line_rec.calculate_price_Flag is null or l_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR) THEN
424: l_line_rec.calculate_price_flag := 'Y';
425: End IF;
426:
427: If (l_line_rec.operation is null or l_line_rec.operation = FND_API.G_MISS_CHAR) THEN

Line 427: If (l_line_rec.operation is null or l_line_rec.operation = FND_API.G_MISS_CHAR) THEN

423: If (l_line_rec.calculate_price_Flag is null or l_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR) THEN
424: l_line_rec.calculate_price_flag := 'Y';
425: End IF;
426:
427: If (l_line_rec.operation is null or l_line_rec.operation = FND_API.G_MISS_CHAR) THEN
428: l_line_rec.operation := oe_globals.g_opr_create;
429: End IF;
430:
431: l_pass_line_flag := 'N';

Line 505: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

501:
502:
503: procedure Populate_Temp_Table
504: IS
505: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
506: l_return_status_Text varchar2(240) ;
507: --
508: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
509: --

Line 553: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

549: p_actual_order_qty => G_ACTUAL_ORDER_QTY_TBL,
550: x_status_code =>l_return_status,
551: x_status_text =>l_return_status_text);
552:
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');

Line 560: RAISE FND_API.G_EXC_ERROR;

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:
563: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
564: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 598: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

594: G_ATTR_PRIMARY_UOM_FLAG_TBL,
595: l_return_status ,
596: l_return_status_text );
597:
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');

Line 605: raise fnd_api.g_exc_unexpected_error;

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:
608: END IF;
609: IF l_debug_level > 0 THEN

Line 615: RAISE FND_API.G_EXC_ERROR;

611: END IF;
612:
613: EXCEPTION
614: WHEN OTHERS THEN
615: RAISE FND_API.G_EXC_ERROR;
616: END POPULATE_TEMP_TABLE;
617:
618:
619: /*+--------------------------------------------------------------------

Line 820: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
823: OE_MSG_PUB.Add;
824: end if;

Line 837: FND_API.G_RET_STS_UNEXP_ERROR,

833: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
834: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

Line 838: FND_API.G_RET_STS_ERROR,

834: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

Line 866: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
869: OE_MSG_PUB.Add;
870: end if;

Line 885: RAISE FND_API.G_EXC_ERROR;

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
888: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||':'||L_LINE_REC.UNIT_LIST_PRICE ) ;
889: END IF;

Line 911: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
914: OE_MSG_PUB.Add;
915: end if;

Line 926: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
929: OE_MSG_PUB.Add;
930: end if;

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

931: else
932: OE_MSG_PUB.Add;
933: end if;
934: Elsif wrong_line.pricing_status_code in
935: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
936: FND_API.G_RET_STS_ERROR)
937: then
938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

Line 936: FND_API.G_RET_STS_ERROR)

932: OE_MSG_PUB.Add;
933: end if;
934: Elsif wrong_line.pricing_status_code in
935: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
936: FND_API.G_RET_STS_ERROR)
937: then
938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
940: END IF;

Line 944: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
947: OE_MSG_PUB.Add;
948: end if;

Line 960: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
963: OE_MSG_PUB.Add;
964: end if;

Line 1008: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
1011: OE_MSG_PUB.Add;
1012: end if;

Line 1024: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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;
1026: else
1027: OE_MSG_PUB.Add;
1028: end if;

Line 1040: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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;
1042: else
1043: OE_MSG_PUB.Add;
1044: end if;

Line 1056: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

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
1059: OE_MSG_PUB.Add;
1060: end if;

Line 1066: --RAISE FND_API.G_EXC_ERROR;

1062: OE_MSG_PUB.Add;
1063: end if;
1064: End if; /* wrong pricing status code */
1065:
1066: --RAISE FND_API.G_EXC_ERROR;
1067: --btea begin if do not write to db, we still need to
1068: --return line and status code to the caller
1069: -- If Not p_control_rec.p_write_to_db Then
1070: l_line_rec.Header_id := p_header_rec.Header_id;

Line 1131: RAISE FND_API.G_EXC_ERROR;

1127: IF l_debug_level > 0 THEN
1128: -- oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;
1129: NULL;
1130: END IF;
1131: RAISE FND_API.G_EXC_ERROR;
1132:
1133: end if;
1134:
1135: end loop; /* wrong_lines cursor */

Line 1155: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then

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

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: l_temp_line_rec.line_id := book_line.line_id;
1161: l_temp_line_rec.ordered_quantity := book_line.line_quantity;
1162: l_temp_line_rec.pricing_quantity := book_line.priced_quantity;
1163: --Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
1164: RAISE FND_API.G_EXC_ERROR;
1165: end if;
1166: else
1167: OE_MSG_PUB.ADD;
1168: end if;

Line 1178: RAISE FND_API.G_EXC_ERROR;

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;
1178: RAISE FND_API.G_EXC_ERROR;
1179: END IF;
1180:
1181: End loop; /* wrong booked lines */
1182: IF l_debug_level > 0 THEN

Line 1386: WHEN FND_API.G_EXC_ERROR THEN

1382: end loop;
1383: px_line_adj_tbl := l_adj_tbl;
1384:
1385: /* Exception
1386: WHEN FND_API.G_EXC_ERROR THEN
1387:
1388: --reseting global structure after engine call
1389: OE_Order_PUB.G_LINE := NULL;
1390: OE_Order_PUB.G_HDR := NULL;

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR;

1387:
1388: --reseting global structure after engine call
1389: OE_Order_PUB.G_LINE := NULL;
1390: OE_Order_PUB.G_HDR := NULL;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392:
1393: IF l_debug_level > 0 THEN
1394: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
1395: END IF;

Line 1396: RAISE FND_API.G_EXC_ERROR;

1392:
1393: IF l_debug_level > 0 THEN
1394: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
1395: END IF;
1396: RAISE FND_API.G_EXC_ERROR;
1397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1398:
1399: --reseting global structure after engine call
1400: OE_Order_PUB.G_LINE := NULL;

Line 1397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1393: IF l_debug_level > 0 THEN
1394: oe_debug_pub.add( 'EXITING PRICE_LINE WITH EXC ERROR' , 1 ) ;
1395: END IF;
1396: RAISE FND_API.G_EXC_ERROR;
1397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1398:
1399: --reseting global structure after engine call
1400: OE_Order_PUB.G_LINE := NULL;
1401: OE_Order_PUB.G_HDR := NULL;

Line 1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1398:
1399: --reseting global structure after engine call
1400: OE_Order_PUB.G_LINE := NULL;
1401: OE_Order_PUB.G_HDR := NULL;
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: IF l_debug_level > 0 THEN
1404: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
1405: END IF;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: IF l_debug_level > 0 THEN
1404: oe_debug_pub.add( 'EXITING PRICE_LINE WITH UNEXPECTED ERROR' , 1 ) ;
1405: END IF;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: WHEN OTHERS THEN
1408:
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: --reseting global structure after engine call

Line 1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1405: END IF;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: WHEN OTHERS THEN
1408:
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410: --reseting global structure after engine call
1411: OE_Order_PUB.G_LINE := NULL;
1412: OE_Order_PUB.G_HDR := NULL;
1413: IF l_debug_level > 0 THEN

Line 1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1427:
1428: IF l_debug_level > 0 THEN
1429: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.PRICE_LINE' , 1 ) ;
1430: END IF;
1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432:
1433: IF l_debug_level > 0 THEN
1434: oe_debug_pub.add( 'EXITING OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;
1435: END IF;

Line 1507: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1503: ,x_return_status =>x_return_status
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;

Line 1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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');
1514: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
1515: OE_MSG_PUB.Add;

Line 1512: ELSIF x_return_status = FND_API.G_RET_STS_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');
1514: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
1515: OE_MSG_PUB.Add;
1516: RAISE FND_API.G_EXC_ERROR;

Line 1516: RAISE FND_API.G_EXC_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:
1519: END Call_Pricing_Engine;
1520:

Line 1640: x_return_status := FND_API.G_RET_STS_SUCCESS;

1636:
1637: Update_Lines(l_Line_Tbl);
1638: Process_Adjustments(px_line_adj_tbl);
1639: px_line_rec := l_Line_Tbl(1);
1640: x_return_status := FND_API.G_RET_STS_SUCCESS;
1641:
1642: if (px_line_rec.unit_list_price is null) THEN
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: END IF;

Line 1643: x_return_status := FND_API.G_RET_STS_ERROR;

1639: px_line_rec := l_Line_Tbl(1);
1640: x_return_status := FND_API.G_RET_STS_SUCCESS;
1641:
1642: if (px_line_rec.unit_list_price is null) THEN
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: END IF;
1645:
1646:
1647: EXCEPTION

Line 1655: /* x_return_status := FND_API.G_RET_STS_SUCCESS;

1651: px_line_rec.unit_selling_price := 10.5;
1652:
1653: END Price_Order;
1654:
1655: /* x_return_status := FND_API.G_RET_STS_SUCCESS;
1656:
1657: l_price_control_rec.p_write_to_db := FALSE;
1658: l_price_control_rec.p_multiple_events := 'Y';
1659: l_price_control_rec.p_use_current_header := TRUE;