[Home] [Help]
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: -- procedure params
21: p_x_route_rec IN OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,
22: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
23: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
24: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
25: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
70: fnd_log.string
71: (
72: fnd_log.level_statement,
73: l_debug_module ,
74: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'
75: );
76:
77: END IF;
78:
79: -- PRITHWI: discuss with Shailaja whether to default to 'C' or to throw error if there is no Defaul
80: IF p_x_route_rec.DML_OPERATION = 'C'
81: THEN
82:
83: AHL_RM_ROUTE_PVT.process_route
84: (
85: p_api_version => 1.0,
86: p_init_msg_list => FND_API.G_FALSE,
87: p_commit => FND_API.G_FALSE,
93: x_msg_data => x_msg_data,
94: p_x_route_rec => p_x_route_rec
95: );
96:
97: -- to raise errors from AHL_RM_ROUTE_PVT.process_ROUTE
98: x_msg_count := FND_MSG_PUB.count_msg;
99:
100: IF x_msg_count > 0 THEN
101: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452: x_return_status OUT NOCOPY VARCHAR2,
453: x_msg_count OUT NOCOPY NUMBER,
454: x_msg_data OUT NOCOPY VARCHAR2,
455: -- procedure params
456: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,
457: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
458: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
459: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
460: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
464: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_ROUTE';
465: l_api_version CONSTANT NUMBER := 1.0;
466: l_debug_module CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name||'.'||l_api_name;
467: l_route_id NUMBER;
468: l_route_rec AHL_RM_ROUTE_PVT.route_rec_type;
469: l_x_rt_oper_cost_rec AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_cost_rec_type;
470:
471: BEGIN
472:
508: fnd_log.string
509: (
510: fnd_log.level_statement,
511: l_debug_module ,
512: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'
513: );
514:
515: END IF;
516:
555: -- no check on OBJ VER NO as PVT already does it.
556: IF p_route_rec.DML_OPERATION = 'U'
557: THEN
558: l_route_rec := p_route_rec ;
559: AHL_RM_ROUTE_PVT.process_route
560: (
561: p_api_version => 1.0,
562: p_init_msg_list => FND_API.G_FALSE,
563: p_commit => FND_API.G_FALSE,
568: x_msg_count => x_msg_count,
569: x_msg_data => x_msg_data,
570: p_x_route_rec => l_route_rec
571: );
572: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
573: x_msg_count := FND_MSG_PUB.count_msg;
574:
575: IF x_msg_count > 0 THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: fnd_log.string
936: (
937: fnd_log.level_statement,
938: l_debug_module ,
939: 'Before calling the private API AHL_RM_ROUTE_PVT.delete_route.....'
940: );
941:
942: END IF;
943:
977:
978: END IF;
979:
980:
981: AHL_RM_ROUTE_PVT.delete_route
982: (
983: p_api_version => 1.0,
984: p_init_msg_list => FND_API.G_FALSE,
985: p_commit => FND_API.G_FALSE,
991: x_msg_data => x_msg_data,
992: p_route_id => l_route_id,
993: p_object_version_number => p_route_object_version
994: );
995: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
996: x_msg_count := FND_MSG_PUB.count_msg;
997:
998: IF x_msg_count > 0 THEN
999: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390: );
1391: END IF;
1392:
1393: -- Call the corresponding private API
1394: AHL_RM_ROUTE_PVT.create_route_revision
1395: (
1396: p_api_version => 1.0,
1397: p_init_msg_list => FND_API.G_FALSE,
1398: p_commit => FND_API.G_FALSE,