APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_RSV_RESERVATIONS_PVT

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

7394: -- When a visit is pushed to production, all the material reservations that were
7395: -- created will have to be transferred with the WIP details
7396:
7397: IF (l_log_statement >= l_log_current_level) THEN
7398: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION');
7399: END IF;
7400:
7401: AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION
7402: (

Line 7401: AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION

7397: IF (l_log_statement >= l_log_current_level) THEN
7398: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION');
7399: END IF;
7400:
7401: AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION
7402: (
7403: p_api_version => l_api_version,
7404: p_init_msg_list => l_init_msg_list,
7405: x_return_status => l_return_status,

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

7409: p_visit_id => p_visit_id
7410: );
7411:
7412: IF (l_log_statement >= l_log_current_level) THEN
7413: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION - l_return_status : '||l_return_status);
7414: END IF;
7415:
7416: -- handle the exceptions, if any
7417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

7417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7418: IF (l_log_statement >= l_log_current_level) THEN
7419: fnd_log.string(l_log_statement,
7420: L_DEBUG_KEY,
7421: ':Errors from AHL_RSV_RESERVATIONS_PVT.TRANSFER_RESERVATION API : ' || x_msg_count );
7422: END IF;
7423: RAISE Fnd_Api.g_exc_error;
7424: END IF;
7425: --------------------------------- R12 changes For Serial Number Reservations End----------------------------------

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

12518:
12519: IF (l_log_statement >= l_log_current_level) THEN
12520: fnd_log.string(l_log_statement,
12521: L_DEBUG_KEY,
12522: 'Before calling AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR');
12523: fnd_log.string(l_log_statement,
12524: L_DEBUG_KEY,
12525: 'l_material_reqrs_rec.scheduled_material_id->' || l_material_reqrs_rec.scheduled_material_id);
12526: fnd_log.string(l_log_statement,

Line 12531: AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR

12527: L_DEBUG_KEY,'l_scheduled_matrial_id->' || l_scheduled_matrial_id);
12528: END IF;
12529:
12530: -- Call Transfer reservations
12531: AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR
12532: (p_api_version => l_api_version,
12533: p_init_msg_list => l_init_msg_list,
12534: p_module_type => p_module_type,
12535: x_msg_count => x_msg_count,

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

12542:
12543: IF (l_log_statement >= l_log_current_level) THEN
12544: fnd_log.string(l_log_statement,
12545: L_DEBUG_KEY,
12546: 'After calling AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR. Return Status = '||
12547: x_return_status);
12548: END IF;
12549:
12550: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

12551: x_msg_count := FND_MSG_PUB.count_msg;
12552: IF (l_log_statement >= l_log_current_level) THEN
12553: fnd_log.string(l_log_statement,
12554: L_DEBUG_KEY,
12555: 'Errors from AHL_RSV_RESERVATIONS_PVT.TRNSFR_RSRV_FOR_MATRL_REQR. Message count: ' || x_msg_count);
12556: END IF;
12557: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
12558: RAISE FND_API.G_EXC_ERROR;
12559: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN