DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 459: AHL_MC_PATH_POSITION_PVT.get_pos_instance(

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

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

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

Line 2604: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (

2600: -- passed and if this API has NOT been called from Part Change
2601: IF (p_x_disposition_rec.instance_id IS NULL AND p_x_disposition_rec.part_change_id IS NULL) THEN
2602: l_unit_instance_id := get_unit_instance_id(p_x_disposition_rec.workorder_id);
2603: IF l_unit_instance_id IS NOT NULL THEN
2604: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (
2605: p_api_version => 1.0,
2606: x_return_status => x_return_status,
2607: x_msg_count => x_msg_count,
2608: x_msg_data => x_msg_data,

Line 2761: AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID (

2757: ' Instance id ' || p_x_disposition_rec.instance_id );
2758: END IF;
2759:
2760: IF (root_node_in_uc_headers(p_x_disposition_rec.instance_id) = TRUE) THEN
2761: AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID (
2762: p_api_version => 1.0,
2763: x_return_status => x_return_status,
2764: x_msg_count => x_msg_count,
2765: x_msg_data => x_msg_data,

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

3045: FETCH chk_non_serialized_csr INTO l_dummy;
3046: IF (chk_non_serialized_csr%NOTFOUND) THEN
3047: -- The chk_non_serialized_csr will not fetch results if item id is NULL.
3048: -- If item id is NULL, then this disposition is being created for empty position.
3049: -- Check for non-serialized position by calling the API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled
3050: IF (p_disposition_rec.inventory_item_id IS NULL) THEN
3051: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3052: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3053: 'Before API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);

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

3049: -- Check for non-serialized position by calling the API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled
3050: IF (p_disposition_rec.inventory_item_id IS NULL) THEN
3051: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3052: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3053: 'Before API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);
3054: END IF;
3055:
3056: l_srl_flag := AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(
3057: NULL,

Line 3056: l_srl_flag := AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(

3052: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3053: 'Before API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);
3054: END IF;
3055:
3056: l_srl_flag := AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled(
3057: NULL,
3058: p_disposition_rec.path_position_id
3059: );
3060:

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

3059: );
3060:
3061: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3062: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,
3063: 'After API AHL_MC_PATH_POSITION_PVT.Is_Position_Serial_Controlled call l_srl_flag => '||l_srl_flag);
3064: END IF;
3065: END IF;
3066:
3067: --If item/position is serialized, then validate that path position does not exist in other dispositions

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

3085: RAISE FND_API.G_EXC_ERROR;
3086: END IF;
3087:
3088: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3089: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'About to call AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance with ' ||
3090: ' p_position_id = ' || p_disposition_rec.path_position_id ||
3091: ', p_csi_item_instance_id = ' || l_unit_instance_id);
3092: END IF;
3093:

Line 3094: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (

3090: ' p_position_id = ' || p_disposition_rec.path_position_id ||
3091: ', p_csi_item_instance_id = ' || l_unit_instance_id);
3092: END IF;
3093:
3094: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance (
3095: p_api_version => 1.0,
3096: x_return_status => l_return_status,
3097: x_msg_count => l_msg_count,
3098: x_msg_data => l_msg_data,

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

3105: x_mapping_status => l_mapping_status
3106: );
3107:
3108: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3109: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Returned from call to AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance: ' ||
3110: ' x_return_status ' || l_return_status ||
3111: ', x_parent_instance_id ' || l_parent_instance_id ||
3112: ', x_mapping_status = ' || l_mapping_status);
3113: END IF;

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

3120:
3121: -- SATHAPLI:: Bug 6836572, 19-Mar-2008
3122: -- If the workorder instance is root instance of an installed sub UC, and the sub UC has been removed during parts change, then
3123: -- the API get_unit_instance_id would return the sub UC's root instance, instead of the top most UC's root instance. This
3124: -- would result in the API AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance returning x_mapping_status as 'NA'.
3125: -- 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
3126: -- Disposition creation.
3127:
3128: IF (l_mapping_status = 'NA') THEN