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.INV_TRANSACTION_FLOW_PUB dependencies on FND_PROFILE

Line 14: g_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10: G_INV_CURR_CODE VARCHAR2(31);
11: G_FROM_ORG_ID NUMBER := -1;
12: G_TO_ORG_ID NUMBER := -1;
13: G_FLOW_TYPE NUMBER := -1;
14: g_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
15: g_version_printed BOOLEAN := FALSE;
16:
17: G_PKG_NAME CONSTANT VARCHAR2(50) := 'INV_TRANSACTION_FLOW_PUB';
18:

Line 153: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

149: and icp.sell_organization_id=t_line.to_org_id
150: and icp.flow_type = l_flow_type
151: ORDER BY t_line.line_number;
152:
153: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
154: l_transaction_flows_tbl g_transaction_flow_tbl_type;
155: rcount NUMBER := 0;
156: l_match BOOLEAN;
157: l_found BOOLEAN;

Line 502: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

498: AND icp.flow_type = t_hdr.flow_type
499: ORDER BY t_line.line_number;
500:
501:
502: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
503: l_transaction_flows_tbl g_transaction_flow_tbl_type;
504: rcount NUMBER := 0;
505: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRANSACTION_FLOW';
506: l_api_version_number CONSTANT NUMBER := 1.0;

Line 710: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

706: ORDER BY
707: t_hdr.organization_id, t_hdr.qualifier_code;
708:
709: l_match BOOLEAN;
710: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
711: l_api_version_number CONSTANT NUMBER := 1.0;
712: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_TRANSACTION_FLOW';
713: l_from_ou_name VARCHAR2(240);
714: l_to_ou_name VARCHAR2(240);

Line 1620: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1616: l_return_status VARCHAR2(1) := NULL;
1617: l_msg_data VARCHAR2(2000):= NULL;
1618: l_msg_count NUMBER := NULL;
1619: l_lines_tab INV_TRANSACTION_FLOW_PVT.trx_flow_lines_tab;
1620: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1621: l_api_version_number CONSTANT NUMBER := 1.0;
1622: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRANSACTION_FLOW_HEADER';
1623: BEGIN
1624:

Line 1754: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1750:
1751: l_return_status VARCHAR2(1) := NULL;
1752: l_msg_data VARCHAR2(2000):= NULL;
1753: l_msg_count NUMBER := NULL;
1754: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1755: l_api_version_number CONSTANT NUMBER := 1.0;
1756: l_api_name CONSTANT VARCHAR2(30) := 'Update_Transaction_flow_line';
1757: BEGIN
1758:

Line 2864: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2860: , x_dropship_type_Code OUT NOCOPY NUMBER
2861: , x_header_id OUT NOCOPY NUMBER
2862: ) IS
2863:
2864: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2865: l_inventory_item_id NUMBER;
2866: l_po_header_id NUMBER := NULL;
2867: l_po_line_id NUMBER := NULL;
2868: l_po_line_location_id NUMBER := NULL;

Line 3575: l_conversion_type := fnd_profile.value('IC_CURRENCY_CONVERSION_TYPE');

3571: l_fixed_rate := gl_currency_api.is_fixed_rate(
3572: p_currency_code, l_functional_currency_code, p_transaction_date);
3573:
3574: print_debug('l_fixed_rate is ' || l_fixed_rate, 'convert_currency');
3575: l_conversion_type := fnd_profile.value('IC_CURRENCY_CONVERSION_TYPE');
3576: if( l_fixed_rate = 'Y' ) then
3577: l_conversion_type := 'EMU FIXED';
3578: end if;
3579:

Line 3751: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

3747: l_invoice_currency_code VARCHAR2(30);
3748: l_return_Status VARCHAR2(1);
3749: l_msg_data VARCHAR2(255);
3750: l_msg_count NUMBER;
3751: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3752: l_transfer_price NUMBER := 0;
3753: l_qp_profile NUMBER := nvl(fnd_profile.value('INV_USE_QP_FOR_INTERCOMPANY'), 2);
3754: l_transfer_price_code NUMBER := -1;
3755: l_organization_id NUMBER;

Line 3753: l_qp_profile NUMBER := nvl(fnd_profile.value('INV_USE_QP_FOR_INTERCOMPANY'), 2);

3749: l_msg_data VARCHAR2(255);
3750: l_msg_count NUMBER;
3751: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3752: l_transfer_price NUMBER := 0;
3753: l_qp_profile NUMBER := nvl(fnd_profile.value('INV_USE_QP_FOR_INTERCOMPANY'), 2);
3754: l_transfer_price_code NUMBER := -1;
3755: l_organization_id NUMBER;
3756: l_functional_currency_code VARCHAR2(30);
3757: l_uom_rate NUMBER;

Line 4486: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

4482: l_transfer_price NUMBER := 0;
4483: l_currency_code VARCHAR2(30);
4484: l_inventory_item_id NUMBER;
4485: l_functional_currency_code VARCHAR2(30);
4486: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
4487: l_return_status VARCHAR2(1);
4488: l_msg_data VARCHAR2(255);
4489: l_msg_count NUMBER;
4490: l_transaction_date DATE;

Line 4965: l_trf_date_profile NUMBER:= nvl(fnd_profile.value('INV_INTERCOMPANY_TRANSFER_PRICE_DATE'), 1);

4961: , x_msg_data OUT NOCOPY VARCHAR2
4962: , x_msg_count OUT NOCOPY NUMBER
4963: ) RETURN DATE
4964: IS
4965: l_trf_date_profile NUMBER:= nvl(fnd_profile.value('INV_INTERCOMPANY_TRANSFER_PRICE_DATE'), 1);
4966: l_trf_price_date DATE;
4967: l_doc_type VARCHAR2(4);
4968: l_whse_code VARCHAR2(4);
4969: l_line_id NUMBER;