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 533: l_curr_rate := INV_TRANSACTION_FLOW_PUB.convert_currency (

529: THEN
530: print_debug(': Now doing currency conversion from Currency: ' ||
531: l_parentorg_currency || ' to functional currency, if necessary');
532:
533: l_curr_rate := INV_TRANSACTION_FLOW_PUB.convert_currency (
534: p_org_id => l_logicalorg_ou_id
535: , p_transfer_price => 1
536: , p_currency_code => l_parentorg_currency
537: , p_transaction_date => l_transaction_date

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

543:
544:
545: IF (l_return_status <> G_RET_STS_SUCCESS) THEN
546: IF (l_debug = 1) THEN
547: print_debug('INV_TRANSACTION_FLOW_PUB.convert_currency returns error', 9);
548: print_debug('l_msg_data = ' || l_msg_data, 9);
549: END IF;
550: x_return_status := l_return_status;
551: x_msg_data := l_msg_data;

Line 775: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

771: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LOGICAL_TRX_WRAPPER';
772: l_init_msg_lst VARCHAR2(1) := NVL(p_init_msg_lst, G_FALSE);
773: l_progress NUMBER;
774: l_mtl_trx_tbl INV_LOGICAL_TRANSACTION_GLOBAL.mtl_trx_tbl_type;
775: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
776: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
777: l_selling_OU NUMBER;
778: l_shipping_OU NUMBER;
779: l_ship_from_org_id NUMBER;

Line 776: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

772: l_init_msg_lst VARCHAR2(1) := NVL(p_init_msg_lst, G_FALSE);
773: l_progress NUMBER;
774: l_mtl_trx_tbl INV_LOGICAL_TRANSACTION_GLOBAL.mtl_trx_tbl_type;
775: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
776: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
777: l_selling_OU NUMBER;
778: l_shipping_OU NUMBER;
779: l_ship_from_org_id NUMBER;
780: l_return_status VARCHAR2(1);

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

782: l_msg_data VARCHAR2(2000);
783: l_header_id NUMBER;
784: l_transaction_date DATE;
785: l_new_accounting_flag VARCHAR2(1) := 'N';
786: l_transaction_flow_exists VARCHAR2(1) := INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_NOT_FOUND;
787: l_organization_id NUMBER;
788: l_item_id NUMBER;
789: l_transaction_source_type_id NUMBER;
790: l_transaction_action_id NUMBER;

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

947: END IF;
948: END;
949:
950: IF (l_debug = 1) THEN
951: print_debug('Calling INV_TRANSACTION_FLOW_PUB.check_transaction_flow', 9);
952: print_debug('l_shipping_OU = ' || l_shipping_OU, 9);
953: print_debug('l_selling_OU = ' || l_selling_OU, 9);
954: print_debug('flow_type = ' || G_SHIPPING, 9);
955: print_debug('organization_id = ' || l_ship_from_org_id, 9);

Line 965: INV_TRANSACTION_FLOW_PUB.check_transaction_flow(

961: print_debug('l_qualifier_value_tbl(1) = ' || l_qualifier_value_tbl(1), 9);
962: END IF;
963: END IF;
964:
965: INV_TRANSACTION_FLOW_PUB.check_transaction_flow(
966: p_api_version => 1.0
967: , p_init_msg_list => fnd_api.g_false
968: , p_start_operating_unit => l_shipping_OU
969: , p_end_operating_unit => l_selling_OU

Line 1042: l_transaction_flow_exists := INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND;

1038: print_debug('This is logical PO receipt', 9);
1039: END IF;
1040:
1041: l_logical_trx_type_code := G_LOGTRXCODE_DSDELIVER;
1042: l_transaction_flow_exists := INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND;
1043: l_new_accounting_flag := 'Y';
1044: l_defer_logical_trx := G_NOT_DEFER_LOGICAL_TRX;
1045: END IF; -- end of transaction source type is sales order issue/RMA
1046:

Line 1047: IF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND

1043: l_new_accounting_flag := 'Y';
1044: l_defer_logical_trx := G_NOT_DEFER_LOGICAL_TRX;
1045: END IF; -- end of transaction source type is sales order issue/RMA
1046:
1047: IF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND
1048: AND l_new_accounting_flag = 'Y') THEN
1049: l_progress := 60;
1050: BEGIN
1051:

Line 1268: ELSIF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND

1264: FND_MESSAGE.SET_NAME('INV', 'INV_MMT_NOT_FOUND');
1265: FND_MSG_PUB.ADD;
1266: RAISE FND_API.G_EXC_ERROR;
1267: END IF;
1268: ELSIF (l_transaction_flow_exists = INV_TRANSACTION_FLOW_PUB.G_TRANSACTION_FLOW_FOUND
1269: AND l_new_accounting_flag = 'N') THEN
1270: IF (l_debug = 1) THEN
1271: print_debug('updating MMT record trx_id ' || p_transaction_id ||
1272: ' with trx_flow_header_id = ' || l_header_id, 9);

Line 1445: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

1441: l_shipping_OU NUMBER;
1442: l_ship_from_org_id NUMBER;
1443: l_new_accounting_flag VARCHAR2(1) := 'N';
1444: l_index NUMBER;
1445: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1446: l_transfer_price_tbl mtl_transfer_price_tbl_type;
1447: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1448: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1449: l_trx_id NUMBER;

Line 1447: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

1443: l_new_accounting_flag VARCHAR2(1) := 'N';
1444: l_index NUMBER;
1445: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1446: l_transfer_price_tbl mtl_transfer_price_tbl_type;
1447: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1448: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1449: l_trx_id NUMBER;
1450: l_is_return NUMBER := 0; -- values: 0 - No, 1 - Yes
1451: l_dsreceive BOOLEAN;

Line 1448: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;

1444: l_index NUMBER;
1445: l_trx_flow_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1446: l_transfer_price_tbl mtl_transfer_price_tbl_type;
1447: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1448: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.number_tbl;
1449: l_trx_id NUMBER;
1450: l_is_return NUMBER := 0; -- values: 0 - No, 1 - Yes
1451: l_dsreceive BOOLEAN;
1452: l_drop_ship_flag VARCHAR2(1) := 'N';

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

2204: -- and shipping_ou<>selling_ou) or SO issue/RMA return
2205: l_progress := 310;
2206: IF (l_debug = 1) THEN
2207: print_debug('Drop shipment deliver across multiple OUS or SO issue/RMA', 9);
2208: print_debug('Calling INV_TRANSACTION_FLOW_PUB.get_transaction_flow', 9);
2209: END IF;
2210:
2211: l_progress := 320;
2212:

Line 2213: INV_TRANSACTION_FLOW_PUB.get_transaction_flow(

2209: END IF;
2210:
2211: l_progress := 320;
2212:
2213: INV_TRANSACTION_FLOW_PUB.get_transaction_flow(
2214: x_return_status => l_return_status
2215: , x_msg_data => l_msg_data
2216: , x_msg_count => l_msg_count
2217: , x_transaction_flows_tbl => l_trx_flow_tbl

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

2255:
2256: l_trx_flow_tbl(1).from_organization_id := l_mtl_trx_tbl(1).organization_id;
2257:
2258: IF (l_debug = 1) THEN
2259: print_debug('Calling INV_TRANSACTION_FLOW_PUB.get_transfer_price', 9);
2260: END IF;
2261:
2262: -- start construct transfer price pl/sql table
2263: FOR i in 1..l_trx_flow_tbl.COUNT LOOP

Line 2278: INV_TRANSACTION_FLOW_PUB.get_transfer_price(

2274:
2275: l_transfer_price_tbl(i).from_org_id := l_trx_flow_tbl(i).from_org_id;
2276: l_transfer_price_tbl(i).to_org_id := l_trx_flow_tbl(i).to_org_id;
2277: l_progress := 330;
2278: INV_TRANSACTION_FLOW_PUB.get_transfer_price(
2279: x_return_status => l_return_status
2280: , x_msg_data => l_msg_data
2281: , x_msg_count => l_msg_count
2282: , x_transfer_price => l_transfer_price_tbl(i).transfer_price

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

2464: l_mtl_trx_tbl(l_index).distribution_account_id := l_trx_flow_tbl(i).EXPENSE_ACCRUAL_ACCOUNT_ID;
2465: END IF;
2466:
2467: IF (l_debug = 1) THEN
2468: print_debug('Calling INV_TRANSACTION_FLOW_PUB.convert_currency, input params:', 9);
2469: print_debug('1. p_org_id = ' || l_transfer_price_tbl(i).to_org_id, 9);
2470: print_debug('2. p_transfer_price = ' || l_mtl_trx_tbl(l_index-1).intercompany_cost, 9);
2471: print_debug('3. p_currency_code = ' || l_mtl_trx_tbl(l_index-1).currency_code, 9);
2472: END IF;

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

2515:
2516: print_debug('l_uom_rate: '||l_uom_rate, 9);
2517: l_progress := 360;
2518: /* Modified the Transaction_cost calculation using intercompany transfer price and currency code for bug 12693744 */
2519: /* l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(
2520: p_org_id => l_transfer_price_tbl(i).to_org_id
2521: , p_transfer_price => l_transfer_price_tbl(i).transfer_price
2522: , p_currency_code => l_mtl_trx_tbl(l_index-1).currency_code
2523: , p_transaction_date => l_mtl_trx_tbl(l_index).transaction_date

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

2526: , x_return_status => l_return_status
2527: , x_msg_data => l_msg_data
2528: , x_msg_count => l_msg_count);*/
2529:
2530: l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(
2531: p_org_id => l_transfer_price_tbl(i).to_org_id
2532: , p_transfer_price => l_transfer_price_tbl(i).incr_transfer_price
2533: , p_currency_code => l_transfer_price_tbl(i).incr_currency_code
2534: , p_transaction_date => l_mtl_trx_tbl(l_index).transaction_date

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

2716: print_debug('l_uom_rate: '||l_uom_rate, 9);
2717:
2718: l_progress := 380;
2719: /* Modified the Transaction_cost calculation using intercompany transfer price and currency code for bug 12693744 */
2720: /* l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(
2721: p_org_id => l_transfer_price_tbl(i).to_org_id
2722: , p_transfer_price => l_transfer_price_tbl(i).transfer_price
2723: , p_currency_code => l_mtl_trx_tbl(l_index-1).currency_code
2724: , p_transaction_date => l_mtl_trx_tbl(l_index).transaction_date

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

2727: , x_return_status => l_return_status
2728: , x_msg_data => l_msg_data
2729: , x_msg_count => l_msg_count); */
2730:
2731: l_mtl_trx_tbl(l_index).transaction_cost := l_uom_rate * INV_TRANSACTION_FLOW_PUB.convert_currency(
2732: p_org_id => l_transfer_price_tbl(i).to_org_id
2733: , p_transfer_price => l_transfer_price_tbl(i).incr_transfer_price
2734: , p_currency_code => l_transfer_price_tbl(i).incr_currency_code
2735: , p_transaction_date => l_mtl_trx_tbl(l_index).transaction_date

Line 4841: l_curr_conversion_rate := INV_TRANSACTION_FLOW_PUB.convert_currency(

4837: print_debug(l_procedure_name || ': SOBs are different. currSOB/ownerSOB: ' ||
4838: l_sob_id ||'/'|| l_owner_sob_id || '. ownerOUId: ' || l_owner_ou_id);
4839: END IF;
4840:
4841: l_curr_conversion_rate := INV_TRANSACTION_FLOW_PUB.convert_currency(
4842: p_org_id => l_owner_ou_id
4843: , p_transfer_price => 1
4844: , p_currency_code => l_currency_code
4845: , p_transaction_date => l_transaction_date

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

4856: END IF;
4857:
4858: IF ( x_return_status <> G_RET_STS_SUCCESS )
4859: THEN
4860: print_debug(l_procedure_name || ': Error from INV_TRANSACTION_FLOW_PUB.convert_currency: ' ||
4861: x_msg_data, 9);
4862: IF x_return_status = FND_API.G_RET_STS_ERROR
4863: THEN
4864: RAISE FND_API.G_EXC_ERROR;