APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on EAM_PROCESS_WO_PVT

Line 943: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('workorder status'||l_wo_status); END IF;

939: l_user_defined_status := l_wo_status;
940: l_pending_flag := null;
941: END;
942:
943: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('workorder status'||l_wo_status); END IF;
944:
945: BEGIN
946: SELECT wdj.status_type
947: INTO l_parent_status

Line 956: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('inside parent status validation :parent status'||l_parent_status); END IF;

952: and wdj.wip_entity_id = wsr.parent_object_id;
953:
954:
955:
956: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('inside parent status validation :parent status'||l_parent_status); END IF;
957:
958: IF( ((l_parent_status=17) and (l_wo_status NOT IN (17,7,6)))
959: OR ((l_parent_status=1) and (l_wo_status NOT IN (17,7,1,6)))
960: OR ((l_parent_status IN (3,6)) and (l_wo_status NOT IN (3,6,17,7,1,12,14,15,4,5)))

Line 968: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after parent status validation :'||x_return_status); END IF;

964: OR ((l_parent_status NOT IN (3,6))and (l_user_defined_status IN(3) and l_pending_flag='Y'))
965: ) THEN
966: x_return_status:=FND_API.G_RET_STS_ERROR;
967: END IF;
968: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after parent status validation :'||x_return_status); END IF;
969:
970: EXCEPTION
971: WHEN NO_DATA_FOUND THEN
972: null;

Line 1033: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after child status validation :'||x_return_status); END IF;

1029: IF(l_invalid_child<>0) THEN
1030: x_return_status:=FND_API.G_RET_STS_ERROR;
1031: END IF;
1032:
1033: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('after child status validation :'||x_return_status); END IF;
1034: END Validate_Status;
1035:
1036: -- Added for Detailed Scheduling.Validates the status of entire hierarchy
1037: PROCEDURE Validate_Network_Status

Line 1167: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN

1163: p_wo_relationship_exc_tbl => p_wo_relationship_exc_tbl
1164: );
1165: END LOOP;
1166:
1167: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN
1168: IF p_wo_relationship_exc_tbl.count >0 THEN
1169: x_return_status:=FND_API.G_RET_STS_ERROR;
1170: END IF;
1171: EAM_ERROR_MESSAGE_PVT.Write_Debug('after Validate_Network_Status status validation :'||x_return_status);