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 OE_DEBUG_PUB

Line 121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

117: Procedure Preprocessing(
118: px_Header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
119: ,px_Line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
120: ) AS
121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
122: BEGIN
123: -- Need both header rec and line rec to price the order
124:
125: IF (px_line_rec.line_id IS NULL

Line 142: oe_debug_pub.add( 'PRICE_ORDER: SETTING REQUEST ID' , 1 ) ;

138: px_header_rec := oe_header_util.query_row(px_line_rec.header_id);
139: END IF;
140:
141: IF l_debug_level > 0 THEN
142: oe_debug_pub.add( 'PRICE_ORDER: SETTING REQUEST ID' , 1 ) ;
143: END IF;
144:
145: G_PASS_LINE_TBL.delete;
146: qp_price_request_context.set_request_id;

Line 149: oe_debug_pub.add( ' REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;

145: G_PASS_LINE_TBL.delete;
146: qp_price_request_context.set_request_id;
147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( ' REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
150: END IF;
151:
152: -- Use the given header to price
153: OE_ORDER_PUB.g_hdr := px_header_rec;

Line 162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

158: )
159: IS
160: i pls_integer;
161: j pls_integer;
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: BEGIN
164: -- HTML change
165:
166: j := 1;

Line 172: oe_debug_pub.add('adding adjustment:'||j);

168: while i is not null loop
169: IF ((px_line_adj_tbl(i).modifier_level_code='ORDER' OR G_PASS_LINE_TBL.exists(px_Line_Adj_Tbl(i).line_id)) AND px_line_adj_tbl(i).list_line_id IS NOT NULL and px_line_adj_tbl(i).applied_flag='Y') THEN
170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add('adding adjustment:'||j);
173: END IF;
174:
175: BEGIN
176: select

Line 248: oe_debug_pub.add('after adding adjustment:'||j);

244: G_LDET_BREAK_UOM_CONTEXT(j) := NULL;
245: G_LDET_BREAK_UOM_ATTRIBUTE(j) := NULL;
246:
247: IF l_debug_level > 0 THEN
248: oe_debug_pub.add('after adding adjustment:'||j);
249: END IF;
250:
251: j := j + 1;
252:

Line 259: oe_debug_pub.add('wrong in insert manual adj'||SQLERRM);

255: end loop;
256: exception
257: when others then
258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add('wrong in insert manual adj'||SQLERRM);
260: END IF;
261: RAISE FND_API.G_EXC_ERROR;
262: END Insert_Manual_Adj;
263:

Line 275: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

271: is
272: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
273: --l_line_index pls_integer := px_req_line_tbl.count;
274: --
275: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
276: --
277: begin
278: G_STMT_NO := 'copy_Header_to_request#10';
279: IF l_debug_level > 0 THEN

Line 280: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;

276: --
277: begin
278: G_STMT_NO := 'copy_Header_to_request#10';
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
281: END IF;
282:
283: --l_line_index := l_line_index+1;
284: px_line_index := px_line_index+1;

Line 351: oe_debug_pub.add( 'EXISTING OE_ORDER_PRICE_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;

347: G_CATCHWEIGHT_QTY_TBL(px_line_index) := NULL;
348: G_ACTUAL_ORDER_QTY_TBL(px_line_index):=NULL;
349:
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add( 'EXISTING OE_ORDER_PRICE_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
352: END IF;
353:
354: end copy_Header_to_request;
355:

Line 381: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

377: x_item_rec OE_Order_Cache.Item_Rec_Type;
378: l_UOM_QUANTITY NUMBER;
379: l_Calculate_Price_Flag varchar2(1);
380: --
381: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
382: --
383: begin
384:
385: px_line_index := px_line_index + 1;

Line 401: oe_debug_pub.add( 'QUANTITY'||L_REQ_LINE_REC.LINE_QUANTITY||' '||L_REQ_LINE_REC.PRICED_QUANTITY , 3 ) ;

397: G_ACTIVE_DATE_SECOND_TYPE_TBL(px_line_index):= NULL;
398: END IF;
399: /*
400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add( 'QUANTITY'||L_REQ_LINE_REC.LINE_QUANTITY||' '||L_REQ_LINE_REC.PRICED_QUANTITY , 3 ) ;
402: END IF;
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add( 'PRICE FLAG'||L_REQ_LINE_REC.PRICE_FLAG ) ;
405: END IF;

Line 404: oe_debug_pub.add( 'PRICE FLAG'||L_REQ_LINE_REC.PRICE_FLAG ) ;

400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add( 'QUANTITY'||L_REQ_LINE_REC.LINE_QUANTITY||' '||L_REQ_LINE_REC.PRICED_QUANTITY , 3 ) ;
402: END IF;
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add( 'PRICE FLAG'||L_REQ_LINE_REC.PRICE_FLAG ) ;
405: END IF;
406: */
407: G_LINE_QUANTITY_TBL(px_line_index) := p_line_rec.ordered_quantity;
408: G_LINE_UOM_CODE_TBL(px_line_index) := p_line_rec.order_quantity_uom;

Line 432: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( PX_LINE_INDEX ) ) ;

428: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
429: G_PRICE_FLAG_TBL(px_line_index) := nvl(p_line_rec.CALCULATE_PRICE_FLAG,'Y');
430: G_LINE_ID_TBL(px_line_index) := p_line_rec.LINE_ID;
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( PX_LINE_INDEX ) ) ;
433: END IF;
434: G_ROUNDING_FLAG_TBL(px_line_index) := 'Q';
435: G_ROUNDING_FACTOR_TBL(px_line_index) := NULL;
436: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;

Line 450: oe_debug_pub.add( 'EXISTING OE_ORDER_PRICE_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;

446: G_LINE_CATEGORY_TBL(px_line_index) := p_line_rec.line_category_code;
447: G_catchweight_qty_tbl(px_line_index) := NULL;
448: g_actual_order_qty_tbl(px_line_index):= NULL;
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add( 'EXISTING OE_ORDER_PRICE_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
451: END IF;
452:
453: end copy_Line_to_request;
454:

Line 461: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

457: , px_Line_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
458: , p_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE
459: , p_pricing_events IN VARCHAR2
460: ) IS
461: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
462: l_pass_line_flag VARCHAR2(1);
463: l_check_line_flag VARCHAR2(1);
464: l_source_line_flag VARCHAR2(1);
465: l_line_rec OE_ORDER_PUB.Line_Rec_Type;

Line 569: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

565: IS
566: l_return_status varchar2(1);
567: l_return_status_Text varchar2(240) ;
568: --
569: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
570: --
571: BEGIN
572: l_return_status := FND_API.G_RET_STS_SUCCESS;
573: IF l_debug_level > 0 THEN

Line 574: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;

570: --
571: BEGIN
572: l_return_status := FND_API.G_RET_STS_SUCCESS;
573: IF l_debug_level > 0 THEN
574: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
575: END IF;
576: QP_PREQ_GRP.INSERT_LINES2
577: (p_LINE_INDEX => G_LINE_INDEX_TBL,
578: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,

Line 617: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;

613: x_status_text =>l_return_status_text);
614:
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;

Line 627: oe_debug_pub.add( 'inserting adjustments:'||G_LDET_LINE_DETAIL_INDEX.count);

623: END IF;
624:
625: IF G_LDET_LINE_DETAIL_INDEX.count > 0 THEN
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'inserting adjustments:'||G_LDET_LINE_DETAIL_INDEX.count);
628: oe_debug_pub.add('first:'||G_LDET_LINE_INDEX.first||' last:'||G_LDET_LINE_INDEX.last);
629: FOR i in G_LDET_LINE_DETAIL_INDEX.first..G_LDET_LINE_DETAIL_INDEX.last LOOP
630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));
631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));

Line 628: oe_debug_pub.add('first:'||G_LDET_LINE_INDEX.first||' last:'||G_LDET_LINE_INDEX.last);

624:
625: IF G_LDET_LINE_DETAIL_INDEX.count > 0 THEN
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'inserting adjustments:'||G_LDET_LINE_DETAIL_INDEX.count);
628: oe_debug_pub.add('first:'||G_LDET_LINE_INDEX.first||' last:'||G_LDET_LINE_INDEX.last);
629: FOR i in G_LDET_LINE_DETAIL_INDEX.first..G_LDET_LINE_DETAIL_INDEX.last LOOP
630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));
631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));
632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));

Line 630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));

626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'inserting adjustments:'||G_LDET_LINE_DETAIL_INDEX.count);
628: oe_debug_pub.add('first:'||G_LDET_LINE_INDEX.first||' last:'||G_LDET_LINE_INDEX.last);
629: FOR i in G_LDET_LINE_DETAIL_INDEX.first..G_LDET_LINE_DETAIL_INDEX.last LOOP
630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));
631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));
632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));
633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));

Line 631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));

627: oe_debug_pub.add( 'inserting adjustments:'||G_LDET_LINE_DETAIL_INDEX.count);
628: oe_debug_pub.add('first:'||G_LDET_LINE_INDEX.first||' last:'||G_LDET_LINE_INDEX.last);
629: FOR i in G_LDET_LINE_DETAIL_INDEX.first..G_LDET_LINE_DETAIL_INDEX.last LOOP
630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));
631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));
632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));
633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));

Line 632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));

628: oe_debug_pub.add('first:'||G_LDET_LINE_INDEX.first||' last:'||G_LDET_LINE_INDEX.last);
629: FOR i in G_LDET_LINE_DETAIL_INDEX.first..G_LDET_LINE_DETAIL_INDEX.last LOOP
630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));
631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));
632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));
633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));

Line 633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));

629: FOR i in G_LDET_LINE_DETAIL_INDEX.first..G_LDET_LINE_DETAIL_INDEX.last LOOP
630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));
631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));
632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));
633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));

Line 634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));

630: oe_debug_pub.add('1:'||G_LDET_LINE_DETAIL_INDEX(i));
631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));
632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));
633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));

Line 635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));

631: oe_debug_pub.add('2:'||G_LDET_LINE_DETAIL_TYPE_CODE(i));
632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));
633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));

Line 636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));

632: oe_debug_pub.add('3:'||G_LDET_LINE_INDEX(i));
633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));

Line 637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));

633: oe_debug_pub.add('4:'||G_LDET_PRICE_BREAK_TYPE_CODE(i));
634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));

Line 638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));

634: oe_debug_pub.add('5:'||G_LDET_LIST_HEADER_ID(i));
635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));

Line 639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));

635: oe_debug_pub.add('6:'||G_LDET_LIST_LINE_ID(i));
636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));

Line 640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));

636: oe_debug_pub.add('7:'||G_LDET_LIST_LINE_TYPE(i));
637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));

Line 641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));

637: oe_debug_pub.add('8:'||G_LDET_LIST_TYPE_CODE(i));
638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));

Line 642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));

638: oe_debug_pub.add('9:'||G_LDET_PRICING_GROUP_SEQUENCE(i));
639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));

Line 643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));

639: oe_debug_pub.add('10:'||G_LDET_PRICING_PHASE_ID(i));
640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));

Line 644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));

640: oe_debug_pub.add('11:'||G_LDET_OPERATOR(i));
641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));

Line 645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));

641: oe_debug_pub.add('12:'||G_LDET_OPERAND_VALUE(i));
642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));

Line 646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));

642: oe_debug_pub.add('13:'||G_LDET_SUBSTITUTION_TYPE_CODE(i));
643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));

Line 647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));

643: oe_debug_pub.add('14:'||G_LDET_SUBSTITUTION_VALUE_FROM(i));
644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));

Line 648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));

644: oe_debug_pub.add('15:'||G_LDET_SUBSTITUTION_VALUE_TO(i));
645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));

Line 649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));

645: oe_debug_pub.add('16:'||G_LDET_PRICE_FORMULA_ID(i));
646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));

Line 650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));

646: oe_debug_pub.add('17:'||G_LDET_PRODUCT_PRECEDENCE(i));
647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));

Line 651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));

647: oe_debug_pub.add('18:'||G_LDET_INCOM_GRP_CODE(i));
648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));

Line 652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));

648: oe_debug_pub.add('19:'||G_LDET_APPLIED_FLAG(i));
649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));

Line 653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));

649: oe_debug_pub.add('20:'||G_LDET_AUTOMATIC_FLAG(i));
650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));

Line 654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));

650: oe_debug_pub.add('21:'||G_LDET_OVERRIDE_FLAG(i));
651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));

Line 655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));

651: oe_debug_pub.add('22:'||G_LDET_MODIFIER_LEVEL_CODE(i));
652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));

Line 656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));

652: oe_debug_pub.add('23:'||G_LDET_BENEFIT_QTY(i));
653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));

Line 657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));

653: oe_debug_pub.add('24:'||G_LDET_BENEFIT_UOM_CODE(i));
654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));

Line 658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));

654: oe_debug_pub.add('25:'||G_LDET_LIST_LINE_NO(i));
655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));

Line 659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));

655: oe_debug_pub.add('26:'||G_LDET_ACCRUAL_FLAG(i));
656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));

Line 660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));

656: oe_debug_pub.add('27:'||G_LDET_ACCRUAL_CONVERSION_RATE(i));
657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));

Line 661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));

657: oe_debug_pub.add('28:'||G_LDET_ESTIM_ACCRUAL_RATE(i));
658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));

Line 662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));

658: oe_debug_pub.add('29:'||G_LDET_CHARGE_TYPE_CODE(i));
659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));

Line 663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));

659: oe_debug_pub.add('30:'||G_LDET_CHARGE_SUBTYPE_CODE(i));
660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));

Line 664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));

660: oe_debug_pub.add('31:'||G_LDET_LINE_QUANTITY(i));
661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));
668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));

Line 665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));

661: oe_debug_pub.add('32:'||G_LDET_UPDATED_FLAG(i));
662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));
668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));
669: oe_debug_pub.add('40:'||G_LDET_BREAK_UOM_CONTEXT(i));

Line 666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));

662: oe_debug_pub.add('33:'||G_LDET_CALCULATION_CODE(i));
663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));
668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));
669: oe_debug_pub.add('40:'||G_LDET_BREAK_UOM_CONTEXT(i));
670: oe_debug_pub.add('41:'||G_LDET_BREAK_UOM_ATTRIBUTE(i));

Line 667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));

663: oe_debug_pub.add('34:'||G_LDET_CHANGE_REASON_CODE(i));
664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));
668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));
669: oe_debug_pub.add('40:'||G_LDET_BREAK_UOM_CONTEXT(i));
670: oe_debug_pub.add('41:'||G_LDET_BREAK_UOM_ATTRIBUTE(i));
671: END LOOP;

Line 668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));

664: oe_debug_pub.add('35:'||G_LDET_CHANGE_REASON_TEXT(i));
665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));
668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));
669: oe_debug_pub.add('40:'||G_LDET_BREAK_UOM_CONTEXT(i));
670: oe_debug_pub.add('41:'||G_LDET_BREAK_UOM_ATTRIBUTE(i));
671: END LOOP;
672: END IF;

Line 669: oe_debug_pub.add('40:'||G_LDET_BREAK_UOM_CONTEXT(i));

665: oe_debug_pub.add('36:'||G_LDET_ACCUM_CONTEXT(i));
666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));
668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));
669: oe_debug_pub.add('40:'||G_LDET_BREAK_UOM_CONTEXT(i));
670: oe_debug_pub.add('41:'||G_LDET_BREAK_UOM_ATTRIBUTE(i));
671: END LOOP;
672: END IF;
673:

Line 670: oe_debug_pub.add('41:'||G_LDET_BREAK_UOM_ATTRIBUTE(i));

666: oe_debug_pub.add('37:'||G_LDET_ACCUM_ATTRIBUTE(i));
667: oe_debug_pub.add('38:'||G_LDET_ACCUM_FLAG(i));
668: oe_debug_pub.add('39:'||G_LDET_BREAK_UOM_CODE(i));
669: oe_debug_pub.add('40:'||G_LDET_BREAK_UOM_CONTEXT(i));
670: oe_debug_pub.add('41:'||G_LDET_BREAK_UOM_ATTRIBUTE(i));
671: END LOOP;
672: END IF;
673:
674: QP_PREQ_GRP.INSERT_LDETS2

Line 720: oe_debug_pub.add( 'ERROR INSERTING INTO LINE DETAILS'||SQLERRM ) ;

716: x_status_code => l_return_status,
717: x_status_text => l_return_status_text);
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;

Line 766: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;

762: l_return_status_text );
763:
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;

Line 776: oe_debug_pub.add( 'AFTER DIRECT INSERT INTO TEMP TABLE: BULK INSERT' , 1 ) ;

772: END IF;
773:
774: END IF;
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'AFTER DIRECT INSERT INTO TEMP TABLE: BULK INSERT' , 1 ) ;
777: END IF;
778:
779: EXCEPTION
780: WHEN OTHERS THEN

Line 793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

789: */
790: PROCEDURE Reset_All_Tbls
791: AS
792: --
793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
794: --
795: BEGIN
796: G_LINE_INDEX_tbl.delete;
797: G_LINE_TYPE_CODE_TBL.delete ;

Line 897: oe_debug_pub.add( 'Reset all tables: '||SQLERRM , 1 ) ;

893:
894: EXCEPTION
895: WHEN OTHERS THEN
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add( 'Reset all tables: '||SQLERRM , 1 ) ;
898: END IF;
899: END reset_all_tbls;
900:
901: procedure Report_Engine_Errors(

Line 963: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

959: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
960: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
961: -- );
962: --
963: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
964: --
965: begin
966: -- Update Order Lines
967: IF l_debug_level > 0 THEN

Line 968: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.REPORT_ENGINE_ERROR' , 1 ) ;

964: --
965: begin
966: -- Update Order Lines
967: IF l_debug_level > 0 THEN
968: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.REPORT_ENGINE_ERROR' , 1 ) ;
969: END IF;
970: G_STMT_NO := 'Report_Engine_Error#10';
971:
972: l_allow_negative_price := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');

Line 979: oe_debug_pub.add( 'ERROR '||J||' LINE'||PX_LINE_TBL ( J ) .LINE_ID||' '||WRONG_LINE.LINE_ID ) ;

975:
976: J:= px_Line_Tbl.First;
977: While J is not null loop
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add( 'ERROR '||J||' LINE'||PX_LINE_TBL ( J ) .LINE_ID||' '||WRONG_LINE.LINE_ID ) ;
980: END IF;
981: If px_Line_Tbl(j).line_id = wrong_line.line_id
982: --or
983: -- J = wrong_line.line_index

Line 987: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_LIST_PRICE||'+'||L_LINE_REC.UNIT_LIST_PRICE_PER_PQTY ) ;

983: -- J = wrong_line.line_index
984: then
985: l_line_rec := px_Line_Tbl(J);
986: IF l_debug_level > 0 THEN
987: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_LIST_PRICE||'+'||L_LINE_REC.UNIT_LIST_PRICE_PER_PQTY ) ;
988: END IF;
989: exit;
990: End if;
991: J:= px_Line_Tbl.next(j);

Line 1010: oe_debug_pub.add( 'THE STATUS'||WRONG_LINE.PRICING_STATUS_CODE||':'||WRONG_LINE.PROCESSED_CODE||':'||WRONG_LINE.STATUS_TEXT ) ;

1006: ,p_source_document_line_id => l_line_rec.source_document_line_id
1007: );
1008:
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'THE STATUS'||WRONG_LINE.PRICING_STATUS_CODE||':'||WRONG_LINE.PROCESSED_CODE||':'||WRONG_LINE.STATUS_TEXT ) ;
1011: END IF;
1012: l_invalid_line := 'N';
1013: -- add message when the price list is found to be inactive
1014: IF wrong_line.line_Type_code ='LINE' and

Line 1017: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;

1013: -- add message when the price list is found to be inactive
1014: IF wrong_line.line_Type_code ='LINE' and
1015: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1018: END IF;
1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;
1021: END IF;

Line 1020: oe_debug_pub.add( 'LINDA , INVALID PRICE LIST ' , 1 ) ;

1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'PRICE LIST NOT 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);

Line 1065: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;

1061: End;
1062:
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);

Line 1081: oe_debug_pub.add( 'BEFORE CHECKING BOOK FLAG' ) ;

1077: else
1078: OE_MSG_PUB.Add;
1079: end if;
1080: IF l_debug_level > 0 THEN
1081: oe_debug_pub.add( 'BEFORE CHECKING BOOK FLAG' ) ;
1082: END IF;
1083:
1084: If nvl(l_line_rec.booked_flag,'X') = 'Y' Then
1085: IF l_debug_level > 0 THEN

Line 1086: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;

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

Line 1094: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||':'||L_LINE_REC.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
1094: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||':'||L_LINE_REC.UNIT_LIST_PRICE ) ;
1095: END IF;
1096:
1097: --Fix bug 1650637
1098: If (l_line_rec.unit_selling_price Is Not Null or

Line 1111: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;

1107:
1108:
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);

Line 1127: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;

1123: OE_MSG_PUB.Add;
1124: end if;
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

Line 1145: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

1141: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
1142: FND_API.G_RET_STS_ERROR)
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

Line 1160: oe_debug_pub.add( 'INVALID UOM' ) ;

1156: OE_MSG_PUB.Add;
1157: end if;
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);

Line 1176: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;

1172: OE_MSG_PUB.Add;
1173: end if;
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

Line 1224: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;

1220: OE_MSG_PUB.Add;
1221: end if;
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);

Line 1240: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;

1236: OE_MSG_PUB.Add;
1237: end if;
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);

Line 1256: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;

1252: OE_MSG_PUB.Add;
1253: end if;
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);

Line 1291: oe_debug_pub.add( 'J IS '||J ) ;

1287: --since the line_rec doesn't have the place holder to hold error status
1288: l_line_rec.industry_attribute30
1289: := wrong_line.pricing_status_code;
1290: IF l_debug_level > 0 THEN
1291: oe_debug_pub.add( 'J IS '||J ) ;
1292: END IF;
1293: if (j<>0) THEN
1294: px_line_tbl(j) := l_line_rec;
1295: END IF;

Line 1298: oe_debug_pub.add( 'PASSING BACK PRICE'||L_LINE_REC.UNIT_LIST_PRICE||' '||L_LINE_REC.UNIT_SELLING_PRICE ) ;

1294: px_line_tbl(j) := l_line_rec;
1295: END IF;
1296:
1297: IF l_debug_level > 0 THEN
1298: oe_debug_pub.add( 'PASSING BACK PRICE'||L_LINE_REC.UNIT_LIST_PRICE||' '||L_LINE_REC.UNIT_SELLING_PRICE ) ;
1299: END IF;
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'LINE'||L_LINE_REC.HEADER_ID||'+'||L_LINE_REC.LINE_ID ) ;
1302: END IF;

Line 1301: oe_debug_pub.add( 'LINE'||L_LINE_REC.HEADER_ID||'+'||L_LINE_REC.LINE_ID ) ;

1297: IF l_debug_level > 0 THEN
1298: oe_debug_pub.add( 'PASSING BACK PRICE'||L_LINE_REC.UNIT_LIST_PRICE||' '||L_LINE_REC.UNIT_SELLING_PRICE ) ;
1299: END IF;
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'LINE'||L_LINE_REC.HEADER_ID||'+'||L_LINE_REC.LINE_ID ) ;
1302: END IF;
1303: -- End If;
1304: --btea end
1305:

Line 1320: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;

1316: (wrong_line.unit_price <0 or wrong_line.adjusted_unit_price<0)
1317: Then
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);

Line 1328: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;

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

Line 1334: -- oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;

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;
1336: END IF;
1337: RAISE FND_API.G_EXC_ERROR;
1338:

Line 1358: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;

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

Line 1382: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;

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;
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386:

Line 1389: oe_debug_pub.add( 'EXITING REPORT_ENGINE_ERRORS' ) ;

1385: END IF;
1386:
1387: End loop; /* wrong booked lines */
1388: IF l_debug_level > 0 THEN
1389: oe_debug_pub.add( 'EXITING REPORT_ENGINE_ERRORS' ) ;
1390: END IF;
1391: End Report_Engine_Errors;
1392:
1393: Procedure Calculate_Adjustments(

Line 1404: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1400: ,p_Simulation_Flag IN VARCHAR2
1401: ,p_Get_Freight_Flag IN VARCHAR2
1402: ,x_Return_Status OUT NOCOPY VARCHAR2 )
1403: IS
1404: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1405: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
1406: BEGIN
1407:
1408:

Line 1436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1432: ,p_Action_Code IN VARCHAR2
1433: ,x_Return_Status OUT NOCOPY VARCHAR2 )
1434: Is
1435: i PLS_INTEGER;
1436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1437: Cursor adj_cur IS
1438: SELECT /*+ ORDERED USE_NL(ldets lines qh) */
1439: oe_price_adjustments_s.nextval price_adjustment_id
1440: , oe_order_pub.g_hdr.header_id header_id

Line 1608: oe_debug_pub.add( 'EXITING OE_PRICE_ORDER_PVT.PROCESS_ADJUSTMENTS' , 1 ) ;

1604: end loop;
1605: px_line_adj_tbl := l_adj_tbl;
1606:
1607: IF l_debug_level > 0 THEN
1608: oe_debug_pub.add( 'EXITING OE_PRICE_ORDER_PVT.PROCESS_ADJUSTMENTS' , 1 ) ;
1609: END IF;
1610:
1611:
1612: EXCEPTION

Line 1621: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR' , 1 ) ;

1617: OE_Order_PUB.G_HDR := NULL;
1618: x_return_status := FND_API.G_RET_STS_ERROR;
1619:
1620: IF l_debug_level > 0 THEN
1621: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH EXC ERROR' , 1 ) ;
1622: END IF;
1623: RAISE FND_API.G_EXC_ERROR;
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625:

Line 1631: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR' , 1 ) ;

1627: OE_Order_PUB.G_LINE := NULL;
1628: OE_Order_PUB.G_HDR := NULL;
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: IF l_debug_level > 0 THEN
1631: oe_debug_pub.add( 'EXITING PROCESS_ADJUSTMENTS WITH UNEXPECTED ERROR' , 1 ) ;
1632: END IF;
1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1634: WHEN OTHERS THEN
1635:

Line 1641: oe_debug_pub.add( 'ERROR IN OE_PRICE_ORDER_PVT.Process_Adjustments' , 1 ) ;

1637: --reseting global structure after engine call
1638: OE_Order_PUB.G_LINE := NULL;
1639: OE_Order_PUB.G_HDR := NULL;
1640: IF l_debug_level > 0 THEN
1641: oe_debug_pub.add( 'ERROR IN OE_PRICE_ORDER_PVT.Process_Adjustments' , 1 ) ;
1642: END IF;
1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( SQLERRM , 1 ) ;
1645: END IF;

Line 1644: oe_debug_pub.add( SQLERRM , 1 ) ;

1640: IF l_debug_level > 0 THEN
1641: oe_debug_pub.add( 'ERROR IN OE_PRICE_ORDER_PVT.Process_Adjustments' , 1 ) ;
1642: END IF;
1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( SQLERRM , 1 ) ;
1645: END IF;
1646:
1647: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1648: THEN

Line 1656: oe_debug_pub.add( 'EXITING OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;

1652: );
1653: END IF;
1654:
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add( 'EXITING OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;
1657: END IF;
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659:
1660: END Process_Adjustments;

Line 1672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1668: l_return_status_text varchar(2000);
1669: l_control_rec QP_PREQ_GRP.control_record_type;
1670: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1671: --
1672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1673: --
1674: BEGIN
1675: IF l_debug_level > 0 THEN
1676: oe_debug_pub.add( 'BEFORE QP_PREQ_PUB.PRICE_REQUEST' , 1 ) ;

Line 1676: oe_debug_pub.add( 'BEFORE QP_PREQ_PUB.PRICE_REQUEST' , 1 ) ;

1672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1673: --
1674: BEGIN
1675: IF l_debug_level > 0 THEN
1676: oe_debug_pub.add( 'BEFORE QP_PREQ_PUB.PRICE_REQUEST' , 1 ) ;
1677: END IF;
1678:
1679: l_control_rec.calculate_flag := 'Y';
1680: l_control_rec.simulation_flag := 'Y';

Line 1697: oe_debug_pub.add('get_freight_flag before calling pricing engine is: '||l_control_rec.get_freight_flag, 3 ) ;

1693:
1694: -- added for freight rating.
1695: l_control_rec.get_freight_flag := 'N';
1696: IF l_debug_level > 0 THEN
1697: oe_debug_pub.add('get_freight_flag before calling pricing engine is: '||l_control_rec.get_freight_flag, 3 ) ;
1698: END IF;
1699:
1700: -- IF (G_PASS_ALL_LINES in ('N', 'R')) THEN
1701: -- l_control_rec.full_pricing_call := 'N';

Line 1750: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1746:
1747: Procedure Update_Lines(px_Line_Tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type)
1748: IS
1749: l_line_index pls_integer;
1750: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1751: l_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
1752: BEGIN
1753: l_line_index := px_line_tbl.first;
1754: while l_line_index is not null loop

Line 1757: oe_debug_pub.add( 'LINE ID'||L_LINE_REC.LINE_ID ) ;

1753: l_line_index := px_line_tbl.first;
1754: while l_line_index is not null loop
1755: l_line_rec := px_line_tbl(l_line_index);
1756: IF l_debug_level > 0 THEN
1757: oe_debug_pub.add( 'LINE ID'||L_LINE_REC.LINE_ID ) ;
1758: END IF;
1759:
1760: BEGIN
1761:

Line 1833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1829: ,p_Get_Freight_Flag IN VARCHAR2
1830: ,x_Return_Status OUT NOCOPY VARCHAR2
1831: ) AS
1832: l_any_frozen_line BOOLEAN;
1833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1834: l_header_adj_tbl OE_ORDER_PUB.Header_ADJ_Tbl_Type;
1835: l_header_price_att_tbl OE_PRICE_ORDER_PVT.price_att_tbl_type;
1836: l_Line_Tbl OE_ORDER_PUB.Line_Tbl_Type;
1837: i PLS_INTEGER;

Line 1864: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;

1860: , p_Get_Freight_Flag
1861: , x_Return_Status);
1862: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1863: IF l_debug_level > 0 THEN
1864: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
1865: END IF;
1866: raise fnd_api.g_exc_error;
1867: END IF;
1868:

Line 1873: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;

1869: IF (G_PASS_LINE_TBL.count > 0) THEN
1870: Call_Pricing_Engine(p_Pricing_Events, x_Return_Status);
1871: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1872: IF l_debug_level > 0 THEN
1873: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
1874: END IF;
1875: raise fnd_api.g_exc_error;
1876: END IF;
1877:

Line 1884: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;

1880: , px_line_tbl => l_line_tbl
1881: , p_header_rec => px_header_rec);
1882: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1883: IF l_debug_level > 0 THEN
1884: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
1885: END IF;
1886: raise fnd_api.g_exc_error;
1887: END IF;
1888:

Line 1895: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;

1891: , nvl(p_Action_Code, 'NONE')
1892: , x_Return_Status);
1893: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1894: IF l_debug_level > 0 THEN
1895: oe_debug_pub.add( 'CALCULATE ADJUSTMENTS ERROR' ) ;
1896: END IF;
1897: raise fnd_api.g_exc_error;
1898: END IF;
1899:

Line 1938: oe_debug_pub.add('ONTHPROB:Failed while trying to query up tax_calcualtion_event for order_type_id ');

1934: WHEN NO_DATA_FOUND THEN
1935: l_tax_calculation_event_code := 0;
1936: WHEN OTHERS THEN
1937: IF l_debug_level > 0 THEN
1938: oe_debug_pub.add('ONTHPROB:Failed while trying to query up tax_calcualtion_event for order_type_id ');
1939: END IF;
1940:
1941: RAISE;
1942: END;

Line 1951: oe_debug_pub.add('ONTHPROB:Tax Event Code :'||l_tax_calculation_event_code);

1947: l_current_event := 1; /* current event is booking or higher */
1948: END IF;
1949:
1950: IF l_debug_level > 0 THEN
1951: oe_debug_pub.add('ONTHPROB:Tax Event Code :'||l_tax_calculation_event_code);
1952: oe_debug_pub.add('ONTHPROB:Current Event :'||l_current_event);
1953: END IF;
1954:
1955:

Line 1952: oe_debug_pub.add('ONTHPROB:Current Event :'||l_current_event);

1948: END IF;
1949:
1950: IF l_debug_level > 0 THEN
1951: oe_debug_pub.add('ONTHPROB:Tax Event Code :'||l_tax_calculation_event_code);
1952: oe_debug_pub.add('ONTHPROB:Current Event :'||l_current_event);
1953: END IF;
1954:
1955:
1956: IF l_current_event >= l_tax_calculation_event_code THEN

Line 2010: oe_debug_pub.add( 'EXITING PRICE_ORDER WITH EXC ERROR' , 1 ) ;

2006: OE_Order_PUB.G_HDR := NULL;
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008:
2009: IF l_debug_level > 0 THEN
2010: oe_debug_pub.add( 'EXITING PRICE_ORDER WITH EXC ERROR' , 1 ) ;
2011: END IF;
2012: RAISE FND_API.G_EXC_ERROR;
2013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2014:

Line 2020: oe_debug_pub.add( 'EXITING PRICE_ORDER WITH UNEXPECTED ERROR' , 1 ) ;

2016: OE_Order_PUB.G_LINE := NULL;
2017: OE_Order_PUB.G_HDR := NULL;
2018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2019: IF l_debug_level > 0 THEN
2020: oe_debug_pub.add( 'EXITING PRICE_ORDER WITH UNEXPECTED ERROR' , 1 ) ;
2021: END IF;
2022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2023: WHEN OTHERS THEN
2024:

Line 2030: oe_debug_pub.add( 'ERROR IN OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;

2026: --reseting global structure after engine call
2027: OE_Order_PUB.G_LINE := NULL;
2028: OE_Order_PUB.G_HDR := NULL;
2029: IF l_debug_level > 0 THEN
2030: oe_debug_pub.add( 'ERROR IN OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;
2031: END IF;
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add( SQLERRM , 1 ) ;
2034: END IF;

Line 2033: oe_debug_pub.add( SQLERRM , 1 ) ;

2029: IF l_debug_level > 0 THEN
2030: oe_debug_pub.add( 'ERROR IN OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;
2031: END IF;
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add( SQLERRM , 1 ) ;
2034: END IF;
2035:
2036: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2037: THEN

Line 2045: oe_debug_pub.add( 'EXITING OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;

2041: );
2042: END IF;
2043:
2044: IF l_debug_level > 0 THEN
2045: oe_debug_pub.add( 'EXITING OE_PRICE_ORDER_PVT.PRICE_ORDER' , 1 ) ;
2046: END IF;
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: END Price_Order;
2049: