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.139.12020000.31 2013/05/23 13:36:02 nilegupt 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.139.12020000.31 2013/05/23 13:36:02 nilegupt 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: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8636027

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

22: p_top_model_line_id IN NUMBER,
23: p_link_to_line_id IN NUMBER
24: );
25:
26: -- Procedure Clear_Dependent_Attr: Moved to OE_LINE_UTIL_EXT (OEXULXTS/B.pls)
27:
28: -- Added 09-DEC-2002
29: -- Forward declaration of LOCAL PROCEDURE Log_Blanket_Request
30: PROCEDURE Log_Blanket_Request

Line 105: IF oe_line_util.dual_uom_control

101: IF l_debug_level > 0 THEN
102: oe_debug_pub.ADD('Entering Is_Catch_Weight');
103: END IF;
104:
105: IF oe_line_util.dual_uom_control
106: (p_line_rec.inventory_item_id
107: ,p_line_rec.ship_from_org_id
108: ,l_item_rec)
109: THEN

Line 111: l_ref_line_rec := OE_line_UTIL.Query_Row(p_line_rec.reference_line_id);

107: ,p_line_rec.ship_from_org_id
108: ,l_item_rec)
109: THEN
110: IF p_line_rec.reference_line_id is NOT NULL THEN
111: l_ref_line_rec := OE_line_UTIL.Query_Row(p_line_rec.reference_line_id);
112: END IF;
113:
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.ADD('Reference Line FB:'||l_ref_line_rec.fulfillment_base);

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

683:
684: BEGIN
685:
686: if l_debug_level > 0 then
687: oe_debug_pub.add('Entering OE_LINE_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
688: end if;
689:
690: -- Query Header Record
691: -- Performance Improvement Bug 1929163

Line 2203: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);

2199: p_x_line_rec.line_category_code <> 'RETURN'
2200: THEN
2201: /*
2202: p_x_line_rec.ordered_quantity2 :=
2203: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);
2204: */
2205: /* OPM - NC 3/8/02 Bug#2046641
2206: Commented the above call and added the call to calculate_dual_quantity */
2207: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110507') OR NOT(OE_GLOBALS.G_UI_FLAG) THEN

Line 2212: oe_line_util.calculate_dual_quantity(

2208:
2209: if l_debug_level > 0 then
2210: oe_debug_pub.add('about to call calculate_dual_quantity 1' );
2211: end if;
2212: oe_line_util.calculate_dual_quantity(
2213: p_ordered_quantity => p_x_line_rec.ordered_quantity
2214: ,p_old_ordered_quantity => NULL
2215: ,p_ordered_quantity2 => p_x_line_rec.ordered_quantity2
2216: ,p_old_ordered_quantity2 => NULL

Line 2250: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);

2246: p_x_line_rec.split_by = 'USER'
2247: THEN
2248: /*
2249: p_x_line_rec.ordered_quantity2 :=
2250: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);
2251: */
2252: /* OPM - NC 3/8/02 Bug#2046641
2253: Commented the above call and added the call to calculate_dual_quantity */
2254: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110507') OR NOT(OE_GLOBALS.G_UI_FLAG) THEN

Line 2259: oe_line_util.calculate_dual_quantity(

2255: if l_debug_level > 0 then
2256: oe_debug_pub.add('about to call calculate_dual_quantity 2' );
2257: end if;
2258:
2259: oe_line_util.calculate_dual_quantity(
2260: p_ordered_quantity => p_x_line_rec.ordered_quantity
2261: ,p_old_ordered_quantity => NULL
2262: ,p_ordered_quantity2 => p_x_line_rec.ordered_quantity2
2263: ,p_old_ordered_quantity2 => NULL

Line 3372: OE_Line_Util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec

3368: -- BUG 1491504 BEGIN -- INVCONV stet
3369: -- Warehouse data CAN determine whether the line is treated as process or discrete OR SINGLE uom OR dUAL uom CONTROLLED .
3370: -- Warehouse data can impact quantity calculations, so check the quantites here
3371: -- pal
3372: OE_Line_Util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec
3373: ,p_old_line_rec => p_old_line_rec);
3374: -- Check to see if either the primary or secondary quantity has changed
3375: -- If there is a change, make a recursive call to OE_Order_Pvt.Lines
3376: IF p_x_line_rec.ordered_quantity <> l_ordered_quantity OR

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

6407: /*Bug2848734*/
6408:
6409: if l_debug_level > 0 then
6410: oe_debug_pub.add('return status before exiting '|| p_x_line_rec.return_status, 1);
6411: oe_debug_pub.add('Exiting OE_LINE_UTIL.APPLY_ATTRIBUTE_CHANGES', 1);
6412: end if;
6413:
6414: END Apply_Attribute_Changes;
6415:

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

6427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6428: BEGIN
6429:
6430: IF l_debug_level > 0 THEN
6431: oe_debug_pub.add('Entering OE_LINE_UTIL.COMPLETE_RECORD', 1);
6432: END IF;
6433:
6434: IF p_x_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
6435: p_x_line_rec.accounting_rule_id := p_old_line_rec.accounting_rule_id;

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

7891: p_x_line_rec.fulfillment_base :=p_old_line_rec.fulfillment_base;--ER#14763609
7892: END IF;
7893:
7894: if l_debug_level > 0 then
7895: oe_debug_pub.add('Exiting OE_LINE_UTIL.COMPLETE_RECORD', 1);
7896: end if;
7897:
7898: END Complete_Record;
7899:

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

7910: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7911: BEGIN
7912:
7913: if l_debug_level > 0 then
7914: oe_debug_pub.add('Entering OE_LINE_UTIL.CONVERT_MISS_TO_NULL', 1);
7915:
7916: oe_debug_pub.add('outside margin convert miss to null',1);
7917: end if;
7918: --MRG BGN

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

9355: p_x_line_rec.fulfillment_base := NULL ;--ER#14763609
9356: END IF;
9357:
9358: if l_debug_level > 0 then
9359: oe_debug_pub.add('Exiting OE_LINE_UTIL.CONVERT_MISS_TO_NULL', 1);
9360: end if;
9361: END Convert_Miss_To_Null;
9362:
9363:

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

9378: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9379: BEGIN
9380:
9381: if l_debug_level > 0 then
9382: oe_debug_pub.add('Entering OE_LINE_UTIL.UPDATE_ROW', 1);
9383: end if;
9384: --Commented for MOAC start
9385: /*if l_org_id IS NULL THEN
9386: OE_GLOBALS.Set_Context;

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

9403: p_line_id => p_line_rec.line_id,
9404: x_index => l_index,
9405: x_return_status => l_return_status);
9406: if l_debug_level > 0 then
9407: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);
9408: OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);
9409: OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);
9410: end if;
9411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

9404: x_index => l_index,
9405: x_return_status => l_return_status);
9406: if l_debug_level > 0 then
9407: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);
9408: OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);
9409: OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);
9410: end if;
9411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9412: if l_debug_level > 0 then

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

9405: x_return_status => l_return_status);
9406: if l_debug_level > 0 then
9407: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.update_row is: ' || l_return_status);
9408: OE_DEBUG_PUB.ADD('JFC: Line Booked Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.booked_flag);
9409: OE_DEBUG_PUB.ADD('JFC: Line Flow Status in OE_LINE_UTIL.update_row is: ' || p_line_rec.flow_status_code);
9410: end if;
9411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9412: if l_debug_level > 0 then
9413: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');

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

9410: end if;
9411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9412: if l_debug_level > 0 then
9413: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
9414: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
9415: end if;
9416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9417: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9418: if l_debug_level > 0 then

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

9415: end if;
9416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9417: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9418: if l_debug_level > 0 then
9419: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Update_row');
9420: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
9421: end if;
9422: RAISE FND_API.G_EXC_ERROR;
9423: END IF;

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

9416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9417: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
9418: if l_debug_level > 0 then
9419: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Update_row');
9420: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.Update_ROW', 1);
9421: end if;
9422: RAISE FND_API.G_EXC_ERROR;
9423: END IF;
9424: END IF; /*code_release_level*/

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

9811:
9812: p_line_rec.lock_control := l_lock_control;
9813:
9814: if l_debug_level > 0 then
9815: oe_debug_pub.add('Exiting OE_LINE_UTIL.UPDATE_ROW', 1);
9816: end if;
9817:
9818: EXCEPTION
9819:

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

9854: l_price_request_code VARCHAR2(240);
9855: BEGIN
9856:
9857: if l_debug_level > 0 then
9858: oe_debug_pub.add('Entering OE_LINE_UTIL.INSERT_ROW', 1);
9859: end if;
9860:
9861: --MOAC change
9862: OE_GLOBALS.Set_Context;

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

10676: p_line_id => p_line_rec.line_id,
10677: x_index => l_index,
10678: x_return_status => l_return_status);
10679: if l_debug_level > 0 then
10680: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.inset_row is: ' || l_return_status);
10681: OE_DEBUG_PUB.ADD('returned index is: ' || l_index ,1);
10682: end if;
10683: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10684: if l_debug_level > 0 then

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

10682: end if;
10683: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10684: if l_debug_level > 0 then
10685: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
10686: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
10687: end if;
10688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
10690: if l_debug_level > 0 then

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

10687: end if;
10688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
10690: if l_debug_level > 0 then
10691: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.insert_row');
10692: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
10693: end if;
10694: RAISE FND_API.G_EXC_ERROR;
10695: END IF;

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

10688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10689: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
10690: if l_debug_level > 0 then
10691: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.insert_row');
10692: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.insert_ROW', 1);
10693: end if;
10694: RAISE FND_API.G_EXC_ERROR;
10695: END IF;
10696: END IF; /*code_release_code*/

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

10696: END IF; /*code_release_code*/
10697: -- notification framework end
10698:
10699: if l_debug_level > 0 then
10700: oe_debug_pub.add('Exiting OE_LINE_UTIL.INSERT_ROW', 1);
10701: end if;
10702:
10703: EXCEPTION
10704:

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

10773: AND service_reference_type_code = 'ORDER'; --bug 3056313
10774:
10775: BEGIN
10776:
10777: oe_debug_pub.add('Entering OE_LINE_UTIL.DELETE_ROW', 1);
10778: --Commented for MOAC start
10779: /*l_org_id := OE_GLOBALS.G_ORG_ID;
10780:
10781: IF l_org_id IS NULL THEN

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

10800: p_line_rec =>l_new_line_rec,
10801: p_line_id =>l_line.line_id,
10802: x_index => l_index,
10803: x_return_status => l_return_status);
10804: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row is: ' || l_return_status);
10805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10806: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
10807: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
10808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

10803: x_return_status => l_return_status);
10804: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row is: ' || l_return_status);
10805: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10806: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
10807: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
10808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
10810: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
10811: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

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

10806: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
10807: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
10808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
10810: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
10811: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
10812: RAISE FND_API.G_EXC_ERROR;
10813: END IF;
10814: END IF; /*code_release_level*/

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

10807: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
10808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10809: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
10810: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
10811: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
10812: RAISE FND_API.G_EXC_ERROR;
10813: END IF;
10814: END IF; /*code_release_level*/
10815: -- notification framework end

Line 10866: oe_line_util.query_row

10862:
10863: ELSE -- header_id is missing.
10864: oe_debug_pub.add('hdr missing delete_row,line_id: '||p_line_id, 1);
10865:
10866: oe_line_util.query_row
10867: (p_line_id => p_line_id
10868: ,x_line_rec => l_line_rec );
10869:
10870: lvariable2 := p_line_id;

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

11095: p_line_rec =>l_new_line_rec,
11096: p_line_id =>l_line_rec.line_id,
11097: x_index => l_index,
11098: x_return_status => l_return_status);
11099: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting standard line is: ' || l_return_status);
11100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11101: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
11102: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

11098: x_return_status => l_return_status);
11099: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting standard line is: ' || l_return_status);
11100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11101: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
11102: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11105: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
11106: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

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

11101: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
11102: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11105: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
11106: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11107: RAISE FND_API.G_EXC_ERROR;
11108: END IF;
11109: END IF; /*code_release_level*/

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

11102: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11104: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11105: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
11106: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11107: RAISE FND_API.G_EXC_ERROR;
11108: END IF;
11109: END IF; /*code_release_level*/
11110: -- notification framework end

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

11129: p_line_id =>l_svc.line_id,
11130: x_index => l_index,
11131: x_return_status => l_return_status);
11132:
11133: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting service line is: ' || l_return_status);
11134: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11135: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
11136: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

11132:
11133: OE_DEBUG_PUB.ADD('Update_Global Return Status from OE_LINE_UTIL.delete_row for deleting service line is: ' || l_return_status);
11134: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11135: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
11136: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11139: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
11140: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);

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

11135: OE_DEBUG_PUB.ADD('EVENT NOTIFY - Unexpected Error');
11136: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11139: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
11140: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11141: RAISE FND_API.G_EXC_ERROR;
11142: END IF;
11143: END LOOP;

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

11136: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11138: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11139: OE_DEBUG_PUB.ADD('Update_Global_Picture Error in OE_LINE_UTIL.Delete_row');
11140: OE_DEBUG_PUB.ADD('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11141: RAISE FND_API.G_EXC_ERROR;
11142: END IF;
11143: END LOOP;
11144: END IF; /*code_release_level*/

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

11205: END IF;
11206: END;
11207: END IF; -- profile is yes
11208:
11209: oe_debug_pub.add('Exiting OE_LINE_UTIL.DELETE_ROW', 1);
11210:
11211: EXCEPTION
11212: WHEN FND_API.G_EXC_ERROR THEN
11213: RAISE FND_API.G_EXC_ERROR ;

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

11626:
11627: BEGIN
11628:
11629: IF l_debug_level > 0 THEN
11630: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROW, line_id:'||p_line_id, 1);
11631: END IF;
11632:
11633:
11634: OPEN l_line_csr;

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

12025:
12026: CLOSE l_line_csr;
12027:
12028: IF l_debug_level > 0 THEN
12029: oe_debug_pub.add('Exiting OE_LINE_UTIL.QUERY_ROW', 1);
12030: END IF;
12031:
12032:
12033: EXCEPTION

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

12862: l_line_rec OE_ORDER_PUB.line_rec_type;
12863: BEGIN
12864:
12865: IF l_debug_level > 0 THEN
12866: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS, line_id:'||p_line_id, 1);
12867: END IF;
12868:
12869: IF
12870: (p_line_id IS NOT NULL

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

13700:
13701:
13702: -- Return fetched table
13703: IF l_debug_level > 0 THEN
13704: oe_debug_pub.add('Exiting OE_LINE_UTIL.QUERY_ROWS', 1);
13705: END IF;
13706:
13707: EXCEPTION
13708:

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

13776: --
13777: BEGIN
13778:
13779: IF l_debug_level > 0 THEN
13780: oe_debug_pub.add('Entering OE_LINE_UTIL.LOCK_ROW', 1);
13781: END IF;
13782:
13783: SAVEPOINT Lock_Row;
13784:

Line 13933: oe_line_util.Query_Row

13929: IF l_lock_control IS NULL
13930: OR (l_lock_control <> l_db_lock_control)
13931: OR (OE_GLOBALS.G_UI_FLAG = TRUE ) THEN -- 3025978
13932:
13933: oe_line_util.Query_Row
13934: (p_line_id => l_line_id
13935: ,x_line_rec => p_x_line_rec
13936: );
13937:

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

14012:
14013: OE_GLOBALS.G_LOCK_TEST := 'N';
14014:
14015: IF l_debug_level > 0 THEN
14016: oe_debug_pub.add('Exiting OE_LINE_UTIL.LOCK_ROW', 1);
14017: oe_debug_pub.add(' ', 1);
14018: oe_debug_pub.add('lock const: '|| oe_globals.g_lock_const, 1);
14019: END IF;
14020:

Line 14155: oe_line_util.Query_Rows

14151: END;
14152:
14153: -- locked all lines
14154:
14155: oe_line_util.Query_Rows
14156: (p_line_id => p_line_id
14157: ,p_header_id => p_header_id
14158: ,x_line_tbl => x_line_tbl
14159: );

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

14158: ,x_line_tbl => x_line_tbl
14159: );
14160:
14161: IF l_debug_level > 0 THEN
14162: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS', 1);
14163: END IF;
14164:
14165: x_return_status := FND_API.G_RET_STS_SUCCESS;
14166:

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

14215: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14216: BEGIN
14217:
14218: if l_debug_level > 0 then
14219: OE_DEBUG_PUB.add('Entering OE_LINE_UTIL.Get_Values');
14220: end if;
14221:
14222: IF (p_line_rec.calculate_price_flag IS NULL OR
14223: p_line_rec.calculate_price_flag <> FND_API.G_MISS_CHAR) AND

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

17951: THEN
17952: if l_debug_level > 0 then
17953: oe_debug_pub.ADD('Calling IS_OVER_RETURN ',1);
17954: end if;
17955: IF (OE_LINE_UTIL.Is_Over_Return(p_x_line_rec)) THEN
17956: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
17957: OE_MSG_PUB.Add;
17958: RAISE FND_API.G_EXC_ERROR;
17959: END IF;

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

18970: l_line_rec OE_Order_PUB.Line_Rec_Type;
18971: l_cursor_flag VARCHAR2(1) := null;
18972:
18973: BEGIN
18974: oe_debug_pub.add('Entering OE_LINE_UTIL.CASCADE_LINE_NUMBER ');
18975: oe_debug_pub.add('AK line_id ' || p_line_id);
18976: oe_debug_pub.add('AK line_iset_d ' || p_line_set_id);
18977: oe_debug_pub.add('AK line_number' || p_line_number);
18978: oe_debug_pub.add('AK item_type_code' || p_item_type_code);

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

19152: CLOSE Service_line_number;
19153:
19154: END IF; /*p_item_type_code*/
19155:
19156: oe_debug_pub.add('Exiting OE_LINE_UTIL.CASCADE_LINE_NUMBER ');
19157:
19158: EXCEPTION
19159:
19160: WHEN NO_DATA_FOUND THEN

Line 20452: IF oe_line_util.Process_Characteristics

20448: and item.alloc_class = alot.alloc_class
20449: and alot.delete_mark = 0;
20450: BEGIN
20451:
20452: IF oe_line_util.Process_Characteristics
20453: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id,l_item_rec) AND
20454: ((NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_item
20455: ,p_old_line_rec.ordered_item)) OR
20456: (NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id

Line 21112: IF oe_line_util.Process_Characteristics

21108:
21109:
21110: -- If this is a process line, load the item details from cache
21111: --==============================================================
21112: IF oe_line_util.Process_Characteristics
21113: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id,l_item_rec) THEN
21114: NULL;
21115: ELSE
21116: RETURN p_line_rec.ordered_quantity2;

Line 21256: oe_line_util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec

21252: -- As part of scheduling restructure. dependency will added with
21253: -- bug 2164440.
21254: --4504362 : Branch Scheduling check removed.
21255: -- OPM 02/JUN/00
21256: oe_line_util.Sync_Dual_Qty (p_x_line_rec => p_x_line_rec
21257: ,p_old_line_rec => p_old_line_rec);
21258: -- OPM 02/JUN/00 END
21259: -- INVCONV
21260: -- check this - why call here ?? need to know where to call in proper place - ask OM team

Line 21296: oe_line_util.calculate_dual_quantity(

21292: end if;
21293: IF l_qty <>0 or
21294: l_qty2 <> 0
21295: then
21296: oe_line_util.calculate_dual_quantity(
21297: p_ordered_quantity => l_qty
21298: ,p_old_ordered_quantity => NULL
21299: ,p_ordered_quantity2 => l_qty2 -- p_x_line_rec.reserved_quantity2
21300: ,p_old_ordered_quantity2 => NULL

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

23155: oe_debug_pub.add('Before calling Version_Audit_Process',1);
23156: end if;
23157:
23158: --Adding code to log versioning/audit request
23159: OE_Line_Util.Version_Audit_Process(p_x_line_rec => p_x_line_rec,
23160: p_old_line_rec => p_old_line_rec);
23161:
23162: --bug 3988559 modify sfadnavi END
23163:

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

23992: up_f oe_price_adjustments.updated_flag%TYPE;
23993: row_count NUMBER;
23994:
23995: BEGIN
23996: oe_debug_pub.ADD('Entering OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
23997:
23998: IF p_old_line_rec.inventory_item_id IS NULL THEN
23999: --new item, dont need to do anything
24000: oe_debug_pub.ADD('New Item, dont have to do anything',1);

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

23997:
23998: IF p_old_line_rec.inventory_item_id IS NULL THEN
23999: --new item, dont need to do anything
24000: oe_debug_pub.ADD('New Item, dont have to do anything',1);
24001: oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
24002: RETURN;
24003: END IF;
24004:
24005: --deleting the IUE adjustment

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

24068:
24069: END LOOP;
24070: CLOSE c1;
24071: oe_debug_pub.ADD('...done looking for item parent lines',1);
24072: oe_debug_pub.ADD('Exiting OE_LINE_UTIL.UPDATE_ADJUSTMENT_FLAGS',1);
24073: RETURN;
24074:
24075: END update_adjustment_flags;
24076:

Line 24578: oe_debug_pub.add('Entering OE_LINE_UTIL.Get_customer_info_ids :'||p_line_customer_info_tbl.count);

24574:
24575: x_return_status := FND_API.G_RET_STS_SUCCESS;
24576:
24577: IF l_debug_level >0 then
24578: oe_debug_pub.add('Entering OE_LINE_UTIL.Get_customer_info_ids :'||p_line_customer_info_tbl.count);
24579: End IF;
24580:
24581: IF p_line_customer_info_tbl.count = 0 THEN
24582: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 24737: oe_debug_pub.add('Entering OE_LINE_UTIL.Get_customer_info_ids :'||p_line_customer_info_tbl.count);

24733:
24734: OE_CUSTOMER_INFO_PVT.G_SOLD_TO_CUSTOMER_ID := NULL;
24735:
24736: IF l_debug_level >0 then
24737: oe_debug_pub.add('Entering OE_LINE_UTIL.Get_customer_info_ids :'||p_line_customer_info_tbl.count);
24738: End IF;
24739:
24740:
24741:

Line 24870: END oe_line_util;

24866:
24867: END copy_assoc;
24868: --bug 16317238 end
24869:
24870: END oe_line_util;