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_UTIL dependencies on OE_LINE_UTIL

Line 1: PACKAGE BODY OE_LINE_UTIL AS

1: PACKAGE BODY OE_LINE_UTIL AS
2: /* $Header: OEXULINB.pls 120.67.12010000.20 2008/12/26 07:37:31 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_line_util';

2: /* $Header: OEXULINB.pls 120.67.12010000.20 2008/12/26 07:37:31 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_line_util';
7: --bug4080363 commenting out the following
8: -- bug 3491752
9: --G_LIST_PRICE_OVERRIDE Varchar2(30) := nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE');
10:

Line 19: -- Procedure Clear_Dependent_Attr: Moved to OE_LINE_UTIL_EXT (OEXULXTS/B.pls)

15: p_top_model_line_id IN NUMBER,
16: p_link_to_line_id IN NUMBER
17: );
18:
19: -- Procedure Clear_Dependent_Attr: Moved to OE_LINE_UTIL_EXT (OEXULXTS/B.pls)
20:
21: -- Added 09-DEC-2002
22: -- Forward declaration of LOCAL PROCEDURE Log_Blanket_Request
23: PROCEDURE Log_Blanket_Request

Line 480: oe_debug_pub.add('Entering OE_LINE_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);

476:
477: BEGIN
478:
479: if l_debug_level > 0 then
480: oe_debug_pub.add('Entering OE_LINE_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
481: end if;
482:
483: -- Query Header Record
484: -- Performance Improvement Bug 1929163

Line 1706: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);

1702: p_x_line_rec.line_category_code <> 'RETURN'
1703: THEN
1704: /*
1705: p_x_line_rec.ordered_quantity2 :=
1706: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);
1707: */
1708: /* OPM - NC 3/8/02 Bug#2046641
1709: Commented the above call and added the call to calculate_dual_quantity */
1710: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110507') OR NOT(OE_GLOBALS.G_UI_FLAG) THEN

Line 1715: oe_line_util.calculate_dual_quantity(

1711:
1712: if l_debug_level > 0 then
1713: oe_debug_pub.add('about to call calculate_dual_quantity 1' );
1714: end if;
1715: oe_line_util.calculate_dual_quantity(
1716: p_ordered_quantity => p_x_line_rec.ordered_quantity
1717: ,p_old_ordered_quantity => NULL
1718: ,p_ordered_quantity2 => p_x_line_rec.ordered_quantity2
1719: ,p_old_ordered_quantity2 => NULL

Line 1753: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);

1749: p_x_line_rec.split_by = 'USER'
1750: THEN
1751: /*
1752: p_x_line_rec.ordered_quantity2 :=
1753: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);
1754: */
1755: /* OPM - NC 3/8/02 Bug#2046641
1756: Commented the above call and added the call to calculate_dual_quantity */
1757: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110507') OR NOT(OE_GLOBALS.G_UI_FLAG) THEN

Line 1762: oe_line_util.calculate_dual_quantity(

1758: if l_debug_level > 0 then
1759: oe_debug_pub.add('about to call calculate_dual_quantity 2' );
1760: end if;
1761:
1762: oe_line_util.calculate_dual_quantity(
1763: p_ordered_quantity => p_x_line_rec.ordered_quantity
1764: ,p_old_ordered_quantity => NULL
1765: ,p_ordered_quantity2 => p_x_line_rec.ordered_quantity2
1766: ,p_old_ordered_quantity2 => NULL

Line 2810: OE_Line_Util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec

2806: -- BUG 1491504 BEGIN -- INVCONV stet
2807: -- Warehouse data CAN determine whether the line is treated as process or discrete OR SINGLE uom OR dUAL uom CONTROLLED .
2808: -- Warehouse data can impact quantity calculations, so check the quantites here
2809: -- pal
2810: OE_Line_Util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec
2811: ,p_old_line_rec => p_old_line_rec);
2812: -- Check to see if either the primary or secondary quantity has changed
2813: -- If there is a change, make a recursive call to OE_Order_Pvt.Lines
2814: IF p_x_line_rec.ordered_quantity <> l_ordered_quantity OR

Line 5285: oe_debug_pub.add('Exiting OE_LINE_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);

5281: /*Bug2848734*/
5282:
5283: if l_debug_level > 0 then
5284: oe_debug_pub.add('return status before exiting '|| p_x_line_rec.return_status, 1);
5285: oe_debug_pub.add('Exiting OE_LINE_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
5286: end if;
5287:
5288: END Apply_Attribute_Changes;
5289:

Line 5305: oe_debug_pub.add('Entering OE_LINE_UTIL.COMPLETE_RECORD', 1);

5301: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5302: BEGIN
5303:
5304: IF l_debug_level > 0 THEN
5305: oe_debug_pub.add('Entering OE_LINE_UTIL.COMPLETE_RECORD', 1);
5306: END IF;
5307:
5308: IF p_x_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
5309: p_x_line_rec.accounting_rule_id := p_old_line_rec.accounting_rule_id;

Line 6728: oe_debug_pub.add('Exiting OE_LINE_UTIL.COMPLETE_RECORD', 1);

6724: END IF;
6725:
6726:
6727: if l_debug_level > 0 then
6728: oe_debug_pub.add('Exiting OE_LINE_UTIL.COMPLETE_RECORD', 1);
6729: end if;
6730:
6731: END Complete_Record;
6732:

Line 6747: oe_debug_pub.add('Entering OE_LINE_UTIL.CONVERT_MISS_TO_NULL', 1);

6743: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6744: BEGIN
6745:
6746: if l_debug_level > 0 then
6747: oe_debug_pub.add('Entering OE_LINE_UTIL.CONVERT_MISS_TO_NULL', 1);
6748:
6749: oe_debug_pub.add('outside margin convert miss to null',1);
6750: end if;
6751: --MRG BGN

Line 8130: oe_debug_pub.add('Exiting OE_LINE_UTIL.CONVERT_MISS_TO_NULL', 1);

8126: END IF;
8127: */
8128:
8129: if l_debug_level > 0 then
8130: oe_debug_pub.add('Exiting OE_LINE_UTIL.CONVERT_MISS_TO_NULL', 1);
8131: end if;
8132: END Convert_Miss_To_Null;
8133:
8134:

Line 8153: oe_debug_pub.add('Entering OE_LINE_UTIL.UPDATE_ROW', 1);

8149: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8150: BEGIN
8151:
8152: if l_debug_level > 0 then
8153: oe_debug_pub.add('Entering OE_LINE_UTIL.UPDATE_ROW', 1);
8154: end if;
8155: --Commented for MOAC start
8156: /*if l_org_id IS NULL THEN
8157: OE_GLOBALS.Set_Context;

Line 8178: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);

8174: p_line_id => p_line_rec.line_id,
8175: x_index => l_index,
8176: x_return_status => l_return_status);
8177: if l_debug_level > 0 then
8178: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);
8179: OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);
8180: OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);
8181: end if;
8182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 8179: OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);

8175: x_index => l_index,
8176: x_return_status => l_return_status);
8177: if l_debug_level > 0 then
8178: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);
8179: OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);
8180: OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);
8181: end if;
8182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8183: if l_debug_level > 0 then

Line 8180: OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);

8176: x_return_status => l_return_status);
8177: if l_debug_level > 0 then
8178: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);
8179: OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);
8180: OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);
8181: end if;
8182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8183: if l_debug_level > 0 then
8184: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

Line 8185: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);

8181: end if;
8182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8183: if l_debug_level > 0 then
8184: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
8185: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
8186: end if;
8187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8188: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8189: if l_debug_level > 0 then

Line 8190: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Update_row');

8186: end if;
8187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8188: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8189: if l_debug_level > 0 then
8190: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Update_row');
8191: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
8192: end if;
8193: RAISE FND_API.G_EXC_ERROR;
8194: END IF;

Line 8191: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);

8187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8188: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
8189: if l_debug_level > 0 then
8190: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Update_row');
8191: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
8192: end if;
8193: RAISE FND_API.G_EXC_ERROR;
8194: END IF;
8195: END IF; /*code_release_level*/

Line 8576: oe_debug_pub.add('Exiting OE_LINE_UTIL.UPDATE_ROW', 1);

8572:
8573: p_line_rec.lock_control := l_lock_control;
8574:
8575: if l_debug_level > 0 then
8576: oe_debug_pub.add('Exiting OE_LINE_UTIL.UPDATE_ROW', 1);
8577: end if;
8578:
8579: EXCEPTION
8580:

Line 8619: oe_debug_pub.add('Entering OE_LINE_UTIL.INSERT_ROW', 1);

8615: l_price_request_code VARCHAR2(240);
8616: BEGIN
8617:
8618: if l_debug_level > 0 then
8619: oe_debug_pub.add('Entering OE_LINE_UTIL.INSERT_ROW', 1);
8620: end if;
8621:
8622: --MOAC change
8623: OE_GLOBALS.Set_Context;

Line 9413: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.inset_row is: ' || l_return_status);

9409: p_line_id => p_line_rec.line_id,
9410: x_index => l_index,
9411: x_return_status => l_return_status);
9412: if l_debug_level > 0 then
9413: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.inset_row is: ' || l_return_status);
9414: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
9415: end if;
9416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9417: if l_debug_level > 0 then

Line 9419: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);

9415: end if;
9416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9417: if l_debug_level > 0 then
9418: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9419: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
9420: end if;
9421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9423: if l_debug_level > 0 then

Line 9424: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.insert_row');

9420: end if;
9421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9423: if l_debug_level > 0 then
9424: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.insert_row');
9425: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
9426: end if;
9427: RAISE FND_API.G_EXC_ERROR;
9428: END IF;

Line 9425: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);

9421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9423: if l_debug_level > 0 then
9424: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.insert_row');
9425: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
9426: end if;
9427: RAISE FND_API.G_EXC_ERROR;
9428: END IF;
9429: END IF; /*code_release_code*/

Line 9433: oe_debug_pub.add('Exiting OE_LINE_UTIL.INSERT_ROW', 1);

9429: END IF; /*code_release_code*/
9430: -- notification framework end
9431:
9432: if l_debug_level > 0 then
9433: oe_debug_pub.add('Exiting OE_LINE_UTIL.INSERT_ROW', 1);
9434: end if;
9435:
9436: EXCEPTION
9437:

Line 9510: oe_debug_pub.add('Entering OE_LINE_UTIL.DELETE_ROW', 1);

9506: AND service_reference_type_code = 'ORDER'; --bug 3056313
9507:
9508: BEGIN
9509:
9510: oe_debug_pub.add('Entering OE_LINE_UTIL.DELETE_ROW', 1);
9511: --Commented for MOAC start
9512: /*l_org_id := OE_GLOBALS.G_ORG_ID;
9513:
9514: IF l_org_id IS NULL THEN

Line 9537: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row is: ' || l_return_status);

9533: p_line_rec =>l_new_line_rec,
9534: p_line_id =>l_line.line_id,
9535: x_index => l_index,
9536: x_return_status => l_return_status);
9537: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row is: ' || l_return_status);
9538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9539: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9540: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9540: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

9536: x_return_status => l_return_status);
9537: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row is: ' || l_return_status);
9538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9539: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9540: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9543: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9544: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

Line 9543: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');

9539: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9540: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9543: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9544: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9545: RAISE FND_API.G_EXC_ERROR;
9546: END IF;
9547: END IF; /*code_release_level*/

Line 9544: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

9540: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9542: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9543: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9544: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9545: RAISE FND_API.G_EXC_ERROR;
9546: END IF;
9547: END IF; /*code_release_level*/
9548: -- notification framework end

Line 9599: oe_line_util.query_row

9595:
9596: ELSE -- header_id is missing.
9597: oe_debug_pub.add('hdr missing delete_row,line_id: '||p_line_id, 1);
9598:
9599: oe_line_util.query_row
9600: (p_line_id => p_line_id
9601: ,x_line_rec => l_line_rec );
9602:
9603: lvariable2 := p_line_id;

Line 9832: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting standard line is: ' || l_return_status);

9828: p_line_rec =>l_new_line_rec,
9829: p_line_id =>l_line_rec.line_id,
9830: x_index => l_index,
9831: x_return_status => l_return_status);
9832: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting standard line is: ' || l_return_status);
9833: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9834: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9835: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9835: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

9831: x_return_status => l_return_status);
9832: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting standard line is: ' || l_return_status);
9833: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9834: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9835: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9837: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9838: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9839: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

Line 9838: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');

9834: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9835: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9837: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9838: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9839: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9840: RAISE FND_API.G_EXC_ERROR;
9841: END IF;
9842: END IF; /*code_release_level*/

Line 9839: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

9835: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9837: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9838: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9839: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9840: RAISE FND_API.G_EXC_ERROR;
9841: END IF;
9842: END IF; /*code_release_level*/
9843: -- notification framework end

Line 9866: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting service line is: ' || l_return_status);

9862: p_line_id =>l_svc.line_id,
9863: x_index => l_index,
9864: x_return_status => l_return_status);
9865:
9866: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting service line is: ' || l_return_status);
9867: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9868: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9869: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9869: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

9865:
9866: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting service line is: ' || l_return_status);
9867: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9868: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9869: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9871: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9872: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9873: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

Line 9872: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');

9868: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9869: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9871: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9872: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9873: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9874: RAISE FND_API.G_EXC_ERROR;
9875: END IF;
9876: END LOOP;

Line 9873: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

9869: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9871: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9872: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
9873: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9874: RAISE FND_API.G_EXC_ERROR;
9875: END IF;
9876: END LOOP;
9877: END IF; /*code_release_level*/

Line 9942: oe_debug_pub.add('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

9938: END IF;
9939: END;
9940: END IF; -- profile is yes
9941:
9942: oe_debug_pub.add('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
9943:
9944: EXCEPTION
9945: WHEN FND_API.G_EXC_ERROR THEN
9946: RAISE FND_API.G_EXC_ERROR ;

Line 10351: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROW, line_id:'||p_line_id, 1);

10347:
10348: BEGIN
10349:
10350: IF l_debug_level > 0 THEN
10351: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROW, line_id:'||p_line_id, 1);
10352: END IF;
10353:
10354:
10355: OPEN l_line_csr;

Line 10737: oe_debug_pub.add('Exiting OE_LINE_UTIL.QUERY_ROW', 1);

10733:
10734: CLOSE l_line_csr;
10735:
10736: IF l_debug_level > 0 THEN
10737: oe_debug_pub.add('Exiting OE_LINE_UTIL.QUERY_ROW', 1);
10738: END IF;
10739:
10740:
10741: EXCEPTION

Line 11554: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS, line_id:'||p_line_id, 1);

11550: l_line_rec OE_ORDER_PUB.line_rec_type;
11551: BEGIN
11552:
11553: IF l_debug_level > 0 THEN
11554: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS, line_id:'||p_line_id, 1);
11555: END IF;
11556:
11557: IF
11558: (p_line_id IS NOT NULL

Line 12372: oe_debug_pub.add('Exiting OE_LINE_UTIL.QUERY_ROWS', 1);

12368:
12369:
12370: -- Return fetched table
12371: IF l_debug_level > 0 THEN
12372: oe_debug_pub.add('Exiting OE_LINE_UTIL.QUERY_ROWS', 1);
12373: END IF;
12374:
12375: EXCEPTION
12376:

Line 12448: oe_debug_pub.add('Entering OE_LINE_UTIL.LOCK_ROW', 1);

12444: --
12445: BEGIN
12446:
12447: IF l_debug_level > 0 THEN
12448: oe_debug_pub.add('Entering OE_LINE_UTIL.LOCK_ROW', 1);
12449: END IF;
12450:
12451: SAVEPOINT Lock_Row;
12452:

Line 12601: oe_line_util.Query_Row

12597: IF l_lock_control IS NULL
12598: OR (l_lock_control <> l_db_lock_control)
12599: OR (OE_GLOBALS.G_UI_FLAG = TRUE ) THEN -- 3025978
12600:
12601: oe_line_util.Query_Row
12602: (p_line_id => l_line_id
12603: ,x_line_rec => p_x_line_rec
12604: );
12605:

Line 12684: oe_debug_pub.add('Exiting OE_LINE_UTIL.LOCK_ROW', 1);

12680:
12681: OE_GLOBALS.G_LOCK_TEST := 'N';
12682:
12683: IF l_debug_level > 0 THEN
12684: oe_debug_pub.add('Exiting OE_LINE_UTIL.LOCK_ROW', 1);
12685: oe_debug_pub.add(' ', 1);
12686: oe_debug_pub.add('lock const: '|| oe_globals.g_lock_const, 1);
12687: END IF;
12688:

Line 12823: oe_line_util.Query_Rows

12819: END;
12820:
12821: -- locked all lines
12822:
12823: oe_line_util.Query_Rows
12824: (p_line_id => p_line_id
12825: ,p_header_id => p_header_id
12826: ,x_line_tbl => x_line_tbl
12827: );

Line 12830: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS', 1);

12826: ,x_line_tbl => x_line_tbl
12827: );
12828:
12829: IF l_debug_level > 0 THEN
12830: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS', 1);
12831: END IF;
12832:
12833: x_return_status := FND_API.G_RET_STS_SUCCESS;
12834:

Line 12887: OE_DEBUG_PUB.add('Entering OE_LINE_UTIL.Get_Values');

12883: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12884: BEGIN
12885:
12886: if l_debug_level > 0 then
12887: OE_DEBUG_PUB.add('Entering OE_LINE_UTIL.Get_Values');
12888: end if;
12889:
12890: IF (p_line_rec.calculate_price_flag IS NULL OR
12891: p_line_rec.calculate_price_flag <> FND_API.G_MISS_CHAR) AND

Line 16383: IF (OE_LINE_UTIL.Is_Over_Return(p_x_line_rec)) THEN

16379: THEN
16380: if l_debug_level > 0 then
16381: oe_debug_pub.ADD('Calling IS_OVER_RETURN ',1);
16382: end if;
16383: IF (OE_LINE_UTIL.Is_Over_Return(p_x_line_rec)) THEN
16384: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
16385: OE_MSG_PUB.Add;
16386: RAISE FND_API.G_EXC_ERROR;
16387: END IF;

Line 17269: oe_debug_pub.add('Entering OE_LINE_UTIL.CASCADE_LINE_NUMBER ');

17265: l_line_rec OE_Order_PUB.Line_Rec_Type;
17266: l_cursor_flag VARCHAR2(1) := null;
17267:
17268: BEGIN
17269: oe_debug_pub.add('Entering OE_LINE_UTIL.CASCADE_LINE_NUMBER ');
17270: oe_debug_pub.add('AK line_id ' || p_line_id);
17271: oe_debug_pub.add('AK line_iset_d ' || p_line_set_id);
17272: oe_debug_pub.add('AK line_number' || p_line_number);
17273: oe_debug_pub.add('AK item_type_code' || p_item_type_code);

Line 17451: oe_debug_pub.add('Exiting OE_LINE_UTIL.CASCADE_LINE_NUMBER ');

17447: CLOSE Service_line_number;
17448:
17449: END IF; /*p_item_type_code*/
17450:
17451: oe_debug_pub.add('Exiting OE_LINE_UTIL.CASCADE_LINE_NUMBER ');
17452:
17453: EXCEPTION
17454:
17455: WHEN NO_DATA_FOUND THEN

Line 18618: IF oe_line_util.Process_Characteristics

18614: and item.alloc_class = alot.alloc_class
18615: and alot.delete_mark = 0;
18616: BEGIN
18617:
18618: IF oe_line_util.Process_Characteristics
18619: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id,l_item_rec) AND
18620: ((NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_item
18621: ,p_old_line_rec.ordered_item)) OR
18622: (NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id

Line 19261: IF oe_line_util.Process_Characteristics

19257:
19258:
19259: -- If this is a process line, load the item details from cache
19260: --==============================================================
19261: IF oe_line_util.Process_Characteristics
19262: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id,l_item_rec) THEN
19263: NULL;
19264: ELSE
19265: RETURN p_line_rec.ordered_quantity2;

Line 19379: oe_line_util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec

19375: -- As part of scheduling restructure. dependency will added with
19376: -- bug 2164440.
19377: --4504362 : Branch Scheduling check removed.
19378: -- OPM 02/JUN/00
19379: oe_line_util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec
19380: ,p_old_line_rec => p_old_line_rec);
19381: -- OPM 02/JUN/00 END
19382: -- INVCONV
19383: -- check this - why call here ?? need to know where to call in proper place - ask OM team

Line 19419: oe_line_util.calculate_dual_quantity(

19415: end if;
19416: IF l_qty <>0 or
19417: l_qty2 <> 0
19418: then
19419: oe_line_util.calculate_dual_quantity(
19420: p_ordered_quantity => l_qty
19421: ,p_old_ordered_quantity => NULL
19422: ,p_ordered_quantity2 => l_qty2 -- p_x_line_rec.reserved_quantity2
19423: ,p_old_ordered_quantity2 => NULL

Line 21275: OE_Line_Util.Version_Audit_Process(p_x_line_rec => p_x_line_rec,

21271: oe_debug_pub.add('Before calling Version_Audit_Process',1);
21272: end if;
21273:
21274: --Adding code to log versioning/audit request
21275: OE_Line_Util.Version_Audit_Process(p_x_line_rec => p_x_line_rec,
21276: p_old_line_rec => p_old_line_rec);
21277:
21278: --bug 3988559 modify sfadnavi END
21279:

Line 22112: oe_debug_pub.ADD('Entering OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);

22108: up_f oe_price_adjustments.updated_flag%TYPE;
22109: row_count NUMBER;
22110:
22111: BEGIN
22112: oe_debug_pub.ADD('Entering OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
22113:
22114: IF p_old_line_rec.inventory_item_id IS NULL THEN
22115: --new item, dont need to do anything
22116: oe_debug_pub.ADD('New Item, dont have to do anything',1);

Line 22117: oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);

22113:
22114: IF p_old_line_rec.inventory_item_id IS NULL THEN
22115: --new item, dont need to do anything
22116: oe_debug_pub.ADD('New Item, dont have to do anything',1);
22117: oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
22118: RETURN;
22119: END IF;
22120:
22121: --deleting the IUE adjustment

Line 22188: oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);

22184:
22185: END LOOP;
22186: CLOSE c1;
22187: oe_debug_pub.ADD('...done looking for item parent lines',1);
22188: oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
22189: RETURN;
22190:
22191: END update_adjustment_flags;
22192:

Line 22662: END oe_line_util;

22658:
22659: END HANDLE_RFR;
22660:
22661:
22662: END oe_line_util;