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_OE_AVAILABILITY dependencies on OE_OE_AVAILABILITY

Line 1: PACKAGE BODY oe_oe_availability AS

1: PACKAGE BODY oe_oe_availability AS
2: /* $Header: OEXFAVAB.pls 120.0.12010000.2 2008/08/04 14:59:27 amallik ship $ */
3:
4: --Global variables
5:

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

2: /* $Header: OEXFAVAB.pls 120.0.12010000.2 2008/08/04 14:59:27 amallik ship $ */
3:
4: --Global variables
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_oe_availability';
7: G_ATP_TBL OE_ATP.atp_tbl_type;
8: G_line_id CONSTANT NUMBER :=1234;
9: G_atp_line_id CONSTANT NUMBER := -9987;
10: g_header_id CONSTANT NUMBER :=2345;

Line 1360: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_HEADER_TO_REQUEST' ) ;

1356:
1357: --Temp Table population done
1358:
1359: IF l_debug_level > 0 THEN
1360: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_HEADER_TO_REQUEST' ) ;
1361: END IF;
1362:
1363: END copy_Header_to_request;
1364:

Line 1514: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_LINE_TO_REQUEST' , 1 ) ;

1510: G_LINE_CATEGORY_TBL(l_line_index) := NULL;
1511:
1512:
1513: IF l_debug_level > 0 THEN
1514: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_LINE_TO_REQUEST' , 1 ) ;
1515: END IF;
1516:
1517: END copy_Line_to_request;
1518:

Line 1786: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;

1782: --
1783: BEGIN
1784:
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
1787: END IF;
1788:
1789: IF g_panda_rec_table(p_g_line_index).p_pricing_attribute1 is not null then
1790: i := px_Req_line_attr_tbl.count+1;

Line 2695: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;

2691: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_panda_rec_table(p_g_line_index).p_pricing_attribute100;
2692: end if;
2693:
2694: IF l_debug_level > 0 THEN
2695: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
2696: END IF;
2697:
2698: END Append_attributes;
2699:

Line 3718: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;

3714: --
3715: BEGIN
3716:
3717: IF l_debug_level > 0 THEN
3718: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3719: END IF;
3720: i := p_pricing_contexts_Tbl.First;
3721: While i is not null loop
3722: l_attr_index := l_attr_index +1;

Line 3769: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;

3765: i := p_qualifier_contexts_Tbl.Next(i);
3766: end loop;
3767:
3768: IF l_debug_level > 0 THEN
3769: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3770: END IF;
3771:
3772: END copy_attribs_to_Req;
3773:

Line 4525: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.GET_ITEM_INFO'||

4521: --
4522: BEGIN
4523:
4524: IF l_debug_level > 0 THEN
4525: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4526: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID ) ;
4527: END IF;
4528:
4529: OPEN c_item_info;

Line 4570: oe_oe_availability.get_Ship_From_Org

4566: out_make_or_buy := 'Buy';
4567: END IF;
4568:
4569:
4570: oe_oe_availability.get_Ship_From_Org
4571: ( in_org_id => in_org_id
4572: , out_code=>out_wsh
4573: , out_name =>out_wsh_name
4574: );

Line 4601: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.GET_ITEM_INFO'||

4597: out_user_item_type := null;
4598:
4599: END IF;
4600: IF l_debug_level > 0 THEN
4601: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4602: ' ITEM_STATUS ='||OUT_ITEM_STATUS ) ;
4603: END IF;
4604:
4605: EXCEPTION

Line 4613: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.GET_ITEM_INFO '||

4609: CLOSE c_item_info;
4610: END IF;
4611:
4612: IF l_debug_level > 0 THEN
4613: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.GET_ITEM_INFO '||
4614: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID||
4615: 'SQLCODE='||SQLCODE|| 'SQLERRM='||SQLERRM ) ;
4616: END IF;
4617:

Line 5494: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;

5490:
5491: EXCEPTION
5492: WHEN NO_DATA_FOUND THEN
5493: IF l_debug_level > 0 THEN
5494: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5495: END IF;
5496: WHEN OTHERS THEN
5497: IF l_debug_level > 0 THEN
5498: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

Line 5498: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

5494: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5495: END IF;
5496: WHEN OTHERS THEN
5497: IF l_debug_level > 0 THEN
5498: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;
5499: END IF;
5500:
5501: END set_mrp_debug;
5502:

Line 5751: END oe_oe_availability;

5747:
5748: END copy_fields_to_globals;
5749:
5750:
5751: END oe_oe_availability;