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 1214: AHL_RM_ROUTE_UTIL.validate_ApplnUsage

1210: --This is to be added before calling validate_api_inputs()
1211: -- Validate Application Usage
1212: IF (p_association_type_code = 'ROUTE')
1213: THEN
1214: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
1215: (
1216: p_object_id => p_object_id,
1217: p_association_type => p_association_type_code ,
1218: x_return_status => x_return_status,

Line 1383: AHL_RM_ROUTE_UTIL.validate_operation_status

1379: IF G_DEBUG='Y' THEN
1380: AHL_DEBUG_PUB.debug( 'p_association_type_code = OPERATION');
1381: END IF;
1382:
1383: AHL_RM_ROUTE_UTIL.validate_operation_status
1384: (
1385: p_object_id,
1386: l_msg_data,
1387: l_return_status

Line 1414: AHL_RM_ROUTE_UTIL.validate_route_status

1410: IF G_DEBUG='Y' THEN
1411: AHL_DEBUG_PUB.debug( 'p_association_type_code = ROUTE');
1412: END IF;
1413: -- Check if the Route is existing and in Draft status
1414: AHL_RM_ROUTE_UTIL.validate_route_status
1415: (
1416: p_object_id,
1417: l_msg_data,
1418: l_return_status

Line 1769: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1765: p_x_rt_oper_cost_rec.cost_basis_id <> FND_API.G_MISS_NUM ) OR
1766: ( p_x_rt_oper_cost_rec.cost_basis IS NOT NULL AND
1767: p_x_rt_oper_cost_rec.cost_basis <> FND_API.G_MISS_CHAR ) ) THEN
1768:
1769: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1770: (
1771: x_return_status => l_return_status,
1772: x_msg_data => l_msg_data,
1773: p_lookup_type => 'CST_BASIS',

Line 1806: AHL_RM_ROUTE_UTIL.validate_activity

1802: ( p_x_rt_oper_cost_rec.activity IS NOT NULL AND
1803: p_x_rt_oper_cost_rec.activity <> FND_API.G_MISS_CHAR ) )
1804: THEN
1805:
1806: AHL_RM_ROUTE_UTIL.validate_activity
1807: (
1808: x_return_status => l_return_status,
1809: x_msg_data => l_msg_data,
1810: p_activity => p_x_rt_oper_cost_rec.activity,

Line 1836: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1832: ( p_x_rt_oper_cost_rec.scheduled_type IS NOT NULL AND
1833: p_x_rt_oper_cost_rec.scheduled_type <> FND_API.G_MISS_CHAR ) )
1834: THEN
1835:
1836: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1837: (
1838: x_return_status => l_return_status,
1839: x_msg_data => l_msg_data,
1840: p_lookup_type => 'BOM_RESOURCE_SCHEDULE_TYPE',

Line 1873: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1869: ( p_x_rt_oper_cost_rec.autocharge_type IS NOT NULL AND
1870: p_x_rt_oper_cost_rec.autocharge_type <> FND_API.G_MISS_CHAR ) )
1871: THEN
1872:
1873: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1874: (
1875: x_return_status => l_return_status,
1876: x_msg_data => l_msg_data,
1877: p_lookup_type => 'BOM_AUTOCHARGE_TYPE',

Line 1910: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

1906: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1907: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1908: THEN
1909:
1910: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1911: (
1912: x_return_status => l_return_status,
1913: x_msg_data => l_msg_data,
1914: p_lookup_type => 'SYS_YES_NO',

Line 2204: AHL_RM_ROUTE_UTIL.validate_resource_duration

2200: END IF; -- p_x_rt_oper_cost_rec.scheduled_type_id = 1
2201: */
2202: -- validate time span based on scheduled_type_id.
2203: IF (p_x_rt_oper_cost_rec.scheduled_type_id = 1 AND l_resource_type_id IN (1,2)) THEN
2204: AHL_RM_ROUTE_UTIL.validate_resource_duration
2205: (
2206: x_return_status => l_return_status,
2207: x_msg_data => l_msg_data,
2208: p_object_id => l_object_id,

Line 2275: AHL_RM_ROUTE_UTIL.validate_operation_status

2271: AHL_DEBUG_PUB.debug( 'l_association_type_code = OPERATION');
2272: END IF;
2273:
2274: -- Check if the Route is existing and in Draft status
2275: AHL_RM_ROUTE_UTIL.validate_operation_status
2276: (
2277: l_object_id,
2278: l_msg_data,
2279: l_return_status

Line 2307: AHL_RM_ROUTE_UTIL.validate_ApplnUsage

2303: IF G_DEBUG='Y' THEN
2304: AHL_DEBUG_PUB.debug( 'l_association_type_code = ROUTE');
2305: END IF;
2306:
2307: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
2308: (
2309: p_object_id => l_object_id,
2310: p_association_type => l_association_type_code ,
2311: x_return_status => x_return_status,

Line 2323: AHL_RM_ROUTE_UTIL.validate_route_status

2319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2320: END IF ;
2321:
2322: -- Check if the Route is existing and in Draft status
2323: AHL_RM_ROUTE_UTIL.validate_route_status
2324: (
2325: l_object_id,
2326: l_msg_data,
2327: l_return_status

Line 2556: AHL_RM_ROUTE_UTIL.validate_aso_resource

2552: ( p_x_alt_resource_rec.aso_resource_name IS NOT NULL AND
2553: p_x_alt_resource_rec.aso_resource_name <> FND_API.G_MISS_CHAR ) )
2554: THEN
2555:
2556: AHL_RM_ROUTE_UTIL.validate_aso_resource
2557: (
2558: x_return_status => l_return_status,
2559: x_msg_data => l_msg_data,
2560: p_aso_resource_name => p_x_alt_resource_rec.aso_resource_name,