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_RESERVATION_PVT dependencies on RSV_TEMP

Line 9653: insert_rsv_temp

9649: RAISE fnd_api.g_exc_unexpected_error;
9650: END IF;
9651: END IF;
9652:
9653: insert_rsv_temp
9654: (
9655: p_organization_id => l_rsv_rec.organization_id
9656: , p_inventory_item_id => l_rsv_rec.inventory_item_id
9657: , p_primary_reservation_quantity=> l_rsv_rec.primary_reservation_quantity

Line 9667: debug_print('After insert into rsv temp ' || l_return_status);

9663: , p_demand_source_name => l_rsv_rec.demand_source_name
9664: );
9665:
9666: IF (l_debug = 1) THEN
9667: debug_print('After insert into rsv temp ' || l_return_status);
9668: END IF;
9669:
9670: IF l_return_status = fnd_api.g_ret_sts_error THEN
9671: RAISE fnd_api.g_exc_error;

Line 18132: PROCEDURE insert_rsv_temp(

18128:
18129: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18130: END transfer_lpn_trx_reservation;
18131:
18132: PROCEDURE insert_rsv_temp(
18133: p_organization_id NUMBER
18134: , p_inventory_item_id NUMBER
18135: , p_primary_reservation_quantity NUMBER
18136: , p_tree_id NUMBER

Line 18143: l_api_name VARCHAR2(100) := 'Insert_rsv_temp';

18139: , p_demand_source_line_id NUMBER
18140: , p_demand_source_header_id NUMBER
18141: , p_demand_source_name VARCHAR2
18142: ) IS
18143: l_api_name VARCHAR2(100) := 'Insert_rsv_temp';
18144: x_msg_count NUMBER;
18145: x_msg_data VARCHAR2(1000);
18146: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
18147: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 18149: INSERT INTO rsv_temp

18145: x_msg_data VARCHAR2(1000);
18146: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
18147: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18148: BEGIN
18149: INSERT INTO rsv_temp
18150: (
18151: p_organization_id
18152: , p_inventory_item_id
18153: , p_primary_reservation_quantity

Line 18172: debug_print('Inserted rsv_temp org='||p_organization_id||' item='||p_inventory_item_id||', p_tree_id='||p_tree_id||', p_reservation_id='||p_reservation_id||', p_demand_source_line_id ='||p_demand_source_line_id);

18168: , p_demand_source_name
18169: );
18170:
18171: IF (l_debug = 1) THEN
18172: debug_print('Inserted rsv_temp org='||p_organization_id||' item='||p_inventory_item_id||', p_tree_id='||p_tree_id||', p_reservation_id='||p_reservation_id||', p_demand_source_line_id ='||p_demand_source_line_id);
18173: END IF;
18174:
18175: x_return_status := l_return_status;
18176: EXCEPTION

Line 18186: END insert_rsv_temp;

18182: END IF;
18183:
18184: -- Get message count and data
18185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18186: END insert_rsv_temp;
18187:
18188: --Ref 2132071 This procedure pick up reservations created from last commit issued
18189: --and check if there is any node violation.If there is one then it will clear
18190: --the reservations .This call also clears Quantity cache at the end of call

Line 18199: , x_failed_rsv_temp_tbl OUT NOCOPY inv_reservation_global.mtl_failed_rsv_tbl_type

18195: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
18196: , x_return_status OUT NOCOPY VARCHAR2
18197: , x_msg_count OUT NOCOPY NUMBER
18198: , x_msg_data OUT NOCOPY VARCHAR2
18199: , x_failed_rsv_temp_tbl OUT NOCOPY inv_reservation_global.mtl_failed_rsv_tbl_type
18200: ) IS
18201: l_api_version_number CONSTANT NUMBER := 1.0;
18202: l_api_name CONSTANT VARCHAR2(30) := 'Do_check_for_commit';
18203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 18206: l_failed_rsv_temp_tbl inv_reservation_global.mtl_failed_rsv_tbl_type;

18202: l_api_name CONSTANT VARCHAR2(30) := 'Do_check_for_commit';
18203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
18204: l_no_violation BOOLEAN;
18205: l_root_id INTEGER;
18206: l_failed_rsv_temp_tbl inv_reservation_global.mtl_failed_rsv_tbl_type;
18207: l_failed_rsv_temp_rec inv_reservation_global.mtl_failed_rsv_rec_type;
18208: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
18209: p_original_serial_number inv_reservation_global.serial_number_tbl_type;
18210: l_reservation_id NUMBER;

Line 18207: l_failed_rsv_temp_rec inv_reservation_global.mtl_failed_rsv_rec_type;

18203: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
18204: l_no_violation BOOLEAN;
18205: l_root_id INTEGER;
18206: l_failed_rsv_temp_tbl inv_reservation_global.mtl_failed_rsv_tbl_type;
18207: l_failed_rsv_temp_rec inv_reservation_global.mtl_failed_rsv_rec_type;
18208: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
18209: p_original_serial_number inv_reservation_global.serial_number_tbl_type;
18210: l_reservation_id NUMBER;
18211: l_failed_rsv_temp_tbl_count INTEGER := 0;

Line 18211: l_failed_rsv_temp_tbl_count INTEGER := 0;

18207: l_failed_rsv_temp_rec inv_reservation_global.mtl_failed_rsv_rec_type;
18208: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
18209: p_original_serial_number inv_reservation_global.serial_number_tbl_type;
18210: l_reservation_id NUMBER;
18211: l_failed_rsv_temp_tbl_count INTEGER := 0;
18212: l_error_code VARCHAR2(100);
18213: l_demand_source_line_id NUMBER;
18214: l_demand_source_header_id NUMBER;
18215: l_demand_source_name VARCHAR2(1000);

Line 18224: FROM rsv_temp

18220:
18221: -- Bug 3926414, added order by clause to avoid deadlock.
18222: CURSOR tree_csr IS
18223: SELECT p_tree_id
18224: FROM rsv_temp
18225: ORDER BY p_organization_id, p_inventory_item_id;
18226:
18227: --Bug 6812723, changing input from p_tree_id to l_tree_id
18228: CURSOR rsv_csr(l_tree_id NUMBER) IS

Line 18235: FROM rsv_temp

18231: , p_inventory_item_id
18232: , p_demand_source_line_id
18233: , p_demand_source_header_id
18234: , p_demand_source_name
18235: FROM rsv_temp
18236: WHERE p_tree_id = l_tree_id;
18237: BEGIN
18238: FOR tree_rec IN tree_csr LOOP
18239:

Line 18287: l_failed_rsv_temp_tbl_count := l_failed_rsv_temp_tbl_count + 1;

18283: RAISE fnd_api.g_exc_unexpected_error;
18284: -- END IF;
18285: END IF;
18286:
18287: l_failed_rsv_temp_tbl_count := l_failed_rsv_temp_tbl_count + 1;
18288: l_failed_rsv_temp_rec.reservation_id := l_reservation_id;
18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;
18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;

Line 18288: l_failed_rsv_temp_rec.reservation_id := l_reservation_id;

18284: -- END IF;
18285: END IF;
18286:
18287: l_failed_rsv_temp_tbl_count := l_failed_rsv_temp_tbl_count + 1;
18288: l_failed_rsv_temp_rec.reservation_id := l_reservation_id;
18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;
18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;
18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;

Line 18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;

18285: END IF;
18286:
18287: l_failed_rsv_temp_tbl_count := l_failed_rsv_temp_tbl_count + 1;
18288: l_failed_rsv_temp_rec.reservation_id := l_reservation_id;
18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;
18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;
18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;
18293: l_failed_rsv_temp_rec.demand_source_name := l_demand_source_name;

Line 18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;

18286:
18287: l_failed_rsv_temp_tbl_count := l_failed_rsv_temp_tbl_count + 1;
18288: l_failed_rsv_temp_rec.reservation_id := l_reservation_id;
18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;
18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;
18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;
18293: l_failed_rsv_temp_rec.demand_source_name := l_demand_source_name;
18294: l_failed_rsv_temp_tbl(l_failed_rsv_temp_tbl_count) := l_failed_rsv_temp_rec;

Line 18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;

18287: l_failed_rsv_temp_tbl_count := l_failed_rsv_temp_tbl_count + 1;
18288: l_failed_rsv_temp_rec.reservation_id := l_reservation_id;
18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;
18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;
18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;
18293: l_failed_rsv_temp_rec.demand_source_name := l_demand_source_name;
18294: l_failed_rsv_temp_tbl(l_failed_rsv_temp_tbl_count) := l_failed_rsv_temp_rec;
18295: END LOOP;

Line 18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;

18288: l_failed_rsv_temp_rec.reservation_id := l_reservation_id;
18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;
18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;
18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;
18293: l_failed_rsv_temp_rec.demand_source_name := l_demand_source_name;
18294: l_failed_rsv_temp_tbl(l_failed_rsv_temp_tbl_count) := l_failed_rsv_temp_rec;
18295: END LOOP;
18296:

Line 18293: l_failed_rsv_temp_rec.demand_source_name := l_demand_source_name;

18289: l_failed_rsv_temp_rec.organization_id := l_organization_id;
18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;
18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;
18293: l_failed_rsv_temp_rec.demand_source_name := l_demand_source_name;
18294: l_failed_rsv_temp_tbl(l_failed_rsv_temp_tbl_count) := l_failed_rsv_temp_rec;
18295: END LOOP;
18296:
18297: IF rsv_csr%ISOPEN THEN

Line 18294: l_failed_rsv_temp_tbl(l_failed_rsv_temp_tbl_count) := l_failed_rsv_temp_rec;

18290: l_failed_rsv_temp_rec.inventory_item_id := l_inventory_item_id;
18291: l_failed_rsv_temp_rec.demand_source_line_id := l_demand_source_line_id;
18292: l_failed_rsv_temp_rec.demand_source_header_id := l_demand_source_header_id;
18293: l_failed_rsv_temp_rec.demand_source_name := l_demand_source_name;
18294: l_failed_rsv_temp_tbl(l_failed_rsv_temp_tbl_count) := l_failed_rsv_temp_rec;
18295: END LOOP;
18296:
18297: IF rsv_csr%ISOPEN THEN
18298: CLOSE rsv_csr;

Line 18303: x_failed_rsv_temp_tbl := l_failed_rsv_temp_tbl;

18299: END IF;
18300: END IF;
18301: END LOOP;
18302:
18303: x_failed_rsv_temp_tbl := l_failed_rsv_temp_tbl;
18304: x_return_status := l_return_status;
18305: inv_quantity_tree_pub.clear_quantity_cache;
18306: EXCEPTION
18307: WHEN fnd_api.g_exc_error THEN