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.

[Home] [Help]

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 4099: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||

4095: x_order_status_rec =>l_order_status_rec);
4096: -- bug 9728497 end
4097:
4098: IF l_debug_level > 0 THEN
4099: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4100: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4101: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4102: if (OE_GLOBALS.G_UI_FLAG) then
4103: oe_debug_pub.add('ui mode');

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

4097:
4098: IF l_debug_level > 0 THEN
4099: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4100: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4101: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4102: if (OE_GLOBALS.G_UI_FLAG) then
4103: oe_debug_pub.add('ui mode');
4104: end if;
4105: END IF;

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

4099: oe_debug_pub.add('SummaryFlag:'||l_order_status_rec.SUMMARY_LINE_FLAG||'ALL_LINES_FLAG:'||
4100: l_order_status_rec.ALL_LINES_FLAG||' CHANGED_LINE_FLAG:'||l_order_status_rec.CHANGED_LINES_FLAG);
4101: oe_debug_pub.add('G_DEFER_PRICING'||OE_GLOBALS.G_DEFER_PRICING);
4102: if (OE_GLOBALS.G_UI_FLAG) then
4103: oe_debug_pub.add('ui mode');
4104: end if;
4105: END IF;
4106:
4107: -- If 'ORDER' event doesn't require sending in all lines, let's just price the current line

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

4211: l_lock_control NUMBER;
4212:
4213: BEGIN
4214:
4215: oe_debug_pub.add('Entering OE_Line_Adj_Util.Lock_Row.', 1);
4216: SAVEPOINT Lock_Row;
4217:
4218: l_lock_control := NULL;
4219:

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

4235: ,x_Line_Price_Att_rec => p_x_Line_Price_Att_rec
4236: );
4237:
4238:
4239: oe_debug_pub.add('queried lock_control: '|| p_x_line_price_att_rec.lock_control, 1);
4240:
4241: -- If lock_control is not passed(is null or missing), then return the locked record.
4242:
4243:

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

4256:
4257: -- Row locked. If the whole record is passed, then
4258: -- Compare lock_control.
4259:
4260: oe_debug_pub.add('compare ', 1);
4261:
4262: IF OE_GLOBALS.Equal(p_x_line_Price_Att_rec.lock_control,
4263: l_lock_control)
4264: THEN

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

4264: THEN
4265:
4266: -- Row has not changed. Set out parameter.
4267:
4268: oe_debug_pub.add('locked row', 1);
4269:
4270: -- Set return status
4271:
4272: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4274:
4275: ELSE
4276:
4277: -- Row has changed by another user.
4278: oe_debug_pub.add('row changed by other user', 1);
4279:
4280: x_return_status := FND_API.G_RET_STS_ERROR;
4281: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4282:

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

4356: l_lock_control NUMBER;
4357:
4358: BEGIN
4359:
4360: oe_debug_pub.add('Entering OE_Line_PAttr_Util.Lock_Rows.', 1);
4361:
4362: IF (p_order_price_attrib_id IS NOT NULL AND
4363: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4364: (p_line_id IS NOT NULL AND

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

4443: , 'Lock_Row'
4444: );
4445: END IF;
4446:
4447: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.Lock_Rows.', 1);
4448:
4449:
4450: END lock_rows;
4451:

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

4486: --serla end
4487: i PLS_INTEGER;
4488:
4489: BEGIN
4490: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4491:
4492: OE_Line_PAttr_Util.Query_rows(p_line_id => p_from_line_id
4493: , x_Line_Price_att_tbl => l_Line_Price_Att_tbl);
4494:

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

4495:
4496: i := l_line_price_att_tbl.First;
4497: While i IS NOT NULL LOOP
4498:
4499: oe_debug_pub.add('Entering the LOOP ... : ', 1);
4500:
4501: -- calling Pricing API to check if the pricing context is valid.
4502: QP_UTIL.validate_context_code(
4503: p_flexfield_name => l_line_price_att_tbl(i).flex_title

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

4541:
4542:
4543: -- Call OE_Order_PVT.Process_order
4544:
4545: oe_debug_pub.add('Before OE_Order_PVT.Process_order',1);
4546:
4547: -- OE_Globals.G_RECURSION_MODE := 'Y';
4548:
4549:

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

4590: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4593:
4594: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_pricing_attribtes.', 1);
4595:
4596: Exception
4597: WHEN FND_API.G_EXC_ERROR THEN
4598:

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

4634:
4635:
4636: BEGIN
4637:
4638: oe_debug_pub.add('Entering OE_Line_PAttr_Util.copy_model_pattr.', 1);
4639:
4640: SELECT top_model_line_id, header_id
4641: INTO l_top_model_line_id, l_from_header_id
4642: FROM oe_order_lines

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

4649: FETCH Get_Option_Lines INTO l_from_header_id, l_to_line_id;
4650: EXIT WHEN Get_Option_Lines%NOTFOUND;
4651: */
4652:
4653: oe_debug_pub.add('Copying pricing attributes for line '||p_to_line_id);
4654:
4655: copy_pricing_attributes
4656: ( p_from_line_id => l_top_model_line_id
4657: ,p_to_line_id => p_to_line_id

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

4670: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
4671: RAISE FND_API.G_EXC_ERROR;
4672: END IF;
4673:
4674: oe_debug_pub.add('Exiting OE_Line_PAttr_Util.copy_model_pattr.', 1);
4675:
4676: EXCEPTION
4677: WHEN FND_API.G_EXC_ERROR THEN
4678: