[Home] [Help]
1: PACKAGE BODY om_tax_util AS
2: /* $Header: OEXUTAXB.pls 120.32 2011/05/31 10:58:42 jmedaven ship $ */
3: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT;
4: G_DEBUG_BYPASS_TAX CONSTANT VARCHAR2(1):=nvl(Fnd_Profile.value('OE_DBG_BYPASS'),'N');
5: -- structure for caching loc_ship_bill_info
112:
113:
114: PROCEDURE TAX_LINE(
115: p_entity_id_tbl IN OE_Delayed_Requests_PVT.Entity_Id_Tbl_Type,
116: x_tax_out_tbl OUT NOCOPY OM_TAX_UTIL.om_tax_out_tab_type,
117: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
118: AS
119: TYPE ship_bill_records
120: IS
2049:
2050: x_return_status := FND_API.G_RET_STS_SUCCESS;
2051: WHEN OTHERS THEN
2052: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2053: OE_MSG_PUB.Add_Exc_Msg ( 'OM_TAX_UTIL' , 'Tax_Line' );
2054: END IF;
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add('some error occurred ' || sqlerrm , 1);
2057: END IF;
2115: WHEN OTHERS THEN
2116: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2117: THEN
2118: OE_MSG_PUB.Add_Exc_Msg
2119: ( 'OM_TAX_UTIL' ,
2120: 'Calculate_Tax'
2121: );
2122: END IF;
2123:
2143: IF i IS NOT NULL
2144: AND zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID.exists(i)
2145: THEN
2146:
2147: oe_debug_pub.add('Entering OM_TAX_UTIL.Debug_msg procedure ');
2148: oe_debug_pub.add(' i = '||i);
2149: oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(i));
2150: oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(i));
2151: oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(i));
2418: oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(i));
2419: oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(i)= '||zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(i));
2420: oe_debug_pub.add(' zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(i)= '||
2421: zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(i),3);
2422: oe_debug_pub.add('Exiting OM_TAX_UTIL.Debug_msg procedure ');
2423: ELSE
2424: oe_debug_pub.add(' Index:'||i||' not avail for debug');
2425: END IF;
2426:
2621:
2622: EXCEPTION
2623: WHEN OTHERS THEN
2624: OE_MSG_PUB.Add_Exc_Msg
2625: ( 'OM_TAX_UTIL'
2626: , 'Get_Content_Owner_Id'
2627: );
2628: RETURN -99;
2629:
2629:
2630: END Get_Content_Owner_Id;
2631:
2632:
2633: END OM_TAX_UTIL;