DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on OE_DEBUG_PUB

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

16: )
17: IS
18:
19: --
20: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21: --
22: Begin
23: IF G_DEBUG IS NULL THEN
24: IF OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE THEN

Line 24: IF OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE THEN

20: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21: --
22: Begin
23: IF G_DEBUG IS NULL THEN
24: IF OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE THEN
25: G_DEBUG := 'Y';
26: ELSE
27: G_DEBUG := 'N';
28: END IF;

Line 33: oe_debug_pub.add( P_TEXT , NVL ( P_LEVEL , 5 ) ) ;

29: END IF;
30:
31: IF G_DEBUG = 'Y' THEN
32: IF l_debug_level > 0 THEN
33: oe_debug_pub.add( P_TEXT , NVL ( P_LEVEL , 5 ) ) ;
34: END IF;
35: END IF;
36: End;
37:

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

53: i number;
54: l_org_id Number;
55: l_prev_org_id Number;
56: --
57: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
58: --
59: begin
60: debug('Inside oe_margin_pvt_1.cost_action',1);
61: If P_cost_level ='LINE' then

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

117: l_dummy VARCHAR2(1);
118: l_manual_hold_exists varchar2(1) := 'N';
119: l_released_rec_exists varchar2(1) := 'Y';
120: --
121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
122: --
123: BEGIN
124: debug('Entering OE_MARGIN_PUB.Check_Manual_Released_Holds');
125: Debug(' Checking for Manually Released Holds on header_id'||

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

261: AND p.ORGANIZATION_ID = p_organization_id
262: AND rownum < 2; */
263:
264: --
265: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
266: --
267: CURSOR drop_ship_line_cost IS
268: SELECT POL.UNIT_PRICE
269: FROM PO_LINES_ALL POL,

Line 323: oe_debug_pub.add( 'INDEX=' || L_IND , 1 ) ;

319: l_ind,
320: l_result,
321: l_return_status);
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'INDEX=' || L_IND , 1 ) ;
324: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STATUS , 1 ) ;
325: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
326: END IF;
327:

Line 324: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STATUS , 1 ) ;

320: l_result,
321: l_return_status);
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'INDEX=' || L_IND , 1 ) ;
324: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STATUS , 1 ) ;
325: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
326: END IF;
327:
328: IF l_result = FND_API.G_TRUE then

Line 325: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;

321: l_return_status);
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'INDEX=' || L_IND , 1 ) ;
324: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STATUS , 1 ) ;
325: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
326: END IF;
327:
328: IF l_result = FND_API.G_TRUE then
329: l_line_rec := OE_ORDER_UTIL.G_Line_Tbl(l_ind);

Line 490: oe_debug_pub.add( ' COST GROUP ID FOR NONE PROJECT ITEM:'||L_COST_GROUP_ID ) ;

486: INTO l_cost_group_id
487: FROM mtl_parameters
488: WHERE organization_id = G_SHIP_FROM_ORG_ID;
489: IF l_debug_level > 0 THEN
490: oe_debug_pub.add( ' COST GROUP ID FOR NONE PROJECT ITEM:'||L_COST_GROUP_ID ) ;
491: END IF;
492:
493: ELSE
494:

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

771: l_transaction_type_id NUMBER;
772: l_min_margin_percent NUMBER;
773:
774: --
775: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
776: --
777: BEGIN
778: debug('Entering function min_margin_percent');
779: debug(' p_header_id:'||p_header_id);

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

829: AND unit_cost IS NOT NULL
830: AND line_category_code = 'ORDER';
831: --bug 5654745}
832: --
833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
834: --
835: BEGIN
836: debug('Entering Oe_Margin_Pvt.Get_Order_Margin');
837: --retrive margin calculation method perference

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

967: l_order_margin_amount number;
968: l_manual_released Varchar2(1):= 'N';
969: l_booked_flag Varchar2(1):='N';
970: --
971: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
972: --
973: BEGIN
974: debug('Entering Oe_Margin_Pvt.Margin_Hold');
975:

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

1080: Function Is_Margin_Avail return Boolean Is
1081: l_release_level Varchar2(15);
1082: l_correct_release Boolean;
1083: --
1084: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1085: --
1086: BEGIN
1087: l_release_level:=Oe_Code_Control.Get_Code_Release_Level;
1088:

Line 1111: oe_debug_pub.add('Warning:- unit selling price is null,margin not relevant');

1107: Begin
1108: l_cost:=Get_Cost(p_line_rec=>p_line_rec);
1109: x_unit_cost:=l_cost;
1110: If p_line_rec.unit_selling_price is Null Then
1111: oe_debug_pub.add('Warning:- unit selling price is null,margin not relevant');
1112: oe_debug_pub.add('Exiting oe_margin_pvt.get_line_margin');
1113: Return;
1114: End If;
1115: l_margin_amt := nvl(p_line_rec.unit_selling_price,0) - nvl(l_cost,0); --bug 5155086

Line 1112: oe_debug_pub.add('Exiting oe_margin_pvt.get_line_margin');

1108: l_cost:=Get_Cost(p_line_rec=>p_line_rec);
1109: x_unit_cost:=l_cost;
1110: If p_line_rec.unit_selling_price is Null Then
1111: oe_debug_pub.add('Warning:- unit selling price is null,margin not relevant');
1112: oe_debug_pub.add('Exiting oe_margin_pvt.get_line_margin');
1113: Return;
1114: End If;
1115: l_margin_amt := nvl(p_line_rec.unit_selling_price,0) - nvl(l_cost,0); --bug 5155086
1116: x_unit_margin_amount:=l_margin_amt;

Line 1120: oe_debug_pub.add('Warning: Price based margin calculation is invalid,because 0 selling price, divided by zero error would occur. Returning');

1116: x_unit_margin_amount:=l_margin_amt;
1117:
1118: IF G_COMPUTE_METHOD = 'P' THEN
1119: If p_line_rec.unit_selling_price = 0 Then
1120: oe_debug_pub.add('Warning: Price based margin calculation is invalid,because 0 selling price, divided by zero error would occur. Returning');
1121: x_margin_percent:=NULL;
1122: Return;
1123: End If;
1124:

Line 1130: oe_debug_pub.add('Warning: Cost based margin calculation is invalid,because 0 cost, divided by zero error would occur. Returning');

1126: x_margin_percent := l_margin_percent;
1127: Elsif G_COMPUTE_METHOD = 'C' THEN
1128: -- If p_line_rec.unit_selling_price = 0 Then bug5939162
1129: If nvl(l_cost,0) = 0 Then
1130: oe_debug_pub.add('Warning: Cost based margin calculation is invalid,because 0 cost, divided by zero error would occur. Returning');
1131: x_margin_percent:=NULL;
1132: Return;
1133: End If;
1134: