16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2,
19: -- procedure params
20: p_x_oper_rec IN OUT NOCOPY AHL_RM_OPERATION_PVT.operation_rec_type,
21: p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
22: p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
23: p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
24: p_x_oper_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
68: fnd_log.string
69: (
70: fnd_log.level_statement,
71: l_debug_module ,
72: 'Before calling the private API AHL_RM_OPERATION_PVT.process_operation.....'
73: );
74:
75: END IF;
76:
77: -- PRITHWI: discuss with Shailaja whether to default to 'C' or to throw error if there is no Defaul
78: IF p_x_oper_rec.DML_OPERATION = 'C'
79: THEN
80:
81: AHL_RM_OPERATION_PVT.process_operation
82: (
83: p_api_version => 1.0,
84: p_init_msg_list => FND_API.G_FALSE,
85: p_commit => FND_API.G_FALSE,
91: x_msg_data => x_msg_data,
92: p_x_operation_rec => p_x_oper_rec
93: );
94:
95: -- to raise errors from AHL_RM_OPERATION_PVT.process_operation
96: x_msg_count := FND_MSG_PUB.count_msg;
97:
98: IF x_msg_count > 0 THEN
99: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: -- procedure params
416: p_x_oper_rec IN OUT NOCOPY AHL_RM_OPERATION_PVT.operation_rec_type,
417: p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
418: p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
419: p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
420: )
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,
501: -- procedure params
502: p_oper_rec IN AHL_RM_OPERATION_PVT.operation_rec_type,
503: p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
504: p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
505: p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
506: p_x_oper_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
509: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_OPERATION';
510: l_api_version CONSTANT NUMBER := 2.0;
511: l_debug_module CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name||'.'||l_api_name;
512: l_oper_id NUMBER;
513: l_oper_rec AHL_RM_OPERATION_PVT.operation_rec_type;
514: l_x_rt_oper_cost_rec AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_cost_rec_type;
515:
516: BEGIN
517:
552: fnd_log.string
553: (
554: fnd_log.level_statement,
555: l_debug_module,
556: 'Before calling the private API AHL_RM_OPERATION_PVT.process_operation.....'
557: );
558:
559: END IF;
560:
605: THEN
606:
607: l_oper_rec := p_oper_rec;
608:
609: AHL_RM_OPERATION_PVT.process_operation
610: (
611: p_api_version => 1.0,
612: p_init_msg_list => FND_API.G_FALSE,
613: p_commit => FND_API.G_FALSE,
618: x_msg_count => x_msg_count,
619: x_msg_data => x_msg_data,
620: p_x_operation_rec => l_oper_rec
621: );
622: -- to raise errors from AHL_RM_OPERATION_PVT.process_operation
623: x_msg_count := FND_MSG_PUB.count_msg;
624:
625:
626: IF x_msg_count > 0 THEN
988: x_return_status OUT NOCOPY VARCHAR2,
989: x_msg_count OUT NOCOPY NUMBER,
990: x_msg_data OUT NOCOPY VARCHAR2,
991: -- procedure params
992: p_oper_rec IN AHL_RM_OPERATION_PVT.operation_rec_type,
993: p_x_oper_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
994: p_x_oper_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
995: p_x_oper_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
996: )
1125: fnd_log.string
1126: (
1127: fnd_log.level_statement,
1128: l_debug_module,
1129: 'Before calling the private API AHL_RM_OPERATION_PVT.delete_operation.....'
1130: );
1131:
1132: END IF;
1133:
1169:
1170: END IF;
1171:
1172:
1173: AHL_RM_OPERATION_PVT.delete_operation
1174: (
1175: p_api_version => 1.0,
1176: p_init_msg_list => FND_API.G_FALSE,
1177: p_commit => FND_API.G_FALSE,
1183: x_msg_data => x_msg_data,
1184: p_operation_id => l_oper_id ,
1185: p_object_version_number => p_oper_object_version
1186: );
1187: -- to raise errors from AHL_RM_OPERATION_PVT.process_operation
1188: x_msg_count := FND_MSG_PUB.count_msg;
1189:
1190: IF x_msg_count > 0 THEN
1191: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615:
1616: -- Call the private API
1617:
1618:
1619: AHL_RM_OPERATION_PVT.create_oper_revision
1620: (
1621: p_api_version => 1.0,
1622: p_init_msg_list => FND_API.G_FALSE,
1623: p_commit => FND_API.G_FALSE,