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.

[Home] [Help]

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.3.12020000.2 2012/07/03 09:52:08 amallik ship $ */
3:
4: --Global variables
5:

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

2: /* $Header: OEXFAVAB.pls 120.3.12020000.2 2012/07/03 09:52:08 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 1363: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_HEADER_TO_REQUEST' ) ;

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

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

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

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

1787: --
1788: BEGIN
1789:
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
1792: END IF;
1793:
1794: IF g_panda_rec_table(p_g_line_index).p_pricing_attribute1 is not null then
1795: i := px_Req_line_attr_tbl.count+1;

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

2696: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_panda_rec_table(p_g_line_index).p_pricing_attribute100;
2697: end if;
2698:
2699: IF l_debug_level > 0 THEN
2700: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
2701: END IF;
2702:
2703: END Append_attributes;
2704:

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

3731: --
3732: BEGIN
3733:
3734: IF l_debug_level > 0 THEN
3735: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3736: END IF;
3737: i := p_pricing_contexts_Tbl.First;
3738: While i is not null loop
3739: l_attr_index := l_attr_index +1;

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

3782: i := p_qualifier_contexts_Tbl.Next(i);
3783: end loop;
3784:
3785: IF l_debug_level > 0 THEN
3786: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3787: END IF;
3788:
3789: END copy_attribs_to_Req;
3790:

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

4538: --
4539: BEGIN
4540:
4541: IF l_debug_level > 0 THEN
4542: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4543: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID ) ;
4544: END IF;
4545:
4546: OPEN c_item_info;

Line 4587: oe_oe_availability.get_Ship_From_Org

4583: out_make_or_buy := 'Buy';
4584: END IF;
4585:
4586:
4587: oe_oe_availability.get_Ship_From_Org
4588: ( in_org_id => in_org_id
4589: , out_code=>out_wsh
4590: , out_name =>out_wsh_name
4591: );

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

4614: out_user_item_type := null;
4615:
4616: END IF;
4617: IF l_debug_level > 0 THEN
4618: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4619: ' ITEM_STATUS ='||OUT_ITEM_STATUS ) ;
4620: END IF;
4621:
4622: EXCEPTION

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

4626: CLOSE c_item_info;
4627: END IF;
4628:
4629: IF l_debug_level > 0 THEN
4630: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.GET_ITEM_INFO '||
4631: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID||
4632: 'SQLCODE='||SQLCODE|| 'SQLERRM='||SQLERRM ) ;
4633: END IF;
4634:

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

5507:
5508: EXCEPTION
5509: WHEN NO_DATA_FOUND THEN
5510: IF l_debug_level > 0 THEN
5511: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5512: END IF;
5513: WHEN OTHERS THEN
5514: IF l_debug_level > 0 THEN
5515: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

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

5511: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5512: END IF;
5513: WHEN OTHERS THEN
5514: IF l_debug_level > 0 THEN
5515: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;
5516: END IF;
5517:
5518: END set_mrp_debug;
5519:

Line 5773: END oe_oe_availability;

5769:
5770: END copy_fields_to_globals;
5771:
5772:
5773: END oe_oe_availability;