DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 462: AHL_MC_PATH_POSITION_PVT.get_pos_instance(

458: 'Before calling mc path position API and p_position_id ='||
459: l_route_mtl_req_tbl(i).position_path_id||' p_csi_item_instance_id='||
460: l_unit_instance_id);
461: END IF;
462: AHL_MC_PATH_POSITION_PVT.get_pos_instance(
463: p_api_version => 1.0,
464: p_init_msg_list => FND_API.G_FALSE,
465: p_commit => FND_API.G_FALSE,
466: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 479: 'Returned from call to AHL_MC_PATH_POSITION_PVT.get_pos_instance:' ||

475:
476: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
478: G_LOG_PREFIX||l_api_name||': Within the procedure ',
479: 'Returned from call to AHL_MC_PATH_POSITION_PVT.get_pos_instance:' ||
480: ' x_return_status = ' || l_return_status ||
481: ', x_mapping_status = ' || l_mapping_status ||
482: ', x_item_instance_id = ' || l_installed_inst_id ||
483: ', x_lowest_uc_csi_id = ' || l_lowest_unit_inst_id);

Line 3027: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (

3023: -- passed and if this API has NOT been called from Part Change
3024: IF (p_x_disposition_rec.instance_id IS NULL AND p_x_disposition_rec.part_change_id IS NULL) THEN
3025: l_unit_instance_id := get_unit_instance_id(p_x_disposition_rec.workorder_id);
3026: IF l_unit_instance_id IS NOT NULL THEN
3027: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (
3028: p_api_version => 1.0,
3029: x_return_status => x_return_status,
3030: x_msg_count => x_msg_count,
3031: x_msg_data => x_msg_data,

Line 3184: AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID (

3180: ' Instance id ' || p_x_disposition_rec.instance_id );
3181: END IF;
3182:
3183: IF (root_node_in_uc_headers(p_x_disposition_rec.instance_id) = TRUE) THEN
3184: AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID (
3185: p_api_version => 1.0,
3186: x_return_status => x_return_status,
3187: x_msg_count => x_msg_count,
3188: x_msg_data => x_msg_data,

Line 3477: -- Check for non-serialized position by calling the API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled

3473: FETCH chk_non_serialized_csr INTO l_dummy;
3474: IF (chk_non_serialized_csr%NOTFOUND) THEN
3475: -- The chk_non_serialized_csr will not fetch results if item id is NULL.
3476: -- If item id is NULL, then this disposition is being created for empty position.
3477: -- Check for non-serialized position by calling the API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled
3478: IF (p_disposition_rec.inventory_item_id IS NULL) THEN
3479: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3481: 'Before API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);

Line 3481: 'Before API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);

3477: -- Check for non-serialized position by calling the API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled
3478: IF (p_disposition_rec.inventory_item_id IS NULL) THEN
3479: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3481: 'Before API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);
3482: END IF;
3483:
3484: l_srl_flag := AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(
3485: NULL,

Line 3484: l_srl_flag := AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(

3480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3481: 'Before API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);
3482: END IF;
3483:
3484: l_srl_flag := AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(
3485: NULL,
3486: p_disposition_rec.path_position_id
3487: );
3488:

Line 3491: 'After API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);

3487: );
3488:
3489: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3491: 'After API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);
3492: END IF;
3493: END IF;
3494:
3495: --If item/position is serialized, then validate that path position does not exist in other dispositions

Line 3517: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance with ' ||

3513: RAISE FND_API.G_EXC_ERROR;
3514: END IF;
3515:
3516: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3517: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance with ' ||
3518: ' p_position_id = ' || p_disposition_rec.path_position_id ||
3519: ', p_csi_item_instance_id = ' || l_unit_instance_id);
3520: END IF;
3521:

Line 3522: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (

3518: ' p_position_id = ' || p_disposition_rec.path_position_id ||
3519: ', p_csi_item_instance_id = ' || l_unit_instance_id);
3520: END IF;
3521:
3522: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (
3523: p_api_version => 1.0,
3524: x_return_status => l_return_status,
3525: x_msg_count => l_msg_count,
3526: x_msg_data => l_msg_data,

Line 3537: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Returned from call to AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance: ' ||

3533: x_mapping_status => l_mapping_status
3534: );
3535:
3536: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3537: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Returned from call to AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance: ' ||
3538: ' x_return_status ' || l_return_status ||
3539: ', x_parent_instance_id ' || l_parent_instance_id ||
3540: ', x_mapping_status = ' || l_mapping_status);
3541: END IF;

Line 3552: -- would result in the API AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance returning x_mapping_status as 'NA'.

3548:
3549: -- SATHAPLI:: Bug 6836572, 19-Mar-2008
3550: -- If the workorder instance is root instance of an installed sub UC, and the sub UC has been removed during parts change, then
3551: -- the API get_unit_instance_id would return the sub UC's root instance, instead of the top most UC's root instance. This
3552: -- would result in the API AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance returning x_mapping_status as 'NA'.
3553: -- To bypass this, we can just check for the part change to have taken place or not. If yes, then we can go ahead with the
3554: -- Disposition creation.
3555:
3556: IF (l_mapping_status = 'NA') THEN