APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_RSV_RESERVATIONS_PVT

Line 4897: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION');

4893: -- When a visit is pushed to production, all the material reservations that were
4894: -- created will have to be transferred with the WIP details
4895:
4896: IF (l_log_statement >= l_log_current_level) THEN
4897: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION');
4898: END IF;
4899:
4900: AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION
4901: (

Line 4900: AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION

4896: IF (l_log_statement >= l_log_current_level) THEN
4897: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION');
4898: END IF;
4899:
4900: AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION
4901: (
4902: p_api_version => l_api_version,
4903: p_init_msg_list => l_init_msg_list,
4904: x_return_status => l_return_status,

Line 4912: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION - l_return_status : '||l_return_status);

4908: p_visit_id => p_visit_id
4909: );
4910:
4911: IF (l_log_statement >= l_log_current_level) THEN
4912: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION - l_return_status : '||l_return_status);
4913: END IF;
4914:
4915: -- handle the exceptions, if any
4916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4920: ':Errors from AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION API : ' || x_msg_count );

4916: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4917: IF (l_log_statement >= l_log_current_level) THEN
4918: fnd_log.string(l_log_statement,
4919: L_DEBUG_KEY,
4920: ':Errors from AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION API : ' || x_msg_count );
4921: END IF;
4922: RAISE Fnd_Api.g_exc_error;
4923: END IF;
4924: --------------------------------- R12 changes For Serial Number Reservations End----------------------------------

Line 8726: 'Before calling AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR');

8722:
8723: IF (l_log_statement >= l_log_current_level) THEN
8724: fnd_log.string(l_log_statement,
8725: L_DEBUG_KEY,
8726: 'Before calling AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR');
8727: fnd_log.string(l_log_statement,
8728: L_DEBUG_KEY,
8729: 'l_material_reqrs_rec.scheduled_material_id->' || l_material_reqrs_rec.scheduled_material_id);
8730: fnd_log.string(l_log_statement,

Line 8735: AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR

8731: L_DEBUG_KEY,'l_scheduled_matrial_id->' || l_scheduled_matrial_id);
8732: END IF;
8733:
8734: -- Call Transfer reservations
8735: AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR
8736: (p_api_version => l_api_version,
8737: p_init_msg_list => l_init_msg_list,
8738: p_module_type => p_module_type,
8739: x_msg_count => x_msg_count,

Line 8750: 'After calling AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR. Return Status = '||

8746:
8747: IF (l_log_statement >= l_log_current_level) THEN
8748: fnd_log.string(l_log_statement,
8749: L_DEBUG_KEY,
8750: 'After calling AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR. Return Status = '||
8751: x_return_status);
8752: END IF;
8753:
8754: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 8759: 'Errors from AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR. Message count: ' || x_msg_count);

8755: x_msg_count := FND_MSG_PUB.count_msg;
8756: IF (l_log_statement >= l_log_current_level) THEN
8757: fnd_log.string(l_log_statement,
8758: L_DEBUG_KEY,
8759: 'Errors from AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR. Message count: ' || x_msg_count);
8760: END IF;
8761: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8762: RAISE FND_API.G_EXC_ERROR;
8763: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN