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

Line 517: l_curr_rate := INV_TRANSACTION_FLOW_PUB.convert_currency (

513: THEN
514: print_debug(': Now doing currency conversion from Currency: ' ||
515: l_parentorg_currency || ' to functional currency, if necessary');
516:
517: l_curr_rate := INV_TRANSACTION_FLOW_PUB.convert_currency (
518: p_org_id => l_logicalorg_ou_id
519: , p_transfer_price => 1
520: , p_currency_code => l_parentorg_currency
521: , p_transaction_date => l_transaction_date

Line 531: print_debug('INV_TRANSACTION_FLOW_PUB.convert_currency returns error', 9);

527:
528:
529: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
530: IF (l_debug = 1) THEN
531: print_debug('INV_TRANSACTION_FLOW_PUB.convert_currency returns error', 9);
532: print_debug('l_msg_data = ' || l_msg_data, 9);
533: END IF;
534: x_return_status := l_return_status;
535: x_msg_data := l_msg_data;

Line 759: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

755: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LOGICAL_TRX_WRAPPER';
756: l_init_msg_lst VARCHAR2(1) := NVL(p_init_msg_lst, G_FALSE);
757: l_progress NUMBER;
758: l_mtl_trx_tbl INV_LOGICAL_TRANSACTION_GLOBAL.mtl_trx_tbl_type;
759: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
760: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
761: l_selling_OU NUMBER;
762: l_shipping_OU NUMBER;
763: l_ship_from_org_id NUMBER;

Line 760: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

756: l_init_msg_lst VARCHAR2(1) := NVL(p_init_msg_lst, G_FALSE);
757: l_progress NUMBER;
758: l_mtl_trx_tbl INV_LOGICAL_TRANSACTION_GLOBAL.mtl_trx_tbl_type;
759: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
760: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
761: l_selling_OU NUMBER;
762: l_shipping_OU NUMBER;
763: l_ship_from_org_id NUMBER;
764: l_return_status VARCHAR2(1);

Line 770: l_transaction_flow_exists VARCHAR2(1) := INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_NOT_FOUND;

766: l_msg_data VARCHAR2(2000);
767: l_header_id NUMBER;
768: l_transaction_date DATE;
769: l_new_accounting_flag VARCHAR2(1) := 'N';
770: l_transaction_flow_exists VARCHAR2(1) := INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_NOT_FOUND;
771: l_organization_id NUMBER;
772: l_item_id NUMBER;
773: l_transaction_source_type_id NUMBER;
774: l_transaction_action_id NUMBER;

Line 935: print_debug('Calling INV_TRANSACTION_FLOW_PUB.check_transaction_flow', 9);

931: END IF;
932: END;
933:
934: IF (l_debug = 1) THEN
935: print_debug('Calling INV_TRANSACTION_FLOW_PUB.check_transaction_flow', 9);
936: print_debug('l_shipping_OU = ' || l_shipping_OU, 9);
937: print_debug('l_selling_OU = ' || l_selling_OU, 9);
938: print_debug('flow_type = ' || G_SHIPPING, 9);
939: print_debug('organization_id = ' || l_ship_from_org_id, 9);

Line 949: INV_TRANSACTION_FLOW_PUB.check_transaction_flow(

945: print_debug('l_qualifier_value_tbl(1) = ' || l_qualifier_value_tbl(1), 9);
946: END IF;
947: END IF;
948:
949: INV_TRANSACTION_FLOW_PUB.check_transaction_flow(
950: p_api_version => 1.0
951: , p_init_msg_list => fnd_api.g_false
952: , p_start_operating_unit => l_shipping_OU
953: , p_end_operating_unit => l_selling_OU

Line 1026: l_transaction_flow_exists := INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND;

1022: print_debug('This is logical PO receipt', 9);
1023: END IF;
1024:
1025: l_logical_trx_type_code := G_LOGTRXCODE_DSDELIVER;
1026: l_transaction_flow_exists := INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND;
1027: l_new_accounting_flag := 'Y';
1028: l_defer_logical_trx := G_NOT_DEFER_LOGICAL_TRX;
1029: END IF; -- end of transaction source type is sales order issue/RMA
1030:

Line 1031: IF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND

1027: l_new_accounting_flag := 'Y';
1028: l_defer_logical_trx := G_NOT_DEFER_LOGICAL_TRX;
1029: END IF; -- end of transaction source type is sales order issue/RMA
1030:
1031: IF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND
1032: AND l_new_accounting_flag = 'Y') THEN
1033: l_progress := 60;
1034: BEGIN
1035:

Line 1252: ELSIF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND

1248: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1249: FND_MSG_PUB.ADD;
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252: ELSIF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND
1253: AND l_new_accounting_flag = 'N') THEN
1254: IF (l_debug = 1) THEN
1255: print_debug('updating MMT record trx_id ' || p_transaction_id ||
1256: ' with trx_flow_header_id = ' || l_header_id, 9);

Line 1430: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

1426: l_shipping_OU NUMBER;
1427: l_ship_from_org_id NUMBER;
1428: l_new_accounting_flag VARCHAR2(1) := 'N';
1429: l_index NUMBER;
1430: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1431: l_transfer_price_tbl mtl_transfer_price_tbl_type;
1432: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1433: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1434: l_trx_id NUMBER;

Line 1432: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

1428: l_new_accounting_flag VARCHAR2(1) := 'N';
1429: l_index NUMBER;
1430: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1431: l_transfer_price_tbl mtl_transfer_price_tbl_type;
1432: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1433: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1434: l_trx_id NUMBER;
1435: l_is_return NUMBER := 0; -- values: 0 - No, 1 - Yes
1436: l_dsreceive BOOLEAN;

Line 1433: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

1429: l_index NUMBER;
1430: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1431: l_transfer_price_tbl mtl_transfer_price_tbl_type;
1432: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1433: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1434: l_trx_id NUMBER;
1435: l_is_return NUMBER := 0; -- values: 0 - No, 1 - Yes
1436: l_dsreceive BOOLEAN;
1437: l_drop_ship_flag VARCHAR2(1) := 'N';

Line 2191: print_debug('Calling INV_TRANSACTION_FLOW_PUB.get_transaction_flow', 9);

2187: -- and shipping_ou<>selling_ou) or SO issue/RMA return
2188: l_progress := 310;
2189: IF (l_debug = 1) THEN
2190: print_debug('Drop shipment deliver across multiple OUS or SO issue/RMA', 9);
2191: print_debug('Calling INV_TRANSACTION_FLOW_PUB.get_transaction_flow', 9);
2192: END IF;
2193:
2194: l_progress := 320;
2195:

Line 2196: INV_TRANSACTION_FLOW_PUB.get_transaction_flow(

2192: END IF;
2193:
2194: l_progress := 320;
2195:
2196: INV_TRANSACTION_FLOW_PUB.get_transaction_flow(
2197: x_return_status => l_return_status
2198: , x_msg_data => l_msg_data
2199: , x_msg_count => l_msg_count
2200: , x_transaction_flows_tbl => l_trx_flow_tbl

Line 2242: print_debug('Calling INV_TRANSACTION_FLOW_PUB.get_transfer_price', 9);

2238:
2239: l_trx_flow_tbl(1).from_organization_id := l_mtl_trx_tbl(1).organization_id;
2240:
2241: IF (l_debug = 1) THEN
2242: print_debug('Calling INV_TRANSACTION_FLOW_PUB.get_transfer_price', 9);
2243: END IF;
2244:
2245: -- start construct transfer price pl/sql table
2246: FOR i in 1..l_trx_flow_tbl.COUNT LOOP

Line 2261: INV_TRANSACTION_FLOW_PUB.get_transfer_price(

2257:
2258: l_transfer_price_tbl(i).from_org_id := l_trx_flow_tbl(i).from_org_id;
2259: l_transfer_price_tbl(i).to_org_id := l_trx_flow_tbl(i).to_org_id;
2260: l_progress := 330;
2261: INV_TRANSACTION_FLOW_PUB.get_transfer_price(
2262: x_return_status => l_return_status
2263: , x_msg_data => l_msg_data
2264: , x_msg_count => l_msg_count
2265: , x_transfer_price => l_transfer_price_tbl(i).transfer_price

Line 2451: print_debug('Calling INV_TRANSACTION_FLOW_PUB.convert_currency, input params:', 9);

2447: l_mtl_trx_tbl(l_index).distribution_account_id := l_trx_flow_tbl(i).EXPENSE_ACCRUAL_ACCOUNT_ID;
2448: END IF;
2449:
2450: IF (l_debug = 1) THEN
2451: print_debug('Calling INV_TRANSACTION_FLOW_PUB.convert_currency, input params:', 9);
2452: print_debug('1. p_org_id = ' || l_transfer_price_tbl(i).to_org_id, 9);
2453: print_debug('2. p_transfer_price = ' || l_mtl_trx_tbl(l_index-1).intercompany_cost, 9);
2454: print_debug('3. p_currency_code = ' || l_mtl_trx_tbl(l_index-1).currency_code, 9);
2455: END IF;

Line 2502: l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(

2498:
2499: print_debug('l_uom_rate: '||l_uom_rate, 9);
2500:
2501: l_progress := 360;
2502: l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(
2503: p_org_id => l_transfer_price_tbl(i).to_org_id
2504: , p_transfer_price => l_transfer_price_tbl(i).transfer_price
2505: , p_currency_code => l_mtl_trx_tbl(l_index-1).currency_code
2506: , p_transaction_date => l_mtl_trx_tbl(l_index).transaction_date

Line 2689: l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(

2685:
2686: print_debug('l_uom_rate: '||l_uom_rate, 9);
2687:
2688: l_progress := 380;
2689: l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(
2690: p_org_id => l_transfer_price_tbl(i).to_org_id
2691: , p_transfer_price => l_transfer_price_tbl(i).transfer_price
2692: , p_currency_code => l_mtl_trx_tbl(l_index-1).currency_code
2693: , p_transaction_date => l_mtl_trx_tbl(l_index).transaction_date

Line 4754: l_curr_conversion_rate := INV_TRANSACTION_FLOW_PUB.convert_currency(

4750: print_debug(l_procedure_name || ': SOBs are different. currSOB/ownerSOB: ' ||
4751: l_sob_id ||'/'|| l_owner_sob_id || '. ownerOUId: ' || l_owner_ou_id);
4752: END IF;
4753:
4754: l_curr_conversion_rate := INV_TRANSACTION_FLOW_PUB.convert_currency(
4755: p_org_id => l_owner_ou_id
4756: , p_transfer_price => 1
4757: , p_currency_code => l_currency_code
4758: , p_transaction_date => l_transaction_date

Line 4772: print_debug(l_procedure_name || ': Error from INV_TRANSACTION_FLOW_PUB.convert_currency: ' ||

4768: END IF;
4769:
4770: IF ( x_return_status <> G_RET_STS_SUCCESS )
4771: THEN
4772: print_debug(l_procedure_name || ': Error from INV_TRANSACTION_FLOW_PUB.convert_currency: ' ||
4773: x_msg_data, 9);
4774: IF x_return_status = FND_API.G_RET_STS_ERROR
4775: THEN
4776: RAISE FND_API.G_EXC_ERROR;