DBA Data[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_RM_ROUTE_UTIL

Line 136: AHL_RM_ROUTE_UTIL.validate_route_status

132: RETURN;
133: END IF;
134: -- Check if the Route / Operation is in Updatable status
135: IF ( p_association_type = 'ROUTE' ) THEN
136: AHL_RM_ROUTE_UTIL.validate_route_status
137: (
138: x_return_status => l_return_status,
139: x_msg_data => l_msg_data,
140: p_route_id => p_object_id

Line 143: AHL_RM_ROUTE_UTIL.validate_operation_status

139: x_msg_data => l_msg_data,
140: p_route_id => p_object_id
141: );
142: ELSIF ( p_association_type = 'OPERATION' ) THEN
143: AHL_RM_ROUTE_UTIL.validate_operation_status
144: (
145: x_return_status => l_return_status,
146: x_msg_data => l_msg_data,
147: p_operation_id => p_object_id

Line 150: AHL_RM_ROUTE_UTIL.validate_efct_status

146: x_msg_data => l_msg_data,
147: p_operation_id => p_object_id
148: );
149: ELSIF ( p_association_type = 'DISPOSITION' ) THEN
150: AHL_RM_ROUTE_UTIL.validate_efct_status
151: (
152: x_return_status => l_return_status,
153: x_msg_data => l_msg_data,
154: p_efct_id => p_object_id

Line 205: AHL_RM_ROUTE_UTIL.validate_route_status

201: FND_MSG_PUB.add;
202: x_return_status := FND_API.G_RET_STS_ERROR;
203: RAISE FND_API.G_EXC_ERROR;
204: END IF;
205: AHL_RM_ROUTE_UTIL.validate_route_status
206: (
207: p_route_id => p_object_id,
208: x_return_status => l_return_status,
209: x_msg_data => l_msg_data

Line 349: AHL_RM_ROUTE_UTIL.validate_item_comp

345: -- Convert / Validate Item Composition
346: IF ( p_association_type = 'DISPOSITION' AND
347: p_x_material_req_rec.item_comp_detail_id IS NOT NULL AND
348: p_x_material_req_rec.item_comp_detail_id <> FND_API.G_MISS_NUM ) THEN
349: AHL_RM_ROUTE_UTIL.validate_item_comp
350: (
351: x_return_status => l_return_status,
352: x_msg_data => l_msg_data,
353: p_x_item_comp_detail_id => p_x_material_req_rec.item_comp_detail_id

Line 369: AHL_RM_ROUTE_UTIL.validate_position_path

365: ( p_x_material_req_rec.position_path_id IS NOT NULL AND
366: p_x_material_req_rec.position_path_id <> FND_API.G_MISS_NUM ) OR
367: ( p_x_material_req_rec.position_path IS NOT NULL AND
368: p_x_material_req_rec.position_path <> FND_API.G_MISS_CHAR ) ) THEN
369: AHL_RM_ROUTE_UTIL.validate_position_path
370: (
371: x_return_status => l_return_status,
372: x_msg_data => l_msg_data,
373: p_position_path => p_x_material_req_rec.position_path,

Line 394: AHL_RM_ROUTE_UTIL.validate_item_group

390: IF ( ( p_x_material_req_rec.item_group_id IS NOT NULL AND
391: p_x_material_req_rec.item_group_id <> FND_API.G_MISS_NUM ) OR
392: ( p_x_material_req_rec.item_group_name IS NOT NULL AND
393: p_x_material_req_rec.item_group_name <> FND_API.G_MISS_CHAR ) ) THEN
394: AHL_RM_ROUTE_UTIL.validate_item_group
395: (
396: x_return_status => l_return_status,
397: x_msg_data => l_msg_data,
398: p_association_type => p_association_type,

Line 449: AHL_RM_ROUTE_UTIL.validate_item

445: ( p_x_material_req_rec.item_number IS NOT NULL AND
446: p_x_material_req_rec.item_number <> FND_API.G_MISS_CHAR ) ) THEN
447: IF ( p_association_type <> 'DISPOSITION' )
448: THEN
449: AHL_RM_ROUTE_UTIL.validate_item
450: (
451: x_return_status => l_return_status,
452: x_msg_data => l_msg_data,
453: p_item_number => p_x_material_req_rec.item_number,

Line 458: AHL_RM_ROUTE_UTIL.validate_adt_item

454: p_x_inventory_item_id => p_x_material_req_rec.inventory_item_id,
455: p_x_inventory_org_id => p_x_material_req_rec.inventory_org_id
456: );
457: ELSE
458: AHL_RM_ROUTE_UTIL.validate_adt_item
459: (
460: x_return_status => l_return_status,
461: x_msg_data => l_msg_data,
462: p_item_number => p_x_material_req_rec.item_number,

Line 494: AHL_RM_ROUTE_UTIL.validate_uom

490: p_x_material_req_rec.uom_code <> FND_API.G_MISS_CHAR ) OR
491: ( p_x_material_req_rec.uom IS NOT NULL AND
492: p_x_material_req_rec.uom <> FND_API.G_MISS_CHAR ) )
493: THEN
494: AHL_RM_ROUTE_UTIL.validate_uom
495: (
496: x_return_status => l_return_status,
497: x_msg_data => l_msg_data,
498: p_uom => p_x_material_req_rec.uom,

Line 521: AHL_RM_ROUTE_UTIL.Validate_Master_Config

517: p_x_material_req_rec.MC_NAME <> FND_API.G_MISS_CHAR ) OR
518: ( p_x_material_req_rec.MC_ID IS NOT NULL AND
519: p_x_material_req_rec.MC_ID <> FND_API.G_MISS_NUM ) )
520: THEN
521: AHL_RM_ROUTE_UTIL.Validate_Master_Config
522: (
523: x_return_status => l_return_status,
524: x_msg_data => l_msg_data,
525: p_mc_name => p_x_material_req_rec.MC_NAME,

Line 547: AHL_RM_ROUTE_UTIL.Validate_Mc_Position

543: p_x_material_req_rec.MC_POSITION <> FND_API.G_MISS_CHAR ) OR
544: ( p_x_material_req_rec.MC_POSITION_KEY IS NOT NULL AND
545: p_x_material_req_rec.MC_POSITION_KEY <> FND_API.G_MISS_NUM ) )
546: THEN
547: AHL_RM_ROUTE_UTIL.Validate_Mc_Position
548: (
549: x_return_status => l_return_status,
550: x_msg_data => l_msg_data,
551: p_mc_id => p_x_material_req_rec.MC_ID,

Line 586: AHL_RM_ROUTE_UTIL.validate_master_configuration

582: IF ( ( p_x_route_efct_rec.MC_ID IS NOT NULL AND
583: p_x_route_efct_rec.MC_ID <> FND_API.G_MISS_NUM ) OR
584: ( p_x_route_efct_rec.MC_NAME IS NOT NULL AND
585: p_x_route_efct_rec.MC_NAME <> FND_API.G_MISS_CHAR ) ) THEN
586: AHL_RM_ROUTE_UTIL.validate_master_configuration
587: (
588: x_return_status => l_return_status,
589: x_msg_data => l_msg_data,
590: p_mc_name => p_x_route_efct_rec.MC_NAME,

Line 617: AHL_RM_ROUTE_UTIL.validate_effectivity_item

613: ( (p_x_route_efct_rec.ORGANIZATION_CODE IS NOT NULL AND p_x_route_efct_rec.ORGANIZATION_CODE <> FND_API.G_MISS_CHAR )
614: AND(p_x_route_efct_rec.item_number IS NOT NULL AND p_x_route_efct_rec.item_number <> FND_API.G_MISS_CHAR )
615: )
616: )THEN
617: AHL_RM_ROUTE_UTIL.validate_effectivity_item
618: (
619: x_return_status => l_return_status,
620: x_msg_data => l_msg_data,
621: p_item_number => p_x_route_efct_rec.item_number,

Line 1750: AHL_RM_ROUTE_UTIL.validate_item_uom

1746: IF ( p_material_req_rec.uom_code IS NOT NULL AND
1747: ( p_material_req_rec.item_group_id IS NOT NULL OR
1748: ( p_material_req_rec.inventory_item_id IS NOT NULL AND
1749: p_material_req_rec.inventory_org_id IS NOT NULL ) ) ) THEN
1750: AHL_RM_ROUTE_UTIL.validate_item_uom
1751: (
1752: x_return_status => l_return_status,
1753: x_msg_data => l_msg_data,
1754: p_item_group_id => p_material_req_rec.item_group_id,

Line 2110: AHL_RM_ROUTE_UTIL.validate_ApplnUsage

2106: --This is to be added before calling validate_efct_api_inputs
2107: -- Validate Application Usage
2108: IF (p_association_type = 'ROUTE')
2109: THEN
2110: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
2111: (
2112: p_object_id => p_object_id,
2113: p_association_type => p_association_type,
2114: x_return_status => x_return_status,

Line 2234: AHL_RM_ROUTE_UTIL.validate_operation_status

2230: END IF;
2231: IF ( p_association_type = 'OPERATION')
2232: THEN
2233: -- Check if the Route is existing and in Draft status
2234: AHL_RM_ROUTE_UTIL.validate_operation_status
2235: (
2236: p_object_id,
2237: l_msg_data,
2238: l_return_status

Line 2269: AHL_RM_ROUTE_UTIL.validate_route_status

2265: RAISE FND_API.G_EXC_ERROR;
2266: END IF;
2267: CLOSE get_efct_rec;
2268: -- Check if the Route is existing and in Draft status
2269: AHL_RM_ROUTE_UTIL.validate_route_status
2270: (
2271: l_dummy_number,
2272: l_msg_data,
2273: l_return_status

Line 2294: AHL_RM_ROUTE_UTIL.validate_route_status

2290: CLOSE get_route_status;
2291: ELSIF ( p_association_type = 'ROUTE' )
2292: THEN
2293: -- Check if the Route is existing and in Draft status
2294: AHL_RM_ROUTE_UTIL.validate_route_status
2295: (
2296: p_object_id,
2297: l_msg_data,
2298: l_return_status

Line 2694: AHL_RM_ROUTE_UTIL.validate_ApplnUsage

2690: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
2691: END IF;
2692: --This is to be added before calling validate_api_inputs
2693: -- Validate Application Usage
2694: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
2695: (
2696: p_object_id => p_object_id,
2697: p_association_type => 'ROUTE',
2698: x_return_status => x_return_status,

Line 2810: AHL_RM_ROUTE_UTIL.validate_route_status

2806: IF G_DEBUG='Y' THEN
2807: AHL_DEBUG_PUB.debug( 'p_association_type = ROUTE');
2808: END IF;
2809: -- Check if the Route is existing and in Draft status
2810: AHL_RM_ROUTE_UTIL.validate_route_status
2811: (
2812: p_object_id,
2813: l_msg_data,
2814: l_return_status