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

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

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

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

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

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

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

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

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

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

118: l_dummy VARCHAR2(1);
119: l_manual_hold_exists varchar2(1) := 'N';
120: l_released_rec_exists varchar2(1) := 'Y';
121: --
122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
123: --
124:
125: --added for BUG#9728597 Start
126: cursor released_hold is

Line 197: oe_debug_pub.add('An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);

193: END IF;
194: CLOSE released_hold;
195: EXCEPTION
196: WHEN OTHERS THEN
197: oe_debug_pub.add('An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
198: l_released_rec_exists := 'N';
199: --added for BUG#9728597 End
200:
201: END;

Line 236: oe_debug_pub.add('An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);

232: END IF;
233: CLOSE released_hold_line;
234: EXCEPTION
235: WHEN OTHERS THEN
236: oe_debug_pub.add('An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
237: l_released_rec_exists := 'N';
238: --added for BUG#9728597 End
239:
240: END;

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

334: AND p.ORGANIZATION_ID = p_organization_id
335: AND rownum < 2; */
336:
337: --
338: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
339: --
340: CURSOR drop_ship_line_cost IS
341: SELECT POL.UNIT_PRICE
342: FROM PO_LINES_ALL POL,

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

392: l_ind,
393: l_result,
394: l_return_status);
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'INDEX=' || L_IND , 1 ) ;
397: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STATUS , 1 ) ;
398: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
399: END IF;
400:

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

393: l_result,
394: l_return_status);
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'INDEX=' || L_IND , 1 ) ;
397: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STATUS , 1 ) ;
398: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
399: END IF;
400:
401: IF l_result = FND_API.G_TRUE then

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

394: l_return_status);
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'INDEX=' || L_IND , 1 ) ;
397: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STATUS , 1 ) ;
398: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
399: END IF;
400:
401: IF l_result = FND_API.G_TRUE then
402: l_line_rec := OE_ORDER_UTIL.G_Line_Tbl(l_ind);

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

560: FROM mtl_parameters
561: WHERE organization_id = G_SHIP_FROM_ORG_ID;
562: G_COST_GROUP_ID := l_cost_group_id; --bug14282027
563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add( ' COST GROUP ID FOR NONE PROJECT ITEM:'||L_COST_GROUP_ID ) ;
565: END IF;
566:
567: ELSE
568:

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

887: l_transaction_type_id NUMBER;
888: l_min_margin_percent NUMBER;
889:
890: --
891: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
892: --
893: BEGIN
894: debug('Entering function min_margin_percent');
895: debug(' p_header_id:'||p_header_id);

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

945: AND unit_cost IS NOT NULL
946: AND line_category_code = 'ORDER';
947: --bug 5654745}
948: --
949: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
950: --
951: BEGIN
952: debug('Entering Oe_Margin_Pvt.Get_Order_Margin');
953: --retrive margin calculation method perference

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

1083: l_order_margin_amount number;
1084: l_manual_released Varchar2(1):= 'N';
1085: l_booked_flag Varchar2(1):='N';
1086: --
1087: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1088: --
1089: BEGIN
1090: debug('Entering Oe_Margin_Pvt.Margin_Hold');
1091:

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

1196: Function Is_Margin_Avail return Boolean Is
1197: l_release_level Varchar2(15);
1198: l_correct_release Boolean;
1199: --
1200: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1201: --
1202: BEGIN
1203: l_release_level:=Oe_Code_Control.Get_Code_Release_Level;
1204:

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

1223: Begin
1224: l_cost:=Get_Cost(p_line_rec=>p_line_rec);
1225: x_unit_cost:=l_cost;
1226: If p_line_rec.unit_selling_price is Null Then
1227: oe_debug_pub.add('Warning:- unit selling price is null,margin not relevant');
1228: oe_debug_pub.add('Exiting oe_margin_pvt.get_line_margin');
1229: Return;
1230: End If;
1231: l_margin_amt := nvl(p_line_rec.unit_selling_price,0) - nvl(l_cost,0); --bug 5155086

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

1224: l_cost:=Get_Cost(p_line_rec=>p_line_rec);
1225: x_unit_cost:=l_cost;
1226: If p_line_rec.unit_selling_price is Null Then
1227: oe_debug_pub.add('Warning:- unit selling price is null,margin not relevant');
1228: oe_debug_pub.add('Exiting oe_margin_pvt.get_line_margin');
1229: Return;
1230: End If;
1231: l_margin_amt := nvl(p_line_rec.unit_selling_price,0) - nvl(l_cost,0); --bug 5155086
1232: x_unit_margin_amount:=l_margin_amt;

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

1232: x_unit_margin_amount:=l_margin_amt;
1233:
1234: IF G_COMPUTE_METHOD = 'P' THEN
1235: If p_line_rec.unit_selling_price = 0 Then
1236: oe_debug_pub.add('Warning: Price based margin calculation is invalid,because 0 selling price, divided by zero error would occur. Returning');
1237: x_margin_percent:=NULL;
1238: Return;
1239: End If;
1240:

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

1242: x_margin_percent := l_margin_percent;
1243: Elsif G_COMPUTE_METHOD = 'C' THEN
1244: -- If p_line_rec.unit_selling_price = 0 Then bug5939162
1245: If nvl(l_cost,0) = 0 Then
1246: oe_debug_pub.add('Warning: Cost based margin calculation is invalid,because 0 cost, divided by zero error would occur. Returning');
1247: x_margin_percent:=NULL;
1248: Return;
1249: End If;
1250: