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

Line 50: oe_debug_pub.add(' CustAcctID_func -l_Custid- '||l_Custid);

46: AND siteuse.site_use_code ='BILL_TO'
47: AND siteuse.status = 'A'
48: AND cust.cust_account_id =site.cust_account_id ;
49:
50: oe_debug_pub.add(' CustAcctID_func -l_Custid- '||l_Custid);
51: RETURN(l_Custid);
52: EXCEPTION
53: WHEN NO_DATA_FOUNd THEN
54: oe_debug_pub.add(' CustAcctID_func, No Data Found, p_in_site_id= '||p_in_site_id);

Line 54: oe_debug_pub.add(' CustAcctID_func, No Data Found, p_in_site_id= '||p_in_site_id);

50: oe_debug_pub.add(' CustAcctID_func -l_Custid- '||l_Custid);
51: RETURN(l_Custid);
52: EXCEPTION
53: WHEN NO_DATA_FOUNd THEN
54: oe_debug_pub.add(' CustAcctID_func, No Data Found, p_in_site_id= '||p_in_site_id);
55: p_out_IDfound:='N';
56: RETURN 0;
57: WHEN OTHERS THEN
58: oe_debug_pub.add(' CustAcctID_func, When Others Exception, p_in_site_id='||p_in_site_id);

Line 58: oe_debug_pub.add(' CustAcctID_func, When Others Exception, p_in_site_id='||p_in_site_id);

54: oe_debug_pub.add(' CustAcctID_func, No Data Found, p_in_site_id= '||p_in_site_id);
55: p_out_IDfound:='N';
56: RETURN 0;
57: WHEN OTHERS THEN
58: oe_debug_pub.add(' CustAcctID_func, When Others Exception, p_in_site_id='||p_in_site_id);
59: p_out_IDfound:='N';
60: RETURN 0;
61: END;
62: --ER# 3667551 END

Line 129: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug

125:
126: l_count BINARY_INTEGER;
127: BEGIN
128:
129: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
130: -- Clear the Globals.
131: g_hold_header_id.DELETE;
132: g_hold_line_id.DELETE;
133: g_hold_Source_Id.DELETE;

Line 297: oe_debug_pub.add('Before opening C_Hold_Sources'); --ER#7479609 debug

293: EndCust_EndCustLoc_Hold.Delete;
294:
295: --ER# 12571983 end added for 'EC'
296:
297: oe_debug_pub.add('Before opening C_Hold_Sources'); --ER#7479609 debug
298: -- Load the Hold Sources into Globals.
299: OPEN C_Hold_Sources;
300: FETCH C_Hold_Sources BULK COLLECT INTO
301: T_HOLD_SOURCE_ID,

Line 309: oe_debug_pub.add('After Closing C_Hold_Sources:'||T_HOLD_SOURCE_ID.COUNT); --ER#7479609 debug

305: T_HOLD_ENTITY_CODE2,
306: T_HOLD_ACTIVITY_NAME,
307: T_HOLD_ID;--ER# 3667551
308: CLOSE C_Hold_Sources;
309: oe_debug_pub.add('After Closing C_Hold_Sources:'||T_HOLD_SOURCE_ID.COUNT); --ER#7479609 debug
310:
311: FOR i IN 1..T_HOLD_SOURCE_ID.COUNT LOOP
312:
313: -- Load Customer Hold Source

Line 457: oe_debug_pub.add('Before Loading payment type'); --ER#7479609 debug

453: SalesChannel_Pointer(T_HOLD_ENTITY_ID(i)) := l_count+1;
454: END IF;
455: END IF;
456:
457: oe_debug_pub.add('Before Loading payment type'); --ER#7479609 debug
458: IF T_HOLD_ENTITY_CODE(i) = 'P' AND T_HOLD_ENTITY_ID2(i) IS NULL
459: THEN
460: l_count := PaymentType_Hold.COUNT;
461: PaymentType_Hold(l_count+1).Entity_Id1 := T_HOLD_ENTITY_ID(i);

Line 1014: oe_debug_pub.add('Before Loading Ware House'); --ER#7479609 debug

1010:
1011: END IF;
1012:
1013: --ER#7479609 end
1014: oe_debug_pub.add('Before Loading Ware House'); --ER#7479609 debug
1015: -- Load Warehouse Customer Hold Source
1016: IF T_HOLD_ENTITY_CODE(i) = 'W' AND T_HOLD_ENTITY_CODE2(i) = 'C'
1017: THEN
1018: l_count := Warehouse_Customer_Hold.COUNT;

Line 1375: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug

1371: --ER# 13331078 END for 'IC'
1372:
1373: END LOOP;
1374:
1375: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Load_Hold_Sources'); --ER#7479609 debug
1376:
1377: EXCEPTION
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1415: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');

1411: l_invoice_Custid NUMBER := 0;
1412: --ER# 3667551 end;
1413:
1414: BEGIN
1415: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');
1416: oe_debug_pub.add('Header'||p_header_rec.header_id);
1417: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);
1418:
1419: -- Set the OUT parameter

Line 1416: oe_debug_pub.add('Header'||p_header_rec.header_id);

1412: --ER# 3667551 end;
1413:
1414: BEGIN
1415: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');
1416: oe_debug_pub.add('Header'||p_header_rec.header_id);
1417: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);
1418:
1419: -- Set the OUT parameter
1420: p_on_generic_hold := FALSE;

Line 1417: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);

1413:
1414: BEGIN
1415: oe_debug_pub.add('Entering OE_Bulk_Holds_PVT.Evaluate_Holds');
1416: oe_debug_pub.add('Header'||p_header_rec.header_id);
1417: oe_debug_pub.add('Line:'||p_line_rec.header_id||':'||p_line_rec.line_id);
1418:
1419: -- Set the OUT parameter
1420: p_on_generic_hold := FALSE;
1421: p_on_booking_hold := FALSE;

Line 1438: oe_debug_pub.add('Credit Hold TYpe System Parameter set to BillToCustomer, no header level hold');

1434: -- applying hold is handled seperately below this section so no hold to be applied for BTH also here
1435: --
1436: If(l_credithold_syspar IN('BTL','BTH') AND Customer_hold(j).hold_id=1) then
1437: j := j+1; -- Increment counter so that next hold data is processed
1438: oe_debug_pub.add('Credit Hold TYpe System Parameter set to BillToCustomer, no header level hold');
1439: Else
1440: --ER# 3667551 end
1441: Mark_Hold(p_header_id => p_header_rec.header_id,
1442: p_line_id => NULL,

Line 1755: oe_debug_pub.add(' CH sold_to_org_id= ' ||p_line_rec.sold_to_org_id||'invoice_to_org_id= '||p_line_rec.invoice_to_org_id);

1751: p_out_IDfound=> l_custlin_hold);
1752: --IF Customer_Pointer.EXISTS(p_line_rec.sold_to_org_id) THEN
1753: IF (Customer_Pointer.EXISTS(l_invoice_Custid) AND l_custlin_hold = 'Y') THEN
1754: j := Customer_Pointer(l_invoice_Custid);
1755: oe_debug_pub.add(' CH sold_to_org_id= ' ||p_line_rec.sold_to_org_id||'invoice_to_org_id= '||p_line_rec.invoice_to_org_id);
1756:
1757: WHILE (Customer_hold(j).Entity_Id1 = l_invoice_Custid )
1758: LOOP
1759:

Line 4050: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug

4046:
4047: --ER# 13331078 END added 'IC'
4048:
4049: END IF;
4050: oe_debug_pub.add('Exitting OE_Bulk_Holds_PVT.Evaluate_Holds'); --ER#7479609 debug
4051: EXCEPTION
4052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4054: WHEN OTHERS THEN

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

4559: END Extend_Holds_Tbl;
4560:
4561: PROCEDURE Create_Holds
4562: IS
4563: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4564: l_org_id number :=mo_global.get_current_org_id; --5488209
4565: BEGIN
4566:
4567: IF l_debug_level > 0 THEN

Line 4568: oe_debug_pub.add('No. of holds to create is '||G_Hold_header_id.COUNT);

4564: l_org_id number :=mo_global.get_current_org_id; --5488209
4565: BEGIN
4566:
4567: IF l_debug_level > 0 THEN
4568: oe_debug_pub.add('No. of holds to create is '||G_Hold_header_id.COUNT);
4569: oe_debug_pub.add('No. of holds sources to create is '
4570: ||g_hold_source_rec.HOLD_SOURCE_ID.COUNT);
4571: END IF;
4572:

Line 4569: oe_debug_pub.add('No. of holds sources to create is '

4565: BEGIN
4566:
4567: IF l_debug_level > 0 THEN
4568: oe_debug_pub.add('No. of holds to create is '||G_Hold_header_id.COUNT);
4569: oe_debug_pub.add('No. of holds sources to create is '
4570: ||g_hold_source_rec.HOLD_SOURCE_ID.COUNT);
4571: END IF;
4572:
4573: FORALL i IN 1..G_Hold_header_id.COUNT

Line 4659: oe_debug_pub.add('In OTHERS error ' || SUBSTR(sqlerrm,1,240), 1);

4655: END IF;
4656: EXCEPTION
4657: WHEN OTHERS THEN
4658: IF l_debug_level > 0 THEN
4659: oe_debug_pub.add('In OTHERS error ' || SUBSTR(sqlerrm,1,240), 1);
4660: END IF;
4661: OE_BULK_MSG_PUB.Add_Exc_Msg
4662: ( G_PKG_NAME
4663: , 'Create_Holds'

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

4675: p_attribute IN VARCHAR2,
4676: p_top_model_line_id IN NUMBER
4677: )
4678: IS
4679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4680: i BINARY_INTEGER;
4681: BEGIN
4682:
4683: i := G_Hold_header_id.COUNT;

Line 4706: oe_debug_pub.add('In OTHERS error - Mark_Hold ' ||

4702:
4703: EXCEPTION
4704: WHEN OTHERS THEN
4705: IF l_debug_level > 0 THEN
4706: oe_debug_pub.add('In OTHERS error - Mark_Hold ' ||
4707: SUBSTR(sqlerrm,1,240), 1);
4708: END IF;
4709: OE_BULK_MSG_PUB.Add_Exc_Msg
4710: ( G_PKG_NAME

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

4872: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 --bug 3735141
4873: )
4874: IS
4875: i BINARY_INTEGER;
4876: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4877: BEGIN
4878: x_return_status := FND_API.G_RET_STS_SUCCESS;
4879: -- Check the count of the Global Table for Hold Source Rec
4880: i := g_hold_source_rec.HOLD_ID.COUNT;

Line 4911: oe_debug_pub.add('In OTHERS error - Apply GSA Hold ' ||

4907: --bug 3735141
4908: EXCEPTION
4909: WHEN OTHERS THEN
4910: IF l_debug_level > 0 THEN
4911: oe_debug_pub.add('In OTHERS error - Apply GSA Hold ' ||
4912: SUBSTR(sqlerrm,1,240), 1);
4913: END IF;
4914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4915: --bug 3735141

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

4948: IS
4949:
4950: l_result BOOLEAN;
4951: l_header_hold_index BINARY_INTEGER;
4952: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4953:
4954: BEGIN
4955:
4956: IF l_debug_level > 0 THEN

Line 4957: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');

4953:
4954: BEGIN
4955:
4956: IF l_debug_level > 0 THEN
4957: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');
4958: oe_debug_pub.add( 'p_line_index is '||p_line_index);
4959: END IF;
4960:
4961: -- Initialize API return value to False

Line 4958: oe_debug_pub.add( 'p_line_index is '||p_line_index);

4954: BEGIN
4955:
4956: IF l_debug_level > 0 THEN
4957: oe_debug_pub.add( 'IN OE_BULK_HOLDS_PVT.Check_For_Holds');
4958: oe_debug_pub.add( 'p_line_index is '||p_line_index);
4959: END IF;
4960:
4961: -- Initialize API return value to False
4962: l_result := FALSE;

Line 4969: oe_debug_pub.add( 'Line on Generic Hold' ||p_line_id ) ;

4965: IF G_Line_Holds_Tbl.EXISTS(p_line_index) THEN
4966: IF G_Line_Holds_Tbl(p_line_index).On_Generic_Hold = 'Y' THEN
4967:
4968: IF l_debug_level > 0 THEN
4969: oe_debug_pub.add( 'Line on Generic Hold' ||p_line_id ) ;
4970: END IF;
4971: RETURN TRUE;
4972:
4973: END IF;

Line 4982: oe_debug_pub.add( 'HEADER LEVEL HOLD EXISTS' ) ;

4978: p_hold_index => l_header_hold_index );
4979:
4980: IF l_result THEN
4981: IF l_debug_level > 0 THEN
4982: oe_debug_pub.add( 'HEADER LEVEL HOLD EXISTS' ) ;
4983: END IF;
4984: RETURN l_result;
4985: END IF;
4986:

Line 4996: oe_debug_pub.add( 'Line is part of ATO model and one of the lines

4992: IF G_Line_Holds_Tbl.EXISTS(p_ato_line_index) THEN
4993: IF G_Line_Holds_Tbl(p_ato_line_index).Any_ato_line_on_hold = 'Y' THEN
4994:
4995: IF l_debug_level > 0 THEN
4996: oe_debug_pub.add( 'Line is part of ATO model and one of the lines
4997: is on Generic Hold') ;
4998: END IF;
4999: RETURN TRUE;
5000: END IF;

Line 5014: oe_debug_pub.add( 'Line is part of SMC model and one of the lines

5010: IF G_Line_Holds_Tbl(p_top_model_line_index).Any_SMC_Line_on_hold = 'Y'
5011: THEN
5012:
5013: IF l_debug_level > 0 THEN
5014: oe_debug_pub.add( 'Line is part of SMC model and one of the lines
5015: is on Generic Hold') ;
5016: END IF;
5017: RETURN TRUE;
5018: END IF;

Line 5032: oe_debug_pub.add( 'II Parent line is on Generic Hold') ;

5028: IF G_Line_Holds_Tbl(p_ii_parent_line_index).On_Generic_Hold = 'Y' AND
5029: G_Line_Holds_Tbl(p_ii_parent_line_index).hold_ii_flag = 'Y'
5030: THEN
5031: IF l_debug_level > 0 THEN
5032: oe_debug_pub.add( 'II Parent line is on Generic Hold') ;
5033: END IF;
5034: RETURN TRUE;
5035: END IF;
5036: END IF;

Line 5039: oe_debug_pub.add( 'Exiting OE_BULK_HOLDS_PVT.Check_For_Holds');

5035: END IF;
5036: END IF;
5037: END IF;
5038: IF l_debug_level > 0 THEN
5039: oe_debug_pub.add( 'Exiting OE_BULK_HOLDS_PVT.Check_For_Holds');
5040: END IF;
5041: RETURN FALSE;
5042:
5043: EXCEPTION

Line 5046: oe_debug_pub.add( 'In others of OE_BULK_HOLDS_PVT.Check_For_Holds');

5042:
5043: EXCEPTION
5044: WHEN OTHERS THEN
5045: IF l_debug_level > 0 THEN
5046: oe_debug_pub.add( 'In others of OE_BULK_HOLDS_PVT.Check_For_Holds');
5047: END IF;
5048: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5049: THEN
5050: OE_MSG_PUB.Add_Exc_Msg