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.AHL_MM_MTL_MGT_PVT dependencies on AHL_MM_RESERVATIONS_PVT

Line 699: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;

695: l_qty_detailed NUMBER;
696: l_return_status VARCHAR2(1);
697: l_uom VARCHAR2(3);
698: l_old_rsrv_id NUMBER;
699: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;
700: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;
701:
702: l_temp_txn_id NUMBER;
703: l_fm_serial VARCHAR2(30);

Line 700: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;

696: l_return_status VARCHAR2(1);
697: l_uom VARCHAR2(3);
698: l_old_rsrv_id NUMBER;
699: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;
700: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;
701:
702: l_temp_txn_id NUMBER;
703: l_fm_serial VARCHAR2(30);
704: l_to_serial VARCHAR2(30);

Line 825: AHL_MM_RESERVATIONS_PVT.CANCEL_RESERVATION(p_api_version => 1.0

821: l_reservation_id_tbl(1) := l_old_rsrv_id;
822: l_serial_number_tbl(1).inventory_item_id := l_inv_item_id;
823: l_serial_number_tbl(1).serial_number := p_supply_tbl_type(i).Serial_Number;
824:
825: AHL_MM_RESERVATIONS_PVT.CANCEL_RESERVATION(p_api_version => 1.0
826: , p_init_msg_list => FND_API.G_FALSE
827: , p_commit => FND_API.G_FALSE
828: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
829: , p_module_type => 'INTERNAL'

Line 2686: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;

2682: X_MSG_COUNT OUT NOCOPY NUMBER,
2683: X_MSG_DATA OUT NOCOPY VARCHAR2,
2684: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
2685: IS
2686: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;
2687: L_SERIAL_NUMBER_TBL AHL_MM_RESERVATIONS_PVT.SERIAL_NUMBER_TBL_TYPE;
2688: --L_RESERVATION_ID NUMBER;
2689: l_return_status VARCHAR2(1);
2690: L_MSG_COUNT NUMBER;

Line 2687: L_SERIAL_NUMBER_TBL AHL_MM_RESERVATIONS_PVT.SERIAL_NUMBER_TBL_TYPE;

2683: X_MSG_DATA OUT NOCOPY VARCHAR2,
2684: X_RETURN_STATUS OUT NOCOPY VARCHAR2)
2685: IS
2686: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;
2687: L_SERIAL_NUMBER_TBL AHL_MM_RESERVATIONS_PVT.SERIAL_NUMBER_TBL_TYPE;
2688: --L_RESERVATION_ID NUMBER;
2689: l_return_status VARCHAR2(1);
2690: L_MSG_COUNT NUMBER;
2691: L_MSG_INDEX_OUT NUMBER;

Line 2705: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION(

2701: L_RSV_REC.SUPPLY_SOURCE_LINE_ID := P_INTERNAL_REQ_LINE_ID;
2702: L_RSV_REC.SUPPLY_SOURCE_LINE_DETAIL := NULL;
2703: L_RSV_REC.PRIMARY_RESERVATION_QUANTITY := P_REQUIRED_QUANTITY;
2704:
2705: AHL_MM_RESERVATIONS_PVT.CREATE_RESERVATION(
2706: p_api_version => 1.0,
2707: p_init_msg_list => 'F',
2708: p_commit => 'T',
2709: p_validation_level => FND_API.G_VALID_LEVEL_FULL, -- the validation level

Line 4106: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;

4102: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;
4103:
4104: -- Record type variables
4105: -- Variables for making reservation
4106: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;
4107: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;
4108: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;
4109:
4110: -- for commit

Line 4107: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;

4103:
4104: -- Record type variables
4105: -- Variables for making reservation
4106: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;
4107: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;
4108: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;
4109:
4110: -- for commit
4111: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 4108: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;

4104: -- Record type variables
4105: -- Variables for making reservation
4106: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;
4107: l_serial_number_tbl AHL_MM_RESERVATIONS_PVT.serial_number_tbl_type;
4108: l_reservation_id_tbl AHL_MM_RESERVATIONS_PVT.number_table_type;
4109:
4110: -- for commit
4111: l_commit VARCHAR2(1) := FND_API.G_FALSE;
4112: l_count NUMBER;

Line 4282: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION(

4278: G_DEBUG_LINE_NUM := 70;
4279:
4280: x_msg_count := NULL;
4281: x_msg_data := NULL;
4282: AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION(
4283: p_api_version => 1.0,
4284: p_init_msg_list => FND_API.G_TRUE,
4285: p_commit => FND_API.G_FALSE,
4286: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4297: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned exception');

4293: x_reservation_id_tbl => l_reservation_id_tbl);
4294: EXCEPTION
4295: WHEN OTHERS THEN
4296: IF (l_log_exception >= l_log_current_level) THEN
4297: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned exception');
4298: FND_LOG.string(l_log_exception, l_debug_module, G_DEBUG_LINE_NUM||':SQLERRM ='||SQLERRM);
4299: END IF;
4300: -- Raise Exception
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4305: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned error. x_msg_count ='||x_msg_count);

4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: END;
4303: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4304: IF (l_log_error >= l_log_current_level) THEN
4305: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned error. x_msg_count ='||x_msg_count);
4306: END IF;
4307: -- Raise exception
4308: RAISE FND_API.G_EXC_ERROR;
4309: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4311: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned unexpected error.');

4307: -- Raise exception
4308: RAISE FND_API.G_EXC_ERROR;
4309: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4310: IF (l_log_error >= l_log_current_level) THEN
4311: FND_LOG.string(l_log_error, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION returned unexpected error.');
4312: END IF;
4313: -- Raise exception
4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4315: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4317: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION completed successfully.');

4313: -- Raise exception
4314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4315: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4316: IF (l_log_statement >= l_log_current_level) THEN
4317: FND_LOG.string(l_log_statement, l_debug_module, G_DEBUG_LINE_NUM||':API AHL_MM_RESERVATIONS_PVT.PROCESS_RESERVATION completed successfully.');
4318: END IF;
4319: --FND_MESSAGE.Set_Name('AHL','AHL_MM_RES_MSG');
4320: --FND_MESSAGE.Set_Token('MSG','Material transfer is completed and reservation made');
4321: --FND_MSG_PUB.ADD;