DBA Data[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 3562: l_conversion_type := fnd_profile.value('IC_CURRENCY_CONVERSION_TYPE');

3558: l_fixed_rate := gl_currency_api.is_fixed_rate(
3559: p_currency_code, l_functional_currency_code, p_transaction_date);
3560:
3561: print_debug('l_fixed_rate is ' || l_fixed_rate, 'convert_currency');
3562: l_conversion_type := fnd_profile.value('IC_CURRENCY_CONVERSION_TYPE');
3563: if( l_fixed_rate = 'Y' ) then
3564: l_conversion_type := 'EMU FIXED';
3565: end if;
3566:

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

3706: l_invoice_currency_code VARCHAR2(30);
3707: l_return_Status VARCHAR2(1);
3708: l_msg_data VARCHAR2(255);
3709: l_msg_count NUMBER;
3710: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3711: l_transfer_price NUMBER := 0;
3712: l_qp_profile NUMBER := nvl(fnd_profile.value('INV_USE_QP_FOR_INTERCOMPANY'), 2);
3713: l_transfer_price_code NUMBER := -1;
3714: l_organization_id NUMBER;

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

3708: l_msg_data VARCHAR2(255);
3709: l_msg_count NUMBER;
3710: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3711: l_transfer_price NUMBER := 0;
3712: l_qp_profile NUMBER := nvl(fnd_profile.value('INV_USE_QP_FOR_INTERCOMPANY'), 2);
3713: l_transfer_price_code NUMBER := -1;
3714: l_organization_id NUMBER;
3715: l_functional_currency_code VARCHAR2(30);
3716: l_uom_rate NUMBER;

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

4377: l_transfer_price NUMBER := 0;
4378: l_currency_code VARCHAR2(30);
4379: l_inventory_item_id NUMBER;
4380: l_functional_currency_code VARCHAR2(30);
4381: l_debug NUMBER := nvl(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
4382: l_return_status VARCHAR2(1);
4383: l_msg_data VARCHAR2(255);
4384: l_msg_count NUMBER;
4385: l_transaction_date DATE;