DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_RM_ROUTE_UTIL

Line 79: AHL_RM_ROUTE_UTIL.validate_operation_status

75: END IF;
76:
77: -- Check if a valid value is passed in p_object_id
78: IF (p_association_type_code = 'OPERATION') THEN
79: AHL_RM_ROUTE_UTIL.validate_operation_status
80: (
81: p_operation_id => p_object_id,
82: x_return_status => l_return_status,
83: x_msg_data => l_msg_data

Line 92: AHL_RM_ROUTE_UTIL.validate_route_status

88: x_return_status := FND_API.G_RET_STS_ERROR;
89: RETURN;
90: END IF;
91: ELSIF (p_association_type_code = 'ROUTE') THEN
92: AHL_RM_ROUTE_UTIL.validate_route_status
93: (
94: p_route_id => p_object_id,
95: x_return_status => l_return_status,
96: x_msg_data => l_msg_data

Line 178: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

174: p_x_rt_oper_resource_rec.resource_type_id <> FND_API.G_MISS_NUM ) OR
175: ( p_x_rt_oper_resource_rec.resource_type IS NOT NULL AND
176: p_x_rt_oper_resource_rec.resource_type <> FND_API.G_MISS_CHAR ) ) THEN
177:
178: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
179: (
180: x_return_status => l_return_status,
181: x_msg_data => l_msg_data,
182: p_lookup_type => 'BOM_RESOURCE_TYPE',

Line 216: AHL_RM_ROUTE_UTIL.validate_aso_resource

212: ( p_x_rt_oper_resource_rec.aso_resource_name IS NOT NULL AND
213: p_x_rt_oper_resource_rec.aso_resource_name <> FND_API.G_MISS_CHAR ) )
214: THEN
215:
216: AHL_RM_ROUTE_UTIL.validate_aso_resource
217: (
218: x_return_status => l_return_status,
219: x_msg_data => l_msg_data,
220: p_aso_resource_name => p_x_rt_oper_resource_rec.aso_resource_name,

Line 248: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

244: ( p_x_rt_oper_resource_rec.scheduled_type IS NOT NULL AND
245: p_x_rt_oper_resource_rec.scheduled_type <> FND_API.G_MISS_CHAR ) )
246: THEN
247:
248: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
249: (
250: x_return_status => l_return_status,
251: x_msg_data => l_msg_data,
252: p_lookup_type => 'BOM_RESOURCE_SCHEDULE_TYPE',

Line 797: AHL_RM_ROUTE_UTIL.validate_resource_duration

793: IF ( p_rt_oper_resource_rec.duration IS NOT NULL AND
794: p_rt_oper_resource_rec.duration <> FND_API.G_MISS_NUM AND
795: p_rt_oper_resource_rec.duration > 0 ) THEN
796:
797: AHL_RM_ROUTE_UTIL.validate_resource_duration
798: (
799: x_return_status => l_return_status,
800: x_msg_data => l_msg_data,
801: p_object_id => p_object_id,

Line 956: AHL_RM_ROUTE_UTIL.validate_resource_duration

952: p_rt_oper_resource_rec.resource_type_id IN (1,2) ) AND
953: ( p_rt_oper_resource_rec.scheduled_type_id = 1 )
954: THEN
955:
956: AHL_RM_ROUTE_UTIL.validate_resource_duration
957: (
958: x_return_status => l_return_status,
959: x_msg_data => l_msg_data,
960: p_object_id => p_object_id,

Line 1256: AHL_RM_ROUTE_UTIL.validate_ApplnUsage

1252: --This is to be added before calling validate_api_inputs()
1253: -- Validate Application Usage
1254: IF (p_association_type_code = 'ROUTE')
1255: THEN
1256: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
1257: (
1258: p_object_id => p_object_id,
1259: p_association_type => p_association_type_code ,
1260: x_return_status => x_return_status,

Line 1425: AHL_RM_ROUTE_UTIL.validate_operation_status

1421: IF G_DEBUG='Y' THEN
1422: AHL_DEBUG_PUB.debug( 'p_association_type_code = OPERATION');
1423: END IF;
1424:
1425: AHL_RM_ROUTE_UTIL.validate_operation_status
1426: (
1427: p_object_id,
1428: l_msg_data,
1429: l_return_status

Line 1456: AHL_RM_ROUTE_UTIL.validate_route_status

1452: IF G_DEBUG='Y' THEN
1453: AHL_DEBUG_PUB.debug( 'p_association_type_code = ROUTE');
1454: END IF;
1455: -- Check if the Route is existing and in Draft status
1456: AHL_RM_ROUTE_UTIL.validate_route_status
1457: (
1458: p_object_id,
1459: l_msg_data,
1460: l_return_status

Line 1811: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1807: p_x_rt_oper_cost_rec.cost_basis_id <> FND_API.G_MISS_NUM ) OR
1808: ( p_x_rt_oper_cost_rec.cost_basis IS NOT NULL AND
1809: p_x_rt_oper_cost_rec.cost_basis <> FND_API.G_MISS_CHAR ) ) THEN
1810:
1811: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1812: (
1813: x_return_status => l_return_status,
1814: x_msg_data => l_msg_data,
1815: p_lookup_type => 'CST_BASIS',

Line 1848: AHL_RM_ROUTE_UTIL.validate_activity

1844: ( p_x_rt_oper_cost_rec.activity IS NOT NULL AND
1845: p_x_rt_oper_cost_rec.activity <> FND_API.G_MISS_CHAR ) )
1846: THEN
1847:
1848: AHL_RM_ROUTE_UTIL.validate_activity
1849: (
1850: x_return_status => l_return_status,
1851: x_msg_data => l_msg_data,
1852: p_activity => p_x_rt_oper_cost_rec.activity,

Line 1878: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1874: ( p_x_rt_oper_cost_rec.scheduled_type IS NOT NULL AND
1875: p_x_rt_oper_cost_rec.scheduled_type <> FND_API.G_MISS_CHAR ) )
1876: THEN
1877:
1878: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1879: (
1880: x_return_status => l_return_status,
1881: x_msg_data => l_msg_data,
1882: p_lookup_type => 'BOM_RESOURCE_SCHEDULE_TYPE',

Line 1915: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1911: ( p_x_rt_oper_cost_rec.autocharge_type IS NOT NULL AND
1912: p_x_rt_oper_cost_rec.autocharge_type <> FND_API.G_MISS_CHAR ) )
1913: THEN
1914:
1915: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1916: (
1917: x_return_status => l_return_status,
1918: x_msg_data => l_msg_data,
1919: p_lookup_type => 'BOM_AUTOCHARGE_TYPE',

Line 1952: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1948: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1949: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1950: THEN
1951:
1952: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1953: (
1954: x_return_status => l_return_status,
1955: x_msg_data => l_msg_data,
1956: p_lookup_type => 'SYS_YES_NO',

Line 2246: AHL_RM_ROUTE_UTIL.validate_resource_duration

2242: END IF; -- p_x_rt_oper_cost_rec.scheduled_type_id = 1
2243: */
2244: -- validate time span based on scheduled_type_id.
2245: IF (p_x_rt_oper_cost_rec.scheduled_type_id = 1 AND l_resource_type_id IN (1,2)) THEN
2246: AHL_RM_ROUTE_UTIL.validate_resource_duration
2247: (
2248: x_return_status => l_return_status,
2249: x_msg_data => l_msg_data,
2250: p_object_id => l_object_id,

Line 2317: AHL_RM_ROUTE_UTIL.validate_operation_status

2313: AHL_DEBUG_PUB.debug( 'l_association_type_code = OPERATION');
2314: END IF;
2315:
2316: -- Check if the Route is existing and in Draft status
2317: AHL_RM_ROUTE_UTIL.validate_operation_status
2318: (
2319: l_object_id,
2320: l_msg_data,
2321: l_return_status

Line 2349: AHL_RM_ROUTE_UTIL.validate_ApplnUsage

2345: IF G_DEBUG='Y' THEN
2346: AHL_DEBUG_PUB.debug( 'l_association_type_code = ROUTE');
2347: END IF;
2348:
2349: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
2350: (
2351: p_object_id => l_object_id,
2352: p_association_type => l_association_type_code ,
2353: x_return_status => x_return_status,

Line 2365: AHL_RM_ROUTE_UTIL.validate_route_status

2361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2362: END IF ;
2363:
2364: -- Check if the Route is existing and in Draft status
2365: AHL_RM_ROUTE_UTIL.validate_route_status
2366: (
2367: l_object_id,
2368: l_msg_data,
2369: l_return_status

Line 2598: AHL_RM_ROUTE_UTIL.validate_aso_resource

2594: ( p_x_alt_resource_rec.aso_resource_name IS NOT NULL AND
2595: p_x_alt_resource_rec.aso_resource_name <> FND_API.G_MISS_CHAR ) )
2596: THEN
2597:
2598: AHL_RM_ROUTE_UTIL.validate_aso_resource
2599: (
2600: x_return_status => l_return_status,
2601: x_msg_data => l_msg_data,
2602: p_aso_resource_name => p_x_alt_resource_rec.aso_resource_name,