DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PVT dependencies on AHL_RM_ROUTE_UTIL

Line 154: AHL_RM_ROUTE_UTIL.validate_lookup

150: p_x_route_rec.route_type_code <> FND_API.G_MISS_CHAR ) OR
151: ( p_x_route_rec.route_type IS NOT NULL AND
152: p_x_route_rec.route_type <> FND_API.G_MISS_CHAR ) ) THEN
153:
154: AHL_RM_ROUTE_UTIL.validate_lookup
155: (
156: x_return_status => l_return_status,
157: x_msg_data => l_msg_data,
158: p_lookup_type => 'AHL_ROUTE_TYPE',

Line 191: AHL_RM_ROUTE_UTIL.validate_lookup

187: p_x_route_rec.model_code <> FND_API.G_MISS_CHAR ) OR
188: ( p_x_route_rec.model_meaning IS NOT NULL AND
189: p_x_route_rec.model_meaning <> FND_API.G_MISS_CHAR ) ) THEN
190:
191: AHL_RM_ROUTE_UTIL.validate_lookup
192: (
193: x_return_status => l_return_status,
194: x_msg_data => l_msg_data,
195: p_lookup_type => 'AHL_ENIGMA_MODEL_CODE',

Line 228: AHL_RM_ROUTE_UTIL.validate_lookup

224: p_x_route_rec.process_code <> FND_API.G_MISS_CHAR ) OR
225: ( p_x_route_rec.process IS NOT NULL AND
226: p_x_route_rec.process <> FND_API.G_MISS_CHAR ) ) THEN
227:
228: AHL_RM_ROUTE_UTIL.validate_lookup
229: (
230: x_return_status => l_return_status,
231: x_msg_data => l_msg_data,
232: p_lookup_type => 'AHL_PROCESS_CODE',

Line 264: AHL_RM_ROUTE_UTIL.validate_lookup

260: p_x_route_rec.product_type_code <> FND_API.G_MISS_CHAR ) OR
261: ( p_x_route_rec.product_type IS NOT NULL AND
262: p_x_route_rec.product_type <> FND_API.G_MISS_CHAR ) ) THEN
263:
264: AHL_RM_ROUTE_UTIL.validate_lookup
265: (
266: x_return_status => l_return_status,
267: x_msg_data => l_msg_data,
268: p_lookup_type => 'ITEM_TYPE',

Line 300: AHL_RM_ROUTE_UTIL.validate_operator

296: p_x_route_rec.operator_name <> FND_API.G_MISS_CHAR ) OR
297: ( p_x_route_rec.operator_party_id IS NOT NULL AND
298: p_x_route_rec.operator_party_id <> FND_API.G_MISS_NUM ) ) THEN
299:
300: AHL_RM_ROUTE_UTIL.validate_operator
301: (
302: x_return_status => l_return_status,
303: x_msg_data => l_msg_data,
304: p_operator_name => p_x_route_rec.operator_name,

Line 329: AHL_RM_ROUTE_UTIL.validate_lookup

325: p_x_route_rec.zone_code <> FND_API.G_MISS_CHAR ) OR
326: ( p_x_route_rec.zone IS NOT NULL AND
327: p_x_route_rec.zone <> FND_API.G_MISS_CHAR ) ) THEN
328:
329: AHL_RM_ROUTE_UTIL.validate_lookup
330: (
331: x_return_status => l_return_status,
332: x_msg_data => l_msg_data,
333: p_lookup_type => 'AHL_ZONE',

Line 365: AHL_RM_ROUTE_UTIL.validate_lookup

361: p_x_route_rec.sub_zone_code <> FND_API.G_MISS_CHAR ) OR
362: ( p_x_route_rec.sub_zone IS NOT NULL AND
363: p_x_route_rec.sub_zone <> FND_API.G_MISS_CHAR ) ) THEN
364:
365: AHL_RM_ROUTE_UTIL.validate_lookup
366: (
367: x_return_status => l_return_status,
368: x_msg_data => l_msg_data,
369: p_lookup_type => 'AHL_SUB_ZONE',

Line 403: AHL_RM_ROUTE_UTIL.validate_service_item

399: p_x_route_rec.service_item_id <> FND_API.G_MISS_NUM AND
400: p_x_route_rec.service_item_org_id IS NOT NULL AND
401: p_x_route_rec.service_item_org_id <> FND_API.G_MISS_NUM ) ) THEN
402:
403: AHL_RM_ROUTE_UTIL.validate_service_item
404: (
405: x_return_status => l_return_status,
406: x_msg_data => l_msg_data,
407: p_item_number => p_x_route_rec.service_item_number,

Line 435: AHL_RM_ROUTE_UTIL.validate_accounting_class

431: p_x_route_rec.accounting_class_org_id <> FND_API.G_MISS_NUM ) OR
432: ( p_x_route_rec.accounting_class IS NOT NULL AND
433: p_x_route_rec.accounting_class <> FND_API.G_MISS_CHAR ) ) THEN
434:
435: AHL_RM_ROUTE_UTIL.validate_accounting_class
436: (
437: x_return_status => l_return_status,
438: x_msg_data => l_msg_data,
439: p_accounting_class => p_x_route_rec.accounting_class,

Line 465: AHL_RM_ROUTE_UTIL.validate_task_template_group

461: p_x_route_rec.task_template_group <> FND_API.G_MISS_CHAR ) OR
462: ( p_x_route_rec.task_template_group_id IS NOT NULL AND
463: p_x_route_rec.task_template_group_id <> FND_API.G_MISS_NUM ) ) THEN
464:
465: AHL_RM_ROUTE_UTIL.validate_task_template_group
466: (
467: x_return_status => l_return_status,
468: x_msg_data => l_msg_data,
469: p_task_template_group => p_x_route_rec.task_template_group,

Line 494: AHL_RM_ROUTE_UTIL.validate_qa_inspection_type

490: p_x_route_rec.qa_inspection_type_desc <> FND_API.G_MISS_CHAR ) OR
491: ( p_x_route_rec.qa_inspection_type IS NOT NULL AND
492: p_x_route_rec.qa_inspection_type <> FND_API.G_MISS_CHAR ) ) THEN
493:
494: AHL_RM_ROUTE_UTIL.validate_qa_inspection_type
495: (
496: x_return_status => l_return_status,
497: x_msg_data => l_msg_data,
498: p_qa_inspection_type_desc => p_x_route_rec.qa_inspection_type_desc,

Line 523: AHL_RM_ROUTE_UTIL.validate_lookup

519: p_x_route_rec.revision_status_code <> FND_API.G_MISS_CHAR ) OR
520: ( p_x_route_rec.revision_status IS NOT NULL AND
521: p_x_route_rec.revision_status <> FND_API.G_MISS_CHAR ) ) THEN
522:
523: AHL_RM_ROUTE_UTIL.validate_lookup
524: (
525: x_return_status => l_return_status,
526: x_msg_data => l_msg_data,
527: p_lookup_type => 'AHL_REVISION_STATUS',

Line 560: AHL_RM_ROUTE_UTIL.validate_lookup

556: p_x_route_rec.unit_receipt_update_flag <> FND_API.G_MISS_CHAR ) OR
557: ( p_x_route_rec.unit_receipt_update IS NOT NULL AND
558: p_x_route_rec.unit_receipt_update <> FND_API.G_MISS_CHAR ) ) THEN
559:
560: AHL_RM_ROUTE_UTIL.validate_lookup
561: (
562: x_return_status => l_return_status,
563: x_msg_data => l_msg_data,
564: p_lookup_type => 'AHL_YES_NO_TYPE',

Line 1731: AHL_RM_ROUTE_UTIL.validate_route_time_span

1727: IF ( p_route_rec.time_span IS NOT NULL AND
1728: p_route_rec.time_span <> FND_API.G_MISS_NUM AND
1729: p_route_rec.time_span > 0 ) THEN
1730:
1731: AHL_RM_ROUTE_UTIL.validate_route_time_span
1732: (
1733: x_return_status => l_return_status,
1734: x_msg_data => l_msg_data,
1735: p_route_id => p_route_rec.route_id,

Line 1837: AHL_RM_ROUTE_UTIL.validate_rt_oper_start_date

1833: p_route_rec.revision_status_code = 'APPROVAL_REJECTED' ) AND
1834: p_route_rec.route_id IS NOT NULL AND
1835: p_route_rec.active_start_date IS NOT NULL ) THEN
1836:
1837: AHL_RM_ROUTE_UTIL.validate_rt_oper_start_date
1838: (
1839: x_return_status => l_return_status,
1840: x_msg_data => l_msg_data,
1841: p_association_type => 'ROUTE',

Line 1881: AHL_RM_ROUTE_UTIL.validate_pt_zone

1877: -- Check if the Zone is valid for the Product Type
1878: IF ( p_route_rec.product_type_code IS NOT NULL AND
1879: p_route_rec.zone_code IS NOT NULL ) THEN
1880:
1881: AHL_RM_ROUTE_UTIL.validate_pt_zone
1882: (
1883: x_return_status => l_return_status,
1884: x_msg_data => l_msg_data,
1885: p_product_type_code => p_route_rec.product_type_code,

Line 1913: AHL_RM_ROUTE_UTIL.validate_pt_zone_subzone

1909: IF ( p_route_rec.product_type_code IS NOT NULL AND
1910: p_route_rec.zone_code IS NOT NULL AND
1911: p_route_rec.sub_zone_code IS NOT NULL ) THEN
1912:
1913: AHL_RM_ROUTE_UTIL.validate_pt_zone_subzone
1914: (
1915: x_return_status => l_return_status,
1916: x_msg_data => l_msg_data,
1917: p_product_type_code => p_route_rec.product_type_code,

Line 2031: AHL_RM_ROUTE_UTIL.Route_Number_To_Id(

2027: IF (p_x_route_rec.dml_operation <> 'C' AND p_x_route_rec.dml_operation <> 'c') AND
2028: (p_x_route_rec.route_id IS NULL OR p_x_route_rec.route_id = FND_API.G_MISS_NUM)
2029: THEN
2030: -- Function to convert route_number, route_revision to id
2031: AHL_RM_ROUTE_UTIL.Route_Number_To_Id(
2032: p_route_number => p_x_route_rec.route_no,
2033: p_route_revision => p_x_route_rec.revision_number,
2034: x_route_id => p_x_route_rec.route_id,
2035: x_return_status => x_return_status

Line 2055: AHL_RM_ROUTE_UTIL.validate_ApplnUsage

2051: --This is to be added before calling validate_api_inputs
2052: IF ( p_x_route_rec.dml_operation = 'U' )
2053: THEN
2054: -- Validate Application Usage
2055: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
2056: (
2057: p_object_id => p_x_route_rec.route_id,
2058: p_association_type => 'ROUTE',
2059: x_return_status => x_return_status,

Line 2596: --This is to be added before calling AHL_RM_ROUTE_UTIL.validate_route_status

2592: IF G_DEBUG = 'Y' THEN
2593: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2594: END IF;
2595:
2596: --This is to be added before calling AHL_RM_ROUTE_UTIL.validate_route_status
2597: -- Validate Application Usage
2598: AHL_RM_ROUTE_UTIL .validate_ApplnUsage
2599: (
2600: p_object_id => p_route_id,

Line 2598: AHL_RM_ROUTE_UTIL .validate_ApplnUsage

2594: END IF;
2595:
2596: --This is to be added before calling AHL_RM_ROUTE_UTIL.validate_route_status
2597: -- Validate Application Usage
2598: AHL_RM_ROUTE_UTIL .validate_ApplnUsage
2599: (
2600: p_object_id => p_route_id,
2601: p_association_type => 'ROUTE',
2602: x_return_status => x_return_status,

Line 2650: AHL_RM_ROUTE_UTIL.validate_route_status

2646: END IF;
2647: END IF;
2648: --bachandr Enigma Phase I changes -- end
2649:
2650: AHL_RM_ROUTE_UTIL.validate_route_status
2651: (
2652: p_route_id => p_route_id,
2653: x_msg_data => l_msg_data,
2654: x_return_status => l_return_status

Line 3028: AHL_RM_ROUTE_UTIL .validate_ApplnUsage

3024: END IF;
3025:
3026: --This is to be added before calling get_route_record()
3027: -- Validate Application Usage
3028: AHL_RM_ROUTE_UTIL .validate_ApplnUsage
3029: (
3030: p_object_id => p_route_id,
3031: p_association_type => 'ROUTE',
3032: x_return_status => x_return_status,