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_LINE_PATTR_UTIL dependencies on OE_DEBUG_PUB

Line 390: oe_debug_pub.add('Entering OE_Line_Patt_UTIL.INSERT_ROW', 1);

386: l_lock_control NUMBER := 1;
387:
388: BEGIN
389:
390: oe_debug_pub.add('Entering OE_Line_Patt_UTIL.INSERT_ROW', 1);
391:
392: INSERT INTO OE_ORDER_PRICE_ATTRIBS
393: ( HEADER_ID
394: ,LINE_ID

Line 665: oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.INSERT_ROW', 1);

661: );
662:
663: p_Line_Price_Att_rec.lock_control := l_lock_control;
664:
665: oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.INSERT_ROW', 1);
666:
667: EXCEPTION
668:
669: WHEN OTHERS THEN

Line 728: oe_debug_pub.add('Entering OE_Line_PATT_UTIL.UPDATE_ROW', 1);

724: l_lock_control NUMBER;
725:
726: BEGIN
727:
728: oe_debug_pub.add('Entering OE_Line_PATT_UTIL.UPDATE_ROW', 1);
729:
730: -- increment lock_control by 1 whenever the record is updated
731: SELECT lock_control
732: INTO l_lock_control

Line 876: oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.UPDATE_ROW', 1);

872: p_Line_Price_Att_rec.order_price_attrib_id;
873:
874: p_Line_Price_Att_rec.lock_control := l_lock_control;
875:
876: oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.UPDATE_ROW', 1);
877:
878: EXCEPTION
879:
880: WHEN OTHERS THEN

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

3202: l_msg_name VARCHAR2(200);
3203: l_pricing_event VARCHAR2(30);
3204: l_order_pricing_event VARCHAR2(30);
3205: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
3206: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3207: --bug 2702382 begin
3208: l_price_adj_id1 number;
3209: l_tmp1 number;
3210: l_tmp_price_flag boolean := FALSE;

Line 3244: oe_debug_pub.add('in free goods line no data found');

3240: opa.list_line_type_code = 'PRG';
3241: exception
3242: when no_data_found then
3243: --indicates not a free goods adjustment, so delete it
3244: oe_debug_pub.add('in free goods line no data found');
3245: delete from oe_price_adjustments where
3246: price_adjustment_id = l_prc_adj_id;
3247: when others then
3248: null;

Line 3445: oe_debug_pub.add('OTA call return status is: '||l_return_status,1);

3441: IN p_x_Line_Price_Att_rec.operation,
3442: OUT l_return_status,
3443: OUT l_msg_name;
3444:
3445: oe_debug_pub.add('OTA call return status is: '||l_return_status,1);
3446: oe_debug_pub.add('OTA call return message is: '||l_msg_name,1);
3447:
3448: IF l_return_status = 'E' THEN
3449: oe_debug_pub.add('OTA API - Error.', 1);

Line 3446: oe_debug_pub.add('OTA call return message is: '||l_msg_name,1);

3442: OUT l_return_status,
3443: OUT l_msg_name;
3444:
3445: oe_debug_pub.add('OTA call return status is: '||l_return_status,1);
3446: oe_debug_pub.add('OTA call return message is: '||l_msg_name,1);
3447:
3448: IF l_return_status = 'E' THEN
3449: oe_debug_pub.add('OTA API - Error.', 1);
3450: FND_MESSAGE.SET_NAME('OTA',l_msg_name);

Line 3449: oe_debug_pub.add('OTA API - Error.', 1);

3445: oe_debug_pub.add('OTA call return status is: '||l_return_status,1);
3446: oe_debug_pub.add('OTA call return message is: '||l_msg_name,1);
3447:
3448: IF l_return_status = 'E' THEN
3449: oe_debug_pub.add('OTA API - Error.', 1);
3450: FND_MESSAGE.SET_NAME('OTA',l_msg_name);
3451: OE_MSG_PUB.ADD;
3452: RAISE FND_API.G_EXC_ERROR;
3453: END IF;

Line 3456: oe_debug_pub.add('OTA module is not installed. ',1);

3452: RAISE FND_API.G_EXC_ERROR;
3453: END IF;
3454:
3455: ELSE
3456: oe_debug_pub.add('OTA module is not installed. ',1);
3457: END IF;
3458: END IF;
3459: END IF;
3460:

Line 4002: oe_debug_pub.add('in no data found - apply attribute change');

3998: and updated_flag = 'Y';
3999: l_price_flag := delete_price_adj(l_price_adj_id1,l_lst_type_code);
4000: exception
4001: when others then
4002: oe_debug_pub.add('in no data found - apply attribute change');
4003: null;
4004: end;
4005: elsif p_x_line_price_att_rec.pricing_attribute2 is null THEN
4006: begin

Line 4033: oe_debug_pub.ADD('Logging delayed request for pricing from OE_Line_PAttr_Util.apply_attribute_changes ', 1);

4029: --for bug 2702382 end
4030:
4031: If l_price_flag Then
4032:
4033: oe_debug_pub.ADD('Logging delayed request for pricing from OE_Line_PAttr_Util.apply_attribute_changes ', 1);
4034: --2442012
4035: Begin
4036: Select booked_flag,shipping_quantity into
4037: l_booked_flag,l_shipping_quantity

Line 4056: oe_debug_pub.add(' Before calling registered changed lines from ulpab');

4052: l_order_pricing_event := 'ORDER';
4053: End If;
4054:
4055: --Need to register changed line so that repricing for this line will happen
4056: oe_debug_pub.add(' Before calling registered changed lines from ulpab');
4057: OE_LINE_ADJ_UTIL.Register_Changed_Lines(p_line_id=> p_x_Line_Price_Att_rec.line_id,
4058: p_header_id=>p_x_Line_Price_Att_rec.header_id,
4059: p_operation=>OE_GLOBALS.G_OPR_UPDATE);
4060: oe_debug_pub.add(' After calling registered changed line');

Line 4060: oe_debug_pub.add(' After calling registered changed line');

4056: oe_debug_pub.add(' Before calling registered changed lines from ulpab');
4057: OE_LINE_ADJ_UTIL.Register_Changed_Lines(p_line_id=> p_x_Line_Price_Att_rec.line_id,
4058: p_header_id=>p_x_Line_Price_Att_rec.header_id,
4059: p_operation=>OE_GLOBALS.G_OPR_UPDATE);
4060: oe_debug_pub.add(' After calling registered changed line');
4061:
4062: --for bug 2456108 begin
4063: if (p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER') then
4064: OE_delayed_requests_Pvt.log_request(

Line 4080: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||

4076: -- for bug 3533776: Find out whether order event needs all lines to be sent
4077: QP_UTIL_PUB.Get_Order_Lines_Status(l_order_pricing_event,l_order_status_rec);
4078:
4079: IF l_debug_level > 0 THEN
4080: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4081: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4082: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4083: if (OE_GLOBALS.G_UI_FLAG) then
4084: oe_debug_pub.add('ui mode');

Line 4082: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);

4078:
4079: IF l_debug_level > 0 THEN
4080: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4081: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4082: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4083: if (OE_GLOBALS.G_UI_FLAG) then
4084: oe_debug_pub.add('ui mode');
4085: end if;
4086: END IF;

Line 4084: oe_debug_pub.add('ui mode');

4080: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4081: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4082: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4083: if (OE_GLOBALS.G_UI_FLAG) then
4084: oe_debug_pub.add('ui mode');
4085: end if;
4086: END IF;
4087:
4088: -- If 'ORDER' event doesn't require sending in all lines, let's just price the current line

Line 4174: oe_debug_pub.add('Entering OE_Line_Adj_Util.Lock_Row.', 1);

4170: l_lock_control NUMBER;
4171:
4172: BEGIN
4173:
4174: oe_debug_pub.add('Entering OE_Line_Adj_Util.Lock_Row.', 1);
4175: SAVEPOINT Lock_Row;
4176:
4177: l_lock_control := NULL;
4178:

Line 4198: oe_debug_pub.add('queried lock_control: '|| p_x_line_price_att_rec.lock_control, 1);

4194: ,x_Line_Price_Att_rec => p_x_Line_Price_Att_rec
4195: );
4196:
4197:
4198: oe_debug_pub.add('queried lock_control: '|| p_x_line_price_att_rec.lock_control, 1);
4199:
4200: -- If lock_control is not passed(is null or missing), then return the locked record.
4201:
4202:

Line 4219: oe_debug_pub.add('compare ', 1);

4215:
4216: -- Row locked. If the whole record is passed, then
4217: -- Compare lock_control.
4218:
4219: oe_debug_pub.add('compare ', 1);
4220:
4221: IF OE_GLOBALS.Equal(p_x_line_Price_Att_rec.lock_control,
4222: l_lock_control)
4223: THEN

Line 4227: oe_debug_pub.add('locked row', 1);

4223: THEN
4224:
4225: -- Row has not changed. Set out parameter.
4226:
4227: oe_debug_pub.add('locked row', 1);
4228:
4229: -- Set return status
4230:
4231: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4237: oe_debug_pub.add('row changed by other user', 1);

4233:
4234: ELSE
4235:
4236: -- Row has changed by another user.
4237: oe_debug_pub.add('row changed by other user', 1);
4238:
4239: x_return_status := FND_API.G_RET_STS_ERROR;
4240: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4241:

Line 4319: oe_debug_pub.add('Entering OE_Line_PAttr_Util.Lock_Rows.', 1);

4315: l_lock_control NUMBER;
4316:
4317: BEGIN
4318:
4319: oe_debug_pub.add('Entering OE_Line_PAttr_Util.Lock_Rows.', 1);
4320:
4321: IF (p_order_price_attrib_id IS NOT NULL AND
4322: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4323: (p_line_id IS NOT NULL AND

Line 4406: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.Lock_Rows.', 1);

4402: , 'Lock_Row'
4403: );
4404: END IF;
4405:
4406: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.Lock_Rows.', 1);
4407:
4408:
4409: END lock_rows;
4410:

Line 4449: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);

4445: --serla end
4446: i PLS_INTEGER;
4447:
4448: BEGIN
4449: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4450:
4451: OE_Line_PAttr_Util.Query_rows(p_line_id => p_from_line_id
4452: , x_Line_Price_att_tbl => l_Line_Price_Att_tbl);
4453:

Line 4458: oe_debug_pub.add('Entering the LOOP ... : ', 1);

4454:
4455: i := l_line_price_att_tbl.First;
4456: While i IS NOT NULL LOOP
4457:
4458: oe_debug_pub.add('Entering the LOOP ... : ', 1);
4459:
4460: -- calling Pricing API to check if the pricing context is valid.
4461: QP_UTIL.validate_context_code(
4462: p_flexfield_name => l_line_price_att_tbl(i).flex_title

Line 4504: oe_debug_pub.add('Before OE_Order_PVT.Process_order',1);

4500:
4501:
4502: -- Call OE_Order_PVT.Process_order
4503:
4504: oe_debug_pub.add('Before OE_Order_PVT.Process_order',1);
4505:
4506: -- OE_Globals.G_RECURSION_MODE := 'Y';
4507:
4508:

Line 4553: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);

4549: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4550: RAISE FND_API.G_EXC_ERROR;
4551: END IF;
4552:
4553: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4554:
4555: Exception
4556: WHEN FND_API.G_EXC_ERROR THEN
4557:

Line 4597: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_model_pattr.', 1);

4593:
4594:
4595: BEGIN
4596:
4597: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_model_pattr.', 1);
4598:
4599: SELECT top_model_line_id, header_id
4600: INTO l_top_model_line_id, l_from_header_id
4601: FROM oe_order_lines

Line 4612: oe_debug_pub.add('Copying pricing attributes for line '||p_to_line_id);

4608: FETCH Get_Option_Lines INTO l_from_header_id, l_to_line_id;
4609: EXIT WHEN Get_Option_Lines%NOTFOUND;
4610: */
4611:
4612: oe_debug_pub.add('Copying pricing attributes for line '||p_to_line_id);
4613:
4614: copy_pricing_attributes
4615: ( p_from_line_id => l_top_model_line_id
4616: ,p_to_line_id => p_to_line_id

Line 4633: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_model_pattr.', 1);

4629: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4630: RAISE FND_API.G_EXC_ERROR;
4631: END IF;
4632:
4633: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_model_pattr.', 1);
4634:
4635: EXCEPTION
4636: WHEN FND_API.G_EXC_ERROR THEN
4637: